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

class Room_m extends MY_Model {
	
	protected $_table_name = 'hotel_rooms';
	protected $_primary_key = 'id';
	protected $_order_by = 'id';

	public $rules = array( 
        array(
             'field'   => 'room_name', 
             'label'   => 'room Name',
             'rules'   => 'trim|required|callback__cek_existing_room_name'
          )
    ); 

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

	//pagination included
	function get_all_rooms($limit, $start) {
		$this->db->select('*');
		$this->db->from('hotel_rooms');
		$this->db->where('id !=', '0');
		$this->db->order_by('id');
		$this->db->limit($limit, $start);
		$query = $this->db->get();		
		return $query->result();
	}


	//function count all record for rooms
	public function record_count() {
        return $this->db->get('hotel_rooms')->num_rows(); 
    }

    //function count if existing record exist
	public function count_exist($id) {
        $this->db->select('*');
        $this->db->from('hotel_rooms');
        $this->db->where('id', $id);
        $query = $this->db->get();		
		return $query->num_rows();
    }
	
	function get_room($slug) {

		$this->db->select('*');
		$this->db->from('hotel_rooms');
		$this->db->where('slug', $slug);
		$query = $this->db->get();		
		return $query->row(); 
	}

	//function to display new room, where all fields are empty
	public function get_new() {
		$rooms = new stdClass();
        $rooms->room_name = '';	
        $rooms->introduction = '';	
        $rooms->priority = '';
        
        // New fields from hotel_rooms_additional_columns.sql
        $rooms->room_image = '';
        $rooms->intro_image = '';
        $rooms->intro_title = '';
        $rooms->intro_subtitle = '';
        $rooms->highlight_intro = '';
        $rooms->overview1_title = '';
        $rooms->overview1_content = '';
        $rooms->overview2_title = '';
        $rooms->overview2_content = '';
        $rooms->overview3_title = '';
        $rooms->overview3_content = '';
        $rooms->amenities1_title = '';
        $rooms->amenities1_content = '';
        $rooms->amenities2_title = '';
        $rooms->amenities2_content = '';
        $rooms->amenities3_title = '';
        $rooms->amenities3_content = '';
        $rooms->amenities4_title = '';
        $rooms->amenities4_content = '';
        $rooms->amenities5_title = '';
        $rooms->amenities5_content = '';
        $rooms->amenities6_title = '';
        $rooms->amenities6_content = '';	
		return $rooms; 
	}

	//function add new room
	function add_room($data) {
		$this->db->insert('hotel_rooms', $data);	
		return $this->db->insert_id();	 
	}

	//function edit room
	function edit_room($id, $data) {
		$this->db->where('id', $id);
		$this->db->update('hotel_rooms', $data);	
	}

	//cek if room title already exist
	public function cek_existing_room_name($str, $room_id) {
		$this->db->select('id');
		$this->db->from('hotel_rooms');
		$this->db->where('room_name', $str);
		$this->db->where('hotel_id',$this->session->userdata('hotel_id'));

		if ($room_id != NULL) {
			$this->db->where('id !=', $room_id);	
		} 

		$query = $this->db->get();
		return $query->num_rows();
	}

	

	
}