FrameBeurk File
Fmbk/Module/Rhum/Section/Maj/descendSection.php
<?php //FrameBeurk V0.65 Copyright ToolOscope 2016. Licence CeCILL-C.
$result1 = db_QUERY("SELECT NoOrdre FROM Rhum_Section WHERE IdSection = '$IdMaj'");
if (list($NoOrdre) = db_FETCH_ROW($result1)) {
// descendre la section
$result2 = db_QUERY('SELECT count(*) FROM Rhum_Section');
if (list($nbrSection) = db_FETCH_ROW($result2)) {
if ($NoOrdre >= $nbrSection)
Beurk_messageEtape('Section déjà en dernier', true);
else {
$NewOrder = $NoOrdre + 1;
//pas de gestion de version pour cette action, pas d'impact sur les noeuds
$requete = 'UPDATE Rhum_Section AS S1, Rhum_Section AS S2 '
. "SET S1.NoOrdre = $NewOrder, S2.NoOrdre = $NoOrdre "
. "WHERE S1.IdSection = '$IdMaj' AND S2.NoOrdre = $NewOrder AND S2.IdSection <> '$IdMaj'";
if (db_QUERY($requete))
Beurk_messageEtape('Section descendue', false);
else
Beurk_messageEtape('Modification en erreur', true);
}
}
db_FREE($result2);
} else Beurk_messageEtape('Section inconnue', true);
db_FREE($result1);
© 2010-2015 by ToolOscope SASU. © 2016-2018 by Arnaud De Rette. All rights reserved