Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date	Action
sendoverdue.php	3.95 KB	-rw-r--r--	2025-03-18 10:09

Rename

<?php

session_start(); // Initialize Session data
ob_start(); // Turn on output buffering

if (!isset($_SERVER['DOCUMENT_ROOT']) || strlen($_SERVER['DOCUMENT_ROOT']) <= 0) {
    $_SERVER['DOCUMENT_ROOT'] = str_replace('/cceadmin/crons', '', getcwd());
}

include_once('../ewcfg7.php');
include_once($_SERVER['DOCUMENT_ROOT'] . '/cesanet/inc_shared.php');

$conni = mysqli_connect(EW_CONN_HOST, EW_CONN_USER, EW_CONN_PASS, EW_CONN_DB);

$sql = "SELECT * FROM CCEStudents WHERE BlockAccess='n' AND Archived=0 "
        . "AND CCEStudentID<>54 "
        . "ORDER BY Surname, FirstName";
$recStudents = mysqli_query($conni, $sql);
while ($rowStudents = mysqli_fetch_assoc($recStudents)) {
    unset($arrOverdue);
    extract($rowStudents);
    $arrOverdue = GetOverdue($rowStudents["CCEStudentID"], $rowStudents["ModulesEnrolled"]);
//    $arrOverdue[] = 634;

if (count($arrOverdue) > 0) {
        foreach ($arrOverdue as $key => $val) {

//            if ($key == 634 && $rowStudents["CCEStudentID"] != 54) {
//                continue;
//            }

$sql = "SELECT * FROM CCEAssignments WHERE CCEAssignmentID=" . $key;
            $recA = mysqli_query($conni, $sql);
            if ($rowA = mysqli_fetch_assoc($recA)) {

$dueDate = new DateTime($rowA['DueDate']);
                $nowDate = new DateTime();
                $numDays = floor(($nowDate->getTimestamp() - $dueDate->getTimestamp()) / (24 * 3600));
                $markNum = 1;

if ($numDays > 1) {
                    $markNum += ($numDays - 1) / 2;
                }

if ($markNum <= 0) {
                    continue;
                }

if ($markNum > 31) {
                    //Skip over long overdue assignments
                    continue;
                }

if ($markNum > 10) {
                    $markNum = 10;
                }

$msg = "Dear " . $KnownAs . " " . $Surname . "\r\n\r\n"
                        . "Please note assignment " . $rowA["AssignmentName"] . " is overdue. "
                        . "Your assignment score is affected by penalties on late submissions, so please submit as soon as possible.\r\n\r\n"
                        . "This assignment was due on: " . $dueDate->format('j F Y') . ".\r\n"
                        . "You have lost " . $markNum . " mark(s).";
                $sSubject = "BCE Assignment Overdue: " . $rowA["RefNum"] . " - " . $rowA["AssignmentName"];

echo $msg . "<br><br>";

$headers = array('From: BCE CESAnet <brenda@cesa.co.za>', 'Bcc: cesa-bce@igotafrica.com');

//                $row["EmailAddress"] = 'otto@saayman.net';
//                SendStudentEmail($rowStudents["CCEStudentID"], $key, 'Overdue', $sSubject);
//                SendStudentEmail(54, $key, 'Overdue', $sSubject);
                maill(
                        $row["EmailAddress"],
                        $sSubject,
                        $msg,
                        null,
                        array('from-name' => 'BCE CESAnet', 'from-address' => 'brenda@cesa.co.za', 'bcc' => array('bce@igotafrica.com'))
                );

$sql = "INSERT 
                    INTO CCEMessages (CCEModuleID, SentByName, SentTo, SentDateTime, MessageSubject, MessageText)
                    VALUES (0, 'System', '" . addslashes($FirstName . " " . $Surname) . "', '" . date("Y-m-d H:i:s") . "', 
                        '" . addslashes($sSubject) . "', '" . addslashes(stripslashes($msg)) . "')";
                mysqli_query($conni, $sql);
                $sql = "INSERT 
                    INTO CCEMessagesSentTo (CCEMessageID, SentType, SentID) 
                    VALUES (" . mysqli_insert_id($conni) . ", 'Student', '" . $CCEStudentID . "')";
                mysqli_query($conni, $sql);
            }
            mysqli_free_result($recA);
        }
    }
}
mysqli_free_result($recStudents);