Changeset 165 for trunk

Timestamp:

Oct 23, 2009, 1:00:23 PM (15 years ago)

Author:

gav

Message:

Install export plugin.
Add budget 'planned' and 'unplanned' search view.

Location:

trunk

Files:

• application.properties (modified) (1 diff)
• grails-app/conf/Config.groovy (modified) (1 diff)
• grails-app/controllers/TaskDetailedController.groovy (modified) (3 diffs)
• grails-app/services/TaskSearchService.groovy (modified) (1 diff)
• grails-app/views/appCore/manager.gsp (modified) (1 diff)
• grails-app/views/taskDetailed/budget.gsp (added)

trunk/application.properties

@@ -1 +1 @@
 #utf-8
-#Mon Oct 12 09:03:21 EST 2009
+#Fri Oct 23 11:43:54 EST 2009
+plugins.export=0.4
 plugins.acegi=0.5.1
 plugins.navigation=1.1

trunk/grails-app/conf/Config.groovy

@@ -19 +19 @@
                       css: 'text/css',
                       csv: 'text/csv',
+                      pdf: 'application/pdf',
+                      rtf: 'application/rtf',
+                      excel: 'application/vnd.ms-excel',
+                      ods: 'application/vnd.oasis.opendocument.spreadsheet',
                       all: '*/*',
                       json: ['application/json','text/json'],

trunk/grails-app/controllers/TaskDetailedController.groovy

@@ -1 +1 @@
 import org.codehaus.groovy.grails.plugins.springsecurity.Secured
+import org.codehaus.groovy.grails.commons.ConfigurationHolder
 
 class TaskDetailedController extends BaseController {
@@ -7 +8 @@
     def taskSearchService
     def filterService
+    def exportService
 
     // the delete, save and update actions only accept POST requests
@@ -102 +104 @@
         return[ taskInstanceList: filterService.filter( params, Task ),
             taskInstanceTotal: taskInstanceTotal,
+            filterParams: com.zeddware.grails.plugins.filterpane.FilterUtils.extractFilterParams(params),
+            params:params ]
+    }
+
+    def budget = {
+//         println params
+        params.max = Math.min( params.max ? params.max.toInteger() : 10,  100 )
+
+        // Quick Search:
+        if(!params.filter)
+        {
+            def taskInstanceList = []
+            def personInstance = Person.get(authenticateService.userDomain().id)
+
+            if(params.quickSearch == "budgetUnplanned") {
+                taskInstanceList = taskSearchService.getBudgetUnplanned(params)
+                if(taskInstanceList.totalCount > 0) { params.message = "Budget unplanned tasks in the last week." }
+                else { params.message = "No tasks found." }
+            }
+            //else if(params.quickSearch == "budgetPlanned") {
+            else {
+                //Default:
+                taskInstanceList = taskSearchService.getBudgetPlanned(params)
+                if(taskInstanceList.totalCount > 0) { params.message = "Budget planned Tasks in the last week." }
+                else { params.message = "No tasks found.." }
+            }
+            // export plugin:
+            if(params?.format && params.format != "html") {
+                response.contentType = ConfigurationHolder.config.grails.mime.types[params.format]
+                response.setHeader("Content-disposition", "attachment; filename=tasks.${params.extension}")
+                List fields = ["id", "targetStartDate", "description", "leadPerson", "taskStatus", "taskType"]
+                Map labels = ["id": "ID", "targetStartDate": "Target Start Date", "description": "Description",
+                                        "leadPerson": "Lead Person", "taskStatus": "Task Status", "taskType": "Task Type"]
+                Map formatters = [:]
+                String title = "${params.quickSearch} tasks in the last week."
+                Map parameters = [title: title]
+
+                exportService.export(params.format, response.outputStream, taskInstanceList, fields, labels, formatters, parameters) 
+            }
+            return[taskInstanceList: taskInstanceList, taskInstanceTotal: taskInstanceList.totalCount, filterParams: params]
+        }
+        // filterPane:
+        return[ taskInstanceList: filterService.filter( params, Task ),
+            taskInstanceTotal: filterService.count( params, Task ),
             filterParams: com.zeddware.grails.plugins.filterpane.FilterUtils.extractFilterParams(params),
             params:params ]

trunk/grails-app/services/TaskSearchService.groovy

@@ -76 +76 @@
             }
     }
+
+    def getBudgetPlanned(params) {
+        params.max = Math.min(params?.max?.toInteger() ?: 10, 100)
+        params.offset = params?.offset?.toInteger() ?: 0
+        params.sort = params?.sort ?: "id"
+        params.order = params?.order ?: "desc"
+
+        def taskInstanceList = Task.createCriteria().list(
+            max: params.max,
+            offset: params.offset,
+            sort: params.sort,
+            order: params.order) {
+                ne("taskType", TaskType.findByName("Unscheduled Breakin"))
+                ge("targetStartDate", dateUtilService.getToday()-7)
+                lt("targetStartDate", dateUtilService.getTomorrow())
+                eq("isActive", true)
+            }
+    }
+
+    def getBudgetUnplanned(params) {
+        params.max = Math.min(params?.max?.toInteger() ?: 10, 100)
+        params.offset = params?.offset?.toInteger() ?: 0
+        params.sort = params?.sort ?: "id"
+        params.order = params?.order ?: "desc"
+
+        def taskInstanceList = Task.createCriteria().list(
+            max: params.max,
+            offset: params.offset,
+            sort: params.sort,
+            order: params.order) {
+                eq("taskType", TaskType.findByName("Unscheduled Breakin"))
+                ge("targetStartDate", dateUtilService.getToday()-7)
+                lt("targetStartDate", dateUtilService.getTomorrow())
+                eq("isActive", true)
+            }
+    }
 }

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

@@ -29 +29 @@
                         <tr class="prop">
                             <td valign="top" class="name">
+                                <label>Budget:</label>
+                            </td>
+                            <td valign="top" class="value">
+                                <g:link controller="taskDetailed"
+                                                action="budget"
+                                                params="[quickSearch: 'budgetPlanned']">
+                                                Planned Tasks
+                                </g:link>
+                                <br />
+                                <g:link controller="taskDetailed" 
+                                                action="budget"
+                                                params="[quickSearch: 'budgetUnplanned']">
+                                                Unplanned Tasks
+                                </g:link>
+                            </td>
+                        </tr>
+
+                        <tr class="prop">
+                            <td valign="top" class="name">
                                 <label>Entity Relationship Diagram:</label>
                             </td>