Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
_notes	[ DIR ]	drwxr-sr-x	2022-12-20 11:09
_vti_cnf	[ DIR ]	drwxr-sr-x	2022-12-20 11:09
certificate	[ DIR ]	drwxr-sr-x	2023-03-22 11:22
includes	[ DIR ]	drwxr-sr-x	2026-08-24 10:12
mail_interface	[ DIR ]	drwxr-sr-x	2025-06-14 09:47
security	[ DIR ]	drwxr-sr-x	2023-09-17 08:02
temp	[ DIR ]	drwxr-sr-x	2026-04-18 22:25
templates	[ DIR ]	drwxr-sr-x	2026-05-25 12:12
tests	[ DIR ]	drwxr-sr-x	2025-07-07 15:54
CaptchaSecurityImages.php	2.26 KB	-rw-r--r--	2022-12-20 11:09
Inc_calendarnew.php	8.59 KB	-rw-r--r--	2017-11-20 10:34
accredcourses.php	7.04 KB	-rw-r--r--	2023-08-22 10:55
adecquestionnaire.php	26.54 KB	-rw-r--r--	2025-08-01 10:38
advisory.php	7.21 KB	-rw-r--r--	2022-12-20 11:09
advisory_full.php	1.31 KB	-rw-r--r--	2022-12-20 11:09
annualdeclaration.php	15.28 KB	-rw-r--r--	2026-01-22 10:25
awardsentry.php	14.55 KB	-rw-r--r--	2025-08-01 10:38
awardsentry.php.bak	11.22 KB	-rw-r--r--	2016-04-13 12:45
bookdetail.php	954 B	-rw-r--r--	2022-12-20 11:09
books.php	4.4 KB	-rw-r--r--	2023-05-16 13:08
branchdocuments.php	1.14 KB	-rw-r--r--	2022-12-20 11:09
branches.php	2.82 KB	-rw-r--r--	2025-08-06 12:54
calendarpdf.php	1.75 KB	-rw-r--r--	2025-08-26 16:52
cceregister.php	55.59 KB	-rw-r--r--	2026-08-14 12:05
ccmregister.php	71.57 KB	-rw-r--r--	2022-12-20 11:09
class.phpmailer.php	44.39 KB	-rw-r--r--	2022-12-20 11:09
class.smtp.php	32.74 KB	-rw-r--r--	2022-12-20 11:09
committeedocs.php	932 B	-rw-r--r--	2022-12-20 11:09
committees.php	2.69 KB	-rw-r--r--	2025-08-06 12:58
cpdapply.php	5.73 KB	-rw-r--r--	2022-12-20 11:09
cpdapplyform.php	34.06 KB	-rw-r--r--	2025-08-01 10:38
cpdproviderapply.php	42.09 KB	-rw-r--r--	2026-02-10 10:10
cpdproviderportal.php	79.47 KB	-rw-r--r--	2025-09-08 07:23
cpdspverify.php	4.27 KB	-rw-r--r--	2025-10-10 10:45
cpdtmverify.php	4.45 KB	-rw-r--r--	2023-06-19 13:44
declineeventreg.php	3.73 KB	-rw-r--r--	2022-12-20 11:09
directorybooking.php	7.39 KB	-rw-r--r--	2022-12-20 11:09
downloadPN.php	385 B	-rw-r--r--	2025-06-26 13:02
downloadfile.php	280 B	-rw-r--r--	2025-08-01 10:38
enews.php	1.33 KB	-rw-r--r--	2022-12-20 11:09
enewsarchive.php	1.09 KB	-rw-r--r--	2022-12-20 11:09
event.php	12.39 KB	-rw-r--r--	2026-08-19 12:22
event_allvenues.php	18.93 KB	-rw-r--r--	2026-08-09 11:44
eventdecline_awards.php	11.79 KB	-rw-r--r--	2022-12-20 11:09
eventregister.php	26.85 KB	-rw-r--r--	2026-02-10 07:56
eventregister_awards.php	19.4 KB	-rw-r--r--	2025-06-20 06:38
eventregister_golf.php	28.83 KB	-rw-r--r--	2025-08-19 08:12
eventtables.php	24.13 KB	-rw-r--r--	2023-06-01 09:51
eventtables.php.bak	3.49 KB	-rw-r--r--	2022-12-20 11:09
fidicgama2018.php	1012 B	-rw-r--r--	2022-12-20 11:09
forum.php	3.25 KB	-rw-r--r--	2022-12-20 11:09
getoffices.php	799 B	-rw-r--r--	2022-12-20 11:09
hrforumsubscribe.php	2.62 KB	-rw-r--r--	2022-12-20 11:09
hrforumunsubscribe.php	1.32 KB	-rw-r--r--	2022-12-20 11:09
inc_calendarnew.php	10.56 KB	-rw-r--r--	2025-08-21 10:11
inc_captcha.php	337 B	-rw-r--r--	2022-12-20 11:09
inc_db.php	12.33 KB	-rw-r--r--	2025-06-18 12:05
inc_php7.php	6 KB	-rw-r--r--	2025-07-07 12:51
inc_practicenoteslist.php	4.1 KB	-rw-r--r--	2024-07-03 13:52
inc_scecalendar.php	8.55 KB	-rw-r--r--	2025-06-13 08:57
inc_scecalendar_backup.php	6.66 KB	-rw-r--r--	2022-12-20 11:09
inc_scecalendarnew.php	7.84 KB	-rw-r--r--	2026-05-09 09:39
jobshadowschools.php	7.26 KB	-rw-r--r--	2025-06-20 06:38
logout.php	593 B	-rw-r--r--	2025-02-25 08:19
marketingevent.php	122.75 KB	-rw-r--r--	2026-08-03 13:40
marketingeventdecline.php	15.21 KB	-rw-r--r--	2022-12-20 11:09
marketingsurvey.php	5.95 KB	-rw-r--r--	2022-12-20 11:09
matrixtemplate.htm	2.13 KB	-rw-r--r--	2022-12-20 11:09
member_portal_becs.php	2.14 KB	-rw-r--r--	2025-09-12 07:50
member_portal_transformation.php	10.45 KB	-rw-r--r--	2026-05-20 10:07
member_portal_transformation_proxy.php	538 B	-rw-r--r--	2026-05-20 09:08
memberauth.php	991 B	-rw-r--r--	2025-02-25 08:19
memberportal.php	11.79 KB	-rw-r--r--	2026-05-20 09:54
membersearch.php	22.72 KB	-rw-r--r--	2025-02-27 08:02
membersearch_smme.php	6.2 KB	-rw-r--r--	2024-11-27 11:41
memberverify.php	5.25 KB	-rw-r--r--	2022-12-20 11:09
mentors.php	21.68 KB	-rw-r--r--	2025-06-20 06:38
migratenode.php	1.26 KB	-rw-r--r--	2022-12-20 11:09
monofont.ttf	40.07 KB	-rw-r--r--	2022-12-20 11:09
nlc.php	855 B	-rw-r--r--	2022-12-20 11:09
nlcreports.php	2.51 KB	-rw-r--r--	2022-12-20 11:09
php_errors.log	1.06 KB	-rw-r--r--	2026-08-20 23:37
practicenotes.php	4.63 KB	-rw-r--r--	2022-12-20 11:09
practicenotes_full.php	1.33 KB	-rw-r--r--	2022-12-20 11:09
practicenotes_help.php	2.17 KB	-rw-r--r--	2022-12-20 11:09
practicenotes_list.php	2.03 KB	-rw-r--r--	2024-07-03 13:52
practicenotes_search.php	9.43 KB	-rw-r--r--	2022-12-20 11:09
querynlcmatrix.php	15 KB	-rw-r--r--	2022-12-20 11:09
querynlcmatrix.php4	15.38 KB	-rw-r--r--	2012-03-05 08:01
register.php	58.18 KB	-rw-r--r--	2026-05-26 14:55
relay.php	20.33 KB	-rw-r--r--	2025-06-20 06:38
relayteams.php	12.53 KB	-rw-r--r--	2022-12-20 11:09
resendcpdform.php	7.28 KB	-rw-r--r--	2025-08-01 10:38
retiredeng.php	13.45 KB	-rw-r--r--	2025-06-20 06:38
retiredeng_members.php	1.81 KB	-rw-r--r--	2022-12-20 11:09
sanitize.php	10 B	-rw-r--r--	2022-12-20 11:09
sce_survey2015.php	25.85 KB	-rw-r--r--	2022-12-20 11:09
sceallevents.php	8.13 KB	-rw-r--r--	2026-01-20 08:45
scecalendar.php	4.86 KB	-rw-r--r--	2025-06-18 11:18
scecalendar_backup.php	3.17 KB	-rw-r--r--	2025-06-18 11:18
scecalendarnew.php	5.98 KB	-rw-r--r--	2025-08-28 11:14
scecalendarnewtest.php	5.7 KB	-rw-r--r--	2022-03-04 12:37
scecalendartest.php	3.57 KB	-rw-r--r--	2022-03-04 12:38
scecategories.php	914 B	-rw-r--r--	2022-12-20 11:09
scecourses.php	7.18 KB	-rw-r--r--	2026-08-19 12:15
scelist.php	7.72 KB	-rw-r--r--	2025-08-29 07:18
scesubscribe.php	2.06 KB	-rw-r--r--	2022-12-20 11:09
sceupdate.php	1.67 KB	-rw-r--r--	2025-06-18 11:18
scevenuehire.php	6.15 KB	-rw-r--r--	2026-01-23 13:12
sendeventreg.php	19.5 KB	-rw-r--r--	2026-08-14 12:05
sendeventreg2.php	2.83 KB	-rw-r--r--	2026-07-17 14:57
sendeventreg_golf.php	20.23 KB	-rw-r--r--	2026-08-14 12:05
sendeventreg_golf.php.bak	11.69 KB	-rw-r--r--	2016-09-07 09:48
sendreg.php	35.15 KB	-rw-r--r--	2026-08-14 12:05
smsunsub.php	1.89 KB	-rw-r--r--	2025-06-18 11:18
template.php	54.36 KB	-rw-r--r--	2022-12-20 11:09
tenders.php	1.34 KB	-rw-r--r--	2022-12-20 11:09
trainerportal.php	50.27 KB	-rw-r--r--	2025-08-01 11:06
trainerportal.php.bak	2.57 KB	-rw-r--r--	2022-12-20 11:09
unempgrad_members.php	2.38 KB	-rw-r--r--	2025-06-18 11:18
unemployed.php	14.13 KB	-rw-r--r--	2025-06-20 06:38
unemployedreg.php	23.38 KB	-rw-r--r--	2025-06-20 06:38
unempreg_members.php	2.36 KB	-rw-r--r--	2025-06-18 11:18
ypfbranchcommittee.php	1.63 KB	-rw-r--r--	2022-12-20 11:09
ypfcommittees.php	1.57 KB	-rw-r--r--	2022-12-20 11:09
ypfjoin.php	30.29 KB	-rw-r--r--	2025-07-07 15:53
ypfjoin2.php	28.13 KB	-rw-r--r--	2025-06-18 11:18
ypfjoinmatches.php	9.46 KB	-rw-r--r--	2025-06-18 11:18
ypfmentees.php	20.81 KB	-rw-r--r--	2026-08-24 11:52
ypfmentees_members.php	2.42 KB	-rw-r--r--	2025-06-18 11:18

