$view = new view; $view->name = 'aggregated_orders'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'commerce_order'; $view->human_name = 'Aggregated orders'; $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['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['query']['options']['query_comment'] = FALSE; $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( 'order_id' => 'order_id', 'commerce_order_total' => 'commerce_order_total', ); $handler->display->display_options['style_options']['default'] = '-1'; $handler->display->display_options['style_options']['info'] = array( 'order_id' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'commerce_order_total' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), ); $handler->display->display_options['style_options']['override'] = 1; $handler->display->display_options['style_options']['sticky'] = 0; $handler->display->display_options['style_options']['empty_table'] = 0; /* Field: COUNT(Commerce Order: Order ID) */ $handler->display->display_options['fields']['order_id']['id'] = 'order_id'; $handler->display->display_options['fields']['order_id']['table'] = 'commerce_order'; $handler->display->display_options['fields']['order_id']['field'] = 'order_id'; $handler->display->display_options['fields']['order_id']['group_type'] = 'count'; $handler->display->display_options['fields']['order_id']['label'] = 'Number of orders'; $handler->display->display_options['fields']['order_id']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['order_id']['alter']['make_link'] = 0; $handler->display->display_options['fields']['order_id']['alter']['absolute'] = 0; $handler->display->display_options['fields']['order_id']['alter']['external'] = 0; $handler->display->display_options['fields']['order_id']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['order_id']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['order_id']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['order_id']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['order_id']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['order_id']['alter']['more_link'] = 0; $handler->display->display_options['fields']['order_id']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['order_id']['alter']['trim'] = 0; $handler->display->display_options['fields']['order_id']['alter']['html'] = 0; $handler->display->display_options['fields']['order_id']['element_label_colon'] = 1; $handler->display->display_options['fields']['order_id']['element_default_classes'] = 1; $handler->display->display_options['fields']['order_id']['hide_empty'] = 0; $handler->display->display_options['fields']['order_id']['empty_zero'] = 0; $handler->display->display_options['fields']['order_id']['hide_alter_empty'] = 1; $handler->display->display_options['fields']['order_id']['format_plural'] = 0; /* Field: SUM(Commerce Order: Order total) */ $handler->display->display_options['fields']['commerce_order_total']['id'] = 'commerce_order_total'; $handler->display->display_options['fields']['commerce_order_total']['table'] = 'field_data_commerce_order_total'; $handler->display->display_options['fields']['commerce_order_total']['field'] = 'commerce_order_total'; $handler->display->display_options['fields']['commerce_order_total']['group_type'] = 'sum'; $handler->display->display_options['fields']['commerce_order_total']['label'] = 'Total sales'; $handler->display->display_options['fields']['commerce_order_total']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['commerce_order_total']['alter']['make_link'] = 0; $handler->display->display_options['fields']['commerce_order_total']['alter']['absolute'] = 0; $handler->display->display_options['fields']['commerce_order_total']['alter']['external'] = 0; $handler->display->display_options['fields']['commerce_order_total']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['commerce_order_total']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['commerce_order_total']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['commerce_order_total']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['commerce_order_total']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['commerce_order_total']['alter']['more_link'] = 0; $handler->display->display_options['fields']['commerce_order_total']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['commerce_order_total']['alter']['trim'] = 0; $handler->display->display_options['fields']['commerce_order_total']['alter']['html'] = 0; $handler->display->display_options['fields']['commerce_order_total']['element_label_colon'] = 1; $handler->display->display_options['fields']['commerce_order_total']['element_default_classes'] = 1; $handler->display->display_options['fields']['commerce_order_total']['hide_empty'] = 0; $handler->display->display_options['fields']['commerce_order_total']['empty_zero'] = 0; $handler->display->display_options['fields']['commerce_order_total']['hide_alter_empty'] = 1; $handler->display->display_options['fields']['commerce_order_total']['click_sort_column'] = 'amount'; $handler->display->display_options['fields']['commerce_order_total']['type'] = 'commerce_price_formatted_amount'; $handler->display->display_options['fields']['commerce_order_total']['settings'] = array( 'calculation' => FALSE, ); $handler->display->display_options['fields']['commerce_order_total']['group_column'] = 'amount'; $handler->display->display_options['fields']['commerce_order_total']['field_api_classes'] = 0;