<?php

/*
 * Catabatic Technology Pvt. Ltd.
 * File Name :ImageTypeController.php
 * File Description :Department controller managed all data related to department
 * Created By : Pardeep Panchal
 * Created Date: 02-Auguest-2016
 */

class InventoryDetailController extends Zend_Controller_Action {

    public function init() {
        parent::init();
        $request = Zend_Controller_Front::getInstance()->getRequest();
        $this->baseUrl = $request->getScheme() . '://' . $request->getHttpHost();
        $sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
        // Zend_Session::rememberMe(60 * 60 * 24 * 7);
        #get session variable

        $this->intLoggedinUserId = $sessionLogin_user->intLoggedinUserId;
        $this->intLoggedinUserGroupSysId = $sessionLogin_user->intLoggedinUserGroupSysId;
        $this->intLoggedinUserAgencySysId = $sessionLogin_user->intLoggedinUserAgencySysId;
        $this->intLoggedinUserTrxCurrency = $sessionLogin_user->intLoggedinUserTrxCurrency;

        if (!empty($this->intLoggedinUserAgencySysId)) {
            $this->InfoSourceSysId = '2'; /* Information Source is Agent */
        }

        if (empty($this->intLoggedinUserId)) {
            $this->_redirect('/login/');
        }
        $this->_crmcustomerObj = new Travel_Model_CRM_Customer();
    }

    public function indexAction() {
        $intLoggedinUserAgencySysId = $this->intLoggedinUserAgencySysId;
        $this->view->strPageTitle = "Inventory Detail";
        $objPackage = new Travel_Model_TblPackage();
        $this->view->source = $this->_getParam('filter', 'inprocess');
        $searchData = [];
        if ($this->getRequest()->isPost()) {
            $searchData = $this->getRequest()->getParams();
        }
        $packageList = $objPackage->getFixedDepartue($intLoggedinUserAgencySysId, $this->view->source, $searchData);
        $page = $this->_getParam('page', 1);
        $paginator = Zend_Paginator::factory($packageList);
        $paginator->setItemCountPerPage(GRID_PER_PAGE_RECORD_COUNT);
        $paginator->setCurrentPageNumber($page);
        $this->view->per_page_record = GRID_PER_PAGE_RECORD_COUNT;
        $this->view->page = $page;
        $this->view->paginator = $paginator;
        $this->view->messages = $this->_helper->flashMessenger->getMessages();
        $this->view->searchData = $searchData;
    }

    public function viewInventoryDetailPopupAction() {
        $this->_helper->layout->disableLayout();
        $intLoggedinUserAgencySysId = $this->intLoggedinUserAgencySysId;
        $objPackage = new Travel_Model_TblPackage();
        if ($this->getRequest()->isPost()) {
            $postData = $this->getRequest()->getPost();
            $pkgId = $postData['id'];
            $resultset = array();
            $resultsetOnHold = array();
            $resultset = $objPackage->getInventoryDateForInventoryDetail($intLoggedinUserAgencySysId, $pkgId);
            $this->view->flexiPackageList = $resultset;
            $this->view->pkgId = $pkgId;
        }
    }

