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

Collaboration diagram for ilCronDeleteInactiveUserReminderMail:

Static Public Member Functions
static	removeEntriesFromTableIfLastLoginIsNewer ()

static	sendReminderMailIfNeeded (ilObjUser $user, int $reminderTime, int $time_frame_for_deletion)

static	flushDataTable ()

static	removeSingleUserFromTable (int $usr_id)

Data Fields
const	TABLE_NAME = "usr_cron_mail_reminder"

Static Private Member Functions
static	mailSent (int $usr_id)

static	sendReminder (ilObjUser $user, int $reminderTime, int $time_frame_for_deletion)

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 This checks if a mail has to be send after a certain INACTIVITY period

Author: Guido Vollbach gvoll.nosp@m.bach.nosp@m.@data.nosp@m.bay..nosp@m.de

Definition at line 23 of file class.ilCronDeleteInactiveUserReminderMail.php.

Member Function Documentation

◆ flushDataTable()

static ilCronDeleteInactiveUserReminderMail::flushDataTable ( )

static

Definition at line 103 of file class.ilCronDeleteInactiveUserReminderMail.php.

References $DIC, and $ilDB.

Referenced by ilCronDeleteInactiveUserAccounts\saveCustomSettings().

                                            : void
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         $ilDB->manipulate("DELETE FROM " . self::TABLE_NAME);
     }

Here is the caller graph for this function:

◆ mailSent()

static ilCronDeleteInactiveUserReminderMail::mailSent ( int $usr_id )

staticprivate

Definition at line 27 of file class.ilCronDeleteInactiveUserReminderMail.php.

References $DIC, and $ilDB.

                                                  : void
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         $ilDB->manipulateF(
             "INSERT INTO " . self::TABLE_NAME . " (usr_id, ts) VALUES (%s, %s)",
             array(
                 "integer",
                 "integer"
             ),
             array(
                 $usr_id,
                 time()
             )
         );
     }

◆ removeEntriesFromTableIfLastLoginIsNewer()

static ilCronDeleteInactiveUserReminderMail::removeEntriesFromTableIfLastLoginIsNewer ( )

static

Definition at line 63 of file class.ilCronDeleteInactiveUserReminderMail.php.

References $DIC, $ilDB, $query, $res, ilObjUser\_lookupLastLogin(), ilDBConstants\FETCHMODE_OBJECT, if, and ILIAS\Repository\int().

Referenced by ilCronDeleteInactiveUserAccounts\hasCustomSettings().

                                                                      : void
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         $query = "SELECT usr_id,ts FROM " . self::TABLE_NAME;
         $res = $ilDB->queryF($query, array(
             'integer',
             'integer'
         ), array(
             'usr_id',
             'ts'
         ));
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $lastLoginUnixtime = strtotime(ilObjUser::_lookupLastLogin($row->usr_id));
             $lastReminderSent = (int) $row->ts;
             if ($lastLoginUnixtime >= $lastReminderSent) {
                 self::removeSingleUserFromTable($row->usr_id);
             }
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ removeSingleUserFromTable()

static ilCronDeleteInactiveUserReminderMail::removeSingleUserFromTable ( int $usr_id )

static

Definition at line 111 of file class.ilCronDeleteInactiveUserReminderMail.php.

References $DIC, $ilDB, and $query.

Referenced by ilObjUser\delete().

                                                                  : void
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         $query = "DELETE FROM " . self::TABLE_NAME . " WHERE usr_id = %s";
         $ilDB->manipulateF($query, array('integer'), array($usr_id));
     }

Here is the caller graph for this function:

◆ sendReminder()

static ilCronDeleteInactiveUserReminderMail::sendReminder	(	ilObjUser	$user,
		int	$reminderTime,
		int	$time_frame_for_deletion
	)

staticprivate

Definition at line 45 of file class.ilCronDeleteInactiveUserReminderMail.php.

References ilUtil\_getHttpPath(), and ilObject\getId().

      : void {
         $mail = new ilCronDeleteInactiveUserReminderMailNotification();
         $mail->setRecipients(array($user));
         $mail->setAdditionalInformation(
             array(
                  "www" => ilUtil::_getHttpPath(),
                  "days" => $reminderTime,
                  "date" => $time_frame_for_deletion
              )
         );
         $mail->send();
         self::mailSent($user->getId());
     }

Here is the call graph for this function:

◆ sendReminderMailIfNeeded()

static ilCronDeleteInactiveUserReminderMail::sendReminderMailIfNeeded	(	ilObjUser	$user,
		int	$reminderTime,
		int	$time_frame_for_deletion
	)

static

Definition at line 85 of file class.ilCronDeleteInactiveUserReminderMail.php.

References $DIC, $ilDB, $query, $res, ilDBConstants\FETCHMODE_OBJECT, and ilObject\getId().

Referenced by ilCronDeleteInactiveUserAccounts\hasCustomSettings().

      : bool {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         $query = "SELECT ts FROM " . self::TABLE_NAME . " WHERE usr_id = %s";
         $res = $ilDB->queryF($query, array('integer'), array($user->getId()));
         $row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
         if ($row === false || $row->ts === null) {
             self::sendReminder($user, $reminderTime, $time_frame_for_deletion);
             return true;
         }
         return false;
     }