Changeset 485

Timestamp:

Apr 13, 2010, 12:37:51 PM (14 years ago)

Author:

gav

Message:

Add inventory item quick search (items below reorder) and remember user's search in session.

Location:

trunk/grails-app

Files:

• controllers/InventoryItemDetailedController.groovy (modified) (8 diffs)
• i18n/messages.properties (modified) (2 diffs)
• services/InventoryItemSearchService.groovy (added)
• views/inventoryItemDetailed/search.gsp (modified) (2 diffs)

trunk/grails-app/controllers/InventoryItemDetailedController.groovy

@@ -1 +1 @@
 import org.codehaus.groovy.grails.plugins.springsecurity.Secured
 import org.codehaus.groovy.grails.commons.ConfigurationHolder
+import com.zeddware.grails.plugins.filterpane.FilterUtils
+import org.springframework.web.servlet.support.RequestContextUtils as RCU
 
 @Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager'])
@@ -9 +11 @@
     def inventoryCsvService
     def inventoryItemService
+    def inventoryItemSearchService
     def inventoryMovementService
 
@@ -114 +117 @@
     }
 
+    /**
+    * Search for Inventory items.
+    */
     @Secured(['ROLE_AppAdmin', 'ROLE_Manager', 'ROLE_InventoryManager', 'ROLE_InventoryUser'])
     def search = {
@@ -120 +126 @@
             params.max = session.inventoryItemSearchParamsMax
 
-        params.max = Math.min( params.max ? params.max.toInteger() : 10,  100)
+        // Protect filterPane.
+        params.max = Math.min( params.max ? params.max.toInteger() : 10,  1000)
 
         def inventoryItemInstanceList = []
         def inventoryItemInstanceTotal
-        def filterParams = [:]
-
-        // Quick Search:
-        if(!params.filter) {
-            inventoryItemInstanceList = InventoryItem.list( params )
-            inventoryItemInstanceTotal = InventoryItem.count()
-            filterParams = params
-        }
-        else {
-        // filterPane:
+        def filterParams = com.zeddware.grails.plugins.filterpane.FilterUtils.extractFilterParams(params)
+        def isFilterApplied = FilterUtils.isFilterApplied(params)
+
+        // Restore search unless a new search is being requested.
+        if(!params.quickSearch && !filterParams) {
+            if(session.inventoryItemQuickSearch)
+                params.quickSearch = session.inventoryItemQuickSearch
+            else if(session.inventoryItemSearchFilterParams) {
+                session.inventoryItemSearchFilterParams.each() { params[it.key] = it.value }
+                params.filter = session.inventoryItemSearchFilter
+                isFilterApplied = FilterUtils.isFilterApplied(params)
+            }
+        }
+
+        // Remember sort if supplied, otherwise try to restore.
+        if(params.sort && params.order) {
+             session.inventoryItemSearchSort = params.sort
+             session.inventoryItemSearchOrder = params.order
+        }
+        else if(session.inventoryItemSearchSort && session.inventoryItemSearchOrder) {
+            params.sort = session.inventoryItemSearchSort
+            params.order = session.inventoryItemSearchOrder
+        }
+
+        if(isFilterApplied) {
+            // filterPane:
             inventoryItemInstanceList = filterService.filter( params, InventoryItem )
             inventoryItemInstanceTotal = filterService.count( params, InventoryItem )
             filterParams = com.zeddware.grails.plugins.filterpane.FilterUtils.extractFilterParams(params)
+            // Remember search.
+            session.inventoryItemSearchFilterParams = new LinkedHashMap(filterParams)
+            session.inventoryItemSearchFilter = new LinkedHashMap(params.filter)
+            session.inventoryItemQuickSearch = null
+        }
+        else {
+            // Quick Search:
+            if(!params.quickSearch) params.quickSearch = "all"
+            def result = inventoryItemSearchService.getQuickSearch(params, RCU.getLocale(request))
+            inventoryItemInstanceList = result.inventoryItemList
+            inventoryItemInstanceTotal = result.inventoryItemList.totalCount
+            params.message = result.message
+            filterParams.quickSearch = result.quickSearch
+            // Remember search.
+            session.inventoryItemSearchFilterParams = null
+            session.inventoryItemSearchFilter = null
+            session.inventoryItemQuickSearch = result.quickSearch
         }
 
@@ -145 +185 @@
                 formatDate(format: "EEE, dd-MMM-yyyy", date: date)
             }
-            String title = "Inventory List."
+
+            String title
+            if(params.quickSearch)
+                title = params.message
+            else
+                title = "Filtered Inventory List."
 
             response.contentType = ConfigurationHolder.config.grails.mime.types[params.format]
@@ -152 +197 @@
                                 "description",
                                 "unitsInStock",
+                                "reorderPoint",
                                 "unitOfMeasure",
                                 "inventoryLocation",
@@ -158 +204 @@
                                 "description": "Description",
                                 "unitsInStock":"In Stock",
+                                "reorderPoint":"Reorder Point",
                                 "unitOfMeasure": "UOM",
                                 "inventoryLocation": "Location",
@@ -177 +224 @@
         filterParams.max = params.max
         filterParams.offset = params.offset?.toInteger() ?: 0
-        filterParams.sort = params.sort ?: "id"
-        filterParams.order = params.order ?: "desc"
+        filterParams.sort = params.sort ?: "name"
+        filterParams.order = params.order ?: "asc"
 
         return[ inventoryItemInstanceList: inventoryItemInstanceList,
                 inventoryItemInstanceTotal: inventoryItemInstanceTotal,
-                filterParams: filterParams ]
+                filterParams: filterParams,
+                params: params ]
     } // end search()
 

