'0' && $SC > '0' && $SEQ > '0' && $FixedpoR > '0' && $SCline > '0' )
{
//echo "Good";
///////saving to Po fixed item table
$sqlstr="SELECT * FROM PO_Imp_F_Head where PO_No='$ponew'";
$result = mysqli_query($conn,$sqlstr);
$record = mysqli_fetch_array( $result ) ;
$pointernal=$record['Internal'];
$sqlstr5="SELECT * FROM Ref_FixedPoItem where LineNo='$SCline'";
$result5 = mysqli_query($conn,$sqlstr5);
$record5 = mysqli_fetch_array( $result5 ) ;
$scno=$record5["PCNo"];
$seqno=$record5["SeqNo"];
$internal=$record5["Internal"];
$rr=0;
$tt=0;
$sqlstr6="SELECT * FROM PO_Imp_F_Item where Internal='$internal' AND PCNo='$scno' AND SeqNo='$seqno'";
//echo $sqlstr6;
$result6 = mysqli_query($conn,$sqlstr6);
while($record6 = mysqli_fetch_array( $result6 ))
{
$catid=$record6['Cat_ID'];
$Item_Code=$record6['Item_Code'];
$Description=$record6['Description'];
$Unit=$record6['Unit'];
$Last_Price=$record6['Last_Price'];
$Unit_Price=$record6['Unit_Price'];
//$SiniRef=$record6['SiniRef'];
$SubItem1=$record6['SubItem1'];
$SubItem2=$record6['SubItem2'];
$SubItem3=$record6['SubItem3'];
$SubItem4=$record6['SubItem4'];
$Subitem5=$record6['Subitem5'];
$SubItem6=$record6['SubItem6'];
$Subval1=$record6['Subval1'];
$Subval2=$record6['Subval2'];
$Subval3=$record6['Subval3'];
$Subval4=$record6['Subval4'];
$Subval5=$record6['Subval5'];
$Subval6=$record6['Subval6'];
$price_us=$record6['price_us'];
$price_nt=$record6['price_nt'];
$price_bt=$record6['price_bt'];
$price_rnb=$record6['price_rnb'];
//$Subval6=$record6['Subval6'];
$sqlstr="SELECT * FROM PO_Imp_F_Head where PO_No='$ponew'";
$result = mysqli_query($conn,$sqlstr);
$record = mysqli_fetch_array( $result ) ;
$pointernal=$record['Internal'];
$sqlstr1="SELECT Max(SerialNo) as serial FROM PO_Imp_F_Item where Internal='$pointernal' ";
$result1 = mysqli_query($conn,$sqlstr1);
$record1 = mysqli_fetch_array( $result1 ) ;
$serialnonew=$record1['serial']+1;
$sqlstr2="SELECT * FROM Sc_Itemnot_Include where Sc_No='$SC' AND Seq_No='$SEQ' AND CatID='$catid'";
$result2 = mysqli_query($conn,$sqlstr2);
$record2 = mysqli_fetch_array( $result2 ) ;
$sciniitemlineno=$record2['LineNo'];
$sqlstr12="SELECT * FROM SC_Item where Sc_No='$SC' AND Seq_No='$SEQ' ";
$result12 = mysqli_query($conn,$sqlstr12);
$record12 = mysqli_fetch_array( $result12 ) ;
$color=$record12['Color'];
$qty=$record12['Quantity'];
if(mysqli_num_rows($result2) > '0')
{
$sqlstr22="SELECT * FROM PO_Imp_F_Item where PCNo='$SC' AND SeqNo='$SEQ' AND Cat_ID='$catid'";
$result22 = mysqli_query($conn,$sqlstr22);
if(mysqli_num_rows($result22) > '0')
{
$xx="Already Po Has This Item";
$tt++;
//echo $xx;
}
else
{
$sql1="INSERT INTO PO_Imp_F_Item (Internal,SerialNo,PCNo,SeqNo,Cat_ID,Item_Code,Description,Unit,Colour,Last_Price,Unit_Price,QTY,Final,SiniRef,SubItem1,SubItem2,SubItem3,SubItem4,SubItem5,SubItem6,Subval1,Subval2,Subval3,Subval4,Subval5,Subval6,price_us,price_nt,price_bt,price_rnb)
VALUES('$pointernal','$serialnonew','$SC','$SEQ','$catid','".trim(addslashes($Item_Code))."','".trim(addslashes($Description))."','$Unit'
,'".trim(addslashes($color))."','$Last_Price','$Unit_Price','$qty','1','$sciniitemlineno','".trim(addslashes($SubItem1))."','".trim(addslashes($SubItem2))."','".trim(addslashes($SubItem3))."','".trim(addslashes($SubItem4))."','".trim(addslashes($SubItem5))."','".trim(addslashes($SubItem6))."','".trim(addslashes($Subval1))."','".trim(addslashes($Subval2))."','".trim(addslashes($Subval3))."','".trim(addslashes($Subval4))."','".trim(addslashes($Subval5))."','".trim(addslashes($Subval6))."','$price_us','$price_nt','$price_bt','$price_rnb')";
$result=mysqli_query($conn,$sql1);
if($catid == '962')
{
$sq1="UPDATE Sc_Itemnot_Include SET Item_Code='".trim(addslashes($Item_Code))."' WHERE Sc_No='$SC' AND Seq_No='$SEQ' AND CatID='962'";
$result1=mysqli_query($conn,$sq1);
}
if($catid == '963')
{
$sq1="UPDATE Sc_Itemnot_Include SET Item_Code='".trim(addslashes($Item_Code))."' WHERE Sc_No='$SC' AND Seq_No='$SEQ' AND CatID='963'";
$result1=mysqli_query($conn,$sq1);
}
$sqlstr66="SELECT * FROM PO_Imp_F_Item where PCNo='$SC' AND SeqNo='$SEQ' AND Item_Code='$Item_Code' ";
//echo $sqlstr6;
$result66 = mysqli_query($conn,$sqlstr66);
$record66 = mysqli_fetch_array( $result66 );
$lineno=$record66['LineNo'];
$con1 =mysqli_connect("103.5.232.117","Admin","Fi20foX12R7E");
mysqli_select_db("FFxchina", $con1);
$sql1="INSERT INTO PO_Status (Sc_No,Seq_No,Internal1,Lineno,Po_Status)
VALUES('$SC','$SEQ','$pointernal','$lineno','1')";
$result=mysqli_query($conn,$sql1);
require ('dbcon.php');
$yy="Save Done";
$rr++;
//echo $yy;
}
}
else
{
$dd=$SC."-".$SEQ;
$qq="This $dd has NO INI Selected.";
}
}
}
else
{
if($ponew < '0' )
{
$x="Please Select The PO";
//echo $x;
}
if($SC < '0' )
{
$x1="Please Select The SC NO";
//echo $x;
}
if($FixedpoR < '0' )
{
$x2="Please Select The Repeat PO";
//echo $x;
}
if($SCline < '0' )
{
$x3="Please Select The Repeat SC SEQ";
//echo $x;
}
}
}
?>
Fixed PO Repeat Item
'0')
{
echo $x;
echo "
";
}
if($x1 > '0')
{
echo $x1;
echo "
";
}
if($x2 > '0')
{
echo $x2;
echo "
";
}
if($x3 > '0')
{
echo $x3;
echo "
";
}
if($tt > '0')
{
echo $xx;
echo "
";
}
if($rr > '0')
{
echo $yy;
echo "
";
}
if($qq> '0')
{
echo $qq;
echo "
";
}
?>
Back to FIXED PO LIST