function edition($login, $edit_id, $DEBUG = FALSE)
{
//$DEBUG = TRUE ;
$session = session_id();
// recup infos du user
$tab_info_user = recup_info_user_pour_edition($login, $DEBUG);
// recup infos de l'édition
$tab_info_edition = recup_info_edition($edit_id, $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);
if ($DEBUG) {
echo "tab_info_user :<br>\n";
print_r($tab_info_user);
echo "<br><br>\n";
echo "tab_info_edition :<br>\n";
print_r($tab_info_edition);
echo "<br><br>\n";
echo "tab_type_cong :<br>\n";
print_r($tab_type_cong);
echo "<br><br>\n";
echo "tab_type_conges_exceptionnels :<br>\n";
print_r($tab_type_conges_exceptionnels);
echo "<br><br>\n";
echo "tab_type_all_cong :<br>\n";
print_r($tab_type_all_cong);
echo "<br><br>\n";
echo "numero edition = {$edit_id}<br>\n";
}
/**************************************/
/* affichage du texte en haut de page */
/**************************************/
echo "\n<!-- affichage du texte en haut de page -->\n";
echo "<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"770\">\n";
echo "<tr align=\"center\">\n";
echo "<td>" . $_SESSION['config']['texte_haut_edition_papier'] . "<br><br></td>\n";
echo "</tr>\n";
echo "</table>\n";
/**************************************/
/* affichage du TITRE */
/**************************************/
echo "\n<!-- affichage du TITRE -->\n";
echo "<H1>" . $tab_info_user['nom'] . " " . $tab_info_user['prenom'] . "</H1>\n\n";
$tab_date = explode("-", $tab_info_edition['date']);
echo "<H2>" . _('editions_bilan_au') . " {$tab_date['2']} / {$tab_date['1']} / {$tab_date['0']}</H2>\n\n";
/****************************/
/* tableau Bilan des Conges */
/****************************/
// affichage du tableau récapitulatif des solde de congés d'un user DE cette edition !
affiche_tableau_bilan_conges_user_edition($tab_info_user, $tab_info_edition, $tab_type_cong, $tab_type_conges_exceptionnels, $DEBUG);
$quotite = $tab_info_user['quotite'];
echo "<h3> " . _('divers_quotite') . " : {$quotite} % </h3>\n";
echo "<br><br><br>\n";
if ($_SESSION['config']['affiche_date_traitement']) {
echo "<table cellpadding=\"0\" cellspacing=\"0\" border=\"1\" width=\"870\">\n";
} else {
echo "<table cellpadding=\"0\" cellspacing=\"0\" border=\"1\" width=\"770\">\n";
}
echo "<tr align=\"center\">\n";
echo "<td><h3>" . _('editions_historique') . " :</h3></td>\n";
echo "</tr>\n";
/*********************************************/
/* Tableau Historique des Conges et demandes */
/*********************************************/
echo "\n<!-- Tableau Historique des Conges et demandes -->\n";
echo "<tr align=\"center\">\n";
echo "<td>\n";
// Récupération des informations
// on ne recup QUE les periodes de l'edition choisie
$sql2 = "SELECT p_login, p_date_deb, p_demi_jour_deb, p_date_fin, p_demi_jour_fin, p_nb_jours, p_commentaire, p_type, p_etat, p_date_demande, p_date_traitement ";
$sql2 = $sql2 . "FROM conges_periode ";
$sql2 = $sql2 . "WHERE p_edition_id = {$edit_id} ";
$sql2 = $sql2 . "ORDER BY p_date_deb ASC ";
$ReqLog2 = SQL::query($sql2);
$count2 = $ReqLog2->num_rows;
if ($count2 == 0) {
echo "<b>" . _('editions_aucun_conges') . "</b><br>\n";
} else {
// AFFICHAGE TABLEAU
if ($_SESSION['config']['affiche_date_traitement']) {
echo "<table cellpadding=\"2\" class=\"tablo-edit\" width=\"850\">\n";
} else {
echo "<table cellpadding=\"2\" class=\"tablo-edit\" width=\"750\">\n";
}
/*************************************/
/* affichage anciens soldes */
/*************************************/
echo "\n<!-- affichage anciens soldes -->\n";
echo "<tr>\n";
echo "<td colspan=\"5\">\n";
$edition_precedente_id = get_id_edition_precedente_user($login, $edit_id, $DEBUG);
if ($edition_precedente_id == 0) {
echo "<b>" . _('editions_soldes_precedents_inconnus') . " !... ";
} else {
$tab_edition_precedente = recup_info_edition($edition_precedente_id, $DEBUG);
foreach ($tab_type_cong as $id_abs => $libelle) {
echo _('editions_solde_precedent') . " <b>{$libelle} : " . $tab_edition_precedente['conges'][$id_abs] . "</b><br>\n";
}
foreach ($tab_type_conges_exceptionnels as $id_abs => $libelle) {
echo _('editions_solde_precedent') . " <b>{$libelle} : " . $tab_edition_precedente['conges'][$id_abs] . "</b><br>\n";
}
}
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";
while ($resultat2 = $ReqLog2->fetch_array()) {
$sql_p_date_deb = eng_date_to_fr($resultat2["p_date_deb"]);
$sql_p_demi_jour_deb = $resultat2["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($resultat2["p_date_fin"]);
$sql_p_demi_jour_fin = $resultat2["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 = $resultat2["p_nb_jours"];
$sql_p_commentaire = $resultat2["p_commentaire"];
$sql_p_type = $resultat2["p_type"];
$sql_p_etat = $resultat2["p_etat"];
$sql_p_date_demande = $resultat2["p_date_demande"];
$sql_p_date_traitement = $resultat2["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";
}
/*************************************/
/* affichage nouveaux soldes */
/*************************************/
echo "\n<!-- affichage nouveaux soldes -->\n";
echo "<tr>\n";
echo "<td colspan=\"5\">\n";
foreach ($tab_type_cong as $id_abs => $libelle) {
echo _('editions_nouveau_solde') . " <b>{$libelle} : " . $tab_info_edition['conges'][$id_abs] . "</b><br>\n";
}
echo "<td>\n";
echo "</tr>\n";
echo "</table>\n\n";
}
echo "<br><br>\n";
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
/*************************************/
/* affichage des zones de signature */
/*************************************/
echo "\n<!-- affichage des zones de signature -->\n";
echo "<br>\n";
echo "<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"770\">\n";
echo "<tr align=\"center\">\n";
echo "<td> </td>\n";
echo "<td align=\"left\">\n";
echo "<b>" . _('editions_date') . " : <br>" . _('editions_signature_1') . " :</b><br><br><br><br><br><br><br><br><br><br>\n";
echo "</td>\n";
echo "<td> </td>\n";
echo "<td align=\"left\">\n";
echo "<b>" . _('editions_date') . " : <br>" . _('editions_signature_2') . " :</b><br><i>(" . _('editions_cachet_etab') . ")</i><br><br><br><br><br><br><br><br><br>\n";
echo "</td>\n";
echo "<td> </td>\n";
echo "</tr>\n";
echo "</table>\n";
/*************************************/
/* affichage du texte en bas de page */
/*************************************/
echo "\n<!-- affichage du texte en bas de page -->\n";
echo "<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"770\">\n";
echo "<tr align=\"center\">\n";
echo "<td><br>" . $_SESSION['config']['texte_bas_edition_papier'] . "</td>\n";
echo "</tr>\n";
echo "</table>\n";
}
function edition($user_login, $edit_id, $session, $DEBUG = FALSE)
{
$tab_info_user = recup_info_user_pour_edition($user_login, $DEBUG);
// recup infos de l'édition
$tab_info_edition = recup_info_edition($edit_id, $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);
head_ed($tab_info_user, $tab_info_edition, $tab_type_cong, $tab_type_conges_exceptionnels, $edit_id, $DEBUG);
if ($DEBUG) {
echo "tab_info_user :<br>\n";
print_r($tab_info_user);
echo "<br><br>\n";
echo "tab_info_edition :<br>\n";
print_r($tab_info_edition);
echo "<br><br>\n";
echo "tab_type_cong :<br>\n";
print_r($tab_type_cong);
echo "<br><br>\n";
echo "tab_type_conges_exceptionnels :<br>\n";
print_r($tab_type_conges_exceptionnels);
echo "<br><br>\n";
echo "tab_type_all_cong :<br>\n";
print_r($tab_type_all_cong);
echo "<br><br>\n";
echo "numero edition = {$edit_id}<br>\n";
}
/*********************************************/
/* Tableau Historique des Conges et demandes */
/*********************************************/
echo "\n<!-- Tableau Historique des Conges et demandes -->\n";
echo "<tr align=\"center\">\n";
echo "<td>\n";
// Récupération des informations
// on ne recup QUE les periodes de l'edition choisie
$sql2 = "SELECT p_login, p_date_deb, p_demi_jour_deb, p_date_fin, p_demi_jour_fin, p_nb_jours, p_commentaire, p_type, p_etat, p_date_demande, p_date_traitement ";
$sql2 = $sql2 . "FROM conges_periode ";
$sql2 = $sql2 . "WHERE p_edition_id = {$edit_id} ";
$sql2 = $sql2 . "ORDER BY p_date_deb ASC ";
$ReqLog2 = SQL::query($sql2);
$count2 = $ReqLog2->num_rows;
if ($count2 == 0) {
echo "<b>" . _('editions_aucun_conges') . "</b><br>\n";
} else {
// AFFICHAGE TABLEAU
if ($_SESSION['config']['affiche_date_traitement']) {
echo "<table cellpadding=\"2\" class=\"tablo-edit\" width=\"850\">\n";
} else {
echo "<table cellpadding=\"2\" class=\"tablo-edit\" width=\"750\">\n";
}
/*************************************/
/* affichage anciens soldes */
/*************************************/
echo "\n<!-- affichage anciens soldes -->\n";
echo "<tr>\n";
echo "<td colspan=\"5\">\n";
$edition_precedente_id = get_id_edition_precedente_user($user_login, $edit_id, $DEBUG);
if ($edition_precedente_id == 0) {
echo "<b>" . _('editions_soldes_precedents_inconnus') . " !... ";
} else {
$tab_edition_precedente = recup_info_edition($edition_precedente_id, $DEBUG);
foreach ($tab_type_cong as $id_abs => $libelle) {
echo _('editions_solde_precedent') . " <b>{$libelle} : " . $tab_edition_precedente['conges'][$id_abs] . "</b><br>\n";
}
foreach ($tab_type_conges_exceptionnels as $id_abs => $libelle) {
echo _('editions_solde_precedent') . " <b>{$libelle} : " . $tab_edition_precedente['conges'][$id_abs] . "</b><br>\n";
}
}
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";
while ($resultat2 = $ReqLog2->fetch_array()) {
$sql_p_date_deb = eng_date_to_fr($resultat2["p_date_deb"]);
$sql_p_demi_jour_deb = $resultat2["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($resultat2["p_date_fin"]);
$sql_p_demi_jour_fin = $resultat2["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 = $resultat2["p_nb_jours"];
$sql_p_commentaire = $resultat2["p_commentaire"];
$sql_p_type = $resultat2["p_type"];
$sql_p_etat = $resultat2["p_etat"];
$sql_p_date_demande = $resultat2["p_date_demande"];
$sql_p_date_traitement = $resultat2["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";
}
/*************************************/
/* affichage nouveaux soldes */
/*************************************/
echo "\n<!-- affichage nouveaux soldes -->\n";
echo "<tr>\n";
echo "<td colspan=\"5\">\n";
foreach ($tab_type_cong as $id_abs => $libelle) {
echo _('editions_nouveau_solde') . " <b>{$libelle} : " . $tab_info_edition['conges'][$id_abs] . "</b><br>\n";
}
echo "<td>\n";
echo "</tr>\n";
echo "</table>\n\n";
}
echo "<br><br>\n";
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
bottom_ed();
}
$this->Cell(0, 3, $_SESSION['config']['texte_bas_edition_papier'], 0, 1, 'C');
$this->Ln(10);
}
}
// recup du tableau des types de conges (seulement les conges)
$tab_type_cong = recup_tableau_types_conges();
// recup du tableau des types de conges exceptionnels (seulement les conges exceptionnels)
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);
// recup infos du user
$tab_info_user = recup_info_user_pour_edition($login);
// recup infos de l'édition
$tab_info_edition = recup_info_edition($edit_id);
/**************************************/
/* on commence l'affichage ... */
/**************************************/
header('content-type: application/pdf');
//header('content-Disposition: attachement; filename="downloaded.pdf"'); // pour IE
$pdf = new PDF('P', 'mm', 'A4', true, "UTF-8");
//$pdf->Open();
$pdf->AddPage();
$pdf->SetFillColor(200);
/**************************************/
/* affichage du texte en haut de page */
/**************************************/
// fait dans le header de la classe (cf + haut)