| | |
|---|
| | | 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; |
|---|
