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

<?php
include_once('inc_db.php');

$NumMonths = 6;

if (isset($_REQUEST["NumMonths"])) {
	if ($_REQUEST["NumMonths"] == "y2018") {
		if (date("Y") == 2017) {
			$NumMonths = (13 - date("m")) + 12;
		} else {
			$NumMonths = 13 - date("m");
		}
	} else {
		$NumMonths = intval($_REQUEST["NumMonths"]);
	}
}

// Check if this is for PDF generation
$isPDF = isset($_REQUEST["pdf"]) && $_REQUEST["pdf"] == "1";
?>
<style>
	.smallfonts {
		border: 1px solid;
		border-collapse: collapse;
	}

.smallfonts td {
		font-family: Tahoma;
		font-size: 10px;
		border: 1px solid #CCCCCC;
	}

.smallfonts th {
		font-family: Tahoma;
		font-size: 10px;
	}

@media screen {

div#tbl-container {
			width: 650px;
			height: 350px;
			overflow: auto;
			position: absolute;
			left: 220px;
			border: 2px outset;
			background-color: white;
		}

/*table {
table-layout: fixed;
border-collapse: collapse;
}*/

td.locked,
		th.locked {
			position: relative;
			z-index: 10;
			text-align: center;
		}

.eventname {
			font-family: Verdana, Arial, sans-serif;
			font-size: 11px;
		}
	}
</style>
<?php if (!$isPDF): ?>
<table border=0 cellspacing=0 cellpadding="0" width="100%">
	<tr>
		<td width="50%" align="left">&nbsp;
			
			<form method="get" action="/scecalendar">
				<input type="hidden" name="test" value="1">
				<table border="0">
					<tr>
						<td valign="middle">
							Number
							of months to display: <select name="NumMonths">
								<option value="6" <?php if (!isset($_REQUEST["NumMonths"]) || ($_REQUEST["NumMonths"] == "6")) echo " selected"; ?>>Next 6 months</option>
								<option value="12" <?php if ($_REQUEST["NumMonths"] == "12") echo " selected"; ?>>Next 12 months</option>
								<option value="y2018" <?php if ($_REQUEST["NumMonths"] == "y2018") echo " selected"; ?>>To end of 2018</option>
							</select><br>
							Category to display: <select name="cat">
								<option value="" <?php if (!isset($_REQUEST['cat']) || empty($_REQUEST['cat'])) echo " selected"; ?>>All categories</option>
								<?php
								$catrs = mysql_query("SELECT * FROM SchoolWebCategories WHERE DisplayOrder>0 ORDER BY DisplayOrder");
								while ($catrow = mysql_fetch_assoc($catrs)) {
								?>
									<option value="<?php echo $catrow["WebCategoryID"]; ?>" <?php if ($_REQUEST["cat"] == $catrow["WebCategoryID"]) echo " selected"; ?>><?php echo $catrow["WebCategoryName"]; ?></option>
								<?php
								}
								?>
							</select></td>
						<td valign="middle">&nbsp;&nbsp;<input type="submit" value="Update Calendar"></td>
					</tr>
				</table>
			</form>
		</td>
		<td width="50%" align="right">
			<a href="/php/calendarpdf.php?NumMonths=<?php echo $_REQUEST["NumMonths"]; ?>" target="_blank"><img
					src="/images/icon_pdf.gif" border="0" align="absmiddle" />&nbsp;<strong>Download as a PDF</strong></a>
		</td>
	</tr>
	
</table>
<?php endif; ?>
<table width=100% cellspacing=0 cellpadding=2 class="smallfonts" id="tbl">
	<thead>
		<tr>
			<th colspan=<?php echo $NumMonths + 2; ?> align=center class='locked' bgcolor="#325eab">
				<B style="color:white">Training Schedule, <?php echo date("M Y"); ?> -
					<?php echo date("M Y", strtotime("+ " . ($NumMonths - 1) . " months", strtotime(date("Y-m") . "-01"))); ?></b>
			</th>
		</tr>
		<tr>
			<th class='locked' bgcolor="#325eab" align=center><b style="color:white">Course</b></th>
			<th class='locked' bgcolor="#325eab" align=center><strong style="color:white">CPD</strong></th>
			<?php
			$lastmonthShown = 0;
			for ($z = date("n"); $z <= (date("n") + ($NumMonths - 1)); $z++) {
				$usez = $z;
				if ($usez > 12) $usez = $usez - 12;
				echo "<th align=center class='locked' bgcolor='#325eab'><b style='color:white'>" . date("M", strtotime(date("Y") . "-" . $usez . "-01")) . "</b></th>";
				$lastmonthShown = $usez;
			}
			?>
		</tr>
	</thead>
	<tbody>
		<?php
		$sql = "SELECT * FROM SchoolWebCategories ";
		if (isset($_REQUEST["cat"]) && !empty($_REQUEST["cat"])) $sql .= " WHERE WebCategoryID=" . intval($_REQUEST["cat"]);
		$sql .= " ORDER BY DisplayOrder";
		$catrs = mysql_query($sql);

