blob: 285e12c2b349aa465bd4c96691760c03b695eb0e (
plain)
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
|
<?php
// $Id$
function migrated_labs()
{
global $user;
$dl_root_path = 'sites/default/files/lab_migration/';
/* get pending proposals to be approved */
$labs_rows = array();
$labs_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE approval_status = 1 ORDER BY id DESC");
while ($labs_data = db_fetch_object($labs_q)) {
/* file attachments */
$file_links = '';
$problem_q = db_query("SELECT * FROM {lab_migration_files} WHERE link_id = %d AND filetype = 'P'", $labs_data->id);
$problem_data = db_fetch_object($problem_q);
$file_links .= '<br/>' . l('Problem Statement', $dl_root_path . $problem_data->filepath);
$sup_q = db_query("SELECT * FROM {lab_migration_files} WHERE link_id = %d AND filetype = 'S'", $labs_data->id);
$sup_data = db_fetch_object($sup_q);
if ($sup_data)
$file_links .= '<br/>' . l('Suplementary Files', $dl_root_path . $sup_data->filepath);
$migration_status = '';
switch ($labs_data) {
case 1: $migration_status = '(In Progress)'; break;
case 3: $migration_status = '(Completed)'; break;
}
$labs_rows[] = array($labs_data->university . '<br/>' . $migration_status, $labs_data->lab_title, $labs_data->problem_topic . $file_links, l($labs_data->name_title . ' ' . $labs_data->name, 'user/' . $labs_data->uid) . '<br/>' . $labs_data->department);
}
/* check if there are any pending proposals */
if (!$labs_rows) {
drupal_set_message(t('There are no lab migrations.'), 'status');
return '';
}
$labs_header = array('University/Institute', 'Title of the Lab', 'Title of the Problem', 'Name of the Proposer and Department');
$output = theme_table($labs_header, $labs_rows);
return $output;
}
|
