<?php
class Productsdisplay extends CI_Model
{
    function __construct()
    {
        parent::__construct();
         $this->load->database();
        $this->table_name = 'product';
    }
   
    function fetch_details($id){
        if($id!=''){
           $this->db->select('*');
           $this->db->where('id',$id);
           $query = $this->db->get($this->table_name);
           return $query->row();
        }
    }
    
   function get_total_records(){
       return $query = $this->db->count_all_results($this->table_name);
    }
    
   function get_contents($start, $limit){
       $this->db->select('*');
       $this->db->order_by($this->table_name.".id");
       $this->db->limit( $start, $limit);  
       $query = $this->db->get($this->table_name);
       return $query->result();
  }
  
  function deletebrand($id){
       $this->db->where('id', $id);
       $this->db->delete($this->table_name);
  }
  
   
     function getAllCategories($item_id='')
    {
         
        if($item_id!=''){
      
       $query = $this->db->where('product_type',$item_id);
     }
      $query = $this->db->get('category');
       return $query->result(); 
    }
    
    function addEnquiry($data){
        if(!empty($data)){
          unset($data['sbt']);
          unset($data['g-recaptcha-response']);
          
           $this->table_name='enquiry'; 
           $this->db->insert($this->table_name,$data);
            $insert_id = $this->db->insert_id();
            return $insert_id;
           //echo $this->db->last_query(); die;
        }
    }

    
    
  
function get_category($item_id){
    if($item_id!=''){
       $this->db->select('*');
       $this->db->order_by("category_name", "ASC");
       $query = $this->db->where('product_type',$item_id);
       $query = $this->db->get('category');
       return $query->result(); 
     }
   }
   
  function get_products()
    {
        if(isset($_GET['sort'])!="") {
            $sort = $_GET['sort'];
            $this->db->select('*');
            $this->db->select('product.id');
            
            $this->db->from('product');
            $this->db->join('category',"category.id=product.product_category");
            $this->db->join('product_images',"product.id=product_images.product_id ");
            $this->db->where("product.status='active'");
            $this->db->order_by("product.product_name",$sort);  
            $query = $this->db->get(); 
            return $query->result(); 
        }
        if(isset($_GET['getCat'])!="") {
            $cat = $_GET['getCat'];
            // var_dump($_GET);exit;
            $this->db->select('*');
            $this->db->select('product.id');
            
            $this->db->from('product');
            $this->db->join('category',"category.id=product.product_category");
            $this->db->join('product_images',"product.id=product_images.product_id ");
            $this->db->where("product.status='active'");
            $this->db->where("product.product_category",$cat);  
            $query = $this->db->get(); 
            return $query->result(); 
        }
        if(isset($_GET['sort'])!="" && isset($_GET['getCat'])!="") {
            $sort = $_GET['sort'];
            $cat = $_GET['getCat'];
            $this->db->select('*');
            $this->db->select('product.id');
            
            $this->db->from('product');
            $this->db->join('category',"category.id=product.product_category");
            $this->db->join('product_images',"product.id=product_images.product_id ");
            $this->db->where("product.status='active'");
            $this->db->where("product.product_category",$cat); 
            $this->db->order_by("product.product_name",$sort);  
            
            $query = $this->db->get(); 
            return $query->result(); 
        }
      else{
        $this->db->select('*');
        $this->db->select('product.id as prodID');
        
        $this->db->from('product');
        $this->db->join('category',"category.id=product.product_category");
        $this->db->join('subcategory',"subcategory.id=product.product_subcategory");
        $this->db->join('product_images',"product.id=product_images.product_id ");
        $this->db->where("product.status='active'");
        // $this->db->order_by("product.product_name",$sort);
        $query = $this->db->get(); 
        return $query->result();
    }
}
 
