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

session_start();
ob_start();

$echasl23Dir = $_SERVER['DOCUMENT_ROOT'] . '/echasl23';

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

include_once $_SERVER['DOCUMENT_ROOT'] . '/cfg/config.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/php/includes/sqlFunctions.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/php/includes/maill.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/php/includes/SchoolAttendees.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/contracts/fpdf184/fpdf.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/contracts/FPDI-2.3.6/src/autoload.php';

if (defined('EW_SESSION_STATUS') && (!isset($_SESSION[EW_SESSION_STATUS]) || $_SESSION[EW_SESSION_STATUS] !== 'login')) {
    header('Location: /echasl23/login.php');
    exit;
}

$conni = mysqli_connect(EW_CONN_HOST, EW_CONN_USER, EW_CONN_PASS, EW_CONN_DB);
$schoolAttendees = new SchoolAttendees($sqlf);

$eventId = isset($_REQUEST['EventID']) ? intval($_REQUEST['EventID']) : 0;
if ($eventId <= 0 && isset($_SESSION['EventID'])) {
    $eventId = intval($_SESSION['EventID']);
}

$attendeeIdFilter = array();
if (isset($_REQUEST['AttendeeIDs']) && is_string($_REQUEST['AttendeeIDs']) && $_REQUEST['AttendeeIDs'] !== '') {
    $decoded = json_decode($_REQUEST['AttendeeIDs'], true);
    if (is_array($decoded)) {
        $attendeeIdFilter = $decoded;
    }
}

$errorMessage = '';
$successMessage = '';
$previewRows = array();
$eventName = '';

if ($eventId > 0) {
    $eventRow = $sqlf->getRow('SELECT EventName FROM SchoolEvents WHERE EventID = ' . $eventId . ' LIMIT 1');
    if (is_array($eventRow) && isset($eventRow['EventName'])) {
        $eventName = $eventRow['EventName'];
    }

$eligible = $schoolAttendees->getCertificateEmailAttendees($eventId, $attendeeIdFilter);
    foreach ($eligible as $row) {
        $filePath = $schoolAttendees->generateCertificateFilePath($row['AttendeeID']);
        $fileName = $filePath !== null ? basename($filePath) : '';
        $previewRows[] = array(
            'name' => trim($row['ContactFirstName'] . ' ' . $row['ContactLastName']),
            'email' => $row['EmailAddress'],
            'file' => $fileName,
        );
    }
}

$defaultMessage = '';
if ($eventName !== '') {
    $defaultMessage = "Please find attached all certificates for " . $eventName . ".\r\n\r\n"
        . SchoolAttendees::getSendCertificateBody();
}

$toAddress = isset($_POST['to_address']) ? trim((string) $_POST['to_address']) : '';
if ($toAddress === '' && $_SERVER['REQUEST_METHOD'] !== 'POST') {
    $toAddress = SchoolAttendees::SCHOOL_CERTIFICATE_DEFAULT_EMAIL;
}
$bccAddresses = isset($_POST['bcc_addresses']) ? (string) $_POST['bcc_addresses'] : '';
$emailMessage = isset($_POST['email_message']) ? (string) $_POST['email_message'] : $defaultMessage;
$sendCopySce = !isset($_POST['go']) || isset($_POST['send_copy_sce']);

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['go']) && intval($_POST['go']) === 1) {
    try {
        $result = $schoolAttendees->sendAllCertificatesToOneAddress(array(
            'event_id' => $eventId,
            'to_address' => $toAddress,
            'bcc_addresses' => $bccAddresses,
            'email_message' => $emailMessage,
            'send_copy_sce' => $sendCopySce,
            'attendee_ids' => $attendeeIdFilter,
        ));
        $successMessage = 'Sent one e-mail with ' . intval($result['attachment_count'])
            . ' certificate(s) to ' . htmlspecialchars($result['sent_to'], ENT_QUOTES, 'UTF-8') . '.';
    } catch (Exception $e) {
        $errorMessage = $e->getMessage();
    }
}

$listUrl = '/echasl23/Certificateslist.php?showmaster=SchoolEvents&EventID=' . $eventId;
$refer = isset($_SERVER['HTTP_REFERER']) && $_SERVER['HTTP_REFERER'] !== ''
    ? $_SERVER['HTTP_REFERER']
    : $listUrl;

