Package de.willuhn.datasource.rmi

Examples of de.willuhn.datasource.rmi.DBIterator


  {
    if (this.existing != null)
      return this.existing;

    HBCIDBService service = (HBCIDBService) Settings.getDBService();
    DBIterator list = this.transfer.getList();
    list.addFilter("ausgefuehrt = 0");
    list.setOrder("ORDER BY " + service.getSQLTimestamp("termin") + " DESC, id DESC");
    this.existing = new SelectInput(list,null);
    this.existing.setName(i18n.tr("Existierende Auftr�ge"));
    this.existing.setPleaseChoose(i18n.tr("Bitte w�hlen..."));
    this.existing.setEnabled(false);

    // Wenn wir keine existierenden Auftraege haben, koennen wir das gleich komplett deaktivieren
    if (list.size() == 0)
    {
      getUseExisting().setValue(Boolean.FALSE);
      getUseExisting().setEnabled(false);
    }
View Full Code Here


  /**
   * @see de.willuhn.jameica.gui.Part#paint(org.eclipse.swt.widgets.Composite)
   */
  public void paint(Composite parent) throws RemoteException
  {
    DBIterator iterator = Settings.getDBService().createList(Nachricht.class);
    iterator.setOrder("order by datum desc"); // Neueste zuerst
    iterator.addFilter("gelesen is null or gelesen = 0");
   
    this.list = new NachrichtList(iterator,new NachrichtOpen());
    this.list.setSummary(false);
    this.list.paint(parent);
   
View Full Code Here

   */
  public boolean isEnabled()
  {
    try
    {
      DBIterator iterator = Settings.getDBService().createList(Nachricht.class);
      iterator.addFilter("gelesen is null or gelesen = 0");
      return iterator.hasNext(); // Wenn Nachrichten vorliegen, wird die Box automatisch aktiviert
    }
    catch (Exception e)
    {
      Logger.error("unable to check for new messages",e);
    }
View Full Code Here

  {
    if (search == null || search.length() == 0)
      return null;

    String text = "%" + search.toLowerCase() + "%";
    DBIterator list = Settings.getDBService().createList(Konto.class);
    list.addFilter("LOWER(name) LIKE ? OR " +
                   "LOWER(bezeichnung) LIKE ? OR " +
                   "kontonummer LIKE ? OR " +
                   "blz LIKE ? OR " +
                   "kundennummer LIKE ?",
                   text,text,text,text,text);

    ArrayList results = new ArrayList();
    while (list.hasNext())
    {
      results.add(new MyResult((Konto)list.next()));
    }
    return results;
  }
View Full Code Here

  private static List init(KontoFilter filter) throws RemoteException
  {
    groups = KontoUtil.getGroups(); // Gruppen neu laden
    boolean haveGroups = groups.size() > 0;

    DBIterator it = Settings.getDBService().createList(Konto.class);
    it.setOrder("ORDER BY LOWER(kategorie), blz, kontonummer, bezeichnung");
    List l = new ArrayList();

    String current = null;

    while (it.hasNext())
    {
      Konto k = (Konto) it.next();

      if (filter == null || filter.accept(k))
      {
        if (haveGroups)
        {
View Full Code Here

        if (!options.getSyncSepaDauerauftraege())
          continue;
       
        // Senden der neuen Dauerauftraege
        DBIterator list = kt.getSepaDauerauftraege();
        while (list.hasNext())
        {
          SepaDauerauftrag d = (SepaDauerauftrag) list.next();
          if (d.isActive())
            continue; // Der wurde schon gesendet
         
          SynchronizeJobSepaDauerauftragStore job = backend.create(SynchronizeJobSepaDauerauftragStore.class,kt);
          job.setContext(SynchronizeJob.CTX_ENTITY,d);
View Full Code Here

          String zweck = (String) getZweck().getValue();
          String zweck2 = getZweck2().getText(); // "getText()" ist wichtig, weil das ein DialogInput ist
          if ((zweck != null && zweck.length() > 0) || (zweck2 != null && zweck2.length() > 0))
            return;
         
          DBIterator list = getTransfer().getList();
          list.addFilter("empfaenger_konto = ?",new Object[]{gegenkonto.getKontonummer()});
          list.addFilter("empfaenger_blz = ?"new Object[]{gegenkonto.getBlz()});
          list.setOrder("order by id desc");
          if (list.hasNext())
          {
            HibiscusTransfer t = (HibiscusTransfer) list.next();
            getZweck().setValue(t.getZweck());
            getZweck2().setText(t.getZweck2()); // "setText()" ist wichtig, weil das ein DialogInput ist
          }
        }
        catch (Exception e)
View Full Code Here

      String konto = (String) params.get("my.account");
      String blz   = (String) params.get("my.blz");
      boolean stored = false;
      if (konto != null && blz != null)
      {
        DBIterator list = service.createList(Konto.class);
        list.addFilter("kontonummer = ?", new Object[]{konto});
        list.addFilter("blz = ?",         new Object[]{blz});
        if (list.hasNext())
        {
          // Jepp, wir haben das Konto.
          ls.setKonto((Konto) list.next());

          // Nur, wenn wir das Konto haben, koennen wir
          // versuchen, den Auftrag zu speichern
          ls.store();
          stored = true;
View Full Code Here

   */
  protected DBIterator getList(Object konto, Date from, Date to, String text) throws RemoteException
  {
    HBCIDBService service = (HBCIDBService) Settings.getDBService();
   
    DBIterator list = service.createList(getObjectType());
    if (from != null) list.addFilter("termin >= ?", new java.sql.Date(DateUtil.startOfDay(from).getTime()));
    if (to   != null) list.addFilter("termin <= ?", new java.sql.Date(DateUtil.endOfDay(to).getTime()));

    if (konto != null && (konto instanceof Konto))
      list.addFilter("konto_id = " + ((Konto) konto).getID());
    else if (konto != null && (konto instanceof String))
      list.addFilter("konto_id in (select id from konto where kategorie = ?)", (String) konto);
   
    boolean pending = ((Boolean) this.getPending().getValue()).booleanValue();
    if (pending)
      list.addFilter("ausgefuehrt = 0");

    list.setOrder("ORDER BY " + service.getSQLTimestamp("termin") + " DESC, id DESC");
    return list;
  }
View Full Code Here

  public static GenericIterator getNeueUmsaetze() throws RemoteException
  {
    if (first == null)
      return PseudoIterator.fromArray(new Umsatz[0]);

    DBIterator list = UmsatzUtil.getUmsaetzeBackwards();
    list.addFilter("id >= " + first);
    if (list.size() == 0)
      first = null; // Wenn nichts gefunden wurde, resetten wir uns
    return list;
  }
View Full Code Here

TOP

Related Classes of de.willuhn.datasource.rmi.DBIterator

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.