HOME

Welding allocation report View/Print

SC # Seq No Status '; for ($i=1;$i<=$NoofRow ;$i++ ) { $scno =$_POST['scno'.$i]; $seqno =$_POST['seqno'.$i]; $checkstatus =$_POST['checkstatus'.$i]; $weldingstatus =$_POST['status'.$i]; if($checkstatus == "Yes" AND $weldingstatus == "Welded") { $xx="Unweld"; $message .= ' '. $scno .' '. $seqno .' '. $xx .' '; //$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'"); } if($checkstatus == "Yes" AND $weldingstatus == "Unweld" ) { $xx="Welded"; $message .= ' '. $scno .' '. $seqno .' '. $xx .' '; //$xx=$scno."-".$seqno."-".$checkstatus; //echo $xx; //echo "
"; $sqlupdate=mysqli_query($conn,"UPDATE SC_Item SET UNWLDFrame='' WHERE Sc_No='$scno' AND Seq_No='$seqno'"); } } $message .= ' '; $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"; mail($email, "$modelsubject", "$message", $headers); ?> '".$_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