<?php
// Dinamik index.php dosyasi
require_once 'config.php';

// Veritabani baglantisini al
global $pdo, $mysqli, $use_pdo;

// Anasayfa bolumlerini getir (acik/kapali durumlari)
$homepageSections = [];
try {
    if ($use_pdo) {
        $result = $pdo->query("SELECT section_key, status FROM homepage_sections");
        if ($result) {
            $sections = $result->fetchAll();
            foreach ($sections as $section) {
                $homepageSections[$section['section_key']] = $section['status'];
            }
        }
    } else {
        $result = $mysqli->query("SELECT section_key, status FROM homepage_sections");
        if ($result) {
            while ($row = $result->fetch_assoc()) {
                $homepageSections[$row['section_key']] = $row['status'];
            }
        }
    }
} catch (Exception $e) {
    // Tablo yoksa varsayilan degerleri kullan
    $homepageSections = [
        'banner' => 1,
        'about' => 1,
        'services' => 1,
        'cta' => 1,
        'quality' => 1,
        'counters' => 1,
        'projects' => 1,
        'blog' => 1
    ];
}

// Helper function: Bolumun aktif olup olmadigini kontrol et
function isSectionEnabled($key, $sections) {
    return isset($sections[$key]) && $sections[$key] == 1;
}

// Bannerlari getir (sadece bolum aktifse)
$banners = [];
if (isSectionEnabled('banner', $homepageSections)) {
    if ($use_pdo) {
        $banners = $pdo->query("SELECT * FROM banners WHERE status = 1 ORDER BY `order` ASC, id ASC")->fetchAll();
    } else {
        $result = $mysqli->query("SELECT * FROM banners WHERE status = 1 ORDER BY `order` ASC, id ASC");
        $banners = $result ? dbFetchAll($result) : [];
    }
}

// Diger bolumleri getir
$aboutSection = null;
if (isSectionEnabled('about', $homepageSections)) {
    $currentLang = getCurrentLanguage();
    // Metin iceriklerini secili dilden al
    if ($use_pdo) {
        $stmt = $pdo->prepare("SELECT * FROM about_section WHERE status = 1 AND lang_code = ? LIMIT 1");
        $stmt->execute([$currentLang]);
        $aboutSection = $stmt->fetch();
    } else {
        $stmt = $mysqli->prepare("SELECT * FROM about_section WHERE status = 1 AND lang_code = ? LIMIT 1");
        $stmt->bind_param("s", $currentLang);
        $stmt->execute();
        $result = $stmt->get_result();
        $aboutSection = $result ? $result->fetch_assoc() : null;
    }
    
    // Gorselleri TR'den al (tum dillerde ayni gorseller kullanilir)
    if ($use_pdo) {
        $stmt = $pdo->prepare("SELECT image1, image2 FROM about_section WHERE status = 1 AND lang_code = 'tr' LIMIT 1");
        $stmt->execute();
        $trImages = $stmt->fetch();
    } else {
        $stmt = $mysqli->prepare("SELECT image1, image2 FROM about_section WHERE status = 1 AND lang_code = 'tr' LIMIT 1");
        $stmt->execute();
        $result = $stmt->get_result();
        $trImages = $result ? $result->fetch_assoc() : null;
    }
    
    // Gorselleri TR'deki gorsellerle birlestir
    if ($aboutSection && $trImages) {
        $aboutSection['image1'] = $trImages['image1'] ?? '';
        $aboutSection['image2'] = $trImages['image2'] ?? '';
    }
}

$services = [];
if (isSectionEnabled('services', $homepageSections)) {
    $currentLang = getCurrentLanguage();
    if ($use_pdo) {
        $stmt = $pdo->prepare("SELECT * FROM services WHERE status = 1 AND lang_code = ? ORDER BY `order` ASC, id ASC LIMIT 4");
        $stmt->execute([$currentLang]);
        $services = $stmt->fetchAll();
    } else {
        $stmt = $mysqli->prepare("SELECT * FROM services WHERE status = 1 AND lang_code = ? ORDER BY `order` ASC, id ASC LIMIT 4");
        $stmt->bind_param("s", $currentLang);
        $stmt->execute();
        $result = $stmt->get_result();
        $services = $result ? dbFetchAll($result) : [];
    }
}

$ctaSection = null;
if (isSectionEnabled('cta', $homepageSections)) {
    if ($use_pdo) {
        $ctaSection = $pdo->query("SELECT * FROM cta_section WHERE status = 1 LIMIT 1")->fetch();
    } else {
        $result = $mysqli->query("SELECT * FROM cta_section WHERE status = 1 LIMIT 1");
        $ctaSection = $result ? $result->fetch_assoc() : null;
    }
}

$qualitySection = null;
$qualityItems = [];
if (isSectionEnabled('quality', $homepageSections)) {
    $currentLang = getCurrentLanguage();
    if ($use_pdo) {
        $qualitySection = $pdo->query("SELECT * FROM quality_section WHERE status = 1 LIMIT 1")->fetch();
        
        // Kalite öğelerini dile göre getir
        $stmt = $pdo->prepare("SELECT * FROM quality_items WHERE status = 1 AND lang_code = ? ORDER BY `order` ASC, id ASC");
        $stmt->execute([$currentLang]);
        $qualityItems = $stmt->fetchAll();
        
        // Seçili dilde yoksa Türkçe'yi getir
        if (empty($qualityItems)) {
            $qualityItems = $pdo->query("SELECT * FROM quality_items WHERE status = 1 AND lang_code = 'tr' ORDER BY `order` ASC, id ASC")->fetchAll();
        }
    } else {
        $result = $mysqli->query("SELECT * FROM quality_section WHERE status = 1 LIMIT 1");
        $qualitySection = $result ? $result->fetch_assoc() : null;
        
        // Kalite öğelerini dile göre getir
        $stmt = $mysqli->prepare("SELECT * FROM quality_items WHERE status = 1 AND lang_code = ? ORDER BY `order` ASC, id ASC");
        $stmt->bind_param("s", $currentLang);
        $stmt->execute();
        $result = $stmt->get_result();
        $qualityItems = $result ? dbFetchAll($result) : [];
        
        // Seçili dilde yoksa Türkçe'yi getir
        if (empty($qualityItems)) {
            $result = $mysqli->query("SELECT * FROM quality_items WHERE status = 1 AND lang_code = 'tr' ORDER BY `order` ASC, id ASC");
        $qualityItems = $result ? dbFetchAll($result) : [];
        }
    }
}

