/home/techb158/workloadmatch.com/Admin

Name	Size	Mode	Actions
dashboard.php	10515	0644	edit dl rm
logs.php	10017	0644	edit dl rm
main-header-inc.php	1195	0644	edit dl rm
main-header.php	7527	0644	edit dl rm
managers.php	21524	0644	edit dl rm
masters.php	21705	0644	edit dl rm
pages.php	15822	0644	edit dl rm
pages_ajax.php	630	0644	edit dl rm
reports.php	9193	0644	edit dl rm
roles.php	15833	0644	edit dl rm
roles_ajax.php	1007	0644	edit dl rm
settings.php	4575	0644	edit dl rm
teachers.php	27850	0644	edit dl rm
teacher_absence.php	305	0644	edit dl rm

Edit: /home/techb158/workloadmatch.com/Admin/reports.php (9193B)

<?php
include_once '../includes/db_connect.php';
include_once '../includes/functions.php';

sec_session_start();
require_role($mysqli, 'admin_profile');
$page = 'Admin | Reports';
addinfo($page, $mysqli);

// Combined users query
$allUsers = [];

$masters = $mysqli->query("SELECT Master_ID AS id, First_Name, Last_Name, Email, User_Access, Reg_Date AS created_at, 'Master' AS user_type, role_id, NULL AS last_activity FROM master_profile");
if ($masters) {
    while ($r = $masters->fetch_assoc()) { $allUsers[] = $r; }
}

$managers = $mysqli->query("SELECT Manager_ID AS id, First_Name, Last_Name, Email, User_Access, Reg_Date AS created_at, 'Manager' AS user_type, role_id, last_activity FROM manager_profile");
if ($managers) {
    while ($r = $managers->fetch_assoc()) { $allUsers[] = $r; }
}

$teachers = $mysqli->query("SELECT Teacher_ID AS id, First_Name, Last_Name, Email, User_Access, Reg_Date AS created_at, 'Teacher' AS user_type, role_id, last_activity FROM teacher_profile");
if ($teachers) {
    while ($r = $teachers->fetch_assoc()) { $allUsers[] = $r; }
}

// Sort by created_at descending
usort($allUsers, function($a, $b) {
    return strtotime($b['created_at'] ?? '1970-01-01') - strtotime($a['created_at'] ?? '1970-01-01');
});
?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>Admin | Reports</title>
  <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  <link rel="icon" href="dist/img/avatar.png" sizes="32x32" />
  <link rel="stylesheet" href="bower_components/bootstrap/dist/css/bootstrap.min.css">
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.5.0/css/font-awesome.min.css">
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">
  <link rel="stylesheet" href="dist/css/AdminLTE.min.css">
  <link rel="stylesheet" href="dist/css/skins/skin-black-light.min.css">
  <link rel="stylesheet" href="plugins/datatables/dataTables.bootstrap.css">
  <link rel="stylesheet" href="https://cdn.datatables.net/1.10.13/css/jquery.dataTables.min.css">
  <link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.2.4/css/buttons.dataTables.min.css">
