$pdf->addpage();
$NumCols = floor(($PaperWidth - 2 * $MarLeftRight) / max(1, $StickCols));
$HGap = ($PaperWidth - 2 * $MarLeftRight - $NumCols * $StickCols) / ($NumCols - 1);
$NumRows = floor(($PaperHeight - $MarTop - $MarTop) / max(1, $StickRows + 3));
$VGap = ($PaperHeight - $MarTop - $MarTop - $NumRows * ($StickRows + 3)) / ($NumRows - 1);
$X = $MarLeftRight;
$Y = $MarTop;
$pdf->SetFontSize(7);
error_reporting(E_ALL);
while ($r = safe_fetch($q)) {
if (!is_file($file = $CFG->DOCUMENT_PATH . 'TV/Photos/' . $_SESSION['TourCodeSafe'] . '-En-' . $r->PhEnId . '.jpg')) {
continue;
}
$pdf->Image($file, $X, $Y, $StickCols, $StickRows, 'JPG', '', '', true, 300, '', false, false, 1, true);
$pdf->setXY($X, $Y + $StickRows);
$pdf->cell($StickCols, 3, $r->code, '', '', 'C', '', '', 1);
$X += $StickCols + $HGap;
if ($X + $StickCols > $PaperWidth) {
$X = $MarLeftRight;
$Y += $StickRows + $VGap + 3;
if ($Y + $StickRows > $PaperHeight) {
$Y = $MarTop;
$pdf->addpage();
}
}
}
} else {
$lblW = $pdf->GetPageWidth() / 3;
$lblH = $pdf->GetPageHeight() / 8;
$lblSp = $lblH * 0.05;
$MyQuery = "SELECT EnId, EnName AS Name, upper(EnFirstName) AS FirstName, SUBSTRING(AtTargetNo,1,1) AS Session, SUBSTRING(AtTargetNo,2," . (TargetNoPadding + 1) . ") AS TargetNo, CoCode AS NationCode, CoName AS Nation, EnClass AS ClassCode, EnDivision AS DivCode, EnStatus as Status, EnIndClEvent AS `IC`, EnTeamClEvent AS `TC`, EnIndFEvent AS `IF`, EnTeamFEvent as `TF`, if(AEId IS NULL, 0, 1) as OpDone ";
