*** empty log message ***

19 files changed, 276 insertions, 105 deletions

diff --git a/noncore/apps/qashmoney/CHANGES b/noncore/apps/qashmoney/CHANGES
index f17035b..a3ac224 100755
--- a/noncore/apps/qashmoney/CHANGES
+++ b/noncore/apps/qashmoney/CHANGES
@@ -3,4 +3,12 @@ QashMoney - Budget Software for the Sharp Zaurus
 CHANGES
 
+0.76 - 5/21/03
+
+        Updated postinst file so app will install on new Sharp ROM 3.1
+        Improved algorithm for selecting cleared transaction
+        Fixed budget display bug
+
+----------------------------------------------------------------------------------
+
 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
diff --git a/noncore/apps/qashmoney/README b/noncore/apps/qashmoney/README
index 1888ce6..ef004f7 100755
--- a/noncore/apps/qashmoney/README
+++ b/noncore/apps/qashmoney/README
@@ -3,11 +3,8 @@ QashMoney - Budget Software for the Sharp Zaurus
 README
 
-Welcome to the latest version of QashMoney!  This app is designed to make your
-budgeting fast, inuitive and easy.
-
 This file lists all the important files in the qashmoney CVS directory and how
 to make the IPK file that goes on the Zaurus.  When you checkout the
-qashmoney module from CVS, it will create a directory on your hard drive called
-qashmoney.  These instructions assume you are in the directory.
+qashmoney-source module from CVS, it will create a directory on your hard drive called
+qashmoney-source.  These instructions assume you are in this directory.
 
 The first thing you need to do is have all the necessary cross-compile software
@@ -24,12 +21,9 @@ QashMoney.  Go to:
 http://www.sqlite.org
 
-to download this progam.  The SQLite library has already been compiled for the
-IPK and is in the 'install' directory.  So there is no need to compile SQLite
-for ARM but you can if you want.  There are instructions for that on the
-website.
+to download this progam.
 
 After that, set the correct environment variables for the package you
-are developing.Two scripts in the qashmoney are used for that purpose: x86.sh
-andarm.shIf you are buidling for x86 type:
+are developing. Two scripts in the qashmoney-source directory are used for that purpose: x86.sh
+and arm.sh.  If you are building for x86 type:
 
 source x86.sh
@@ -64,22 +58,5 @@ and QashMoney should appear in the frambuffer.  You can use and test qashmoney
 here as you would on the Zaurus.
 
-If you compile the binary file for the Zaurus, another script in this directory
-will come in handy.  To automagically make the IPK file, type:
-
-su
-./make_ipk
-
-You need to be the root user to set the ownership of the binary and other
-files correctly.  The IPK file will appear in the qashmoney directory.  Now put
-this file onto the Zaurus and install!
-
-Two other scripts in the directory may be of use.  The make_x86 script cleans
-the directory and makes the x86 qashmoney binary automatically.  The make_arm
-scripts makes the ARM binary.  So you should really only have to type three
-commands the make the IPK file:
-
-./make_arm
-su
-./make_ipk
+If you want to compile the app and make the IPK file, check out the qashmoney-build module and see the README file in that module.
 
 I hope the program can be useful.  If you have any questions or comments, please
diff --git a/noncore/apps/qashmoney/account.cpp b/noncore/apps/qashmoney/account.cpp
index fc2f8c1..28f9ba2 100755
--- a/noncore/apps/qashmoney/account.cpp
+++ b/noncore/apps/qashmoney/account.cpp
@@ -23,7 +23,6 @@ void Account::addAccount ( QString name, int parentid, float balance, int type,
                                         int statementyear, int statementmonth, int statementday, float statementbalance, const char *currency  )
   {
-    int r = sqlite_exec_printf ( adb, "insert into accounts2 values ( '%q', %i, %.2f, %i, '%q', %.2f, %i, %i, %i, %.2f, '%q', 0, 0, 0, 0, 0, NULL );", 0, 0, 0,
+    sqlite_exec_printf ( adb, "insert into accounts2 values ( '%q', %i, %.2f, %i, '%q', %.2f, %i, %i, %i, %.2f, '%q', 0, 0, 0, 0, 0, NULL );", 0, 0, 0,
       (const char *) name, parentid, balance, type, (const char *) description, creditlimit, statementyear, statementmonth, statementday, statementbalance, currency );
-    cout << "Results = " << r << endl;
   }
 
@@ -226,4 +225,10 @@ void Account::displayAccounts ( QListView *listview )
         listview->setColumnWidthMode ( 3, QListView::Manual );
       }
