Initial repo

1 files changed, 270 insertions, 0 deletions

diff --git a/manage_solution_proposal.inc b/manage_solution_proposal.inc
new file mode 100755
index 0000000..2bace0c
--- /dev/null
+++ b/manage_solution_proposal.inc
@@ -0,0 +1,270 @@
+<?php
+// $Id$
+
+function lab_migration_solution_proposal_pending()
+{
+  /* get list of solution proposal where the solution_provider_uid is set to some userid except 0 and solution_status is also 1 */
+  $pending_rows = array();
+  //$pending_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE solution_provider_uid != 0 AND solution_status = 1 ORDER BY id DESC");
+  $query = db_select('lab_migration_proposal');
+            $query->fields('lab_migration_proposal');
+            $query->condition('solution_provider_uid', 0, '!=');
+            $query->condition('solution_status', 1);
+            $query->orderBy('id', 'DESC');
+            $pending_q = $query->execute();
+  while ($pending_data = $pending_q->fetchObject())
+  {
+    $pending_rows[$pending_data->id] = array(l($pending_data->name, 'user/' . $pending_data->uid), $pending_data->lab_title, l('Approve', 'lab_migration/manage_proposal/solution_proposal_approve/' . $pending_data->id));
+  }
+
+  /* check if there are any pending proposals */
+  if (!$pending_rows)
+  {
+    drupal_set_message(t('There are no pending solution proposals.'), 'status');
+    return '';
+  }
+
+  $pending_header = array('Proposer Name', 'Title of the Lab', 'Action');  
+  $output = theme('table', array('header' => $pending_header, 'rows' => $pending_rows ));
+  return $output; 
+}
+
+/******************************************************************************/
+/***************** SOLUTION PROPOSAL APPROVAL FORM ****************************/
+/******************************************************************************/
+
+function lab_migration_solution_proposal_approval_form($form_state)
+{
+  global $user;
+
+  /* get current proposal */
+  $proposal_id = (int)arg(3);
+ // $proposal_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE id = %d", $proposal_id);
+  $query = db_select('lab_migration_proposal');
+            $query->fields('lab_migration_proposal');
+            $query->condition('id', $proposal_id);
+            $proposal_q = $query->execute();
+  if ($proposal_q)
+  {
+    if ($proposal_data = $proposal_q->fetchObject())
+    {
+      /* everything ok */
+    } else {
+      drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+      drupal_goto('lab_migration/manage_proposal/pending_solution_proposal');
+      return;
+    }
+  } else {
+    drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+    drupal_goto('lab_migration/manage_proposal/pending_solution_proposal');
+    return;
+  }
+
+  $form['name'] = array(
+    '#type' => 'item',
+    '#markup' => l($proposal_data->name_title . ' ' . $proposal_data->name, 'user/' . $proposal_data->uid),
+    '#title' => t('Proposer Name'),
+  );
+  $form['email_id'] = array(
+    '#type' => 'item',
+    '#markup' => user_load($proposal_data->uid)->mail,
+    '#title' => t('Email'),
+  );
+  $form['contact_ph'] = array(
+    '#type' => 'item',
+    '#markup' => $proposal_data->contact_ph,
+    '#title' => t('Contact No.'),
+  );
+  $form['department'] = array(
+    '#type' => 'item',
+    '#markup' => $proposal_data->department,
+    '#title' => t('Department/Branch'),
+  );
+  $form['university'] = array(
+    '#type' => 'item',
+    '#markup' => $proposal_data->university,
+    '#title' => t('University/Institute'),
+  );
+  $form['lab_title'] = array(
+    '#type' => 'item',
+    '#markup' => $proposal_data->lab_title,
+    '#title' => t('Title of the Lab'),
+  );
+
+  /* get experiment details */
+  $experiment_list = '<ul>';
+  //$experiment_q = db_query("SELECT * FROM {lab_migration_experiment} WHERE proposal_id = %d ORDER BY id ASC", $proposal_id);
+  $query = db_select('lab_migration_experiment');
+            $query->fields('lab_migration_experiment');
+            $query->condition('proposal_id', $proposal_id);
+            $query->orderBy('id', 'ASC');
+            $experiment_q = $query->execute();
+  while ($experiment_data = $experiment_q->fetchObject())
+  {
+    $experiment_list .= '<li>' . $experiment_data->title . '</li>Description of Experiment : '.$experiment_data->description.'<br>';;
+  }
+  $experiment_list .= '</ul>';
+
+  $form['experiment'] = array(
+      '#type' => 'item',
+      '#markup' => $experiment_list,
+      '#title' => t('Experiments'),
+  );
+
+  $form['solution_display'] = array(
+	  '#type' => 'item',
+		'#title' => t('Display the solution on the www.esim.fossee.in website'),
+		'#markup' => ($proposal_data->solution_display == 1) ? "Yes" : "No",
+  );
+
+  if ($proposal_data->solution_provider_uid == 0) {
+  	$solution_provider = "Open";
+  } else if ($proposal_data->solution_provider_uid == $proposal_data->uid) {
+  	$solution_provider = "Proposer will provide the solution of the lab";
+  } else {
+  	$solution_provider_user_data = user_load($proposal_data->solution_provider_uid);
+  	if ($solution_provider_user_data) {
+  		$solution_provider .= '<ul>' .
+        '<li><strong>Solution Provider:</strong> ' . l($solution_provider_user_data->name, 'user/' . $proposal_data->solution_provider_uid) . '</li>' .
+        '<li><strong>Solution Provider Name:</strong> ' . $proposal_data->solution_provider_name_title . ' ' . $proposal_data->solution_provider_name . '</li>' .
+        '<li><strong>Department:</strong> ' . $proposal_data->solution_provider_department . '</li>' .
+        '<li><strong>University:</strong> ' . $proposal_data->solution_provider_university . '</li>' .
+        '</ul>';
+  	} else {
+  		$solution_provider = "User does not exists";
+  	}
+  }
+  $form['solution_provider_uid'] = array(
+	  '#type' => 'item',
+		'#title' => t('Solution Provider'),
+		'#markup' => $solution_provider,
+  );
+
+  $form['approval'] = array(
+	  '#type' => 'radios',
+		'#title' => t('Solution Provider'),
+		'#options' => array('1' => 'Approve', '2' => 'Disapprove'),
+		'#required' => TRUE,
+	);
+
+  $form['message'] = array(	
+    '#type' => 'textarea',
+    '#title' => t('Reason for disapproval'),
+  );
+
+  $form['submit'] = array(
+    '#type' => 'submit',
+    '#value' => t('Submit')
+  );
+
+  $form['cancel'] = array(
+    '#type' => 'markup',
+    '#value' => l(t('Cancel'), 'lab_migration/manage_proposal/pending_solution_proposal'),
+  );
+
+  return $form;
+}
+
+function lab_migration_solution_proposal_approval_form_validate($form, &$form_state)
+{
+  $proposal_id = (int)arg(3);
+
+ // $solution_provider_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE id = %d", $proposal_id);
+  $query = db_select('lab_migration_proposal');
+          $query->fields('lab_migration_proposal');
+          $query->condition('id', $proposal_id);
+          $solution_provider_q = $query->execute();
+  $solution_provider_data = $solution_provider_q->fetchObject();
+
+ //	$solution_provider_present_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE solution_provider_uid = %d AND approval_status IN (0, 1) AND id != %d", $solution_provider_data->uid, $proposal_id);
+
+  $query = db_select('lab_migration_proposal');
+            $query->fields('lab_migration_proposal');
+            $query->condition('solution_provider_uid', $solution_provider_data->uid);
+            $query->condition('approval_status', array(0, 1), 'IN');
+            $query->condition('id', $proposal_id, '<>');
+            $solution_provider_present_q = $query->execute();
+	if ($x = $solution_provider_present_q->fetchObject()) {
+		drupal_set_message($proposal_id);
+		form_set_error('', t('Solution provider has already one proposal active'));
+	}
+}
+
+function lab_migration_solution_proposal_approval_form_submit($form, &$form_state)
+{
+	global $user;
+
+  /* get current proposal */
+  $proposal_id = (int)arg(3);
+  //$proposal_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE id = %d", $proposal_id);
+  $query = db_select('lab_migration_proposal');
+           $query->fields('lab_migration_proposal');
+           $query->condition('id', $proposal_id);
+           $proposal_q = $query->execute();
+  if ($proposal_q)
+  {
+    if ($proposal_data = $proposal_q->fetchObject())
+    {
+      /* everything ok */
+    } else {
+      drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+      drupal_goto('lab_migration/manage_proposal/pending_solution_proposal');
+      return;
+    }
+  } else {
+    drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+    drupal_goto('lab_migration/manage_proposal/pending_solution_proposal');
+    return;
+  }
+
+  $user_data = user_load($proposal_data->solution_provider_uid);
+
+  if ($form_state['values']['approval'] == 1) {
+  	$query = "UPDATE {lab_migration_proposal} SET solution_status = 2 WHERE id =:proposal_id";
+    $args = array(
+                   ":proposal_id" => $proposal_id
+            );
+    db_query($query, $args);
+
+    /* sending email */
+    $email_to = $user_data->mail;
+    $param['solution_proposal_approved']['proposal_id'] = $proposal_id;
+    $param['solution_proposal_approved']['user_id'] = $proposal_data->solution_provider_uid;
+    if (!drupal_mail('lab_migration', 'solution_proposal_approved', $email_to , language_default(), $param, variable_get('lab_migration_from_email', NULL), TRUE))
+      drupal_set_message('Error sending email message.', 'error');
+
+    $email_to = $user->mail . ', ' . variable_get('lab_migration_emails', '');
+    if (!drupal_mail('lab_migration', 'solution_proposal_approved', $email_to , language_default(), $param, variable_get('lab_migration_from_email', NULL), TRUE))
+      drupal_set_message('Error sending email message.', 'error');
+
+    drupal_set_message('Lab migration solution proposal approved. User has been notified of the approval.', 'status');
+    drupal_goto('lab_migration/manage_proposal/pending_solution_proposal');
+    return;
+  } else if ($form_state['values']['approval'] == 2) {
+    $query = "UPDATE {lab_migration_proposal} SET solution_provider_uid = :solution_provider_uid, solution_status = :solution_status, solution_provider_name_title = '', solution_provider_name = '', solution_provider_contact_ph = '', solution_provider_department = '', solution_provider_university = '' WHERE id = :proposal_id";
+
+        $args = array( 
+                   ":solution_provider_uid" => 0,
+                   ":solution_status" => 0,                  
+                   ":proposal_id" => $proposal_id
+                );
+    db_query($query, $args);
+
+    /* sending email */
+    $email_to = $user_data->mail;
+    $param['solution_proposal_disapproved']['proposal_id'] = $proposal_id;
+    $param['solution_proposal_disapproved']['user_id'] = $proposal_data->solution_provider_uid;
+    $param['solution_proposal_disapproved']['message'] = $form_state['values']['message'];
+    if (!drupal_mail('lab_migration', 'solution_proposal_disapproved', $email_to , language_default(), $param, variable_get('lab_migration_from_email', NULL), TRUE))
+      drupal_set_message('Error sending email message.', 'error');
+
+    $email_to = $user->mail . ', ' . variable_get('lab_migration_emails', '');;
+    if (!drupal_mail('lab_migration', 'solution_proposal_disapproved', $email_to , language_default(), $param, variable_get('lab_migration_from_email', NULL), TRUE))
+      drupal_set_message('Error sending email message.', 'error');
+
+    drupal_set_message('Lab migration solution proposal dis-approved. User has been notified of the dis-approval.', 'status');
+    drupal_goto('lab_migration/manage_proposal/pending_solution_proposal');
+    return;
+  }
+}
+