Model class for manipulating user alerts.

Models don't share that much, so most implementations will be adding methods onto this class. This class simply provides helper methods for common actions.

author kier
package XenForo_Mvc

 Methods

Constructor.

__construct() 
Inherited

Use create() statically unless you know what you're doing.

inherited_from \XenForo_Model::__construct()

Adds a join to the set of fetch options.

addFetchOptionJoin(array $fetchOptions, integer $join) 
Inherited

Join should be one of the constants.

inherited_from \XenForo_Model::addFetchOptionJoin()

Parameters

$fetchOptions

array

$join

integer

Adds the equivalent of a limit clause using position-based limits.

addPositionLimit(string $table, integer $limit, integer $offset, string $column) : string
Inherited

It no limit value is specified, nothing will be returned.

This must be added within a WHERE clause. If a clause is required, it will begin with "AND", so ensure there is a condition before it.

inherited_from \XenForo_Model::addPositionLimit()

Parameters

$table

string

Name of the table alias to prefix. May be blank for no table reference.

$limit

integer

Number of records to limit to; ignored if <= 0

$offset

integer

Offset from the start of the records. 0+

$column

string

Name of the column that is storing the position

Returns

stringPosition limit clause if needed

Send a user alert

alert(integer $alertUserId, integer $userId, string $username, string $contentType, integer $contentId, string $action, array $extraData) 

Parameters

$alertUserId

integer

$userId

integer

$username

string

$contentType

string

$contentId

integer

$action

string

$extraData

array

Send a user alert

alertUser(integer $alertUserId, integer $userId, string $username, string $contentType, integer $contentId, string $action, array $extraData) 

Parameters

$alertUserId

integer

$userId

integer

$username

string

$contentType

string

$contentId

integer

$action

string

$extraData

array

Ensures that a valid cut-off operator is passed.

assertValidCutOffOperator(string $operator) 
Inherited

inherited_from \XenForo_Model::assertValidCutOffOperator()

Parameters

$operator

string

countAlertsForUser()

countAlertsForUser($userId) 

Parameters

$userId

Factory method to get the named model.

create(string $class) : \XenForo_Model
Inherited

The class must exist or be autoloadable or an exception will be thrown.

inherited_from \XenForo_Model::create()

Parameters

$class

string

Class to load

Returns

Deletes the matching alerts.

deleteAlerts(string $contentType, integer | array $contentId, integer | null $userId, string | null $action) 

Parameters

$contentType

string

$contentId

integerarray

$userId

integernull

Ignored if null

$action

stringnull

Ignored if null

Deletes old viewed alerts.

deleteOldReadAlerts(integer | null $dateCut) 

Parameters

$dateCut

integernull

Cut off date; if not specified, defaults to expiry setting

Deletes old unviewed alerts.

deleteOldUnreadAlerts(integer | null $dateCut) 

The cut-off here is much longer than viewed ones.

Parameters

$dateCut

integernull

Cut off date; if not specified, defaults to 30 days

Fetches results from the database with each row keyed according to preference.

fetchAllKeyed(string $sql, string $key, mixed $bind, string $nullPrefix) : array
Inherited

The 'key' parameter provides the column name with which to key the result. For example, calling fetchAllKeyed('SELECT item_id, title, date FROM table', 'item_id') would result in an array keyed by item_id: [$itemId] => array('item_id' => $itemId, 'title' => $title, 'date' => $date)

Note that the specified key must exist in the query result, or it will be ignored.

inherited_from \XenForo_Model::fetchAllKeyed()

Parameters

$sql

string

SQL to execute

$key

string

Column with which to key the results array

$bind

mixed

Parameters for the SQL

$nullPrefix

string

If the key is null, prefix the counter with this

Returns

array

Fetches a single alert using its ID

getAlertById(integer $alertId) : array | false

Parameters

$alertId

integer

Returns

arrayfalse

Fetches an array containing the names of alert types the specified user has opted not to receive.

getAlertOptOuts(array $user, boolean $useDenormalized) : array

Parameters

$user

