Create a new bulk loader template
";
$del_url = url("admin/tripal/tripal_bulk_loader_template/delete");
$output .= "Delete a bulk loader template";
return $output;
}
/*******************************************************************************
* tripal_bulk_loader_admin_template_add
*/
function tripal_bulk_loader_admin_template_add () {
return drupal_get_form('tripal_bulk_loader_admin_template_form');
}
/*******************************************************************************
* tripal_bulk_loader_admin_template_form
*/
function tripal_bulk_loader_admin_template_form (&$form_state = NULL) {
$no_col = variable_get('tripal_bulk_loader_template_number_of_column', 0);
$name = variable_get('tripal_bulk_loader_template_name', NULL);
$form = array();
if ($no_col == 0) {
$form['template_name'] = array(
'#type' => 'textfield',
'#title' => t('Template Name'),
'#weight' => 0,
'#required' => TRUE,
'#default_value' => $template_name,
);
$form['no_cols'] = array(
'#type' => 'textfield',
'#title' => t('Number of Column'),
'#weight' => 1,
'#required' => TRUE,
'#maxlength' => 3,
'#size' =>3,
);
$form['addsheet'] = array (
'#type' => 'button',
'#value' => t('Add a sheet'),
'#weight' => 1,
'#executes_submit_callback' => TRUE,
);
} else {
$form['template_setting'] = array(
'#suffix' => '| Column# | Chado Table | Chado Column | Associated CVterm | Translate Regex |
|---|
',
'#type' => 'item',
'#title' => t("Template '$name'"),
);
}
$shema = "";
global $db_url;
if(is_array($db_url) and array_key_exists('chado',$db_url)){
$shema = 'public';
} else {
$shema = 'chado';
}
$sql = "SELECT table_name FROM information_schema.tables WHERE table_schema = '%s' ORDER BY table_name";
$previous_db = tripal_db_set_active('chado');
$result = db_query($sql, $shema);
$allowed_tables = array ();
while ($tb = db_fetch_object($result)) {
$allowed_tables[$tb->table_name] = $tb->table_name;
}
$first_table = db_result(db_query($sql,$shema));
$sql = "SELECT column_name FROM information_schema.columns WHERE table_name ='%s'";
$result = db_query($sql, $first_table);
$allowed_columns = array();
while ($col = db_fetch_object($result)) {
$allowed_columns[$col->column_name] = $col->column_name;
}
tripal_db_set_active($previous_db);
for ($i = 0; $i < $no_col; $i ++) {
$j = $i + 1;
$form[$i]['col'] = array(
'#prefix' => '| ',
'#suffix' => ' | ',
'#type' => 'textfield',
'#maxlength' => 3,
'#size' => 3,
'#required' => TRUE
);
global $base_url;
$form[$i]['chado_table'] = array(
'#prefix' => '',
'#suffix' => ' | ',
'#type' => 'select',
'#options' => $allowed_tables,
'#attributes' => array(
'onChange' => "return tripal_update_chado_columns(this,'$base_url')",
),
'#required' => TRUE
);
$form[$i]['chado_column'] = array(
'#prefix' => '',
'#suffix' => ' | ',
'#type' => 'select',
'#options' => $allowed_columns,
);
$form[$i]['chado_cvterm'] = array(
'#prefix' => '',
'#suffix' => ' | ',
'#type' => 'textfield',
'#size' => 10,
);
$form[$i]['chado_regex'] = array(
'#prefix' => '',
'#suffix' => ' |
',
'#type' => 'textfield',
'#size' => 10,
);
}
if ($no_col != 0) {
$form['removesheet'] = array (
'#type' => 'button',
'#value' => t('Remove this sheet'),
'#weight' => 49,
'#executes_submit_callback' => TRUE,
'#prefix' => '
',
);
$form['submit'] = array (
'#type' => 'submit',
'#value' => t('Save'),
'#weight' => 50,
'#executes_submit_callback' => TRUE,
);
}
return $form;
}
/************************************************************************
* tripal_bulk_loader_admin_template_form_submit
*/
function tripal_bulk_loader_admin_template_form_submit($form, &$form_state){
$op = $form_state['values']['op'];
if ($op == 'Add a sheet') {
$name = $form_state['values']['template_name'];
$sql = "SELECT template_id FROM {tripal_bulk_loader_template} WHERE name = '%s'";
$template_id = db_result(db_query($sql, $name));
if ($template_id) {
form_set_error('template_name',t("The template '$name' exists. Please use another name."));
variable_set('tripal_bulk_loader_template_name', NULL);
variable_set('tripal_bulk_loader_template_number_of_column', NULL);
} else {
variable_set('tripal_bulk_loader_template_name', $form_state['values']['template_name']);
variable_set('tripal_bulk_loader_template_number_of_column', $form_state['values']['no_cols']);
}
return;
} elseif ($op == 'Remove this sheet') {
variable_set('tripal_bulk_loader_template_name', NULL);
variable_set('tripal_bulk_loader_template_number_of_column', NULL);
return;
} elseif ($op == 'Save') {
$name = variable_get('tripal_bulk_loader_template_name', NULL);
$template_array = "array('DUMMY' => 'TEMPLATE ARRAY')";
$sql = "INSERT INTO {tripal_bulk_loader_template} (name, template_array) VALUES ('%s', '%s')";
if (db_query($sql, $name, $template_array)) {
drupal_set_message("Bulk loader template '$name' added.");
variable_set('tripal_bulk_loader_template_name', NULL);
variable_set('tripal_bulk_loader_template_number_of_column', NULL);
}
}
}
/************************************************************************
* tripal_bulk_loader_admin_template_delete
*/
function tripal_bulk_loader_admin_template_delete () {
return drupal_get_form('tripal_bulk_loader_admin_template_del_form');
}
/************************************************************************
* tripal_bulk_loader_admin_template_del_from
*/
function tripal_bulk_loader_admin_template_del_form (&$form_state = NULL) {
$form = array();
$sql = "SELECT * FROM {tripal_bulk_loader_template}";
$results = db_query($sql);
$templates = array();
while ($template = db_fetch_object($results)) {
$templates [$template->template_id] = $template->name;
}
if ($templates) {
$form['label'] = array(
'#type' => 'item',
'#title' => t('Select a template to delete'),
'#weight' => 0,
);
$form['template_name'] = array(
'#type' => 'select',
'#title' => t('Template Name'),
'#options' => $templates,
'#weight' => 1,
'#required' => TRUE
);
$form['submit'] = array (
'#type' => 'submit',
'#value' => t('Delete'),
'#weight' => 2,
'#executes_submit_callback' => TRUE,
);
} else {
$form['label'] = array(
'#type' => 'item',
'#description' => t('No template available'),
'#weight' => 0,
);
}
return $form;
}
/************************************************************************
* tripal_bulk_loader_admin_template_del_form_submit
*/
function tripal_bulk_loader_admin_template_del_form_submit($form, &$form_state){
$template = $form_state['values']['template_name'];
$name = db_result(db_query("SELECT name FROM {tripal_bulk_loader_template} WHERE template_id = $template"));
$sql = "DELETE FROM {tripal_bulk_loader_template} WHERE template_id = %d";
if (db_query($sql, $template)) {
drupal_set_message("Bulk loader template '$name' deleted.");
}
}
/************************************************************************
* tripal_bulk_loader_chado_column_ajax
*/
function tripal_bulk_loader_chado_column_ajax ($table) {
$sql = "SELECT column_name FROM information_schema.columns WHERE table_name ='%s'";
$previous_db = tripal_db_set_active('chado');
$result = db_query($sql, $table);
tripal_db_set_active($previous_db);
$cols = array();
while ($col = db_fetch_object($result)) {
$cols[$col->column_name] = $col->column_name;
}
drupal_json($cols);
}