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/report_manga/ |
<?php
$type = $CORE->input['type'] ?? 'list';
$arr_error = array(1=>'Image is wrong or can not see it',2=>'Chapter is duplicated',3=>'Chapter untranslated',4=>'Chapter not this manga?',5=>'Other error');
$f = $CORE->input['s']??array();
$where = " AND a.error_id>0 ";
$param_search = '';
foreach($f as $key=>$val){
if(isset($val) and trim($val)!='') {
if ($key == 'error_type') {
$val = trim($val);
$where .= " AND error_type='$val' ";
}
if ($key == 'error_des') {
$val = trim($val);
$where .= " AND error_des LIKE '%" . $val . "%' ";
}
$param_search .= 's[' . $key . ']=' . trim($val) . '&';
}
}
$order_by = ' a.time_post DESC';
$pageNum = isset($_GET['pageNum']) ? intval($_GET['pageNum']) : 1;
$pageSize = 25;
$from = (($pageNum * $pageSize) - $pageSize);
$t = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_error a WHERE 1 ".$where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$q_comment = $DB->query("
SELECT a.*,b.truyen_name,c.chuong_name
FROM tb_error a, tb_truyen b, tb_chuong c
WHERE 1 ".$where." AND a.truyen_id = b.truyen_id AND a.chuong_id=c.chuong_id
ORDER BY $order_by LIMIT $from,$pageSize");
$list = '';
$flag = '';
while($r_comment = $DB->fetch_row($q_comment)) {
$error_id = $r_comment['error_id'];
$date_comment = date('d/m/Y h:i:s A', strtotime($r_comment['time_post']));
$list .= '
<tr><td><a href="?act=admin&code=posts&type=post&id='.$r_comment['truyen_id'].'">'.$r_comment['truyen_name'].'</td><td><a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=posts&type=postchapter&id='.$r_comment['truyen_id'].'&chuong_id='.$r_comment['chuong_id'].'\',\'View chap for fix\')">'.$r_comment['chuong_name'].'</a></td><td>'.$arr_error[$r_comment['error_type']].'</td><td>'.$r_comment['error_des'].'</td><td>'.$date_comment.'</td><td>[<a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=posts&type=postchapter&id='.$r_comment['truyen_id'].'&chuong_id='.$r_comment['chuong_id'].'\',\'View chap for fix\')">Fix chap</a>] [<a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=report_manga&type=delete&error_id='.$r_comment['error_id'].'\',\'Delete\');" class="">Delete</a>]</td></tr>';
}
$nav = $print->Pagination($totalPage,$pageNum,'pages','?act=admin&code=report_manga&'.$param_search);
?>