<?php
/**
 * Class City
 *
 * @name		City
 * @author		Ravi Khare
 * @editor		Ranvir Singh
 * @created		13 Sep 2016
 * @updateed		08 Jan 2018 by Md sabir
 * @version 	1.0
 * @copyright 	Catabatic India Pvt Ltd
 * Handle City Related function for Front end only
 *
 */

class Admin_StateController extends Catabatic_ValidateAdmin {
    
    public $imageUrl = NULL;
    
    public $baseUrl = '';
    
    public $tablename   = '';
    public $cityMdl     = '';
    
    public $per_page_record = GRID_PER_PAGE_RECORD_COUNT;


    public function init() {
        parent::init();
        $request = Zend_Controller_Front::getInstance()->getRequest();
        $this->baseUrl = $request->getScheme() . '://' . $request->getHttpHost();

        $this->cityModal = new Travel_Model_TblCity();
        $this->stateMdl = new Travel_Model_TblState();
		
		$this->GeneralFunction_Modal = new Travel_Model_GeneralFunction();  // Make object of generel function class
        
        $this->tablename    = 'TB_Master_Geo_State';
        
        $sessionLogin_user  = new Zend_Session_Namespace('sessionLogin_user');
        $this->intLoggedinUserId            = $sessionLogin_user->intLoggedinUserId;
        $this->intLoggedinUserAgencySysId   = $sessionLogin_user->intLoggedinUserAgencySysId;
        
        
        
        $this->imageUrl = $this->baseUrl."/public/upload/city/";
        
    }
    
