";
$Todt=$_POST['scnoto'];
//echo $Todt;
$sql1="Select * From Ref_Weekno_Master where Internal='".$fromdt."'";
$result1=mysqli_query($conn,$sql1);
$record1=mysqli_fetch_array($result1);
$stdate=$record1["From_Date"];
$stdate1=$record1["From_Date"];
//$weekyear=$record1["yearno"];
$sql2="Select * From Ref_Weekno_Master where Internal='".$Todt."'";
// echo $sql2;
$result2=mysqli_query($conn,$sql2);
$record2=mysqli_fetch_array($result2);
$enddate2=$record2["To_Date"];
$newdate = strtotime ( '-1 day' , strtotime ( $enddate2 ) ) ;
$newdate = date ( 'Y-m-j' , $newdate );
$enddate=$newdate;
//echo $enddate;
if ($_POST["chkdate3"]=="checkbox")
{
$FDate=$stdate;
$TDate=$enddate;
$where="FRMpc2dlvy>='".$FDate."' AND FRMpc2dlvy<='".$TDate."'";
}
/*
if ($_POST["yesmet"]=="checkbox")
if (strlen(trim($where))>0)
$where=$where." AND (". "Material='".$_POST["mete"]."' )";
else
$where=" (". "Material='".$_POST["mete"]."' )";
*/
//echo $where;
?>
Welding Capacity (
Home)
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Capacity |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
WK Days |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
WK # |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(dt frm->to) |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(ttl Qty) |
";
$result7=mysqli_query($conn,$sql7);
while($record7=mysqli_fetch_array($result7))
{
//$weeks1=date('m/d',strtotime($record6['From_Date']));
$stdate=$record7['From_Date'];
$enddate1=$record7['To_Date'];
$newdate = strtotime ( '-1 day' , strtotime ( $enddate1 ) ) ;
$newdate = date ( 'Y-m-j' , $newdate );
$enddate=$newdate;
$ttlqty=0;
$ttlqtyr=0;
$qty1=0;
$sql8="Select * From Ref_Welding_Capacity where FRMpc2dlvy between '$stdate' AND '$enddate' AND Unweld = '1' ";
//echo $sql8;
//echo "
";
$result8=mysqli_query($conn,$sql8);
while($record8=mysqli_fetch_array($result8))
{
$qty1=$record8['Quantity'];
$ttlqty=$ttlqty+$qty1;
//$qtyy=$record8['sumqty'];
}
$qty9=0;
$newrw=0;
$newrw1=0;
$nttl=0;
$ttlqtyrw=0;
$sql9="Select * From Ref_Welding_Capacity where FRMpc2dlvy between '$stdate' AND '$enddate' AND Unweld = '2' ";
//echo $sql9;
//echo "
";
$result9=mysqli_query($conn,$sql9);
while($record9=mysqli_fetch_array($result9))
{
$qty9=$record9['Quantity'];
$ttlqtyrw=$ttlqtyrw+$qty9;
//$qtyy=$record8['sumqty'];
}
$newrw=($ttlqtyrw*30)/100;
$newrw1=$ttlqtyrw-$newrw;
$nttl=$ttlqty+$newrw1;
//echo $newrw1;
?>
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Bal |
'0' ";
//echo $sql8;
$result8=mysqli_query($conn,$sql8);
while($record8=mysqli_fetch_array($result8))
{
$qty1=$record8['Quantity'];
//echo $qty1;
$ttlqty=$ttlqty+$qty1;
//$qtyy=$record8['sumqty'];
}
$sql6="Select count(Internal) as holi From BD_Holidays where BD_Holiday_Date between '$frmdate' AND '$todate'";
$result6=mysqli_query($conn,$sql6);
$record6=mysqli_fetch_array($result6);
$newcount=$record6['holi'];
//echo $newcount;
$noworkingdays=6-$newcount;
$qtyweek=350*$noworkingdays;
//echo $qtyweek;
$bal=$qtyweek-$ttlqty;
?>
|
PC # |
Seq No |
Cust |
Mdl |
Meterial |
Size |
Qty/Seq |
Status |
PC1 Dlvy |
ETA Corvo |
PC2 Dlvy |
NBR Days |
SC Dlvy |
1st FC ETD |
1st FC ETA |
|
|
0)
$where=$where." AND (". "Material='".$_POST["mete"]."' )";
else
$where=" (". "Material='".$_POST["mete"]."' )";
*/
//if($xx == "")
//{
//Material
if ($_POST["yesmet"]=="checkbox")
{
if ($_POST["mete"]=="AL")
{
$sql5="Select * From Ref_Welding_Capacity where $where AND Material='AL' AND Unweld <> '0' order by FRMpc2dlvy,Sc_No,Seq_No";
}
if ($_POST["mete"]=="Steel")
{
$sql5="Select * From Ref_Welding_Capacity where $where AND Material <> 'AL' AND Unweld <> '0' order by FRMpc2dlvy,Sc_No,Seq_No";
}
}
else
{
$sql5="Select * From Ref_Welding_Capacity where $where AND Unweld <> '0' order by FRMpc2dlvy,Sc_No,Seq_No";
}
//}
//echo $sql5;
$result5=mysqli_query($conn,$sql5);
while($record5=mysqli_fetch_array($result5))
{
$pcno=$record5['Sc_No'];
$seqno=$record5['Seq_No'];
$cust=$record5['NickName'];
$mdl=$record5['Model_Name'];
$meterial=$record5['Material'];
//echo $meterial;
$size=$record5['Size'];
$qty=$record5['Quantity'];
$welstatus=$record5['Unweld'];
if($welstatus == '1')
{
$welstatus="Unweld";
}
if($welstatus == '2')
{
$welstatus="RT-Unweld";
}
$pc1dlvy=$record5['Delivery_Date'];
$etacorvo=$record5['FTYETA'];
$pc2dlvy=$record5['FRMpc2dlvy'];
$sql20="Select * From SC_Item where Sc_No='$pcno' AND Seq_No='$seqno' ";
//echo $sql9;
$result20=mysqli_query($conn,$sql20);
$record20=mysqli_fetch_array($result20);
$eta1FC=$record20['ETA1'];
$etd1FC=$record20['ETD1'];
//$sql19="Select * From Ref_Weekno_Master where From_Date <= '$pc2dlvy' AND To_Date >= '$pc2dlvy' ";
//$sql19="Select * From Ref_Weekno_Master where From_Date <= '$pc2dlvy' AND To_Date >= '$pc2dlvy' ";
//$sql19="Select * From Ref_Weekno_Master where From_Date <= '$pc2dlvy' AND To_Date >= '$pc2dlvy' ";
//start_date <= '". format_date_db($start_date) ."' AND end_date >= '". format_date_db($start_date) ."'
$sql19="Select * From Ref_Weekno_Master where From_Date <= '$pc2dlvy' AND New_To_Date >= '$pc2dlvy' ";
//echo $sql9;
$result19=mysqli_query($conn,$sql19);
$record19=mysqli_fetch_array($result19);
$fromdatee=$record19['From_Date'];
$too=$record19['New_To_Date'];
/*
$sql22="Select sum(Quantity) as sumqty From Ref_Welding_Capacity where FRMpc2dlvy Between '$fromdatee' AND '$too' AND Unweld <> '0' order by FRMpc2dlvy,Sc_No,Seq_No";
//echo $sql9;sum
$result22=mysqli_query($conn,$sql22);
$record22=mysqli_fetch_array($result22);
$ttlqty=$record22[''];
*/
//echo $sql9;
$weekint=$record19['Internal'];
$xx=$weekint;
//echo $xx;
//echo "
";
if($weekint%2 == 0)
{
$color="#E1FFC4";
}
else
{
$color="#CCFFFF";
}
$scdlvy=$record5['Shpt_Before'];
$date1Timestamp = strtotime($pc2dlvy);
$date2Timestamp = strtotime($etacorvo);
$differencedays = $date1Timestamp - $date2Timestamp;
$dayss=floor($differencedays/3600/24);
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
= '$pc2dlvy' ";
//echo $sql8;
$result19=mysqli_query($conn,$sql19);
$record19=mysqli_fetch_array($result19);
$weekno=$record19['Internal'];
if($weekno%2==0)
{
$color="#E1FFC4";
}
else
{
$color="#CCFFFF";
}
$xx=$scno."-".$frmpc2dlvy."-".$weekno;
for($a = $fromdt; $a <= $Todt; $a += 1)
{
?>
= $datefrom) && ($frmpc2dlvy <= $dateto))if(
if( $a == $weekno)
{
?>
|
|
