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

class Bestseller 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() . 'bestseller/index/';
        $this->load->model('product_m');
        $config['total_rows'] = $this->product_m->count_products_bestseller();
        $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_bestseller($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'] = 'best seller';

        //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) . ' - Best Seller';
        $this->data_header['meta_description'] = ucwords($website_name->website_name) . ' - Best Seller';

        //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()
    {
        // Get customer_id from session (assuming you have already set the session)
        $customer_id = $this->session->userdata('customer')['customer_id'];

        // Get products best seller
        $this->db->select('p.id_products, p.brand_id, p.title, p.alias');
        $this->db->from('products p');
        $this->db->join('(SELECT product_id, COUNT(*) AS review_count FROM product_review GROUP BY product_id) pr', 'p.id_products = pr.product_id');
        $this->db->where('p.product_status', 1);

        // Check if customer_id_exc is not empty and matches the customer_id from session
        $this->db->where('(
        p.customer_id_exc IS NULL
        OR p.customer_id_exc = "" 
        OR p.customer_id_exc = ' . $this->db->escape($customer_id) . '
    )');

        $this->db->order_by('pr.review_count', 'DESC');
        $this->db->limit(8);
        $data['best_sellers'] = $this->db->get()->result();

        $this->load->view("$this->theme_no/bestseller", $data);

        // best_sellers 
    }
}