name = 'uc_orders'; $view->description = ''; $view->tag = 'Ubercart'; $view->base_table = 'uc_orders'; $view->human_name = ''; $view->core = 0; $view->api_version = '3.0'; $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */ /* Display: Defaults */ $handler = $view->new_display('default', 'Defaults', 'default'); $handler->display->display_options['title'] = 'Orders'; $handler->display->display_options['access']['type'] = 'perm'; $handler->display->display_options['access']['perm'] = 'view all orders'; $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['pager']['options']['items_per_page'] = '30'; $handler->display->display_options['pager']['options']['offset'] = '0'; $handler->display->display_options['pager']['options']['id'] = '0'; $handler->display->display_options['style_plugin'] = 'table'; $handler->display->display_options['style_options']['columns'] = array( 'actions' => 'actions', 'order_id' => 'order_id', 'billing_full_name' => 'billing_full_name', 'order_status' => 'order_status', 'created' => 'created', 'order_total' => 'order_total', ); $handler->display->display_options['style_options']['default'] = 'order_id'; $handler->display->display_options['style_options']['info'] = array( 'actions' => array( 'align' => '', 'separator' => '', ), 'order_id' => array( 'sortable' => 1, 'align' => '', 'separator' => '', ), 'billing_full_name' => array( 'align' => '', 'separator' => '', ), 'order_status' => array( 'sortable' => 1, 'align' => '', 'separator' => '', ), 'created' => array( 'sortable' => 1, 'align' => '', 'separator' => '', ), 'order_total' => array( 'sortable' => 1, 'align' => '', 'separator' => '', ), ); $handler->display->display_options['style_options']['override'] = 1; $handler->display->display_options['style_options']['sticky'] = 1; $handler->display->display_options['style_options']['order'] = 'desc'; /* Field: Order: Actions */ $handler->display->display_options['fields']['actions']['id'] = 'actions'; $handler->display->display_options['fields']['actions']['table'] = 'uc_orders'; $handler->display->display_options['fields']['actions']['field'] = 'actions'; $handler->display->display_options['fields']['actions']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['actions']['alter']['make_link'] = 0; $handler->display->display_options['fields']['actions']['alter']['absolute'] = 0; $handler->display->display_options['fields']['actions']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['actions']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['actions']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['actions']['alter']['trim'] = 0; $handler->display->display_options['fields']['actions']['alter']['html'] = 0; $handler->display->display_options['fields']['actions']['hide_empty'] = 0; $handler->display->display_options['fields']['actions']['empty_zero'] = 0; /* Field: Order: Order ID */ $handler->display->display_options['fields']['order_id']['id'] = 'order_id'; $handler->display->display_options['fields']['order_id']['table'] = 'uc_orders'; $handler->display->display_options['fields']['order_id']['field'] = 'order_id'; $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']['word_boundary'] = 1; $handler->display->display_options['fields']['order_id']['alter']['ellipsis'] = 1; $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']['hide_empty'] = 0; $handler->display->display_options['fields']['order_id']['empty_zero'] = 0; $handler->display->display_options['fields']['order_id']['link_to_order'] = 1; /* Field: User: Uid */ $handler->display->display_options['fields']['uid']['id'] = 'uid'; $handler->display->display_options['fields']['uid']['table'] = 'users'; $handler->display->display_options['fields']['uid']['field'] = 'uid'; $handler->display->display_options['fields']['uid']['label'] = ''; $handler->display->display_options['fields']['uid']['exclude'] = TRUE; $handler->display->display_options['fields']['uid']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['uid']['alter']['text'] = '[billing_full_name]'; $handler->display->display_options['fields']['uid']['alter']['make_link'] = 0; $handler->display->display_options['fields']['uid']['alter']['path'] = '[uid]'; $handler->display->display_options['fields']['uid']['alter']['absolute'] = 0; $handler->display->display_options['fields']['uid']['alter']['external'] = 0; $handler->display->display_options['fields']['uid']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['uid']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['uid']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['uid']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['uid']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['uid']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['uid']['alter']['trim'] = 0; $handler->display->display_options['fields']['uid']['alter']['html'] = 0; $handler->display->display_options['fields']['uid']['element_label_colon'] = FALSE; $handler->display->display_options['fields']['uid']['element_default_classes'] = 1; $handler->display->display_options['fields']['uid']['hide_empty'] = 0; $handler->display->display_options['fields']['uid']['empty_zero'] = 0; $handler->display->display_options['fields']['uid']['hide_alter_empty'] = 1; $handler->display->display_options['fields']['uid']['link_to_user'] = 0; /* Field: Order: Billing address: Full name */ $handler->display->display_options['fields']['billing_full_name']['id'] = 'billing_full_name'; $handler->display->display_options['fields']['billing_full_name']['table'] = 'uc_orders'; $handler->display->display_options['fields']['billing_full_name']['field'] = 'billing_full_name'; $handler->display->display_options['fields']['billing_full_name']['label'] = 'Customer'; $handler->display->display_options['fields']['billing_full_name']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['make_link'] = 1; $handler->display->display_options['fields']['billing_full_name']['alter']['path'] = 'user/[uid]'; $handler->display->display_options['fields']['billing_full_name']['alter']['absolute'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['external'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['billing_full_name']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['billing_full_name']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['trim'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['html'] = 0; $handler->display->display_options['fields']['billing_full_name']['element_label_colon'] = 1; $handler->display->display_options['fields']['billing_full_name']['element_default_classes'] = 1; $handler->display->display_options['fields']['billing_full_name']['hide_empty'] = 0; $handler->display->display_options['fields']['billing_full_name']['empty_zero'] = 0; $handler->display->display_options['fields']['billing_full_name']['hide_alter_empty'] = 1; /* Field: Order: Order total */ $handler->display->display_options['fields']['order_total']['id'] = 'order_total'; $handler->display->display_options['fields']['order_total']['table'] = 'uc_orders'; $handler->display->display_options['fields']['order_total']['field'] = 'order_total'; $handler->display->display_options['fields']['order_total']['label'] = 'Total'; $handler->display->display_options['fields']['order_total']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['order_total']['alter']['make_link'] = 0; $handler->display->display_options['fields']['order_total']['alter']['absolute'] = 0; $handler->display->display_options['fields']['order_total']['alter']['external'] = 0; $handler->display->display_options['fields']['order_total']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['order_total']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['order_total']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['order_total']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['order_total']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['order_total']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['order_total']['alter']['trim'] = 0; $handler->display->display_options['fields']['order_total']['alter']['html'] = 0; $handler->display->display_options['fields']['order_total']['element_label_colon'] = 1; $handler->display->display_options['fields']['order_total']['element_default_classes'] = 1; $handler->display->display_options['fields']['order_total']['hide_empty'] = 0; $handler->display->display_options['fields']['order_total']['empty_zero'] = 0; $handler->display->display_options['fields']['order_total']['hide_alter_empty'] = 0; $handler->display->display_options['fields']['order_total']['set_precision'] = 0; $handler->display->display_options['fields']['order_total']['precision'] = '0'; $handler->display->display_options['fields']['order_total']['format_plural'] = 0; /* Field: Order: Creation date */ $handler->display->display_options['fields']['created']['id'] = 'created'; $handler->display->display_options['fields']['created']['table'] = 'uc_orders'; $handler->display->display_options['fields']['created']['field'] = 'created'; $handler->display->display_options['fields']['created']['label'] = 'Purchase date'; $handler->display->display_options['fields']['created']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['created']['alter']['make_link'] = 0; $handler->display->display_options['fields']['created']['alter']['absolute'] = 0; $handler->display->display_options['fields']['created']['alter']['external'] = 0; $handler->display->display_options['fields']['created']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['created']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['created']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['created']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['created']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['created']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['created']['alter']['trim'] = 0; $handler->display->display_options['fields']['created']['alter']['html'] = 0; $handler->display->display_options['fields']['created']['element_label_colon'] = 1; $handler->display->display_options['fields']['created']['element_default_classes'] = 1; $handler->display->display_options['fields']['created']['hide_empty'] = 0; $handler->display->display_options['fields']['created']['empty_zero'] = 0; $handler->display->display_options['fields']['created']['hide_alter_empty'] = 0; $handler->display->display_options['fields']['created']['date_format'] = 'uc_store'; /* Field: Order: Order status */ $handler->display->display_options['fields']['order_status']['id'] = 'order_status'; $handler->display->display_options['fields']['order_status']['table'] = 'uc_orders'; $handler->display->display_options['fields']['order_status']['field'] = 'order_status'; $handler->display->display_options['fields']['order_status']['label'] = 'Status'; $handler->display->display_options['fields']['order_status']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['order_status']['alter']['make_link'] = 0; $handler->display->display_options['fields']['order_status']['alter']['absolute'] = 0; $handler->display->display_options['fields']['order_status']['alter']['external'] = 0; $handler->display->display_options['fields']['order_status']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['order_status']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['order_status']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['order_status']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['order_status']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['order_status']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['order_status']['alter']['trim'] = 0; $handler->display->display_options['fields']['order_status']['alter']['html'] = 0; $handler->display->display_options['fields']['order_status']['element_label_colon'] = 1; $handler->display->display_options['fields']['order_status']['element_default_classes'] = 1; $handler->display->display_options['fields']['order_status']['hide_empty'] = 0; $handler->display->display_options['fields']['order_status']['empty_zero'] = 0; $handler->display->display_options['fields']['order_status']['hide_alter_empty'] = 0; /* Filter criterion: Order: Order ID */ $handler->display->display_options['filters']['order_id']['id'] = 'order_id'; $handler->display->display_options['filters']['order_id']['table'] = 'uc_orders'; $handler->display->display_options['filters']['order_id']['field'] = 'order_id'; $handler->display->display_options['filters']['order_id']['group'] = 0; $handler->display->display_options['filters']['order_id']['exposed'] = TRUE; $handler->display->display_options['filters']['order_id']['expose']['operator_id'] = 'order_id_op'; $handler->display->display_options['filters']['order_id']['expose']['label'] = 'View order number'; $handler->display->display_options['filters']['order_id']['expose']['operator'] = 'order_id_op'; $handler->display->display_options['filters']['order_id']['expose']['identifier'] = 'order_id'; /* 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( '_active' => '_active', ); $handler->display->display_options['filters']['order_status']['group'] = 0; $handler->display->display_options['filters']['order_status']['exposed'] = TRUE; $handler->display->display_options['filters']['order_status']['expose']['operator_id'] = 'order_status_op'; $handler->display->display_options['filters']['order_status']['expose']['label'] = 'View by status'; $handler->display->display_options['filters']['order_status']['expose']['operator'] = 'order_status_op'; $handler->display->display_options['filters']['order_status']['expose']['identifier'] = 'order_status'; $handler->display->display_options['filters']['order_status']['expose']['reduce'] = 0; /* Display: Admin page */ $handler = $view->new_display('page', 'Admin page', 'admin_page'); $handler->display->display_options['path'] = 'admin/store/orders/view'; $handler->display->display_options['menu']['type'] = 'normal'; $handler->display->display_options['menu']['title'] = 'View orders'; $handler->display->display_options['menu']['description'] = 'View and process the orders received through your website.'; $handler->display->display_options['menu']['weight'] = '-10'; $handler->display->display_options['menu']['name'] = 'management'; /* Display: Search */ $handler = $view->new_display('page', 'Search', 'search'); $handler->display->display_options['defaults']['title'] = FALSE; $handler->display->display_options['title'] = 'Search orders'; $handler->display->display_options['defaults']['filters'] = FALSE; /* Filter criterion: Order: Billing address: First name */ $handler->display->display_options['filters']['billing_first_name']['id'] = 'billing_first_name'; $handler->display->display_options['filters']['billing_first_name']['table'] = 'uc_orders'; $handler->display->display_options['filters']['billing_first_name']['field'] = 'billing_first_name'; $handler->display->display_options['filters']['billing_first_name']['operator'] = 'allwords'; $handler->display->display_options['filters']['billing_first_name']['group'] = 0; $handler->display->display_options['filters']['billing_first_name']['exposed'] = TRUE; $handler->display->display_options['filters']['billing_first_name']['expose']['operator_id'] = 'billing_first_name_op'; $handler->display->display_options['filters']['billing_first_name']['expose']['label'] = 'Billing first name'; $handler->display->display_options['filters']['billing_first_name']['expose']['operator'] = 'billing_first_name_op'; $handler->display->display_options['filters']['billing_first_name']['expose']['identifier'] = 'billing_first_name'; $handler->display->display_options['filters']['billing_first_name']['expose']['required'] = 0; $handler->display->display_options['filters']['billing_first_name']['expose']['remember'] = 1; $handler->display->display_options['filters']['billing_first_name']['expose']['multiple'] = FALSE; /* Filter criterion: Order: Billing address: Last name */ $handler->display->display_options['filters']['billing_last_name']['id'] = 'billing_last_name'; $handler->display->display_options['filters']['billing_last_name']['table'] = 'uc_orders'; $handler->display->display_options['filters']['billing_last_name']['field'] = 'billing_last_name'; $handler->display->display_options['filters']['billing_last_name']['operator'] = 'allwords'; $handler->display->display_options['filters']['billing_last_name']['group'] = 0; $handler->display->display_options['filters']['billing_last_name']['exposed'] = TRUE; $handler->display->display_options['filters']['billing_last_name']['expose']['operator_id'] = 'billing_last_name_op'; $handler->display->display_options['filters']['billing_last_name']['expose']['label'] = 'Billing last name'; $handler->display->display_options['filters']['billing_last_name']['expose']['operator'] = 'billing_last_name_op'; $handler->display->display_options['filters']['billing_last_name']['expose']['identifier'] = 'billing_last_name'; $handler->display->display_options['filters']['billing_last_name']['expose']['required'] = 0; $handler->display->display_options['filters']['billing_last_name']['expose']['remember'] = 1; $handler->display->display_options['filters']['billing_last_name']['expose']['multiple'] = FALSE; /* Filter criterion: Order: Billing address: Company */ $handler->display->display_options['filters']['billing_company']['id'] = 'billing_company'; $handler->display->display_options['filters']['billing_company']['table'] = 'uc_orders'; $handler->display->display_options['filters']['billing_company']['field'] = 'billing_company'; $handler->display->display_options['filters']['billing_company']['operator'] = 'allwords'; $handler->display->display_options['filters']['billing_company']['group'] = 0; $handler->display->display_options['filters']['billing_company']['exposed'] = TRUE; $handler->display->display_options['filters']['billing_company']['expose']['operator_id'] = 'billing_company_op'; $handler->display->display_options['filters']['billing_company']['expose']['label'] = 'Billing company'; $handler->display->display_options['filters']['billing_company']['expose']['operator'] = 'billing_company_op'; $handler->display->display_options['filters']['billing_company']['expose']['identifier'] = 'billing_company'; $handler->display->display_options['filters']['billing_company']['expose']['required'] = 0; $handler->display->display_options['filters']['billing_company']['expose']['remember'] = 1; $handler->display->display_options['filters']['billing_company']['expose']['multiple'] = FALSE; /* Filter criterion: Order: Delivery address: First name */ $handler->display->display_options['filters']['delivery_first_name']['id'] = 'delivery_first_name'; $handler->display->display_options['filters']['delivery_first_name']['table'] = 'uc_orders'; $handler->display->display_options['filters']['delivery_first_name']['field'] = 'delivery_first_name'; $handler->display->display_options['filters']['delivery_first_name']['operator'] = 'allwords'; $handler->display->display_options['filters']['delivery_first_name']['group'] = 0; $handler->display->display_options['filters']['delivery_first_name']['exposed'] = TRUE; $handler->display->display_options['filters']['delivery_first_name']['expose']['operator_id'] = 'delivery_first_name_op'; $handler->display->display_options['filters']['delivery_first_name']['expose']['label'] = 'Delivery first name'; $handler->display->display_options['filters']['delivery_first_name']['expose']['operator'] = 'delivery_first_name_op'; $handler->display->display_options['filters']['delivery_first_name']['expose']['identifier'] = 'delivery_first_name'; $handler->display->display_options['filters']['delivery_first_name']['expose']['required'] = 0; $handler->display->display_options['filters']['delivery_first_name']['expose']['remember'] = 1; $handler->display->display_options['filters']['delivery_first_name']['expose']['multiple'] = FALSE; /* Filter criterion: Order: Delivery address: Last name */ $handler->display->display_options['filters']['delivery_last_name']['id'] = 'delivery_last_name'; $handler->display->display_options['filters']['delivery_last_name']['table'] = 'uc_orders'; $handler->display->display_options['filters']['delivery_last_name']['field'] = 'delivery_last_name'; $handler->display->display_options['filters']['delivery_last_name']['operator'] = 'allwords'; $handler->display->display_options['filters']['delivery_last_name']['group'] = 0; $handler->display->display_options['filters']['delivery_last_name']['exposed'] = TRUE; $handler->display->display_options['filters']['delivery_last_name']['expose']['operator_id'] = 'delivery_last_name_op'; $handler->display->display_options['filters']['delivery_last_name']['expose']['label'] = 'Delivery last name'; $handler->display->display_options['filters']['delivery_last_name']['expose']['operator'] = 'delivery_last_name_op'; $handler->display->display_options['filters']['delivery_last_name']['expose']['identifier'] = 'delivery_last_name'; $handler->display->display_options['filters']['delivery_last_name']['expose']['required'] = 0; $handler->display->display_options['filters']['delivery_last_name']['expose']['remember'] = 1; $handler->display->display_options['filters']['delivery_last_name']['expose']['multiple'] = FALSE; /* Filter criterion: Order: Delivery address: Company */ $handler->display->display_options['filters']['delivery_company']['id'] = 'delivery_company'; $handler->display->display_options['filters']['delivery_company']['table'] = 'uc_orders'; $handler->display->display_options['filters']['delivery_company']['field'] = 'delivery_company'; $handler->display->display_options['filters']['delivery_company']['operator'] = 'allwords'; $handler->display->display_options['filters']['delivery_company']['group'] = 0; $handler->display->display_options['filters']['delivery_company']['exposed'] = TRUE; $handler->display->display_options['filters']['delivery_company']['expose']['operator_id'] = 'delivery_company_op'; $handler->display->display_options['filters']['delivery_company']['expose']['label'] = 'Delivery company'; $handler->display->display_options['filters']['delivery_company']['expose']['operator'] = 'delivery_company_op'; $handler->display->display_options['filters']['delivery_company']['expose']['identifier'] = 'delivery_company'; $handler->display->display_options['filters']['delivery_company']['expose']['required'] = 0; $handler->display->display_options['filters']['delivery_company']['expose']['remember'] = 1; $handler->display->display_options['filters']['delivery_company']['expose']['multiple'] = FALSE; if (module_exists('date_views')) { /* Filter criterion: Order: Creation date */ $handler->display->display_options['filters']['created']['id'] = 'created'; $handler->display->display_options['filters']['created']['table'] = 'uc_orders'; $handler->display->display_options['filters']['created']['field'] = 'created'; $handler->display->display_options['filters']['created']['operator'] = 'between'; $handler->display->display_options['filters']['created']['group'] = 0; $handler->display->display_options['filters']['created']['exposed'] = TRUE; $handler->display->display_options['filters']['created']['expose']['operator_id'] = 'created_op'; $handler->display->display_options['filters']['created']['expose']['operator'] = 'created_op'; $handler->display->display_options['filters']['created']['expose']['identifier'] = 'created'; $handler->display->display_options['filters']['created']['expose']['multiple'] = FALSE; } /* 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( '_active' => '_active', ); $handler->display->display_options['filters']['order_status']['group'] = 0; $handler->display->display_options['filters']['order_status']['exposed'] = TRUE; $handler->display->display_options['filters']['order_status']['expose']['operator_id'] = 'order_status_op'; $handler->display->display_options['filters']['order_status']['expose']['label'] = 'View by status'; $handler->display->display_options['filters']['order_status']['expose']['operator'] = 'order_status_op'; $handler->display->display_options['filters']['order_status']['expose']['identifier'] = 'order_status'; $handler->display->display_options['filters']['order_status']['expose']['reduce'] = 0; $handler->display->display_options['path'] = 'admin/store/orders/search'; $handler->display->display_options['menu']['type'] = 'normal'; $handler->display->display_options['menu']['title'] = 'Search orders'; $handler->display->display_options['menu']['description'] = 'Search existing orders.'; $handler->display->display_options['menu']['weight'] = '0'; $handler->display->display_options['menu']['name'] = 'management'; /* Display: By customer */ $handler = $view->new_display('page', 'By customer', 'by_customer'); $handler->display->display_options['defaults']['arguments'] = FALSE; /* Contextual filter: User: Uid */ $handler->display->display_options['arguments']['uid']['id'] = 'uid'; $handler->display->display_options['arguments']['uid']['table'] = 'users'; $handler->display->display_options['arguments']['uid']['field'] = 'uid'; $handler->display->display_options['arguments']['uid']['default_action'] = 'not found'; $handler->display->display_options['arguments']['uid']['title_enable'] = 1; $handler->display->display_options['arguments']['uid']['title'] = 'Customer orders: %1'; $handler->display->display_options['arguments']['uid']['default_argument_type'] = 'fixed'; $handler->display->display_options['arguments']['uid']['default_argument_skip_url'] = 0; $handler->display->display_options['arguments']['uid']['summary']['number_of_records'] = '0'; $handler->display->display_options['arguments']['uid']['summary']['format'] = 'default_summary'; $handler->display->display_options['arguments']['uid']['summary_options']['items_per_page'] = '25'; $handler->display->display_options['arguments']['uid']['specify_validation'] = 1; $handler->display->display_options['arguments']['uid']['validate']['type'] = 'user'; $handler->display->display_options['arguments']['uid']['validate_options']['restrict_roles'] = 0; $handler->display->display_options['arguments']['uid']['break_phrase'] = 0; $handler->display->display_options['arguments']['uid']['not'] = 0; $handler->display->display_options['defaults']['filters'] = FALSE; /* 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( '_active' => '_active', ); $handler->display->display_options['filters']['order_status']['group'] = 0; $handler->display->display_options['filters']['order_status']['exposed'] = TRUE; $handler->display->display_options['filters']['order_status']['expose']['operator_id'] = 'order_status_op'; $handler->display->display_options['filters']['order_status']['expose']['label'] = 'View by status'; $handler->display->display_options['filters']['order_status']['expose']['operator'] = 'order_status_op'; $handler->display->display_options['filters']['order_status']['expose']['identifier'] = 'order_status'; $handler->display->display_options['filters']['order_status']['expose']['reduce'] = 0; $handler->display->display_options['path'] = 'admin/store/customers/orders'; $views[$view->name] = $view; $view = new view; $view->name = 'uc_customers'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'users'; $view->human_name = 'uc_customers'; $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'] = 'Customers'; $handler->display->display_options['group_by'] = TRUE; $handler->display->display_options['access']['type'] = 'perm'; $handler->display->display_options['access']['perm'] = 'view customers'; $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']['submit_button'] = 'Search'; $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'] = '30'; $handler->display->display_options['pager']['options']['offset'] = '0'; $handler->display->display_options['pager']['options']['id'] = '0'; $handler->display->display_options['pager']['options']['expose']['items_per_page_options_all'] = 0; $handler->display->display_options['style_plugin'] = 'table'; $handler->display->display_options['style_options']['columns'] = array( 'uid' => 'uid', 'name' => 'name', 'billing_full_name' => 'billing_full_name', 'primary_email' => 'primary_email', 'billing_city' => 'billing_city', 'zone_code' => 'billing_city', 'country_name' => 'billing_city', 'order_id' => 'order_id', 'order_total' => 'order_total', ); $handler->display->display_options['style_options']['default'] = 'order_id'; $handler->display->display_options['style_options']['info'] = array( 'uid' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'name' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'billing_full_name' => array( 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'primary_email' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'billing_city' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => ', ', 'empty_column' => 0, ), 'zone_code' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'country_name' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'order_id' => array( 'sortable' => 1, 'default_sort_order' => 'desc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'order_total' => array( 'sortable' => 1, 'default_sort_order' => 'desc', '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; /* Relationship: User: Orders */ $handler->display->display_options['relationships']['uc_orders']['id'] = 'uc_orders'; $handler->display->display_options['relationships']['uc_orders']['table'] = 'users'; $handler->display->display_options['relationships']['uc_orders']['field'] = 'uc_orders'; $handler->display->display_options['relationships']['uc_orders']['required'] = 1; /* Field: User: Uid */ $handler->display->display_options['fields']['uid']['id'] = 'uid'; $handler->display->display_options['fields']['uid']['table'] = 'users'; $handler->display->display_options['fields']['uid']['field'] = 'uid'; $handler->display->display_options['fields']['uid']['label'] = ''; $handler->display->display_options['fields']['uid']['exclude'] = TRUE; $handler->display->display_options['fields']['uid']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['uid']['alter']['make_link'] = 0; $handler->display->display_options['fields']['uid']['alter']['absolute'] = 0; $handler->display->display_options['fields']['uid']['alter']['external'] = 0; $handler->display->display_options['fields']['uid']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['uid']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['uid']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['uid']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['uid']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['uid']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['uid']['alter']['trim'] = 0; $handler->display->display_options['fields']['uid']['alter']['html'] = 0; $handler->display->display_options['fields']['uid']['element_label_colon'] = FALSE; $handler->display->display_options['fields']['uid']['element_default_classes'] = 1; $handler->display->display_options['fields']['uid']['hide_empty'] = 0; $handler->display->display_options['fields']['uid']['empty_zero'] = 0; $handler->display->display_options['fields']['uid']['hide_alter_empty'] = 1; $handler->display->display_options['fields']['uid']['link_to_user'] = 0; /* Field: User: Name */ $handler->display->display_options['fields']['name']['id'] = 'name'; $handler->display->display_options['fields']['name']['table'] = 'users'; $handler->display->display_options['fields']['name']['field'] = 'name'; $handler->display->display_options['fields']['name']['label'] = 'User'; $handler->display->display_options['fields']['name']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['name']['alter']['make_link'] = 0; $handler->display->display_options['fields']['name']['alter']['absolute'] = 0; $handler->display->display_options['fields']['name']['alter']['external'] = 0; $handler->display->display_options['fields']['name']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['name']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['name']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['name']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['name']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['name']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['name']['alter']['trim'] = 0; $handler->display->display_options['fields']['name']['alter']['html'] = 0; $handler->display->display_options['fields']['name']['element_label_colon'] = 1; $handler->display->display_options['fields']['name']['element_default_classes'] = 1; $handler->display->display_options['fields']['name']['hide_empty'] = 0; $handler->display->display_options['fields']['name']['empty_zero'] = 0; $handler->display->display_options['fields']['name']['hide_alter_empty'] = 1; $handler->display->display_options['fields']['name']['link_to_user'] = 1; $handler->display->display_options['fields']['name']['overwrite_anonymous'] = 0; $handler->display->display_options['fields']['name']['format_username'] = 1; /* Field: Order: Billing address: Full name */ $handler->display->display_options['fields']['billing_full_name']['id'] = 'billing_full_name'; $handler->display->display_options['fields']['billing_full_name']['table'] = 'uc_orders'; $handler->display->display_options['fields']['billing_full_name']['field'] = 'billing_full_name'; $handler->display->display_options['fields']['billing_full_name']['relationship'] = 'uc_orders'; $handler->display->display_options['fields']['billing_full_name']['label'] = 'Name'; $handler->display->display_options['fields']['billing_full_name']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['make_link'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['absolute'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['external'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['billing_full_name']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['billing_full_name']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['trim'] = 0; $handler->display->display_options['fields']['billing_full_name']['alter']['html'] = 0; $handler->display->display_options['fields']['billing_full_name']['element_label_colon'] = 1; $handler->display->display_options['fields']['billing_full_name']['element_default_classes'] = 1; $handler->display->display_options['fields']['billing_full_name']['hide_empty'] = 0; $handler->display->display_options['fields']['billing_full_name']['empty_zero'] = 0; $handler->display->display_options['fields']['billing_full_name']['hide_alter_empty'] = 1; /* Field: Order: Email address */ $handler->display->display_options['fields']['primary_email']['id'] = 'primary_email'; $handler->display->display_options['fields']['primary_email']['table'] = 'uc_orders'; $handler->display->display_options['fields']['primary_email']['field'] = 'primary_email'; $handler->display->display_options['fields']['primary_email']['relationship'] = 'uc_orders'; $handler->display->display_options['fields']['primary_email']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['primary_email']['alter']['make_link'] = 0; $handler->display->display_options['fields']['primary_email']['alter']['absolute'] = 0; $handler->display->display_options['fields']['primary_email']['alter']['external'] = 0; $handler->display->display_options['fields']['primary_email']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['primary_email']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['primary_email']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['primary_email']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['primary_email']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['primary_email']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['primary_email']['alter']['trim'] = 0; $handler->display->display_options['fields']['primary_email']['alter']['html'] = 0; $handler->display->display_options['fields']['primary_email']['element_label_colon'] = 1; $handler->display->display_options['fields']['primary_email']['element_default_classes'] = 1; $handler->display->display_options['fields']['primary_email']['hide_empty'] = 0; $handler->display->display_options['fields']['primary_email']['empty_zero'] = 0; $handler->display->display_options['fields']['primary_email']['hide_alter_empty'] = 1; /* 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']['relationship'] = 'uc_orders'; $handler->display->display_options['fields']['billing_city']['label'] = 'Location'; $handler->display->display_options['fields']['billing_city']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['billing_city']['alter']['make_link'] = 0; $handler->display->display_options['fields']['billing_city']['alter']['absolute'] = 0; $handler->display->display_options['fields']['billing_city']['alter']['external'] = 0; $handler->display->display_options['fields']['billing_city']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['billing_city']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['billing_city']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['billing_city']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['billing_city']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['billing_city']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['billing_city']['alter']['trim'] = 0; $handler->display->display_options['fields']['billing_city']['alter']['html'] = 0; $handler->display->display_options['fields']['billing_city']['element_label_colon'] = 1; $handler->display->display_options['fields']['billing_city']['element_default_classes'] = 1; $handler->display->display_options['fields']['billing_city']['hide_empty'] = 0; $handler->display->display_options['fields']['billing_city']['empty_zero'] = 0; $handler->display->display_options['fields']['billing_city']['hide_alter_empty'] = 1; /* 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'] = 'uc_orders'; $handler->display->display_options['fields']['zone_code']['label'] = ''; $handler->display->display_options['fields']['zone_code']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['zone_code']['alter']['make_link'] = 0; $handler->display->display_options['fields']['zone_code']['alter']['absolute'] = 0; $handler->display->display_options['fields']['zone_code']['alter']['external'] = 0; $handler->display->display_options['fields']['zone_code']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['zone_code']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['zone_code']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['zone_code']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['zone_code']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['zone_code']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['zone_code']['alter']['trim'] = 0; $handler->display->display_options['fields']['zone_code']['alter']['html'] = 0; $handler->display->display_options['fields']['zone_code']['element_label_colon'] = FALSE; $handler->display->display_options['fields']['zone_code']['element_default_classes'] = 1; $handler->display->display_options['fields']['zone_code']['hide_empty'] = 0; $handler->display->display_options['fields']['zone_code']['empty_zero'] = 0; $handler->display->display_options['fields']['zone_code']['hide_alter_empty'] = 1; /* Field: Order: Billing address: Country */ $handler->display->display_options['fields']['country_name']['id'] = 'country_name'; $handler->display->display_options['fields']['country_name']['table'] = 'billing_countries'; $handler->display->display_options['fields']['country_name']['field'] = 'country_name'; $handler->display->display_options['fields']['country_name']['relationship'] = 'uc_orders'; $handler->display->display_options['fields']['country_name']['label'] = ''; $handler->display->display_options['fields']['country_name']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['country_name']['alter']['make_link'] = 0; $handler->display->display_options['fields']['country_name']['alter']['absolute'] = 0; $handler->display->display_options['fields']['country_name']['alter']['external'] = 0; $handler->display->display_options['fields']['country_name']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['country_name']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['country_name']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['country_name']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['country_name']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['country_name']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['country_name']['alter']['trim'] = 0; $handler->display->display_options['fields']['country_name']['alter']['html'] = 0; $handler->display->display_options['fields']['country_name']['element_label_colon'] = FALSE; $handler->display->display_options['fields']['country_name']['element_default_classes'] = 1; $handler->display->display_options['fields']['country_name']['hide_empty'] = 0; $handler->display->display_options['fields']['country_name']['empty_zero'] = 0; $handler->display->display_options['fields']['country_name']['hide_alter_empty'] = 1; /* Field: COUNT(Order: Order ID) */ $handler->display->display_options['fields']['order_id']['id'] = 'order_id'; $handler->display->display_options['fields']['order_id']['table'] = 'uc_orders'; $handler->display->display_options['fields']['order_id']['field'] = 'order_id'; $handler->display->display_options['fields']['order_id']['relationship'] = 'uc_orders'; $handler->display->display_options['fields']['order_id']['group_type'] = 'count'; $handler->display->display_options['fields']['order_id']['label'] = 'Orders'; $handler->display->display_options['fields']['order_id']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['order_id']['alter']['make_link'] = 1; $handler->display->display_options['fields']['order_id']['alter']['path'] = 'admin/store/customers/orders/[uid]'; $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']['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(Order: Order total) */ $handler->display->display_options['fields']['order_total']['id'] = 'order_total'; $handler->display->display_options['fields']['order_total']['table'] = 'uc_orders'; $handler->display->display_options['fields']['order_total']['field'] = 'order_total'; $handler->display->display_options['fields']['order_total']['relationship'] = 'uc_orders'; $handler->display->display_options['fields']['order_total']['group_type'] = 'sum'; $handler->display->display_options['fields']['order_total']['label'] = 'Total'; $handler->display->display_options['fields']['order_total']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['order_total']['alter']['make_link'] = 0; $handler->display->display_options['fields']['order_total']['alter']['absolute'] = 0; $handler->display->display_options['fields']['order_total']['alter']['external'] = 0; $handler->display->display_options['fields']['order_total']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['order_total']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['order_total']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['order_total']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['order_total']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['order_total']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['order_total']['alter']['trim'] = 0; $handler->display->display_options['fields']['order_total']['alter']['html'] = 0; $handler->display->display_options['fields']['order_total']['element_label_colon'] = 1; $handler->display->display_options['fields']['order_total']['element_default_classes'] = 1; $handler->display->display_options['fields']['order_total']['hide_empty'] = 0; $handler->display->display_options['fields']['order_total']['empty_zero'] = 0; $handler->display->display_options['fields']['order_total']['hide_alter_empty'] = 1; $handler->display->display_options['fields']['order_total']['set_precision'] = 0; $handler->display->display_options['fields']['order_total']['precision'] = '0'; $handler->display->display_options['fields']['order_total']['format_plural'] = 0; /* Filter criterion: User: Name */ $handler->display->display_options['filters']['uid']['id'] = 'uid'; $handler->display->display_options['filters']['uid']['table'] = 'users'; $handler->display->display_options['filters']['uid']['field'] = 'uid'; $handler->display->display_options['filters']['uid']['operator'] = 'not in'; $handler->display->display_options['filters']['uid']['value'] = array( 0 => 0, ); $handler->display->display_options['filters']['uid']['group'] = 0; $handler->display->display_options['filters']['uid']['expose']['operator_id'] = 'uid_op'; $handler->display->display_options['filters']['uid']['expose']['label'] = 'Name'; $handler->display->display_options['filters']['uid']['expose']['operator'] = 'uid_op'; $handler->display->display_options['filters']['uid']['expose']['identifier'] = 'uid'; $handler->display->display_options['filters']['uid']['expose']['multiple'] = FALSE; $handler->display->display_options['filters']['uid']['expose']['reduce'] = 0; /* 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']['relationship'] = 'uc_orders'; $handler->display->display_options['filters']['order_status']['value'] = array( '_active' => '_active', ); $handler->display->display_options['filters']['order_status']['group'] = 0; /* Filter criterion: Order: Billing address: First name */ $handler->display->display_options['filters']['billing_first_name']['id'] = 'billing_first_name'; $handler->display->display_options['filters']['billing_first_name']['table'] = 'uc_orders'; $handler->display->display_options['filters']['billing_first_name']['field'] = 'billing_first_name'; $handler->display->display_options['filters']['billing_first_name']['relationship'] = 'uc_orders'; $handler->display->display_options['filters']['billing_first_name']['operator'] = 'allwords'; $handler->display->display_options['filters']['billing_first_name']['group'] = 0; $handler->display->display_options['filters']['billing_first_name']['exposed'] = TRUE; $handler->display->display_options['filters']['billing_first_name']['expose']['operator_id'] = 'billing_first_name_op'; $handler->display->display_options['filters']['billing_first_name']['expose']['label'] = 'First name'; $handler->display->display_options['filters']['billing_first_name']['expose']['operator'] = 'billing_first_name_op'; $handler->display->display_options['filters']['billing_first_name']['expose']['identifier'] = 'billing_first_name'; $handler->display->display_options['filters']['billing_first_name']['expose']['required'] = 0; $handler->display->display_options['filters']['billing_first_name']['expose']['multiple'] = FALSE; /* Filter criterion: Order: Billing address: Last name */ $handler->display->display_options['filters']['billing_last_name']['id'] = 'billing_last_name'; $handler->display->display_options['filters']['billing_last_name']['table'] = 'uc_orders'; $handler->display->display_options['filters']['billing_last_name']['field'] = 'billing_last_name'; $handler->display->display_options['filters']['billing_last_name']['relationship'] = 'uc_orders'; $handler->display->display_options['filters']['billing_last_name']['operator'] = 'allwords'; $handler->display->display_options['filters']['billing_last_name']['group'] = 0; $handler->display->display_options['filters']['billing_last_name']['exposed'] = TRUE; $handler->display->display_options['filters']['billing_last_name']['expose']['operator_id'] = 'billing_last_name_op'; $handler->display->display_options['filters']['billing_last_name']['expose']['label'] = 'Last name'; $handler->display->display_options['filters']['billing_last_name']['expose']['operator'] = 'billing_last_name_op'; $handler->display->display_options['filters']['billing_last_name']['expose']['identifier'] = 'billing_last_name'; $handler->display->display_options['filters']['billing_last_name']['expose']['required'] = 0; $handler->display->display_options['filters']['billing_last_name']['expose']['multiple'] = FALSE; /* Filter criterion: Order: Email address */ $handler->display->display_options['filters']['primary_email']['id'] = 'primary_email'; $handler->display->display_options['filters']['primary_email']['table'] = 'uc_orders'; $handler->display->display_options['filters']['primary_email']['field'] = 'primary_email'; $handler->display->display_options['filters']['primary_email']['relationship'] = 'uc_orders'; $handler->display->display_options['filters']['primary_email']['operator'] = 'allwords'; $handler->display->display_options['filters']['primary_email']['group'] = 0; $handler->display->display_options['filters']['primary_email']['exposed'] = TRUE; $handler->display->display_options['filters']['primary_email']['expose']['operator_id'] = 'primary_email_op'; $handler->display->display_options['filters']['primary_email']['expose']['label'] = 'Email address'; $handler->display->display_options['filters']['primary_email']['expose']['operator'] = 'primary_email_op'; $handler->display->display_options['filters']['primary_email']['expose']['identifier'] = 'primary_email'; $handler->display->display_options['filters']['primary_email']['expose']['required'] = 0; $handler->display->display_options['filters']['primary_email']['expose']['multiple'] = FALSE; /* Display: Admin page */ $handler = $view->new_display('page', 'Admin page', 'admin_page'); $handler->display->display_options['path'] = 'admin/store/customers/view'; $handler->display->display_options['menu']['type'] = 'normal'; $handler->display->display_options['menu']['title'] = 'View customers'; $handler->display->display_options['menu']['description'] = 'View and search customer information.'; $handler->display->display_options['menu']['weight'] = '-10'; $handler->display->display_options['menu']['name'] = 'management'; $views[$view->name] = $view; $view = new view; $view->name = 'uc_orders_user'; $view->description = ''; $view->tag = 'Ubercart'; $view->base_table = 'uc_orders'; $view->human_name = 'uc_orders_user'; $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'] = 'My order history'; $handler->display->display_options['access']['type'] = 'perm'; $handler->display->display_options['access']['perm'] = 'view own orders'; $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['pager']['options']['items_per_page'] = '20'; $handler->display->display_options['pager']['options']['offset'] = '0'; $handler->display->display_options['pager']['options']['id'] = '0'; $handler->display->display_options['pager']['options']['expose']['items_per_page_options_all'] = 0; $handler->display->display_options['style_plugin'] = 'table'; $handler->display->display_options['style_options']['columns'] = array( 'created' => 'created', 'order_id' => 'order_id', 'actions' => 'order_id', 'order_status' => 'order_status', 'product_count' => 'product_count', 'order_total' => 'order_total', ); $handler->display->display_options['style_options']['default'] = 'created'; $handler->display->display_options['style_options']['info'] = array( 'created' => array( 'sortable' => 1, 'default_sort_order' => 'desc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'order_id' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => ' ', 'empty_column' => 0, ), 'actions' => array( 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'order_status' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'product_count' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'order_total' => array( 'sortable' => 1, '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: Order: Creation date */ $handler->display->display_options['fields']['created']['id'] = 'created'; $handler->display->display_options['fields']['created']['table'] = 'uc_orders'; $handler->display->display_options['fields']['created']['field'] = 'created'; $handler->display->display_options['fields']['created']['label'] = 'Date'; $handler->display->display_options['fields']['created']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['created']['alter']['make_link'] = 0; $handler->display->display_options['fields']['created']['alter']['absolute'] = 0; $handler->display->display_options['fields']['created']['alter']['external'] = 0; $handler->display->display_options['fields']['created']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['created']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['created']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['created']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['created']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['created']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['created']['alter']['trim'] = 0; $handler->display->display_options['fields']['created']['alter']['html'] = 0; $handler->display->display_options['fields']['created']['element_label_colon'] = 1; $handler->display->display_options['fields']['created']['element_default_classes'] = 1; $handler->display->display_options['fields']['created']['hide_empty'] = 0; $handler->display->display_options['fields']['created']['empty_zero'] = 0; $handler->display->display_options['fields']['created']['hide_alter_empty'] = 1; $handler->display->display_options['fields']['created']['date_format'] = 'uc_store'; /* Field: Order: Order ID */ $handler->display->display_options['fields']['order_id']['id'] = 'order_id'; $handler->display->display_options['fields']['order_id']['table'] = 'uc_orders'; $handler->display->display_options['fields']['order_id']['field'] = 'order_id'; $handler->display->display_options['fields']['order_id']['label'] = 'Order #'; $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']['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'] = 0; $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']['link_to_order'] = 1; /* Field: Order: Actions */ $handler->display->display_options['fields']['actions']['id'] = 'actions'; $handler->display->display_options['fields']['actions']['table'] = 'uc_orders'; $handler->display->display_options['fields']['actions']['field'] = 'actions'; $handler->display->display_options['fields']['actions']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['actions']['alter']['make_link'] = 0; $handler->display->display_options['fields']['actions']['alter']['absolute'] = 0; $handler->display->display_options['fields']['actions']['alter']['external'] = 0; $handler->display->display_options['fields']['actions']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['actions']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['actions']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['actions']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['actions']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['actions']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['actions']['alter']['trim'] = 0; $handler->display->display_options['fields']['actions']['alter']['html'] = 0; $handler->display->display_options['fields']['actions']['element_label_colon'] = 1; $handler->display->display_options['fields']['actions']['element_default_classes'] = 1; $handler->display->display_options['fields']['actions']['hide_empty'] = 0; $handler->display->display_options['fields']['actions']['empty_zero'] = 0; $handler->display->display_options['fields']['actions']['hide_alter_empty'] = 1; /* Field: Order: Order status */ $handler->display->display_options['fields']['order_status']['id'] = 'order_status'; $handler->display->display_options['fields']['order_status']['table'] = 'uc_orders'; $handler->display->display_options['fields']['order_status']['field'] = 'order_status'; $handler->display->display_options['fields']['order_status']['label'] = 'Status'; $handler->display->display_options['fields']['order_status']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['order_status']['alter']['make_link'] = 0; $handler->display->display_options['fields']['order_status']['alter']['absolute'] = 0; $handler->display->display_options['fields']['order_status']['alter']['external'] = 0; $handler->display->display_options['fields']['order_status']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['order_status']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['order_status']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['order_status']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['order_status']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['order_status']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['order_status']['alter']['trim'] = 0; $handler->display->display_options['fields']['order_status']['alter']['html'] = 0; $handler->display->display_options['fields']['order_status']['element_label_colon'] = 1; $handler->display->display_options['fields']['order_status']['element_default_classes'] = 1; $handler->display->display_options['fields']['order_status']['hide_empty'] = 0; $handler->display->display_options['fields']['order_status']['empty_zero'] = 0; $handler->display->display_options['fields']['order_status']['hide_alter_empty'] = 1; /* Field: Order: Product count */ $handler->display->display_options['fields']['product_count']['id'] = 'product_count'; $handler->display->display_options['fields']['product_count']['table'] = 'uc_orders'; $handler->display->display_options['fields']['product_count']['field'] = 'product_count'; $handler->display->display_options['fields']['product_count']['label'] = 'Products'; $handler->display->display_options['fields']['product_count']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['product_count']['alter']['make_link'] = 0; $handler->display->display_options['fields']['product_count']['alter']['absolute'] = 0; $handler->display->display_options['fields']['product_count']['alter']['external'] = 0; $handler->display->display_options['fields']['product_count']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['product_count']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['product_count']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['product_count']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['product_count']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['product_count']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['product_count']['alter']['trim'] = 0; $handler->display->display_options['fields']['product_count']['alter']['html'] = 0; $handler->display->display_options['fields']['product_count']['element_label_colon'] = 1; $handler->display->display_options['fields']['product_count']['element_default_classes'] = 1; $handler->display->display_options['fields']['product_count']['hide_empty'] = 0; $handler->display->display_options['fields']['product_count']['empty_zero'] = 0; $handler->display->display_options['fields']['product_count']['hide_alter_empty'] = 1; $handler->display->display_options['fields']['product_count']['format_plural'] = 0; /* Field: Order: Order total */ $handler->display->display_options['fields']['order_total']['id'] = 'order_total'; $handler->display->display_options['fields']['order_total']['table'] = 'uc_orders'; $handler->display->display_options['fields']['order_total']['field'] = 'order_total'; $handler->display->display_options['fields']['order_total']['label'] = 'Total'; $handler->display->display_options['fields']['order_total']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['order_total']['alter']['make_link'] = 0; $handler->display->display_options['fields']['order_total']['alter']['absolute'] = 0; $handler->display->display_options['fields']['order_total']['alter']['external'] = 0; $handler->display->display_options['fields']['order_total']['alter']['replace_spaces'] = 0; $handler->display->display_options['fields']['order_total']['alter']['trim_whitespace'] = 0; $handler->display->display_options['fields']['order_total']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['order_total']['alter']['word_boundary'] = 1; $handler->display->display_options['fields']['order_total']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['order_total']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['order_total']['alter']['trim'] = 0; $handler->display->display_options['fields']['order_total']['alter']['html'] = 0; $handler->display->display_options['fields']['order_total']['element_label_colon'] = 1; $handler->display->display_options['fields']['order_total']['element_default_classes'] = 1; $handler->display->display_options['fields']['order_total']['hide_empty'] = 0; $handler->display->display_options['fields']['order_total']['empty_zero'] = 0; $handler->display->display_options['fields']['order_total']['hide_alter_empty'] = 1; $handler->display->display_options['fields']['order_total']['set_precision'] = 0; $handler->display->display_options['fields']['order_total']['precision'] = '0'; $handler->display->display_options['fields']['order_total']['format_plural'] = 0; /* Contextual filter: User: Uid */ $handler->display->display_options['arguments']['uid']['id'] = 'uid'; $handler->display->display_options['arguments']['uid']['table'] = 'users'; $handler->display->display_options['arguments']['uid']['field'] = 'uid'; $handler->display->display_options['arguments']['uid']['default_action'] = 'not found'; $handler->display->display_options['arguments']['uid']['default_argument_type'] = 'fixed'; $handler->display->display_options['arguments']['uid']['default_argument_skip_url'] = 0; $handler->display->display_options['arguments']['uid']['exception']['value'] = ''; $handler->display->display_options['arguments']['uid']['summary']['number_of_records'] = '0'; $handler->display->display_options['arguments']['uid']['summary']['format'] = 'default_summary'; $handler->display->display_options['arguments']['uid']['summary_options']['items_per_page'] = '25'; $handler->display->display_options['arguments']['uid']['specify_validation'] = 1; $handler->display->display_options['arguments']['uid']['validate']['type'] = 'user_or_permission'; $handler->display->display_options['arguments']['uid']['break_phrase'] = 0; $handler->display->display_options['arguments']['uid']['not'] = 0; /* 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( '_active' => '_active', ); /* Display: Page */ $handler = $view->new_display('page', 'Page', 'page'); $handler->display->display_options['path'] = 'user/%/orders'; $handler->display->display_options['menu']['type'] = 'tab'; $handler->display->display_options['menu']['title'] = 'Orders'; $handler->display->display_options['menu']['description'] = 'View your order history.'; $handler->display->display_options['menu']['weight'] = '0'; $handler->display->display_options['menu']['name'] = 'user-menu'; $views[$view->name] = $view; return $views; }