$counters = [];
if (isSectionEnabled('counters', $homepageSections)) {
    $currentLang = getCurrentLanguage();
    if ($use_pdo) {
        $stmt = $pdo->prepare("SELECT * FROM counters WHERE status = 1 AND lang_code = ? ORDER BY `order` ASC, id ASC");
        $stmt->execute([$currentLang]);
        $counters = $stmt->fetchAll();
        
        // Seçili dilde sayaç yoksa Türkçe'yi getir
        if (empty($counters)) {
            $stmt = $pdo->prepare("SELECT * FROM counters WHERE status = 1 AND lang_code = 'tr' ORDER BY `order` ASC, id ASC");
            $stmt->execute();
            $counters = $stmt->fetchAll();
        }
    } else {
        $stmt = $mysqli->prepare("SELECT * FROM counters WHERE status = 1 AND lang_code = ? ORDER BY `order` ASC, id ASC");
        $stmt->bind_param("s", $currentLang);
        $stmt->execute();
        $result = $stmt->get_result();
        $counters = $result ? dbFetchAll($result) : [];
        
        // Seçili dilde sayaç yoksa Türkçe'yi getir
        if (empty($counters)) {
            $result = $mysqli->query("SELECT * FROM counters WHERE status = 1 AND lang_code = 'tr' ORDER BY `order` ASC, id ASC");
        $counters = $result ? dbFetchAll($result) : [];
        }
    }
}

$projects = [];
if (isSectionEnabled('projects', $homepageSections)) {
    if ($use_pdo) {
        $projects = $pdo->query("SELECT * FROM projects WHERE status = 1 ORDER BY `order` ASC, id ASC LIMIT 6")->fetchAll();
    } else {
        $result = $mysqli->query("SELECT * FROM projects WHERE status = 1 ORDER BY `order` ASC, id ASC LIMIT 6");
        $projects = $result ? dbFetchAll($result) : [];
    }
}

$blogPosts = [];
if (isSectionEnabled('blog', $homepageSections)) {
    $currentLang = getCurrentLanguage();
    if ($use_pdo) {
        // Önce seçili dildeki haberleri getir
        $stmt = $pdo->prepare("SELECT * FROM blog_posts WHERE status = 1 AND lang_code = ? ORDER BY published_at DESC, created_at DESC LIMIT 3");
        $stmt->execute([$currentLang]);
        $blogPosts = $stmt->fetchAll();
        
        // Seçili dilde haber yoksa Türkçe'yi getir
        if (empty($blogPosts)) {
            $blogPosts = $pdo->query("SELECT * FROM blog_posts WHERE status = 1 AND lang_code = 'tr' ORDER BY published_at DESC, created_at DESC LIMIT 3")->fetchAll();
        }
    } else {
        // Önce seçili dildeki haberleri getir
        $stmt = $mysqli->prepare("SELECT * FROM blog_posts WHERE status = 1 AND lang_code = ? ORDER BY published_at DESC, created_at DESC LIMIT 3");
        $stmt->bind_param("s", $currentLang);
        $stmt->execute();
        $result = $stmt->get_result();
        $blogPosts = $result ? dbFetchAll($result) : [];
        
        // Seçili dilde haber yoksa Türkçe'yi getir
        if (empty($blogPosts)) {
            $result = $mysqli->query("SELECT * FROM blog_posts WHERE status = 1 AND lang_code = 'tr' ORDER BY published_at DESC, created_at DESC LIMIT 3");
        $blogPosts = $result ? dbFetchAll($result) : [];
    }
    }
}

// Yeni Urunler - Son eklenen 6 urun
$newProducts = [];
try {
    if ($use_pdo) {
        $newProducts = $pdo->query("SELECT * FROM products WHERE status = 1 ORDER BY id DESC LIMIT 6")->fetchAll();
    } else {
        $result = $mysqli->query("SELECT * FROM products WHERE status = 1 ORDER BY id DESC LIMIT 6");
        $newProducts = $result ? dbFetchAll($result) : [];
    }
} catch (Exception $e) {
    $newProducts = [];
}

