ilCronDeleteInactiveUserReminderMail Class Reference

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.

      {
    }

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.

Referenced by sendReminder().

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

Here is the caller graph for this function:

removeEntriesFromTableIfLastLoginIsNewer()

ilCronDeleteInactiveUserReminderMail::removeEntriesFromTableIfLastLoginIsNewer

(

)

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

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

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

Here is the call graph for this function:

removeSingleUserFromTable()

ilCronDeleteInactiveUserReminderMail::removeSingleUserFromTable

(

int

$usr_id

)

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

Referenced by removeEntriesFromTableIfLastLoginIsNewer().

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

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.

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

Referenced by sendReminderMailIfNeeded().

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

Here is the call graph for this function:

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.

References $res, ilDBConstants\FETCHMODE_OBJECT, ilObject\getId(), null, and sendReminder().

     : 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;
    }

Here is the call graph for this function:

Field Documentation

TABLE_NAME

const ilCronDeleteInactiveUserReminderMail::TABLE_NAME = "usr_cron_mail_reminder"

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

---

The documentation for this class was generated from the following file:

• components/ILIAS/User/classes/Cron/class.ilCronDeleteInactiveUserReminderMail.php