MT940

  
/**
  * Fetches all references that need to be considered during the MT940 import process, e.g.
  * all open client billings/invoices that have not yet been linked to other bank transactions
  * 
  * @note A dummy implementation of <code>org.nuclet.mt940.logic.AbstractMt940Logic</code> has 
  * been  provided with this class here, its methods are meant to be implemented with user 
  * specific behaviour.
  * 
  * @return all references that need to be considered during the MT940 import process; the return
  * value comes as as <code>Map</code> in which the <code>BusinessObject</code> represents the
  * map's key while the text, which is meant to be used to link the reference to a bank
  * transaction, represents the map's value
  * 
  * @throws BusinessException might be thrown in case of errors or other exceptions
  *
  */
 public Map<BusinessObject, String> getReferences() throws BusinessException
 {
     final HashMap<BusinessObject, String> mpReferences = new HashMap<BusinessObject, String>();
        
     // @replace!
     // Please, replace this code fragment here with your specific code fitting your needs.
     // 
     // - MT940Reference is just a placeholder for the BusinessObject you'd like to use.
     // - If your aim was to link your client billings to your bank transactions, the client 
     //    billings being represented by the Nuclos-entity "Client Billing", you would use the 
     //    related BusinessObject-class "ClientBilling" here.
     // - Please, expand the query below to a more specific form.
     //
     // - In case only ClientBilling objects of two specific states should be considered, 
     //   a fitting code example could look like this:
     //
     // final Query<ClientBilling> qryGetReferencesStateAB = QueryProvider.create(ClientBilling.class);                                
     // qryGetReferencesStateAB.where(ClientBilling.NuclosState.eq(ProcessClientBillingSM.State_AB.getId()));
     //
     // final List<Rechnung> lstReferencesStateAB = QueryProvider.execute(qryGetReferencesStateAB);                
     //
     // for (final ClientBilling clientBilling : lstReferencesStateAB) {
     //     mpReferences.put(clientBilling, clientBilling.getBillingNumber());
     // }
     // 
     // final Query<ClientBilling> qryGetReferencesStateXY = QueryProvider.create(ClientBilling.class);                                
     // qryGetReferencesStateXY.where(ClientBilling.NuclosState.eq(ProcessClientBillingSM.State_XY.getId()));
     // 
     // final List<ClientBilling> lstReferencesStateXY = QueryProvider.execute(qryGetReferencesStateXY);                
     // 
     // for (final ClientBilling clientBilling : lstReferencesStateXY) {
     //     mpReferences.put(clientBilling, clientBilling.getBillingNumber());
     //  }
     //
     //   return mpReferences;
     //                   
     return mpReferences;
  
}

/**
   * Check, if the changes done to the given bank transaction should result in further
   * changes and/or state changes of the references <code>BusinessObject</code>
   * 
   * @param context the current context
   * 
   * @throws BusinessException, in case an error or exception occurs
   */
  private void checkReferences(UpdateContext context) throws BusinessException
  {
      // @replace!
      //
      // This code segment needs to be filled with application specific behaviour.
      //
      //
  }

package org.nuclet.mt940.wrapper;


import org.nuclos.api.businessobject.BusinessObject;

// @replace
//
// mit eigenem Code zu ersetzen, Beispiel:
//
// import org.nuclet.currency.Currency;


/**
 * Konkrete Wrapper-Klasse für Währungsobjekte
 * 
 */
public class CurrencyWrapper extends AbstractCurrencyWrapper 
{
    public CurrencyWrapper(final BusinessObject currency)
    {
        // @replace Bitte bei Nuclet-Integration mit eigenem Code ersetzen!
        //
        // Beispiel:
        //
        // if (currency instanceof Currency) {
        //    this.businessObject = currency;
        // }
    }

    /**
     * Liefert die Datenbank-ID des Währungsobjektes.
     */
    public Long getId()
    {
        return this.businessObject.getId();
    }

    /**
     * Liefert den ISO-4217-Code des Währungsobjektes.
     * @see https://de.wikipedia.org/wiki/ISO_4217
     * @see https://en.wikipedia.org/wiki/ISO_4217
     */
    public String getIso4217Code()
    {
        // @replace Bitte bei Nuclet-Integration mit eigenem Code ersetzen!
        //
        // Beispiel:
        //
        // return ((Currency)this.businessObject).getIso4217Code();

        return null;
    }
}

