<?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'];
		$service_id=$_POST['service_id'];

		// $s_date = '01/07/2019';
		// $e_date = '13/03/2020';
		$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,$service_id);
	    
		//print_r($list); die;
        $data = array();
        $no = $_POST['start'];
		$i=1;
		if($no>1)
	    {
	      $i=$i*$no+1;
	    }
        foreach ($list as $person) {
            $no++;
            $row = array();	
            $row[]=$i;
            $row[]=$person->service_name;					
			$row[]=$person->car_no;
			$row[]=date("d-m-Y", strtotime($person->next_service_date));
            $data[] = $row;
			$i++;
        }
           //print_r($i); die;
        $output = array(
                        "draw" => $_POST['draw'],
                        "recordsTotal" => $this->mservicedue->count_all($start_date,$end_date,$service_id),
                        "recordsFiltered" => $this->mservicedue->count_filtered($start_date,$end_date,$service_id),
                        "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';
	    if($_POST['service_id']!='')
	    {
	    	$list = $this->mservicedue->get_data_excel($start_date,$end_date,$_POST['service_id']);
	    }
	    else
	    {
			$list = $this->mservicedue->get_data_excel($start_date,$end_date);
		}
		//echo $this->db->last_query(); die;
		
		$row1 = array('SL No','Service Name','Car No','Due Date');
        $data[] = $row1;
		$i=0;
       	foreach ($list as $person) {
           $i++;
            $row = array();	
            $row[]=$i;
            $row[]=$person->service_name;					
			$row[]=$person->car_no;
			$row[]=date("d-m-Y", strtotime($person->next_service_date));
            $data[] = $row;
			
        }
		@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);
	}

	//////////////////////data insert/////////////////////////////
	// public function data_import(){ 
	// 	$CI1 =& get_instance();
 //        $CI1->db->select('*');
 //        $CI1->db->from('job_services');  
 //        $where1 = "service_id IN (7,8,20)";      
 //        $CI1->db->where($where1); 
 //        $query1=$CI1->db->get();
	// 	$jobs = $query1->result_array();
	// 	// echo '<pre>';
	// 	// print_r($jobs); die;
	// 	foreach($jobs as $row){
	// 		$condition['job_id']=$row['job_id'];
	// 		$job_date_data=$this->mcommon->getRow('job_service_date',$condition);
	// 		$udata=array();
	// 		$udata['job_id']=$row['job_id'];
	// 		$udata['service_id']=$row['service_id'];
	// 		$udata['car_id']=$job_date_data['car_id'];
	// 		$udata['service_date']=$job_date_data['service_date'];
	// 		$udata['next_service_date']=$job_date_data['next_service_date'];
	// 		$udata['next_service_date_reminder_before_seven']=$job_date_data['next_service_date_reminder_before_seven'];
	// 		$udata['next_service_date_before_three']=$job_date_data['next_service_date_before_three'];
	// 		$udata['service_end_date']=$job_date_data['service_end_date'];
	// 		$udata['service_end_time']=$job_date_data['service_end_time'];
	// 		$this->mcommon->insert('job_service_date_specific',$udata);
	// 		//echo $this->db->last_query();die;
	// 		}
	// 		echo 'done'; die;
	// }
}