ilCronDeleteInactiveUserReminderMail Class Reference

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"

Private Member Functions
	mailSent ($usr_id)

Static Private Member Functions
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 69 of file class.ilCronDeleteInactiveUserReminderMail.php.

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

Referenced by ilCronDeleteInactiveUserAccounts\hasCustomSettings().

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

Here is the call graph for this function:

Here is the caller graph for this function:

flushDataTable()

static ilCronDeleteInactiveUserReminderMail::flushDataTable ( )

static

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

References $ilDB.

Referenced by ilCronDeleteInactiveUserAccounts\saveCustomSettings().

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

Here is the caller graph for this function:

mailSent()

ilCronDeleteInactiveUserReminderMail::mailSent (   $usr_id )

private

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

References $ilDB, array, and time.

        {
                global $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 47 of file class.ilCronDeleteInactiveUserReminderMail.php.

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

Referenced by ilCronDeleteInactiveUserAccounts\hasCustomSettings().

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

Here is the call graph for this function:

Here is the caller graph for this function:

removeSingleUserFromTable()

static ilCronDeleteInactiveUserReminderMail::removeSingleUserFromTable (   $usr_id )

static

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

References $ilDB, $query, and array.

Referenced by ilObjUser\delete().

        {
                global $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,   $reminderTime,   $time_frame_for_deletion  )

staticprivate

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

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

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

Here is the call graph for this function:

Field Documentation

TABLE_NAME

const ilCronDeleteInactiveUserReminderMail::TABLE_NAME = "usr_cron_mail_reminder"

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

---

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

• Services/User/classes/class.ilCronDeleteInactiveUserReminderMail.php