Changeset 1035 for trunk

Timestamp:

Nov 1, 2010, 4:38:36 PM (12 years ago)

Author:

adem.bilican@…

Message:

SimpleTox? exporter with file downloading system

Location:

trunk/grails-app

Files:

• controllers/dbnp/exporter/ExporterController.groovy (modified) (2 diffs)
• views/exporter/index.gsp (modified) (1 diff)

trunk/grails-app/controllers/dbnp/exporter/ExporterController.groovy

@@ -88 +88 @@
 
         HSSFWorkbook wb = new HSSFWorkbook()
-        FileOutputStream fileOut = new FileOutputStream(studyInstance.title+"_SimpleTox.xls")
+        //FileOutputStream fileOut = new FileOutputStream(studyInstance.title+"_SimpleTox.xls")
 //        HSSFCellStyle style = wb.createCellStyle()
 //        style.setFillForegroundColor((short) HSSFColor.RED.index)
@@ -126 +126 @@
             sub.createCell((short)8).setCellValue(studyInstance.samples.getAt(s-1).parentSubject.species.name)
 
+            // adding the subject domain + template properties
             for (u in 0..studyInstance.samples.getAt(s-1).parentSubject.giveFields().unique().size()-1){
-                row.createCell((short)9+u).setCellValue(studyInstance.samples.getAt(s-1).parentSubject.giveFields().getAt(u).toString())
-//                println "VALUE "+studyInstance.samples.getAt(s-1).parentSubject.getFieldValue(u.name)
                 TemplateField tf = studyInstance.samples.getAt(s-1).parentSubject.giveFields().getAt(u)
-//                println tf.name
-//                println studyInstance.samples.getAt(s-1).parentSubject.giveFields().getAt(u)
                 row.createCell((short)9+u).setCellValue(tf.name)
                 studyInstance.samples.getAt(s-1).parentSubject.getFieldValue(tf.name) ? sub.createCell((short)9+u).setCellValue(studyInstance.samples.getAt(s-1).parentSubject.getFieldValue(tf.name).toString()) : "not define"
             }
 
+            // adding the samplingEvent domain + template properties
+            for (t in 0..studyInstance.samples.getAt(s-1).parentEvent.giveFields().unique().size()-1){
+                TemplateField tf = studyInstance.samples.getAt(s-1).parentEvent.giveFields().getAt(t)
+                row.createCell((short)9+studyInstance.samples.getAt(s-1).parentSubject.giveFields().unique().size()+t).setCellValue(tf.name)
+                studyInstance.samples.getAt(s-1).parentEvent.getFieldValue(tf.name) ? sub.createCell((short)9+studyInstance.samples.getAt(s-1).parentSubject.giveFields().unique().size()+t).setCellValue(studyInstance.samples.getAt(s-1).parentEvent.getFieldValue(tf.name).toString()) : "not define"
+            }
+
+            // adding samples domain + template properties
+            TemplateField sf = studyInstance.samples.getAt(s-1).giveFields().getAt(s)
+            //println studyInstance.samples.getAt(s-1).getFieldValue(sf.name)
+
+            // adding Event domaine + template properties
+
+
         }
+        //println "DOMAINS " +studyInstance.samples.getAt(s-1).parentSubject.giveFields()
 
-        //println "DOMAINS " +studyInstance.samples.getAt(s-1).parentSubject.giveFields()
+        //wb.write(fileOut)
+        //fileOut.close()
+
+        response.setHeader("Content-disposition", "attachment;filename=\"${studyInstance.title}_SimpleTox.xls\"")
+        response.setContentType("application/octet-stream")
+        wb.write(response.outputStream)
+        response.outputStream.close()
+
         
-        
-        wb.write(fileOut)
-        fileOut.close()
     }
 
+ 
 }

trunk/grails-app/views/exporter/index.gsp

@@ -78 +78 @@
     </div>
 
-    <div class="paginateButtons">
-        <g:paginate total="${studyInstanceTotal}" prev="&laquo; Previous" next="&raquo; Next" />
-        <br>
-        <INPUT TYPE=submit name=submit Value="Export">
+
+    <div class="paginateButtons" id="button">
     </div>
+
+<!--    <g:submitToRemote action="test" update="result" />-->
+
+<!--    <g:submitToRemote action="export" update="[success:'message',failure:'error']" />-->
+
+    <INPUT TYPE=submit name=submit Value="Export">
+
   </div>
+
+    <div id="result">  </div>
+
 </g:form>
+
 </body>
 </html>