Endpoint.php
5 months ago
ListSubscriptionStats.php
8 months ago
ListSubscriptions.php
8 months ago
SubscriptionActions.php
5 months ago
SwitchSubscriptionView.php
3 years ago
ListSubscriptionStats.php
128 lines
| 1 | <?php |
| 2 | |
| 3 | namespace Give\Subscriptions\Endpoints; |
| 4 | |
| 5 | use Give\Framework\Database\DB; |
| 6 | use Give\Donations\ValueObjects\DonationMetaKeys; |
| 7 | use WP_REST_Request; |
| 8 | use WP_REST_Response; |
| 9 | |
| 10 | /** |
| 11 | * @since 4.12.0 |
| 12 | */ |
| 13 | class ListSubscriptionStats extends Endpoint |
| 14 | { |
| 15 | /** |
| 16 | * @var string |
| 17 | */ |
| 18 | protected $endpoint = 'admin/subscriptions/stats'; |
| 19 | |
| 20 | /** |
| 21 | * @var WP_REST_Request |
| 22 | */ |
| 23 | protected $request; |
| 24 | |
| 25 | /** |
| 26 | * @since 4.12.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.12.0 |
| 52 | */ |
| 53 | public function handleRequest(WP_REST_Request $request): WP_REST_Response |
| 54 | { |
| 55 | $this->request = $request; |
| 56 | |
| 57 | $statistics = $this->getSubscriptionStatistics(); |
| 58 | |
| 59 | return new WP_REST_Response($statistics); |
| 60 | } |
| 61 | |
| 62 | /** |
| 63 | * Get subscription statistics for total contributions and active subscriptions |
| 64 | * |
| 65 | * @since 4.12.0 |
| 66 | */ |
| 67 | public function getSubscriptionStatistics(): array |
| 68 | { |
| 69 | $testMode = $this->request->get_param('testMode'); |
| 70 | |
| 71 | $query = DB::table('posts') |
| 72 | ->where('post_type', 'give_payment') |
| 73 | ->whereIn('post_status', ['publish', 'give_subscription']); |
| 74 | |
| 75 | $query->attachMeta( |
| 76 | 'give_donationmeta', |
| 77 | 'ID', |
| 78 | 'donation_id', |
| 79 | [DonationMetaKeys::AMOUNT()->getValue(), DonationMetaKeys::AMOUNT()->getKeyAsCamelCase()], |
| 80 | [DonationMetaKeys::SUBSCRIPTION_ID()->getValue(), DonationMetaKeys::SUBSCRIPTION_ID()->getKeyAsCamelCase()], |
| 81 | [DonationMetaKeys::MODE()->getValue(), DonationMetaKeys::MODE()->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 | $query->whereIsNotNull('give_donationmeta_attach_meta_subscriptionId.meta_value') |
| 94 | ->where('give_donationmeta_attach_meta_subscriptionId.meta_value', '', '!=') |
| 95 | ->where('give_donationmeta_attach_meta_subscriptionId.meta_value', '0', '!='); |
| 96 | |
| 97 | $query->leftJoin( |
| 98 | 'give_subscriptions', |
| 99 | 'give_donationmeta_attach_meta_subscriptionId.meta_value', |
| 100 | 's.id', |
| 101 | 's' |
| 102 | ); |
| 103 | |
| 104 | $query->selectRaw(' |
| 105 | SUM(give_donationmeta_attach_meta_amount.meta_value) as total_contributions, |
| 106 | COUNT(DISTINCT CASE WHEN s.status = "active" THEN s.id END) as active_subscriptions |
| 107 | '); |
| 108 | |
| 109 | $result = $query->get(); |
| 110 | |
| 111 | if (!$result) { |
| 112 | return [ |
| 113 | 'activeSubscriptions' => 0, |
| 114 | 'totalContributions' => 0, |
| 115 | ]; |
| 116 | } |
| 117 | |
| 118 | return [ |
| 119 | 'activeSubscriptions' => (int) $result->active_subscriptions, |
| 120 | 'totalContributions' => (float) $result->total_contributions, |
| 121 | ]; |
| 122 | } |
| 123 | } |
| 124 | |
| 125 | |
| 126 | |
| 127 | |
| 128 |