1)
{
$deletesql=mysqli_query($conn,"DELETE FROM IBWS_Payment_Main WHERE Inv_No='$invno' ");
$deletesql1=mysqli_query($conn,"DELETE FROM IBWS_Inv_SCwise WHERE Inv_No='$invno' ");
$deletesql2=mysqli_query($conn,"DELETE FROM IBWS_Inv_SCwisespttl WHERE Inv_No='$invno' ");
$deletesql2=mysqli_query($conn,"DELETE FROM IBWS_Bcharge WHERE line='$linee' ");
}
$result3 = mysqli_query($conn,"SELECT * FROM IBWS_Payment_Main WHERE Inv_No='$invno'") or die(mysqli_error());
$norows=mysqli_num_rows($result3);
//$norows44=mysqli_num_rows($result44);
if($norows == 0)
{
$result = mysqli_query($conn,"SELECT * FROM TTest_copy WHERE Inv_No='$invno'") or die(mysqli_error());
while($row = mysqli_fetch_array( $result ))
{
if ( $row['sump'] == $row['ST_Partss'] && $row['sums'] == $row['stssum'] )
{
$invno1=$row['Inv_No'];
$idate=$row['Inv_Date'];
$Parts=$row['sump'];
$sqlstr121="Select count(*) as countrec from IBWS_Payment_Main where Inv_No='$invno1' ";
//echo $sqlstr121;
$result121=mysqli_query($conn,$sqlstr121);
while($record=mysqli_fetch_array($result121))
{
if ( $record['countrec'] != 1)
{
///////////////////////////////////////////////////////////
$sqlstr122="Select * from Payment_IBWS_Maininfo where Inv_No='$invno1' ";
//echo $sqlstr121;
$result122=mysqli_query($conn,$sqlstr122);
$record11=mysqli_fetch_array($result122);
// mysql("103.5.232.117", "Admin", "Fi20foX12R7E") or die(mysqli_error());
require ('dbcon1.php'); // or die(mysqli_error());
$sqlstr60 ="SELECT * FROM Ref_IBWS_INVTTL WHERE Inv_No='$invno1' ";
//echo $sqlstr;
$result60 = mysqli_query($conn,$sqlstr60);
$record60 = mysqli_fetch_array( $result60 );
$ttlvalue=$record60['ttlnew'];
$sqlstr62 ="SELECT * FROM Ibws_Head_Inv WHERE Inv_No='$invno1' ";
//echo $sqlstr;
$result62 = mysqli_query($conn,$sqlstr62);
$record62 = mysqli_fetch_array( $result62 );
$Internalibws=$record62['Internal'];
$sqlstr61 ="SELECT sum(plus_minus) as pmsum FROM Ibws_Inv_Plus_Minus WHERE internal='$Internalibws' ";
//echo $sqlstr;
$result61 = mysqli_query($conn,$sqlstr61);
$record61 = mysqli_fetch_array( $result61 );
$plusminussum=$record61['pmsum'];
require ('dbcon.php');
$internal=$record11['Internal'];
$fty=$record11['Tittle'];
$plusminus=$plusminussum;
$pval=$ttlvalue;
$sparesval=$record11['sparesval'];
$ttlamt=$pval+$sparesval;
if($Parts == '0')
{
$sqlstr133="Select * from Payment_IBWS_Spares where Inv_No='$invno1' ";
//echo $sqlstr133;
$result133=mysqli_query($conn,$sqlstr133);
$record3=mysqli_fetch_array($result133);
//$Inv_No=$record3['Inv_No'];
$Total_value=$record3['sparesval'];
//echo $Total_value;
$sparesval=$Total_value;
$ttlamt=$Total_value;
}
$sqlstr1221="Select * from Factory where Fty_ID='$fty' ";
$result1221=mysqli_query($conn,$sqlstr1221);
$record111=mysqli_fetch_array($result1221);
///////////////////////
/*
$sqlstr33="Select * from IBWS_Invplusminus where Inv_No='$invno1' ";
$result33=mysqli_query($conn,$sqlstr33);
$record33=mysqli_fetch_array($result33);
$inplusminus=$record33['plusminusval'];
*/
/////////////////////////
$fnickname=$record111['NickName'];
$creditdays=$record111['Dept1'];
if($creditdays != "")
{
$newdate = strtotime ( $creditdays.'days' , strtotime ( $idate ) ) ;
$newdate = date ( 'Y-m-j' , $newdate );
}
/////////////////////////////////////////////////////
if(mysqli_num_rows(mysqli_query($conn,"SELECT * FROM IBWS_Payment_Main WHERE Inv_No= '$invno1' ")))
{
//$i++;
$sqlstr1114 = "UPDATE IBWS_Payment_Main SET
Inv_plusminus='".$plusminus."',
Parts_Value='".$pval."',
Spares_Value='".$sparesval."',
TTL_Amt='$ttlamt'
where Inv_No= '$invno1'";
//echo $sqlstr114;
//echo "
";
$result1114 = mysqli_query($conn,$sqlstr1114);
}
else
{
//$i++;
$sql5=mysqli_query($conn,"Select * from Container_Head where ContainerNo='$invno1' ");
$resultt=mysqli_fetch_array($sql5);
$importterms=$resultt['Import_terms'];
$sqlstr1 = "INSERT INTO IBWS_Payment_Main(Inv_No,Inv_Date,Internal,Factory,Paymnt_Due,Inv_plusminus,Parts_Value,Spares_Value,TTL_Amt,Cash_Duedate,Import_Terms) VALUES('$invno1','$idate','$internal','$fnickname','$newdate','$plusminus','$pval','$sparesval','$ttlamt','$newdate','$importterms')" ;
$result11 = mysqli_query($conn,$sqlstr1);
}
//////
//////////////////////////////////////////////////////////////////////////////////////////////////
$sqlstr133="Select * from Payment_IBWS_P_SCseq where Inv_No='$invno1' ";
//echo $sqlstr121;
$result133=mysqli_query($conn,$sqlstr133);
while($record3=mysqli_fetch_array($result133))
{
$Inv_No=$record3['Inv_No'];
$Total_value=$record3['sumvalsc'];
$Sc_No=$record3['Sc_No'];
$Seq_No=$record3['Seq_No'];
$Ship_No=$record3['Ship_No'];
//$lineno=$record3['LineNo'];
$sqlstr1334="Select * from IBWS_Payment_Main where Inv_No='$invno1' ";
//echo $sqlstr121;
$result1334=mysqli_query($conn,$sqlstr1334);
$record34=mysqli_fetch_array($result1334);
$lineno=$record34['Line'];
if(mysqli_num_rows(mysqli_query($conn,"SELECT * FROM IBWS_Inv_SCwise WHERE Inv_No= '$Inv_No' AND Sc_No='$Sc_No' AND Seq_No='$Seq_No' AND Ship_No='$Ship_No' ")))
{
//$i++;
/*
$sqlstr1114 = "UPDATE IBWS_Inv_SCwise SET
Total_value='$Total_value'
where Inv_No= '$Inv_No' AND Sc_No='$Sc_No' AND Seq_No='$Seq_No' AND Ship_No='$Ship_No' ";
//echo $sqlstr114;
//echo "
";
$result1114 = mysqli_query($conn,$sqlstr1114);
*/
}
else
{
//$i++;
$sqlstr1 = "INSERT INTO IBWS_Inv_SCwise(Inv_No,Total_value,Sc_No,Seq_No,Ship_No,lineibws) VALUES('$Inv_No','$Total_value','$Sc_No','$Seq_No','$Ship_No','$lineno')" ;
$result11 = mysqli_query($conn,$sqlstr1);
}
}
//////////////////////////////////////////////////////////////////////////////////////////////////
$sqlstr133="Select * from Payment_IBWS_SP_SCseq where Inv_No='$invno1' ";
//echo $sqlstr121;
$result133=mysqli_query($conn,$sqlstr133);
while($record3=mysqli_fetch_array($result133))
{
$Inv_No=$record3['Inv_No'];
$Total_value=$record3['spval'];
$Sc_No=$record3['Sc_No'];
$Seq_No=$record3['Seq_No'];
$Ship_No=$record3['Ship_No'];
//$lineno=$record3['LineNo'];
$sqlstr1334="Select * from IBWS_Payment_Main where Inv_No='$invno1' ";
//echo $sqlstr121;
$result1334=mysqli_query($conn,$sqlstr1334);
$record34=mysqli_fetch_array($result1334);
$lineno=$record34['Line'];
if(mysqli_num_rows(mysqli_query($conn,"SELECT * FROM IBWS_Inv_SCwisespttl WHERE Inv_No= '$Inv_No' AND Sc_No='$Sc_No' AND Seq_No='$Seq_No' AND Ship_No='$Ship_No' ")))
{
//$i++;
/*
$sqlstr1114 = "UPDATE IBWS_Inv_SCwisespttl SET
Total_value='$Total_value'
where Inv_No= '$invno1' AND Sc_No='$Sc_No' AND Seq_No='$Seq_No' AND Ship_No='$Ship_No'";
//echo $sqlstr114;
//echo "
";
$result1114 = mysqli_query($conn,$sqlstr1114);
*/
}
else
{
//$i++;
$sqlstr1 = "INSERT INTO IBWS_Inv_SCwisespttl(Inv_No,Total_value,Sc_No,Seq_No,Ship_No,lineibws) VALUES('$Inv_No','$Total_value','$Sc_No','$Seq_No','$Ship_No','$lineno')" ;
$result11 = mysqli_query($conn,$sqlstr1);
}
}
}
}
}
}
/////////////////////////////////Input Duedate Information
$sql2=mysqli_query($conn,"SELECT * FROM Ibws_Head_Inv WHERE Inv_No='$invno'");
$recs=mysqli_fetch_array($sql2);
$sql20=mysqli_query($conn,"SELECT * FROM IBWS_Payment_Main WHERE Inv_No='$invno'");
$recs20=mysqli_fetch_array($sql20);
$ttlamount=$recs20['TTL_Amt'];
$plusminusa=$recs20['Inv_plusminus'];
$ttlinv=$ttlamount+$plusminusa;
$sqlinsert=mysqli_query($conn,"INSERT INTO Ibws_payment_Duedates_Input(Cont_No,Fty,ETD,ETA,Amt,Title) Values('$invno','".$recs['Tittle']."','".$recs['Etd']."','".$recs['Eta']."','$ttlinv','".$recs['InvoiceTo']."')");
}////////
/////////////////////////////////
?>