prepare("SELECT id, nosaukums FROM zzzTesti WHERE sacensibu_id = ? ORDER BY nosaukums"); $sth->execute([SACENSIBU_ID]); while ($o = $sth->fetchObject()) { $testi_thead .= "$o->nosaukums"; $testi[$o->id] = $o->nosaukums; } // dalibnieki / komandas $rezultati = []; $sth = $dbh->prepare("SELECT r.id, r.komandas_id, rms.team_name, rms.class_id, r.sakuma_laiks, r.beigu_laiks, SUBTIME(IF(r.beigu_laiks > 0, r.beigu_laiks, TIME(NOW())), r.sakuma_laiks) AS kopejais_trases_laiks, r.zaudetie_kontrolpunkti, r.citi_sodi, rms.status, GROUP_CONCAT(rms.rider) AS riders, rmc.class FROM zzzRezultati r LEFT JOIN 2w_race_manager_signup rms ON rms.team_id = r.komandas_id LEFT JOIN 2w_race_manager_classes rmc ON rmc.id = rms.class_id WHERE r.sacensibu_id = ? AND (rms.status IS NULL OR rms.status = 0) AND rms.class_id IS NOT NULL GROUP BY r.id ORDER BY rms.class_id, r.id"); $sth->execute([SACENSIBU_ID]); while ($o = $sth->fetchObject()) { $rezultati[$o->id] = $o; } $thead = " Team IDTeam nameRidersClassStart timeFinish timeTotal time $testi_thead STAGE TOTAL CP Penalty #CP Penalty secPenalty for exceeding timeOther penaltiesTotal Result "; ?>

Overall Rating 2022

$r) { //atkārtot hederi ja mainās klase // if ($r->class_id != $class_id && $class_id) { // echo "$thead"; // } // $class_id = $r->class_id; //savāc testu rezultātus $r->testi_html = ""; $r->testu_kopejais_laiks_sekundes = 0; foreach ($testi as $testa_id => $test) { $sth = $dbh->prepare("SELECT COALESCE(MIN(SUBTIME(beigu_laiks, sakuma_laiks)), '') AS testa_laiks FROM zzzTestaRezultati WHERE komandas_id = ? AND testa_id = ?"); $sth->execute([$r->komandas_id, $testa_id]); $testa_laiks = $sth->fetchObject()->testa_laiks; $r->testi_html .= ""; $r->testu_kopejais_laiks_sekundes += timeToSeconds($testa_laiks); } //beigu laika apstrāde $r->beigu_laiks = ($r->beigu_laiks > 0) ? $r->beigu_laiks : ""; //CP penalty $r->zaudeto_kontrolpunktu_laiks = $r->zaudetie_kontrolpunkti * 120; //Exceeding penalty $r->sods_par_parteretu_laiku = ($r->kopejais_trases_laiks > "07:00:00") ? 360 : 0; //total time $r->kopvertejums = $r->testu_kopejais_laiks_sekundes + $r->zaudeto_kontrolpunktu_laiks + $r->sods_par_parteretu_laiku + $r->citi_sodi; } uasort($rezultati, function($a, $b){ if ($a->class_id == $b->class_id) { return $a->kopvertejums - $b->kopvertejums; } else { return strcmp($a->class_id, $b->class_id); } }); $class_id = ""; foreach ($rezultati as $id => $r) { if ($r->class_id != $class_id) { if ($class_id) echo ""; echo "$thead"; } $class_id = $r->class_id; echo " $r->testi_html "; } ?>
$testa_laiks
$r->class
$r->komandas_id $r->team_name $r->riders $r->class $r->sakuma_laiks $r->beigu_laiks $r->kopejais_trases_laiks".secondsToTime($r->testu_kopejais_laiks_sekundes)." $r->zaudetie_kontrolpunkti ".secondsToTime($r->zaudeto_kontrolpunktu_laiks)." ".$r->sods_par_parteretu_laiku." ".secondsToTime($r->citi_sodi)." ".secondsToTime($r->kopvertejums)."