trunk/grails-app/i18n/messages.properties

@@ -200 +200 @@
 default.options.text=Options
 default.none.text=None
+default.all.text=All
 
 # Rich UI plugin - Calendar
@@ -287 +288 @@
 task.search.text.planners.range.none.found=No tasks found in the past week or two weeks ahead.
 task.search.calendar.text.too.many.results=Too many results, only {0} are shown.
+
+# InventoryItemSearch
+inventoryItem.search.text.below.reorder=Bellow Reorder
+inventoryItem.search.text.below.reorder.description=Inventory items at or below reorder point, with reorder enabled.
+inventoryItem.search.text.below.reorder.all=Below Reorder (all)
+inventoryItem.search.text.below.reorder.all.description=Inventory items at or below reorder point, including reorder disabled.
+inventoryItem.search.text.below.reorder.none.found=No inventory items found at or below reorder point.
+inventoryItem.search.text.all.description=All inventory items.
+inventoryItem.search.text.all.none.found=No inventory items found.

trunk/grails-app/views/inventoryItemDetailed/search.gsp

@@ -197 +197 @@
                         <tr class="prop">
                             <td valign="top" class="name">
+                                <label>Inventory:</label>
+                            </td>
+                            <td valign="top" class="value">
+                                <g:link controller="inventoryItemDetailed"
+                                                action="search"
+                                                params="[quickSearch: 'all']">
+                                                <g:message code="default.all.text" />
+                                </g:link>
+                                <br />
+                                <g:link controller="inventoryItemDetailed"
+                                                action="search"
+                                                params="[quickSearch: 'inventoryBelowReorder']">
+                                                <g:message code="inventoryItem.search.text.below.reorder" />
+                                </g:link> - <g:message code="inventoryItem.search.text.below.reorder.description" />
+                                <br />
+                                <g:link controller="inventoryItemDetailed"
+                                                action="search"
+                                                params="[quickSearch: 'inventoryBelowReorderAll']">
+                                                <g:message code="inventoryItem.search.text.below.reorder.all" />
+                                </g:link> - <g:message code="inventoryItem.search.text.below.reorder.all.description" />
+                            </td>
+                        </tr>
+
+                        <tr class="prop">
+                            <td valign="top" class="name">
                                 <label>Links:</label>
                             </td>
@@ -204 +229 @@
                                                 Purchases
                                 </g:link>
-                                <br />
                             </td>
                         </tr>