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/admin.adimi/code/management/infohosting/ |
<?php
$type2 = (isset($CORE->input['type2']) && $CORE->input['type2']>0) ? $CORE->input['type2'] : 0;
$where = " WHERE infohosting_id>0 ";
$s = array();
$param_search = '';
if(isset($CORE->input['s'])){
$s = $CORE->input['s'];
foreach ($s as $key=>$val){
if(trim($val)!='') {
$where .= " AND ".$key." LIKE '%".$val."%' ";
$param_search .= '&s[' . $key . ']=' . $val;
}
}
}
switch ($type2){
default:
$where .= "";
break;
case '1':
$time_check_month = time();
$txt_check_month = date('Y-m-d',$time_check_month);
$where .= " AND infohosting_end>'".$txt_check_month."' ";
break;
case '2':
$time_check_month = time();
$txt_check_month = date('Y-m-d',$time_check_month);
$time_check_month_next = time() + (30*24*60*60);
$txt_check_month_next = date('Y-m-d',$time_check_month_next);
$where .= " AND infohosting_end BETWEEN '".$txt_check_month."' AND '".$txt_check_month_next."' ";
break;
case '3':
$time_check_month = time();
$txt_check_month = date('Y-m-d',$time_check_month);
$where .= " AND infohosting_end<='".$txt_check_month."' ";
break;
}
$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_infohosting ".$where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$q_vps = $DB->query("SELECT * FROM tb_infohosting ".$where." ORDER BY infohosting_begin DESC LIMIT $from,$pageSize ");
$txt_list='';
$stt=1;
while ($r_vps = $DB->fetch_row($q_vps)){
$txt_time_batdau = strtotime($r_vps['infohosting_begin']);
$txt_time_ketthuc = strtotime($r_vps['infohosting_end']);
$time_check_month = $txt_time_ketthuc - (30*24*60*60);
if($time_check_month < time() && $txt_time_ketthuc > time()){
$txt_status = '<span class="text-warning"><i class="far fa-clock"></i> Sắp hết hạn </span>';
}elseif(time() > $txt_time_ketthuc){
$txt_status = '<span class="text-danger"><i class="far fa-stop-circle"></i> Đã hết hạn</span>';
}elseif(time() < $txt_time_ketthuc && time()<$time_check_month){
$txt_status = '<span class="text-success"><i class="far fa-play-circle"></i> Đang sử dụng</span>';
}
$txt_list .= '<tr><td>'.$stt.'</td><td>'.$r_vps['infohosting_ip'].'</td><td><a href="'.$r_vps['infohosting_domain'].'" target="_blank">'.$r_vps['infohosting_domain'].'</a></td><td>'.$r_vps['infohosting_cplink'].'</td><td>'.date('d-m-Y',$txt_time_batdau).'</td><td>'.date('d-m-Y',$txt_time_ketthuc).'</td><td>'.$txt_status.'</td><td><a href="?act=management&code=infohosting&type=post&infohosting_id='.$r_vps['infohosting_id'].'">Chi tiết</a> | <a href="?act=management&code=infohosting&type=giahanhosting&infohosting_id='.$r_vps['infohosting_id'].'">Gia hạn Hosting</a></td></tr>';
$stt++;
}
$nav = $print->Pagination($totalPage,$pageNum,'menu','?act=management&code=infohosting&type2='.$type2);
?>