function affichage($tab_new_values, $session, $DEBUG = FALSE)
{
$PHP_SELF = $_SERVER['PHP_SELF'];
if ($session == "") {
$URL = "{$PHP_SELF}";
} else {
$URL = "{$PHP_SELF}?session={$session}";
}
/**************************************/
// affichage du titre
echo "<H1> " . _('config_mail_titre') . "</H1>\n";
echo "<i> " . _('config_mail_alerte_config') . "</i>\n";
echo "<br><br>\n";
/**************************************/
affiche_bouton_retour($session);
// affichage de la liste des type d'absence existants
//requête qui récupère les informations de la table conges_type_absence
$sql1 = "SELECT * FROM conges_mail ";
$ReqLog1 = SQL::query($sql1);
echo " <form action=\"{$URL}\" method=\"POST\"> \n";
while ($data = $ReqLog1->fetch_array()) {
$mail_nom = stripslashes($data['mail_nom']);
$mail_subject = stripslashes($data['mail_subject']);
$mail_body = stripslashes($data['mail_body']);
$legend = $mail_nom;
// echo $mail_nom ;
$key = $mail_nom . "_comment";
$comment = _($key);
echo "<br>\n";
echo "<table>\n";
echo "<tr><td>\n";
echo " <fieldset class=\"cal_saisie\">\n";
echo " <legend class=\"boxlogin\">{$legend}</legend>\n";
echo " <i>{$comment}</i><br><br>\n";
echo " <table cellpadding=\"2\" class=\"tablo-config\" >\n";
echo " <tr>\n";
echo " \t<td class=\"config\" valign=\"top\"><b>" . _('config_mail_subject') . "</b></td>\n";
echo " \t<td class=\"config\"><input type=\"text\" size=\"80\" name=\"tab_new_values[{$mail_nom}][subject]\" value=\"{$mail_subject}\"></td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " \t<td class=\"config\" valign=\"top\"><b>" . _('config_mail_body') . "</b></td>\n";
echo " \t<td class=\"config\"><textarea rows=\"6\" cols=\"80\" name=\"tab_new_values[{$mail_nom}][body]\" value=\"{$mail_body}\">{$mail_body}</textarea></td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " \t<td class=\"config\"> </td>\n";
echo " \t<td class=\"config\">\n";
echo " \t\t<i>" . _('mail_remplace_url_accueil_comment') . "<br>\n";
echo " \t\t" . _('mail_remplace_sender_name_comment') . "<br>\n";
echo " \t\t" . _('mail_remplace_destination_name_comment') . "<br>\n";
echo " \t\t" . _('mail_remplace_nb_jours') . "<br>\n";
echo " \t\t" . _('mail_remplace_date_debut') . "<br>\n";
echo " \t\t" . _('mail_remplace_date_fin') . "<br>\n";
echo " \t\t" . _('mail_remplace_commentaire') . "<br>\n";
echo " \t\t" . _('mail_remplace_type_absence') . "<br>\n";
echo " \t\t" . _('mail_remplace_retour_ligne_comment') . "</i>\n";
echo " \t</td>\n";
echo " </tr>\n";
echo " </table>\n";
echo "</td></tr>\n";
echo "</table>\n";
}
echo " <input type=\"hidden\" name=\"action\" value=\"modif\">\n";
echo " <input type=\"submit\" value=\"" . _('form_save_modif') . "\"><br>\n";
echo " </form>\n";
// Bouton de retour : différent suivant si on vient des pages d'install ou de l'appli
echo "<br><br>\n";
affiche_bouton_retour($session);
}
function affichage($tab_new_values, $session, $DEBUG = FALSE)
{
$PHP_SELF = $_SERVER['PHP_SELF'];
if ($session == "") {
$URL = "{$PHP_SELF}";
} else {
$URL = "{$PHP_SELF}?session={$session}";
}
/**************************************/
// affichage du titre
echo "<br><center><H1> " . _('config_abs_titre') . "</H1></center>\n";
echo "<br>\n";
/**************************************/
affiche_bouton_retour($session);
// affichage de la liste des type d'absence existants
$tab_enum = get_tab_from_mysql_enum_field("conges_type_absence", "ta_type", $DEBUG);
foreach ($tab_enum as $ta_type) {
if ($ta_type == "conges_exceptionnels" && $_SESSION['config']['gestion_conges_exceptionnels'] == FALSE) {
} else {
$divers_maj_1 = 'divers_' . $ta_type . '_maj_1';
$config_abs_comment = 'config_abs_comment_' . $ta_type;
$legend = _($divers_maj_1);
$comment = _($config_abs_comment);
echo "<br>\n";
echo "<table width=\"100%\">\n";
echo "<tr><td>\n";
echo " <fieldset class=\"cal_saisie\">\n";
echo " <legend class=\"boxlogin\">{$legend}</legend>\n";
echo " <i>{$comment}</i><br><br>\n";
//requête qui récupère les informations de la table conges_type_absence
$sql1 = 'SELECT * FROM conges_type_absence WHERE ta_type = \'' . SQL::quote($ta_type) . '\'';
$ReqLog1 = SQL::query($sql1);
if ($ReqLog1->num_rows != 0) {
echo " <table cellpadding=\"2\" class=\"tablo\" >\n";
echo " <tr>\n";
echo " <td><b><u>" . _('config_abs_libelle') . "</b></u></td>\n";
echo " <td><b><u>" . _('config_abs_libelle_short') . "</b></u></td>\n";
echo " <td></td>\n";
echo " <td></td>\n";
echo " </tr>\n";
while ($data = $ReqLog1->fetch_array()) {
$ta_id = $data['ta_id'];
$ta_libelle = $data['ta_libelle'];
$ta_short_libelle = $data['ta_short_libelle'];
if ($session == "") {
$text_modif = "<a href=\"{$PHP_SELF}?action=modif&id_to_update={$ta_id}\">" . _('form_modif') . "</a>";
$text_suppr = "<a href=\"{$PHP_SELF}?action=suppr&id_to_update={$ta_id}\">" . _('form_supprim') . "</a>";
} else {
$text_modif = "<a href=\"{$PHP_SELF}?session={$session}&action=modif&id_to_update={$ta_id}\">" . _('form_modif') . "</a>";
$text_suppr = "<a href=\"{$PHP_SELF}?session={$session}&action=suppr&id_to_update={$ta_id}\">" . _('form_supprim') . "</a>";
}
echo " <tr><td><b>{$ta_libelle}</b></td><td>{$ta_short_libelle}</td><td>{$text_modif}</td><td>{$text_suppr}</td></tr>\n";
}
echo " </table>\n";
echo "</td></tr>\n";
echo "</table>\n";
}
echo " </table>\n";
echo "</td></tr>\n";
echo "</table>\n";
}
}
/**************************************/
// saisie de nouveaux type d'absence
echo "<br>\n";
echo "<table width=\"100%\">\n";
echo "<tr><td>\n";
echo " <form action=\"{$URL}\" method=\"POST\"> \n";
echo " <fieldset class=\"cal_saisie\">\n";
echo " <legend class=\"boxlogin\">" . _('config_abs_add_type_abs') . "</legend>\n";
echo " " . _('config_abs_add_type_abs_comment') . "\n";
echo " <table cellpadding=\"2\" >\n";
echo " <tr>\n";
echo " <td>" . _('config_abs_libelle') . "</td>\n";
echo " <td>" . _('config_abs_libelle_short') . "</td>\n";
echo " <td>" . _('divers_type') . "</td>\n";
echo " </tr>\n";
echo " <tr>\n";
$new_libelle = isset($tab_new_values['libelle']) ? $tab_new_values['libelle'] : "";
$new_short_libelle = isset($tab_new_values['short_libelle']) ? $tab_new_values['short_libelle'] : "";
$new_type = isset($tab_new_values['type']) ? $tab_new_values['type'] : "";
echo " <td><input type=\"text\" name=\"tab_new_values[libelle]\" size=\"20\" maxlength=\"20\" value=\"{$new_libelle}\" ></td>\n";
echo " <td><input type=\"text\" name=\"tab_new_values[short_libelle]\" size=\"3\" maxlength=\"3\" value=\"{$new_short_libelle}\" ></td>\n";
echo " <td>\n";
echo "<SELECT NAME=tab_new_values[type]>\n";
foreach ($tab_enum as $option) {
if ($option == "conges_exceptionnels" && $_SESSION['config']['gestion_conges_exceptionnels'] == FALSE) {
} else {
if ($option == $new_type) {
echo "<OPTION selected>{$option}</OPTION>\n";
} else {
echo "<OPTION>{$option}</OPTION>\n";
}
}
}
echo "</SELECT>\n";
echo " </td></tr>\n";
echo " </table>\n";
echo " <input type=\"hidden\" name=\"action\" value=\"new\">\n";
echo " <input type=\"submit\" value=\"" . _('form_ajout') . "\"><br>\n";
echo " </form>\n";
echo "</td></tr>\n";
echo "</table>\n";
// Bouton de retour : différent suivant si on vient des pages d'install ou de l'appli
echo "<br><br>\n";
affiche_bouton_retour($session);
echo "<br><br>\n";
}
function affichage($login_par, $session, $DEBUG = FALSE)
{
$PHP_SELF = $_SERVER['PHP_SELF'];
/**************************************/
// affichage du titre
echo "<H1><img src=\"" . TEMPLATE_PATH . "img/tux_config_32x32.png\" width=\"32\" height=\"32\" border=\"0\" title=\"" . _('config_logs_titre_2') . "\" alt=\"" . _('config_logs_titre_2') . "\"> " . _('config_logs_titre_1') . "</H1></center>\n";
echo "<br>\n";
/**************************************/
affiche_bouton_retour($session);
//requête qui récupère les logs
$sql1 = "SELECT log_user_login_par, log_user_login_pour, log_etat, log_comment, log_date FROM conges_logs ";
if ($login_par != "") {
$sql1 = $sql1 . " WHERE log_user_login_par = '{$login_par}' ";
}
$sql1 = $sql1 . " ORDER BY log_date";
$ReqLog1 = SQL::query($sql1);
if ($ReqLog1->num_rows != 0) {
echo "<center>\n";
if ($session == "") {
echo "<form action=\"{$PHP_SELF}\" method=\"POST\"> \n";
} else {
echo "<form action=\"{$PHP_SELF}?session={$session}\" method=\"POST\"> \n";
}
echo "<br>\n";
echo "<table align=\"center\">\n";
echo "<tr><td class=\"histo\" colspan=\"5\">" . _('voir_les_logs_par') . "</td>";
if ($login_par != "") {
echo "<tr><td class=\"histo\" colspan=\"5\">" . _('voir_tous_les_logs') . " <a href=\"{$PHP_SELF}?session={$session}\">" . _('voir_tous_les_logs') . "</a></td>";
}
echo "<tr><td class=\"histo\" colspan=\"5\"> </td>";
// titres
echo "<tr>\n";
echo "<td>" . _('divers_date_maj_1') . "</td>\n";
echo "<td>" . _('divers_fait_par_maj_1') . "</td>\n";
echo "<td>" . _('divers_pour_maj_1') . "</td>\n";
echo "<td>" . _('divers_comment_maj_1') . "</td>\n";
echo "<td>" . _('divers_etat_maj_1') . "</td>\n";
echo "</tr>\n";
// affichage des logs
while ($data = $ReqLog1->fetch_array()) {
$log_login_par = $data['log_user_login_par'];
$log_login_pour = $data['log_user_login_pour'];
$log_log_etat = $data['log_etat'];
$log_log_comment = $data['log_comment'];
$log_log_date = $data['log_date'];
echo "<tr>\n";
echo "<td>{$log_log_date}</td>\n";
echo "<td><a href=\"{$PHP_SELF}?session={$session}&login_par={$log_login_par}\"><b>{$log_login_par}</b></a></td>\n";
echo "<td>{$log_login_pour}</td>\n";
echo "<td>{$log_log_comment}</td>\n";
echo "<td>{$log_log_etat}</td>\n";
echo "</tr>\n";
}
echo "</table>\n";
// affichage du bouton pour vider les logs
echo "<input type=\"hidden\" name=\"action\" value=\"suppr_logs\">\n";
echo "<input type=\"submit\" value=\"" . _('form_delete_logs') . "\"><br>";
echo "</form>\n";
echo "</center>\n";
} else {
echo _('no_logs_in_db') . "><br>";
}
echo "<br>\n";
affiche_bouton_retour($session);
echo "<br><br>\n";
}
function affichage($session, $DEBUG = FALSE)
{
$PHP_SELF = $_SERVER['PHP_SELF'];
/**************************************/
// affichage du titre
echo "<H1><img src=\"" . TEMPLATE_PATH . "img/tux_config_32x32.png\" width=\"32\" height=\"32\" border=\"0\" title=\"" . _('config_appli_titre_2') . "\" alt=\"" . _('config_appli_titre_2') . "\"> " . _('config_appli_titre_1') . "</H1></center>\n";
echo "<br>\n";
/**************************************/
affiche_bouton_retour($session);
// affichage de la liste des variables
if ($session == "") {
echo "<form action=\"{$PHP_SELF}\" method=\"POST\"> \n";
} else {
echo "<form action=\"{$PHP_SELF}?session={$session}\" method=\"POST\"> \n";
}
echo "<input type=\"hidden\" name=\"action\" value=\"commit\">\n";
//requête qui récupère les informations de config
$sql1 = "SELECT * FROM conges_config ORDER BY conf_groupe ASC";
$ReqLog1 = SQL::query($sql1);
$old_groupe = "";
while ($data = $ReqLog1->fetch_array()) {
$conf_nom = $data['conf_nom'];
$conf_valeur = $data['conf_valeur'];
$conf_groupe = $data['conf_groupe'];
$conf_type = strtolower($data['conf_type']);
$conf_commentaire = strtolower($data['conf_commentaire']);
// changement de groupe de variables
if ($old_groupe != $conf_groupe) {
if ($old_groupe != "") {
echo "</td></tr>\n";
echo "<tr><td align=\"right\">\n";
echo "<input type=\"submit\" value=\"" . _('form_save_modif') . "\"><br>";
echo "</td></tr>\n";
echo "</table>\n";
}
echo "<br>\n";
echo "<table width=\"100%\">\n";
echo "<tr><td>\n";
echo " <fieldset class=\"cal_saisie\">\n";
echo " <legend class=\"boxlogin\">" . _($conf_groupe) . "</legend>\n";
$old_groupe = $conf_groupe;
}
// si on est sur le parametre "lang" on liste les fichiers de langue du répertoire install/lang
if ($conf_nom == "lang") {
echo "Choisissez votre langue :<br> \n";
echo "Choose your language :<br>\n";
// affichage de la liste des langues supportées ...
// on lit le contenu du répertoire lang et on parse les nom de ficher (ex lang_fr_francais.php)
//affiche_select_from_lang_directory("tab_new_values[$conf_nom]");
affiche_select_from_lang_directory('lang', $conf_valeur);
} else {
// affichage commentaire
echo "<br><i>" . _($conf_commentaire) . "</i><br>\n";
// affichage saisie variable
if ($conf_nom == "installed_version") {
echo "<b>{$conf_nom} = {$conf_valeur}</b><br>";
} elseif ($conf_type == "texte" || $conf_type == "path") {
echo "<b>{$conf_nom}</b> = <input type=\"text\" size=\"50\" maxlength=\"200\" name=\"tab_new_values[{$conf_nom}]\" value=\"{$conf_valeur}\"><br>";
} elseif ($conf_type == "boolean") {
echo "<b>{$conf_nom}</b> = <select name=\"tab_new_values[{$conf_nom}]\">";
echo "<option value=\"TRUE\"";
if ($conf_valeur == "TRUE") {
echo "selected";
}
echo ">TRUE</option>";
echo "<option value=\"FALSE\"";
if ($conf_valeur == "FALSE") {
echo "selected";
}
echo ">FALSE</option>";
echo "</select><br>";
} elseif (substr($conf_type, 0, 4) == "enum") {
echo "<b>{$conf_nom}</b> = <select name=\"tab_new_values[{$conf_nom}]\">";
$options = explode("/", substr(strstr($conf_type, '='), 1));
for ($i = 0; $i < count($options); $i++) {
echo "<option value=\"" . $options[$i] . "\"";
if ($conf_valeur == $options[$i]) {
echo "selected";
}
echo ">" . $options[$i] . "</option>";
}
echo "</select><br>";
}
echo "<br>";
}
}
echo "</td></tr>\n";
echo "<tr><td align=\"right\">\n";
echo "<input type=\"submit\" value=\"" . _('form_save_modif') . "\"><br>";
echo "</td></tr>\n";
/******************* GESTION DES PLUGINS V1.7 *************************/
//rajout du formulaire de gestion des plugins : à partir de la version 1.7
// - On détecte les plugins puis on propose de les installer
// L'installation du plugin va lancer include/plugins/[nom_du_plugins]/plugin_install.php
// plugin_install.php lance la création des tables supplémentaires;
// normalement le format de nommage des tables est conges_plugin_[nom_du_plugin]. Exemple de table : conges_plugin_cet
// il vaut mieux éviter de surcharger les tables existantes pour éviter les nombreux problèmes de compatibilité
// lors d'un changement de version.
// - Lorsqu'un plugin est installé, l'administrateur ou la personne autorisée pourra activer le plugin.
// Le status qui s'affichera deviendra "activated"
// Soit 4 statuts disponibles : not installed, installed, disable, activated
// Correspondants à 4 fichiers dans le dossier du plugin : plugin_install.php, plugin_uninstall.php, plugin_active.php, plugin_inactive.php
//Les statuts sont retrouvés par la table conges_plugins
//Ensuite, les fichiers à inclure doivent être listés dans include/plugins/[nom_du_plugins]/allfilestoinclude.php
// Ces fichiers à inclure contiennent le coeur de votre plugin.
$my_plugins = scandir(PLUGINS_DIR);
$plug_count = 0;
echo "<table width=\"100%\">\n";
echo "<tr><td>\n";
echo " <fieldset class=\"cal_saisie\">\n";
echo " <legend class=\"boxlogin\"> Plugins</legend>\n";
foreach ($my_plugins as $my_plugin) {
if (is_dir(PLUGINS_DIR . "/{$my_plugin}") && !preg_match("/^\\./", $my_plugin)) {
echo "Plugin détecté : ";
echo "<b> {$my_plugin} </b>. This plugin is installed ? :\n <select name=tab_new_values[" . $my_plugin . "_installed]>";
$sql_plug = "SELECT p_is_active, p_is_install FROM conges_plugins WHERE p_name = '" . $my_plugin . "';";
$ReqLog_plug = SQL::query($sql_plug);
if ($ReqLog_plug->num_rows != 0) {
while ($plug = $ReqLog_plug->fetch_array()) {
$p_install = $plug["p_is_install"];
if ($p_install == '1') {
echo "<option selected='selected' value='1'>Y</option><option value='0'>N</option>";
} else {
echo "<option value='1'>Y</option><option selected='selected' value='0'>N</option>";
}
echo "</select>";
echo " ... Is activated ? : <select name=tab_new_values[" . $my_plugin . "_activated]>";
$p_active = $plug["p_is_active"];
if ($p_active == '1') {
echo "<option selected='selected' value='1'>Y</option><option value='0'>N</option>";
} else {
echo "<option value='1'>Y</option><option selected='selected' value='0'>N</option>";
}
}
} else {
echo "<option value='1'>Y</option><option selected='selected' value='0'>N</option>";
echo "</select>";
echo " ... Is activated ? : <select name=tab_new_values[" . $my_plugin . "_activated]>";
echo "<option value='1'>Y</option><option selected='selected' value='0'>N</option>";
}
echo "</select>";
echo "<br />";
$plug_count++;
}
}
if ($plug_count == 0) {
echo "No plugin detected.";
}
echo "</td></tr>\n";
echo "<tr><td align=\"right\">\n";
echo "<input type=\"submit\" value=\"" . _('form_save_modif') . "\"><br>";
echo "</td></tr>\n";
/**********************************************************************/
echo "</table>\n";
echo "</form>\n";
echo "<br><br>\n";
affiche_bouton_retour($session);
echo "<br><br>\n";
bottom();
}
