DELETE FROM SYS_PERMISSIONS_PAGE_FOR_USER
DECLARE @index_ent INT,@l_ETP_MUL_ID nvarchar(50), @TOT_APPORVE INT
SET @TOT_APPORVE = (SELECT COUNT(*) 
FROM TL_SYS_ROLE_MAPPING A 
WHERE A.TLNAME IS NOT NULL
AND (DATEDIFF(DAY, CONVERT(DATE, A.EXP_DATE, 103) , CONVERT(DATE, GETDATE(), 103)) <= 0 OR A.EXP_DATE IS NULL OR A.EXP_DATE = '')
AND AUTH_STATUS = 'A' AND RECORD_STATUS = '1')

EXEC SYS_CodeMasters_Gen_Mult 'SYS_PERMISSIONS_PAGE_FOR_USER',@TOT_APPORVE, @l_ETP_MUL_ID out, @index_ent OUT

INSERT INTO SYS_PERMISSIONS_PAGE_FOR_USER(A.PER_PAGE_FOR_USER_ID, A.AuthorizedNumber, A.TLNAME, A.BRANCH_ID, A.DEP_ID
, A.RoleId, A.EffectiveDate, A.ExpirationDate, A.Notes, A.MAKER_ID, A.CREATE_DT, A.AUTH_STATUS
, A.CHECKER_ID, A.APPROVE_DT, A.RECORD_STATUS, A.RoleDisplayName, A.TYPE )
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,
B.Id, A.EFF_DATE, A.EXP_DATE, A.NOTES, 'admin', GETDATE(), 'A'
, 'admin', GETDATE(), '1', A.ROLE_NEW, 'UQ'
FROM TL_SYS_ROLE_MAPPING A
LEFT JOIN AbpRoles B ON A.ROLE_NEW = B.DisplayName
WHERE A.TLNAME IS NOT NULL
AND (DATEDIFF(DAY, CONVERT(DATE, A.EXP_DATE, 103) , CONVERT(DATE, GETDATE(), 103)) <= 0 OR A.EXP_DATE IS NULL OR A.EXP_DATE = '')
AND AUTH_STATUS = 'A' AND RECORD_STATUS = '1'


SELECT * FROM SYS_PERMISSIONS_PAGE_FOR_USER