<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
require_once("Secure_Controller.php");
class Revenue_report extends Secure_Controller{
	
	public function __construct(){
		parent::__construct('revenue_report');
		$this->load->model('Revenue_report_model');
	}

	public function index(){
		if(!$this->Appconfig->isAppvalid()){
			redirect('config');
		}
		$this->load->view('revenue_report/manage', $data);
	}
	
	/*
	This Revenue report for all travells
	*/
	public function revenue_report(){
		$start_date    = date("Y-m-d", strtotime($this->input->post('start_date')));
		$end_date      = date("Y-m-d", strtotime($this->input->post('end_date')));
		$owned_by      = $this->Revenue_report_model->revenue_report($start_date,$end_date,1);
		$others        = $this->Revenue_report_model->revenue_report($start_date,$end_date,0);
		$out_catering  = $this->Revenue_report_model->outside_catering($start_date,$end_date);
		
		$revenue_array = array();
		
		$aggregate_amt      = 0;
		$individual_amt     = 0;
		$corporate_amt      = 0;
		$package_amt        = 0;
		$pkg_cat_amt        = 0;
		$agent_amt          = 0;
		$sble_amt           = 0;
		
		
		
		foreach($owned_by as $rslt){
			$booking_type_name      = strtoupper($rslt->booking_type_name);
			$vendor_name            = strtoupper($rslt->vendor_name);
			$book_amount            = $rslt->book_amount;
			$cat_amt                = $rslt->cat_amt;
			$stay_amt               = $rslt->stay_amt;
			
			
			if(($booking_type_name === "AGGREGATE")&& ($vendor_name !== "SBLE")){
				$aggregate_amt += (int)$book_amount;
			}
			if(($booking_type_name === "INDIVIDUAL")&& ($vendor_name !== "SBLE")){
				$individual_amt += (int)$book_amount;
			}
			if(($booking_type_name === "CORPORATE")&& ($vendor_name !== "SBLE")){
				$corporate_amt += (int)$book_amount;
			}
			if(($booking_type_name === "PACKAGE")&& ($vendor_name !== "SBLE")){
				$package_amt += (int)$book_amount;
				$pkg_cat_amt += (int)$cat_amt;
				
			}
			if(($booking_type_name === "TRAVEL AGENTS")&& ($vendor_name !== "SBLE")){
				$agent_amt += (int)$book_amount;
			}
			if($vendor_name === "SBLE"){				
				$sble_amt += (int)$book_amount;
			}
			
			
		}
		
		$ot_aggregate_amt  = 0;
		$ot_individual_amt = 0;
		$ot_corporate_amt  = 0;
		$ot_package_amt    = 0;
		$ot_pkg_cat_amt    = 0;
		$ot_agent_amt      = 0;
		$ot_sble_amt       = 0;
		
		
		foreach($others as $rslt){
			$ot_booking_type_name = strtoupper($rslt->booking_type_name);
			$ot_vendor_name       = strtoupper($rslt->vendor_name);
			$ot_book_amount       = $rslt->book_amount;
			$ot_cat_amt           = $rslt->cat_amt;
			$ot_stay_amt          = $rslt->stay_amt;
			$ot_out_cat_amt       = $rslt->out_cat_amt;
			if(($ot_booking_type_name === "AGGREGATE")&& ($ot_vendor_name !== "SBLE")){
				$ot_aggregate_amt += (int)$ot_book_amount;
			}
			if(($ot_booking_type_name === "INDIVIDUAL")&& ($ot_vendor_name !== "SBLE")){
				$ot_individual_amt += (int)$ot_book_amount;
			}
			if(($ot_booking_type_name === "CORPORATE")&& ($ot_vendor_name !== "SBLE")){
				$ot_corporate_amt += (int)$ot_book_amount;
			}
			if(($ot_booking_type_name === "PACKAGE") && ($ot_vendor_name !== "SBLE")){
				$ot_package_amt += (int)$ot_book_amount;
				$ot_pkg_cat_amt += (int)$ot_cat_amt;
			}
			if(($ot_booking_type_name === "TRAVEL AGENTS") && ($ot_vendor_name !== "SBLE")){
				$ot_agent_amt += (int)$ot_book_amount;
			}
			if($ot_vendor_name === "SBLE"){				
				$ot_sble_amt += (int)$ot_book_amount;
			}
		}
		
		$out_cat = 0;
		foreach($out_catering as $rslt){
			$out_cat      = $rslt->out_cat_amt;
		}
		
		$aggregate_tot     = (int)$aggregate_amt    + (int)$ot_aggregate_amt;
		$individual_tot    = (int)$individual_amt   + (int)$ot_individual_amt;
		$corporate_tot     = (int)$corporate_amt    + (int)$ot_corporate_amt;
		$package_tot       = (int)$package_amt      + (int)$ot_package_amt;
		$agent_tot         = (int)$agent_amt        + (int)$ot_agent_amt;
		$pkg_cat_tot       = (int)$pkg_cat_amt      + (int)$ot_pkg_cat_amt;
		$sble_tot          = (int)$sble_amt         + (int)$ot_sble_amt;
		
		
		$sbltt_total  = (int)$aggregate_amt + (int)$individual_amt + (int)$corporate_amt + (int)$package_amt + (int)$agent_amt + (int)$pkg_cat_amt + (int)$sble_amt + (int)$out_cat;		
		$others_total = (int)$ot_aggregate_amt + (int)$ot_individual_amt + (int)$ot_corporate_amt + (int)$ot_package_amt + (int)$ot_agent_amt + (int)$ot_pkg_cat_amt + (int)$ot_sble_amt;
		
		$total = (int)$sbltt_total + (int)$others_total;
				
		$revenue_array['Aggregate']      = array('sbltt' => $aggregate_amt,'others' => $ot_aggregate_amt,'tot' => $aggregate_tot);
		$revenue_array['Individual']     = array('sbltt' => $individual_amt,'others' => $ot_individual_amt,'tot' => $individual_tot);
		$revenue_array['Corporate']      = array('sbltt' => $corporate_amt,'others' => $ot_corporate_amt,'tot' => $corporate_tot);
		$revenue_array['Package']        = array('sbltt' => $package_amt,'others' => $ot_package_amt,'tot' => $package_tot);
		$revenue_array['pkg_cat']        = array('sbltt' => $pkg_cat_amt,'others' => $ot_pkg_cat_amt,'tot' => $pkg_cat_tot);
		$revenue_array['Travel_Agent']   = array('sbltt' => $agent_amt,'others' => $ot_agent_amt,'tot' => $agent_tot);
		$revenue_array['sble']           = array('sbltt' => $sble_amt,'others' => $ot_sble_amt,'tot' => $sble_tot);
		$revenue_array['total']          = array('sbltt' => $sbltt_total,'others' => $others_total,'tot' => $total);
		$revenue_array['out_cat']        = array('sbltt' => $out_cat);
		
	
		echo json_encode($revenue_array);
	}
	
	
}

?>