tripal_views_setup.admin.inc 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102
  1. <?php
  2. // function tripal_views_setup_admin(){
  3. // $add_url = url('admin/tripal/tripal_views_setup/new');
  4. // $output = "<div id='add-new-search'><a href=\"$add_url\">Add New Search</a><div>";
  5. // $output .= drupal_get_form('tripal_views_setup_admin_form');
  6. //
  7. // return $rows;
  8. // }
  9. function tripal_views_setup_admin_form(){
  10. $query_resulst = db_query('SELECT * FROM public.tripal_views_setup;');
  11. $form = array();
  12. $int_i = 0;
  13. $records = array();
  14. while($record = db_fetch_object($query_resulst)){
  15. $records[] = $record;
  16. }
  17. dpm($records, 'records');
  18. $record_fields = array('setup_id', 'mview_id', 'base_table_name', 'name', 'description');
  19. $form = tripal_helper_form_createformdata($form, $records, $record_fields);
  20. $form['submit'] = array(
  21. '#type' => 'submit',
  22. '#value' => t('Remove'),
  23. );
  24. $form['cancel'] = array(
  25. '#type' => 'markup',
  26. '#value' => l(t('Cancel'), 'admin/tripal/'),
  27. );
  28. dpm($form, 'admin_form');
  29. return $form;
  30. //return system_settings_form($form);
  31. }
  32. function tripal_views_setup_admin_form_submit($form_id, $form){
  33. $form_values = $form['values'];
  34. dpm($form, 'submitted form');
  35. dpm($form_values, 'submitted form values');
  36. $featured = $form_values['row_checkboxes'];
  37. $selected_checkbox = array();
  38. foreach($featured as $key => $value){
  39. if($value){
  40. $selected_checkbox[] = "'$value'";
  41. }
  42. }
  43. dpm($selected_checkbox, 'selected');
  44. foreach ($selected_checkbox as $key => $value) {
  45. dpm((string)$value, 'delete value');
  46. dpm("DELETE FROM public.tripal_views_setup WHERE setup_id = $value;", 'delete stuff');
  47. db_query("DELETE FROM public.tripal_views_setup WHERE setup_id = $value;");
  48. }
  49. }
  50. function tripal_views_setup_new_search_form(){
  51. $form = array();
  52. return $form;
  53. }
  54. function tripal_views_setup_mview_list(){
  55. //must return an array of strings ie:
  56. $options = array(
  57. 'dummyoption' => t('dummyoptiontext'),
  58. );
  59. return $options;
  60. }
  61. function tripal_views_setup_btable_list(){
  62. //must return an array of strings ie:
  63. $options = array(
  64. 'dummyoption2' => t('dummyoptiontext2'),
  65. );
  66. return $options;
  67. }