$certificateEmailCwd = getcwd();
chdir($echasl23Dir);

if (!isset($Language)) {
    if (!class_exists('cLanguage', false)) {
        include_once $echasl23Dir . '/ewshared7.php';
    }
    $Language = new cLanguage();
}

include $echasl23Dir . '/header.php';
?>
<p><span class="phpmaker"><a href="<?php echo htmlspecialchars($refer, ENT_QUOTES, 'UTF-8'); ?>">Return to previous screen</a></span></p>

<?php if ($eventId <= 0) { ?>
<p><span class="phpmaker"><b>No event ID specified.</b></span></p>
<?php } else { ?>

<?php if ($errorMessage !== '') { ?>
<p><span class="phpmaker" style="color:#c00;"><b><?php echo htmlspecialchars($errorMessage, ENT_QUOTES, 'UTF-8'); ?></b></span></p>
<?php } ?>

<?php if ($successMessage !== '') { ?>
<p><span class="phpmaker" style="color:#060;"><b><?php echo $successMessage; ?></b></span></p>
<p><span class="phpmaker"><a href="<?php echo htmlspecialchars($listUrl, ENT_QUOTES, 'UTF-8'); ?>">Back to certificates list</a></span></p>
<?php } else { ?>

<p><span class="phpmaker"><b>Send all certificates to one address</b><?php
if ($eventName !== '') {
    echo ' — ' . htmlspecialchars($eventName, ENT_QUOTES, 'UTF-8');
}
?></span></p>

<?php if (count($previewRows) <= 0) { ?>
<p><span class="phpmaker">No eligible attendees (must be attended and paid for this event).</span></p>
<?php } else { ?>

<p><span class="phpmaker">
        <label for="to_address"><b>To e-mail address</b> (required):</label><br />
        <input type="email" name="to_address" id="to_address" size="60" value="<?php echo htmlspecialchars($toAddress, ENT_QUOTES, 'UTF-8'); ?>" required="required" /><br /><br />

<label for="bcc_addresses"><b>BCC addresses</b> (optional — comma, semicolon, or one per line):</label><br />
        <textarea name="bcc_addresses" id="bcc_addresses" rows="3" cols="60"><?php echo htmlspecialchars($bccAddresses, ENT_QUOTES, 'UTF-8'); ?></textarea><br /><br />

<label for="email_message"><b>E-mail message</b>:</label><br />
        <textarea name="email_message" id="email_message" rows="12" cols="60"><?php echo htmlspecialchars($emailMessage, ENT_QUOTES, 'UTF-8'); ?></textarea><br /><br />

<input type="submit" value="Send <?php echo count($previewRows); ?> certificate(s) in one e-mail" />
    </span></p>
</form>

<p><span class="phpmaker">The following <?php echo count($previewRows); ?> certificate(s) will be attached:</span></p>
<table class="ewTable ewTableSeparate" cellspacing="0">
    <thead>
        <tr class="ewTableHeader">
            <td>Name</td>
            <td>Attendee e-mail</td>
            <td>Certificate file</td>
        </tr>
    </thead>
    <tbody>
        <?php foreach ($previewRows as $preview) { ?>
        <tr>
            <td><?php echo htmlspecialchars($preview['name'], ENT_QUOTES, 'UTF-8'); ?></td>
            <td><?php echo htmlspecialchars($preview['email'], ENT_QUOTES, 'UTF-8'); ?></td>
            <td>
                <?php if ($preview['file'] !== '') { ?>
                <a href="/echasl23/certificates/files/<?php echo htmlspecialchars($preview['file'], ENT_QUOTES, 'UTF-8'); ?>" target="_blank"><?php echo htmlspecialchars($preview['file'], ENT_QUOTES, 'UTF-8'); ?></a>
                <?php } else { ?>
                <span style="color:#c00;">Not generated</span>
                <?php } ?>
            </td>
        </tr>
        <?php } ?>
    </tbody>
</table>

<?php } ?>
<?php } ?>
<?php } ?>

<?php
include $echasl23Dir . '/footer.php';
if ($certificateEmailCwd !== false) {
    chdir($certificateEmailCwd);
}
?>