    function get_launch_products()
    {
        if(isset($_GET['sort'])!="") {
            $sort = $_GET['sort'];
            $this->db->select('*');
            $this->db->select('product.id');
            
            $this->db->from('product');
            $this->db->join('category',"category.id=product.product_category");
            $this->db->join('product_images',"product.id=product_images.product_id ");
            $this->db->where("product.status='active'");
            $this->db->where("product.new_launch='1'");
            $this->db->order_by("product.product_name",$sort);  
            $query = $this->db->get(); 
            return $query->result(); 
        }
        if(isset($_GET['getCat'])!="") {
            $cat = $_GET['getCat'];
            // var_dump($_GET);exit;
            $this->db->select('*');
            $this->db->select('product.id');
            
            $this->db->from('product');
            $this->db->join('category',"category.id=product.product_category");
            $this->db->join('product_images',"product.id=product_images.product_id ");
            $this->db->where("product.status='active'");
            $this->db->where("product.new_launch='1'");
            $this->db->where("product.product_category",$cat);  
            $query = $this->db->get(); 
            return $query->result(); 
        }
        if(isset($_GET['sort'])!="" && isset($_GET['getCat'])!="") {
            $sort = $_GET['sort'];
            $cat = $_GET['getCat'];
            $this->db->select('*');
            $this->db->select('product.id');
            
            $this->db->from('product');
            $this->db->join('category',"category.id=product.product_category");
            $this->db->join('product_images',"product.id=product_images.product_id ");
            $this->db->where("product.status='active'");
            $this->db->where("product.product_category",$cat); 
            $this->db->where("product.new_launch='1'");
            $this->db->order_by("product.product_name",$sort);  
            
            $query = $this->db->get(); 
            return $query->result(); 
        }  else {
            $this->db->select('*');
            $this->db->select('product.id as prodID');
            
            $this->db->from('product');
            $this->db->join('category',"category.id=product.product_category");
            $this->db->join('subcategory',"subcategory.id=product.product_subcategory");
            $this->db->join('product_images',"product.id=product_images.product_id ");
            $this->db->where("product.new_launch='1'");
            $this->db->where("product.status='active'");
            // $this->db->order_by("product.product_name",$sort);
            $query = $this->db->get(); 
            return $query->result();
        }
    }  
   
     function getCategories()
    {
        $this->db->where("status='active'");
        $query = $this->db->get('category');
        return $query->result();
    }   
    
     function getSubCategories()
    {
        $this->db->where("status='active'");
        $query = $this->db->get('subcategory');
        return $query->result();
    }       

     function getAllType()
    {
        $query = $this->db->get('type');
        return $query->result();
    }

    function getAllApps()
    {
        $query = $this->db->get('application');
        return $query->result();
    }

    function getAllVariant()
    {
        $query = $this->db->get('variant');
        return $query->result();
        
    }

    function getAllFeatures()
    {
        $query = $this->db->get('feature');
        return $query->result();
    }

    function getAllRating()
    {
        $query = $this->db->get('rating');
        return $query->result();
    }
    
        
function get_compdetails($slug,$sub,$cat,$img){
    $this->db->select('*');
    $this->db->select('product.id as prodID');
    $this->db->select('product.featured_image');
    $this->db->select('category.slug as cat_slug');
    $this->db->select('subcategory.slug as subcat_slug');
    $this->db->select('product.features as prodfeatures');
    $this->db->from('product');
    $this->db->join('category',"category.id=product.product_category");
    $this->db->join('subcategory',"subcategory.id=product.product_subcategory");
    if($img!=""){
    $this->db->join('product_images',"product.id=product_images.product_id ");
    }
    $this->db->where('product.slug',$slug);
    $this->db->where('product.product_category',$cat);
    $this->db->where('product.product_subcategory',$sub);
   
    $query = $this->db->get(); 
    return $query->result();
}
function get_compRelated($slug,$sub,$cat,$img,$id)
{
    $this->db->select('*');
    $this->db->select('product.id as prodID');
    $this->db->select('product.slug as prodslug');
    $this->db->select('product.featured_image as image');
    $this->db->from('product');
    $this->db->join('category',"category.id=product.product_category");
    $this->db->join('subcategory',"subcategory.id=product.product_subcategory");
    if($img!=""){
    $this->db->join('product_images',"product.id=product_images.product_id ");
    }
    
    $this->db->where('product.slug !=',$slug);
    $this->db->where('product.product_category',$cat);
    $this->db->where('product.product_subcategory',$id);
    $this->db->order_by('rand()');
    $query = $this->db->get(); 
    return $query->result();
}


    function getAllCompanyProduct1($catid)
    {
            $this->db->select('*');
            $this->db->select('product.slug as productid');
            $this->db->select('product.featured_image as image');
            $this->db->from('product');
            $this->db->join('product_company',"product.id=product_company.product_id");
            $this->db->where('product_company.company_id',$catid);
            $this->db->where('product.product_category','1');
            $query = $this->db->get(); 
            return $query->result(); 
    }
    
      function getAllCompanyProduct2($catid)
    {
            $this->db->select('*');
            $this->db->select('product.slug as productid');
            $this->db->select('product.featured_image as image');
            $this->db->from('product');
            $this->db->join('product_company',"product.id=product_company.product_id");
            $this->db->where('product_company.company_id',$catid);
             $this->db->where('product.product_category','2');
            $query = $this->db->get(); 
            return $query->result(); 
    }
    
    
      function getAllCompanyProduct3($catid)
    {
            $this->db->select('*');
            $this->db->select('product.slug as productid');
            $this->db->select('product.featured_image as image');
            $this->db->from('product');
            $this->db->join('product_company',"product.id=product_company.product_id");
            $this->db->where('product_company.company_id',$catid);
             $this->db->where('product.product_category','4');
            $query = $this->db->get(); 
            return $query->result(); 
    }
    
    
      function getAllCompanyProduct4($catid)
    {
            $this->db->select('*');
            $this->db->select('product.slug as productid');
            $this->db->select('product.featured_image as image');
            $this->db->from('product');
            $this->db->join('product_company',"product.id=product_company.product_id");
            $this->db->where('product_company.company_id',$catid);
             $this->db->where('product.product_category','5');
            $query = $this->db->get(); 
            return $query->result(); 
    }

