| FTY |
SC # |
Seq No |
Cust |
Model |
Meterial |
Qty |
Old Status |
New Status |
FC New Dlvy(Old) |
FC New Dlvy(New) |
ETA |
';
for ($i=1;$i<=$NoofRow ;$i++ )
{
$scno =$_POST['scno'.$i];
$seqno =$_POST['seqno'.$i];
$checkstatus =$_POST['checkstatus'.$i];
$weldingstatus =$_POST['status'.$i];
$FRmdlvy =$_POST['frmdlvy'.$i];
$FRmdlvyold =$_POST['frmdlvyold'.$i];
$ETABD =$_POST['frmeta'.$i];
$sqlstr1040 ="SELECT * FROM PC_Head WHERE Sc_No='".$scno."' AND Pc_No='1'";
$result1040 = mysqli_query($conn,$sqlstr1040);
$record1040 = mysqli_fetch_array( $result1040 );
$ftyid=$record1040['fty_ID'];
$sqlstr1041 ="SELECT * FROM Factory WHERE Fty_ID='".$ftyid."' ";
$result1041 = mysqli_query($conn,$sqlstr1041);
$record1041 = mysqli_fetch_array( $result1041);
$ftynick=$record1041['NickName'];
$sqlstr1035 ="SELECT * FROM Sc_Head WHERE Sc_No='".$scno."' ";
$result1035 = mysqli_query($conn,$sqlstr1035);
$record1035 = mysqli_fetch_array( $result1035 );
$custid=$record1035['Cst_ID'];
$sqlstr1036 ="SELECT * FROM Customer WHERE Cst_ID='".$custid."' ";
$result1036 = mysqli_query($conn,$sqlstr1036);
$record1036 = mysqli_fetch_array( $result1036 );
$custnick=$record1036['NickName'];
$sqlstr1034 ="SELECT * FROM SC_Item WHERE Sc_No='".$scno."' AND Seq_No='".$seqno."' ";
$result1034 = mysqli_query($conn,$sqlstr1034);
$record1034 = mysqli_fetch_array( $result1034 );
$modelno=$record1034['Model_No'];
$qty=$record1034['Quantity'];
$sqlstr1037 ="SELECT * FROM BD_Model WHERE Model_No='".$modelno."' ";
$result1037 = mysqli_query($conn,$sqlstr1037);
$record1037 = mysqli_fetch_array( $result1037 );
$modelname=$record1037['Model_Name'];
$meterial=$record1037['Material'];
if($checkstatus == "Yes" AND $weldingstatus == "Welded")
{
$xx="Unweld";
$message .= '
| '. $ftynick .' |
'. $scno .' |
'. $seqno .' |
'. $custnick .' |
'. $modelname .' |
'. $meterial .' |
'. $qty .' |
'. $weldingstatus .' |
'. $xx .' |
'. $FRmdlvyold .' |
'. $FRmdlvy .' |
'. $ETABD .' |
';
//$xx=$scno."-".$seqno."-".$checkstatus;
//echo $xx;
//echo "
";
$sqlupdate=mysqli_query($conn,"UPDATE SC_Item SET UNWLDFrame='Rear Triangle',Unweld='1' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
// echo "UPDATE SC_Item SET UNWLDFrame='Rear Triangle' AND Unweld='1' WHERE Sc_No='$scno' AND Seq_No='$seqno'";
$sqlupdate1=mysqli_query($conn,"UPDATE SC_Item SET Corvo_Dlvy='$FRmdlvy' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
}
if($checkstatus == "Yes" AND $weldingstatus == "Unweld" )
{
$xx="Welded";
$message .= '
| '. $ftynick .' |
'. $scno .' |
'. $seqno .' |
'. $custnick .' |
'. $modelname .' |
'. $meterial .' |
'. $qty .' |
'. $weldingstatus .' |
'. $xx .' |
'. $FRmdlvyold .' |
'. $FRmdlvy .' |
'. $ETABD .' |
';
//$xx=$scno."-".$seqno."-".$checkstatus;
//echo $xx;
//echo "
";
$sqlupdate=mysqli_query($conn,"UPDATE SC_Item SET UNWLDFrame='',Unweld='0' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
$sqlupdate1=mysqli_query($conn,"UPDATE SC_Item SET Corvo_Dlvy='$FRmdlvy' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
}
if($FRmdlvy <> $FRmdlvyold )
{
if($checkstatus == "Yes" AND $weldingstatus == "Welded" OR $checkstatus == "Yes" AND $weldingstatus == "Unweld")
{
}
else
{
$sqlupdate1=mysqli_query($conn,"UPDATE SC_Item SET Corvo_Dlvy='$FRmdlvy' WHERE Sc_No='$scno' AND Seq_No='$seqno'");
$xx="Unweld";
$message .= '
| '. $ftynick .' |
'. $scno .' |
'. $seqno .' |
'. $custnick .' |
'. $modelname .' |
'. $meterial .' |
'. $qty .' |
'. $weldingstatus .' |
'. $weldingstatus.' |
'. $FRmdlvyold .' |
'. $FRmdlvy .' |
'. $ETABD .' |
';
// }
}
}
}
$message .= '
|
|
|
|
|
';
$remarks=$_POST['textareaR'];
//echo $remarks;
//echo $message;
if($remarks > '0')
{
$Rmks="Remarks:".$remarks;
}
$Information=$message."".$Rmks;
$from="welding_erp_sys@corvoltd.com";
$modelsubject="Welding Allocation Status Report";
$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";
$email="umanga@corvoltd.com";
if($_POST['email11'] > '0')
{
$e1=$_POST['email11'];
mail($e1, "$modelsubject", "$Information", $headers);
}
if($_POST['email12'] > '0')
{
$e2=$_POST['email12'];
mail($e2, "$modelsubject", "$Information", $headers);
}
if($_POST['email13'] > '0')
{
$e3=$_POST['email13'];
mail($e3, "$modelsubject", "$Information", $headers);
}
if($_POST['email14'] > '0')
{
$e4=$_POST['email14'];
mail($e4, "$modelsubject", "$Information", $headers);
}
if($_POST['email15'] > '0')
{
$e5=$_POST['email15'];
mail($e5, "$modelsubject", "$Information", $headers);
}
if($_POST['email16'] > '0')
{
$e6=$_POST['email16'];
mail($e6, "$modelsubject", "$Information", $headers);
}
//echo $email1;
//$Item_Code=$_POST['Item_Code'];
//$Type=$_POST['Type'];
?>
Welding allocation report View/Print
'".$_POST['mete']."')";
}
else{
$where="(Material <> '".$_POST['mete']."')";
}
}
*/
//echo $where;
for($i=$weekno1 ; $i <= $weekno2 ; $i++)
{
$sql3="Select * From Ref_Weekno_Master where Week_No='".$i."' AND yearno='$weekyear'";
// echo "Select * From Ref_Weekno_Master where Internal='".$_POST["chkdate1"]."'";
$result3=mysqli_query($conn,$sql3);
$record3=mysqli_fetch_array($result3);
$weeknostart=$record3["From_Date"];
$weekstartfor=date('d-M', strtotime($weeknostart));
$weeknoend=$record3["To_Date"];
$newdate = strtotime ( '-1 day' , strtotime ( $weeknoend ) ) ;
$newdate = date ( 'Y-m-j' , $newdate );
$weekendfor=date('d-M', strtotime($newdate));
$sql6="Select sum(Quantity) as steelframe From Ref_WeldingNew1 where FTYETA Between '$weeknostart' AND '$newdate' AND Material<>'AL'";
// echo "Select * From Ref_Weekno_Master where Internal='".$_POST["chkdate1"]."'";
$result6=mysqli_query($conn,$sql6);
$record6=mysqli_fetch_array($result6);
$steelframe=$record6['steelframe'];
$sql4="Select sum(Quantity) as unweld From Ref_WeldingNew1unweld where FTYETA Between '$weeknostart' AND '$newdate'";
// echo "Select * From Ref_Weekno_Master where Internal='".$_POST["chkdate1"]."'";
$result4=mysqli_query($conn,$sql4);
$record4=mysqli_fetch_array($result4);
$ttlunwelded=$record4['unweld'];
/*
$sql4="Select sum(Quantity) as steelframe From Ref_WeldingNew1 where FTYETA Between '$weeknostart' AND '$newdate' AND Material='Steel'";
// echo "Select * From Ref_Weekno_Master where Internal='".$_POST["chkdate1"]."'";
$result4=mysqli_query($conn,$sql4);
$record4=mysqli_fetch_array($result4);
$ttlwelded=$record4['weld'];
*/
$ttlframes=$ttlunwelded+$ttlwelded;
?>