<?php

/***************************************************************
 * Catabatic Technology Pvt. Ltd.
 * File Name     : IndexController.php
 * File Desc.    : Index controller for home page front end
 * Created By    : Ranvir Singh <ranvir@catpl.co.in>
 * Created Date  : 25 May 2017
 * Updated Date  : 14 Dec 2017
 ***************************************************************/

class MarkupController extends Catabatic_CheckSession
{

    protected $objMdl;
    protected $tablename;
    protected $tablenameDestination;
    protected $baseUrl;
    protected $tollfreenumber;

    protected $objHelperGeneral;
    protected $per_page_record;

    public $_session;
    public $customerbookinglistAPIUrl;

    public $uploadPakcagePath;
    public $uploadDestinationPath;
    public $dummyImagePackage;
    public $dummyImageDestination;

    public $myNamespace;


    public function init()
    {
        parent::init();
        $aConfig = $this->getInvokeArg('bootstrap')->getOptions();
        $BootStrap  = $aConfig['bootstrap'];
        $this->_session = new Zend_Session_Namespace('User');
        $this->siteName = $BootStrap['siteName'];
        $this->baseUrl  = $BootStrap['siteUrl'];
        $this->siteImageUrl  = $BootStrap['siteImageUrl'];
        $this->tollfreenumber  = $BootStrap['tollfreenumber'];
        $this->IsAllowFlight  = $BootStrap['IsAllowFlight'];
        $this->IsAllowHotel  = $BootStrap['IsAllowHotel'];
        $this->IsAllowHotelINV  = $BootStrap['IsAllowHotelINV'];
        //$this->gtxagencysysid = $BootStrap['gtxagencysysid'];
        $this->gtxagencysysid = $this->_session->data['AgencySysId'];
        $this->MasterAgencySysId = $this->_session->data['MasterAgencySysId'];
        $this->objMdl   = new Admin_Model_CRUD();

        $this->tablename    = "tb_tbb2c_packages_master";
        $this->tablenameTes = "tbl_testimonials";
        $this->tablenameDestination = "tb_tbb2c_destinations";
        $this->hotelTypeArr = ['Standard', 'Deluxe', 'Luxury'];

        $this->objHelperGeneral = $this->_helper->General;
        $this->per_page_record = 10;

        $this->uploadPakcagePath = 'public/upload/tours/';
        $this->uploadDestinationPath = 'public/upload/destinations/';

        $this->dummyImagePackage = 'default-tour.jpg';
        $this->dummyImageDestination = 'default-destination.jpg';

        $this->enableCache = $BootStrap['enableCache'];
        $this->packageTypeStatic = $BootStrap['packageTypeDynamic'];


        $this->customerbookinglistAPIUrl = API_CUSTOMER_LIST; // from constant file
        $this->customerchangepasswordAPIUrlB2c = API_CUSTOMER_CHANGEPASSWORDB2C;
        $this->addagencyuser = API_ADD_AGENCY_USER;
        $this->updateagencyuser = API_UPDATE_AGENCY_USER;
        $this->agencyuserlist = API_AGENCY_USER_LIST;
        $this->deactivateagencyuser = API_DEACTIVATE_AGENCY_USER;
        $this->activateagencyuser = API_ACTIVATE_AGENCY_USER;
        $this->sendB2bAgentForgetPasswordMail = API_SEND_B2B_AGENT_FORGET_PASSWORD_MAIL;
        $this->myNamespace = new Zend_Session_Namespace('MypopSess'); // get user end infomations

    }




