diff options
| -rwxr-xr-x | lab_details.inc | 30 |
1 files changed, 15 insertions, 15 deletions
diff --git a/lab_details.inc b/lab_details.inc index 3f09e43..39529f4 100755 --- a/lab_details.inc +++ b/lab_details.inc @@ -1,24 +1,24 @@ -<?php - function lab_migration_completed_labs_all() { - $page_content = ""; +<?php + function lab_migration_completed_labs_all() { + $page_content = ""; $query = "SELECT * FROM {lab_migration_proposal} WHERE approval_status = 3"; - $result = db_query($query); - - $page_content .= "<ol>"; - while($row = db_fetch_object($result)) { - $page_content .= "<li>"; - $page_content .= l($row->university." ({$row->lab_title})", "lab_migration_run/".$row->id); - $page_content .= "</li>"; - } - $page_content .= "</ol>"; - return $page_content; + $result = db_query($query); + $proposal_rows = array(); + $i=1; + while($row = db_fetch_object($result)) { + $approval_date=date("Y", $row->approval_date); + $preference_rows[] = array($i, $row->university , l($row->lab_title,"lab_migration_run/".$row->id),$approval_date); + $i++; + } + $preference_header = array('No','Institute', 'Lab', 'Year'); + $output = theme_table($preference_header, $preference_rows); + return $output; } function lab_migration_labs_progress_all() { $page_content = ""; $query = "SELECT * FROM {lab_migration_proposal} WHERE approval_status = 1 and solution_status = 2"; $result = db_query($query); - $page_content .= "<ol>"; while($row = db_fetch_object($result)) { $page_content .= "<li>"; @@ -28,4 +28,4 @@ $page_content .= "</ol>"; return $page_content; } -?> +?>
\ No newline at end of file |