<?php include("site-header.php"); ?>
    
    
    
<?php include("inner-banner.php"); ?>

 
       <?php

$brand_name=$_REQUEST['brand_name']; 
$start = intval($start);
//$pagesize = intval($pagesize)==0?$pagesize=DEF_PAGE_SIZE:$pagesize;
$pagesize=12;
$sql = "select * from  tbl_category where 1 and category_status='Active' and category_is_product='Yes' and category_brand='$brand_name' ";
$sql .= " limit $start, $pagesize ";
//echo $sql;
$pager = new midas_pager_sql($sql, $pagesize, $start);
if($pager->total_records) {
  $result = db_query($sql);
}
?> 

      
    <main class="main-content ">  
      
      <div class="wrapper">
        
        <div class="grid__item">           
          



<div class="grid__item">
  <div class="collection-products position-change">

      <? if($pager->total_records!=0) {?>
<? $pager->show_displaying()?>
<?//=pagesize_dropdown('pagesize', $pagesize);?>
<?php
}
?>

   
    <div class="grid__item wide--one-fifth post-large--one-fifth large--three-tenths left-sidebar">
      <!-- /snippets/collection-sidebar.liquid -->



<div class="collection_sidebar">

   <div id="shopify-section-sidebar-category" class="shopify-section">
    <div data-section-id="sidebar-category"  data-section-type="Sidebar-category" class="shopify-section"> 
    <div class="widget widget_product_categories">
      
      <h4>
        Brands
      </h4>  
      
      
      <ul class="product-categories dt-sc-toggle-frame-set">
<?php
$left_brand_query=db_query("select * from tbl_partners where partner_status='Active' ");
while($left_brand_res=mysqli_fetch_array($left_brand_query))
{?>
                     
    <li class="cat-item cat-item-39 cat-parent">
          <i></i><a class=" " href="<?=$site_url?>/product-by-brand.html?brand_name=<?=$left_brand_res['partner_name']?>"><?=$left_brand_res['partner_name']?></a> 
        </li>
        <?}?>


<!--         <li class="cat-item cat-item-39 cat-parent first">
          <i></i>
          <a class="" href="../products/wall-mounted-sinks.html">Shower Faucet</a> <span class="dt-sc-toggle"></span>

                  
          <ul class="children dt-sc-toggle-content ">
            
               
            <li class="second">
              <i></i>             
              <a class="" href="../products/wall-mounted-sinks.html">Remer</a>
               
              
              
            
            </li>
            
               
            <li class="second">
              <i></i>             
              <a class="" href="../products/white-drop-in-sink.html">Ramon Soler</a>
               
              
              
            
            </li>
            
          </ul>
          
        </li> -->
        
        
                     
        
    
        
        
                     
        
   
        
        
      </ul>
      
    </div>
    
  </div>
</div> 
   
 
  
 <!--    <div class="refined-widgets">
      <a href="javascript:void(0)" class="clear-all" style="display:none">
        Clear All
      </a>
    </div> -->
    <div class="sidebar-block">
     <div id="shopify-section-sidebar-colors" class="shopify-section"><div data-section-id="sidebar-colors"  data-section-type="Sidebar-color" class="shopify-section">  

      
</div>

   
 



</div>
     <div id="shopify-section-sidebar-tag-filters" class="shopify-section">
<div data-section-id="sidebar-tag-filters"  data-section-type="Sidebar-tag" class="shopify-section">  


   
      

  
</div>
  
</div>
  </div>
 


  <div id="shopify-section-sidebar-banner" class="shopify-section">  
    <div class="widget widget_promo_img">
      <ul id="promo-carousel" class="owl-carousel owl-theme">
        
        
        
        
        
      </ul>
    </div>
 
 




<script type="text/javascript">
$(document).ready(function(){
     $("#promo-carousel").owlCarousel({ 
        loop:false,
       // margin:10,
        nav:false,       
        dots: true,
        responsive:{
            0:{
                items:1
            },
            600:{
                items:1
            },
            1000:{
                items:1
            }
        }
 
  });
});
      
</script>
</div>
  
