[Fmsystem-commits] [10796] property: bulk update budget

[Sigurd Nes]

Revision: 10796
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=10796
Author:   sigurdne
Date:     2013-02-11 19:15:42 +0000 (Mon, 11 Feb 2013)
Log Message:
-----------
property: bulk update budget

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

Modified: trunk/property/inc/class.soworkorder.inc.php
===================================================================
--- trunk/property/inc/class.soworkorder.inc.php        2013-02-11 17:18:41 UTC 
(rev 10795)
+++ trunk/property/inc/class.soworkorder.inc.php        2013-02-11 19:15:42 UTC 
(rev 10796)
@@ -2255,7 +2255,7 @@
                                //paid last year
                                $this->db->query("SELECT sum(amount) as paid 
FROM fm_workorder"
                                . " {$this->join} 
fm_orders_paid_or_pending_view ON fm_workorder.id = 
fm_orders_paid_or_pending_view.order_id"
-                               . " WHERE periode > {$latest_year}00 AND 
periode < {$latest_year}13 AND fm_project.id = {$id}",__LINE__,__FILE__);
+                               . " WHERE periode > {$latest_year}00 AND 
periode < {$latest_year}13 AND fm_workorder.id = {$id}",__LINE__,__FILE__);
                                $this->db->next_record();
                                $paid_last_year = $this->db->f('paid');