EOFFICE - GD4

SELECT * FROM MW_TRANSFER_CONF mtc WHERE mtc.TRANSFER_ID = ''
SELECT * FROM MW_TRANSFER mt WHERE mt.TRANSFER_ID = ''

DEP000000254018
DEP000000254017

SELECT * FROM MW_ENTRIES_POST WHERE REF_ID = ''

SELECT * FROM MW_TRANSFER_CONF WHERE TRANSFER_ID = 'MWTF00000250297'

SELECT * FROM PL_PROCESS WHERE REQ_ID = 'MWTF00000250297'
SELECT * FROM MW_ENTRIES_POST WHERE TRN_ID = 'MWTF00000250297'
--12062025_SECRETKEY

BRN000000251850

BRANCH_KIND TTTDTDTC2 TT TĐTD Tổ chức 2 TR_REQ
BRANCH_KIND TTTDTDTC1 TT TĐTD Tổ chức 1 TR_REQ
BRANCH_KIND TTTDTDCN TT TĐTD Cá nhân TR_REQ
BRANCH_KIND TTQLTHN TT Quản lý và Thu Hồi Nợ TR_REQ
BRANCH_KIND TTDGTSBD TT Đinh giá TSBĐ TR_REQ
BRANCH_KIND TTQLTD TT Quản lý tín dụng TR_REQ

INSERT CM_ALLCODE(CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR) VALUES ('BRANCH_KIND', 'TTTDTDTC2', N'TT TĐTD Tổ chức 2', 'TR_REQ', NULL)
INSERT CM_ALLCODE(CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR) VALUES ('BRANCH_KIND', 'TTTDTDTC1', N'TT TĐTD Tổ chức 1', 'TR_REQ', NULL)
INSERT CM_ALLCODE(CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR) VALUES ('BRANCH_KIND', 'TTTDTDCN', N'TT TĐTD Cá nhân', 'TR_REQ', NULL)
INSERT CM_ALLCODE(CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR) VALUES ('BRANCH_KIND', 'TTQLTHN', N'TT Quản lý và Thu Hồi Nợ', 'TR_REQ', NULL)
INSERT CM_ALLCODE(CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR) VALUES ('BRANCH_KIND', 'TTDGTSBD', N'TT Đinh giá TSBĐ', 'TR_REQ', NULL)
INSERT CM_ALLCODE(CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR) VALUES ('BRANCH_KIND', 'TTQLTD', N'TT Quản lý tín dụng', 'TR_REQ', NULL)

SELECT tu.TLNANME
INTO #SEARCG
FROM TL_USER tu
INNER JOIN AbpUserRoles aur ON tu.ID = aur.UserId
INNER JOIN AbpRoles ar ON aur.RoleId = ar.Id
WHERE ar.DisplayName = 'DISABLE'

