package com.vci.ubcs.starter.web.wrapper;
|
|
//
|
// Source code recreated from a .class file by IntelliJ IDEA
|
// (powered by FernFlower decompiler)
|
//
|
|
//package com.vci.starter.web.wrapper;
|
|
import java.lang.reflect.Field;
|
import java.util.ArrayList;
|
import java.util.Collection;
|
import java.util.Date;
|
import java.util.HashMap;
|
import java.util.HashSet;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Locale;
|
import java.util.Map;
|
import java.util.Set;
|
import java.util.Map.Entry;
|
import java.util.stream.Collectors;
|
|
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
|
import com.vci.ubcs.starter.exception.VciBaseException;
|
import com.vci.ubcs.starter.revision.model.TreeQueryObject;
|
import com.vci.ubcs.starter.web.annotation.VciFieldType;
|
import com.vci.ubcs.starter.web.annotation.VciUseEnum;
|
import com.vci.ubcs.starter.web.enumpck.VciFieldTypeEnum;
|
import com.vci.ubcs.starter.web.pagemodel.PageHelper;
|
import com.vci.ubcs.starter.web.service.VciSecretServiceI;
|
import com.vci.ubcs.starter.web.util.VciBaseUtil;
|
import org.springframework.util.CollectionUtils;
|
|
import javax.xml.bind.annotation.XmlType;
|
|
public class VciQueryWrapperForDO implements VciSecretServiceI {
|
public static boolean USER_TABLE_COMPATIBILITY = false;
|
public static String DATABASE_PLATFORM;
|
public static Map<String, String> USER_TABLE_COMPATIBILITY_BTM_MAP;
|
public static Map<String, String> USER_TABLE_COMPATIBILITY_FIELD_MAP;
|
public static final String USER_TABLE_COMPATIBILITY_FIELD_SEP = "${vcicomplibitysep}";
|
private Map<String, String> conditionMap;
|
private Map<String, String> customerSqlMap;
|
private String oidFieldName;
|
private static final String SPACE = " ";
|
public static final String QUERY_FIELD_SECRET = "${vciQuerySecret}";
|
public static final String QUERY_FIELD_DATARIGHT = "${vciQueryDataRight}";
|
private Class<?> doClass;
|
private PageHelper pageHelper;
|
private Map<String, String> allFieldNameMap;
|
private List<String> xmlTypeFieldList;
|
private boolean distinct;
|
public static final String OID_FIELD = "oid";
|
public static final String ID_FIELD = "id";
|
public static final String LC_STATUS_FIELD = "lcstatus";
|
public static final String LC_STATUS_FIELD_TEXT = "lcStatus_text";
|
private Map<String, VciFieldTypeEnum> allFieldTypeMap;
|
private Map<String, String> useReferMap;
|
private Map<String, String> enumFieldMap;
|
private String linkTableSql;
|
private String selectFieldSql;
|
private String selectPrefixForPage;
|
private String whereSql;
|
private String orderSql;
|
private String whereSubfixForPage;
|
private Map<String, String> valuesMap;
|
private String tableNick;
|
private Map<String, String> extendFieldMap;
|
private static final String DATETIME_FORMAT = "yyyy-mm-dd hh24:mi:ss";
|
private static final String DATE_FORMAT = "yyyy-mm-dd";
|
|
public void clearPage() {
|
this.pageHelper = null;
|
this.selectPrefixForPage = "";
|
this.whereSubfixForPage = "";
|
}
|
|
public VciQueryWrapperForDO in(String key, String value) throws VciBaseException {
|
this.addQueryMap(key, value, "\\IN");
|
return this;
|
}
|
|
public VciQueryWrapperForDO notIn(String key, String value) throws VciBaseException {
|
this.addQueryMap(key, value, "\\NOTIN");
|
return this;
|
}
|
|
public VciQueryWrapperForDO eq(String key, String value) throws VciBaseException {
|
this.addQueryMap(key, value);
|
return this;
|
}
|
|
public VciQueryWrapperForDO neq(String key, String value) throws VciBaseException {
|
this.addQueryMap(key, value, "!=");
|
return this;
|
}
|
|
public VciQueryWrapperForDO less(String key, String value) throws VciBaseException {
|
this.addQueryMap(key, value, "<");
|
return this;
|
}
|
|
public VciQueryWrapperForDO lessThan(String key, String value) throws VciBaseException {
|
this.addQueryMap(key, value, "<=");
|
return this;
|
}
|
|
public VciQueryWrapperForDO more(String key, String value) throws VciBaseException {
|
this.addQueryMap(key, value, ">");
|
return this;
|
}
|
|
public VciQueryWrapperForDO moreThan(String key, String value) throws VciBaseException {
|
this.addQueryMap(key, value, ">=");
|
return this;
|
}
|
|
public VciQueryWrapperForDO isNull(String key) throws VciBaseException {
|
this.addQueryMap(key, "_n", "=null");
|
return this;
|
}
|
|
public VciQueryWrapperForDO isNotNull(String key) throws VciBaseException {
|
this.addQueryMap(key, "_n", "!=null");
|
return this;
|
}
|
|
public VciQueryWrapperForDO secret() throws VciBaseException {
|
String secretSql = this.getLessThanUserSecretSql();
|
this.addQueryMap("secretGrade", secretSql, "<=");
|
return this;
|
}
|
|
public void addQueryMap(String key, String value) {
|
this.addQueryMap(key, value, (String)null);
|
}
|
|
public void addQueryMap(String key, String value, String operation) {
|
VciBaseUtil.alertNotNull(new Object[]{key, "查询条件的名称"});
|
if (StringUtils.isNotBlank(value)) {
|
if (this.conditionMap == null) {
|
this.conditionMap = new HashMap();
|
}
|
|
if (operation == null) {
|
operation = "";
|
}
|
|
this.conditionMap.put(key, operation + value);
|
}
|
|
}
|
|
public void addCustomSql(String key, String sql) {
|
VciBaseUtil.alertNotNull(new Object[]{key, "自定义SQL的KEY", sql, "自定义的SQL语句"});
|
if (StringUtils.isNotBlank(sql)) {
|
if (this.customerSqlMap == null) {
|
this.customerSqlMap = new HashMap();
|
}
|
|
this.customerSqlMap.put(key, sql);
|
}
|
|
}
|
|
public void addExtendField(String fieldName) {
|
this.addExtendField(fieldName, fieldName);
|
}
|
|
public void addExtendField(String fieldName, String nickName) {
|
this.extendFieldMap.put(fieldName, nickName);
|
}
|
|
public Map<String, String> getConditionMap() {
|
return this.conditionMap;
|
}
|
|
public void setConditionMap(Map<String, String> conditionMap) {
|
this.conditionMap = conditionMap;
|
}
|
|
public Map<String, String> switchConditionMap() {
|
Map<String, String> queryMap = new HashMap();
|
if (!CollectionUtils.isEmpty(this.conditionMap)) {
|
this.conditionMap.forEach((key, value) -> {
|
queryMap.put(key, value);
|
});
|
this.allFieldNameMap.forEach((dbField, field) -> {
|
if (this.conditionMap.containsKey(field)) {
|
queryMap.put(dbField, this.conditionMap.get(field));
|
}
|
|
});
|
}
|
|
return queryMap;
|
}
|
|
public String getLinkTableSql() {
|
return this.linkTableSql;
|
}
|
|
public void setLinkTableSql(String linkTableSql) {
|
this.linkTableSql = linkTableSql;
|
}
|
|
public void addLinkTableSql(String linkTableSql) {
|
this.linkTableSql = this.linkTableSql + " " + linkTableSql + " ";
|
}
|
|
public void setSelectFieldSql(String selectFieldSql) {
|
this.selectFieldSql = selectFieldSql;
|
}
|
|
public void appendSelectField(String sql) {
|
this.selectFieldSql = this.selectFieldSql + "," + sql;
|
}
|
|
public void appendSelectPagePrefix(String sql) {
|
this.selectPrefixForPage = this.selectPrefixForPage + "," + sql;
|
}
|
|
public String getWhereSql() {
|
if (StringUtils.isBlank(this.whereSql)) {
|
this.whereSql = " 1 = 1 ";
|
}
|
|
return this.pageHelper != null && this.pageHelper.getLimit() > 0 ? this.whereSql + (this.orderSql == null ? "" : this.orderSql) + (this.whereSubfixForPage == null ? "" : this.whereSubfixForPage) : (StringUtils.isNotBlank(this.whereSql) ? this.whereSql : " 1= 1 ") + (this.orderSql == null ? "" : this.orderSql);
|
}
|
|
public void setWhereSql(String whereSql) {
|
this.whereSql = whereSql;
|
}
|
|
public Map<String, String> getValuesMap() {
|
return this.valuesMap;
|
}
|
|
public void setValuesMap(Map<String, String> valuesMap) {
|
this.valuesMap = valuesMap;
|
}
|
|
public String getTableNick() {
|
return this.tableNick;
|
}
|
|
public void setTableNick(String tableNick) {
|
this.tableNick = tableNick;
|
}
|
|
public String getOrderSql() {
|
return this.orderSql;
|
}
|
|
public void setOrderSql(String orderSql) {
|
this.orderSql = orderSql;
|
}
|
|
public String getOidFieldName() {
|
return this.oidFieldName;
|
}
|
|
public void setOidFieldName(String oidFieldName) {
|
this.oidFieldName = oidFieldName;
|
}
|
|
public boolean isDistinct() {
|
return this.distinct;
|
}
|
|
public void setDistinct(boolean distinct) {
|
this.distinct = distinct;
|
}
|
|
public Map<String, String> getCustomerSqlMap() {
|
return this.customerSqlMap;
|
}
|
|
public void setCustomerSqlMap(Map<String, String> customerSqlMap) {
|
this.customerSqlMap = customerSqlMap;
|
}
|
|
}
|
