<?php 
session_start();
include("includes/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("includes/css.php");?>
</head>

<body>
    <?php include("includes/header.php");?>

    <section class="pt-3 pb-3 page-info section-padding border-bottom bg-white">
        <div class="container-fluid">
            <div class="row">
                <div class="col-md-12">
                    <a href="index.php"><strong><span class="mdi mdi-home"></span> Home</strong></a> <span class="mdi mdi-chevron-right"></span> <a href="#">Product</a>
                </div>
            </div>
        </div>
    </section>
 
    <section class="shop-list section-padding">
        <div class="container-fluid">
            <div class="row">
                <?php
if (isset($_GET['martsearch'])) {
 $martsearch =($_GET['martsearch']); 
$sql="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,sub_sub_category.sub_sub_cat_banner,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.prod_name like '%$martsearch%' or category.cat_name like '%$martsearch%' or sub_category.sub_category_name like '%$martsearch%' or sub_sub_category.sub_sub_cat_name like '%$martsearch%'";
$result = mysqli_query($conn, $sql);
$res_prdd= mysqli_fetch_array($result);
?> 
                <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 id="f1" class="checkboxes_list">
                                    <?php $ssc_id=$res_prdd['ss_id'];
                                           $sc_id=$res_prdd['scid'];
                                    $sql_scat="select sub_sub_category.* from sub_sub_category where sub_sub_category.id !='".$ssc_id."' and sub_category_id='".$sc_id."'";
                                    $result_scat = mysqli_query($conn, $sql_scat);
                                    while($res_scat = mysqli_fetch_array($result_scat)){ ?>
                                         <a href="product.php?id=<?php echo $res_scat['id']; ?>"> <li class="custom-control">
                                            <label><?php echo $res_scat['sub_sub_cat_name']; ?></label>
                                        </li></a>
                                    <?php } ?>
                                       
                                    </ul>
                                </div>
                            </div>
                    </div>
                </div>

                <div class="col-md-10"> 
                    <div class="shop-head mb-3">
                       
                        <h5 class="mb-3"><?php echo $res_prdd['sub_sub_cat_name']; ?></h5>
                    </div>
                    <div class="row no-gutters" >
                        <?php $martsearch =($_GET['martsearch']); 
                        $sql_prd="select sub_category.sub_category_name,category.cat_name,sub_sub_category.sub_sub_cat_name,sub_sub_category.sub_sub_cat_banner,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.prod_name like '%$martsearch%' or category.cat_name like '%$martsearch%' or sub_category.sub_category_name like '%$martsearch%' or sub_sub_category.sub_sub_cat_name like '%$martsearch%'";
                            $result_prd = mysqli_query($conn, $sql_prd);
                           while($res_prd= mysqli_fetch_array($result_prd)){ ?>
                            <?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));?>   
                        <div class="col-md-3 col-6 product">
                            <div class="container">
                                <div class="product-header">
                                <?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); ?>
                                    <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">
                                     <a href="https://orangegroceries.com/<?php echo "$category/$sub_category/$ssub_category/$product_name.php"; ?>">
                                    <?php if(!empty($res_pd['prod_discount'])){ ?>
                                    <span class="badge badge-success"><?php echo $res_pd['prod_discount']; ?>% OFF</span>
                                <?php } ?>
                                    <img class="img-fluid" src="admin/product/<?php echo $res_prd['prod_img1'];?>" alt="<?php echo $res_prd['prod_name']; ?>"></a>
                                    <?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 } ?>
                                </div>
                                <a href="https://orangegroceries.com/<?php echo "$category/$sub_category/$ssub_category/$product_name.php"; ?>">
                                    <div class="product-body">
                                        <h5><?php echo $res_prd['prod_name']; ?> - <?php echo $pricesss =$res_pd['prod_quantity'].$res_pd['prod_quantity_type']; ?></h5>
                                    </div>
                                </a>
                               <!--  <div class="row">
                                    <div class="col-lg-3 col-md-3 col-xl-3 col-sm-3 col-3"> <span class="mdi mdi-approval"></span> Qty-</div>
                                    <div class="col-lg-9 col-md-9 col-xl-9 col-sm-9 col-9">
                                       <select name="prod_quanttity" id="prod_quanttity" class="form-control mt-10" >
                                    
                                    <?php $prd_id=$res_prd['id'];
                                    $sql2="SELECT * from product_detail where prod_id='$prd_id'";
                                    $exe2=mysqli_query($conn,$sql2);
                                    while ($res2=mysqli_fetch_array($exe2))
                                    {
                                        $id = $res2['id'];
                                      $price =$res2['prod_quantity'].$res2['prod_quantity_type'];
                                       echo "<option value='".$id."'>".$price."</option>";
                                        } ?>
                                        </select> 
                                    </div>
                                </div> -->
                                <div class="product-footer">
                                    <a href="https://orangegroceries.com/<?php echo "$category/$sub_category/$ssub_category/$product_name.php"; ?>" > 
                                    <button type="submit" class="btn btn-sm" style="border:0px;background-color:#ec3237; color:#fff;float: right;color: #fff;padding: 2px 4px; border-radius: 6px;"><i class="mdi mdi-cart-outline"></i>Add to cart </button>
                                 </a>
                                    <p class="offer-price mb-0 mt-1"><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></p>
                                </div>
                            </div>
                        </div>
                    <?php } ?>
                    </div> 
                </div>
            <?php } 
