Interface created to propose a new case study project and manage the proposals

1 files changed, 150 insertions, 0 deletions

diff --git a/run.inc b/run.inc
new file mode 100755
index 0000000..c047b78
--- /dev/null
+++ b/run.inc
@@ -0,0 +1,150 @@
+<?php
+function cfd_case_study_run_form($form, &$form_state)
+{
+	$options_first = _list_of_case_study();
+	$url_case_study_id = (int) arg(2);
+	$case_study_data = _case_study_information($url_case_study_id);
+	if ($case_study_data == 'Not found') {
+		$url_case_study_id = '';
+	} //$case_study_data == 'Not found'
+	if (!$url_case_study_id) {
+		$selected = isset($form_state['values']['case_study']) ? $form_state['values']['case_study'] : key($options_first);
+	} //!$url_case_study_id
+	elseif ($url_case_study_id == '') {
+		$selected = 0;
+	} //$url_case_study_id == ''
+	else {
+		$selected = $url_case_study_id;
+	}
+	$form = array();
+	$form['case_study'] = array(
+		'#type' => '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' => '<div id="ajax_case_study_details"></div>'
+		);
+		$form['selected_case_study'] = array(
+			'#type' => 'item',
+			'#markup' => '<div id="ajax_selected_case_study"></div>'
+		);
+	} //!$url_case_study_id
+	else {
+		$case_study_default_value = $url_case_study_id;
+		$form['case_study_details'] = array(
+			'#type' => 'item',
+			'#markup' => '<div id="ajax_case_study_details">' . _case_study_details($case_study_default_value) . '</div>'
+		);
+		$form['selected_case_study'] = array(
+			'#type' => 'item',
+			'#markup' => '<div id="ajax_selected_case_study">' . l('Download Case Study', 'case-study-project/full-download/project/' . $case_study_default_value) . '</div>'
+		);
+	}
+	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 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 .= "<th>{$header}</th>";
+	} //$headers as $header
+	foreach ($rows as $row) {
+		$tbody .= "<tr>";
+		foreach ($row as $data) {
+			$tbody .= "<td>{$data}</td>";
+		} //$row as $data
+		$tbody .= "</tr>";
+	} //$rows as $row
+	$table = "
+            <table class='table table-bordered table-hover' style='margin-left:-140px'>
+                <thead>{$thead}</thead>
+                <tbody>{$tbody}</tbody>
+            </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) {
+		if($case_study_details->reference != NULL){
+		$url = '~(?:(https?)://([^\s<]+)|(www\.[^\s<]+?\.[^\s<]+))(?<![\.,:])~i';
+	        $reference = preg_replace($url, '<a href="$0" target="_blank" title="$0">$0</a>', $case_study_details->reference);
+		}else{
+		$reference = 'Not provided';
+		}
+		$form['case_study_details']['#markup'] = '<span style="color: rgb(128, 0, 0);"><strong>About the case study</strong></span></td><td style="width: 35%;"><br />' . '<ul>' . '<li><strong>Proposer Name:</strong> ' . $case_study_details->name_title . ' ' . $case_study_details->contributor_name . '</li>' . '<li><strong>Title of the Flowhseet:</strong> ' . $case_study_details->project_title . '</li>' . '<li><strong>University:</strong> ' . $case_study_details->university . '</li>' . '</ul>';
+		$details = $form['case_study_details']['#markup'];
+		return $details;
+	} //$case_study_default_value != 0
+}