[Fmsystem-commits] [8713] property: project budgetting

[Sigurd Nes]

Revision: 8713
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8713
Author:   sigurdne
Date:     2012-01-30 12:05:02 +0000 (Mon, 30 Jan 2012)
Log Message:
-----------
property: project budgetting

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 11:59:27 UTC (rev 
8712)
+++ trunk/property/inc/class.soproject.inc.php  2012-01-30 12:05:02 UTC (rev 
8713)
@@ -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;"// ORDER BY start_date 
ASC";
                        $this->db->query($sql,__LINE__,__FILE__);
 
                        while ($this->db->next_record())