Grails Brasil

Relatorios com Export Plugin

19/08/2014 22:38

Dúvida galera!!!
Criando relatórios com este plugin: http://grails.org/plugin/export#Abstract
Ao clicar no link ele renderiza os dados na url quando se trata de xml (http://localhost:8080/Panel/user/index?format=xml&extension=xml), mas quando se trata de ods,xls ,pdf etc ele nao mostra nada!!!

Eu queria que ao clicar o usuario pudesse realizar o download do arquivo com o formato escolhido.

Tags: Relatorios , Export Plugin,PDF, Excel, XML

E ai galera!!!!

Alguém pode me ajudar???

20/08/2014 14:28

wander arce

(14)

Olá Wander,
Nunca usei este plugin, utilizo o jasper mas acredito que pode te ajudar tbm.
No meu caso bastou adicionar na controller o código abaixo


response.setContentType("application/pdf")
response.setHeader("Content-disposition", "attachment; filename=nomeDoArquivo.pdf")
response.outputStream << meuPDF;

veja se lhe pode ser útil.

20/08/2014 15:51

Dyego Mota

(638)

Olá Dyego,

Tentei realizar conforme me passou, porém permanece da mesma forma. O código abaixo alterei conforme me passou!!!

def list = {
if(!params.max) params.max = 10

if(params?.format && params.format != "html"){
if(params?.format=='pdf'){
response.setContentType("aplication/pdf")
response.outputStream<< users.${params.extension}

}else if(params?.format=='excel'){
response.setContentType("aplication/xls")
response.outputStream<< users.${params.extension}
}else if(params?.format=='ods'){
response.setContentType("aplication/ods")
response.outputStream<< users.${params.extension}
}else if(params?.format=='rtf'){
response.setContentType("aplication/rtf")
response.outputStream<< users.${params.extension}
}else{
response.setContentType("aplication/xml")
response.outputStream<< users.${params.extension}
}
response.setHeader("Content-disposition", "attachment: filename=users.${params.extension}")

List fields = ["username", "enable"]
Map labels = ["username": "Username", "enable": "Enable"]

/* Formatter closure in previous releases
def upperCase = { value ->
return value.toUpperCase()
}*/

exportService.export(params.format, response.outputStream , User.list(params), fields, labels, formatters, parameters)
}

[ userInstance.list( params ) ]

}

20/08/2014 17:23

wander arce

(14)

Bom...
Acredito que falte algum detalhe apenas pois o dados estão sendo carregados normalmente no xml conforme abaixo:

==================================================================================================

<list>
<user id="1">
<accountExpired>false</accountExpired>
<accountLocked>false</accountLocked>
<enabled>true</enabled>
<password>
$2a$10$6RX6NeZH4aqJN4qGCV5NdOJEjiQRRhwI7F1SPes1eM52dsTN04fOi
</password>
<passwordExpired>false</passwordExpired>
<username>wander</username>
</user>
<user id="2">
<accountExpired>false</accountExpired>
<accountLocked>false</accountLocked>
<enabled>true</enabled>
<password>
$2a$10$8AdqTZSeR5XOM0OgA.WmSO/G9FB7HKHAz94QN6sJsVNT.bkIHEvPO
</password>
<passwordExpired>false</passwordExpired>
<username>Admin</username>
</user>
<user id="3">
<accountExpired>false</accountExpired>
<accountLocked>false</accountLocked>
<enabled>true</enabled>
<password>
$2a$10$SG7gtluxv6bjRo0AK.Ve4ukR3AiHnOzohLMJZ9vALrUlw3kB6gKK.
</password>
<passwordExpired>false</passwordExpired>
<username>Novo teste</username>
</user>
</list>

20/08/2014 19:25

wander arce

(14)