CMTC Tech Solution - จอทีวีแสดงคิวส่วนกลาง (Central Queue TV Display)

prepare("SELECT id, table_number, status, DATE_FORMAT(created_at, '%H:%i') as time_str FROM orders WHERE status IN ('pending', 'preparing') AND store_id = :store_id ORDER BY created_at ASC"); $stmt_pending->execute([':store_id' => $store_id]); $pending = $stmt_pending->fetchAll(); // Fetch ready orders (LIFO) $stmt_ready = $pdo->prepare("SELECT id, table_number, status, DATE_FORMAT(created_at, '%H:%i') as time_str FROM orders WHERE status IN ('ready', 'served') AND store_id = :store_id ORDER BY created_at DESC LIMIT 12"); $stmt_ready->execute([':store_id' => $store_id]); $ready = $stmt_ready->fetchAll(); echo json_encode([ 'success' => true, 'pending' => $pending, 'ready' => $ready ]); } catch (Exception $e) { echo json_encode([ 'success' => false, 'error' => $e->getMessage() ]); } exit; } $shop_info = null; $active_shops = []; if ($store_id > 0) { try { $stmt_shop = $pdo->prepare("SELECT store_id as id, store_name as name, address, category FROM tenants WHERE store_id = :id AND status = 'active'"); $stmt_shop->execute([':id' => $store_id]); $shop_info = $stmt_shop->fetch(); } catch (PDOException $e) { $shop_info = null; } } if (!$shop_info) { try { $stmt_active = $pdo->query("SELECT store_id as id, store_name as name, category, address FROM tenants WHERE status = 'active' ORDER BY store_id DESC"); $active_shops = $stmt_active->fetchAll(); } catch (PDOException $e) { $active_shops = []; } } ?> CMTC Tech Solution - จอทีวีแสดงคิวส่วนกลาง (Central Queue TV Display)

📺