Rename

<p><b>Search:</b></p>
<form method="post" action="/cpd-validation/cpd-validated-training-events/">
    <input type="hidden" name="go" value="1">
    <table border=0 cellpadding=5 cellspacing=0 width=372>
        <tr><td width="107"><b>Subject:</b></td><td width="245"><input name="subject" type="text" id="subject" size="40"></td></tr>
        <tr><td><b>Provider:</b></td><td><input name="provider" type="text" id="provider" size="40"></td></tr>
        <tr><td><b>Service Provider Verification Number:</b></td><td><input name="spnum" type="text" id="spnum" size="40"></td></tr>
        <tr><td><b>Activity Validation Number:</b></td><td><input name="accrednum" type="text" id="accrednum" size="40"></td></tr>
        <tr><td colspan=2 align="center"><input type="submit" name="submit" id="submit" value="Submit"></td></tr>
    </table>
</form>
<?php
include("inc_db.php");

//$sql = "SELECT TrainingMaterial.Subject, TrainingMaterial.Comments, SchoolProviders.CompanyName ProviderName, SchoolProviders.PhoneNumber,
//	SchoolProviders.EmailAddress, TrainingMaterial.Status, SchoolProviders.SPNumber,
//	TrainingMaterial.Level, TrainingMaterial.Duration, TrainingMaterial.DurationUnit, TrainingMaterial.CPD,
//	TrainingMaterial.NQFLevel, TrainingMaterial.AccredNum, TrainingMaterial.ProviderID, TrainingMaterial.EvaluatorID
//	FROM CPDServiceProvider SchoolProviders INNER JOIN CPDTrainingMaterial TrainingMaterial ON SchoolProviders.CPDProviderID=TrainingMaterial.ProviderID
//	WHERE
//    (TrainingMaterial.Status IN ('Approved','Pending'))
//	AND TrainingMaterial.AccredNum LIKE 'CESA%' ";
//if (isset($_REQUEST["subject"]))
//    $sql .= " AND TrainingMaterial.Subject LIKE '%" . mysql_real_escape_string($_REQUEST["subject"]) . "%' ";
//if (isset($_REQUEST["provider"]))
//    $sql .= " AND SchoolProviders.CompanyName LIKE '%" . mysql_real_escape_string($_REQUEST["provider"]) . "%' ";
//if (isset($_REQUEST["accrednum"]))
//    $sql .= " AND TrainingMaterial.AccredNum LIKE '%" . mysql_real_escape_string($_REQUEST["accrednum"]) . "%' ";
//if (isset($_REQUEST["spnum"]))
//    $sql .= " AND SchoolProviders.SPNumber LIKE '%" . mysql_real_escape_string($_REQUEST["spnum"]) . "%' ";
//
//$sql .= " ORDER BY TrainingMaterial.Subject ASC";

