79 lines
2.5 KiB
PHP
79 lines
2.5 KiB
PHP
|
<?php
|
||
|
|
include('includes/config/config.php');
|
||
|
|
include('includes/auth/auth.php');
|
||
|
|
include('includes/functions.php');
|
||
|
|
include('access.php');
|
||
|
|
?>
|
||
|
|
<?php
|
||
|
|
|
||
|
|
// Connect to mysqli database
|
||
|
|
$rp="";
|
||
|
|
$page = 1; // The current page
|
||
|
|
$sortname = 'menu_id'; // Sort column
|
||
|
|
$sortorder = 'asc'; // Sort order
|
||
|
|
$qtype = ''; // Search column
|
||
|
|
$query = ''; // Search string
|
||
|
|
// Get posted data
|
||
|
|
if (isset($_POST['page'])) {
|
||
|
|
$page = mysqli_real_escape_string($conn,$_POST['page']);
|
||
|
|
}
|
||
|
|
if (isset($_POST['sortname'])) {
|
||
|
|
$sortname = mysqli_real_escape_string($conn,$_POST['sortname']);
|
||
|
|
}
|
||
|
|
if (isset($_POST['sortorder'])) {
|
||
|
|
$sortorder = mysqli_real_escape_string($conn,$_POST['sortorder']);
|
||
|
|
}
|
||
|
|
if (isset($_POST['qtype'])) {
|
||
|
|
$qtype = mysqli_real_escape_string($conn,$_POST['qtype']);
|
||
|
|
}
|
||
|
|
if (isset($_POST['query'])) {
|
||
|
|
$query = mysqli_real_escape_string($conn,$_POST['query']);
|
||
|
|
}
|
||
|
|
if (isset($_POST['rp'])) {
|
||
|
|
$rp = mysqli_real_escape_string($conn,$_POST['rp']);
|
||
|
|
}
|
||
|
|
// Setup sort and search SQL using posted data
|
||
|
|
$sortSql = "order by $sortname $sortorder";
|
||
|
|
$searchSql = ($qtype != '' && $query != '') ? "where $qtype like '%$query%'" : '';
|
||
|
|
// Get total count of records
|
||
|
|
$sql = "select count(*)from menu_master $searchSql";
|
||
|
|
$result = mysqli_query($conn,$sql);
|
||
|
|
$row = mysqli_fetch_array($result);
|
||
|
|
$total = $row[0];
|
||
|
|
// Setup paging SQL
|
||
|
|
$pageStart = ($page-1)*$rp;
|
||
|
|
$limitSql = "limit $pageStart, $rp";
|
||
|
|
// Return JSON data
|
||
|
|
$data = array();
|
||
|
|
$data['page'] = $page;
|
||
|
|
$data['total'] = $total;
|
||
|
|
$data['rows'] = array();
|
||
|
|
$sql = "select menu_id, menu_name, menu_description, menu_url,icon_text,disp_seq,parent_id
|
||
|
|
from menu_master $searchSql $sortSql $limitSql";
|
||
|
|
$results = mysqli_query($conn,$sql);
|
||
|
|
while ($row = @mysqli_fetch_assoc($results)) {
|
||
|
|
|
||
|
|
$menu_id_val=$row['menu_id'];
|
||
|
|
|
||
|
|
if($access_level=='R' )
|
||
|
|
{
|
||
|
|
$view_link="<a href=\"#\"class=\"grey\" onclick=\"open_menu('$menu_id_val','$access_level')\"><span class=\"fa fa-eye bigger-130\"></span></a>";
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
if($access_level=='W' || $access_level=='E' )
|
||
|
|
{
|
||
|
|
$edit_link="<a href=\"#\"class=\"blue\" onclick=\"open_menu('$menu_id_val','$access_level')\"><span class=\"fa fa-edit bigger-130\"></span></a>";
|
||
|
|
}
|
||
|
|
|
||
|
|
if($access_level=='E' )
|
||
|
|
{
|
||
|
|
$delete_link="<a href=\"#\"class=\"red\" onclick=delete_menu('$menu_id_val')><span class=\"glyphicon glyphicon-trash\"></span></a>";
|
||
|
|
}
|
||
|
|
$data['rows'][] = array(
|
||
|
|
'id' => $row['id'],
|
||
|
|
'cell' => array($row['menu_id'], $row['menu_name'], $row['menu_description'], $row['menu_url'],$row['parent_id'],$row['disp_seq'],$row['icon_text'], $view_link, $edit_link, $delete_link)
|
||
|
|
);
|
||
|
|
}
|
||
|
|
echo json_encode($data);
|
||
|
|
?>
|