TODO: import/export reminder data with the exercise/assignment. More...

Collaboration diagram for ilExAssignmentReminder:

Public Member Functions
	__construct ($a_exc_id="", $a_ass_id="", $a_type="")

	getReminderType ()

	setReminderStatus ($a_status)
	Set reminder for users without submission. More...

	getReminderStatus ()
	Get the reminder status. More...

	setReminderStart ($a_num_days)
	Set num days before the deadline to start sending notifications. More...

	getReminderStart ()
	Get num days before the deadline to start sending notifications. More...

	setReminderEnd ($a_date)
	Set the ending of the reminder. More...

	getReminderEnd ()
	get the ending of the reminder More...

	setReminderFrequency ($a_num_days)
	Set frequency in days. More...

	getReminderFrequency ()
	get submit reminder frequency in days. More...

	setReminderLastSend ($a_timestamp)

	getReminderLastSend ()

	setReminderMailTemplate ($a_tpl_id)

	getReminderMailTemplate ()

	save ()

	update ()

	read ()

	getReminders ($a_type="")
	Get reminders available by date/frequence. More...

	parseSubmissionReminders ($a_reminders)
	Filter the reminders by object(crs,grp) by active status and if have members. More...

	parseGradeReminders ($a_reminders)

	parsePeerReminders ($a_reminders)

	checkReminders ()
	CRON send reminders. More...

	deleteReminders ($a_ass_id)
	remove reminders from DB when the parent assignment is deleted. More...

Data Fields
const	SUBMIT_REMINDER = "submit"

const	GRADE_REMINDER = "grade"

const	FEEDBACK_REMINDER = "peer"

Protected Member Functions
	initFromDB (array $a_set)
	Import DB record. More...

	sentReminderPlaceholders ($a_message, $a_reminder_data, $a_reminder_type)

	updateRemindersLastDate ($a_reminders)
	Update reminders last_send value with the current timestamp. More...

Protected Attributes
	$db

	$tree

	$now

	$rmd_status

	$rmd_start

	$rmd_end

	$rmd_frequency

	$rmd_last_send

	$rmd_tpl_id

	$ass_id

	$exc_id

	$rmd_type

	$log

Detailed Description

TODO: import/export reminder data with the exercise/assignment.

TODO: Delete reminders from exc_ass_reminders when the assignment is deleted.

Exercise Assignment Reminders

Author: Jesús López lopez.nosp@m.@lei.nosp@m.fos.c.nosp@m.om

Definition at line 14 of file class.ilExAssignmentReminder.php.

Constructor & Destructor Documentation

◆ __construct()

ilExAssignmentReminder::__construct	(	$a_exc_id = `""`,
		$a_ass_id = `""`,
		$a_type = `""`
	)

Definition at line 38 of file class.ilExAssignmentReminder.php.

    {
        global $DIC;
        $this->db = $DIC->database();
        $this->tree = $DIC->repositoryTree();
        $this->access = $DIC->access();
        $this->log = ilLoggerFactory::getLogger("exc");
 
        if ($a_ass_id) {
            $this->ass_id = $a_ass_id;
        }
        if ($a_exc_id) {
            $this->exc_id = $a_exc_id;
        }
        if ($a_type) {
            $this->rmd_type = $a_type;
        }
        if ($a_exc_id and $a_ass_id and $a_type) {
            $this->read();
        }
    }

References $a_type, $DIC, ilLoggerFactory\getLogger(), and read().

Here is the call graph for this function:

Member Function Documentation

◆ checkReminders()

ilExAssignmentReminder::checkReminders ( )

CRON send reminders.

Definition at line 469 of file class.ilExAssignmentReminder.php.

    {
        $submit_reminders = $this->getReminders(self::SUBMIT_REMINDER);
        $parsed_submit_reminders = $this->parseSubmissionReminders($submit_reminders);
 
        $grade_reminders = $this->getReminders(self::GRADE_REMINDER);
        $parsed_grade_reminders = $this->parseGradeReminders($grade_reminders);
 
        $peer_reminders = $this->getReminders(self::FEEDBACK_REMINDER);
        $parsed_peer_reminders = $this->parsePeerReminders($peer_reminders);
 
        /* //DEBUG
        $this->log->debug("ALL SUBMIT REMINDERS");
        $this->log->dump($submit_reminders);
        $this->log->debug("PARSED SUBMIT REMINDERS");
        $this->log->dump($parsed_submit_reminders);
        $this->log->debug("GRADE REMINDERS ARRAY");
        $this->log->dump($grade_reminders);
        $this->log->debug("PARSED GRADE REMINDERS");
        $this->log->dump($parsed_grade_reminders);
        $this->log->debug("PEER REMINDERS ARRAY");
        $this->log->dump($peer_reminders);
        $this->log->debug("PARSED PEER REMINDERS");
        $this->log->dump($parsed_peer_reminders);
        */
 
        $reminders = array_merge($parsed_submit_reminders, $parsed_grade_reminders, $parsed_peer_reminders);
 
        $reminders_sent = $this->sendReminders($reminders);
 
        return $reminders_sent;
    }

