[Fmsystem-commits] [14938] Fixed aggregated control results for property

[Erik Holm-Larsen]

Revision: 14938
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=14938
Author:   erikhl
Date:     2016-04-26 10:35:51 +0000 (Tue, 26 Apr 2016)
Log Message:
-----------
Fixed aggregated control results for property
Now displays control results for buildings on property summary page

Modified Paths:
--------------
    trunk/controller/inc/class.socheck_list.inc.php

Modified: trunk/controller/inc/class.socheck_list.inc.php
===================================================================
--- trunk/controller/inc/class.socheck_list.inc.php     2016-04-26 10:29:21 UTC 
(rev 14937)
+++ trunk/controller/inc/class.socheck_list.inc.php     2016-04-26 10:35:51 UTC 
(rev 14938)
@@ -428,7 +428,7 @@
                        $sql .= "cl.component_id as cl_component_id, 
cl.location_code as cl_location_code, num_open_cases, num_pending_cases, 
cl.serie_id ";
                        $sql .= "FROM controller_control c ";
                        $sql .= "LEFT JOIN controller_check_list cl on 
cl.control_id = c.id ";
-                       $sql .= "WHERE cl.location_code = '{$location_code}' ";
+                       $sql .= "WHERE cl.location_code LIKE 
'{$location_code}%' ";
 
                        if ($repeat_type != null)
                        {