| Sr. | Item | Total Stock | Total Hold | Total Avl. | Details |
|---|
0";
$result_details = mysqli_query($conn,$sql_details );
$detailed_info='';
while ( $row_details = mysqli_fetch_assoc ( $result_details ) ) {
extract ( $row_details );
$item_stock = $stock_qty;
$sql_item_stock1 = "select sum(issue_qty),item_batch_no from stock_issue_items where stock_issue_id in (select stock_issue_id from stock_issue where STATUS='N' ) and item_id=$item_id and item_batch_no='" . $item_batch_no . "' group by item_batch_no,item_id ";
$result_item_stock1 = mysqli_query($conn,$sql_item_stock1 );
$row_item_stock1 = mysqli_fetch_array ( $result_item_stock1 );
if ($row_item_stock1 [0] != "" && $row_item_stock1 [0] != null) {
$hold_qty = $row_item_stock1 [0];
} else {
$hold_qty = 0.0;
}
$total_hold+=$hold_qty;
$total_stock+=$item_stock;
$available_qty = floatval ( $item_stock ) - floatval ( $hold_qty );
$detailed_info.="
Batch:".$item_batch_no;
$detailed_info.=", Expiry:";
$detailed_info.=(isset($row_details ['expiry_date']))?date_format ( date_create ( $row_details ['expiry_date'] ), "M-Y " ):"";
$detailed_info.=", Stock: ".$item_stock . " " . $unit_name;
$detailed_info.=", Hold: ".$hold_qty . " " . $unit_name;
$detailed_info.=", Available: ".$available_qty . " " . $unit_name."
";
}
//$links = $edit_link1;
$total_available=floatval ( $total_stock ) - floatval ( $total_hold );
$count=$count+1;
?> | | | | | |