fmsystem-commits
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Fmsystem-commits] [8857] property: order by


From: Sigurd Nes
Subject: [Fmsystem-commits] [8857] property: order by
Date: Tue, 14 Feb 2012 12:12:33 +0000

Revision: 8857
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8857
Author:   sigurdne
Date:     2012-02-14 12:12:09 +0000 (Tue, 14 Feb 2012)
Log Message:
-----------
property: order by

Modified Paths:
--------------
    trunk/property/inc/class.sos_agreement.inc.php

Modified: trunk/property/inc/class.sos_agreement.inc.php
===================================================================
--- trunk/property/inc/class.sos_agreement.inc.php      2012-02-14 09:59:42 UTC 
(rev 8856)
+++ trunk/property/inc/class.sos_agreement.inc.php      2012-02-14 12:12:09 UTC 
(rev 8857)
@@ -284,18 +284,30 @@
 
                        if ($order)
                        {
-                               switch ($order)
+                               if(!$detail)
                                {
-                                       case 'id':
-                                       case 'status':
-                                               $ordermethod = " ORDER BY 
{$entity_table}.{$order} {$sort}";
-                                               break;
-                                       case 'category':
-                                               $ordermethod = " ORDER BY 
{$category_table}.descr {$sort}";                                     
-                                               break;
-                                       default:
-                                               $ordermethod = " ORDER BY 
{$order} {$sort}";
+                                       switch ($order)
+                                       {
+                                               case 'id':
+                                               case 'status':
+                                                       $ordermethod = " ORDER 
BY {$entity_table}.{$order} {$sort}";
+                                                       break;
+                                               case 'category':
+                                                       $ordermethod = " ORDER 
BY {$category_table}.descr {$sort}";                                     
+                                                       break;
+                                               default:
+                                                       $ordermethod = " ORDER 
BY {$order} {$sort}";
+                                       }
                                }
+                               else
+                               {
+                                       switch ($order)
+                                       {
+                                               case 'id':
+                                                       $ordermethod = " ORDER 
BY {$entity_table}.{$order} {$sort}";
+                                                       break;
+                                       }
+                               }
                        }
                        else
                        {




reply via email to

[Prev in Thread] Current Thread [Next in Thread]