Frame Dlvy ADD/EDIT
Only For Frames
SC No
Seq No
FTY
Model
Size
Qty
Total Order
PC2 Dlvy
PC1 Dlvy
ETA BD
ETA IN FTY
Status
ETD China
ETA
'0' order by Sc_No,Seq_No "; $result100 = mysqli_query($conn,$sqlstr100); $scttlqty1=""; while($record100 = mysqli_fetch_array( $result100 )) { $noofrow++; $scno=$record100['Sc_No']; $seqno=$record100['Seq_No']; $model=$record100['Model_Name']; $size=$record100['Size']; $qty=$record100['Quantity']; //$pc2dlvy=$record100['Model_Name']; $pc1dlvy=$record100['Delivery_Date']; $sqlstr102 ="SELECT * FROM Ref_SCTTLBDBK WHERE Sc_No='$scno' "; $result102 = mysqli_query($conn,$sqlstr102); $record102 = mysqli_fetch_array( $result102 ); $ttlqtysc=$record102['sumqty']; $scttlqty=$scno.$ttlqtysc; $sqlstr101 ="SELECT * FROM PC_Head WHERE Sc_No='$scno' AND Pc_No='2'"; $result101 = mysqli_query($conn,$sqlstr101); $record101 = mysqli_fetch_array( $result101 ); $pc2dlvy=$record101['Delivery_Date']; $ftyeta=$record100['FTYETA']; $Etabd1 = strtotime ( '-7 day' , strtotime ( $ftyeta) ) ; $Etabd = date ( 'Y-m-j' , $Etabd1 ); $sqlstr102 ="SELECT * FROM Factory WHERE Fty_ID='".$record100['fty_ID']."' "; $result102 = mysqli_query($conn,$sqlstr102); $record102 = mysqli_fetch_array( $result102 ); $ftynick=$record102['NickName']; $sqlstr103 ="SELECT * FROM WeldingFrameDlvy_Input WHERE Sc_No='$scno' AND Seq_No='$seqno' "; $result103 = mysqli_query($conn,$sqlstr103); $record103 = mysqli_fetch_array( $result103 ); $norecord=mysqli_num_rows($result103); if($norecord > '0') { $Etabd=$record103['Frame_ETA']; $pc1dlvy=$record103['Frame_Dlvy']; } ?>
Unweld