Initial revision

14 files changed, 2061 insertions, 0 deletions

diff --git a/noncore/apps/qashmoney/CHANGES b/noncore/apps/qashmoney/CHANGES
new file mode 100755
index 0000000..f17035b
--- a/dev/null
+++ b/noncore/apps/qashmoney/CHANGES
@@ -0,0 +1,24 @@
+QashMoney - Budget Software for the Sharp Zaurus
+
+CHANGES
+
+11/1/02 - Initial release of 0.2 version.  Considered stable beta version.
+11/16/02 - Release of version 0.3.  This is a stable version adding function to
+ transfer money between accounts.  Several bugs fixes and speed enhancements
+ have been done.
+11/21/02 - 0.31 news tabs working but not yet displaying accounts
+12/15/02 - QashMoney gets a complete face lift and now has a date picker.
+12/29/02 - Version 0.41 released.  This release fixes more bugs and adds a
+ function to manage transaction memory items.
+12/31/02 - Version 0.42 released.  Maintenance release fixing soem rather nasty
+ bugs that screw up account, transaction, and transfer displays.
+03/03/03 - Version 0.60 released.  QashMoney has undergone quite a transformation.
+ A new GUI that incorporates all of Qts excellent layout capabilities should
+ display nicely in all formats.  A new embedded SQL database should make QashMoney
+very extensible.
+4/25/03 - Version 0.70 released.  This version includes many new features over 0.60 including
+currency support for accounts, a function to limit transaction views, and an all new budgeting
+tab that allows multiple budgets and currency support.
+5/7/03 - Version 0.73 released.  Few minor bugfixes and feature enhancements.  QashMoney now
+right justifies all numbers and remembers the sate in which you leave the account window.  So, if you
+collapse a parent account, it will stay collapsed (even between QashMoney restarts).  
diff --git a/noncore/apps/qashmoney/account.h b/noncore/apps/qashmoney/account.h
new file mode 100755
index 0000000..f77f400
--- a/dev/null
+++ b/noncore/apps/qashmoney/account.h
@@ -0,0 +1,100 @@
+#ifndef ACCOUNT_H
+#define ACCOUNT_H
+
+#include <qstring.h>
+#include <qlistview.h>
+#include <qcombobox.h>
+#include <sqlite.h>
+
+class Account
+  {
+    public:
+
+      Account ();
+      ~Account ();
+
+      // This function adds a new account to the database.  It takes the account name, parent,
+      // initial balance and the account type, description, credit limit, statementbalancedate
+      // as three integers, and the statementbalance amount
+      // The parent is an integer account id.  Its -1 if there is no parent
+      // The account types (so far)  are 0=not defined 1=parent checking 2=child checking
+      void addAccount ( QString, int, float, int, QString, float, int, int, int, float, const char * );
+
+      // updates certain parts of an account
+      void updateAccount ( QString name, QString description, QString currencycode, int accountid );
+
+      void setAccountExpanded ( int expanded, int accountid );
+      int getAccountExpanded ( int id );
+
+      // Deletes an account
+      // Takes the accountid as its parameter
+      void deleteAccount ( int );
+
+      // Returns the number of accounts
+      int getNumberOfAccounts ();
+
+      // returns number of child accounts for a given parent
+      // this function is useless for child accounts.  It will
+      // always return 0
+      int getNumberOfChildAccounts ( int );
+
+      // This function retrieves all transactions for an account and updates the
+      // account balance based on the transactions
+      void updateAccountBalance ( int accountid );
+      //void changeAccountBalance ( int accountid, float amount );
+
+      // updates a parent account
+      void changeParentAccountBalance ( int parentid );
+
+      // Returns the parent account ID for an account
+      // Takes the account name as its parameter or the account id
+      int getParentAccountID ( QString accountname );
+      int getParentAccountID ( int id );
+
+      // This takes a QListView and puts parents and children memorys
+      // into the list view
+      void displayAccounts ( QListView * );
+
+      // This function displays a sorted list of account names in a combobox
+      // Takes the combobox address for its parameter
+      int displayParentAccountNames ( QComboBox *, QString );
+
+      int getAccountType ( int );  // returns account type for given account id
+
+      // The next three collectively return a date or balance
+      // They take the accountid as their parameters
+      int getStatementDay ( int );
+      int getStatementMonth ( int );
+      int getStatementYear ( int );
+      float getStatementBalance ( int );
+
+      // Returns account description and name
+      QString getAccountDescription ( int accountid );
+      QString getCurrencyCode ( int accountid );
+      QString getAccountName ( int accountid );
+      QStringList getAccountNames ();
+      QStringList getAccountIDs ();
+      QString getAccountBalance ( int accountid );
+
+      // returns account credit limit
+      float getAccountCreditLimit ( int );
+
+      // The primary database that stores all our data
+      sqlite *adb;
+  };
+
+class GreyBackgroundItem : public QListViewItem
+  {
+    public:
+
+      GreyBackgroundItem ( QListView *parent );
+      GreyBackgroundItem ( QListView *parent, QString label1, QString label2, QString label3 );
+      GreyBackgroundItem ( QListView *parent, QString label1, QString label2, QString label3, QString label4 );
+      GreyBackgroundItem ( QListView *parent, QString label1, QString label2, QString label3, QString label4, QString label5 );
+
+      virtual void paintCell ( QPainter *p, const QColorGroup &cg, int column, int width, int alignment );
+
+  };
+
+#endif
+
diff --git a/noncore/apps/qashmoney/accountdisplay.cpp b/noncore/apps/qashmoney/accountdisplay.cpp
new file mode 100755
index 0000000..46ab1db
--- a/dev/null
+++ b/noncore/apps/qashmoney/accountdisplay.cpp
@@ -0,0 +1,432 @@
+#include <qdatetime.h>
+#include <qmessagebox.h>
+#include <qheader.h>
+
+#include "accountdisplay.h"
+#include "newaccount.h"
+#include "transaction.h"
+#include "transferdialog.h"
+#include "preferences.h"
+#include "transfer.h"
+
+extern Account *account;
+extern Transaction *transaction;
+extern Transfer *transfer;
+extern Preferences *preferences;
+
+AccountDisplay::AccountDisplay ( QWidget *parent ) : QWidget ( parent )
+  {
+    cleared = 0;
+
+    firstline = new QHBox ( this );
+    firstline->setSpacing ( 2 );
+
+    newaccount = new QPushButton ( firstline );
+    newaccount->setPixmap ( QPixmap ("/opt/QtPalmtop/pics/new.png") );
+    connect ( newaccount, SIGNAL ( released () ), this, SLOT ( addAccount () ) );
+
+    editaccount = new QPushButton ( firstline );
+    editaccount->setPixmap ( QPixmap ("/opt/QtPalmtop/pics/edit.png") );
+    connect ( editaccount, SIGNAL ( released () ), this, SLOT ( editAccount () ) );
+
+    deleteaccount = new QPushButton ( firstline );
+    deleteaccount->setPixmap( QPixmap ( "/opt/QtPalmtop/pics/delete.png") );
+    connect ( deleteaccount, SIGNAL ( released () ), this, SLOT ( deleteAccount () ) );
+
+    transferbutton = new QPushButton ( firstline );
+    transferbutton->setPixmap( QPixmap ( "/opt/QtPalmtop/pics/transfer.png") );
+    transferbutton->setToggleButton ( TRUE );
+    connect ( transferbutton, SIGNAL ( toggled ( bool ) ), this, SLOT ( accountTransfer ( bool ) ) );
+
+    listview = new QListView ( this );
+    listview->setAllColumnsShowFocus ( TRUE );
+    listview->setShowSortIndicator ( TRUE );
+    listview->setRootIsDecorated ( TRUE );
+    listview->setMultiSelection ( FALSE );
+    connect ( listview, SIGNAL ( expanded ( QListViewItem * ) ), this, SLOT ( setAccountExpanded ( QListViewItem * ) ) );
+    connect ( listview, SIGNAL ( collapsed ( QListViewItem * ) ), this, SLOT ( setAccountCollapsed ( QListViewItem * ) ) );
+
+    listview->header()->setTracking ( FALSE );
+    connect ( listview->header(), SIGNAL ( sizeChange ( int, int, int ) ), this, SLOT ( saveColumnSize ( int, int, int ) ) );
+
+    layout = new QVBoxLayout ( this, 2, 5 );
+    layout->addWidget ( firstline );
+    layout->addWidget ( listview );
+  }
+
+void AccountDisplay::setTabs ( QWidget *newtab2, QTabWidget *newtabs )
+  {
+    tab2 = newtab2;
+    maintabs = newtabs;
+  }
+
+void AccountDisplay::addAccount ()
+  {
+    // initialize local variables
+    int parentid = 0;
+    type = 0;
+    QString parentlist [ listview->childCount() + 1 ] [ 3 ] ;
+
+    // create new account window for entering data
+    NewAccount *newaccount = new NewAccount ( this );
+    int width = this->width();
+    newaccount->accountbox->setMaximumWidth ( ( int ) ( width * 0.5 ) );
+    newaccount->datebox->setMaximumWidth ( ( int ) ( width * 0.4 ) );
+    newaccount->childbox->setMaximumWidth ( ( int ) ( width * 0.5 ) );
+    newaccount->balancebox->setMaximumWidth ( ( int ) ( width * 0.4 ) );
+    newaccount->creditlimitbox->setMaximumWidth ( ( int ) ( width * 0.4 ) );
+
+    // if there are no accounts, disable the child check box
+    if ( account->getNumberOfAccounts () == 0 )
+      newaccount->childcheckbox->setEnabled ( FALSE );
+
+    // if there are accounts, fill up the pulldown menu for
+    // selecting a parent account.  We should only add those parents without transactions
+    else
+      {
+        int c = 0;
+        QListViewItemIterator it ( listview );
+        for ( ; it.current(); ++it )
+          {
+            int id = it.current()->text ( getIDColumn() ).toInt();
+            // iterate through accountdisplay listview and add parents with no transactions
+            // add this item to the list box only if it is a parent and has no transactions
+            if ( transfer->getNumberOfTransfers ( id ) == 0 && transaction->getNumberOfTransactions ( id ) == 0 && it.current()->parent() == 0  )
+              {
+                newaccount->childbox->insertItem ( it.current()->text ( 0 ) );
+                parentlist [ c ] [ 0 ] = it.current()->text ( 0 );
+                parentlist [ c ] [ 1 ] = it.current()->text ( getIDColumn() );
+                parentlist [ c ] [ 2 ] = QString::number ( c );
+                c++;
+              }
+          }
+      }
+
+    if ( preferences->getPreference ( 4 ) == 0 )
+      newaccount->currencybox->setEnabled ( FALSE );
+
+    // enter today's date in the date box as default
+    QDate today = QDate::currentDate ();
+    int defaultday = today.day();
+    int defaultmonth = today.month();
+    int defaultyear  = today.year();
+    newaccount->startdate->setText ( preferences->getDate ( defaultyear, defaultmonth, defaultday )  );
+
+    //add account information if user pushes OK button
+    if ( newaccount->exec() == QDialog::Accepted )
+      {
+        if ( newaccount->childcheckbox->isChecked () == TRUE ) // set a parent id and type for a child account
+          {
+            // go through the parentlist we created and determine the parent accountid
+            // we can't use the name of the account because there may be two accounts
+            // with the same name.  This function does it all by accountid
+            int counter;
+            for ( counter = 0; counter < listview->childCount() + 1; counter++ )
+              if ( ( parentlist [ counter ] [ 2 ].toInt() ) == newaccount->childbox->currentItem() )
+                {
+                  parentid = parentlist [ counter ] [ 1 ].toInt();
+                  break;
+                }
+            type = ( newaccount->accounttype->currentItem() ) + 6;  // sets account ids for child accounts.  See accountdisplay.h for types
+          }
+        else
+          {
+            parentid = -1;
+            type = newaccount->accounttype->currentItem(); // sets account ids for parent accounts
+          }
+
+        // add the new account
+	if ( newaccount->getDateEdited () == TRUE )
+          account->addAccount ( newaccount->accountname->text(), parentid, newaccount->accountbalance->text().toFloat(), type,
+          newaccount->getDescription(), newaccount->creditlimit->text().toFloat(), newaccount->getYear(),
+          newaccount->getMonth(), newaccount->getDay(), newaccount->accountbalance->text().toFloat(), newaccount->currencybox->currencybox->currentText() );
+	else
+          account->addAccount ( newaccount->accountname->text (), parentid, newaccount->accountbalance->text().toFloat(), type,
+          newaccount->getDescription(), newaccount->creditlimit->text().toFloat(), defaultyear,
+          defaultmonth, defaultday, newaccount->accountbalance->text().toFloat(), newaccount->currencybox->currencybox->currentText() );
+
+        if ( parentid != -1 )
+          account->changeParentAccountBalance ( parentid );
+
+        // redisplay accounts
+        // this function clears the account display first
+        account->displayAccounts ( listview );
+        setToggleButton();
+      }
+     maintabs->setTabEnabled ( tab2, FALSE );
+  }
+
+void AccountDisplay::deleteAccount ()
+  {
+    if ( listview->selectedItem() == 0 )
+      QMessageBox::warning ( this, "QashMoney", "Please select an account\nto delete.");
+    else if ( listview->selectedItem()->parent() == 0 && listview->selectedItem()->childCount() != 0 )
+      QMessageBox::warning ( this, "QashMoney", "Can't delete parent accounts\nwith children");
+    else
+    {
+      QMessageBox mb ( "Delete Account", "This will delete all transactions\nand transfers for this account.", QMessageBox::Information, QMessageBox::Ok, QMessageBox::Cancel, QMessageBox::NoButton );
+      if ( mb.exec() == QMessageBox::Ok )
+        {
+          int accountid = listview->selectedItem()->text ( getIDColumn() ).toInt ();
+          int parentid = account->getParentAccountID ( accountid );
+
+          // delete all the transactions and transfers for the account
+          transaction->deleteAllTransactions ( accountid );
+          transfer->deleteAllTransfers ( accountid );
+
+          // delete the account
+          account->deleteAccount ( accountid );
+
+          // update account balances
+          if ( parentid != -1 )
+            account->changeParentAccountBalance ( parentid );
+
+          //redisplay accounts
+          account->displayAccounts ( listview );
+
+          //remove all the columns from the accountdisplay if there are not any accounts
+          if ( account->getNumberOfAccounts() == 0 )
+            {
+              int columns = listview->columns();
+              int counter;
+              for ( counter = 0; counter <= columns; counter++ )
+                listview->removeColumn ( 0 );
+            }
+
+          setToggleButton();
+        }
+    }
+    maintabs->setTabEnabled ( tab2, FALSE );
+  }
+
+void AccountDisplay::setToggleButton ()
+  {
+    // iterate through account display and determine how many "transferable" accounts we have
+    // if there are less than two, disable the transfer button
+    QListViewItemIterator it ( listview );
+    int counter = 0;
+    for ( ; it.current(); ++it )
+      {
+        // add one to counter if we find a transferable account
+        if ( it.current()->parent() != 0 || ( it.current()->childCount() ) == 0 )
+          counter++;
+      }
+    if ( counter > 1 )
+      transferbutton->show();
+    else
+      transferbutton->hide();
+  }
+
+void AccountDisplay::accountTransfer ( bool state )
+  {
+    if ( state == TRUE )
+      {
+        firstaccountid = -1;
+        secondaccountid = -1;
+        listview->clearSelection ();
+        listview->setMultiSelection ( TRUE );
+        disableParentsWithChildren ();
+        connect ( listview, SIGNAL ( clicked ( QListViewItem * ) ), this, SLOT ( getTransferAccounts ( QListViewItem * ) ) );
+      }
+    else
+      {
+        firstaccountid = -1;
+        secondaccountid = -1;
+        listview->clearSelection ();
+	listview->setMultiSelection ( FALSE );
+        enableAccounts ();
+        disconnect ( listview, SIGNAL ( clicked ( QListViewItem * ) ), this, SLOT ( getTransferAccounts ( QListViewItem * ) ) );
+      }
+  }
+
+void AccountDisplay::getTransferAccounts ( QListViewItem * item )
+  {
+    if ( item->parent() != 0 || item->childCount() == 0 ) // only set an account for transfer if its a child or parent with no children
+      {
+        if ( firstaccountid == -1 )
+          firstaccountid = item->text ( getIDColumn() ).toInt(); // set first account if we've selected a valid account
+        else
+          if ( item->text ( getIDColumn() ).toInt() != firstaccountid ) // set the second account if its not equal to the first
+            secondaccountid = item->text ( getIDColumn() ).toInt();
+      }
+
+    // open transfer window if both accounts are set
+    if ( firstaccountid != -1 && secondaccountid != -1 )
+      {
+        // construct the transferdialog window
+        TransferDialog *td = new TransferDialog ( this, firstaccountid, secondaccountid );
+
+        // enter today's date in the date box as default
+        QDate today = QDate::currentDate ();
+        int defaultday = today.day();
+        int defaultmonth = today.month();
+        int defaultyear  = today.year();
+        td->date->setText ( preferences->getDate ( defaultyear, defaultmonth, defaultday ) );
+
+        if ( td->exec() == QDialog::Accepted )
+          {
+            // set the cleared integer if the checkbox is checked
+            if ( td->clearedcheckbox->isChecked() == TRUE )
+              cleared = 1;
+
+            // add the transfer with a new date if its been edited or use the default date
+            if ( td->getDateEdited () == TRUE )
+              transfer->addTransfer ( firstaccountid, account->getParentAccountID ( firstaccountid ), secondaccountid,
+              account->getParentAccountID ( secondaccountid ), td->getDay(), td->getMonth(), td->getYear(), td->amount->text().toFloat(), cleared );
+            else
+              transfer->addTransfer ( firstaccountid, account->getParentAccountID ( firstaccountid ), secondaccountid,
+                account->getParentAccountID ( secondaccountid ), defaultday, defaultmonth, defaultyear, td->amount->text().toFloat(), cleared );
+
+            // update account balances of both accounts and parents if necessary
+            account->updateAccountBalance ( firstaccountid );
+             if ( account->getParentAccountID ( firstaccountid ) != -1 )
+               account->changeParentAccountBalance ( account->getParentAccountID ( firstaccountid ) );
+            account->updateAccountBalance ( secondaccountid );
+            if ( account->getParentAccountID ( secondaccountid ) != -1 )
+               account->changeParentAccountBalance ( account->getParentAccountID ( secondaccountid ) );
+
+            // redisplay accounts
+            account->displayAccounts ( listview );
+          }
+        else
+          {
+            firstaccountid = -1;
+            secondaccountid = -1;
+            listview->clearSelection ();
+	    listview->setMultiSelection ( FALSE );
+            disconnect ( listview, SIGNAL ( clicked ( QListViewItem * ) ), this, SLOT ( getTransferAccounts ( QListViewItem * ) ) );
+          }
+
+       // reset the accounts display window
+       transferbutton->toggle(); // toggling this button with clear the window as well
+
+       // reenable all the accounts so the transaction tab will be properly set
+       enableAccounts ();
+      }
+  }
+
+void AccountDisplay::disableParentsWithChildren ()
+  {
+     // iterate through accountdisplay listview and disable all the parents that have children
+     QListViewItemIterator it ( listview );
+     for ( ; it.current(); ++it )
+       {
+         if ( it.current()->parent() == 0 && it.current()->childCount() != 0 )
+           it.current()->setSelectable ( FALSE );
+       }
+  }
+
+void AccountDisplay::enableAccounts ()
+  {
+     // iterate through accountdisplay listview and enable all accounts
+     QListViewItemIterator it ( listview );
+     for ( ; it.current(); ++it )
+       it.current()->setSelectable ( TRUE );
+  }
+
+void AccountDisplay::saveColumnSize ( int column, int oldsize, int newsize )
+  {
+    switch ( column )
+      {
+        case 0:
+          if ( listview->columns() == 3 )
+            preferences->changeColumnPreference ( 1, newsize );
+          else
+            preferences->changeColumnPreference ( 10, newsize );
+          break;
+        case 1:
+          if ( listview->columns() == 3 )
+            preferences->changeColumnPreference ( 2, newsize );
+          else
+            preferences->changeColumnPreference ( 11, newsize );
+          break;
+        case 2:
+            preferences->changeColumnPreference ( 12, newsize );
+          break;
+      }
+
+  }
+
+int AccountDisplay::getIDColumn ()
+  {
+    int counter;
+    int columns = listview->columns();
+    for ( counter = 0; counter <= columns; counter++ )
+      if ( listview->header()->label ( counter ).length() == 0 )
+        return counter;
+  }
+
+void AccountDisplay::editAccount ()
+  {
+    if ( listview->selectedItem() == 0 )
+      QMessageBox::warning ( this, "QashMoney", "Please select an account\nto edit.");
+    else
+      {
+        // set the accountid
+        int accountid = listview->selectedItem()->text ( getIDColumn() ).toInt();
+
+        //construct new dialog box
+        QDialog *editaccountwindow = new QDialog ( this, 0, TRUE );
+        editaccountwindow->setCaption ( "Edit Account" );
+
+        // construct the items which will go in the dialog bix
+        QLabel *namelabel = new QLabel ( "Account Name", editaccountwindow );
+        QLineEdit *accountname = new QLineEdit ( editaccountwindow );
+        QLabel *descriptionlabel = new QLabel ( "Account Description", editaccountwindow );
+        QLineEdit *accountdescription = new QLineEdit ( editaccountwindow );
+        Currency *currencybox = new Currency ( editaccountwindow );
+
+        QVBoxLayout *layout = new QVBoxLayout ( editaccountwindow, 5, 2 );
+        layout->addWidget ( namelabel );
+        layout->addWidget ( accountname );
+        layout->addWidget ( descriptionlabel );
+        layout->addWidget ( accountdescription );
+        layout->addWidget ( currencybox );
+
+        //set the account name
+        accountname->setText ( listview->selectedItem()->text ( 0 ) );
+
+        //set the account description
+        accountdescription->setText ( account->getAccountDescription ( accountid ) );
+
+        if ( preferences->getPreference ( 4 ) == 1 )
+          {
+            // get currency code for this account then iterate through the currency box
+            // to find the one we want
+            int count = currencybox->currencybox->count();
+            QString code = account->getCurrencyCode ( accountid );
+            for ( int counter = 0; count - 1; counter++ )
+              {
+                if ( QString::compare ( currencybox->currencybox->text ( counter ), code ) == 0 )
+                  {
+                    currencybox->currencybox->setCurrentItem ( counter );
+                    break;
+                  }
+              }
+            }
+          else
+            currencybox->setEnabled ( FALSE );
+
+        //execute the dialog box
+        int response = editaccountwindow->exec();
+        if ( response == 1 )
+         {
+           account->updateAccount ( accountname->text(), accountdescription->text(), currencybox->currencybox->currentText(), accountid );
+           account->displayAccounts ( listview );
+         }
+      }
+  }
+
+void AccountDisplay::setAccountExpanded ( QListViewItem *item )
+  {
+    int accountid = item->text ( getIDColumn() ).toInt();
+    account->setAccountExpanded ( 1, accountid );
+  }
+
+void AccountDisplay::setAccountCollapsed ( QListViewItem *item )
+  {
+    int accountid = item->text ( getIDColumn() ).toInt();
+    account->setAccountExpanded ( 0, accountid );
+  }
+
+
diff --git a/noncore/apps/qashmoney/budget.cpp b/noncore/apps/qashmoney/budget.cpp
new file mode 100755
index 0000000..42f7eca
--- a/dev/null
+++ b/noncore/apps/qashmoney/budget.cpp
@@ -0,0 +1,221 @@
+#include "budget.h"
+#include "transaction.h"
+#include <stdlib.h>
+
+extern Transaction *transaction;
+
+Budget::Budget ()
+  {
+    bdb = sqlite_open ( "qmbudgets.db", 0, NULL );
+  }
+
+Budget::~Budget ()
+  {
+    sqlite_close ( bdb );
+  }
+
+int Budget::addBudget ( QString name, int type, QString description, QString currency, int startday, int startmonth, int startyear, int endday, int endmonth, int endyear, int defaultview )
+  {
+    sqlite_exec_printf ( bdb, "insert into budgets values ( '%q', %i, '%q', '%q', %i, %i, %i, %i, %i, %i, %i, NULL );", 0, 0, 0, ( const char * ) name, type, ( const char * ) description, ( const char * ) currency, startday, startmonth, startyear, endday, endmonth, endyear, defaultview );
+    char **results;
+    sqlite_get_table ( bdb, "select last_insert_rowid() from budgets;", &results, NULL, NULL, NULL );
+    QString tablename = "table";
+    tablename.append ( results [ 1 ] );
+    sqlite_exec_printf ( bdb, "create table '%q' ( name, lineitemamount, type, lineitemid integer primary key );", 0, 0, 0, ( const char* ) tablename );
+    return atoi ( results [ 1 ] );
+  }
+
+void Budget::updateBudget ( QString name, QString description, QString currency, int budgetid )
+  {
+    sqlite_exec_printf ( bdb, "update budgets set name = '%q', description = '%q', currency = '%q' where budgetid = %i;", 0, 0, 0, ( const char * ) name, ( const char * ) description, ( const char * ) currency, budgetid );
+  }
+
+void Budget::deleteBudget ( int budgetid )
+  {
+    if ( getNumberOfBudgets() != 0 )
+      {
+        QString tablename = "table";
+        tablename.append ( QString::number ( budgetid ) );
+        sqlite_exec_printf ( bdb, "delete from budgets where budgetid = %i;", 0, 0, 0, budgetid );
+        sqlite_exec_printf ( bdb, "drop table '%q';", 0, 0, 0, ( const char* ) tablename );
+      }
+  }
+
+int Budget::getNumberOfBudgets ()
+  {
+    char **results;
+    sqlite_get_table ( bdb, "select count() from budgets;", &results, NULL, NULL, NULL );
+    return atoi ( results [ 1 ] );
+  }
+
+int Budget::getNumberOfLineItems ( int budgetid )
+  {
+    QString tablename = "table";
+    tablename.append ( QString::number ( budgetid ) );
+    char **results;
+    sqlite_get_table_printf ( bdb, "select count() from '%q';", &results, NULL, NULL, NULL, ( const char * ) tablename );
+    return atoi ( results [ 1 ] );
+  }
+
+QStringList* Budget::getBudgetNames ()
+  {
+    QStringList *names = new QStringList ();
+    char **results;
+    int rows, counter;
+    sqlite_get_table ( bdb, "select name from budgets order by name asc;", &results, &rows, NULL, NULL );
+    names->append ( "None" );
+    for ( counter = 0; counter < rows; counter++ )
+      names->append ( results [ counter+1 ] );
+    return names;
+  }
+
+QString Budget::getBudgetName ( int budgetid )
+  {
+    char **results;
+    sqlite_get_table_printf ( bdb, "select name from budgets where budgetid= %i;", &results, NULL, NULL, NULL, budgetid );
+    return ( QString ) results [ 1 ];
+  }
+
+QString Budget::getBudgetDescription ( int budgetid )
+  {
+    char **results;
+    sqlite_get_table_printf ( bdb, "select description from budgets where budgetid= %i;", &results, NULL, NULL, NULL, budgetid );
+    return ( QString ) results [ 1 ];
+  }
+
+QString Budget::getCurrency ( int budgetid )
+  {
+    char **results;
+    sqlite_get_table_printf ( bdb, "select currency from budgets where budgetid= %i;", &results, NULL, NULL, NULL, budgetid );
+    return ( QString ) results [ 1 ];
+  }
+
+QStringList* Budget::getBudgetIDs ()
+  {
+    QStringList *ids = new QStringList ();
+    char **results;
+    int rows, counter;
+    sqlite_get_table ( bdb, "select budgetid from budgets;", &results, &rows, NULL, NULL );
+    for ( counter = 0; counter < rows; counter++ )
+      ids->append ( results [ counter+1 ] );
+    return ids;
+  }
+
+int Budget::addLineItem ( int budgetid, QString lineitemname, float lineitemamount, int lineitemtype )
+  {
+    QString tablename = "table";
+    tablename.append ( QString::number ( budgetid ) );
+    sqlite_exec_printf ( bdb, "insert into '%q' values ( '%q', %.2f, %i, NULL );", 0, 0, 0, ( const char* ) tablename, ( const char* ) lineitemname, lineitemamount, lineitemtype );
+    char **results;
+    sqlite_get_table_printf ( bdb, "select last_insert_rowid() from '%q';", &results, NULL, NULL, NULL, ( const char* ) tablename );
+    return atoi ( results [ 1 ] );
+  }
+
+void Budget::updateLineItem ( QString lineitemname, float lineitemamount, int lineitemtype, int budgetid, int lineitemid )
+  {
+    QString tablename = "table";
+    tablename.append ( QString::number ( budgetid ) );
+    sqlite_exec_printf ( bdb, "update '%q' set name = '%q', lineitemamount = %f, type = %i where lineitemid = %i;", 0, 0, 0, ( const char* ) tablename, ( const char * ) lineitemname, lineitemamount, lineitemtype, lineitemid );
+  }
+
+void Budget::deleteLineItem ( int budgetid, int lineitemid )
+  {
+    QString tablename = "table";
+    tablename.append ( QString::number ( budgetid ) );
+   sqlite_exec_printf ( bdb, "delete from '%q' where lineitemid = %i;", 0, 0, 0, ( const char * ) tablename, lineitemid );
+  }
+
+void Budget::displayLineItems ( int budgetid, QListView *listview, int month, int year, int viewtype )
+  {
+    QString tablename = "table";
+    tablename.append ( QString::number ( budgetid ) );
+    char **results;
+    int rows, columns, counter;
+    sqlite_get_table_printf ( bdb, "select name, lineitemamount, lineitemid from '%q';", &results, &rows, &columns, NULL, ( const char * ) tablename );
+    int total = ( ( rows + 1 ) * columns );
+    for ( counter = 3; counter < total; counter = counter + 3 )
+      {
+        float amount = 0;
+        if ( viewtype == 0 )
+          {
+            QString lineitemamount = results [ counter + 1 ];
+            amount = lineitemamount.toFloat() / 12;
+          }
+        else
+          {
+            QString lineitemamount = results [ counter + 1 ];
+            amount = lineitemamount.toFloat();
+          }
+        QListViewItem *item = new QListViewItem ( listview, results [ counter ], QString::number ( amount, 'f', 2 ), transaction->getBudgetTotal ( budgetid, atoi ( results [ counter + 2 ] ), year, month, viewtype ), results [ counter + 2 ] );
+      }
+  }
+
+QStringList Budget::getLineItems ( int budgetid )
+  {
+    QString tablename = "table";
+    tablename.append ( QString::number ( budgetid ) );
+    QStringList lineitems;
+    char **results;
+    int rows, counter;
+    sqlite_get_table_printf ( bdb, "select name from '%q';", &results, &rows, NULL, NULL, (const char*) tablename );
+    for ( counter = 0; counter < rows; counter++ )
+      lineitems.append ( results [ counter + 1 ] );
+    return lineitems;
+  }
+
+QStringList Budget::getLineItemIDs ( int budgetid )
+  {
+    QString tablename = "table";
+    tablename.append ( QString::number ( budgetid ) );
+    QStringList lineitemids;
+    char **results;
+    int rows, counter;
+    sqlite_get_table_printf ( bdb, "select lineitemid from '%q';", &results, &rows, NULL, NULL, (const char*) tablename );
+    for ( counter = 0; counter < rows; counter++ )
+      lineitemids.append ( results [ counter + 1 ] );
+    return lineitemids;
+  }
+
+int Budget::getLineItemTime ( int budgetid, int lineitemid )
+  {
+    QString tablename = "table";
+    tablename.append ( QString::number ( budgetid ) );
+    char **results;
+    sqlite_get_table_printf ( bdb, "select type from '%q' where lineitemid= %i;", &results, NULL, NULL, NULL, ( const char * ) tablename, lineitemid );
+    return atoi ( results [ 1 ] );
+  }
+
+float Budget::getLineItemAmount ( int budgetid, int lineitemid )
+  {
+    QString tablename = "table";
+    tablename.append ( QString::number ( budgetid ) );
+    char **results;
+    sqlite_get_table_printf ( bdb, "select lineitemamount from '%q' where lineitemid= %i;", &results, NULL, NULL, NULL, ( const char* ) tablename, lineitemid );
+    return strtod ( results [ 1 ], 0 );
+  }
+
+QString Budget::getBudgetTotal ( int budgetid, int viewtype )
+  {
+    QString tablename = "table";
+    tablename.append ( QString::number ( budgetid ) );
+    // determine if we are viewing a years, months, or days budget
+    // we have to pick a different sum for each
+    char **results;
+    sqlite_get_table_printf ( bdb, "select sum ( lineitemamount ) from '%q';", &results, NULL, NULL, NULL, ( const char * ) tablename );
+    QString amount = results [ 1 ];
+    float total  = amount.toFloat();
+    if ( viewtype == 0 )
+      total = total / 12;
+    amount.setNum ( total, 'f', 2 );
+    return amount;
+  }
+
+int Budget::getLastAdded ()
+  {
+    char **results;
+    sqlite_get_table ( bdb, "select last_insert_rowid() from budgets;", &results, NULL, NULL, NULL );
+    return atoi ( results [ 1 ] );
+  }
+
+
+
diff --git a/noncore/apps/qashmoney/budget.h b/noncore/apps/qashmoney/budget.h
new file mode 100755
index 0000000..16af26a
--- a/dev/null
+++ b/noncore/apps/qashmoney/budget.h
@@ -0,0 +1,45 @@
+#ifndef BUDGET_H
+#define BUDGET_H
+
+#include <qstring.h>
+#include <qstringlist.h>
+#include <qlistview.h>
+#include <sqlite.h>
+
+class Budget
+  {
+    public:
+
+      Budget ();
+      ~Budget ();
+
+      int addBudget ( QString name, int type, QString description, QString currency, int startday, int startmonth, int startyear, int endday, int endmonth, int endyear, int defaultview );
+      void updateBudget ( QString name, QString description, QString currency, int budgetid );
+      void deleteBudget ( int budgetid );
+      int getNumberOfBudgets ();
+      int getNumberOfLineItems ( int budgetid );
+
+      QStringList* getBudgetNames ();
+      QStringList* getBudgetIDs ();
+      QStringList getLineItems ( int budgetid );
+      QStringList getLineItemIDs ( int budgetid );
+      QString getBudgetName ( int budgetid );
+      QString getBudgetDescription ( int budgetid );
+      QString getCurrency ( int budgetid );
+      QString getBudgetTotal ( int budgetid, int viewtype );
+
+      int getLastAdded ();
+
+      int addLineItem ( int budgetid, QString lineitemname, float lineitemamount, int lineitemtype );
+      void updateLineItem ( QString lineitemname, float lineitemamount, int lineitemtype, int budgetid, int lineitemid );
+      void displayLineItems ( int budgetid, QListView *listview, int month, int year, int viewtype );
+      void deleteLineItem ( int budgetid, int lineitemid );
+      int getLineItemTime ( int budgetid, int lineitemid );
+      float getLineItemAmount ( int budgetid, int lineitemid );
+
+    private:
+      sqlite *bdb;
+  };
+
+#endif
+
diff --git a/noncore/apps/qashmoney/memory.cpp b/noncore/apps/qashmoney/memory.cpp
new file mode 100755
index 0000000..b5155b3
--- a/dev/null
+++ b/noncore/apps/qashmoney/memory.cpp
@@ -0,0 +1,62 @@
+#include "memory.h"
+
+#include <stdlib.h>
+
+Memory::Memory ()
+  {
+    db = sqlite_open ( "qmmemory.db", 0, NULL );
+  }
+
+Memory::~Memory ()
+  {
+    sqlite_close ( db );
+  }
+
+void Memory::addMemoryItem ( QString item )
+  {
+    sqlite_exec_printf ( db, "insert into memory values ( '%q', 0, 0 );", 0, 0, 0, ( const char * ) item );
+  }
+
+void Memory::deleteMemoryItem ( QString item )
+  {
+    sqlite_exec_printf ( db, "delete from memory where item = '%q';", 0, 0, 0, ( const char * ) item );
+  }
+
+int Memory::getNumberOfMemoryItems ()
+  {
+    char **results;
+    sqlite_get_table ( db, "select count() from memory;", &results, NULL, NULL, NULL );
+    return atoi ( results [ 1 ] );
+  }
+
+void Memory::changeMemoryName ( QString item )
+  {
+    sqlite_exec_printf ( db, "update memory set item = '%q' where item = '%q';", 0, 0, 0, ( const char * ) item );
+  }
+
+void Memory::displayMemoryItems ( QListBox *listbox )
+  {
+    char **results;
+    int rows;
+    sqlite_get_table ( db, "select item from memory order by item asc;", &results, &rows, NULL, NULL );
+    int counter = 1;
+    while ( counter < ( rows + 1 ) )
+      {
+        listbox->insertItem ( results [ counter ] );
+        counter ++;
+      }
+  }
+
+void Memory::displayMemoryItems ( QComboBox *box )
+  {
+    char **results;
+    int rows;
+    sqlite_get_table ( db, "select item from memory order by item asc;", &results, &rows, NULL, NULL );
+    int counter = 1;
+    while ( counter < ( rows + 1 ) )
+      {
+        box->insertItem ( results [ counter ] );
+        counter ++;
+      }
+  }
+
diff --git a/noncore/apps/qashmoney/memory.h b/noncore/apps/qashmoney/memory.h
new file mode 100755
index 0000000..6f3f100
--- a/dev/null
+++ b/noncore/apps/qashmoney/memory.h
@@ -0,0 +1,45 @@
+#ifndef MEMORY_H
+#define MEMORY_H
+
+#include <qstring.h>
+#include <qlistbox.h>
+#include <qcombobox.h>
+#include <sqlite.h>
+
+class Memory : public QObject
+  {
+
+    Q_OBJECT
+
+    public:
+
+      Memory ();
+      ~Memory ();
+
+      // This function adds a new memory to the database.  It takes the memory name, parent,
+      // initial balance, a displayed variable, and the memory type
+      // The parent is an integer memory id.  Its -1 if there is not parent
+      // The memory types  are 0=not defined 1=parent 2=child
+      void addMemoryItem ( QString );
+
+      // Returns the number of checking memorys
+      int getNumberOfMemoryItems ();
+
+      void changeMemoryName ( QString );
+
+      // This takes a QListView and puts parents and children memorys
+      // into the list view
+      void displayMemoryItems ( QListBox * );
+      void displayMemoryItems ( QComboBox * );
+
+      // The primary database that stores all our data
+      sqlite *db;
+
+    public slots:
+
+      // Deletes a memory item.  Takes the memoryid as its parameter
+      void deleteMemoryItem ( QString );
+  };
+
+#endif
+
diff --git a/noncore/apps/qashmoney/preferences.h b/noncore/apps/qashmoney/preferences.h
new file mode 100755
index 0000000..4a3e058
--- a/dev/null
+++ b/noncore/apps/qashmoney/preferences.h
@@ -0,0 +1,50 @@
+#include <sqlite.h>
+#include <qstring.h>
+
+#ifndef PREFERENCES_H
+#define PREFERENCES_H
+
+class Preferences
+  {
+    public:
+      Preferences ();
+      ~Preferences ();
+
+      void addPreferences ();
+      void initializeColumnPreferences ();
+
+      // Returns a preference value for the given preferences ID
+      int getPreference ( int );
+      int getColumnPreference ( int id );
+
+      // Convenience for getting date separator with one function
+      // call.  Takes the preference id as its argument
+      QString getSeparator ( );
+
+      //  Changes a preference for the given ID
+      void changePreference ( int , int );
+      void changeColumnPreference ( int id, int width );
+
+      // The primary database that stores all our data
+      sqlite *db;
+
+      // This function returns a Qstring for the year first date formats
+      // for displaying.  It takes the date numbers
+      QString getDate ( int, int, int );
+      QString getDate ( int y, int m );
+
+      void setDefaultDatePreferences ();
+  };
+
+#endif
+
+
+
+
+
+
+
+
+
+
+
diff --git a/noncore/apps/qashmoney/qashmoney.cpp b/noncore/apps/qashmoney/qashmoney.cpp
new file mode 100755
index 0000000..1ea358c
--- a/dev/null
+++ b/noncore/apps/qashmoney/qashmoney.cpp
@@ -0,0 +1,356 @@
+#include "qashmoney.h"
+#include "preferencedialogs.h"
+#include "memorydialog.h"
+
+#include <qheader.h>
+#include <iostream.h>
+
+Budget *budget = new Budget ();
+Preferences *preferences = new Preferences ();
+Account *account = new Account ();
+Transaction *transaction = new Transaction ();
+Transfer *transfer = new Transfer ();
+Memory *memory = new Memory ();
+
+QashMoney::QashMoney () : QWidget ()
+  {
+    preferences->addPreferences();
+    preferences->initializeColumnPreferences ();
+
+    // set the text in the upper part of the frame
+    setCaption ( tr ( "QashMoney" ) );
+
+    // Create new menubar for our mainwindow
+    // and add menu items
+    mainmenu = new QPEMenuBar ( this );
+    mainmenu->setFrameStyle ( QFrame::PopupPanel | QFrame::Raised );
+    preferencesmenu = new QPopupMenu ( this );
+    utilitiesmenu = new QPopupMenu ( this );
+    mainmenu->insertItem ( "Preferences", preferencesmenu );
+    mainmenu->insertItem ( "Utilities", utilitiesmenu );
+    preferencesmenu->insertItem ( "Date", this, SLOT ( displayDatePreferencesDialog () ) );
+    preferencesmenu->insertItem ( "Account", this, SLOT ( displayAccountPreferencesDialog () ) );
+    preferencesmenu->insertItem ( "Transaction", this, SLOT ( displayTransactionPreferencesDialog () ) );
+    utilitiesmenu->insertItem ( "Memory", this, SLOT ( displayMemoryDialog () ) );
+
+    // create the main tabwidget for displaying accounts and transactions
+    maintabs = new QTabWidget ( this );
+    tab = new QWidget ( this );
+    tab_2 = new QWidget ( this );
+    tab_3 = new QWidget ( this );
+    maintabs->addTab ( tab, "Accounts" );
+    maintabs->addTab ( tab_2, "Transactions" );
+    maintabs->addTab ( tab_3, "Budgets" );
+    tabheight = tab->height();
+    maintabs->setTabEnabled ( tab_2, FALSE );
+
+    // create a new account display object
+    accountdisplay = new AccountDisplay ( maintabs );
+    accountdisplay->setTabs ( tab_2, maintabs );
+    connect ( accountdisplay->listview, SIGNAL ( selectionChanged () ), this, SLOT ( setTransactionTab () ) );
+
+    // set the connection to disable the one touch account viewing if we are transfering money
+    connect ( accountdisplay->transferbutton, SIGNAL ( toggled ( bool ) ), this, SLOT ( toggleOneTouchViewing ( bool ) ) );
+
+    // create a new transactiondisplay object
+    transactiondisplay = new TransactionDisplay ( maintabs );
+    transactiondisplay->hide();
+
+    // create new budgetdisplay object
+    budgetdisplay = new BudgetDisplay ( maintabs );
+    budgetdisplay->hide();
+
+    tabslayout = new QVBoxLayout ( maintabs, 4, 2 );
+    tabslayout->addSpacing ( tabheight );
+    tabslayout->addWidget ( accountdisplay );
+    tabslayout->addWidget ( transactiondisplay );
+    tabslayout->addWidget ( budgetdisplay );
+
+    // connect a change in the maintabs with changing the tab display
+    connect ( maintabs, SIGNAL ( currentChanged ( QWidget * ) ), this, SLOT ( changeTabDisplay () ) );
+
+    // create layout that will contain the menubar and the maintabs
+    layout = new QVBoxLayout ( this, 2, 2 );
+    layout->setMenuBar ( mainmenu );
+    layout->addWidget ( maintabs );
+  }
+
+QashMoney::~QashMoney ()
+  {
+    delete budget;
+    delete preferences;
+    delete account;
+    delete transaction;
+    delete transfer;
+    delete memory;
+  }
+
+void QashMoney::changeTabDisplay ()
+  {
+    // if the user pressed the transactions tab, hide the account display
+    // object and create a new transaction display
+    if ( maintabs->currentPageIndex() == 1 )
+      {
+        // initialize variables
+        bool children = FALSE;
+
+        // hide the account display and define accountid
+        int accountid = accountdisplay->listview->selectedItem()->text ( accountdisplay->getIDColumn() ).toInt();
+
+        //remove all the columns from the transactiondisplay
+        int columns = transactiondisplay->listview->columns();
+        int counter;
+        for ( counter = 0; counter <= columns; counter++ )
+          transactiondisplay->listview->removeColumn ( 0 );
+
+        // set the account name and account balance
+        QString name = account->getAccountName ( accountid );
+        QString balance = account->getAccountBalance ( accountid );
+        transactiondisplay->name->setText ( name );
+        transactiondisplay->balance->setText ( balance );
+
+        // clear the limitbox
+        transactiondisplay->limitbox->clear();
+
+        // get parent account id
+        int parentaccountid = account->getParentAccountID ( accountid );
+
+        // add columns based on which account is selected
+        // this first if determines if we selected a parent with no children or a child
+        // in these cases, we add standard three columns for date, transaction, amount
+        transactiondisplay->listview->addColumn ( "Date", 0 );
+        transactiondisplay->listview->addColumn ( "Transaction", 0 );
+        transactiondisplay->listview->addColumn ( "Amt", 0);
+        transactiondisplay->listview->setColumnAlignment ( 2, Qt::AlignRight );
+        transactiondisplay->listview->addColumn ( "", 0 );
+
+        if ( accountdisplay->listview->selectedItem()->parent() == 0 && accountdisplay->listview->selectedItem()->childCount() != 0 ) // we selected a parent with children
+          {
+            // add an extra column for the account name for eac child transaction
+            transactiondisplay->listview->addColumn ( "Acct", 0 );
+            children = TRUE;
+
+            // hide the new transaction button
+            transactiondisplay->newtransaction->setEnabled ( FALSE );
+          }
+        else //we selected a parent without children or a child
+          transactiondisplay->newtransaction->setEnabled ( TRUE );
+
+        // disable the transactionid column so it can't be red
+        transactiondisplay->listview->header()->setResizeEnabled ( FALSE, 3 );
+
+        // set the accountid and children variables
+        transactiondisplay->setChildren ( children );
+        transactiondisplay->setAccountID ( accountid );
+
+        // display transactions
+        transactiondisplay->listview->clear();
+        QString displaytext = "%";
+        displaytext.prepend ( transactiondisplay->limitbox->text() );
+        if ( transaction->getNumberOfTransactions() > 0 )
+          transaction->displayTransactions ( transactiondisplay->listview, accountid, children, displaytext );
+
+        // display transfers
+        transfer->displayTransfers ( transactiondisplay->listview, accountid, children );
+
+        // open a new preferences object and resize the transaction display columns
+        // each column will have a different size based on whether we are looking at a child
+        // account or children through a parent
+        if ( parentaccountid != -1 || accountdisplay->listview->selectedItem()->childCount() == 0 ) // a parent with no children or a child - three columns
+          {
+            transactiondisplay->listview->setColumnWidth ( 0, preferences->getColumnPreference ( 3 ) ); // normal transaction date width
+            transactiondisplay->listview->setColumnWidthMode ( 0, QListView::Manual );
+            transactiondisplay->listview->setColumnWidth ( 1, preferences->getColumnPreference ( 4 ) ); // normal transaction name width
+            transactiondisplay->listview->setColumnWidthMode ( 1, QListView::Manual );
+            transactiondisplay->listview->setColumnWidth ( 2, preferences->getColumnPreference ( 5 ) ); // normal transaction amount width
+            transactiondisplay->listview->setColumnWidthMode ( 2, QListView::Manual );
+          }
+        else
+          {
+            transactiondisplay->listview->setColumnWidth ( 0, preferences->getColumnPreference ( 6 ) ); // extended transaction date width
+            transactiondisplay->listview->setColumnWidthMode ( 0, QListView::Manual );
+            transactiondisplay->listview->setColumnWidth ( 1, preferences->getColumnPreference ( 7 ) ); // extended transaction name width
+            transactiondisplay->listview->setColumnWidthMode ( 1, QListView::Manual );
+            transactiondisplay->listview->setColumnWidth ( 2, preferences->getColumnPreference ( 8 ) ); // extended transaction amount width
+            transactiondisplay->listview->setColumnWidthMode ( 2, QListView::Manual );
+            transactiondisplay->listview->setColumnWidth ( 4, preferences->getColumnPreference ( 9 ) ); // transaction account width
+            transactiondisplay->listview->setColumnWidthMode ( 4, QListView::Manual );
+          }
+
+        // show the window
+        transactiondisplay->show();
+        // hide the account display and define accountid
+        accountdisplay->hide();
+        // hide the budget display
+        budgetdisplay->hide();
+      }
+    else if ( maintabs->currentPageIndex() == 0 )
+      {
+        disableOneTouchViewing();
+
+        // clear the account display selection
+        accountdisplay->listview->clearSelection();
+
+        // resize the account display columns
+        accountdisplay->listview->setColumnWidth ( 0, preferences->getColumnPreference ( 1 ) );
+        accountdisplay->listview->setColumnWidth ( 1, preferences->getColumnPreference ( 2 ) );
+
+        // display the accounts
+        if ( account->getNumberOfAccounts() != 0 )
+          account->displayAccounts ( accountdisplay->listview );
+        maintabs->setTabEnabled ( tab_2, FALSE );
+
+        // set the toggle button
+        accountdisplay->setToggleButton ();
+
+        // show the account display
+        accountdisplay->show();
+
+        // hide the transaction display
+        transactiondisplay->hide();
+
+        // hide the budget display
+        budgetdisplay->hide();
+
+
+        enableOneTouchViewing ();
+      }
+    else
+      {
+        budgetdisplay->displayLineItems();
+        budgetdisplay->show();
+        transactiondisplay->hide();
+        accountdisplay->hide();
+      }
+  }
+
+void QashMoney::setTransactionTab ()
+  {
+    if ( accountdisplay->listview->selectedItem() == 0 )
+      maintabs->setTabEnabled ( tab_2, FALSE );
+    else
+      maintabs->setTabEnabled ( tab_2, TRUE );
+  }
+
+void QashMoney::displayDatePreferencesDialog ()
+  {
+    // this shows a dialog to set preferences for formatting the date
+    DatePreferences *pd = new DatePreferences ( this );
+    pd->exec ();
+    if ( transactiondisplay->isVisible() )
+      {
+        // set the account id
+        int accountid = accountdisplay->listview->selectedItem()->text ( accountdisplay->getIDColumn() ).toInt();
+
+        // set children so we can let displayTransfers know if there are children for the selected account
+        bool children;
+        if ( accountdisplay->listview->selectedItem()->parent() == 0 && accountdisplay->listview->selectedItem()->childCount() != 0 )
+          children = TRUE;
+        else
+          children = FALSE;
+
+        // redisplay transactions if they are visible incorporating
+        // any changes to the date format
+        transactiondisplay->listview->clear();
+        QString displaytext = "%";
+        displaytext.prepend ( transactiondisplay->limitbox->text() );
+        if ( transaction->getNumberOfTransactions() > 0 )
+          transaction->displayTransactions ( transactiondisplay->listview, accountid, children, displaytext );
+
+        if ( transfer->getNumberOfTransfers() != 0 )
+          transfer->displayTransfers ( transactiondisplay->listview, accountid, children );
+      }
+    else if ( accountdisplay->isVisible() )
+      {
+        accountdisplay->listview->clearSelection();
+        maintabs->setTabEnabled ( tab_2, FALSE );
+      }
+    else
+      budgetdisplay->updateBudgetInformation();
+  }
+
+void QashMoney::displayTransactionPreferencesDialog ()
+  {
+    // display a dialog for setting preferences for transactions
+    TransactionPreferences *td = new TransactionPreferences ( this );
+    td->exec ();
+    if ( transactiondisplay->isVisible() )
+      {
+        // set the account id
+        int accountid = accountdisplay->listview->selectedItem()->text ( accountdisplay->getIDColumn() ).toInt();
+
+        // set children so we can let displayTransfers know if there are children for the selected account
+        bool children;
+        if ( accountdisplay->listview->selectedItem()->parent() == 0 && accountdisplay->listview->selectedItem()->childCount() != 0 )
+          children = TRUE;
+        else
+          children = FALSE;
+
+        // redisplay transactions incorporating any transaction preference changes
+        transactiondisplay->listview->clear();
+        QString displaytext = "%";
+        displaytext.prepend ( transactiondisplay->limitbox->text() );
+        if ( transaction->getNumberOfTransactions() > 0 )
+          transaction->displayTransactions ( transactiondisplay->listview, accountid, children, displaytext );
+
+        if ( transfer->getNumberOfTransfers() != 0 )
+          transfer->displayTransfers ( transactiondisplay->listview, accountid, children );
+      }
+    else
+      {
+        accountdisplay->listview->clearSelection();
+        maintabs->setTabEnabled ( tab_2, FALSE );
+      }
+  }
+
+void QashMoney::displayAccountPreferencesDialog ()
+  {
+    // display a dialog for setting preferences for accounts
+    AccountPreferences *ap = new AccountPreferences ( this );
+    ap->exec ();
+
+    if ( accountdisplay->isVisible() && account->getNumberOfAccounts() != 0 )
+      {
+        accountdisplay->listview->clear();
+        account->displayAccounts ( accountdisplay->listview );
+        accountdisplay->listview->clearSelection();
+        maintabs->setTabEnabled ( tab_2, FALSE );
+      }
+    changeTabDisplay();
+  }
+
+void QashMoney::displayMemoryDialog ()
+  {
+    // opens a dialog to add, edit and delete memory items
+    MemoryDialog *md = new MemoryDialog ();
+    md->exec();
+  }
+
+void QashMoney::showTransactions ()
+  {
+    maintabs->setCurrentPage ( 1 );
+  }
+
+void QashMoney::enableOneTouchViewing ()
+  {
+    if ( preferences->getPreference ( 5 ) == 1 )
+      connect ( accountdisplay->listview, SIGNAL ( selectionChanged () ), this, SLOT ( showTransactions () ) );
+    else
+      disconnect ( accountdisplay->listview, SIGNAL ( selectionChanged () ), this, SLOT ( showTransactions () ) );
+  }
+
+void QashMoney::disableOneTouchViewing ()
+  {
+    disconnect ( accountdisplay->listview, SIGNAL ( selectionChanged () ), this, SLOT ( showTransactions () ) );
+  }
+
+void QashMoney::toggleOneTouchViewing ( bool state )
+  {
+    if ( state == TRUE )
+      disableOneTouchViewing();
+    else
+      enableOneTouchViewing();
+  }
+
+
+
diff --git a/noncore/apps/qashmoney/transaction.cpp b/noncore/apps/qashmoney/transaction.cpp
new file mode 100755
index 0000000..af7d18f
--- a/dev/null
+++ b/noncore/apps/qashmoney/transaction.cpp
@@ -0,0 +1,274 @@
+// RESERVEDONE COLUMN NAME REPRESENTS THE LINEITEMID AND SHOULD BE CHANGED IN
+// FUTURE VERSIONS OF QASHMONEY
+
+// RESERVEDTWO REPRESENTS THE TRANSACTION DESCRIPTION
+
+#include "transaction.h"
+#include "account.h"
+#include "transactiondisplay.h"
+
+#include <stdlib.h>
+
+extern Account *account;
+extern Preferences *preferences;
+
+Transaction::Transaction ()
+  {
+    tdb = sqlite_open ( "qmtransactions.db", 0, NULL );
+  }
+
+Transaction::~Transaction ()
+  {
+    sqlite_close ( tdb );
+  }
+
+void Transaction::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 )
+  {
+    sqlite_exec_printf ( tdb, "insert into transactions values ( '%q', %i, %i, %i, %i, %i, %i, %.2f, %i, %i, 0, 0, 0, 0, 0, 0, %i, '%q', 0,
+    0, 0, 0, NULL );", 0, 0, 0, ( const char * ) payee, accountid, parentid, number, day, month, year, amount, cleared, budgetid, lineitemid, ( const char * ) description );
+  }
+
+void Transaction::updateTransaction ( QString description, QString payee, int number, int day, int month, int year, float amount, int cleared, int budgetid, int lineitemid, int transactionid )
+  {
+    sqlite_exec_printf ( tdb, "update transactions set reservedtwo = '%q', payee = '%q', number = %i, day = %i, month = %i, year = %i, amount = %.2f,
+      cleared = %i, budgetid = %i, reservedone = %i where transid = %i;", 0, 0, 0, ( const char * ) description, ( const char * ) payee, number, day, month, year,
+      amount, cleared, budgetid, lineitemid, transactionid );
+  }
+
+void Transaction::deleteTransaction ( int transid )
+  {
+    sqlite_exec_printf ( tdb, "delete from transactions where transid = %i;", 0, 0, 0, transid );
+  }
+
+void Transaction::deleteAllTransactions ( int accountid )
+  {
+    sqlite_exec_printf ( tdb, "delete from transactions where accountid = %i;", 0, 0, 0, accountid );
+  }
+
+int Transaction::getAccountID ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( tdb, "select accountid from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
+    return atol ( results [ 1 ] );
+  }
+
+int Transaction::getNumberOfTransactions ()
+  {
+    char **results;
+    sqlite_get_table ( tdb, "select count() from transactions;", &results, NULL, NULL, NULL );
+    return atoi ( results [ 1 ] );
+  }
+
+int Transaction::getNumberOfTransactions ( int accountid )
+  {
+    char **results;
+    sqlite_get_table_printf ( tdb, "select count() from transactions where accountid = %i;", &results, NULL, NULL, NULL, accountid );
+    return atol ( results [ 1 ] );
+  }
+
+QString Transaction::getPayee ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( tdb, "select payee from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
+    return results [ 1 ];
+  }
+
+QString Transaction::getTransactionDescription ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( tdb, "select reservedtwo from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
+    return results [ 1 ];
+  }
+
+QString Transaction::getNumber ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( tdb, "select number from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
+    return results [ 1 ];
+  }
+
+QString Transaction::getAmount ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( tdb, "select amount from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
+    return results [ 1 ];
+  }
+
+QString Transaction::getAbsoluteAmount ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( tdb, "select abs ( amount ) from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
+    return results [ 1 ];
+  }
+
+int Transaction::getCleared ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( tdb, "select cleared from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
+    QString cleared = results [ 1 ];
+    return cleared.toInt();
+  }
+
+void Transaction::setCleared ( int id, int cleared )
+  {
+    sqlite_exec_printf ( tdb, "update transactions set cleared = %i where transid = %i;", 0, 0, 0, cleared, id );
+  }
+
+int Transaction::getBudgetID ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( tdb, "select budgetid from transactions where transid = %i;", &results, NULL, NULL, NULL, id );
+    QString budgetid = results [ 1 ];
+    return budgetid.toInt();
+  }
+
+int Transaction::getLineItemID ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( tdb, "select reservedone from transactions where transid = %i;", &results, NULL, NULL, NULL, id );
+    QString lineitemid = results [ 1 ];
+    return lineitemid.toInt();
+  }
+
+int Transaction::getDay ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( tdb, "select day from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
+    QString daystring = results [ 1 ];
+    return daystring.toInt();
+  }
+
+int Transaction::getMonth ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( tdb, "select month from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
+    QString monthstring = results [ 1 ];
+    return monthstring.toInt();
+  }
+
+int Transaction::getYear ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( tdb, "select year from transactions where transid= %i;", &results, NULL, NULL, NULL, id );
+    QString yearstring = results [ 1 ];
+    return yearstring.toInt();
+  }
+
+void Transaction::displayTransactions ( QListView *listview, int id, bool children, const char *limit )
+  {
+    int showcleared = preferences->getPreference ( 3 );
+
+    // select the transactions to display
+    // two different statements are used based on
+    // whether we are showing cleared transactions
+    char **results;
+    int rows, columns;
+    if ( showcleared == 0 )
+      {
+        if ( account->getParentAccountID ( id ) == -1 && children == TRUE )
+          sqlite_get_table_printf ( tdb, "select day, month, year, payee, amount, transid, accountid from transactions where cleared = 0 and parentid = %i and payee like '%q';", &results, &rows, &columns, NULL, id, limit );
+        else
+          sqlite_get_table_printf ( tdb, "select day, month, year, payee, amount, transid, accountid from transactions where cleared = 0 and accountid = %i and payee like '%q';", &results, &rows, &columns, NULL, id, limit );
+      }
+    else
+      {
+      if ( account->getParentAccountID ( id ) == -1 && children == TRUE )
+          sqlite_get_table_printf ( tdb, "select day, month, year, payee, amount, transid, accountid from transactions where parentid = %i and payee like '%q';", &results, &rows, &columns, NULL, id, limit );
+      else
+        sqlite_get_table_printf ( tdb, "select day, month, year, payee, amount, transid, accountid from transactions where accountid = %i and payee like '%q';", &results, &rows, &columns, NULL, id, limit );
+      }
+
+    // iterate through the result list and display each item
+    int counter = 7;
+    while ( counter < ( ( rows + 1 ) * columns ) )
+      {
+        // construct the date
+	//QString daystring = results [ counter ];
+	//int day = results [ counter ].toInt ();
+	//QString monthstring = results [ counter + 1 ];
+	//int month = results [ counter + 1 ].toInt ();
+	//QString yearstring = results [ counter + 2 ];
+	//int year = results [ counter + 2 ].toInt ();
+	QString date = preferences->getDate ( atoi ( results [ counter + 2 ] ), atoi ( results [ counter + 1 ] ), atoi ( results [ counter ] ) );
+
+	// construct transaction name, amount, id
+	QString payee = results [ counter + 3 ];
+	QString amount = results [ counter + 4 ];
+	QString transferid = results [ counter + 5 ];
+
+        //determine the account name of the child accounts that we're displaying
+        QString accountname = account->getAccountName ( atoi ( results [ counter + 6 ] ) );
+
+	// fill in values
+        if ( account->getParentAccountID ( id ) != -1 ) // use these constructors if we're showing a child account
+          {
+	    if ( showcleared == 1 && getCleared ( transferid.toInt() ) == 1 )
+	      ColorListItem *item = new ColorListItem ( listview, date, payee, amount, transferid);
+	    else
+	      QListViewItem *item = new QListViewItem ( listview, date, payee, amount, transferid );
+          }
+       else
+         {
+	    if ( showcleared == 1 && getCleared ( transferid.toInt() ) == 1 )
+	      ColorListItem *item = new ColorListItem ( listview, date, payee, amount, transferid, accountname );
+	    else
+	      QListViewItem *item = new QListViewItem ( listview, date, payee, amount, transferid, accountname );
+         }
+
+	// advance counter
+	counter = counter + 7;
+      }
+  }
+
+QString Transaction::getBudgetTotal ( int budgetid, int lineitemid, int year, int month, int viewtype )
+  {
+    // determine if we are viewing a years, months, or days budget
+    // we have to pick a different sum for each
+    char **results;
+    switch ( viewtype )
+      {
+        case 1: // we are viewing a year
+        sqlite_get_table_printf ( tdb, "select abs ( sum ( amount ) ) from transactions where year = %i and amount < 0 and budgetid = %i and reservedone = %i;", &results, NULL, NULL, NULL, year, budgetid, lineitemid );
+        break;
+
+        case 0: // we are viewing a month
+        sqlite_get_table_printf ( tdb, "select abs ( sum ( amount ) ) from transactions where year = %i and month = %i and amount < 0 and budgetid = %i and reservedone = %i;", &results, NULL, NULL, NULL, year, month, budgetid, lineitemid );
+        break;
+      }
+    QString amount = results [ 1 ];
+    float total  = amount.toFloat();
+    amount.setNum ( total, 'f', 2 );
+    return amount;
+  }
+
+QString Transaction::getActualTotal ( int budgetid, int year, int month, int viewtype )
+  {
+    // determine if we are viewing a years, months, or days budget
+    // we have to pick a different sum for each
+    char **results;
+    switch ( viewtype )
+      {
+        case 1: // we are viewing a year
+        sqlite_get_table_printf ( tdb, "select abs ( sum ( amount ) ) from transactions where year = %i and amount < 0 and budgetid = %i;", &results, NULL, NULL, NULL, year, budgetid );
+        break;
+
+        case 0: // we are viewing a month
+        sqlite_get_table_printf ( tdb, "select abs ( sum ( amount ) ) from transactions where year = %i and month = %i and amount < 0 and budgetid = %i;", &results, NULL, NULL, NULL, year, month, budgetid );
+        break;
+      }
+    QString amount = results [ 1 ];
+    float total  = amount.toFloat();
+    amount.setNum ( total, 'f', 2 );
+    return amount;
+  }
+
+void Transaction::clearBudgetIDs ( int budgetid, int lineitemid )
+  {
+    sqlite_exec_printf ( tdb, "update transactions set budgetid = -1 where budgetid = %i and reservedone = %i;", 0, 0, 0, budgetid, lineitemid );
+  }
+
+void Transaction::clearBudgetIDs ( int budgetid )
+  {
+    sqlite_exec_printf ( tdb, "update transactions set budgetid = -1 where budgetid = %i;", 0, 0, 0, budgetid );
+  }
+
diff --git a/noncore/apps/qashmoney/transaction.h b/noncore/apps/qashmoney/transaction.h
new file mode 100755
index 0000000..5db011c
--- a/dev/null
+++ b/noncore/apps/qashmoney/transaction.h
@@ -0,0 +1,69 @@
+#ifndef TRANSACTION_H
+#define TRANSACTION_H
+
+#include <qstring.h>
+#include <qlistview.h>
+#include <sqlite.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 * );
+      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:
+
+      sqlite *tdb;
+  };
+
+#endif
+
+
+
diff --git a/noncore/apps/qashmoney/transactiondisplay.h b/noncore/apps/qashmoney/transactiondisplay.h
new file mode 100755
index 0000000..79f20ba
--- a/dev/null
+++ b/noncore/apps/qashmoney/transactiondisplay.h
@@ -0,0 +1,79 @@
+#ifndef TRANSACTIONDISPLAY_H
+#define TRANSACTIONDISPLAY_H
+
+#include <qlayout.h>
+#include <qhbox.h>
+#include <qlistview.h>
+#include <qpushbutton.h>
+#include <qlabel.h>
+#include <qlineedit.h>
+
+class TransactionDisplay : public QWidget
+  {
+    Q_OBJECT
+
+  public:
+    TransactionDisplay ( QWidget* parent );
+
+    QListView* listview;
+    QPushButton* newtransaction;
+    QPushButton* edittransaction;
+    QPushButton* deletetransaction;
+    QPushButton* toggletransaction;
+    QPushButton* viewtransactionnotes;
+
+    QLabel *name;
+    QLabel *balance;
+    QLineEdit *limitbox;
+    QLineEdit *amount;
+    QLineEdit *date;
+
+    int getIDColumn ();
+
+  public slots:
+    void setChildren ( bool );
+    void setAccountID ( int );
+    void showTransactionNotes ();
+
+  private slots:
+    void addTransaction ();
+    void editTransaction ();
+    void editTransfer ();
+    void deleteTransaction ();
+    void toggleTransaction ();
+    void checkListViewDelete ();
+    void checkListViewEdit ();
+    void checkListViewToggle ();
+    void saveColumnSize ( int column, int oldsize, int newsize );
+    void limitDisplay ( const QString & );
+    void showCalculator ();
+    void showCalendar ();
+
+  private:
+    int accountid, fromaccount, fromparent, toaccount, toparent, day, month, year, transferid;
+    bool children;
+    QBoxLayout *layout;
+    QHBox *firstline;
+    QHBox *secondline;
+    void redisplayAccountBalance ();
+    void updateAndDisplay ( int accountid );
+  };
+
+#endif
+
+#ifndef COLORLISTITEM_H
+#define COLORLISTITEM_H
+
+class ColorListItem : public QListViewItem
+  {
+    public:
+
+      ColorListItem ( QListView *parent );
+      ColorListItem ( QListView *parent, QString label1, QString label2, QString label3, QString label4 );
+      ColorListItem ( QListView *parent, QString label1, QString label2, QString label3, QString label4, QString label5 );
+
+      virtual void paintCell ( QPainter *p, const QColorGroup &cg, int column, int width, int alignment );
+  };
+
+#endif
+
diff --git a/noncore/apps/qashmoney/transfer.cpp b/noncore/apps/qashmoney/transfer.cpp
new file mode 100755
index 0000000..77cbb4e
--- a/dev/null
+++ b/noncore/apps/qashmoney/transfer.cpp
@@ -0,0 +1,253 @@
+#include "transfer.h"
+#include "account.h"
+#include "transactiondisplay.h"
+#include <stdlib.h>
+#include <iostream.h>
+
+extern Account *account;
+extern Preferences *preferences;
+
+Transfer::Transfer ()
+  {
+    db = sqlite_open ( "qmtransfers.db", 0, 0 );
+  }
+
+Transfer::~Transfer ()
+  {
+    sqlite_close ( db );
+  }
+
+void Transfer::addTransfer ( int fromaccount, int fromparent, int toaccount, int toparent, int day, int month, int year, float amount, int cleared )
+  {
+    int nextrowid = -1;
+    char **results;
+    sqlite_get_table ( db, "select count() from transfers;", &results, 0, 0, 0 );
+    if ( atoi ( results [ 1 ] ) != 0 )
+      {
+        char **results;
+        sqlite_get_table ( db, "select min ( rowid ) from transfers;", &results, 0, 0, 0 );
+        nextrowid = ( atoi ( results [ 1 ] ) ) - 1;
+      }
+    sqlite_exec_printf ( db, "insert into transfers values ( %i, %i, %i, %i, %i, %i, %i, 0, 0, %.2f, %i, 0, 0, 0, 0, 0, %i );", 0, 0, 0, fromaccount, fromparent, toaccount, toparent, day, month, year, amount, cleared, nextrowid );
+  }
+
+void Transfer::updateTransfer ( int fromaccount, int fromparent, int toaccount, int toparent, int day, int month, int year, float amount, int cleared, int transferid )
+  {
+    sqlite_exec_printf ( db, "update transfers set fromaccount = %i, fromparent = %i, toaccount = %i, toparent = %i, day = %i, month = %i, year = %i,
+      amount = %.2f, cleared = %i where transferid = %i;", 0, 0, 0, fromaccount, fromparent, toaccount, toparent, day, month, year, amount, cleared, transferid );
+  }
+
+void Transfer::deleteTransfer ( int transferid )
+  {
+    sqlite_exec_printf ( db, "delete from transfers where transferid = %i;", 0, 0, 0, transferid );
+  }
+
+void Transfer::deleteAllTransfers ( int accountid )
+  {
+    sqlite_exec_printf ( db, "delete from transfers where fromaccount = %i;", 0, 0, 0, accountid );
+    sqlite_exec_printf ( db, "delete from transfers where toaccount = %i;", 0, 0, 0, accountid );
+  }
+
+int Transfer::getNumberOfTransfers ()
+  {
+    char **results;
+    sqlite_get_table ( db, "select count() from transfers;", &results, 0, 0, 0 );
+    return atoi ( results [ 1 ] );
+  }
+
+int Transfer::getNumberOfTransfers ( int accountid )
+  {
+    char **results;
+    sqlite_get_table_printf ( db, "select count() from transfers where fromaccount = %i;", &results, 0, 0, 0, accountid );
+    int transfers = atoi ( results [ 1 ] );
+    sqlite_get_table_printf ( db, "select count() from transfers where toaccount = %i;", &results, 0, 0, 0, accountid );
+    transfers = transfers + atoi ( results [ 1 ] );
+    return transfers;
+  }
+
+void Transfer::displayTransfers ( QListView *listview, int accountid, bool children )
+  {
+    int showcleared = preferences->getPreference ( 3 );
+
+    // select the from transfers to display
+    char **results;
+    int rows, columns;
+    if ( account->getParentAccountID ( accountid ) == -1 && children == TRUE )
+      {
+        if ( showcleared == 0 )
+          sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where cleared = 0 and toparent = %i;", &results, &rows, &columns, 0, accountid );
+        else
+          sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where toparent = %i;", &results, &rows, &columns, 0, accountid );
+      }
+    else
+      {
+        if ( showcleared == 0 )
+          sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where cleared = 0 and toaccount = %i;", &results, &rows, &columns, 0, accountid );
+        else
+          sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where toaccount = %i;", &results, &rows, &columns, 0, accountid );
+      }
+
+    // iterate through the list and display the from items
+    int counter = 7;
+    int position = 0;
+    while ( counter < ( ( rows + 1 ) * columns ) )
+      {
+        // construct the date
+	QString daystring = results [ counter ];
+	int day = daystring.toInt ();
+	QString monthstring = results [ counter + 1 ];
+	int month = monthstring.toInt ();
+	QString yearstring = results [ counter + 2 ];
+	int year = yearstring.toInt ();
+	QString date = preferences->getDate ( year, month, day );
+
+        //construct the amount and id strings
+        QString amount = results [ counter + 3 ];
+        QString id = results [ counter + 4 ];
+
+        // construct the transaction name
+        QString transactionname = "FROM: ";
+        QString temp1 = results [ counter + 5 ];
+        transactionname.append ( account->getAccountName ( temp1.toInt() ) );
+
+        QString toaccount = account->getAccountName ( atol ( results [ counter + 6 ] ) );
+
+        // display this transfer
+        if ( account->getParentAccountID ( accountid ) == -1 )
+          {
+            if ( showcleared == 1 && getCleared ( id.toInt() ) == 1 )
+              ColorListItem *item = new ColorListItem ( listview, date, transactionname, amount, id, toaccount );
+            else
+              QListViewItem *item = new QListViewItem ( listview, date, transactionname, amount, id, toaccount );
+          }
+        else
+          {
+            if ( showcleared == 1 && getCleared ( id.toInt() ) == 1 )
+              ColorListItem *item = new ColorListItem ( listview, date, transactionname, amount, id );
+            else
+              QListViewItem *item = new QListViewItem ( listview, date, transactionname, amount, id );
+          }
+
+        counter = counter + 7;
+      }
+
+    // select the to transfers to display
+    char **toresults;
+    rows = 0;
+    columns = 0;
+    if ( account->getParentAccountID ( accountid ) == -1 && children == TRUE )
+      {
+        if ( showcleared == 0 )
+          sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where cleared = 0 and fromparent = %i;", &toresults, &rows, &columns, 0, accountid );
+        else
+          sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where fromparent = %i;", &toresults, &rows, &columns, 0, accountid );
+      }
+    else
+      {
+        if ( showcleared == 0 )
+          sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where cleared = 0 and fromaccount = %i;", &toresults, &rows, &columns, 0, accountid );
+        else
+          sqlite_get_table_printf ( db, "select day, month, year, amount, transferid, fromaccount, toaccount from transfers where fromaccount = %i;", &toresults, &rows, &columns, 0, accountid );
+      }
+
+    // iterate through the list and display the from items
+    counter = 7;
+    position = 0;
+    while ( counter < ( ( rows + 1 ) * columns ) )
+      {
+        // construct the date
+	QString daystring = toresults [ counter ];
+	int day = daystring.toInt ();
+	QString monthstring = toresults [ counter + 1 ];
+	int month = monthstring.toInt ();
+	QString yearstring = toresults [ counter + 2 ];
+	int year = yearstring.toInt ();
+	QString date = preferences->getDate ( year, month, day );
+
+        //construct the amount and id strings
+        QString amount = toresults [ counter + 3 ];
+        amount.prepend ( "-" );
+        QString id = toresults [ counter + 4 ];
+
+        // construct the transaction name
+        QString transactionname = "TO: ";
+        QString temp1 = toresults [ counter + 6 ];
+        transactionname.append ( account->getAccountName ( temp1.toInt() ) );
+
+        QString fromaccount = account->getAccountName ( atol ( toresults [ counter + 5 ] ) );
+
+        // display this transfer
+        if ( account->getParentAccountID ( accountid ) == -1 )
+          {
+            if ( showcleared == 1 && getCleared ( id.toInt() ) == 1 )
+              ColorListItem *item = new ColorListItem ( listview, date, transactionname, amount, id, fromaccount );
+            else
+              QListViewItem *item = new QListViewItem ( listview, date, transactionname, amount, id, fromaccount );
+          }
+        else
+          {
+            if ( showcleared == 1 && getCleared ( id.toInt() ) == 1 )
+              ColorListItem *item = new ColorListItem ( listview, date, transactionname, amount, id );
+            else
+              QListViewItem *item = new QListViewItem ( listview, date, transactionname, amount, id );
+          }
+
+        counter = counter + 7;
+      }
+  }
+
+int Transfer::getCleared ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( db, "select cleared from transfers where transferid= %i;", &results, 0, 0, 0, id );
+    return atoi ( results [ 1 ] );
+  }
+
+void Transfer::setCleared ( int id, int cleared )
+  {
+    sqlite_exec_printf ( db, "update transfers set cleared = %i where transferid = %i;", 0, 0, 0, cleared, id );
+  }
+
+int Transfer::getFromAccountID ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( db, "select fromaccount from transfers where transferid= %i;", &results, 0, 0, 0, id );
+    return atoi ( results [ 1 ] );
+  }
+
+int Transfer::getToAccountID ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( db, "select toaccount from transfers where transferid= %i;", &results, 0, 0, 0, id );
+    return atoi ( results [ 1 ] );
+  }
+
+int Transfer::getDay ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( db, "select day from transfers where transferid= %i;", &results, 0, 0, 0, id );
+    return atoi ( results [ 1 ] );
+  }
+
+int Transfer::getMonth ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( db, "select month from transfers where transferid= %i;", &results, 0, 0, 0, id );
+    return atoi ( results [ 1 ] );
+  }
+
+int Transfer::getYear ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( db, "select year from transfers where transferid= %i;", &results, 0, 0, 0, id );
+    return atoi ( results [ 1 ] );
+  }
+
+QString Transfer::getAmount ( int id )
+  {
+    char **results;
+    sqlite_get_table_printf ( db, "select amount from transfers where transferid= %i;", &results, 0, 0, 0, id );
+    return results [ 1 ];
+  }
+
+
diff --git a/noncore/apps/qashmoney/transfer.h b/noncore/apps/qashmoney/transfer.h
new file mode 100755
index 0000000..33dedf4
--- a/dev/null
+++ b/noncore/apps/qashmoney/transfer.h
@@ -0,0 +1,51 @@
+#ifndef TRANSFER_H
+#define TRANSFER_H
+
+#include <qlistview.h>
+#include <qstring.h>
+#include <sqlite.h>
+
+#include "preferences.h"
+
+class Transfer
+  {
+    public:
+
+      Transfer ();
+      ~Transfer ();
+
+      // This function adds a new transfer to the database.  It takes the fromaccount, toaccount,
+      // number, frombudget, tobudget, day, month, year, amount, cleared
+      void addTransfer ( int fromaccount, int fromparent, int toaccount, int toparent, int day, int month, int year, float amount, int cleared );
+      void updateTransfer ( int fromaccount, int fromparent, int toaccount, int toparent, int day, int month, int year, float amount, int cleared, int transferid );
+
+      // Deletes a transfer.  Takes the transferid as its parameter
+      void deleteTransfer ( int );
+
+      // Deletes all transfers for a given accountid
+      void deleteAllTransfers ( int accountid );
+
+      // Returns the number of checking transfers
+      int getNumberOfTransfers ();
+      int getNumberOfTransfers ( int accountid );
+
+      void displayTransfers ( QListView *listview, int accountid, bool children );
+      int getCleared ( int id );
+      void setCleared ( int id, int cleared );
+      int getFromAccountID ( int id );
+      int getToAccountID ( int id );
+
+      int getDay ( int id );
+      int getMonth ( int id );
+      int getYear ( int id );
+      QString getAmount ( int id );
+
+    private:
+
+      sqlite *db;
+  };
+
+#endif
+
+
+