<?php

/**
 * Class Airline
 *
 * @name		Airport
 * @author		Shailender Joshi
 * @editor		Shailender Joshi
 * @created		30 Sep 2016
 * @updateed    30 Sep 2016
 * @version 	1.0
 * @copyright 	Catabatic India Pvt Ltd
 * Handle Airport Related function for Front end only
 *
 */
class Admin_AirportController extends Catabatic_ValidateAdmin {

    public $imageUrl = NULL;
    public $baseUrl = '';
    public $tablename = '';
    public $current_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->cityMdl = new Travel_Model_TblCity();
        $this->current_Modal = new Travel_Model_TblAirport();

        $this->tablename = 'TB_Master_Airport';

        $sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
        $this->intLoggedinUserId = $sessionLogin_user->intLoggedinUserId;
        $this->intLoggedinUserAgencySysId = $sessionLogin_user->intLoggedinUserAgencySysId;



        $this->imageUrl = $this->baseUrl . "/public/upload/airport/";
    }

    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'] : '';
                $CityId = (@$getData['cityList'] != '') ? @$getData['cityList'] : '';
                $CountryId = (@$getData['CountryId'] != '') ? @$getData['CountryId'] : '';
                $filter1 = (@$getData['filter1'] != 'All') ? @$getData['filter1'] : '';    // status part


                $searchArr = array(
                    'Title' => $Title,
                    'Code' => $Code,
                    'CityId' => $CityId,
                    'CountryId' => $CountryId,
                    'filter1' => $filter1,
                );
                // print_r($getData);
            }
        } else {

            $Title = $this->_getParam('Title');
            $Code = $this->_getParam('Code');
            $CityId = $this->_getParam('CityId');
            $CountryId = $this->_getParam('CountryId');
            $filter1 = $this->_getParam('filter1');


            $filter1 = (@$filter1 != 'All') ? $filter1 : '';

            $searchArr = array(
                'Title' => $Title,
                'Code' => $Code,
                'CityId' => $CityId,
                'CountryId' => $CountryId,
                'filter1' => $filter1,
            );

            //print_r($searchArr);
        }

        //print_r($searchArr);
        if ($searchArr['CountryId'] != "") {
            $this->view->city_listing = $this->current_Modal->getRecordListingWhere(trim(@$searchArr['CountryId']));
            $this->view->city_selected = @$searchArr['CityId'];
        }

        $this->current_Modal->searchArr = $searchArr; // send Array - searchArr() to modal just for pagination
        $this->view->searchArr = $searchArr;

        // get country list array
        $objCountry = new Travel_Model_TblCountry();
        $this->view->countrylist = $objCountry->getCountryList();

        // get city list array
        $this->view->citylist = $this->cityMdl->getRecordListing('TB_Master_Geo_City', array('CityId', 'Title'), 1, 1, 0, 'Title');


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

        $data = $this->current_Modal->getAirportListingRecord(); // get all getHotelAmenityCategory
        //print_r($data); die;

        $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_Airport();
        $form->setAction($this->baseUrl . "/admin/airport/add")->setMethod("POST")->setName("addAirportForm");
        $this->view->form = $form;


        if ($this->getRequest()->isPost()) {

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

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

                try {
                    $addData = array(
                        'AirportTitle' => trim($this->sanitize_data($post['Title'])),
                        'AirportCode' => trim($this->sanitize_data($post['Code'])),
                        'IATACode' => trim($this->sanitize_data($post['Code'])),
                        'CountrySysId' => trim($this->sanitize_data($post['countryList'])),
                        'CityId' => trim($this->sanitize_data($post['cityList'])),
                        'PlaceOneliner' => '',
                        'ICAO' => '',
                        'GeoLat' => trim($this->sanitize_data($post['Latitude'])),
                        'GeoLong' => trim($this->sanitize_data($post['Longitude'])),
                        'AirportStartDate' => date('Y-m-d h:i:s'),
                        'IsActive' => 1,
                        'IsMarkForDel' => 0
                    );
                    //echo '<pre>';var_dump($addData);die;
                    // check Same Title name already exists or not ( Avoid duplicate entry)
                    if ($post['Title'] != '' && $post['Code'] != '') {
                        $entryData = $this->current_Modal->getRecordListingWhere2($this->tablename, array('AirportTitle'), array('AirportTitle' => $post['Title'], 'AirportCode' => $post['Code']));
                    }
                    //print_r($entryDate); echo count($entryDate);
                    if (count($entryData) >= 1) {
                        $this->view->eMsg = "Airport already exists.";
                    } else {
                        //echo '<pre>';var_dump($addData);die;
                        $isinserted = $this->current_Modal->insertTable($this->tablename, $addData);
                        if ($isinserted) {
                            $this->_helper->flashMessenger->addMessage("Record added successfully");
                            $this->_redirect("admin/airport");
                        }
                    }
                } 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);
        $page = $this->getRequest()->getParam('page');

        if (!empty($intId) || !is_int($intId)) {

            # get listings of airport
            $resultset = $this->current_Modal->getDetailsByUniqueId($intId);

            $form = new Travel_Form_Airport();
            $form->setMethod("POST")->setName("editAirportForm");

            $editFormdata = array(
                'Title' => $resultset['AirportTitle'],
                'Code' => $resultset['AirportCode'],
                'countryList' => trim($resultset['CountrySysId']),
                'Latitude' => $resultset['GeoLat'],
                'Longitude' => $resultset['GeoLong']
            );

            $form->populate($editFormdata);

            $this->view->form = $form;
            // send city list array according to country selected for airport
            $this->view->city_listing = $this->current_Modal->getRecordListingWhere(trim($resultset['CountrySysId']));
            $this->view->city_selected = $resultset['CityId'];

            if ($this->getRequest()->isPost()) {

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

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

                    try {

                        $editData = array(
                            'AirportTitle' => trim($this->sanitize_data($post['Title'])),
                            'AirportCode' => trim($this->sanitize_data($post['Code'])),
                            'CountrySysId' => trim($this->sanitize_data($post['countryList'])),
                            'CityId' => trim($this->sanitize_data($post['cityList'])),
                            'GeoLat' => trim($this->sanitize_data($post['Latitude'])),
                            'GeoLong' => trim($this->sanitize_data($post['Longitude'])),
                        );

                        $where = array('ISO =?' => $intId);
                        $this->current_Modal->updateTable($editData, $where);

                        $this->_helper->flashMessenger->addMessage("Record updated successfully");
                        $this->_redirect("admin/airport/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 getcityajaxAction() {
        $this->_helper->layout()->disableLayout('');
        if ($this->_request->isXmlHttpRequest()) {
            $country_id = $this->getRequest()->getParam('countryid');

            $where = array('IsMarkForDel' => '0', 'ContSysId' => trim($country_id));

            $city_list = $this->cityMdl->getRecordListingWhere('TB_Master_Geo_City', array('CityId', 'Title'), $where, "Title", "ASC"); // call Method	
            //echo "<pre>";print_r($city_list);die;

            $select = '<option value="">--Select--</option>';

            if ($city_list != "") {

                $select = '<script src="/public/assets/js/pages/selectAjaxTag.js"></script>';
                $select .= '<select id="cityList" name="cityList" class="demo-default select-ajax-country" placeholder="Select City"><option value="">Select City</option>';
                foreach ($city_list as $val) {
                    $select .= '<option value="' . $val['CityId'] . '">' . $val['Title'] . '</option>';
                }
            } else {
                $select = '<script src="/public/assets/js/pages/selectAjaxTag.js"></script>';
                $select .= '<select id="cityList" name="cityList" class="demo-default select-ajax-country" placeholder="Select City"><option value="">Select City</option></select>';
            }

            echo $select;
        }
        exit;
    }

    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('ISO =?' => $id);
            $isupdated = $this->cityMdl->updateTable($this->tablename, $editData, $where);
            if ($isupdated) {
                $this->_helper->flashMessenger->addMessage("Record Deleted successfully.");
                $this->_redirect("admin/airport/index/page/$currentPage");
            }
        } else {
            $this->_redirect("admin/airport/index/page/$currentPage");
        }
    }

    public function getlocationAction() {
        if ($this->getRequest()->isXmlHttpRequest()) {
            /* Disable layout */
            $this->_helper->viewRenderer->setNoRender(true);

            $this->_helper->layout->disableLayout();
            $strAddress = $this->getRequest()->getPost('address');
            $arrLocation = $this->getHelper('General')->getLatitudeLongitude($strAddress);
            echo Zend_Json::encode($arrLocation);
            exit;
        }
    }

    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;
            }

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

}