列表搜索，取列表别名错误

shicf

3 天以前 c18646fe51ad7f329a3430faa56bf0335f8f80f9

列表搜索，取列表别名错误

 src/main/java/com/product/face/entity/FaceListEntity.java

@@ -437,13 +437,13 @@
    private String getFieldName(Map<String, List<String>> tableAlias,Map<String, List<String>> aliasField, Map<String, List<String>> tableAndField, String fieldName) {    
        String table=null;
        boolean b=false;
        if(!tableAndField.isEmpty()) {
        if(tableAndField!=null && !tableAndField.isEmpty()) {
            for(String key:tableAndField.keySet()) {
                for(String field:tableAndField.get(key)) {
                    if(fieldName.equals(field)) {
                        
                        List<String>alias=tableAlias.get(key);
                        if(!alias.isEmpty()) {
                        if(alias!=null && !alias.isEmpty()) {
                            table=alias.get(0);//取第一个别名
                        }
                        b=true;

 src/main/java/com/product/face/service/FaceListSearchService.java

@@ -95,12 +95,12 @@
            face = JSON.parseObject(JSON.toJSONString(RedisUtil.get(FaceConst.FACE_LIST_KEY + faceUuid)), FaceListEntity.class);
        }
        if (face != null) {
            String tableAlias = null;
            String tableName = face.getTableName();
            List<String> t = aliasTable.get(tableName);
            if (t != null && t.size() > 0) {
                tableAlias = t.get(0);
            }
//            String tableAlias = null;
//            String tableName = face.getTableName();
//            List<String> t = aliasTable.get(tableName);
//            if (t != null && t.size() > 0) {
//                tableAlias = t.get(0);
//            }
            Map<String, List<String>> params = face.getFilters(aliasTable, aliasField,tableOfField);
            List<String> fieldNames = params.get("fields");
            List<String> filters = params.get("filter");