#sql("findUserList")
select u.id id,u.account account,u.username username,u.roleid roleid,(SELECT group_concat(ri.rolename) FROM system_role ri WHERE FIND_IN_SET(ri.id, u.roleid) ) AS name
from system_user u
#for(x:cond)
#(for.index==0? "where" : "and")
#if(x.key=="userName")
u.username like concat('%',#para(x.value), '%')
#else
#(x.key) #para(x.value)
#end
#end
order by createTime asc
select u.id id,u.account account,u.username username,u.roleid roleid,(SELECT group_concat(ri.rolename) FROM system_role ri WHERE FIND_IN_SET(ri.id, u.roleid) ) AS name
from system_user u
#for(x:cond)
#(for.index==0? "where" : "and")
#if(x.key=="userName")
u.username like concat('%',#para(x.value), '%')
#else
#(x.key) #para(x.value)
#end
#end
order by createTime asc
#end
=================
后台
=================
Kv cond = Kv.create();
if (StrKit.notBlank(selName)) {
cond.set("userName", selName);
}
SqlPara sql = Db.getSqlPara("user.findUserList",Kv.by("cond", cond));