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
|
$pending_rows = array();
$pending_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE proposal_status = 0 ORDER BY id DESC");
while ($pending_data = db_fetch_object($pending_q))
{
$pending_rows[$pending_data->id] = array(date('d-m-Y', $pending_data->creation_date), l($pending_data->full_name, 'user/' . $pending_data->uid), date('d-m-Y', $pending_data->completion_date), l('Approve', 'manage_proposal/approve/' . $pending_data->id) . ' | ' . l('Edit', 'manage_proposal/edit/' . $pending_data->id));
}
/* check if there are any pending proposals */
if (!$pending_rows)
{
drupal_set_message(t('There are no pending proposals.'), 'status');
return '';
}
$pending_header = array('Date of Submission', 'Contributor Name', 'Date of Completion', 'Action');
$output = theme_table($pending_header, $pending_rows);
return $output;
global $user;
$uid1 = $user->uid;
$query2 = db_query("SELECT * FROM {textbook_companion_proposal} WHERE proposal_status=3 AND uid=".$user->uid);
$data2 = db_fetch_object($query2);
if($data2->id)
{
$search_rows = array();
$output = '';
$query3 = db_query("SELECT * FROM textbook_companion_preference WHERE approval_status=1 AND proposal_id=".$data2->id);
while ($search_data3 = db_fetch_object($query3))
{
$search_rows[] = array($search_data3->id,$search_data3->proposal_id,$search_data3->book, l('Download Certificate', 'certificate/generate_pdf'.$search_data3->proposal_id));
}
if ($search_rows)
{
$search_header = array('Id', 'Proposal Id', 'Book Name', 'Download Certificates');
$output .= theme_table($search_header, $search_rows);
}
else
{
echo("Error");
}
return $output;
}
else
{
echo("Book Still Under Review");
};
|
