
2026-02-10 12:00:11 - 

ALTER TABLE `planning_periode`  ADD INDEX `idx_user_date_debut` (`user_id`, `date_debut`),  ADD INDEX `idx_projet_date_debut` (`projet_id`, `date_debut`),  ADD INDEX `idx_parent_date_debut` (`parent_id`, `date_debut`)
2026-02-10 12:00:28 - 

ALTER TABLE `planning_periode`  ADD INDEX `idx_user_date_debut` (`user_id`, `date_debut`),  ADD INDEX `idx_projet_date_debut` (`projet_id`, `date_debut`),  ADD INDEX `idx_parent_date_debut` (`parent_id`, `date_debut`)
2026-02-10 13:50:07 - 

ALTER TABLE `planning_periode`  ADD INDEX `idx_user_date_debut` (`user_id`, `date_debut`),  ADD INDEX `idx_projet_date_debut` (`projet_id`, `date_debut`),  ADD INDEX `idx_parent_date_debut` (`parent_id`, `date_debut`)
2026-02-10 13:50:14 - 

ALTER TABLE `planning_periode`  ADD INDEX `idx_user_date_debut` (`user_id`, `date_debut`),  ADD INDEX `idx_projet_date_debut` (`projet_id`, `date_debut`),  ADD INDEX `idx_parent_date_debut` (`parent_id`, `date_debut`)
2026-03-04 14:22:01 - SELECT *
		FROM (
			SELECT *,
				CASE
					WHEN date_fin IS NOT NULL THEN CONCAT(date_fin, ' ', '17')
					duree_details IS NOT NULL
						THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
					WHEN duree LIKE '%AM%'
						CONCAT(date_debut, ' ', '14')
					ELSE
						THEN CONCAT(date_debut, ' ', '17')
				END AS datetime_fin
			FROM planning_periode
			WHERE notif_apres_actif = 'oui'
			AND notif_apres_date_envoyee IS NULL
			AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
		) t
		WHERE (
			   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
			OR (notif_apres_delai_type = 'heure'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
			OR (notif_apres_delai_type = 'minute' AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
		)
		ORDER BY date_debut
2026-03-04 14:22:38 - SELECT *
		FROM (
			SELECT *,
				CASE
					WHEN date_fin IS NOT NULL THEN CONCAT(date_fin, ' ', '17')
					duree_details IS NOT NULL
						THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
					WHEN duree LIKE '%AM%'
						CONCAT(date_debut, ' ', '14')
					ELSE
						THEN CONCAT(date_debut, ' ', '17')
				END AS datetime_fin
			FROM planning_periode
			WHERE notif_apres_actif = 'oui'
			AND notif_apres_date_envoyee IS NULL
			AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
		) t
		WHERE (
			   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
			OR (notif_apres_delai_type = 'heure'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
			OR (notif_apres_delai_type = 'minute' AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
		)
		ORDER BY date_debut
2026-03-04 14:22:48 - SELECT *
		FROM (
			SELECT *,
				CASE
					WHEN date_fin IS NOT NULL THEN CONCAT(date_fin, ' ', '17')
					duree_details IS NOT NULL
						THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
					WHEN duree LIKE '%AM%'
						CONCAT(date_debut, ' ', '14')
					ELSE
						THEN CONCAT(date_debut, ' ', '17')
				END AS datetime_fin
			FROM planning_periode
			WHERE notif_apres_actif = 'oui'
			AND notif_apres_date_envoyee IS NULL
			AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
		) t
		WHERE (
			   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
			OR (notif_apres_delai_type = 'heure'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
			OR (notif_apres_delai_type = 'minute' AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
		)
		ORDER BY date_debut
2026-03-04 14:23:22 - SELECT *
		FROM (
			SELECT *,
				CASE
					WHEN date_fin IS NOT NULL THEN CONCAT(date_fin, ' ', '17')
					duree_details IS NOT NULL
						THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
					WHEN duree LIKE '%AM%'
						CONCAT(date_debut, ' ', '14')
					ELSE
						THEN CONCAT(date_debut, ' ', '17')
				END AS datetime_fin
			FROM planning_periode
			WHERE notif_apres_actif = 'oui'
			AND notif_apres_date_envoyee IS NULL
			AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
		) t
		WHERE (
			   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
			OR (notif_apres_delai_type = 'heure'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
			OR (notif_apres_delai_type = 'minute' AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
		)
		ORDER BY date_debut
2026-03-04 14:24:24 - SELECT *
		FROM (
			SELECT *,
				CASE
					WHEN date_fin IS NOT NULL THEN CONCAT(date_fin, ' ', '17:00:00')
					duree_details IS NOT NULL
						THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
					WHEN duree LIKE '%AM%'
						CONCAT(date_debut, ' ', '14:00:00')
					ELSE
						THEN CONCAT(date_debut, ' ', '17:00:00')
				END AS datetime_fin
			FROM planning_periode
			WHERE notif_apres_actif = 'oui'
			AND notif_apres_date_envoyee IS NULL
			AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
		) t
		WHERE (
			   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
			OR (notif_apres_delai_type = 'heure'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
			OR (notif_apres_delai_type = 'minute' AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
		)
		ORDER BY date_debut
2026-03-04 14:25:29 - SELECT *
		FROM (
			SELECT *,
				CASE
					WHEN date_fin IS NOT NULL
						THEN CONCAT(date_fin, ' ', '17:00:00')
					WHEN duree_details IS NOT NULL
						THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
					WHEN duree LIKE '%AM%'
						CONCAT(date_debut, ' ', '14:00:00')
					ELSE
						THEN CONCAT(date_debut, ' ', '17:00:00')
				END AS datetime_fin
			FROM planning_periode
			WHERE notif_apres_actif = 'oui'
			AND notif_apres_date_envoyee IS NULL
			AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
		) t
		WHERE (
			   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
			OR (notif_apres_delai_type = 'heure'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
			OR (notif_apres_delai_type = 'minute' AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
		)
		ORDER BY date_debut
2026-03-04 14:26:03 - SELECT *
		FROM (
			SELECT *,
				CASE
					WHEN date_fin IS NOT NULL
						THEN CONCAT(date_fin, ' ', '17:00:00')
					WHEN duree_details IS NOT NULL
						THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
					WHEN duree LIKE '%AM%'
						THEN CONCAT(date_debut, ' ', '14:00:00')
					ELSE
						THEN CONCAT(date_debut, ' ', '17:00:00')
				END AS datetime_fin
			FROM planning_periode
			WHERE notif_apres_actif = 'oui'
			AND notif_apres_date_envoyee IS NULL
			AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
		) t
		WHERE (
			   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
			OR (notif_apres_delai_type = 'heure'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
			OR (notif_apres_delai_type = 'minute' AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
		)
		ORDER BY date_debut
2026-03-10 15:29:47 - 
		SELECT * FROM (
		  SELECT *, ROW_NUMBER() OVER (PARTITION BY link_id ORDER BY date_debut, id) AS rn
		  FROM (
			SELECT *,
			  CASE
				WHEN duree_details IS NOT NULL THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 1))
				WHEN duree LIKE '%PM%'         THEN CONCAT(date_debut, ' ', '14:00:00')
				ELSE                                CONCAT(date_debut, ' ', '8:00:00')
			  END AS datetime_debut
			FROM planning_periode
			WHERE notif_avant_actif = 'oui'
			  AND notif_avant_date_envoyee IS NULL
		  ) base
		  WHERE (notif_avant_delai_type = 'jour'    AND NOW() >= DATE_SUB(datetime_debut, INTERVAL notif_avant_delai_nb DAY))
			 OR (notif_avant_delai_type = 'heure'   AND NOW() >= DATE_SUB(datetime_debut, INTERVAL notif_avant_delai_nb HOUR))
			 OR (notif_avant_delai_type = 'minute'  AND NOW() >= DATE_SUB(datetime_debut, INTERVAL notif_avant_delai_nb MINUTE))
		) t
		WHERE rn = 1
		ORDER BY date_debut
		
2026-03-10 15:29:48 - 
		SELECT * FROM (
		  SELECT *, ROW_NUMBER() OVER (PARTITION BY link_id ORDER BY date_debut, id) AS rn
		  FROM (
			SELECT *,
			  CASE
				WHEN duree_details IS NOT NULL THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 1))
				WHEN duree LIKE '%PM%'         THEN CONCAT(date_debut, ' ', '14:00:00')
				ELSE                                CONCAT(date_debut, ' ', '8:00:00')
			  END AS datetime_debut
			FROM planning_periode
			WHERE notif_avant_actif = 'oui'
			  AND notif_avant_date_envoyee IS NULL
		  ) base
		  WHERE (notif_avant_delai_type = 'jour'    AND NOW() >= DATE_SUB(datetime_debut, INTERVAL notif_avant_delai_nb DAY))
			 OR (notif_avant_delai_type = 'heure'   AND NOW() >= DATE_SUB(datetime_debut, INTERVAL notif_avant_delai_nb HOUR))
			 OR (notif_avant_delai_type = 'minute'  AND NOW() >= DATE_SUB(datetime_debut, INTERVAL notif_avant_delai_nb MINUTE))
		) t
		WHERE rn = 1
		ORDER BY date_debut
		
2026-03-10 15:29:49 - 
		SELECT * FROM (
		  SELECT *, ROW_NUMBER() OVER (PARTITION BY link_id ORDER BY date_debut, id) AS rn
		  FROM (
			SELECT *,
			  CASE
				WHEN duree_details IS NOT NULL THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 1))
				WHEN duree LIKE '%PM%'         THEN CONCAT(date_debut, ' ', '14:00:00')
				ELSE                                CONCAT(date_debut, ' ', '8:00:00')
			  END AS datetime_debut
			FROM planning_periode
			WHERE notif_avant_actif = 'oui'
			  AND notif_avant_date_envoyee IS NULL
		  ) base
		  WHERE (notif_avant_delai_type = 'jour'    AND NOW() >= DATE_SUB(datetime_debut, INTERVAL notif_avant_delai_nb DAY))
			 OR (notif_avant_delai_type = 'heure'   AND NOW() >= DATE_SUB(datetime_debut, INTERVAL notif_avant_delai_nb HOUR))
			 OR (notif_avant_delai_type = 'minute'  AND NOW() >= DATE_SUB(datetime_debut, INTERVAL notif_avant_delai_nb MINUTE))
		) t
		WHERE rn = 1
		ORDER BY date_debut
		
2026-03-10 16:49:42 - 
	SELECT * FROM (
	  SELECT *,
		CASE
		  WHEN date_fin IS NOT NULL
			THEN CONCAT(date_fin, ' ', '17:00:00')
		  WHEN duree_details IS NOT NULL
			THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
		  WHEN duree LIKE '%AM%'
			THEN CONCAT(date_debut, ' ', '14:00:00')
		  ELSE
			CONCAT(date_debut, ' ', '17:00:00')
		END AS datetime_fin,
		ROW_NUMBER() OVER (PARTITION BY link_id ORDER BY id) AS rn
	  FROM planning_periode
	  WHERE notif_apres_actif = 'oui'
		AND notif_apres_date_envoyee IS NULL
		AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
	) t
	WHERE rn = 1
	  AND (
		   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
		OR (notif_apres_delai_type = 'heure'   AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
		OR (notif_apres_delai_type = 'minute'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
	  )
	ORDER BY date_debut
	
2026-03-10 16:49:47 - 
	SELECT * FROM (
	  SELECT *,
		CASE
		  WHEN date_fin IS NOT NULL
			THEN CONCAT(date_fin, ' ', '17:00:00')
		  WHEN duree_details IS NOT NULL
			THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
		  WHEN duree LIKE '%AM%'
			THEN CONCAT(date_debut, ' ', '14:00:00')
		  ELSE
			CONCAT(date_debut, ' ', '17:00:00')
		END AS datetime_fin,
		ROW_NUMBER() OVER (PARTITION BY link_id ORDER BY id) AS rn
	  FROM planning_periode
	  WHERE notif_apres_actif = 'oui'
		AND notif_apres_date_envoyee IS NULL
		AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
	) t
	WHERE rn = 1
	  AND (
		   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
		OR (notif_apres_delai_type = 'heure'   AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
		OR (notif_apres_delai_type = 'minute'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
	  )
	ORDER BY date_debut
	
2026-03-10 16:49:51 - 
	SELECT * FROM (
	  SELECT *,
		CASE
		  WHEN date_fin IS NOT NULL
			THEN CONCAT(date_fin, ' ', '17:00:00')
		  WHEN duree_details IS NOT NULL
			THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
		  WHEN duree LIKE '%AM%'
			THEN CONCAT(date_debut, ' ', '14:00:00')
		  ELSE
			CONCAT(date_debut, ' ', '17:00:00')
		END AS datetime_fin,
		ROW_NUMBER() OVER (PARTITION BY link_id ORDER BY id) AS rn
	  FROM planning_periode
	  WHERE notif_apres_actif = 'oui'
		AND notif_apres_date_envoyee IS NULL
		AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
	) t
	WHERE rn = 1
	  AND (
		   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
		OR (notif_apres_delai_type = 'heure'   AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
		OR (notif_apres_delai_type = 'minute'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
	  )
	ORDER BY date_debut
	
2026-03-10 16:49:53 - 
	SELECT * FROM (
	  SELECT *,
		CASE
		  WHEN date_fin IS NOT NULL
			THEN CONCAT(date_fin, ' ', '17:00:00')
		  WHEN duree_details IS NOT NULL
			THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
		  WHEN duree LIKE '%AM%'
			THEN CONCAT(date_debut, ' ', '14:00:00')
		  ELSE
			CONCAT(date_debut, ' ', '17:00:00')
		END AS datetime_fin,
		ROW_NUMBER() OVER (PARTITION BY link_id ORDER BY id) AS rn
	  FROM planning_periode
	  WHERE notif_apres_actif = 'oui'
		AND notif_apres_date_envoyee IS NULL
		AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
	) t
	WHERE rn = 1
	  AND (
		   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
		OR (notif_apres_delai_type = 'heure'   AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
		OR (notif_apres_delai_type = 'minute'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
	  )
	ORDER BY date_debut
	
2026-03-10 16:49:55 - 
	SELECT * FROM (
	  SELECT *,
		CASE
		  WHEN date_fin IS NOT NULL
			THEN CONCAT(date_fin, ' ', '17:00:00')
		  WHEN duree_details IS NOT NULL
			THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
		  WHEN duree LIKE '%AM%'
			THEN CONCAT(date_debut, ' ', '14:00:00')
		  ELSE
			CONCAT(date_debut, ' ', '17:00:00')
		END AS datetime_fin,
		ROW_NUMBER() OVER (PARTITION BY link_id ORDER BY id) AS rn
	  FROM planning_periode
	  WHERE notif_apres_actif = 'oui'
		AND notif_apres_date_envoyee IS NULL
		AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
	) t
	WHERE rn = 1
	  AND (
		   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
		OR (notif_apres_delai_type = 'heure'   AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
		OR (notif_apres_delai_type = 'minute'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
	  )
	ORDER BY date_debut
	
2026-03-10 16:54:19 - 
	SELECT * FROM (
	  SELECT *,
		CASE
		  WHEN date_fin IS NOT NULL
			THEN CONCAT(date_fin, ' ', '17:00:00')
		  WHEN duree_details IS NOT NULL
			THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
		  WHEN duree LIKE '%AM%'
			THEN CONCAT(date_debut, ' ', '14:00:00')
		  ELSE
			CONCAT(date_debut, ' ', '17:00:00')
		END AS datetime_fin,
		ROW_NUMBER() OVER (PARTITION BY link_id ORDER BY id) AS rn
	  FROM planning_periode
	  WHERE notif_apres_actif = 'oui'
		AND notif_apres_date_envoyee IS NULL
		AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
	) t
	WHERE rn = 1
	  AND (
		   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
		OR (notif_apres_delai_type = 'heure'   AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
		OR (notif_apres_delai_type = 'minute'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
	  )
	ORDER BY date_debut
	
2026-03-10 16:54:20 - 
	SELECT * FROM (
	  SELECT *,
		CASE
		  WHEN date_fin IS NOT NULL
			THEN CONCAT(date_fin, ' ', '17:00:00')
		  WHEN duree_details IS NOT NULL
			THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
		  WHEN duree LIKE '%AM%'
			THEN CONCAT(date_debut, ' ', '14:00:00')
		  ELSE
			CONCAT(date_debut, ' ', '17:00:00')
		END AS datetime_fin,
		ROW_NUMBER() OVER (PARTITION BY link_id ORDER BY id) AS rn
	  FROM planning_periode
	  WHERE notif_apres_actif = 'oui'
		AND notif_apres_date_envoyee IS NULL
		AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
	) t
	WHERE rn = 1
	  AND (
		   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
		OR (notif_apres_delai_type = 'heure'   AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
		OR (notif_apres_delai_type = 'minute'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
	  )
	ORDER BY date_debut
	
2026-03-10 16:54:22 - 
	SELECT * FROM (
	  SELECT *,
		CASE
		  WHEN date_fin IS NOT NULL
			THEN CONCAT(date_fin, ' ', '17:00:00')
		  WHEN duree_details IS NOT NULL
			THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
		  WHEN duree LIKE '%AM%'
			THEN CONCAT(date_debut, ' ', '14:00:00')
		  ELSE
			CONCAT(date_debut, ' ', '17:00:00')
		END AS datetime_fin,
		ROW_NUMBER() OVER (PARTITION BY link_id ORDER BY id) AS rn
	  FROM planning_periode
	  WHERE notif_apres_actif = 'oui'
		AND notif_apres_date_envoyee IS NULL
		AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
	) t
	WHERE rn = 1
	  AND (
		   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
		OR (notif_apres_delai_type = 'heure'   AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
		OR (notif_apres_delai_type = 'minute'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
	  )
	ORDER BY date_debut
	
2026-03-10 16:55:41 - 
	SELECT * FROM (
	  SELECT *,
		CASE
		  WHEN date_fin IS NOT NULL
			THEN CONCAT(date_fin, ' ', '17:00:00')
		  WHEN duree_details IS NOT NULL
			THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
		  WHEN duree LIKE '%AM%'
			THEN CONCAT(date_debut, ' ', '14:00:00')
		  ELSE
			CONCAT(date_debut, ' ', '17:00:00')
		END AS datetime_fin,
		ROW_NUMBER() OVER (PARTITION BY link_id ORDER BY id) AS rn
	  FROM planning_periode
	  WHERE notif_apres_actif = 'oui'
		AND notif_apres_date_envoyee IS NULL
		AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
	) t
	WHERE rn = 1
	  AND (
		   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
		OR (notif_apres_delai_type = 'heure'   AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
		OR (notif_apres_delai_type = 'minute'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
	  )
	ORDER BY date_debut
	
2026-03-10 16:56:38 - 
	SELECT * FROM (
	  SELECT *,
		CASE
		  WHEN date_fin IS NOT NULL
			THEN CONCAT(date_fin, ' ', '17:00:00')
		  WHEN duree_details IS NOT NULL
			THEN CONCAT(date_debut, ' ', SUBSTRING_INDEX(duree_details, ';', 2))
		  WHEN duree LIKE '%AM%'
			THEN CONCAT(date_debut, ' ', '14:00:00')
		  ELSE
			CONCAT(date_debut, ' ', '17:00:00')
		END AS datetime_fin,
		ROW_NUMBER() OVER (PARTITION BY link_id ORDER BY id) AS rn
	  FROM planning_periode
	  WHERE notif_apres_actif = 'oui'
		AND notif_apres_date_envoyee IS NULL
		AND FIND_IN_SET(statut_tache, notif_apres_statuts_requis) = 0
	) t
	WHERE rn = 1
	  AND (
		   (notif_apres_delai_type = 'jour'    AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb DAY))
		OR (notif_apres_delai_type = 'heure'   AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb HOUR))
		OR (notif_apres_delai_type = 'minute'  AND NOW() >= DATE_ADD(datetime_fin, INTERVAL notif_apres_delai_nb MINUTE))
	  )
	ORDER BY date_debut
	
2026-03-24 14:54:57 - SELECT *
				FROM planning_projet 
				WHERE 0 = 0AND nom LIKE '%BI%'ORDER BY projet_id ASC
2026-03-24 18:21:47 - SELECT *
				FROM planning_projet 
				WHERE 0 = 0
				AND 'user_id', '<>', 'publicspl' AND nom LIKE '%Chloé%'ORDER BY user_id ASC
2026-03-24 18:21:47 - SELECT *
				FROM planning_projet 
				WHERE 0 = 0
				AND 'user_id', '<>', 'publicspl' AND user_id LIKE '%Chloé%'ORDER BY user_id ASC
2026-03-24 18:25:34 - SELECT *
				FROM planning_projet 
				WHERE 0 = 0
				AND 'user_id', '<>', 'publicspl' AND nom LIKE '%Chloé%'ORDER BY user_id ASC
2026-03-24 18:25:34 - SELECT *
				FROM planning_projet 
				WHERE 0 = 0
				AND 'user_id', '<>', 'publicspl' AND user_id LIKE '%Chloé%'ORDER BY user_id ASC
2026-03-24 18:29:43 - SELECT *
				FROM planning_projet 
				WHERE 0 = 0
				AND 'user_id', '<>', 'publicspl' AND nom LIKE '%Chloé%'ORDER BY user_id ASC
2026-03-24 18:29:43 - SELECT *
				FROM planning_projet 
				WHERE 0 = 0
				AND 'user_id', '<>', 'publicspl' AND user_id LIKE '%Chloé%'ORDER BY user_id ASC
2026-03-24 18:29:43 - SELECT *
				FROM planning_projet 
				WHERE 0 = 0
				AND 'user_id', '<>', 'publicspl' AND nom LIKE '%Cloe%'ORDER BY user_id ASC
2026-03-24 18:29:43 - SELECT *
				FROM planning_projet 
				WHERE 0 = 0
				AND 'user_id', '<>', 'publicspl' AND user_id LIKE '%Cloe%'ORDER BY user_id ASC
2026-03-24 18:33:33 - SELECT *
				FROM planning_projet 
				WHERE 0 = 0
				AND 'user_id', '<>', 'publicspl' AND nom LIKE '%pierre%'ORDER BY user_id ASC
2026-03-24 18:33:33 - SELECT *
				FROM planning_projet 
				WHERE 0 = 0
				AND 'user_id', '<>', 'publicspl' AND user_id LIKE '%pierre%'ORDER BY user_id ASC
2026-03-24 18:35:28 - SELECT *
				FROM planning_projet 
				WHERE 0 = 0
				AND 'user_id', '<>', 'publicspl' AND nom LIKE '%pierre%'ORDER BY user_id ASC
2026-03-24 18:38:11 - SELECT *
				FROM planning_user 
				WHERE 0 = 0
				AND 'user_id', '<>', 'publicspl' AND nom LIKE '%Pierre%'ORDER BY user_id ASC
2026-03-24 18:38:11 - SELECT *
				FROM planning_user 
				WHERE 0 = 0
				AND 'user_id', '<>', 'publicspl' AND user_id LIKE '%Pierre%'ORDER BY user_id ASC
2026-03-24 18:39:38 - SELECT *
				FROM planning_user 
				WHERE 0 = 0
				AND 'user_id', '<>', 'publicspl' AND nom LIKE '%pierre%'ORDER BY user_id ASC
2026-04-13 10:20:20 - 
0
0
CREATE TABLE `planning_lieu` (
  `lieu_id` varchar(20) collate0 latin1_general_ci NOT NULL default '',
  `nom` varchar(50) collate latin1_general_ci NOT NULL default '',
  `commentaire` TEXT collate latin1_general_ci default NULL,
  `exclusif` TINYINT NULL DEFAULT '0' COLLATE 'latin1_general_ci',
  `couleur` varchar(6) DEFAULT NULL,
  PRIMARY KEY  (`lieu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
2026-04-13 10:20:57 - 
0
0
CREATE TABLE `planning_lieu` (
  `lieu_id` varchar(20) collate0 latin1_general_ci NOT NULL default '',
  `nom` varchar(50) collate latin1_general_ci NOT NULL default '',
  `commentaire` TEXT collate latin1_general_ci default NULL,
  `exclusif` TINYINT NULL DEFAULT '0' COLLATE 'latin1_general_ci',
  `couleur` varchar(6) DEFAULT NULL,
  PRIMARY KEY  (`lieu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
