Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
BCE Home cover_files	[ DIR ]	drwxr-sr-x	2012-03-12 06:07
BCE Introduction_files	[ DIR ]	drwxr-sr-x	2012-03-12 06:07
BCE RESOURCE AND SUPPORT_files	[ DIR ]	drwxr-sr-x	2012-03-12 06:08
BCE RULES AND REGULATIONS_files	[ DIR ]	drwxr-sr-x	2012-03-12 06:07
BCE THE LEARNING PROGRAMME_files	[ DIR ]	drwxr-sr-x	2012-03-12 06:08
SpryAssets	[ DIR ]	drwxr-sr-x	2013-02-14 22:54
ajax	[ DIR ]	drwxr-sr-x	2026-08-20 14:43
assignments	[ DIR ]	drwxr-sr-x	2022-03-07 13:03
docthumbs	[ DIR ]	drwxr-sr-x	2022-03-14 09:40
facilitators	[ DIR ]	drwxr-sr-x	2012-01-18 08:00
guidelines	[ DIR ]	drwxr-sr-x	2021-04-29 08:34
images	[ DIR ]	drwxr-sr-x	2023-04-18 07:54
includes	[ DIR ]	drwxr-sr-x	2024-02-23 09:41
lightbox	[ DIR ]	drwxr-sr-x	2012-07-02 08:44
pdf	[ DIR ]	drwxr-sr-x	2012-03-15 12:53
pdf-viewer	[ DIR ]	drwxr-sr-x	2025-02-20 13:18
visual-countdown-timer	[ DIR ]	drwxr-sr-x	2021-11-03 09:27
activities.php	6.49 KB	-rw-r--r--	2024-02-23 09:36
activityadd.php	7.44 KB	-rw-r--r--	2024-02-23 09:36
advisory.php	1.37 KB	-rw-r--r--	2024-02-23 09:36
assignmentadd.php	43.1 KB	-rw-r--r--	2026-08-19 12:45
assignmentinfo.php	2.96 KB	-rw-r--r--	2025-02-24 16:01
assignmentpack.php	4.66 KB	-rw-r--r--	2024-02-23 09:36
assignmentpdf.php	3.64 KB	-rw-r--r--	2024-02-23 09:36
assignments.php	14.04 KB	-rw-r--r--	2026-06-24 12:03
assigsummary.php	12.25 KB	-rw-r--r--	2025-04-14 08:46
calendar.js	13.28 KB	-rw-r--r--	2024-02-23 09:36
calendar.php	502 B	-rw-r--r--	2024-02-23 09:47
cceregister.php	22.5 KB	-rw-r--r--	2013-10-09 08:40
changedates.php	1.35 KB	-rw-r--r--	2024-02-23 09:36
contacts.php	4.87 KB	-rw-r--r--	2025-06-26 12:42
contacts_students.php	2.34 KB	-rw-r--r--	2024-02-27 11:36
details.php	9.24 KB	-rw-r--r--	2025-02-06 10:38
document-pdf-proxy.php	1.95 KB	-rw-r--r--	2025-06-27 10:14
document-view.php	7.35 KB	-rw-r--r--	2025-06-27 12:42
download_student_agreement.php	1.71 KB	-rw-r--r--	2026-03-16 11:53
evaluations.php	6.85 KB	-rw-r--r--	2024-02-23 09:36
exam.php	47.02 KB	-rw-r--r--	2026-08-25 07:11
examresults.php	3.01 KB	-rw-r--r--	2026-02-17 09:45
extension.php	11.33 KB	-rw-r--r--	2026-08-19 12:45
feedback.php	3.91 KB	-rw-r--r--	2024-02-23 09:36
feedbackmsgs.php	5.04 KB	-rw-r--r--	2024-03-25 10:07
file-download.php	343 B	-rw-r--r--	2026-06-24 12:03
forgotpwd.php	2.57 KB	-rw-r--r--	2024-02-23 09:36
gallery.php	1.75 KB	-rw-r--r--	2024-02-23 09:36
guideline-view.php	812 B	-rw-r--r--	2026-02-17 09:45
guideline.php	1 KB	-rw-r--r--	2026-02-17 09:45
guideline_intro.php	14.2 KB	-rw-r--r--	2024-02-23 09:36
guideline_notes.php	2.35 KB	-rw-r--r--	2024-02-23 09:36
guideline_programme.php	39.82 KB	-rw-r--r--	2024-02-23 09:36
guideline_resources.php	21.47 KB	-rw-r--r--	2024-02-23 09:36
guideline_rules.php	44.97 KB	-rw-r--r--	2024-02-23 09:36
inc_dashboard.php	28.4 KB	-rw-r--r--	2026-08-20 12:16
inc_footer.php	412 B	-rw-r--r--	2025-02-20 13:01
inc_footer_html.php	59 B	-rw-r--r--	2024-02-23 09:36
inc_functions.php	1.86 KB	-rw-r--r--	2026-06-24 12:03
inc_guidelinemenu.php	944 B	-rw-r--r--	2024-02-23 09:36
inc_header.php	2.46 KB	-rw-r--r--	2025-02-20 13:01
inc_header_html.php	1.34 KB	-rw-r--r--	2024-02-23 09:36
inc_shared.php	27.07 KB	-rw-r--r--	2026-08-19 12:45
inc_sidebar.php	9.54 KB	-rw-r--r--	2026-05-13 15:17
index.php	8.47 KB	-rw-r--r--	2026-06-02 08:33
library-old.php	8.46 KB	-rw-r--r--	2024-02-16 11:19
library-render.php	11.09 KB	-rw-r--r--	2026-04-29 07:23
library.php	474 B	-rw-r--r--	2024-02-25 11:44
login.php	2.79 KB	-rw-r--r--	2025-02-06 10:39
logout.php	129 B	-rw-r--r--	2024-02-23 09:36
markmessagesread.php	546 B	-rw-r--r--	2024-02-23 09:36
messages.php	4.14 KB	-rw-r--r--	2026-05-05 11:48
modcontact.php	26.51 KB	-rw-r--r--	2026-07-30 15:46
module.php	2.78 KB	-rw-r--r--	2024-02-23 09:36
notices.php	2.73 KB	-rw-r--r--	2024-02-23 09:36
password.php	2.52 KB	-rw-r--r--	2024-02-23 09:36
pdfthumb.php	230 B	-rw-r--r--	2024-02-23 09:36
php_errors.log	14.11 KB	-rw-r--r--	2026-08-21 08:24
phpinfo.php	17 B	-rw-r--r--	2025-06-09 13:16
popups.php	1.71 KB	-rw-r--r--	2024-02-23 09:36
profile.php	14.69 KB	-rw-r--r--	2026-03-16 11:53
profile_mentor.php	4.23 KB	-rw-r--r--	2024-02-23 09:36
progress_report.php	2.53 KB	-rw-r--r--	2026-05-13 15:17
readmessage.php	2.49 KB	-rw-r--r--	2026-05-19 07:04
recommended.php	5.94 KB	-rw-r--r--	2024-02-16 11:18
resources.php	4.14 KB	-rw-r--r--	2024-02-23 09:36
results.php	1.54 KB	-rw-r--r--	2024-02-23 09:36
saveexam.php	5.72 KB	-rw-r--r--	2025-11-19 09:45
sentmessages.php	1.66 KB	-rw-r--r--	2024-03-27 09:30
style.css	26.86 KB	-rw-r--r--	2025-02-20 13:04
submittedactivities.php	2.98 KB	-rw-r--r--	2024-02-23 09:36
submittedassignments.php	7.78 KB	-rw-r--r--	2026-06-24 12:03
templates.php	2.08 KB	-rw-r--r--	2024-02-23 09:36
timetable-render.php	2.27 KB	-rw-r--r--	2025-02-20 13:03
timetable.php	476 B	-rw-r--r--	2024-03-16 16:02
v3_feedback_form.php	2.52 KB	-rw-r--r--	2026-05-27 08:23
v3_feedback_submit.php	2.55 KB	-rw-r--r--	2026-05-27 08:23
videos.php	4.06 KB	-rw-r--r--	2024-02-23 09:36

