$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']; ?>