<?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');
        } else {

            $this->lang->load('homepage', '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)
    {
        $data = array();

        // Get product IDs from product_suggest
        if ($id != null) {
            $this->db->select('product_suggest');
            $this->db->from('products');
            $this->db->where('id_products', $id);
            $product_suggest = $this->db->get()->row()->product_suggest;

            if ($product_suggest) {
                $product_ids = array_filter(explode(',', $product_suggest));

                if (!empty($product_ids)) {
                    $this->db->select('products.id_products, products.title, products.alias, category_product.id_category, brands.brand, product_combination.attribute_id');
                    $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->join('product_combination', 'product_combination.product_id = products.id_products', 'left');
                    $this->db->join('product_attributes', 'product_attributes.id = product_combination.attribute_id', 'left');
                    $this->db->where_in('products.id_products', $product_ids);
                    $this->db->where('products.product_status', 1);
                    $this->db->group_by('products.id_products');
                    $this->db->order_by('products.title', 'RANDOM');
                    $this->db->limit(4);
                    $data['new_arrivals'] = $this->db->get()->result();
                }
            }
        }




        if (!empty($data['new_arrivals'])) {
            $this->load->view("$this->theme_no/newarrival", $data);
        } else {
        }
    }
}