<?php
defined('BASEPATH') or exit('No direct script access allowed');

class Application extends CI_Controller
{


public function index()
    {
        $this->load->helper(array('form', 'url', 'common'));
        $this->load->library(array('session','pagination')); 

        $this->load->model('applicationmodel', '', true);
        $this->load->model('homemodel', '', true);

        $sql=$this->db->query("SELECT * from page where page_name='Browse By Application'");
        $result = $sql->result();
        
        $title = $result[0]->page_title;
        $meta_title = $result[0]->meta_title;
        $meta_d =$result[0]->meta_description;
        $image = $result[0]->page_image;
        $data['prod'] = $this->uri->segment(1);
        
        $data['title'] = $title ." || IKIO LED LIGHTING";
        $data['meta_title'] = $meta_title ."  || IKIO LED LIGHTING";
        $data['meta_description'] = $meta_d ."  || IKIO LED LIGHTING";
        $data['image'] = $image;

        $data['category'] = $this->homemodel->getCategory();
        $data['subcategorys'] =$this->homemodel->getSubCategory();
        $data['application'] =$this->homemodel->getApplication();
       
        $this->load->view('inc/header',$data);   
        $this->load->view('application/index', $data);
        $this->load->view('inc/footer',$data);
    }
    
    
    public function getapplication()
    {
        
        $this->load->helper(array('form', 'url', 'common'));
        $this->load->library(array('session','pagination')); 

        $this->load->model('applicationmodel', '', true);
        $this->load->model('homemodel', '', true);

        $sql=$this->db->query("SELECT * from page where page_name='Browse By Application'");
        $result = $sql->result();
        
        $title = $result[0]->page_title;
        $meta_title = $result[0]->meta_title;
        $meta_d =$result[0]->meta_description;
        $image = $result[0]->page_image;
        
        $data['prod'] = $this->uri->segment(1); 
        
        $data['val'] = $this->uri->segment(2);

        
        $data['title'] = $title ." || IKIO LED LIGHTING";
        $data['meta_title'] = $meta_title ."  || IKIO LED LIGHTING";
        $data['meta_description'] = $meta_d ."  || IKIO LED LIGHTING";
        $data['image'] = $image;

        $data['category'] = $this->homemodel->getCategory();
        $data['subcategorys'] =$this->homemodel->getSubCategory();
        $data['application'] =$this->homemodel->getApplication();
       
        $this->load->view('inc/header',$data);   
        $this->load->view('application/application', $data);
        $this->load->view('inc/footer',$data);
        
        
    }
    
function fetch_data()
 {
  sleep(1);
  $this->load->model('applicationmodel','',TRUE);
  
  $this->load->helper(array('form', 'url','common'));
  $this->load->library(array('session', 'pagination','cart'));
  
  $sort_by =$this->input->post('sort_by');
  
  $limit = 10;


  $config = array();
  $config["base_url"] = '#';
  $config['total_rows'] = $this->applicationmodel->count_all($sort_by);
  $config['per_page'] = $limit;
  $config['uri_segment'] = 3;
  $config['use_page_numbers'] = TRUE;
  $config['full_tag_open'] = '<ul class="pagination">';
  $config['full_tag_close'] = '</ul>';
  $config['first_tag_open'] = '<li>';
  $config['first_tag_close'] = '</li>';
  $config['last_tag_open'] = '<li>';
  $config['last_tag_close'] = '</li>';
  $config['next_link'] = '&gt;';
  $config['next_tag_open'] = '<li>';
  $config['next_tag_close'] = '</li>';
  $config['prev_link'] = '&lt;';
  $config['prev_tag_open'] = '<li>';
  $config['prev_tag_close'] = '</li>';
  $config['cur_tag_open'] = "<li class='active'><a href='#'>";
  $config['cur_tag_close'] = '</a></li>';
  $config['num_tag_open'] = '<li>';
  $config['num_tag_close'] = '</li>';
  $config['num_links'] = 3;
  $this->pagination->initialize($config);
  $page = $this->uri->segment(3);
  $start = ($page - 1) * $config['per_page'];
  $output = array(
   'pagination_link'  => $this->pagination->create_links(),
   'product_list'   => $this->applicationmodel->fetch_data($config["per_page"], $start,$sort_by)
  );
  echo json_encode($output);
  
  
 }

function fetch_application_data()
 {
  sleep(1);
  $this->load->model('applicationmodel','',TRUE);
  
  $this->load->helper(array('form', 'url','common'));
  $this->load->library(array('session', 'pagination','cart'));
  
  $app1 = $this->input->post('appid21'); // 1stsegment
  
  $qry ="SELECT id from application WHERE slug='$app1'";
  
  
  $sql = $this->db->query("SELECT id from application where slug='$app1'");
        
  $result = $sql->result();
       
  $appid = $result[0]->id;

  $sort_by = $this->input->post('sort_by1');
  
  $limit =$this->input->post('limit1');


  $config = array();
  $config["base_url"] = '#';
  $config['total_rows'] = $this->applicationmodel->count_all1($sort_by,$appid);
  $config['per_page'] = $limit;
  $config['uri_segment'] = 3;
  $config['use_page_numbers'] = TRUE;
  $config['full_tag_open'] = '<ul class="pagination">';
  $config['full_tag_close'] = '</ul>';
  $config['first_tag_open'] = '<li>';
  $config['first_tag_close'] = '</li>';
  $config['last_tag_open'] = '<li>';
  $config['last_tag_close'] = '</li>';
  $config['next_link'] = '&gt;';
  $config['next_tag_open'] = '<li>';
  $config['next_tag_close'] = '</li>';
  $config['prev_link'] = '&lt;';
  $config['prev_tag_open'] = '<li>';
  $config['prev_tag_close'] = '</li>';
  $config['cur_tag_open'] = "<li class='active'><a href='#'>";
  $config['cur_tag_close'] = '</a></li>';
  $config['num_tag_open'] = '<li>';
  $config['num_tag_close'] = '</li>';
  $config['num_links'] = 3;
  $this->pagination->initialize($config);
  $page = $this->uri->segment(3);
  $start = ($page - 1) * $config['per_page'];
  $output = array(
   'pagination_link'  => $this->pagination->create_links(),
   'product_list'   => $this->applicationmodel->fetch_application_data($config["per_page"], $start,$sort_by,$appid)
  );
  echo json_encode($output);
  
  
 }
 
 
 
 
 
    



}