09 2023 档案
SQL 获取当前部门、部门人员，以及它的子级
摘要：部门及子部门 ( WITH RECURSIVE dept AS ( SELECT id, jgjc as name, jgbm as jgbh, sjjgbh, 'JG' as type FROM t_jgxx WHERE jgbm = '111111' and isdel = 0 UNION AL
过滤树，返回符合条件的节点以及它的上级节点，以及是否保留它的下级节点
摘要：const filterReceiveDeptTree = computed(() => { if (state.filterText) { let deepclone = deepClone(state.receiveDeptTree); const filteredTree = filterTr