References getReminders(), parseGradeReminders(), parsePeerReminders(), and parseSubmissionReminders().

Here is the call graph for this function:

◆ deleteReminders()

ilExAssignmentReminder::deleteReminders ( $a_ass_id )

remove reminders from DB when the parent assignment is deleted.

Parameters

$a_ass_id

Definition at line 642 of file class.ilExAssignmentReminder.php.

    {
        $sql = "DELETE FROM exc_ass_reminders" .
            " WHERE ass_id = " . $a_ass_id;
 
        $this->db->manipulate($sql);
    }

◆ getReminderEnd()

ilExAssignmentReminder::getReminderEnd ( )

get the ending of the reminder

Returns: mixed

Definition at line 114 of file class.ilExAssignmentReminder.php.

    {
        return $this->rmd_end;
    }

References $rmd_end.

Referenced by save(), and update().

Here is the caller graph for this function:

◆ getReminderFrequency()

ilExAssignmentReminder::getReminderFrequency ( )

get submit reminder frequency in days.

Returns: mixed

Definition at line 132 of file class.ilExAssignmentReminder.php.

    {
        return $this->rmd_frequency;
    }

References $rmd_frequency.

Referenced by save(), and update().

Here is the caller graph for this function:

◆ getReminderLastSend()

ilExAssignmentReminder::getReminderLastSend ( )

Definition at line 142 of file class.ilExAssignmentReminder.php.

    {
        return $this->rmd_last_send;
    }

References $rmd_last_send.

Referenced by save(), and update().

Here is the caller graph for this function:

◆ getReminderMailTemplate()

ilExAssignmentReminder::getReminderMailTemplate ( )

Definition at line 152 of file class.ilExAssignmentReminder.php.

    {
        return $this->rmd_tpl_id;
    }

References $rmd_tpl_id.

Referenced by save(), and update().

Here is the caller graph for this function:

◆ getReminders()

ilExAssignmentReminder::getReminders ( $a_type = "" )

Get reminders available by date/frequence.

Parameters

$a_type string reminder type

Returns: mixed

Definition at line 228 of file class.ilExAssignmentReminder.php.

    {
        $now = time();
        $today = date("Y-m-d");
 
        $this->log->debug("Get reminders $a_type.");
 
        //remove time from the timestamp (86400 = 24h)
        //$now = floor($now/86400)*86400;
        $and_type = "";
        if ($a_type == self::SUBMIT_REMINDER || $a_type == self::GRADE_REMINDER || $a_type == self::FEEDBACK_REMINDER) {
            $and_type = " AND type = '" . $a_type . "'";
        }
 
        $query = "SELECT last_send_day, ass_id, exc_id, status, start, freq, end, type, last_send, template_id" .
            " FROM exc_ass_reminders" .
            " WHERE status = 1" .
            " AND start <= " . $now .
            " AND end > " . ($now - 86400) .
            $and_type;
 
 
        $result = $this->db->query($query);
 
        $array_data = array();
        while ($rec = $this->db->fetchAssoc($result)) {
            $rem = array(
                "ass_id" => $rec["ass_id"],
                "exc_id" => $rec["exc_id"],
                "start" => $rec["start"],
                "end" => $rec["end"],
                "freq" => $rec["freq"],
                "type" => $rec["type"],
                "last_send" => $rec["last_send"],
                "last_send_day" => $rec["last_send_day"],
                "template_id" => $rec["template_id"]
            );
 
            $end_day = date("Y-m-d", $rec["end"]);
 
            //frequency
            $next_send = "";
            if ($rec["last_send_day"] != "") {
                $date = new DateTime($rec["last_send_day"]);
                $date->add(new DateInterval('P' . $rec["freq"] . 'D'));
                $next_send = $date->format('Y-m-d');
            }
            $this->log->debug("ass: " . $rec["ass_id"] . ", last send: " . $rec["last_send_day"] .
                ", freq: " . $rec["freq"] . ", end_day: $end_day, today: " . $today . ", next send: $next_send");
            if ($rec["last_send_day"] == "" || $next_send <= $today) {
                if ($end_day >= $today) {
                    $this->log->debug("included");
                    array_push($array_data, $rem);
                }
            }
        }
 
        return $array_data;
    }

