'".$_POST['mete']."')";
}
else{
$where="(Material <> '".$_POST['mete']."')";
}
}
//echo $where;
if($_POST['chkscno']<>"checkbox")
{
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));
if($_POST['yesmet']=="checkbox" OR $_POST['nomet2']=="checkbox" )
{
$sql6="Select sum(Quantity) as steelframe From Ref_WeldingNew1 where FTYETA Between '$weeknostart' AND '$newdate' AND $where";
}
else
{
$sql6="Select sum(Quantity) as steelframe From Ref_WeldingNew1 where FTYETA Between '$weeknostart' AND '$newdate' ";
}
// echo "Select * From Ref_Weekno_Master where Internal='".$_POST["chkdate1"]."'";
$result6=mysqli_query($conn,$sql6);
$record6=mysqli_fetch_array($result6);
$steelframe=$record6['steelframe'];
if($_POST['yesmet']=="checkbox" OR $_POST['nomet2']=="checkbox" )
{
$sql4="Select sum(Quantity) as unweld From Ref_WeldingNew1 where FTYETA Between '$weeknostart' AND '$newdate' AND Unweld='1' AND $where";
}
else
{
$sql4="Select sum(Quantity) as unweld From Ref_WeldingNew1 where FTYETA Between '$weeknostart' AND '$newdate' AND Unweld='1' ";
}
//echo $sql4;
//echo "
";
// echo "Select * From Ref_Weekno_Master where Internal='".$_POST["chkdate1"]."'";
$result4=mysqli_query($conn,$sql4);
$record4=mysqli_fetch_array($result4);
$ttlunwelded=$record4['unweld'];
if($_POST['yesmet']=="checkbox" OR $_POST['nomet2']=="checkbox" )
{
$sql5="Select sum(Quantity) as unweld From Ref_WeldingNew1 where FTYETA Between '$weeknostart' AND '$newdate' AND Unweld='2' AND $where";
}
else
{
$sql5="Select sum(Quantity) as unweld From Ref_WeldingNew1 where FTYETA Between '$weeknostart' AND '$newdate' AND Unweld='2' ";
}
// echo "Select * From Ref_Weekno_Master where Internal='".$_POST["chkdate1"]."'";
$result5=mysqli_query($conn,$sql5);
$record5=mysqli_fetch_array($result5);
$ttlRTunwelded=$record5['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;
?>