Processes an order directive for the issue translations list.
| private static ProcessLanguageListOrder ( array $p_order ) : array | ||
| $p_order | array | 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 |
| 리턴 | array | The array containing processed values of the condition |
/**
* 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;
}
