$dtnum = date(Ymd);
$dnum = date(Ymd) * 4;
$today = date("F j, Y");
$invnum = $_GET['invnum'];
if($invnum == ""){
$invnum = $_POST['inv'];
}
$numcnt = strlen($invnum);
if($invnum == "" or $numcnt < 8){
echo("Error: No Input");
exit();
}else{
echo $invnum;
$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_inv', $dbcnx);
$newinv = mysql_query("SELECT ID,invnum,CID,RID,rep,rep_email,rec_co,rec_name,rec_address,rec_city,rec_state,rec_zip,rec_phone,ponum,terms,due,project FROM ecoinvoice WHERE invnum='$invnum'");
if(!$newinv){
echo("
Problem getting invoice data.
Error: ".mysql_error()."
");
}else{
$row = mysql_fetch_array($newinv);
$ID = $row['ID'];
$invnu = $row['invnum'];
$invnum = $invnu + 0;
$CID = $row['CID'];
$RID = $row['RID'];
$rep = $row['rep'];
$rep_email = $row['rep_email'];
$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'];
$due = $row['due'];
$chunk_due = chunk_split($due, 2, ':');
$chunk_arrd = explode(":", $chunk_due);
$doit = $chunk_arrd[2].'/'.$chunk_arrd[3].'/'.$chunk_arrd[0].$chunk_arrd[1];
$project = $row['project'];
$taxtotal = $row['taxtotal'];
$tax = $row['tax'];
$subtotal = $row['subtotal'];
$shiptotal = $row['shiptotal'];
$balance = $row['balance'];
$payments = $row['payments'];
$special = $row['special'];
}
mysql_select_db('ecosmar_contacts', $dbcnx);
$contact = mysql_query("SELECT first_Name,Name,Company,Address,City,State,ZipCode from con_main WHERE ID='$CID'");
if(!$contact){
echo("
Problem getting contact data.
Error: ".mysql_error()."
");
}else{
$rowc = mysql_fetch_array($contact);
$first_Name = $rowc['first_Name'];
$Name = $rowc['Name'];
$Company = $rowc['Company'];
$Address = $rowc['Address'];
$City = $rowc['City'];
$State = $rowc['State'];
$ZipCode = $rowc['ZipCode'];
$customer = "$Company
$first_Name $Name
$Address
$City, $State $ZipCode
$email
$Phone
$FAX";
$c_ship = "$Company
$first_Name $Name
$Address
$City, $State $ZipCode
$Phone";
$shipto = "$rec_co
$rec_name
$rec_address
$rec_city, $rec_state $rec_zip
$rec_phone";
}
}
$right = "So";
?>
|
Eco-$mart, Inc.
4411 Bee Ridge Road #344
Sarasota, FL 34233
PH. 888-329-2705 FX: 941-377-9460
www.ecosmartinc.com
|
Quote
Date
| Invoice #
|
|
|
Representative
|
|
|
Bill To:
| Ship To:
|
|
if($rec_zip == ""){
echo $c_ship;
}else{
echo $shipto;
}
?>
|
P.O. Number
| Terms
| Est. Delivery
| Project
|
|
|
|
|
|
©2007 - Data Base Interface - Custom Built at:
|