$f): ?>
) ?>)
Inclusive of all taxes
Sold out
0 ? 'Add up to ' . $maxItems . ' items' : 'Add as many items as you like' ?> to your Trial Bag. We bring them home, you pay only for what you keep.
This product is not available. See all products
'; site_footer(); exit; } try { $st = $pdo->prepare('SELECT file, color FROM product_images WHERE product_id = ? ORDER BY sort_order, id'); $st->execute([$id]); $imgRows = $st->fetchAll(); } catch (Throwable $e) { // color column not added yet $st = $pdo->prepare('SELECT file, \'\' AS color FROM product_images WHERE product_id = ? ORDER BY sort_order, id'); $st->execute([$id]); $imgRows = $st->fetchAll(); } $images = array_column($imgRows, 'file'); $imgData = array_map(fn($r) => ['url' => img_url($r['file']), 'color' => (string)$r['color']], $imgRows); $st = $pdo->prepare('SELECT id, size, color, GREATEST(stock - reserved, 0) AS avail FROM product_variants WHERE product_id = ?'); $st->execute([$id]); $variants = $st->fetchAll(); $rank = array_flip(size_sort(array_values(array_unique(array_column($variants, 'size'))))); usort($variants, function ($a, $b) use ($rank) { $c = strcmp($a['color'], $b['color']); return $c !== 0 ? $c : ($rank[$a['size']] <=> $rank[$b['size']]); }); $vdata = array_map(fn($v) => [ 'id' => (int)$v['id'], 'size' => $v['size'], 'color' => $v['color'], 'avail' => (int)$v['avail'], ], $variants); $totalAvail = array_sum(array_column($vdata, 'avail')); $d = discount_pct((float)$p['mrp'], (float)$p['price']); // More like this: same category first (closest price first, in stock only), then fill from other categories $inStock = 'EXISTS (SELECT 1 FROM product_variants rv WHERE rv.product_id = p.id AND rv.stock - rv.reserved > 0)'; $related = fetch_cards($pdo, "p.category_id = ? AND p.id <> ? AND $inStock", [$p['category_id'], $id], 'ABS(p.price - ' . (float)$p['price'] . ') ASC, p.id DESC', 8); if (count($related) < 8) { $skip = array_merge([$id], array_map(fn($r) => (int)$r['id'], $related)); $ph = implode(',', array_fill(0, count($skip), '?')); $more = fetch_cards($pdo, "p.id NOT IN ($ph) AND $inStock", $skip, 'p.id DESC', 8 - count($related)); $related = array_merge($related, $more); } $maxItems = (int)setting('max_trial_items', '5'); $inBag = array_keys(bag()); site_header($p['name'], mb_substr(strip_tags((string)$p['description']), 0, 150), $p['cat_slug']); ?>Home /
Inclusive of all taxes
0 ? 'Add up to ' . $maxItems . ' items' : 'Add as many items as you like' ?> to your Trial Bag. We bring them home, you pay only for what you keep.