Changeset 441 for trunk/grails-app/services/InventoryItemService.groovy

Timestamp:

Mar 16, 2010, 12:00:04 PM (14 years ago)

Author:

gav

Message:

Add CostCode and InventoryItemPurchase domain classes with import features.
Includes some fixes to inventory imports, where manufacturer and supplier were crossed.

File:

• trunk/grails-app/services/InventoryItemService.groovy (modified) (3 diffs)

trunk/grails-app/services/InventoryItemService.groovy

@@ -28 +28 @@
     def show(params) {
         def result = [:]
+
         def fail = { Map m ->
             result.error = [ code: m.code, args: ["InventoryItem", params.id] ]
@@ -37 +38 @@
         if(!result.inventoryItemInstance)
             return fail(code:"default.not.found")
+
+        def p = [:]
+
+        if(params.paginate == "purchases") {
+            params.showTab = "showPurchasingTab"
+            p.max = Math.min(params.max?.toInteger() ?: 10, 100)
+            p.offset = params.offset?.toInteger() ?: 0
+            p.sort = params.sort ?: null
+            p.order = params.order ?: null
+        }
+        else {
+            p.max = 10
+            p.offset = 0
+        }
+
+        result.inventoryItemPurchasesTotal = InventoryItemPurchase.countByInventoryItem(result.inventoryItemInstance)
+
+        result.inventoryItemPurchases = InventoryItemPurchase.withCriteria {
+                eq("inventoryItem", result.inventoryItemInstance)
+                maxResults(p.max)
+                firstResult(p.offset)
+                // Sorting:
+                // Default is to sort by order number then id.
+                // When a sortable column is clicked then we sort by that.
+                // If the sortable column clicked is order number then we add id as the second sort.
+                if(p.sort && p.order) {
+                    order(p.sort, p.order)
+                    if(p.sort == "purchaseOrderNumber") order('id', 'asc')
+                }
+                else {
+                    order('purchaseOrderNumber', 'desc')
+                    order('id', 'asc')
+                }
+            }
 
         result.showTab = [:]
@@ -46 +81 @@
                 result.showTab.movement =  new String("true")
                 break
+            case "showPurchasingTab":
+                result.showTab.purchasing =  new String("true")
+                break
             default:
                 result.showTab.inventory = new String("true")
         }
 
-        def p = [:]
         p.max = result.inventoryMovementListMax = 10
+        p.offset = 0
         p.order = "desc"
         p.sort = "id"
         result.inventoryMovementList = InventoryMovement.findAllByInventoryItem(result.inventoryItemInstance, p)
         result.inventoryMovementListTotal = InventoryMovement.countByInventoryItem(result.inventoryItemInstance)
+
 
         // Success.