}
}
// Get maximum point values based upon number of entries
$organ_points = number_format(total_points($total_entries, "Organizer"), 1);
$staff_points = number_format(total_points($total_entries, "Staff"), 1);
$judge_points = number_format(total_points($total_entries, "Judge"), 1);
// Divide total staff point pool by amount of staff, round down
$query_assignments = sprintf("SELECT COUNT(*) as 'count' FROM %s WHERE staff_staff='1'", $staff_db_table);
$assignments = mysql_query($query_assignments, $brewing) or die(mysql_error());
$row_assignments = mysql_fetch_assoc($assignments);
//echo $staff_points."<br>";
//echo $row_assignments['count']."<br>";
$staff_ind_points = $staff_points / $row_assignments['count'];
//echo $staff_ind_points;
if ($row_assignments['count'] >= 2) {
$staff_points = number_format(round_to_half($staff_ind_points), 1);
} elseif ($row_assignments['count'] == 1) {
$staff_points = number_format($staff_points, 1);
} else {
$staff_points = 0;
}
// Organizer
$query_organizer = sprintf("SELECT uid FROM %s WHERE staff_organizer='1'", $staff_db_table);
$organizer = mysql_query($query_organizer, $brewing) or die(mysql_error());
$row_organizer = mysql_fetch_assoc($organizer);
$totalRows_organizer = mysql_num_rows($organizer);
// Judges
$query_judges = sprintf("SELECT uid FROM %s WHERE staff_judge='1'", $staff_db_table);
$judges = mysql_query($query_judges, $brewing) or die(mysql_error());
$row_judges = mysql_fetch_assoc($judges);
$totalRows_judges = mysql_num_rows($judges);
function commit_update($u_login_to_update, &$tab_new_user, &$tab_new_jours_an, &$tab_new_solde, &$tab_new_reliquat, $tab_checkbox_sem_imp, $tab_checkbox_sem_p, $DEBUG = FALSE)
{
//$DEBUG=TRUE;
$PHP_SELF = $_SERVER['PHP_SELF'];
$session = session_id();
$result = TRUE;
// recup du tableau des types de conges (seulement les conges)
$tab_type_conges = recup_tableau_types_conges($DEBUG);
$tab_type_conges_excep = array();
if ($_SESSION['config']['gestion_conges_exceptionnels']) {
$tab_type_conges_excep = recup_tableau_types_conges_exceptionnels($DEBUG);
}
if ($DEBUG) {
echo "tab_new_jours_an = <br>\n";
print_r($tab_new_jours_an);
echo "<br>\n";
echo "tab_new_solde = <br>\n";
print_r($tab_new_solde);
echo "<br>\n";
echo "tab_new_reliquat = <br>\n";
print_r($tab_new_reliquat);
echo "<br>\n";
echo "tab_type_conges = <br>\n";
print_r($tab_type_conges);
echo "<br>\n";
echo "tab_type_conges_excep = <br>\n";
print_r($tab_type_conges_excep);
echo "<br>\n";
}
echo "{$u_login_to_update}---" . $tab_new_user['nom'] . "---" . $tab_new_user['prenom'] . "---" . $tab_new_user['quotite'] . "---" . $tab_new_user['is_resp'] . "---" . $tab_new_user['resp_login'] . "---" . $tab_new_user['is_admin'] . "---" . $tab_new_user['is_hr'] . "---" . $tab_new_user['is_active'] . "---" . $tab_new_user['see_all'] . "---" . $tab_new_user['email'] . "---" . $tab_new_user['login'] . "<br>\n";
$valid_1 = TRUE;
$valid_2 = TRUE;
$valid_3 = TRUE;
$valid_reliquat = TRUE;
// verification de la validite de la saisie du nombre de jours annuels et du solde pour chaque type de conges
foreach ($tab_type_conges as $id_conges => $libelle) {
$valid_1 = $valid_1 && verif_saisie_decimal($tab_new_jours_an[$id_conges], $DEBUG);
//verif la bonne saisie du nombre d?cimal
$valid_2 = $valid_2 && verif_saisie_decimal($tab_new_solde[$id_conges], $DEBUG);
//verif la bonne saisie du nombre d?cimal
$valid_reliquat = $valid_reliquat && verif_saisie_decimal($tab_new_reliquat[$id_conges], $DEBUG);
//verif la bonne saisie du nombre d?cimal
}
// si l'application gere les conges exceptionnels ET si des types de conges exceptionnels ont été définis
if ($_SESSION['config']['gestion_conges_exceptionnels'] && count($tab_type_conges_excep) > 0) {
$valid_3 = TRUE;
// vérification de la validité de la saisie du nombre de jours annuels et du solde pour chaque type de conges exceptionnels
foreach ($tab_type_conges_excep as $id_conges => $libelle) {
$valid_3 = $valid_3 && verif_saisie_decimal($tab_new_solde[$id_conges], $DEBUG);
//verif la bonne saisie du nombre décimal
}
} else {
$valid_3 = TRUE;
}
if ($DEBUG) {
echo "valid_1 = {$valid_1} // valid_2 = {$valid_2} // valid_3 = {$valid_3} // valid_reliquat = {$valid_reliquat} <br>\n";
}
// si aucune erreur de saisie n'a ete commise
if ($valid_1 && $valid_2 && $valid_3 && $valid_reliquat) {
// UPDATE de la table conges_users
$sql = 'UPDATE conges_users SET u_nom=\'' . SQL::quote($tab_new_user['nom']) . '\', u_prenom=\'' . SQL::quote($tab_new_user['prenom']) . '\', u_is_resp=\'' . SQL::quote($tab_new_user['is_resp']) . '\', u_resp_login=\'' . SQL::quote($tab_new_user['resp_login']) . '\',u_is_admin=\'' . SQL::quote($tab_new_user['is_admin']) . '\',u_is_hr=\'' . SQL::quote($tab_new_user['is_hr']) . '\',u_is_active=\'' . SQL::quote($tab_new_user['is_active']) . '\',u_see_all=\'' . SQL::quote($tab_new_user['see_all']) . '\',u_login=\'' . SQL::quote($tab_new_user['login']) . '\',u_quotite=\'' . SQL::quote($tab_new_user['quotite']) . '\',u_email=\'' . SQL::quote($tab_new_user['email']) . '\' WHERE u_login=\'' . SQL::quote($u_login_to_update) . '\'';
SQL::query($sql);
/*************************************/
/* Mise a jour de la table conges_solde_user */
foreach ($tab_type_conges as $id_conges => $libelle) {
$sql = 'REPLACE INTO conges_solde_user SET su_nb_an=\'' . strtr(round_to_half($tab_new_jours_an[$id_conges]), ",", ".") . '\',su_solde=\'' . strtr(round_to_half($tab_new_solde[$id_conges]), ",", ".") . '\',su_reliquat=\'' . strtr(round_to_half($tab_new_reliquat[$id_conges]), ",", ".") . '\',su_login=\'' . SQL::quote($u_login_to_update) . '\',su_abs_id=' . intval($id_conges) . ';';
echo $sql;
SQL::query($sql);
}
if ($_SESSION['config']['gestion_conges_exceptionnels']) {
foreach ($tab_type_conges_excep as $id_conges => $libelle) {
$sql = 'REPLACE INTO conges_solde_user SET su_nb_an=0, su_solde=\'' . strtr(round_to_half($tab_new_solde[$id_conges]), ",", ".") . '\', su_reliquat=\'' . strtr(round_to_half($tab_new_reliquat[$id_conges]), ",", ".") . '\', su_login=\'' . SQL::quote($u_login_to_update) . '\', su_abs_id=' . intval($id_conges) . ';';
echo $sql;
SQL::query($sql);
}
}
/*************************************/
/* Mise a jour de la table artt si besoin : */
$tab_grille_rtt_actuelle = get_current_grille_rtt($u_login_to_update, $DEBUG);
$tab_new_grille_rtt = tab_grille_rtt_from_checkbox($tab_checkbox_sem_imp, $tab_checkbox_sem_p, $DEBUG);
if ($tab_grille_rtt_actuelle != $tab_new_grille_rtt) {
/* if($tab_grille_rtt_actuelle==$tab_new_grille_rtt)
{
// on ne touche pas à la table artt
}
else
{
*/
$new_date_deb_grille = $tab_new_user['year'] . "-" . $tab_new_user['mois'] . "-" . $tab_new_user['jour'];
/****************************/
/*** phase 1 : ***/
// si la derniere grille est ancienne, on l'update (on update la date de fin de grille)
// sinon, si la derniere grille date d'aujourd'hui, on la supprime
// on regarde si la grille artt a deja été modifiée aujourd'hui :
$sql = 'SELECT a_date_fin_grille FROM conges_artt
WHERE a_login=\'' . SQL::quote($u_login_to_update) . '\' AND a_date_debut_grille=\'' . SQL::quote($new_date_deb_grille) . '\';';
$result_grille = SQL::query($sql);
$count_grille = $result_grille->num_rows;
if ($count_grille == 0) {
// date de fin de la grille précedent :
// $new_date_fin_grille = $new_date_deb_grille -1 jour !
$new_jour_num = (int) $tab_new_user['jour'];
$new_mois_num = (int) $tab_new_user['mois'];
$new_year_num = (int) $tab_new_user['year'];
$new_date_fin_grille = date("Y-m-d", mktime(0, 0, 0, $new_mois_num, $new_jour_num - 1, $new_year_num));
// int mktime(int hour, int minute, int second, int month, int day, int year )
// UPDATE de la table conges_artt
// en fait, on update la dernière grille (on update la date de fin de grille), et on ajoute une nouvelle
// grille (avec sa date de début de grille)
// on update la dernière grille (on update la date de fin de grille)
$sql = 'UPDATE conges_artt SET a_date_fin_grille=\'' . SQL::quote($new_date_fin_grille) . '\' WHERE a_login=\'' . SQL::quote($u_login_to_update) . '\' AND a_date_fin_grille=\'9999-12-31\' ';
SQL::query($sql);
} else {
$sql = 'DELETE FROM conges_artt WHERE a_login=\'' . SQL::quote($u_login_to_update) . '\' AND a_date_debut_grille=\'' . SQL::quote($new_date_deb_grille);
SQL::query($sql);
}
/****************************/
/*** phase 2 : ***/
// on Insert la nouvelle grille (celle qui commence aujourd'hui)
// on met à 'Y' les demi-journées de rtt (et seulement celles là)
$list_columns = "";
$list_valeurs = "";
$i = 0;
if ($tab_checkbox_sem_imp != "") {
while (list($key, $val) = each($tab_checkbox_sem_imp)) {
if ($i != 0) {
$list_columns = $list_columns . ", ";
$list_valeurs = $list_valeurs . ", ";
}
$list_columns = $list_columns . " {$key} ";
$list_valeurs = $list_valeurs . " '{$val}' ";
$i = $i + 1;
}
}
if ($tab_checkbox_sem_p != "") {
while (list($key, $val) = each($tab_checkbox_sem_p)) {
if ($i != 0) {
$list_columns = $list_columns . ", ";
$list_valeurs = $list_valeurs . ", ";
}
$list_columns = $list_columns . " {$key} ";
$list_valeurs = $list_valeurs . " '{$val}' ";
$i = $i + 1;
}
}
if ($list_columns != "" && $list_valeurs != "") {
$sql = "INSERT INTO conges_artt (a_login, {$list_columns}, a_date_debut_grille ) VALUES ('{$u_login_to_update}', {$list_valeurs}, '{$new_date_deb_grille}') ";
SQL::query($sql);
}
}
// Si changement du login, (on a dèja updaté la table users (mais pas les responsables !!!)) on update toutes les autres tables
// (les grilles artt, les periodes de conges et les échanges de rtt, etc ....) avec le nouveau login
if ($tab_new_user['login'] != $u_login_to_update) {
// update table artt
$sql = 'UPDATE conges_artt SET a_login=\'' . SQL::quote($tab_new_user['login']) . '\' WHERE a_login=\'' . SQL::quote($u_login_to_update) . '\' ';
SQL::query($sql);
// update table echange_rtt
$sql = 'UPDATE conges_echange_rtt SET e_login=\'' . SQL::quote($tab_new_user['login']) . '\' WHERE e_login=\'' . SQL::quote($u_login_to_update) . '\' ';
SQL::query($sql);
// update table edition_papier
$sql = 'UPDATE conges_edition_papier SET ep_login=\'' . SQL::quote($tab_new_user['login']) . '\' WHERE ep_login=\'' . SQL::quote($u_login_to_update) . '\' ';
SQL::query($sql);
// update table groupe_grd_resp
$sql = 'UPDATE conges_groupe_grd_resp SET ggr_login=\'' . SQL::quote($tab_new_user['login']) . '\' WHERE ggr_login=\'' . SQL::quote($u_login_to_update) . '\' ';
SQL::query($sql);
// update table groupe_resp
$sql = 'UPDATE conges_groupe_resp SET gr_login=\'' . SQL::quote($tab_new_user['login']) . '\' WHERE gr_login=\'' . SQL::quote($u_login_to_update) . '\' ';
SQL::query($sql);
// update table conges_groupe_users
$sql = 'UPDATE conges_groupe_users SET gu_login=\'' . SQL::quote($tab_new_user['login']) . '\' WHERE gu_login=\'' . SQL::quote($u_login_to_update) . '\' ';
SQL::query($sql);
// update table periode
$sql = 'UPDATE conges_periode SET p_login=\'' . SQL::quote($tab_new_user['login']) . '\' WHERE p_login=\'' . SQL::quote($u_login_to_update) . '\' ';
SQL::query($sql);
// update table conges_solde_user
$sql = 'UPDATE conges_solde_user SET su_login=\'' . SQL::quote($tab_new_user['login']) . '\' WHERE su_login=\'' . SQL::quote($u_login_to_update) . '\' ';
SQL::query($sql);
// update table conges_users
$sql = 'UPDATE conges_users SET u_resp_login=\'' . SQL::quote($tab_new_user['login']) . '\' WHERE u_resp_login=\'' . SQL::quote($u_login_to_update) . '\' ';
SQL::query($sql);
}
if ($tab_new_user['login'] != $u_login_to_update) {
$comment_log = "modif_user (old_login = {$u_login_to_update}) new_login = "******"modif_user login = {$u_login_to_update}";
}
log_action(0, "", $u_login_to_update, $comment_log, $DEBUG);
echo _('form_modif_ok') . " !<br><br> \n";
} else {
echo _('form_modif_not_ok') . " !<br><br> \n";
}
}
function num_to_stars($num)
{
$stars = round_to_half($num);
$num = round($num, 2);
$html = "";
for ($i = 0; $i < floor($stars); $i++) {
$html .= '<img src="' . WP_PLUGIN_URL . '/review-site/star.gif" alt="' . $num . '" />';
}
if (floor($stars) != $stars) {
$html .= '<img src="' . WP_PLUGIN_URL . '/review-site/star-half.gif" alt="' . $num . '" />';
}
if (ceil($stars) < 5) {
for ($i = ceil($stars); $i < 5; $i++) {
$html .= '<img src="' . WP_PLUGIN_URL . '/review-site/star-empty.gif" alt="' . $num . '" />';
}
}
return $html;
}
