0 and ohc_type_id='".$_SESSION['current_ohcttype']."' and item_stock_id not in (select item_stock_id from cleanup_item_stock) and DATE(expiry_date)<= (CURDATE() + INTERVAL $expiryAlertAdvance DAY )) itm_stk where itm_stk.item_id=i.item_id";
$results_expiry_items = mysqli_query($conn,$sql_expiry_items);
$total_item = mysqli_num_rows($results_expiry_items);
?>
| Item |
Available
Qty |
Batch |
Expiry date |
|
|
|
|