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');
}
}
}