1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
|
<?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;
}
?>
|