    public function onholdInventoryDetailAction() {
        $this->view->baseUrl = $this->baseUrl;
        $intLoggedinUserAgencySysId = $this->intLoggedinUserAgencySysId;
        $this->view->strPageTitle = "Onhold Inventory Detail";
        $objPackage = new Travel_Model_TblPackage();
        $this->view->paramData = $paramData = $this->getRequest()->getParams();
        $date1 = isset($paramData['date']) ? $paramData['date'] : '';
        $departureCity = isset($paramData['departureCity']) ? $paramData['departureCity'] : NULL;
        $date = base64_decode($date1);
        $getCustomerIdsQueryArray = array();
        $getCustomerIdsQuery = $objPackage->GetFixeddepartureTravelPlanQueryDetails($intLoggedinUserAgencySysId, base64_decode($paramData['id']), $departureCity);
        $this->view->fixedInventroy = $objPackage->getInventoryCount($date, base64_decode($paramData['id']), $departureCity);
        $customHelper = Zend_Controller_Action_HelperBroker::getStaticHelper('Custom');
        $travelPlanStatusName = $customHelper->GetTravelPlanStatus(2);
//                 echo "<pre>";print_r($getCustomerIdsQuery);die;
        $StatusType = '';
        foreach ($getCustomerIdsQuery as $dataKey => $dataValue) {
            foreach ($travelPlanStatusName as $statuskey => $statusvalue) {
                if ($statusvalue['TPStatusSysId'] == $dataValue['StatusType']) {
                    $StatusType = $statusvalue['TPStatus'];
                }
            }
            if ($dataValue['InventoryStatus'] == 0) {
                $InventoryStatus = 'Hold';
            } else if ($dataValue['InventoryStatus'] == 1) {
                $InventoryStatus = '<span style="color:green">Sold</span>';
            } else if ($dataValue['InventoryStatus'] == 2) {
                $InventoryStatus = 'Payment Faild';
            }
            if (isset($date) && $date != '') {
                if ($date == $dataValue['FromDate']->format('Y-m-d')) {
                    $getCustomerIdsQueryArray[] = [
                        'FromDate' => $dataValue['FromDate']->format('d-M-y'),
                        'IsB2BAgent' => $dataValue['IsB2BAgent'],
                        'CompanyName' => trim($dataValue['CompanyName']),
                        'FullName' => trim($dataValue['FirstName']) . ' ' . trim($dataValue['LastName']),
                        'EmailId' => $dataValue['EmailId'],
                        'Contacts' => $dataValue['Contacts'],
                        'CustomerSysId' => $dataValue['CustomerSysId'],
                        'RefTPSysID' => $dataValue['RefTPSysID'],
                        'Title' => $dataValue['Title'],
                        'TPSysId' => $dataValue['TPSysId'],
                        'MasterTPSysId' => $dataValue['MasterTPSysId'],
                        'StatusType' => $StatusType,
                        'StatusTypeId' => $dataValue['StatusType'],
                        'Inventory' => $dataValue['Inventory'],
                        'InventoryStatus' => $dataValue['InventoryStatus'],
                        'CreateDate' => $dataValue['CreateDate']->format('d-M-y'),
                        'HoldDay' => ($dataValue['HoldDay'] != '') ? $dataValue['HoldDay'] : 0,
                        'NetPrice' => $dataValue['NetPrice'] + $dataValue['TotalCostGen'] + $dataValue['TotalTcs'],
                        'isShareWithFlight' => $dataValue['isShareWithFlight'],
                        'ShareCombinedFlightPricing' => $dataValue['ShareCombinedFlightPricing'],
                        'AgencyMarkUp' => $dataValue['AgencyMarkUp'],
                        'MarkUp' => $dataValue['MarkUp'],
                        'Price' => $dataValue['Price'],
                        'XServiceTaxAmount' => $dataValue['XServiceTaxAmount'],
                        'AgentServiceTaxAmount' => $dataValue['AgentServiceTaxAmount'],
                        'AgentsCustomServiceTaxAmount' => $dataValue['AgentsCustomServiceTaxAmount'],
                        'ServiceTaxOnCustomDiscount' => $dataValue['ServiceTaxOnCustomDiscount'],
                        'CustomDiscount' => $dataValue['CustomDiscount'],
                        'Readymade' => $dataValue['Readymade'],
                        'CurrencyType' => $dataValue['CurrencyType'],
                        'AgentFullName' => trim($dataValue['AgentFirstName']) . ' ' . trim($dataValue['AgentLastName']),
                    ];
                }
            } else {
                $getCustomerIdsQueryArray[] = [
                    'FromDate' => $dataValue['FromDate']->format('d-M-y'),
                    'IsB2BAgent' => $dataValue['IsB2BAgent'],
                    'CompanyName' => trim($dataValue['CompanyName']),
                    'FullName' => trim($dataValue['FirstName']) . ' ' . trim($dataValue['LastName']),
                    'EmailId' => $dataValue['EmailId'],
                    'Contacts' => $dataValue['Contacts'],
                    'CustomerSysId' => $dataValue['CustomerSysId'],
                    'RefTPSysID' => $dataValue['RefTPSysID'],
                    'Title' => $dataValue['Title'],
                    'TPSysId' => $dataValue['TPSysId'],
                    'MasterTPSysId' => $dataValue['MasterTPSysId'],
                    'StatusType' => $StatusType,
                    'StatusTypeId' => $dataValue['StatusType'],
                    'Inventory' => $dataValue['Inventory'],
                    'InventoryStatus' => $dataValue['InventoryStatus'],
                    'CreateDate' => $dataValue['CreateDate']->format('d-M-y'),
                    'HoldDay' => ($dataValue['HoldDay'] != '') ? $dataValue['HoldDay'] : 0,
                    'NetPrice' => $dataValue['NetPrice'] + $dataValue['TotalCostGen'] + $dataValue['TotalTcs'],
                    'isShareWithFlight' => $dataValue['isShareWithFlight'],
                    'ShareCombinedFlightPricing' => $dataValue['ShareCombinedFlightPricing'],
                    'AgencyMarkUp' => $dataValue['AgencyMarkUp'],
                    'MarkUp' => $dataValue['MarkUp'],
                    'Price' => $dataValue['Price'],
                    'XServiceTaxAmount' => $dataValue['XServiceTaxAmount'],
                    'AgentServiceTaxAmount' => $dataValue['AgentServiceTaxAmount'],
                    'AgentsCustomServiceTaxAmount' => $dataValue['AgentsCustomServiceTaxAmount'],
                    'ServiceTaxOnCustomDiscount' => $dataValue['ServiceTaxOnCustomDiscount'],
                    'CustomDiscount' => $dataValue['CustomDiscount'],
                    'Readymade' => $dataValue['Readymade'],
                    'CurrencyType' => $dataValue['CurrencyType'],
                    'AgentFullName' => trim($dataValue['AgentFirstName']) . ' ' . trim($dataValue['AgentLastName']),
                ];
            }
        }
//        echo "<pre>";print_r($getCustomerIdsQuery);die;
        $page = $this->_getParam('page', 1);
        $paginator = Zend_Paginator::factory($getCustomerIdsQueryArray);
        $paginator->setItemCountPerPage(GRID_PER_PAGE_RECORD_COUNT);
        $paginator->setCurrentPageNumber($page);

        $this->view->per_page_record = GRID_PER_PAGE_RECORD_COUNT;
        $this->view->page = $page;
        $this->view->paginator = $paginator;
        $this->view->messages = $this->_helper->flashMessenger->getMessages();
        $TblCurrency = new Travel_Model_TblCurrency();
        $this->view->CurrencySymbol = $CurrencySymbol = $TblCurrency->getCurrencySymbolByIdsList();
    }

