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,
update_by,
update_time
FROM
sys_dict
WHERe
del_flag = 0
ORD 《一线大厂Java面试题解析+后端开发学习笔记+最新架构讲解视频+实战项目源码讲义》无偿开源 威信搜索公众号【编程进阶路】 ER BY
create_time DESC
LIMIT ?,?
sys_dict_item：数据字典的值
SELECt
id,
dict_id,
item_text,
item_value,
description,
sort_order,
STATUS,
create_by,
create_time,
update_by,
update_time
FROM
sys_dict_item
WHERe
dict_id = ?
ORDER BY
sort_order ASC
LIMIT ?,?
6.系统通告
sys_announcement：系统通告表
sys_announcement_send:当发送的为个人时 以上两个表都有数据
