webform_results.inc 8.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169
  1. <?php
  2. /**
  3. * @file
  4. * View definition webform_results.
  5. */
  6. // --- Paste exported view below ---.
  7. $view = new view();
  8. $view->name = 'webform_results';
  9. $view->description = '';
  10. $view->tag = 'webform';
  11. $view->base_table = 'webform_submissions';
  12. $view->human_name = 'Webform Results';
  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. );
  38. $handler->display->display_options['style_options']['default'] = 'view_submission';
  39. $handler->display->display_options['style_options']['info'] = array(
  40. 'view_submission' => array(
  41. 'sortable' => 1,
  42. 'default_sort_order' => 'desc',
  43. 'align' => '',
  44. 'separator' => '',
  45. 'empty_column' => 0,
  46. ),
  47. 'submitted' => array(
  48. 'sortable' => 1,
  49. 'default_sort_order' => 'asc',
  50. 'align' => '',
  51. 'separator' => '',
  52. 'empty_column' => 0,
  53. ),
  54. 'name' => array(
  55. 'sortable' => 1,
  56. 'default_sort_order' => 'asc',
  57. 'align' => '',
  58. 'separator' => '',
  59. 'empty_column' => 0,
  60. ),
  61. 'remote_addr' => array(
  62. 'sortable' => 1,
  63. 'default_sort_order' => 'asc',
  64. 'align' => '',
  65. 'separator' => '',
  66. 'empty_column' => 0,
  67. ),
  68. 'webform_all_fields' => array(
  69. 'sortable' => 1,
  70. 'default_sort_order' => 'asc',
  71. 'align' => '',
  72. 'separator' => '',
  73. 'empty_column' => 0,
  74. ),
  75. );
  76. $handler->display->display_options['style_options']['sticky'] = TRUE;
  77. $handler->display->display_options['style_options']['empty_table'] = TRUE;
  78. /* Header: Global: Result summary with additional tokens */
  79. $handler->display->display_options['header']['webform_result']['id'] = 'webform_result';
  80. $handler->display->display_options['header']['webform_result']['table'] = 'views';
  81. $handler->display->display_options['header']['webform_result']['field'] = 'webform_result';
  82. $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>';
  83. /* No results behavior: Global: Unfiltered text */
  84. $handler->display->display_options['empty']['area_text_custom']['id'] = 'area_text_custom';
  85. $handler->display->display_options['empty']['area_text_custom']['table'] = 'views';
  86. $handler->display->display_options['empty']['area_text_custom']['field'] = 'area_text_custom';
  87. $handler->display->display_options['empty']['area_text_custom']['empty'] = TRUE;
  88. $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/')));
  89. $handler->display->display_options['empty']['area_text_custom']['tokenize'] = TRUE;
  90. /* Relationship: Webform submissions: User */
  91. $handler->display->display_options['relationships']['uid']['id'] = 'uid';
  92. $handler->display->display_options['relationships']['uid']['table'] = 'webform_submissions';
  93. $handler->display->display_options['relationships']['uid']['field'] = 'uid';
  94. /* Field: Webform submissions: View link */
  95. $handler->display->display_options['fields']['view_submission']['id'] = 'view_submission';
  96. $handler->display->display_options['fields']['view_submission']['table'] = 'webform_submissions';
  97. $handler->display->display_options['fields']['view_submission']['field'] = 'view_submission';
  98. $handler->display->display_options['fields']['view_submission']['label'] = '#';
  99. $handler->display->display_options['fields']['view_submission']['element_label_colon'] = FALSE;
  100. $handler->display->display_options['fields']['view_submission']['text'] = '[serial]';
  101. $handler->display->display_options['fields']['view_submission']['access_check'] = 0;
  102. /* Field: Webform submissions: Submitted */
  103. $handler->display->display_options['fields']['submitted']['id'] = 'submitted';
  104. $handler->display->display_options['fields']['submitted']['table'] = 'webform_submissions';
  105. $handler->display->display_options['fields']['submitted']['field'] = 'submitted';
  106. $handler->display->display_options['fields']['submitted']['date_format'] = 'short';
  107. $handler->display->display_options['fields']['submitted']['second_date_format'] = 'long';
  108. /* Field: User: Name */
  109. $handler->display->display_options['fields']['name']['id'] = 'name';
  110. $handler->display->display_options['fields']['name']['table'] = 'users';
  111. $handler->display->display_options['fields']['name']['field'] = 'name';
  112. $handler->display->display_options['fields']['name']['relationship'] = 'uid';
  113. $handler->display->display_options['fields']['name']['label'] = 'User';
  114. $handler->display->display_options['fields']['name']['element_label_colon'] = FALSE;
  115. /* Field: Webform submissions: Remote address */
  116. $handler->display->display_options['fields']['remote_addr']['id'] = 'remote_addr';
  117. $handler->display->display_options['fields']['remote_addr']['table'] = 'webform_submissions';
  118. $handler->display->display_options['fields']['remote_addr']['field'] = 'remote_addr';
  119. $handler->display->display_options['fields']['remote_addr']['label'] = 'IP address';
  120. /* Field: Webform submission data: All values */
  121. $handler->display->display_options['fields']['webform_all_fields']['id'] = 'webform_all_fields';
  122. $handler->display->display_options['fields']['webform_all_fields']['table'] = 'webform_submissions';
  123. $handler->display->display_options['fields']['webform_all_fields']['field'] = 'webform_all_fields';
  124. $handler->display->display_options['fields']['webform_all_fields']['label'] = '';
  125. $handler->display->display_options['fields']['webform_all_fields']['exclude'] = TRUE;
  126. $handler->display->display_options['fields']['webform_all_fields']['alter']['nl2br'] = TRUE;
  127. $handler->display->display_options['fields']['webform_all_fields']['format'] = 'text';
  128. /* Contextual filter: Webform submissions: Node */
  129. $handler->display->display_options['arguments']['nid']['id'] = 'nid';
  130. $handler->display->display_options['arguments']['nid']['table'] = 'webform_submissions';
  131. $handler->display->display_options['arguments']['nid']['field'] = 'nid';
  132. $handler->display->display_options['arguments']['nid']['default_action'] = 'not found';
  133. $handler->display->display_options['arguments']['nid']['default_argument_type'] = 'fixed';
  134. $handler->display->display_options['arguments']['nid']['summary']['number_of_records'] = '0';
  135. $handler->display->display_options['arguments']['nid']['summary']['format'] = 'default_summary';
  136. $handler->display->display_options['arguments']['nid']['summary_options']['items_per_page'] = '25';
  137. $handler->display->display_options['arguments']['nid']['specify_validation'] = TRUE;
  138. $handler->display->display_options['arguments']['nid']['validate']['type'] = 'node';
  139. $translatables['webform_results'] = array(
  140. t('Master'),
  141. t('more'),
  142. t('Apply'),
  143. t('Reset'),
  144. t('Sort by'),
  145. t('Asc'),
  146. t('Desc'),
  147. t('Items per page'),
  148. t('- All -'),
  149. t('Offset'),
  150. t('« first'),
  151. t('‹ previous'),
  152. t('next ›'),
  153. t('last »'),
  154. t('Showing @start - @end of @total'),
  155. t('Webform Submission User'),
  156. t('Serial Number'),
  157. t('[serial]'),
  158. t('Submitted'),
  159. t('User'),
  160. t('IP address'),
  161. t('All'),
  162. );
  163. // --- Paste exported view above ---.
  164. $views[$view->name] = $view;