    public function changeInventoryStatusDetailAction() {
        $this->_helper->layout->disableLayout();
        $payment = new Payment_Model_Payment();
        if ($this->getRequest()->isPost()) {
            $postData = $this->getRequest()->getParams();
            $payment = $payment->updatelockInventorystatusManual($postData['id'], $postData['inventoryStatus']);
            $status = array('status' => 'success');
            echo json_encode($status);
            exit;
        }
    }

    public function addInventoryBookingAction() {
        $TblCurrency = new Travel_Model_TblCurrency();
        $objPackage = new Travel_Model_TblPackage();
        $markupMdl = new Markup_Model_Markup();
        $this->view->paramData = $paramData = $this->getRequest()->getParams();
        $id = isset($paramData['id']) ? $paramData['id'] : '';
        $pkgid = base64_decode($id);
        $date1 = isset($paramData['date']) ? $paramData['date'] : '';
        $dipartureCity = isset($paramData['departure']) ? $paramData['departure'] : '';
        $date = base64_decode($date1);
        $this->view->travelPlan = $travelPlan = $objPackage->getFlexiPackageList($pkgid);
        $this->view->flexiPackageItenList = $flexiPackageItenList = $objPackage->getFlexiPackageItenList($pkgid);
        $this->view->AgencySysId = $this->intLoggedinUserAgencySysId;
        $getleadSource = $this->_crmcustomerObj->getLeadSourceByAgency($this->intLoggedinUserAgencySysId);
        $this->view->leadSourceList = $getleadSource;
        $this->view->dipartureCity = $dipartureCity;
        $this->view->Currency = $Currency = $TblCurrency->getCurrencyTypes();
        $PlanType = (!empty($travelPlan['PlanType'])) ? $travelPlan['PlanType'] : 5;
        
        $this->view->getTaxSettingDetail = $markupMdl->getTaxSettingDetailForCustom("TB_Master_Agency_Tax_Settings", $this->intLoggedinUserAgencySysId, 0, 1, $PlanType);
//        echo "<pre>";print_r($travelPlan);die;
    }

    public function addInventoryBookingPassangerAction() {
        $this->_helper->layout->disableLayout();
        if ($this->getRequest()->isPost()) {
            $postData = $this->getRequest()->getParams();
            $getCustomerDetail = array();
            $CustomerSysId = (isset($postData['CustomerSysId']) && $postData['CustomerSysId'] != '') ? $postData['CustomerSysId'] : '';
            if ($CustomerSysId != '') {
                $getCustomerDetail = $this->_crmcustomerObj->GetCustomerWithDetails($CustomerSysId);
            }
            $this->view->totaltraveller = $totaltraveller = $postData['totaltraveller'];
            $this->view->AgencySysId = $this->intLoggedinUserAgencySysId;
            $this->view->getCustomerDetail = $getCustomerDetail;
        }
    }

    public function getCustomerDetailByIdAction() {
        $this->view->layout()->disableLayout();
        $CustomerSysId = $this->getRequest()->getParam('CustomerSysId');
        $response = array();
        if ($CustomerSysId) {
            $getCustomerDetail = $this->_crmcustomerObj->GetCustomerWithDetails($CustomerSysId);

            $countryshortcode = Zend_Controller_Action_HelperBroker::getStaticHelper('General')->countryshortcode(($getCustomerDetail['countrycode'] != null) ? str_replace('+', '', trim($getCustomerDetail['countrycode'])) : '91');
            $response = array(
                'CustomerSysId' => $getCustomerDetail['CustomerSysId'],
                'Salutation' => trim($getCustomerDetail['Salutation']),
                'FullName' => trim($getCustomerDetail['FullName']),
                'FirstName' => trim($getCustomerDetail['FirstName']),
                'LastName' => trim($getCustomerDetail['LastName']),
                'EmailId' => trim($getCustomerDetail['EmailId']),
                'Contacts' => trim($getCustomerDetail['Contacts']),
                'Countrycode' => trim($getCustomerDetail['countrycode']),
                'countryshortcode' => $countryshortcode,
                'DOB' => ($getCustomerDetail['DOB']->format('d/m/Y') != '01/01/1900') ? $getCustomerDetail['DOB']->format('d/m/Y') : '',
                'PassportNo' => $getCustomerDetail['PassportNo'],
                'PassportExpiry' => ($getCustomerDetail['PassportExpiry']->format('d/m/Y') != '01/01/1900') ? $getCustomerDetail['PassportExpiry']->format('d/m/Y') : '',
                'CitySysId' => $getCustomerDetail['CitySysId'],
                'StateOrZoneSysId' => $getCustomerDetail['StateOrZoneSysId'],
                'CountrySysId' => $getCustomerDetail['CountrySysId'],
                'PinCode' => trim($getCustomerDetail['PinCode']),
                'Address' => $getCustomerDetail['Address'],
                'StateName' => $getCustomerDetail['StateName'],
                'CountryTitle' => $getCustomerDetail['CountryTitle'],
                'cityTitle' => $getCustomerDetail['cityTitle'],
            );
        }

        echo json_encode(array('status' => true, 'data' => $response));
        exit;
    }

