File manager - Edit - /home/autoph/public_html/connectv1/app/table/employee.php
Back
<?php include_once("../../cfg/db.php"); /** picture employee id full name company position number */ $search = $db -> escape(trim($_GET['search'])); $offset = $db -> escape(trim($_GET['offset'])); $account_status = $db -> escape(trim($_GET['filter_data'])); if(isset($_GET['limit'])){ $limit = $db -> escape(trim($_GET['limit'])); $offset_limit = " LIMIT ". $offset.",".$limit; }else{ $offset_limit = ""; } $json_arr['rows'] = array(); $admin_id = $db->select('SELECT MIN(id) FROM `employee` WHERE 1 LIMIT 1'); if(isset($_SESSION['user']['id']) && $_SESSION['user']['id'] == $admin_id){ $filter_admin = ""; }else{ $filter_admin = " AND e.id NOT IN($admin_id) "; } $employee_query = "SELECT %s FROM `employee` e INNER JOIN employee_contact ec ON e.employee_id=ec.employee_id INNER JOIN all_suffix ext ON e.`suffix_id`=ext.id INNER JOIN source_company_dealer scd ON e.`company_dealer_id`=scd.id INNER JOIN source_company sc ON sc.id=scd.company_id INNER JOIN source_dealer sd ON sd.id=scd.dealer_id INNER JOIN employee_department ed ON e.`department_id` = ed.id INNER JOIN employee_position ep ON e.`position_id` = ep.id INNER JOIN all_gender ag ON e.gender_id=ag.id INNER JOIN employee_account ea ON e.employee_id = ea.employee_id INNER JOIN employee_role er ON ea.employee_role_id = er.id WHERE concat(e.employee_id,e.first_name,e.middle_name,e.last_name) like '%%%s%%' and e.status = 1 and ea.status = $account_status %s "; $count = " count(e.id) "; $fields = " e.id,er.name as role_name,e.photo,e.employee_id,e.`first_name`, e.`middle_name`, e.`last_name`,ext.suffix_name, sc.name as companyname, sd.name as dealername,ed.department_name, ep.position_name,ea.status "; $empoloyee_list_query = $db -> sql_query(sprintf($employee_query,$fields,$search,$filter_admin)." $offset_limit"); // $empoloyee_list_query_filter_count = $empoloyee_list_query -> num_rows; $employee_list_query_count = $db -> select(sprintf($employee_query,$count,$search,$filter_admin)); while($row = $empoloyee_list_query->fetch_assoc()) { $append_suffix = $row['suffix_name']; if($append_suffix == 'None' ){ $append_suffix = ''; } $fullname = trim($row['first_name'] . ' ' . $row['middle_name'] . ' ' . $row['last_name'] . ' ' . $append_suffix); $json_arr['rows'] = array_merge($json_arr['rows'] , array( array( 'photo'=>$row['photo'], 'id'=>$row['id'], 'employee_id'=>$row['employee_id'], 'fullname'=>$fullname, 'role_name'=>$row['role_name'], 'company'=>$row['companyname'], 'department'=>$row['department_name'], 'position'=>$row['position_name'], 'status'=>$row['status']))) ; } // $json_arr['total'] = $empoloyee_list_query_filter_count; //total number of result // $json_arr['totalNotFiltered'] = $empoloyee_list_query_count; //total number of data $json_arr['total'] = $employee_list_query_count; //total number of result echo json_encode($json_arr); function isNotEmpty($data){ return preg_match('/\S/', $data); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0.01 |
proxy
|
phpinfo
|
Settings