<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/pdf/OrisPDF.inc.php';
require_once 'Common/Fun_FormatText.inc.php';
if (!isset($isCompleteResultBook)) {
$pdf = new OrisPDF('C32B', 'Entries by Event');
} else {
$pdf->setOrisCode('', 'Entries by Event');
}
$TmpWhere = "";
if (isset($_REQUEST["CountryName"]) && preg_match("/^[-,0-9A-Z]*\$/i", str_replace(" ", "", $_REQUEST["CountryName"]))) {
foreach (explode(",", $_REQUEST["CountryName"]) as $Value) {
$Tmp = NULL;
if (preg_match("/^([A-Z0-9]*)-([A-Z0-9]*)\$/i", str_replace(" ", "", $Value), $Tmp)) {
$TmpWhere .= "(CoCode >= " . StrSafe_DB(stripslashes($Tmp[1])) . " AND CoCode <= " . StrSafe_DB(stripslashes($Tmp[2] . chr(255))) . ") OR ";
} else {
$TmpWhere .= "CoCode LIKE " . StrSafe_DB(stripslashes(trim($Value)) . "%") . " OR ";
}
}
$TmpWhere = substr($TmpWhere, 0, -3);
}
$MyQuery = "SELECT IFNULL(EvCode,CONCAT(TRIM(EnDivision),TRIM(EnClass))) as EventCode, EnCode as Bib, EnName AS Name, upper(EnFirstName) AS FirstName, QuSession AS Session, SUBSTRING(QuTargetNo,2) AS TargetNo, CoCode AS NationCode, CoName AS Nation, IFNULL(EvEventName,CONCAT('|',DivDescription, '| |', ClDescription)) as EventName, cNumber ";
$MyQuery .= "FROM Entries AS e ";
$MyQuery .= "INNER JOIN Countries AS c ON e.EnCountry=c.CoId AND e.EnTournament=c.CoTournament ";
$MyQuery .= "INNER JOIN Qualifications AS q ON e.EnId=q.QuId ";
$MyQuery .= "INNER JOIN ( ";
$MyQuery .= "SELECT EnCountry AS cCode, COUNT(EnId) AS cNumber FROM `Entries` ";
$MyQuery .= "WHERE EnTournament=" . StrSafe_DB($_SESSION['TourId']) . " GROUP BY EnCountry ";
$MyQuery .= ") as sqy ON e.EnCountry=sqy.cCode ";
$MyQuery .= "LEFT JOIN Individuals AS i on e.EnId=i.IndId AND e.EnTournament=i.IndTournament ";
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/pdf/OrisPDF.inc.php';
require_once 'Common/Fun_FormatText.inc.php';
require_once 'Common/OrisFunctions.php';
require_once 'Common/pdf/PdfChunkLoader.php';
// ATTENTION!
// MUST BE called $PdfData
$PdfData = getStartListByCountries(true, isset($_GET['Athletes']));
if (!isset($isCompleteResultBook)) {
$pdf = new OrisPDF($PdfData->Code, $PdfData->Description);
} else {
$pdf->setOrisCode('', $PdfData->Description);
}
require_once PdfChunkLoader('OrisCountry.inc.php');
if (!isset($isCompleteResultBook)) {
if (isset($_REQUEST['ToFitarco'])) {
$Dest = 'D';
if (isset($_REQUEST['Dest'])) {
$Dest = $_REQUEST['Dest'];
}
$pdf->Output($_REQUEST['ToFitarco'], $Dest);
} else {
$pdf->Output();
}
}
function OrisBracketPDF($DocNumber, $DocTitle, $Headers = '')
{
//$this->__construct('P','mm','A4');
parent::__construct($DocNumber, $DocTitle, $Headers);
$this->SetAutoPageBreak(false);
}
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/pdf/OrisPDF.inc.php';
require_once 'Common/Fun_FormatText.inc.php';
$isCompleteResultBook = true;
$pdf = new OrisPDF('C95', 'Medal Standings');
include 'OrisMedalStanding.php';
include 'OrisMedalList.php';
if (isset($_REQUEST['ToFitarco'])) {
$Dest = 'D';
if (isset($_REQUEST['Dest'])) {
$Dest = $_REQUEST['Dest'];
}
$pdf->Output($_REQUEST['ToFitarco'], $Dest);
} else {
$pdf->Output();
}
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
include_once 'Common/pdf/OrisPDF.inc.php';
$pdf = new OrisPDF(get_text('DailySchedule', 'Tournament'), false);
//Genero la query
$MyQuery = "SELECT f.FinEvent AS Event, " . " EvEventName AS EventDescr," . " f.FinMatchNo," . " EvFinalFirstPhase, " . " IF(GrPhase!=0,GrPhase,1) as Phase, " . " (GrPhase=1) as Finalina, " . " I1.IndRank as Rank, " . " Q1.QuScore, " . " E1.EnFirstName as FirstName, " . " E1.EnName as Name, " . " C1.CoCode as Country, " . " I2.IndRank OppRank, " . " Q2.QuScore OppQuScore, " . " E2.EnFirstName as OppFirstName, " . " E2.EnName as OppName, " . " C2.CoCode as OppCountry, " . " IF(EvMatchMode=0,f.FinScore,f.FinSetScore) AS Score, " . " f.FinTie," . " f.FinTiebreak," . " IF(EvMatchMode=0,f2.FinScore,f2.FinSetScore) as OppScore," . " f2.FinTie as OppTie," . " f.FinSetPoints as SetPoints, " . " GrPosition," . " EvFinalPrintHead," . " fs1.FSTarget," . " fs2.FSTarget OppFSTarget," . " DATE_FORMAT(fs1.FSScheduledDate,'" . get_text('DateFmtDB') . "') as ScheduledDate," . " DATE_FORMAT(fs1.FSScheduledTime,'" . get_text('TimeFmt') . "') AS ScheduledTime " . "FROM Finals AS f " . "INNER JOIN Finals AS f2 ON f.FinEvent=f2.FinEvent AND f.FinMatchNo=f2.FinMatchNo-1 AND f.FinTournament=f2.FinTournament " . "INNER JOIN Events ON f.FinEvent=EvCode AND f.FinTournament=EvTournament AND EvTeamEvent=0 " . "INNER JOIN Grids ON f.FinMatchNo=GrMatchNo " . "INNER JOIN Entries E1 ON f.FinAthlete=E1.EnId AND f.FinTournament=E1.EnTournament " . "INNER JOIN Qualifications Q1 ON E1.EnId=Q1.QuId " . "INNER JOIN Individuals I1 ON I1.IndId=f.FinAthlete AND I1.IndEvent=f.FinEvent AND I1.IndTournament=f.FinTournament " . "INNER JOIN Countries C1 ON E1.EnCountry=C1.CoId AND E1.EnTournament=C1.CoTournament " . "INNER JOIN Entries E2 ON f2.FinAthlete=E2.EnId AND f2.FinTournament=E2.EnTournament " . "INNER JOIN Qualifications Q2 ON E2.EnId=Q2.QuId " . "INNER JOIN Individuals I2 ON I2.IndId=f2.FinAthlete AND I2.IndEvent=f2.FinEvent AND I2.IndTournament=f2.FinTournament " . "INNER JOIN Countries C2 ON E2.EnCountry=C2.CoId AND E2.EnTournament=C2.CoTournament " . "INNER JOIN FinSchedule fs1 ON f.FinEvent=fs1.FSEvent AND f.FinMatchNo=fs1.FSMatchNo AND f.FinTournament=fs1.FSTournament AND fs1.FSTeamEvent='0' " . "INNER JOIN FinSchedule fs2 ON f.FinEvent=fs2.FSEvent AND f.FinMatchNo=fs2.FSMatchNo AND f.FinTournament=fs2.FSTournament AND fs2.FSTeamEvent='0' " . "WHERE f.FinTournament = " . StrSafe_DB($_SESSION['TourId']) . " " . " AND f.FinMatchNo%2 = 0 ";
if (!empty($_REQUEST['Event'])) {
$MyQuery .= CleanEvents($_REQUEST['Event'], 'f.FinEvent');
}
$MyQuery .= "ORDER BY fs1.FSScheduledDate, fs1.FSScheduledTime, EvProgr ASC, EvCode, Phase DESC, f.FinMatchNo ASC ";
//$MyQuery = "($MyQuery) union (";
$Rs = safe_r_sql($MyQuery);
$pdf->SetMargins(10, 35, 10);
$pdf->AddPage();
$W = $pdf->getPageWidth();
$W = ($W - 100 - 20) / 2;
$pdf->SetLineWidth(0.1);
$pdf->SetFontSize(15);
$pdf->SetFont('', 'b');
$pdf->Cell($pdf->getPageWidth() - 20, 5, get_text('DailySchedule', 'Tournament'), 0, 1, 'C');
$pdf->sety($pdf->gety() + 5);
$pdf->SetFontSize(10);
$oldDate = '';
$oldTime = '';
$oldEvent = '';
$oldPhase = '';
$Date = '';
$Time = '';
$Event = '';
$Phase = '';
<?php
require_once dirname(dirname(__FILE__)) . '/config.php';
require_once 'Common/pdf/OrisPDF.inc.php';
require_once 'Common/Fun_FormatText.inc.php';
require_once 'Common/OrisFunctions.php';
require_once 'Common/pdf/PdfChunkLoader.php';
// ATTENTION!
// MUST BE called $PdfData
$PdfData = getStartList(true, '', true);
if (!isset($isCompleteResultBook)) {
$pdf = new OrisPDF('C51A', 'Start List by Target');
} else {
$pdf->setOrisCode('', 'Start List by Target');
}
require_once PdfChunkLoader('OrisElimStartList.inc.php');
if (!isset($isCompleteResultBook)) {
if (isset($_REQUEST['ToFitarco'])) {
$Dest = 'D';
if (isset($_REQUEST['Dest'])) {
$Dest = $_REQUEST['Dest'];
}
$pdf->Output($_REQUEST['ToFitarco'], $Dest);
} else {
$pdf->Output();
}
}
