LLMS_Notifications_Query::sql_orderby()
Retrieve the prepared SQL for the ORDER clause.
Description Description
Slightly modified from abstract to include the table name to prevent ambiguous errors.
Return Return
(string)
Source Source
File: includes/notifications/class.llms.notifications.query.php
protected function sql_orderby() {
$sql = 'ORDER BY';
$comma = false;
foreach ( $this->get( 'sort' ) as $orderby => $order ) {
$pre = ( $comma ) ? ', ' : ' ';
$sql .= $pre . 'n.' . sanitize_sql_orderby( "{$orderby} {$order}" );
$comma = true;
}
if ( $this->get( 'suppress_filters' ) ) {
return $sql;
}
/**
* Filters the query WHERE clause.
*
* @since 7.1.0
*
* @param string $sql The WHERE clause of the query.
* @param LLMS_Notifications_Query $notifications_query Instance of LLMS_Events_Query.
*/
return apply_filters( 'llms_notifications_query_where', $sql, $this );
}
Expand full source code Collapse full source code View on GitHub
Changelog Changelog
| Version | Description |
|---|---|
| 7.1.0 | Drop usage of $this->get_filter('where') in favor of llms_notifications_query_where. |
| 3.9.2 | Introduced. |