$query = mysql_query("SELECT * FROM candidate_poll WHERE Reviewee = {$reviewee} AND Reviewer IN ({$managers}) AND Ok_overall = 1 ORDER BY Score LIMIT 100 OFFSET 1");
if (!$query || mysql_num_rows($query) <= 0) {
echo mysql_error();
return false;
} else {
while ($row = mysql_fetch_assoc($query)) {
$polls[] = array('ID' => $row['ID'], 'Reviewer' => $row['Reviewer'], 'Reviewee' => $row['Reviewee'], 'Score' => $row['Score'], 'Ok_overall' => $row['Ok_overall']);
}
return $polls;
}
}
foreach ($users as $user) {
//echo get_number_of_candidate_poll_managers($user['ID'])."-";
}
if (isset($_GET['user'])) {
get_candidate_user_info($_GET['user']);
}
function check($users)
{
$number_of_reviews_given = mysql_result(mysql_query("SELECT Value FROM parameter WHERE Short_name ='Reviews_to_give'"), 0);
$number_of_reviews_received = mysql_result(mysql_query("SELECT Value FROM parameter WHERE Short_name ='Reviews_to_receive'"), 0);
$number_of_manager_reviews_received = mysql_result(mysql_query("SELECT Value FROM parameter WHERE Short_name = 'Reviews_by_not_teammanager'"), 0);
$number_of_team_member_reviews_received = mysql_result(mysql_query("SELECT Value FROM parameter WHERE Short_name = 'Reviews_own_department'"), 0);
shuffle($users);
foreach ($users as $user) {
// X beste reviewee polls en 5 beste reviewer polls kiezen en respectievelijk Ok_reviewee en Ok_reviewer op 1 zetten
$get_best_polls_reviewee = get_best_polls_reviewee($user['ID'], $number_of_reviews_received);
foreach ($get_best_polls_reviewee as $poll) {
$id = $poll['ID'];
mysql_query("UPDATE candidate_poll SET Ok_reviewee = 1 WHERE ID = {$id}");
}
$users = get_users_order_by_id();
if (isset($_GET['id'])) {
if (isset($_POST['recalculate'])) {
calculate_couples($_GET['id']);
header('Location: calculate.php?id=' . $_GET['id']);
} else {
if (isset($_POST['accept'])) {
accept_calculated_polls($_GET['id']);
}
}
echo '<div class="content">';
foreach ($users as $user) {
$user_name = get_user_by_id($user['ID']);
echo '<div class="topContent">';
echo '<h3>' . $user_name[0] . ' ' . $user_name[1] . '</h3>';
get_candidate_user_info($user['ID']);
echo '</div>';
}
echo '</div>';
?>
<aside class="topSidebar">
<form action="<?php
echo $_SERVER['PHP_SELF'];
?>
?id=<?php
echo $_GET['id'];
?>
" method="post">
<input type="hidden" name="batch_id" value="<?php
echo $_GET['id'];
?>
