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/lockedchap/ |
<?php
$time_now = date('Y-m-d H:i:s');
$where = " AND (t1.lock_to_date!='' OR t1.lock_to_date is not NULL) AND t1.lock_to_date>='".$time_now."' ";
$keyword = isset($CORE->input['fkeyword']) ? $CORE->input['fkeyword'] : '';
if($keyword!='')
{
$where .= " AND (t2.truyen_name LIKE '%".$keyword."%') ";
}
$pageNum = isset($_GET['pageNum']) ? intval($_GET['pageNum']) : 1;
$pageSize = 20;
$from = (($pageNum * $pageSize) - $pageSize);
$t = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_chuong t1 LEFT JOIN tb_truyen t2 ON t1.truyen_id=t2.truyen_id WHERE 1 ".$where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$query = $DB->query("
select t1.*,t2.*
from tb_chuong t1 LEFT JOIN tb_truyen t2 ON t1.truyen_id=t2.truyen_id
WHERE 1 ".$where."
ORDER BY t2.truyen_id, t1.chuong_pos DESC LIMIT $from, $pageSize
");
$list='';
while($row = $DB->fetch_row($query)){
$list.='<tr id="chuong_lock_'.$row['chuong_id'].'"><td>'.$row['chuong_name'].'</td><td>'.$row['truyen_name'].'</td><td>'.$row['lock_to_date'].'</td><td>[<a href="javascript:void(0);" class="delete_pay" data-chapid="'.$row['chuong_id'].'">Delete lock</a>] [<a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=posts&type=lockchapter&id='.$row['truyen_id'].'&chuong_id='.$row['chuong_id'].'\',\'post chap\')">Change date</a>]</td>';
}
$nav = $print->Pagination($totalPage,$pageNum,'pages','?act=admin&code=lockedchap');
?>