if (isset($_POST['martsearch'])) {
 $martsearch =($_POST['martsearch']); 
$sql="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,sub_sub_category.sub_sub_cat_banner,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.prod_name like '$martsearch' or category.cat_name like '$martsearch' or sub_category.sub_category_name like '$martsearch' or sub_sub_category.sub_sub_cat_name like '$martsearch'";
$result = mysqli_query($conn, $sql);
$res_prdd= mysqli_fetch_array($result);
?> 
                <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 id="f1" class="checkboxes_list">
                                    <?php $ssc_id=$res_prdd['ss_id'];
                                           $sc_id=$res_prdd['scid'];
                                    $sql_scat="select sub_sub_category.* from sub_sub_category where sub_sub_category.id !='".$ssc_id."' and sub_category_id='".$sc_id."'";
                                    $result_scat = mysqli_query($conn, $sql_scat);
                                    while($res_scat = mysqli_fetch_array($result_scat)){ ?>
                                         <a href="product.php?id=<?php echo $res_scat['id']; ?>"> <li class="custom-control">
                                            <label><?php echo $res_scat['sub_sub_cat_name']; ?></label>
                                        </li></a>
                                    <?php } ?>
                                       
                                    </ul>
                                </div>
                            </div>
                    </div>
                </div>

                <div class="col-md-10"> 
                    <div class="shop-head mb-3">
                       
                        <h5 class="mb-3"><?php echo $res_prdd['sub_sub_cat_name']; ?></h5>
                    </div>
                    <div class="row no-gutters" >
                        <?php $martsearch =($_POST['martsearch']); 
                        $sql_prd="select sub_category.sub_category_name,category.cat_name,sub_sub_category.sub_sub_cat_name,sub_sub_category.sub_sub_cat_banner,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.prod_name like '%$martsearch%' or category.cat_name like '%$martsearch%' or sub_category.sub_category_name like '%$martsearch%' or sub_sub_category.sub_sub_cat_name like '%$martsearch%'";
                            $result_prd = mysqli_query($conn, $sql_prd);
                           while($res_prd= mysqli_fetch_array($result_prd)){ ?>
                             <?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));?> 
                        <div class="col-md-3 col-6 product">
                            <div class="container">
                                <div class="product-header">
                                <?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); ?>
                                    <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">
                                     <a href="https://orangegroceries.com/<?php echo "$category/$sub_category/$ssub_category/$product_name.php"; ?>">
                                    <span class="badge badge-success"><?php echo $res_pd['prod_discount']; ?>% OFF</span>
                                    <img class="img-fluid" src="admin/product/<?php echo $res_prd['prod_img1'];?>" alt="<?php echo $res_prd['prod_name']; ?>"></a>
                                    <?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 } ?>
                                </div> 
                                <a href="https://orangegroceries.com/<?php echo "$category/$sub_category/$ssub_category/$product_name.php"; ?>">
                                    <div class="product-body">
                                        <h5><?php echo $res_prd['prod_name']; ?> - <?php echo $pricess =$res_pd['prod_quantity'].$res_pd['prod_quantity_type']; ?></h5>
                                    </div>
                                </a>
                                <!-- <div class="row">
                                    <div class="col-lg-3 col-md-3 col-xl-3 col-sm-3 col-3"> <span class="mdi mdi-approval"></span> Qty-</div>
                                    <div class="col-lg-9 col-md-9 col-xl-9 col-sm-9 col-9">
                                       <select name="prod_quanttity" id="prod_quanttity" class="form-control mt-10" >
                                    
                                    <?php $prd_id=$res_prd['id'];
                                    $sql2="SELECT * from product_detail where prod_id='$prd_id'";
                                    $exe2=mysqli_query($conn,$sql2);
                                    while ($res2=mysqli_fetch_array($exe2))
                                    {
                                        $id = $res2['id'];
                                      $price =$res2['prod_quantity'].$res2['prod_quantity_type'];
                                       echo "<option value='".$id."'>".$price."</option>";
                                        } ?>
                                        </select> 
                                    </div>
                                </div> -->
                                <div class="product-footer">
                                <a href="https://orangegroceries.com/<?php echo "$category/$sub_category/$ssub_category/$product_name.php"; ?>"> 
                                   <button type="submit" class="btn btn-sm" style="border:0px;background-color:#ec3237; color:#fff;float: right;color: #fff;padding: 2px 4px; border-radius: 6px;"><i class="mdi mdi-cart-outline"></i>Add to cart </button>
                                 </a>
                                    <p class="offer-price mb-0 mt-1">&#x20B9;<span id="divShowHide"><?php echo $res_pd['prod_price']; ?></span><span id ="prod_price"> </span><i class="mdi mdi-tag-outline"></i>
                                        <br><span class="regular-price"> &#x20B9;<span id="divShowHide1"><?php echo $res_pd['prod_cross_price']; ?></span> <span id ="prod_cross_price"> </span></span></p>
                                </div>
                            </div>
                        </div>
                    <?php } ?>
                    </div>
                </div>
            <?php } ?>
            </div>
        </div>
    </section>
    <?php include("includes/footer.php");?>
    <?php include("includes/js.php");?>
    <script type="text/javascript">
       

$(function() {
    $(document.body).on('change',"#prod_quanttity",function (e) {
        var qid = $(this).val();
        //var qid = $('#prod_quanttity').val();
        //alert(qid);
        $.ajax({
            method: "POST",
            url: "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();
        //$("#butsave").attr("disabled", "disabled");
        //var prd_name = $('#name').val();
        //var prod_id = $('#prod_id').val();
       // var prod_quanttity = $('#prod_quanttity').val();
       
        if(prd_name!="" && prod_id!="" && prod_quanttity!="" ){
            $.ajax({
                url: "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>