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; }