<?php include 'header.php';?>
    <div class="bread-crumb-section">
        <div class="container">
            <div class="row justify-content-center align-items-center">
                <div class="col-lg-8 d-flex justify-content-lg-start justify-content-center flex-column">
                    <h2 class="bread-crumb-title">Production</h2>
                    <nav aria-label="breadcrumb">
                        <ol class="breadcrumb gap-3 m-0 p-0">
                            <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                            <li class="breadcrumb-item active" aria-current="page">Production</li>
                        </ol>
                    </nav>
                </div>
                <div class="col-lg-4">
                    <div class="circle-text-common circel-tex-area1">
                        <img src="assets/images/bg/logod.png" alt="image" width="130px">
                        <p id="CircleTypeText1" class="circle-text">designs point *&nbsp; </p>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="our-portfilio-area bg-color2 pt-50 pb-120">
        <div class="container">
           <div class="row justify-content-center g-4">
               <div class="col-lg-12 text-center">
                   <h2 class="section-title-one">Photography</h2>
               </div>
               <div class="col-lg-12">
                   <div class="filters filter-button-group">
                   <ul class="d-flex justify-content-lg-center justify-content-center flex-wrap">
                            <?php
                               include('admin/connection.php');
                                $sql = "SELECT DISTINCT title, filter_class, sub_category_services, is_production FROM production";
                                 $result = $conn->query($sql);
                               if ($result->num_rows > 0) {
                                 echo '<li class="active" data-filter="*">All <span></span></li>';
                                  while ($row = $result->fetch_assoc()) {
                                     $filter_class = htmlspecialchars($row['filter_class']);
                                      $category = htmlspecialchars($row['title']);
                                       $subcategory = htmlspecialchars($row['sub_category_services']);
                                      $is_production = htmlspecialchars($row['is_production']);

                                    if ($is_production == 1 && $category != $subcategory) {
                                       echo '<li data-filter=".' . $filter_class . '">' . $category . ' <span></span></li>';
                                    }
                                }
                               } else {
                               echo '<li>No categories found</li>';
                              }
                              $conn->close();
                            ?>
                       </ul>
                   </div>
               </div>
           </div>
           <div class="row grid g-4 mb-70 justify-content-center">
                <?php
                include('admin/connection.php');

                $sqlImages = "SELECT category_id,image FROM photo_management ORDER BY id DESC";
                $resultImages = $conn->query($sqlImages);

                if (!$resultImages) {
                    die("Query failed: " . $conn->error);
                }

                if ($resultImages->num_rows > 0) {
                    while ($image = $resultImages->fetch_assoc()) {
                        $catId = $image['category_id'];
                        $categorySql = "SELECT `title`,`sub_category_services`,`filter_class`,`is_production` FROM production where id='$catId'";
                        $resultCategoriess = $conn->query($categorySql);
                        $catData = $resultCategoriess->fetch_assoc();
                        $filterClass = htmlspecialchars($image['category_id']);
                        $category = htmlspecialchars($catData['title']);
                        $subcategory = htmlspecialchars($catData['sub_category_services']);
                        $isproduction = htmlspecialchars($catData['is_production']);

                        if ($isproduction ==1 && $category != $subcategory) {
                            $image_path = 'admin/photomanagement/uploads/' . basename($image['image']);
                          ?>
                          <div class="col-xl-4 col-lg-4 col-md-6 col-sm-6 grid-item <?= $catData['filter_class'] ?>">
                            <img class="img-fluid" src="<?= $image_path ?>" alt="image" style='max-width: 1000px;'>
                          </div>
                         <?php
                        }
                        

                    }
                } else {
                    ?>
                    <div class="col-12 text-center">No images found</div>
                    <?php
                }

                $conn->close();
                ?>
            </div>
        </div>
    </div>

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