References $a_type, $now, $query, and $result.

Referenced by checkReminders().

Here is the caller graph for this function:

◆ getReminderStart()

ilExAssignmentReminder::getReminderStart ( )

Get num days before the deadline to start sending notifications.

Returns: mixed

Definition at line 96 of file class.ilExAssignmentReminder.php.

    {
        return $this->rmd_start;
    }

References $rmd_start.

Referenced by save(), and update().

Here is the caller graph for this function:

◆ getReminderStatus()

ilExAssignmentReminder::getReminderStatus ( )

Get the reminder status.

Returns: mixed

Definition at line 78 of file class.ilExAssignmentReminder.php.

    {
        return $this->rmd_status;
    }

References $rmd_status.

Referenced by save(), ilExAssignmentEditorGUI\saveReminderData(), and update().

Here is the caller graph for this function:

◆ getReminderType()

ilExAssignmentReminder::getReminderType ( )

Definition at line 60 of file class.ilExAssignmentReminder.php.

    {
        return $this->rmd_type;
    }

References $rmd_type.

Referenced by ilExAssignmentEditorGUI\saveReminderData().

Here is the caller graph for this function:

◆ initFromDB()

ilExAssignmentReminder::initFromDB ( array $a_set )

protected

Import DB record.

Parameters

array $a_set

Definition at line 211 of file class.ilExAssignmentReminder.php.

    {
        $this->setReminderStatus($a_set["status"]);
        $this->setReminderStart($a_set["start"]);
        $this->setReminderEnd($a_set["end"]);
        $this->setReminderFrequency($a_set["freq"]);
        $this->setReminderLastSend($a_set["last_send"]);
        $this->setReminderMailTemplate($a_set["template_id"]);
    }

References setReminderEnd(), setReminderFrequency(), setReminderLastSend(), setReminderMailTemplate(), setReminderStart(), and setReminderStatus().

Referenced by read().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ parseGradeReminders()

ilExAssignmentReminder::parseGradeReminders ( $a_reminders )

Definition at line 369 of file class.ilExAssignmentReminder.php.

    {
        $reminders = $a_reminders;
        $users_to_remind = array();
 
        $has_pending_to_grade = false;
 
        foreach ($reminders as $rem) {
            //$this->log->debug("---- parse grade reminder with values -> ",$rem);
            $ass_obj = new ilExAssignment($rem["ass_id"]);
            $members_data = $ass_obj->getMemberListData();
 
            //$this->log->debug("--- get members list data  => ",$members_data);
            foreach ($members_data as $member_id => $assignment_data) {
                if ($assignment_data["status"] == ilExerciseManagementGUI::GRADE_NOT_GRADED) {
                    //at least there is one submission pending to grade.
                    $has_pending_to_grade = true;
                    continue;
                }
            }
 
            /* //DEBUG
            if($has_pending_to_grade){
                $this->log->debug("SOMEONE HAS TO BE GRADED");
            } else {
                $this->log->debug("There is nothing to Grade");
            }
            */
 
            if ($has_pending_to_grade) {
                //get tutor of this exercise.
                $users = ilNotification::getNotificationsForObject(ilNotification::TYPE_EXERCISE_SUBMISSION, $rem["exc_id"]);
 
                foreach ($users as $user_id) {
                    $exc_refs = ilObject::_getAllReferences($rem["exc_id"]);
                    $unike_usr_id = array();
                    foreach ($exc_refs as $exc_ref) {
                        if ($this->access->checkAccessOfUser($user_id, "write", "", $exc_ref)) {
                            if (!in_array($user_id, $unike_usr_id)) {
                                $member_data = array(
                                    "exc_id" => $rem["exc_id"],
                                    "exc_ref" => $exc_ref,
                                    "ass_id" => $rem["ass_id"],
                                    "member_id" => $user_id,
                                    "reminder_type" => $rem["type"],
                                    "template_id" => $rem["template_id"]
                                );
                                array_push($users_to_remind, $member_data);
                                array_push($unike_usr_id, $user_id);
                            }
                        }
                    }
                }
            }
        }
 
        return $users_to_remind;
    }

