���� JFIF �� � ( %"1"%)+...383,7(-.-
![]() 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); ?>