Changeset 688

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.

Location:

trunk/grails-app

Files:

• controllers/AppCoreController.groovy (modified) (2 diffs)
• services/AssetService.groovy (modified) (2 diffs)
• services/AssetSubItemService.groovy (modified) (3 diffs)
• services/CreateDataService.groovy (modified) (1 diff)
• views/appCore/appAdmin.gsp (modified) (1 diff)

trunk/grails-app/controllers/AppCoreController.groovy

@@ -9 +9 @@
 
     def authService
+    def assetService
     def appConfigService
     def createDataService
     def searchableService
+    def assetSubItemService
     def createBulkDataService
 
@@ -269 +271 @@
     }
 
+    /**
+    * Allow admin to create recommended extended attributes for assets.
+    */
+    @Secured(['ROLE_AppAdmin'])
+    def createRecommendedAssetExtendedAttributes = {
+        def result = assetService.createRecommendedExtendedAttributes()
+        if(!result.error) {
+            flash.message = g.message(code:"default.create.success", args:["Extended attributes created", ''])
+            redirect(action: appAdmin)
+            return
+        }
+
+        flash.errorMessage = g.message(code: result.error.code, args: result.error.args)
+        redirect(action: appAdmin)
+    }
+
+    /**
+    * Allow admin to create recommended extended attributes for level 1 assetSubItems.
+    */
+    @Secured(['ROLE_AppAdmin'])
+    def createRecommendedAssetSubItemExtendedAttributes = {
+        def result = assetSubItemService.createRecommendedExtendedAttributes()
+        if(!result.error) {
+            flash.message = g.message(code:"default.create.success", args:["Extended attributes created", ''])
+            redirect(action: appAdmin)
+            return
+        }
+
+        flash.errorMessage = g.message(code: result.error.code, args: result.error.args)
+        redirect(action: appAdmin)
+    }
+
 } // end of class.

trunk/grails-app/services/AssetService.groovy

@@ -5 +5 @@
 
     boolean transactional = false
+
+    def sessionFactory
 
     def assetSubItemService
@@ -235 +237 @@
     } // end saveCopySrvce
 
