| P.O. Number
| Terms
| Est. Delivery
| Project
|
| | | |
|
| Item Code
| Description
| Quantity
| Price
| Amount
|
Error retrieving Product Data.
' . 'Error: '. mysql_error(). '');
}
while($rowp = mysql_fetch_array($prod_inv)){
$PID = $rowp['ID'];
$PID_arr[] = $PID;
$prod_name = $rowp['prod_name'];
$prod_name_arr[] = $prod_name;
$prod_desc = $rowp['prod_desc'];
$prod_desc_arr[] = $prod_desc;
$prod_qty = $rowp['prod_qty'];
$prod_qty_arr[] = $prod_qty;
$prod_price = $rowp['prod_price'];
$dtup = $rowp['dtup'];
$dtnum = $rowp['dtnum'];
$status = $rowp['status'];
$amount = $prod_qty * $prod_price;
$amount1 = $prod_qty * $prod_price;
$amount = sprintf("%01.2f", $amount1);
echo("| $prod_name | $prod_desc" .
" | $prod_qty" .
" | $prod_price | $amount" .
" | ");
}
$prodcount = count($PID_arr);
$i = 0;
while($i < $prodcount){
$prod_list[] = $prod_name_arr[$i]." - ".$prod_desc_arr[$i]." - ".$prod_qty_arr[$i];
$i = $i+1;
}
$products = implode( "\\n", $prod_list);
$update = @mysql_query("UPDATE ecoinvoice SET status='Authorized' WHERE ID='$ID' LIMIT 1");
if (!$update) {
$no_up = 'Could not complete Authorization'. mysql_error();
}else{
$recipient = $rep_email.","."kent@kwgrubbs.com";
$subject = "E-bill from Eco-\$mart, Inc. Invoice No. $invnum";
$message = "FROM: ECO-\$MART, INC. == (888) 329-2705 == info@ecosmartinc.com" .
"\n" .
"TO: $to" .
"\n" .
"$email" .
"\n" .
"$City, $State $ZipCode" .
"\n" .
"INVOICE #: $invnum" .
"\n" .
"PRODUCTS:" .
"\n" .
"$products" .
"\n" .
"Thank you for your order from Eco-\$mart, Inc. We are so happy that you share our desire to live green." .
"\n" .
"To view or print your Invoice, please go to" .
"\n" .
"http://www.ecosmartinc.com/my_ecosmart_bill/" .
"\n" .
"Log in with your email address and this invoice number." .
"\n" .
"You can also securely pay this invoice on line with a bank card or credit card." .
"\n" .
"Please let us know if we can help you in any way." .
"\n" .
"\n" .
"Thank You," .
"\n" .
"$rep" .
"\n" .
"Eco-\$mart, Inc." .
"\n" .
"$rep_email" .
"\n";
if(@mail($recipient, $subject, $message, "From: $rep <$rep_email>")){
$maildone = 'yes';
}else{
$no_mail = 'Error Emailing E-bill';
}
}
//begin insert into billing table.
if($maildone == 'yes'){
$billo = @mysql_query("INSERT INTO inv_bill SET invnum='$invnum',rep='$rep',ref='$ref_RID',subtotal='$subtotal',total='$balance',dtup='$dtnum',dtpaid='0'");
if (!$billo){
$no_bill = 'Problem posting Bill' . mysql_error();
}else{
$billdone = 'yes';
}
}
if($billdone == 'yes'){
$oko = @mysql_query("INSERT INTO inv_notes SET invnum='$invnum',Notes ='$Notes',dtnum='$dtnum'");
if (!$oko){
$no_notes = 'Problem posting Notes' . mysql_error();
}else{
$alldone = 'yes';
}
}
?>
|
|
|
|
|
|
|
Invoice Status
|
Subtotal
" . $subtotal . "");
?>
|
|
" .
" | " .
"Successful Authorization" .
"
Data Base Updated
Email sent to Rep
Notes posted to Invoice" .
" | | " .
"Print Invoice" .
"Online Billing" .
" | ");
}else{
echo("" .
"" .
"Problems with Authorization" .
"
$no_up
$no_mail
$no_bill
$no_notes" .
" | ");
}
?>
| Sales Tax
" . $taxtotal . "");
?>
|