array
  • defaults to visitor if null

$useDenormalized

boolean

If true, the $user array must contain the alert_optout key from the user_option table. If false, queries for the data.

Returns

array[ a => true, b => true, c => true ]

Returns alert data for the specified user.

getAlertsForUser(integer $userId, string $fetchMode, array $fetchOptions, array $viewingUser) : array

Parameters

$userId

integer

$fetchMode

string

Use one of the FETCH_x constants

$fetchOptions

array

(supports page, perpage)

$viewingUser

arraynull

Information about the viewing user (keys: user_id, permission_combination_id, permissions) or null for visitor

Returns

array

Gets a list of SQL conditions in the format for a clause.

getConditionsForClause(array $sqlConditions) : string
Inherited

This always returns a value that can be used in a clause such as WHERE.

inherited_from \XenForo_Model::getConditionsForClause()

Parameters

$sqlConditions

array

Returns

string

Gets the specified field from a content type, if specified for that type.

getContentTypeField(string $contentType, string $fieldName) : string | false
Inherited

inherited_from \XenForo_Model::getContentTypeField()

Parameters

$contentType

string

$fieldName

string

Returns

stringfalse

Gets the value of the specified field for each content type that has that field.

getContentTypesWithField(string $fieldName) : array
Inherited

inherited_from \XenForo_Model::getContentTypesWithField()

Parameters

$fieldName

string

Returns

arrayFormat: [content type] => field value

Gets the specified model object from the cache.

getModelFromCache(string $class) : \XenForo_Model
Inherited

If it does not exist, it will be instantiated.

inherited_from \XenForo_Model::getModelFromCache()

Parameters

$class

string

Name of the class to load

Returns

Gets the order by clause for an SQL query.

getOrderByClause(array $choices, array $fetchOptions, string $defaultOrderSql) : string
Inherited

inherited_from \XenForo_Model::getOrderByClause()

Parameters

$choices

array

$fetchOptions

array

$defaultOrderSql

string

Returns

stringOrder by clause or empty string

Applies a limit clause to the provided query if a limit value is specified.

limitQueryResults(string $query, integer $limit, integer $offset) : string
Inherited

If the limit value is 0 or less, no clause is applied.

inherited_from \XenForo_Model::limitQueryResults()

Parameters

$query

string

SQL query to run

$limit

integer

Number of records to limit to; ignored if <= 0

$offset

integer

Offset from the start of the records. 0+

Returns

stringQuery with limit applied if necessary

Marks all of a user's alerts as read.

markAllAlertsReadForUser(integer $userId, integer | null $time) 

Parameters

$userId

integer

$time

integernull

Wraps around the prepareX functions in the handler class for each content type.

prepareAlert(array $item, string $handlerClassName, array $viewingUser) : array

Also does basic setup, moving user info to a sub-array.

Parameters

$item

array

$handlerClassName

string

Name of alert handler class for this item

$viewingUser

array

Information about the viewing user (keys: user_id, permission_combination_id, permissions)

Returns

array

Runs prepareAlert on an array of items

prepareAlerts(array $alerts, array $viewingUser) : array

Parameters

$alerts

array

$viewingUser

array

Information about the viewing user (keys: user_id, permission_combination_id, permissions)

Returns

array

Prepares the limit-related fetching options that can be applied to various queries.

prepareLimitFetchOptions(array $fetchOptions) : array
Inherited

Includes: limit, offset, page, and perPage.

inherited_from \XenForo_Model::prepareLimitFetchOptions()

Parameters

$fetchOptions

array

Unprepared options

Returns

arrayLimit options; keys: limit, offset

Prepares state related fetch limits, based on the list of conditions.

prepareStateLimitFromConditions(array $fetchOptions, string $table, string $stateField, string $userField) : string
Inherited

Looks for keys "deleted" and "moderated".

inherited_from \XenForo_Model::prepareStateLimitFromConditions()

Parameters

$fetchOptions

array

$table

string

Name of the table to prefix the state and user fields with

$stateField

string

Name of the field that holds the state

$userField

string