</div>
  

 
    </div>
      <!--   four-fifths -->

    <div class="grid__item wide--four-fifths post-large--four-fifths large--seven-tenths sidebar-hidden second">       
      <div class="collection-list">
        <div class="grid-uniform grid-link__container col-main">            
             
          
<br>





 <?php if($pager->total_records>0) {?> 
          
          <div class="products-grid-view">
                
          <ul>
<?php
//$pro_sql=db_query("select * from tbl_category where 1 and category_status='Active' and category_is_product='Yes' ");
while($pro_res=mysqli_fetch_array($result))
{
?>
<li class="grid__item item-row  wide--one-quarter post-large--one-third large--one-half medium--one-half small-grid__item on-sale" id="product-1892471406710" >
  <div class="products product-hover-16">
    <div class="product-container">  

  <a href="<?=$site_url?>/product-details.html?id=<?=$pro_res['category_id']?>" class="grid-link">    

        <div class="ImageOverlayCa"></div>
        
        <div class="reveal"> 
          <span class="product-additional">      
            <img src="<?=$site_url?>/uploaded_files/<?=$pro_res['category_image_name']?>" class="featured-image" alt="<?=$pro_res['category_name']?>" title="<?=$pro_res['category_name']?>" style="height: 200px; width:230px;">
          </span>
          <img  src="<?=$site_url?>/uploaded_files/<?=$pro_res['category_image_name']?>" class="hidden-feature_img" alt="<?=$pro_res['category_name']?>" title="<?=$pro_res['category_name']?>" style="height: 200px; width:230px;" />
        </div>      
        
      </a>
 <div class="product_right_tag   offer_exist ">
 </div>

      <div class="product-detail">

        <div class="prt-detail-inner">

   <a href="<?=$site_url?>/product-details.html?id=<?=$pro_res['category_id']?>" class="grid-link__title"><?=$pro_res['category_name']?></a> 


        <div class="grid-link__meta">
            <div class="product_price">

              
              <div class="grid-link__org_price">
                <span class=money><i class="fa fa-inr"></i><?=$pro_res['category_discount_price']?></span>
              </div>

              
              <del class="grid-link__sale_price"><span class=money><i class="fa fa-inr"></i><?=$pro_res['category_real_price']?></span></del>
              
            </div>        

          </div> 
        
        </div>


       <div class="functional-buttons">
                                         
          <input type="hidden" name="id" value="18033246109814" />  
          <a class="add-cart-btn btn" href="javascript:void(0);" onclick="add_to_cart_pro_ajax(<?=$pro_res['category_id']?>);">
           Add to Cart
          </a>
       

 </div> 
 
      </div>
    </div>

  </div>
</li>
<?}?>





            
             


            
          </ul>
          
          </div>


              <? $pager->show_pager();?>
<?php }else{?>
  <div class="col-md-12">
   <h2  style="color:red; text-align: center; padding-bottom:50px;">
    Product Not Available!

  </h2>
  </div>
<?php }?>
          
        
          
            
        </div>

           <?php if($pager->total_records>0) { 
           $pager->show_pager();
              }
          ?>

          
      </div>
    </div>


    
</div>
</div>   
    <div class="dt-sc-hr-invisible-large"></div>
              
        </div>          
        
      </div>
      
      
       <div class="dt-sc-hr-invisible-large"></div>
    </main>  
    
    
    <script>
           function add_to_cart_pro_ajax(pro_cart_id)
    {

/*swal(""+pro_cart_id+"");*/
        
           $.ajax({
            url:"<?=$site_url?>/add_to_cart.php",
            type:"POST",
            data:{pro_cart_id:pro_cart_id},
            success:function(data){
                 if(data=="quantity error")
                {
                    swal("Quantity not available !", "", "error");
                    
                }else if(data=="Item added in your cart.")
                {
 //         swal("Added !", "Item added in your cart", "success");
swal({title: "Added", text: "Item added in your cart", showConfirmButton: true, allowEscapeKey : false, allowOutsideClick: false, type: "success"},
   function(){ 
       location.reload();
   }
);
                }else{
                     swal("Item already added in your cart!", "", "error");
                     
                }

            }
        });
        

    }
    </script>
   <?php include("site-footer.php"); ?>