tripal_core.views_default.inc 37 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670
  1. <?php
  2. /**
  3. *
  4. */
  5. function tripal_core_views_default_views() {
  6. $views = array();
  7. $view = tripal_core_admin_defaultview_jobs();
  8. $views[$view->name] = $view;
  9. $view = tripal_core_admin_defaultview_custom_tables();
  10. $views[$view->name] = $view;
  11. $view = tripal_core_admin_defaultview_mviews();
  12. $views[$view->name] = $view;
  13. return $views;
  14. }
  15. function tripal_core_admin_defaultview_jobs() {
  16. $view = new view();
  17. $view->name = 'tripal_core_admin_jobs';
  18. $view->description = 'DO NOT DISABLE';
  19. $view->tag = 'tripal admin';
  20. $view->base_table = 'tripal_jobs';
  21. $view->human_name = 'Jobs Admin';
  22. $view->core = 7;
  23. $view->api_version = '3.0';
  24. $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
  25. /* Display: Master */
  26. $handler = $view->new_display('default', 'Master', 'default');
  27. $handler->display->display_options['title'] = 'Jobs';
  28. $handler->display->display_options['use_more_always'] = FALSE;
  29. $handler->display->display_options['access']['type'] = 'none';
  30. $handler->display->display_options['cache']['type'] = 'none';
  31. $handler->display->display_options['query']['type'] = 'views_query';
  32. $handler->display->display_options['exposed_form']['type'] = 'basic';
  33. $handler->display->display_options['exposed_form']['options']['submit_button'] = 'Filter';
  34. $handler->display->display_options['pager']['type'] = 'full';
  35. $handler->display->display_options['pager']['options']['items_per_page'] = '25';
  36. $handler->display->display_options['style_plugin'] = 'table';
  37. $handler->display->display_options['style_options']['columns'] = array(
  38. 'job_id' => 'job_id',
  39. 'job_name' => 'job_name',
  40. 'submit_date' => 'submit_date',
  41. 'start_time' => 'start_time',
  42. 'end_time' => 'end_time',
  43. 'nothing' => 'nothing',
  44. 'priority' => 'priority',
  45. 'progress' => 'progress',
  46. 'status' => 'status',
  47. 'nothing_2' => 'nothing_2',
  48. 'nothing_3' => 'nothing_3',
  49. 'nothing_1' => 'nothing_1',
  50. );
  51. $handler->display->display_options['style_options']['default'] = 'job_id';
  52. $handler->display->display_options['style_options']['info'] = array(
  53. 'job_id' => array(
  54. 'sortable' => 1,
  55. 'default_sort_order' => 'asc',
  56. 'align' => '',
  57. 'separator' => '',
  58. 'empty_column' => 0,
  59. ),
  60. 'job_name' => array(
  61. 'sortable' => 1,
  62. 'default_sort_order' => 'asc',
  63. 'align' => '',
  64. 'separator' => '',
  65. 'empty_column' => 0,
  66. ),
  67. 'submit_date' => array(
  68. 'sortable' => 0,
  69. 'default_sort_order' => 'asc',
  70. 'align' => '',
  71. 'separator' => '',
  72. 'empty_column' => 0,
  73. ),
  74. 'start_time' => array(
  75. 'sortable' => 0,
  76. 'default_sort_order' => 'asc',
  77. 'align' => '',
  78. 'separator' => '',
  79. 'empty_column' => 0,
  80. ),
  81. 'end_time' => array(
  82. 'sortable' => 0,
  83. 'default_sort_order' => 'asc',
  84. 'align' => '',
  85. 'separator' => '',
  86. 'empty_column' => 0,
  87. ),
  88. 'nothing' => array(
  89. 'align' => '',
  90. 'separator' => '',
  91. 'empty_column' => 0,
  92. ),
  93. 'priority' => array(
  94. 'sortable' => 1,
  95. 'default_sort_order' => 'asc',
  96. 'align' => '',
  97. 'separator' => '',
  98. 'empty_column' => 0,
  99. ),
  100. 'progress' => array(
  101. 'sortable' => 1,
  102. 'default_sort_order' => 'asc',
  103. 'align' => '',
  104. 'separator' => '',
  105. 'empty_column' => 0,
  106. ),
  107. 'status' => array(
  108. 'sortable' => 1,
  109. 'default_sort_order' => 'asc',
  110. 'align' => '',
  111. 'separator' => '',
  112. 'empty_column' => 0,
  113. ),
  114. 'nothing_2' => array(
  115. 'align' => '',
  116. 'separator' => '',
  117. 'empty_column' => 0,
  118. ),
  119. 'nothing_3' => array(
  120. 'align' => '',
  121. 'separator' => '',
  122. 'empty_column' => 0,
  123. ),
  124. 'nothing_1' => array(
  125. 'align' => '',
  126. 'separator' => '',
  127. 'empty_column' => 0,
  128. ),
  129. );
  130. /* Header: Global: Text area */
  131. $handler->display->display_options['header']['area']['id'] = 'area';
  132. $handler->display->display_options['header']['area']['table'] = 'views';
  133. $handler->display->display_options['header']['area']['field'] = 'area';
  134. $handler->display->display_options['header']['area']['label'] = 'Description';
  135. $handler->display->display_options['header']['area']['empty'] = TRUE;
  136. $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>';
  137. $handler->display->display_options['header']['area']['format'] = 'filtered_html';
  138. /* Field: Tripal Jobs: Job ID */
  139. $handler->display->display_options['fields']['job_id']['id'] = 'job_id';
  140. $handler->display->display_options['fields']['job_id']['table'] = 'tripal_jobs';
  141. $handler->display->display_options['fields']['job_id']['field'] = 'job_id';
  142. $handler->display->display_options['fields']['job_id']['label'] = '';
  143. $handler->display->display_options['fields']['job_id']['element_class'] = 'extra-short-column';
  144. $handler->display->display_options['fields']['job_id']['element_label_class'] = 'extra-short-column';
  145. $handler->display->display_options['fields']['job_id']['element_label_colon'] = FALSE;
  146. $handler->display->display_options['fields']['job_id']['separator'] = '';
  147. /* Field: Tripal Jobs: Job Name */
  148. $handler->display->display_options['fields']['job_name']['id'] = 'job_name';
  149. $handler->display->display_options['fields']['job_name']['table'] = 'tripal_jobs';
  150. $handler->display->display_options['fields']['job_name']['field'] = 'job_name';
  151. $handler->display->display_options['fields']['job_name']['alter']['make_link'] = TRUE;
  152. $handler->display->display_options['fields']['job_name']['alter']['path'] = 'admin/tripal/tripal_jobs/view/[job_id]';
  153. /* Field: Tripal Jobs: Submit Date */
  154. $handler->display->display_options['fields']['submit_date']['id'] = 'submit_date';
  155. $handler->display->display_options['fields']['submit_date']['table'] = 'tripal_jobs';
  156. $handler->display->display_options['fields']['submit_date']['field'] = 'submit_date';
  157. $handler->display->display_options['fields']['submit_date']['exclude'] = TRUE;
  158. $handler->display->display_options['fields']['submit_date']['date_format'] = 'long';
  159. /* Field: Tripal Jobs: Start Time */
  160. $handler->display->display_options['fields']['start_time']['id'] = 'start_time';
  161. $handler->display->display_options['fields']['start_time']['table'] = 'tripal_jobs';
  162. $handler->display->display_options['fields']['start_time']['field'] = 'start_time';
  163. $handler->display->display_options['fields']['start_time']['exclude'] = TRUE;
  164. $handler->display->display_options['fields']['start_time']['date_format'] = 'long';
  165. /* Field: Tripal Jobs: End Time */
  166. $handler->display->display_options['fields']['end_time']['id'] = 'end_time';
  167. $handler->display->display_options['fields']['end_time']['table'] = 'tripal_jobs';
  168. $handler->display->display_options['fields']['end_time']['field'] = 'end_time';
  169. $handler->display->display_options['fields']['end_time']['exclude'] = TRUE;
  170. $handler->display->display_options['fields']['end_time']['date_format'] = 'long';
  171. /* Field: Global: Custom text */
  172. $handler->display->display_options['fields']['nothing']['id'] = 'nothing';
  173. $handler->display->display_options['fields']['nothing']['table'] = 'views';
  174. $handler->display->display_options['fields']['nothing']['field'] = 'nothing';
  175. $handler->display->display_options['fields']['nothing']['label'] = 'Dates';
  176. $handler->display->display_options['fields']['nothing']['alter']['text'] = 'Submitted: [submit_date]<br />
  177. Started: [start_time]<br />
  178. Ended: [end_time]';
  179. /* Field: Tripal Jobs: Priority */
  180. $handler->display->display_options['fields']['priority']['id'] = 'priority';
  181. $handler->display->display_options['fields']['priority']['table'] = 'tripal_jobs';
  182. $handler->display->display_options['fields']['priority']['field'] = 'priority';
  183. $handler->display->display_options['fields']['priority']['element_class'] = 'short-column';
  184. $handler->display->display_options['fields']['priority']['element_label_class'] = 'short-column';
  185. $handler->display->display_options['fields']['priority']['separator'] = '';
  186. /* Field: Tripal Jobs: Progress */
  187. $handler->display->display_options['fields']['progress']['id'] = 'progress';
  188. $handler->display->display_options['fields']['progress']['table'] = 'tripal_jobs';
  189. $handler->display->display_options['fields']['progress']['field'] = 'progress';
  190. $handler->display->display_options['fields']['progress']['element_class'] = 'short-column';
  191. $handler->display->display_options['fields']['progress']['element_label_class'] = 'short-column';
  192. $handler->display->display_options['fields']['progress']['separator'] = '';
  193. $handler->display->display_options['fields']['progress']['suffix'] = '%';
  194. /* Field: Tripal Jobs: Status */
  195. $handler->display->display_options['fields']['status']['id'] = 'status';
  196. $handler->display->display_options['fields']['status']['table'] = 'tripal_jobs';
  197. $handler->display->display_options['fields']['status']['field'] = 'status';
  198. $handler->display->display_options['fields']['status']['element_class'] = 'short-column';
  199. $handler->display->display_options['fields']['status']['element_label_class'] = 'short-column';
  200. /* Field: Global: Custom text */
  201. $handler->display->display_options['fields']['nothing_2']['id'] = 'nothing_2';
  202. $handler->display->display_options['fields']['nothing_2']['table'] = 'views';
  203. $handler->display->display_options['fields']['nothing_2']['field'] = 'nothing';
  204. $handler->display->display_options['fields']['nothing_2']['label'] = 'Re-run Link';
  205. $handler->display->display_options['fields']['nothing_2']['exclude'] = TRUE;
  206. $handler->display->display_options['fields']['nothing_2']['alter']['text'] = 'Re-run';
  207. $handler->display->display_options['fields']['nothing_2']['alter']['make_link'] = TRUE;
  208. $handler->display->display_options['fields']['nothing_2']['alter']['path'] = 'admin/tripal/tripal_jobs/rerun/[job_id]';
  209. /* Field: Global: Custom text */
  210. $handler->display->display_options['fields']['nothing_3']['id'] = 'nothing_3';
  211. $handler->display->display_options['fields']['nothing_3']['table'] = 'views';
  212. $handler->display->display_options['fields']['nothing_3']['field'] = 'nothing';
  213. $handler->display->display_options['fields']['nothing_3']['label'] = 'Cancel link';
  214. $handler->display->display_options['fields']['nothing_3']['exclude'] = TRUE;
  215. $handler->display->display_options['fields']['nothing_3']['alter']['text'] = 'Cancel';
  216. $handler->display->display_options['fields']['nothing_3']['alter']['make_link'] = TRUE;
  217. $handler->display->display_options['fields']['nothing_3']['alter']['path'] = 'admin/tripal/tripal_jobs/cancel/[job_id]';
  218. /* Field: Global: Custom text */
  219. $handler->display->display_options['fields']['nothing_1']['id'] = 'nothing_1';
  220. $handler->display->display_options['fields']['nothing_1']['table'] = 'views';
  221. $handler->display->display_options['fields']['nothing_1']['field'] = 'nothing';
  222. $handler->display->display_options['fields']['nothing_1']['label'] = 'Action';
  223. $handler->display->display_options['fields']['nothing_1']['alter']['text'] = '[nothing_2]<br />
  224. [nothing_3]';
  225. $handler->display->display_options['fields']['nothing_1']['element_class'] = 'short-column';
  226. $handler->display->display_options['fields']['nothing_1']['element_label_class'] = 'short-column';
  227. /* Filter criterion: Tripal Jobs: Job Name */
  228. $handler->display->display_options['filters']['job_name']['id'] = 'job_name';
  229. $handler->display->display_options['filters']['job_name']['table'] = 'tripal_jobs';
  230. $handler->display->display_options['filters']['job_name']['field'] = 'job_name';
  231. $handler->display->display_options['filters']['job_name']['operator'] = 'contains';
  232. $handler->display->display_options['filters']['job_name']['exposed'] = TRUE;
  233. $handler->display->display_options['filters']['job_name']['expose']['operator_id'] = 'job_name_op';
  234. $handler->display->display_options['filters']['job_name']['expose']['label'] = 'Job Name Contains';
  235. $handler->display->display_options['filters']['job_name']['expose']['operator'] = 'job_name_op';
  236. $handler->display->display_options['filters']['job_name']['expose']['identifier'] = 'job_name';
  237. $handler->display->display_options['filters']['job_name']['expose']['remember_roles'] = array(
  238. 2 => '2',
  239. 1 => 0,
  240. 3 => 0,
  241. );
  242. /* Filter criterion: Tripal Jobs: Module Name */
  243. $handler->display->display_options['filters']['modulename']['id'] = 'modulename';
  244. $handler->display->display_options['filters']['modulename']['table'] = 'tripal_jobs';
  245. $handler->display->display_options['filters']['modulename']['field'] = 'modulename';
  246. $handler->display->display_options['filters']['modulename']['exposed'] = TRUE;
  247. $handler->display->display_options['filters']['modulename']['expose']['operator_id'] = 'modulename_op';
  248. $handler->display->display_options['filters']['modulename']['expose']['label'] = 'Submitting Module';
  249. $handler->display->display_options['filters']['modulename']['expose']['operator'] = 'modulename_op';
  250. $handler->display->display_options['filters']['modulename']['expose']['identifier'] = 'modulename';
  251. $handler->display->display_options['filters']['modulename']['expose']['remember_roles'] = array(
  252. 2 => '2',
  253. 1 => 0,
  254. 3 => 0,
  255. );
  256. /* Filter criterion: Tripal Jobs: Status */
  257. $handler->display->display_options['filters']['status']['id'] = 'status';
  258. $handler->display->display_options['filters']['status']['table'] = 'tripal_jobs';
  259. $handler->display->display_options['filters']['status']['field'] = 'status';
  260. $handler->display->display_options['filters']['status']['exposed'] = TRUE;
  261. $handler->display->display_options['filters']['status']['expose']['operator_id'] = 'status_op';
  262. $handler->display->display_options['filters']['status']['expose']['label'] = 'Job Status';
  263. $handler->display->display_options['filters']['status']['expose']['operator'] = 'status_op';
  264. $handler->display->display_options['filters']['status']['expose']['identifier'] = 'status';
  265. $handler->display->display_options['filters']['status']['expose']['remember_roles'] = array(
  266. 2 => '2',
  267. 1 => 0,
  268. 3 => 0,
  269. );
  270. /* Display: Page */
  271. $handler = $view->new_display('page', 'Page', 'page');
  272. $handler->display->display_options['path'] = 'admin/tripal/tripal_jobs/jobs';
  273. $handler->display->display_options['menu']['type'] = 'default tab';
  274. $handler->display->display_options['menu']['title'] = 'Jobs';
  275. $handler->display->display_options['menu']['description'] = 'Jobs managed by Tripal';
  276. $handler->display->display_options['menu']['weight'] = '-10';
  277. $handler->display->display_options['menu']['context'] = 0;
  278. $handler->display->display_options['menu']['context_only_inline'] = 0;
  279. $handler->display->display_options['tab_options']['weight'] = '0';
  280. return $view;
  281. }
  282. function tripal_core_admin_defaultview_custom_tables() {
  283. $view = new view();
  284. $view->name = 'tripal_core_admin_custom_table';
  285. $view->description = 'DO NOT DISABLE';
  286. $view->tag = 'tripal admin';
  287. $view->base_table = 'tripal_custom_tables';
  288. $view->human_name = 'Tripal Custom Table Admin';
  289. $view->core = 7;
  290. $view->api_version = '3.0';
  291. $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
  292. /* Display: Master */
  293. $handler = $view->new_display('default', 'Master', 'default');
  294. $handler->display->display_options['title'] = 'Custom Tables';
  295. $handler->display->display_options['use_more_always'] = FALSE;
  296. $handler->display->display_options['access']['type'] = 'none';
  297. $handler->display->display_options['cache']['type'] = 'none';
  298. $handler->display->display_options['query']['type'] = 'views_query';
  299. $handler->display->display_options['exposed_form']['type'] = 'basic';
  300. $handler->display->display_options['exposed_form']['options']['submit_button'] = 'Filter';
  301. $handler->display->display_options['pager']['type'] = 'full';
  302. $handler->display->display_options['pager']['options']['items_per_page'] = '25';
  303. $handler->display->display_options['style_plugin'] = 'table';
  304. /* Header: Global: Action Links */
  305. $handler->display->display_options['header']['action_links_area']['id'] = 'action_links_area';
  306. $handler->display->display_options['header']['action_links_area']['table'] = 'views';
  307. $handler->display->display_options['header']['action_links_area']['field'] = 'action_links_area';
  308. $handler->display->display_options['header']['action_links_area']['label'] = 'Action Links';
  309. $handler->display->display_options['header']['action_links_area']['empty'] = TRUE;
  310. $handler->display->display_options['header']['action_links_area']['link-1'] = array(
  311. 'label-1' => 'Add Custom Table',
  312. 'path-1' => 'admin/tripal/schema/custom_tables/new',
  313. );
  314. $handler->display->display_options['header']['action_links_area']['link-2'] = array(
  315. 'label-2' => '',
  316. 'path-2' => '',
  317. );
  318. $handler->display->display_options['header']['action_links_area']['link-3'] = array(
  319. 'label-3' => '',
  320. 'path-3' => '',
  321. );
  322. $handler->display->display_options['header']['action_links_area']['link-4'] = array(
  323. 'label-4' => '',
  324. 'path-4' => '',
  325. );
  326. /* Field: Tripal Custom Tables: Custom Table ID */
  327. $handler->display->display_options['fields']['table_id']['id'] = 'table_id';
  328. $handler->display->display_options['fields']['table_id']['table'] = 'tripal_custom_tables';
  329. $handler->display->display_options['fields']['table_id']['field'] = 'table_id';
  330. $handler->display->display_options['fields']['table_id']['label'] = '';
  331. $handler->display->display_options['fields']['table_id']['element_class'] = 'extra-short-column';
  332. $handler->display->display_options['fields']['table_id']['element_label_class'] = 'extra-short-column';
  333. $handler->display->display_options['fields']['table_id']['element_label_colon'] = FALSE;
  334. $handler->display->display_options['fields']['table_id']['separator'] = '';
  335. /* Field: Tripal Custom Tables: Table Name */
  336. $handler->display->display_options['fields']['table_name']['id'] = 'table_name';
  337. $handler->display->display_options['fields']['table_name']['table'] = 'tripal_custom_tables';
  338. $handler->display->display_options['fields']['table_name']['field'] = 'table_name';
  339. $handler->display->display_options['fields']['table_name']['label'] = 'Name';
  340. $handler->display->display_options['fields']['table_name']['alter']['make_link'] = TRUE;
  341. $handler->display->display_options['fields']['table_name']['alter']['path'] = 'admin/tripal/schema/custom_tables/view/[table_id]';
  342. /* Field: Global: Custom text */
  343. $handler->display->display_options['fields']['nothing']['id'] = 'nothing';
  344. $handler->display->display_options['fields']['nothing']['table'] = 'views';
  345. $handler->display->display_options['fields']['nothing']['field'] = 'nothing';
  346. $handler->display->display_options['fields']['nothing']['label'] = 'Edit Link';
  347. $handler->display->display_options['fields']['nothing']['exclude'] = TRUE;
  348. $handler->display->display_options['fields']['nothing']['alter']['text'] = 'Edit';
  349. $handler->display->display_options['fields']['nothing']['alter']['make_link'] = TRUE;
  350. $handler->display->display_options['fields']['nothing']['alter']['path'] = 'admin/tripal/schema/custom_tables/edit/[table_id]';
  351. /* Field: Global: Custom text */
  352. $handler->display->display_options['fields']['nothing_1']['id'] = 'nothing_1';
  353. $handler->display->display_options['fields']['nothing_1']['table'] = 'views';
  354. $handler->display->display_options['fields']['nothing_1']['field'] = 'nothing';
  355. $handler->display->display_options['fields']['nothing_1']['label'] = 'Delete Link';
  356. $handler->display->display_options['fields']['nothing_1']['exclude'] = TRUE;
  357. $handler->display->display_options['fields']['nothing_1']['alter']['text'] = 'Delete';
  358. $handler->display->display_options['fields']['nothing_1']['alter']['make_link'] = TRUE;
  359. $handler->display->display_options['fields']['nothing_1']['alter']['path'] = 'admin/tripal/schema/custom_tables/action/delete/[table_id]';
  360. /* Field: Global: Custom text */
  361. $handler->display->display_options['fields']['nothing_2']['id'] = 'nothing_2';
  362. $handler->display->display_options['fields']['nothing_2']['table'] = 'views';
  363. $handler->display->display_options['fields']['nothing_2']['field'] = 'nothing';
  364. $handler->display->display_options['fields']['nothing_2']['label'] = '';
  365. $handler->display->display_options['fields']['nothing_2']['alter']['text'] = '[nothing] [nothing_1]';
  366. $handler->display->display_options['fields']['nothing_2']['element_label_colon'] = FALSE;
  367. /* Filter criterion: Tripal Custom Tables: Table Name */
  368. $handler->display->display_options['filters']['table_name']['id'] = 'table_name';
  369. $handler->display->display_options['filters']['table_name']['table'] = 'tripal_custom_tables';
  370. $handler->display->display_options['filters']['table_name']['field'] = 'table_name';
  371. $handler->display->display_options['filters']['table_name']['exposed'] = TRUE;
  372. $handler->display->display_options['filters']['table_name']['expose']['operator_id'] = 'table_name_op';
  373. $handler->display->display_options['filters']['table_name']['expose']['label'] = 'Table Name';
  374. $handler->display->display_options['filters']['table_name']['expose']['operator'] = 'table_name_op';
  375. $handler->display->display_options['filters']['table_name']['expose']['identifier'] = 'table_name';
  376. $handler->display->display_options['filters']['table_name']['expose']['remember_roles'] = array(
  377. 2 => '2',
  378. 1 => 0,
  379. 3 => 0,
  380. );
  381. /* Display: Page */
  382. $handler = $view->new_display('page', 'Page', 'page');
  383. $handler->display->display_options['path'] = 'admin/tripal/schema/custom_tables/tables';
  384. $handler->display->display_options['menu']['type'] = 'default tab';
  385. $handler->display->display_options['menu']['title'] = 'Custom Tables';
  386. $handler->display->display_options['menu']['description'] = 'A list of existing custom tables';
  387. $handler->display->display_options['menu']['weight'] = '-10';
  388. $handler->display->display_options['menu']['name'] = 'management';
  389. $handler->display->display_options['menu']['context'] = 0;
  390. $handler->display->display_options['menu']['context_only_inline'] = 0;
  391. $handler->display->display_options['tab_options']['weight'] = '0';
  392. return $view;
  393. }
  394. function tripal_core_admin_defaultview_mviews() {
  395. $view = new view();
  396. $view->name = 'tripal_core_admin_mviews';
  397. $view->description = 'DO NOT DISABLE';
  398. $view->tag = 'tripal admin';
  399. $view->base_table = 'tripal_mviews';
  400. $view->human_name = 'MView Admin';
  401. $view->core = 7;
  402. $view->api_version = '3.0';
  403. $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
  404. /* Display: Master */
  405. $handler = $view->new_display('default', 'Master', 'default');
  406. $handler->display->display_options['title'] = 'Materialized Views';
  407. $handler->display->display_options['use_more_always'] = FALSE;
  408. $handler->display->display_options['access']['type'] = 'none';
  409. $handler->display->display_options['cache']['type'] = 'none';
  410. $handler->display->display_options['query']['type'] = 'views_query';
  411. $handler->display->display_options['exposed_form']['type'] = 'basic';
  412. $handler->display->display_options['exposed_form']['options']['submit_button'] = 'Filter';
  413. $handler->display->display_options['pager']['type'] = 'full';
  414. $handler->display->display_options['pager']['options']['items_per_page'] = '25';
  415. $handler->display->display_options['style_plugin'] = 'table';
  416. $handler->display->display_options['style_options']['columns'] = array(
  417. 'mview_id' => 'mview_id',
  418. 'name' => 'name',
  419. 'mv_table' => 'mv_table',
  420. 'comment' => 'comment',
  421. 'last_update' => 'last_update',
  422. 'status' => 'status',
  423. );
  424. $handler->display->display_options['style_options']['default'] = 'mview_id';
  425. $handler->display->display_options['style_options']['info'] = array(
  426. 'mview_id' => array(
  427. 'sortable' => 1,
  428. 'default_sort_order' => 'asc',
  429. 'align' => '',
  430. 'separator' => '',
  431. 'empty_column' => 0,
  432. ),
  433. 'name' => array(
  434. 'sortable' => 1,
  435. 'default_sort_order' => 'asc',
  436. 'align' => '',
  437. 'separator' => '',
  438. 'empty_column' => 0,
  439. ),
  440. 'mv_table' => array(
  441. 'sortable' => 1,
  442. 'default_sort_order' => 'asc',
  443. 'align' => '',
  444. 'separator' => '',
  445. 'empty_column' => 0,
  446. ),
  447. 'comment' => array(
  448. 'sortable' => 0,
  449. 'default_sort_order' => 'asc',
  450. 'align' => '',
  451. 'separator' => '',
  452. 'empty_column' => 0,
  453. ),
  454. 'last_update' => array(
  455. 'sortable' => 1,
  456. 'default_sort_order' => 'asc',
  457. 'align' => '',
  458. 'separator' => '',
  459. 'empty_column' => 0,
  460. ),
  461. 'status' => array(
  462. 'sortable' => 1,
  463. 'default_sort_order' => 'asc',
  464. 'align' => '',
  465. 'separator' => '',
  466. 'empty_column' => 0,
  467. ),
  468. );
  469. /* Header: Global: Text area */
  470. $handler->display->display_options['header']['area']['id'] = 'area';
  471. $handler->display->display_options['header']['area']['table'] = 'views';
  472. $handler->display->display_options['header']['area']['field'] = 'area';
  473. $handler->display->display_options['header']['area']['label'] = 'Description';
  474. $handler->display->display_options['header']['area']['empty'] = TRUE;
  475. $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>
  476. <p>MViews behaves in the following way:</p>
  477. <ul>
  478. <li>The SQL statement defined for an MVIEW will be used to populate the table</li>
  479. <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>
  480. <li>Altering the query of an existing view will not change the MView table. No records will be lost.</li>
  481. <li>Repopulating an MView that is already populated will result in replacement of all records.</li>
  482. <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>
  483. </ul>';
  484. $handler->display->display_options['header']['area']['format'] = 'full_html';
  485. /* Header: Global: Action Links */
  486. $handler->display->display_options['header']['action_links_area']['id'] = 'action_links_area';
  487. $handler->display->display_options['header']['action_links_area']['table'] = 'views';
  488. $handler->display->display_options['header']['action_links_area']['field'] = 'action_links_area';
  489. $handler->display->display_options['header']['action_links_area']['label'] = 'Action Links';
  490. $handler->display->display_options['header']['action_links_area']['link-1'] = array(
  491. 'label-1' => 'Add Materialized View',
  492. 'path-1' => 'admin/tripal/schema/mviews/new',
  493. );
  494. $handler->display->display_options['header']['action_links_area']['link-2'] = array(
  495. 'label-2' => '',
  496. 'path-2' => '',
  497. );
  498. $handler->display->display_options['header']['action_links_area']['link-3'] = array(
  499. 'label-3' => '',
  500. 'path-3' => '',
  501. );
  502. $handler->display->display_options['header']['action_links_area']['link-4'] = array(
  503. 'label-4' => '',
  504. 'path-4' => '',
  505. );
  506. /* Field: Tripal Materialized Views: Materialized View ID */
  507. $handler->display->display_options['fields']['mview_id']['id'] = 'mview_id';
  508. $handler->display->display_options['fields']['mview_id']['table'] = 'tripal_mviews';
  509. $handler->display->display_options['fields']['mview_id']['field'] = 'mview_id';
  510. $handler->display->display_options['fields']['mview_id']['label'] = '';
  511. $handler->display->display_options['fields']['mview_id']['element_class'] = 'extra-short-column';
  512. $handler->display->display_options['fields']['mview_id']['element_label_class'] = 'extra-short-column';
  513. $handler->display->display_options['fields']['mview_id']['element_label_colon'] = FALSE;
  514. $handler->display->display_options['fields']['mview_id']['separator'] = '';
  515. /* Field: Tripal Materialized Views: Name */
  516. $handler->display->display_options['fields']['name']['id'] = 'name';
  517. $handler->display->display_options['fields']['name']['table'] = 'tripal_mviews';
  518. $handler->display->display_options['fields']['name']['field'] = 'name';
  519. $handler->display->display_options['fields']['name']['alter']['make_link'] = TRUE;
  520. $handler->display->display_options['fields']['name']['alter']['path'] = 'admin/tripal/schema/mviews/report/[mview_id]';
  521. /* Field: Tripal Materialized Views: Table */
  522. $handler->display->display_options['fields']['mv_table']['id'] = 'mv_table';
  523. $handler->display->display_options['fields']['mv_table']['table'] = 'tripal_mviews';
  524. $handler->display->display_options['fields']['mv_table']['field'] = 'mv_table';
  525. $handler->display->display_options['fields']['mv_table']['label'] = 'Table Name';
  526. /* Field: Tripal Materialized Views: Description */
  527. $handler->display->display_options['fields']['comment']['id'] = 'comment';
  528. $handler->display->display_options['fields']['comment']['table'] = 'tripal_mviews';
  529. $handler->display->display_options['fields']['comment']['field'] = 'comment';
  530. /* Field: Tripal Materialized Views: Updated */
  531. $handler->display->display_options['fields']['last_update']['id'] = 'last_update';
  532. $handler->display->display_options['fields']['last_update']['table'] = 'tripal_mviews';
  533. $handler->display->display_options['fields']['last_update']['field'] = 'last_update';
  534. $handler->display->display_options['fields']['last_update']['label'] = 'Last Updated';
  535. $handler->display->display_options['fields']['last_update']['date_format'] = 'long';
  536. /* Field: Tripal Materialized Views: Status */
  537. $handler->display->display_options['fields']['status']['id'] = 'status';
  538. $handler->display->display_options['fields']['status']['table'] = 'tripal_mviews';
  539. $handler->display->display_options['fields']['status']['field'] = 'status';
  540. $handler->display->display_options['fields']['status']['empty'] = 'Not yet populated';
  541. /* Field: Global: Custom text */
  542. $handler->display->display_options['fields']['nothing']['id'] = 'nothing';
  543. $handler->display->display_options['fields']['nothing']['table'] = 'views';
  544. $handler->display->display_options['fields']['nothing']['field'] = 'nothing';
  545. $handler->display->display_options['fields']['nothing']['label'] = 'Edit Link';
  546. $handler->display->display_options['fields']['nothing']['exclude'] = TRUE;
  547. $handler->display->display_options['fields']['nothing']['alter']['text'] = 'Edit';
  548. $handler->display->display_options['fields']['nothing']['alter']['make_link'] = TRUE;
  549. $handler->display->display_options['fields']['nothing']['alter']['path'] = 'admin/tripal/schema/mviews/edit/[mview_id]';
  550. /* Field: Global: Custom text */
  551. $handler->display->display_options['fields']['nothing_1']['id'] = 'nothing_1';
  552. $handler->display->display_options['fields']['nothing_1']['table'] = 'views';
  553. $handler->display->display_options['fields']['nothing_1']['field'] = 'nothing';
  554. $handler->display->display_options['fields']['nothing_1']['label'] = 'Delete Link';
  555. $handler->display->display_options['fields']['nothing_1']['exclude'] = TRUE;
  556. $handler->display->display_options['fields']['nothing_1']['alter']['text'] = 'Delete';
  557. $handler->display->display_options['fields']['nothing_1']['alter']['make_link'] = TRUE;
  558. $handler->display->display_options['fields']['nothing_1']['alter']['path'] = 'admin/tripal/schema/mviews/action/delete/[mview_id]';
  559. /* Field: Global: Custom text */
  560. $handler->display->display_options['fields']['nothing_2']['id'] = 'nothing_2';
  561. $handler->display->display_options['fields']['nothing_2']['table'] = 'views';
  562. $handler->display->display_options['fields']['nothing_2']['field'] = 'nothing';
  563. $handler->display->display_options['fields']['nothing_2']['label'] = 'Populate Link';
  564. $handler->display->display_options['fields']['nothing_2']['exclude'] = TRUE;
  565. $handler->display->display_options['fields']['nothing_2']['alter']['text'] = 'Populate';
  566. $handler->display->display_options['fields']['nothing_2']['alter']['make_link'] = TRUE;
  567. $handler->display->display_options['fields']['nothing_2']['alter']['path'] = 'admin/tripal/schema/mviews/action/update/[mview_id]';
  568. /* Field: Global: Custom text */
  569. $handler->display->display_options['fields']['nothing_3']['id'] = 'nothing_3';
  570. $handler->display->display_options['fields']['nothing_3']['table'] = 'views';
  571. $handler->display->display_options['fields']['nothing_3']['field'] = 'nothing';
  572. $handler->display->display_options['fields']['nothing_3']['label'] = '';
  573. $handler->display->display_options['fields']['nothing_3']['alter']['text'] = '[nothing] [nothing_1]<br />
  574. [nothing_2]';
  575. $handler->display->display_options['fields']['nothing_3']['element_class'] = 'short-column';
  576. $handler->display->display_options['fields']['nothing_3']['element_label_class'] = 'short-column';
  577. $handler->display->display_options['fields']['nothing_3']['element_label_colon'] = FALSE;
  578. /* Filter criterion: Tripal Materialized Views: Name */
  579. $handler->display->display_options['filters']['name']['id'] = 'name';
  580. $handler->display->display_options['filters']['name']['table'] = 'tripal_mviews';
  581. $handler->display->display_options['filters']['name']['field'] = 'name';
  582. $handler->display->display_options['filters']['name']['group'] = 1;
  583. $handler->display->display_options['filters']['name']['exposed'] = TRUE;
  584. $handler->display->display_options['filters']['name']['expose']['operator_id'] = 'name_op';
  585. $handler->display->display_options['filters']['name']['expose']['label'] = 'Name';
  586. $handler->display->display_options['filters']['name']['expose']['operator'] = 'name_op';
  587. $handler->display->display_options['filters']['name']['expose']['identifier'] = 'name';
  588. $handler->display->display_options['filters']['name']['expose']['remember_roles'] = array(
  589. 2 => '2',
  590. 1 => 0,
  591. 3 => 0,
  592. );
  593. /* Filter criterion: Tripal Materialized Views: Table */
  594. $handler->display->display_options['filters']['mv_table']['id'] = 'mv_table';
  595. $handler->display->display_options['filters']['mv_table']['table'] = 'tripal_mviews';
  596. $handler->display->display_options['filters']['mv_table']['field'] = 'mv_table';
  597. $handler->display->display_options['filters']['mv_table']['group'] = 1;
  598. $handler->display->display_options['filters']['mv_table']['exposed'] = TRUE;
  599. $handler->display->display_options['filters']['mv_table']['expose']['operator_id'] = 'mv_table_op';
  600. $handler->display->display_options['filters']['mv_table']['expose']['label'] = 'Database Table';
  601. $handler->display->display_options['filters']['mv_table']['expose']['operator'] = 'mv_table_op';
  602. $handler->display->display_options['filters']['mv_table']['expose']['identifier'] = 'mv_table';
  603. $handler->display->display_options['filters']['mv_table']['expose']['remember_roles'] = array(
  604. 2 => '2',
  605. 1 => 0,
  606. 3 => 0,
  607. );
  608. /* Filter criterion: Tripal Materialized Views: Module Name */
  609. $handler->display->display_options['filters']['modulename']['id'] = 'modulename';
  610. $handler->display->display_options['filters']['modulename']['table'] = 'tripal_mviews';
  611. $handler->display->display_options['filters']['modulename']['field'] = 'modulename';
  612. $handler->display->display_options['filters']['modulename']['group'] = 1;
  613. $handler->display->display_options['filters']['modulename']['exposed'] = TRUE;
  614. $handler->display->display_options['filters']['modulename']['expose']['operator_id'] = 'modulename_op';
  615. $handler->display->display_options['filters']['modulename']['expose']['label'] = 'Module Created by';
  616. $handler->display->display_options['filters']['modulename']['expose']['operator'] = 'modulename_op';
  617. $handler->display->display_options['filters']['modulename']['expose']['identifier'] = 'modulename';
  618. $handler->display->display_options['filters']['modulename']['expose']['remember_roles'] = array(
  619. 2 => '2',
  620. 1 => 0,
  621. 3 => 0,
  622. );
  623. /* Filter criterion: Tripal Materialized Views: Status */
  624. $handler->display->display_options['filters']['status']['id'] = 'status';
  625. $handler->display->display_options['filters']['status']['table'] = 'tripal_mviews';
  626. $handler->display->display_options['filters']['status']['field'] = 'status';
  627. $handler->display->display_options['filters']['status']['group'] = 1;
  628. $handler->display->display_options['filters']['status']['exposed'] = TRUE;
  629. $handler->display->display_options['filters']['status']['expose']['operator_id'] = 'status_op';
  630. $handler->display->display_options['filters']['status']['expose']['label'] = 'Status';
  631. $handler->display->display_options['filters']['status']['expose']['operator'] = 'status_op';
  632. $handler->display->display_options['filters']['status']['expose']['identifier'] = 'status';
  633. $handler->display->display_options['filters']['status']['expose']['remember_roles'] = array(
  634. 2 => '2',
  635. 1 => 0,
  636. 3 => 0,
  637. );
  638. /* Display: Page */
  639. $handler = $view->new_display('page', 'Page', 'page');
  640. $handler->display->display_options['path'] = 'admin/tripal/schema/mviews/mviews';
  641. $handler->display->display_options['menu']['type'] = 'default tab';
  642. $handler->display->display_options['menu']['title'] = 'Materialized Views';
  643. $handler->display->display_options['menu']['description'] = 'a list of mviews';
  644. $handler->display->display_options['menu']['weight'] = '-10';
  645. $handler->display->display_options['menu']['name'] = 'management';
  646. $handler->display->display_options['menu']['context'] = 0;
  647. $handler->display->display_options['menu']['context_only_inline'] = 0;
  648. $handler->display->display_options['tab_options']['weight'] = '0';
  649. return $view;
  650. }