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(); }