예제 #1
0
  public void loadAsynchronous() {

    // On recupere les differents journaux
    SQLTable journalTable = base.getTable("JOURNAL");
    // SQLSelect selJournal = new SQLSelect(base);
    //
    // selJournal.addSelect(journalTable.getField("ID"));
    // selJournal.addSelect(journalTable.getField("NOM"));
    // selJournal.addSelect(journalTable.getField("CODE"));
    //
    // selJournal.addRawOrder("\"JOURNAL\".\"NOM\"");
    //
    // String reqJournal = selJournal.asString();
    // Object obJournal = base.getDataSource().execute(reqJournal, new ArrayListHandler());
    //
    // List myListJournal = (List) obJournal;
    //
    // if (myListJournal.size() != 0) {

    List<SQLRow> liste =
        SQLBackgroundTableCache.getInstance().getCacheForTable(journalTable).getRows();
    for (int k = 0; k < liste.size(); k++) {
      SQLRow row = liste.get(k);
      fireIsLoading(true);
      final Journal jrnlTmp = new Journal(row.getID(), row.getString("NOM"), row.getString("CODE"));
      new SwingWorker<JPanel, Object>() {
        @Override
        protected JPanel doInBackground() throws Exception {

          final JPanel initJournalPanel = initJournalPanel(jrnlTmp);
          return initJournalPanel;
        }

        @Override
        protected void done() {
          JPanel initJournalPanel;
          try {
            initJournalPanel = get();

            initJournalPanel.setOpaque(false);
            JScrollPane scroll = new JScrollPane(initJournalPanel);
            scroll.setBorder(null);
            scroll.setOpaque(false);
            scroll.getViewport().setOpaque(false);
            EtatJournauxPanel.this.tabbedJournaux.addTab(jrnlTmp.getNom(), scroll);
          } catch (InterruptedException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
          } catch (ExecutionException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
          }
          fireIsLoading(false);
          super.done();
        }
      }.execute();
    }
  }
예제 #2
0
  @Override
  protected SQLRowValues createDefaults() {
    System.err.println("Create defaults");

    setSiteEnabled(false, Type_Diff.DONNEUR_ORDRE);
    setSiteEnabled(false, Type_Diff.SITE);

    // Numero incremental auto
    final SQLRowValues rowVals = new SQLRowValues(getTable());
    rowVals.put("NUMERO", NumerotationAutoSQLElement.getNextNumero(DevisSQLElement.class));

    // User
    // final SQLSelect sel = new SQLSelect(Configuration.getInstance().getBase());
    final SQLElement eltComm = Configuration.getInstance().getDirectory().getElement("COMMERCIAL");
    final int idUser = UserManager.getInstance().getCurrentUser().getId();
    //
    // sel.addSelect(eltComm.getTable().getKey());
    // sel.setWhere(new Where(eltComm.getTable().getField("ID_USER_COMMON"), "=", idUser));
    // final List<SQLRow> rowsComm = (List<SQLRow>)
    // Configuration.getInstance().getBase().getDataSource().execute(sel.asString(), new
    // SQLRowListRSH(eltComm.getTable()));

    SQLRow rowsComm =
        SQLBackgroundTableCache.getInstance()
            .getCacheForTable(eltComm.getTable())
            .getFirstRowContains(idUser, eltComm.getTable().getField("ID_USER_COMMON"));

    if (rowsComm != null) {
      rowVals.put("ID_COMMERCIAL", rowsComm.getID());
    }
    if (getTable().getUndefinedID() == SQLRow.NONEXISTANT_ID) {
      rowVals.put("ID_ETAT_DEVIS", EtatDevisSQLElement.EN_ATTENTE);
    } else {
      SQLRowValues foreign = UndefinedRowValuesCache.getInstance().getDefaultRowValues(getTable());
      if (foreign != null && !foreign.isUndefined()) {
        rowVals.put("ID_ETAT_DEVIS", foreign.getObject("ID_ETAT_DEVIS"));
      } else {
        rowVals.put("ID_ETAT_DEVIS", EtatDevisSQLElement.EN_ATTENTE);
      }
    }
    rowVals.put("T_HT", Long.valueOf(0));
    rowVals.put("T_TVA", Long.valueOf(0));
    rowVals.put("T_SERVICE", Long.valueOf(0));
    rowVals.put("T_TTC", Long.valueOf(0));

    if (getTable().getFieldsName().contains("DATE_VALIDITE")) {
      Calendar cal = Calendar.getInstance();
      cal.add(Calendar.MONTH, 1);
      rowVals.put("DATE_VALIDITE", cal.getTime());
    }
    return rowVals;
  }