fxEscape($clef) . "' ORDER BY trie"; $rec = $objDatabase->fxGetResults($sql); if ($rec===null){ $sql = "SELECT * FROM config_tableau WHERE clef = 'LISTEDONATEURGENERIQUE' ORDER BY trie"; $rec = $objDatabase->fxGetResults($sql); } return $rec; } function fxchecklangue($strtab,$i,$langues) { if ($strtab[$i]['info1langue'] == 1) return $strtab[$i]['info1'] . "_" . $langues; else return $strtab[$i]['info1']; } function fxGetquery($clef,$eve_id) { $sql = "SELECT query_query FROM config_query WHERE query_clef = '" . $objDatabase->fxEscape($clef) . "' limit 1"; $rec = $objDatabase->fxGetVar($sql); if ($rec===null){ $sql = "SELECT query_query FROM config_query WHERE query_clef = 'rapportdonationGENERIQUE' limit 1"; $rec = $objDatabase->fxGetVar($sql); $rec = str_replace('%eve_id%', $eve_id, $rec); } return $rec; } function fxlistepreuves($evenement,$langue,$mem_selected) { require_once('php/inc_dons.php'); // $sql = "SELECT * FROM inscriptions_panier_epreuves WHERE pan_id = " . $evenement . " ORDER BY epr_type_" . $langue; // $sql = "SELECT * FROM inscriptions_panier_epreuves WHERE pan_id = " . $evenement . " ORDER BY epr_type_" . $langue; $list_exeption=''; $sqlex = "SELECT * from config_query_exep where type_exep='remove' and eve_id= " . $evenement; $recex = $objDatabase->fxGetRow($sqlex); if ($recex) $list_exeption="ipe.epr_id not in (". $recex['sql'].") and " ; // $list_exeptionadd=''; $sqlex = "SELECT * from config_query_exep where type_exep='add' and eve_id= " . $evenement; $list_exeptionadd = $objDatabase->fxGetResults($sqlex); // if ($recex) // $list_exeption="ipe.epr_id not in (". $recex['sql'].") and " ; $sql = "SELECT * FROM inscriptions_panier_epreuves_commandees ipec LEFT JOIN inscriptions_panier_epreuves ipe on ipe.epr_id= ipec.epr_id where ".$list_exeption." eve_id= " . $evenement . " group by ipec.epr_id ORDER BY epr_type_" . $langue; $rec = $objDatabase->fxGetResults($sql); if ($mem_selected == "") $mem_select = ' selected="selected"'; else $mem_select = ''; $output = ''; return $output; } $strEpreuve = afficheTexte('toutlesepreuves',0); $mem_where = ''; $mem_rech_epreuve = ''; // v?rifier les form POST if (isset($_GET['rech_epreuve'])) { if ($_GET['rech_epreuve'] != '') { $exep=explode(":",$_GET['rech_epreuve']); if (isset($exep[0])) $expsuite= $exep[0]; else $expsuite=""; if ($exep[0]=='exp'){ $mem_where .= ' and e.epr_id in( ' .$exep[1].')'; $strEpreuve=$exep[2]; $mem_rech_epreuve= $_GET['rech_epreuve']; } else { $mem_where .= ' and e.epr_id = ' . $_GET['rech_epreuve']; $mem_rech_epreuve = $_GET['rech_epreuve']; $mem_tabformat = "LISTEDONATEUREVE".$tabEvenement['general']['eve_id']; $intEpreuve = $_GET['rech_epreuve']; // trouver le nom de l'?preuve foreach ($tabEvenement['epreuves'] as $tabEpreuves) { if ($tabEpreuves['epr_id'] == $intEpreuve) { $strEpreuve = fxUnescape($tabEpreuves['epr_type_' . $strLangue]); if (trim($tabEpreuves['epr_nom_' . $strLangue]) != '') $strEpreuve .= ' - ' . fxUnescape($tabEpreuves['epr_nom_' . $strLangue]); } } } } else $mem_tabformat = "LISTEDONATEUR".$tabEvenement['general']['eve_id']; } $mem_rech_nom=""; if (isset($_GET['rech_nom'])) { if($_GET['rech_nom'] != '') { $mem_where .= " and concat(com_prenom,' ',com_nom) like '%" . $_GET['rech_nom'] . "%'" ; $mem_rech_nom = $_GET['rech_nom']; } } ?>

//donsdonations" id="frm_search" name="frm_search" method="get">

Recherche :Search :




fxGetResults($sql); $strtab = fxGetchamps("LISTETOTALEVE".$tabEvenement['general']['eve_id_don']); echo '

'.afficheTexte('listeparticipantsresume',0).'


'; echo '
'; $strResults = ''; //entete pour le tableau for ($i = 1; $i <= count($strtab); $i++) $strResults .= ''; //contenue le tableau for ($x = 1; $x <= count($strliste); $x++) { $mem_odd = ($x & 1) ? '' : ''; $strResults .= $mem_odd; for ($i = 1; $i <= count($strtab); $i++) { if ($strtab[$i]['multiple'] == 1) { $mem_field = preg_split('/,/', $strtab[$i]['info1']); $mem_affiche = $strliste[$x][$mem_field[0]] . ' ' . $strliste[$x][$mem_field[1]]; } else $mem_affiche = $strliste[$x][fxchecklangue($strtab, $i, $strLangue)]; // if ($mem_lientours == "TRUE" && trim($strtab[$i]['lien']) <> "") { // if (trim($strclassement[$x][$strtab[$i]['info1']]) == "") { //$mem_param = '?equipe=' . $strclassement[$x]['Id_Numero'] . '&tabformat=' . $mem_tabformat . 'TOUR&lang=' . $lang . '&where=' . $mem_whereorg . '&nocoursse=' . $mem_nocoursse . '&nocoursseorg=' . $mem_nocoursseorg . '&rettabformat=' . $mem_tabformat; // $mem_affiche = ' ' . $strtab[$i]['info2_' . $lang] . ''; // } // } if ($strLangue == 'fr') $MEM_SUITE = 'inscrits'; else $MEM_SUITE='registered'; $strResults .= ''; } $strResults .= ""; } $strResults .= "
' . $strtab[$i]['info2_' . $strLangue] . '
' . $mem_affiche . '
"; echo $strResults; echo '
'; } //liste des participants $sql = fxGetquery("rapportdonnation".$tabEvenement['general']['eve_id_don'],$tabEvenement['general']['eve_id_don']); $sql = str_replace('%where%', $mem_where, $sql); $strliste = $objDatabase->fxGetResults($sql); $strtab = fxGetchamps($mem_tabformat); echo '

' . $strEpreuve . '

'; if ($stradm!="") echo '

' . afficheTexte('nombreinscription', 0) . ' ' . count($strliste) . '


'; $strResults = ''; //entete pour le tableau for ($i = 1; $i <= count($strtab); $i++) $strResults .= ''; // contenue le tableau for ($x = 1; $x <= count($strliste); $x++) { $mem_odd = ($x & 1) ? '' : ''; $strResults .= $mem_odd; for ($i = 1; $i <= count($strtab); $i++) { // stephan MSIN-2002 if ($strtab[$i]['convert']=='dons'){ $mem_field = preg_split('/,/',$strtab[$i]['info1']); $mem_affiche = fxGetLinksDonationParticipant($strliste[$x][ $mem_field[0]], $strliste[$x][ $mem_field[1]], $strLangue); $mem_affiche = '' . $mem_affiche['label'] . ''; } else { if ($strtab[$i]['multiple']==1) { $mem_field=preg_split('/,/',$strtab[$i]['info1']); $mem_affiche = $strliste[$x][ $mem_field[0]].' '.$strliste[$x][ $mem_field[1]]; } else $mem_affiche = $strliste[$x][ fxchecklangue($strtab,$i,$strLangue)]; } $strResults .= ''; } $strResults .= ""; } $strResults .= "
' . $strtab[$i]['info2_' . $strLangue] . '
' . $mem_affiche . '
"; echo $strResults; */ require_once 'php/inc_dons.php'; // récupérer les donnnées get if (!empty($_GET['pec_id'])) $intEpreuveCommandee = $_GET['pec_id']; else $intEpreuveCommandee = ''; if (!empty($_GET['par_id'])) $intParticipant = $_GET['par_id']; else $intParticipant = ''; if ($strLangue == 'fr') $strPageDon = 'don'; else $strPageDon = 'donate'; $arrDonateurs = fxGetDonateurs($tabEvenement['general']['eve_id_don'], $intEpreuveCommandee, $intParticipant); ?>