$view = new view; $view->name = 'aggregation_test'; $view->description = 'Master overview of performances'; $view->tag = 'default'; $view->base_table = 'node'; $view->human_name = 'AGGREGATION TEST'; $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'] = 'Performances'; $handler->display->display_options['use_ajax'] = TRUE; $handler->display->display_options['access']['type'] = 'perm'; $handler->display->display_options['cache']['type'] = 'none'; $handler->display->display_options['query']['type'] = 'views_query'; $handler->display->display_options['query']['options']['query_comment'] = FALSE; $handler->display->display_options['exposed_form']['type'] = 'basic'; $handler->display->display_options['exposed_form']['options']['autosubmit'] = 0; $handler->display->display_options['exposed_form']['options']['autosubmit_hide'] = 1; $handler->display->display_options['pager']['type'] = 'full'; $handler->display->display_options['pager']['options']['items_per_page'] = '20'; $handler->display->display_options['style_plugin'] = 'table'; $handler->display->display_options['style_options']['columns'] = array( 'field_commission' => 'field_commission', ); $handler->display->display_options['style_options']['default'] = '-1'; $handler->display->display_options['style_options']['info'] = array( 'field_commission' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => 'views-align-right', 'separator' => '', 'empty_column' => 0, ), ); $handler->display->display_options['style_options']['override'] = 1; $handler->display->display_options['style_options']['sticky'] = 1; $handler->display->display_options['style_options']['empty_table'] = 1; /* Field: Content: Reserved Timewindow */ $handler->display->display_options['fields']['field_performance_timewindow']['id'] = 'field_performance_timewindow'; $handler->display->display_options['fields']['field_performance_timewindow']['table'] = 'field_data_field_performance_timewindow'; $handler->display->display_options['fields']['field_performance_timewindow']['field'] = 'field_performance_timewindow'; $handler->display->display_options['fields']['field_performance_timewindow']['label'] = 'Date/Time'; $handler->display->display_options['fields']['field_performance_timewindow']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['field_performance_timewindow']['alter']['make_link'] = 0; $handler->display->display_options['fields']['field_performance_timewindow']['alter']['absolute'] = 0; $handler->display->display_options['fields']['field_performance_timewindow']['alter']['external'] = 0; $handler->display->display_options['fields']['field_performance_timewindow']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['field_performance_timewindow']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['field_performance_timewindow']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['field_performance_timewindow']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['field_performance_timewindow']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['field_performance_timewindow']['alter']['more_link'] = 0; $handler->display->display_options['fields']['field_performance_timewindow']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['field_performance_timewindow']['alter']['trim'] = 0; $handler->display->display_options['fields']['field_performance_timewindow']['alter']['html'] = 0; $handler->display->display_options['fields']['field_performance_timewindow']['element_label_colon'] = 1; $handler->display->display_options['fields']['field_performance_timewindow']['element_default_classes'] = 1; $handler->display->display_options['fields']['field_performance_timewindow']['hide_empty'] = 0; $handler->display->display_options['fields']['field_performance_timewindow']['empty_zero'] = 0; $handler->display->display_options['fields']['field_performance_timewindow']['hide_alter_empty'] = 1; $handler->display->display_options['fields']['field_performance_timewindow']['settings'] = array( 'format_type' => 'long', 'fromto' => 'value', 'multiple_number' => '', 'multiple_from' => '', 'multiple_to' => '', ); $handler->display->display_options['fields']['field_performance_timewindow']['field_api_classes'] = 0; /* Field: Workflow: Current state */ $handler->display->display_options['fields']['sid']['id'] = 'sid'; $handler->display->display_options['fields']['sid']['table'] = 'workflow_node'; $handler->display->display_options['fields']['sid']['field'] = 'sid'; $handler->display->display_options['fields']['sid']['label'] = 'Status'; $handler->display->display_options['fields']['sid']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['sid']['alter']['make_link'] = 0; $handler->display->display_options['fields']['sid']['alter']['absolute'] = 0; $handler->display->display_options['fields']['sid']['alter']['external'] = 0; $handler->display->display_options['fields']['sid']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['sid']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['sid']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['sid']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['sid']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['sid']['alter']['more_link'] = 0; $handler->display->display_options['fields']['sid']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['sid']['alter']['trim'] = 0; $handler->display->display_options['fields']['sid']['alter']['html'] = 0; $handler->display->display_options['fields']['sid']['element_label_colon'] = 1; $handler->display->display_options['fields']['sid']['element_default_classes'] = 1; $handler->display->display_options['fields']['sid']['hide_empty'] = 0; $handler->display->display_options['fields']['sid']['empty_zero'] = 0; $handler->display->display_options['fields']['sid']['hide_alter_empty'] = 1; /* Field: Content: Commission */ $handler->display->display_options['fields']['field_commission']['id'] = 'field_commission'; $handler->display->display_options['fields']['field_commission']['table'] = 'field_data_field_commission'; $handler->display->display_options['fields']['field_commission']['field'] = 'field_commission'; $handler->display->display_options['fields']['field_commission']['group_type'] = 'sum'; $handler->display->display_options['fields']['field_commission']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['make_link'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['absolute'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['external'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['field_commission']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['field_commission']['alter']['more_link'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['trim'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['html'] = 0; $handler->display->display_options['fields']['field_commission']['element_label_colon'] = 1; $handler->display->display_options['fields']['field_commission']['element_default_classes'] = 1; $handler->display->display_options['fields']['field_commission']['hide_empty'] = 0; $handler->display->display_options['fields']['field_commission']['empty_zero'] = 0; $handler->display->display_options['fields']['field_commission']['hide_alter_empty'] = 1; $handler->display->display_options['fields']['field_commission']['field_api_classes'] = 0; /* Sort criterion: Content: Reserved Timewindow - start date (field_performance_timewindow) */ $handler->display->display_options['sorts']['field_performance_timewindow_value']['id'] = 'field_performance_timewindow_value'; $handler->display->display_options['sorts']['field_performance_timewindow_value']['table'] = 'field_data_field_performance_timewindow'; $handler->display->display_options['sorts']['field_performance_timewindow_value']['field'] = 'field_performance_timewindow_value'; $handler->display->display_options['sorts']['field_performance_timewindow_value']['group_type'] = 'sum'; $handler->display->display_options['sorts']['field_performance_timewindow_value']['expose']['label'] = 'Date'; /* Filter criterion: Content: Published */ $handler->display->display_options['filters']['status']['id'] = 'status'; $handler->display->display_options['filters']['status']['table'] = 'node'; $handler->display->display_options['filters']['status']['field'] = 'status'; $handler->display->display_options['filters']['status']['value'] = 1; $handler->display->display_options['filters']['status']['group'] = 1; $handler->display->display_options['filters']['status']['expose']['operator'] = FALSE; /* Filter criterion: Content: Type */ $handler->display->display_options['filters']['type']['id'] = 'type'; $handler->display->display_options['filters']['type']['table'] = 'node'; $handler->display->display_options['filters']['type']['field'] = 'type'; $handler->display->display_options['filters']['type']['value'] = array( 'performance' => 'performance', ); $handler->display->display_options['filters']['type']['group'] = 1; /* Filter criterion: Date Range */ $handler->display->display_options['filters']['field_performance_timewindow_value']['id'] = 'field_performance_timewindow_value'; $handler->display->display_options['filters']['field_performance_timewindow_value']['table'] = 'field_data_field_performance_timewindow'; $handler->display->display_options['filters']['field_performance_timewindow_value']['field'] = 'field_performance_timewindow_value'; $handler->display->display_options['filters']['field_performance_timewindow_value']['ui_name'] = 'Date Range'; $handler->display->display_options['filters']['field_performance_timewindow_value']['operator'] = '>='; $handler->display->display_options['filters']['field_performance_timewindow_value']['group'] = 1; $handler->display->display_options['filters']['field_performance_timewindow_value']['exposed'] = TRUE; $handler->display->display_options['filters']['field_performance_timewindow_value']['expose']['operator_id'] = 'field_performance_timewindow_value_op'; $handler->display->display_options['filters']['field_performance_timewindow_value']['expose']['label'] = 'Date Range'; $handler->display->display_options['filters']['field_performance_timewindow_value']['expose']['use_operator'] = 1; $handler->display->display_options['filters']['field_performance_timewindow_value']['expose']['operator'] = 'field_performance_timewindow_value_op'; $handler->display->display_options['filters']['field_performance_timewindow_value']['expose']['identifier'] = 'field_performance_timewindow_value'; $handler->display->display_options['filters']['field_performance_timewindow_value']['expose']['remember'] = 1; $handler->display->display_options['filters']['field_performance_timewindow_value']['expose']['multiple'] = FALSE; $handler->display->display_options['filters']['field_performance_timewindow_value']['form_type'] = 'date_popup'; $handler->display->display_options['filters']['field_performance_timewindow_value']['default_to_date'] = '+1 year'; /* Filter criterion: Workflow: Current state */ $handler->display->display_options['filters']['sid']['id'] = 'sid'; $handler->display->display_options['filters']['sid']['table'] = 'workflow_node'; $handler->display->display_options['filters']['sid']['field'] = 'sid'; $handler->display->display_options['filters']['sid']['value'] = array( 'all' => 'all', 26 => '26', 27 => '27', ); $handler->display->display_options['filters']['sid']['group'] = 1; $handler->display->display_options['filters']['sid']['exposed'] = TRUE; $handler->display->display_options['filters']['sid']['expose']['operator_id'] = 'sid_op'; $handler->display->display_options['filters']['sid']['expose']['label'] = 'Status'; $handler->display->display_options['filters']['sid']['expose']['operator'] = 'sid_op'; $handler->display->display_options['filters']['sid']['expose']['identifier'] = 'sid'; $handler->display->display_options['filters']['sid']['expose']['remember'] = 1; $handler->display->display_options['filters']['sid']['expose']['reduce'] = 1; /* Filter criterion: Content: Commission (field_commission) */ $handler->display->display_options['filters']['field_commission_value']['id'] = 'field_commission_value'; $handler->display->display_options['filters']['field_commission_value']['table'] = 'field_data_field_commission'; $handler->display->display_options['filters']['field_commission_value']['field'] = 'field_commission_value'; $handler->display->display_options['filters']['field_commission_value']['group_type'] = 'sum'; $handler->display->display_options['filters']['field_commission_value']['operator'] = '>'; $handler->display->display_options['filters']['field_commission_value']['value']['value'] = '1'; $handler->display->display_options['filters']['field_commission_value']['group'] = 1; $handler->display->display_options['filters']['field_commission_value']['exposed'] = TRUE; $handler->display->display_options['filters']['field_commission_value']['expose']['operator_id'] = 'field_commission_value_op'; $handler->display->display_options['filters']['field_commission_value']['expose']['label'] = 'Commission'; $handler->display->display_options['filters']['field_commission_value']['expose']['use_operator'] = 1; $handler->display->display_options['filters']['field_commission_value']['expose']['operator'] = 'field_commission_value_op'; $handler->display->display_options['filters']['field_commission_value']['expose']['identifier'] = 'field_commission_value'; $handler->display->display_options['filters']['field_commission_value']['expose']['remember'] = 1; $handler->display->display_options['filters']['field_commission_value']['expose']['multiple'] = FALSE; /* Display: Page */ $handler = $view->new_display('page', 'Page', 'page'); $handler->display->display_options['path'] = 'agg-test'; $handler->display->display_options['menu']['title'] = 'Performances'; $handler->display->display_options['menu']['weight'] = '0'; $handler->display->display_options['menu']['name'] = 'management'; $handler->display->display_options['menu']['context'] = 0; /* Display: Attachment */ $handler = $view->new_display('attachment', 'Attachment', 'attachment_1'); $handler->display->display_options['defaults']['group_by'] = FALSE; $handler->display->display_options['group_by'] = TRUE; $handler->display->display_options['pager']['type'] = 'some'; $handler->display->display_options['defaults']['fields'] = FALSE; /* Field: Content: Commission */ $handler->display->display_options['fields']['field_commission']['id'] = 'field_commission'; $handler->display->display_options['fields']['field_commission']['table'] = 'field_data_field_commission'; $handler->display->display_options['fields']['field_commission']['field'] = 'field_commission'; $handler->display->display_options['fields']['field_commission']['group_type'] = 'sum'; $handler->display->display_options['fields']['field_commission']['label'] = 'Total Commissions'; $handler->display->display_options['fields']['field_commission']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['make_link'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['absolute'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['external'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['field_commission']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['field_commission']['alter']['more_link'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['trim'] = 0; $handler->display->display_options['fields']['field_commission']['alter']['html'] = 0; $handler->display->display_options['fields']['field_commission']['element_label_colon'] = 1; $handler->display->display_options['fields']['field_commission']['element_default_classes'] = 1; $handler->display->display_options['fields']['field_commission']['hide_empty'] = 0; $handler->display->display_options['fields']['field_commission']['empty_zero'] = 0; $handler->display->display_options['fields']['field_commission']['hide_alter_empty'] = 1; $handler->display->display_options['fields']['field_commission']['group_columns'] = array( 'value' => 'value', ); $handler->display->display_options['fields']['field_commission']['field_api_classes'] = 0; $handler->display->display_options['displays'] = array( 'page' => 'page', 'default' => 0, ); $handler->display->display_options['attachment_position'] = 'after'; $handler->display->display_options['inherit_exposed_filters'] = 1;