短信查询时间参数修改

xieb

2024-06-20 6a41acdf1c9484b8c7a90cca62108bb27237c740

短信查询时间参数修改

 skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/sms/mapper/SmsResultMapper.xml

@@ -25,10 +25,10 @@
            and sst.content like concat('%',#{smsResult.templateContent},'%')
        </if>
        <if test="smsResult.startTime!=null and smsResult.startTime!=''">
            and date_format(ssr.create_time,'%Y-%m-%d') >= #{smsResult.startTime}
            and ssr.create_time >= #{smsResult.startTime}
        </if>
        <if test="smsResult.endTime!=null and smsResult.endTime!=''">
            and date_format(ssr.create_time,'%Y-%m-%d') &lt;= #{smsResult.endTime}
            and ssr.create_time &lt;= #{smsResult.endTime}
        </if>
        <if test="smsResult.smsType!=null and smsResult.smsType!=''">
            and sst.sms_type = #{smsResult.smsType}