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

"); exit(); } $invnu = $_POST['inv']; $hite = $_POST['hite']; if($hite == 'b'){ $butt = 'Submit'; }else{ $butt = 'Add Products'; } $blank = "off"; $year = date(Y); $year2 = $year + 1; $year3 = $year + 2; $usrn = $_GET['usrn']; if($usrn == ""){ $usrn = $_POST['usrn']; } $CID = $_GET['ID']; if($CID == ""){ $CID = $_POST['CID']; } if($CID == ""){ echo("

No Contact!
Contact must be registered before Invoicing.

"); exit(); } $today = date("F j, Y"); $dtnum = date(Ymd); $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); mysql_select_db('ecosmar_website', $dbcnx); $ok = @mysql_query("SELECT ID,usrn,email FROM psw WHERE usrn='$usrn'"); if (!$ok) { echo 'Could not retrieve Representative ID: ' . mysql_error(); } $rowa = mysql_fetch_array($ok); $RD = $rowa[0]; $rep = $rowa[1]; $rep_email = $rowa[2]; $str = strlen($RD); if($str < 3){ $RID = 100 + $RD; }elseif($str == 3){ $RID = $RD; }else{ echo("Trouble generating Representative invoice number."); } mysql_select_db('ecosmar_contacts', $dbcnx); $listem = @mysql_query("SELECT ID,first_Name,Name,Company,Phone,Address,FAX,City,email,State,ZipCode,referred_by 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']; $full_Name = $first_Name." ".$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']; $referred_by = $rowb['referred_by']; $customer = "$Company
$first_Name $Name
$Address
$City, $State $ZipCode
$email
$Phone
$FAX"; if($referred_by != ""){ $refmess = "

This contact referred by ".$referred_by.".

"; }else{ $refmess = "

No referrer listed for this contact. If you think this is an error, please contact Eco-\$mart Administration. Contacts must be submitted and authorized to become Eco-\$mart Referrers.

"; } $ok2 = @mysql_query("SELECT ID,status FROM special WHERE email='$email'"); if (!$ok2) { echo 'Trouble finding Special Status: ' . mysql_error(); }else{ $rowb = mysql_fetch_array($ok2); $SID = $rowb['ID']; $special = $rowb['status']; } mysql_select_db('ecosmar_inv', $dbcnx); if($invnu == ""){ $id_max = mysql_query("SELECT invnum FROM ecoinvoice WHERE rep='$usrn' ORDER BY invnum DESC "); if(!$id_max){ echo("Trouble generating invoice number: ". mysql_error()); }else{ $id_macs = mysql_fetch_array($id_max); $oldinv = $id_macs[0]; if($oldinv == ""){ $newinv = "1".$RID."00001"; }else{ $newinv = $oldinv + 1; } } $TID = $newinv + 0; $invnum = $TID; }else{ $getinv = mysql_query("SELECT invnum,rec_co,rec_name,rec_address,rec_city,rec_state,rec_zip,rec_phone,ponum,terms,due,project,status FROM ecoinvoice WHERE invnum='$invnu'"); if(!$getinv){ echo("

Problem retrieving invoice data.
Error: ".mysql_error()."

"); }else{ $row = mysql_fetch_array($getinv); $invnum = $row['invnum']; $rec_co = $row['rec_co']; $rec_name = $row['rec_name']; $rec_address = $row['rec_address']; $rec_city = $row['rec_city']; $rec_state = $row['rec_state']; $rec_zip = $row['rec_zip']; $rec_phone = $row['rec_phone']; $ponum = $row['ponum']; $terms = $row['terms']; $termselect = "