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

class Servicedue extends MY_Controller {
	public function __construct() {
		parent::__construct();
		$this->redirect_guest();
		$this->admin=$this->session->userdata('admin');		
		$this->load->model('admin/mservicedue');
		$this->load->model('admin/mcar');
	}
	
	public function index() {
		$this->_load_list_view();		
	}
	
	private function _load_list_view() {
		$condition = array();
		//$data['cars'] = $this->mservicehistory->getRows('car',$condition);		
		$data['content'] = 'admin/servicedue/list';
		$this->load->view('admin/layouts/index', $data);
	}
	
	public function all_content_list(){
		$s_date = $_POST['start_date'];
		$e_date = $_POST['end_date'];

		$s_date_array = explode('/',$s_date);
	    $start_date = $s_date_array[2]."-".$s_date_array[1]."-".$s_date_array[0];

	    $e_date_array = explode('/',$e_date);
	    $end_date = $e_date_array[2]."-".$e_date_array[1]."-".$e_date_array[0];
	    
		$list = $this->mservicedue->get_datatables($start_date,$end_date);
        $data = array();
        $no = $_POST['start'];
		$i=0;
        foreach ($list as $person) {
            $no++;
            $row = array();	
            $res['car']=$this->mcar->get_details($person[0]);					
			$row[] = $res['car']['car_no'];
			$row[] = $person[1];	
			$row[] = $person[2];
			$row[] = $person[3];
            $data[] = $row;
			$i++;
        }
           //print_r($i); die;
        $output = array(
                        "draw" => $_POST['draw'],
                        "recordsTotal" => $i,
                        "recordsFiltered" => $i,
                        "data" => $data,
                );
        echo json_encode($output);
	}
	
		public function all_content_list1(){
		$s_date = '15/02/2019';
	    $e_date = '30/03/2019';
// 		$s_date = $_POST['start_date'];
// 		$e_date = $_POST['end_date'];
		

		$s_date_array = explode('/',$s_date);
	    $start_date = $s_date_array[2]."-".$s_date_array[1]."-".$s_date_array[0];

	    $e_date_array = explode('/',$e_date);
	    $end_date = $e_date_array[2]."-".$e_date_array[1]."-".$e_date_array[0];
	    
		$list = $this->mservicedue->get_datatables1($start_date,$end_date);
        $data = array();
        $no = $_POST['start'];
		$i=0;
        foreach ($list as $person) {
            $no++;
            $row = array();	
            $res['car']=$this->mcar->get_details($person[0]);					
			$row[] = $res['car']['car_no'];
			$row[] = $person[1];	
			$row[] = $person[2];
			$row[] = $person[3];
            $data[] = $row;
			$i++;
        }
           //print_r($i); die;
        $output = array(
                        "draw" => $_POST['draw'],
                        "recordsTotal" => $i,
                        "recordsFiltered" => $i,
                        "data" => $data,
                );
        echo json_encode($output);
	}
	public function all_content_list_csv(){
		$s_date = $_POST['start_date'];
		$e_date = $_POST['end_date'];

		$s_date_array = explode('/',$s_date);
	    $start_date = $s_date_array[2]."-".$s_date_array[1]."-".$s_date_array[0];

	    $e_date_array = explode('/',$e_date);
	    $end_date = $e_date_array[2]."-".$e_date_array[1]."-".$e_date_array[0];
	    $filename= 'due_service_report'.time().'.csv';

		$list = $this->mservicedue->get_datatables($start_date,$end_date);
		$row1 = array('Car No','Due Transmission','Due Engine','Due Spark Plug');
        $data[] = $row1;
		$i=0;
        foreach ($list as $person) {	
            $row = array();
            $res['car']=$this->mcar->get_details($person[0]);					
			$row[] = $res['car']['car_no'];
			$row[] = $person[1];	
			$row[] = $person[2];
			$row[] = $person[3];
            $data[] = $row;
			$i++;
        }
		@array_to_csv($data,$filename);
        echo $filename;
	}
	
	public function all_details(){
		$job_id = $this->input->post('job_id');		
		$car_id = $this->input->post('car_id');	
		$services = $this->mservicehistory->get_details($job_id);	
		foreach($services as $key=>$service)
		{
			$condition = array("service_id"=>$service['service_id']);			
			$task = $this->mservicehistory->getRows('task',$condition);
			$services[$key]['task'] = $task;
		}
		$result['services'] = $services;
		$car_condition = array("car_id"=>$car_id);
		$car = $this->mservicehistory->getRow('car',$car_condition);
		$result['car'] = $car;
		echo json_encode($result);
	}
}