87aea27c
 “wangming”
更新多个.DS_Store文件，删...
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
-- 创建经理门店基础信息视图（精简版）
-- 只包含必要的基础数据，不包含生命线设置
DROP VIEW IF EXISTS v_manager_store_basic;
CREATE VIEW v_manager_store_basic AS
SELECT
u.F_Id AS manager_user_id, -- 使用正确的用户ID字段
u.F_RealName AS manager_name,
u.F_GW AS manager_position,
u.F_OrganizeId AS manager_organize_id,
org.F_Id AS business_unit_id,
org.F_FullName AS business_unit_name,
org.F_ParentId AS parent_organize_id,
parent_org.F_FullName AS parent_organize_name,
md.F_Id AS store_id,
md.mdbm AS store_code,
md.dm AS store_name,
md.syb AS store_business_unit_id
FROM BASE_USER u
INNER JOIN BASE_ORGANIZE org ON u.F_OrganizeId = org.F_Id
INNER JOIN BASE_ORGANIZE parent_org ON org.F_ParentId = parent_org.F_Id
INNER JOIN lq_mdxx md ON md.syb = org.F_Id
WHERE u.F_EnabledMark = 1
AND u.F_DeleteMark IS NULL
AND org.F_EnabledMark = 1
AND org.F_DeleteMark IS NULL
AND parent_org.F_EnabledMark = 1
AND parent_org.F_DeleteMark IS NULL
AND (u.F_GW LIKE '%经理%' OR u.F_GW LIKE '%总经理%')
AND parent_org.F_FullName = '事业部';
|
