ÿØÿà JFIF ÿÛ „ ( %"1"%)+...383,7(-.-
![]() 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/thietkeweb2/code/admin/users/ |
<?php $keyword = isset($CORE->input['fkeyword']) ? $CORE->input['fkeyword'] : ''; $where = " WHERE a.user_key<>'' "; if($keyword!='') { $where .= " AND (b.staff_fullname LIKE '%".$keyword."%' OR a.user_key LIKE '%".$keyword."%' OR b.staff_email LIKE '%".$keyword."%') "; } $pageNum = isset($_GET['pageNum']) ? intval($_GET['pageNum']) : 1; $pageSize = 100; $from = (($pageNum * $pageSize) - $pageSize); $t = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_user a LEFT JOIN tb_staff b ON a.user_id=b.user_id ".$where)); $total = $t['total']; $totalPage = ceil($total / $pageSize); $query = $DB->query("SELECT a.*,b.* FROM tb_user a LEFT JOIN tb_staff b ON a.user_id=b.user_id ".$where." ORDER BY b.staff_order,b.staff_status LIMIT $from, $pageSize"); $txt_list_users = ''; $stt = 1; while($row = $DB->fetch_row($query)) { if($row['user_image']!='' and $row['user_image']!='NULL' and file_exists('upload/user/'.$row['user_image'])) { $row['user_image'] = 'upload/user/'.$row['user_image']; }else{ $row['user_image'] = 'layout/adminlte320rc/dist/img/letter/'.strtolower(substr($row['user_key'],0,1)).'.png'; } $txt_list_users .= '<tr> <td>'.$stt.'</td> <td><img src="'.$row['user_image'].'" class="img-size-32"></td> <td>'.$row['staff_fullname'].'</td> <td>'.$row['user_key'].'</td> <td>'.$row['staff_email'].'</td> <td>'.$arr_group_user[$row['staff_group']].'</td> <td> <a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=users&type=post&staff_id='.$row['staff_id'].'\',\'Sá»a\')" class="btn btn-sm btn-warning"><i class="fas fa-edit"></i> Sá»a</a> <a href="?act=admin&code=users&type=delete&staff_id='.$row['staff_id'].'" class="btn btn-sm btn-danger" onclick="return confirm(\'Are you sure want to delete?\');"><i class="far fa-trash-alt"></i> Xóa</a> </td> </tr>'; $stt++; } $nav = $print->Pagination($totalPage,$pageNum,'menu','?act=admin&code=users&type=list&fkeyword='.$keyword); ?>