$view = new view(); $view->name = 'recur'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'civicrm_contribution_recur'; $view->human_name = 'recur'; $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['use_more_always'] = FALSE; $handler->display->display_options['access']['type'] = 'role'; $handler->display->display_options['access']['role'] = array( 3 => '3', ); $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['pager']['options']['items_per_page'] = '100'; $handler->display->display_options['pager']['options']['offset'] = '0'; $handler->display->display_options['pager']['options']['id'] = '0'; $handler->display->display_options['pager']['options']['quantity'] = '9'; $handler->display->display_options['style_plugin'] = 'table'; $handler->display->display_options['style_options']['columns'] = array( 'id' => 'id', 'next_sched_contribution_date' => 'next_sched_contribution_date', ); $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, ), 'next_sched_contribution_date' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), ); /* Header: Global: Text area */ $handler->display->display_options['header']['area']['id'] = 'area'; $handler->display->display_options['header']['area']['table'] = 'views'; $handler->display->display_options['header']['area']['field'] = 'area'; $handler->display->display_options['header']['area']['content'] = '

Future payments

'; $handler->display->display_options['header']['area']['format'] = 'full_html'; /* Relationship: CiviCRM Recurring Contributions: Contact ID */ $handler->display->display_options['relationships']['contact_id']['id'] = 'contact_id'; $handler->display->display_options['relationships']['contact_id']['table'] = 'civicrm_contribution_recur'; $handler->display->display_options['relationships']['contact_id']['field'] = 'contact_id'; /* Field: CiviCRM Recurring Contributions: Recurring Contribution ID */ $handler->display->display_options['fields']['id']['id'] = 'id'; $handler->display->display_options['fields']['id']['table'] = 'civicrm_contribution_recur'; $handler->display->display_options['fields']['id']['field'] = 'id'; $handler->display->display_options['fields']['id']['label'] = 'Recur ID'; $handler->display->display_options['fields']['id']['separator'] = ''; /* Field: CiviCRM Contacts: Display Name */ $handler->display->display_options['fields']['display_name']['id'] = 'display_name'; $handler->display->display_options['fields']['display_name']['table'] = 'civicrm_contact'; $handler->display->display_options['fields']['display_name']['field'] = 'display_name'; $handler->display->display_options['fields']['display_name']['relationship'] = 'contact_id'; $handler->display->display_options['fields']['display_name']['label'] = 'Name'; $handler->display->display_options['fields']['display_name']['link_to_civicrm_contact'] = 1; /* Field: CiviCRM Recurring Contributions: Create Date */ $handler->display->display_options['fields']['create_date']['id'] = 'create_date'; $handler->display->display_options['fields']['create_date']['table'] = 'civicrm_contribution_recur'; $handler->display->display_options['fields']['create_date']['field'] = 'create_date'; $handler->display->display_options['fields']['create_date']['label'] = 'Created'; $handler->display->display_options['fields']['create_date']['date_format'] = 'custom'; $handler->display->display_options['fields']['create_date']['custom_date_format'] = 'd M Y'; $handler->display->display_options['fields']['create_date']['second_date_format'] = 'ip2country_date'; /* Field: CiviCRM Recurring Contributions: Frequency Unit */ $handler->display->display_options['fields']['frequency_unit']['id'] = 'frequency_unit'; $handler->display->display_options['fields']['frequency_unit']['table'] = 'civicrm_contribution_recur'; $handler->display->display_options['fields']['frequency_unit']['field'] = 'frequency_unit'; $handler->display->display_options['fields']['frequency_unit']['label'] = 'Frequency'; /* Field: CiviCRM Recurring Contributions: Next Contribution Date */ $handler->display->display_options['fields']['next_sched_contribution_date']['id'] = 'next_sched_contribution_date'; $handler->display->display_options['fields']['next_sched_contribution_date']['table'] = 'civicrm_contribution_recur'; $handler->display->display_options['fields']['next_sched_contribution_date']['field'] = 'next_sched_contribution_date'; $handler->display->display_options['fields']['next_sched_contribution_date']['date_format'] = 'custom'; $handler->display->display_options['fields']['next_sched_contribution_date']['custom_date_format'] = 'd M Y'; $handler->display->display_options['fields']['next_sched_contribution_date']['second_date_format'] = 'ip2country_date'; /* Field: Global: View */ $handler->display->display_options['fields']['view']['id'] = 'view'; $handler->display->display_options['fields']['view']['table'] = 'views'; $handler->display->display_options['fields']['view']['field'] = 'view'; $handler->display->display_options['fields']['view']['label'] = 'Latest Payment (Date > Status)'; $handler->display->display_options['fields']['view']['view'] = 'contribution_for_recur'; $handler->display->display_options['fields']['view']['arguments'] = '[id]'; /* Sort criterion: CiviCRM Recurring Contributions: Next Contribution Date */ $handler->display->display_options['sorts']['next_sched_contribution_date']['id'] = 'next_sched_contribution_date'; $handler->display->display_options['sorts']['next_sched_contribution_date']['table'] = 'civicrm_contribution_recur'; $handler->display->display_options['sorts']['next_sched_contribution_date']['field'] = 'next_sched_contribution_date'; /* Filter criterion: CiviCRM Recurring Contributions: Next Contribution Date */ $handler->display->display_options['filters']['next_sched_contribution_date']['id'] = 'next_sched_contribution_date'; $handler->display->display_options['filters']['next_sched_contribution_date']['table'] = 'civicrm_contribution_recur'; $handler->display->display_options['filters']['next_sched_contribution_date']['field'] = 'next_sched_contribution_date'; $handler->display->display_options['filters']['next_sched_contribution_date']['operator'] = 'between'; $handler->display->display_options['filters']['next_sched_contribution_date']['value']['min'] = '-1 month'; $handler->display->display_options['filters']['next_sched_contribution_date']['value']['max'] = 'Now'; $handler->display->display_options['filters']['next_sched_contribution_date']['value']['type'] = 'offset'; $handler->display->display_options['filters']['next_sched_contribution_date']['expose']['operator_id'] = 'next_sched_contribution_date_op'; $handler->display->display_options['filters']['next_sched_contribution_date']['expose']['label'] = 'Next Contribution Date'; $handler->display->display_options['filters']['next_sched_contribution_date']['expose']['use_operator'] = TRUE; $handler->display->display_options['filters']['next_sched_contribution_date']['expose']['operator'] = 'next_sched_contribution_date_op'; $handler->display->display_options['filters']['next_sched_contribution_date']['expose']['identifier'] = 'next_sched_contribution_date'; $handler->display->display_options['filters']['next_sched_contribution_date']['expose']['remember_roles'] = array( 2 => '2', 1 => 0, 35 => 0, 3 => 0, 10 => 0, 36 => 0, 13 => 0, 30 => 0, 7 => 0, 24 => 0, 25 => 0, 28 => 0, 29 => 0, 32 => 0, 33 => 0, ); /* Display: Page */ $handler = $view->new_display('page', 'Page', 'page_1'); $handler->display->display_options['defaults']['header'] = FALSE; /* Header: Global: Text area */ $handler->display->display_options['header']['area']['id'] = 'area'; $handler->display->display_options['header']['area']['table'] = 'views'; $handler->display->display_options['header']['area']['field'] = 'area'; $handler->display->display_options['header']['area']['content'] = '

