<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Sales_report extends Admin_Controller {

	private $total_sales_amount = 0;
		
	function __construct() {
		parent::__construct();	
		$this->load->model('order_m');  
		$this->load->model('order_detail_m'); 
		$this->load->model('configuration_m');  
		$this->load->model('customer_m');  
	}
		
	//this is to list all orders
	public function index() { 

		$this->session->unset_userdata('report_sales_start');
		$this->session->unset_userdata('report_sales_end');

		//pagination in action. 100 results per page 
		$this->load->library('pagination');
		$config['base_url'] = base_url() . 'admin/sales_report/index'; 
		$config['per_page'] = 100;
		$config["uri_segment"] = 4; 

		if ($this->input->post('submit')) {

			if($_POST['sales_start'] && $_POST['sales_end']) {

				$date_start = explode('-', $this->input->post('sales_start'));
				$new_date_start = $date_start[2] . '-' . $date_start[1] . '-' . $date_start[0];
				
				$date_end = explode('-', $this->input->post('sales_end'));
				$new_date_end = $date_end[2] . '-' . $date_end[1] . '-' . $date_end[0] . ' 23:59:59';

				$this->session->set_userdata('report_sales_start', $new_date_start);
				$this->session->set_userdata('report_sales_end', $new_date_end);
				
				$config['total_rows'] = $this->order_m->record_count_search_date($new_date_start, $new_date_end); 

				$this->pagination->initialize($config);
				
				$this->data['orders'] = $this->order_m->find_order_by_date($config["per_page"], $this->uri->segment(4), $new_date_start, $new_date_end);  

				foreach ($this->data['orders'] as $sales) {
					$final_amount = 0;
					if($sales->payment_type != 'free order'){
		                $sales_total = $sales->total_amount;
		                $sales_total = $sales_total + $sales->ppn;
		                $sales_total = $sales_total + $sales->shipping_fee;
		                $sales_total = $sales_total - $sales->free_shipping_fee;
		                $sales_total = $sales_total - $sales->redeemed_voucher_amount;
		                $sales_total = $sales_total - $sales->minus_reward_amount; 
		                $final_amount = $sales_total;
						// $final_amount = $sales->total_amount;
					}
					$this->total_sales_amount = $this->total_sales_amount+ $final_amount;
				}

				$this->data['sales_start'] = $_POST['sales_start'];
				$this->data['sales_end'] = $_POST['sales_end'];

			} else {

				//fetch all orders
				$config['total_rows'] = $this->order_m->report_record_count();  
				$this->pagination->initialize($config);
		   		$this->data['orders'] = $this->order_m->report_get_all_orders($config["per_page"], 
				$this->uri->segment(4));  

				foreach ($this->data['orders'] as $sales) {
					$final_amount = 0;
					if($sales->payment_type != 'free order'){
		                $sales_total = $sales->total_amount;
		                $sales_total = $sales_total + $sales->ppn;
		                $sales_total = $sales_total + $sales->shipping_fee;
		                $sales_total = $sales_total - $sales->free_shipping_fee;
		                $sales_total = $sales_total - $sales->redeemed_voucher_amount;
		                $sales_total = $sales_total - $sales->minus_reward_amount; 
		                $final_amount = $sales_total;
						// $final_amount = $sales->total_amount;
					}
					$this->total_sales_amount = $this->total_sales_amount+ $final_amount;
				}	

				$this->data['sales_start'] = '';
				$this->data['sales_end'] = '';

			}

		} else {	

			//fetch all orders
			$config['total_rows'] = $this->order_m->report_record_count();  
			$this->pagination->initialize($config);
	   		$this->data['orders'] = $this->order_m->report_get_all_orders($config["per_page"], 
			$this->uri->segment(4));  

			foreach ($this->data['orders'] as $sales) {
				$final_amount = 0; 
				if($sales->payment_type != 'free order'){
	                $sales_total = $sales->total_amount;
	                $sales_total = $sales_total + $sales->ppn;
	                $sales_total = $sales_total + $sales->shipping_fee;
	                $sales_total = $sales_total - $sales->free_shipping_fee;
	                $sales_total = $sales_total - $sales->redeemed_voucher_amount;
	                $sales_total = $sales_total - $sales->minus_reward_amount; 
	                $final_amount = $sales_total;
					// $final_amount = $sales->total_amount;
				}
				$this->total_sales_amount = $this->total_sales_amount + $final_amount;
			}	

			$this->data['sales_start'] = '';
			$this->data['sales_end'] = '';

		}

		$this->data['total_sales_amount'] = $this->total_sales_amount;

		//load view
		$this->data['subview'] = 'admin/statistic/sales_report';
		$this->load->view('admin/templates/header', $this->data_header); 
		$this->load->view('admin/_layout_main', $this->data);
		$this->load->view('admin/templates/footer');	 
		
	}
	
	public function excel_export() {
		
		$this->load->library('excel'); 
		header("Content-type: application/vnd-ms-excel");
		header("Content-Disposition: attachment; filename=indolok_salesorder_report.xls");

		$new_date_start = $this->session->userdata('report_sales_start');
		$new_date_end = $this->session->userdata('report_sales_end');

		$data['orders'] = $this->order_m->find_order_filter_date($new_date_start, $new_date_end); 

		$this->load->view('admin/statistic/salesorder_excel_report', $data);
	}		
}