From 5d55062d003a17e197523f37d68d0e88ba727219 Mon Sep 17 00:00:00 2001
From: 罗元桥 <2376770955@qq.com>
Date: 星期四, 20 五月 2021 19:13:48 +0800
Subject: [PATCH] Merge branch 'test' into 'master'

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVaccinesInoculationRecordDAO.java |   64 ++++++++++++++++++++++++++++++++
 1 files changed, 64 insertions(+), 0 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVaccinesInoculationRecordDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVaccinesInoculationRecordDAO.java
index 7a43aa2..d5c5547 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVaccinesInoculationRecordDAO.java
+++ b/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 != &quot;&quot;'>" +
+            " and cmvir.name like concat('%',#{inoculationByAdminDTO.name},'%') "+
+            " </if> " +
+            "<if test='inoculationByAdminDTO.dosage != null and inoculationByAdminDTO.dosage != &quot;&quot;'>" +
+            " and cmvir.dosage = #{inoculationByAdminDTO.dosage} "+
+            " </if> " +
+            "<if test='inoculationByAdminDTO.idCard != null and inoculationByAdminDTO.idCard != &quot;&quot;'>" +
+            " and cmvir.id_card = #{inoculationByAdminDTO.idCard} "+
+            " </if> " +
+            "<if test='inoculationByAdminDTO.phone != null and inoculationByAdminDTO.phone != &quot;&quot;'>" +
+            " and cmvir.phone = #{inoculationByAdminDTO.phone} "+
+            " </if> " +
+            "<if test='inoculationByAdminDTO.startTime != null and inoculationByAdminDTO.startTime != &quot;&quot;'>\n" +
+            " AND cmvir.inoculation_at <![CDATA[>=]]> #{inoculationByAdminDTO.startTime}  \n" +
+            "</if>" +
+            "<if test='inoculationByAdminDTO.endTime != null and inoculationByAdminDTO.endTime != &quot;&quot;'>\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 != &quot;&quot;'>" +
+            " and cmvir.name like concat('%',#{inoculationByAdminDTO.name},'%') "+
+            " </if> " +
+            "<if test='inoculationByAdminDTO.dosage != null and inoculationByAdminDTO.dosage != &quot;&quot;'>" +
+            " and cmvir.dosage = #{inoculationByAdminDTO.dosage} "+
+            " </if> " +
+            "<if test='inoculationByAdminDTO.idCard != null and inoculationByAdminDTO.idCard != &quot;&quot;'>" +
+            " and cmvir.id_card = #{inoculationByAdminDTO.idCard} "+
+            " </if> " +
+            "<if test='inoculationByAdminDTO.phone != null and inoculationByAdminDTO.phone != &quot;&quot;'>" +
+            " and cmvir.phone = #{inoculationByAdminDTO.phone} "+
+            " </if> " +
+            "<if test='inoculationByAdminDTO.startTime != null and inoculationByAdminDTO.startTime != &quot;&quot;'>\n" +
+            " AND cmvir.inoculation_at <![CDATA[>=]]> #{inoculationByAdminDTO.startTime}  \n" +
+            "</if>" +
+            "<if test='inoculationByAdminDTO.endTime != null and inoculationByAdminDTO.endTime != &quot;&quot; '>\n" +
+            " AND cmvir.inoculation_at <![CDATA[<=]]> #{inoculationByAdminDTO.endTime}  " +
+            " </if> \n" +
+            " </where>" +
+            " order by inoculation_at desc " +
+            " </script>")
+    List<ComMngVaccinesInoculationExcelVo> exportVaccinesInoculationListByAdmin(@Param("inoculationByAdminDTO") VaccinesInoculationByAdminDTO inoculationByAdminDTO);
 }

--
Gitblit v1.7.1