Dépôt officiel du code source de l'ERP OpenConcerto

/*

 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.

 *

 * Copyright 2011-2019 OpenConcerto, by ILM Informatique. All rights reserved.

 *

 * The contents of this file are subject to the terms of the GNU General Public License Version 3

 * only ("GPL"). You may not use this file except in compliance with the License. You can obtain a

 * copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific

 * language governing permissions and limitations under the License.

 *

 * When distributing the software, include this License Header Notice in each file.

 */

 package org.openconcerto.erp.core.sales.invoice.report;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

import org.openconcerto.erp.core.common.element.BanqueSQLElement;

import org.openconcerto.erp.core.sales.quote.report.PaypalStamper;

import org.openconcerto.erp.core.supplychain.purchase.importer.FacturXExporter;

import org.openconcerto.erp.generationDoc.AbstractSheetXMLWithDate;

import org.openconcerto.erp.generationDoc.PDFAttachment;

import org.openconcerto.erp.generationDoc.SheetUtils;

import org.openconcerto.erp.generationDoc.gestcomm.OptionDocProcessor;

import org.openconcerto.erp.preferences.PayPalPreferencePanel;

import org.openconcerto.erp.preferences.PrinterNXProps;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.preferences.SQLPreferences;

import org.openconcerto.utils.ExceptionHandler;

import java.io.File;

import java.io.InputStream;

import java.io.InputStreamReader;

import java.io.OutputStream;

import java.net.HttpURLConnection;

import java.net.URL;

import java.net.URLConnection;

import java.net.URLEncoder;

import java.nio.charset.StandardCharsets;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import java.util.StringJoiner;

import org.jopendocument.model.OpenDocument;

public class VenteFactureXmlSheet extends AbstractSheetXMLWithDate {

    public static final String TEMPLATE_ID = "VenteFacture";

    public static final String TEMPLATE_SITUATION_SUFFIX = "Situation";

    public static final String TEMPLATE_PROPERTY_NAME = "LocationFacture";

    @Override

    public String getReference() {

        return this.getSQLRow().getString("NOM");

    }

    @Override

    public String getName() {

        final String startName;

        if (this.getSQLRow().getBoolean("COMPLEMENT")) {

            startName = "FactureComplement_";

        } else if (this.getSQLRow().getBoolean("ACOMPTE")) {

            startName = "FactureAcompte_";

        } else {

            startName = "Facture_";

        }

        return startName + this.getSQLRow().getString("NUMERO");

    }

    @Override

    public SQLRow getRowLanguage() {

        SQLRow rowClient = this.getSQLRow().getForeignRow("ID_CLIENT");

        if (rowClient.getTable().contains("ID_LANGUE")) {

            if (!rowClient.isForeignEmpty("ID_LANGUE")) {

                return rowClient.getForeign("ID_LANGUE");

            } else {

                return null;

            }

        } else {

            return super.getRowLanguage();

        }

    }

    public VenteFactureXmlSheet(SQLRow row) {

        super(row);

        this.elt = Configuration.getInstance().getDirectory().getElement("SAISIE_VENTE_FACTURE");

        this.printer = PrinterNXProps.getInstance().getStringProperty("FacturePrinter");

        getDefaultTemplateId();

        this.setPostProcess(new OptionDocProcessor());

    }

    @Override

    public String getType() {

        String type;

        SQLRow row = this.getSQLRow();

        if (row.getBoolean("COMPLEMENT")) {

            type = "Complement";

        } else if (row.getBoolean("ACOMPTE")) {

            type = "Acompte";

        } else if (row.getBoolean("PARTIAL") || row.getBoolean("SOLDE")) {

            type = TEMPLATE_SITUATION_SUFFIX;

        } else {

            type = null;

        }

        return type;

    }

    @Override

    public String getDefaultTemplateId() {

        return TEMPLATE_ID;

    }

    @Override

