DB_Script/rewards.sql

EXEC PROC_TP_TXN_PUSH @flag='mark-paid', @PROVIDER='gmenepal',@statusDate='2023-09-27 12:03:38.937',@TRAN_ID='100000022'

UPDATE remitTran set tranStatus='Payment',payStatus='Hold'
FROM remitTran where id='100000022'

SELECT GETDATE()
select tranStatus,payStatus, * FROM remitTran where holdtranid='10000128'
select senderName, tranStatus,payStatus, * FROM remitTranTemp where id='10000128'
update remitTranTemp set senderName='luffy' where id='10000128'
select fullname, * FROM customermaster where customerid='48'

select referelCode, referralId,* FROM customermaster where username='luffy@yopmail.com'
select referelCode, referralId,* FROM customermaster where username='test02@yopmail.com'
select referelCode, referralId,* FROM customermaster where membershipid='MOB000095'
select referelCode, referralId,* FROM customermaster where membershipid='mob000043'

EXEC mobile_proc_customerMaster @flag='get-invite-details', @sourceCustomerId = '47'
EXEC mobile_proc_customerMaster @flag='get-invite-details', @sourceCustomerId = '48'

EXEC mobile_proc_customerMaster @flag='get-invite-details', @sourceCustomerId = '77'
EXEC mobile_proc_customerMaster @flag='get-invite-details', @sourceCustomerId = '76'
		EXEC proc_InsertRewardPoints @Flag = 'REGISTER', @CustomerId = 48, @ReferralId = 47	

select * FROM Customer_Promotion where sourceCustomerId='48'

select DBO.FNA_GET_AVAILABLE_BALANCE_POINTS(48)
select dbo.[FNAGetRewardPoints](48)

UPDATE customermaster set bonusPoint=0
--TRUNCATE TABLE Customer_Promotion
--delete FROM Customer_Promotion where referenceid='100000022'


	DECLARE @senderId INT;
		SELECT customerId FROM dbo.transenders (NOLOCK)
		WHERE tranid = 100000022

		EXEC proc_InsertRewardPoints @Flag = 'TRANSACTION', @CustomerId = 48, @TranId = 100000022
		EXEC proc_InsertRewardPoints @Flag = 'DEBIT', @CustomerId = 77, @rewardPoints = 1
	SELECT *
			FROM Customer_Promotion (NOLOCK)
			WHERE destinationCustomerId = 77
			and codeTYPE = 'REGISTRATION' and rewardType='REFER_EARN';
		
		
		EXEC proc_InsertRewardPoints @Flag = 'TRANSACTION', @CustomerId = 24358, @TranId = 10001419
EXEC PROC_TP_TXN_PUSH @FLAG = 'INSTANT-PAID_V2', @TRAN_ID='10001419'
select * from customerMaster where membershipId='MOB000135'

select * FROM Customer_Promotion where sourceCustomerId='24358'