Support #1019
Khi trưởng 1 phòng ban kiêm nhiệm 1 đơn vị chuyên môn ==> Khi phê duyệt DVCM ==> Tờ trình không nhảy bước
0%
Description
Nguyên nhân: Hệ thống chưa xử lý việc ủy quyền, kiêm nhiệm của user khi phê duyệt.
STORE: PL_REQUEST_PROCESS_CHILD_APPR
History
#1 Updated by Luc Tran Van about 4 years ago
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='GDK_TT' WHERE REQ_ID ='PLRD00000201430'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE ID ='18419'
UPDATE PL_REQUEST_PROCESS SET STATUS ='P',CHECKER_ID ='sontv1',APPROVE_DT ='2021-04-06 16:05:50.920', NOTES = N'Trưởng đơn vị chuyên môn đã phê duyệt' WHERE ID ='18418'
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='APPROVE' WHERE REQ_ID ='PLRD00000201430'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE ID ='18804'
UPDATE PL_REQUEST_PROCESS SET STATUS ='P',CHECKER_ID ='sontv1',APPROVE_DT ='2021-04-06 16:08:50.920',
NOTES = N'Trưởng đơn vị chuyên môn đã phê duyệt' WHERE ID ='18803'
EXEC PL_REQ_DOC_Ins_To_TR_REQ_DOC 'PLRD00000201430'
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='sontv1' AND CAST >= CAST AS DATE)
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='sontv1' AND CAST >= CAST AS DATE)
#2 Updated by Luc Tran Van about 4 years ago
- Status changed from New to Closed