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

Timestamp:

06/15/12 17:00:17 (12 years ago)

Author:

gustavo

Message:

Ticket #2766 - Merge do branch das novas funcionalidaes para o trunk

Location:

trunk

Files:

• . (modified) (1 prop)
• prototype/services/PostgreSQL.php (modified) (6 diffs)

trunk/prototype/services/PostgreSQL.php

@@ -40 +40 @@
  */
 
+use prototype\api\Config as Config;
+
 class PostgreSQL implements Service
 {
@@ -87 +89 @@
             $map = Config::get($uri['concept'], 'PostgreSQL.mapping');
             $criteria = ($criteria !== false) ? $this->parseCriteria ( $criteria , $map , ' WHERE '.$map['id'].' = \''.addslashes( $uri['id'] ).'\'') : ' WHERE '.$map['id'].' = \''.addslashes( $uri['id'] ).'\'';
+
             return $this->execSql('UPDATE '.(Config::get($uri['concept'],'PostgreSQL.concept')).' '. self::parseUpdateData( $data ,$map).$criteria);
     }
@@ -197 +200 @@
                     $val[] = '\''.addslashes($v).'\'';
             }
-            
-            return '('.implode(',', $ind).') VALUES ('.implode(',', $val).') RETURNING '.$map['id'].' as id';
+            return '('.implode(',', $ind).') VALUES ('.implode(',', $val).') RETURNING '.$map['id'].' as id';       
     }
         
@@ -244 +246 @@
                     $query .= ' GROUP BY '.( is_array($criteria["group"]) ? implode(', ', $criteria["group"]) : $criteria["group"] ).' ';
             }
-            
+   
             if( isset($criteria["order"]) )
             {
-                    $query .= ' ORDER BY '.self::parseOrder( $criteria["order"], $map ).' ';
-            }
+                    //Verificar se os atributos para o ORDER BY serao ordenados em ordem decrescente [DESC]
+                    $orderDesc = ( isset($criteria["orderDesc"]) && count($criteria["order"]) == count($criteria["orderDesc"]) ) ? $criteria["orderDesc"] : false;
+                
+                    $query .= ' ORDER BY '.self::parseOrder( $criteria["order"], $map, $orderDesc ).' ';
+            
+            }
+
             if( isset($criteria["limit"]) )
             {
@@ -339 +346 @@
     }
 
-   private static function parseOrder($order , &$map)
+    private static function parseOrder($order , &$map, $orderDesc=false)
     {
-                  
+
         if($notArray = !is_array($order)) //Caso seja um full select pegar todas as keys
             $order = array( $order );
+
+        //Caso seja feita ordenacao em ordem descrescente
+        //concatenar DESC em cada atributo
+        if($orderDesc !== false){
+                if(!is_array($orderDesc)){
+                        $orderDesc = array( $orderDesc );
+                }
+
+                for($i=0; $i<count($order); $i++){
+                        $order[$i] .= ($orderDesc[$i] === true) ? ' DESC' : '';
+                }
+        }
 
         $return = array();
@@ -356 +375 @@
         return ( $notArray ?  $order[0] : implode(', ', $order) );
     }
+
 }