fields('lab_migration_proposal'); $query->condition('approval_status', 3); $result = $query->execute(); //$result = db_query($query); if ($result->rowCount() == 0) { $output .= "We are in the process of updating the lab migration data."; } else { $preference_rows = array(); $i = 1; while ($row = $result->fetchObject()) { $approval_date = date("Y", $row->approval_date); $preference_rows[] = array( $i, $row->university, l($row->lab_title, "lab-migration/lab-migration-run/" . $row->id), $approval_date ); $i++; } $preference_header = array( 'No', 'Institute', 'Lab', 'Year' ); $output .= theme('table', array( 'header' => $preference_header, 'rows' => $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"; $query = db_select('lab_migration_proposal'); $query->fields('lab_migration_proposal'); $query->condition('approval_status', 1); $query->condition('solution_status', 2); $result = $query->execute(); if ($result->rowCount() == 0) { $page_content .= "We are in the process of updating the lab migration data."; } else { //$result = db_query($query); $page_content .= "

"; while ($row = $result->fetchObject()) { $page_content .= "
1. "; $page_content .= $row->university . " ({$row->lab_title})"; $page_content .= "
"; } $page_content .= "

"; } return $page_content; }