Changeset 958 for trunk/grails-app/controllers/InventoryLocationDetailedController.groovy

Timestamp:

Jul 1, 2011, 6:13:37 AM (13 years ago)

Author:

gav

Message:

Add filterpane search to InventoryLocation? list view.

File:

• trunk/grails-app/controllers/InventoryLocationDetailedController.groovy (modified) (3 diffs)

trunk/grails-app/controllers/InventoryLocationDetailedController.groovy

@@ -3 +3 @@
 @Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager'])
 class InventoryLocationDetailedController extends BaseController {
+
+    def filterService
 
     // the delete, save and update actions only accept POST requests
@@ -13 +15 @@
     def list = {
         params.max = Math.min( params.max ? params.max.toInteger() : 10,  100)
-        [ inventoryLocationInstanceList: InventoryLocation.list( params ), inventoryLocationInstanceTotal: InventoryLocation.count() ]
+        def associatedPropertyMax = 1000
+        def associatedPropertyValues = [:]
+        def inventoryStoreNameQuery = 'select distinct a.name from InventoryStore a where a.isActive = ? order by a.name'
+        associatedPropertyValues.inventoryStoreList = InventoryStore.executeQuery(inventoryStoreNameQuery, [true], [max:associatedPropertyMax])
+
+        if(!params.filter) {
+            return [inventoryLocationInstanceList: InventoryLocation.list(params),
+                    inventoryLocationInstanceTotal: InventoryLocation.count(),
+                    associatedPropertyValues: associatedPropertyValues,
+                    filterParams: params]
+        }
+
+        // filterPane:
+        return[ inventoryLocationInstanceList: filterService.filter( params, InventoryLocation ),
+                inventoryLocationInstanceTotal: filterService.count( params, InventoryLocation ),
+                associatedPropertyValues: associatedPropertyValues,
+                filterParams: com.zeddware.grails.plugins.filterpane.FilterUtils.extractFilterParams(params),
+                params:params ]
     }
 
@@ -74 +93 @@
                 def version = params.version.toLong()
                 if(inventoryLocationInstance.version > version) {
-                    
+
                     inventoryLocationInstance.errors.rejectValue("version", "default.optimistic.locking.failure")
                     render(view:'edit',model:[inventoryLocationInstance:inventoryLocationInstance])