private static final String TAG = "SQLConfig";

/**

public static final Map<String, String> TABLE_KEY_MAP;

static {

TABLE_KEY_MAP = new HashMap<String, String>();

TABLE_KEY_MAP.put(Table.class.getSimpleName(), Table.TAG);

TABLE_KEY_MAP.put(Column.class.getSimpleName(), Column.TAG);

}

private long id; //Table的id

private RequestMethod method; //操作方法

private boolean prepared = true; //预编译

private boolean main = true;

/**

private RequestRole role; //发送请求的用户的角色

private String database; //表所在的数据库类型

private String schema; //表所在的数据库名

private String table; //表名

private String alias; //表别名

private String group; //分组方式的字符串数组，','分隔

private String having; //聚合函数的字符串数组，','分隔

private String order; //排序方式的字符串数组，','分隔

private String column; //表内字段名(或函数名，仅查询操作可用)的字符串数组，','分隔

private String values; //对应表内字段的值的字符串数组，','分隔

private Map<String, Object> content; //Request内容，key:value形式，column = content.keySet()，values = content.values()

private Map<String, Object> where; //筛选条件，key:value形式

private Map<String, List<String>> combine; //条件组合，{ "&":[key], "|":[key], "!":[key] }

//array item <<<<<<<<<<

private int count; //Table数量

private int page; //Table所在页码

private int position; //Table在[]中的位置

private int query; //JSONRequest.query

private int type; //ObjectParser.type

private List<Join> joinList; //joinList

//array item >>>>>>>>>>

private boolean test; //测试

private boolean cacheStatic; //静态缓存

public AbstractSQLConfig(RequestMethod method) {

setMethod(method);

}

public AbstractSQLConfig(RequestMethod method, String table) {

this(method);

setTable(table);

}

public AbstractSQLConfig(RequestMethod method, int count, int page) {

this(method);

setCount(count);

setPage(page);

}

@NotNull

@Override

public RequestMethod getMethod() {

if (method == null) {

method = GET;

}

return method;

}

@Override

public AbstractSQLConfig setMethod(RequestMethod method) {

this.method = method;

return this;

}

@Override

public boolean isPrepared() {

return prepared;

}

@Override

public AbstractSQLConfig setPrepared(boolean prepared) {

this.prepared = prepared;

return this;

}

@Override

public boolean isMain() {

return main;

}

@Override

public AbstractSQLConfig setMain(boolean main) {

this.main = main;

return this;

}

@Override

public long getId() {

return id;

}

@Override

public AbstractSQLConfig setId(long id) {

this.id = id;

return this;

}

@Override

public RequestRole getRole() {

//不能 @NotNull , AbstractParser#getSQLObject 内当getRole() == null时填充默认值

return role;

}

public AbstractSQLConfig setRole(String roleName) throws Exception {

return setRole(RequestRole.get(roleName));

}

@Override

public AbstractSQLConfig setRole(RequestRole role) {

this.role = role;

return this;

}

@Override

public String getDatabase() {

return database;

}

@Override

public SQLConfig setDatabase(String database) {

this.database = database;

return this;

}

@Override

public String getSchema() {

String sqlTable = getSQLTable();

if (sqlTable != null && sqlTable.startsWith("`")) {

return SCHEMA_INFORMATION;

}

return schema;

}

@Override

public AbstractSQLConfig setSchema(String schema) {

if (schema != null) {

String s = schema.startsWith("`") && schema.endsWith("`") ? schema.substring(1, schema.length() - 1) : schema;

if (StringUtil.isName(s) == false) {

throw new IllegalArgumentException("@schema:value 中value必须是1个单词！");

}

}

this.schema = schema;

return this;

}

/**请求传进来的Table名

@Override

public String getTable() {

return table;

}

/**数据库里的真实Table名

@JSONField(serialize = false)

@Override

public String getSQLTable() {

return (TABLE_KEY_MAP.containsKey(table) ? TABLE_KEY_MAP.get(table) : table)

+ ( isKeyPrefix() ? " AS " + getAlias() : "");

}

@JSONField(serialize = false)

@Override

public String getTablePath() {

return getSchema() + "." + getSQLTable();

}

@Override

public AbstractSQLConfig setTable(String table) { //Table已经在Parser中校验，所以这里不用防SQL注入

this.table = table;

return this;

}

@Override

public String getAlias() {

if (StringUtil.isEmpty(alias, true)) {

alias = getTable();

}

return alias;

}

@Override

public AbstractSQLConfig setAlias(String alias) {

this.alias = alias;

return this;

}

@Override

public String getGroup() {

return group;

}

public AbstractSQLConfig setGroup(String... keys) {

return setGroup(StringUtil.getString(keys));

}

@Override

public AbstractSQLConfig setGroup(String group) {

this.group = group;

return this;

}

@JSONField(serialize = false)

public String getGroupString() {

//TODO 加上子表的group

group = StringUtil.getTrimedString(group);

if (group.isEmpty()) {

return "";

}

String[] keys = StringUtil.split(group);

if (keys == null || keys.length <= 0) {

return "";

}

for (int i = 0; i < keys.length; i++) {

if (isPrepared()) { //不能通过 ? 来代替，因为SQLExecutor statement.setString后 GROUP BY 'userId' 有单引号，只能返回一条数据，必须去掉单引号才行！

if (StringUtil.isName(keys[i]) == false) {

throw new IllegalArgumentException("@group:value 中 value里面用 , 分割的每一项都必须是1个单词！并且不要有空格！");

}

}

keys[i] = getKey(keys[i]);

}

return " GROUP BY " + StringUtil.getString(keys);

}

@Override

public String getHaving() {

return having;

}

public AbstractSQLConfig setHaving(String... conditions) {

return setHaving(StringUtil.getString(conditions));

}

@Override

public AbstractSQLConfig setHaving(String having) {

this.having = having;

return this;

}

/**

@JSONField(serialize = false)

public String getHavingString() {

having = StringUtil.getTrimedString(having);

if(having.isEmpty()) {

return "";

}

String[] keys = StringUtil.split(having, ";");

if (keys == null || keys.length <= 0) {

return "";

}

String expression;

String method;

//暂时不允许 String prefix;

String suffix;

//fun0(arg0,arg1,...);fun1(arg0,arg1,...)

for (int i = 0; i < keys.length; i++) {

//fun(arg0,arg1,...)

expression = keys[i];

int start = expression.indexOf("(");

if (start < 0) {

if (isPrepared() && PATTERN_HAVING.matcher(expression).matches() == false) {

throw new UnsupportedOperationException("字符串 " + expression + " 不合法！"

+ "预编译模式下 @having:\"column?value;function(arg0,arg1,...)?value...\""

+ " 中 column?value 必须符合正则表达式 ^[A-Za-z0-9%!=<>]+$ ！不允许空格！");

}

continue;

}

int end = expression.indexOf(")");

if (start >= end) {

throw new IllegalArgumentException("字符 " + expression + " 不合法！"

+ "@having:value 中 value 里的 SQL函数必须为 function(arg0,arg1,...) 这种格式！");

}

method = expression.substring(0, start);

if (StringUtil.isName(method) == false) {

throw new IllegalArgumentException("字符 " + method + " 不合法！"

+ "预编译模式下 @having:\"column?value;function(arg0,arg1,...)?value...\""

+ " 中SQL函数名 function 必须符合正则表达式 ^[0-9a-zA-Z_]+$ ！");

}

suffix = expression.substring(end + 1, expression.length());

if (isPrepared() && PATTERN_HAVING_SUFFIX.matcher((String) suffix).matches() == false) {

throw new UnsupportedOperationException("字符串 " + suffix + " 不合法！"

+ "预编译模式下 @having:\"column?value;function(arg0,arg1,...)?value...\""

+ " 中 ?value 必须符合正则表达式 ^[0-9%!=<>]+$ ！不允许空格！");

}

String[] ckeys = StringUtil.split(expression.substring(start + 1, end));

if (ckeys != null) {

for (int j = 0; j < ckeys.length; j++) {

if (isPrepared() && (StringUtil.isName(ckeys[j]) == false || ckeys[j].startsWith("_"))) {

throw new IllegalArgumentException("字符 " + ckeys[j] + " 不合法！"

+ "预编译模式下 @having:\"column?value;function(arg0,arg1,...)?value...\""

+ " 中所有 arg 都必须是1个不以 _ 开头的单词！并且不要有空格！");

}

ckeys[j] = getKey(ckeys[j]);

}

}

keys[i] = method + "(" + StringUtil.getString(ckeys) + ")" + suffix;

}

return " HAVING " + StringUtil.getString(keys, AND); //TODO 支持 OR, NOT 参考 @combine:"&key0,|key1,!key2"

}

@Override

public String getOrder() {

return order;

}

public AbstractSQLConfig setOrder(String... conditions) {

return setOrder(StringUtil.getString(conditions));

}

@Override

public AbstractSQLConfig setOrder(String order) {

this.order = order;

return this;

}

@JSONField(serialize = false)

public String getOrderString() {

//TODO 加上子表的order

order = StringUtil.getTrimedString(order);

if (order.isEmpty()) {

return "";

}

if (order.contains("+")) {//replace没有包含的replacement会崩溃

order = order.replaceAll("\\+", " ASC ");

}

if (order.contains("-")) {

order = order.replaceAll("-", " DESC ");

}

//TODO column, order, group 都改用 List<String> 存储！！！，并且每个字段都要加 Table. 前缀！

String[] keys = StringUtil.split(order);

if (keys == null || keys.length <= 0) {

return "";

}

String origin;

String sort;

int index;

for (int i = 0; i < keys.length; i++) {

index = keys[i].trim().endsWith(" ASC") ? keys[i].lastIndexOf(" ASC") : -1; //StringUtil.split返回数组中，子项不会有null

if (index < 0) {

index = keys[i].trim().endsWith(" DESC") ? keys[i].lastIndexOf(" DESC") : -1;

sort = index <= 0 ? "" : " DESC ";

} else {

sort = " ASC ";

}

origin = index < 0 ? keys[i] : keys[i].substring(0, index);

if (isPrepared()) { //不能通过 ? 来代替，SELECT 'id','name' 返回的就是 id:"id", name:"name"，而不是数据库里的值！

//这里既不对origin trim，也不对 ASC/DESC ignoreCase，希望前端严格传没有任何空格的字符串过来，减少传输数据量，节约服务器性能

if (StringUtil.isName(origin) == false) {

throw new IllegalArgumentException("预编译模式下 @order:value 中 value里面用 , 分割的每一项"

+ " column+ / column- 中 column必须是1个单词！并且不要有多余的空格！");

}

}

keys[i] = getKey(origin) + sort;

}

return " ORDER BY " + StringUtil.getString(keys);

}

@Override

public String getColumn() {

return column;

}

public AbstractSQLConfig setColumn(String... keys) {

return setColumn(StringUtil.getString(keys));

}

@Override

public AbstractSQLConfig setColumn(String column) {

this.column = column;

return this;

}

@JSONField(serialize = false)

public String getColumnString() throws Exception {

switch (getMethod()) {

case HEAD:

case HEADS: //StringUtil.isEmpty(column, true) || column.contains(",") 时SQL.count(column)会return "*"

if (isPrepared() && StringUtil.isEmpty(column, true) == false

&& column.contains(",") == false && StringUtil.isName(column) == false) {

throw new IllegalArgumentException("HEAD请求: @column:value 中 value里面用 , 分割的每一项都必须是1个单词！");

}

return SQL.count(column);

case POST:

if (StringUtil.isEmpty(column, true)) {

throw new NotExistException(TAG + "getColumnString getMethod() = POST"

+ " >> StringUtil.isEmpty(column, true)");

}

if (isPrepared()) { //不能通过 ? 来代替，SELECT 'id','name' 返回的就是 id:"id", name:"name"，而不是数据库里的值！

String[] keys = StringUtil.split(column);

if (keys != null && keys.length > 0) {

for (int i = 0; i < keys.length; i++) {

if (StringUtil.isName(keys[i]) == false) {

throw new IllegalArgumentException("POST请求: 每一个 key:value 中的key都必须是1个单词！");

}

}

}

}

return "(" + column + ")";

case GET:

case GETS: //TODO 支持SQL函数 json_length(contactIdList):contactCount

boolean isQuery = RequestMethod.isQueryMethod(method);

String joinColumn = "";

if (isQuery && joinList != null) {

SQLConfig c;

boolean first = true;

for (Join j : joinList) {

c = j.getJoinConfig();

c.setAlias(c.getTable());

joinColumn += (first ? "" : ", ") + ((AbstractSQLConfig) c).getColumnString();

first = false;

}

}

String tableAlias = getAlias();

String c = StringUtil.getString(column); //id,name;json_length(contactIdList):contactCount;...

String[] keys = StringUtil.split(c, ";");

if (keys == null || keys.length <= 0) {

return isKeyPrefix() == false ? "*" : (tableAlias + ".*" + (StringUtil.isEmpty(joinColumn, true) ? "" : ", " + joinColumn));

}

String expression;

String method = null;

//...;fun0(arg0,arg1,...):fun0;fun1(arg0,arg1,...):fun1;...

for (int i = 0; i < keys.length; i++) {

//fun(arg0,arg1,...)

expression = keys[i];

int start = expression.indexOf("(");

int end = 0;

if (start >= 0) {

end = expression.indexOf(")");

if (start >= end) {

throw new IllegalArgumentException("字符 " + expression + " 不合法！"

+ "@having:value 中 value 里的 SQL函数必须为 function(arg0,arg1,...) 这种格式！");

}

method = expression.substring(0, start);

if (StringUtil.isName(method) == false) {

throw new IllegalArgumentException("字符 " + method + " 不合法！"

+ "预编译模式下 @column:\"column0,column1:alias;function0(arg0,arg1,...);function1(...):alias...\""

+ " 中SQL函数名 function 必须符合正则表达式 ^[0-9a-zA-Z_]+$ ！");

}

}

boolean isColumn = start < 0;

String[] ckeys = StringUtil.split(isColumn ? expression : expression.substring(start + 1, end));

// if (isPrepared()) { //不能通过 ? 来代替，SELECT 'id','name' 返回的就是 id:"id", name:"name"，而不是数据库里的值！

if (ckeys != null && ckeys.length > 0) {

String origin;

String alias;

int index;

for (int j = 0; j < ckeys.length; j++) {

index = ckeys[j].lastIndexOf(":"); //StringUtil.split返回数组中，子项不会有null

origin = index < 0 ? ckeys[j] : ckeys[j].substring(0, index);

alias = index < 0 ? null : ckeys[j].substring(index + 1);

if (isPrepared()) {

if (isColumn) {

if (StringUtil.isName(origin) == false || (alias != null && StringUtil.isName(alias) == false)) {

throw new IllegalArgumentException("GET请求: 预编译模式下 @column:value 中 value里面用 , 分割的每一项"

+ " column:alias 中 column 必须是1个单词！如果有alias，则alias也必须为1个单词！并且不要有多余的空格！");

}

}

else {

if ((StringUtil.isName(ckeys[j]) == false || ckeys[j].startsWith("_"))) {

throw new IllegalArgumentException("字符 " + ckeys[j] + " 不合法！"

+ "预编译模式下 @column:\"column0,column1:alias;function0(arg0,arg1,...);function1(...):alias...\""

+ " 中所有 arg 都必须是1个不以 _ 开头的单词！并且不要有空格！");

}

}

}

if (isKeyPrefix()) {

ckeys[j] = tableAlias + "." + origin;

if (isColumn) {

ckeys[j] += " AS \"" + (isMain() ? "" : tableAlias + ".") + (StringUtil.isEmpty(alias, true) ? origin : alias) + "\"";

}

} else {

ckeys[j] = origin + (StringUtil.isEmpty(alias, true) ? "" : " AS \"" + alias + "\"");

}

}

// }

}

if (isColumn) {

keys[i] = StringUtil.getString(ckeys);

}

else {

String suffix = expression.substring(end + 1, expression.length()); //:contactCount

String alias = suffix.startsWith(":") ? suffix.substring(1) : null; //contactCount

if (StringUtil.isEmpty(alias, true)) {

if (suffix.isEmpty() == false) {

throw new IllegalArgumentException("GET请求: 预编译模式下 @column:value 中 value里面用 ; 分割的每一项"

+ " function(arg0,arg1,...):alias 中 alias 如果有就必须是1个单词！并且不要有多余的空格！");

}

}

else {

if (StringUtil.isEmpty(alias, true) == false && StringUtil.isName(alias) == false) {

throw new IllegalArgumentException("GET请求: 预编译模式下 @column:value 中 value里面用 ; 分割的每一项"

+ " function(arg0,arg1,...):alias 中 alias 必须是1个单词！并且不要有多余的空格！");

}

}

String origin = method + "(" + StringUtil.getString(ckeys) + ")";

if (isKeyPrefix()) {

keys[i] = origin + " AS \"" + (isMain() ? "" : tableAlias + ".") + (StringUtil.isEmpty(alias, true) ? method : alias) + "\"";

}

else {

keys[i] = origin + (StringUtil.isEmpty(alias, true) ? "" : " AS \"" + alias + "\"");

}

}

}

c = StringUtil.getString(keys);

return (c.contains(":") == false ? c : c.replaceAll(":", " AS ")) + (StringUtil.isEmpty(joinColumn, true) ? "" : ", " + joinColumn);//不能在这里改，后续还要用到:

default:

throw new UnsupportedOperationException(

"服务器内部错误：getColumnString 不支持 " + RequestMethod.getName(getMethod())

+ " 等 [GET,GETS,HEAD,HEADS,POST] 外的ReuqestMethod！"

);

}

}

@Override

public String getValues() {

return values;

}

@JSONField(serialize = false)

public String getValuesString() {

return values;

}

public AbstractSQLConfig setValues(Object[][] valuess) {

String s = "";

if (valuess != null && valuess.length > 0) {

Object[] items = new Object[valuess.length];

Object[] vs;

for (int i = 0; i < valuess.length; i++) {

vs = valuess[i];

if (vs == null) {

continue;

}

items[i] = "(";

for (int j = 0; j < vs.length; j++) {

items[i] += ((j <= 0 ? "" : ",") + getValue(vs[j]));

}

items[i] += ")";

}

s = StringUtil.getString(items);

}

return setValues(s);

}

@Override

public AbstractSQLConfig setValues(String values) {

this.values = values;

return this;

}

@Override

public Map<String, Object> getContent() {

return content;

}

@Override

public AbstractSQLConfig setContent(Map<String, Object> content) {

this.content = content;

return this;

}

@Override

public int getCount() {

return count;

}

@Override

public AbstractSQLConfig setCount(int count) {

this.count = count;

return this;

}

@Override

public int getPage() {

return page;

}

@Override

public AbstractSQLConfig setPage(int page) {

this.page = page;

return this;

}

@Override

public int getPosition() {

return position;

}

@Override

public AbstractSQLConfig setPosition(int position) {

this.position = position;

return this;

}

@Override

public int getQuery() {

return query;

}

@Override

public AbstractSQLConfig setQuery(int query) {

this.query = query;

return this;

}

@Override

public int getType() {

return type;

}

@Override

public AbstractSQLConfig setType(int type) {

this.type = type;

return this;

}

@Override

public List<Join> getJoinList() {

return joinList;

}

@Override

public SQLConfig setJoinList(List<Join> joinList) {

this.joinList = joinList;

return this;

}

@Override

public boolean isTest() {

return test;

}

@Override

public AbstractSQLConfig setTest(boolean test) {

this.test = test;

return this;

}

@Override

public boolean isCacheStatic() {

return cacheStatic;

}

@Override

public AbstractSQLConfig setCacheStatic(boolean cacheStatic) {

this.cacheStatic = cacheStatic;

return this;

}

/**获取初始位置offset

@JSONField(serialize = false)

public int getOffset() {

return getOffset(getPage(), getCount());

}

/**获取初始位置offset

public static int getOffset(int page, int count) {

return page*count;

}

/**获取限制数量

@JSONField(serialize = false)

public String getLimitString() {

return getLimitString(getPage(), getCount());// + 1);

}

/**获取限制数量

public static String getLimitString(int page, int count) {

return count <= 0 ? "" : " LIMIT " + count + " OFFSET " + getOffset(page, count);

}

//WHERE <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

@Override

public Map<String, Object> getWhere() {

return where;

}

@Override

public AbstractSQLConfig setWhere(Map<String, Object> where) {

this.where = where;

return this;

}

@NotNull

@Override

public Map<String, List<String>> getCombine() {

List<String> andList = combine == null ? null : combine.get("&");

if (andList == null) {

andList = where == null ? new ArrayList<String>() : new ArrayList<String>(where.keySet());

if (combine == null) {

combine = new HashMap<>();

}

combine.put("&", andList);

}

return combine;

}

@Override

public AbstractSQLConfig setCombine(Map<String, List<String>> combine) {

this.combine = combine;

return this;

}

/**

@JSONField(serialize = false)

@Override

public Object getWhere(String key) {

return getWhere(key, false);

}

/**

@JSONField(serialize = false)

@Override

public Object getWhere(String key, boolean exactMatch) {

if (exactMatch) {

return where == null ? null : where.get(key);

}

Set<String> set = key == null || where == null ? null : where.keySet();

if (set != null) {

synchronized (where) {

if (where != null) {

int index;

for (String k : set) {

index = k.indexOf(key);

if (index >= 0 && StringUtil.isName(k.substring(index)) == false) {

return where.get(k);

}

}

}

}

}

return null;

}

@Override

public AbstractSQLConfig putWhere(String key, Object value, boolean prior) {

if (key != null) {

if (where == null) {

where = new LinkedHashMap<String, Object>();

}

where.put(key, value);

combine = getCombine();

List<String> andList = combine == null ? null : combine.get("&");

if (value == null) {

andList.remove(key);

}

else if (andList == null || andList.contains(key) == false) {

int i = 0;

if (andList == null) {

andList = new ArrayList<>();

}

else if (prior && andList.isEmpty() == false) {

if (andList.contains(KEY_ID)) {

i ++;

}

if (andList.contains(KEY_ID_IN)) {

i ++;

}

if (andList.contains(KEY_USER_ID)) {

i ++;

}

if (andList.contains(KEY_USER_ID_IN)) {

i ++;

}

}

if (prior) {

andList.add(i, key); //userId的优先级不能比id高 0, key);

} else {

andList.add(key); //AbstractSQLExecutor.onPutColumn里getSQL，要保证缓存的SQL和查询的SQL里 where 的 key:value 顺序一致

}

}

combine.put("&", andList);

}

return this;

}

/**获取WHERE

@JSONField(serialize = false)

@Override

public String getWhereString(boolean hasPrefix) throws Exception {

return getWhereString(hasPrefix, getMethod(), getWhere(), getCombine(), getJoinList(), ! isTest());

}

/**获取WHERE

@JSONField(serialize = false)

public String getWhereString(boolean hasPrefix, RequestMethod method, Map<String, Object> where, Map<String, List<String>> combine, List<Join> joinList, boolean verifyName) throws Exception {

Set<Entry<String, List<String>>> combineSet = combine == null ? null : combine.entrySet();

if (combineSet == null || combineSet.isEmpty()) {

Log.w(TAG, "getWhereString combineSet == null || combineSet.isEmpty() >> return \"\";");

return "";

}

List<String> keyList;

String whereString = "";

boolean isCombineFirst = true;

int logic;

boolean isItemFirst;

String c;

String cs;

for (Entry<String, List<String>> ce : combineSet) {

keyList = ce == null ? null : ce.getValue();

if (keyList == null || keyList.isEmpty()) {

continue;

}

if ("|".equals(ce.getKey())) {

logic = Logic.TYPE_OR;

}

else if ("!".equals(ce.getKey())) {

logic = Logic.TYPE_NOT;

}

else {

logic = Logic.TYPE_AND;

}

isItemFirst = true;

cs = "";

for (String key : keyList) {

c = getWhereItem(key, where.get(key), method, verifyName);

if (StringUtil.isEmpty(c, true)) {//避免SQL条件连接错误

continue;

}

cs += (isItemFirst ? "" : (Logic.isAnd(logic) ? AND : OR)) + "(" + c + ")";

isItemFirst = false;

}

whereString += (isCombineFirst ? "" : AND) + (Logic.isNot(logic) ? NOT : "") + " ( " + cs + " ) ";

isCombineFirst = false;

}

if (joinList != null) {

String newWs = "";

String ws = "" + whereString;

List<Object> newPvl = new ArrayList<>();

List<Object> pvl = new ArrayList<>(preparedValueList);

SQLConfig jc;

String js;

//各种 JOIN 没办法统一用 & | ！连接，只能按优先级，和 @combine 一样?

for (Join j : joinList) {

switch (j.getJoinType()) {

case "":

case "|": //不支持 <>, [] ，避免太多符号

case "&":

case "!":

case "^":

case "*":

jc = j.getJoinConfig();

boolean isMain = jc.isMain();

jc.setMain(false).setPrepared(isPrepared()).setPreparedValueList(new ArrayList<Object>());

js = jc.getWhereString(false);

jc.setMain(isMain);

if (StringUtil.isEmpty(js, true)) {

continue;

}

if (StringUtil.isEmpty(newWs, true) == false) {

newWs += AND;

}

if ("^".equals(j.getJoinType())) { // (A & ! B) | (B & ! A)

newWs += " ( ( " + ws + ( StringUtil.isEmpty(ws, true) ? "" : AND + NOT ) + " ( " + js + " ) ) "

+ OR

+ " ( " + js + AND + NOT + " ( " + ws + " ) ) ) ";

newPvl.addAll(pvl);

newPvl.addAll(jc.getPreparedValueList());