Collaboration diagram for ilCronDeleteInactiveUserReminderMail:

Static Public Member Functions
static	removeEntriesFromTableIfLastLoginIsNewer ()

static	checkIfReminderMailShouldBeSend (ilObjUser $user, $reminderTime, $time_frame_for_deletion)

static	flushDataTable ()

static	removeSingleUserFromTable ($usr_id)

Data Fields
const	TABLE_NAME = "usr_cron_mail_reminder"

Static Private Member Functions
static	mailSent ($usr_id)

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

Detailed Description

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

Member Function Documentation

◆ checkIfReminderMailShouldBeSend()

static ilCronDeleteInactiveUserReminderMail::checkIfReminderMailShouldBeSend	(	ilObjUser	$user,
			$reminderTime,
			$time_frame_for_deletion
	)

static

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

    {
        global $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->ts == null) {
            self::sendReminder($user, $reminderTime, $time_frame_for_deletion);
            return true;
        }
        return false;
    }

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

Here is the call graph for this function:

◆ flushDataTable()

static ilCronDeleteInactiveUserReminderMail::flushDataTable ( )

static

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

    {
        global $ilDB;
        $ilDB->manipulate("DELETE FROM " . self::TABLE_NAME);
    }

References $ilDB.

Referenced by ilCronDeleteInactiveUserAccounts\saveCustomSettings().

Here is the caller graph for this function:

◆ mailSent()

static ilCronDeleteInactiveUserReminderMail::mailSent ( $usr_id )

staticprivate

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

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

References $ilDB.

Referenced by sendReminder().

Here is the caller graph for this function:

◆ removeEntriesFromTableIfLastLoginIsNewer()

static ilCronDeleteInactiveUserReminderMail::removeEntriesFromTableIfLastLoginIsNewer ( )

static

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

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

References $ilDB, $query, $res, $row, ilObjUser\_lookupLastLogin(), ilDBConstants\FETCHMODE_OBJECT, removeSingleUserFromTable(), and TABLE_NAME.

Here is the call graph for this function:

◆ removeSingleUserFromTable()

static ilCronDeleteInactiveUserReminderMail::removeSingleUserFromTable ( $usr_id )

static

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

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

References $ilDB, and $query.

Referenced by ilObjUser\delete(), and removeEntriesFromTableIfLastLoginIsNewer().

Here is the caller graph for this function:

◆ sendReminder()

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

staticprivate

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

    {
        include_once 'Services/User/classes/class.ilCronDeleteInactiveUserReminderMailNotification.php';
        $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());
    }