prepare("
SELECT id, title, message, background_color, text_color,
link_url, link_text, coupon_code
FROM announcements
WHERE is_active = 1
AND (start_date IS NULL OR start_date <= NOW())
AND (end_date IS NULL OR end_date >= NOW())
ORDER BY display_order DESC, created_at DESC
LIMIT 1
");
$stmt->execute();
$active_offer = $stmt->fetch(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
$active_offer = null;
}
// إذا كان هناك عرض نشط، اعرضه
if ($active_offer):
$banner_text = $active_offer['message'];
$banner_color = $active_offer['background_color'] ?: 'linear-gradient(135deg, #E57393 0%, #D1537A 100%)';
$text_color = $active_offer['text_color'] ?: '#ffffff';
$title = $active_offer['title'];
$coupon_code = $active_offer['coupon_code'];
$link_url = $active_offer['link_url'];
$link_text = $active_offer['link_text'] ?: 'تسوق الآن';
?>