springcloud_k8s_panzhihuazhihuishequ/applets_backstage/src/main/java/com/panzhihua/applets_backstage/api/CommunityConvenientApi.java
@@ -213,7 +213,7 @@ } catch (IOException e) { e.printStackTrace(); log.error("导入模板失败【{}】", e.getMessage()); return R.fail(); return R.fail(e.getMessage()); } return R.ok(); } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/vaccines/VaccinesEnrollByAdminDTO.java
@@ -33,4 +33,7 @@ @ApiModelProperty(value = "社区id",hidden = true) private Long communityId; @ApiModelProperty("疫苗名称") private String vaccines; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/vaccines/VaccinesInoculationByAdminDTO.java
New file @@ -0,0 +1,37 @@ package com.panzhihua.common.model.dtos.vaccines; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; @Data @ApiModel("疫苗接种记录请求参数") public class VaccinesInoculationByAdminDTO { @ApiModelProperty(value = "分页-当前页数",example = "1") private Long pageNum = 1L; @ApiModelProperty(value = "分页-每页记录数",example = "10") private Long pageSize = 10L; @ApiModelProperty("姓名") private String name; @ApiModelProperty("身份证号") private String idCard; @ApiModelProperty("手机号") private String phone; @ApiModelProperty("接种时间开始") private String startTime; @ApiModelProperty("接种时间结束") private String endTime; @ApiModelProperty(value = "社区id",hidden = true) private Long communityId; @ApiModelProperty("接种剂次") private String dosage; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/EldersAuthDetailsVO.java
@@ -1,6 +1,9 @@ package com.panzhihua.common.model.vos.community; import java.util.*; import com.panzhihua.common.model.helper.sensitive.Sensitive; import com.panzhihua.common.model.helper.sensitive.SensitiveStrategy; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; @@ -24,7 +27,7 @@ private Long createBy; @ApiModelProperty(value = "创建时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") @JsonFormat(pattern = "yyyy-MM-dd HH:mm", timezone = "GMT+8") private Date createAt; @ApiModelProperty(value = "更新人") @@ -35,6 +38,7 @@ private Date updateAt; @ApiModelProperty(value = "身份证") @Sensitive(strategy = SensitiveStrategy.ID_CARD) private String idCard; @ApiModelProperty(value = "认证人姓名") springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/vaccines/ComMngVaccinesEnrollExcelVo.java
New file @@ -0,0 +1,34 @@ package com.panzhihua.common.model.vos.vaccines; import com.alibaba.excel.annotation.ExcelProperty; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.Data; import java.util.Date; @Data public class ComMngVaccinesEnrollExcelVo { @ExcelProperty(value = "姓名" ,index = 0) private String name; @ExcelProperty(value = "性别" ,index = 1) private String sex; @ExcelProperty(value = "年龄" ,index = 2) private Integer age; @ExcelProperty(value = "手机号" ,index = 3) private String phone; @ExcelProperty(value = "身份证号" ,index = 4) private String idCard; @ExcelProperty(value = "登记时间" ,index = 5) @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8") private Date createAt; @ExcelProperty(value = "疫苗分类" ,index = 6) private String vaccines; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/vaccines/ComMngVaccinesInoculationExcelVo.java
New file @@ -0,0 +1,46 @@ package com.panzhihua.common.model.vos.vaccines; import com.alibaba.excel.annotation.ExcelProperty; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.Data; import java.util.Date; @Data public class ComMngVaccinesInoculationExcelVo { @ExcelProperty(value = "姓名" ,index = 0) private String name; @ExcelProperty(value = "性别" ,index = 1) private String sex; @ExcelProperty(value = "年龄" ,index = 2) private Integer age; @ExcelProperty(value = "手机号" ,index = 3) private String phone; @ExcelProperty(value = "身份证号" ,index = 4) private String idCard; @ExcelProperty(value = "接种时间" ,index = 5) @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8") private Date inoculationAt; @ExcelProperty(value = "接种剂次" ,index = 6) private String dosage; @ExcelProperty(value = "医疗机构" ,index = 7) private String medicalInstitution; @ExcelProperty(value = "疫苗批号" ,index = 8) private String vaccinesCode; @ExcelProperty(value = "疫苗名称" ,index = 9) private String vaccines; @ExcelProperty(value = "备注" ,index = 10) private String remark; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/vaccines/VaccinesEnrollByAdminVO.java
@@ -38,4 +38,10 @@ @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8") private Date createAt; @ApiModelProperty("性别(1.男 2.女 3.未知)") private Integer sex; @ApiModelProperty("疫苗分类") private String vaccines; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/vaccines/VaccinesEnrollUserByAppVO.java
@@ -5,6 +5,8 @@ import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.Date; /** * @auther lyq * @describe 疫苗分类信息 @@ -40,6 +42,9 @@ @ApiModelProperty("是否是自己(1.是 2.否)") private Integer isUser; @ApiModelProperty("创建时间") private Date createAt; /** * 是否已报名(1.是 2.否) */ springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/vaccines/VaccinesInoculationByAdminVO.java
New file @@ -0,0 +1,56 @@ package com.panzhihua.common.model.vos.vaccines; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.Date; /** * @auther lyq * @describe 疫苗接种记录 */ @Data @ApiModel("疫苗接种记录") public class VaccinesInoculationByAdminVO { @ApiModelProperty("疫苗接种记录id") private Long id; @ApiModelProperty("姓名") private String name; @ApiModelProperty("性别(1.男 2.女)") private Integer sex; @ApiModelProperty("年龄") private Integer age; @ApiModelProperty("手机号") private String phone; @ApiModelProperty("身份证号码") private String idCard; @ApiModelProperty("接种时间") @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8") private Date inoculationAt; @ApiModelProperty("接种剂次") private String dosage; @ApiModelProperty("医疗机构") private String medicalInstitution; @ApiModelProperty("疫苗批号") private String vaccinesCode; @ApiModelProperty("疫苗名称") private String vaccines; @ApiModelProperty("备注") private String remark; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java
@@ -16,11 +16,8 @@ import com.panzhihua.common.model.dtos.shop.PageComShopGoodsDTO; import com.panzhihua.common.model.dtos.shop.PageComShopStoreDTO; import com.panzhihua.common.model.dtos.user.PageInputUserDTO; import com.panzhihua.common.model.dtos.vaccines.*; import com.panzhihua.common.model.vos.IPageVO; import com.panzhihua.common.model.dtos.vaccines.VaccinesByAdminDTO; import com.panzhihua.common.model.dtos.vaccines.VaccinesEnrollByAdminDTO; import com.panzhihua.common.model.dtos.vaccines.VaccinesEnrollByAppDTO; import com.panzhihua.common.model.dtos.vaccines.VaccinesEnrollUserByAppDTO; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.SystemmanagementConfigVO; import com.panzhihua.common.model.vos.community.*; @@ -196,6 +193,16 @@ */ @PostMapping("detaileasyphoto") R detailEasyPhoto(@RequestParam("id") Long id, @RequestParam("userId") Long userId); /** * 随手拍删除 * * @param id 随手拍主键 * @param userId 登录用户id * @return 详情内容 */ @PostMapping("deleteEasyPhoto") R deleteEasyPhoto(@RequestParam("id") Long id, @RequestParam("userId") Long userId); /** * 分页查询微心愿 @@ -2610,4 +2617,35 @@ */ @PostMapping("/vaccines/admin/enroll/delete") R deleteVaccinesByAdmin(@RequestParam("id") Long id); /** * 根据条件导出登记列表 * @param vaccinesByAdminDTO 请求参数 * @return 登记列表 */ @PostMapping("/vaccines/admin/enroll/export") R exportVaccinesEnrollListByAdmin(@RequestBody VaccinesEnrollByAdminDTO vaccinesByAdminDTO); /** * 查询接种记录列表 * @param inoculationByAdminDTO 请求参数 * @return 接种记录列表 */ @PostMapping("/vaccines/admin/inoculation/list") R getVaccinesInoculationListByAdmin(@RequestBody VaccinesInoculationByAdminDTO inoculationByAdminDTO); /** * 接种记录信息导出 * @param inoculationByAdminDTO 请求参数 * @return 导出结果 */ @PostMapping("/vaccines/admin/inoculation/export") R exportVaccinesInoculationListByAdmin(@RequestBody VaccinesInoculationByAdminDTO inoculationByAdminDTO); /** * 查询疫苗分类列表 * @return 疫苗分类列表 */ @PostMapping("/vaccines/admin/enroll/type/list") R getEnrollTypeListByAdmin(); } springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommunityActivityApi.java
@@ -248,6 +248,13 @@ return communityService.detailEasyPhoto(id, userId); } @ApiOperation(value = "删除随手拍", response = ComActEasyPhotoVO.class) @DeleteMapping("easyphoto/{id}") public R deleteEasyPhoto(@PathVariable("id") Long id) { Long userId = this.getUserId(); return communityService.deleteEasyPhoto(id, userId); } @ApiOperation(value = "分页查询微心愿") @PostMapping("pagemicrowish") public R pageMicroWish(@RequestBody ComActMicroWishVO comActMicroWishVO) { springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommunityConvenientApi.java
@@ -191,7 +191,7 @@ } catch (IOException e) { e.printStackTrace(); log.error("导入模板失败【{}】", e.getMessage()); return R.fail(); return R.fail(e.getMessage()); } return R.ok(); } springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/EldersAuthApi.java
@@ -87,7 +87,7 @@ */ @PostMapping("page") @ApiOperation(value = "查询高龄认证", response = EldersAuthVO.class) R query(@Validated @ModelAttribute PageEldersAuthDTO pageEldersAuthDTO){ R query(@Validated @RequestBody PageEldersAuthDTO pageEldersAuthDTO){ ClazzUtils.setIfStringIsEmpty(pageEldersAuthDTO); return communityService.query(pageEldersAuthDTO); } springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/VaccinesApi.java
@@ -1,20 +1,40 @@ package com.panzhihua.community_backstage.api; import com.alibaba.excel.EasyExcel; import com.alibaba.excel.ExcelWriter; import com.alibaba.excel.write.metadata.WriteSheet; import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy; import com.alibaba.fastjson.JSON; import com.panzhihua.common.controller.BaseController; import com.panzhihua.common.enums.PopulIsOkEnum; import com.panzhihua.common.enums.PopulPoliticalOutlookEnum; import com.panzhihua.common.enums.PopulSexEnum; import com.panzhihua.common.model.dtos.vaccines.VaccinesEnrollByAdminDTO; import com.panzhihua.common.model.dtos.vaccines.VaccinesInoculationByAdminDTO; import com.panzhihua.common.model.vos.LoginUserInfoVO; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.vaccines.VaccinesEnrollByAdminVO; import com.panzhihua.common.model.vos.community.ComMngPopulationExcelVo; import com.panzhihua.common.model.vos.community.ComMngPopulationVO; import com.panzhihua.common.model.vos.vaccines.*; import com.panzhihua.common.service.community.CommunityService; import com.panzhihua.common.utlis.SFTPUtil; import com.panzhihua.community_backstage.excel.CustomSheetWriteHandler; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Value; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import javax.annotation.Resource; import java.io.File; import java.io.FileInputStream; import java.io.InputStream; import java.util.ArrayList; import java.util.List; @Slf4j @RestController @@ -24,6 +44,20 @@ @Resource private CommunityService communityService; @Value("${excel.userurl}") private String excelUrl; // FTP 登录用户名 @Value("${ftp.username}") private String userName; // FTP 登录密码 @Value("${ftp.password}") private String password; // FTP 服务器地址IP地址 @Value("${ftp.host}") private String host; // FTP 端口 @Value("${ftp.port}") private int port; @ApiOperation(value = "疫苗登记列表" , response = VaccinesEnrollByAdminVO.class) @PostMapping("/enroll/list") @@ -35,14 +69,137 @@ return communityService.getVaccinesEnrollListByAdmin(vaccinesByAdminDTO); } @ApiOperation(value = "疫苗登记列表导出" , response = VaccinesEnrollByAdminVO.class) @ApiOperation(value = "疫苗登记列表导出") @PostMapping("/enroll/export") public R exportVaccinesEnrollListByAdmin(@RequestBody VaccinesEnrollByAdminDTO vaccinesByAdminDTO) { //获取登陆用户 LoginUserInfoVO loginUserInfo = this.getLoginUserInfo(); //获取登陆用户绑定社区id vaccinesByAdminDTO.setCommunityId(loginUserInfo.getCommunityId()); //生成动态模板excel通过ftp工具上传到主节点,然后返回模板下载地址 String ftpUrl = "/mnt/data/web/excel/"; String name = "疫苗登记记录.xlsx"; try { SFTPUtil sftp = new SFTPUtil(userName, password, host, port); sftp.login(); boolean existDir = sftp.isExistDir(ftpUrl + name); if (!existDir) { String property = System.getProperty("user.dir"); String fileName = property + File.separator + name; // 这里 需要指定写用哪个class去写 ExcelWriter excelWriter = null; InputStream inputStream = null; try { R isok = communityService.exportVaccinesEnrollListByAdmin(vaccinesByAdminDTO); List<ComMngVaccinesEnrollExcelVo> populList = JSON.parseArray(JSON.toJSONString(isok.getData()),ComMngVaccinesEnrollExcelVo.class); if(populList != null && populList.size() > 0){ for (ComMngVaccinesEnrollExcelVo popul:populList){ //设置性别 popul.setSex(PopulSexEnum.getCnDescByName(Integer.parseInt(popul.getSex()))); } } excelWriter = EasyExcel.write(fileName, ComMngVaccinesEnrollExcelVo.class).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()).registerWriteHandler(new CustomSheetWriteHandler()).build(); WriteSheet writeSheet = EasyExcel.writerSheet("疫苗登记导出数据").build(); excelWriter.write(populList, writeSheet); excelWriter.finish(); File file = new File(fileName); inputStream = new FileInputStream(file); sftp.uploadMore(ftpUrl, name, inputStream); sftp.logout(); inputStream.close(); String absolutePath = file.getAbsolutePath(); boolean delete = file.delete(); log.info("删除excel【{}】结果【{}】", absolutePath, delete); } finally { // 千万别忘记finish 会帮忙关闭流 if (inputStream != null) { inputStream.close(); } if (excelWriter != null) { excelWriter.finish(); } } } return R.ok(excelUrl + name); } catch (Exception e) { e.printStackTrace(); log.error("文件传输失败【{}】", e.getMessage()); return R.fail(); } } @ApiOperation(value = "接种信息列表" , response = VaccinesInoculationByAdminVO.class) @PostMapping("/inoculation/list") public R getVaccinesInoculationListByAdmin(@RequestBody VaccinesInoculationByAdminDTO inoculationByAdminDTO) { LoginUserInfoVO loginUserInfo = this.getLoginUserInfo(); if(loginUserInfo != null){ vaccinesByAdminDTO.setCommunityId(loginUserInfo.getCommunityId()); inoculationByAdminDTO.setCommunityId(loginUserInfo.getCommunityId()); } return communityService.getVaccinesEnrollListByAdmin(vaccinesByAdminDTO); return communityService.getVaccinesInoculationListByAdmin(inoculationByAdminDTO); } @ApiOperation(value = "接种信息列表导出") @PostMapping("/inoculation/export") public R exportVaccinesInoculationListByAdmin(@RequestBody VaccinesInoculationByAdminDTO inoculationByAdminDTO) { //获取登陆用户 LoginUserInfoVO loginUserInfo = this.getLoginUserInfo(); //获取登陆用户绑定社区id inoculationByAdminDTO.setCommunityId(loginUserInfo.getCommunityId()); //生成动态模板excel通过ftp工具上传到主节点,然后返回模板下载地址 String ftpUrl = "/mnt/data/web/excel/"; String name = "接种信息记录.xlsx"; try { SFTPUtil sftp = new SFTPUtil(userName, password, host, port); sftp.login(); boolean existDir = sftp.isExistDir(ftpUrl + name); if (!existDir) { String property = System.getProperty("user.dir"); String fileName = property + File.separator + name; // 这里 需要指定写用哪个class去写 ExcelWriter excelWriter = null; InputStream inputStream = null; try { List<ComMngVaccinesInoculationExcelVo> populList = JSON.parseArray(JSON.toJSONString(communityService.exportVaccinesInoculationListByAdmin(inoculationByAdminDTO).getData()),ComMngVaccinesInoculationExcelVo.class); if(populList != null && populList.size() > 0){ for (ComMngVaccinesInoculationExcelVo popul:populList){ //设置性别 popul.setSex(PopulSexEnum.getCnDescByName(Integer.parseInt(popul.getSex()))); } } excelWriter = EasyExcel.write(fileName, ComMngVaccinesInoculationExcelVo.class).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()).registerWriteHandler(new CustomSheetWriteHandler()).build(); WriteSheet writeSheet = EasyExcel.writerSheet("接种信息导出数据").build(); excelWriter.write(populList, writeSheet); excelWriter.finish(); File file = new File(fileName); inputStream = new FileInputStream(file); sftp.uploadMore(ftpUrl, name, inputStream); sftp.logout(); inputStream.close(); String absolutePath = file.getAbsolutePath(); boolean delete = file.delete(); log.info("删除excel【{}】结果【{}】", absolutePath, delete); } finally { // 千万别忘记finish 会帮忙关闭流 if (inputStream != null) { inputStream.close(); } if (excelWriter != null) { excelWriter.finish(); } } } return R.ok(excelUrl + name); } catch (Exception e) { e.printStackTrace(); log.error("文件传输失败【{}】", e.getMessage()); return R.fail(); } } @ApiOperation(value = "疫苗分类列表") @PostMapping("/enroll/type/list") public R getEnrollTypeListByAdmin() { return communityService.getEnrollTypeListByAdmin(); } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/CommunityApi.java
@@ -465,6 +465,26 @@ } /** * 随手拍删除 * * @param id 随手拍主键 * @param userId 登录用户 * @return 详情内容 */ @PostMapping("deleteEasyPhoto") public R deleteEasyPhoto(@RequestParam("id") Long id, @RequestParam("userId") Long userId) { ComActEasyPhotoDO comActEasyPhotoDO = comActEasyPhotoService.getBaseMapper().selectById(id); if(comActEasyPhotoDO==null){ return R.fail("随手拍不存在"); } comActEasyPhotoDO.setDelTag(1); int updateById = comActEasyPhotoService.getBaseMapper().updateById(comActEasyPhotoDO); if(updateById==1){ return R.ok(); } return R.fail(); } /** * 分页查询微心愿 * * @param comActMicroWishVO 查询参数 @@ -1541,10 +1561,14 @@ @PostMapping("/eldersauth/getMyfamilyElders/{userId}") R<List<ComMngFamilyInfoVO>> getMyfamilyElders(@PathVariable("userId") Long userId){ List<ComMngFamilyInfoVO> list = comMngPopulationDAO.listFamilyByUserId(userId); List<ComMngFamilyInfoVO> sortedList = list.stream().sorted(Comparator.comparing(ComMngFamilyInfoVO::getCreateAt).reversed()).collect(Collectors.toList()); List<ComMngFamilyInfoVO> listRt = new ArrayList<>(); list.forEach(rt -> { boolean isElders = rt.getAge()>=80; if(isElders){ sortedList.forEach(rt -> { int age = IdCard.IdNOToAge(rt.getIdCard()); boolean isElders = age >= 80; if (isElders) { listRt.add(rt); } }); @@ -1580,6 +1604,9 @@ //根据身份证查询出籍贯 出生日期 //String domicile = IdCard.domicile(eldersAuthDO.getIdCard()); String domicile = eldersAuthService.queryDomicile(eldersAuthDO.getIdCard()); if(StringUtils.isEmpty(domicile)){ domicile = "暂无"; } Date birthDay = IdCard.birthDay(eldersAuthDO.getIdCard()); eldersAuthDO.setDomicile(domicile); @@ -1611,10 +1638,11 @@ SysUserNoticeVO sysUserNoticeVO=new SysUserNoticeVO(); sysUserNoticeVO.setUserId(eldersAuthDO.getSumitUserId()); sysUserNoticeVO.setType(3); sysUserNoticeVO.setTitle("高龄认证社区社区反馈"); sysUserNoticeVO.setTitle("高龄认证社区反馈"); sysUserNoticeVO.setBusinessType(13); sysUserNoticeVO.setBusinessTitle(" "); sysUserNoticeVO.setBusinessContent("你提交【" +eldersAuthDO.getAuthUserName() + "】的高龄认证,社区进行了反馈"); sysUserNoticeVO.setBusinessContent("你提交【" +eldersAuthDO.getAuthUserName() + "】的高龄认证,社区反馈:" + eldersAuthFeedbackAddDTO.getFeedBack()); sysUserNoticeVO.setBusinessId(eldersAuthDO.getId()); sysUserNoticeVO.setStatus(0); sysUserNoticeVO.setBusinessStatus(2); @@ -1624,7 +1652,7 @@ } } return eldersAuthService.addFeedback(eldersAuthFeedbackAddDTO); return addR; } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/VaccinesApi.java
@@ -1,9 +1,6 @@ package com.panzhihua.service_community.api; import com.panzhihua.common.model.dtos.vaccines.VaccinesByAdminDTO; import com.panzhihua.common.model.dtos.vaccines.VaccinesEnrollByAdminDTO; import com.panzhihua.common.model.dtos.vaccines.VaccinesEnrollByAppDTO; import com.panzhihua.common.model.dtos.vaccines.VaccinesEnrollUserByAppDTO; import com.panzhihua.common.model.dtos.vaccines.*; import com.panzhihua.common.model.vos.R; import com.panzhihua.service_community.service.ComMngVaccinesEnrollRecordService; import com.panzhihua.service_community.service.ComMngVaccinesInoculationRecordService; @@ -98,7 +95,7 @@ * @param vaccinesByAdminDTO 请求参数 * @return 登记列表 */ @PostMapping("admin/enroll/list") @PostMapping("/admin/enroll/list") public R getVaccinesEnrollListByAdmin(@RequestBody VaccinesEnrollByAdminDTO vaccinesByAdminDTO) { return comMngVaccinesEnrollRecordService.getVaccinesEnrollListByAdmin(vaccinesByAdminDTO); } @@ -112,4 +109,43 @@ public R deleteVaccinesByAdmin(@RequestParam("id") Long id) { return comMngVaccinesService.deleteVaccinesByAdmin(id); } /** * 根据条件导出疫苗登记记录 * @param vaccinesByAdminDTO 请求参数 * @return 导出登记列表 */ @PostMapping("/admin/enroll/export") public R exportVaccinesEnrollListByAdmin(@RequestBody VaccinesEnrollByAdminDTO vaccinesByAdminDTO) { return comMngVaccinesEnrollRecordService.exportVaccinesEnrollListByAdmin(vaccinesByAdminDTO); } /** * 查询接种记录列表 * @param inoculationByAdminDTO 请求参数 * @return 接种记录列表 */ @PostMapping("/admin/inoculation/list") public R getVaccinesInoculationListByAdmin(@RequestBody VaccinesInoculationByAdminDTO inoculationByAdminDTO) { return comMngVaccinesInoculationRecordService.getVaccinesInoculationListByAdmin(inoculationByAdminDTO); } /** * 接种记录信息导出 * @param inoculationByAdminDTO 请求参数 * @return 导出结果 */ @PostMapping("/admin/inoculation/export") public R exportVaccinesInoculationListByAdmin(@RequestBody VaccinesInoculationByAdminDTO inoculationByAdminDTO) { return comMngVaccinesInoculationRecordService.exportVaccinesInoculationListByAdmin(inoculationByAdminDTO); } /** * 疫苗分类列表 * @return 疫苗分类列表 */ @PostMapping("/admin/enroll/type/list") public R getEnrollTypeListByAdmin() { return comMngVaccinesService.getEnrollTypeListByAdmin(); } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActEasyPhotoDAO.java
@@ -56,7 +56,7 @@ "<if test='comActEasyPhotoVO.handlerName != null and comActEasyPhotoVO.handlerName.trim() != ""'>" + "AND su.`name` like concat(#{comActEasyPhotoVO.handlerName},'%') \n" + " </if> " + "where p.status !=2"+ "where p.del_tag = 0 and p.status !=2"+ "<if test='comActEasyPhotoVO.communityId != null and comActEasyPhotoVO.communityId != 0'>" + " and p.community_id=#{comActEasyPhotoVO.communityId} " + " </if> " + @@ -111,7 +111,7 @@ "<if test='comActEasyPhotoVO.handlerName != null and comActEasyPhotoVO.handlerName.trim() != ""'>" + "AND su.`name` like concat(#{comActEasyPhotoVO.handlerName},'%') \n" + " </if> " + "where p.status=2 and p.is_need_feed_back=1 " + "where p.del_tag = 0 and p.status=2 and p.is_need_feed_back=1 " + "<if test='comActEasyPhotoVO.backUserId != null and comActEasyPhotoVO.backUserId != 0'>" + "and p.handler_id=#{comActEasyPhotoVO.backUserId}"+ " </if> " + @@ -163,14 +163,14 @@ "JOIN sys_user u on p.sponsor_id=u.user_id\n" + "LEFT JOIN sys_user su on p.handler_id=su.user_id\n" + "LEFT JOIN com_act_easy_photo_user pu on p.id=pu.easy_photo_id\n" + "WHERE p.id=#{id}") "WHERE p.del_tag = 0 and p.id=#{id}") ComActEasyPhotoVO detailEasyPhoto(Long id); @Select("SELECT\n" + "'1' type\n" + "FROM\n" + "com_act_easy_photo p \n" + " com_act_easy_photo p \n" + "WHERE\n" + "p.community_id = #{communityId} \n" + " p.del_tag = 0 and p.community_id = #{communityId} \n" + "AND p.STATUS = 1 \n"+ "\n" + "union all \n" + @@ -178,9 +178,9 @@ "SELECT\n" + "'1' type\n" + "FROM\n" + "com_act_easy_photo p \n" + " p.del_tag = 0 and com_act_easy_photo p \n" + "WHERE\n" + "p.community_id = #{communityId} \n" + " p.del_tag = 0 and p.community_id = #{communityId} \n" + "AND p.`status` = 2 and p.is_need_feed_back=1 and p.handler_id=#{userId}\n" ) List<TodoEventsVO> selectNeedToDo(@Param("communityId") Long communityId, @Param("userId") Long userId); @@ -210,6 +210,7 @@ "left JOIN sys_user su ON p.handler_id = su.user_id \n" + "left JOIN com_act_easy_photo_comment c ON p.id = c.easy_photo_id \n" + " <where>" + " p.del_tag = 0 " + "<if test='comActEasyPhotoVO.communityId != null and comActEasyPhotoVO.communityId != 0'>" + " and p.community_id=#{comActEasyPhotoVO.communityId} " + " </if> " + springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVaccinesEnrollRecordDAO.java
@@ -4,6 +4,7 @@ import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.panzhihua.common.model.dtos.vaccines.VaccinesEnrollByAdminDTO; import com.panzhihua.common.model.vos.vaccines.ComMngVaccinesEnrollExcelVo; import com.panzhihua.common.model.vos.vaccines.VaccinesEnrollByAdminVO; import com.panzhihua.common.model.vos.vaccines.VaccinesEnrollUserByAppVO; import com.panzhihua.service_community.model.dos.ComMngVaccinesEnrollRecordDO; @@ -21,18 +22,25 @@ @Mapper public interface ComMngVaccinesEnrollRecordDAO extends BaseMapper<ComMngVaccinesEnrollRecordDO> { @Select("select cmfi.id as userId,cmfi.name,cmfi.age,cmfi.job,cmfi.phone,cmfi.id_card from com_mng_family_info as cmfi where user_id = #{userId}") @Select("select cmfi.id as userId,cmfi.name,cmfi.age,cmfi.job,cmfi.phone,cmfi.id_card,cmfi.create_at from com_mng_family_info as cmfi where user_id = #{userId}") List<VaccinesEnrollUserByAppVO> getFamilyUserList(@Param("userId") Long userId); @Select("select su.user_id,su.name,su.nick_name,su.job,su.phone,su.id_card,su.birthday,su.sex from sys_user as su where user_id = #{userId}") @Select("select su.user_id,su.name,su.nick_name,su.job,su.phone,su.id_card,su.birthday,su.sex,su.create_at from sys_user as su where user_id = #{userId}") VaccinesEnrollUserByAppVO getSysUser(@Param("userId") Long userId); @Select("select cmfi.name,cmfi.age,cmfi.phone,cmfi.id_card from com_mng_family_info as cmfi where id = #{userId}") VaccinesEnrollUserByAppVO getFamilyUser(@Param("userId") Long userId); @Select("<script> " + "select cmver.id,cmver.name,cmver.sex,cmver.age,cmver.phone,cmver.id_card,cmver.create_at from com_mng_vaccines_enroll_record as cmver" + "select cmver.id,cmver.name,cmver.sex,cmver.age,cmver.phone,cmver.id_card,cmver.create_at,cmv.name as vaccines from com_mng_vaccines_enroll_record as cmver " + " left join com_mng_vaccines as cmv on cmv.id = cmver.type " + " <where>" + "<if test='vaccinesByAdminDTO.communityId != null'>" + " and cmver.community_id = #{vaccinesByAdminDTO.communityId} "+ " </if> " + "<if test='vaccinesByAdminDTO.vaccines != null and vaccinesByAdminDTO.vaccines != ""'>" + " and cmv.name = #{vaccinesByAdminDTO.vaccines} "+ " </if> " + "<if test='vaccinesByAdminDTO.name != null and vaccinesByAdminDTO.name != ""'>" + " and cmver.name like concat('%',#{vaccinesByAdminDTO.name},'%') "+ " </if> " + @@ -42,14 +50,44 @@ "<if test='vaccinesByAdminDTO.phone != null and vaccinesByAdminDTO.phone != ""'>" + " and cmver.phone = #{vaccinesByAdminDTO.phone} "+ " </if> " + "<if test='vaccinesByAdminDTO.startTime != null '>\n" + "<if test='vaccinesByAdminDTO.startTime != null and vaccinesByAdminDTO.startTime != "" '>\n" + " AND cmver.create_at <![CDATA[>=]]> #{vaccinesByAdminDTO.startTime} \n" + "</if>" + "<if test='vaccinesByAdminDTO.endTime != null '>\n" + "<if test='vaccinesByAdminDTO.endTime != null and vaccinesByAdminDTO.endTime != "" '>\n" + " AND cmver.create_at <![CDATA[<=]]> #{vaccinesByAdminDTO.endTime} " + " </if> \n" + " </where>" + " order by cmver.create_at desc"+ " </script>") IPage<VaccinesEnrollByAdminVO> getVaccinesEnrollListByAdmin(Page page, @Param("vaccinesByAdminDTO") VaccinesEnrollByAdminDTO vaccinesByAdminDTO); @Select("<script> " + "select cmver.name,cmver.sex,cmver.age,cmver.phone,cmver.id_card,cmver.create_at,cmv.name as vaccines from com_mng_vaccines_enroll_record as cmver " + " left join com_mng_vaccines as cmv on cmv.id = cmver.type " + " <where>" + "<if test='vaccinesByAdminDTO.communityId != null'>" + " and cmver.community_id = #{vaccinesByAdminDTO.communityId} "+ " </if> " + "<if test='vaccinesByAdminDTO.vaccines != null and vaccinesByAdminDTO.vaccines != ""'>" + " and cmv.name = #{vaccinesByAdminDTO.vaccines} "+ " </if> " + "<if test='vaccinesByAdminDTO.name != null and vaccinesByAdminDTO.name != ""'>" + " and cmver.name like concat('%',#{vaccinesByAdminDTO.name},'%') "+ " </if> " + "<if test='vaccinesByAdminDTO.idCard != null and vaccinesByAdminDTO.idCard != ""'>" + " and cmver.id_card = #{vaccinesByAdminDTO.idCard} "+ " </if> " + "<if test='vaccinesByAdminDTO.phone != null and vaccinesByAdminDTO.phone != ""'>" + " and cmver.phone = #{vaccinesByAdminDTO.phone} "+ " </if> " + "<if test='vaccinesByAdminDTO.startTime != null and vaccinesByAdminDTO.startTime != "" '>\n" + " AND cmver.create_at <![CDATA[>=]]> #{vaccinesByAdminDTO.startTime} \n" + "</if>" + "<if test='vaccinesByAdminDTO.endTime != null and vaccinesByAdminDTO.endTime != "" '>\n" + " AND cmver.create_at <![CDATA[<=]]> #{vaccinesByAdminDTO.endTime} " + " </if> \n" + " </where>" + " order by cmver.create_at desc"+ " </script>") List<ComMngVaccinesEnrollExcelVo> exportVaccinesEnrollListByAdmin(@Param("vaccinesByAdminDTO") VaccinesEnrollByAdminDTO vaccinesByAdminDTO); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVaccinesInoculationRecordDAO.java
@@ -1,6 +1,11 @@ package com.panzhihua.service_community.dao; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.panzhihua.common.model.dtos.vaccines.VaccinesInoculationByAdminDTO; import com.panzhihua.common.model.vos.vaccines.ComMngVaccinesInoculationExcelVo; import com.panzhihua.common.model.vos.vaccines.VaccinesInoculationByAdminVO; import com.panzhihua.common.model.vos.vaccines.VaccinesUserInoculationByAppVO; import com.panzhihua.service_community.model.dos.ComMngVaccinesInoculationRecordDO; import org.apache.ibatis.annotations.Mapper; @@ -33,4 +38,63 @@ " </script>") List<VaccinesUserInoculationByAppVO> getUserInoculationListByApp(@Param("ids") List<Long> ids, @Param("userId") Long userId); @Select("<script> " + "select cmvir.id,cmvir.name,cmvir.sex,cmvir.age,cmvir.phone,cmvir.id_card,cmvir.inoculation_at,cmvir.dosage " + ",cmvir.medical_institution,cmvir.vaccines_code,cmvir.vaccines,cmvir.remark from com_mng_vaccines_inoculation_record as cmvir" + " <where>" + "<if test='inoculationByAdminDTO.communityId != null'>" + " and cmvir.community_id = #{inoculationByAdminDTO.communityId} "+ " </if> " + "<if test='inoculationByAdminDTO.name != null and inoculationByAdminDTO.name != ""'>" + " and cmvir.name like concat('%',#{inoculationByAdminDTO.name},'%') "+ " </if> " + "<if test='inoculationByAdminDTO.dosage != null and inoculationByAdminDTO.dosage != ""'>" + " and cmvir.dosage = #{inoculationByAdminDTO.dosage} "+ " </if> " + "<if test='inoculationByAdminDTO.idCard != null and inoculationByAdminDTO.idCard != ""'>" + " and cmvir.id_card = #{inoculationByAdminDTO.idCard} "+ " </if> " + "<if test='inoculationByAdminDTO.phone != null and inoculationByAdminDTO.phone != ""'>" + " and cmvir.phone = #{inoculationByAdminDTO.phone} "+ " </if> " + "<if test='inoculationByAdminDTO.startTime != null and inoculationByAdminDTO.startTime != ""'>\n" + " AND cmvir.inoculation_at <![CDATA[>=]]> #{inoculationByAdminDTO.startTime} \n" + "</if>" + "<if test='inoculationByAdminDTO.endTime != null and inoculationByAdminDTO.endTime != ""'>\n" + " AND cmvir.inoculation_at <![CDATA[<=]]> #{inoculationByAdminDTO.endTime} " + " </if> \n" + " </where>" + " order by inoculation_at desc " + " </script>") IPage<VaccinesInoculationByAdminVO> getVaccinesInoculationListByAdmin(Page page, @Param("inoculationByAdminDTO") VaccinesInoculationByAdminDTO inoculationByAdminDTO); @Select("<script> " + "select cmvir.name,cmvir.sex,cmvir.age,cmvir.phone,cmvir.id_card,cmvir.inoculation_at,cmvir.dosage " + ",cmvir.medical_institution,cmvir.vaccines_code,cmvir.vaccines,cmvir.remark from com_mng_vaccines_inoculation_record as cmvir" + " <where>" + "<if test='inoculationByAdminDTO.communityId != null'>" + " and cmvir.community_id = #{inoculationByAdminDTO.communityId} "+ " </if> " + "<if test='inoculationByAdminDTO.name != null and inoculationByAdminDTO.name != ""'>" + " and cmvir.name like concat('%',#{inoculationByAdminDTO.name},'%') "+ " </if> " + "<if test='inoculationByAdminDTO.dosage != null and inoculationByAdminDTO.dosage != ""'>" + " and cmvir.dosage = #{inoculationByAdminDTO.dosage} "+ " </if> " + "<if test='inoculationByAdminDTO.idCard != null and inoculationByAdminDTO.idCard != ""'>" + " and cmvir.id_card = #{inoculationByAdminDTO.idCard} "+ " </if> " + "<if test='inoculationByAdminDTO.phone != null and inoculationByAdminDTO.phone != ""'>" + " and cmvir.phone = #{inoculationByAdminDTO.phone} "+ " </if> " + "<if test='inoculationByAdminDTO.startTime != null and inoculationByAdminDTO.startTime != ""'>\n" + " AND cmvir.inoculation_at <![CDATA[>=]]> #{inoculationByAdminDTO.startTime} \n" + "</if>" + "<if test='inoculationByAdminDTO.endTime != null and inoculationByAdminDTO.endTime != "" '>\n" + " AND cmvir.inoculation_at <![CDATA[<=]]> #{inoculationByAdminDTO.endTime} " + " </if> \n" + " </where>" + " order by inoculation_at desc " + " </script>") List<ComMngVaccinesInoculationExcelVo> exportVaccinesInoculationListByAdmin(@Param("inoculationByAdminDTO") VaccinesInoculationByAdminDTO inoculationByAdminDTO); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComActEasyPhotoDO.java
@@ -100,4 +100,9 @@ * 地址备注 */ private String addrRemark; /** * 是否删除 0 否 1 是 */ private Integer delTag; } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComMngVaccinesInoculationRecordDO.java
@@ -97,6 +97,11 @@ */ private Long userType; /** * 社区id */ private Long communityId; @Override public String toString() { return "ComMngVaccinesInoculationRecordDO{" + springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComMngVaccinesEnrollRecordService.java
@@ -34,4 +34,11 @@ */ R getVaccinesEnrollListByAdmin(VaccinesEnrollByAdminDTO vaccinesByAdminDTO); /** * 根据条件导出疫苗登记记录 * @param vaccinesByAdminDTO 请求参数 * @return 导出登记列表 */ R exportVaccinesEnrollListByAdmin(VaccinesEnrollByAdminDTO vaccinesByAdminDTO); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComMngVaccinesInoculationRecordService.java
@@ -1,6 +1,7 @@ package com.panzhihua.service_community.service; import com.baomidou.mybatisplus.extension.service.IService; import com.panzhihua.common.model.dtos.vaccines.VaccinesInoculationByAdminDTO; import com.panzhihua.common.model.vos.R; import com.panzhihua.service_community.model.dos.ComMngVaccinesInoculationRecordDO; @@ -18,4 +19,18 @@ */ R getVaccinesUserInoculationListByApp(Long userId); /** * 查询接种记录列表 * @param inoculationByAdminDTO 请求参数 * @return 接种记录列表 */ R getVaccinesInoculationListByAdmin(VaccinesInoculationByAdminDTO inoculationByAdminDTO); /** * 接种记录信息导出 * @param inoculationByAdminDTO 请求参数 * @return 导出结果 */ R exportVaccinesInoculationListByAdmin(VaccinesInoculationByAdminDTO inoculationByAdminDTO); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComMngVaccinesService.java
@@ -46,4 +46,10 @@ */ R deleteVaccinesByAdmin(Long id); /** * 疫苗分类列表 * @return 疫苗分类列表 */ R getEnrollTypeListByAdmin(); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActActivityServiceImpl.java
@@ -1,12 +1,17 @@ package com.panzhihua.service_community.service.impl; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.panzhihua.common.model.dtos.community.ExcelElderAuthDTO; import com.panzhihua.common.model.vos.IndexDataVO; import com.panzhihua.common.model.vos.LoginUserInfoVO; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.community.*; import com.panzhihua.common.service.user.UserService; import com.panzhihua.service_community.dao.ComActActSignDAO; import com.panzhihua.service_community.dao.ComActActivityDAO; import com.panzhihua.service_community.dao.ComActDiscussOptionUserDAO; @@ -40,6 +45,8 @@ private ComActActivityDAO comActActivityDAO; @Resource private ComActActSignDAO comActActSignDAO; @Resource private UserService userService; /** * 新增社区活动 @@ -237,8 +244,16 @@ Integer type = signactivityVO.getType(); Long userId = signactivityVO.getUserId(); Integer isVolunteer = signactivityVO.getIsVolunteer(); int num=0; if (1==type) { R<LoginUserInfoVO> userInfoR = userService.getUserInfoByUserId(String.valueOf(userId)); LoginUserInfoVO loginUserInfoVO = JSONObject.parseObject(JSONObject.toJSONString(userInfoR.getData()), LoginUserInfoVO.class); boolean userNotVolunteer = !(loginUserInfoVO.getIsVolunteer()==1); if(isVolunteer == 1 && userNotVolunteer){ return R.fail("只有志愿者才能报名"); } ComActActSignDO comActActSignDO=new ComActActSignDO(); comActActSignDO.setActivityId(activityId); comActActSignDO.setUserId(userId); springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActNeighborCircleServiceImpl.java
@@ -313,7 +313,8 @@ ComActNeighborCircleFabulousDO oldCircleFabulousDO = comActNeighborCircleFabulousDAO.selectOne( new QueryWrapper<ComActNeighborCircleFabulousDO>().lambda().eq(ComActNeighborCircleFabulousDO::getType,ComActNeighborFabulousAppDTO.type.llq) .eq(ComActNeighborCircleFabulousDO::getParentId,fabulousAppDTO.getServiceId()) .eq(ComActNeighborCircleFabulousDO::getIsEffective,ComActNeighborCircleFabulousDO.isEffective.yes)); .eq(ComActNeighborCircleFabulousDO::getIsEffective,ComActNeighborCircleFabulousDO.isEffective.yes) .eq(ComActNeighborCircleFabulousDO::getUserId,fabulousAppDTO.getUserId())); if(oldCircleFabulousDO != null){ return R.fail("您已点赞"); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComCvtServeServiceImpl.java
@@ -174,6 +174,7 @@ comCvtBusinessDOS = comCvtBusinessDAO.selectList(new LambdaQueryWrapper<>()); } Map<String, Long> businessMap = getBusinessMap(comCvtBusinessDOS); List<String> errorInfo = new ArrayList<>(); list.forEach(comCvtServeExcelVO -> { /** * 便民服务分类存在 并且 便民服务商家 匹配上 @@ -189,9 +190,24 @@ }else{ log.error(String.format("导入失败:商家【%s】下已有服务【%s】",comCvtServeExcelVO.getBusinessName(),comCvtServeExcelVO.getServiceName())); } }else{ if(!categoryMap.containsKey(comCvtServeExcelVO.getCategoryName())) { errorInfo.add(comCvtServeExcelVO.getCategoryName() +"导入失败: 服务分类不存在"); } if(!businessMap.containsKey(comCvtServeExcelVO.getBusinessName())) { errorInfo.add(comCvtServeExcelVO.getBusinessName() +"导入失败: 便民服务商家不存在"); } } }); this.saveBatch(comCvtServeDOS); boolean saveBatched = this.saveBatch(comCvtServeDOS); if(saveBatched) { if (comCvtServeDOS.size()>0 && errorInfo != null && errorInfo.size() > 0) { return R.fail("导入部分成功:" + errorInfo.toString()); } if(comCvtServeDOS.size()==0 && errorInfo != null && errorInfo.size() > 0){ return R.fail("导入失败:" + errorInfo.toString()); } } return R.ok("共计导入服务数量:"+comCvtServeDOS.size()); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngVaccinesEnrollRecordServiceImpl.java
@@ -1,6 +1,7 @@ package com.panzhihua.service_community.service.impl; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.panzhihua.common.model.dtos.vaccines.EnrollUserByAppDTO; @@ -10,7 +11,6 @@ import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.vaccines.VaccinesEnrollByAdminVO; import com.panzhihua.common.model.vos.vaccines.VaccinesEnrollUserByAppVO; import com.panzhihua.common.utlis.AgeUtils; import com.panzhihua.common.utlis.IdCard; import com.panzhihua.common.utlis.StringUtils; import com.panzhihua.service_community.dao.ComMngVaccinesDAO; @@ -23,7 +23,9 @@ import javax.annotation.Resource; import java.util.ArrayList; import java.util.Comparator; import java.util.List; import java.util.stream.Collectors; /** * @auther lyq @@ -45,7 +47,6 @@ public R getVaccinesUserListByApp(VaccinesEnrollUserByAppDTO enrollUserByAppDTO){ //查询当前用户的家庭成员列表 List<VaccinesEnrollUserByAppVO> userLists = new ArrayList<>(); List<VaccinesEnrollUserByAppVO> newUserLists = new ArrayList<>(); //将自己的信息组装进家庭成员列表中 VaccinesEnrollUserByAppVO ownUser = this.baseMapper.getSysUser(enrollUserByAppDTO.getUserId()); if(ownUser != null){ @@ -76,10 +77,12 @@ user.setIsEnroll(VaccinesEnrollUserByAppVO.isEnroll.yes); }else{ user.setIsEnroll(VaccinesEnrollUserByAppVO.isEnroll.no); newUserLists.add(user); } }); } List<VaccinesEnrollUserByAppVO> newUserLists = userLists.stream().sorted(Comparator.comparing(VaccinesEnrollUserByAppVO::getIsEnroll).reversed() .thenComparing(Comparator.comparing(VaccinesEnrollUserByAppVO::getCreateAt).reversed())).collect(Collectors.toList()); return R.ok(newUserLists); } @@ -147,7 +150,28 @@ * @param vaccinesByAdminDTO 请求参数 * @return 登记列表 */ @Override public R getVaccinesEnrollListByAdmin(VaccinesEnrollByAdminDTO vaccinesByAdminDTO){ return R.ok(this.baseMapper.getVaccinesEnrollListByAdmin(new Page<VaccinesEnrollByAdminVO>(vaccinesByAdminDTO.getPageNum(),vaccinesByAdminDTO.getPageSize()),vaccinesByAdminDTO)); IPage<VaccinesEnrollByAdminVO> enrollByAdminVOIPage = this.baseMapper.getVaccinesEnrollListByAdmin(new Page<VaccinesEnrollByAdminVO>(vaccinesByAdminDTO.getPageNum(),vaccinesByAdminDTO.getPageSize()),vaccinesByAdminDTO); if(!enrollByAdminVOIPage.getRecords().isEmpty()){ for (VaccinesEnrollByAdminVO enroll:enrollByAdminVOIPage.getRecords()) { if(enroll.getIdCard().length() != 18){ enroll.setSex(3); }else{ enroll.setSex(IdCard.sex(enroll.getIdCard())); } } } return R.ok(enrollByAdminVOIPage); } /** * 根据条件导出疫苗登记记录 * @param vaccinesByAdminDTO 请求参数 * @return 导出登记列表 */ @Override public R exportVaccinesEnrollListByAdmin(VaccinesEnrollByAdminDTO vaccinesByAdminDTO){ return R.ok(this.baseMapper.exportVaccinesEnrollListByAdmin(vaccinesByAdminDTO)); } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngVaccinesInoculationRecordServiceImpl.java
@@ -1,6 +1,8 @@ package com.panzhihua.service_community.service.impl; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.panzhihua.common.model.dtos.vaccines.VaccinesInoculationByAdminDTO; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.vaccines.VaccinesEnrollUserByAppVO; import com.panzhihua.common.model.vos.vaccines.VaccinesUserInoculationByAppVO; @@ -37,4 +39,24 @@ return R.ok(this.baseMapper.getUserInoculationListByApp(userIds,userId)); } /** * 查询接种记录列表 * @param inoculationByAdminDTO 请求参数 * @return 接种记录列表 */ @Override public R getVaccinesInoculationListByAdmin(VaccinesInoculationByAdminDTO inoculationByAdminDTO){ return R.ok(this.baseMapper.getVaccinesInoculationListByAdmin(new Page(inoculationByAdminDTO.getPageNum(),inoculationByAdminDTO.getPageSize()),inoculationByAdminDTO)); } /** * 接种记录信息导出 * @param inoculationByAdminDTO 请求参数 * @return 导出结果 */ @Override public R exportVaccinesInoculationListByAdmin(VaccinesInoculationByAdminDTO inoculationByAdminDTO){ return R.ok(this.baseMapper.exportVaccinesInoculationListByAdmin(inoculationByAdminDTO)); } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngVaccinesServiceImpl.java
@@ -114,4 +114,14 @@ } } /** * 疫苗分类列表 * @return 疫苗分类列表 */ public R getEnrollTypeListByAdmin(){ List<ComMngVaccinesDO> vaccinesDOList = this.baseMapper.selectList(new QueryWrapper<ComMngVaccinesDO>() .lambda().eq(ComMngVaccinesDO::getStatus,1)); return R.ok(vaccinesDOList); } }