Changeset 954

Timestamp:

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

Author:

gav

Message:

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

Location:

trunk/grails-app

Files:

• controllers/CostCodeDetailedController.groovy (modified) (2 diffs)
• views/costCodeDetailed/list.gsp (modified) (1 diff)

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 ]

trunk/grails-app/views/costCodeDetailed/list.gsp

@@ -97 +97 @@
                                    class="overlayPane"
                                    associatedProperties="purchasingGroup.name"
-                                   filterPropertyValues="${['purchasingGroup.name':[values:PurchasingGroup.findAllByIsActive(true)]]}" />
+                                   filterPropertyValues="${['purchasingGroup.name':[values: associatedPropertyValues.purchasingGroupList]]}" />
 
         </div>