HOME

0) { $message .= ' '; 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]; $ETABD =$_POST['frmeta'.$i]; if($checkstatus == "Yes" AND $weldingstatus == "Welded") { $xx="Unweld"; $message .= ' '; //$xx=$scno."-".$seqno."-".$checkstatus; //echo $xx; //echo "
"; $sqlupdate=mysqli_query($conn,"UPDATE SC_Item SET UNWLDFrame='Rear Triangle' 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 .= ' '; //$xx=$scno."-".$seqno."-".$checkstatus; //echo $xx; //echo "
"; $sqlupdate=mysqli_query($conn,"UPDATE SC_Item SET UNWLDFrame='' 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'"); } } $message .= '
SC # Seq No Status FC New Dlvy ETA
'. $scno .' '. $seqno .' '. $xx .' '. $FRmdlvy .' '. $ETABD .'
'. $scno .' '. $seqno .' '. $xx .' '. $FRmdlvy .' '. $ETABD .'
'; $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", "$message", $headers); } if($_POST['email12'] > '0') { $e2=$_POST['email12']; mail($e2, "$modelsubject", "$message", $headers); } if($_POST['email13'] > '0') { $e3=$_POST['email13']; mail($e3, "$modelsubject", "$message", $headers); } if($_POST['email14'] > '0') { $e4=$_POST['email14']; mail($e4, "$modelsubject", "$message", $headers); } if($_POST['email15'] > '0') { $e5=$_POST['email15']; mail($e5, "$modelsubject", "$message", $headers); } if($_POST['email16'] > '0') { $e6=$_POST['email16']; mail($e6, "$modelsubject", "$message", $headers); } //echo $email1; //$Item_Code=$_POST['Item_Code']; //$Type=$_POST['Type']; } ?>
Welding Allocation
Email2-
Email3-
Email4-
Email5-
Email6-

 

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; ?>

'0') { $status="Unweld"; } else { $status="Welded"; } ?>
Week #
From
To
 Total Steel Frames
Total Unweld
 TTL Days Unweld
FTY
PC #
Cust
Seq
Model
Model Meterial
SZ
Qty/Seq
PC1 Dlvry - Frames Rqrd by -
ETA In FTY
PC2-Dlvry
Nbr/Days
Qty/Day
SC Dlvry
Status

HOME