'select',
'#title' => t('Title of the lab'),
'#options' => _list_of_labs(),
'#default_value' => $selected,
'#ajax' => array(
'callback' => 'ajax_experiment_list_callback'
)
);
if (!$url_lab_id)
{
$form['selected_lab'] = array(
'#type' => 'item',
'#markup' => ''
);
$form['selected_lab_dwsim'] = array(
'#type' => 'item',
'#markup' => ''
);
$form['selected_lab_pdf'] = array(
'#type' => 'item',
'#markup' => ''
);
$form['lab_details'] = array(
'#type' => 'item',
'#markup' => ''
);
$form['lab_experiment_list'] = array(
'#type' => 'select',
'#title' => t('Titile of the experiment'),
'#options' => _ajax_get_experiment_list($selected),
//'#default_value' => isset($form_state['values']['lab_experiment_list']) ? $form_state['values']['lab_experiment_list'] : '',
'#ajax' => array(
'callback' => 'ajax_solution_list_callback'
),
'#prefix' => '',
'#suffix' => '
',
'#states' => array(
'invisible' => array(
':input[name="lab"]' => array(
'value' => 0
)
)
)
);
$form['download_experiment'] = array(
'#type' => 'item',
'#markup' => ''
);
$form['lab_solution_list'] = array(
'#type' => 'select',
'#title' => t('Solution'),
'#options' => _ajax_get_solution_list($select_two),
//'#default_value' => isset($form_state['values']['lab_solution_list']) ?
//$form_state['values']['lab_solution_list'] : '',
'#ajax' => array(
'callback' => 'ajax_solution_files_callback'
),
'#prefix' => '',
'#suffix' => '
',
'#states' => array(
'invisible' => array(
':input[name="lab"]' => array(
'value' => 0
)
)
)
);
$form['download_solution'] = array(
'#type' => 'item',
'#markup' => ''
);
$form['edit_solution'] = array(
'#type' => 'item',
'#markup' => ''
);
$form['solution_files'] = array(
'#type' => 'item',
// '#title' => t('List of solution_files'),
'#markup' => '',
'#states' => array(
'invisible' => array(
':input[name="lab"]' => array(
'value' => 0
)
)
)
);
}
else
{
$lab_default_value = $url_lab_id;
$form['selected_lab'] = array(
'#type' => 'item',
'#markup' => '' . l('Download Lab Solutions', 'lab-migration/download/lab/' . $lab_default_value) . '
'
);
/* $form['selected_lab_pdf'] = array(
'#type' => 'item',
'#markup' => ''. l('Download PDF of Lab Solutions', 'lab-migration/generate-lab/' . $lab_default_value . '/1') .'
',
);*/
if ($lab_default_value == '2')
{
$form['selected_lab_dwsim'] = array(
'#type' => 'item',
'#markup' => '' . l('Download Lab Solutions (dwsim Version)', 'lab-migration-uploads/dwsim_Version.zip') . '
'
);
}
$form['lab_details'] = array(
'#type' => 'item',
'#markup' => '' . _lab_details($lab_default_value) . '
'
);
$form['lab_experiment_list'] = array(
'#type' => 'select',
'#title' => t('Titile of the experiment'),
'#options' => _ajax_get_experiment_list($selected),
// '#default_value' => isset($form_state['values']['lab_experiment_list']) ? $form_state['values']['lab_experiment_list'] : '',
'#ajax' => array(
'callback' => 'ajax_solution_list_callback'
),
'#prefix' => '',
'#suffix' => '
',
'#states' => array(
'invisible' => array(
':input[name="lab"]' => array(
'value' => 0
)
)
)
);
$form['download_experiment'] = array(
'#type' => 'item',
'#markup' => ''
);
$form['lab_solution_list'] = array(
'#type' => 'select',
'#title' => t('Solution'),
'#options' => _ajax_get_solution_list($select_two),
'#default_value' => isset($form_state['values']['lab_solution_list']) ? $form_state['values']['lab_solution_list'] : '',
'#ajax' => array(
'callback' => 'ajax_solution_files_callback'
),
'#prefix' => '',
'#suffix' => '
',
'#states' => array(
'invisible' => array(
':input[name="lab_experiment_list"]' => array(
'value' => 0
)
)
)
);
$form['download_solution'] = array(
'#type' => 'item',
'#markup' => ''
);
$form['edit_solution'] = array(
'#type' => 'item',
'#markup' => ''
);
$form['solution_files'] = array(
'#type' => 'item',
// '#title' => t('List of solution_files'),
'#markup' => '',
'#states' => array(
'invisible' => array(
':input[name="lab_experiment_list"]' => array(
'value' => 0
)
)
)
);
}
/*
$form['message'] = array(
'#type' => 'textarea',
'#title' => t('If Dis-Approved please specify reason for Dis-Approval'),
'#prefix' => '',
'#states' => array('invisible' => array(':input[name="lab"]' => array('value' => 0,),),),
);
$form['submit'] = array(
'#type' => 'submit',
'#value' => t('Submit'),
'#suffix' => '
',
'#states' => array('invisible' => array(':input[name="lab"]' => array('value' => 0,),),),
);*/
return $form;
}
function ajax_experiment_list_callback($form, $form_state)
{
$commands = array();
$lab_default_value = $form_state['values']['lab'];
if ($lab_default_value != 0)
{
$form['lab_details']['#markup'] = _lab_details($lab_default_value);
$lab_details = _lab_information($lab_default_value);
$user_solution_provider = user_load($lab_details->solution_provider_uid);
//var_dump($lab_details->solution_provider_uid);
if ($lab_details->solution_provider_uid > 0)
{
$commands[] = ajax_command_html('#ajax_selected_lab', l('Download Lab Solutions', 'lab-migration/download/lab/' . $lab_default_value));
if ($lab_default_value == '2')
{
$commands[] = ajax_command_html('#ajax_selected_lab_dwsim', l('Download Lab Solutions (dwsim Version)', 'lab-migration_uploads/dwsim_Version.zip'));
}
/* $commands[] = ajax_command_html('#ajax_selected_lab_pdf', l('Download PDF of Lab Solutions', 'lab-migration/generate-lab/' . $lab_default_value . '/1'));*/
}
else
{
$commands[] = ajax_command_html('#ajax_selected_lab', '');
$commands[] = ajax_command_html('#ajax_selected_lab_pdf', '');
$commands[] = ajax_command_html('#ajax_selected_lab_dwsim', '');
}
$commands[] = ajax_command_html('#ajax_lab_details', _lab_details($lab_default_value));
$form['lab_experiment_list']['#options'] = _ajax_get_experiment_list($lab_default_value);
$commands[] = ajax_command_replace('#ajax_selected_experiment', drupal_render($form['lab_experiment_list']));
$commands[] = ajax_command_html('#ajax_selected_solution', '');
$commands[] = ajax_command_html('#ajax_solution_files', '');
$commands[] = ajax_command_html('#ajax_download_experiment_solution', '');
$commands[] = ajax_command_html('#ajax_edit_experiment_solution', '');
$commands[] = ajax_command_html('#ajax_download_experiments', '');
}
else
{
$form['lab_experiment_list']['#options'] = _ajax_get_experiment_list();
$commands[] = ajax_command_replace('#ajax_selected_experiment', drupal_render($form['lab_experiment_list']));
$commands[] = ajax_command_html('#ajax_lab_details', '');
$commands[] = ajax_command_html('#ajax_selected_lab', '');
$commands[] = ajax_command_html('#ajax_selected_lab_dwsim', '');
$commands[] = ajax_command_html('#ajax_selected_lab_pdf', '');
$commands[] = ajax_command_data('#ajax_selected_lab', 'form_state_value_select', $form_state['values']['lab']);
$commands[] = ajax_command_html('#ajax_selected_experiment', '');
$commands[] = ajax_command_html('#ajax_download_experiments', '');
$commands[] = ajax_command_html('#ajax_selected_solution', '');
$commands[] = ajax_command_html('#ajax_solution_files', '');
$commands[] = ajax_command_html('#ajax_download_experiment_solution', '');
$commands[] = ajax_command_html('#ajax_edit_experiment_solution', '');
}
return array(
'#type' => 'ajax',
'#commands' => $commands
);
}
function ajax_solution_list_callback($form, $form_state)
{
$commands = array();
$experiment_list_default_value = $form_state['values']['lab_experiment_list'];
//var_dump($lab_default_value);
if ($experiment_list_default_value != 0)
{
$form['lab_solution_list']['#options'] = _ajax_get_solution_list($experiment_list_default_value);
$commands[] = ajax_command_html('#ajax_download_experiments', l('Download Experiment', 'lab-migration/download/experiment/' . $experiment_list_default_value));
$commands[] = ajax_command_html('#ajax_selected_experiment', drupal_render($form['lab_experiment_list']));
$commands[] = ajax_command_html('#ajax_selected_solution', drupal_render($form['lab_solution_list']));
// $commands[] = ajax_command_html('#ajax_solution_files', '');
// $commands[] = ajax_command_html('#ajax_download_experiment_solution', '');
// $commands[] = ajax_command_html('#ajax_edit_experiment_solution', '');
}
else
{
$form['lab_solution_list']['#options'] = _ajax_get_solution_list();
$commands[] = ajax_command_html('#ajax_selected_solution', drupal_render($form['lab_solution_list']));
$commands[] = ajax_command_html('#ajax_download_experiments', '');
$commands[] = ajax_command_html('#ajax_selected_solution', '');
$commands[] = ajax_command_html('#ajax_solution_files', '');
$commands[] = ajax_command_html('#ajax_download_experiment_solution', '');
$commands[] = ajax_command_html('#ajax_edit_experiment_solution', '');
// $commands[] = ajax_command_replace('#ajax_selected_experiment',drupal_render($form['lab_experiment_list']));
}
return array(
'#type' => 'ajax',
'#commands' => $commands
);
}
function ajax_solution_files_callback($form, $form_state)
{
$commands = array();
$solution_list_default_value = $form_state['values']['lab_solution_list'];
//var_dump($lab_default_value);
if ($solution_list_default_value != 0)
{
$commands[] = ajax_command_html('#ajax_selected_lab_experiment_solution_action', drupal_render($form['lab_experiment_solution_actions']));
/*************************************************************************************/
//$solution_list_q = db_query("SELECT * FROM {lab_migration_solution_files} WHERE solution_id = %d", $form_state['values']['solution']);
$query = db_select('lab_migration_solution_files');
$query->fields('lab_migration_solution_files');
$query->condition('solution_id', $solution_list_default_value);
$solution_list_q = $query->execute();
if ($solution_list_q)
{
$solution_files_rows = array();
while ($solution_list_data = $solution_list_q->fetchObject())
{
$solution_file_type = '';
switch ($solution_list_data->filetype)
{
case 'S':
$solution_file_type = 'Source or Main file';
break;
case 'R':
$solution_file_type = 'Result file';
break;
case 'X':
$solution_file_type = 'xcos file';
break;
default:
$solution_file_type = 'Unknown';
break;
}
$solution_files_rows[] = array(
l($solution_list_data->filename, 'lab-migration/download/file/' . $solution_list_data->id),
$solution_file_type
);
}
/* dependency files */
//$dependency_q = db_query("SELECT * FROM {lab_migration_solution_dependency} WHERE solution_id = %d", $form_state['values']['solution']);
$query = db_select('lab_migration_solution_dependency');
$query->fields('lab_migration_solution_dependency');
$query->condition('solution_id', $solution_list_default_value);
$dependency_q = $query->execute();
while ($dependency_data = $dependency_q->fetchObject())
{
//$dependency_files_q = db_query("SELECT * FROM {lab_migration_dependency_files} WHERE id = %d", $dependency_data->dependency_id);
$query = db_select('lab_migration_dependency_files');
$query->fields('lab_migration_dependency_files');
$query->condition('id', $dependency_data->dependency_id);
$dependency_files_q = $query->execute();
$dependency_files_data = $dependency_files_q->fetchObject();
$solution_file_type = 'Dependency file';
$solution_files_rows[] = array(
l($dependency_files_data->filename, 'lab-migration/download/dependency/' . $dependency_files_data->id),
$solution_file_type
);
}
/* creating list of files table */
$solution_files_header = array(
'Filename',
'Type'
);
$solution_files = theme('table', array(
'header' => $solution_files_header,
'rows' => $solution_files_rows
));
}
$form['solution_files']['#title'] = 'List of solution files';
$form['solution_files']['#markup'] = $solution_files;
$commands[] = ajax_command_html('#ajax_download_experiment_solution', l('Download Solution', 'lab-migration/download/solution/' . $solution_list_default_value));
// $commands[] = ajax_command_html('#ajax_edit_experiment_solution', l('Edit Solution', 'code_approval/editcode/' . $solution_list_default_value));
// $commands[] = ajax_command_html('#ajax_solution_files', $solution_files);
$commands[] = ajax_command_html('#ajax_solution_files', drupal_render($form['solution_files']));
}
else
{
$commands[] = ajax_command_html('#ajax_selected_lab_experiment_solution_action', '');
$commands[] = ajax_command_html('#ajax_download_experiment_solution', '');
$commands[] = ajax_command_html('#ajax_edit_experiment_solution', '');
$commands[] = ajax_command_html('#ajax_solution_files', '');
}
return array(
'#type' => 'ajax',
'#commands' => $commands
);
}
function bootstrap_table_format($headers, $rows)
{
$thead = "";
$tbody = "";
foreach ($headers as $header)
{
$thead .= "{$header} | ";
}
foreach ($rows as $row)
{
$tbody .= "";
foreach ($row as $data)
{
$tbody .= "| {$data} | ";
}
$tbody .= "
";
}
$table = "
";
return $table;
}
/*****************************************************/
function _list_of_labs()
{
$lab_titles = array(
'0' => 'Please select...'
);
//$lab_titles_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE solution_display = 1 ORDER BY lab_title ASC");
$query = db_select('lab_migration_proposal');
$query->fields('lab_migration_proposal');
$query->condition('solution_display', 1);
$query->condition('approval_status', 3);
$query->orderBy('lab_title', 'ASC');
$lab_titles_q = $query->execute();
while ($lab_titles_data = $lab_titles_q->fetchObject())
{
$lab_titles[$lab_titles_data->id] = $lab_titles_data->lab_title . ' (Proposed by ' . $lab_titles_data->name_title .' '.$lab_titles_data->name . ')';
}
return $lab_titles;
}
function _ajax_get_experiment_list($lab_default_value = '')
{
$experiments = array(
'0' => 'Please select...'
);
//$experiments_q = db_query("SELECT * FROM {lab_migration_experiment} WHERE proposal_id = %d ORDER BY number ASC", $proposal_id);
$query = db_select('lab_migration_experiment');
$query->fields('lab_migration_experiment');
$query->condition('proposal_id', $lab_default_value);
$query->orderBy('number', 'ASC');
$experiments_q = $query->execute();
while ($experiments_data = $experiments_q->fetchObject())
{
$experiments[$experiments_data->id] = $experiments_data->number . '. ' . $experiments_data->title;
}
return $experiments;
}
function _ajax_get_solution_list($lab_experiment_list = '')
{
$solutions = array(
'0' => 'Please select...'
);
// $solutions_q = db_query("SELECT * FROM {lab_migration_solution} WHERE experiment_id = %d ORDER BY
// CAST(SUBSTRING_INDEX(code_number, '.', 1) AS BINARY) ASC,
// CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(code_number , '.', 2), '.', -1) AS UNSIGNED) ASC,
// CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(code_number , '.', -1), '.', 1) AS UNSIGNED) ASC", $experiment_id);
$query = db_select('lab_migration_solution');
$query->fields('lab_migration_solution');
$query->condition('experiment_id', $lab_experiment_list);
//$query->orderBy("CAST(SUBSTRING_INDEX(code_number, '.', 1) AS BINARY", "ASC");
// $query->orderBy("CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(code_number , '.', 2), '.', -1) AS UNSIGNED", "ASC");
// $query->orderBy("CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(code_number , '.', -1), '.', 1) AS UNSIGNED", "ASC");
$solutions_q = $query->execute();
while ($solutions_data = $solutions_q->fetchObject())
{
$solutions[$solutions_data->id] = $solutions_data->code_number . ' (' . $solutions_data->caption . ')';
}
return $solutions;
}
function _lab_information($proposal_id)
{
//$lab_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE id = %d", $proposal_id);
$query = db_select('lab_migration_proposal');
$query->fields('lab_migration_proposal');
$query->condition('id', $proposal_id);
$query->condition('approval_status', 3);
$lab_q = $query->execute();
$lab_data = $lab_q->fetchObject();
if($lab_data){
return $lab_data;
}
else
{
return ;
}
}
function _lab_details($lab_default_value)
{
//$lab_default_value = $form_state['values']['lab'];
$lab_details = _lab_information($lab_default_value);
if ($lab_default_value != 0)
{
if ($lab_details){
if ($lab_details->solution_provider_uid > 0)
{
$user_solution_provider = user_load($lab_details->solution_provider_uid);
if ($user_solution_provider)
{
$solution_provider = 'Solution Provider
' . '' . '- Solution Provider Name: ' . $lab_details->solution_provider_name_title . ' ' . $lab_details->solution_provider_name . '
' . '- Department: ' . $lab_details->solution_provider_department . '
' . '- University: ' . $lab_details->solution_provider_university . '
' . ' ';
}
else
{
$solution_provider = 'Solution Provider |
' . '' . '- Solution Provider: (Open)
' . ' ';
}
}
else
{
$solution_provider = 'Solution Provider |
' . '' . '- Solution Provider: (Open)
' . ' ';
}}
else{
drupal_goto('lab-migration/lab-migration-run');
}
$form['lab_details']['#markup'] = 'About the Lab |
' . '' . '- Proposer Name: ' . $lab_details->name_title . ' ' . $lab_details->name . '
' . '- Title of the Lab: ' . $lab_details->lab_title . '
' . '- Department: ' . $lab_details->department . '
' . '- University: ' . $lab_details->university . '
' . '- Category: ' . $lab_details->category . '
' . ' ' . $solution_provider;
$details = $form['lab_details']['#markup'];
return $details;
}
}
|