/**
* Class constructor.
*/
public function __construct() {
$this->_customGroupExtended['civicrm_event'] = array(
'extends' => array('Event'),
'filters' => TRUE,
'title' => ts('Event'),
);
$this->_customGroupExtended['civicrm_participant'] = array(
'extends' => array('Participant'),
'filters' => TRUE,
'title' => ts('Participant'),
);
$this->_columns = $this->getColumns('Event', array(
'fields' => FALSE,
)
)
+ $this->getColumns('Participant', array('fields' => FALSE,))
+ $this->getColumns('Contact', array('fields' => FALSE,));
$this->_columns['civicrm_event']['fields']['id']['required'] = TRUE;
$this->_columns['civicrm_event']['fields']['id']['alter_display'] = 'alterEventID';
$this->_columns['civicrm_event']['fields']['id']['title'] = 'Event';
$this->_aggregateRowFields = array(
'event:id' => 'Event',
);
$this->_aggregateColumnHeaderFields = array(
'participant:status_id' => ts('Participant Status'),
);
$this->_groupFilter = TRUE;
parent::__construct();
}
/**
* Class constructor.
*/
public function __construct() {
$this->_customGroupExtended['civicrm_contribution'] = array(
'extends' => array('Contribution'),
'filters' => TRUE,
'title' => ts('Contribution'),
);
$this->_columns = $this->getColumns('Contribution', array(
'fields' => FALSE,
)) +
$this->_columns = $this->getColumns('Contact', array(
'fields' => FALSE,
)) + $this->_columns = $this->getColumns('Address', array(
'fields' => FALSE,
));
$this->_aggregateRowFields = array(
'contribution:contribution_campaign_id' => 'Campaign',
'address:address_county_id' => 'County',
'address:address_city' => 'City',
'contribution:contribution_financial_type_id' => 'Financial Type',
);
$this->_aggregateColumnHeaderFields = array(
'contribution:contribution_financial_type_id' => 'Financial Type',
'contribution:contribution_campaign_id' => 'Campaign',
);
parent::__construct();
}
/**
*
*/
function __construct() {
$this->_customGroupExtended['civicrm_activity'] = array(
'extends' => array('Activity'),
'filters' => TRUE,
'title' => ts('Activity'),
);
$this->_columns = $this->getColumns('Activity', array(
'fields' => FALSE,
)
)// + $this->getColumns('Contact', array())
;
// $this->_columns['civicrm_contact']['fields']['id']['required'] = true;
// $this->_columns['civicrm_contact']['fields']['gender_id']['no_display'] = true;
// $this->_columns['civicrm_contact']['fields']['gender_id']['title'] = 'Gender';
$this->_aggregateRowFields = array(
'activity:activity_activity_type_id' => 'Activity Type',
'activity:activity_activity_status_id' => 'Activity Status',
'activity:activity_result' => 'Activity Result',
'activity:activity_subject' => 'Activity Subject',
// 'civicrm_contact_civireport:gender_id' => 'Gender',
);
$this->_aggregateColumnHeaderFields = array(
'activity:activity_activity_type_id' => 'Activity Type',
'activity:activity_activity_status_id' => 'Activity Status',
);
parent::__construct();
}
/**
* Class constructor.
*/
public function __construct() {
$this->_templates = array(
'default' => 'default template',
'PhoneBank' => 'Phone Bank template - Phone.tpl',
);
$this->_columns = $this->getColumns('Contact', array(
'fields' => TRUE,
'order_by' => FALSE,
)
) +
$this->getColumns('Address', array(
'fields' => TRUE,
'order_by' => FALSE,
)
) +
$this->getColumns('Email', array(
'fields' => TRUE,
'order_by' => FALSE,
)
) +
$this->getColumns('LatestActivity', array(
'filters' => FALSE,
'fields' => array('activity_type' => array('title' => 'Latest Activity')),
)) +
$this->getColumns('Tag') +
$this->getColumns('Phone');
$this->_columns['civicrm_contact']['fields']['id']['required'] = TRUE;
$this->addTemplateSelector();
$this->_groupFilter = TRUE;
parent::__construct();
}
/**
* Class constructor.
*/
public function __construct() {
$this->_customGroupExtended['civicrm_membership'] = array(
'extends' => array('Membership'),
'filters' => TRUE,
'title' => ts('Membership'),
);
$this->_columns = $this->getColumns('membership', array(
'fields' => FALSE,
'order_by' => FALSE,
)
) + $this->getColumns('contact', array(
'fields' => FALSE,
'order_by' => FALSE,
)
);
$this->_columns['civicrm_membership']['fields']['id']['required'] = TRUE;
$this->_aggregateRowFields = array(
'membership:membership_membership_type_id' => 'Membership Type',
'membership:membership_membership_status_id' => 'Membership Status',
);
$this->_aggregateColumnHeaderFields = array(
'membership:membership_membership_type_id' => 'Membership Type',
'membership:membership_membership_status_id' => 'Membership Status',
);
parent::__construct();
}
/**
* Class constructor.
*/
public function __construct() {
$this->_columns = $this->getColumns('Event');
$this->_columns['civicrm_event']['fields']['id'] = array(
'title' => 'id',
'required' => TRUE,
);
parent::__construct();
}
/**
* Class constructor.
*/
public function __construct() {
$this->_columns = $this->getColumns('Contact', array(
'fields' => FALSE,
'order_by' => FALSE,
)
);
$this->_columns['civicrm_contact']['fields']['id']['required'] = TRUE;
parent::__construct();
}
/**
* Class constructor.
*/
public function __construct() {
$this->_columns
= $this->getColumns('Contact')
+ $this->getColumns('Contribution')
+ $this->getColumns('PriceField')
+ $this->getColumns('PriceFieldValue')
+ $this->getColumns('LineItem');
parent::__construct();
}
/**
* Class constructor.
*/
public function __construct() {
$this->_columns = $this->getColumns('Activity')
+ $this->getColumns('Contact', array('prefix' => 'target_',));
$this->_columns['civicrm_activity']['fields']['id'] = array(
'title' => 'id',
'required' => TRUE,
);
parent::__construct();
}
/**
* Class constructor.
*/
public function __construct() {
$this->_columns
= $this->getColumns('Contact', array('order_by' => TRUE))
+ $this->getColumns('Event')
+ $this->getColumns('Participant')
+ $this->getColumns('Contribution', array('order_by' => TRUE))
+ $this->getColumns('PriceField', array('order_by' => TRUE))
+ $this->getColumns('PriceFieldValue' , array('order_by' => TRUE))
+ $this->getColumns('LineItem', array('order_by' => TRUE));
parent::__construct();
}
/**
* constructor
* @todo allow filtering on other contacts
*/
function __construct() {
$this->_columns = $this->getColumns('Contact', array(
'prefix' => '',
'prefix_label' => 'Source Contact ::',
'filters' => TRUE,
))
+ $this->getColumns('Contact', array(
'prefix' => 'target_',
'group_by' => TRUE,
'prefix_label' => 'Target Contact ::',
'filters' => FALSE,
))
+ $this->getColumns('Contact', array(
'prefix' => 'assignee_',
'prefix_label' => 'Assignee Contact ::',
'filters' => FALSE,
))
+ $this->getColumns('Activity');
parent::__construct();
}
/**
*
*/
function __construct() {
$this->_customGroupExtended['civicrm_case'] = array(
'extends' => array('Case'),
'filters' => TRUE,
'title' => ts('Case'),
);
$this->_columns = $this->getColumns('Case', array(
'fields' => FALSE,
)
)
+ $this->getColumns('Contact', array());
$this->_columns['civicrm_case']['fields']['id']['required'] = TRUE;
$this->_columns['civicrm_contact']['fields']['id']['required'] = TRUE;
// $this->_columns['civicrm_case']['fields']['id']['alter_display'] = 'alterCaseID';
$this->_columns['civicrm_case']['fields']['id']['title'] = 'Case';
$this->_columns['civicrm_contact']['fields']['gender_id']['no_display'] = TRUE;
$this->_columns['civicrm_contact']['fields']['gender_id']['title'] = 'Gender';
$this->_columns['civicrm_contact']['fields']['gender_id']['alter_display'] = 'alterGenderID';
$this->_columns['civicrm_case']['fields']['case_status_id']['title'] = ts('Case Status');
$this->_columns['civicrm_case']['fields']['case_status_id']['options'] = CRM_Case_BAO_Case::buildOptions('status_id');
$this->_columns['civicrm_contact']['fields']['case_status_id']['no_display'] = TRUE;
$this->_columns['civicrm_case']['fields']['case_status_id']['name'] = 'status_id';
$this->_columns['civicrm_case']['filters']['case_is_deleted']['default'] = 0;
$this->_aggregateRowFields = array(
'case_civireport:id' => 'Case',
'case_civireport:case_status_id' => 'Case Status',
'civicrm_contact_civireport:gender_id' => 'Gender',
);
$this->_aggregateColumnHeaderFields = array(
'civicrm_contact_civireport:gender_id' => 'Gender',
'case_civireport:case_status_id' => 'Case Status',
);
$this->_tagFilter = TRUE;
$this->_groupFilter = TRUE;
parent::__construct();
}
/**
*
*/
function __construct() {
$this->_customGroupExtended['civicrm_case'] = array(
'extends' => array('Case'),
'filters' => TRUE,
'title' => ts('Case'),
);
$this->_customGroupExtended['civicrm_activity'] = array(
'extends' => array('Activity'),
'filters' => TRUE,
'title' => ts('Activity'),
);
$this->_columns = $this->getColumns('Case', array(
'fields' => FALSE,
)
)
+ $this->getColumns('Contact', array())
+ $this->_columns = $this->getColumns('Activity', array(
'fields' => FALSE,
)
);
$this->_columns['civicrm_case']['fields']['id']['required'] = TRUE;
$this->_columns['civicrm_contact']['fields']['id']['required'] = TRUE;
// $this->_columns['civicrm_case']['fields']['id']['alter_display'] = 'alterCaseID';
$this->_columns['civicrm_case']['fields']['id']['title'] = 'Case';
$this->_columns['civicrm_contact']['fields']['gender_id']['no_display'] = TRUE;
$this->_columns['civicrm_contact']['fields']['gender_id']['title'] = 'Gender';
$this->_aggregateRowFields = array(
'case_civireport:id' => 'Case',
'civicrm_contact_civireport:gender_id' => 'Gender',
);
$this->_aggregateColumnHeaderFields = array(
'civicrm_contact_civireport:gender_id' => 'Gender',
);
$this->_tagFilter = TRUE;
$this->_groupFilter = TRUE;
parent::__construct();
}
/**
* Class constructor.
*/
public function __construct() {
$this->_columns = $this->getColumns('Contact')
+ $this->getColumns('Address')
+ $this->getColumns('Phone', array('subquery' => FALSE,))
+ $this->getColumns('Email')
+ $this->getColumns('Membership')
+ $this->getColumns('FinancialAccount')
+ $this->getColumns('LineItem')
+ array(
'civicrm_contribution' => array(
'dao' => 'CRM_Contribute_DAO_Contribution',
'fields' => array(
'receive_date' => array(
'default' => TRUE
),
'invoice_id' => array(
'title' => ts('Invoice ID'),
'default' => TRUE,
),
'contribution_status_id' => array(
'title' => ts('Contribution Status'),
'default' => TRUE,
),
'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'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Contribute_PseudoConstant::contributionStatus(),
'default' => array(1),
),
),
'order_bys' => array(
'contribution_id' => array('title' => ts('Contribution #')),
'contribution_status_id' => array('title' => ts('Contribution Status')),
),
'grouping' => 'contri-fields',
),)
+ array(
'civicrm_financial_trxn' => array(
'dao' => 'CRM_Financial_DAO_FinancialTrxn',
'fields' => array(
'check_number' => array(
'title' => ts('Cheque #'),
'default' => TRUE,
),
'payment_instrument_id' => array(
'title' => ts('Payment Instrument'),
'default' => TRUE,
'alter_display' => 'alterPaymentType',
),
'currency' => array(
'required' => TRUE,
'no_display' => TRUE,
),
'trxn_date' => array(
'title' => ts('Transaction Date'),
'default' => TRUE,
'type' => CRM_Utils_Type::T_DATE,
),
'trxn_id' => array(
'title' => ts('Trans #'),
'default' => TRUE,
),
),
'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,
),
'trxn_date' => array(
'title' => ts('Transaction Date'),
'operatorType' => CRM_Report_Form::OP_DATE,
'type' => CRM_Utils_Type::T_DATE,
),
),
'order_bys' => array(
'payment_instrument_id' => array('title' => ts('Payment Instrument')),
),
),
) + array(
'civicrm_entity_financial_trxn' => array(
'dao' => 'CRM_Financial_DAO_EntityFinancialTrxn',
'fields' => array(
'amount' => array(
'title' => ts('Amount'),
'default' => TRUE,
'type' => CRM_Utils_Type::T_STRING,
),
),
'filters' => array(
'amount' => array('title' => ts('Amount')),
),
),
);
$this->_groupFilter = TRUE;
$this->_tagFilter = TRUE;
parent::__construct();
}
/**
* Class constructor.
*/
public function __construct() {
$this->_columns = $this->getColumns('Event', array()) +
$this->getColumns('EventSummary');
parent::__construct();
}
/**
* Class constructor.
*/
public function __construct() {
$this->_autoIncludeIndexedFieldsAsOrderBys = 1;
// Check if CiviCampaign is a) enabled and b) has active campaigns
$config = CRM_Core_Config::singleton();
$campaignEnabled = in_array("CiviCampaign", $config->enableComponents);
if ($campaignEnabled) {
$getCampaigns = CRM_Campaign_BAO_Campaign::getPermissionedCampaigns(NULL, NULL, TRUE, FALSE, TRUE);
$this->activeCampaigns = $getCampaigns['campaigns'];
asort($this->activeCampaigns);
}
$this->_columns = array(
'civicrm_contact' => array_merge($this->getColumns('Contact'), array(
'dao' => 'CRM_Contact_DAO_Contact',
'fields' => array(
'sort_name' => array(
'title' => ts('Participant Name'),
'required' => TRUE,
'no_repeat' => TRUE,
'dbAlias' => 'contact_civireport.sort_name',
),
'first_name' => array(
'title' => ts('First Name'),
),
'last_name' => array(
'title' => ts('Last Name'),
),
'id' => array(
'no_display' => TRUE,
'required' => TRUE,
),
'gender_id' => array(
'title' => ts('Gender'),
),
'birth_date' => array(
'title' => ts('Birth Date'),
),
'age' => array(
'title' => ts('Age'),
'dbAlias' => 'TIMESTAMPDIFF(YEAR, contact_civireport.birth_date, CURDATE())',
),
'age_at_event' => array(
'title' => ts('Age at Event'),
'dbAlias' => 'TIMESTAMPDIFF(YEAR, contact_civireport.birth_date, event_civireport.start_date)',
),
'employer_id' => array(
'title' => ts('Organization'),
),
),
'grouping' => 'contact-fields',
'order_bys' => array(
'sort_name' => array(
'title' => ts('Last Name, First Name'),
'default' => '1',
'default_weight' => '0',
'default_order' => 'ASC',
),
'gender_id' => array(
'name' => 'gender_id',
'title' => ts('Gender'),
),
'birth_date' => array(
'name' => 'birth_date',
'title' => ts('Birth Date'),
),
'age_at_event' => array(
'name' => 'age_at_event',
'title' => ts('Age at Event'),
),
),
'filters' => array(
'sort_name' => array(
'title' => ts('Participant Name'),
'operator' => 'like',
),
'gender_id' => array(
'title' => ts('Gender'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Core_PseudoConstant::get('CRM_Contact_DAO_Contact', 'gender_id'),
),
'birth_date' => array(
'title' => 'Birth Date',
'operatorType' => CRM_Report_Form::OP_DATE,
'type' => CRM_Utils_Type::T_DATE,
),
),
)),
'civicrm_email' => array(
'dao' => 'CRM_Core_DAO_Email',
'fields' => array(
'email' => array(
'title' => ts('Email'),
'no_repeat' => TRUE,
),
),
'grouping' => 'contact-fields',
'filters' => array(
'email' => array(
'title' => ts('Participant E-mail'),
'operator' => 'like',
),
),
),
'civicrm_address' => array(
'dao' => 'CRM_Core_DAO_Address',
'fields' => array(
'street_address' => NULL,
'city' => NULL,
'postal_code' => NULL,
'state_province_id' => array(
'title' => ts('State/Province'),
),
'country_id' => array(
'title' => ts('Country'),
),
),
'grouping' => 'contact-fields',
),
'civicrm_participant' => array(
'dao' => 'CRM_Event_DAO_Participant',
'fields' => array(
'participant_id' => array('title' => 'Participant ID'),
'participant_record' => array(
'name' => 'id',
'no_display' => TRUE,
'required' => TRUE,
),
'event_id' => array(
'default' => TRUE,
'type' => CRM_Utils_Type::T_STRING,
),
'status_id' => array(
'title' => ts('Status'),
'default' => TRUE,
),
'role_id' => array(
'title' => ts('Role'),
'default' => TRUE,
),
'fee_currency' => array(
'required' => TRUE,
'no_display' => TRUE,
),
'participant_fee_level' => NULL,
'participant_fee_amount' => NULL,
'participant_register_date' => array('title' => ts('Registration Date')),
),
'grouping' => 'event-fields',
'filters' => array(
'event_id' => array(
'name' => 'event_id',
'title' => ts('Event'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => $this->getEventFilterOptions(),
),
'sid' => array(
'name' => 'status_id',
'title' => ts('Participant Status'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Event_PseudoConstant::participantStatus(NULL, NULL, 'label'),
),
'rid' => array(
'name' => 'role_id',
'title' => ts('Participant Role'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Event_PseudoConstant::participantRole(),
),
'participant_register_date' => array(
'title' => 'Registration Date',
'operatorType' => CRM_Report_Form::OP_DATE,
),
'fee_currency' => array(
'title' => ts('Fee Currency'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Core_OptionGroup::values('currencies_enabled'),
'default' => NULL,
'type' => CRM_Utils_Type::T_STRING,
),
),
'order_bys' => array(
'event_id' => array(
'title' => ts('Event'),
'default_weight' => '1',
'default_order' => 'ASC',
),
),
),
) +
$this->getColumns('Phone') + array(
'civicrm_event' => array(
'dao' => 'CRM_Event_DAO_Event',
'fields' => array(
'event_type_id' => array('title' => ts('Event Type')),
'event_start_date' => array('title' => ts('Event Start Date')),
),
'grouping' => 'event-fields',
'filters' => array(
'eid' => array(
'name' => 'event_type_id',
'title' => ts('Event Type'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Core_OptionGroup::values('event_type'),
),
'event_start_date' => array(
'title' => ts('Event Start Date'),
'operatorType' => CRM_Report_Form::OP_DATE,
),
),
'order_bys' => array(
'event_type_id' => array(
'title' => ts('Event Type'),
'default_weight' => '2',
'default_order' => 'ASC',
),
),
),
'civicrm_contribution' => array(
'dao' => 'CRM_Contribute_DAO_Contribution',
'fields' => array(
'contribution_id' => array(
'name' => 'id',
'no_display' => TRUE,
'required' => TRUE,
'csv_display' => TRUE,
'title' => ts('Contribution ID'),
),
'financial_type_id' => array('title' => ts('Financial Type')),
'receive_date' => array('title' => ts('Payment Date')),
'contribution_status_id' => array('title' => ts('Contribution Status')),
'payment_instrument_id' => array('title' => ts('Payment Type')),
'contribution_source' => array(
'name' => 'source',
'title' => ts('Contribution Source'),
),
'currency' => array(
'required' => TRUE,
'no_display' => TRUE,
),
'trxn_id' => NULL,
'honor_type_id' => array('title' => ts('Honor Type')),
'fee_amount' => array('title' => ts('Transaction Fee')),
'net_amount' => NULL,
),
'grouping' => 'contrib-fields',
'filters' => array(
'receive_date' => array(
'title' => 'Payment Date',
'operatorType' => CRM_Report_Form::OP_DATE,
),
'financial_type_id' => array(
'title' => ts('Financial Type'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Contribute_PseudoConstant::financialType(),
),
'currency' => array(
'title' => ts('Contribution Currency'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Core_OptionGroup::values('currencies_enabled'),
'default' => NULL,
'type' => CRM_Utils_Type::T_STRING,
),
'payment_instrument_id' => array(
'title' => ts('Payment Type'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Contribute_PseudoConstant::paymentInstrument(),
),
'contribution_status_id' => array(
'title' => ts('Contribution Status'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Contribute_PseudoConstant::contributionStatus(),
'default' => NULL,
),
),
),
'civicrm_line_item' => array(
'dao' => 'CRM_Price_DAO_LineItem',
'grouping' => 'priceset-fields',
'filters' => array(
'price_field_value_id' => array(
'name' => 'price_field_value_id',
'title' => ts('Fee Level'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => $this->getPriceLevels(),
),
),
),
)
+ $this->getColumns('Relationship', array(
'fields' => FALSE,
'filters' => FALSE,
'join_filters' => TRUE,
'group_by' => FALSE,
)) +
$this->getColumns('Contact', array(
'fields' => TRUE,
'join_fields' => TRUE,
'filters' => FALSE,
'prefix' => 'related_',
'prefix_label' => 'Related Contact ',
)) +
$this->getColumns('Email', array(
'prefix' => 'related_',
'prefix_label' => 'Related Contact ',
)) +
$this->getColumns('Phone', array(
'fields' => TRUE,
'join_fields' => TRUE,
'filters' => FALSE,
'prefix' => 'related_',
'prefix_label' => 'Related Contact ',
));
$this->_options = array(
'blank_column_begin' => array(
'title' => ts('Blank column at the Beginning'),
'type' => 'checkbox',
),
'blank_column_end' => array(
'title' => ts('Blank column at the End'),
'type' => 'select',
'options' => array(
'' => '-select-',
1 => ts('One'),
2 => ts('Two'),
3 => ts('Three'),
),
),
);
// If we have active campaigns add those elements to both the fields and filters
if ($campaignEnabled && !empty($this->activeCampaigns)) {
$this->_columns['civicrm_participant']['fields']['campaign_id'] = array(
'title' => ts('Campaign'),
'default' => 'false',
);
$this->_columns['civicrm_participant']['filters']['campaign_id'] = array(
'title' => ts('Campaign'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => $this->activeCampaigns,
);
$this->_columns['civicrm_participant']['order_bys']['campaign_id'] = array(
'title' => ts('Campaign'),
);
}
$this->_currencyColumn = 'civicrm_participant_fee_currency';
parent::__construct();
}
/**
* Class constructor.
*/
public function __construct() {
$this->_tagFilter = TRUE;
$this->_columns = $this->getColumns('Contact', array(
'prefix' => 'contact_a_',
'prefix_label' => 'Contact A ::'
))
+ $this->getColumns('Contact', array(
'prefix' => 'contact_b_',
'prefix_label' => 'Contact B ::',
))
+ $this->getColumns('Email', array(
'prefix' => 'contact_a_',
'prefix_label' => 'Contact A ::',
))
+ $this->getColumns('Email', array(
'prefix' => 'contact_b_',
'prefix_label' => 'Contact B ::',
))
+ $this->getColumns('Phone', array(
'prefix' => 'contact_a_',
'prefix_label' => 'Contact A ::',
'subquery' => FALSE,
))
+ $this->getColumns('Phone', array(
'prefix' => 'contact_b_',
'prefix_label' => 'Contact B ::',
'subquery' => FALSE,
))
+ $this->getColumns('Relationship') + array(
'civicrm_relationship_type' => array(
'dao' => 'CRM_Contact_DAO_RelationshipType',
'fields' => array(
'label_a_b' => array(
'title' => ts('Relationship A-B '),
'default' => TRUE
),
'label_b_a' => array(
'title' => ts('Relationship B-A '),
'default' => TRUE
)
),
'filters' => array(
'contact_type_a' => array(
'title' => ts('Contact Type A'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => $this->getContactTypeOptions(),
'type' => CRM_Utils_Type::T_STRING
),
'contact_type_b' => array(
'title' => ts('Contact Type B'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => $this->getContactTypeOptions(),
'type' => CRM_Utils_Type::T_STRING
),
),
'grouping' => 'relation-fields',
),
'civicrm_group' => array(
'dao' => 'CRM_Contact_DAO_Group',
'alias' => 'cgroup',
'filters' => array(
'gid' => array(
'name' => 'group_id',
'title' => ts('Group'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'group' => TRUE,
'options' => CRM_Core_PseudoConstant::group()
),
),
),
)
+ $this->getColumns('Case')
+ $this->getColumns('Address', array(
'prefix' => 'contact_a_',
'prefix_label' => 'Contact A ::',
)
)
+ $this->getColumns('Address', array(
'prefix' => 'contact_b_',
'prefix_label' => 'Contact B ::',
)
);
parent::__construct();
}
/**
* Class constructor.
*/
public function __construct() {
$yearsInPast = 8;
$yearsInFuture = 2;
$date = CRM_Core_SelectValues::date('custom', NULL, $yearsInPast, $yearsInFuture);
$count = $date['maxYear'];
while ($date['minYear'] <= $count) {
$optionYear[$date['minYear']] = $date['minYear'];
$date['minYear']++;
}
$this->_columns = array(
'civicrm_contact' => array(
'dao' => 'CRM_Contact_DAO_Contact',
'grouping' => 'contact-field',
'fields' => array(
'display_name' => array(
'title' => ts('Donor Name'),
'default' => TRUE,
'required' => TRUE,
),
),
'filters' => array(
'sort_name' => array(
'title' => ts('Donor Name'),
'operator' => 'like',
),
),
),
'civicrm_email' => array(
'dao' => 'CRM_Core_DAO_Email',
'grouping' => 'contact-field',
'fields' => array(
'email' => array(
'title' => ts('Email'),
'default' => TRUE,
),
),
),
'civicrm_phone' => array(
'dao' => 'CRM_Core_DAO_Phone',
'grouping' => 'contact-field',
'fields' => array(
'phone' => array(
'title' => ts('Phone No'),
'default' => TRUE,
),
),
),
'civicrm_pledge' => array(
'dao' => 'CRM_Pledge_DAO_Pledge',
'fields' => array(
'contact_id' => array(
'title' => ts('contactId'),
'no_display' => TRUE,
'required' => TRUE,
'no_repeat' => TRUE,
),
'amount' => array(
'title' => ts('Total Amount'),
'no_display' => TRUE,
'required' => TRUE,
'no_repeat' => TRUE,
),
'start_date' => array(
'title' => ts('Year'),
'no_display' => TRUE,
'required' => TRUE,
'no_repeat' => TRUE,
'type' => CRM_Utils_Type::T_INT,
),
),
'filters' => array(
'yid' => array(
'name' => 'start_date',
'title' => ts('This Year'),
'operatorType' => CRM_Report_Form::OP_SELECT,
'type' => CRM_Utils_Type::T_INT,
'options' => $optionYear,
'default' => date('Y'),
),
'status_id' => array(
'title' => ts('Pledge status'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Contribute_PseudoConstant::contributionStatus(),
'default' => array('1')
),
),
),
'civicrm_group' => array(
'dao' => 'CRM_Contact_DAO_GroupContact',
'alias' => 'cgroup',
'filters' => array(
'gid' => array(
'name' => 'group_id',
'title' => ts('Group'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'group' => TRUE,
'options' => CRM_Core_PseudoConstant::group()
),
),
),
);
$this->_tagFilter = TRUE;
parent::__construct();
}
/**
* Class constructor.
*/
public function __construct() {
$yearsInPast = 8;
$yearsInFuture = 2;
$date = CRM_Core_SelectValues::date('custom', NULL, $yearsInPast, $yearsInFuture);
$count = $date['maxYear'];
while ($date['minYear'] <= $count) {
$optionYear[$date['minYear']] = $date['minYear'];
$date['minYear']++;
}
$this->_columns = array(
'civicrm_contact' => array(
'dao' => 'CRM_Contact_DAO_Contact',
'grouping' => 'contact-field',
'fields' => array(
'display_name' => array(
'title' => ts('Donor Name'),
'default' => TRUE,
'required' => TRUE,
),
),
'filters' => array(
'sort_name' => array(
'title' => ts('Donor Name'),
'operator' => 'like',
),
),
),
'civicrm_email' => array(
'dao' => 'CRM_Core_DAO_Email',
'grouping' => 'contact-field',
'fields' => array(
'email' => array(
'title' => ts('Email'),
'default' => TRUE,
),
),
),
'civicrm_phone' => array(
'dao' => 'CRM_Core_DAO_Phone',
'grouping' => 'contact-field',
'fields' => array(
'phone' => array(
'title' => ts('Phone No'),
'default' => TRUE,
),
),
),
'civicrm_pledge' => array(
'dao' => 'CRM_Pledge_DAO_Pledge',
'fields' => array(
'contact_id' => array(
'title' => ts('contactId'),
'required' => TRUE,
'no_repeat' => TRUE,
'type' => CRM_Utils_Type::T_INT,
),
'amount' => array(
'title' => ts('Total Amount'),
'required' => TRUE,
'no_repeat' => TRUE,
'type' => CRM_Utils_Type::T_MONEY,
),
'start_date' => array(
'title' => ts('Start Date (within range)'),
'required' => TRUE,
'no_repeat' => TRUE,
'type' => CRM_Utils_Type::T_DATE,
),
),
'filters' => array(
'yid' => array(
'name' => 'start_date',
'title' => ts('Last Pledge Start Date'),
'type' => CRM_Utils_Type::T_DATE,
'operatorType' => CRM_Report_Form::OP_DATE,
'clause' => "pledge_civireport.contact_id IN
(SELECT distinct pledge.contact_id FROM civicrm_pledge pledge
WHERE pledge.start_date BETWEEN '\$from' AND '\$to' AND pledge.is_test = 0
)
AND pledge_civireport.contact_id NOT IN
(SELECT distinct pledge.contact_id FROM civicrm_pledge pledge
WHERE pledge.start_date >= ('\$to') AND pledge.is_test = 0) ",
),
'status_id' => array(
'title' => 'Pledge Status',
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Contribute_PseudoConstant::contributionStatus(),
'default' => array(
'1',
),
),
),
),
'civicrm_group' => array(
'dao' => 'CRM_Contact_DAO_GroupContact',
'alias' => 'cgroup',
'filters' => array(
'gid' => array(
'name' => 'group_id',
'title' => ts('Group'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'group' => TRUE,
'options' => CRM_Core_PseudoConstant::group()
)
)
)
);
$this->_tagFilter = TRUE;
parent::__construct();
}
