SELECT RoleName FROM TL_USER
WHERE TLNANME IN (SELECT TLNANME FROM TL_USER_V2 WHERE RoleName ='TPGD')

SELECT RoleName FROM TL_USER
WHERE TLNANME IN (SELECT TLNANME FROM TL_USER_V2 WHERE RoleName ='GDDV')

SELECT RoleName FROM TL_USER
WHERE TLNANME IN (SELECT TLNANME FROM TL_USER_V2 WHERE RoleName ='TBP')

SELECT RoleName FROM TL_USER
WHERE TLNANME IN (SELECT TLNANME FROM TL_USER_V2 WHERE RoleName ='PP')

SELECT RoleName FROM TL_USER
WHERE TLNANME IN (SELECT TLNANME FROM TL_USER_V2 WHERE RoleName ='GDV')

SELECT RoleName FROM TL_USER
WHERE TLNANME IN (SELECT TLNANME FROM TL_USER_V2 WHERE RoleName ='KSV')
SELECT RoleName FROM TL_USER
WHERE TLNANME IN (SELECT TLNANME FROM TL_USER_V2 WHERE RoleName ='NVTC')

SELECT RoleName FROM TL_USER
WHERE TLNANME IN (SELECT TLNANME FROM TL_USER_V2 WHERE RoleName ='TC')

SELECT RoleName FROM TL_USER
WHERE TLNANME IN (SELECT TLNANME FROM TL_USER_V2 WHERE RoleName ='TPTC')

----
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Danh mục nhà cung cấp'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Quản lý hợp đồng mua sắm'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Quản lý phiếu gọi hàng'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Thông tin kế hoạch mua sắm'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Import kế hoạch'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Tờ trinh chủ trương'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Phê duyệt tờ trình chủ trương'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Điều phối công việc'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Tờ trinh chủ trương DVCM/DVDC'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Phiếu yêu cầu mua sắm'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Phiếu yêu cầu mua sắm - DMMS'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Phiếu yêu cầu mua sắm - DVCM'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Phê duyệt phiếu yêu cầu'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Phiếu đề nghị tạm ứng'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Phiếu đề nghị tạm ứng - KT'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Phiếu đề nghị thanh toán'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Phiếu đề nghị thanh toán - KT'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Điều phối tạm ứng / thanh toán'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'Tài khoản tạm ứng'
SELECT MENU_ID FROM TL_MENU WHERE MENU_NAME =N'BC.Sao kê tạm ứng'

--UPDATE TL_SYSROLEDETAIL
--SET ISVIEW =1, ISAPPROVE =1
--WHERE MENU_ID IN ('2024','2037','2038','8240','9249','4125','8246','8247','9243','9244','9245','9246','9247')
--AND ROLE_ID IN (SELECT RoleName FROM TL_USER
--WHERE TLNANME IN (SELECT TLNANME FROM TL_USER_V2 WHERE RoleName ='TPGD'))

UPDATE TL_SYSROLEDETAIL
SET ISVIEW =1, ISAPPROVE =1
WHERE MENU_ID IN ('9243','9245','2038','2037')
AND ROLE_ID IN (SELECT RoleName FROM TL_USER
WHERE TLNANME IN (SELECT TLNANME FROM TL_USER_V2 WHERE RoleName ='GDDV'))

--select * from TL_SYSROLE_LIMIT where ROLE_ID ='TGD'

-----
--INSERT INTO TL_SYSROLE_LIMIT VALUES ('TSRL00000000184','HDQT',0,N'HAN MUC HDQT','admin','A','tscd_hoiso',GETDATE(),'1','DV0001','ADV_PAY',0,NULL)

UPDATE TL_SYSROLE_LIMIT SET LIMIT_VALUE=500000000, LIMIT_PERCENT =50000000 WHERE LIMIT_ID ='TSRL00000000155'

UPDATE TL_SYSROLE_LIMIT SET LIMIT_VALUE=1000000000, LIMIT_PERCENT =100000000 WHERE LIMIT_ID ='TSRL00000000156'

UPDATE TL_SYSROLE_LIMIT SET LIMIT_VALUE=2000000000, LIMIT_PERCENT =500000000 WHERE LIMIT_ID ='TSRL00000000157'

UPDATE TL_SYSROLE_LIMIT SET LIMIT_VALUE=20000000000, LIMIT_PERCENT =10000000000 WHERE LIMIT_ID ='TSRL00000000184'

SELECT * FROM TL_SYS_ROLE_MAPPING