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; } /** * * @ingroup tripal_view_setup */ 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;"); } /** * * @ingroup tripal_view_setup */ function tripal_views_setup_new_setup_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 mview_id,name FROM {tripal_mviews} ORDER BY name;"); $mview_options = array(); $mview_options['0'] = 'Select'; while ($mview_option = db_fetch_array($mview_query)){ $mview_options[$mview_option['mview_id']] = $mview_option['name']; } $form['mview_id'] = array( '#title' => t('Materialized View'), '#type' => 'select', '#options' => $mview_options, '#description' => 'Which materialized view to use.', '#required' => TRUE, '#ahah' => array( 'path' => 'admin/tripal/tripal_views_setup/ajax/mview_cols', 'wrapper' => 'table-rows-div', 'effect' => 'fade', 'event' => 'change', 'method' => 'replace', ), ); // ignore this for now... we'll come back to it later -- spf // $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, // ); $form['view_setup_table'] = array( '#type' => 'item', '#prefix' => '
', '#suffix' => '
', ); if($form_state['values']['mview_id']){ $mview_id = $form_state['values']['mview_id']; $form['view_setup_table'] = array( '#type' => 'fieldset', '#title' => 'Table Fields Setup', '#prefix' => '
', '#suffix' => '
', ); // get the columns in this materialized view. They are separated by commas // where the first word is the column name and the rest is the type $sql = "SELECT mv_specs FROM {tripal_mviews} WHERE mview_id = $mview_id"; $mview = db_fetch_object(db_query($sql)); $columns = explode(",",$mview->mv_specs); $i=1; $chado_tables = tripal_core_get_chado_tables(); $chado_tables = array_merge(array('select or leave blank',), $chado_tables); $handlers = array(); $form['view_setup_table']["fields_headers"] = array( '#type' => 'markup', '#value' => "
". "
Field Name and Type
". "
Join Table
". "
Join Column
". "
Handler
", ); foreach ($columns as $column){ $column = trim($column); // trim trailing and leading spaces preg_match("/^(.*?)\ (.*?)$/",$column,$matches); $column_name = $matches[1]; $column_type = $matches[2]; // first print the field name $form['view_setup_table']["fields_start_$mview_id-$i"] = array( '#type' => 'markup', '#value' => "
", ); $form['view_setup_table']["fields_column_name_$mview_id-$i"] = array( '#type' => 'markup', '#attributes' => array('class' => 'fields-column-name'), '#value' => "
$column_name". "
$column_type
", ); // second print the table join drop down $table = $form_state['values']["fields_column_join_$mview_id_$i"]; $form['view_setup_table']["fields_column_join_$mview_id-$i"] = array( '#type' => 'select', '#prefix' => "
", '#suffix' => "
", '#options' => $chado_tables, '#required' => FALSE, '#default_value' => $table, '#ahah' => array( 'path' => 'admin/tripal/tripal_views_setup/ajax/field_col_join', 'wrapper' => "fields-column-join-column-$mview_id-$i", 'effect' => 'fade', // 'event' => 'change', 'method' => 'replace', ), ); if($table){ $table_desc = module_invoke_all('chado_'.$table.'_schema'); $columns = array_keys($table_desc['fields']); } else { $columns = array(); } $form['view_setup_table']["fields_column_join_column_$mview_id-$i"] = array( '#type' => 'select', '#prefix' => "
", '#suffix' => "
", '#options' => $columns, '#required' => FALSE, ); $form['view_setup_table']["fields_column_handler_$mview_id-$i"] = array( '#type' => 'select', '#prefix' => "
", '#suffix' => "
", '#options' => $handlers, '#required' => FALSE, ); $form['view_setup_table']["fields_end_$i"] = array( '#type' => 'markup', '#value' => "
", ); $i++; } $form['view_setup_table']['submit'] = array( '#type' => 'submit', '#value' => 'Create', ); $form['row_counter'] = array( '#type' => 'hidden', '#value' => $i, ); } // end if($form_state['values']['mview_id']) return $form; } /** * * @ingroup tripal_view_setup */ function tripal_view_setup_ajax_mview_cols(){ // regenerate the form $form = tripal_views_setup_ajax_rebuild_form($form_state, $args, $_POST); // because the AJAX sent a post of the mview_id, the form now has in it // form components for the rows for the materialized view. We want to add // these components to the page, but we don't need to add the existing form // elements because they are already there. $view_setup_table_form = $form['view_setup_table']; unset($view_setup_table_form['#prefix'], $view_setup_table_form['#suffix']); $output = theme('status_message') . drupal_render($view_setup_table_form); // Final rendering callback. $javascript = drupal_add_js(NULL, NULL, 'header'); drupal_json(array('status' => TRUE, 'data' => $output, 'settings' => call_user_func('array_merge_recursive', $javascript['setting']))); } /** * * @ingroup tripal_view_setup */ function tripal_view_setup_ajax_field_col_join(){ // regenerate the form $form = tripal_views_setup_ajax_rebuild_form($form_state, $args, $_POST); // get the information we need to pull out table select box that was changed $mview_id = $form_state['values']['mview_id']; // $row = $form_state['values']['mview_id']; // $row_select_box = $form['view_setup_table']["fields-column-join-column-$mview_id-1"]; // unset($row_select_box['#prefix'], $row_select_box['#suffix']); // $output = theme('status_message') . drupal_render($row_select_box); // Final rendering callback. // $javascript = $javascript = drupal_add_js(NULL); // drupal_json(array('status' => TRUE, 'data' => $output, 'settings' => call_user_func('array_merge_recursive', $javascript['setting']))); $javascript = drupal_add_js(NULL, NULL, 'header'); drupal_json(array('status' => TRUE, 'data' => 'helloworld', 'settings' => call_user_func('array_merge_recursive', $javascript['setting']))); } /** * * @ingroup tripal_view_setup */ function tripal_views_setup_ajax_rebuild_form(&$form_state, &$args, &$_POST){ // Retrieve the form from the cache $form_state = array('storage' => NULL, 'submitted' => FALSE,); $form_build_id = $_POST['form_build_id']; $form = form_get_cache($form_build_id, $form_state); // Preparing to process the form $args = $form['#parameters']; $form_id = array_shift($args); $form_state['post'] = $form['#post'] = $_POST; $form['#programmed'] = $form['#redirect'] = FALSE; // Sets the form_state so that the validate and submit handlers can tell // when the form is submitted via AHAH $form_state['ahah_submission'] = TRUE; // Process the form with drupal_process_form. This function calls the submit // handlers, which put whatever was worthy of keeping into $form_state. drupal_process_form($form_id, $form, $form_state); // You call drupal_rebuild_form which destroys $_POST. // The form generator function is called and creates the form again but since // it knows to use $form_state, the form will be different. // The new form gets cached and processed again, but because $_POST is // destroyed, the submit handlers will not be called again. $form = drupal_rebuild_form($form_id, $form_state, $args, $form_build_id); dpm($form,'form at rebuild'); dpm($form_state['post'], 'post at rebuild'); return $form; } /** * * @ingroup tripal_view_setup */ // function tripal_views_setup_fields(&$form_state=NULL, $mview_id = NULL){ // if(!$mview_id){ // return; // } // // get the columns in this materialized view. They are separated by commas // // where the first word is the column name and the rest is the type // $sql = "SELECT mv_specs FROM {tripal_mviews} WHERE mview_id = $mview_id"; // $mview = db_fetch_object(db_query($sql)); // $columns = explode(",",$mview->mv_specs); // $i=1; // $chado_tables = tripal_core_get_chado_tables(); // $handlers = array(); // $form["fields_headers"] = array( // '#type' => 'markup', // '#value' => "
". // "
Field Name and Type
". // "
Join Table
". // "
Join Column
". // "
Handler
", // ); // foreach ($columns as $column){ // $column = trim($column); // trim trailing and leading spaces // preg_match("/^(.*?)\ (.*?)$/",$column,$matches); // $column_name = $matches[1]; // $column_type = $matches[2]; // // first print the field name // $form["fields_start_$i"] = array( // '#type' => 'markup', // '#value' => "
", // ); // $form["fields_column_name_$i"] = array( // '#type' => 'markup', // '#attributes' => array('class' => 'fields-column-name'), // '#value' => "
$column_name". // "
$column_type
", // ); // // second print the table join drop down // $chado_tables = array_merge(array(NULL,), $chado_tables); // $form["fields_column_join_$i"] = array( // '#type' => 'select', // '#prefix' => "
", // '#suffix' => "
", // '#options' => $chado_tables, // '#required' => FALSE, // '#ahah' => array( // 'path' => 'admin/tripal/tripal_views_setup/ajax/field_col_join', // 'wrapper' => "fields-column-join-column-$i", // 'effect' => 'fade', // 'event' => 'change', // 'method' => 'replace', // ), // ); // $form["fields_column_join_column_$i"] = array( // '#type' => 'select', // '#prefix' => "
", // '#suffix' => "
", // '#options' => array(), // '#required' => FALSE, // ); // $form["fields_column_handler_$i"] = array( // '#type' => 'select', // '#prefix' => "
", // '#suffix' => "
", // '#options' => $handlers, // '#required' => FALSE, // ); // $form["fields_end_$i"] = array( // '#type' => 'markup', // '#value' => "
", // ); // $i++; // } // $form['row_counter'] = array( // '#type' => 'hidden', // '#value' => $i, // ); // $form['submit'] = array( // '#type' => 'submit', // '#value' => 'Create', // ); // return $form; // } // function tripal_views_setup_fields_form_submit($form, &$form_state){ // ----($form,'formfield'); // ----($form_state, 'formstatefield'); // } /** * * @ingroup tripal_view_setup */ function tripal_views_setup_new_setup_form_submit($form, &$form_state){ dpm($form, 'form on submit'); dpm($form_state, 'forms_state on submit'); }