</head>
<body class="hold-transition skin-black-light sidebar-mini">
<?php if (login_check($mysqli) == true) : ?>
<?php display_flash_msg(); include 'main-header-inc.php'; ?>
<div class="wrapper">
<?php include 'main-header.php'; ?>
<div class="content-wrapper">
  <section class="content-header">
    <h1>Reports <small>System reports and summaries</small></h1>
    <ol class="breadcrumb">
      <li><a href="<?php echo BASE_URL; ?>/dashboard"><i class="fa fa-dashboard"></i> Home</a></li>
      <li class="active">Reports</li>
    </ol>
  </section>
  <section class="content">
    <div class="row">
      <div class="col-lg-3 col-xs-6">
        <div class="small-box bg-aqua">
          <div class="inner"><h3>Masters</h3><p>Master accounts report</p></div>
          <div class="icon"><i class="ion ion-ios-people"></i></div>
          <a href="<?php echo BASE_URL; ?>/masters" class="small-box-footer">View Masters <i class="fa fa-arrow-circle-right"></i></a>
        </div>
      </div>
      <div class="col-lg-3 col-xs-6">
        <div class="small-box bg-green">
          <div class="inner"><h3>Managers</h3><p>Manager accounts report</p></div>
          <div class="icon"><i class="ion ion-ios-people-outline"></i></div>
          <a href="<?php echo BASE_URL; ?>/managers" class="small-box-footer">View Managers <i class="fa fa-arrow-circle-right"></i></a>
        </div>
      </div>
      <div class="col-lg-3 col-xs-6">
        <div class="small-box bg-yellow">
          <div class="inner"><h3>Teachers</h3><p>Teacher accounts report</p></div>
          <div class="icon"><i class="ion ion-person-add"></i></div>
          <a href="<?php echo BASE_URL; ?>/teachers" class="small-box-footer">View Teachers <i class="fa fa-arrow-circle-right"></i></a>
        </div>
      </div>
      <div class="col-lg-3 col-xs-6">
        <div class="small-box bg-red">
          <div class="inner"><h3>Activity Logs</h3><p>System activity report</p></div>
          <div class="icon"><i class="ion ion-document-text"></i></div>
          <a href="<?php echo BASE_URL; ?>/logs" class="small-box-footer">View Logs <i class="fa fa-arrow-circle-right"></i></a>
        </div>
      </div>
    </div>
    <div class="row">
      <div class="col-xs-12">
        <div class="box box-primary">
          <div class="box-header with-border">
            <h3 class="box-title">User Access Report</h3>
          </div>
          <div class="box-body">
            <div class="row" style="margin-bottom:15px;">
              <div class="col-md-4">
                <label>User Type</label>
                <select id="filterType" class="form-control">
                  <option value="">All Types</option>
                  <option value="Master">Master</option>
                  <option value="Manager">Manager</option>
                  <option value="Teacher">Teacher</option>
                </select>
              </div>
              <div class="col-md-4">
                <label>Status</label>
                <select id="filterStatus" class="form-control">
                  <option value="">All Statuses</option>
                  <option value="Active">Active</option>
                  <option value="Disabled">Disabled</option>
                </select>
              </div>
            </div>
            <table id="userAccessTable" class="table table-bordered table-striped">
              <thead>
                <tr>
                  <th>Name</th>
                  <th>Email</th>
                  <th>Type</th>
                  <th>Status</th>
                  <th>Last Login</th>
                  <th>Actions</th>
                </tr>
              </thead>
              <tbody>
                <?php foreach ($allUsers as $u):
                    $statusLabel = ($u['User_Access'] == 1) ? '<span class="label label-success">Active</span>' : '<span class="label label-danger">Disabled</span>';
                    $typeLabel = htmlspecialchars($u['user_type']);
                    $name = htmlspecialchars($u['First_Name'] . ' ' . $u['Last_Name']);
                    $email = htmlspecialchars($u['Email']);
                    $lastLogin = !empty($u['last_activity']) ? htmlspecialchars($u['last_activity']) : '<span class="text-muted">Never</span>';
                    $manageLink = BASE_URL . '/' . strtolower($u['user_type']) . 's';
                ?>
                <tr>
                  <td><?php echo $name; ?></td>
                  <td><?php echo $email; ?></td>
                  <td><?php echo $typeLabel; ?></td>
                  <td><?php echo $statusLabel; ?></td>
                  <td><?php echo $lastLogin; ?></td>
                  <td><a href="<?php echo $manageLink; ?>" class="btn btn-xs btn-primary"><i class="fa fa-external-link"></i> Manage</a></td>
                </tr>
                <?php endforeach; ?>
              </tbody>
            </table>
          </div>
        </div>
      </div>
    </div>
  </section>
</div>
<?php include '../footer.php'; ?>
</div>

$('#filterType').on('change', function() {
    table.column(2).search($(this).val()).draw();
  });

$('#filterStatus').on('change', function() {
    var val = $(this).val();
    table.column(3).search(val ? '^' + val + '$' : '', true, false).draw();
  });
});
</script>
<?php else : ?>
  <?php include '../authorized.php'; ?>
<?php endif; ?>
</body>
</html>

query("SELECT Master_ID AS id, First_Name, Last_Name, Email, User_Access, Reg_Date AS created_at, 'Master' AS user_type, role_id, NULL AS last_activity FROM master_profile"); if ($masters) { while ($r = $masters->fetch_assoc()) { $allUsers[] = $r; } } $managers = $mysqli->query("SELECT Manager_ID AS id, First_Name, Last_Name, Email, User_Access, Reg_Date AS created_at, 'Manager' AS user_type, role_id, last_activity FROM manager_profile"); if ($managers) { while ($r = $managers->fetch_assoc()) { $allUsers[] = $r; } } $teachers = $mysqli->query("SELECT Teacher_ID AS id, First_Name, Last_Name, Email, User_Access, Reg_Date AS created_at, 'Teacher' AS user_type, role_id, last_activity FROM teacher_profile"); if ($teachers) { while ($r = $teachers->fetch_assoc()) { $allUsers[] = $r; } } // Sort by created_at descending usort($allUsers, function($a, $b) { return strtotime($b['created_at'] ?? '1970-01-01') - strtotime($a['created_at'] ?? '1970-01-01'); }); ?> Admin | Reports

Reports System reports and summaries

Masters

Master accounts report

View Masters

Managers

Manager accounts report

View Managers

Teachers

Teacher accounts report

View Teachers

Activity Logs

System activity report

View Logs

User Access Report

User Type

Status

Active' : 'Disabled'; $typeLabel = htmlspecialchars($u['user_type']); $name = htmlspecialchars($u['First_Name'] . ' ' . $u['Last_Name']); $email = htmlspecialchars($u['Email']); $lastLogin = !empty($u['last_activity']) ? htmlspecialchars($u['last_activity']) : 'Never'; $manageLink = BASE_URL . '/' . strtolower($u['user_type']) . 's'; ?>

Name	Email	Type	Status	Last Login	Actions
					Manage