$sql = "SELECT TrainingMaterial.Subject, TrainingMaterial.Comments, SchoolProviders.CompanyName ProviderName, SchoolProviders.PhoneNumber,
	SchoolProviders.EmailAddress, TrainingMaterial.Status, SchoolProviders.SPNumber,
	TrainingMaterial.Level, TrainingMaterial.Duration, TrainingMaterial.DurationUnit, TrainingMaterial.CPD,
	TrainingMaterial.NQFLevel, TrainingMaterial.AccredNum, TrainingMaterial.ProviderID, TrainingMaterial.EvaluatorID
	FROM CPDServiceProvider SchoolProviders INNER JOIN CPDTrainingMaterial TrainingMaterial ON SchoolProviders.CPDProviderID=TrainingMaterial.ProviderID
	WHERE
    (TrainingMaterial.Status IN ('Approved'))
    AND TrainingMaterial.DateExpires > NOW() 
	AND TrainingMaterial.AccredNum LIKE 'CESA%' ";
if (isset($_REQUEST["subject"]))
    $sql .= " AND TrainingMaterial.Subject LIKE '%" . mysql_real_escape_string($_REQUEST["subject"]) . "%' ";
if (isset($_REQUEST["provider"]))
    $sql .= " AND SchoolProviders.CompanyName LIKE '%" . mysql_real_escape_string($_REQUEST["provider"]) . "%' ";
