<?php

class Travel_Model_TblAccomoImg {
    
    private $db = NULL;
    
    public $intId = NULL;
    
    public $strCondition  = NULL;
    
    public $orderByField = 'AminityId';
    
    public $orderBy      = 'ASC' ;
    
    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 getAccomodationAmenitiesList() {
        $sql = " SELECT AminityId, CatMask, Title, Icon, UpdateDate, CreateDate, IsMarkForDel, IsActive
                 FROM TB_Master_Accom_AccomAminity WHERE 1 = 1 " ;
        
        if(!empty($this->strCondition)) {
            $sql .= $this->strCondition;
        }
        
        
        
        return $this->db->query($sql)->fetchAll();
        
    }
    
    public function getAccomoImage($accomSysId) {
         $sql = " SELECT Img.Details, M.* 
                 FROM TB_IC_Accomdation_Images as Img LEFT JOIN TB_Master_ImageType AS M ON Img.ImgType=M.ImgType
                 WHERE Img.AccomSysId='".$accomSysId."'   AND Img.IsActive = 1 AND Img.IsMarkForDel = 0 AND Img.Details != 'http://www.travelboutiqueonline.com/Images/HotelNA.jpg'" ;
        
//        if(!empty($this->strCondition)) {
//            $sql .= $this->strCondition;
//        }
//        
//        $sql .= " ORDER BY " . $this->orderByField . " " . $this->orderBy ;
//        
        return $this->db->query($sql)->fetchAll();
        
       
        
    }
    public function getImagesByAccomSysIds($accomSysIds) {
         $sql = " SELECT Img.AccomSysId,Img.Details, M.ImgType 
                 FROM TB_IC_Accomdation_Images as Img LEFT JOIN TB_Master_ImageType AS M ON Img.ImgType=M.ImgType
                 WHERE Img.AccomSysId IN ($accomSysIds) AND Img.IsActive = 1 AND Img.IsMarkForDel = 0 AND Img.Details != 'http://www.travelboutiqueonline.com/Images/HotelNA.jpg' order by Img.AccomSysId ASC" ;  
        return $this->db->query($sql)->fetchAll();
        
       
        
    }
    
    

    
   
    
    
}