/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/dashboard.php (10515B)

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

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

// Counts
$totalMasters = $mysqli->query("SELECT COUNT(*) FROM master_profile")->fetch_row()[0];
$totalManagers = $mysqli->query("SELECT COUNT(*) FROM manager_profile")->fetch_row()[0];
$totalTeachers = $mysqli->query("SELECT COUNT(*) FROM teacher_profile")->fetch_row()[0];
$totalRoles = $mysqli->query("SELECT COUNT(*) FROM roles")->fetch_row()[0];

$activeMasters = $mysqli->query("SELECT COUNT(*) FROM master_profile WHERE User_Access = 1")->fetch_row()[0];
$disabledMasters = $mysqli->query("SELECT COUNT(*) FROM master_profile WHERE User_Access = 0")->fetch_row()[0];
$activeManagers = $mysqli->query("SELECT COUNT(*) FROM manager_profile WHERE User_Access = 1")->fetch_row()[0];
$disabledManagers = $mysqli->query("SELECT COUNT(*) FROM manager_profile WHERE User_Access = 0")->fetch_row()[0];
$activeTeachers = $mysqli->query("SELECT COUNT(*) FROM teacher_profile WHERE User_Access = 1")->fetch_row()[0];
$disabledTeachers = $mysqli->query("SELECT COUNT(*) FROM teacher_profile WHERE User_Access = 0")->fetch_row()[0];

// Recent Activity
$recentLogs = [];
$logStmt = $mysqli->query("SELECT * FROM activity_logs ORDER BY created_at DESC LIMIT 10");
if ($logStmt) {
    while ($row = $logStmt->fetch_assoc()) {
        $recentLogs[] = $row;
    }
}
?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>Admin | Dashboard</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">
  <style>
    .small-box .inner h3 { font-size: 2.2em; margin: 0; padding: 10px 0; }
    .quick-action-btn { margin-bottom: 10px; }
  </style>
</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>Dashboard <small>Admin Overview</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">Dashboard</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><?php echo $totalMasters; ?></h3><p>Total Masters</p></div>
          <div class="icon"><i class="ion ion-ios-people"></i></div>
          <a href="<?php echo BASE_URL; ?>/masters" class="small-box-footer">More info <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><?php echo $totalManagers; ?></h3><p>Total Managers</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">More info <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><?php echo $totalTeachers; ?></h3><p>Total Teachers</p></div>
          <div class="icon"><i class="ion ion-person-add"></i></div>
          <a href="<?php echo BASE_URL; ?>/teachers" class="small-box-footer">More info <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><?php echo $totalRoles; ?></h3><p>Total Roles</p></div>
          <div class="icon"><i class="ion ion-lock"></i></div>
          <a href="<?php echo BASE_URL; ?>/roles" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
        </div>
      </div>
    </div>
    <div class="row">
      <div class="col-lg-2 col-xs-4">
        <div class="small-box bg-green">
          <div class="inner"><h3><?php echo $activeMasters; ?></h3><p>Active Masters</p></div>
          <div class="icon"><i class="ion ion-checkmark-circled"></i></div>
        </div>
      </div>
      <div class="col-lg-2 col-xs-4">
        <div class="small-box bg-red">
          <div class="inner"><h3><?php echo $disabledMasters; ?></h3><p>Disabled Masters</p></div>
          <div class="icon"><i class="ion ion-close-circled"></i></div>
        </div>
      </div>
      <div class="col-lg-2 col-xs-4">
        <div class="small-box bg-green">
          <div class="inner"><h3><?php echo $activeManagers; ?></h3><p>Active Managers</p></div>
          <div class="icon"><i class="ion ion-checkmark-circled"></i></div>
        </div>
      </div>
      <div class="col-lg-2 col-xs-4">
        <div class="small-box bg-red">
          <div class="inner"><h3><?php echo $disabledManagers; ?></h3><p>Disabled Managers</p></div>
          <div class="icon"><i class="ion ion-close-circled"></i></div>
        </div>
      </div>
      <div class="col-lg-2 col-xs-4">
        <div class="small-box bg-green">
          <div class="inner"><h3><?php echo $activeTeachers; ?></h3><p>Active Teachers</p></div>
          <div class="icon"><i class="ion ion-checkmark-circled"></i></div>
        </div>
      </div>
      <div class="col-lg-2 col-xs-4">
        <div class="small-box bg-red">
          <div class="inner"><h3><?php echo $disabledTeachers; ?></h3><p>Disabled Teachers</p></div>
          <div class="icon"><i class="ion ion-close-circled"></i></div>
        </div>
      </div>
    </div>
    <div class="row">
      <div class="col-md-8">
        <div class="box box-primary">
          <div class="box-header with-border"><h3 class="box-title">Recent Activity</h3></div>
          <div class="box-body table-responsive no-padding">
            <table class="table table-bordered table-striped">
              <thead><tr><th>User</th><th>Action</th><th>Target</th><th>Date</th><th>IP</th></tr></thead>
              <tbody>
                <?php foreach ($recentLogs as $log): ?>
                <tr>
                  <td><?php echo htmlspecialchars($log['user_id']); ?> (<?php echo htmlspecialchars($log['user_role']); ?>)</td>
                  <td><?php echo htmlspecialchars($log['action']); ?></td>
                  <td><?php echo htmlspecialchars($log['target_type'] ?? 'N/A') . ' - ' . htmlspecialchars($log['target_name'] ?? ''); ?></td>
                  <td><?php echo htmlspecialchars($log['created_at'] ?? ''); ?></td>
                  <td><?php echo htmlspecialchars($log['ip_address'] ?? ''); ?></td>
                </tr>
                <?php endforeach; ?>
                <?php if (empty($recentLogs)): ?>
                <tr><td colspan="5" class="text-center">No recent activity.</td></tr>
                <?php endif; ?>
              </tbody>
            </table>
          </div>
          <div class="box-footer">
            <a href="<?php echo BASE_URL; ?>/logs" class="btn btn-default btn-sm"><i class="fa fa-history"></i> View All Logs</a>
          </div>
        </div>
      </div>
      <div class="col-md-4">
        <div class="box box-success">
          <div class="box-header with-border"><h3 class="box-title">Quick Actions</h3></div>
          <div class="box-body">
            <a href="<?php echo BASE_URL; ?>/masters" class="btn btn-block btn-primary quick-action-btn"><i class="fa fa-user-circle-o"></i> Manage Masters</a>
            <a href="<?php echo BASE_URL; ?>/managers" class="btn btn-block btn-info quick-action-btn"><i class="fa fa-users"></i> Manage Managers</a>
            <a href="<?php echo BASE_URL; ?>/teachers" class="btn btn-block btn-warning quick-action-btn"><i class="fa fa-graduation-cap"></i> Manage Teachers</a>
            <a href="<?php echo BASE_URL; ?>/roles" class="btn btn-block btn-danger quick-action-btn"><i class="fa fa-lock"></i> Roles &amp; Permissions</a>
            <a href="<?php echo BASE_URL; ?>/reports" class="btn btn-block btn-success quick-action-btn"><i class="fa fa-bar-chart-o"></i> Reports</a>
            <a href="<?php echo BASE_URL; ?>/logs" class="btn btn-block btn-default quick-action-btn"><i class="fa fa-history"></i> Activity Logs</a>
          </div>
        </div>
        <div class="box box-default">
          <div class="box-header with-border"><h3 class="box-title">System Overview</h3></div>
          <div class="box-body">
            <dl class="dl-horizontal">
              <dt>PHP Version</dt><dd><?php echo phpversion(); ?></dd>
              <dt>Database</dt><dd><?php echo defined('DATABASE') ? DATABASE : 'N/A'; ?></dd>
              <dt>Base URL</dt><dd><?php echo BASE_URL; ?></dd>
              <dt>Total Users</dt><dd><?php echo $totalMasters + $totalManagers + $totalTeachers; ?></dd>
              <dt>Total Roles</dt><dd><?php echo $totalRoles; ?></dd>
            </dl>
          </div>
        </div>
      </div>
    </div>
  </section>
