'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;
$sqla=mysql_query("SELECT * FROM ST_History_FOB WHERE Pc_No='$scno' AND Seq_No='$seqno' AND DocNo='30'");
while($rec=mysql_fetch_array($sqla))
{
$catid=$rec['Cat_ID'];
if($catid == '985')
{
$sqla=mysql_query("SELECT * FROM SC_Item WHERE Sc_No='$scno' AND Seq_No='$seqno' ");
$rec=mysql_fetch_array($sqla);
$specno=$rec['Spec_No'];
$sqlb=mysql_query("SELECT * FROM Sp_Kitem WHERE Internal='$specno' AND Group_Item='Chain' ");
$recb=mysql_fetch_array($sqlb);
$Item1=$recb['SubItem1'];
$Item2=$recb['SubItem2'];
$Item3=$recb['SubItem3'];
$Item4=$recb['SubItem4'];
$Item5=$recb['SubItem5'];
$Item6=$recb['SubItem6'];
$Itemv1=$recb['Subval1'];
$Itemv2=$recb['Subval2'];
$Itemv3=$recb['Subval3'];
$Itemv4=$recb['Subval4'];
$Itemv5=$recb['Subval5'];
$Itemv6=$recb['Subval6'];
if($Item1 == "Links" AND $Itemv1 > '0' )
{
$nolinks=$Itemv1;
}
if($Item2 == "Links" AND $Itemv2 > '0' )
{
$nolinks=$Itemv2;
}
if($Item3 == "Links" AND $Itemv3 > '0' )
{
$nolinks=$Itemv3;
}
if($Item4 == "Links" AND $Itemv4 > '0' )
{
$nolinks=$Itemv4;
}
if($Item5 == "Links" AND $Itemv5 > '0' )
{
$nolinks=$Itemv5;
}
if($Item6 == "Links" AND $Itemv6 > '0' )
{
$nolinks=$Itemv6;
}
$qtyya=$nolinks*$qtyy;
$sqlupdatesthistory=mysql_query("UPDATE ST_History_FOB SET Qty='$qtyya' WHERE Pc_No='$scno' AND Seq_No='$seqno' AND DocNo='30' AND Cat_ID='985'");
}
else
{
$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