'select',
'#title' => t('Title of the case study'),
'#options' => _list_of_case_study(),
'#default_value' => $selected,
'#ajax' => array(
'callback' => 'case_study_project_details_callback'
)
);
if (!$url_case_study_id) {
$form['case_study_details'] = array(
'#type' => 'item',
'#markup' => ''
);
$form['selected_case_study'] = array(
'#type' => 'item',
'#markup' => ''
);
} //!$url_case_study_id
else {
$case_study_default_value = $url_case_study_id;
$form['case_study_details'] = array(
'#type' => 'item',
'#markup' => '' . _case_study_details($case_study_default_value) . '
'
);
$form['selected_case_study'] = array(
'#type' => 'item',
'#markup' => '' . l('Download Abstract', "case-study-project/download/project-file/" . $case_study_default_value) . '
' . l('Download Case Study', 'case-study-project/full-download/project/' . $case_study_default_value) . '
'
);
}
return $form;
}
function case_study_project_details_callback($form, $form_state)
{
$commands = array();
$case_study_default_value = $form_state['values']['case_study'];
if ($case_study_default_value != 0) {
$form['case_study_details']['#markup'] = _case_study_details($case_study_default_value);
$case_study_details = _case_study_information($case_study_default_value);
$provider = user_load($case_study_details->uid);
if ($case_study_details->uid > 0) {
$commands[] = ajax_command_html('#ajax_selected_case_study', l('Download Abstract', "case-study-project/download/project-file/" . $case_study_default_value) . '
' . l('Download case study', 'case-study-project/full-download/project/' . $case_study_default_value));
} //$case_study_details->uid > 0
else {
$commands[] = ajax_command_html('#ajax_selected_case_study', '');
$commands[] = ajax_command_html('#ajax_selected_case_study', '');
}
$commands[] = ajax_command_html('#ajax_case_study_details', _case_study_details($case_study_default_value));
} //$case_study_default_value != 0
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_case_study_details', '');
$commands[] = ajax_command_html('#ajax_selected_case_study', '');
$commands[] = ajax_command_html('#ajax_selected_case_study', '');
$commands[] = ajax_command_data('#ajax_selected_case_study', 'form_state_value_select', $form_state['values']['case_study']);
}
return array(
'#type' => 'ajax',
'#commands' => $commands
);
}
function bootstrap_table_format($headers, $rows)
{
$thead = "";
$tbody = "";
foreach ($headers as $header) {
$thead .= "{$header} | ";
} //$headers as $header
foreach ($rows as $row) {
$tbody .= "";
foreach ($row as $data) {
$tbody .= "| {$data} | ";
} //$row as $data
$tbody .= "
";
} //$rows as $row
$table = "
";
return $table;
}
/*****************************************************/
function _list_of_case_study()
{
$case_study_titles = array(
'0' => 'Please select...'
);
//$lab_titles_q = db_query("SELECT * FROM {case_study_proposal} WHERE solution_display = 1 ORDER BY lab_title ASC");
$query = db_select('case_study_proposal');
$query->fields('case_study_proposal');
$query->condition('approval_status', 3);
$query->orderBy('project_title', 'ASC');
$case_study_titles_q = $query->execute();
while ($case_study_titles_data = $case_study_titles_q->fetchObject()) {
$case_study_titles[$case_study_titles_data->id] = $case_study_titles_data->project_title . ' (Proposed by ' . $case_study_titles_data->name_title . ' ' . $case_study_titles_data->contributor_name . ')';
} //$case_study_titles_data = $case_study_titles_q->fetchObject()
return $case_study_titles;
}
function _case_study_information($proposal_id)
{
$query = db_select('case_study_proposal');
$query->fields('case_study_proposal');
$query->condition('id', $proposal_id);
$query->condition('approval_status', 3);
$case_study_q = $query->execute();
$case_study_data = $case_study_q->fetchObject();
if ($case_study_data) {
return $case_study_data;
} //$case_study_data
else {
return 'Not found';
}
}
function _case_study_details($case_study_default_value)
{
$case_study_details = _case_study_information($case_study_default_value);
if ($case_study_default_value != 0) {
$form['case_study_details']['#markup'] = 'About the case study
' . '' . '- Proposer Name: ' . $case_study_details->name_title . ' ' . $case_study_details->contributor_name . '
' . '- Title of the Case Study: ' . $case_study_details->project_title . '
' . '- University: ' . $case_study_details->university . '
' . ' ';
$details = $form['case_study_details']['#markup'];
return $details;
} //$case_study_default_value != 0
}
|