DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

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