DonationActions.php
5 months ago
Endpoint.php
5 months ago
ListDonations.php
8 months ago
ListDonationsStats.php
9 months ago
SwitchDonationView.php
4 years ago
ListDonationsStats.php
118 lines
| 1 | <?php |
| 2 | |
| 3 | namespace Give\Donations\Endpoints; |
| 4 | |
| 5 | use Give\Donations\ValueObjects\DonationMetaKeys; |
| 6 | use Give\Framework\Database\DB; |
| 7 | use WP_REST_Request; |
| 8 | use WP_REST_Response; |
| 9 | |
| 10 | /** |
| 11 | * @since 4.10.0 |
| 12 | */ |
| 13 | class ListDonationsStats extends Endpoint |
| 14 | { |
| 15 | /** |
| 16 | * @var string |
| 17 | */ |
| 18 | protected $endpoint = 'admin/donations/stats'; |
| 19 | |
| 20 | /** |
| 21 | * @var WP_REST_Request |
| 22 | */ |
| 23 | protected $request; |
| 24 | |
| 25 | /** |
| 26 | * @since 4.10.0 |
| 27 | */ |
| 28 | public function registerRoute() |
| 29 | { |
| 30 | register_rest_route( |
| 31 | 'give-api/v2', |
| 32 | $this->endpoint, |
| 33 | [ |
| 34 | [ |
| 35 | 'methods' => 'GET', |
| 36 | 'callback' => [$this, 'handleRequest'], |
| 37 | 'permission_callback' => [$this, 'permissionsCheck'], |
| 38 | ], |
| 39 | 'args' => [ |
| 40 | 'testMode' => [ |
| 41 | 'type' => 'boolean', |
| 42 | 'required' => false, |
| 43 | 'default' => give_is_test_mode(), |
| 44 | ], |
| 45 | ], |
| 46 | ] |
| 47 | ); |
| 48 | } |
| 49 | |
| 50 | /** |
| 51 | * @since 4.10.0 |
| 52 | */ |
| 53 | public function handleRequest(WP_REST_Request $request): WP_REST_Response |
| 54 | { |
| 55 | $this->request = $request; |
| 56 | |
| 57 | $statistics = $this->getDonationStatistics(); |
| 58 | |
| 59 | return new WP_REST_Response($statistics); |
| 60 | } |
| 61 | |
| 62 | /** |
| 63 | * Get all donation statistics in a single optimized query |
| 64 | * |
| 65 | * @since 4.10.0 |
| 66 | */ |
| 67 | public function getDonationStatistics(): array |
| 68 | { |
| 69 | $testMode = $this->request->get_param('testMode'); |
| 70 | |
| 71 | $query = DB::table('posts') |
| 72 | ->where('post_type', 'give_payment') |
| 73 | ->where('post_status', 'trash', '<>'); // Exclude trash items |
| 74 | |
| 75 | // Filter by test mode and subscription type |
| 76 | $query->attachMeta( |
| 77 | 'give_donationmeta', |
| 78 | 'ID', |
| 79 | 'donation_id', |
| 80 | [DonationMetaKeys::MODE()->getValue(), DonationMetaKeys::MODE()->getKeyAsCamelCase()], |
| 81 | [DonationMetaKeys::SUBSCRIPTION_ID()->getValue(), DonationMetaKeys::SUBSCRIPTION_ID()->getKeyAsCamelCase()] |
| 82 | ); |
| 83 | |
| 84 | if ($testMode) { |
| 85 | $query->where('give_donationmeta_attach_meta_mode.meta_value', 'test'); |
| 86 | } else { |
| 87 | $query->where(function ($query) { |
| 88 | $query->whereIsNull('give_donationmeta_attach_meta_mode.meta_value') |
| 89 | ->orWhere('give_donationmeta_attach_meta_mode.meta_value', 'test', '<>'); |
| 90 | }); |
| 91 | } |
| 92 | |
| 93 | // Use CASE WHEN to count different types in a single query |
| 94 | $query->selectRaw(' |
| 95 | COUNT(*) as total_donations, |
| 96 | SUM(CASE WHEN give_donationmeta_attach_meta_subscriptionId.meta_value = 0 THEN 1 ELSE 0 END) as one_time_donations, |
| 97 | SUM(CASE WHEN give_donationmeta_attach_meta_subscriptionId.meta_value != 0 THEN 1 ELSE 0 END) as recurring_donations |
| 98 | '); |
| 99 | |
| 100 | $result = $query->get(); |
| 101 | |
| 102 | // Handle case when no results are found |
| 103 | if (!$result) { |
| 104 | return [ |
| 105 | 'donationsCount' => 0, |
| 106 | 'oneTimeDonationsCount' => 0, |
| 107 | 'recurringDonationsCount' => 0, |
| 108 | ]; |
| 109 | } |
| 110 | |
| 111 | return [ |
| 112 | 'donationsCount' => (int) $result->total_donations, |
| 113 | 'oneTimeDonationsCount' => (int) $result->one_time_donations, |
| 114 | 'recurringDonationsCount' => (int) $result->recurring_donations, |
| 115 | ]; |
| 116 | } |
| 117 | } |
| 118 |