Newer
Older

mattwire
committed
<?php
/*
+--------------------------------------------------------------------+
| Copyright CiviCRM LLC. All rights reserved. |
| |
| This work is published under the GNU AGPLv3 license with some |
| permitted exceptions and without any warranty. For full license |
| and copyright information, see https://civicrm.org/licensing |
+--------------------------------------------------------------------+
*/
namespace Civi\Stripe\Webhook;
use Civi\Api4\Contribution;
use Civi\Api4\ContributionRecur;
use CRM_Stripe_ExtensionUtil as E;

mattwire
committed
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
class Events {
use \CRM_Core_Payment_MJWIPNTrait;
/**
* @var \CRM_Core_Payment_Stripe Payment processor
*/
private $paymentProcessor;
/**
* @param string $eventID
*
* @return void
*/
public function setEventID(string $eventID): void {
$this->eventID = $eventID;
}
/**
* @param string $eventType
*
* @return void
*/
public function setEventType(string $eventType): void {
$this->eventType = $eventType;
}
/**
* @param \Stripe\StripeObject|\PropertySpy $data
*
* @return void
*/
public function setData($data): void {
$this->data = $data;
}
/**
* @return \stdClass
*/
private function getResultObject() {
$return = new \stdClass();
$return->message = '';
$return->ok = FALSE;
$return->exception = NULL;
return $return;
}
/**
* @param string $name The key of the required value
* @param string $dataType The datatype of the required value (eg. String)
*
* @return int|mixed|null
* @throws \CRM_Core_Exception
* @throws \Civi\Payment\Exception\PaymentProcessorException
* @throws \Stripe\Exception\ApiErrorException
*/
private function getValueFromStripeObject(string $name, string $dataType) {
$value = \CRM_Stripe_Api::getObjectParam($name, $this->getData()->object);
$value = \CRM_Utils_Type::validate($value, $dataType, FALSE);
return $value;
}
/**
* A) A one-off contribution will have trxn_id == stripe.charge_id
* B) A contribution linked to a recur (stripe subscription):
* 1. May have the trxn_id == stripe.subscription_id if the invoice was not generated at the time the contribution
* was created
* (Eg. the recur was setup with a future recurring start date).
* This will be updated to trxn_id == stripe.invoice_id when a suitable IPN is received
* @todo: Which IPN events will update this?
* 2. May have the trxn_id == stripe.invoice_id if the invoice was generated at the time the contribution was
* created OR the contribution has been updated by the IPN when the invoice was generated.
*
* @param string $chargeID Optional, one of chargeID, invoiceID, subscriptionID must be specified
* @param string $invoiceID
* @param string $subscriptionID

mattwire
committed
*
* @return array
* @throws \CRM_Core_Exception
*/
private function findContribution(string $chargeID = '', string $invoiceID = '', string $subscriptionID = '', string $paymentIntentID = ''): array {

mattwire
committed
$paymentParams = [
'contribution_test' => $this->getPaymentProcessor()->getIsTestMode(),
];
// A) One-off contribution
if (!empty($chargeID)) {
$paymentParams['trxn_id'] = $chargeID;
$contributionApi3 = civicrm_api3('Mjwpayment', 'get_contribution', $paymentParams);
}
// A2) trxn_id = paymentIntentID if set by checkout.session.completed
if (empty($contributionApi3['count'])) {
if (!empty($paymentIntentID)) {
$paymentParams['trxn_id'] = $paymentIntentID;
$contributionApi3 = civicrm_api3('Mjwpayment', 'get_contribution', $paymentParams);
}
}

mattwire
committed
// B2) Contribution linked to subscription and we have invoice_id
// @todo there is a case where $contribution is not defined (i.e. if charge_id is empty)
if (empty($contributionApi3['count'])) {

mattwire
committed
unset($paymentParams['trxn_id']);
if (!empty($invoiceID)) {
$paymentParams['order_reference'] = $invoiceID;
$contributionApi3 = civicrm_api3('Mjwpayment', 'get_contribution', $paymentParams);
}
}
// B1) Contribution linked to subscription and we have subscription_id
// @todo there is a case where $contribution is not defined (i.e. if charge_id, invoice_id are empty)
if (empty($contributionApi3['count'])) {

mattwire
committed
unset($paymentParams['trxn_id']);
if (!empty($subscriptionID)) {
$paymentParams['order_reference'] = $subscriptionID;
$contributionApi3 = civicrm_api3('Mjwpayment', 'get_contribution', $paymentParams);
}
}
// @todo there is a case where $contribution is not defined (i.e. if charge_id, invoice_id, subscription_id are empty)
if (empty($contributionApi3['count'])) {

mattwire
committed
if ((bool)\Civi::settings()->get('stripe_ipndebug')) {
$message = $this->getPaymentProcessor()->getPaymentProcessorLabel() . 'No matching contributions for event ' . $this->getEventID();
\Civi::log()->debug($message);
}
$result = [];
\CRM_Mjwshared_Hook::webhookEventNotMatched('stripe', $this, 'contribution_not_found', $result);
if (empty($result['contribution'])) {
return [];
}
$contribution = $result['contribution'];
}
else {
$contribution = $contributionApi3['values'][$contributionApi3['id']];
}
return $contribution ?? [];
}
/**
* @param string $chargeID
*
* @return float
* @throws \CRM_Core_Exception
* @throws \Civi\Payment\Exception\PaymentProcessorException
* @throws \Stripe\Exception\ApiErrorException
*/
private function getFeeFromCharge(string $chargeID): float {
if (($this->getData()->object['object'] !== 'charge') && (!empty($chargeID))) {
$charge = $this->getPaymentProcessor()->stripeClient->charges->retrieve($chargeID);
$balanceTransactionID = \CRM_Stripe_Api::getObjectParam('balance_transaction', $charge);
}
else {
$balanceTransactionID = $this->getValueFromStripeObject('balance_transaction', 'String');
}
try {
$balanceTransaction = $this->getPaymentProcessor()->stripeClient->balanceTransactions->retrieve($balanceTransactionID);
}
catch (\Exception $e) {
throw new \Civi\Payment\Exception\PaymentProcessorException("Error retrieving balanceTransaction {$balanceTransactionID}. " . $e->getMessage());
}
$fee = $this->getPaymentProcessor()
->getFeeFromBalanceTransaction($balanceTransaction, $this->getValueFromStripeObject('currency', 'String'));
return $fee ?? 0.0;
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
/**
* @param string $chargeID
*
* @return array
* @throws \CRM_Core_Exception
* @throws \Civi\Payment\Exception\PaymentProcessorException
* @throws \Stripe\Exception\ApiErrorException
*/
private function getDetailsFromBalanceTransaction(string $chargeID): array {
if (($this->getData()->object['object'] !== 'charge') && (!empty($chargeID))) {
$charge = $this->getPaymentProcessor()->stripeClient->charges->retrieve($chargeID);
$balanceTransactionID = \CRM_Stripe_Api::getObjectParam('balance_transaction', $charge);
}
else {
$balanceTransactionID = $this->getValueFromStripeObject('balance_transaction', 'String');
}
try {
$balanceTransaction = $this->getPaymentProcessor()->stripeClient->balanceTransactions->retrieve($balanceTransactionID);
}
catch (\Exception $e) {
throw new \Civi\Payment\Exception\PaymentProcessorException("Error retrieving balanceTransaction {$balanceTransactionID}. " . $e->getMessage());
}
if (!empty($balanceTransactionID)) {
$fee = $this->getPaymentProcessor()
->getFeeFromBalanceTransaction($balanceTransaction, $this->getValueFromStripeObject('currency', 'String'));
return [
'fee_amount' => $fee,
'available_on' => \CRM_Stripe_Api::formatDate($balanceTransaction->available_on),
'exchange_rate' => $balanceTransaction->exchange_rate,
'payout_amount' => $balanceTransaction->amount / 100,
'payout_currency' => \CRM_Stripe_Api::formatCurrency($balanceTransaction->currency),
];
}
else {
return [
'fee_amount' => 0.0
];
}
}
/**
* This allows us to end a subscription once:
* a) We've reached the end date / number of installments
* b) The recurring contribution is marked as completed
*
* @throws \CiviCRM_API3_Exception
*/
private function handleInstallmentsForSubscription(string $subscriptionID = '', int $contributionRecurID = NULL) {
// Check that we have both contributionRecurID and subscriptionID
if ((empty($contributionRecurID)) || (empty($subscriptionID))) {
return;
}
$contributionRecur = ContributionRecur::get(FALSE)
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
->addWhere('id', '=', $contributionRecurID)
->execute()
->first();
// Do we have an end date?
if (empty($contributionRecur['end_date'])) {
return;
}
// There is no easy way of retrieving a count of all invoices for a subscription so we ignore the "installments"
// parameter for now and rely on checking end_date (which was calculated based on number of installments...)
// if (empty($contributionRecur['installments'])) { return; }
$stripeSubscription = $this->getPaymentProcessor()->stripeClient->subscriptions->retrieve($subscriptionID);
// If we've passed the end date cancel the subscription
if (($stripeSubscription->current_period_end >= strtotime($contributionRecur['end_date']))
|| ($contributionRecur['contribution_status_id']
== \CRM_Core_PseudoConstant::getKey('CRM_Contribute_BAO_ContributionRecur', 'contribution_status_id', 'Completed'))) {
$this->getPaymentProcessor()->stripeClient->subscriptions->update($subscriptionID, ['cancel_at_period_end' => TRUE]);
$this->updateRecurCompleted(['id' => $contributionRecurID]);
}
}
/**
* Get the recurring contribution from the Stripe subscription ID
*
* @return array
* @throws \CRM_Core_Exception
*/
public function getRecurFromSubscriptionID($subscriptionID): array {
if (empty($subscriptionID)) {
return [];
}
// Get the recurring contribution record associated with the Stripe subscription.
$contributionRecur = ContributionRecur::get(FALSE)
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
->addWhere('processor_id', '=', $subscriptionID)
->addWhere('is_test', 'IN', [TRUE, FALSE])
->execute()
->first();
if (empty($contributionRecur)) {
if ((bool)\Civi::settings()->get('stripe_ipndebug')) {
$message = $this->getPaymentProcessor()->getPaymentProcessorLabel() . ': ' . $this->getEventID() . ': Cannot find recurring contribution for subscription ID: ' . $subscriptionID;
\Civi::log()->debug($message);
}
return [];
}
return $contributionRecur;
}
/**
* Create the next contribution for a recurring contribution
* This happens when Stripe generates a new invoice and notifies us (normally by invoice.finalized but
* invoice.payment_succeeded sometimes arrives first).
*
* @param string $chargeID
* @param string $invoiceID
* @param array $contributionRecur
*
* @return int
* @throws \CRM_Core_Exception
* @throws \CiviCRM_API3_Exception
* @throws \Civi\Payment\Exception\PaymentProcessorException
* @throws \Stripe\Exception\ApiErrorException
*/
public function createNextContributionForRecur(string $chargeID, string $invoiceID, array $contributionRecur): int {
// We have a recurring contribution but no contribution so we'll repeattransaction
// Stripe has generated a new invoice (next payment in a subscription) so we
// create a new contribution in CiviCRM
$repeatContributionParams = [
'contribution_recur_id' => $contributionRecur['id'],
'contribution_status_id' => \CRM_Core_PseudoConstant::getKey('CRM_Contribute_BAO_Contribution', 'contribution_status_id', 'Pending'),
'receive_date' => $this->getValueFromStripeObject('receive_date', 'String'),
'order_reference' => $invoiceID,
'trxn_id' => $chargeID,
'total_amount' => $this->getValueFromStripeObject('amount', 'String'),
'fee_amount' => $this->getFeeFromCharge($chargeID),
];
return $this->repeatContribution($repeatContributionParams);
// Don't touch the contributionRecur as it's updated automatically by Contribution.repeattransaction

mattwire
committed
}
* Webhook event: charge.succeeded / charge.captured
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
* We process charge.succeeded per charge.captured
*
* @return \stdClass
* @throws \CRM_Core_Exception
* @throws \CiviCRM_API3_Exception
* @throws \Civi\Payment\Exception\PaymentProcessorException
* @throws \Stripe\Exception\ApiErrorException
*/
public function doChargeSucceeded(): \stdClass {
$return = $this->getResultObject();
// Check we have the right data object for this event
if (($this->getData()->object['object'] ?? '') !== 'charge') {
$return->message = __FUNCTION__ . ' Invalid object type';
return $return;
}
// For a recurring contribution we can process charge.succeeded once we receive the event with an invoice ID.
// For a single contribution we can't process charge.succeeded because it only triggers BEFORE the charge is captured
if (empty($this->getValueFromStripeObject('customer_id', 'String'))) {
$return->message = __FUNCTION__ . ' not processing because no customer_id';
$return->ok = TRUE;
return $return;
}
$chargeID = $this->getValueFromStripeObject('charge_id', 'String');
if (!$chargeID) {
$return->message = __FUNCTION__ . ' Missing charge_id';
return $return;
}
$paymentIntentID = $this->getValueFromStripeObject('payment_intent_id', 'String');
$invoiceID = $this->getValueFromStripeObject('invoice_id', 'String');
$contribution = $this->findContribution($chargeID, $invoiceID, '', $paymentIntentID);
if (empty($contribution)) {
$return->message = __FUNCTION__ . ' ignoring - contribution not found';
$return->ok = TRUE;
return $return;
}
// For a single contribution we have to use charge.captured because it has the customer_id.
// We only process charge.captured for one-off contributions (see invoice.paid/invoice.payment_succeeded for recurring)
if (!empty($contribution['contribution_recur_id'])) {
$return->message = __FUNCTION__ . ' ignoring - contribution has recur';
$return->ok = TRUE;
return $return;
}
// We only process charge.captured for one-off contributions
if (empty($this->getValueFromStripeObject('captured', 'Boolean'))) {
$return->message = __FUNCTION__ . ' ignoring - charge not captured';
$return->ok = TRUE;
return $return;
}
$pendingContributionStatusID = (int) \CRM_Core_PseudoConstant::getKey('CRM_Contribute_BAO_Contribution', 'contribution_status_id', 'Pending');
$failedContributionStatusID = (int) \CRM_Core_PseudoConstant::getKey('CRM_Contribute_BAO_Contribution', 'contribution_status_id', 'Failed');
$statusesAllowedToComplete = [$pendingContributionStatusID, $failedContributionStatusID];
// If contribution is in Pending or Failed state record payment and transition to Completed
if (in_array($contribution['contribution_status_id'], $statusesAllowedToComplete)) {
$balanceTransactionDetails = $this->getDetailsFromBalanceTransaction($chargeID);
$contributionParams = [
'contribution_id' => $contribution['id'],
'trxn_date' => $this->getValueFromStripeObject('receive_date', 'String'),
'order_reference' => $invoiceID ?? $chargeID,
'trxn_id' => $chargeID,
'total_amount' => $this->getValueFromStripeObject('amount', 'Float'),
// 'fee_amount' Added below via $balanceTransactionDetails
foreach ($balanceTransactionDetails as $key => $value) {
$contributionParams[$key] = $value;
}
$this->updateContributionCompleted($contributionParams);
}
$return->message = __FUNCTION__ . ' contributionID: ' . $contribution['id'];
$return->ok = TRUE;
return $return;
}

mattwire
committed
/**
* Webhook event: charge.refunded

mattwire
committed
* Process the charge.refunded event from Stripe
*
* @return \stdClass
* @throws \CRM_Core_Exception
* @throws \CiviCRM_API3_Exception
* @throws \Civi\Payment\Exception\PaymentProcessorException
* @throws \Stripe\Exception\ApiErrorException
*/
public function doChargeRefunded(): \stdClass {

mattwire
committed
$return = $this->getResultObject();
// Check we have the right data object for this event
if (($this->getData()->object['object'] ?? '') !== 'charge') {
$return->message = __FUNCTION__ . ' Invalid object type';

mattwire
committed
return $return;
}
// Cancelling an uncaptured paymentIntent triggers charge.refunded but we don't want to process that
if (empty(\CRM_Stripe_Api::getObjectParam('captured', $this->getData()->object))) {
$return->ok = TRUE;
return $return;
}
// Charge ID is required
$chargeID = $this->getValueFromStripeObject('charge_id', 'String');
if (!$chargeID) {
$return->message = __FUNCTION__ . ' Missing charge_id';

mattwire
committed
return $return;
}
// Invoice ID is optional
$invoiceID = $this->getValueFromStripeObject('invoice_id', 'String');
// This gives us the refund date + reason code
$refunds = $this->getPaymentProcessor()->stripeClient->refunds->all(['charge' => $chargeID, 'limit' => 1]);
$refund = $refunds->data[0];
// Stripe does not refund fees - see https://support.stripe.com/questions/understanding-fees-for-refunded-payments
// This gives us the actual amount refunded
$amountRefunded = \CRM_Stripe_Api::getObjectParam('amount_refunded', $this->getData()->object);
// Get the CiviCRM contribution that matches the Stripe metadata we have from the event
$contribution = $this->findContribution($chargeID, $invoiceID);
if (empty($contribution)) {
$return->message = __FUNCTION__ . ' Contribution not found';

mattwire
committed
return $return;
}
if (isset($contribution['payments'])) {
foreach ($contribution['payments'] as $payment) {
if ($payment['trxn_id'] === $refund->id) {
$return->message = __FUNCTION__ . ' Refund ' . $refund->id . ' already recorded in CiviCRM';

mattwire
committed
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
return $return;
}
if ($payment['trxn_id'] === $chargeID) {
// This triggers the financial transactions/items to be updated correctly.
$cancelledPaymentID = $payment['id'];
}
}
}
$refundParams = [
'contribution_id' => $contribution['id'],
'total_amount' => 0 - abs($amountRefunded),
'trxn_date' => date('YmdHis', $refund->created),
'trxn_result_code' => $refund->reason,
'fee_amount' => 0,
'trxn_id' => $refund->id,
'order_reference' => $invoiceID,
];
if (!empty($cancelledPaymentID)) {
$refundParams['cancelled_payment_id'] = $cancelledPaymentID;
}
$lock = \Civi::lockManager()->acquire('data.contribute.contribution.' . $refundParams['contribution_id']);
if (!$lock->isAcquired()) {
\Civi::log()->error('Could not acquire lock to record refund for contribution: ' . $refundParams['contribution_id']);
}
$refundPayment = civicrm_api3('Payment', 'get', [
'trxn_id' => $refundParams['trxn_id'],
'total_amount' => $refundParams['total_amount'],
]);
if (!empty($refundPayment['count'])) {
$return->message = __FUNCTION__ . ' Refund already recorded. Contribution ID: ' . $contribution['id'];
$return->ok = TRUE;

mattwire
committed
}
else {
$this->updateContributionRefund($refundParams);
$return->message = __FUNCTION__ . 'Refund recorded. Contribution ID: ' . $contribution['id'];
$return->ok = TRUE;

mattwire
committed
}
$lock->release();
return $return;
}
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
/**
* Webhook event: charge.failed
* One-time donation and per invoice payment
*
* @return \stdClass
* @throws \CiviCRM_API3_Exception
* @throws \Civi\Payment\Exception\PaymentProcessorException
*/
public function doChargeFailed(): \stdClass {
$return = $this->getResultObject();
// Check we have the right data object for this event
if (($this->getData()->object['object'] ?? '') !== 'charge') {
$return->message = __FUNCTION__ . ' Invalid object type';
return $return;
}
// If we don't have a customer_id we can't do anything with it!
// It's quite likely to be a fraudulent/spam so we ignore.
if (empty($this->getValueFromStripeObject('customer_id', 'String'))) {
$return->message = __FUNCTION__ . ' ignoring - no customer_id';
$return->ok = TRUE;
return $return;
}
// Charge ID is required
$chargeID = $this->getValueFromStripeObject('charge_id', 'String');
if (!$chargeID) {
$return->message = __FUNCTION__ . ' Missing charge_id';
return $return;
}
$paymentIntentID = $this->getValueFromStripeObject('payment_intent_id', 'String');
// Invoice ID is optional
$invoiceID = $this->getValueFromStripeObject('invoice_id', 'String');
$contribution = $this->findContribution($chargeID, $invoiceID, '', $paymentIntentID);
if (empty($contribution)) {
$return->message = __FUNCTION__ . ' Contribution not found';
return $return;
}
$failedContributionParams = [
'contribution_id' => $contribution['id'],
'cancel_date' => $this->getValueFromStripeObject('receive_date', 'String'),
'cancel_reason' => $this->getValueFromStripeObject('failure_message', 'String'),
];
// Fallback from invoiceID to chargeID. We can't use ?? because invoiceID might be empty string ie. '' and not NULL
$failedContributionParams['order_reference'] = empty($invoiceID) ? $chargeID : $invoiceID;
$this->updateContributionFailed($failedContributionParams);
$return->message = __FUNCTION__ . ' contributionID: ' . $contribution['id'];
$return->ok = TRUE;
return $return;
}
/**
* Webhook event: checkout.session.completed
*
* @return \stdClass
public function doCheckoutSessionCompleted(): \stdClass {
$return = $this->getResultObject();
// Check we have the right data object for this event
if (($this->getData()->object['object'] ?? '') !== 'checkout.session') {
$return->message = __FUNCTION__ . ' Invalid object type';
return $return;
}
// Invoice ID is required
$clientReferenceID = $this->getValueFromStripeObject('client_reference_id', 'String');
if (!$clientReferenceID) {
$return->message = __FUNCTION__ . ' Missing client_reference_id';
return $return;
}
$contribution = Contribution::get(FALSE)
->addWhere('invoice_id', '=', $clientReferenceID)
->addWhere('is_test', 'IN', [TRUE, FALSE])
->execute()
->first();
if (empty($contribution)) {
$return->message = __FUNCTION__ . ' contribution not found for client_reference_id';
return $return;
}
// For one-off we have a paymentintentID
$paymentIntentID = $this->getValueFromStripeObject('payment_intent_id', 'String');
// For subscription we have invoice + subscription
$invoiceID = $this->getValueFromStripeObject('invoice_id', 'String');
$subscriptionID = $this->getValueFromStripeObject('subscription_id', 'String');
if (!empty($invoiceID)) {
$contributionTrxnID = $invoiceID;
}
elseif (!empty($paymentIntentID)) {
$contributionTrxnID = $paymentIntentID;
}
else {
$return->message = __FUNCTION__ . ' Missing invoiceID or paymentIntentID';
return $return;
}
Contribution::update(FALSE)
->addWhere('id', '=', $contribution['id'])
->addValue('trxn_id', $contributionTrxnID)
->execute();
if (!empty($subscriptionID) && !empty($contribution['contribution_recur_id'])) {
ContributionRecur::update(FALSE)
->addWhere('id', '=', $contribution['contribution_recur_id'])
->addValue('processor_id', $subscriptionID)
->execute();
}
// charge.succeeded often arrives before checkout.session.completed and we have no way
// to match it to a contribution so it will be ignored.
// Now we have processed checkout.session.completed see if we need to process
// charge.succeeded again.
$chargeSucceededWebhook = \Civi\Api4\PaymentprocessorWebhook::get(FALSE)
->addSelect('id')
->addWhere('identifier', 'CONTAINS', $paymentIntentID)
->addWhere('trigger', '=', 'charge.succeeded')
->addWhere('status', '=', 'success')
->addOrderBy('created_date', 'DESC')
->execute()
->first();
if (!empty($chargeSucceededWebhook)) {
// Flag charge.succeeded for re-processing
\Civi\Api4\PaymentprocessorWebhook::update(FALSE)
->addValue('status', 'new')
->addValue('processed_date', NULL)
->addWhere('id', '=', $chargeSucceededWebhook['id'])
->execute();
$return->message = __FUNCTION__ . ' contributionID: ' . $contribution['id'] . ' charge.succeeded flagged for re-process';
}
else {
$return->message = __FUNCTION__ . ' contributionID: ' . $contribution['id'];
}
$return->ok = TRUE;
return $return;
}
/**
* Webhook event: invoice.paid / invoice.payment_succeeded
* Invoice changed to paid. This is nearly identical to invoice.payment_succeeded
*
* The invoice.payment_successful type Event object is created and sent to any webhook endpoints configured
* to accept that type of Event when the PaymentIntent powering the payment of an Invoice is used successfully.
* The invoice.paid type Event object is created and sent to any webhook endpoints configured to accept that
* type of Event when the Invoice object has its paid property modified to a "true" value
* (see https://stripe.com/docs/api/invoices/object#invoice_object-paid).
*
* Successful recurring payment. Either we are completing an existing contribution or it's the next one in a subscription
*
* @return \stdClass
* @throws \CRM_Core_Exception
* @throws \CiviCRM_API3_Exception
* @throws \Civi\Payment\Exception\PaymentProcessorException
*/
public function doInvoicePaid(): \stdClass {
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
$return = $this->getResultObject();
// Check we have the right data object for this event
if (($this->getData()->object['object'] ?? '') !== 'invoice') {
$return->message = __FUNCTION__ . ' Invalid object type';
return $return;
}
// Invoice ID is required
$invoiceID = $this->getValueFromStripeObject('invoice_id', 'String');
if (!$invoiceID) {
$return->message = __FUNCTION__ . ' Missing invoice_id';
return $return;
}
$chargeID = $this->getValueFromStripeObject('charge_id', 'String');
$subscriptionID = $this->getValueFromStripeObject('subscription_id', 'String');
$contributionRecur = $this->getRecurFromSubscriptionID($subscriptionID);
if (empty($contributionRecur)) {
$return->message = __FUNCTION__ . ': ' . E::ts('No contributionRecur record found in CiviCRM. Ignored.');
$return->ok = TRUE;
return $return;
}
// Acquire the lock to find/create contribution
$lock = \Civi::lockManager()->acquire('data.contribute.contribution.' . $invoiceID);
if (!$lock->isAcquired()) {
\Civi::log()->error('Could not acquire lock to record ' . $this->getEventType() . ' for Stripe InvoiceID: ' . $invoiceID);
}
// We *normally/ideally* expect to be able to find the contribution,
// since the logical order of events would be invoice.finalized first which
// creates a contribution; then invoice.payment_succeeded/paid following, which would
// find it.
$contribution = $this->findContribution($chargeID, $invoiceID, $subscriptionID);
if (empty($contribution)) {
// We were unable to locate the Contribution; it could be the next one in a subscription.
if (empty($contributionRecur['id'])) {
// Hmmm. We could not find the contribution recur record either. Silently ignore this event(!)
$return->ok = TRUE;
$return->message = __FUNCTION__ . ': ' . E::ts('No contribution or recur record found in CiviCRM. Ignored.');
return $return;
}
else {
// We have a recurring contribution but have not yet received invoice.finalized so we don't have the next contribution yet.
// invoice.payment_succeeded sometimes comes before invoice.finalized so trigger the same behaviour here to create a new contribution
$contributionID = $this->createNextContributionForRecur($chargeID, $invoiceID, $contributionRecur);
// Now get the contribution we just created.
$contribution = Contribution::get(FALSE)
->addWhere('id', '=', $contributionID)
->execute()
->first();
}
}
// Release the lock to find/create contribution
$lock->release();
// Now acquire lock to record payment on the contribution
$lock = \Civi::lockManager()->acquire('data.contribute.contribution.' . $contribution['id']);
if (!$lock->isAcquired()) {
\Civi::log()->error('Could not acquire lock to record ' . $this->getEventType() . ' for contribution: ' . $contribution['id']);
}
// By this point we should have a contribution
if (civicrm_api3('Mjwpayment', 'get_payment', [
'trxn_id' => $chargeID,
'status_id' => 'Completed',
])['count'] > 0) {
// Payment already recorded
$return->ok = TRUE;
$return->message = __FUNCTION__ . ': ' . E::ts('Payment already recorded');
return $return;
}
$pendingContributionStatusID = (int) \CRM_Core_PseudoConstant::getKey('CRM_Contribute_BAO_Contribution', 'contribution_status_id', 'Pending');
$failedContributionStatusID = (int) \CRM_Core_PseudoConstant::getKey('CRM_Contribute_BAO_Contribution', 'contribution_status_id', 'Failed');
$statusesAllowedToComplete = [$pendingContributionStatusID, $failedContributionStatusID];
// If contribution is in Pending or Failed state record payment and transition to Completed
if (in_array($contribution['contribution_status_id'], $statusesAllowedToComplete)) {
$contributionParams = [
'contribution_id' => $contribution['id'],
'trxn_date' => $this->getValueFromStripeObject('receive_date', 'String'),
'order_reference' => $invoiceID,
'trxn_id' => $chargeID,
'total_amount' => $this->getValueFromStripeObject('amount', 'String'),
'fee_amount' => $this->getFeeFromCharge($chargeID),
'contribution_status_id' => $contribution['contribution_status_id'],
];
$this->updateContributionCompleted($contributionParams);
// Don't touch the contributionRecur as it's updated automatically by Contribution.completetransaction
}
$lock->release();
$this->handleInstallmentsForSubscription($subscriptionID, $contributionRecur['id']);
$return->message = __FUNCTION__ . ' contributionID: ' . $contribution['id'];
$return->ok = TRUE;
return $return;
}
/**
* Webhook event: invoice.finalized
*
* @return \stdClass
* @throws \CRM_Core_Exception
* @throws \CiviCRM_API3_Exception
* @throws \Civi\Payment\Exception\PaymentProcessorException
* @throws \Stripe\Exception\ApiErrorException
*/
public function doInvoiceFinalized(): \stdClass {
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
$return = $this->getResultObject();
// Check we have the right data object for this event
if (($this->getData()->object['object'] ?? '') !== 'invoice') {
$return->message = __FUNCTION__ . ' Invalid object type';
return $return;
}
// Invoice ID is required
$invoiceID = $this->getValueFromStripeObject('invoice_id', 'String');
if (!$invoiceID) {
$return->message = __FUNCTION__ . ' Missing invoice_id';
return $return;
}
$chargeID = $this->getValueFromStripeObject('charge_id', 'String');
$subscriptionID = $this->getValueFromStripeObject('subscription_id', 'String');
$contributionRecur = $this->getRecurFromSubscriptionID($subscriptionID);
if (empty($contributionRecur)) {
$return->message = __FUNCTION__ . ': ' . E::ts('No contributionRecur record found in CiviCRM. Ignored.');
$return->ok = TRUE;
return $return;
}
$contribution = $this->findContribution($chargeID, $invoiceID, $subscriptionID);
// An invoice has been created and finalized (ready for payment)
// This usually happens automatically through a Stripe subscription
if (empty($contribution)) {
// Unable to find a Contribution.
$this->createNextContributionForRecur($chargeID, $invoiceID, $contributionRecur);
$return->ok = TRUE;
return $return;
}
// For a future recur start date we setup the initial contribution with the
// Stripe subscriptionID because we didn't have an invoice.
// Now we do we can map subscription_id to invoice_id so payment can be recorded
// via subsequent IPN requests (eg. invoice.payment_succeeded)
if ($contribution['trxn_id'] === $subscriptionID) {
$this->updateContribution([
'contribution_id' => $contribution['id'],
'trxn_id' => $invoiceID,
]);
}
$return->message = __FUNCTION__ . ' contributionID: ' . $contribution['id'];
$return->ok = TRUE;
return $return;
}
/**
* Webhook event: invoice.payment_failed
* Failed recurring payment. Either we are failing an existing contribution or it's the next one in a subscription
*
* @return \stdClass
* @throws \CiviCRM_API3_Exception
* @throws \Civi\Payment\Exception\PaymentProcessorException
* @throws \Stripe\Exception\ApiErrorException
*/
public function doInvoicePaymentFailed(): \stdClass {
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
$return = $this->getResultObject();
// Check we have the right data object for this event
if (($this->getData()->object['object'] ?? '') !== 'invoice') {
$return->message = __FUNCTION__ . ' Invalid object type';
return $return;
}
// Invoice ID is required
$invoiceID = $this->getValueFromStripeObject('invoice_id', 'String');
if (!$invoiceID) {
$return->message = __FUNCTION__ . ' Missing invoice_id';
return $return;
}
$chargeID = $this->getValueFromStripeObject('charge_id', 'String');
// Get the CiviCRM contribution that matches the Stripe metadata we have from the event
$contribution = $this->findContribution($chargeID, $invoiceID);
if (empty($contribution)) {
$return->message = __FUNCTION__ . ' Contribution not found';
return $return;
}
$pendingContributionStatusID = (int) \CRM_Core_PseudoConstant::getKey('CRM_Contribute_BAO_Contribution', 'contribution_status_id', 'Pending');
if ($contribution['contribution_status_id'] == $pendingContributionStatusID) {
// If this contribution is Pending, set it to Failed.
// To obtain the failure_message we need to look up the charge object
$failureMessage = '';
if ($chargeID) {
$stripeCharge = $this->getPaymentProcessor()->stripeClient->charges->retrieve($chargeID);
$failureMessage = \CRM_Stripe_Api::getObjectParam('failure_message', $stripeCharge);
$failureMessage = is_string($failureMessage) ? $failureMessage : '';
}
$receiveDate = $this->getValueFromStripeObject('receive_date', 'String');
$params = [
'contribution_id' => $contribution['id'],
'order_reference' => $invoiceID,
'cancel_date' => $receiveDate,
'cancel_reason' => $failureMessage,
];
$this->updateContributionFailed($params);
}
$return->message = __FUNCTION__ . ' contributionID: ' . $contribution['id'];
$return->ok = TRUE;
return $return;
}
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
/**
* Subscription is cancelled.
*
* @return \stdClass
* @throws \CiviCRM_API3_Exception
* @throws \Civi\Payment\Exception\PaymentProcessorException
*/
public function doCustomerSubscriptionDeleted(): \stdClass {
$return = $this->getResultObject();
// Check we have the right data object for this event
if (($this->getData()->object['object'] ?? '') !== 'subscription') {
$return->message = __FUNCTION__ . ' Invalid object type';
return $return;
}
$subscriptionID = $this->getValueFromStripeObject('subscription_id', 'String');
if (!$subscriptionID) {
$return->message = __FUNCTION__ . ' Missing subscription_id';
return $return;
}
$contributionRecur = $this->getRecurFromSubscriptionID($subscriptionID);
if (empty($contributionRecur)) {
// Subscription was not found in CiviCRM
$result = [];
\CRM_Mjwshared_Hook::webhookEventNotMatched('stripe', $this, 'subscription_not_found', $result);
if (empty($result['contributionRecur'])) {
$return->message = __FUNCTION__ . ': ' . E::ts('No contributionRecur record found in CiviCRM. Ignored.');
$return->ok = TRUE;
return $return;
}
else {
$contributionRecur = $result['contributionRecur'];
}
}
// Cancel the recurring contribution
$this->updateRecurCancelled(['id' => $contributionRecur['id'], 'cancel_date' => $this->getValueFromStripeObject('cancel_date', 'String')]);
$return->message = __FUNCTION__ . ' contributionRecurID: ' . $contributionRecur['id'] . ' cancelled';
$return->ok = TRUE;
return $return;
}
/**
* Subscription is updated. We don't currently do anything with this
*
* @return \stdClass
*/
public function doCustomerSubscriptionUpdated(): \stdClass {
$return = $this->getResultObject();
// Check we have the right data object for this event
if (($this->getData()->object['object'] ?? '') !== 'subscription') {
$return->message = __FUNCTION__ . ' Invalid object type';
return $return;
}
$return->message = __FUNCTION__ . ' ignoring - not implemented';
$return->ok = TRUE;
return $return;
}