[Fmsystem-commits] [11921] property: fix sql for bulk update

[Sigurd Nes]

Revision: 11921
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=11921
Author:   sigurdne
Date:     2014-04-25 11:13:50 +0000 (Fri, 25 Apr 2014)
Log Message:
-----------
property: fix sql for bulk update

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-24 09:07:44 UTC (rev 
11920)
+++ trunk/property/inc/class.soproject.inc.php  2014-04-25 11:13:50 UTC (rev 
11921)
@@ -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.project_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,fm_workorder.title,fm_workorder.start_date,fm_workorder.continuous";
                                        }
 
                                        
$this->_update_status_workorder($execute, $status_new, $ids);