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

import org.jdom2.Document;

import org.jdom2.Document;

import org.jdom2.Element;

import org.jdom2.Element;

import org.jdom2.Namespace;

import org.jdom2.Namespace;

public final class SDDMessageSQLElement extends ComptaSQLConfElement {

public final class SDDMessageSQLElement extends ComptaSQLConfElement {

    static public final String XML_LOCATION_PREF_KEY = "SDD.XML.location";

    static public final String XML_LOCATION_PREF_KEY = "SDD.XML.location";

    public static final String SERIAL_MD = "SDD_MESSAGE_SERIAL";

    public static final String SERIAL_MD = "SDD_MESSAGE_SERIAL";

    public static SQLCreateTable getCreateTable(final DBRoot root) {

    public static SQLCreateTable getCreateTable(final DBRoot root) {

        if (root.contains(TABLE_NAME))

        if (root.contains(TABLE_NAME))

    @Override

    @Override

    protected String createCode() {

    protected String createCode() {

        // TODO rename createCodeFromPackage() to createCodeOfPackage() and change createCode()

        // TODO rename createCodeFromPackage() to createCodeOfPackage() and change createCode()

        // implementation to use a new createCodeFromPackage() which uses the class name (w/o

        // implementation to use a new createCodeFromPackage() which uses the class name (w/o

        // SQLElement suffix)

        // SQLElement suffix)

    }

    }

    public final void exportXML(final Component comp, final List<? extends SQLRowAccessor> messages) {

    public final void exportXML(final Component comp, final List<? extends SQLRowAccessor> messages) {

        final Preferences sddMsgPrefs = getPreferences();

        final Preferences sddMsgPrefs = getPreferences();

        final String storedPath = sddMsgPrefs.get(XML_LOCATION_PREF_KEY, "");

        final String storedPath = sddMsgPrefs.get(XML_LOCATION_PREF_KEY, "");

    }

    }

    static private final class InvoicesByPaymentInfo {

    static private final class InvoicesByPaymentInfo {

        private final Date lowerBound, upperBound;

        private final Date lowerBound, upperBound;

        private final NavigableMap<Date, ListMap<String, InvoiceElem>> map = new TreeMap<>();

        private final NavigableMap<Date, ListMap<String, InvoiceElem>> map = new TreeMap<>();

        private final Set<Number> lockedInvoicesIDs = new HashSet<>();

        private final Set<Number> lockedInvoicesIDs = new HashSet<>();

        private BigDecimal sum = BigDecimal.ZERO;

        private BigDecimal sum = BigDecimal.ZERO;

        private final Set<String> invoiceNumbers = new HashSet<>();

        private final Set<String> invoiceNumbers = new HashSet<>();

        private final Set<String> invoiceMandates = new HashSet<>();

        private final Set<String> invoiceMandates = new HashSet<>();

                throw new IllegalStateException("Duplicate invoice number : " + invoice);

                throw new IllegalStateException("Duplicate invoice number : " + invoice);

            final SQLRowAccessor mandate = invoice.getForeign("ID_MODE_REGLEMENT").getForeign("ID_SEPA_MANDATE");

            final SQLRowAccessor mandate = invoice.getForeign("ID_MODE_REGLEMENT").getForeign("ID_SEPA_MANDATE");

            if (!mandate.getBoolean("ACTIVE"))

            if (!mandate.getBoolean("ACTIVE"))

                throw new IllegalStateException("Inactive mandate for " + invoice);

                throw new IllegalStateException("Inactive mandate for " + invoice);

            // needed otherwise would have to update seqType while generating

            // needed otherwise would have to update seqType while generating

            if (!this.invoiceMandates.add(mandate.getString("MandateIdentification")))

            if (!this.invoiceMandates.add(mandate.getString("MandateIdentification")))

                return IgnoreReason.DUPLICATE_MANDATE;

                return IgnoreReason.DUPLICATE_MANDATE;

            this.lockedInvoicesIDs.add(invoice.getIDNumber());

            this.lockedInvoicesIDs.add(invoice.getIDNumber());

            ListMap<String, InvoiceElem> bySeqType = this.map.get(dueDate);

            ListMap<String, InvoiceElem> bySeqType = this.map.get(dueDate);

                // find and lock invoices with TYPE_REGLEMENT direct debit and no message

                // find and lock invoices with TYPE_REGLEMENT direct debit and no message

                final SQLRowValues invoiceVals = new SQLRowValues(invoiceT);

                final SQLRowValues invoiceVals = new SQLRowValues(invoiceT);

                invoiceVals.putRowValues("ID_CLIENT").putNulls("NOM", "BIC", "IBAN");

                invoiceVals.putRowValues("ID_CLIENT").putNulls("NOM", "BIC", "IBAN");

                invoiceVals.putRowValues("ID_MODE_REGLEMENT").putNulls("AJOURS", "LENJOUR").putRowValues("ID_SEPA_MANDATE").setAllToNull();

                invoiceVals.putRowValues("ID_MODE_REGLEMENT").putNulls("AJOURS", "LENJOUR").putRowValues("ID_SEPA_MANDATE").setAllToNull();

                final SQLRowValuesListFetcher fetcher = SQLRowValuesListFetcher.create(invoiceVals);

                final SQLRowValuesListFetcher fetcher = SQLRowValuesListFetcher.create(invoiceVals);

                fetcher.setReturnedRowsUnmodifiable(true);

                fetcher.setReturnedRowsUnmodifiable(true);

                // required for locking rows and to make sure that there's a SEPA Mandate

                // required for locking rows and to make sure that there's a SEPA Mandate

                fetcher.setFullOnly(true);

                fetcher.setFullOnly(true);

                fetcher.appendSelTransf(new ITransformer<SQLSelect, SQLSelect>() {

                fetcher.appendSelTransf(new ITransformer<SQLSelect, SQLSelect>() {

        res.addContent(new Element("Dbtr", painNS).addContent(elemCreator.createWithNonEmptyText("Nm", clientRow, "NOM")));

        res.addContent(new Element("Dbtr", painNS).addContent(elemCreator.createWithNonEmptyText("Nm", clientRow, "NOM")));

        res.addContent(new Element("DbtrAcct", painNS).addContent(new Element("Id", painNS).addContent(elemCreator.createWithNonEmptyText("IBAN", clientRow, "IBAN"))));

        res.addContent(new Element("DbtrAcct", painNS).addContent(new Element("Id", painNS).addContent(elemCreator.createWithNonEmptyText("IBAN", clientRow, "IBAN"))));

        res.addContent(new Element("Purp", painNS).addContent(new Element("Cd", painNS).setText("OTHR")));

        res.addContent(new Element("Purp", painNS).addContent(new Element("Cd", painNS).setText("OTHR")));

        return res;

        return res;

    }

    }

    static public final class MissingInfoException extends Exception {

    static public final class MissingInfoException extends Exception {

            return this.label;

            return this.label;

        }

        }

    }

    }

    static private final class ElementCreator {

    static private final class ElementCreator {

        private final Namespace painNS;

        private final Namespace painNS;

        private final SQLFieldTranslator fieldTrans;

        private final SQLFieldTranslator fieldTrans;

        protected ElementCreator(Namespace painNS, final SQLFieldTranslator fieldTrans) {

        protected ElementCreator(Namespace painNS, final SQLFieldTranslator fieldTrans) {

            super();

            super();

        protected Element createWithNonEmptyText(final String elemName, final String text, final String label) throws MissingInfoException {

        protected Element createWithNonEmptyText(final String elemName, final String text, final String label) throws MissingInfoException {

            if (StringUtils.isEmpty(text))

            if (StringUtils.isEmpty(text))

                throw new MissingInfoException(label == null ? elemName : label);

                throw new MissingInfoException(label == null ? elemName : label);

            return create(elemName).setText(text);

            return create(elemName).setText(text);

        }

        }

    }

    }

}

}