'0' AND $seqno > '0' AND $qty > '0')
{
///////sc item update
$sqlupdatescitem=mysql_query("UPDATE SC_Item SET Quantity='$qty' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
/////////////tri sc item update
$sqlupdatescitem=mysql_query("UPDATE TRI_SC_Item SET Quantity='$qty' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
//////pc item update
//////pc item update
$sqlupdatepcitem=mysql_query("UPDATE PC_Item SET Quantity='$qty' WHERE SC_No='$scno' AND Seq_No='$seqno'");
////ibws_data update
$sqlupdateibwsdataitem=mysql_query("UPDATE Ibws_Data SET order_qty='$qty' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
////////sc_ini item
$sqlupdateiniitem=mysql_query("UPDATE Sc_Itemnot_Include SET Ord_Qty='$qty' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
///////
/////ST History
$qtyy=(0-$qty);
if($importterms =='CM')
{
echo $importterms;
$sqlupdatesthistory=mysql_query("UPDATE ST_History SET Qty='$qtyy' WHERE Pc_No='$scno' AND Seq_No='$seqno' AND DocNo='30'");
}
if($importterms =='FOB')
{
echo $importterms;
$sqlupdatesthistory=mysql_query("UPDATE ST_History_FOB SET Qty='$qtyy' WHERE Pc_No='$scno' AND Seq_No='$seqno' AND DocNo='30'");
}
////
////pc dlvy head
$sqlupdatepcdlvyhead=mysql_query("UPDATE PC_Dlvy_Head SET Qty='$qty',Dlvy1_Qty='$qty' WHERE Sc_No='$scno' AND Seq_No='$seqno' ");
}
else
{
echo "make sure fill the balnks correctly.";
echo "";
}
?>
Home