| | |
| | | + "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> " |
| | | + " 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 != ""'>" |
| | |
| | | + "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> " |
| | | + " 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> " |