Planning APS

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

04/03/2025 05/05/2025

	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	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	BAH	OFF
okabe																												OFF

	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