Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
SpryAssets	[ DIR ]	drwxr-sr-x	2013-09-25 09:36
docthumbs	[ DIR ]	drwxr-sr-x	2015-07-16 10:47
downloads	[ DIR ]	drwxr-sr-x	2015-05-20 09:39
guidelines	[ DIR ]	drwxr-sr-x	2017-10-25 14:17
images	[ DIR ]	drwxr-sr-x	2015-07-14 05:06
lightbox	[ DIR ]	drwxr-sr-x	2013-09-25 09:35
pdf	[ DIR ]	drwxr-sr-x	2013-09-25 09:36
Guideline 2 - Developing a WPTP.DOCX	182.26 KB	-rw-r--r--	2013-09-25 09:33
ReportMilestones.php	7.54 KB	-rw-r--r--	2014-07-07 06:49
archivedmessages.php	2.69 KB	-rw-r--r--	2013-10-21 10:34
calendar.js	13.62 KB	-rw-r--r--	2013-09-25 09:33
calendar.php	2.88 KB	-rw-r--r--	2014-01-22 08:36
changedates.php	1.37 KB	-rw-r--r--	2013-09-25 09:33
contacts.php	3.2 KB	-rw-r--r--	2013-09-25 09:33
details.php	5.48 KB	-rw-r--r--	2013-09-25 09:33
feedback.php	16.68 KB	-rw-r--r--	2015-09-16 05:17
forgotpwd.php	2.49 KB	-rw-r--r--	2013-10-14 07:07
gallery.php	2.27 KB	-rw-r--r--	2013-09-25 09:33
guidelines.php	1.95 KB	-rw-r--r--	2014-10-13 08:37
inc_footer.php	349 B	-rw-r--r--	2013-09-25 09:34
inc_functions.php	739 B	-rw-r--r--	2013-10-10 13:34
inc_header.php	114 B	-rw-r--r--	2014-01-22 08:56
inc_sidebar.php	3.7 KB	-rw-r--r--	2018-11-21 13:29
index.php	8.85 KB	-rw-r--r--	2015-07-14 05:07
library.php	3.98 KB	-rw-r--r--	2013-09-25 09:35
login.php	3.88 KB	-rw-r--r--	2014-07-21 09:41
logout.php	104 B	-rw-r--r--	2013-09-25 09:35
messages.php	4.35 KB	-rw-r--r--	2014-01-22 08:56
milestones.php	15.55 KB	-rw-r--r--	2015-07-13 09:14
milestones_backup.php	18.64 KB	-rw-r--r--	2014-01-16 08:07
modcontact.php	5.75 KB	-rw-r--r--	2014-04-14 08:20
notices.php	2.76 KB	-rw-r--r--	2013-09-25 09:35
password.php	5.11 KB	-rw-r--r--	2014-11-03 09:00
pdfthumb.php	230 B	-rw-r--r--	2013-09-25 09:48
php_errors.log	1.92 KB	-rw-r--r--	2026-08-20 23:56
profile.php	8.1 KB	-rw-r--r--	2018-11-23 12:50
readmessage.php	4.21 KB	-rw-r--r--	2014-01-22 08:56
register.php	79.1 KB	-rw-r--r--	2014-09-02 10:32
register_step2.php	56.18 KB	-rw-r--r--	2014-11-03 09:09
sentmessages.php	2.51 KB	-rw-r--r--	2013-10-21 10:34
style.css	3.72 KB	-rw-r--r--	2013-09-25 09:36
templates.php	1.91 KB	-rw-r--r--	2013-09-25 09:36

Rename

<?php
include("inc_functions.php");

