[Fmsystem-commits] [8715] property: group by

[Sigurd Nes]

Revision: 8715
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8715
Author:   sigurdne
Date:     2012-01-30 12:08:59 +0000 (Mon, 30 Jan 2012)
Log Message:
-----------
property: group by

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

Modified: trunk/property/inc/class.soproject.inc.php
===================================================================
--- trunk/property/inc/class.soproject.inc.php  2012-01-30 12:06:49 UTC (rev 
8714)
+++ trunk/property/inc/class.soproject.inc.php  2012-01-30 12:08:59 UTC (rev 
8715)
@@ -1318,7 +1318,7 @@
                        $sql = "SELECT EXTRACT(YEAR from 
to_timestamp(start_date) ) as year, sum(calculation) as calculation, 
sum(budget) as budget, sum(contract_sum) as contract_sum FROM fm_workorder"
                        . " {$this->join} fm_workorder_status ON 
fm_workorder.status  = fm_workorder_status.id"
                        . " WHERE project_id = {$project_id} AND 
fm_workorder_status.closed IS NULL"
-                       . " GROUP BY fm_workorder.id";// ORDER BY start_date 
ASC";
+                       . " GROUP BY fm_workorder.id, 
fm_workorder.start_date";// ORDER BY start_date ASC";
                        $this->db->query($sql,__LINE__,__FILE__);
 
                        while ($this->db->next_record())