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