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/thietkeweb2/code/admin/contact/ |
<?php
$where = $param_search = '';
if(isset($CORE->input['s'])){
$s = $CORE->input['s'];
foreach ($s as $key=>$val){
if($val!='') {
$param_search .= 's['.$key.']='.trim($val).'&';
if($key=='status'){
$where .= " AND status='".$val."' ";
}
if($key=='keyword'){
$where .= " AND (phone LIKE '%".$val."%' OR email LIKE '%".$val."%' OR name LIKE '%".$val."%' OR website LIKE '%".$val."%' OR message LIKE '%".$val."%') ";
}
}
}
}
$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_contact_form WHERE 1 ".$where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$query = $DB->query(
"SELECT pre.*
FROM
(SELECT id FROM tb_contact_form WHERE 1 ".$where." ORDER BY time_post DESC LIMIT $from, $pageSize) as tmp
INNER JOIN tb_contact_form as pre ON pre.id=tmp.id
ORDER BY pre.time_post DESC
");
$list = '';
while ($row = $DB->fetch_row($query)){
if($row['status']=='pending'){
$status = '<span class="badge badge-success">Chưa xử lý</span>';
}else{
$status = '<span class="badge badge-warning">Đã xử lý</span>';
}
$list .= '<tr id="list_contact_'.$row['id'].'"><td><input type="checkbox" value="'.$row['id'].'" name="id[]"></td><td>'.$row['phone'].'</td><td>'.$row['name'].'</td><td>'.$row['email'].'</td><td>'.$row['website'].'</td><td>'.$row['message'].'</td><td>'.$row['time_post'].'</td><td>'.$status.'</td></tr>';
}
$nav = '';
if(!empty($list)){
$nav = $print->Pagination($totalPage,$pageNum,'pages','?act=admin&code=posts&'.$param_search);
}
if(isset($CORE->input['type2']) && $CORE->input['type2']!=''){
$type2 = trim($CORE->input['type2']);
switch ($type2){
case 'del_posts':
$arr_id = $CORE->input['id'];
foreach ($arr_id as $val){
$id = $val;
//$row_check = $DB->fetch_row($DB->query("SELECT * FROM tb_contact_form WHERE id='$id'"));
$DB->query("DELETE FROM tb_contact_form WHERE id='$id'");
}
$print->refresh('?act=admin&code=contact');
break;
case 'active_posts':
$arr_id = $CORE->input['id'];
foreach ($arr_id as $val) {
$id = $val;
$DB->query("UPDATE tb_contact_form SET status='pending' WHERE id='$id' ");
}
$print->refresh('?act=admin&code=contact');
break;
case 'deactive_posts':
$arr_id = $CORE->input['id'];
foreach ($arr_id as $val) {
$id = $val;
$DB->query("UPDATE tb_contact_form SET status='done' WHERE id='$id' ");
}
$print->refresh('?act=admin&code=contact');
break;
}
}
?>