SELECT planning_periode.*,planning_projet.statut, planning_status.nom as status_nom, planning_status.barre as statut_barre,planning_status.gras as statut_gras,planning_status.italique as statut_italique,planning_status.souligne as statut_souligne, planning_status.couleur as statut_couleur,planning_status.pourcentage as statut_pourcentage, pu.nom as user_nom, pu.couleur as user_couleur, planning_projet.nom as projet_nom, planning_projet.couleur as projet_couleur, pg.nom AS groupe_nom, pu.*,pug.nom AS team_nom, pl.nom as lieu_nom, pl.couleur as lieu_couleur, pr.nom as ressource_nom, pr.couleur as ressource_couleur, planning_projet.budget_montant, planning_projet.budget_temps, planning_projet.createur_id AS projet_createur_id, puc.nom AS nom_createur, pum.nom AS nom_modifier, planning_periode.date_creation, planning_periode.date_modif, CASE WHEN planning_periode.duree_details = 'AM' THEN '08:00:00;08:01:00' WHEN planning_periode.duree_details = 'PM' THEN '14:00:00;14:01:00' WHEN planning_periode.duree_details = 'duree' THEN NULL ELSE planning_periode.duree_details END AS tri_heures_taches FROM planning_periode INNER JOIN planning_projet on planning_projet.projet_id = planning_periode.projet_id INNER JOIN planning_status on planning_status.status_id = planning_periode.statut_tache INNER JOIN planning_user as pu on planning_periode.user_id = pu.user_id LEFT JOIN planning_user as puc on planning_periode.createur_id = puc.user_id LEFT JOIN planning_user as pum on planning_periode.modifier_id = pum.user_id LEFT JOIN planning_user_groupe as pug on pu.user_groupe_id = pug.user_groupe_id LEFT JOIN planning_groupe as pg on planning_projet.groupe_id = pg.groupe_id LEFT JOIN planning_lieu as pl on planning_periode.lieu_id = pl.lieu_id LEFT JOIN planning_ressource as pr on planning_periode.ressource_id = pr.ressource_id WHERE planning_periode.projet_id = planning_projet.projet_id and ( (planning_periode.date_debut <= '2025-04-04' AND planning_periode.date_fin >= '2025-04-04') OR (planning_periode.date_debut <= '2025-05-04' AND planning_periode.date_debut >= '2025-04-04') ) ORDER by date_debut,duree_details asc Planning APS
April 2025 May 2025
W 14 W 15 W 16 W 17 W 18
F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S
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 1 2 3 4
 LECLERCNANTERRE
OFF
 LECLERCRUEIL
OFF
 LECLERCRUEIL
OFF
 LECLERCRUEIL
OFF
 LEROYMERLIN
OFF
 SQYOUEST
OFF
 SQYOUEST
OFF
 SQYOUEST
OFF
 okabe
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
milestoneBAH
OFF
 okabe
OFF



Project : LECLERCNANTERRE(ADSNANTERRE)
Project : LECLERCRUEIL(ADSREUIL)
Project : LECLERCRUEIL(SSIAP1RUEIL)
Project : LECLERCRUEIL(SSIAP2RUEIL)
Project : LEROYMERLIN(ADSLEROYMERLIN)
Project : SQYOUEST(SSIAP1SQY)
Project : SQYOUEST(SSIAP2SQY)
Project : SQYOUEST(SSIAP3SQY)
Project : okabe(SSIAP1OKA)
Project : okabe(SSIAP2OKA)
Project Task Charge
ADSNANTERRE LECLERCNANTERRE
ADSREUIL LECLERCRUEIL
SSIAP1RUEIL LECLERCRUEIL
SSIAP2RUEIL LECLERCRUEIL
ADSLEROYMERLIN LEROYMERLIN
SSIAP1SQY SQYOUEST
SSIAP2SQY SQYOUEST
SSIAP3SQY SQYOUEST
SSIAP1OKA okabe
okabe
BAH MAMADOU CELLOU
ADS

04/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

05/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

06/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

07/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

08/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

09/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

10/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

11/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

12/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

13/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

14/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

15/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

16/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

17/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

18/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

19/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

20/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

21/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

22/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

23/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

24/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

25/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

26/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

27/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

28/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

29/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
okabe
BAH MAMADOU CELLOU
ADS

30/04/2025 12:00
  OKABE
Prochaine
TEST OMAR
Total : 13.5d ( = 324h)
SSIAP2OKA okabe
Move
Move all tasks
Copy Cancel