<?php
/**
 * Class Region
 *
 * @name		Region
 * @author		Shailender Joshi
 * @editor		Shailender Joshi
 * @created		19 Oct 2016
 * @updateed    19 ct 2016
 * @version 	1.0
 * @copyright 	Catabatic India Pvt Ltd
 * Handle Region  Related function for Front end only
 *
 */

class RegionController extends Zend_Controller_Action {
    
    public $imageUrl = NULL;
    
    public $baseUrl = '';
    
    public $tablename   = '';
    public $HAC_Modal     = '';
    
    public $per_page_record = GRID_PER_PAGE_RECORD_COUNT;


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

        $this->HAC_Modal = new Travel_Model_TblRegion();
                
        $this->tablename    = 'TB_Master_Geo_Region';
        
        $sessionLogin_user  = new Zend_Session_Namespace('sessionLogin_user');
        $this->intLoggedinUserId            = $sessionLogin_user->intLoggedinUserId;
        $this->intLoggedinUserAgencySysId   = $sessionLogin_user->intLoggedinUserAgencySysId;
        
        if(empty($this->intLoggedinUserId)) {
            $this->_redirect('/login/');
        }
        
                
    }
    
     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->getRegionListingRecord(); // get all Region
				
		$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_Region();
        $form->setAction($this->baseUrl."/region/add")->setMethod("POST")->setName("addRegionForm");
        $this->view->form = $form;
            
            
		if ($this->getRequest()->isPost()) {

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

			if ($form->isValid($post)) {
				
				try 
				{
						$addData = array(
							 'Title'=> $post['Title'],
							 'Code'=> $post['Code'],
							 'CreateDate'=> date('Y-m-d h:i:s'),
							 'UpdateDate'=> '',
							 'IsActive'=> 1,
							 'IsMarkForDel'=> 0,
						   );
						
						
						// check Same Title name already exists or not ( Avoid duplicate Season entry)
						if($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 = "Region already exists.";
							
						} 
						else
						{
							$isinserted = $this->HAC_Modal->insertTable($this->tablename, $addData); 
							if($isinserted) {
								$this->_helper->flashMessenger->addMessage("Record added successfully");
								$this->_redirect("region");
							}
							
						}
				}
				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, 'RegId', $intId);

            $form = new Travel_Form_Region();
			$form->setMethod("POST")->setName("editRegionForm");

            $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'=> $post['Title'],
									 'Code'=> $post['Code'],
									 'UpdateDate'=> date('Y-m-d h:i:s')
									);

							
							$where  = array('RegId =?'=> $intId);
							$this->HAC_Modal->updateTable($this->tablename, $editData, $where);
							
							$this->_helper->flashMessenger->addMessage("Record updated successfully");
							$this->_redirect("region/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 deleteRegionAction()
    {
        /* 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['IsMarkForDel']  = 1;           
			$where      = array('RegId =?'=> $id);
			$isupdated  = $this->HAC_Modal->updateTable($this->tablename, $editData, $where);
			if($isupdated)
				{
					$this->_helper->flashMessenger->addMessage("Record Deleted successfully.");
					$this->_redirect("region/index/page/$currentPage");
				}
        }
        else {
                $this->_redirect("region/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('RegId =?'=> $id);
			$isupdated  = $this->HAC_Modal->updateTable($this->tablename, $editData, $where);
			if($isupdated)
				{
					$this->_helper->flashMessenger->addMessage("Record Update successfully.");
					$this->_redirect("region/index/page/$currentPage");
				}
        }
        else {
                $this->_redirect("region/index/page/$currentPage");
         }   
        
    }
    
}