This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Collaboration diagram for ilExAssignmentReminder:

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

	getReminderType ()

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

	getReminderStatus ()

	setReminderStart (int $a_num_days)

	getReminderStart ()

	setReminderEnd (int $a_date)

	getReminderEnd ()

	setReminderFrequency (int $a_num_days)

	getReminderFrequency ()

	setReminderLastSend (int $a_timestamp)

	getReminderLastSend ()

	setReminderMailTemplate (int $a_tpl_id)

	getReminderMailTemplate ()

	save ()

	update ()

	read ()

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

	parseGradeReminders (array $a_reminders)

	parsePeerReminders (array $a_reminders)

	checkReminders ()

	deleteReminders (int $a_ass_id)

Data Fields
const	SUBMIT_REMINDER = "submit"

const	GRADE_REMINDER = "grade"

const	FEEDBACK_REMINDER = "peer"

Protected Member Functions
	initFromDB (array $a_set)

	sendReminders (array $reminders)

	sentReminderPlaceholders (string $a_message, array $a_reminder_data, string $a_reminder_type)

	updateRemindersLastDate (array $a_reminders)

Protected Attributes
ilDBInterface	$db

ilTree	$tree

bool	$rmd_status = null

int	$rmd_start = 0

int	$rmd_end = 0

int	$rmd_frequency = 0

int	$rmd_last_send = 0

int	$rmd_tpl_id = 0

int	$ass_id = 0

int	$exc_id = 0

string	$rmd_type = ""

ilLogger	$log

ilAccessHandler	$access

Private Attributes
ilMailTemplatePlaceholderResolver	$placeholder_resolver

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning 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; Alexander Killing killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

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

Constructor & Destructor Documentation

◆ __construct()

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

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

      {
        global $DIC;
        $this->db = $DIC->database();
        $this->tree = $DIC->repositoryTree();
        $this->access = $DIC->access();
        $this->log = ilLoggerFactory::getLogger("exc");
        $this->placeholder_resolver = $DIC->mail()->placeholderResolver();
 
        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 $DIC, ILIAS\Repository\access(), ilLoggerFactory\getLogger(), and read().

Here is the call graph for this function:

Member Function Documentation

◆ checkReminders()

ilExAssignmentReminder::checkReminders ( )

Returns: int number of reminders sent

Exceptions

ilExcUnknownAssignmentTypeException
Exception

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

                                    : int
    {
        $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);
 
        return $this->sendReminders($reminders);
    }

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

Here is the call graph for this function:

◆ deleteReminders()

ilExAssignmentReminder::deleteReminders ( int $a_ass_id )

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

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

◆ getReminderEnd()

ilExAssignmentReminder::getReminderEnd ( )

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

                                    : int
    {
        return $this->rmd_end;
    }

References $rmd_end.

Referenced by save(), and update().

Here is the caller graph for this function:

◆ getReminderFrequency()

ilExAssignmentReminder::getReminderFrequency ( )

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

                                          : int
    {
        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 136 of file class.ilExAssignmentReminder.php.

                                         : int
    {
        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 146 of file class.ilExAssignmentReminder.php.

                                             : int
    {
        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 ( string $a_type = "" )

Get reminders available by date/frequence.

Exceptions

Exception

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

                                                     : array
    {
        $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_data[] = $rem;
                }
            }
        }
 
        return $array_data;
    }

Referenced by checkReminders().

Here is the caller graph for this function:

◆ getReminderStart()

ilExAssignmentReminder::getReminderStart ( )

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

                                      : int
    {
        return $this->rmd_start;
    }

References $rmd_start.

Referenced by save(), and update().

Here is the caller graph for this function:

◆ getReminderStatus()

ilExAssignmentReminder::getReminderStatus ( )

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

                                       : ?bool
    {
        return $this->rmd_status;
    }

References $rmd_status.

Referenced by save(), and update().

Here is the caller graph for this function:

◆ getReminderType()

ilExAssignmentReminder::getReminderType ( )

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

                                     : string
    {
        return $this->rmd_type;
    }

References $rmd_type.

◆ initFromDB()

