<?php

class Travel_Model_TblHotelMeals {
    
    private $db = NULL;
    
    public $intId = 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 getMealTypes() {
        $sql =" SELECT * from TB_Master_Accom_MealType where IsActive = 1 ORDER BY Title ";
        return $this->db->query($sql)->fetchAll();
    }
	public function getMealName($MealTypeId) {
		$select = $this->db->select();
            $selectarray = array('MealTypeId','Title');
            $select->from(array('tb1' => "TB_Master_Accom_MealType"), $selectarray);
            $select->where("tb1.MealTypeId =?", $MealTypeId);
            $result = $this->db->fetchRow($select);
        return $result['Title'];
    }
    
    
    
}