Name of the field that holds the user ID

Returns

stringSQL condition to limit state

Reset an entry or the entire local cache.

resetLocalCacheData($name) 
Inherited

This can be used if you know when some cached data has expired.

inherited_from \XenForo_Model::resetLocalCacheData()

Parameters

$name

Resets the unviewed alerts counter to 0 for the specified user.

resetUnreadAlertsCounter(integer $userId) 

Parameters

$userId

integer

Sets whether we're allowed to read values from the cache on a model-level.

setAllowCachedRead($allowCachedRead) 
Inherited

This may be controllable on an individual level basis, if the implementation allows it.

inherited_from \XenForo_Model::setAllowCachedRead()

Parameters

$allowCachedRead

boolean

Injects a local cache value.

setLocalCacheData(string $name, $value) 
Inherited

This should only be used if you know what you're doing or for testing purposes!

Note that you cannot get the existing data via the public interface. If you think you need the set data, use a new object. It defaults to empty. :)

inherited_from \XenForo_Model::setLocalCacheData()

Parameters

$name

string

$value

Standardizes a set of node permissions and a user ID to always have appropriate data.

standardizeNodePermissionsAndUserId(integer $nodeId, array | null $permissions, integer | null $userId) 
Inherited

If an invalid permission set or user ID is provided, the current visitor's will be used.

inherited_from \XenForo_Model::standardizeNodePermissionsAndUserId()

Parameters

$nodeId

integer

Node permissions are for

$permissions

arraynull

Permissions for node or null to use current visitor's permissions

$userId

integernull

User permissions belong to or null to use current visitor

Standardizes a permission combination and user ID to always have appropriate data.

standardizePermissionCombinationIdAndUserId(integer | null $permissionCombinationId, integer | null $userId) 
Inherited

If null, users current visitor's values.

inherited_from \XenForo_Model::standardizePermissionCombinationIdAndUserId()

Parameters

$permissionCombinationId

integernull

Permission combination ID or null to use current visitor

$userId

integernull

User permissions belong to or null to use current visitor

Standardizes a set of permissions and a user ID to always have appropriate data.

standardizePermissionsAndUserId(array | null $permissions, integer | null $userId) 
Inherited

If an invalid permission set or user ID is provided, the current visitor's will be used.

inherited_from \XenForo_Model::standardizePermissionsAndUserId()

Parameters

$permissions

arraynull

Global pPermissions or null to use current visitor's permissions

$userId

integernull

User permissions belong to or null to use current visitor

Standardizes a viewing user reference array.

standardizeViewingUserReference(array $viewingUser) 
Inherited

This array must contain all basic user info (preferably all user info) and include global permissions in a "permissions" key. If not an array or missing a user_id, the visitor's values will be used.

inherited_from \XenForo_Model::standardizeViewingUserReference()

Parameters

$viewingUser

arraynull

Standardizes the viewing user reference for the specific node.

standardizeViewingUserReferenceForNode(integer $nodeId, array $viewingUser, array $nodePermissions) 
Inherited

inherited_from \XenForo_Model::standardizeViewingUserReferenceForNode()

Parameters

$nodeId

integer

$viewingUser

arraynull

Viewing user; if null, use visitor

$nodePermissions

arraynull

Permissions for this node; if null, use visitor's

Helper to unserialize permissions in a list of items.

unserializePermissionsInList(array $items, string $serializedKey, string $targetKey) : array
Inherited

inherited_from \XenForo_Model::unserializePermissionsInList()

Parameters

$items

array

List of items

$serializedKey

string

Key where serialized permissions are

$targetKey

string

Key where unserialized permissions will go

Returns

arrayList of items with permissions unserialized

Returns false if the specified user has opted not to receive the specified alert type

userReceivesAlert(array $user, string $contentType, string $action) 

Parameters

$user

array

$contentType

string

$action

string

Fetches an instance of the specified alert handler

_getAlertHandlerFromCache(string $class) : \XenForo_AlertHandler_Abstract

Parameters

$class

string

Returns

Fetches raw alert records for the specified user.

