java/zhihuishenqu.git

			@@ -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 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);
			@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);
			}