203 lines
12 KiB
Plaintext
Executable File
203 lines
12 KiB
Plaintext
Executable File
package com.fp.person.rules.query;
|
|
|
|
import com.fp.bpm.query.Query;
|
|
import com.fp.dto.Response;
|
|
import com.fp.dto.query.QueryRequest;
|
|
import com.fp.dto.rules.QueryRule;
|
|
import com.fp.persistence.pcustomer.gene.TcustPersonAddress;
|
|
import com.fp.persistence.pcustomer.gene.TcustPersonDetail;
|
|
import com.fp.persistence.pcustomer.people.TcustPeople;
|
|
import com.fp.persistence.pcustomer.people.TcustPeopleRealAssets;
|
|
import com.fp.persistence.pgeneral.gene.TgeneCanton;
|
|
import com.fp.persistence.pgeneral.gene.TgeneCity;
|
|
import com.fp.persistence.pgeneral.gene.TgeneCountry;
|
|
import com.fp.persistence.pgeneral.gene.TgeneParroquia;
|
|
import com.fp.persistence.pgeneral.gene.TgeneProvince;
|
|
import com.fp.person.db.DataHelper;
|
|
import java.util.List;
|
|
|
|
/**
|
|
* Clase que se encarga de completar el nombre de pais, provincia y ciudad asociados a una persona.
|
|
* @author Wilson Sigcho
|
|
* @version 2.1
|
|
*/
|
|
public class CountryProvinceCity extends QueryRule { // NOPMD by jorge on 12/10/10 22:28
|
|
|
|
private String country = "countrydesc";
|
|
private String province = "provincedesc";
|
|
private String canton = "cantondesc";
|
|
private String city = "citydesc";
|
|
private String parroquia = "parroquiadesc";
|
|
private String nacionality ="nacionalitydesc";
|
|
|
|
/**
|
|
* Metodo que agrega el nombre de pais, provincia y cuidad asociadas a una persona, cuando una consulta es requerida.
|
|
* @param pQueryRequest Objeto que posee la consulta requerida.
|
|
* @return pQueryRequest
|
|
* @throws Exception
|
|
*/
|
|
public QueryRequest process(QueryRequest pQueryRequest) throws Exception {
|
|
Response response = pQueryRequest.getResponse();
|
|
Query qry = new Query();
|
|
qry.process(pQueryRequest);
|
|
Object people = (Object) response.get("TCUSTPEOPLE");
|
|
List<Object> address = (List<Object>) response.get("TCUSTPERSONADDRESS");
|
|
List<Object> realassets = (List<Object>) response.get("TCUSTPEOPLEREALASSETS");
|
|
this.completePeople(people);
|
|
this.completeAddress(address);
|
|
this.completeRealAssets(realassets);
|
|
return pQueryRequest;
|
|
}
|
|
|
|
/**
|
|
* Metodo que se encraga de completar el nombre de pais, provincia, cuidad y parroquia de nacimiento de una persona.
|
|
* @param detail Objeto que posee un registro consultado en la tabla TcustPeople.
|
|
* @throws Exception
|
|
*/
|
|
private void completePeople(Object detail) throws Exception { // NOPMD by jorge on 12/10/10 22:27
|
|
if (detail == null) {
|
|
return;
|
|
}
|
|
TcustPeople tcustPeople = (TcustPeople) detail;
|
|
if (tcustPeople.getBirthcountrycode() != null) {
|
|
TgeneCountry tgeneCountry = DataHelper.getInstance().getTgeneCountry(tcustPeople.getBirthcountrycode());
|
|
tcustPeople.addAddtionalInfo(country, tgeneCountry.getDescription());
|
|
} else {
|
|
tcustPeople.addAddtionalInfo(country, null);
|
|
}
|
|
if (tcustPeople.getBirthcountrycode() != null && tcustPeople.getBirthprovincecode() != null) {
|
|
TgeneProvince tgeneProvince = DataHelper.getInstance().getTgeneProvince(tcustPeople.getBirthcountrycode(), tcustPeople.getBirthprovincecode());
|
|
tcustPeople.addAddtionalInfo(province, tgeneProvince.getDescription());
|
|
} else {
|
|
tcustPeople.addAddtionalInfo(province, null);
|
|
}
|
|
if (tcustPeople.getBirthcountrycode() != null && tcustPeople.getBirthprovincecode() != null && tcustPeople.getBirthcantoncode() != null) {
|
|
TgeneCanton tgeneCanton = DataHelper.getInstance().getTgeneCanton(tcustPeople.getBirthcountrycode(),
|
|
tcustPeople.getBirthprovincecode(), tcustPeople.getBirthcantoncode());
|
|
tcustPeople.addAddtionalInfo(canton, tgeneCanton.getDescription());
|
|
} else {
|
|
tcustPeople.addAddtionalInfo(canton, null);
|
|
}
|
|
if (tcustPeople.getBirthcountrycode() != null && tcustPeople.getBirthprovincecode() != null
|
|
&& tcustPeople.getBirthcantoncode() != null && tcustPeople.getBirthcitycode() != null) {
|
|
TgeneCity tgeneCity = DataHelper.getInstance().getTgeneCity(tcustPeople.getBirthcountrycode(),
|
|
tcustPeople.getBirthprovincecode(), tcustPeople.getBirthcantoncode(), tcustPeople.getBirthcitycode());
|
|
tcustPeople.addAddtionalInfo(city, tgeneCity.getDescription());
|
|
} else {
|
|
tcustPeople.addAddtionalInfo(city, null);
|
|
}
|
|
if (tcustPeople.getBirthcountrycode() != null && tcustPeople.getBirthprovincecode() != null
|
|
&& tcustPeople.getBirthcantoncode() != null && tcustPeople.getBirthparroquiacode() != null) {
|
|
TgeneParroquia tgeneParroquia = DataHelper.getInstance().getTgeneParroquia(tcustPeople.getBirthcountrycode(),
|
|
tcustPeople.getBirthprovincecode(), tcustPeople.getBirthcantoncode(), tcustPeople.getBirthparroquiacode());
|
|
tcustPeople.addAddtionalInfo(parroquia, tgeneParroquia.getDescription());
|
|
} else {
|
|
tcustPeople.addAddtionalInfo(parroquia, null);
|
|
}
|
|
if (tcustPeople.getNacionality() != null) {
|
|
TgeneCountry tgeneCountry = DataHelper.getInstance().getTgeneCountry(tcustPeople.getNacionality());
|
|
tcustPeople.addAddtionalInfo(nacionality, tgeneCountry.getCitizenship());
|
|
} else {
|
|
tcustPeople.addAddtionalInfo(nacionality, null);
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Metodo que se encraga de completar el nombre de pais, provincia y cuidad asociados a direcciones de una persona.
|
|
* @param lDetail Objeto que posee una lista de los registros consultados en la tabla TcustPersonAddress.
|
|
* @throws Exception
|
|
*/
|
|
private void completeAddress(List<Object> lDetail) throws Exception { // NOPMD by jorge on 12/10/10 22:27
|
|
if (lDetail == null) {
|
|
return;
|
|
}
|
|
for (Object object : lDetail) {
|
|
TcustPersonAddress tcustPersonAddress = (TcustPersonAddress) object;
|
|
if (tcustPersonAddress.getCountrycode() != null) {
|
|
TgeneCountry tgeneCountry = DataHelper.getInstance().getTgeneCountry(tcustPersonAddress.getCountrycode());
|
|
tcustPersonAddress.addAddtionalInfo(country, tgeneCountry.getDescription());
|
|
} else {
|
|
tcustPersonAddress.addAddtionalInfo(country, null);
|
|
}
|
|
if (tcustPersonAddress.getCountrycode() != null && tcustPersonAddress.getProvincecode() != null) {
|
|
TgeneProvince tgeneProvince = DataHelper.getInstance().getTgeneProvince(tcustPersonAddress.getCountrycode(),
|
|
tcustPersonAddress.getProvincecode());
|
|
tcustPersonAddress.addAddtionalInfo(province, tgeneProvince.getDescription());
|
|
} else {
|
|
tcustPersonAddress.addAddtionalInfo(province, null);
|
|
}
|
|
if (tcustPersonAddress.getCountrycode() != null && tcustPersonAddress.getProvincecode() != null
|
|
&& tcustPersonAddress.getCantoncode() != null) {
|
|
TgeneCanton tgeneCanton = DataHelper.getInstance().getTgeneCanton(tcustPersonAddress.getCountrycode(),
|
|
tcustPersonAddress.getProvincecode(), tcustPersonAddress.getCantoncode());
|
|
tcustPersonAddress.addAddtionalInfo(canton, tgeneCanton.getDescription());
|
|
} else {
|
|
tcustPersonAddress.addAddtionalInfo(canton, null);
|
|
}
|
|
if (tcustPersonAddress.getCountrycode() != null && tcustPersonAddress.getProvincecode() != null
|
|
&& tcustPersonAddress.getCantoncode() != null && tcustPersonAddress.getCitycode() != null) {
|
|
TgeneCity tgeneCity = DataHelper.getInstance().getTgeneCity(tcustPersonAddress.getCountrycode(), tcustPersonAddress.getProvincecode(), tcustPersonAddress.getCantoncode(), tcustPersonAddress.getCitycode());
|
|
tcustPersonAddress.addAddtionalInfo(city, tgeneCity.getDescription());
|
|
} else {
|
|
tcustPersonAddress.addAddtionalInfo(city, null);
|
|
}
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Metodo que se encraga de completar el nombre de pais, provincia, parroquia y cuidad de inmuebles asociados a una persona.
|
|
* @param lDetail Objeto que posee una lista de los registros consultados en la tabla TcustPeopleRealAssets.
|
|
* @throws Exception
|
|
*/
|
|
private void completeRealAssets(List<Object> lDetail) throws Exception { // NOPMD by jorge on 12/10/10 22:27
|
|
if (lDetail == null) {
|
|
return;
|
|
}
|
|
for (Object object : lDetail) {
|
|
TcustPeopleRealAssets tcustPeopleRealAssets = (TcustPeopleRealAssets) object;
|
|
if (tcustPeopleRealAssets.getCountrycode() != null) {
|
|
TgeneCountry tgeneCountry = DataHelper.getInstance().getTgeneCountry(tcustPeopleRealAssets.getCountrycode());
|
|
tcustPeopleRealAssets.addAddtionalInfo(country, tgeneCountry.getDescription());
|
|
} else {
|
|
tcustPeopleRealAssets.addAddtionalInfo(country, null);
|
|
}
|
|
if (tcustPeopleRealAssets.getCountrycode() != null && tcustPeopleRealAssets.getProvincecode() != null) {
|
|
TgeneProvince tgeneProvince = DataHelper.getInstance().getTgeneProvince(tcustPeopleRealAssets.getCountrycode(), tcustPeopleRealAssets.getProvincecode());
|
|
tcustPeopleRealAssets.addAddtionalInfo(province, tgeneProvince.getDescription());
|
|
} else {
|
|
tcustPeopleRealAssets.addAddtionalInfo(province, null);
|
|
}
|
|
if (tcustPeopleRealAssets.getCountrycode() != null && tcustPeopleRealAssets.getProvincecode() != null
|
|
&& tcustPeopleRealAssets.getCantoncode() != null) {
|
|
TgeneCanton tgeneCanton = DataHelper.getInstance().getTgeneCanton(tcustPeopleRealAssets.getCountrycode(),
|
|
tcustPeopleRealAssets.getProvincecode(), tcustPeopleRealAssets.getCantoncode());
|
|
tcustPeopleRealAssets.addAddtionalInfo(canton, tgeneCanton.getDescription());
|
|
} else {
|
|
tcustPeopleRealAssets.addAddtionalInfo(canton, null);
|
|
}
|
|
if (tcustPeopleRealAssets.getCountrycode() != null && tcustPeopleRealAssets.getProvincecode() != null
|
|
&& tcustPeopleRealAssets.getCantoncode() != null && tcustPeopleRealAssets.getCitycode() != null) {
|
|
TgeneCity tgeneCity = DataHelper.getInstance().getTgeneCity(tcustPeopleRealAssets.getCountrycode(),
|
|
tcustPeopleRealAssets.getProvincecode(), tcustPeopleRealAssets.getCantoncode(), tcustPeopleRealAssets.getCitycode());
|
|
tcustPeopleRealAssets.addAddtionalInfo(city, tgeneCity.getDescription());
|
|
} else {
|
|
tcustPeopleRealAssets.addAddtionalInfo(city, null);
|
|
}
|
|
if (tcustPeopleRealAssets.getCountrycode() != null && tcustPeopleRealAssets.getProvincecode() != null
|
|
&& tcustPeopleRealAssets.getCantoncode() != null && tcustPeopleRealAssets.getParroquiacode() != null) {
|
|
TgeneParroquia tgeneParroquia = DataHelper.getInstance().getTgeneParroquia(tcustPeopleRealAssets.getCountrycode(),
|
|
tcustPeopleRealAssets.getProvincecode(), tcustPeopleRealAssets.getCantoncode(), tcustPeopleRealAssets.getParroquiacode());
|
|
tcustPeopleRealAssets.addAddtionalInfo(parroquia, tgeneParroquia.getDescription());
|
|
} else {
|
|
tcustPeopleRealAssets.addAddtionalInfo(parroquia, null);
|
|
}
|
|
if (tcustPeopleRealAssets.getMortgagepersoncode() != null) {
|
|
TcustPersonDetail tcustPersonDetail = DataHelper.getInstance().getTcustPersonDetail(tcustPeopleRealAssets.getMortgagepersoncode());
|
|
tcustPeopleRealAssets.addAddtionalInfo("name", tcustPersonDetail.getName());
|
|
} else {
|
|
tcustPeopleRealAssets.addAddtionalInfo("name", null);
|
|
}
|
|
}
|
|
}
|
|
}
|