Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
error_handling	[ DIR ]	drwxr-sr-x	2025-07-07 15:54
mail	[ DIR ]	drwxr-sr-x	2025-06-14 11:17
ADQAnswers.php	3.16 KB	-rw-r--r--	2026-06-03 05:55
ADQAudit.php	6.51 KB	-rw-r--r--	2026-06-03 05:55
ADQAuditAnswers.php	1.21 KB	-rw-r--r--	2026-06-03 05:55
ADQFirms.php	18.41 KB	-rw-r--r--	2025-12-31 10:56
ADQuestionnairesAnswers.php	1.05 KB	-rw-r--r--	2026-06-03 05:55
ADQuestionnairesAudit.php	2.01 KB	-rw-r--r--	2026-06-03 05:55
ADecQuestionnaires.php	3.31 KB	-rw-r--r--	2026-06-03 05:55
ADecQuestions.php	541 B	-rw-r--r--	2026-06-03 05:55
ADec_Contacts.php	1.61 KB	-rw-r--r--	2026-06-03 05:55
ADec_OfficeContacts.php	7.43 KB	-rw-r--r--	2026-06-03 05:55
ADec_PIUnderwriters.php	742 B	-rw-r--r--	2026-06-03 05:55
ADec_Transformation.php	817 B	-rw-r--r--	2026-06-03 05:55
ADec_tblMemberFirmOffices.php	1.49 KB	-rw-r--r--	2026-06-03 05:55
ADec_tblMemberFirmSkills.php	2.38 KB	-rw-r--r--	2026-06-03 05:55
ADec_tblMemberFirms.php	19.37 KB	-rw-r--r--	2026-06-03 05:55
AnonRespondees.php	4.25 KB	-rw-r--r--	2026-06-05 11:41
AwardsEntries.php	2.4 KB	-rw-r--r--	2026-06-06 10:48
BaseTableClass.php	950 B	-rw-r--r--	2026-04-26 08:24
BatchJob.php	4.46 KB	-rw-r--r--	2026-06-03 05:55
BceAssignmentFeedbackFormsReportService.php	6.77 KB	-rw-r--r--	2026-05-25 13:06
CCEAssignment.php	12.44 KB	-rw-r--r--	2026-05-26 14:26
CCEAssignmentMarking.php	26.26 KB	-rw-r--r--	2026-08-14 12:06
CCEBooks.php	524 B	-rw-r--r--	2026-06-03 05:55
CCEConvenorAuth.php	3.06 KB	-rw-r--r--	2026-08-19 11:18
CCECourseSchedules.php	579 B	-rw-r--r--	2026-06-03 05:55
CCEDocCategories.php	529 B	-rw-r--r--	2026-06-03 05:55
CCEDocuments.php	8.15 KB	-rw-r--r--	2026-08-20 12:16
CCEExam.php	15.87 KB	-rw-r--r--	2026-06-03 06:35
CCEExamQuestion.php	1.76 KB	-rw-r--r--	2026-06-03 05:55
CCEFacilitatorUser.php	931 B	-rw-r--r--	2026-06-03 05:55
CCEMessageLog.php	951 B	-rw-r--r--	2026-06-03 05:55
CCEMessages.php	8.88 KB	-rw-r--r--	2026-07-01 13:20
CCEModuleMarksService.php	7.16 KB	-rw-r--r--	2026-05-26 10:30
CCEModules.php	1.16 KB	-rw-r--r--	2026-06-03 05:55
CCEResourceGroups.php	591 B	-rw-r--r--	2026-06-03 05:55
CCEResources.php	896 B	-rw-r--r--	2026-06-03 05:55
CCESetup.php	256 B	-rw-r--r--	2026-02-09 16:20
CCEStAssigExtension.php	2.07 KB	-rw-r--r--	2026-06-03 05:55
CCEStAssigExtensionRequest.php	6.65 KB	-rw-r--r--	2026-06-03 05:55
CCEStudentAssignment.php	16.61 KB	-rw-r--r--	2026-07-15 14:44
CCEStudentCourses.php	611 B	-rw-r--r--	2026-06-03 05:55
CCEStudentDisplayOrder.php	4.96 KB	-rw-r--r--	2026-05-26 09:32
CCEStudents.php	8.4 KB	-rw-r--r--	2026-08-19 11:18
CCETemplates.php	896 B	-rw-r--r--	2026-06-03 05:55
CCEWeeklySessions.php	2.27 KB	-rw-r--r--	2026-02-09 16:25
CPDSPReview.php	624 B	-rw-r--r--	2026-06-03 05:55
CPDServiceProvider.php	4.57 KB	-rw-r--r--	2026-06-12 11:48
CPDTrainingMaterial.php	3.96 KB	-rw-r--r--	2026-06-12 11:48
CceUploadedFileService.php	34.9 KB	-rw-r--r--	2026-06-24 12:03
Certificates.php	8.93 KB	-rw-r--r--	2026-08-18 15:42
Contact.php	690 B	-rw-r--r--	2026-06-03 05:55
ErrorLog.php	1.22 KB	-rw-r--r--	2026-08-24 10:12
EventSchedules.php	5.39 KB	-rw-r--r--	2025-12-20 10:03
FileUploads.php	2.1 KB	-rw-r--r--	2026-06-03 05:55
HTMLHelper.php	17.2 KB	-rw-r--r--	2026-06-03 05:55
KeyValue.php	4.9 KB	-rw-r--r--	2026-04-25 09:34
Mailer.php	12.78 KB	-rw-r--r--	2026-07-15 09:50
MarketingAttendees.php	36.87 KB	-rw-r--r--	2026-08-14 12:06
MarketingPayments.php	2.52 KB	-rw-r--r--	2026-06-03 05:55
MemberContact.php	1.04 KB	-rw-r--r--	2026-06-03 05:55
MemberFirm.php	17.71 KB	-rw-r--r--	2026-06-03 05:55
MemberFirmOffices.php	752 B	-rw-r--r--	2026-06-03 05:55
MemberFirmSkill.php	18.04 KB	-rw-r--r--	2026-06-03 05:55
MemberPortalTransformationProxy.php	4.44 KB	-rw-r--r--	2026-05-20 09:08
MemberPortalUrls.php	1.82 KB	-rw-r--r--	2026-05-20 09:53
MsgAttachFileService.php	4.92 KB	-rw-r--r--	2026-06-22 08:37
OfficeContact.php	1.01 KB	-rw-r--r--	2026-06-03 05:55
Picklists.php	539 B	-rw-r--r--	2026-06-03 05:55
Questionnaires.php	849 B	-rw-r--r--	2026-01-23 12:39
SchoolAttendeeBulkMailerService.php	34.26 KB	-rw-r--r--	2026-08-11 10:45
SchoolAttendees.php	73.21 KB	-rw-r--r--	2026-08-11 10:45
SchoolCourses.php	7.98 KB	-rw-r--r--	2026-08-19 11:59
SchoolEvents.php	45.54 KB	-rw-r--r--	2026-08-18 15:42
SchoolPayments.php	4.48 KB	-rw-r--r--	2026-04-13 09:33
SchoolPresenters.php	1.86 KB	-rw-r--r--	2026-01-23 12:43
SchoolWeeksCoursesDashboardProxy.php	10.69 KB	-rw-r--r--	2026-08-14 12:32
TrainingProvider.php	8.06 KB	-rw-r--r--	2026-01-23 12:43
TrainingProviderDoc.php	554 B	-rw-r--r--	2026-06-03 05:55
Transformation.php	10.87 KB	-rw-r--r--	2026-05-13 09:36
UnempPractitioners.php	1.43 KB	-rw-r--r--	2026-06-03 05:55
Utils.php	13.72 KB	-rw-r--r--	2026-07-23 07:28
WeeklySessionsParser.php	7.87 KB	-rw-r--r--	2026-02-09 16:20
cceMessageAttachmentUpload.inc.php	5.12 KB	-rw-r--r--	2026-06-03 05:55
cceMessageEditor.inc.php	9.26 KB	-rw-r--r--	2026-07-01 13:20
cce_file_download_endpoint.php	1.75 KB	-rw-r--r--	2026-06-24 08:38
cstUnreadMessages.php	2.1 KB	-rw-r--r--	2026-07-01 13:20
cstWeeksCourses.php	1.84 KB	-rw-r--r--	2026-08-14 12:06
load_phpmailer.php	742 B	-rw-r--r--	2026-07-17 14:57
maill.php	19.45 KB	-rw-r--r--	2026-08-19 12:23
require_ewmysql.php	1.2 KB	-rw-r--r--	2026-08-24 10:12
sqlFunctions.php	10.48 KB	-rw-r--r--	2026-08-24 10:12

