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
session_start(); // Initialize Session data
ob_start(); // Turn on output buffering
?>
<?php include "ewcfg7.php" ?>
<?php include "ewmysql7.php" ?>
<?php include "phpfn7.php" ?>
<?php include "CCEAssignmentsinfo.php" ?>
<?php include "userfn7.php" ?>
<?php
if (!isset($_SESSION[EW_SESSION_STATUS]) || ($_SESSION[EW_SESSION_STATUS] != "login")) {
    header("Location: http://www.cesa.co.za/cceconvenors/login.php");
    die();
}
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // Always modified
header("Cache-Control: private, no-store, no-cache, must-revalidate"); // HTTP/1.1
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache"); // HTTP/1.0
?>
<?php
include "header.php";
?>
<style type="text/css">
    
</style>
<style type="text/css">
    <!--
    .table {
        padding: 0px;
        color: black;
        text-align: general;
        vertical-align: bottom;
        border: none;
        white-space: nowrap;
    }

.cell {
        padding: 0px;
        color: black;
        text-align: center;
        vertical-align: middle;
        border: .5pt solid windowtext;
        white-space: normal;
    }

.submitted {
        background: #92D050;
    }

.notsubmitted {
        background: #feade3;
    }

.darkcell {
        background: #DA9694;
    }

.lightcell {
        background: #F2DCDB;
    }

.whitetext {
        color: white;
    }
    -->
</style>
<h1> Assignments Uploaded</h1>
<?php

function getInitials($name)
{
    //split name using spaces
    $words = explode(" ", $name);
    $inits = '';
    //loop through array extracting initial letters
    foreach ($words as $word) {
        $inits .= strtoupper(substr($word, 0, 1));
    }
    return $inits;
}
?>
<table width="95%" align="center" class="table" cellpadding="5" cellspacing="0">
    <tr>
        <td width="20%" align="center"><input type="checkbox" class="filter-checkbox" name="check-all" id="check-all" value="1,2,3,4,5" checked /> All</td>
        <td width="20%" align="center"><input type="checkbox" class="filter-checkbox" name="check-cce" id="check-cce" value="1" /> Consulting Engineering Environment</a></td>
        <td width="20%" align="center"><input type="checkbox" class="filter-checkbox" name="check-cce" id="check-cce" value="2" /> Project Delivery</td>
        <td width="20%" align="center"><input type="checkbox" class="filter-checkbox" name="check-fin" id="check-fin" value="3" /> Finance</td>
        <td width="20%" align="center"><input type="checkbox" class="filter-checkbox" name="check-law" id="check-law" value="4" /> Law</td>
    </tr>
</table>
<p>&nbsp;</p>

