列表高级搜索无效

2369059705@qq.com

2023-06-12 b18c5b8db781dd2c057ede09d07f4f88d0eaef0b

列表高级搜索无效

 src/main/java/com/product/server/report/service/ReportConfigService.java

@@ -51,12 +51,18 @@

        List<Object> paramList = Lists.newArrayList();
        StringBuilder sql = new StringBuilder(512);
        String queryFilter = " ";
        if(!BaseUtil.dataTableIsEmpty(fse.getSubDataTable("systemSeniorQueryString"))){
            queryFilter ="AND"+ queryFilterService.getQueryFilter(fse);
        }
        sql.append("\nSELECT a.uuid,a.type_uuid,a.is_valid,a.org_level_uuid,a.report_name,b.type_name,b.type_group")
                .append("\nFROM product_sys_report_config a")
                .append("\nLEFT JOIN product_sys_report_type_config b ON a.type_uuid = b.uuid")
                .append("\nwhere (function_uuid is null or function_uuid='') ");
                .append("\nwhere (function_uuid is null or function_uuid='') ")
                .append(queryFilter);

        if (!StringUtils.isEmpty(fse.getString(CmnConst.TYPE_UUID))) {
            sql.append("\nand b.type_group=?");
            sql.append("\nand b.type_group=? ");
            paramList.add(fse.getString(CmnConst.TYPE_UUID));
        }
        return baseDao.listTable(sql.toString(), paramList.toArray(), pageSize, cpage);