include 'includes/header.php';
?>

    <div class="banner-swiper-two">
        <div class="swiper mySwiper-banner-two">
            <div class="swiper-wrapper">
            <?php if (!empty($banners)): ?>
                <?php foreach ($banners as $banner): 
                    $bgImage = !empty($banner['image']) ? $banner['image'] : 'assets/images/banner/02.webp';
                ?>
                <div class="swiper-slide">
                    <div class="rts-banner-area-two rts-section-gap" style="background-image: url('<?php echo htmlspecialchars($bgImage); ?>'); background-size: cover; background-position: center;">
                        <div class="container">
                            <div class="row">
                                <div class="col-lg-12">
                                    <div class="banner-inner-two-content">
                                            <?php if (!empty($banner['subtitle'])): ?>
                                            <p class="pre-title"><span><?php echo htmlspecialchars($banner['subtitle']); ?></span></p>
                                            <?php endif; ?>
                                            <?php if (!empty($banner['title'])): ?>
                                            <h1 class="title"><?php echo nl2br(htmlspecialchars($banner['title'])); ?></h1>
                                            <?php endif; ?>
                                            <?php if (!empty($banner['description'])): ?>
                                            <p class="disc"><?php echo htmlspecialchars($banner['description']); ?></p>
                                            <?php endif; ?>
                                            <?php if (!empty($banner['button_text'])): ?>
                                                <a href="<?php echo htmlspecialchars($banner['button_url']); ?>" class="rts-btn btn-primary btn-white">
                                                    <?php echo htmlspecialchars($banner['button_text']); ?>
                                                </a>
                                            <?php endif; ?>
                                        </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <?php endforeach; ?>
            <?php else: ?>
                <div class="swiper-slide">
                    <div class="rts-banner-area-two rts-section-gap bg_image">
                        <div class="container">
                            <div class="row">
                                <div class="col-lg-12">
                                    <div class="banner-inner-two-content">
                                        <p class="pre-title"><span><?php echo t('site_title'); ?></span></p>
                                        <h1 class="title"><?php echo t('banner_title'); ?></h1>
                                        <p class="disc"><?php echo t('banner_desc'); ?></p>
                                        <a href="urunlerimiz.php" class="rts-btn btn-primary btn-white"><?php echo t('products'); ?></a>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            <?php endif; ?>
            </div>
            <div class="swiper-button-next"><i class="fa-light fa-chevron-right"></i></div>
            <div class="swiper-button-prev"><i class="fa-light fa-chevron-left"></i></div>
        </div>
    </div>

<?php if ($aboutSection): ?>
    <div class="rts-about-area-two rts-section-gap">
        <div class="container">
            <div class="row align-items-center">
                <div class="col-lg-6">
                    <div class="left-thumbnail-about-area-two">
                    <?php if ($aboutSection['image1']): ?>
                        <img loading="lazy" src="<?php echo htmlspecialchars($aboutSection['image1']); ?>" alt="about">
                    <?php else: ?>
                        <img loading="lazy" src="assets/images/about/04.webp" alt="about">
                    <?php endif; ?>
                    <?php if ($aboutSection['image2']): ?>
                        <div class="small-image">
                            <img loading="lazy" src="<?php echo htmlspecialchars($aboutSection['image2']); ?>" alt="small">
                        </div>
                    <?php endif; ?>
                        <div class="counter-about-area">
                        <h2 class="counter title"><span class="odometer" data-count="<?php echo $aboutSection['experience_years']; ?>">00</span>+</h2>
                            <span><?php echo t('years_experience'); ?></span>
                    </div>
                    </div>
                </div>
                <div class="col-lg-6 mt_sm--80 mt_md--80">
                    <div class="about-inner-content-two">
                        <div class="title-style-two left">
                        <span class="bg-content"><?php echo htmlspecialchars($aboutSection['subtitle']); ?></span>
                        <span class="pre"><?php echo htmlspecialchars($aboutSection['subtitle']); ?></span>
                        <h2 class="title rts-text-anime-style-1"><?php echo htmlspecialchars($aboutSection['title']); ?></h2>
                        </div>
                        <div class="about-between-wrapper">
                        <p class="disc"><?php echo nl2br(htmlspecialchars($aboutSection['description'])); ?></p>
                            <div class="check-wrapper-area">
                            <?php if ($aboutSection['feature1_title']): ?>
                                <div class="single-check">
                                    <i class="fa-solid fa-circle-check"></i>
                                    <p><?php echo htmlspecialchars($aboutSection['feature1_title']); ?></p>
                                </div>
                            <?php endif; ?>
                            <?php if ($aboutSection['feature2_title']): ?>
                                <div class="single-check">
                                    <i class="fa-solid fa-circle-check"></i>
                                    <p><?php echo htmlspecialchars($aboutSection['feature2_title']); ?></p>
                                </div>
                            <?php endif; ?>
                            <?php if ($aboutSection['feature3_title']): ?>
                                <div class="single-check">
                                    <i class="fa-solid fa-circle-check"></i>
                                    <p><?php echo htmlspecialchars($aboutSection['feature3_title']); ?></p>
                                </div>
                            <?php endif; ?>
                        </div>
                    </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="shape-area">
            <img loading="lazy" src="assets/images/about/shape/01.svg" alt="shape" class="one">
            <img loading="lazy" src="assets/images/about/shape/02.svg" alt="shape" class="two">
        </div>
    </div>
<?php endif; ?>

