}
$TmpJoinType = 'INNER';
if (isset($_REQUEST["IncEmpty"]) && $_REQUEST["IncEmpty"] == 1) {
$TmpJoinType = 'LEFT';
}
$MyQuery = 'SELECT ' . ' EvCode, EvEventName, EvFinalFirstPhase, EvMatchMode, EvMatchArrowsNo, ' . ' IF(EvFinalFirstPhase=48 || EvFinalFirstPhase=24,GrPosition2, GrPosition) as GrPosition, CONCAT(EnName, \' \', EnFirstName) as Athlete, (FinTie=2) as isBye, ' . ' CoCode, CoName, ' . ' NULLIF(s64.FSLetter,\'\') s64,NULLIF(s32.FSLetter,\'\') s32, NULLIF(s16.FSLetter,\'\') s16, NULLIF(s8.FSLetter,\'\') s8, NULLIF(s4.FSLetter,\'\') s4, NULLIF(s2.FSLetter,\'\') s2, NULLIF(sb.FSLetter,\'\') sBr, NULLIF(sg.FSLetter,\'\') sGo ' . " , EvElimEnds" . " , EvElimArrows" . " , EvElimSO" . " , EvFinEnds" . " , EvFinArrows" . " , EvFinSO" . ' FROM Events' . ' INNER JOIN Finals ON EvCode=FinEvent AND EvTournament=FinTournament' . ' INNER JOIN Grids ON FinMatchNo=GrMatchNo AND GrPhase=(IF(EvFinalFirstPhase=24,32, IF(EvFinalFirstPhase=48,64,EvFinalFirstPhase )))' . ' ' . $TmpJoinType . ' JOIN Entries ON FinAthlete=EnId AND FinTournament=EnTournament' . ' ' . $TmpJoinType . ' JOIN Countries on EnCountry=CoId AND EnTournament=CoTournament' . ' LEFT JOIN FinSchedule s64 ON EvCode=s64.FSEvent AND EvTeamEvent=s64.FSTeamEvent AND EvTournament=s64.FSTournament AND IF(EvFinalFirstPhase=64 OR EvFinalFirstPhase=48,FinMatchNo,-256)=s64.FSMatchNo' . ' LEFT JOIN FinSchedule s32 ON EvCode=s32.FSEvent AND EvTeamEvent=s32.FSTeamEvent AND EvTournament=s32.FSTournament AND IF(EvFinalFirstPhase=32 OR EvFinalFirstPhase=24,FinMatchNo,FLOOR(s64.FSMatchNo/2))=s32.FSMatchNo' . ' LEFT JOIN FinSchedule s16 ON EvCode=s16.FSEvent AND EvTeamEvent=s16.FSTeamEvent AND EvTournament=s16.FSTournament AND IF(EvFinalFirstPhase=16,FinMatchNo,FLOOR(s32.FSMatchNo/2))=s16.FSMatchNo' . ' LEFT JOIN FinSchedule s8 ON EvCode=s8.FSEvent AND EvTeamEvent=s8.FSTeamEvent AND EvTournament=s8.FSTournament AND IF(EvFinalFirstPhase=8,FinMatchNo,FLOOR(s16.FSMatchNo/2))=s8.FSMatchNo' . ' LEFT JOIN FinSchedule s4 ON EvCode=s4.FSEvent AND EvTeamEvent=s4.FSTeamEvent AND EvTournament=s4.FSTournament AND IF(EvFinalFirstPhase=4,FinMatchNo,FLOOR(s8.FSMatchNo/2))=s4.FSMatchNo' . ' LEFT JOIN FinSchedule s2 ON EvCode=s2.FSEvent AND EvTeamEvent=s2.FSTeamEvent AND EvTournament=s2.FSTournament AND IF(EvFinalFirstPhase=2,FinMatchNo,FLOOR(s4.FSMatchNo/2))=s2.FSMatchNo' . ' LEFT JOIN FinSchedule sb ON EvCode=sb.FSEvent AND EvTeamEvent=sb.FSTeamEvent AND EvTournament=sb.FSTournament AND FLOOR(s2.FSMatchNo/2)=sb.FSMatchNo' . ' LEFT JOIN FinSchedule sg ON EvCode=sg.FSEvent AND EvTeamEvent=sg.FSTeamEvent AND EvTournament=sg.FSTournament AND FLOOR(s2.FSMatchNo/2)-2=sg.FSMatchNo' . ' WHERE EvTournament=' . StrSafe_DB($_SESSION['TourId']) . ' AND EvTeamEvent=0 ';
if ($Events) {
$MyQuery .= "AND EvCode in (" . implode(',', $Events) . ") ";
}
$MyQuery .= ' ORDER BY EvCode, FinMatchNo ';
}
//DEBUG_svela($MyQuery, true);
$Rs = safe_r_sql($MyQuery);
// Se il Recordset รจ valido e contiene almeno una riga
if (safe_num_rows($Rs) > 0) {
$defArrowTotW = ($pdf->GetPageWidth() - 3 * $pdf->getSideMargin()) / 2 * (6 / 15);
//12;
$defTotalW = ($pdf->GetPageWidth() - 3 * $pdf->getSideMargin()) / 2 * (3 / 15);
//16;
$defGoldW = ($pdf->GetPageWidth() - 3 * $pdf->getSideMargin()) / 2 * (1 / 15);
//7;
$ScoreHeight = $pdf->GetPageHeight() * 0.23;
$WhereStartX = array($pdf->getSideMargin(), $pdf->GetPageWidth() / 2 + $pdf->getSideMargin() / 2, $pdf->getSideMargin(), $pdf->GetPageWidth() / 2 + $pdf->getSideMargin() / 2, $pdf->getSideMargin(), $pdf->GetPageWidth() / 2 + $pdf->getSideMargin() / 2);
$WhereStartY = array($pdf->GetPageHeight() * 0.2, $pdf->GetPageHeight() * 0.2, $pdf->GetPageHeight() * 0.44, $pdf->GetPageHeight() * 0.44, $pdf->GetPageHeight() * 0.68, $pdf->GetPageHeight() * 0.68);
$WhereX = NULL;
$WhereY = NULL;
$RowNo = 0;
while ($MyRow = safe_fetch($Rs)) {
// if($MyRow->EvFinalFirstPhase==48 || $MyRow->EvFinalFirstPhase==24)
// $Fasi[0]=get_text('24_Phase');
if ($MyRow->EvFinalFirstPhase == 48) {
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/config.php';
require_once 'Common/pdf/ResultPDF.inc.php';
require_once 'Common/Fun_FormatText.inc.php';
require_once 'Common/Fun_Phases.inc.php';
$pdf = new ResultPDF(get_text('TeamFinal'), true);
$pdf->setlinewidth(0.1);
$GoldW = ($pdf->GetPageWidth() - 3 * $pdf->getSideMargin()) / 2 * (1 / 18);
$ArrowTotW = ($pdf->GetPageWidth() - 3 * $pdf->getSideMargin()) / 2 * (9 / 18);
$TotalW = ($pdf->GetPageWidth() - 3 * $pdf->getSideMargin()) / 2 * (3 / 18);
$GridHeight = ($pdf->GetPageHeight() - 90) / 2;
$StdCols = 1;
$NumRow = 4;
$CellH = 7;
/*$Select
= "SELECT (TtElabTeam=0) as StdTournament, (TtElabTeam=2) as ThreeDTournament "
. "FROM Tournament INNER JOIN Tournament*Type ON ToType=TtId "
. "WHERE ToId=" . StrSafe_DB($_SESSION['TourId']) . " ";*/
$Select = "SELECT (ToElabTeam=0) as StdTournament, (ToElabTeam=2) as ThreeDTournament " . "FROM Tournament " . "WHERE ToId=" . StrSafe_DB($_SESSION['TourId']) . " ";
$RsTour = safe_r_sql($Select);
if (safe_num_rows($RsTour) == 1) {
$r = safe_fetch($RsTour);
$StdCols = $r->StdTournament;
$NumRow = $r->ThreeDTournament;
safe_free_result($RsTour);
}
$NumRow = $NumRow == 1 ? 8 : 4;
$Fasi = array(get_text('8_Phase'), get_text('4_Phase'), get_text('2_Phase'), get_text('0_Phase'));
$TgtNoFasi = array('s8', 's4', 's2', 'sGo');
$Start2FirstPhase = array(8 => 0, 4 => 1, 2 => 2, 1 => 3, 0 => 3);