Rename

<?php

/**
 * Standard CCEStudent list ordering: KnownAs, else FirstName, then Surname.
 */
final class CCEStudentDisplayOrder
{
    /**
     * @param string $tableAlias SQL table alias (letters, numbers, underscore only)
     */
    public static function sqlOrderByDisplayName($tableAlias = 'CCEStudents'): string
    {
        $alias = preg_replace('/[^A-Za-z0-9_]/', '', $tableAlias);
        if ($alias === '') {
            $alias = 'CCEStudents';
        }

return 'CASE WHEN ' . $alias . '.KnownAs IS NULL OR TRIM(' . $alias . '.KnownAs) = \'\''
            . ' THEN ' . $alias . '.FirstName ELSE ' . $alias . '.KnownAs END, '
            . $alias . '.Surname';
    }

public static function sqlOrderByDisplayNameLookup(): string
    {
        return 'CASE WHEN `KnownAs` IS NULL OR TRIM(`KnownAs`) = \'\' THEN `FirstName` ELSE `KnownAs` END, `Surname`';
    }

/**
     * @param string $tableAlias
     * @param string $direction Asc|Desc|ASC|DESC
     */
    public static function sqlOrderByFragment($tableAlias = 'CCEStudents', $direction = 'ASC'): string
    {
        return ' ORDER BY ' . self::sqlOrderByDisplayName($tableAlias) . ' ' . self::normaliseDirection($direction);
    }

/**
     * For PHPMaker CCEStudents lookup SQL fragments.
     *
     * @param string $direction Asc|Desc|ASC|DESC or empty
     */
    public static function sqlOrderByLookupFragment($direction = 'ASC'): string
    {
        $dir = self::normaliseDirection($direction);

return ' ORDER BY ' . self::sqlOrderByDisplayNameLookup() . ($dir !== '' ? ' ' . $dir : '');
    }

/**
     * @param array<string, mixed> $row
     */
    public static function getSortPrimaryName(array $row, string $knownAsKey = 'KnownAs', string $firstNameKey = 'FirstName'): string
    {
        $knownAs = trim((string) ($row[$knownAsKey] ?? ''));
        if ($knownAs !== '') {
            return $knownAs;
        }

return trim((string) ($row[$firstNameKey] ?? ''));
    }

/**
     * @param array<string, mixed> $row
     */
    public static function getSortSurname(array $row, string $surnameKey = 'Surname'): string
    {
        return trim((string) ($row[$surnameKey] ?? ''));
    }

/**
     * @param array<int, array<string, mixed>> $rows
     */
    public static function sortRows(
        array &$rows,
        string $knownAsKey = 'KnownAs',
        string $firstNameKey = 'FirstName',
        string $surnameKey = 'Surname'
    ): void {
        if (count($rows) <= 1) {
            return;
        }

usort(
            $rows,
            static function (array $left, array $right) use ($knownAsKey, $firstNameKey, $surnameKey): int {
                return self::compareRows($left, $right, $knownAsKey, $firstNameKey, $surnameKey);
            }
        );
    }

/**
     * @param array<string, mixed> $left
     * @param array<string, mixed> $right
     */
    public static function compareRows(
        array $left,
        array $right,
        string $knownAsKey = 'KnownAs',
        string $firstNameKey = 'FirstName',
        string $surnameKey = 'Surname'
    ): int {
        $cmp = strcasecmp(
            self::getSortPrimaryName($left, $knownAsKey, $firstNameKey),
            self::getSortPrimaryName($right, $knownAsKey, $firstNameKey)
        );
        if ($cmp !== 0) {
            return $cmp;
        }

return strcasecmp(self::getSortSurname($left, $surnameKey), self::getSortSurname($right, $surnameKey));
    }

/**
     * @param object $left
     * @param object $right
     */
    public static function compareObjects($left, $right): int
    {
        $cmp = strcasecmp(self::getObjectSortPrimaryName($left), self::getObjectSortPrimaryName($right));
        if ($cmp !== 0) {
            return $cmp;
        }

return strcasecmp(self::getObjectSortSurname($left), self::getObjectSortSurname($right));
    }

/**
     * @param object $object
     */
    public static function getObjectSortPrimaryName($object): string
    {
        if (is_object($object) && method_exists($object, 'getKnownAs')) {
            $knownAs = trim((string) $object->getKnownAs());
            if ($knownAs !== '') {
                return $knownAs;
            }
        }
        if (is_object($object) && method_exists($object, 'getFirstName')) {
            return trim((string) $object->getFirstName());
        }

return '';
    }

/**
     * @param object $object
     */
    public static function getObjectSortSurname($object): string
    {
        if (is_object($object) && method_exists($object, 'getSurname')) {
            return trim((string) $object->getSurname());
        }

return '';
    }

private static function normaliseDirection($direction): string
    {
        $direction = strtoupper(trim((string) $direction));
        if ($direction === 'DESC' || $direction === 'ASC') {
            return $direction;
        }
        if (stripos((string) $direction, 'DESC') !== false) {
            return 'DESC';
        }

return 'ASC';
    }
}