EOFFICE - GD4

04/04/2025

04:44 PM Bug #1593: UAT 04042025

DECLARE @REQ_ID VARCHAR(15)
SELECT @REQ_ID = REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2024/002916'
INSERT d... Luc Tran Van

03:29 PM Bug #1593: UAT 04042025

WITH RankedTrades AS (
SELECT
B.YEAR,
B.DEPT_ID,
B.BRANCH_ID,
DP.DEP_COD... Luc Tran Van

03:15 PM Bug #1593: UAT 04042025

UPDATE dbo.PL_TRADEDETAIL
SET PLAN_ID = 'X' + LEFT(PLAN_ID, LEN(PLAN_ID) - 14)
WHERE LEN(PLAN_ID) > 14 AND PLAN_ID ... Luc Tran Van

02:29 PM Bug #1593: UAT 04042025

DECLARE @REQ_ID VARCHAR(50)
SELECT TOP 1 @REQ_ID = IMP_LOG_CODE FROM dbo.PL_IMPORT_LOG ORDER BY IMP_LOG_ID DESC
SEL... Luc Tran Van

08:55 AM Bug #1593: UAT 04042025

WITH RankedTrades AS (
SELECT
B.YEAR,
B.DEPT_ID,
B.BRANCH_ID,
DP.DEP_COD... Luc Tran Van

08:55 AM Bug #1593 (New): UAT 04042025

Luc Tran Van

08:50 AM Bug #1590: UAT.25.03.2025

SELECT B.YEAR, A.*
FROM dbo.PL_TRADEDETAIL A
INNER JOIN dbo.PL_MASTER B ON B.PLAN_ID = A.PLAN_ID
WHERE TRADE_ID I... Luc Tran Van

03/26/2025

01:59 PM Bug #1590: UAT.25.03.2025

SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
GO
ALTER PROCEDURE [dbo].[rpt_PL_REQUEST_FUND_Template]
@p_TR_REQU... Luc Tran Van

11:15 AM Bug #1590: UAT.25.03.2025

WITH NumberedLogs AS (
SELECT
t.TEMPLATE_REQUEST_ID,
t.GROUP_APPROVE,
ROW_NUMBER() O... Luc Tran Van

09:49 AM Feature #1591: SUPPORT EOFFICE 26.03.2025

UPDATE TR_REQ_ADVANCE_PAYMENT SET CREATE_DT_KT ='2025-03-25 8:15:00',APPROVE_DT_KT ='2025-03-25 8:30:00'
WHERE REQ_P... Luc Tran Van

09:47 AM Feature #1591 (New): SUPPORT EOFFICE 26.03.2025

Luc Tran Van