<?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() { 

		//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';
				$new_date_start = $this->input->post('sales_start');
				$new_date_end = $this->input->post('sales_end');
				$payment = $this->input->post('payment_type');
				
				$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($new_date_start, $new_date_end, $payment);  

				foreach ($this->data['orders'] as $sales) {
					$final_amount = 0;
					if($sales->payment_type != 'free order'){
						$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'];
				$this->data['payment'] = $payment;

			} else {

				//fetch all orders
				$config['total_rows'] = $this->order_m->record_count();  
				$this->pagination->initialize($config);
		   		$this->data['orders'] = $this->order_m->report_get_all_orders();  

				foreach ($this->data['orders'] as $sales) {
					$final_amount = 0;
					if($sales->payment_type != 'free order'){
						$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['payment'] = '';

			}

		} else {	

			//fetch all orders
			$config['total_rows'] = $this->order_m->record_count();  
			$this->pagination->initialize($config);
	   		$this->data['orders'] = $this->order_m->report_get_all_orders();  

			foreach ($this->data['orders'] as $sales) {
				$final_amount = 0;
				if($sales->payment_type != 'free order'){
					$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['payment'] = '';

		}

		$this->data['total_sales_amount'] = $this->total_sales_amount;
		$this->data["options"] = $this->db->distinct()->select('payment_type')->from('orders')->get()->result();

		//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');	 
		
    }
	
			
}