Payments due in last month

'; $handler->display->display_options['header']['area']['format'] = 'full_html'; $handler->display->display_options['path'] = 'admin/recur-latest-contribution'; /* Display: Attachment */ $handler = $view->new_display('attachment', 'Attachment', 'attachment_1'); $handler->display->display_options['pager']['type'] = 'some'; $handler->display->display_options['defaults']['filter_groups'] = FALSE; $handler->display->display_options['defaults']['filters'] = FALSE; /* Filter criterion: CiviCRM Recurring Contributions: Next Contribution Date */ $handler->display->display_options['filters']['next_sched_contribution_date']['id'] = 'next_sched_contribution_date'; $handler->display->display_options['filters']['next_sched_contribution_date']['table'] = 'civicrm_contribution_recur'; $handler->display->display_options['filters']['next_sched_contribution_date']['field'] = 'next_sched_contribution_date'; $handler->display->display_options['filters']['next_sched_contribution_date']['operator'] = '>'; $handler->display->display_options['filters']['next_sched_contribution_date']['value']['min'] = '-1 month'; $handler->display->display_options['filters']['next_sched_contribution_date']['value']['max'] = 'Now'; $handler->display->display_options['filters']['next_sched_contribution_date']['value']['value'] = 'NOW'; $handler->display->display_options['filters']['next_sched_contribution_date']['value']['type'] = 'offset'; $handler->display->display_options['filters']['next_sched_contribution_date']['expose']['operator_id'] = 'next_sched_contribution_date_op'; $handler->display->display_options['filters']['next_sched_contribution_date']['expose']['label'] = 'Next Contribution Date'; $handler->display->display_options['filters']['next_sched_contribution_date']['expose']['use_operator'] = TRUE; $handler->display->display_options['filters']['next_sched_contribution_date']['expose']['operator'] = 'next_sched_contribution_date_op'; $handler->display->display_options['filters']['next_sched_contribution_date']['expose']['identifier'] = 'next_sched_contribution_date'; $handler->display->display_options['filters']['next_sched_contribution_date']['expose']['remember_roles'] = array( 2 => '2', 1 => 0, 35 => 0, 3 => 0, 10 => 0, 36 => 0, 13 => 0, 30 => 0, 7 => 0, 24 => 0, 25 => 0, 28 => 0, 29 => 0, 32 => 0, 33 => 0, ); $handler->display->display_options['displays'] = array( 'page_1' => 'page_1', 'default' => 0, ); $handler->display->display_options['attachment_position'] = 'after';