'0')
{
}
else
{
$i++;
$insertsql="INSERT INTO Temp_Fixed_Packing(Fixed_Inv_Internal,Item_Code,Item_Internal) Values('$internal','".addslashes($partid)."','$i') ";
$sqlinsert=mysqli_query($conn,$insertsql);
}
}
//echo $internal;I
//$bulk=$_POST['bulk'];
//$today = date("Y/m/d");
/*
if($fixed == 'F')
{
*/
$xx="";
foreach($country as $a => $b)
{
//print "$a = $b\n";
if($b > '0')
{
$aa=$a+1;
$sqlstr8 ="SELECT * FROM Temp_Fixed_Packing where Fixed_Inv_Internal='$internal' AND Item_Internal='$aa'";
$result8 = mysqli_query($conn,$sqlstr8);
$row78 = mysqli_fetch_array( $result8);
$itemcodepacking=$row78['Item_Code'];
$sqlstr81 ="SELECT * FROM ST_Item_Fixed where Item_Code='$itemcodepacking' ";
$result81 = mysqli_query($conn,$sqlstr81);
$row781 = mysqli_fetch_array( $result81);
$unit=$row781['Unit'];
////////////////////////////////////
$sqlstr812 ="SELECT * FROM Ref_FixedInvOrder where Item_Code='$itemcodepacking' AND Internal='$internal' ";
$result812 = mysqli_query($conn,$sqlstr812);
$row7812 = mysqli_fetch_array( $result812);
$orderqty=$row7812['sumqty'];
$sqlstr813 ="SELECT * FROM Ref_Fixed_INVTTL where Item_Code='$itemcodepacking' AND Fixed_Inv_Internal='$internal' ";
$result813 = mysqli_query($conn,$sqlstr813);
$row7813 = mysqli_fetch_array( $result813);
$packingnow=$row7813['sumqty']+$b;
//print "$aa = $b\n";
//print "$itemcodepacking = $b\n";
/////////////////////////////////////Insert data
if($b > '0' )
{
if($orderqty >= $packingnow)
{
$sqlinsert1=mysqli_query($conn,"INSERT INTO Fixed_Inv_Packing(Fixed_Inv_Internal,Item_Code,Qty,Item_Code_Int,Unit) VALUES('$internal','".addslashes($itemcodepacking)."','$b','$aa','$unit')");
}
}
///////////////////////////////////////////
//echo "
";
//$xx=$xx.",".$itemcodepacking;
//echo $xx;
}
/*
if($country[$a] != '0')
{
echo $country[$a];
}
if($country[$a] == "")
{
$country[$a]=0;
echo $country[$a];
}
*/
}
$itemm="";
$itemnm="";
$yy=0;
$sqlstr9 ="SELECT * FROM Fixed_Inv_Packing where Serial_No='0'";
$result9 = mysqli_query($conn,$sqlstr9);
while($row79 = mysqli_fetch_array( $result9))
{
$y++;
$itemcode=$row79['Item_Code'];
$sqlstr19 ="SELECT * FROM ST_Item_Fixed where Item_Code='$itemcode'";
$result19 = mysqli_query($conn,$sqlstr19);
$row179 = mysqli_fetch_array( $result19);
$cat=$row179['Category'];
$sqlstr19 ="SELECT * FROM ST_Item_Fixed where Item_Code='$itemcode'";
$result19 = mysqli_query($conn,$sqlstr19);
$row179 = mysqli_fetch_array( $result19);
$cat=$row179['Category'];
$sqlstr191 ="SELECT * FROM Parts where Internal='$cat'";
$result191 = mysqli_query($conn,$sqlstr191);
$row1791 = mysqli_fetch_array( $result191);
$itemname=$row1791['Item'];
$itemnm=$itemnm.",".$itemname;
$itemm=$itemm.",".$itemcode;
}
$strItemm = substr($itemm, 1);
$strItemmreplace = str_replace(",", "+", $strItemm);
$strItemm1 = substr($itemnm, 1);
$strItemmreplace1 = str_replace(",", "+", $strItemm1);
if($y > '1')
{
$sqlupdate=mysqli_query($conn,"UPDATE Fixed_Inv_Packing SET Unit='Sets' where Serial_No='0' ");
}
$sqlupdate=mysqli_query($conn,"UPDATE Fixed_Inv_Packing SET Item_Combine='".addslashes($strItemmreplace)."',Item_Combine_Int='".addslashes($strItemmreplace1)."',No_of_Items='".$y."' where Serial_No='0' ");
//////////////////////////////////////////////////////////////////
$sqlstr19 ="SELECT * FROM Fixed_Inv_Packing where Serial_No='0'";
$result19 = mysqli_query($conn,$sqlstr19);
while($row179 = mysqli_fetch_array( $result19))
{
$y++;
$itemcode=$row179['Item_Code'];
$Item_Combine=$row179['Item_Combine'];
$itemcombinename=$row179['Item_Combine_Int'];
$Unit=$row179['Unit'];
$fixedinternal=$row179['Fixed_Inv_Internal'];
$sqlstr30 ="SELECT * FROM PI_Imp_F_Head where Internal='$fixedinternal' ";
//echo $sqlstr29;
$result30= mysqli_query($conn,$sqlstr30);
$row379 = mysqli_fetch_array( $result30);
$invno=$row379['Invoice_No'];
$sqlstr29 ="SELECT * FROM Ref_FixedInvscwise where CUSPAR='$itemcode' AND RefNo='$invno' ";
//echo $sqlstr29;
$result29 = mysqli_query($conn,$sqlstr29);
while($row279 = mysqli_fetch_array( $result29))
{
$scno=$row279['Sc_No'];
//echo $scno;
$seqno=$row279['Seq_No'];
$sqlinsert2=mysqli_query($conn,"INSERT INTO Fixed_Inv_Packingscseq(Sc_No,Seq_No,Item_Code,Item_Code_Special,Unit,Fixed_inv_no,Item_Code_Name) VALUES('$scno','".addslashes($seqno)."','".addslashes($itemcode)."','".addslashes($Item_Combine)."','$Unit','$fixedinternal','".addslashes($itemcombinename)."')");
//$sqlinsert2=mysqli_query($conn,"INSERT INTO Fixed_Inv_Packingscseq(Sc_No,Seq_No) VALUES('$scno','".addslashes($seqno)."')");
}
}
////////////////////////////////////////////////////////////////////////////
$sqlstr10 ="SELECT Max(Serial_No) as maxserial FROM Fixed_Inv_Packing where Fixed_Inv_Internal='$internal' ";
$result10 = mysqli_query($conn,$sqlstr10);
$row10 = mysqli_fetch_array( $result10);
$serialnew=$row10['maxserial']+1;
$sqlupdate1=mysqli_query($conn,"UPDATE Fixed_Inv_Packing SET Serial_No='$serialnew' where Serial_No='0' ");
$sqlupdate2=mysqli_query($conn,"UPDATE Fixed_Inv_Packingscseq SET Serial_No='$serialnew' where Serial_No='0' ");
echo '';
?>