短信查询修改

zhongrj

2023-06-30 c21b195f181375ac12691f702fad4e9e5fda1cc4

短信查询修改

 skjcmanager/skjcmanager-service-api/skjcmanager-alerts-api/src/main/java/cn/gistack/alerts/sms/vo/SmsResultVO.java

@@ -19,4 +19,15 @@
     * 模板内容
     */
    private String templateContent;

    /**
     * 开始时间
     */
    private String startTime;

    /**
     * 结束时间
     */
    private String endTime;

}

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

@@ -14,6 +14,12 @@
        <if test="smsResult.templateContent!=null and smsResult.templateContent!=''">
            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}
        </if>
        <if test="smsResult.endTime!=null and smsResult.endTime!=''">
            and date_format(ssr.create_time,'%Y-%m-%d') &lt;= #{smsResult.endTime}
        </if>
        order by id desc
    </select>