ilExAssignmentReminder::initFromDB ( array $a_set )

protected

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

                                               : void
    {
        $this->setReminderStatus((bool) $a_set["status"]);
        $this->setReminderStart((int) $a_set["start"]);
        $this->setReminderEnd((int) $a_set["end"]);
        $this->setReminderFrequency((int) $a_set["freq"]);
        $this->setReminderLastSend((int) $a_set["last_send"]);
        $this->setReminderMailTemplate((int) $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 ( array $a_reminders )

Exceptions

ilExcUnknownAssignmentTypeException

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

                                                           : array
    {
        $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 $assignment_data) {
                if ($assignment_data["status"] == ilExerciseManagementGUI::GRADE_NOT_GRADED) {
                    //at least there is one submission pending to grade.
                    $has_pending_to_grade = true;
                }
            }
 
            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"]
                                );
                                $users_to_remind[] = $member_data;
                                $unike_usr_id[] = $user_id;
                            }
                        }
                    }
                }
            }
        }
 
        return $users_to_remind;
    }

References $user_id, ilObject\_getAllReferences(), ILIAS\Repository\access(), 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 ( array $a_reminders )

Exceptions

ilExcUnknownAssignmentTypeException

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

                                                          : array
    {
        $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"]
                            );
                            $users_to_remind[] = $member_data;
                        }
                    }
                }
            }
        }
 
        return $users_to_remind;
    }

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

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 187 of file class.ilExAssignmentReminder.php.

                          : void
    {
        $set = $this->db->queryF(
            "SELECT status, start, freq, end, last_send, template_id" .
            " FROM exc_ass_reminders" .
            " WHERE type = %s AND ass_id = %s AND exc_id = %s",
            ["text", "integer", "integer"],
            [$this->rmd_type, $this->ass_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 151 of file class.ilExAssignmentReminder.php.

                          : void
    {
        $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:

◆ sendReminders()

ilExAssignmentReminder::sendReminders ( array $reminders )

protected

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

                                                      : int
    {
        global $DIC;
 
        $tpl = null;
 
        foreach ($reminders as $reminder) {
            $template_id = $reminder['template_id'];
 
            $rmd_type = $reminder["reminder_type"];
            $this->log->debug("Sending reminder type = " . $rmd_type);
 
            //if the template exists (can be deleted via Administration/Mail)
            if ($template_id) {
                $templateService = $DIC->mail()->textTemplates();
                $tpl = $templateService->loadTemplateForId((int) $template_id);
            }
            $subject = "";
            if ($tpl) {
                $this->log->debug("** send reminder WITH template.");
                $subject = $tpl->getSubject();
 
                $placeholder_params = array(
                    "exc_id" => $reminder["exc_id"],
                    "exc_ref" => $reminder["exc_ref"],
                    "ass_id" => $reminder["ass_id"],
                    "member_id" => $reminder["member_id"]
                );
                $message = $this->sentReminderPlaceholders($tpl->getMessage(), $placeholder_params, $rmd_type);
            } else {
                $this->log->debug("** send reminder WITHOUT template.");
 
                $ass_title = ilExAssignment::lookupTitle($reminder["ass_id"]);
                $exc_title = ilObjExercise::_lookupTitle($reminder["exc_id"]);
 
                // use language of recipient to compose message
                $ulng = ilLanguageFactory::_getLanguageOfUser($reminder["member_id"]);
                $ulng->loadLanguageModule('exc');
 
                $link = ilLink::_getLink($reminder["exc_ref"], "exc", array(), "_" . $reminder["ass_id"]);
 
                $message = sprintf($ulng->txt('exc_reminder_salutation'), ilObjUser::_lookupFullname($reminder["member_id"])) . "\n\n";
 
                $this->log->debug("send: MAIL TYPE = " . $rmd_type . ", user: " . $reminder["member_id"] . ", ass: " . $reminder["ass_id"]);
 
                switch ($rmd_type) {
                    case "submit":
                        $subject = sprintf($ulng->txt('exc_reminder_submit_subject'), $ass_title);
                        $message .= $ulng->txt('exc_reminder_submit_body') . ":\n\n";
                        break;
 
                    case "grade":
                        $subject = sprintf($ulng->txt('exc_reminder_grade_subject'), $ass_title);
                        $message .= $ulng->txt('exc_reminder_grade_body') . ":\n\n";
                        break;
 
                    case "peer":
                        $subject = sprintf($ulng->txt('exc_reminder_peer_subject'), $ass_title);
                        $message .= $ulng->txt('exc_reminder_peer_body') . ":\n\n";
                        break;
                }
 
                $message .= $ulng->txt('obj_exc') . ": " . $exc_title . "\n";
                $message .= $ulng->txt('obj_ass') . ": " . $ass_title . "\n";
                $message .= "\n" . $ulng->txt('exc_reminder_link') . ": " . $link;
            }
            $mail_obj = new ilMail(ANONYMOUS_USER_ID);
            $mail_obj->appendInstallationSignature(true);
            $mail_obj->enqueue(
                ilObjUser::_lookupLogin($reminder["member_id"]),
                "",
                "",
                $subject,
                $message,
                array()
            );
        }
 
        $this->updateRemindersLastDate($reminders);
        return count($reminders);
    }

References $DIC, $message, $rmd_type, ilLanguageFactory\_getLanguageOfUser(), ilObjUser\_lookupFullname(), ilObjUser\_lookupLogin(), ilObject\_lookupTitle(), ANONYMOUS_USER_ID, ilExAssignment\lookupTitle(), sentReminderPlaceholders(), and updateRemindersLastDate().

Referenced by checkReminders().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ sentReminderPlaceholders()

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

protected

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

     : string {
        // 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"]);
 
            $a_message = $this->placeholder_resolver->resolve($context, $a_message, $user, $a_reminder_data);
        } catch (Exception $e) {
            ilLoggerFactory::getLogger('mail')->error(__METHOD__ . ' has been called with invalid context.');
        }
 
        return $a_message;
    }

References $context, exit, FEEDBACK_REMINDER, ilMailTemplateContextService\getTemplateContextById(), GRADE_REMINDER, ilExcMailTemplateGradeReminderContext\ID, ilExcMailTemplatePeerReminderContext\ID, ilExcMailTemplateSubmitReminderContext\ID, and SUBMIT_REMINDER.

Referenced by sendReminders().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ setReminderEnd()

ilExAssignmentReminder::setReminderEnd ( int $a_date )

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

                                               : void
    {
        $this->rmd_end = $a_date;
    }

Referenced by initFromDB().

Here is the caller graph for this function:

◆ setReminderFrequency()

ilExAssignmentReminder::setReminderFrequency ( int $a_num_days )

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

                                                         : void
    {
        $this->rmd_frequency = $a_num_days;
    }

Referenced by initFromDB().

Here is the caller graph for this function:

◆ setReminderLastSend()

ilExAssignmentReminder::setReminderLastSend ( int $a_timestamp )

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

                                                         : void
    {
        $this->rmd_last_send = $a_timestamp;
    }

Referenced by initFromDB().

Here is the caller graph for this function:

◆ setReminderMailTemplate()

ilExAssignmentReminder::setReminderMailTemplate ( int $a_tpl_id )

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

                                                          : void
    {
        $this->rmd_tpl_id = $a_tpl_id;
    }

Referenced by initFromDB().

Here is the caller graph for this function:

◆ setReminderStart()

ilExAssignmentReminder::setReminderStart ( int $a_num_days )

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

                                                     : void
    {
        $this->rmd_start = $a_num_days;
    }

Referenced by initFromDB().

Here is the caller graph for this function:

◆ setReminderStatus()

ilExAssignmentReminder::setReminderStatus ( ?bool $a_status )

Set reminder for users without submission.

Parameters

bool $a_status activated?

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

                                                      : void
    {
        $this->rmd_status = $a_status;
    }

Referenced by initFromDB().

Here is the caller graph for this function:

◆ update()

ilExAssignmentReminder::update ( )

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

                            : void
    {
        $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 ( array $a_reminders )

protected

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

                                                                  : void
    {
        $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);
        }
    }