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

package org.openconcerto.modules.card;

import java.io.IOException;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.List;

import org.openconcerto.erp.config.MainFrame;

import org.openconcerto.erp.modules.AbstractModule;

import org.openconcerto.erp.modules.AlterTableRestricted;

import org.openconcerto.erp.modules.ComponentsContext;

import org.openconcerto.erp.modules.DBContext;

import org.openconcerto.erp.modules.MenuContext;

import org.openconcerto.erp.modules.ModuleElement;

import org.openconcerto.erp.modules.ModuleFactory;

import org.openconcerto.erp.modules.ModulePreferencePanel;

import org.openconcerto.erp.modules.ModulePreferencePanelDesc;

import org.openconcerto.sql.element.SQLComponent;

import org.openconcerto.sql.element.SQLElement.ReferenceAction;

import org.openconcerto.sql.element.SQLElementDirectory;

import org.openconcerto.sql.element.UISQLComponent;

import org.openconcerto.sql.model.DBRoot;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.utils.SQLCreateTable;

import org.openconcerto.utils.ListMap;

import org.openconcerto.utils.PrefType;

public final class ModuleCard extends AbstractModule {

    private static final String TABLE_NAME = "FIDELITY_CARD";

    public ModuleCard(ModuleFactory f) throws IOException {

        super(f);

    }

    @Override

    protected void install(DBContext ctxt) throws SQLException, IOException {

        super.install(ctxt);

        // TODO use version to upgrade

        if (!ctxt.getTablesPreviouslyCreated().contains(TABLE_NAME)) {

            final SQLCreateTable createTable = ctxt.getCreateTable(TABLE_NAME);

            createTable.addVarCharColumn("SERIAL", 64);

            createTable.addColumn("POINTS", "int NOT NULL DEFAULT 0");

            createTable.addDateAndTimeColumn("EXPIRATION_DATE");

            final AlterTableRestricted alterTable = ctxt.getAlterTable("CLIENT");

            alterTable.addForeignColumn("ID_FIDELITY_CARD", createTable);

        }

    }

    @Override

    protected void setupElements(SQLElementDirectory dir) {

        super.setupElements(dir);

        final ModuleElement fidCardElement = new ModuleElement(this, TABLE_NAME) {

            @Override

            protected List<String> getListFields() {

                final List<String> l = new ArrayList<String>();

                l.add("SERIAL");

                l.add("POINTS");

                l.add("EXPIRATION_DATE");

                return l;

            }

            @Override

            protected List<String> getComboFields() {

                final List<String> l = new ArrayList<String>();

                l.add("SERIAL");

                l.add("POINTS");

                return l;

            }

            @Override

            public ListMap<String, String> getShowAs() {

                return ListMap.singleton(null, getComboFields());

            }

            @Override

            protected SQLComponent createComponent() {

                return new UISQLComponent(this) {

                    @Override

                    protected void addViews() {

                        this.addView("SERIAL");

                        this.addView("POINTS");

                        this.addView("EXPIRATION_DATE");

                    }

                };

            }

        };

        dir.addSQLElement(fidCardElement);

        final SQLTable clientT = fidCardElement.getTable().findReferentTable("CLIENT");

        // do not delete a client

        dir.getElement(clientT).setAction("ID_FIDELITY_CARD", ReferenceAction.SET_EMPTY);

    }

    @Override

    protected void setupComponents(ComponentsContext ctxt) {

        ctxt.putAdditionalField("CLIENT", "ID_FIDELITY_CARD");

    }

    @Override

    protected void setupMenu(MenuContext ctxt) {

        ctxt.addMenuItem(ctxt.createListAction(TABLE_NAME), MainFrame.LIST_MENU);

    }

    @Override

    protected void start() {

    }

    @Override

    public List<ModulePreferencePanelDesc> getPrefDescriptors(final DBRoot root) {

        return Arrays.<ModulePreferencePanelDesc> asList(new ModulePreferencePanelDesc("Préf") {

            @Override

            protected ModulePreferencePanel createPanel() {

                return new ModulePreferencePanel(root, "Mon super titre") {

                    @Override

                    protected void addViews() {

                        this.addView(new SQLPrefView<Boolean>(PrefType.BOOLEAN_TYPE, "Un booléen", "boolPref").setDefaultValue(Boolean.TRUE));

                        this.addView(new SQLPrefView<String>(PrefType.STRING_TYPE, 12, "Du texte", "textPref").setDefaultValue("court"));

                        this.addView(new SQLPrefView<Double>(PrefType.DOUBLE_TYPE, "Un double", "doublePref"));

                    }

                };

            }

        }, new ModulePreferencePanelDesc("Préf2") {

            @Override

            protected ModulePreferencePanel createPanel() {

                return new ModulePreferencePanel(root, "Mon super titre") {

                    @Override

                    protected void addViews() {

                        this.addView(new SQLPrefView<String>(PrefType.STRING_TYPE, 512, "Du texte", "textPref").setDefaultValue("long texte"));

                        this.addView(new SQLPrefView<Long>(PrefType.LONG_TYPE, "Un long", "longPref"));

                    }

                };

            }

        }.setLocal(false).setKeywords("toto", "vélo"));

    }

    @Override

    protected void stop() {

    }

}