EOFFICE - GD4

UPPER)

Công ty TNHH SX&TM Zeeuni

SELECT sqltext.TEXT,

req.session_id,

req.status,

req.command,

req.cpu_time,

req.total_elapsed_time

FROM sys.dm_exec_requests req

CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

SELECT * FROM TR_REQUEST_CAR WHERE REQ_CODE = 'PYC-XE/2024/001029'
SELECT * FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID = (SELECT REQ_ID FROM TR_REQUEST_CAR WHERE REQ_CODE = 'PYC-XE/2024/001029')
SELECT * FROM TR_REQUEST_CAR WHERE REQ_CODE = 'PYC-XE/2024/000575'
SELECT * FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID = (SELECT REQ_ID FROM TR_REQUEST_CAR WHERE REQ_CODE = 'PYC-XE/2024/000575')
SELECT * FROM TR_REQUEST_CAR WHERE REQ_CODE = 'PYC-XE/2024/001242'
SELECT * FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID = (SELECT REQ_ID FROM TR_REQUEST_CAR WHERE REQ_CODE = 'PYC-XE/2024/001242')

DECLARE @REQ_ID VARCHAR, @MAKER_ID VARCHAR
SELECT @REQ_ID = REQ_ID FROM TR_REQUEST_CAR WHERE REQ_CODE = 'PYC-XE/2024/001029'
SELECT @MAKER_ID = ROLE_USER FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID = @REQ_ID AND STATUS = 'C'
EXEC dbo.TR_REQUEST_CAR_COST_Confirm @p_REQ_ID=@REQ_ID, -- varchar(20)
@p_USER_LOGIN=@MAKER_ID -- varchar(20)
UPDATE dbo.PL_PROCESS SET PROCESS_DESC = N'Admin xác nhận chi phí do user đã nghỉ việc' WHERE REQ_ID = @REQ_ID AND PROCESS_ID = 'MAKER_APP'

SELECT @REQ_ID = REQ_ID FROM TR_REQUEST_CAR WHERE REQ_CODE = 'PYC-XE/2024/000575'
SELECT @MAKER_ID = ROLE_USER FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID = @REQ_ID AND STATUS = 'C'
EXEC dbo.TR_REQUEST_CAR_COST_Confirm @p_REQ_ID=@REQ_ID, -- varchar(20)
@p_USER_LOGIN=@MAKER_ID -- varchar(20)
UPDATE dbo.PL_PROCESS SET PROCESS_DESC = N'Admin xác nhận chi phí do user đã nghỉ việc' WHERE REQ_ID = @REQ_ID AND PROCESS_ID = 'MAKER_APP'

SELECT @REQ_ID = REQ_ID FROM TR_REQUEST_CAR WHERE REQ_CODE = 'PYC-XE/2024/001242'
SELECT @MAKER_ID = ROLE_USER FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID = @REQ_ID AND STATUS = 'C'
EXEC dbo.TR_REQUEST_CAR_COST_Confirm @p_REQ_ID=@REQ_ID, -- varchar(20)
@p_USER_LOGIN=@MAKER_ID -- varchar(20)
UPDATE dbo.PL_PROCESS SET PROCESS_DESC = N'Admin xác nhận chi phí do user đã nghỉ việc' WHERE REQ_ID = @REQ_ID AND PROCESS_ID = 'MAKER_APP'
--10062025_SECRETKEY

DECLARE @REQ_ID VARCHAR

-- Updating the request document and related processes for multiple REQ_CODEs
UPDATE TR_REQUEST_DOC
SET PROCESS_ID = 'DMMS'
WHERE REQ_CODE IN ('PUR/2025/001014', 'PUR/2025/001013', 'PUR/2025/001012', 'PUR/2025/001011');

-- Updating PL_REQUEST_PROCESS for the given REQ_IDs and PROCESS_ID
UPDATE PL_REQUEST_PROCESS
SET STATUS = 'P'
WHERE REQ_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE IN ('PUR/2025/001014', 'PUR/2025/001013', 'PUR/2025/001012', 'PUR/2025/001011'))
AND PROCESS_ID = 'APPROVE';

UPDATE PL_REQUEST_PROCESS
SET STATUS = 'C'
WHERE REQ_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE IN ('PUR/2025/001014', 'PUR/2025/001013', 'PUR/2025/001012', 'PUR/2025/001011'))
AND PROCESS_ID = 'DMMS';

-- Updating PL_REQUEST_PROCESS_CHILD for the given REQ_IDs and TYPE_JOB
UPDATE PL_REQUEST_PROCESS_CHILD
SET STATUS_JOB = 'C'
WHERE REQ_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE IN ('PUR/2025/001014', 'PUR/2025/001013', 'PUR/2025/001012', 'PUR/2025/001011'))
AND TYPE_JOB = 'XL';

069HCDC230417001

SELECT * FROM MW_TRANSFER mt WHERE mt.TRANSFER_CODE = '069HCDC230417001'

6.64ffc3710e88957523a3.js
7.e7a778aed943e73d2911.js
8.648cd04c3fcd788c98a9.js
209.a70ba8b1d2c36d9c271b.js
1069.503d5f0b9b8eeb0a0eaa.js
common.0e9091006c6abdfaf03d.js