| | |
| | | " 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); |
| | | |
| | |
| | | " <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},'%') "+ |
| | |
| | | " AND cmvir.inoculation_at <![CDATA[<=]]> #{inoculationByAdminDTO.endTime} " + |
| | | " </if> \n" + |
| | | " </where>" + |
| | | " order by inoculation_at desc " + |
| | | " </script>") |
| | | List<ComMngVaccinesInoculationExcelVo> exportVaccinesInoculationListByAdmin(@Param("inoculationByAdminDTO") VaccinesInoculationByAdminDTO inoculationByAdminDTO); |
| | | } |