+
+    // Now reset the column sorting to user preference
+    int column = 0;
+    int direction = 0;
+    preferences->getSortingPreference ( 1, &column, &direction );
+    listview->setSorting ( column, direction );
   }
 
diff --git a/noncore/apps/qashmoney/accountdisplay.cpp b/noncore/apps/qashmoney/accountdisplay.cpp
index b2c0838..64f4ea8 100755
--- a/noncore/apps/qashmoney/accountdisplay.cpp
+++ b/noncore/apps/qashmoney/accountdisplay.cpp
@@ -2,4 +2,5 @@
 #include <qmessagebox.h>
 #include <qheader.h>
+#include <iostream.h>
 
 #include "accountdisplay.h"
@@ -46,8 +47,9 @@ AccountDisplay::AccountDisplay ( QWidget *parent ) : QWidget ( parent )
     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 ) ) );
-
+    connect ( listview->header(), SIGNAL ( clicked ( int ) ), this, SLOT ( saveSortingPreference ( int ) ) );
+    
     layout = new QVBoxLayout ( this, 2, 5 );
     layout->addWidget ( firstline );
@@ -269,12 +271,10 @@ void AccountDisplay::getTransferAccounts ( QListViewItem * item )
             if ( td->clearedcheckbox->isChecked() == TRUE )
               cleared = 1;
-
+            cout << "Year from transferdialog = " << td->getYear() << endl;
             // 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 );
+              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 );
+              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
@@ -348,4 +348,9 @@ void AccountDisplay::saveColumnSize ( int column, int oldsize, int newsize )
   }
 
+void AccountDisplay::saveSortingPreference ( int column )
+  {
+    preferences->changeSortingPreference ( 1, column );
+  }
+
 int AccountDisplay::getIDColumn ()
   {
diff --git a/noncore/apps/qashmoney/accountdisplay.h b/noncore/apps/qashmoney/accountdisplay.h
index 37bcb34..6d67b9b 100755
--- a/noncore/apps/qashmoney/accountdisplay.h
+++ b/noncore/apps/qashmoney/accountdisplay.h
@@ -43,4 +43,5 @@ class AccountDisplay : public QWidget
       void setAccountExpanded ( QListViewItem *item );
       void setAccountCollapsed ( QListViewItem *item );
+      void saveSortingPreference ( int column );
 
     private:
diff --git a/noncore/apps/qashmoney/budget.cpp b/noncore/apps/qashmoney/budget.cpp
index 42f7eca..9f74078 100755
--- a/noncore/apps/qashmoney/budget.cpp
+++ b/noncore/apps/qashmoney/budget.cpp
@@ -2,4 +2,5 @@
 #include "transaction.h"
 #include <stdlib.h>
+#include <iostream.h>
 
 extern Transaction *transaction;
@@ -63,5 +64,5 @@ QStringList* Budget::getBudgetNames ()
     char **results;
     int rows, counter;
-    sqlite_get_table ( bdb, "select name from budgets order by name asc;", &results, &rows, NULL, NULL );
+    sqlite_get_table ( bdb, "select name from budgets;", &results, &rows, NULL, NULL );
     names->append ( "None" );
     for ( counter = 0; counter < rows; counter++ )
diff --git a/noncore/apps/qashmoney/budgetdisplay.cpp b/noncore/apps/qashmoney/budgetdisplay.cpp
index 09f62b2..afc6a2d 100755
--- a/noncore/apps/qashmoney/budgetdisplay.cpp
+++ b/noncore/apps/qashmoney/budgetdisplay.cpp
@@ -83,4 +83,11 @@ BudgetDisplay::BudgetDisplay ( QWidget *parent ) : QWidget ( parent )
     listview->header()->setTracking ( FALSE );
     connect ( listview->header(), SIGNAL ( sizeChange ( int, int, int ) ), this, SLOT ( saveColumnSize ( int, int, int ) ) );
+    connect ( listview->header(), SIGNAL ( clicked ( int ) ), this, SLOT ( saveSortingPreference ( int ) ) );
+
+    // pull the column sorting preference from the preferences table, and configure the listview accordingly
+    int column = 0;
+    int direction = 0;
+    preferences->getSortingPreference ( 3, &column, &direction );
+    listview->setSorting ( column, direction );
 
     displayBudgetNames();
@@ -119,4 +126,9 @@ void BudgetDisplay::saveColumnSize ( int column, int oldsize, int newsize )
   }
 