</div>
<?php include '../footer.php'; ?>
</div>

query("SELECT COUNT(*) FROM master_profile")->fetch_row()[0]; $totalManagers = $mysqli->query("SELECT COUNT(*) FROM manager_profile")->fetch_row()[0]; $totalTeachers = $mysqli->query("SELECT COUNT(*) FROM teacher_profile")->fetch_row()[0]; $totalRoles = $mysqli->query("SELECT COUNT(*) FROM roles")->fetch_row()[0]; $activeMasters = $mysqli->query("SELECT COUNT(*) FROM master_profile WHERE User_Access = 1")->fetch_row()[0]; $disabledMasters = $mysqli->query("SELECT COUNT(*) FROM master_profile WHERE User_Access = 0")->fetch_row()[0]; $activeManagers = $mysqli->query("SELECT COUNT(*) FROM manager_profile WHERE User_Access = 1")->fetch_row()[0]; $disabledManagers = $mysqli->query("SELECT COUNT(*) FROM manager_profile WHERE User_Access = 0")->fetch_row()[0]; $activeTeachers = $mysqli->query("SELECT COUNT(*) FROM teacher_profile WHERE User_Access = 1")->fetch_row()[0]; $disabledTeachers = $mysqli->query("SELECT COUNT(*) FROM teacher_profile WHERE User_Access = 0")->fetch_row()[0]; // Recent Activity $recentLogs = []; $logStmt = $mysqli->query("SELECT * FROM activity_logs ORDER BY created_at DESC LIMIT 10"); if ($logStmt) { while ($row = $logStmt->fetch_assoc()) { $recentLogs[] = $row; } } ?> Admin | Dashboard

Dashboard Admin Overview

Total Masters

More info

Total Managers

More info

Total Teachers

More info

Total Roles

More info

Active Masters

Disabled Masters

Active Managers

Disabled Managers

Active Teachers

Disabled Teachers

Recent Activity

User	Action	Target	Date	IP
()
No recent activity.

View All Logs

Quick Actions

Manage Masters Manage Managers Manage Teachers Roles & Permissions Reports Activity Logs

System Overview

PHP Version
Database
Base URL
Total Users
Total Roles