<?php

/***************************************************************
 * Catabatic Technology Pvt. Ltd.
 * File Name : Slider.php
 * File Description : Slider Model
 * Created By : Praveen Kumar
 * Created Date: 05-September-2014
 ***************************************************************/

class Application_Model_State extends Zend_Db_Table_Abstract
{
    function __construct() 
    { 	  
        
    }
    
   
    /**
    * getAllActiveStatesList() method is used to get all active states list
    * @param email string
    * @return object 
    */	
    public function getAllActiveStatesList()
    {   
        $dbtable = new Zend_Db_Table('tbl_states');
        $select = $dbtable->select()
                          ->where('status =?','Activate')          
                          ->order('state_name');
        $result = $dbtable->fetchAll($select);
        return $result;
    }
  
    /**
    * getAllActiveCityList() method is used to get all active states list
    * @param email string
    * @return object 
    */	
    public function getAllActiveCityList()
    {   
        $dbtable = new Zend_Db_Table('tbl_city');
        $select = $dbtable->select()
                          ->where('status =?','Activate')          
                          ->order('city_name');
        $result = $dbtable->fetchAll($select);
        return $result;
    }
    
    /**
    * getAllCityListByStateId() method is used to get city list by state id
    * @param email string
    * @return object 
    */	
    public function getAllCityListByStateId($state_id)
    {   
        $dbtable = new Zend_Db_Table('tbl_city');
        $select = $dbtable->select()
                          ->where('state_id = ?',$state_id)
                          ->where('status = ?','Activate')
                          ->order('city_name');
        $result = $dbtable->fetchAll($select);
        return $result;
    }
    
    /**
    * getAllActiveCitiesList() method is used to get all active states list
    * @param email string
    * @return object 
    */	
    public function getAllActiveCitiesList()
    {   
        $dbtable = new Zend_Db_Table('tbl_cities');
        $select = $dbtable->select()
                          ->where('status =?','Activate')          
                          ->order('city_name');
        $result = $dbtable->fetchAll($select);
        return $result;
    }
    
    
    /**
    * getAllCitiesListByStateId() method is used to get city list by state id
    * @param email string
    * @return object 
    */	
    public function getAllCitiesListByStateId($state_id)
    {   
        $dbtable = new Zend_Db_Table('tbl_cities');
        $select = $dbtable->select()
                          ->where('state_id = ?',$state_id)
                          ->where('status = ?','Activate')
                          ->order('city_name');
        $result = $dbtable->fetchAll($select);
        return $result;
    }
    
    /**
    * getAllCounytyList() method is used to get all active country list
    * @param NULL
    * @return array 
    */	
    public function getAllCounytyList()
    {   
        $dbtable = new Zend_Db_Table('tbl_countries');
        $select = $dbtable->select()
                          ->where('status =?','Activate')          
                          ->order('Name');
        $result = $dbtable->fetchAll($select);
        return $result;
    }
    
    /**
    * getAllActiveCountryCodeList() method is used to get all active country code list
    * @param NULL
    * @return array 
    */	
    public function getAllActiveCountryCodeList()
    {   
        $dbtable = new Zend_Db_Table('tbl_countries');
        $select = $dbtable->select()
                          ->where('status =?','Activate')  
                          ->where('CountryCode !=?','NULL') 
                          ->where('Code !=?','IND')  
                          ->order('Name');
        $result = $dbtable->fetchAll($select);
        return $result;
    }    
}