tripal_core.views_default.inc 44 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788
  1. <?php
  2. /**
  3. * @file
  4. * Describes core default views
  5. */
  6. /**
  7. * Describes core default views
  8. *
  9. * @ingroup tripal_core
  10. */
  11. function tripal_core_views_default_views() {
  12. $views = array();
  13. $view = tripal_core_admin_defaultview_jobs();
  14. $views[$view->name] = $view;
  15. $view = tripal_core_admin_defaultview_custom_tables();
  16. $views[$view->name] = $view;
  17. $view = tripal_core_admin_defaultview_mviews();
  18. $views[$view->name] = $view;
  19. // We only want to make this view available if the Search API module is installed
  20. // and the "Default Node Index has been enabled.
  21. if (module_exists('search_api')) {
  22. $index_enabled = db_query('SELECT enabled FROM search_api_index WHERE machine_name=:name', array(':name' => 'default_node_index'))->fetchField();
  23. if ($index_enabled) {
  24. $view = tripal_core_search_default_node_index();
  25. $views[$view->name] = $view;
  26. }
  27. }
  28. return $views;
  29. }
  30. /**
  31. * Describes the jobs administration view.
  32. *
  33. * @ingroup tripal_core
  34. */
  35. function tripal_core_admin_defaultview_jobs() {
  36. $view = new view();
  37. $view->name = 'tripal_core_admin_jobs';
  38. $view->description = 'DO NOT DISABLE';
  39. $view->tag = 'tripal admin';
  40. $view->base_table = 'tripal_jobs';
  41. $view->human_name = 'Jobs Admin';
  42. $view->core = 7;
  43. $view->api_version = '3.0';
  44. $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
  45. /* Display: Master */
  46. $handler = $view->new_display('default', 'Master', 'default');
  47. $handler->display->display_options['title'] = 'Jobs';
  48. $handler->display->display_options['use_more_always'] = FALSE;
  49. $handler->display->display_options['access']['type'] = 'none';
  50. $handler->display->display_options['cache']['type'] = 'none';
  51. $handler->display->display_options['query']['type'] = 'views_query';
  52. $handler->display->display_options['exposed_form']['type'] = 'basic';
  53. $handler->display->display_options['exposed_form']['options']['submit_button'] = 'Filter';
  54. $handler->display->display_options['pager']['type'] = 'full';
  55. $handler->display->display_options['pager']['options']['items_per_page'] = '25';
  56. $handler->display->display_options['style_plugin'] = 'table';
  57. $handler->display->display_options['style_options']['columns'] = array(
  58. 'job_id' => 'job_id',
  59. 'job_name' => 'job_name',
  60. 'submit_date' => 'submit_date',
  61. 'start_time' => 'start_time',
  62. 'end_time' => 'end_time',
  63. 'nothing' => 'nothing',
  64. 'priority' => 'priority',
  65. 'progress' => 'progress',
  66. 'status' => 'status',
  67. 'nothing_2' => 'nothing_2',
  68. 'nothing_3' => 'nothing_3',
  69. 'nothing_1' => 'nothing_1',
  70. );
  71. $handler->display->display_options['style_options']['default'] = 'job_id';
  72. $handler->display->display_options['style_options']['info'] = array(
  73. 'job_id' => array(
  74. 'sortable' => 1,
  75. 'default_sort_order' => 'desc',
  76. 'align' => '',
  77. 'separator' => '',
  78. 'empty_column' => 0,
  79. ),
  80. 'job_name' => array(
  81. 'sortable' => 1,
  82. 'default_sort_order' => 'asc',
  83. 'align' => '',
  84. 'separator' => '',
  85. 'empty_column' => 0,
  86. ),
  87. 'submit_date' => array(
  88. 'sortable' => 0,
  89. 'default_sort_order' => 'asc',
  90. 'align' => '',
  91. 'separator' => '',
  92. 'empty_column' => 0,
  93. ),
  94. 'start_time' => array(
  95. 'sortable' => 0,
  96. 'default_sort_order' => 'asc',
  97. 'align' => '',
  98. 'separator' => '',
  99. 'empty_column' => 0,
  100. ),
  101. 'end_time' => array(
  102. 'sortable' => 0,
  103. 'default_sort_order' => 'asc',
  104. 'align' => '',
  105. 'separator' => '',
  106. 'empty_column' => 0,
  107. ),
  108. 'nothing' => array(
  109. 'align' => '',
  110. 'separator' => '',
  111. 'empty_column' => 0,
  112. ),
  113. 'priority' => array(
  114. 'sortable' => 1,
  115. 'default_sort_order' => 'asc',
  116. 'align' => '',
  117. 'separator' => '',
  118. 'empty_column' => 0,
  119. ),
  120. 'progress' => array(
  121. 'sortable' => 1,
  122. 'default_sort_order' => 'asc',
  123. 'align' => '',
  124. 'separator' => '',
  125. 'empty_column' => 0,
  126. ),
  127. 'status' => array(
  128. 'sortable' => 1,
  129. 'default_sort_order' => 'asc',
  130. 'align' => '',
  131. 'separator' => '',
  132. 'empty_column' => 0,
  133. ),
  134. 'nothing_2' => array(
  135. 'align' => '',
  136. 'separator' => '',
  137. 'empty_column' => 0,
  138. ),
  139. 'nothing_3' => array(
  140. 'align' => '',
  141. 'separator' => '',
  142. 'empty_column' => 0,
  143. ),
  144. 'nothing_1' => array(
  145. 'align' => '',
  146. 'separator' => '',
  147. 'empty_column' => 0,
  148. ),
  149. );
  150. /* Header: Global: Text area */
  151. $handler->display->display_options['header']['area']['id'] = 'area';
  152. $handler->display->display_options['header']['area']['table'] = 'views';
  153. $handler->display->display_options['header']['area']['field'] = 'area';
  154. $handler->display->display_options['header']['area']['label'] = 'Description';
  155. $handler->display->display_options['header']['area']['empty'] = TRUE;
  156. $handler->display->display_options['header']['area']['content'] = '<p>Waiting jobs are executed first by priority level (the lower the number the higher the priority) and second by the order they were entered.</p>';
  157. $handler->display->display_options['header']['area']['format'] = 'filtered_html';
  158. /* Field: Tripal Jobs: Job ID */
  159. $handler->display->display_options['fields']['job_id']['id'] = 'job_id';
  160. $handler->display->display_options['fields']['job_id']['table'] = 'tripal_jobs';
  161. $handler->display->display_options['fields']['job_id']['field'] = 'job_id';
  162. $handler->display->display_options['fields']['job_id']['label'] = '';
  163. $handler->display->display_options['fields']['job_id']['element_class'] = 'extra-short-column';
  164. $handler->display->display_options['fields']['job_id']['element_label_class'] = 'extra-short-column';
  165. $handler->display->display_options['fields']['job_id']['element_label_colon'] = FALSE;
  166. $handler->display->display_options['fields']['job_id']['separator'] = '';
  167. /* Field: Tripal Jobs: Job Name */
  168. $handler->display->display_options['fields']['job_name']['id'] = 'job_name';
  169. $handler->display->display_options['fields']['job_name']['table'] = 'tripal_jobs';
  170. $handler->display->display_options['fields']['job_name']['field'] = 'job_name';
  171. $handler->display->display_options['fields']['job_name']['alter']['make_link'] = TRUE;
  172. $handler->display->display_options['fields']['job_name']['alter']['path'] = 'admin/tripal/tripal_jobs/view/[job_id]';
  173. /* Field: Tripal Jobs: Submit Date */
  174. $handler->display->display_options['fields']['submit_date']['id'] = 'submit_date';
  175. $handler->display->display_options['fields']['submit_date']['table'] = 'tripal_jobs';
  176. $handler->display->display_options['fields']['submit_date']['field'] = 'submit_date';
  177. $handler->display->display_options['fields']['submit_date']['exclude'] = TRUE;
  178. $handler->display->display_options['fields']['submit_date']['date_format'] = 'long';
  179. /* Field: Tripal Jobs: Start Time */
  180. $handler->display->display_options['fields']['start_time']['id'] = 'start_time';
  181. $handler->display->display_options['fields']['start_time']['table'] = 'tripal_jobs';
  182. $handler->display->display_options['fields']['start_time']['field'] = 'start_time';
  183. $handler->display->display_options['fields']['start_time']['exclude'] = TRUE;
  184. $handler->display->display_options['fields']['start_time']['date_format'] = 'long';
  185. /* Field: Tripal Jobs: End Time */
  186. $handler->display->display_options['fields']['end_time']['id'] = 'end_time';
  187. $handler->display->display_options['fields']['end_time']['table'] = 'tripal_jobs';
  188. $handler->display->display_options['fields']['end_time']['field'] = 'end_time';
  189. $handler->display->display_options['fields']['end_time']['exclude'] = TRUE;
  190. $handler->display->display_options['fields']['end_time']['date_format'] = 'long';
  191. /* Field: Global: Custom text */
  192. $handler->display->display_options['fields']['nothing']['id'] = 'nothing';
  193. $handler->display->display_options['fields']['nothing']['table'] = 'views';
  194. $handler->display->display_options['fields']['nothing']['field'] = 'nothing';
  195. $handler->display->display_options['fields']['nothing']['label'] = 'Dates';
  196. $handler->display->display_options['fields']['nothing']['alter']['text'] = 'Submitted: [submit_date]<br />
  197. Started: [start_time]<br />
  198. Ended: [end_time]';
  199. /* Field: Tripal Jobs: Priority */
  200. $handler->display->display_options['fields']['priority']['id'] = 'priority';
  201. $handler->display->display_options['fields']['priority']['table'] = 'tripal_jobs';
  202. $handler->display->display_options['fields']['priority']['field'] = 'priority';
  203. $handler->display->display_options['fields']['priority']['element_class'] = 'short-column';
  204. $handler->display->display_options['fields']['priority']['element_label_class'] = 'short-column';
  205. $handler->display->display_options['fields']['priority']['separator'] = '';
  206. /* Field: Tripal Jobs: Progress */
  207. $handler->display->display_options['fields']['progress']['id'] = 'progress';
  208. $handler->display->display_options['fields']['progress']['table'] = 'tripal_jobs';
  209. $handler->display->display_options['fields']['progress']['field'] = 'progress';
  210. $handler->display->display_options['fields']['progress']['element_class'] = 'short-column';
  211. $handler->display->display_options['fields']['progress']['element_label_class'] = 'short-column';
  212. $handler->display->display_options['fields']['progress']['separator'] = '';
  213. $handler->display->display_options['fields']['progress']['suffix'] = '%';
  214. /* Field: Tripal Jobs: Status */
  215. $handler->display->display_options['fields']['status']['id'] = 'status';
  216. $handler->display->display_options['fields']['status']['table'] = 'tripal_jobs';
  217. $handler->display->display_options['fields']['status']['field'] = 'status';
  218. $handler->display->display_options['fields']['status']['element_class'] = 'short-column';
  219. $handler->display->display_options['fields']['status']['element_label_class'] = 'short-column';
  220. /* Field: Global: Custom text */
  221. $handler->display->display_options['fields']['nothing_2']['id'] = 'nothing_2';
  222. $handler->display->display_options['fields']['nothing_2']['table'] = 'views';
  223. $handler->display->display_options['fields']['nothing_2']['field'] = 'nothing';
  224. $handler->display->display_options['fields']['nothing_2']['label'] = 'Re-run Link';
  225. $handler->display->display_options['fields']['nothing_2']['exclude'] = TRUE;
  226. $handler->display->display_options['fields']['nothing_2']['alter']['text'] = 'Re-run';
  227. $handler->display->display_options['fields']['nothing_2']['alter']['make_link'] = TRUE;
  228. $handler->display->display_options['fields']['nothing_2']['alter']['path'] = 'admin/tripal/tripal_jobs/rerun/[job_id]';
  229. /* Field: Global: Custom text */
  230. $handler->display->display_options['fields']['nothing_3']['id'] = 'nothing_3';
  231. $handler->display->display_options['fields']['nothing_3']['table'] = 'views';
  232. $handler->display->display_options['fields']['nothing_3']['field'] = 'nothing';
  233. $handler->display->display_options['fields']['nothing_3']['label'] = 'Cancel link';
  234. $handler->display->display_options['fields']['nothing_3']['exclude'] = TRUE;
  235. $handler->display->display_options['fields']['nothing_3']['alter']['text'] = 'Cancel';
  236. $handler->display->display_options['fields']['nothing_3']['alter']['make_link'] = TRUE;
  237. $handler->display->display_options['fields']['nothing_3']['alter']['path'] = 'admin/tripal/tripal_jobs/cancel/[job_id]';
  238. /* Field: Global: Custom text */
  239. $handler->display->display_options['fields']['nothing_1']['id'] = 'nothing_1';
  240. $handler->display->display_options['fields']['nothing_1']['table'] = 'views';
  241. $handler->display->display_options['fields']['nothing_1']['field'] = 'nothing';
  242. $handler->display->display_options['fields']['nothing_1']['label'] = 'Action';
  243. $handler->display->display_options['fields']['nothing_1']['alter']['text'] = '[nothing_2]<br />
  244. [nothing_3]';
  245. $handler->display->display_options['fields']['nothing_1']['element_class'] = 'short-column';
  246. $handler->display->display_options['fields']['nothing_1']['element_label_class'] = 'short-column';
  247. /* Filter criterion: Tripal Jobs: Job Name */
  248. $handler->display->display_options['filters']['job_name']['id'] = 'job_name';
  249. $handler->display->display_options['filters']['job_name']['table'] = 'tripal_jobs';
  250. $handler->display->display_options['filters']['job_name']['field'] = 'job_name';
  251. $handler->display->display_options['filters']['job_name']['operator'] = 'contains';
  252. $handler->display->display_options['filters']['job_name']['exposed'] = TRUE;
  253. $handler->display->display_options['filters']['job_name']['expose']['operator_id'] = 'job_name_op';
  254. $handler->display->display_options['filters']['job_name']['expose']['label'] = 'Job Name Contains';
  255. $handler->display->display_options['filters']['job_name']['expose']['operator'] = 'job_name_op';
  256. $handler->display->display_options['filters']['job_name']['expose']['identifier'] = 'job_name';
  257. $handler->display->display_options['filters']['job_name']['expose']['remember_roles'] = array(
  258. 2 => '2',
  259. 1 => 0,
  260. 3 => 0,
  261. );
  262. /* Filter criterion: Tripal Jobs: Module Name */
  263. $handler->display->display_options['filters']['modulename']['id'] = 'modulename';
  264. $handler->display->display_options['filters']['modulename']['table'] = 'tripal_jobs';
  265. $handler->display->display_options['filters']['modulename']['field'] = 'modulename';
  266. $handler->display->display_options['filters']['modulename']['exposed'] = TRUE;
  267. $handler->display->display_options['filters']['modulename']['expose']['operator_id'] = 'modulename_op';
  268. $handler->display->display_options['filters']['modulename']['expose']['label'] = 'Submitting Module';
  269. $handler->display->display_options['filters']['modulename']['expose']['operator'] = 'modulename_op';
  270. $handler->display->display_options['filters']['modulename']['expose']['identifier'] = 'modulename';
  271. $handler->display->display_options['filters']['modulename']['expose']['remember_roles'] = array(
  272. 2 => '2',
  273. 1 => 0,
  274. 3 => 0,
  275. );
  276. /* Filter criterion: Tripal Jobs: Status */
  277. $handler->display->display_options['filters']['status']['id'] = 'status';
  278. $handler->display->display_options['filters']['status']['table'] = 'tripal_jobs';
  279. $handler->display->display_options['filters']['status']['field'] = 'status';
  280. $handler->display->display_options['filters']['status']['exposed'] = TRUE;
  281. $handler->display->display_options['filters']['status']['expose']['operator_id'] = 'status_op';
  282. $handler->display->display_options['filters']['status']['expose']['label'] = 'Job Status';
  283. $handler->display->display_options['filters']['status']['expose']['operator'] = 'status_op';
  284. $handler->display->display_options['filters']['status']['expose']['identifier'] = 'status';
  285. $handler->display->display_options['filters']['status']['expose']['remember_roles'] = array(
  286. 2 => '2',
  287. 1 => 0,
  288. 3 => 0,
  289. );
  290. /* Display: Page */
  291. $handler = $view->new_display('page', 'Page', 'page');
  292. $handler->display->display_options['path'] = 'admin/tripal/tripal_jobs/jobs';
  293. $handler->display->display_options['menu']['type'] = 'default tab';
  294. $handler->display->display_options['menu']['title'] = 'Jobs';
  295. $handler->display->display_options['menu']['description'] = 'Jobs managed by Tripal';
  296. $handler->display->display_options['menu']['weight'] = '-10';
  297. $handler->display->display_options['menu']['context'] = 0;
  298. $handler->display->display_options['menu']['context_only_inline'] = 0;
  299. $handler->display->display_options['tab_options']['weight'] = '0';
  300. return $view;
  301. }
  302. /**
  303. * Describes the custom tables administration view.
  304. *
  305. * @ingroup tripal_core
  306. */
  307. function tripal_core_admin_defaultview_custom_tables() {
  308. $view = new view();
  309. $view->name = 'tripal_core_admin_custom_table';
  310. $view->description = 'DO NOT DISABLE';
  311. $view->tag = 'tripal admin';
  312. $view->base_table = 'tripal_custom_tables';
  313. $view->human_name = 'Tripal Custom Table Admin';
  314. $view->core = 7;
  315. $view->api_version = '3.0';
  316. $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
  317. /* Display: Master */
  318. $handler = $view->new_display('default', 'Master', 'default');
  319. $handler->display->display_options['title'] = 'Custom Tables';
  320. $handler->display->display_options['use_more_always'] = FALSE;
  321. $handler->display->display_options['access']['type'] = 'none';
  322. $handler->display->display_options['cache']['type'] = 'none';
  323. $handler->display->display_options['query']['type'] = 'views_query';
  324. $handler->display->display_options['exposed_form']['type'] = 'basic';
  325. $handler->display->display_options['exposed_form']['options']['submit_button'] = 'Filter';
  326. $handler->display->display_options['pager']['type'] = 'full';
  327. $handler->display->display_options['pager']['options']['items_per_page'] = '25';
  328. $handler->display->display_options['style_plugin'] = 'table';
  329. /* Header: Global: Action Links */
  330. $handler->display->display_options['header']['action_links_area']['id'] = 'action_links_area';
  331. $handler->display->display_options['header']['action_links_area']['table'] = 'views';
  332. $handler->display->display_options['header']['action_links_area']['field'] = 'action_links_area';
  333. $handler->display->display_options['header']['action_links_area']['label'] = 'Action Links';
  334. $handler->display->display_options['header']['action_links_area']['empty'] = TRUE;
  335. $handler->display->display_options['header']['action_links_area']['link-1'] = array(
  336. 'label-1' => 'Add Custom Table',
  337. 'path-1' => 'admin/tripal/schema/custom_tables/new',
  338. );
  339. $handler->display->display_options['header']['action_links_area']['link-2'] = array(
  340. 'label-2' => '',
  341. 'path-2' => '',
  342. );
  343. $handler->display->display_options['header']['action_links_area']['link-3'] = array(
  344. 'label-3' => '',
  345. 'path-3' => '',
  346. );
  347. $handler->display->display_options['header']['action_links_area']['link-4'] = array(
  348. 'label-4' => '',
  349. 'path-4' => '',
  350. );
  351. /* Field: Tripal Custom Tables: Custom Table ID */
  352. $handler->display->display_options['fields']['table_id']['id'] = 'table_id';
  353. $handler->display->display_options['fields']['table_id']['table'] = 'tripal_custom_tables';
  354. $handler->display->display_options['fields']['table_id']['field'] = 'table_id';
  355. $handler->display->display_options['fields']['table_id']['label'] = 'ID';
  356. $handler->display->display_options['fields']['table_id']['element_class'] = 'extra-short-column';
  357. $handler->display->display_options['fields']['table_id']['element_label_class'] = 'extra-short-column';
  358. $handler->display->display_options['fields']['table_id']['element_label_colon'] = FALSE;
  359. $handler->display->display_options['fields']['table_id']['separator'] = '';
  360. /* Field: Tripal Custom Tables: Table Name */
  361. $handler->display->display_options['fields']['table_name']['id'] = 'table_name';
  362. $handler->display->display_options['fields']['table_name']['table'] = 'tripal_custom_tables';
  363. $handler->display->display_options['fields']['table_name']['field'] = 'table_name';
  364. $handler->display->display_options['fields']['table_name']['label'] = 'Name';
  365. $handler->display->display_options['fields']['table_name']['alter']['make_link'] = TRUE;
  366. $handler->display->display_options['fields']['table_name']['alter']['path'] = 'admin/tripal/schema/custom_tables/view/[table_id]';
  367. /* Field: Tripal Custom Tables: Materialized View ID */
  368. $handler->display->display_options['fields']['mview_id']['id'] = 'mview_id';
  369. $handler->display->display_options['fields']['mview_id']['table'] = 'tripal_custom_tables';
  370. $handler->display->display_options['fields']['mview_id']['field'] = 'mview_id';
  371. $handler->display->display_options['fields']['mview_id']['label'] = 'Is MView';
  372. $handler->display->display_options['fields']['mview_id']['alter']['alter_text'] = TRUE;
  373. $handler->display->display_options['fields']['mview_id']['alter']['text'] = 'Yes';
  374. $handler->display->display_options['fields']['mview_id']['hide_empty'] = TRUE;
  375. $handler->display->display_options['fields']['mview_id']['empty_zero'] = TRUE;
  376. /* Field: Global: Custom text */
  377. $handler->display->display_options['fields']['nothing']['id'] = 'nothing';
  378. $handler->display->display_options['fields']['nothing']['table'] = 'views';
  379. $handler->display->display_options['fields']['nothing']['field'] = 'nothing';
  380. $handler->display->display_options['fields']['nothing']['label'] = 'Edit Link';
  381. $handler->display->display_options['fields']['nothing']['exclude'] = TRUE;
  382. $handler->display->display_options['fields']['nothing']['alter']['text'] = 'Edit';
  383. $handler->display->display_options['fields']['nothing']['alter']['make_link'] = TRUE;
  384. $handler->display->display_options['fields']['nothing']['alter']['path'] = 'admin/tripal/schema/custom_tables/edit/[table_id]';
  385. /* Field: Global: Custom text */
  386. $handler->display->display_options['fields']['nothing_1']['id'] = 'nothing_1';
  387. $handler->display->display_options['fields']['nothing_1']['table'] = 'views';
  388. $handler->display->display_options['fields']['nothing_1']['field'] = 'nothing';
  389. $handler->display->display_options['fields']['nothing_1']['label'] = 'Delete Link';
  390. $handler->display->display_options['fields']['nothing_1']['exclude'] = TRUE;
  391. $handler->display->display_options['fields']['nothing_1']['alter']['text'] = 'Delete';
  392. $handler->display->display_options['fields']['nothing_1']['alter']['make_link'] = TRUE;
  393. $handler->display->display_options['fields']['nothing_1']['alter']['path'] = 'admin/tripal/schema/custom_tables/delete/[table_id]';
  394. /* Field: Global: Custom text */
  395. $handler->display->display_options['fields']['nothing_2']['id'] = 'nothing_2';
  396. $handler->display->display_options['fields']['nothing_2']['table'] = 'views';
  397. $handler->display->display_options['fields']['nothing_2']['field'] = 'nothing';
  398. $handler->display->display_options['fields']['nothing_2']['label'] = '';
  399. $handler->display->display_options['fields']['nothing_2']['alter']['text'] = '[nothing] [nothing_1]';
  400. $handler->display->display_options['fields']['nothing_2']['element_label_colon'] = FALSE;
  401. /* Filter criterion: Tripal Custom Tables: Table Name */
  402. $handler->display->display_options['filters']['table_name']['id'] = 'table_name';
  403. $handler->display->display_options['filters']['table_name']['table'] = 'tripal_custom_tables';
  404. $handler->display->display_options['filters']['table_name']['field'] = 'table_name';
  405. $handler->display->display_options['filters']['table_name']['exposed'] = TRUE;
  406. $handler->display->display_options['filters']['table_name']['expose']['operator_id'] = 'table_name_op';
  407. $handler->display->display_options['filters']['table_name']['expose']['label'] = 'Table Name';
  408. $handler->display->display_options['filters']['table_name']['expose']['operator'] = 'table_name_op';
  409. $handler->display->display_options['filters']['table_name']['expose']['identifier'] = 'table_name';
  410. $handler->display->display_options['filters']['table_name']['expose']['remember_roles'] = array(
  411. 2 => '2',
  412. 1 => 0,
  413. 3 => 0,
  414. );
  415. /* Display: Page */
  416. $handler = $view->new_display('page', 'Page', 'page');
  417. $handler->display->display_options['path'] = 'admin/tripal/schema/custom_tables/tables';
  418. $handler->display->display_options['menu']['type'] = 'default tab';
  419. $handler->display->display_options['menu']['title'] = 'Custom Tables';
  420. $handler->display->display_options['menu']['description'] = 'A list of existing custom tables';
  421. $handler->display->display_options['menu']['weight'] = '-10';
  422. $handler->display->display_options['menu']['name'] = 'management';
  423. $handler->display->display_options['menu']['context'] = 0;
  424. $handler->display->display_options['menu']['context_only_inline'] = 0;
  425. $handler->display->display_options['tab_options']['weight'] = '0';
  426. return $view;
  427. }
  428. /**
  429. * Describes the materialized views administration view.
  430. *
  431. * @ingroup tripal_core
  432. */
  433. function tripal_core_admin_defaultview_mviews() {
  434. $view = new view();
  435. $view->name = 'tripal_core_admin_mviews';
  436. $view->description = 'DO NOT DISABLE';
  437. $view->tag = 'tripal admin';
  438. $view->base_table = 'tripal_mviews';
  439. $view->human_name = 'MView Admin';
  440. $view->core = 7;
  441. $view->api_version = '3.0';
  442. $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
  443. /* Display: Master */
  444. $handler = $view->new_display('default', 'Master', 'default');
  445. $handler->display->display_options['title'] = 'Materialized Views';
  446. $handler->display->display_options['use_more_always'] = FALSE;
  447. $handler->display->display_options['access']['type'] = 'none';
  448. $handler->display->display_options['cache']['type'] = 'none';
  449. $handler->display->display_options['query']['type'] = 'views_query';
  450. $handler->display->display_options['exposed_form']['type'] = 'basic';
  451. $handler->display->display_options['exposed_form']['options']['submit_button'] = 'Filter';
  452. $handler->display->display_options['pager']['type'] = 'full';
  453. $handler->display->display_options['pager']['options']['items_per_page'] = '25';
  454. $handler->display->display_options['style_plugin'] = 'table';
  455. $handler->display->display_options['style_options']['columns'] = array(
  456. 'mview_id' => 'mview_id',
  457. 'name' => 'name',
  458. 'mv_table' => 'mv_table',
  459. 'comment' => 'comment',
  460. 'last_update' => 'last_update',
  461. 'status' => 'status',
  462. );
  463. $handler->display->display_options['style_options']['default'] = 'mview_id';
  464. $handler->display->display_options['style_options']['info'] = array(
  465. 'mview_id' => array(
  466. 'sortable' => 1,
  467. 'default_sort_order' => 'asc',
  468. 'align' => '',
  469. 'separator' => '',
  470. 'empty_column' => 0,
  471. ),
  472. 'name' => array(
  473. 'sortable' => 1,
  474. 'default_sort_order' => 'asc',
  475. 'align' => '',
  476. 'separator' => '',
  477. 'empty_column' => 0,
  478. ),
  479. 'mv_table' => array(
  480. 'sortable' => 1,
  481. 'default_sort_order' => 'asc',
  482. 'align' => '',
  483. 'separator' => '',
  484. 'empty_column' => 0,
  485. ),
  486. 'comment' => array(
  487. 'sortable' => 0,
  488. 'default_sort_order' => 'asc',
  489. 'align' => '',
  490. 'separator' => '',
  491. 'empty_column' => 0,
  492. ),
  493. 'last_update' => array(
  494. 'sortable' => 1,
  495. 'default_sort_order' => 'asc',
  496. 'align' => '',
  497. 'separator' => '',
  498. 'empty_column' => 0,
  499. ),
  500. 'status' => array(
  501. 'sortable' => 1,
  502. 'default_sort_order' => 'asc',
  503. 'align' => '',
  504. 'separator' => '',
  505. 'empty_column' => 0,
  506. ),
  507. );
  508. /* Header: Global: Text area */
  509. $handler->display->display_options['header']['area']['id'] = 'area';
  510. $handler->display->display_options['header']['area']['table'] = 'views';
  511. $handler->display->display_options['header']['area']['field'] = 'area';
  512. $handler->display->display_options['header']['area']['label'] = 'Description';
  513. $handler->display->display_options['header']['area']['empty'] = TRUE;
  514. $handler->display->display_options['header']['area']['content'] = '<p>Materialized Views (MViews) are custom tables populated with a defined SQL statement. Because Chado is highly normalized and highly constrained it serves as a wonderful data storage platform, but unfortunately some queries may be slow. MViews alleviate slowness by aggregating data into tables that are more easy to query. Use MViews to create tables for custom search pages or custom Tripal module development.</p>
  515. <p>MViews behaves in the following way:</p>
  516. <ul>
  517. <li>The SQL statement defined for an MVIEW will be used to populate the table</li>
  518. <li>Altering the table structure of an MView will cause the MView table to be dropped and recreated. All records in the MView will be lost.</li>
  519. <li>Altering the query of an existing view will not change the MView table. No records will be lost.</li>
  520. <li>Repopulating an MView that is already populated will result in replacement of all records.</li>
  521. <li>A database transaction will be used when populating MViews. Therefore replacement of records does not occur until the query completes. Any search forms or pages dependent on the MView will continue to function.</li>
  522. </ul>';
  523. $handler->display->display_options['header']['area']['format'] = 'full_html';
  524. /* Header: Global: Action Links */
  525. $handler->display->display_options['header']['action_links_area']['id'] = 'action_links_area';
  526. $handler->display->display_options['header']['action_links_area']['table'] = 'views';
  527. $handler->display->display_options['header']['action_links_area']['field'] = 'action_links_area';
  528. $handler->display->display_options['header']['action_links_area']['label'] = 'Action Links';
  529. $handler->display->display_options['header']['action_links_area']['link-1'] = array(
  530. 'label-1' => 'Add Materialized View',
  531. 'path-1' => 'admin/tripal/schema/mviews/new',
  532. );
  533. $handler->display->display_options['header']['action_links_area']['link-2'] = array(
  534. 'label-2' => '',
  535. 'path-2' => '',
  536. );
  537. $handler->display->display_options['header']['action_links_area']['link-3'] = array(
  538. 'label-3' => '',
  539. 'path-3' => '',
  540. );
  541. $handler->display->display_options['header']['action_links_area']['link-4'] = array(
  542. 'label-4' => '',
  543. 'path-4' => '',
  544. );
  545. /* Field: Tripal Materialized Views: Materialized View ID */
  546. $handler->display->display_options['fields']['mview_id']['id'] = 'mview_id';
  547. $handler->display->display_options['fields']['mview_id']['table'] = 'tripal_mviews';
  548. $handler->display->display_options['fields']['mview_id']['field'] = 'mview_id';
  549. $handler->display->display_options['fields']['mview_id']['label'] = '';
  550. $handler->display->display_options['fields']['mview_id']['element_class'] = 'extra-short-column';
  551. $handler->display->display_options['fields']['mview_id']['element_label_class'] = 'extra-short-column';
  552. $handler->display->display_options['fields']['mview_id']['element_label_colon'] = FALSE;
  553. $handler->display->display_options['fields']['mview_id']['separator'] = '';
  554. /* Field: Tripal Materialized Views: Name */
  555. $handler->display->display_options['fields']['name']['id'] = 'name';
  556. $handler->display->display_options['fields']['name']['table'] = 'tripal_mviews';
  557. $handler->display->display_options['fields']['name']['field'] = 'name';
  558. $handler->display->display_options['fields']['name']['alter']['make_link'] = TRUE;
  559. $handler->display->display_options['fields']['name']['alter']['path'] = 'admin/tripal/schema/mviews/report/[mview_id]';
  560. /* Field: Tripal Materialized Views: Table */
  561. $handler->display->display_options['fields']['mv_table']['id'] = 'mv_table';
  562. $handler->display->display_options['fields']['mv_table']['table'] = 'tripal_mviews';
  563. $handler->display->display_options['fields']['mv_table']['field'] = 'mv_table';
  564. $handler->display->display_options['fields']['mv_table']['label'] = 'Table Name';
  565. /* Field: Tripal Materialized Views: Description */
  566. $handler->display->display_options['fields']['comment']['id'] = 'comment';
  567. $handler->display->display_options['fields']['comment']['table'] = 'tripal_mviews';
  568. $handler->display->display_options['fields']['comment']['field'] = 'comment';
  569. /* Field: Tripal Materialized Views: Updated */
  570. $handler->display->display_options['fields']['last_update']['id'] = 'last_update';
  571. $handler->display->display_options['fields']['last_update']['table'] = 'tripal_mviews';
  572. $handler->display->display_options['fields']['last_update']['field'] = 'last_update';
  573. $handler->display->display_options['fields']['last_update']['label'] = 'Last Updated';
  574. $handler->display->display_options['fields']['last_update']['date_format'] = 'long';
  575. /* Field: Tripal Materialized Views: Status */
  576. $handler->display->display_options['fields']['status']['id'] = 'status';
  577. $handler->display->display_options['fields']['status']['table'] = 'tripal_mviews';
  578. $handler->display->display_options['fields']['status']['field'] = 'status';
  579. $handler->display->display_options['fields']['status']['empty'] = 'Not yet populated';
  580. /* Field: Global: Custom text */
  581. $handler->display->display_options['fields']['nothing']['id'] = 'nothing';
  582. $handler->display->display_options['fields']['nothing']['table'] = 'views';
  583. $handler->display->display_options['fields']['nothing']['field'] = 'nothing';
  584. $handler->display->display_options['fields']['nothing']['label'] = 'Edit Link';
  585. $handler->display->display_options['fields']['nothing']['exclude'] = TRUE;
  586. $handler->display->display_options['fields']['nothing']['alter']['text'] = 'Edit';
  587. $handler->display->display_options['fields']['nothing']['alter']['make_link'] = TRUE;
  588. $handler->display->display_options['fields']['nothing']['alter']['path'] = 'admin/tripal/schema/mviews/edit/[mview_id]';
  589. /* Field: Global: Custom text */
  590. $handler->display->display_options['fields']['nothing_1']['id'] = 'nothing_1';
  591. $handler->display->display_options['fields']['nothing_1']['table'] = 'views';
  592. $handler->display->display_options['fields']['nothing_1']['field'] = 'nothing';
  593. $handler->display->display_options['fields']['nothing_1']['label'] = 'Delete Link';
  594. $handler->display->display_options['fields']['nothing_1']['exclude'] = TRUE;
  595. $handler->display->display_options['fields']['nothing_1']['alter']['text'] = 'Delete';
  596. $handler->display->display_options['fields']['nothing_1']['alter']['make_link'] = TRUE;
  597. $handler->display->display_options['fields']['nothing_1']['alter']['path'] = 'admin/tripal/schema/mviews/delete/[mview_id]';
  598. /* Field: Global: Custom text */
  599. $handler->display->display_options['fields']['nothing_2']['id'] = 'nothing_2';
  600. $handler->display->display_options['fields']['nothing_2']['table'] = 'views';
  601. $handler->display->display_options['fields']['nothing_2']['field'] = 'nothing';
  602. $handler->display->display_options['fields']['nothing_2']['label'] = 'Populate Link';
  603. $handler->display->display_options['fields']['nothing_2']['exclude'] = TRUE;
  604. $handler->display->display_options['fields']['nothing_2']['alter']['text'] = 'Populate';
  605. $handler->display->display_options['fields']['nothing_2']['alter']['make_link'] = TRUE;
  606. $handler->display->display_options['fields']['nothing_2']['alter']['path'] = 'admin/tripal/schema/mviews/update/[mview_id]';
  607. /* Field: Global: Custom text */
  608. $handler->display->display_options['fields']['nothing_3']['id'] = 'nothing_3';
  609. $handler->display->display_options['fields']['nothing_3']['table'] = 'views';
  610. $handler->display->display_options['fields']['nothing_3']['field'] = 'nothing';
  611. $handler->display->display_options['fields']['nothing_3']['label'] = '';
  612. $handler->display->display_options['fields']['nothing_3']['alter']['text'] = '[nothing] [nothing_1]<br />
  613. [nothing_2]';
  614. $handler->display->display_options['fields']['nothing_3']['element_class'] = 'short-column';
  615. $handler->display->display_options['fields']['nothing_3']['element_label_class'] = 'short-column';
  616. $handler->display->display_options['fields']['nothing_3']['element_label_colon'] = FALSE;
  617. /* Filter criterion: Tripal Materialized Views: Name */
  618. $handler->display->display_options['filters']['name']['id'] = 'name';
  619. $handler->display->display_options['filters']['name']['table'] = 'tripal_mviews';
  620. $handler->display->display_options['filters']['name']['field'] = 'name';
  621. $handler->display->display_options['filters']['name']['group'] = 1;
  622. $handler->display->display_options['filters']['name']['exposed'] = TRUE;
  623. $handler->display->display_options['filters']['name']['expose']['operator_id'] = 'name_op';
  624. $handler->display->display_options['filters']['name']['expose']['label'] = 'Name';
  625. $handler->display->display_options['filters']['name']['expose']['operator'] = 'name_op';
  626. $handler->display->display_options['filters']['name']['expose']['identifier'] = 'name';
  627. $handler->display->display_options['filters']['name']['expose']['remember_roles'] = array(
  628. 2 => '2',
  629. 1 => 0,
  630. 3 => 0,
  631. );
  632. /* Filter criterion: Tripal Materialized Views: Table */
  633. $handler->display->display_options['filters']['mv_table']['id'] = 'mv_table';
  634. $handler->display->display_options['filters']['mv_table']['table'] = 'tripal_mviews';
  635. $handler->display->display_options['filters']['mv_table']['field'] = 'mv_table';
  636. $handler->display->display_options['filters']['mv_table']['group'] = 1;
  637. $handler->display->display_options['filters']['mv_table']['exposed'] = TRUE;
  638. $handler->display->display_options['filters']['mv_table']['expose']['operator_id'] = 'mv_table_op';
  639. $handler->display->display_options['filters']['mv_table']['expose']['label'] = 'Table Name';
  640. $handler->display->display_options['filters']['mv_table']['expose']['operator'] = 'mv_table_op';
  641. $handler->display->display_options['filters']['mv_table']['expose']['identifier'] = 'mv_table';
  642. $handler->display->display_options['filters']['mv_table']['expose']['remember_roles'] = array(
  643. 2 => '2',
  644. 1 => 0,
  645. 3 => 0,
  646. );
  647. /* Filter criterion: Tripal Materialized Views: Module Name */
  648. $handler->display->display_options['filters']['modulename']['id'] = 'modulename';
  649. $handler->display->display_options['filters']['modulename']['table'] = 'tripal_mviews';
  650. $handler->display->display_options['filters']['modulename']['field'] = 'modulename';
  651. $handler->display->display_options['filters']['modulename']['group'] = 1;
  652. $handler->display->display_options['filters']['modulename']['exposed'] = TRUE;
  653. $handler->display->display_options['filters']['modulename']['expose']['operator_id'] = 'modulename_op';
  654. $handler->display->display_options['filters']['modulename']['expose']['label'] = 'Module';
  655. $handler->display->display_options['filters']['modulename']['expose']['operator'] = 'modulename_op';
  656. $handler->display->display_options['filters']['modulename']['expose']['identifier'] = 'modulename';
  657. $handler->display->display_options['filters']['modulename']['expose']['remember_roles'] = array(
  658. 2 => '2',
  659. 1 => 0,
  660. 3 => 0,
  661. );
  662. /* Filter criterion: Tripal Materialized Views: Status */
  663. $handler->display->display_options['filters']['status']['id'] = 'status';
  664. $handler->display->display_options['filters']['status']['table'] = 'tripal_mviews';
  665. $handler->display->display_options['filters']['status']['field'] = 'status';
  666. $handler->display->display_options['filters']['status']['group'] = 1;
  667. $handler->display->display_options['filters']['status']['exposed'] = TRUE;
  668. $handler->display->display_options['filters']['status']['expose']['operator_id'] = 'status_op';
  669. $handler->display->display_options['filters']['status']['expose']['label'] = 'Status';
  670. $handler->display->display_options['filters']['status']['expose']['operator'] = 'status_op';
  671. $handler->display->display_options['filters']['status']['expose']['identifier'] = 'status';
  672. $handler->display->display_options['filters']['status']['expose']['remember_roles'] = array(
  673. 2 => '2',
  674. 1 => 0,
  675. 3 => 0,
  676. );
  677. /* Display: Page */
  678. $handler = $view->new_display('page', 'Page', 'page');
  679. $handler->display->display_options['path'] = 'admin/tripal/schema/mviews/mviews';
  680. $handler->display->display_options['menu']['type'] = 'default tab';
  681. $handler->display->display_options['menu']['title'] = 'Materialized Views';
  682. $handler->display->display_options['menu']['description'] = 'a list of mviews';
  683. $handler->display->display_options['menu']['weight'] = '-10';
  684. $handler->display->display_options['menu']['name'] = 'management';
  685. $handler->display->display_options['menu']['context'] = 0;
  686. $handler->display->display_options['menu']['context_only_inline'] = 0;
  687. $handler->display->display_options['tab_options']['weight'] = '0';
  688. return $view;
  689. }
  690. /**
  691. * Provides a default search view for the Search API "Default Node Index".
  692. */
  693. function tripal_core_search_default_node_index() {
  694. $view = new view();
  695. $view->name = 'search_api_default_node_search';
  696. $view->description = 'A default keyword-based search view using the search API "Default node index".';
  697. $view->tag = 'search';
  698. $view->base_table = 'search_api_index_default_node_index';
  699. $view->human_name = 'Search';
  700. $view->core = 7;
  701. $view->api_version = '3.0';
  702. $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
  703. /* Display: Master */
  704. $handler = $view->new_display('default', 'Master', 'default');
  705. $handler->display->display_options['title'] = 'Search';
  706. $handler->display->display_options['use_more_always'] = FALSE;
  707. $handler->display->display_options['access']['type'] = 'none';
  708. $handler->display->display_options['cache']['type'] = 'none';
  709. $handler->display->display_options['query']['type'] = 'views_query';
  710. $handler->display->display_options['exposed_form']['type'] = 'input_required';
  711. $handler->display->display_options['exposed_form']['options']['submit_button'] = 'Search';
  712. $handler->display->display_options['exposed_form']['options']['expose_sort_order'] = FALSE;
  713. $handler->display->display_options['exposed_form']['options']['text_input_required'] = '';
  714. $handler->display->display_options['exposed_form']['options']['text_input_required_format'] = 'filtered_html';
  715. $handler->display->display_options['pager']['type'] = 'full';
  716. $handler->display->display_options['pager']['options']['items_per_page'] = '25';
  717. $handler->display->display_options['pager']['options']['offset'] = '0';
  718. $handler->display->display_options['pager']['options']['id'] = '0';
  719. $handler->display->display_options['pager']['options']['quantity'] = '9';
  720. $handler->display->display_options['style_plugin'] = 'default';
  721. $handler->display->display_options['row_plugin'] = 'fields';
  722. /* Field: Content: Rendered Node */
  723. $handler->display->display_options['fields']['rendered_entity']['id'] = 'rendered_entity';
  724. $handler->display->display_options['fields']['rendered_entity']['table'] = 'views_entity_node';
  725. $handler->display->display_options['fields']['rendered_entity']['field'] = 'rendered_entity';
  726. $handler->display->display_options['fields']['rendered_entity']['label'] = '';
  727. $handler->display->display_options['fields']['rendered_entity']['element_label_colon'] = FALSE;
  728. $handler->display->display_options['fields']['rendered_entity']['link_to_entity'] = 1;
  729. $handler->display->display_options['fields']['rendered_entity']['display'] = 'view';
  730. $handler->display->display_options['fields']['rendered_entity']['view_mode'] = 'teaser';
  731. $handler->display->display_options['fields']['rendered_entity']['bypass_access'] = 0;
  732. /* Sort criterion: Search: Relevance */
  733. $handler->display->display_options['sorts']['search_api_relevance']['id'] = 'search_api_relevance';
  734. $handler->display->display_options['sorts']['search_api_relevance']['table'] = 'search_api_index_default_node_index';
  735. $handler->display->display_options['sorts']['search_api_relevance']['field'] = 'search_api_relevance';
  736. $handler->display->display_options['sorts']['search_api_relevance']['order'] = 'DESC';
  737. /* Filter criterion: Search: Fulltext search */
  738. $handler->display->display_options['filters']['search_api_views_fulltext']['id'] = 'search_api_views_fulltext';
  739. $handler->display->display_options['filters']['search_api_views_fulltext']['table'] = 'search_api_index_default_node_index';
  740. $handler->display->display_options['filters']['search_api_views_fulltext']['field'] = 'search_api_views_fulltext';
  741. $handler->display->display_options['filters']['search_api_views_fulltext']['operator'] = 'OR';
  742. $handler->display->display_options['filters']['search_api_views_fulltext']['exposed'] = TRUE;
  743. $handler->display->display_options['filters']['search_api_views_fulltext']['expose']['operator_id'] = 'search_api_views_fulltext_op';
  744. $handler->display->display_options['filters']['search_api_views_fulltext']['expose']['label'] = 'Keywords';
  745. $handler->display->display_options['filters']['search_api_views_fulltext']['expose']['operator'] = 'search_api_views_fulltext_op';
  746. $handler->display->display_options['filters']['search_api_views_fulltext']['expose']['identifier'] = 'keywords';
  747. $handler->display->display_options['filters']['search_api_views_fulltext']['expose']['remember_roles'] = array(
  748. 2 => '2',
  749. 1 => 0,
  750. 3 => 0,
  751. );
  752. /* Display: Page */
  753. $handler = $view->new_display('page', 'Page', 'page');
  754. $handler->display->display_options['path'] = 'chado';
  755. $handler->display->display_options['menu']['type'] = 'normal';
  756. $handler->display->display_options['menu']['title'] = 'Search';
  757. $handler->display->display_options['menu']['description'] = 'General keyword search of all content.';
  758. $handler->display->display_options['menu']['weight'] = '0';
  759. $handler->display->display_options['menu']['context'] = 0;
  760. $handler->display->display_options['menu']['context_only_inline'] = 0;
  761. return $view;
  762. }