package org.nuclet.mt940.facade;


import java.util.List;

import org.nuclos.api.businessobject.Query;
import org.nuclos.api.businessobject.QueryOperation;
import org.nuclos.api.businessobject.SearchExpression;
import org.nuclos.api.context.JobContext;
import org.nuclos.api.context.RuleContext;
import org.nuclos.api.exception.BusinessException; 
import org.nuclos.api.provider.QueryProvider;
import org.nuclos.api.provider.BusinessObjectProvider;

import org.nuclet.common.facade.AbstractFacade;
import org.nuclet.mt940.wrapper.AbstractCurrencyWrapper;

// @replace! Bitte bei Nuclet-Integration mit eigenem Code ersetzen!
//
// Beispiel:
// 
// import org.nuclet.currency.Currency;


/**
 * Facade for Business Objects of type "Currency" 
 * 
 */
public class CurrencyFacade extends AbstractCurrencyFacade
{        
    private static final CurrencyFacade instance = new CurrencyFacade();        
    
    /**
     * Liefert die Singleton-Instanz dieser Klasse
     *
     */
    public static CurrencyFacade getInstance()
    {
        return instance;
    } 
    
    /**
     * Fetches the currency which determined by a given ISO 4217 code from the database
     * 
     * @param strIso4217Code the ISO 4217 code of the currency to be found
     * 
     * @return the currency which is marked as "base currency" from the database
     * @throws BusinessException, if more than one currency-objects are found 
     */
    public AbstractCurrencyWrapper getCurrencyByIso4217Code(final String strIso4217Code)
    {
        // @replace! Bitte bei Nuclet-Integration mit eigenem Code ersetzen!
        //
        // Beispiel:
        //
        // 
        // final Query<Currency> queryGetCurrency = QueryProvider.create(Currency.class);
        // queryGetCurrency.where(Currency.Iso4217Code.eq(strIso4217Code));
        //                
        // final List<Currency> lstCurrency = QueryProvider.execute(queryGetCurrency);
        //    
        // if (lstCurrency != null && lstCurrency.size() > 0) {    
        //    return new CurrencyWrapper(lstCurrency.get(0));
        // } else {
        //     return null;
        // }
        
        return null;
    }
        
}

:20:STARTUMSE 
:25:10010010/1111111111 
:28C:00001/001 
:60F:C120131EUR8200,90 
:61:1202020102DR400,62N033NONREF 
:86:077?00Überweisung beleglos?109310?20RECHNUNGSNR. 1210815 ?21K 
UNDENNR. 01234 ?22DATUM 01.02.2012?3020020020?2222222222?32MARTHA  
MUELLER?34999 
:61:1202030103DR1210,00N012NONREF 
:86:008?00Dauerauftrag?107000?20MIETE GOETHESTR. 12?3030030030?31 
3333333333?32ABC IMMOBILIEN GMBH?34997 
:61:1202030103CR30,00N062NONREF 
:86:051?00Überweisungseingang?109265?20RECHNUNG 20120188?21STEFAN 
 SCHMIDT?23KUNDENR. 4711,?3040040040?4444444444?32STEFAN SCHMIDT 
:61:1202030103CR89,97N060NONREF//000000000001 
:86:052?00Überweisungseingang?109265?20RECHNUNG 20120165?21PETER 
 PETERSEN?3050050050?315555555555?32PETER PETERSEN  
:62F:C120203EUR6710,50 
-

