ÿØÿà 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/thietkeweb2/code/admin/posts/ |
<?php function showCategories_option($categories, $parent_id = 0, $char = '') { foreach ($categories 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($categories[$key]); // Tiếp tục đệ quy để tìm chuyên mục con của chuyên mục Ä‘ang lặp showCategories_option($categories, $item['menus_id'], $char.'+'); } } } $query = $DB->query("SELECT * FROM tb_menus WHERE menus_type='normal' 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 id IN (SELECT pages_id FROM tb_menus_pages WHERE menus_id='".$val."' ) "; } if($key=='status'){ $where .= " AND status='".$val."' "; } if($key=='keyword'){ $where .= " AND (title LIKE '%".$val."%' OR etitle 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_pages WHERE 1 ".$where)); $total = $t['total']; $totalPage = ceil($total / $pageSize); $query = $DB->query("SELECT * FROM tb_pages WHERE 1 ".$where." ORDER BY `pos` ASC, `noibat` DESC, status ASC 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 b.pages_id='".$row['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['id'].'" name="id[]"></td><td><a href="?act=admin&code=posts&type=post&id='.$row['id'].'">'.$row['title'].'</a></td><td>'.$txt_menu.'</td><td><img src="'.$row['path_img'].'" style="width: 60px;"></td><td>'.date('d-m-Y',$row['time']).'</td><td>'.$txt_status.'</td><td>'.$txt_noibat.'</td><td><a href="?act=admin&code=posts&type=post&id='.$row['id'].'"><i class="far fa-edit"></i> Sá»a</a> <a href="?act=admin&code=posts&type=del&id='.$row['id'].'" onclick="return confirm(\'Bạn có chắc muốn xóa?\')"><i class="far fa-trash-alt"></i> Xóa</a></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_pages SET status='0' WHERE 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_pages SET status='1' WHERE 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; } } ?>