/**
* 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;
}
