Changeset 535 for trunk/grails-app/services/TaskReportService.groovy

Timestamp:

May 16, 2010, 5:47:34 PM (14 years ago)

Author:

gav

Message:

Improvements to Reactive Ratio Report.

File:

• trunk/grails-app/services/TaskReportService.groovy (modified) (4 diffs)

trunk/grails-app/services/TaskReportService.groovy

@@ -24 +24 @@
         def result = [:]
 
-        def currentUser = authService.currentUser
-        def startOfToday = dateUtilService.today
-        def startOfYesterday = dateUtilService.yesterday
-        def startOfTomorrow = dateUtilService.tomorrow
-        def oneWeekAgo = dateUtilService.oneWeekAgo
-
-        def paginateParams = [:]
-        paginateParams.max = Math.min(params?.max?.toInteger() ?: 10, paramsMax)
-        paginateParams.offset = params?.offset?.toInteger() ?: 0
-
-        def sort = "task." + (params?.sort ?: "targetStartDate")
-        def order = params?.order == "desc" ? "desc" : "asc"
-        def orderBy = " order by " + sort + ' ' + order
-
         def namedParams = [:]
         namedParams.startDate = params.startDate ?: dateUtilService.today
-        namedParams.endDate = params.endDate ?: dateUtilService.tomorrow
+        namedParams.endDate = params.endDate ?: dateUtilService.today
+        namedParams.endDate++ // Start of next day required.
         namedParams.immediateCallout = TaskType.read(1)
         namedParams.unscheduledBreakin = TaskType.read(2)
         namedParams.preventativeMaintenance = TaskType.read(4)
+        namedParams.notStarted = TaskStatus.read(1)
 
         result.taskQuery = "from Task as task \
                                         where (task.trash = false \
+                                                    and task.taskStatus != :notStarted \
                                                     and task.targetStartDate < :endDate \
                                                     and task.targetStartDate >= :startDate \
@@ -56 +45 @@
                                         )"
 
-        result.taskQuery = "select distinct task " + result.taskQuery + orderBy
-        result.taskList = Task.executeQuery(result.taskQuery, namedParams, paginateParams)
+        result.taskQuery = "select distinct task " + result.taskQuery
+        result.taskList = Task.executeQuery(result.taskQuery, namedParams)
         result.taskCount = result.taskList.size()
 
         // Counts
-        result.totalTaskOnAssetCount = 0
+        result.totalAssetsOnTasksCount = 0
         result.immediateCalloutCount = 0
         result.unscheduledBreakinCount = 0
         result.preventativeMaintenanceCount = 0
 
-        // Count the tasks performed against assets.
+        result.summaryOfCalculationMethod = 'HQL query: \n\n'
+        def tempStringArray = result.taskQuery.split('    ')
+        tempStringArray.each() {
+            if(it != '') result.summaryOfCalculationMethod += it +'\n'
+        }
+        result.summaryOfCalculationMethod += '\n'+'Calculations: '+'\n\n'
+
+        result.summaryOfCalculationMethod += 'totalAssetsOnTasksCount = A count of unique assets on each task. \n'
         result.taskList.each() { task ->
             if(task.primaryAsset) {
-                result.totalTaskOnAssetCount++
+                result.totalAssetsOnTasksCount++
                 if(task.taskType == namedParams.immediateCallout) result.immediateCalloutCount++
                 if(task.taskType == namedParams.unscheduledBreakin) result.unscheduledBreakinCount++
@@ -76 +72 @@
             task.associatedAssets.each() { associatedAsset ->
                 if(associatedAsset.id != task.primaryAsset?.id) {
-                    result.totalTaskOnAssetCount++
+                    result.totalAssetsOnTasksCount++
                     if(task.taskType == namedParams.immediateCallout) result.immediateCalloutCount++
                     if(task.taskType == namedParams.unscheduledBreakin) result.unscheduledBreakinCount++
@@ -88 +84 @@
         result.totalPreventativePercentage = 0
 
+        result.summaryOfCalculationMethod += 'totalPreventativeCount = unscheduledBreakinCount + preventativeMaintenanceCount\n'
         result.totalPreventativeCount = result.unscheduledBreakinCount + result.preventativeMaintenanceCount
         try {
-            result.immediateCalloutPercentage = (result.immediateCalloutCount / result.totalTaskOnAssetCount)*100
-            result.immediateCalloutPercentage = result.immediateCalloutPercentage.toInteger()
-            result.totalPreventativePercentage = (result.totalPreventativeCount / result.totalTaskOnAssetCount)*100
-            result.totalPreventativePercentage = result.totalPreventativePercentage.toInteger()
+            result.summaryOfCalculationMethod += 'immediateCalloutPercentage = (immediateCalloutCount / totalAssetsOnTasksCount)*100 \n'
+            result.summaryOfCalculationMethod += 'totalPreventativePercentage = (totalPreventativeCount / totalAssetsOnTasksCount)*100 \n'
+            result.immediateCalloutPercentage = (result.immediateCalloutCount / result.totalAssetsOnTasksCount)*100
+            result.totalPreventativePercentage = (result.totalPreventativeCount / result.totalAssetsOnTasksCount)*100
         }
         catch(ArithmeticException e) {
+            log.error "Could not calculate percentages: "+e
         }