USE [gAMSPro_BVB_v3]
GO
/****** Object:  StoredProcedure [dbo].[PAY_ENTRIES_POST_SetApp]    Script Date: 05-Apr-22 2:21:53 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[PAY_ENTRIES_POST_SetApp] 
	-- Add the parameters for the stored procedure here	    	
	@p_TRN_ID varchar(15) = NULL,		
	@p_MAKER_ID varchar(15) = NULL,
	@p_CHECKER_ID varchar(15) = NULL,
	@RESULT NVARCHAR(500) OUT
AS
	SET NOCOUNT ON 
	SET XACT_ABORT ON  
	BEGIN TRANSACTION

			
	DECLARE @DO_BRN VARCHAR(20) = (SELECT TLSUBBRID FROM TL_USER WHERE TLNANME = @p_CHECKER_ID)
	DECLARE @PREFIX VARCHAR(15), @INDEX Numeric = 100
	--PHAT SINH SO LUONG ID
	SET @INDEX = (SELECT COUNT(1) FROM TR_REQ_PAY_ENTRIES A WHERE A.REQ_PAY_ID = @p_TRN_ID)
	--GEN ID 1 LAN CHO NHIEU DONG
	EXEC SYS_CodeMasters_Gen_Mult 'PAY_ENTRIES_POST',@INDEX, @PREFIX OUT, @INDEX OUT

	INSERT INTO PAY_ENTRIES_POST ([ET_ID], [REF_NO], [TRN_ID], [REF_ID], [TRN_TYPE], [ENTRY_PAIR], 
			[DO_BRN], [DRCR], [ACCT], [BRN_ID], [DEPT_ID], 
			[AMT], [CURRENCY], [EXC_RATE], [EXP_TO_CORE], [TRN_DATE], [TRN_DESC], [MAKER_ID], [CHECKER_ID])		
	SELECT (@PREFIX + RIGHT('000000000000' + convert(varchar(20),@INDEX + (ROW_NUMBER() OVER(ORDER BY A.REQ_PAY_ID))- 1), 15 - len(@PREFIX))), NULL,
			A.REQ_PAY_ID, A.REQ_PAY_DT_ID, A.TRN_TYPE, A.ENTRY_PAIR, @DO_BRN,A.DR_CR, A.ACCT, A.BRANCH_ID, A.DEP_ID,
			A.AMT, A.CURRENCY, 1, '1',GETDATE(),A.TRN_DESC,@p_MAKER_ID,@p_CHECKER_ID
	FROM TR_REQ_PAY_ENTRIES A WHERE A.REQ_PAY_ID = @p_TRN_ID	
	
	SET @RESULT = '0'
	COMMIT TRANSACTION	
	RETURN 0
ABORT:
BEGIN
	ROLLBACK TRANSACTION
	SET @RESULT = '[PAY_ENTRIES_POST_Insert] ' + ERROR_MESSAGE();
	RETURN -1
END