HOME
Actual WPP Report
Week # |
From |
To |
Unwelded |
Welded |
Qty |
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));
$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 weld From Ref_WeldingNew1weld 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);
$ttlwelded=$record4['weld'];
$ttlframes=$ttlunwelded+$ttlwelded;
?>
|
|
|
|
|
|
}
//echo $_POST["FDate2"];;
?>