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;
} else {
$lblW = 2.5935 * 25.4;
$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') ";
$MyQuery .= "ORDER BY AtTargetNo, CoCode, Name, CoName, FirstName ";