Example #1
0
  private ValidState computeCodeValidity() {
    final String code = this.textCode.getText().trim();

    if (VariablePayeSQLElement.isForbidden(code))
      return ValidState.createCached(false, "Code réservé");

    // on vérifie que la variable n'existe pas déja
    final SQLSelect selAllCodeName = new SQLSelect(getTable().getBase());

    selAllCodeName.addSelectFunctionStar("count");
    selAllCodeName.setWhere(new Where(getTable().getField("CODE"), "=", code));

    final int idSelected = this.getSelectedID();
    if (idSelected >= SQLRow.MIN_VALID_ID) {
      selAllCodeName.andWhere(new Where(getTable().getField("ID"), "!=", idSelected));
    }

    final Number rubCount =
        (Number)
            getTable().getDBSystemRoot().getDataSource().executeScalar(selAllCodeName.asString());
    if (rubCount.intValue() > 0) return ValidState.createCached(false, "Code déjà attribué");

    final SQLSelect selAllVarName = new SQLSelect(getTable().getBase());
    final SQLTable tableVar = getTable().getTable("VARIABLE_PAYE");
    selAllVarName.addSelectFunctionStar("count");
    selAllVarName.setWhere(new Where(tableVar.getField("NOM"), "=", code));
    final Number payVarCount =
        (Number)
            getTable().getDBSystemRoot().getDataSource().executeScalar(selAllVarName.asString());

    return ValidState.createCached(
        payVarCount.intValue() == 0, "Code déjà attribué à une variable de paye");
  }
Example #2
0
 private final void setValidCode(ValidState state) {
   if (!state.equals(this.validCode)) {
     this.validCode = state;
     final boolean visible = !this.validCode.isValid();
     this.labelWarningBadName.setVisible(visible);
     if (visible) this.labelWarningBadName.setText(this.validCode.getValidationText());
     this.fireValidChange();
   }
 }
Example #3
0
public abstract class RubriqueSQLComponent extends BaseSQLComponent {

  private final JTextField textCode;
  private final JLabel labelWarningBadName;
  private final JTextField textLibelle = new JTextField();
  private ValidState validCode = ValidState.getTrueInstance();

  public RubriqueSQLComponent(SQLElement element) {
    super(element);
    this.textCode = new JTextField();
    this.textCode
        .getDocument()
        .addDocumentListener(
            new SimpleDocumentListener() {
              @Override
              public void update(DocumentEvent e) {
                updateCodeValidity();
              }
            });
    this.labelWarningBadName = new JLabelWarning("Code déjà attribué");
  }

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

    // Code
    JLabel labelCode = new JLabel(getLabelFor("CODE"));
    labelCode.setHorizontalAlignment(SwingConstants.RIGHT);
    this.add(labelCode, c);

    c.gridx++;
    c.weightx = 1;
    this.add(this.textCode, c);
    c.weightx = 0;

    c.gridx++;
    this.add(this.labelWarningBadName, c);
    this.labelWarningBadName.setVisible(false);

    // Libelle
    c.gridy++;
    c.gridx = 0;
    JLabel labelNom = new JLabel(getLabelFor("NOM"));
    labelNom.setHorizontalAlignment(SwingConstants.RIGHT);
    this.add(labelNom, c);

    final boolean nl = this.newline();
    c.gridx++;
    c.gridwidth = nl ? GridBagConstraints.REMAINDER : 1;
    c.weightx = 1;
    this.add(this.textLibelle, c);
    c.weightx = 0;
    c.gridwidth = 1;
    if (nl) c.gridy++;

    this.addRequiredSQLObject(this.textCode, "CODE");
    this.addSQLObject(this.textLibelle, "NOM");

    this.addViews(c);
  }

  // new line after Libellé ?
  protected boolean newline() {
    return true;
  }

  protected abstract void addViews(GridBagConstraints c);

  private ValidState computeCodeValidity() {
    final String code = this.textCode.getText().trim();

    if (VariablePayeSQLElement.isForbidden(code))
      return ValidState.createCached(false, "Code réservé");

    // on vérifie que la variable n'existe pas déja
    final SQLSelect selAllCodeName = new SQLSelect(getTable().getBase());

    selAllCodeName.addSelectFunctionStar("count");
    selAllCodeName.setWhere(new Where(getTable().getField("CODE"), "=", code));

    final int idSelected = this.getSelectedID();
    if (idSelected >= SQLRow.MIN_VALID_ID) {
      selAllCodeName.andWhere(new Where(getTable().getField("ID"), "!=", idSelected));
    }

    final Number rubCount =
        (Number)
            getTable().getDBSystemRoot().getDataSource().executeScalar(selAllCodeName.asString());
    if (rubCount.intValue() > 0) return ValidState.createCached(false, "Code déjà attribué");

    final SQLSelect selAllVarName = new SQLSelect(getTable().getBase());
    final SQLTable tableVar = getTable().getTable("VARIABLE_PAYE");
    selAllVarName.addSelectFunctionStar("count");
    selAllVarName.setWhere(new Where(tableVar.getField("NOM"), "=", code));
    final Number payVarCount =
        (Number)
            getTable().getDBSystemRoot().getDataSource().executeScalar(selAllVarName.asString());

    return ValidState.createCached(
        payVarCount.intValue() == 0, "Code déjà attribué à une variable de paye");
  }

  private void updateCodeValidity() {
    this.setValidCode(this.computeCodeValidity());
  }

  private final void setValidCode(ValidState state) {
    if (!state.equals(this.validCode)) {
      this.validCode = state;
      final boolean visible = !this.validCode.isValid();
      this.labelWarningBadName.setVisible(visible);
      if (visible) this.labelWarningBadName.setText(this.validCode.getValidationText());
      this.fireValidChange();
    }
  }

  @Override
  public synchronized ValidState getValidState() {
    return super.getValidState().and(this.validCode);
  }

  @Override
  public void select(SQLRowAccessor r) {
    super.select(r);
    updateCodeValidity();
  }
}