3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.4 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2013 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
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. |
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. |
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 +--------------------------------------------------------------------+
31 * @copyright CiviCRM LLC (c) 2004-2013
35 class CRM_Contribute_BAO_ContributionSoft
extends CRM_Contribute_DAO_ContributionSoft
{
40 function __construct() {
41 parent
::__construct();
45 * function to add contribution soft credit record
47 * @param array $params (reference ) an assoc array of name/value pairs
49 * @return object soft contribution of object that is added
53 public static function add(&$params) {
54 $contributionSoft = new CRM_Contribute_DAO_ContributionSoft();
55 $contributionSoft->copyValues($params);
57 // set currency for CRM-1496
58 if (!isset($contributionSoft->currency
)) {
59 $config = CRM_Core_Config
::singleton();
60 $contributionSoft->currency
= $config->defaultCurrency
;
62 return $contributionSoft->save();
66 * Takes a bunch of params that are needed to match certain criteria and
67 * retrieves the relevant objects. Typically the valid params are only
68 * contact_id. We'll tweak this function to be more full featured over a period
69 * of time. This is the inverse function of create. It also stores all the retrieved
70 * values in the default array
72 * @param array $params (reference ) an assoc array of name/value pairs
73 * @param array $defaults (reference ) an assoc array to hold the flattened values
75 * @return object CRM_Contribute_BAO_ContributionSoft object
79 static function retrieve(&$params, &$defaults) {
80 $contributionSoft = new CRM_Contribute_DAO_ContributionSoft();
81 $contributionSoft->copyValues($params);
82 if ($contributionSoft->find(TRUE)) {
83 CRM_Core_DAO
::storeValues($contributionSoft, $defaults);
84 return $contributionSoft;
90 * Function to delete soft credits
92 * @param int $contributionTypeId
95 static function del($params) {
96 //delete from contribution soft table
97 $contributionSoft = new CRM_Contribute_DAO_ContributionSoft();
98 foreach($params as $column => $value) {
99 $contributionSoft->$column = $value;
101 $contributionSoft->delete();
104 static function getSoftContributionTotals($contact_id, $isTest = 0) {
106 SELECT SUM(amount) as amount, AVG(total_amount) as average, cc.currency
107 FROM civicrm_contribution_soft ccs
108 LEFT JOIN civicrm_contribution cc ON ccs.contribution_id = cc.id
109 WHERE cc.is_test = %2 AND ccs.contact_id = %1
112 $params = array(1 => array($contact_id, 'Integer'),
113 2 => array($isTest, 'Integer'));
115 $cs = CRM_Core_DAO
::executeQuery($query, $params);
118 $amount = $average = array();
120 while ($cs->fetch()) {
121 if ($cs->amount
> 0) {
123 $amount[] = $cs->amount
;
124 $average[] = $cs->average
;
125 $currency[] = $cs->currency
;
131 implode(', ', $amount),
132 implode(', ', $average),
133 implode(', ', $currency),
140 * Function to retrieve soft contributions for contribution record.
141 * @param array $params an associated array
142 * @param boolean $all include PCP data
144 * @return array of soft contribution ids, amounts, and associated contact ids
147 static function getSoftContribution($contributionID, $all = FALSE) {
150 'pcp_display_in_roll',
156 SELECT ccs.id, pcp_id, pcp_display_in_roll, pcp_roll_nickname, pcp_personal_note, amount, contact_id, c.display_name
157 FROM civicrm_contribution_soft ccs INNER JOIN civicrm_contact c on c.id = ccs.contact_id
158 WHERE contribution_id = %1;
161 $params = array(1 => array($contributionID, 'Integer'));
163 $dao = CRM_Core_DAO
::executeQuery($query, $params);
165 $softContribution = array();
167 while ($dao->fetch()) {
169 foreach ($pcpFields as $val) {
170 $softContribution[$val] = $dao->$val;
174 $softContribution['soft_credit'][$count] = array(
175 'contact_id' => $dao->contact_id
,
176 'soft_credit_id' => $dao->id
,
177 'amount' => $dao->amount
,
178 'contact_name' => $dao->display_name
184 * FIX API before deleting this
185 $cs = new CRM_Contribute_DAO_ContributionSoft();
186 $cs->copyValues($params);
187 $softContribution = array();
192 while ($cs->fetch()) {
194 foreach ($pcpFields as $val) {
195 $softContribution['pcp'][$val] = $cs->$val;
199 $softContribution['soft_credit'][$count] = array(
200 'soft_credit_to' => $cs->contact_id,
201 'soft_credit_id' => $cs->id,
202 'soft_credit_amount' => $cs->amount,
209 return $softContribution;
212 static function getSoftCreditType($contributionID) {
215 FROM civicrm_contribution_soft
216 WHERE contribution_id = %1
218 $params = array(1 => array($contributionID, 'Integer'));
220 $dao = CRM_Core_DAO
::executeQuery($query, $params);
223 while ($dao->fetch()) {
232 return array($type, $id);
236 * Function to retrieve the list of soft contributions for given contact.
237 * @param int $contact_id contact id
242 static function getSoftContributionList($contact_id, $isTest = 0) {
244 SELECT ccs.id, ccs.amount as amount,
247 ccs.pcp_display_in_roll,
248 ccs.pcp_roll_nickname,
249 ccs.pcp_personal_note,
251 cc.contact_id as contributor_id,
252 cc.contribution_status_id as contribution_status_id,
253 cp.title as pcp_title,
255 contact.display_name,
256 cct.name as contributionType
257 FROM civicrm_contribution_soft ccs
258 LEFT JOIN civicrm_contribution cc
259 ON ccs.contribution_id = cc.id
260 LEFT JOIN civicrm_pcp cp
261 ON ccs.pcp_id = cp.id
262 LEFT JOIN civicrm_contact contact ON
263 ccs.contribution_id = cc.id AND cc.contact_id = contact.id
264 LEFT JOIN civicrm_financial_type cct ON cc.financial_type_id = cct.id
265 WHERE cc.is_test = %2 AND ccs.contact_id = %1
266 ORDER BY cc.receive_date DESC';
269 1 => array($contact_id, 'Integer'),
270 2 => array($isTest, 'Integer')
272 $cs = CRM_Core_DAO
::executeQuery($query, $params);
273 $contributionStatus = CRM_Contribute_PseudoConstant
::contributionStatus();
275 while ($cs->fetch()) {
276 $result[$cs->id
]['amount'] = $cs->amount
;
277 $result[$cs->id
]['currency'] = $cs->currency
;
278 $result[$cs->id
]['contributor_id'] = $cs->contributor_id
;
279 $result[$cs->id
]['contribution_id'] = $cs->contribution_id
;
280 $result[$cs->id
]['contributor_name'] = $cs->display_name
;
281 $result[$cs->id
]['financial_type'] = $cs->contributionType
;
282 $result[$cs->id
]['receive_date'] = $cs->receive_date
;
283 $result[$cs->id
]['pcp_id'] = $cs->pcp_id
;
284 $result[$cs->id
]['pcp_title'] = $cs->pcp_title
;
285 $result[$cs->id
]['pcp_display_in_roll'] = $cs->pcp_display_in_roll
;
286 $result[$cs->id
]['pcp_roll_nickname'] = $cs->pcp_roll_nickname
;
287 $result[$cs->id
]['pcp_personal_note'] = $cs->pcp_personal_note
;
288 $result[$cs->id
]['contribution_status'] = CRM_Utils_Array
::value($cs->contribution_status_id
, $contributionStatus);
291 $result[$cs->id
]['contribution_status'] = $result[$cs->id
]['contribution_status'] . '<br /> (test)';