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/oladi/code/admin/menus/ |
<?php
global $DB,$func;
function menus_selected($id,$parentid,$aCats,$res,$sep){
foreach($aCats as $val){
if($val['menus_parentid']==$parentid){
if($id==$val['menus_id']){
$re = '<option value="'.$val['menus_id'].'" selected> + '.$sep.' '.$val['menus_name'].' ('.$val['menus_pos'].')</option>';
}else{
$re = '<option value="'.$val['menus_id'].'"> + '.$sep.' '.$val['menus_name'].' ('.$val['menus_pos'].')</option>';
}
$res .= menus_selected($id,$val['menus_id'],$aCats,$re,$sep.' + ');
}
}
return $res;
}
function tree_menu($parentid,$arr,$sep){
if(!is_null($arr)) {
foreach ($arr as $key => $v) {
if ($v['menus_parentid'] == $parentid) {
$arr[$key]['menus_name'] = $sep . ' ' . $arr[$key]['menus_name'];
$arr = tree_menu($v['menus_id'], $arr, $sep . " + ");
}
}
}
return $arr;
}
$CORE->page_title = ($v_lang=='en')?'Menu':'Danh mục menu';
$type = isset($CORE->input['type']) ? $CORE->input['type'] : '';
switch ($type){
case 'delete':
global $INFO;
$menus_id = $CORE->input['menus_id'];
if($menus_id==1){
$print->refresh('?act=admin&code=menus','Some pages used this menu, can not delete',2);
}
$row_check = $DB->fetch_row($DB->query("SELECT * FROM tb_menus_pages WHERE menus_id='$menus_id'"));
if($row_check){
$print->refresh('?act=admin&code=menus','Some pages used this menu, can not delete',2);
}else{
$DB->query("DELETE FROM tb_menus WHERE menus_parentid='".$menus_id."' ");
$DB->query("DELETE FROM tb_menus WHERE menus_id='".$menus_id."' ");
$print->refresh('?act=admin&code=menus');
}
break;
case 'post' :
$menus_id = isset($CORE->input['menus_id']) ? intval($CORE->input['menus_id']) : 0;
$row_check = $DB->get_colum_tb('tb_menus');
if($menus_id>0) {
$row_check = $DB->fetch_row($DB->query("SELECT * FROM `tb_menus` WHERE `menus_id` = '$menus_id' "));
}
$aCats = array();
$op_menu = '';
$query_menu = $DB->query("SELECT * FROM tb_menus ");
while($rows_menu = $DB->fetch_row($query_menu))
{
$aCats[] = $rows_menu;
}
$op_menu = menus_selected($row_check['menus_parentid'],0,$aCats,'<option value="0"> Choose a module category</option>','');
$html_block = 'post';
if(isset($CORE->input['submitbt'])){
$f = $CORE->input['f'];
if(isset($f['menus_type'])){
$f['menus_type']= trim($f['menus_type']);
}else{
$f['menus_type']='normal';
$f['menus_url'] = '';
}
if($f['menus_name']!='') {
$fname = $func->format_string($f['menus_name']);
if(intval($f['menus_id'])>0){
$row_check_total = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_menus WHERE menus_fname='".$fname."' AND menus_id!='".intval($f['menus_id'])."' "));
if($row_check_total['total']>0){
$fname = $fname.'-'.($row_check_total['total']+1);
}
$DB->query("UPDATE tb_menus SET menus_name='".$f['menus_name']."' ,menus_ename='".$f['menus_ename']."',menus_fname='".$fname."',menus_des='".trim($f['menus_des'])."', menus_icon='" . $f['menus_icon'] . "',menus_parentid='" . $f['menus_parentid'] . "',menus_pos='" . $f['menus_pos'] . "',menus_type='".$f['menus_type']."',menus_url='".$f['menus_url']."',time_post='".date('Y-m-d H:i:s')."' WHERE menus_id='".intval($f['menus_id'])."'");
$v_menus_id = intval($f['menus_id']);
}else {
$row_check_total = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_menus WHERE menus_fname='".$fname."' "));
if($row_check_total['total']>0){
$fname = $fname.'-'.($row_check_total['total']+1);
}
$DB->query("INSERT INTO `tb_menus` ( `menus_name`, `menus_ename`,`menus_fname`, menus_des,`menus_parentid`,`menus_icon`, `menus_pos`,user_id,menus_type,menus_url,time_post) VALUES ( '" . $f['menus_name'] . "', '" . $f['menus_ename'] . "', '" . $fname . "', '" . $f['menus_des'] . "', '" . $f['menus_parentid'] . "', '" . $f['menus_icon'] . "', '" . $f['menus_pos'] . "','".$ob_user->user_id."', '" . $f['menus_type'] . "', '" . $f['menus_url'] . "','".date('Y-m-d H:i:s')."');");
$v_menus_id = $DB->insert_id();
}
//upload logo
if($_FILES['image_field']){
include ROOT_PATH.'lib/class.upload.php';
$handle = new upload($_FILES['image_field']);
if ($handle->uploaded) {
$v_image_name = $v_menus_id.'_'.time();
$handle->allowed = array('image/*');
$handle->file_new_name_body = $v_image_name;
$handle->file_max_size = '1000000';
$handle->image_convert = 'png';
$folder = 'upload/menus/'.date('Y').'/'.date('m');
if(!is_dir($folder)){
mkdir($folder,0755,true);
}
$v_image_folder = $folder.'/'.$v_image_name.'.png';
$handle->process(ROOT_PATH.$folder.'/');
if ($handle->processed) {
if($row_check['menus_img']!='') {
unlink($row_check['menus_img']);
}
$DB->query("UPDATE tb_menus SET menus_img='".$v_image_folder."' WHERE menus_id='$v_menus_id' ");
$handle->clean();
} else {
echo 'Upload Error : ' . $handle->error;
exit();
}
}
}
$print->refresh('?act=admin&code=menus');
}
}
break;
default:
$keyword = isset($CORE->input['fkeyword']) ? $CORE->input['fkeyword'] : '';
$where = "WHERE menus_name<>''";
if($keyword!='')
{
$where .= " AND (menus_name LIKE '%".$keyword."%' or menus_ename LIKE '%".$keyword."%') ";
}
$pageNum = isset($_GET['pageNum']) ? intval($_GET['pageNum']) : 1;
$pageSize = 50;
$from = (($pageNum * $pageSize) - $pageSize);
$t = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_menus ".$where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$query = $DB->query("SELECT * FROM tb_menus ".$where." ORDER BY `menus_pos` ASC LIMIT $from, $pageSize");
$arr = array();
while($row = $DB->fetch_row($query))
{
$arr[] = $row;
}
$list_company = tree_menu(0,$arr,'+');
$nav = $print->Pagination($totalPage,$pageNum,'menu','index.php?act=admin&code=menus&fkeyword='.$keyword);
$txt_list_company = '';
foreach($list_company as $val){
if($val['menus_img']!='' and file_exists($val['menus_img'])){
$txt_img = '<img src="'.$val['menus_img'].'" style="width: 20px;">';
}else{
$txt_img = '';
}
$txt_list_company .= '<tr>
<td><input name="txt_pos['.$val['menus_id'].'][]" class="form-control" type="text" value="'.$val['menus_pos'].'" style="width:100px;"></td>
<td>'.$val['menus_name'].'</td>
<td>'.$val['menus_fname'].'</td>
<td>'.$txt_img.'</td>
<td>'.html_entity_decode($val['menus_icon']).'</td>
<td>
<a href="?act=admin&code=menus&type=post&menus_id='.$val['menus_id'].'" class="btn btn-sm btn-icon btn-pure btn-outline delete-row-btn"><i class="far fa-edit"></i> Edit</a>
<a href="?act=admin&code=menus&type=delete&menus_id='.$val['menus_id'].'" class="btn btn-sm btn-icon btn-pure btn-outline delete-row-btn" onclick="return confirm(\'Are you sure want to delete?\');"><i class="far fa-trash-alt"></i> Del</a>
</td>
</tr>';
}
$html_block = 'list';
$type2 = isset($CORE->input['type2']) ? $CORE->input['type2'] : '';
if($type2=='update_pos'){
if(isset($CORE->input['txt_pos'])) {
$pos = $CORE->input['txt_pos'];
foreach ($pos as $key=>$val){
$DB->query("UPDATE tb_menus SET menus_pos = '".$val[0]."' WHERE menus_id='$key' ");
}
unset($pos);
}
$print->refresh('index.php?act=admin&code=menus');
}
break;
}
?>
<?php
include ROOT_PATH . 'include/block/header_admin.php';
?>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<div class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1 class="m-0">Menu management</h1>
</div><!-- /.col -->
<div class="col-sm-6">
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item"><a href="index.php">Home</a></li>
<li class="breadcrumb-item"><a href="?act=admin&code=menus"><?php echo $CORE->page_title;?></a></li>
<li class="breadcrumb-item active" aria-current="page"><span><?php echo $CORE->page_title;?> management</span></li>
</ol>
</div><!-- /.col -->
</div><!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<!-- /.content-header -->
<!-- Main content -->
<section class="content">
<div class="container-fluid">
<!-- Small boxes (Stat box) -->
<div class="row">
<div class="col-12">
<?php
if($html_block=='delete'){
?>
<form action="?act=admin&code=menus&type=delete" method="post">
<input type="hidden" value="<?php echo $menus_id;?>" name="menus_id">
<div class="card">
<div class="card-body">
<h4 class="card-title">Some data will be lost when you delete this record:</h4>
<h6 class="card-subtitle">About <?php echo $i;?> result</h6>
<ul class="search-listing">
<?php echo $txt_list_table_delete;?>
</ul>
</div>
<div class="form-actions">
<button type="submit" class="btn btn-success" name="submitbt_delete"> Agree delete</button>
<button type="button" class="btn btn-inverse" onclick="location.href='?act=admin&code=menus'">Cancel</button>
</div>
</div>
</form>
<?php } ?>
<?php
if($html_block=='post'){
?>
<div class="card card-outline-info">
<div class="card-header">
<h4 class="m-b-0">Add new menu</h4>
</div>
<div class="card-body">
<form action="?act=admin&code=menus&type=post" method="post" enctype="multipart/form-data">
<input type="hidden" value="<?php echo $row_check['menus_id'];?>" name="f[menus_id]">
<div class="form-body">
<div class="row p-t-20">
<div class="col-md-4">
<div class="form-group">
<label class="control-label">Menu name</label>
<input type="text" class="form-control" placeholder="" name="f[menus_name]" value="<?php echo $row_check['menus_name'];?>" required>
</div>
</div>
<div class="col-md-4 <?php echo $txt_form_en;?>">
<div class="form-group">
<label class="control-label">Tên menu Tiếng Anh</label>
<input type="text" class="form-control" name="f[menus_ename]" value="<?php echo $row_check['menus_ename'];?>">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="control-label">Menu icon fontawesome.com</label>
<input type="text" class="form-control" name="f[menus_icon]" value="<?php echo $row_check['menus_icon'];?>">
</div>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div class="form-group">
<label class="control-label">Menu parent</label>
<select class="form-control custom-select" data-placeholder="Choose a menu" name="f[menus_parentid]">
<?php echo $op_menu; unset($op_menu);?>
</select>
</div>
</div>
</div>
<div class="row">
<div class="col-md-4">
<div class="form-group">
<label class="control-label">Position:</label>
<input type="text" class="form-control" placeholder="" name="f[menus_pos]" value="<?php echo $row_check['menus_pos'];?>" required>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label>Menu image</label>
<input type="file" name="image_field">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<?php
if($row_check['menus_img']!='' and
file_exists($row_check['menus_img'])
){ ?>
<img src="<?php echo $row_check['menus_img'];?>" style="width:100px;">
<?php } ?>
</div>
</div>
</div>
<div class="row mb-4">
<div class="col-md-4">
<div class="form-check">
<input type="checkbox" class="form-check-input" name="f[menus_type]" id="check_menu_url" value="url" <?php if($row_check['menus_type']=='url'){echo 'checked'; }?>>
<label class="form-check-label">URL menu?</label>
</div>
</div>
<div class="col-md-8" id="menu_url" <?php if($row_check['menus_type']!='url'){echo 'style="display: none;"'; }?> >
<div class="form-group">
<label class="control-label">URL:</label>
<input type="text" class="form-control" placeholder="" name="f[menus_url]" value="<?php echo $row_check['menus_url'];?>" <?php if($row_check['menus_type']=='url'){echo 'required'; }?>>
</div>
</div>
</div>
<div class="row mb-4">
<div class="col-md-4">
<div class="form-check">
<input type="checkbox" class="form-check-input" name="f[menus_type]" id="check_menu_page" value="page" <?php if($row_check['menus_type']=='page'){echo 'checked'; }?>>
<label class="form-check-label">LÀ DANH MỤC SẢN PHẨM</label>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div class="form-group">
<label>Menu description</label>
<textarea name="f[menus_des]" class="form-control"><?php echo $row_check['menus_des'];?></textarea>
</div>
</div>
</div>
</div>
<div class="form-actions">
<button type="submit" class="btn btn-success" name="submitbt"> <i class="fa fa-check"></i> Save</button>
<button type="button" class="btn btn-inverse" onclick="location.href='index.php?act=admin&code=menus'">Cancel</button>
</div>
</form>
</div>
</div>
<?php } ?>
<?php
if($html_block=='list'){
?>
<div class="card">
<div class="card-body">
<div class="m-t-40">
<div class="d-flex">
<div class="mr-auto">
<div class="form-group">
<a href="?act=admin&code=menus&type=post" class="btn btn-primary btn-sm"><i class="fa fa-plus"></i> Add new
</a>
<a href="javascript:void(0);" class="btn btn-primary btn-sm" id="update_pos"><i class="fa fa-bars"></i> Update position
</a>
</div>
</div>
<div class="ml-auto">
<div class="form-group">
<input id="demo-input-search2" type="text" placeholder="Search" autocomplete="off" class="module_title_search" value="<?php echo $keyword;?>">
<input type="hidden" value="a=WALLS2&act=menus" id="txt_code_search">
</div>
</div>
</div>
</div>
<form action="" method="post" id="form_quick_update">
<input type="hidden" name="type2" value="">
<table class="table table-bordered color-table primary-table footable">
<thead>
<tr>
<th><?php echo $lang['vi-tri'];?></th>
<th>Name</th>
<th>Slug</th>
<th>Image</th>
<th>Icon</th>
<th>#</th>
</tr>
</thead>
<tbody>
<?php echo $txt_list_company;?>
</tbody>
</table>
</form>
<div class="text-center footable">
<ul class="pagination">
<?php echo $nav;?>
</ul>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
</div>
</section>
</div>
<script>
$("#check_menu_url").change(function () {
if($(this).is(':checked')) {
$("#menu_url").show();
$("input[name='f[menus_url]']").prop('required',true);
$("#check_menu_page").prop('checked',false);
}else{
$("#menu_url").hide();
$("input[name='f[menus_url]']").prop('required',false);
}
});
$('#check_menu_page').change(function () {
if($(this).is(':checked')) {
$("#check_menu_url").prop('checked',false);
$("#menu_url").hide();
$("input[name='f[menus_url]']").prop('required',false);
}else{
$("#menu_url").show();
}
});
</script>
<?php
include 'include/block/footer_admin.php';
?>