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

class Welcome extends Public_Controller 
{
		public function __construct() 
		{   
				parent::__construct();
		}

		public function index() 
		{  
				//SEO configuration data
				$this->db->select('browser_title, meta_description, why_title')->from('configuration')->where('id_configuration', 1); 
				$website_data = $this->db->get()->row();
				$this->data_header['browser_title'] = $website_data->browser_title;
				$this->data_header['meta_description'] = $website_data->meta_description;
				$this->data['why_title'] = $website_data->why_title; 
				
				//get slideshows
				$this->db->select('title, image, text_content')->from('home_slideshow')->where('status', '1')->where('type', 'homepage')->order_by('priority', 'ASC');
				$this->data['slideshows'] = $this->db->get()->result_array();  

				//get home content
				$this->data['home'] = $this->db->select('about_title, about_image1, about_image2, about_text, statistic1_title, statistic2_title, statistic3_title, statistic1_text, statistic2_text, statistic3_text, why_text, aboutpage_title, aboutpage_subtitle, about_image4')->from('home_centerbanners')->where('id_home_centerbanners', 1)->get()->row_array(); 

				//get categories
				$this->data['categories'] = $this->db->select('category, image, alias')->from('categories')->where('status', '1')->order_by('priority', 'ASC')->get()->result_array();

				//get services
				$this->data['services'] = $this->db->select('name, image1, alias')->from('service')->where('status', '1')->order_by('priority', 'ASC')->get()->result_array();

				//get history
				$this->data['history'] = $this->db->select('year, content')->from('history')->where('status', '1')->order_by('priority', 'ASC')->get()->result_array(); 

				//get portfolio categories
				$this->data['portfolios_cat'] = $this->db->select('id, name')->from('portfolios_category')->where('status', '1')->order_by('priority', 'ASC')->get()->result_array(); 

				//get portfolios
				$this->data['portfolios'] = $this->db->select('portfolios_category_id, name, image')->from('portfolios')->where('status', '1')->limit(8)->order_by('id_portfolios', 'RANDOM')->get()->result_array();  

				//get residential portfolios
				$this->data['portfolios_residential'] = $this->db->select('portfolios_category_id, name, image')->from('portfolios')->where('status', '1')->where('portfolios_category_id', 1)->limit(8)->order_by('id_portfolios', 'RANDOM')->get()->result_array();  

				//get office portfolios
				$this->data['portfolios_office'] = $this->db->select('portfolios_category_id, name, image')->from('portfolios')->where('status', '1')->where('portfolios_category_id', 2)->limit(8)->order_by('id_portfolios', 'RANDOM')->get()->result_array(); 

				//get hotel portfolios
				$this->data['portfolios_hotel'] = $this->db->select('portfolios_category_id, name, image')->from('portfolios')->where('status', '1')->where('portfolios_category_id', 3)->limit(8)->order_by('id_portfolios', 'RANDOM')->get()->result_array(); 

				//get customer testimonials
				$this->data['testimonies'] = $this->db->select('customer_name, testimony, image')->from('testimonies')->where('type', 'customer')->where('status', '1')->order_by('priority', 'ASC')->get()->result_array();  

				//get brands
				$this->data['brands'] = $this->db->select('logo, banner_link')->from('brands')->where('status', '1')->order_by('priority', 'ASC')->get()->result_array(); 

				//get latest blog 
				$this->data['blogs'] = $this->db->select('blog, blog.alias, publish_date, image2, description, name')->from('blog')->join('blogs_category', 'blogs_category.id = blog.id_blogs_category')->where('blog.status', '1')->order_by('blog.publish_date', 'DESC')->limit(3)->get()->result_array();  

				//get showrooms images
				$this->data['showrooms'] = $this->db->select('showroom, image2')->from('showroom')->where('status', '1')->order_by('priority', 'ASC')->get()->result_array();  

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