本文整理汇总了PHP中Publication::ProcessLanguageListOrder方法的典型用法代码示例。如果您正苦于以下问题:PHP Publication::ProcessLanguageListOrder方法的具体用法?PHP Publication::ProcessLanguageListOrder怎么用?PHP Publication::ProcessLanguageListOrder使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Publication
的用法示例。
在下文中一共展示了Publication::ProcessLanguageListOrder方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getLanguages
/**
* Return all languages used in the publication as an array of
* Language objects.
*
* @param integer $p_excludeLanguageId
* If greater than 0, exclude the language with the given
* identifier from the list.
* @param array $p_order
* The array of order directives in the format:
* array('field'=>field_name, 'dir'=>order_direction)
* field_name can take one of the following values:
* bynumber, byname, byenglish_name, bycode
* order_direction can take one of the following values:
* asc, desc
* @return array
*/
public function getLanguages($p_excludeLanguageId = null, array $p_order = array(), $p_published = false)
{
$queryStr = 'SELECT Languages.* FROM Issues LEFT JOIN Languages ' . 'ON Issues.IdLanguage = Languages.Id WHERE ' . 'Issues.IdPublication = ' . $this->getPublicationId();
if ($p_excludeLanguageId > 0) {
$queryStr .= ' AND Languages.Id != ' . $p_excludeLanguageId;
}
if ($p_published) {
$queryStr .= " AND Issues.Published = 'Y'";
}
$queryStr .= ' GROUP BY Languages.Id';
$order = Publication::ProcessLanguageListOrder($p_order);
foreach ($order as $orderDesc) {
$sqlOrder[] = $orderDesc['field'] . ' ' . $orderDesc['dir'];
}
if (count($sqlOrder) > 0) {
$queryStr .= ' ORDER BY ' . implode(', ', $sqlOrder);
}
$languages = DbObjectArray::Create('Language', $queryStr);
return $languages;
}