$inst = $pcfg['institution_name'];
$a1 = "<table><tr><td rowspan='2'><p class='nc'> Si No</p></td><td rowspan='2'><p class='nc'>Item</p></td><td rowspan='2'><p class='nc'>Category</p></td><td colspan='3'><p class='nc'>Opening Balance</p></td><td colspan='3'><p class='nc'>Purchase</p></td><td colspan='3'><p class='nc'>Total Stock</p></td><td colspan='3'><p class='nc'>Issued</p></td><td colspan='3'><p class='nc'>Available Stock</p></td></span></tr><tr><td><p class='nc'>Qty</p></td><td><p class='nc'>Rate</p></td><td><p class='nc'>Amount</p></td><td><p class='nc'>Qty</p></td><td><p class='nc'>Rate</p></td><td><p class='nc'>Amount</p></td><td><p class='nc'>Qty</p></td><td><p class='nc'>Rate</p></td><td><p class='nc'>Amount</p></td><td><p class='nc'>Qty</p></td><td><p class='nc'>Rate</p></td><td><p class='nc'>Amount</p></td><td><p class='nc'>Qty</p></td><td><p class='nc'>Rate</p></td><td>Amount</td></tr>";
$tob = 0;
$tpur =0;
$ts = 0;
$tissue = 0;
$si = 0;
$rscat = DB::Query("SELECT
inventory_category.category,
inventory_items.category AS cate
FROM inventory_items
INNER JOIN inventory_category ON inventory_items.category = inventory_category.ic_id
GROUP BY inventory_category.category
ORDER BY inventory_items.category");
while($datacat = db_fetch_array($rscat))
{
$cate = $datacat["cate"];
$category = $datacat["category"];
$rsi = DB::Query("SELECT
item,
rate+rate*((ifnull(tax,0)+ifnull(cgst,0)+ifnull(sgst,0))/100) AS stock_rate,
category,
inv_code
FROM inventory_items
WHERE (category ='$cate')");
while($datai = db_fetch_array($rsi))
{
$si = $si + 1;
$item = $datai["item"];
$stock_rate = $datai["stock_rate"];
$code = $datai["inv_code"];
$rso = DB::Query("SELECT
inventory_ob.code,
inventory_ob.opening_qty,
rate+rate*((ifnull(tax,0)+ifnull(cgst,0)+ifnull(sgst,0))/100) AS op_rate,
financial_year.status,
financial_year.financial_year AS fy
FROM inventory_ob
INNER JOIN financial_year ON inventory_ob.fy = financial_year.financial_year
WHERE (inventory_ob.code ='$code') AND (financial_year.status ='In_Progress')");
$datao = db_fetch_array($rso);
$ops= $datao["opening_qty"];
$opr = $datao["op_rate"];
$rsp = DB::Query("SELECT
inv_inward_details.item,
AVG(rate+rate*((ifnull(tax,0)+ifnull(cgst,0)+ifnull(sgst,0))/100)) AS pur_rate,
financial_year.status,
SUM(inv_inward_details.qty) AS qty
FROM inv_inward_details
INNER JOIN financial_year ON inv_inward_details.fy = financial_year.financial_year
WHERE (inv_inward_details.item ='$code') AND (financial_year.status ='In_Progress')
GROUP BY inv_inward_details.item, financial_year.status");
$datap = db_fetch_array($rsp);
$pq = $datap["qty"];
$pr = $datap["pur_rate"];
$tq = $ops+$pq; 
$rsis = DB::Query("SELECT
inv_issue_items.item,
AVG(rate+rate*((ifnull(tax,0)+ifnull(cgst,0)+ifnull(sgst,0))/100)) AS issue_rate,
SUM(inv_issue_items.qty) AS qty,
financial_year.status
FROM inv_issue_items
INNER JOIN financial_year ON inv_issue_items.fy = financial_year.financial_year
WHERE (inv_issue_items.item ='$code') AND (financial_year.status ='In_Progress')
GROUP BY inv_issue_items.item, financial_year.status");
$datais = db_fetch_array($rsis);
$isq = $datais["qty"];
$isr = $datais["issue_rate"];
$tb = $tq - $isq;
$tob = $tob+($ops*$opr);
$tpur =$tpur+($pr*$pq);
$tissue = $tissue+($isq*$stock_rate);
$ts = $ts + ($tq*$stock_rate);
if(strlen($ops)>0) {$opa = number_format(($ops*$opr),2);} else {$opa = '';}
if(strlen($pq)>0) {$pa = number_format(($pr*$pq),2);} else {$pa = '';}
if($tq>0) {$ta = number_format(($tq*$stock_rate),2); $tr = $stock_rate;} else {$ta = ''; $tq='';$tr='';}
if($isq>0) {$isa = number_format(($isq*$stock_rate),2); $isr = $stock_rate;} else {$isa = ''; $isq='';$isr='';}
if($tb>0) {$tba = number_format(($tb*$stock_rate),2); $tbr = $stock_rate;} else {$tba = ''; $tb='';$tbr='';}
$a1= $a1."<tr><td><p class='nc'>".$si."</p></td><td><p class='nc'>".$item."</p></td><td><p class='nc'>".$category."</p></td><td><p class='nc'>".$ops."</p></td><td><p class='nc'>".$opr."</p></td><td><p class='nc'>".$opa."</p></td><td><p class='nc'>".$pq."</p></td><td><p class='nc'>".$pr."</p></td><td><p class='nc'>".$pa."</p></td><td><p class='nc'>".$tq."</p></td><td><p class='nc'>".$tr."</p></td><td><p class='nc'>".$ta."</p></td><td><p class='nc'>".$isq."</p></td><td><p class='nc'>".$isr."</p></td><td><p class='nc'>".$isa."</p></td><td><p class='nc'>$tb</p></td><td><p class='nc'>".$tbr."</p></td><td>".$tba."</td></tr>";
}
}

$a1 = $a1."<tr><td colspan='3'></td><td colspan='2'><b> Total</b></td><td><b>".number_format(($tob),2)."</b></td><td colspan='2'><b> Total</b></td><td><b>".number_format(($tpur),2)."</b></td><td colspan='2'><b> Total</b></td><td><b>".number_format(($ts),2)."</b></td><td colspan='2'><b> Total</b></td><td><b>".number_format(($tissue),2)."</b></td><td colspan='2'><b> Total</b></td><td><b>".number_format(($ts-$tissue),2)."</b></td></tr>";
$a1 = $a1."</table>";