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

class CountryController extends Zend_Controller_Action {
    
    public $imageUrl = NULL;
    
    public $baseUrl = '';
    
    public $tablename   = '';
    public $current_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->current_Modal = new Travel_Model_TblCountry();
		
		$this->GeneralFunction_Modal = new Travel_Model_GeneralFunction();  // Make object of generel function class
                
        $this->tablename    = 'TB_Master_Geo_Country';
        
        $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/');
        }
        
        $this->imageUrl = $this->baseUrl."/public/upload/country/";
        
    }
    
     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']    : '';
				$Code       = (@$getData['Code']!='')        ? @$getData['Code']     : '';
				$region     = (@$getData['region']!='')      ? @$getData['region']   : '';
				$continent  = (@$getData['continent']!='')   ? @$getData['continent']: '';
				$filter1    = (@$getData['filter1']!='All')  ? @$getData['filter1']  : '';    // status part
				$filter2    = (@$getData['filter2']!='All')  ? @$getData['filter2']  : '';    // verified part
				
               
			   $searchArr = array(
                            'Title'    => $Title,
							'Code'     => $Code,
							'region'   => $region,
							'continent'=> $continent,
							'filter1'  => $filter1,
							'filter2'  => $filter2,
							);
			  // print_r($getData);
			} 
		} 
		else
		{
				
			$Title      = $this->_getParam('Title');
			$Code       = $this->_getParam('Code');
			$region     = $this->_getParam('region');
			$continent  = $this->_getParam('continent');
			$filter1    = $this->_getParam('filter1');
			$filter2    = $this->_getParam('filter2');
							 
			
			$filter1    = (@$filter1!='All') ? $filter1 : '';
			$filter2    = (@$filter2!='All') ? $filter2 : '';
						
			$searchArr = array(
                            'Title'    => $Title,
							'Code'     => $Code,
							'region'   => $region,
							'continent'=> $continent,
							'filter1'  => $filter1,
							'filter2'  => $filter2
							);
			
			//print_r($searchArr);
				
		}
			//print_r($searchArr);
			$this->current_Modal->searchArr = $searchArr; // send Array - searchArr() to modal just for pagination
			$this->view->searchArr = $searchArr;

			// get Region list array
			$this->view->regionlist = $this->GeneralFunction_Modal->getRecordListingWhere('TB_Master_Geo_Region',array('RegId','Title'), array('IsMarkForDel'=>0),'Title');
			
			// get Continent list array
			$this->view->continentlist = $this->GeneralFunction_Modal->getRecordListingWhere('TB_Master_Geo_Continent',array('ContiSysId','Title'), array('IsMarkForDelete'=>0),'Title');
		
		
		// pagination start
		$page = $this->_request->getParam('page',1); //get curent page param, default 1 if param not available.
		
		$data = $this->current_Modal->getCountryListingRecord(); // get all getHotelAmenityCategory
				
		$page=$this->_getParam('page',1);
        $paginator = Zend_Paginator::factory($data);      
        $paginator->setCurrentPageNumber($this->getRequest()->getParam('page')); // page number
        $perPage = $paginator->setItemCountPerPage($this->per_page_record); // 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_Country();
        $form->setAction($this->baseUrl."/country/add")->setMethod("POST")->setName("addCountryForm");
        $this->view->form = $form;
            
            
		if ($this->getRequest()->isPost()) {

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

			if ($form->isValid($post)) {
				
				try 
				{
						$addData = array(
							 'RegionId'    => $post['regionList'],
							 'Continent'   => $post['continentList'],
							 'Title'       => $post['Title'],
							 'Code'        => $post['Code'],
							 'PhoneCode'   => $post['PhoneCode'],
							 'TimeZoneUTC' => $post['TimeZone'],
							 'Synonyms'    => $post['Synonyms'],
							 'CreateDate'  => date('Y-m-d h:i:s'),
							 'IsApprove'   => 0,
							 'IsActive'    => 1,
							 'IsMarkForDel'=> 0,
						   );
						
											  
						// check Same Title name already exists or not ( Avoid duplicate hotel Amenity Category entry)
						if($post['Title']!='' && $post['Code']!=''){
							$entryDate   = $this->GeneralFunction_Modal->getRecordListingWhere($this->tablename, array('Title'), array('Title'=>$addData['Title'], 'Code'=>$addData['Code']));
						}
						//print_r($entryDate); echo count($entryDate);
						if(count($entryDate)>=1){
							$this->view->eMsg = "Country already exists.";
							
						} 
						else
						{
							$isinserted = $this->GeneralFunction_Modal->insertTable($this->tablename, $addData); 
							if($isinserted) {
									$this->_helper->flashMessenger->addMessage("Record added successfully");
								$this->_redirect("country");
							}
							
						}
				}
				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 countrys
            $colsArr    = array('*');
            $resultset  = $this->GeneralFunction_Modal->getDetailsByUniqueId($this->tablename, $colsArr, 'ContId', $intId);

            $form = new Travel_Form_Country();
			$form->setMethod("POST")->setName("editCountryForm");

            $editFormdata = array(
							 'regionList'  => $resultset['RegionId'],
							 'continentList'=> $resultset['Continent'],
							 'Title'       => $resultset['Title'],
							 'Code'        => $resultset['Code'],
							 'PhoneCode'   => $resultset['PhoneCode'],
							 'TimeZone' => $resultset['TimeZoneUTC'],
							 'Synonyms'    => $resultset['Synonyms'],
							 
							);

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

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

					if ($form->isValid($post)) {
						
						try {
							    $editData = array(
									 'RegionId'    => $post['regionList'],
									 'Continent'   => $post['continentList'],
									 'Title'       => $post['Title'],
									 'Code'        => $post['Code'],
									 'PhoneCode'   => $post['PhoneCode'],
									 'TimeZoneUTC' => $post['TimeZone'],
									 'Synonyms'    => $post['Synonyms'],
									 'UpdateDate'  => date('Y-m-d h:i:s'),
									);

							
							$where  = array('ContId =?'=> $intId);
							$this->GeneralFunction_Modal->updateTable($this->tablename, $editData, $where);
							
							$this->_helper->flashMessenger->addMessage("Record updated successfully");
							$this->_redirect("country/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 deleteAction()
    {
        /* 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('ContId =?'=> $id);
			$isupdated  = $this->GeneralFunction_Modal->updateTable($this->tablename, $editData, $where);
			if($isupdated)
				{
					$this->_helper->flashMessenger->addMessage("Record Deleted successfully.");
					$this->_redirect("country/index/page/$currentPage");
				}
        }
        else {
                $this->_redirect("country/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 == 0) ? '' : date('Y-m-d h:i:s'); 	
			}	
			
			$where      = array('ContId =?'=> $id);
			$isupdated  = $this->GeneralFunction_Modal->updateTable($this->tablename, $editData, $where);
			if($isupdated)
				{
					$this->_helper->flashMessenger->addMessage("Record Update successfully.");
					$this->_redirect("country/index/page/$currentPage");
				}
        }
        else {
                $this->_redirect("country/index/page/$currentPage");
         }   
        
    }
    
}