<?php
/***************************************************************
* Catabatic Technology Pvt. Ltd.
* File Name     : StaticpageController.php
* File Desc.    : Staticpage controller managed all staic content pages
* Created By    : Piyush Tiwari <piyush@catpl.co.in>
* Created Date  : 23 May 2018
* Updated Date  : 23 May 2018
***************************************************************/
class Admin_MarkupController extends Zend_Controller_Action
{
    

    public $dbAdapter;
    public $perPageLimit;
    public $siteurl;
    public $DIR_WRITE_MODE;
    protected $objMdl;
    public $gtxagencysysid;
    public $gtxagentsysid;
    
    public function init(){

       /*Initialize db and session access */
         parent::init(); 
         $aConfig = $this->getInvokeArg('bootstrap')->getOptions();
         $this->siteurl           = $aConfig['bootstrap']['siteUrl']; 
		 $this->appmode = $aConfig['bootstrap']['appmode'];
		 $this->per_page_record   = 20;

         $this->dbAdapter = Zend_Db_Table::getDefaultAdapter();
       
         $auth        = Zend_Auth::getInstance();
         $authStorage = $auth->getStorage()->read();
         $this->username      = $authStorage->username;
         $this->admin_type    = $authStorage->role;
         $this->table = 'tb_mp_stdmarkup_air';   
         $this->current_time = time();
         $this->imageUrl     = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/offers/';
         $this->DIR_WRITE_MODE = 0777;
         $this->gtxagencysysid       = $aConfig['bootstrap']['gtxagencysysid']; // get gtxagencysysid from application config
         $this->gtxagentsysid       = $aConfig['bootstrap']['gtxagentsysid']; // get gtxagentsysid from application config
         $this->objMdl = new Admin_Model_CRUD();
     
    }
    
    
    
    /**
    * index() method is used to admin login for form call
    * @param Null
    * @return Array 
    */
    
    public function indexAction()
    {
                //Check admin logedin or not
       

        $this->checklogin();
        $this->view->messages = $this->_helper->flashMessenger->getMessages();
        $crud   = new Admin_Model_CRUD();
        $getData = array();
        
        //  echo"<pre>";print_r($getHotelMarkup);exit;
        $resultset = $crud->rv_select_static( $this->table,['*'],['isMarkForDel' =>0 ],['AgencySysId '=> 'DESC']);  
        
             
        $this->view->baseUrl = $this->siteurl;        
        $this->view->resultset = $resultset;        

    }
    
