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

/*
 * Contact otto@igotafrica.com for details
 */

/**
 * Control the  CCEStAssigExtensionRequests table
 *
 * @author Otto Saayman
 */
class CCEStAssigExtensionRequest extends BaseTableClass
{

public static function getStatusString($status)
    {
        switch ($status) {
            case 'A':
                return 'Approved';
                break;
            case 'P':
                return 'Approved w Penalty';
                break;
            case 'D':
                return 'Declined';
                break;
            default:
                return 'Pending';
        }
    }

public static function getDueDateExtendedDate($assignment, $dueDate, $extended = false)
    {

$return = '';

if ($extended) {
            $return .= 'Extension approved and due on ';
        }

$return .= $dueDate->format('d-m-Y') . ' ';

if ($dueDate->getTimestamp() < time()) {
 $sResubDate = GetResubDate($assignment["CCEAssignmentID"], $_SESSION["StudentID"]);
 if ($sResubDate != '')
 $return .= "Resubmissions due on " . $sResubDate . " ";
 // echo $return;
 // exit;
 }

return $return;
    }

public static function getExtensionDueString($assignment, $extensionRequests, $showDueOn = false)
    {

$return = '';
        $dueDate = '';

if ($showDueOn) {
            $dueDate .= 'Due on ';
        }

$dueDate .= self::getDueDateExtendedDate($assignment, new DateTime($assignment['DueDate']));

if (isset($extensionRequests) && is_array($extensionRequests) && count($extensionRequests) > 0) {

$reqDate = null;

foreach ($extensionRequests as $extensionRequest) {

if ($extensionRequest['Status'] != 'A' || !is_null($reqDate)) {
                    continue;
                }

$dueDate = self::getDueDateExtendedDate($assignment, new DateTime($extensionRequest['CCEExtensionDate']), true);

// $reqDate = new DateTime($extensionRequest['DateRequested']);
 // $return .= 'Extension approved and due on ' . $reqDate->format('d-m-Y') . ' ';

break;
            } //foreach
        }

return $dueDate . $return;
    }

public function updateStudentAssigID($studentId, $assignmentId)
    {

$updateStudentAssigIDSQL = "UPDATE CCEStAssigExtensionRequests er
            INNER JOIN (
                SELECT CCEStudentID, CCEAssignmentID, CCEStudentAssigID
                FROM CCEStudentAssignments sa1
                WHERE (
                    SELECT COUNT(*)
                    FROM CCEStudentAssignments sa2
                    WHERE sa2.CCEStudentID = sa1.CCEStudentID 
                    AND sa2.CCEAssignmentID = sa1.CCEAssignmentID
                    AND sa2.CCEStudentID = " . ($studentId + 0) . " AND sa2.CCEAssignmentID = " . ($assignmentId + 0) . "
                ) = 1
            ) sa ON er.CCEStudentID = sa.CCEStudentID 
                AND er.CCEAssignmentID = sa.CCEAssignmentID
            SET er.CCEStudentAssigID = sa.CCEStudentAssigID
            WHERE (er.CCEStudentAssigID IS NULL OR er.CCEStudentAssigID = 0) 
                AND er.CCEStudentID = " . ($studentId + 0) . " AND er.CCEAssignmentID = " . ($assignmentId + 0);

// echo $updateStudentAssigIDSQL . ' ';

$this->sqlf->execute($updateStudentAssigIDSQL);
    }

public function findAllByStudentAssignment($studentId, $assignmentId, $studentAssigID = 0)
    {

$this->updateStudentAssigID($studentId, $assignmentId);

$getAssignmentSQL = "SELECT ser.*, se.CCEExtensionDate AS ApprovedCCEExtensionDate "
            . "FROM CCEStAssigExtensionRequests ser "
            . " LEFT JOIN CCEStAssigExtensions se ON ser.CCEStAssigExtensionID = se.CCEStAssigExtensionID "
            . "WHERE ser.CCEStudentID = $studentId AND ser.CCEAssignmentID = $assignmentId ";

if ($studentAssigID > 0) {
            $getAssignmentSQL .= " AND (ser.CCEStudentAssigID = " . ($studentAssigID + 0) . " OR ser.CCEStudentAssigID IS NULL)";
        }

$getAssignmentSQL .= " ORDER BY ser.CCEExtensionDate DESC, ser.DateUpdated DESC ";

// echo $getAssignmentSQL . ' ';
 // exit;

return $this->sqlf->getAll($getAssignmentSQL);
    }

public function getLastExtensionRequest($studentId, $assignmentId, $studentAssigID)
    {
        $extensions = $this->findAllByStudentAssignment($studentId, $assignmentId, $studentAssigID);

if (is_array($extensions) && count($extensions) > 0) {
            return $extensions[0];
        }

return array();
    }

public function findAllByStudent($studentId)
 {
 
 $findByStudentSQL = "SELECT ser.*, se.CCEExtensionDate AS ApprovedCCEExtensionDate, a.AssignmentName, a.RefNum "
 . "FROM CCEStAssigExtensionRequests ser "
 . "INNER JOIN CCEAssignments a ON ser.CCEAssignmentID = a.CCEAssignmentID "
 . "LEFT OUTER JOIN CCEStudentAssignments sa ON ser.CCEAssignmentID = sa.CCEAssignmentID AND ser.CCEStudentID = sa.CCEStudentID "
 . "LEFT JOIN CCEStAssigExtensions se ON ser.CCEAssignmentID = se.CCEAssignmentID AND ser.CCEStudentID = se.CCEStudentID "
 . "WHERE ser.CCEStudentID = $studentId AND sa.DateSubmitted IS NULL ";
 
 $findByStudentSQL .= " ORDER BY ser.CCEExtensionDate DESC ";
 
 // echo 'Please ignore debug info: ' . $findByStudentSQL . ' ';

$return = $this->sqlf->getAll($findByStudentSQL);

if (!is_array($return)) {
            $return = array();
        }

return $return;
    }
}

// included functions
function CCEStAssigExtensionRequestPageLoad()
{

if (isset($_REQUEST['CCEStudentID'])) {
        $_SESSION['CCEStudentID'] = $_REQUEST['CCEStudentID'];
    }

if (isset($_REQUEST['CCEAssignmentID'])) {
        $_SESSION['CCEAssignmentID'] = $_REQUEST['CCEAssignmentID'];
    }

if (isset($_SESSION['CCEAssignmentID'])) {
        //        echo 'filtering on assignment ' . $_SESSION['CCEAssignmentID'];
        //        exit;
        $_REQUEST['x_CCEAssignmentID'] = $_SESSION['CCEAssignmentID'];
        $_REQUEST['x_CCEAssignmentID'] = '=';
        $_GET['x_CCEAssignmentID'] = $_SESSION['CCEAssignmentID'];
        $_GET['z_CCEAssignmentID'] = '=';
    }

if (isset($_SESSION['CCEStudentID'])) {
        $_REQUEST['x_CCEStudentID'] = $_SESSION['CCEStudentID'];
        $_REQUEST['z_CCEStudentID'] = '=';
        $_GET['x_CCEStudentID'] = $_SESSION['CCEStudentID'];
        $_GET['z_CCEStudentID'] = '=';
    }
}

function CCEStAssigExtensionRequestUpsert($rsold, $rsnew) {}