CiviCRM Community Forums (archive)

I need to add a field to the ContributionAggregate.php form.  I have made a new form and it's working properly.  I need to add a custom field to the form results.

The name of my custom field is: Custom_Household_Sort_Name (I found it in the database in the civicrm_custom_field table).

I can add the field here and it works as expected, I can see the column added to the results page:

   * Define the columns for search result rows
         */
        $this->_columns = array( ts('Contact Id')   => 'contact_id'  ,
                                 ts('Name'      )   => 'sort_name',
                         ts('Last Name') => 'last_name',
                         ts('Household Name') => 'household_name',
                         ts('Custom Household Sort Name')=> 'Custom_Household_Sort_Name',
                                 ts('Donation Count') => 'donation_count',
                                 ts('Donation Amount') => 'donation_amount' );
    }

I also need it to populate the data in the field, but I am not an expert at SQL and PHP, so can someone help me code it into the form.  I think it needs to go here:

        // SELECT clause must include contact_id as an alias for civicrm_contact.id
        if ( $onlyIDs ) {
            $select  = "DISTINCT contact_a.id as contact_id";
        } else {
            $select  = "
DISTINCT contact_a.id as contact_id,
contact_a.sort_name as sort_name,
contact_a.last_name as last_name,
contact_a.household_name as household_name,
sum(contrib.total_amount) AS donation_amount,
count(contrib.id) AS donation_count
";

Thanks!

Michael,

Thank you for the information - yes, I just want to add the data to my form from the custom field.

Do I simply add these custom classes to the form (where the original class is, example below)?  Or is there more to it?

Sorry, but I'll need a degree of guidance here since I'm not a SQL/PHP guru.

class CRM_Contact_Form_Search_Custom_CustomContributionAggregate
   implements CRM_Contact_Form_Search_Interface {

    protected $_formValues;
    protected $_customGroupExtends = NULL;
    protected $_customGroupFilters = TRUE;
    protected $_customGroupGroupBy = FALSE;

Thank you - I will take a look

http://civicrm.org/what/experts

lobo