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
//ini_set('display_errors', 1);
//error_reporting(E_ALL);

include("inc_functions.php");

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

$cceStudentId = intval($_SESSION["StudentID"]);

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

$maxDays = 7;

if ($env == 'dev') {
    $maxDays = 70;
}

if (!isset($_REQUEST["CCEStudentAssigID"]) || $_REQUEST["CCEStudentAssigID"] <= 0) {

$studentAssignmentObj = new CCEStudentAssignment($sqlf);
    $studentAssignment = $studentAssignmentObj->findOrCreateByStudentAssignment($cceStudentId, $_REQUEST["id"]);
    $_REQUEST["CCEStudentAssigID"] = $studentAssignment["CCEStudentAssigID"];
}

$assignmentExtensionRequestObj = new CCEStAssigExtensionRequest($sqlf);
$cceUploadedFileService = new CceUploadedFileService();
?>
<h1>Request Extension</h1>
<?php
$sql = "SELECT CCEAssignments.* FROM CCEAssignments
WHERE CCEAssignments.CCEAssignmentID=" . intval($_REQUEST["id"]) . " AND CCEAssignments.Archived=0";
$rec = mysql_query($sql);
if ($row = mysql_fetch_assoc($rec)) {

$sDueDate = $row["DueDate"];
    $extensionRequests = $assignmentExtensionRequestObj->findAllByStudentAssignment($cceStudentId, $row['CCEAssignmentID']);
?>
    <h2><?php echo $row["AssignmentName"]; ?><br />
        <?php echo CCEStAssigExtensionRequest::getExtensionDueString($row, $extensionRequests, true); ?></h2>
    <p align="right">
        <a href="/cesanet/assignments.php">Back to Assignments</a>
    </p>
    <?php
    if (strtotime('+' . $maxDays . ' days', strtotime($row["DueDate"])) < mktime(0)) {
        echo "<p><b>It is not possible to request an extension more than 1 week after the assignment was due.</b></p>";
        echo "</div>";
        include("inc_footer.php");
        die();
    }
}

$bDisplayForm = true;

if (isset($_REQUEST["go"]) && ($_REQUEST["go"] == 1)) {
    $cceStudentId = isset($_SESSION["StudentID"]) ? intval($_SESSION["StudentID"]) : 0;
    $errs = array();
    if ($cceStudentId <= 0) {
        $errs[] = "Your session has expired or your student ID is missing. Please log in again.";
    }
    if (empty($_POST["NewDate"]))
        $errs[] = "Proposed date is required";
    if (empty($_POST["comments"]))
        $errs[] = "Motivation is required";
    if (strlen($_POST["comments"]) < 20)
        $errs[] = "Your motivation is too short. Please write at least one sentence.";

if ((strtotime($_POST["NewDate"]) < strtotime($sDueDate)) || (strtotime('+' . $maxDays . ' days', strtotime($sDueDate)) < strtotime($_POST["NewDate"])))
        $errs[] = "Please select a valid date from the calendar";

if (count($errs) == 0) {
        $uploadfilename1 = '';
        $uploadResult = $cceUploadedFileService->storeStudentSupportingDocUpload(
            'SupportingDoc',
            intval($_REQUEST['id']),
            $cceStudentId
        );
        if (is_array($uploadResult) && !empty($uploadResult['filename'])) {
            $uploadfilename1 = $uploadResult['filename'];
        } elseif (
            isset($_FILES['SupportingDoc']) &&
            is_array($_FILES['SupportingDoc']) &&
            isset($_FILES['SupportingDoc']['name']) &&
            (string) $_FILES['SupportingDoc']['name'] !== ''
        ) {
            $errs[] = 'Your supporting document could not be uploaded. Please try again.';
        }
    }

if (count($errs) == 0) {

$sql = "INSERT INTO CCEStAssigExtensionRequests (CCEStudentID, CCEAssignmentID, CCEStudentAssigID, CCEExtensionDate, Motivation, SupportingDoc, DateRequested)
		VALUES (" . $cceStudentId . ", " . intval($_REQUEST["id"]) . ", " . intval($_REQUEST["CCEStudentAssigID"]) . ", '" . date("Y-m-d", strtotime($_POST["NewDate"])) . "',
		'" . addslashes($_POST["comments"]) . "', '" . addslashes($uploadfilename1) . "', NOW())";

// Trace the insert query excecuted successfully
        // echo $sql . "\r\n";
        // exit;
        if (!mysql_query($sql)) {
            ErrorLog::logError("Failed to create extension request: " . $sql . ' - ' . mysql_error(get_current_connection()));
            echo "Failed to create your extension request. Please try again.";
            exit;
        }

$sql = "SELECT FirstName, Surname, KnownAs FROM CCEStudents WHERE CCEStudentID=" . $cceStudentId;
        $rec = mysql_query($sql);
        if ($row = mysql_fetch_assoc($rec)) {
            $sStudentName = $row["KnownAs"] . " " . $row["Surname"];
        } else {
            die('Your student record was not found. Please log in again.');
        }
        
        $sql = "SELECT CCEFacilitators.*, CCEAssignments.RefNum, CCEAssignments.AssignmentName FROM CCEAssignments JOIN CCEModuleSchedules USING (CCEModuleID) JOIN CCEFacilitators USING (`FacilitatorID`)
		WHERE CCEAssignments.CCEAssignmentID=" . intval($_REQUEST["id"]);
        $rec = mysql_query($sql);
        if ($row = mysql_fetch_assoc($rec)) {
            // $sSendTo = "brenda@cesa.co.za,craigclarkeknysna@gmail.com,melissa@cesa.co.za";
            $sSendTo = "brenda@cesa.co.za,melissa@cesa.co.za";
            if (!empty($row["EmailAddress"])) {
                $sSendTo .= "," . $row["EmailAddress"];
                //$sSendTo="julia@xe.co.za";

if ($env == 'dev') {
                    $sSendTo = 'cesabce@igotafrica.com';
                } else {
                    $sSendTo .= ',cesabce@igotafrica.com';
                }

$sMsg = "Dear " . $row["FacilitatorName"] . "

" . $sStudentName . " has requested an extension.

Assignment: " . $row["RefNum"] . " - " . $row["AssignmentName"] . "
Proposed Extension Date: " . date("Y-m-d", strtotime($_POST["NewDate"])) . "
Motivation:
" . $_POST["comments"];
                if (!empty($uploadfilename1))
                    $sMsg .= "\r\n\r\n" . "Supporting document uploaded (view in the convenor extension request list).";
                //                                mail($sSendTo, "Extension request for " . $row["RefNum"], $sMsg, "From: brenda@cesa.co.za");

$subject = "BCE Assignment Extension Request: " . $row["RefNum"] . ' - ' . $row["AssignmentName"];

// CESANet emails: send as HTML (plain text => nl2br) so links and formatting render correctly.
                $sMsgEmail = nl2br(htmlspecialchars($sMsg, ENT_QUOTES, 'UTF-8'));
                maill($sSendTo, $subject, $sMsgEmail, null, array('from-address' => 'sce@cesa.co.za', 'isHTML' => true));

$sql = "INSERT INTO CCEMessages (CCEModuleID, SentByName, SentTo, SentDateTime, MessageSubject, MessageText, SystemMessage)
			VALUES (0, 'System', '" . $row["FacilitatorName"] . "', '" . date("Y-m-d H:i:s") . "', '" . $subject . "', '" . addslashes(stripslashes($sMsg)) . "', 1)";
                mysql_query($sql);
                $sql = "INSERT INTO CCEMessagesSentTo (CCEMessageID, SentType, SentID) VALUES (" . mysqli_insert_id($conni) . ", 'Facilitator', '" . $row["FacilitatorID"] . "')";
                mysql_query($sql);
            }
        }
        echo "<p><b>Your request has been sent to the module convenor for this assignment.</b></p>";

$bDisplayForm = false;
    } else {
    ?>
        <p><b style="color:red">ERROR:</b> The request could not be submitted, please correct the following:</p>
        <ul>
            <li><?php echo implode("</li><li>", $errs); ?></li>
        </ul>
    <?php
    }
}

