package cn.chnmuseum.party.web.controller; import cn.chnmuseum.party.auth.SHA256PasswordEncryptionService; import cn.chnmuseum.party.auth.util.AESUtils; import cn.chnmuseum.party.auth.util.JwtTokenUtil; import cn.chnmuseum.party.common.enums.AuditOperationEnum; import cn.chnmuseum.party.common.enums.FileCatEnum; import cn.chnmuseum.party.common.enums.FileTypeEnum; import cn.chnmuseum.party.common.enums.LanguageEnum; import cn.chnmuseum.party.common.util.TimeUtils; import cn.chnmuseum.party.common.validator.groups.Add; import cn.chnmuseum.party.common.vo.GenericPageParam; import cn.chnmuseum.party.model.*; import cn.chnmuseum.party.service.*; import cn.chnmuseum.party.service.impl.*; import cn.chnmuseum.party.web.controller.base.BaseController; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import io.swagger.annotations.Api; import io.swagger.annotations.ApiImplicitParam; import io.swagger.annotations.ApiImplicitParams; import io.swagger.annotations.ApiOperation; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang3.StringUtils; import org.apache.shiro.authc.DisabledAccountException; import org.apache.shiro.authc.IncorrectCredentialsException; import org.apache.shiro.authz.annotation.RequiresAuthentication; import org.springframework.data.redis.core.StringRedisTemplate; import org.springframework.scheduling.annotation.Scheduled; import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import java.time.LocalDate; import java.time.LocalDateTime; import java.util.*; import java.util.concurrent.TimeUnit; import java.util.stream.Collectors; @Slf4j @RestController() @RequestMapping("/cmRestApi") @Api(tags = {"中国移动API"}) public class ChinaMobileRestApiController extends BaseController { @Resource private StringRedisTemplate stringRedisTemplate; @Resource private TUserServiceImpl userService; @Resource private TOrganServiceImpl organService; @Resource private RunLogServiceImpl runLogService; @Resource private AssetServiceImpl assetService; @Resource private VideoContentService videoContentService; @Resource private TBoxOperationServiceImpl boxOperationService; @Resource private ExhibitionBoardService exhibitionBoardService; @Resource private TBoardStatisticService tBoardStatisticService; @Resource private LearningProjectService learningProjectService; @Resource private LearningContentService learningContentService; @Resource private ExhibitionBoardCatService exhibitionBoardCatService; @Resource private CopyrightOwnerService copyrightOwnerService; @Resource private LearningContentBoardService learningContentBoardService; @Resource private TAppVersionService appVersionService; @Resource private TAppDirPicService appDirPicService; @Resource private TAppRunPicService appRunPicService; private static final String SHIRO_JWT_TOKEN = "shiro:jwt:token:"; //用户登录次数计数 redisKey 前缀 private static final String SHIRO_LOGIN_COUNT = "shiro_login_count_"; //用户登录是否被锁定 一小时 redisKey 前缀 private static final String SHIRO_IS_LOCK = "shiro_is_lock_"; @ApiOperation(value = "获取机顶盒密钥", notes = "获取机顶盒密钥") @GetMapping("/equitment/key") @RequiresAuthentication //@RequiresPermissions("equitment:key") public Map<String, Object> getBoxPrivateKey(@RequestParam(value = "mac") String mac) { try { String macAddress = mac.trim().toUpperCase().replaceAll("-|_", ":"); final LambdaQueryWrapper<TBoxOperation> queryWrapper = Wrappers.<TBoxOperation>lambdaQuery().eq(TBoxOperation::getMac, macAddress); final TBoxOperation tBoxOperation = this.boxOperationService.getOne(queryWrapper); if (tBoxOperation != null) { final String organId = tBoxOperation.getOrganId(); final TUser tUser = getcurUser(); if (tUser != null && organId.equals(tUser.getOrgId())) { // final String countStr = this.stringRedisTemplate.opsForValue().get(macAddress + "_count"); // if (StringUtils.isNotBlank(countStr)) { // final long count = Long.parseLong(countStr); // if (count > 1) { // JSONObject jsonObject = new JSONObject(); // jsonObject.put("key", ""); // return getFailResult("400", "已经获取过一次,无法再次获取", jsonObject); // } // } else if (tBoxOperation.getRequestCount() > 1) { // JSONObject jsonObject = new JSONObject(); // jsonObject.put("key", ""); // return getFailResult("400", "已经获取过一次,无法再次获取", jsonObject); // } // this.stringRedisTemplate.opsForValue().increment(macAddress + "_count"); // tBoxOperation.setRequestCount(tBoxOperation.getRequestCount() + 1); // this.boxOperationService.updateById(tBoxOperation); JSONObject jsonObject = new JSONObject(); jsonObject.put("key", tBoxOperation.getPrivateKey()); return getResult(jsonObject); } else { return getFailResult("400", "您无权获取此机顶盒密钥"); } } return getFailResult("400", "系统未查询到此机顶盒相关信息"); } catch (Exception e) { e.printStackTrace(); } return getFailResult(); } @ApiOperation(value = "机顶盒激活状态查询", notes = "机顶盒激活状态查询") @GetMapping("/equitment/activity") //@RequiresAuthentication //@RequiresPermissions("/equitment/activity/") public Map<String, Object> getActivity(@RequestParam(required = true) String mac) { try { UpdateWrapper<TBoxOperation> wrapper = new UpdateWrapper<>(); wrapper.eq("mac", mac); TBoxOperation one = boxOperationService.getOne(wrapper); HashMap<Object, Object> map = new HashMap<>(); map.put("activityStatus", false); if (one != null) { map.put("activityStatus", true); } return getResult(map); } catch (Exception e) { e.printStackTrace(); } return getFailResult(); } @RequestMapping(value = "/user/webLogin", method = RequestMethod.POST) public Map<String, Object> login(@RequestParam(value = "username") String username, @RequestParam(value = "password") String password, @RequestParam(value = "mac") String mac) { JSONObject resultMap = new JSONObject(true); TUser user; if (StringUtils.isNoneBlank(username)) { try { //访问一次,计数一次 // ValueOperations<String, String> opsForValue = stringRedisTemplate.opsForValue(); // if ("LOCK".equals(opsForValue.get(SHIRO_IS_LOCK + username))) { // resultMap.put("resultCode", "400"); // resultMap.put("message", "由于密码输入错误次数大于5次,12小时内帐号已禁止登录!请您联系相关管理人员,联系电话:13924551212,邮箱:325346534@zh.com。"); // return ResponseEntity.status(HttpStatus.INTERNAL_SERVER_ERROR).body(resultMap); // } user = userService.selectByUsername(username); if (user == null) { resultMap.put("resultCode", "400"); resultMap.put("message", "用户名或密码不正确!"); return resultMap; } TBoxOperation operation = boxOperationService.getOne(new UpdateWrapper<TBoxOperation>().eq("organ_id", user.getOrgId())); if (operation == null || "".equals(operation.getMac())) { resultMap.put("resultCode", "400"); resultMap.put("message", "用户未激活!"); return resultMap; } //解密 mac = AESUtils.aesDecrypt(mac); password = AESUtils.aesDecrypt(password); if (!mac.equals(operation.getMac())) { resultMap.put("resultCode", "400"); resultMap.put("message", "mac地址不正确!"); return resultMap; } if (AuditOperationEnum.DISABLE.name().equals(user.getStatus())) { throw new DisabledAccountException("此帐号已禁用,请联系管理员!"); } if (user.getPermanent() != null && !user.getPermanent()) { if (user.getEffectiveDate().isAfter(LocalDate.now()) || user.getExiredDate().isBefore(LocalDate.now())) { throw new DisabledAccountException("此帐号已失效,请联系管理员!"); } } byte[] salt = user.getPasswordSalt(); if (!new String(SHA256PasswordEncryptionService.createPasswordHash(password, salt)).equals(new String(user.getPasswordHash()))) { // opsForValue.increment(SHIRO_LOGIN_COUNT + username, 1); // //计数大于5时,设置用户被锁定一小时 // String s = opsForValue.get(SHIRO_LOGIN_COUNT + username); // if (StringUtils.isNotBlank(s)) { // if (Integer.parseInt(s) >= 5) { // opsForValue.set(SHIRO_IS_LOCK + username, "LOCK"); // stringRedisTemplate.expire(SHIRO_IS_LOCK + username, 12, TimeUnit.HOURS); // } // } throw new IncorrectCredentialsException("用户名或密码不正确!"); } String token = JwtTokenUtil.sign(username, user.getId()); // 将token信息存入Redis stringRedisTemplate.opsForValue().set(SHIRO_JWT_TOKEN + token, user.getId(), 240, TimeUnit.MINUTES); JSONObject jsonObject = new JSONObject(true); jsonObject.put("token", token); jsonObject.put("userId", user.getId()); jsonObject.put("userName", user.getUserName()); jsonObject.put("expire", TimeUtils.format(LocalDateTime.now().plusMinutes(240), TimeUtils.FORMAT_ONE)); jsonObject.put("orgCode", user.getOrgId()); jsonObject.put("orgName", user.getOrgName()); resultMap.put("resultCode", "200"); resultMap.put("message", "登录成功"); resultMap.put("data", jsonObject); return resultMap; } catch (Exception e) { resultMap.put("resultCode", "500"); resultMap.put("message", e.getMessage()); } } return getFailResult(resultMap.get("message")); } @ApiOperation(value = "获取单个成员信息") @GetMapping(value = "/user/getUserInfo") @RequiresAuthentication public Map<String, Object> getById(String userId) { JSONObject resultMap = new JSONObject(true); try { TUser user = userService.getById(userId); TOrgan organ = organService.getById(user.getOrgId()); if (null == user) { resultMap.put("resultCode", "400"); resultMap.put("message", "用户不存在"); resultMap.put("data", ""); return resultMap; } JSONObject jsonObject = new JSONObject(true); jsonObject.put("userId", user.getId()); jsonObject.put("userName", user.getUserName()); // long expire = stringRedisTemplate.getExpire(SHIRO_JWT_TOKEN + token) == null ? 0L : stringRedisTemplate.getExpire(SHIRO_JWT_TOKEN + token); //jsonObject.put("expire", TimeUtils.format(LocalDateTime.now().plusMinutes(expire), TimeUtils.FORMAT_ONE)); jsonObject.put("effectiveDate", user.getEffectiveDate()); jsonObject.put("expireDate", user.getExiredDate()); jsonObject.put("orgCode", user.getOrgId()); jsonObject.put("orgName", organ.getName()); resultMap.put("resultCode", "200"); resultMap.put("message", "成功"); resultMap.put("data", jsonObject); return resultMap; } catch (Exception e) { resultMap.put("resultCode", "500"); resultMap.put("message", "获取单个成员信息失败!"); } return getFailResult(); } @RequestMapping(value = "/user/logout", method = RequestMethod.GET) @RequiresAuthentication public Map<String, Object> logout() { String token = request.getHeader("Authorization"); JSONObject resultMap = new JSONObject(true); if (token.startsWith("Bearer ")) { token = token.substring(7); } try { if (StringUtils.isNotBlank(token)) { // SecurityUtils.getSubject().logout(); this.stringRedisTemplate.delete(SHIRO_JWT_TOKEN + token); } resultMap.put("resultCode", "200"); resultMap.put("message", "成功"); resultMap.put("data", ""); return resultMap; } catch (Exception e) { resultMap.put("resultCode", "500"); resultMap.put("message", "注销错误!"); } return getFailResult("注销错误!"); } /** * 插入机顶盒日志表 */ @ApiOperation(value = "插入机顶盒日志表", notes = "插入机顶盒日志表") @PostMapping(value = "/equitment/runLog") @RequiresAuthentication public Map<String, Object> insertRunLog(RunLog runLog) { JSONObject resultMap = new JSONObject(); try { boolean b = runLogService.insertRunLog(runLog); resultMap.put("resultCode", "200"); resultMap.put("message", "成功"); resultMap.put("data", ""); return resultMap; } catch (Exception e) { resultMap.put("resultCode", "500"); resultMap.put("message", "失败"); resultMap.put("data", ""); } return getFailResult(); } @ApiImplicitParams(value = { @ApiImplicitParam(name = "boardId", value = "展板内容ID", paramType = "query", dataType = "String", required = true) }) @ApiOperation(value = "查询展板视频/语音导览语言列表", notes = "查询展板视频/语音导览语言列表") @GetMapping(value = "/exhibitionBoard/language") @RequiresAuthentication public Map<String, Object> getExhibitionBoardVideoLanguageList(@RequestParam(value = "boardId") String boardId) { JSONObject resultMap = new JSONObject(); Map<String, List<Map<String, String>>> langMap = new LinkedHashMap<>(2); try { List<Map<String, String>> videoList = new ArrayList<>(); final ExhibitionBoard exhibitionBoard = this.exhibitionBoardService.getById(boardId); final String videoContentId = exhibitionBoard.getVideoContentId(); LambdaQueryWrapper<Asset> assetLambdaQueryWrapper = Wrappers.<Asset>lambdaQuery().eq(Asset::getRefItemId, videoContentId).eq(Asset::getPublished, true);; List<Asset> assetList = this.assetService.list(assetLambdaQueryWrapper); List<String> languageList = assetList.stream().map(Asset::getLanguage).collect(Collectors.toList()); for (LanguageEnum languageEnum : LanguageEnum.values()) { if (languageList.contains(languageEnum.name())) { Map<String, String> map = new LinkedHashMap<>(1); map.put("code", languageEnum.name()); map.put("name", languageEnum.getName()); videoList.add(map); } } langMap.put("video", videoList); assetLambdaQueryWrapper.clear(); List<Map<String, String>> audioList = new ArrayList<>(); assetLambdaQueryWrapper = Wrappers.<Asset>lambdaQuery().eq(Asset::getRefItemId, boardId); assetLambdaQueryWrapper.eq(Asset::getPublished, true); assetLambdaQueryWrapper.eq(Asset::getFileCat, FileCatEnum.EXHIBITION_BOARD_AUDIO); assetList = this.assetService.list(assetLambdaQueryWrapper); languageList = assetList.stream().map(Asset::getLanguage).collect(Collectors.toList()); for (LanguageEnum languageEnum : LanguageEnum.values()) { if (languageList.contains(languageEnum.name())) { Map<String, String> map = new LinkedHashMap<>(1); map.put("code", languageEnum.name()); map.put("name", languageEnum.getName()); audioList.add(map); } } langMap.put("audio", audioList); resultMap.put("resultCode", "200"); resultMap.put("message", "成功"); resultMap.put("data", langMap); return resultMap; } catch (Exception e) { resultMap.put("resultCode", "400"); resultMap.put("message", "该展板已下架"); resultMap.put("data", ""); } return getFailResult("400", "该展板已下架"); } @ApiImplicitParams(value = { @ApiImplicitParam(name = "_index", value = "分页起始偏移量", paramType = "query", dataType = "Integer"), @ApiImplicitParam(name = "_size", value = "返回条数", paramType = "query", dataType = "Integer"), @ApiImplicitParam(name = "learningContentId", value = "学习内容ID", paramType = "query", dataType = "String") }) @PostMapping("/exhibitionBoard/getPage") @RequiresAuthentication //@RequiresPermissions("exhibition:board:page") @ApiOperation(value = "展板列表查询", notes = "展板列表查询") public Map<String, Object> getExhibitionBoardPageList(@RequestParam(value = "learningContentId", required = false) String learningContentId) { final IPage<ExhibitionBoard> page = this.learningContentBoardService.getBoardPageByLearningContentId(getPage(), learningContentId, null); for (ExhibitionBoard exhibitionBoard : page.getRecords()) { exhibitionBoard.setLearningContentId(learningContentId); if (exhibitionBoard.getVideoContentCopyrightOwnerId() != null) { String name = this.copyrightOwnerService.getById(exhibitionBoard.getVideoContentCopyrightOwnerId()).getName(); exhibitionBoard.setBoardCopyrightOwnerName(name); } if (exhibitionBoard.getExhibitionBoardCatId() != null) { String name = this.exhibitionBoardCatService.getById(exhibitionBoard.getExhibitionBoardCatId()).getName(); exhibitionBoard.setExhibitionBoardCatName(name); } if (exhibitionBoard.getVideoContentId() != null) { final VideoContent videoContent = this.videoContentService.getById(exhibitionBoard.getVideoContentId()); if (videoContent != null) { exhibitionBoard.setBoardVideoContentThumbnail(videoContent.getThumbnail()); } } LambdaQueryWrapper<Asset> assetQueryWrapper = Wrappers.<Asset>lambdaQuery().eq(Asset::getRefItemId, exhibitionBoard.getVideoContentId()); assetQueryWrapper.eq(Asset::getPublished, true); assetQueryWrapper.eq(Asset::getFileCat, FileCatEnum.VIDEO_CONTENT.name()); List<Asset> videoList = this.assetService.list(assetQueryWrapper); assetQueryWrapper.clear(); assetQueryWrapper = Wrappers.<Asset>lambdaQuery().eq(Asset::getRefItemId, exhibitionBoard.getId()); assetQueryWrapper.eq(Asset::getPublished, true); assetQueryWrapper.eq(Asset::getFileCat, FileCatEnum.EXHIBITION_BOARD_DATUM.name()); List<Asset> datumList = this.assetService.list(assetQueryWrapper); exhibitionBoard.setDatumList(datumList); videoList.addAll(datumList.stream().filter(x -> FileTypeEnum.VIDEO.name().equalsIgnoreCase(x.getFileType())).collect(Collectors.toList())); exhibitionBoard.setVideoList(videoList); } return getResult(page); } @ApiOperation(value = "展板详情查询", notes = "展板详情查询") @ApiImplicitParams({ @ApiImplicitParam(name = "boardId", value = "展板ID", dataType = "String", paramType = "query"), @ApiImplicitParam(name = "videoLanguage", value = "语言", dataType = "String", paramType = "query"), @ApiImplicitParam(name = "audioLanguage", value = "语言", dataType = "String", paramType = "query") }) @GetMapping("/exhibitionBoard/getBoardInfo") @RequiresAuthentication public Map<String, Object> getById(@RequestParam(value = "boardId") String id, @RequestParam(value = "videoLanguage", required = false) LanguageEnum videoLanguage, @RequestParam(value = "audioLanguage", required = false) LanguageEnum audioLanguage) { ExhibitionBoard exhibitionBoard = exhibitionBoardService.getById(id); String exhibitionBoardCatId = exhibitionBoard.getExhibitionBoardCatId(); if (exhibitionBoardCatId != null) { exhibitionBoard.setExhibitionBoardCatName(this.exhibitionBoardCatService.getById(exhibitionBoardCatId).getName()); } String boardCopyrightOwnerId = exhibitionBoard.getBoardCopyrightOwnerId(); if (boardCopyrightOwnerId != null) { exhibitionBoard.setBoardCopyrightOwnerName(this.copyrightOwnerService.getById(boardCopyrightOwnerId).getName()); } if (exhibitionBoard.getVideoContentCopyrightOwnerId() != null) { String name = this.copyrightOwnerService.getById(exhibitionBoard.getVideoContentCopyrightOwnerId()).getName(); exhibitionBoard.setVideoContentCopyrightOwnerName(name); } if (exhibitionBoard.getVideoContentId() != null) { String thumbnail = this.videoContentService.getById(exhibitionBoard.getVideoContentId()).getThumbnail(); exhibitionBoard.setBoardVideoContentThumbnail(thumbnail); } LambdaQueryWrapper<Asset> assetQueryWrapper = Wrappers.<Asset>lambdaQuery().eq(Asset::getRefItemId, id); assetQueryWrapper.eq(Asset::getPublished, true); assetQueryWrapper.eq(Asset::getFileCat, FileCatEnum.EXHIBITION_BOARD_AUDIO.name()); if (audioLanguage != null) { assetQueryWrapper.eq(Asset::getLanguage, audioLanguage.name()); } final List<Asset> audioList = this.assetService.list(assetQueryWrapper); exhibitionBoard.setAudioList(audioList); assetQueryWrapper.clear(); assetQueryWrapper = Wrappers.<Asset>lambdaQuery().eq(Asset::getRefItemId, id); assetQueryWrapper.eq(Asset::getPublished, true); assetQueryWrapper.eq(Asset::getFileCat, FileCatEnum.EXHIBITION_BOARD_DATUM.name()); final List<Asset> datumList = this.assetService.list(assetQueryWrapper); exhibitionBoard.setDatumList(datumList); final String videoContentId = exhibitionBoard.getVideoContentId(); if (videoContentId != null) { final VideoContent videoContent = this.videoContentService.getById(videoContentId); exhibitionBoard.setVideoContentName(videoContent.getName()); assetQueryWrapper.clear(); assetQueryWrapper = Wrappers.<Asset>lambdaQuery().eq(Asset::getRefItemId, videoContentId); assetQueryWrapper.eq(Asset::getPublished, true); assetQueryWrapper.eq(Asset::getFileCat, FileCatEnum.VIDEO_CONTENT.name()); if (videoLanguage != null) { assetQueryWrapper.eq(Asset::getLanguage, videoLanguage.name()); } final List<Asset> videoList = this.assetService.list(assetQueryWrapper); exhibitionBoard.setVideoList(videoList); } return getResult(exhibitionBoard); } @PostMapping("/equitment/playLog") @RequiresAuthentication //@RequiresPermissions("t:board:statistic:statisticBoardInfo") @ApiOperation(value = "播放记录信息反馈", notes = "播放记录信息反馈") public Map<String, Object> boardStatisticInfo(@Validated(value = {Add.class}) TBoardStatistic tBoardStatistic) { // 展板信息统计 try { Object result = tBoardStatisticService.boardStatisticInfo(tBoardStatistic, false); // 返回操作结果 if (result != null && (boolean) result) { return getSuccessResult(); } } catch (Exception e) { e.printStackTrace(); } // 保存失败 return getFailResult(); } @Scheduled(cron = "0 0/5 * * * *") public void boardStatistic() { try { System.out.println("定时汇总播放记录开始..."); tBoardStatisticService.boardStatisticInfo(null, true); System.out.println("定时汇总播放记录成功..."); } catch (Exception e) { e.printStackTrace(); } } @ApiImplicitParams(value = { @ApiImplicitParam(name = "_index", value = "分页起始偏移量", paramType = "query", dataType = "Integer"), @ApiImplicitParam(name = "_size", value = "返回条数", paramType = "query", dataType = "Integer"), @ApiImplicitParam(name = "learningProjectId", value = "学习项目ID", paramType = "query", dataType = "String"), @ApiImplicitParam(name = "nameOrCode", value = "名称或编码", paramType = "query", dataType = "String") }) @PostMapping("/learningContent/getPage") @RequiresAuthentication //@RequiresPermissions("learning:content:page") @ApiOperation(value = "查询学习内容", notes = "查询学习内容") public Map<String, Object> getLearningContentPageList(GenericPageParam genericPageParam, @RequestParam(value = "learningProjectId", required = false) String learningProjectId) { LambdaQueryWrapper<LearningContent> queryWrapper = new LambdaQueryWrapper<>(); queryWrapper.eq(LearningContent::getPublished, true); // 对名称或编码模糊查询 if (StringUtils.isNotBlank(learningProjectId)) { queryWrapper.eq(LearningContent::getLearningProjectId, learningProjectId); } // 对名称或编码模糊查询 if (StringUtils.isNotBlank(genericPageParam.getNameOrCode())) { queryWrapper.like(LearningContent::getName, genericPageParam.getNameOrCode()); } // 根据创建时间区间检索 if (genericPageParam.getStartDate() != null && genericPageParam.getEndDate() != null) { queryWrapper.ge(LearningContent::getCreateTime, genericPageParam.getStartDate().atTime(0, 0, 0)) .le(LearningContent::getCreateTime, genericPageParam.getEndDate().atTime(23, 59, 59)); } // 设置排序规则 queryWrapper.orderByDesc(LearningContent::getSortorder); // 设置查询内容 queryWrapper.select( LearningContent::getId, LearningContent::getName, LearningContent::getCover, LearningContent::getSortorder, LearningContent::getCreateTime, LearningContent::getUpdateTime); Page<LearningContent> page = this.learningContentService.page(getPage(), queryWrapper); for (LearningContent learningContent : page.getRecords()) { LambdaQueryWrapper<LearningContentBoard> lambdaQueryWrapper = Wrappers.<LearningContentBoard>lambdaQuery().eq(LearningContentBoard::getLearningContentId, learningContent.getId()); int exhibitionBoardCount = this.learningContentBoardService.count(lambdaQueryWrapper); learningContent.setExhibitionBoardCount(exhibitionBoardCount); } return getResult(page); } @ApiImplicitParams(value = { @ApiImplicitParam(name = "_index", value = "分页起始偏移量", paramType = "query", dataType = "Integer"), @ApiImplicitParam(name = "_size", value = "返回条数", paramType = "query", dataType = "Integer"), @ApiImplicitParam(name = "nameOrCode", value = "名称或编码", paramType = "query", dataType = "String"), @ApiImplicitParam(name = "startDate", value = "创建时间-开始", paramType = "query", dataType = "String"), @ApiImplicitParam(name = "endDate", value = "创建时间-结束", paramType = "query", dataType = "String") }) @PostMapping("/learningProject/getPage") @RequiresAuthentication //@RequiresPermissions("learning:project:page") @ApiOperation(value = "查询学习项目", notes = "查询学习项目") public Map<String, Object> getLearningProjectPageList(GenericPageParam genericPageParam) { LambdaQueryWrapper<LearningProject> queryWrapper = new LambdaQueryWrapper<>(); // 对名称或编码模糊查询 if (StringUtils.isNotBlank(genericPageParam.getNameOrCode())) { queryWrapper.like(LearningProject::getName, genericPageParam.getNameOrCode()); } // 根据创建时间区间检索 if (genericPageParam.getStartDate() != null && genericPageParam.getEndDate() != null) { queryWrapper.ge(LearningProject::getCreateTime, genericPageParam.getStartDate().atTime(0, 0, 0)) .le(LearningProject::getCreateTime, genericPageParam.getEndDate().atTime(23, 59, 59)); } // 设置排序规则 queryWrapper.orderByDesc(LearningProject::getCreateTime); // 设置查询内容 queryWrapper.select( LearningProject::getId, LearningProject::getName, LearningProject::getRemarks, LearningProject::getCreateTime, LearningProject::getUpdateTime); Page<LearningProject> page = this.learningProjectService.page(getPage(), queryWrapper); for (LearningProject learningProject : page.getRecords()) { LambdaQueryWrapper<LearningContent> lambdaQueryWrapper = Wrappers.<LearningContent>lambdaQuery() .eq(LearningContent::getLearningProjectId, learningProject.getId()) .eq(LearningContent::getPublished, true).orderByDesc(LearningContent::getSortorder); lambdaQueryWrapper.select(LearningContent::getName, LearningContent::getCover); List<LearningContent> learningContentList = this.learningContentService.list(lambdaQueryWrapper); if (!learningContentList.isEmpty()) { String learningContentNames = learningContentList.stream().map(LearningContent::getName).collect(Collectors.joining("、")); learningProject.setThumbnail(learningContentList.get(0).getCover()); learningProject.setLearningContentNames(learningContentNames); } } return getResult(page); } @ApiImplicitParams(value = { @ApiImplicitParam(name = "_index", value = "分页起始偏移量", paramType = "query", dataType = "Integer"), @ApiImplicitParam(name = "_size", value = "返回条数", paramType = "query", dataType = "Integer"), @ApiImplicitParam(name = "boardId", value = "展板内容ID", paramType = "path", dataType = "String", required = true) }) @GetMapping("/exhibitionBoard/getRefMaterial/{boardId}") @RequiresAuthentication //@RequiresPermissions("learning:project:page") @ApiOperation(value = "展板参考资料分页查询", notes = "展板参考资料分页查询") public Map<String, Object> getBoardRefMaterial(@PathVariable(value = "boardId") String boardId) { final ExhibitionBoard exhibitionBoard = this.exhibitionBoardService.getById(boardId); final LambdaQueryWrapper<Asset> assetQueryWrapper = Wrappers.<Asset>lambdaQuery().eq(Asset::getRefItemId, exhibitionBoard.getId()); assetQueryWrapper.eq(Asset::getPublished, true); assetQueryWrapper.eq(Asset::getFileCat, FileCatEnum.EXHIBITION_BOARD_DATUM.name()); final Page<Asset> datumList = this.assetService.page(this.getPage(), assetQueryWrapper); return getResult(datumList); } @ApiImplicitParams(value = { @ApiImplicitParam(name = "_index", value = "分页起始偏移量", paramType = "query", dataType = "Integer"), @ApiImplicitParam(name = "_size", value = "返回条数", paramType = "query", dataType = "Integer"), @ApiImplicitParam(name = "learningContentId", value = "学习内容ID", paramType = "query", dataType = "String"), @ApiImplicitParam(name = "nameOrCode", value = "名称或编码", paramType = "query", dataType = "String") }) @PostMapping("/exhibitionBoard/search") @RequiresAuthentication //@RequiresPermissions("learning:content:board:page") @ApiOperation(value = "模糊搜索查询", notes = "模糊搜索查询") public Map<String, Object> getLearningContentBoardPageList(GenericPageParam genericPageParam, @RequestParam(value = "learningContentId", required = false) String learningContentId) { IPage<ExhibitionBoard> page = this.learningContentBoardService.getBoardPageByLearningContentId(getPage(), learningContentId, genericPageParam.getNameOrCode()); return getResult(page); } @ApiImplicitParams(value = { @ApiImplicitParam(name = "_index", value = "分页起始偏移量", paramType = "query", dataType = "Integer"), @ApiImplicitParam(name = "_size", value = "返回条数", paramType = "query", dataType = "Integer") }) @PostMapping("/asset/search") @RequiresAuthentication //@RequiresPermissions("learning:content:board:page") @ApiOperation(value = "获取当前用户可查看的视频信息", notes = "获取当前用户可查看的视频信息") public Map<String, Object> getAssetPageByOrganId() { final TUser tUser = getcurUser(); if (tUser != null && tUser.getOrgCode() != null) { final String orgCode = tUser.getOrgCode(); IPage<Asset> page = this.learningContentBoardService.getAssetPageByOrganCode(getPage(), orgCode); return getResult(page); } return getFailResult("400", "用户未登录"); } @ApiOperation(value = "app最新版本查询") @ApiImplicitParams({ @ApiImplicitParam(name = "versionNo", value = "app版本号", dataType = "String", paramType = "query") }) @GetMapping(value = "/version/check") @RequiresAuthentication //@RequiresPermissions("app:version:check") public Map<String, Object> versionCheck(String versionNo) { TAppVersion current = new TAppVersion();//当前版本 // 查询最新版本号信息 QueryWrapper<TAppVersion> qw = new QueryWrapper<>(); qw.eq("is_current", 1); qw.select().orderByDesc("update_time"); List<TAppVersion> currentList = appVersionService.list(qw); if (currentList == null || currentList.size() == 0) { return getFailResult("未设置当前版本信息"); } else { current = currentList.get(0); } Map map = new HashMap(); if (StringUtils.isNotBlank(versionNo)) { final String prefix = StringUtils.substring(versionNo, 0, StringUtils.indexOf(versionNo, ".")); final String suffix = StringUtils.substring(versionNo, StringUtils.indexOf(versionNo, ".")).replaceAll("\\.", ""); String currAppVersion = current.getAppVersion(); final String prefix1 = StringUtils.substring(currAppVersion, 0, StringUtils.indexOf(currAppVersion, ".")); final String suffix1 = StringUtils.substring(currAppVersion, StringUtils.indexOf(currAppVersion, ".")).replaceAll("\\.", ""); if (Double.parseDouble(prefix + "." + suffix) >= Double.parseDouble(prefix1 + "." + suffix1)) { map.put("isLatest", true); } else { map.put("isLatest", false); } } else { map.put("isLatest", false); } map.put("versionNo", current.getAppVersion()); map.put("versionUrl", current.getApkUrl()); map.put("updateLog", current.getUpdateLog()); map.put("updateTime", current.getUpdateTime()); return getResult(map); } @ApiOperation(value = "app界面图片查询") @GetMapping(value = "/app/picSelect") //@RequiresAuthentication //@RequiresPermissions("app:pic:select") public Map<String, Object> appPicSelect() { TAppDirPic currentDir = null;// 当前目录页面 TAppRunPic currentRun = null;// 当前运行画面 // 查询当前目录界面信息 QueryWrapper<TAppDirPic> qw = new QueryWrapper<>(); qw.eq("is_current", 1); qw.select().orderByDesc("create_time"); List<TAppDirPic> currentDirList = appDirPicService.list(qw); if (currentDirList != null && currentDirList.size() > 0) { currentDir = currentDirList.get(0); } QueryWrapper<TAppRunPic> qw1 = new QueryWrapper<>(); qw1.eq("is_current", 1); qw1.select().orderByDesc("create_time"); List<TAppRunPic> currentRunList = appRunPicService.list(qw1); if (currentRunList != null && currentRunList.size() > 0) { currentRun = currentRunList.get(0); } Map map = new HashMap(); map.put("dirImgUrl", currentDir != null ? currentDir.getAppDirPic() : "未设置目录图片"); map.put("runImgUrl", currentRun != null ? currentRun.getAppRunPic() : "未设置运行图片"); return getResult(map); } }