Dépôt officiel du code source de l'ERP OpenConcerto
Rev 121 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed
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.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() {
return Arrays.<ModulePreferencePanelDesc> asList(new ModulePreferencePanelDesc("Préf") {
@Override
protected ModulePreferencePanel createPanel() {
return new ModulePreferencePanel("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("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() {
}
}