/**
* 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.stms.web.controller.transactions;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.validation.Valid;
import org.egov.eis.entity.Assignment;
import org.egov.eis.service.AssignmentService;
import org.egov.eis.web.contract.WorkflowContainer;
import org.egov.eis.web.controller.workflow.GenericWorkFlowController;
import org.egov.infra.admin.master.service.AppConfigValueService;
import org.egov.infra.config.core.ApplicationThreadLocals;
import org.egov.infra.filestore.service.FileStoreService;
import org.egov.infra.security.utils.SecurityUtils;
import org.egov.ptis.domain.model.AssessmentDetails;
import org.egov.ptis.domain.model.PropertyTaxDetails;
import org.egov.ptis.domain.service.property.PropertyExternalService;
import org.egov.stms.masters.entity.DocumentTypeMaster;
import org.egov.stms.masters.entity.FeesDetailMaster;
import org.egov.stms.masters.entity.SewerageApplicationType;
import org.egov.stms.masters.entity.enums.PropertyType;
import org.egov.stms.masters.entity.enums.SewerageConnectionStatus;
import org.egov.stms.masters.service.DocumentTypeMasterService;
import org.egov.stms.masters.service.FeesDetailMasterService;
import org.egov.stms.masters.service.SewerageApplicationTypeService;
import org.egov.stms.transactions.entity.SewerageApplicationDetails;
import org.egov.stms.transactions.entity.SewerageApplicationDetailsDocument;
import org.egov.stms.transactions.entity.SewerageConnection;
import org.egov.stms.transactions.entity.SewerageConnectionFee;
import org.egov.stms.transactions.entity.SewerageDemandConnection;
import org.egov.stms.transactions.service.SewerageApplicationDetailsService;
import org.egov.stms.transactions.service.SewerageConnectionService;
import org.egov.stms.transactions.service.SewerageThirdPartyServices;
import org.egov.stms.utils.SewerageTaxUtils;
import org.egov.stms.utils.constants.SewerageTaxConstants;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.ui.ModelMap;
import org.springframework.validation.BindingResult;
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.multipart.MultipartFile;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.support.RedirectAttributes;
@Controller
@RequestMapping(value = "/transactions")
public class SewerageConnectionController extends GenericWorkFlowController {
private static final Logger LOG = LoggerFactory.getLogger(SewerageConnectionController.class);
private final SewerageTaxUtils sewerageTaxUtils;
private final SewerageApplicationDetailsService sewerageApplicationDetailsService;
@Autowired
private SewerageConnectionService sewerageConnectionService;
@Autowired
private SewerageApplicationTypeService sewerageApplicationTypeService;
@Autowired
private SecurityUtils securityUtils;
@Autowired
protected AssignmentService assignmentService;
@Autowired
private AppConfigValueService appConfigValuesService;
@Autowired
private PropertyExternalService propertyExternalService;
@Autowired
private FeesDetailMasterService feesDetailMasterService;
@Autowired
@Qualifier("fileStoreService")
protected FileStoreService fileStoreService;
@Autowired
private SewerageThirdPartyServices sewerageThirdPartyServices;
@Autowired
private DocumentTypeMasterService documentTypeMasterService;
@Autowired
public SewerageConnectionController(final SewerageTaxUtils sewerageTaxUtils,
final SewerageApplicationDetailsService sewerageApplicationDetailsService) {
this.sewerageTaxUtils = sewerageTaxUtils;
this.sewerageApplicationDetailsService = sewerageApplicationDetailsService;
}
public @ModelAttribute("documentNamesList") List<SewerageApplicationDetailsDocument> documentTypeMasterList(
@ModelAttribute final SewerageApplicationDetails sewerageApplicationDetails) {
final List<SewerageApplicationDetailsDocument> tempDocList = new ArrayList<SewerageApplicationDetailsDocument>(
0);
final SewerageApplicationType applicationType = sewerageApplicationTypeService
.findByCode(SewerageTaxConstants.NEWSEWERAGECONNECTION);
List<DocumentTypeMaster> documentTypeMasterList = documentTypeMasterService
.getAllActiveDocumentTypeMasterByApplicationType(applicationType);
if (sewerageApplicationDetails != null) {
for (final DocumentTypeMaster dtm : documentTypeMasterList) {
SewerageApplicationDetailsDocument sad = new SewerageApplicationDetailsDocument();
if (dtm != null) {
sad.setDocumentTypeMaster(dtm);
tempDocList.add(sad);
}
}
}
return tempDocList;
}
@RequestMapping(value = "/newConnection-newform", method = RequestMethod.GET)
public String showNewApplicationForm(@ModelAttribute final SewerageApplicationDetails sewerageApplicationDetails,
final Model model, final HttpServletRequest request) {
LOG.debug("Inside showNewApplicationForm method");
final SewerageApplicationType applicationType = sewerageApplicationTypeService
.findByCode(SewerageTaxConstants.NEWSEWERAGECONNECTION);
sewerageApplicationDetails.setApplicationType(applicationType);
sewerageApplicationDetails.setApplicationDate(new Date());
final SewerageConnection connection = new SewerageConnection();
connection.setStatus(SewerageConnectionStatus.INPROGRESS);
sewerageApplicationDetails.setConnection(connection);
model.addAttribute("allowIfPTDueExists", sewerageTaxUtils.isNewConnectionAllowedIfPTDuePresent());
model.addAttribute("propertyTypes", PropertyType.values());
model.addAttribute("additionalRule", sewerageApplicationDetails.getApplicationType().getCode());
final WorkflowContainer workFlowContainer = new WorkflowContainer();
workFlowContainer.setAdditionalRule(sewerageApplicationDetails.getApplicationType().getCode());
prepareWorkflow(model, sewerageApplicationDetails, workFlowContainer);
model.addAttribute("currentUser", sewerageTaxUtils.getCurrentUserRole(securityUtils.getCurrentUser()));
model.addAttribute("stateType", sewerageApplicationDetails.getClass().getSimpleName());
model.addAttribute("typeOfConnection", SewerageTaxConstants.NEWSEWERAGECONNECTION);
final boolean inspectionFeeCollectionRequired = sewerageTaxUtils.isInspectionFeeCollectionRequired();
model.addAttribute("inspectionFeesCollectionRequired", inspectionFeeCollectionRequired);
if (inspectionFeeCollectionRequired) {
createSewerageConnectionFee(sewerageApplicationDetails, SewerageTaxConstants.FEE_INSPECTIONCHARGE);
}
model.addAttribute("mode", null);
return "newconnection-form";
}
private void createSewerageConnectionFee(final SewerageApplicationDetails sewerageApplicationDetails, String feeCode) {
List<FeesDetailMaster> inspectionFeeList = feesDetailMasterService.findAllActiveFeesDetailByFeesCode(feeCode);
for (FeesDetailMaster feeDetailMaster : inspectionFeeList) {
SewerageConnectionFee connectionFee = new SewerageConnectionFee();
connectionFee.setFeesDetail(feeDetailMaster);
if (feeDetailMaster.getIsFixedRate())
connectionFee.setAmount(feeDetailMaster.getAmount().doubleValue());
connectionFee.setApplicationDetails(sewerageApplicationDetails);
sewerageApplicationDetails.getConnectionFees().add(connectionFee);
}
}
@RequestMapping(value = "/newConnection-create", method = RequestMethod.POST)
public String create(@Valid @ModelAttribute final SewerageApplicationDetails sewerageApplicationDetails,
final BindingResult resultBinder, final RedirectAttributes redirectAttributes,
final HttpServletRequest request, final Model model, @RequestParam String workFlowAction,
final BindingResult errors, @RequestParam("files") final MultipartFile[] files) {
validatePropertyID(sewerageApplicationDetails, resultBinder, request);
final List<SewerageApplicationDetailsDocument> applicationDocs = new ArrayList<SewerageApplicationDetailsDocument>();
int i = 0;
if (!sewerageApplicationDetails.getAppDetailsDocument().isEmpty())
for (final SewerageApplicationDetailsDocument applicationDocument : sewerageApplicationDetails
.getAppDetailsDocument()) {
sewerageConnectionService.validateDocuments(applicationDocs, applicationDocument, i, resultBinder);
i++;
}
/**
* If inspection fee required to be collected, then change status to fee
* collection pending.
*/
if (LOG.isDebugEnabled())
LOG.error("Model Level Validation occurs = " + resultBinder);
if (resultBinder.hasErrors()) {
sewerageApplicationDetails.setApplicationDate(new Date());
model.addAttribute("validateIfPTDueExists", sewerageTaxUtils.isNewConnectionAllowedIfPTDuePresent());
model.addAttribute("propertyTypes", PropertyType.values());
prepareWorkflow(model, sewerageApplicationDetails, new WorkflowContainer());
model.addAttribute("additionalRule", sewerageApplicationDetails.getApplicationType().getCode());
model.addAttribute("currentUser", sewerageTaxUtils.getCurrentUserRole(securityUtils.getCurrentUser()));
model.addAttribute("approvalPosOnValidate", request.getParameter("approvalPosition"));
model.addAttribute("stateType", sewerageApplicationDetails.getClass().getSimpleName());
return "newconnection-form";
}
if (sewerageApplicationDetails.getState() == null)
if (sewerageTaxUtils.isInspectionFeeCollectionRequired())
sewerageApplicationDetails.setStatus(sewerageTaxUtils.getStatusByCodeAndModuleType(
SewerageTaxConstants.APPLICATION_STATUS_COLLECTINSPECTIONFEE, SewerageTaxConstants.MODULETYPE));
else
sewerageApplicationDetails.setStatus(sewerageTaxUtils.getStatusByCodeAndModuleType(
SewerageTaxConstants.APPLICATION_STATUS_CREATED, SewerageTaxConstants.MODULETYPE));
sewerageApplicationDetails.getAppDetailsDocument().clear();
sewerageApplicationDetails.setAppDetailsDocument(applicationDocs);
sewerageConnectionService.processAndStoreApplicationDocuments(sewerageApplicationDetails);
Long approvalPosition = 0l;
String approvalComment = "";
if (request.getParameter("approvalComment") != null)
approvalComment = request.getParameter("approvalComent");
if (request.getParameter("workFlowAction") != null)
workFlowAction = request.getParameter("workFlowAction");
if (request.getParameter("approvalPosition") != null && !request.getParameter("approvalPosition").isEmpty())
approvalPosition = Long.valueOf(request.getParameter("approvalPosition"));
populateFeesDetails(sewerageApplicationDetails);
final SewerageApplicationDetails newSewerageApplicationDetails = sewerageApplicationDetailsService
.createNewSewerageConnection(sewerageApplicationDetails, approvalPosition, approvalComment,
sewerageApplicationDetails.getApplicationType().getCode(),files, workFlowAction, request);
final Assignment currentUserAssignment = assignmentService.getPrimaryAssignmentForGivenRange(securityUtils
.getCurrentUser().getId(), new Date(), new Date());
Assignment assignObj = null;
List<Assignment> asignList = null;
if (approvalPosition != null)
assignObj = assignmentService.getPrimaryAssignmentForPositon(approvalPosition);
if (assignObj != null) {
asignList = new ArrayList<Assignment>();
asignList.add(assignObj);
} else if (assignObj == null && approvalPosition != null)
asignList = assignmentService.getAssignmentsForPosition(approvalPosition, new Date());
final String nextDesign = !asignList.isEmpty() ? asignList.get(0).getDesignation().getName() : "";
final String pathVars = newSewerageApplicationDetails.getApplicationNumber() + ","
+ sewerageTaxUtils.getApproverName(approvalPosition) + ","
+ (currentUserAssignment != null ? currentUserAssignment.getDesignation().getName() : "") + ","
+ (nextDesign != null ? nextDesign : "");
return "redirect:/transactions/application-success?pathVars=" + pathVars;
}
private void populateFeesDetails(final SewerageApplicationDetails sewerageApplicationDetails) {
if (sewerageApplicationDetails.getConnectionFees() != null
&& !sewerageApplicationDetails.getConnectionFees().isEmpty())
for (final SewerageConnectionFee scf : sewerageApplicationDetails.getConnectionFees())
scf.setApplicationDetails(sewerageApplicationDetails);
}
@RequestMapping(value = "/application-success", method = RequestMethod.GET)
public ModelAndView successView(@ModelAttribute SewerageApplicationDetails sewerageApplicationDetails,
final HttpServletRequest request, final Model model, final ModelMap modelMap) {
final String[] keyNameArray = request.getParameter("pathVars").split(",");
String applicationNumber = "";
String approverName = "";
String currentUserDesgn = "";
String nextDesign = "";
if (keyNameArray.length != 0 && keyNameArray.length > 0)
if (keyNameArray.length == 1)
applicationNumber = keyNameArray[0];
else if (keyNameArray.length == 3) {
applicationNumber = keyNameArray[0];
approverName = keyNameArray[1];
currentUserDesgn = keyNameArray[2];
} else {
applicationNumber = keyNameArray[0];
approverName = keyNameArray[1];
currentUserDesgn = keyNameArray[2];
nextDesign = keyNameArray[3];
}
if (applicationNumber != null)
sewerageApplicationDetails = sewerageApplicationDetailsService.findByApplicationNumber(applicationNumber);
model.addAttribute("approverName", approverName);
model.addAttribute("currentUserDesgn", currentUserDesgn);
model.addAttribute("nextDesign", nextDesign);
model.addAttribute("cityName", ApplicationThreadLocals.getCityName());
model.addAttribute("mode", "ack");
setCommonDetails(sewerageApplicationDetails, modelMap, request);
final boolean inspectionFeeCollectionRequired = sewerageTaxUtils.isInspectionFeeCollectionRequired();
model.addAttribute("inspectionFeesCollectionRequired", inspectionFeeCollectionRequired);
if (inspectionFeeCollectionRequired)
model.addAttribute("inspectionDetails", sewerageApplicationDetails.getConnectionFees());
model.addAttribute("documentNamesList",
sewerageConnectionService.getSewerageApplicationDoc(sewerageApplicationDetails));
return new ModelAndView("application-success", "sewerageApplicationDetails", sewerageApplicationDetails);
}
private void setCommonDetails(final SewerageApplicationDetails sewerageApplicationDetails, final ModelMap modelMap,
final HttpServletRequest request) {
final String assessmentNumber = sewerageApplicationDetails.getConnectionDetail()
.getPropertyIdentifier();
final AssessmentDetails propertyOwnerDetails = sewerageThirdPartyServices.getPropertyDetails(assessmentNumber,
request);
if (propertyOwnerDetails != null)
modelMap.addAttribute("propertyOwnerDetails", propertyOwnerDetails);
final PropertyTaxDetails propertyTaxDetails = propertyExternalService.getPropertyTaxDetails(assessmentNumber,null);
modelMap.addAttribute("propertyTax", propertyTaxDetails.getTotalTaxAmt());
}
private void validatePropertyID(final SewerageApplicationDetails sewerageApplicationDetails,
final BindingResult errors, final HttpServletRequest request) {
if (sewerageApplicationDetails.getConnectionDetail() != null
&& sewerageApplicationDetails.getConnectionDetail().getPropertyIdentifier() != null
&& !sewerageApplicationDetails.getConnectionDetail().getPropertyIdentifier().equals("")) {
String errorMessage = sewerageApplicationDetailsService
.checkValidPropertyAssessmentNumber(sewerageApplicationDetails.getConnectionDetail().getPropertyIdentifier());
if (errorMessage != null && !errorMessage.equals(""))
errors.reject("err.connectionDetail.propertyIdentifier.validate",
new String[] { errorMessage }, null);
else {
errorMessage = sewerageApplicationDetailsService
.checkConnectionPresentForProperty(sewerageApplicationDetails.getConnectionDetail().getPropertyIdentifier());
if (errorMessage != null && !errorMessage.equals(""))
errors.reject("err.connectionDetail.propertyIdentifier.validate",
new String[] { errorMessage }, null);
else {
HashMap<String, Object> result = sewerageThirdPartyServices.getWaterTaxDueAndCurrentTax(sewerageApplicationDetails.getConnectionDetail().getPropertyIdentifier(), request);
BigDecimal waterTaxDue = (BigDecimal) result.get("WATERTAXDUE");
String consumerCode = result.get("CONSUMERCODE").toString();
//Taking substring since value in consumercode is in this form [12345]
if(consumerCode!="" && consumerCode!=null)
consumerCode=consumerCode.substring(1, consumerCode.length()-1);
if (waterTaxDue.compareTo(BigDecimal.ZERO)>0){
errorMessage="For Entered Property tax Assessment number "+sewerageApplicationDetails.getConnectionDetail().getPropertyIdentifier()+
" linked water tap connection demand with Consumer code:"+consumerCode+" is due Rs."+waterTaxDue+"/- . Please clear demand and create new sewerage connection.";
errors.reject("err.connectionDetail.propertyIdentifier.validate",
new String[] { errorMessage }, null);
}
}
}
}
}
}