Changeset 681 for trunk/grails-app/services

Timestamp:

Oct 5, 2010, 2:24:33 AM (14 years ago)

Author:

gav

Message:

Improvements to assetRegister report, adding site and section to page header.

File:

• trunk/grails-app/services/AssetReportService.groovy (modified) (2 diffs)

trunk/grails-app/services/AssetReportService.groovy

@@ -24 +24 @@
         def result = [:]
 
+        result.section = Section.get(params.section.id.toLong())
+        result.site = result.section.site
+
         // Inner join used to return only attribTypes that are used by AssetExtendedAttributes.
         // So the result is only asset extendedAttributeTypes.
@@ -44 +47 @@
                     'left join asset.assetExtendedAttributes as attrib',
                     'left join attrib.extendedAttributeType as attribT'
-            if(params.section instanceof Section) {
-                namedParams.section = params.section
-                where 'asset.section = :section'
-            }
+            where 'asset.section = :section'
+                    namedParams.section = result.section
             order 'by asset.name asc, attribT.name asc'
         }