tripal_pub_stocks.tpl.php 3.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104
  1. <?php
  2. $pub = $variables['node']->pub;
  3. $stocks = [];
  4. // get the stocks that are associated with this publication. But we only
  5. // want 25 and we want a pager to let the user cycle between pages of stocks.
  6. // so we, use the chado_select_record API function to get the results and
  7. // generate the pager. The function is smart enough to know which page the user is
  8. // on and retrieves the proper set of stocks
  9. $element = 5; // an index to specify the pager this must be unique amongst all pub templates
  10. $num_per_page = 25; // the number of stocks to show per page$num_results_per_page = 25;
  11. // get the stocks from the stock_pub table
  12. $options = [
  13. 'return_array' => 1,
  14. 'pager' => [
  15. 'limit' => $num_per_page,
  16. 'element' => $element,
  17. ],
  18. ];
  19. $pub = chado_expand_var($pub, 'table', 'stock_pub', $options);
  20. $stock_pubs = $pub->stock_pub;
  21. if (count($stock_pubs) > 0) {
  22. foreach ($stock_pubs as $stock_pub) {
  23. $stocks[] = $stock_pub->stock_id;
  24. }
  25. }
  26. // get the total number of records
  27. $total_records = chado_pager_get_count($element);
  28. if (count($stocks) > 0) { ?>
  29. <div class="tripal_pub-data-block-desc tripal-data-block-desc">This
  30. publication contains information
  31. about <?php print number_format($total_records) ?> stocks:
  32. </div> <?php
  33. // the $headers array is an array of fields to use as the colum headers.
  34. // additional documentation can be found here
  35. // https://api.drupal.org/api/drupal/includes%21theme.inc/function/theme_table/7
  36. $headers = ['Stock Name', 'Uniquenaem', 'Type'];
  37. // the $rows array contains an array of rows where each row is an array
  38. // of values for each column of the table in that row. Additional documentation
  39. // can be found here:
  40. // https://api.drupal.org/api/drupal/includes%21theme.inc/function/theme_table/7
  41. $rows = [];
  42. foreach ($stocks as $stock) {
  43. $stock_name = $stock->name;
  44. if (property_exists($stock, 'nid')) {
  45. $stock_name = l($stock_name, 'node/' . $stock->nid, ['attributes' => ['target' => '_blank']]);
  46. }
  47. $rows[] = [
  48. $stock_name,
  49. $stock->uniquename,
  50. $stock->type_id->name,
  51. ];
  52. }
  53. // the $table array contains the headers and rows array as well as other
  54. // options for controlling the display of the table. Additional
  55. // documentation can be found here:
  56. // https://api.drupal.org/api/drupal/includes%21theme.inc/function/theme_table/7
  57. $table = [
  58. 'header' => $headers,
  59. 'rows' => $rows,
  60. 'attributes' => [
  61. 'id' => 'tripal_pub-table-stocks',
  62. 'class' => 'tripal-data-table',
  63. ],
  64. 'sticky' => FALSE,
  65. 'caption' => '',
  66. 'colgroups' => [],
  67. 'empty' => '',
  68. ];
  69. // once we have our table array structure defined, we call Drupal's theme_table()
  70. // function to generate the table.
  71. print theme_table($table);
  72. // the $pager array values that control the behavior of the pager. For
  73. // documentation on the values allows in this array see:
  74. // https://api.drupal.org/api/drupal/includes!pager.inc/function/theme_pager/7
  75. // here we add the paramter 'block' => 'stocks'. This is because
  76. // the pager is not on the default block that appears. When the user clicks a
  77. // page number we want the browser to re-appear with the page is loaded.
  78. // We remove the 'pane' parameter from the original query parameters because
  79. // Drupal won't reset the parameter if it already exists.
  80. $get = $_GET;
  81. unset($_GET['pane']);
  82. $pager = [
  83. 'tags' => [],
  84. 'element' => $element,
  85. 'parameters' => [
  86. 'pane' => 'stocks',
  87. ],
  88. 'quantity' => $num_per_page,
  89. ];
  90. print theme_pager($pager);
  91. $_GET = $get;
  92. }