CRM-18661 Fix & add test for financial rows created by repeattransaction
[civicrm-core.git] / CRM / Member / BAO / MembershipPayment.php
1 <?php
2 /*
3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.7 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2016 |
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
31 * @copyright CiviCRM LLC (c) 2004-2016
32 * $Id$
33 *
34 */
35 class CRM_Member_BAO_MembershipPayment extends CRM_Member_DAO_MembershipPayment {
36
37
38 /**
39 * Class constructor.
40 */
41 public function __construct() {
42 parent::__construct();
43 }
44
45 /**
46 * Add the membership Payments.
47 *
48 * @param array $params
49 * Reference array contains the values submitted by the form.
50 *
51 *
52 * @return object
53 */
54 public static function create($params) {
55 $hook = empty($params['id']) ? 'create' : 'edit';
56 CRM_Utils_Hook::pre($hook, 'MembershipPayment', CRM_Utils_Array::value('id', $params), $params);
57 $dao = new CRM_Member_DAO_MembershipPayment();
58 $dao->copyValues($params);
59 // We check for membership_id in case we are being called too early in the process. This is
60 // cludgey but is part of the deprecation process (ie. we are trying to do everything
61 // from LineItem::create with a view to eventually removing this fn & the table.
62 if (!civicrm_api3('Membership', 'getcount', array('id' => $params['membership_id']))) {
63 return $dao;
64 }
65
66 //Fixed for avoiding duplicate entry error when user goes
67 //back and forward during payment mode is notify
68 if (!$dao->find(TRUE)) {
69 $dao->save();
70 }
71 CRM_Utils_Hook::post($hook, 'MembershipPayment', $dao->id, $dao);
72 // CRM-14197 we are in the process on phasing out membershipPayment in favour of storing both contribution_id & entity_id (membership_id) on the line items
73 // table. However, at this stage we have both - there is still quite a bit of refactoring to do to set the line_iten entity_id right the first time
74 // however, we can assume at this stage that any contribution id will have only one line item with that membership type in the line item table
75 // OR the caller will have taken responsibility for updating the line items themselves so we will update using SQL here
76 if (!isset($params['membership_type_id'])) {
77 $membership_type_id = civicrm_api3('membership', 'getvalue', array(
78 'id' => $dao->membership_id,
79 'return' => 'membership_type_id',
80 ));
81 }
82 else {
83 $membership_type_id = $params['membership_type_id'];
84 }
85 $sql = "UPDATE civicrm_line_item li
86 LEFT JOIN civicrm_price_field_value pv ON pv.id = li.price_field_value_id
87 SET entity_table = 'civicrm_membership', entity_id = %1
88 WHERE pv.membership_type_id = %2
89 AND contribution_id = %3";
90 CRM_Core_DAO::executeQuery($sql, array(
91 1 => array($dao->membership_id, 'Integer'),
92 2 => array($membership_type_id, 'Integer'),
93 3 => array($dao->contribution_id, 'Integer'),
94 ));
95 return $dao;
96 }
97
98 /**
99 * Delete membership Payments.
100 *
101 * @param int $id
102 *
103 * @return bool
104 */
105 public static function del($id) {
106 $dao = new CRM_Member_DAO_MembershipPayment();
107 $dao->id = $id;
108 $result = FALSE;
109 if ($dao->find(TRUE)) {
110 $dao->delete();
111 $result = TRUE;
112 }
113 return $result;
114 }
115
116 }