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/truyentranh/code/admin/uservip/ |
<?php
$keyword = isset($CORE->input['fkeyword']) ? $CORE->input['fkeyword'] : '';
$where = " WHERE a.user_key<>'' AND a.user_key<>'giacbn' AND b.is_vip IN ('active','pending') ";
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 b.vip_date ASC LIMIT $from, $pageSize");
$txt_list_users = '';
$stt = 1;
while($row = $DB->fetch_row($query))
{
update_vip_his($row['user_id']);
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 mt-1"><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 mt-1"><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 ml-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 ml-1"><i class="far fa-comments"></i> Active Comment</a>';
}
$txt_vip = '';
if($row['guest_vip_level']=='vip'){
$txt_vip = '';
}
$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['is_vip'].'</td>
<td>'.date('d-m-Y',strtotime($row['vip_date'])).'</td>
<td>
<a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=users&type=vip_update&user_id='.$row['user_id'].'\',\'VIP\')" class="btn btn-sm btn-primary"><i class="fas fa-user-tie"></i> VIP update</a>
<a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=uservip&type=deactive_vip&user_id='.$row['user_id'].'\',\'Deactive VIP\')" class="btn btn-sm btn-danger"><i class="fas fa-lock"></i> Deactive VIP</a>
<a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=uservip&type=active_vip&user_id='.$row['user_id'].'\',\'Active VIP\')" class="btn btn-sm btn-success mt-1"><i class="fas fa-lock-open"></i> Active VIP</a>
</td>
</tr>';
$stt++;
}
$nav = $print->Pagination($totalPage,$pageNum,'menu','?act=admin&code=users&type=list&fkeyword='.$keyword);
?>