代码提交

杜洪波

2024-06-18 160309ee65ffc6bd0dc5448ece27064e6cec4eb3

代码提交

 src/main/java/com/product/administration/service/CustomerInfoService.java

@@ -45,11 +45,14 @@
        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("    A.uuid,A.customer_name, 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 (!BaseUtil.strIsNull(searchFilter)) {
            sbSql.append("WHERE ").append(searchFilter);
        }
		
//        if(!StringUtils.isEmpty(dataFilter)) {
//            if (!StringUtils.isEmpty(searchFilter)) {
//                dataFilter+=" AND "+ searchFilter;