<?php

/***************************************************************
 * Catabatic Technology Pvt. Ltd.
 * File Name : Menu.php
 * File Description : Menu Model for managed all menus
 * Created By : Prashant Kumar
 * Created Date: 18-September-2014
 ***************************************************************/

class Application_Model_Locate extends Zend_Db_Table_Abstract
{
    function __construct() 
    { 	  
        
    }
       
    /**
    * getAllStateList() method is used to get state list
    * @param email string
    * @return object 
    */	
    public function getAllStateList()
    {   
        $db = Zend_Db_Table::getDefaultAdapter(); 
        $select = $db->select()
                     ->from('tbl_states', array('id','state_name'))
                     ->where('status =?','Activate')
                     ->order('state_name');
        $result = $db->fetchAll($select);
        return $result;
    }
    
    
    /**
    * getAllBranchCityListByStateId() method is used to get branch city list by state id
    * @param email string
    * @return object 
    */	
    public function getAllBranchCityListByStateId($bsid,$type)
    {   
        $db = Zend_Db_Table::getDefaultAdapter(); 
        $select = $db->select()
                     ->from(array("br"=>"tbl_branches"))
                     ->join(array('ct'=>'tbl_city'),'br.city_id=ct.id',array('ct.id','ct.city_name'))
                     ->where('br.state_id =?',$bsid)
                     ->where('br.state_id =?',$bsid)
                     ->where('ct.status =?','Activate')
                     ->group('br.city_id')
                     ->order('ct.city_name');
        $result = $db->fetchAll($select);
        return $result;
    }
    
    
    /**
    * getAllBranchListByCityId() method is used to get branch list by city id
    * @param email string
    * @return object 
    */	
    public function getAllBranchListByCityId($brchid,$type)
    {   
        $db = Zend_Db_Table::getDefaultAdapter(); 
        $select = $db->select()
                     ->from('tbl_branches', array('id','location'))
                     ->where('status =?','Activate')
                     ->where('type =?',$type)
                     ->where('city_id =?',$brchid)
                     ->order('location');
        $result = $db->fetchAll($select);
        return $result;
    }
    
    
    /**
    * getAllBranchAtmListById() method is used to get branch list by city id
    * @param email string
    * @return object 
    */	
    public function getAllBranchAtmListById($type,$type_val)
    {   
        $db = Zend_Db_Table::getDefaultAdapter(); 
        $select = $db->select()
                     ->from('tbl_branches', array('id','branch_head','location','nearby_milestone','address1','address2','pin_code','ifs_code','telephone_no','telephone_no2','telephone_no3','telephone_no4','telephone_no5','branch_atm','branch_locker','branch_timing_monday_to_friday','branch_timing_saturday','atm_id','atm_timing'))
                     ->where('status =?','Activate')
                     ->where('type =?',$type)
                     ->where('id =?',$type_val);
        $result = $db->fetchRow($select);
        return $result;
    }
    
    
    /**
    * getAllLocationBranchAtmListById() method is used to get branch list by city id
    * @param email string
    * @return object 
    */	
    public function getAllLocationBranchAtmListById($type,$type_val)
    {   
        $db = Zend_Db_Table::getDefaultAdapter(); 
        $select = $db->select()
                     ->from('tbl_branches', array('id','branch_head','location','nearby_milestone','address1','address2','pin_code','ifs_code','telephone_no','telephone_no2','telephone_no3','telephone_no4','telephone_no5','branch_atm','branch_locker','branch_timing_monday_to_friday','branch_timing_saturday','atm_id','atm_timing'))
                     ->where('status =?','Activate')
                     ->where('type =?',$type)
                     ->where('location_id =?',$type_val);
        $result = $db->fetchAll($select);
        return $result;
    }
    
    
    /**
    * getAllBranchStateList() method is used to get all quick or tiled menu list
    * @param email string
    * @return object
    */
    public function getAllBranchStateList($type)
    {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                     ->from(array("br"=>"tbl_branches"), array('br.state_id'))
                     ->join(array('st'=>'tbl_states'),'br.state_id=st.id',array('st.id','st.state_name'))
                     ->where('br.type =?',$type)
                     ->group('br.state_id')
                     ->order('st.state_name');
        $result = $db->fetchAll($select);
        return $result;
    }
    
    
    /**
    * getAllLocationListByCityId() method is used to get branch list by city id
    * @param email string
    * @return object 
    */	
    public function getAllLocationListByCityId($brchid)
    {   
        $db = Zend_Db_Table::getDefaultAdapter(); 
        $select = $db->select()
                     ->from('tbl_location', array('id','location_name'))
                     ->where('status =?','Activate')
                     ->where('city_id =?',$brchid)
                     ->order('location_name'); 
        $result = $db->fetchAll($select);
        return $result;
    }
    
}