<?php
include_once 'header.php';

// Include database connection
require_once 'db_connection.php';

$type = isset($_GET['type']) ? trim($_GET['type']) : '';

$stmt = $conn->prepare("SELECT * FROM solutions WHERE status = '1' AND alias = ? LIMIT 1");
if (!$stmt) {
    die("Prepare failed: " . $conn->error);
}

$stmt->bind_param("s", $type);
if (!$stmt->execute()) {
    die("Execute failed: " . $stmt->error);
}

$result = $stmt->get_result();
$industry = $result->fetch_assoc();

$solutions_sql = "
    SELECT categories.* 
    FROM categories
    INNER JOIN industry_solution ON industry_solution.solution_id = categories.id_categories
    WHERE categories.status = 1 
      AND categories.parent IS NULL 
      AND industry_solution.industry_id = {$industry['id_solutions']}
    ORDER BY categories.priority ASC
";
$solutions = $conn->query($solutions_sql);
if (!$solutions) {
    die("Query failed: " . $conn->error);
}

// Query to fetch blog data
$blogs_sql = "
    SELECT * 
    FROM blog 
    WHERE status = 1 
      AND type = 'case study' 
      AND industry_id = {$industry['id_solutions']}
";
$blog_data = $conn->query($blogs_sql);

// Convert result to array
$blogs = [];
while ($row = $blog_data->fetch_assoc()) {
    $blogs[] = $row;
}

$conn->close();
?>

<section class="u-clearfix u-image u-section-1" id="sec-5169" data-image-width="1280" data-image-height="853" style="background-image: linear-gradient(0deg, rgba(0,0,0,0.5), rgba(0,0,0,0.5)), url('https://www.indolok.id/cms/uploads/solution/<?= $industry['thumbnail'] ?>'); background-position: 50% 50%;">
  <div class="u-clearfix u-sheet u-valign-middle u-sheet-1" >
    <h1 class="u-align-center u-text u-text-body-alt-color u-title u-text-1" style="font-weight: 700; text-transform: uppercase; margin: 60px;"><?= $industry['solution'] ?></h1>
  </div>
</section>

<section class="u-clearfix u-white u-section-2" id="airport-security-solutions">
  <div class="u-clearfix u-sheet u-valign-middle-lg u-valign-middle-md u-valign-middle-sm u-valign-middle-xl u-sheet-1" style="min-height: 500px;">
    <div class="u-clearfix u-expanded-width u-layout-wrap u-layout-wrap-1">
      <div class="u-layout">
        <div class="u-layout-row">
          <div class="u-container-style u-layout-cell u-size-30 u-layout-cell-1">
            <div class="u-container-layout u-container-layout-1">
              <img class="u-image u-image-default u-image-1" src="https://www.indolok.id/cms/uploads/solution/<?= $industry['image1'] ?>" alt="<?= $industry['solution'] ?>" style="width:100%; object-fit: cover; height: 100%;">
            </div>
          </div>
          <div class="u-align-left u-container-style u-layout-cell u-size-30 u-layout-cell-2" style="padding: 30px;">
            <div class="normalFontSize u-container-layout u-container-layout-2">
              <h2 class="u-custom-font u-text u-text-custom-color-5 u-text-1" style="font-family: Poppins; font-weight: 600;"><?= $industry['solution'] ?></h2>
              <?= $industry['description'] ?>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</section>

<section class="u-align-center u-clearfix u-container-align-center u-custom-color-10 u-section-3" id="sec-f608">
  <div class="industryDetailBoxes u-clearfix u-sheet u-valign-middle u-sheet-1">
      <h2 class="u-align-center u-custom-font u-text u-text-1" style="font-family: Poppins;
    font-size: 1.875rem;
    font-weight: 500;
    width: 100%;
    text-align:center;
    margin: 60px auto 0; color:white"> Solusi <?= $industry['solution'] ?></h2>
    <?= $industry['description2'] ?>
    <div class="u-expanded-width u-layout-grid u-list u-list-1">
      <div class="u-repeater u-repeater-1">
        <?php if (isset($solutions) && $solutions->num_rows > 0): ?>
          <?php while($row = $solutions->fetch_assoc()): ?>
            <div class="u-align-center u-container-style u-list-item u-repeater-item u-white">
              <div class="u-container-layout u-similar-container u-valign-top">
                <h4 class="u-align-left u-custom-font u-text u-text-custom-color-5"><a href="solution.php?type=<?= $row['alias'] ?>"><?= $row['category'] ?> <span class="u-text-custom-color-5">›</span></a></h4>
                <div class="u-card-description">
                  <p><?= !empty($row['description']) ? $row['description'] : 'A broad suite of products, systems, analytics, and managed solutions.' ?></p>
                </div>
              </div>
            </div>
          <?php endwhile; ?>
        <?php else: ?>
          <p>No other solutions found in this category.</p>
        <?php endif; ?>
      </div>
    </div>
  </div>
</section>

