<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Newarrival extends Public_Controller {
    function __construct() {
        parent::__construct();      
    }
    public function index() {  
        //check if post sort_product is exist
        if ($this->input->post('sort_product')) {
            $this->session->set_userdata('sort_product', $this->input->post('sort_product'));
        }
        //PRODUCTS
        //pagination in action. 
        //get no. of products per page (pagination) from configuration table
        $this->db->select('products_displayed')->from('configuration')->where('id_configuration', 1);
        $per_page = $this->db->get()->row(); 
        //PRODUCTS
        //pagination in action 
        $this->load->library('pagination');
        $config = array();
        $this->load->helper('pagination_helper');
        $config = pagination_format();
        $config['base_url'] = base_url() . 'newarrival/index/';
        $this->load->model('product_m');
        $config['total_rows'] = $this->product_m->count_products_new_arrival();
        $config['per_page'] = (int) $per_page->products_displayed;  
        $config['uri_segment'] = 3;
        $this->pagination->initialize($config); 
        $this->data['sort_product_by'] = $this->session->userdata('sort_product');
        $this->data['total_products'] = $config['total_rows'];
        $this->data['products'] = $this->product_m->get_products_new_arrival($config['per_page'], $this->uri->segment($config['uri_segment']));  
        //get all category landing page banner
        // $this->db->select('category_landingpage_image')->from('configuration')->where('id_configuration', 1);
        // $this->data['category_landingpage_image'] = $this->db->get()->row()->category_landingpage_image;      
        //to display title on product_list view
        $this->data['product_list_title'] = 'New Arrival';   
        //get SEO
        $this->db->select('website_name')->from('configuration')->where('id_configuration', 1);
        $website_name = $this->db->get()->row();
        $this->data_header['browser_title'] =  ucwords($website_name->website_name) . ' - New Arrival'; 
        $this->data_header['meta_description'] = ucwords($website_name->website_name) . ' - New Arrival';
        //LOAD LANGUAGE FILES FOR HOMEPAGE & BLOG
        if($this->session->userdata('site_lang') == 'english') {
            $this->lang->load('homepage', 'english');
            $this->lang->load('product_list', 'english');
        } else {
            $this->lang->load('homepage', 'indonesian');
            $this->lang->load('product_list', 'indonesian');
        }
        $this->data['category_url'] = 'bestseller';
        $this->load->view("themes/$this->theme_no/header", $this->data_header);
        $this->load->view("themes/$this->theme_no/product_list", $this->data);
        $this->load->view("themes/$this->theme_no/footer", $this->data_footer); 
    }
    public function frontpage($id=null) { 
        //get products new arrival 
        $q_get_id_category = null;
        $limit_show = 4;
        if ($id != null) {
            $this->db->select('products.id_products,products.brand_id, products.title, products.alias,category_product.id_category,brands.brand'); 
            $this->db->from('products'); 
            $this->db->join('category_product','category_product.id_product = products.id_products'); 
            $this->db->join('categories','categories.id_categories = category_product.id_category');
            $this->db->join('brands','brands.id_brands = products.brand_id');
            $this->db->where('category_product.id_product', $id); 
            $this->db->where('products.product_status', 1); 
            $this->db->order_by('products.title', 'RANDOM');  
            $q_get_id_category = $this->db->get()->row();
            // echo "<script>alert('".$q_get_id_category->id_category."');</script>";
            $limit_show = 3;
            $data['product_referrence'] = true;
        }
        $this->db->select('products.new_arrival, products.id_products,products.brand_id, products.title, products.alias,category_product.id_category,brands.brand'); 
        $this->db->from('products'); 
        $this->db->join('category_product','category_product.id_product = products.id_products'); 
        $this->db->join('categories','categories.id_categories = category_product.id_category'); 
        $this->db->join('brands','products.brand_id = brands.id_brands'); 
        if ($q_get_id_category != null) {
            $this->db->where('categories.id_categories', $q_get_id_category->id_category);  
        }
        $this->db->where('products.product_status', 1); 
        $this->db->group_by('products.id_products, products.brand_id'); 
        $this->db->order_by('products.title', 'RANDOM'); 
        $this->db->limit($limit_show);
        $data['new_arrivals'] = $this->db->get()->result();
        $this->load->view("$this->theme_no/newarrival", $data); 
    }
}