Publication::ProcessLanguageListOrder PHP Method

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