Changeset 688 for trunk/grails-app/services/AssetSubItemService.groovy

Timestamp:

Oct 6, 2010, 4:23:46 AM (14 years ago)

Author:

gav

Message:

Add admin feature to create recommended extended attributes for assets and level 1 assetSubItems.

File:

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

trunk/grails-app/services/AssetSubItemService.groovy

@@ -1 +1 @@
 
+import net.kromhouts.HqlBuilder
 import org.apache.commons.lang.WordUtils
 
@@ -5 +6 @@
 
     boolean transactional = false
+
+    def sessionFactory
 
     /**
@@ -120 +123 @@
     } // save()
 
+    /**
+    * Get a list of level 1 assetSubItems.
+    * @returns By default all level 1 assetSubItems are returned.
+    */
+    def getLevel1AssetSubItems(params) {
+
+        // A result is returned for every level 1 assetSubItem.
+        def q = new HqlBuilder().query {
+            select 'assetSubItem'
+            from 'AssetSubItem assetSubItem',
+                    'inner join assetSubItem.assets as asset'
+            where 'asset != null' // ensure that only level 1 assetSubItems are returned.
+        }
+        def assetSubItems = AssetSubItem.executeQuery(q.query, q.namedParams)
+
+    }
+
+    /**
+    * Create recommended extended attributes for all level 1 subItems.
+    */
+    def createRecommendedExtendedAttributes() {
+        def result = [:]
+
+        def hibernateSession = sessionFactory.currentSession
+
+        def assetSubItems = getLevel1AssetSubItems()
+
+        def manufacturer = ExtendedAttributeType.get(8)
+        def modelNumber = ExtendedAttributeType.get(1)
+        def serialNumber = ExtendedAttributeType.get(3)
+        def manufacturedDate = ExtendedAttributeType.get(4)
+
+        for(assetSubItem in assetSubItems) {
+
+            def attributeTypes = assetSubItem.assetSubItemExtendedAttributes.collect {it.extendedAttributeType}
+
+            //AssetSubItemExtendedAttribute
+            def assetSubItemExtendedAttributeInstance
+
+            if(!attributeTypes.contains(manufacturer)) {
+                //AssetSubItemExtendedAttribute #1
+                assetSubItemExtendedAttributeInstance = new AssetSubItemExtendedAttribute(value: "Not Specified",
+                                                                                                                    assetSubItem: assetSubItem,
+                                                                                                                    extendedAttributeType: manufacturer)
+                assetSubItemExtendedAttributeInstance.save()
+            }
+
+            if(!attributeTypes.contains(modelNumber)) {
+                //AssetSubItemExtendedAttribute #2
+                assetSubItemExtendedAttributeInstance = new AssetSubItemExtendedAttribute(value: "Not Specified",
+                                                                                                                    assetSubItem: assetSubItem,
+                                                                                                                    extendedAttributeType: modelNumber)
+                assetSubItemExtendedAttributeInstance.save()
+            }
+
+            if(!attributeTypes.contains(serialNumber)) {
+                //AssetSubItemExtendedAttribute #3
+                assetSubItemExtendedAttributeInstance = new AssetSubItemExtendedAttribute(value: "Not Specified",
+                                                                                                                    assetSubItem: assetSubItem,
+                                                                                                                    extendedAttributeType: serialNumber)
+                assetSubItemExtendedAttributeInstance.save()
+            }
+
+            if(!attributeTypes.contains(manufacturedDate)) {
+                //AssetSubItemExtendedAttribute #4
+                assetSubItemExtendedAttributeInstance = new AssetSubItemExtendedAttribute(value: "Not Specified",
+                                                                                                                    assetSubItem: assetSubItem,
+                                                                                                                    extendedAttributeType: manufacturedDate)
+                assetSubItemExtendedAttributeInstance.save()
+            }
+
+            hibernateSession.flush()
+
+        } // for
+
+        // Success.
+        return result
+
+    } // createRecommendedExtendedAttributes()
+
 } // end class