Java tutorial
/* * eGov SmartCity eGovernance suite aims to improve the internal efficiency,transparency, * accountability and the service delivery of the government organizations. * * Copyright (C) 2017 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. * Further, all user interfaces, including but not limited to citizen facing interfaces, * Urban Local Bodies interfaces, dashboards, mobile applications, of the program and any * derived works should carry eGovernments Foundation logo on the top right corner. * * For the logo, please refer http://egovernments.org/html/logo/egov_logo.png. * For any further queries on attribution, including queries on brand guidelines, * please contact contact@egovernments.org * * 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.ptis.actions.reports; import org.apache.log4j.Logger; import org.apache.struts2.convention.annotation.ParentPackage; import org.egov.commons.Installment; import org.egov.infra.reporting.engine.ReportRequest; import org.egov.infra.reporting.engine.ReportService; import org.egov.infra.reporting.viewer.ReportViewerUtil; import org.egov.infra.web.struts.actions.BaseFormAction; import org.egov.ptis.bean.ReportInfo; import org.egov.ptis.service.utils.PropertyTaxCommonUtils; import org.hibernate.Query; import org.springframework.beans.factory.annotation.Autowired; import java.math.BigDecimal; import java.util.ArrayList; import java.util.Calendar; import java.util.HashMap; import java.util.List; import java.util.Map; import static java.util.Calendar.YEAR; import static org.egov.ptis.constants.PropertyTaxConstants.REPORT_TEMPLATENAME_HEADWISEDMDCOLL; @ParentPackage("egov") public class HeadWiseDmdNdRecReportAction extends BaseFormAction { private final Logger LOGGER = Logger.getLogger(getClass()); private final String RESULT_GENERATE = "generate"; private ReportService reportService; private String reportId; private BigDecimal arrDmdTotal = BigDecimal.ZERO; private BigDecimal currDmdTotal = BigDecimal.ZERO; private BigDecimal arrCollTotal = BigDecimal.ZERO; private BigDecimal currCollTotal = BigDecimal.ZERO; private BigDecimal arrDmdGrandTotal = BigDecimal.ZERO; private BigDecimal currDmdGrandTotal = BigDecimal.ZERO; private BigDecimal arrCollGrandTotal = BigDecimal.ZERO; private BigDecimal currCollGrandTotal = BigDecimal.ZERO; private Map<String, BigDecimal> dmdCollMap = new HashMap<String, BigDecimal>(); private List arrInstDmdCollList = new ArrayList(); private List currInstDmdCollList = new ArrayList(); private Installment currentInstallment; @Autowired private PropertyTaxCommonUtils propertyTaxCommonUtils; @Autowired private ReportViewerUtil reportViewerUtil; public String generateHeadWiseDmdColl() { ReportRequest reportRequest = null; ReportInfo reportInfo = new ReportInfo(); currentInstallment = propertyTaxCommonUtils.getCurrentInstallment(); prepareReasonWiseCurrDmdColl(); prepareReasonWiseArrDmdColl(); Calendar installmentFromDate = Calendar.getInstance(); installmentFromDate.setTime(currentInstallment.getFromDate()); Calendar installmentToDate = Calendar.getInstance(); installmentToDate.setTime(currentInstallment.getToDate()); reportInfo.setCurrInstallment("Year " + installmentFromDate.get(YEAR) + "-" + installmentToDate.get(YEAR)); reportInfo.setDemandCollMap(dmdCollMap); reportRequest = new ReportRequest(REPORT_TEMPLATENAME_HEADWISEDMDCOLL, reportInfo, new HashMap<String, Object>()); reportRequest.setPrintDialogOnOpenReport(true); reportId = reportViewerUtil.addReportToTempCache(reportService.createReport(reportRequest)); return RESULT_GENERATE; } private void prepareReasonWiseCurrDmdColl() { LOGGER.debug("Enter prepareReasonWiseCurrDmdColl"); StringBuilder currDmdCollBuilder = new StringBuilder(1500); currDmdCollBuilder.append("select") .append(" dcb.installment.id, sum(dcb.generalTax), sum(dcb.generalTaxColl),") .append(" sum(dcb.egsTax), sum(dcb.egsTaxColl),") .append(" sum(dcb.eduCessResdTax) + sum(dcb.eduCessNonResdTax),") .append(" sum(dcb.eduCessResdTaxColl) + sum(dcb.eduCessNonResdTaxColl),") .append(" sum(dcb.waterTax), sum(dcb.waterTaxColl),") .append(" sum(dcb.fireTax), sum(dcb.fireTaxColl),") .append(" sum(dcb.sewerageTax), sum(dcb.sewerageTaxColl),") .append(" sum(dcb.lightTax), sum(dcb.lightTaxColl),") .append(" sum(dcb.bigBldgTax), sum(dcb.bigBldgTaxColl),") .append(" sum(dcb.chqBouncePenalty), sum(dcb.chqBuncPnltyColl),") .append(" sum(dcb.penaltyFine), sum(dcb.penaltyFineColl)") .append(" from InstDmdCollMaterializeView dcb, Installment inst, Module module").append(" where") .append(" inst.module.id = module.id").append(" and module.moduleName = 'Property Tax'") .append(" and inst.fromDate <= sysdate").append(" and inst.toDate >= sysdate") .append(" and dcb.installment.id = inst.id").append(" group by dcb.installment.id"); Query qry = getPersistenceService().getSession().createQuery(currDmdCollBuilder.toString()); currInstDmdCollList = qry.list(); Object[] currInst = (Object[]) currInstDmdCollList.get(0); dmdCollMap.put("currSewerageTax", ((BigDecimal) currInst[11])); dmdCollMap.put("currWaterTax", ((BigDecimal) currInst[7])); dmdCollMap.put("currGenTax", ((BigDecimal) currInst[1])); dmdCollMap.put("currFireTax", ((BigDecimal) currInst[9])); dmdCollMap.put("currLightTax", ((BigDecimal) currInst[13])); dmdCollMap.put("currEduTax", ((BigDecimal) currInst[5])); dmdCollMap.put("currEgsTax", ((BigDecimal) currInst[3])); dmdCollMap.put("currBigBldgTax", ((BigDecimal) currInst[15])); dmdCollMap.put("currSewerageTaxColl", ((BigDecimal) currInst[12])); dmdCollMap.put("currWaterTaxColl", ((BigDecimal) currInst[8])); dmdCollMap.put("currGenTaxColl", ((BigDecimal) currInst[2])); dmdCollMap.put("currFireTaxColl", ((BigDecimal) currInst[10])); dmdCollMap.put("currLightTaxColl", ((BigDecimal) currInst[14])); dmdCollMap.put("currEduTaxColl", ((BigDecimal) currInst[6])); dmdCollMap.put("currEgsTaxColl", ((BigDecimal) currInst[4])); dmdCollMap.put("currBigBldgTaxColl", ((BigDecimal) currInst[16])); dmdCollMap.put("currChqBuncPenalty", ((BigDecimal) currInst[17])); dmdCollMap.put("currPenaltyFine", ((BigDecimal) currInst[19])); dmdCollMap.put("currChqBncPntyColl", ((BigDecimal) currInst[18])); dmdCollMap.put("currPnltyFineColl", ((BigDecimal) currInst[20])); currDmdTotal = currDmdTotal.add((BigDecimal) currInst[11]).add((BigDecimal) currInst[7]) .add((BigDecimal) currInst[1]).add((BigDecimal) currInst[9]).add((BigDecimal) currInst[13]) .add((BigDecimal) currInst[5]).add((BigDecimal) currInst[3]).add((BigDecimal) currInst[15]) .add((BigDecimal) currInst[17]).add((BigDecimal) currInst[19]); currCollTotal = currCollTotal.add((BigDecimal) currInst[12]).add((BigDecimal) currInst[8]) .add((BigDecimal) currInst[2]).add((BigDecimal) currInst[10]).add((BigDecimal) currInst[14]) .add((BigDecimal) currInst[6]).add((BigDecimal) currInst[4]).add((BigDecimal) currInst[16]) .add((BigDecimal) currInst[18]).add((BigDecimal) currInst[20]); currDmdGrandTotal = currDmdGrandTotal.add(currDmdTotal); currCollGrandTotal = currCollGrandTotal.add(currCollTotal); dmdCollMap.put("currDmdTotal", currDmdTotal); dmdCollMap.put("currCollTotal", currCollTotal); dmdCollMap.put("currDmdGrandTotal", currDmdGrandTotal); dmdCollMap.put("currCollGrandTotal", currCollGrandTotal); LOGGER.debug("Exit prepareReasonWiseCurrDmdColl"); } private void prepareReasonWiseArrDmdColl() { LOGGER.debug("Enter prepareReasonWiseArrDmdColl"); StringBuilder arrDmdCollBuilder = new StringBuilder(1500); arrDmdCollBuilder.append("select").append(" sum(dcb.generalTax), sum(dcb.generalTaxColl),") .append(" sum(dcb.egsTax), sum(dcb.egsTaxColl), ") .append(" sum(dcb.eduCessResdTax) + sum(dcb.eduCessNonResdTax),") .append(" sum(dcb.eduCessResdTaxColl) + sum(dcb.eduCessNonResdTaxColl),") .append(" sum(dcb.waterTax), sum(dcb.waterTaxColl), sum(dcb.fireTax),") .append(" sum(dcb.fireTaxColl), sum(dcb.sewerageTax), sum(dcb.sewerageTaxColl),") .append(" sum(dcb.lightTax), sum(dcb.lightTaxColl), sum(dcb.bigBldgTax),") .append(" sum(dcb.bigBldgTaxColl), sum(dcb.chqBouncePenalty),") .append(" sum(dcb.chqBuncPnltyColl), sum(dcb.penaltyFine),").append(" sum(dcb.penaltyFineColl)") .append(" from InstDmdCollMaterializeView dcb, Installment inst, Module module").append(" where") .append(" inst.module.id = module.id").append(" and module.moduleName = 'Property Tax'") .append(" and inst.toDate < :currInstFromDate").append(" and dcb.installment.id = inst.id"); Query qry = getPersistenceService().getSession().createQuery(arrDmdCollBuilder.toString()); qry.setDate("currInstFromDate", currentInstallment.getFromDate()); arrInstDmdCollList = qry.list(); Object[] arrearTaxes = (Object[]) arrInstDmdCollList.get(0); dmdCollMap.put("arrSewerageTax", (BigDecimal) arrearTaxes[10]); dmdCollMap.put("arrWaterTax", (BigDecimal) arrearTaxes[6]); dmdCollMap.put("arrGenTax", (BigDecimal) arrearTaxes[0]); dmdCollMap.put("arrFireTax", (BigDecimal) arrearTaxes[8]); dmdCollMap.put("arrLightTax", (BigDecimal) arrearTaxes[12]); dmdCollMap.put("arrEduTax", (BigDecimal) arrearTaxes[4]); dmdCollMap.put("arrEgsTax", (BigDecimal) arrearTaxes[2]); dmdCollMap.put("arrBigBldgTax", (BigDecimal) arrearTaxes[14]); dmdCollMap.put("arrSewerageTaxColl", (BigDecimal) arrearTaxes[11]); dmdCollMap.put("arrWaterTaxColl", (BigDecimal) arrearTaxes[7]); dmdCollMap.put("arrGenTaxColl", (BigDecimal) arrearTaxes[1]); dmdCollMap.put("arrFireTaxColl", (BigDecimal) arrearTaxes[9]); dmdCollMap.put("arrLightTaxColl", (BigDecimal) arrearTaxes[13]); dmdCollMap.put("arrEduTaxColl", (BigDecimal) arrearTaxes[5]); dmdCollMap.put("arrEgsTaxColl", (BigDecimal) arrearTaxes[3]); dmdCollMap.put("arrBigBldgTaxColl", (BigDecimal) arrearTaxes[15]); dmdCollMap.put("arrChqBuncPenalty", (BigDecimal) arrearTaxes[16]); dmdCollMap.put("arrPenaltyFine", (BigDecimal) arrearTaxes[18]); dmdCollMap.put("arrChqBuncPnltyColl", (BigDecimal) arrearTaxes[17]); dmdCollMap.put("arrPenaltyFineColl", (BigDecimal) arrearTaxes[19]); for (Map.Entry<String, BigDecimal> mapEntry : dmdCollMap.entrySet()) { if (mapEntry.getKey().startsWith("arr")) { if (mapEntry.getKey().endsWith("Tax")) { arrDmdTotal = arrDmdTotal.add(mapEntry.getValue()); } else if (mapEntry.getKey().endsWith("Coll")) { arrCollTotal = arrCollTotal.add(mapEntry.getValue()); } } } arrDmdTotal = arrDmdTotal.add(dmdCollMap.get("arrChqBuncPenalty")).add(dmdCollMap.get("arrPenaltyFine")); arrDmdGrandTotal = arrDmdGrandTotal.add(arrDmdTotal); arrCollGrandTotal = arrCollGrandTotal.add(arrCollTotal); dmdCollMap.put("arrDmdTotal", arrDmdTotal); dmdCollMap.put("arrCollTotal", arrCollTotal); dmdCollMap.put("arrDmdGrandTotal", arrDmdGrandTotal); dmdCollMap.put("arrCollGrandTotal", arrCollGrandTotal); LOGGER.debug("Exit from prepareReasonWiseArrDmdColl"); } public ReportService getReportService() { return reportService; } public void setReportService(ReportService reportService) { this.reportService = reportService; } public String getReportId() { return reportId; } @Override public Object getModel() { return null; } }