add_styles_page();
$db = new db_safeguard();
$record_id = $_GET['record_id'];
$booked_stock_res = $db->query("book_stock", "SELECT * FROM book_stock WHERE record_id = '$record_id'");
$booked_stock = $booked_stock_res->fetch_assoc();
$order_no = $booked_stock['order_no'];
/* ── Build line items with already returned, already used, outstanding ── */
$all_complete = true;
$line_items = [];
$booked_data_res = $db->query("book_stock_list", "SELECT * FROM book_stock_list WHERE order_no = '$order_no'");
while ($row = $booked_data_res->fetch_assoc()) {
$sn = $row['stock_no'];
$ret_res = $db->query("stock_trans",
"SELECT COALESCE(SUM(quantity), 0) AS total
FROM stock_trans
WHERE stock_no = '$sn' AND status = 'RETURNED' AND order_no = '$order_no'"
);
$already_returned = (int) $ret_res->fetch_assoc()['total'];
$used_res = $db->query("stock_trans",
"SELECT COALESCE(SUM(quantity), 0) AS total
FROM stock_trans
WHERE stock_no = '$sn' AND status = 'USED' AND order_no = '$order_no'"
);
$already_used = (int) $used_res->fetch_assoc()['total'];
$outstanding = max(0, (int) $row['amount'] - $already_returned - $already_used);
$stock_type_res = $db->query("stock_types", "SELECT * FROM stock_types WHERE record_id = '{$row['stock_type_id']}'");
$stock_type_data = $stock_type_res->fetch_assoc();
$row['_already_returned'] = $already_returned;
$row['_already_used'] = $already_used;
$row['_outstanding'] = $outstanding;
$row['_type_name'] = $stock_type_data['name'];
if ($outstanding > 0) $all_complete = false;
$line_items[] = $row;
}
$total_rows = count($line_items);
?>