1
|
<?php
|
2
|
|
3
|
/**
|
4
|
* @file
|
5
|
* webform_results view definition.
|
6
|
*/
|
7
|
|
8
|
// --- Paste exported view below ---
|
9
|
|
10
|
$view = new view();
|
11
|
$view->name = 'webform_results';
|
12
|
$view->description = '';
|
13
|
$view->tag = 'webform';
|
14
|
$view->base_table = 'webform_submissions';
|
15
|
$view->human_name = 'Webform Results';
|
16
|
$view->core = 7;
|
17
|
$view->api_version = '3.0';
|
18
|
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
|
19
|
|
20
|
/* Display: Master */
|
21
|
$handler = $view->new_display('default', 'Master', 'default');
|
22
|
$handler->display->display_options['use_more_always'] = FALSE;
|
23
|
$handler->display->display_options['access']['type'] = 'none';
|
24
|
$handler->display->display_options['cache']['type'] = 'none';
|
25
|
$handler->display->display_options['query']['type'] = 'views_query';
|
26
|
$handler->display->display_options['exposed_form']['type'] = 'basic';
|
27
|
$handler->display->display_options['pager']['type'] = 'full';
|
28
|
$handler->display->display_options['pager']['options']['items_per_page'] = '50';
|
29
|
$handler->display->display_options['pager']['options']['offset'] = '0';
|
30
|
$handler->display->display_options['pager']['options']['id'] = '0';
|
31
|
$handler->display->display_options['pager']['options']['quantity'] = '9';
|
32
|
$handler->display->display_options['pager']['options']['expose']['items_per_page_options'] = '10, 50, 100, 200, 500, 1000';
|
33
|
$handler->display->display_options['pager']['options']['expose']['items_per_page_options_all'] = TRUE;
|
34
|
$handler->display->display_options['pager']['options']['expose']['items_per_page_options_all_label'] = 'All';
|
35
|
|
36
|
$handler->display->display_options['style_plugin'] = 'table';
|
37
|
$handler->display->display_options['style_options']['columns'] = array(
|
38
|
'view_submission' => 'view_submission',
|
39
|
'submitted' => 'submitted',
|
40
|
'name' => 'name',
|
41
|
'remote_addr' => 'remote_addr',
|
42
|
);
|
43
|
$handler->display->display_options['style_options']['default'] = 'view_submission';
|
44
|
$handler->display->display_options['style_options']['info'] = array(
|
45
|
'view_submission' => array(
|
46
|
'sortable' => 1,
|
47
|
'default_sort_order' => 'desc',
|
48
|
'align' => '',
|
49
|
'separator' => '',
|
50
|
'empty_column' => 0,
|
51
|
),
|
52
|
'submitted' => array(
|
53
|
'sortable' => 1,
|
54
|
'default_sort_order' => 'asc',
|
55
|
'align' => '',
|
56
|
'separator' => '',
|
57
|
'empty_column' => 0,
|
58
|
),
|
59
|
'name' => array(
|
60
|
'sortable' => 1,
|
61
|
'default_sort_order' => 'asc',
|
62
|
'align' => '',
|
63
|
'separator' => '',
|
64
|
'empty_column' => 0,
|
65
|
),
|
66
|
'remote_addr' => array(
|
67
|
'sortable' => 1,
|
68
|
'default_sort_order' => 'asc',
|
69
|
'align' => '',
|
70
|
'separator' => '',
|
71
|
'empty_column' => 0,
|
72
|
),
|
73
|
'webform_all_fields' => array(
|
74
|
'sortable' => 1,
|
75
|
'default_sort_order' => 'asc',
|
76
|
'align' => '',
|
77
|
'separator' => '',
|
78
|
'empty_column' => 0,
|
79
|
),
|
80
|
);
|
81
|
$handler->display->display_options['style_options']['sticky'] = TRUE;
|
82
|
$handler->display->display_options['style_options']['empty_table'] = TRUE;
|
83
|
/* Header: Global: Result summary with additional tokens */
|
84
|
$handler->display->display_options['header']['webform_result']['id'] = 'webform_result';
|
85
|
$handler->display->display_options['header']['webform_result']['table'] = 'views';
|
86
|
$handler->display->display_options['header']['webform_result']['field'] = 'webform_result';
|
87
|
$handler->display->display_options['header']['webform_result']['content'] = '<div class="webform-results-per-page">Showing @start - @end of @total. @items_per_page_links</div>';
|
88
|
/* No results behavior: Global: Unfiltered text */
|
89
|
$handler->display->display_options['empty']['area_text_custom']['id'] = 'area_text_custom';
|
90
|
$handler->display->display_options['empty']['area_text_custom']['table'] = 'views';
|
91
|
$handler->display->display_options['empty']['area_text_custom']['field'] = 'area_text_custom';
|
92
|
$handler->display->display_options['empty']['area_text_custom']['empty'] = TRUE;
|
93
|
$handler->display->display_options['empty']['area_text_custom']['content'] = t('There are no submissions for this form. <a href="!url!1">View this form</a>.', array('!url' => url('node/')));
|
94
|
$handler->display->display_options['empty']['area_text_custom']['tokenize'] = TRUE;
|
95
|
/* Relationship: Webform submissions: User */
|
96
|
$handler->display->display_options['relationships']['uid']['id'] = 'uid';
|
97
|
$handler->display->display_options['relationships']['uid']['table'] = 'webform_submissions';
|
98
|
$handler->display->display_options['relationships']['uid']['field'] = 'uid';
|
99
|
/* Field: Webform submissions: View link */
|
100
|
$handler->display->display_options['fields']['view_submission']['id'] = 'view_submission';
|
101
|
$handler->display->display_options['fields']['view_submission']['table'] = 'webform_submissions';
|
102
|
$handler->display->display_options['fields']['view_submission']['field'] = 'view_submission';
|
103
|
$handler->display->display_options['fields']['view_submission']['label'] = '#';
|
104
|
$handler->display->display_options['fields']['view_submission']['element_label_colon'] = FALSE;
|
105
|
$handler->display->display_options['fields']['view_submission']['text'] = '[serial]';
|
106
|
$handler->display->display_options['fields']['view_submission']['access_check'] = 0;
|
107
|
/* Field: Webform submissions: Submitted */
|
108
|
$handler->display->display_options['fields']['submitted']['id'] = 'submitted';
|
109
|
$handler->display->display_options['fields']['submitted']['table'] = 'webform_submissions';
|
110
|
$handler->display->display_options['fields']['submitted']['field'] = 'submitted';
|
111
|
$handler->display->display_options['fields']['submitted']['date_format'] = 'short';
|
112
|
$handler->display->display_options['fields']['submitted']['second_date_format'] = 'long';
|
113
|
/* Field: User: Name */
|
114
|
$handler->display->display_options['fields']['name']['id'] = 'name';
|
115
|
$handler->display->display_options['fields']['name']['table'] = 'users';
|
116
|
$handler->display->display_options['fields']['name']['field'] = 'name';
|
117
|
$handler->display->display_options['fields']['name']['relationship'] = 'uid';
|
118
|
$handler->display->display_options['fields']['name']['label'] = 'User';
|
119
|
$handler->display->display_options['fields']['name']['element_label_colon'] = FALSE;
|
120
|
/* Field: Webform submissions: Remote address */
|
121
|
$handler->display->display_options['fields']['remote_addr']['id'] = 'remote_addr';
|
122
|
$handler->display->display_options['fields']['remote_addr']['table'] = 'webform_submissions';
|
123
|
$handler->display->display_options['fields']['remote_addr']['field'] = 'remote_addr';
|
124
|
$handler->display->display_options['fields']['remote_addr']['label'] = 'IP address';
|
125
|
/* Field: Webform submission data: All values */
|
126
|
$handler->display->display_options['fields']['webform_all_fields']['id'] = 'webform_all_fields';
|
127
|
$handler->display->display_options['fields']['webform_all_fields']['table'] = 'webform_submissions';
|
128
|
$handler->display->display_options['fields']['webform_all_fields']['field'] = 'webform_all_fields';
|
129
|
$handler->display->display_options['fields']['webform_all_fields']['label'] = '';
|
130
|
$handler->display->display_options['fields']['webform_all_fields']['exclude'] = TRUE;
|
131
|
$handler->display->display_options['fields']['webform_all_fields']['alter']['nl2br'] = TRUE;
|
132
|
$handler->display->display_options['fields']['webform_all_fields']['format'] = 'text';
|
133
|
/* Contextual filter: Webform submissions: Node */
|
134
|
$handler->display->display_options['arguments']['nid']['id'] = 'nid';
|
135
|
$handler->display->display_options['arguments']['nid']['table'] = 'webform_submissions';
|
136
|
$handler->display->display_options['arguments']['nid']['field'] = 'nid';
|
137
|
$handler->display->display_options['arguments']['nid']['default_action'] = 'not found';
|
138
|
$handler->display->display_options['arguments']['nid']['default_argument_type'] = 'fixed';
|
139
|
$handler->display->display_options['arguments']['nid']['summary']['number_of_records'] = '0';
|
140
|
$handler->display->display_options['arguments']['nid']['summary']['format'] = 'default_summary';
|
141
|
$handler->display->display_options['arguments']['nid']['summary_options']['items_per_page'] = '25';
|
142
|
$handler->display->display_options['arguments']['nid']['specify_validation'] = TRUE;
|
143
|
$handler->display->display_options['arguments']['nid']['validate']['type'] = 'node';
|
144
|
$translatables['webform_results'] = array(
|
145
|
t('Master'),
|
146
|
t('more'),
|
147
|
t('Apply'),
|
148
|
t('Reset'),
|
149
|
t('Sort by'),
|
150
|
t('Asc'),
|
151
|
t('Desc'),
|
152
|
t('Items per page'),
|
153
|
t('- All -'),
|
154
|
t('Offset'),
|
155
|
t('« first'),
|
156
|
t('‹ previous'),
|
157
|
t('next ›'),
|
158
|
t('last »'),
|
159
|
t('Showing @start - @end of @total'),
|
160
|
t('Webform Submission User'),
|
161
|
t('Serial Number'),
|
162
|
t('[serial]'),
|
163
|
t('Submitted'),
|
164
|
t('User'),
|
165
|
t('IP address'),
|
166
|
t('All'),
|
167
|
);
|
168
|
|
169
|
// --- Paste exported view above ---
|
170
|
|
171
|
$views[$view->name] = $view;
|