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

class Rwcrgexpery extends MY_Controller {
	public function __construct() {
		parent::__construct();
		$this->redirect_guest();
		$this->admin=$this->session->userdata('admin');		
		$this->load->model('admin/mrwcrgexpery');
	}
	
	public function index() {	
		$this->_load_list_view();		
	}
	
	private function _load_list_view() {
		$condition = array();
		$data['cars'] = $this->mrwcrgexpery->getRows('car',$condition,'car_no','asc');		
		$data['content'] = 'admin/rwcrgexpery/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'];
		$rcrg = $_POST['rcrg'];
		if($rcrg == "rwc")
		{
			$list = $this->mrwcrgexpery->get_datatables_rwc($newStartDate,$newEndDate,$car_id);
		}else if($rcrg == "rg"){
			$list = $this->mrwcrgexpery->get_datatables($newStartDate,$newEndDate,$car_id);
		}else{
			$list = $this->mrwcrgexpery->get_datatables_all($newStartDate,$newEndDate,$car_id);
		}
		
        $data = array();
        $no = $_POST['start'];
		$i=1;
        foreach ($list as $person) {
            $no++;
            $row = array();						
			$row[] =$no;
			$row[] = $person->car_no;
			$row[] = $person->registration_expiry_date;	
			$row[] = $person->registration_due_month;		
            $data[] = $row;
			$i++;
        }
		
		
		if($rcrg == "rwc")
		{
			$count = $this->mrwcrgexpery->count_all_rwc($newStartDate,$newEndDate,$car_id);
			$count_filterd = $this->mrwcrgexpery->count_filtered_rwc($newStartDate,$newEndDate,$car_id);
		}else if($rcrg == "rg"){
			$count = $this->mrwcrgexpery->count_all($newStartDate,$newEndDate,$car_id);
			$count_filterd = $this->mrwcrgexpery->count_filtered($newStartDate,$newEndDate,$car_id);
		}else{
			$count = $this->mrwcrgexpery->count_all_all($newStartDate,$newEndDate,$car_id);
			$count_filterd = $this->mrwcrgexpery->count_filtered_all($newStartDate,$newEndDate,$car_id);
		}
        $output = array(
                        "draw" => $_POST['draw'],
                        "recordsTotal" => $count,
                        "recordsFiltered" => $count_filterd,
                        "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'];
		$rcrg = $_POST['rcrg'];  

        if($rcrg == "rwc")
		{
			//$list = $this->mrwcrgexpery->get_datatables_rwc($newStartDate,$newEndDate,$car_id);

			    $this->db->select('car.car_no,DATE_FORMAT(car.registration_expiry_date, "%d/%m/%Y") "Registration Expiry Date",DATE_FORMAT(car.registration_due_month, "%d/%m/%Y") "RWC Due"');
		        $this->db->from('car');			
				$this->db->where("registration_due_month>=",$start_date);
				$this->db->where("registration_due_month<=",$end_date);	
				if($car_id != '')
				{
					$this->db->where("car_id",$car_id);
				}
              $query = $this->db->get();
             

		}else if($rcrg == "rg"){
			//$list = $this->mrwcrgexpery->get_datatables($newStartDate,$newEndDate,$car_id);
			           $this->db->select('car.car_no,DATE_FORMAT(car.registration_expiry_date, "%d/%m/%Y") "Registration Expiry Date",DATE_FORMAT(car.registration_due_month, "%d/%m/%Y") "RWC Due"');
				        $this->db->from('car');						
						$this->db->where("registration_expiry_date>=",$start_date);
						$this->db->where("registration_expiry_date<=",$end_date);	
						if($car_id != '')
						{
							$this->db->where("car_id",$car_id);
						}
					  $query = $this->db->get();
		}else{
			    //$list = $this->mrwcrgexpery->get_datatables_all($newStartDate,$newEndDate,$car_id);

		                $this->db->select('car.car_no,DATE_FORMAT(car.registration_expiry_date, "%d/%m/%Y") "Registration Expiry Date",DATE_FORMAT(car.registration_due_month, "%d/%m/%Y") "RWC Due"');
		                 $this->db->from('car');
				
						if($car_id == '')
						{
							
							$where = "registration_expiry_date between '".$start_date."' AND '".$end_date."'
								OR registration_due_month between '".$start_date."' AND '".$end_date."'";	
						}else{
							$where = "registration_expiry_date between '".$start_date."' AND '".$end_date."' AND car_id = ".$car_id."
								OR registration_due_month between '".$start_date."' AND '".$end_date."' AND car_id = ".$car_id;
						}
						
						$this->db->where($where);
					   $query = $this->db->get();

		}



	
        $filename= 'rwcrg_expiry_report'.time().'.csv';


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

        @query_to_csv($query,TRUE,$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);
	}
}