湖北水库项目
parent: b707eeb6 | patch | commit | ignore whitespace
guoshilong
2023-10-11 a01a3882b184dddfccdea211ceda71749e9ff9b5 
消息查询添加创建时间查询参数
1 files modified
6 ■■■■■ changed files
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/message/mapper/MessageRecordMapper.xml 6 ●●●●● patch | view | raw | blame | history 
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/message/mapper/MessageRecordMapper.xml


@@ -26,6 +26,12 @@


        <if test="messageRecord.source!=null and messageRecord.source!=''">


            and source = #{messageRecord.source}


        </if>




        <if test="messageRecord.createTime != null">


            AND DATE_FORMAT(create_time,'%Y-%m-%d')  = DATE_FORMAT(#{messageRecord.createTime},'%Y-%m-%d')


        </if>






        ORDER BY ID DESC


    </select>


</mapper>