add_styles_page(); $db = new db_safeguard(); $today = date('Y-m-d'); $week_start = date('Y-m-d', strtotime('monday this week')); $week_end = date('Y-m-d', strtotime('sunday this week')); $month_start = date('Y-m-01'); $month_end = date('Y-m-t'); function build_rows($db, $date_from, $date_to) { $rows = ""; $res = $db->query("stock_trans", "SELECT * FROM stock_trans WHERE status = 'USED' AND DATE(datetime_created) BETWEEN '$date_from' AND '$date_to' ORDER BY datetime_created DESC" ); if ($res && $res->num_rows > 0) { while ($row = $res->fetch_assoc()) { $stock_res = $db->query("stock", "SELECT * FROM stock WHERE stock_no = '{$row['stock_no']}'"); $stock = $stock_res->fetch_assoc(); $type_res = $db->query("stock_types", "SELECT * FROM stock_types WHERE record_id = '{$stock['stock_type_id']}'"); $type = $type_res->fetch_assoc(); $team_name = "N/A"; if (!empty($row['order_no'])) { $order_res = $db->query("book_stock", "SELECT * FROM book_stock WHERE order_no = '{$row['order_no']}'"); if ($order = $order_res->fetch_assoc()) { $team_res = $db->query("teams", "SELECT * FROM teams WHERE record_id = '{$order['team_assigned_id']}'"); $team = $team_res->fetch_assoc(); $team_name = $team['name'] ?? "N/A"; } } $rows .= " " . date('Y-m-d H:i', strtotime($row['datetime_created'])) . " " . htmlspecialchars($row['order_no'] ?? 'N/A') . " " . htmlspecialchars($team_name) . " " . htmlspecialchars($type['name'] ?? 'N/A') . " " . htmlspecialchars($row['stock_no']) . " " . htmlspecialchars($row['item_name']) . " " . htmlspecialchars($row['quantity']) . " "; } } else { $rows = "NO USED STOCK FOUND FOR THIS PERIOD"; } return $rows; } $week_rows = build_rows($db, $week_start, $week_end); $month_rows = build_rows($db, $month_start, $month_end); ?>

USED STOCK

to
DOWNLOAD PDF
Date UsedOrder NoTeam Stock TypeStock NoItem NameQty Used
Date UsedOrder NoTeam Stock TypeStock NoItem NameQty Used