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/thietkewebvumi.com/admin_new/mod/ |
<?php
class videocat{
var $path_image = "upload/videocat/";
var $max_fsize = 1500000;//1,5M
function videocat (){
global $CORE;
$arr_sid = array();
switch($CORE->input['code']){
default : $this->goList(); break;
case 'post': $this->goPost(); break;
case 'del': $this->goDel($arr_sid); break;
case 'showvideocat' : $this->goShowvideocat(); break;
}
}
function goList(){
global $CORE, $DB, $smarty, $print;
$smarty->assign('module_name','Quản lý danh mục video');
$smarty->assign('title','Danh mục video');
$smarty->assign('section','list');
$smarty->assign('status',$CORE->input['status']);
if($CORE->input['task'] == 'massdel'){
$sids = $CORE->input['sids'];
$arr_sid = explode('|',$sids);
if(!empty($arr_sid)){
$this->goDel($arr_sid);
$print->refresh("index.php?act=videocat&status=del_success&type=");
}
}
$where = "WHERE cname<>''";
$_SESSION['type'] = $CORE->input['type'];
$_SESSION['fstatus'] = $CORE->input['fstatus'];
$_SESSION['fkeyword'] = $CORE->input['fkeyword'];
if($_SESSION['fkeyword']!='')
{
$where .= " AND title LIKE '%".$CORE->input['fkeyword']."%'";
$nsearch = 1;
}
$smarty->assign('nsearch',$nsearch);
if($CORE->input['nosearch']){ unset( $_SESSION['fcat'],$_SESSION['fstatus'],$_SESSION['fkeyword']);}
// Filtering End --------------------------------------------------------
// Sorting Begin -----------------------------------------------------
if($CORE->input['sortby']) $_SESSION['prod_dirby'] = ($_SESSION['prod_dirby']==1) ? 0 : 1;
$dbsort = ($CORE->input['sortby']) ? $CORE->input['sortby'] : $_SESSION['prod_sortby'];
$_SESSION['prod_sortby'] = $dbsort;
// Sorting End --------------------------------------------------------
$pageNum = ($_GET['pageNum']>0) ? intval($_GET['pageNum']) : 1;
$pageSize = 20;
$from = (($pageNum * $pageSize) - $pageSize);
//$t = $DB->query("SELECT a.id FROM NNCCMS_videocat");
$t = $DB->fetch_row($DB->query("SELECT count(*) as total FROM NNCCMS_videocat ".$where));
$total = $t['total'];
$smarty->assign('total',$total);
$totalPage = ceil($total / $pageSize);
// Pagination2 DB
$query = $DB->query("SELECT * FROM NNCCMS_videocat ".$where." ORDER BY cid DESC LIMIT $from, $pageSize");
//echo "SELECT * FROM NNCCMS_videocat ".$where." ".$sortby." LIMIT $from, $pageSize";
$c = 0;
while($row = $DB->fetch_row($query))
{
$c++;
$row['no'] = $c;
$arr2 = explode(',',$row['cid']);
$check_time = time()-(31*24*60*60);
//$data['time'] = date('D, d/m/Y: A',$data['time']);
$row['time'] = date('d-m-Y',$row['time']);
$arr[] = $row;
}
if(is_null($arr)) $arr[] = array();
$smarty->assign('list',$arr);
$nav = $print->Pagination($totalPage,$pageNum,'phim','index.php?act=video');
$smarty->assign('nav',$nav);
$DB->free_result();
}
function goPost(){
global $CORE, $DB, $func, $smarty, $print;
$smarty->assign('module_name','Quản lý danh mục video');
$smarty->assign('title','Danh mục video');
$smarty->assign('status',$CORE->input['status']);
$smarty->assign('section','post');
if($_SESSION['error']) unset($CORE->input['bsubmit']);
// Show post -----------------------------------------------------------------------
if(!$CORE->input['bsubmit']){
$id = intval($CORE->input['id']);
if ($_SESSION['error']) $prevError = $_SESSION['error']; unset($_SESSION['error']);
if ($_SESSION['state']) $prevState = $_SESSION['state']; unset($_SESSION['state']);
if($prevState!=NULL){
$data = $prevState;
}else{
if($id==0){
$data['status'] = 1;
}else{
$query = $DB->query(
"SELECT * FROM NNCCMS_videocat WHERE cid='".$id."'");
$data = $DB->fetch_row($query);
}
}
// End u4 list ----------------------------------------------
$error[] = $prevError;
$post[] = $data;
$smarty->assign('error',$error);
$smarty->assign('post',$data);
// Do post -------------------------------------------
}else{
$cid = $state['cid'] = intval($CORE->input['cid']);
$cname = $state['cname'] = $CORE->input['cname'];
$fcname = $func->format_string($cname);
$cname_youtube = $CORE->input['cname_youtube'];
$row_check = $DB->fetch_row($DB->query("SELECT cid FROM NNCCMS_videocat WHERE fcname='$fcname'"));
if($row_check){
$fcname = $fcname.'-'.($row_check['cid']+100);
}
// -------------- check -------------------------
if($cname=='' or $cname_youtube=='') exit('Xin nhập tiêu đề');
if($cid==0){
$DB->query("INSERT INTO `NNCCMS_videocat`(`cname`,`cname_youtube`,`fcname`)
VALUES('".$cname."','".$cname_youtube."','".$fcname."');");
return $print->refresh("index.php?act=videocat&status=add_success");
// Do Edit -----------------
}else{
$DB->query("UPDATE `NNCCMS_videocat` SET `cname` = '$cname',`cname_youtube`='$cname_youtube',`fcname` = '$fcname' WHERE `cid`='$cid'");
return $print->refresh("index.php?act=videocat&code=post&status=edit_success&id=".$cid);
}
}
}
function goDel($id){
global $CORE, $DB, $print;
if($CORE->admin_user['ug_id']!=4) exit('Chỉ có admin mới có quyền xóa bài!...');
if(!empty($id)){
foreach($id as $val){
$DB->query("DELETE FROM NNCCMS_video WHERE cid='".$val."'");
$DB->query("DELETE FROM NNCCMS_videocat WHERE cid='".$val."'");
}
}
}
function goShowvideocat(){
global $CORE, $DB, $func;
$cid = intval($CORE->input['param']);
$fcat = '<select name="list1" multiple="multiple" size="10" ondblclick="opt.transferRight()" style="width:290px;height:400px">';
$row = $DB->fetch_row($DB->query("SELECT id_videocat FROM NNCCMS_videocatcat WHERE cid = '$cid'"));
if($row['id_videocat']==''){
echo 'Danh mục này chưa có sản phẩm';
exit();
}
$query_videocat = $DB->query("SELECT id,title FROM NNCCMS_videocat WHERE id IN ({$row['id_videocat']}) ORDER BY title ");
while($row_videocat = $DB->fetch_row($query_videocat)){
$fcat .= '<option value="'.$row_videocat['id'].'">++'.$row_videocat['title'].'</option>';
}
$fcat .= '</select>';
echo '<SCRIPT LANGUAGE="JavaScript">
var opt = new OptionTransfer("list1","list2");
opt.setAutoSort(false);
opt.setDelimiter(",");
opt.saveNewRightOptions("prods");
</SCRIPT><script language="javascript" type="text/javascript">opt.init(document.getElementById(\'post\'));</script>';
echo $fcat;
exit();
}
}
$run = new videocat();
?>