【丽水】患者满意度导出增加完成时间条件

陈昶聿

4 天以前 2fd4481d5927519f867c99e0b355ce326573ea68

【丽水】患者满意度导出增加完成时间条件

 smartor/src/main/resources/mapper/smartor/PatSatisfactionMapper.xml

@@ -108,17 +108,11 @@
            <if test="orgid != null  and orgid != ''">
                and orgid = #{orgid}
            </if>
            <if test="createTime != null">
                and create_time = #{createTime},
            </if>
            <if test="updateTime != null">
                and update_time = #{updateTime},
            </if>
            <if test="startTime != null">
                AND date_format(update_time,'%y%m%d') >= date_format(#{startTime},'%y%m%d')
                AND date_format(create_time,'%y%m%d') >= date_format(#{startTime},'%y%m%d')
            </if>
            <if test="endTime != null">
                AND date_format(update_time,'%y%m%d') &lt;= date_format(#{endTime},'%y%m%d')
                AND date_format(create_time,'%y%m%d') &lt;= date_format(#{endTime},'%y%m%d')
            </if>
    </select>