<?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_sub_category"));
    while ($res2=mysqli_fetch_array($findid)) {
        if(strtolower(str_replace(" ", "-", $res2["sub_sub_cat_name"])) == $page_name){
            $id = $res2["id"];
        }
    } 
?>    
<?php //$id=$_POST["id"];
 $sql_prdd="select sub_category.sub_category_name,sub_category.id as scid,category.cat_name,sub_sub_category.sub_sub_cat_name,sub_sub_category.id as ss_id,product.* from product join category on product.category_id=category.id join sub_category on product.sub_category_id=sub_category.id join sub_sub_category on product.sub_sub_cat_id=sub_sub_category.id where product.sub_sub_cat_id='$id'";
 $result_prdd = mysqli_query($conn, $sql_prdd);
$res_prdd= mysqli_fetch_array($result_prdd); ?>
  <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_prdd['sub_sub_cat_name']; ?></a>
                </div> 
                </div> 
        </div>
    </section>
  <section class="shop-list section-padding">
    <div class="container-fluid">
      <div class="row">
        <div class="col-md-2" style="padding-right:0;">
          <div id="accordion" class="shop-filters ">
            <div class="card">
                <div class="card-header">
                                <h5 class="mb-0">
                                    <button class="btn btn-link collapsed">
                                    <?php echo $res_prdd['sub_sub_cat_name']; ?> <span class="mdi mdi-chevron-down float-right"></span> </button>
                                </h5>
                            </div> 
                <div class="card-body card-shop-filters">
                                    <ul  class="checkboxes_list">
                                    <?php $ssc_id=$res_prdd['sub_category_id'];
                                   $sql_scat="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_category_id='".$ssc_id."'";
                                    $result_scat = mysqli_query($conn, $sql_scat);
                                    while($res_scat = mysqli_fetch_array($result_scat)){
                                       $cat_name=$res_scat['cat_name']; 
                            $scat_name=$res_scat['sub_category_name']; 
                            $sub_sub_cat_name=$res_scat['sub_sub_cat_name']; 
                            $categorys = strtolower(str_replace(" ", "-", $cat_name));
                            $sub_categorys = strtolower(str_replace(" ", "-", $scat_name));
                            $ssub_categorys = strtolower(str_replace(" ", "-", $sub_sub_cat_name));
                                     ?>
                                          <li class="custom-control">
                                            <label> 
                                              <a href="https://orangegroceries.com/<?php echo "$categorys/$sub_categorys/$ssub_categorys/$ssub_categorys.php"; ?>"><?php echo $res_scat['sub_sub_cat_name']; ?></a>
                                            </label>
                                        </li>
                                    <?php } ?>                                       
                                    </ul>
                                </div>
            </div>
          </div>
        </div>

        <div class="col-md-10">
          <div class="shop-head mb-3">
            <!-- <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> -->
            <h5 class="mb-3"><?php echo $res_prdd['sub_sub_cat_name']; ?></h5>
          </div>
          <div class="row anajgharproducts no-gutters">
                    <?php $id=$id;
                        $sql_prd="select sub_category.sub_category_name,category.cat_name,sub_sub_category.sub_sub_cat_name,product.* from product join category on product.category_id=category.id join sub_category on product.sub_category_id=sub_category.id join sub_sub_category on product.sub_sub_cat_id=sub_sub_category.id where product.sub_sub_cat_id='$id'";
                            $result_prd = mysqli_query($conn, $sql_prd);
                           while($res_prd= mysqli_fetch_array($result_prd)){ ?>
                              <div class="col-md-3 col-6">
                               <?php $prd_id=$res_prd['id'];
                                $sql_pd="SELECT * from product_detail where prod_id='$prd_id'";
                                $exe_pd=mysqli_query($conn,$sql_pd);
                                $res_pd=mysqli_fetch_array($exe_pd); ?>
                                <?php $cat_name=$res_prd['cat_name']; 
                                  $scat_name=$res_prd['sub_category_name']; 
                                  $sub_sub_cat_name=$res_prd['sub_sub_cat_name']; 
                                  $prod_name=$res_prd['prod_name']; 
                                  $category = strtolower(str_replace(" ", "-", $cat_name));
                                  $sub_category = strtolower(str_replace(" ", "-", $scat_name));
                                  $ssub_category = strtolower(str_replace(" ", "-", $sub_sub_cat_name));
                                  $product_name = strtolower(str_replace(" ", "-", $prod_name));?>
                                   <input name="prd_id" id="prod_id" value="<?php echo $res_prd['id']; ?>" class="prd_id" type="hidden">
                                     <input name="prd_name" id="name" class="name" value="<?php echo $res_prd['prod_name']; ?>" type="hidden">
              <div class="products-wrapper" style="height: 430px; min-height: 430px; margin-bottom:20px;">
                <div class="product-image">
                  <a href="https://orangegroceries.com/<?php echo "$category/$sub_category/$ssub_category/$product_name.php"; ?>">
                                      <?php if($res_prd['prod_test_type']==="Veg"){ ?>
                                      <span class="veg text-success mdi mdi-circle"></span><?php }else if($res_prd['prod_test_type']==="Non-Veg"){ ?> <span class="non-veg text-danger mdi mdi-circle"></span><?php } ?> 
                                      <img class="img-fluid" src="https://orangegroceries.com/admin/product/<?php echo $res_prd['prod_img1'];?>" alt="<?php echo $res_prd['prod_name'];?>"></a>
                </div>
                <div class="product-other-info">
                  <div class="product-name">
                    <a href="https://orangegroceries.com/<?= "$category/$sub_category/$ssub_category/$product_name.php"; ?>">
                  <?php echo $res_prd['prod_name']; ?> , <?php echo $price =$res_pd['prod_quantity'].$res_pd['prod_quantity_type']; ?>
                </a>
                  </div>
                   
                  <div class="product-add-to-cart-btn">
                     <span class="mrp-txt">mrp</span>
                    <span class="main-prize"><strike><i class="fa fa-inr"></i>&nbsp;<span id="divShowHide"><?php echo $res_pd['prod_cross_price']; ?></span><span id="prod_cross_price"></span></strike></span>
                    <span class="discounted-prize">
                      <i class="fa fa-inr"></i>&nbsp;<span id="divShowHide1"><?php echo $res_pd['prod_price']; ?></span><span id="prod_price"></span></span>
                  <a href="https://orangegroceries.com/<?=  "$category/$sub_category/$ssub_category/$product_name.php"; ?>">
                   <button type="button" class="btn btn-sm" style="border:0px;background-color:#ec3237; color:#fff;color: #fff;padding: 2px 4px; border-radius: 6px;"><i class="mdi mdi-cart-outline"></i>Add To Cart </button></a>
                      <!-- <span class="cart-icon"> <i class="mdi mdi-cart-outline" aria-hidden="true"></i> </span> -->
                  </div>
                </div>
                <?php if(!empty($res_pd['prod_discount'])){ ?>
                <div class="discount-in-percent"><?php echo $res_pd['prod_discount']; ?>% off</div><?php } ?>
              </div>
            </div>
                         <?php } ?>
            </div>      <a href="">
              <div class="product-header">
              </div>
            </a>
           <!-- <div class="shop-head mt-3">
              <div class="pagination-wraper">
                <div class="pagination">
                </div>
              </div>
            </div>-->
          </div>
        </div>
      </div>
  </section>

