package com.goafanti.admin.controller; import java.io.IOException; import java.lang.reflect.Field; import java.util.ArrayList; import java.util.Arrays; import java.util.List; import java.util.UUID; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.validation.Valid; import org.springframework.beans.BeanUtils; import org.springframework.validation.BindingResult; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController; import org.springframework.web.multipart.MultipartFile; import com.alibaba.fastjson.JSON; import com.goafanti.achievement.bo.AchievementImportBo; import com.goafanti.achievement.bo.InputAchievement; import com.goafanti.achievement.service.AchievementOrderService; import com.goafanti.achievement.service.AchievementService; import com.goafanti.admin.service.AftFileService; import com.goafanti.common.bo.Result; import com.goafanti.common.constant.AFTConstants; import com.goafanti.common.constant.ErrorConstants; import com.goafanti.common.controller.CertifyApiController; import com.goafanti.common.enums.AchievementAuditStatus; import com.goafanti.common.enums.AchievementFields; import com.goafanti.common.enums.AchievementImportFields; import com.goafanti.common.enums.AchievementOrderStatus; import com.goafanti.common.enums.AchievementReleaseStatus; import com.goafanti.common.enums.AttachmentType; import com.goafanti.common.enums.DeleteStatus; import com.goafanti.common.model.Achievement; import com.goafanti.common.model.AchievementOrder; import com.goafanti.common.model.AftFile; import com.goafanti.common.utils.LoggerUtils; import com.goafanti.common.utils.StringUtils; import com.goafanti.core.shiro.token.TokenManager; import com.goafanti.user.service.UserService; @RestController @RequestMapping(value = "/api/admin/achievement") public class AdminAchievementApiController extends CertifyApiController { @Resource private AchievementService achievementService; @Resource private UserService userService; @Resource private AftFileService aftFileService; @Resource private AchievementOrderService achievementOrderService; /** * 个人成果列表 */ @RequestMapping(value = "/userList", method = RequestMethod.GET) private Result userList(String ownerId, Integer auditStatus, Integer serialNumber, String name, String keyword, Integer category, Integer status, String releaseDateStartDate, String releaseDateEndDate, Integer releaseStatus, String pageNo, String pageSize) { Result res = new Result(); Integer pNo = 1; Integer pSize = 10; if (StringUtils.isNumeric(pageSize)) { pSize = Integer.parseInt(pageSize); } if (StringUtils.isNumeric(pageNo)) { pNo = Integer.parseInt(pageNo); } res.setData(achievementService.listUserOwnerAchievement(ownerId, auditStatus, serialNumber, name, keyword, category, status, releaseDateStartDate, releaseDateEndDate, releaseStatus, pNo, pSize)); return res; } /** * 组织用户成果列表 */ @RequestMapping(value = "/orgList", method = RequestMethod.GET) private Result orgList(String ownerId, Integer auditStatus, Integer serialNumber, String name, String keyword, Integer category, Integer status, String releaseDateStartDate, String releaseDateEndDate, Integer releaseStatus, String pageNo, String pageSize) { Result res = new Result(); Integer pNo = 1; Integer pSize = 10; if (StringUtils.isNumeric(pageSize)) { pSize = Integer.parseInt(pageSize); } if (StringUtils.isNumeric(pageNo)) { pNo = Integer.parseInt(pageNo); } res.setData(achievementService.listOrgOwnerAchievement(ownerId, auditStatus, serialNumber, name, keyword, category, status, releaseDateStartDate, releaseDateEndDate, releaseStatus, pNo, pSize)); return res; } /** * 个人成果所有人列表 */ @RequestMapping(value = "/userOwner", method = RequestMethod.GET) public Result getAchievementUserOwner(String name) { Result res = new Result(); if (StringUtils.isBlank(name)) { return res; } res.setData(userService.selectAchievementUserOwner(name)); return res; } /** * 组织成果所有人列表 */ @RequestMapping(value = "/orgOwner", method = RequestMethod.GET) public Result getAchievementOrgOwner(String name) { Result res = new Result(); if (StringUtils.isBlank(name)) { return res; } res.setData(userService.selectAchievementOrgOwner(name)); return res; } /** * 个人成果详情详情 */ @RequestMapping(value = "/userDetail", method = RequestMethod.GET) private Result userDetail(String id) { Result res = new Result(); if (StringUtils.isBlank(id)) { res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "找不到成果ID", "成果ID")); return res; } res.setData(achievementService.selectUserOwnerDetail(id)); return res; } /** * 组织用户成果详情详情 */ @RequestMapping(value = "/orgDetail", method = RequestMethod.GET) private Result orgDetail(String id) { Result res = new Result(); if (StringUtils.isBlank(id)) { res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "找不到成果ID", "成果ID")); return res; } res.setData(achievementService.selectOrgOwnerDetail(id)); return res; } /** * 新增成果 */ @RequestMapping(value = "/apply", method = RequestMethod.POST) private Result apply(@Valid InputAchievement ia, BindingResult bindingResult, @RequestParam(name = "keywords[]", required = false) String[] keywords) { Result res = new Result(); if (bindingResult.hasErrors()) { res.getError().add(buildErrorByMsg(bindingResult.getFieldError().getDefaultMessage(), AchievementFields.getFieldDesc(bindingResult.getFieldError().getField()))); return res; } res = disposeInputAchievement(res, ia, keywords); if (!res.getError().isEmpty()) { return res; } Achievement a = new Achievement(); BeanUtils.copyProperties(ia, a); achievementService.saveAchievement(a, keywords); return res; } /** * 修改成果 */ @RequestMapping(value = "/update", method = RequestMethod.POST) public Result update(@Valid InputAchievement ia, BindingResult bindingResult, @RequestParam(name = "keywords[]", required = false) String[] keywords) { Result res = new Result(); if (bindingResult.hasErrors()) { res.getError().add(buildErrorByMsg(bindingResult.getFieldError().getDefaultMessage(), AchievementFields.getFieldDesc(bindingResult.getFieldError().getField()))); return res; } if (StringUtils.isBlank(ia.getId())) { res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "找不到成果ID", "成果ID")); return res; } if (!AchievementAuditStatus.CREATE.getCode().equals(ia.getAuditStatus()) && !AchievementAuditStatus.SUBMIT.getCode().equals(ia.getAuditStatus()) && !AchievementAuditStatus.UNAUDITED.getCode().equals(ia.getAuditStatus())) { res.getError().add(buildError(ErrorConstants.PARAM_ERROR, "", "当前状态无法提交审核!")); return res; } res = disposeInputAchievement(res, ia, keywords); if (!res.getError().isEmpty()) { return res; } Achievement a = new Achievement(); BeanUtils.copyProperties(ia, a); achievementService.updateAchievement(a, keywords); return res; } /** * 科技成果匹配科技需求 */ @RequestMapping(value = "/matchDemand", method = RequestMethod.POST) public Result matchDemand(String id) { Result res = new Result(); if (StringUtils.isBlank(id)) { res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "找不到成果ID", "成果ID")); return res; } Achievement a = achievementService.selectByPrimaryKey(id); if (null == a || !AchievementAuditStatus.AUDITED.getCode().equals(a.getAuditStatus()) || !DeleteStatus.UNDELETE.getCode().equals(a.getDeletedSign()) || !AchievementReleaseStatus.RELEASED.getCode().equals(a.getReleaseStatus())) { res.getError().add(buildError("", "当前状态无法匹配!")); return res; } res.setData(achievementService.updateMatchDemand(a)); return res; } /** * 批量导入科技成果 */ @SuppressWarnings("unchecked") @RequestMapping(value = "/importAchievement", method = RequestMethod.POST) public Result importAchievement(@RequestParam(name = "data", required = false) String d) { Result res = new Result(); List data = JSON.parseArray(d, AchievementImportBo.class); if (data == null || data.isEmpty()) { res.getError().add(buildError(ErrorConstants.PARAM_ERROR, "", "导入数据")); return res; } if (data.size() > AFTConstants.IMPORTMAXLENTH) { res.getError().add(buildError(ErrorConstants.PARAM_ERROR, "", "导入数据量")); return res; } res = disposeImportAchievement(res, data); if (!res.getError().isEmpty()) { return res; } data = (List) res.getData(); achievementService.insertImport(data); return res; } /** * 成果需求匹配列表 */ @RequestMapping(value = "/achievementDemand", method = RequestMethod.GET) public Result achievementDemand(String id) { Result res = new Result(); res.setData(achievementService.selectAchievementDemandListByAchievementId(id)); return res; } /** * 上传技术成果批量导入Excel模板 * * @param req * @return */ @RequestMapping(value = "/uploadTemplate", method = RequestMethod.POST) public Result uploadPatentTemplate(HttpServletRequest req, String sign) { Result res = new Result(); String fileName = ""; List files = getFiles(req); MultipartFile mf = files.get(0); String suffix = mf.getOriginalFilename().substring(mf.getOriginalFilename().lastIndexOf(".")); if (suffix.equals(".xls") || suffix.equals(".xlsx")) { AttachmentType attachmentType = AttachmentType.getField(sign); if (attachmentType == AttachmentType.ACHIEVEMENT_TEMPLATE) { fileName = sign + suffix; } else { res.getError().add(buildError(ErrorConstants.PARAM_ERROR, "", "附件标示")); return res; } String name = handleFile(res, req, fileName, files, mf); res.setData(name); if (!StringUtils.isBlank(name) && null == aftFileService.selectAftFileBySign(sign)) { AftFile f = new AftFile(); f.setId(UUID.randomUUID().toString()); f.setFileName(AttachmentType.ACHIEVEMENT_TEMPLATE.getDesc()); f.setUid(TokenManager.getAdminId()); f.setComment(AttachmentType.ACHIEVEMENT_TEMPLATE.getDesc()); f.setSign(sign); f.setFilePath("/admin/" + fileName); f.setDeleletedSign(DeleteStatus.UNDELETE.getCode()); aftFileService.insert(f); } } else { res.getError().add(buildError(ErrorConstants.FILE_PATTERN_ERROR, "文件格式错误,请重新上传!")); } return res; } /** * 下载技术成果批量导入Excel模板 * * @param response * @return */ @RequestMapping(value = "/downloadTemplate", method = RequestMethod.GET) public Result downloadTemplateFile(HttpServletResponse response, String sign) { Result res = new Result(); AttachmentType attachmentType = AttachmentType.getField(sign); if (attachmentType == AttachmentType.ACHIEVEMENT_TEMPLATE) { String fileName = ""; AftFile af = aftFileService.selectAftFileBySign(sign); if (null == af) { res.getError().add(buildError(ErrorConstants.FILE_NON_EXISTENT, "", "找不到文件!")); } else { String path = af.getFilePath(); String suffix = path.substring(path.lastIndexOf(".")); fileName = AttachmentType.ACHIEVEMENT_TEMPLATE.getDesc() + suffix; downloadFile(response, fileName, path); } } else { res.getError().add(buildError(ErrorConstants.PARAM_ERROR, "", "附件标示")); } return res; } /** * 成果撤消发布(下架) */ @RequestMapping(value = "/offShelf", method = RequestMethod.POST) public Result offShelf(String id) { Result res = new Result(); if (StringUtils.isBlank(id)) { res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "找不到成果ID", "成果ID")); return res; } Achievement a = achievementService.selectByPrimaryKey(id); if (null == a) { res.getError().add(buildError(ErrorConstants.PARAM_ERROR, "", "需求ID")); return res; } res.setData(achievementService.updateReleaseStatus(a)); return res; } /** * 下载文本文件 */ @RequestMapping(value = "/download", method = RequestMethod.GET) public Result download(HttpServletResponse response, String id, String sign) { Result res = new Result(); if (StringUtils.isEmpty(id)) { res.getError().add(buildError(ErrorConstants.PARAM_ERROR, "", "科技成果ID")); return res; } Achievement a = achievementService.selectByPrimaryKey(id); if (null == a) { res.getError().add(buildError(ErrorConstants.PARAM_ERROR, "", "科技成果ID")); return res; } AttachmentType attachmentType = AttachmentType.getField(sign); if (attachmentType == AttachmentType.ACHIEVEMENT_MATURITY_TEXT_FILE) { downloadUnPrivateFile(response, a.getMaturityTextFileDownloadFileName(), a.getMaturityTextFileUrl()); } else if (attachmentType == AttachmentType.ACHIEVEMENT_TECH_PLAN) { downloadUnPrivateFile(response, a.getTechPlanDownloadFileName(), a.getTechPlanUrl()); } else if (attachmentType == AttachmentType.ACHIEVEMENT_BUSINESS_PLAN) { downloadUnPrivateFile(response, a.getBusinessPlanDownloadFileName(), a.getBusinessPlanUrl()); } else { res.getError().add(buildError(ErrorConstants.PARAM_ERROR, "", "附件标示")); } return res; } /** * 文本文件上传 */ @RequestMapping(value = "/uploadTextFile", method = RequestMethod.POST) public Result uploadTextFile(HttpServletRequest req, String sign) { Result res = new Result(); AttachmentType attachmentType = AttachmentType.getField(sign); if (attachmentType == AttachmentType.ACHIEVEMENT_MATURITY_TEXT_FILE || attachmentType == AttachmentType.ACHIEVEMENT_TECH_PLAN || attachmentType == AttachmentType.ACHIEVEMENT_BUSINESS_PLAN) { res.setData(handleFiles(res, "/achievement/", false, req, sign, "achievement")); } else { res.getError().add(buildError(ErrorConstants.PARAM_ERROR, "", "附件标示")); } return res; } /** * 图片上传 */ @RequestMapping(value = "/uploadPicture", method = RequestMethod.POST) public Result uploadPicture(HttpServletRequest req, String sign) { Result res = new Result(); AttachmentType attachmentType = AttachmentType.getField(sign); if (attachmentType == AttachmentType.ACHIEVEMENT_TECHNICAL_PICTURE || attachmentType == AttachmentType.ACHIEVEMENT_MATURITY_PICTURE) { res.setData(handleFiles(res, "/achievement/", false, req, sign, "achievement")); } else { res.getError().add(buildError(ErrorConstants.PARAM_ERROR, "", "附件标示")); } return res; } /** * 删除 */ @RequestMapping(value = "/delete", method = RequestMethod.POST) private Result delete(@RequestParam(name = "ids[]", required = false) String[] ids) { Result res = new Result(); if (ids == null || ids.length != 1) { res.getError().add(buildError(ErrorConstants.PARAM_ERROR, "", "")); } else { List list = achievementOrderService.selectAchievementOrderByAchievementId(ids[0]); for (AchievementOrder order : list) { if (!AchievementOrderStatus.CREATE.getCode().equals(order.getStatus())) { res.getError().add(buildError("", "当前科技成果有订单,无法删除!")); return res; } } res.setData(achievementService.deleteByPrimaryKey(Arrays.asList(ids))); } return res; } private Result disposeInputAchievement(Result res, InputAchievement ia, String[] keywords) { if (StringUtils.isBlank(ia.getName())) { res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "找不到成果名称", "成果名称")); return res; } if (null == ia.getCategory()) { res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "找不到数据类别", "数据类别")); return res; } if (StringUtils.isBlank(ia.getKeyword())) { res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "找不到关键词", "关键词")); return res; } if (null == keywords || keywords.length < 1) { res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "找不到关键词", "关键词")); return res; } if (null == ia.getOwnerType()) { res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "找不到所有人类型", "所有人类型")); return res; } if (null == ia.getCooperationMode()) { res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "找不到合作方式", "合作方式")); return res; } for (int i = 0; i < keywords.length; i++) { if (AFTConstants.KEYWORDLENTH < keywords[i].length()) { res.getError().add(buildError(ErrorConstants.PARAM_ERROR, "", "关键词长度")); return res; } } return res; } private String handleFile(Result res, HttpServletRequest req, String fileName, List files, MultipartFile mf) { if (!files.isEmpty()) { try { mf.transferTo(toAdminPrivateFile(fileName)); LoggerUtils.debug(getClass(), fileName + " 文件上传成功"); } catch (IllegalStateException | IOException e) { LoggerUtils.error(getClass(), "文件上传失败", e); res.getError().add(buildError("", "文件上传失败!")); return ""; } } else { res.getError().add(buildError("", "文件上传失败!")); return ""; } return fileName; } private Result disposeImportAchievement(Result res, List data) { Field[] field = AchievementImportBo.class.getDeclaredFields(); for (AchievementImportBo bo : data) { for (Field f : field) { f.setAccessible(true); try { if (!f.getName().equals("keywords") && (f.get(bo) == null || "".equals(f.get(bo)))) { res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "", AchievementImportFields.getFieldDesc(f.getName()))); return res; } } catch (IllegalArgumentException | IllegalAccessException e) { } } if (bo.getDataCategory().toString().length() > 1) { res.getError().add(buildError(ErrorConstants.PARAM_SIZE_ERROR, "", AchievementImportFields.DATACATEGORY.getDesc())); return res; } if (bo.getName().length() > 31) { res.getError() .add(buildError(ErrorConstants.PARAM_SIZE_ERROR, "", AchievementImportFields.NAME.getDesc())); return res; } if (bo.getCategory().toString().length() > 1) { res.getError().add( buildError(ErrorConstants.PARAM_SIZE_ERROR, "", AchievementImportFields.CATEGORY.getDesc())); return res; } if (bo.getOwnerName().length() > 31) { res.getError().add( buildError(ErrorConstants.PARAM_SIZE_ERROR, "", AchievementImportFields.OWNERNAME.getDesc())); return res; } if (bo.getOwnerType().toString().length() > 1) { res.getError().add( buildError(ErrorConstants.PARAM_SIZE_ERROR, "", AchievementImportFields.OWNERTYPE.getDesc())); return res; } if (bo.getOwnerIdNumber().length() > 35) { res.getError().add(buildError(ErrorConstants.PARAM_SIZE_ERROR, "", AchievementImportFields.OWNERIDNUMBER.getDesc())); return res; } if (bo.getOwnerMobile().length() > 11) { res.getError().add( buildError(ErrorConstants.PARAM_SIZE_ERROR, "", AchievementImportFields.OWNERMOBILE.getDesc())); return res; } if (bo.getOwnerEmail().length() > 254) { res.getError().add( buildError(ErrorConstants.PARAM_SIZE_ERROR, "", AchievementImportFields.OWNERMOBILE.getDesc())); return res; } if (bo.getOwnerPostalAddress().length() > 254) { res.getError().add(buildError(ErrorConstants.PARAM_SIZE_ERROR, "", AchievementImportFields.OWNERPOSTALADDRESS.getDesc())); return res; } if (bo.getCooperationMode().toString().length() > 1) { res.getError().add(buildError(ErrorConstants.PARAM_SIZE_ERROR, "", AchievementImportFields.COOPERATIONMODE.getDesc())); return res; } if (bo.getIntroduction().length() > 298){ res.getError().add( buildError(ErrorConstants.PARAM_SIZE_ERROR, "", AchievementImportFields.INTRODUCTION.getDesc())); return res; } if (bo.getKeyword().length() > 44) { res.getError().add( buildError(ErrorConstants.PARAM_SIZE_ERROR, "", AchievementImportFields.KEYWORD.getDesc())); return res; } String[] keywords = bo.getKeyword().trim().split(",|,"); if (null == keywords || keywords.length < 1) { res.getError() .add(buildError(ErrorConstants.PARAM_ERROR, "", AchievementImportFields.KEYWORD.getDesc())); return res; } List list = new ArrayList<>(); for (String s : keywords) { if (!StringUtils.isBlank(s)) { list.add(s); } } bo.setKeywords(list); } res.setData(data); return res; } }