File: //var/www/html/taxicamera/old/applicationold/controllers/admin/Log.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Log extends MY_Controller {
public function __construct() {
parent::__construct();
//$this->redirect_guest();
$this->load->model('admin/mdocket');
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);
}
public function index()
{
$data = array();
$log_data = $this->mcommon->getLogDetails();
if(!empty($log_data)){
$data['log_list'] = $log_data;
foreach($log_data as $key => $val){
$condition = array('master_user.user_id' => $val['action_done_by']);
$joindata = array('select'=>'master_user.role_id,user_profile.first_name,user_profile.middle_name,user_profile.last_name, master_role.role_name',
'first_table' =>'master_user',
'second_table' =>'user_profile',
'dependency1' =>'master_user.user_id = user_profile.user_id',
'join_type1' =>'inner',
/**********************************/
'third_table' =>'master_role',
'dependency2' =>'master_role.role_id = master_user.role_id',
'join_type2' =>'inner'
);
$action_done_by = $this->mcommon->joinQuery($joindata,$condition,'row','','');
//pr($action_done_by);
if(!empty($action_done_by)){
if(!empty($action_done_by['middle_name'])){
$middle_name = ' '.$action_done_by['middle_name'];
}
else{
$middle_name = '';
}
$data['log_list'][$key]['action_done_by_name'] = $action_done_by['first_name'].$middle_name.' '.$action_done_by['last_name'];
$data['log_list'][$key]['role'] = $action_done_by['role_name'];
}
}
}
else{
$data['log_list'] = '';
}
//pr($data['log_list']);
$data['content'] = 'admin/log/log_list';
$this->_load_view($data);
}
}