本文整理匯總了PHP中table_sql::get_sql_sort方法的典型用法代碼示例。如果您正苦於以下問題：PHP table_sql::get_sql_sort方法的具體用法？PHP table_sql::get_sql_sort怎麽用？PHP table_sql::get_sql_sort使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類table_sql的用法示例。
在下文中一共展示了table_sql::get_sql_sort方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1:
/**
* override parent class method, because we may want to specify a default sort
*
* @return xxx
*/
function get_sql_sort()
{
// if user has specified a sort column, use that
if ($sort = parent::get_sql_sort()) {
return $sort;
}
// if there is a "fullname" column, sort by first/last name
if ($this->has_column('fullname')) {
$sort = 'u.firstname, u.lastname';
if ($this->has_column('attempt')) {
$sort .= ', ha.attempt ASC';
}
return $sort;
}
// no sort column, and no "fullname" column
return '';
}示例2: get_sql_sort
/**
* Get the SQL fragment to sort by.
*
* This is overridden to sort by timemodified and ID by default. Many items happen at the same time
* and a second sorting by ID is valuable to distinguish the order in which the history happened.
*
* @return string SQL fragment.
*/
public function get_sql_sort()
{
$columns = $this->get_sort_columns();
if (count($columns) == 1 && isset($columns['timemodified']) && $columns['timemodified'] == SORT_DESC) {
// Add the 'id' column when we are using the default sorting.
$columns['id'] = SORT_DESC;
return self::construct_order_by($columns);
}
return parent::get_sql_sort();
}