<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Home_model extends CI_Model{

	function get_home(){
		$data = $this->db->query("SELECT * FROM home")->row_array();
		$data['banners'] = $this->db->query("SELECT * FROM home_banner ORDER BY sort_order ASC")->result();
	//	$data['explores'] = $this->db->query("SELECT * FROM home_category ORDER BY sort_order ASC")->result();
		$data['testimonials'] = $this->db->query("SELECT * FROM testimonial WHERE status='1' ORDER BY id DESC LIMIT 5")->result();
		$data['portfolio'] = $this->db->query("SELECT * FROM event WHERE status='1' ORDER BY event_id DESC LIMIT 6")->result();
			$data['portfolio1'] = $this->db->query("SELECT * FROM event WHERE status='1' and category='Web Design' ORDER BY event_id DESC LIMIT 6")->result();
				$data['portfolio2'] = $this->db->query("SELECT * FROM event WHERE status='1' and category='Web Development' ORDER BY event_id DESC LIMIT 6")->result();
		//$data['services'] = $this->db->query("SELECT * FROM category WHERE status='1' ORDER BY id ASC LIMIT 9")->result();
	//	$data['blogs'] = $this->db->query("SELECT * FROM blog WHERE status = '1' ORDER BY created DESC LIMIT 5")->result();
		$data['clients'] = $this->db->query("SELECT * FROM clients order by name asc ")->result();
		$data['teams'] = $this->db->query("SELECT * FROM team WHERE status='1' order by name asc LIMIT 4")->result();
		$data['categorytablehead'] = $this->db->query("SELECT * FROM category_table_header  LIMIT 2")->result();
		$data['categorydata'] = $this->db->query("SELECT * FROM category_table_data")->result();
		return $data;
	}
	
	function get_news(){
		$data['news_events'] = $this->db->query("SELECT * FROM event WHERE status='1' ORDER BY event_id DESC LIMIT 2")->result();
		return $data;
	}
	
	
		function get_web($id){
		$data = $this->db->query("SELECT * FROM website_banner WHERE cat_id='$id'");
		return $data;
	}
		function get_metas($id){
		$data = $this->db->query("SELECT * FROM metas WHERE url='$id'");
		return $data;
	}
	
		function faq(){
		  
		 $data = $this->db->query("SELECT * FROM `tbl_faq`")->result();
// 		 print_r($data);
		 return $data;
	}
		function get_grap($id){
		$data = $this->db->query("SELECT * FROM graphics_banner WHERE cat_id='$id'");
		return $data;
	}
		function get_faq($id){
		$data = $this->db->query("SELECT * FROM faq WHERE catid='$id'");
		return $data;
	}
		function get_pack($id,$dtt){
		$data = $this->db->query("SELECT * FROM tbl_package WHERE catid='$id' and SName='$dtt' order by id asc")->result();
		return $data;
	}
		function get_price($id,$dtt){
		    //echo "SELECT * FROM p_price WHERE catid='$id' and pname='$dtt' order by id asc";exit;
		$data = $this->db->query("SELECT * FROM p_price WHERE catid='$id' and pname='$dtt' order by id asc")->result();
		return $data;
	}
	
function get_packName($id){
    $data = $this->db->query("
        SELECT SName 
        FROM tbl_package 
        WHERE catid='$id' 
        GROUP BY SName 
        ORDER BY SName DESC
    ");
    return $data;
}
	
		function get_seo(){
		    $data['teams'] = $this->db->query("SELECT * FROM team WHERE status='1' order by name asc LIMIT 4")->result();
		    	$data['testimonials'] = $this->db->query("SELECT * FROM testimonial WHERE status='1' ORDER BY id DESC LIMIT 5")->result();
		$data['service'] = $this->db->query("SELECT * FROM category WHERE status='1' and Cat_type='seo' ")->result();
		$data['categorytablehead'] = $this->db->query("SELECT * FROM category_table_header")->result();
			$data['categorytablehead1'] = $this->db->query("SELECT * FROM category_table_header where region='Domestic'")->result();
				$data['categorytablehead2'] = $this->db->query("SELECT * FROM category_table_header where region='International'")->result();
		$data['categorydata'] = $this->db->query("SELECT * FROM category_table_data")->result();
			$data['portfolio'] = $this->db->query("SELECT * FROM event WHERE status='1' ORDER BY event_id DESC LIMIT 6")->result();
			$data['portfolio1'] = $this->db->query("SELECT * FROM event WHERE status='1' and category='Web Design' ORDER BY event_id DESC LIMIT 6")->result();
				$data['portfolio2'] = $this->db->query("SELECT * FROM event WHERE status='1' and category='Web Development' ORDER BY event_id DESC LIMIT 6")->result();
	
		return $data;
	}
	
	
	function get_seodata($id){
		
		$data = $this->db->query("SELECT * FROM category_table_data where headId='$id'")->result();
		return $data;
	}
	
		function seo_banner(){
		
		$data = $this->db->query("SELECT * FROM seo_banner where seo_id=1")->result();
		return $data;
	}
	
		function seo(){
		
		$data = $this->db->query("SELECT * FROM seo where home_id=1")->result();
		return $data;
	}
	
	function get_news_page(){
		$data = $this->db->query("SELECT * FROM event WHERE status='1' ORDER BY event_id DESC")->result();
		return $data;
	}
	
	function get_news_single($id){
		$query = $this->db->query("SELECT * FROM event WHERE event_id = '" . (int)$id . "' AND status = '1'");
		return $query->row();
	}
	
	function get_blogs(){
		$query = $this->db->query("SELECT * FROM blog WHERE status = '1'");
		return $query;
	}
	
	function recent_blogs(){
		$query = $this->db->query("SELECT * FROM blog WHERE status = '1' ORDER BY created DESC");
		return $query;
	}

	function get_blog($id){
		$query = $this->db->query("SELECT * FROM blog WHERE id = '" . (int)$id . "' AND status = '1'");
		return $query;
	}
	
	/*------- Category --------*/
	function category_query(){
	    $query = array();
		$sql = "SELECT * FROM category WHERE parent_id !=0 AND status='1'";
		$query = $sql;
		return $query;
	}
	
	function get_category($start, $limit){
		$query = array();
		$sql = $this->category_query();
 		$sql .= " ORDER BY id DESC";
		$sql .= " LIMIT " . $limit . "," . $start . "";
		//echo '<pre>'; print_r($sql); '</pre>'; exit();
		//echo $sql; exit();
		$query = $this->db->query($sql);
		return $query;
	}

	function get_category_count(){
		$query = $this->db->query("SELECT COUNT(id) as total FROM category WHERE 1=1 AND status='1'");
		return $query->row()->total;
	}
	
	function count_all_category(){
		$query = $this->category_query();
		$data = $this->db->query($query);
		return $data->num_rows();
	}
	/*------- Category End --------*/
	
	/*------- Rooms --------*/
	function rooms_query($cat_id){
	    $query = array();
		$sql = "SELECT p.* FROM rooms p WHERE p.id IN (SELECT pc.room_id FROM room_category pc WHERE pc.category_id = '" . (int)$cat_id . "') AND p.status = '1'";
		$query = $sql;
		return $query;
	}
	
	function get_rooms($start, $limit, $cat_id){
		$query = array();
		$sql = $this->rooms_query($cat_id);
 		$sql .= " ORDER BY p.id DESC";
		$sql .= " LIMIT " . $limit . "," . $start . "";
		//echo '<pre>'; print_r($sql); '</pre>'; exit();
		//echo $sql; exit();
		$query = $this->db->query($sql);
		return $query;
	}

	function get_rooms_count($cat_id){
		$query = $this->db->query("SELECT COUNT(room_id) as total FROM room_category WHERE category_id = '". $cat_id ."'");
		return $query->row()->total;
	}
	
	function count_all_rooms($cat_id){
		$query = $this->rooms_query($cat_id);
		$data = $this->db->query($query);
		return $data->num_rows();
	}
	/*------- Rooms End --------*/
	
	function make_query(){
	    $query = array();
		$sql = "SELECT * FROM testimonial WHERE status='1' ";
		$query = $sql;
		return $query;
	}
	
	function get_testimonials(){
		$query = array();
		$sql = $this->make_query();
 		$sql .= " ORDER BY id DESC";
		//$sql .= " LIMIT " . $limit . "," . $start . "";
		//echo '<pre>'; print_r($sql); '</pre>'; exit();
		//echo $sql; exit();
		$query = $this->db->query($sql);
		return $query;
	}

	function get_testimonial_count(){
		$query = $this->db->query("SELECT COUNT(id) as total FROM testimonial WHERE  status='1'");
		return $query->row()->total;
	}
	
	function count_all_testimonial(){
		$query = $this->make_query();
		$data = $this->db->query($query);
		return $data->num_rows();
	}

	function get_search($term){
		$sql = "SELECT p.* FROM rooms p where (p.sku = '" . $this->db->escape_str($term) . "' OR p.name LIKE '%" . $this->db->escape_str($term) . "%')";
		$query = $this->db->query($sql);
		return $query->result();
	}

	function get_search1($term){
		return true;
	}

	function get_product($id){
		$data = $this->db->query("SELECT * FROM rooms WHERE id = '" . (int)$id . "'")->row_array();
		$data['images'] = $this->db->query("SELECT * FROM rooms_image WHERE room_id = '" . (int)$id . "'")->result_array();
		$data['prices'] = $this->db->query("SELECT * FROM room_price WHERE room_id = '" . (int)$id . "'")->result_array();
		if(!empty($data['amenities'])){
		    $data['amenities'] = $this->db->query("SELECT amenities_name,icon FROM master_amenities WHERE id IN (" . $data['amenities'] . ") ORDER BY amenities_name")->result_array();
		}else{
		    $data['amenities'] = [];
		}
		$data['similars'] = $this->db->query("SELECT p.* FROM rooms p WHERE p.id IN (SELECT pc.room_id FROM room_category pc WHERE pc.category_id = (SELECT category_id FROM room_category WHERE room_id = '" . (int)$id . "'LIMIT 1))  AND p.id != '" . (int)$id . "' LIMIT 8")->result_array();
		return $data;
	}

	function get_image($id){
		$query = $this->db->query("SELECT image FROM product_image WHERE product_id = '" . (int)$id . "'");
		return $query;
	}
	
	function get_page($id){
		$query = $this->db->query("SELECT * FROM cms WHERE id = '" . (int)$id . "'");
		return $query->result();
	}


	function get_faqs(){
		$query = $this->db->query("SELECT * FROM faqs WHERE id = '" . (int)$id . "'");
		return $query;
	}

	function get_clients(){
		$query = $this->db->query("SELECT * FROM clients order by name asc");
		return $query;
	}
	
	function get_teams(){
		$query = $this->db->query("SELECT * FROM team WHERE status = '1' order by name asc");
		return $query;
	}
	
	function get_certificates(){
		$query = $this->db->query("SELECT * FROM certificates order by name asc");
		return $query->result();
	}
	
	function get_gallery(){
		$query = $this->db->query("SELECT * FROM gallery order by sort_order asc");
		return $query->result();
	}
	
	function get_videos(){
		$query = $this->db->query("SELECT * FROM youtube_videos WHERE status = '1' ORDER BY sort_order ASC");
		return $query->result();
	}
	
	function get_links(){
		$query = $this->db->query("SELECT * FROM useful_links WHERE status = '1' ORDER BY sort_order ASC");
		return $query->result();
	}
	
	function get_contact_cms(){
		$query = $this->db->query("SELECT * FROM contact_cms");
		return $query->row();
	}
	
	function submit_contact_us(){
		$query = $this->db->query("INSERT INTO contact SET name = '" . $this->db->escape_str($this->input->post('name')) . "', email = '" . $this->db->escape_str($this->input->post('email')) . "', mobile = '" . $this->db->escape_str($this->input->post('mobile')) . "', subject = '" . $this->db->escape_str($this->input->post('subject')) . "', address = '" . $this->db->escape_str($this->input->post('address')) . "', message = '" . $this->db->escape_str($this->input->post('message')) . "', status = '2', created = NOW()");

		/* Send mail */
		return $query;
	}
	
	function submit_bookings(){
		$query = $this->db->query("INSERT INTO bookings SET room_name = '" . $this->db->escape_str($this->input->post('room_name')) . "', name = '" . $this->db->escape_str($this->input->post('name')) . "', email = '" . $this->db->escape_str($this->input->post('email')) . "', mobile = '" . $this->db->escape_str($this->input->post('mobile')) . "', adults = '" . $this->db->escape_str((int)$this->input->post('adults')) . "', children = '" . $this->db->escape_str((int)$this->input->post('children')) . "', check_in = '" . $this->db->escape_str($this->input->post('check_in')) . "', check_out = '" . $this->db->escape_str($this->input->post('check_out')) . "', message = '" . $this->db->escape_str($this->input->post('message')) . "', status = '0', created = NOW(), modified = NOW(), ip = '" . $this->input->ip_address() . "'");

		/* Send mail */
		return $query;
	}
	
	function submit_support_form(){
	    //echo "INSERT INTO support_form SET name = '" . $this->db->escape_str($this->input->post('name')) . "', email = '" . $this->db->escape_str($this->input->post('email')) . "', contact_no = '" . $this->db->escape_str($this->input->post('phone')) . "', problems = '" . $this->db->escape_str($this->input->post('message')) . "',  status = '2', created_at = NOW()";exit;
		$query = $this->db->query("INSERT INTO support_form SET name = '" . $this->db->escape_str($this->input->post('name')) . "', email = '" . $this->db->escape_str($this->input->post('email')) . "', contact_no = '" . $this->db->escape_str($this->input->post('phone')) . "', problems = '" . $this->db->escape_str($this->input->post('message')) . "',  status = '2', created_at = NOW()");

		/* Send mail */
		return $query;
	}
	
	function get_review(){
		$query = $this->db->query("SELECT * FROM customer_review WHERE status = 1");
		return $query->result();
	}
	
	function customer_review(){
		$query = $this->db->query("INSERT INTO customer_review SET name = '" . $this->db->escape_str($this->input->post('name')) . "', email = '" . $this->db->escape_str($this->input->post('email')) . "', mobile = '" . $this->db->escape_str($this->input->post('mobile')) . "', massage = '" . $this->db->escape_str($this->input->post('massage')) . "', star = '" . $this->db->escape_str($this->input->post('star')) . "',status = '2', created = NOW()");

		/* Send mail */
		return $query;
	}
	
	function submit_newsletter(){
		$query = $this->db->query("INSERT INTO newsletter SET email = '" . $this->db->escape_str($this->input->post('email')) . "', mobile = '" . $this->db->escape_str($this->input->post('mobile')) . "', name = '" . $this->db->escape_str($this->input->post('name')) . "', created = NOW()");
		return $query;
	}

}
