<?php require_once dirname(dirname(__FILE__)) . '/config.php'; require_once 'Common/pdf/LabelPDF.inc.php'; require_once 'CommonCard.php'; $Rs = safe_r_sql($MyQuery); if (!safe_num_rows($Rs)) { include 'Common/Templates/head-popup.php'; echo '<table height="' . ($_SESSION['WINHEIGHT'] - 50) . '" width="100%"><tr><td>'; echo '<div align="center">' . get_text('BadgeNoData', 'Tournament') . ''; echo '<br/><br/><input type="button" onclick="window.close();" value="' . get_text('Close') . '">'; echo '</td></tr></table>'; include 'Common/Templates/tail-popup.php'; die; } $pdf = new LabelPDF(); $pdf->SetAutoPageBreak(false); $pdf->setPrintHeader(false); $pdf->setPrintFooter(false); $cntPass = 0; $ImgSxSize = NULL; $ImgDxSize = NULL; $ImgLowSize = NULL; if (!empty($pdf->ToPaths['ToLeft'])) { $ImgSxSize = getimagesize($pdf->ToPaths['ToLeft']); } if (!empty($pdf->ToPaths['ToRight'])) { $ImgDxSize = getimagesize($pdf->ToPaths['ToRight']); } if (!empty($pdf->ToPaths['ToBottom'])) { $ImgLowSize = getimagesize($pdf->ToPaths['ToBottom']);
$MyQuery .= "WHERE EnAthlete=1 AND EnTournament = " . StrSafe_DB($_SESSION['TourId']) . " "; if (isset($_REQUEST["Session"]) && is_numeric($_REQUEST["Session"])) { $MyQuery .= "AND QuSession = " . StrSafe_DB($_REQUEST["Session"]) . " "; } if ($TmpWhere != "") { $MyQuery .= "AND (" . $TmpWhere . ")"; } $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);
---Label Width * 2.5935 ---Label Height Detail – Height 1 Top Margin Report – Top Margin 0.5 Right Margin Report – Right Margin 0.5 Bottom Margin Report – Bottom Margin 0.1875 Left Margin Report – Left Margin 0.1875 Columns Report – Column Count 3 Horizontal Spacing Report – Column Spacing 0.15625 * */ $OpDetails = "Accreditation"; if (isset($_REQUEST["OperationType"])) { $OpDetails = $_REQUEST["OperationType"]; } if (CheckTourSession()) { $pdf = new LabelPDF(); //Predefinita per etichette A4 $lblW = $pdf->GetPageWidth() / 3; $lblH = $pdf->GetPageHeight() / 8; $lblMarginH = 2; $lblMarginV = 2; $lblSpaceV = 0; $lblSpaceH = 0; $pageMarginT = 0; $pageMarginL = 0; $Label4Column = 3; $Label4Page = 24; $printBarcode = true; if (intval($pdf->GetPageWidth()) == 210 && intval($pdf->GetPageHeight()) == 297) { $lblMarginH = 4; $lblMarginV = 4;
if (isset($_REQUEST["OperationType"])) { $OpDetails = $_REQUEST["OperationType"]; } if ($_POST) { require_once 'Common/pdf/LabelPDF.inc.php'; $IncludeBarCode = true; $MarLeftRight = 0; $MarTop = 0; $MarBottom = 0; $StickXRows = 0; $StickXCols = 0; $ColIntMargin = 0; $RowIntMargin = 0; $PaperHeight = 0; $PaperWidth = 0; $pdf = new LabelPDF(); $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 "; $MyQuery .= "FROM AvailableTarget at "; $MyQuery .= "INNER JOIN Qualifications AS q ON at.AtTargetNo=q.QuTargetNo "; $MyQuery .= "INNER JOIN Entries AS e ON q.QuId=e.EnId AND e.EnTournament=at.AtTournament AND EnAthlete=1 "; $MyQuery .= "INNER JOIN Countries AS c ON e.EnCountry=c.CoId AND e.EnTournament=c.CoTournament "; $MyQuery .= "LEFT JOIN AccEntries AS ae ON e.EnId=ae.AEId AND e.EnTournament=ae.AETournament "; $MyQuery .= "AND ae.AEOperation=(SELECT AOTId FROM AccOperationType WHERE AOTDescr=" . StrSafe_DB($OpDetails) . ") "; $MyQuery .= "WHERE AtTournament = " . StrSafe_DB($_SESSION['TourId']) . " "; if (isset($_REQUEST["Session"]) && is_numeric($_REQUEST["Session"])) { $MyQuery .= "AND SUBSTRING(AtTargetNo,1,1) = " . StrSafe_DB($_REQUEST["Session"]) . " "; } //$MyQuery .= "AND AtTargetNo IN ('145B','145D','146D','149D','151C','152A') ";
<?php require_once dirname(dirname(__FILE__)) . '/config.php'; require_once 'Common/pdf/LabelPDF.inc.php'; require_once 'Common/Fun_Sessions.inc.php'; $Indices = array('bis', 'ter', 'quat', 'quin', 'sex', 'sept', 'oct'); if (CheckTourSession()) { $pdf = new LabelPDF(); $ath4target = 0; $ses = GetSessions('Q'); foreach ($ses as $s) { $ath4target = max($ath4target, $s->SesAth4Target); } $MyQuery = "SELECT EnName AS Name, EnFirstName AS FirstName, SUBSTRING(ElTargetNo,1,1) AS Session, SUBSTRING(ElTargetNo,2,2) AS TargetNo, SUBSTRING(ElTargetNo,-1,1) AS BackNo " . " FROM Eliminations AS q " . " INNER JOIN Entries AS e ON q.ElId=e.EnId AND EnAthlete=1 " . " INNER JOIN Countries AS c ON e.EnCountry=c.CoId AND e.EnTournament=c.CoTournament " . " LEFT JOIN Session ON ElSession=SesOrder AND ElTournament=SesTournament AND SesType='E' " . " WHERE EnTournament = " . StrSafe_DB($_SESSION['TourId']) . ' ' . (!(empty($_REQUEST['x_From']) && empty($_REQUEST['x_To'])) ? " AND ElTargetNo>='" . str_pad($_REQUEST['x_From'], '3', '0', STR_PAD_LEFT) . "A' AND ElTargetNo<='" . str_pad($_REQUEST['x_To'], '3', '0', STR_PAD_LEFT) . "Z' AND ElElimPhase= " . $_REQUEST['x_Session'] . " " : "") . (!empty($_REQUEST['x_ElimSession']) ? " AND ElSession=" . $_REQUEST['x_ElimSession'] . " " : "") . ' ORDER BY ElSession, SesOrder, ElElimPhase, ElTargetNo ASC, EnFirstName, EnName, CoCode'; //echo $MyQuery;exit; $Rs = safe_r_sql($MyQuery); if ($Rs) { $Etichetta = -1; $CurrentTarget = 0; $NewTarget = true; $CurHeight = 0; $BlockHeight = ($pdf->getPageHeight() - 30) / 4; $CellHeight = $BlockHeight / ($ath4target + 1); while ($MyRow = safe_fetch($Rs)) { $NumEnd = $MyRow->Session == 0 ? 12 : 8; $TargetToPrint = $MyRow->TargetNo; $NumTarget = intval($MyRow->TargetNo); if ($NumTarget > $NumEnd) { $NumTarget = ($NumTarget - 1) % $NumEnd + 1; } if ($MyRow->TargetNo and $NumTarget != intval($MyRow->TargetNo)) {
* * Page / Label Dimensions Report Builder Fields Avery 5160 (inches) ---Page Width Report – Page Width 8.5 ---Page Height Report – Page Height 11 ---Label Width * 2.5935 ---Label Height Detail – Height 1 Top Margin Report – Top Margin 0.5 Right Margin Report – Right Margin 0.5 Bottom Margin Report – Bottom Margin 0.1875 Left Margin Report – Left Margin 0.1875 Columns Report – Column Count 3 Horizontal Spacing Report – Column Spacing 0.15625 * */ if (CheckTourSession()) { $pdf = new LabelPDF(); //Predefinita per etichette A4 $lblW = $pdf->GetPageWidth() / 3; $lblH = $pdf->GetPageHeight() / 8; $lblMarginH = 2; $lblMarginV = 2; $lblSpaceV = 0; $lblSpaceH = 0; $pageMarginT = 0; $pageMarginL = 0; $Label4Column = 3; $Label4Page = 24; $printBarcode = true; if (intval($pdf->GetPageWidth()) == 210 && intval($pdf->GetPageHeight()) == 297) { $lblMarginH = 4; $lblMarginV = 4;
$AcMeal = getimagesize($CFG->DOCUMENT_PATH . 'Common/Images/AcMeal.png'); $AcAccomodation = getimagesize($CFG->DOCUMENT_PATH . 'Common/Images/AcAccomodation.png'); $AcHeight = $AcAccomodation[1]; $OffsetX = explode(';', $_REQUEST['IdCardsSettings']['OffsetX']); $OffsetY = explode(';', $_REQUEST['IdCardsSettings']['OffsetY']); $PageWidth = $_REQUEST['IdCardsSettings']['PaperWidth']; $PageHeight = $_REQUEST['IdCardsSettings']['PaperHeight']; foreach ($OffsetY as $y) { foreach ($OffsetX as $x) { $Badges[] = array($x, $y); } } $BadgePerPage = count($Badges); $Just = array('L', 'C', 'R'); $cntPass = 0; $pdf = new LabelPDF($PageWidth, $PageHeight); // get the background of the card $q = safe_r_SQL("select * from IdCards where IcTournament={$_SESSION['TourId']}"); $BackGround = safe_fetch($q) or debug_svela('Error in Accreditation!'); $BackGround->Options = unserialize($BackGround->IcSettings); $Elements = array(); $q = safe_r_SQL("select * from IdCardElements where IceTournament={$_SESSION['TourId']} order by IceOrder"); while ($r = safe_fetch($q)) { $r->Options = unserialize($r->IceOptions); if (!empty($r->Options['Font'])) { $r->Options['FontFamily'] = $pdf->addTTFfont(K_PATH_FONTS . $r->Options['Font'] . '.ttf'); $r->Options['FontStyle'] = (substr($r->Options['Font'], -2, 1) == 'b' ? 'B' : '') . (substr($r->Options['Font'], -1, 1) == 'i' ? 'I' : ''); } if ($r->IceType == 'Accomodation') { // calculate the final dimentions regard the space we have.... $OrgAcScaleFactor = ($r->Options['H'] - 4) / $AcHeight;
<?php require_once dirname(dirname(__FILE__)) . '/config.php'; require_once 'Common/pdf/LabelPDF.inc.php'; require_once 'CommonCard.php'; $Rs = safe_r_sql($MyQuery); if (!safe_num_rows($Rs)) { include 'Common/Templates/head-popup.php'; echo '<table height="' . ($_SESSION['WINHEIGHT'] - 50) . '" width="100%"><tr><td>'; echo '<div align="center">' . get_text('BadgeNoData', 'Tournament') . ''; echo '<br/><br/><input type="button" onclick="window.close();" value="' . get_text('Close') . '">'; echo '</td></tr></table>'; include 'Common/Templates/tail-popup.php'; die; } $pdf = new LabelPDF(); $pdf->SetAutoPageBreak(false); $pdf->setPrintHeader(false); $pdf->setPrintFooter(false); $AccW = ($pdf->getPageWidth() - 13) / 2 - 10; $AccH = ($pdf->getPageHeight() - 50) / 3 - 10; $XOffset = array(0, $AccW + 10); $YOffset = array(0, 0, $AccH + 10, $AccH + 10, $AccH * 2 + 20, $AccH * 2 + 20); $CardsPerWidth = 2; $CardsPerPage = 6; $FlagHeight = 12; $cntPass = 0; $ImgSxSize = NULL; $ImgDxSize = NULL; $ImgLowSize = NULL; $ImgLWidth = 0;
} if ($_POST) { require_once 'Common/pdf/LabelPDF.inc.php'; $IncludePicture = !empty($_REQUEST['sticker_Picture']); $IncludeBarCode = !empty($_REQUEST['sticker_BarCode']); $Unit = $_REQUEST['sticker_Unit']; $MarTop = $_REQUEST['sticker_Top']; $MarLeftRight = $_REQUEST['sticker_Side']; $MarBottom = $_REQUEST['sticker_Bot']; $StickRows = $_REQUEST['sticker_Y']; $StickCols = $_REQUEST['sticker_X']; $ColIntMargin = $_REQUEST['sticker_InterCols']; $RowIntMargin = $_REQUEST['sticker_InterRows']; $PaperHeight = $_REQUEST['sticker_PageHeight']; $PaperWidth = $_REQUEST['sticker_PageWidth']; $pdf = new LabelPDF(); if ($IncludePicture) { include_once 'Common/CheckPictures.php'; CheckPictures('', true, false, true); // cancella le foto più vecchie di 1 giorno // prints all the pictures in the size specified... $MySQL = "select" . " PhEnId, concat(CoCode, ' (', EnCode, '-', EnFirstName, ')') code " . "from" . " Photos" . " inner join Entries on EnId=PhEnId " . " inner join Countries on EnCountry=CoId " . " left join Qualifications on EnId=QuId " . "where" . " EnTournament={$_SESSION['TourId']} " . (isset($_REQUEST["Session"]) && is_numeric($_REQUEST["Session"]) ? " AND SUBSTRING(QuTargetNo,1,1) = " . StrSafe_DB($_REQUEST["Session"]) . " " : '') . " and PhPhoto>'' order by code"; $q = safe_r_sql($MySQL); $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);