    public void createPDF(final File generatedFile, final File pdfFile, final OpenDocument doc, String storagePath) {

        if (pdfFile == null) {

            throw new IllegalArgumentException("null PDF file");

        }

        try {

            final List<PDFAttachment> attachments = new ArrayList<>(1);

            final FacturXExporter ex = new FacturXExporter();

            final SQLRow rowSociete = ComptaPropsConfiguration.getInstanceCompta().getRowSociete();

            final String xml = ex.createXMLFrom(getSQLRow().getTable().getDBRoot(), getSQLRow().getID(), rowSociete);

            attachments.add(new PDFAttachment("factur-x.xml", "factur-x.xml", xml.getBytes(StandardCharsets.UTF_8), "text/xml"));

            final SQLPreferences prefs = SQLPreferences.getMemCached(getElement().getTable().getDBRoot());

            if (prefs.getBoolean(PayPalPreferencePanel.PAYPAL_INVOICE, false)) {

                try {

                    final File inFile = File.createTempFile("oc_", pdfFile.getName());

                    SheetUtils.convert2PDF(doc, inFile, attachments);

                    PaypalStamper s = new PaypalStamper();

                    int x = prefs.getInt(PayPalPreferencePanel.PAYPAL_INVOICE_X, 0);

                    int y = prefs.getInt(PayPalPreferencePanel.PAYPAL_INVOICE_Y, 0);

                    // Reference

                    String ref = getSQLRow().getString("NUMERO");

                    // Montant : ex : 10.55

                    long cents = getSQLRow().getLong("NET_A_PAYER");

                    String amount = cents / 100 + "." + cents % 100;

                    // Devise

                    // TODO : autres devises

                    String currency = "EUR";

                    // POST

                    final URL url = new URL("https://cloud.openconcerto.org/payment");

                    final URLConnection con = url.openConnection();

                    final HttpURLConnection http = (HttpURLConnection) con;

                    http.setRequestMethod("POST");

                    http.setDoOutput(true);

                    http.setDefaultUseCaches(false);

                    String hyperlink = null;

                    // x-www-form-urlencoded

                    final Map<String, String> arguments = new HashMap<>();

                    arguments.put("pI", prefs.get(PayPalPreferencePanel.PAYPAL_CLIENTID, ""));

                    arguments.put("pS", prefs.get(PayPalPreferencePanel.PAYPAL_SECRET, ""));

                    arguments.put("ref", ref);

                    arguments.put("amount", amount);

                    arguments.put("currency", currency);

                    arguments.put("type", "paypal");

                    final StringJoiner sj = new StringJoiner("&");

                    for (Map.Entry<String, String> entry : arguments.entrySet()) {

                        sj.add(URLEncoder.encode(entry.getKey(), "UTF-8") + "=" + URLEncoder.encode(entry.getValue(), "UTF-8"));

                    }

                    final String postData = sj.toString();

                    byte[] out = postData.getBytes(StandardCharsets.UTF_8);

                    int length = out.length;

                    http.setFixedLengthStreamingMode(length);

                    http.setRequestProperty("Content-Type", "application/x-www-form-urlencoded; charset=UTF-8");

                    http.connect();

                    try (OutputStream os = http.getOutputStream()) {

                        os.write(out);

                    }

                    if (http.getResponseCode() != 401) {

                        InputStream is = http.getInputStream();

                        InputStreamReader isr = new InputStreamReader(is);

                        int numCharsRead;

                        char[] charArray = new char[1024];

                        StringBuilder sb = new StringBuilder();

                        while ((numCharsRead = isr.read(charArray)) > 0) {

                            sb.append(charArray, 0, numCharsRead);

                        }

                        //

                        hyperlink = sb.toString();

                    }

                    s.addLink(inFile, pdfFile, x, y, hyperlink);

                } catch (Exception e) {

                    e.printStackTrace();

                    SheetUtils.convert2PDF(doc, pdfFile, attachments);

                }

            } else {

                SheetUtils.convert2PDF(doc, pdfFile, attachments);

            }

        } catch (Throwable e) {

            ExceptionHandler.handle("Impossible de créer le PDF " + pdfFile.getAbsolutePath(), e);

        }

        if (!pdfFile.canRead()) {

            ExceptionHandler.handle("Le fichier PDF " + pdfFile.getAbsolutePath() + " ne peut être lu.");

        }

        storeWithStorageEngines(generatedFile, pdfFile, storagePath);

    }

}