    function getAllCompanyProduct5($catid)
    {
            $this->db->select('*');
            $this->db->select('product.slug as productid');
            $this->db->select('product.featured_image as image');
            $this->db->from('product');
            $this->db->join('product_company',"product.id=product_company.product_id");
            $this->db->where('product_company.company_id',$catid);
            $this->db->where('product.product_category','8');
            $query = $this->db->get(); 
            return $query->result(); 
    }
    
    
    
    function get_Related($slug,$sub,$cat,$img)
    {
        $this->db->select('*');
        $this->db->select('product.id as prodID');
        $this->db->select('product.slug as prodslug');
        $this->db->select('product.featured_image as image');
        $this->db->from('product');
        $this->db->join('category',"category.id=product.product_category");
        $this->db->join('subcategory',"subcategory.id=product.product_subcategory");
        if($img!=""){
        $this->db->join('product_images',"product.id=product_images.product_id ");
        }
        $this->db->where('product.slug !=',$slug);
         $this->db->where('product.product_category',$cat);
        // $this->db->where('product.product_subcategory',$sub);
        $this->db->where("product.status='active'");
        $this->db->order_by('rand()');
        $query = $this->db->get(); 
        return $query->result();
    }
    
    function getAllCategoryProduct($catid)
    {
            $this->db->select('*');
            $this->db->select('product.slug as productid');
             $this->db->select('product.featured_image as image');
            $this->db->from('product');
            $this->db->join('category',"category.id=product.product_category");

            $this->db->where('product.product_category',$catid);
            $this->db->where("product.status='active'");
            // $this->db->group_by('product.product_name');
            $query = $this->db->get(); 
            return $query->result(); 
    }
    
    
    
    
    function getAllSubcategoryProduct($subcatid)
    {
            $this->db->select('*');
            $this->db->select('product.id as productid');
            $this->db->select('product.featured_image');
            $this->db->from('product');
            $this->db->join('category',"category.id=product.product_category");
            $this->db->join('subcategory',"subcategory.id = product.product_subcategory");
            $this->db->join('product_images',"product.id=product_images.product_id ");
            $this->db->where('product.product_subcategory',$subcatid);
            $this->db->where("product.status='active'");
            $query = $this->db->get(); 
            return $query->result(); 
    }
    
    
    
function make_query($sort_by)
 {
  $query = "
  SELECT DISTINCT product.*,product.slug as prodID,product.featured_image as img FROM product 
   WHERE product.status = 'active' 
 ";
  
  if(isset($sort_by))
  {
      $query .= "ORDER BY  ".$sort_by." 
      ";
  }
  
  return $query;
 }   
 
 function make_launch_query()
 {
  $query = "
  SELECT DISTINCT product.*,product.slug as prodID,product.featured_image as img FROM product 
   WHERE product.status = 'active' AND product.new_launch=1
 ";
  
  
  return $query;
 } 
 
