add_styles_page();
$db = new db_safeguard();
$table_data = "";
$current_stock_res = $db->query("book_stock", "SELECT * FROM book_stock");
if ($current_stock_res->num_rows > 0) {
while ($stock = $current_stock_res->fetch_assoc()) {
$team_assigned_res = $db->query(
"teams",
"SELECT * FROM teams WHERE record_id = {$stock['team_assigned_id']}"
);
$team_assigned = $team_assigned_res->fetch_assoc();
$stock_list_res = $db->query(
"book_stock_list",
"SELECT * FROM book_stock_list WHERE order_no = '{$stock['order_no']}'"
);
while ($stock_list = $stock_list_res->fetch_assoc()) {
$stock_type_res = $db->query(
"stock_types",
"SELECT * FROM stock_types WHERE record_id = '{$stock_list['stock_type_id']}'"
);
$stock_type = $stock_type_res->fetch_assoc();
$table_data .= "
| {$stock_list['order_no']} |
{$stock['booking_date']} |
{$team_assigned['name']} |
{$stock_type['name']} |
{$stock_list['item_name']} |
{$stock_list['amount']} |
";
}
}
} else {
$table_data .= "
| NO STOCK BOOKED |
";
}
?>