+void BudgetDisplay::saveSortingPreference ( int column )
+  {
+    preferences->changeSortingPreference ( 3, column );
+  }
+
 int BudgetDisplay::getIDColumn ()
   {
diff --git a/noncore/apps/qashmoney/budgetdisplay.h b/noncore/apps/qashmoney/budgetdisplay.h
index 25e952a..3976ce1 100755
--- a/noncore/apps/qashmoney/budgetdisplay.h
+++ b/noncore/apps/qashmoney/budgetdisplay.h
@@ -70,4 +70,5 @@ class BudgetDisplay : public QWidget
       void constructBudgetWindow ();
       void constructLineItemWindow ();
+      void saveSortingPreference ( int column );
 
     private:
diff --git a/noncore/apps/qashmoney/install/CONTROL/opie-qashmoney.control b/noncore/apps/qashmoney/install/CONTROL/opie-qashmoney.control
index b00e3b1..ec65c0e 100755
--- a/noncore/apps/qashmoney/install/CONTROL/opie-qashmoney.control
+++ b/noncore/apps/qashmoney/install/CONTROL/opie-qashmoney.control
@@ -1,7 +1,8 @@
 Package: qashmoney
+Files: bin/qashmoney pics/qashmony/* pics/qashmony/flags/* apps/Applications/qashmoney.desktop
 Priority: optional
-Version: 0.75
+Version: 0.76
 Architecture: arm
-Maintainer: Allen Forsythe qashmoneyman@attbi.com
+Maintainer: Allen Forsythe allen@qashmoney.org
 Section: Applications
 Description: QashMoney provides an intuitive and fast way to keep track of your accounts and budgets.
diff --git a/noncore/apps/qashmoney/preferences.cpp b/noncore/apps/qashmoney/preferences.cpp
index 9bf64dd..880807a 100755
--- a/noncore/apps/qashmoney/preferences.cpp
+++ b/noncore/apps/qashmoney/preferences.cpp
@@ -151,4 +151,29 @@ void Preferences::initializeColumnPreferences ()
   }
 
+void Preferences::initializeSortingPreferences ()
+  {
+    int rows = 0;
+    int columns = 0;
+    char **results;
+
+    if ( sqlite_get_table ( db, "select count() from sorting;", 0, 0, 0, 0 ) != 0 )
+      sqlite_exec ( db, "create table sorting ( listbox, column, direction, id integer primary key );", 0, 0, 0 );
+
+    // initialize account listbox sorting. Set direction = 1 here so ascending sort is default.
+    sqlite_get_table ( db, "select column, direction from sorting where id = 1;", &results, &rows, &columns, 0 );
+    if ( rows == 0 )
+      sqlite_exec ( db, "insert into sorting values ( 'accounts', 0, 1, NULL );", 0, 0, 0 );
+
+    // initialize transaction listbox sorting
+    sqlite_get_table ( db, "select column, direction from sorting where id = 2;", &results, &rows, &columns, 0);
+    if ( rows == 0 )
+      sqlite_exec ( db, "insert into sorting values ( 'transactions', 0, 1, NULL );", 0, 0, 0 );
+
+    // initialize budgets listbox sorting
+    sqlite_get_table ( db, "select column, direction from sorting where id = 3;", & results, &rows, &columns, 0 );
+    if ( rows == 0 )
+      sqlite_exec ( db, "insert into sorting values ( 'budgets', 0, 1, NULL );", 0, 0, 0 );
+  }
+
 void Preferences::changeColumnPreference ( int id, int width )
   {
@@ -163,4 +188,29 @@ int Preferences::getColumnPreference ( int id )
   }
 
+void Preferences::changeSortingPreference ( int id, int column )
+  {
+    int pColumn = 0;    // column setting coming from the prefs object
+    int pDirection = 0; // direction setting coming from the prefs object
+
+    // because there appears to be no way to query the QT header object directly for it's current sort settings, we have
+    // to maintain track of them ourselves.  So start by pulling the current saved setting for this view.
+    getSortingPreference ( id, &pColumn, &pDirection );
+
+    // if the current saved column == the new column, then the user wants to toggle the sort order.
+    // otherwise we behave like QT does by default, which is to select the new column and default to an ascending sort.
+    if ( column == pColumn )
+      sqlite_exec_printf ( db, "update sorting set direction = %i where id = %i;", 0, 0, 0, !pDirection, id );
+    else
+      sqlite_exec_printf ( db, "update sorting set column = %i, direction = 1 where id = %i;", 0, 0, 0, column, id );
+  }
+
+void Preferences::getSortingPreference ( int id, int *column, int *direction )
+  {
+    char **results;
+    sqlite_get_table_printf ( db, "select column, direction from sorting where id = %i;", &results, NULL, NULL, NULL, id );
+    *column = atoi ( results [ 2 ] );
+    *direction = atoi ( results [ 3 ] );
+  }
+
 int Preferences::getPreference ( int id )
   {
diff --git a/noncore/apps/qashmoney/preferences.h b/noncore/apps/qashmoney/preferences.h
index 4a3e058..10ec6e9 100755
--- a/noncore/apps/qashmoney/preferences.h
+++ b/noncore/apps/qashmoney/preferences.h
@@ -13,8 +13,10 @@ class Preferences
       void addPreferences ();
       void initializeColumnPreferences ();
+      void initializeSortingPreferences ();
 
       // Returns a preference value for the given preferences ID
       int getPreference ( int );
       int getColumnPreference ( int id );
+      void getSortingPreference ( int id, int *column, int *direction );
 
       // Convenience for getting date separator with one function
@@ -25,4 +27,5 @@ class Preferences
       void changePreference ( int , int );
       void changeColumnPreference ( int id, int width );
+      void changeSortingPreference ( int id, int column );
 
       // The primary database that stores all our data
diff --git a/noncore/apps/qashmoney/qashmoney.cpp b/noncore/apps/qashmoney/qashmoney.cpp
index 83eea01..20e8d32 100755
--- a/noncore/apps/qashmoney/qashmoney.cpp
+++ b/noncore/apps/qashmoney/qashmoney.cpp
@@ -15,6 +15,7 @@ Memory *memory = new Memory ();
 QashMoney::QashMoney () : QWidget ()
   {
-    preferences->addPreferences();
+    preferences->addPreferences ();
     preferences->initializeColumnPreferences ();
+    preferences->initializeSortingPreferences ();
 
     // set the text in the upper part of the frame
@@ -154,5 +155,5 @@ void QashMoney::changeTabDisplay ()
 
         // display transfers
-        transfer->displayTransfers ( transactiondisplay->listview, accountid, children );
+        transfer->displayTransfers ( transactiondisplay->listview, accountid, children, newdate );
 
         // open a new preferences object and resize the transaction display columns
@@ -179,4 +180,10 @@ void QashMoney::changeTabDisplay ()
             transactiondisplay->listview->setColumnWidthMode ( 4, QListView::Manual );
           }
+        
+        // pull the column sorting preference from the preferences table, and configure the listview accordingly
+        int column = 0;
+        int direction = 0;
+        preferences->getSortingPreference ( 2, &column, &direction );
+        transactiondisplay->listview->setSorting ( column, direction );
 
         // show the window
@@ -198,4 +205,10 @@ void QashMoney::changeTabDisplay ()
         accountdisplay->listview->setColumnWidth ( 1, preferences->getColumnPreference ( 2 ) );
 
+        // set sorting preference on account display columns
+        int column = 0;
+        int direction = 0;
+        preferences->getSortingPreference ( 1, &column, &direction );
+        accountdisplay->listview->setSorting ( column, direction );
+
         // display the accounts
         if ( account->getNumberOfAccounts() != 0 )
@@ -263,5 +276,5 @@ void QashMoney::displayDatePreferencesDialog ()
 
         if ( transfer->getNumberOfTransfers() != 0 )
-          transfer->displayTransfers ( transactiondisplay->listview, accountid, children );
+          transfer->displayTransfers ( transactiondisplay->listview, accountid, children, newdate );
       }
     else if ( accountdisplay->isVisible() )
@@ -301,5 +314,5 @@ void QashMoney::displayTransactionPreferencesDialog ()
 
         if ( transfer->getNumberOfTransfers() != 0 )
-          transfer->displayTransfers ( transactiondisplay->listview, accountid, children );
+          transfer->displayTransfers ( transactiondisplay->listview, accountid, children, newdate );
       }
     else
@@ -386,5 +399,5 @@ void QashMoney::setTransactionDisplayDate ()
       }
     else
-      newdate = QDate ( 1, 1, 1000 );
+      newdate = QDate ( 1900, 1, 1 );
   }
 
diff --git a/noncore/apps/qashmoney/transaction.cpp b/noncore/apps/qashmoney/transaction.cpp
index 5ecc7ed..a3bd9e7 100755
--- a/noncore/apps/qashmoney/transaction.cpp
+++ b/noncore/apps/qashmoney/transaction.cpp
@@ -156,28 +156,104 @@ int Transaction::getYear ( int id )
   }
 
-void Transaction::displayTransactions ( QListView *listview, int id, bool children, const char *limit, QDate displaydate )
+char ** Transaction::selectAllTransactions ( QDate fromdate, bool children, const char *limit, int id )
   {
+    // initialize variables
+    char **results;
     int showcleared = preferences->getPreference ( 3 );
-    int year = ( displaydate.year() ) - 1;
+    QDate today = QDate::currentDate();
+    int fromyear = fromdate.year();
+    int toyear = today.year();
+    int frommonth = fromdate.month();
+    int tomonth = today.month();
+    int fromday = fromdate.day();
 
-    // 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 )
+    // construct the first part of the string
+    QString query = "select day, month, year, payee, amount, transid, accountid from transactions where";
+
+    if ( frommonth == tomonth && fromyear == toyear ) // our dates cross neither a month nor a year
       {
-        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 year >= %i parentid = %i and payee like '%q';", &results, &rows, &columns, NULL, year, id, limit );
-        else
-          sqlite_get_table_printf ( tdb, "select day, month, year, payee, amount, transid, accountid from transactions where cleared = 0 year >= %i accountid = %i and payee like '%q';", &results, &rows, &columns, NULL, year, id, limit );
+        query.append ( " year = " );
+        query.append ( QString::number ( toyear ) );
+        query.append ( " and month = " );
+        query.append ( QString::number ( tomonth ) );
+        query.append ( " and day >= " );
+        query.append ( QString::number ( fromday ) );
+        query.append ( " and" );
       }
-    else
+    else if ( frommonth != tomonth && fromyear == toyear ) // our dates cross a month within the same year
       {
-      if ( account->getParentAccountID ( id ) == -1 && children == TRUE )
-          sqlite_get_table_printf ( tdb, "select day, month, year, payee, amount, transid, accountid from transactions where year >= %i and parentid = %i and payee like '%q';", &results, &rows, &columns, NULL, year, 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 );
+        query.append ( " year = " );
+        query.append ( QString::number ( toyear ) );
+        query.append ( " and ( ( month <= " );
+        query.append ( QString::number ( tomonth ) );
+        query.append ( " and month > " );
+        query.append ( QString::number ( frommonth ) );
+        query.append ( " ) or ( month = " );
+        query.append ( QString::number ( frommonth ) );
+        query.append ( " and day >= " );
+        query.append ( QString::number ( fromday ) );
+        query.append ( " ) ) and " );
       }
+    else if ( fromyear != toyear && fromyear != 1900 ) // here we are showing transactions from an entire year
+      {
+        // divide this taks into two parts - get the transactions from the prior and then the current year
+        // current year part
+        int tmpfrommonth = 1; // set temporary from months and days to Jan. 1
+        int tmpfromday = 1;
+        query.append ( " ( year >= " );
+        query.append ( QString::number ( fromyear ) );
+        query.append ( " and ( month <= " );
+        query.append ( QString::number ( tomonth ) );
+        query.append ( " and month > " );
+        query.append ( QString::number ( tmpfrommonth ) );
+        query.append ( " ) or ( month = " );
+        query.append ( QString::number ( tmpfrommonth ) );
+        query.append ( " and day >= " );
+        query.append ( QString::number ( tmpfromday ) );
+        query.append ( " ) ) or" );
+
+        // prior year part
+        int tmptomonth = 12;
+        query.append ( " ( year = " );
+        query.append ( QString::number ( fromyear ) );
+        query.append ( " and ( ( month <= " );
+        query.append ( QString::number ( tmptomonth ) );
+        query.append ( " and month > " );
+        query.append ( QString::number ( frommonth ) );
+        query.append ( " ) or ( month = " );
+        query.append ( QString::number ( frommonth ) );
+        query.append ( " and day >= " );
+        query.append ( QString::number ( fromday ) );
+        query.append ( " ) ) ) and " );
+      }
+
+    if ( account->getParentAccountID ( id ) == -1 && children == TRUE )
+      query.append ( " parentid = %i and payee like '%q';" );
+    else
+      query.append ( " accountid = %i and payee like '%q';" );
+
+    sqlite_get_table_printf ( tdb, query, &results, &rows, &columns, NULL, id, limit );
+    return results;
+  }
+
+char ** Transaction::selectNonClearedTransactions ( QDate fromdate, bool children, const char *limit, int id )
+  {
+    char **results;
+    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 );
+    return results;
+  }
+
+void Transaction::displayTransactions ( QListView *listview, int id, bool children, const char *limit, QDate displaydate )
+  {
+    int showcleared = preferences->getPreference ( 3 );
+
+    char **results;
+    if ( showcleared == 0 )
+      results = selectNonClearedTransactions ( displaydate, children, limit, id );
+    else
+      results = selectAllTransactions ( displaydate, children, limit, id );
 
     // iterate through the result list and display each item
@@ -185,5 +261,5 @@ void Transaction::displayTransactions ( QListView *listview, int id, bool childr
     while ( counter < ( ( rows + 1 ) * columns ) )
       {
-        QDate displaydate ( atoi ( results [ counter + 2 ] ), atoi ( results [ counter + 1 ] ), atoi ( results [ counter ] ) );
+        //QDate testdate ( atoi ( results [ counter + 2 ] ), atoi ( results [ counter + 1 ] ), atoi ( results [ counter ] ) );
         QString date = preferences->getDate ( atoi ( results [ counter + 2 ] ), atoi ( results [ counter + 1 ] ), atoi ( results [ counter ] ) );
 
@@ -196,19 +272,19 @@ void Transaction::displayTransactions ( QListView *listview, int id, bool childr
         QString accountname = account->getAccountName ( atoi ( results [ counter + 6 ] ) );
 
-        // fill in values
+        // 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);
+             ColorListItem *item = new ColorListItem ( listview, date, payee, amount, transferid );
             else
               QListViewItem *item = new QListViewItem ( listview, date, payee, amount, transferid );
           }
-       else
-         {
+        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
diff --git a/noncore/apps/qashmoney/transaction.h b/noncore/apps/qashmoney/transaction.h
index 7297bb1..5871555 100755
--- a/noncore/apps/qashmoney/transaction.h
+++ b/noncore/apps/qashmoney/transaction.h
@@ -46,4 +46,6 @@ class Transaction
 
       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 );
@@ -63,4 +65,5 @@ class Transaction
 
       sqlite *tdb;
+      int rows, columns;
   };
 
diff --git a/noncore/apps/qashmoney/transactiondisplay.cpp b/noncore/apps/qashmoney/transactiondisplay.cpp
index ae6223d..1839cd2 100755
--- a/noncore/apps/qashmoney/transactiondisplay.cpp
+++ b/noncore/apps/qashmoney/transactiondisplay.cpp
@@ -68,4 +68,5 @@ TransactionDisplay::TransactionDisplay ( QWidget* parent ) : QWidget ( parent )
     listview->header()->setTracking ( FALSE );
     connect ( listview->header(), SIGNAL ( sizeChange ( int, int, int ) ), this, SLOT ( saveColumnSize ( int, int, int ) ) );
+    connect ( listview->header(), SIGNAL ( clicked ( int ) ), this, SLOT ( saveSortingPreference ( int ) ) );
 
     layout = new QVBoxLayout ( this, 2, 2 );
@@ -134,5 +135,5 @@ void TransactionDisplay::addTransaction ()
         // redisplay transfers
         if ( transfer->getNumberOfTransfers() > 0 )
-          transfer->displayTransfers ( listview, accountid, children );
+          transfer->displayTransfers ( listview, accountid, children, displaydate );
 
         // add the transaction amount to the account it's associated with
@@ -373,5 +374,5 @@ void TransactionDisplay::updateAndDisplay ( int id )
     // redisplay transfers
     if ( transfer->getNumberOfTransfers() > 0 )
-      transfer->displayTransfers ( listview, accountid, children );
+      transfer->displayTransfers ( listview, accountid, children, displaydate );
 
     // add the transaction amount to the account it's associated with
@@ -417,5 +418,5 @@ void TransactionDisplay::deleteTransaction ()
 
         if ( transfer->getNumberOfTransfers() > 0 )
-          transfer->displayTransfers ( listview, accountid, children );
+          transfer->displayTransfers ( listview, accountid, children, displaydate );
 
         // if we are viewing different child accounts through the parent account
@@ -449,5 +450,5 @@ void TransactionDisplay::deleteTransaction ()
 
         if ( transfer->getNumberOfTransfers() > 0 )
-          transfer->displayTransfers ( listview, accountid, children );
+          transfer->displayTransfers ( listview, accountid, children, displaydate );
 
         // for the from account
@@ -502,5 +503,5 @@ void TransactionDisplay::toggleTransaction ()
 
     if ( transfer->getNumberOfTransfers() != 0 )
-      transfer->displayTransfers ( listview, accountid, children );
+      transfer->displayTransfers ( listview, accountid, children, displaydate );
   }
 
@@ -552,4 +553,9 @@ void TransactionDisplay::saveColumnSize ( int column, int oldsize, int newsize )
   }
 
+void TransactionDisplay::saveSortingPreference ( int column )
+  {
+    preferences->changeSortingPreference ( 2, column );
+  }
+
 void TransactionDisplay::limitDisplay ( const QString &text )
   {
@@ -562,5 +568,5 @@ void TransactionDisplay::limitDisplay ( const QString &text )
 
     if ( displaytext.length() == 1 || preferences->getPreference ( 6 ) == 1 )
-      transfer->displayTransfers ( listview, accountid, children );
+      transfer->displayTransfers ( listview, accountid, children, displaydate );
   }
 
@@ -620,4 +626,4 @@ void TransactionDisplay::setTransactionDisplayDate ()
       }
     else
-      displaydate = QDate ( 1, 1, 1000 );
+      displaydate = QDate ( 1900, 1, 1 );
   }
diff --git a/noncore/apps/qashmoney/transactiondisplay.h b/noncore/apps/qashmoney/transactiondisplay.h
index 1746f6c..594776a 100755
--- a/noncore/apps/qashmoney/transactiondisplay.h
+++ b/noncore/apps/qashmoney/transactiondisplay.h
@@ -51,4 +51,5 @@ class TransactionDisplay : public QWidget
     void showCalendar ();
     void setTransactionDisplayDate ();
+    void saveSortingPreference ( int column );
 
   private:
diff --git a/noncore/apps/qashmoney/transfer.cpp b/noncore/apps/qashmoney/transfer.cpp
index 77cbb4e..568d584 100755
--- a/noncore/apps/qashmoney/transfer.cpp
+++ b/noncore/apps/qashmoney/transfer.cpp
@@ -66,5 +66,5 @@ int Transfer::getNumberOfTransfers ( int accountid )
   }
 
-void Transfer::displayTransfers ( QListView *listview, int accountid, bool children )
+void Transfer::displayTransfers ( QListView *listview, int accountid, bool children, QDate displaydate )
   {
     int showcleared = preferences->getPreference ( 3 );
@@ -101,4 +101,5 @@ void Transfer::displayTransfers ( QListView *listview, int accountid, bool child
         int year = yearstring.toInt ();
         QString date = preferences->getDate ( year, month, day );
+        QDate testdate ( year, month, day );
 
         //construct the amount and id strings
@@ -113,20 +114,22 @@ void Transfer::displayTransfers ( QListView *listview, int accountid, bool child
         QString toaccount = account->getAccountName ( atol ( results [ counter + 6 ] ) );
 
-        // display this transfer
-        if ( account->getParentAccountID ( accountid ) == -1 )
+        if ( testdate >= displaydate || showcleared == 0 )
           {
-            if ( showcleared == 1 && getCleared ( id.toInt() ) == 1 )
-              ColorListItem *item = new ColorListItem ( listview, date, transactionname, amount, id, toaccount );
+            // 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
-              QListViewItem *item = new QListViewItem ( listview, date, transactionname, amount, id, toaccount );
+              {
+                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 );
+              }
           }
-        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;
       }
@@ -164,4 +167,5 @@ void Transfer::displayTransfers ( QListView *listview, int accountid, bool child
         int year = yearstring.toInt ();
         QString date = preferences->getDate ( year, month, day );
+        QDate testdate ( year, month, day );
 
         //construct the amount and id strings
@@ -177,18 +181,21 @@ void Transfer::displayTransfers ( QListView *listview, int accountid, bool child
         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 );
+         if ( testdate >= displaydate || showcleared == 0 )
+           {
+             // 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
-              QListViewItem *item = new QListViewItem ( listview, date, transactionname, amount, id );
+              {
+                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 );
+              }
           }
 
diff --git a/noncore/apps/qashmoney/transfer.h b/noncore/apps/qashmoney/transfer.h
index 33dedf4..e910e7c 100755
--- a/noncore/apps/qashmoney/transfer.h
+++ b/noncore/apps/qashmoney/transfer.h
@@ -5,4 +5,5 @@
 #include <qstring.h>
 #include <sqlite.h>
+#include <qdatetime.h>
 
 #include "preferences.h"
@@ -30,5 +31,5 @@ class Transfer
       int getNumberOfTransfers ( int accountid );
 
-      void displayTransfers ( QListView *listview, int accountid, bool children );
+      void displayTransfers ( QListView *listview, int accountid, bool children, QDate displaydate );
       int getCleared ( int id );
       void setCleared ( int id, int cleared );
diff --git a/noncore/apps/qashmoney/transferdialog.cpp b/noncore/apps/qashmoney/transferdialog.cpp
index 7bc3eb0..f85c740 100755
--- a/noncore/apps/qashmoney/transferdialog.cpp
+++ b/noncore/apps/qashmoney/transferdialog.cpp
@@ -98,5 +98,5 @@ int TransferDialog::getMonth ()
 int TransferDialog::getYear ()
   {
-    return day;
+    return year;
   }