$value) {
$newCat = true;
$query = "select i.item_id, i.item_name,rsi1.received_sum from tbl_items i left join (select item_id, sum(received_qty) received_sum from received_issue_items rsi where rsi.ohc_location_id='$ohc' and received_id in (select received_id from received_master where received_date between '$from_date1' and '$from_date2' ) group by item_id) rsi1 on i.item_id=rsi1.item_id where i.cat='$value' and i.status = '1' order by item_form_id";
error_log("query:" . $query);
$result = mysqli_query($conn,$query);
$total = mysqli_num_rows($result);
if ($total != 0) { ?>