_getAlertsFromSource(integer $userId, string $fetchMode, array $fetchOptions) 

Includes any unviewed alerts plus any alerts that were viewed within the last $dateCut seconds.

Parameters

$userId

integer

User to whom the alerts belong

$fetchMode

string

Fetch viewed alerts read more recently than this timestamp

$fetchOptions

array

(supports page and perpage)

Helper method to get the cache object.

_getCache(boolean $forceCachedRead) : \Zend_Cache_Core | \Zend_Cache_Frontend | false
Inherited

If cache reads are disabled, this will return false.

inherited_from \XenForo_Model::_getCache()

Parameters

$forceCachedRead

boolean

If true, the global "allow cached read" value is ignored

Returns

\Zend_Cache_Core\Zend_Cache_Frontendfalse

Fetches content data for alerts

_getContentForAlerts(array $data, integer $userId, array $viewingUser) : array

Parameters

$data

array

Raw alert data

$userId

integer

The user ID the alerts are for

$viewingUser

array

Information about the viewing user (keys: user_id, permission_combination_id, permissions)

Returns

array

Gets the data registry model.

_getDataRegistryModel() : \XenForo_Model_DataRegistry
Inherited

inherited_from \XenForo_Model::_getDataRegistryModel()

Returns

Helper method to get the database object.

_getDb() : \Zend_Db_Adapter_Abstract
Inherited

inherited_from \XenForo_Model::_getDb()

Returns

\Zend_Db_Adapter_Abstract

Translates the FETCH_MODE_x constants from this class into a cut-off timestamp

_getFetchModeDateCut(string $fetchMode) : integer

Parameters

$fetchMode

string

self::FETCH_MODE_x

Returns

integerUnix timestamp

Gets the named entry from the local cache.

_getLocalCacheData(string $name) : mixed
Inherited

inherited_from \XenForo_Model::_getLocalCacheData()

Parameters

$name

string

Returns

mixed

Fetches an instance of the user model

_getUserModel() : \XenForo_Model_User

Filters out unviewable alerts and returns only those the user can view.

_getViewableAlerts(array $alerts, array $viewingUser) : array

Parameters

$alerts

array

$viewingUser

array

Information about the viewing user (keys: user_id, permission_combination_id, permissions)

Returns

arrayFiltered items

Returns true if the alert passed in is 'current' for the given date-cut-off.

_isCurrent(array $alert, integer $dateCut) : boolean

Current means unread, or viewed within the specified date cut off.

Parameters

$alert

array

$dateCut

integer

Returns

boolean

Returns true if the alert passed in is 'unread' - ie: has view_date == 0

_isUnread(array $alert) : boolean

Parameters

$alert

array

Returns

boolean

 Properties

 

Controls whether a cached read is allowed.

$_allowCachedRead : boolean
Inherited

If not, it should be retrieved from the source.

inherited_from \XenForo_Model::$$_allowCachedRead
 

Cache object

$_cache : \Zend_Cache_Core | \Zend_Cache_Frontend
Inherited

inherited_from \XenForo_Model::$$_cache
 

Database object

$_db : \Zend_Db_Adapter_Abstract
Inherited

inherited_from \XenForo_Model::$$_db
 

Array to store alert handler classes

$_handlerCache : array

 

Stores local, instance-specific cached data for each model.

$_localCacheData : array
Inherited

This data is generally treated as canonical, even if {$_allowCachedRead} is false.

inherited_from \XenForo_Model::$$_localCacheData
 

Standard approach to caching other model objects for the lifetime of the model.

$_modelCache : array
Inherited

inherited_from \XenForo_Model::$$_modelCache

 Constants

 

Fetch alerts regardless of their view_date

FETCH_MODE_ALL : string

 

Fetch alerts viewed in the last options:alertsPopupExpiryHours hours

FETCH_MODE_POPUP : string

 

Fetch alerts viewed in the last options:alertExpiryDays days

FETCH_MODE_RECENT : string

 

Prevent alerts from being marked as read (debug option);

PREVENT_MARK_READ : boolean