$view = new view; $view->name = '2009_registrations'; $view->description = ''; $view->tag = ''; $view->view_php = ''; $view->base_table = 'node'; $view->is_cacheable = FALSE; $view->api_version = 2; $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */ $handler = $view->new_display('default', 'Defaults', 'default'); $handler->override_option('relationships', array( 'order_product_id' => array( 'label' => 'uc_node_checkout order', 'required' => 1, 'id' => 'order_product_id', 'table' => 'uc_node_checkout_order_products', 'field' => 'order_product_id', 'relationship' => 'none', ), )); $handler->override_option('fields', array( 'order_id' => array( 'label' => 'Order', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'help' => '', 'trim' => 0, 'max_length' => '', 'word_boundary' => 1, 'ellipsis' => 1, 'strip_tags' => 0, 'html' => 0, ), 'link_to_order' => 1, 'exclude' => 0, 'id' => 'order_id', 'table' => 'uc_orders', 'field' => 'order_id', 'relationship' => 'order_product_id', 'override' => array( 'button' => 'Override', ), ), 'title' => array( 'label' => 'Name', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'help' => '', 'trim' => 1, 'max_length' => '30', 'word_boundary' => 1, 'ellipsis' => 1, 'strip_tags' => 0, 'html' => 0, ), 'link_to_node' => 1, 'exclude' => 0, 'id' => 'title', 'table' => 'node', 'field' => 'title', 'relationship' => 'none', 'override' => array( 'button' => 'Override', ), ), 'field_email_email' => array( 'label' => 'E-mail', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'help' => '', 'trim' => 0, 'max_length' => '', 'word_boundary' => 1, 'ellipsis' => 1, 'strip_tags' => 0, 'html' => 0, ), 'link_to_node' => 0, 'label_type' => 'widget', 'format' => 'default', 'multiple' => array( 'group' => TRUE, 'multiple_number' => '', 'multiple_from' => '', 'multiple_reversed' => FALSE, ), 'exclude' => 0, 'id' => 'field_email_email', 'table' => 'node_data_field_email', 'field' => 'field_email_email', 'override' => array( 'button' => 'Override', ), 'relationship' => 'none', ), 'field_organization_value' => array( 'label' => 'Organization', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'help' => '', 'trim' => 0, 'max_length' => '40', 'word_boundary' => 0, 'ellipsis' => 0, 'strip_tags' => 0, 'html' => 0, ), 'link_to_node' => 0, 'label_type' => 'widget', 'format' => 'default', 'multiple' => array( 'group' => TRUE, 'multiple_number' => '', 'multiple_from' => '', 'multiple_reversed' => FALSE, ), 'exclude' => 0, 'id' => 'field_organization_value', 'table' => 'node_data_field_organization', 'field' => 'field_organization_value', 'override' => array( 'button' => 'Override', ), 'relationship' => 'none', ), 'created' => array( 'label' => 'Date', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'help' => '', 'trim' => 0, 'max_length' => '', 'word_boundary' => 1, 'ellipsis' => 1, 'strip_tags' => 0, 'html' => 0, ), 'date_format' => 'custom', 'custom_date_format' => 'M j', 'exclude' => 0, 'id' => 'created', 'table' => 'node', 'field' => 'created', 'relationship' => 'none', 'override' => array( 'button' => 'Override', ), ), 'order_status' => array( 'label' => 'St', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'help' => '', 'trim' => 1, 'max_length' => '3', 'word_boundary' => 0, 'ellipsis' => 0, 'strip_tags' => 0, 'html' => 0, ), 'exclude' => 0, 'id' => 'order_status', 'table' => 'uc_orders', 'field' => 'order_status', 'override' => array( 'button' => 'Override', ), 'relationship' => 'none', ), 'field_attendee_type_value' => array( 'label' => 'type', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'help' => '', 'trim' => 1, 'max_length' => '5', 'word_boundary' => 0, 'ellipsis' => 0, 'strip_tags' => 0, 'html' => 0, ), 'link_to_node' => 0, 'label_type' => 'custom', 'format' => 'default', 'multiple' => array( 'group' => TRUE, 'multiple_number' => '', 'multiple_from' => '', 'multiple_reversed' => FALSE, ), 'exclude' => 0, 'id' => 'field_attendee_type_value', 'table' => 'node_data_field_attendee_type', 'field' => 'field_attendee_type_value', 'override' => array( 'button' => 'Override', ), 'relationship' => 'none', ), )); $handler->override_option('filters', array( 'type' => array( 'operator' => 'in', 'value' => array( 'registration' => 'registration', ), 'group' => '0', 'exposed' => FALSE, 'expose' => array( 'operator' => FALSE, 'label' => '', ), 'id' => 'type', 'table' => 'node', 'field' => 'type', 'relationship' => 'none', ), 'model' => array( 'operator' => 'word', 'value' => 'DIWD10, DIWD11, DIWD12, DIWD13', 'group' => '0', 'exposed' => FALSE, 'expose' => array( 'operator' => FALSE, 'label' => '', ), 'case' => 1, 'id' => 'model', 'table' => 'uc_order_products', 'field' => 'model', 'relationship' => 'order_product_id', ), 'order_status' => array( 'operator' => 'in', 'value' => array( 'payment_received' => 'payment_received', 'completed' => 'completed', ), 'group' => '0', 'exposed' => TRUE, 'expose' => array( 'use_operator' => 0, 'operator' => 'order_status_op', 'identifier' => 'order_status', 'label' => 'Status', 'optional' => 1, 'single' => 0, 'remember' => 0, 'reduce' => 0, ), 'id' => 'order_status', 'table' => 'uc_orders', 'field' => 'order_status', 'relationship' => 'order_product_id', ), )); $handler->override_option('access', array( 'type' => 'role', 'role' => array( '3' => 3, ), )); $handler->override_option('cache', array( 'type' => 'none', )); $handler->override_option('title', 'DIWD 09 Registrations'); $handler->override_option('header', 'Total registrations: \' . $view->total_rows . \'\'; ?>'); $handler->override_option('header_format', '2'); $handler->override_option('header_empty', 0); $handler->override_option('items_per_page', 300); $handler->override_option('use_pager', '1'); $handler->override_option('distinct', 0); $handler->override_option('style_plugin', 'table'); $handler->override_option('style_options', array( 'grouping' => '', 'override' => 1, 'sticky' => 0, 'order' => 'desc', 'columns' => array( 'order_id' => 'order_id', 'title' => 'title', 'field_organization_value' => 'field_organization_value', 'created' => 'created', ), 'info' => array( 'order_id' => array( 'sortable' => 1, 'separator' => '', ), 'title' => array( 'sortable' => 1, 'separator' => '', ), 'field_organization_value' => array( 'sortable' => 1, 'separator' => '', ), 'created' => array( 'sortable' => 1, 'separator' => '', ), ), 'default' => 'order_id', )); $handler = $view->new_display('page', 'Page', 'page_1'); $handler->override_option('path', 'admin/store/reports/registrations'); $handler->override_option('menu', array( 'type' => 'normal', 'title' => 'DIWD 09 Registrations', 'description' => '', 'weight' => '0', 'name' => 'navigation', )); $handler->override_option('tab_options', array( 'type' => 'none', 'title' => '', 'description' => '', 'weight' => 0, ));