<?php if (!empty($services)): ?>
    <?php
    $sectionTitle = getSetting('homepage_section_services_title', t('production_process'));
    $sectionSubtitle = getSetting('homepage_section_services_subtitle', t('site_title'));
    ?>
    <div class="rts-service-area production-process-section">
        <div class="container">
            <div class="row">
                <div class="col-lg-12">
                    <div class="title-style-two center">
                        <span class="bg-content"><?php echo htmlspecialchars($sectionSubtitle); ?></span>
                        <span class="pre"><?php echo htmlspecialchars($sectionSubtitle); ?></span>
                        <h2 class="title rts-text-anime-style-1"><?php echo htmlspecialchars($sectionTitle); ?></h2>
                    </div>
                </div>
            </div>
            <div class="row g-4 mt--40 production-images-grid">
                <?php foreach ($services as $index => $service): ?>
                    <div class="col-lg-3 col-md-4 col-sm-6" data-aos="fade-up" data-aos-delay="<?php echo $index * 100; ?>">
                        <div class="production-image-card">
                            <?php if ($service['icon_image']): ?>
                                <div class="production-image-wrapper">
                                    <img loading="lazy" src="<?php echo htmlspecialchars($service['icon_image']); ?>" alt="<?php echo htmlspecialchars($service['title']); ?>" class="production-image">
                                    <div class="production-image-overlay"></div>
                                </div>
                            <?php else: ?>
                                <div class="production-image-wrapper">
                                    <img loading="lazy" src="assets/images/service/icons/01.svg" alt="<?php echo htmlspecialchars($service['title']); ?>" class="production-image">
                                    <div class="production-image-overlay"></div>
                                </div>
                            <?php endif; ?>
                        </div>
                    </div>
                <?php endforeach; ?>
            </div>
        </div>
    </div>
<?php endif; ?>

<!-- Yeni Urunler Bolumu -->
<?php if (!empty($newProducts)): ?>
<div class="new-products-section rts-section-gap">
                    <div class="container">
                        <div class="row">
                            <div class="col-lg-12">
                <div class="title-style-two center">
                    <span class="bg-content">May Fren</span>
                    <span class="pre">May Fren</span>
                    <h2 class="title rts-text-anime-style-1"><?php echo t('new_products'); ?></h2>
                </div>
            </div>
        </div>
        <div class="row g-4 mt--40">
            <?php foreach ($newProducts as $index => $product): ?>
                <div class="col-lg-4 col-md-6" data-aos="fade-up" data-aos-delay="<?php echo $index * 100; ?>">
                    <div class="new-product-card">
                        <a href="urun-detay.php?id=<?php echo $product['id']; ?>" class="product-image-link">
                            <div class="product-image-wrapper">
                                <?php if (!empty($product['image'])): ?>
                                    <img src="<?php echo htmlspecialchars($product['image']); ?>" alt="<?php echo htmlspecialchars($product['name']); ?>" class="product-image">
                                <?php else: ?>
                                    <img src="assets/images/product/placeholder.png" alt="<?php echo htmlspecialchars($product['name']); ?>" class="product-image">
                                <?php endif; ?>
                            </div>
                        </a>
                        <div class="product-info">
                            <h4 class="product-title">
                                <a href="urun-detay.php?id=<?php echo $product['id']; ?>">
                                    <?php echo htmlspecialchars($product['name']); ?>
                                </a>
                            </h4>
                            <?php if (!empty($product['description'])): ?>
                                <p class="product-desc"><?php echo htmlspecialchars(mb_substr(strip_tags($product['description']), 0, 80)); ?>...</p>
                                <?php endif; ?>
                            <a href="urun-detay.php?id=<?php echo $product['id']; ?>" class="product-link">
                                <?php echo t('view_details'); ?> <i class="fas fa-arrow-right"></i>
                            </a>
                            </div>
                        </div>
                    </div>
            <?php endforeach; ?>
                </div>
        <div class="row mt--50">
            <div class="col-lg-12 text-center">
                <a href="urunlerimiz.php" class="rts-btn btn-primary"><?php echo t('all_products'); ?> <i class="fas fa-arrow-right ms-2"></i></a>
            </div>
        </div>
    </div>
</div>
<?php endif; ?>