 function make_query1($rating, $feature, $variant,$application,$type,$sort_by,$subcatid)
 {
  $query = "
  SELECT DISTINCT product.*,product.slug as prodID,category.category_name,subcategory.name,product.featured_image as image FROM product
  left JOIN product_application ON product_application.product_id=product.id
  left JOIN product_feature ON 	product_feature.product_id=product.id 
  left JOIN product_rating  ON 	product_rating.product_id=product.id
  left JOIN product_type    ON 	product_type.product_id=product.id
  left JOIN product_variant ON 	product_variant.product_id=product.id
  left JOIN product_images  ON 	product_images.product_id=product.id 
  left JOIN category        ON  category.id=product.product_category
  left JOIN subcategory     ON  subcategory.id=product.product_subcategory
  WHERE product.status = 'active'  AND product.product_subcategory='$subcatid'
 ";
  
  if(isset($application))
  {
   $application_filter = implode("','", $application);
   $query .= "
    AND product_application.product_application IN ('".$application_filter."')
   ";
  }
 
if(isset($type))
  {
   $type_filter = implode("','", $type);
   $query .= "
    AND product_type.product_type IN('".$type_filter."')
   ";
  }
  
  if(isset($variant))
  {
   $variant_filter = implode("','", $variant);
   $query .= "
    AND product_variant.product_variant IN ('".$variant_filter."')
   ";
  }
 
  if(isset($feature))
  {
   $feature_filter = implode("','", $feature);
   $query .= "
    AND product_feature.product_feature IN ('".$feature_filter."')
   ";
  }
  
if(isset($rating))
  {
   $rating_filter = implode("','", $rating);
   $query .= "
    AND product_rating.product_rating IN ('".$rating_filter."')
   ";
  }
  
  if(isset($subcategory))
  {
     $query .="
     AND product.product_subcategory ='".$subcategory."' 
     "; 
  }
  
  if(isset($sort_by))
  {
      $query .= "ORDER BY ".$sort_by." 
      ";
  }
  
  return $query;
 }   
 function count_all($sort_by)
 {
  $query = $this->make_query($sort_by);
  $data = $this->db->query($query);
  return $data->num_rows();
 }  
 function count_launch_all()
 {
  $query = $this->make_launch_query();
  $data = $this->db->query($query);
  return $data->num_rows();
 }  
 

function count_all1($rating,$feature,$variant,$application,$type,$sort_by,$subcatid)
 {
  $query = $this->make_query1($rating,$feature,$variant,$application,$type,$sort_by,$subcatid);
  $data = $this->db->query($query);
  return $data->num_rows();
 }  
function countWhere($where){
		$this -> db -> where($where);
        $query = $this -> db -> get($this->table_name);
        return $query->num_rows();
}

function launch_data($limit,$start)
 {
  $query = $this->make_launch_query();

  $query .= ' LIMIT '.$start.',' . $limit;

  $data = $this->db->query($query);

  $output = '';
  if($data->num_rows() > 0)
  {
   foreach($data->result_array() as $row)
   {
       
     $product_id = $row['prodID'];
     $product_name =$row['product_name'];
     $item_name = $row['product_tagline'];
    
     $output.='<div class="col-md-3">
                            <div class="ikio__main_product_boxes">
                               <a href='.base_url().'product/'.$product_id.'>
                                    <div class="ikio_main_productImage">
                                        <img src="'.base_url().'uploads/product/'.$row['featured_image'].'">
                                    </div>
                                    <div class="ikio_mian_productMeta_info">
                                        <h6>'.$product_name.'</h6>
                                        <span>'.$item_name.'</span>
                                    </div>
                                </a>
                            </div>
                </div>
    ';    
   }
  }
  else
  {
   $output = '<img src="'.base_url().'assets/img/404.jpg" class="no_data">';
  }
  return $output;
 } 
 
 function fetch_data($limit,$start,$sort_by)
 {
  $query = $this->make_query($sort_by);

  $query .= ' LIMIT '.$start.',' . $limit;

  $data = $this->db->query($query);

  $output = '';
  if($data->num_rows() > 0)
  {
   foreach($data->result_array() as $row)
   {
       
     $product_id = $row['prodID'];
     $product_name =$row['product_name'];
     $item_name = $row['product_tagline'];
    
     $output.='<div class="col-md-3">
                            <div class="ikio__main_product_boxes">
                               <a href='.base_url().'product/'.$product_id.'>
                                    <div class="ikio_main_productImage">
                                        <img src="'.base_url().'uploads/product/'.$row['featured_image'].'">
                                    </div>
                                    <div class="ikio_mian_productMeta_info">
                                        <h6>'.$product_name.'</h6>
                                        <span>'.$item_name.'</span>
                                    </div>
                                </a>
                            </div>
                </div>
    ';    
   }
  }
  else
  {
   $output = '<img src="'.base_url().'assets/img/404.jpg" class="no_data">';
  }
  return $output;
 }   
function fetch_data12($limit,$start,$rating,$feature,$variant,$application,$type,$sort_by,$subcatid){
      
    $query = "SELECT DISTINCT product.*,product.slug as prodID,product.featured_image as image FROM product  WHERE product.status = 'active' AND product.product_subcategory='$subcatid' ";
    if(isset($sort_by))
  {
      $query .= "ORDER BY ".$sort_by." 
      ";
  }
  //   $query .= ' LIMIT '.$start.', ' . $limit;
  
    $data = $this->db->query($query);
    $product_subcategory = array();
    $output = '';
    if($data->num_rows() > 0)
    {
     foreach($data->result_array() as $row)
     {
         
       $product_id = $row['prodID'];
       $product_name =$row['product_name'];
       $item_name = $row['product_tagline'];
         
       $output.='<div class="col-md-3">
                              <div class="ikio__main_product_boxes">
                                 <a href='.base_url().'product/'.$product_id.'>
                                      <div class="ikio_main_productImage">
                                          <img src="'.base_url().'uploads/product/'. $row['image'] .'">
                                      </div>
                                      <div class="ikio_mian_productMeta_info">
                                          <h6>'.$product_name.'</h6>
                                          <span>'.$item_name.'</span>
                                      </div>
                                  </a>
                              </div>
                  </div>
      ';    
     }
    }
    else
    {
     $output = '<img src="'.base_url().'assets/img/404.jpg" class="no_data">';
    }
  
    return $output;
   }  
   function fetch_data13($limit,$start,$rating,$feature,$variant,$application,$type,$sort_by,$subcatid){
      
    $query = "SELECT DISTINCT product.*,product.slug as prodID,product.featured_image as image FROM product left JOIN product_variant ON 	product_variant.product_id=product.id left JOIN product_type    ON 	product_type.product_id=product.id WHERE product.status = 'active' AND product.product_subcategory='$subcatid' ";
    if(isset($type))
  {
   $type_filter = implode("','", $type);
   $query .= "
    AND product_type.product_type IN('".$type_filter."')
   ";
  }
  
  if(isset($variant))
  {
   $variant_filter = implode("','", $variant);
   $query .= "
    AND product_variant.product_variant IN ('".$variant_filter."')
   ";
  }
    if(isset($sort_by))
  {
      $query .= "ORDER BY ".$sort_by." 
      ";
  }
  
    $data = $this->db->query($query);
    $product_subcategory = array();
    $output = '';
    if($data->num_rows() > 0)
    {
     foreach($data->result_array() as $row)
     {
         
       $product_id = $row['prodID'];
       $product_name =$row['product_name'];
       $item_name = $row['product_tagline'];
         
       $output.='<div class="col-md-3">
                              <div class="ikio__main_product_boxes">
                                 <a href='.base_url().'product/'.$product_id.'>
                                      <div class="ikio_main_productImage">
                                          <img src="'.base_url().'uploads/product/'. $row['image'] .'">
                                      </div>
                                      <div class="ikio_mian_productMeta_info">
                                          <h6>'.$product_name.'</h6>
                                          <span>'.$item_name.'</span>
                                      </div>
                                  </a>
                              </div>
                  </div>
      ';    
     }
    }
    else
    {
     $output = '<img src="'.base_url().'assets/img/404.jpg" class="no_data">';
    }
  
    return $output;
   }  
  
