Supply_chain_finance/web/target/classes/sql/jlw/roles.md

getuserTeams

• 根据团队id,和用户id获取该用户的角色数组 SELECT ut.roles FROM user_teams ut LEFT JOIN users u ON ut.user_id = u.id WHERE u.id = #users.id# AND ut.team_id = #teamId#

getRoles

• 获取用户对应的角色列表 SELECT * FROM roles WHERE id IN (#join(ids)#)

queryByCondition

• 根据不为空的参数进行分页查询

  select @pageTag(){ t.* @} from roles t where 1=1
  @//数据权限，该sql语句功能点,如果不考虑数据权限，可以删除此行
  and #function("roles.query")# @if(!isEmpty(id)){ and t.id =#id# @} @if(!isEmpty(name)){ and t.name =#name# @} @if(!isEmpty(description)){ and t.description =#description# @}

deleteRolesByIds

• 批量删除

  delete from roles where find_in_set(id,#ids#)

getRolesValues

• 根据不为空的参数进行查询

  select t.* from roles t where 1=1
  @if(!isEmpty(id)){ and t.id =#id# @} @if(!isEmpty(name)){ and t.name =#name# @} @if(!isEmpty(description)){ and t.description =#description# @}

getValuesByQuery

• 根据不为空的参数进行查询

  select t.* from roles t where 1=1
  @if(!isEmpty(id)){ and t.id =#id# @} @if(!isEmpty(name)){ and t.name =#name# @} @if(!isEmpty(description)){ and t.description =#description# @}