summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJayaram Pai2014-05-08 18:12:00 +0530
committerJayaram Pai2014-05-08 18:12:00 +0530
commit0e66c002d4d2885fc89aafe2bc6f47d96f0a2533 (patch)
treee1a0feeb54444d5ba2597152aecce494c65c8bba
parent41350944cd678cf2242417e38b29027cfedc8fcc (diff)
downloadtbc-external-review-0e66c002d4d2885fc89aafe2bc6f47d96f0a2533.tar.gz
tbc-external-review-0e66c002d4d2885fc89aafe2bc6f47d96f0a2533.tar.bz2
tbc-external-review-0e66c002d4d2885fc89aafe2bc6f47d96f0a2533.zip
added user profile display in manage_tests
-rwxr-xr-xtbc_external_review.module23
1 files changed, 23 insertions, 0 deletions
diff --git a/tbc_external_review.module b/tbc_external_review.module
index 1de3348..edd23fb 100755
--- a/tbc_external_review.module
+++ b/tbc_external_review.module
@@ -1948,12 +1948,35 @@
($user_answer->mit == $correct_answers[$user_answer->question_id]->mit)?$scores[$user_answer->question_id]++:Null;
($user_answer->agl == $correct_answers[$user_answer->question_id]->agl)?$scores[$user_answer->question_id]++:Null;
}
+ $page_content .= "<hr><h1><u>User Score</u></h1>";
$total_score = 0;
foreach($scores as $key => $value) {
$page_content .= "Question {$key} score = <strong>{$value}</strong> out of 9<br>";
$total_score += $value;
}
$page_content .= "<h1>Total Score = {$total_score} out of 45";
+ /* fetching user data for display */
+ $query = "
+ SELECT * FROM external_review_profile erd
+ LEFT JOIN users usr ON usr.uid = erd.uid
+ WHERE erd.uid = %d
+ ";
+ $result = db_query($query, $user_id);
+ $row = db_fetch_array($result);
+ $fields = array(
+ "first_name", "last_name", "designation", "university",
+ "phone", "email", "alt_email", "address",
+ "description"
+ );
+ $page_content .= "<hr><h1><u>User Profile</u></h1>";
+ $page_content .= "<table border=1 cellspacing=1 cellpadding=1>";
+ foreach($fields as $field) {
+ $page_content .= "<tr>";
+ $page_content .= "<td>{$field}</td>";
+ $page_content .= "<td>{$row[$field]}</td>";
+ $page_content .= "</tr>";
+ }
+ $page_content .= "</table>";
}
} else {
$query = "