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
 */

include_once('BaseTableClass.php');

/**
 * Control the  ADQFirms table
 *
 * @author Otto Saayman
 */
class ADQAudit extends BaseTableClass {

public function find($ADQAuditID) {

$sql = "SELECT * FROM ADQAudit "
                . "WHERE ADQAudit.ADQAuditID=" . $ADQAuditID;

//        echo $sql . '<br />';

return $this->sqlf->getRow($sql);
    }

public function findByFirmId($ADQFirmID) {

if (strlen($ADQFirmID) <= 0) {
            return array();
        }

$sql = "SELECT * FROM ADQAudit "
                . "WHERE ADQAudit.ADQFirmID=" . $ADQFirmID;

//        echo $sql . '<br />';

return $this->sqlf->getRow($sql);
    }

public function checkAuditScore($ADQFirmID) {

$iScore = 0;
        $iMaxScore = 0;
        $iScorePerc = 0;

if (is_null($ADQFirmID) || strlen($ADQFirmID) <= 0) {
            return;
        }

$sql = "SELECT ADQAnswers.Answer, ADQAuditAnswers.Verified FROM
		ADQAnswers JOIN ADQuestions USING (ADQuestionID)
		JOIN ADQAuditAnswers ON (ADQAnswers.ADQFirmID=ADQAuditAnswers.ADQFirmID AND ADQAnswers.ADQuestionID=ADQAuditAnswers.ADQQuestionID)
		WHERE ADQAnswers.ADQFirmID=" . $ADQFirmID . " AND ADQAnswers.Answer IN ('Yes','No') AND SectionNum>1";

//        echo $sql . '<br />';

$rows = $this->sqlf->getAll($sql);

foreach ($rows as $row) {
            if (($row["Verified"] == "Y") || ($row["Verified"] == "C")) {
                $iScore++;
            }
            $iMaxScore++;
        }

if ($iMaxScore <= 0) {
            //Check if certified

//            echo $sql . '<br />';

$rows = $this->sqlf->getAll($sql);

foreach ($rows as $row) {
                if (($row["Verified"] == "Y") || ($row["Verified"] == "C")) {
                    $iScore++;
                }
                $iMaxScore++;
            }
        }

$sql = "UPDATE ADQFirms SET AuditScore=" . $iScore . ", AuditMaxScore=" . $iMaxScore . ", AuditScorePerc=" . ($iMaxScore > 0 ? round($iScore / $iMaxScore * 100, 2) : "NULL") . " WHERE ADQFirmID=" . $ADQFirmID;
        $this->sqlf->execute($sql);
    }

public function checkAudit($ADQFirmID) {

if (strlen($ADQFirmID) <= 0) {
            return;
        }

$row = $this->findByFirmId($ADQFirmID);

if (!is_array($row) || count($row) <= 0) {
            $row['ADQFirmID'] = $ADQFirmID;
            $row['DateUpdated'] = date('Y-m-d H:i:s');

$this->sqlf->autoExecute('ADQAudit', $row, 'INSERT', null, 'ADQAuditID');
        }
    }

public function update($adqAudit) {

if (isset($adqAudit['ADQAuditID'])) {
            $row = $this->find($adqAudit['ADQAuditID']);
        } elseif (!isset($adqAudit['IgnoreFirm']) || !$adqAudit['IgnoreFirm']) {
            $row = $this->findByFirmId($adqAudit['ADQFirmID']);
        }

$action = 'UPDATE';

if (!is_array($row) || count($row) <= 0) {
            $action = 'INSERT';
            $adqAudit['ADQAuditID'] = -1;
        } else {
            $adqAudit['ADQAuditID'] = $row['ADQAuditID'];
        }

$nowDate = new DateTime();
        $adqAudit['DateUpdated'] = $nowDate->format('Y-m-d H:i:s');

//        var_dump($adqAudit);
//        exit;

unset($adqAudit['IgnoreFirm']);

$this->sqlf->autoExecute('ADQAudit', $adqAudit, $action, 'ADQAuditID = ' . $adqAudit['ADQAuditID'], 'ADQAuditID');
//        exit;
    }

public function getPast($ADQFirmID) {

if ($ADQFirmID <= 0) {
            return array();
        }

$sql = "SELECT * FROM ADQAudit WHERE ADQFirmID = " . $ADQFirmID . " ORDER BY DateUpdated DESC LIMIT 1, 1000000000";
//        echo $sql . '<br />';

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

public static function getStatus($verified) {

$status = 'Not Verified';

switch ($verified) {
            case "Y":
                $status = "Verified";
                break;
            case "C":
                $status = "Verified With Comments";
                break;
            case "N":
                $status = "Not Verified";
                break;
        }
        return $status;
    }

public static function getFileName($firmName, $ADQFirmID) {
        return $fileName = 'MSD_' . str_replace('__', '_', str_replace('&', '_', str_replace(')', '', str_replace('(', '', str_replace(' ', '_', $firmName))))) . '_' . $ADQFirmID . '_' . date('m_Y');
    }
}

if (isset($_POST["go"]) && ($_POST["go"] == "AuditPopup")) {

if (strlen(CurrentUserName()) <= 0) {
        ?>
        <script language="javascript">
            alert('Please log in before updating reviews.');
        </script>
        <?php

header("Location: " . $_SERVER['REQUEST_URI'] . "&id=" . intval($_REQUEST["id"]) . "&filtertable=" . $_REQUEST["filtertable"] . "&filteraudit=" . $_REQUEST["filteraudit"] . "#" . intval($_POST["ADQFirmID"]));
        exit;
    }

$adqAudit = new ADQAudit($sqlf);
    $adqAudit->update(array(
        'ADQFirmID' => intval($_POST["ADQFirmID"]),
        'UpdatedBy' => CurrentUserName(),
        'ContactPerson' => addslashes($_POST["ContactPerson"]),
        'Comments' => addslashes($_POST["Comments"]),
        'Verified' => addslashes($_POST["Verified"]),
        'IgnoreFirm' => true,
    ));

//    $sql = "INSERT INTO ADQAudit (ADQFirmID, DateUpdated, UpdatedBy, ContactPerson, Comments, Verified)
//	VALUES (" . intval($_POST["ADQFirmID"]) . ", NOW(), '" . CurrentUserName() . "', '" . addslashes($_POST["ContactPerson"]) . "',
//	'" . addslashes($_POST["Comments"]) . "', '" . addslashes($_POST["Verified"]) . "')";
//    mysqli_query($conni, $sql);

if (($_POST["Verified"] == "Y") || ($_POST["Verified"] == "C")) {
        $adqAudit = new ADQAudit($sqlf);
        $adqAudit->checkAuditScore($_POST["ADQFirmID"]);
    }

if (strpos($_SERVER['REQUEST_URI'], '?') <= 0) {
        $_SERVER['REQUEST_URI'] .= '?1=1';
    }

header("Location: " . $_SERVER['REQUEST_URI'] . "&ADQFirmID=" . $_POST["ADQFirmID"] . "&id=" . intval($_REQUEST["id"]) . "&filtertable=" . $_REQUEST["filtertable"]
            . "&filteraudit=" . $_REQUEST["filteraudit"] . "#" . intval($_POST["ADQFirmID"]));
    exit;
}