Esempio n. 1
0
 if (!$Rows) {
     continue;
 }
 if ($n > 1) {
     $TopPos += 2;
 }
 if (!$pdf->SamePage(12 * count($Rows) + 12)) {
     $pdf->addpage();
     $TopPos = 35;
 }
 $pdf->SetXY(10, $TopPos);
 $pdf->SetFont($pdf->FontStd, 'I', 12);
 $pdf->Cell($pdf->GetPageWidth() - 20, 7, get_text('Distance', 'Tournament') . ": " . $n, 0, 0, "C", 1);
 $TopPos += 8;
 // prints the targets
 $pdf->SetCellPadding(0);
 foreach ($Rows as $Distance => $TarTypes) {
     // prints the distance
     if (!$pdf->SamePage(15)) {
         $pdf->addpage();
         $TopPos = 35;
     }
     $pdf->SetTextColor(0);
     $pdf->SetXY(10, $TopPos);
     $pdf->SetFont($pdf->FontStd, 'B', 14);
     $pdf->Cell(ColName, 12, $Distance, 0, 0, "L");
     foreach ($TarTypes as $TarDesc => $TarDims) {
         foreach ($TarDims as $TarDim => $Groups) {
             foreach ($Groups as $Targets) {
                 // prints the target numbers
                 $pdf->SetTextColor(0);
Esempio n. 2
0
            $DayLastTargets[$r->FSScheduledDate] = max($r->B, $DayLastTargets[$r->FSScheduledDate]);
        }
    }
    $FirstTarget = min($DayFirstTargets);
    $LastTarget = max($DayLastTargets);
}
if (!$FirstTarget and !$LastTarget) {
    exit;
}
list($a, $FirstTarget) = each($DayFirstTargets);
list($a, $LastTarget) = each($DayLastTargets);
// $FirstTarget=1; // che senso ha???
// debug_svela($DayFirstTargets);
$pdf = new ResultPDF(get_text('FopSetup'), $LastTarget - $FirstTarget < 21);
error_reporting(E_ALL);
$pdf->SetCellPadding(0.25);
$DimTarget = min(10, ($pdf->getpagewidth() - 20 - ColName) / ($LastTarget - $FirstTarget + 1));
$MyQuery = "(SELECT '' as Warmup, FSEvent," . " FSTeamEvent," . " GrPhase," . " FsMatchNo," . " FsTarget," . " '' as TargetTo," . " EvMatchArrowsNo, EvMatchMode, EvMixedTeam, EvTeamEvent, " . " UNIX_TIMESTAMP(FSScheduledDate) as SchDate," . " DATE_FORMAT(FSScheduledTime,'" . get_text('TimeFmt') . "') as SchTime, " . " EvFinalFirstPhase," . " @bit:=pow(2, ceil(log2(GrPhase))+1) & EvMatchArrowsNo," . " IF(@bit=0,EvFinEnds,EvElimEnds) AS `ends`," . " IF(@bit=0,EvFinArrows,EvElimArrows) AS `arrows`," . " IF(@bit=0,EvFinSO,EvElimSO) AS `so`," . " EvMaxTeamPerson," . " FSScheduledDate," . " FSScheduledTime, EvDistance " . " FROM FinSchedule" . " INNER JOIN Grids ON FSMatchNo=GrMatchNo" . " INNER JOIN Events ON FSEvent=EvCode AND FSTeamEvent=EvTeamEvent AND FSTournament=EvTournament " . " WHERE FSTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND (FSScheduledDate!='0000-00-00' && (FSTarget*1)>0) AND GrPhase<=if(EvFinalFirstPhase=24, 32, if(EvFinalFirstPhase=48, 64, EvFinalFirstPhase)) " . ") UNION (" . "SELECT '1' as Warmup, '" . get_text('WarmUp', 'Tournament') . "'," . " ''," . " FwEvent ," . " ''," . " FwTargets, " . " FwOptions," . " '--' as EvMatchArrowsNo, 0 as EvMatchMode, 0, 0, " . " UNIX_TIMESTAMP(FwDay) as SchDate," . " DATE_FORMAT(FwTime,'" . get_text('TimeFmt') . "') as SchTime," . " 0," . " 0," . " 0 AS `ends`," . " 0 AS `arrows`," . " 0 AS `so`," . " 0," . " FwDay," . " FwTime, EvDistance " . " FROM FinWarmup" . " INNER JOIN Events ON FwEvent=EvCode AND FwTeamEvent=EvTeamEvent AND FwTournament=EvTournament " . " WHERE FwTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND FwDay>0 and FwTargets>''" . " )" . " ORDER BY FSScheduledDate ASC, FSScheduledTime ASC, Warmup ASC, FSTarget ASC, FSMatchNo ASC";
// 	debug_svela($MyQuery);
$Rs = safe_r_sql($MyQuery);
if (safe_num_rows($Rs) > 0) {
    $OldSched = '';
    $OldDate = '';
    $OldEvent = '';
    $OldTarget = '';
    $TmpColor = array(255, 255, 255);
    $PrintEvent = true;
    $TgText = '';
    $TgFirst = 0;
    $TgNo = 0;
    $TgTop = 0;