/*************************************************************************** begin : Mon Mar 01 2004 copyright : (C) 2018 by Martin Preuss email : martin@libchipcard.de *************************************************************************** * Please see toplevel file COPYING for license details * ***************************************************************************/ #ifdef HAVE_CONFIG_H # include #endif #include "jobgettransactions_l.h" #include "aqhbci/aqhbci_l.h" #include "accountjob_l.h" #include "aqhbci/joblayer/job_l.h" #include "aqhbci/joblayer/job_crypt.h" #include "aqhbci/banking/user_l.h" #include #include #include #include #include #include #include #include /* ------------------------------------------------------------------------------------------------ * types * ------------------------------------------------------------------------------------------------ */ enum { AH_JOB_GETTRANS_NONE=0, AH_JOB_GETTRANS_HKKAZ, AH_JOB_GETTRANS_DKKKU, AH_JOB_GETTRANS_HKKKU, AH_JOB_GETTRANS_HKWDU }; /* ------------------------------------------------------------------------------------------------ * forward declarations * ------------------------------------------------------------------------------------------------ */ static int _jobApi_ProcessForBankAccount(AH_JOB *j, AB_IMEXPORTER_CONTEXT *ctx); static int _jobApi_ProcessForCreditCard(AH_JOB *j, AB_IMEXPORTER_CONTEXT *ctx); static int _jobApi_GetLimits(AH_JOB *j, AB_TRANSACTION_LIMITS **pLimits); static int _jobApi_HandleCommand(AH_JOB *j, const AB_TRANSACTION *t); static AH_JOB *_createJob_HKKAZ(AB_PROVIDER *pro, AB_USER *u, AB_ACCOUNT *account); static AH_JOB *_createJob_DKKKU(AB_PROVIDER *pro, AB_USER *u, AB_ACCOUNT *account); static AH_JOB *_createJob_HKKKU(AB_PROVIDER *pro, AB_USER *u, AB_ACCOUNT *account); static AH_JOB *_createJob_HKWDU(AB_PROVIDER *pro, AB_USER *u, AB_ACCOUNT *account); static int _determineJobToUse(AB_USER *u, AB_ACCOUNT *account); static int _readTransIntoAccountInfo(AH_JOB *j, AB_IMEXPORTER_ACCOUNTINFO *ai, const char *docType, int ty, const uint8_t *ptr, uint32_t len); static int _readCheckAndConcatTransDataFromResponses(AH_JOB *j, GWEN_DB_NODE *dbResponses, GWEN_BUFFER *tbooked, GWEN_BUFFER *tnoted); static int _parseTransData(AH_JOB *j, AB_IMEXPORTER_ACCOUNTINFO *ai, const uint8_t *ptrBooked, uint32_t lenBooked, const uint8_t *ptrNoted, uint32_t lenNoted); static AB_TRANSACTION *_readCreditCardTransactionFromResponse(AB_USER *u, AB_ACCOUNT *a, GWEN_DB_NODE *dbTransaction); static AB_VALUE *_readValueFromCreditCardTransResp(GWEN_DB_NODE *dbTransaction); static void _appendBufferToFile(const char *fname, const char *ptr, uint32_t length); /* ------------------------------------------------------------------------------------------------ * implementations * ------------------------------------------------------------------------------------------------ */ AH_JOB *AH_Job_GetTransactions_new(AB_PROVIDER *pro, AB_USER *u, AB_ACCOUNT *account) { int jobType; jobType=_determineJobToUse(u, account); switch(jobType) { case AH_JOB_GETTRANS_HKKAZ: return _createJob_HKKAZ(pro, u, account); case AH_JOB_GETTRANS_DKKKU: return _createJob_DKKKU(pro, u, account); case AH_JOB_GETTRANS_HKKKU: return _createJob_HKKKU(pro, u, account); case AH_JOB_GETTRANS_HKWDU: return _createJob_HKWDU(pro, u, account); default: DBG_NOTICE(AQHBCI_LOGDOMAIN, "No FinTS job (GetTransaction) available for this account"); return NULL; } } AH_JOB *_createJob_HKKAZ(AB_PROVIDER *pro, AB_USER *u, AB_ACCOUNT *account) { AH_JOB *j; GWEN_DB_NODE *dbArgs; j=AH_AccountJob_new("JobGetTransactions", pro, u, account); if (j==NULL) { DBG_INFO(AQHBCI_LOGDOMAIN, "Job \"JobGetTransactions\" not available"); return NULL; } /* set virtual functions */ AH_Job_SetProcessFn(j, _jobApi_ProcessForBankAccount); AH_Job_SetGetLimitsFn(j, _jobApi_GetLimits); AH_Job_SetHandleCommandFn(j, _jobApi_HandleCommand); AH_Job_SetHandleResultsFn(j, AH_Job_HandleResults_Empty); AH_Job_SetSupportedCommand(j, AB_Transaction_CommandGetTransactions); dbArgs=AH_Job_GetArguments(j); GWEN_DB_SetCharValue(dbArgs, GWEN_DB_FLAGS_DEFAULT, "allAccounts", "N"); if (AH_Job_GetSegmentVersion(j)<7) { /* HKKAZ ver 7 and higher use IBAN and BIC, older segments use accountId and bankCode */ DBG_NOTICE(AQHBCI_LOGDOMAIN, "Adding national account specs for HKKAZ version <7"); AH_AccountJob_WriteNationalAccountInfoToArgs(j); } return j; } AH_JOB *_createJob_DKKKU(AB_PROVIDER *pro, AB_USER *u, AB_ACCOUNT *account) { AH_JOB *j; GWEN_DB_NODE *dbArgs; j=AH_AccountJob_new("JobGetTransactionsCreditCard", pro, u, account); if (j==NULL) { DBG_INFO(AQHBCI_LOGDOMAIN, "Job \"JobGetTransactionsCreditCard\" not available"); return NULL; } AH_Job_SetProcessFn(j, _jobApi_ProcessForCreditCard); AH_Job_SetGetLimitsFn(j, _jobApi_GetLimits); AH_Job_SetHandleCommandFn(j, _jobApi_HandleCommand); AH_Job_SetHandleResultsFn(j, AH_Job_HandleResults_Empty); AH_Job_SetSupportedCommand(j, AB_Transaction_CommandGetTransactions); AH_AccountJob_WriteNationalAccountInfoToArgs(j); dbArgs=AH_Job_GetArguments(j); GWEN_DB_SetCharValue(dbArgs, GWEN_DB_FLAGS_DEFAULT, "accountNumber", AB_Account_GetAccountNumber(account)); return j; } AH_JOB *_createJob_HKKKU(AB_PROVIDER *pro, AB_USER *u, AB_ACCOUNT *account) { AH_JOB *j; GWEN_DB_NODE *dbArgs; j=AH_AccountJob_new("JobGetTransactionsCreditCard2", pro, u, account); if (j==NULL) { DBG_INFO(AQHBCI_LOGDOMAIN, "Job \"JobGetTransactionsCreditCard2\" not available"); return NULL; } AH_Job_SetProcessFn(j, _jobApi_ProcessForCreditCard); AH_Job_SetGetLimitsFn(j, _jobApi_GetLimits); AH_Job_SetHandleCommandFn(j, _jobApi_HandleCommand); AH_Job_SetHandleResultsFn(j, AH_Job_HandleResults_Empty); AH_Job_SetSupportedCommand(j, AB_Transaction_CommandGetTransactions); AH_AccountJob_WriteNationalAccountInfoToArgs(j); dbArgs=AH_Job_GetArguments(j); GWEN_DB_SetCharValue(dbArgs, GWEN_DB_FLAGS_DEFAULT, "accountNumber", AB_Account_GetAccountNumber(account)); return j; } AH_JOB *_createJob_HKWDU(AB_PROVIDER *pro, AB_USER *u, AB_ACCOUNT *account) { DBG_NOTICE(AQHBCI_LOGDOMAIN, "HKWDU available, but not yet implemented for JobGetTransactions"); return NULL; } int _determineJobToUse(AB_USER *u, AB_ACCOUNT *account) { GWEN_DB_NODE *updgroup; updgroup=AH_User_GetUpdForAccount(u, account); if (updgroup) { GWEN_DB_NODE *n; n=GWEN_DB_GetFirstGroup(updgroup); while (n) { const char *s; s=GWEN_DB_GetCharValue(n, "job", 0, NULL); if (s && *s) { if (strcasecmp(s, "HKKAZ")==0) return AH_JOB_GETTRANS_HKKAZ; else if (strcasecmp(s, "DKKKU")==0) return AH_JOB_GETTRANS_DKKKU; else if (strcasecmp(s, "HKKKU")==0) return AH_JOB_GETTRANS_HKKKU; else if (strcasecmp(s, "HKWDU")==0) return AH_JOB_GETTRANS_HKWDU; } n=GWEN_DB_GetNextGroup(n); } /* while */ } /* if updgroup for the given account found */ return AH_JOB_GETTRANS_NONE; } int _readTransIntoAccountInfo(AH_JOB *j, AB_IMEXPORTER_ACCOUNTINFO *ai, const char *docType, int ty, const uint8_t *ptr, uint32_t len) { AB_PROVIDER *pro; AB_IMEXPORTER_CONTEXT *tempContext; int rv; assert(j); pro=AH_Job_GetProvider(j); assert(pro); /* import data into a temporary context */ tempContext=AB_ImExporterContext_new(); #if 0 DBG_ERROR(0, "About to read this SWIFT data (%s)", docType); GWEN_Text_DumpString((const char *) ptr, len, 2); #endif rv=AB_Banking_ImportFromBufferLoadProfile(AB_Provider_GetBanking(pro), "swift", tempContext, docType, NULL, ptr, len); if (rv<0) { DBG_INFO(AQHBCI_LOGDOMAIN, "here (%d)", rv); AB_ImExporterContext_free(tempContext); return rv; } AB_Provider_MergeContextsSetTypeAndFreeSrc(ai, tempContext, ty); return 0; } int _jobApi_ProcessForBankAccount(AH_JOB *j, AB_IMEXPORTER_CONTEXT *ctx) { AB_ACCOUNT *a; AB_IMEXPORTER_ACCOUNTINFO *ai; GWEN_DB_NODE *dbResponses; GWEN_BUFFER *tbooked; GWEN_BUFFER *tnoted; int rv; DBG_INFO(AQHBCI_LOGDOMAIN, "Processing JobGetTransactions"); a=AH_AccountJob_GetAccount(j); assert(a); dbResponses=AH_Job_GetResponses(j); assert(dbResponses); tbooked=GWEN_Buffer_new(0, 1024, 0, 1); tnoted=GWEN_Buffer_new(0, 1024, 0, 1); rv=_readCheckAndConcatTransDataFromResponses(j, dbResponses, tbooked, tnoted); if (rv<0) { DBG_INFO(AQHBCI_LOGDOMAIN, "here (%d)", rv); GWEN_Buffer_free(tbooked); GWEN_Buffer_free(tnoted); AH_Job_SetStatus(j, AH_JobStatusError); return rv; } if (getenv("AQHBCI_LOGBOOKED")) _appendBufferToFile("/tmp/booked.mt", GWEN_Buffer_GetStart(tbooked), GWEN_Buffer_GetUsedBytes(tbooked)); if (getenv("AQHBCI_LOGNOTED")) _appendBufferToFile("/tmp/noted.mt", GWEN_Buffer_GetStart(tnoted), GWEN_Buffer_GetUsedBytes(tnoted)); ai=AB_Provider_GetOrAddAccountInfoForAccount(ctx, a); rv=_parseTransData(j, ai, (const uint8_t *) GWEN_Buffer_GetStart(tbooked), GWEN_Buffer_GetUsedBytes(tbooked), (const uint8_t *) GWEN_Buffer_GetStart(tnoted), GWEN_Buffer_GetUsedBytes(tnoted)); GWEN_Buffer_free(tbooked); GWEN_Buffer_free(tnoted); if (rv<0) { DBG_INFO(AQHBCI_LOGDOMAIN, "here (%d)", rv); AH_Job_SetStatus(j, AH_JobStatusError); return rv; } AB_Provider_DumpTransactionsIfDebug(ai, AQHBCI_LOGDOMAIN); return 0; } int _readCheckAndConcatTransDataFromResponses(AH_JOB *j, GWEN_DB_NODE *dbResponses, GWEN_BUFFER *tbooked, GWEN_BUFFER *tnoted) { GWEN_DB_NODE *dbCurr; int rv; dbCurr=GWEN_DB_GetFirstGroup(dbResponses); while (dbCurr) { GWEN_DB_NODE *dbXA; rv=AH_Job_CheckEncryption(j, dbCurr); if (rv) { DBG_INFO(AQHBCI_LOGDOMAIN, "Compromised security (encryption)"); return rv; } rv=AH_Job_CheckSignature(j, dbCurr); if (rv) { DBG_INFO(AQHBCI_LOGDOMAIN, "Compromised security (signature)"); return rv; } dbXA=GWEN_DB_GetGroup(dbCurr, GWEN_PATH_FLAGS_NAMEMUSTEXIST, "data/transactions"); if (dbXA) { const void *p; unsigned int bs; if (GWEN_Logger_GetLevel(0)>=GWEN_LoggerLevel_Debug) GWEN_DB_Dump(dbXA, 2); p=GWEN_DB_GetBinValue(dbXA, "booked", 0, 0, 0, &bs); if (p && bs) GWEN_Buffer_AppendBytes(tbooked, p, bs); p=GWEN_DB_GetBinValue(dbXA, "noted", 0, 0, 0, &bs); if (p && bs) GWEN_Buffer_AppendBytes(tnoted, p, bs); } /* if "Transactions" */ dbCurr=GWEN_DB_GetNextGroup(dbCurr); } return 0; } int _parseTransData(AH_JOB *j, AB_IMEXPORTER_ACCOUNTINFO *ai, const uint8_t *ptrBooked, uint32_t lenBooked, const uint8_t *ptrNoted, uint32_t lenNoted) { int rv; /* read booked transactions */ if (ptrBooked && lenBooked) { rv=_readTransIntoAccountInfo(j, ai, "fints940", AB_Transaction_TypeStatement, ptrBooked, lenBooked); if (rv<0) { DBG_INFO(AQHBCI_LOGDOMAIN, "Error parsing booked transactions (%d)", rv); return rv; } } /* read noted transactions */ if (ptrNoted && lenNoted) { rv=_readTransIntoAccountInfo(j, ai, "fints942", AB_Transaction_TypeNotedStatement, ptrNoted, lenNoted); if (rv<0) { DBG_INFO(AQHBCI_LOGDOMAIN, "Error parsing noted transactions (%d)", rv); return rv; } } return 0; } int _jobApi_ProcessForCreditCard(AH_JOB *j, AB_IMEXPORTER_CONTEXT *ctx) { AB_ACCOUNT *a; AB_IMEXPORTER_ACCOUNTINFO *ai; AB_USER *u; GWEN_DB_NODE *dbResponses; GWEN_DB_NODE *dbCurr; int rv; DBG_INFO(AQHBCI_LOGDOMAIN, "Processing JobGetTransactionsCreditCard"); dbResponses=AH_Job_GetResponses(j); assert(dbResponses); a=AH_AccountJob_GetAccount(j); u=AH_Job_GetUser(j); ai=AB_Provider_GetOrAddAccountInfoForAccount(ctx, a); AB_ImExporterAccountInfo_SetAccountId(ai, AB_Account_GetUniqueId(a)); /* search for "Transactions" */ dbCurr=GWEN_DB_GetFirstGroup(dbResponses); while (dbCurr) { GWEN_DB_NODE *dbXA; rv=AH_Job_CheckEncryption(j, dbCurr); if (rv) { DBG_INFO(AQHBCI_LOGDOMAIN, "Compromised security (encryption)"); AH_Job_SetStatus(j, AH_JobStatusError); return rv; } rv=AH_Job_CheckSignature(j, dbCurr); if (rv) { DBG_INFO(AQHBCI_LOGDOMAIN, "Compromised security (signature)"); AH_Job_SetStatus(j, AH_JobStatusError); return rv; } dbXA=GWEN_DB_GetGroup(dbCurr, GWEN_PATH_FLAGS_NAMEMUSTEXIST, "data/transactionscreditcard"); if (!dbXA) { dbXA=GWEN_DB_GetGroup(dbCurr, GWEN_PATH_FLAGS_NAMEMUSTEXIST, "data/TransactionsCreditCard2"); } if (dbXA) { GWEN_DB_NODE *dbT; dbT=GWEN_DB_GetGroup(dbXA, GWEN_PATH_FLAGS_NAMEMUSTEXIST, "entries"); while (dbT) { AB_TRANSACTION *t; t=_readCreditCardTransactionFromResponse(u, a, dbT); if (t) { DBG_INFO(AQHBCI_LOGDOMAIN, "Adding transaction"); AB_ImExporterAccountInfo_AddTransaction(ai, t); } dbT=GWEN_DB_FindNextGroup(dbT, "entries"); } //while (dbT) } //if (dbXA) dbCurr=GWEN_DB_GetNextGroup(dbCurr); } AB_Provider_DumpTransactionsIfDebug(ai, AQHBCI_LOGDOMAIN); return 0; } AB_TRANSACTION *_readCreditCardTransactionFromResponse(AB_USER *u, AB_ACCOUNT *a, GWEN_DB_NODE *dbTransaction) { GWEN_DATE *date=NULL; GWEN_DATE *valutaDate=NULL; AB_VALUE *value=NULL; const char *p; const char *ref; int i; GWEN_STRINGLIST *purpose; AB_TRANSACTION *t; p=GWEN_DB_GetCharValue(dbTransaction, "date", 0, 0); /* "Buchungsdatum" */ if (p) date=GWEN_Date_fromStringWithTemplate(p, "YYYYMMDD"); p=GWEN_DB_GetCharValue(dbTransaction, "valutaDate", 0, 0); /* "Umsatzdatum" */ if (p) valutaDate=GWEN_Date_fromStringWithTemplate(p, "YYYYMMDD"); value=_readValueFromCreditCardTransResp(dbTransaction); if (value==NULL || (date==NULL && valutaDate==NULL)) { DBG_WARN(AQHBCI_LOGDOMAIN, "Incomplete credit card transaction received"); } /* read purpose */ purpose=GWEN_StringList_new(); for (i=0; i<10; i++) { p=GWEN_DB_GetCharValue(dbTransaction, "purpose", i, 0); if (!p) break; GWEN_StringList_AppendString(purpose, p, 0, 0); } /* read reference */ ref=GWEN_DB_GetCharValue(dbTransaction, "reference", 0, 0); if (ref) GWEN_StringList_AppendString(purpose, ref, 0, 0); t=AB_Transaction_new(); if (ref) AB_Transaction_SetFiId(t, ref); AB_Transaction_SetType(t, AB_Transaction_TypeStatement); AB_Transaction_SetUniqueAccountId(t, AB_Account_GetUniqueId(a)); AB_Transaction_SetLocalBankCode(t, AB_User_GetBankCode(u)); AB_Transaction_SetLocalAccountNumber(t, AB_Account_GetAccountNumber(a)); AB_Transaction_SetValutaDate(t, valutaDate); AB_Transaction_SetDate(t, date); AB_Transaction_SetValue(t, value); AB_Transaction_SetPurposeFromStringList(t, purpose); GWEN_StringList_free(purpose); AB_Value_free(value); GWEN_Date_free(date); GWEN_Date_free(valutaDate); return t; } AB_VALUE *_readValueFromCreditCardTransResp(GWEN_DB_NODE *dbTransaction) { GWEN_DB_NODE *dbV; const char *p; AB_VALUE *value=NULL; dbV=GWEN_DB_GetGroup(dbTransaction, GWEN_PATH_FLAGS_NAMEMUSTEXIST, "value"); if (dbV) value=AB_Value_fromDb(dbV); if (value==NULL) { DBG_ERROR(AQHBCI_LOGDOMAIN, "Error parsing value from DB"); return NULL; } p=GWEN_DB_GetCharValue(dbTransaction, "debitMark", 0, 0); if (p) { if (strcasecmp(p, "D")==0 || strcasecmp(p, "RC")==0) { AB_Value_Negate(value); } else if (strcasecmp(p, "C")==0 || strcasecmp(p, "RD")==0) { } else { DBG_ERROR(AQHBCI_LOGDOMAIN, "Bad debit mark \"%s\"", p); AB_Value_free(value); return NULL; } } return value; } int _jobApi_GetLimits(AH_JOB *j, AB_TRANSACTION_LIMITS **pLimits) { AB_TRANSACTION_LIMITS *tl; GWEN_DB_NODE *dbParams; dbParams=AH_Job_GetParams(j); tl=AB_TransactionLimits_new(); AB_TransactionLimits_SetCommand(tl, AH_Job_GetSupportedCommand(j)); AB_TransactionLimits_SetMaxValueSetupTime(tl, GWEN_DB_GetIntValue(dbParams, "storeDays", 0, 0)); /* nothing more to set for this kind of job */ *pLimits=tl; return 0; } int _jobApi_HandleCommand(AH_JOB *j, const AB_TRANSACTION *t) { const GWEN_DATE *da; da=AB_Transaction_GetFirstDate(t); if (da) { char dbuf[16]; GWEN_DB_NODE *dbArgs; dbArgs=AH_Job_GetArguments(j); snprintf(dbuf, sizeof(dbuf), "%04d%02d%02d", GWEN_Date_GetYear(da), GWEN_Date_GetMonth(da), GWEN_Date_GetDay(da)); GWEN_DB_SetCharValue(dbArgs, GWEN_DB_FLAGS_OVERWRITE_VARS, "fromDate", dbuf); } da=AB_Transaction_GetLastDate(t); if (da) { char dbuf[16]; GWEN_DB_NODE *dbArgs; dbArgs=AH_Job_GetArguments(j); snprintf(dbuf, sizeof(dbuf), "%04d%02d%02d", GWEN_Date_GetYear(da), GWEN_Date_GetMonth(da), GWEN_Date_GetDay(da)); GWEN_DB_SetCharValue(dbArgs, GWEN_DB_FLAGS_OVERWRITE_VARS, "toDate", dbuf); } return 0; } void _appendBufferToFile(const char *fname, const char *ptr, uint32_t length) { if (ptr && length) { FILE *f; f=fopen(fname, "w+"); if (f) { if (fwrite(ptr, length, 1, f)!=1) { DBG_ERROR(AQHBCI_LOGDOMAIN, "fwrite: %s", strerror(errno)); } if (fclose(f)) { DBG_ERROR(AQHBCI_LOGDOMAIN, "fclose: %s", strerror(errno)); } } } }