     public function indexAction()
    {
        $this->view->messages = $this->_helper->flashMessenger->getMessages();
		
        // get country list array
        $objCountry = new Travel_Model_TblCountry();
        $this->view->countrylist = $objCountry->getCountryList();
		
        // display flash msg 
        $this->view->messages = $this->_helper->flashMessenger->getMessages(); 


        //Start Search Code
        $searchArr = array();
        $getData = array();
		  
        if($this->getRequest()->isPost())
        {
            $getData = $this->getRequest()->getPost();
            
            if(!empty($getData))
            {
                $dateFrom       = (@$getData['dateFrom']!='')         ? @$getData['dateFrom']       : '';
                $dateTo         = (@$getData['dateTo']!='')           ? $this->_helper->general->plusOneDay(@$getData['dateTo'])  : '';   // add one day extra while fetching result date results
                $code           = (@$getData['code']!='')             ? @$getData['code']           : '';
                $country_id     = (@$getData['country_id']!=0)        ? @$getData['country_id']     : '';
                $region     = (@$getData['region']!='')      ? @$getData['region']   : '';
                $stateName      = (@$getData['stateName']!='')       ? @$getData['stateName']       : '';
                $filter1        = (@$getData['filter1']!='All')       ? @$getData['filter1']        : '';    // status part
                $filter2        = (@$getData['filter2']!='All')       ? @$getData['filter2']        : '';    // verified part
               
                $searchArr = array(
                 'dateFrom' => $dateFrom,
                 'dateTo'   => $dateTo,
                 'code'     => $code,
                 'region'   => $region,
                 'stateName' => $stateName,
                 'countryId'=> $country_id,
                 'filter1'  => $filter1,
                 'filter2'  => $filter2
                            
               );
			  // print_r($getData);
                    } 
		} 
		else
		{
				
                    $dateFrom   = $this->_getParam('dateFrom');
                    $dateTo     = $this->_getParam('dateTo');
                    $code       = $this->_getParam('code');
                    $region     = $this->_getParam('region');
                    $stateName  = $this->_getParam('stateName');   // _getParam( $searchArr('Key') );
                    $country_id = $this->_getParam('countryId');
                    $filter1    = $this->_getParam('filter1');
                    $filter2    = $this->_getParam('filter2');

                    $dateFrom   = (@$dateFrom!='') ? $dateFrom : '';
                    $dateTo     = (@$dateTo!='') ? $dateTo : '';
                    $code       = (@$code!='') ? $code : '';
                    $stateName  = (@$stateName!='') ? $stateName : '';
                    $country_id = (@$country_id!=0) ? $country_id : '';
                    $filter1    = (@$filter1!='All') ? $filter1 : '';
                    $filter2    = (@$filter2!='All') ? $filter2 : '';

                    $searchArr = array(
                        'dateFrom' => $dateFrom,
                        'dateTo'   => $dateTo,
                        'code'     => $code,
                        'region'   => $region,
                        'stateName' => $stateName,
                        'countryId'=> $country_id,
                        'filter1'  => $filter1,
                        'filter2'  => $filter2

                    );
			
			//print_r($searchArr);
				
		}
        //print_r($searchArr);
        $this->stateMdl->searchArr = $searchArr; // send Array - searchArr() to modal just for pagination
        $this->view->searchArr = $searchArr;	
		
	$this->view->regionlist = $this->GeneralFunction_Modal->getRecordListingWhere('TB_Master_Geo_Region',array('RegId','Title'), array('IsMarkForDel'=>0),'Title');	
		// pagination start
        $page = $this->_request->getParam('page',1); //get curent page param, default 1 if param not available.

        $data = $this->stateMdl->getStateListingRecord();
       
        // get all cities
	$resultSet = array();
        foreach($data as $key =>$val){
           $resultSet[$val['StateId']]['StateId'] =  $val['StateId'];
           $resultSet[$val['StateId']]['Country'] =  $val['Country'];
           $resultSet[$val['StateId']]['IsMarkForDelete'] =  $val['IsMarkForDelete'];
           $resultSet[$val['StateId']]['IsActive'] =  $val['IsActive'];
           $resultSet[$val['StateId']]['PIN'] =  $val['PIN'];
           $resultSet[$val['StateId']]['Code'] =  $val['Code'];
           $resultSet[$val['StateId']]['Title'] =  $val['Title'];
           $resultSet[$val['StateId']]['ContSysId'] =  $val['ContSysId'];
           $resultSet[$val['StateId']]['RegionId'] =  $val['RegionId'];
           $resultSet[$val['StateId']]['RegionName'][] =  $val['RegionName'];
           $resultSet[$val['StateId']]['IsApprove'] =  $val['IsApprove'];
           $resultSet[$val['StateId']]['UpdateDate'] =  $val['UpdateDate'];
           $resultSet[$val['StateId']]['CreateDate'] =  $val['CreateDate'];
        }
        
        // echo "<pre>";print_r($resultSet);exit;
        //echo "<pre>";print_r($data);exit;
        
        
        $page=$this->_getParam('page',1);
        $paginator = Zend_Paginator::factory($resultSet);      
        $paginator->setCurrentPageNumber($this->getRequest()->getParam('page')); // page number
        $perPage = $paginator->setItemCountPerPage(20); // number of items to show per page
        $this->view->paginator = $paginator;
        $this->view->totalrec = $paginator->getTotalItemCount();
        $this->view->currentPage = $this->_getParam('page');
		
		
    }
    
    
    public function addAction()
    {
        
        $form = new Travel_Form_States();
        $form->setAction($this->baseUrl."/admin/state/add")->setMethod("POST")->setName("addStateForm");
        $this->view->form = $form;
        
        if ($this->getRequest()->isPost()) {
            $post = $this->getRequest()->getPost();
            if ($form->isValid($post)) {
                try 
                {

                    $addState = array(
                            'Title'=> trim($this->sanitize_data($post['Title'])),
                            'Code'=> trim($this->sanitize_data($post['Code'])),
                            'ContSysId'=> trim($this->sanitize_data($post['countryId'])),
                            'RegionId'=> trim($this->sanitize_data($post['regionList'])),
                            'CreateDate'=> date('Y-m-d H:i:s'),
                            'UpdateDate'=> '',
                            'PIN'=> 0,
                            'IsApprove'=> 0,
                            'IsActive'=> 1,
                            'IsMarkForDelete'=> 0,
                       );
                    //print_r($post);die;
                    // check state name already exists or not ( Avoid duplicate state entry)
                    if(trim($this->sanitize_data($post['Title']))!=''){
                        $stateName    = $this->GeneralFunction_Modal->getRecordListingWhere($this->tablename, array('Title'), array('Title'=>$addState['Title']),'Title');
                    }
                    //print_r($stateName); echo count($stateName);
                    if(count($stateName)>=1){
                        $this->view->eMsg = "State name already exists.";
                    } 
                    else
                    {
                        $isinserted = $this->GeneralFunction_Modal->insertTable($this->tablename, $addState); 
                        if($isinserted) {
                            $this->_helper->flashMessenger->addMessage("Record inserted successfully.");
                            $this->_redirect("admin/state/index");
                        }

                    }
                }
                catch (Zend_Form_Exception $e) {
                        $this->view->error_msg  = $e->getMessage();
                }                    

            }

        }
        $this->view->others   = array('baseUrl' => $this->baseUrl, 'action_name'=> 'add');
        $this->view->messages = $this->_helper->flashMessenger->getMessages();
        
    }
    
    
    public function editAction()
    {
        
        $encodeId   = ($this->getRequest()->getParam('id'));
        $intId      = (int)base64_decode($encodeId);

        //$this->_helper->viewRenderer("places-to-eat-new");
        
       if(!empty($intId) || !is_int($intId) )
        {
            
            # get listings of place to eat
            $colsArr    = array('*');
            $resultset  = $this->GeneralFunction_Modal->getDetailsByUniqueId('TB_Master_Geo_State', $colsArr, 'StateId', $intId);

            $form = new Travel_Form_States();
        
            $form->setMethod("POST")->setName("editStateForm");

            $editdata = array(
                'Title'=> $resultset['Title'],
                'countryId'=> $resultset['ContSysId'],
                'Code'=> $resultset['Code'],
                'regionList'=> $resultset['RegionId'],
                'IsApprove'=> $resultset['IsApprove'],
                'IsActive'=> $resultset['IsActive'],
            );

            $form->populate($editdata);
            $this->view->form = $form;
            if ($this->getRequest()->isPost()) {
                $post = $this->getRequest()->getPost();
                if ($form->isValid($post)) {

                   try {
                        $editStateData = array(
                            'Title'=> trim($this->sanitize_data($post['Title'])),
                            'Code'=> trim($this->sanitize_data($post['Code'])),
                            'ContSysId'=> trim($this->sanitize_data($post['countryId'])),
                            'RegionId'=> trim($this->sanitize_data($post['regionList'])),
                            'UpdateDate'=> date('Y-m-d H:i:s'),
                            'IsApprove'=> 1,
                            'IsActive'=> 1,
                        );

                        $tablename  = 'TB_Master_Geo_State';
                        $where      = array('StateId =?'=> $intId);
                        $this->GeneralFunction_Modal->updateTable($tablename, $editStateData, $where);
						
                        $this->_helper->flashMessenger->addMessage("Record updated successfully");
                        $this->_redirect("admin/state");
                        
                    }
                    catch (Zend_Form_Exception $e) {
                        $this->view->error_msg  = $e->getMessage();
                    } 
                    
                }
            }
            $this->view->regionlist = $this->GeneralFunction_Modal->getRecordListingWhere('TB_Master_Geo_Region',array('RegId','Title'), array('IsMarkForDel'=>0),'Title');
            $this->view->others         = array('baseUrl' => $this->baseUrl, 'action_name'=> 'places-to-eat');
            $this->view->resultset      = $resultset;
            $this->view->messages = $this->_helper->flashMessenger->getMessages();

        }
        
    }
    
    
    public function deleteStateAction()
    {
        /* Disable Layout & set Render False */
        $this->_helper->layout->disableLayout();
        $this->_helper->viewRenderer->setNoRender(true);

        $StateId  = base64_decode( $this->getRequest()->getParam('id'));
        $currentPage  = base64_decode( $this->getRequest()->getParam('page'));

        if($StateId) {
            $editData['IsMarkForDelete']  = 1;           
            $tablename  = "TB_Master_Geo_State";
            $where      = array('StateId =?'=> $StateId);
            $isupdated  = $this->GeneralFunction_Modal->updateTable($this->tablename, $editData, $where);
            if($isupdated)
            {
                $this->_helper->flashMessenger->addMessage("Record Deleted successfully.");
                $this->_redirect("admin/state/index/page/$currentPage");
            }
        }
        else {
            $this->_redirect("admin/state/index/page/$currentPage");
         }   
        
    }
	
	public function filterStatusAction()
    {
        /* Disable Layout & set Render False */
        $this->_helper->layout->disableLayout();
        $this->_helper->viewRenderer->setNoRender(true);

        $filter  = $this->getRequest()->getParam('filter');
        $val     = $this->getRequest()->getParam('val');
        $StateId  = base64_decode( $this->getRequest()->getParam('id'));
        $currentPage  = base64_decode( $this->getRequest()->getParam('page'));

        if($StateId && $filter) {
            if($filter == 'filter1'){
                $editData['IsActive']  = ($val == 0) ? 1 : 0;           
            }
            if($filter == 'filter2'){
                $editData['IsApprove']  = ($val == 0) ? 1 : 0;                
            }	
            $tablename  = "TB_Master_Geo_State";
            $where      = array('StateId =?'=> $StateId);
            $isupdated  = $this->GeneralFunction_Modal->updateTable($this->tablename, $editData, $where);
            if($isupdated)
            {
                $this->_helper->flashMessenger->addMessage("Record Update successfully.");
                $this->_redirect("admin/state/index/page/$currentPage");
            }
        }
        else {
            $this->_redirect("admin/state/index/page/$currentPage");
         }   
        
    }
    
}