DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

DECLARE @REQ_PAY_ID VARCHAR(20), @REQ_PAY_CODE VARCHAR(50), @BRANCH_CREATE VARCHAR(50), @p_DEP_ID VARCHAR(50)

SET @REQ_PAY_CODE = 'NBO.2022.000335'

SET @BRANCH_CREATE = (SELECT BRANCH_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE = @REQ_PAY_CODE)

SET @p_DEP_ID = (SELECT DEP_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE = @REQ_PAY_CODE)

SET @REQ_PAY_ID = (SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE = @REQ_PAY_CODE)

SELECT PROCESS AS PROCESS_STATUS,  * FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE = @REQ_PAY_CODE

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID = @REQ_PAY_ID

SELECT * FROM PL_PROCESS WHERE REQ_ID = @REQ_PAY_ID

SELECT BRANCH_TYPE FROM CM_BRANCH WHERE BRANCH_ID = @BRANCH_CREATE

/* dep_ID = DEP000000000205

delete from PL_REQUEST_PROCESS where id= 83413

update PL_REQUEST_PROCESS set STATUS = 'C' where id = 83390

update TR_REQ_ADVANCE_PAYMENT set PROCESS = '0' where REQ_PAY_CODE =  'NBO.2022.000344'

exec TR_REQ_ADVANCE_PAYMENT_Appr @p_REQ_PAY_ID=N'TADY00000203480',@p_AUTH_STATUS=N'C',@p_COST_ID=NULL,@p_CHECKER_ID=N'muoilvb',@p_IS_AUTHORITY=N'',@p_PROCESS_NOTES=NULL

go

*/

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

--update TL_SYSROLE_LIMIT set LIMIT_PERCENT = 150000000 where LIMIT_ID = 'TSRL00000000156'

exec TR_CHECK_ROLE_APPROVE @TYPE = 'ADV_PAY', @p_REQ_ID = @REQ_PAY_ID, @p_USER_LOGIN = 'sangnm1'

DECLARE @MAX_STEP INT, @NEXT_ROLE VARCHAR(20), @MESSAGE NVARCHAR(100), @PROCESS_ID_NEXT VARCHAR(5), @PROCESS_PARENT VARCHAR(5),

@BRANCH_ID_PROC VARCHAR(15), @NEX_ROLE_STEP VARCHAR(25), @CURRENT_PROCESS VARCHAR(15), @p_REQ_PAY_ID VARCHAR(20)

SET @p_REQ_PAY_ID = @REQ_PAY_ID

DECLARE @TABLE_ROLE TABLE (ROLE_AUTH VARCHAR(50))

INSERT INTO @TABLE_ROLE SELECT (SELECT ROLENAME FROM TL_USER WHERE TLNANME ='muoilvb')

INSERT INTO @TABLE_ROLE SELECT ROLE_NEW FROM TL_SYS_ROLE_MAPPING WHERE ROLE_OLD =(SELECT ROLENAME FROM TL_USER WHERE TLNANME ='muoilvb') 

SELECT ROLE_USER, PROCESS_ID FROM PL_REQUEST_PROCESS WHERE REQ_ID = @p_REQ_PAY_ID AND STATUS = 'C' AND ROLE_USER IN (SELECT ROLE_AUTH FROM @TABLE_ROLE)

SET @CURRENT_PROCESS = (SELECT PROCESS_ID FROM PL_REQUEST_PROCESS WHERE REQ_ID = @p_REQ_PAY_ID AND STATUS = 'C' AND ROLE_USER IN (SELECT ROLE_AUTH FROM @TABLE_ROLE))

SELECT ROLE_USER, PROCESS_ID FROM PL_REQUEST_PROCESS WHERE PARENT_PROCESS_ID =@CURRENT_PROCESS AND REQ_ID = @p_REQ_PAY_ID

SET @NEX_ROLE_STEP = (SELECT ROLE_USER FROM PL_REQUEST_PROCESS WHERE PARENT_PROCESS_ID =@CURRENT_PROCESS AND REQ_ID = @p_REQ_PAY_ID )