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/netphim/code/admin/phim/ |
<?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_phim WHERE 1 ".$where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$query = $DB->query("SELECT * FROM tb_phim WHERE 1 ".$where." ORDER BY `time` DESC LIMIT $from, $pageSize");
$list = '';
while ($row = $DB->fetch_row($query)){
$list .= '<tr><td><input type="checkbox" value="'.$row['phim_id'].'" name="id[]"></td><td><a href="?act=admin&code=phim&type=post&id='.$row['phim_id'].'">'.$row['name'].'</a><br/>'.$row['api_id'].'</td><td>'.$row['slug'].'</td><td><img src="'.$row['thumb_url'].'" style="width: 60px;"></td><td>'.date('d-m-Y',strtotime($row['created'])).'</td><td>'.$row['episode_current'].'</td><td>'.$row['episode_total'].'</td><td><nobr><a href="?act=admin&code=phim&type=post&id='.$row['phim_id'].'"><i class="far fa-edit"></i> Edit</a> <a href="?act=admin&code=phim&type=epi&id='.$row['phim_id'].'"><i class="fas fa-list-ol"></i> Epi</a> <a href="javascript:void(0);" onclick="if(confirm(\'Are you sure?\')){ open_popup(\'?act=admin&code=phim&type=del&id='.$row['phim_id'].'\',\'Delete\');}"><i class="far fa-trash-alt"></i> Delete</a></nobr></td>';
}
$nav = $print->Pagination($totalPage,$pageNum,'pages','?act=admin&code=phim&'.$param_search);
if(isset($CORE->input['submitbt'])){
}
if(isset($CORE->input['type2']) && $CORE->input['type2']!=''){
$type2 = trim($CORE->input['type2']);
switch ($type2){
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;
}
}
?>