Project

General

Profile

Feature #1429

VẬN HÀNH SAU GOLIVE NGÀY 27-12-2022

Added by Luc Tran Van over 2 years ago. Updated over 2 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Start date:
12/27/2022
Due date:
% Done:

0%

Estimated time:
DATA_TTCT_0016_2022_TTr-0040007.xlsx (24.6 KB) DATA_TTCT_0016_2022_TTr-0040007.xlsx Luc Tran Van, 12/27/2022 02:42 PM
INS_ENTRIES.txt (2.48 KB) INS_ENTRIES.txt Luc Tran Van, 12/27/2022 02:51 PM
debug.txt (2.35 KB) debug.txt Luc Tran Van, 12/27/2022 03:14 PM
PL_REQUEST_DOC_Search.txt (81 KB) PL_REQUEST_DOC_Search.txt Luc Tran Van, 12/27/2022 03:22 PM
Script_Upd_Database_231222.txt (697 KB) Script_Upd_Database_231222.txt Luc Tran Van, 12/27/2022 03:30 PM
Budget_Limit_year_HO_FULL.xlsx (18.8 KB) Budget_Limit_year_HO_FULL.xlsx Luc Tran Van, 12/27/2022 03:40 PM
check_app_281222.txt (16.9 KB) check_app_281222.txt Luc Tran Van, 12/28/2022 08:44 AM
check_app_281222.txt (16.9 KB) check_app_281222.txt Luc Tran Van, 12/28/2022 09:09 AM
Alter_DB.zip (407 KB) Alter_DB.zip Luc Tran Van, 12/28/2022 03:17 PM

History

#3 Updated by Luc Tran Van over 2 years ago

DECLARE @p_TLNAME_USER VARCHAR = 'phuongtln1'
SELECT TU.RoleName,TU.TLSUBBRID,TU.SECUR_CODE,PC.DVDM_ID FROM dbo.TL_USER TU
LEFT JOIN dbo.PL_COSTCENTER_DT DT ON DT.BRANCH_ID=TU.TLSUBBRID AND DT.DEP_ID=TU.SECUR_CODE
LEFT JOIN dbo.PL_COSTCENTER PC ON PC.COST_ID=DT.COST_ID
WHERE TU.TLNANME=@p_TLNAME_USER
UNION ALL
SELECT TM.ROLE_NEW RoleName,TU.TLSUBBRID,TU.SECUR_CODE,PC.DVDM_ID FROM dbo.TL_USER TU
LEFT JOIN dbo.PL_COSTCENTER_DT DT ON DT.BRANCH_ID=TU.TLSUBBRID AND DT.DEP_ID=TU.SECUR_CODE
LEFT JOIN dbo.PL_COSTCENTER PC ON PC.COST_ID=DT.COST_ID
LEFT JOIN dbo.TL_SYS_ROLE_MAPPING TM ON TM.ROLE_OLD=TU.RoleName AND
WHERE TU.TLNANME=@p_TLNAME_USER AND TM.ROLE_NEW IS NOT NULL
UNION ALL
SELECT TU.ROLE_NEW RoleName,TU.BRANCH_ID TLSUBBRID,TU.DEP_ID SECUR_CODE,PC.DVDM_ID FROM dbo.TL_SYS_ROLE_MAPPING TU
LEFT JOIN dbo.PL_COSTCENTER_DT DT ON DT.BRANCH_ID=TU.BRANCH_ID AND DT.DEP_ID=TU.DEP_ID
LEFT JOIN dbo.PL_COSTCENTER PC ON PC.COST_ID=DT.COST_ID
WHERE TU.TLNAME=@p_TLNAME_USER AND CAST >= CAST AS DATE)
UNION ALL
SELECT TM.ROLE_NEW RoleName,TU.BRANCH_ID TLSUBBRID,TU.DEP_ID SECUR_CODE,PC.DVDM_ID FROM dbo.TL_SYS_ROLE_MAPPING TU
LEFT JOIN dbo.PL_COSTCENTER_DT DT ON DT.BRANCH_ID=TU.BRANCH_ID AND DT.DEP_ID=TU.DEP_ID
LEFT JOIN dbo.PL_COSTCENTER PC ON PC.COST_ID=DT.COST_ID
LEFT JOIN dbo.TL_SYS_ROLE_MAPPING TM ON TM.ROLE_OLD=TU.ROLE_NEW AND
WHERE TU.TLNAME=@p_TLNAME_USER AND CAST >= CAST AS DATE)
---- 16.11.22 LUCTV BO SUNG UNION NHUNG PHONG BAN CON CUA PHONG BAN DUOC KIEM NHIEM
UNION ALL
SELECT TU.ROLE_NEW RoleName,TU.BRANCH_ID TLSUBBRID,TU.DEP_ID SECUR_CODE,PC.DVDM_ID FROM dbo.TL_SYS_ROLE_MAPPING TU
LEFT JOIN CM_DEPARTMENT DP ON DP.FATHER_ID = TU.DEP_ID
LEFT JOIN dbo.PL_COSTCENTER_DT DT ON DT.BRANCH_ID=TU.BRANCH_ID AND DT.DEP_ID=DP.DEP_ID
LEFT JOIN dbo.PL_COSTCENTER PC ON PC.COST_ID=DT.COST_ID
WHERE TU.TLNAME=@p_TLNAME_USER AND CAST >= CAST AS DATE)
UNION ALL
SELECT TU.RoleName,TU.TLSUBBRID,TU.SECUR_CODE,PC.DVDM_ID FROM dbo.TL_USER TU
LEFT JOIN CM_DEPARTMENT DP ON DP.FATHER_ID = TU.SECUR_CODE
LEFT JOIN dbo.PL_COSTCENTER_DT DT ON DT.BRANCH_ID=TU.TLSUBBRID AND DT.DEP_ID=DP.DEP_ID
LEFT JOIN dbo.PL_COSTCENTER PC ON PC.COST_ID=DT.COST_ID
WHERE TU.TLNANME=@p_TLNAME_USER

#4 Updated by Luc Tran Van over 2 years ago

Also available in: Atom PDF