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

class Track_driver extends MY_Controller {
	public function __construct() {
		parent::__construct();
		//$this->redirect_guest();
		$this->admin=$this->session->userdata('admin');		
		$this->load->model('admin/mrole');

		
		if($this->session->userdata('admin') != 1)
		{
			redirect('admin');
			
		}
		
	}


	// Default load function for header and footer inculded
	private function _load_view($data) {
		$this->load->view('admin/layouts/index',$data);
	}	


	/*
	author: soumya hazra
	purpose: Role Listing
	date: 9-9-2019
	*/
	public function index() { 
		$result = array();
		// $result['roles'] = $this->mrole->get_role();		
		$result['get_inactive_role'] = $this->mrole->get_inactive_role();		
		$result['content']='admin/track_driver/track_driver';
		$this->_load_view($result);
				
	}
	public function getTrakerdata(){
		$traker_data	= array();
		$joindata   	= array('select'        =>"driver_tracking.last_lat,driver_tracking.last_lon,DSD.shift_no,master_car.registration_no,master_user.dc_no,CONCAT(user_profile.first_name,' ',ifnull(user_profile.middle_name,''),' ',user_profile.last_name) as fullname,date_format(ifnull(driver_tracking.updated_ts,driver_tracking.created_ts),'%d/%m/%Y %H:%i:%s') as last_updated",
                            'first_table'   =>'driver_tracking',
                            'second_table'  =>'master_car',
                            'dependency1'   =>'driver_tracking.car_id = master_car.car_id',
                            'join_type1'    =>'left',                  
                        /********************************/ 
                         	'third_table'   =>'driver_shift_details DSD',
                            'dependency2'   =>'driver_tracking.shift_id = DSD.shift_id',
                            'join_type2'    =>'left',
                            
                        /*********************************/   
                            'forth_table'   =>'roster_driver_maping',
                            'dependency3'   =>'roster_driver_maping.roster_driver_id = DSD.roster_driver_id',
                            'join_type3'    =>'left',
                         /********************************/ 
                         	'fifth_table'   =>'master_user',
                            'dependency4'   =>'master_user.user_id = roster_driver_maping.driver_id',
                            'join_type4'    =>'left',
                        /*********************************/   
                            'sixth_table'   =>'user_profile',
                            'dependency5'   =>'user_profile.user_id = master_user.user_id',
                            'join_type5'    =>'left'
                        );
		$cond				= array();
        $traker_data     	= $this->mcommon->joinQuery($joindata,$cond,'result','','');
        //pr($traker_data);
        echo json_encode($traker_data);exit;
	}
}