Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/luckymerchan/code/management/staff/ |
<?php
$mod = '';
if(isset($CORE->input['ajax'])){
$mod = $CORE->input['ajax'];
}
switch ($mod){
case 'check_fullname':
$name = '';
$staff_id = intval($CORE->input['staff_id']);
if(isset($CORE->input['name'])){
$name = trim($CORE->input['name']);
}
if($name!=''){
if($staff_id>0) {
$row_check = $DB->fetch_row($DB->query("SELECT * FROM tb_staff WHERE staff_fullname = '$name' AND company_id='$v_company_id' AND staff_id <> '$staff_id' "));
}else{
$row_check = $DB->fetch_row($DB->query("SELECT * FROM tb_staff WHERE staff_fullname = '$name' AND company_id='$v_company_id' "));
}
if($row_check){
$arr['status'] = 1;
$arr['fullname'] = $name;
}else{
$arr['status'] = 0;
$arr['fullname'] = '';
}
}else{
$arr['status'] = 0;
$arr['fullname'] = '';
}
echo json_encode($arr);
exit();
break;
case 'search_staff_from_function':
$v_function_id = $CORE->input['fid'];
$q_staff = $DB->query("SELECT * FROM tb_staff WHERE staff_function='$v_function_id' AND company_id='$v_company_id' ORDER BY staff_order");
$list = array();
while ($r_staff = $DB->fetch_row($q_staff)){
$arr['staff_fullname'] = $r_staff['staff_fullname'];
$arr['staff_id'] = $r_staff['staff_id'];
$list[] = $arr;
}
echo json_encode($list);
exit();
break;
case 'search_staff_from_name':
$keyword = trim($CORE->input['keyword']);
$q_staff = $DB->query("SELECT * FROM tb_staff WHERE staff_fullname LIKE '%".$keyword."%' AND company_id='$v_company_id' ORDER BY staff_order ASC LIMIT 10");
$list = array();
while ($r_staff = $DB->fetch_row($q_staff)){
$arr['staff_fullname'] = $r_staff['staff_fullname'];
$arr['staff_id'] = $r_staff['staff_id'];
$arr['staff_email365'] = $r_staff['staff_email365'];
$list[] = $arr;
}
echo json_encode($list);
exit();
break;
}