0)
{
$x=1;
}
else
{
$x=0;
}
if($forkprice > 0)
{
$y=1;
}
else
{
$y=0;
}
///////
$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);
$sqlstrbc=mysqli_query($conn,"SELECT sum(Percentage) as sump1 From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND (Item_Cat='FR31' OR Item_Cat='FR41') ");
$recordbc=mysqli_fetch_array($sqlstrbc);
//$sqlstrbd=mysqli_query($conn,"SELECT count(Item_Selection) as countsump1 From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND
//(Item='Bridge' OR Item='Chain Guard Bracket' OR Item='Brake Pivots' OR Item='K/S Bracket' OR Item='Cable Guide' OR Item='Cable Stopper' OR Item='Shock Mount'
//OR Item='Seat Clamp' OR Item='Tube Gusset' ) ");
//echo
$sqlstrbd=mysqli_query($conn,"SELECT count(Item_Selection) as countsump1 From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND (Item_Cat='FR31' OR Item_Cat='FR41') ");
$recordbd=mysqli_fetch_array($sqlstrbd);
$bitscount=$recordbd['countsump1'];
//echo $bitscount;
if($ttlpecentage == 0)
{
$sump31=0;
}
else
{
$sump31=round($recordbc['sump1'],0);
}
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;
}
///////////////////////////////
$sqlstrc177=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='Dual FT'");
$recordc177=mysqli_fetch_array($sqlstrc177);
$f17=$recordc177['Percentage'];
if($f17 == "")
{
$f17=0.00;
}
$sqlstrc187=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR30' AND Item='Dual RT'");
$recordc187=mysqli_fetch_array($sqlstrc187);
$f18=$recordc187['Percentage'];
if($f18 == "")
{
$f18=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='H/B Tubes'");
$recordc14=mysqli_fetch_array($sqlstrc14);
$norows16=mysqli_num_rows($sqlstrc14);
if($norows16 == 0)
{
$f15=0;
}
else
{
$f15=$recordc14['Percentage'];
}
//////////////////////////////////
$sqlstrc20=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='H-T-Bracket'");
$recordc20=mysqli_fetch_array($sqlstrc20);
$norows20=mysqli_num_rows($sqlstrc20);
if($norows20 == 0)
{
$f20=0;
}
else
{
$f20=$recordc20['Percentage'];
}
///////////////////////
$sqlstrc21=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='T-T-Gusset'");
$recordc21=mysqli_fetch_array($sqlstrc21);
$norows21=mysqli_num_rows($sqlstrc21);
if($norows21 == 0)
{
$f21=0;
}
else
{
$f21=$recordc21['Percentage'];
}
///////////////////////////////
$sqlstrc22=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='D-T-Gusset'");
$recordc22=mysqli_fetch_array($sqlstrc22);
$norows22=mysqli_num_rows($sqlstrc22);
if($norows22 == 0)
{
$f22=0;
}
else
{
$f22=$recordc22['Percentage'];
}
$sqlstrc23=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='C-B-Hub-Bracket'");
$recordc23=mysqli_fetch_array($sqlstrc23);
$norows23=mysqli_num_rows($sqlstrc23);
if($norows23 == 0)
{
$f23=0;
}
else
{
$f23=$recordc23['Percentage'];
}
/////
$sqlstrc25=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR40' AND Item='Steer tube'");
$recordc25=mysqli_fetch_array($sqlstrc25);
$norows25=mysqli_num_rows($sqlstrc25);
if($norows25 == 0)
{
$f25=0;
}
else
{
$f25=$recordc25['Percentage'];
}
/////
$sqlstrc26=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR40' AND Item='L-leg'");
$recordc26=mysqli_fetch_array($sqlstrc26);
$norows26=mysqli_num_rows($sqlstrc26);
if($norows26 == 0)
{
$f26=0;
}
else
{
$f26=$recordc26['Percentage'];
}
////////////////////////////////////////
$sqlstrc27=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR40' AND Item='R-leg'");
$recordc27=mysqli_fetch_array($sqlstrc27);
$norows27=mysqli_num_rows($sqlstrc27);
if($norows27 == 0)
{
$f27=0;
}
else
{
$f27=$recordc27['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);
$sqlstrc26=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='H-T-Bracket'");
$recordc26=mysqli_fetch_array($sqlstrc26);
$norows27=mysqli_num_rows($sqlstrc26);
$sqlstrc28=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='T-T-Gusset'");
$recordc28=mysqli_fetch_array($sqlstrc28);
$norows29=mysqli_num_rows($sqlstrc28);
$sqlstrc30=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='D-T-Gusset'");
$recordc30=mysqli_fetch_array($sqlstrc30);
$norows31=mysqli_num_rows($sqlstrc30);
$sqlstrc32=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='C-B-Hub-Bracket'");
$recordc32=mysqli_fetch_array($sqlstrc32);
$norows33=mysqli_num_rows($sqlstrc32);
$sqlstrc3a=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='Br. Pivot Base'");
$recordc3a=mysqli_fetch_array($sqlstrc3a);
$norows3a=mysqli_num_rows($sqlstrc3a);
$sqlstrc3b=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR31' AND Item='Br. Pivot Top'");
$recordc3b=mysqli_fetch_array($sqlstrc3b);
$norows3b=mysqli_num_rows($sqlstrc3b);
$sqlstrc3c=mysqli_query($conn,"SELECT * From FrameComponents_SCwise WHERE Sc_No='$scno' AND Seq_No='$seqno' AND Item_Cat='FR41' AND Item='FK-Brake pivot'");
$recordc3c=mysqli_fetch_array($sqlstrc3c);
$norows3c=mysqli_num_rows($sqlstrc3c);
?>