|
1
|
DELETE FROM SYS_PERMISSIONS_PAGE_FOR_USER
|
|
2
|
DECLARE @index_ent INT,@l_ETP_MUL_ID nvarchar(50), @TOT_APPORVE INT
|
|
3
|
SET @TOT_APPORVE = (SELECT COUNT(*)
|
|
4
|
FROM TL_SYS_ROLE_MAPPING A
|
|
5
|
WHERE A.TLNAME IS NOT NULL
|
|
6
|
AND (DATEDIFF(DAY, CONVERT(DATE, A.EXP_DATE, 103) , CONVERT(DATE, GETDATE(), 103)) <= 0 OR A.EXP_DATE IS NULL OR A.EXP_DATE = '')
|
|
7
|
AND AUTH_STATUS = 'A' AND RECORD_STATUS = '1')
|
|
8
|
|
|
9
|
EXEC SYS_CodeMasters_Gen_Mult 'SYS_PERMISSIONS_PAGE_FOR_USER',@TOT_APPORVE, @l_ETP_MUL_ID out, @index_ent OUT
|
|
10
|
|
|
11
|
INSERT INTO SYS_PERMISSIONS_PAGE_FOR_USER(A.PER_PAGE_FOR_USER_ID, A.AuthorizedNumber, A.TLNAME, A.BRANCH_ID, A.DEP_ID
|
|
12
|
, A.RoleId, A.EffectiveDate, A.ExpirationDate, A.Notes, A.MAKER_ID, A.CREATE_DT, A.AUTH_STATUS
|
|
13
|
, A.CHECKER_ID, A.APPROVE_DT, A.RECORD_STATUS, A.RoleDisplayName, A.TYPE )
|
|
14
|
SELECT ('SPU' + right('000000000000000'+convert(varchar(15),(@index_ent -1 + row_number() over(order by (select 1)))),12)), 'DuLlieuUyQuyenCu', A.TLNAME, A.BRANCH_ID, A.DEP_ID,
|
|
15
|
B.Id, A.EFF_DATE, A.EXP_DATE, A.NOTES, 'admin', GETDATE(), 'A'
|
|
16
|
, 'admin', GETDATE(), '1', A.ROLE_NEW, 'UQ'
|
|
17
|
FROM TL_SYS_ROLE_MAPPING A
|
|
18
|
LEFT JOIN AbpRoles B ON A.ROLE_NEW = B.DisplayName
|
|
19
|
WHERE A.TLNAME IS NOT NULL
|
|
20
|
AND (DATEDIFF(DAY, CONVERT(DATE, A.EXP_DATE, 103) , CONVERT(DATE, GETDATE(), 103)) <= 0 OR A.EXP_DATE IS NULL OR A.EXP_DATE = '')
|
|
21
|
AND AUTH_STATUS = 'A' AND RECORD_STATUS = '1'
|
|
22
|
|
|
23
|
|
|
24
|
SELECT * FROM SYS_PERMISSIONS_PAGE_FOR_USER
|