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