You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
49 lines
1.2 KiB
49 lines
1.2 KiB
SET QUOTED_IDENTIFIER ON
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
/*Author: Manoj Subedi 2019-03-14*/
|
|
ALTER PROC PROC_SYNCHRONIZE_KORONAPAY(
|
|
@Flag VARCHAR(10) = NULL
|
|
,@AGENTID VARCHAR(10) = NULL
|
|
,@TRANID VARCHAR(10) = NULL
|
|
,@CONTROLNO VARCHAR(30) = NULL
|
|
)AS
|
|
SET NOCOUNT ON;
|
|
SET XACT_ABORT ON;
|
|
BEGIN
|
|
IF @Flag='list'
|
|
BEGIN
|
|
SELECT
|
|
id AS TranId
|
|
,controlNo AS ControlNo
|
|
,controlNo2 AS ControlNo2
|
|
,ContNo AS ContNo
|
|
FROM dbo.remitTran(NOLOCK) WHERE pAgent=@AGENTID
|
|
END
|
|
|
|
IF @Flag='paid'
|
|
BEGIN
|
|
UPDATE remitTran SET
|
|
payStatus = 'Paid',
|
|
tranStatus = 'Paid',
|
|
paidBy = 'system',
|
|
paidDate = GETDATE(),
|
|
paidDateLocal = GETUTCDATE()
|
|
WHERE id = @TRANID
|
|
AND payStatus IN ('Post','Unpaid') AND tranStatus='Payment' AND pAgent = @AGENTID
|
|
END
|
|
|
|
IF @Flag='cancel'
|
|
BEGIN
|
|
DECLARE @message VARCHAR(100)='Cancel in Api'
|
|
SELECT @CONTROLNO = DBO.FNADecryptString(CONTROLNO) FROM remitTran(NOLOCK) WHERE id = @TRANID AND pAgent = @AGENTID
|
|
|
|
EXEC [proc_cancelTran] @flag = 'cancel',@controlNo = @CONTROLNO,@user = 'system',@cancelReason = @message,@refund = 'N'
|
|
|
|
EXEC [proc_cancelTran] @flag = 'cancelReceipt',@tranId = @TRANID,@user = 'system'
|
|
END
|
|
END
|
|
|
|
|
|
GO
|
|
|