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

class Welcome extends Public_Controller {

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

	public function index()
	{
			//SEO browser title and meta details homepage
			$this->db->select('browser_title, meta_description, meta_keywords, home_welcome')
			->from('configuration')->where('id_configuration', 1);
			$website = $this->db->get()->row();
			$this->data_header['browser_title'] = $website->browser_title;
			$this->data_header['meta_description'] = $website->meta_description;
			$this->data_header['meta_keywords'] = $website->meta_keywords;
			$this->data['welcome_message'] = $website->home_welcome;

			//CUSTOM INFO TEXT
			$this->db->select('topinfo')->from('topinfo')->where('id_topinfo', 1);
			$this->data['custom_info'] = $this->db->get()->row()->topinfo;

			//get home banners & texts
			$this->db->select('*')->from('home_centerbanners')->where('id_home_centerbanners', 1);
			$this->data['home'] = $this->db->get()->row();

			//GET FEATURED PRODUCTS
			$this->db->group_by('products.id_products');
			$this->db->select('products.alias as alias, products.image1 as image1,
			products.title as title, products.id_products as id_products,
			products.created_at, product_details.price, product_details.discounted_price,
			products.preorder_message as preorder_message');
			$this->db->from('products');
			$this->db->join('category_product', 'category_product.id_product = products.id_products');
			$this->db->join('product_details', 'product_details.product_id = products.id_products');
			// $this->db->where('products.new_arrival', 'yes');
			$this->db->where('products.product_status', 1);
			$this->db->where('category_product.id_category', $this->data['home']->category_id);
			$this->db->order_by('products.title', 'RANDOM');
			$this->db->limit(3);
			$this->data['new_products'] = $this->db->get()->result();
	
			//get all slideshow
			$this->db->select('*')->from('home_slideshow')->where('status', '1')->order_by('priority', 'ASC');
			$this->data['slideshows'] = $this->db->get()->result();

			//LOAD VIEW
			$this->load->view('template/header', $this->data_header);
			$this->load->view('welcome', $this->data);
			$this->load->view('template/footer', $this->data_footer);
	}
}