/*
+--------------------------------------------------------------------+
- | CiviCRM version 4.5 |
+ | CiviCRM version 4.6 |
+--------------------------------------------------------------------+
| Copyright CiviCRM LLC (c) 2004-2014 |
+--------------------------------------------------------------------+
protected $_summary = NULL;
protected $_customGroupExtends = array(
- 'Membership');
+ 'Membership'
+ );
/**
*
/**
*
*/
- function __construct() {
+ public function __construct() {
$this->_columns = array(
- 'civicrm_contact' =>
- array(
+ 'civicrm_contact' => array(
'dao' => 'CRM_Contact_DAO_Contact',
- 'fields' =>
- array(
- 'sort_name' =>
- array('title' => ts('Contact Name'),
+ 'fields' => array(
+ 'sort_name' => array(
+ 'title' => ts('Contact Name'),
'required' => TRUE,
'no_repeat' => TRUE,
),
- 'id' =>
- array(
+ 'id' => array(
'no_display' => TRUE,
'required' => TRUE,
),
- 'contact_type' =>
- array(
+ 'contact_type' => array(
'title' => ts('Contact Type'),
),
- 'contact_sub_type' =>
- array(
+ 'contact_sub_type' => array(
'title' => ts('Contact Subtype'),
),
),
- 'filters' =>
- array(
- 'sort_name' =>
- array('title' => ts('Contact Name'),
+ 'filters' => array(
+ 'sort_name' => array(
+ 'title' => ts('Contact Name'),
'operator' => 'like',
),
- 'id' =>
- array('title' => ts('Contact ID'),
+ 'id' => array(
+ 'title' => ts('Contact ID'),
'no_display' => TRUE,
),
),
- 'order_bys' =>
- array(
+ 'order_bys' => array(
'sort_name' => array(
'title' => ts('Last Name, First Name'),
),
),
'grouping' => 'contact-fields',
),
- 'civicrm_membership' =>
- array(
+ 'civicrm_membership' => array(
'dao' => 'CRM_Member_DAO_Membership',
- 'fields' =>
- array(
- 'id' =>
- array('title' => ts('Membership #'),
+ 'fields' => array(
+ 'id' => array(
+ 'title' => ts('Membership #'),
'no_display' => TRUE,
'required' => TRUE,
),
'fields' => array(
'debit_accounting_code' => array(
'title' => ts('Financial Account Code - Debit'),
- 'name' => 'accounting_code',
+ 'name' => 'accounting_code',
'alias' => 'financial_account_civireport_debit',
'default' => TRUE,
),
'credit_accounting_code' => array(
'title' => ts('Financial Account Code - Credit'),
- 'name' => 'accounting_code',
+ 'name' => 'accounting_code',
'alias' => 'financial_account_civireport_credit',
'default' => TRUE,
),
'debit_name' => array(
'title' => ts('Financial Account Name - Debit'),
- 'name' => 'name',
+ 'name' => 'name',
'alias' => 'financial_account_civireport_debit',
'default' => TRUE,
),
'credit_name' => array(
'title' => ts('Financial Account Name - Credit'),
- 'name' => 'name',
+ 'name' => 'name',
'alias' => 'financial_account_civireport_credit',
'default' => TRUE,
),
'title' => ts('Financial Account Code - Debit'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Contribute_PseudoConstant::financialAccount(NULL, NULL, 'accounting_code', 'accounting_code'),
- 'name' => 'accounting_code',
+ 'name' => 'accounting_code',
'alias' => 'financial_account_civireport_debit',
),
'credit_accounting_code' => array(
'title' => ts('Financial Account Name - Debit'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Contribute_PseudoConstant::financialAccount(),
- 'name' => 'id',
+ 'name' => 'id',
'alias' => 'financial_account_civireport_debit',
),
'credit_name' => array(
'civicrm_line_item' => array(
'dao' => 'CRM_Price_DAO_LineItem',
'fields' => array(
- 'financial_type_id' => array('title' => ts('Financial Type'),
+ 'financial_type_id' => array(
+ 'title' => ts('Financial Type'),
'default' => TRUE,
),
),
'financial_type_id' => array('title' => ts('Financial Type')),
),
),
- 'civicrm_contribution' =>
- array(
+ 'civicrm_contribution' => array(
'dao' => 'CRM_Contribute_DAO_Contribution',
- 'fields' =>
- array(
+ 'fields' => array(
'receive_date' => array(
'default' => TRUE
),
'title' => ts('Invoice ID'),
'default' => TRUE,
),
- 'contribution_status_id' => array('title' => ts('Contribution Status'),
+ 'contribution_status_id' => array(
+ 'title' => ts('Contribution Status'),
'default' => TRUE,
),
- 'id' => array('title' => ts('Contribution #'),
+ 'id' => array(
+ 'title' => ts('Contribution #'),
'default' => TRUE,
),
),
- 'filters' =>
- array(
- 'receive_date' =>
- array('operatorType' => CRM_Report_Form::OP_DATE),
- 'contribution_status_id' =>
- array('title' => ts('Contribution Status'),
+ 'filters' => array(
+ 'receive_date' => array('operatorType' => CRM_Report_Form::OP_DATE),
+ 'contribution_status_id' => array(
+ 'title' => ts('Contribution Status'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Contribute_PseudoConstant::contributionStatus(),
'default' => array(1),
'title' => ts('Cheque #'),
'default' => TRUE,
),
- 'payment_instrument_id' => array('title' => ts('Payment Instrument'),
+ 'payment_instrument_id' => array(
+ 'title' => ts('Payment Instrument'),
'default' => TRUE,
),
'currency' => array(
- 'required' => TRUE,
- 'no_display' => TRUE,
+ 'required' => TRUE,
+ 'no_display' => TRUE,
),
'trxn_date' => array(
'title' => ts('Transaction Date'),
'default' => TRUE,
),
),
- 'filters' =>
- array(
+ 'filters' => array(
'payment_instrument_id' => array(
'title' => ts('Payment Instrument'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Contribute_PseudoConstant::paymentInstrument(),
),
'currency' => array(
- 'title' => 'Currency',
- 'operatorType' => CRM_Report_Form::OP_MULTISELECT,
- 'options' => CRM_Core_OptionGroup::values('currencies_enabled'),
- 'default' => NULL,
- 'type' => CRM_Utils_Type::T_STRING,
+ 'title' => 'Currency',
+ 'operatorType' => CRM_Report_Form::OP_MULTISELECT,
+ 'options' => CRM_Core_OptionGroup::values('currencies_enabled'),
+ 'default' => NULL,
+ 'type' => CRM_Utils_Type::T_STRING,
),
'trxn_date' => array(
'title' => ts('Transaction Date'),
'type' => CRM_Utils_Type::T_STRING,
),
),
- 'filters' =>
- array(
- 'amount' =>
- array('title' => ts('Amount')),
+ 'filters' => array(
+ 'amount' => array('title' => ts('Amount')),
),
),
);
parent::__construct();
}
- function preProcess() {
+ public function preProcess() {
parent::preProcess();
}
- function select() {
+ public function select() {
$select = array();
$this->_columnHeaders = array();
foreach ($this->_columns as $tableName => $table) {
if (array_key_exists('fields', $table)) {
foreach ($table['fields'] as $fieldName => $field) {
- if (!empty($field['required']) || !empty($this->_params['fields'][$fieldName])) {
+ if (!empty($field['required']) ||
+ !empty($this->_params['fields'][$fieldName])
+ ) {
switch ($fieldName) {
- case 'credit_accounting_code' :
- $select[] = " CASE
+ case 'credit_accounting_code' :
+ $select[] = " CASE
WHEN {$this->_aliases['civicrm_financial_trxn']}.from_financial_account_id IS NOT NULL
THEN {$this->_aliases['civicrm_financial_account']}_credit_1.accounting_code
ELSE {$this->_aliases['civicrm_financial_account']}_credit_2.accounting_code
END AS civicrm_financial_account_credit_accounting_code ";
- break;
- case 'amount' :
- $select[] = " CASE
+ break;
+ case 'amount' :
+ $select[] = " 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 civicrm_entity_financial_trxn_amount ";
- break;
- case 'credit_name' :
- $select[] = " CASE
+ break;
+ case 'credit_name' :
+ $select[] = " CASE
WHEN {$this->_aliases['civicrm_financial_trxn']}.from_financial_account_id IS NOT NULL
THEN {$this->_aliases['civicrm_financial_account']}_credit_1.name
ELSE {$this->_aliases['civicrm_financial_account']}_credit_2.name
END AS civicrm_financial_account_credit_name ";
- break;
- default :
- $select[] = "{$field['dbAlias']} as {$tableName}_{$fieldName}";
- break;
+ break;
+ default :
+ $select[] = "{$field['dbAlias']} as {$tableName}_{$fieldName}";
+ break;
}
$this->_columnHeaders["{$tableName}_{$fieldName}"]['title'] = $field['title'];
$this->_columnHeaders["{$tableName}_{$fieldName}"]['type'] = CRM_Utils_Array::value('type', $field);
$this->_select = 'SELECT ' . implode(', ', $select) . ' ';
}
- function from() {
+ public function from() {
$this->_from = NULL;
$this->_from = "FROM civicrm_contact {$this->_aliases['civicrm_contact']} {$this->_aclFrom}
ON fitem.entity_id = {$this->_aliases['civicrm_line_item']}.id AND fitem.entity_table = 'civicrm_line_item' ";
}
- function orderBy() {
+ public function orderBy() {
parent::orderBy();
// please note this will just add the order-by columns to select query, and not display in column-headers.
// This is a solution to not throw fatal errors when there is a column in order-by, not present in select/display columns.
foreach ($this->_orderByFields as $orderBy) {
- if (!array_key_exists($orderBy['name'], $this->_params['fields']) && empty($orderBy['section'])) {
+ if (!array_key_exists($orderBy['name'], $this->_params['fields']) &&
+ empty($orderBy['section'])
+ ) {
$this->_select .= ", {$orderBy['dbAlias']} as {$orderBy['tplField']}";
}
}
}
- function where() {
+ public function where() {
foreach ($this->_columns as $tableName => $table) {
if (array_key_exists('filters', $table)) {
foreach ($table['filters'] as $fieldName => $field) {
}
if (CRM_Utils_Array::value('type', $field) & CRM_Utils_Type::T_DATE) {
$relative = CRM_Utils_Array::value("{$fieldName}_relative", $this->_params);
- $from = CRM_Utils_Array::value("{$fieldName}_from", $this->_params);
- $to = CRM_Utils_Array::value("{$fieldName}_to", $this->_params);
+ $from = CRM_Utils_Array::value("{$fieldName}_from", $this->_params);
+ $to = CRM_Utils_Array::value("{$fieldName}_to", $this->_params);
$clause = $this->dateClause($field['name'], $relative, $from, $to, $field['type']);
}
}
}
- function postProcess() {
+ public function postProcess() {
// get the acl clauses built before we assemble the query
$this->buildACLClause($this->_aliases['civicrm_contact']);
parent::postProcess();
*
* @return array
*/
- function statistics(&$rows) {
+ public function statistics(&$rows) {
$statistics = parent::statistics($rows);
$select = " SELECT COUNT({$this->_aliases['civicrm_financial_trxn']}.id ) as count,
$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);
+ $avg[] = CRM_Utils_Money::format(round(($dao->amount /
+ $dao->count), 2), $dao->currency);
}
$statistics['counts']['amount'] = array(
- 'value' => implode(', ', $amount),
- 'title' => 'Total Amount',
- 'type' => CRM_Utils_Type::T_STRING,
+ 'value' => implode(', ', $amount),
+ 'title' => 'Total Amount',
+ 'type' => CRM_Utils_Type::T_STRING,
);
$statistics['counts']['avg'] = array(
'value' => implode(', ', $avg),
/**
* @param $rows
*/
- function alterDisplay(&$rows) {
+ public function alterDisplay(&$rows) {
$contributionTypes = CRM_Contribute_PseudoConstant::financialType();
$paymentInstruments = CRM_Contribute_PseudoConstant::paymentInstrument();
$contributionStatus = CRM_Contribute_PseudoConstant::contributionStatus();
foreach ($rows as $rowNum => $row) {
// convert display name to links
- if (array_key_exists('civicrm_contact_sort_name', $row) && !empty($rows[$rowNum]['civicrm_contact_sort_name']) &&
+ if (array_key_exists('civicrm_contact_sort_name', $row) &&
+ !empty($rows[$rowNum]['civicrm_contact_sort_name']) &&
array_key_exists('civicrm_contact_id', $row)
) {
$url = CRM_Utils_System::url('civicrm/contact/view',
$rows[$rowNum]['civicrm_line_item_financial_type_id'] = $contributionTypes[$value];
}
if ($value = CRM_Utils_Array::value('civicrm_entity_financial_trxn_amount', $row)) {
- $rows[$rowNum]['civicrm_entity_financial_trxn_amount'] = CRM_Utils_Money::format($rows[$rowNum]['civicrm_entity_financial_trxn_amount'],$rows[$rowNum]['civicrm_financial_trxn_currency']);
+ $rows[$rowNum]['civicrm_entity_financial_trxn_amount'] = CRM_Utils_Money::format($rows[$rowNum]['civicrm_entity_financial_trxn_amount'], $rows[$rowNum]['civicrm_financial_trxn_currency']);
}
}
}
}
-