function recup_info_user_pour_edition($login, $DEBUG = FALSE)
{
$tab = array();
$sql_user = '******'' . SQL::quote($login) . '\'';
$ReqLog_user = SQL::query($sql_user);
while ($resultat_user = $ReqLog_user->fetch_array()) {
$tab['nom'] = $resultat_user["u_nom"];
$tab['prenom'] = $resultat_user["u_prenom"];
$tab['quotite'] = $sql_quotite = $resultat_user["u_quotite"];
}
// recup dans un tableau de tableaux les nb et soldes de conges d'un user (indicé par id de conges)
$tab['conges'] = recup_tableau_conges_for_user($login, false, $DEBUG);
return $tab;
}
function recup_infos_du_user($login, $list_groups_double_valid)
{
$tab = array();
$sql1 = 'SELECT u_login, u_nom, u_prenom, u_is_resp, u_resp_login, u_is_admin, u_is_hr, u_is_active, u_see_all, u_passwd, u_quotite, u_email, u_num_exercice FROM conges_users ' . 'WHERE u_login="******";';
$ReqLog = \includes\SQL::query($sql1);
if ($resultat = $ReqLog->fetch_array()) {
$tab_user = array();
$tab_user['login'] = $resultat['u_login'];
$tab_user['nom'] = $resultat['u_nom'];
$tab_user['prenom'] = $resultat['u_prenom'];
$tab_user['is_resp'] = $resultat['u_is_resp'];
$tab_user['resp_login'] = $resultat['u_resp_login'];
$tab_user['is_admin'] = $resultat['u_is_admin'];
$tab_user['is_hr'] = $resultat['u_is_hr'];
$tab_user['is_active'] = $resultat['u_is_active'];
$tab_user['see_all'] = $resultat['u_see_all'];
$tab_user['passwd'] = $resultat['u_passwd'];
$tab_user['quotite'] = $resultat['u_quotite'];
$tab_user['email'] = $resultat['u_email'];
$tab_user['num_exercice'] = $resultat['u_num_exercice'];
$tab_user['conges'] = recup_tableau_conges_for_user($login, false);
$tab_user['double_valid'] = "N";
// on regarde ici si le user est dans un groupe qui fait l'objet d'une double validation
if ($_SESSION['config']['double_validation_conges']) {
if ($list_groups_double_valid != "") {
$sql1 = 'SELECT gu_login FROM conges_groupe_users WHERE gu_login="******" AND gu_gid IN (' . $list_groups_double_valid . ') ORDER BY gu_gid, gu_login;';
$ReqLog1 = \includes\SQL::query($sql1);
if ($ReqLog1->num_rows != 0) {
$tab_user['double_valid'] = 'Y';
}
}
}
return $tab_user;
} else {
return FALSE;
}
}
function edition_year($user_login, $edit_id, $session, $DEBUG)
{
$tab_info_user = recup_info_user_pour_edition($user_login, $DEBUG);
// recup du tableau des types de conges exceptionnels (seulement les conge sexceptionnels )
$tab_type_cong = recup_tableau_types_conges($DEBUG);
// recup du tableau des types de conges (seulement les conges)
if ($_SESSION['config']['gestion_conges_exceptionnels']) {
$tab_type_conges_exceptionnels = recup_tableau_types_conges_exceptionnels($DEBUG);
} else {
$tab_type_conges_exceptionnels = array();
}
// recup du tableau de tous les types de conges
$tab_type_all_cong = recup_tableau_tout_types_abs($DEBUG);
$tab_info = array();
$tab_info['date'] = date("Y-m-d");
$tab_info['conges'] = recup_tableau_conges_for_user($user_login, false, $DEBUG);
head_ed($tab_info_user, $tab_info, $tab_type_cong, $tab_type_conges_exceptionnels, $edit_id, $DEBUG);
$my_arrays = array();
// Récupération des informations sur l'année
$my_arrays = get_year_edition_user($user_login, $DEBUG);
/*********************************************/
/* Tableau Historique des Conges et demandes */
/*********************************************/
echo "\n<!-- Tableau Historique des Conges et demandes -->\n";
echo "<tr align=\"center\">\n";
echo "<td>\n";
if (empty($my_arrays)) {
echo "<b>" . _('editions_aucun_conges') . "</b><br>\n";
} else {
echo "</td>\n";
echo "</tr>\n";
/*************************************/
/* affichage lignes de l'edition */
/*************************************/
echo "\n<!-- affichage lignes de l'edition -->\n";
echo "<tr>\n";
echo " <td class=\"titre-edit\">" . _('divers_type_maj_1') . "</td>\n";
echo " <td class=\"titre-edit\">" . _('divers_etat_maj_1') . "</td>\n";
echo " <td class=\"titre-edit\">" . _('divers_nb_jours_maj_1') . "</td>\n";
echo " <td class=\"titre-edit\">" . _('divers_debut_maj_1') . "</td>\n";
echo " <td class=\"titre-edit\">" . _('divers_fin_maj_1') . "</td>\n";
echo " <td class=\"titre-edit\">" . _('divers_comment_maj_1') . "</td>\n";
if ($_SESSION['config']['affiche_date_traitement']) {
echo "<td class=\"titre-edit\">" . _('divers_date_traitement') . "</td>\n";
}
echo "</tr>\n";
foreach ($my_arrays as $my_array) {
$sql_p_date_deb = eng_date_to_fr($my_array["p_date_deb"]);
$sql_p_demi_jour_deb = $my_array["p_demi_jour_deb"];
if ($sql_p_demi_jour_deb == "am") {
$demi_j_deb = _('divers_am_short');
} else {
$demi_j_deb = _('divers_pm_short');
}
$sql_p_date_fin = eng_date_to_fr($my_array["p_date_fin"]);
$sql_p_demi_jour_fin = $my_array["p_demi_jour_fin"];
if ($sql_p_demi_jour_fin == "am") {
$demi_j_fin = _('divers_am_short');
} else {
$demi_j_fin = _('divers_pm_short');
}
$sql_p_nb_jours = $my_array["p_nb_jours"];
$sql_p_commentaire = $my_array["p_commentaire"];
$sql_p_type = $my_array["p_type"];
$sql_p_etat = $my_array["p_etat"];
$sql_p_date_demande = $my_array["p_date_demande"];
$sql_p_date_traitement = $my_array["p_date_traitement"];
echo "<tr>\n";
echo "<td class=\"histo-edit\">" . $tab_type_all_cong[$sql_p_type]['libelle'] . "</td>\n";
echo "<td class=\"histo-edit\">";
if ($sql_p_etat == "refus") {
echo _('divers_refuse');
} elseif ($sql_p_etat == "annul") {
echo _('divers_annule');
} else {
echo "{$sql_p_etat}";
}
echo "</td>\n";
if ($sql_p_etat == "ok") {
echo "<td class=\"histo-big\"> -{$sql_p_nb_jours}</td>";
} elseif ($sql_p_etat == "ajout") {
echo "<td class=\"histo-big\"> +{$sql_p_nb_jours}</td>";
} else {
echo "<td> {$sql_p_nb_jours}</td>";
}
echo "<td class=\"histo-edit\">{$sql_p_date_deb} _ {$demi_j_deb}</td>";
echo "<td class=\"histo-edit\">{$sql_p_date_fin} _ {$demi_j_fin}</td>";
echo "<td class=\"histo-edit\">{$sql_p_commentaire}</td>";
if ($_SESSION['config']['affiche_date_traitement']) {
if ($sql_p_date_demande == NULL) {
echo "<td class=\"histo-left\">" . _('divers_demande') . " : {$sql_p_date_demande}<br>" . _('divers_traitement') . " : {$sql_p_date_traitement}</td>\n";
} else {
echo "<td class=\"histo-left\">" . _('divers_demande') . " : {$sql_p_date_demande}<br>" . _('divers_traitement') . " : pas traité</td>\n";
}
}
echo "</tr>\n";
}
echo "</table>\n\n";
}
echo "<br><br>\n";
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
bottom_ed();
}
