From 08f1b1f1804a8bd833d42f257908d80e88387b55 Mon Sep 17 00:00:00 2001
From: mitao <2763622819@qq.com>
Date: 星期五, 14 三月 2025 11:27:47 +0800
Subject: [PATCH] 3.5增加登录验证、修改密码、人员列表调整
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVaccinesInoculationRecordDAO.java | 132 +++++++++++++++++++-------------------------
1 files changed, 57 insertions(+), 75 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 c2844ac..de6a1c2 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,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.VaccinesInoculationByAdminVO;
import com.panzhihua.common.model.vos.vaccines.VaccinesUserInoculationByAppVO;
import com.panzhihua.service_community.model.dos.ComMngVaccinesInoculationRecordDO;
-import org.apache.ibatis.annotations.Mapper;
-import org.apache.ibatis.annotations.Param;
-import org.apache.ibatis.annotations.Select;
-
-import java.util.List;
/**
* @auther lyq
@@ -22,77 +23,58 @@
@Mapper
public interface ComMngVaccinesInoculationRecordDAO extends BaseMapper<ComMngVaccinesInoculationRecordDO> {
- @Select("<script> " +
- "select id,vaccines,name,inoculation_at,vaccines_code,medical_institution,dosage from com_mng_vaccines_inoculation_record " +
- " where 1=1 and " +
- "<if test='ids != null and ids.size>0'>" +
- "(user_type = 2 and user_id in "+
- "<foreach item=\"item\" collection=\"ids\" separator=\",\" open=\"(\" close=\")\" index=\"\"> " +
- "#{item} " +
- "</foreach>" +
- " ) or " +
- " </if> " +
+ @Select("<script> "
+ + "select id,vaccines,name,inoculation_at,vaccines_code,medical_institution,dosage from com_mng_vaccines_inoculation_record "
+ + " where 1=1 and " + "<if test='ids != null and ids.size>0'>" + "(user_type = 2 and user_id in "
+ + "<foreach item=\"item\" collection=\"ids\" separator=\",\" open=\"(\" close=\")\" index=\"\"> " + "#{item} "
+ + "</foreach>" + " ) or " + " </if> " +
- " (user_type = 1 and user_id = #{userId}) " +
- " order by inoculation_at desc " +
- " </script>")
- List<VaccinesUserInoculationByAppVO> getUserInoculationListByApp(@Param("ids") List<Long> ids, @Param("userId") Long userId);
+ " (user_type = 1 and user_id = #{userId}) " + " order by inoculation_at desc " + " </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>" +
- " </script>")
- IPage<VaccinesInoculationByAdminVO> getVaccinesInoculationListByAdmin(Page page, @Param("inoculationByAdminDTO") VaccinesInoculationByAdminDTO inoculationByAdminDTO);
+ @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>" +
- " </script>")
- List<ComMngVaccinesInoculationExcelVo> exportVaccinesInoculationListByAdmin(@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.ids != null and inoculationByAdminDTO.ids.size > 0'>" + " and cmvir.id in "
+ + "<foreach item=\"item\" collection=\"inoculationByAdminDTO.ids\" separator=\",\" open=\"(\" close=\")\" index=\"\"> \n"
+ + "#{item}" + "</foreach>" + " </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);
}
--
Gitblit v1.7.1