ÿØÿà 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/netphim/code/admin/users/ |
<?php $keyword = isset($CORE->input['fkeyword']) ? $CORE->input['fkeyword'] : ''; $where = " WHERE a.user_key<>'' AND a.user_key<>'giacbn' "; if($keyword!='') { $where .= " AND (b.guest_fullname LIKE '%".$keyword."%' OR a.user_key LIKE '%".$keyword."%' OR b.guest_email LIKE '%".$keyword."%') "; } $pageNum = isset($_GET['pageNum']) ? intval($_GET['pageNum']) : 1; $pageSize = 50; $from = (($pageNum * $pageSize) - $pageSize); $t = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_user a LEFT JOIN tb_guest 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_guest b ON a.user_id=b.user_id ".$where." ORDER BY a.user_jointime DESC LIMIT $from, $pageSize"); $txt_list_users = ''; $stt = 1; while($row = $DB->fetch_row($query)) { if ($row['guest_avatar'] != '' and $row['guest_avatar'] != 'NULL') { $row['user_image'] = $row['guest_avatar']; } else { $row['user_image'] = 'layout/adminlte320rc/dist/img/letter/' . strtolower(substr($row['user_key'], 0, 1)) . '.png'; } $txt_locked=''; if($row['user_status']=='active'){ $txt_locked = '<a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=users&type=login_status&login_status=locked&user_id='.$row['user_id'].'\',\'Locked Login\')" class="btn btn-sm btn-warning"><i class="fas fa-lock"></i> Locked Login</a>'; }else{ $txt_locked = '<a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=users&type=login_status&login_status=active&user_id='.$row['user_id'].'\',\'Active Login\')" class="btn btn-sm btn-warning"><i class="fas fa-unlock-alt"></i> Active Login</a>'; } $txt_locked_comment=''; if($row['user_comment_status']=='active'){ $txt_locked_comment = '<a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=users&type=locked_comment&locked_comment=locked&user_id='.$row['user_id'].'\',\'Locked Comment\')" class="btn btn-sm btn-primary mt-1"><i class="far fa-comments"></i> Locked Comment</a>'; }else{ $txt_locked_comment = '<a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=users&type=locked_comment&locked_comment=active&user_id='.$row['user_id'].'\',\'Active Comment\')" class="btn btn-sm btn-primary mt-1"><i class="far fa-comments"></i> Active Comment</a>'; } $txt_list_users .= '<tr> <td>'.$stt.'</td> <td><img src="'.$row['user_image'].'" class="img-size-32"></td> <td>'.$row['guest_fullname'].'</td> <td>'.$row['user_key'].'</td> <td>'.$row['user_status'].'</td> <td>'.date('d-m-Y',$row['user_jointime']).'</td> <td> <a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=users&type=post&user_id='.$row['user_id'].'\',\'Sá»a\')" class="btn btn-sm btn-success"><i class="fas fa-edit"></i> Update</a> '.$txt_locked.$txt_locked_comment.' <a href="?act=admin&code=users&type=delete&user_id='.$row['user_id'].'" class="btn btn-sm btn-danger mt-1" onclick="return confirm(\'Are you sure want to delete?\');"><i class="far fa-trash-alt"></i> Delete</a> </td> </tr>'; $stt++; } $nav = $print->Pagination($totalPage,$pageNum,'menu','?act=admin&code=users&type=list&fkeyword='.$keyword); ?>