";
$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);
}
}
}
}
}
}
//echo '';
}////////
$sqlnewa=mysqli_query($conn,"SELECT * FROM IBWS_Payment_Main Where Inv_No='".$invno."'");
$rowsa=mysqli_fetch_array($sqlnewa);
$inpminus=$rowsa["Inv_plusminus"];
$ttl=$rowsa["TTL_Amt"];
$ttlinvbd=$inpminus+$ttl;
//mysqli_connect("system.corvoltd.com", "Admin", "Fi20foX12R7E@tw") or die(mysqli_error());
//mysqli_select_db("firefoxbd") or die(mysqli_error());
$sqlnewb=mysqli_query($conn,"SELECT * FROM Ibws_Head_Inv Where Inv_No='".$invno."'");
$rowsb=mysqli_fetch_array($sqlnewb);
$internal=$rowsb["Internal"];
$sqlnewc=mysqli_query($conn,"SELECT * FROM Ref_IBWS_INVTTL Where Inv_No='".$invno."'");
$rowsc=mysqli_fetch_array($sqlnewc);
$ttlpartschina=$rowsc['ttlnew'];
$sqlnewd=mysqli_query($conn,"SELECT * FROM IBWS_spares_Ttl Where Inv_No='".$invno."'");
$rowsd=mysqli_fetch_array($sqlnewd);
$ttlspartschina=$rowsd['ttlsp'];
$sqlnewe=mysqli_query($conn,"select sum(plus_minus) as sumpm FROM Ibws_Inv_Plus_Minus WHERE internal='$internal'");
$rowse=mysqli_fetch_array($sqlnewe);
$ttpm=$rowse['sumpm'];
$ttlchina=$ttpm+$ttlpartschina+$ttlspartschina;
//mysqli_connect("system.corvoltd.com", "Admin", "Fi20foX12R7E@tw") or die(mysqli_error());
//mysqli_select_db("firefoxbd") or die(mysqli_error());
if($ttlchina == $ttlinvbd )
{
$sqlnewe=mysqli_query($conn,"SELECT * FROM Ibws_Head_Inv Where Inv_No='".$invno."'");
$rowse=mysqli_fetch_array($sqlnewe);
$sqlnewf=mysqli_query($conn,"SELECT * FROM IBWS_Payment_Main Where Inv_No='$invno'");
$rowsf=mysqli_fetch_array($sqlnewf);
$updatenew=mysqli_query($conn,"UPDATE Ibws_payment_Duedates_Input SET
Fty='".$rowse["Tittle"]."',
ETD='".$rowse["Etd"]."',
ETA='".$rowse["Eta"]."',
Amt='".$rowsf["TTL_Amt"]."',
Title='".$rowse["InvoiceTo"]."'
WHERE Cont_No='".$invno."' ");
$Information="Please Enter the Bank details and Due Dates for INV- $invno ";
//echo $Information;
$modelsubject="Please Enter Due dates for - IBWS INV:$invno ";
$from="duedates_erp_sys@corvoltd.com";
$eol = PHP_EOL;
$headers = "From: ".$from.$eol;
$headers .= "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
$email1="umanga@corvoltd.com";
$email2="sujeewa@corvoltd.com";
$email3="amy@intrend.com.tw";
//$email4="sujeewa@corvoltd.com";
mail($email1, "$modelsubject", "$Information", $headers);
mail($email2, "$modelsubject", "$Information", $headers);
mail($email3, "$modelsubject", "$Information", $headers);
//mail($email4, "$modelsubject", "$Information", $headers);
echo "You Will Redirecting Soon.";
echo '';
}
else
{
$Information="Need To Sync Data From China side to BD Side For Duedates Input for $invno ";
//echo $Information;
$modelsubject="Need To Sync Data From China side to BD Side For Duedates Input for $invno ";
$from="Sync_notifi_erp_sys@corvoltd.com";
$eol = PHP_EOL;
$headers = "From: ".$from.$eol;
$headers .= "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
$email1="umanga@corvoltd.com";
$email2="sujeewa@corvoltd.com";
mail($email1, "$modelsubject", "$Information", $headers);
mail($email2, "$modelsubject", "$Information", $headers);
echo "";
echo "Data Sysnc Need to be done From China Side to Bd side.Notification Email has been send to the Admin Automatically.Your Will be reply by admin on 20 minites.";
echo "";
echo '';
}
?>
Back To Home