$view = new view(); $view->name = 'sales_reports'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'node'; $view->human_name = 'Sales Reports'; $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'] = 'Sales Reports'; $handler->display->display_options['use_more_always'] = FALSE; $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['exposed_form']['type'] = 'basic'; $handler->display->display_options['pager']['type'] = 'full'; $handler->display->display_options['pager']['options']['items_per_page'] = '10'; $handler->display->display_options['style_plugin'] = 'table'; /* Relationship: Content: Referenced line items */ $handler->display->display_options['relationships']['field_client_quote_line_item_id']['id'] = 'field_client_quote_line_item_id'; $handler->display->display_options['relationships']['field_client_quote_line_item_id']['table'] = 'field_data_field_client_quote'; $handler->display->display_options['relationships']['field_client_quote_line_item_id']['field'] = 'field_client_quote_line_item_id'; $handler->display->display_options['relationships']['field_client_quote_line_item_id']['label'] = 'Application'; /* Relationship: Commerce Line Item: Order ID */ $handler->display->display_options['relationships']['order_id']['id'] = 'order_id'; $handler->display->display_options['relationships']['order_id']['table'] = 'commerce_line_item'; $handler->display->display_options['relationships']['order_id']['field'] = 'order_id'; $handler->display->display_options['relationships']['order_id']['relationship'] = 'field_client_quote_line_item_id'; /* Relationship: Commerce Order: Representative payment transaction */ $handler->display->display_options['relationships']['payment_transaction_representative']['id'] = 'payment_transaction_representative'; $handler->display->display_options['relationships']['payment_transaction_representative']['table'] = 'commerce_order'; $handler->display->display_options['relationships']['payment_transaction_representative']['field'] = 'payment_transaction_representative'; $handler->display->display_options['relationships']['payment_transaction_representative']['relationship'] = 'order_id'; $handler->display->display_options['relationships']['payment_transaction_representative']['subquery_sort'] = 'commerce_payment_transaction.transaction_id'; $handler->display->display_options['relationships']['payment_transaction_representative']['subquery_view'] = ''; $handler->display->display_options['relationships']['payment_transaction_representative']['subquery_namespace'] = ''; /* Field: Content: Title */ $handler->display->display_options['fields']['title']['id'] = 'title'; $handler->display->display_options['fields']['title']['table'] = 'node'; $handler->display->display_options['fields']['title']['field'] = 'title'; $handler->display->display_options['fields']['title']['alter']['word_boundary'] = FALSE; $handler->display->display_options['fields']['title']['alter']['ellipsis'] = FALSE; /* Field: Commerce Line item: Policy Number */ $handler->display->display_options['fields']['field_policy_number']['id'] = 'field_policy_number'; $handler->display->display_options['fields']['field_policy_number']['table'] = 'field_data_field_policy_number'; $handler->display->display_options['fields']['field_policy_number']['field'] = 'field_policy_number'; $handler->display->display_options['fields']['field_policy_number']['relationship'] = 'field_client_quote_line_item_id'; $handler->display->display_options['fields']['field_policy_number']['label'] = 'Policy'; /* Field: 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']['relationship'] = 'order_id'; /* Field: Commerce Payment Transaction: Message */ $handler->display->display_options['fields']['message']['id'] = 'message'; $handler->display->display_options['fields']['message']['table'] = 'commerce_payment_transaction'; $handler->display->display_options['fields']['message']['field'] = 'message'; $handler->display->display_options['fields']['message']['relationship'] = 'payment_transaction_representative'; /* Sort criterion: Content: Post date */ $handler->display->display_options['sorts']['created']['id'] = 'created'; $handler->display->display_options['sorts']['created']['table'] = 'node'; $handler->display->display_options['sorts']['created']['field'] = 'created'; $handler->display->display_options['sorts']['created']['order'] = 'DESC'; /* 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( 'client' => 'client', ); /* Display: Page */ $handler = $view->new_display('page', 'Page', 'page'); $handler->display->display_options['path'] = 'sales-reports'; $translatables['sales_reports'] = array( t('Master'), t('Sales Reports'), t('more'), t('Apply'), t('Reset'), t('Sort by'), t('Asc'), t('Desc'), t('Items per page'), t('- All -'), t('Offset'), t('« first'), t('‹ previous'), t('next ›'), t('last »'), t('Application'), t('Title'), t('Policy Number'), t('Page'), );