Changeset 1425 for trunk/grails-app/controllers

Timestamp:

Jan 21, 2011, 4:37:54 PM (10 years ago)

Author:

s.h.sikkema@…

Message:

Rudimentary assay export functionality

File:

• trunk/grails-app/controllers/dbnp/studycapturing/AssayController.groovy (modified) (1 diff)

trunk/grails-app/controllers/dbnp/studycapturing/AssayController.groovy

@@ -138 +138 @@
      */
     def exportAssayAsExcel = {
-        Assay assay = Assay.get(params.id)
+
+        Assay assay = Assay.get(params.assayId)
 
         if (!assay) {
-            flash.errorMessage = "No assay found with id: $params.id."
+            flash.errorMessage = "No assay found with id: $params.assayId."
             redirect action: 'selectAssay'
             return
         }
 
-        // TODO: refactor into service
+        try {
 
-        // Gather sample meta data from GSCF
-        def samples = assay.samples
+            def assayData = assayService.collectAssayData(assay, grailsApplication.config.modules.metabolomics.url)
 
-        def collectUsedTemplateFields = { templateEntityList ->
+            def filename = 'export.xlsx'
+            response.setHeader("Content-disposition", "attachment;filename=\"${filename}\"")
+            response.setContentType("application/octet-stream")
 
-            def templateFields = templateEntityList*.giveFields().flatten().unique().findAll{it}
-            def usedTemplateFields = templateFields.findAll{ tf ->
+            assayService.exportColumnWiseDataToExcelFile(assayData, response.outputStream)
 
-                templateEntityList.any { it.fieldExists(tf.name) && it.getFieldValue(tf.name) }
-            }
+        } catch (Exception e) {
 
-            def m = [:]
-            usedTemplateFields.each { tf ->
-                m["${tf.name}"] = templateEntityList.collect{ it.fieldExists(tf.name) ? it.getFieldValue(tf.name) : '' }
-            }
-            m
-        }
+            flash.errorMessage = e.toString()
+            redirect action: 'selectAssay'
 
-        // get all sample related subjects
-        def assayData = [
-                'Subject Data':         collectUsedTemplateFields(samples*.parentSubject.unique()),
-                'Sampling Event Data':  collectUsedTemplateFields(samples*.parentEvent.unique()),
-                'Event Data':           collectUsedTemplateFields(samples*.parentEventGroup.events.flatten().unique()),
-                'Sample Data':          collectUsedTemplateFields(samples)]
-
-        // Gather sample meta data from the module
-
-        // - sample metadata
-
-        // Gather measurement data from the module
-
-        // - measurements
-
-        // Write to excel
-
-        println assayData
-
-        try {
-            assayService.exportAssayDataAsExcelFile(assayData)
-        } catch (Exception e) {
-            flash.errorMessage = e.message
-            redirect action: 'selectAssay'
         }
     }