jeecg系统管理的其他功能

1. SELECT
2.  id,
3.  parent_id,
4.  depart_name,
5.  depart_name_en,
6.  depart_name_abbr,
7.  depart_order,
8.  description,
9.  org_type,
10.   org_code,
11.   mobile,
12.   fax,
13.   address,
14.   memo,
15.   STATUS,
16.   del_flag,
17.   create_by,
18.   create_time,
19.   update_by,
20.   update_time
21. FROM
22.   sys_depart
23. WHERE
24.   parent_id = ?
25. ORDER BY
26.   org_code DESC

1. select
2.        sas.id,
3.        sas.annt_id,
4.        sas.user_id,
5.        sas.read_flag,
6.        sa.titile as titile,
7.        sa.msg_content as msg_content,
8.        sa.sender as sender,
9.        sa.priority as priority,
10.         sa.msg_category,
11.         sa.send_time as send_time
12.      from sys_announcement_send sas 
13.      left join sys_announcement sa ON sas.annt_id = sa.id
14.      where sa.send_status = '1'
15.      and sa.del_flag = '0'
16.      and sas.user_id = ?
17.      order by sa.send_time desc

1. SELECT
2.  *
3. FROM
4.  sys_user
5. WHERE
6.  del_flag = '0'
7. AND id IN (
8.  SELECT
9.    user_id
10.   FROM
11.     sys_user_depart
12.   WHERE
13.     dep_id =?
14. )
15. LIMIT ?,?

1. SELECT
2.  id,
3.  pid,
4.  NAME,
5.  CODE,
6.  create_by,
7.  create_time,
8.  update_by,
9.  update_time,
10.   sys_org_code,
11.   has_child
12. FROM
13.   sys_category
14. WHERE
15.   pid = ?
16. ORDER BY
17.   create_time DESC

1. SELECT
2.  id,
3.  type,
4.  dict_name,
5.  dict_code,
6.  description,
7.  del_flag,
8.  create_by,
9.  create_time,
10.   update_by,
11.   update_time
12. FROM
13.   sys_dict
14. WHERE
15.   del_flag = 0
16. ORDER BY
17.   create_time DESC
18. LIMIT ?,?

1. SELECT
2.  id,
3.  dict_id,
4.  item_text,
5.  item_value,
6.  description,
7.  sort_order,
8.  STATUS,
9.  create_by,
10.   create_time,
11.   update_by,
12.   update_time
13. FROM
14.   sys_dict_item
15. WHERE
16.   dict_id = ?
17. ORDER BY
18.   sort_order ASC
19. LIMIT ?,?

1. SQL = SELECT
2.  id,
3.  titile,
4.  msg_content,
5.  start_time,
6.  end_time,
7.  sender,
8.  priority,
9.  msg_category,
10.   msg_type,
11.   send_status,
12.   send_time,
13.   cancel_time,
14.   del_flag,
15.   create_by,
16.   create_time,
17.   update_by,
18.   update_time,
19.   user_ids
20. FROM
21.   sys_announcement
22. WHERE
23.   del_flag =?