'id', // Governs the whole mozilla 'title' => t('CiviCRM Contacts'), 'help' => t("View displays CiviCRM Contacts, of people, organizations, etc."), ); //TABLE JOINS FOR CIVICRM CONTACTS GO HERE! $data['civicrm_contact']['table']['join'] = array( // Directly links to participants. 'civicrm_participant' => array( 'left_field' => 'contact_id', 'field' => 'id', ), // Directly links to contribution 'civicrm_contribution' => array( 'left_field' => 'contact_id', 'field' => 'id', ), // Directly links to activity. 'civicrm_activity' => array( 'left_field' => 'source_contact_id', 'field' => 'id', ), // Directly links to membership. 'civicrm_membership' => array( 'left_field' => 'contact_id', 'field' => 'id', ), // Link to mailing. 'civicrm_mailing' => array( 'left_table' => 'civicrm_mailing_event_queue', 'left_field' => 'contact_id', 'field' => 'id', ), ); // For other base tables, explain how we join - $data['civicrm_contact']['table']['join']['users'] = array( 'left_table' => 'civicrm_uf_match', 'left_field' => 'contact_id', 'field' => 'id', ); $data['civicrm_uf_match']['table']['join']['users'] = array( 'left_field' => 'uid', 'field' => 'uf_id', ); //CiviCRM Contacts - FIELDS //Numeric Contact ID $data['civicrm_contact']['id'] = array( 'title' => t('Contact ID'), 'help' => t('The numeric ID of the Contact'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); // Drupal ID of the contact (from uf_match.uf_id) $data['civicrm_contact']['drupal_id'] = array( 'real field' => 'id', 'title' => t('Drupal ID'), 'help' => t('Relates a CiviCRM Contact to the Druapl User Record'), 'field' => array( 'handler' => 'civicrm_handler_field_drupalid', 'click sortable' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), 'relationship' => array( 'base' => 'users', 'field' => 'uid', 'handler' => 'civicrm_handler_relationship_contact2users', 'label' => t('Drupal User'), ), ); //SORT Name for the Contact (Last Name followed by First) $data['civicrm_contact']['sort_name'] = array( 'title' => t('Sort Name'), 'help' => t('The Contact Name for sorting purposes, Last Name then First'), 'field' => array( 'handler' => 'civicrm_handler_field_contact_link', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //DISPLAY Name for the Contact (Full Name with Prefixes and Suffixes) $data['civicrm_contact']['display_name'] = array( 'title' => t('Display Name'), 'help' => t('Full Name of the Contact with prefixes and suffixes'), 'field' => array( 'handler' => 'civicrm_handler_field_contact_link', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Gender $data['civicrm_contact']['gender'] = array( 'title' => t('Gender'), 'real field' => 'gender_id', 'help' => t('Contact\'s Gender'), 'field' => array( 'handler' => 'civicrm_handler_field_gender', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_gender', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //FIRST NAME $data['civicrm_contact']['first_name'] = array( 'title' => t('First Name'), 'help' => t('First Name'), 'field' => array( 'handler' => 'civicrm_handler_field_contact_link', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //MIDDLE NAME $data['civicrm_contact']['middle_name'] = array( 'title' => t('Middle Name'), 'help' => t('Middle Name'), 'field' => array( 'handler' => 'civicrm_handler_field_contact_link', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //LAST NAME $data['civicrm_contact']['last_name'] = array( 'title' => t('Last Name'), 'help' => t('Last Name'), 'field' => array( 'handler' => 'civicrm_handler_field_contact_link', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : IS Deceased $data['civicrm_contact']['is_deceased'] = array( 'title' => t('Is Deceased'), 'help' => t('Is the contact deceased?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //THUMBSUP: Contact Permissions ie Do not email, do not this, do not that. //BOOLEAN : DO NOT EMAIL $data['civicrm_contact']['do_not_email'] = array( 'title' => t('Do Not E-mail'), 'help' => t('Does this contact not want to be emailed?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : DO NOT PHONE $data['civicrm_contact']['do_not_phone'] = array( 'title' => t('Do Not Phone'), 'help' => t('Does this contact not want to be phoned?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : DO NOT MAIL $data['civicrm_contact']['do_not_mail'] = array( 'title' => t('Do Not Mail'), 'help' => t('Does this contact not want to be mailed?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : DO NOT SMS $data['civicrm_contact']['do_not_sms'] = array( 'title' => t('Do Not Sms'), 'help' => t('Does this contact not want to receive messages?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : DO NOT TRADE $data['civicrm_contact']['do_not_trade'] = array( 'title' => t('Do Not Trade'), 'help' => t('Does this contact not want trade?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : Opted out of Bulk Mailing $data['civicrm_contact']['is_opt_out'] = array( 'title' => t('Opted Out of Bulk Mail'), 'help' => t('Has this contact opted out of bulk mail?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); // Organization Name $data['civicrm_contact']['organization_name'] = array( 'title' => t('Organization Name'), // The item it appears as on the UI, 'help' => t('The display name of the contact\'s organizations.'), // The help that appears on the UI, 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), 'argument' => array( 'handler' => 'views_handler_argument_string', ), ); // contact_type $data['civicrm_contact']['contact_type'] = array( 'title' => t('Contact Type'), // The item it appears as on the UI, 'help' => t('Contact Type'), // The help that appears on the UI, 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_contact_type', ), ); // add the other generic fields $objType = 'Individual'; $fields = CRM_Contact_BAO_Contact::exportableFields( $objType ); $skipFields = array( 'id' => 1, 'sort_name' => 1, 'display_name' => 1, 'gender' => 1, 'first_name' => 1, 'middle_name' => 1, 'last_name' => 1, 'is_deceased' => 1, 'do_not_email' => 1, 'do_not_phone' => 1, 'do_not_mail' => 1, 'do_not_trade' => 1, 'is_opt_out' => 1, 'contact_type' => 1, 'organization_name' => 1, ); civicrm_views_add_fields( $fields, $data['civicrm_contact'], $skipFields, 'civicrm_contact' ); // CHILLING OUT AT THE CIVICRM_ADDRESS TABLE $data['civicrm_address']['table']['group'] = t('CiviCRM Address'); // Explain how this table joins to others. $data['civicrm_address']['table']['join'] = array( // Directly links to contact table. 'civicrm_contact' => array( 'left_field' => 'id', 'field' => 'contact_id', ), ); //CiviCRM Address Using Contacts as a pitstop before going on to Participants $data['civicrm_address']['table']['join']['civicrm_participant'] = array( 'left_table' => 'civicrm_contact', 'left_field' => 'id', 'field' => 'contact_id', ); //CiviCRM Address Using Contacts as a pitstop before going on to Contributions $data['civicrm_address']['table']['join']['civicrm_contribution'] = array( 'left_table' => 'civicrm_contact', 'left_field' => 'id', 'field' => 'contact_id', ); //CiviCRM Address Using Contacts as a pitstop before going on to Activities $data['civicrm_address']['table']['join']['civicrm_activity'] = array( 'left_table' => 'civicrm_contact', 'left_field' => 'id', 'field' => 'contact_id', ); //CiviCRM Address Using Locations as a pitstop before going on to Events $data['civicrm_address']['table']['join']['civicrm_event'] = array( 'left_table' => 'civicrm_loc_block', 'left_field' => 'address_id', 'field' => 'id', ); //CiviCRM Address Using Contacts as a pitstop before going on to Memberships $data['civicrm_address']['table']['join']['civicrm_membership'] = array( 'left_table' => 'civicrm_contact', 'left_field' => 'id', 'field' => 'contact_id', ); $data['civicrm_address']['table']['join']['users'] = array( 'left_table' => 'civicrm_uf_match', 'left_field' => 'contact_id', 'field' => 'contact_id', ); //BOOLEAN : IS PRIMARY ADDRESS $data['civicrm_address']['is_primary'] = array( 'title' => t('Is Primary Address'), 'help' => t('Is this address the contact\'s primary address?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : IS BILLING ADDRESS $data['civicrm_address']['is_billing'] = array( 'title' => t('Is Billing Address'), 'help' => t('Is this address the contact\'s billing address?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //ADDRESS'S LOCATION TYPE $data['civicrm_address']['location_type'] = array( 'title' => t('Location Type'), 'real field' => 'location_type_id', 'help' => t('The Location of the Address for the Contact'), 'field' => array( 'handler' => 'civicrm_handler_field_location_type', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_location_type', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //FULL STREET ADDRESS $data['civicrm_address']['street_address'] = array( 'title' => t('Full Street Address'), 'help' => t('Full Street Address without Country, State or Postcode'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //FULL STREET ADDRESS SUPPLEMENTAL 1 $data['civicrm_address']['supplemental_address_1'] = array( 'title' => t('Supplemental Street Address'), 'help' => t('Supplemental Street Address such as Apartment or Suite Number or Department'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //CITY OR SUBURB THE ADDRESS IS AT $data['civicrm_address']['city'] = array( 'title' => t('City / Suburb'), 'help' => t('The City or Suburb the address is at'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //STATE OR PROVINCE $data['civicrm_address']['state_province'] = array( 'title' => t('State / Province'), 'real field' => 'state_province_id', 'help' => t('The State or Province of the Address'), 'field' => array( 'handler' => 'civicrm_handler_field_state', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_state', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //ZIP / POSTAL CODE $data['civicrm_address']['postal_code'] = array( 'title' => t('ZIP / Postal Code'), 'help' => t('ZIP / Postal Code of the Address'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Latitude or Geo Code 1 $data['civicrm_address']['geo_code_1'] = array( 'title' => t('Latitude'), 'help' => t('Latitude of the Address for mapping'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Longitude or Geo Code 2 $data['civicrm_address']['geo_code_2'] = array( 'title' => t('Longitude'), 'help' => t('Longitude of the Address for mapping'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //COUNTRY $data['civicrm_address']['country'] = array( 'title' => t('Country'), 'real field' => 'country_id', 'help' => t('The Country of the Address'), 'field' => array( 'handler' => 'civicrm_handler_field_country', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_country', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Address name $data['civicrm_address']['name'] = array( 'title' => t('Address Name'), 'help' => t('Be sure addres name is enabled '. l('In Global Settings','civicrm/admin/setting/preferences/address',array('query'=>'reset=1'))), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); // CHILLING OUT AT THE CIVICRM_EMAIL TABLE $data['civicrm_email']['table']['group'] = t('CiviCRM Email'); // Explain how this table joins to others. $data['civicrm_email']['table']['join'] = array( // Directly links to contact table. 'civicrm_contact' => array( 'left_field' => 'id', 'field' => 'contact_id', ), ); //CiviCRM Email Using Contacts as a pitstop before going on to Participants $data['civicrm_email']['table']['join']['civicrm_participant'] = array( 'left_table' => 'civicrm_contact', 'left_field' => 'id', 'field' => 'contact_id', ); //CiviCRM Email Using Contacts as a pitstop before going on to Contributions $data['civicrm_email']['table']['join']['civicrm_contribution'] = array( 'left_table' => 'civicrm_contact', 'left_field' => 'id', 'field' => 'contact_id', ); //CiviCRM Email Using Contacts as a pitstop before going on to Activities $data['civicrm_email']['table']['join']['civicrm_activity'] = array( 'left_table' => 'civicrm_contact', 'left_field' => 'id', 'field' => 'contact_id', ); //CiviCRM Email Using Locations as a pitstop before going on to Events $data['civicrm_email']['table']['join']['civicrm_event'] = array( 'left_table' => 'civicrm_loc_block', 'left_field' => 'email_id', 'field' => 'id', ); //CiviCRM Email Using Contacts as a pitstop before going on to Memberhsips $data['civicrm_email']['table']['join']['civicrm_membership'] = array( 'left_table' => 'civicrm_contact', 'left_field' => 'id', 'field' => 'contact_id', ); //Display E-mails in User Views $data['civicrm_email']['table']['join']['users'] = array( 'left_table' => 'civicrm_uf_match', 'left_field' => 'contact_id', 'field' => 'contact_id', ); //BOOLEAN : IS PRIMARY EMAIL $data['civicrm_email']['is_primary'] = array( 'title' => t('Is Primary Email'), 'help' => t('Is this address the contact\'s primary email?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : IS BILLING EMAIL $data['civicrm_email']['is_billing'] = array( 'title' => t('Is Billing Email'), 'help' => t('Is this address the contact\'s billing email?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //EMAIL'S LOCATION TYPE $data['civicrm_email']['location_type'] = array( 'title' => t('Location Type'), 'real field' => 'location_type_id', 'help' => t('The Location of the Address for the Contact'), 'field' => array( 'handler' => 'civicrm_handler_field_location_type', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_location_type', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //FULL EMAIL ADDRESS $data['civicrm_email']['email'] = array( 'title' => t('Email Address'), 'help' => t('Email Address'), 'field' => array( 'handler' => 'civicrm_handler_field_email', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); // CHILLING OUT AT THE CIVICRM_PHONE TABLE $data['civicrm_phone']['table']['group'] = t('CiviCRM Phone Details'); // Explain how this table joins to others. $data['civicrm_phone']['table']['join'] = array( // Directly links to contact table. 'civicrm_contact' => array( 'left_field' => 'id', 'field' => 'contact_id', ), ); //CiviCRM Phone Using Contacts as a pitstop before going on to Participants $data['civicrm_phone']['table']['join']['civicrm_participant'] = array( 'left_table' => 'civicrm_contact', 'left_field' => 'id', 'field' => 'contact_id', ); //CiviCRM Phone Using Contacts as a pitstop before going on to Contributions $data['civicrm_phone']['table']['join']['civicrm_contribution'] = array( 'left_table' => 'civicrm_contact', 'left_field' => 'id', 'field' => 'contact_id', ); //CiviCRM Phone Using Contacts as a pitstop before going on to Activities $data['civicrm_phone']['table']['join']['civicrm_activity'] = array( 'left_table' => 'civicrm_contact', 'left_field' => 'id', 'field' => 'contact_id', ); //CiviCRM Phone Using Locations as a pitstop before going on to Events $data['civicrm_phone']['table']['join']['civicrm_event'] = array( 'left_table' => 'civicrm_loc_block', 'left_field' => 'phone_id', 'field' => 'id', ); //CiviCRM Phone Using Contacts as a pitstop before going on to Memberhsips $data['civicrm_phone']['table']['join']['civicrm_membership'] = array( 'left_table' => 'civicrm_contact', 'left_field' => 'id', 'field' => 'contact_id', ); //Display Phone Details in User Views $data['civicrm_phone']['table']['join']['users'] = array( 'left_table' => 'civicrm_uf_match', 'left_field' => 'contact_id', 'field' => 'contact_id', ); //BOOLEAN : IS PRIMARY EMAIL $data['civicrm_phone']['is_primary'] = array( 'title' => t('Is Primary Phone'), 'help' => t('Is this the contact\'s primary phone?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : IS BILLING EMAIL $data['civicrm_phone']['is_billing'] = array( 'title' => t('Is Billing Phone'), 'help' => t('Is this the contact\'s billing phone?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //PHONE'S LOCATION TYPE $data['civicrm_phone']['location_type'] = array( 'title' => t('Location Type'), 'real field' => 'location_type_id', 'help' => t('The Location of the Phone for the Contact'), 'field' => array( 'handler' => 'civicrm_handler_field_location_type', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_location_type', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //FULL PHONE NUMBER $data['civicrm_phone']['phone'] = array( 'title' => t('Phone Number'), 'help' => t('Full Phone Number'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //TODO: Mobile Provider //PHONE TYPE , Phone, Mobile, Fax or Pager $data['civicrm_phone']['phone_type'] = array( 'title' => t('Phone Type'), 'real field' => 'phone_type_id', 'help' => t('The Type, either Phone, Mobile, Fax or Pager'), 'field' => array( 'handler' => 'civicrm_handler_field_phone_type', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_phone_type', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //---------------------------------------------------------------- // CIVICRM Events Be next bro! It's A BASE TABLE //---------------------------------------------------------------- $data['civicrm_event']['table']['group'] = t('CiviCRM Events'); $data['civicrm_event']['table']['base'] = array( 'field' => 'id', // Governs the whole mozilla 'title' => t('CiviCRM Events'), 'help' => t("View displays CiviCRM Events"), ); //TABLE JOINS FOR CIVICRM EVENTS GO HERE! $data['civicrm_event']['table']['join'] = array( // Directly links to contact table. 'civicrm_participant' => array( 'left_field' => 'event_id', 'field' => 'id', ), ); // Numeric Event ID $data['civicrm_event']['id'] = array( 'title' => t('Event ID'), 'help' => t('The numeric ID of the Event'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Event Type $data['civicrm_event']['event_type'] = array( 'title' => t('Event Type'), 'real field' => 'event_type_id', 'help' => t('The Event Type'), 'field' => array( 'handler' => 'civicrm_handler_field_event_type', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_event_type', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : IS EVENT PUBLIC $data['civicrm_event']['is_public'] = array( 'title' => t('Is Public'), 'help' => t('Has this event been made public?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : IS EVENT ACTIVE $data['civicrm_event']['is_active'] = array( 'title' => t('Is Active'), 'help' => t('Has this event been made active?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //EVENT TITLE $data['civicrm_event']['title'] = array( 'title' => t('Title'), 'help' => t('The Event\'s Title'), 'field' => array( 'handler' => 'civicrm_handler_field_event_link', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); // EVENT SUMMARY $data['civicrm_event']['summary'] = array( 'title' => t('Summary'), 'help' => t('The Event\'s Summary'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), ); // EVENT DESCRIPTION $data['civicrm_event']['description'] = array( 'title' => t('Description'), 'help' => t('The Event\'s Full Description'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), ); //EVENT Start DATE $data['civicrm_event']['start_date'] = array( 'title' => t('Start Date'), 'help' => t('The Event\'s Start Date'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_event'],array('title' =>'Start Date', 'name' => 'start_date')); //EVENT END DATE $data['civicrm_event']['end_date'] = array( 'title' => t('End Date'), 'help' => t('The Event\'s End Date'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_event'],array('title' =>'End Date', 'name' => 'end_date')); //BOOLEAN : IS ONLINE REGISTRATION ENABLED $data['civicrm_event']['is_online_registration'] = array( 'title' => t('Is Online Registration On'), 'help' => t('Is Online Registration enabled for the event?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //EVENT ONLINE REGISTRATION START DATE $data['civicrm_event']['registration_start_date'] = array( 'title' => t('Registration Start Date'), 'help' => t('The Event\'s Online Registration Start Date'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_event'],array('title' =>'Registration Start Date', 'name' => 'registration_start_date')); //EVENT ONLINE REGISTRATION END DATE $data['civicrm_event']['registration_end_date'] = array( 'title' => t('Registration End Date'), 'help' => t('The Event\'s Online Registration End Date'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_event'],array('title' =>'Registration End Date', 'name' => 'registration_end_date')); // CHILLING OUT AT THE CIVICRM_LOC_BLOCK TABLE $data['civicrm_loc_block']['table']['group'] = t('CiviCRM Locations'); // Explain how this table joins to others. $data['civicrm_loc_block']['table']['join'] = array( // Directly links to event table 'civicrm_event' => array( 'left_field' => 'loc_block_id', 'field' => 'id', ), ); //---------------------------------------------------------------- // CIVICRM Participants are here, base tabling it up. //---------------------------------------------------------------- $data['civicrm_participant']['table']['group'] = t('CiviCRM Participants'); $data['civicrm_participant']['table']['base'] = array( 'field' => 'id', // Governs the whole mozilla 'title' => t('CiviCRM Participants'), 'help' => t("View displays CiviCRM Participants, often in conjunction with Event Filters"), ); //TABLE JOINS FOR CIVICRM PARTICIPANTS GO HERE! //CiviCRM Participants - FIELDS //Numeric Event ID $data['civicrm_participant']['id'] = array( 'title' => t('Participant ID'), 'help' => t('The numeric ID of the Participant'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Numeric Contact ID $data['civicrm_participant']['contact_id'] = array( 'title' => t('Participant\'s Contact ID'), 'help' => t('The numeric ID of the Contact of the Participant'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), 'relationship' => array( 'base' => 'civicrm_contact', 'field' => 'id', 'handler' => 'views_handler_relationship', 'label' => t('CiviCRM Contact, with custom fields'), ), ); //Participant Status $data['civicrm_participant']['status'] = array( 'title' => t('Participant Status'), 'real field' => 'status_id', 'help' => t('The Status of the Participant\'s Booking and Attendance'), 'field' => array( 'handler' => 'civicrm_handler_field_participant_status', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_participant_status', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Participant Role $data['civicrm_participant']['role'] = array( 'title' => t('Participant Role'), 'real field' => 'role_id', 'help' => t('The Role the Participant is registered for.'), 'field' => array( 'handler' => 'civicrm_handler_field_participant_role', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_participant_role', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Source $data['civicrm_participant']['source'] = array( 'title' => t('Source'), 'help' => t('Where did this registration come from?'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Participant Registration Date $data['civicrm_participant']['register_date'] = array( 'title' => t('Register Date'), 'help' => t('The Date the participant Registered for the Event'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_participant'],array('title' =>'Register Date', 'name' => 'register_date')); //BOOLEAN : IS SET TO PAY LATER $data['civicrm_participant']['is_pay_later'] = array( 'title' => t('Is Pay Later'), 'help' => t('Opted to Pay Later after Registration, and is still pending payment.'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); // Registered by ID - Participant ID of the person who made the registration $data['civicrm_participant']['registered_by_id'] = array( 'title' => t('Registered by ID'), 'help' => t('The numeric ID of the Participant who registered this Participant'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), 'relationship' => array( 'base' => 'civicrm_participant', 'field' => 'id', 'handler' => 'views_handler_relationship', 'label' => t('CiviCRM Source Record Contact'), ), ); //Fee Level $data['civicrm_participant']['fee_level'] = array( 'title' => t('Fee Level'), 'help' => t('The Fee Level the Participant is registered for.'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); // Fee Amount , the amount the Participant has paid or will have to pay. $data['civicrm_participant']['fee_amount'] = array( 'title' => t('Fee Amount'), 'help' => t('The amount the Participant has paid or will have to pay.'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); // HOP SCOTCHING OUR WAY THROUGH THE CIVICRM_PARTICIPANT_PAYMENT // Explain how this table joins to others. $data['civicrm_participant_payment']['table']['join'] = array( // Directly links to event table 'civicrm_participant' => array( 'left_field' => 'id', 'field' => 'participant_id', ), ); //---------------------------------------------------------------- // CIVICRM Contributions are here with all the bling, base tabling it up. //---------------------------------------------------------------- $data['civicrm_contribution']['table']['group'] = t('CiviCRM Contributions'); $data['civicrm_contribution']['table']['base'] = array( 'field' => 'id', // Governs the whole mozilla 'title' => t('CiviCRM Contributions'), 'help' => t("View displays CiviCRM Contributions, with relation to contacts."), ); //TABLE JOINS FOR CIVICRM CONTRIBUTIONS GO HERE! $data['civicrm_contribution']['table']['join']['civicrm_participant'] = array( 'left_table' => 'civicrm_participant_payment', 'left_field' => 'contribution_id', 'field' => 'id', ); //CiviCRM Contributions - FIELDS //Numeric Contribution ID $data['civicrm_contribution']['id'] = array( 'title' => t('Contribution ID'), 'help' => t('The numeric ID of the Contribution'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Contribution Type $data['civicrm_contribution']['contribution_type'] = array( 'title' => t('Contribution Type'), 'real field' => 'contribution_type_id', 'help' => t('The Type of Contribution made, ie Member Dues, Event Fees etc'), 'field' => array( 'handler' => 'civicrm_handler_field_contribution_type', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_contribution_type', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Contribution Page $data['civicrm_contribution']['contribution_page'] = array( 'title' => t('Contribution Page'), 'real field' => 'contribution_page_id', 'help' => t('The Page this Contribution came from'), 'field' => array( 'handler' => 'civicrm_handler_field_contribution_page', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_contribution_page', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Payment Instrument Used $data['civicrm_contribution']['payment_instrument'] = array( 'title' => t('Payment Instrument'), 'real field' => 'payment_instrument_id', 'help' => t('The Payment Instrument Used for the Contribution'), 'field' => array( 'handler' => 'civicrm_handler_field_payment_instrument', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_payment_instrument', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Contribution Receive Date $data['civicrm_contribution']['receive_date'] = array( 'title' => t('Receive Date'), 'help' => t('The Date the Contribution was received / paid'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_contribution'],array('title' =>'Receive Date', 'name' => 'receive_date')); //Non Deductible Amount of Contribution $data['civicrm_contribution']['non_deductible_amount'] = array( 'title' => t('Non Deductible Amount'), 'help' => t('The Non Deductible Part of the Contribution'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); $data['civicrm_contribution']['total_amount'] = array( 'title' => t('Total Amount'), 'help' => t('The Total Contribution made by the Contact'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); $data['civicrm_contribution']['fee_amount'] = array( 'title' => t('Fee Amount'), 'help' => t('The fee charged by the Payment Processor for the transaction.'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); $data['civicrm_contribution']['net_amount'] = array( 'title' => t('Net Amount'), 'help' => t('The Full Contribution minus Payment Processor Fees.'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Transaction ID $data['civicrm_contribution']['trxn_id'] = array( 'title' => t('Transaction ID'), 'help' => t('Unique Transaction ID from Payment Processor / Bank etc'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Invoice ID $data['civicrm_contribution']['invoice_id'] = array( 'title' => t('Invoice ID'), 'help' => t('Unique Invoice ID from system'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Currency $data['civicrm_contribution']['currency'] = array( 'title' => t('Currency'), 'help' => t('Currency used for the Contribution'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Contribution Cancellation Date $data['civicrm_contribution']['cancel_date'] = array( 'title' => t('Cancellation Date'), 'help' => t('The Date the Contribution was cancelled (if it was)'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_contribution'],array('title' =>'Cancel Date', 'name' => 'cancel_date')); //Cancellation Reason $data['civicrm_contribution']['cancel_reason'] = array( 'title' => t('Cancellation Reason'), 'help' => t('The Reason for the Contribution Cancellation'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Contribution Receipt Date $data['civicrm_contribution']['receipt_date'] = array( 'title' => t('Receipt Date'), 'help' => t('The Date a receipt for the contribution was sent.'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_contribution'],array('title' =>'Receipt Date', 'name' => 'receipt_date')); //Contribution Thank You Date $data['civicrm_contribution']['thankyou_date'] = array( 'title' => t('Thank You Date'), 'help' => t('The Date a thank you to the donor for the contribution was sent.'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_contribution'],array('title' =>'Thank You Date', 'name' => 'thankyou_date')); //Contribution Source $data['civicrm_contribution']['source'] = array( 'title' => t('Source'), 'help' => t('Where the Contribution came through.'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Contribution Status $data['civicrm_contribution']['contribution_status'] = array( 'title' => t('Contribution Status'), 'real field' => 'contribution_status_id', 'help' => t('The Status of this Contribution'), 'field' => array( 'handler' => 'civicrm_handler_field_contribution_status', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_contribution_status', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //TODO: CONTRIBUTION RECURRING STUFF + HONOR_CONTACT_ID + HONOR_TYPE_ID //BOOLEAN : IS A TEST CONTRIBUTION $data['civicrm_contribution']['is_test'] = array( 'title' => t('Is Test'), 'help' => t('Is the contribution a test entry?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : IS SET TO PAY LATER $data['civicrm_contribution']['is_pay_later'] = array( 'title' => t('Is Pay Later'), 'help' => t('Opted to Pay Contribution Later, and is still pending payment.'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //---------------------------------------------------------------------------------------- // CIVICRM Activities are here with all the activeness they can muster, base tabling it up. //---------------------------------------------------------------------------------------- $data['civicrm_activity']['table']['group'] = t('CiviCRM Activities'); $data['civicrm_activity']['table']['base'] = array( 'field' => 'id', // Governs the whole mozilla 'title' => t('CiviCRM Activities'), 'help' => t("View displays CiviCRM Activities"), ); //TABLE JOINS FOR CIVICRM ACTIVITIES GO HERE! //CiviCRM Activities - FIELDS //Numeric Activity ID $data['civicrm_activity']['id'] = array( 'title' => t('Activity ID'), 'help' => t('The numeric ID of the Activity Instance'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); $data['civicrm_activity']['source_contact_id'] = array( 'title' => t('Source Contact'), 'help' => t('The contact who scheduled this activity'), 'relationship' => array( 'base' => 'civicrm_contact', 'field' => 'id', 'handler' => 'views_handler_relationship', 'label' => t('CiviCRM Source Contact'), ), ); $data['civicrm_activity']['source_record_id'] = array( 'title' => t('Source Record ID'), 'help' => t('The contact who made this activity'), 'relationship' => array( 'base' => 'civicrm_contact', 'field' => 'id', 'handler' => 'views_handler_relationship', 'label' => t('CiviCRM Source Record Contact'), ), ); //Activity Type $data['civicrm_activity']['activity_type'] = array( 'title' => t('Activity Type'), 'real field' => 'activity_type_id', 'help' => t('The Type of Activity'), 'field' => array( 'handler' => 'civicrm_handler_field_activity_type', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_activity_type', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Activity Status $data['civicrm_activity']['status'] = array( 'title' => t('Activity Status'), 'real field' => 'status_id', 'help' => t('The Status of this Activity'), 'field' => array( 'handler' => 'civicrm_handler_field_activity_status', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_activity_status', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Activity Subject $data['civicrm_activity']['subject'] = array( 'title' => t('Subject'), 'help' => t('A short description of the activity..'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Scheduled Activity Date $data['civicrm_activity']['activity_date_time'] = array( 'title' => t('Scheduled Activity Date'), 'help' => t('The Date and Time the activity is scheduled to happen.'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_activity'],array('title' =>'Scheduled Activity Date', 'name' => 'activity_date_time')); //Activity Duration $data['civicrm_activity']['duration'] = array( 'title' => t('Duration (min)'), 'help' => t('The Activity\'s Duration in Minutes'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Activity Location $data['civicrm_activity']['location'] = array( 'title' => t('Location'), 'help' => t('Activity\'s Location in a text string.'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Activity Details / Notes $data['civicrm_activity']['details'] = array( 'title' => t('Details'), 'help' => t('Details and Notes regarding the activity.'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : IS A TEST ACTIVITY $data['civicrm_activity']['is_test'] = array( 'title' => t('Is Test'), 'help' => t('Is the activity a test entry?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); // CHILLING OUT AT THE CIVICRM_ACTIVTY_ASSIGNMENT TABLE $data['civicrm_activity_assignment']['table']['group'] = t('CiviCRM Activity Assignments'); // Explain how this table joins to others. $data['civicrm_activity_assignment']['table']['join'] = array( // Directly links to event table 'civicrm_activity' => array( 'left_field' => 'id', 'field' => 'activity_id', ), ); $data['civicrm_activity_assignment']['assignee_contact_id'] = array( 'title' => t('Assignee Contact ID'), 'help' => t('The contact who is assigned the activity.'), 'relationship' => array( 'base' => 'civicrm_contact', 'field' => 'id', 'handler' => 'views_handler_relationship', 'label' => t('CiviCRM Assignee Contact ID'), ), ); // CHILLING OUT AT THE CIVICRM_ACTIVTY_ASSIGNMENT TABLE $data['civicrm_activity_target']['table']['group'] = t('CiviCRM Activity Targets'); // Explain how this table joins to others. $data['civicrm_activity_target']['table']['join'] = array( // Directly links to event table 'civicrm_activity' => array( 'left_field' => 'id', 'field' => 'activity_id', ), ); $data['civicrm_activity_target']['target_contact_id'] = array( 'title' => t('Target Contact ID'), 'help' => t('The contact who is the activity\'s target.'), 'relationship' => array( 'base' => 'civicrm_contact', 'field' => 'id', 'handler' => 'views_handler_relationship', 'label' => t('CiviCRM Target Contact ID'), ), ); //TEXT LINKS THAT AREN'T PART OF THE TABLE //Contact Text Link $data['civicrm_contact']['text_link'] = array( 'field' => array( 'title' => t('Text Link'), 'help' => t('Creates a Text Link for various contact actions.'), 'handler' => 'civicrm_handler_field_link_contact', ), ); //Event Text Link $data['civicrm_event']['text_link'] = array( 'field' => array( 'title' => t('Text Link'), 'help' => t('Creates a Text Link for various event actions.'), 'handler' => 'civicrm_handler_field_link_event', ), ); //Participant Text Link $data['civicrm_participant']['text_link'] = array( 'field' => array( 'title' => t('Text Link'), 'help' => t('Creates a Text Link for various participant actions.'), 'handler' => 'civicrm_handler_field_link_participant', ), ); //Contribution Text Link $data['civicrm_contribution']['text_link'] = array( 'field' => array( 'title' => t('Text Link'), 'help' => t('Creates a Text Link for various contribution actions.'), 'handler' => 'civicrm_handler_field_link_contribution', ), ); //---------------------------------------------------------------- // CIVICRM Relationships are here with all the connections, base tabling it up. //---------------------------------------------------------------- $data['civicrm_relationship']['table']['group'] = t('CiviCRM Relationships'); $data['civicrm_relationship']['table']['base'] = array( 'field' => 'id', // Governs the whole mozilla 'title' => t('CiviCRM Relationships'), 'help' => t("View displays CiviCRM Relationships, with connection to contacts."), ); //TABLE JOINS FOR CIVICRM RELATIONSHIPS GO HERE! $data['civicrm_relationship']['table']['join'] = array( // Directly links to contact table - link A 'civicrm_contact' => array( 'left_field' => 'id', 'field' => 'contact_id_a', ), // Directly links to contact table - link B also. // 'civicrm_contact' => array( // 'left_field' => 'id', // 'field' => 'contact_id_b', // ), ); //Display A->B relationships in User Views $data['civicrm_relationship']['table']['join']['users'] = array( 'left_table' => 'civicrm_uf_match', 'left_field' => 'contact_id', 'field' => 'contact_id_a', ); //CiviCRM Relationships - FIELDS //Numeric Relationship ID $data['civicrm_relationship']['id'] = array( 'title' => t('Relationship ID'), 'help' => t('The numeric ID of the Relationship'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Relationship Type $data['civicrm_relationship']['relationship_type'] = array( 'title' => t('Relationship Type A-to-B'), 'real field' => 'relationship_type_id', 'help' => t('The Type of Relationship, i.e. Employee of, Household Head for...'), 'field' => array( 'handler' => 'civicrm_handler_field_relationship_type', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_relationship_type', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); $data['civicrm_relationship']['contact_id_a'] = array( 'title' => t('Contact ID A'), 'help' => t('The contact A'), 'relationship' => array( 'base' => 'civicrm_contact', 'field' => 'id', 'handler' => 'views_handler_relationship', 'label' => t('CiviCRM Contact A'), ), ); $data['civicrm_relationship']['contact_id_b'] = array( 'title' => t('Contact ID B'), 'help' => t('The contact B'), 'relationship' => array( 'base' => 'civicrm_contact', 'field' => 'id', 'handler' => 'views_handler_relationship', 'label' => t('CiviCRM Contact B'), ), ); $data['civicrm_relationship']['description'] = array( 'title' => t('Description'), 'help' => t('Description of the relationship'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Relationship start date $data['civicrm_relationship']['start_date'] = array( 'title' => t('Start Date'), 'help' => t('The Relationship\'s Start Date'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_relationship'],array('title' =>'Start Date', 'name' => 'start_date')); //Relationship end date $data['civicrm_relationship']['end_date'] = array( 'title' => t('End Date'), 'help' => t('The Relationship\'s End Date'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_replationship'],array('title' =>'AEnd Date', 'name' => 'end_date')); //BOOLEAN : IS RELATIONSHIP ACTIVE $data['civicrm_relationship']['is_active'] = array( 'title' => t('Is Relationship Active'), 'help' => t('Is the Relationship active?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //---------------------------------------------------------------- // CIVICRM Memberships are here with all the connections. //---------------------------------------------------------------- $data['civicrm_membership']['table']['group'] = t('CiviCRM Member'); $data['civicrm_membership']['table']['base'] = array( 'field' => 'id', // Governs the whole mozilla 'title' => t('CiviCRM Memberships'), 'help' => t("View displays CiviCRM Memberships, with connection to contacts."), ); $data['civicrm_membership']['table']['join'] = array( // Directly links to contact table - link A 'civicrm_contact' => array( 'left_field' => 'id', 'field' => 'contact_id', ) ); //Display Memberships in User Views $data['civicrm_membership']['table']['join']['users'] = array( 'left_table' => 'civicrm_uf_match', 'left_field' => 'contact_id', 'field' => 'contact_id', ); //CiviCRM Memberships - FIELDS //Numeric Membership ID $data['civicrm_membership']['id'] = array( 'title' => t('Membership ID'), 'help' => t('The numeric ID of the Membership'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Membership Type $data['civicrm_membership']['membership_type'] = array( 'title' => t('Membership Type'), 'real field' => 'membership_type_id', 'help' => t('The Type of Membership'), 'field' => array( 'handler' => 'civicrm_handler_field_membership_type', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_membership_type', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Membership Join date $data['civicrm_membership']['join_date'] = array( 'title' => t('Join Date'), 'help' => t('The Membership\'s Start Date'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_membership'],array('title' =>'Join Date', 'name' => 'join_date')); //Membership start date $data['civicrm_membership']['start_date'] = array( 'title' => t('Start Date'), 'help' => t('The Membership\'s Start Date'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_membership'],array('title' =>'Start Date', 'name' => 'start_date')); //Membership end date $data['civicrm_membership']['end_date'] = array( 'title' => t('End Date'), 'help' => t('The Membership\'s End Date'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_membership'],array('title' =>'End Date', 'name' => 'end_date')); //membership Source $data['civicrm_membership']['source'] = array( 'title' => t('Source'), 'help' => t('Source of the relationship'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Membership Status $data['civicrm_membership']['status'] = array( 'title' => t('Status'), 'real field' => 'status_id', 'help' => t('The Status of the Membership'), 'field' => array( 'handler' => 'civicrm_handler_field_membership_status', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_membership_status', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : IS Status Overridden $data['civicrm_membership']['is_override'] = array( 'title' => t('Status overridden?'), 'help' => t('Is the membership status overridden?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Membership end date $data['civicrm_membership']['reminder_date'] = array( 'title' => t('Reminder Date'), 'help' => t('The Membership\'s Reminder Date'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_date', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_membership'],array('title' =>'Reminder Date', 'name' => 'reminder_date')); //Numeric Membership Owner ID $data['civicrm_membership']['owner_membership_id'] = array( 'title' => t('Membership Owner ID'), 'help' => t('The numeric ID Contact that owns the membership'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : IS test membership $data['civicrm_membership']['is_test'] = array( 'title' => t('Test Membership?'), 'help' => t('Is this a test membership?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //BOOLEAN : IS Pay later $data['civicrm_membership']['is_pay_later'] = array( 'title' => t('Is Pay Later'), 'help' => t('Is the Membership pay later?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); /* * Add support for CivicRM groups table */ $data['civicrm_group']['table']['group'] = t('CiviCRM Groups'); $data['civicrm_group']['table']['join']['civicrm_contact'] = array( 'left_table' => 'civicrm_group_contact', 'left_field' => 'group_id', 'field' => 'id', ); $data['civicrm_group_contact']['table']['join']['civicrm_contact'] = array( // Directly links to group table 'left_field' => 'id', 'field' => 'contact_id', ); //CiviCRM Groups - FIELDS //Numeric Group ID $data['civicrm_group']['id'] = array( 'title' => t('Group ID'), 'help' => t('The numeric ID of the Group'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Is Group Active? $data['civicrm_group']['is_active'] = array( 'title' => t('Is Active'), 'help' => t('Is the Group Active'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); $data['civicrm_group']['title'] = array( 'title' => t('Title'), 'help' => t('Group Title'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_group_title', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); $data['civicrm_group']['description'] = array( 'title' => t('Description'), 'help' => t('Description of the Group'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); /* * Add support for CivicRM tags */ $data['civicrm_tag']['table']['group'] = t('CiviCRM Tags'); $data['civicrm_tag']['table']['join']['civicrm_contact'] = array( 'left_table' => 'civicrm_entity_tag', 'left_field' => 'tag_id', 'field' => 'id', ); $data['civicrm_entity_tag']['table']['join']['civicrm_contact'] = array( // Directly links to group table 'left_field' => 'id', 'field' => 'contact_id', ); //CiviCRM Groups - FIELDS //Numeric Group ID $data['civicrm_tag']['id'] = array( 'title' => t('Tag ID'), 'help' => t('The numeric ID of the Group'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); $data['civicrm_tag']['name'] = array( 'title' => t('Name'), 'help' => t('Name of Tag'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_tag_title', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); $data['civicrm_tag']['description'] = array( 'title' => t('Description'), 'help' => t('Description of the Tag'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); /* * CivicRM Mailings tables */ $data['civicrm_mailing']['table']['group'] = t('CiviCRM Mailings'); $data['civicrm_mailing']['table']['base'] = array( 'field' => 'id', // Governs the whole mozilla 'title' => t('CiviCRM Mailings'), 'help' => t("View displays CiviCRM Mailing Results."), ); $data['civicrm_mailing_event_queue']['table']['join'] = array( // Directly links to contact table - link A 'civicrm_mailing' => array( 'left_table' =>'civicrm_mailing_job', 'left_field' => 'id', 'field' => 'job_id', ) ); //CiviCRM Mailing - FIELDS //Mailing Name $data['civicrm_mailing']['name'] = array( 'title' => t('Name'), 'help' => t('Title of the mailing'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_mailing_name', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Mailing Subject line $data['civicrm_mailing']['subject'] = array( 'title' => t('Subject Line'), 'help' => t('Subject Line of the mailing'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Mailing From e-mail $data['civicrm_mailing']['from_email'] = array( 'title' => t('From Email'), 'help' => t('From Email of the mailing'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Mailing reply to e-mail $data['civicrm_mailing']['replyto_email'] = array( 'title' => t('Reply to Email'), 'help' => t('Reply Email of the mailing'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Does the mailng track click throughs $data['civicrm_mailing']['url_tracking'] = array( 'title' => t('Track URLs?'), 'help' => t('Does the mailing track click throughs?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Does the e-mail track opens $data['civicrm_mailing']['open_tracking'] = array( 'title' => t('Track Opens?'), 'help' => t('Does the mailing track Open Rate?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //has mailing been sent $data['civicrm_mailing']['is_completed'] = array( 'title' => t('Complete?'), 'help' => t('Is the mailing completely sent?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Mialing Job table $data['civicrm_mailing_job']['table']['group'] = ts('CiviCRM Mailing Job'); $data['civicrm_mailing_job']['table']['join'] = array( // link to civicrm_mailing 'civicrm_mailing' => array( 'left_field' => 'id', 'field' => 'mailing_id', ) ); //When is the mailing sceduled to go out $data['civicrm_mailing_job']['scheduled_date'] = array( 'title' => t('Scheduled Date'), 'help' => t('The Mailing\'s Scheduled Date'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_date', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_mailing_job'],array('title' =>'Scheduled Date', 'name' => 'scheduled_date')); //When did the mailing start to send $data['civicrm_mailing_job']['start_date'] = array( 'title' => t('Start Date'), 'help' => t('The Mailing\'s Start Date'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_date', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_mailing_job'],array('title' =>'Start Date', 'name' => 'start_date')); //Mailing finish date $data['civicrm_mailing_job']['end_date'] = array( 'title' => t('End Date'), 'help' => t('The Mailing\'s End Date'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_date', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); civicrm_views_add_date_arguments($data['civicrm_mailing_job'],array('title' =>'End Date', 'name' => 'end_date')); //Is this a test mailing $data['civicrm_mailing_job']['is_test'] = array( 'title' => t('Is Test?'), 'help' => t('Is this the test mailing?'), 'field' => array( 'handler' => 'views_handler_field_boolean', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_boolean_operator', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Mailing table that tracks who forwarded the e-mail $data['civicrm_mailing_event_forward']['table']['group'] = ts('CiviCRM Mailing Forwards'); $data['civicrm_mailing_event_forward']['table']['join'] = array( // links through civicrm_mail_event_queue 'civicrm_mailing' => array( 'left_table' =>'civicrm_mailing_event_queue', 'left_field' => 'id', 'field' => 'event_queue_id', ) ); //time stamp of eash individual forward $data['civicrm_mailing_event_forward']['time_stamp'] = array( 'title' => t('Date forwaded'), 'help' => t('Date user forwarded the e-mail'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_date', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); //Tracks who click through, traces each individual click through $data['civicrm_mailing_event_trackable_url_open']['table']['group'] = ts('CiviCRM Mailing Click Throughs'); $data['civicrm_mailing_event_trackable_url_open']['table']['join'] = array( // link to civicrm_mailing through civicrm_mailing_event_queue 'civicrm_mailing' => array( 'left_table' =>'civicrm_mailing_event_queue', 'left_field' => 'id', 'field' => 'event_queue_id', ) ); //timestamp of click through $data['civicrm_mailing_event_trackable_url_open']['time_stamp'] = array( 'title' => t('Date of click through'), 'help' => t('Date user clicked a link in the e-mail'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_date', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); //ID of click through event $data['civicrm_mailing_event_trackable_url_open']['id'] = array( 'title' => t('Mailing click through ID'), 'help' => t('The numeric ID click through record'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Track the click through's URL $data['civicrm_mailing_trackable_url']['table']['group'] = ts('CiviCRM Mailing Click Throughs URL'); $data['civicrm_mailing_trackable_url']['table']['join'] = array( // link to civicrm_mailing through civicrm_mailing_event_queue 'civicrm_mailing' => array( 'left_table' =>'civicrm_mailing_event_trackable_url_open', 'left_field' => 'trackable_url_id', 'field' => 'id', ) ); $data['civicrm_mailing_trackable_url']['url'] = array( 'title' => t('URL'), 'help' => t('What URL was clicked'), 'field' => array( 'handler' => 'views_handler_field_url', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); $data['civicrm_mailing_event_bounce']['table']['group'] = ts('CiviCRM Mailing Bounced'); $data['civicrm_mailing_event_bounce']['table']['join'] = array( // link to civicrm_mailing through civicrm_mailing_event_queue 'civicrm_mailing' => array( 'left_table' =>'civicrm_mailing_event_queue', 'left_field' => 'id', 'field' => 'event_queue_id', ) ); $data['civicrm_mailing_event_bounce']['time_stamp'] = array( 'title' => t('Date of bounce'), 'help' => t('Date user e-mail bounced'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_date', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); $data['civicrm_mailing_event_bounce']['id'] = array( 'title' => t('Mailing bounced ID'), 'help' => t('The numeric ID of the bounce record'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); $data['civicrm_mailing_event_bounce']['bounce_reason'] = array( 'title' => t('Reason'), 'help' => t('Reason the e-mail bounced'), 'field' => array( 'handler' => 'views_handler_field', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument', ), 'filter' => array( 'handler' => 'views_handler_filter_string', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); $data['civicrm_mailing_event_delivered']['table']['group'] = ts('CiviCRM Mailing Delivered'); $data['civicrm_mailing_event_delivered']['table']['join'] = array( // link to civicrm_mailing through civicrm_mailing_event_queue 'civicrm_mailing' => array( 'left_table' =>'civicrm_mailing_event_queue', 'left_field' => 'id', 'field' => 'event_queue_id', ) ); $data['civicrm_mailing_event_delivered']['time_stamp'] = array( 'title' => t('Date of delivery'), 'help' => t('Date user e-mail delivered'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_date', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); $data['civicrm_mailing_event_delivered']['id'] = array( 'title' => t('Mailing delivered ID'), 'help' => t('The numeric ID of the delivery record'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); $data['civicrm_mailing_event_opened']['table']['group'] = ts('CiviCRM Mailing Opened'); $data['civicrm_mailing_event_opened']['table']['join'] = array( // link to civicrm_mailing through civicrm_mailing_event_queue 'civicrm_mailing' => array( 'left_table' =>'civicrm_mailing_event_queue', 'left_field' => 'id', 'field' => 'event_queue_id', ) ); $data['civicrm_mailing_event_opened']['time_stamp'] = array( 'title' => t('Date e-mail opened'), 'help' => t('Date e-mail opened'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_date', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); $data['civicrm_mailing_event_opened']['id'] = array( 'title' => t('Mailing opened ID'), 'help' => t('The numeric ID of the opened record'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); $data['civicrm_mailing_event_reply']['table']['group'] = ts('CiviCRM Mailing Replied'); $data['civicrm_mailing_event_reply']['table']['join'] = array( // link to civicrm_mailing through civicrm_mailing_event_queue 'civicrm_mailing' => array( 'left_table' =>'civicrm_mailing_event_queue', 'left_field' => 'id', 'field' => 'event_queue_id', ) ); $data['civicrm_mailing_event_reply']['time_stamp'] = array( 'title' => t('Date of reply'), 'help' => t('Date user replied'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_date', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); $data['civicrm_mailing_event_reply']['id'] = array( 'title' => t('Mailing reply ID'), 'help' => t('The numeric ID of the reply record'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); $data['civicrm_mailing_event_unsubscribe']['table']['group'] = ts('CiviCRM Mailing Unsubscribe'); $data['civicrm_mailing_event_unsubcribe']['table']['join'] = array( // link to civicrm_mailing through civicrm_mailing_event_queue 'civicrm_mailing' => array( 'left_table' =>'civicrm_mailing_event_queue', 'left_field' => 'id', 'field' => 'event_queue_id', ) ); $data['civicrm_mailing_event_unsubscribe']['time_stamp'] = array( 'title' => t('Date of unsubscribe'), 'help' => t('Date user unsubscribed'), 'field' => array( 'handler' => 'civicrm_handler_field_datetime', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_date', ), 'filter' => array( 'handler' => 'civicrm_handler_filter_datetime', ), 'sort' => array( 'handler' => 'views_handler_sort_date', ), ); $data['civicrm_mailing_event_unsubscribe']['id'] = array( 'title' => t('Mailing unsubscribeded ID'), 'help' => t('The numeric ID of the unsubscribe record'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'argument' => array( 'handler' => 'views_handler_argument_numeric', 'numeric' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', 'allow empty' => TRUE, ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); //Activity Text Link $data['civicrm_activity']['text_link'] = array( 'field' => array( 'title' => t('Text Link'), 'help' => t('Creates a Text Link for various activity actions.'), 'handler' => 'civicrm_handler_field_link_activity', ), ); //Relationship Text Link $data['civicrm_relationship']['text_link'] = array( 'field' => array( 'title' => t('Text Link'), 'help' => t('Creates a Text Link for various relationship actions.'), 'handler' => 'civicrm_handler_field_link_relationship', ), ); $query = "select id, extends, extends_entity_column_value, style from civicrm_custom_group where is_active = 1"; $dao = CRM_Core_DAO::executeQuery( $query ); while ( $dao->fetch( ) ) { // call getTree using $dao->id as groupID and $dao->extends as entityType $data = civicrm_views_custom_data_cache ($data, $dao->extends, $dao->id, $dao->extends_entity_column_value, $dao->style ); } return $data; } // RETURNS A LINK TO A CIVICRM PATH function civicrm_views_href( $text, $path, $query ) { civicrm_initialize( ); require_once 'CRM/Utils/System.php'; return CRM_Utils_System::href( $text, $path, $query ); } // Creates new View fields from CiviCRM fields function civicrm_views_add_fields( &$fields, &$data, &$skipFields, $tableName ) { foreach ( $fields as $name => $value ) { if ( CRM_Utils_Array::value( $name, $skipFields ) || substr( $value['where'], 0, strlen( $tableName ) + 1 ) != "{$tableName}." ) { continue; } $data[$value['name']] = array( 'title' => $value['title'], 'help' => $value['title'], 'field' => array( 'handler' => civicrm_get_field_handler ( $value['type'] ), 'click sortable' => true, ), 'sort' => array( 'handler' => civicrm_get_sort_handler ( $value['type'] ), ), 'filter' => array( 'handler' => civicrm_get_filter_handler( $value['type'] ), ), ); //For date fields add in 6 arguments if ( $value['type'] == 4 ){ civicrm_views_add_date_arguments($data,$value); } } } /* * Function adds 6 date arguments to a date field * */ function civicrm_views_add_date_arguments(&$data,$value){ $data[$value['name'].'_full'] = array( 'title' => t($value['title']), 'help' => t('In the form of CCYYMMDD.'), 'argument' => array( 'field'=>$value['name'], 'handler' => 'views_handler_argument_civicrm_fulldate', ), ); $data[$value['name'].'_year_month'] = array( 'title' => t($value['title'].' year + month'), 'help' => t('In the form of YYYYMM.'), 'argument' => array( 'field' => $value['name'], 'handler' => 'views_handler_argument_civicrm_year_month', ), ); $data[$value['name'].'_year'] = array( 'title' => t($value['title'].' year'), 'help' => t('In the form of YYYY.'), 'argument' => array( 'field' => $value['name'], 'handler' => 'views_handler_argument_civicrm_year', ), ); $data[$value['name'].'_month'] = array( 'title' => t($value['title'].' month'), 'help' => t('In the form of MM (01 - 12).'), 'argument' => array( 'field' => $value['name'], 'handler' => 'views_handler_argument_civicrm_month', ), ); $data[$value['name'].'_day'] = array( 'title' => t($value['title'].' day'), 'help' => t('In the form of DD (01 - 31).'), 'argument' => array( 'field' => $value['name'], 'handler' => 'views_handler_argument_civicrm_day', ), ); $data[$value['name'].'_week'] = array( 'title' => t($value['title'].' week'), 'help' => t('In the form of WW (01 - 53).'), 'argument' => array( 'field' => $value['name'], 'handler' => 'views_handler_argument_civicrm_week', ), ); } function civicrm_views_custom_data_cache($data, $entity_type, $groupID, $subType, $style) { //Feels a bit hacky this next 10 lines but it was the only way I could get getTree to play nice with the data $config =& CRM_Core_Config::singleton( ); if ($style == 'Inline') { $tree = CRM_Core_BAO_CustomGroup::getTree( $entity_type, CRM_Core_DAO::$_nullObject, null, null, $subType, null ); } else { $tree = CRM_Core_BAO_CustomGroup::getTree( $entity_type, CRM_Core_DAO::$_nullObject, null, $groupID); } switch ($entity_type) { case "Contact": case "Individual": case "Household": case "Organization": $jointable = 'civicrm_contact'; break; case "Event": $jointable = 'civicrm_event'; break; case "Participant": $jointable = 'civicrm_participant'; break; case "Contribution": $jointable = 'civicrm_contribution'; break; case "Activity": $jointable = 'civicrm_activity'; break; case "Relationship": $jointable = 'civicrm_relationship'; break; case "Membership": $jointable = 'civicrm_membership'; break; } foreach ($tree as $groupkey => $currentgroup) { if ($groupkey == 'info') { return $data; } // dodges an invalid argument call after all the groups go through // have a look at what $tree outputs to to see why. $data[$currentgroup['table_name']]['table']['group'] = t('CiviCRM Custom: ') . $currentgroup['title']; // Join this table to Contacts $data[$currentgroup['table_name']]['table']['join'] = array( // Directly links to join table. $jointable => array( 'left_field' => 'id', 'field' => 'entity_id', ), ); $currentgroupfields = $currentgroup['fields']; foreach ($currentgroupfields as $key => $currentfield) { if ($currentfield['help_post'] == '' || $currentfield['help_post'] == null) { $currentfield['help_post'] = t('Custom Data Field'); } // Populates help text so there isn't miles of error: Missing Help //Create the Views Field $data[$currentgroup['table_name']][$currentfield['column_name']] = array( 'title' => $currentfield['label'], 'help' => $currentfield['help_post'], 'field' => array( 'handler' => civicrm_get_field_handler($currentfield['data_type']), 'click sortable' => TRUE, ), 'argument' => array( 'handler' => civicrm_get_argument_handler($currentfield['data_type']), ), 'filter' => array( 'handler' => civicrm_get_filter_handler($currentfield['data_type']), ), 'sort' => array( 'handler' => civicrm_get_sort_handler($currentfield['data_type']), ), ); //For date fields add in 6 arguments if ($currentfield['data_type'] == 'Date'){ //@TODO Still need to get the field under it's respecitve group, I may e able to set the civicrm_views_add_date_arguments() function with a group variable and default it to null $value = array(); $value['title'] = $currentfield['label']; $value['name'] = $currentfield['column_name']; civicrm_views_add_date_arguments($data[$currentgroup['table_name']],$value); } } } return $data; } //Getting the proper handlers by checking against the field's data_type function civicrm_get_field_handler($type) { switch ($type) { case "String": case "Memo": return 'views_handler_field'; case "Float": case "Int": return 'views_handler_field_numeric'; case "Date": return 'civicrm_handler_field_datetime'; case "Boolean": return 'views_handler_field_boolean'; case "StateProvince": return 'civicrm_handler_field_state'; case "Country": return 'civicrm_handler_field_country'; default: return 'views_handler_field'; } } function civicrm_get_argument_handler($type) { switch ($type) { case "String": case "Memo": return 'views_handler_argument'; case "Float": case "Int": return 'views_handler_argument_numeric'; case "Date": return 'views_handler_argument_date'; case "Boolean": return 'views_handler_argument'; case "StateProvince": return 'views_handler_argument'; case "Country": return 'views_handler_argument'; default: return 'views_handler_argument'; } } function civicrm_get_filter_handler($type) { switch ($type) { case "String": case "Memo": return 'views_handler_filter_string'; case "Float": case "Int": return 'views_handler_filter_numeric'; case "Date": return 'civicrm_handler_filter_datetime'; case "Boolean": return 'views_handler_filter_boolean_operator'; case "StateProvince": return 'civicrm_handler_filter_state'; case "Country": return 'civicrm_handler_filter_country'; default: return 'views_handler_filter_string'; } } function civicrm_get_sort_handler($type) { switch ($type) { case "String": case "Memo": return 'views_handler_sort'; case "Float": case "Int": return 'views_handler_sort_numeric'; case "Date": return 'views_handler_sort_date'; case "Boolean": return 'views_handler_sort'; case "StateProvince": return 'views_handler_sort'; case "Country": return 'views_handler_sort'; default: return 'views_handler_sort'; } } //Implementation of hook_date_api_fields function civicrm_date_api_fields($field) { $values = array( // The type of date: DATE_UNIX, DATE_ISO, DATE_DATETIME. 'sql_type' => DATE_DATETIME, // Timezone handling options: 'none', 'site', 'date', 'utc'. 'tz_handling' => 'site', // Needed only for dates that use 'date' tz_handling. 'timezone_field' => '', // Needed only for dates that use 'date' tz_handling. 'offset_field' => '', // Array of "table.field" values for related fields that should be // loaded automatically in the Views SQL. 'related_fields' => array(), // Granularity of this date field's db data. 'granularity' => array('year', 'month', 'day', 'hour', 'minute', 'second'), ); switch ($field) { case 'civicrm_event.start_date': case 'civicrm_event.end_date': case 'civicrm_event.registration_start_date': case 'civicrm_event.registration_end_date': case 'civicrm_mailing_job.scheduled_date': case 'civicrm_mailing_job.start_date': case 'civicrm_mailing_job.end_date': case 'civicrm_activity.activity_date_time': return $values; } } /** * Implement hook_date_api_tables(). */ function civicrm_date_api_tables() { return array('civicrm_mailing_job', 'civicrm_event', 'civicrm_activity'); } // Telling Views where to get the Handlers function civicrm_views_handlers() { return array( 'info' => array( 'path' => drupal_get_path('module', 'civicrm') . '/modules/views/civicrm', ), 'handlers' => //FIELD HANDLAAARRRRS! Field Handlers! array( // LINK FIELDS GO HERE 'civicrm_handler_field_link_contact' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_link_event' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_link_participant' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_link_contribution' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_link_activity' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_link_relationship' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_contact_link' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_gender' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_phone_type' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_location_type' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_state' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_country' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_email' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_datetime' => array( 'parent' => 'views_handler_field_date', ), 'civicrm_handler_field_event_type' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_event_link' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_event_price_set' => array( 'parent' => 'views_handler_field_prerender_list', ), 'civicrm_handler_field_participant_status' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_participant_role' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_contribution_type' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_contribution_page' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_payment_instrument' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_contribution_status' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_activity_status' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_activity_type' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_relationship_type' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_drupalid' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_membership_type' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_field_membership_status' => array( 'parent' => 'views_handler_field', ), 'civicrm_handler_relationship_contact2users' => array( 'parent' => 'views_handler_relationship', ), //FILTER HANDDLEAARRRS! Filter Handlers! 'civicrm_handler_filter_datetime' => array( 'parent' => 'views_handler_filter_date', ), 'civicrm_handler_filter_gender' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_phone_type' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_location_type' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_state' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_country' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_event_type' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_participant_status' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_group_title'=> array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_tag_title' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_participant_role' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_contribution_type' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_contribution_page' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_payment_instrument' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_contribution_status' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_activity_status' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_activity_type' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_contact_date_api_filter_handler' => array( 'parent' => 'date_api_filter_handler', ), 'civicrm_handler_filter_relationship_type' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_contact_type' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_membership_type' => array( 'parent' => 'views_handler_filter_in_operator', ), 'civicrm_handler_filter_membership_status' => array( 'parent' => 'views_handler_filter_in_operator', ), // ARGUMENT HANDLERS 'civicrm_handler_argument_date_api_contact' => array( 'parent' => 'date_api_argument_handler', ), 'views_handler_argument_civicrm_fulldate' => array( 'parent' => 'views_handler_argument_date' ), 'views_handler_argument_civicrm_year' => array( 'parent' => 'views_handler_argument_date' ), 'views_handler_argument_civicrm_year_month' => array( 'parent' => 'views_handler_argument_date' ), 'views_handler_argument_civicrm_month' => array( 'parent' => 'views_handler_argument_date' ), 'views_handler_argument_civicrm_day' => array( 'parent' => 'views_handler_argument_date' ), 'views_handler_argument_civicrm_week' => array( 'parent' => 'views_handler_argument_date' ), //SORT Handlers 'civicrm_handler_sort_date' => array( 'parent' => 'views_handler_sort_date', ), ), ); }