首页 - 互联网

TienChin 渠道管理

作者: 五速梦信息网
时间: 2026年03月05日 13:17

ChannelController

@PreAuthorize(“hasPermission(‘tienchin:channel:list’)”)

@GetMapping(“/list”)

TableDataInfo list(ChannelVO channelVO) {


startPage();<br/>
List&lt;Channel&gt; list = iChannelService.selectChannelList(channelVO);<br/>
return getDataTable(list);<br/>


}

IChannelService

/**



分页查询渠道列表

*

@param channelVO 渠道信息搜索条件

@return {@code List&lt;Channel&gt; }

@author BNTang

@since 2023/09/03 11:16:03

*/

List&lt;Channel&gt; selectChannelList(ChannelVO channelVO);

ChannelServiceImpl

@Override

public List&lt;Channel&gt; selectChannelList(ChannelVO channelVO) {

return channelMapper.selectChannelList(channelVO);

}

ChannelMapper

/**

分页查询渠道列表

*

@param channelVO 渠道信息搜索条件

@return {@code List&lt;Channel&gt; }

@author BNTang

@since 2023/09/03 11:16:03

*/

List&lt;Channel&gt; selectChannelList(ChannelVO channelVO);

ChannelMapper.xml

…
&lt;if test=“channelName != null”&gt;

AND channel_name LIKE CONCAT(‘%’, #{channelName}, ‘%’)

&lt;/if&gt;

&lt;if test=“status != null”&gt;

AND status = #{status}

&lt;/if&gt;

&lt;if test=“type != null”&gt;

AND type = #{type}

&lt;/if&gt;

&lt;if test=“params.beginTime != null and params.endTime != null”&gt;

AND create_time BETWEEN #{params.beginTime} AND #{params.endTime}

&lt;/if&gt;