1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
//Bilan de mission à réclamer dans les deux mois
$reclBM='SELECT bilan_mission.ID_mission, nom,prénom,resp_opé'
. ' AS Responsable,'
. ' MAX(date_add(date_realisation,'
. ' INTERVAL 1 Year )) AS Anniversaire'
. ' FROM agent,mission,bilan_mission'
. ' WHERE agent.ID=mission.ID_agent'
. ' AND mission.ID=bilan_mission.ID_mission'
. ' AND ((agent.ID_pôle=\''.$_SESSION["pole"].'\') OR ('
. $_SESSION["pole"].'=\'0\'))'
. ' GROUP BY bilan_mission.ID_mission, nom,prénom,resp_opé'
. ' HAVING MAX(date_add(date_realisation, INTERVAL 1 Year )) AS Anniversaire<\''.$dans_deux_mois.'\''
. ' AND NOT EXISTS (SELECT bilan_mission.ID_mission, nom,prénom,resp_opé'
. ' AS Responsable'
. ' FROM agent,mission,bilan_mission'
. ' WHERE agent.ID=mission.ID_agent'
. ' AND mission.ID=bilan_mission.ID_mission'
. ' AND ((agent.ID_pôle=\''.$_SESSION["pole"].'\') OR ('
. $_SESSION["pole"].'=\'0\'))'
. 'HAVING date_demande>aniversaire)'; |
Partager