Downloading documents in CSV and PDF formats using Jasper Reports

For downloading documents liferay supports jasper reports engine and one of the market place EE portlet like Reports portlet is also works on the same. To work with Reports EE portlet we should have jrxml and need to upload in to the definition to generate CSV and PDF formats or any other formats. So If you want to download any document in your custom portlet you need to write the code using Jasper Reports API for preparing document. For that we need to pass Jrxml file (Jasper Report xml file) and this creation of jrxml will be done using ireport designer tool. IReport designer tool: Install any latest version of ireport designer and create data source connection with MySql server details as shown in step1 of the tool. Once it is done next step is click on step2 link and in Report section select Blank A4 and click on button “Open this Template”. It will ask the file to save and those folder details. After this a new report will be created by opening with designer view: So this is the designer page here you can give the fields for display, headings, fonts ,styles and lines we can draw and we can add tables, sub reports using the elements in Right-hand side of Palette section. So here you can design the page in the way what we want and arrange those using designer. We can drag and drop the fields from Fields section from the “Report Inspector”. So now we have created successfully a report and its view as shown below: This jrxml will be saved in folder location you gave. Copy this jrxml and create one folder in docroot with the name as reports and save this file in this location (report1.jrxml) Use this jrxml and pass this file to the Jasper reports using below code:

private void generateReport(PortletRequest resourceRequest , PortletResponse response, Map parameters) throws IOException {

String fileType = ParamUtil.getString(resourceRequest, "fileType");

if(fileType != null && fileType != ""){

HttpServletResponse httpServletResponse = PortalUtil.getHttpServletResponse(response);

OutputStream outputStream = httpServletResponse.getOutputStream();

List invoicesList = new ArrayList();

try { invoicesList = InvoiceLocalServiceUtil.getInvoices(-1, -1);

} catch (SystemException e) { System.out.println("no list found");

} String path = getPortletContext().getRealPath("/reports/test_jasper.jrxml");

InputStream inputStream = new FileInputStream (path);

JRBeanCollectionDataSource beanColDataSource = new JRBeanCollectionDataSource(invoicesList);

byte[] contentArray = null;

try { JasperDesign jasperDesign = JRXmlLoader.load(inputStream);

JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, beanColDataSource);

if(fileType.equalsIgnoreCase("PDF")){

System.out.println("PDF calling");

contentArray = JasperExportManager.exportReportToPdf(jasperPrint);

httpServletResponse.setContentType("application/pdf");

httpServletResponse.setHeader("Content-Disposition","attachment;filename=test."+fileType);

outputStream.write(contentArray);

}else{

httpServletResponse.setContentType("text/csv");

JRCsvExporter exporter = new JRCsvExporter();

exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);

exporter.setParameter(JRCsvExporterParameter.FIELD_DELIMITER,";");

exporter.setParameter(JRCsvExporterParameter.RECORD_DELIMITER,"\r\n");

httpServletResponse.setHeader("Content-Disposition", "attachment;filename=testcsv.csv");

StringBuffer buffer = new StringBuffer();

exporter.setParameter(JRExporterParameter.OUTPUT_STRING_BUFFER, buffer);

exporter.exportReport();

outputStream.write(buffer.toString().getBytes());

httpServletResponse.flushBuffer();

} } catch (JRException e) {

e.printStackTrace();

System.out.println("data not found");

} outputStream.close();

}

}



Required jars for the above code is :

For preparing CSV document use the class JRCsvExporter and for PDF document use the class JasperExportManager. In above code for exporting document in to PDF and CSV formats the code has written. And remaining things are self-explanatory in the code. For downloading document we need to create OutputStream object and pass the appropriate MIME formats to the HttpServletResponse object. And from UI side I have created forms with two submit buttons “Generate CSV Report” and “Generate PDF Report”. While submitting the report I have created ResourceURL because the action we are doing here is ajax request because after downloading the document the page should not refresh. So I created liferay resource url and written serveResource() method implementation in controller side.

If we look on code in controller is : ExportReports.java

