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.

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

     {
         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();
         }
     }

Here is the call graph for this function:

Member Function Documentation

◆ checkReminders()

ilExAssignmentReminder::checkReminders ( )

CRON send reminders.

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

References $DIC, $message, $rmd_type, $template_id, $tpl, ilLanguageFactory\_getLanguageOfUser(), ilLink\_getLink(), ilObjUser\_lookupFullname(), ilObjUser\_lookupLogin(), ilObject\_lookupTitle(), getReminders(), ilExAssignment\lookupTitle(), parseGradeReminders(), parsePeerReminders(), parseSubmissionReminders(), sentReminderPlaceholders(), and updateRemindersLastDate().

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

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 641 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.

References $rmd_end.

Referenced by save(), and update().

     {
         return $this->rmd_end;
     }

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.

References $rmd_frequency.

Referenced by save(), and update().

     {
         return $this->rmd_frequency;
     }

Here is the caller graph for this function:

◆ getReminderLastSend()

ilExAssignmentReminder::getReminderLastSend ( )

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

References $rmd_last_send.

Referenced by save(), and update().

     {
         return $this->rmd_last_send;
     }

Here is the caller graph for this function:

◆ getReminderMailTemplate()

ilExAssignmentReminder::getReminderMailTemplate ( )

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

References $rmd_tpl_id.

Referenced by save(), and update().

     {
         return $this->rmd_tpl_id;
     }

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.

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

Referenced by checkReminders().

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

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.

References $rmd_start.

Referenced by save(), and update().

     {
         return $this->rmd_start;
     }

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.

References $rmd_status.

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

     {
         return $this->rmd_status;
     }

Here is the caller graph for this function:

◆ getReminderType()

ilExAssignmentReminder::getReminderType ( )

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

References $rmd_type.

Referenced by ilExAssignmentEditorGUI\saveReminderData().

     {
         return $this->rmd_type;
     }

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.

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

Referenced by read().

     {
         $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"]);
     }

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.

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

Referenced by checkReminders().

     {
         $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.
                 include_once "./Services/Notification/classes/class.ilNotification.php";
 
                 $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;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ parsePeerReminders()

ilExAssignmentReminder::parsePeerReminders ( $a_reminders )

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

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

Referenced by checkReminders().

     {
         $reminders = $a_reminders;
         $users_to_remind = array();
 
         foreach ($reminders as $reminder) {
             $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;
     }

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.

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

Referenced by checkReminders().

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

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.

References initFromDB().

Referenced by __construct().

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

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.

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

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

Here is the call graph for this function:

◆ sentReminderPlaceholders()

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

protected

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

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

Referenced by checkReminders().

     {
         // 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;
     }

Here is the call graph for this function:

Here is the caller 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.

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

     {
         $this->rmd_end = $a_date;
     }

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.

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

     {
         $this->rmd_frequency = $a_num_days;
     }

Here is the caller graph for this function:

◆ setReminderLastSend()

ilExAssignmentReminder::setReminderLastSend ( $a_timestamp )

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

Referenced by initFromDB().

     {
         $this->rmd_last_send = $a_timestamp;
     }

Here is the caller graph for this function:

◆ setReminderMailTemplate()

ilExAssignmentReminder::setReminderMailTemplate ( $a_tpl_id )

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

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

     {
         $this->rmd_tpl_id = $a_tpl_id;
     }

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.

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

     {
         $this->rmd_start = $a_num_days;
     }

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.

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

     {
         $this->rmd_status = $a_status;
     }

Here is the caller graph for this function:

◆ update()

ilExAssignmentReminder::update ( )

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

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

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

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

Referenced by checkReminders().

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