/**
* @param $rows
*
* @return mixed
*/
function statistics(&$rows) {
$statistics = parent::statistics($rows);
$isStatusFilter = FALSE;
$relStatus = NULL;
if (CRM_Utils_Array::value('is_active_value', $this->_params) == '1') {
$relStatus = 'Is equal to Active';
}
elseif (CRM_Utils_Array::value('is_active_value', $this->_params) == '0') {
$relStatus = 'Is equal to Inactive';
}
if (CRM_Utils_Array::value('filters', $statistics)) {
foreach ($statistics['filters'] as $id => $value) {
//for displaying relationship type filter
if ($value['title'] == 'Relationship') {
$relTypes = CRM_Core_PseudoConstant::relationshipType();
$statistics['filters'][$id]['value'] = 'Is equal to ' . $relTypes[$this->_params['relationship_type_id_value']]['label_' . $this->relationType];
}
//for displaying relationship status
if ($value['title'] == 'Relationship Status') {
$isStatusFilter = TRUE;
$statistics['filters'][$id]['value'] = $relStatus;
}
}
}
//for displaying relationship status
if (!$isStatusFilter && $relStatus) {
$statistics['filters'][] = array(
'title' => 'Relationship Status',
'value' => $relStatus
);
}
return $statistics;
}
/**
* @param $rows
*
* @return array
*/
function statistics(&$rows) {
$statistics = parent::statistics($rows);
$select = " SELECT COUNT({$this->_aliases['civicrm_financial_trxn']}.id ) as count,
{$this->_aliases['civicrm_contribution']}.currency,
SUM(CASE
WHEN {$this->_aliases['civicrm_entity_financial_trxn']}_item.entity_id IS NOT NULL
THEN {$this->_aliases['civicrm_entity_financial_trxn']}_item.amount
ELSE {$this->_aliases['civicrm_entity_financial_trxn']}.amount
END) as amount
";
$sql = "{$select} {$this->_from} {$this->_where}
GROUP BY {$this->_aliases['civicrm_contribution']}.currency
";
$dao = CRM_Core_DAO::executeQuery($sql);
while ($dao->fetch()) {
$amount[] = CRM_Utils_Money::format($dao->amount, $dao->currency);
$avg[] = CRM_Utils_Money::format(round(($dao->amount /
$dao->count), 2), $dao->currency);
}
if (empty($amount)) {
return $statistics;
}
$statistics['counts']['amount'] = array(
'value' => implode(', ', $amount),
'title' => 'Total Amount',
'type' => CRM_Utils_Type::T_STRING,
);
$statistics['counts']['avg'] = array(
'value' => implode(', ', $avg),
'title' => 'Average',
'type' => CRM_Utils_Type::T_STRING,
);
return $statistics;
}
/**
* @param $rows
*
* @return mixed
*/
function statistics(&$rows) {
$statistics = parent::statistics($rows);
if (!empty($rows)) {
$select = "
SELECT
SUM({$this->_aliases['civicrm_pledge']}.amount ) as amount ";
$sql = "{$select} {$this->_from } {$this->_where}";
$dao = CRM_Core_DAO::executeQuery($sql);
if ($dao->fetch()) {
$statistics['counts']['amount'] = array(
'value' => $dao->amount,
'title' => 'Total LifeTime',
'type' => CRM_Utils_Type::T_MONEY
);
}
}
return $statistics;
}
/**
* @param $rows
*
* @return mixed
*/
function statistics(&$rows) {
return parent::statistics($rows);
}