  function fetch_data1($limit,$start,$rating,$feature,$variant,$application,$type,$sort_by,$subcatid){
      
  $query = $this->make_query1($rating,$feature,$variant,$application,$type,$sort_by,$subcatid);
 
//   $query .= ' LIMIT '.$start.', ' . $limit;

  $data = $this->db->query($query);
  $product_subcategory = array();
  $output = '';
  if($data->num_rows() > 0)
  {
   foreach($data->result_array() as $row)
   {
       
     $product_id = $row['prodID'];
     $product_name =$row['product_name'];
     $item_name = $row['product_tagline'];
       
     $output.='<div class="col-md-3">
                            <div class="ikio__main_product_boxes">
                               <a href='.base_url().'product/'.$product_id.'>
                                    <div class="ikio_main_productImage">
                                        <img src="'.base_url().'uploads/product/'. $row['image'] .'">
                                    </div>
                                    <div class="ikio_mian_productMeta_info">
                                        <h6>'.$product_name.'</h6>
                                        <span>'.$item_name.'</span>
                                    </div>
                                </a>
                            </div>
                </div>
    ';    
   }
  }
  else
  {
   $output = '<img src="'.base_url().'assets/img/404.jpg" class="no_data">';
  }

  return $output;
 }   


  function fetch_data11($limit,$start,$rating,$feature,$variant,$application,$type,$sort_by,$subcatid){
      
  $query = $this->make_query1($rating,$feature,$variant,$application,$type,$sort_by,$subcatid);

//   $query .= ' LIMIT '.$start.', ' . $limit;

  $data = $this->db->query($query);
  $product_subcategory = array();
  $output = '';
  if($data->num_rows() > 0)
  {
   foreach($data->result_array() as $row)
   {
       
     $product_id = $row['prodID'];
     $product_name =$row['product_name'];
     $item_name = $row['product_tagline'];   
    $product_subcategory[] = $row['id'];
   }
  }
  else
  {
   $output = '<img src="'.base_url().'assets/img/404.jpg" class="no_data">';
  }
  $outputfilt =''; 
$product_subcategory =  array_unique($product_subcategory);
$pid = implode(",",$product_subcategory);
if(!empty($pid)){
$varid='';
      $query121 = "SELECT product_type,count(product_type) FROM product_type WHERE product_id IN($pid) GROUP BY product_type
      HAVING COUNT(product_type) > 0;";
      $data451 = $this->db->query($query121);



if($data451->num_rows() > 0)
{
 foreach($data451->result_array() as $row451)
 {
     if(empty($varid)){
      $varid=$row451['product_type'];
     }
     else{
      $varid=$varid.','.$row451['product_type'];
     }
  }


     
     
     $query = "SELECT  * FROM `type` WHERE id IN($varid)"; 
      $data = $this->db->query($query);
 if($data->num_rows() > 0)
  {
   foreach($data->result_array() as $type)
   {
       $type_id = $type['id'];
       $type_name =$type['type_name'];
       $outputfilt.=' <li>
                                            <div class="form-group ikio_filter_group ">
                                                <input type="checkbox" id="'.$type_name.'"  class="type_checkbox common_selector"  value="'.$type_id.'">
                                                <label for="'.$type_name.'">'.$type_name.'</label>
                                            </div>
                                        </li>'; 
       
   }
  }

 }
}
  return $outputfilt;
 }   

