query("select count(barcode)jrow from (select barcode from tbarang ".(!empty($qry) ? " where ".$qry : "").
" group by kode_gr,barcode)a");
$row = $result->fetch_assoc();
$hasil["total"]=$row['jrow'];
$result=$conn->query("select barcode,nama_br,nama_gr,merk,ukuran,FORMAT(stock_all,0)stock_all,satuan,hjual_ec,hjual_gr ".
"from tbarang ".(!empty($qry) ? " where ".$qry : "").
" group by kode_gr,barcode order by barcode asc");
}else{
$result=$conn->query("select count(barcode)jrow from (select barcode from tbarang group by kode_gr,barcode)a");
$row = $result->fetch_assoc();
$hasil["total"]=$row['jrow'];
$result=$conn->query("select barcode,nama_br,nama_gr,merk,ukuran,FORMAT(stock_all,0)stock_all,satuan,hjual_ec,hjual_gr from ".
"tbarang group by kode_gr,barcode order by barcode asc limit 0");
}
$res=array();
while($row = $result->fetch_array()){
array_push($res, $row);
}
$hasil["rows"]=$res;
echo json_encode($hasil);
break;
case "subgrid":
$result=$conn->query("select nama_gd,FORMAT(stock,0)stock,hjual_ec,hjual_gr,satuan from tbarang where barcode='$_GET[barcode]'");
$hasil = array();
while($row = $result->fetch_array()){
array_push($hasil, $row);
}
echo json_encode($hasil);
break;
case "subpanel":
$result=$conn->query("select nama_gr,nama_pr,ukuran,merk,barcode,FORMAT(hjual_ec,0)hjual_ec,FORMAT(hjual_gr,0)hjual_gr from tbarang where barcode='$_GET[barcode]' limit 1");
$row=$result->fetch_assoc();
echo '