setup_id, $result->name, $result->mview_id, $result->base_table_name, $result->description,); $results[] = $result; } $options = array(); foreach ($results as $key => $value) { if(!empty($value)) $options[] = $value->setup_id;// . ' | ' . $value->name . ' | ' . $value->mview_id . ' | ' . $value->base_table_name; } $form['existing_rows'] = array( '#type' => 'select', '#options' => $options, '#description' => 'Select a View Setup to delete from the database.', '#prefix' => theme('table', $header, $rows), ); $form['submit'] = array( '#type' => 'submit', '#value' => t('Remove'), ); $form['cancel'] = array( '#type' => 'markup', '#value' => l(t('Cancel '), 'admin/tripal/'), ); $form['new'] = array( '#type' => 'markup', '#value' => l(t(' New'), 'admin/tripal/tripal_views_setup_new'), ); return $form; } function tripal_views_setup_admin_form_submit($form, &$form_state){ $value = $form['existing_rows']['#options'][$form_state['values']['existing_rows']]; db_query("DELETE FROM public.tripal_views_setup WHERE setup_id = $value;"); db_query("DELETE FROM public.tripal_views_handlers WHERE setup_id = $value;"); db_query("DELETE FROM public.tripal_mviews_join WHERE setup_id = $value;"); } function tripal_views_setup_new_search_form($form_state){ $form = array(); $form['#cache'] = TRUE; $form['row_name'] = array( '#title' => t('Name'), '#type' => 'textfield', '#size' => 60, '#maxlength' => 128, '#description' => 'Name of the Views Setup', '#required' => TRUE, ); $form['row_description'] = array( '#title' => t('Description'), '#type' => 'textfield', '#size' => 60, '#maxlength' => 255, '#description' => 'Briefly describe in which view this will be used', '#required' => TRUE, ); $mview_query = db_query("SELECT name FROM {tripal_mviews} ORDER BY name;"); $mview_options = array(); while ($mview_option = db_fetch_array($mview_query)){ $mview_options[] = $mview_option['name']; } $form['row_mview'] = array( '#title' => t('Materialized View'), '#type' => 'select', '#options' => $mview_options, '#description' => 'Which materialized view to use.', '#required' => TRUE, // '#ahah' => array( // 'path' => 'rowmview/ahah', // 'wrapper' => 'rowmview-ahah', // 'effect' => 'fade', // 'event' => 'change', // 'method' => 'replace', // ), ); $form['row_base_table_name'] = array( '#title' => t('Base Table Name'), '#type' => 'select', // '#options' => array('stub'), '#options' => tripal_core_get_chado_tables(), '#description' => 'Select which chado table to use for this view.', '#required' => TRUE, ); //--tripal_mviews_join $form['row_view_column'] = array( '#title' => t('View Column'), '#type' => 'select', '#options' => array('stub'), '#description' => 'Which materialized view column to use.', '#required' => TRUE, ); $form['row_chado_column'] = array( '#title' => t('Chado Column'), '#type' => 'select', '#options' => array('stub'), '#description' => 'Which Chado table column to use.', '#required' => TRUE, ); $form['submit'] = array( '#type' => 'submit', '#value' => 'Create', ); return $form; } // function rowmview_ahah(){ // $query = "SELECT mv_specs FROM tripal_mviews;"; // $row_options = db_fetch_array(db_query($query)); // // // } // function tripal_views_setup_ajax_db_mview_columns(){ // $mview = $_POST['row_mview']; // $form = drupal_get_form('tripal_views_setup_mview_column_form', $mview); // drupal_json(array('status' => TRUE, 'data' => $form)); // } // function tripal_views_setup_mview_column_form(&$form_state = NULL, $mview = NULL){ // if ($mview){ // $mview_query = db_fetch_array(db_query("SELECT mv_specs FROM tripal_mviews WHERE name = $mview;")); // // $form['row_mview'] // } // // } // function tripal_views_setup_ajax_db_chado_tables(){ // } function tripal_views_setup_new_search_form_submit($form, &$form_state){ }