帮助分类服务
| 26 | * 帮助分类服务 |
| 27 | */ |
| 28 | @Service |
| 29 | public class HelpTypeServiceImpl implements HelpTypeService { |
| 30 | private static final Logger logger = LogManager.getLogger(HelpTypeServiceImpl.class); |
| 31 | |
| 32 | |
| 33 | @Resource HelpTypeRepository helpTypeRepository; |
| 34 | @Resource |
| 35 | SettingRepository settingRepository; |
| 36 | @Resource |
| 37 | FileComponent fileComponent; |
| 38 | @Resource |
| 39 | HelpTypeComponent helpTypeComponent; |
| 40 | |
| 41 | //完整路径 |
| 42 | private record FullPath(String imagePath, String fileName) { |
| 43 | } |
| 44 | |
| 45 | /** |
| 46 | * 获取标签列表 |
| 47 | * |
| 48 | * @param parentId 父标签 |
| 49 | * @param fileServerAddress 文件服务器地址 |
| 50 | * @param page 页码 |
| 51 | * @return |
| 52 | */ |
| 53 | public PageView<HelpType> getHelpTypeList(Long parentId, String fileServerAddress, int page) { |
| 54 | StringBuffer jpql = new StringBuffer(""); |
| 55 | //存放参数值 |
| 56 | List<Object> params = new ArrayList<Object>(); |
| 57 | |
| 58 | |
| 59 | //如果所属父类有值 |
| 60 | if(parentId != null && parentId >0L){ |
| 61 | jpql.append(" and o.parentId=?"+ (params.size()+1));//所属父类的ID;(params.size()+1)是为了和下面的条件参数兼容 |
| 62 | params.add(parentId);//设置o.parentId=?2参数 |
| 63 | }else{//如果没有父类 |
| 64 | // jpql.append(" and o.parent is null"); |
| 65 | jpql.append(" and o.parentId=?"+ (params.size()+1)); |
| 66 | params.add(0L); |
| 67 | } |
| 68 | |
| 69 | PageView<HelpType> pageView = new PageView<HelpType>(settingRepository.findSystemSetting_cache().getBackstagePageNumber(),page,10); |
| 70 | //当前页 |
| 71 | int firstindex = (page-1)*pageView.getMaxresult();; |
| 72 | //排序 |
| 73 | LinkedHashMap<String,String> orderby = new LinkedHashMap<String,String>(); |
| 74 | |
| 75 | orderby.put("sort", "desc");//根据typeid字段降序排序 |
| 76 | |
| 77 | |
| 78 | //删除第一个and |
| 79 | String jpql_str = StringUtils.difference(" and", jpql.toString()); |
| 80 | |
| 81 | //调用分页算法类 |
| 82 | QueryResult<HelpType> qr = helpTypeRepository.getScrollData(HelpType.class, firstindex, pageView.getMaxresult(), jpql_str, params.toArray(),orderby); |
| 83 | |
| 84 | pageView.setQueryResult(qr); |
| 85 |
nothing calls this directly
no outgoing calls
no test coverage detected
searching dependent graphs…