$view = new view(); $view->name = 'rosters'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'uc_order_products'; $view->human_name = 'Rosters'; $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'] = 'Bikecicle Roster'; $handler->display->display_options['use_more_always'] = FALSE; $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']['disable_sql_rewrite'] = TRUE; $handler->display->display_options['exposed_form']['type'] = 'basic'; $handler->display->display_options['pager']['type'] = 'none'; $handler->display->display_options['style_plugin'] = 'table'; $handler->display->display_options['style_options']['grouping'] = array( 0 => array( 'field' => 'model', 'rendered' => 1, 'rendered_strip' => 0, ), ); $handler->display->display_options['style_options']['columns'] = array( 'attributes' => 'attributes', 'billing_city' => 'billing_city', 'zone_code' => 'zone_code', 'model' => 'model', ); $handler->display->display_options['style_options']['default'] = 'model'; $handler->display->display_options['style_options']['info'] = array( 'attributes' => array( 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'billing_city' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'zone_code' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'model' => 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'] = 'Details for this event'; $handler->display->display_options['header']['area']['format'] = 'full_html'; /* Header: Global: Result summary */ $handler->display->display_options['header']['result']['id'] = 'result'; $handler->display->display_options['header']['result']['table'] = 'views'; $handler->display->display_options['header']['result']['field'] = 'result'; /* No results behavior: Global: Text area */ $handler->display->display_options['empty']['area']['id'] = 'area'; $handler->display->display_options['empty']['area']['table'] = 'views'; $handler->display->display_options['empty']['area']['field'] = 'area'; $handler->display->display_options['empty']['area']['empty'] = TRUE; $handler->display->display_options['empty']['area']['content'] = 'No registrations yet.'; $handler->display->display_options['empty']['area']['format'] = 'full_html'; /* Relationship: Ordered product: Order */ $handler->display->display_options['relationships']['order_id']['id'] = 'order_id'; $handler->display->display_options['relationships']['order_id']['table'] = 'uc_order_products'; $handler->display->display_options['relationships']['order_id']['field'] = 'order_id'; /* Field: Ubercart order product: Product attributes */ $handler->display->display_options['fields']['attributes']['id'] = 'attributes'; $handler->display->display_options['fields']['attributes']['table'] = 'uc_order_products'; $handler->display->display_options['fields']['attributes']['field'] = 'attributes'; $handler->display->display_options['fields']['attributes']['label'] = 'Racer'; /* Field: Order: Billing address: City */ $handler->display->display_options['fields']['billing_city']['id'] = 'billing_city'; $handler->display->display_options['fields']['billing_city']['table'] = 'uc_orders'; $handler->display->display_options['fields']['billing_city']['field'] = 'billing_city'; $handler->display->display_options['fields']['billing_city']['exclude'] = TRUE; /* Field: Order: Billing address: State/Province code */ $handler->display->display_options['fields']['zone_code']['id'] = 'zone_code'; $handler->display->display_options['fields']['zone_code']['table'] = 'billing_zones'; $handler->display->display_options['fields']['zone_code']['field'] = 'zone_code'; $handler->display->display_options['fields']['zone_code']['relationship'] = 'order_id'; $handler->display->display_options['fields']['zone_code']['label'] = 'Hometown'; $handler->display->display_options['fields']['zone_code']['alter']['alter_text'] = TRUE; $handler->display->display_options['fields']['zone_code']['alter']['text'] = '[billing_city], [zone_code]'; /* Field: Ordered product: SKU */ $handler->display->display_options['fields']['model']['id'] = 'model'; $handler->display->display_options['fields']['model']['table'] = 'uc_order_products'; $handler->display->display_options['fields']['model']['field'] = 'model'; $handler->display->display_options['fields']['model']['label'] = 'Category'; $handler->display->display_options['fields']['model']['exclude'] = TRUE; /* Filter criterion: Order: Order status */ $handler->display->display_options['filters']['order_status']['id'] = 'order_status'; $handler->display->display_options['filters']['order_status']['table'] = 'uc_orders'; $handler->display->display_options['filters']['order_status']['field'] = 'order_status'; $handler->display->display_options['filters']['order_status']['value'] = array( 'pending' => 'pending', 'processing' => 'processing', 'paypal_pending' => 'paypal_pending', 'payment_received' => 'payment_received', 'completed' => 'completed', ); /* Filter criterion: Ordered product: SKU */ $handler->display->display_options['filters']['model']['id'] = 'model'; $handler->display->display_options['filters']['model']['table'] = 'uc_order_products'; $handler->display->display_options['filters']['model']['field'] = 'model'; $handler->display->display_options['filters']['model']['exposed'] = TRUE; $handler->display->display_options['filters']['model']['expose']['operator_id'] = 'model_op'; $handler->display->display_options['filters']['model']['expose']['label'] = 'SKU'; $handler->display->display_options['filters']['model']['expose']['operator'] = 'model_op'; $handler->display->display_options['filters']['model']['expose']['identifier'] = 'model'; $handler->display->display_options['filters']['model']['is_grouped'] = TRUE; $handler->display->display_options['filters']['model']['group_info']['label'] = 'Year'; $handler->display->display_options['filters']['model']['group_info']['identifier'] = 'model'; $handler->display->display_options['filters']['model']['group_info']['default_group'] = '1'; $handler->display->display_options['filters']['model']['group_info']['group_items'] = array( 1 => array( 'title' => '2015', 'operator' => 'contains', 'value' => '2015-bikecicle', ), 2 => array( 'title' => '', 'operator' => '=', 'value' => '', ), 3 => array( 'title' => '', 'operator' => '=', 'value' => '', ), ); /* Filter criterion: Ordered product: Attribute: Category */ $handler->display->display_options['filters']['attr_4']['id'] = 'attr_4'; $handler->display->display_options['filters']['attr_4']['table'] = 'uc_order_products'; $handler->display->display_options['filters']['attr_4']['field'] = 'attr_4'; $handler->display->display_options['filters']['attr_4']['value'] = array( 3 => '3', ); $handler->display->display_options['filters']['attr_4']['type'] = 'select'; /* Display: Page */ $handler = $view->new_display('page', 'Page', 'page'); $handler->display->display_options['path'] = 'rosters/bikecicle';