$view = new view(); $view->name = 'membership_change_status'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'civicrm_activity'; $view->human_name = 'membership change status'; $view->core = 7; $view->api_version = '3.0'; $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */ /* Display: Master */ $handler = $view->new_display('default', 'Master', 'default'); $handler->display->display_options['title'] = 'Report of Memberships with changed Status'; $handler->display->display_options['use_more_always'] = FALSE; $handler->display->display_options['group_by'] = TRUE; $handler->display->display_options['access']['type'] = 'none'; $handler->display->display_options['cache']['type'] = 'none'; $handler->display->display_options['query']['type'] = 'views_query'; $handler->display->display_options['exposed_form']['type'] = 'basic'; $handler->display->display_options['pager']['type'] = 'full'; $handler->display->display_options['style_plugin'] = 'table'; $handler->display->display_options['style_options']['columns'] = array( 'id' => 'id', 'activity_type' => 'activity_type', 'activity_date_time' => 'activity_date_time', 'subject' => 'subject', ); $handler->display->display_options['style_options']['default'] = '-1'; $handler->display->display_options['style_options']['info'] = array( 'id' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'activity_type' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'activity_date_time' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'subject' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), ); /* Relationship: CiviCRM Activity Contacts: Activity Contact ID */ $handler->display->display_options['relationships']['contact_id']['id'] = 'contact_id'; $handler->display->display_options['relationships']['contact_id']['table'] = 'civicrm_activity_contact'; $handler->display->display_options['relationships']['contact_id']['field'] = 'contact_id'; $handler->display->display_options['relationships']['contact_id']['record_type'] = '3'; /* Field: CiviCRM Member: Membership Type */ $handler->display->display_options['fields']['membership_type']['id'] = 'membership_type'; $handler->display->display_options['fields']['membership_type']['table'] = 'civicrm_membership'; $handler->display->display_options['fields']['membership_type']['field'] = 'membership_type'; $handler->display->display_options['fields']['membership_type']['relationship'] = 'contact_id'; /* Field: CiviCRM Activities: Subject */ $handler->display->display_options['fields']['subject']['id'] = 'subject'; $handler->display->display_options['fields']['subject']['table'] = 'civicrm_activity'; $handler->display->display_options['fields']['subject']['field'] = 'subject'; $handler->display->display_options['fields']['subject']['label'] = 'Type of Membership Status change'; /* Field: COUNT(CiviCRM Activities: Activity ID) */ $handler->display->display_options['fields']['id']['id'] = 'id'; $handler->display->display_options['fields']['id']['table'] = 'civicrm_activity'; $handler->display->display_options['fields']['id']['field'] = 'id'; $handler->display->display_options['fields']['id']['group_type'] = 'count'; $handler->display->display_options['fields']['id']['label'] = 'Count'; $handler->display->display_options['fields']['id']['separator'] = ''; /* Filter criterion: CiviCRM Activities: Activity Type */ $handler->display->display_options['filters']['activity_type']['id'] = 'activity_type'; $handler->display->display_options['filters']['activity_type']['table'] = 'civicrm_activity'; $handler->display->display_options['filters']['activity_type']['field'] = 'activity_type'; $handler->display->display_options['filters']['activity_type']['value'] = array( 36 => '36', ); /* Filter criterion: CiviCRM Activities: Scheduled Activity Date */ $handler->display->display_options['filters']['activity_date_time']['id'] = 'activity_date_time'; $handler->display->display_options['filters']['activity_date_time']['table'] = 'civicrm_activity'; $handler->display->display_options['filters']['activity_date_time']['field'] = 'activity_date_time'; $handler->display->display_options['filters']['activity_date_time']['operator'] = 'between'; $handler->display->display_options['filters']['activity_date_time']['value']['min'] = '2015-06-01'; $handler->display->display_options['filters']['activity_date_time']['value']['max'] = '2015-06-30'; $handler->display->display_options['filters']['activity_date_time']['exposed'] = TRUE; $handler->display->display_options['filters']['activity_date_time']['expose']['operator_id'] = 'activity_date_time_op'; $handler->display->display_options['filters']['activity_date_time']['expose']['label'] = 'Scheduled Activity Date'; $handler->display->display_options['filters']['activity_date_time']['expose']['description'] = 'Use CCYY-MM-DD'; $handler->display->display_options['filters']['activity_date_time']['expose']['operator'] = 'activity_date_time_op'; $handler->display->display_options['filters']['activity_date_time']['expose']['identifier'] = 'activity_date_time'; $handler->display->display_options['filters']['activity_date_time']['expose']['remember_roles'] = array( 2 => '2', 3 => 0, 1 => 0, 5 => 0, 4 => 0, 6 => 0, 7 => 0, 8 => 0, ); /* Filter criterion: CiviCRM Activities: Subject */ $handler->display->display_options['filters']['subject']['id'] = 'subject'; $handler->display->display_options['filters']['subject']['table'] = 'civicrm_activity'; $handler->display->display_options['filters']['subject']['field'] = 'subject'; $handler->display->display_options['filters']['subject']['operator'] = 'contains'; $handler->display->display_options['filters']['subject']['exposed'] = TRUE; $handler->display->display_options['filters']['subject']['expose']['operator_id'] = 'subject_op'; $handler->display->display_options['filters']['subject']['expose']['label'] = 'Type of Membership Status change'; $handler->display->display_options['filters']['subject']['expose']['description'] = 'Eg enter "Grace to Expired" or just "Grace to" or "to Expired"'; $handler->display->display_options['filters']['subject']['expose']['operator'] = 'subject_op'; $handler->display->display_options['filters']['subject']['expose']['identifier'] = 'subject'; $handler->display->display_options['filters']['subject']['expose']['remember_roles'] = array( 2 => '2', 3 => 0, 1 => 0, 5 => 0, 4 => 0, 6 => 0, 7 => 0, 8 => 0, );