<?php if ($qualitySection): ?>
    <div class="business-goal-area-2 rts-section-gap">
        <div class="container pt--30">
            <div class="row mb--60">
                <div class="col-lg-12">
                    <div class="title-style-two center">
                        <span class="bg-content"><?php echo htmlspecialchars($qualitySection['subtitle'] ?? 'Kalite'); ?></span>
                        <span class="pre"><?php echo htmlspecialchars($qualitySection['subtitle'] ?? 'Kalite'); ?></span>
                        <h2 class="title rts-text-anime-style-1"><?php echo htmlspecialchars($qualitySection['title']); ?></h2>
                    </div>
                </div>
            </div>
            
            <?php if (!empty($qualityItems)): ?>
                <div class="row g-4">
                    <?php foreach ($qualityItems as $index => $item): ?>
                        <div class="col-lg-4 col-md-6" data-aos="fade-up" data-aos-delay="<?php echo $index * 100; ?>" data-aos-duration="1000">
                            <div class="premium-quality-item-card">
                                <div class="premium-card-wrapper">
                                    <div class="premium-card-glow"></div>
                                    <div class="premium-card-content">
                                        <div class="premium-item-icon-container">
                                            <div class="premium-icon-wrapper">
                                                <?php if (!empty($item['icon'])): ?>
                                                    <i class="<?php echo htmlspecialchars($item['icon']); ?>"></i>
                                                <?php else: ?>
                                                    <i class="fas fa-check-circle"></i>
                                                <?php endif; ?>
                                            </div>
                                            <div class="premium-icon-ring"></div>
                                        </div>
                                        <div class="premium-item-content-wrapper">
                                            <h3 class="premium-item-heading"><?php echo htmlspecialchars($item['title']); ?></h3>
                                            <?php if (!empty($item['description'])): ?>
                                                <p class="premium-item-text"><?php echo nl2br(htmlspecialchars($item['description'])); ?></p>
                                            <?php endif; ?>
                                        </div>
                                        <div class="premium-card-hover-effect"></div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    <?php endforeach; ?>
                </div>
            <?php endif; ?>
            
            <?php if (empty($qualityItems) && ($qualitySection['item1_title'] || $qualitySection['item2_title'])): ?>
                <div class="row mt--60">
                    <div class="col-lg-6">
                        <div class="consultancy-style-one">
                            <?php if ($qualitySection['item1_title']): ?>
                                <div class="signle-consultancy mb--30">
                                    <div class="icon">
                                        <?php if ($qualitySection['item1_icon']): ?>
                                            <img loading="lazy" src="<?php echo htmlspecialchars($qualitySection['item1_icon']); ?>" alt="">
                                        <?php else: ?>
                                        <img loading="lazy" src="assets/images/about/icons/01.svg" alt="">
                                        <?php endif; ?>
                                    </div>
                                    <div class="information">
                                        <h4 class="title"><?php echo htmlspecialchars($qualitySection['item1_title']); ?></h4>
                                        <p class="disc"><?php echo htmlspecialchars($qualitySection['item1_description']); ?></p>
                                    </div>
                                </div>
                            <?php endif; ?>
                            <?php if ($qualitySection['item2_title']): ?>
                                <div class="signle-consultancy">
                                    <div class="icon">
                                        <?php if ($qualitySection['item2_icon']): ?>
                                            <img loading="lazy" src="<?php echo htmlspecialchars($qualitySection['item2_icon']); ?>" alt="">
                                        <?php else: ?>
                                        <img loading="lazy" src="assets/images/about/icons/02.svg" alt="">
                                        <?php endif; ?>
                                    </div>
                                    <div class="information">
                                        <h4 class="title"><?php echo htmlspecialchars($qualitySection['item2_title']); ?></h4>
                                        <p class="disc"><?php echo htmlspecialchars($qualitySection['item2_description']); ?></p>
                                    </div>
                                </div>
                            <?php endif; ?>
                        </div>
                    </div>
                    <div class="col-lg-6">
                        <div class="thumbnail-business-area-right-two">
                        <?php if ($qualitySection['image1']): ?>
                            <div class="large-thumbnail">
                                <img loading="lazy" src="<?php echo htmlspecialchars($qualitySection['image1']); ?>" alt="">
                            </div>
                        <?php endif; ?>
                        <?php if ($qualitySection['image2']): ?>
                            <div class="small-thumbnail images-r">
                                <img loading="lazy" src="<?php echo htmlspecialchars($qualitySection['image2']); ?>" alt="">
                            </div>
                        <?php endif; ?>
                    </div>
                </div>
            </div>
            <?php endif; ?>
            
            <?php if ($qualitySection['button_text']): ?>
                <div class="row mt--60">
                    <div class="col-lg-12 text-center">
                        <a href="<?php echo htmlspecialchars($qualitySection['button_url']); ?>" class="rts-btn btn-primary">
                            <?php echo htmlspecialchars($qualitySection['button_text']); ?>
                        </a>
                    </div>
                </div>
            <?php endif; ?>
        </div>
    </div>
<?php endif; ?>

<?php if (!empty($counters)): ?>
    <div class="rts-counter-up-area rts-section-gap counter-bg counter-compact">
        <div class="container">
            <div class="row g-5">
            <?php foreach ($counters as $counter): ?>
                <div class="col-xl-3 col-lg-4 col-md-6 col-sm-6 col-12">
                    <div class="single-counter">
                        <div class="icon">
                            <?php if ($counter['icon_image']): ?>
                                <img loading="lazy" src="<?php echo htmlspecialchars($counter['icon_image']); ?>" alt="counter">
                            <?php else: ?>
                                <img loading="lazy" src="assets/images/counterup/icon/01.svg" alt="counter">
                            <?php endif; ?>
                        </div>
                        <div class="counter-details">
                            <h2 class="counter title"><span class="odometer" data-count="<?php echo $counter['count']; ?>">00</span>+</h2>
                            <p class="disc"><?php echo htmlspecialchars($counter['title']); ?></p>
                        </div>
                    </div>
                </div>
            <?php endforeach; ?>
        </div>
    </div>
</div>
<?php endif; ?>

<?php if (!empty($projects)): ?>
    <div class="rts-gallery-area rts-section-gap gallery-bg bg_image">
        <div class="container pt--40">
            <div class="row">
                <div class="col-lg-12">
                    <div class="title-area-between-wrapper-gallery-project">
                        <div class="title-style-two mb--40 left">
                            <span class="bg-content">May Fren Sistemleri</span>
                            <span class="pre">May Fren Sistemleri</span>
                        <h2 class="title rts-text-anime-style-1"><?php echo t('product_groups'); ?></h2>
                    </div>
                    <div class="swiper-paginations"></div>
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-lg-12">
                    <div class="project-style-one-wrapper">
                        <div class="swiper mySwiper-project-1">
                            <div class="swiper-wrapper">
                            <?php foreach ($projects as $project): ?>
                                <div class="swiper-slide">
                                    <div class="project-style-one">
                                        <a href="<?php echo htmlspecialchars($project['url']); ?>" class="thumbnail">
                                            <?php if ($project['image']): ?>
                                                <img loading="lazy" src="<?php echo htmlspecialchars($project['image']); ?>" alt="project">
                                            <?php else: ?>
                                            <img loading="lazy" src="assets/images/project/01.webp" alt="project">
                                            <?php endif; ?>
                                        </a>
                                        <div class="inner-content">
                                            <a href="<?php echo htmlspecialchars($project['url']); ?>">
                                                <h5 class="title"><?php echo htmlspecialchars($project['title']); ?></h5>
                                            </a>
                                            <span><?php echo htmlspecialchars($project['description']); ?></span>
                                        </div>
                                    </div>
                                </div>
                            <?php endforeach; ?>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<?php endif; ?>

