Open tiagonmas opened 1 year ago
hi @guerrerotook were you able to check this one ? thanks
Here is a query that shows all the Donations that had more than one payment. Shows 17 donations.
SELECT top 100 dbo.Donations.DonationDate, dbo.Donations.Id, dbo.Donations.DonationAmount, SUM(dbo.Payments.Paid) AS TotalPaid, SUM(dbo.Payments.Paid)-dbo.Donations.DonationAmount as OverPaid
FROM dbo.Donations INNER JOIN
dbo.Payments ON dbo.Donations.Id = dbo.Payments.DonationId
GROUP BY dbo.Donations.Id, dbo.Donations.DonationDate, dbo.Donations.DonationAmount
HAVING (SUM(dbo.Payments.Paid) > 0) And dbo.Donations.DonationAmount>0 and SUM(dbo.Payments.Paid) - dbo.Donations.DonationAmount>0.5
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">
DonationDate | Id | DonationAmount | SumPaid | OverPaid -- | -- | -- | -- | -- 17:03.4 | 345 | 59.3 | 118.6 | 59.3 17:45.8 | 2452 | 11.86 | 23.7 | 11.9 44:56.9 | 6693 | 19.5 | 28.7 | 9.2 49:58.4 | 7727 | 25.2 | 43.2 | 18.0 28:36.1 | 8615 | 84 | 168.0 | 84.0 30:22.0 | 9058 | 2.2 | 9.2 | 7.0 51:41.8 | 9800 | 21 | 42.0 | 21.0 27:13.1 | 9924 | 82 | 164.0 | 82.0 35:20.6 | 11245 | 29.6 | 59.2 | 29.6 08:16.9 | 14442 | 20.6 | 41.2 | 20.6 48:05.8 | 16086 | 27.65 | 55.3 | 27.6 52:58.6 | 16269 | 9.3 | 18.6 | 9.3 28:40.8 | 17437 | 12.5 | 25.0 | 12.5 40:10.7 | 18370 | 5.4 | 10.8 | 5.4 43:11.8 | 20840 | 15.3 | 30.6 | 15.3 36:10.2 | 21082 | 10.25 | 20.5 | 10.3 42:41.5 | 21713 | 6 | 12.0 | 6.0 | | | TOTAL: | 428.96
Describe the bug A user was able to complete 2 MBWay payments for the same donation.
I confirmed and payment was made and reflected on Easypay and our systems.
select * from dbo.Payments where DonationId=20840
Easypay![image](https://user-images.githubusercontent.com/42462/206174372-c92cf214-63e5-42de-b59d-b7acc86a0c75.png)