References ilObject\_getAllReferences(), ilNotification\getNotificationsForObject(), ilExerciseManagementGUI\GRADE_NOT_GRADED, and ilNotification\TYPE_EXERCISE_SUBMISSION.

Referenced by checkReminders().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ parsePeerReminders()

ilExAssignmentReminder::parsePeerReminders ( $a_reminders )

Definition at line 428 of file class.ilExAssignmentReminder.php.

    {
        $reminders = $a_reminders;
        $users_to_remind = array();
 
        $this->log->debug("Peer Reminders: " . count($a_reminders));
 
        foreach ($reminders as $reminder) {
            $this->log->debug("Init peer review: " . $reminder["ass_id"]);
            $pr = new ilExPeerReview(new ilExAssignment($reminder["ass_id"]));
            $pr->initPeerReviews();
            $giver_ids = array_unique(ilExPeerReview::lookupGiversWithPendingFeedback($reminder["ass_id"]));
            foreach ($giver_ids as $giver_id) {
                $state = ilExcAssMemberState::getInstanceByIds($reminder["ass_id"], $giver_id);
                $days_diff = (($state->getPeerReviewDeadline() - time()) / (60 * 60 * 24));
 
                if ($state->isPeerReviewAllowed() && $days_diff < $reminder["start"]) {
                    $exc_refs = ilObject::_getAllReferences($reminder["exc_id"]);
                    foreach ($exc_refs as $exc_ref) {
                        if ($this->access->checkAccessOfUser($giver_id, "read", "", $exc_ref)) {
                            $member_data = array(
                                "exc_id" => $reminder["exc_id"],
                                "exc_ref" => $exc_ref,
                                "ass_id" => $reminder["ass_id"],
                                "member_id" => $giver_id,
                                "reminder_type" => $reminder["type"],
                                "template_id" => $reminder["template_id"]
                            );
                            array_push($users_to_remind, $member_data);
                        }
                    }
                }
            }
        }
 
        return $users_to_remind;
    }

References ilObject\_getAllReferences(), ilExcAssMemberState\getInstanceByIds(), and ilExPeerReview\lookupGiversWithPendingFeedback().

Referenced by checkReminders().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ parseSubmissionReminders()

ilExAssignmentReminder::parseSubmissionReminders ( $a_reminders )

Filter the reminders by object(crs,grp) by active status and if have members.

Parameters

$a_reminders

Returns: array

Definition at line 294 of file class.ilExAssignmentReminder.php.

    {
        $reminders = $a_reminders;
        $users_to_remind = array();
 
        foreach ($reminders as $rem) {
            $ass_id = $rem["ass_id"];
            $ass_obj = new ilExAssignment($ass_id);
 
            $exc_id = $rem["exc_id"];
 
            $exc_refs = ilObject::_getAllReferences($exc_id);
            foreach ($exc_refs as $exc_ref) {
 
                // check if we have an upper course
                if ($course_ref_id = $this->tree->checkForParentType($exc_ref, 'crs')) {
                    $obj = new ilObjCourse($course_ref_id);
                    $participants_class = "ilCourseParticipants";
                    $parent_ref_id = $course_ref_id;
                    $parent_obj_type = 'crs';
 
                // check if we have an upper group
                } elseif ($group_ref_id = $parent_ref_id = $this->tree->checkForParentType($exc_ref, 'grp')) {
                    $obj = new ilObjGroup($group_ref_id);
                    $participants_class = "ilGroupParticipants";
                    $parent_ref_id = $group_ref_id;
                    $parent_obj_type = 'grp';
                } else {
                    continue;
                }
 
                // get participants
                $parent_obj_id = $obj->getId();
                $participants_ids = $participants_class::getInstance($parent_ref_id)->getMembers();
 
                foreach ($participants_ids as $member_id) {
                    $this->log->debug("submission reminder: ass: $ass_id, member: $member_id.");
 
                    // check read permission
                    if ($this->access->checkAccessOfUser($member_id, "read", "", $exc_ref)) {
                        $state = ilExcAssMemberState::getInstanceByIds($ass_id, $member_id);
 
                        $deadline_day = date("Y-m-d", $state->getOfficialDeadline());
                        $today = date("Y-m-d");
                        $date = new DateTime($deadline_day);
                        $date->sub(new DateInterval('P' . $rem["start"] . 'D'));
                        $send_from = $date->format('Y-m-d');
                        $this->log->debug("today: $today, send from: $send_from, start: " . $rem["start"] . ", submission allowed: " . $state->isSubmissionAllowed());
 
                        // check if user can submit and difference in days is smaller than reminder start
                        if ($state->isSubmissionAllowed() && $send_from <= $today) {
                            $submission = new ilExSubmission($ass_obj, $member_id);
 
                            // check if user has submitted anything
                            if (!$submission->getLastSubmission()) {
                                $member_data = array(
                                    "parent_type" => $parent_obj_type,
                                    "parent_id" => $parent_obj_id,
                                    "exc_id" => $exc_id,
                                    "exc_ref" => $exc_ref,
                                    "ass_id" => $ass_id,
                                    "member_id" => $member_id,
                                    "reminder_type" => $rem["type"],
                                    "template_id" => $rem["template_id"]
                                );
                                array_push($users_to_remind, $member_data);
                            }
                        }
                    }
                }
            }
        }
        return $users_to_remind;
    }

