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/luckymerchan/code/admin/dangsoloc/ |
<?php
$s = array();
$param_search = '';
$where = '';
if(isset($CORE->input['s'])){
$s = $CORE->input['s'];
foreach ($s as $key=>$val){
if($val!='') {
$param_search .= 's['.$key.']='.trim($val).'&';
if($key=='kqloc_excel_date_from'){
$txt_date_from = date('Y-m-d',strtotime($val));
$where .= " AND kqloc_excel_date>='$txt_date_from' ";
}
if($key=='kqloc_excel_date_to'){
$txt_date_to = date('Y-m-d',strtotime($val));
$where .= " AND kqloc_excel_date<='$txt_date_to' ";
}
if($key=='kqloc_excel_type'){
$where .= " AND kqloc_excel_type='".$val."' ";
}
if($key=='kqloc_excel_data'){
$where .= " AND kqloc_excel_data LIKE '%".$val."%' ";
}
if($key=='kqloc_excel_show_free'){
$where .= " AND kqloc_excel_show_free='$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_kqloc_excel WHERE 1 ".$where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$q_dangsoloc = $DB->query("SELECT * FROM tb_kqloc_excel WHERE 1 ".$where." ORDER BY kqloc_excel_date DESC,kqloc_excel_type LIMIT $from,$pageSize");
$txt_list = '';
while($r = $DB->fetch_row($q_dangsoloc)){
$txt_type='';
if($r['kqloc_excel_type']==1){
$txt_type='1 ngày';
}else{
$txt_type='6 ngày';
}
$txt_free = 'No';
if($r['kqloc_excel_show_free']==1){
$txt_free = '<span class="text-danger">Yes</span>';
}
$txt_list .= '<tr id="tr_dangsoloc_'.$r['kqloc_excel_id'].'"><td>'.date('d-m-Y',strtotime($r['kqloc_excel_date'])).'</td>
<td>'.$func->ope_max($r['kqloc_excel_data'],100).'</td>
<td>'.$txt_type.'</td>
<td>'.$txt_free.'</td>
<td>[<a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=dangsoloc&type=post&kqloc_excel_id='.$r['kqloc_excel_id'].'\',\'Edit kqloc_excel_id\')">Edit</a>] [<a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=dangsoloc&type=chinh_mau&kqloc_excel_id='.$r['kqloc_excel_id'].'\',\'Edit kqloc_excel_id\')">Chỉnh màu</a>] [<a href="javascript:void(0);" data-id="'.$r['kqloc_excel_id'].'" class="delete_dangsoloc">Delete</a>]</td></tr>';
}
$nav = $print->Pagination($totalPage,$pageNum,'pages','?act=admin&code=dangsoloc&'.$param_search);
?>