- 001
- 002
- 003
- 004
- 005
- 006
- 007
- 008
- 009
- 010
- 011
- 012
- 013
- 014
- 015
- 016
- 017
- 018
- 019
- 020
- 021
- 022
- 023
- 024
- 025
- 026
- 027
- 028
- 029
- 030
- 031
- 032
- 033
- 034
- 035
- 036
- 037
- 038
- 039
- 040
- 041
- 042
- 043
- 044
- 045
- 046
- 047
- 048
- 049
- 050
- 051
- 052
- 053
- 054
- 055
- 056
- 057
- 058
- 059
- 060
- 061
- 062
- 063
- 064
- 065
- 066
- 067
- 068
- 069
- 070
- 071
- 072
- 073
- 074
- 075
- 076
- 077
- 078
- 079
- 080
- 081
- 082
- 083
- 084
- 085
- 086
- 087
- 088
- 089
- 090
- 091
- 092
- 093
- 094
- 095
- 096
- 097
- 098
- 099
- 100
if (filter != null)
for (FilterItem item : filter.getItems()) {
if (StringUtils.isBlank(item.getProperty()) || StringUtils.isBlank(item.getValue())) {
log.warn("Skipping wrong filter: {}", PrintHelper.objectToString(item));
continue;
}
String property = item.getProperty().trim();
String value = item.getValue().trim();
if (property.equals(USER_ACCESS_LEVEL)) {
this.accessLevelType = Integer.valueOf(value);
paramsMap.put("user_access_level_type.id", ":" + USER_ACCESS_LEVEL);
valuesMap.put(USER_ACCESS_LEVEL, this.accessLevelType);
} if (property.equals(USER_TYPE)) {
this.userType = Integer.valueOf(value);
paramsMap.put("user_type.id", ":" + USER_TYPE);
valuesMap.put(USER_TYPE, this.userType);
} if (property.equals(FEDERAL_DISTRICT_ID)) {
this.federalDistrictId = Integer.valueOf(value);
paramsMap.put("user_org_detail.federal_district_fkey", ":" + FEDERAL_DISTRICT_ID);
valuesMap.put(FEDERAL_DISTRICT_ID, this.federalDistrictId);
} if (property.equals(CONSTITUENT_ENTITY_ID)) {
this.constituentEntityId = Integer.valueOf(value);
paramsMap.put("user_org_detail.constituent_entity_fkey", ":" + CONSTITUENT_ENTITY_ID);
valuesMap.put(CONSTITUENT_ENTITY_ID, this.constituentEntityId);
} if (property.equals(FORESTRY_ID)) {
this.forestryId = value;
paramsMap.put("user_org_detail.forestry_fkey", ":" + FORESTRY_ID);
valuesMap.put(FORESTRY_ID, this.forestryId);
} if (property.equals(USER_ROLE_ID)) {
this.userRoleId = value;
paramsMap.put("user_role.role_fkey", ":" + USER_ROLE_ID);
valuesMap.put(USER_ROLE_ID, this.userRoleId);
} if (property.equals(USER_LOGIN)) {
this.userLogin = value;
paramsMap.put("usr.login", ":" + USER_LOGIN);
valuesMap.put(USER_LOGIN, "%" + this.userLogin + "%");
} if (property.equals(USER_NAME)) {
this.userName = value;
String[] query = this.userName.split(" ");
String[] fnamePlaceholders = {};
String[] lnamePlaceholders = {};
String[] mnamePlaceholders = {};
for (int i = 0; i < query.length; i++) {
String fname = ":first_name_" + i;
fnamePlaceholders = ArrayUtils.add(fnamePlaceholders, fname);
String lname = ":last_name_" + i;
lnamePlaceholders = ArrayUtils.add(lnamePlaceholders, lname);
String mname = ":middle_name_" + i;
mnamePlaceholders = ArrayUtils.add(mnamePlaceholders, mname);
valuesMap.put("first_name_" + i, "%" + query[i] + "%");
valuesMap.put("last_name_" + i, "%" + query[i] + "%");
valuesMap.put("middle_name_" + i, "%" + query[i] + "%");
}
userParams.put("usr.first_name", fnamePlaceholders);
userParams.put("usr.last_name", lnamePlaceholders);
userParams.put("usr.middle_name", mnamePlaceholders);
} if (property.equals(USER_STATUS)) {
this.userStatus = value;
paramsMap.put("usr.status", ":" + USER_STATUS);
valuesMap.put(USER_STATUS, this.userStatus);
} if (property.equals(PARTY_NAME)) {
this.partyName = value;
String[] query = value.split(" ");
String[] fnamePlaceholders = {};
String[] lnamePlaceholders = {};
String[] mnamePlaceholders = {};
for (int i = 0; i < query.length; i++) {
String fname = ":person_first_name_" + i;
fnamePlaceholders = ArrayUtils.add(fnamePlaceholders, fname);
String lname = ":person_last_name_" + i;
lnamePlaceholders = ArrayUtils.add(lnamePlaceholders, lname);
String mname = ":person_mid_name_" + i;
mnamePlaceholders = ArrayUtils.add(mnamePlaceholders, mname);
valuesMap.put("person_first_name_" + i, "%" + query[i] + "%");
valuesMap.put("person_last_name_" + i, "%" + query[i] + "%");
valuesMap.put("person_mid_name_" + i, "%" + query[i] + "%");
}
partyParams.put("party.person_first_name", fnamePlaceholders);
partyParams.put("party.person_last_name", lnamePlaceholders);
partyParams.put("party.person_mid_name", mnamePlaceholders);
partyParams.put("party.party_name", new String[]{":party_name"});
valuesMap.put("party_name", "%" + this.partyName + "%");
} if (property.equals(PARTY_INN)) {
this.partyInn = value;
paramsMap.put("party.inn", ":" + PARTY_INN);
valuesMap.put(PARTY_INN, this.partyInn);
} if (property.equals(USER_IS_MASTER)) {
this.userIsMaster = Boolean.valueOf(value);
paramsMap.put("user_org_detail.organization_master", ":" + USER_IS_MASTER);