if (isset($_REQUEST["accrednum"]))
    $sql .= " AND TrainingMaterial.AccredNum LIKE '%" . mysql_real_escape_string($_REQUEST["accrednum"]) . "%' ";
if (isset($_REQUEST["spnum"]))
    $sql .= " AND SchoolProviders.SPNumber LIKE '%" . mysql_real_escape_string($_REQUEST["spnum"]) . "%' ";

$sql .= " ORDER BY TrainingMaterial.Subject ASC";

$queryresult = mysql_query($sql);
$ProviderID = 0;
if (mysql_num_rows($queryresult) > 0) {
    if (isset($_REQUEST["go"])) {
        ?>
        <p>Number of search results found: <?php echo mysql_num_rows($queryresult); ?>. <a href="/node/169">Click here to show all</a></p>
        <?php
    }
    ?>
    <table border=1 cellpadding=5 cellspacing=0 style="border:0; font-size:10px" width=100%>
        <tr>
            <td style="border-width:0px; padding-bottom:1px" width=20%><b>Subject</b></td>
            <td style="border-width:0px; padding-bottom:1px" width=18%><b>Service Provider</b></td>
            <td align="center" style="border-width:0px; padding-bottom:1px; text-align:center" width=18%><b>Service Provider<br>Verification Number</b></td>
            <td style="border-width:0px; padding-bottom:1px" width=10%><b>Type</b></td>
            <td style="border-width:0px; padding-bottom:1px" width=5%><b>Duration</b></td>
            <td style="border-width:0px; padding-bottom:1px; text-align:center" width=4%><b>CPD Points</b></td>
            <td align="center" style="border-width:0px; padding-bottom:1px; text-align:center" width=16%><b>Activity<br>Validation Number</b></td>
        </tr>
        <?php
        while ($row = mysql_fetch_array($queryresult)) {
            $ProviderName = $row["ProviderName"];
            $Phone = $row["PhoneNumber"];
            $Email = $row["EmailAddress"];
            $Subject = $row["Subject"];
//	$EvaluatorName = $row["EvaluatorName"];
            $Level = $row["Level"];
            $Hours = $row["Duration"] . " " . $row["DurationUnit"];
            $CPD = $row["CPD"];
            $AccredNum = $row["AccredNum"];

if ((intval(substr($row["AccredNum"], -4)) > date("Y")) || ((intval(substr($row["AccredNum"], -4)) == date("Y")) && (intval(substr($row["AccredNum"], -7, 2)) >= date("m")))) {

//Write out detail
                ?>
                <tr>
                    <td style="border-width:0px 0px 1px 0px;border-color:#CCCCCC; padding-top:1px"><?php echo $Subject; ?></td>
                    <td style="border-width:0px 0px 1px 0px;border-color:#CCCCCC; padding-top:1px"><?php echo $ProviderName; ?>
                        <?php
                        if (!empty($Phone))
                            echo "<br>Tel: " . $Phone;
                        if (!empty($Email))
                            echo "<br>Email: " . $Email;
                        ?>
                    </td>
                    <td style="border-width:0px 0px 1px 0px;border-color:#CCCCCC; padding-top:1px"><?php echo $row["SPNumber"]; ?></td>
                    <td style="border-width:0px 0px 1px 0px;border-color:#CCCCCC; padding-top:1px"><?php echo $Level; ?></td>
                    <td style="border-width:0px 0px 1px 0px;border-color:#CCCCCC; padding-top:1px"><?php echo $Hours; ?></td>
                    <td style="border-width:0px 0px 1px 0px;border-color:#CCCCCC; padding-top:1px"><?php echo $CPD; ?></td>
                    <td style="border-width:0px 0px 1px 0px;border-color:#CCCCCC; padding-top:1px"><?php
// if ($row["Status"]=="Pending") { echo "Pending"; } else { echo $AccredNum; }
// 2018-10-17 Blessings requested that we not show the Pending status, as many approved courses have not had their status
// updated in the database
                        if ($row["Status"] != "Pending") {
                            echo $AccredNum;
                        }
                        ?></td>
                </tr>
                <?php
            }
        }
        ?>
    </table>
    <?php
}
?>