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/service/ |
<?php
$service_id = 0;
if(isset($CORE->input['service_id']) && $CORE->input['service_id']>0 ){
$service_id = $CORE->input['service_id'];
}
$txt_all = '';
$where = " WHERE service_id>0 AND user_post='".$ob_user->user_name."' ";
if(is_admin()){
$where = " WHERE service_id>0 ";
}
$s = array('service_title'=>'','service_cat'=>'','company_id'=>'');
$param_search = '';
if(isset($CORE->input['s'])){
$s = $CORE->input['s'];
foreach ($s as $key=>$val){
if($key=='service_title' && $val!='' ){
$where .= " AND ".$key." LIKE '%".$val."%' ";
}
if($key=='service_cat' && $val>0){
$where .= " AND ".$key." = '".$val."' ";
}
if($key=='customer_id' && $val>0){
$where .= " AND ".$key." = '".$val."' ";
}
$param_search .= '&s[' . $key . ']=' . $val;
}
$txt_all = '<a href="index.php?act=management&code=service" class="badge badge-warning">All</a>';
//$param_search = http_build_query($s);
}
$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_service ".$where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$q_service = $DB->query("SELECT * FROM tb_service ".$where." ORDER BY time_post DESC LIMIT $from,$pageSize ");
$txt_list='';
while ($r_service = $DB->fetch_row($q_service)){
$arr_customer = get_customer_info($r_service['customer_id']);
$txt_list .= '<tr><td>'.$r_service['service_id'].'</td><td><a href="?act=management&code=service&type=post&id='.$r_service['service_id'].'">'.$r_service['service_title'].'</a></td><td>'.$arr_service[$r_service['service_cat']].'</td><td><a href="?act=management&code=customer&type=post&id='.$arr_customer['customer_id'].'" target="_blank">'.$arr_customer['customer_fullname'].'</a></td>
<td>
<a class="btn btn-info btn-sm" href="?act=management&code=service&type=post&id='.$r_service['service_id'].'"><i class="fas fa-pencil-alt"></i> Cập nhật</a>
<a class="btn btn-danger btn-sm" href="?act=management&code=service&type=delete_service&id='.$r_service['service_id'].'" onclick="return confirm(\'Bạn có chắc muốn xóa?\');"><i class="fas fa-trash"></i> Xóa</a>
</td>
</tr>';
}
$nav = $print->Pagination($totalPage,$pageNum,'menu','index.php?act=management&code=service&'.$param_search);
?>