<?php
/**
 * Class Zone
 *
 * @name		Zone
 * @author		Shailender Joshi
 * @editor		Shailender Joshi
 * @created		19 Oct 2016
 * @updateed    08 Jan 2018 by Md sabir
 * @version 	1.0
 * @copyright 	Catabatic India Pvt Ltd
 * Handle Zone  Related function for Front end only
 *
 */

class Admin_ZoneController extends Catabatic_ValidateAdmin {
    
    public $imageUrl = NULL;
    
    public $baseUrl = '';
    
    public $tablename   = '';
    public $HAC_Modal     = '';
    
    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->HAC_Modal = new Travel_Model_TblZone();
                
        $this->tablename    = 'TB_Master_Geo_Zone';
        
        $sessionLogin_user  = new Zend_Session_Namespace('sessionLogin_user');
        $this->intLoggedinUserId            = $sessionLogin_user->intLoggedinUserId;
        $this->intLoggedinUserAgencySysId   = $sessionLogin_user->intLoggedinUserAgencySysId;
        
                       
    }
    
     public function indexAction()
    {
        $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))
            {
                $Title    = (@$getData['Title']!='') ? @$getData['Title']: '';
                $filter1  = (@$getData['filter1']!='All') ? @$getData['filter1']: '';    // status part
				
                $searchArr = array(
                 'Title'    => $Title,
                 'filter1'  => $filter1
                 );
                 // print_r($getData);
             } 
        } 
        else
        {
            $Title      = ( $this->_getParam('Title') != '' ) ? $this->_getParam('Title') : '';
            $filter1    = ( $this->_getParam('filter1') != 'All' ) ? $this->_getParam('filter1') : '';

            $searchArr = array(
                'Title'    => $Title,
                'filter1'  => $filter1
            );
            //print_r($searchArr);
        }	
        
        //print_r($searchArr);
        $this->HAC_Modal->searchArr = $searchArr; // send Array - searchArr() to modal just for pagination
        $this->view->searchArr = $searchArr;	


       // pagination start
        $page = $this->_request->getParam('page',1); //get curent page param, default 1 if param not available.

        $data = $this->HAC_Modal->getZoneListingRecord(); // get all Zone

        $page=$this->_getParam('page',1);
        $paginator = Zend_Paginator::factory($data);      
        $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_Zone();
        $form->setAction($this->baseUrl."/admin/zone/add")->setMethod("POST")->setName("addZoneForm");
        $this->view->form = $form;
            
            
		if ($this->getRequest()->isPost()) {

                    $post = $this->getRequest()->getPost();

                    if ($form->isValid($post)) {

                        try 
                        {
                            $addData = array(
                                'Title'=> trim($this->sanitize_data($post['Title'])),
                                'Code'=> trim($this->sanitize_data($post['Code'])),
                                'CreateDate'=> date('Y-m-d h:i:s'),
                                'UpdateDate'=> '',
                                'IsActive'=> 1,
                                'IsMarkForDelete'=> 0,
                            );


                            // check Same Title name already exists or not ( Avoid duplicate Season entry)
                            if(trim($this->sanitize_data($post['Title']))!=''){
                                $entryData   = $this->HAC_Modal->getRecordListingWhere($this->tablename, array('Title'), array('Title'=>$addData['Title']));
                            }
                            //print_r($entryDate); echo count($entryData);
                            if(count($entryData)>=1){
                                $this->view->eMsg = "Zone already exists.";

                            } 
                            else
                            {
                                $isinserted = $this->HAC_Modal->insertTable($this->tablename, $addData); 
                                if($isinserted) {
                                    $this->_helper->flashMessenger->addMessage("Record added successfully");
                                    $this->_redirect("admin/zone");
                                }

                            }
                        }
                        catch (Zend_file_transfer_exeception $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);
        $page       = $this->getRequest()->getParam('page');
                
       if(!empty($intId) || !is_int($intId) )
        {
            
            # get listings of season
            $colsArr    = array('*');
            $resultset  = $this->HAC_Modal->getDetailsByUniqueId($this->tablename, $colsArr, 'ZoneId', $intId);

            $form = new Travel_Form_Zone();
            $form->setMethod("POST")->setName("editZoneForm");

            $editFormdata = array(
            'Title'      => $resultset['Title'],
            'Code'       => $resultset['Code'],
            );

            $form->populate($editFormdata);
        
            $this->view->form = $form;
            if ($this->getRequest()->isPost()) {

                $post = $this->getRequest()->getPost();
                if ($form->isValid($post)) {
                    try {
                        $editData = array(
                            'Title'=> trim($this->sanitize_data($post['Title'])),
                            'Code'=> trim($this->sanitize_data($post['Code'])),
                            'UpdateDate'=> date('Y-m-d h:i:s')
                        );
                        $where  = array('ZoneId =?'=> $intId);
                        $this->HAC_Modal->updateTable($this->tablename, $editData, $where);

                        $this->_helper->flashMessenger->addMessage("Record updated successfully");
                        $this->_redirect("admin/zone/index/page/$page");

                    }
                    catch (Zend_Form_Exception $e) {
                        $this->view->error_msg  = $e->getMessage();
                    } 
                    
                }
            }
            $this->view->resultset  = $resultset;
            $this->view->messages = $this->_helper->flashMessenger->getMessages();

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

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

        if($id) {
            $editData['IsMarkForDelete']  = 1;           
            $where      = array('ZoneId =?'=> $id);
            $isupdated  = $this->HAC_Modal->updateTable($this->tablename, $editData, $where);
            if($isupdated)
            {
                $this->_helper->flashMessenger->addMessage("Record Deleted successfully.");
                $this->_redirect("admin/zone/index/page/$currentPage");
            }
        }
        else {
                $this->_redirect("admin/zone/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');
        $id      = base64_decode( $this->getRequest()->getParam('id'));
        $currentPage  =  $this->getRequest()->getParam('page');

        if($id && $filter) {
            if($filter == 'filter1'){
                $editData['IsActive']  = ($val == 0) ? 1 : 0;           
            }
            if($filter == 'filter2'){
                $editData['IsApprove']    = ($val == 0) ? 1 : 0;   
                $editData['ApproveDate']  = ($val == 1) ? date('Y-m-d h:i:s') : '';   				
            }	

            $where      = array('ZoneId =?'=> $id);
            $isupdated  = $this->HAC_Modal->updateTable($this->tablename, $editData, $where);
            if($isupdated)
            {
                $this->_helper->flashMessenger->addMessage("Record Update successfully.");
                $this->_redirect("admin/zone/index/page/$currentPage");
            }
        }
        else {
            $this->_redirect("admin/zone/index/page/$currentPage");
         }   
        
    }
    
}