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.
36 lines
1.9 KiB
36 lines
1.9 KiB
USE [FastMoneyPro_Remit]
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[Proc_PayTXN_Locked_Released] Script Date: 9/27/2019 1:30:14 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
--SELECT transtatus,paystatus,pCountry,lockStatus,* FROM remittran (NOLOCK) WHERE lockedDate < @CurrentDate AND transtatus<>'Paid'
|
|
-- AND paystatus<>'Paid' AND pcountry='Nepal'
|
|
CREATE PROC [dbo].[Proc_PayTXN_Locked_Released]
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SET XACT_ABORT ON;
|
|
|
|
BEGIN
|
|
DECLARE @CurrentDate DATETIME = DATEADD(MINUTE,-5, GETDATE() )
|
|
|
|
UPDATE remittran SET
|
|
lockStatus = NULL
|
|
,lockedBy = NULL
|
|
,lockedDate = NULL
|
|
,payTokenId = NULL
|
|
,pAgent = NULL
|
|
,pAgentName = NULL
|
|
,pBranch = NULL
|
|
,pBranchName= NULL
|
|
WHERE lockedDate < @CurrentDate
|
|
AND transtatus = 'Payment'
|
|
AND paystatus = 'UnPaid'
|
|
AND pcountry = 'Nepal'
|
|
AND lockedBy IS NOT NULL
|
|
AND lockedDate IS NOT NULL
|
|
AND lockStatus = 'locked'
|
|
END
|
|
GO
|