'sale_price ASC', 'sale_price_desc' => 'sale_price DESC', 'days_asc' => 'days ASC', 'days_desc' => 'days DESC', 'data_asc' => 'data_mb ASC', 'data_desc' => 'data_mb DESC', ]; $order_sql = $order_map[$sort] ?? 'sale_price ASC'; $where_sql = implode(' AND ', $where); $count_stmt = $pdo->prepare("SELECT COUNT(*) FROM packages WHERE $where_sql"); $count_stmt->execute($params); $total = $count_stmt->fetchColumn(); $total_pages = ceil($total / $per_page); $offset = ($page - 1) * $per_page; $stmt = $pdo->prepare("SELECT * FROM packages WHERE $where_sql ORDER BY $order_sql LIMIT $per_page OFFSET $offset"); $stmt->execute($params); $packages = $stmt->fetchAll(); // Devices for add-on $devices = $pdo->query("SELECT * FROM devices ORDER BY id")->fetchAll(); $shipping_fee = floatval(getSetting('shipping_fee') ?? 3.50); $devices_json = json_encode(array_map(function($d){ return ['id'=>(int)$d['id'],'name'=>$d['name'],'price'=>(float)$d['price'],'description'=>$d['description']]; }, $devices)); // Load current user's eUICC cards for order association $user_euiccs = []; if (isLoggedIn()) { $eu_stmt = $pdo->prepare("SELECT id, euicc_number, nickname FROM euniccs WHERE user_id = ? ORDER BY created_at DESC"); $eu_stmt->execute([$_SESSION['user_id']]); $user_euiccs = $eu_stmt->fetchAll(); } function devIcon2($name) { if (strpos($name, '写卡器') !== false) return 'usb'; if (strpos($name, '可编程') !== false) return 'microchip'; return 'sim-card'; } ?>

eSIM流量套餐

共找到 个套餐

天有效期
$ USD
1): ?>