    public function indexAction()
    {
        //$getAgencyData = Zend_Controller_Action_HelperBroker::getStaticHelper("Flight")->getAgencyData($this->gtxagencysysid);

        //echo "<pre>";
        //print_r($this->_session->data);
        //print_r($this->gtxagencysysid);
        //die;       
        $this->view->baseUrl    = $this->baseUrl;
        $this->view->MobileDetect = $this->objHelperGeneral->getDevice();

        $objMarkup = new Travel_Model_Markup();
        if ($this->getRequest()->isPost()) {
            $dateTime = date('Y-m-d H:i:s');
            try {
                $MyBaseCurrency = $this->getRequest()->getPost("MyBaseCurrency");
                $APIBasedBookingsFlightAir = $this->getRequest()->getPost("APIBasedBookingsFlightAir");
                $APIBasedBookingsFlightMPType = $this->getRequest()->getPost("APIBasedBookingsFlightMPType");
                $APIBasedBookingsFlightItemSourceType = $this->getRequest()->getPost("APIBasedBookingsFlightItemSourceType");
                $APIBasedBookingsFlightMarkupType = $this->getRequest()->getPost("APIBasedBookingsFlightMarkupType");
                $APIBasedBookingsFlightMyCommission = $this->getRequest()->getPost("APIBasedBookingsFlightMyCommission");
                $APIBasedBookingsFlightMarkup = $this->getRequest()->getPost("APIBasedBookingsFlightMarkup");
                $APIBasedBookingsFlightMarkupTypeCommssionType = $this->getRequest()->getPost("APIBasedBookingsFlightMarkupTypeCommssionType");
                $insertFlightData = array();
                for ($i = 0; $i < count($APIBasedBookingsFlightMPType); $i++) {


                    if (isset($APIBasedBookingsFlightMarkup[$i]) && $APIBasedBookingsFlightMarkup[$i] != '') {
                        $APIBasedBookingsFlightMarkup[$i] = $APIBasedBookingsFlightMarkup[$i];
                    } else {
                        $APIBasedBookingsFlightMarkup[$i] = 0;
                    }
                    if (isset($APIBasedBookingsFlightMyCommission[$i]) && $APIBasedBookingsFlightMyCommission[$i] != '') {
                        $APIBasedBookingsFlightMyCommission[$i] = $APIBasedBookingsFlightMyCommission[$i];
                    } else {
                        $APIBasedBookingsFlightMyCommission[$i] = 0;
                    }


                    $checkFlightDate = $objMarkup->getDetailsForFlight("tb_mp_stdmarkup_air", $this->gtxagencysysid, $APIBasedBookingsFlightAir[$i], $APIBasedBookingsFlightItemSourceType[$i], $APIBasedBookingsFlightMPType[$i]);
                    // echo "<pre>";
                    // print_r($checkFlightDate);
                    // exit;
                    $insertFlightData['AgencySysId'] = $this->gtxagencysysid;
                    $insertFlightData['MasterAgencySysId'] = $this->MasterAgencySysId;
                    $insertFlightData['MPType'] = $APIBasedBookingsFlightMPType[$i];
                    $insertFlightData['ItemSourceType'] = $APIBasedBookingsFlightItemSourceType[$i];
                    $insertFlightData['AirType'] = $APIBasedBookingsFlightAir[$i];
                    $insertFlightData['CustGrSysId'] = 0;
                    $insertFlightData['Currency'] = $MyBaseCurrency;
                    $insertFlightData['MarkUpType'] = $APIBasedBookingsFlightMarkupType[$i];
                    $insertFlightData['IsSameForAll'] = 0;
                    $insertFlightData['StdMarkUpPer'] = $APIBasedBookingsFlightMarkup[$i];
                    $insertFlightData['TaxPer'] = 0;
                    $insertFlightData['DiscAtMarkupPer'] = 0;
                    $insertFlightData['DiscAtMarkupVal'] = 0;
                    $insertFlightData['CommssionType'] = $APIBasedBookingsFlightMarkupTypeCommssionType[$i];
                    $insertFlightData['CommssionVal'] = $APIBasedBookingsFlightMyCommission[$i];
                    $insertFlightData['DiscountPer'] = 0;
                    $insertFlightData['DiscountVal'] = 0;
                    $insertFlightData['DiscountMsg'] = 0;
                    $insertFlightData['Details'] = 0;
                    $insertFlightData['ValidTill'] = $dateTime;
                    $insertFlightData['IsServiceChrgIncludeInTax'] = 0;
                    $insertFlightData['ApproveDate'] = $dateTime;
                    $insertFlightData['IsApproved'] = 1;
                    $insertFlightData['CreateDate'] = $dateTime;
                    $insertFlightData['UpdateDate'] = $dateTime;
                    $insertFlightData['IsMarkForDel'] = 0;
                    $insertFlightData['IsActive'] = 1;

                    if (!empty($checkFlightDate)) {
                        //echo "<pre>";print_r($insertFlightData);exit;
                        $whereFlight = array(
                            "AgencySysId=?" => $this->gtxagencysysid,
                            "AirType=?" => $APIBasedBookingsFlightAir[$i],
                            "ItemSourceType=?" => $APIBasedBookingsFlightItemSourceType[$i],
                            "MPType=?" => $APIBasedBookingsFlightMPType[$i]
                        );
                        $objMarkup->updateTable("tb_mp_stdmarkup_air", $insertFlightData, $whereFlight);
                    } else {

                        $objMarkup->insertTable("tb_mp_stdmarkup_air", $insertFlightData);
                        //
                    }
                }
                
                $APIBasedBookingsHotelsMPType = $this->getRequest()->getPost("APIBasedBookingsHotelsMPType");
                
                $APIBasedBookingsHotelsItemSourceType = $this->getRequest()->getPost("APIBasedBookingsHotelsItemSourceType");
                $APIBasedBookingsHotelsAccom = $this->getRequest()->getPost("APIBasedBookingsHotelsAccom");
                $MyBaseCurrency = $this->getRequest()->getPost("MyBaseCurrency");
                $ExchangeRateMaarkup = $this->getRequest()->getPost("CurrencyMarkUp");
                $APIBasedBookingsHotelsMarkupType = $this->getRequest()->getPost("APIBasedBookingsHotelsMarkupType");
                $APIBasedBookingsHotelsMarkup = $this->getRequest()->getPost("APIBasedBookingsHotelsMarkup");
                $APIBasedBookingsHotelsDoubleOccupancy = $this->getRequest()->getPost("APIBasedBookingsHotelsDoubleOccupancy");
                $APIBasedBookingsHotelsSingleOccupancy = $this->getRequest()->getPost("APIBasedBookingsHotelsSingleOccupancy");
                $APIBasedBookingsHotelsExtraBed = $this->getRequest()->getPost("APIBasedBookingsHotelsExtraBed");
                $APIBasedBookingsHotelsWithoutExtraBed = $this->getRequest()->getPost("APIBasedBookingsHotelsWithoutExtraBed");
                $insertData = array();
                for ($i = 0; $i < count($APIBasedBookingsHotelsMPType); $i++) {

                    if (isset($APIBasedBookingsHotelsMarkup[$i]) && $APIBasedBookingsHotelsMarkup[$i] != '') {
                        $APIBasedBookingsHotelsMarkup[$i] = $APIBasedBookingsHotelsMarkup[$i];
                    } else {
                        $APIBasedBookingsHotelsMarkup[$i] = 0;
                    }
                    if (isset($APIBasedBookingsHotelsDoubleOccupancy[$i]) && $APIBasedBookingsHotelsDoubleOccupancy[$i] != '') {
                        $APIBasedBookingsHotelsDoubleOccupancy[$i] = $APIBasedBookingsHotelsDoubleOccupancy[$i];
                    } else {
                        $APIBasedBookingsHotelsDoubleOccupancy[$i] = 0;
                    }
                    if (isset($APIBasedBookingsHotelsSingleOccupancy[$i]) && $APIBasedBookingsHotelsSingleOccupancy[$i] != '') {
                        $APIBasedBookingsHotelsSingleOccupancy[$i] = $APIBasedBookingsHotelsSingleOccupancy[$i];
                    } else {
                        $APIBasedBookingsHotelsSingleOccupancy[$i] = 0;
                    }
                    if (isset($APIBasedBookingsHotelsExtraBed[$i]) && $APIBasedBookingsHotelsExtraBed[$i] != '') {
                        $APIBasedBookingsHotelsExtraBed[$i] = $APIBasedBookingsHotelsExtraBed[$i];
                    } else {
                        $APIBasedBookingsHotelsExtraBed[$i] = 0;
                    }
                    if (isset($APIBasedBookingsHotelsWithoutExtraBed[$i]) && $APIBasedBookingsHotelsWithoutExtraBed[$i] != '') {
                        $APIBasedBookingsHotelsWithoutExtraBed[$i] = $APIBasedBookingsHotelsWithoutExtraBed[$i];
                    } else {
                        $APIBasedBookingsHotelsWithoutExtraBed[$i] = 0;
                    }
                    $checkHotelDate = $objMarkup->getDetailsForHotel("tb_mp_stdmarkup_accom", $this->gtxagencysysid, $APIBasedBookingsHotelsAccom[$i], $APIBasedBookingsHotelsItemSourceType[$i], $APIBasedBookingsHotelsMPType[$i]);
                    /* Hotel Data Insert */
                    //
                    $insertData['AgencySysId'] = $this->gtxagencysysid;
                    $insertData['MasterAgencySysId'] = $this->MasterAgencySysId;
                    $insertData['MPType'] = $APIBasedBookingsHotelsMPType[$i];
                    $insertData['ItemSourceType'] = $APIBasedBookingsHotelsItemSourceType[$i];
                    $insertData['CustGrSysId'] = 0;
                    $insertData['AccomType'] = $APIBasedBookingsHotelsAccom[$i];
                    $insertData['Currency'] = $MyBaseCurrency;
                    $insertData['MarkUpType'] = $APIBasedBookingsHotelsMarkupType[$i];
                    $insertData['IsSameForAll'] = 0;
                    $insertData['MarkUp'] = $APIBasedBookingsHotelsMarkup[$i];
                   
                    $insertData['ValidTill'] = $dateTime;
                    $insertData['ApproveDate'] = $dateTime;
                    $insertData['CreateDate'] = $dateTime;
                    $insertData['UpdateDate'] = $dateTime;
                    $insertData['IsApproved'] = 1;
                    $insertData['IsMarkForDel'] = 0;
                    $insertData['IsActive'] = 1;
                    //echo "<pre>";print_r($insertData);
                    if (!empty($checkHotelDate)) {
                        $where = array(
                            "AgencySysId=?" => $this->gtxagencysysid,
                            "AccomType=?" => $APIBasedBookingsHotelsAccom[$i],
                            "ItemSourceType=?" => $APIBasedBookingsHotelsItemSourceType[$i],
                            "MPType=?" => $APIBasedBookingsHotelsMPType[$i]
                        );
                        $objMarkup->updateTable("tb_mp_stdmarkup_accom", $insertData, $where);
                    } else {
                        $objMarkup->insertTable("tb_mp_stdmarkup_accom", $insertData);
                    }
                }
            } catch (Zend_Exception $e) {
                print_r($e->getMessage());
                exit;
            }
        }

        $this->view->AgencyId = $this->gtxagencysysid;
        
        $this->view->getAllHotelDetail  = $getAllHotelDetail= $objMarkup->getDetailsForHotelAgency("tb_mp_stdmarkup_accom", $this->gtxagencysysid);
        $this->view->getAllFlightDetail = $getAllFlightDetail = $objMarkup->getDetailsForHotelAgency("tb_mp_stdmarkup_air", $this->gtxagencysysid);
        
        $this->view->IsAllowFlight = $this->IsAllowFlight;
        $this->view->IsAllowHotel = $this->IsAllowHotel;
        $this->view->IsAllowHotelINV = $this->IsAllowHotelINV;
        //echo "<pre>";
        //print_r($getAllHotelDetail);die;
    }
}