<?php

/*
 * Catabatic Technology Pvt. Ltd.
 * File Name :TblCRMCustomer.php
 * File Description :Manage to Customer Operation
 * Created By : Shobhit Srivastav 
 * Created Date: 03-Aug-2016
 */

class Travel_Model_CRM_CustomerTravelPlanHotel
{
	protected $_dbObj;
	protected $_custtravelHotelObj;
	protected $_custtravelHotelRoomObj;

	public function __construct()
	{

		$this->_custtravelHotelObj = new Travel_Model_TblCustomerTravelPlanHotel();
		$this->_custtravelHotelRoomObj = new Travel_Model_TblCustomerTravelPlanHotelRoom();
		$this->_dbObj = Zend_Db_Table::getDefaultAdapter();
	}


	public function addCustomerTravelPlanHotel(array $data)
	{
		$this->_custtravelHotelObj->insert($data);
		$lastID = $this->_dbObj->lastInsertId();
		return $lastID;
	}
	public function addCustomerTravelPlanHotelRoom(array $data)
	{
		$this->_custtravelHotelRoomObj->insert($data);
		$lastID = $this->_dbObj->lastInsertId();
		return $lastID;
	}
	public function UpdateCustomerTravelPlanHotel(array $data, $where = NULL)
	{
		$this->_custtravelHotelObj->update($data, $where);
	}
	public function GetAccomDetailsById($id)
	{
		$columns = array('TPIntSysId', 'AdultPax', 'ChildPax', 'ChildsAge', 'CreateDate', 'UpdateDate');
		$select = $this->_dbObj->select();
		$select->from('TB_Agency_Customer_TravelPlan_Accom', $columns);
		$select->where("TB_Agency_Customer_TravelPlan_Accom.TPIntSysId = ?", $id);
		$result = $this->_dbObj->fetchAll($select);
		return $result;
	}
	public function DeleteCustomerTravelPlanHotel($where)
	{
		$this->_custtravelHotelObj->delete($where);
	}
}