Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
CertificateEmailOneAddress.php	8.08 KB	-rw-r--r--	2026-08-24 10:15
SchoolAttendeeBookingForm.php	369 B	-rw-r--r--	2026-04-02 12:19
SchoolAttendeeBookingFormSend.php	544 B	-rw-r--r--	2026-04-02 12:19
SchoolAttendeeBulkEmail.php	19.04 KB	-rw-r--r--	2026-08-24 10:15
SchoolAttendeeFixCase.php	552 B	-rw-r--r--	2026-04-02 12:19
SchoolEventCourseCancelledEmail.php	9.62 KB	-rw-r--r--	2026-08-24 10:15
SchoolEventCoursePostponedEmail.php	13.36 KB	-rw-r--r--	2026-08-24 10:15
SchoolEventInsufficientDelegatesEmail.php	9.05 KB	-rw-r--r--	2026-08-24 10:15
SchoolWeeksCoursesDashboard.php	8.98 KB	-rw-r--r--	2026-08-24 10:15
php_errors.log	966 B	-rw-r--r--	2026-08-21 08:08

Rename

<?php
/**
 * SCE Weeks/Courses dashboard shell (echasl23).
 * Loads cesa-v3 HTML via server-side SSO proxy.
 * ?partial=1 returns only the embed fragment (AJAX pager/filter).
 */
session_start();
ob_start();

if (!function_exists('IsLoggedIn')) {
    include_once $_SERVER['DOCUMENT_ROOT'] . '/echasl23/ewcfg7.php';
    include_once $_SERVER['DOCUMENT_ROOT'] . '/php/includes/require_ewmysql.php';
    cesa_require_ewmysql($_SERVER['DOCUMENT_ROOT'] . '/echasl23/ewmysql7.php');
    include_once $_SERVER['DOCUMENT_ROOT'] . '/echasl23/phpfn7.php';
    include_once $_SERVER['DOCUMENT_ROOT'] . '/echasl23/userfn7.php';
}

include_once $_SERVER['DOCUMENT_ROOT'] . '/cfg/config.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/php/includes/Utils.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/php/includes/SchoolWeeksCoursesDashboardProxy.php';

SchoolWeeksCoursesDashboardProxy::ensureEnvLoaded();

$isPartial = isset($_GET['partial']) && (string) $_GET['partial'] === '1';

if (defined('EW_SESSION_STATUS') && (!isset($_SESSION[EW_SESSION_STATUS]) || $_SESSION[EW_SESSION_STATUS] !== 'login')) {
    if ($isPartial) {
        header('HTTP/1.1 401 Unauthorized');
        header('Content-Type: text/plain; charset=UTF-8');
        echo 'Session expired. Please log in again.';
        exit;
    }
    header('Location: /echasl23/login.php');
    exit;
}

if (function_exists('AllowListMenu') && !AllowListMenu('cstWeeksCourses')) {
    if ($isPartial) {
        header('HTTP/1.1 403 Forbidden');
        header('Content-Type: text/plain; charset=UTF-8');
        echo 'Access denied.';
        exit;
    }
    header('Location: /echasl23/login.php');
    exit;
}

$username = '';
if (defined('EW_SESSION_USER_NAME') && isset($_SESSION[EW_SESSION_USER_NAME])) {
    $username = trim((string) $_SESSION[EW_SESSION_USER_NAME]);
}

$filters = [
    'from' => isset($_GET['from']) ? trim((string) $_GET['from']) : null,
    'to' => isset($_GET['to']) ? trim((string) $_GET['to']) : null,
    'q' => isset($_GET['q']) ? trim((string) $_GET['q']) : null,
    'page' => isset($_GET['page']) ? trim((string) $_GET['page']) : null,
    'per_page' => isset($_GET['per_page']) ? trim((string) $_GET['per_page']) : null,
    'sort' => isset($_GET['sort']) ? trim((string) $_GET['sort']) : null,
    'dir' => isset($_GET['dir']) ? trim((string) $_GET['dir']) : null,
];
foreach ($filters as $k => $v) {
    if ($v === '') {
        $filters[$k] = null;
    }
}

