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:

Public Member Functions
	__construct (private ilDBInterface $db)

	removeEntriesFromTableIfLastLoginIsNewer ()

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

	flushDataTable ()

	removeSingleUserFromTable (int $usr_id)

Data Fields
const	TABLE_NAME = "usr_cron_mail_reminder"

Private Member Functions
	persistMailSent (int $usr_id)

	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.

Constructor & Destructor Documentation

◆ __construct()

ilCronDeleteInactiveUserReminderMail::__construct ( private ilDBInterface $db )

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

29 {

30 }

Member Function Documentation

◆ flushDataTable()

ilCronDeleteInactiveUserReminderMail::flushDataTable ( )

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

                                    : void
    {
 
        $this->db->manipulate("DELETE FROM " . self::TABLE_NAME);
    }

◆ persistMailSent()

ilCronDeleteInactiveUserReminderMail::persistMailSent ( int $usr_id )

private

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

                                                 : void
    {
        $this->db->manipulateF(
            "INSERT INTO " . self::TABLE_NAME . " (usr_id, ts) VALUES (%s, %s)",
            [
                "integer",
                "integer"
            ],
            [
                $usr_id,
                time()
            ]
        );
    }

◆ removeEntriesFromTableIfLastLoginIsNewer()

ilCronDeleteInactiveUserReminderMail::removeEntriesFromTableIfLastLoginIsNewer ( )

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

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

References $res, ilObjUser\_lookupLastLogin(), ilDBConstants\FETCHMODE_OBJECT, if, ILIAS\Repository\int(), removeSingleUserFromTable(), and TABLE_NAME.

Here is the call graph for this function:

◆ removeSingleUserFromTable()

ilCronDeleteInactiveUserReminderMail::removeSingleUserFromTable ( int $usr_id )

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

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

Referenced by removeEntriesFromTableIfLastLoginIsNewer().

Here is the caller graph for this function:

◆ sendReminder()

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

private

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

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

Referenced by sendReminderMailIfNeeded().

Here is the caller graph for this function:

◆ sendReminderMailIfNeeded()

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

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

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