");
foreach($air as $value){
echo("$value
");
}
exit();
}//doneisno
else{
$relocate="eco_quote.php?QID=".$newQID."&CID=".$newCID."&usrn=".$usrn."&usr=".$usr."&fr=".$dnum;
header("Location: $relocate");
}//done is yes
}else{///not same price level//////////////////////////////////////////////////////////////////
$act = mysql_query("INSERT INTO quotes SET CID='$newCID',usrn='$usrn',started='$dtnum'");
if(!$act){
$air[]="Could not insert new quote. Error: ".mysql_error();
//echo mysql_error();
exit();
}else{
$newQID = mysql_insert_id();
}//new QID inserted
$getoldprods = mysql_query("SELECT item,description,qty,price,unit FROM q_products WHERE QID='$QID'");
if(!$getoldprods){
$air[]="Could not get old Quote products. Error: ".mysql_error();
}else{
while($row=mysql_fetch_array($getoldprods)){
$newitems[]=$row['item'];
$newdescriptions[]=$row['description'];
$newqtys[]=$row['qty'];
$newprices[]=$row['price'];
$newunits[]=$row['unit'];
}//while getting old products
}///gotoldproductlist
$done="yes";
$countem=count($newitems);
$i=0;
while($i<$countem){
mysql_select_db('ecosmar_products', $dbcnx);
$getprices = mysql_query("SELECT sku,list,retail,special,dealer,dealer_lo,unit,lo_units,cs,min,description FROM price WHERE item='$newitems'");
if(!$getprices){
$air[]="Could not get price for".$newprod[$i].".";
}else{
$rowg=mysql_fetch_array($getprices);
$skus[]=$rowg['sku'];
$lists[]=$rowg['list'];
$retails[]=$rowg['retail'];
$specials[]=$rowg['special'];
$dealers[]=$rowg['dealer'];
$dealer_los[]=$rowg['dealer_lo'];
$units[]=$rowg['unit'];
$lo_unitss[]=$rowg['lo_units'];
$css[]=$rowg['cs'];
$mins[]=$rowg['min'];
$descriptions[]=$rowg['description'];
}//gotprices
if($newprice_level == "Wholesale"){
$inprice = $specials[$i];
}elseif($newprice_level == "Dealer" and $newqtys[$i]>=$lo_unitss[$i] and ($lo_unitss[$i]*1)!=0){
$inprice = $dealer_los[$i];
}elseif($newprice_level == "Dealer"){
$inprice = $dealers[$i];
}else{
$inprice = $retails[$i];
}
mysql_select_db('ecosmar_inv', $dbcnx);
if($newitems[$i] !="" and $newqtys[$i] !=""){
$inny=mysql_query("INSERT INTO q_products SET QID='$newQID',item='$newitems[$i]',description='$newdescriptions[$i]',qty='$newqtys[$i]',price='$inprice',unit='$newunits[$i]'");
if(!$inny){
$air[]="Could not insert ".$newitems[$i].". Error: ".mysql_error();
$done="no";
}
}//newprod item and qty is not blank
$i=$i+1;
}//while counting down new items
if($done=="no"){
echo("CANNOT DUPLICATE:
");
foreach($air as $value){
echo("$value
");
}
exit();
}//doneisno
else{
$relocate="eco_quote.php?QID=".$newQID."&CID=".$newCID."&usrn=".$usrn."&usr=".$usr."&fr=".$dnum."&dup=yes";
header("Location: $relocate");
}//done is yes
}///not same price level
?>