花城E+防疫修改

101captain

2022-04-29 ef4ea7eca5e06df669fe419af7f010eafec847cf

花城E+防疫修改

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActAcidRecordMapper.xml

@@ -32,7 +32,7 @@
                and (name like concat('%',#{commonPage.keyword},'%') or phone like concat('%',#{commonPage.keyword},'%') or id_card like concat('%',#{commonPage.keyword},'%'))
            </if>
            <if test="commonPage.startTime !=null">
                and create_time between #{commonPage.startTime} and #{commonPage.stopTime}
                and create_time between #{commonPage.startTime} and concat(#{commonPage.stopTime},' 23:59:59')
            </if>
            <if test="commonPage.isAddress !=null">
                <if test="commonPage.isAddress == 0">
@@ -68,7 +68,7 @@
                and (name like concat('%',#{commonPage.keyword},'%') or phone like concat('%',#{commonPage.keyword},'%') or id_card like concat('%',#{commonPage.keyword},'%'))
            </if>
            <if test="commonPage.startTime !=null">
                and create_time between #{commonPage.startTime} and #{commonPage.stopTime}
                and create_time between #{commonPage.startTime}  and concat(#{commonPage.stopTime},' 23:59:59')
            </if>
            <if test="commonPage.isAddress !=null">
                <if test="commonPage.isAddress == 0">