<?php

class Travel_Model_TblGeneral {
    
    private $db = NULL;
    
    public $intId = NULL;
    
    public $strName = NULL;
    
    public $intCountry = NULL;
    
    public $intState = NULL;
    
    public $intCity = NULL;
    
    public $strAddress1 = NULL;
    
    public $strAddress2 = NULL;
    
    public $intRating  = NULL;
    
    public $location = NULL;
    
    public $description = NULL;
    
    public $postalCode = NULL;
    
    public $services = NULL;
    
    public $strHotelImage = NULL;
    
    public $isBackend = 'Y';
    
     /*  Common to all models */
    public $strCondition  = NULL;
    
    public $deleted = 'N';
    
    public $status = '1';
        
    public $strSelectedView = '';
    
    public $intQueryOffset = 0;
    
    public $intListPerPage = 10;
    
    public $strOrderBy = 'hotel_name' ;
    
    public $isVerified = 'Y';
    public $baseUrl;
    
    /***************************************/
    
    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 getMarketPlaces() {
        $sql = " SELECT MPType, Title, Details FROM TB_MASTER_MPType " ;
        return $this->db->query($sql)->fetchAll();
    }
    
    
    
    
    
}