CiviCRM Community Forums (archive)

The standard reports from a "Find Contacts" and also the standard Print report lists the Country as one of the column headings.  In our case, everyone is in one country to the information is not useful.  What would be involved in modifying the standard listing and print report to instead display one or two custom fields instead.  Fields like political house district.

Thanks.

The actual template that produces the print report is located at:
templates/CRM/Contact/Form/Tast/Print.tpl

where it is straight forward to eliminate columns, hrename headings and re-arrange columns.

However, there seems to be a result set $rows that is available to the template with the standard fields.  Where is $rows calculated and can it be modified to include custom fields?

Instead of Country, we would really like to have the custom fields for house district, senate district and congressional district displayed.  I would think this would be useful for many advocacy organizations like www.HealthCareForAllColorado.org

Thank you.

A little more on what's where

= = = = = = = == = = = = == =
The Find Contacts output
drupal/sites/all/modules/civicrm/CRM/Contact/Selector.php 
set's column headers

drupal/sites/all/modused/civicrm/templates/CRM/Contact/Form/Selector.tpl
sets detail line values (v 1.9 about line 76)
also script for hacked easy edit navigation

Thnk the script for the detail is:
civicrm/CRM/Contact/BAO/Query.php
But I'm not sure

= = = = = = = = = = = = =

The actual output from the print button
drupal/sites/all/modules/civicrm/templates/CRM/Contact/Form/Task/Print.tpl
Print header (v. 1.9 about line 22)
Print detail (v. 1.9 about line 43)

Quite the dungeons and dragons to get this far and am able to manually code a fixed text string in the column header and detail lines for both reports.

= = = = = = = = = = =

Anyone else interested in modifying the standard output.  We never use Country and would very much like to have a custom field available to all users the county field place.  Our case political districts.

= = = = = == = = = = = =

/www/drupal/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php 
About line 2372 v 1.9

    static function &defaultReturnProperties( $mode = 1 ) {
        if ( ! isset( self::$_defaultReturnProperties ) ) {
            self::$_defaultReturnProperties = array( );
        }

        if ( ! isset( self::$_defaultReturnProperties[$mode] ) ) {
            require_once 'CRM/Core/Component.php';
            self::$_defaultReturnProperties[$mode] = CRM_Core_Component::defaultReturnProperties( $mode );

            if ( empty( self::$_defaultReturnProperties[$mode] ) ) {
                self::$_defaultReturnProperties[$mode] = array(
                                                               'home_URL'               => 1,

= = = = = = =
Objective to have values as part of the $rows array used by the template, but not sure where this is populated.

I have just lifted this from somewhere  - not tested but this might be a pointer

 $customfields = CRM_Core_BAO_CustomValueTable::getEntityValues($contactID );

Thanks Eileen - got us looking in a more productive area and thank you to Colin O'Connor for knowing how to apply the ideas.  Here is the solution that works for us under v 1.9

Hope this helps someone else - seems like for those with important custom fields, it might be very useful:

IN
/www/drupal/sites/all/modules/civicrm/CRM/Contact/Selector.php
 
// davehack
// custom_10, custom_11, custom_17 - districts
// custom_28 - CO County Name
 
    static $_properties = array('contact_id', 'contact_type', 'contact_sub_type',
                                'sort_name', 'street_address',
                                'city', 'state_province', 'postal_code', 'country',
                                'geo_code_1', 'geo_code_2',
                                'email', 'on_hold', 'phone', 'status', custom_10, custom_11, custom_17, custom_28 );
 
ALSO IN SAME SCRIPT
// *** davehack ***
    $row['custom_10'] = CRM_Core_BAO_CustomField::getDisplayValue($row['custom_10'], 2, $this->_query->_options);
    $row['custom_11'] = CRM_Core_BAO_CustomField::getDisplayValue($row['custom_11'], 2, $this->_query->_options);
    $row['custom_17'] = CRM_Core_BAO_CustomField::getDisplayValue($row['custom_17'], 2, $this->_query->_options);
    $row['custom_28'] = CRM_Core_BAO_CustomField::getDisplayValue($row['custom_28'], 2, $this->_query->_options);
// *** end davehack ***
 
ALSO IN SAME SCRIP
    private static function &_getColumnHeaders()
    {
  //davehack - change country column heading to political districts
                                          array(
                                                'name'      => ts('County<br>HD-SD-C'),
                                                'sort'      => 'county',
                                              'direction' => CRM_Utils_Sort::DONTCARE,
                                                ),
 
IN
/www/drupal/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php
 
// *** davehack ***
// add custom fields to the array below
'custom_10'              => 1,
'custom_11'              => 1,
'custom_17'              => 1,   
'custom_28'              => 1,
 
IN
/www/drupal/sites/all/modules/civicrm/templates/CRM/Contact/Form/Selector.tpl
<td>{$row.custom_28}<br>{$row.custom_10}-{$row.custom_11}-{$row.custom_17}</td>
 
IN
/www/drupal/sites/all/modules/civicrm/templates/CRM/Contact/Form/Task/Print.tpl
<th>{ts}County<br>HD-SD-C{/ts}</th>
 
And also in same script
<td>{$row.custom_28}<br>{$row.custom_10}-{$row.custom_11}-{$row.custom_17}</td>