Gerar Report
30/09/2014 22:49
<g:form url="[action:'createReport']" >
<div class="fieldcontain required">
<label for="startDate">
<g:message code="freight.startDate.label" default="Start Date" />
</label>
<calendar:datePicker name="startDate" dateFormat="%d/%m/%Y" years="1900,2099" />
</div>
<div class="fieldcontain required">
<label for="endDate">
<g:message code="freight.endDate.label" default="End Date" />
</label>
<calendar:datePicker name="endDate" dateFormat="%d/%m/%Y" years="1900,2099" />
</div>
<input type="hidden" name="_format" value="PDF"/>
<input type="hidden" name="dataHora" value=""/>
<input type="hidden" name="_file" value="relatorio_frete"/>
<input type="hidden" name="realPath" value="${realPath}"/><br>
<fieldset class="buttons">
<g:submitButton name="createReport" class="report pdf" value="${message(code: 'freight.button.create.label', default: 'Generate Report')}" />
</fieldset>
</g:form>
/* formatas a data para o formato dd/mm/yyyy */
dtStart= formatter.parse(params.startDate_value)
params.startDate = formatter.format(dtStart)
dtEnd = formatter.parse(params.endDate_value)
params.endDate = formatter.format(dtEnd)
def results = Delivery.withCriteria {
between("expectedDate", dtStart, dtEnd)
}
ArrayList bean = new ArrayList()
for(result in results){
BeanFreight beanFreight = new BeanFreight()
beanFreight.data = formatter.format(result.expectedDate)
beanFreight.cidadeOrigem = result.dispatcherPlace
beanFreight.cidadeDestino = result.receiverPlace
beanFreight.valorFrete = moneyMask.format(result.freightValue?:0.00).toString()
beanFreight.transportador = result.transporter
bean.add(beanFreight)
}
chain(controller:'jasper',action:'index', model:[data:bean],params:params)
Para se registrar, clique aqui.