Changeset 954 for trunk/grails-app/controllers/CostCodeDetailedController.groovy

Timestamp:

Jun 29, 2011, 4:55:11 PM (13 years ago)

Author:

gav

Message:

Add filterpane search to CostCode? list view, part 2.

File:

• trunk/grails-app/controllers/CostCodeDetailedController.groovy (modified) (2 diffs)

trunk/grails-app/controllers/CostCodeDetailedController.groovy

@@ -13 +13 @@
     def list = {
         params.max = Math.min( params.max ? params.max.toInteger() : 10,  100)
+        def associatedPropertyMax = 1000
+        def associatedPropertyValues = [:]
+        def purchasingGroupNameQuery = 'select distinct a.name from PurchasingGroup a where a.isActive = ? order by a.name'
+        associatedPropertyValues.purchasingGroupList = PurchasingGroup.executeQuery(purchasingGroupNameQuery, [true], [max:associatedPropertyMax])
 
         if(!params.filter) {
             return [costCodeInstanceList: CostCode.list(params),
                     costCodeInstanceTotal: CostCode.count(),
+                    associatedPropertyValues: associatedPropertyValues,
                     filterParams: params]
         }
@@ -23 +28 @@
         return[ costCodeInstanceList: filterService.filter( params, CostCode ),
                 costCodeInstanceTotal: filterService.count( params, CostCode ),
+                associatedPropertyValues: associatedPropertyValues,
                 filterParams: com.zeddware.grails.plugins.filterpane.FilterUtils.extractFilterParams(params),
                 params:params ]