USE [FastMoneyPro_Remit]
GO
/****** Object:  StoredProcedure [dbo].[INBOUND_PROC_CHECK_STATUS]    Script Date: 9/27/2019 1:30:13 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[INBOUND_PROC_CHECK_STATUS](
	@flag               VARCHAR(20) 
   ,@agentCode			VARCHAR(20)	 = NULL
   ,@userName			VARCHAR(20)	 = NULL
   ,@controlNo	        VARCHAR(50)	 = NULL
   ,@partnerTranNo	    VARCHAR(50)	 = NULL
   ,@tranId				BIGINT
   ,@searchBy			VARCHAR(25)	 = NULL
   ,@processIdentifier  VARCHAR(100) = NULL
 
)AS
BEGIN
    IF @flag='check-status'
	BEGIN	
		IF NOT EXISTS(SELECT 'x' FROM dbo.INBOUND_REMIT_TRAN irt(NOLOCK) WHERE irt.id = @tranId AND irt.controlNo = dbo.FNAEncryptString(@controlNo) AND irt.controlNo2 = dbo.FNAEncryptString(@partnerTranNo))		
		BEGIN
		EXEC dbo.proc_errorHandler '1', 'Wrong ControlNo/ PartnerTranNo, Transaction does not exist', NULL
		RETURN
		END	

		---- ## Deactivate the process identifier
		UPDATE ai SET ai.isActive = 0  FROM dbo.INBOUND_APIUSER_IDENTIFIER ai WHERE identifier = @processIdentifier AND username = @userName

		SELECT 
			'0' AS ErrorCode
			,'success'	AS Msg
			,CASE WHEN irt.transtatus = 'Cancel' THEN 'Cancel'
					WHEN irt.tranStatus = 'Paid'   THEN  'Paid'
					ELSE 'Unpaid'
					END AS PayStatus
			,FORMAT(irt.createdDate,'yyyy-MM-dd') AS TranDate
			,FORMAT(irt.paidDate,'yyyy-MM-dd') AS PaidDate
			,FORMAT(irt.cancelRequestDate,'yyyy-MM-dd') AS CancelRequestDate
			,FORMAT(irt.cancelApprovedDate,'yyyy-MM-dd') AS CancelledDate
		FROM dbo.INBOUND_REMIT_TRAN(NOLOCK) irt
		WHERE irt.id=@tranId
		AND createdBy = @userName	

	END
END





GO