1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| $requete = "select numStage,
stage.libelle AS libelleStage,
DATE_FORMAT(dateDebut,'%d/%m/%Y') AS dateDebut,
DATE_FORMAT(dateFin,'%d/%m/%Y') AS dateFin,
lieu,
DATE_FORMAT(dateLimite,'%d/%m/%Y') dateLimite,
nbRestantes,
specialite.libelle AS libelleSpe,
theme.libelle AS libelleTheme
from stage
INNER JOIN specialite ON stage.id_Specialite = specialite.id
INNER JOIN theme ON stage.id_Theme = theme.id
LEFT OUTER JOIN inscrire ON stage.numStage = inscrire.numStage_Stage
LEFT OUTER JOIN personnel ON inscrire.id_Personnel = personnel.num
WHERE exists (select 1 from inscrire where id_Personnel ='$numero')
AND (nbRestantes > 0 and stage.dateLimite >= '$date')
OR (desinscription = 'Oui' AND nbRestantes > 0 and stage.dateLimite >= '$date')
";
if(isset($_POST["themeStage"]) && $_POST["themeStage"]!="")
{
$requete = $requete. " AND id_Theme = '".$_POST["themeStage"]."'";
}
if(isset($_POST["dateDebut"]) && $_POST["dateDebut"]!="")
{
$dateDebut = conversionDateFrançaisVersMySql($_POST["dateDebut"]);
$requete = $requete. " AND stage.dateDebut = '".$dateDebut."' ";
}
if(isset($_POST["dateFin"]) && $_POST["dateFin"]!="")
{
$dateFin = conversionDateFrançaisVersMySql($_POST["dateFin"]);
$requete = $requete. " AND stage.dateFin = '".$dateFin."' ";
}
$requete = $requete. 'ORDER BY numStage'; |
Partager