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'];
//////ttl percentage
$sqlstra=mysqli_query($conn,"SELECT sum(Percentage) as sump From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno'");
$recorda=mysqli_fetch_array($sqlstra);
$ttlpecentage=$recorda['sump'];
//echo $ttlpecentage;
if($ttlpecentage == "")
{
$ttlpecentage=0;
}
$sqlstrb=mysqli_query($conn,"SELECT sum(Percentage) as sump From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30'");
$recordb=mysqli_fetch_array($sqlstrb);
if($ttlpecentage == 0)
{
$sump31=0;
}
else
{
$sump31=100-$recordb['sump'];
}
if($sump31 == "")
{
$sump31=0.00;
}
//////////////////////////////
$sqlstrc=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='F/Triangle'");
$recordc=mysqli_fetch_array($sqlstrc);
$f1=$recordc['Percentage'];
if($f1 == "")
{
$f1=0.00;
}
$sqlstrc1=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='RR Triangle'");
$recordc1=mysqli_fetch_array($sqlstrc1);
$f2=$recordc1['Percentage'];
if($f2 == "")
{
$f2=0.00;
}
$sqlstrc2=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='LR Triangle'");
$recordc2=mysqli_fetch_array($sqlstrc2);
$f3=$recordc2['Percentage'];
if($f3 == "")
{
$f3=0.00;
}
$sqlstrc3=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='Top Tube'");
$recordc3=mysqli_fetch_array($sqlstrc3);
$f4=$recordc3['Percentage'];
if($f4 == "")
{
$f4=0.00;
}
$sqlstrc4=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='Down Tube'");
$recordc4=mysqli_fetch_array($sqlstrc4);
$f5=$recordc4['Percentage'];
if($f5 == "")
{
$f5=0.00;
}
$sqlstrc5=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='Seat Tube'");
$recordc5=mysqli_fetch_array($sqlstrc5);
$f6=$recordc5['Percentage'];
if($f6 == "")
{
$f6=0.00;
}
$sqlstrc6=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='Head Tube'");
$recordc6=mysqli_fetch_array($sqlstrc6);
$f7=$recordc6['Percentage'];
if($f7 == "")
{
$f7=0.00;
}
$sqlstrc7=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='BB'");
$recordc7=mysqli_fetch_array($sqlstrc7);
$f8=$recordc7['Percentage'];
if($f8 == "")
{
$f8=0.00;
}
$sqlstrc8=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='R/C Stay'");
$recordc8=mysqli_fetch_array($sqlstrc8);
$f9=$recordc8['Percentage'];
if($f9 == "")
{
$f9=0.00;
}
$sqlstrc9=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='L/C Stay'");
$recordc9=mysqli_fetch_array($sqlstrc9);
$f10=$recordc9['Percentage'];
if($f10 == "")
{
$f10=0.00;
}
$sqlstrc10=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='R/S Stay'");
$recordc10=mysqli_fetch_array($sqlstrc10);
$f11=$recordc10['Percentage'];
if($f11 == "")
{
$f11=0.00;
}
$sqlstrc11=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='L/S Stay'");
$recordc11=mysqli_fetch_array($sqlstrc11);
$f12=$recordc11['Percentage'];
if($f12 == "")
{
$f12=0.00;
}
$sqlstrc12=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='Frame Ends'");
$recordc12=mysqli_fetch_array($sqlstrc12);
$f13=$recordc12['Percentage'];
if($f13 == "")
{
$f13=0.00;
}
$sqlstrc13=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='Fork parts'");
$recordc13=mysqli_fetch_array($sqlstrc13);
$norows15=mysqli_num_rows($sqlstrc13);
if($norows15 == 0)
{
$f14=0;
}
else
{
$f14=$recordc13['Percentage'];
}
$sqlstrc14=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='Fork parts'");
$recordc14=mysqli_fetch_array($sqlstrc14);
$norows16=mysqli_num_rows($sqlstrc14);
if($norows16 == 0)
{
$f15=0;
}
else
{
$f15=$recordc14['Percentage'];
}
$sqlstrc15=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='Bridge'");
$recordc15=mysqli_fetch_array($sqlstrc15);
$norows17=mysqli_num_rows($sqlstrc15);
$sqlstrc16=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='Chain Guard Bracket'");
$recordc16=mysqli_fetch_array($sqlstrc16);
$norows18=mysqli_num_rows($sqlstrc16);
$sqlstrc17=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='Brake Pivots'");
$recordc17=mysqli_fetch_array($sqlstrc17);
$norows19=mysqli_num_rows($sqlstrc17);
$sqlstrc18=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='K/S Bracket'");
$recordc18=mysqli_fetch_array($sqlstrc18);
$norows20=mysqli_num_rows($sqlstrc18);
$sqlstrc19=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='Cable Guide'");
$recordc19=mysqli_fetch_array($sqlstrc19);
$norows21=mysqli_num_rows($sqlstrc19);
$sqlstrc20=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='Cable Stopper'");
$recordc20=mysqli_fetch_array($sqlstrc20);
$norows22=mysqli_num_rows($sqlstrc20);
$sqlstrc21=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='Shock Mount'");
$recordc21=mysqli_fetch_array($sqlstrc21);
$norows23=mysqli_num_rows($sqlstrc21);
$sqlstrc22=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='Seat Clamp'");
$recordc22=mysqli_fetch_array($sqlstrc22);
$norows24=mysqli_num_rows($sqlstrc22);
$sqlstrc23=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='Tube Gusset'");
$recordc23=mysqli_fetch_array($sqlstrc23);
$norows25=mysqli_num_rows($sqlstrc23);
?>