source: trunk/grails-app/controllers/dbnp/exporter/ExporterController.groovy @ 1000

/**
 * ExporterController Controler
 *
 * Description of my controller
 *
 * @author  your email (+name?)
 * @since       2010mmdd
 * @package     ???
 *
 * Revision information:
 * $Rev$
 * $Author$
 * $Date$
 */
package dbnp.exporter

import dbnp.studycapturing.*

import org.apache.poi.hssf.util.HSSFColor
import org.apache.poi.*
import org.apache.poi.hssf.usermodel.*
import org.apache.poi.poifs.filesystem.POIFSFileSystem
import org.apache.poi.ss.usermodel.DataFormatter

import grails.plugins.springsecurity.Secured

class ExporterController {

    def AuthenticationService
    def ImporterService

     /*
      * List of all studies for selection the study to export
      * Using the same code as 'list' into StudyController
      */
     def index = {

        def user = AuthenticationService.getLoggedInUser()
        def max = Math.min(params.max ? params.int('max') : 10, 100)

        def c = dbnp.studycapturing.Study.createCriteria()

        def studies
        if( user == null ) {
            studies = c.list {
                maxResults(max)
                and {
                    eq( "published", true )
                    eq( "publicstudy", true )
                }
            }
        } else {
            studies = c.list {
                maxResults(max)
                or {
                    eq( "owner", user )
                    writers {
                        eq( "id", user.id )
                    }
                    and {
                        readers {
                            eq( "id", user.id )
                        }
                        eq( "published", true )
                    }
                }
            }
        }
        [studyInstanceList: studies, studyInstanceTotal: studies.count()]
    }

    /* 
     * the export method will create a SimpleTox format for the selected study
     */
    def export = {
        def studyInstance

        // the attributes list for the SimpleTox format
        def attributes_list = ["SubjectID","DataFile","HybName","SampleName","ArrayType","Label","StudyTitle","Array_ID",
        "Species"]

        // Get the selected study
        for ( j in dbnp.studycapturing.Study.list() ){
            if (params.containsKey(j.title)){
                studyInstance = j
            }
        }

        HSSFWorkbook wb = new HSSFWorkbook()
        FileOutputStream fileOut = new FileOutputStream(studyInstance.title+"_SimpleTox.xls")
//        HSSFCellStyle style = wb.createCellStyle()
//        style.setFillForegroundColor((short) HSSFColor.RED.index)


        // The first row contains the attributes names
        HSSFSheet sheet = wb.createSheet()
        HSSFRow row     = sheet.createRow((short)0)
        for (i in 0..attributes_list.size()){
//            HSSFCell cell   = row.createCell((short)i)
//            cell.setCellValue(attributes_list[i])
//            cell.setCellStyle(style)
            row.createCell((short)i).setCellValue(attributes_list[i])
        }

        // Adding the next lines
        for (s in 1..studyInstance.samples.size()){
            // creating new line for every sample
            HSSFRow sub     = sheet.createRow((short)s)
            // adding subject name in row 1
            sub.createCell((short)0).setCellValue(studyInstance.samples.getAt(s-1).parentSubject.name)
            // adding sample in row 4
            sub.createCell((short)3).setCellValue(studyInstance.samples.getAt(s-1).name)
            // adding label (EventGroup) in row 6
            for (ev in EventGroup.list()){
                if (ev.subjects.name.contains(studyInstance.samples.getAt(s-1).parentSubject.name)) {
                    sub.createCell((short)5).setCellValue(ev.name)
                    break
                }
                else {
                    sub.createCell((short)5).setCellValue(" ")
                }
            }
            // adding study title in row 7
            sub.createCell((short)6).setCellValue(studyInstance.title)
            // Species row 9
            sub.createCell((short)8).setCellValue(studyInstance.samples.getAt(s-1).parentSubject.species.name)

            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"
            }

        }

        //println "DOMAINS " +studyInstance.samples.getAt(s-1).parentSubject.giveFields()
        
        
        wb.write(fileOut)
        fileOut.close()
    }

}