query("SELECT id, name FROM outlets WHERE status = 'active'")->fetchAll(PDO::FETCH_ASSOC); } catch (Exception $e) { $outlets = []; } // Simple API endpoint for price lookup if (isset($_GET['action']) && $_GET['action'] === 'lookup') { header('Content-Type: application/json'); $sku = $_GET['sku'] ?? ''; $outlet_id = $_GET['outlet_id'] ?? ($_COOKIE['preferred_outlet'] ?? null); if (empty($sku)) { echo json_encode(['error' => 'Empty SKU']); exit; } try { $sql = "SELECT name_en, name_ar, sale_price, image_path FROM stock_items WHERE sku = ?"; $params = [$sku]; if ($outlet_id) { $sql .= " AND outlet_id = ?"; $params[] = $outlet_id; } $sql .= " LIMIT 1"; $stmt = db()->prepare($sql); $stmt->execute($params); $item = $stmt->fetch(PDO::FETCH_ASSOC); if ($item) { echo json_encode([ 'success' => true, 'item' => [ 'name' => $item['name_en'] ?: $item['name_ar'], 'price' => number_format($item['sale_price'], 3), 'image' => $item['image_path'] ?: null ] ]); } else { echo json_encode(['success' => false, 'message' => 'Item not found']); } } catch (Exception $e) { echo json_encode(['error' => 'Database error']); } exit; } ?> Price Checker

Price Checker

Quickly check item prices

OMR