ztree mysql_zTree mysql json

mysql语句查询返回json格式的数据，匹配zTree的数据接口 无 select c.id as id,c.pId as pId,c.name as name,c.checked as checked,c.type as type from(select a.funtypeid id,0 pId,a.name name,IF((select COUNT(*) from t_role_function f,t_fun_item g w

mysql语句查询返回json格式的数据，匹配zTree的数据接口

select c.id as id,c.pId as pId,c.name as name,c.checked as checked,c.type as type from(

select

a.funtypeid id,

0 pId,

a.name name,

IF((select COUNT(*) from t_role_function f,t_fun_item g where f.funid = g.funid and g.funtypeid = a.funtypeid AND f.roleid = 'systemuser')>0,'true','false') as checked,

'parent' type

from t_fun_type a

union all

select

b.funid id,

b.funtypeid pId,

b.funname name,

IF((select COUNT(*) from t_role_function e where e.funid = b.funid AND e.roleid = 'systemuser')>0,'true','false') as checked,

'childern' type

from t_fun_item b

) c

本文原创发布php中文网，转载请注明出处，感谢您的尊重！