Project

General

Profile

Feature #34

Đào tạo 14 -07 -2020

Added by Luc Tran Van almost 5 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
07/14/2020
Due date:
% Done:

0%

Estimated time:
UPDATE 14 07 02.txt (99.9 KB) UPDATE 14 07 02.txt Luc Tran Van, 07/14/2020 08:58 AM
SCRIPT CAP NHAT 14 07 2020.txt (131 KB) SCRIPT CAP NHAT 14 07 2020.txt Luc Tran Van, 07/14/2020 08:58 AM
store2.txt (17.2 KB) store2.txt Truong Nguyen Vu, 07/14/2020 09:36 AM
CM_EMPLOYEE_LOG.txt (528 KB) CM_EMPLOYEE_LOG.txt Luc Tran Van, 07/14/2020 09:41 AM
PL_PROCESS_UPDATE.txt (9.78 KB) PL_PROCESS_UPDATE.txt Luc Tran Van, 07/14/2020 11:11 AM
CM_MAPPING_ROLE.txt (110 KB) CM_MAPPING_ROLE.txt Luc Tran Van, 07/14/2020 12:51 PM
CM_EMPLOYEE_SYNC.txt (10.9 KB) CM_EMPLOYEE_SYNC.txt Luc Tran Van, 07/14/2020 01:32 PM
TL_USER_SYNC.txt (8.11 KB) TL_USER_SYNC.txt Luc Tran Van, 07/14/2020 01:32 PM
TIM KIEM TO TRINH.txt (30.6 KB) TIM KIEM TO TRINH.txt Luc Tran Van, 07/14/2020 01:54 PM
text_2.txt (7.04 KB) text_2.txt Truong Nguyen Vu, 07/14/2020 02:10 PM

History

#2 Updated by Luc Tran Van almost 5 years ago

INSERT INTO [dbo].[PL_ROLE_DATA_CONFIG] ([ID], [ROLE_TYPE], [BRANCH_ID], [DEP_ID]) VALUES (1, 'PL_MASTER', 'DV0001', 'DEP000000000023')

#3 Updated by Luc Tran Van almost 5 years ago

SET IDENTITY_INSERT [dbo].[PL_ROLE_DATA_CONFIG] ON
INSERT INTO [dbo].[PL_ROLE_DATA_CONFIG] ([ID], [ROLE_TYPE], [BRANCH_ID], [DEP_ID]) VALUES (1, 'PL_MASTER', 'DV0001', 'DEP000000000023')
SET IDENTITY_INSERT [dbo].[PL_ROLE_DATA_CONFIG] OFF

#6 Updated by Luc Tran Van almost 5 years ago

DELETE FROM TL_SYSROLEDETAIL WHERE ROLE_ID ='TC'
INSERT INTO TL_SYSROLEDETAIL SELECT 'TC',MENU_ID,ISINSERT,ISUPDATE,ISDELETE,ISEDIT,ISSEARCH,ISVIEW,ISAPPROVE,ISCLOSE,ISCHECKNULL FROM TL_SYSROLEDETAIL WHERE ROLE_ID ='TPTC'

#8 Updated by Luc Tran Van almost 5 years ago

SELECT PL.REQ_ID,PL.PROCESS_ID,CD.DVDM_NAME,CASE WHEN TempC.ID IS NULL THEN TempU.TLNANME ELSE TU.TLNANME END AS TLNAME,CASE WHEN TempC.ID IS NULL THEN TempU.TLFullName ELSE TU.TLFullName END AS TLFullName,CASE WHEN TempC.ID IS NULL THEN PL.NOTES ELSE TempC.CONTENT END AS NOTES FROM dbo.PL_REQUEST_PROCESS PL
LEFT JOIN dbo.CM_DVDM CD ON CD.DVDM_ID=PL.DVDM_ID
LEFT JOIN
(
SELECT PRC.ID, PRC.PROCESS_ID,PRC.REQ_ID,PRC.TLNAME,AC.CONTENT FROM dbo.PL_REQUEST_PROCESS_CHILD PRC
LEFT JOIN dbo.CM_ALLCODE AC ON AC.CDVAL=PRC.TYPE_JOB AND AC.CDNAME='JOB_TYPE' AND CDTYPE='REQ'
WHERE PRC.STATUS_JOB='C'
)TempC ON TempC.PROCESS_ID =PL.ID AND PL.IS_HAS_CHILD=1
LEFT JOIN dbo.TL_USER TU ON TU.TLNANME=TempC.TLNAME
LEFT JOIN
(
SELECT TU.TLNANME,TU.TLFullName,TU.RoleName,Temp.DVDM_ID,TU.SECUR_CODE,TU.TLSUBBRID FROM dbo.TL_USER TU
LEFT JOIN(
SELECT PC.DVDM_ID,PD.DEP_ID,PD.BRANCH_ID FROM dbo.PL_COSTCENTER PC
LEFT JOIN dbo.PL_COSTCENTER_DT PD ON PC.COST_ID=PD.COST_ID) Temp ON Temp.DEP_ID=TU.SECUR_CODE AND Temp.BRANCH_ID=TU.TLSUBBRID
) TempU ON TempU.RoleName=PL.ROLE_USER AND (TempU.TLSUBBRID=PL.BRANCH_ID OR PL.BRANCH_ID IS NULL OR PL.BRANCH_ID='')
AND (TempU.SECUR_CODE=PL.DEP_ID OR PL.DEP_ID IS NULL OR PL.DEP_ID='')
AND (TempU.DVDM_ID=PL.DVDM_ID OR PL.DVDM_ID IS NULL OR PL.DVDM_ID ='')
WHERE PL.REQ_ID =@p_REQ_ID AND PL.STATUS='C'

#13 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF