} $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);