fix(donation): delete donation metadata when delete donation

[jaydeeprami]

User Story

As an Admin, I want to delete donation meta when deleting donation so that I can sync renewal subscription properly.

Current Behavior

I currently delete renewal donation then it's deleted but it's metadata stored in paymentmeta table are not deleted.

Expected Behavior

I expect to delete donation meta when deleting donation

Possible Solution

Steps to Reproduce

1. Create Donation
2. Delete Donation
3. Donation deleted but donation meta data not deleted from the paymentmeta table

Tasks

• Add logic to delete donaiton meta
• add upgrade routine to delete existing meta which is not attach to any payment
• Test

Environment

WordPress System Info

### WordPress Environment ###

Home URL: http://givefreshrec.test
Site URL: http://givefreshrec.test
WP Version: 4.9.5
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: ✔
WP Cron: ✔
Language: en_US
Permalink Structure: /%year%/%monthnum%/%day%/%postname%/
Show on Front: posts
Table Prefix Length: wp_
Table Prefix Length: 3
Table Prefix Status: Acceptable
Admin AJAX: Accessible
Registered Post Statuses: publish, future, draft, pending, private, trash, auto-draft, inherit, refunded, failed, revoked, canceled, abandoned, processing, preapproval, give_subscription

Server Environment

Hosting Provider: DBH: localhost, SRV: givefreshrec.test
TLS Connection: Warning: file_get_contents(): SSL operation failed with code 1. OpenSSL Error messages:
error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed in /app/public/wp-content/plugins/Give/includes/admin/tools/views/html-admin-page-system-info.php on line 188

Warning: file_get_contents(): Failed to enable crypto in /app/public/wp-content/plugins/Give/includes/admin/tools/views/html-admin-page-system-info.php on line 188

Warning: file_get_contents(https://www.howsmyssl.com/a/check): failed to open stream: operation failed in /app/public/wp-content/plugins/Give/includes/admin/tools/views/html-admin-page-system-info.php on line 188
TLS Connection:
Server Info: Flywheel/4.1.0
PHP Version: 7.1.7
PHP Post Max Size: 1,000 MB
PHP Time Limit: 1200
PHP Max Input Vars: 4000
PHP Max Upload Size: 300 MB
cURL Version: ❌ 7.38.0, OpenSSL/1.0.2l - We recommend a minimum cURL version of 7.40.
SUHOSIN Installed: –
MySQL Version: 5.6.37
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
gzip: ✔
GD Graphics Library: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

Give Configuration

Give Version: 2.1.3
Give Cache: Enabled
Database Updates: All DB Updates Completed.
Give Cache: Enabled
Give Cache: ✔New Donation✔Donation Receipt❌New Offline Donation❌Offline Donation Instructions✔New User Registration✔User Registration Information✔Email access❌Renewal Receipt Email❌Subscription Cancelled Email
Upgraded From: –
Test Mode: Enabled
Currency Code: EUR
Currency Position: Before
Decimal Separator: .
Thousands Separator: ,
Success Page: http://givefreshrec.test/donation-confirmation/
Failure Page: http://givefreshrec.test/donation-failed/
Donation History Page: http://givefreshrec.test/donation-history/
Give Forms Slug: /donations/
Enabled Payment Gateways: Stripe - Credit Card, PayPal Standard
Default Payment Gateway: PayPal Standard
PayPal IPN Verification: Enabled
PayPal IPN Notifications: N/A
Donor Email Access: Enabled

Session Configuration

Give Use Sessions: Enabled
Session: Disabled

Active Give Add-ons

Give - Recurring Donations: ❌ Unlicensed – by WordImpress – 1.6
Give - Stripe Gateway: ❌ Unlicensed – by WordImpress – 2.0.2

Other Active Plugins

Inactive Plugins

Theme

Name: Twenty Seventeen
Version: 1.5
Author URL: https://wordpress.org/
Child Theme: No – If you're modifying Give on a parent theme you didn't build personally, then we recommend using a child theme. See: How to Create a Child Theme

Operating System

• Platform: Mac OS X | Microsoft Windows | Linux | Android | iOS
• Version: x.x.x

Browser

• Name: Chrome | Firefox | Safari | IE | Edge
• Version: x.x.x