FM / routes

/home/techb158/workloadmatch.com/api/routes/

/home/techb158/workloadmatch.com/api/routes

Name	Size	Mode	Actions
ai_generate.php	11642	0644	edit dl rm
assignments.php	9931	0644	edit dl rm
auth.php	6697	0644	edit dl rm
chat.php	9934	0644	edit dl rm
courses.php	7225	0644	edit dl rm
coursesessions.php	6705	0644	edit dl rm
dashboard.php	6232	0644	edit dl rm
groups.php	11099	0644	edit dl rm
logs.php	3587	0644	edit dl rm
managers.php	9612	0644	edit dl rm
masters.php	6685	0644	edit dl rm
notifications.php	5975	0644	edit dl rm
preferences.php	6487	0644	edit dl rm
programs.php	4882	0644	edit dl rm
reports.php	13696	0644	edit dl rm
roles.php	8516	0644	edit dl rm
schedules.php	11042	0644	edit dl rm
settings.php	4295	0644	edit dl rm
teachers.php	16013	0644	edit dl rm
timeslots.php	4807	0644	edit dl rm

Edit: /home/techb158/workloadmatch.com/api/routes/settings.php (4295B)

<?php

function listSettings(mysqli $mysqli): void
{
    Auth::requireRole('admin_profile');

// Return app-level config info
    $data = [
        'app_name'    => 'WorkloadMatch',
        'app_version' => '1.0.0',
        'php_version' => PHP_VERSION,
        'db_host'     => HOST,
        'db_name'     => DATABASE,
        'secure'      => (bool)SECURE,
        'timezone'    => date_default_timezone_get(),
        'date_format' => 'Y-m-d',
        'time_format' => 'H:i:s',
    ];

// Get page control settings
    $r = $mysqli->query("SELECT * FROM pages_control ORDER BY module, page_name");
    $data['pages'] = $r->fetch_all(MYSQLI_ASSOC);
    $r->close();

Response::success($data);
}

function getSetting(string $id, mysqli $mysqli): void
{
    Auth::requireRole('admin_profile');

if ($id === 'page' && !empty($_GET['key'])) {
        $stmt = $mysqli->prepare("SELECT * FROM pages_control WHERE page_key = ? LIMIT 1");
        $stmt->bind_param('s', $_GET['key']);
        $stmt->execute();
        $result = $stmt->get_result();
        $item = $result->fetch_assoc();
        $stmt->close();
        if (!$item) Response::notFound('Page setting not found');
        Response::success($item);
    }

Response::notFound("Setting: $id");
}

function updateSetting(?string $id, ?array $body, mysqli $mysqli): void
{
    Auth::requireRole('admin_profile');

if ($id === 'password-policy') {
        // Placeholder for password policy settings
        Response::success(null, 'Settings updated');
    }

if ($id === 'page' && !empty($_GET['key']) && isset($body['status'])) {
        $stmt = $mysqli->prepare("UPDATE pages_control SET status = ? WHERE page_key = ?");
        $stmt->bind_param('is', $body['status'], $_GET['key']);
        $stmt->execute();
        $stmt->close();

log_activity($mysqli, 'update', 'page_settings', 0, "Page {$_GET['key']} status changed", 'Page setting updated via API');
        Response::success(null, 'Page setting updated');
    }

Response::notFound("Setting: $id");
}

function listPageSettings(mysqli $mysqli): void
{
    Auth::requireAnyRole(['admin_profile', 'master_profile']);

$module = $_GET['module'] ?? null;
    $wheres = [];
    $params = [];
    $types  = '';

if ($module) {
        $wheres[] = 'module = ?';
        $params[] = $module;
        $types   .= 's';
    }

$whereClause = $wheres ? 'WHERE ' . implode(' AND ', $wheres) : '';

$stmt = $mysqli->prepare("SELECT * FROM pages_control $whereClause ORDER BY module, page_name");
    if ($params) $stmt->bind_param($types, ...$params);
    $stmt->execute();
    $result = $stmt->get_result();
    $items = $result->fetch_all(MYSQLI_ASSOC);
    $stmt->close();

Response::success($items);
}

function updatePageSettings(?array $body, mysqli $mysqli): void
{
    Auth::requireRole('admin_profile');

if (!$body || !isset($body['pages']) || !is_array($body['pages'])) {
        Response::validationError(['pages' => 'Array of page settings required']);
    }

$updated = 0;
    foreach ($body['pages'] as $page) {
        if (!isset($page['page_key'], $page['status'])) continue;

$stmt = $mysqli->prepare("UPDATE pages_control SET status = ? WHERE page_key = ?");
        $stmt->bind_param('is', $page['status'], $page['page_key']);
        $stmt->execute();
        if ($stmt->affected_rows > 0) $updated++;
        $stmt->close();
    }

log_activity($mysqli, 'update', 'page_settings', 0, "Updated $updated page settings", 'Bulk page update via API');
    Response::success(null, "Updated $updated page setting(s)");
}

cmd: