webform_submissions.inc 11 KB

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