'where' => 'civicrm_contribution_soft.contribution_id',
'data_type' => CRM_Utils_Type::T_INT,
),
+ 'contribution_soft_credit_contact_id' => array(
+ 'name' => 'contribution_soft_credit_contact_id',
+ 'title' => 'Soft Credit For Contact ID',
+ 'where' => 'civicrm_contact_d.id',
+ 'data_type' => CRM_Utils_Type::T_INT,
+ ),
);
// CRM-16713 - contribution search by Premiums on 'Find Contribution' form.
GROUP BY currency
";
- $dao = CRM_Core_DAO::executeQuery($query, CRM_Core_DAO::$_nullArray);
+ $dao = CRM_Core_DAO::executeQuery($query);
$amount = array();
$count = 0;
while ($dao->fetch()) {
* payments is important for forensic and outreach reasons.
*
* @param int $contributionID
+ * @param int $contactID
* @param string $message
+ *
+ * @throws \CiviCRM_API3_Exception
*/
public static function failPayment($contributionID, $contactID, $message) {
civicrm_api3('activity', 'create', array(
'headerPattern' => '/^soft_credit_contact_id$/i',
'where' => 'civicrm_contribution_soft.contact_id',
),
+ 'contribution_pcp_title' => array(
+ 'name' => 'contribution_pcp_title',
+ 'title' => 'Personal Campaign Page Title',
+ 'headerPattern' => '/^contribution_pcp_title$/i',
+ 'where' => 'contribution_pcp.title',
+ ),
);
return $extraFields;
WHERE civicrm_contribution.contact_id = civicrm_contact.id
AND civicrm_contribution.id = {$id}
";
- return CRM_Core_DAO::singleValueQuery($query, CRM_Core_DAO::$_nullArray);
+ return CRM_Core_DAO::singleValueQuery($query);
}
/**
AND b.is_test = 0
AND b.receive_date >= $startDate
AND b.receive_date < $endDate
- $additionalWhere
+ $additionalWhere
GROUP BY currency
";
$dao = CRM_Core_DAO::executeQuery($query, CRM_Core_DAO::$_nullArray);
$contactContributionsSQL = "
SELECT contribution.id AS id
FROM civicrm_contribution contribution
- LEFT JOIN civicrm_line_item i ON i.contribution_id = contribution.id AND i.entity_table = 'civicrm_contribution' $liWhere
- WHERE contribution.is_test = 0 AND contribution.contact_id = {$contactId}
- $additionalWhere
+ LEFT JOIN civicrm_line_item i ON i.contribution_id = contribution.id AND i.entity_table = 'civicrm_contribution' $liWhere
+ WHERE contribution.is_test = 0 AND contribution.contact_id = {$contactId}
+ $additionalWhere
AND i.id IS NULL";
$contactSoftCreditContributionsSQL = "
}
}
- if ($this->_component == 'contribute') {
- // retrieve the other optional objects first so
- // stuff down the line can use this info and do things
- // CRM-6056
- //in any case get the memberships associated with the contribution
- //because we now support multiple memberships w/ price set
- // see if there are any other memberships to be considered for same contribution.
- $query = "
- SELECT membership_id
- FROM civicrm_membership_payment
-WHERE contribution_id = %1 ";
- $params = array(1 => array($this->id, 'Integer'));
-
- $dao = CRM_Core_DAO::executeQuery($query, $params);
- while ($dao->fetch()) {
- if ($dao->membership_id) {
- if (!is_array($ids['membership'])) {
- $ids['membership'] = array();
- }
- $ids['membership'][] = $dao->membership_id;
- }
- }
+ $this->loadRelatedMembershipObjects($ids);
- if (array_key_exists('membership', $ids) && is_array($ids['membership'])) {
- foreach ($ids['membership'] as $id) {
- if (!empty($id)) {
- $membership = new CRM_Member_BAO_Membership();
- $membership->id = $id;
- if (!$membership->find(TRUE)) {
- throw new Exception("Could not find membership record: $id");
- }
- $membership->join_date = CRM_Utils_Date::isoToMysql($membership->join_date);
- $membership->start_date = CRM_Utils_Date::isoToMysql($membership->start_date);
- $membership->end_date = CRM_Utils_Date::isoToMysql($membership->end_date);
- $this->_relatedObjects['membership'][$membership->membership_type_id] = $membership;
- $membership->free();
- }
- }
- }
- }
- else {
+ if ($this->_component != 'contribute') {
// we are in event mode
// make sure event exists and is valid
$event = new CRM_Event_BAO_Event();
$values['custom_pre_id'] = $custom_pre_id;
$values['custom_post_id'] = $custom_post_ids;
- //for tasks 'Change Participant Status' and 'Batch Update Participants Via Profile' case
+ //for tasks 'Change Participant Status' and 'Update multiple Contributions' case
//and cases involving status updation through ipn
// whatever that means!
// total_amount appears to be the preferred input param & it is unclear why we support amount here
CRM_Financial_BAO_FinancialItem::create($itemParams, NULL, $trxnIds);
if ($fieldValues['tax_amount']) {
- $invoiceSettings = CRM_Core_BAO_Setting::getItem(CRM_Core_BAO_Setting::CONTRIBUTE_PREFERENCES_NAME, 'contribution_invoice_settings');
+ $invoiceSettings = Civi::settings()->get('contribution_invoice_settings');
$taxTerm = CRM_Utils_Array::value('tax_term', $invoiceSettings);
$itemParams['amount'] = $diff * $fieldValues['tax_amount'];
$itemParams['description'] = $taxTerm;
* Credit Note Id.
*/
public static function createCreditNoteId() {
- $prefixValue = CRM_Core_BAO_Setting::getItem(CRM_Core_BAO_Setting::CONTRIBUTE_PREFERENCES_NAME, 'contribution_invoice_settings');
+ $prefixValue = Civi::settings()->get('contribution_invoice_settings');
$creditNoteNum = CRM_Core_DAO::singleValueQuery("SELECT count(creditnote_id) as creditnote_number FROM civicrm_contribution");
$creditNoteId = NULL;
return $creditNoteId;
}
+ /**
+ * Load related memberships.
+ *
+ * Note that in theory it should be possible to retrieve these from the line_item table
+ * with the membership_payment table being deprecated. Attempting to do this here causes tests to fail
+ * as it seems the api is not correctly linking the line items when the contribution is created in the flow
+ * where the contribution is created in the API, followed by the membership (using the api) followed by the membership
+ * payment. The membership payment BAO does have code to address this but it doesn't appear to be working.
+ *
+ * I don't know if it never worked or broke as a result of https://issues.civicrm.org/jira/browse/CRM-14918.
+ *
+ * @param array $ids
+ *
+ * @throws Exception
+ */
+ public function loadRelatedMembershipObjects(&$ids) {
+ $query = "
+ SELECT membership_id
+ FROM civicrm_membership_payment
+ WHERE contribution_id = %1 ";
+ $params = array(1 => array($this->id, 'Integer'));
+
+ $dao = CRM_Core_DAO::executeQuery($query, $params);
+ while ($dao->fetch()) {
+ if ($dao->membership_id) {
+ if (!is_array($ids['membership'])) {
+ $ids['membership'] = array();
+ }
+ $ids['membership'][] = $dao->membership_id;
+ }
+ }
+
+ if (array_key_exists('membership', $ids) && is_array($ids['membership'])) {
+ foreach ($ids['membership'] as $id) {
+ if (!empty($id)) {
+ $membership = new CRM_Member_BAO_Membership();
+ $membership->id = $id;
+ if (!$membership->find(TRUE)) {
+ throw new Exception("Could not find membership record: $id");
+ }
+ $membership->join_date = CRM_Utils_Date::isoToMysql($membership->join_date);
+ $membership->start_date = CRM_Utils_Date::isoToMysql($membership->start_date);
+ $membership->end_date = CRM_Utils_Date::isoToMysql($membership->end_date);
+ $this->_relatedObjects['membership'][$membership->membership_type_id] = $membership;
+ $membership->free();
+ }
+ }
+ }
+ }
+
}
projects / civicrm-core.git / blobdiff