<!-- header top start -->
<?php include('header_top.php');?>
<?php if($_REQUEST['category']!=''){
		$category=$_REQUEST['category'];
		$subcate=$_REQUEST['subcate'];
		$parentsubcate=$_REQUEST['parentsubcate'];
	   //   print_r($subcate);
	   //   exit();
		}else{
		header("https://couponclap.com/category-deals");
		}

		$category_query = mysqli_query($con, "
			SELECT * FROM categories 
			WHERE LOWER(REPLACE(slug,' ','-')) = '$category'
		");
		$category_details = mysqli_fetch_assoc($category_query);

		$subcate_query = mysqli_query($con, "
			SELECT * FROM subcategories 
			WHERE LOWER(REPLACE(slug,' ','-')) = '$subcate'
		");
		$subcate_details = mysqli_fetch_assoc($subcate_query);

		$parentsubcate_query = mysqli_query($con, "
			SELECT * FROM parent_subcategories 
			WHERE LOWER(REPLACE(slug,' ','-')) = '$parentsubcate'
		");
		$parentsubcate_details = mysqli_fetch_assoc($parentsubcate_query);
		
		$slugcategory = strtolower(str_replace(' ','-',$category_details['slug']));
		$slugsubcate = strtolower(str_replace(' ','-',$subcate_details['slug']));
		$slugptsubcate = strtolower(str_replace(' ','-',$parentsubcate_details['slug']));
	?>
<!-- header top end -->
<?php 
$c_id = $category_details['id'];
$query_meta = "SELECT * FROM meta_data WHERE meta_name='cat_$c_id'";
$res = mysqli_query($con, $query_meta);
while($row = mysqli_fetch_array($res)) {
?>
    <?php echo $row['content']; ?>
<?php 
}
?>

<link href='https://couponclap.com/static/css/frontend/category-deals.css' rel="stylesheet" />
<!-- header bottom start -->
<?php include('header_buttom.php');?>
<!-- header bottom end -->

<body style="background-color: #f2f2f1;">
	<!-- header menu start -->
	<?php include('header.php');?>
	<!-- header menu end -->
	<nav id="breadcrumb" class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
		<div class="breadcrumb-wrap col-xs-12 col-sm-12 col-md-12 col-lg-12">
			<ul class="crumbs col-xs-12 col-sm-12 col-md-12 col-lg-12">
				<li>
					<a href="https://couponclap.com/category-deals">
						<span itemprop="title">Home</span>
					</a>
				</li>
				/ <li>
					<a href="https://couponclap.com/category-deals/<?php echo $slugcategory;?>">
						<span itemprop="title">
							<?php echo $category_details['name'];?>
						</span>
					</a>
				</li>
				/<li>
					<a
						href="https://couponclap.com/category-deals/<?php echo $slugcategory;?>/<?php echo $slugsubcate;?>">
						<span itemprop="title">
							<?php echo $subcate_details['name'];?>
						</span>
					</a>
				/</li>
				<li>
					<a
						href="https://couponclap.com/category-deals/<?php echo $slugcategory;?>/<?php echo $slugsubcate;?>/<?php echo $slugptsubcate;?>">
						<span itemprop="title">
							<?php echo $parentsubcate_details['name'];?>
						</span>
					</a>
				</li>
			</ul>
		</div>
	</nav>

	<?php
	// ================= FILTER VALUES =================
			$category_filter = $category_details['id'] ?? '';
			$subcate_filter = $subcate_details['id'] ?? '';
			$parentsubcate_filter = $parentsubcate_details['id'] ?? '';
			
			
			// ================= GET VALUES =================
				$brandSlug    = $_GET['Brand'] ?? '';
				$storeSlug    = $_GET['Store'] ?? '';

				$where = " WHERE p.status='published' AND p.unpaused='0'";

				if(!empty($category_filter)){
					$cat_ids = $category_filter;
					$where .= " AND p.category_id IN ($cat_ids)";
				}
				
				if(!empty($subcate_filter)){
					$subcat_ids = $subcate_filter;
					$where .= " AND p.subcategories_id IN ($subcat_ids)";
				}
				
				if(!empty($parentsubcate_filter)){
					$ptsubcat_ids = $parentsubcate_filter;
					$where .= " AND p.parent_sub_category_id IN ($ptsubcat_ids)";
				}

				// ================= BRAND FILTER =================
				if(!empty($brandSlug)){
					$brands = explode(',', $brandSlug);
					$brands = array_map(function($v) use ($con){
						return "'" . mysqli_real_escape_string($con,$v) . "'";
					}, $brands);
					$where .= " AND b.slug IN (" . implode(',', $brands) . ")";
				}

				// ================= STORE FILTER =================
				if(!empty($storeSlug)){
					$stores = explode(',', $storeSlug);
					$stores = array_map(function($v) use ($con){
						return "'" . mysqli_real_escape_string($con,$v) . "'";
					}, $stores);
					$where .= " AND s.slug IN (" . implode(',', $stores) . ")";
				}

				// ================= PAGINATION =================
				// $limit = 9;
				// $page  = isset($_GET['page']) ? (int)$_GET['page'] : 1;
				// $start = ($page - 1) * $limit;

				// ================= TOTAL COUNT =================
				$count_query = "
				SELECT COUNT(*) as total
				FROM posts p
				LEFT JOIN categories c ON c.id = p.category_id
				LEFT JOIN subcategories sc ON sc.id = p.subcategories_id
				LEFT JOIN parent_subcategories psc ON psc.id = p.parent_sub_category_id
				LEFT JOIN brands b ON b.id = p.category_brand_id
				LEFT JOIN stores s ON s.id = p.stores_id
				$where
				";

				$count_result = mysqli_query($con, $count_query);
				$count_row = mysqli_fetch_assoc($count_result);
				$total_products = $count_row['total'];

				// ================= MAIN QUERY =================
				$query = "
				SELECT p.*, 
					b.name,
					b.slug AS brand_slug,
					s.store_name,
					c.name as category_name
				FROM posts p
				LEFT JOIN categories c ON c.id = p.category_id
				LEFT JOIN subcategories sc ON sc.id = p.subcategories_id
				LEFT JOIN parent_subcategories psc ON psc.id = p.parent_sub_category_id
				LEFT JOIN brands b ON b.id = p.category_brand_id
				LEFT JOIN stores s ON s.id = p.stores_id
				$where
				ORDER BY p.id DESC
				";

				$result = mysqli_query($con, $query);
				?>
	<div id="main-content" class="container col-xs-12 col-sm-12 col-md-12 col-lg-12">
		<div class="general-head-div col-xs-12 col-sm-12 col-md-12 col-lg-12">
			<div class="general-head"><?php echo $parentsubcate_details['name'];?> Deals</div>
			<div class="general-count-text">Total Products :
				<?php echo $total_products; ?>
			</div>
		</div>
		<button class="p-btns btn-modify col-xs-12 col-sm-12 col-md-12 col-lg-12" type="button">Modify Results</button>

		<aside class="fl-l sidebar col-xs-12 col-sm-12 col-md-3 col-lg-3">

			<section class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
				<a class="pd-close" href="#">x</a>
				<div class="sidebar-wrap container col-xs-12 col-sm-12 col-md-12 col-lg-12" id="side-filter">
					<h2>Filter Results:</h2>
					<div class="sf-title" style="margin-bottom: 10px;">Categories</div>
					<div class="side_product_category side-wrap clearfix" id="sf-cat">
						<ul>
							<?php 
							$sql_cate_deails = "SELECT * FROM categories WHERE id = '$category_filter' AND status = '1'";
							$res_cate_deails = mysqli_query($con, $sql_cate_deails);
							while($row_cate_deails = mysqli_fetch_assoc($res_cate_deails)){
								$slug = strtolower(str_replace(' ','-',$row_cate_deails['slug']));
								$category_id = $row_cate_deails['id'];
							?>
							<li>
								<a href="https://couponclap.com/category-deals/<?php echo $slug;?>"
									data-id="<?php echo $category_id;?>">
									<?php echo $row_cate_deails['name'];?>
								</a>

								<!-- Subcategory UL inside Category LI -->
								<ul>
									<?php 
									$sql_sub_cate_deails = "SELECT * FROM subcategories WHERE category_id = '$category_id' AND id = '$subcate_filter' AND show_on_menu = '1'";
									$res_sub_cate_deails = mysqli_query($con, $sql_sub_cate_deails);
									while($row_sub_cate_deails = mysqli_fetch_assoc($res_sub_cate_deails)){
										$sub_cate_slug = strtolower(str_replace(' ','-',$row_sub_cate_deails['slug']));
										$sub_category_id = $row_sub_cate_deails['id'];
									?>
									<li>
										<a href="https://couponclap.com/category-deals/<?php echo $slug;?>/<?php echo $sub_cate_slug;?>"
											data-id="<?php echo $sub_category_id;?>">
											<?php echo $row_sub_cate_deails['name'];?>
										</a>

										<!-- Parent Subcategory UL inside Subcategory LI -->
										<ul>
											<?php 
											$sql_parent_sub_cate_deails = "SELECT * FROM parent_subcategories WHERE sub_cate_id = '$sub_category_id' AND id = '$parentsubcate_filter' AND show_on_menu = '1'";
											$res_parent_sub_cate_deails = mysqli_query($con, $sql_parent_sub_cate_deails);
											while($row_parent_sub_cate_deails = mysqli_fetch_assoc($res_parent_sub_cate_deails)){
												$sub_parent_sub_cate_slug = strtolower(str_replace(' ','-',$row_parent_sub_cate_deails['slug']));
												$parent_sub_category_id = $row_parent_sub_cate_deails['id'];
											?>
											<li>
												<a href="https://couponclap.com/category-deals/<?php echo $slug;?>/<?php echo $sub_cate_slug;?>/<?php echo $sub_parent_sub_cate_slug;?>"
													data-id="<?php echo $parent_sub_category_id;?>">
													<?php echo $row_parent_sub_cate_deails['name'];?>
												</a>
											</li>
											<?php } ?>
											<!-- Child Subcategory UL inside Subcategory LI -->
											<ul>
												<?php 
											$sql_chld_sub_cate_deails = "SELECT * FROM child_subcategories WHERE parent_sub_cate_id = '$parent_sub_category_id' AND show_on_menu = '1'";
											$res_chld_sub_cate_deails = mysqli_query($con, $sql_chld_sub_cate_deails);
											while($row_chld_sub_cate_deails = mysqli_fetch_assoc($res_chld_sub_cate_deails)){
												$sub_chld_sub_cate_slug = strtolower(str_replace(' ','-',$row_chld_sub_cate_deails['slug']));
												$chld_sub_category_id = $row_chld_sub_cate_deails['id'];
											?>
												<li>
													<a href="https://couponclap.com/category-deals/<?php echo $slug;?>/<?php echo $sub_cate_slug;?>/<?php echo $sub_parent_sub_cate_slug;?>/<?php echo $sub_chld_sub_cate_slug;?>"
														data-id="<?php echo $sub_chld_sub_cate_slug;?>">
														<?php echo $row_chld_sub_cate_deails['name'];?>
													</a>
												</li>
												<?php } ?>
											</ul>
										</ul>

									</li>

									<?php } ?>
								</ul>

							</li>
							<?php } ?>
						</ul>
					</div>
				</div>
			</section>

			<section class="facet-filter col-xs-12 col-sm-12 col-md-12 col-lg-12">
				<a class="fl-r expand_ico" href="javaScript:void(0);"></a>
				<h3>BRAND</h3>
				<div class="side-facet-list pb">
					<div class="facet-scroll">
						<?php

							// Category Filter Condition
							$parent_sub_cat_condition = "";
							if(!empty($parentsubcate_filter)){
								$sub_cat_ids = $parentsubcate_filter;
								$parent_sub_cat_condition = " AND b.parent_sub_cate_id IN ($sub_cat_ids)";
							}

							// Main Query
							$cat_query = "
							SELECT 
								b.id, 
								b.name,
								b.slug,
								COUNT(p.id) AS total_posts
							FROM brands b
							LEFT JOIN posts p 
								ON p.category_brand_id = b.id 
								AND p.status = 'published' AND p.unpaused = '0'
							WHERE b.status = 1
							$parent_sub_cat_condition
							GROUP BY b.id
							ORDER BY b.name ASC
							";

							$result_brand = mysqli_query($con, $cat_query);
							while($row_brand = mysqli_fetch_assoc($result_brand)){

								$checked = (!empty($brand_filter) && 
											in_array($row_brand['slug'], $brand_filter)) 
											? 'checked' : '';
							?>
						<label class="clearfix txt fw filterByBrandParent">
							<input type="checkbox" class="brand-filter" value="<?php echo $row_brand['slug']; ?>" <?php
								echo $checked; ?>>
							<span class="fl filterByBrandChild">
								<?php echo $row_brand['name']; ?>
								(
								<?php echo $row_brand['total_posts']; ?>)
							</span>
						</label>
						<?php
						}
						?>
					</div>
				</div>
			</section>

			<section class="facet-filter col-xs-12 col-sm-12 col-md-12 col-lg-12">
				<a class="fl-r expand_ico" href="javaScript:void(0);"></a>
				<h3>STORE</h3>
				<div class="side-facet-list pb">
					<div class="facet-scroll">
						<?php
							$store_filter = $store_filter ?? []; // avoid undefined error
							$sto_query = "
							SELECT s.id, s.store_name,
							COUNT(p.id) AS total_posts
							FROM stores s
							LEFT JOIN posts p 
								ON p.stores_id = s.id 
								AND p.status='published' AND p.unpaused='0'
							GROUP BY s.id, s.store_name
							ORDER BY s.store_name ASC
							";

							$result_sto = mysqli_query($con, $sto_query);

							while($row = mysqli_fetch_assoc($result_sto)){

								$store_names   = $row['store_name'];
								
								$store_name = htmlspecialchars($row['store_name']);
								$total_posts = $row['total_posts'];

								$checked = (in_array($store_names, $store_filter)) ? 'checked' : '';
							?>
						<label class="clearfix txt fw filterByStoreParent">
							<input type="checkbox" value="<?php echo $store_names; ?>" class="store-filter" <?php echo
								$checked; ?>>
							<span class="fl filterByStoreChild">
								<?php echo $store_name; ?> (
								<?php echo $total_posts; ?>)
							</span>
						</label>
						<?php } ?>
					</div>
				</div>
			</section>
		</aside>
		<section class="deal-items deal-listing col-xs-12 col-sm-12 col-md-9 col-lg-9">
			<div class="product_category_header col-xs-12 col-sm-12 col-md-12 col-lg-12" id="sort-elms">
				<p class="sort_by">
					<a class="active" data-source="popularity" href="javaScript:void(0);">Popular</a>
				</p>
			</div>
			<div class="container deal-listing-wrap col-xs-12 col-sm-12 col-md-12 col-lg-12" id="scroll" data-npage="1">
				<ul class="col-xs-12 col-md-12 col-lg-12 col-sm-12 product-list-ul">
					<?php
						if(mysqli_num_rows($result) > 0){
						while($row = mysqli_fetch_assoc($result)){
						$stores_id = $row['stores_id'];
                    // store details
						$sql_stores_s = "SELECT * FROM stores WHERE id = '$stores_id'";
						$res_stores_s = mysqli_query($con, $sql_stores_s);
						$result_stores_d=mysqli_fetch_assoc($res_stores_s);
						$slug = strtolower(str_replace(' ','-',$row['slug']));
					?>
					<li data-deal-id="<?php echo $row['id'];?>" data-deal-text="<?php echo $row['title'];?>"
						class="deal-tile deal-wrap category-product-li col-xs-12 col-sm-12 col-md-4 col-lg-4">
						<div class="product-details-container col-xs-12 col-sm-12 col-md-12 col-lg-12">
							<a href="https://couponclap.com/deals/<?php echo $slug; ?>"
								title="<?php echo $row['title'];?>"
								class="product-buy-btn-link col-xs-12 col-md-12 col-lg-12 col-sm-12">
								<div class="store-min">
									<img src="https://couponclap.com/images/uploads/stores/<?php echo $result_stores_d['store_image']; ?>"
										alt=" <?php echo $result_stores_d['store_name']; ?>">
								</div>
								<div class="dolphin sticker" style="">
									<p>
										<?php echo $row['discount'];?>
									</p>
									<p class="last">OFF</p>
								</div>
								<div class="deal-img col-xs-6 col-sm-6 col-md-12 col-lg-12">
									<?php
										$image = !empty($row['image_big']) 
											? 'images/blogs/coupon/' . $row['image_big'] 
											: 'images/icon-image/logo3.jpg';
										?>

									<img alt="<?php echo htmlspecialchars($row['title']); ?>"
										src="https://couponclap.com/<?php echo $image; ?>"
										title="<?php echo htmlspecialchars($row['title']); ?>">
								</div>
								<div class="deal-info col-xs-6 col-sm-6 col-md-12 col-lg-12">
									<div class="deal deal-text col-xs-12 col-md-12 col-lg-12 col-sm-12"
										title="<?php echo $row['title'];?>">
										<?php echo $row['title'];?>
									</div>
									<div class="clearfix col-xs-12 col-md-12 col-lg-12 col-sm-12 product-price-details">
										<div data-dealid="<?php echo $row['id'];?>"
											data-href="<?php echo $row['slug'];?>" data-html="false"
											class="product-cashback col-xs-12 col-md-12 col-lg-12 col-sm-12">
											<?php echo $row['coupon_code'];?>
										</div>
									</div>
								</div>
							</a>
							<?php if(!empty($row['code'])){?>
                            <a href="https://couponclap.com/deals/<?php echo $slug; ?>"
                            data-slug="<?php echo $slug; ?>"
                            data-title="<?php echo $row['title']; ?>"
                            data-click-type="coupon"
    							class="product-buy-btn copy-btn-grap goToStoresFromOfferPage cashbackBtn col-xs-12 col-md-12 col-lg-12 col-sm-12">
    							    SHOW COUPON
							</a>
                            <?php }else{ ?>
                            <a class="product-buy-btn copy-btn-grap goToStoresFromOfferPageset cashbackBtn col-xs-12 col-md-12 col-lg-12 col-sm-12"
                                href="javascript:void(0);" data-slug="<?php echo $slug; ?>"
                                data-store-url="<?php echo $result_stores_d['store_url']; ?>"
                                data-logo="https://couponclap.com/images/uploads/stores/<?php echo $result_stores_d['store_image']; ?>"
                                data-store="<?php echo $result_stores_d['store_name']; ?>" data-title="<?php echo $row['title']; ?>"
                                data-type="<?php echo $row['type']; ?>"
                                data-click-type="grab"
                                data-image="https://couponclap.com/images/blogs/coupon/<?php echo $row['image_big']; ?>">
                                GET NOW 
                            </a>
                            <?php } ?>
						</div>
					</li>
					<?php
					}
					}else{ ?>
					<h4 class="text-center" style="padding: 21px;font-weight:bold;background: azure;">No Products Found</h4>
					<?php } ?>
				</ul>
			
			</div>
		</section>
		<section class="store-foot-section col-md-12 col-lg-12 col-sm-12 col-xs-12" style="background:white;margin-top:14px">
          <article class="store-foot pg-seo col-md-12 col-lg-12 col-sm-12 col-xs-12">
              <?php echo $category_details['thema_content'];?>
          </article>
        </section>
	</div>

	<!-- ================= JAVASCRIPT FILTER ================= -->
	<script>
		document.querySelectorAll("input[type=checkbox]").forEach(function (el) {
			el.addEventListener("change", function () {

				let brand = [];
				let store = [];

				document.querySelectorAll(".brand-filter:checked").forEach(e => brand.push(e.value));
				document.querySelectorAll(".store-filter:checked").forEach(e => store.push(e.value));

				let url = "https://couponclap.com/category-deals/<?php echo $category_details['slug'];?>/<?php echo $subcate_details['slug'];?>/<?php echo $parentsubcate_details['slug'];?>?";

				if (brand.length) url += "Brand=" + brand.join(",") + "&";
				if (store.length) url += "Store=" + store.join(",") + "&";

				window.location.href = url;
			});
		});
	</script>
	<!-- footer code start -->
	<?php include('footer.php');?>
	<!-- footer code end -->
	<script type="text/javascript" src="https://couponclap.com/static/javascripts/ion.rangeSlider.min.js"></script>
	<script type="text/javascript" src="https://couponclap.com/static/javascripts/auto.scroller.js"></script>
	<script src='https://couponclap.com/static/javascripts/ads.js' type="text/javascript" async defer></script>
	<!-- footer url link start code -->
	<?php include('footer_url.php');?>
	<!-- footer url link end code -->