$r = safe_fetch($Rs);
$NumEnd = $r->TtNumEnds;
}
$NumEnd = !empty($_REQUEST['x_Session']) && $_REQUEST['x_Session'] == 1 ? 8 : 12;
if (!(isset($_REQUEST["ScoreHeader"]) && $_REQUEST["ScoreHeader"] == 1)) {
$pdf->HideHeader();
}
if (!(isset($_REQUEST["ScoreLogos"]) && $_REQUEST["ScoreLogos"] == 1)) {
$pdf->HideLogo();
}
if (isset($_REQUEST["ScoreDraw"]) && $_REQUEST["ScoreDraw"] == "Data") {
$pdf->NoDrawing();
}
if (isset($_REQUEST["ScoreDraw"]) && $_REQUEST['ScoreDraw'] == "Draw") {
$pdf->AddPage();
$pdf->DrawScoreField(8, 8, 194, 132.5, $NumEnd / 2, 3, array("tNo" => '', "startTarget" => ''));
$pdf->DrawScoreField(8, 156.5, 194, 132.5, $NumEnd / 2, 3, array("tNo" => '', "startTarget" => ''));
} else {
$MyQuery = 'SELECT SUBSTRING(ElTargetNo,1,4) as tNo, SesName, CONCAT(EnFirstName,\' \', EnName) AS Ath, CONCAT(CoCode, \' - \', CoName) as Noc, ElEventCode AS Cat , ElElimPhase, IFNULL(SesFirstTarget,0) as FirstTarget ' . ", CoCode, CoName " . " FROM Eliminations AS q " . " INNER JOIN Entries AS e ON q.ElId=e.EnId AND EnAthlete=1 " . " INNER JOIN Countries AS c ON e.EnCountry=c.CoId AND e.EnTournament=c.CoTournament " . " LEFT JOIN Session ON ElSession=SesOrder AND ElTournament=SesTournament AND SesType='E' " . " WHERE EnTournament = " . StrSafe_DB($_SESSION['TourId']) . ' ' . (!(empty($_REQUEST['x_From']) && empty($_REQUEST['x_To'])) ? " AND ElTargetNo>='" . str_pad($_REQUEST['x_From'], '3', '0', STR_PAD_LEFT) . "A' AND ElTargetNo<='" . str_pad($_REQUEST['x_To'], '3', '0', STR_PAD_LEFT) . "Z' AND ElElimPhase= " . $_REQUEST['x_Session'] . " " : "") . (!empty($_REQUEST['x_ElimSession']) ? " AND ElSession=" . $_REQUEST['x_ElimSession'] . " " : "") . ' ORDER BY ElSession, SesOrder, ElElimPhase, ElTargetNo ASC, EnFirstName, EnName, CoCode';
$Rs = safe_r_sql($MyQuery);
if (safe_num_rows($Rs) > 0) {
while ($MyRow = safe_fetch($Rs)) {
$Value = array("tNo" => $MyRow->tNo, "startTarget" => substr($MyRow->tNo, 0, -1) * 1, "firstTarget" => $MyRow->FirstTarget, "Cat" => $MyRow->Cat, "Dist" => '', "Ath" => $MyRow->Ath . ' - ' . get_text('Eliminations_' . ($MyRow->ElElimPhase + 1)) . ($MyRow->SesName ? " ({$MyRow->SesName})" : ''), "Noc" => $MyRow->Noc, 'CoCode' => $MyRow->CoCode, 'CoName' => $MyRow->CoName);
if (substr($Value["tNo"], -1, 1) == "A") {
$pdf->AddPage();
$pdf->DrawScoreField(8, 8, 194, 132.5, $NumEnd / 2, 3, $Value);
} elseif (substr($Value["tNo"], -1, 1) == "B") {
$pdf->DrawScoreField(8, 156.5, 194, 132.5, $NumEnd / 2, 3, $Value);
} elseif (substr($Value["tNo"], -1, 1) == "C") {
$pdf->AddPage();
$pdf->DrawScoreField(8, 8, 194, 132.5, $NumEnd / 2, 3, $Value);
}
if (!empty($_REQUEST['QRCode'])) {
$QRCodeX = 0;
$QRCodeY = 0;
$defScoreH -= 11;
$defScoreY2 += 11;
$quanti = count($_REQUEST['QRCode']);
$QRCodeX = ($pdf->GetPageWidth() + 5 - 30 * $quanti) / 2;
}
if (isset($_REQUEST["ScoreDraw"]) && $_REQUEST['ScoreDraw'] == "Draw") {
$pdf->AddPage();
if ($subRule) {
$pdf->DrawScore3D($defScoreX, $defScoreY, $defScoreW, $defScoreH, $NumEnd / 2, array(), false, $Target);
$pdf->DrawScore3D($defScoreX, $defScoreY2, $defScoreW, $defScoreH, $NumEnd / 2, array(), false, $Target);
} else {
$pdf->DrawScoreField($defScoreX, $defScoreY, $defScoreW, $defScoreH, $NumEnd / 2, 2, array(), false);
$pdf->DrawScoreField($defScoreX, $defScoreY2, $defScoreW, $defScoreH, $NumEnd / 2, 2, array(), false);
}
if (!empty($_REQUEST['QRCode'])) {
foreach ($_REQUEST['QRCode'] as $k => $Api) {
require_once 'Api/' . $Api . '/DrawQRCode.php';
$Function = 'DrawQRCode_' . preg_replace('/[^a-z0-9]/sim', '_', $Api);
$Function($pdf, $QRCodeX + 30 * $k, $QRCodeY);
}
}
} else {
$MyQuery = 'SELECT EnCode, EnDivision, EnClass, SUBSTRING(at.AtTargetNo,2) as tNo, CONCAT(EnFirstName,\' \', EnName) AS Ath, CONCAT(CoCode, \' - \', CoName) as Noc, CONCAT(EnDivision, \' \', EnClass) AS Cat, TfName ' . ', CoCode, CoName FROM AvailableTarget as at ';
if (isset($_REQUEST["noEmpty"]) && $_REQUEST["noEmpty"] == 1) {
$MyQuery .= "INNER JOIN\r\n\t\t\t\t(SELECT DISTINCT EnTournament, SUBSTRING(QuTargetNo,1,4) as TgtNo\r\n\t\t\t\tFROM Qualifications\r\n\t\t\t\tINNER JOIN Entries On QuId=EnId\r\n\t\t\t\tWHERE EnTournament = " . StrSafe_DB($_SESSION['TourId']) . " AND EnAthlete=1 AND QuTargetNo>='" . $_REQUEST['x_Session'] . str_pad($_REQUEST['x_From'], TargetNoPadding, "0", STR_PAD_LEFT) . "A' AND QuTargetNo<='" . $_REQUEST['x_Session'] . str_pad($_REQUEST['x_To'], TargetNoPadding, "0", STR_PAD_LEFT) . "Z'\r\n\t\t\t\t) as Tgt ON at.AtTournament=Tgt.EnTournament AND SUBSTRING(at.AtTargetNo,1,4)=Tgt.TgtNo\t";
}
$MyQuery .= " LEFT JOIN " . " (SELECT QuTargetNo, EnCode, EnName, EnFirstName, CoCode, CoName, EnClass, EnDivision, TfName " . " FROM Qualifications AS q " . " INNER JOIN Entries AS e ON q.QuId=e.EnId AND e.EnTournament= " . StrSafe_DB($_SESSION['TourId']) . " AND EnAthlete=1 " . " INNER JOIN Countries AS c ON e.EnCountry=c.CoId AND e.EnTournament=c.CoTournament " . ' INNER JOIN Tournament AS t ON e.EnTournament=t.ToId ' . ' LEFT JOIN TargetFaces ON EnTournament=TfTournament AND EnTargetFace=TfId) as Sq ON at.AtTargetNo=Sq.QuTargetNo' . " WHERE AtTournament = " . StrSafe_DB($_SESSION['TourId']) . ' ' . " AND at.AtTargetNo>='" . $_REQUEST['x_Session'] . str_pad($_REQUEST['x_From'], TargetNoPadding, "0", STR_PAD_LEFT) . "A' AND at.AtTargetNo<='" . $_REQUEST['x_Session'] . str_pad($_REQUEST['x_To'], TargetNoPadding, "0", STR_PAD_LEFT) . "Z' " . ' ORDER BY at.AtTargetNo ASC, EnFirstName, EnName, CoCode';
$pdf->HideLogo();
}
if (isset($_REQUEST["ScoreDraw"]) && $_REQUEST["ScoreDraw"] == "Data") {
$pdf->NoDrawing();
}
if (!empty($_REQUEST['QRCode'])) {
$QRCodeX = 0;
$QRCodeY = 0;
$defScoreH -= 11;
$defScoreY2 += 11;
$quanti = count($_REQUEST['QRCode']);
$QRCodeX = ($pdf->GetPageWidth() + 5 - 30 * $quanti) / 2;
}
if (isset($_REQUEST["ScoreDraw"]) && $_REQUEST['ScoreDraw'] == "Draw") {
$pdf->AddPage();
$pdf->DrawScoreField($defScoreX, $defScoreY, $defScoreW, $defScoreH, $NumEnd / 2, 3, array());
$pdf->DrawScoreField($defScoreX, $defScoreY2, $defScoreW, $defScoreH, $NumEnd / 2, 3, array());
if (!empty($_REQUEST['QRCode'])) {
foreach ($_REQUEST['QRCode'] as $k => $Api) {
require_once 'Api/' . $Api . '/DrawQRCode.php';
$Function = 'DrawQRCode_' . preg_replace('/[^a-z0-9]/sim', '_', $Api);
$Function($pdf, $QRCodeX + 30 * $k, $QRCodeY);
}
}
} else {
$MyQuery = 'SELECT CoCode, CoName, EnCode, EnDivision, EnClass, SUBSTRING(at.AtTargetNo,2) as tNo, CONCAT(EnFirstName,\' \', EnName) AS Ath, CONCAT(CoCode, \' - \', CoName) as Noc, CONCAT(EnDivision, \' \', EnClass) AS Cat, TfName ' . ' FROM AvailableTarget as at ';
if (isset($_REQUEST["noEmpty"]) && $_REQUEST["noEmpty"] == 1) {
$MyQuery .= "INNER JOIN\r\n\t\t\t\t(SELECT DISTINCT EnTournament, SUBSTRING(QuTargetNo,1,4) as TgtNo\r\n\t\t\t\tFROM Qualifications\r\n\t\t\t\tINNER JOIN Entries On QuId=EnId\r\n\t\t\t\tWHERE EnTournament = " . StrSafe_DB($_SESSION['TourId']) . " AND EnAthlete=1 AND QuTargetNo>='" . $_REQUEST['x_Session'] . str_pad($_REQUEST['x_From'], TargetNoPadding, "0", STR_PAD_LEFT) . "A' AND QuTargetNo<='" . $_REQUEST['x_Session'] . str_pad($_REQUEST['x_To'], TargetNoPadding, "0", STR_PAD_LEFT) . "Z'\r\n\t\t\t\t) as Tgt ON at.AtTournament=Tgt.EnTournament AND SUBSTRING(at.AtTargetNo,1,4)=Tgt.TgtNo\t";
}
$MyQuery .= " LEFT JOIN " . " (SELECT QuTargetNo, EnCode, EnName, EnFirstName, CoCode, CoName, EnClass, EnDivision, TfName " . " FROM Qualifications AS q " . " INNER JOIN Entries AS e ON q.QuId=e.EnId AND e.EnTournament= " . StrSafe_DB($_SESSION['TourId']) . " AND EnAthlete=1 " . " INNER JOIN Countries AS c ON e.EnCountry=c.CoId AND e.EnTournament=c.CoTournament " . ' INNER JOIN Tournament AS t ON e.EnTournament=t.ToId ' . ' LEFT JOIN TargetFaces ON EnTournament=TfTournament AND EnTargetFace=TfId) as Sq ON at.AtTargetNo=Sq.QuTargetNo' . " WHERE AtTournament = " . StrSafe_DB($_SESSION['TourId']) . ' ' . " AND at.AtTargetNo>='" . $_REQUEST['x_Session'] . str_pad($_REQUEST['x_From'], TargetNoPadding, "0", STR_PAD_LEFT) . "A' AND at.AtTargetNo<='" . $_REQUEST['x_Session'] . str_pad($_REQUEST['x_To'], TargetNoPadding, "0", STR_PAD_LEFT) . "Z' " . ' ORDER BY at.AtTargetNo ASC, EnFirstName, EnName, CoCode';
//echo $MyQuery;
