";
$record4=mysqli_fetch_array($sql4);
$sqlupdate5=mysqli_query($conn,"UPDATE `PO_Imp_F_Head` SET `TTl_US`='".$record4['sumus']."' , TTL_NT='".$record4['sumnt']."',TTL_RNB='".$record4['sumrnb']."',TTL_BT='".$record4["sumbtk"]."' WHERE Internal='$internalno' ");
//echo "UPDATE `PO_Imp_F_Head` SET `TTl_US`='".$record4['sumus']."' , TTL_NT='".$record4['sumnt']."',TTL_RNB='".$record4['sumrnb']."',TTL_BT='".$record4["sumbtk"]."' WHERE Internal='$internalno' ";
$sql5=mysqli_query($conn,"Select * from Imp_F_Itemttl_US Where LineNo='$lineno' ");
$record5=mysqli_fetch_array($sql5);
$sqlupdate6=mysqli_query($conn,"UPDATE PO_Imp_F_Item SET price_us='".$record5["priceus"]."',
price_nt='".$record5["pricent"]."',
price_bt='".$record5["pricebtk"]."',
price_rnb='".$record5["pricernb"]."',
TTl_Item_us='".$record5["itemvalus"]."',
TTl_Item_nt='".$record5["itemvalnt"]."',
TTl_Item_rnb='".$record5["itemvalrnb"]."',
TTl_Item_btk='".$record5["itemvalbtk"]."' WHERE LineNo='$lineno' ");
/*echo "UPDATE PO_Imp_F_Item SET price_us='".$record5["priceus"]."',
price_nt='".$record5["pricent"]."',
price_bt='".$record5["pricebtk"]."',
price_rnb='".$record5["pricernb"]."',
TTl_Item_us='".$record5["itemvalus"]."',
TTl_Item_nt='".$record5["itemvalnt"]."',
TTl_Item_rnb='".$record5["itemvalrnb"]."',
TTl_Item_btk='".$record5["itemvalbtk"]."' WHERE LineNo='$lineno' ";*/
//echo "
";
$sqlupdate6=mysqli_query($conn,"UPDATE `ST_Item_Fixed` SET `Price_US`='".$record5["priceus"]."' ,
`Price_NT`='".$record5["pricent"]."' ,
`Price_RMB`='".$record5["pricernb"]."' ,
`Price_BT`='".$record5["pricebtk"]."' ,
`Last_update_Date`='".$pdate."'
WHERE Item_Code='".$itemcode."'");
$sqlupdate7=mysqli_query($conn,"UPDATE `ST_Item` SET `Price_US`='".$record5["priceus"]."' ,
`Price_NT`='".$record5["pricent"]."' ,
`Price_RMB`='".$record5["pricernb"]."' ,
`Price_BT`='".$record5["pricebtk"]."' ,
`Last_update_Date`='".$pdate."'
WHERE Item_Code='".$itemcode."'");
$today1 = date("Y-m-d");
$sqlupdate8=mysqli_query($conn,"UPDATE `Cost_INI_Item` SET `Price`='".$record5["priceus"]."',
`Date`='".$today1."'
WHERE Item_Code='".$itemcode."'");
}
if($currency == "NT$")
{
$strSQLExists = "select * from Imp_F_PO_TTLvalnt Where Internal='".$internalno."' ";
$rsExists = mysqli_query($conn,$strSQLExists);
$data499=mysqli_fetch_array($rsExists);
$strSQLInsert5 = mysqli_query($conn,"UPDATE PO_Imp_F_Head SET TTl_US='".$data499["sumus"]."',
TTL_NT='".$data499["sumnt"]."',
TTL_RNB='".$data499["sumrnb"]."',
TTL_BT='".$data499["sumbtk"]."'
WHERE Internal='".$internalno."' ") ;
//echo $strSQLInsert;
//db_exec($strSQLInsert5 ,$conn);
//////////////////
$strSQLExists = "select * from Imp_F_Itemttl_NT Where LineNo='".$lineno."' ";
$rsExists = mysqli_query($conn,$strSQLExists);
$data4550=mysqli_fetch_array($rsExists);
$strSQLInsert5 = mysqli_query($conn,"UPDATE PO_Imp_F_Item SET price_us='".$data4550["priceus"]."',
price_nt='".$data4550["pricent"]."',
price_bt='".$data4550["pricebtk"]."',
price_rnb='".$data4550["pricernb"]."',
TTl_Item_us='".$data4550["itemvalus"]."',
TTl_Item_nt='".$data4550["itemvalnt"]."',
TTl_Item_rnb='".$data4550["itemvalrnb"]."',
TTl_Item_btk='".$data4550["itemvalbtk"]."'
WHERE LineNo='".$lineno."' ") ;
//echo $strSQLInsert;
//db_exec($strSQLInsert5 ,$conn);
$strSQLUPdate = mysqli_query($conn,"UPDATE `ST_Item_Fixed` SET `Price_US`='".$data4550["priceus"]."' ,
`Price_NT`='".$data4550["pricent"]."' ,
`Price_RMB`='".$data4550["pricernb"]."' ,
`Price_BT`='".$data4550["pricebtk"]."' ,
`Last_update_Date`='".$pdate."'
WHERE Item_Code='".$itemcode."'");
//echo $strSQLUPdate;
//db_exec($strSQLUPdate ,$conn);
$strSQLUPdate = mysqli_query($conn,"UPDATE `ST_Item` SET `Price_US`='".$data4550["priceus"]."' ,
`Price_NT`='".$data4550["pricent"]."' ,
`Price_RMB`='".$data4550["pricernb"]."' ,
`Price_BT`='".$data4550["pricebtk"]."' ,
`Last_update_Date`='".$pdate."'
WHERE Item_Code='".$itemcode."'");
//echo $strSQLUPdate;
//db_exec($strSQLUPdate ,$conn);
}
if($currency == "RMB")
{
$strSQLExists = "select * from Imp_F_PO_TTLvalrnb Where Internal='".$internalno."' ";
$rsExists = mysqli_query($conn,$strSQLExists);
$data499=mysqli_fetch_array($rsExists);
$strSQLInsert5 = mysqli_query($conn,"UPDATE PO_Imp_F_Head SET TTl_US='".$data499["sumus"]."',
TTL_NT='".$data499["sumnt"]."',
TTL_RNB='".$data499["sumrnb"]."',
TTL_BT='".$data499["sumbtk"]."'
WHERE Internal='".$internalno."' ") ;
//echo $strSQLInsert;
//db_exec($strSQLInsert5 ,$conn);
//////////////////
$strSQLExists = "select * from Imp_F_Itemttl_RNB Where LineNo='".$lineno."' ";
$rsExists = db_query($strSQLExists,$conn);
$data4550=db_fetch_array($rsExists);
$strSQLInsert5 = mysqli_query($conn,"UPDATE PO_Imp_F_Item SET price_us='".$data4550["priceus"]."',
price_nt='".$data4550["pricent"]."',
price_bt='".$data4550["pricebtk"]."',
price_rnb='".$data4550["pricernb"]."',
TTl_Item_us='".$data4550["itemvalus"]."',
TTl_Item_nt='".$data4550["itemvalnt"]."',
TTl_Item_rnb='".$data4550["itemvalrnb"]."',
TTl_Item_btk='".$data4550["itemvalbtk"]."'
WHERE LineNo='".$lineno."' ") ;
//echo $strSQLInsert;
//db_exec($strSQLInsert5 ,$conn);
$strSQLUPdate = mysqli_query($conn,"UPDATE `ST_Item_Fixed` SET `Price_US`='".$data4550["priceus"]."' ,
`Price_NT`='".$data4550["pricent"]."' ,
`Price_RMB`='".$data4550["pricernb"]."' ,
`Price_BT`='".$data4550["pricebtk"]."' ,
`Last_update_Date`='".$pdate."'
WHERE Item_Code='".$itemcode."'");
//echo $strSQLUPdate;
//db_exec($strSQLUPdate ,$conn);
$strSQLUPdate = mysqli_query($conn,"UPDATE `ST_Item` SET `Price_US`='".$data4550["priceus"]."' ,
`Price_NT`='".$data4550["pricent"]."' ,
`Price_RMB`='".$data4550["pricernb"]."' ,
`Price_BT`='".$data4550["pricebtk"]."' ,
`Last_update_Date`='".$pdate."'
WHERE Item_Code='".$itemcode."'");
//echo $strSQLUPdate;
//db_exec($strSQLUPdate ,$conn);
}
if($currency == "BTK")
{
$strSQLExists = "select * from Imp_F_PO_TTLvalbtk Where Internal='".$internalno."' ";
$rsExists = mysqli_query($conn,$strSQLExists);
$data499=mysqli_fetch_array($rsExists);
$strSQLInsert5 = mysqli_query($conn,"UPDATE PO_Imp_F_Head SET TTl_US='".$data499["sumus"]."',
TTL_NT='".$data499["sumnt"]."',
TTL_RNB='".$data499["sumrnb"]."',
TTL_BT='".$data499["sumbtk"]."'
WHERE Internal='".$internalno."' ") ;
//echo $strSQLInsert;
//db_exec($strSQLInsert5 ,$conn);
//////////////////
$strSQLExists = "select * from Imp_F_Itemttl_BTK Where LineNo='".$lineno."' ";
$rsExists = mysqli_query($conn,$strSQLExists);
$data4550=mysqli_fetch_array($rsExists);
$strSQLInsert5 = mysqli_query($conn,"UPDATE PO_Imp_F_Item SET price_us='".$data4550["priceus"]."',
price_nt='".$data4550["pricent"]."',
price_bt='".$data4550["pricebtk"]."',
price_rnb='".$data4550["pricernb"]."',
TTl_Item_us='".$data4550["itemvalus"]."',
TTl_Item_nt='".$data4550["itemvalnt"]."',
TTl_Item_rnb='".$data4550["itemvalrnb"]."',
TTl_Item_btk='".$data4550["itemvalbtk"]."'
WHERE LineNo='".$lineno."' ") ;
//echo $strSQLInsert;
//db_exec($strSQLInsert5 ,$conn);
$strSQLUPdate = mysqli_query($conn,"UPDATE `ST_Item_Fixed` SET `Price_US`='".$data4550["priceus"]."' ,
`Price_NT`='".$data4550["pricent"]."' ,
`Price_RMB`='".$data4550["pricernb"]."' ,
`Price_BT`='".$data4550["pricebtk"]."' ,
`Last_update_Date`='".$pdate."'
WHERE Item_Code='".$itemcode."'");
//echo $strSQLUPdate;
db_exec($strSQLUPdate ,$conn);
$strSQLUPdate = mysqli_query($conn,"UPDATE `ST_Item` SET `Price_US`='".$data4550["priceus"]."' ,
`Price_NT`='".$data4550["pricent"]."' ,
`Price_RMB`='".$data4550["pricernb"]."' ,
`Price_BT`='".$data4550["pricebtk"]."' ,
`Last_update_Date`='".$pdate."'
WHERE Item_Code='".$itemcode."'");
//echo $strSQLUPdate;
db_exec($strSQLUPdate ,$conn);
}
//////////////////////////////////////////////////////////////////////////////////////
if ($catid <> '962' OR $catid <> '963' OR $catid <> '1183')
{
$item=trim($itemcode);
//$scno=$values["PCNo"];
//$seqno=$values["SeqNo"];
$strSQLExists = "select * from SC_Item Where Sc_No='".$pcno."' AND Seq_No='".$seqno."' ";
$rsExists = mysqli_query($conn,$strSQLExists);
$data500=mysqli_fetch_array($rsExists);
$frsize=$data500["Frm_Size"];
$mdlgroup=$data500["Model_Group"];
$specno=$data500["Spec_No"];
if($mdlgroup <> '1')
{
$article=$data500["Article"];
$strSQLExists5 = "select * from SC_Item Where LineNo='".$article."' ";
$rsExists5 = mysqli_query($conn,$strSQLExists5,$conn);
$data5005=mysqli_fetch_array($rsExists5);
$specno=$data5005["Spec_No"];
$seqno=$data5005["Seq_No"];
}
if($mdlgroup <> '1')
{
$strSQLExists1 = "select * from Ref_Fixed_Des Where Internal='".$specno."' AND Sc_No='".$pcno."' AND Seq_No='".$seqno."' AND Model='".$item."' ";
}
if($mdlgroup == '1')
{
$strSQLExists1 = "select * from Ref_Fixed_Des Where Internal='".$specno."' AND Sc_No='".$pcno."' AND Seq_No='".$seqno."' AND Model='".$item."' AND Frame_Size='".$frsize."' ";
}
//echo "select * from Ref_Fixed_Des Where Internal='".$specno."' AND Sc_No='".$scno."' AND Seq_No='".$seqno."' AND Model='".$item."' AND Frame_Size='".$frsize."' ";
//echo $strSQLExists1;
$rsExists1 = mysqli_query($conn,$strSQLExists1);
$data5001=mysqli_fetch_array($rsExists1);
$norows=mysqli_num_rows($rsExists1);
$specfrmesize=$data5001["Frame_Size"];
if($norows > '0')
{
mysqli_query($conn,"SET NAMES 'utf8'");
$strSQLInsert5 = mysqli_query($conn,"UPDATE PO_Imp_F_Item SET
Description='".addslashes($data5001["Description"])."',
SubItem1='".trim(addslashes($data5001["SubItem1"]))."',
SubItem2='".trim(addslashes($data5001["SubItem2"]))."',
SubItem3='".trim(addslashes($data5001["SubItem3"]))."',
SubItem4='".trim(addslashes($data5001["SubItem4"]))."',
Subitem5='".trim(addslashes($data5001["Subitem5"]))."',
SubItem6='".trim(addslashes($data5001["SubItem6"]))."',
Subval1='".trim(addslashes($data5001["Subval1"]))."',
Subval2='".trim(addslashes($data5001["Subval2"]))."',
Subval3='".trim(addslashes($data5001["Subval3"]))."',
Subval4='".trim(addslashes($data5001["Subval4"]))."',
Subval5='".trim(addslashes($data5001["Subval5"]))."',
Subval6='".trim(addslashes($data5001["Subval6"]))."'
WHERE LineNo='".$lineno."' ") ;
//echo $strSQLInsert5;
//db_exec($strSQLInsert5 ,$conn);
}
if($frsize < '0' OR $specfrmesize < '0')
{
$strSQLExists = "select * from Ref_Fixed_Des Where Internal='".$specno."' AND Sc_No='".$pcno."' AND Seq_No='".$seqno."' AND Model='".$item."' ";
$rsExists = mysqli_query($conn,$strSQLExists);
$data501=mysqli_fetch_array($rsExists);
$norows2=mysqli_num_rows($rsExists);
if($norows2 > '0')
{
mysqli_query($conn,"SET NAMES 'utf8'");
$strSQLInsert5 = mysqli_query($conn,"UPDATE PO_Imp_F_Item SET
Description='".addslashes($data501["Description"])."',
SubItem1='".trim(addslashes($data501["SubItem1"]))."',
SubItem2='".trim(addslashes($data501["SubItem2"]))."',
SubItem3='".trim(addslashes($data501["SubItem3"]))."',
SubItem4='".trim(addslashes($data501["SubItem4"]))."',
Subitem5='".trim(addslashes($data501["Subitem5"]))."',
SubItem6='".trim(addslashes($data501["SubItem6"]))."',
Subval1='".trim(addslashes($data501["Subval1"]))."',
Subval2='".trim(addslashes($data501["Subval2"]))."',
Subval3='".trim(addslashes($data501["Subval3"]))."',
Subval4='".trim(addslashes($data501["Subval4"]))."',
Subval5='".trim(addslashes($data501["Subval5"]))."',
Subval6='".trim(addslashes($data501["Subval6"]))."'
WHERE LineNo='".$lineno."' ") ;
//echo $strSQLInsert5;
//db_exec($strSQLInsert5 ,$conn);
}
}
}
if ($catid == '962' OR $catid == '963' OR $catid == '1041' OR $catid == '1183')
{
$strSQLExists = "select * from ST_Item_Fixed Where Item_Code='".$item."' ";
//echo "select * from ST_Item_Fixed Where Item_Code='".$item."' ";
$rsExists = mysqli_query($conn,$strSQLExists);
$data502=mysqli_fetch_array($rsExists);
$strSQLInsert5 = mysqli_query($conn,"UPDATE PO_Imp_F_Item SET Description='".addslashes($data502["Description"])."'
WHERE LineNo='".$lineno."' ") ;
//echo $strSQLInsert5;
/*echo "UPDATE PO_Imp_F_Item SET Description='".addslashes($data502["Description"])."'
WHERE LineNo='".$lineno."' ";*/
//db_exec($strSQLInsert5 ,$conn);
}
///////////////////////////////
if($mdlgroup == '4')
{
if ($catid <> '962' OR $catid <> '963' OR $catid <> '1183')
{
$strSQLExists = "select * from ST_Item_Fixed Where Item_Code='".$item."' ";
$rsExists = mysqli_query($conn,$strSQLExists);
$data502=mysqli_fetch_array($rsExists);
$strSQLExists3 = "select * from Ref_parts_subitem Where Internal='".$catid."' ";
$rsExists3 = mysqli_query($conn,$strSQLExists3);
$data5030=mysqli_fetch_array($rsExists3);
$strSQLExists31 = "select * from Sc_Itemnot_Include Where Sc_No='".$pcno."' AND Seq_No='".$seqno."' ";
$rsExists31 = mysqli_query($conn,$strSQLExists31);
$mnorows=mysqli_num_rows($rsExists31);
$data50301=mysqli_fetch_array($rsExists31);
if($mnorows > '0')
{
$strSQLExists32 = "select * from SC_Item Where Sc_No='".$pcno."' AND Seq_No='".$seqno."' ";
$rsExists32 = mysqli_query($conn,$strSQLExists32);
$data50302=mysqli_fetch_array($rsExists32);
$specno=$data50302['Spec_No'];
$strSQLExists120 = "select * from Ref_Fixed_Des Where Internal='".$specno."' AND Sc_No='".$pcno."' AND Seq_No='".$seqno."' AND Model='".$item."' ";
$rsExists120 = mysqli_query($conn,$strSQLExists120,$conn);
$data120=mysqli_fetch_array($rsExists120);
$desc=$data120["Description"];
}
else
{
$desc=$data502["Description"];
}
mysqli_query($conn,"SET NAMES 'utf8'");
$strSQLInsert5 = mysqli_query($conn,"UPDATE PO_Imp_F_Item SET
Description='".addslashes($desc)."',
SubItem1='".trim(addslashes($data5030["SubItem1"]))."',
SubItem2='".trim(addslashes($data5030["SubItem2"]))."',
SubItem3='".trim(addslashes($data5030["SubItem3"]))."',
SubItem4='".trim(addslashes($data5030["SubItem4"]))."',
Subitem5='".trim(addslashes($data5030["Subitem5"]))."',
SubItem6='".trim(addslashes($data5030["SubItem6"]))."'
WHERE LineNo='".$lineno."' ") ;
//echo $strSQLInsert5;
//db_exec($strSQLInsert5 ,$conn);
}
}
////Cost INI Item///
$selcie=mysqli_query($conn,"SELECT price_us FROM PO_Imp_F_Item WHERE LineNo='$lineno'");
$rowcie=mysqli_fetch_assoc($selcie);
$Price=round($rowcie['price_us'],2);
$s=0;
$selcii=mysqli_query($conn,"SELECT JB_Price,LJ_Price FROM Cost_INI_Item WHERE Item_Code='$itemcode' AND Category='$catid' AND Category!='1041' AND Category!='1042' AND Category!='962' AND Category!='963' AND Category!='1183' AND Maker!='TRIDENT'");
$rowcii=mysqli_fetch_assoc($selcii);
$JB_Price=$rowcii['JB_Price'];
$LJ_Price=$rowcii['LJ_Price'];
if(($JB_Price!=0 && $JB_Price!='' && $Price!='' && $Price!=0 && $Price>$JB_Price) || ($LJ_Price!=0 && $LJ_Price!='' && $Price!='' && $Price!=0 && $Price>$LJ_Price)){
echo "SC:".$pcno." *** Seq:".$seqno." *** $itemcode *** Price:".$Price." *** JB Price:".$JB_Price." *** LJ Price:".$LJ_Price."";