Changeset 599 for trunk

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.

Location:

trunk/grails-app

Files:

• domain/InventoryItemPurchase.groovy (modified) (1 diff)
• i18n/messages.properties (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))

trunk/grails-app/i18n/messages.properties

@@ -175 +175 @@
 inventoryMovement.still.associated=Could not complete operation as inventory movements are still associated with this item.
 
+inventoryItemPurchase.purchaseOrderNumber.not.unique.for.inventory.item.order=Purchase Order Number must be unique for this inventory item order.
 inventoryItemPurchase.invoiceNumber.required=An invoice number must be supplied to approve payment.
 inventoryItemPurchase.delete.failure.received.exists=Could not delete, items have been received.