    public function hotelAction() {
        $intLoggedinUserAgencySysId = $this->intLoggedinUserAgencySysId;
        $params = Zend_Controller_Front::getInstance()->getRequest()->getParams();
        $searchArr = Zend_Controller_Front::getInstance()->getRequest()->getPost();
//         echo '<pre>';print_r(implode('-',array_reverse(explode('/',$searchArr['FromDate']))));echo '</pre>';die;
        $inventoryList = array();
        $this->view->strPageTitle = "Inventory Detail";
        $objHotel = new Travel_Model_TblHotel();
        $objAgency = new Travel_Model_TblAgency();
        $objAccoModel = new Travel_Model_AccommodationModel();
        $TblBuyHotel = new Travel_Model_TblBuyHotel();
        $orderBy = $searchArr['order'] = (isset($searchArr['order']) && !empty($searchArr['order'])) ? $searchArr['order'] : 'FromDate_1';
        $order_type = explode('_', $orderBy);
        $ASCDESC = ($order_type[1] == 1) ? 'ASC' : 'DESC';
        $orderStr = 'tb1.' . trim($order_type[0]) . ' ' . $ASCDESC;
        if (isset($params['id']) && !empty($params['id'])) {
            $result = $objAccoModel->hotelDetailsRates($params['id'], $this->intLoggedinUserAgencySysId);
            if (!$result) {
                die('Invalid request!! try again.');
            }
            $RoomDetailsList = $objAccoModel->HotelRoomDetailsList($params['id'], $this->intLoggedinUserAgencySysId);

            $objAccoModel->searchHotelinv['hotelId'] = $params['id'];
            $objAccoModel->searchHotelinv['EconomyType'] = $params['eco'] = (isset($searchArr['RoomTypeId']) && !empty($searchArr['RoomTypeId'])) ? (int) $searchArr['RoomTypeId'] : $RoomDetailsList[0]['room']['RoomTypeId'];
            $objAccoModel->searchHotelinv['FromDate'] = (isset($searchArr['FromDate']) && !empty($searchArr['FromDate'])) ? date('Y-m-d', strtotime($searchArr['FromDate'])) : '';
            $objAccoModel->searchHotelinv['ToDate'] = (isset($searchArr['ToDate']) && !empty($searchArr['ToDate'])) ? date('Y-m-d', strtotime($searchArr['ToDate'])) : '';
            $objAccoModel->searchHotelinv['OrderBy'] = $orderStr;
            $inventoryList = $objAccoModel->HotelrateCardByAgListByHotel($intLoggedinUserAgencySysId);
        }
//        echo "<pre>";print_r($inventoryList);die;
        $page = $this->_getParam('page', 1);
        $paginator = Zend_Paginator::factory($inventoryList);
        $paginator->setItemCountPerPage(GRID_PER_PAGE_RECORD_COUNT);
        $paginator->setCurrentPageNumber($page);

        $this->view->per_page_record = GRID_PER_PAGE_RECORD_COUNT;
        $this->view->page = $page;
        $this->view->paginator = $paginator;
        $this->view->result = $result;
        $this->view->RoomDetailsList = $RoomDetailsList;
        $this->view->params = $params;
        $this->view->messages = $this->_helper->flashMessenger->getMessages();
        $this->view->baseUrl = $this->baseUrl;
        $this->view->searchArr = $searchArr;
    }

    public function hotelInventoryDetailAction() {
        $this->view->params = $params = Zend_Controller_Front::getInstance()->getRequest()->getParams();
        $this->view->eco = $eco = trim($params['eco']);
        $hotelId = base64_decode($params['id']);
        $date = str_replace('/', '-', trim(base64_decode(trim($params['date']))));
        $postData = $this->getRequest()->getPost();
//        echo "<pre>";print_r($postData);die;
        $this->view->dateFrom = $dateFrom = (isset($postData['dateFrom']) && !empty($postData['dateFrom'])) ? trim($postData['dateFrom']) : '';
        $EconomyType = (isset($postData['EconomyType']) && !empty($postData['EconomyType'])) ? trim($postData['EconomyType']) : '';
        $TblBuyHotel = new Travel_Model_TblBuyHotel();
        $AccommodationModel = new Travel_Model_AccommodationModel();
        $intLoggedinUserAgencySysId = $this->intLoggedinUserAgencySysId;
        $TblBuyHotel->strCondition = '';
        $TblBuyHotel->strCondition .= " 1=1 ";
        $TblBuyHotel->strCondition .= " AND TPA.AccoSysId = '" . $hotelId . "'";
        if ($EconomyType != '') {
            $this->view->eco = $EconomyType;
            $TblBuyHotel->strCondition .= " AND TACTAIL.RoomType = '" . $EconomyType . "'";
        } else if ($eco != '') {
            $TblBuyHotel->strCondition .= " AND TACTAIL.RoomType = '" . $eco . "'";
        }
        $TblBuyHotel->strCondition .= " AND TPA.XRefBookingId != '' AND TPA.XRefBookingId != '0' ";
        if ($dateFrom != '') {
            $TblBuyHotel->strCondition .= " AND (TPA.FromDate <= '" . $dateFrom . "' AND TPA.ToDate > '" . $dateFrom . "')";
        } else {
            $this->view->dateFrom = $date;
            $TblBuyHotel->strCondition .= " AND (TPA.FromDate <= '" . $date . "' AND TPA.ToDate > '" . $date . "')";
        }
        $getHotelBookingList = $TblBuyHotel->getHotelBookingList('', 'INV');
        $this->view->getHotelBookingList = $getHotelBookingList;
        $hotelDetails = $AccommodationModel->hotelDetails($hotelId, $intLoggedinUserAgencySysId);
        $this->view->hotelDetails = $hotelDetails;
        $getAvailableRoomTypes = $TblBuyHotel->getAvailableRoomTypes($hotelId);
        $this->view->getAvailableRoomTypes = $getAvailableRoomTypes;
//        echo "<pre>";print_r($getHotelBookingList);die;
    }

