<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Action_controller.php");
class Truck_or_trailer_history  extends Action_controller{	
	public function __construct(){
		parent::__construct('truck_or_trailer_history');
		$this->collect_base_info();
	}
	// LOAD PAGE QUICK LINK,FILTERS AND TABLE HEADERS
	public function index(){
		// $this->db->from('cw_maintenance_job_schedule');
  //       $this->db->join('cw_vehicle_trip_info', 'cw_vehicle_trip_info.prime_vehicle_info_id = cw_maintenance_job_schedule.vehicle_no','inner');
  //       $this->db->join('cw_vehicle_master', 'cw_vehicle_master.prime_vehicle_master_id = cw_maintenance_job_schedule.vehicle_no','inner');
		// $this->db->join('cw_maintenance_wheel_alignment', 'cw_maintenance_wheel_alignment.prime_maintenance_wheel_alignment_id = cw_maintenance_job_schedule.prime_maintenance_job_schedule_id','inner');

		// $get_data_rslt  =  $this->db->get()->result();
		// print_r($get_data_rslt); die;



		$this->load->view("$this->control_name/manage");
	}
	public function check_log_details(){
		$start_date        = str_replace("/","-",$this->input->post('start_date'));
		$end_date          = str_replace("/","-",$this->input->post('end_date'));
		$from_date         = date('Y-m-d',strtotime($start_date));
		$to_date           = date('Y-m-d',strtotime($end_date));	
		$this->db->from('cw_maintenance_job_schedule');
        $this->db->join('cw_vehicle_trip_info', 'cw_vehicle_trip_info.prime_vehicle_info_id = cw_maintenance_job_schedule.vehicle_no','inner');
        $this->db->join('cw_vehicle_master', 'cw_vehicle_master.prime_vehicle_master_id = cw_maintenance_job_schedule.vehicle_no','inner');
		$this->db->join('cw_maintenance_wheel_alignment', 'cw_maintenance_wheel_alignment.prime_maintenance_wheel_alignment_id = cw_maintenance_job_schedule.prime_maintenance_job_schedule_id','inner');
		$this->db->where('cw_maintenance_job_schedule.date between "'.$from_date.'" AND "'.$to_date.'"');
		// $this->db->group_by('cw_maintenance_job_schedule.date');

		// $this->db->order_by('cw_maintenance_job_schedule.date asc');
		$get_data_rslt  =  $this->db->get()->result();	 
		$tr_line	= "";
			foreach ($get_data_rslt as $key => $value){			
			$tr_line .="<tr>
			<td>".$date               = date('d-m-Y',strtotime($value->date))."</td>
			<td>".$vehicle_no         = $value->vehicle_no."</td>
			<td>".$register_no        = $value->register_no."</td>
			<td>".$horse              = $value->reg_no."</td>
			<td>".$km                 = $value->km."</td>
			<td>".$next_checking_date = date('d-m-Y',strtotime($value->next_checking_date))."</td>
			</tr>";
            }
        	if($get_data_rslt){
			$table_content = "<div style='margin:20px;'>
							<table class='table table-striped table-bordered' id='trip_report'>
								<thead>
									<tr>
									<td>DATE</td>
									<td>FLEET NO</td>
									<td>TRAILER REG</td>
									<td>HORSE</td>
									<td>KM</td>
									<td>SERVICE DATE</td>
									</tr>
								</thead>
								<tbody>
									$tr_line
								</tbody>
							</table>
						</div>";
				echo json_encode(array('success'=>true,'table_content'=>$table_content));
            }else{
			    echo json_encode(array('success'=>false,'message'=>'NO DATA AVAILABLE','table_content'=>$table_content));
		}
    }	
}
?>