Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | <?php |
2 | /* | |
3 | +--------------------------------------------------------------------+ | |
4 | | CiviCRM version 4.3 | | |
5 | +--------------------------------------------------------------------+ | |
6 | | Copyright CiviCRM LLC (c) 2004-2013 | | |
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-2013 | |
32 | * $Id$ | |
33 | * | |
34 | */ | |
35 | ||
36 | /** | |
37 | * | |
38 | * @package CRM | |
39 | * @author Marshal Newrock <marshal@idealso.com> | |
40 | * $Id$ | |
41 | */ | |
42 | ||
43 | /** | |
44 | * Business objects for Line Items generated by monetary transactions | |
45 | */ | |
46 | class CRM_Price_BAO_LineItem extends CRM_Price_DAO_LineItem { | |
47 | ||
48 | /** | |
49 | * Creates a new entry in the database. | |
50 | * | |
51 | * @param array $params (reference) an assoc array of name/value pairs | |
52 | * | |
53 | * @return object CRM_Price_DAO_LineItem object | |
54 | * @access public | |
55 | * @static | |
56 | */ | |
57 | static function create(&$params) { | |
58 | //create mode only as we don't support editing line items | |
59 | ||
60 | CRM_Utils_Hook::pre('create', 'LineItem', $params['entity_id'], $params); | |
421dfaa6 | 61 | |
6a488035 TO |
62 | $lineItemBAO = new CRM_Price_BAO_LineItem(); |
63 | $lineItemBAO->copyValues($params); | |
64 | ||
65 | $return = $lineItemBAO->save(); | |
66 | ||
67 | CRM_Utils_Hook::post('create', 'LineItem', $params['entity_id'], $params); | |
68 | ||
69 | return $return; | |
70 | } | |
71 | ||
72 | /** | |
73 | * Takes a bunch of params that are needed to match certain criteria and | |
74 | * retrieves the relevant objects. Typically, the valid params are only | |
75 | * price_field_id. This is the inverse function of create. It also | |
76 | * stores all of the retrieved values in the default array. | |
77 | * | |
78 | * @param array $params (reference ) an assoc array of name/value pairs | |
79 | * @param array $defaults (reference ) an assoc array to hold the flattened values | |
80 | * | |
81 | * @return object CRM_Price_BAO_LineItem object | |
82 | * @access public | |
83 | * @static | |
84 | */ | |
85 | static function retrieve(&$params, &$defaults) { | |
86 | $lineItem = new CRM_Price_BAO_LineItem(); | |
87 | $lineItem->copyValues($params); | |
88 | if ($lineItem->find(TRUE)) { | |
89 | CRM_Core_DAO::storeValues($lineItem, $defaults); | |
90 | return $lineItem; | |
91 | } | |
92 | return NULL; | |
93 | } | |
94 | ||
95 | /** | |
96 | * Given a participant id/contribution id, | |
97 | * return contribution/fee line items | |
98 | * | |
99 | * @param $entityId int participant/contribution id | |
100 | * @param $entity string participant/contribution. | |
101 | * | |
102 | * @return array of line items | |
103 | */ | |
104 | static function getLineItems($entityId, $entity = 'participant', $isQuick = NULL) { | |
105 | $selectClause = $whereClause = $fromClause = NULL; | |
106 | $selectClause = " | |
107 | SELECT li.id, | |
108 | li.label, | |
109 | li.qty, | |
110 | li.unit_price, | |
111 | li.line_total, | |
112 | pf.label as field_title, | |
113 | pf.html_type, | |
114 | pfv.membership_type_id, | |
9c09f5b7 | 115 | pfv.membership_num_terms, |
6a488035 TO |
116 | li.price_field_id, |
117 | li.participant_count, | |
118 | li.price_field_value_id, | |
119 | pfv.description"; | |
120 | ||
121 | $fromClause = " | |
122 | FROM civicrm_%2 as %2 | |
123 | LEFT JOIN civicrm_line_item li ON ( li.entity_id = %2.id AND li.entity_table = 'civicrm_%2') | |
124 | LEFT JOIN civicrm_price_field_value pfv ON ( pfv.id = li.price_field_value_id ) | |
125 | LEFT JOIN civicrm_price_field pf ON (pf.id = li.price_field_id )"; | |
126 | $whereClause = " | |
127 | WHERE %2.id = %1"; | |
128 | ||
129 | if ($isQuick) { | |
130 | $fromClause .= " LEFT JOIN civicrm_price_set cps on cps.id = pf.price_set_id "; | |
131 | $whereClause .= " and cps.is_quick_config = 0"; | |
132 | } | |
133 | $lineItems = array(); | |
134 | ||
135 | if (!$entityId || !$entity || !$fromClause) { | |
136 | return $lineItems; | |
137 | } | |
138 | ||
139 | $params = array( | |
140 | 1 => array($entityId, 'Integer'), | |
141 | 2 => array($entity, 'Text'), | |
142 | ); | |
143 | ||
144 | $dao = CRM_Core_DAO::executeQuery("$selectClause $fromClause $whereClause", $params); | |
145 | while ($dao->fetch()) { | |
146 | if (!$dao->id) { | |
147 | continue; | |
148 | } | |
149 | $lineItems[$dao->id] = array( | |
150 | 'qty' => $dao->qty, | |
151 | 'label' => $dao->label, | |
152 | 'unit_price' => $dao->unit_price, | |
153 | 'line_total' => $dao->line_total, | |
154 | 'price_field_id' => $dao->price_field_id, | |
155 | 'participant_count' => $dao->participant_count, | |
156 | 'price_field_value_id' => $dao->price_field_value_id, | |
157 | 'field_title' => $dao->field_title, | |
158 | 'html_type' => $dao->html_type, | |
159 | 'description' => $dao->description, | |
160 | 'entity_id' => $entityId, | |
161 | 'membership_type_id' => $dao->membership_type_id, | |
9c09f5b7 | 162 | 'membership_num_terms' => $dao->membership_num_terms, |
6a488035 TO |
163 | ); |
164 | } | |
165 | return $lineItems; | |
166 | } | |
167 | ||
168 | /** | |
169 | * This method will create the lineItem array required for | |
170 | * processAmount method | |
171 | * | |
172 | * @param int $fid price set field id | |
173 | * @param array $params referance to form values | |
174 | * @param array $fields referance to array of fields belonging | |
175 | * to the price set used for particular event | |
176 | * @param array $values referance to the values array( | |
177 | this is | |
178 | * lineItem array) | |
179 | * | |
180 | * @return void | |
181 | * @access static | |
182 | */ | |
183 | static function format($fid, &$params, &$fields, &$values) { | |
184 | if (empty($params["price_{$fid}"])) { | |
185 | return; | |
186 | } | |
187 | ||
188 | $optionIDs = implode(',', array_keys($params["price_{$fid}"])); | |
189 | ||
190 | //lets first check in fun parameter, | |
191 | //since user might modified w/ hooks. | |
192 | $options = array(); | |
193 | if (array_key_exists('options', $fields)) { | |
194 | $options = $fields['options']; | |
195 | } | |
196 | else { | |
9da8dc8c | 197 | CRM_Price_BAO_PriceFieldValue::getValues($fid, $options, 'weight', TRUE); |
6a488035 TO |
198 | } |
199 | $fieldTitle = CRM_Utils_Array::value('label', $fields); | |
200 | if (!$fieldTitle) { | |
9da8dc8c | 201 | $fieldTitle = CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceField', $fid, 'label'); |
6a488035 TO |
202 | } |
203 | ||
204 | foreach ($params["price_{$fid}"] as $oid => $qty) { | |
205 | $price = $options[$oid]['amount']; | |
206 | ||
207 | // lets clean the price in case it is not yet cleant | |
208 | // CRM-10974 | |
209 | $price = CRM_Utils_Rule::cleanMoney($price); | |
210 | ||
211 | $participantsPerField = CRM_Utils_Array::value('count', $options[$oid], 0); | |
212 | ||
213 | $values[$oid] = array( | |
214 | 'price_field_id' => $fid, | |
215 | 'price_field_value_id' => $oid, | |
216 | 'label' => CRM_Utils_Array::value('label', $options[$oid]), | |
217 | 'field_title' => $fieldTitle, | |
218 | 'description' => CRM_Utils_Array::value('description', $options[$oid]), | |
219 | 'qty' => $qty, | |
220 | 'unit_price' => $price, | |
221 | 'line_total' => $qty * $price, | |
222 | 'participant_count' => $qty * $participantsPerField, | |
223 | 'max_value' => CRM_Utils_Array::value('max_value', $options[$oid]), | |
224 | 'membership_type_id' => CRM_Utils_Array::value('membership_type_id', $options[$oid]), | |
225 | 'membership_num_terms' => CRM_Utils_Array::value('membership_num_terms', $options[$oid]), | |
226 | 'auto_renew' => CRM_Utils_Array::value('auto_renew', $options[$oid]), | |
227 | 'html_type' => $fields['html_type'], | |
228 | 'financial_type_id' => CRM_Utils_Array::value( 'financial_type_id', $options[$oid]), | |
421dfaa6 | 229 | |
6a488035 TO |
230 | ); |
231 | if ($values[$oid]['membership_type_id'] && !isset($values[$oid]['auto_renew'])) { | |
421dfaa6 | 232 | $values[$oid]['auto_renew'] = CRM_Core_DAO::getFieldValue('CRM_Member_DAO_MembershipType', $values[$oid]['membership_type_id'], 'auto_renew'); |
6a488035 TO |
233 | } |
234 | } | |
235 | } | |
236 | ||
237 | /** | |
238 | * Delete line items for given entity. | |
239 | * | |
240 | * @param int $entityId | |
241 | * @param int $entityTable | |
242 | * | |
243 | * @access public | |
244 | * @static | |
245 | */ | |
421dfaa6 | 246 | public static function deleteLineItems($entityId, $entityTable) { |
6a488035 | 247 | if (!$entityId || !$entityTable) { |
9330406e | 248 | return FALSE; |
6a488035 TO |
249 | } |
250 | ||
251 | if ($entityId && !is_array($entityId)) { | |
252 | $entityId = array($entityId); | |
253 | } | |
254 | ||
de1c25e1 | 255 | $query = "DELETE FROM civicrm_line_item where entity_id IN ('" . implode("','", $entityId) . "') AND entity_table = '$entityTable'"; |
6a488035 | 256 | $dao = CRM_Core_DAO::executeQuery($query); |
9330406e | 257 | return TRUE; |
6a488035 TO |
258 | } |
259 | ||
260 | /** | |
261 | * Function to process price set and line items. | |
262 | * @param int $contributionId contribution id | |
263 | * @param array $lineItem line item array | |
264 | * @param object $contributionDetails | |
265 | * @param decimal $initAmount amount | |
266 | * @param string $entityTable entity table | |
267 | * | |
268 | * @access public | |
269 | * @return void | |
270 | * @static | |
271 | */ | |
272 | static function processPriceSet($entityId, $lineItem, $contributionDetails = NULL, $entityTable = 'civicrm_contribution', $update = FALSE) { | |
273 | if (!$entityId || !is_array($lineItem) | |
274 | || CRM_Utils_system::isNull($lineItem) | |
275 | ) { | |
276 | return; | |
277 | } | |
421dfaa6 | 278 | |
6a488035 TO |
279 | foreach ($lineItem as $priceSetId => $values) { |
280 | if (!$priceSetId) { | |
281 | continue; | |
282 | } | |
283 | ||
284 | foreach ($values as $line) { | |
285 | $line['entity_table'] = $entityTable; | |
286 | $line['entity_id'] = $entityId; | |
287 | // if financial type is not set and if price field value is NOT NULL | |
288 | // get financial type id of price field value | |
289 | if (CRM_Utils_Array::value('price_field_value_id', $line) && !CRM_Utils_Array::value('financial_type_id', $line)) { | |
9da8dc8c | 290 | $line['financial_type_id'] = CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceFieldValue', $line['price_field_value_id'], 'financial_type_id'); |
6a488035 TO |
291 | } |
292 | $lineItems = CRM_Price_BAO_LineItem::create($line); | |
293 | if (!$update && $contributionDetails) { | |
294 | CRM_Financial_BAO_FinancialItem::add($lineItems, $contributionDetails); | |
295 | } | |
296 | } | |
297 | } | |
421dfaa6 | 298 | } |
6a488035 TO |
299 | |
300 | public static function syncLineItems($entityId, $entityTable = 'civicrm_contribution', $amount, $otherParams = NULL) { | |
301 | if (!$entityId || CRM_Utils_System::isNull($amount)) | |
302 | return; | |
303 | ||
304 | $from = " civicrm_line_item li | |
305 | LEFT JOIN civicrm_price_field pf ON pf.id = li.price_field_id | |
306 | LEFT JOIN civicrm_price_set ps ON ps.id = pf.price_set_id "; | |
307 | ||
421dfaa6 | 308 | $set = " li.unit_price = %3, |
6a488035 TO |
309 | li.line_total = %3 "; |
310 | ||
421dfaa6 | 311 | $where = " li.entity_id = %1 AND |
6a488035 TO |
312 | li.entity_table = %2 "; |
313 | ||
314 | $params = array( | |
315 | 1 => array($entityId, 'Integer'), | |
316 | 2 => array($entityTable, 'String'), | |
317 | 3 => array($amount, 'Float'), | |
318 | ); | |
319 | ||
320 | if ($entityTable == 'civicrm_contribution') { | |
321 | $entityName = 'default_contribution_amount'; | |
322 | $where .= " AND ps.name = %4 "; | |
421dfaa6 | 323 | $params[4] = array($entityName, 'String'); |
324 | } | |
6a488035 TO |
325 | elseif ($entityTable == 'civicrm_participant') { |
326 | $from .= " | |
327 | LEFT JOIN civicrm_price_set_entity cpse ON cpse.price_set_id = ps.id | |
328 | LEFT JOIN civicrm_price_field_value cpfv ON cpfv.price_field_id = pf.id and cpfv.label = %4 "; | |
329 | $set .= " ,li.label = %4, | |
330 | li.price_field_value_id = cpfv.id "; | |
331 | $where .= " AND cpse.entity_table = 'civicrm_event' AND cpse.entity_id = %5 "; | |
332 | $amount = empty($amount) ? 0: $amount; | |
333 | $params += array( | |
334 | 4 => array($otherParams['fee_label'], 'String'), | |
335 | 5 => array($otherParams['event_id'], 'String'), | |
336 | ); | |
337 | } | |
338 | ||
421dfaa6 | 339 | $query = " |
6a488035 TO |
340 | UPDATE $from |
341 | SET $set | |
421dfaa6 | 342 | WHERE $where |
6a488035 TO |
343 | "; |
344 | ||
345 | CRM_Core_DAO::executeQuery($query, $params); | |
346 | } | |
347 | ||
348 | /** | |
349 | * Function to build line items array. | |
350 | * @param int $params form values | |
351 | * | |
352 | * @param string $entityId entity id | |
353 | * | |
354 | * @param string $entityTable entity Table | |
355 | * | |
356 | * @access public | |
357 | * @return void | |
358 | * @static | |
359 | */ | |
360 | static function getLineItemArray(&$params, $entityId = NULL, $entityTable = 'contribution') { | |
421dfaa6 | 361 | |
6a488035 | 362 | if (!$entityId) { |
9da8dc8c | 363 | $priceSetDetails = CRM_Price_BAO_PriceSet::getDefaultPriceSet(); |
6a488035 TO |
364 | foreach ($priceSetDetails as $values) { |
365 | $params['line_item'][$values['setID']][$values['priceFieldID']] = array( | |
366 | 'price_field_id' => $values['priceFieldID'], | |
367 | 'price_field_value_id' => $values['priceFieldValueID'], | |
368 | 'label' => $values['label'], | |
369 | 'qty' => 1, | |
370 | 'unit_price' => $params['total_amount'], | |
371 | 'line_total' => $params['total_amount'], | |
372 | 'financial_type_id' => $params['financial_type_id'] | |
373 | ); | |
374 | } | |
421dfaa6 | 375 | } |
6a488035 TO |
376 | else { |
377 | $setID = NULL; | |
464bb009 PN |
378 | $totalEntityId = count($entityId); |
379 | foreach ($entityId as $id) { | |
380 | $lineItems = CRM_Price_BAO_LineItem::getLineItems($id, $entityTable); | |
381 | foreach ($lineItems as $key => $values) { | |
382 | if (!$setID) { | |
9da8dc8c | 383 | $setID = CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceField', $values['price_field_id'], 'price_set_id'); |
384 | $params['is_quick_config'] = CRM_Core_DAO::getFieldValue('CRM_Price_DAO_PriceSet', $setID, 'is_quick_config'); | |
464bb009 PN |
385 | } |
386 | if (CRM_Utils_Array::value('is_quick_config', $params) && array_key_exists('total_amount', $params) | |
387 | && $totalEntityId == 1) { | |
388 | $values['line_total'] = $values['unit_price'] = $params['total_amount']; | |
389 | } | |
390 | $values['id'] = $key; | |
391 | $params['line_item'][$setID][$key] = $values; | |
6a488035 | 392 | } |
6a488035 TO |
393 | } |
394 | } | |
395 | } | |
396 | } |