Changeset 489 for trunk/grails-app/services/InventoryItemSearchService.groovy

Timestamp:

Apr 16, 2010, 2:10:52 PM (14 years ago)

Author:

gav

Message:

Add recentlyUsed inventoryItem quick search.

File:

• trunk/grails-app/services/InventoryItemSearchService.groovy (modified) (4 diffs)

trunk/grails-app/services/InventoryItemSearchService.groovy

@@ +1 @@
+import grails.orm.PagedResultList
+
 /**
 * Service class that encapsulates the business logic for InventoryItem searches.
@@ -6 +8 @@
     boolean transactional = false
 
+    def dateUtilService
     def messageSource
 
@@ -37 +40 @@
                 else
                     result.message = getMessage(code:"inventoryItem.search.text.below.reorder.none.found")
+                break
+            case "recentlyUsed":
+                result.daysBack = params.daysBack?.isInteger() ? params.daysBack.toInteger() : 14
+                result.inventoryItemList = getRecentlyUsed(params, result.daysBack)
+                if(result.inventoryItemList.totalCount > 0)
+                    result.message = getMessage(code:"inventoryItem.search.text.recently.used.description", args:[result.daysBack])
+                else
+                    result.message = getMessage(code:"inventoryItem.search.text.recently.used.none.found", args:[result.daysBack])
                 break
             default:
@@ -93 +104 @@
     } // getInventoryBelowReorder
 
+    /**
+    * Get a list of recently used inventory items.
+    * @param params The request params.
+    * @param daysBack The number of days back to get results for.
+    */
+    def getRecentlyUsed(params, daysBack) {
+        def paginateParams = [:]
+        paginateParams.max = Math.min(params?.max?.toInteger() ?: 10, paramsMax)
+        paginateParams.offset = params?.offset?.toInteger() ?: 0
+
+        def sort = "inventoryItem." + (params?.sort ?: "name")
+        def order = params?.order == "desc" ? "desc" : "asc"
+        def orderBy = " order by " + sort + ' ' + order
+
+        def namedParams = [:]
+        namedParams.startOfDay = dateUtilService.today - daysBack
+
+        def baseQuery = "from InventoryItem as inventoryItem \
+                                        left join inventoryItem.inventoryMovements as inventoryMovement \
+                                        where (inventoryItem.isActive = true \
+                                                    and inventoryMovement.date > :startOfDay \
+                                                    and inventoryMovement.inventoryMovementType = 1 \
+                                                    )"
+
+        def searchQuery = "select distinct inventoryItem " + baseQuery + orderBy
+        def list = InventoryItem.executeQuery(searchQuery, namedParams, paginateParams)
+
+        def countQuery = "select count(distinct inventoryItem) as inventoryItemCount " + baseQuery
+        def totalCount = InventoryItem.executeQuery(countQuery, namedParams)[0].toInteger()
+
+        def inventoryItemInstanceList = new PagedResultList(list, totalCount)
+        return inventoryItemInstanceList
+    } // getRecentlyUsed
+
 } // end class