$pdf->SetFont('', 'B', 12); $pdf->Cell($AccW, $AccH * 0.05, $pdf->Name, 0, 0, 'C', 0); $pdf->Rect($PosX, $PosY + $AccH * 0.05, $AccW, $AccH * 0.2, 'F', array(), $AccColor); $tmpX = $PosX + 2; if (!is_null($ImgSxSize)) { //Immagine Sinistra if ($ImgSxSize[0] / $ImgSxSize[1] <= ($AccW * 0.4 - 4) / ($AccH * 0.2 - 4)) { //Immagine troppo larga $pdf->Image($pdf->ToPaths['ToLeft'], $tmpX, $PosY + $AccH * 0.05 + 2, 0, $AccH * 0.2 - 4); } else { $pdf->Image($pdf->ToPaths['ToLeft'], $tmpX, $PosY + $AccH * 0.05 + ($AccW * 0.4 - 4) / $ImgSxSize[0] * $ImgSxSize[1] / 2 / $pdf->getScaleFactor(), $AccW * 0.4 - 4, 0); } $tmpX = $pdf->getImageRBX() + 2; } if ($MyRow->AcTitleReverse) { $pdf->SetTextColor(255); } $pdf->SetFont('', 'B', 16); //Cognome e Nome $pdf->SetXY($tmpX, $PosY + $AccH * 0.08); $pdf->Cell($AccW + 2 - $tmpX - $PosX, $AccH * 0.07000000000000001, $MyRow->FirstName, 0, 0, 'C', 0); $pdf->SetXY($tmpX, $PosY + $AccH * 0.15); $pdf->Cell($AccW + 2 - $tmpX - $PosX, $AccH * 0.07000000000000001, $MyRow->Name, 0, 0, 'C', 0); $pdf->SetDefaultColor(); $pdf->SetXY($PosX, $PosY + $AccH * 0.25); //Luogo $pdf->SetFont('', '', 7); $pdf->Cell($AccW, $AccH * 0.02, $pdf->Where . ", " . TournamentDate2String($pdf->WhenF, $pdf->WhenT), 0, 0, 'C', 0); //SPAZIO BIANCO DI RISPETTO: Altezza 2/20 (totale 8/20, ne restano 12/20) //SECONDA Area dell'accredito: Logo DX e Nome/Country/Categoria/Photo - Altezza 7/20 (totale 15/20, ne restano 5/20) $tmpX = $PosX + 2;
$MyQuery .= "ORDER BY QuSession, FirstName, Name, TargetNo "; //print $MyQuery;exit; //print '<br><br>'.$MyQuery;exit; $PosX = array(6, 111, 6, 111); $PosY = array(6, 6, 155, 155); //echo $MyQuery; $Rs = safe_r_sql($MyQuery); if (safe_num_rows($Rs) > 0) { $pdf = new LabelPDF(); // 'P','mm','A4'); $pdf->AliasNbPages(); $pdf->setPrintHeader(false); $pdf->setPrintFooter(false); $pdf->SetMargins(6, 6, 6); $pdf->SetAutoPageBreak(false, 15); $pdf->SetTextColor(0x0, 0x0, 0x0); $i = 0; while ($MyRow = safe_fetch($Rs)) { $pdf->SetFont($pdf->FontStd, 'B', 18); if ($i % 4 == 0) { $pdf->AddPage(); //Crop Mark $pdf->Line(2, 148.5, 5, 148.5); $pdf->Line(103, 148.5, 107, 148.5); $pdf->Line(205, 148.5, 208, 148.5); $pdf->Line(105, 2, 105, 5); $pdf->Line(105, 146.5, 105, 150.5); $pdf->Line(105, 292, 105, 295); } $myPosX = $PosX[$i % 4]; $myPosY = $PosY[$i % 4];