',
);
return $form;
}
/**
*
* @ingroup tripal_view_search
*/
function tripal_view_search_ajax_mview_cols(){
dpm($_POST, 'post');
$mview_id = $_POST['mview_id'];
$form = drupal_get_form('tripal_views_setup_fields_form',$mview_id);
drupal_json(array('status' => TRUE, 'data' => $form));
}
/**
*
* @ingroup tripal_view_search
*/
function tripal_views_setup_fields_form(&$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' => "",
);
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){
dpm($form,'formfield');
dpm($form_state, 'formstatefield');
}
/**
*
* @ingroup tripal_view_search
*/
function tripal_view_search_ajax_field_col_join(){
dpm($_POST);
dpm($_POST['row_counter'], 'rowcounter');
drupal_json(array('status' => TRUE, 'data' => 'howdy'));
}
/**
*
* @ingroup tripal_view_search
*/
function tripal_views_setup_new_search_form_submit($form, &$form_state){
dpm($form,'form');
dpm($form_state, 'formstate');
}