";
$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='".trim(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