<?php
class Applicationmodel extends CI_Model
{
    function __construct()
    {
        parent::__construct();
         $this->load->database();
        $this->table_name = 'application';

    }
    function add($data){
        if(!empty($data)){
            // print_r($data);exit;
             unset($data['sbt']);
            $data['created_at']=date('Y-m-d H:i:s'); 
            $data['updated_at']=date('Y-m-d H:i:s');
            $data['status']="Active";
           $this->db->insert($this->table_name,$data);
            $insert_id = $this->db->insert_id();
            return $insert_id;
        //    echo $this->db->last_query(); die;
        }
    }
   function edit($id,$data){
        if(!empty($data) && $id!=''){
                unset($data['sbt']);
          $this->db->where('id',$id);
          return $this->db->update($this->table_name,$data);
           //echo $this->db->last_query(); die;
        }
    }
    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", "desc");
       $query = $this->db->get($this->table_name);
       return $query->result();
    }
  function deleteapplication($id){
       $this->db->where('id', $id);
       $this->db->delete($this->table_name);
    }
    
    function getApp()
    {
       $this->db->select('*');
       $this->db->where("status='active'");
       $this->db->order_by("id", "desc");
       $query = $this->db->get($this->table_name);
       return $query->result();
    }
   
  function update_status($id,$svalue){
      $svalue=$_REQUEST['svalue'];
      
    
      if($svalue=='active'){
          $status='inactive';
      }else{
          $status='active';
      }
      $data= array(
                        'status' => $status
                  );
     $this->db->where('id',$id);
     return $this->db->update('application',$data);                
     }
    
    



function make_query($sort_by)
 {
  $query = "
  SELECT DISTINCT product.*, product.slug as prodID, product_application.product_id,product.featured_image as image from product
  left JOIN product_application ON product.id=product_application.product_id 
  left JOIN product_images  ON product_images.product_id=product.id 
  WHERE product.status='active' 
  ";
  
   if(isset($sort_by))
  {
      $query .= "ORDER BY product_application.product_id ".$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 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)
   {
       
     $application_id = $row['prodID'];
     $application_name =$row['product_name'];
     $item_name = $row['product_tagline'];
     
    $date = $row['updated_at'];
    $dateToPrint = date('j F, Y', strtotime($date) ) ;
                                             
     
       
     $output.='  
     <div class="col-md-3">
                            <div class="ikio__main_application_boxes">
                                <a href='.base_url().'product/'.$application_id.'>
                                    <div class="ikio_main_applicationImage">
                                        <img src="'.base_url().'uploads/product/'. $row['image'] .'">
                                    </div>
                                    <div class="ikio_mian_applicationMeta_info">
                                        <h6>'.$application_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 make_query1($sort_by,$appid)
 {
  $query = "
  SELECT DISTINCT product.*, product.slug as prodID, product_application.product_id,product.featured_image as image from product
  left JOIN product_application ON product.id=product_application.product_id 
  left JOIN product_images  ON product_images.product_id=product.id
  WHERE product.status='active' and product_application.product_application ='$appid'
  ";
  
   if(isset($sort_by))
  {
      $query .= "ORDER BY product_application.product_id ".$sort_by." 
      ";
  }
  
 
  return $query;
 }   
 function count_all1($sort_by,$appid)
 {
  $query = $this->make_query($sort_by,$appid);
  $data = $this->db->query($query);
  return $data->num_rows();
 }  

 function fetch_application_data($limit,$start,$sort_by,$appid)
 {
  $query = $this->make_query1($sort_by,$appid);

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

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

  $output = '';
  if($data->num_rows() > 0)
  {
   foreach($data->result_array() as $row)
   {
       
     $application_id = $row['prodID'];
     $application_name =$row['product_name'];
     $item_name = $row['product_tagline'];
     
    $date = $row['updated_at'];
    $dateToPrint = date('j F, Y', strtotime($date) ) ;
                                             
     
       
     $output.='  
     <div class="col-md-3">
                            <div class="ikio__main_application_boxes">
                                <a href='.base_url().'product/'.$application_id.'>
                                    <div class="ikio_main_applicationImage">
                                        <img src="'.base_url().'uploads/product/'. $row['image'] .'">
                                    </div>
                                    <div class="ikio_mian_applicationMeta_info">
                                        <h6>'.$application_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 delete_application($id)
 {
  
  $this->db->where('id', $id);
  $this->db->delete('application');

 }


function make_featured($id)
 {
 
  $this->db->set('is_featured','yes');
  $this->db->where('id', $id);
  $this->db->update('application');
 }

function remove_featured($id)
 {
 
  $this->db->set('is_featured','no');
  $this->db->where('id', $id);
  $this->db->update('application');
 }

function make_activated($id)
 {
 
  $this->db->set('status','active');
  $this->db->where('id', $id);
  $this->db->update('application');
 }

 
function remove_activated($id)
 {
 
  $this->db->set('status','inactive');
  $this->db->where('id', $id);
  $this->db->update('application');
 }
    
    
 
}