<?php if (!empty($blogPosts)): ?>
    <div class="news-section-modern rts-section-gap">
        <div class="container">
            <div class="row">
                <div class="col-lg-12">
                    <div class="title-style-two center">
                        <span class="bg-content">MAY FREN</span>
                        <span class="pre">MAY FREN</span>
                    <h2 class="title"><?php echo t('our_news'); ?></h2>
                </div>
                </div>
            </div>
            <div class="row g-4 mt--40">
                <?php foreach ($blogPosts as $index => $post): 
                    $postDate = !empty($post['published_at']) ? $post['published_at'] : $post['created_at'];
                    $formattedDate = date('d.m.Y', strtotime($postDate));
                ?>
                <div class="col-lg-4 col-md-6" data-aos="fade-up" data-aos-delay="<?php echo $index * 100; ?>">
                    <div class="news-card-modern">
                        <a href="haber-detay.php?id=<?php echo $post['id']; ?>" class="news-card-image">
                                                <?php if ($post['image']): ?>
                                <img loading="lazy" src="<?php echo htmlspecialchars($post['image']); ?>" alt="<?php echo htmlspecialchars($post['title']); ?>">
                                                <?php else: ?>
                                <img loading="lazy" src="assets/images/blog/01.webp" alt="<?php echo htmlspecialchars($post['title']); ?>">
                                                <?php endif; ?>
                            <div class="news-card-overlay"></div>
                        </a>
                        <div class="news-card-content">
                            <div class="news-card-date">
                                <i class="far fa-calendar-alt"></i>
                                <span><?php echo $formattedDate; ?></span>
                            </div>
                            <h4 class="news-card-title">
                                <a href="haber-detay.php?id=<?php echo $post['id']; ?>">
                                    <?php echo htmlspecialchars($post['title']); ?>
                                </a>
                            </h4>
                            <?php if (!empty($post['excerpt'])): ?>
                                <p class="news-card-excerpt"><?php echo htmlspecialchars(mb_substr(strip_tags($post['excerpt']), 0, 100)); ?>...</p>
                            <?php endif; ?>
                            <a href="haber-detay.php?id=<?php echo $post['id']; ?>" class="news-card-link">
                                <?php echo t('read_more'); ?> <i class="fas fa-arrow-right"></i>
                                            </a>
                                        </div>
                                    </div>
                                </div>
                            <?php endforeach; ?>
                            </div>
            <div class="row mt--50">
                <div class="col-lg-12 text-center">
                    <a href="haberler.php" class="rts-btn btn-primary"><?php echo t('all_news'); ?> <i class="fas fa-arrow-right ms-2"></i></a>
                </div>
            </div>
        </div>
    </div>
<?php endif; ?>

<?php include 'includes/footer.php'; ?>

<style>
/* Slider Yukseklik Ayari */
.banner-swiper-two .rts-banner-area-two {
    height: 480px !important;
    min-height: 480px !important;
}

/* Slider Yon Oklari */
.mySwiper-banner-two .swiper-button-next,
.mySwiper-banner-two .swiper-button-prev {
    width: 60px;
    height: 60px;
    background: rgba(255, 255, 255, 0.9);
    border-radius: 50%;
    box-shadow: 0 5px 20px rgba(0, 0, 0, 0.15);
    transition: all 0.3s ease;
}

.mySwiper-banner-two .swiper-button-next:hover,
.mySwiper-banner-two .swiper-button-prev:hover {
    background: #82b440;
    transform: scale(1.1);
}

.mySwiper-banner-two .swiper-button-next::after,
.mySwiper-banner-two .swiper-button-prev::after {
    font-size: 20px;
    font-weight: bold;
    color: #1C2539;
    transition: color 0.3s ease;
}

.mySwiper-banner-two .swiper-button-next:hover::after,
.mySwiper-banner-two .swiper-button-prev:hover::after {
    color: #fff;
}

.mySwiper-banner-two .swiper-button-prev {
    left: 30px;
}

.mySwiper-banner-two .swiper-button-next {
    right: 30px;
}

@media (max-width: 768px) {
    .mySwiper-banner-two .swiper-button-next,
    .mySwiper-banner-two .swiper-button-prev {
        width: 45px;
        height: 45px;
    }
    
    .mySwiper-banner-two .swiper-button-next::after,
    .mySwiper-banner-two .swiper-button-prev::after {
        font-size: 16px;
    }
    
    .mySwiper-banner-two .swiper-button-prev {
        left: 15px;
    }
    
    .mySwiper-banner-two .swiper-button-next {
        right: 15px;
    }
}

.banner-swiper-two .rts-banner-area-two .banner-inner-two-content {
    padding-top: 60px;
}

.banner-swiper-two .rts-banner-area-two .banner-inner-two-content .title {
    font-size: 44px;
    line-height: 1.2;
}

@media (max-width: 991px) {
    .banner-swiper-two .rts-banner-area-two {
        height: 400px !important;
        min-height: 400px !important;
    }
    
    .banner-swiper-two .rts-banner-area-two .banner-inner-two-content .title {
        font-size: 34px;
    }
}

@media (max-width: 575px) {
    .banner-swiper-two .rts-banner-area-two {
        height: 340px !important;
        min-height: 340px !important;
    }
    
    .banner-swiper-two .rts-banner-area-two .banner-inner-two-content {
        padding-top: 50px;
    }
    
    .banner-swiper-two .rts-banner-area-two .banner-inner-two-content .title {
        font-size: 26px;
    }
}

.production-process-section {
    position: relative;
    overflow: visible !important;
    z-index: 1;
    padding-top: 30px !important;
    padding-bottom: 30px !important;
}

