From 233fb69fa9d1694e97337d74fa3da72cacda04c1 Mon Sep 17 00:00:00 2001 From: songhuangfeng123 <shf18767906695@163.com> Date: 星期四, 18 八月 2022 17:25:33 +0800 Subject: [PATCH] 目标统计 --- goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/RewardPunishmentDetailController.java | 78 ++++++++++++++++++++++++++++++++++---- 1 files changed, 69 insertions(+), 9 deletions(-) diff --git a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/RewardPunishmentDetailController.java b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/RewardPunishmentDetailController.java index 7c91f6a..1942653 100644 --- a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/RewardPunishmentDetailController.java +++ b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/RewardPunishmentDetailController.java @@ -5,8 +5,16 @@ import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.gkhy.safePlatform.commons.utils.BeanCopyUtils; import com.gkhy.safePlatform.targetDuty.entity.RewardPunishmentDetail; +import com.gkhy.safePlatform.targetDuty.model.dto.resp.ExamineMngDto; +import com.gkhy.safePlatform.targetDuty.model.dto.resp.ExamineTemplateDto; +import com.gkhy.safePlatform.targetDuty.model.dto.resp.RewardPunishmentDetailDto; +import com.gkhy.safePlatform.targetDuty.model.dto.resp.RewardPunishmentDetailExcel; import com.gkhy.safePlatform.targetDuty.service.RewardPunishmentDetailService; +import com.gkhy.safePlatform.targetDuty.utils.DateUtils; +import com.gkhy.safePlatform.targetDuty.utils.poihelper.ExcelUtil; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import com.gkhy.safePlatform.commons.query.PageQuery; import com.gkhy.safePlatform.commons.utils.PageUtils; @@ -14,11 +22,14 @@ import com.gkhy.safePlatform.commons.enums.ResultCodes; import com.gkhy.safePlatform.targetDuty.model.dto.req.RewardPunishmentDetailQueryCriteria; -import java.util.Arrays; +import java.io.IOException; +import java.net.URLEncoder; +import java.util.*; import java.util.stream.Collectors; import javax.annotation.Resource; +import javax.servlet.http.HttpServletRequest; +import javax.servlet.http.HttpServletResponse; import java.io.Serializable; -import java.util.List; /** * 奖惩记录(RewardPunishmentDetail)表控制层 @@ -35,6 +46,12 @@ @Resource private RewardPunishmentDetailService rewardPunishmentDetailService; + @Autowired + public HttpServletRequest request; + + @Autowired + public HttpServletResponse response; + /** * 分页查询所有数据 * @@ -43,7 +60,7 @@ */ @PostMapping(value = "/page/list") public ResultVO selectAll(@RequestBody PageQuery<RewardPunishmentDetailQueryCriteria> pageQuery){ - PageUtils.checkCheck(pageQuery.getPageIndex(), pageQuery.getPageSize()); + PageUtils.checkCheck(pageQuery); return this.rewardPunishmentDetailService.queryAll(pageQuery); } @@ -56,7 +73,8 @@ */ @GetMapping(value = "/selectOne/{id}") public ResultVO selectOne(@PathVariable Serializable id) { - return new ResultVO<>(ResultCodes.OK,this.rewardPunishmentDetailService.getById(id)); + RewardPunishmentDetailDto mngDto = this.rewardPunishmentDetailService.selectOne(id); + return new ResultVO<>(ResultCodes.OK,mngDto); } /** @@ -73,10 +91,21 @@ if(rewardPunishmentDetail.getRewardPunishmentStandardId() == null){ return new ResultVO<>(ResultCodes.CLIENT_PARAM_ILLEGAL,"缺少rewardPunishmentStandardId"); } + +// List<Long> pIdList = Arrays.stream(rewardPunishmentDetail.getPersonId().split(",")).map(s-> Long.parseLong(s.trim())) +// .collect(Collectors.toList()); +// +// List<RewardPunishmentDetail> list = new ArrayList<>(); +// pIdList.forEach(f->{ +// RewardPunishmentDetail new1 = BeanCopyUtils.copyBean(rewardPunishmentDetail, RewardPunishmentDetail.class); +// new1.setPersonId(f+""); +// list.add(new1); +// }); if (rewardPunishmentDetail.getId() == null) { + rewardPunishmentDetail.setCreateTime(new Date()); return new ResultVO<>(ResultCodes.OK,rewardPunishmentDetailService.save(rewardPunishmentDetail)); } else { - rewardPunishmentDetailService.update(rewardPunishmentDetail,new UpdateWrapper<RewardPunishmentDetail>().eq("id",rewardPunishmentDetail.getId())); + rewardPunishmentDetailService.updateById(rewardPunishmentDetail); return new ResultVO<>(ResultCodes.OK); } } @@ -87,11 +116,42 @@ * @param ids 主键结合 * @return 删除结果 */ - @GetMapping(value = "/delete") - public ResultVO delete(String ids) { - List<String> idList = Arrays.stream(ids.split(",")) - .collect(Collectors.toList()); + @RequestMapping(value = "/delete",method = RequestMethod.POST) + public ResultVO delete(@RequestBody Long[] ids) { + if(ids == null){ + return new ResultVO<>(ResultCodes.CLIENT_PARAM_ILLEGAL); + } + List<Long> idList = Arrays.asList(ids); this.rewardPunishmentDetailService.removeByIds(idList); return new ResultVO<>(ResultCodes.OK); } + + + + /** + * 导出一览数据 + * + */ + @GetMapping(value = "/exportData") + public void exportData(RewardPunishmentDetailQueryCriteria queryCriteria) throws IOException { + Map<String,String> map = new LinkedHashMap<>(); + map.put("1","奖惩日期"); + map.put("2","奖惩类型"); + map.put("3","被奖惩者"); + map.put("4","奖惩内容"); + map.put("5","奖惩依据"); + + String key = DateUtils.date2String(new Date(), DateUtils.PATTERN_ALLTIME_NOSIGN) ; + String fileName = URLEncoder.encode("奖惩记录"+key+".xls", "UTF-8"); + response.setContentType("application/vnd.ms-excel"); + response.setHeader("Content-Disposition", "attachment;filename=" + fileName + ".xlsx"); + response.setHeader("Access-Control-Expose-Headers", "Content-Disposition"); + + + List<RewardPunishmentDetailExcel> respList = BeanCopyUtils.copyBeanList(rewardPunishmentDetailService.queryAllRelation(queryCriteria), RewardPunishmentDetailExcel.class); + + ExcelUtil.exportExcel(map,respList , response.getOutputStream(),DateUtils.PATTERN_STANDARD); + response.getOutputStream().close(); + } + } \ No newline at end of file -- Gitblit v1.9.2