<<<<Restricted Area>>>>" . "
Sorry, you must Log In to view this Page

"); exit(); } $usrn = $_POST['usrn']; $ID = $_POST['ID']; $today = date("F j, Y"); $dtup = date(Ymd); $invnum = $_POST['invnum']; $CID = $_POST['CID']; $rep = $_POST['rep']; $rec_name = $_POST['rec_name']; $rec_address = $_POST['rec_address']; $rec_city = $_POST['rec_city']; $rec_state = $_POST['rec_state']; $rec_zip = $_POST['rec_zip']; $ponum = $_POST['ponum']; $terms = $_POST['terms']; $due = $_POST['due']; $project = $_POST['project']; $remove = $_POST[remove]; $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); mysql_select_db('ecosmar_inv', $dbcnx); foreach($remove as $value){ $ok2 = @mysql_query("DELETE FROM inv_prod WHERE prod_name='$value' AND invnum='$invnum' LIMIT1"); if ($ok2) { $remprod = 'ok'; }else{ echo ("

Could not remove products!
". 'Error:' . mysql_error() . '

'); } } } $special = $_POST['special']; $newproduct_list = $_POST[newproduct_list]; $nplist_count = count($newproduct_list); $i = 0; while($i < $nplist_count){ $result = @mysql_query("SELECT id,productname,description,$special FROM prices WHERE id='$newproduct_list[$i]'"); if (!$result){ echo ("

Error Getting New Products from Data Base!
". 'Error:' . mysql_error() . '

'); }else{ $nplist = mysql_fetch_array($result) $PID_arr[] = $nplist[0]; $prod_name_arr[] = $nplist[1]; $prod_desc_arr[] = stripslashes($nplist[2]); $prod_price_arr[] = $nplist[3]; } $i = $i+1; } foreach($PID_arr as $value){ $oko = @mysql_query("INSERT INTO inv_prod SET invnum='$invnum',prod_name='$prod_name_arr[$i]',prod_desc_arr='$prod_desc[$i]',prod_qty='$prod_qty[$i]',prod_price='$prod_price[$i]',dtup='$dtup',dtnum='$dtnum',status='new'"); if (!$oko){ $no_add = 'Problem Adding Products to Invoice: ' . mysql_error(); }else{ $add_prod = $add_prod + 1; } $i = $i+1; } if($add_prod == $prod_count){ $added_prod = 'yes'; } } $balance = $row['balance']; $payments = $row['payments']; $dtnum = $_POST['dtnum']; $chunk_dtnum = chunk_split($dtnum, 2, ':'); $chunk_arr = explode(":", $chunk_dtnum); $datus = $chunk_arr[2].'-'.$chunk_arr[3].'-'.$chunk_arr[0].$chunk_arr[1]; $status = $row['status']; $prgrss = $row['prgrss']; mysql_select_db('ecosmar_contacts', $dbcnx); $listem = @mysql_query("SELECT ID,first_Name,Name,Company,Phone,Address,FAX,City,email,State,ZipCode FROM con_main WHERE ID='$CID'"); if (!$listem) { echo('

Error retrieving data from data base.
' . 'Error: '. mysql_error(). '

'); } $rowb = mysql_fetch_array($listem); $CID = $rowb['ID']; $first_Name = $rowb['first_Name']; $Name = $rowb['Name']; $Company = $rowb['Company']; $Phone = $rowb['Phone']; $Address = $rowb['Address']; $FAX = $rowb['FAX']; $City = $rowb['City']; $email = $rowb['email']; $State = $rowb['State']; $ZipCode = $rowb['ZipCode']; $customer = "$first_Name $Name
$Company
$Address
$City, $State $ZipCode
$email
$Phone
$FAX"; ?>

Eco-$mart, Inc.
4411 Bee Ridge Road #344  Sarasota, FL 34233
PH. 888-329-2705   FX: 941-377-9460
www.ecosmartinc.com

Invoice
Date Invoice #
   
Representative
 
Bill To: Ship To:


, 
P.O. Number Terms Due Date Project #
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']; $dtup = $rowp['dtup']; $dtnum = $rowp['dtnum']; $status = $rowp['status']; $amount = $prod_qty * $prod_price; echo("" . ""); $full_amount[] = $amount; } ?>
Remove this Product Item Code Description Quantity Price Amount
" . "$prod_name$prod_desc" . "$prod_qty" . "$prod_price$amount" . "
  Remove this Product  = Remove      
+ Add Products: Subtotal $subtotal

"); ?>
Error Getting Product List from Data Base!
". 'Error:' . mysql_error() . '

'); }else{ while($row = mysql_fetch_array($result)){ $NPID = $row['id']; $prod_name = $row['productname']; $prod_desc = stripslashes($row['description']); echo("" . "$prod_name - $prod_desc
"); } } ?>
Sales Tax $tax

"); ?>

New Tax  %

Total $total

"); ?>
Payments/Credits

New Payments  $

Balance Due

~  "Authorize" - will Approve this Invoice and Create an Official Invoice to print or send.
~  "Edit" - Make changes to Products or Prices.
~  "Change" - Change the Status of this Invoice.