Package de.willuhn.datasource.rmi

Examples of de.willuhn.datasource.rmi.DBIterator

569
570
571
572
573
574
575
576
577
  /**
   * @see de.willuhn.datasource.db.AbstractDBObjectNode#getPossibleParents()
   */
  public GenericIterator getPossibleParents() throws RemoteException
  {
    DBIterator list = (DBIterator) super.getPossibleParents();
    list.setOrder("order by nummer, name");
    return list;
  }
View Full Code Here
579
580
581
582
583
584
585
586
587
  /**
   * @see de.willuhn.datasource.db.AbstractDBObjectNode#getTopLevelList()
   */
  public GenericIterator getTopLevelList() throws RemoteException
  {
    DBIterator list = (DBIterator) super.getTopLevelList();
    list.setOrder("order by nummer, name");
    return list;
  }
View Full Code Here
610
611
612
613
614
615
616
617
618
  {
    GenericIterator i = super.getChildren();
    if (this.isNewObject() || !(i instanceof DBIterator))
      return i;
   
    DBIterator di = (DBIterator) i;
    di.setOrder("order by nummer,name");
    return di;
  }
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
   * das Speichern und kehrt fehlerfrei zurueck.
   * @see de.willuhn.datasource.db.AbstractDBObject#insert()
   */
  public void insert() throws RemoteException, ApplicationException
  {
    DBIterator existing = getService().createList(Turnus.class);
    existing.addFilter("zeiteinheit = " + this.getZeiteinheit());
    existing.addFilter("intervall = " + this.getIntervall());
    existing.addFilter("tag = " + this.getTag());
    if (existing.hasNext())
    {
      Logger.info("turnus \"" + TurnusHelper.createBezeichnung(this) + "\" already exists, skipping insert");
      return;
    }
    super.insert();
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
97
98
        try
        {
          UmsatzList list = ((UmsatzList)getUmsatzListe());
          list.removeAll();
          Konto k = getKonto();
          DBIterator i = k.getUmsaetze();
          while (i.hasNext())
            list.addItem(i.next());
          list.sort();
        }
        catch (RemoteException e)
        {
          Logger.error("error while reloading umsatz list",e);
View Full Code Here
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
          String zweck = StringUtils.trimToNull((String) getZweck().getValue());
          if (zweck == null)
          {
            // Verwendungszweck vervollstaendigen
            SepaSammelTransferBuchung s = getBuchung();
            DBIterator list = s.getList();
            list.addFilter("empfaenger_konto = ?",a.getIban());
            list.setOrder("order by id desc");
            if (list.hasNext())
            {
              SepaSammelTransferBuchung t = (SepaSammelTransferBuchung) list.next();
              getZweck().setValue(t.getZweck());
            }
          }
        }
        catch (Exception e)
View Full Code Here
187
188
189
190
191
192
193
194
195
196
197
198
199
200
  public static Turnus findByDauerAuftrag(GVRDauerList.Dauer d) throws RemoteException
  {
    int ze = Turnus.ZEITEINHEIT_MONATLICH;
    if ("W".equalsIgnoreCase(d.timeunit)) ze = Turnus.ZEITEINHEIT_WOECHENTLICH;

    DBIterator list = Settings.getDBService().createList(Turnus.class);
    list.addFilter("zeiteinheit = " + ze);
    list.addFilter("intervall = " + d.turnus);
    list.addFilter("tag = " + d.execday);
    if (list.hasNext())
      return (Turnus) list.next();

    return null;
  }
View Full Code Here
811
812
813
814
815
816
817
818
819
820
821
822
823
        try
        {
          UmsatzList list = ((UmsatzList)getUmsatzList());
          list.removeAll();
          Konto k = getKonto();
          DBIterator i = k.getUmsaetze(HBCIProperties.UMSATZ_DEFAULT_DAYS);
          while (i.hasNext())
            list.addItem(i.next());
          list.sort();
          if (consumer != null)
            consumer.handleMessage(null);
        }
        catch (IllegalArgumentException iae)
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
   * @return Liste der gefundenen Umsaetze.
   * @throws RemoteException
   */
  public static DBIterator find(Konto konto, String kategorie, Date from, Date to, String query) throws RemoteException
  {
    DBIterator list = getUmsaetzeBackwards();
   
    if (konto != null)
      list.addFilter("konto_id = " + konto.getID());
    else if (StringUtils.trimToNull(kategorie) != null)
      list.addFilter("konto_id in (select id from konto where kategorie = ?)", kategorie);
   
    if (from != null)
      list.addFilter("datum >= ?", new java.sql.Date(DateUtil.startOfDay(from).getTime()));
    if (to != null)
      list.addFilter("datum <= ?", new java.sql.Date(DateUtil.endOfDay(to).getTime()));
   
    if (StringUtils.trimToNull(query) != null)
    {
      String text = "%" + query.toLowerCase() + "%";
      list.addFilter("(LOWER(CONCAT(COALESCE(zweck,''),COALESCE(zweck2,''),COALESCE(zweck3,''))) LIKE ? OR " +
          "LOWER(empfaenger_name) LIKE ? OR " +
          "empfaenger_konto LIKE ? OR " +
          "empfaenger_blz LIKE ? OR " +
          "LOWER(primanota) LIKE ? OR " +
          "LOWER(art) LIKE ? OR " +
View Full Code Here
122
123
124
125
126
127
128
129
130
   */
  private static DBIterator getUmsaetze(boolean backwards) throws RemoteException
  {
    String s = backwards ? "DESC" : "ASC";
    HBCIDBService service = (HBCIDBService) Settings.getDBService();
    DBIterator list = service.createList(Umsatz.class);
    list.setOrder("ORDER BY " + service.getSQLTimestamp("datum") + " " + s + ", id " + s);
    return list;
  }
View Full Code Here
TOP

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

  • de.willuhn.jameica.hbci.gui.action.BackupCreate
  • de.willuhn.jameica.hbci.gui.action.KontoDisable
  • de.willuhn.jameica.hbci.gui.action.KontoMerge
  • de.willuhn.jameica.hbci.gui.boxes.NachrichtBox
  • de.willuhn.jameica.hbci.gui.boxes.Overview
  • de.willuhn.jameica.hbci.gui.chart.ChartDataSaldoVerlauf
  • de.willuhn.jameica.hbci.gui.chart.ChartDataUmsatzTyp
  • de.willuhn.jameica.hbci.gui.controller.AbstractSammelTransferBuchungControl$GegenkontoListener
  • de.willuhn.jameica.hbci.gui.controller.AbstractSepaSammelTransferBuchungControl$EmpfaengerListener
  • de.willuhn.jameica.hbci.gui.controller.AbstractTransferControl$EmpfaengerListener
    • 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.