    public function updatedAction()
    {
      $crud   = new Admin_Model_CRUD(); 
      $resultset = $crud->rv_select_static( $this->table,['*'],['isMarkForDel' =>0,'AccomType'=>'1'],['AgencySysId '=> 'DESC']); 

        $getHotelMarkup = Zend_Controller_Action_HelperBroker::getStaticHelper("Hotel")->getMarkup('IN');
      
        $t=time();
        $datetime = date("Y-m-d",$t);


        //echo"<pre>";print_r($this->gtxagencysysid);exit;
        if($getHotelMarkup){
            $hotelMarkupArray = array(
            'AgencySysId' => $this->gtxagencysysid,
            'MasterAgencySysId' => $this->gtxagencysysid,
            'MPType' => 2,
            'ItemSourceType' => isset($getHotelMarkup['arrAgencyUserDetail']['ItemSourceType'])?$getHotelMarkup['arrAgencyUserDetail']['ItemSourceType']:0,
            'AirType' => 0,
            'AccomType' =>$getHotelMarkup['arrAgencyMarkupsHotel'][0]['AccomType'],
            'IsForCancellation' =>0,
            'CustGrSysId' => 0,
            'Currency' => $getHotelMarkup['arrAgencyMarkupsHotel']['0']['Currency'],
            'MarkUpType' => $getHotelMarkup['arrAgencyMarkupsHotel']['0']['MarkUpType'],
            'IsSameForAll' => 0,
            'StdMarkUpPer' => $getHotelMarkup['arrAgencyMarkupsHotel']['0']['MarkUp'],
            'TaxPer' =>  $getHotelMarkup['arrAgencyMarkupsHotel']['0']['Tax'],
            'DiscAtMarkupPer' => 0,
            'DiscAtMarkupVal' => 0,
            'CommssionType' => 0,
            'CommssionVal' => 0,
            'DiscountPer' => 0,
            'DiscountVal' => 0,
            'DiscountMsg' => 0,
            'Details' => 0,
            'ValidTill' =>$datetime,
            'IsServiceChrgIncludeInTax' => 0,
            'ApproveDate' =>$datetime,
            'IsApproved' => 1,
            'IsMarkForDel' => 0,
            'IsActive' => 1,

          );
        }

       if($resultset){
           $queryup1 = $this->objMdl->rv_update($this->table, $hotelMarkupArray, ['MPType=?' => 2,'AccomType=?'=>1]);
        }else{
          $queryup1 =  $this->objMdl->rv_insert($this->table, $hotelMarkupArray);  
            
        }


        $resultset = $crud->rv_select_static( $this->table,['*'],['isMarkForDel' =>0,'AccomType'=>'2' ],['AgencySysId '=> 'DESC']); 

        $getHotelMarkup = Zend_Controller_Action_HelperBroker::getStaticHelper("Hotel")->getMarkup('UK');
       // echo"<pre>";print_r($getHotelMarkup);exit;

        if($getHotelMarkup){
            $hotelMarkupArray = array(
            'AgencySysId' => $this->gtxagencysysid,
            'MasterAgencySysId' => $this->gtxagencysysid,
            'MPType' => 2,
            'ItemSourceType' => isset($getHotelMarkup['arrAgencyUserDetail']['ItemSourceType'])?$getHotelMarkup['arrAgencyUserDetail']['ItemSourceType']:0,
            'AirType' => 0,
            'AccomType' =>$getHotelMarkup['arrAgencyMarkupsHotel'][0]['AccomType'],
            'IsForCancellation' =>0,
            'CustGrSysId' => 0,
            'Currency' => $getHotelMarkup['arrAgencyMarkupsHotel']['0']['Currency'],
            'MarkUpType' => $getHotelMarkup['arrAgencyMarkupsHotel']['0']['MarkUpType'],
            'IsSameForAll' => 0,
            'StdMarkUpPer' => $getHotelMarkup['arrAgencyMarkupsHotel']['0']['MarkUp'],
            'TaxPer' =>  $getHotelMarkup['arrAgencyMarkupsHotel']['0']['Tax'],
            'DiscAtMarkupPer' => 0,
            'DiscAtMarkupVal' => 0,
            'CommssionType' => 0,
            'CommssionVal' => 0,
            'DiscountPer' => 0,
            'DiscountVal' => 0,
            'DiscountMsg' => 0,
            'Details' => 0,
            'ValidTill' =>$datetime,
            'IsServiceChrgIncludeInTax' => 0,
            'ApproveDate' => $datetime,
            'IsApproved' => 1,
            'IsMarkForDel' => 0,
            'IsActive' => 1,

          );
        }

       if($resultset){
           $queryup2 = $this->objMdl->rv_update($this->table, $hotelMarkupArray, ['MPType=?' => 2,'AccomType=?'=>2]);
            
        }else{
          $queryup2 =  $this->objMdl->rv_insert($this->table, $hotelMarkupArray);  
            
        }



     
    $resultset = $crud->rv_select_static( $this->table,['*'],['isMarkForDel' =>0,'AirType'=>1],['AgencySysId'=> 'DESC']);
    $getFlightMarkup = Zend_Controller_Action_HelperBroker::getStaticHelper("Flight")->getMarkup('IN');

    $flightMarkupArray = array(
        'AgencySysId' => $this->gtxagencysysid,
        'MasterAgencySysId' => $this->gtxagencysysid,
        'MPType' => 1,
        'ItemSourceType' => isset($getFlightMarkup['arrAgencyMarkupsCancellation'][0]['ItemSourceType'])?$getFlightMarkup['arrAgencyMarkupsCancellation'][0]['ItemSourceType']:0,
        'AirType' => $getFlightMarkup['arrAgencyMarkups'][0]['AirType'],
        'IsForCancellation' =>0,
        'CustGrSysId' => 0,
        'Currency' => $getFlightMarkup['arrAgencyMarkups']['0']['Currency'],
        'MarkUpType' => $getFlightMarkup['arrAgencyMarkups']['0']['MarkUpType'],
        'IsSameForAll' => 0,
        'StdMarkUpPer' => $getFlightMarkup['arrAgencyMarkups']['0']['StdMarkUpPer'],
        'TaxPer' =>  $getFlightMarkup['arrAgencyMarkups']['0']['TaxPer'],
        'DiscAtMarkupPer' => 0,
        'DiscAtMarkupVal' => 0,
        'CommssionType' => $getFlightMarkup['arrAgencyMarkups']['0']['CommssionType'],
        'CommssionVal' =>$getFlightMarkup['arrAgencyMarkups']['0']['CommssionVal'],
        'DiscountPer' => 0,
        'DiscountVal' => 0,
        'DiscountMsg' => 0,
        'Details' => 0,
        'ValidTill' =>$datetime,
        'IsServiceChrgIncludeInTax' =>$getFlightMarkup['arrApiServiceTax']['0']['Percentage'],
        'ApproveDate' => $datetime,
        'IsApproved' => 1,
        'IsMarkForDel' => 0,
        'IsActive' => 1,

      );

        if($resultset){
          $queryup3 = $this->objMdl->rv_update($this->table, $flightMarkupArray, ['MPType=?' => 1,'AirType=?'=>1]);
        }else{
          $queryup3 = $this->objMdl->rv_insert($this->table, $flightMarkupArray);  
        }


    $resultset = $crud->rv_select_static( $this->table,['*'],['isMarkForDel' =>0,'AirType'=>2],['AgencySysId '=> 'DESC']);
    $getFlightMarkup = Zend_Controller_Action_HelperBroker::getStaticHelper("Flight")->getMarkup('UK');

    $flightMarkupArray = array(
        'AgencySysId' => $this->gtxagencysysid,
        'MasterAgencySysId' => $this->gtxagencysysid,
        'MPType' => 1,
        'ItemSourceType' => isset($getFlightMarkup['arrAgencyMarkupsCancellation'][0]['ItemSourceType'])?$getFlightMarkup['arrAgencyMarkupsCancellation'][0]['ItemSourceType']:0,
        'AirType' => $getFlightMarkup['arrAgencyMarkups'][0]['AirType'],
        'IsForCancellation' =>0,
        'CustGrSysId' => 0,
        'Currency' => $getFlightMarkup['arrAgencyMarkups']['0']['Currency'],
        'MarkUpType' => $getFlightMarkup['arrAgencyMarkups']['0']['MarkUpType'],
        'IsSameForAll' => 0,
        'StdMarkUpPer' => $getFlightMarkup['arrAgencyMarkups']['0']['StdMarkUpPer'],
        'TaxPer' =>  $getFlightMarkup['arrAgencyMarkups']['0']['TaxPer'],
        'DiscAtMarkupPer' => 0,
        'DiscAtMarkupVal' => 0,
        'CommssionType' => $getFlightMarkup['arrAgencyMarkups']['0']['CommssionType'],
        'CommssionVal' =>$getFlightMarkup['arrAgencyMarkups']['0']['CommssionVal'],
        'DiscountPer' => 0,
        'DiscountVal' => 0,
        'DiscountMsg' => 0,
        'Details' => 0,
        'ValidTill' =>$datetime,
        'IsServiceChrgIncludeInTax' =>$getFlightMarkup['arrApiServiceTax']['0']['Percentage'],
        'ApproveDate' => $datetime,
        'IsApproved' => 1,
        'IsMarkForDel' => 0,
        'IsActive' => 1,

      );

        if($resultset){
          $queryup4 = $this->objMdl->rv_update($this->table, $flightMarkupArray, ['MPType=?' => 1,'AirType=?'=>2]);
        }else{
         $queryup4 =  $this->objMdl->rv_insert($this->table, $flightMarkupArray);  
        }

        $this->_redirect('admin/markup');
    }
    

    /**
     * checklogin() method is used to check admin logedin or not
     * @param Null
     * @return Array 
     */
    public function checklogin() {
        $auth = Zend_Auth::getInstance();
        /*         * ************* check user identity *********** */
        if (!$auth->hasIdentity()) {
            $this->_redirect('admin/index/index');
        }
    }

    /*     * ** logout ********* */

    public function logoutAction() {
        if ($this->getRequest()->getParam('module') == 'admin') {
            $storage = new Zend_Auth_Storage_Session();
            $storage->clear();
            $this->_redirect('admin/index/index');
        } else {
            $this->_redirect('admin/index/index');
        }
    }

    
    }