<?php session_start();
include("db_config.php"); ?>
<!DOCTYPE html>
<html lang="en">
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
	<meta name="description" content=" ">
	<meta name="author" content="">
	<title>Orange Groceries</title>
	<?php include("css.php");?>
</head>

<body>
	<?php include("header.php");?>
<?php $page_name = str_replace(".php", "", basename($_SERVER['PHP_SELF']));
    $Current_URL = basename(dirname(__FILE__));
    $findid = (mysqli_query($conn, "SELECT * FROM sub_category"));
    while ($res2=mysqli_fetch_array($findid)) {
        if(strtolower(str_replace(" ", "-", $res2["sub_category_name"])) == $page_name){
            $id = $res2["id"];
        }
    }	
?>		
<?php  //$id=$_POST["id"];
$sql_sscats="select sub_sub_category.*,category.cat_name,sub_category.sub_category_name,sub_category.id as scat,sub_category.subcat_banner from sub_sub_category join category on sub_sub_category.category_id=category.id join sub_category on sub_sub_category.sub_category_id=sub_category.id  where sub_sub_category.sub_category_id='$id'";
$result_sscats = mysqli_query($conn, $sql_sscats);
$res_sscats = mysqli_fetch_array($result_sscats); ?>
	<section class="page-info section-padding border-bottom topthumb">
		<div class="container-fluid">
			<div class="row">
			<div class="col-md-12">
				<a href="https://orangegroceries.com/index.php"> <span class="mdi mdi-home"></span> &nbsp; Home</a> <span class="mdi mdi-chevron-right"></span> <a href="#"><?php echo $res_sscats['sub_category_name']; ?></a>
			</div>
			</div>
		</div>
	</section>

	<section class="shop-list section-padding">
		<div class="container-fluid">
			<div class="row dscats">
				<div class="col-md-3" style="padding-right:0;">
					<div class="shop-filters ">
						<div class="card">
							<div class="card-header">
								<h5 class="mb-0">
									<button class="btn btn-link collapsed">
										<?php echo $res_sscats['sub_category_name']; ?><span class="mdi mdi-chevron-down float-right"></span> </button>
								</h5>
							</div>
							<div class="card-body card-shop-filters">
								<ul id="f1" class="checkboxes_list">
                                      <?php $ssc_id=$res_sscats['scat'];
                                      $sscs_id=$res_sscats['category_id'];
                                    $sql_scat="select sub_category.*,category.cat_name,category.id as cid,category.cat_banner from sub_category join category on sub_category.category_id=category.id where sub_category.id !='$ssc_id' and sub_category.category_id ='$sscs_id' ";
                                    $result_scat = mysqli_query($conn, $sql_scat);
                                    while($res_scat = mysqli_fetch_array($result_scat)){ 
                                         $cat_name=$res_scat['cat_name']; 
                                         $category = strtolower(str_replace(" ", "-", $cat_name));
                                         $scat_name=$res_scat['sub_category_name']; 
                                         $sub_category = strtolower(str_replace(" ", "-", $scat_name));
                                        $cidd=$res_scat['id']; ?>
									<li class="custom-control">
										<label> <a href="https://orangegroceries.com/<?php echo "$category/$sub_category/$sub_category.php"; ?>" method="POST"><?php echo $res_scat['sub_category_name']; ?></a>
                                         </label>
									</li> <?php } ?>
								</ul>
							</div>
						</div>
					</div>
				</div>

				<div class="col-md-9">
					<div class="shop-head mb-1">
						<div class="mb-2">
						<img src="https://orangegroceries.com/admin/product/subcat/<?php echo $res_sscats['subcat_banner']; ?>" class="img-responsive">
						</div>
						<!-- <div class="btn-group float-right">
							<select name="speed" id="input-limit" class="option-drop" onchange="change_sort(this.value);">
								<option value="popularity">Popularity</option>
								<option value="price_l2h">Price Low To High</option>
								<option value="price_h2l">Price High To Low</option>
								<option value="latest">Fresh Arrivals</option>
							</select>
						</div> -->
						<h4 class="mb-1"><?php echo $res_sscats['sub_category_name']; ?> </h4>
					</div>
					<div class="row no-gutters">
						 <?php 
                        $id=$id;
                        $sql_sscat="select sub_sub_category.*,category.cat_name,sub_category.sub_category_name,sub_category.subcat_banner from sub_sub_category join category on sub_sub_category.category_id=category.id join sub_category on sub_sub_category.sub_category_id=sub_category.id  where sub_sub_category.sub_category_id='$id'";
                            $result_sscat = mysqli_query($conn, $sql_sscat);
                          while($res_scat= mysqli_fetch_array($result_sscat)){
                            $cat_name=$res_scat['cat_name']; 
                            $scat_name=$res_scat['sub_category_name']; 
                            $sub_sub_cat_name=$res_scat['sub_sub_cat_name']; 
                         $category = strtolower(str_replace(" ", "-", $cat_name));
                         $sub_category = strtolower(str_replace(" ", "-", $scat_name));
                         $ssub_category = strtolower(str_replace(" ", "-", $sub_sub_cat_name));
                        ?>
						<div class="col-md-3 col-6 product">
							<div class="category-item">
								<a href="https://orangegroceries.com/<?php echo "$category/$sub_category/$ssub_category/$ssub_category.php"; ?>" method="POST">
                                <img class="img-fluid" src="https://orangegroceries.com/admin/product/subsubcat/<?php echo $res_scat['subsub_cat_img']; ?>" style="height:200px;" alt="<?php echo $res_scat['sub_sub_cat_name']; ?>">   
									<h6><?php echo $res_scat['sub_sub_cat_name']; ?> </h6></a>
								</a>
							</div>
						</div>
                        <?php } ?>
						

					</div>
				</div>
			</div>
		</div>
	</section>
	<?php include("footer.php");?>
	<?php include("js.php");?>

	<script>
		jQuery(function() {
			jQuery('#in1').fastLiveFilter('#f1');
		});

	</script>
</body>

</html>