if ($bDisplayForm) {
    ?>
    <form action="extension.php" method="post" name="form1" id="form1" enctype="multipart/form-data">
        <input type="hidden" name="go" value="1" />
        <input type="hidden" name="id" value="<?php echo intval($_REQUEST["id"]); ?>" />
        <input type="hidden" name="CCEStudentAssigID" value="<?php echo intval($_REQUEST["CCEStudentAssigID"]); ?>" />

<div class="form-group">
            <div class="row">
                <div class="col-sm-12 col-lg-4">
                    Enter your new proposed date for submission here.<br />
                    The requested date may not be more than one week after the due date for the assignment:
                </div>
                <div class="col-sm-12 col-lg-8">
                    <input type="text" name="NewDate" size="40" required id="datepicker" class="form-control" />
                </div>
            </div>
            <div class="row">
                <div class="col-sm-12 col-lg-4">
                    Motivation / Reason for Extension (Required):
                </div>
                <div class="col-sm-12 col-lg-8">
                    <textarea name="comments" id="comments" class="form-control" required></textarea>
                </div>
            </div>
            <div class="row">
                <div class="col-sm-12 col-lg-4">
                    Supporting Document (Optional):
                </div>
                <div class="col-sm-12 col-lg-8">
                    <input type="file" name="SupportingDoc" class="form-control" />
                </div>
            </div>
        </div>

</form>
    <script>
        var allowSubmit = true;

$(document).ready(function() {

$('#form1').on('submit', function() {

var commentStr = new String($('#comments').val());

if (commentStr.length < 20) {
                    alert('Your motivation is too short. Please write at least one sentence.');
                    return false;
                }

if (allowSubmit) {
                    allowSubmit = false;
                    $('#button').attr('value', 'Sending now ...');
                    $('#button').attr('disabled', 'disabled');
                    return true;
                } else {
                    return false;
                }
            });

$("#datepicker").datepicker({
                dateFormat: "yy-mm-dd",
                minDate: new Date(<?php echo date("Y", strtotime($sDueDate)); ?>, <?php echo date("m", strtotime($sDueDate)) - 1; ?>, <?php echo date("d", strtotime($sDueDate)); ?>),
                maxDate: new Date(<?php echo date("Y", strtotime('+' . $maxDays . ' days', strtotime($sDueDate))); ?>, <?php echo date("m", strtotime('+' . $maxDays . ' days', strtotime($sDueDate))) - 1; ?>, <?php echo date("d", strtotime('+' . $maxDays . ' days', strtotime($sDueDate))); ?>),
            });
        });
    </script>
<?php
}

if (isset($extensionRequests) && is_array($extensionRequests) && count($extensionRequests) > 0) {
    $studentID = $cceStudentId;
    $assignmentID = $_REQUEST['id'];
    $extensionRequests = $cceUploadedFileService->enrichStudentExtensionRequests(
        $extensionRequests,
        intval($assignmentID),
        intval($studentID)
    );
?>
    <h4>Previous Extension Requests</h4>
<?php
    include($_SERVER['DOCUMENT_ROOT'] . '/php/templates/cesanet/student_assignment_extensions.php');
}

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