Changeset 669 for trunk/grails-app/services/InventoryReportService.groovy

Timestamp:

Oct 1, 2010, 6:04:29 PM (14 years ago)

Author:

gav

Message:

New report: Inventory Value, remove pictures due to JVM size limits and MSSQL bug when it tries to get distinct image.

File:

• trunk/grails-app/services/InventoryReportService.groovy (modified) (2 diffs)

trunk/grails-app/services/InventoryReportService.groovy

@@ -199 +199 @@
                     'left join fetch inventoryItem.inventoryLocation as inventoryLocation',
                     'left join fetch inventoryLocation.inventoryStore as inventoryStore',
-                    'left join fetch inventoryItem.unitOfMeasure as unitOfMeasure',
-                    'left join fetch inventoryItem.picture as picture',
-                    'left join fetch picture.images as Image'
+                    'left join fetch inventoryItem.unitOfMeasure as unitOfMeasure'
             where 'inventoryItem.isActive = true'
                 namedParams.siteId = result.site.id
@@ -226 +224 @@
                 break
             }
-            result.inventoryItemTotalValue += inventoryItem.estimatedUnitPriceAmount * inventoryItem.unitsInStock
+            if(inventoryItem.estimatedUnitPriceAmount && inventoryItem.unitsInStock) // Some items have null estimatedUnitPriceAmount.
+                result.inventoryItemTotalValue += inventoryItem.estimatedUnitPriceAmount * inventoryItem.unitsInStock
         } // for