| | |
| | | String queryFilter = queryFilterService.getQueryFilter(fse); |
| | | StringBuilder sb = new StringBuilder(); |
| | | sb.append("SELECT * FROM( \n"); |
| | | sb.append("SELECT A.*,B.project_number,B.project_name AS project_name_label,E.user_name AS apply_label \n"); |
| | | sb.append("SELECT A.*,B.project_name AS project_name_label,E.user_name AS apply_label \n"); |
| | | sb.append("FROM product_project_performance_commission A \n"); |
| | | sb.append("LEFT JOIN product_project_business B ON B.uuid = A.project_uuid \n"); |
| | | sb.append("LEFT JOIN product_sys_users E ON E.user_id = A.apply_user \n"); |