[Fmsystem-commits] [11903] property: sql-bug

[Sigurd Nes]

Revision: 11903
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=11903
Author:   sigurdne
Date:     2014-04-11 10:41:20 +0000 (Fri, 11 Apr 2014)
Log Message:
-----------
property: sql-bug

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

Modified: trunk/property/inc/class.soproject.inc.php
===================================================================
--- trunk/property/inc/class.soproject.inc.php  2014-04-10 11:14:18 UTC (rev 
11902)
+++ trunk/property/inc/class.soproject.inc.php  2014-04-11 10:41:20 UTC (rev 
11903)
@@ -2731,7 +2731,7 @@
                                                $end_period              = 
(date('Y') - 1) . 13;
                                                $join_method .= " 
{$this->left_join} fm_ecobilagoverf ON ( fm_workorder.id = 
fm_ecobilagoverf.pmwrkord_code AND fm_ecobilagoverf.periode > $start_period AND 
fm_ecobilagoverf.periode < $end_period)";
                                                $actual_cost     = 
',sum(fm_ecobilagoverf.godkjentbelop) AS actual_cost';
-                                               $group_method    = "GROUP BY 
fm_workorder.id, fm_workorder.account_id, 
fm_workorder_status.closed,fm_workorder_status.descr,fm_project.project_type_id";
+                                               $group_method    = "GROUP BY 
fm_workorder.id, fm_workorder.project_id, fm_workorder.account_id, 
fm_workorder_status.closed,fm_workorder_status.descr,fm_project.project_type_id";
                                        }
 
                                        
$this->_update_status_workorder($execute, $status_new, $ids);