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



class Caffe extends CI_Controller {

    public function __construct() {parent::__construct();









    }



    public function index() {

        $query = $this->db->query("SELECT title, keywords, description FROM meta WHERE page_id = '".$this->uri->segment(1)."'");

        $data=$query->row_array();

        $this->load->view('inc/header', $data);

        $data['category_business']=array(10,50,51,52,53);







        $config['base_url'] = base_url().$this->uri->segment(1);

        $this->db->select('tickets.*,tickets_categorys.category_id');

        $this->db->group_by('ticket_id');

        $this->db->join('tickets_categorys', 'tickets.ticket_id = tickets_categorys.ticket_id');

        $this->db->where_in('category_id',$data['category_business']);

        $this->db->where(array('ticket_status' => "publish"));



        $config['total_rows']=$this->db->get('tickets')->num_rows();

        $data['show_add']=false;





        $config['per_page'] =  10;

        $last=$config['total_rows']/$config['per_page'];

        $last=ceil($last);

        $config['num_links'] = 2;

        $config['uri_segment'] = 2;

        $config['first_link'] = '1..';

        $config['last_link'] = '..'.$last;

        $config['prev_link'] = FALSE;

        $config['next_link'] = FALSE;

        $config['first_url'] = $config['base_url'].'?'.http_build_query($_GET).'#tickets';

        if (count($_GET) > 0) $config['suffix'] = '?' . http_build_query($_GET, '', "&");

        $config['suffix']=$config['suffix'].'#tickets';

        $this->pagination->initialize($config);

        $data['pager']=$this->pagination->create_links();

        $from=intval($this->uri->segment(2));



        $this->db->limit(10,$from);

        $this->db->select('tickets.*,tickets_categorys.category_id');

        $this->db->group_by('ticket_id');

        $this->db->join('tickets_categorys', 'tickets.ticket_id = tickets_categorys.ticket_id');

        $this->db->where_in('category_id',$data['category_business']);

        $this->db->where(array('ticket_status' => "publish"));

        $this->db->order_by('ticket_date_modified', "DESC ");



        $data['tickets']=$this->db->get('tickets')->result_array();





        $this->load->view('pages/fastSearch',$data);



        $this->load->view('inc/footer');

    }









}



?>