Changeset 5514 for trunk/prototype/services/PostgreSQL.php

Timestamp:

02/14/12 16:52:04 (12 years ago)

Author:

acoutinho

Message:

Ticket #2434 - Implementacao anexos, acls e delegacao de participantes

File:

• trunk/prototype/services/PostgreSQL.php (modified) (2 diffs)

trunk/prototype/services/PostgreSQL.php

@@ -210 +210 @@
             if( isset($criteria["order"]) )
             {
-                    $result .= ' ORDER BY '.( is_array($criteria["order"]) ? implode(', ', $criteria["order"]) : $criteria["order"] ).' ';
+                    $result .= ' ORDER BY '.self::parseOrder( $criteria["order"], $map ).' ';
             }
             if( isset($criteria["limit"]) )
@@ -300 +300 @@
         return $return;  
     }
-   
+
+   private static function parseOrder($order , &$map)
+    {
+                  
+        if($notArray = !is_array($order)) //Caso seja um full select pegar todas as keys
+            $order = array( $order );
+
+        $return = array();
+
+        foreach ($order as &$value) 
+        {
+            if(!isset($map[$value])) continue; //Escapa itens não existentes no mapa
+
+            $value = $map[$value];
+        }
+
+        return ( $notArray ?  $order[0] : implode(', ', $order) );
+    }
 }