86 lines
3.0 KiB
PHP
86 lines
3.0 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/auth/auth.php');
|
|
?>
|
|
<?php
|
|
// Connect to mysqli database
|
|
|
|
$page = 1; // The current page
|
|
$sortname = 'user_name'; // 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']);
|
|
}
|
|
if (!isset($_POST['rp'])) {
|
|
$rp=10;
|
|
}
|
|
// Setup sort and search SQL using posted data
|
|
$sortSql = "order by $sortname $sortorder";
|
|
$searchSql = ($qtype != '' && $query != '') ? " where $qtype = '$query'" : '';
|
|
// Get total count of records
|
|
$sql = "SELECT count(*) FROM tbl_users a left join role_master b on a.role_id=b.role_id $searchSql";
|
|
|
|
$result = mysqli_query($conn,$sql);
|
|
$rowCount = mysqli_fetch_array($result);
|
|
$total = $rowCount[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_list = "SELECT a.user_name ,a.status, a.email, a.user_id, a.role_id, b.role_name, a.remarks, first_name,last_name FROM tbl_users a left join role_master b on a.role_id=b.role_id $searchSql $sortSql $limitSql";
|
|
//echo $sql_list;
|
|
$resultList = mysqli_query($conn,$sql_list);
|
|
$count=1;
|
|
while ($row = mysqli_fetch_assoc($resultList)) {
|
|
|
|
$user_id_val=$row['user_id'];
|
|
$status_val=$row['status'];
|
|
|
|
$view_link="<a href='#' onclick=\"window.open('manage_users.php?acn=view&txt_user_id=$user_id_val','mywindow','menubar=0,resizable=0,status=0,scrollbars=0,width=700,height=500,top=100,left=100')\"><img src='images/view.jpg' border=\"0\" /></a>";
|
|
$edit_link="<a href='#' onclick=\"window.open('manage_users.php?acn=update&txt_user_id=$user_id_val','mywindow','menubar=0,resizable=0,status=0,scrollbars=0,width=700,height=500,top=100,left=100')\"><img src='images/edit.png' border=\"0\" /></a>";
|
|
$activate_link="<a href='#' onclick=deleterecord('manage_users.php?acn=delete&txt_user_id=$user_id_val')><img src='images/drop.png' border=\"0\" /></a>";
|
|
|
|
if($_SESSION['RoleId']!=1)
|
|
{
|
|
$activate_link=" ";
|
|
$edit_link=" ";
|
|
}
|
|
|
|
if($status_val=='1'){
|
|
$status="Active";
|
|
}else{
|
|
$status="Inactive";
|
|
}
|
|
$firstName =$row['first_name'];
|
|
$last_name =$row['last_name'];
|
|
$data['rows'][] = array(
|
|
'id' => $row['id'],
|
|
'cell' => array($count++, $user_id_val, $row['user_name'],$firstName,$last_name, $row['role_name'], $status, $view_link, $edit_link, $activate_link)
|
|
);
|
|
}
|
|
echo json_encode($data);
|
|
?>
|