|
Al Joly
|
December 16, 2013 at 12:56 pm
The attendee reassignment filter is working good for us. The downfall we’ve found is that we have a lot of events. We have them all categorized by their type of class.
For example: First Aid – all these classes are in that category as we run this class multiple times each month.
Our usage for this tool is to move them from one date to a new date.
Is there a way to filter the event display in the Attendee Reassignment dropdown to only show events in the same category?
|
|
Sidney Harrell
|
December 16, 2013 at 3:33 pm
You would need to make some code changes to the attendee mover tool. In index.php add in the following after line 68:
global $wpdb, $org_options;
$cat_id = $wpdb->get_var($wpdb->prepare("SELECT cat_id FROM " . EVENTS_CATEGORY_REL_TABLE . " WHERE event_id = '%d'", $old_event_id));
then add the following line after what will then be line 138:
$sql .= " FROM " . EVENTS_DETAIL_TABLE . " e ";
$sql .= " JOIN " . EVENTS_CATEGORY_REL_TABLE . " cr ON cr.event_id = e.id ";
then modify line 155:
$sql .= " WHERE e.event_status != 'D' AND cr.cat_id = '%d'";
and finally, modify line 165:
$events = $wpdb->get_results($wpdb->prepare($sql, $cat_id));
Note: I was working off the development branch copy, but it should be pretty much the same code in the current pre-release channel copy.
|