if (!isset($_SESSION["StudentID"]) || empty($_SESSION["StudentID"])) header("Location: http://www.cesa.co.za/mentanet/login.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>MentaNet</title>
<link href="style.css" rel="stylesheet" type="text/css" />

</head>

<div id="container">
<?php include("inc_header.php"); ?>
<?php include("inc_sidebar.php"); ?>
  <div id="mainContent">
<h1>Milestones Report</h1>
<br>
<table cellspacing="0" class="ewGrid"><tr><td class="ewGridContent">
<?php

function ShowRows($iEmployerID, $sEmployer) {

if (!empty($sEmployer)) {
?><p><b><?php echo $sEmployer; ?></b></p>
<?php
	} else {
?><p><b>No Coordinator</b></p>
<?php
	}
?>
<table width="740" cellspacing="0" border="1" class="ewTable ewTableSeparate" rowhighlightclass="ewTableHighlightRow" rowselectclass="ewTableSelectRow" roweditclass="ewTableEditRow"<?php if (isset($_GET["export"])) echo " border=1"; ?>>
<thead>
	<tr class="ewTableHeader">
		<td width="80">Type</td>
		<td width="200">Name</td>
		<td width="200">Contact</td>
        <td width="80">Milestone</td>
        <td width="80">Num Steps<br>
          Completed</td>
        <td width="300">Details</td>
	</tr>
</thead>
<tbody>
<?php
	if (!empty($sEmployer)) {
		$sql="SELECT COUNT(CCMMilestones.CCMMilestoneID) AS NumSteps, CCMEmployers.CCMEmployerID, CCMEmployers.FirstName, CCMEmployers.Surname, CCMEmployers.Telephone, CCMEmployers.Cellphone, CCMEmployers.EmailAddress, CCMMilestones.MilestoneNum
		FROM CCMEmployers LEFT JOIN CCMMilestones ON (CCMEmployerID=CCMStudentID)
		WHERE CCMEmployers.CCMEmployerID=".$iEmployerID."
		GROUP BY CCMEmployers.CCMEmployerID, CCMEmployers.FirstName, CCMEmployers.Surname, CCMEmployers.Telephone, CCMEmployers.Cellphone, CCMEmployers.EmailAddress, CCMMilestones.MilestoneNum
		ORDER BY CCMEmployers.Surname, CCMEmployers.FirstName, CCMMilestones.MilestoneNum";
		$recS=mysql_query($sql);
		while ($rowS=mysql_fetch_assoc($recS)) {
?><tr><td>Coordinator</td><td><?php echo $rowS["FirstName"]." ".$rowS["Surname"]; ?></td>
<td><?php echo $rowS["Telephone"]."<br>".$rowS["Cellphone"]."<br>".$rowS["EmailAddress"]; ?></td>
<td><?php echo $rowS["MilestoneNum"]; ?></td><td><?php echo $rowS["NumSteps"]; ?></td>
<td><?php if ($rowS["NumSteps"]>0) { echo "<ul>"; ShowDetails($rowS["CCMEmployerID"], $rowS["MilestoneNum"]); echo "</ul>"; } ?></td>
</tr>
<?php
		}
	}
?>
<?php
	$sql="SELECT COUNT(CCMMilestones.CCMMilestoneID) AS NumSteps, CCMStudents.MentorID, CCMStudents.CCMStudentID, CCMStudents.FirstName, CCMStudents.Surname, CCMStudents.Telephone, CCMStudents.Cellphone, CCMStudents.EmailAddress, CCMMilestones.MilestoneNum FROM CCMStudents LEFT JOIN CCMMilestones ON (CCMStudents.CCMStudentID=CCMMilestones.CCMStudentID)
	WHERE ";
	if (!empty($sEmployer)) {
		$sql.=" CCMStudents.EmployerID=".$iEmployerID;
	} else {
		$sql.=" (CCMStudents.EmployerID IS NULL OR CCMStudents.EmployerID=0)";
	}
	$sql.="
	AND CCMStudents.Archived=0
	GROUP BY CCMStudents.MentorID, CCMStudents.CCMStudentID, CCMStudents.FirstName, CCMStudents.Surname, CCMStudents.Telephone, CCMStudents.Cellphone, CCMStudents.EmailAddress, CCMMilestones.MilestoneNum
	ORDER BY CCMStudents.Surname, CCMStudents.FirstName, CCMMilestones.MilestoneNum";
	$recS=mysql_query($sql);
	while ($rowS=mysql_fetch_assoc($recS)) {
?><tr><td>Candidate</td><td><?php echo $rowS["FirstName"]." ".$rowS["Surname"]; ?><br>
	(Mentor: <?php
	$sql="SELECT * FROM CCMMentors WHERE CCMMentorID=".$rowS["MentorID"];
	$recM=mysql_query($sql); if ($rowM=mysql_fetch_assoc($recM)) echo $rowM["FirstName"]." ".$rowM["Surname"];
	mysql_free_result($recM);
	?>)</td>
<td><?php echo $rowS["Telephone"]."<br>".$rowS["Cellphone"]."<br>".$rowS["EmailAddress"]; ?></td>
<td><?php echo $rowS["MilestoneNum"]; ?></td><td><?php echo $rowS["NumSteps"]; ?></td>
<td><?php if ($rowS["NumSteps"]>0) { echo "<ul>"; ShowDetails($rowS["CCMStudentID"], $rowS["MilestoneNum"]); echo "</ul>"; } ?></td>
</tr>
<?php
}
?>
<?php
	$sql="SELECT COUNT(CCMMilestones.CCMMilestoneID) AS NumSteps, CCMMentors.CCMMentorID, CCMMentors.FirstName, CCMMentors.Surname, CCMMentors.Telephone, CCMMentors.Cellphone, CCMMentors.EmailAddress, CCMMilestones.MilestoneNum FROM (CCMMentors INNER JOIN CCMStudents ON (CCMMentorID=MentorID ))
	LEFT JOIN CCMMilestones ON (CCMMentorID=CCMMilestones.CCMStudentID)
	WHERE ";
	if (!empty($sEmployer)) {
		$sql.=" CCMStudents.EmployerID=".$iEmployerID;
	} else {
		$sql.=" (CCMStudents.EmployerID IS NULL OR CCMStudents.EmployerID=0)";
	}
	$sql.="
	AND CCMStudents.Archived=0
	GROUP BY CCMMentors.CCMMentorID, CCMMentors.FirstName, CCMMentors.Surname, CCMMentors.Telephone, CCMMentors.Cellphone, CCMMentors.EmailAddress, CCMMilestones.MilestoneNum
	ORDER BY CCMMentors.Surname, CCMMentors.FirstName, CCMMilestones.MilestoneNum";
	$recS=mysql_query($sql);
	while ($rowS=mysql_fetch_assoc($recS)) {
?><tr><td>Mentor</td><td><?php echo $rowS["FirstName"]." ".$rowS["Surname"]; ?></td>
<td><?php echo $rowS["Telephone"]."<br>".$rowS["Cellphone"]."<br>".$rowS["EmailAddress"]; ?></td>
<td><?php echo $rowS["MilestoneNum"]; ?></td><td><?php echo $rowS["NumSteps"]; ?></td>
<td><?php if ($rowS["NumSteps"]>0) { echo "<ul>"; ShowDetails($rowS["CCMMentorID"], $rowS["MilestoneNum"]); echo "</ul>"; } ?></td>
</tr>
<?php
	}
?>
</tbody>
</table>
<?php 
} 
		$sql = "SELECT DISTINCT CCMEmployers.* FROM CCMEmployers, CCMStudents
		WHERE CCMEmployers.CCMEmployerID =CCMStudents.EmployerID
		AND CCMStudents.";
		if ($_SESSION["UserType"]=="M") $sql.="MentorID=".$_SESSION["StudentID"];
		if ($_SESSION["UserType"]=="E") $sql.="EmployerID=".$_SESSION["StudentID"];
//		echo $sql;
		$recE=mysql_query($sql);
		if ($rowE=mysql_fetch_assoc($recE)) {
			ShowRows($rowE["CCMEmployerID"], $rowE["Organisation"]);
		}
?>
</td></tr></table>
  </div>
<?php include("inc_footer.php"); ?>
	</div>
</body>
</html>