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
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
|
<?php
// $Id$
/******************************************************************************/
/***************************** BOOK NOTES *************************************/
/******************************************************************************/
function lab_migration_lab_notes_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 LIMIT 1", $proposal_id);
$query = db_select('lab_migration_proposal');
$query->fields('lab_migration_proposal');
$query->condition('id', $proposal_id);
$query->range(0, 1);
$proposal_q = $query->execute();
$proposal_data = $proposal_q->fetchObject();
if (!$proposal_data)
{
drupal_set_message(t('Invalid lab selected. Please try again.'), 'error');
drupal_goto('lab_migration/code_approval');
return;
}
/* get current notes */
$notes = '';
//$notes_q = db_query("SELECT * FROM {lab_migration_notes} WHERE proposal_id = %d LIMIT 1", $proposal_id);
$query = db_select('lab_migration_notes');
$query->fields('lab_migration_notes');
$query->condition('proposal_id', $proposal_id);
$query->range(0, 1);
$notes_q = $query->execute();
if ($notes_q)
{
$notes_data = $notes_q->fetchObject();
$notes = $notes_data->notes;
}
$form['lab_details'] = array(
'#type' => 'item',
'#value' => '<span style="color: rgb(128, 0, 0);"><strong>About the Lab</strong></span><br />' .
'<strong>Proposer:</strong> ' . $proposal_data->name . '<br />' .
'<strong>Title of the Lab:</strong> ' . $proposal_data->lab_title . '<br />'
);
$form['notes'] = array(
'#type' => 'textarea',
'#rows' => 20,
'#title' => t('Notes for Reviewers'),
'#default_value' => $notes,
);
$form['submit'] = array(
'#type' => 'submit',
'#value' => t('Submit')
);
$form['cancel'] = array(
'#type' => 'markup',
'#value' => l(t('Back'), 'lab_migration/code_approval'),
);
return $form;
}
function lab_migration_lab_notes_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 LIMIT 1", $proposal_id);
$query = db_select('lab_migration_proposal');
$query->fields('lab_migration_proposal');
$query->condition('id', $proposal_id);
$query->range(0, 1);
$proposal_q = $query->execute();
$proposal_data = $proposal_q->fetchObject();
if (!$proposal_data)
{
drupal_set_message(t('Invalid lab selected. Please try again.'), 'error');
drupal_goto('lab_migration/code_approval');
return;
}
/* find existing notes */
//$notes_q = db_query("SELECT * FROM {lab_migration_notes} WHERE proposal_id = %d LIMIT 1", $proposal_id);
$query = db_select('lab_migration_notes');
$query->fields('lab_migration_notes');
$query->condition('proposal_id', $proposal_id);
$query->range(0, 1);
$notes_q = $query->execute();
$notes_data = $notes_q->fetchObject();
/* add or update notes in database */
if ($notes_data) {
$query = "UPDATE {lab_migration_notes} SET notes = :notes WHERE id = :notes_id";
$args = array(
":notes" => $form_state['values']['notes'],
":notes_id" => $notes_data->id,
);
db_query($query, $args);
drupal_set_message('Notes updated successfully.', 'status');
} else {
$query = "INSERT INTO {lab_migration_notes} (proposal_id, notes) VALUES (:proposal_id, :notes)";
$args = array(
":proposal_id" => $proposal_id,
":notes" =>$form_state['values']['notes'],
);
db_query($query, $args);
drupal_set_message('Notes added successfully.', 'status');
}
}
|
