/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/logs.php (10017B)

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

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

$totalLogs = 0;
$cnt = $mysqli->query("SELECT COUNT(*) FROM activity_logs");
if ($cnt) { $totalLogs = $cnt->fetch_row()[0]; }

// Clear old logs
if (isset($_POST['clear_old_logs'])) {
    $days = intval($_POST['days']);
    if ($days > 0) {
        $stmt = $mysqli->prepare("DELETE FROM activity_logs WHERE created_at < NOW() - INTERVAL ? DAY");
        $stmt->bind_param('i', $days);
        if ($stmt->execute()) {
            $deleted = $stmt->affected_rows;
            set_flash_msg("Deleted $deleted log entries older than $days days.", 'success');
            log_activity($mysqli, 'clear_old_logs', 'logs', null, "Cleared logs older than $days days");
        } else {
            set_flash_msg('Error clearing logs.', 'danger');
        }
        $stmt->close();
    } else {
        set_flash_msg('Invalid number of days.', 'warning');
    }
    header('Location: ' . $_SERVER['PHP_SELF']);
    exit;
}
?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>Admin | Activity Logs</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">
  <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker-bs3.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>Activity Logs <small>View and manage system activity</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">Activity Logs</li>
    </ol>
  </section>
  <section class="content">
    <div class="row">
      <div class="col-xs-12">
        <div class="small-box bg-aqua">
          <div class="inner"><h3><?php echo $totalLogs; ?></h3><p>Total Log Entries</p></div>
          <div class="icon"><i class="ion ion-document-text"></i></div>
        </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">Log Entries</h3>
            <div class="box-tools pull-right">
              <button class="btn btn-danger btn-sm" data-toggle="modal" data-target="#clearLogsModal"><i class="fa fa-trash"></i> Clear Old Logs</button>
            </div>
          </div>
          <div class="box-body">
            <div class="row" style="margin-bottom:15px;">
              <div class="col-md-3">
                <label>User Role</label>
                <select id="filterRole" class="form-control">
                  <option value="">All Roles</option>
                  <option value="admin_profile">Admin</option>
                  <option value="master_profile">Master</option>
                  <option value="manager_profile">Manager</option>
                  <option value="teacher_profile">Teacher</option>
                </select>
              </div>
              <div class="col-md-3">
                <label>Search Action</label>
                <input type="text" id="filterAction" class="form-control" placeholder="Type to filter...">
              </div>
              <div class="col-md-3">
                <label>From Date</label>
                <input type="date" id="filterDateFrom" class="form-control">
              </div>
              <div class="col-md-3">
                <label>To Date</label>
                <input type="date" id="filterDateTo" class="form-control">
              </div>
            </div>
            <table id="logsTable" class="table table-bordered table-striped">
              <thead>
                <tr>
                  <th>ID</th>
                  <th>User ID</th>
                  <th>User Role</th>
                  <th>Action</th>
                  <th>Target Type</th>
                  <th>Target Name</th>
                  <th>Status</th>
                  <th>IP</th>
                  <th>Date</th>
                </tr>
              </thead>
              <tbody>
                <?php
                $logs = $mysqli->query("SELECT * FROM activity_logs ORDER BY created_at DESC");
                if ($logs):
                  while ($row = $logs->fetch_assoc()):
                    $statusLabel = $row['status'] === 'success' ? '<span class="label label-success">Success</span>' : ($row['status'] === 'error' ? '<span class="label label-danger">Error</span>' : '<span class="label label-default">' . htmlspecialchars($row['status'] ?? '') . '</span>');
                ?>
                <tr>
                  <td><?php echo (int)$row['id']; ?></td>
                  <td><?php echo htmlspecialchars($row['user_id']); ?></td>
                  <td><?php echo htmlspecialchars($row['user_role']); ?></td>
                  <td><?php echo htmlspecialchars($row['action']); ?></td>
                  <td><?php echo htmlspecialchars($row['target_type'] ?? ''); ?></td>
                  <td><?php echo htmlspecialchars($row['target_name'] ?? ''); ?></td>
                  <td><?php echo $statusLabel; ?></td>
                  <td><?php echo htmlspecialchars($row['ip_address'] ?? ''); ?></td>
                  <td><?php echo htmlspecialchars($row['created_at'] ?? ''); ?></td>
                </tr>
                <?php
                  endwhile;
                endif;
                ?>
              </tbody>
            </table>
          </div>
        </div>
      </div>
    </div>
  </section>
</div>

<div class="modal fade" id="clearLogsModal" tabindex="-1">
  <div class="modal-dialog">
    <div class="modal-content">
      <form method="post">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal">&times;</button>
          <h4 class="modal-title">Clear Old Logs</h4>
        </div>
        <div class="modal-body">
          <p>Delete log entries older than how many days?</p>
          <div class="form-group">
            <input type="number" name="days" class="form-control" value="90" min="1" required>
          </div>
          <p class="text-muted">This action cannot be undone.</p>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
          <button type="submit" name="clear_old_logs" class="btn btn-danger"><i class="fa fa-trash"></i> Clear Logs</button>
        </div>
      </form>
    </div>
  </div>
</div>

<?php include '../footer.php'; ?>
</div>

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

$('#filterAction').on('keyup', function() {
    table.column(3).search($(this).val()).draw();
  });

$.fn.dataTable.ext.search.push(function(settings, data, dataIndex) {
    var from = $('#filterDateFrom').val();
    var to = $('#filterDateTo').val();
    var date = data[8] || '';
    if (!from && !to) return true;
    if (from && date < from) return false;
    if (to && date > to + ' 23:59:59') return false;
    return true;
  });

$('#filterDateFrom, #filterDateTo').on('change', function() {
    table.draw();
  });
});
</script>
<?php else : ?>
  <?php include '../authorized.php'; ?>
<?php endif; ?>
</body>
</html>

query("SELECT COUNT(*) FROM activity_logs"); if ($cnt) { $totalLogs = $cnt->fetch_row()[0]; } // Clear old logs if (isset($_POST['clear_old_logs'])) { $days = intval($_POST['days']); if ($days > 0) { $stmt = $mysqli->prepare("DELETE FROM activity_logs WHERE created_at < NOW() - INTERVAL ? DAY"); $stmt->bind_param('i', $days); if ($stmt->execute()) { $deleted = $stmt->affected_rows; set_flash_msg("Deleted $deleted log entries older than $days days.", 'success'); log_activity($mysqli, 'clear_old_logs', 'logs', null, "Cleared logs older than $days days"); } else { set_flash_msg('Error clearing logs.', 'danger'); } $stmt->close(); } else { set_flash_msg('Invalid number of days.', 'warning'); } header('Location: ' . $_SERVER['PHP_SELF']); exit; } ?> Admin | Activity Logs

Activity Logs View and manage system activity

Total Log Entries

Log Entries

User Role

Search Action

From Date

To Date

query("SELECT * FROM activity_logs ORDER BY created_at DESC"); if ($logs): while ($row = $logs->fetch_assoc()): $statusLabel = $row['status'] === 'success' ? 'Success' : ($row['status'] === 'error' ? 'Error' : '' . htmlspecialchars($row['status'] ?? '') . ''); ?>

ID	User ID	User Role	Action	Target Type	Target Name	Status	IP	Date