}
$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) {
$p = 32;
} elseif ($p == 48) {
$p = 64;
}
$MyQuery .= "AND GrPhase = {$p} ";
//. StrSafe_DB($_REQUEST['Phase']) . " ";
//$MyQuery.= "AND GrPhase = " . StrSafe_DB($_REQUEST['Phase']) . " ";
}
}
$MyQuery .= ' ORDER BY ' . $OrderBy . ' EvCode, GrPhase DESC, FinMatchNo ASC';
}
//*DEBUG*/echo $MyQuery;exit();
$Rs = safe_r_sql($MyQuery);
// Se il Recordset è valido e contiene almeno una riga
if (safe_num_rows($Rs) > 0) {
$defGoldW = ($pdf->GetPageWidth() - 3 * $pdf->getSideMargin()) / 2 * (1 / 15);
$defTotalW = ($pdf->GetPageWidth() - 3 * $pdf->getSideMargin()) / 2 * (3 / 15);
$defArrowTotW = ($pdf->GetPageWidth() - 3 * $pdf->getSideMargin()) / 2 * (6 / 15);
$WhereStartX = array($pdf->getSideMargin(), $pdf->GetPageWidth() / 2 + $pdf->getSideMargin() / 2);
$WhereStartY = array(60, 60);
$WhereX = NULL;
$WhereY = NULL;
$AtlheteName = NULL;
$FollowingRows = false;
//DrawScore
while ($MyRow = safe_fetch($Rs)) {
$MyRowOpp = safe_fetch($Rs);
if (empty($_REQUEST["Blank"]) && empty($_REQUEST["IncEmpty"]) && ($MyRow->FinAthlete == 0 || $MyRowOpp->FinAthlete == 0)) {
// se è vuoto uno dei due arcieri e non è selezionata l'inclusione
// salta al prossimo record
continue;
<?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);
$ColorAssignment = array();
$OldSession = '';
$OldDist = '';
$OldTarget = '';
$TmpColor = array(255, 255, 255);
$SecondaryDistance = 0;
$TgText = '';
$TgFirst = 0;
$TgNo = 0;
$TgTop = 0;
$TopPos = 35 - RowH;
// select already assigned number of sessions with min and max target
$SesSql = safe_r_sql("select QuSession, min(cast( substr(QuTargetNo,2) as unsigned)) TargetMin, max(cast( substr(QuTargetNo,2) as unsigned)) TargetMax, ToNumDist from Qualifications inner join Entries on EnId=QuId inner join Tournament on EnTournament=ToId where EnTournament={$_SESSION['TourId']} and cast( substr(QuTargetNo,2) as unsigned)>0 group by QuSession");
while ($SesRow = safe_fetch($SesSql)) {
// set the target dimention
$DimTarget = min(10, ($pdf->GetPageWidth() - 20 - ColName) / ($SesRow->TargetMax - $SesRow->TargetMin + 1));
// checks if there is enough space for at least 1 distance
if (!$pdf->SamePage(RowH + 25)) {
$pdf->AddPage();
//Al cambio di data aggiungo una pagina
$TopPos = 35;
} else {
$TopPos += RowH;
}
// prints the session
$pdf->SetFillColor(0);
$pdf->SetTextColor(255);
$pdf->SetXY(10, $TopPos);
$pdf->SetFont($pdf->FontStd, 'B', 14);
$pdf->Cell($pdf->GetPageWidth() - 20, 8, get_text('Session') . ": " . $SesRow->QuSession, 0, 0, "C", 1);
$TopPos += 8;
<?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/Lib/ArrTargets.inc.php';
require_once 'Common/Lib/Fun_PrintOuts.php';
$pdf = new ResultPDF(get_text('IndFinal'), false);
$pdf->setBarcodeHeader(70);
$CellH = 12;
$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);
$GridTotH = $pdf->GetPageheight() * 0.25;
$FillWithArrows = false;
if (isset($_REQUEST["ScoreFilled"]) && $_REQUEST["ScoreFilled"] == 1) {
$FillWithArrows = true;
}
$pdf->PrintFlags = !empty($_REQUEST["ScoreFlags"]);
$NumColStd = 6;
$NumColField = 3;
$StdCols = 1;
$NumRow = 0;
$Fita3D = false;
/*$Select
= "SELECT (TtElabTeam=0) as StdTournament, (TtCategory=8) as 3DTournament "
. "FROM Tournament INNER JOIN Tournament*Type ON ToType=TtId "
. "WHERE ToId=" . StrSafe_DB($_SESSION['TourId']) . " ";*/
$Select = "SELECT (ToElabTeam=0) as StdTournament, (ToCategory=8) as 3DTournament " . "FROM Tournament " . "WHERE ToId=" . StrSafe_DB($_SESSION['TourId']) . " ";
$RsTour = safe_r_sql($Select);
if (safe_num_rows($RsTour) == 1) {
}
$ColorAssignment = array();
$FirstTarget = 1;
$LastTarget = 99;
$NumDistances = 1;
$MyQuery = "SELECT MIN(SUBSTRING(AtTargetNo,2," . TargetNoPadding . ")*1) AS A, MAX(SUBSTRING(AtTargetNo,2," . TargetNoPadding . ")*1) AS B, MAX(ToNumDist) as NumDistanze" . " FROM Tournament" . " INNER JOIN AvailableTarget On ToId = AtTournament" . " WHERE ToId=" . StrSafe_DB($_SESSION['TourId']);
//echo $MyQuery;exit();
$Rs = safe_r_sql($MyQuery);
if (safe_num_rows($Rs) == 1) {
$r = safe_fetch($Rs);
$FirstTarget = $r->A;
$LastTarget = $r->B;
$NumDistances = $r->NumDistanze;
//safe_free_result($Rs);
}
$DimTarget = ($pdf->GetPageWidth() - 42) / ($LastTarget - $FirstTarget + 1);
$MyQuery = "";
for ($i = 1; $i <= $NumDistances; $i++) {
if (strlen($MyQuery) != 0) {
$MyQuery .= " UNION ";
}
$MyQuery .= "(SELECT DISTINCT QuSession as Session, SUBSTRING(QuTargetNo,2," . TargetNoPadding . ") as Target, " . " IFNULL(Td" . $i . ",'." . $i . ".') as Dist, IFNULL(Td1,'.1.') as Main, " . $i . " as CheDist" . " FROM Tournament AS t" . " INNER JOIN Entries AS e ON t.ToId=e.EnTournament" . " INNER JOIN Qualifications AS q ON e.EnId=q.QuId" . " LEFT JOIN TournamentDistances AS td ON t.ToType=td.TdType and TdTournament=ToId AND CONCAT(TRIM(e.EnDivision),TRIM(e.EnClass)) LIKE TdClasses" . " WHERE ToId=" . StrSafe_DB($_SESSION['TourId']) . " AND QuSession > 0 AND QuTargetNo <> '' )";
}
$MyQuery .= " ORDER BY Session, Dist+0 DESC, CheDist ASC, Target, Main DESC";
// debug_svela($MyQuery);
$Rs = safe_r_sql($MyQuery);
if (safe_num_rows($Rs) > 0) {
$OldSession = '';
$OldDist = '';
$OldTarget = '';
$TmpColor = array(255, 255, 255);
