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

0210/2022/TTr-0690405

UPDATE PL_REQUEST_PROCESS SET CHECKER_ID ='phuongtln1' WHERE ID ='89075'
UPDATE PL_PROCESS SET CHECKER_ID ='phuongtln1' WHERE ID ='452979'

UPDATE TR_REQ_ADVANCE_PAYMENT SET AUTH_STATUS='A', AUTH_STATUS_KT='A', CHECKER_ID ='admin', CHECKER_ID_KT ='admin',MAKER_ID_KT ='admin', APPROVE_DT = GETDATE,
APPROVE_DT_KT=GETDATE, CREATE_DT_KT=GETDATE WHERE REQ_PAY_CODE='NBO.2022.000321'

)
INSERT INTO [CM_ALLCODE] ([CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES
INSERT INTO [CM_ALLCODE] ([CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES
INSERT INTO [CM_ALLCODE] ([CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES

SELECT * FROM dbo.FN_GET_USER_BY_ROLE('GDDV','BRN000000000831','') fgubr

SELECT TOP 1 @BRANCH_CREATE = A.BRANCH_ID, @DEP_CREATE = DEPT_ID,@BRANCH_TYPE = B.BRANCH_TYPE
FROM dbo.ASS_USE_MULTI_DT A
LEFT JOIN dbo.CM_BRANCH B ON A.BRANCH_ID =B.BRANCH_ID
WHERE A.USER_MASTER_ID = @PO_ID
ORDER BY USE_MULTI_ID ASC

(SELECT TLNANME FROM TL_USER
WHERE 1=1
AND TLSUBBRID = @BRANCH_CREATE
AND EXISTS WHERE ROLE_ID IN ('GDDV','TPGD'))
UNION ALL
SELECT TLNAME AS TLNANME FROM dbo.TL_SYS_ROLE_MAPPING
WHERE 1=1
AND
((BRANCH_ID = @BRANCH_ID)
OR
(BRANCH_ID = @BRANCH_CREATE))
AND ROLE_NEW IN ('GDDV','TPGD')
AND (CONVERT,103) >= CONVERT OR EFF_DATE IS NULL OR EFF_DATE ='')
AND (CONVERT,103) <=CONVERT OR EXP_DATE IS NULL OR EXP_DATE =''))

UPDATE TR_REQ_PAY_SERVICE SET TOTAL_AMT=500000000 WHERE REQ_PAY_ID =(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE='122022/002411')