<table border="0" cellspacing="0" cellpadding="0" width="720">
    <tr>
        <td width="290" valign="top">
            <table cellspacing="0" cellpadding="2" class="table" width="200">
                <tr>
                    <td class="cell darkcell">NAME<br><br><br><br></td>
                    
                </tr>
                <?php
                $sql = "SELECT CCEStudents.CCEStudentID, CCEStudents.Surname, CCEStudents.FirstName, CCEStudents.KnownAs, CCEFacilitators.FacilitatorName "
                    . "FROM CCEStudents LEFT JOIN CCEFacilitators ON (CCEFacilitatorID=FacilitatorID) "
                    . "WHERE CCEStudents.Archived=0 AND CCEStudents.CCEStudentID<>54 "
                    . "ORDER BY CCEStudents.CCEFacilitatorID, CCEStudents.Surname, CCEStudents.FirstName";
                $recStudents = mysql_query($sql);
                $iLastFacilitator = "";
                $cellclass = " darkcell";
                while ($rowStudents = mysql_fetch_assoc($recStudents)) {
                    if ($iLastFacilitator != $rowStudents["FacilitatorName"]) {
                        $iLastFacilitator = $rowStudents["FacilitatorName"];
                        if ($cellclass == " darkcell") {
                            $cellclass = " lightcell";
                        } else {
                            $cellclass = " darkcell";
                        }
                    }
                ?>
                    <tr>
                        <td class="cell<?php echo $cellclass; ?>" width="200" style="border-top:none;" nowrap><?php echo $rowStudents["KnownAs"] . " " . $rowStudents["Surname"]; ?></td>
                        
                    </tr>
                <?php
                }
                ?>
            </table>
        </td>
        <td width="520" valign="top">
            <div style="width:520px; overflow:scroll">
                <table cellspacing="0" cellpadding="2" class="table" width="520">
                    <tr>
                        <?php
                        $sql = "SELECT CCEAssignments.* FROM CCEAssignments
	WHERE Archived=0 AND ReleaseDate <= '" . date("Y-m-d") . "'
	AND YEAR(ReleaseDate)=YEAR(NOW())
	ORDER BY RefNum";
                        //                        echo $sql;
                        //                        exit;
                        $rec = mysql_query($sql);
                        while ($row = mysql_fetch_assoc($rec)) {
                            $cellclass = "";
                            if ($row["AssigType"] == 0) {
                                $cellclass = " lightcell";
                            } else {
                                $cellclass = " hardcopy";
                            }
                        ?>
                            <td class="cell<?php echo $cellclass; ?> mod-<?php echo $row['CCEModuleID']; ?>" width="41" style="border-left:none;width:25pt;">
                                <?php echo $row["RefNum"]; ?><br>
                                <?php echo $row["DueDate"]; ?>
                            </td>
                        <?php
                        } //while assignments
                        ?>
                        <td class="cell darkcell">&nbsp;<br><br><br><br></td>
                    </tr>
                    <?php
                    mysql_data_seek($recStudents, 0);
                    $iLastFacilitator = "";
                    $cellclass = " darkcell";
                    while ($rowStudents = mysql_fetch_assoc($recStudents)) {
                        if ($iLastFacilitator != $rowStudents["FacilitatorName"]) {
                            $iLastFacilitator = $rowStudents["FacilitatorName"];
                            if ($cellclass == " darkcell") {
                                $cellclass = " lightcell";
                            } else {
                                $cellclass = " darkcell";
                            }
                        }
                    ?>
                        <tr>
                            <?php
                            mysql_data_seek($rec, 0);
                            while ($row = mysql_fetch_assoc($rec)) {

// Achieved assignments that need enhancement must say "E" instead of "Y"
                                // Enhancements and resubmissions - add an E or an R as required

$sql = "SELECT * FROM CCEStudentAssignments WHERE CCEStudentID='" . $rowStudents["CCEStudentID"] . "' AND CCEAssignmentID=" . $row["CCEAssignmentID"] . " ORDER BY CCEStudentAssigID DESC";
                                $recAssig = mysql_query($sql);
                                $cellclass2 = " notsubmitted";
                                $cellvalue = "N";
                                if ($rowAssig = mysql_fetch_assoc($recAssig)) {
                                    $iStatus = $rowAssig["Passed"];
                                    $cellvalue = "Y";
                                    $cellclass2 = " submitted";

//                                    if ($iStatus == 0)
                                    //                                        $cellvalue = "Y";
                                    //                                    if ($iStatus == 1)
                                    //                                        $cellvalue = "Y";
                                    //                                    if ($iStatus == 2)
                                    //                                        $cellvalue = "N";

if ((mysql_num_rows($recAssig) > 1) && ($iStatus != 1)) {
                                        if ($rowAssig = mysql_fetch_assoc($recAssig)) {
                                            if (($rowAssig["RulingCode"] == "NE") || ($rowAssig["RulingCode"] == "U") || ($rowAssig["RulingCode"] == "R")) {
                                                //							$cellclass2=" resubmitted";
                                                //if ($rowAssig["RulingCode"]=="NE") $cellvalue.="E";
                                                //if (($rowAssig["RulingCode"]=="U") || ($rowAssig["RulingCode"]=="R")) $cellvalue.="R";
                                            }
                                        }
                                    } else {
                                        if ($iStatus == 0) {
                                            //$cellclass2=" notevaluated";
                                        } elseif ($iStatus == 1) {
                                            //$cellclass2=" achieved";
                                            // Needs enhancement?
                                            if ($rowAssig["RulingCode"] == "NE") {
                                                //$cellvalue="E";
                                                //$cellclass2=" achieved whitetext";
                                            }
                                        } elseif ($iStatus == 2) {
                                            //$cellclass2=" notachieved";
                                            //$cellvalue="R";
                                        }
                                    }
                                } else {
                                    $sql = "SELECT * FROM CCEStAssigExtensions WHERE CCEStudentID='" . $rowStudents["CCEStudentID"] . "' AND CCEAssignmentID=" . $row["CCEAssignmentID"];
                                    $recAssig = mysql_query($sql);
                                    if ($rowAssig = mysql_fetch_assoc($recAssig)) {
                                        if ($rowAssig["CCEExtensionDate"] >= date("Y-m-d"))
                                            $cellvalue .= "*";
                                    }
                                }
                                mysql_free_result($recAssig);
                            ?>
                                <td class="cell<?php echo $cellclass2; ?>" width="41" style="border-top:none;border-left:none;width:25pt;"><?php echo $cellvalue; ?></td>
                            <?php
                            }
                            ?>
                            <td></td>
                        </tr>
                    <?php
                    } //while
                    ?>
                </table>
            </div>
        </td>
    </tr>
</table>
<br>
<table cellspacing="0" cellpadding="0">
    <tr>
        <td width="63" align="center" class="submitted">Y</td>
        <td width="300">Submitted</td>
    </tr>
    <tr>
        <td width="63" align="center" class="notsubmitted">N</td>
        <td width="300">Not yet Submitted</td>
    </tr>
    <tr>
        <td width="63" align="center" class="notsubmitted">N*</td>
        <td width="300">Extension granted</td>
    </tr>
</table>
<?php
include "footer.php";