.production-images-grid {
    position: relative;
    z-index: 2;
    clear: both;
}

.production-image-card {
    position: relative;
    overflow: hidden;
    border-radius: 15px;
    box-shadow: 0 10px 30px rgba(0, 0, 0, 0.1);
    transition: all 0.4s cubic-bezier(0.23, 1, 0.32, 1);
    background: #ffffff;
    padding: 10px;
}

.production-image-card:hover {
    transform: translateY(-10px);
    box-shadow: 0 20px 50px rgba(130, 180, 64, 0.2);
}

.production-image-wrapper {
    position: relative;
    width: 100%;
    height: 200px;
    overflow: hidden;
    border-radius: 12px;
    background: #f8f9fa;
    display: flex;
    align-items: center;
    justify-content: center;
    padding: 15px;
}

.production-image {
    width: 100%;
    height: 100%;
    object-fit: contain;
    transition: transform 0.4s ease;
    display: block;
}

.production-image-card:hover .production-image {
    transform: scale(1.1);
}

.production-image-overlay {
    position: absolute;
    top: 0;
    left: 0;
    right: 0;
    bottom: 0;
    background: linear-gradient(135deg, rgba(130, 180, 64, 0.1) 0%, transparent 100%);
    opacity: 0;
    transition: opacity 0.4s ease;
    z-index: 1;
}

.production-image-card:hover .production-image-overlay {
    opacity: 1;
}

.counter-compact {
    height: auto !important;
    min-height: 300px !important;
    padding: 60px 0 !important;
}

.counter-compact .single-counter {
    justify-content: center;
    text-align: center;
    flex-direction: column;
    gap: 15px !important;
}

.counter-compact .single-counter .icon {
    margin: 0 auto;
}

.counter-compact .single-counter .counter-details {
    text-align: center;
}

.premium-quality-item-card {
    height: 100%;
    position: relative;
}

.premium-card-wrapper {
    position: relative;
    height: 100%;
}

.premium-card-glow {
    position: absolute;
    top: -20px;
    left: -20px;
    right: -20px;
    bottom: -20px;
    background: radial-gradient(circle, rgba(130, 180, 64, 0.2) 0%, transparent 70%);
    border-radius: 30px;
    opacity: 0;
    transition: opacity 0.6s ease;
    z-index: 0;
}

.premium-quality-item-card:hover .premium-card-glow {
    opacity: 1;
}

.premium-card-content {
    background: rgba(255, 255, 255, 0.95);
    backdrop-filter: blur(20px);
    border-radius: 30px;
    padding: 50px 35px;
    height: 100%;
    display: flex;
    flex-direction: column;
    align-items: center;
    text-align: center;
    box-shadow: 0 15px 50px rgba(0, 0, 0, 0.08);
    transition: all 0.6s cubic-bezier(0.23, 1, 0.32, 1);
    position: relative;
    z-index: 1;
    border: 1px solid rgba(255, 255, 255, 0.6);
    overflow: hidden;
}

.premium-quality-item-card:hover .premium-card-content {
    transform: translateY(-20px) scale(1.02);
    box-shadow: 0 25px 70px rgba(130, 180, 64, 0.25);
}