Rename

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

//ini_set('display_errors', 1);
//error_reporting(E_ALL);

if (!isset($_SESSION["StudentID"]) || empty($_SESSION["StudentID"]) || $_SESSION["StudentID"] == null)
    header("Location: /cesanet/login.php");

include_once($_SERVER['DOCUMENT_ROOT'] . "/cesanet/includes/html_begin.php");

$cceUploadedFileService = new CceUploadedFileService();
$studentId = intval($_SESSION['StudentID']);
?>
<h1> Submitted Assignments</h1>
<?php
$sql = "SELECT CCEAssignments.*, CCEModules.ModuleName
	FROM CCEAssignments INNER JOIN CCEModules USING (CCEModuleID)
	WHERE EXISTS (SELECT * FROM CCEStudentAssignments WHERE CCEStudentAssignments.CCEAssignmentID=CCEAssignments.CCEAssignmentID AND CCEStudentAssignments.CCEStudentID=" . $_SESSION["StudentID"] . ")
	ORDER BY RefNum, ArchiveYear";
//	echo $sql;
$rec = mysql_query($sql);
if (mysql_num_rows($rec) > 0) {
    ?>
    <table border="1" cellpadding="2" cellspacing="0" width="700">
        <tr><td width="250"><b>Module</b></td><td width="250"><b>Assignment</b></td><td><b>Submissions</b></td></tr>
        <?php
        while ($row = mysql_fetch_assoc($rec)) {
            ?>
            <tr><td><?php echo $row["ModuleName"]; ?></td>
                <td><?php
                    echo $row["RefNum"];
                    if (!empty($row["ArchiveYear"]))
                        echo " (" . $row["ArchiveYear"] . ") ";
                    echo ": " . $row["AssignmentName"];
                    ?></td>
                <td><table width="100%" border="1" cellpadding="2" cellspacing="0"><?php
                        $sql = "SELECT CCEStudentAssignments.*, CCERulingCodes.Ruling
		FROM CCEStudentAssignments LEFT JOIN CCERulingCodes USING (RulingCode)
		WHERE CCEStudentAssignments.CCEStudentID=" . $_SESSION["StudentID"] . "
		AND CCEStudentAssignments.CCEAssignmentID=" . $row["CCEAssignmentID"] . "
		ORDER BY CCEStudentAssignments.CCEStudentAssigID";
                        //	echo $sql;
                        $rec2 = mysql_query($sql);
                        $iNumSub = 0;
                        while ($row2 = mysql_fetch_assoc($rec2)) {
                            $iNumSub++;
                            ?>
                            <tr><td width="10"><?php echo $iNumSub; ?></td><td width=50><?php
                                    if (!empty($row2["AssignmentFile1"])) {
                                        $fileUrl = $cceUploadedFileService->buildStudentAssignmentFileUrl(
                                            intval($row2['CCEAssignmentID']),
                                            $studentId,
                                            1,
                                            $row2['AssignmentFile1']
                                        );
                                        echo "<a href='" . htmlspecialchars((string) $fileUrl) . "' target='_blank' rel='noopener'>File 1</a><br>";
                                    }
                                    if (!empty($row2["AssignmentFile2"])) {
                                        $fileUrl = $cceUploadedFileService->buildStudentAssignmentFileUrl(
                                            intval($row2['CCEAssignmentID']),
                                            $studentId,
                                            2,
                                            $row2['AssignmentFile2']
                                        );
                                        echo "<a href='" . htmlspecialchars((string) $fileUrl) . "' target='_blank' rel='noopener'>File 2</a><br>";
                                    }
                                    if (!empty($row2["AssignmentFile3"])) {
                                        $fileUrl = $cceUploadedFileService->buildStudentAssignmentFileUrl(
                                            intval($row2['CCEAssignmentID']),
                                            $studentId,
                                            3,
                                            $row2['AssignmentFile3']
                                        );
                                        echo "<a href='" . htmlspecialchars((string) $fileUrl) . "' target='_blank' rel='noopener'>File 3</a><br>";
                                    }
                                    if (!empty($row2["AssignmentFile4"])) {
                                        $fileUrl = $cceUploadedFileService->buildStudentAssignmentFileUrl(
                                            intval($row2['CCEAssignmentID']),
                                            $studentId,
                                            4,
                                            $row2['AssignmentFile4']
                                        );
                                        echo "<a href='" . htmlspecialchars((string) $fileUrl) . "' target='_blank' rel='noopener'>File 4</a><br>";
                                    }
                                    if (!empty($row2["AssignmentFile5"])) {
                                        $fileUrl = $cceUploadedFileService->buildStudentAssignmentFileUrl(
                                            intval($row2['CCEAssignmentID']),
                                            $studentId,
                                            5,
                                            $row2['AssignmentFile5']
                                        );
                                        echo "<a href='" . htmlspecialchars((string) $fileUrl) . "' target='_blank' rel='noopener'>File 5</a><br>";
                                    }
                                    ?></td>
                                <td style="<?php
                                if ($row2["Passed"] == 2) {
                                    echo "background-color:#FFCC99";
                                } elseif (($row2["Passed"] == 1) && ($row2["RulingCode"] == "NE")) {
                                    echo "background-color:#FFFF99";
                                }
                                ?>">
                                        <?php
                                        if (($row2["Passed"] == 1) || ($row2["Passed"] == 2))
                                            echo $row2["Ruling"];
                                        if ($row2["Passed"] == 0)
                                            echo "Not Yet Evaluated";
                                        if ($row2["Passed"] == 3)
                                            echo "Added to PoE";
                                        if ($iNumSub == mysql_num_rows($rec2)) {
                                            ?>
                                            <?php
                                            if ($row2["RulingCode"] == "R") {
                                                echo "<br><a href='assignmentadd.php?id=" . $row["CCEAssignmentID"] . "'>Upload resubmission</a>";
                                                echo "<br>Due by " . GetResubDate($row["CCEAssignmentID"]);
                                            }
                                            ?>
                                            <?php if ($row2["RulingCode"] == "NE") echo "<br><a href='assignmentadd.php?id=" . $row["CCEAssignmentID"] . "'>Upload enhancement</a>"; ?>
                                            <?php
                                        }
                                        ?>
                                </td></tr>
                            <?php
                        }
                        ?>
                    </table></td></tr>
            <?php
        }
        ?>
    </table>
    <?php
} else {
    echo "No assignments have yet been completed.";
}

include_once($_SERVER['DOCUMENT_ROOT'] . "/cesanet/includes/html_end.php");