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/posts/ |
<?php
function showCategories_option($arr_menus, $parent_id = 0, $char = '')
{
foreach ($arr_menus as $key => $item)
{
// Nếu là chuyên mục con thì hiển thị
if ($item['menus_parentid'] == $parent_id)
{
echo '<option value="'.$item['menus_id'].'">';
echo $char . $item['menus_name'];
echo '</option>';
// Xóa chuyên mục đã lặp
unset($arr_menus[$key]);
// Tiếp tục đệ quy để tìm chuyên mục con của chuyên mục đang lặp
showCategories_option($arr_menus, $item['menus_id'], $char.'+');
}
}
}
$query = $DB->query("SELECT * FROM tb_menus WHERE menus_type='page' ORDER BY `menus_pos` ASC");
$arr_menus = array();
while($row = $DB->fetch_row($query))
{
$arr_menus[] = $row;
}
$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=='menus_id'){
$where .= " AND truyen_id IN (SELECT truyen_id FROM tb_menus_pages WHERE menus_id='".$val."' ) ";
}
if($key=='active_status'){
$where .= " AND truyen_active_status='".$val."' ";
}
if($key=='status'){
$where .= " AND truyen_status='".$val."' ";
}
if($key=='truyen_type'){
$where .= " AND truyen_type='".$val."' ";
}
if($key=='keyword'){
$where .= " AND (truyen_name LIKE '%".$val."%' OR truyen_fname LIKE '%".$val."%' OR truyen_othername 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_truyen WHERE 1 ".$where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$query = $DB->query("SELECT * FROM tb_truyen WHERE 1 ".$where." ORDER BY time_post DESC LIMIT $from, $pageSize");
$list = '';
while ($row = $DB->fetch_row($query)){
$q_menu_page = $DB->query(" SELECT a.menus_id,a.menus_name FROM tb_menus a LEFT JOIN tb_menus_pages b ON a.menus_id=b.menus_id WHERE a.menus_parentid!=0 AND b.truyen_id='".$row['truyen_id']."' ");
$arr_menu = array();
$arr_color = array('text-primary','text-secondary','text-success','text-danger','text-warning','text-info','text-dark');
while ($r_menu_page = $DB->fetch_row($q_menu_page)){
$arr_menu[]='<a href="?act=admin&code=posts&s[menus_id]='.$r_menu_page['menus_id'].'" style="font-size:11px;" class="'.$arr_color[array_rand($arr_color)].'">'.$r_menu_page['menus_name'].'</a>';
}
$txt_menu = '';
if(!empty($arr_menu)){
$txt_menu .= implode(', ',$arr_menu);
}
/*$txt_status = '<i class="far fa-check-circle"></i>';
if($row['status']==1) {
$txt_status = '<i class="fas fa-times"></i>';
}
$txt_noibat = '<i class="fas fa-times"></i>';
if($row['noibat']==1) {
$txt_noibat = '<i class="far fa-check-circle"></i>';
}*/
$list .= '<tr><td><input type="checkbox" value="'.$row['truyen_id'].'" name="id[]"></td><td><a href="?act=admin&code=posts&type=post&id='.$row['truyen_id'].'">'.$row['truyen_name'].'</a><br/>'.$row['truyen_chuong_moinhat_name'].'</td><td>'.$row['truyen_theloai'].'</td><td><img src="'.$row['truyen_thumb'].'" style="width: 60px;"></td><td>'.date('d-m-Y',strtotime($row['time_post'])).'</td><td>'.$row['truyen_active_status'].'</td><td>'.$row['truyen_sochuong'].'</td><td><nobr><a href="?act=admin&code=posts&type=post&id='.$row['truyen_id'].'"><i class="far fa-edit"></i> Edit</a> <a href="?act=admin&code=posts&type=chapter&id='.$row['truyen_id'].'"><i class="fas fa-list-ol"></i> Chap</a> <a href="javascript:void(0);" onclick="if(confirm(\'Are you sure?\')){ open_popup(\'?act=admin&code=posts&type=del&id='.$row['truyen_id'].'\',\'Delete\');}"><i class="far fa-trash-alt"></i> Delete</a></nobr></td>';
}
$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_pages WHERE id='$id'"));
if($row_check){
if($row_check['path_img']!='' && file_exists($row_check['path_img'])){
unlink($row_check['path_img']);
}
}
$DB->query("DELETE FROM tb_pages WHERE id='$id'");
$DB->query("DELETE FROM tb_menus_pages WHERE pages_id='$id'");
}
$print->refresh('?act=admin&code=posts');
break;*/
case 'active_posts':
$arr_id = $CORE->input['id'];
foreach ($arr_id as $val) {
$id = $val;
$DB->query("UPDATE tb_truyen SET truyen_active_status='Active' WHERE truyen_id='$id' ");
}
$print->refresh('?act=admin&code=posts');
break;
case 'deactive_posts':
$arr_id = $CORE->input['id'];
foreach ($arr_id as $val) {
$id = $val;
$DB->query("UPDATE tb_truyen SET truyen_active_status='Deactive' WHERE truyen_id='$id' ");
}
$print->refresh('?act=admin&code=posts');
break;
case 'noibat_posts':
$arr_id = $CORE->input['id'];
foreach ($arr_id as $val) {
$id = $val;
$DB->query("UPDATE tb_pages SET noibat='1' WHERE id='$id' ");
}
$print->refresh('?act=admin&code=posts');
break;
case 'huynoibat_posts':
$arr_id = $CORE->input['id'];
foreach ($arr_id as $val) {
$id = $val;
$DB->query("UPDATE tb_pages SET noibat='0' WHERE id='$id' ");
}
$print->refresh('?act=admin&code=posts');
break;
}
}
?>