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/vaccines/ComMngVaccinesEnrollExcelVo.java
New file @@ -0,0 +1,31 @@ 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; } 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/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.*; @@ -2610,4 +2607,28 @@ */ @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); } springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/VaccinesApi.java
@@ -1,20 +1,43 @@ 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.community.ComMngPopulationExcelVo; import com.panzhihua.common.model.vos.community.ComMngPopulationVO; import com.panzhihua.common.model.vos.vaccines.ComMngVaccinesEnrollExcelVo; import com.panzhihua.common.model.vos.vaccines.ComMngVaccinesInoculationExcelVo; import com.panzhihua.common.model.vos.vaccines.VaccinesEnrollByAdminVO; import com.panzhihua.common.model.vos.vaccines.VaccinesInoculationByAdminVO; 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 +47,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 +72,131 @@ 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(); } } } 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,34 @@ 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); } } 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; @@ -33,6 +34,9 @@ @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" + " <where>" + "<if test='vaccinesByAdminDTO.communityId != null'>" + " and cmver.community_id = #{vaccinesByAdminDTO.communityId} "+ " </if> " + "<if test='vaccinesByAdminDTO.name != null and vaccinesByAdminDTO.name != ""'>" + " and cmver.name like concat('%',#{vaccinesByAdminDTO.name},'%') "+ " </if> " + @@ -52,4 +56,28 @@ " </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 from com_mng_vaccines_enroll_record as cmver" + " <where>" + "<if test='vaccinesByAdminDTO.communityId != null'>" + " and cmver.community_id = #{vaccinesByAdminDTO.communityId} "+ " </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 '>\n" + " AND cmver.create_at <![CDATA[>=]]> #{vaccinesByAdminDTO.startTime} \n" + "</if>" + "<if test='vaccinesByAdminDTO.endTime != null '>\n" + " AND cmver.create_at <![CDATA[<=]]> #{vaccinesByAdminDTO.endTime} " + " </if> \n" + " </where>" + " </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,61 @@ " </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 '>\n" + " AND cmvir.inoculation_at <![CDATA[>=]]> #{inoculationByAdminDTO.startTime} \n" + "</if>" + "<if test='inoculationByAdminDTO.endTime != null '>\n" + " AND cmvir.inoculation_at <![CDATA[<=]]> #{inoculationByAdminDTO.endTime} " + " </if> \n" + " </where>" + " </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 '>\n" + " AND cmvir.inoculation_at <![CDATA[>=]]> #{inoculationByAdminDTO.startTime} \n" + "</if>" + "<if test='inoculationByAdminDTO.endTime != null '>\n" + " AND cmvir.inoculation_at <![CDATA[<=]]> #{inoculationByAdminDTO.endTime} " + " </if> \n" + " </where>" + " </script>") List<ComMngVaccinesInoculationExcelVo> exportVaccinesInoculationListByAdmin(@Param("inoculationByAdminDTO") VaccinesInoculationByAdminDTO inoculationByAdminDTO); } 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/impl/ComMngVaccinesEnrollRecordServiceImpl.java
@@ -147,7 +147,18 @@ * @param vaccinesByAdminDTO 请求参数 * @return 登记列表 */ @Override public R getVaccinesEnrollListByAdmin(VaccinesEnrollByAdminDTO vaccinesByAdminDTO){ return R.ok(this.baseMapper.getVaccinesEnrollListByAdmin(new Page<VaccinesEnrollByAdminVO>(vaccinesByAdminDTO.getPageNum(),vaccinesByAdminDTO.getPageSize()),vaccinesByAdminDTO)); } /** * 根据条件导出疫苗登记记录 * @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)); } }
