| | |
| | | " 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); |
| | | |
| | |
| | | " <where>" + |
| | | "<if test='vaccinesByAdminDTO.communityId != null'>" + |
| | | " and cmver.community_id = #{vaccinesByAdminDTO.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='vaccinesByAdminDTO.vaccines != null and vaccinesByAdminDTO.vaccines != ""'>" + |
| | | " and cmv.name = #{vaccinesByAdminDTO.vaccines} "+ |
| | |
| | | " AND cmver.create_at <![CDATA[<=]]> #{vaccinesByAdminDTO.endTime} " + |
| | | " </if> \n" + |
| | | " </where>" + |
| | | " order by cmver.create_at desc"+ |
| | | " </script>") |
| | | List<ComMngVaccinesEnrollExcelVo> exportVaccinesEnrollListByAdmin(@Param("vaccinesByAdminDTO") VaccinesEnrollByAdminDTO vaccinesByAdminDTO); |
| | | } |