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

13 files changed, 3919 insertions, 0 deletions

diff --git a/abstract_bulk_approval.inc b/abstract_bulk_approval.inc
new file mode 100755
index 0000000..72e8f74
--- /dev/null
+++ b/abstract_bulk_approval.inc
@@ -0,0 +1,402 @@
+<?php
+
+function cfd_case_study_abstract_bulk_approval_form($form, &$form_state)
+{
+	$options_first = _bulk_list_of_case_study_project();
+	$selected = isset($form_state['values']['case_study_project']) ? $form_state['values']['case_study_project'] : key($options_first);
+	$form = array();
+	$form['case_study_project'] = array(
+		'#type' => 'select',
+		'#title' => t('Title of the case study project'),
+		'#options' => _bulk_list_of_case_study_project(),
+		'#default_value' => $selected,
+		'#ajax' => array(
+			
+			'callback' => 'ajax_bulk_case_study_abstract_details_callback'
+		),
+		'#suffix' => '<div id="ajax_selected_case_study"></div><div id="ajax_selected_case_study_pdf"></div>'
+	);
+	$form['case_study_actions'] = array(
+		'#type' => 'select',
+		'#title' => t('Please select action for case study project'),
+		'#options' => _bulk_list_case_study_actions(),
+		'#default_value' => 0,
+		'#prefix' => '<div id="ajax_selected_case_study_action" style="color:red;">',
+		'#suffix' => '</div>',
+		'#states' => array(
+			'invisible' => array(
+				':input[name="case_study_project"]' => array(
+					'value' => 0
+				)
+			)
+		)
+	);
+	$form['message'] = array(
+		'#type' => 'textarea',
+		'#title' => t('If Dis-Approved please specify reason for Dis-Approval'),
+		'#prefix' => '<div id= "message_submit">',
+		'#states' => array(
+			'visible' => array(
+				array(
+					':input[name="case_study_actions"]' => array(
+						'value' => 3
+					)
+				),
+				'or',
+				array(
+					':input[name="case_study_actions"]' => array(
+						'value' => 4
+					)
+				)
+			)
+		)
+	);
+	$form['submit'] = array(
+		'#type' => 'submit',
+		'#value' => t('Submit'),
+		'#states' => array(
+			'invisible' => array(
+				':input[name="lab"]' => array(
+					'value' => 0
+				)
+			)
+		)
+	);
+	return $form;
+}
+function ajax_bulk_case_study_abstract_details_callback($form, $form_state)
+{
+	$commands = array();
+	$case_study_project_default_value = $form_state['values']['case_study_project'];
+	if ($case_study_project_default_value != 0)
+	{
+		$commands[] = ajax_command_html('#ajax_selected_case_study', _case_study_details($case_study_project_default_value));
+		$form['case_study_actions']['#options'] = _bulk_list_case_study_actions();
+		$commands[] = ajax_command_replace('#ajax_selected_case_study_action', drupal_render($form['case_study_actions']));
+	} //$case_study_project_default_value != 0
+	else
+	{
+		$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_project']);
+	}
+	return array(
+		'#type' => 'ajax',
+		'#commands' => $commands
+	);
+}
+/************************************************************/
+function cfd_case_study_abstract_bulk_approval_form_submit($form, &$form_state)
+{
+	global $user;
+	$msg = '';
+	$root_path = cfd_case_study_path();
+	//var_dump($root_path);die;
+	if ($form_state['clicked_button']['#value'] == 'Submit')
+	{
+		if ($form_state['values']['case_study_project'])
+			//var_dump($form_state['values']['case_study_actions']);die;
+		// case_study_abstract_del_lab_pdf($form_state['values']['case_study_project']);
+			if (user_access('Case Study bulk manage abstract'))
+			{
+				$query = db_select('case_study_proposal');
+				$query->fields('case_study_proposal');
+				$query->condition('id', $form_state['values']['case_study_project']);
+				$user_query = $query->execute();
+				$user_info = $user_query->fetchObject();
+				//var_dump($user_info);die;
+				$user_data = user_load($user_info->uid);
+				if ($form_state['values']['case_study_actions'] == 1)
+				{
+					// approving entire project //
+					$query = db_select('case_study_submitted_abstracts');
+					$query->fields('case_study_submitted_abstracts');
+					$query->condition('proposal_id', $form_state['values']['case_study_project']);
+					$abstracts_q = $query->execute();
+					//var_dump($abstracts_q);die;
+					$experiment_list = '';
+					while ($abstract_data = $abstracts_q->fetchObject())
+					{
+						db_query("UPDATE {case_study_submitted_abstracts} SET abstract_approval_status = 1, is_submitted = 1, approver_uid = :approver_uid WHERE id = :id", array(
+							':approver_uid' => $user->uid,
+							':id' => $abstract_data->id
+						));
+						db_query("UPDATE {case_study_submitted_abstracts_file} SET file_approval_status = 1, approvar_uid = :approver_uid WHERE submitted_abstract_id = :submitted_abstract_id", array(
+							':approver_uid' => $user->uid,
+							':submitted_abstract_id' => $abstract_data->id
+						));
+					} //$abstract_data = $abstracts_q->fetchObject()
+					drupal_set_message(t('Approved case study project.'), 'status');
+					// email 
+					$email_subject = t('[!site_name][case study Project] Your uploaded case study project have been approved', array(
+						'!site_name' => variable_get('site_name', '')
+					));
+					$email_body = array(
+						0 => t('
+
+Dear !user_name,
+
+Your uploaded abstract for the case study project has been approved:
+
+Title of case study project  : ' . $user_info->project_title . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+							'!site_name' => variable_get('site_name', ''),
+							'!user_name' => $user_data->name
+						))
+					);
+					/** sending email when everything done **/
+					$email_to = $user_data->mail;
+					$from = variable_get('case_study_from_email', '');
+					$bcc = variable_get('case_study_emails', '');
+					$cc = variable_get('case_study_cc_emails', '');
+					$params['standard']['subject'] = $email_subject;
+					$params['standard']['body'] = $email_body;
+					$params['standard']['headers'] = array(
+						'From' => $from,
+						'MIME-Version' => '1.0',
+						'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
+						'Content-Transfer-Encoding' => '8Bit',
+						'X-Mailer' => 'Drupal',
+						'Cc' => $cc,
+						'Bcc' => $bcc
+					);
+					if (!drupal_mail('case_study', 'standard', $email_to, language_default(), $params, $from, TRUE))
+					{
+						$msg = drupal_set_message('Error sending email message.', 'error');
+					} //!drupal_mail('case_study', 'standard', $email_to, language_default(), $params, $from, TRUE)
+				} //$form_state['values']['case_study_actions'] == 1
+				elseif ($form_state['values']['case_study_actions'] == 2)
+				{
+					//pending review entire project 
+					$query = db_select('case_study_submitted_abstracts');
+					$query->fields('case_study_submitted_abstracts');
+					$query->condition('proposal_id', $form_state['values']['case_study_project']);
+					$abstracts_q = $query->execute();
+					$experiment_list = '';
+					while ($abstract_data = $abstracts_q->fetchObject())
+					{
+						db_query("UPDATE {case_study_submitted_abstracts} SET abstract_approval_status = 0, is_submitted = 0, approver_uid = :approver_uid WHERE id = :id", array(
+							':approver_uid' => $user->uid,
+							':id' => $abstract_data->id
+						));
+						db_query("UPDATE {case_study_proposal} SET is_submitted = 0, approver_uid = :approver_uid WHERE id = :id", array(
+							':approver_uid' => $user->uid,
+							':id' => $abstract_data->proposal_id
+						));
+						db_query("UPDATE {case_study_submitted_abstracts_file} SET file_approval_status = 0, approvar_uid = :approver_uid WHERE submitted_abstract_id = :submitted_abstract_id", array(
+							':approver_uid' => $user->uid,
+							':submitted_abstract_id' => $abstract_data->id
+						));
+					} //$abstract_data = $abstracts_q->fetchObject()
+					drupal_set_message(t('Resubmit the project files'), 'status');
+					// email 
+					$email_subject = t('[!site_name][case study Project] Your uploaded case study project have been marked as pending', array(
+						'!site_name' => variable_get('site_name', '')
+					));
+					$email_body = array(
+						0 => t('
+
+Dear !user_name,
+
+Kindly resubmit the project files for the project : ' . $user_info->project_title . '.
+ 
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+							'!site_name' => variable_get('site_name', ''),
+							'!user_name' => $user_data->name
+						))
+					);
+					/** sending email when everything done **/
+					$email_to = $user_data->mail;
+					$from = variable_get('case_study_from_email', '');
+					$bcc = variable_get('case_study_emails', '');
+					$cc = variable_get('case_study_cc_emails', '');
+					$params['standard']['subject'] = $email_subject;
+					$params['standard']['body'] = $email_body;
+					$params['standard']['headers'] = array(
+						'From' => $from,
+						'MIME-Version' => '1.0',
+						'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
+						'Content-Transfer-Encoding' => '8Bit',
+						'X-Mailer' => 'Drupal',
+						'Cc' => $cc,
+						'Bcc' => $bcc
+					);
+					if (!drupal_mail('case_study', 'standard', $email_to, language_default(), $params, $from, TRUE))
+					{
+						drupal_set_message('Error sending email message.', 'error');
+					} //!drupal_mail('case_study', 'standard', $email_to, language_default(), $params, $from, TRUE)
+				} //$form_state['values']['case_study_actions'] == 2
+				elseif ($form_state['values']['case_study_actions'] == 3) //disapprove and delete entire case study project
+				{
+					if (strlen(trim($form_state['values']['message'])) <= 30)
+					{
+						form_set_error('message', t(''));
+						$msg = drupal_set_message("Please mention the reason for disapproval. Minimum 30 character required", 'error');
+						return $msg;
+					} //strlen(trim($form_state['values']['message'])) <= 30
+					if (!user_access('Case Study bulk delete abstract'))
+					{
+						$msg = drupal_set_message(t('You do not have permission to Bulk Dis-Approved and Deleted Entire Lab.'), 'error');
+						return $msg;
+					} //!user_access('case_study bulk delete code')
+					if (case_study_abstract_delete_project($form_state['values']['case_study_project'])) //////
+					{
+						drupal_set_message(t('Dis-Approved and Deleted Entire case study project.'), 'status');
+						$email_subject = t('[!site_name][case study Project] Your uploaded case study project have been marked as dis-approved', array(
+						'!site_name' => variable_get('site_name', '')
+					));
+					$email_body = array(
+						0 => t('
+
+					Dear !user_name,
+
+					Your uploaded case study project files for the case study project Title : ' . $user_info->project_title . ' have been marked as dis-approved.
+
+					Reason for dis-approval: ' . $form_state['values']['message'] . '
+
+					Best Wishes,
+
+					!site_name Team,
+					FOSSEE,IIT Bombay', array(
+												'!site_name' => variable_get('site_name', ''),
+												'!user_name' => $user_data->name
+											))
+					);
+					$email_to = $user_data->mail;
+					$from = variable_get('case_study_from_email', '');
+					$bcc = variable_get('case_study_emails', '');
+					$cc = variable_get('case_study_cc_emails', '');
+					$params['standard']['subject'] = $email_subject;
+					$params['standard']['body'] = $email_body;
+					$params['standard']['headers'] = array(
+						'From' => $from,
+						'MIME-Version' => '1.0',
+						'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
+						'Content-Transfer-Encoding' => '8Bit',
+						'X-Mailer' => 'Drupal',
+						'Cc' => $cc,
+						'Bcc' => $bcc
+					);
+					if (!drupal_mail('case_study', 'standard', $email_to, language_default(), $params, $from, TRUE))
+					{
+						drupal_set_message('Error sending email message.', 'error');
+					}
+					} //case_study_abstract_delete_project($form_state['values']['case_study_project'])
+					else
+					{
+						drupal_set_message(t('Error Dis-Approving and Deleting Entire case study project.'), 'error');
+					}
+					// email 
+					
+				} //$form_state['values']['case_study_actions'] == 3
+				
+			} //user_access('case_study project bulk manage code')
+		return $msg;
+	} //$form_state['clicked_button']['#value'] == 'Submit'
+}
+/**********************************************************/
+function _bulk_list_of_case_study_project()
+{
+	$project_titles = array(
+		'0' => 'Please select...'
+	);
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('is_submitted', 1);
+	$query->condition('approval_status', 1);
+	$query->orderBy('project_title', 'ASC');
+	$project_titles_q = $query->execute();
+	while ($project_titles_data = $project_titles_q->fetchObject())
+	{
+		$project_titles[$project_titles_data->id] = $project_titles_data->project_title . ' (Proposed by ' . $project_titles_data->contributor_name . ')';
+	} //$project_titles_data = $project_titles_q->fetchObject()
+	return $project_titles;
+}
+function _bulk_list_case_study_actions()
+{
+	$case_study_actions = array(
+		0 => 'Please select...'
+	);
+	$case_study_actions[1] = 'Approve Entire case study Project';
+	$case_study_actions[2] = 'Resubmit Project files';
+	$case_study_actions[3] = 'Dis-Approve Entire case study Project (This will delete case study Project)';
+	//$case_study_actions[4] = 'Delete Entire case study Project Including Proposal';
+	return $case_study_actions;
+}
+function _case_study_details($case_study_proposal_id)
+{
+	$return_html = "";
+	$query_pro = db_select('case_study_proposal');
+	$query_pro->fields('case_study_proposal');
+	$query_pro->condition('id', $case_study_proposal_id);
+	$abstracts_pro = $query_pro->execute()->fetchObject();
+	//var_dump($abstracts_pro);die;
+	$query_pdf = db_select('case_study_submitted_abstracts_file');
+	$query_pdf->fields('case_study_submitted_abstracts_file');
+	$query_pdf->condition('proposal_id', $case_study_proposal_id);
+	$query_pdf->condition('filetype', 'A');
+	$abstracts_pdf = $query_pdf->execute()->fetchObject();
+	if ($abstracts_pdf == TRUE)
+	{
+		if ($abstracts_pdf->filename != "NULL" || $abstracts_pdf->filename != "")
+		{
+			$abstract_filename = $abstracts_pdf->filename;
+		} //$abstracts_pdf->filename != "NULL" || $abstracts_pdf->filename != ""
+		else
+		{
+			$abstract_filename = "File not uploaded";
+		}
+	} //$abstracts_pdf == TRUE
+	else
+	{
+		$abstract_filename = "File not uploaded";
+	}
+	$query_process = db_select('case_study_submitted_abstracts_file');
+	$query_process->fields('case_study_submitted_abstracts_file');
+	$query_process->condition('proposal_id', $case_study_proposal_id);
+	$query_process->condition('filetype', 'S');
+	$abstracts_query_process = $query_process->execute()->fetchObject();
+	$query = db_select('case_study_submitted_abstracts');
+	$query->fields('case_study_submitted_abstracts');
+	$query->condition('proposal_id', $case_study_proposal_id);
+	$abstracts_q = $query->execute()->fetchObject();
+	if ($abstracts_q)
+	{
+		if ($abstracts_q->is_submitted == 0)
+		{
+			//drupal_set_message(t('Abstract is not submmited yet.'), 'error', $repeat = FALSE);
+			//return;
+		} //$abstracts_q->is_submitted == 0
+	} //$abstracts_q
+	//var_dump($abstracts_query_process);die;
+	if ($abstracts_query_process == TRUE)
+	{
+		if ($abstracts_query_process->filename != "NULL" || $abstracts_query_process->filename != "")
+		{
+			$abstracts_query_process_filename = $abstracts_query_process->filename;
+		} //$abstracts_query_process->filename != "NULL" || $abstracts_query_process->filename != ""
+		else
+		{
+			$abstracts_query_process_filename = "File not uploaded";
+		}
+	} //$abstracts_query_process == TRUE
+	else
+	{
+		$url = l('Upload abstract', 'case-study-project/abstract-code/upload');
+		$abstracts_query_process_filename = "File not uploaded";
+	}
+	$download_case_study = l('Download case study project','case-study-project/full-download/project/'.$case_study_proposal_id);
+	$return_html .= '<strong>Proposer Name:</strong><br />' . $abstracts_pro->name_title . ' ' . $abstracts_pro->contributor_name . '<br /><br />';
+	$return_html .= '<strong>Title of the case study Project:</strong><br />' . $abstracts_pro->project_title . '<br /><br />';
+	$return_html .= '<strong>Uploaded an abstract (brief outline) of the project:</strong><br />' . $abstract_filename . '<br /><br />';
+	$return_html .= '<strong>Upload the eSim circuit simulation for the developed process:</strong><br />' . $abstracts_query_process_filename . '<br /><br />';
+	$return_html .= $download_case_study;
+	return $return_html;
+}
diff --git a/cfd_case_study.info b/cfd_case_study.info
new file mode 100755
index 0000000..4cd305c
--- /dev/null
+++ b/cfd_case_study.info
@@ -0,0 +1,7 @@
+name = "CFD Case Study"
+description = "CFD Case Study Project, FOSSEE, IIT Bombay"
+package = FOSSEE
+version = "7.x"
+core = "7.x"
+
+;scripts[] = js/jquery-1.4.1.min.js
diff --git a/cfd_case_study.module b/cfd_case_study.module
new file mode 100755
index 0000000..86f84b7
--- /dev/null
+++ b/cfd_case_study.module
@@ -0,0 +1,837 @@
+<?php
+// $Id$
+require_once('general_deletion.inc');
+require_once('email.inc');
+/**
+ * Implementation of hook_menu().
+ */
+function cfd_case_study_menu()
+{
+	$items = array();
+	/* PROPOSAL */
+	$items['case-study-project/proposal'] = array(
+		'title'=> 'Case Study Proposal Form',
+		'description'=> 'Case Study Proposal Form',
+		'page callback'=> 'drupal_get_form',
+		'page arguments'=> array(
+			'cfd_case_study_proposal_form'
+		),
+		'access arguments'=> array(
+			'Case Study create proposal'
+		),
+		'type'=> MENU_NORMAL_ITEM,
+		'file'=> 'proposal.inc'
+	);
+	$items['case-study-project/manage-proposal'] = array(
+		'title'=> 'Manage Case Study Proposals',
+		'description'=> 'Manage Case StudyProposals',
+		'page callback'=> 'cfd_case_study_proposal_pending',
+		'access callback'=> 'user_access',
+		'access arguments'=> array(
+			'Case Study manage proposal'
+		),
+		'file'=> 'manage_proposal.inc'
+	);
+	$items['case-study-project/manage-proposal/pending'] = array(
+		'title'=> 'Pending Proposals',
+		'description'=> 'Pending  Case Study Proposals Queue',
+		'page callback'=> 'cfd_case_study_proposal_pending',
+		'access callback'=> 'user_access',
+		'access arguments'=> array(
+			'Case Study manage proposal'
+		),
+		'type'=> MENU_DEFAULT_LOCAL_TASK,
+		'weight'=> 1,
+		'file'=> 'manage_proposal.inc'
+	);
+	$items['case-study-project/manage-proposal/all'] = array(
+		'title'=> 'All Proposals',
+		'description'=> 'All Proposals',
+		'page callback'=> 'cfd_case_study_proposal_all',
+		'access callback'=> 'user_access',
+		'access arguments'=> array(
+			'Case Study manage proposal'
+		),
+		'type'=> MENU_LOCAL_TASK,
+		'weight'=> 4,
+		'file'=> 'manage_proposal.inc'
+	);
+	$items['case-study-project/manage-proposal/approve'] = array(
+		'title'=> 'Approve Proposal',
+		'description'=> 'Approve Proposal',
+		'page callback'=> 'drupal_get_form',
+		'page arguments'=> array(
+			'cfd_case_study_proposal_approval_form'
+		),
+		'access arguments'=> array(
+			'Case Study manage proposal'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'manage_proposal.inc'
+	);
+	$items['case-study-project/manage-proposal/solution-proposal-approve'] = array(
+		'title'=> 'Approve Solution Proposal',
+		'description'=> 'Approve Solution Proposal',
+		'page callback'=> 'drupal_get_form',
+		'page arguments'=> array(
+			'cfd_case_study_solution_proposal_approval_form'
+		),
+		'access arguments'=> array(
+			'Case Study manage proposal'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'manage_solution_proposal.inc'
+	);
+	$items['case-study-project/manage-proposal/edit'] = array(
+		'title'=> 'Edit Proposal',
+		'description'=> 'Edit Proposal',
+		'page callback'=> 'drupal_get_form',
+		'page arguments'=> array(
+			'cfd_case_study_proposal_edit_form'
+		),
+		'access arguments'=> array(
+			'Case Study manage proposal'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'manage_proposal.inc'
+	);
+	$items['case-study-project/manage-proposal/status'] = array(
+		'title'=> 'Proposal Status',
+		'description'=> 'Proposal Status',
+		'page callback'=> 'drupal_get_form',
+		'page arguments'=> array(
+			'cfd_case_study_proposal_status_form'
+		),
+		'access arguments'=> array(
+			'Case Study approve proposal'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'manage_proposal.inc'
+	);
+	/*$items['case-study-project/show-proposal'] = array(
+		'title'=> 'Case Study Solution Proposal',
+		'page callback'=> 'drupal_get_form',
+		'page arguments'=> array(
+			'cfd_case_study_solution_proposal_form'
+		),
+		'access arguments'=> array(
+			'Case Study propose solution'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'solution_proposal.inc'
+	);*/
+	/* CODE REVIEW */
+	/*$items['case-study-project/code-approval'] = array(
+		'title'=> 'LM Manage Code Approval',
+		'description'=> 'Manage Code Approval',
+		'page callback'=> 'cfd_case_study_code_approval',
+		'access arguments'=> array(
+			'Case Study approve code'
+		),
+		'type'=> MENU_NORMAL_ITEM,
+		'file'=> 'code_approval.inc'
+	);
+	$items['case-study-project/abstract-approval/approve'] = array(
+		'title'=> 'Code Approval',
+		'description'=> 'Code Approval',
+		'page callback'=> 'drupal_get_form',
+		'page arguments'=> array(
+			'cfd_case_study_abstract_approval_form'
+		),
+		'access arguments'=> array(
+			'Case Study approve code'
+		),
+		'type'=> MENU_DEFAULT_LOCAL_TASK,
+		'weight'=> 1,
+		'file'=> 'code_approval.inc'
+	);*/
+	$items['case-study-project/abstract-approval/bulk'] = array(
+		'title'=> 'Bulk Manage',
+		'description'=> 'Bulk Mangage',
+		'page callback'=> 'drupal_get_form',
+		'page arguments'=> array(
+			'cfd_case_study_abstract_bulk_approval_form'
+		),
+		'access arguments'=> array(
+			'Case Study bulk manage abstract'
+		),
+		'type'=> MENU_LOCAL_TASK,
+		'weight'=> 2,
+		'file'=> 'abstract_bulk_approval.inc'
+	);
+	$items['case-study-project/code-approval/bulk'] = array(
+		'title'=> 'Bulk Manage',
+		'description'=> 'Bulk Mangage',
+		'page callback'=> 'drupal_get_form',
+		'page arguments'=> array(
+			'cfd_case_study_bulk_approval_form'
+		),
+		'access arguments'=> array(
+			'Case Study bulk manage abstract'
+		),
+		'type'=> MENU_LOCAL_TASK,
+		'weight'=> 2,
+		'file'=> 'bulk_approval.inc'
+	);
+	/*$items['cfd_case_study/code_approval/dependency'] = array(
+	'title'=> 'Dependency',
+	'description'=> 'Dependency Mangage',
+	'page callback'=> 'drupal_get_form',
+	'page arguments'=> array('cfd_case_study_dependency_approval_form'),
+	'access arguments'=> array('Case Study bulk manage abstract'),
+	'type'=> MENU_LOCAL_TASK,
+	'weight'=> 3,
+	'file'=> 'dependency_approval.inc',
+	);*/
+	$items['case-study-project/code-approval/upload'] = array(
+		'title'=> 'Upload Code',
+		'description'=> 'Admin Upload',
+		'page callback'=> 'drupal_get_form',
+		'page arguments'=> array(
+			'cfd_case_study_bulk_upload_code_form'
+		),
+		'access arguments'=> array(
+			'Case Study bulk manage abstract'
+		),
+		'type'=> MENU_CALLBACK,
+		'weight'=> 4,
+		'file'=> 'bulk_upload_code.inc'
+	);
+	$items['case-study-project/code-approval/notes'] = array(
+		'title'=> 'Notes for Reviewers',
+		'description'=> 'Notes for Reviewers',
+		'page callback'=> 'drupal_get_form',
+		'page arguments'=> array(
+			'cfd_case_study_lab_notes_form'
+		),
+		'access arguments'=> array(
+			'Case Study bulk manage abstract'
+		),
+		'type'=> MENU_CALLBACK,
+		'weight'=> 4,
+		'file'=> 'notes.inc'
+	);
+	/* CODE UPLOAD */
+	/* CODE UPLOAD */
+	$items['case-study-project/abstract-code'] = array(
+		'title'=> 'Abstract and Project Files Upload',
+		'description'=> 'Abstract Submission',
+		'page callback'=> 'cfd_case_study_abstract',
+		'access callback'=> 'user_access',
+		'access arguments'=> array(
+			'Case Study upload abstract'
+		),
+		'file'=> 'upload_code.inc'
+	);
+	$items['case-study-project/abstract-code/case-study-project-list'] = array(
+		'title'=> 'Case Study',
+		'description'=> 'List Experiments',
+		'page callback'=> 'cfd_case_study_abstract',
+		'access arguments'=> array(
+			'Case Study upload abstract'
+		),
+		'type'=> MENU_DEFAULT_LOCAL_TASK,
+		'file'=> 'upload_code.inc',
+		'weight'=> 1
+	);
+	$items['case-study-project/abstract-code/upload'] = array(
+		'title'=> 'Abstract and Project Upload',
+		'description'=> 'Project Upload',
+		'page callback'=> 'drupal_get_form',
+		'access callback'=> 'user_access',
+		'page arguments'=> array(
+			'cfd_case_study_upload_abstract_code_form'
+		),
+		'access arguments'=> array(
+			'Case Study upload abstract'
+		),
+		'type'=> MENU_LOCAL_TASK,
+		'file'=> 'upload_code.inc',
+		'weight'=> 2
+	);
+	$items['case-study-project/abstract-code/delete'] = array(
+		'title'=> 'Delete Solution',
+		'description'=> 'Delete Solution',
+		'page callback'=> 'cfd_case_study_upload_code_delete',
+		'access arguments'=> array(
+			'Case Study upload code'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'upload_code_delete.inc'
+	);
+	/* CODE DOWNLOADS */
+	$items['case-study-project/download/file'] = array(
+		'title'=> 'Code Download',
+		'description'=> 'Code Download',
+		'page callback'=> 'cfd_case_study_download_solution_file',
+		'access arguments'=> array(
+			'Case Study download code'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'download.inc'
+	);
+	$items['case-study-project/download/solution'] = array(
+		'title'=> 'Code Download',
+		'description'=> 'Code Download',
+		'page callback'=> 'cfd_case_study_download_solution',
+		'access arguments'=> array(
+			'Case Study download code'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'download.inc'
+	);
+	$items['case-study-project/download/experiment'] = array(
+		'title'=> 'Code Download',
+		'description'=> 'Code Download',
+		'page callback'=> 'cfd_case_study_download_experiment',
+		'access arguments'=> array(
+			'Case Study download code'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'download.inc'
+	);
+	$items['case-study-project/download/lab'] = array(
+		'title'=> 'Code Download',
+		'description'=> 'Code Download',
+		'page callback'=> 'cfd_case_study_download_lab',
+		'access arguments'=> array(
+			'Case Study download code'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'download.inc'
+	);
+	$items['case-study-project/full-download/experiment'] = array(
+		'title'=> 'Code Download',
+		'description'=> 'Code Download',
+		'page callback'=> 'cfd_case_study_download_completed_project',
+		'access arguments'=> array(
+			'Case Study approve code'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'full_download.inc'
+	);
+	$items['case-study-project/full-download/project'] = array(
+		'title'=> 'Code Download',
+		'description'=> 'Code Download',
+		'page callback'=> 'cfd_case_study_download_full_project',
+		'access arguments'=> array(
+			'Case Study download code'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'full_download.inc'
+	);
+	/* COMPLETED  Case studies */
+	$items['case-study-project/completed-case-studies'] = array(
+		'title'=> 'Completed Case studies',
+		'page callback'=> 'cfd_case_study_completed_proposals_all',
+		'access arguments'=> array(
+			'Case Study download code'
+		),
+		'file'=> 'cfd_case_study_details.inc'
+	);
+	/* LABS IN PROGRESS */
+	$items['case-study-project/case-study-progress'] = array(
+		'title'=> 'Case studies in Progress',
+		'page callback'=> 'cfd_case_study_progress_all',
+		'access arguments'=> array(
+			'Case Study download code'
+		),
+		'file'=> 'cfd_case_study_details.inc'
+	);
+	/* DOWNLOAD FOR EVERYONE */
+	$items['case-study-project/case-study-run'] = array(
+		'title'=> 'Download Codes',
+		'page callback'=> 'drupal_get_form',
+		'page arguments'=> array(
+			'cfd_case_study_run_form'
+		),
+		'access arguments'=> array(
+			'Case Study download code'
+		),
+		'type'=> MENU_NORMAL_ITEM,
+		'file'=> 'run.inc'
+	);
+	$items['case-study-project/download/resource-file'] = array(
+		'title'=> 'Download user defined compound file',
+		'description'=> 'Download resource file',
+		'page callback'=> 'cfd_case_study_download_upload_file',
+		'access arguments'=> array(
+			'download code'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'download.inc'
+	);
+	$items['case-study-project/download/project-file'] = array(
+		'title'=> 'Download Project file',
+		'description'=> 'Download project file',
+		'page callback'=> 'cfd_case_study_project_files',
+		'access arguments'=> array(
+			'download code'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'download.inc'
+	);
+	/* LATEX SCRIPT */
+	$items['case-study-project/generate-lab'] = array(
+		'title'=> 'Generate Lab',
+		'description'=> 'Generate Lab From Latex Script',
+		'page callback'=> 'cfd_case_study_download_lab_pdf',
+		'access arguments'=> array(
+			'Case Study generate lab'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'latex.inc'
+	);
+	$items['case-study-project/delete-lab'] = array(
+		'title'=> 'Delete Lab PDF',
+		'description'=> 'Delete Lab PDF',
+		'page callback'=> 'cfd_case_study_delete_lab_pdf',
+		'access arguments'=> array(
+			'Case Study approve code'
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'latex.inc'
+	);
+	/* ADMIN SETTINGS */
+	$items['admin/settings/case-study'] = array(
+		'title'=> 'Case Study Settings',
+		'description'=> 'Case Study Settings',
+		'page callback'=> 'drupal_get_form',
+		'page arguments'=> array(
+			'cfd_case_study_settings_form'
+		),
+		'access arguments'=> array(
+			'administer  Case Study'
+		),
+		'type'=> MENU_NORMAL_ITEM,
+		'file'=> 'settings.inc'
+	);
+	/* AJAX REQUEST */
+	$items["lab-bulk-manage-exp/ajax"] = array(
+		"title" => "Ajax callbacks",
+		"page callback" => "lab_bulk_manage_exp_ajax",
+		"access arguments" => array(
+			" Case Study bulk manage abstract"
+		),
+		"type" => MENU_CALLBACK,
+		'file'=> 'bulk_approval.inc'
+	);
+	$items['case-study-project/certificates'] = array(
+		'title'=> 'List of Case Study Certificates',
+		'description'=> 'List of Case Study Certificates',
+		'page callback'=> '_list_cfd_case_study_certificates',
+		'access arguments'=> array(
+			'list Case Study certificates'
+		),
+		'file'=> 'pdf/list_cfd_case_study_certificate.inc'
+	);
+	$items['case-study-project/certificates/generate-pdf'] = array(
+		'title'=> 'Download Certificate',
+		'description'=> 'Download Certificate',
+		'page callback'=> 'drupal_get_form',
+		'page arguments'=> array(
+			'generate_pdf'
+		),
+		'type'=> MENU_CALLBACK,
+		'access arguments'=> array(
+			'generate pdf'
+		),
+		'file'=> 'pdf/cert_new.inc'
+	);
+	$items['case-study-project/certificates-custom'] = array(
+		'title'=> 'List of Case Study Custom Certificates',
+		'description'=> 'List of Case Study Custom Certificates',
+		'page callback'=> '_list_cfd_case_study_custom_certificates',
+		'access arguments'=> array(
+			'list Case Study custom certificates'
+		),
+		'file'=> 'pdf/list_mentor_certificates.inc'
+	);
+	$items['case-study-project/certificates-custom/pdf'] = array(
+		'title'=> 'Download Certificate',
+		'description'=> 'Download Certificate',
+		'page callback'=> 'drupal_get_form',
+		'page arguments'=> array(
+			'generate_pdf'
+		),
+		'type'=> MENU_CALLBACK,
+		'access arguments'=> array(
+			'generate pdf'
+		),
+		'file'=> 'pdf/mentor_cert_pdf.inc'
+	);
+	$items['case-study-project/certificates/verify'] = array(
+		"title" => "Certificate Verification",
+		"page callback" => "verify_certificates",
+'page arguments'=> array(
+			'verify_certificates'
+		),
+		"access arguments" => array(
+			"verify certificates"
+		),
+		'type'=> MENU_CALLBACK,
+		'file'=> 'pdf/verify_certificates.inc'
+	);
+	return $items;
+}
+/**
+ * Implementation of hook_perm().
+ */
+function cfd_case_study_permission()
+{
+	return array(
+		'Case Study create proposal'=> array(
+			'title'=> t('Case Study create proposal'),
+			'restrict access'=> TRUE
+		),
+		'Case Study manage proposal'=> array(
+			'title'=> t('Case Study manage proposal'),
+			'restrict access'=> TRUE
+		),
+		'Case Study edit proposal'=> array(
+			'title'=> t('Case Study edit proposal'),
+			'restrict access'=> TRUE
+		),
+		'Case Study approve proposal'=> array(
+			'title'=> t('Case Study approve proposal'),
+			'restrict access'=> TRUE
+		),
+		'Case Study propose solution'=> array(
+			'title'=> t('Case Study propose solution'),
+			'restrict access'=> TRUE
+		),
+		'Case Study approve abstract'=> array(
+			'title'=> t('Case Study approve code'),
+			'restrict access'=> TRUE
+		),
+		'Case Study bulk manage abstract'=> array(
+			'title'=> t('Case Study bulk manage abstract'),
+			'restrict access'=> TRUE
+		),
+		'Case Study bulk delete abstract'=> array(
+			'title'=> t('Case Study bulk delete code'),
+			'restrict access'=> TRUE
+		),
+		'Case Study upload abstract'=> array(
+			'title'=> t('Case Study upload code'),
+			'restrict access'=> TRUE
+		),
+		'Case Study download code'=> array(
+			'title'=> t('Case Study download code'),
+			'restrict access'=> TRUE
+		),
+		'administer  Case Study'=> array(
+			'title'=> t('administer  Case Study'),
+			'restrict access'=> TRUE
+		),
+		'Case Study generate abstract'=> array(
+			'title'=> t('Case Study generate abstract'),
+			'restrict access'=> TRUE
+		),
+		"list Case Study certificates" => array(
+			"title" => t("list the certificates"),
+			"description" => t("list the certificates"),
+			'restrict access'=> TRUE
+		),
+		"list Case Study custom certificates" => array(
+			"title" => t("list the mentor certificates"),
+			"description" => t("list the mentor certificates"),
+			'restrict access'=> TRUE
+		),
+		"verify certificates" => array(
+			"title" => t("verify the certificates"),
+			"description" => t("verify the certificates"),
+			'restrict access'=> TRUE
+		)
+
+	);
+}
+/*************************** VALIDATION FUNCTIONS *****************************/
+function cfd_case_study_check_valid_filename($file_name)
+{
+	if (!preg_match('/^[0-9a-zA-Z\.\_]+$/', $file_name))
+		return FALSE;
+	else if (substr_count($file_name, ".") > 1)
+		return FALSE;
+	else
+		return TRUE;
+}
+function cfd_case_study_check_name($name = '')
+{
+	if (!preg_match('/^[0-9a-zA-Z\ ]+$/', $name))
+		return FALSE;
+	else
+		return TRUE;
+}
+function cfd_case_study_check_code_number($number = '')
+{
+	if (!preg_match('/^[0-9]+$/', $number))
+		return FALSE;
+	else
+		return TRUE;
+}
+function cfd_case_study_path()
+{
+	return $_SERVER['DOCUMENT_ROOT'] . base_path() . 'uploads/case_study_uploads/';
+}
+function cfd_case_study_file_path($value='')
+{
+	return $_SERVER['DOCUMENT_ROOT'] . base_path() . 'uploads/';
+}
+/************************* USER VERIFICATION FUNCTIONS ************************/
+function cfd_case_study_get_proposal()
+{
+	global $user;
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('uid', $user->uid);
+	$query->orderBy('id', 'DESC');
+	$query->range(0, 1);
+	$proposal_q = $query->execute();
+	$proposal_data = $proposal_q->fetchObject();
+	if (!$proposal_data)
+	{
+		drupal_set_message("You do not have any approved  Case Study proposal. Please propose the Case Study proposal", 'error');
+		drupal_goto('');
+	} //!$proposal_data
+	switch ($proposal_data->approval_status)
+	{
+		case 0:
+			drupal_set_message(t('Proposal is awaiting approval.'), 'status');
+			return FALSE;
+		case 1:
+			return $proposal_data;
+		case 2:
+			drupal_set_message(t('Proposal has been dis-approved.'), 'error');
+			return FALSE;
+		case 3:
+			drupal_set_message(t('Proposal has been marked as completed.'), 'status');
+			return FALSE;
+		default:
+			drupal_set_message(t('Invalid proposal state. Please contact site administrator for further information.'), 'error');
+			return FALSE;
+	} //$proposal_data->approval_status
+	return FALSE;
+}
+/*************************************************************************/
+/***** Function To convert only first charater of string in uppercase ****/
+/*************************************************************************/
+/*function ucname($string)
+{
+	$string = ucwords(strtolower($string));
+	foreach (array(
+		'-',
+		'\''
+	) as $delimiter)
+	{
+		if (strpos($string, $delimiter) !== false)
+		{
+			$string = implode($delimiter, array_map('ucfirst', explode($delimiter, $string)));
+		} //strpos($string, $delimiter) !== false
+	} //array( '-', '\'') as $delimiter
+	return $string;
+}*/
+function _df_sentence_case($string)
+{
+	$string = ucwords(strtolower($string));
+	foreach (array(
+		'-',
+		'\''
+	) as $delimiter)
+	{
+		if (strpos($string, $delimiter) !== false)
+		{
+			$string = implode($delimiter, array_map('ucfirst', explode($delimiter, $string)));
+		} //strpos($string, $delimiter) !== false
+	} //array( '-', '\'') as $delimiter
+	return $string;
+}
+function _df_list_of_states()
+{
+	$states = array(
+		0 => '-Select-'
+	);
+	$query = db_select('list_states_of_india');
+	$query->fields('list_states_of_india');
+	//$query->orderBy('', '');
+	$states_list = $query->execute();
+	while ($states_list_data = $states_list->fetchObject())
+	{
+		$states[$states_list_data->state] = $states_list_data->state;
+	} //$states_list_data = $states_list->fetchObject()
+	return $states;
+}
+function _df_list_of_cities()
+{
+	$city = array(
+		0 => '-Select-'
+	);
+	$query = db_select('list_cities_of_india');
+	$query->fields('list_cities_of_india');
+	$query->orderBy('city', 'ASC');
+	$city_list = $query->execute();
+	while ($city_list_data = $city_list->fetchObject())
+	{
+		$city[$city_list_data->city] = $city_list_data->city;
+	} //$city_list_data = $city_list->fetchObject()
+	return $city;
+}
+function _df_list_of_pincodes()
+{
+	$pincode = array(
+		0 => '-Select-'
+	);
+	$query = db_select('list_of_all_india_pincode');
+	$query->fields('list_of_all_india_pincode');
+	$query->orderBy('pincode', 'ASC');
+	$pincode_list = $query->execute();
+	while ($pincode_list_data = $pincode_list->fetchObject())
+	{
+		$pincode[$pincode_list_data->pincode] = $pincode_list_data->pincode;
+	} //$pincode_list_data = $pincode_list->fetchObject()
+	return $pincode;
+}
+function _df_list_of_departments()
+{
+	$department = array();
+	$query = db_select('list_of_departments');
+	$query->fields('list_of_departments');
+	$query->orderBy('id', 'DESC');
+	$department_list = $query->execute();
+	while ($department_list_data = $department_list->fetchObject())
+	{
+		$department[$department_list_data->department] = $department_list_data->department;
+	} //$department_list_data = $department_list->fetchObject()
+	return $department;
+}
+function _df_dir_name($project, $proposar_name)
+{
+	$project_title = ucname($project);
+	$proposar_name = ucname($proposar_name);
+	$dir_name = $project_title . ' By '. $proposar_name;
+	$directory_name = str_replace("__", "_", str_replace(" ", "_", str_replace("/","_", trim($dir_name))));
+	return $directory_name;
+}
+function cfd_case_study_document_path()
+{
+	return $_SERVER['DOCUMENT_ROOT'] . base_path() . 'uploads/case_study_uploads/';
+}
+function DF_RenameDir($proposal_id, $dir_name)
+{
+	$proposal_id = $proposal_id;
+	$dir_name = $dir_name;
+	$query = db_query("SELECT directory_name,id FROM case_study_proposal WHERE id = :proposal_id", array(
+		':proposal_id'=> $proposal_id
+	));
+	$result = $query->fetchObject();
+	if ($result != NULL)
+	{
+		$files = scandir(cfd_case_study_path());
+		$files_id_dir = cfd_case_study_path() . $result->id;
+		//var_dump($files);die;
+		$file_dir = cfd_case_study_path() . $result->directory_name;
+		if (is_dir($file_dir))
+		{
+			$new_directory_name = rename(cfd_case_study_path() . $result->directory_name, cfd_case_study_path() . $dir_name);
+			return $new_directory_name;
+		} //is_dir($file_dir)
+		else if (is_dir($files_id_dir))
+		{
+			$new_directory_name = rename(cfd_case_study_path() . $result->id, cfd_case_study_path() . $dir_name);
+			return $new_directory_name;
+		} //is_dir($files_id_dir)
+		else
+		{
+			drupal_set_message('Directory not available for rename.');
+			return;
+		}
+	} //$result != NULL
+	else
+	{
+		drupal_set_message('Project directory name not present in databse');
+		return;
+	}
+	return;
+}
+function CreateReadmeFileCaseStudyProject($proposal_id)
+{
+	$result = db_query("
+                        SELECT * from case_study_proposal WHERE id = :proposal_id", array(
+		":proposal_id" => $proposal_id
+	));
+	$proposal_data = $result->fetchObject();
+	$root_path = cfd_case_study_path();
+	$readme_file = fopen($root_path . $proposal_data->directory_name . "/README.txt", "w") or die("Unable to open file!");
+	$txt = "";
+	$txt .= "About the Case Study";
+	$txt .= "\n" . "\n";
+	$txt .= "Title Of The Case Study Project: " . $proposal_data->project_title . "\n";
+	$txt .= "Proposar Name: " . $proposal_data->name_title . " " . $proposal_data->contributor_name . "\n";
+	$txt .= "University: " . $proposal_data->university . "\n";
+	$txt .= "\n" . "\n";
+	$txt .= " Case Study Project By FOSSEE, IIT Bombay" . "\n";
+	fwrite($readme_file, $txt);
+	fclose($readme_file);
+	return $txt;
+}
+function rrmdir_project($prop_id)
+{
+	$proposal_id = $prop_id;
+	$result = db_query("SELECT * from case_study_proposal WHERE id = :proposal_id", array(
+		":proposal_id" => $proposal_id
+	));
+	$proposal_data = $result->fetchObject();
+	$root_path = cfd_case_study_document_path();
+	$dir = $root_path . $proposal_data->directory_name;
+	if ($proposal_data->id == $prop_id)
+	{
+		if (is_dir($dir))
+		{
+			$objects = scandir($dir);
+			foreach ($objects as $object)
+			{
+				if ($object != "." && $object != "..")
+				{
+					if (filetype($dir . "/" . $object) == "dir")
+					{
+						rrmdir($dir . "/" . $object);
+					} //filetype($dir . "/" . $object) == "dir"
+					else
+					{
+						unlink($dir . "/" . $object);
+					}
+				} //$object != "." && $object != ".."
+			} //$objects as $object
+			reset($objects);
+			rmdir($dir);
+			$msg = drupal_set_message("Directory deleted successfully");
+			return $msg;
+		} //is_dir($dir)
+		$msg = drupal_set_message("Directory not present");
+		return $msg;
+	} //$proposal_data->id == $prop_id
+	else
+	{
+		$msg = drupal_set_message("Data not found");
+		return $msg;
+	}
+}
+function rrmdir($dir)
+{
+	if (is_dir($dir))
+	{
+		$objects = scandir($dir);
+		foreach ($objects as $object)
+		{
+			if ($object != "." && $object != "..")
+			{
+				if (filetype($dir . "/" . $object) == "dir")
+					rrmdir($dir . "/" . $object);
+				else
+					unlink($dir . "/" . $object);
+			} //$object != "." && $object != ".."
+		} //$objects as $object
+		reset($objects);
+		rmdir($dir);
+	} //is_dir($dir)
+}
diff --git a/cfd_case_study_details.inc b/cfd_case_study_details.inc
new file mode 100755
index 0000000..7ad9e60
--- /dev/null
+++ b/cfd_case_study_details.inc
@@ -0,0 +1,102 @@
+<?php
+// eSim case study display completed proposals
+function cfd_case_study_completed_proposals_all()
+{
+	$output = "";
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('approval_status', 3);
+	$query->orderBy('actual_completion_date', 'DESC');
+	//$query->condition('is_completed', 1);
+	$result = $query->execute();
+	
+	//var_dump($case_study_abstract);die;
+	if ($result->rowCount() == 0)
+	{
+		$output .= "Work has been completed for the following case study. We welcome your contributions." ."<hr>";
+
+	} //$result->rowCount() == 0
+	else
+	{
+		$output .= "Work has been completed for the following case study. We welcome your contributions." . "<hr>";
+		$preference_rows = array();
+		$i = 1;
+		while ($row = $result->fetchObject())
+		{
+			$proposal_id = $row->id;
+			$query1 = db_select('case_study_submitted_abstracts_file');
+			$query1->fields('case_study_submitted_abstracts_file');
+			$query1->condition('file_approval_status', 1);
+			$query1->condition('proposal_id', $proposal_id);
+			$case_study_files = $query1->execute();
+			$case_study_abstract = $case_study_files->fetchObject();
+			$approval_date = date("Y", $row->approval_date);
+			$preference_rows[] = array(
+				$i,
+				l($row->project_title, "case-study-project/case-study-run/" . $row->id),
+				l('Download', "case-study-project/download/project-file/" . $row->id),
+				$row->contributor_name,
+				$row->university,
+				$approval_date
+			);
+			$i++;
+		} //$row = $result->fetchObject()
+		$preference_header = array(
+			'No',
+			'case study Project',
+			'Abstract File',
+			'Contributor Name',
+			'Institute',
+			'Year'
+		);
+		$output .= theme('table', array(
+			'header' => $preference_header,
+			'rows' => $preference_rows
+		));
+	}
+	return $output;
+}
+// eSim case study display in progress proposals
+function cfd_case_study_progress_all()
+{
+	$page_content = "";
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('approval_status', 1);
+	$query->condition('is_completed', 0);
+	$result = $query->execute();
+	if ($result->rowCount() == 0)
+	{
+		$page_content .= "Work is in progress for the following case study under case study Project<hr>";
+	} //$result->rowCount() == 0
+	else
+	{
+		$page_content .= "Work is in progress for the following case study under case study Project<hr>";
+		$preference_rows = array();
+		$i = 1;
+		while ($row = $result->fetchObject())
+		{
+			$approval_date = date("Y", $row->approval_date);
+			$preference_rows[] = array(
+				$i,
+				$row->project_title,
+				$row->contributor_name,
+				$row->university,
+				$approval_date
+			);
+			$i++;
+		} //$row = $result->fetchObject()
+		$preference_header = array(
+			'No',
+			'case study Project',
+			'Contributor Name',
+			'Institute',
+			'Year'
+		);
+		$page_content .= theme('table', array(
+			'header' => $preference_header,
+			'rows' => $preference_rows
+		));
+	}
+	return $page_content;
+}
diff --git a/download.inc b/download.inc
new file mode 100755
index 0000000..bcbf9ed
--- /dev/null
+++ b/download.inc
@@ -0,0 +1,62 @@
+<?php
+// $Id$
+/*function cfd_case_study_download_upload_file()
+{
+	$proposal_id = arg(3);
+	$root_path = cfd_case_study_path();
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('id', $proposal_id);
+	$query->range(0, 1);
+	$result = $query->execute();
+	$circuit_simulation_upload_file = $result->fetchObject();
+	$samplecodename = substr($circuit_simulation_upload_file->samplefilepath, strrpos($circuit_simulation_upload_file->samplefilepath, '/') + 1);
+			ob_clean();
+            header("Pragma: public");
+            header("Expires: 0");
+            header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
+            header("Cache-Control: public");
+            header("Content-Description: File Transfer");
+            header('Content-Type: application/pdf');
+            header('Content-disposition: attachment; filename="' . $samplecodename . '"');
+            header('Content-Length: ' . filesize($root_path . $circuit_simulation_upload_file->samplefilepath));
+            header("Content-Transfer-Encoding: binary");
+            header('Expires: 0');
+            header('Pragma: no-cache');
+            readfile($root_path . $circuit_simulation_upload_file->samplefilepath);
+	        ob_end_flush();
+           ob_clean();
+           flush();
+}*/
+function cfd_case_study_project_files() {
+	$proposal_id = arg(3);
+	$root_path = cfd_case_study_path();
+	$query = db_select('case_study_submitted_abstracts_file');
+	$query->fields('case_study_submitted_abstracts_file');
+	$query->condition('proposal_id', $proposal_id);
+	$query->condition('filetype', 'A');
+	$result = $query->execute();
+	$cfd_case_study_project_files = $result->fetchObject();
+	$query1 = db_select('case_study_proposal');
+	$query1->fields('case_study_proposal');
+	$query1->condition('id', $proposal_id);
+	$result1 = $query1->execute();
+	$case_study = $result1->fetchObject();
+	$directory_name = $case_study->directory_name . '/';
+	$abstract_file = $cfd_case_study_project_files->filename;
+	ob_clean();
+	header("Pragma: public");
+	header("Expires: 0");
+	header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
+	header("Cache-Control: public");
+	header("Content-Description: File Transfer");
+	header("Content-Type: application/pdf");
+	header('Content-disposition: attachment; filename="' . $abstract_file . '"');
+	header("Content-Length: " . filesize($root_path . $directory_name . $abstract_file));
+	header("Content-Transfer-Encoding: binary");
+	header("Expires: 0");
+	header("Pragma: no-cache");
+	readfile($root_path . $directory_name . $abstract_file);
+	ob_end_flush();
+	ob_clean();
+}
diff --git a/email.inc b/email.inc
new file mode 100755
index 0000000..efa4896
--- /dev/null
+++ b/email.inc
@@ -0,0 +1,269 @@
+<?php
+/**
+ * Implementation of hook_mail().
+ */
+function case_study_mail($key, &$message, $params)
+{
+	global $user;
+	$language = $message['language'];
+	//$language = user_preferred_language($user);
+	switch ($key)
+	{
+		case 'case_study_proposal_received':
+			/* initializing data */
+			$query = db_select('case_study_proposal');
+			$query->fields('case_study_proposal');
+			$query->condition('id', $params['case_study_proposal_received']['result1']);
+			$query->range(0, 1);
+			$proposal_data = $query->execute()->fetchObject();
+			$user = user_load($params['case_study_proposal_received']['user_id']);
+			$message['headers'] = $params['case_study_proposal_received']['headers'];
+			$message['subject'] = t('[!site_name][Case Study Project] Your  Case Study Project proposal has been received', array(
+				'!site_name' => variable_get('site_name', '')
+			), array(
+				'language' => $language->language
+			));
+			$message['body'] = array(
+				'body' => t('
+Dear !user_name,
+
+We have received your  Case Study Project proposal with the following details:
+
+Full Name: ' . $proposal_data->name_title . ' ' . $proposal_data->contributor_name . '
+Email: ' . $user->mail . '
+University/Institute: ' . $proposal_data->university . '
+City: ' . $proposal_data->city . '
+State: ' . $proposal_data->state . '
+Country: ' . $proposal_data->country . '
+Project Title: ' . $proposal_data->project_title . '
+Date of Proposal: ' . date('d/m/Y' , $proposal_data->creation_date) . '
+Expected Date of Completion: ' . date('d/m/Y', $proposal_data->expected_date_of_completion) . '
+
+Your proposal is under review. You will soon receive an email when same has been approved/disapproved.
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+					'!site_name' => variable_get('site_name', ''),
+					'!user_name' => $user->name
+				), array(
+					'language' => $language->language
+				))
+			);
+			break;
+		case 'case_study_proposal_disapproved':
+			/* initializing data */
+			$query = db_select('case_study_proposal');
+			$query->fields('case_study_proposal');
+			$query->condition('id', $params['case_study_proposal_disapproved']['proposal_id']);
+			$query->range(0, 1);
+			$proposal_data = $query->execute()->fetchObject();
+			$user_data = user_load($params['case_study_proposal_disapproved']['user_id']);
+			//$user = user_load($params['case_study_proposal']['name']);
+			$message['headers'] = $params['case_study_proposal_disapproved']['headers'];
+			$message['subject'] = t('[!site_name][Case Study Project] Your  Case Study Project proposal has been disapproved', array(
+				'!site_name' => variable_get('site_name', '')
+			), array(
+				'language' => $language->language
+			));
+			$message['body'] = array(
+				'body' => t('
+Dear !user_name,
+
+We regret to inform you that your  Case Study proposal with following details have been disapproved:
+
+Full Name: ' . $proposal_data->name_title . ' ' . $proposal_data->contributor_name . '
+Email: ' . $user_data->mail . '
+University/Institute: ' . $proposal_data->university . '
+City: ' . $proposal_data->city . '
+State: ' . $proposal_data->state . '
+Country: ' . $proposal_data->country . '
+Project Title: ' . $proposal_data->project_title . '
+Date of Proposal: ' . date('d/m/Y' , $proposal_data->creation_date) . '
+Expected Date of Completion: ' . date('d/m/Y', $proposal_data->expected_date_of_completion) . '
+
+Reason for rejection: ' . $proposal_data->dissapproval_reason . '
+
+
+You are welcome to submit a new proposal.
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+					'!site_name' => variable_get('site_name', ''),
+					'!user_name' => $user_data->name
+				), array(
+					'language' => $language->language
+				))
+			);
+			break;
+		case 'case_study_proposal_approved':
+			/* initializing data */
+			$url = 'http://cfd.fossee.in/case-study-project/project-upload';
+			$query = db_select('case_study_proposal');
+			$query->fields('case_study_proposal');
+			$query->condition('id', $params['case_study_proposal_approved']['proposal_id']);
+			$query->range(0, 1);
+			$proposal_data = $query->execute()->fetchObject();
+			$user_data = user_load($params['case_study_proposal_approved']['user_id']);
+			$message['headers'] = $params['case_study_proposal_approved']['headers'];
+			$message['subject'] = t('[!site_name][Case Study Project] Your  Case Study Project proposal has been approved', array(
+				'!site_name' => variable_get('site_name', '')
+			), array(
+				'language' => $language->language
+			));
+			$message['body'] = array(
+				'body' => t('
+Dear !user_name,
+
+Your  Case Study Project proposal with the following details has been approved:
+
+Full Name: ' . $proposal_data->name_title . ' ' . $proposal_data->contributor_name . '
+Email: ' . $user_data->mail . '
+University/Institute: ' . $proposal_data->university . '
+City: ' . $proposal_data->city . '
+State: ' . $proposal_data->state . '
+Country: ' . $proposal_data->country . '
+Project Title: ' . $proposal_data->project_title . '
+Date of Proposal: ' . date('d/m/Y' , $proposal_data->creation_date) . '
+Expected Date of Completion: ' . date('d/m/Y', $proposal_data->expected_date_of_completion) . '
+
+
+You can upload your project files at: ' . $url . '
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+					'!site_name' => variable_get('site_name', ''),
+					'!user_name' => $user_data->name
+				), array(
+					'language' => $language->language
+				))
+			);
+			break;
+		case 'case_study_proposal_completed':
+			/* initializing data */
+			$query = db_select('case_study_proposal');
+			$query->fields('case_study_proposal');
+			$query->condition('id', $params['case_study_proposal_completed']['proposal_id']);
+			$query->range(0, 1);
+			$proposal_data = $query->execute()->fetchObject();
+			$user_data = user_load($params['case_study_proposal_completed']['user_id']);
+			$message['headers'] = $params['case_study_proposal_completed']['headers'];
+			$message['subject'] = t('[!site_name][Case Study Project] Your  Case Study Project proposal has been completed', array(
+				'!site_name' => variable_get('site_name', '')
+			), array(
+				'language' => $language->language
+			));
+			$message['body'] = array(
+				'body' => t('
+Dear !user_name,
+
+Your  Case Study and abstract on the following process have been completed successfully.
+
+Full Name: ' . $proposal_data->name_title . ' ' . $proposal_data->contributor_name . '
+Email: ' . $user_data->mail . '
+University/Institute: ' . $proposal_data->university . '
+City: ' . $proposal_data->city . '
+State: ' . $proposal_data->state . '
+Country: ' . $proposal_data->country . '
+Project Title: ' . $proposal_data->project_title . '
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+					'!site_name' => variable_get('site_name', ''),
+					'!user_name' => $user_data->name
+				), array(
+					'language' => $language->language
+				))
+			);
+			break;
+		case 'case_study_proposal_deleted':
+			/* initializing data */
+			$query = db_select('case_study_proposal');
+			$query->fields('case_study_proposal');
+			$query->condition('id', $params['case_study_proposal_deleted']['proposal_id']);
+			$query->range(0, 1);
+			$proposal_data = $query->execute()->fetchObject();
+			$user_data = user_load($params['case_study_proposal_deleted']['user_id']);
+			$message['headers'] = $params['case_study_proposal_deleted']['headers'];
+			$message['subject'] = t('[!site_name][Case Study Project] Your  Case Study Project proposal has been deleted', array(
+				'!site_name' => variable_get('site_name', '')
+			), array(
+				'language' => $language->language
+			));
+			$message['body'] = array(
+				'body' => t('
+Dear !user_name,
+
+Your  Case Study Project proposal with the following details has been deleted :
+
+Full Name: ' . $proposal_data->name_title . ' ' . $proposal_data->contributor_name . '
+Email: ' . $user_data->mail . '
+University/Institute: ' . $proposal_data->university . '
+City: ' . $proposal_data->city . '
+State: ' . $proposal_data->state . '
+Country: ' . $proposal_data->country . '
+Project Title: ' . $proposal_data->project_title . '
+
+You can propose a new Case Study project.
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+					'!site_name' => variable_get('site_name', ''),
+					'!user_name' => $user_data->name
+				), array(
+					'language' => $language->language
+				))
+			);
+			break;
+		/**************************************************************/
+		case 'abstract_uploaded':
+			// $solution_q = db_query("SELECT * FROM {case_study_solution} WHERE id = %d LIMIT 1", $params['abstract_uploaded']['solution_id']);
+			$query = db_select('case_study_proposal');
+			$query->fields('case_study_proposal');
+			$query->condition('id', $params['abstract_uploaded']['proposal_id']);
+			$query->range(0, 1);
+			$proposal_data = $query->execute()->fetchObject();
+			
+			$user = user_load($params['abstract_uploaded']['user_id']);
+			$message['subject'] = t('[!site_name][Case Study Project] You have uploaded  Case Study project files', array(
+				'!site_name' => variable_get('site_name', '')
+			), array(
+				'language' => $language->language
+			));
+			$message['headers'] = $params['abstract_uploaded']['headers'];
+			$message['body'] = array(
+				'body' => t('
+Dear !user_name,
+
+You have uploaded the following Abstract and Project files:
+
+Project Title: ' . $proposal_data->project_title . '
+
+
+The abstract and project files are under review. You will be notified when it has been approved.
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+					'!site_name' => variable_get('site_name', ''),
+					'!user_name' => $user->name
+				), array(
+					'language' => $language->language
+				))
+			);
+			break;
+		case 'standard':
+			$message['subject'] = $params['standard']['subject'];
+			$message['body'] = $params['standard']['body'];
+			$message['headers'] = $params['standard']['headers'];
+			break;
+	} //$key
+}
diff --git a/full_download.inc b/full_download.inc
new file mode 100755
index 0000000..f3fbc00
--- /dev/null
+++ b/full_download.inc
@@ -0,0 +1,131 @@
+<?php
+// $Id$
+function cfd_case_study_download_full_project()
+{
+	global $user;
+	$id = arg(3);
+	$root_path = cfd_case_study_path();
+	//var_dump($root_path);die;
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('id', $id);
+	$case_study_q = $query->execute();
+	$case_study_data = $case_study_q->fetchObject();
+	$CASE_STUDY_PATH = $case_study_data->directory_name . '/';
+	/* zip filename */
+	$zip_filename = $root_path . 'zip-' . time() . '-' . rand(0, 999999) . '.zip';
+	/* creating zip archive on the server */
+	$zip = new ZipArchive();
+	$zip->open($zip_filename, ZipArchive::CREATE);
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('id', $id);
+	$circuit_simulation_udc_q = $query->execute();
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('id', $id);
+	$query = db_select('case_study_submitted_abstracts_file');
+	$query->fields('case_study_submitted_abstracts_file');
+	$query->condition('proposal_id', $id);
+	$project_files = $query->execute();
+	while ($esim_project_files = $project_files->fetchObject()) {
+		$zip->addFile($root_path . $CASE_STUDY_PATH . $esim_project_files->filepath, $CASE_STUDY_PATH . str_replace(' ', '_', basename($esim_project_files->filename)));
+	}
+	$zip_file_count = $zip->numFiles;
+	$zip->close();
+	if ($zip_file_count > 0) {
+		if ($user->uid) {
+			/* download zip file */
+			header('Content-Type: application/zip');
+			header('Content-disposition: attachment; filename="' . str_replace(' ', '_', $case_study_data->project_title) . '.zip"');
+			header('Content-Length: ' . filesize($zip_filename));
+			ob_end_flush();
+			ob_clean();
+			flush();
+			readfile($zip_filename);
+			unlink($zip_filename);
+		} //$user->uid
+		else {
+			header('Content-Type: application/zip');
+			header('Content-disposition: attachment; filename="' . str_replace(' ', '_', $case_study_data->project_title) . '.zip"');
+			header('Content-Length: ' . filesize($zip_filename));
+			header("Content-Transfer-Encoding: binary");
+			header('Expires: 0');
+			header('Pragma: no-cache');
+			ob_end_flush();
+			ob_clean();
+			flush();
+			readfile($zip_filename);
+			unlink($zip_filename);
+		}
+	} //$zip_file_count > 0
+	else {
+		drupal_set_message("There are no case study project in this proposal to download", 'error');
+		drupal_goto('circuit-simulation-project/full-download/project');
+	}
+}
+/*
+function circuit_simulation_download_completed_project()
+{
+		global $user;
+	$id = arg(3);
+	$root_path = cfd_case_study_path();
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('id', $id);
+	$case_study_q = $query->execute();
+	$case_study_data = $case_study_q->fetchObject();
+	$CASE_STUDY_PATH = $case_study_data->directory_name . '/';
+	/* zip filename 
+	$zip_filename = $root_path . 'zip-' . time() . '-' . rand(0, 999999) . '.zip';
+	/* creating zip archive on the server 
+	$zip = new ZipArchive();
+	$zip->open($zip_filename, ZipArchive::CREATE);
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('id', $id);
+	$circuit_simulation_udc_q = $query->execute();
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('id', $id);
+	$query = db_select('case_study_submitted_abstracts_file');
+	$query->fields('case_study_submitted_abstracts_file');
+	$query->condition('proposal_id', $id);
+	$project_files = $query->execute();
+	//var_dump($root_path . $CASE_STUDY_PATH . 'project_files/');die;
+	while ($esim_project_files = $project_files->fetchObject()) {
+		$zip->addFile($root_path . $CASE_STUDY_PATH . 'project_files/' . $esim_project_files->filepath, $CASE_STUDY_PATH . str_replace(' ', '_', basename($esim_project_files->filename)));
+	}
+	$zip_file_count = $zip->numFiles;
+	$zip->close();
+	if ($zip_file_count > 0) {
+		if ($user->uid) {
+			/* download zip file 
+			header('Content-Type: application/zip');
+			header('Content-disposition: attachment; filename="' . str_replace(' ', '_', $case_study_data->project_title) . '.zip"');
+			header('Content-Length: ' . filesize($zip_filename));
+			ob_end_flush();
+			ob_clean();
+			flush();
+			readfile($zip_filename);
+			unlink($zip_filename);
+		} //$user->uid
+		else {
+			header('Content-Type: application/zip');
+			header('Content-disposition: attachment; filename="' . str_replace(' ', '_', $case_study_data->project_title) . '.zip"');
+			header('Content-Length: ' . filesize($zip_filename));
+			header("Content-Transfer-Encoding: binary");
+			header('Expires: 0');
+			header('Pragma: no-cache');
+			ob_end_flush();
+			ob_clean();
+			flush();
+			readfile($zip_filename);
+			unlink($zip_filename);
+		}
+	} //$zip_file_count > 0
+	else {
+		drupal_set_message("There are circuit simulation project in this proposal to download", 'error');
+		drupal_goto('circuit-simulation-project/full-download/project');
+	}
+}*/
diff --git a/general_deletion.inc b/general_deletion.inc
new file mode 100755
index 0000000..4bc9d3f
--- /dev/null
+++ b/general_deletion.inc
@@ -0,0 +1,41 @@
+<?php
+/******************************************************************************/
+/****************************** DELETION FUNCTIONS ****************************/
+/******************************************************************************/
+function case_study_abstract_delete_project($proposal_id)
+{
+	$status = TRUE;
+	$root_path = cfd_case_study_path();
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('id', $proposal_id);
+	$proposal_q = $query->execute();
+	$proposal_data = $proposal_q->fetchObject();
+	if (!$proposal_data)
+	{
+		drupal_set_message('Invalid Case Study Project.', 'error');
+		return FALSE;
+	} //!$proposal_data
+	$query = db_select('case_study_submitted_abstracts_file');
+	$query->fields('case_study_submitted_abstracts_file');
+	$query->condition('proposal_id', $proposal_id);
+	$abstract_q = $query->execute();
+	$dir_project_files = $root_path . $proposal_data->directory_name . '/';
+	while ($abstract_data = $abstract_q->fetchObject())
+	{
+		if (is_dir($dir_project_files)){
+
+		unlink($root_path . $proposal_data->directory_name . '/' . $abstract_data->filepath);
+		}
+		else
+		{
+			drupal_set_message('Invalid case study project abstract.', 'error');
+		}
+		db_delete('case_study_submitted_abstracts_file')->condition('proposal_id', $proposal_id)->execute();
+		//!dwsim_flowsheet_delete_abstract_file($abstract_data->id)
+	}
+	$res = rmdir($root_path . $proposal_data->directory_name);
+	db_delete('case_study_proposal')->condition('id', $proposal_data->id)->execute();
+	db_delete('case_study_submitted_abstracts')->condition('proposal_id', $proposal_id)->execute();
+	return $status;
+}
diff --git a/manage_proposal.inc b/manage_proposal.inc
new file mode 100755
index 0000000..cec5890
--- /dev/null
+++ b/manage_proposal.inc
@@ -0,0 +1,888 @@
+<?php
+// $Id$
+function cfd_case_study_proposal_pending()
+{
+	/* get pending proposals to be approved */
+	$pending_rows = array();
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('approval_status', 0);
+	$query->orderBy('id', 'DESC');
+	$pending_q = $query->execute();
+	while ($pending_data = $pending_q->fetchObject())
+	{
+		$pending_rows[$pending_data->id] = array(
+			date('d-m-Y', $pending_data->creation_date),
+			l($pending_data->name_title . ' ' . $pending_data->contributor_name, 'user/' . $pending_data->uid),
+			$pending_data->project_title,
+			l('Approve', 'case-study-project/manage-proposal/approve/' . $pending_data->id) . ' | ' . l('Edit', 'case-study-project/manage-proposal/edit/' . $pending_data->id)
+		);
+	} //$pending_data = $pending_q->fetchObject()
+	/* check if there are any pending proposals */
+	if (!$pending_rows)
+	{
+		drupal_set_message(t('There are no pending proposals.'), 'status');
+		return '';
+	} //!$pending_rows
+	$pending_header = array(
+		'Date of Submission',
+		'Student Name',
+		'Title of the Case Study Project',
+		'Action'
+	);
+	//$output = theme_table($pending_header, $pending_rows);
+	$output = theme('table', array(
+		'header' => $pending_header,
+		'rows' => $pending_rows
+	));
+	return $output;
+}
+function cfd_case_study_proposal_all()
+{
+	/* get pending proposals to be approved */
+	$proposal_rows = array();
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->orderBy('id', 'DESC');
+	$proposal_q = $query->execute();
+	while ($proposal_data = $proposal_q->fetchObject())
+	{
+		$approval_status = '';
+		switch ($proposal_data->approval_status)
+		{
+			case 0:
+				$approval_status = 'Pending';
+				break;
+			case 1:
+				$approval_status = 'Approved';
+				break;
+			case 2:
+				$approval_status = 'Dis-approved';
+				break;
+			case 3:
+				$approval_status = 'Completed';
+				break;
+			default:
+				$approval_status = 'Unknown';
+				break;
+		} //$proposal_data->approval_status
+		if ($proposal_data->actual_completion_date == 0)
+		{
+			$actual_completion_date = "Not Completed";
+		} //$proposal_data->actual_completion_date == 0
+		else
+		{
+			$actual_completion_date = date('d-m-Y', $proposal_data->actual_completion_date);
+		}
+		$proposal_rows[] = array(
+			date('d-m-Y', $proposal_data->creation_date),
+			l($proposal_data->contributor_name, 'user/' . $proposal_data->uid),
+			$proposal_data->project_title,
+			$actual_completion_date,
+			$approval_status,
+			l('Status', 'case-study-project/manage-proposal/status/' . $proposal_data->id) . ' | ' . l('Edit', 'case-study-project/manage-proposal/edit/' . $proposal_data->id)
+		);
+	} //$proposal_data = $proposal_q->fetchObject()
+	/* check if there are any pending proposals */
+	if (!$proposal_rows)
+	{
+		drupal_set_message(t('There are no proposals.'), 'status');
+		return '';
+	} //!$proposal_rows
+	$proposal_header = array(
+		'Date of Submission',
+		'Student Name',
+		'Title of the case-study project',
+		'Date of Completion',
+		'Status',
+		'Action'
+	);
+	$output = theme('table', array(
+		'header' => $proposal_header,
+		'rows' => $proposal_rows
+	));
+	return $output;
+}
+/******************************************************************************/
+/************************** PROPOSAL APPROVAL FORM ****************************/
+/******************************************************************************/
+function cfd_case_study_proposal_approval_form($form, &$form_state)
+{
+	global $user;
+	/* get current proposal */
+	$proposal_id = (int) arg(3);
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('id', $proposal_id);
+	$proposal_q = $query->execute();
+	$query_abstract = db_select('case_study_submitted_abstracts_file');
+	$query_abstract->fields('case_study_submitted_abstracts_file');
+	$query_abstract->condition('proposal_id', $proposal_id);
+	$query_abstract->condition('filetype', 'A');
+	$query_abstract_pdf = $query_abstract->execute()->fetchObject();
+	if ($proposal_q)
+	{
+		if ($proposal_data = $proposal_q->fetchObject())
+		{
+			/* everything ok */
+		} //$proposal_data = $proposal_q->fetchObject()
+		else
+		{
+			drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+			drupal_goto('case-study-project/manage-proposal');
+			return;
+		}
+	} //$proposal_q
+	else
+	{
+		drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+		drupal_goto('case-study-project/manage-proposal');
+		return;
+	}
+	if ($proposal_data->project_guide_name == "NULL" || $proposal_data->project_guide_name == "")
+	{
+		$project_guide_name = "Not Entered";
+	} //$proposal_data->project_guide_name == NULL
+	else
+	{
+		$project_guide_name = $proposal_data->project_guide_name;
+	}
+	if ($proposal_data->project_guide_email_id == "NULL" || $proposal_data->project_guide_email_id == "")
+	{
+		$project_guide_email_id = "Not Entered";
+	} //$proposal_data->project_guide_email_id == NULL
+	else
+	{
+		$project_guide_email_id = $proposal_data->project_guide_email_id;
+	}
+	$form['contributor_name'] = array(
+		'#type' => 'item',
+		'#markup' => l($proposal_data->name_title . ' ' . $proposal_data->contributor_name, 'user/' . $proposal_data->uid),
+		'#title' => t('Student name')
+	);
+	$form['student_email_id'] = array(
+		'#title' => t('Student Email'),
+		'#type' => 'item',
+		'#markup' => user_load($proposal_data->uid)->mail,
+		'#title' => t('Email')
+	);
+	$form['contributor_contact_no'] = array(
+		'#title' => t('Contact No.'),
+		'#type' => 'item',
+		'#markup' => $proposal_data->contact_no,
+	);
+	$form['university'] = array(
+		'#type' => 'item',
+		'#markup' => $proposal_data->university,
+		'#title' => t('University/Institute')
+	);
+	$form['country'] = array(
+		'#type' => 'item',
+		'#markup' => $proposal_data->country,
+		'#title' => t('Country')
+	);
+	$form['all_state'] = array(
+		'#type' => 'item',
+		'#markup' => $proposal_data->state,
+		'#title' => t('State')
+	);
+	$form['city'] = array(
+		'#type' => 'item',
+		'#markup' => $proposal_data->city,
+		'#title' => t('City')
+	);
+	$form['pincode'] = array(
+		'#type' => 'item',
+		'#markup' => $proposal_data->pincode,
+		'#title' => t('Pincode/Postal code')
+	);
+	$form['project_title'] = array(
+		'#type' => 'item',
+		'#markup' => $proposal_data->project_title,
+		'#title' => t('Title of the Case Study Project')
+	);
+	$form['date_of_proposal'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Date of Proposal'),
+		'#default_value' => date('d/m/Y', $proposal_data->creation_date),
+		'#disabled' => TRUE,
+	);
+	$form['expected_completion_date'] =array(
+		'#type' => 'textfield',
+		'#title' => t('Expected Date of Completion'),
+		'#default_value' => date('d/m/Y', $proposal_data->expected_date_of_completion),
+		'#disabled' => TRUE,
+	);
+	if (($query_abstract_pdf->filename != "") && ($query_abstract_pdf->filename != 'NULL'))
+	{
+		$str = substr($query_abstract_pdf->filename,strrpos($query_abstract_pdf->filename, '/'));
+		$resource_file =ltrim($str, '/');
+		
+		$form['abstract_file_path'] = array(
+			'#type' => 'item',
+			'#title' => t('Abstract file '),
+			'#markup' => l($resource_file, 'case-study-project/download/project-file/' . $proposal_id) . ""
+		);
+	} //$proposal_data->user_defined_compound_filepath != ""
+	else
+	{
+		$form['abstract_file_path'] = array(
+			'#type' => 'item',
+			'#title' => t('Abstract file '),
+			'#markup' => "Not uploaded<br><br>"
+		);
+	}
+	$form['approval'] = array(
+		'#type' => 'radios',
+		'#title' => t('CFD Case Study proposal'),
+		'#options' => array(
+			'1' => 'Approve',
+			'2' => 'Disapprove'
+		),
+		'#required' => TRUE
+	);
+	$form['message'] = array(
+		'#type' => 'textarea',
+		'#title' => t('Reason for disapproval'),
+		'#attributes' => array(
+			'placeholder' => t('Enter reason for disapproval in minimum 30 characters '),
+			'cols' => 50,
+			'rows' => 4
+		),
+		'#states' => array(
+			'visible' => array(
+				':input[name="approval"]' => array(
+					'value' => '2'
+				)
+			)
+		)
+	);
+	$form['submit'] = array(
+		'#type' => 'submit',
+		'#value' => t('Submit')
+	);
+	$form['cancel'] = array(
+		'#type' => 'item',
+		'#markup' => l(t('Cancel'), 'case-study-project/manage-proposal')
+	);
+	return $form;
+}
+function cfd_case_study_proposal_approval_form_validate($form, &$form_state)
+{
+	if ($form_state['values']['approval'] == 2)
+	{
+		if ($form_state['values']['message'] == '')
+		{
+			form_set_error('message', t('Reason for disapproval could not be empty'));
+		} //$form_state['values']['message'] == ''
+	} //$form_state['values']['approval'] == 2
+}
+function cfd_case_study_proposal_approval_form_submit($form, &$form_state)
+{
+	global $user;
+	/* get current proposal */
+	$proposal_id = (int) arg(3);
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('id', $proposal_id);
+	$proposal_q = $query->execute();
+	if ($proposal_q)
+	{
+		if ($proposal_data = $proposal_q->fetchObject())
+		{
+			/* everything ok */
+		} //$proposal_data = $proposal_q->fetchObject()
+		else
+		{
+			drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+			drupal_goto('case-study-project/manage-proposal');
+			return;
+		}
+	} //$proposal_q
+	else
+	{
+		drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+		drupal_goto('case-study-project/manage-proposal');
+		return;
+	}
+	if ($form_state['values']['approval'] == 1)
+	{
+		$query = "UPDATE {case_study_proposal} SET approver_uid = :uid, approval_date = :date, approval_status = 1 WHERE id = :proposal_id";
+		$args = array(
+			":uid" => $user->uid,
+			":date" => time(),
+			":proposal_id" => $proposal_id
+		);
+		db_query($query, $args);
+		/* sending email */
+		$user_data = user_load($proposal_data->uid);
+		$email_to = $user_data->mail;
+		$from = variable_get('case_study_from_email', '');
+		$bcc = $user->mail . ', ' . variable_get('case_study_emails', '');
+		$cc = variable_get('case_study_cc_emails', '');
+		$params['case_study_proposal_approved']['proposal_id'] = $proposal_id;
+		$params['case_study_proposal_approved']['user_id'] = $proposal_data->uid;
+		$params['case_study_proposal_approved']['headers'] = array(
+			'From' => $from,
+			'MIME-Version' => '1.0',
+			'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
+			'Content-Transfer-Encoding' => '8Bit',
+			'X-Mailer' => 'Drupal',
+			'Cc' => $cc,
+			'Bcc' => $bcc
+		);
+		if (!drupal_mail('case_study', 'case_study_proposal_approved', $email_to, language_default(), $params, $from, TRUE))
+			drupal_set_message('Error sending email message.', 'error');
+		drupal_set_message('CFD Case Study proposal No. ' . $proposal_id . ' approved. User has been notified of the approval.', 'status');
+		drupal_goto('case-study-project/manage-proposal');
+		return;
+	} //$form_state['values']['approval'] == 1
+	else if ($form_state['values']['approval'] == 2)
+	{
+		$query = "UPDATE {case_study_proposal} SET approver_uid = :uid, approval_date = :date, approval_status = 2, dissapproval_reason = :dissapproval_reason WHERE id = :proposal_id";
+		$args = array(
+			":uid" => $user->uid,
+			":date" => time(),
+			":dissapproval_reason" => $form_state['values']['message'],
+			":proposal_id" => $proposal_id
+		);
+		$result = db_query($query, $args);
+		/* sending email */
+		$user_data = user_load($proposal_data->uid);
+		$email_to = $user_data->mail;
+		$from = variable_get('case_study_from_email', '');
+		$bcc = $user->mail . ', ' . variable_get('case_study_emails', '');
+		$cc = variable_get('case_study_cc_emails', '');
+		$params['case_study_proposal_disapproved']['proposal_id'] = $proposal_id;
+		$params['case_study_proposal_disapproved']['user_id'] = $proposal_data->uid;
+		$params['case_study_proposal_disapproved']['headers'] = array(
+			'From' => $from,
+			'MIME-Version' => '1.0',
+			'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
+			'Content-Transfer-Encoding' => '8Bit',
+			'X-Mailer' => 'Drupal',
+			'Cc' => $cc,
+			'Bcc' => $bcc
+		);
+		if (!drupal_mail('case_study', 'case_study_proposal_disapproved', $email_to, language_default(), $params, $from, TRUE))
+			drupal_set_message('Error sending email message.', 'error');
+		drupal_set_message('CFD Case Study proposal No. ' . $proposal_id . ' dis-approved. User has been notified of the dis-approval.', 'error');
+		drupal_goto('case-study-project/manage-proposal');
+		return;
+	} //$form_state['values']['approval'] == 2
+}
+/******************************************************************************/
+/*************************** PROPOSAL STATUS FORM *****************************/
+/******************************************************************************/
+function cfd_case_study_proposal_status_form($form, &$form_state)
+{
+	global $user;
+	/* get current proposal */
+	$proposal_id = (int) arg(3);
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('id', $proposal_id);
+	$proposal_q = $query->execute();
+	if ($proposal_q)
+	{
+		if ($proposal_data = $proposal_q->fetchObject())
+		{
+			/* everything ok */
+		} //$proposal_data = $proposal_q->fetchObject()
+		else
+		{
+			drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+			drupal_goto('case-study-project/manage-proposal');
+			return;
+		}
+	} //$proposal_q
+	else
+	{
+		drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+		drupal_goto('case-study-project/manage-proposal');
+		return;
+	}
+	$form['contributor_name'] = array(
+		'#type' => 'item',
+		'#markup' => l($proposal_data->name_title . ' ' . $proposal_data->contributor_name, 'user/' . $proposal_data->uid),
+		'#title' => t('Student name')
+	);
+	$form['student_email_id'] = array(
+		'#title' => t('Student Email'),
+		'#type' => 'item',
+		'#markup' => user_load($proposal_data->uid)->mail,
+		'#title' => t('Email')
+	);
+	$form['university'] = array(
+		'#type' => 'item',
+		'#markup' => $proposal_data->university,
+		'#title' => t('University/Institute')
+	);
+	$form['country'] = array(
+		'#type' => 'item',
+		'#markup' => $proposal_data->country,
+		'#title' => t('Country')
+	);
+	$form['all_state'] = array(
+		'#type' => 'item',
+		'#markup' => $proposal_data->state,
+		'#title' => t('State')
+	);
+	$form['city'] = array(
+		'#type' => 'item',
+		'#markup' => $proposal_data->city,
+		'#title' => t('City')
+	);
+	$form['pincode'] = array(
+		'#type' => 'item',
+		'#markup' => $proposal_data->pincode,
+		'#title' => t('Pincode/Postal code')
+	);
+	$form['project_title'] = array(
+		'#type' => 'item',
+		'#markup' => $proposal_data->project_title,
+		'#title' => t('Title of the Case Study Project')
+	);
+	/************************** reference link filter *******************/
+	$url = '~(?:(https?)://([^\s<]+)|(www\.[^\s<]+?\.[^\s<]+))(?<![\.,:])~i';
+	$reference = preg_replace($url, '<a href="$0" target="_blank" title="$0">$0</a>', $proposal_data->reference);
+	/******************************/
+	/*$form['reference'] = array(
+		'#type' => 'item',
+		'#markup' => $reference,
+		'#title' => t('References')
+	);*/
+	$proposal_status = '';
+	switch ($proposal_data->approval_status)
+	{
+		case 0:
+			$proposal_status = t('Pending');
+			break;
+		case 1:
+			$proposal_status = t('Approved');
+			break;
+		case 2:
+			$proposal_status = t('Dis-approved');
+			break;
+		case 3:
+			$proposal_status = t('Completed');
+			break;
+		default:
+			$proposal_status = t('Unkown');
+			break;
+	} 
+	$form['proposal_status'] = array(
+		'#type' => 'item',
+		'#markup' => $proposal_status,
+		'#title' => t('Proposal Status')
+	);
+	if ($proposal_data->approval_status == 0)
+	{
+		$form['approve'] = array(
+			'#type' => 'item',
+			'#markup' => l('Click here', 'case-study-project/manage-proposal/approve/' . $proposal_id),
+			'#title' => t('Approve')
+		);
+	} //$proposal_data->approval_status == 0
+	if ($proposal_data->approval_status == 1)
+	{
+		$form['completed'] = array(
+			'#type' => 'checkbox',
+			'#title' => t('Completed'),
+			'#description' => t('Check if user has provided all the required files and pdfs.')
+		);
+	} //$proposal_data->approval_status == 1
+	if ($proposal_data->approval_status == 2)
+	{
+		$form['message'] = array(
+			'#type' => 'item',
+			'#markup' => $proposal_data->message,
+			'#title' => t('Reason for disapproval')
+		);
+	} //$proposal_data->approval_status == 2
+	$form['submit'] = array(
+		'#type' => 'submit',
+		'#value' => t('Submit')
+	);
+	$form['cancel'] = array(
+		'#type' => 'markup',
+		'#markup' => l(t('Cancel'), 'case-study-project/manage-proposal/all')
+	);
+	return $form;
+}
+function cfd_case_study_proposal_status_form_submit($form, &$form_state)
+{
+	global $user;
+	/* get current proposal */
+	$proposal_id = (int) arg(3);
+	//$proposal_q = db_query("SELECT * FROM {case_study_proposal} WHERE id = %d", $proposal_id);
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('id', $proposal_id);
+	$proposal_q = $query->execute();
+	if ($proposal_q)
+	{
+		if ($proposal_data = $proposal_q->fetchObject())
+		{
+			/* everything ok */
+		} //$proposal_data = $proposal_q->fetchObject()
+		else
+		{
+			drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+			drupal_goto('case-study-project/manage-proposal');
+			return;
+		}
+	} //$proposal_q
+	else
+	{
+		drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+		drupal_goto('case-study-project/manage-proposal');
+		return;
+	}
+	/* set the book status to completed */
+	if ($form_state['values']['completed'] == 1)
+	{
+		$up_query = "UPDATE case_study_proposal SET approval_status = :approval_status , actual_completion_date = :expected_completion_date WHERE id = :proposal_id";
+		$args = array(
+			":approval_status" => '3',
+			":proposal_id" => $proposal_id,
+			":expected_completion_date" => time()
+		);
+		$result = db_query($up_query, $args);
+		CreateReadmeFileCaseStudyProject($proposal_id);
+		if (!$result)
+		{
+			drupal_set_message('Error in update status', 'error');
+			return;
+		} //!$result
+		/* sending email */
+		$user_data = user_load($proposal_data->uid);
+		$email_to = $user_data->mail;
+		$from = variable_get('case_study_from_email', '');
+		$bcc = $user->mail . ', ' . variable_get('case_study_emails', '');
+		$cc = variable_get('case_study_cc_emails', '');
+		$params['case_study_proposal_completed']['proposal_id'] = $proposal_id;
+		$params['case_study_proposal_completed']['user_id'] = $proposal_data->uid;
+		$params['case_study_proposal_completed']['headers'] = array(
+			'From' => $from,
+			'MIME-Version' => '1.0',
+			'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
+			'Content-Transfer-Encoding' => '8Bit',
+			'X-Mailer' => 'Drupal',
+			'Cc' => $cc,
+			'Bcc' => $bcc
+		);
+		if (!drupal_mail('case_study', 'case_study_proposal_completed', $email_to, language_default(), $params, $from, TRUE))
+			drupal_set_message('Error sending email message.', 'error');
+		drupal_set_message('Congratulations! CFD Case Study proposal has been marked as completed. User has been notified of the completion.', 'status');
+	}
+		drupal_goto('case-study-project/manage-proposal');
+		return;
+	
+}
+/******************************************************************************/
+/**************************** PROPOSAL EDIT FORM ******************************/
+/******************************************************************************/
+function cfd_case_study_proposal_edit_form($form, &$form_state)
+{
+	global $user;
+	/* get current proposal */
+	$proposal_id = (int) arg(3);
+	//$proposal_q = db_query("SELECT * FROM {case_study_proposal} WHERE id = %d", $proposal_id);
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('id', $proposal_id);
+	$proposal_q = $query->execute();
+	if ($proposal_q)
+	{
+		if ($proposal_data = $proposal_q->fetchObject())
+		{
+			/* everything ok */
+		} //$proposal_data = $proposal_q->fetchObject()
+		else
+		{
+			drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+			drupal_goto('case-study-project/manage-proposal');
+			return;
+		}
+	} //$proposal_q
+	else
+	{
+		drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+		drupal_goto('case-study-project/manage-proposal');
+		return;
+	}
+	$user_data = user_load($proposal_data->uid);
+	$form['name_title'] = array(
+		'#type' => 'select',
+		'#title' => t('Title'),
+		'#options' => array(
+			'Dr' => 'Dr',
+			'Prof' => 'Prof',
+			'Mr' => 'Mr',
+			'Mrs' => 'Mrs',
+			'Ms' => 'Ms'
+		),
+		'#required' => TRUE,
+		'#default_value' => $proposal_data->name_title
+	);
+	$form['contributor_name'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Name of the Proposer'),
+		'#size' => 30,
+		'#maxlength' => 50,
+		'#required' => TRUE,
+		'#default_value' => $proposal_data->contributor_name
+	);
+	$form['student_email_id'] = array(
+		'#type' => 'item',
+		'#title' => t('Email'),
+		'#markup' => $user_data->mail
+	);
+	$form['university'] = array(
+		'#type' => 'textfield',
+		'#title' => t('University/Institute'),
+		'#size' => 200,
+		'#maxlength' => 200,
+		'#required' => TRUE,
+		'#default_value' => $proposal_data->university
+	);
+	$form['institute'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Institute'),
+		'#size' => 80,
+		'#maxlength' => 200,
+		'#required' => TRUE,
+		'#default_value' => $proposal_data->institute
+	);
+	$form['country'] = array(
+		'#type' => 'select',
+		'#title' => t('Country'),
+		'#options' => array(
+			'India' => 'India',
+			'Others' => 'Others'
+		),
+		'#default_value' => $proposal_data->country,
+		'#required' => TRUE,
+		'#tree' => TRUE,
+		'#validated' => TRUE
+	);
+	$form['other_country'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Other than India'),
+		'#size' => 100,
+		'#default_value' => $proposal_data->country,
+		'#attributes' => array(
+			'placeholder' => t('Enter your country name')
+		),
+		'#states' => array(
+			'visible' => array(
+				':input[name="country"]' => array(
+					'value' => 'Others'
+				)
+			)
+		)
+	);
+	$form['other_state'] = array(
+		'#type' => 'textfield',
+		'#title' => t('State other than India'),
+		'#size' => 100,
+		'#attributes' => array(
+			'placeholder' => t('Enter your state/region name')
+		),
+		'#default_value' => $proposal_data->state,
+		'#states' => array(
+			'visible' => array(
+				':input[name="country"]' => array(
+					'value' => 'Others'
+				)
+			)
+		)
+	);
+	$form['other_city'] = array(
+		'#type' => 'textfield',
+		'#title' => t('City other than India'),
+		'#size' => 100,
+		'#attributes' => array(
+			'placeholder' => t('Enter your city name')
+		),
+		'#default_value' => $proposal_data->city,
+		'#states' => array(
+			'visible' => array(
+				':input[name="country"]' => array(
+					'value' => 'Others'
+				)
+			)
+		)
+	);
+	$form['all_state'] = array(
+		'#type' => 'select',
+		'#title' => t('State'),
+		'#options' => _df_list_of_states(),
+		'#default_value' => $proposal_data->state,
+		'#validated' => TRUE,
+		'#states' => array(
+			'visible' => array(
+				':input[name="country"]' => array(
+					'value' => 'India'
+				)
+			)
+		)
+	);
+	$form['city'] = array(
+		'#type' => 'select',
+		'#title' => t('City'),
+		'#options' => _df_list_of_cities(),
+		'#default_value' => $proposal_data->city,
+		'#states' => array(
+			'visible' => array(
+				':input[name="country"]' => array(
+					'value' => 'India'
+				)
+			)
+		)
+	);
+	$form['pincode'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Pincode'),
+		'#size' => 30,
+		'#maxlength' => 6,
+		'#default_value' => $proposal_data->pincode,
+		'#attributes' => array(
+			'placeholder' => 'Insert pincode of your city/ village....'
+		)
+	);
+	$form['project_title'] = array(
+		'#type' => 'textarea',
+		'#title' => t('Title of the Case Study Project'),
+		'#size' => 300,
+		'#maxlength' => 350,
+		'#required' => TRUE,
+		'#default_value' => $proposal_data->project_title
+	);
+	$form['date_of_proposal'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Date of Proposal'),
+		'#default_value' => date('d/m/Y', $proposal_data->creation_date),
+		'#disabled' => TRUE,
+	);
+	$form['expected_completion_date'] =array(
+		'#type' => 'textfield',
+		'#title' => t('Expected Date of Completion'),
+		'#default_value' => date('d/m/Y', $proposal_data->expected_date_of_completion),
+	);
+	$form['delete_proposal'] = array(
+		'#type' => 'checkbox',
+		'#title' => t('Delete Proposal')
+	);
+	$form['submit'] = array(
+		'#type' => 'submit',
+		'#value' => t('Submit')
+	);
+	$form['cancel'] = array(
+		'#type' => 'item',
+		'#markup' => l(t('Cancel'), 'case-study-project/manage-proposal')
+	);
+	return $form;
+}
+function cfd_case_study_proposal_edit_form_submit($form, &$form_state)
+{
+	global $user;
+	/* get current proposal */
+	$proposal_id = (int) arg(3);
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('id', $proposal_id);
+	$proposal_q = $query->execute();
+	if ($proposal_q)
+	{
+		if ($proposal_data = $proposal_q->fetchObject())
+		{
+			/* everything ok */
+		} //$proposal_data = $proposal_q->fetchObject()
+		else
+		{
+			drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+			drupal_goto('case-study-project/manage-proposal');
+			return;
+		}
+	} //$proposal_q
+	else
+	{
+		drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+		drupal_goto('case-study-project/manage-proposal');
+		return;
+	}
+	/* delete proposal */
+	if ($form_state['values']['delete_proposal'] == 1)
+	{
+		/* sending email */
+		$user_data = user_load($proposal_data->uid);
+		$email_to = $user_data->mail;
+		$from = variable_get('case_study_from_email', '');
+		$bcc = variable_get('case_study_emails', '');
+		$cc = variable_get('case_study_cc_emails', '');
+		$params['case_study_proposal_deleted']['proposal_id'] = $proposal_id;
+		$params['case_study_proposal_deleted']['user_id'] = $proposal_data->uid;
+		$params['case_study_proposal_deleted']['headers'] = array(
+			'From' => $from,
+			'MIME-Version' => '1.0',
+			'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
+			'Content-Transfer-Encoding' => '8Bit',
+			'X-Mailer' => 'Drupal',
+			'Cc' => $cc,
+			'Bcc' => $bcc
+		);
+		if (!drupal_mail('case_study', 'case_study_proposal_deleted', $email_to, user_preferred_language($user), $params, $from, TRUE))
+			drupal_set_message('Error sending email message.', 'error');
+		drupal_set_message(t('CaseStudy Cicuit simulation proposal has been deleted.'), 'status');
+		if (rrmdir_project($proposal_id) == TRUE)
+		{
+			$query = db_delete('case_study_proposal');
+			$query->condition('id', $proposal_id);
+			$num_deleted = $query->execute();
+			drupal_set_message(t('Proposal Deleted'), 'status');
+			drupal_goto('case-study-project/manage-proposal');
+		return;
+		} //rrmdir_project($proposal_id) == TRUE
+	} //$form_state['values']['delete_proposal'] == 1
+	/* update proposal */
+	$v = $form_state['values'];
+	$project_title = $v['project_title'];
+	$proposar_name = $v['name_title'] . ' ' . $v['contributor_name'];
+	$university = $v['university'];
+	$directory_names = _df_dir_name($project_title, $proposar_name);
+	if (DF_RenameDir($proposal_id, $directory_names))
+	{
+		$directory_name = $directory_names;
+	} //LM_RenameDir($proposal_id, $directory_names)
+	else
+	{
+		return;
+	}
+	$query = "UPDATE case_study_proposal SET 
+				name_title=:name_title,
+				contributor_name=:contributor_name,
+				university=:university,
+				city=:city,
+				pincode=:pincode,
+				state=:state,
+				project_title=:project_title,
+				directory_name=:directory_name,
+				expected_date_of_completion=:expected_date_of_completion 
+				WHERE id=:proposal_id";
+	$args = array(
+		':name_title' => $v['name_title'],
+		':contributor_name' => $v['contributor_name'],
+		':university' => $v['university'],
+		':city' => $v['city'],
+		':pincode' => $v['pincode'],
+		':state' => $v['all_state'],
+		':project_title' => $project_title,
+		':directory_name' => $directory_name,
+		':expected_date_of_completion' => strtotime(date('d/m/Y',$v['expected_date_of_completion'])),
+		':proposal_id' => $proposal_id
+	);
+	$result = db_query($query, $args);
+	drupal_set_message(t('Proposal Updated'), 'status');
+}
diff --git a/proposal.inc b/proposal.inc
new file mode 100755
index 0000000..ffd590d
--- /dev/null
+++ b/proposal.inc
@@ -0,0 +1,551 @@
+<?php
+/*
+Approval Status :
+0 - Pending
+1 - Approved
+2 - Dis-Approved
+3 - Completed
+Solution Status :
+0 - Pending
+1 - Approved
+2 - Dis-Approved
+Solution Display :
+0 - No
+1 - Yes
+is_completed
+0 - in progress
+1 - Completed
+Tables :
+case_study_solution : approval_status
+0 - Pending
+1 - Approved
+2 - Disapproved (delete it)
+*/
+function cfd_case_study_proposal_form($form, &$form_state, $no_js_use = FALSE)
+{
+	global $user;
+	/************************ start approve book details ************************/
+	if ($user->uid == 0)
+	{
+		$msg = drupal_set_message(t('It is mandatory to ' . l('login', 'user') . ' on this website to access the case study proposal form. If you are new user please create a new account first.'), 'error');
+		drupal_goto('user');
+		return $msg;
+	} //$user->uid == 0
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('uid', $user->uid);
+	$query->orderBy('id', 'DESC');
+	$query->range(0, 1);
+	$proposal_q = $query->execute();
+	$proposal_data = $proposal_q->fetchObject();
+	if ($proposal_data)
+	{
+		if ($proposal_data->approval_status == 0 || $proposal_data->approval_status == 1)
+		{
+			drupal_set_message(t('We have already received your proposal.'), 'status');
+			drupal_goto('');
+			return;
+		} //$proposal_data->approval_status == 0 || $proposal_data->approval_status == 1
+	} //$proposal_data
+	$form['#attributes'] = array(
+		'enctype' => "multipart/form-data"
+	);
+
+	$form['name_title'] = array(
+		'#type' => 'select',
+		'#title' => t('Title'),
+		'#options' => array(
+			'Dr' => 'Dr',
+			'Prof' => 'Prof',
+			'Mr' => 'Mr',
+			'Mrs' => 'Mrs',
+			'Ms' => 'Ms'
+		),
+		'#required' => TRUE
+	);
+	$form['contributor_name'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Name of the contributor'),
+		'#size' => 250,
+		'#attributes' => array(
+			'placeholder' => t('Enter your full name.....')
+		),
+		'#maxlength' => 250,
+		'#required' => TRUE
+	);
+	$form['contributor_email_id'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Email'),
+		'#size' => 30,
+		'#value' => $user->mail,
+		'#disabled' => TRUE
+	);
+	$form['contributor_contact_no'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Contact No.'),
+		'#size' => 10,
+		'#attributes' => array(
+			'placeholder' => t('Enter your contact number')
+		),
+		'#maxlength' => 250
+	);
+	$form['university'] = array(
+		'#type' => 'textfield',
+		'#title' => t('University'),
+		'#size' => 80,
+		'#maxlength' => 200,
+		'#required' => TRUE,
+		'#attributes' => array(
+			'placeholder' => 'Insert full name of your university.... '
+		)
+	);
+	$form['institute'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Institute'),
+		'#size' => 80,
+		'#maxlength' => 200,
+		'#required' => TRUE,
+		'#attributes' => array(
+			'placeholder' => 'Insert full name of your institute.... '
+		)
+	);
+	$form['country'] = array(
+		'#type' => 'select',
+		'#title' => t('Country'),
+		'#options' => array(
+			'India' => 'India',
+			'Others' => 'Others'
+		),
+		'#required' => TRUE,
+		'#tree' => TRUE,
+		'#validated' => TRUE
+	);
+	$form['other_country'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Other than India'),
+		'#size' => 100,
+		'#attributes' => array(
+			'placeholder' => t('Enter your country name')
+		),
+		'#states' => array(
+			'visible' => array(
+				':input[name="country"]' => array(
+					'value' => 'Others'
+				)
+			)
+		)
+	);
+	$form['other_state'] = array(
+		'#type' => 'textfield',
+		'#title' => t('State other than India'),
+		'#size' => 100,
+		'#attributes' => array(
+			'placeholder' => t('Enter your state/region name')
+		),
+		'#states' => array(
+			'visible' => array(
+				':input[name="country"]' => array(
+					'value' => 'Others'
+				)
+			)
+		)
+	);
+	$form['other_city'] = array(
+		'#type' => 'textfield',
+		'#title' => t('City other than India'),
+		'#size' => 100,
+		'#attributes' => array(
+			'placeholder' => t('Enter your city name')
+		),
+		'#states' => array(
+			'visible' => array(
+				':input[name="country"]' => array(
+					'value' => 'Others'
+				)
+			)
+		)
+	);
+	$form['all_state'] = array(
+		'#type' => 'select',
+		'#title' => t('State'),
+		'#options' => _df_list_of_states(),
+		'#validated' => TRUE,
+		'#states' => array(
+			'visible' => array(
+				':input[name="country"]' => array(
+					'value' => 'India'
+				)
+			)
+		)
+	);
+	$form['city'] = array(
+		'#type' => 'select',
+		'#title' => t('City'),
+		'#options' => _df_list_of_cities(),
+		'#states' => array(
+			'visible' => array(
+				':input[name="country"]' => array(
+					'value' => 'India'
+				)
+			)
+		)
+	);
+	$form['pincode'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Pincode'),
+		'#size' => 6
+	);
+	/***************************************************************************/
+	$form['hr'] = array(
+		'#type' => 'item',
+		'#markup' => '<hr>'
+	);
+	$form['project_title'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Project Title'),
+		'#size' => 250,
+		'#description' => t('Maximum character limit is 250'),
+		'#required' => TRUE
+	);
+	$form['abstract_file'] = array(
+		'#type' => 'fieldset',
+		'#title' => t('Submit an Abstract'),
+		'#collapsible' => FALSE,
+		'#collapsed' => FALSE
+	);
+	$form['abstract_file']['abstract_file_path'] = array(
+		'#type' => 'file',
+		'#size' => 48,
+		'#description' => t('Upload filenames with allowed extensions only. No spaces or any special characters allowed in filename.') . '<br />' . t('<span style="color:red;">Allowed file extensions : ') . variable_get('resource_upload_extensions', '') . '</span>'
+	);
+	$form['date_of_proposal'] = array(
+		'#type' => 'date_popup',
+		'#title' => t('Date of Proposal'),
+		'#default_value' => date("Y-m-d H:i:s"),
+		'#date_format' => 'd M Y',
+		'#disabled' => TRUE,
+		'#date_label_position' => '',
+	);
+	$form['expected_date_of_completion'] = array(
+		'#type' => 'date_popup',
+		'#title' => t('Expected Date of Completion'),
+		'#date_label_position' => '',
+		'#description' => '',
+		'#default_value' => '',
+		'#date_format' => 'd-M-Y',
+		//'#date_increment' => 0,
+		//'#minDate' => '+0',
+		'#date_year_range' => '0 : +1',
+		'#required' => TRUE
+	);
+	$form['term_condition'] = array(
+		'#type' => 'checkboxes',
+		'#title' => t('Terms And Conditions'),
+		'#options' => array(
+			'status' => t('<a href="/term-and-conditions" target="_blank">I agree to the Terms and Conditions</a>')
+		),
+		'#required' => TRUE
+	);
+	$form['submit'] = array(
+		'#type' => 'submit',
+		'#value' => t('Submit')
+	);
+	return $form;
+}
+function cfd_case_study_proposal_form_validate($form, &$form_state)
+{
+	if ($form_state['values']['term_condition'] == '1')
+	{
+		form_set_error('term_condition', t('Please check the terms and conditions'));
+		// $form_state['values']['country'] = $form_state['values']['other_country'];
+	} //$form_state['values']['term_condition'] == '1'
+	if ($form_state['values']['country'] == 'Others')
+	{
+		if ($form_state['values']['other_country'] == '')
+		{
+			form_set_error('other_country', t('Enter country name'));
+			// $form_state['values']['country'] = $form_state['values']['other_country'];
+		} //$form_state['values']['other_country'] == ''
+		else
+		{
+			$form_state['values']['country'] = $form_state['values']['other_country'];
+		}
+		if ($form_state['values']['other_state'] == '')
+		{
+			form_set_error('other_state', t('Enter state name'));
+			// $form_state['values']['country'] = $form_state['values']['other_country'];
+		} //$form_state['values']['other_state'] == ''
+		else
+		{
+			$form_state['values']['all_state'] = $form_state['values']['other_state'];
+		}
+		if ($form_state['values']['other_city'] == '')
+		{
+			form_set_error('other_city', t('Enter city name'));
+			// $form_state['values']['country'] = $form_state['values']['other_country'];
+		} //$form_state['values']['other_city'] == ''
+		else
+		{
+			$form_state['values']['city'] = $form_state['values']['other_city'];
+		}
+	} //$form_state['values']['country'] == 'Others'
+	else
+	{
+		if ($form_state['values']['country'] == '')
+		{
+			form_set_error('country', t('Select country name'));
+			// $form_state['values']['country'] = $form_state['values']['other_country'];
+		} //$form_state['values']['country'] == ''
+		if ($form_state['values']['all_state'] == '')
+		{
+			form_set_error('all_state', t('Select state name'));
+			// $form_state['values']['country'] = $form_state['values']['other_country'];
+		} //$form_state['values']['all_state'] == ''
+		if ($form_state['values']['city'] == '')
+		{
+			form_set_error('city', t('Select city name'));
+			// $form_state['values']['country'] = $form_state['values']['other_country'];
+		} //$form_state['values']['city'] == ''
+	}
+	//Validation for project title
+	$form_state['values']['project_title'] = trim($form_state['values']['project_title']);
+	if ($form_state['values']['project_title'] != '')
+	{
+		if (strlen($form_state['values']['project_title']) > 250)
+		{
+			form_set_error('project_title', t('Maximum charater limit is 250 charaters only, please check the length of the project title'));
+		} //strlen($form_state['values']['project_title']) > 250
+		else if (strlen($form_state['values']['project_title']) < 10)
+		{
+			form_set_error('project_title', t('Minimum charater limit is 10 charaters, please check the length of the project title'));
+		} //strlen($form_state['values']['project_title']) < 10
+	} //$form_state['values']['project_title'] != ''
+	else
+	{
+		form_set_error('project_title', t('Project title shoud not be empty'));
+	}
+	if(strtotime(date($form_state['values']['expected_date_of_completion'])) < time())
+	{
+		form_set_error('expected_date_of_completion', t('Completion date should not be earlier than proposal date'));
+	}
+	
+if (isset($_FILES['files']))
+	{
+		/* check if atleast one source or result file is uploaded */
+		if (!($_FILES['files']['name']['abstract_file_path']))
+			form_set_error('abstract_file_path', t('Please upload the abstract file'));
+		/* check for valid filename extensions */
+		foreach ($_FILES['files']['name'] as $file_form_name => $file_name)
+		{
+			if ($file_name)
+			{
+				/* checking file type */
+				$allowed_extensions_str = variable_get('resource_upload_extensions', '');
+				$allowed_extensions = explode(',', $allowed_extensions_str);
+				$fnames = explode('.', strtolower($_FILES['files']['name'][$file_form_name]));
+				$temp_extension = end($fnames);
+				if (!in_array($temp_extension, $allowed_extensions))
+					form_set_error($file_form_name, t('Only file with ' . $allowed_extensions_str . ' extensions can be uploaded.'));
+				if ($_FILES['files']['size'][$file_form_name] <= 0)
+					form_set_error($file_form_name, t('File size cannot be zero.'));
+				/* check if valid file name */
+				if (!textbook_companion_check_valid_filename($_FILES['files']['name'][$file_form_name]))
+					form_set_error($file_form_name, t('Invalid file name specified. Only alphabets and numbers are allowed as a valid filename.'));
+			} //$file_name
+		} //$_FILES['files']['name'] as $file_form_name => $file_name
+	} 
+	return $form_state;
+}
+function cfd_case_study_proposal_form_submit($form, &$form_state)
+{
+	global $user;
+	$root_path = case_study_path();
+	if (!$user->uid)
+	{
+		drupal_set_message('It is mandatory to login on this website to access the proposal form', 'error');
+		return;
+	}
+	/* inserting the user proposal */
+	$v = $form_state["values"];
+	$project_title = trim($v['project_title']);
+	$proposar_name = $v['name_title'] . ' ' . $v['contributor_name'];
+	$university = $v['university'];
+	$directory_name = _df_dir_name($project_title, $proposar_name);
+	$result = "INSERT INTO {case_study_proposal} 
+    (
+    uid, 
+    approver_uid,
+    name_title, 
+    contributor_name,
+    contact_no,
+    university,
+    institute,
+    city, 
+    pincode, 
+    state, 
+    country,
+    project_title, 
+    directory_name,
+    approval_status,
+    is_completed, 
+    dissapproval_reason,
+    creation_date, 
+    expected_date_of_completion,
+    approval_date
+    ) VALUES
+    (
+    :uid, 
+    :approver_uid, 
+    :name_title, 
+    :contributor_name, 
+    :contact_no,
+    :university, 
+    :institute,
+    :city, 
+    :pincode, 
+    :state,  
+    :country,
+    :project_title, 
+    :directory_name,
+    :approval_status,
+    :is_completed, 
+    :dissapproval_reason,
+    :creation_date, 
+    :expected_date_of_completion,
+    :approval_date
+    )";
+	$args = array(
+		":uid" => $user->uid,
+		":approver_uid" => 0,
+		":name_title" => $v['name_title'],
+		":contributor_name" => _df_sentence_case(trim($v['contributor_name'])),
+		":contact_no" => $v['contributor_contact_no'],
+		":university" => _df_sentence_case($v['university']),
+		":institute" => _df_sentence_case($v['institute']),
+		":city" => $v['city'],
+		":pincode" => $v['pincode'],
+		":state" => $v['all_state'],
+		":country" => $v['country'],
+		":project_title" => _df_sentence_case($v['project_title']),
+		":directory_name" => $directory_name,
+		":approval_status" => 0,
+		":is_completed" => 0,
+		":dissapproval_reason" => "NULL",
+		":creation_date" => time(),
+		":expected_date_of_completion" => strtotime(date($v['expected_date_of_completion'])),
+		":approval_date" => 0
+		);
+	$result1 = db_query($result, $args, array(
+		'return' => Database::RETURN_INSERT_ID
+	));
+	//var_dump($result1->id);die;
+	$query_pro = db_select('case_study_proposal');
+	$query_pro->fields('case_study_proposal');
+	//$query_pro->condition('id', $proposal_data->id);
+	$abstracts_pro = $query_pro->execute()->fetchObject();
+	$proposal_id = $query_pro->id;
+	$dest_path = $directory_name . '/';
+	$dest_path1 = $root_path . $dest_path;
+	if (!is_dir($root_path . $dest_path))
+		mkdir($root_path . $dest_path);
+	/* uploading files */
+	foreach ($_FILES['files']['name'] as $file_form_name => $file_name)
+	{
+		if ($file_name)
+		{
+			/* checking file type */
+			//$file_type = 'S';
+			if (file_exists($root_path . $dest_path . $_FILES['files']['name'][$file_form_name]))
+			{
+				 drupal_set_message(t("Error uploading file. File !filename already exists.", array('!filename' => $_FILES['files']['name'][$file_form_name])), 'error');
+				//unlink($root_path . $dest_path . $_FILES['files']['name'][$file_form_name]);
+			} //file_exists($root_path . $dest_path . $_FILES['files']['name'][$file_form_name])
+			/* uploading file */
+			if (move_uploaded_file($_FILES['files']['tmp_name'][$file_form_name], $root_path . $dest_path . $_FILES['files']['name'][$file_form_name]))
+			{
+				$query_pro = db_select('case_study_proposal');
+	$query_pro->fields('case_study_proposal');
+	//$query_pro->condition('id', $proposal_data->id);
+	$abstracts_pro = $query_pro->execute()->fetchObject();
+	$proposal_id = $abstracts_pro->id;
+				//$proposal_id = $result1->id;
+				$query_abstracts = "INSERT INTO {case_study_submitted_abstracts} (
+	proposal_id,
+	approver_uid,
+	abstract_approval_status,
+	abstract_upload_date,
+	abstract_approval_date,
+	is_submitted) VALUES (:proposal_id, :approver_uid, :abstract_approval_status,:abstract_upload_date, :abstract_approval_date, :is_submitted)";
+		$args = array(
+			":proposal_id" => $proposal_id,
+			":approver_uid" => 0,
+			":abstract_approval_status" => 0,
+			":abstract_upload_date" => time(),
+			":abstract_approval_date" => 0,
+			":is_submitted" => 0
+		);
+		$submitted_abstract_id = db_query($query_abstracts, $args, array(
+			'return' => Database::RETURN_INSERT_ID
+		));
+			$query = "INSERT INTO {case_study_submitted_abstracts_file} (submitted_abstract_id, proposal_id, uid, approvar_uid, filename, filepath, filemime, filesize, filetype, timestamp)
+          VALUES (:submitted_abstract_id, :proposal_id, :uid, :approvar_uid, :filename, :filepath, :filemime, :filesize, :filetype, :timestamp)";
+							$args = array(
+								":submitted_abstract_id" => $submitted_abstract_id,
+								":proposal_id" => $proposal_id,
+								":uid" => $user->uid,
+								":approvar_uid" => 0,
+								":filename" => $_FILES['files']['name'][$file_form_name],
+								":filepath" => $_FILES['files']['name'][$file_form_name],
+								":filemime" => mime_content_type($root_path . $dest_path_project_files . $_FILES['files']['name'][$file_form_name]),
+								":filesize" => $_FILES['files']['size'][$file_form_name],
+								":filetype" => 'A',
+								":timestamp" => time()
+							);
+
+				/*$query = "UPDATE {case_study_proposal} SET abstract_file_path = :abstract_file_path WHERE id = :id";
+				$args = array(
+					":abstract_file_path" => $dest_path . $_FILES['files']['name'][$file_form_name],
+					":id" => $result1
+				);*/
+				
+				$updateresult = db_query($query, $args);
+				//var_dump($args);die;
+
+				drupal_set_message($file_name . ' uploaded successfully.', 'status');
+			} //move_uploaded_file($_FILES['files']['tmp_name'][$file_form_name], $root_path . $dest_path . $_FILES['files']['name'][$file_form_name])
+			else
+			{
+				drupal_set_message('Error uploading file : ' . $dest_path . '/' . $file_name, 'error');
+			}
+		} //$file_name
+	} //$_FILES['files']['name'] as $file_form_name => $file_name
+	if (!$result1)
+	{
+		drupal_set_message(t('Error receiving your proposal. Please try again.'), 'error');
+		return;
+	} //!$proposal_id
+	/* sending email */
+	$email_to = $user->mail;
+	$form = variable_get('case_study_from_email', '');
+	$bcc = variable_get('case_study_emails', '');
+	$cc = variable_get('case_study_cc_emails', '');
+	$params['case_study_proposal_received']['result1'] = $result1;
+	$params['case_study_proposal_received']['user_id'] = $user->uid;
+	$params['case_study_proposal_received']['headers'] = array(
+		'From' => $form,
+		'MIME-Version' => '1.0',
+		'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
+		'Content-Transfer-Encoding' => '8Bit',
+		'X-Mailer' => 'Drupal',
+		'Cc' => $cc,
+		'Bcc' => $bcc
+	);
+	if (!drupal_mail('case_study', 'case_study_proposal_received', $email_to, user_preferred_language($user), $params, $form, TRUE))
+		drupal_set_message('Error sending email message.', 'error');
+	drupal_set_message(t('We have received your case study proposal. We will get back to you soon.'), 'status');
+	drupal_goto('');
+}
+
+function case_study_path() {
+  return $_SERVER['DOCUMENT_ROOT'] . base_path() . 'uploads/case_study_uploads/';
+}
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
+}
diff --git a/settings.inc b/settings.inc
new file mode 100755
index 0000000..010f8e1
--- /dev/null
+++ b/settings.inc
@@ -0,0 +1,78 @@
+<?php
+// $Id$
+function cfd_case_study_settings_form($form, $form_state)
+{
+	$form['emails'] = array(
+		'#type' => 'textfield',
+		'#title' => t('(Bcc) Notification emails'),
+		'#description' => t('Specify emails id for Bcc option of mail system with comma separated'),
+		'#size' => 50,
+		'#maxlength' => 255,
+		'#required' => TRUE,
+		'#default_value' => variable_get('case_study_emails', '')
+	);
+	$form['cc_emails'] = array(
+		'#type' => 'textfield',
+		'#title' => t('(Cc) Notification emails'),
+		'#description' => t('Specify emails id for Cc option of mail system with comma separated'),
+		'#size' => 50,
+		'#maxlength' => 255,
+		'#required' => TRUE,
+		'#default_value' => variable_get('case_study_cc_emails', '')
+	);
+	$form['from_email'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Outgoing from email address'),
+		'#description' => t('Email address to be display in the from field of all outgoing messages'),
+		'#size' => 50,
+		'#maxlength' => 255,
+		'#required' => TRUE,
+		'#default_value' => variable_get('case_study_from_email', '')
+	);
+	$form['extensions']['resource_upload'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Allowed file extensions for uploading resource files'),
+		'#description' => t('A comma separated list WITHOUT SPACE of source file extensions that are permitted to be uploaded on the server'),
+		'#size' => 50,
+		'#maxlength' => 255,
+		'#required' => TRUE,
+		'#default_value' => variable_get('resource_upload_extensions', '')
+	);
+	$form['extensions']['abstract_upload'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Allowed file extensions for abstract'),
+		'#description' => t('A comma separated list WITHOUT SPACE of pdf file extensions that are permitted to be uploaded on the server'),
+		'#size' => 50,
+		'#maxlength' => 255,
+		'#required' => TRUE,
+		'#default_value' => variable_get('case_study_abstract_upload_extensions', '')
+	);
+	$form['extensions']['case_study_upload'] = array(
+		'#type' => 'textfield',
+		'#title' => t('Allowed extensions for project files'),
+		'#description' => t('A comma separated list WITHOUT SPACE of pdf file extensions that are permitted to be uploaded on the server'),
+		'#size' => 50,
+		'#maxlength' => 255,
+		'#required' => TRUE,
+		'#default_value' => variable_get('case_study_project_files_extensions', '')
+	);
+	$form['submit'] = array(
+		'#type' => 'submit',
+		'#value' => t('Submit')
+	);
+	return $form;
+}
+function cfd_case_study_settings_form_validate($form, &$form_state)
+{
+	return;
+}
+function cfd_case_study_settings_form_submit($form, &$form_state)
+{
+	variable_set('case_study_emails', $form_state['values']['emails']);
+	variable_set('case_study_cc_emails', $form_state['values']['cc_emails']);
+	variable_set('case_study_from_email', $form_state['values']['from_email']);
+	variable_set('resource_upload_extensions', $form_state['values']['resource_upload']);
+	variable_set('case_study_abstract_upload_extensions', $form_state['values']['abstract_upload']);
+	variable_set('case_study_project_files_extensions', $form_state['values']['case_study_upload']);
+	drupal_set_message(t('Settings updated'), 'status');
+}
diff --git a/upload_code.inc b/upload_code.inc
new file mode 100755
index 0000000..d95a226
--- /dev/null
+++ b/upload_code.inc
@@ -0,0 +1,401 @@
+<?php
+// $Id$
+function cfd_case_study_abstract()
+{
+	global $user;
+	$return_html = "";
+	$proposal_data = cfd_case_study_get_proposal();
+	if (!$proposal_data)
+	{
+		drupal_goto('');
+		return;
+	} //!$proposal_data
+	//$return_html .= l('Upload abstract', 'case-study-project/abstract-code/upload') . '<br />';
+	/* get experiment list */
+	$query = db_select('case_study_submitted_abstracts');
+	$query->fields('case_study_submitted_abstracts');
+	$query->condition('proposal_id', $proposal_data->id);
+	$abstracts_q = $query->execute()->fetchObject();
+	$query_pro = db_select('case_study_proposal');
+	$query_pro->fields('case_study_proposal');
+	$query_pro->condition('id', $proposal_data->id);
+	$abstracts_pro = $query_pro->execute()->fetchObject();
+	$query_pdf = db_select('case_study_submitted_abstracts_file');
+	$query_pdf->fields('case_study_submitted_abstracts_file');
+	$query_pdf->condition('proposal_id', $proposal_data->id);
+	$query_pdf->condition('filetype', 'A');
+	$abstracts_pdf = $query_pdf->execute()->fetchObject();
+	if ($abstracts_pdf == TRUE)
+	{
+		if ($abstracts_pdf->filename != "NULL" || $abstracts_pdf->filename != "")
+		{
+			$abstract_filename = $abstracts_pdf->filename;
+			//$abstract_filename = l($abstracts_pdf->filename, 'case-study-project/download/project-file/' . $proposal_data->id);
+		} //$abstracts_pdf->filename != "NULL" || $abstracts_pdf->filename != ""
+		else
+		{
+			$abstract_filename = "File not uploaded";
+		}
+	} //$abstracts_pdf == TRUE
+	else
+	{
+		$abstract_filename = "File not uploaded";
+	}
+	$query_process = db_select('case_study_submitted_abstracts_file');
+	$query_process->fields('case_study_submitted_abstracts_file');
+	$query_process->condition('proposal_id', $proposal_data->id);
+	$query_process->condition('filetype', 'S');
+	$abstracts_query_process = $query_process->execute()->fetchObject();
+	if ($abstracts_query_process == TRUE)
+	{
+		if ($abstracts_query_process->filename != "NULL" || $abstracts_query_process->filename != "")
+		{
+			$abstracts_query_process_filename = $abstracts_query_process->filename;
+			//$abstracts_query_process_filename = l($abstracts_query_process->filename, 'case-study-project/download/project-file/' . $proposal_data->id); 
+		} //$abstracts_query_process->filename != "NULL" || $abstracts_query_process->filename != ""
+		else
+		{
+			$abstracts_query_process_filename = "File not uploaded";
+		}
+		if ($abstracts_q->is_submitted == '')
+		{
+			$url = l('Upload abstract', 'case-study-project/abstract-code/upload');
+		} //$abstracts_q->is_submitted == ''
+		else if ($abstracts_q->is_submitted == 1)
+		{
+			$url = "";
+		} //$abstracts_q->is_submitted == 1
+		else if ($abstracts_q->is_submitted == 0)
+		{
+			$url = l('Edit', 'case-study-project/abstract-code/upload');
+		} //$abstracts_q->is_submitted == 0
+	} //$abstracts_query_process == TRUE
+	else
+	{
+		$url = l('Upload abstract', 'case-study-project/abstract-code/upload');
+		$abstracts_query_process_filename = "File not uploaded";
+	}
+	$return_html .= '<strong>Contributor Name:</strong><br />' . $proposal_data->name_title . ' ' . $proposal_data->contributor_name . '<br /><br />';
+	$return_html .= '<strong>Title of the Case Study Project:</strong><br />' . $proposal_data->project_title . '<br /><br />';
+	$return_html .= '<strong>Uploaded abstract of the project:</strong><br />' . $abstract_filename . '<br /><br />';
+	$return_html .= '<strong>Uploaded project files:</strong><br />' . $abstracts_query_process_filename . '<br /><br />';
+	$return_html .= $url . '<br />';
+	return $return_html;
+}
+function cfd_case_study_upload_abstract_code_form($form, &$form_state)
+{
+	global $user;
+	$form['#attributes'] = array(
+		'enctype' => "multipart/form-data"
+	);
+	/* get current proposal */
+	//$proposal_id = (int) arg(3);
+	$uid = $user->uid;
+	$query = db_select('case_study_proposal');
+	$query->fields('case_study_proposal');
+	$query->condition('uid', $uid);
+	$query->condition('approval_status', '1');
+	$proposal_q = $query->execute();
+	if ($proposal_q)
+	{
+		if ($proposal_data = $proposal_q->fetchObject())
+		{
+			/* everything ok */
+		} //$proposal_data = $proposal_q->fetchObject()
+		else
+		{
+			drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+			drupal_goto('case-study-project/abstract-code');
+			return;
+		}
+	} //$proposal_q
+	else
+	{
+		drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+		drupal_goto('case-study-project/abstract-code');
+		return;
+	}
+	$query = db_select('case_study_submitted_abstracts');
+	$query->fields('case_study_submitted_abstracts');
+	$query->condition('proposal_id', $proposal_data->id);
+	$abstracts_q = $query->execute()->fetchObject();
+	if ($abstracts_q)
+	{
+		if ($abstracts_q->is_submitted == 1)
+		{
+			drupal_set_message(t('You have already submited your project files, hence you can not upload more code, for any query please write to us.'), 'error', $repeat = FALSE);
+			drupal_goto('case-study-project/abstract-code');
+			//return;
+		} //$abstracts_q->is_submitted == 1
+	} //$abstracts_q->is_submitted == 1
+	$form['project_title'] = array(
+		'#type' => 'item',
+		'#markup' => $proposal_data->project_title,
+		'#title' => t('Title of the Case Study Project')
+	);
+	$form['contributor_name'] = array(
+		'#type' => 'item',
+		'#markup' => $proposal_data->contributor_name,
+		'#title' => t('Contributor Name')
+	);
+	$existing_uploaded_S_file = default_value_for_uploaded_files("S", $proposal_data->id);
+	if (!$existing_uploaded_S_file)
+	{
+		$existing_uploaded_S_file = new stdClass();
+		$existing_uploaded_S_file->filename = "No file uploaded";
+	} //!$existing_uploaded_S_file
+	$form['upload_case_study_developed_process'] = array(
+		'#type' => 'file',
+		'#title' => t('Upload the Project Files'),
+		//'#required' => TRUE,
+		'#description' => t('<span style="color:red;">Current File :</span> ' . $existing_uploaded_S_file->filename . '<br />Separate filenames with underscore. No spaces or any special characters allowed in filename.') . '<br />' . t('<span style="color:red;">Allowed file extensions : ') . variable_get('case_study_project_files_extensions', '') . '</span>'
+	);
+	$form['prop_id'] = array(
+		'#type' => 'hidden',
+		'#value' => $proposal_data->id
+	);
+	$form['submit'] = array(
+		'#type' => 'submit',
+		'#value' => t('Submit'),
+		'#submit' => array(
+			'cfd_case_study_upload_abstract_code_form_submit'
+		)
+	);
+	$form['cancel'] = array(
+		'#type' => 'item',
+		'#markup' => l(t('Cancel'), 'case-study-project/abstract-code')
+	);
+	return $form;
+}
+
+///////////////////////////////////////////////////////////////
+function cfd_case_study_upload_abstract_code_form_validate($form, &$form_state)
+{
+	//var_dump($form);die;
+	if (isset($_FILES['files']))
+	{
+		/* check if atleast one source or result file is uploaded */
+		if (!($_FILES['files']['name']['upload_case_study_developed_process']))
+			form_set_error('upload_case_study_developed_process', t('Please upload the abstract file'));
+		/* check for valid filename extensions */
+		foreach ($_FILES['files']['name'] as $file_form_name => $file_name)
+		{
+			if ($file_name)
+			{
+				/* checking file type */
+				$allowed_extensions_str = variable_get('case_study_project_files_extensions', '');
+				$allowed_extensions = explode(',', $allowed_extensions_str);
+				$fnames = explode('.', strtolower($_FILES['files']['name'][$file_form_name]));
+				$temp_extension = end($fnames);
+				if (!in_array($temp_extension, $allowed_extensions))
+					form_set_error($file_form_name, t('Only file with ' . $allowed_extensions_str . ' extensions can be uploaded.'));
+				if ($_FILES['files']['size'][$file_form_name] <= 0)
+					form_set_error($file_form_name, t('File size cannot be zero.'));
+				/* check if valid file name */
+				if (!cfd_case_study_check_valid_filename($_FILES['files']['name'][$file_form_name]))
+					form_set_error($file_form_name, t('Invalid file name specified. Only alphabets and numbers are allowed as a valid filename.'));
+			} //$file_name
+		} //$_FILES['files']['name'] as $file_form_name => $file_name
+	} 
+	return $form_state;
+}
+function cfd_case_study_upload_abstract_code_form_submit($form, &$form_state)
+{
+	global $user;
+	$v = $form_state['values'];
+	$root_path = cfd_case_study_path();
+	$proposal_data = cfd_case_study_get_proposal();
+	$proposal_id = $proposal_data->id;
+	if (!$proposal_data)
+	{
+		drupal_goto('');
+		return;
+	} //!$proposal_data
+	$proposal_id = $proposal_data->id;
+	$proposal_directory = $proposal_data->directory_name;
+	/* create proposal folder if not present */
+	//$dest_path = $proposal_directory . '/';
+	$dest_path_project_files = $proposal_directory . '/';
+	$proposal_id = $proposal_data->id;
+	$query_s = "SELECT * FROM {case_study_submitted_abstracts} WHERE proposal_id = :proposal_id";
+	$args_s = array(
+		":proposal_id" => $proposal_id
+	);
+	$query_s_result = db_query($query_s, $args_s)->fetchObject();
+	if (!$query_s_result)
+	{
+		/* creating solution database entry */
+		$query = "INSERT INTO {case_study_submitted_abstracts} (
+	proposal_id,
+	approver_uid,
+	abstract_approval_status,
+	abstract_upload_date,
+	abstract_approval_date,
+	is_submitted) VALUES (:proposal_id, :approver_uid, :abstract_approval_status,:abstract_upload_date, :abstract_approval_date, :is_submitted)";
+		$args = array(
+			":proposal_id" => $proposal_id,
+			":approver_uid" => 0,
+			":abstract_approval_status" => 0,
+			":abstract_upload_date" => time(),
+			":abstract_approval_date" => 0,
+			":is_submitted" => 1
+		);
+		$submitted_abstract_id = db_query($query, $args, array(
+			'return' => Database::RETURN_INSERT_ID
+		));
+		$query1 = "UPDATE {case_study_proposal} SET is_submitted = :is_submitted WHERE id = :id";
+		$args1 = array(
+			":is_submitted" => 1,
+			":id" => $proposal_id
+		);
+		db_query($query1,$args1);
+		drupal_set_message('Abstract uploaded successfully.', 'status');
+	} //!$query_s_result
+	else
+	{
+		$query = "UPDATE {case_study_submitted_abstracts} SET 
+
+	
+	abstract_upload_date =:abstract_upload_date,
+	is_submitted= :is_submitted 
+	WHERE proposal_id = :proposal_id
+	";
+		$args = array(
+			
+			":abstract_upload_date" => time(),
+			":is_submitted" => 1,
+			":proposal_id" => $proposal_id
+		);
+		$submitted_abstract_id = db_query($query, $args, array(
+			'return' => Database::RETURN_INSERT_ID
+		));
+		$query1 = "UPDATE {case_study_proposal} SET is_submitted = :is_submitted WHERE id = :id";
+		$args1 = array(
+			":is_submitted" => 1,
+			":id" => $proposal_id
+		);
+		db_query($query1,$args1);
+		drupal_set_message('Abstract updated successfully.', 'status');
+	}
+	foreach ($_FILES['files']['name'] as $file_form_name => $file_name)
+	{
+		if ($file_name)
+		{
+			/* checking file type */
+			if (strstr($file_form_name, 'upload_case_study_developed_process'))
+			{
+				$file_type = 'S';
+			} //strstr($file_form_name, 'upload_case_study_developed_process')
+			switch ($file_type)
+			{
+				case 'S':
+
+					if (file_exists($root_path . $dest_path_project_files . $_FILES['files']['name'][$file_form_name]))
+					{
+						//unlink($root_path . $dest_path . $_FILES['files']['name'][$file_form_name]);
+						drupal_set_message(t("File !filename already exists hence overwirtten the exisitng file ", array(
+							'!filename' => $_FILES['files']['name'][$file_form_name]
+						)), 'error');
+					} //file_exists($root_path . $dest_path . $_FILES['files']['name'][$file_form_name])
+					/* uploading file */
+					else if (move_uploaded_file($_FILES['files']['tmp_name'][$file_form_name], $root_path . $dest_path_project_files . $_FILES['files']['name'][$file_form_name]))
+					{
+						/* for uploaded files making an entry in the database */
+						$query_abstracts = "SELECT * FROM case_study_submitted_abstracts WHERE proposal_id = :proposal_id";
+						$query_abstracts_args = array(
+							":proposal_id" => $proposal_id
+							);
+						$query_abstracts_result = db_query($query_abstracts, $query_abstracts_args)->fetchObject();
+						$submitted_abstract_id = $query_abstracts_result->id;
+						$query_ab_f = "SELECT * FROM case_study_submitted_abstracts_file WHERE proposal_id = :proposal_id AND filetype = 
+				:filetype";
+						$args_ab_f = array(
+							":proposal_id" => $proposal_id,
+							":filetype" => $file_type
+						);
+						$query_ab_f_result = db_query($query_ab_f, $args_ab_f)->fetchObject();
+						if (!$query_ab_f_result)
+						{
+							$query = "INSERT INTO {case_study_submitted_abstracts_file} (submitted_abstract_id, proposal_id, uid, approvar_uid, filename, filepath, filemime, filesize, filetype, timestamp)
+          VALUES (:submitted_abstract_id, :proposal_id, :uid, :approvar_uid, :filename, :filepath, :filemime, :filesize, :filetype, :timestamp)";
+							$args = array(
+								":submitted_abstract_id" => $submitted_abstract_id,
+								":proposal_id" => $proposal_id,
+								":uid" => $user->uid,
+								":approvar_uid" => 0,
+								":filename" => $_FILES['files']['name'][$file_form_name],
+								":filepath" => $_FILES['files']['name'][$file_form_name],
+								":filemime" => mime_content_type($root_path . $dest_path_project_files . $_FILES['files']['name'][$file_form_name]),
+								":filesize" => $_FILES['files']['size'][$file_form_name],
+								":filetype" => $file_type,
+								":timestamp" => time()
+							);
+							db_query($query, $args, array('return' => Database::RETURN_INSERT_ID));
+							drupal_set_message($file_name . ' uploaded successfully.', 'status');
+						} //!$query_ab_f_result
+						else
+						{
+							unlink($root_path . $dest_path_project_files . $query_ab_f_result->filename);
+							$query = "UPDATE {case_study_submitted_abstracts_file} SET filename = :filename, filepath=:filepath, filemime=:filemime, filesize=:filesize, timestamp=:timestamp WHERE proposal_id = :proposal_id AND filetype = :filetype";
+							$args = array(
+								":filename" => $_FILES['files']['name'][$file_form_name],
+								":filepath" => $file_path . $_FILES['files']['name'][$file_form_name],
+								":filemime" => mime_content_type($root_path . $dest_path_project_files . $_FILES['files']['name'][$file_form_name]),
+								":filesize" => $_FILES['files']['size'][$file_form_name],
+								":timestamp" => time(),
+								":proposal_id" => $proposal_id,
+								":filetype" => $file_type
+							);
+							db_query($query, $args, array('return' => Database::RETURN_INSERT_ID
+	));
+
+							drupal_set_message($file_name . ' file updated successfully.', 'status');
+						}
+					} //move_uploaded_file($_FILES['files']['tmp_name'][$file_form_name], $root_path . $dest_path . $_FILES['files']['name'][$file_form_name])
+					else
+					{
+						drupal_set_message('Error uploading file : ' . $dest_path_project_files . $file_name, 'error');
+					}
+					break;
+			} //$file_type
+		} //$file_name
+	} //$_FILES['files']['name'] as $file_form_name => $file_name
+	/* sending email */
+	$email_to = $user->mail;
+	$from = variable_get('case_study_from_email', '');
+	$bcc = variable_get('case_study_emails', '');
+	$cc = variable_get('case_study_cc_emails', '');
+	$params['abstract_uploaded']['proposal_id'] = $proposal_id;
+	$params['abstract_uploaded']['submitted_abstract_id'] = $submitted_abstract_id;
+	$params['abstract_uploaded']['user_id'] = $user->uid;
+	$params['abstract_uploaded']['headers'] = array(
+		'From' => $from,
+		'MIME-Version' => '1.0',
+		'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
+		'Content-Transfer-Encoding' => '8Bit',
+		'X-Mailer' => 'Drupal',
+		'Cc' => $cc,
+		'Bcc' => $bcc
+	);
+	if (!drupal_mail('case_study', 'abstract_uploaded', $email_to, language_default(), $params, $from, TRUE))
+		drupal_set_message('Error sending email message.', 'error');
+	drupal_goto('case-study-project/abstract-code');
+}
+function default_value_for_uploaded_files($filetype, $proposal_id)
+{
+	$query = db_select('case_study_submitted_abstracts_file');
+	$query->fields('case_study_submitted_abstracts_file');
+	$query->condition('proposal_id', $proposal_id);
+	$selected_files_array = "";
+	if ($filetype == "S")
+	{
+		$query->condition('filetype', $filetype);
+		$filetype_q = $query->execute()->fetchObject();
+		return $filetype_q;
+	}
+	else
+	{
+		return;
+	}
+	return;
+}