+    /**
+    * Create recommended extended attributes for all assets.
+    */
+    def createRecommendedExtendedAttributes() {
+        def result = [:]
+
+        def hibernateSession = sessionFactory.currentSession
+
+        def assets = Asset.list()
+        def locationDescription = ExtendedAttributeType.get(5)
+        def ecr = ExtendedAttributeType.get(9)
+        def assetNumber = ExtendedAttributeType.get(17)
+        def assetCondition = ExtendedAttributeType.get(16)
+        def maintenancePercentComplete = ExtendedAttributeType.get(13)
+        def registrationRequired = ExtendedAttributeType.get(14)
+        def registrationExpiryDate =  ExtendedAttributeType.get(15)
+        def regulatoryRequirement = ExtendedAttributeType.get(12)
+        def riskLevel = ExtendedAttributeType.get(10)
+        def safeWorkProcedure = ExtendedAttributeType.get(11)
+
+        for(asset in assets) {
+
+            def attributeTypes = asset.assetExtendedAttributes.collect {it.extendedAttributeType}
+
+            //AssetExtendedAttribute
+            def assetExtendedAttributeInstance
+
+            if(!attributeTypes.contains(locationDescription)) {
+                //AssetExtendedAttribute #1
+                assetExtendedAttributeInstance = new AssetExtendedAttribute(value: "Not Specified",
+                                                                                                                    asset: asset,
+                                                                                                                    extendedAttributeType: locationDescription)
+                assetExtendedAttributeInstance.save()
+            }
+
+            if(!attributeTypes.contains(ecr)) {
+                //AssetExtendedAttribute #2
+                assetExtendedAttributeInstance = new AssetExtendedAttribute(value: "Not Specified",
+                                                                                                                    asset: asset,
+                                                                                                                    extendedAttributeType: ecr)
+                assetExtendedAttributeInstance.save()
+            }
+
+            if(!attributeTypes.contains(assetNumber)) {
+                //AssetExtendedAttribute #3
+                assetExtendedAttributeInstance = new AssetExtendedAttribute(value: "Not Specified",
+                                                                                                                    asset: asset,
+                                                                                                                    extendedAttributeType: assetNumber)
+                assetExtendedAttributeInstance.save()
+            }
+
+            if(!attributeTypes.contains(assetCondition)) {
+                //AssetExtendedAttribute #4
+                assetExtendedAttributeInstance = new AssetExtendedAttribute(value: "Not Specified",
+                                                                                                                    asset: asset,
+                                                                                                                    extendedAttributeType: assetCondition)
+                assetExtendedAttributeInstance.save()
+            }
+
+            if(!attributeTypes.contains(maintenancePercentComplete)) {
+                //AssetExtendedAttribute #5
+                assetExtendedAttributeInstance = new AssetExtendedAttribute(value: "TBA",
+                                                                                                                    asset: asset,
+                                                                                                                    extendedAttributeType: maintenancePercentComplete)
+                assetExtendedAttributeInstance.save()
+            }
+
+            if(!attributeTypes.contains(registrationRequired)) {
+                //AssetExtendedAttribute #6
+                assetExtendedAttributeInstance = new AssetExtendedAttribute(value: "Not Specified",
+                                                                                                                    asset: asset,
+                                                                                                                    extendedAttributeType: registrationRequired)
+                assetExtendedAttributeInstance.save()
+            }
+
+            if(!attributeTypes.contains(registrationExpiryDate)) {
+                //AssetExtendedAttribute #7
+                assetExtendedAttributeInstance = new AssetExtendedAttribute(value: "Not Specified",
+                                                                                                                    asset: asset,
+                                                                                                                    extendedAttributeType:registrationExpiryDate)
+                assetExtendedAttributeInstance.save()
+            }
+
+            if(!attributeTypes.contains(regulatoryRequirement)) {
+                //AssetExtendedAttribute #8
+                assetExtendedAttributeInstance = new AssetExtendedAttribute(value: "Not Specified",
+                                                                                                                    asset: asset,
+                                                                                                                    extendedAttributeType: regulatoryRequirement)
+                assetExtendedAttributeInstance.save()
+            }
+
+            if(!attributeTypes.contains(riskLevel)) {
+                //AssetExtendedAttribute #9
+                assetExtendedAttributeInstance = new AssetExtendedAttribute(value: "Not Specified",
+                                                                                                                    asset: asset,
+                                                                                                                    extendedAttributeType: riskLevel)
+                assetExtendedAttributeInstance.save()
+            }
+
+            if(!attributeTypes.contains(safeWorkProcedure)) {
+                //AssetExtendedAttribute #10
+                assetExtendedAttributeInstance = new AssetExtendedAttribute(value: "Not Specified",
+                                                                                                                    asset: asset,
+                                                                                                                    extendedAttributeType: safeWorkProcedure)
+                assetExtendedAttributeInstance.save()
+            }
+
+            hibernateSession.flush()
+
+        } // for
+
+        // Success.
+        return result
+
+    } // createRecommendedExtendedAttributes()
+
 } // end class

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

trunk/grails-app/services/CreateDataService.groovy

@@ -1425 +1425 @@
 
         //Section #1
-        sectionInstance = new Section(name: "Press",
+        sectionInstance = new Section(name: "A-Press",
                                                                 description: "Press Section",
                                                                 site: Site.get(3),

trunk/grails-app/views/appCore/appAdmin.gsp

@@ -49 +49 @@
                                 </g:else>
 
+                                <br />
+                                <br />
+
+                                <g:link action="createRecommendedAssetExtendedAttributes">Asset Extended Attributes</g:link> - Create recommended extended attributes for assets.
+                                <br />
+                                <g:link action="createRecommendedAssetSubItemExtendedAttributes">Sub Asset Extended Attributes</g:link> - Create recommended extended attributes for level 1 sub assets.
+
                             </td>
                         </tr>