本文整理匯總了PHP中CRM_Contribute_DAO_Contribution::executeQuery方法的典型用法代碼示例。如果您正苦於以下問題：PHP CRM_Contribute_DAO_Contribution::executeQuery方法的具體用法？PHP CRM_Contribute_DAO_Contribution::executeQuery怎麽用？PHP CRM_Contribute_DAO_Contribution::executeQuery使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類CRM_Contribute_DAO_Contribution的用法示例。
在下文中一共展示了CRM_Contribute_DAO_Contribution::executeQuery方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: getPotentialContributionsForContact
/**
* Will get a the set of contributions of a given contact
*
* caution: will only the contributions of the last year
*
* @return an array with contributions
*/
public function getPotentialContributionsForContact($contact_id, CRM_Banking_Matcher_Context $context)
{
$config = $this->_plugin_config;
// check in cache
$cache_key = "_contributions_{$contact_id}_{$range_back}_{$config->received_date_check}";
$contributions = $context->getCachedEntry($cache_key);
if ($contributions != NULL) {
return $contributions;
}
$contributions = array();
if ($config->received_date_check) {
$range_back = (int) $config->received_range_days;
$date_restriction = " AND receive_date > (NOW() - INTERVAL {$range_back} DAY)";
} else {
$date_restriction = "";
}
$sql = "SELECT * FROM civicrm_contribution WHERE contact_id={$contact_id} AND is_test = 0 {$date_restriction};";
$contribution = CRM_Contribute_DAO_Contribution::executeQuery($sql);
while ($contribution->fetch()) {
array_push($contributions, $contribution->toArray());
}
// cache result and return
$context->setCachedEntry($cache_key, $contributions);
return $contributions;
}