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()) {
$stock_type_res = $db->query(
"stock_types",
"SELECT * FROM stock_types WHERE record_id = {$stock['stock_type_id']}"
);
$stock_type = $stock_type_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();
$table_data .= "
| {$stock['stock_no']} |
{$stock['item_name']} |
{$stock_type['name']} |
{$stock['quantity']} |
{$team_assigned['name']} |
";
}
} else {
$table_data .= "
| NO STOCK BOOKED |
";
}
?>