' . afficheTexte('txt_recherche_no_result', 0) . '
';
}
$strDisplay = (!isset($_GET['pg']) && !isset($_GET['btn_recherche'])) ? '' : ' show';
$strIcon = "'" . $vDomaine . "/images/search-icon.png'";
$strRetour .= '
' . afficheTexte('txt_recherche_no_result', 0) . '
';
}
$strDisplay = (!isset($_GET['pg']) && !isset($_GET['btn_recherche'])) ? '' : ' show';
$strIcon = "'" . $vDomaine . "/images/search-icon.png'";
$strRetour .= '
';
$strAffichage .=$arrListeParticipants[$x]['no_bib_remis_date'];
$strAffichage .='
';
$strAffichage .='';
$strAffichage .=$arrListeParticipants[$x]['no_bib_remis_par'];
break;
case 'factures':
case 'confirmm':
$arrFactures = fxGetFactures($arrListeParticipants[$x]['pec_id_original']); // trouver toutes les factures pour cette épreuve
if ($arrFactures != null) {
$strAffichageTemp = '';
for ($intCtr2 = 1; $intCtr2 <= count($arrFactures); $intCtr2++) {
$strAffichageTemp .= $strAffichage;
if ($intCtr2 > 1) {
$strAffichageTemp .= '
';
}
foreach ($arrFields as $intIndex => $strField) { // remplacer {x} dans le mask de la colonne
$strAffichageTemp = str_replace('{' . $intIndex . '}', $arrListeParticipants[$x][fxchecklanguePromoteur($strField, $arrCol['multilingue'], $strLangue)], $strAffichageTemp);
}
}
$strAffichage = $strAffichageTemp;
}
break;
case 'race':
foreach ($arrFields as $intIndex => $strField) { // remplacer {x} dans le mask de la colonne
$strReplace = fxGetTabInscription(fxchecklanguePromoteur($strField, $arrCol['multilingue'], $strLangue), $arrListeParticipants[$x]['epr_id'], 'epreuves', 'epr');
if (trim($strReplace) != '') {
$strReplace .= '
';
}
$strAffichage = str_replace('{' . $intIndex . '}', $strReplace, $strAffichage);
}
break;
case 'money': //format dollar
foreach ($arrFields as $intIndex => $strField) { // remplacer {x} dans le mask de la colonne
$strAffichage = str_replace('{' . $intIndex . '}', fxShowPrix($arrListeParticipants[$x][fxchecklanguePromoteur($strField, $arrCol['multilingue'], $strLangue)], $strLangue), $strAffichage);
}
break;
default:
if ($arrCol['format'] == 'participant') {
if (fxIsParEquipe($arrListeParticipants[$x]['pec_id_original'], $arrListeParticipants[$x]['epr_id'])) {
$tabCapitaine = fxGetCapitaine($arrListeParticipants[$x]['pec_id'], $arrListeParticipants[$x]['epr_id']);
if ($tabCapitaine != null) {
$arrListeParticipants[$x]['par_prenom'] = $tabCapitaine['par_prenom'];
$arrListeParticipants[$x]['par_nom'] = $tabCapitaine['par_nom'];
}
/* else
afficheTexte('promoteur_no_captain'); */
}
}
foreach ($arrFields as $intIndex => $strField) { // remplacer {x} dans le mask de la colonne
// $strField ici {}on change par la valeur du champ le champ
$strAffichage = str_replace('{' . $intIndex . '}', $arrListeParticipants[$x][fxchecklanguePromoteur($strField, $arrCol['multilingue'], $strLangue)], $strAffichage);
}
// MSIN-3679 patch eve_id
$eve_idcode=urlencode(base64_encode($arrListeParticipants[$x]['eve_id'])) ;
$strAffichage = str_replace('{99}',$eve_idcode, $strAffichage);
}
if ($arrCol['format'] == 'team') { //si épreuve solo, ne pas afficher lev nom d'équipe
if ($intEquipe != 1) {
$strAffichage = '';
}
}
/* if (count($arrFields) == 1 && trim($arrListeParticipants[$x][fxchecklanguePromoteur($arrFields[0], $arrCol['multilingue'], $strLangue)]) == '') { // si la valeur est vide, ne rien afficher
$strAffichage = '';
} */
$strResults .= '
' . $strAffichage . ' ';
}
return $strResults;
}
function fxchecklanguePromoteur($strField, $intMultilingue, $langues) {
if (intval($intMultilingue) == 1)
return $strField . "_" . $langues;
else
return $strField;
}
function fxGetchampsPromoteur($blnDon, $strLangue) {
global $vDomaine, $vRepertoireFichiers;
if ($blnDon) {
$arrColonnes = array(
1 => array(
'field' => 'com_nom,com_prenom',
'align' => 'left',
'format' => 'string',
'mask' => '{0}, {1}',
'multilingue' => 0,
'label_fr' => 'Donateur',
'label_en' => 'Donator'
),
2 => array(
'field' => 'epr_categorie,epr_type,epr_nom',
'align' => 'left',
'format' => 'race',
'mask' => '
{0} {1}{2}',
'multilingue' => 1,
'label_fr' => 'Épreuve',
'label_en' => 'Race'
),
3 => array(
'field' => 'pec_nom_equipe',
'align' => 'left',
'format' => 'team',
'mask' => '{0}',
'multilingue' => 0,
'label_fr' => ' Équipe',
'label_en' => 'Team'
),
4 => array(
'field' => 'par_nom,par_prenom',
'align' => 'left',
'format' => 'string',
'mask' => '{0}, {1}',
'multilingue' => 0,
'label_fr' => 'Participant',
'label_en' => 'Participant'
),
5 => array(
'field' => 'pd_montant',
'align' => 'right',
'format' => 'money',
'mask' => '{0}',
'multilingue' => 0,
'label_fr' => 'Montant',
'label_en' => 'Amount'
),
6 => array(
'field' => 'no_panier,no_commande',
'align' => 'left',
'format' => ' factures',
'mask' => '
{1} ',
'multilingue' => 0,
'label_fr' => '# commande',
'label_en' => 'Order #'
),
7 => array(
'field' => 'pd_recu_pdf',
'align' => 'left',
'format' => 'string',
'mask' => '
PDF ',
'multilingue' => 0,
'label_fr' => 'Reçu',
'label_en' => 'Receipt'
)
);
} else {
$strRenvoi = ($strLangue == 'fr') ? "RENVOI" : "RESEND";
$arrColonnes = array(
1 => array(
'field' => 'epr_categorie,epr_type,epr_nom',
'align' => 'left',
'format' => 'race',
'mask' => '
{0} {1}{2}',
'multilingue' => 1,
'label_fr' => 'Épreuve',
'label_en' => 'Race'
),
2 => array(
'field' => 'par_nom,par_prenom',
'align' => 'left',
'format' => '^particpant',
'mask' => '{0}, {1}',
'multilingue' => 0,
'label_fr' => 'Nom du participant',
'label_en' => 'Participant\'s name'
),
3 => array(
'field' => '',
'align' => 'left',
'format' => 'bib',
'mask' => '',
'multilingue' => 0,
'label_fr' => afficheTexte('promoteur_bib_number', 0),
'label_en' => afficheTexte('promoteur_bib_number', 0)
),
4 => array(
'field' => '',
'align' => 'left',
'format' => 'details',
'mask' => '',
'multilingue' => 0,
'label_fr' => 'Détails',
'label_en' => 'Details'
),5 => array(
'field' => '',
'align' => 'left',
'format' => 'management',
'mask' => '',
'multilingue' => 0,
'label_fr' => 'Gestion',
'label_en' => 'Management'
),
6 => array(
'field' => '',
'align' => 'left',
'format' => 'edit',
'mask' => '',
'multilingue' => 0,
'label_fr' => 'Modifiée',
'label_en' => 'Modified'
),
7 => array(
'field' => 'no_panier,no_commande',
'align' => 'left',
'format' => 'string',// MSIN-3679
'mask' => '
{1} ',
'multilingue' => 0,
'label_fr' => '# commande',
'label_en' => 'Order #'
),
8 => array(
'field' => 'no_panier,no_commande',
'align' => 'left',
'format' => 'confirm',
'mask' => '
' . $strRenvoi . ' ',
'multilingue' => 0,
'label_fr' => 'Confirmation',
'label_en' => 'Confirmation'
)
);
}
return $arrColonnes;
}
function fxSetBibManuel($strAction, $intEvenement, $intNewNoBib, $intEpreuveCommandee, $intEpreuve, $intPartipcipant, $strLangue = 'fr') {
global $objDatabase;
$arrRetour = array('state' => 'error');
$intEveId = base64_decode(urldecode($intEvenement));
$_SESSION['promoteur_eve_id'] = base64_decode(urldecode($intEvenement));
$sqlEpreuve = "SELECT * FROM inscriptions_epreuves WHERE epr_id = " . intval($intEpreuve);
$tabEpreuve = $objDatabase->fxGetRow($sqlEpreuve);
$strBib = $intNewNoBib;
$sqlTeam = "SELECT * FROM resultats_participants WHERE pec_id = " . intval($intEpreuveCommandee) . " ORDER BY no_bib";
$tabTeam = $objDatabase->fxGetResults($sqlTeam);
// MSIN-4464 — audit dossard (apres UPDATE reussi uniquement).
if (!function_exists('fxFicheAuditRecordChange')) {
require_once dirname(__FILE__) . '/inc_fx_fiche_audit.php';
}
switch($strAction) {
case 'no_bib':
if ($tabEpreuve['epr_equipe'] == 0 || ($tabEpreuve['epr_equipe'] == 1 && $tabEpreuve['epr_bib_mode'] == 1)) {
// verifier si new_no_bib existe
$sqlNoBib = "SELECT no_bib FROM resultats_participants WHERE no_bib LIKE '%" . "-" . $intNewNoBib . "' AND eve_id = " . intval($intEveId);
$qryNoBib = $objDatabase->fxGetResults($sqlNoBib);
if ($qryNoBib != null) {
if ($strLangue == 'fr')
$_SESSION['msg'] = 'p155';
else
$_SESSION['msg'] = 'p555';
}
$strOldBib = (string)$objDatabase->fxGetVar(
'SELECT no_bib FROM resultats_participants WHERE par_id = ' . intval($intPartipcipant) . ' LIMIT 1'
);
$sqlUpdate = "UPDATE resultats_participants SET par_modification_promoteur = 1, no_bib = '" . fxUnescape($strBib) . "', par_maj = '" . fxGetDateTime() . "' WHERE epr_id = " . intval($intEpreuve) . " AND par_id = " . intval($intPartipcipant);
$qryUpdate = $objDatabase->fxQuery($sqlUpdate);
if (!$qryUpdate) {
fxcreer_log("Erreur durant assignation manuelle du numero de dossard (" . $intPartipcipant . ")");
} else {
if (function_exists('fxEvtErreurResoudre')) {
fxEvtErreurResoudre('bib_auto_miss', (int)$intEpreuve, (int)$intPartipcipant);
}
fxFicheAuditRecordChange(
intval($intPartipcipant),
'no_bib',
$strOldBib,
fxUnescape($strBib),
'bib_manuel',
intval($intEveId)
);
$arrRetour['state'] = 'success';
}
} elseif($tabEpreuve['epr_equipe'] == 1 && $tabEpreuve['epr_bib_mode'] == 0) {
$strOldBib = (string)$objDatabase->fxGetVar(
'SELECT no_bib FROM resultats_participants WHERE par_id = ' . intval($intPartipcipant) . ' LIMIT 1'
);
$sqlUpdateTeamPart = "UPDATE resultats_participants SET par_modification_promoteur = 1, no_bib = '" . $intNewNoBib . "', par_maj = '" . fxGetDateTime() . "' WHERE par_id = " . intval($intPartipcipant);
$qryUpdateTeam = $objDatabase->fxQuery($sqlUpdateTeamPart);
if (!$qryUpdateTeam) {
fxcreer_log("Erreur durant assignation manuelle du numero de dossard (" . $intPartipcipant . ")");
} else {
if (function_exists('fxEvtErreurResoudre')) {
fxEvtErreurResoudre('bib_auto_miss', (int)$intEpreuve, (int)$intPartipcipant);
}
fxFicheAuditRecordChange(
intval($intPartipcipant),
'no_bib',
$strOldBib,
(string)$intNewNoBib,
'bib_manuel',
intval($intEveId)
);
$arrRetour['state'] = 'success';
}
}
break;
case 'no_equipe':
if ($tabEpreuve['epr_equipe'] == 1 && $strAction == 'no_equipe') {
// verifier si new_no_bib existe
$sqlNoBib = "SELECT no_equipe FROM resultats_epreuves_commandees WHERE no_equipe LIKE '%" . $intNewNoBib . "' AND eve_id = " . intval($intEveId);
$qryNoBib = $objDatabase->fxGetResults($sqlNoBib);
if ($qryNoBib != null) {
if ($strLangue == 'fr')
$_SESSION['msg'] = 'p156';
else
$_SESSION['msg'] = 'p556';
}
if ($strAction == 'no_equipe') {
// update no_equipe
$sqlUpdate = "UPDATE resultats_epreuves_commandees SET no_equipe = '" . fxUnescape($strBib) . "' WHERE pec_id_original = " . intval($intEpreuveCommandee);
$qryUpdate = $objDatabase->fxQuery($sqlUpdate);
}
$intCtr = 1;
for ($i = 1; $i <= count($tabTeam); $i++) {
$intParTeam = intval($tabTeam[$i]['par_id']);
$strOldBibTeam = (string)($tabTeam[$i]['no_bib'] ?? '');
$strNewBibTeam = '';
if ($strAction == 'no_equipe' && $tabEpreuve['epr_bib_mode'] == 0) {
if (intval($tabTeam[$i]['rol_id']) == 1) {
$strNewBibTeam = (string)(intval($strBib) * 10);
$sqlUpdatePart = "UPDATE resultats_participants SET par_modification_promoteur = 1, no_bib = " . intval($strBib) * 10 . ", par_maj = '" . fxGetDateTime() . "' WHERE par_id = " . $intParTeam;
} else {
$strNewBibTeam = (string)$strBib . $intCtr;
$sqlUpdatePart = "UPDATE resultats_participants SET par_modification_promoteur = 1, no_bib = '" . $strBib . $intCtr . "', par_maj = '" . fxGetDateTime() . "' WHERE par_id = " . $intParTeam;
$intCtr++;
}
$qryUpdatePart = $objDatabase->fxQuery($sqlUpdatePart);
if (!$qryUpdate) {
fxcreer_log("Erreur durant assignation manuelle du numero d'équipe (" . $intEpreuveCommandee . ")");
} elseif ($qryUpdatePart) {
fxFicheAuditRecordChange(
$intParTeam,
'no_bib',
$strOldBibTeam,
$strNewBibTeam,
'bib_equipe',
intval($intEveId)
);
}
} else {
$strNewBibTeam = (string)$strBib;
$sqlUpdatePart = "UPDATE resultats_participants SET par_modification_promoteur = 1, no_bib = '" . $strBib . "', par_maj = '" . fxGetDateTime() . "' WHERE par_id = " . $intParTeam;
$qryUpdatePart = $objDatabase->fxQuery($sqlUpdatePart);
if (!$qryUpdatePart) {
fxcreer_log("Erreur durant assignation manuelle du numero de dossard (" . $intPartipcipant . ")");
} else {
fxFicheAuditRecordChange(
$intParTeam,
'no_bib',
$strOldBibTeam,
$strNewBibTeam,
'bib_equipe',
intval($intEveId)
);
}
}
}
if (!$qryUpdate) {
fxcreer_log("Erreur durant assignation manuelle du numero d'équipe (" . $intEpreuveCommandee . ")");
} else {
$arrRetour['state'] = 'success';
}
}
break;
}
return $arrRetour;
}
function fxSetParStatutCourse($intPartipcipant, $strStatutCode, $strLangue = 'fr') {
global $objDatabase;
$arrRetour = array('state' => 'error');
$intParId = intval($intPartipcipant);
$strCode = trim((string)$strStatutCode);
if ($intParId <= 0 || $strCode === '') {
return $arrRetour;
}
$sqlCheck = "SELECT 1 FROM info WHERE info_actif = 1 AND info_clef = 'inscr_statut_course'"
. " AND info_description = 'opt' AND info_option2 = '" . $objDatabase->fxEscape($strCode) . "' LIMIT 1";
if ($objDatabase->fxGetRow($sqlCheck) === null) {
return $arrRetour;
}
// MSIN-4464 — ancienne valeur avant UPDATE.
$rowAvant = $objDatabase->fxGetRow(
'SELECT par_statut_course, eve_id FROM resultats_participants WHERE par_id = ' . $intParId . ' LIMIT 1'
);
$strOldStatut = is_array($rowAvant) ? trim((string)($rowAvant['par_statut_course'] ?? '')) : '';
$intEveId = is_array($rowAvant) ? intval($rowAvant['eve_id'] ?? 0) : 0;
$sqlUpdate = "UPDATE resultats_participants SET par_modification_promoteur = 1,"
. " par_statut_course = '" . $objDatabase->fxEscape($strCode) . "',"
. " par_maj = '" . fxGetDateTime() . "'"
. " WHERE par_id = " . $intParId;
if ($objDatabase->fxQuery($sqlUpdate)) {
if (!function_exists('fxFicheAuditRecordChange')) {
require_once dirname(__FILE__) . '/inc_fx_fiche_audit.php';
}
fxFicheAuditRecordChange($intParId, 'par_statut_course', $strOldStatut, $strCode, 'statut', $intEveId);
$arrRetour['state'] = 'success';
} else {
fxcreer_log('Erreur durant mise a jour statut course (' . $intParId . ')');
}
return $arrRetour;
}
function fxShowTeammates($intEvenement, $intEpreuve, $intEpreuveCommandee) {
$arrRetour = array('state' => 'error');
$tabEquipe = fxGetMembresEquipe($intEvenement, $intEpreuveCommandee, $intEpreuve, 0, 1);
if ($tabEquipe != null) {
$arrRetour['state'] = 'success';
$arrRetour['team'] = fxUnescape($tabEquipe[1]['pec_nom_equipe']);
$strMembers = '';
for ($i = 1; $i <= count($tabEquipe); $i++) {
$strMembers .= '
';
}
$arrRetour['members'] = $strMembers;
}
return $arrRetour;
}
function fxGetQuantitesEvenement($intEpreuve) {
global $objDatabase;
$arrRetour = array();
$intTotalOriginal = $intTotalAvailable = $intTotalBooked = $intTotalCurrent = $intTotalAjustement = 0;
// récupérer toutes les épreuves de l'événement de $intEpreuve
$sqlEpreuves = "SELECT epr_id FROM inscriptions_epreuves WHERE eve_id = (SELECT DISTINCT eve_id FROM inscriptions_epreuves WHERE epr_id = " . intval($intEpreuve) . ") AND epr_actif = 1";
$arrEpreuves = $objDatabase->fxGetResults($sqlEpreuves);
if ($arrEpreuves != null) {
for ($intCtr = 1; $intCtr <= count($arrEpreuves); $intCtr++) {
$tabEpreuve = fxGetEpreuve($arrEpreuves[$intCtr]['epr_id']);
$sqlInscriptions = 'select p.no_bib, p.par_id, p.par_prenom, p.par_nom, e.pec_id_original, e.epr_id, e.eve_id, e.pec_id, e.is_cancelled, p.rol_id, e.no_commande, e.no_panier, e.no_equipe from resultats_epreuves_commandees e, resultats_participants p where p.is_cancelled = 0 AND p.epr_id = ' . intval($tabEpreuve['epr_id']) . ' AND p.epr_id = e.epr_id and p.pec_id = e.pec_id_original group by e.pec_id_original';
$tabInscriptions = $objDatabase->fxGetResults($sqlInscriptions);
// MSIN-4479 — fxGetResults peut renvoyer null (0 ligne) ; count(null) pollue le JSON AJAX si display_errors.
$intNbInscriptions = is_array($tabInscriptions) ? count($tabInscriptions) : 0;
$intTotalOriginal += $tabEpreuve['epr_qte_origine'];
$intTotalAvailable += $tabEpreuve['epr_qte'];
$intTotalBooked += $intNbInscriptions;
$intTotalCurrent += intval($intNbInscriptions) + intval($tabEpreuve['epr_qte']);
$intTotalAjustement += intval($intNbInscriptions) + intval($tabEpreuve['epr_qte']) - intval($tabEpreuve['epr_qte_origine']);
$checkin=fxGetCheckinqte($arrEpreuves[$intCtr]['epr_id']);
$arrRetour[$arrEpreuves[$intCtr]['epr_id']] = array(
'qte_origine' => intval($tabEpreuve['epr_qte_origine']),
'qte_restante' => intval($tabEpreuve['epr_qte']),
'qte_inscrits' => intval($intNbInscriptions),
'qte_courante' => intval($intNbInscriptions) + intval($tabEpreuve['epr_qte']),
'qte_ajustement' => intval($intNbInscriptions) + intval($tabEpreuve['epr_qte']) - intval($tabEpreuve['epr_qte_origine']),
'qte_checkin' => intval($checkin)
);
}
$arrRetour['total'] = array(
'qte_origine_total' => $intTotalOriginal,
'qte_restante_total' => $intTotalAvailable,
'qte_inscrits_total' => $intTotalBooked,
'qte_courante_total' => $intTotalCurrent,
'qte_ajustement_total' => $intTotalAjustement
);
}
return $arrRetour;
}
function fxGetQuantites($intEpreuve) {
global $objDatabase;
$tabEpreuve = fxGetEpreuve($intEpreuve);
$sqlCommandees = "SELECT COUNT(*) FROM inscriptions_panier_epreuves_commandees e, inscriptions_panier_acheteurs a WHERE e.epr_id = " . intval($tabEpreuve['epr_id']) . " AND e.no_panier = a.no_panier AND a.sta_id = 3";
$intQteCommandees = $objDatabase->fxGetVar($sqlCommandees);
$sqlInscriptions = 'select p.no_bib, p.par_id, p.par_prenom, p.par_nom, e.pec_id_original, e.epr_id, e.eve_id, e.pec_id, e.is_cancelled, p.rol_id, e.no_commande, e.no_panier, e.no_equipe from resultats_epreuves_commandees e, resultats_participants p where p.is_cancelled = 0 AND p.epr_id = ' . intval($intEpreuve) . ' AND p.epr_id = e.epr_id and p.pec_id = e.pec_id_original group by e.pec_id_original';
$tabInscriptions = $objDatabase->fxGetResults($sqlInscriptions);
// MSIN-4479 — même garde que fxGetQuantitesEvenement (null = 0 inscription).
$intNbInscriptions = is_array($tabInscriptions) ? count($tabInscriptions) : 0;
$arrRetour = array(
'qte_origine' => intval($tabEpreuve['epr_qte_origine']),
'qte_restante' => intval($tabEpreuve['epr_qte']),
'qte_inscrits' => intval($intNbInscriptions),
'qte_courante' => intval($intNbInscriptions) + intval($tabEpreuve['epr_qte']),
'qte_ajustement' => intval($intNbInscriptions) + intval($tabEpreuve['epr_qte']) - intval($tabEpreuve['epr_qte_origine'])
);
return $arrRetour;
}
function fxUpdateQuantites($intEpreuve, $intQuantite, $strLangue) {
global $objDatabase;
$arrRetour = array('state' => 'error');
if ($intQuantite >= 0) {
$tabEpreuve = fxGetEpreuve($intEpreuve);
$intDifference = $intQuantite - $tabEpreuve['epr_qte'];
$sqlUpdate = "UPDATE inscriptions_epreuves SET epr_qte_ajoutee = epr_qte_ajoutee + " . intval($intDifference) . ", epr_qte = epr_qte + " . intval($intDifference) . " WHERE epr_id = " . intval($intEpreuve);
$qryUpdate = $objDatabase->fxQuery($sqlUpdate);
if ($qryUpdate) {
if($strLangue == 'fr')
$_SESSION['msg'] = 'p154';
else
$_SESSION['msg'] = 'p554';
}
$arrRetour['data'] = fxGetQuantitesEvenement($intEpreuve);
$arrRetour['state'] = 'success';
}
return $arrRetour;
}
/**
* MSIN-4468 — Reçoit une capacité totale claire pour l'utilisateur, tout en
* conservant epr_qte comme stock restant attendu par le moteur historique.
*/
function fxUpdateQuantiteTotale($intEpreuve, $intQuantiteTotale) {
global $objDatabase;
$arrRetour = array('state' => 'error');
$intEpreuve = intval($intEpreuve);
$intQuantiteTotale = intval($intQuantiteTotale);
if ($intEpreuve <= 0 || $intQuantiteTotale < 0) {
return $arrRetour;
}
$tabEpreuve = fxGetEpreuve($intEpreuve);
if ($tabEpreuve == null || intval($tabEpreuve['epr_qte_limitee']) !== 1) {
return $arrRetour;
}
$arrQuantites = fxGetQuantites($intEpreuve);
$intNbInscriptions = intval($arrQuantites['qte_inscrits'] ?? 0);
if ($intQuantiteTotale < $intNbInscriptions) {
$arrRetour['error_code'] = 'total_below_registrations';
$arrRetour['qte_inscrits'] = $intNbInscriptions;
return $arrRetour;
}
$intAncienneQte = intval($tabEpreuve['epr_qte']);
$intNouvelleQte = $intQuantiteTotale - $intNbInscriptions;
$intDifference = $intNouvelleQte - $intAncienneQte;
if ($intDifference !== 0) {
// Refuse d'écraser un stock qui aurait changé depuis sa lecture.
$sqlUpdate = "UPDATE inscriptions_epreuves"
. " SET epr_qte_ajoutee = epr_qte_ajoutee + " . intval($intDifference)
. ", epr_qte = epr_qte + " . intval($intDifference)
. " WHERE epr_id = " . $intEpreuve
. " AND epr_qte_limitee = 1"
. " AND epr_qte = " . $intAncienneQte;
$qryUpdate = $objDatabase->fxQuery($sqlUpdate);
if (!$qryUpdate || intval($objDatabase->fxGetNbAffectedRows()) !== 1) {
return $arrRetour;
}
}
$arrRetour['data'] = fxGetQuantitesEvenement($intEpreuve);
$arrRetour['state'] = 'success';
return $arrRetour;
}
// v2 — encart « choisissez vos séquences » (batch + auto)
function renderBibBatchPickPrompt() {
ob_start();
?>
0) {
return 'ba:' . (int)$mix;
}
$str = trim((string)$mix);
if (preg_match('/^(ba|que):\d+$/', $str)) {
return $str;
}
return '';
}
/** MSIN-4436 — Clé de tri depuis ba_id legacy. */
function fxBibSortKeyFromBaId($int_ba_id) {
$int_ba_id = (int)$int_ba_id;
return $int_ba_id > 0 ? 'ba:' . $int_ba_id : '';
}
/** MSIN-4436 — Tris mémorisés sur l'épreuve (repli sur ba_id). */
function fxBibGetEpreuveDefaultSortKeys(array $tabEpreuve) {
$strSort1 = fxBibNormalizeSortKey($tabEpreuve['ba_bib_sort_1'] ?? '');
$strSort2 = fxBibNormalizeSortKey($tabEpreuve['ba_bib_sort_2'] ?? '');
if ($strSort1 === '') {
$strSort1 = fxBibSortKeyFromBaId((int)($tabEpreuve['ba_id'] ?? 0));
}
if ($strSort1 === '') {
$strSort1 = 'ba:2';
}
return [$strSort1, $strSort2];
}
/** MSIN-4436 — Persiste le tri batch sur l'épreuve (+ ba_id si tri fixe). */
function fxBibSaveEpreuveBatchSort($epr_id, $sort1, $sort2 = '') {
global $objDatabase;
$epr_id = (int)$epr_id;
$strSort1 = fxBibNormalizeSortKey($sort1);
$strSort2 = fxBibNormalizeSortKey($sort2);
if ($epr_id <= 0 || $strSort1 === '') {
return false;
}
if ($strSort1 === $strSort2) {
$strSort2 = '';
}
$intBaId = 0;
if (preg_match('/^ba:(\d+)$/', $strSort1, $m)) {
$intBaId = (int)$m[1];
}
$sql = "
UPDATE inscriptions_epreuves
SET ba_bib_sort_1 = '" . $objDatabase->fxEscape($strSort1) . "',
ba_bib_sort_2 = '" . $objDatabase->fxEscape($strSort2) . "'
" . ($intBaId > 0 ? ", ba_id = $intBaId" : '') . "
WHERE epr_id = $epr_id
LIMIT 1
";
return (bool)$objDatabase->fxQuery($sql);
}
/** MSIN-4436 — Lit sort_1 / sort_2 depuis POST (repli ba_id). */
function fxBibParseBatchSortFromPost() {
$strSort1 = fxBibNormalizeSortKey($_POST['sort_1'] ?? '');
$strSort2 = fxBibNormalizeSortKey($_POST['sort_2'] ?? '');
if ($strSort1 === '') {
$strSort1 = fxBibNormalizeSortKey($_POST['ba_id'] ?? '');
}
if ($strSort1 === '') {
$strSort1 = 'ba:2';
}
if ($strSort1 === $strSort2) {
$strSort2 = '';
}
return [$strSort1, $strSort2];
}
/** MSIN-4436 — Questions éligibles au tri pour une épreuve. */
function fxBibGetQuestionSortOptions($epr_id, $eve_id, $strLangue = 'fr') {
global $objDatabase;
$epr_id = (int)$epr_id;
$eve_id = (int)$eve_id;
if ($epr_id <= 0 || $eve_id <= 0) {
return [];
}
$strCol = ($strLangue === 'en') ? 'que_question_en' : 'que_question_fr';
$sql = "
SELECT que_id, $strCol AS que_label, que_validation
FROM inscriptions_questions
WHERE que_actif = 1
AND eve_id = $eve_id
AND (FIND_IN_SET($epr_id, que_epreuves_incluses) OR que_epreuves_incluses = '' OR que_epreuves_incluses IS NULL)
AND que_validation NOT IN ('image', 'pdf')
ORDER BY que_tri, que_id
";
$rows = $objDatabase->fxGetResults($sql);
if (!is_array($rows)) {
return [];
}
$out = [];
foreach ($rows as $row) {
$intQueId = (int)($row['que_id'] ?? 0);
if ($intQueId <= 0) {
continue;
}
$strLabel = trim((string)($row['que_label'] ?? ''));
if ($strLabel === '') {
$strLabel = 'Question #' . $intQueId;
}
if (mb_strlen($strLabel) > 72) {
$strLabel = mb_substr($strLabel, 0, 69) . '…';
}
$out[] = [
'key' => 'que:' . $intQueId,
'label' => $strLabel,
'group' => 'question',
];
}
return $out;
}
/** MSIN-4436 — Options de tri (fixes + questions) pour une épreuve. */
function fxBibGetSortOptionsForEpreuve($epr_id, $eve_id, $strLangue = 'fr', $blnTeamEpreuve = false, $blnIncludeQuestions = true) {
global $objDatabase;
$out = [];
$rows = $objDatabase->fxGetResults(
"SELECT * FROM bib_assignements WHERE ba_actif = 1 ORDER BY ba_tri"
);
if (is_array($rows)) {
foreach ($rows as $row) {
if ((int)($row['ba_equipe'] ?? 0) === 1 && !$blnTeamEpreuve) {
continue;
}
$intBaId = (int)($row['ba_id'] ?? 0);
if ($intBaId <= 0) {
continue;
}
$strLabel = trim((string)($row['ba_nom_' . $strLangue] ?? ''));
if ($strLabel === '') {
$strLabel = trim((string)($row['ba_nom_fr'] ?? ''));
}
$out[] = [
'key' => 'ba:' . $intBaId,
'label' => $strLabel !== '' ? $strLabel : ('ba:' . $intBaId),
'group' => 'fixed',
];
}
}
if ($blnIncludeQuestions && (int)$epr_id > 0 && (int)$eve_id > 0) {
$out = array_merge($out, fxBibGetQuestionSortOptions($epr_id, $eve_id, $strLangue));
}
return $out;
}
/** MSIN-4436 — Vérifie qu'une question est liée à l'épreuve. */
function fxBibQuestionSortAllowedForEpreuve($epr_id, $que_id, $eve_id) {
global $objDatabase;
$epr_id = (int)$epr_id;
$que_id = (int)$que_id;
$eve_id = (int)$eve_id;
if ($epr_id <= 0 || $que_id <= 0 || $eve_id <= 0) {
return false;
}
$sql = "
SELECT COUNT(*)
FROM inscriptions_questions
WHERE que_id = $que_id
AND eve_id = $eve_id
AND que_actif = 1
AND que_validation NOT IN ('image', 'pdf')
AND (FIND_IN_SET($epr_id, que_epreuves_incluses) OR que_epreuves_incluses = '' OR que_epreuves_incluses IS NULL)
";
return (int)$objDatabase->fxGetVar($sql) > 0;
}
/**
* MSIN-4456 — Clause ORDER BY fiable pour « Nom d'équipe ».
* Regroupe d'abord par nom (pec / repli par_nom_equipe), puis pec_id (même nom ≠ même équipe).
*/
function fxBibTeamNameOrderClause() {
return "TRIM(IFNULL(NULLIF(c.pec_nom_equipe, ''), IFNULL(p.par_nom_equipe, ''))), p.pec_id";
}
/** MSIN-4456 — La clé de tri est-elle un critère ba_equipe (ex. Nom d'équipe) ? */
function fxBibSortKeyIsTeamCriterion($sortKey) {
global $objDatabase;
$sortKey = fxBibNormalizeSortKey($sortKey);
if (!preg_match('/^ba:(\d+)$/', $sortKey, $m)) {
return false;
}
return (int)$objDatabase->fxGetVar(
"SELECT ba_equipe FROM bib_assignements WHERE ba_id = " . (int)$m[1] . " AND ba_actif = 1 LIMIT 1"
) === 1;
}
/**
* MSIN-4456 — Re-tri PHP des participants (filet si l'ORDER BY SQL ne regroupe pas).
* Appliqué seulement quand le tri principal est un critère équipe.
*/
function fxBibSortParticipantsByTeamName(array $participants) {
if (empty($participants)) {
return $participants;
}
$rows = [];
foreach ($participants as $row) {
$rows[] = $row;
}
usort($rows, function ($a, $b) {
$strTeamA = trim((string)($a['pec_nom_equipe'] ?? ''));
if ($strTeamA === '') {
$strTeamA = trim((string)($a['par_nom_equipe'] ?? ''));
}
$strTeamB = trim((string)($b['pec_nom_equipe'] ?? ''));
if ($strTeamB === '') {
$strTeamB = trim((string)($b['par_nom_equipe'] ?? ''));
}
$intCmp = strcasecmp($strTeamA, $strTeamB);
if ($intCmp !== 0) {
return $intCmp;
}
$intPecA = (int)($a['pec_id_original'] ?? $a['pec_id'] ?? 0);
$intPecB = (int)($b['pec_id_original'] ?? $b['pec_id'] ?? 0);
if ($intPecA !== $intPecB) {
return $intPecA <=> $intPecB;
}
$intCmp = strcasecmp((string)($a['par_nom'] ?? ''), (string)($b['par_nom'] ?? ''));
if ($intCmp !== 0) {
return $intCmp;
}
$intCmp = strcasecmp((string)($a['par_prenom'] ?? ''), (string)($b['par_prenom'] ?? ''));
if ($intCmp !== 0) {
return $intCmp;
}
return ((int)($a['par_id'] ?? 0)) <=> ((int)($b['par_id'] ?? 0));
});
$out = [];
$intCtr = 1;
foreach ($rows as $row) {
$out[$intCtr++] = $row;
}
return $out;
}
/** MSIN-4436 — Fragment ORDER BY pour une clé de tri. */
function fxBibResolveSortClause($epr_id, $sortKey, $strLangue = 'fr', $eve_id = 0) {
global $objDatabase;
$sortKey = fxBibNormalizeSortKey($sortKey);
if ($sortKey === '') {
return '';
}
if (preg_match('/^ba:(\d+)$/', $sortKey, $m)) {
$intBaId = (int)$m[1];
$tabBa = $objDatabase->fxGetRow(
"SELECT ba_sql_order, ba_equipe FROM bib_assignements WHERE ba_id = $intBaId AND ba_actif = 1 LIMIT 1"
);
if (!$tabBa) {
return '';
}
// MSIN-4456 — Ne pas se fier seul à ba_sql_order historique (souvent déjà + nom/prénom).
if ((int)($tabBa['ba_equipe'] ?? 0) === 1) {
return fxBibTeamNameOrderClause();
}
$orderBy = trim((string)($tabBa['ba_sql_order'] ?? ''));
return $orderBy !== '' ? $orderBy : '';
}
if (preg_match('/^que:(\d+)$/', $sortKey, $m)) {
$que_id = (int)$m[1];
$epr_id = (int)$epr_id;
if ($epr_id <= 0) {
return '';
}
if ($eve_id <= 0) {
$eve_id = (int)$objDatabase->fxGetVar(
"SELECT eve_id FROM inscriptions_epreuves WHERE epr_id = $epr_id LIMIT 1"
);
}
if (!fxBibQuestionSortAllowedForEpreuve($epr_id, $que_id, $eve_id)) {
return '';
}
$strCol = ($strLangue === 'en') ? 'que_choix_en' : 'que_choix_fr';
return "(
SELECT TRIM(rq.$strCol)
FROM resultats_questions rq
WHERE rq.que_actif = 1
AND rq.que_id = $que_id
AND rq.par_id = p.par_id
AND rq.pec_id = p.pec_id
LIMIT 1
)";
}
return '';
}
/** MSIN-4436 — ORDER BY complet (2 niveaux + tie-breaker). */
function fxBibBuildBatchOrderBy($epr_id, $sort1, $sort2 = '', $strLangue = 'fr', $eve_id = 0) {
$epr_id = (int)$epr_id;
if ($eve_id <= 0 && $epr_id > 0) {
global $objDatabase;
$eve_id = (int)$objDatabase->fxGetVar(
"SELECT eve_id FROM inscriptions_epreuves WHERE epr_id = $epr_id LIMIT 1"
);
}
$strSort1 = fxBibNormalizeSortKey($sort1);
$strSort2 = fxBibNormalizeSortKey($sort2);
if ($strSort1 === $strSort2) {
$strSort2 = '';
}
$tabParts = [];
foreach ([$strSort1, $strSort2] as $mixKey) {
if ($mixKey === '') {
continue;
}
$strClause = fxBibResolveSortClause($epr_id, $mixKey, $strLangue, $eve_id);
// MSIN-4456 — Tri principal « nom d'équipe » + secondaire alphabétique :
// la clause équipe ne doit PAS déjà embarquer par_nom (sinon le 2e niveau est noyé).
if ($mixKey === $strSort1 && fxBibSortKeyIsTeamCriterion($mixKey) && $strSort2 !== '') {
$strClause = fxBibTeamNameOrderClause();
}
if ($strClause !== '' && !in_array($strClause, $tabParts, true)) {
$tabParts[] = $strClause;
}
}
if (empty($tabParts)) {
$tabParts[] = 'p.par_nom, p.par_prenom';
}
$tabParts[] = 'p.par_id ASC';
return implode(', ', $tabParts);
}
/** MSIN-4436 — Rendu des
pour un select de tri. */
function fxBibRenderBatchSortOptions($tabOptions, $strSelected, $blnAllowEmpty = false, $strLangue = 'fr') {
$strSelected = fxBibNormalizeSortKey($strSelected);
$html = '';
if ($blnAllowEmpty) {
$strNone = fxBibTexte('bib_v4_batch_order_none', 0);
$html .= ' '
. fxBibEsc($strNone) . ' ';
}
$tabFixed = [];
$tabQuestions = [];
foreach ($tabOptions as $opt) {
if (($opt['group'] ?? '') === 'question') {
$tabQuestions[] = $opt;
} else {
$tabFixed[] = $opt;
}
}
if (!empty($tabFixed)) {
$html .= '
';
foreach ($tabFixed as $opt) {
$strKey = fxBibEsc($opt['key'] ?? '');
$html .= ''
. fxBibEsc($opt['label'] ?? '') . ' ';
}
$html .= ' ';
}
if (!empty($tabQuestions)) {
$html .= '
';
foreach ($tabQuestions as $opt) {
$strKey = fxBibEsc($opt['key'] ?? '');
$html .= ''
. fxBibEsc($opt['label'] ?? '') . ' ';
}
$html .= ' ';
}
return $html;
}
// v2 — options d'ordre batch (table bib_assignements)
function renderBatchConfig($epr_id, $eve_id, $strLangue = 'fr', $isTeamEpreuve = false, $strSort1 = '', $strSort2 = '') {
$epr_id = (int)$epr_id;
$eve_id = (int)$eve_id;
$strSort1 = fxBibNormalizeSortKey($strSort1);
$strSort2 = fxBibNormalizeSortKey($strSort2);
if ($strSort1 === '') {
$strSort1 = 'ba:2';
}
$tabOptions = fxBibGetSortOptionsForEpreuve($epr_id, $eve_id, $strLangue, $isTeamEpreuve, true);
ob_start();
?>
'inc_tableau_gestion_epreuves',
'epreuves' => 'inc_tableau_epreuves',
'dossards' => 'inc_tableau_dossards',
'promoteur' => 'inc_tableau_promoteur',
);
$strFrom = (isset($_GET['from']) && trim($_GET['from']) !== '') ? trim($_GET['from']) : $strDefault;
if (!isset($arrAllowed[$strFrom])) {
$strFrom = $strDefault;
}
if ($strFrom === 'promoteur') {
if (!function_exists('fxPromoteurHubOrLegacyBackUrl')) {
require_once __DIR__ . '/inc_fx_promoteur_hub.php';
}
$strLangue = ($strPage === '/account') ? 'en' : 'fr';
return fxPromoteurHubOrLegacyBackUrl($intEveId, $strLangue);
}
$strEveParam = 'promoteur_eve_id=' . urlencode(base64_encode($intEveId));
return $vDomaine . $strPage . '/' . $arrAllowed[$strFrom] . '?' . $strEveParam;
}
/** Chemin relatif (sans domaine) pour strhomeclientannuler et liens internes. */
function fxGetPromoteurBackPath($strPage = '/compte', $strDefault = 'promoteur') {
$arrAllowed = array(
'gestion' => 'inc_tableau_gestion_epreuves',
'epreuves' => 'inc_tableau_epreuves',
'dossards' => 'inc_tableau_dossards',
'promoteur' => 'inc_tableau_promoteur',
);
$strFrom = (isset($_GET['from']) && trim($_GET['from']) !== '') ? trim($_GET['from']) : $strDefault;
if (!isset($arrAllowed[$strFrom])) {
$strFrom = $strDefault;
}
return $strPage . '/' . $arrAllowed[$strFrom];
}
/** Jeton CSRF du module dossards v4 (session). */
function fxBibCsrfToken($mem_regenerate = false) {
if (empty($_SESSION['bib_csrf_token']) || $mem_regenerate) {
$_SESSION['bib_csrf_token'] = bin2hex(random_bytes(32));
}
return $_SESSION['bib_csrf_token'];
}
/** Valide le jeton CSRF reçu en POST (ajax_bib_range save_auto_config, etc.). */
function fxBibValidateCsrf($str_token) {
if ($str_token === '' || empty($_SESSION['bib_csrf_token'])) {
return false;
}
return hash_equals($_SESSION['bib_csrf_token'], $str_token);
}
/** Session promoteur ou admin requise pour les actions AJAX sensibles du module bib. */
function fxBibRequirePromoteurSession() {
return !empty($_SESSION['com_id']) || !empty($_SESSION['usa_id']);
}
/** MSIN-4436 — Au moins une séquence verrouillée sur l'épreuve. */
function fxBibEpreuveHasLockedRanges($epr_id) {
global $objDatabase;
$epr_id = (int)$epr_id;
if ($epr_id <= 0) {
return false;
}
$sql = "
SELECT COUNT(*)
FROM inscriptions_epreuves_bib
WHERE epr_id = $epr_id
AND epr_bib_locked = 1
";
return (int)$objDatabase->fxGetVar($sql) > 0;
}
/** MSIN-4436 — Réinitialisation totale : aucun cadenas sur l'épreuve. */
function fxBibAssertEpreuveNoLockedRanges($epr_id) {
if (fxBibEpreuveHasLockedRanges($epr_id)) {
return ['success' => false, 'message' => fxBibMsg('bib_v4_js_reset_all_locked')];
}
return ['success' => true];
}
/** MSIN-4424 — Mêmes numéros de dossard autorisés entre épreuves (réglage événement). */
function fxBibEventAllowsInterEprDuplicates($int_eve_id) {
global $objDatabase;
static $memCache = [];
$int_eve_id = (int)$int_eve_id;
if ($int_eve_id <= 0) {
return false;
}
if (array_key_exists($int_eve_id, $memCache)) {
return $memCache[$int_eve_id];
}
$intVal = (int)$objDatabase->fxGetVar(
'SELECT eve_bib_allow_inter_epr FROM inscriptions_evenements WHERE eve_id = ' . $int_eve_id . ' LIMIT 1'
);
$memCache[$int_eve_id] = ($intVal === 1);
return $memCache[$int_eve_id];
}
/** MSIN-4424 — Persiste le réglage doublons inter-épreuves. */
function fxBibSetEventAllowsInterEprDuplicates($int_eve_id, $blnAllow) {
global $objDatabase;
$int_eve_id = (int)$int_eve_id;
$intAllow = $blnAllow ? 1 : 0;
if ($int_eve_id <= 0) {
return ['success' => false, 'message' => fxBibMsg('bib_v4_ajax_epr_invalid')];
}
$objDatabase->fxQuery(
'UPDATE inscriptions_evenements SET eve_bib_allow_inter_epr = ' . $intAllow
. ' WHERE eve_id = ' . $int_eve_id . ' LIMIT 1'
);
return ['success' => true, 'allow_inter_epr' => ($intAllow === 1)];
}
/** Resout eve_id depuis la requete AJAX bib (eve_id, epr_id ou epr_bib_id / id). */
function fxBibResolveEveIdFromRequest() {
global $objDatabase;
if (!empty($_REQUEST['eve_id'])) {
return intval($_REQUEST['eve_id']);
}
$intEprId = intval($_REQUEST['epr_id'] ?? 0);
if ($intEprId > 0) {
$intEveId = intval($objDatabase->fxGetVar(
'SELECT eve_id FROM inscriptions_epreuves WHERE epr_id = ' . $intEprId . ' LIMIT 1'
));
return ($intEveId > 0) ? $intEveId : 0;
}
// delete n'envoyait que id (epr_bib_id) — seule action sans epr_id ni eve_id
$intBibId = intval($_REQUEST['epr_bib_id'] ?? $_REQUEST['id'] ?? 0);
if ($intBibId <= 0) {
return 0;
}
$intEveId = intval($objDatabase->fxGetVar(
'SELECT e.eve_id FROM inscriptions_epreuves_bib b '
. 'INNER JOIN inscriptions_epreuves e ON e.epr_id = b.epr_id '
. 'WHERE b.epr_bib_id = ' . $intBibId . ' LIMIT 1'
));
return ($intEveId > 0) ? $intEveId : 0;
}
/** Gate AJAX bib v4 — session promoteur + CSRF (pas de granularite v2 pour l'instant). */
function fxBibRequireAjaxAccess() {
if (!fxBibRequirePromoteurSession()) {
echo json_encode([
'success' => false,
'message' => fxBibMsg('bib_v4_ajax_session_invalid'),
]);
exit;
}
$strToken = $_POST['csrf_token'] ?? $_REQUEST['csrf_token'] ?? '';
if (!fxBibValidateCsrf($strToken)) {
echo json_encode([
'success' => false,
'message' => fxBibMsg('bib_v4_ajax_unauthorized'),
]);
exit;
}
}
/** Échappement HTML pour attributs Tippy / boutons bib v4. */
function fxBibEsc($str) {
return htmlspecialchars($str, ENT_QUOTES, 'UTF-8');
}
/** Page info pour le module bib v4 — toujours compte.php, jamais le script AJAX. */
function fxBibInfoPage() {
return 'compte.php';
}
/**
* Lit info_texte / info_aide depuis $vtexte_page ou la BD (compte.php / global uniquement).
* N'écrit jamais dans info — évite les doublons info_prg=ajax_bib_range.php en AJAX.
*/
function fxBibGetInfoRow($clef) {
global $vtexte_page, $objDatabase, $strLangue;
if (!empty($vtexte_page[$clef])) {
return $vtexte_page[$clef];
}
static $bibInfoCache = array();
if (array_key_exists($clef, $bibInfoCache)) {
return $bibInfoCache[$clef];
}
if (!isset($objDatabase)) {
$bibInfoCache[$clef] = array();
return $bibInfoCache[$clef];
}
$strLang = !empty($strLangue) ? $strLangue : 'fr';
$strPage = fxBibInfoPage();
$sql = "SELECT info_texte, info_aide FROM info
WHERE info_actif = 1
AND info_clef = '" . $objDatabase->fxEscape($clef) . "'
AND info_langue = '" . $objDatabase->fxEscape($strLang) . "'
AND info_prg IN ('" . $strPage . "', 'global')
ORDER BY FIELD(info_prg, '" . $strPage . "', 'global')
LIMIT 1";
$row = $objDatabase->fxGetRow($sql);
if (!is_array($row) || empty($row)) {
// Entrées legacy créées par erreur sous ajax_bib_range.php — lecture seule.
$sqlLegacy = "SELECT info_texte, info_aide FROM info
WHERE info_actif = 1
AND info_clef = '" . $objDatabase->fxEscape($clef) . "'
AND info_langue = '" . $objDatabase->fxEscape($strLang) . "'
AND info_prg = 'ajax_bib_range.php'
LIMIT 1";
$row = $objDatabase->fxGetRow($sqlLegacy);
}
$bibInfoCache[$clef] = is_array($row) ? $row : array();
return $bibInfoCache[$clef];
}
/** Libellé bib v4 — sur compte.php auto-crée si absent ; en AJAX, lecture seule.
* $blnAllowEmptyLabel : si true, info_texte vide en BD reste vide (en-têtes colonnes éditables). */
function fxBibTexte($clef, $mem_echo = 0, $blnAllowEmptyLabel = false) {
$row = fxBibGetInfoRow($clef);
$blnHasDbRow = !empty($row) && array_key_exists('info_texte', $row);
$str = trim($row['info_texte'] ?? '');
if ($blnAllowEmptyLabel && $blnHasDbRow && $str === '') {
if ($mem_echo) {
echo '';
}
return '';
}
if ($str === '' || $str === $clef || $str === '*' . $clef . '*') {
if (!defined('MS1_BIB_AJAX') || !MS1_BIB_AJAX) {
if (!$blnHasDbRow && !$blnAllowEmptyLabel) {
$str = trim(afficheTexte($clef, 0));
}
}
if ($str === '' || $str === $clef || $str === '*' . $clef . '*') {
$str = fxBibStaticFallback($clef);
if ($str === '') {
$str = $blnAllowEmptyLabel ? '' : $clef;
}
}
}
if ($mem_echo) {
echo fxBibEsc($str);
}
return $str;
}
/** Repli FR/EN si clé bib_v4 absente ou mal saisie en BD. */
function fxBibStaticFallback($clef) {
global $strLangue;
$lng = ($strLangue === 'en') ? 'en' : 'fr';
$tab = [
'bib_v4_view_cancelled' => ['fr' => 'Annulé', 'en' => 'Cancelled'],
'bib_v4_err_gaps' => ['fr' => 'Dossards non assignés :', 'en' => 'Unassigned bibs:'],
'bib_v4_err_dupes' => ['fr' => 'Dossards en double :', 'en' => 'Duplicate bibs:'],
'bib_v4_anomalies_auto_miss_title' => ['fr' => 'Inscriptions sans dossard (auto)', 'en' => 'Registrations without a bib (auto)'],
'bib_v4_anomalies_out_of_range_title' => ['fr' => 'Dossards hors séquence', 'en' => 'Bibs outside sequences'],
'bib_v4_anomalies_no_range' => ['fr' => 'Aucune séquence configurée', 'en' => 'No sequence configured'],
'bib_v4_anomalies_order_fmt' => ['fr' => 'Commande %s', 'en' => 'Order %s'],
'bib_v4_anomalies_assign_link' => ['fr' => 'Assigner un dossard', 'en' => 'Assign a bib'],
'bib_v4_anomalies_orphan_annule' => ['fr' => 'Annulée — dossard encore en séquence', 'en' => 'Cancelled — bib still in sequence'],
'bib_v4_anomalies_orphan_transfert'=> ['fr' => 'Transférée — dossard conservé', 'en' => 'Transferred — bib kept'],
'bib_v4_anomalies_view_inscription'=> ['fr' => "Voir l'inscription", 'en' => 'View registration'],
'bib_v4_js_loader_wait' => ['fr' => 'Chargement...', 'en' => 'Loading...'],
'bib_v4_js_global_no_epr' => ['fr' => 'Sélectionnez au moins une épreuve solo.', 'en' => 'Select at least one solo race.'],
'bib_v4_js_global_no_seq' => ['fr' => 'Cochez au moins une séquence pour les épreuves sélectionnées.', 'en' => 'Check at least one sequence for the selected races.'],
'bib_v4_global_batch_plan_invalid' => ['fr' => 'Sélection invalide : choisissez au moins une épreuve solo et des séquences.', 'en' => 'Invalid selection: pick at least one solo race and sequences.'],
'bib_v4_global_batch_need_two' => ['fr' => "L'assignation globale nécessite au moins deux épreuves solo avec des séquences disponibles.", 'en' => 'Global assignment requires at least two solo races with available sequences.'],
'bib_v4_global_batch_existing_title' => ['fr' => 'Assignation des dossards avec séquences existantes', 'en' => 'Bib assignment with existing sequences'],
'bib_v4_global_batch_generated_title' => ['fr' => 'Assignation de dossards sans séquence existante', 'en' => 'Bib assignment without existing sequences'],
'bib_v4_global_batch_start_bib' => ['fr' => 'Dossard numéro 1', 'en' => 'First bib number'],
'bib_v4_global_batch_gen_hint' => ['fr' => 'Épreuves solo sans séquence : une plage est créée pour chaque épreuve sélectionnée, à la taille exacte des inscriptions à assigner. Les numéros se suivent dans l\'ordre des épreuves.', 'en' => 'Solo races without sequences: one range is created per selected race, sized exactly to registrations to assign. Bib numbers continue in race order.'],
'bib_v4_global_batch_gen_range_preview' => ['fr' => 'Plage prévue : %d → %d · %d à assigner', 'en' => 'Planned range: %d → %d · %d to assign'],
'bib_v4_global_batch_gen_plan_invalid' => ['fr' => 'Sélection invalide : dossard de départ et au moins une épreuve avec inscriptions à assigner.', 'en' => 'Invalid selection: starting bib and at least one race with registrations to assign.'],
'bib_v4_global_batch_gen_no_pending' => ['fr' => 'Aucune inscription à assigner dans les épreuves sélectionnées.', 'en' => 'No registrations to assign in the selected races.'],
'bib_v4_global_batch_gen_has_seq' => ['fr' => 'Une épreuve sélectionnée a déjà une séquence — rechargez le panneau.', 'en' => 'A selected race already has a sequence — reload the panel.'],
'bib_v4_global_batch_gen_no_start' => ['fr' => 'Indiquez le numéro du premier dossard.', 'en' => 'Enter the first bib number.'],
'bib_v4_global_batch_gen_insert_failed' => ['fr' => 'Impossible de créer la séquence de dossards. Réessayez ou rechargez la page.', 'en' => 'Could not create the bib sequence. Try again or reload the page.'],
'bib_v4_js_global_gen_epr_missing' => ['fr' => 'Épreuve introuvable sur la page après création des séquences. Rechargez la page puis réessayez.', 'en' => 'Race not found on the page after creating sequences. Reload the page and try again.'],
'bib_v4_ajax_error' => ['fr' => 'Erreur', 'en' => 'Error'],
'bib_v4_global_batch_unavailable' => ['fr' => 'Aucune assignation globale disponible pour cet événement.', 'en' => 'No global assignment available for this event.'],
'bib_v4_ajax_global_gen_sim_summary' => ['fr' => '%d épreuve(s) · %d dossards · %d à assigner', 'en' => '%d race(s) · %d bibs · %d to assign'],
'bib_v4_ajax_global_gen_analysis' => ['fr' => '%d épreuve(s) · plage %d → %d · %d à assigner', 'en' => '%d race(s) · range %d → %d · %d to assign'],
'bib_v4_js_global_batch_finalizing' => ['fr' => 'Finalisation — mise à jour de l\'affichage…', 'en' => 'Finishing — refreshing the display…'],
'bib_v4_global_batch_go_complete_title' => ['fr' => 'Assignation terminée', 'en' => 'Assignment complete'],
'bib_v4_global_batch_go_complete_summary' => ['fr' => '%d dossard(s) assigné(s) sur %d · %d épreuve(s)', 'en' => '%d bib(s) assigned of %d · %d race(s)'],
'bib_v4_global_batch_go_complete_reload' => ['fr' => 'OK — Recharger la page', 'en' => 'OK — Reload page'],
// MSIN-4445 — Assignation libre.
'bib_v4_global_batch_free_title' => ['fr' => 'Assignation libre', 'en' => 'Free assignment'],
'bib_v4_global_batch_free_hint' => ['fr' => 'Toutes les épreuves solo : choisissez Début et Fin (ou Qté). Les dossards sont assignés sans créer de séquence, même si une séquence existe déjà. Le Go reste disponible même si la quantité n\'est pas juste.', 'en' => 'All solo races: choose Start and End (or Qty). Bibs are assigned without creating a sequence, even if a sequence already exists. Go stays available even if the quantity is not exact.'],
'bib_v4_global_batch_free_qty_juste' => ['fr' => 'Quantité juste', 'en' => 'Exact quantity'],
'bib_v4_global_batch_free_qty_manquante' => ['fr' => 'Quantité manquante : %d', 'en' => 'Missing quantity: %d'],
'bib_v4_global_batch_free_qty_supplementaire' => ['fr' => 'Quantité supplémentaire : %d', 'en' => 'Extra quantity: %d'],
'bib_v4_global_batch_free_dupes_warn' => ['fr' => 'Attention : vous êtes en train de créer des inscriptions avec des dossards en double.', 'en' => 'Warning: you are about to create registrations with duplicate bib numbers.'],
'bib_v4_global_batch_free_plan_invalid' => ['fr' => 'Sélection invalide : Début, Fin (ou Qté) et au moins une épreuve avec inscriptions à assigner.', 'en' => 'Invalid selection: Start, End (or Qty) and at least one race with registrations to assign.'],
'bib_v4_ajax_global_free_analysis' => ['fr' => '%d épreuve(s) · plage %d → %d · %d à assigner · %s', 'en' => '%d race(s) · range %d → %d · %d to assign · %s'],
'bib_v4_ajax_global_free_sim_summary' => ['fr' => '%d épreuve(s) · %d dossards · %d à assigner · %s', 'en' => '%d race(s) · %d bibs · %d to assign · %s'],
'bib_v4_batch_order_2' => ['fr' => 'Tri secondaire', 'en' => 'Secondary sort'],
'bib_v4_batch_order_none' => ['fr' => '— Aucun —', 'en' => '— None —'],
'bib_v4_batch_sort_group_fixed' => ['fr' => 'Critères fixes', 'en' => 'Fixed criteria'],
'bib_v4_summary_teams_unit' => ['fr' => 'équipes', 'en' => 'teams'],
// MSIN-4467 — Nouvelle architecture visuelle du module.
'bib_v5_workspace_label' => ['fr' => 'Gestion des dossards', 'en' => 'Bib management'],
'bib_v5_workspace_preparation' => ['fr' => 'Préparation', 'en' => 'Preparation'],
'bib_v5_workspace_production' => ['fr' => 'Production de dossards', 'en' => 'Bib production'],
'bib_v5_workspace_operations' => ['fr' => 'Opérations', 'en' => 'Operations'],
'bib_v5_workspace_settings' => ['fr' => 'Réglages', 'en' => 'Settings'],
'bib_v5_preparation_intro' => ['fr' => 'Préparez les épreuves et attribuez les dossards aux inscriptions.', 'en' => 'Prepare races and assign bibs to registrations.'],
'bib_v5_group_quantities' => ['fr' => 'Quantités', 'en' => 'Quantities'],
'bib_v5_group_bibs' => ['fr' => 'Dossards', 'en' => 'Bibs'],
'bib_v5_modes_intro' => ['fr' => 'Utilisez les modes d’assignation qui traitent plusieurs épreuves ou des besoins particuliers.', 'en' => 'Use assignment modes that process multiple races or special requirements.'],
'bib_v5_stat_races' => ['fr' => 'Épreuves actives', 'en' => 'Active races'],
'bib_v5_stat_registered' => ['fr' => 'Inscriptions', 'en' => 'Registrations'],
'bib_v5_stat_assigned' => ['fr' => 'Dossards attribués', 'en' => 'Assigned bibs'],
'bib_v5_stat_pending' => ['fr' => 'À attribuer', 'en' => 'To assign'],
'bib_v5_race_ready' => ['fr' => 'Prête', 'en' => 'Ready'],
'bib_v5_race_incomplete' => ['fr' => 'À compléter', 'en' => 'To complete'],
'bib_v5_quantities_title' => ['fr' => 'Quantités d’inscription', 'en' => 'Registration quantities'],
'bib_v5_bib_assignment_title' => ['fr' => 'Attribution des dossards', 'en' => 'Bib assignment'],
'bib_v5_ranges_title' => ['fr' => 'Plages de numéros', 'en' => 'Number ranges'],
'bib_v5_ranges_hint' => ['fr' => 'Définissez les numéros disponibles pour cette épreuve.', 'en' => 'Define the numbers available for this race.'],
'bib_v5_method_title' => ['fr' => 'Méthode d’attribution', 'en' => 'Assignment method'],
// MSIN-4468 — Filet de secours; la source officielle demeure la table info.
'bib_v5_qte_total_min' => [
'fr' => 'Quantité refusée : le total doit être d’au moins %d, soit le nombre d’inscriptions déjà vendues.',
'en' => 'Quantity rejected: the total must be at least %d, which is the number of registrations already sold.',
],
'bib_v5_batch_title' => ['fr' => 'Attribuer maintenant', 'en' => 'Assign now'],
'bib_v5_batch_hint' => ['fr' => 'Attribuer en lot aux inscriptions qui n’ont pas encore de dossard.', 'en' => 'Assign in bulk to registrations that do not have a bib yet.'],
'bib_v5_auto_title' => ['fr' => 'Nouvelles inscriptions', 'en' => 'New registrations'],
'bib_v5_auto_hint' => ['fr' => 'Attribuer automatiquement un dossard lors des prochaines inscriptions.', 'en' => 'Automatically assign a bib to future registrations.'],
'bib_v5_advanced_actions' => ['fr' => 'Actions avancées', 'en' => 'Advanced actions'],
'bib_v5_production_intro' => ['fr' => 'Préparez les informations nécessaires à l’impression des dossards à partir des plages déjà configurées.', 'en' => 'Prepare the information required to print bibs using the ranges already configured.'],
'bib_v5_production_planned' => ['fr' => 'Fonctionnalité prévue — aucune donnée ne sera enregistrée pour le moment.', 'en' => 'Planned feature — no data will be saved yet.'],
'bib_v5_production_step_ranges' => ['fr' => 'Choisir les plages', 'en' => 'Choose ranges'],
'bib_v5_production_step_answers' => ['fr' => 'Répondre par catégorie', 'en' => 'Answer by category'],
'bib_v5_production_step_review' => ['fr' => 'Réviser la production', 'en' => 'Review production'],
'bib_v5_production_step_printer' => ['fr' => 'Transmettre à l’imprimeur', 'en' => 'Send to printer'],
'bib_v5_production_categories' => ['fr' => 'Préparation par épreuve et catégorie', 'en' => 'Preparation by race and category'],
'bib_v5_production_ranges' => ['fr' => 'Plages existantes', 'en' => 'Existing ranges'],
'bib_v5_production_color' => ['fr' => 'Couleur du dossard', 'en' => 'Bib colour'],
'bib_v5_production_questions' => ['fr' => 'Questions de production', 'en' => 'Production questions'],
'bib_v5_production_to_define' => ['fr' => 'À définir', 'en' => 'To be defined'],
'bib_v5_production_status' => ['fr' => 'À préparer', 'en' => 'To prepare'],
// MSIN-4469 — Filet de secours; la source officielle demeure la table info.
'bib_v5_production_excel_title' => ['fr' => 'Fichier Excel pour l’imprimeur', 'en' => 'Printer Excel file'],
'bib_v5_production_excel_intro' => ['fr' => 'Le fichier contient un onglet Imprimeur et un onglet Commande MS1.', 'en' => 'The file contains a Printer sheet and an MS1 Order sheet.'],
'bib_v5_production_excel_generate' => ['fr' => 'Générer et verrouiller', 'en' => 'Generate and lock'],
'bib_v5_production_excel_generate_help' => ['fr' => 'Cette action crée le fichier officiel et verrouille les séquences pour l’impression.', 'en' => 'This creates the official file and locks the ranges for printing.'],
'bib_v5_production_excel_download' => ['fr' => 'Télécharger de nouveau', 'en' => 'Download again'],
'bib_v5_production_excel_locked' => ['fr' => 'En impression — séquences verrouillées', 'en' => 'In print — ranges locked'],
'bib_v5_production_excel_meta' => ['fr' => 'Version %d créée le %s par %s', 'en' => 'Version %d created on %s by %s'],
'bib_v5_production_excel_generating' => ['fr' => 'Génération en cours — rechargez la page dans quelques instants.', 'en' => 'Generation in progress — reload the page shortly.'],
'bib_v5_production_no_ranges' => ['fr' => 'Aucune séquence de dossards à produire.', 'en' => 'No bib ranges to produce.'],
'bib_v5_production_event_invalid' => ['fr' => 'Événement introuvable.', 'en' => 'Event not found.'],
'bib_v5_production_range_invalid' => ['fr' => 'Une séquence de dossards est invalide.', 'en' => 'A bib range is invalid.'],
'bib_v5_production_generation_error' => ['fr' => 'Impossible de générer le fichier Excel.', 'en' => 'Unable to generate the Excel file.'],
'bib_v5_production_file_missing' => ['fr' => 'Le fichier Excel enregistré est introuvable.', 'en' => 'The saved Excel file could not be found.'],
'bib_v5_production_col_bib' => ['fr' => 'Numéro de dossard', 'en' => 'Bib number'],
'bib_v5_production_col_race' => ['fr' => 'Épreuve', 'en' => 'Race'],
'bib_v5_production_col_printer_lines' => ['fr' => 'Lignes Imprimeur', 'en' => 'Printer lines'],
'bib_v5_production_total' => ['fr' => 'TOTAL', 'en' => 'TOTAL'],
'bib_v5_production_locked_error' => ['fr' => 'Les séquences sont verrouillées parce que le fichier est en impression.', 'en' => 'The ranges are locked because the file is in print.'],
'bib_v5_production_print_lock_col' => ['fr' => 'Impression', 'en' => 'Printing'],
'bib_v5_production_print_lock_tip' => ['fr' => 'Verrouillé pour l’impression : cette séquence ne peut plus être modifiée.', 'en' => 'Locked for printing: this range can no longer be modified.'],
'bib_v5_production_dev_unlock' => ['fr' => 'Déverrouiller pour le développement', 'en' => 'Unlock for development'],
'bib_v5_production_dev_unlock_help' => ['fr' => 'Réactive temporairement la modification de toutes les séquences de cet événement.', 'en' => 'Temporarily enables editing for all ranges in this event.'],
'bib_v5_operations_intro' => ['fr' => 'Contrôlez les anomalies et préparez les documents pour la distribution.', 'en' => 'Review anomalies and prepare distribution documents.'],
'bib_v5_settings_intro' => ['fr' => 'Gérez les règles qui s’appliquent à l’ensemble de l’événement.', 'en' => 'Manage rules that apply to the entire event.'],
'bib_v4_event_config_title' => ['fr' => "Configuration globale pour l'assignation de dossard", 'en' => 'Global bib assignment settings'],
'bib_v4_event_config_inter_epr_on' => ['fr' => 'Inter épreuve', 'en' => 'Inter-race'],
'bib_v4_anomalies_nav_todo' => ['fr' => 'Élément à valider', 'en' => 'Item to review'],
'bib_v4_anomalies_nav_todo_fmt' => ['fr' => 'Élément à valider : %d', 'en' => 'Item to review: %d'],
'bib_v4_qty_summary_title' => ['fr' => 'Sommaire des quantités', 'en' => 'Quantity summary'],
'bib_v4_qty_summary_a_assigner' => ['fr' => 'À assigner', 'en' => 'To assign'],
'bib_v4_qty_summary_bib_restant' => ['fr' => 'Dossards restants', 'en' => 'Bibs remaining'],
'bib_v4_qty_summary_orphelins' => ['fr' => 'Personnes orphelines', 'en' => 'Orphan participants'],
'bib_v4_qty_summary_total' => ['fr' => 'Inscrits', 'en' => 'Registered'],
'bib_v4_qty_summary_avec_bib' => ['fr' => 'Avec dossard', 'en' => 'With bib'],
'bib_v4_qty_summary_sans_bib' => ['fr' => 'Sans dossard', 'en' => 'Without bib'],
'bib_v4_qty_summary_places_dispo' => ['fr' => 'Places disponibles', 'en' => 'Places available'],
'bib_v4_qty_summary_global' => ['fr' => 'Total événement', 'en' => 'Event total'],
'bib_v4_qty_summary_by_epr' => ['fr' => 'Détail par épreuve', 'en' => 'Breakdown by race'],
'bib_v4_qty_summary_col_epr' => ['fr' => 'Épreuve', 'en' => 'Race'],
'bib_v4_ajax_global_sim_summary' => ['fr' => '%d épreuve(s) · %d dispo / %d à assigner → %d assignables (%d manque)', 'en' => '%d race(s) · %d avail. / %d to assign → %d assignable (%d short)'],
'bib_v4_dist_print_title' => ['fr' => 'Impression PDF — distribution des dossards', 'en' => 'PDF print — bib distribution'],
'bib_v4_dist_print_questions' => ['fr' => 'Colonnes optionnelles (questions)', 'en' => 'Optional columns (questions)'],
'bib_v4_dist_print_generate' => ['fr' => 'Générer le PDF', 'en' => 'Generate PDF'],
'bib_v4_dist_print_last_none' => ['fr' => 'Aucune impression enregistrée pour cet événement.', 'en' => 'No print recorded for this event yet.'],
'bib_v4_dist_print_max_questions' => ['fr' => 'Maximum %d questions par épreuve pour le format lettre.', 'en' => 'Maximum %d questions per race for letter format.'],
'bib_v4_dist_print_no_questions' => ['fr' => 'Aucune question éligible pour cette épreuve.', 'en' => 'No eligible question for this race.'],
'bib_v4_dist_print_col_bib' => ['fr' => 'Dossard', 'en' => 'Bib'],
'bib_v4_dist_print_col_nom' => ['fr' => 'Nom', 'en' => 'Last name'],
'bib_v4_dist_print_col_prenom' => ['fr' => 'Prénom', 'en' => 'First name'],
// MSIN-4471 — Feuille bénévole : nom+prénom + case remise.
'bib_v4_dist_print_col_nom_prenom' => ['fr' => 'Nom, Prénom', 'en' => 'Last name, First name'],
'bib_v4_dist_print_col_check' => ['fr' => 'OK', 'en' => 'OK'],
'bib_v4_dist_print_col_sexe' => ['fr' => 'Sexe', 'en' => 'Gender'],
'bib_v4_dist_print_empty_epr' => ['fr' => 'Aucun dossard assigné pour cette épreuve.', 'en' => 'No bib assigned for this race.'],
'bib_v4_dist_print_last' => ['fr' => 'Dernière impression : %s — %s', 'en' => 'Last print: %s — %s'],
'bib_v4_dist_print_footer' => ['fr' => 'Imprimé le %s — %s', 'en' => 'Printed on %s — %s'],
'bib_v4_dist_print_page' => ['fr' => 'Page %s / %s', 'en' => 'Page %s / %s'],
];
return $tab[$clef][$lng] ?? '';
}
/** Libellé « Annulé » dans la vue dossards — repli si clé BD absente ou mal saisie. */
function fxBibViewCancelledLabel($strLangue = 'fr') {
$str = fxBibTexte('bib_v4_view_cancelled', 0);
if ($str === '' || $str === 'bib_v4_view_cancelled' || $str === '*bib_v4_view_cancelled*') {
return ($strLangue === 'en') ? 'Cancelled' : 'Annulé';
}
return $str;
}
/** Message bib v4 avec placeholders sprintf (%d, %s…) — AJAX et vues dynamiques. */
function fxBibMsg($clef, ...$args) {
$str = fxBibTexte($clef, 0);
if (!empty($args)) {
return vsprintf($str, $args);
}
return $str;
}
/** Crayon traduction bib v4 (page info bib). */
function fxBibTradButton($clef) {
return fxAdminTradButton($clef, fxBibInfoPage());
}
/** Texte bib + crayon si mode Textes actif. */
function fxBibTexteTrad($clef, $mem_echo = 0, $blnAllowEmptyLabel = false) {
$html = fxBibEsc(fxBibTexte($clef, 0, $blnAllowEmptyLabel)) . fxBibTradButton($clef);
if ($mem_echo) {
echo $html;
}
return $html;
}
/** Message sprintf + crayon. */
function fxBibMsgTrad($clef, ...$args) {
return fxBibEsc(fxBibMsg($clef, ...$args)) . fxBibTradButton($clef);
}
/** Clé site promoteur_* puis repli bib_v4_* + crayon sur la clé bib. */
function fxBibSiteOrBibTexteTrad($strSiteClef, $strBibClef, $mem_echo = 0) {
$html = fxBibEsc(fxBibSiteOrBibTexte($strSiteClef, $strBibClef)) . fxBibTradButton($strBibClef);
if ($mem_echo) {
echo $html;
}
return $html;
}
/** Description d'une épreuve en conflit : type + catégorie (langue courante), (inactive) si epr_actif = 0. */
function fxBibEpreuveDisplayName(array $row, $strLangue = 'fr') {
$strLangue = in_array($strLangue, ['fr', 'en'], true) ? $strLangue : 'fr';
$strAlt = $strLangue === 'fr' ? 'en' : 'fr';
$strType = trim($row['epr_type_' . $strLangue] ?? '');
if ($strType === '') {
$strType = trim($row['epr_type_' . $strAlt] ?? '');
}
$strCat = trim($row['epr_categorie_' . $strLangue] ?? '');
if ($strCat === '') {
$strCat = trim($row['epr_categorie_' . $strAlt] ?? '');
}
$parts = [];
if ($strType !== '') {
$parts[] = $strType;
}
if ($strCat !== '') {
$parts[] = $strCat;
}
$str = implode(' ', $parts);
if ($str === '') {
$strNom = trim($row['epr_nom_' . $strLangue] ?? '');
if ($strNom === '') {
$strNom = trim($row['epr_nom_' . $strAlt] ?? '');
}
$str = $strNom;
}
if ($str === '' && !empty($row['epr_id'])) {
$str = '#' . (int)$row['epr_id'];
}
if ((int)($row['epr_actif'] ?? 1) === 0) {
$strInactive = trim(fxBibTexte('bib_v4_ajax_overlap_inactive', 0));
if ($strInactive !== '' && $strInactive !== 'bib_v4_ajax_overlap_inactive') {
$str .= ' (' . $strInactive . ')';
}
}
return $str;
}
/**
* MSIN-4424 — Séquences qui chevauchent [start, end].
* Par défaut : tout l'événement. Si doublons inter-épreuves autorisés : même epr_id seulement.
*
* @return array|null Tableau 1-based fxGetResults, ou null si paramètres invalides.
*/
function fxBibGetOverlappingRanges($eve_id, $start, $end, $exclude_bib_id = 0, $epr_id = 0) {
global $objDatabase;
$eve_id = (int)$eve_id;
$start = (int)$start;
$end = (int)$end;
$exclude_bib_id = (int)$exclude_bib_id;
$epr_id = (int)$epr_id;
if ($eve_id <= 0 || $start <= 0 || $end <= 0) {
return null;
}
$sqlExclude = ($exclude_bib_id > 0) ? "AND b.epr_bib_id <> $exclude_bib_id" : '';
$sqlEprOnly = '';
if ($epr_id > 0 && fxBibEventAllowsInterEprDuplicates($eve_id)) {
$sqlEprOnly = "AND b.epr_id = $epr_id";
}
$sql = "
SELECT
b.epr_bib_id,
b.epr_id,
b.epr_bib_start,
b.epr_bib_finish,
e.epr_nom_fr,
e.epr_nom_en,
e.epr_type_fr,
e.epr_type_en,
e.epr_categorie_fr,
e.epr_categorie_en,
e.epr_actif
FROM inscriptions_epreuves_bib b
INNER JOIN inscriptions_epreuves e ON e.epr_id = b.epr_id
WHERE b.eve_id = $eve_id
AND b.epr_bib_start IS NOT NULL
AND b.epr_bib_finish IS NOT NULL
$sqlExclude
$sqlEprOnly
AND ($start <= b.epr_bib_finish AND $end >= b.epr_bib_start)
ORDER BY b.epr_bib_start, b.epr_bib_id
";
return $objDatabase->fxGetResults($sql);
}
/** Message d'erreur détaillé pour un chevauchement de séquences de dossards. */
function fxBibFormatOverlapConflictMessage($tabOverlaps, $strLangue = 'fr') {
if (empty($tabOverlaps) || !is_array($tabOverlaps)) {
return fxBibTexte('bib_v4_ajax_overlap', 0);
}
$entries = [];
$firstRow = null;
foreach ($tabOverlaps as $row) {
if (!is_array($row)) {
continue;
}
if ($firstRow === null) {
$firstRow = $row;
}
$entries[] = fxBibMsg(
'bib_v4_ajax_overlap_entry',
fxBibEpreuveDisplayName($row, $strLangue),
(int)$row['epr_bib_start'],
(int)$row['epr_bib_finish']
);
}
if (empty($entries) || $firstRow === null) {
return fxBibTexte('bib_v4_ajax_overlap', 0);
}
if (count($entries) === 1) {
return fxBibMsg(
'bib_v4_ajax_overlap',
(int)$firstRow['epr_bib_start'],
(int)$firstRow['epr_bib_finish'],
fxBibEpreuveDisplayName($firstRow, $strLangue)
);
}
return fxBibMsg('bib_v4_ajax_overlap_many', implode('; ', $entries));
}
/** MSIN-4379 — Attributs data-js-* injectés dans #module-bib pour le JS client. */
function fxBibModuleJsDataAttrs() {
$map = [
'loader-wait' => 'bib_v4_js_loader_wait',
'server-error' => 'bib_v4_js_server_error',
'fields-required' => 'bib_v4_js_fields_required',
'auto-select-count' => 'bib_v4_js_auto_select_count',
'batch-none' => 'bib_v4_js_batch_none_selected',
'batch-summary-ok' => 'bib_v4_js_batch_summary_ok',
'reset-warning' => 'bib_v4_js_reset_warning',
'auto-disable-confirm'=> 'bib_v4_js_auto_disable_confirm',
'no-seq-selected' => 'bib_v4_ajax_no_seq_selected',
'err-generic' => 'bib_v4_ajax_error',
'batch-summary-short' => 'bib_v4_ajax_sim_summary',
'batch-reset-count' => 'bib_v4_ajax_reset_preview_count',
'auto-select-hint' => 'bib_v4_auto_select_hint',
'lock-confirm' => 'bib_v4_js_lock_confirm',
'unlock-confirm' => 'bib_v4_js_unlock_confirm',
'auto-pending-bibs' => 'bib_v4_js_auto_pending_bibs',
'range-incomplete' => 'bib_v4_js_range_incomplete',
'range-invalid' => 'bib_v4_js_range_invalid',
'range-invalid-end' => 'bib_v4_js_range_invalid_end',
'range-invalid-qty' => 'bib_v4_js_range_invalid_qty',
'qte-total-min' => 'bib_v5_qte_total_min',
'batch-progress' => 'bib_v4_js_batch_progress',
'global-no-epr' => 'bib_v4_js_global_no_epr',
'global-no-seq' => 'bib_v4_js_global_no_seq',
'global-gen-no-start' => 'bib_v4_global_batch_gen_no_start',
'global-gen-epr-missing' => 'bib_v4_js_global_gen_epr_missing',
'global-gen-no-epr' => 'bib_v4_js_global_no_epr',
'global-batch-finalizing' => 'bib_v4_js_global_batch_finalizing',
'global-batch-complete-title' => 'bib_v4_global_batch_go_complete_title',
'global-batch-complete-summary' => 'bib_v4_global_batch_go_complete_summary',
'global-batch-complete-reload' => 'bib_v4_global_batch_go_complete_reload',
// MSIN-4445
'global-free-qty-juste' => 'bib_v4_global_batch_free_qty_juste',
'global-free-qty-manquante' => 'bib_v4_global_batch_free_qty_manquante',
'global-free-qty-supplementaire' => 'bib_v4_global_batch_free_qty_supplementaire',
'global-free-dupes-warn' => 'bib_v4_global_batch_free_dupes_warn',
'global-free-plan-invalid' => 'bib_v4_global_batch_free_plan_invalid',
'reset-all-confirm' => 'bib_v4_js_reset_all_confirm',
'reset-all-locked' => 'bib_v4_js_reset_all_locked',
'assign-full' => 'bib_v4_ajax_assign_full',
'assign-partial' => 'bib_v4_ajax_assign_partial',
'assign-none' => 'bib_v4_ajax_assign_none',
'anomalies-nav-todo' => 'bib_v4_anomalies_nav_todo',
'anomalies-nav-todo-fmt' => 'bib_v4_anomalies_nav_todo_fmt',
];
$html = '';
foreach ($map as $attr => $clef) {
$html .= ' data-js-' . $attr . '="' . fxBibEsc(fxBibTexte($clef, 0)) . '"';
}
return $html;
}
/** Texte d'aide long bib v4 — même règle que fxBibTexte pour l'auto-création. */
function fxBibAide($clef, $mem_echo = 0) {
$row = fxBibGetInfoRow($clef);
$str = trim($row['info_aide'] ?? '');
if ($str === '' && (!defined('MS1_BIB_AJAX') || !MS1_BIB_AJAX)) {
$str = trim(afficheAide($clef, 0));
}
if ($mem_echo) {
echo fxBibEsc($str);
}
return $str;
}
/** Attribut data-tippy-content — info_aide (tips sur icônes œil, colonnes sans libellé, etc.). */
function fxBibAideTippyAttr($clef) {
$strTip = trim(fxBibAide($clef, 0));
if ($strTip === '') {
return '';
}
return ' data-tippy-content="' . fxBibEsc($strTip) . '"';
}
/** Bouton œil (grille dossards) + crayon traduction en mode Textes — clé bib_v4_col_view. */
function fxBibRenderViewRangeButton($intEprId, $intRangeId, $strBtnClass = 'btn btn-sm btn-secondary btn-view-range') {
return '
'
. ''
. ' '
. fxBibTradButton('bib_v4_col_view')
. ' ';
}
/** Attribut data-tippy-content — texte court depuis info_texte (clé bib_v4_tip_*). */
function fxBibTippyAttr($clef) {
$strTip = trim(fxBibTexte($clef, 0));
if ($strTip === '' || $strTip === '*' . $clef . '*') {
return '';
}
return ' data-tippy-content="' . fxBibEsc($strTip) . '"';
}
/** Classe CSS de visibilité — toujours appliquée au conteneur entier (bouton + ?). */
function fxBibUiHiddenClass($blnVisible) {
return $blnVisible ? '' : ' bib-ui-hidden';
}
/** Contenu aide (?) — texte caché ; espace visuel avant le rond via CSS (.epr-action-group gap). */
function fxBibAideInner($clef) {
$strAide = trim(fxBibAide($clef, 0));
if ($strAide === '') {
return '';
}
return '
' . fxBibEsc($strAide) . ' ?';
}
/** Bouton (?) rond + crayon traduction (via fxAdminTradButton) — $strTone optionnel. */
function fxBibAideButton($clef, $strTone = '', $blnWithTrad = true) {
$strHtml = '';
$strInner = fxBibAideInner($clef);
if ($strInner !== '') {
$strClass = 'btn-aide-bib bib-aide-trigger';
if ($strTone !== '') {
$strClass .= ' btn-aide-tone-' . preg_replace('/[^a-z0-9-]/', '', $strTone);
}
$strHtml = '
'
. $strInner
. ' ';
}
if ($blnWithTrad) {
$strHtml .= fxAdminTradButton($clef, fxBibInfoPage());
}
return $strHtml;
}
/** Clé site promoteur_* puis repli bib_v4_* si absent en BD. */
function fxBibSiteOrBibTexte($strSiteClef, $strBibClef) {
$str = trim(afficheTexte($strSiteClef, 0));
if ($str === '' || $str === '*' . $strSiteClef . '*') {
$str = fxBibTexte($strBibClef, 0);
}
return $str;
}
/** Libellé info_texte + bouton (?) si info_aide renseigné. */
function fxBibTexteAide($clef, $mem_echo = 1) {
$str = fxBibTexte($clef, 0);
$html = fxBibEsc($str) . fxBibAideButton($clef);
if ($mem_echo) {
echo $html;
}
return $html;
}
/** Titre d'en-tête de bloc (assignation, gestion…) + aide + doc overlay optionnel. */
function fxBibBlockHeader($clef, $docAnchorClef = '') {
$html = '';
}
/** Pastille résumé dans la bande bleue (quantité dispo, séquences, etc.). */
function fxBibHeaderSummaryBadge($strText, $strVariant = '', $strTradClef = '') {
$strClass = 'epr-header-summary';
if ($strVariant !== '') {
$strClass .= ' epr-header-summary--' . preg_replace('/[^a-z0-9-]/', '', $strVariant);
}
$strInner = fxBibEsc($strText);
if ($strTradClef !== '') {
$strInner .= fxBibTradButton($strTradClef);
}
return '
' . $strInner . ' ';
}
/** Résumé gestion : quantité disponible. */
function fxBibGestionHeaderSummary($epr_id) {
$arrQuantites = fxGetQuantites((int)$epr_id);
$intDispo = (int)$arrQuantites['qte_restante'];
$strLabel = fxBibSiteOrBibTexte('promoteur_qte_epr_qte', 'bib_v4_summary_dispo');
return fxBibHeaderSummaryBadge($strLabel . ' : ' . $intDispo, 'dispo', 'bib_v4_summary_dispo');
}
/** Résumé assignation : nombre de séquences (+ auto si actif). */
function fxBibAssignHeaderSummary($intSeqCount, $blnAutoActive = false) {
$html = '';
$intSeqCount = (int)$intSeqCount;
if ($intSeqCount > 0) {
if ($intSeqCount === 1) {
$html .= fxBibHeaderSummaryBadge(
fxBibTexte('bib_v4_summary_seq_one', 0),
'seq',
'bib_v4_summary_seq_one'
);
} else {
$html .= fxBibHeaderSummaryBadge(
fxBibMsg('bib_v4_summary_seq_many', $intSeqCount),
'seq',
'bib_v4_summary_seq_many'
);
}
} else {
$html .= fxBibHeaderSummaryBadge(
fxBibTexte('bib_v4_summary_seq_empty', 0),
'seq-empty',
'bib_v4_summary_seq_empty'
);
}
if ($blnAutoActive) {
$html .= fxBibHeaderSummaryBadge(
fxBibTexte('bib_v4_auto_badge', 0),
'auto',
'bib_v4_auto_badge'
);
}
return $html;
}
/** MSIN-4446 — Compte les séquences persistées (ignore la ligne UI temporaire epr_bib_id=0). */
function fxBibCountSavedRanges(array $tabBibRanges) {
$intCount = 0;
foreach ($tabBibRanges as $range) {
if ((int)($range['epr_bib_id'] ?? 0) > 0) {
$intCount++;
}
}
return $intCount;
}
/**
* MSIN-4446 — Pastille(s) résumé à renvoyer avec le HTML des séquences (AJAX).
* Évite que « 1 séquence » reste affiché après delete / save / refresh.
*/
function fxBibAssignRangesAjaxExtras($epr_id, array $tabBibRanges) {
$epr_id = (int)$epr_id;
$intSeqCount = fxBibCountSavedRanges($tabBibRanges);
$blnAutoActive = $epr_id > 0 ? fxIsBibAutoActive($epr_id) : false;
return [
'summary_html' => fxBibAssignHeaderSummary($intSeqCount, $blnAutoActive),
'seq_count' => $intSeqCount,
'auto_active' => $blnAutoActive ? 1 : 0,
];
}
/** Dossards encore disponibles dans une séquence (stats fxInfosBibRange). */
function fxBibRangeDispoFromRow(array $range) {
$nb_total = (int)($range['nb_total_range'] ?? 0);
$nb_utilises = (int)($range['nb_utilises'] ?? 0);
return max(0, $nb_total - $nb_utilises);
}
/** Séquence utilisable pour l'assignation auto (au moins un dossard libre). */
function fxBibIsRangeAvailableForAuto($epr_id, $epr_bib_id) {
$rows = fxInfosBibRange((int)$epr_id, (int)$epr_bib_id);
if (empty($rows) || !is_array($rows[1] ?? null)) {
return false;
}
if (fxBibRangeIsLocked($rows[1])) {
return false;
}
return fxBibRangeDispoFromRow($rows[1]) > 0;
}
/** Séquence verrouillée (epr_bib_locked = 1) — plus de modification ni assignation. */
function fxBibRangeIsLocked(array $range) {
return (int)($range['epr_bib_locked'] ?? 0) === 1;
}
/** Vérifie qu'aucune des séquences listées n'est verrouillée. */
function fxBibAssertRangesUnlocked($epr_id, $rangeIds) {
global $objDatabase;
$epr_id = (int)$epr_id;
if ($epr_id <= 0 || empty($rangeIds) || !is_array($rangeIds)) {
return ['success' => true];
}
$ids = array_values(array_filter(array_map('intval', $rangeIds)));
if (empty($ids)) {
return ['success' => true];
}
$strIds = implode(',', $ids);
$sql = "
SELECT COUNT(*)
FROM inscriptions_epreuves_bib
WHERE epr_id = $epr_id
AND epr_bib_id IN ($strIds)
AND epr_bib_locked = 1
";
if ((int)$objDatabase->fxGetVar($sql) > 0) {
return ['success' => false, 'message' => fxBibMsg('bib_v4_ajax_range_locked')];
}
return ['success' => true];
}
/** Bascule le verrou d'une séquence (0 = ouvert, 1 = fermé). */
function fxBibSetRangeLocked($epr_bib_id, $locked, $epr_id = 0) {
global $objDatabase;
$epr_bib_id = (int)$epr_bib_id;
$epr_id = (int)$epr_id;
$locked = $locked ? 1 : 0;
if ($epr_bib_id <= 0) {
return ['success' => false, 'message' => fxBibMsg('bib_v4_ajax_id_invalid')];
}
$sqlGet = "
SELECT epr_id
FROM inscriptions_epreuves_bib
WHERE epr_bib_id = $epr_bib_id
";
$rowEprId = (int)$objDatabase->fxGetVar($sqlGet);
if ($rowEprId <= 0) {
return ['success' => false, 'message' => fxBibMsg('bib_v4_ajax_range_not_found')];
}
if ($epr_id > 0 && $rowEprId !== $epr_id) {
return ['success' => false, 'message' => fxBibMsg('bib_v4_ajax_seq_invalid')];
}
if (fxBibProductionEpreuveIsLocked($rowEprId)) {
return ['success' => false, 'message' => fxBibMsg('bib_v5_production_locked_error')];
}
$objDatabase->fxQuery("
UPDATE inscriptions_epreuves_bib
SET epr_bib_locked = $locked
WHERE epr_bib_id = $epr_bib_id
");
if ($locked === 1) {
$objDatabase->fxQuery("
UPDATE inscriptions_epreuves_bib
SET epr_bib_auto = 0
WHERE epr_bib_id = $epr_bib_id
");
}
return [
'success' => true,
'epr_id' => $rowEprId,
'locked' => $locked === 1,
];
}
/** Bouton cadenas utilisateur (vert ouvert / rouge fermé) devant une séquence enregistrée. */
function fxBibRenderRangeLockButton(array $range, $epr_id = 0, $blnDisabled = false) {
if ((int)($range['epr_bib_id'] ?? 0) <= 0) {
return '
';
}
$locked = fxBibRangeIsLocked($range);
$strClass = $locked ? 'btn-bib-lock--closed' : 'btn-bib-lock--open';
$strIcon = $locked ? 'fa-lock' : 'fa-unlock';
$strTip = $locked ? 'bib_v4_tip_lock_closed' : 'bib_v4_tip_lock_open';
return '
'
. '
';
}
/** MSIN-4469 — Cadenas distinct signalant le verrouillage physique pour impression. */
function fxBibRenderProductionRangeLock($blnProductionLocked) {
if (!$blnProductionLocked) {
return '
';
}
$strLabel = fxBibTexte('bib_v5_production_print_lock_tip', 0);
return '
'
. ''
. '
';
}
/** Badge « Assignation automatique » sur une ligne de séquence (epr_bib_auto = 1). */
function fxBibRenderRangeAutoBadge(array $range, $mode = 'assign') {
if ($mode !== 'assign') {
return '';
}
if ((int)($range['epr_bib_id'] ?? 0) <= 0) {
return '';
}
if ((int)($range['epr_bib_auto'] ?? 0) !== 1) {
return '';
}
if (fxBibRangeIsLocked($range)) {
return '';
}
if (fxBibRangeDispoFromRow($range) <= 0) {
return '';
}
return '
'
. fxBibEsc(fxBibTexte('bib_v4_auto', 0))
. fxBibTradButton('bib_v4_auto')
. ' ';
}
/** MSIN-4436 — Nombre d'équipes actives sur une épreuve équipe. */
function fxBibCountEquipes($epr_id) {
global $objDatabase;
$epr_id = (int)$epr_id;
if ($epr_id <= 0) {
return 0;
}
return (int)$objDatabase->fxGetVar("
SELECT COUNT(DISTINCT p.pec_id)
FROM resultats_participants p
WHERE p.epr_id = $epr_id
AND p.is_cancelled = 0
AND p.pec_id > 0
");
}
/** Pastilles épreuve (solo/équipe, inscrits, avec dossard) — bande bleue colonne gauche. */
function fxBibEpreuveHeaderSummaries($tabEpreuve, $infoBib) {
$html = '';
if ((int)$tabEpreuve['epr_equipe'] === 1) {
$intNbEquipes = (int)($infoBib['nb_equipes'] ?? 0);
$html .= fxBibHeaderSummaryBadge(
fxBibSiteOrBibTexte('promoteur_epr_equipe', 'bib_v4_summary_team'),
'team',
'bib_v4_summary_team'
);
$html .= '';
} else {
$html .= fxBibHeaderSummaryBadge(
fxBibSiteOrBibTexte('promoteur_epr_solo', 'bib_v4_summary_solo'),
'solo',
'bib_v4_summary_solo'
);
}
$html .= '';
$html .= '';
return $html;
}
/** En-tête bleu colonne gauche : titre de l'épreuve + pastilles (aligné visuellement avec la droite). */
function renderBibEpreuveIdentityHeader($tabEpreuve, $infoBib, $strLangue = 'fr') {
$strCat = trim($tabEpreuve['epr_categorie_' . $strLangue] ?? '');
$strType = trim($tabEpreuve['epr_type_' . $strLangue] ?? '');
$strNom = trim($tabEpreuve['epr_nom_' . $strLangue] ?? '');
$intEprId = (int)($tabEpreuve['epr_id'] ?? 0);
ob_start();
?>
>
'
. '
';
}
return '
'
. ' ';
}
/** Cellule d'en-tête de colonne séquence + aide optionnelle (info_texte peut être vide). */
function fxBibColHeader($clef) {
$strLabel = fxBibTexte($clef, 0, true);
$strClass = 'epr-col-header-label';
if ($strLabel === '') {
$strClass .= ' epr-col-header-label--empty';
}
return '
'
. fxBibEsc($strLabel)
. fxBibAideButton($clef)
. fxBibTradButton($clef)
. ' ';
}
/** Groupe action (bouton + ?) — $strClass ex. « epr-action-batch-group ». */
function fxBibActionGroupOpen($strClass, $blnVisible = true) {
return '
';
}
function fxBibActionGroupClose() {
return ' ';
}
/** Ouvre le segment bouton + ? collés (option A — rangée d'actions). */
function fxBibBtnAideSegmentOpen($strExtraClass = '') {
$strClass = 'epr-btn-aide-segment';
if ($strExtraClass !== '') {
$strClass .= ' ' . preg_replace('/[^a-z0-9 _-]/', '', $strExtraClass);
}
return '
';
}
function fxBibBtnAideSegmentClose($clef = '') {
$html = '';
if ($clef !== '') {
$html .= fxBibTradButton($clef);
}
return $html . ' ';
}
/** MSIN-4468 — Capacité totale modifiable; disponibilité dérivée en lecture seule. */
function renderBibGestionEpreuve($epr_id, $int_eve_id, $strLangue) {
$epr_id = (int)$epr_id;
$int_eve_id = (int)$int_eve_id;
$arrQuantites = fxGetQuantites($epr_id);
$tabEpreuve = fxGetEpreuve($epr_id);
$QCheckin = fxGetCheckinqte($epr_id);
$nbSurListeA = fx_liste_attente_nombre_surliste($epr_id, 1);
$nbSurListe = fx_liste_attente_nombre_surliste($epr_id);
$intNbSurListeA = ($nbSurListeA !== false && $nbSurListeA > 0) ? (int)$nbSurListeA : 0;
$intNbSurListe = ($nbSurListe !== false && $nbSurListe > 0) ? (int)$nbSurListe : 0;
$blnQteLimitee = intval($tabEpreuve['epr_qte_limitee'] ?? 0) === 1;
$blnCanEditQte = !empty($_SESSION['usa_id'])
|| (!empty($_SESSION['com_id'])
&& function_exists('fxEveAccesHasPermission')
&& fxEveAccesHasPermission($_SESSION['com_id'], $int_eve_id, 'epreuves.edit_qte'));
ob_start();
?>
0 ? $intNbSurListeA : '—'; ?>
0 ? $intNbSurListe : '—'; ?>
>
0 && $intEnd >= $intStart) {
$intQty = $intEnd - $intStart + 1;
}
return [
'qty' => $intQty,
'start' => $intStart,
'end' => $intEnd,
'has_values' => ($intId > 0 && $intStart > 0 && $intEnd >= $intStart),
];
}
/** MSIN-4429 — Colonne « ou » entre Qté et Fin. */
function fxBibRenderRangeOrCell() {
ob_start();
?>
0;
ob_start();
?>
$intBibId,
'start' => (int)$row['epr_bib_start'],
'end' => (int)$row['epr_bib_finish'],
'dispo' => $intDispo,
];
}
return $out;
}
/** MSIN-4436 — Vérifie épreuve solo de l'événement (batch global). */
function fxBibAssertSoloEpreuveForGlobalBatch($epr_id, $int_eve_id) {
global $objDatabase;
$epr_id = (int)$epr_id;
$int_eve_id = (int)$int_eve_id;
$row = $objDatabase->fxGetRow("
SELECT epr_id, eve_id, epr_equipe
FROM inscriptions_epreuves
WHERE epr_id = $epr_id
LIMIT 1
");
if (!$row || (int)$row['eve_id'] !== $int_eve_id) {
return ['success' => false, 'message' => fxBibMsg('bib_v4_ajax_epr_invalid')];
}
if ((int)$row['epr_equipe'] === 1) {
return ['success' => false, 'message' => fxBibMsg('bib_v4_global_batch_team_excluded')];
}
return ['success' => true];
}
/** MSIN-4436 — Plans batch global validés [{epr_id, ranges[]}]. */
function fxBibParseGlobalBatchPlans($plans, $int_eve_id) {
if (!is_array($plans)) {
return [];
}
$out = [];
foreach ($plans as $plan) {
$epr_id = (int)($plan['epr_id'] ?? 0);
$ranges = $plan['ranges'] ?? [];
if ($epr_id <= 0 || !is_array($ranges)) {
continue;
}
$check = fxBibAssertSoloEpreuveForGlobalBatch($epr_id, $int_eve_id);
if (!$check['success']) {
continue;
}
$ranges = array_values(array_filter(array_map('intval', $ranges)));
if (empty($ranges)) {
continue;
}
$lockCheck = fxBibAssertRangesUnlocked($epr_id, $ranges);
if (!$lockCheck['success']) {
continue;
}
$out[] = [
'epr_id' => $epr_id,
'ranges' => $ranges,
];
}
return $out;
}
/** MSIN-4440 — Pastille tuile Anomalies (style Inter épreuve, sans compteur rouge). */
function renderBibAnomaliesNavBadge($intCount = 0, $blnPending = false) {
if ($blnPending || (int)$intCount <= 0) {
return '';
}
$strLabel = fxBibMsg('bib_v4_anomalies_nav_todo_fmt', (int)$intCount);
if ($strLabel === '' || $strLabel === 'bib_v4_anomalies_nav_todo_fmt') {
$strLabel = fxBibTexte('bib_v4_anomalies_nav_todo', 0) . ' : ' . (int)$intCount;
}
return '';
}
/**
* MSIN-4440 — Bouton tuile de la grille outils bib v4.
*/
function renderBibToolNavBtn($strTool, $strTitleClef, $strBadgesHtml = '', $blnAlt = false, $strDocClef = '') {
$strClass = 'bib-tool-btn';
if ($blnAlt) {
$strClass .= ' bib-tool-btn--alt';
}
$strTitle = fxBibTexte($strTitleClef, 0);
// div role=button : évite button dans button (icônes aide/doc) — HTML invalide qui casse la grille.
$html = '
';
$html .= '';
$html .= '';
$html .= '' . fxBibEsc($strTitle) . ' ';
$html .= '';
$html .= fxBibAideButton($strTitleClef);
if ($strDocClef !== '') {
$html .= fxDocRenderTrigger($strDocClef);
$html .= fxAdminDocButton($strDocClef);
}
$html .= ' ';
$html .= ' ';
if ($strBadgesHtml !== '') {
$html .= '' . $strBadgesHtml . ' ';
}
$html .= '
';
return $html;
}
/** MSIN-4467 — Onglet principal de l'espace de travail dossards. */
function renderBibWorkspaceTab($strWorkspace, $strTitleClef, $blnActive = false) {
$strClass = 'bib-workspace-tab' . ($blnActive ? ' is-active' : '');
return '
'
. fxBibEsc(fxBibTexte($strTitleClef, 0))
. fxBibTradButton($strTitleClef)
. ' ';
}
/** MSIN-4467 — Résumé événement affiché avant le détail des épreuves. */
function renderBibPreparationOverview(array $tabEpreuves, $strAnomBadges = '') {
$intRegistered = 0;
$intAssigned = 0;
foreach ($tabEpreuves as $tabEpreuve) {
if (!is_array($tabEpreuve)) {
continue;
}
$tabInfo = fxInfosBibEpreuve((int)($tabEpreuve['epr_id'] ?? 0));
$intRegistered += (int)($tabInfo['total'] ?? 0);
$intAssigned += (int)($tabInfo['avec_bib'] ?? 0);
}
$intPending = max(0, $intRegistered - $intAssigned);
$tabQuantityStats = [
['value' => count($tabEpreuves), 'key' => 'bib_v5_stat_races', 'tone' => ''],
['value' => $intRegistered, 'key' => 'bib_v5_stat_registered', 'tone' => ''],
];
$tabBibStats = [
['value' => $intAssigned, 'key' => 'bib_v5_stat_assigned', 'tone' => 'success'],
['value' => $intPending, 'key' => 'bib_v5_stat_pending', 'tone' => $intPending > 0 ? 'warning' : 'success'],
];
ob_start();
?>
0 ? fxBibProductionGetActiveOrder($intEveId) : null;
$blnProductionLocked = !empty($tabProductionOrder);
$strExcelUrl = $vDomaine . '/bib_production_excel.php';
ob_start();
?>
';
}
/**
* MSIN-4443 — Enveloppe résultats simulation assignation globale (bouton Fermer).
*/
function fxBibWrapGlobalSimView($strSummary, $strSectionsHtml, $strExtraClass = '') {
$strExtraClass = trim((string)$strExtraClass);
$strClass = 'epr-row-view bib-global-sim-view';
if ($strExtraClass !== '') {
$strClass .= ' ' . preg_replace('/[^a-z0-9 _-]/', '', $strExtraClass);
}
ob_start();
?>
$epr,
'ranges' => $tabRanges,
];
}
ob_start();
echo fxBibGlobalBatchSectionOpen('existing', 'bib_v4_global_batch_existing_title', $strLangue);
if (count($tabSolo) < 2) { ?>
fxGetResults($sqlEpreuves);
$sqlBibAssignments = "SELECT * FROM bib_assignements WHERE ba_actif = 1 ORDER BY ba_tri";
$tabBibAssignments = $objDatabase->fxGetResults($sqlBibAssignments);
?>
' . $strPermInspectBadges . '
>
fxGetResults($sqlBibRanges);
// MSIN-4436 — Chargement page : stats séquences sans trous/doublons (calcul complet en AJAX refresh).
$tabBibStats = fxInfosBibRange(intval($tabEpreuves[$i]['epr_id']), 0, false);
$infoBib = fxInfosBibEpreuve(intval($tabEpreuves[$i]['epr_id']));
// MSIN-4379 — Étape 2 : détecte si l'auto est actif (au moins une séquence epr_bib_auto=1).
// Prochain tour : étape 6–7 (assignation à l'achat).
$blnAutoActive = fxIsBibAutoActive((int)$tabEpreuves[$i]['epr_id']);
$blnHasLockedRanges = fxBibEpreuveHasLockedRanges((int)$tabEpreuves[$i]['epr_id']);
$intSeqCount = fxBibCountSavedRanges($tabBibStats);
$intPending = (int)($infoBib['a_assigner'] ?? 0);
$tabQuantites = fxGetQuantites((int)$tabEpreuves[$i]['epr_id']);
$intPlacesAvailable = (int)($tabQuantites['qte_restante'] ?? 0);
// MSIN-4467 — Aucune épreuve ouverte au chargement; l'utilisateur choisit laquelle développer.
$blnRaceExpanded = false;
// MSIN-4467 — L'identité complète de l'épreuve reste visible dans son résumé replié.
$blnTeamEpreuve = ((int)$tabEpreuves[$i]['epr_equipe'] === 1);
$teamMode = (int)$tabEpreuves[$i]['epr_bib_team_mode'];
if ($teamMode <= 0) {
$teamMode = 1;
}
$lockTeamMode = ((int)$infoBib['avec_bib'] > 0);
$strEpreuveMode = $blnTeamEpreuve
? fxBibSiteOrBibTexte('promoteur_epr_equipe', 'bib_v4_summary_team')
: fxBibSiteOrBibTexte('promoteur_epr_solo', 'bib_v4_summary_solo');
$strTeamModeSummary = '';
if ($blnTeamEpreuve) {
$strTeamModeSummary = fxBibTexte(
$teamMode === 3 ? 'bib_v4_team_mode_one_team' : 'bib_v4_team_mode_individual',
0
);
}
?>
0,
$tabEpreuves[$i]
); ?>
>
*/
function fxBibAnomalyGroupDuplicateRows(array $rows, $strLangue = 'fr') {
$grouped = [];
foreach ($rows as $row) {
$intRangeId = (int)$row['epr_bib_id'];
$key = ($intRangeId > 0 ? $intRangeId : (int)$row['epr_id']) . '-' . (int)$row['no_bib'];
if (!isset($grouped[$key])) {
$grouped[$key] = [
'epr_id' => (int)$row['epr_id'],
'epr_label' => fxBibAnomalyEprLabel($row, $strLangue),
'range_id' => $intRangeId,
'range_start' => (int)$row['epr_bib_start'],
'range_end' => (int)$row['epr_bib_finish'],
'no_bib' => (int)$row['no_bib'],
'participants' => [],
];
}
$grouped[$key]['participants'][] = [
'par_id' => (int)$row['par_id'],
'par_prenom' => trim($row['par_prenom'] ?? ''),
'par_nom' => trim($row['par_nom'] ?? ''),
];
}
return array_values($grouped);
}
/**
* MSIN-4424 — Dossards en double entre épreuves (même no_bib, epr_id distincts).
* Vide si le réglage événement autorise les doublons inter-épreuves.
*
* @return array>
*/
function fxBibAnomalyInterEprDuplicateBibs($int_eve_id, $strLangue = 'fr') {
global $objDatabase;
$int_eve_id = (int)$int_eve_id;
if ($int_eve_id <= 0 || fxBibEventAllowsInterEprDuplicates($int_eve_id)) {
return [];
}
$sqlBibNumP = fxBibSqlNoBibUnsigned('p.no_bib');
$sqlBibNumP2 = fxBibSqlNoBibUnsigned('p2.no_bib');
$sql = "
SELECT
$sqlBibNumP AS no_bib,
p.epr_id,
p.par_id,
p.par_prenom,
p.par_nom,
e.epr_nom_fr,
e.epr_nom_en,
e.epr_type_fr,
e.epr_type_en,
e.epr_categorie_fr,
e.epr_categorie_en,
e.epr_actif
FROM resultats_participants p
INNER JOIN inscriptions_epreuves e ON e.epr_id = p.epr_id
WHERE e.eve_id = $int_eve_id
AND p.is_cancelled = 0
AND $sqlBibNumP > 0
AND $sqlBibNumP IN (
SELECT $sqlBibNumP2
FROM resultats_participants p2
INNER JOIN inscriptions_epreuves e2 ON e2.epr_id = p2.epr_id
WHERE e2.eve_id = $int_eve_id
AND p2.is_cancelled = 0
AND $sqlBibNumP2 > 0
GROUP BY $sqlBibNumP2
HAVING COUNT(DISTINCT p2.epr_id) > 1
)
ORDER BY $sqlBibNumP, p.epr_id, p.par_nom, p.par_prenom
";
$rows = $objDatabase->fxGetResults($sql);
if (!is_array($rows) || empty($rows)) {
return [];
}
$grouped = [];
foreach ($rows as $row) {
$intBib = (int)$row['no_bib'];
$key = (string)$intBib;
if (!isset($grouped[$key])) {
$grouped[$key] = [
'no_bib' => $intBib,
'entries' => [],
];
}
$intEprId = (int)$row['epr_id'];
$strEprKey = (string)$intEprId;
if (!isset($grouped[$key]['entries'][$strEprKey])) {
$grouped[$key]['entries'][$strEprKey] = [
'epr_id' => $intEprId,
'epr_label' => fxBibAnomalyEprLabel($row, $strLangue),
'participants' => [],
];
}
$grouped[$key]['entries'][$strEprKey]['participants'][] = [
'par_id' => (int)$row['par_id'],
'par_prenom' => trim($row['par_prenom'] ?? ''),
'par_nom' => trim($row['par_nom'] ?? ''),
];
}
foreach ($grouped as &$item) {
$item['entries'] = array_values($item['entries']);
}
unset($item);
return array_values($grouped);
}
/**
* MSIN-4379 — Dossards en double (même epr_id, même no_bib, >1 unité active).
* Couvre les séquences configurées et les épreuves sans séquence (saisie manuelle).
*
* @return array>
*/
function fxBibAnomalyDuplicateBibs($int_eve_id, $strLangue = 'fr') {
global $objDatabase;
$int_eve_id = (int)$int_eve_id;
if ($int_eve_id <= 0) {
return [];
}
$sqlBibNumP = fxBibSqlNoBibUnsigned('p.no_bib');
$sqlInRange = "
SELECT
b.epr_bib_id,
b.epr_id,
b.epr_bib_start,
b.epr_bib_finish,
e.epr_nom_fr,
e.epr_nom_en,
e.epr_type_fr,
e.epr_type_en,
e.epr_categorie_fr,
e.epr_categorie_en,
e.epr_actif,
$sqlBibNumP AS no_bib,
p.par_id,
p.par_prenom,
p.par_nom
FROM inscriptions_epreuves_bib b
INNER JOIN inscriptions_epreuves e ON e.epr_id = b.epr_id
INNER JOIN resultats_participants p
ON p.epr_id = b.epr_id
AND p.is_cancelled = 0
AND $sqlBibNumP BETWEEN b.epr_bib_start AND b.epr_bib_finish
AND $sqlBibNumP > 0
WHERE e.eve_id = $int_eve_id
AND b.epr_bib_start IS NOT NULL
AND b.epr_bib_finish IS NOT NULL
AND " . fxBibSqlIsBibDuplicateAnomaly('b.epr_id', $sqlBibNumP) . "
ORDER BY b.epr_id, b.epr_bib_start, $sqlBibNumP, p.par_nom, p.par_prenom
";
$sqlNoRange = "
SELECT
0 AS epr_bib_id,
p.epr_id,
0 AS epr_bib_start,
0 AS epr_bib_finish,
e.epr_nom_fr,
e.epr_nom_en,
e.epr_type_fr,
e.epr_type_en,
e.epr_categorie_fr,
e.epr_categorie_en,
e.epr_actif,
$sqlBibNumP AS no_bib,
p.par_id,
p.par_prenom,
p.par_nom
FROM resultats_participants p
INNER JOIN inscriptions_epreuves e ON e.epr_id = p.epr_id
WHERE e.eve_id = $int_eve_id
AND p.is_cancelled = 0
AND $sqlBibNumP > 0
AND NOT " . fxBibSqlEpreuveHasBibRanges('p.epr_id') . "
AND " . fxBibSqlIsBibDuplicateAnomaly('p.epr_id', $sqlBibNumP) . "
ORDER BY p.epr_id, $sqlBibNumP, p.par_nom, p.par_prenom
";
$rows = $objDatabase->fxGetResults($sqlInRange);
if (!is_array($rows)) {
$rows = [];
}
$rowsNoRange = $objDatabase->fxGetResults($sqlNoRange);
if (is_array($rowsNoRange) && !empty($rowsNoRange)) {
$rows = array_merge($rows, $rowsNoRange);
}
if (empty($rows)) {
return [];
}
return fxBibAnomalyGroupDuplicateRows($rows, $strLangue);
}
/**
* MSIN-4405 — Dossards orphelins : inscription annulée dont le no_bib occupe encore une séquence.
* Cause alignée sur fxGetAnnulationCause (annule / transfert), pas de collision inter-épreuves.
*
* @return array>
*/
function fxBibAnomalyOrphanBibs($int_eve_id, $strLangue = 'fr') {
global $objDatabase;
$int_eve_id = (int)$int_eve_id;
if ($int_eve_id <= 0) {
return [];
}
$sqlBibNumP = fxBibSqlNoBibUnsigned('p.no_bib');
$sql = "
SELECT
b.epr_bib_id,
b.epr_id,
b.epr_bib_start,
b.epr_bib_finish,
e.epr_nom_fr,
e.epr_nom_en,
e.epr_type_fr,
e.epr_type_en,
e.epr_categorie_fr,
e.epr_categorie_en,
e.epr_actif,
$sqlBibNumP AS no_bib,
p.par_id,
p.pec_id,
p.par_prenom,
p.par_nom,
ec.pec_actif
FROM inscriptions_epreuves_bib b
INNER JOIN inscriptions_epreuves e ON e.epr_id = b.epr_id
INNER JOIN resultats_participants p
ON p.epr_id = b.epr_id
AND p.eve_id = e.eve_id
AND p.is_cancelled = 1
AND $sqlBibNumP > 0
AND $sqlBibNumP BETWEEN b.epr_bib_start AND b.epr_bib_finish
INNER JOIN resultats_epreuves_commandees ec
ON ec.pec_id_original = p.pec_id
AND ec.epr_id = b.epr_id
AND ec.is_cancelled = 1
WHERE e.eve_id = $int_eve_id
AND b.epr_bib_start IS NOT NULL
AND b.epr_bib_finish IS NOT NULL
ORDER BY b.epr_id, b.epr_bib_start, $sqlBibNumP, p.par_nom, p.par_prenom
";
$rows = $objDatabase->fxGetResults($sql);
if (!is_array($rows) || empty($rows)) {
return [];
}
$out = [];
foreach ($rows as $row) {
$intPecId = (int)$row['pec_id'];
$strCause = fxGetAnnulationCause($intPecId, isset($row['pec_actif']) ? (int)$row['pec_actif'] : null);
$out[] = [
'epr_id' => (int)$row['epr_id'],
'epr_label' => fxBibAnomalyEprLabel($row, $strLangue),
'range_id' => (int)$row['epr_bib_id'],
'range_start' => (int)$row['epr_bib_start'],
'range_end' => (int)$row['epr_bib_finish'],
'no_bib' => (int)$row['no_bib'],
'orphan_cause' => $strCause,
'par_id' => (int)$row['par_id'],
'pec_id' => $intPecId,
'par_prenom' => trim($row['par_prenom'] ?? ''),
'par_nom' => trim($row['par_nom'] ?? ''),
];
}
return $out;
}
/** MSIN-4405 — Clé i18n bib pour la cause d'orphelin (alignée fxGetAnnulationCause). */
function fxBibAnomalyOrphanCauseKey($strCause) {
$strCause = trim((string)$strCause);
if (!in_array($strCause, ['annule', 'transfert'], true)) {
$strCause = 'annule';
}
return 'bib_v4_anomalies_orphan_' . $strCause;
}
/**
* MSIN-4379 — Inscriptions sans dossard : auto-assign échoué (séquences épuisées).
* Lit inscriptions_evt_erreur (type bib_auto_miss), purge les lignes déjà corrigées.
* @return array>
*/
function fxBibAnomalyAutoMissBibs($int_eve_id, $strLangue = 'fr') {
global $objDatabase;
$int_eve_id = (int)$int_eve_id;
if ($int_eve_id <= 0 || !fxEvtErreurTableReady()) {
return [];
}
$sqlBibNumP = fxBibSqlNoBibUnsigned('p.no_bib');
$sqlPurge = "
UPDATE inscriptions_evt_erreur e
INNER JOIN resultats_participants p
ON p.par_id = e.par_id
AND p.epr_id = e.epr_id
SET e.evt_err_statut = 'resolu',
e.evt_err_resolved = NOW()
WHERE e.eve_id = $int_eve_id
AND e.evt_err_type = 'bib_auto_miss'
AND e.evt_err_statut = 'ouvert'
AND (
p.is_cancelled = 1
OR $sqlBibNumP > 0
)
";
$objDatabase->fxQuery($sqlPurge);
$sql = "
SELECT
e.evt_err_id,
e.eve_id,
e.epr_id,
e.par_id,
e.pec_id,
e.no_commande,
e.no_panier,
e.com_id,
e.evt_err_created,
p.par_prenom,
p.par_nom,
ep.epr_nom_fr,
ep.epr_nom_en,
ep.epr_type_fr,
ep.epr_type_en,
ep.epr_categorie_fr,
ep.epr_categorie_en,
ep.epr_actif
FROM inscriptions_evt_erreur e
INNER JOIN resultats_participants p
ON p.par_id = e.par_id
AND p.epr_id = e.epr_id
INNER JOIN inscriptions_epreuves ep
ON ep.epr_id = e.epr_id
WHERE e.eve_id = $int_eve_id
AND e.evt_err_type = 'bib_auto_miss'
AND e.evt_err_statut = 'ouvert'
AND p.is_cancelled = 0
AND ($sqlBibNumP = 0 OR p.no_bib IS NULL OR p.no_bib = '' OR p.no_bib = '0')
ORDER BY e.evt_err_created DESC, e.epr_id, p.par_nom, p.par_prenom
";
$rows = $objDatabase->fxGetResults($sql);
if (!is_array($rows) || empty($rows)) {
return [];
}
$items = [];
foreach ($rows as $row) {
$items[] = [
'evt_err_id' => (int)$row['evt_err_id'],
'epr_id' => (int)$row['epr_id'],
'epr_label' => fxBibAnomalyEprLabel($row, $strLangue),
'par_id' => (int)$row['par_id'],
'par_prenom' => trim($row['par_prenom'] ?? ''),
'par_nom' => trim($row['par_nom'] ?? ''),
'no_commande' => trim($row['no_commande'] ?? ''),
'evt_err_created' => trim($row['evt_err_created'] ?? ''),
];
}
return $items;
}
/**
* MSIN-4379 — Dossards assignés hors de toute séquence configurée pour l'épreuve.
* Couvre la saisie manuelle (fiche coureur) ou tout assignement ne passant pas par les plages.
* Inclut les épreuves sans aucune séquence (dossards uniques seulement — les doublons vont dans dupes).
*
* @return array>
*/
function fxBibAnomalyOutOfRangeBibs($int_eve_id, $strLangue = 'fr') {
global $objDatabase;
$int_eve_id = (int)$int_eve_id;
if ($int_eve_id <= 0) {
return [];
}
$sqlBibNumP = fxBibSqlNoBibUnsigned('p.no_bib');
$sql = "
SELECT
p.par_id,
p.pec_id,
p.par_prenom,
p.par_nom,
p.epr_id,
$sqlBibNumP AS no_bib,
e.epr_nom_fr,
e.epr_nom_en,
e.epr_type_fr,
e.epr_type_en,
e.epr_categorie_fr,
e.epr_categorie_en,
e.epr_actif
FROM resultats_participants p
INNER JOIN inscriptions_epreuves e ON e.epr_id = p.epr_id
WHERE e.eve_id = $int_eve_id
AND p.is_cancelled = 0
AND $sqlBibNumP > 0
AND (
(
" . fxBibSqlEpreuveHasBibRanges('p.epr_id') . "
AND NOT EXISTS (
SELECT 1
FROM inscriptions_epreuves_bib b
WHERE b.epr_id = p.epr_id
AND b.epr_bib_start IS NOT NULL
AND b.epr_bib_finish IS NOT NULL
AND $sqlBibNumP BETWEEN b.epr_bib_start AND b.epr_bib_finish
)
)
OR (
NOT " . fxBibSqlEpreuveHasBibRanges('p.epr_id') . "
AND NOT " . fxBibSqlIsBibDuplicateAnomaly('p.epr_id', $sqlBibNumP) . "
)
)
ORDER BY p.epr_id, $sqlBibNumP, p.par_nom, p.par_prenom
";
$rows = $objDatabase->fxGetResults($sql);
if (!is_array($rows) || empty($rows)) {
return [];
}
$items = [];
foreach ($rows as $row) {
$items[] = [
'epr_id' => (int)$row['epr_id'],
'epr_label' => fxBibAnomalyEprLabel($row, $strLangue),
'par_id' => (int)$row['par_id'],
'pec_id' => (int)$row['pec_id'],
'par_prenom' => trim($row['par_prenom'] ?? ''),
'par_nom' => trim($row['par_nom'] ?? ''),
'no_bib' => (int)$row['no_bib'],
];
}
return $items;
}
/** MSIN-4379 — Agrège toutes les anomalies dossards pour un événement. */
function fxBibCollectAnomalies($int_eve_id, $strLangue = 'fr') {
return [
'dupes' => fxBibAnomalyDuplicateBibs($int_eve_id, $strLangue),
'inter_epr_dupes' => fxBibAnomalyInterEprDuplicateBibs($int_eve_id, $strLangue),
'out_of_range' => fxBibAnomalyOutOfRangeBibs($int_eve_id, $strLangue),
'orphans' => fxBibAnomalyOrphanBibs($int_eve_id, $strLangue),
'auto_miss' => fxBibAnomalyAutoMissBibs($int_eve_id, $strLangue),
];
}
function fxBibAnomalyTotalCount(array $tabAnomalies) {
$intTotal = 0;
foreach (['dupes', 'inter_epr_dupes', 'out_of_range', 'orphans', 'auto_miss'] as $strKey) {
if (!empty($tabAnomalies[$strKey]) && is_array($tabAnomalies[$strKey])) {
$intTotal += count($tabAnomalies[$strKey]);
}
}
return $intTotal;
}
/** MSIN-4424 — Corps du panneau configuration globale (réglages événement). */
function renderBibEventConfigPanelContent($int_eve_id) {
$int_eve_id = (int)$int_eve_id;
$blnAllow = fxBibEventAllowsInterEprDuplicates($int_eve_id);
ob_start();
?>
'
. fxBibEsc($strLabel)
. '';
}
/** MSIN-4424 — Panneau repliable : configuration globale assignation dossards (événement). */
function renderBibEventConfigPanel($int_eve_id, $strLangue = 'fr') {
$int_eve_id = (int)$int_eve_id;
$blnAllow = fxBibEventAllowsInterEprDuplicates($int_eve_id);
ob_start();
?>
, epreuves: array>}
*/
function fxBibCollectEventQtySummary($int_eve_id, $strLangue = 'fr') {
global $objDatabase;
$int_eve_id = (int)$int_eve_id;
$tabTotals = [
'a_assigner' => 0,
'bib_restant' => 0,
'orphelins' => 0,
'total' => 0,
'avec_bib' => 0,
'sans_bib' => 0,
'places_dispo' => 0,
];
$tabEpreuvesRows = [];
if ($int_eve_id <= 0) {
return ['totals' => $tabTotals, 'epreuves' => $tabEpreuvesRows];
}
$sqlEpreuves = "
SELECT *
FROM inscriptions_epreuves
WHERE eve_id = $int_eve_id
AND epr_actif = 1
ORDER BY epr_id
";
$tabEpreuves = $objDatabase->fxGetResults($sqlEpreuves);
if (!is_array($tabEpreuves)) {
$tabEpreuves = [];
}
$tabOrphans = fxBibAnomalyOrphanBibs($int_eve_id, $strLangue);
$tabOrphansByEpr = [];
foreach ($tabOrphans as $item) {
$intEprId = (int)($item['epr_id'] ?? 0);
if ($intEprId > 0) {
$tabOrphansByEpr[$intEprId] = ($tabOrphansByEpr[$intEprId] ?? 0) + 1;
}
}
foreach ($tabEpreuves as $epr) {
$epr_id = (int)$epr['epr_id'];
$infoBib = fxInfosBibEpreuve($epr_id);
$arrQte = fxGetQuantites($epr_id);
$intBibRestant = 0;
$tabRanges = fxInfosBibRange($epr_id, 0, false);
if (is_array($tabRanges)) {
foreach ($tabRanges as $range) {
if (is_array($range)) {
$intBibRestant += fxBibRangeDispoFromRow($range);
}
}
}
$tabRow = [
'epr_id' => $epr_id,
'epr_label' => fxBibAnomalyEprLabel($epr, $strLangue),
'total' => (int)($infoBib['total'] ?? 0),
'avec_bib' => (int)($infoBib['avec_bib'] ?? 0),
'sans_bib' => (int)($infoBib['sans_bib'] ?? 0),
'a_assigner' => (int)($infoBib['a_assigner'] ?? 0),
'bib_restant' => $intBibRestant,
'orphelins' => (int)($tabOrphansByEpr[$epr_id] ?? 0),
'places_dispo' => (int)($arrQte['qte_restante'] ?? 0),
];
$tabEpreuvesRows[] = $tabRow;
$tabTotals['a_assigner'] += $tabRow['a_assigner'];
$tabTotals['bib_restant'] += $tabRow['bib_restant'];
$tabTotals['total'] += $tabRow['total'];
$tabTotals['avec_bib'] += $tabRow['avec_bib'];
$tabTotals['sans_bib'] += $tabRow['sans_bib'];
$tabTotals['places_dispo'] += $tabRow['places_dispo'];
}
$tabTotals['orphelins'] = count($tabOrphans);
return ['totals' => $tabTotals, 'epreuves' => $tabEpreuvesRows];
}
/** MSIN-4424 — Coquille sommaire quantités (détail chargé à la première ouverture). */
function renderBibQtySummaryPanelShell($int_eve_id, $strLangue = 'fr') {
global $vDomaine;
$int_eve_id = (int)$int_eve_id;
$strWait = fxBibTexte('bib_v4_js_loader_wait', 0);
if ($strWait === '' || $strWait === 'bib_v4_js_loader_wait') {
$strWait = ($strLangue === 'en') ? 'Loading...' : 'Chargement...';
}
$strRunnerSrc = $vDomaine . '/images/ms1-runner-loader.gif?v=' . _VERSION_CODE;
ob_start();
?>
0;
$blnHasOrphans = (int)($tabTotals['orphelins'] ?? 0) > 0;
ob_start();
?>
$int_pec_id,
'lng' => $strLangue,
'inscr_return' => $strReturn,
]
);
}
/** MSIN-4436 — Lien « voir l'inscription » (gestion inscriptions v2). */
function fxBibAnomalyRenderInscrLink($int_eve_id, $int_pec_id, $strLangue = 'fr') {
$strUrl = fxBibAnomalyInscrGestionUrl($int_eve_id, $int_pec_id, $strLangue);
if ($strUrl === '') {
return '';
}
$strLabel = fxBibTexte('bib_v4_anomalies_view_inscription', 0);
if ($strLabel === '' || $strLabel === 'bib_v4_anomalies_view_inscription') {
$strLabel = ($strLangue === 'en') ? 'View registration' : "Voir l'inscription";
}
return ''
. fxBibEsc($strLabel) . ' ';
}
/**
* MSIN-4436 — Coquille anomalies au chargement page (détail via AJAX).
* Évite 4 requêtes lourdes avant le premier affichage des épreuves.
*/
function renderBibAnomaliesPanelShell($int_eve_id, $strLangue = 'fr') {
global $vDomaine;
$int_eve_id = (int)$int_eve_id;
$strWait = fxBibTexte('bib_v4_js_loader_wait', 0);
if ($strWait === '' || $strWait === 'bib_v4_js_loader_wait') {
$strWait = ($strLangue === 'en') ? 'Loading...' : 'Chargement...';
}
$strRunnerSrc = $vDomaine . '/images/ms1-runner-loader.gif?v=' . _VERSION_CODE;
ob_start();
?>
0;
ob_start();
?>
fxGetVar($sql) > 0;
}
/** MSIN-4379 — Refuse l'activation auto tant qu'il reste des inscriptions sans dossard. */
function fxBibAssertAllBibsAssignedForAuto($epr_id) {
$info = fxInfosBibEpreuve(intval($epr_id));
$nbPending = (int)($info['a_assigner'] ?? 0);
if ($nbPending > 0) {
return [
'success' => false,
'message' => fxBibMsg('bib_v4_ajax_auto_pending_bibs', $nbPending),
];
}
return ['success' => true];
}
/**
* MSIN-4379 — Étape 2
* Enregistre la config auto : remet toutes les séquences à 0, puis marque
* epr_bib_auto = 1 sur les epr_bib_id choisis. Si $active = false, tout désactive.
* Prochain tour : étape 6 lira ces séquences pour fxAssignAutoBibForParticipant().
*/
function fxSaveBibAutoConfig($epr_id, $ranges, $active = true) {
global $objDatabase;
$epr_id = intval($epr_id);
$active = (bool)$active;
if ($epr_id <= 0) {
return ['success' => false, 'message' => fxBibMsg('bib_v4_ajax_epr_invalid')];
}
if (fxBibProductionEpreuveIsLocked($epr_id)) {
return ['success' => false, 'message' => fxBibMsg('bib_v5_production_locked_error')];
}
$objDatabase->fxQuery("
UPDATE inscriptions_epreuves_bib
SET epr_bib_auto = 0
WHERE epr_id = $epr_id
");
if (!$active) {
return ['success' => true, 'auto_active' => false];
}
$pendingCheck = fxBibAssertAllBibsAssignedForAuto($epr_id);
if (!$pendingCheck['success']) {
return $pendingCheck;
}
if (empty($ranges) || !is_array($ranges)) {
return ['success' => false, 'message' => fxBibMsg('bib_v4_ajax_no_seq_selected')];
}
$ids = array_values(array_filter(array_map('intval', $ranges)));
if (empty($ids)) {
return ['success' => false, 'message' => fxBibMsg('bib_v4_ajax_no_seq_selected')];
}
$strIds = implode(',', $ids);
$sqlCheck = "
SELECT COUNT(*)
FROM inscriptions_epreuves_bib
WHERE epr_id = $epr_id
AND epr_bib_id IN ($strIds)
";
$nbValid = (int)$objDatabase->fxGetVar($sqlCheck);
if ($nbValid !== count($ids)) {
return ['success' => false, 'message' => fxBibMsg('bib_v4_ajax_seq_invalid')];
}
foreach ($ids as $bibId) {
if (!fxBibIsRangeAvailableForAuto($epr_id, $bibId)) {
return ['success' => false, 'message' => fxBibMsg('bib_v4_ajax_auto_seq_full')];
}
}
$lockCheck = fxBibAssertRangesUnlocked($epr_id, $ids);
if (!$lockCheck['success']) {
return $lockCheck;
}
$objDatabase->fxQuery("
UPDATE inscriptions_epreuves_bib
SET epr_bib_auto = 1
WHERE epr_id = $epr_id
AND epr_bib_id IN ($strIds)
");
return ['success' => true, 'auto_active' => true];
}
/**
* MSIN-4379 — Étape 6
* Liste des epr_bib_id marqués epr_bib_auto = 1 pour une épreuve.
*/
function fxGetAutoBibRangeIds($epr_id) {
global $objDatabase;
$epr_id = intval($epr_id);
if ($epr_id <= 0 || !fxIsBibAutoActive($epr_id)) {
return [];
}
$sql = "
SELECT epr_bib_id
FROM inscriptions_epreuves_bib
WHERE epr_id = $epr_id
AND epr_bib_auto = 1
AND epr_bib_locked = 0
ORDER BY epr_bib_start
";
$rows = $objDatabase->fxGetResults($sql);
$ids = [];
if (is_array($rows)) {
foreach ($rows as $r) {
$id = (int)($r['epr_bib_id'] ?? 0);
if ($id > 0) {
$ids[] = $id;
}
}
}
return $ids;
}
/**
* MSIN-4379 — Étape 6
* Charge un participant resultats pour l'assignation auto (même jointures que le batch).
*/
function fxLoadParticipantForAutoBib($epr_id, $par_id) {
global $objDatabase;
$epr_id = intval($epr_id);
$par_id = intval($par_id);
if ($epr_id <= 0 || $par_id <= 0) {
return null;
}
$sql = "
SELECT
p.*,
p.pec_id,
c.pec_id_original,
c.pec_nom_equipe,
c.no_equipe
FROM resultats_participants p
LEFT JOIN resultats_epreuves_commandees c
ON c.pec_id_original = p.pec_id
AND c.epr_id = p.epr_id
WHERE p.epr_id = $epr_id
AND p.par_id = $par_id
AND p.is_cancelled = 0
LIMIT 1
";
return $objDatabase->fxGetRow($sql);
}
/**
* MSIN-4379 — Étape 6 / MSIN-4455
* Assigne un dossard à un participant à l'achat (pools epr_bib_auto = 1).
* Même chemin anti-doublon que le batch : fxLoadUsedBibsForBatch + fxTryAssignNextBibForParticipant.
*/
function fxAssignAutoBibForParticipant($epr_id, $par_id) {
global $objDatabase;
$epr_id = intval($epr_id);
$par_id = intval($par_id);
if ($epr_id <= 0 || $par_id <= 0) {
return ['success' => false, 'message' => 'paramètres invalides'];
}
if (!fxIsBibAutoActive($epr_id)) {
return ['success' => false, 'skipped' => true, 'message' => 'auto inactif'];
}
$tabRanges = fxGetRangesForBatchAssign($epr_id, fxGetAutoBibRangeIds($epr_id));
if (empty($tabRanges)) {
return ['success' => false, 'message' => 'aucune plage auto'];
}
$p = fxLoadParticipantForAutoBib($epr_id, $par_id);
if (!$p) {
return ['success' => false, 'message' => 'participant introuvable'];
}
if (in_array((int)$p['rol_id'], [3, 4], true)) {
return ['success' => false, 'skipped' => true, 'message' => 'rôle exclu'];
}
$currentBib = trim((string)($p['no_bib'] ?? ''));
if ($currentBib !== '' && $currentBib !== '0') {
return [
'success' => true,
'skipped' => true,
'no_bib' => (int)$currentBib,
];
}
$sqlEpreuve = "
SELECT epr_equipe, epr_bib_team_mode
FROM inscriptions_epreuves
WHERE epr_id = $epr_id
LIMIT 1
";
$tabEpreuve = $objDatabase->fxGetRow($sqlEpreuve);
$isTeamEvent = $tabEpreuve && (int)$tabEpreuve['epr_equipe'] === 1;
$teamMode = (int)($tabEpreuve['epr_bib_team_mode'] ?? 1);
if ($teamMode <= 0) {
$teamMode = 1;
}
$teamKey = fxGetBatchTeamKey($p);
$foundBib = null;
$teamNumber = 0;
// Mode équipe 3 : reprendre le dossard déjà posé sur un coéquipier.
if ($isTeamEvent && $teamMode === 3 && $teamKey > 0) {
$existingBib = fxGetExistingTeamBibInDb($epr_id, $teamKey);
if ($existingBib !== null && (int)$existingBib > 0) {
$foundBib = (int)$existingBib;
$teamNumber = $foundBib;
if (fxApplyBatchParticipantBib($epr_id, $par_id, $foundBib) <= 0) {
return ['success' => false, 'message' => 'assignation équipe impossible'];
}
}
}
// MSIN-4455 — Charger les numéros déjà pris + relecture BD avant UPDATE (comme le batch GO).
if ($foundBib === null) {
$usedBib = fxLoadUsedBibsForBatch($epr_id);
$findTeamMode = $isTeamEvent ? $teamMode : 1;
$foundBib = fxTryAssignNextBibForParticipant(
$epr_id,
$par_id,
$tabRanges,
'execute',
$usedBib,
$findTeamMode
);
}
if ($foundBib === null) {
if (function_exists('fxcreer_log')) {
fxcreer_log('MSIN-4455: aucun dossard libre (epr_id=' . $epr_id . ', par_id=' . $par_id . ')');
}
if ($p && function_exists('fxEvtErreurOuvrir')) {
fxEvtErreurOuvrir('bib_auto_miss', [
'eve_id' => (int)($p['eve_id'] ?? 0),
'epr_id' => $epr_id,
'par_id' => $par_id,
'pec_id' => (int)($p['pec_id'] ?? 0),
'no_commande' => trim((string)($p['no_commande'] ?? '')),
'no_panier' => trim((string)($p['no_panier'] ?? '')),
'com_id' => (int)($p['com_id'] ?? 0),
]);
}
return ['success' => false, 'message' => 'aucun dossard disponible'];
}
if ($isTeamEvent && $teamKey > 0) {
$updatedTeams = [];
if ($teamMode === 3) {
fxApplyBatchTeamNumber($epr_id, $teamKey, $foundBib, $updatedTeams);
} else {
$sqlEquipe = "
SELECT no_equipe
FROM resultats_epreuves_commandees
WHERE pec_id_original = $teamKey
AND epr_id = $epr_id
LIMIT 1
";
$teamNumber = (int)$objDatabase->fxGetVar($sqlEquipe);
if ($teamNumber <= 0) {
$sqlMaxTeam = "
SELECT MAX(CAST(no_equipe AS UNSIGNED))
FROM resultats_epreuves_commandees
WHERE epr_id = $epr_id
";
$teamNumber = (int)$objDatabase->fxGetVar($sqlMaxTeam) + 1;
}
fxApplyBatchTeamNumber($epr_id, $teamKey, $teamNumber, $updatedTeams);
}
}
return [
'success' => true,
'no_bib' => (int)$foundBib,
];
}
function fxInfosBibEpreuve($epr_id){
global $objDatabase;
static $memCache = [];
$epr_id = intval($epr_id);
if ($epr_id <= 0) {
return [
'total' => 0,
'avec_bib' => 0,
'sans_bib' => 0
];
}
if (isset($memCache[$epr_id])) {
return $memCache[$epr_id];
}
$sqlEpreuve = "
SELECT epr_equipe, epr_bib_team_mode
FROM inscriptions_epreuves
WHERE epr_id = $epr_id
LIMIT 1
";
$tabEpreuve = $objDatabase->fxGetRow($sqlEpreuve);
$blnTeamOneBib = $tabEpreuve
&& (int)$tabEpreuve['epr_equipe'] === 1
&& (int)($tabEpreuve['epr_bib_team_mode'] ?? 1) === 3;
if ($blnTeamOneBib) {
// MSIN-4432 — aligné sur fxGetQuantites / fxCountBatchAssignUnits : une équipe = une unité.
$sql = "
SELECT
COUNT(DISTINCT p.pec_id) AS total,
COUNT(DISTINCT CASE
WHEN p.no_bib IS NOT NULL AND p.no_bib > 0 THEN p.pec_id
ELSE NULL
END) AS avec_bib
FROM resultats_participants p
WHERE p.epr_id = $epr_id
AND p.is_cancelled = 0
AND p.pec_id > 0
";
$row = $objDatabase->fxGetRow($sql);
$intTotal = (int)($row['total'] ?? 0);
$intAvecBib = (int)($row['avec_bib'] ?? 0);
} else {
$sql = "
SELECT
COUNT(*) AS total,
SUM(CASE WHEN no_bib IS NOT NULL AND no_bib > 0 THEN 1 ELSE 0 END) AS avec_bib
FROM resultats_participants
WHERE epr_id = $epr_id
AND is_cancelled = 0
";
$row = $objDatabase->fxGetRow($sql);
$intTotal = (int)($row['total'] ?? 0);
$intAvecBib = (int)($row['avec_bib'] ?? 0);
}
$info = [
'total' => $intTotal,
'avec_bib' => $intAvecBib,
'sans_bib' => max(0, $intTotal - $intAvecBib),
'a_assigner' => fxCountBatchAssignUnits($epr_id)
];
if ($tabEpreuve && (int)$tabEpreuve['epr_equipe'] === 1) {
$info['nb_equipes'] = fxBibCountEquipes($epr_id);
}
$memCache[$epr_id] = $info;
return $info;
}
function renderBibRanges($tabBibRanges, $epr_id = 0, $mode = 'assign') {
//print_rsl($tabBibRanges);
if (!is_array($tabBibRanges)) {
$tabBibRanges = [];
}
if ((int)$epr_id <= 0 && !empty($tabBibRanges[0]['epr_id'])) {
$epr_id = (int)$tabBibRanges[0]['epr_id'];
}
$blnProductionLocked = fxBibProductionEpreuveIsLocked((int)$epr_id);
ob_start();
?>
0) { ?>
0 && !empty($range['liste_trous'])) { ?>
0 && !empty($range['liste_doublons'])) { ?>
' . fxBibTexteTrad('bib_v4_view_range_not_found', 0) . '
';
}
$start = (int)$range['epr_bib_start'];
$end = (int)$range['epr_bib_finish'];
}
// =====================
// 2. GET EPREUVE
// =====================
$sqlEpreuve = "
SELECT *
FROM inscriptions_epreuves
WHERE epr_id = " . intval($epr_id);
$tabEpreuve = $objDatabase->fxGetRow($sqlEpreuve);
if (!$tabEpreuve) {
return '' . fxBibTexteTrad('bib_v4_view_epreuve_not_found', 0) . '
';
}
// =====================
// 3. GET PARTICIPANTS (DB ou SIMULATION)
// =====================
if (!empty($data)) {
$tabParticipants = $data;
} else {
// DB
// 👉 mode normal (DB)
$sqlBibNumP = fxBibSqlNoBibUnsigned('p.no_bib');
$strWhereView = "p.epr_id = " . intval($epr_id);
if ($hasRange) {
$strWhereView .= " AND $sqlBibNumP > 0 AND $sqlBibNumP BETWEEN $start AND $end";
} else {
$strWhereView .= " AND (
(COALESCE(p.is_cancelled, 0) = 0 AND COALESCE(c.is_cancelled, 0) = 0)
OR $sqlBibNumP > 0
)";
}
$sqlParticipants = "
SELECT
p.*,
c.pec_nom_equipe,
c.no_equipe,
c.is_cancelled AS pec_is_cancelled
FROM resultats_participants p
LEFT JOIN resultats_epreuves_commandees c
ON c.pec_id_original = p.pec_id
AND c.epr_id = p.epr_id
WHERE $strWhereView
ORDER BY $sqlBibNumP, p.par_nom, p.par_prenom";
$tabParticipants = $objDatabase->fxGetResults($sqlParticipants);
}
ob_start();
?>
";
if ($tabEpreuve['epr_type_' . $strLangue] != '')
echo $tabEpreuve['epr_type_' . $strLangue];
echo " (" . $tabEpreuve['epr_id'] . ")";
?>
fxGetResults($sql);
if (!is_array($tabParticipants) || empty($tabParticipants)) {
return is_array($tabParticipants) ? $tabParticipants : [];
}
// MSIN-4456 — Filet : si tri principal = nom d'équipe, forcer le regroupement en PHP
// (dossards individuels comme 1 équipe = 1 dossard).
if (fxBibSortKeyIsTeamCriterion($strSort1)) {
$tabParticipants = fxBibSortParticipantsByTeamName($tabParticipants);
}
return $tabParticipants;
}
function fxGetRangesForBatchAssign($epr_id, $ranges) {
global $objDatabase;
// =====================
// VALIDATION
// =====================
$epr_id = intval($epr_id);
if ($epr_id <= 0 || empty($ranges) || !is_array($ranges)) {
return [];
}
// Nettoyage des IDs (sécurité)
$ids = array_map('intval', $ranges);
$ids = array_filter($ids);
if (empty($ids)) {
return [];
}
// =====================
// QUERY LÉGÈRE
// =====================
$strIds = implode(',', $ids);
$sql = "
SELECT
epr_bib_id,
epr_bib_start,
epr_bib_finish
FROM inscriptions_epreuves_bib
WHERE epr_id = $epr_id
AND epr_bib_id IN ($strIds)
AND epr_bib_start IS NOT NULL
AND epr_bib_finish IS NOT NULL
ORDER BY epr_bib_start
";
$rows = $objDatabase->fxGetResults($sql);
// =====================
// NORMALISATION
// =====================
$out = [];
if (is_array($rows)) {
foreach ($rows as $r) {
$start = (int)$r['epr_bib_start'];
$end = (int)$r['epr_bib_finish'];
// sécurité
if ($start > 0 && $end >= $start) {
$out[] = [
'id' => (int)$r['epr_bib_id'],
'start' => $start,
'end' => $end
];
}
}
}
return $out;
}
function fxGetNextAvailableBib($epr_id, $tabRanges) {
global $objDatabase;
$epr_id = intval($epr_id);
$sqlBibNum = fxBibSqlNoBibUnsigned('no_bib');
if ($epr_id <= 0 || empty($tabRanges)) {
return null;
}
// =====================
// PARCOURIR LES RANGES
// =====================
foreach ($tabRanges as $range) {
$start = (int)$range['start'];
$end = (int)$range['end'];
if ($start <= 0 || $end < $start) {
continue;
}
// =====================
// CHERCHER UN BIB LIBRE DANS CE RANGE
// =====================
for ($i = $start; $i <= $end; $i++) {
$sql = "
SELECT COUNT(*)
FROM resultats_participants
WHERE epr_id = $epr_id
AND $sqlBibNum = $i
";
$exists = (int)$objDatabase->fxGetVar($sql);
// 👉 trouvé un BIB libre
if ($exists === 0) {
return $i;
}
}
}
// 👉 aucun BIB disponible
return null;
}
function fxLoadUsedBibsForBatch($epr_id) {
global $objDatabase;
$usedBib = [];
$sql = "
SELECT no_bib
FROM resultats_participants
WHERE epr_id = " . intval($epr_id) . "
AND no_bib IS NOT NULL
AND no_bib != ''
AND no_bib > 0
";
$rows = $objDatabase->fxGetResults($sql);
if (is_array($rows)) {
foreach ($rows as $r) {
$usedBib[(int)$r['no_bib']] = true;
}
}
return $usedBib;
}
/**
* Cherche le prochain dossard libre dans les séquences sélectionnées.
*
* Règle anti-doublon (mode execute / GO) :
* - solo ou équipe « dossards individuels » : un numéro = une personne (COUNT participants)
* - équipe « 1 équipe = 1 dossard » : un numéro = une équipe (COUNT DISTINCT pec_id)
* → plusieurs coéquipiers peuvent partager le même no_bib
*
* @param int $teamMode epr_bib_team_mode (1 = individuel, 3 = 1 équipe = 1 dossard)
*/
function fxFindNextBatchBib($epr_id, $tabRanges, $mode, &$usedBib, $teamMode = 1) {
$epr_id = intval($epr_id);
$teamMode = (int)$teamMode;
foreach ($tabRanges as $range) {
$start = (int)$range['start'];
$end = (int)$range['end'];
for ($i = $start; $i <= $end; $i++) {
if (!isset($usedBib[$i])) {
// MSIN-4433 — simulation : réserve en mémoire ; execute : réservation après UPDATE réussi.
if ($mode === 'simulation') {
$usedBib[$i] = true;
}
return $i;
}
}
}
return null;
}
/**
* MSIN-4433 — Vérifie en BD qu'un numéro est encore libre (assignation manuelle entre-temps).
*/
function fxBibIsNumberFreeInDb($epr_id, $intBib, $teamMode = 1) {
global $objDatabase;
$epr_id = (int)$epr_id;
$intBib = (int)$intBib;
$teamMode = (int)$teamMode;
$sqlBibNum = fxBibSqlNoBibUnsigned('no_bib');
if ($epr_id <= 0 || $intBib <= 0) {
return false;
}
if ($teamMode === 3) {
$sqlCheck = "
SELECT COUNT(DISTINCT pec_id)
FROM resultats_participants
WHERE epr_id = $epr_id
AND $sqlBibNum = $intBib
AND pec_id > 0
";
return (int)$objDatabase->fxGetVar($sqlCheck) === 0;
}
$sqlCheck = "
SELECT COUNT(*)
FROM resultats_participants
WHERE epr_id = $epr_id
AND $sqlBibNum = $intBib
";
return (int)$objDatabase->fxGetVar($sqlCheck) === 0;
}
/**
* MSIN-4433 — Prochain dossard libre pour un participant (1 UPDATE si execute).
* Relecture BD avant écriture : cohérence si changement manuel pendant le batch.
*
* @return int|null Numéro attribué, ou null si épuisé / participant déjà servi.
*/
function fxTryAssignNextBibForParticipant($epr_id, $par_id, $tabRanges, $mode, &$usedBib, $teamMode = 1) {
$epr_id = (int)$epr_id;
$par_id = (int)$par_id;
$teamMode = (int)$teamMode;
$intMaxAttempts = 50000;
for ($intAttempt = 0; $intAttempt < $intMaxAttempts; $intAttempt++) {
$candidate = fxFindNextBatchBib($epr_id, $tabRanges, $mode, $usedBib, $teamMode);
if ($candidate === null) {
return null;
}
if ($mode === 'execute') {
if (!fxBibIsNumberFreeInDb($epr_id, $candidate, $teamMode)) {
$usedBib[$candidate] = true;
continue;
}
$intAffected = fxApplyBatchParticipantBib($epr_id, $par_id, $candidate);
if ($intAffected <= 0) {
return null;
}
$usedBib[$candidate] = true;
return (int)$candidate;
}
return (int)$candidate;
}
return null;
}
/**
* Écrit le no_bib d'un participant (batch GO).
* Note : en mode « 1 équipe = 1 dossard », plusieurs lignes peuvent légitimement
* recevoir le même no_bib — ce n'est pas un doublon erroné.
*/
function fxApplyBatchParticipantBib($epr_id, $par_id, $foundBib) {
global $objDatabase;
// MSIN-4328 — par_maj pour que ChronoTrack détecte le changement de dossard
$sqlUpdate = "
UPDATE resultats_participants
SET no_bib = " . intval($foundBib) . ",
par_date_bib = IFNULL(par_date_bib, NOW()),
par_maj = '" . fxGetDateTime() . "'
WHERE par_id = " . intval($par_id) . "
AND is_cancelled = 0
AND (no_bib IS NULL OR no_bib = '' OR no_bib = 0)
";
$objDatabase->fxQuery($sqlUpdate);
$intAffected = (int)$objDatabase->affected_rows;
if ($intAffected > 0 && function_exists('fxEvtErreurResoudre')) {
fxEvtErreurResoudre('bib_auto_miss', (int)$epr_id, (int)$par_id);
}
return $intAffected;
}
function fxApplyBatchTeamNumber($epr_id, $teamKey, $teamNumber, &$updatedTeams) {
global $objDatabase;
if ($teamKey <= 0 || $teamNumber <= 0 || isset($updatedTeams[$teamKey])) {
return;
}
$sqlTeam = "
UPDATE resultats_epreuves_commandees
SET no_equipe = " . intval($teamNumber) . "
WHERE pec_id_original = " . intval($teamKey) . "
AND epr_id = " . intval($epr_id) . "
";
$objDatabase->fxQuery($sqlTeam);
$updatedTeams[$teamKey] = true;
}
function fxBuildBatchAssignmentRow($p, $foundBib, $teamNumber) {
return [
'rol_id' => $p['rol_id'],
'par_id' => (int)$p['par_id'],
'par_prenom' => $p['par_prenom'],
'par_nom' => $p['par_nom'],
'no_bib' => $foundBib,
'no_equipe' => $teamNumber,
'pec_nom_equipe' => $p['pec_nom_equipe'] ?? '',
];
}
function fxGetBatchTeamKey($p) {
return (int)($p['pec_id_original'] ?? $p['pec_id'] ?? 0);
}
/**
* MSIN-4433 — Mode équipe 3 : dossard déjà posé sur un coéquipier (batch par paquets).
*/
function fxGetExistingTeamBibInDb($epr_id, $teamKey) {
global $objDatabase;
$epr_id = (int)$epr_id;
$teamKey = (int)$teamKey;
$sqlBibNum = fxBibSqlNoBibUnsigned('no_bib');
if ($epr_id <= 0 || $teamKey <= 0) {
return null;
}
$sql = "
SELECT $sqlBibNum
FROM resultats_participants
WHERE epr_id = $epr_id
AND pec_id = $teamKey
AND is_cancelled = 0
AND $sqlBibNum > 0
LIMIT 1
";
$bib = (int)$objDatabase->fxGetVar($sql);
return $bib > 0 ? $bib : null;
}
function fxCountBatchAssignUnits($epr_id, $participants = null) {
global $objDatabase;
$epr_id = intval($epr_id);
if ($epr_id <= 0) {
return 0;
}
$sqlEpreuve = "
SELECT epr_equipe, epr_bib_team_mode
FROM inscriptions_epreuves
WHERE epr_id = $epr_id
LIMIT 1
";
$tabEpreuve = $objDatabase->fxGetRow($sqlEpreuve);
$countParticipants = function ($rows) {
return is_array($rows) ? count($rows) : 0;
};
if (!$tabEpreuve || (int)$tabEpreuve['epr_equipe'] !== 1) {
if (is_array($participants)) {
return $countParticipants($participants);
}
return (int)$objDatabase->fxGetVar("
SELECT COUNT(*)
FROM resultats_participants
WHERE epr_id = $epr_id
AND is_cancelled = 0
AND (no_bib IS NULL OR no_bib = '' OR no_bib = 0)
AND rol_id NOT IN (3, 4)
");
}
$teamMode = (int)($tabEpreuve['epr_bib_team_mode'] ?? 1);
if ($teamMode <= 0) {
$teamMode = 1;
}
if ($teamMode !== 3) {
if (is_array($participants)) {
return $countParticipants($participants);
}
return (int)$objDatabase->fxGetVar("
SELECT COUNT(*)
FROM resultats_participants
WHERE epr_id = $epr_id
AND is_cancelled = 0
AND (no_bib IS NULL OR no_bib = '' OR no_bib = 0)
AND rol_id NOT IN (3, 4)
");
}
if (is_array($participants)) {
$teams = [];
foreach ($participants as $p) {
$teamKey = fxGetBatchTeamKey($p);
if ($teamKey > 0) {
$teams[$teamKey] = true;
}
}
return count($teams);
}
return (int)$objDatabase->fxGetVar("
SELECT COUNT(DISTINCT p.pec_id)
FROM resultats_participants p
WHERE p.epr_id = $epr_id
AND p.is_cancelled = 0
AND (p.no_bib IS NULL OR p.no_bib = '' OR p.no_bib = 0)
AND p.rol_id NOT IN (3, 4)
AND p.pec_id > 0
");
}
function fxProcessBatchAssignmentsSolo($epr_id, $participants, $tabRanges, $mode = 'simulation') {
$assignments = [];
// MSIN-4433 — état réel rechargé à chaque paquet (execute) ou simulation.
$usedBib = fxLoadUsedBibsForBatch($epr_id);
foreach ($participants as $p) {
$foundBib = fxTryAssignNextBibForParticipant(
$epr_id,
(int)$p['par_id'],
$tabRanges,
$mode,
$usedBib,
1
);
if ($foundBib === null) {
break;
}
$assignments[] = fxBuildBatchAssignmentRow($p, $foundBib, 0);
}
return $assignments;
}
function fxProcessBatchAssignmentsEquipe($epr_id, $participants, $tabRanges, $mode, $teamMode) {
global $objDatabase;
$assignments = [];
$teamMap = [];
$updatedTeams = [];
$teamBibMap = [];
// MSIN-4477 — Poursuivre (dossards individuels) : reprendre après le max déjà attribué
// pour éviter les doublons no_equipe avec les équipes déjà numérotées.
$nextTeamNumber = 1;
if ($teamMode !== 3) {
$sqlMaxTeam = "
SELECT MAX(CAST(no_equipe AS UNSIGNED))
FROM resultats_epreuves_commandees
WHERE epr_id = " . intval($epr_id) . "
";
$nextTeamNumber = (int)$objDatabase->fxGetVar($sqlMaxTeam) + 1;
if ($nextTeamNumber < 1) {
$nextTeamNumber = 1;
}
}
$usedBib = fxLoadUsedBibsForBatch($epr_id);
foreach ($participants as $p) {
$par_id = (int)$p['par_id'];
$teamKey = fxGetBatchTeamKey($p);
$teamNumber = 0;
$foundBib = null;
if ($teamMode === 3 && $teamKey > 0) {
if (isset($teamBibMap[$teamKey])) {
$foundBib = $teamBibMap[$teamKey];
} else {
$foundBib = fxGetExistingTeamBibInDb($epr_id, $teamKey);
if ($foundBib !== null) {
$teamBibMap[$teamKey] = $foundBib;
}
}
}
if ($teamMode === 3 && $teamKey > 0 && $foundBib !== null) {
$teamNumber = $foundBib;
if ($mode === 'execute') {
$intAffected = fxApplyBatchParticipantBib($epr_id, $par_id, $foundBib);
if ($intAffected <= 0) {
continue;
}
fxApplyBatchTeamNumber($epr_id, $teamKey, $teamNumber, $updatedTeams);
}
} else {
if ($teamMode !== 3 && $teamKey > 0) {
if (!isset($teamMap[$teamKey])) {
// MSIN-4477 — Réutiliser le no_equipe déjà en BD (équipe partiellement assignée).
$existingTeamNo = (int)($p['no_equipe'] ?? 0);
if ($existingTeamNo > 0) {
$teamMap[$teamKey] = $existingTeamNo;
} else {
$teamMap[$teamKey] = $nextTeamNumber;
$nextTeamNumber++;
}
}
$teamNumber = $teamMap[$teamKey];
}
$foundBib = fxTryAssignNextBibForParticipant(
$epr_id,
$par_id,
$tabRanges,
$mode,
$usedBib,
$teamMode
);
if ($foundBib === null) {
break;
}
if ($teamMode === 3 && $teamKey > 0) {
$teamBibMap[$teamKey] = $foundBib;
$teamNumber = $foundBib;
}
if ($mode === 'execute') {
fxApplyBatchTeamNumber($epr_id, $teamKey, $teamNumber, $updatedTeams);
}
}
$assignments[] = fxBuildBatchAssignmentRow($p, $foundBib, $teamNumber);
}
return $assignments;
}
function fxProcessBatchAssignments($epr_id, $participants, $tabRanges, $mode = 'simulation') {
global $objDatabase;
if (empty($participants) || empty($tabRanges)) {
return [];
}
$epr_id = intval($epr_id);
$sqlEpreuve = "
SELECT epr_equipe, epr_bib_team_mode
FROM inscriptions_epreuves
WHERE epr_id = $epr_id
LIMIT 1
";
$tabEpreuve = $objDatabase->fxGetRow($sqlEpreuve);
// Épreuves solo : logique simple, inchangée (1 personne = 1 dossard)
if (!$tabEpreuve || (int)$tabEpreuve['epr_equipe'] !== 1) {
return fxProcessBatchAssignmentsSolo($epr_id, $participants, $tabRanges, $mode);
}
// Épreuves équipe uniquement — voir fxProcessBatchAssignmentsEquipe()
$teamMode = (int)($tabEpreuve['epr_bib_team_mode'] ?? 1);
if ($teamMode <= 0) {
$teamMode = 1;
}
return fxProcessBatchAssignmentsEquipe($epr_id, $participants, $tabRanges, $mode, $teamMode);
}
/** MSIN-4433 — Clé session pour accumuler les lignes assignées entre paquets AJAX. */
function fxBibBatchExecSessionKey($epr_id) {
return 'bib_batch_exec_' . (int)$epr_id;
}
/**
* MSIN-4433 — HTML résultat GO batch (batch_apply et dernier paquet).
*/
function fxBibBuildBatchApplyHtml($epr_id, array $exec, $intTotalInitial, $strLangue) {
$assigned = count($exec);
$total = max($assigned, (int)$intTotalInitial);
$remaining = max(0, $total - $assigned);
$status = 'success';
if ($assigned === 0) {
$status = 'error';
} elseif ($assigned < $total) {
$status = 'partial';
}
if ($assigned === 0) {
$info = fxBibMsg('bib_v4_ajax_assign_none');
} elseif ($assigned >= $total) {
$info = fxBibMsg('bib_v4_ajax_assign_full', $assigned);
} else {
$info = fxBibMsg('bib_v4_ajax_assign_partial', $assigned, $remaining);
}
return renderBibView(
$epr_id,
0,
$strLangue,
'execute',
$exec,
fxBibTexte('bib_v4_ajax_title_assign'),
$info,
$status
);
}
function fxBuildBatchSummaryFromRanges($tabRangesInfos, $participants, $epr_id = 0) {
$nbParticipants = fxCountBatchAssignUnits($epr_id, $participants);
$nbDispo = 0;
if (!empty($tabRangesInfos)) {
foreach ($tabRangesInfos as $r) {
$total = (int)($r['nb_total_range'] ?? 0);
$used = (int)($r['nb_utilises'] ?? 0);
$nbDispo += max(0, $total - $used);
}
}
$nbAssignable = min($nbParticipants, $nbDispo);
$nbManque = max(0, $nbParticipants - $nbDispo);
return [
'nb_dispo' => $nbDispo,
'nb_participants' => $nbParticipants,
'nb_assignable' => $nbAssignable,
'nb_manque' => $nbManque
];
}
/**
* MSIN-4453 — Efface no_equipe après réinitialisation des dossards (aligné sur le reset legacy).
* Sans $tabParticipants : toute l'épreuve. Avec liste (reset par séquences) : uniquement les équipes
* dont plus aucun membre actif n'a de dossard.
*/
function fxClearTeamNumbersAfterBibReset($epr_id, $tabParticipants = null) {
global $objDatabase;
$epr_id = (int)$epr_id;
if ($epr_id <= 0) {
return;
}
if ($tabParticipants === null) {
$sql = "
UPDATE resultats_epreuves_commandees
SET no_equipe = NULL
WHERE epr_id = $epr_id
";
$objDatabase->fxQuery($sql);
return;
}
$teamKeys = [];
foreach ($tabParticipants as $p) {
$teamKey = fxGetBatchTeamKey($p);
if ($teamKey > 0) {
$teamKeys[$teamKey] = true;
}
}
if (empty($teamKeys)) {
return;
}
$ids = implode(',', array_map('intval', array_keys($teamKeys)));
$sqlBibNum = fxBibSqlNoBibUnsigned('p.no_bib');
$sql = "
UPDATE resultats_epreuves_commandees c
SET c.no_equipe = NULL
WHERE c.epr_id = $epr_id
AND c.pec_id_original IN ($ids)
AND NOT EXISTS (
SELECT 1
FROM resultats_participants p
WHERE p.pec_id = c.pec_id_original
AND p.epr_id = c.epr_id
AND p.is_cancelled = 0
AND p.no_bib IS NOT NULL
AND $sqlBibNum > 0
)
";
$objDatabase->fxQuery($sql);
}
/** MSIN-4436 — Tous les participants avec dossard sur l'épreuve (y compris hors séquences). */
function fxGetParticipantsForEpreuveResetAll($epr_id) {
global $objDatabase;
$epr_id = (int)$epr_id;
if ($epr_id <= 0) {
return [];
}
$sqlBibNumP = fxBibSqlNoBibUnsigned('p.no_bib');
$sql = "
SELECT p.*
FROM resultats_participants p
WHERE p.epr_id = $epr_id
AND p.is_cancelled = 0
AND p.no_bib IS NOT NULL
AND p.no_bib > 0
ORDER BY $sqlBibNumP
";
return $objDatabase->fxGetResults($sql);
}
function fxGetParticipantsForBatchReset($epr_id, $ranges) {
global $objDatabase;
$epr_id = intval($epr_id);
if ($epr_id <= 0 || empty($ranges) || !is_array($ranges)) {
return [];
}
$ids = array_map('intval', $ranges);
$ids = array_filter($ids);
if (empty($ids)) {
return [];
}
$tabRanges = fxGetRangesForBatchAssign($epr_id, $ids);
if (empty($tabRanges)) {
return [];
}
$sqlBibNumP = fxBibSqlNoBibUnsigned('p.no_bib');
$where = [];
foreach ($tabRanges as $r) {
$start = (int)$r['start'];
$end = (int)$r['end'];
$where[] = "($sqlBibNumP BETWEEN $start AND $end)";
}
if (empty($where)) {
return [];
}
$sql = "
SELECT p.*
FROM resultats_participants p
WHERE p.epr_id = $epr_id
AND p.is_cancelled = 0
AND p.no_bib IS NOT NULL
AND p.no_bib > 0
AND (
" . implode(' OR ', $where) . "
)
ORDER BY $sqlBibNumP
";
return $objDatabase->fxGetResults($sql);
}
function fxResolveTeamBib(
$p,
&$teamBibMap,
$epr_id
) {
global $objDatabase;
$teamKey = (int)($p['pec_id'] ?? 0);
if ($teamKey <= 0) {
return null;
}
// =====================
// MÉMOIRE
// =====================
if (isset($teamBibMap[$teamKey])) {
return $teamBibMap[$teamKey];
}
// =====================
// DB EXISTANTE
// =====================
$sql = "
SELECT no_equipe
FROM resultats_epreuves_commandees
WHERE pec_id_original = $teamKey
AND epr_id = " . intval($epr_id) . "
LIMIT 1
";
$existingBib = (int)$objDatabase->fxGetVar($sql);
if ($existingBib > 0) {
$teamBibMap[$teamKey] = $existingBib;
return $existingBib;
}
return null;
}
// =============================================================================
// MSIN-4433 — Impression PDF distribution des dossards
// =============================================================================
/** MSIN-4433 / MSIN-4471 — Limite de colonnes questions (feuille bénévole lettre). */
function fxBibDistPrintMaxQuestions() {
return 3;
}
/** MSIN-4433 — Nom affiché du compte connecté (promoteur ou superadmin). */
function fxBibGetCurrentPromoteurDisplayName() {
if (!empty($_SESSION['usa_id']) && !empty($_SESSION['usa_info']) && is_array($_SESSION['usa_info'])) {
$str = trim((string)($_SESSION['usa_info']['com_prenom'] ?? '') . ' ' . (string)($_SESSION['usa_info']['com_nom'] ?? ''));
if ($str !== '') {
return $str;
}
}
if (!empty($_SESSION['com_info']) && is_array($_SESSION['com_info'])) {
$str = trim((string)($_SESSION['com_info']['com_prenom'] ?? '') . ' ' . (string)($_SESSION['com_info']['com_nom'] ?? ''));
if ($str !== '') {
return $str;
}
}
return trim((string)($_SESSION['com_prenom'] ?? '') . ' ' . (string)($_SESSION['com_nom'] ?? ''));
}
/** MSIN-4433 — Accès génération PDF (session promoteur + CSRF, pas de granularite v2 pour l'instant). */
function fxBibRequireDistPrintAccess() {
if (!fxBibRequirePromoteurSession()) {
http_response_code(403);
header('Content-Type: text/plain; charset=utf-8');
echo fxBibMsg('bib_v4_ajax_session_invalid');
exit;
}
$strToken = $_POST['csrf_token'] ?? $_REQUEST['csrf_token'] ?? '';
if (!fxBibValidateCsrf($strToken)) {
http_response_code(403);
header('Content-Type: text/plain; charset=utf-8');
echo fxBibMsg('bib_v4_ajax_unauthorized');
exit;
}
}
/** MSIN-4433 — Parse liste d'IDs questions depuis chaîne CSV. */
function fxBibParseDistPrintQueIds($strCsv) {
if ($strCsv === null || $strCsv === '') {
return [];
}
$out = [];
foreach (explode(',', (string)$strCsv) as $part) {
$intId = (int)trim($part);
if ($intId > 0 && !in_array($intId, $out, true)) {
$out[] = $intId;
}
}
return $out;
}
/** MSIN-4433 — Sérialise les IDs questions pour stockage. */
function fxBibDistPrintQueIdsToCsv(array $tabQueIds) {
$out = [];
foreach ($tabQueIds as $mixId) {
$intId = (int)$mixId;
if ($intId > 0 && !in_array($intId, $out, true)) {
$out[] = $intId;
}
}
return implode(',', $out);
}
/** MSIN-4433 — Libellé court sexe pour le PDF. */
function fxBibDistPrintSexeLabel($strSexe, $strLangue = 'fr') {
$strSexe = strtolower(trim((string)$strSexe));
if ($strLangue === 'en') {
$tab = ['f' => 'F', 'h' => 'M', 'n' => 'X', 'a' => 'O'];
} else {
$tab = ['f' => 'F', 'h' => 'H', 'n' => 'X', 'a' => 'A'];
}
return $tab[$strSexe] ?? strtoupper($strSexe);
}
/** MSIN-4433 — Date/heure affichée (pied de page, panneau). */
function fxBibFormatDistPrintDateTime($strWhen = '', $strLangue = 'fr') {
$ts = ($strWhen !== '') ? strtotime($strWhen) : time();
if ($ts === false) {
$ts = time();
}
if ($strLangue === 'en') {
return date('F j, Y, g:i a', $ts);
}
$tabMonths = [
1 => 'janvier', 2 => 'février', 3 => 'mars', 4 => 'avril',
5 => 'mai', 6 => 'juin', 7 => 'juillet', 8 => 'août',
9 => 'septembre', 10 => 'octobre', 11 => 'novembre', 12 => 'décembre',
];
$intDay = (int)date('j', $ts);
$intMonth = (int)date('n', $ts);
$intYear = (int)date('Y', $ts);
$strTime = date('H:i', $ts);
return $intDay . ' ' . ($tabMonths[$intMonth] ?? '') . ' ' . $intYear . ', ' . $strTime;
}
/** MSIN-4433 — Métadonnées dernière impression (événement). */
function fxBibGetDistPrintMeta($int_eve_id) {
global $objDatabase;
$int_eve_id = (int)$int_eve_id;
if ($int_eve_id <= 0) {
return ['at' => '', 'by' => '', 'com_id' => 0];
}
$row = $objDatabase->fxGetRow("
SELECT eve_bib_dist_print_at, eve_bib_dist_print_by, eve_bib_dist_print_com_id
FROM inscriptions_evenements
WHERE eve_id = $int_eve_id
LIMIT 1
");
if (!is_array($row)) {
return ['at' => '', 'by' => '', 'com_id' => 0];
}
return [
'at' => trim((string)($row['eve_bib_dist_print_at'] ?? '')),
'by' => trim((string)($row['eve_bib_dist_print_by'] ?? '')),
'com_id' => (int)($row['eve_bib_dist_print_com_id'] ?? 0),
];
}
/** MSIN-4433 — Persiste date / auteur de l'impression. */
function fxBibSaveDistPrintMeta($int_eve_id, $int_com_id, $str_by) {
global $objDatabase;
$int_eve_id = (int)$int_eve_id;
$int_com_id = (int)$int_com_id;
$str_by = trim((string)$str_by);
if ($int_eve_id <= 0) {
return;
}
$sql = "
UPDATE inscriptions_evenements
SET eve_bib_dist_print_at = '" . $objDatabase->fxEscape(fxGetDateTime()) . "',
eve_bib_dist_print_by = '" . $objDatabase->fxEscape($str_by) . "',
eve_bib_dist_print_com_id = $int_com_id
WHERE eve_id = $int_eve_id
LIMIT 1
";
$objDatabase->fxQuery($sql);
}
/**
* MSIN-4433 — Données panneau : épreuves, questions éligibles, sélection mémorisée.
* @return array{meta: array, epreuves: array>}
*/
function fxBibCollectDistPrintPanelData($int_eve_id, $strLangue = 'fr') {
global $objDatabase;
$int_eve_id = (int)$int_eve_id;
$tabOut = ['meta' => fxBibGetDistPrintMeta($int_eve_id), 'epreuves' => []];
if ($int_eve_id <= 0) {
return $tabOut;
}
$sqlEpreuves = "
SELECT *
FROM inscriptions_epreuves
WHERE eve_id = $int_eve_id
AND epr_actif = 1
ORDER BY epr_tri, epr_id
";
$tabEpreuves = $objDatabase->fxGetResults($sqlEpreuves);
if (!is_array($tabEpreuves)) {
return $tabOut;
}
foreach ($tabEpreuves as $epr) {
$epr_id = (int)($epr['epr_id'] ?? 0);
if ($epr_id <= 0) {
continue;
}
$tabQuestionOpts = fxBibGetQuestionSortOptions($epr_id, $int_eve_id, $strLangue);
$tabSelected = fxBibParseDistPrintQueIds($epr['ba_bib_dist_que_ids'] ?? '');
$tabValidIds = [];
foreach ($tabQuestionOpts as $opt) {
if (preg_match('/^que:(\d+)$/', (string)($opt['key'] ?? ''), $m)) {
$tabValidIds[] = (int)$m[1];
}
}
$tabSelected = array_values(array_intersect($tabSelected, $tabValidIds));
$tabOut['epreuves'][] = [
'epr_id' => $epr_id,
'epr_label' => fxBibAnomalyEprLabel($epr, $strLangue),
'questions' => $tabQuestionOpts,
'selected' => $tabSelected,
'avec_bib' => (int)(fxInfosBibEpreuve($epr_id)['avec_bib'] ?? 0),
];
}
return $tabOut;
}
/** MSIN-4433 — Parse sélections POST dist_print[epr_id][] = que_id. */
function fxBibParseDistPrintSelectionsFromPost(array $post) {
$tabRaw = $post['dist_print'] ?? [];
if (!is_array($tabRaw)) {
return [];
}
$out = [];
foreach ($tabRaw as $mixEprId => $mixQueIds) {
$epr_id = (int)$mixEprId;
if ($epr_id <= 0) {
continue;
}
if (!is_array($mixQueIds)) {
$mixQueIds = [$mixQueIds];
}
$tabIds = [];
foreach ($mixQueIds as $mixQueId) {
$intQueId = (int)$mixQueId;
if ($intQueId > 0 && !in_array($intQueId, $tabIds, true)) {
$tabIds[] = $intQueId;
}
}
$out[$epr_id] = $tabIds;
}
return $out;
}
/**
* MSIN-4433 — Sauvegarde les questions cochées par épreuve (à la génération PDF).
* @return array{success: bool, message?: string}
*/
function fxBibSaveDistPrintSelections($int_eve_id, array $tabSelections, $strLangue = 'fr') {
global $objDatabase;
$int_eve_id = (int)$int_eve_id;
if ($int_eve_id <= 0) {
return ['success' => false, 'message' => fxBibMsg('bib_v4_ajax_epr_invalid')];
}
$intMax = fxBibDistPrintMaxQuestions();
$tabPanel = fxBibCollectDistPrintPanelData($int_eve_id, $strLangue);
foreach ($tabPanel['epreuves'] as $tabEpr) {
$epr_id = (int)($tabEpr['epr_id'] ?? 0);
if ($epr_id <= 0) {
continue;
}
$tabValidIds = [];
foreach ($tabEpr['questions'] as $opt) {
if (preg_match('/^que:(\d+)$/', (string)($opt['key'] ?? ''), $m)) {
$tabValidIds[] = (int)$m[1];
}
}
$tabChosen = $tabSelections[$epr_id] ?? [];
if (!is_array($tabChosen)) {
$tabChosen = [];
}
$tabFiltered = [];
foreach ($tabChosen as $intQueId) {
$intQueId = (int)$intQueId;
if ($intQueId > 0 && in_array($intQueId, $tabValidIds, true)
&& !in_array($intQueId, $tabFiltered, true)) {
$tabFiltered[] = $intQueId;
}
}
if (count($tabFiltered) > $intMax) {
// MSIN-4471 — Max abaissé à 3 : garder les N premières plutôt que bloquer.
$tabFiltered = array_slice($tabFiltered, 0, $intMax);
}
$strCsv = fxBibDistPrintQueIdsToCsv($tabFiltered);
$sql = "
UPDATE inscriptions_epreuves
SET ba_bib_dist_que_ids = '" . $objDatabase->fxEscape($strCsv) . "'
WHERE epr_id = $epr_id
AND eve_id = $int_eve_id
LIMIT 1
";
$objDatabase->fxQuery($sql);
}
return ['success' => true];
}
/**
* MSIN-4433 / MSIN-4471 — Participants avec dossard (une ligne par no_bib).
* Tri fixe nom + prénom : les bénévoles cherchent par nom à la table.
* ($sort1 / $sort2 conservés pour compat signature ; ignorés.)
* @return array>
*/
function fxBibGetParticipantsForDistPrint($epr_id, $sort1, $sort2 = '', $strLangue = 'fr') {
global $objDatabase;
$epr_id = (int)$epr_id;
if ($epr_id <= 0) {
return [];
}
$sqlBibNumP = fxBibSqlNoBibUnsigned('p.no_bib');
// MSIN-4471 — Toujours alphabétique nom / prénom (pas le tri batch d'assignation).
$orderBy = 'TRIM(p.par_nom), TRIM(p.par_prenom), p.par_id ASC';
$sql = "
SELECT
p.par_id,
p.par_id_original,
p.pec_id,
p.no_bib,
p.par_nom,
p.par_prenom,
p.par_sexe
FROM resultats_participants p
LEFT JOIN resultats_epreuves_commandees c
ON c.pec_id_original = p.pec_id
AND c.epr_id = p.epr_id
WHERE p.epr_id = $epr_id
AND p.is_cancelled = 0
AND $sqlBibNumP > 0
AND p.rol_id NOT IN (3, 4)
ORDER BY $orderBy
";
$rows = $objDatabase->fxGetResults($sql);
if (!is_array($rows)) {
return [];
}
$tabSeen = [];
$tabOut = [];
foreach ($rows as $row) {
$strBibKey = (string)(int)($row['no_bib'] ?? 0);
if ($strBibKey === '0' || isset($tabSeen[$strBibKey])) {
continue;
}
$tabSeen[$strBibKey] = true;
$tabOut[] = $row;
}
return $tabOut;
}
/** MSIN-4433 — Clé de correspondance participant ↔ réponse question. */
function fxBibDistPrintAnswerKey(array $row) {
$intPecId = (int)($row['pec_id'] ?? 0);
$intParLookup = (int)($row['par_id_original'] ?? 0);
if ($intParLookup <= 0) {
$intParLookup = (int)($row['par_id'] ?? 0);
}
return $intParLookup . ':' . $intPecId;
}
/**
* MSIN-4433 — Réponses questions pour une liste de participants.
* resultats_questions.par_id = resultats_participants.par_id_original (legacy MS1).
* @return array> clé "par_lookup:pec_id" => [que_id => réponse]
*/
function fxBibGetDistPrintQuestionAnswers($epr_id, array $tabQueIds, array $tabParticipants, $strLangue = 'fr') {
global $objDatabase;
$epr_id = (int)$epr_id;
$tabQueIds = array_values(array_filter(array_map('intval', $tabQueIds)));
if ($epr_id <= 0 || empty($tabQueIds) || empty($tabParticipants)) {
return [];
}
$tabParIds = [];
foreach ($tabParticipants as $row) {
$intParId = (int)($row['par_id'] ?? 0);
if ($intParId > 0) {
$tabParIds[] = $intParId;
}
}
$tabParIds = array_values(array_unique($tabParIds));
if (empty($tabParIds)) {
return [];
}
$strCol = ($strLangue === 'en') ? 'que_choix_en' : 'que_choix_fr';
$strQueIds = implode(',', $tabQueIds);
$strParIds = implode(',', $tabParIds);
$sql = "
SELECT
p.par_id,
p.par_id_original,
p.pec_id,
rq.que_id,
TRIM(COALESCE(NULLIF(rq.$strCol, ''), NULLIF(rq.pqu_note, ''), NULLIF(rq.que_choix_fr, ''))) AS ans
FROM resultats_participants p
INNER JOIN resultats_questions rq
ON rq.pec_id = p.pec_id
AND rq.par_id = IF(p.par_id_original > 0, p.par_id_original, p.par_id)
WHERE p.epr_id = $epr_id
AND p.par_id IN ($strParIds)
AND rq.que_id IN ($strQueIds)
";
$rows = $objDatabase->fxGetResults($sql);
if (!is_array($rows)) {
return [];
}
$out = [];
foreach ($rows as $row) {
$strKey = fxBibDistPrintAnswerKey($row);
$intQueId = (int)($row['que_id'] ?? 0);
$out[$strKey][$intQueId] = trim((string)($row['ans'] ?? ''));
}
return $out;
}
/** MSIN-4433 — Tronque texte pour cellule PDF. */
function fxBibDistPrintTruncate($str, $intMax = 28) {
$str = trim((string)$str);
if ($str === '') {
return '';
}
if (function_exists('mb_strlen') && function_exists('mb_substr')) {
if (mb_strlen($str) <= $intMax) {
return $str;
}
return mb_substr($str, 0, max(1, $intMax - 1)) . '…';
}
if (strlen($str) <= $intMax) {
return $str;
}
return substr($str, 0, max(1, $intMax - 1)) . '…';
}
/** MSIN-4470 — Convertit l'UTF-8 vers l'encodage Windows-1252 attendu par les polices FPDF. */
function fxBibDistPrintPdfText($str) {
$str = (string)$str;
if (function_exists('iconv')) {
$strConverted = @iconv('UTF-8', 'Windows-1252//TRANSLIT', $str);
if ($strConverted !== false) {
return $strConverted;
}
}
return utf8_decode($str);
}
/** MSIN-4471 — Clés doc_page des 3 pages d'intro (ordre d'impression). */
function fxBibDistPrintIntroPageClefs() {
return array(
'bib_dist_print_reco',
'bib_dist_print_table',
'bib_dist_print_qr',
);
}
/** MSIN-4471 — Chemin absolu du logo MS1 (pied / bandeau PDF). */
function fxBibDistPrintMs1LogoPath() {
$strDocRoot = $_SERVER['DOCUMENT_ROOT'] ?? dirname(__DIR__);
$strPath = rtrim($strDocRoot, '/\\') . DIRECTORY_SEPARATOR . 'images' . DIRECTORY_SEPARATOR . 'logoms1inscription.png';
return is_file($strPath) ? $strPath : '';
}
/**
* MSIN-4471 — Texte brut d'un nœud DOM (espaces normalisés).
*/
function fxBibDistPrintDomPlainText($node) {
if (!$node) {
return '';
}
$str = $node->textContent ?? '';
$str = preg_replace('/\s+/u', ' ', $str);
return trim((string)$str);
}
/**
* MSIN-4471 — Écrit un fragment inline (texte + strong/em) en mode Write.
*/
function fxBibDistPrintWriteInline($pdf, $node, $fltLineH = 5, $fltFontSize = 10) {
if (!$node) {
return;
}
foreach ($node->childNodes as $child) {
if ($child->nodeType === XML_TEXT_NODE) {
$strText = preg_replace('/\s+/u', ' ', $child->nodeValue);
if ($strText !== null && $strText !== '') {
$pdf->SetFont('Arial', '', $fltFontSize);
$pdf->Write($fltLineH, fxBibDistPrintPdfText($strText));
}
continue;
}
if ($child->nodeType !== XML_ELEMENT_NODE) {
continue;
}
$strTag = strtolower($child->nodeName);
if ($strTag === 'br') {
$pdf->Ln($fltLineH);
continue;
}
if (in_array($strTag, array('strong', 'b'), true)) {
$strText = fxBibDistPrintDomPlainText($child);
if ($strText !== '') {
$pdf->SetFont('Arial', 'B', $fltFontSize);
$pdf->Write($fltLineH, fxBibDistPrintPdfText($strText));
$pdf->SetFont('Arial', '', $fltFontSize);
}
continue;
}
if (in_array($strTag, array('em', 'i'), true)) {
$strText = fxBibDistPrintDomPlainText($child);
if ($strText !== '') {
$pdf->SetFont('Arial', 'I', $fltFontSize);
$pdf->Write($fltLineH, fxBibDistPrintPdfText($strText));
$pdf->SetFont('Arial', '', $fltFontSize);
}
continue;
}
fxBibDistPrintWriteInline($pdf, $child, $fltLineH, $fltFontSize);
}
}
/**
* MSIN-4471 — Résout un src img vers un fichier sous images/doc/ uniquement.
* Accepte /images/doc/x.png, images/doc/x.png (refuse tout autre chemin).
*/
function fxBibDistPrintResolveDocImagePath($strSrc) {
$strSrc = trim((string)$strSrc);
if ($strSrc === '') {
return '';
}
$strSrc = str_replace('\\', '/', $strSrc);
$strSrc = preg_replace('#^https?://[^/]+#i', '', $strSrc);
$strSrc = ltrim($strSrc, '/');
if (strpos($strSrc, 'images/doc/') !== 0) {
return '';
}
$strRel = substr($strSrc, strlen('images/doc/'));
if ($strRel === '' || strpos($strRel, '..') !== false) {
return '';
}
$strDocRoot = $_SERVER['DOCUMENT_ROOT'] ?? dirname(__DIR__);
$strPath = rtrim($strDocRoot, '/\\') . DIRECTORY_SEPARATOR . 'images' . DIRECTORY_SEPARATOR . 'doc' . DIRECTORY_SEPARATOR
. str_replace('/', DIRECTORY_SEPARATOR, $strRel);
if (!is_file($strPath)) {
return '';
}
$strExt = strtolower(pathinfo($strPath, PATHINFO_EXTENSION));
if (!in_array($strExt, array('png', 'jpg', 'jpeg', 'gif'), true)) {
return '';
}
return $strPath;
}
/** MSIN-4471 — Insère une image doc (largeur max = page utile, ou $fltMaxWMm si fourni). */
function fxBibDistPrintWriteImage($pdf, $strPath, $fltMaxWMm = 0, $blnCenter = false) {
if ($strPath === '' || !is_file($strPath)) {
return;
}
$fltLeft = method_exists($pdf, 'GetLeftMargin') ? $pdf->GetLeftMargin() : 10;
$fltRight = method_exists($pdf, 'GetRightMargin') ? $pdf->GetRightMargin() : 10;
$fltBottom = method_exists($pdf, 'GetBreakMargin') ? $pdf->GetBreakMargin() : 14;
$fltPageMax = $pdf->GetPageWidth() - $fltLeft - $fltRight;
$fltMaxW = ($fltMaxWMm > 0) ? min($fltMaxWMm, $fltPageMax) : $fltPageMax;
$tabSize = @getimagesize($strPath);
if (!is_array($tabSize) || empty($tabSize[0]) || empty($tabSize[1])) {
return;
}
// FPDF se fie à l'extension : forcer le type réel (ex. JPEG nommé .png).
$strType = '';
$strMime = isset($tabSize['mime']) ? strtolower((string)$tabSize['mime']) : '';
if ($strMime === 'image/jpeg' || $strMime === 'image/jpg') {
$strType = 'JPG';
} elseif ($strMime === 'image/png') {
$strType = 'PNG';
} elseif ($strMime === 'image/gif') {
$strType = 'GIF';
} else {
return;
}
$fltW = $fltMaxW;
$fltNatW = ($tabSize[0] * 25.4) / 96;
if ($fltNatW > 0 && $fltNatW < $fltMaxW) {
$fltW = $fltNatW;
}
$fltH = $fltW * ($tabSize[1] / $tabSize[0]);
if ($pdf->GetY() + max(10, $fltH) > $pdf->GetPageHeight() - $fltBottom) {
$pdf->AddPage();
}
$fltX = $blnCenter ? (($pdf->GetPageWidth() - $fltW) / 2) : $pdf->GetX();
$pdf->Image($strPath, $fltX, $pdf->GetY(), $fltW, 0, $strType);
$pdf->Ln(max(8, $fltH + 3));
}
/**
* MSIN-4471 — Rendu flyer des pages intro (bandeau déjà dans Header).
* Structure attendue : lead puis blocs
+ (cartes numérotées).
* Si pas de h3 : repli sur fxBibDistPrintWriteHtml.
*/
function fxBibDistPrintWriteIntroFlyer($pdf, $strHtml) {
$strHtml = trim((string)$strHtml);
if ($strHtml === '') {
return;
}
if (!class_exists('DOMDocument', false)) {
fxBibDistPrintWriteHtml($pdf, $strHtml);
return;
}
$dom = new DOMDocument();
$blnPrev = libxml_use_internal_errors(true);
$dom->loadHTML(
'
' . $strHtml . '
',
LIBXML_HTML_NODEFDTD
);
libxml_clear_errors();
libxml_use_internal_errors($blnPrev);
$root = $dom->getElementById('ms1-bib-dist-root');
if (!$root) {
foreach ($dom->getElementsByTagName('div') as $el) {
if ($el->getAttribute('id') === 'ms1-bib-dist-root') {
$root = $el;
break;
}
}
}
if (!$root) {
fxBibDistPrintWriteHtml($pdf, $strHtml);
return;
}
// Déballer si présent.
$article = null;
foreach ($root->childNodes as $child) {
if ($child->nodeType === XML_ELEMENT_NODE && strtolower($child->nodeName) === 'article') {
$article = $child;
break;
}
}
$scope = $article ?: $root;
$tabBlocks = array();
foreach ($scope->childNodes as $child) {
if ($child->nodeType !== XML_ELEMENT_NODE) {
continue;
}
$strTag = strtolower($child->nodeName);
if (in_array($strTag, array('p', 'h2', 'h3', 'h4', 'ul', 'ol', 'blockquote', 'img'), true)) {
$tabBlocks[] = $child;
}
}
$blnHasH3 = false;
foreach ($tabBlocks as $el) {
if (strtolower($el->nodeName) === 'h3') {
$blnHasH3 = true;
break;
}
}
if (!$blnHasH3) {
fxBibDistPrintWriteHtml($pdf, $strHtml);
return;
}
$fltLeft = method_exists($pdf, 'GetLeftMargin') ? $pdf->GetLeftMargin() : 12;
$fltRight = method_exists($pdf, 'GetRightMargin') ? $pdf->GetRightMargin() : 12;
$fltBottom = method_exists($pdf, 'GetBreakMargin') ? $pdf->GetBreakMargin() : 18;
$fltPageW = $pdf->GetPageWidth();
$fltContentW = $fltPageW - $fltLeft - $fltRight;
$intTip = 0;
$blnLeadDone = false;
$i = 0;
$intN = count($tabBlocks);
while ($i < $intN) {
$el = $tabBlocks[$i];
$strTag = strtolower($el->nodeName);
// Premier = encadré d'intro (lead).
if ($strTag === 'p' && !$blnLeadDone) {
$blnLeadDone = true;
$strLead = fxBibDistPrintDomPlainText($el);
$fltInnerW = $fltContentW - 10;
$pdf->SetFont('Arial', 'I', 10);
$intLines = max(2, (int)ceil($pdf->GetStringWidth(fxBibDistPrintPdfText($strLead)) / max(1, $fltInnerW)) + 1);
$fltBoxH = max(12, 4 + ($intLines * 4.5) + 3);
if ($pdf->GetY() + $fltBoxH > $pdf->GetPageHeight() - $fltBottom) {
$pdf->AddPage();
}
$fltY0 = $pdf->GetY();
$pdf->SetFillColor(232, 240, 254);
$pdf->Rect($fltLeft, $fltY0, $fltContentW, $fltBoxH, 'F');
$pdf->SetFillColor(47, 95, 208);
$pdf->Rect($fltLeft, $fltY0, 2.5, $fltBoxH, 'F');
$pdf->SetXY($fltLeft + 6, $fltY0 + 3.5);
$pdf->SetFont('Arial', 'I', 10);
$pdf->SetTextColor(40, 55, 90);
$pdf->MultiCell($fltInnerW, 4.5, fxBibDistPrintPdfText($strLead), 0, 'L');
$pdf->SetY($fltY0 + $fltBoxH + 5);
$pdf->SetTextColor(0, 0, 0);
$i++;
continue;
}
if ($strTag === 'h3' || $strTag === 'h2' || $strTag === 'h4') {
$intTip++;
$strTitleRaw = fxBibDistPrintDomPlainText($el);
$strTitle = $strTitleRaw;
$strNum = (string)$intTip;
if (preg_match('/^(\d+)\s*[\.\)\—\-–]\s*(.+)$/u', $strTitleRaw, $m)) {
$strNum = $m[1];
$strTitle = $m[2];
}
$bodyNode = null;
if (($i + 1) < $intN && strtolower($tabBlocks[$i + 1]->nodeName) === 'p') {
$bodyNode = $tabBlocks[$i + 1];
$i += 2;
} else {
$i++;
}
$strBodyPlain = $bodyNode ? fxBibDistPrintDomPlainText($bodyNode) : '';
$fltBadge = 12;
$fltPad = 4.5;
$fltInnerLeft = $fltLeft + 6 + $fltBadge + 5;
$fltInnerW = ($fltLeft + $fltContentW) - $fltPad - $fltInnerLeft;
$pdf->SetFont('Arial', 'B', 11);
$intTitleLines = max(1, (int)ceil($pdf->GetStringWidth(fxBibDistPrintPdfText($strTitle)) / max(1, $fltInnerW)));
$fltTitleH = $intTitleLines * 5.5;
$pdf->SetFont('Arial', '', 10);
$fltBodyH = 0;
if ($strBodyPlain !== '') {
$intBodyLines = max(1, (int)ceil($pdf->GetStringWidth(fxBibDistPrintPdfText($strBodyPlain)) / max(1, $fltInnerW)));
$fltBodyH = $intBodyLines * 4.8;
}
$fltCardH = max(24, $fltPad + $fltTitleH + 2 + $fltBodyH + $fltPad + 1);
if ($pdf->GetY() + $fltCardH > $pdf->GetPageHeight() - $fltBottom) {
$pdf->AddPage();
}
$fltY0 = $pdf->GetY();
$pdf->SetFillColor(247, 249, 252);
$pdf->SetDrawColor(200, 210, 228);
$pdf->Rect($fltLeft, $fltY0, $fltContentW, $fltCardH, 'FD');
$pdf->SetFillColor(47, 95, 208);
$pdf->Rect($fltLeft, $fltY0, 3.2, $fltCardH, 'F');
$fltBadgeX = $fltLeft + 7;
$fltBadgeY = $fltY0 + ($fltCardH - $fltBadge) / 2;
$pdf->SetFillColor(47, 95, 208);
$pdf->Rect($fltBadgeX, $fltBadgeY, $fltBadge, $fltBadge, 'F');
$pdf->SetTextColor(255, 255, 255);
$pdf->SetFont('Arial', 'B', 12);
$pdf->SetXY($fltBadgeX, $fltBadgeY + 2.8);
$pdf->Cell($fltBadge, 6, fxBibDistPrintPdfText($strNum), 0, 0, 'C');
$pdf->SetTextColor(25, 40, 70);
$pdf->SetFont('Arial', 'B', 11);
$pdf->SetXY($fltInnerLeft, $fltY0 + $fltPad);
$pdf->MultiCell($fltInnerW, 5.5, fxBibDistPrintPdfText($strTitle), 0, 'L');
if ($bodyNode) {
$pdf->SetTextColor(55, 65, 80);
$pdf->SetX($fltInnerLeft);
$pdf->SetLeftMargin($fltInnerLeft);
fxBibDistPrintWriteInline($pdf, $bodyNode, 4.8, 10);
$pdf->SetLeftMargin($fltLeft);
$pdf->Ln(2);
}
$pdf->SetY($fltY0 + $fltCardH + 3.5);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetX($fltLeft);
continue;
}
// Image doc (ex. position du dossard) — centrée, largeur limitée.
if ($strTag === 'img') {
$strSrc = $el->getAttribute('src');
$strPath = fxBibDistPrintResolveDocImagePath($strSrc);
if ($strPath !== '') {
$pdf->Ln(1);
fxBibDistPrintWriteImage($pdf, $strPath, 85, true);
}
$i++;
continue;
}
// Autres blocs (ul/ol…) : rendu classique.
if ($strTag === 'p') {
// p après les cartes (rare) : texte simple.
$pdf->SetFont('Arial', '', 10);
$pdf->MultiCell($fltContentW, 5, fxBibDistPrintPdfText(fxBibDistPrintDomPlainText($el)), 0, 'L');
$pdf->Ln(2);
$i++;
continue;
}
fxBibDistPrintWriteHtml($pdf, $dom->saveHTML($el));
$i++;
}
}
/**
* MSIN-4471 — Rendu HTML simplifié (doc_html) vers FPDF.
* Tags supportés : h2–h4, p, ul/ol/li, strong/b, em/i, br, img, blockquote, article/div/span.
*/
function fxBibDistPrintWriteHtml($pdf, $strHtml) {
$strHtml = trim((string)$strHtml);
if ($strHtml === '') {
return;
}
if (!class_exists('DOMDocument', false)) {
$pdf->SetFont('Arial', '', 10);
$pdf->MultiCell(0, 5, fxBibDistPrintPdfText(strip_tags($strHtml)));
return;
}
$dom = new DOMDocument();
$blnPrev = libxml_use_internal_errors(true);
$dom->loadHTML(
'
' . $strHtml . '
',
LIBXML_HTML_NODEFDTD
);
libxml_clear_errors();
libxml_use_internal_errors($blnPrev);
$root = $dom->getElementById('ms1-bib-dist-root');
if (!$root) {
$tabNodes = $dom->getElementsByTagName('div');
foreach ($tabNodes as $el) {
if ($el->getAttribute('id') === 'ms1-bib-dist-root') {
$root = $el;
break;
}
}
}
if (!$root) {
$pdf->SetFont('Arial', '', 10);
$pdf->MultiCell(0, 5, fxBibDistPrintPdfText(strip_tags($strHtml)));
return;
}
$fltLeft0 = method_exists($pdf, 'GetLeftMargin') ? $pdf->GetLeftMargin() : 10;
$fltTop0 = method_exists($pdf, 'GetTopMargin') ? $pdf->GetTopMargin() : 12;
$fnWalk = null;
$fnWalk = function ($node, $intListDepth = 0, $strListType = '') use ($pdf, &$fnWalk, &$fltLeft0, $fltTop0) {
if ($node->nodeType === XML_TEXT_NODE) {
$strText = preg_replace('/\s+/u', ' ', $node->nodeValue);
if ($strText !== null && trim($strText) !== '') {
$pdf->Write(5, fxBibDistPrintPdfText($strText));
}
return;
}
if ($node->nodeType !== XML_ELEMENT_NODE) {
return;
}
$strTag = strtolower($node->nodeName);
if ($strTag === 'br') {
$pdf->Ln(5);
return;
}
if ($strTag === 'img') {
$strSrc = $node->getAttribute('src');
$strPath = fxBibDistPrintResolveDocImagePath($strSrc);
if ($strPath !== '') {
$pdf->Ln(2);
fxBibDistPrintWriteImage($pdf, $strPath);
}
return;
}
$blnBlock = in_array($strTag, array('p', 'h2', 'h3', 'h4', 'li', 'blockquote', 'ul', 'ol'), true);
if ($blnBlock && $pdf->GetX() > $fltLeft0 + 0.5) {
$pdf->Ln(5);
}
if (in_array($strTag, array('h2', 'h3', 'h4'), true)) {
$fltSize = ($strTag === 'h2') ? 13 : (($strTag === 'h3') ? 11 : 10);
$pdf->SetFont('Arial', 'B', $fltSize);
if ($pdf->GetY() > $fltTop0 + 2) {
$pdf->Ln(2);
}
} elseif (in_array($strTag, array('strong', 'b'), true)) {
$pdf->SetFont('Arial', 'B', 10);
} elseif (in_array($strTag, array('em', 'i'), true)) {
$pdf->SetFont('Arial', 'I', 10);
} elseif ($strTag === 'blockquote') {
$pdf->SetFont('Arial', 'I', 10);
$fltLeft0 += 6;
$pdf->SetLeftMargin($fltLeft0);
$pdf->SetX($fltLeft0);
} elseif ($strTag === 'li') {
$pdf->SetFont('Arial', '', 10);
$strBullet = '- ';
// Compteur ol : index parmi les frères
if ($strListType === 'ol' && $node->parentNode) {
$intIdx = 1;
foreach ($node->parentNode->childNodes as $sib) {
if ($sib === $node) {
break;
}
if ($sib->nodeType === XML_ELEMENT_NODE && strtolower($sib->nodeName) === 'li') {
$intIdx++;
}
}
$strBullet = $intIdx . '. ';
}
$pdf->SetX($fltLeft0 + (6 * max(0, $intListDepth)));
$pdf->Write(5, fxBibDistPrintPdfText($strBullet));
} elseif (in_array($strTag, array('p', 'div', 'span', 'article'), true)) {
$pdf->SetFont('Arial', '', 10);
}
$strChildList = $strListType;
$intChildDepth = $intListDepth;
if ($strTag === 'ul') {
$strChildList = 'ul';
$intChildDepth = $intListDepth + 1;
} elseif ($strTag === 'ol') {
$strChildList = 'ol';
$intChildDepth = $intListDepth + 1;
}
foreach ($node->childNodes as $child) {
$fnWalk($child, $intChildDepth, $strChildList);
}
if ($strTag === 'blockquote') {
$fltLeft0 -= 6;
$pdf->SetLeftMargin($fltLeft0);
}
if ($blnBlock) {
$pdf->Ln(5);
$pdf->SetX($fltLeft0);
}
if (in_array($strTag, array('h2', 'h3', 'h4', 'strong', 'b', 'em', 'i', 'blockquote', 'li', 'p'), true)) {
$pdf->SetFont('Arial', '', 10);
}
};
foreach ($root->childNodes as $child) {
$fnWalk($child, 0, '');
}
}
/**
* MSIN-4471 — Dessine le QR résultats événement (kc.php?t=eve) centré.
* Affiche ms1.ca sous le QR (pas l'URL technique).
*/
function fxBibDistPrintDrawEventQr($pdf, $int_eve_id, $strCaption = '') {
$int_eve_id = (int)$int_eve_id;
if ($int_eve_id <= 0 || !function_exists('fxKcEveResultatsQrPngBinary')) {
return;
}
$binPng = fxKcEveResultatsQrPngBinary($int_eve_id, null, 12, true);
if ($binPng === false || $binPng === '') {
return;
}
$strTmp = tempnam(sys_get_temp_dir(), 'bibqr_');
if ($strTmp === false) {
return;
}
@unlink($strTmp);
$strTmpPng = $strTmp . '.png';
if (@file_put_contents($strTmpPng, $binPng) === false) {
return;
}
$fltBottom = method_exists($pdf, 'GetBreakMargin') ? $pdf->GetBreakMargin() : 18;
$fltSize = 95;
$strCaption = trim((string)$strCaption);
if ($strCaption !== '') {
$pdf->Ln(6);
$pdf->SetFont('Arial', 'B', 13);
$pdf->SetTextColor(25, 40, 70);
$pdf->MultiCell(0, 7, fxBibDistPrintPdfText($strCaption), 0, 'C');
$pdf->SetTextColor(0, 0, 0);
$pdf->Ln(4);
} else {
$pdf->Ln(10);
}
if ($pdf->GetY() + $fltSize + 16 > $pdf->GetPageHeight() - $fltBottom) {
$pdf->AddPage();
}
$fltX = ($pdf->GetPageWidth() - $fltSize) / 2;
$pdf->Image($strTmpPng, $fltX, $pdf->GetY(), $fltSize, $fltSize);
$pdf->Ln($fltSize + 6);
$pdf->SetFont('Arial', 'B', 16);
$pdf->SetTextColor(47, 95, 208);
$pdf->MultiCell(0, 8, fxBibDistPrintPdfText('ms1.ca'), 0, 'C');
$pdf->SetTextColor(0, 0, 0);
@unlink($strTmpPng);
}
/**
* MSIN-4471 — 3 pages d'intro (doc_page) avant les listes d'épreuves.
*/
function fxBibOutputDistPrintIntroPages($pdf, $int_eve_id, $strLangue = 'fr') {
// Aligner fxDocLangue() sur la langue du PDF.
$GLOBALS['strLangue'] = ($strLangue === 'en') ? 'en' : 'fr';
if (!function_exists('fxDocSchemaReady') || !fxDocSchemaReady()) {
return;
}
$pdf->blnIntroMode = true;
$pdf->eprTitle = '';
$pdf->documentSubtitle = '';
$strDefaultDocTitle = fxBibTexte('bib_v4_dist_print_title', 0);
// Marges flyer : place pour bandeau (sous-titre majuscule) + logo pied de page.
$pdf->SetMargins(12, 46, 12);
$pdf->SetAutoPageBreak(true, 18);
$intPageBeforeIntro = (int)$pdf->PageNo();
foreach (fxBibDistPrintIntroPageClefs() as $strClef) {
$row = function_exists('fxDocGetPageRow') ? fxDocGetPageRow($strClef, 0) : array();
$strTitre = trim((string)($row['doc_titre'] ?? ''));
$strSous = trim((string)($row['doc_sous_titre'] ?? ''));
$strHtml = trim((string)($row['doc_html'] ?? ''));
if ($strTitre === '' && $strHtml === '') {
continue;
}
$pdf->documentTitle = ($strTitre !== '') ? $strTitre : $strClef;
$pdf->documentSubtitle = $strSous;
$pdf->AddPage();
// Page QR : en-tête + invite + gros QR + ms1.ca (pas de cartes flyer).
if ($strClef === 'bib_dist_print_qr') {
$strCaption = trim(html_entity_decode(strip_tags($strHtml), ENT_QUOTES, 'UTF-8'));
fxBibDistPrintDrawEventQr($pdf, $int_eve_id, $strCaption);
continue;
}
fxBibDistPrintWriteIntroFlyer($pdf, $strHtml);
}
$pdf->intIntroPageCount = max(0, (int)$pdf->PageNo() - $intPageBeforeIntro);
$pdf->blnIntroMode = false;
$pdf->documentTitle = $strDefaultDocTitle;
$pdf->documentSubtitle = '';
$pdf->eprTitle = '';
$pdf->SetMargins(10, 12, 10);
$pdf->SetAutoPageBreak(true, 18);
}
/** MSIN-4433 — Génère et envoie le PDF (format lettre). */
function fxBibOutputDistPrintPdf($int_eve_id, $strLangue = 'fr', $strPrintedBy = '') {
global $objDatabase;
$int_eve_id = (int)$int_eve_id;
if ($int_eve_id <= 0) {
http_response_code(400);
exit;
}
$tabEvent = $objDatabase->fxGetRow("SELECT * FROM inscriptions_evenements WHERE eve_id = $int_eve_id LIMIT 1");
if (!is_array($tabEvent)) {
http_response_code(404);
exit;
}
$strEventTitle = trim((string)($tabEvent['eve_nom_' . $strLangue] ?? ''));
if ($strEventTitle === '') {
$strEventTitle = trim((string)($tabEvent['eve_nom_fr'] ?? ''));
}
$strPrintedAt = fxBibFormatDistPrintDateTime('', $strLangue);
if (trim((string)$strPrintedBy) === '') {
$strPrintedBy = fxBibGetCurrentPromoteurDisplayName();
}
$strFooter = sprintf(
fxBibTexte('bib_v4_dist_print_footer', 0),
$strPrintedAt,
$strPrintedBy
);
$tabPanel = fxBibCollectDistPrintPanelData($int_eve_id, $strLangue);
$strDocRoot = $_SERVER['DOCUMENT_ROOT'] ?? dirname(__DIR__);
require_once($strDocRoot . '/fpdf182/fpdf.php');
if (!class_exists('BibDistPrintPdf', false)) {
class BibDistPrintPdf extends FPDF {
public $footerText = '';
public $pageText = 'Page %s / %s';
public $eventTitle = '';
public $documentTitle = '';
public $documentSubtitle = '';
public $eprTitle = '';
/** MSIN-4471 — Pages intro : bandeau flyer, pas de sous-titre épreuve. */
public $blnIntroMode = false;
/** MSIN-4471 — Nb de pages intro (pagination listes démarre à 1). */
public $intIntroPageCount = 0;
/** MSIN-4471 — Accès public aux marges (protégées dans FPDF 1.82). */
function GetLeftMargin() {
return $this->lMargin;
}
function GetRightMargin() {
return $this->rMargin;
}
function GetTopMargin() {
return $this->tMargin;
}
function GetBreakMargin() {
return $this->bMargin;
}
function Header() {
if ($this->blnIntroMode) {
$fltW = $this->GetPageWidth();
$strSous = trim((string)$this->documentSubtitle);
$blnHasSous = ($strSous !== '');
$fltBandH = $blnHasSous ? 38 : 30;
// Bandeau flyer (bleu MS1 + filet or).
$this->SetFillColor(47, 95, 208);
$this->Rect(0, 0, $fltW, $fltBandH, 'F');
$this->SetFillColor(255, 193, 7);
$this->Rect(0, $fltBandH, $fltW, 2, 'F');
$fltTextX = 12;
$strLogo = function_exists('fxBibDistPrintMs1LogoPath') ? fxBibDistPrintMs1LogoPath() : '';
if ($strLogo !== '') {
$fltLogoW = 34;
$this->Image($strLogo, 10, 8, $fltLogoW);
$fltTextX = 10 + $fltLogoW + 5;
}
$fltTextW = $fltW - $fltTextX - 10;
$this->SetTextColor(255, 255, 255);
$this->SetXY($fltTextX, 5);
$this->SetFont('Arial', 'B', 13);
$this->Cell($fltTextW, 6, fxBibDistPrintPdfText($this->eventTitle), 0, 2, 'L');
$this->SetFont('Arial', 'B', 11);
$this->Cell($fltTextW, 5.5, fxBibDistPrintPdfText($this->documentTitle), 0, 2, 'L');
if ($blnHasSous) {
$strSousUp = function_exists('mb_strtoupper')
? mb_strtoupper($strSous, 'UTF-8')
: strtoupper($strSous);
$this->SetFont('Arial', 'B', 11);
$this->SetTextColor(255, 255, 255);
$this->MultiCell($fltTextW, 5, fxBibDistPrintPdfText($strSousUp), 0, 'L');
}
$this->SetTextColor(0, 0, 0);
$this->SetY($fltBandH + 6);
return;
}
$this->SetFont('Arial', 'B', 14);
$this->Cell(0, 8, fxBibDistPrintPdfText($this->eventTitle), 0, 1, 'C');
$this->SetFont('Arial', '', 10);
$this->Cell(0, 6, fxBibDistPrintPdfText($this->documentTitle), 0, 1, 'C');
$this->Ln(2);
if ($this->eprTitle !== '') {
$this->SetFont('Arial', 'B', 11);
$this->Cell(0, 7, fxBibDistPrintPdfText($this->eprTitle), 0, 1, 'L');
$this->Ln(1);
}
}
function Footer() {
$strLogo = function_exists('fxBibDistPrintMs1LogoPath') ? fxBibDistPrintMs1LogoPath() : '';
$fltPageW = $this->GetPageWidth();
$fltPageH = $this->GetPageHeight();
$fltLogoW = 22;
$fltLogoH = $fltLogoW * (101 / 355); // ~6.3 mm (ratio logo MS1)
$fltGap = 4;
$fltPageNumW = 32;
$blnShowPage = !$this->blnIntroMode;
$fltLogoX = $fltPageW - $this->rMargin - $fltLogoW;
$fltLogoY = $fltPageH - 9.5;
$fltPageNumX = ($strLogo !== '' && $blnShowPage)
? ($fltLogoX - $fltGap - $fltPageNumW)
: (($strLogo !== '')
? ($fltLogoX - $fltGap)
: ($fltPageW - $this->rMargin - ($blnShowPage ? $fltPageNumW : 0)));
$fltTextW = max(30, ($blnShowPage ? $fltPageNumX : $fltLogoX - $fltGap) - $this->lMargin - 2);
// Logo : fond noir pour garder le contraste (logo blanc sur noir).
if ($strLogo !== '') {
$this->SetFillColor(0, 0, 0);
$this->Rect($fltLogoX - 0.8, $fltLogoY - 0.8, $fltLogoW + 1.6, $fltLogoH + 1.6, 'F');
$this->Image($strLogo, $fltLogoX, $fltLogoY, $fltLogoW);
}
$this->SetY(-11);
$this->SetFont('Arial', 'I', 7);
$this->SetTextColor(90, 90, 90);
$this->SetX($this->lMargin);
$this->Cell($fltTextW, 4, fxBibDistPrintPdfText($this->footerText), 0, 0, 'L');
// Pagination : absente sur les pages intro ; page 1 = 1re page de listes.
if ($blnShowPage) {
$intCur = max(1, $this->PageNo() - (int)$this->intIntroPageCount);
$strPage = sprintf($this->pageText, $intCur, '{nb}');
$this->SetXY($fltPageNumX, -11);
$this->Cell($fltPageNumW, 4, fxBibDistPrintPdfText($strPage), 0, 0, 'R');
}
$this->SetTextColor(0, 0, 0);
}
/**
* MSIN-4471 — {nb} = pages de listes seulement (hors intro).
*/
protected function _putpage($n) {
if (!empty($this->AliasNbPages) && (int)$this->intIntroPageCount > 0) {
$intNbList = max(0, $this->page - (int)$this->intIntroPageCount);
$this->pages[$n] = str_replace($this->AliasNbPages, (string)$intNbList, $this->pages[$n]);
$strSaved = $this->AliasNbPages;
$this->AliasNbPages = '';
parent::_putpage($n);
$this->AliasNbPages = $strSaved;
return;
}
parent::_putpage($n);
}
}
}
$pdf = new BibDistPrintPdf('P', 'mm', 'letter');
$pdf->footerText = $strFooter;
$pdf->pageText = fxBibTexte('bib_v4_dist_print_page', 0);
$pdf->eventTitle = fxBibDistPrintTruncate($strEventTitle, 80);
$pdf->documentTitle = fxBibTexte('bib_v4_dist_print_title', 0);
$pdf->SetMargins(10, 12, 10);
$pdf->SetAutoPageBreak(true, 18);
$pdf->AliasNbPages();
// MSIN-4471 — Pages d'explication (doc) avant les tableaux d'épreuves.
fxBibOutputDistPrintIntroPages($pdf, $int_eve_id, $strLangue);
// MSIN-4471 — Feuille bénévole : recherche par nom, puis dossard à remettre.
// Ordre : ☐ | Nom, Prénom | Dossard | Sexe | questions
$fltPageW = $pdf->GetPageWidth() - 20;
$fltColCheck = 10;
$fltColBib = 28;
$fltColSexe = 12;
$fltFixedW = $fltColCheck + $fltColBib + $fltColSexe;
$fltRowH = 8;
$fltHeadH = 8;
$fltBottom = method_exists($pdf, 'GetBreakMargin') ? $pdf->GetBreakMargin() : 14;
$blnHasPrintedEpreuve = false;
foreach ($tabPanel['epreuves'] as $tabEpr) {
$epr_id = (int)($tabEpr['epr_id'] ?? 0);
if ($epr_id <= 0) {
continue;
}
$tabEprRow = $objDatabase->fxGetRow("SELECT * FROM inscriptions_epreuves WHERE epr_id = $epr_id LIMIT 1");
if (!is_array($tabEprRow)) {
continue;
}
// MSIN-4471 — Tri nom/prénom forcé dans fxBibGetParticipantsForDistPrint (args ignorés).
$tabParticipants = fxBibGetParticipantsForDistPrint($epr_id, 'ba:2', '', $strLangue);
// MSIN-4433 — Épreuve sans dossard assigné : ne pas imprimer la section.
if (empty($tabParticipants)) {
continue;
}
$tabSelectedQue = $tabEpr['selected'] ?? [];
$tabQueCols = [];
foreach ($tabEpr['questions'] as $opt) {
if (preg_match('/^que:(\d+)$/', (string)($opt['key'] ?? ''), $m)) {
$intQueId = (int)$m[1];
if (in_array($intQueId, $tabSelectedQue, true)) {
$tabQueCols[] = [
'que_id' => $intQueId,
'label' => (string)($opt['label'] ?? ('Q' . $intQueId)),
];
}
}
}
// MSIN-4471 — Max 3 questions affichées (lisibilité feuille bénévole).
if (count($tabQueCols) > fxBibDistPrintMaxQuestions()) {
$tabQueCols = array_slice($tabQueCols, 0, fxBibDistPrintMaxQuestions());
}
$intNbQ = count($tabQueCols);
$fltNameW = 78;
$fltQTotal = max(0, $fltPageW - $fltFixedW - $fltNameW);
if ($intNbQ === 0) {
$fltNameW = $fltPageW - $fltFixedW;
$fltQEach = 0;
} else {
$fltQEach = $fltQTotal / $intNbQ;
}
$pdf->eprTitle = fxBibDistPrintTruncate($tabEpr['epr_label'] ?? '', 90);
$pdf->AddPage();
$blnHasPrintedEpreuve = true;
$tabAnswers = fxBibGetDistPrintQuestionAnswers($epr_id, $tabSelectedQue, $tabParticipants, $strLangue);
$fnDrawTableHeader = function () use ($pdf, $fltColCheck, $fltColBib, $fltNameW, $fltColSexe, $fltQEach, $tabQueCols, $intNbQ, $fltHeadH) {
$pdf->SetFont('Arial', 'B', 10);
$pdf->SetFillColor(220, 220, 220);
// Case remise | Nom (recherche) | Dossard | Sexe | …
$pdf->Cell($fltColCheck, $fltHeadH, fxBibDistPrintPdfText(fxBibTexte('bib_v4_dist_print_col_check', 0)), 1, 0, 'C', true);
$pdf->Cell($fltNameW, $fltHeadH, fxBibDistPrintPdfText(fxBibTexte('bib_v4_dist_print_col_nom_prenom', 0)), 1, 0, 'L', true);
$pdf->Cell($fltColBib, $fltHeadH, fxBibDistPrintPdfText(fxBibTexte('bib_v4_dist_print_col_bib', 0)), 1, 0, 'C', true);
$pdf->Cell($fltColSexe, $fltHeadH, fxBibDistPrintPdfText(fxBibTexte('bib_v4_dist_print_col_sexe', 0)), 1, $intNbQ === 0 ? 1 : 0, 'C', true);
foreach ($tabQueCols as $i => $col) {
$blnLast = ($i === $intNbQ - 1);
$pdf->Cell($fltQEach, $fltHeadH, fxBibDistPrintPdfText(fxBibDistPrintTruncate($col['label'], 18)), 1, $blnLast ? 1 : 0, 'L', true);
}
};
$fnDrawTableHeader();
$intRow = 0;
foreach ($tabParticipants as $row) {
// Nouvelle page + répéter l'en-tête de colonnes (feuille bénévole).
if ($pdf->GetY() + $fltRowH > $pdf->GetPageHeight() - $fltBottom) {
$pdf->AddPage();
$fnDrawTableHeader();
}
$strKey = fxBibDistPrintAnswerKey($row);
$strNom = trim((string)($row['par_nom'] ?? ''));
$strPrenom = trim((string)($row['par_prenom'] ?? ''));
$strNomPrenom = $strNom;
if ($strPrenom !== '') {
$strNomPrenom .= ($strNom !== '' ? ', ' : '') . $strPrenom;
}
$blnAlt = ($intRow % 2) === 1;
if ($blnAlt) {
$pdf->SetFillColor(245, 245, 245);
} else {
$pdf->SetFillColor(255, 255, 255);
}
$blnFill = true;
// Case à cocher (vide) pour marquer la remise.
$pdf->SetFont('Arial', '', 11);
$pdf->Cell($fltColCheck, $fltRowH, '', 1, 0, 'C', $blnFill);
// Nom, Prénom — colonne de recherche principale.
$pdf->SetFont('Arial', 'B', 11);
$pdf->Cell($fltNameW, $fltRowH, fxBibDistPrintPdfText(fxBibDistPrintTruncate($strNomPrenom, 42)), 1, 0, 'L', $blnFill);
// Dossard — numéro à remettre.
$pdf->SetFont('Arial', 'B', 14);
$pdf->Cell($fltColBib, $fltRowH, fxBibDistPrintPdfText((string)(int)($row['no_bib'] ?? 0)), 1, 0, 'C', $blnFill);
$pdf->SetFont('Arial', '', 11);
$pdf->Cell($fltColSexe, $fltRowH, fxBibDistPrintPdfText(fxBibDistPrintSexeLabel($row['par_sexe'] ?? '', $strLangue)), 1, $intNbQ === 0 ? 1 : 0, 'C', $blnFill);
foreach ($tabQueCols as $i => $col) {
$intQueId = (int)$col['que_id'];
$strAns = $tabAnswers[$strKey][$intQueId] ?? '';
$blnLast = ($i === $intNbQ - 1);
$pdf->SetFont('Arial', '', 10);
$pdf->Cell($fltQEach, $fltRowH, fxBibDistPrintPdfText(fxBibDistPrintTruncate($strAns, 20)), 1, $blnLast ? 1 : 0, 'L', $blnFill);
}
$intRow++;
}
$pdf->Ln(4);
}
if (!$blnHasPrintedEpreuve && $pdf->PageNo() < 1) {
$pdf->AddPage();
}
$strFilename = 'distribution-dossards-' . $int_eve_id . '.pdf';
$pdf->Output('I', $strFilename);
}
/** MSIN-4433 — Coquille panneau impression (chargement AJAX). */
function renderBibDistPrintPanelShell($int_eve_id, $strLangue = 'fr') {
global $vDomaine;
$int_eve_id = (int)$int_eve_id;
$strWait = fxBibTexte('bib_v4_js_loader_wait', 0);
if ($strWait === '' || $strWait === 'bib_v4_js_loader_wait') {
$strWait = ($strLangue === 'en') ? 'Loading...' : 'Chargement...';
}
$strRunnerSrc = $vDomaine . '/images/ms1-runner-loader.gif?v=' . _VERSION_CODE;
ob_start();
?>