@Override public void serveResource(ResourceRequest resourceRequest, ResourceResponse response) throws IOException, PortletException {

String[] invoiceInfo = ParamUtil.getParameterValues(resourceRequest, "invoiceInfo");

generateReport(resourceRequest,response,putParameters(invoiceInfo));

} private Map putParameters(String[] invoiceInfo) {

Map parameters = new HashMap();

for(String selectedData : invoiceInfo){

selectedData = "show"+selectedData;

parameters.put(selectedData, Boolean.TRUE);

} return parameters;

}

We have completed our coding part and need to check it in application how is it working: downloaded csv file is :

Create site programmatically in Liferay

Create site programmatically in Liferay

This code does creates a site and adds site template to it...

1. It will reaad site name from portal-ext.properties file
2. It will get the site template already created from browser and then add this template to our newly created site.
3. It will get logo from the class path -WEB-INF/mylogo.png
4. It will place logo to our site..


@Override
public void doView(RenderRequest renderRequest,
RenderResponse renderResponse) throws IOException, PortletException {
System.out.println("view calling");

String customSiteName = PropsUtil.get("custom.site.name");
System.out.println("site name == "+customSiteName);

int publicLayoutSetPrototypeId = 0;
int privateLayoutSetPrototypeId =0;

try {
ServiceContext serviceContext =  ServiceContextFactory.getInstance(Group.class.getName(), renderRequest);

Group grp = null;
try {
grp = GroupServiceUtil.getGroup(serviceContext.getThemeDisplay().getCompanyId(), customSiteName);
} catch (Exception e) {

}

if(grp == null){

System.out.println("group created");
grp = GroupServiceUtil.addGroup(GroupConstants.DEFAULT_PARENT_GROUP_ID, GroupConstants.DEFAULT_LIVE_GROUP_ID, customSiteName, customSiteName+"description", GroupConstants.TYPE_SITE_OPEN,
true, GroupConstants.DEFAULT_MEMBERSHIP_RESTRICTION,
"/"+customSiteName, true, true, serviceContext);
}

System.out.println("site created.."+grp.getName());



List<LayoutSetPrototype> layoutSetPrototypes=LayoutSetPrototypeServiceUtil.search(serviceContext.getThemeDisplay().getCompanyId(),Boolean.TRUE, null);

for(LayoutSetPrototype layoutSetPrototype : layoutSetPrototypes){

if(layoutSetPrototype.getName("").equals("mysitetemplate")){

publicLayoutSetPrototypeId = (int) layoutSetPrototype.getLayoutSetPrototypeId();
System.out.println("public pages template id :"+publicLayoutSetPrototypeId);
}
if(layoutSetPrototype.getName("").equals("mysitetemplate2")){

privateLayoutSetPrototypeId = (int) layoutSetPrototype.getLayoutSetPrototypeId();
System.out.println("private pages template ID : "+privateLayoutSetPrototypeId);
}
}



MethodKey methodKey  = new MethodKey(SitesUtil.class, "updateLayoutSetPrototypesLinks",Group.class,long.class, long.class,boolean.class,boolean.class);
PortalClassInvoker.invoke(true, methodKey, grp, publicLayoutSetPrototypeId, privateLayoutSetPrototypeId,true,true);

LayoutSet layoutSet = LayoutSetLocalServiceUtil.getLayoutSet(grp.getGroupId(), true);

MethodKey _mergeLayoutSetPrototypeLayoutsMethodKey  = new MethodKey(SitesUtil.class,"mergeLayoutSetPrototypeLayouts",Group.class,LayoutSet.class);

PortalClassInvoker.invoke(true,_mergeLayoutSetPrototypeLayoutsMethodKey,grp, layoutSet);

System.out.println("suuccess");

java.io.File file = new java.io.File(getPortletContext().getRealPath("/WEB-INF/mylogo.png"));

LayoutSetServiceUtil.updateLogo(grp.getGroupId(), false, true, file);




} catch (PortalException e) {
e.printStackTrace();
} catch (SystemException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}


super.doView(renderRequest, renderResponse);
}