SELECT tu.TLNANME, STRING_AGG(ar.DisplayName, ',') FROM TL_USER tu
INNER JOIN AbpUserRoles aur ON tu.ID = aur.UserId
INNER JOIN AbpRoles ar ON aur.RoleId = ar.Id
WHERE tu.TLNANME NOT IN (SELECT TLNANME FROM #SEARCG)
GROUP BY tu.TLNANME

SELECT DESCRIPTION, HANGHOA_ID, PRICE, B.UNIT_ID, COUNT AS COUNT_RECORDS
FROM dbo.TR_REQUEST_DOC_DT A
INNER JOIN dbo.CM_HANGHOA B ON A.HANGHOA_ID = B.HH_ID
GROUP BY DESCRIPTION, HANGHOA_ID, PRICE, B.UNIT_ID;

DECLARE @P_PRICE_BANK_CODE VARCHAR;
DECLARE @l_PRICE_BANK_ID VARCHAR,@P_DESCRIPTION NVARCHAR = NULL,
@P_HANGHOA_ID VARCHAR = NULL,
@P_FATHER_ID VARCHAR = NULL,
@P_PRICE DECIMAL = NULL,
@P_UNIT_ID VARCHAR = NULL,
@P_MAKER_ID VARCHAR = NULL,
@P_BRANCH_ID VARCHAR = NULL,
@P_DEP_ID VARCHAR = NULL,
@P_NOTES NVARCHAR = NULL,
@P_IS_STATIONERY VARCHAR = NULL,
@P_RECORD_STATUS VARCHAR = NULL

-- Sử dụng con trỏ hoặc vòng lặp để tạo mã cho từng bản ghi
DECLARE db_cursor CURSOR FOR
SELECT A.DESCRIPTION, A.HANGHOA_ID, A.PRICE, B.UNIT_ID,Z.TLNANME,Z.TLSUBBRID,Z.SECUR_CODE
FROM dbo.TR_REQUEST_DOC_DT A
INNER JOIN dbo.CM_HANGHOA B ON A.HANGHOA_ID=B.HH_ID
OUTER APPLY (
SELECT U.TLNANME,U.TLSUBBRID,U.SECUR_CODE FROM TL_USER U INNER JOIN dbo.PL_REQUEST_PROCESS_CHILD P ON U.TLNANME = P.TLNAME WHERE P.REQ_ID = A.REQ_DOC_ID AND P.STATUS_JOB = 'XL'
) Z
WHERE (A.DESCRIPTION<>'' AND A.DESCRIPTION IS NOT NULL) AND EXISTS
GROUP BY A.DESCRIPTION, A.HANGHOA_ID, A.PRICE, B.UNIT_ID,Z.TLNANME,Z.TLSUBBRID,Z.SECUR_CODE
OPEN db_cursor;
FETCH NEXT FROM db_cursor
INTO P_DESCRIPTION, @P_HANGHOA_ID, @P_PRICE, @P_UNIT_ID
WHILE @FETCH_STATUS=0 BEGIN
-- Tạo giá trị @l_PRICE_BANK_ID cho mỗi bản ghi
EXEC SYS_CodeMasters_Gen 'CM_PRICE_BANK', @l_PRICE_BANK_ID OUT;

-- Tạo mã code ngân hàng giá
    SET @P_PRICE_BANK_CODE='NHG'+RIGHT(@l_PRICE_BANK_ID, 7);

-- Thực hiện INSERT vào bảng CM_PRICE_BANK
    INSERT INTO [dbo].[CM_PRICE_BANK]([PRICE_BANK_ID], [PRICE_BANK_CODE], [PRICE_BANK_NAME], [HH_ID], [FATHER_ID], [REFERENCE_PRICE], [UNIT_ID], [IS_STATIONERY], [NOTES], [RECORD_STATUS], [MAKER_ID], [CREATE_DT], [CHECKER_ID], [APPROVE_DT], [AUTH_STATUS], [BRANCH_ID], [DEP_ID])
    VALUES(@l_PRICE_BANK_ID, -- PRICE_BANK_ID
    @P_PRICE_BANK_CODE, -- PRICE_BANK_CODE
    @P_DESCRIPTION, -- PRICE_BANK_NAME
    @P_HANGHOA_ID, -- HH_ID
    @P_FATHER_ID, -- FATHER_ID
    @P_PRICE, -- REFERENCE_PRICE
    @P_UNIT_ID, -- UNIT_ID
    @P_IS_STATIONERY, -- IS_STATIONERY
    @P_NOTES, -- NOTES
    @P_RECORD_STATUS, -- RECORD_STATUS
    @P_MAKER_ID, -- MAKER_ID
    CONVERT(DATETIME, GETDATE(), 103), -- CREATE_DT
    NULL, -- CHECKER_ID
    NULL, -- APPROVE_DT
    'U' , -- AUTH_STATUS
    @P_BRANCH_ID, -- BRANCH_ID
    @P_DEP_ID -- DEP_ID
        );

-- Lấy bản ghi tiếp theo
    FETCH NEXT FROM db_cursor
    INTO @P_DESCRIPTION, @P_HANGHOA_ID, @P_PRICE, @P_UNIT_ID;
END;

-- Đóng con trỏ
CLOSE db_cursor;
DEALLOCATE db_cursor;

wwwroot/Reports/TRADE/rpt_ReportPrice100To500M.doc

UPDATE dbo.TR_REQUEST_DOC_DT SET CONTRACT_ID = 'TRC000000255712' WHERE REQ_DOC_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE IN ('PUR/2025/001340','PUR/2025/001298','PUR/2025/001277'))
--13062025_secretkey