:20:STARTUMSE 
:25:10050000/1111111111 
:28C:00002/001 
:60F:C120203EUR6710,50 
:61:1202040515CR125,00N062NONREF 
:86:051?00Überweisungseingang?109263?20RECHNUNG 20120171?305005 
0050?315555555555?32SUSANNE SCHNEIDER 
:61:1202040515CR389,45N061NONREF 
:86:051?00Überweisungseingang?109310?20FRITZ FISCHER?3060060060 
?316666666666?32FRITZ FISCHER 
:61:1202040515CR35,90N062NONREF 
:86:166?00Überweisungseingang?109249?20RECHNUNG 20120182 ?21AUF 
TRAGSNR. 1010?3070070070?317777777777?32WERNER WEBER?34888 
:61:1202040516CR1015,10N062NONREF 
:86:051?00Überweisungseingang?109255?20RECHNUNG 20120179 ?21BES 
TELLUNG VOM?2231.01.2012?3080080080?3188888888?32MARLENE MEYER 
:61:1202050516CR610,80N062NONREF//661505129024 
:86:051?00Überweisungseingang?109257?20RG. 20120164?3090090090? 
319999999999?32WILLY WAGNER 
:61:1202050518CR3300,21N062NONREF 
:86:051?00Überweisungseingang?109267?20RECHNUNG BEATE BECKER?30 
10110110?311212121212?32BEATE BECKER 
:62M:C120207EUR12186,96 
- 
:20:STARTUMSE 
:25:10010010/1111111111 
:28C:00002/002 
:60M:C120207EUR5569,67 
:61:1202050518CR61,00N060NONREF//000000000009 
:86:052?00Überweisungseingang?109265?20RECHNUNG 20120185 ?30202 
20220?312121212121?32SIEGFRID SCHULZ 
:61:1202080518DR99,80N011NONREF//013900139000 
:86:005?00Lastschrift?109244?20ZAHLUNGSBELEG 08128128128?21IHRE  
KONTONR.1111111111?2208128128128/01.02.2012?3030330330?31343434 
3434?32TELEKOMM GMBH 
:61:1202080518DR49,99N011NONREF//013900610875 
:86:005?00Lastschrift?109244?20ZAHLUNGSBELEG 08128128129?21IHRE  
KONTONR.1111111111?2208128128129/01.02.2012?3030330330?31343434 
3434?32TELEKOMM GMBH 
:61:1202090518DR99,80N011NONREF//013900238880 
:86:005?00Lastschrift?109244?20ZAHLUNGSBELEG 08128128130?21IHRE  
KONTONR.1111111111?2208128128130/01.02.2012?3030330330?31343434 
3434?32TELEKOMM GMBH 
:61:1202090518DR39,95N011NONREF//013900123445 
:86:005?00Lastschrift?109244?20ZAHLUNGSBELEG 08128128131?21IHRE  
KONTONR.1111111111?2208128128131/01.02.2012?3030330330?31343434 
3434?32TELEKOMM GMBH 
:61:1202100521CR560,60N062NONREF 
:86:051?00Überweisungseingang?109203?20RECHNUNG 20120186?304044 
0440?314343434343?32HARRY HOFFMANN 
:62M:C120210EUR12519,02 
- 
:20:STARTUMSE 
:25:10010010/1111111111 
:28C:00002/003 
:60M:C120210EUR12519,02 
:61:1202110521CR444,28N062NONREF//661805129024 
:86:051?00Überweisungseingang?109257?20RECHNUNG 20120178?3050550 
550?315656565656?32SABINE SCHAEFER 
:61:1202120521DR240,00N033NONREF 
:86:020?00Überweisung beleglos?109310?20AUSLAGENERSTATT.BEWIRTUN 
G?21VERSAMML. 15.1.12?22RE VOM 1.2.12?23DATUM 02.02.2012, 11.53  
UHR?3060660660?316565656565?32KARL KOCH?34997 
:61:1202120521DR1500,00N033NONREF 
:86:020?00Überweisung beleglos?109310?20ABSCHLAG BERATUNG I/2012 
?21DATUM 01.02.2012, 11.56 UHR?3070770770?317878787878?32CLAUS&C 
LAUSEN KANZLEI?34997 
:61:1202140522DR20,00N011NONREF//009879865431 
:86:005?00Lastschrift?109264?206116113999 ZBNR 9879865431?21BELEG 
-NR. 6000336000?22B0011A5D90 899900122 PORTOK?23ASSEAUFLADUNG?24B 
ETRAG 20,00?3080880880?318787878787?32POST AG 
:61:1202150523CR65,10N062NONREF 
:86:051?00Überweisungseingang?109263?20RG.NR 20120169?21KUNDENNR. 
9896?3090990990?319898989898?32BENNO BAUER 
:61:1202190523DR15,00N011NONREF//009879865431 
:86:005?00Lastschrift?109264?206116113999 ZBNR 9879865431?21BELEG 
-NR. 6000336000?22B0011A5D90 899900127 PORTOK?23ASSEAUFLADUNG?24B 
ETRAG 15,00?3080880880?318787878787?32POST AG 
:62M:C120221EUR11733,40 
-