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

/*
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 * 
 * Copyright 2011 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.common.element;

import org.openconcerto.sql.element.BaseSQLComponent;
import org.openconcerto.sql.element.SQLComponent;
import org.openconcerto.ui.DefaultGridBagConstraints;
import org.openconcerto.sql.model.Where;
import org.openconcerto.sql.request.ComboSQLRequest;

import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.util.ArrayList;
import java.util.List;

import javax.swing.JCheckBox;
import javax.swing.JLabel;
import javax.swing.JTextField;

public class TitrePersonnelSQLElement extends ComptaSQLConfElement {

    public TitrePersonnelSQLElement() {
        super("TITRE_PERSONNEL", "un titre personnel", "titres personnels");
    }

    @Override
    protected void _initComboRequest(ComboSQLRequest req) {
        super._initComboRequest(req);
        req.setWhere(new Where(getTable().getField("OBSOLETE"), "=", Boolean.FALSE));      
    }
    
    @Override
    public boolean isShared() {
        return true;
    }

    protected List<String> getListFields() {
        final List<String> l = new ArrayList<String>();
        l.add("CODE");
        l.add("NOM");
        l.add("SEXE_M");
        l.add("OBSOLETE");
        return l;
    }

    protected List<String> getComboFields() {
        final List<String> l = new ArrayList<String>();
        l.add("CODE");
        return l;
    }

    public SQLComponent createComponent() {
        return new BaseSQLComponent(this) {

            public void addViews() {
                this.setLayout(new GridBagLayout());
                final GridBagConstraints c = new DefaultGridBagConstraints();

                // Code
                JLabel labelCode = new JLabel("CODE");
                JTextField textCode = new JTextField();
                this.add(labelCode, c);
                c.gridx++;
                this.add(textCode, c);

                // Nom
                JLabel labelNom = new JLabel("NOM");
                JTextField textNom = new JTextField();

                this.add(labelNom, c);
                c.gridx++;
                this.add(textNom, c);

                // Sexe
                JCheckBox sexe = new JCheckBox("Sexe masculin");
                c.gridx++;
                this.add(sexe, c);

                this.addRequiredSQLObject(textCode, "CODE");
                this.addRequiredSQLObject(textNom, "NOM");
                this.addRequiredSQLObject(sexe, "SEXE_M");
            }
        };
    }

    @Override
    protected String createCode() {
        return "civility";
    }
}