Corvo Cycles (Pvt) Ltd.

Cost Statement

Model:-

'TR5' group by HS_Code"; $sql1="Select *,sum(percentage) as itemsum from Ref_Ibwsunithscode where Sc_No='$scno' AND Seq_No='$seqno' AND Part_ID <> 'TR5' AND percentage > '0' group by HS_Code"; //$sql1="Select * from Ref_Ibwsunithscode where Sc_No='$scno' AND Seq_No='$seqno' AND Part_ID <> 'TR5' "; $row=mysqli_query($conn,$sql1); while($record=mysqli_fetch_array($row)) { //$sql2="Select Sum(percentage) as itemsum from Ref_Ibwsunithscode where Sc_No='$scno' AND Seq_No='$seqno' AND Part_ID <> 'TR5' group by HS_Code"; //$row2=mysqli_query($conn,$sql2); //$record22=mysqli_fetch_array($row2); $hscode=$record['HS_Code']; $pricesum=number_format($record['itemsum'],2); //$pricesum=number_format($record['percentage'],2); //$itemnames=$record['Name']; $sql15="Select * from PC_Pricenew where Pc_No='$scno' AND Seq_No='$seqno' "; $row15=mysqli_query($conn,$sql15); $record15=mysqli_fetch_array($row15); $fobbdprice=$record15['Fob_BD']; $ch11=$record15['chk1']; $ch21=$record15['chk2']; if($ch11 == "on") { $price2=$record15['ibwsop1']; } if($ch21 == "on") { $price2=$record15['ibwsop2']; } //$pecentage=($price2/$fobbdprice)*100; $price1=$price2*$pricesum/100; $pecentage=$price1/$fobbdprice*100; $itemper=""; $sql2="Select * from Ref_Ibwsunithscode where Sc_No='$scno' AND Seq_No='$seqno' AND HS_Code='$hscode' AND Name <> 'Freewheel' order by HS_Code "; $row2=mysqli_query($conn,$sql2); while($record2=mysqli_fetch_array($row2)) { $itemnames=$record2['Name']; $itemper=$itemper.",".$itemnames; //$Cntr=$Cntr.",".$data['CNTR_No']; } //$xx=$itemper."-".$pricesum; //echo $xx; //echo "
"; ?>

SC- Seq-
H.S CODE	PARTICULARS	China	Others	USD	Factory
		0.00			0.00
			0.00		0.00
3208.90.90	Paint		0.00		0.00
	Local Row Materials		0.00		0.00
	Material Cost	0.00	0.00		0.00
	Manufacturing Cost (welding, Rim manufacturiung, painting, assembly)			0.00	0.00
	Imp Exp and Operational costs			0.00	0.00
				0.00	0.00