while ($catrow = mysql_fetch_assoc($catrs)) {

$sql = "SELECT SchoolEvents.EventID, SchoolEvents.EventName, SchoolEvents.City,	SchoolEvents.CostPerPerson, 
					SchoolEvents.AccredNum, SchoolEvents.CPD, SchoolEvents.Cancelled, SchoolEvents.Venue, 
					CourseVenues.CourseVenueCity, MIN(EventSchedules.ScheduleDate) AS StartDate, 
					MAX(EventSchedules.ScheduleDate) AS EndDate
				FROM (SchoolEvents LEFT JOIN CourseVenues ON SchoolEvents.Venue = CourseVenues.CourseVenueName)
				LEFT JOIN EventSchedules ON SchoolEvents.EventID=EventSchedules.EventID
				WHERE Cancelled=0 AND WebCategory=" . $catrow["WebCategoryID"] . "
				GROUP BY SchoolEvents.EventID, SchoolEvents.EventName, SchoolEvents.City, SchoolEvents.CostPerPerson, 
					SchoolEvents.AccredNum, SchoolEvents.CPD, SchoolEvents.Cancelled, SchoolEvents.Venue, 
					CourseVenues.CourseVenueCity
				HAVING StartDate >= '" . date("Y-m") . "-01'
					AND StartDate < '" . date("Y-m", strtotime("+ " . $NumMonths . " months", strtotime(date("Y-m") . "-01"))) . "-01'
				ORDER BY EventName, Cancelled, AccredNum, CPD, StartDate";

$queryresult = mysql_query($sql) or die(mysql_error($conn) . " " . $sql);

if (mysql_num_rows($queryresult) > 0) {
		?>
				<tr>
					<td colspan="<?php echo $NumMonths + 2; ?>" align="left" bgcolor="#6ba9d5" style="color:#325eab">
						<b><?php echo $catrow["WebCategoryName"]; ?></b>
					</td>
				</tr>
				<?php
				$i = 1;
				$sLastEvent = "";
				$iLastMonth = date("n") - 1;
				$sThisRow = "";
				while ($row = mysql_fetch_array($queryresult)) {
					$eventid = $row["EventID"];
					$city = $row["City"];
					if (empty($city)) $city = $row["CourseVenueCity"];
					if (empty($city)) $city = $row["Venue"];
					$startdate = $row["StartDate"];
					$enddate = $row["EndDate"];
					$sday = date("d", strtotime($startdate));
					$syear = date("Y", strtotime($startdate));
					$smonth = date("m", strtotime($startdate));
					$eday = date("d", strtotime($enddate));
					$eyear = date("Y", strtotime($enddate));
					$emonth = date("m", strtotime($enddate));

$sEventInfo = $row["EventName"];
					$sCPD = $row["CPD"];
					if ($row["Cancelled"] == 1) $sEventInfo .= " - CANCELLED";
					if (!empty($row["AccredNum"])) $sEventInfo .= " (" . $row["AccredNum"] . ")";
					//$sEventInfo .= "<br>";
					//if (!empty($row["CPD"])) $sEventInfo .= $row["CPD"]." CPD point(s)";

if ($sLastEvent != $sEventInfo) {
						if (!empty($sLastEvent)) {
							if ($iLastMonth > 0) $sThisRow .= "</td>";
							if ($iLastMonth > $lastmonthShown) {
								for ($z = $iLastMonth + 1; $z <= 12; $z++) {
									$sThisRow .= "<td>&nbsp;</td>";
								}
								for ($z = 1; $z <= $lastmonthShown; $z++) {
									$sThisRow .= "<td>&nbsp;</td>";
								}
							} else {
								for ($z = $iLastMonth + 1; $z <= $lastmonthShown; $z++) {
									$sThisRow .= "<td>&nbsp;</td>";
								}
							}
							$sThisRow .= "</tr>
";

$sThisRow = str_replace("EVENTIDHERE", $lasteventid, $sThisRow);
							echo $sThisRow;
						}
						$sThisRow = "<tr><td width=280>";
						if (!$isPDF) {
							$sThisRow .= "<a href='/sce/school-course?id=EVENTIDHERE'><span class='eventname'>";
							$sThisRow .= $sEventInfo;
							$sThisRow .= "</span><br>";
							$sThisRow .= "More&nbsp;Info</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
						} else {
							$sThisRow .= "<span class='eventname'>";
							$sThisRow .= $sEventInfo;
							$sThisRow .= "</span>";
						}
						$sThisRow .= "</td><td align=center>" . $sCPD . "</td>";
						$iLastMonth = date("n") - 1;
						$sLastEvent = $sEventInfo;

if (($i % 10) == 0) {
				?>
							<tr>
								<td class='locked'>&nbsp;</td>
								<td class='locked'>&nbsp;</td>
								<?php
								$lastmonthShown = 0;
								for ($z = date("n"); $z <= (date("n") + ($NumMonths - 1)); $z++) {
									$usez = $z;
									if ($usez > 12) $usez = $usez - 12;
									echo "<td align=center class='locked'><b>" . date("M", strtotime(date("Y") . "-" . $usez . "-01")) . "</b></td>";
									$lastmonthShown = $usez;
								}
								?>
							</tr>
		<?php
						}

$i++;
					}
					if ($smonth != $iLastMonth) {
						// starting in a new month
						if ($iLastMonth > 0) echo "</td>";
						// fill in the months before this
						if ($iLastMonth > $smonth) {
							for ($z = $iLastMonth + 1; $z <= 12; $z++) {
								$sThisRow .= "<td>&nbsp;</td>";
							}
							for ($z = 1; $z < $smonth; $z++) {
								$sThisRow .= "<td>&nbsp;</td>";
							}
						} else {
							for ($z = $iLastMonth + 1; $z < $smonth; $z++) {
								$sThisRow .= "<td>&nbsp;</td>";
							}
						}

if ($emonth > $smonth) {
							$sThisRow .= "<td nowrap colspan=" . ($emonth - $smonth) . " align=center>";
						} else {
							$sThisRow .= "<td nowrap align=center>";
						}
					} else {
						$sThisRow .= "<hr>";
					}
					
					if (!$isPDF) {
						$sThisRow .= "<a href='/sce/school-event?id=" . $eventid . "'>" . $sday;
						if (strtotime($enddate) > strtotime($startdate)) {
							$sThisRow .= "-" . $eday;
						}
						$sThisRow .= " " . date("M", strtotime(date("Y") . "-" . $smonth . "-01"));
						$sThisRow .= "<br><small>" . $city . "</small></a><br>";
						if ($row["Cancelled"] == 0) {
							$sThisRow .= "<a href='/sce/school-event-registration?id=" . $eventid . "'><u><i>Register&nbsp;Now</i></u></a>";
						} else {
							$sThisRow .= "Cancelled";
						}
					} else {
						$sThisRow .= $sday;
						if (strtotime($enddate) > strtotime($startdate)) {
							$sThisRow .= "-" . $eday;
						}
						$sThisRow .= " " . date("M", strtotime(date("Y") . "-" . $smonth . "-01"));
						$sThisRow .= "<br><small>" . $city . "</small><br>";
						if ($row["Cancelled"] == 0) {
							$sThisRow .= "<i>Register&nbsp;Now</i>";
						} else {
							$sThisRow .= "Cancelled";
						}
					}
					// $sThisRow .= "</td>"."\r\n";

$iLastMonth = $smonth;
					if ($iLastMonth > 12) $iLastMonth = 1;
					$lasteventid = $eventid;
				}

if (!empty($sLastEvent)) {
					if ($iLastMonth > 0) $sThisRow .= "</td>";
					for ($z = $iLastMonth + 1; $z <= $lastmonthShown; $z++) {
						$sThisRow .= "<td>&nbsp;</td>";
					}
					$sThisRow .= "</tr>
";

$sThisRow = str_replace("EVENTIDHERE", $lasteventid, $sThisRow);
					echo $sThisRow;
				}
			}
		}
		?>
	</tbody>
</table>