[Fmsystem-commits] [9117] property: listing active orders

[Sigurd Nes]

Revision: 9117
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=9117
Author:   sigurdne
Date:     2012-04-11 07:07:21 +0000 (Wed, 11 Apr 2012)
Log Message:
-----------
property: listing active orders

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

Modified: trunk/property/inc/class.soworkorder.inc.php
===================================================================
--- trunk/property/inc/class.soworkorder.inc.php        2012-04-11 06:33:54 UTC 
(rev 9116)
+++ trunk/property/inc/class.soworkorder.inc.php        2012-04-11 07:07:21 UTC 
(rev 9117)
@@ -625,9 +625,11 @@
 
                        $sql_full = "{$sql} {$filtermethod} {$querymethod}";
 
+                       $sql_base = 
substr($sql_full,strripos($sql_full,'FROM'));
+
                        
if($GLOBALS['phpgw_info']['server']['db_type']=='postgres')
                        {                               
-                               $sql_minimized = 'SELECT DISTINCT 
fm_workorder.id '  . substr($sql_full,strripos($sql_full,'FROM'));
+                               $sql_minimized = "SELECT DISTINCT 
fm_workorder.id {$sql_base}";
                                $sql_count = "SELECT count(id) as cnt FROM 
({$sql_minimized}) as t";
 
                                $this->db->query($sql_count,__LINE__,__FILE__);