Changeset 599 for trunk/grails-app/domain

Timestamp:

Jun 18, 2010, 3:58:43 PM (15 years ago)

Author:

gav

Message:

Implement InventoryItemPurchase custom constraint as per ticket #74, unique purchaseOrderNumber for an inventoryItem order.

File:

• trunk/grails-app/domain/InventoryItemPurchase.groovy (modified) (1 diff)

trunk/grails-app/domain/InventoryItemPurchase.groovy

@@ -22 +22 @@
     static constraints = {
         quantity(min:0)
-        purchaseOrderNumber(blank:false, maxSize:50)
+        purchaseOrderNumber(blank:false, maxSize:50, validator: {val, obj ->
+            // For orders the purchaseOrderNumber must be unique for an inventoryItem.
+            if(obj.inventoryItemPurchaseType.id == 1L) {
+                def list = InventoryItemPurchase.withCriteria {
+                    eq('inventoryItem', obj.inventoryItem)
+                    eq('purchaseOrderNumber', obj.purchaseOrderNumber)
+                    eq('inventoryItemPurchaseType', obj.inventoryItemPurchaseType)
+                    if(obj.id)
+                        notEqual('id', obj.id)
+                }
+                if(list.size() > 0)
+                    return 'not.unique.for.inventory.item.order'
+            }
+            // Success.
+            return true
+        })
         invoiceNumber(maxSize:50)
         orderValueAmount(max: new BigDecimal(1000000000000))