<?php
/**
 * Class AccomdationRoom
 * Description 	This model contains the functions related to Hotel Rooms.
 * @name	Agency
 * @author	Er Amit Kumar Dubey on 24 feb 2017
 * @version 	1.0
 * @copyright 	Catabatic Automation Pvt. Ltd.
 * Handle 	Hotel Room Related function
 *
 */

class Travel_Model_TblICAccomdationRoom {
    
    private $db = NULL;
    
    public function __construct() {
        $request = Zend_Controller_Front::getInstance()->getRequest();
        $this->baseUrl = $request->getScheme() . '://' . $request->getHttpHost();
        $this->db = Zend_Db_Table::getDefaultAdapter(); 
    }
    
    public function __destruct() {
        $this->db->closeConnection(); 
    }
	public function addAccomRoomInfo(array $data) {
		$this->db->insert('TB_IC_Accomdation_Room',$data);
		$lastID = $this->db->lastInsertId();
		return $lastID;
	}
	public function updateAccomRoomInfo($data = array(), $where) {
		$this->db->update('TB_IC_Accomdation_Room',$data,$where);
	}
	public function GetAccomRoomDetail($AccomSysId=NULL,$roomNumber=NULL,$RoomIndex=NULL){
		$select = $this->db->select();
		$accomRoomArray = array('AccomSysId');
		$select->from(array('tbl' => "TB_IC_Accomdation_Room",$accomRoomArray));
		$select->where('tbl.AccomSysId = ?', $AccomSysId);
		$select->where('tbl.RoomIndex = ?', $RoomIndex);
		$select->where('tbl.RoomNumber = ?', $roomNumber);
		$select->where('tbl.IsActive = ? ',1);
		$select->where('tbl.IsDelete = ? ',0);
		$result = $this->db->fetchRow($select);
	   return $result;
   }
}