本文整理汇总了PHP中flexicontent_db::_getOrderByClause方法的典型用法代码示例。如果您正苦于以下问题：PHP flexicontent_db::_getOrderByClause方法的具体用法？PHP flexicontent_db::_getOrderByClause怎么用？PHP flexicontent_db::_getOrderByClause使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类flexicontent_db的用法示例。
在下文中一共展示了flexicontent_db::_getOrderByClause方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: buildItemOrderBy
/**
* Build the order clause of item listings
* precedence: $request_var ==> $order ==> $config_param ==> $default_order_col (& $default_order_dir)
* @access private
* @return string
*/
static function buildItemOrderBy(&$params = null, &$order = '', $request_var = 'orderby', $config_param = 'orderby', $i_as = 'i', $rel_as = 'rel', $default_order_col_1st = '', $default_order_dir_1st = '', $sfx = '', $support_2nd_lvl = false)
{
// Use global params ordering if parameters were not given
if (!$params) {
$params = JComponentHelper::getParams('com_flexicontent');
}
$order_fallback = 'rdate';
// Use as default or when an invalid ordering is requested
$orderbycustomfield = (int) $params->get('orderbycustomfield' . $sfx, 1);
// Backwards compatibility, defaults to enabled *
$orderbycustomfieldid = (int) $params->get('orderbycustomfieldid' . $sfx, 0);
// * but this needs to be set in order for field ordering to be used
// 1. If a FORCED -ORDER- is not given, then use ordering parameters from configuration. NOTE: custom field ordering takes priority
if (!$order) {
$order = $orderbycustomfield && $orderbycustomfieldid ? 'field' : $params->get($config_param . $sfx, $order_fallback);
}
// 2. If allowing user ordering override, then get ordering from HTTP request variable
$order = $params->get('orderby_override') && ($request_order = JRequest::getVar($request_var . $sfx)) ? $request_order : $order;
// 3. Check various cases of invalid order, print warning, and reset ordering to default
if ($order == 'field' && !$orderbycustomfieldid) {
// This can occur only if field ordering was requested explicitly, otherwise an not set 'orderbycustomfieldid' will prevent 'field' ordering
echo "Custom field ordering was selected, but no custom field is selected to be used for ordering<br/>";
$order = $order_fallback;
}
if ($order == 'commented') {
if (!file_exists(JPATH_SITE . DS . 'components' . DS . 'com_jcomments' . DS . 'jcomments.php')) {
echo "jcomments not installed, you need jcomments to use 'Most commented' ordering OR display comments information.<br/>\n";
$order = $order_fallback;
}
}
$order_col_1st = $default_order_col_1st;
$order_dir_1st = $default_order_dir_1st;
flexicontent_db::_getOrderByClause($params, $order, $i_as, $rel_as, $order_col_1st, $order_dir_1st, $sfx);
$order_arr[1] = $order;
$orderby = ' ORDER BY ' . $order_col_1st . ' ' . $order_dir_1st;
// ****************************************************************
// 2nd level ordering, (currently only supported when no SFX given)
// ****************************************************************
if ($sfx != '' || !$support_2nd_lvl) {
$orderby .= $order_col_1st != $i_as . '.title' ? ', ' . $i_as . '.title' : '';
$order_arr[2] = '';
$order = $order_arr;
return $orderby;
}
$order = '';
// Clear this, thus force retrieval from parameters (below)
$sfx = '_2nd';
// Set suffix of second level ordering
$order_fallback = 'alpha';
// Use as default or when an invalid ordering is requested
$orderbycustomfield = (int) $params->get('orderbycustomfield' . $sfx, 1);
// Backwards compatibility, defaults to enabled *
$orderbycustomfieldid = (int) $params->get('orderbycustomfieldid' . $sfx, 0);
// * but this needs to be set in order for field ordering to be used
// 1. If a FORCED -ORDER- is not given, then use ordering parameters from configuration. NOTE: custom field ordering takes priority
if (!$order) {
$order = $orderbycustomfield && $orderbycustomfieldid ? 'field' : $params->get($config_param . $sfx, $order_fallback);
}
// 2. If allowing user ordering override, then get ordering from HTTP request variable
$order = $request_var && ($request_order = JRequest::getVar($request_var . $sfx)) ? $request_order : $order;
// 3. Check various cases of invalid order, print warning, and reset ordering to default
if ($order == 'field' && !$orderbycustomfieldid) {
// This can occur only if field ordering was requested explicitly, otherwise an not set 'orderbycustomfieldid' will prevent 'field' ordering
echo "Custom field ordering was selected, but no custom field is selected to be used for ordering<br/>";
$order = $order_fallback;
}
if ($order == 'commented') {
if (!file_exists(JPATH_SITE . DS . 'components' . DS . 'com_jcomments' . DS . 'jcomments.php')) {
echo "jcomments not installed, you need jcomments to use 'Most commented' ordering OR display comments information.<br/>\n";
$order = $order_fallback;
}
}
$order_col_2nd = '';
$order_dir_2nd = '';
if ($order != 'default') {
flexicontent_db::_getOrderByClause($params, $order, $i_as, $rel_as, $order_col_2nd, $order_dir_2nd, $sfx);
$order_arr[2] = $order;
$orderby .= ', ' . $order_col_2nd . ' ' . $order_dir_2nd;
}
// Order by title after default ordering
$orderby .= $order_col_1st != $i_as . '.title' && $order_col_2nd != $i_as . '.title' ? ', ' . $i_as . '.title' : '';
$order = $order_arr;
return $orderby;
}