/*
* 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.works.web.actions.reports;
import org.apache.commons.lang.StringUtils;
import org.apache.log4j.Logger;
import org.egov.infra.web.struts.actions.BaseFormAction;
import org.egov.works.abstractestimate.entity.AbstractEstimate;
import org.egov.works.contractorbill.entity.ContractorBillRegister;
import java.util.ArrayList;
import java.util.LinkedList;
import java.util.List;
public class AjaxRetentionMoneyRecoveryRegisterAction extends BaseFormAction {
private static final long serialVersionUID = 7421372624155467521L;
private static final Logger logger = Logger.getLogger(AjaxRetentionMoneyRecoveryRegisterAction.class);
private static final String ESTIMATE_NUMBER_SEARCH_RESULTS = "estimateNoSearchResults";
private static final String PROJECT_CODE_SEARCH_RESULTS = "projectCodeSearchResults";
private static final String CONTRACTOR_CODE_SEARCH_RESULTS = "contractorCodeSearchResults";
private String query;
private List<String> estimateNumberSearchList = new LinkedList<String>();
private List<String> projectCodeList = new LinkedList<String>();
private List<String> contractorCodeNameList = new LinkedList<String>();
@Override
public String execute() {
return SUCCESS;
}
@Override
public Object getModel() {
return null;
}
/*
* Autocomplete for estimates where bills are created
*/
public String searchEstimateNumber() {
String strquery = "";
final ArrayList<Object> params = new ArrayList<Object>();
if (!StringUtils.isEmpty(query)) {
strquery = "select distinct(ae.estimateNumber) from AbstractEstimate ae where ae.parent is null and ae.projectCode.id in "
+ "(select bpd.accountDetailKeyId from EgBillPayeedetails bpd where bpd.accountDetailTypeId = ("
+ " select id from Accountdetailtype where name='PROJECTCODE') and bpd.egBilldetailsId.egBillregister.status.code=? "
+ " and expendituretype='Works' ) "
+ "and UPPER(ae.estimateNumber) like '%'||?||'%' and ae.egwStatus.code = ? )";
params.add(ContractorBillRegister.BillStatus.APPROVED.toString());
params.add(query.toUpperCase());
params.add(AbstractEstimate.EstimateStatus.ADMIN_SANCTIONED.toString());
estimateNumberSearchList = persistenceService.findAllBy(strquery, params.toArray());
}
return ESTIMATE_NUMBER_SEARCH_RESULTS;
}
/*
* Autocomplete of Project codes where bills are created
*/
public String searchProjectCode() {
if (!StringUtils.isEmpty(query)) {
String strquery = "";
final ArrayList<Object> params = new ArrayList<Object>();
strquery = "select pc.code from ProjectCode pc where upper(pc.code) like '%'||?||'%'"
+ " and pc.id in (select bpd.accountDetailKeyId from EgBillPayeedetails bpd where bpd.accountDetailTypeId = ("
+ " select id from Accountdetailtype where name='PROJECTCODE') and bpd.egBilldetailsId.egBillregister.status.code=? "
+ " and expendituretype='Works')";
params.add(query.toUpperCase());
params.add(ContractorBillRegister.BillStatus.APPROVED.toString());
projectCodeList = getPersistenceService().findAllBy(strquery, params.toArray());
}
return PROJECT_CODE_SEARCH_RESULTS;
}
/*
* Autocomplete of Contractor Code/Names where bills are created
*/
public String searchContractors() {
if (!StringUtils.isEmpty(query)) {
String strquery = "";
final ArrayList<Object> params = new ArrayList<Object>();
strquery = "select cont.code||'~'||cont.name from Contractor cont where upper(cont.code) like '%'||?||'%' or upper(cont.name) like '%'||?||'%'"
+ " and cont.id in (select bpd.accountDetailKeyId from EgBillPayeedetails bpd where bpd.accountDetailTypeId = ("
+ " select id from Accountdetailtype where name='contractor') and bpd.egBilldetailsId.egBillregister.status.code=? "
+ " and expendituretype='Works')";
params.add(query.toUpperCase());
params.add(query.toUpperCase());
params.add(ContractorBillRegister.BillStatus.APPROVED.toString());
contractorCodeNameList = getPersistenceService().findAllBy(strquery, params.toArray());
}
return CONTRACTOR_CODE_SEARCH_RESULTS;
}
public String getQuery() {
return query;
}
public void setQuery(final String query) {
this.query = query;
}
public List<String> getEstimateNumberSearchList() {
return estimateNumberSearchList;
}
public List<String> getProjectCodeList() {
return projectCodeList;
}
public List<String> getContractorCodeNameList() {
return contractorCodeNameList;
}
}