[19-Feb-2026 16:41:02 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1477,"tournoi_id":1,"e1":1,"e2":7,"s1_raw":"0","s2_raw":"0","phase_text":"Éliminatoire : Demi-finales"}
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":true,"conteste":false,"egalite":true}
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":null,"points_e1":0,"points_e2":0,"vainqueur_id":7,"elim_loser_id":1,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1032","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"1","emarge":"1","j":"3","points":"3","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1038","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"7","emarge":"1","j":"3","points":"3","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":3,"new_points_e1":3,"new_ratio_e1":0,"new_elim_e1":1,"new_j_e2":3,"new_points_e2":3,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1477,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=7 WHERE id=1477 LIMIT 1"}
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1477,"sent_to":[8,1],"isElim":true,"conteste":false,"egalite":true,"vainqueur_id":7,"elim_loser_id":1}
[19-Feb-2026 16:41:02 Europe/Paris] Étape 4 OK match 1477 — phaseElim=1, s1=0, s2=0, gagnant=7, elim=1
[19-Feb-2026 16:41:02 Europe/Paris] ========== TRIGGER STEP 4 : Traitement fin+notation match ==========
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] TRIGGER_CTX step=4 | ctx={"match_id":1478,"tournoi_id":1,"e1":4,"e2":6,"s1_raw":"0","s2_raw":"0","phase_text":"Éliminatoire : Demi-finales"}
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Etat match normalisé | ctx={"s1":0,"s2":0,"isElim":true,"conteste":false,"egalite":true}
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Résultat calcul | ctx={"gagnantTerrain":null,"points_e1":0,"points_e2":0,"vainqueur_id":6,"elim_loser_id":4,"delta_e1":0,"delta_e2":0}
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Avant transaction MAJ | ctx={"te1":{"id":"1035","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"4","emarge":"1","j":"3","points":"3","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"},"te2":{"id":"1037","date":"2026-02-19 16:00:04","tournoi":"1","equipe":"6","emarge":"1","j":"3","points":"3","ratio":"0","elimine":"0","elimine_date":"0000-00-00 00:00:00","beercoins_gagnes":"0"}}
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Nouvelles valeurs | ctx={"new_j_e1":3,"new_points_e1":3,"new_ratio_e1":0,"new_elim_e1":1,"new_j_e2":3,"new_points_e2":3,"new_ratio_e2":0,"new_elim_e2":0}
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Transaction OK étape 4 | ctx={"match_id":1478,"q3":"UPDATE Tournoi_Match SET termine=1, gagnant=6 WHERE id=1478 LIMIT 1"}
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Notifs étape 4 envoyées | ctx={"match_id":1478,"sent_to":[7,17],"isElim":true,"conteste":false,"egalite":true,"vainqueur_id":6,"elim_loser_id":4}
[19-Feb-2026 16:41:02 Europe/Paris] Étape 4 OK match 1478 — phaseElim=1, s1=0, s2=0, gagnant=6, elim=4
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Aucun match qualif en attente | ctx={"tournoi_id":3}
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Aucun match elim en attente -> création next step possible | ctx={"tournoi_id":1}
[19-Feb-2026 16:41:02 Europe/Paris] Tournoi 1 : équipes restantes BEFORE next round => 6(pts:3,ratio:0,j:3), 7(pts:3,ratio:0,j:3)
[19-Feb-2026 16:41:02 Europe/Paris] Tournoi 1 : PAIRS best-vs-worst => 6vs7
[19-Feb-2026 16:41:02 Europe/Paris] ========== TRIGGER STEP 6 : Création tour suivant éliminatoire ==========
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] TRIGGER_CTX step=6 | ctx={"tournoi_id":1,"N":2,"pairs":[[6,7]],"byes":[],"round_label":"Finale"}
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Match tour suivant créé | ctx={"tournoi_id":1,"a":6,"b":7,"table":1,"date":"2026-02-19 16:41:00","phase":"Éliminatoire : Finale"}
[19-Feb-2026 16:41:02 Europe/Paris] [DBG] Transaction création tour suivant OK | ctx={"tournoi_id":1,"created":1,"phase":"Éliminatoire : Finale"}
[19-Feb-2026 16:41:03 Europe/Paris] [DBG] Notif globale tour suivant | ctx={"tournoi_id":1,"round_label":"Finale","players_count":13}
[19-Feb-2026 16:41:03 Europe/Paris] Tournoi 1 : création tour suivant (Finale), matches créés = 1, byes = 0
[2026-02-19 16:41:03] 

ÉTAPE 1

ÉTAPE 2

ÉTAPE 3
ÉTAPE 4
ÉTAPE 5

ÉTAPE 6/7 (Passage tours & Fin tournoi)


--- FIN DU SCRIPT
=== END LOG 2026-02-19 16:41:03 ===