File: //var/www/html/pmw24/pmw_live_testing/app/application/controllers/admin/Todayavailableuserlist.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Todayavailableuserlist extends MY_Controller {
public function __construct() {
parent::__construct();
$this->redirect_guest();
$this->admin=$this->session->userdata('admin');
$this->load->model('admin/mjob');
}
public function index() {
$this->_load_list_view();
}
private function _load_list_view() {
$data['admin'] = $this->admin;
$data['content'] = 'admin/usersetting/todaylist';
$this->load->view('admin/layouts/index', $data);
}
public function all_content_list(){
$mechanic_condition = array("role_id"=>14,"status"=>1);
$mechanics = $this->mjob->getRows('admins',$mechanic_condition);
$date = date('Y-m-d');
$condition = array('available_date'=>$date);
$off_mechanics = $this->mjob->getRows('user_roaster',$condition);
$new_off_mechanic = array();
foreach($off_mechanics as $off_mechanic)
{
$new_off_mechanic[] = $off_mechanic['mechanic_id'];
}
$new_mechanic = array();
foreach($mechanics as $mechanic)
{
$new_mechanic[] = $mechanic['admin_id'];
}
$roasted_mechanic_list = array_diff($new_mechanic,$new_off_mechanic);
$new_mechanic_list = array();
foreach($roasted_mechanic_list as $key_m=>$roasted_mechanic)
{
$reassign_mechanic_condition = array("admin_id"=>$roasted_mechanic);
$reassign_mechanic = $this->mjob->getRow('admins',$reassign_mechanic_condition);
$new_mechanic_list[$key_m] = $reassign_mechanic;
}
//$list = $this->mtodayusersetting->get_datatables();
$data = array();
$no = $_POST['start'];
$i=1;
//print_r($new_mechanic_list);exit;
foreach ($new_mechanic_list as $person) {
$row = array();
$row[]=$i;
$row[] = $person['name'];
$row[] = $person['username'];
$row[] = $person['address'];
$row[] = $person['phoneno'];
$role_condition = array('role_id'=> $person['role_id']);
$role= $this->mjob->getRow('roles',$role_condition);
$row[] = $role['role_name'];
$admin = $this->admin;
$CI =& get_instance();
$CI->db->select('*');
$CI->db->from('role_menu');
$CI->db->join('menu', 'menu.menu_id = role_menu.menu_id', 'left');
$CI->db->where('role_id',$admin['role_id']);
$CI->db->where('parent_id',12);
$query=$CI->db->get();
$menus = $query->result_array();
$status_result = $this->searcharray('Status', menu_name, $menus);
$edit_result = $this->searcharray('Edit', menu_name, $menus);
if(!empty($status_result))
{
$row[] = ($person['status']==1?'<a class="cstm_view_status btn btn-success" id="active" href="javascript:void(0)" title="'.$person['admin_id'].'"><span class="glyphicon glyphicon-ok"></span></a>':'<a class="cstm_view_status btn btn-danger" id="inactive" href="javascript:void(0)" title="'.$person['admin_id'].'"><span class="glyphicon glyphicon-remove"></span></a>');
}
if(!empty($edit_result)){
$row[] = '<a href="'.base_url('admin/usersetting/details/'.$person['admin_id']).'" title="Edit" class="btn btn-info"><span class="glyphicon glyphicon-pencil"></span></a>';
}
$data[] = $row;
$i++;
}
$output = array(
"draw" => $_POST['draw'],
//"recordsTotal" => $this->mtodayusersetting->count_all(),
//"recordsFiltered" => $this->mtodayusersetting->count_filtered(),
"data" => $data,
);
echo json_encode($output);
}
private function searcharray($value, $key, $array) {
foreach ($array as $k => $val) {
if ($val[$key] == $value) {
return $val;
}
}
return null;
}
}