| | |
| | | if (!StringUtils.isEmpty(field_reference)) { |
| | | if (field_reference.indexOf("《") == 0 && field_reference.indexOf("》") > 0) { |
| | | //普通参照 |
| | | filters.add(getDictFilter(fieldName, field_reference.replace("《", "").replace("》", ""))); |
| | | filters.add(getDictFilter(getFieldName(tableAlias, fieldName), field_reference.replace("《", "").replace("》", ""))); |
| | | continue; |
| | | } else { |
| | | if (poolCache == null) { |
| | |
| | | } |
| | | FieldSetEntity ff = prompt.getFieldSetEntity(0); |
| | | StringBuilder p = new StringBuilder(); |
| | | p.append(fieldName).append(" in ").append(" ( SELECT ").append(ff.getString("value_field")).append(" FROM ").append(ff.getString("source_table")); |
| | | p.append(getFieldName(tableAlias, fieldName)).append("` in ").append(" ( SELECT `").append(ff.getString("value_field")).append("` FROM ").append(ff.getString("source_table")); |
| | | p.append(" WHERE ").append(ff.getString("view_fields")).append(" like concat('%','~val~','%') )"); |
| | | filters.add(p.toString()); |
| | | continue; |
| | |
| | | } |
| | | |
| | | if (!StringUtils.isEmpty(faceField.getFieldName())) { |
| | | fieldNames.add(StringUtils.isEmpty(tableAlias) ? faceField.getFieldName() : ("`" + tableAlias + "`.`" + fieldName + "`")); |
| | | fieldNames.add(getFieldName(tableAlias, fieldName)); |
| | | } |
| | | } |
| | | //获取redis 起始key |
| | |
| | | return maps; |
| | | } |
| | | |
| | | private String getFieldName(String tableAlias, String fieldName) { |
| | | fieldName = "`" + fieldName + "`"; |
| | | if (!StringUtils.isEmpty(tableAlias)) { |
| | | return "`" + tableAlias + "`." + fieldName; |
| | | } |
| | | return fieldName; |
| | | } |
| | | |
| | | /** |
| | | * 字段实体类 |
| | | */ |