author | mickeyl <mickeyl> | 2004-11-04 10:33:04 (UTC) |
---|---|---|
committer | mickeyl <mickeyl> | 2004-11-04 10:33:04 (UTC) |
commit | 7855b19ce0241a7b7b4fc72e3a8ddd9bf73b0a77 (patch) (side-by-side diff) | |
tree | e76604c6af3da9c19b69dcdcf8105d58bac63f71 /noncore/unsupported/qashmoney/transaction.h | |
parent | cd2d50799e087fad5b56df9d7fe9aa572a313e64 (diff) | |
download | opie-7855b19ce0241a7b7b4fc72e3a8ddd9bf73b0a77.zip opie-7855b19ce0241a7b7b4fc72e3a8ddd9bf73b0a77.tar.gz opie-7855b19ce0241a7b7b4fc72e3a8ddd9bf73b0a77.tar.bz2 |
opie-qashmoney is now unsupported
Diffstat (limited to 'noncore/unsupported/qashmoney/transaction.h') (more/less context) (ignore whitespace changes)
-rwxr-xr-x | noncore/unsupported/qashmoney/transaction.h | 73 |
1 files changed, 73 insertions, 0 deletions
diff --git a/noncore/unsupported/qashmoney/transaction.h b/noncore/unsupported/qashmoney/transaction.h new file mode 100755 index 0000000..3df43a8 --- a/dev/null +++ b/noncore/unsupported/qashmoney/transaction.h @@ -0,0 +1,73 @@ +#ifndef TRANSACTION_H +#define TRANSACTION_H + +#include <qstring.h> +#include <qlistview.h> +#include <qdatetime.h> +#include <sqlite3.h> + +#include "preferences.h" + +class Transaction + { + public: + + Transaction (); + ~Transaction (); + + // This function adds a new transaction to the database. It takes the payee, accountid, + // budgetid, number, day, month, year, amount, cleared + void addTransaction ( QString description, QString payee, int accountid, int parentid, int number, int day, int month, int year, float amount, int cleared, int budgetid, int lineitemid ); + + // This updates an already existing transaction + void updateTransaction ( QString, QString, int, int, int, int, float, int, int, int, int ); + + // Deletes a transaction. Takes the transid as its parameter + void deleteTransaction ( int ); + + // Returns the number of transactions + int getNumberOfTransactions (); + + // this is an overloaded function that returns the number of + // transactions for an account + int getNumberOfTransactions ( int ); + + // deletes all transactions for the provided accountid + void deleteAllTransactions ( int accountid ); + + QString getBudgetTotal ( int budgetid, int lineitemid, int year, int month, int viewtype ); + QString getActualTotal ( int budgetid, int year, int month, int viewtype ); + + // These two functions clear budget ids is either a line item or an entire budget is deleted + void clearBudgetIDs ( int, int ); + void clearBudgetIDs ( int ); + + public slots: + + void displayTransactions ( QListView *, int, bool, const char *, QDate ); + char ** selectAllTransactions ( QDate fromdate, bool children, const char *limit, int id ); + char ** selectNonClearedTransactions ( QDate fromdate, bool children, const char *limit, int id ); + QString getPayee ( int ); + QString getTransactionDescription ( int ); + QString getNumber ( int ); + QString getAmount ( int ); + QString getAbsoluteAmount ( int ); + int getCleared ( int ); + void setCleared ( int id, int cleared ); + int getBudgetID ( int id ); + int getLineItemID ( int id ); + int getDay ( int ); + int getMonth ( int ); + int getYear ( int ); + int getAccountID ( int id ); + + private: + + sqlite3 *tdb; + int rows, columns; + }; + +#endif + + + |