<?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);
}

$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 include_once 'footer.php'; ?>