include('dbcon.php'); $scno=$_GET['scno']; $seqno=$_GET['seq']; $Model=$_GET['Model']; $sqlstr=mysqli_query($conn,"SELECT * From PC_Item WHERE SC_No='$scno' AND PC_No='3' AND Seq_No='$seqno'"); $record=mysqli_fetch_array($sqlstr); $pricepc=$record['Price']; $sqlstr1=mysqli_query($conn,"Select * FROM SC_Item WHERE Sc_No='$scno' AND Seq_No='$seqno'"); $record1=mysqli_fetch_array($sqlstr1); $gspno=$record1['GSP_NO']; //////////////////////////fk status $fkstatus=$record1['FK_Weld_Status']; ///////////////////////////////////// $sqlstr2=mysqli_query($conn,"Select * FROM Gsp_Bom_costing WHERE Internal='$gspno' "); $record2=mysqli_fetch_array($sqlstr2); $forkprice=$record2['loc_fork']; $hbprice=$record2['loc_hb']; $frameprice=$record2['loc_frame']; if($hbprice > 0) { $x=1; } else { $x=0; } if($forkprice > 0 AND $fkstatus == 0) { $y=1; } else { $y=0; } ?>
PC NO
-Seq
Model:
Percentage
Frame Components
F/Triangle
RR Triangle
LR Triangle
Top Tube
Down Tube
Seat Tube
Head Tube
BB
R/C Stay
L/C Stay
R/S Stay
L/S Stay
Frame Ends
Dual FT
Dual RT
Fork Components
Steer tube
//echo $fkstatus; if($fkstatus == 1) { ?>
} else { ?>
} ?>
L-leg
if($fkstatus == 1) { ?>
} else { ?>
} ?>
Fork tube
if($fkstatus == 1) { ?>
} else { ?>
} ?>
R-leg
if($fkstatus == 1) { ?>
} else { ?>
} ?>
Fork parts
if(($forkprice == 0 OR $forkprice == "") AND $fkstatus == 0 ) { ?>
} else if( $forkprice > 0 AND $fkstatus == 1 ) { ?>
} else { ?>
} ?>
H/B Tubes
if($hbprice == 0 OR $hbprice == "") { ?>
} else { ?>
} ?>
Frame Bits Items
Bridge
Chain Guard Bracket
Brake Pivots
K/S Bracket
Cable Guide
Cable Stopper
Shock Mount
Seat Clamp
Tube Gusset
H-T-Bracket
T-T-Gusset
D-T-Gusset
C-B-Hub-Bracket
Br. Pivot Base
Br. Pivot Top
Fork Bits Items
FK-Brake pivot
if($fkstatus == 1) { ?>
} else { ?>
} ?>