P.O. Number
| Terms
| Est. Delivery
| Project
|
| | | |
|
Item Code
| Description
| Quantity
| Price
| Amount
|
mysql_select_db('ecosmar_inv', $dbcnx);
$prod_inv = @mysql_query("SELECT ID,invnum,prod_name,prod_desc,prod_qty,prod_price FROM inv_prod WHERE invnum='$invnum'");
if (!prod_inv) {
echo('Error retrieving Product Data. ' . 'Error: '. mysql_error(). ' ');
}
while($rowp = mysql_fetch_array($prod_inv)){
$PID[] = $rowp['ID'];
$prod_name[] = $rowp['prod_name'];
$prod_desc[] = $rowp['prod_desc'];
$prod_qty[] = $rowp['prod_qty'];
$prod_price[] = $rowp['prod_price'];
}//while
$p = 1;
$i = 0;
$prodcount = count($PID);
$pagecount = ceil($prodcount / 10);
while($i < $prodcount){
$amount1 = $prod_qty[$i] * $prod_price[$i];
$amount = sprintf("%01.2f", $amount1);
echo("$prod_name[$i] | $prod_desc[$i]" .
" | $prod_qty[$i]" .
" | $prod_price[$i] | $amount" .
" | ");
$i = $i + 1;
if($i == 9){
$i = 0;
$p = $p + 1;
echo("ECO-$MART Invoice: $inv_num $datus Page 1 of $pagecount | " .
" " .
" " .
"" .
" " .
" | Eco-$mart, Inc. " .
"1-888-732-2798 info@eco-smart.com" .
" | Page $p of $pagecount" .
" Invoice #: $inv_num Invoice Date: $datus" .
" | " .
" " .
"Item Code" .
" | Description" .
" | Quantity" .
" | Price" .
" | Amount" .
" | ");
}
}
?>
|
|
|
|
|
if($status == "Quote" or $subtotal == 0.00){
echo(" " .
"ERROR: This quote has not been authorized. Please contact Eco-\$mart Administration for Assistance." .
" |