<?php if (count($blogs) > 0): ?>
<!-- Studi Kasus Aviasi Section -->
    <section class="u-align-center u-clearfix u-image u-section-12" id="carousel_aviasi" data-image-width="768" data-image-height="429" style="background-image: linear-gradient(0deg, rgba(0,0,0,0.7), rgba(0,0,0,0.7)), url('https://www.indolok.id/cms/uploads/solution/<?= $industry['thumbnail'] ?>'); background-position: 50% 50%;">
        <div class="u-clearfix u-sheet u-valign-middle-lg u-sheet-1">
            <h1 class="u-custom-font u-text u-text-body-alt-color u-text-1">Case Study Aviasi</h1>
            
            <div class="u-blog u-expanded-width u-layout-horizontal u-blog-1" data-items-per-page="3">
                <div class="u-list-control"></div>
               
                <div class="u-repeater u-repeater-1">
                    <?php foreach ($blogs as $i => $blog): ?>
                        <div class="u-align-left u-blog-post u-container-style u-repeater-item u-video-cover u-white u-repeater-item-1">
                            <div class="u-container-layout u-similar-container u-valign-top-md u-valign-top-sm u-valign-top-xs u-container-layout-1">
                                <a class="u-post-header-link" href="https://www.indolok.id/blog-detail.php?slug=<?= strtolower($blog['alias']) ?>">
                                    <img alt="" class="u-blog-control u-expanded-width u-image u-image-default u-image-1" src="https://www.indolok.id/cms/uploads/blog/<?= $blog['image1'] ?>" data-image-width="4341" data-image-height="3000">
                                </a>
                                <h2 class="u-text u-text-custom-color-5 u-text-2">
                                    <a class="u-active-none u-btn u-button-link u-button-style u-hover-none u-btn-1" href="https://www.indolok.id/blog-detail.php?slug=<?= strtolower($blog['alias']) ?>"><?= $blog['blog'] ?></a>
                                </h2> 
                                <div class="blogText u-custom-font u-heading-font u-text u-text-3">
                                     <?= substr(strip_tags($blog['description']), 0, 150) ?>...
                                </div>
                            </div>
                        </div>
                    <?php endforeach ?>
                </div>
                <div class="u-list-control"></div>
                <a class="u-gallery-nav u-gallery-nav-prev u-grey-70 u-icon-circle u-opacity u-opacity-70 u-spacing-10 u-text-white u-gallery-nav-1" href="#" role="button">
                    <span aria-hidden="true">
                        <svg viewBox="0 0 451.847 451.847">
                            <path d="M97.141,225.92c0-8.095,3.091-16.192,9.259-22.366L300.689,9.27c12.359-12.359,32.397-12.359,44.751,0
c12.354,12.354,12.354,32.388,0,44.748L173.525,225.92l171.903,171.909c12.354,12.354,12.354,32.391,0,44.744
c-12.354,12.365-32.386,12.365-44.745,0l-194.29-194.281C100.226,242.115,97.141,234.018,97.141,225.92z"></path>
                        </svg>
                    </span>
                    <span class="sr-only">
                        <svg viewBox="0 0 451.847 451.847">
                            <path d="M97.141,225.92c0-8.095,3.091-16.192,9.259-22.366L300.689,9.27c12.359-12.359,32.397-12.359,44.751,0
c12.354,12.354,12.354,32.388,0,44.748L173.525,225.92l171.903,171.909c12.354,12.354,12.354,32.391,0,44.744
c-12.354,12.365-32.386,12.365-44.745,0l-194.29-194.281C100.226,242.115,97.141,234.018,97.141,225.92z"></path>
                        </svg>
                    </span>
                </a>
                <a class="u-gallery-nav u-gallery-nav-next u-grey-70 u-icon-circle u-opacity u-opacity-70 u-spacing-10 u-text-white u-gallery-nav-2" href="#" role="button">
                    <span aria-hidden="true">
                        <svg viewBox="0 0 451.846 451.847">
                            <path d="M345.441,248.292L151.154,442.573c-12.359,12.365-32.397,12.365-44.75,0c-12.354-12.354-12.354-32.391,0-44.744
L278.318,225.92L106.409,54.017c-12.354-12.359-12.354-32.394,0-44.748c12.354-12.359,32.391-12.359,44.75,0l194.287,194.284
c6.177,6.18,9.262,14.271,9.262,22.366C354.708,234.018,351.617,242.115,345.441,248.292z"></path>
                        </svg>
                    </span>
                    <span class="sr-only">
                        <svg viewBox="0 0 451.846 451.847">
                            <path d="M345.441,248.292L151.154,442.573c-12.359,12.365-32.397,12.365-44.75,0c-12.354-12.354-12.354-32.391,0-44.744
L278.318,225.92L106.409,54.017c-12.354-12.359-12.354-32.394,0-44.748c12.354-12.359,32.391-12.359,44.75,0l194.287,194.284
c6.177,6.18,9.262,14.271,9.262,22.366C354.708,234.018,351.617,242.115,345.441,248.292z"></path>
                        </svg>
                    </span>
                </a>
            </div>
        </div>
    </section>
    <!-- End Studi Kasus Aviasi Section -->
<?php endif ?> 

<?php include_once 'footer.php'; ?>