.premium-card-hover-effect {
    position: absolute;
    top: 0;
    left: 0;
    right: 0;
    height: 5px;
    background: linear-gradient(90deg, #82b440 0%, #6ea035 100%);
    transform: scaleX(0);
    transform-origin: left;
    transition: transform 0.6s cubic-bezier(0.23, 1, 0.32, 1);
}

.premium-quality-item-card:hover .premium-card-hover-effect {
    transform: scaleX(1);
}

.premium-item-icon-container {
    position: relative;
    margin-bottom: 30px;
}

.premium-icon-wrapper {
    width: 120px;
    height: 120px;
    background: linear-gradient(135deg, #82b440 0%, #6ea035 100%);
    border-radius: 30px;
    display: flex;
    align-items: center;
    justify-content: center;
    position: relative;
    z-index: 1;
    box-shadow: 0 15px 40px rgba(130, 180, 64, 0.3);
    transition: all 0.6s cubic-bezier(0.23, 1, 0.32, 1);
}

.premium-quality-item-card:hover .premium-icon-wrapper {
    transform: scale(1.2) rotate(10deg);
}

.premium-icon-ring {
    position: absolute;
    top: -10px;
    left: -10px;
    right: -10px;
    bottom: -10px;
    border: 3px solid rgba(130, 180, 64, 0.3);
    border-radius: 35px;
    opacity: 0;
    transition: all 0.6s ease;
}

.premium-quality-item-card:hover .premium-icon-ring {
    opacity: 1;
    transform: scale(1.1);
}

.premium-icon-wrapper i {
    font-size: 52px;
    color: #ffffff;
}

.premium-item-content-wrapper {
    flex: 1;
}

.premium-item-heading {
    font-size: 24px;
    font-weight: 700;
    color: #1C2539;
    margin: 0 0 18px 0;
    transition: all 0.4s ease;
}

.premium-quality-item-card:hover .premium-item-heading {
    color: #82b440;
}

.premium-item-text {
    font-size: 16px;
    color: #5D666F;
    line-height: 1.8;
    margin: 0;
}

@media (max-width: 768px) {
    .production-image-wrapper {
        height: 160px;
        padding: 10px;
    }
}

/* Yeni Urunler Bolumu */
.new-products-section {
    background: #f8f9fa;
    padding: 80px 0;
}

.new-product-card {
    background: #fff;
    border-radius: 16px;
    overflow: hidden;
    box-shadow: 0 5px 25px rgba(0, 0, 0, 0.08);
    transition: all 0.4s ease;
    height: 100%;
    display: flex;
    flex-direction: column;
}

.new-product-card:hover {
    transform: translateY(-10px);
    box-shadow: 0 15px 40px rgba(130, 180, 64, 0.2);
}

.product-image-link {
    display: block;
}

.product-image-wrapper {
    height: 220px;
    overflow: hidden;
    background: #fff;
    display: flex;
    align-items: center;
    justify-content: center;
    padding: 20px;
}

.product-image {
    max-width: 100%;
    max-height: 100%;
    object-fit: contain;
    transition: transform 0.4s ease;
}

.new-product-card:hover .product-image {
    transform: scale(1.05);
}

.product-info {
    padding: 25px;
    flex: 1;
    display: flex;
    flex-direction: column;
    border-top: 1px solid #eee;
}

.product-title {
    font-size: 18px;
    font-weight: 700;
    margin: 0 0 10px;
    line-height: 1.4;
}

.product-title a {
    color: #1C2539;
    text-decoration: none;
    transition: color 0.3s ease;
}

.product-title a:hover {
    color: #82b440;
}

.product-desc {
    font-size: 14px;
    color: #666;
    line-height: 1.6;
    margin: 0 0 15px;
    flex: 1;
}

.product-link {
    display: inline-flex;
    align-items: center;
    gap: 8px;
    font-size: 14px;
    font-weight: 600;
    color: #82b440;
    text-decoration: none;
    transition: all 0.3s ease;
}

.product-link:hover {
    color: #6ea035;
    gap: 12px;
}

.product-link i {
    transition: transform 0.3s ease;
}

.product-link:hover i {
    transform: translateX(3px);
}

@media (max-width: 991px) {
    .new-products-section {
        padding: 60px 0;
    }
    
    .product-image-wrapper {
        height: 180px;
    }
}

@media (max-width: 576px) {
    .product-image-wrapper {
        height: 160px;
    }
    
    .product-info {
        padding: 20px;
    }
    
    .product-title {
        font-size: 16px;
    }
    
    .premium-card-content {
        padding: 40px 25px;
    }
    
    .premium-icon-wrapper {
        width: 100px;
        height: 100px;
    }
    
    .premium-icon-wrapper i {
        font-size: 42px;
    }
    
    .premium-item-heading {
        font-size: 22px;
    }
}

/* Modern Haber Kartlari */
.news-section-modern {
    background: linear-gradient(180deg, #f8f9fa 0%, #ffffff 100%);
    padding: 80px 0;
}

.news-card-modern {
    background: #fff;
    border-radius: 20px;
    overflow: hidden;
    box-shadow: 0 10px 40px rgba(0, 0, 0, 0.08);
    transition: all 0.4s cubic-bezier(0.23, 1, 0.32, 1);
    height: 100%;
    display: flex;
    flex-direction: column;
}

.news-card-modern:hover {
    transform: translateY(-15px);
    box-shadow: 0 25px 60px rgba(130, 180, 64, 0.2);
}

.news-card-image {
    position: relative;
    height: 220px;
    overflow: hidden;
    display: block;
}

.news-card-image img {
    width: 100%;
    height: 100%;
    object-fit: cover;
    transition: transform 0.6s ease;
}

.news-card-modern:hover .news-card-image img {
    transform: scale(1.1);
}

.news-card-overlay {
    position: absolute;
    top: 0;
    left: 0;
    right: 0;
    bottom: 0;
    background: linear-gradient(180deg, transparent 0%, rgba(0, 0, 0, 0.3) 100%);
    opacity: 0;
    transition: opacity 0.4s ease;
}

.news-card-modern:hover .news-card-overlay {
    opacity: 1;
}

.news-card-content {
    padding: 25px;
    flex: 1;
    display: flex;
    flex-direction: column;
}

.news-card-date {
    display: inline-flex;
    align-items: center;
    gap: 8px;
    font-size: 13px;
    color: #82b440;
    font-weight: 600;
    margin-bottom: 12px;
}

.news-card-date i {
    font-size: 14px;
}

.news-card-title {
    font-size: 20px;
    font-weight: 700;
    line-height: 1.4;
    margin: 0 0 12px;
    flex: 1;
}

.news-card-title a {
    color: #1C2539;
    text-decoration: none;
    transition: color 0.3s ease;
    display: -webkit-box;
    -webkit-line-clamp: 2;
    -webkit-box-orient: vertical;
    overflow: hidden;
}

.news-card-title a:hover {
    color: #82b440;
}

.news-card-excerpt {
    font-size: 14px;
    color: #666;
    line-height: 1.7;
    margin: 0 0 20px;
    display: -webkit-box;
    -webkit-line-clamp: 2;
    -webkit-box-orient: vertical;
    overflow: hidden;
}

.news-card-link {
    display: inline-flex;
    align-items: center;
    gap: 8px;
    font-size: 14px;
    font-weight: 600;
    color: #82b440;
    text-decoration: none;
    transition: all 0.3s ease;
    margin-top: auto;
}

.news-card-link:hover {
    color: #6ea035;
    gap: 12px;
}

.news-card-link i {
    transition: transform 0.3s ease;
}

.news-card-link:hover i {
    transform: translateX(5px);
}

@media (max-width: 991px) {
    .news-section-modern {
        padding: 60px 0;
    }
    
    .news-card-image {
        height: 180px;
    }
    
    .news-card-title {
        font-size: 18px;
    }
}

@media (max-width: 576px) {
    .news-card-image {
        height: 160px;
    }
    
    .news-card-content {
        padding: 20px;
    }
    
    .news-card-title {
        font-size: 16px;
    }
}
</style>