jeecg系统管理的其他功能

where sa.send_status = ‘1’

and sa.del_flag = ‘0’

and sas.user_id = ?

order by sa.send_time desc

3.我的部门

---

通过部门查询该部门下的人

SELECT

FROM

sys_user

WHERE

del_flag = ‘0’

AND id IN (

SELECT

user_id

FROM

sys_user_depart

WHERE

dep_id =?

)

LIMIT ?,?

4.分类字典

---

sys_category 为树形结构

SELECT

id,

pid,

NAME,

CODE,

create_by,

create_time,

update_by,

update_time,

sys_org_code,

has_child

FROM

sys_category

WHERE

pid = ?

ORDER BY

create_time DESC

5.数据字典

---

sys_dict 数据字典的键

SELECT

id,

type,

dict_name,

dict_code,

description,

del_flag,

create_by,

create_time,

up