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

class Tyreservicereport extends MY_Controller {
	public function __construct() {
		parent::__construct();
		$this->redirect_guest();
		$this->admin=$this->session->userdata('admin');		
		$this->load->model('admin/mtyreservicereport');
	}
	
	public function index() {	
		$this->_load_list_view();		
	}
	
	private function _load_list_view() {
		$condition = array();
		$data['cars'] = $this->mtyreservicereport->getRows('car',$condition,'car_no','asc');		
		$task_condition = array("service_id"=>11);
		$data['tasks'] = $this->mtyreservicereport->getRows('task',$task_condition);
		$data['content'] = 'admin/tyreservicereport/list';
		$this->load->view('admin/layouts/index', $data);
	}
	
	public function all_content_list(){
		$start_date = $_POST['start_date'];		
		$start_date_array = explode('/',$start_date);
		$newStartDate = $start_date_array[2]."-".$start_date_array[1]."-".$start_date_array[0];
				
		$end_date = $_POST['end_date'];	
		$end_date_array = explode('/',$end_date);
		$newEndDate = $end_date_array[2]."-".$end_date_array[1]."-".$end_date_array[0];
		
		$car_id = $_POST['car_id'];
		$task_id = $_POST['task_id'];
		
		$list = $this->mtyreservicereport->get_datatables($newStartDate,$newEndDate,$car_id,$task_id);
		
		//print_r($list);exit;
		
        $data = array();
        $no = $_POST['start'];
		$i=1;
        foreach ($list as $person) {
            $no++;
            $row = array();						
			$row[] =$no;
			$row[] = $person->car_no;
			$row[] = $person->service_date;	
			$row[] = $person->name;	
            $data[] = $row;
			$i++;
        }
        $output = array(
                        "draw" => $_POST['draw'],
                        "recordsTotal" => $this->mtyreservicereport->count_all($newStartDate,$newEndDate,$car_id,$task_id),
                        "recordsFiltered" => $this->mtyreservicereport->count_filtered($newStartDate,$newEndDate,$car_id,$task_id),
                        "data" => $data,
                );
        echo json_encode($output);
	}

	public function all_content_list_csv(){

		$start_date = $_POST['start_date'];		
		$start_date_array = explode('/',$start_date);
		$start_date = $start_date_array[2]."-".$start_date_array[1]."-".$start_date_array[0];
				
		$end_date = $_POST['end_date'];	
		$end_date_array = explode('/',$end_date);
		$end_date = $end_date_array[2]."-".$end_date_array[1]."-".$end_date_array[0];
		
		$car_id = $_POST['car_id'];
		$task_id = $_POST['task_id'];
	
        $filename= 'type_service_report'.time().'.csv';


        $this->db->select('car.car_no,admins.name,DATE_FORMAT(job_service_date.service_date, "%d/%m/%Y") service_date');
        $this->db->from('job');		
		$this->db->join('job_service_date', 'job_service_date.job_id = job.job_id', 'left');
		$this->db->join('assign_job', 'assign_job.job_id = job.job_id', 'left');
		$this->db->join('mechanic_job_task', 'mechanic_job_task.job_id = job.job_id', 'left');
		$this->db->join('car', 'car.car_id = job.car_id', 'left');
		$this->db->join('admins', 'admins.admin_id = assign_job.mechanic_id', 'left');
		if($car_id!=0)
		{
			$this->db->where("job.car_id",$car_id);	
		}
		$this->db->where("job.job_status",2);
        if($task_id!=0)	
		{	$this->db->where("mechanic_job_task.service_id",11);		
			$this->db->where("mechanic_job_task.task_id",$task_id);
		}else{
			$this->db->where("mechanic_job_task.service_id",11);	
		}
		$this->db->where("assign_job.assign_status",1);
		$this->db->where("job_service_date.service_date>=",$start_date);
		$this->db->where("job_service_date.service_date<=",$end_date);
        $query = $this->db->get();

       //echo $query = $this->db->last_query(); die;

        @query_to_csv($query,TRUE,$filename);
        echo $filename;

	}
}