Java tutorial
/* * eGov suite of products aim to improve the internal efficiency,transparency, * accountability and the service delivery of the government organizations. * * Copyright (C) <2015> eGovernments Foundation * * The updated version of eGov suite of products as by eGovernments Foundation * is available at http://www.egovernments.org * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see http://www.gnu.org/licenses/ or * http://www.gnu.org/licenses/gpl.html . * * In addition to the terms of the GPL license to be adhered to in using this * program, the following additional terms are to be complied with: * * 1) All versions of this program, verbatim or modified must carry this * Legal Notice. * * 2) Any misrepresentation of the origin of the material is prohibited. It * is required that all modified versions of this material be marked in * reasonable ways as different from the original version. * * 3) This license does not grant any rights to any user of the program * with regards to rights under trademark law for use of the trade names * or trademarks of eGovernments Foundation. * * In case of any queries, you can reach eGovernments Foundation at contact@egovernments.org. */ package org.egov.pgr.web.controller.reports; import com.google.gson.Gson; import com.google.gson.GsonBuilder; import org.apache.commons.io.IOUtils; import org.egov.pgr.service.reports.DrillDownReportService; import org.hibernate.SQLQuery; import org.hibernate.transform.Transformers; import org.joda.time.DateTime; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.http.MediaType; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.ExceptionHandler; import org.springframework.web.bind.annotation.ModelAttribute; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.util.List; @Controller @RequestMapping(value = "/report") public class DrillDownReportController { @Autowired private final DrillDownReportService drillDownReportService; @Autowired public DrillDownReportController(final DrillDownReportService drillDownReportService) { this.drillDownReportService = drillDownReportService; } @ModelAttribute public void getReportHelper(final Model model) { final ReportHelper reportHealperObj = new ReportHelper(); model.addAttribute("reportHelper", reportHealperObj); } @RequestMapping(method = RequestMethod.GET, value = "/drillDownReportByBoundary") public String searchAgeingReportByBoundaryForm(final Model model) { model.addAttribute("mode", "ByBoundary"); return "drillDown-search"; } @RequestMapping(method = RequestMethod.GET, value = "/drillDownReportByDept") public String searchAgeingReportByDepartmentForm(final Model model) { model.addAttribute("mode", "ByDepartment"); return "drillDown-search"; } @ExceptionHandler(Exception.class) @RequestMapping(value = "/drillDown/resultList-update", method = RequestMethod.GET) public @ResponseBody void springPaginationDataTablesUpdate(@RequestParam final String groupBy, @RequestParam final String deptid, @RequestParam final String complainttypeid, @RequestParam final String selecteduserid, @RequestParam final String boundary, @RequestParam final String type, @RequestParam final String complaintDateType, @RequestParam final DateTime fromDate, @RequestParam final DateTime toDate, final HttpServletRequest request, final HttpServletResponse response) throws IOException { SQLQuery drillDownreportQuery = null; String result = null; if (deptid != null && complainttypeid != null && selecteduserid != null && !"".equals(deptid) && !"".equals(complainttypeid) && !"".equals(selecteduserid)) { String userName = selecteduserid.split("~")[0]; if (userName.equals("")) userName = null; drillDownreportQuery = drillDownReportService.getDrillDownReportQuery(fromDate, toDate, complaintDateType, deptid, boundary, complainttypeid, userName); drillDownreportQuery.setResultTransformer(Transformers.aliasToBean(DrillDownReportResult.class)); final List<DrillDownReportResult> drillDownresult = drillDownreportQuery.list(); result = new StringBuilder("{ \"data\":").append(toJSONForComplaintType(drillDownresult)).append("}") .toString(); } else { drillDownreportQuery = drillDownReportService.getDrillDownReportQuery(fromDate, toDate, complaintDateType, groupBy, deptid, boundary, complainttypeid, selecteduserid); drillDownreportQuery.setResultTransformer(Transformers.aliasToBean(DrillDownReportResult.class)); final List<AgeingReportResult> drillDownresult = drillDownreportQuery.list(); result = new StringBuilder("{ \"data\":").append(toJSON(drillDownresult)).append("}").toString(); } response.setContentType(MediaType.APPLICATION_JSON_VALUE); IOUtils.write(result, response.getWriter()); } private Object toJSONForComplaintType(final Object object) { final GsonBuilder gsonBuilder = new GsonBuilder(); final Gson gson = gsonBuilder .registerTypeAdapter(DrillDownReportResult.class, new DrillDownReportWithcompTypeAdaptor()) .create(); final String json = gson.toJson(object); return json; } private Object toJSON(final Object object) { final GsonBuilder gsonBuilder = new GsonBuilder(); final Gson gson = gsonBuilder .registerTypeAdapter(DrillDownReportResult.class, new DrillDownReportHelperAdaptor()).create(); final String json = gson.toJson(object); return json; } }