| | |
| | | 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"); |
| | |
| | | while (s >= 0) { |
| | | int c = warnContent.indexOf("{#", s); |
| | | if (c == -1) { |
| | | concatField.append(" uuid "); |
| | | break; |
| | | } |
| | | int m = warnContent.indexOf("#}", c); |