/**
* Create a string with the reviews of a paper
*/
public function showReviews($idPaper, $template, &$tpl, $db, $emailReviewer = "", $html = false)
{
global $EXPERTISE;
global $SCALE;
// Handle NULL values
$SCALE[""] = "?";
$EXPERTISE[""] = "?";
$config = GetConfig($db);
// Extract the block with marks. Check that it has
// not been done before
if (!isset($tpl->varkeys["REVIEW_MARK"])) {
$tpl->set_block($template, "REVIEW_MARK", "REVIEW_MARKS");
} else {
$tpl->set_var("REVIEW_MARKS", "");
}
// Extracts the block with questions
if (!isset($tpl->varkeys["REVIEW_QUESTION"])) {
$tpl->set_block($template, "REVIEW_QUESTION", "REVIEW_QUESTIONS");
}
$tpl->set_var("REVIEW_QUESTIONS", "");
// Select one or all reviews, depending on the emailReviewer variable
if (empty($emailReviewer)) {
$qRev = "SELECT idPaper,email FROM Review " . "WHERE idPaper='{$idPaper}'";
} else {
$qRev = "SELECT idPaper, email FROM Review " . "WHERE idPaper='{$idPaper}' " . " and email='{$emailReviewer}'";
}
// Initialize the REVIEWS entity to empty string
$tpl->set_var("REVIEWS", "");
$listC = GetListCriterias($db);
$resRev = $db->execRequete($qRev);
$i = 1;
while ($rid = $db->ligneSuivante($resRev)) {
// Get the review + the marks
$email = $rid['email'];
$review = GetReview($rid['idPaper'], $email, $db);
$reviewer = GetMember($review['email'], $db);
$tpl->set_var("REVIEWER_NAME", $reviewer['firstName'] . " " . $reviewer['lastName']);
$tpl->set_var("REVIEW_EXT_REV_NAME", $review['fname_ext_reviewer'] . " " . $review['lname_ext_reviewer']);
$tpl->set_var("REVIEWER_NO", $i++);
$tpl->set_var("REVIEW_OVERALL", $review['overall']);
// Show the marks
$tpl->set_var("REVIEW_MARKS", "");
$j = 0;
foreach ($listC as $id => $crVals) {
// Choose the CSS class
if ($j++ % 2 == 0) {
$tpl->set_var("CSS_CLASS", "even");
} else {
$tpl->set_var("CSS_CLASS", "odd");
}
$tpl->set_var("CRITERIA", ucfirst($crVals['label']));
$tpl->set_var("MARK", $SCALE[$review[$id]]);
$tpl->parse("REVIEW_MARKS", "REVIEW_MARK", true);
}
$tpl->set_var("REVIEWER_EXPERTISE", $EXPERTISE[$review['reviewerExpertise']]);
if ($html) {
$tpl->set_var("REVIEW_SUMMARY", String2HTML($review['summary']));
$tpl->set_var("REVIEW_DETAILS", String2HTML($review['details']));
$tpl->set_var("REVIEW_COMMENTS", String2HTML($review['comments']));
} else {
$tpl->set_var("REVIEW_SUMMARY", $review['summary']);
$tpl->set_var("REVIEW_DETAILS", $review['details']);
$tpl->set_var("REVIEW_COMMENTS", $review['comments']);
}
// Put the questions
$q_questions = "SELECT * FROM ReviewQuestion q, RQChoice c, " . " ReviewAnswer a " . " WHERE q.id=c.id_question AND a.id_answer=c.id_choice " . " AND id_paper={$idPaper} AND email='{$email}' AND public='Y'";
$tpl->set_var("REVIEW_QUESTIONS", "");
$rq = $db->execRequete($q_questions);
while ($question = $db->objetSuivant($rq)) {
if ($j++ % 2 == 0) {
$tpl->set_var("CSS_CLASS", "even");
} else {
$tpl->set_var("CSS_CLASS", "odd");
}
$tpl->set_var("QUESTION", $question->question);
$tpl->set_var("ANSWER", $question->choice);
$tpl->parse("REVIEW_QUESTIONS", "REVIEW_QUESTION", true);
}
$tpl->parse("REVIEWS", $template, true);
}
return $tpl->get_var("REVIEWS");
}
//$discharged = empty($discharged) ? NULL : "'{$discharged}'";
$query = "UPDATE `rudi_unit_members` SET" . " `rank_id` = '{$rank_id}'," . " `country_id` = '{$country_id}'," . " `role_id` = '{$role_id}', " . " `status_id` = '{$status_id}'," . " `cunit_id` = '{$unit_id}'," . " `weapon_id` = '{$weapon_id}'," . " `weapon2_id` = '{$weapon2_id}'," . " `a2_id` = '{$a2_id}'," . " `oa_id` = '{$oa_id}'," . " `username` = '{$username}'," . " `email` = '{$email}'," . " `xfire` = '{$xfire}'," . " `first_name` = '{$first_name}'," . " `last_name` = '{$last_name}'," . " `location_city` = '{$city}'," . " `location_province` = '{$province}'," . " `bio` = '{$bio}'," . " `date_enlisted` = '{$enlisted}'," . " `date_promotion` = '{$promoted}'," . " `primary_mos` = '{$primary_mos}',";
if (empty($discharged)) {
$query = $query . " `date_discharged` = null";
} else {
$query = $query . " `date_discharged` = '{$discharged}'";
}
$query = $query . " WHERE `member_id` = '{$member_id}' LIMIT 1";
decho($query);
$db->Query($query);
//$db->Query("UPDATE `rudi_roles_container` SET `role_id` = '$role_id' WHERE `member_id` = '$member_id' LIMIT 1");
/* do the role query as well */
PageRedirect(1, "?op=rudi&show=members");
return;
}
$member = GetMember($member_id);
?>
<a href="?op=rudi&show=members">Cancel</a><br />
<form method="POST" action="">
<table width="100%" style="text-align:center;">
<tr><th colspan="2" style="background-color:#c4c4c4;">Personnel File of <?php
echo $member['first_name'] . " " . $member['last_name'];
?>
</th></tr>
<tr><td class="right" width="50%">Rank:</td><td class="left">
<select name="rank">
<?php
$ranks = GetRanks();
foreach ($ranks as $rank) {
if ($rank['rank_id'] == $member['rank_id']) {
echo "<option value=\"{$rank['rank_id']}\" selected>{$rank['longname']}</option>";
