/** * Function to retrieve the list of soft contributons for given contact. * @param int $contact_id contact id * * @return array * @static */ static function getSoftContributionList($contact_id, $isTest = 0) { $query = "SELECT ccs.id, ccs.amount as amount,\n ccs.contribution_id, \n ccs.pcp_id,\n ccs.pcp_display_in_roll,\n ccs.pcp_roll_nickname,\n ccs.pcp_personal_note,\n cc.receive_date,\n cc.contact_id as contributor_id,\n cc.contribution_status_id as contribution_status_id,\n cp.title as pcp_title,\n cc.currency,\n contact.display_name,\n cct.name as contributionType\n FROM civicrm_contribution_soft ccs\n LEFT JOIN civicrm_contribution cc\n ON ccs.contribution_id = cc.id\n LEFT JOIN civicrm_pcp cp \n ON ccs.pcp_id = cp.id\n LEFT JOIN civicrm_contact contact\n ON ccs.contribution_id = cc.id AND\n cc.contact_id = contact.id \n LEFT JOIN civicrm_contribution_type cct\n ON cc.contribution_type_id = cct.id\n WHERE cc.is_test = {$isTest} AND ccs.contact_id = " . $contact_id; $cs = CRM_Core_DAO::executeQuery($query, CRM_Core_DAO::$_nullArray); require_once "CRM/Contribute/PseudoConstant.php"; $contributionStatus = CRM_Contribute_Pseudoconstant::contributionStatus(); $result = array(); while ($cs->fetch()) { $result[$cs->id]['amount'] = $cs->amount; $result[$cs->id]['currency'] = $cs->currency; $result[$cs->id]['contributor_id'] = $cs->contributor_id; $result[$cs->id]['contribution_id'] = $cs->contribution_id; $result[$cs->id]['contributor_name'] = $cs->display_name; $result[$cs->id]['contribution_type'] = $cs->contributionType; $result[$cs->id]['receive_date'] = $cs->receive_date; $result[$cs->id]['pcp_id'] = $cs->pcp_id; $result[$cs->id]['pcp_title'] = $cs->pcp_title; $result[$cs->id]['pcp_display_in_roll'] = $cs->pcp_display_in_roll; $result[$cs->id]['pcp_roll_nickname'] = $cs->pcp_roll_nickname; $result[$cs->id]['pcp_personal_note'] = $cs->pcp_personal_note; $result[$cs->id]['contribution_status'] = CRM_Utils_Array::value($cs->contribution_status_id, $contributionStatus); if ($isTest) { $result[$cs->id]['contribution_status'] = $result[$cs->id]['contribution_status'] . '<br /> (test)'; } } return $result; }
/** * Function to get list of pledges In Honor of contact Ids * * @param int $honorId In Honor of Contact ID * * @return return the list of pledge fields * * @access public * @static */ static function getHonorContacts($honorId) { $params = array(); require_once 'CRM/Pledge/DAO/Pledge.php'; $honorDAO = new CRM_Pledge_DAO_Pledge(); $honorDAO->honor_contact_id = $honorId; $honorDAO->find(); //get all status. require_once 'CRM/Contribute/PseudoConstant.php'; while ($honorDAO->fetch()) { $params[$honorDAO->id] = array('honorId' => $honorDAO->contact_id, 'amount' => $honorDAO->amount, 'status' => CRM_Contribute_Pseudoconstant::contributionStatus($honorDAO->status_id), 'create_date' => $honorDAO->create_date, 'acknowledge_date' => $honorDAO->acknowledge_date, 'type' => CRM_Core_DAO::getFieldValue('CRM_Contribute_DAO_ContributionType', $honorDAO->contribution_type_id, 'name'), 'display_name' => CRM_Core_DAO::getFieldValue('CRM_Contact_DAO_Contact', $honorDAO->contact_id, 'display_name')); } return $params; }