$isExport = isset($_GET['export']) && (string) $_GET['export'] === '1';
if ($isExport) {
    $exportResult = SchoolWeeksCoursesDashboardProxy::fetchExportBinary($username, $filters);
    if (empty($exportResult['ok'])) {
        header('HTTP/1.1 502 Bad Gateway');
        header('Content-Type: text/plain; charset=UTF-8');
        echo isset($exportResult['error']) ? (string) $exportResult['error'] : 'Export failed.';
        exit;
    }
    $filename = !empty($exportResult['filename']) ? (string) $exportResult['filename'] : 'sce-weeks-courses.xlsx';
    $contentType = !empty($exportResult['content_type'])
        ? (string) $exportResult['content_type']
        : 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet';
    header('Content-Type: ' . $contentType);
    header('Content-Disposition: attachment; filename="' . $filename . '"');
    header('Cache-Control: no-store, no-cache, must-revalidate');
    echo (string) $exportResult['body'];
    exit;
}

$result = SchoolWeeksCoursesDashboardProxy::fetchEmbedHtml($username, $filters);
$embedOk = !empty($result['ok']);
$embedHtml = $embedOk ? (string) $result['html'] : '';
$embedError = $embedOk ? '' : (string) $result['error'];

if ($isPartial) {
    header('Content-Type: text/html; charset=UTF-8');
    header('Cache-Control: no-store, no-cache, must-revalidate');
    if ($embedError !== '') {
        echo '<div class="alert alert-danger" style="margin:12px 0;padding:10px;border:1px solid #c00;background:#fee;">'
            . htmlspecialchars($embedError, ENT_QUOTES, 'UTF-8')
            . '</div>';
        exit;
    }
    echo $embedHtml;
    exit;
}
?>
<?php include $_SERVER['DOCUMENT_ROOT'] . '/echasl23/header.php'; ?>
<link href="/css/shared.css?v=sce-wc-ux-20260814" rel="stylesheet" type="text/css" />

<p><span class="phpmaker" style="white-space: nowrap;">School of Consulting Engineering Courses dashboard</span></p>

<?php
if ($embedHtml !== '') {
    echo $embedHtml;
}
?>
</div>

var loading = false;

function loadPartial(params, pushHistory) {
        if (loading) {
            return;
        }
        loading = true;
        root.style.opacity = '0.55';

fetch(buildUrl(params), {
            method: 'GET',
            credentials: 'same-origin',
            headers: { 'X-Requested-With': 'XMLHttpRequest' }
        }).then(function (res) {
            return res.text().then(function (html) {
                if (!res.ok) {
                    throw new Error(html || ('HTTP ' + res.status));
                }
                root.innerHTML = html;
                if (pushHistory) {
                    history.pushState(params, '', historyUrl(params));
                }
                var dash = root.querySelector('.sce-wc-dash');
                if (dash && dash.scrollIntoView) {
                    dash.scrollIntoView({ block: 'start' });
                }
            });
        }).catch(function (err) {
            root.innerHTML = '<div class="alert alert-danger" style="margin:12px 0;padding:10px;border:1px solid #c00;background:#fee;">'
                + 'Unable to refresh dashboard. ' + String(err && err.message ? err.message : err)
                + '</div>';
        }).then(function () {
            loading = false;
            root.style.opacity = '1';
        });
    }

root.addEventListener('submit', function (ev) {
        var form = ev.target;
        if (!form || !form.classList || !form.classList.contains('sce-wc-filters')) {
            return;
        }
        ev.preventDefault();
        var params = readFormParams(form);
        params.page = '1';
        loadPartial(params, true);
    });

root.addEventListener('click', function (ev) {
        var link = ev.target.closest('a[data-sce-wc-ajax]');
        if (!link || !root.contains(link)) {
            return;
        }
        ev.preventDefault();
        var params = {};
        ['from', 'to', 'q', 'page', 'per_page', 'sort', 'dir'].forEach(function (key) {
            if (link.hasAttribute('data-' + key)) {
                params[key] = link.getAttribute('data-' + key) || '';
            }
        });
        loadPartial(params, true);
    });

root.addEventListener('change', function (ev) {
        var sel = ev.target;
        if (!sel || sel.id !== 'sce_wc_per_page') {
            return;
        }
        var form = sel.form;
        if (!form) {
            return;
        }
        var params = readFormParams(form);
        params.page = '1';
        params.per_page = sel.value;
        loadPartial(params, true);
    });

<?php include $_SERVER['DOCUMENT_ROOT'] . '/echasl23/footer.php'; ?>