Created proposal form

1 files changed, 95 insertions, 0 deletions

diff --git a/upload_code_delete.inc b/upload_code_delete.inc
new file mode 100755
index 0000000..0c63e5f
--- /dev/null
+++ b/upload_code_delete.inc
@@ -0,0 +1,95 @@
+<?php
+
+/******************************************************************************/
+/***************************** DELETE CODE ************************************/
+/******************************************************************************/
+
+function lab_migration_upload_code_delete()
+{
+  global $user;
+
+  $root_path = lab_migration_path();
+  $solution_id = (int)arg(3);
+
+  /* check solution */
+ // $solution_q = db_query("SELECT * FROM {lab_migration_solution} WHERE id = %d LIMIT 1", $solution_id);
+  $query = db_select('lab_migration_solution');
+              $query->fields('lab_migration_solution');
+              $query->condition('id', $solution_id);
+              $query->range(0, 1);
+              $solution_q = $query->execute();
+  $solution_data = $solution_q->fetchObject();
+  if (!$solution_data)
+  {
+    drupal_set_message('Invalid solution.', 'error');
+    drupal_goto('lab-migration/code');
+    return;
+  }
+  if ($solution_data->approval_status != 0)
+  {
+    drupal_set_message('You cannnot delete a solution after it has been approved. Please contact site administrator if you want to delete this solution.', 'error');
+    drupal_goto('lab-migration/code');
+    return;
+  }
+
+  //$experiment_q = db_query("SELECT * FROM {lab_migration_experiment} WHERE id = %d LIMIT 1", $solution_data->experiment_id);
+  $query = db_select('lab_migration_experiment');
+            $query->fields('lab_migration_experiment');
+            $query->condition('id', $solution_data->experiment_id);
+            $query->range(0, 1);
+            $experiment_q = $query->execute();
+
+  $experiment_data = $experiment_q->fetchObject();
+  if (!$experiment_data)
+  {
+    drupal_set_message('You do not have permission to delete this solution.', 'error');
+    drupal_goto('lab-migration/code');
+    return;
+  }
+
+  //$proposal_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE id = %d AND solution_provider_uid = %d LIMIT 1", $experiment_data->proposal_id, $user->uid);
+  $query = db_select('lab_migration_proposal');
+              $query->fields('lab_migration_proposal');
+              $query->condition('id', $experiment_data->proposal_id);
+              $query->condition('solution_provider_uid', $user->uid);
+              $query->range(0, 1);
+              $proposal_q = $query->execute();
+  $proposal_data = $proposal_q->fetchObject();
+  if (!$proposal_data)
+  {
+    drupal_set_message('You do not have permission to delete this solution.', 'error');
+    drupal_goto('lab-migration/code');
+    return;
+  }
+
+  /* deleting solution files */
+  if (lab_migration_delete_solution($solution_data->id))
+  {
+    drupal_set_message('Solution deleted.', 'status');
+
+    /* sending email */
+    $email_to = $user->mail;
+
+    $from = variable_get('lab_migration_from_email', '');
+    $bcc= variable_get('lab_migration_emails', '');
+    $cc=variable_get('lab_migration_cc_emails', '');  
+
+    $param['solution_deleted_user']['lab_title'] = $proposal_data->lab_title;
+    $param['solution_deleted_user']['experiment_title'] = $experiment_data->title;
+    $param['solution_deleted_user']['solution_number'] = $solution_data->code_number;
+    $param['solution_deleted_user']['solution_caption'] = $solution_data->caption;
+    $param['solution_deleted_user']['user_id'] = $user->uid;
+    $param['solution_deleted_user']['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('lab_migration', 'solution_deleted_user', $email_to, language_default(), $param , $from , TRUE))
+      drupal_set_message('Error sending email message.', 'error');
+  } else {
+    drupal_set_message('Error deleting example.', 'status');
+  }
+
+  drupal_goto('lab-migration/code');
+  return;
+}