//echo $MyQuery;exit; $Rs = safe_r_sql($MyQuery); $pdf->SetDataHeader(array("NOC", "Country", "Back No.", "Name"), array(20, 40, 20, 110)); if ($Rs) { $OldTeam = '#@#@#'; $OldEvent = '#@#@#'; while ($MyRow = safe_fetch($Rs)) { if ($OldEvent != $MyRow->EventCode) { $pdf->setEvent(get_text($MyRow->EventName, '', '', true)); $pdf->AddPage(); $pdf->setOrisCode('C32B', 'Entries by Event'); $OldTeam = '#@#@#'; $OldEvent = $MyRow->EventCode; } if ($OldTeam != $MyRow->NationCode) { $pdf->SamePage($MyRow->cNumber + 1); $pdf->lastY += 3.5; $pdf->printDataRow(array($MyRow->NationCode, $MyRow->Nation, $MyRow->TargetNo, $MyRow->FirstName . ' ' . $MyRow->Name)); $OldTeam = $MyRow->NationCode; } else { $pdf->printDataRow(array("", "", $MyRow->TargetNo, $MyRow->FirstName . ' ' . $MyRow->Name)); } } } if (!isset($isCompleteResultBook)) { if (isset($_REQUEST['ToFitarco'])) { $Dest = 'D'; if (isset($_REQUEST['Dest'])) { $Dest = $_REQUEST['Dest']; } $pdf->Output($_REQUEST['ToFitarco'], $Dest);
$pdf->Cell(13, 6, get_text('Date', 'Tournament'), 1, 0, 'L'); $pdf->Cell(8, 6, get_text('Time', 'Tournament'), 1, 0, 'L'); $pdf->Cell(25, 6, get_text('Event'), 1, 0, 'L'); $pdf->Cell(6, 6, get_text('Phase'), 1, 0, 'L'); $pdf->Cell(6, 6, get_text('MatchNo'), 1, 0, 'L'); //$pdf->Cell(3, 4, get_text('Court', 'Tournament'), 1, 0, 'L'); $pdf->Cell(5, 6, get_text('Rank'), 1, 0, 'L'); $pdf->Cell($W + 10, 6, get_text('ParticipantSchedule', 'Tournament', 1), 1, 0, 'L'); $pdf->Cell(6, 6, get_text('TargetShort', 'Tournament'), 1, 0, 'L'); $pdf->Cell(5, 6, get_text('Rank'), 1, 0, 'L'); $pdf->Cell($W + 10, 6, get_text('ParticipantSchedule', 'Tournament', 2), 1, 0, 'L'); $pdf->Cell(6, 6, get_text('TargetShort', 'Tournament'), 1, 1, 'L'); $pdf->SetFont('', ''); $header = false; } if (!$pdf->SamePage(8)) { $DateBorder .= 'B'; $TimeBorder .= 'B'; $EventBorder .= 'B'; $PhaseBorder .= 'B'; $header = true; } $pdf->Cell(13, 5, $Date, $DateBorder, 0, 'L'); $pdf->Cell(8, 5, $Time, $TimeBorder, 0, 'L'); $pdf->Cell(25, 5, $Event, $EventBorder, 0, 'L'); $pdf->Cell(6, 5, $Phase, $PhaseBorder, 0, 'C'); $pdf->Cell(6, 5, $r->FinMatchNo / 2 + 1, 1, 0, 'R'); // $pdf->Cell(3, 4, '', 1, 0, 'L'); $pdf->Cell(5, 5, $r->Rank, 1, 0, 'L'); $pdf->Cell($W, 5, strtoupper($r->FirstName) . ' ' . $r->Name, 1, 0, 'L'); $pdf->Cell(10, 5, $r->Country, 1, 0, 'L');