Changeset 1827 for trunk/grails-app/controllers/dbnp/studycapturing/AssayController.groovy

Timestamp:

May 9, 2011, 4:39:18 PM (11 years ago)

Author:

s.h.sikkema@…

Message:

added different assay export possibilities (tab delimited, csv (comma and semicolon);

File:

• trunk/grails-app/controllers/dbnp/studycapturing/AssayController.groovy (modified) (4 diffs)

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

@@ -171 +171 @@
                                 }
 
+                // collect the assay data according to user selecting
                                 def assayData           = assayService.collectAssayData(flow.assay, fieldMapSelection, measurementTokens)
                                 flow.rowData            = assayService.convertColumnToRowStructure(assayData)
 
+                // prepare the assay data preview
                                 def previewRows         = Math.min(flow.rowData.size()    as int, 5) - 1
                                 def previewCols         = Math.min(flow.rowData[0].size() as int, 5) - 1
@@ -179 +181 @@
                                 flow.assayDataPreview   = flow.rowData[0..previewRows].collect{ it[0..previewCols] as ArrayList }
 
+                // store the selected file type in the flow
+                flow.exportFileType = params.exportFileType
+
                         }.to "compileExportData"
 
@@ -185 +190 @@
 
                 compileExportData {
-                        on ("ok"){session.rowData = flow.rowData}.to "export"
+                        on ("ok"){
+                session.rowData = flow.rowData
+                session.exportFileType = flow.exportFileType
+            }.to "export"
                         on ("cancel").to "selectAssay"
                 }
@@ -204 +212 @@
         def doExport = {
 
-                def filename = 'export.csv'
+        // make sure we're coming from the export flow, otherwise redirect there
+        if (!(session.rowData && session.exportFileType))
+            redirect(action: 'assayExportFlow')
+
+        // process requested output file type
+        def outputDelimiter, outputFileExtension
+
+        switch(session.exportFileType) {
+            case 2: // Comma delimited csv
+                outputDelimiter = ','
+                outputFileExtension = '.csv'
+                break
+            case 3: // Semicolon delimited csv
+                outputDelimiter = ';'
+                outputFileExtension = '.csv'
+                break
+            default: // Tab delimited with .txt extension
+                outputDelimiter = '\t'
+                outputFileExtension = '.txt'
+        }
+
+                def filename = "export.$outputFileExtension"
                 response.setHeader("Content-disposition", "attachment;filename=\"${filename}\"")
                 response.setContentType("application/octet-stream")
                 try {
 
-                        //                      assayService.exportRowWiseDataToExcelFile(session.rowData, response.outputStream)
-                        assayService.exportRowWiseDataToCSVFile(session.rowData, response.outputStream)
+                        // assayService.exportRowWiseDataToExcelFile(session.rowData, response.outputStream)
+                        assayService.exportRowWiseDataToCSVFile(session.rowData, response.outputStream, outputDelimiter)
 
                         // clear the data from the session
                         session.removeAttribute('rowData')
+                        session.removeAttribute('exportFileType')
 
                 } catch (Exception e) {