References $ass_id, $exc_id, ilObject\_getAllReferences(), and ilExcAssMemberState\getInstanceByIds().

Referenced by checkReminders().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ read()

ilExAssignmentReminder::read ( )

Definition at line 193 of file class.ilExAssignmentReminder.php.

    {
        $set = $this->db->query("SELECT status, start, freq, end, last_send, template_id" .
            " FROM exc_ass_reminders" .
            " WHERE type ='" . $this->rmd_type . "'" .
            " AND ass_id = " . $this->ass_id .
            " AND exc_id = " . $this->exc_id);
 
        $rec = $this->db->fetchAssoc($set);
        if (is_array($rec)) {
            $this->initFromDB($rec);
        }
    }

References initFromDB().

Referenced by __construct().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ save()

ilExAssignmentReminder::save ( )

Definition at line 157 of file class.ilExAssignmentReminder.php.

    {
        $this->db->insert("exc_ass_reminders", array(
            "type" => array("text", $this->rmd_type),
            "ass_id" => array("integer", $this->ass_id),
            "exc_id" => array("integer", $this->exc_id),
            "status" => array("integer", $this->getReminderStatus()),
            "start" => array("integer", $this->getReminderStart()),
            "end" => array("integer", $this->getReminderEnd()),
            "freq" => array("integer", $this->getReminderFrequency()),
            "last_send" => array("integer", $this->getReminderLastSend()),
            "template_id" => array("integer", $this->getReminderMailTemplate())
        ));
    }

References getReminderEnd(), getReminderFrequency(), getReminderLastSend(), getReminderMailTemplate(), getReminderStart(), and getReminderStatus().

Here is the call graph for this function:

◆ sentReminderPlaceholders()

ilExAssignmentReminder::sentReminderPlaceholders	(	$a_message,
		$a_reminder_data,
		$a_reminder_type
	)

protected

Definition at line 590 of file class.ilExAssignmentReminder.php.

    {
        // see ilMail::replacePlaceholders()
        try {
            switch ($a_reminder_type) {
                case \ilExAssignmentReminder::SUBMIT_REMINDER:
                    $context = \ilMailTemplateContextService::getTemplateContextById(ilExcMailTemplateSubmitReminderContext::ID);
                    break;
                case \ilExAssignmentReminder::GRADE_REMINDER:
                    $context = \ilMailTemplateContextService::getTemplateContextById(ilExcMailTemplateGradeReminderContext::ID);
                    break;
                case \ilExAssignmentReminder::FEEDBACK_REMINDER:
                    $context = \ilMailTemplateContextService::getTemplateContextById(ilExcMailTemplatePeerReminderContext::ID);
                    break;
                default:
                    exit();
            }
 
            $user = new \ilObjUser($a_reminder_data["member_id"]);
 
            $processor = new \ilMailTemplatePlaceholderResolver($context, $a_message);
            $a_message = $processor->resolve($user, $a_reminder_data);
        } catch (\Exception $e) {
            \ilLoggerFactory::getLogger('mail')->error(__METHOD__ . ' has been called with invalid context.');
        }
 
        return $a_message;
    }

