예제 #1
0
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;
예제 #2
0
    $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 ";