$dtnum = date(Ymd);
$warn = "off";
$usrn = $_POST['usrn'];
$invnum = $_POST[invnum];
$hite = $_POST['hite'];
$CID = $_POST['CID'];
$rep = $_POST['rep'];
$rep_email = $_POST['rep_email'];
$first_Name = $_POST['first_Name'];
$Name = $_POST['Name'];
$Cname = $first_Name." ".$Name;
$Company = $_POST['Company'];
$Phone = $_POST['Phone'];
$Address = $_POST['Address'];
$FAX = $_POST['FAX'];
$City = $_POST['City'];
$email = $_POST['email'];
$State = $_POST['State'];
$ZipCode = $_POST['ZipCode'];
$RID = $_POST['RID'];
$ship = $_POST['ship'];
if($ship == "same"){
$rec_co = $Company;
$rec_name = $Cname;
$rec_address = $Address;
$rec_city = $City;
$rec_state = $State;
$rec_zip = $ZipCode;
$rec_phone = $Phone;
}else{
$rec_co = $_POST['rec_co'];
$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'];
$rec_phone = $_POST['rec_phone'];
if($rec_co == "" and $rec_name == ""){
$warn = "on";
$mess = "Ship to: Name or Company Name";
}elseif($rec_address == ""){
$warn = "on";
$mess = "Ship to: Address";
}elseif($rec_zip == ""){
$warn = "on";
$mess = "Ship to: Zip Code";
}elseif($rec_phone == ""){
$warn = "on";
$mess = "Ship to: Phone Number";
}
}
$specialcheck = $_POST['specialcheck'];
if($specialcheck == ""){
$special = 'none';
}else{
$special = $specialcheck;
}
$ponum = $_POST['ponum'];
$terms = $_POST['terms'];
$dd1 = $_POST['dd1'];
$dd2 = $_POST['dd2'];
$dd3 = $_POST['dd3'];
if($dd1 == "02" or $dd1 == "2" or $dd1 == 2){
$rg = $dd3 / 4;
if(is_int($rg)){
if($dd2 == "30" or $dd2 == "31"){
$warn = "on";
$mess = "Due Date: No such date";
}
}else{
if($dd2 == "29" or $dd2 == "30" or $dd2 == "31"){
$warn = "on";
$mess = "Due Date: No such date";
}
}
}
$due = $dd3.$dd1.$dd2;
if($due < $dtnum){
$warn = "on";
$mess = "Due Date: Date Prior";
}
$project = $_POST['project'];
if($hite == "b"){
$redirect = "eco_inv_newup_edit.php?inv=".$invnum;
}else{
$redirect = "eco_inv_newup2.php?inv=".$invnum;
}
if($warn == "on"){
echo("Sorry, there is a problem with your data.
$mess
Please GO BACK and correct.
");
exit();
}else{
$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_inv', $dbcnx);
if($hite == "b"){
$ok = @mysql_query("UPDATE ecoinvoice SET rec_co='$rec_co',rec_name='$rec_name',rec_address='$rec_address',rec_city='$rec_city',rec_state='$rec_state',rec_zip='$rec_zip',rec_phone='$rec_phone',ponum='$ponum',terms='$terms',due='$due',dueup='$dtnum',project='$project',status='Quote',special='$special' WHERE invnum='$invnum'");
}else{
$ok = @mysql_query("INSERT INTO ecoinvoice SET invnum='$invnum',CID='$CID',RID='$RID',rep='$rep',rep_email='$rep_email',rec_co='$rec_co',rec_name='$rec_name',rec_address='$rec_address',rec_city='$rec_city',rec_state='$rec_state',rec_zip='$rec_zip',rec_phone='$rec_phone',ponum='$ponum',terms='$terms',due='$due',project='$project',dtnum='$dtnum',status='Quote',special='$special'");
}
if (!$ok) {
echo("Could not update data base.
Error: ".mysql_error()."
");
}else{
header("Location: $redirect");
}
}//last else warn is off
?>