    public function exportBookedInventoryDetailAction() {
        $intLoggedinUserAgencySysId = $this->intLoggedinUserAgencySysId;

        $objPackage = new Travel_Model_TblPackage();
        $paramData = $this->getRequest()->getParams();
        $date1 = isset($paramData['date']) ? $paramData['date'] : '';
        $departureCity = isset($paramData['departure']) ? $paramData['departure'] : NULL;
        $date = base64_decode($date1);
        $getCustomerIdsQueryArray = array();
        $getCustomerIdsQuery = $objPackage->GetFixeddepartureTravelPlanQueryDetailsAllPax($intLoggedinUserAgencySysId, base64_decode($paramData['id']), $departureCity);
        // echo "<pre>";print_r($getCustomerIdsQuery);die;
        $customHelper = Zend_Controller_Action_HelperBroker::getStaticHelper('Custom');
        $travelPlanStatusName = $customHelper->GetTravelPlanStatus(2);

        $StatusType = '';

        $ARR_SALUTION = unserialize(ARR_SALUTION);
        $ARR_CUSTOMER_RELATION = unserialize(ARR_CUSTOMER_RELATION);
        $TPSysIdArray = array();
        $checkTPSysId = array();
        foreach ($getCustomerIdsQuery as $dataKey => $dataValue) {
            if (!in_array($dataValue['TPSysId'], $checkTPSysId)) {
                $checkTPSysId[] = $dataValue['TPSysId'];
                $TPSysIdArray[$dataValue['TPSysId']]['TotalPax'] = $dataValue['Inventory'];
                $TPSysIdArray[$dataValue['TPSysId']]['RoomInfoJson'] = '';
                $roomarray = json_decode($dataValue['RoomInfoJson'], true);
                $totalInfant =  $totalChild = $quintSharing = $hexaSharing = $quadSharing = $SingleSharing = $TripleSharing = $TwinSharing = 0;
                
                foreach ($roomarray as $key => $value) {
                    $totalChild = $totalChild + $value['Child'];
                    $totalInfant = $totalInfant + $value['Infant'];
                    if ($value['Adult'] == 2) {
                        $TwinSharing = $TwinSharing + $value['Adult'];
                    } else if ($value['Adult'] == 3) {
                        $TripleSharing = $TripleSharing + $value['Adult'];
                    } else if ($value['Adult'] == 1) {
                        $SingleSharing = $SingleSharing + $value['Adult'];
                    } else if ($value['adult_type'] == 'quad') {
                        $quadSharing = $quadSharing + $value['Adult'];
                    } else if ($value['adult_type'] == 'quint') {
                        $quintSharing = $quintSharing + $value['Adult'];
                    } else if ($value['adult_type'] == 'hexa') {
                        $hexaSharing = $hexaSharing + $value['Adult'];
                    }
                }
                $roomString = '';
                if ($TwinSharing > 0) {
                    $roomString .= "Twin Sharing - " . $TwinSharing;
                    $roomString .= ", ";
                }
                if ($TripleSharing > 0) {
                    $roomString .= "Triple Sharing - " . $TripleSharing;
                    $roomString .= ", ";
                }
                if ($SingleSharing > 0) {
                    $roomString .= "Single Sharing - " . $SingleSharing;
                    $roomString .= ", ";
                }
                if ($quadSharing > 0) {
                    $roomString .= "Quad Sharing - " . $quadSharing;
                    $roomString .= ", ";
                }
                if ($quintSharing > 0) {
                    $roomString .= "Quint Sharing - " . $quintSharing;
                    $roomString .= ", ";
                }
                if ($hexaSharing > 0) {
                    $roomString .= "Hexa Sharing - " . $hexaSharing;
                    $roomString .= ", ";
                }
                if ($totalChild > 0) {
                    $roomString .= "Total Child - " . $totalChild;
                    $roomString .= ", ";
                }
                if ($totalInfant > 0) {
                    $roomString .= "Total Infant - " . $totalInfant;
                    $roomString .= ", ";
                }
                $TPSysIdArray[$dataValue['TPSysId']]['RoomInfoJson'] = substr($roomString, 0, -1);
            }
        }
//        echo "<pre>";
//        print_r($TPSysIdArray);

        foreach ($getCustomerIdsQuery as $dataKey => $dataValue) {
            foreach ($travelPlanStatusName as $statuskey => $statusvalue) {
                if ($statusvalue['TPStatusSysId'] == $dataValue['StatusType']) {
                    $StatusType = $statusvalue['TPStatus'];
                }
            }
            $DOB = (isset($dataValue['DOB']) && $dataValue['DOB'] != '') ? $dataValue['DOB']->format('d-M-y') : '';
            $PassportExpiry = (isset($dataValue['PassportExpiry']) && $dataValue['PassportExpiry'] != '') ? $dataValue['PassportExpiry']->format('d-M-y') : '';
            if ($dataValue['MemberSysId'] != 0) {
                $PassportExpiry = (isset($dataValue['mPassportExpiry']) && $dataValue['mPassportExpiry'] != '') ? $dataValue['mPassportExpiry']->format('d-M-y') : '';
                $DOB = (isset($dataValue['mDOB']) && $dataValue['mDOB'] != '') ? $dataValue['mDOB']->format('d-M-y') : '';
            }
            if ($dataValue['InventoryStatus'] == 0) {
                $InventoryStatus = 'Hold';
            } else if ($dataValue['InventoryStatus'] == 1) {
                $InventoryStatus = '<span style="color:green">Sold</span>';
            } else if ($dataValue['InventoryStatus'] == 2) {
                $InventoryStatus = 'Payment Faild';
            }
            if (isset($date) && $date != '') {
                if ($date == $dataValue['FromDate']->format('Y-m-d')) {
                    $getCustomerIdsQueryArray[] = [
                        'FromDate' => $dataValue['FromDate']->format('d-M-y'),
//                'Salutation' => $ARR_SALUTION[$dataValue['Salutation']],
                        //'FirstName' => $dataValue['FirstName'],
                        //'LastName' => $dataValue['LastName'],
//                'EmailId' => $dataValue['EmailId'],
                        'Contacts' => $dataValue['Contacts'],
                        'CustomerSysId' => $dataValue['CustomerSysId'],
                        'MemberSysId' => $dataValue['MemberSysId'],
                        'RefTPSysID' => $dataValue['RefTPSysID'],
                        'Title' => $dataValue['Title'],
                        'TPSysId' => $dataValue['TPSysId'],
                        'MasterTPSysId' => $dataValue['MasterTPSysId'],
                        'StatusType' => $StatusType,
                        'StatusTypeId' => $dataValue['StatusType'],
//                'Inventory' => $dataValue['Inventory'],
                        'InventoryStatus' => $dataValue['InventoryStatus'],
                        'CreateDate' => $dataValue['CreateDate']->format('d-M-y'),
                        'HoldDay' => ($dataValue['HoldDay'] != '') ? $dataValue['HoldDay'] : 0,
                        'NetPrice' => $dataValue['NetPrice'] + $dataValue['TotalCostGen'] + $dataValue['TotalTcs'],
                        'isShareWithFlight' => $dataValue['isShareWithFlight'],
                        'ShareCombinedFlightPricing' => $dataValue['ShareCombinedFlightPricing'],
                        'AgencyMarkUp' => $dataValue['AgencyMarkUp'],
                        'MarkUp' => $dataValue['MarkUp'],
                        'Price' => $dataValue['Price'],
                        'XServiceTaxAmount' => $dataValue['XServiceTaxAmount'],
                        'AgentServiceTaxAmount' => $dataValue['AgentServiceTaxAmount'],
                        'AgentsCustomServiceTaxAmount' => $dataValue['AgentsCustomServiceTaxAmount'],
                        'ServiceTaxOnCustomDiscount' => $dataValue['ServiceTaxOnCustomDiscount'],
                        'CustomDiscount' => $dataValue['CustomDiscount'],
                        'Readymade' => $dataValue['Readymade'],
                        'CurrencyType' => $dataValue['CurrencyType'],
                        'CityName' => $dataValue['CityName'],
                        'CountryName' => $dataValue['CountryName'],
                        'PinCode' => $dataValue['PinCode'],
                        'AgentFullName' => trim($dataValue['AgentFirstName']) . ' ' . trim($dataValue['AgentLastName']),
                        'DOB' => $DOB,
                        'PassportNo' => (($dataValue['MemberSysId'] == 0)) ? $dataValue['PassportNo'] : $dataValue['mPassportNo'],
                        'PassportExpiry' => $PassportExpiry,
                        'Salutation' => (($dataValue['MemberSysId'] == 0)) ? trim($dataValue['Salutation']) : trim($dataValue['mSalutation']),
                        'FirstName' => (($dataValue['MemberSysId'] == 0)) ? trim($dataValue['FirstName']) : trim($dataValue['mFirstName']),
                        'LastName' => (($dataValue['MemberSysId'] == 0)) ? trim($dataValue['LastName']) : trim($dataValue['mLastName']),
                        'Relation' => ($dataValue['MemberSysId'] == 0) ? 0 : $dataValue['Relation'],
                        'Inventory' => (($dataValue['IsLeadPax'] == 1)) ? $dataValue['Inventory'] : 0,
                        'EmailId' => (($dataValue['MemberSysId'] == 0)) ? trim($dataValue['EmailId']) : (!empty($dataValue['mEmailId']) ? trim($dataValue['mEmailId']) : trim($dataValue['EmailId'])),
                        'Contacts' => (($dataValue['MemberSysId'] == 0)) ? trim($dataValue['Contacts']) : (!empty($dataValue['mContacts']) ? trim($dataValue['mContacts']) : trim($dataValue['Contacts'])),
                        'IsLeadPax' => $dataValue['IsLeadPax'],
                        'RoomShaing' => (($dataValue['IsLeadPax'] == 1)) ? $TPSysIdArray[$dataValue['TPSysId']]['RoomInfoJson']: ''
                    ];
                }
            } else {
                $getCustomerIdsQueryArray[] = [
                    'FromDate' => $dataValue['FromDate']->format('d-M-y'),
//                'Salutation' => $ARR_SALUTION[$dataValue['Salutation']],
//                'FirstName' => $dataValue['FirstName'],
//                'LastName' => $dataValue['LastName'],
//                'EmailId' => $dataValue['EmailId'],
//                'Contacts' => $dataValue['Contacts'],
                    'CustomerSysId' => $dataValue['CustomerSysId'],
                    'MemberSysId' => $dataValue['MemberSysId'],
                    'RefTPSysID' => $dataValue['RefTPSysID'],
                    'Title' => $dataValue['Title'],
                    'TPSysId' => $dataValue['TPSysId'],
                    'MasterTPSysId' => $dataValue['MasterTPSysId'],
                    'StatusType' => $StatusType,
                    'StatusTypeId' => $dataValue['StatusType'],
//                'Inventory' => $dataValue['Inventory'],
                    'InventoryStatus' => $dataValue['InventoryStatus'],
                    'CreateDate' => $dataValue['CreateDate']->format('d-M-y'),
                    'HoldDay' => ($dataValue['HoldDay'] != '') ? $dataValue['HoldDay'] : 0,
                    'NetPrice' => $dataValue['NetPrice'] + $dataValue['TotalCostGen'] + $dataValue['TotalTcs'],
                    'isShareWithFlight' => $dataValue['isShareWithFlight'],
                    'ShareCombinedFlightPricing' => $dataValue['ShareCombinedFlightPricing'],
                    'AgencyMarkUp' => $dataValue['AgencyMarkUp'],
                    'MarkUp' => $dataValue['MarkUp'],
                    'Price' => $dataValue['Price'],
                    'XServiceTaxAmount' => $dataValue['XServiceTaxAmount'],
                    'AgentServiceTaxAmount' => $dataValue['AgentServiceTaxAmount'],
                    'AgentsCustomServiceTaxAmount' => $dataValue['AgentsCustomServiceTaxAmount'],
                    'ServiceTaxOnCustomDiscount' => $dataValue['ServiceTaxOnCustomDiscount'],
                    'CustomDiscount' => $dataValue['CustomDiscount'],
                    'Readymade' => $dataValue['Readymade'],
                    'CurrencyType' => $dataValue['CurrencyType'],
                    'CityName' => $dataValue['CityName'],
                    'CountryName' => $dataValue['CountryName'],
                    'PinCode' => $dataValue['PinCode'],
                    'AgentFullName' => trim($dataValue['AgentFirstName']) . ' ' . trim($dataValue['AgentLastName']),
                    'DOB' => $DOB,
                    'PassportNo' => (($dataValue['MemberSysId'] == 0)) ? $dataValue['PassportNo'] : $dataValue['mPassportNo'],
                    'PassportExpiry' => $PassportExpiry,
                    'Salutation' => (($dataValue['MemberSysId'] == 0)) ? trim($dataValue['Salutation']) : trim($dataValue['mSalutation']),
                    'FirstName' => (($dataValue['MemberSysId'] == 0)) ? trim($dataValue['FirstName']) : trim($dataValue['mFirstName']),
                    'LastName' => (($dataValue['MemberSysId'] == 0)) ? trim($dataValue['LastName']) : trim($dataValue['mLastName']),
                    'Relation' => ($dataValue['MemberSysId'] == 0) ? 0 : $dataValue['Relation'],
                    'Inventory' => (($dataValue['IsLeadPax'] == 1)) ? $dataValue['Inventory'] : 0,
                    'EmailId' => (($dataValue['MemberSysId'] == 0)) ? trim($dataValue['EmailId']) : (!empty($dataValue['mEmailId']) ? trim($dataValue['mEmailId']) : trim($dataValue['EmailId'])),
                    'Contacts' => (($dataValue['MemberSysId'] == 0)) ? trim($dataValue['Contacts']) : (!empty($dataValue['mContacts']) ? trim($dataValue['mContacts']) : trim($dataValue['Contacts'])),
                    'IsLeadPax' => $dataValue['IsLeadPax'],
                    'RoomShaing' => (($dataValue['IsLeadPax'] == 1)) ? $TPSysIdArray[$dataValue['TPSysId']]['RoomInfoJson']: ''
                ];
            }
        }
        $objPkgBooking = new Travel_Model_TblPackageBooking();
        $sheetTitle = str_replace("/", "", $getCustomerIdsQuery[0]['Title']);
        $arrFieldLabel = array(
            'Sr No.', 'Salutation', 'First Name', 'Last Name', 'Proposal ID', 'Total Pax', 'Rooming', 'Relation', 'Email ID', 'Mobile', 'Booking ID', 'Travel Date',
            'Net Price',
//          'Discount','Tax','Total Cost',
            'Paid', 'Balance', 'Owner', 'Query Status', 'Booking Status', 'DOB', 'Passport No', 'Passport Expiry',
            'City', 'Country', 'Zip Code'
        );
        $arrFieldValue = array();
        $i = 1;
        foreach ($getCustomerIdsQueryArray as $key => $customerBookingRecord) {
            $ToBaseCurrencyExchangeRate = !empty($customerBookingRecord['ToBaseCurrencyExchangeRate']) ? $customerBookingRecord['ToBaseCurrencyExchangeRate'] : 1;
            $NetPrice = $customerBookingRecord['NetPrice'] * $ToBaseCurrencyExchangeRate;
            $amountPaid = $objPkgBooking->getAmountPaidForProposalByTPSysId($customerBookingRecord['TPSysId']);
            $TotalAmountPaid = !empty($amountPaid['TotalAmountPaid']) ? $amountPaid['TotalAmountPaid'] : 0;
            $balanceAmount = round($NetPrice - $TotalAmountPaid);
            if ($balanceAmount == 0) {
                $balanceAmount = "Nil";
            }
            $salesPrice = $flightMarkup + $flightCost + $customerBookingRecord['Price'] + $customerBookingRecord['AgencyMarkUp'] + $customerBookingRecord['MarkUp'];
            $GST = $flightGST + (float) $customerBookingRecord['XServiceTaxAmount'] + (float) $customerBookingRecord['AgentServiceTaxAmount'] + (float) $customerBookingRecord['AgentsCustomServiceTaxAmount'] - (float) $customerBookingRecord['ServiceTaxOnCustomDiscount'];
            $DiscountPrice = (float) $customerBookingRecord['CustomDiscount'] * $ToBaseCurrencyExchangeRate;
            $TPSysIdEncoded = base64_encode($result['TPSysId']);
            $paysecureCode = Zend_Controller_Action_HelperBroker::getStaticHelper('SecureCode')->secureCode($TPSysIdEncoded, 1);
            $fullname = $customerBookingRecord['AgentFullName'];
            $StatusStyle = '';
            if ($result['StatusTypeId'] == 17) {
                $StatusStyle = 'style="color:green"';
            }
            $InventoryStatus = 'Hold';
            if ($customerBookingRecord['InventoryStatus'] == 1) {
                $InventoryStatus = 'Sold';
            } else if ($customerBookingRecord['InventoryStatus'] == 2) {
                $InventoryStatus = 'Release';
            }


            $arrFieldValue[$i]['SrNo'] = $i;
            $arrFieldValue[$i]['Salutation'] = $ARR_SALUTION[$customerBookingRecord['Salutation']];
            $arrFieldValue[$i]['FirstName'] = $customerBookingRecord['FirstName'];
            $arrFieldValue[$i]['LastName'] = $customerBookingRecord['LastName'];
            $arrFieldValue[$i]['ProposalId'] = $customerBookingRecord['TPSysId'];
            $arrFieldValue[$i]['TotalPax'] = $customerBookingRecord['Inventory'];
            $arrFieldValue[$i]['RoomShaing'] = $customerBookingRecord['RoomShaing'];
            $arrFieldValue[$i]['Relation'] = $ARR_CUSTOMER_RELATION[$customerBookingRecord['Relation']];
            $arrFieldValue[$i]['EmailID'] = $customerBookingRecord['EmailId'];
            $arrFieldValue[$i]['Mobile'] = $customerBookingRecord['Contacts'];
            $arrFieldValue[$i]['BookingID'] = $customerBookingRecord['TPSysId'];
            $arrFieldValue[$i]['TravelDate'] = $customerBookingRecord['FromDate'];
            $arrFieldValue[$i]['NetPrice'] = ($customerBookingRecord['IsLeadPax'] == 1) ? number_format($NetPrice) : '';
//            $arrFieldValue[$i]['Discount'] = ($customerBookingRecord['MemberSysId'] == 0) ? number_format($DiscountPrice * $ToBaseCurrencyExchangeRate) : '';
//            $arrFieldValue[$i]['Tax'] = ($customerBookingRecord['MemberSysId'] == 0) ? number_format($GST * $ToBaseCurrencyExchangeRate) : '';
//            $arrFieldValue[$i]['TotalCost'] = $customerBookingRecord['Price'];
            $arrFieldValue[$i]['Paid'] = ($customerBookingRecord['IsLeadPax'] == 1) ? number_format($TotalAmountPaid) : '';
            $arrFieldValue[$i]['Balance'] = ($customerBookingRecord['IsLeadPax'] == 1) ? (($balanceAmount != 'Nil') ? number_format($balanceAmount) : $balanceAmount) : '';
            $arrFieldValue[$i]['Owner'] = !empty($fullname) ? $fullname : 'NA';
            $arrFieldValue[$i]['QueryStatus'] = $customerBookingRecord['StatusType'];
            $arrFieldValue[$i]['BookingStatus'] = $InventoryStatus;
            $arrFieldValue[$i]['DOB'] = ($customerBookingRecord['DOB'] != '01-Jan-00') ? $customerBookingRecord['DOB'] : '';
            $arrFieldValue[$i]['PassportNo'] = $customerBookingRecord['PassportNo'];
            $arrFieldValue[$i]['PassportExpiry'] = ($customerBookingRecord['PassportExpiry'] != '01-Jan-00') ? $customerBookingRecord['PassportExpiry'] : '';
            $arrFieldValue[$i]['City'] = $customerBookingRecord['CityName'];
            $arrFieldValue[$i]['Country'] = $customerBookingRecord['CountryName'];
            $arrFieldValue[$i]['ZipCode'] = $customerBookingRecord['PinCode'];
            $i++;
        }
//        echo "<pre>";print_r($arrFieldValue);die;

        Zend_Controller_Action_HelperBroker::getStaticHelper("CreateExcel")->exportToExcel($sheetTitle, $arrFieldLabel, $arrFieldValue);
        exit;
    }

    public function changeHotelInventoryStatusDetailAction() {

        $this->_helper->layout->disableLayout();
//        $intLoggedinUserAgencySysId = $this->intLoggedinUserAgencySysId;
        $TblBuyHotel = new Travel_Model_TblBuyHotel();
        if ($this->getRequest()->isPost()) {
            $postData = $this->getRequest()->getParams();

            $updateInventoryStatus = $TblBuyHotel->updateHotelLockInventoryStatusManual($postData['id'], $postData['inventoryStatus']);
            echo json_encode($updateInventoryStatus);
            exit;
        }
    }

}