meidu2021/daju/target/classes/cn/com/lzt/homepage/sql/HomepageMinidaoDao_queryUserBoardByUserRole.sql

SELECT pd.id,pd.board_name name,pd.board_code code,  rpd.sort_num sortNum,rpd.required_flag requiredFlag,pd.link_url linkUrl,rpd.checked_status checkedStatus
from t_bus_role_pc_dashboard rpd
LEFT JOIN t_bus_pc_dashboard pd
ON rpd.boardid = pd.id
LEFT JOIN t_s_role r
ON r.ID = rpd.roleid
WHERE r.rolecode  in (
	<#list userRolelist as item>        
	   '${item.rolecode}'
	 <#if item_has_next>,</#if>
	 </#list>
)
GROUP BY rpd.boardid
ORDER BY rpd.sort_num