Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | <?php |
2 | /* | |
3 | +--------------------------------------------------------------------+ | |
bc77d7c0 | 4 | | Copyright CiviCRM LLC. All rights reserved. | |
6a488035 | 5 | | | |
bc77d7c0 TO |
6 | | This work is published under the GNU AGPLv3 license with some | |
7 | | permitted exceptions and without any warranty. For full license | | |
8 | | and copyright information, see https://civicrm.org/licensing | | |
6a488035 | 9 | +--------------------------------------------------------------------+ |
d25dd0ee | 10 | */ |
6a488035 | 11 | |
a201e208 | 12 | use Civi\Api4\Contribution; |
13 | ||
6a488035 TO |
14 | /** |
15 | * | |
16 | * @package CRM | |
ca5cec67 | 17 | * @copyright CiviCRM LLC https://civicrm.org/licensing |
6a488035 TO |
18 | */ |
19 | class CRM_Core_Payment_PayPalProIPN extends CRM_Core_Payment_BaseIPN { | |
20 | ||
c8aa607b | 21 | /** |
22 | * Input parameters from payment processor. Store these so that | |
23 | * the code does not need to keep retrieving from the http request | |
24 | * @var array | |
25 | */ | |
be2fb01f | 26 | protected $_inputParameters = []; |
c8aa607b | 27 | |
28 | /** | |
fe482240 | 29 | * Store for the variables from the invoice string. |
c8aa607b | 30 | * @var array |
31 | */ | |
be2fb01f | 32 | protected $_invoiceData = []; |
c8aa607b | 33 | |
34 | /** | |
fe482240 | 35 | * Is this a payment express transaction. |
518fa0ee | 36 | * @var bool |
c8aa607b | 37 | */ |
38 | protected $_isPaymentExpress = FALSE; | |
39 | ||
40 | /** | |
e97c66ff | 41 | * Component. |
42 | * | |
43 | * Are we dealing with an event an 'anything else' (contribute). | |
44 | * | |
45 | * @var string | |
c8aa607b | 46 | */ |
47 | protected $_component = 'contribute'; | |
0dbefed3 | 48 | |
c8aa607b | 49 | /** |
fe482240 | 50 | * Constructor function. |
0dbefed3 | 51 | * |
6a0b768e TO |
52 | * @param array $inputData |
53 | * Contents of HTTP REQUEST. | |
0dbefed3 EM |
54 | * |
55 | * @throws CRM_Core_Exception | |
c8aa607b | 56 | */ |
00be9182 | 57 | public function __construct($inputData) { |
c8aa607b | 58 | $this->setInputParameters($inputData); |
59 | $this->setInvoiceData(); | |
6a488035 TO |
60 | parent::__construct(); |
61 | } | |
62 | ||
c8aa607b | 63 | /** |
fe482240 | 64 | * get the values from the rp_invoice_id string. |
77b97be7 | 65 | * |
6a0b768e TO |
66 | * @param string $name |
67 | * E.g. i, values are stored in the string with letter codes. | |
68 | * @param bool $abort | |
16b10e64 | 69 | * Throw exception if not found |
77b97be7 EM |
70 | * |
71 | * @throws CRM_Core_Exception | |
16b10e64 | 72 | * @return mixed |
c8aa607b | 73 | */ |
00be9182 | 74 | public function getValue($name, $abort = TRUE) { |
c8aa607b | 75 | if ($abort && empty($this->_invoiceData[$name])) { |
76 | throw new CRM_Core_Exception("Failure: Missing Parameter $name"); | |
6a488035 TO |
77 | } |
78 | else { | |
914d3734 | 79 | return $this->_invoiceData[$name] ?? NULL; |
c8aa607b | 80 | } |
81 | } | |
82 | ||
83 | /** | |
84 | * Set $this->_invoiceData from the input array | |
85 | */ | |
00be9182 | 86 | public function setInvoiceData() { |
22e263ad | 87 | if (empty($this->_inputParameters['rp_invoice_id'])) { |
c8aa607b | 88 | $this->_isPaymentExpress = TRUE; |
89 | return; | |
90 | } | |
91 | $rpInvoiceArray = explode('&', $this->_inputParameters['rp_invoice_id']); | |
92 | // for clarify let's also store without the single letter unreadable | |
93 | //@todo after more refactoring we might ditch storing the one letter stuff | |
be2fb01f | 94 | $mapping = [ |
c8aa607b | 95 | 'i' => 'invoice_id', |
96 | 'm' => 'component', | |
97 | 'c' => 'contact_id', | |
98 | 'b' => 'contribution_id', | |
99 | 'r' => 'contribution_recur_id', | |
100 | 'p' => 'participant_id', | |
101 | 'e' => 'event_id', | |
be2fb01f | 102 | ]; |
c8aa607b | 103 | foreach ($rpInvoiceArray as $rpInvoiceValue) { |
104 | $rpValueArray = explode('=', $rpInvoiceValue); | |
105 | $this->_invoiceData[$rpValueArray[0]] = $rpValueArray[1]; | |
106 | $this->_inputParameters[$mapping[$rpValueArray[0]]] = $rpValueArray[1]; | |
107 | // p has been overloaded & could mean contribution page or participant id. Clearly we need an | |
108 | // alphabet with more letters. | |
109 | // the mode will always be resolved before the mystery p is reached | |
6c1df5dc | 110 | if ($rpValueArray[1] === 'contribute') { |
c8aa607b | 111 | $mapping['p'] = 'contribution_page_id'; |
112 | } | |
6a488035 | 113 | } |
22e263ad | 114 | if (empty($this->_inputParameters['component'])) { |
949babe8 JM |
115 | $this->_isPaymentExpress = TRUE; |
116 | } | |
6a488035 TO |
117 | } |
118 | ||
c8aa607b | 119 | /** |
6a0b768e TO |
120 | * @param string $name |
121 | * Of variable to return. | |
122 | * @param string $type | |
123 | * Data type. | |
c8aa607b | 124 | * - String |
125 | * - Integer | |
6a0b768e TO |
126 | * @param string $location |
127 | * Deprecated. | |
128 | * @param bool $abort | |
129 | * Abort if empty. | |
77b97be7 EM |
130 | * |
131 | * @throws CRM_Core_Exception | |
72b3a70c | 132 | * @return mixed |
c8aa607b | 133 | */ |
00be9182 | 134 | public function retrieve($name, $type, $location = 'POST', $abort = TRUE) { |
c8aa607b | 135 | $value = CRM_Utils_Type::validate( |
136 | CRM_Utils_Array::value($name, $this->_inputParameters), | |
137 | $type, | |
138 | FALSE | |
6a488035 TO |
139 | ); |
140 | if ($abort && $value === NULL) { | |
c8aa607b | 141 | throw new CRM_Core_Exception("Could not find an entry for $name in $location"); |
6a488035 TO |
142 | } |
143 | return $value; | |
144 | } | |
145 | ||
c8aa607b | 146 | /** |
fe482240 | 147 | * Process recurring contributions. |
95179d8a | 148 | * |
c8aa607b | 149 | * @param array $input |
150 | * @param array $ids | |
151 | * @param array $objects | |
6a0b768e | 152 | * @param bool $first |
95179d8a | 153 | * |
154 | * @throws \CRM_Core_Exception | |
155 | * @throws \CiviCRM_API3_Exception | |
c8aa607b | 156 | */ |
95179d8a | 157 | public function recur($input, $ids, $objects, $first) { |
6a488035 | 158 | if (!isset($input['txnType'])) { |
d2803851 | 159 | Civi::log()->debug('PayPalProIPN: Could not find txn_type in input request.'); |
95179d8a | 160 | echo 'Failure: Invalid parameters<p>'; |
d2803851 | 161 | return; |
6a488035 TO |
162 | } |
163 | ||
6a488035 TO |
164 | $recur = &$objects['contributionRecur']; |
165 | ||
166 | // make sure the invoice ids match | |
167 | // make sure the invoice is valid and matches what we have in | |
168 | // the contribution record | |
169 | if ($recur->invoice_id != $input['invoice']) { | |
d2803851 | 170 | Civi::log()->debug('PayPalProIPN: Invoice values dont match between database and IPN request recur is ' . $recur->invoice_id . ' input is ' . $input['invoice']); |
95179d8a | 171 | echo 'Failure: Invoice values dont match between database and IPN request recur is ' . $recur->invoice_id . " input is " . $input['invoice']; |
d2803851 | 172 | return; |
6a488035 TO |
173 | } |
174 | ||
175 | $now = date('YmdHis'); | |
176 | ||
6a488035 TO |
177 | $sendNotification = FALSE; |
178 | $subscriptionPaymentStatus = NULL; | |
179 | //List of Transaction Type | |
180 | /* | |
e70a7fc0 | 181 | recurring_payment_profile_created RP Profile Created |
b44e3f84 | 182 | recurring_payment RP Successful Payment |
e70a7fc0 TO |
183 | recurring_payment_failed RP Failed Payment |
184 | recurring_payment_profile_cancel RP Profile Cancelled | |
185 | recurring_payment_expired RP Profile Expired | |
186 | recurring_payment_skipped RP Profile Skipped | |
b44e3f84 | 187 | recurring_payment_outstanding_payment RP Successful Outstanding Payment |
e70a7fc0 TO |
188 | recurring_payment_outstanding_payment_failed RP Failed Outstanding Payment |
189 | recurring_payment_suspended RP Profile Suspended | |
190 | recurring_payment_suspended_due_to_max_failed_payment RP Profile Suspended due to Max Failed Payment | |
191 | */ | |
6a488035 | 192 | |
6a488035 | 193 | //set transaction type |
c8aa607b | 194 | $txnType = $this->retrieve('txn_type', 'String'); |
6a488035 | 195 | //Changes for paypal pro recurring payment |
d2803851 | 196 | $contributionStatuses = array_flip(CRM_Contribute_BAO_Contribution::buildOptions('contribution_status_id', 'validate')); |
6a488035 TO |
197 | switch ($txnType) { |
198 | case 'recurring_payment_profile_created': | |
be2fb01f | 199 | if (in_array($recur->contribution_status_id, [ |
518fa0ee SL |
200 | $contributionStatuses['Pending'], |
201 | $contributionStatuses['In Progress'], | |
202 | ]) | |
353ffa53 TO |
203 | && !empty($recur->processor_id) |
204 | ) { | |
e25b58d1 | 205 | echo "already handled"; |
d2803851 | 206 | return; |
e25b58d1 | 207 | } |
6a488035 | 208 | $recur->create_date = $now; |
d2803851 | 209 | $recur->contribution_status_id = $contributionStatuses['Pending']; |
d57577d4 | 210 | $recur->processor_id = $this->retrieve('recurring_payment_id', 'String'); |
6a488035 TO |
211 | $recur->trxn_id = $recur->processor_id; |
212 | $subscriptionPaymentStatus = CRM_Core_Payment::RECURRING_PAYMENT_START; | |
213 | $sendNotification = TRUE; | |
214 | break; | |
215 | ||
216 | case 'recurring_payment': | |
217 | if ($first) { | |
218 | $recur->start_date = $now; | |
219 | } | |
220 | else { | |
5b51381e | 221 | if ($input['paymentStatus'] != 'Completed') { |
222 | throw new CRM_Core_Exception("Ignore all IPN payments that are not completed"); | |
223 | } | |
b3924856 | 224 | |
5b51381e | 225 | // In future moving to create pending & then complete, but this OK for now. |
226 | // Also consider accepting 'Failed' like other processors. | |
b3924856 MWMC |
227 | $input['contribution_status_id'] = $contributionStatuses['Completed']; |
228 | $input['invoice_id'] = md5(uniqid(rand(), TRUE)); | |
229 | $input['original_contribution_id'] = $ids['contribution']; | |
230 | $input['contribution_recur_id'] = $ids['contributionRecur']; | |
5b51381e | 231 | |
232 | civicrm_api3('Contribution', 'repeattransaction', $input); | |
233 | return; | |
6a488035 TO |
234 | } |
235 | ||
236 | //contribution installment is completed | |
c8aa607b | 237 | if ($this->retrieve('profile_status', 'String') == 'Expired') { |
22e263ad | 238 | if (!empty($recur->end_date)) { |
e25b58d1 | 239 | echo "already handled"; |
d2803851 | 240 | return; |
e25b58d1 | 241 | } |
d2803851 | 242 | $recur->contribution_status_id = $contributionStatuses['Completed']; |
6a488035 TO |
243 | $recur->end_date = $now; |
244 | $sendNotification = TRUE; | |
245 | $subscriptionPaymentStatus = CRM_Core_Payment::RECURRING_PAYMENT_END; | |
246 | } | |
247 | ||
248 | // make sure the contribution status is not done | |
249 | // since order of ipn's is unknown | |
d2803851 MW |
250 | if ($recur->contribution_status_id != $contributionStatuses['Completed']) { |
251 | $recur->contribution_status_id = $contributionStatuses['In Progress']; | |
6a488035 TO |
252 | } |
253 | break; | |
254 | } | |
255 | ||
256 | $recur->save(); | |
257 | ||
258 | if ($sendNotification) { | |
259 | $autoRenewMembership = FALSE; | |
260 | if ($recur->id && | |
261 | isset($ids['membership']) && $ids['membership'] | |
262 | ) { | |
263 | $autoRenewMembership = TRUE; | |
264 | } | |
265 | //send recurring Notification email for user | |
266 | CRM_Contribute_BAO_ContributionPage::recurringNotify($subscriptionPaymentStatus, | |
267 | $ids['contact'], | |
268 | $ids['contributionPage'], | |
269 | $recur, | |
270 | $autoRenewMembership | |
271 | ); | |
272 | } | |
273 | ||
274 | if ($txnType != 'recurring_payment') { | |
d2803851 | 275 | return; |
6a488035 TO |
276 | } |
277 | ||
da88a16b | 278 | // CRM-13737 - am not aware of any reason why payment_date would not be set - this if is a belt & braces |
2aa397bc | 279 | $objects['contribution']->receive_date = !empty($input['payment_date']) ? date('YmdHis', strtotime($input['payment_date'])) : $now; |
6a488035 | 280 | |
2f988242 | 281 | $this->single($input, [ |
282 | 'related_contact' => $ids['related_contact'] ?? NULL, | |
603d4ac3 | 283 | 'participant' => $ids['participant'] ?? NULL, |
284 | 'contributionRecur' => $recur->id ?? NULL, | |
2f988242 | 285 | ], $objects, TRUE, $first); |
6a488035 TO |
286 | } |
287 | ||
6c786a9b | 288 | /** |
d2803851 MW |
289 | * @param array $input |
290 | * @param array $ids | |
291 | * @param array $objects | |
6c786a9b EM |
292 | * @param bool $recur |
293 | * @param bool $first | |
7a9ab499 | 294 | * |
d2803851 | 295 | * @return void |
6c786a9b | 296 | */ |
39edd3c6 | 297 | public function single($input, $ids, $objects, $recur = FALSE, $first = FALSE) { |
6a488035 TO |
298 | $contribution = &$objects['contribution']; |
299 | ||
300 | // make sure the invoice is valid and matches what we have in the contribution record | |
301 | if ((!$recur) || ($recur && $first)) { | |
302 | if ($contribution->invoice_id != $input['invoice']) { | |
d2803851 | 303 | Civi::log()->debug('PayPalProIPN: Invoice values dont match between database and IPN request.'); |
6a488035 | 304 | echo "Failure: Invoice values dont match between database and IPN request<p>contribution is" . $contribution->invoice_id . " and input is " . $input['invoice']; |
d2803851 | 305 | return; |
6a488035 TO |
306 | } |
307 | } | |
308 | else { | |
309 | $contribution->invoice_id = md5(uniqid(rand(), TRUE)); | |
310 | } | |
311 | ||
312 | if (!$recur) { | |
313 | if ($contribution->total_amount != $input['amount']) { | |
d2803851 | 314 | Civi::log()->debug('PayPalProIPN: Amount values dont match between database and IPN request.'); |
6a488035 | 315 | echo "Failure: Amount values dont match between database and IPN request<p>"; |
d2803851 | 316 | return; |
6a488035 TO |
317 | } |
318 | } | |
319 | else { | |
320 | $contribution->total_amount = $input['amount']; | |
321 | } | |
322 | ||
6a488035 | 323 | $status = $input['paymentStatus']; |
95179d8a | 324 | if ($status === 'Denied' || $status === 'Failed' || $status === 'Voided') { |
6c6c8850 | 325 | $this->failed($objects); |
d2803851 | 326 | return; |
6a488035 | 327 | } |
0e89200f | 328 | if ($status === 'Pending') { |
329 | Civi::log()->debug('Returning since contribution status is Pending'); | |
d2803851 | 330 | return; |
6a488035 | 331 | } |
a201e208 | 332 | if ($status === 'Refunded' || $status === 'Reversed') { |
333 | Contribution::update(FALSE)->setValues([ | |
334 | 'cancel_date' => 'now', | |
335 | 'contribution_status_id:name' => 'Cancelled', | |
336 | ])->addWhere('id', '=', $contribution->id)->execute(); | |
337 | Civi::log()->debug("Setting contribution status to Cancelled"); | |
d2803851 | 338 | return; |
6a488035 | 339 | } |
85ce114d | 340 | elseif ($status !== 'Completed') { |
341 | Civi::log()->debug('Returning since contribution status is not handled'); | |
d2803851 | 342 | return; |
6a488035 TO |
343 | } |
344 | ||
345 | // check if contribution is already completed, if so we ignore this ipn | |
4a413eb6 | 346 | $completedStatusId = CRM_Core_PseudoConstant::getKey('CRM_Contribute_BAO_Contribution', 'contribution_status_id', 'Completed'); |
d2803851 | 347 | if ($contribution->contribution_status_id == $completedStatusId) { |
d2803851 | 348 | Civi::log()->debug('PayPalProIPN: Returning since contribution has already been handled.'); |
85ce114d | 349 | echo 'Success: Contribution has already been handled<p>'; |
d2803851 | 350 | return; |
6a488035 TO |
351 | } |
352 | ||
fedc226f | 353 | CRM_Contribute_BAO_Contribution::completeOrder($input, $ids, $objects['contribution']); |
6a488035 TO |
354 | } |
355 | ||
eaf9432c LB |
356 | /** |
357 | * Gets PaymentProcessorID for PayPal | |
358 | * | |
359 | * @return int | |
360 | */ | |
361 | public function getPayPalPaymentProcessorID() { | |
362 | // This is an unreliable method as there could be more than one instance. | |
363 | // Recommended approach is to use the civicrm/payment/ipn/xx url where xx is the payment | |
364 | // processor id & the handleNotification function (which should call the completetransaction api & by-pass this | |
365 | // entirely). The only thing the IPN class should really do is extract data from the request, validate it | |
366 | // & call completetransaction or call fail? (which may not exist yet). | |
d2803851 MW |
367 | |
368 | Civi::log()->warning('Unreliable method used to get payment_processor_id for PayPal Pro IPN - this will cause problems if you have more than one instance'); | |
369 | ||
eaf9432c LB |
370 | $paymentProcessorTypeID = CRM_Core_DAO::getFieldValue('CRM_Financial_DAO_PaymentProcessorType', |
371 | 'PayPal', 'id', 'name' | |
372 | ); | |
be2fb01f | 373 | return (int) civicrm_api3('PaymentProcessor', 'getvalue', [ |
eaf9432c | 374 | 'is_test' => 0, |
be2fb01f | 375 | 'options' => ['limit' => 1], |
eaf9432c LB |
376 | 'payment_processor_type_id' => $paymentProcessorTypeID, |
377 | 'return' => 'id', | |
be2fb01f | 378 | ]); |
eaf9432c LB |
379 | |
380 | } | |
381 | ||
c8aa607b | 382 | /** |
383 | * This is the main function to call. It should be sufficient to instantiate the class | |
384 | * (with the input parameters) & call this & all will be done | |
385 | * | |
386 | * @todo the references to POST throughout this class need to be removed | |
d2803851 | 387 | * @return void |
c8aa607b | 388 | */ |
00be9182 | 389 | public function main() { |
6a488035 TO |
390 | CRM_Core_Error::debug_var('GET', $_GET, TRUE, TRUE); |
391 | CRM_Core_Error::debug_var('POST', $_POST, TRUE, TRUE); | |
cd0f2a34 | 392 | try { |
393 | if ($this->_isPaymentExpress) { | |
394 | $this->handlePaymentExpress(); | |
395 | return; | |
396 | } | |
397 | $objects = $ids = $input = []; | |
398 | $this->_component = $input['component'] = self::getValue('m'); | |
399 | $input['invoice'] = self::getValue('i', TRUE); | |
400 | // get the contribution and contact ids from the GET params | |
401 | $ids['contact'] = self::getValue('c', TRUE); | |
402 | $ids['contribution'] = self::getValue('b', TRUE); | |
403 | ||
404 | $this->getInput($input); | |
405 | ||
406 | if ($this->_component == 'event') { | |
407 | $ids['event'] = self::getValue('e', TRUE); | |
408 | $ids['participant'] = self::getValue('p', TRUE); | |
409 | $ids['contributionRecur'] = self::getValue('r', FALSE); | |
410 | } | |
411 | else { | |
412 | // get the optional ids | |
413 | //@ how can this not be broken retrieving from GET as we are dealing with a POST request? | |
414 | // copy & paste? Note the retrieve function now uses data from _REQUEST so this will be included | |
415 | $ids['membership'] = self::retrieve('membershipID', 'Integer', 'GET', FALSE); | |
416 | $ids['contributionRecur'] = self::getValue('r', FALSE); | |
417 | $ids['contributionPage'] = self::getValue('p', FALSE); | |
418 | $ids['related_contact'] = self::retrieve('relatedContactID', 'Integer', 'GET', FALSE); | |
419 | $ids['onbehalf_dupe_alert'] = self::retrieve('onBehalfDupeAlert', 'Integer', 'GET', FALSE); | |
420 | } | |
6a488035 | 421 | |
cd0f2a34 | 422 | if (!$ids['membership'] && $ids['contributionRecur']) { |
423 | $sql = " | |
6a488035 TO |
424 | SELECT m.id |
425 | FROM civicrm_membership m | |
426 | INNER JOIN civicrm_membership_payment mp ON m.id = mp.membership_id AND mp.contribution_id = %1 | |
427 | WHERE m.contribution_recur_id = %2 | |
428 | LIMIT 1"; | |
cd0f2a34 | 429 | $sqlParams = [ |
430 | 1 => [$ids['contribution'], 'Integer'], | |
431 | 2 => [$ids['contributionRecur'], 'Integer'], | |
432 | ]; | |
433 | if ($membershipId = CRM_Core_DAO::singleValueQuery($sql, $sqlParams)) { | |
434 | $ids['membership'] = $membershipId; | |
435 | } | |
6a488035 | 436 | } |
6a488035 | 437 | |
cd0f2a34 | 438 | $paymentProcessorID = CRM_Utils_Array::value('processor_id', $this->_inputParameters); |
439 | if (!$paymentProcessorID) { | |
440 | $paymentProcessorID = self::getPayPalPaymentProcessorID(); | |
441 | } | |
6a488035 | 442 | |
cd0f2a34 | 443 | if (!$this->validateData($input, $ids, $objects, TRUE, $paymentProcessorID)) { |
444 | return; | |
445 | } | |
6a488035 | 446 | |
dc65872a MW |
447 | $input['payment_processor_id'] = $paymentProcessorID; |
448 | ||
2ae7909b | 449 | if ($ids['contributionRecur']) { |
450 | // check if first contribution is completed, else complete first contribution | |
451 | $first = TRUE; | |
452 | $completedStatusId = CRM_Core_PseudoConstant::getKey('CRM_Contribute_BAO_Contribution', 'contribution_status_id', 'Completed'); | |
453 | if ($objects['contribution']->contribution_status_id == $completedStatusId) { | |
454 | $first = FALSE; | |
6a488035 | 455 | } |
2ae7909b | 456 | $this->recur($input, $ids, $objects, $first); |
457 | return; | |
6a488035 | 458 | } |
2ae7909b | 459 | |
2f988242 | 460 | $this->single($input, [ |
461 | 'related_contact' => $ids['related_contact'] ?? NULL, | |
67ff8c74 | 462 | 'participant' => $ids['participant'] ?? NULL, |
463 | 'contributionRecur' => $ids['contributionRecur'] ?? NULL, | |
2f988242 | 464 | ], $objects, FALSE, FALSE); |
cd0f2a34 | 465 | } |
466 | catch (CRM_Core_Exception $e) { | |
467 | Civi::log()->debug($e->getMessage()); | |
468 | echo 'Invalid or missing data'; | |
6a488035 TO |
469 | } |
470 | } | |
471 | ||
6c786a9b | 472 | /** |
d2803851 | 473 | * @param array $input |
6c786a9b | 474 | * |
d2803851 | 475 | * @return void |
6c786a9b EM |
476 | * @throws CRM_Core_Exception |
477 | */ | |
41ce57e7 | 478 | public function getInput(&$input) { |
479 | $billingID = CRM_Core_BAO_LocationType::getBilling(); | |
6a488035 TO |
480 | |
481 | $input['txnType'] = self::retrieve('txn_type', 'String', 'POST', FALSE); | |
482 | $input['paymentStatus'] = self::retrieve('payment_status', 'String', 'POST', FALSE); | |
6a488035 TO |
483 | |
484 | $input['amount'] = self::retrieve('mc_gross', 'Money', 'POST', FALSE); | |
485 | $input['reasonCode'] = self::retrieve('ReasonCode', 'String', 'POST', FALSE); | |
486 | ||
be2fb01f | 487 | $lookup = [ |
6a488035 TO |
488 | "first_name" => 'first_name', |
489 | "last_name" => 'last_name', | |
490 | "street_address-{$billingID}" => 'address_street', | |
491 | "city-{$billingID}" => 'address_city', | |
492 | "state-{$billingID}" => 'address_state', | |
493 | "postal_code-{$billingID}" => 'address_zip', | |
494 | "country-{$billingID}" => 'address_country_code', | |
be2fb01f | 495 | ]; |
6a488035 TO |
496 | foreach ($lookup as $name => $paypalName) { |
497 | $value = self::retrieve($paypalName, 'String', 'POST', FALSE); | |
498 | $input[$name] = $value ? $value : NULL; | |
499 | } | |
500 | ||
353ffa53 | 501 | $input['is_test'] = self::retrieve('test_ipn', 'Integer', 'POST', FALSE); |
6a488035 TO |
502 | $input['fee_amount'] = self::retrieve('mc_fee', 'Money', 'POST', FALSE); |
503 | $input['net_amount'] = self::retrieve('settle_amount', 'Money', 'POST', FALSE); | |
353ffa53 | 504 | $input['trxn_id'] = self::retrieve('txn_id', 'String', 'POST', FALSE); |
12829b5d | 505 | $input['payment_date'] = $input['receive_date'] = self::retrieve('payment_date', 'String', 'POST', FALSE); |
94155403 | 506 | $input['total_amount'] = $input['amount']; |
6a488035 | 507 | } |
c8aa607b | 508 | |
509 | /** | |
fe482240 | 510 | * Handle payment express IPNs. |
6439290e | 511 | * |
c8aa607b | 512 | * For one off IPNS no actual response is required |
513 | * Recurring is more difficult as we have limited confirmation material | |
949babe8 JM |
514 | * lets look up invoice id in recur_contribution & rely on the unique transaction id to ensure no |
515 | * duplicated | |
516 | * this may not be acceptable to all sites - e.g. if they are shipping or delivering something in return | |
517 | * then the quasi security of the ids array might be required - although better to | |
518 | * http://stackoverflow.com/questions/4848227/validate-that-ipn-call-is-from-paypal | |
519 | * but let's assume knowledge on invoice id & schedule is enough for now esp for donations | |
520 | * only contribute is handled | |
c8aa607b | 521 | */ |
00be9182 | 522 | public function handlePaymentExpress() { |
2aa397bc TO |
523 | //@todo - loads of copy & paste / code duplication but as this not going into core need to try to |
524 | // keep discreet | |
525 | // also note that a lot of the complexity above could be removed if we used | |
526 | // http://stackoverflow.com/questions/4848227/validate-that-ipn-call-is-from-paypal | |
527 | // as membership id etc can be derived by the load objects fn | |
be2fb01f | 528 | $objects = $ids = $input = []; |
949babe8 | 529 | $isFirst = FALSE; |
6439290e | 530 | $input['invoice'] = self::getValue('i', FALSE); |
6d8785b9 JP |
531 | //Avoid return in case of unit test. |
532 | if (empty($input['invoice']) && empty($this->_inputParameters['is_unit_test'])) { | |
b9bb2511 JP |
533 | return; |
534 | } | |
353ffa53 | 535 | $input['txnType'] = $this->retrieve('txn_type', 'String'); |
be2fb01f | 536 | $contributionRecur = civicrm_api3('contribution_recur', 'getsingle', [ |
6439290e | 537 | 'return' => 'contact_id, id, payment_processor_id', |
538 | 'invoice_id' => $input['invoice'], | |
be2fb01f | 539 | ]); |
6439290e | 540 | |
541 | if ($input['txnType'] !== 'recurring_payment' && $input['txnType'] !== 'recurring_payment_profile_created') { | |
949babe8 JM |
542 | throw new CRM_Core_Exception('Paypal IPNS not handled other than recurring_payments'); |
543 | } | |
6439290e | 544 | |
949babe8 | 545 | $this->getInput($input, $ids); |
6439290e | 546 | if ($input['txnType'] === 'recurring_payment' && $this->transactionExists($input['trxn_id'])) { |
949babe8 JM |
547 | throw new CRM_Core_Exception('This transaction has already been processed'); |
548 | } | |
549 | ||
949babe8 JM |
550 | $ids['contact'] = $contributionRecur['contact_id']; |
551 | $ids['contributionRecur'] = $contributionRecur['id']; | |
6439290e | 552 | $result = civicrm_api3('contribution', 'getsingle', ['invoice_id' => $input['invoice'], 'contribution_test' => '']); |
949babe8 JM |
553 | |
554 | $ids['contribution'] = $result['id']; | |
d2803851 | 555 | //@todo hardcoding 'pending' for now |
4a413eb6 | 556 | $pendingStatusId = CRM_Core_PseudoConstant::getKey('CRM_Contribute_BAO_Contribution', 'contribution_status_id', 'Pending'); |
d2803851 | 557 | if ($result['contribution_status_id'] == $pendingStatusId) { |
2aa397bc | 558 | $isFirst = TRUE; |
949babe8 JM |
559 | } |
560 | // arg api won't get this - fix it | |
be2fb01f | 561 | $ids['contributionPage'] = CRM_Core_DAO::singleValueQuery("SELECT contribution_page_id FROM civicrm_contribution WHERE invoice_id = %1", [ |
518fa0ee SL |
562 | 1 => [ |
563 | $ids['contribution'], | |
564 | 'Integer', | |
565 | ], | |
566 | ]); | |
949babe8 JM |
567 | // only handle component at this stage - not terribly sure how a recurring event payment would arise |
568 | // & suspec main function may be a victom of copy & paste | |
569 | // membership would be an easy add - but not relevant to my customer... | |
353ffa53 | 570 | $this->_component = $input['component'] = 'contribute'; |
eee81f5a | 571 | $input['trxn_date'] = date('Y-m-d H:i:s', strtotime(self::retrieve('time_created', 'String'))); |
6439290e | 572 | $paymentProcessorID = $contributionRecur['payment_processor_id']; |
949babe8 JM |
573 | |
574 | if (!$this->validateData($input, $ids, $objects, TRUE, $paymentProcessorID)) { | |
575 | throw new CRM_Core_Exception('Data did not validate'); | |
576 | } | |
6439290e | 577 | $this->recur($input, $ids, $objects, $isFirst); |
949babe8 JM |
578 | } |
579 | ||
580 | /** | |
fe482240 | 581 | * Function check if transaction already exists. |
949babe8 | 582 | * @param string $trxn_id |
72b3a70c | 583 | * @return bool|void |
949babe8 | 584 | */ |
00be9182 | 585 | public function transactionExists($trxn_id) { |
22e263ad | 586 | if (CRM_Core_DAO::singleValueQuery("SELECT count(*) FROM civicrm_contribution WHERE trxn_id = %1", |
be2fb01f CW |
587 | [ |
588 | 1 => [$trxn_id, 'String'], | |
589 | ]) | |
353ffa53 | 590 | ) { |
949babe8 JM |
591 | return TRUE; |
592 | } | |
c8aa607b | 593 | } |
96025800 | 594 | |
6a488035 | 595 | } |