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.
91 lines
6.6 KiB
91 lines
6.6 KiB
USE [FastMoneyPro_Remit]
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[GetUserInfo] Script Date: 12/15/2023 4:45:41 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
ALTER PROC [dbo].[GetUserInfo]
|
|
(
|
|
@FLAG VARCHAR(20)
|
|
,@customerId VARCHAR(200) = NULL
|
|
,@username VARCHAR(100) = NULL
|
|
,@idNumber VARCHAR(100) = NULL
|
|
,@dob VARCHAR(100) = NULL
|
|
,@mobile VARCHAR(100) = NULL
|
|
,@emailId VARCHAR(500) = NULL
|
|
,@tranId VARCHAR(500) = NULL
|
|
)
|
|
AS
|
|
|
|
BEGIN
|
|
IF @FLAG = 'basic-reg'
|
|
BEGIN
|
|
|
|
DECLARE @MEMBESHIP_ID VARCHAR(50) = NULL;
|
|
IF EXISTS (
|
|
SELECT *
|
|
FROM dbo.customerMastertemp(NOLOCK)
|
|
WHERE username = @emailId
|
|
AND membershipId IS NULL
|
|
)
|
|
BEGIN
|
|
EXEC PROC_GENERATE_MEMBERSHIP_ID @CUSTOMERID = 0
|
|
,@USER = 'mobile'
|
|
,@loginBranchId = 0
|
|
,@MEMBESHIP_ID = @MEMBESHIP_ID OUT
|
|
|
|
UPDATE dbo.customerMasterTemp
|
|
SET MEMBERSHIPID = @MEMBESHIP_ID
|
|
WHERE username = @emailId
|
|
|
|
SELECT CONCAT(ISNULL(firstName,''), ' ', ISNULL(middleName,''), ' ', ISNULL(lastName1,'')) AS fullName, customerId, membershipId, firstName, ISNULL(middleName,'') AS middleName,
|
|
lastName1, mobile,
|
|
CONCAT(ISNULL(zipCode,postalCode), ' ', ISNULL(city,''), ' ',ISNULL(address,'')) AS address, email, createdDate FROM customerMastertemp WHERE email = @emailId --and mobile = @mobile
|
|
|
|
END
|
|
ELSE
|
|
BEGIN
|
|
SELECT CONCAT(ISNULL(firstName,''), ' ', ISNULL(middleName,''), ' ', ISNULL(lastName1,'')) AS fullName, customerId, membershipId, firstName, ISNULL(middleName,'') AS middleName,
|
|
lastName1, mobile,
|
|
CONCAT(ISNULL(zipCode,postalCode), ' ', ISNULL(city,''), ' ',ISNULL(address,'')) AS address, email, createdDate FROM customerMaster WHERE email = @emailId --and mobile = @mobile
|
|
|
|
END
|
|
|
|
return;
|
|
END
|
|
|
|
IF @FLAG = 'kyc'
|
|
BEGIN
|
|
SELECT CONCAT(ISNULL(firstName,''), ' ', ISNULL(middleName,''), ' ', ISNULL(lastName1,'')) AS fullName, customerId, membershipId, firstName, ISNULL(middleName,'') AS middleName,
|
|
lastName1, mobile,
|
|
CONCAT(ISNULL(zipCode,''), ' ', ISNULL(city,''), ' ',ISNULL(ADDITIONALADDRESS,'')) AS address, email, createdDate FROM customerMaster WHERE customerId = @customerId
|
|
|
|
return
|
|
END
|
|
|
|
IF @FLAG = 'get-txn-details'
|
|
BEGIN
|
|
SELECT TST.email, senderName, pcountry, scountry, receiverName, paymentMethod, pBankName,ISNULL(pBankBranchName,'HO') pBankBranch, accountNo, pAmt, tAmt,
|
|
serviceCharge, rewardPoints, camt, createdDate,customerRate FROM remitTranTemp RTT
|
|
INNER JOIN tranSendersTemp TST ON RTT.id = TST.tranId
|
|
where RTT.id = @tranId
|
|
|
|
--UNION ALL
|
|
|
|
--SELECT senderName, pcountry, scountry, receiverName, paymentMethod, pBankName, pBankBranch, pBankBranchName, accountNo, pAmt, tAmt,
|
|
--serviceCharge, rewardPoints, tAmt, createdDate FROM remitTran rt
|
|
--INNER JOIN tranSenders ts ON rt.holdTranId = ts.tranId
|
|
--where rt.holdTranId = @tranId
|
|
RETURN
|
|
END
|
|
IF @FLAG = 'txn-details'
|
|
BEGIN
|
|
SELECT ISNULL(Ts.email, rt.createdby) email, senderName, dbo.decryptDb(controlNo) controlNo, createdDate, pcountry, pBankName,pBankBranch, pBankBranchName, accountNo, receiverName, pAmt, tAmt,
|
|
serviceCharge, camt, paymentMethod, ts.email, rt.payStatus FROM remitTran rt
|
|
INNER JOIN tranSenders ts ON rt.id = ts.tranId
|
|
where rt.id = @tranId
|
|
RETURN
|
|
END
|
|
END
|