'0' AND $seqno > '0' AND $qty > '0')
{
///////sc item update
$sqlupdatescitem=mysqli_query($conn,"UPDATE SC_Item SET Quantity='$qty' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
/////////////tri sc item update
$sqlupdatescitem=mysqli_query($conn,"UPDATE TRI_SC_Item SET Quantity='$qty' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
//////pc item update
//////pc item update
$sqlupdatepcitem=mysqli_query($conn,"UPDATE PC_Item SET Quantity='$qty' WHERE SC_No='$scno' AND Seq_No='$seqno'");
if(isset($_POST['po'])=="checkbox"){
$sqlupdatepcitem=mysqli_query($conn,"UPDATE PO_Imp_F_Item SET QTY='$qty' WHERE PCNo='$scno' AND SeqNo='$seqno' AND Cat_ID IS NOT NULL");
}
////ibws_data update
$sqlupdateibwsdataitem=mysqli_query($conn,"UPDATE Ibws_Data SET order_qty='$qty' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
$sqlupdateibwsdataitem=mysqli_query($conn,"UPDATE Ibws_Data_CH SET order_qty='$qty' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
////////sc_ini item
$sqlupdateiniitem=mysqli_query($conn,"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=mysqli_query($conn,"UPDATE ST_History SET Qty='$qtyy' WHERE Pc_No='$scno' AND Seq_No='$seqno' AND DocNo='30'");
}
if($importterms =='FOB')
{
//echo $importterms;
$sqla=mysqli_query($conn,"SELECT * FROM ST_History_FOB WHERE Pc_No='$scno' AND Seq_No='$seqno' AND DocNo='30'");
while($rec=mysqli_fetch_array($sqla))
{
$catid=$rec['Cat_ID'];
$Part_ID=$rec['Part_ID'];
if($catid == '985' && mysqli_num_rows(mysqli_query($conn,"SELECT * FROM ST_Item_Chain WHERE Item_No='$Part_ID'"))!=0)
{
$sqlas=mysqli_query($conn,"SELECT * FROM SC_Item WHERE Sc_No='$scno' AND Seq_No='$seqno' ");
$recs=mysqli_fetch_array($sqlas);
$specno=$recs['Spec_No'];
$sqlb=mysqli_query($conn,"SELECT * FROM Sp_Kitem WHERE Internal='$specno' AND Group_Item='Chain' ");
$recb=mysqli_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=mysqli_query($conn,"UPDATE ST_History_FOB SET Qty='$qtyya' WHERE Pc_No='$scno' AND Seq_No='$seqno' AND DocNo='30' AND Cat_ID='985'");
}
else
{
$sqlupdatesthistory=mysqli_query($conn,"UPDATE ST_History_FOB SET Qty='$qtyy' WHERE Pc_No='$scno' AND Seq_No='$seqno' AND DocNo='30' AND Cat_ID='$catid'");
}
}
$sqla=mysqli_query($conn,"SELECT * FROM ST_History_FOB_Block WHERE Pc_No='$scno' AND Seq_No='$seqno' AND DocNo='30'");
while($rec=mysqli_fetch_array($sqla))
{
$catid=$rec['Cat_ID'];
$Part_ID=$rec['Part_ID'];
if($catid == '985' && mysqli_num_rows(mysqli_query($conn,"SELECT * FROM ST_Item_Chain WHERE Item_No='$Part_ID'"))!=0)
{
$sqlas=mysqli_query($conn,"SELECT * FROM SC_Item WHERE Sc_No='$scno' AND Seq_No='$seqno' ");
$recs=mysqli_fetch_array($sqlas);
$specno=$recs['Spec_No'];
$sqlb=mysqli_query($conn,"SELECT * FROM Sp_Kitem WHERE Internal='$specno' AND Group_Item='Chain' ");
$recb=mysqli_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=mysqli_query($conn,"UPDATE ST_History_FOB_Block SET Qty='$qtyya' WHERE Pc_No='$scno' AND Seq_No='$seqno' AND DocNo='30' AND Cat_ID='985'");
}
else
{
$sqlupdatesthistory=mysqli_query($conn,"UPDATE ST_History_FOB_Block SET Qty='$qtyy' WHERE Pc_No='$scno' AND Seq_No='$seqno' AND DocNo='30' AND Cat_ID='$catid'");
}
}
}
$selr=mysqli_query($conn,"SELECT FD_Number FROM SC_Item WHERE Sc_No='$scno' AND Seq_No='$seqno'");
$rowr=mysqli_fetch_assoc($selr);
$FD_Number=$rowr['FD_Number'];
if($FD_Number!=0 && $FD_Number!=""){
$selsw=mysqli_query($conn,"SELECT SUM(Length) AS QTYS,Item_Code FROM TRI_Frame_Drawing_Spec_Tube WHERE Internal='$FD_Number' GROUP BY Item_Code");
while($rowsw=mysqli_fetch_assoc($selsw)){
$Item_Code=$rowsw['Item_Code'];
$QTYST=$rowsw['QTYS'];
if(strstr($Item_Code,"S")==true && strpos($Item_Code,"S")==0){
$QTYS=-(round(($qty*$QTYST)+($qty*$QTYST*.03),0));
}
else if(strstr($Item_Code,"A")==true){
$QTYS=-(round(($qty*$QTYST)+($qty*$QTYST*.04),0));
}
else{
$QTYS=-(round(($qty*$QTYST)+($qty*$QTYST*.02),0));
}
$inseq=mysqli_query($conn,"UPDATE ST_History_FOB_Tube SET Qty='$QTYS' WHERE Pc_No='$scno' AND Seq_No='$seqno' AND DocNo='130' AND Part_ID='$Item_Code'");
}
}
////
////pc dlvy head
$sqlupdatepcdlvyhead=mysqli_query($conn,"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