GRAYBYTE WORDPRESS FILE MANAGER8431

<?php
class Report extends Basecontroller
{
	public function __construct()
	{
		parent::__construct();

		$this->load->model('order/Product_model', 'Product');
		$this->load->model('users/Users_model', 'Users');
		$this->controller_name = "report";
		if(!$this->session->userdata('is_login')) { redirect('sessions','refresh'); }
    }

	public function index()
	{	
		redirect($this->controller_name.'/reportList');		
    }

	public function reportList(){
		$data = array();
		$data['title'] = "Report";
		$filter_date = $this->input->get('date') ? $this->input->get('date') : '';
		$filter_date = date('Y-m-d', strtotime($filter_date));//.'+6 hours'
		
		$orderData = $this->Product->getOrderFilter($filter_date);
		
		$order_details_data  = array();
		$water_deti_array = array();
		$first_order_id = 0;
		$last_order_id = 0;
		$Total_Amt = 0;
		$order_bill_value = array();
		foreach($orderData as $key => $value) {
			$order_bill_value[] = array(
				'order_id' => $value->order_id,
				'total_amount' => $value->total_amount,
				'payment_mode' => $value->payment_mode,
			);
			if($key == 0){
				$last_order_id = $value->order_id;
			}
			$first_order_id = $value->order_id;

			$order_details = $this->Product->getProductOrder($value->order_id);
			if(empty($order_details)){
				unset($orderData[$key]);
				continue;
			}

			foreach ($order_details as $_value) {
				$Total_Amt += $_value->price;
			}

			$order_details_data[] = $order_details; 
			$user_id = $order_details[0]->user_id > 0 ? $order_details[0]->user_id : 0;
			
			$water_deti = $this->Users->getUserData($user_id);
			$water_deti_array[] =array(
				'user_name' => $water_deti->user_name,
				'user_email' => $water_deti->user_email,
				'user_phone' => $water_deti->user_phone,
				'user_profile_name' => $water_deti->user_profile_name,
				'order_id' => $value->order_id,
			); 
		}

		$_order_details_data = array();
		$billValuePerOrder = 0;
		foreach ($order_details_data as $key => $value) {
			foreach ($value as $_value) {
				$_order_details_data[]  = array(
					'id' => $_value->id,
					'product_name' => $_value->product_name,
					'quantity' => $_value->quantity,
					'price' => $_value->price,
					'order_id' => $_value->order_id,
				);
			}
		
		}

	
		$data['order_details'] = $_order_details_data;
		$data['order_bill_value'] = $order_bill_value;
		$data['water_deti'] = $water_deti_array;
		$data['Total_Amt'] = $Total_Amt;
		$data['first_order_id'] = $first_order_id;
		$data['last_order_id'] = $last_order_id;

	


		// echo "<pre>";print_r($data);exit;


		/*
			$data['order'] = $this->Product->getTodoList(array('limit'=>1000));
			$Total_Amt = 0;
			$Total_Amt_val = 0;
			$first_order_id = 0;
			$last_order_id = 0;
			echo "<pre>";
			print_r($data['order']);
			echo "<hr>";
			
			foreach ($data['order'] as $key => $value) {
				if($filter_date){
					// echo "strtotime ".strtotime($filter_date)."		filter_date ".$filter_date."		created_date ".$created_date."<br>";

					$filter_date = date('Y-m-d H:i:s', strtotime($filter_date.'+6 hours'));
					$filter_date = strtotime($filter_date);

					$created_date = date('Y-m-d H:i:s', strtotime($value->doc));
					$created_date = strtotime($created_date);
					
					if($filter_date >= $created_date){
						echo "sourav37 ".$value->id;
						unset($data['order'][$key]);
					}
				}

				// $order_details = $this->Product->getProductOrder($value->order_id);
				// $value->order_items = $order_details;
				// $user_id = $order_details[0]->user_id > 0 ? $order_details[0]->user_id : 0;
				// $value->water_deti = $this->Users->getUserData($user_id);

				$data['Total_Amt'] += $value->total_amount;
				$data['Total_Amt_val'] += $value->total_amount;
				if($first_order_id == 0){
					$data['first_order_id'] = $value->order_id;
				}
				$data['last_order_id'] = $value->order_id;
			}

			echo "sourav<pre>";
			print_r($data['order']);
			exit;
			

			if($filter_date ==''){
				$data['order'] = array();
			}

		*/
		
		$this->template->admin('report/report/report_lists', $data);
	}
}