<?php //include("orderwhatsapp.php");?>
<?php //include("brands.php");?>
  <?php include("footer.php");?>
  <?php include("js.php");?>

  
  <script type="text/javascript">
$(function() {
    $(document.body).on('change',"#prod_quanttity",function (e) {
        var qid = $(this).val();
        //alert(qid);
        $.ajax({
            method: "POST",
            url: "https://orangegroceries.com/ajax_prd_price.php",
            data:'qid='+qid,
            dataType:'JSON',
            success: function(data){
                $('#prod_price').text(data.prod_price);
                $('#prod_cross_price').text(data.prod_cross_price);
                $('#prod_discount').text(data.prod_discount);
                console.log(data);
            }
        });
    });
});
   $(function(){
$('body').on('change', '#prod_quanttity', function(){    
//$(document).ready(function(){
   // $('#prod_quanttity').on('change', function() {
      if ( this.value == '0')
      {
        $("#divShowHide").show();
        $("#divShowHide1").show();
      }
      else
      {
         $("#divShowHide").hide();
        $("#divShowHide1").hide();
      }
    });
});
    
</script>
<script>
    $(function(){
$('body').on('click', '#butsave', function(){
    var $container = $(this).closest(".container");
    //var prodcut_name = $('#name' + container).val();
    //var prod_id = $('#prd_id' + container).val();
     var prd_name = $container.find("#name").val();
     var prod_id = $container.find("#prod_id").val();
     var prod_quanttity = $container.find("#prod_quanttity").val();
       
        if(prd_name!="" && prod_id!="" && prod_quanttity!="" ){
            $.ajax({
                url: "https://orangegroceries.com/insert_tocart.php",
                type: "POST",
                data: {
                    prd_name: prd_name,
                    prod_id: prod_id,
                    prod_quanttity: prod_quanttity
                },
                cache: false,
                success: function(dataResult){
                    var dataResult = JSON.parse(dataResult);
                    if(dataResult.statusCode==200){
                    window.location.href = 'cart.php';
                    //alert("Data added successfully !");
                    }
                    else if(dataResult.statusCode==201){
                       alert("Error occured !");
                    }
                    
                }
            });
        }
        else{
            alert('Please fill all the field !');
        }
    });
});
</script>
</body>

</html>
