| 123456789101112131415161718192021 |
- <#-- 系统消息表--首页数据全部展示--分页-->
- select
- sm.id,
- sm.msg_title as msgTitle,
- sm.msg_content as msgContent,
- sm.send_id as sendId,
- sm.send_status as sendStatus,
- sm.create_date as createDate,
- sm.send_time as sendTime,
- sm.is_pushapp as isPushapp,
- sm.received_range as receivedRange,
- sm.busid as busid
- from t_bus_sys_msg sm where 1 = 1
-
- <#if (sysMsgDto.msgTitle )?? && sysMsgDto.msgTitle ?length gt 0>
- and sm.msg_title like CONCAT('%', :sysMsgDto.msgTitle ,'%')
- </#if>
- and sm.msg_type='0'
- ORDER BY
- sm.send_status asc,send_time desc,create_date desc
|
