Package de.willuhn.datasource.rmi

Examples of de.willuhn.datasource.rmi.DBIterator.addFilter()

201
202
203
204
205
206
207
208
209
210
211
    }
   
    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");
View Full Code Here
205
206
207
208
209
210
211
212
213
214
215
    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
82
83
84
85
86
87
88
89
90
91
92
    /////////////////////////////////////////////////////////////////
    // Liste der existierenden Konten mit PIN/TAN ermitteln
    // Davon ziehen wir die bereits verlinkten ab
    ArrayList konten = new ArrayList();
    DBIterator list = de.willuhn.jameica.hbci.Settings.getDBService().createList(Konto.class);
    list.addFilter("passport_class = ?",PassportImpl.class.getName());
    list.setOrder("ORDER BY blz, bezeichnung");
    while (list.hasNext())
    {
      Konto k = (Konto) list.next();
      if (exclude.contains(k) != null)
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
   */
  public List getData() throws RemoteException
  {
    DBIterator list = Settings.getDBService().createList(UmsatzTyp.class);
    if (this.type != UmsatzTyp.TYP_EGAL)
      list.addFilter("umsatztyp = " + this.type);
   
    List<Entry> result = new ArrayList<Entry>();
    while (list.hasNext())
    {
      result.add(new Entry((UmsatzTyp)list.next()));
View Full Code Here
156
157
158
159
160
161
162
163
164
165
166
    String konto = a.getKontonummer();
   
    if (StringUtils.isNotEmpty(iban)) // haben wir eine IBAN?
    {
      if (StringUtils.isNotEmpty(konto)) // haben wir ausserdem Konto/BLZ?
        list.addFilter("((empfaenger_konto like ? and empfaenger_blz = ?) or lower(empfaenger_konto) = ?)","%" + konto, a.getBlz(), iban.toLowerCase());
      else // nur IBAN // BUGZILLA 1395
        list.addFilter("lower(empfaenger_konto) = ?",iban.toLowerCase());
    }
    else
    {
View Full Code Here
158
159
160
161
162
163
164
165
166
167
168
    if (StringUtils.isNotEmpty(iban)) // haben wir eine IBAN?
    {
      if (StringUtils.isNotEmpty(konto)) // haben wir ausserdem Konto/BLZ?
        list.addFilter("((empfaenger_konto like ? and empfaenger_blz = ?) or lower(empfaenger_konto) = ?)","%" + konto, a.getBlz(), iban.toLowerCase());
      else // nur IBAN // BUGZILLA 1395
        list.addFilter("lower(empfaenger_konto) = ?",iban.toLowerCase());
    }
    else
    {
      list.addFilter("empfaenger_konto like ?","%" + konto);
      list.addFilter("empfaenger_blz = ?",a.getBlz());
View Full Code Here
162
163
164
165
166
167
168
169
170
171
172
      else // nur IBAN // BUGZILLA 1395
        list.addFilter("lower(empfaenger_konto) = ?",iban.toLowerCase());
    }
    else
    {
      list.addFilter("empfaenger_konto like ?","%" + konto);
      list.addFilter("empfaenger_blz = ?",a.getBlz());
    }

    this.umsatzList = new UmsatzList(list,new UmsatzDetail());
    ((UmsatzList)this.umsatzList).setFilterVisible(false);
View Full Code Here
163
164
165
166
167
168
169
170
171
172
173
        list.addFilter("lower(empfaenger_konto) = ?",iban.toLowerCase());
    }
    else
    {
      list.addFilter("empfaenger_konto like ?","%" + konto);
      list.addFilter("empfaenger_blz = ?",a.getBlz());
    }

    this.umsatzList = new UmsatzList(list,new UmsatzDetail());
    ((UmsatzList)this.umsatzList).setFilterVisible(false);
    return this.umsatzList;
View Full Code Here
184
185
186
187
188
189
190
191
192
193
194
  {
    if (this.sammelList != null)
      return this.sammelList;

    DBIterator list = Settings.getDBService().createList(SepaSammelLastBuchung.class);
    list.addFilter("empfaenger_konto = ?", getAddress().getIban());
    list.setOrder(" ORDER BY id DESC");

    this.sammelList = new SepaSammelTransferBuchungList(list,new SepaSammelLastBuchungNew());
    return this.sammelList;
  }
View Full Code Here
203
204
205
206
207
208
209
210
211
212
213
  {
    if (this.sammelList2 != null)
      return this.sammelList2;

    DBIterator list = Settings.getDBService().createList(SepaSammelUeberweisungBuchung.class);
    list.addFilter("empfaenger_konto = ?", getAddress().getIban());
    list.setOrder(" ORDER BY id DESC");

    this.sammelList2 = new SepaSammelTransferBuchungList(list,new SepaSammelUeberweisungBuchungNew());
    return this.sammelList2;
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.