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