function confirmer($p_num, $onglet, $DEBUG=FALSE) { $PHP_SELF=$_SERVER['PHP_SELF']; $session=session_id() ; // Récupération des informations $sql1 = '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_num FROM conges_periode WHERE p_num = \''.SQL::quote($p_num).'\''; //printf("sql1 = %s<br>\n", $sql1); $ReqLog1 = SQL::query($sql1) ; // AFFICHAGE TABLEAU echo "<form action=\"$PHP_SELF\" method=\"POST\">\n" ; echo "<table cellpadding=\"2\" class=\"tablo\" width=\"80%\">\n"; echo "<thead>\n"; echo "<tr align=\"center\">\n"; echo "<td>". _('divers_debut_maj_1') ."</td>\n"; echo "<td>". _('divers_fin_maj_1') ."</td>\n"; echo "<td>". _('divers_nb_jours_maj_1') ."</td>\n"; echo "<td>". _('divers_comment_maj_1') ."</td>\n"; echo "<td>". _('divers_type_maj_1') ."</td>\n"; echo "</tr>\n"; echo "</thead>\n"; echo "<tbody>\n"; echo "<tr align=\"center\">\n"; while ($resultat1 = $ReqLog1->fetch_array()) { $sql_date_deb=eng_date_to_fr($resultat1["p_date_deb"]); $sql_demi_jour_deb = $resultat1["p_demi_jour_deb"]; if($sql_demi_jour_deb=="am") $demi_j_deb= _('divers_am_short') ; else $demi_j_deb= _('divers_pm_short') ; $sql_date_fin=eng_date_to_fr($resultat1["p_date_fin"]); $sql_demi_jour_fin = $resultat1["p_demi_jour_fin"]; if($sql_demi_jour_fin=="am") $demi_j_fin= _('divers_am_short') ; else $demi_j_fin= _('divers_pm_short') ; $sql_nb_jours=affiche_decimal($resultat1["p_nb_jours"]); //$sql_type=$resultat1["p_type"]; $sql_type=get_libelle_abs($resultat1["p_type"], $DEBUG); $sql_comment=$resultat1["p_commentaire"]; if( $DEBUG ) { echo "$sql_date_deb _ $demi_j_deb : $sql_date_fin _ $demi_j_fin : $sql_nb_jours : $sql_comment : $sql_type<br>\n"; } echo "<td>$sql_date_deb _ $demi_j_deb</td>\n"; echo "<td>$sql_date_fin _ $demi_j_fin</td>\n"; echo "<td>$sql_nb_jours</td>\n"; echo "<td>$sql_comment</td>\n"; echo "<td>$sql_type</td>\n"; } echo "</tr>\n"; echo "</tbody>\n"; echo "</table><br>\n\n"; echo "<input type=\"hidden\" name=\"p_num_to_delete\" value=\"$p_num\">\n"; echo "<input type=\"hidden\" name=\"session\" value=\"$session\">\n"; echo "<input type=\"hidden\" name=\"onglet\" value=\"$onglet\">\n"; echo "<input type=\"submit\" value=\"". _('form_supprim') ."\">\n"; echo "</form>\n" ; }
function confirmer($p_num, $onglet, $DEBUG = FALSE) { $PHP_SELF = $_SERVER['PHP_SELF']; $session = session_id(); // Récupération des informations $sql1 = '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_num FROM conges_periode WHERE p_num = \'' . SQL::quote($p_num) . '\''; //printf("sql1 = %s<br>\n", $sql1); $ReqLog1 = SQL::query($sql1); // AFFICHAGE TABLEAU echo "<form action=\"{$PHP_SELF}\" method=\"POST\">\n"; echo "<table class=\"table table-responsive table-condensed\">\n"; echo "<thead>\n"; echo "<tr>\n"; echo "<th>" . _('divers_debut_maj_1') . "</th>\n"; echo "<th>" . _('divers_fin_maj_1') . "</th>\n"; echo "<th>" . _('divers_nb_jours_maj_1') . "</th>\n"; echo "<th>" . _('divers_comment_maj_1') . "</th>\n"; echo "<th>" . _('divers_type_maj_1') . "</th>\n"; echo "</tr>\n"; echo "</thead>\n"; echo "<tbody>\n"; echo "<tr>\n"; while ($resultat1 = $ReqLog1->fetch_array()) { $sql_date_deb = eng_date_to_fr($resultat1["p_date_deb"]); $sql_demi_jour_deb = $resultat1["p_demi_jour_deb"]; if ($sql_demi_jour_deb == "am") { $demi_j_deb = _('divers_am_short'); } else { $demi_j_deb = _('divers_pm_short'); } $sql_date_fin = eng_date_to_fr($resultat1["p_date_fin"]); $sql_demi_jour_fin = $resultat1["p_demi_jour_fin"]; if ($sql_demi_jour_fin == "am") { $demi_j_fin = _('divers_am_short'); } else { $demi_j_fin = _('divers_pm_short'); } $sql_nb_jours = affiche_decimal($resultat1["p_nb_jours"]); //$sql_type=$resultat1["p_type"]; $sql_type = get_libelle_abs($resultat1["p_type"], $DEBUG); $sql_comment = $resultat1["p_commentaire"]; if ($DEBUG) { echo "{$sql_date_deb} _ {$demi_j_deb} : {$sql_date_fin} _ {$demi_j_fin} : {$sql_nb_jours} : {$sql_comment} : {$sql_type}<br>\n"; } echo "<td>{$sql_date_deb} _ {$demi_j_deb}</td>\n"; echo "<td>{$sql_date_fin} _ {$demi_j_fin}</td>\n"; echo "<td>{$sql_nb_jours}</td>\n"; echo "<td>{$sql_comment}</td>\n"; echo "<td>{$sql_type}</td>\n"; } echo "</tr>\n"; echo "</tbody>\n"; echo "</table>\n"; echo "<hr/>\n"; echo "<input type=\"hidden\" name=\"p_num_to_delete\" value=\"{$p_num}\">\n"; echo "<input type=\"hidden\" name=\"session\" value=\"{$session}\">\n"; echo "<input type=\"hidden\" name=\"onglet\" value=\"{$onglet}\">\n"; echo "<input class=\"btn btn-danger\" type=\"submit\" value=\"" . _('form_supprim') . "\">\n"; echo "<a class=\"btn\" href=\"{$PHP_SELF}?session={$session}&onglet=demandes_en_cours\">" . _('form_cancel') . "</a>\n"; echo "</form>\n"; }