HEX
Server: Apache/2.4.41 (Amazon) OpenSSL/1.0.2k-fips PHP/5.6.40
System: Linux ip-172-31-40-18 4.14.146-93.123.amzn1.x86_64 #1 SMP Tue Sep 24 00:45:23 UTC 2019 x86_64
User: apache (48)
PHP: 5.6.40
Disabled: NONE
Upload Files
File: //var/www/html/taxicamera/pmw_live_testing/application/controllers/admin/Dashboard.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Dashboard extends MY_Controller {

	public function __construct() {
		parent::__construct();
		//$this->redirect_guest();
		$this->load->model('admin/mdashboard');
		//pr($this->session->userdata('admin'));		
		if($this->session->userdata('admin') != 1){
			redirect('admin');
			die();
		}
		
	}
	public function index() { 
	    //echo $this->session->userdata('user_data');die;
		$this->_load_dashboard_view();
	}
	/********************* Sreela (14/11/2019) *********************/

	/****************** Get active driver count ********************/

	public function total_active_driver() { 
		$active_driver_cnt	= array();
		$cond_act_dr 		= array("role_id" =>'2',"is_active" =>1,"status" =>1);
		$active_driver_cnt	= $this->mdashboard->actv_dr_cnt($cond_act_dr);

		return $active_driver_cnt;

	}

	/****************** Get active driver count end ********************/

	/****************** Get daily inspection fault  ********************/

	public function daily_inspection_fault() { 
		$daily_inspcn_fault	= array();
		//$cnt_date			= date('2019-09-19');
		$cnt_date			= date('Y-m-d');
		$newdate 			= date("Y-m-d",strtotime($cnt_date."-7 day")); //last 7 days dt
		$daily_inspcn_fault	= $this->mdashboard->daily_inspcn_fault($cnt_date,$cnt_date);

		return $daily_inspcn_fault;

	}

	/****************** Get daily inspection fault end ********************/

	/****************** Get accident fault/ not fault count  ********************/

	public function accdnt_fault_notfault_count() { 
		$accdnt_fault_notfault_cnt	= array();
		//$cnt_date					= date('2019-09-19');
		$cnt_date					= date('Y-m-d');
		$newdate 					= date('Y-m-d', strtotime('-1 year', strtotime($cnt_date)) );//last 1 year dt		
		$accdnt_fault_cnt			= $this->mdashboard->accdnt_fault_notfault_cnt($newdate,$cnt_date,'fault');
		$accdnt_notfault_cnt		= $this->mdashboard->accdnt_fault_notfault_cnt($newdate,$cnt_date,'not fault');

		$accdnt_fault_notfault_cnt['fault']		= $accdnt_fault_cnt;
		$accdnt_fault_notfault_cnt['not_fault']	= $accdnt_notfault_cnt;
		return $accdnt_fault_notfault_cnt;

	}

	/****************** Get accident fault/ not fault count end ********************/

	private function _load_dashboard_view() {
		$data		= array();

		$data['datatotal_active_driver']	= $this->total_active_driver();
		$data['daily_inspection_fault']		= $this->daily_inspection_fault();
		$data['accdnt_fault_notfault_cnt']	= $this->accdnt_fault_notfault_count();
		$data['driver_due_data']			= $this->mdashboard->get_driver_due_data();
		$data['driver_due_data_not_paid'] = $this->mdashboard->get_driver_due_data_not_paid();
		$data['total_bond']					= $this->mdashboard->get_total_bond();
		$data['total_cash_in_hand']			= $this->mdashboard->get_total_cash_in_hand();
		$data['ongoing_shift_details']		=$this->mdashboard->get_ongoing_shift_details();
		$data['shift_not_started_details']		=$this->mdashboard->get_shift_not_started_details();
		
		
		//pr($data);
		$data['content'] = 'admin/dashboard';			
		$data['title']= 'Dashboard';
		$this->load->view('admin/layouts/index', $data);
	}

	public function get_settlement_due_report(){

		$settlement_data  = $this->mdashboard->get_settlement_due_report();
		$return_data = array('status'=>true,'settlement_data'=>$settlement_data);
		echo json_encode($return_data);
	
	
	}

	public function get_roster_report(){

		$roster_data  = $this->mdashboard->get_roster_report();
		$return_data = array('status'=>true,'roster_data'=>$roster_data);
		echo json_encode($return_data);
	
	
	}

	public function get_job_report(){

		$job_data  = $this->mdashboard->get_job_report();
		$return_data = array('status'=>true,'job_data'=>$job_data);
		echo json_encode($return_data);
	
	
	}

	public function shift_delete($shift_id){
		
		$driver_shift_details =$this->mcommon->getRow('driver_shift_details',array('shift_id'=>$shift_id));
		// echo $this->db->last_query();die;
		// print_r($driver_shift_details);die;
		$roster_driver_mapping = $this->mcommon->getRow('roster_driver_maping',array('roster_driver_id'=>$driver_shift_details['roster_driver_id']));
		$this->mcommon->update('api_token',array('user_id'=>$roster_driver_mapping['driver_id']),array('token_key'=>''));
		//echo $this->db->last_query();die;
		$result = $this->mcommon->delete('driver_shift_details',array('shift_id'=>$shift_id));
		if($result)
		{
			$this->session->set_flashdata('success_msg','Shift Deleted Successfully');
			redirect('admin/dashboard');
		}else{
			$this->session->set_flashdata('error_msg','Oops!Something went wrong...');
			redirect('admin/dashboard');
		}

	}

	

	
	
}