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/video/ |
<?php
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;
}
require "configs.php";
require "lib/class_db.php";
$DB = new db_driver;
$DB->connect($INFO);
$keyword = '';
if(isset($_REQUEST['search'])){
$keyword = trim($_REQUEST['search']);
}
$pageNum = 1;
if(isset($_REQUEST['page'])) {
$pageNum = intval($_REQUEST['page']);
}
$where = "WHERE menus_name<>''";
if($keyword!='')
{
$where .= " AND (menus_name LIKE '%".$keyword."%' or menus_ename LIKE '%".$keyword."%') ";
}
$pageSize = 1000;
$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,'+');
if(!empty($list_company)){
foreach($list_company as $key=>$val){
$list_menus['id'] = $val['menus_id'];
$list_menus['text'] = $val['menus_name'];
$result['results'][] = $list_menus;
}
//$result['pagination'] = array('more'=>true);
$result['pagination']['more'] = true;
}else{
$result['results'] = array();
$result['pagination']['more'] = false;
}
echo json_encode($result);
$DB->free_result();
$DB->close_db();
?>