杜洪波
2024-06-06 7f230f4a07f67e81ab49e81c4154b3586e2c79ec
代码提交
已修改1个文件
11 ■■■■ 文件已修改
src/main/java/com/product/administration/service/CustomerInfoService.java 11 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/product/administration/service/CustomerInfoService.java
@@ -43,7 +43,13 @@
//        String dataFilter=permissionService.getDataFilter(CmnConst.CREATED_BY) ;
        //高级查询
        String searchFilter=queryFilterService.getQueryFilter(fse);
        StringBuilder sbSql = new StringBuilder();
        sbSql.append("SELECT \n");
        sbSql.append("    A.uuid, A.customer_manager, A.customer_manager_leader,A.business_agent, \n");
        sbSql.append("    CONCAT(B.linkman, '-', B.mobile) AS customer_contact \n");
        sbSql.append("FROM product_project_customer A \n");
        sbSql.append("LEFT JOIN product_project_customer_sub B ON B.customer_uuid = A.uuid \n");
        sbSql.append(searchFilter);
//        if(!StringUtils.isEmpty(dataFilter)) {
//            if (!StringUtils.isEmpty(searchFilter)) {
//                dataFilter+=" AND "+ searchFilter;
@@ -54,7 +60,8 @@
//            }
//        }
        
        DataTableEntity dt=baseDao.listTable(CmnConst.product_project_CUSTOMER, searchFilter, null, null, null, pageSize, cpage);
//        DataTableEntity dt=baseDao.listTable(CmnConst.product_project_CUSTOMER, searchFilter, null, null, null, pageSize, cpage);
        DataTableEntity dt = baseDao.listTable(sbSql.toString(), new Object[] {}, pageSize, cpage);
        baseDao.loadPromptData(dt);
        return dt;
    }