Merge pull request #48 from Saketh1499/development

Additional tabs required in manage flowsheet proposal

1 files changed, 189 insertions, 0 deletions

diff --git a/proposals_review_tab.inc b/proposals_review_tab.inc
new file mode 100644
index 0000000..fe74640
--- /dev/null
+++ b/proposals_review_tab.inc
@@ -0,0 +1,189 @@
+<?php
+
+//Proposal tab for reviewing approved proposals
+function dwsim_flowsheet_approved_tab()
+{
+	$page_content = "";
+	$result = db_query("SELECT * from dwsim_flowsheet_proposal where id not in (select proposal_id from dwsim_flowsheet_submitted_abstracts) AND approval_status = 1 order by approval_date desc");
+	if ($result->rowCount() == 0)
+	{
+		$page_content .= "Approved Proposals under Flowsheeting Project<hr>";
+	} //$result->rowCount() == 0
+	else
+	{
+		$page_content .= "Approved Proposals under Flowsheeting Project: " . $result->rowCount() . "<hr>";
+		$preference_rows = array();
+		$i = 1;
+		while ($row = $result->fetchObject())
+		{
+			$approval_date = date("d-M-Y", $row->approval_date);
+			$preference_rows[] = array(
+				$i,
+				$row->project_title,
+				$row->contributor_name,
+				$row->university,
+				$approval_date
+			);
+			$i++;
+		} 
+		$preference_header = array(
+			'No',
+			'Flowsheet Project',
+			'Contributor Name',
+			'University / Institute',
+			'Date of Approval'
+		);
+		$page_content .= theme('table', array(
+			'header' => $preference_header,
+			'rows' => $preference_rows
+		));
+	}
+	return $page_content;
+}
+
+
+///////////////////////////////////////////////////////////////////////
+//////////////////////////////////////////////////////////////////////
+/////////////////////////////////////////////////////////////////////
+
+//Proposal tab for reviewing Code submission of the uploaded proposals  
+
+function dwsim_flowsheet_uploaded_tab()
+{
+	$page_content = "";
+	$result = db_query("SELECT dfp.project_title, dfp.contributor_name, dfp.id, dfp.university, dfa.abstract_upload_date, dfa.abstract_approval_status from dwsim_flowsheet_proposal as dfp JOIN dwsim_flowsheet_submitted_abstracts as dfa on dfa.proposal_id = dfp.id where dfp.id in (select proposal_id from dwsim_flowsheet_submitted_abstracts) AND approval_status = 1");
+
+	if ($result->rowCount() == 0)
+	{
+		$page_content .= "Uploaded Proposals under Flowsheeting Project<hr>";
+	}
+	else
+	{
+		$page_content .= "Uploaded Proposals under Flowsheeting Project: " . $result->rowCount() . "<hr>";
+		$preference_rows = array();
+		$i = 1;
+		while ($row = $result->fetchObject())
+		{
+			$abstract_upload_date = date("d-M-Y", $row->abstract_upload_date);
+			$preference_rows[] = array(
+				$i,
+				$row->project_title,
+				$row->contributor_name,
+				$row->university,
+				$abstract_upload_date
+			);
+			$i++;
+		}
+		$preference_header = array(
+			'No',
+			'Flowsheet Project',
+			'Contributor Name',
+			'University / Institute',
+			'Date of file submission'
+		);
+		$page_content .= theme('table', array(
+			'header' => $preference_header,
+			'rows' => $preference_rows
+		));
+	}
+	return $page_content;
+}
+
+
+///////////////////////////////////////////////////////////////////////
+//////////////////////////////////////////////////////////////////////
+/////////////////////////////////////////////////////////////////////
+
+//Proposal tab for reviewing Completed proposals
+
+function dwsim_flowsheet_completed_tab_form($form, $form_state)
+{
+
+	$form['howmany_select'] = array(
+    '#title' => t('Sorting projects according to year:'),
+    '#type' => 'select',
+    '#options' => array(
+    	'Please select...' => 'Please select...',
+    	'2017' => '2017',
+    	'2018' => '2018', 
+    	'2019' => '2019', 
+    	'2020' => '2020', 
+    	'2021' => '2021'),
+    //'#default_value' => 'Please select...',
+    '#ajax' => array(
+      'callback' => 'ajax_example_autocheckboxes_callback',
+    ),
+    '#suffix' => '<div id="ajax-selected-flowsheet"></div>'
+
+	  );
+	return $form;
+}
+
+
+function ajax_example_autocheckboxes_callback($form, $form_state)
+{
+	$commands = array();
+	$flowsheet_project_default_value = $form_state['values']['howmany_select'];
+	if ($flowsheet_project_default_value != 0)
+	{
+		$form['howmany_select']['#options'] =  array('Please select...' => 'Please select...');
+		$commands[] = ajax_command_html('#ajax-selected-flowsheet', _flowsheet_details($flowsheet_project_default_value));
+		$commands[] = ajax_command_replace('#ajax_selected_flowsheet_action', drupal_render($form['howmany_select']));
+		
+	} 
+	else
+	{
+		$form['howmany_select']['#options'] =  array('Please select...' => 'Please select...');
+		$commands[] = ajax_command_data('#ajax_selected_flowsheet', 'form_state_value_select', $form_state['values']['howmany_select']);
+	}
+	return array(
+		'#type' => 'ajax',
+		'#commands' => $commands
+	);
+}
+
+
+function _flowsheet_details($flowsheet_proposal_id)
+{
+	$output = "";
+	$result = db_query("SELECT * from {dwsim_flowsheet_proposal} WHERE approval_status = 3 and from_unixtime(actual_completion_date, '%Y') = :year",
+		array(
+							':year' => $flowsheet_proposal_id)
+				 );
+	
+	if ($result->rowCount() == 0)
+	{
+		$output .= "Work has been completed for the following flow sheets.";
+
+	} 
+	else
+	{
+		$output .= "Work has been completed for the following flow sheets: " . $result->rowCount() . "<hr>";
+		$preference_rows = array();
+		$i = 1;
+		while ($row = $result->fetchObject())
+		{
+			$completion_date = date("d-M-Y", $row->actual_completion_date);
+			$preference_rows[] = array(
+				$i,
+				l($row->project_title, "flowsheeting-project/dwsim-flowsheet-run/" . $row->id, array('attributes' => array('title' => 'This is a zip file containing a pdf (abstract) and a dwxml/dwxmz file which is the DWSIM flow sheet which is to be viewed by right clicking on the file and opening with DWSIM.'))),
+				$row->contributor_name,
+				$row->university,
+				$completion_date
+			);
+			$i++;
+		} 
+		$preference_header = array(
+			'No',
+			'Flowsheet Project',
+			'Contributor Name',
+			'University / Institute',
+			'Date of Completion'
+		);
+		$output .= theme('table', array(
+			'header' => $preference_header,
+			'rows' => $preference_rows
+		));
+	}
+	return $output;
+}
\ No newline at end of file