participanti-varsta

[php]

### configurare
$categories_arr = array(
‘semi’ => array(
‘Categorie’,
‘Semi 14-22 F’,
‘Semi 14-22 M’,
‘Semi 23-39 F’,
‘Semi 23-39 M’,
‘Semi 40+ F’,
‘Semi 40+ M’
),
‘cross’ => array(
‘Categorie’,
‘Cross 14-19 F’,
‘Cross 14-19 M’,
‘Cross 20+ F’,
‘Cross 20+ M’,
)
);

$sorttable = $_GET[‘tabel’];# values: semi, cross
$sortkey = $_GET[‘sortF’] ? $_GET[‘sortF’] : ‘nrConcurs’ ;
$sortdirection = $_GET[‘sortD’] ? $_GET[‘sortD’] : ($sortkey == ‘nrConcurs’ ? ‘desc’ : ‘asc’) ;
$limit = false;

$sort_arr = array (
‘nrConcurs’ => false,
‘nume’ => ‘Nume (Last name)’,
‘varsta’ => ‘Varsta (Age)’,
‘oras’ => ‘Oras (City)’,
‘club’ => ‘Club/Asociatie/Firma (Club/Association/Company)’
);

$array = get_cforms_entries(‘Inscriere’, false, false, $sort_arr[$sortkey], $limit, $sortdirection);
#echo’

';var_export($array);echo'

‘;

/*** FIX for sort for cforms integer field ***/
if($sortkey == ‘varsta’ && $sortdirection == ‘desc’) $array = array_reverse($array);

$data = array();
if($array) foreach($array as $row){
if($row[‘data’][‘Selectati categoria la care participati (Please select your category)’] && $row[‘data’][‘Numar concurs’]){
if(stristr($row[‘data’][‘Selectati categoria la care participati (Please select your category)’], ‘semi’))
$data[‘semi’][] = $row;
else
$data[‘cross’][] = $row;
}
}

$sortLinkParams = array(
‘nume’ => $_GET[‘nume’],
‘categorie’ => $_GET[‘categorie’],
‘sortkey’ => $sortkey,
‘sortdirection’ => $sortdirection
);

function sortQuery($field, $params){
$query = ‘tabel=’.$params[‘tabel’].’&’;
$query .= $params[‘nume’] ? ‘nume=’.$params[‘nume’] : ”;
$query .= $query && substr($query,-1)!=’&’ ? ‘&’ : ”;
$query .= $params[‘categorie’] ? ‘categorie=’.$params[‘categorie’] : ”;
$query .= $query && substr($query,-1)!=’&’ ? ‘&’ : ”;
$query .= ‘sortF=’.$field;
if($params[‘sortkey’] == $field)
$query .= ‘&sortD=’ . ($params[‘sortdirection’] == ‘asc’ ? ‘desc’ : ‘asc’);
return ‘?’.$query;
}

function sortArrow($field, $params){
if($params[‘sortkey’] == $field)
{
$path = ‘http://semimaraton.ro/images/graphics/’;
$style = ‘ style=”width:10px; margin-left:2px; vertical-align:middle”‘;
if($params[‘sortdirection’] == ‘asc’)
return ‘‘;
else
return ‘‘;
}
else
return ”;
}

echo ‘

‘;

$sortLinkParams[‘tabel’] = ‘semi’;
echo ‘

Semimaraton (‘.count($data[$sortLinkParams[‘tabel’]]).’ participanti)

‘;

$sortLinkParams[‘tabel’] = ‘cross’;
echo ‘

Cross (‘.count($data[$sortLinkParams[‘tabel’]]).’ participanti)

‘;

[/php]