<?php
/**
 * Class            Rating  Model
 * Description 		This model class contains the functions needed for manipulation of Rating.
 * @name		    Travel_Model_TblRating  Model
 * @author		    Shailender Joshi
 * @editor          Shailender Joshi <shailender@catpl.co.in>
 * @version         1.0
 * @copyright       Catabatic Technologies Pvt Ltd
 *
 */

class Travel_Model_TblRating {
    
     
    public $intContSysId   = NULL;
    
    protected $db          = NULL;
    
    public $imageServerUrl = NULL;
    
    public $baseUrl        = NULL;
    
    
     /*  Common to all models */
    public $strCondition  = NULL;
    
    public $deleted = 'N';
    
    public $status = '1';
        
    public $strSelectedView = '';
    
    public $intQueryOffset = 0;
    
    public $intListPerPage = 10;
    
    public $strOrderBy = 'TB_Master_RatingProvider.ProviderId' ;
    
    public $intLoginUserId = NULL;
    
    public $intLoginAgentId = NULL;
    
    
    public $strImageFlag  = NULL;
    
		
    /***************************************/
    
   
    public function __construct(){
      #initialize db adapter
      $this->db = Zend_Db_Table::getDefaultAdapter();
    }
    
    public function __destruct() {
        $this->db->closeConnection(); 
    }
    
        
	public function getRatingListingRecord()
	{
		$sql = " SELECT AAc.ProviderId, AAC.Title, AAC.Icon, AAC.IsActive, TB_Master_Lang.TitleEng as Language  
				 FROM TB_Master_RatingProvider as AAC 
				 INNER JOIN TB_Master_Lang ON TB_Master_Lang.LangSysId = AAC.LangType
				 WHERE AAC.IsMarkForDel =0 " ;
			
			if(!empty($this->searchArr)) {
				//echo "<pre>"; print_r($this->searchArr); die;
				
				if($this->searchArr['Title']!='')
				{
				  $sql .= " AND AAC.Title LIKE '%".$this->searchArr['Title']."%' ";
				}
				if($this->searchArr['languageList']!='')
				{
				  $sql .= " AND AAC.LangType = '".$this->searchArr['languageList']."' ";
				}
				if($this->searchArr['filter1']!='All' && $this->searchArr['filter1']!='')
				{
				  $sql .= " AND AAC.IsActive = '".$this->searchArr['filter1']."' ";
				}
				
			 }
			 
		     $sql .= " ORDER BY AAC.ProviderId DESC ";
			//echo $sql; //die();
			
		$rowset = $this->db->query($sql)->fetchAll();
        return $rowset;
	}
	
	
    # End : functions added by Shailender Joshi on 18 Oct 2016
    
}