nl.detoren.ijc.io.OutputIntekenlijst.java Source code

Introduction

Here is the source code for nl.detoren.ijc.io.OutputIntekenlijst.java

Source

/**
 * Copyright (C) 2016 Leo van der Meulen
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation version 3.0
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * See: http://www.gnu.org/licenses/gpl-3.0.html
 *
 * Problemen in deze code:
 */
package nl.detoren.ijc.io;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.math.BigInteger;
import java.util.logging.Level;
import java.util.logging.Logger;

import org.apache.poi.xwpf.usermodel.BreakType;
import org.apache.poi.xwpf.usermodel.XWPFDocument;
import org.apache.poi.xwpf.usermodel.XWPFParagraph;
import org.apache.poi.xwpf.usermodel.XWPFRun;
import org.openxmlformats.schemas.wordprocessingml.x2006.main.CTPPr;
import org.openxmlformats.schemas.wordprocessingml.x2006.main.CTSpacing;
import org.openxmlformats.schemas.wordprocessingml.x2006.main.STLineSpacingRule;

import nl.detoren.ijc.data.groepen.Groep;
import nl.detoren.ijc.data.groepen.Groepen;
import nl.detoren.ijc.data.groepen.Speler;
import nl.detoren.ijc.ui.control.IJCController;
import nl.detoren.ijc.ui.util.Utils;

public class OutputIntekenlijst implements GroepenExportInterface {

    private final static Logger logger = Logger.getLogger(OutputIntekenlijst.class.getName());

    public boolean export(Groepen groepen) {
        try {
            logger.log(Level.INFO, "Wedstrijden wegschrijven naar Excel");
            FileInputStream file = new FileInputStream("Leeg.docx");
            XWPFDocument document = new XWPFDocument(file);
            XWPFParagraph paragraph = document.getLastParagraph();
            setDoubleLineSpacing(paragraph);
            XWPFRun run = paragraph.createRun();
            run.setFontFamily("Courier New");
            run.setFontSize(12);
            String result;
            result = "Intekenlijst aangemaakt met " + IJCController.c().appTitle + " voor "
                    + IJCController.c().verenigingNaam;
            run.setText(result);
            run.addCarriageReturn(); // separate previous text from break
            for (int i = 0; i < groepen.getAantalGroepen(); ++i) {
                if (i >= 1)
                    run.addBreak();
                Groep groep = groepen.getGroepById(i);
                result = "Stand na " + groepen.getRonde() + "e ronde, " + groepen.getPeriode();
                result += "e periode                " + groep.getNaam() + " (" + groep.getSpelers().size() + ")\n";
                run.setText(result);
                run.addBreak();
                result = "    Naam                           ini   zw rating  gespeeld tegen  pnt\n";
                run.setText(result);
                run.addBreak();
                result = "-----------------------------------------------------------------------\n";
                run.setText(result);
                run.addBreak();
                for (Speler s : groep.getSpelers()) {
                    result = s.toPrintableString(false);
                    run.setText(result);
                    run.addBreak();
                }

                if (IJCController.c().exportDoorschuivers) {
                    int ndoor = IJCController.c().bepaalAantalDoorschuiversVolgendeRonde(groep.getNiveau(),
                            groepen.getPeriode(), groepen.getRonde());
                    if (i - 1 >= 0) {
                        run.setText(IJCController.c().exportDoorschuiversStart + "\n");
                        run.addBreak();
                        Groep lager = groepen.getGroepById(i - 1);
                        if (ndoor > 1) {
                            for (int j = 0; j < ndoor; j++) {
                                Speler s = lager.getSpelerByID(j + 1);
                                run.setText(s.toPrintableString(false, true) + "\n");
                                run.addBreak();
                            }
                            run.setText(IJCController.c().exportDoorschuiversStop + "\n" + "\n");
                        } else {
                            // Bij n doorschuiver, alleen doorschuiven als
                            // kampioen
                            Speler s1 = lager.getSpelerByID(1);
                            Speler s2 = lager.getSpelerByID(2);
                            if ((s2 != null) && ((s1.getPunten() - s2.getPunten()) > 4)) {
                                run.setText(s1.toPrintableString(false, true) + "\n");
                                run.addBreak();
                            }

                        }
                    }
                }
                run.addCarriageReturn(); // separate previous text from break
                run.addBreak(BreakType.PAGE);
            }
            // Close input file
            file.close();
            // Store Excel to new file
            String dirName = "R" + groepen.getPeriode() + "-" + groepen.getRonde();
            new File(dirName).mkdirs();
            String filename = dirName + File.separator + "IntekenlijstR" + groepen.getPeriode() + "-"
                    + groepen.getRonde() + ".docx";
            File outputFile = new File(filename);
            FileOutputStream outFile = new FileOutputStream(outputFile);
            document.write(outFile);
            // Close output file
            document.close();
            outFile.close();
            // And open it in the system editor
            //Desktop.getDesktop().open(new File(outputFile));
            return true;
        } catch (Exception ex) {
            logger.log(Level.WARNING, "Export mislukt :" + ex.getMessage());
            Utils.stacktrace(ex);
            return false;
        }
    }

    /**
     * Set spacing to double
     *
     * @param para
     */
    private void setDoubleLineSpacing(XWPFParagraph para) {
        CTPPr ppr = para.getCTP().getPPr();
        if (ppr == null)
            ppr = para.getCTP().addNewPPr();
        CTSpacing spacing = ppr.isSetSpacing() ? ppr.getSpacing() : ppr.addNewSpacing();
        spacing.setAfter(BigInteger.valueOf(0));
        spacing.setBefore(BigInteger.valueOf(0));
        spacing.setLineRule(STLineSpacingRule.AUTO);
        spacing.setLine(BigInteger.valueOf(480));
    }
}