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/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;
	}
	
	
}