CiviCRM Community Forums (archive)

On a Drupal 6 CiviCRM 3.4.5 site I am trying extend the Participant Search page civicrm/event/search?reset=1 We want to allow the user to filter the results by Group. I added a dropdown for Group and can access it via $_POST (this may have been the easy way out of that part, heh heh) but now on the back end I am not able to properly adjust the search.

In CRM/Event/Form/Search.php at line 447 I added this:

        $query   =& $selector->getQuery( );

        /* Start code added by Hershel Robinson */
        if(0 != $_POST['group_id']) {
       //   $query->_whereClause .= ' AND civicrm_group_contact.group_id = ' .  $_POST['group_id'];
         $results=civicrm_api("Contact","get", array (
                                                 'version' =>'3',
                                                 'group' =>$_POST['group_id'],
                                                 'rowCount' =>'200000', 'return.contact_id' =>'1'
                                               )
                             );
         if (0 != $results['count']) {
          $in_clause  = 'contact_a.id IN ( ' .  join(',',array_keys($results['values'])) . ')';
          $query->_where[] = $in_clause;
          $query->_whereClause = "( {$query->_whereClause} AND $in_clause )";
         }
       //  $query->_tables['civicrm_group_contact'] = 1;
        }
        /* END Start code added by Hershel Robinson */

The search results are actually filtered by Group, but the header part of the results page like "211 Results" doesn't reflect this filtering--it shows the full values without the Group filter.

You can see in the code how I tried to do this the correct way, but it failed, so I commented that out and I used a kludge.

Can anyhow assist in getting this done properly, including the header (and pager) parts?

Thanks.

Your 1. worked great.

In CRM/Event/Form/Search/Common.tpl we added

<tr><td><label>Group</label>
  {crmAPI var="GroupS" entity="Group" action="get" version="3" }
  <select name="group">
    <option value="">- Any -</option>
    {foreach from=$GroupS.values item=Group}
      <option value="{$Group.id}">{$Group.name}</option>
    {/foreach}
  </select>
</td></tr>

to get the group drop down, and in a custom hook_buildForm we added

if ('CRM_Event_Form_Search' == $formName) {
  $groupResult = civicrm_api('Group', 'get', array('version' =>'3'));
  $groups = array();
  foreach ($groupResult['values'] as $group) {
    $group[$group['id']] = $group['name'];
  }
  $form->addElement('select', 'group', 'Group', $groups);
}
We didn't have to customize Search.php at all.

Thank you.