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