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/truyentranh/code/admin/banner/ |
<?php
$keyword = isset($CORE->input['fkeyword']) ? $CORE->input['fkeyword'] : '';
$where = " WHERE banner_title<>'' ";
if($keyword!='')
{
$where .= " AND (banner_title LIKE '%".$keyword."%' or banner_etitle LIKE '%".$keyword."%') ";
}
$pageNum = isset($_GET['pageNum']) ? intval($_GET['pageNum']) : 1;
$pageSize = 100;
$from = (($pageNum * $pageSize) - $pageSize);
$t = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_banner ".$where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$query = $DB->query("SELECT * FROM tb_banner ".$where." ORDER BY `banner_pos` ASC LIMIT $from, $pageSize");
$txt_list_banner = '';
while($row = $DB->fetch_row($query))
{
$filename = 'upload/logos/'.$row['banner_img'];
$size = getimagesize($filename);
$txt_list_banner .= '<tr>
<td><input name="txt_pos['.$row['banner_id'].'][]" class="form-control" type="text" value="'.$row['banner_pos'].'" style="width:100px;"></td>
<td><a href="?act=admin&code=banner&type=post&banner_id='.$row['banner_id'].'">'.$row['banner_title'].'</a></td>
<td><img src="upload/logos/'.$row['banner_img'].'" style="width: 100px;"></td>
<td>'.$size[0].'x'.$size[1].'</td>
<td>'.$row['banner_url'].'</td>
<td>'.date('d-m-Y',strtotime($row['banner_time'])).'</td>
<td>
<a href="?act=admin&code=banner&type=post&banner_id='.$row['banner_id'].'" class="btn btn-warning"><i class="fas fa-edit"></i> Edit</a>
<a href="?act=admin&code=banner&type=delete&banner_id='.$row['banner_id'].'" class="btn btn-danger" onclick="return confirm(\'Are you sure want to delete?\');"><i class="far fa-trash-alt"></i> Delete</a>
</td>
</tr>';
}
$nav = $print->Pagination($totalPage,$pageNum,'menu','?act=admin&code=banner&type=list&fkeyword='.$keyword);
$html_block = 'list';
$type2 = isset($CORE->input['type2']) ? $CORE->input['type2'] : '';
if($type2=='update_pos'){
$pos = $CORE->input['txt_pos'];
foreach ($pos as $key=>$val){
$DB->query("UPDATE tb_banner SET banner_pos = '".$val[0]."' WHERE banner_id='$key' ");
}
unset($pos);
$print->refresh('?act=admin&code=banner&type=list');
}
?>