  function variant_data($subid,$subcatid)
 {
     
     $base= base_url();
  $query = "
  SELECT  product_filters.* FROM product_filters 
  left JOIN subcategory_filter ON subcategory_filter.name=product_filters.id
  left JOIN subcategory ON 	subcategory.id=subcategory_filter.subcategory_id 
  WHERE subcategory.slug = '$subid'";
  $data = $this->db->query($query);

  $output = '';
       $output.='    
                    <div class="ikio__product_filter_horizontal ">
                        <ul class="nav nav-tabs horizontal__filter_styl" id="myTab" role="tablist">';
  if($data->num_rows() > 0)
  {
   foreach($data->result_array() as $row)
   {
       
     $fitter_id = $row['id'];
     $fitter_name =$row['filter_name'];
     
 
                            $output.='  <li class="nav-item ">
                                <a class="nav-link tablinks" id="'.$fitter_name.'-tab" data-toggle="tab" href="#'.$fitter_name.'" role="tab"
                                    aria-controls="'.$fitter_name.'" aria-selected="true"  >'.$fitter_name.'</a>
                            </li>';
                             
                      
     
   }
   
  }
   $output.='  </ul>
                        <div class="tab-content sub_category_content " id="myTabContent">';
   $query = "SELECT  product_filters.* FROM product_filters 
  left JOIN subcategory_filter ON subcategory_filter.name=product_filters.id
  left JOIN subcategory ON 	subcategory.id=subcategory_filter.subcategory_id    
  WHERE subcategory.slug = '$subid'";
  $data = $this->db->query($query);

 
        
  if($data->num_rows() > 0)
  {
   foreach($data->result_array() as $row)
   {
       
     $fitter_id = $row['id'];
     $fitter_name =$row['filter_name'];
     if($fitter_name == "Type"){
        $verientid = "subcat";
     }else{
        $verientid = "";
     }
     $output .='<div class="tab-pane fade" id="'.$fitter_name.'" role="tabpanel" aria-labelledby="'.$fitter_name.'-tab">
                                <div class="horizontal__filters_values" >
                                    <ul id="'.$verientid.'">';
 if($fitter_name == "Variant"){
    $pid='';
      $query12 = "SELECT * FROM product WHERE product_subcategory = '$subcatid'";
  $data45 = $this->db->query($query12);

 
        
  if($data45->num_rows() > 0)
  {
   foreach($data45->result_array() as $row45)
   {
       if(empty($pid) ){
        $pid=$row45['id'];
       }
       else{
        $pid=$pid.','.$row45['id']; 
       }

    }
}
$varid='';
        $query121 = "SELECT product_variant,count(product_variant) FROM product_variant WHERE product_id IN($pid) GROUP BY product_variant
        HAVING COUNT(product_variant) > 0;";
        $data451 = $this->db->query($query121);

 
        
  if($data451->num_rows() > 0)
  {
   foreach($data451->result_array() as $row451)
   {
       if(empty( $varid)){
        $varid=$row451['product_variant'];
       }
       else{
        $varid=$varid.','.$row451['product_variant'];
       }
    }

}
      $query = "SELECT * FROM  variant WHERE id IN($varid)"; 
      $data = $this->db->query($query);
 if($data->num_rows() > 0)
  {
   foreach($data->result_array() as $variant)
   { 
       $variant_id = $variant['id'];
     $variant_name =$variant['variant_name'];
      $output.=' <li>
                                            <div class="form-group ikio_filter_group">
                                                <input type="checkbox" class="variant_checkbox common_selector" type="checkbox" id="'.$variant_name.'" value="'.$variant_id.'">
                                                <label for="'.$variant_name.'">'.$variant_name.'</label>
                                            </div>
                                        </li>'; 
       
  
   }
  }
   
   
 }
 else if($fitter_name == "Type"){
     
    $pid='';
    $query12 = "SELECT * FROM product WHERE product_subcategory = '$subcatid'";
$data45 = $this->db->query($query12);


      
if($data45->num_rows() > 0)
{
 foreach($data45->result_array() as $row45)
 {
     if(empty($pid) ){
      $pid=$row45['id'];
     }
     else{
      $pid=$pid.','.$row45['id']; 
     }

  }
}
$varid='';
      $query121 = "SELECT product_type,count(product_type) FROM product_type WHERE product_id IN($pid) GROUP BY product_type
      HAVING COUNT(product_type) > 0;";
      $data451 = $this->db->query($query121);


      
if($data451->num_rows() > 0)
{
 foreach($data451->result_array() as $row451)
 {
     if(empty($varid)){
      $varid=$row451['product_type'];
     }
     else{
      $varid=$varid.','.$row451['product_type'];
     }
  }

}
     
     
     $query = "SELECT  * FROM `type` WHERE id IN($varid)"; 
      $data = $this->db->query($query);
 if($data->num_rows() > 0)
  {
   foreach($data->result_array() as $type)
   {
       $type_id = $type['id'];
       $type_name =$type['type_name'];
       $output.=' <li>
                                            <div class="form-group ikio_filter_group ">
                                                <input type="checkbox" id="'.$type_name.'"  class="type_checkbox common_selector"  value="'.$type_id.'">
                                                <label for="'.$type_name.'">'.$type_name.'</label>
                                            </div>
                                        </li>'; 
       
   }
  }
   
 }
   if($fitter_name == "Rating"){
     
    $pid='';
    $query12 = "SELECT * FROM product WHERE product_subcategory = '$subcatid'";
$data45 = $this->db->query($query12);


      
if($data45->num_rows() > 0)
{
 foreach($data45->result_array() as $row45)
 {
     if(empty($pid) ){
      $pid=$row45['id'];
     }
     else{
      $pid=$pid.','.$row45['id']; 
     }

  }
}
$varid='';
      $query121 = "SELECT product_rating,count(product_rating) FROM product_rating WHERE product_id IN($pid) GROUP BY product_rating
      HAVING COUNT(product_rating) > 0;";
      $data451 = $this->db->query($query121);


      
if($data451->num_rows() > 0)
{
 foreach($data451->result_array() as $row451)
 {
     if(empty( $varid)){
      $varid=$row451['product_rating'];
     }
     else{
      $varid=$varid.','.$row451['product_rating'];
     }
  }

}
     
     $query = "SELECT  * FROM  rating WHERE id IN($varid)"; 
      $data = $this->db->query($query);
 if($data->num_rows() > 0)
  {
   foreach($data->result_array() as $rating)
   {
       $ratintg_id = $rating['id'];
     $ratintg_name =$rating['rating_name'];
      $output.=' <li>
                                            <div class="form-group ikio_filter_group tabcontent">
                                                <input type="checkbox" id="'.$ratintg_id.'"  class="rating_checkbox common_selector"  value="'.$ratintg_id.'">
                                                <label for="'.$ratintg_name.'">'.$ratintg_name.'</label>
                                            </div>
                                        </li>'; 
       
   }
  }
   
 } 
                             
     if($fitter_name == "Feature"){
   
        $pid='';
        $query12 = "SELECT * FROM product WHERE product_subcategory = '$subcatid'";
    $data45 = $this->db->query($query12);
    
    
          
    if($data45->num_rows() > 0)
    {
     foreach($data45->result_array() as $row45)
     {
         if(empty($pid) ){
          $pid=$row45['id'];
         }
         else{
          $pid=$pid.','.$row45['id']; 
         }
    
      }
    }
    $varid='';
          $query121 = "SELECT product_features,count(product_features) FROM product_feature WHERE product_id IN($pid) GROUP BY product_features
          HAVING COUNT(product_features) > 0;";
          $data451 = $this->db->query($query121);
    
    
          
    if($data451->num_rows() > 0)
    {
     foreach($data451->result_array() as $row451)
     {
         if(empty( $varid)){
          $varid=$row451['product_features'];
         }
         else{
          $varid=$varid.','.$row451['product_features'];
         }
      }
    
    }
     
       
     $query = "SELECT  * FROM  feature WHERE id IN($varid)"; 
      $data = $this->db->query($query);
 if($data->num_rows() > 0)
  {
   foreach($data->result_array() as $feature)
   {
       $feature_id = $feature['id'];
     $feature_name =$feature['feature_name'];
      $output.=' <li>
                                            <div class="form-group ikio_filter_group">
                                                <input type="checkbox"id="'.$feature_id.'"  class="feature_checkbox common_selector"  value="'.$feature_id.'">
                                                <label for="'.$feature_name.'">'.$feature_name.'</label>
                                            </div>
                                        </li>'; 
       
   }
  }
  
 }     
   if($fitter_name == "Application"){
   
    $pid='';
    $query12 = "SELECT * FROM product WHERE product_subcategory = '$subcatid'";
$data45 = $this->db->query($query12);


      
if($data45->num_rows() > 0)
{
 foreach($data45->result_array() as $row45)
 {
     if(empty($pid) ){
      $pid=$row45['id'];
     }
     else{
      $pid=$pid.','.$row45['id']; 
     }

  }
}
$varid='';
      $query121 = "SELECT product_application,count(product_application) FROM product_application WHERE product_id IN($pid) GROUP BY product_application
      HAVING COUNT(product_application) > 0;";
      $data451 = $this->db->query($query121);


      
if($data451->num_rows() > 0)
{
 foreach($data451->result_array() as $row451)
 {
     if(empty( $varid)){
      $varid=$row451['product_application'];
     }
     else{
      $varid=$varid.','.$row451['product_application'];
     }
  }

}
     
       
     $query = "SELECT * FROM application WHERE id IN($varid)"; 
      $data = $this->db->query($query);
 if($data->num_rows() > 0)
  {
   foreach($data->result_array() as $application)
   {
       $application_id = $application['id'];
     $application_name =$application['application_name'];
      $output.=' <li>
                                            <div class="form-group ikio_filter_group">
                                                <input type="checkbox" id="'.$application_id.'"  class="application_checkbox common_selector"  value="'.$application_id.'">
                                                <label for="'.$application_name.'">'.$application_name.'</label>
                                            </div>
                                        </li>'; 
       
   }
  }

   }
  
  $output.=' </ul>
                                </div>
                            </div>';
  }
 }
  else  {
  
  }
                     
                           
                         $output.=' </div>';
     
                    
            $output.='        <script>
                    $(document).ready(function(){
                          function filter_data12(page)
    {
           var action = "fetch_data";
        var sort_by = $("#select_id").val(); 
        var limit = $("#Sort__filters").val();
         var subid="'. $subid.'";
        var application_checkbox = get_filter("application_checkbox");
        var variant_checkbox = get_filter("variant_checkbox");
        var type_checkbox = get_filter("type_checkbox");
        var feature_checkbox = get_filter("feature_checkbox");
        var rating_checkbox = get_filter("rating_checkbox");
  
       
        $.ajax({
            url:"'.$base.'product/fetch_datasub1/"+page,
            method:"POST",
            dataType:"JSON",
            data:{action:action,subid:subid,variant_checkbox:variant_checkbox,type_checkbox:type_checkbox,feature_checkbox:feature_checkbox,application_checkbox:application_checkbox,rating_checkbox:rating_checkbox,sort_by:sort_by,limit:limit},
            success:function(data)
            {
             
                $(".filter_data").html(data.product_list);
                $("#subcat").html(data.subcat);
                $("#pagination_link").html(data.pagination_link);
            }
        })
    }

    function get_filter(class_name)
    {
        var filter = [];
        $("."+class_name+":checked").each(function(){
            filter.push($(this).val());
        });
        return filter;
    }
function getQueryStringValue(key) {  
  return decodeURIComponent(window.location.search.replace(new RegExp("^(?:.*[&\\?]" + encodeURIComponent(key).replace(/[\.\+\*]/g, "\\$&") + "(?:\\=([^&]*))?)?.*$", "i"), "$1"));  
} 
function getUrlVars() {
    var vars = {};
    var parts = window.location.href.replace(/[?&]+([^=&]+)=([^&]*)/gi, function(m,key,value) {
        vars[key] = value;
    });
    return vars;
}

    $(document).on("click", ".pagination li a", function(event){
        event.preventDefault();
        var page = $(this).data("ci-pagination-page");
        filter_data(page);
    }); 

    $(".common_selector").click(function(){
        filter_data12(1);
    });
});
                    </script>';
                     
                    
   
 
  return $output;
 }      

    
function get_details($slug,$sub,$cat,$img){
        $this->db->select('*');
        $this->db->select('product.id as prodID');
        $this->db->select('product.featured_image');
        $this->db->select('category.slug as cat_slug');
        $this->db->select('subcategory.slug as subcat_slug');
        $this->db->select('product.features as prodfeatures');
        $this->db->from('product');
        $this->db->join('category',"category.id=product.product_category");
        $this->db->join('subcategory',"subcategory.id=product.product_subcategory");
        if($img!=""){
        $this->db->join('product_images',"product.id=product_images.product_id ");
        }
        $this->db->where('product.slug',$slug);
        $this->db->where('product.product_category',$cat);
        $this->db->where('product.product_subcategory',$sub);
        $this->db->where("product.status='active'");
        $query = $this->db->get(); 
        return $query->result();
    } 
    
   function prod_Check($prod)
   {
    $this->db->select('product_name');
    $this->db->from('product');
    $this->db->where('product.product_name',$prod);
    $query = $this->db->get(); 
    return $query->result();

   }
  
    
}