From 5a8a90c095280fbd2106869ecd2bad10e01a57a6 Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期四, 23 十二月 2021 18:10:22 +0800
Subject: [PATCH] 12/23 大屏修改
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVaccinesEnrollRecordDAO.java | 118 ++++++++++++++++++++++++----------------------------------
1 files changed, 49 insertions(+), 69 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVaccinesEnrollRecordDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVaccinesEnrollRecordDAO.java
index 06c898a..adee323 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVaccinesEnrollRecordDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVaccinesEnrollRecordDAO.java
@@ -1,5 +1,11 @@
package com.panzhihua.service_community.dao;
+import java.util.List;
+
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
@@ -8,11 +14,6 @@
import com.panzhihua.common.model.vos.vaccines.VaccinesEnrollByAdminVO;
import com.panzhihua.common.model.vos.vaccines.VaccinesEnrollUserByAppVO;
import com.panzhihua.service_community.model.dos.ComMngVaccinesEnrollRecordDO;
-import org.apache.ibatis.annotations.Mapper;
-import org.apache.ibatis.annotations.Param;
-import org.apache.ibatis.annotations.Select;
-
-import java.util.List;
/**
* @auther lyq
@@ -31,69 +32,48 @@
@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,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>")
- IPage<VaccinesEnrollByAdminVO> getVaccinesEnrollListByAdmin(Page page, @Param("vaccinesByAdminDTO") VaccinesEnrollByAdminDTO vaccinesByAdminDTO);
+ @Select("<script> "
+ + "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> "
+ + "<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>")
+ 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.ids != null and vaccinesByAdminDTO.ids.size > 0'>" +
- " and cmvir.id in " +
- "<foreach item=\"item\" collection=\"vaccinesByAdminDTO.ids\" separator=\",\" open=\"(\" close=\")\" index=\"\"> \n" +
- "#{item}" +
- "</foreach>" +
- " </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);
+ @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.ids != null and vaccinesByAdminDTO.ids.size > 0'>" + " and cmver.id in "
+ + "<foreach item=\"item\" collection=\"vaccinesByAdminDTO.ids\" separator=\",\" open=\"(\" close=\")\" index=\"\"> \n"
+ + "#{item}" + "</foreach>" + " </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);
}
--
Gitblit v1.7.1