<#-- 系统消息表--首页数据全部展示--分页-->

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