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 |
return | array | The array containing processed values of the condition |
private static function ProcessLanguageListOrder(array $p_order)
{
$order = array();
foreach ($p_order as $orderDesc) {
$field = $orderDesc['field'];
$direction = $orderDesc['dir'];
$dbField = null;
switch (strtolower($field)) {
case 'bynumber':
$dbField = 'Languages.Id';
break;
case 'byname':
$dbField = 'Languages.OrigName';
break;
case 'byenglish_name':
$dbField = 'Languages.Name';
break;
case 'bycode':
$dbField = 'Languages.Code';
break;
}
if (!is_null($dbField)) {
$direction = !empty($direction) ? $direction : 'asc';
}
$order[] = array('field' => $dbField, 'dir' => $direction);
}
return $order;
}
/** * 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; }