| | |
|---|
| | | |
|---|
| | | List<Object> paramList = Lists.newArrayList(); |
|---|
| | | StringBuilder sql = new StringBuilder(512); |
|---|
| | | String queryFilter = " "; |
|---|
| | | if(!BaseUtil.dataTableIsEmpty(fse.getSubDataTable("systemSeniorQueryString"))){ |
|---|
| | | queryFilter ="AND"+ queryFilterService.getQueryFilter(fse); |
|---|
| | | } |
|---|
| | | sql.append("\nSELECT a.uuid,a.type_uuid,a.is_valid,a.org_level_uuid,a.report_name,b.type_name,b.type_group") |
|---|
| | | .append("\nFROM product_sys_report_config a") |
|---|
| | | .append("\nLEFT JOIN product_sys_report_type_config b ON a.type_uuid = b.uuid") |
|---|
| | | .append("\nwhere (function_uuid is null or function_uuid='') "); |
|---|
| | | .append("\nwhere (function_uuid is null or function_uuid='') ") |
|---|
| | | .append(queryFilter); |
|---|
| | | |
|---|
| | | if (!StringUtils.isEmpty(fse.getString(CmnConst.TYPE_UUID))) { |
|---|
| | | sql.append("\nand b.type_group=?"); |
|---|
| | | sql.append("\nand b.type_group=? "); |
|---|
| | | paramList.add(fse.getString(CmnConst.TYPE_UUID)); |
|---|
| | | } |
|---|
| | | return baseDao.listTable(sql.toString(), paramList.toArray(), pageSize, cpage); |
|---|
