/** * 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>";