References $context, Vendor\Package\$e, exit, ilLoggerFactory\getLogger(), ilMailTemplateContextService\getTemplateContextById(), ilExcMailTemplateGradeReminderContext\ID, ilExcMailTemplatePeerReminderContext\ID, and ilExcMailTemplateSubmitReminderContext\ID.

Here is the call graph for this function:

◆ setReminderEnd()

ilExAssignmentReminder::setReminderEnd ( $a_date )

Set the ending of the reminder.

Parameters

$a_date

Definition at line 105 of file class.ilExAssignmentReminder.php.

    {
        $this->rmd_end = $a_date;
    }

Referenced by initFromDB(), and ilExAssignmentEditorGUI\saveReminderData().

Here is the caller graph for this function:

◆ setReminderFrequency()

ilExAssignmentReminder::setReminderFrequency ( $a_num_days )

Set frequency in days.

Parameters

$a_num_days

Definition at line 123 of file class.ilExAssignmentReminder.php.

    {
        $this->rmd_frequency = $a_num_days;
    }

Referenced by initFromDB(), and ilExAssignmentEditorGUI\saveReminderData().

Here is the caller graph for this function:

◆ setReminderLastSend()

ilExAssignmentReminder::setReminderLastSend ( $a_timestamp )

Definition at line 137 of file class.ilExAssignmentReminder.php.

    {
        $this->rmd_last_send = $a_timestamp;
    }

Referenced by initFromDB().

Here is the caller graph for this function:

◆ setReminderMailTemplate()

ilExAssignmentReminder::setReminderMailTemplate ( $a_tpl_id )

Definition at line 147 of file class.ilExAssignmentReminder.php.

    {
        $this->rmd_tpl_id = $a_tpl_id;
    }

Referenced by initFromDB(), and ilExAssignmentEditorGUI\saveReminderData().

Here is the caller graph for this function:

◆ setReminderStart()

ilExAssignmentReminder::setReminderStart ( $a_num_days )

Set num days before the deadline to start sending notifications.

Parameters

$a_num_days

Definition at line 87 of file class.ilExAssignmentReminder.php.

    {
        $this->rmd_start = $a_num_days;
    }

Referenced by initFromDB(), and ilExAssignmentEditorGUI\saveReminderData().

Here is the caller graph for this function:

◆ setReminderStatus()

ilExAssignmentReminder::setReminderStatus ( $a_status )

Set reminder for users without submission.

Parameters

$a_status

Definition at line 69 of file class.ilExAssignmentReminder.php.

    {
        $this->rmd_status = $a_status;
    }

Referenced by initFromDB(), and ilExAssignmentEditorGUI\saveReminderData().

Here is the caller graph for this function:

◆ update()

ilExAssignmentReminder::update ( )

Definition at line 172 of file class.ilExAssignmentReminder.php.

    {
        $this->db->update(
            "exc_ass_reminders",
            array(
            "status" => array("integer", $this->getReminderStatus()),
            "start" => array("integer", $this->getReminderStart()),
            "end" => array("integer", $this->getReminderEnd()),
            "freq" => array("integer", $this->getReminderFrequency()),
            "last_send" => array("integer", $this->getReminderLastSend()),
            "template_id" => array("integer", $this->getReminderMailTemplate())
        ),
            array(
            "type" => array("text", $this->rmd_type),
            "exc_id" => array("integer", $this->exc_id),
            "ass_id" => array("integer", $this->ass_id)
        )
        );
    }

References getReminderEnd(), getReminderFrequency(), getReminderLastSend(), getReminderMailTemplate(), getReminderStart(), and getReminderStatus().

Here is the call graph for this function:

◆ updateRemindersLastDate()

ilExAssignmentReminder::updateRemindersLastDate ( $a_reminders )

protected

Update reminders last_send value with the current timestamp.

Parameters

$a_reminders

Definition at line 623 of file class.ilExAssignmentReminder.php.

    {
        $today = date("Y-m-d");
        foreach ($a_reminders as $reminder) {
            $sql = "UPDATE exc_ass_reminders" .
                " SET last_send = " . $this->db->quote(time(), 'integer') .
                " , last_send_day = " . $this->db->quote($today, 'date') .
                " WHERE type = " . $this->db->quote($reminder["reminder_type"], 'text') .
                " AND ass_id = " . $this->db->quote($reminder["ass_id"], 'integer') .
                " AND exc_id = " . $this->db->quote($reminder["exc_id"], 'integer');
 
            $this->db->manipulate($sql);
        }
    }