| -rwxr-xr-x | noncore/apps/qashmoney/account.cpp | 372 |
1 files changed, 372 insertions, 0 deletions
diff --git a/noncore/apps/qashmoney/account.cpp b/noncore/apps/qashmoney/account.cpp new file mode 100755 index 0000000..fc2f8c1 --- a/dev/null +++ b/noncore/apps/qashmoney/account.cpp @@ -0,0 +1,372 @@ +#include "account.h" +#include "transaction.h" +#include "transfer.h" +#include "preferences.h" + +#include <qpixmap.h> +#include <stdlib.h> +#include <iostream.h> + +extern Preferences *preferences; + +Account::Account () + { + adb = sqlite_open ( "qmaccounts.db", 0, NULL ); + } + +Account::~Account () + { + sqlite_close ( adb ); + } + +void Account::addAccount ( QString name, int parentid, float balance, int type, QString description, float creditlimit, + 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, + (const char *) name, parentid, balance, type, (const char *) description, creditlimit, statementyear, statementmonth, statementday, statementbalance, currency ); + cout << "Results = " << r << endl; + } + +void Account::updateAccount ( QString name, QString description, QString currencycode, int accountid ) + { + sqlite_exec_printf ( adb, "update accounts2 set name = '%q', description = '%q', currency = '%q' where accountid = %i;", 0, 0, 0, ( const char * ) name, ( const char * ) description, ( const char * ) currencycode, accountid ); + } + +void Account::deleteAccount ( int accountid ) + { + sqlite_exec_printf ( adb, "delete from accounts2 where accountid = %i;", 0, 0, 0, accountid ); + } + +void Account::setAccountExpanded ( int expanded, int accountid ) + { + sqlite_exec_printf ( adb, "update accounts2 set r1 = %i where accountid = %i;", 0, 0, 0, expanded, accountid ); + } + +int Account::getAccountExpanded ( int id ) + { + char **results; + sqlite_get_table_printf ( adb, "select r1 from accounts2 where accountid = %i;", &results, 0, 0, 0, id ); + if ( strlen ( results [1] ) == 0 ) + return 0; + else + return atoi ( results [ 1 ] ); + } + +int Account::getNumberOfAccounts () + { + char **results; + sqlite_get_table ( adb, "select count() from accounts2;", &results, NULL, NULL, NULL ); + return atoi ( results [ 1 ] ); + } + +int Account::getNumberOfChildAccounts ( int id ) + { + char **results; + sqlite_get_table_printf ( adb, "select count() from accounts2 where parent = %i;", &results, NULL, NULL, NULL, id ); + return atoi ( results [ 1 ] ); + } + +void Account::updateAccountBalance ( int accountid ) + { + // Here, we'll get a balance for the transactions in an account + sqlite *tdb = sqlite_open ( "qmtransactions.db", 0, NULL ); + int rows, columns; + char **results; + sqlite_get_table_printf ( tdb, "select sum (amount) from transactions where accountid= %i;", &results, &rows, &columns, NULL, accountid ); + float transactionsbalance = strtod ( results [ 1 ], 0 ); + sqlite_close ( tdb ); + + // next, we'll get a balance for all the transfers from the account + sqlite *trdb = sqlite_open ( "qmtransfers.db", 0, NULL ); + rows = 0; + columns = 0; + char **results2; + sqlite_get_table_printf ( trdb, "select sum (amount) from transfers where fromaccount = %i;", &results2, &rows, &columns, NULL, accountid ); + float fromtransfersbalance = ( strtod ( results2 [ 1 ], 0 ) * -1 ); + + // finally, we'll get a balance for all the transfers into the account + rows = 0; + columns= 0; + char **results3; + sqlite_get_table_printf ( trdb, "select sum (amount) from transfers where toaccount = %i;", &results3, &rows, &columns, NULL, accountid ); + float totransfersbalance = strtod ( results3 [ 1 ], 0 ); + + sqlite_close ( trdb ); + + // calculate and update new balance + sqlite_exec_printf ( adb, "update accounts2 set balance = %.2f where accountid = %i;", 0, 0, 0, + ( transactionsbalance + fromtransfersbalance + totransfersbalance + getStatementBalance ( accountid ) ), accountid ); + } + +void Account::changeParentAccountBalance ( int parentid ) + { + // select all child balances that share the parent of the current child account + char **results; + int rows; + sqlite_get_table_printf ( adb, "select sum ( balance ) from accounts2 where parent = %i;", &results, &rows, NULL, NULL, parentid ); + sqlite_exec_printf ( adb, "update accounts2 set balance = %.2f where accountid = %i;", 0, 0, 0, strtod ( results[ 1 ], NULL ), parentid ); + } + +int Account::getParentAccountID ( int id ) + { + char **results; + sqlite_get_table_printf ( adb, "select parent from accounts2 where accountid = %i;", &results, NULL, NULL, NULL, id ); + return atoi ( results [ 1 ] ); + } + +int Account::getParentAccountID ( QString accountname ) + { + char **results; + sqlite_get_table_printf ( adb, "select parent from accounts2 where name= '%q';", &results, NULL, NULL, NULL, ( const char * ) accountname ); + return atoi ( results [ 1 ] ); + } + +void Account::displayAccounts ( QListView *listview ) + { + char **results; + int rows, columns; + sqlite_get_table ( adb, "select name, parent, balance, accountid, currency from accounts2;", &results, &rows, &columns, 0 ); + + // determine if we are using currency support + int currency = preferences->getPreference ( 4 ); + + // remove all columns from the account display + int counter; + for ( counter = 0; counter <= columns; counter++ ) + listview->removeColumn ( 0 ); + + // add columns to the account display + listview->addColumn ( "Account", 0 ); + int columntoalign = 1; + if ( preferences->getPreference ( 4 ) == 1 ) // add the currency column if the user wants it + { + listview->addColumn ( "C", 0 ); + columntoalign = 2; + } + listview->addColumn ( "Balance", 0 ); + listview->addColumn ( "", 0 ); + listview->setColumnAlignment ( columntoalign, Qt::AlignRight ); + counter = 5; + int total = ( rows + 1 ) * columns; + while ( counter < total ) + { + int accountid = atoi ( results [ counter + 3 ] ); + if ( atoi ( results [ counter + 1 ] ) == -1 ) + { + QListViewItem *parent = new QListViewItem ( listview ); + parent->setText ( 0, results [ counter ] ); + if ( currency == 0 ) + { + parent->setText ( 1, results [ counter + 2 ] ); + parent->setText ( 2, results [ counter + 3 ] ); + } + else + { + if ( getNumberOfChildAccounts ( accountid ) == 0 ) // add the currency flag if this is a parent with no children + { + // create the string we'll use to set the currency pixmap + QString filename = "/opt/QtPalmtop/pics/flags/"; + QString flag = results [ counter + 4 ]; + filename.append ( flag ); + filename.append ( ".png" ); + parent->setPixmap ( 1, QPixmap ( filename ) ); + parent->setText ( 1, flag ); + } + parent->setText ( 2, results [ counter + 2 ] ); + parent->setText ( 3, results [ counter + 3 ] ); + } + + if ( getAccountExpanded ( accountid ) == 1 ) + parent->setOpen ( TRUE ); + + //Start display child accounts for this parent + int childcounter = 5; + while ( childcounter < total ) + { + if ( atoi ( results [ childcounter + 1 ] ) == accountid ) + { + if ( currency == 0 ) + QListViewItem *child = new QListViewItem ( parent, results [ childcounter ], results [ childcounter + 2 ], results [ childcounter + 3 ] ); + else + { + // create the string we'll use to set the currency pixmap + QString filename = "/opt/QtPalmtop/pics/flags/"; + QString flag = results [ childcounter + 4 ]; + filename.append ( flag ); + filename.append ( ".png" ); + QListViewItem *child = new QListViewItem ( parent, results [ childcounter ], "", results [ childcounter + 2 ], results [ childcounter + 3 ] ); + child->setPixmap ( 1, QPixmap ( filename ) ); + child->setText ( 1, flag ); + } + } + childcounter = childcounter + 5; + } + //End display child accounts + } + counter = counter + 5; + } + + // resize all columns appropriately + if ( preferences->getPreference ( 4 ) == 0 ) + { + listview->setColumnWidth ( 0, preferences->getColumnPreference ( 1 ) ); + listview->setColumnWidthMode ( 0, QListView::Manual ); + listview->setColumnWidth ( 1, preferences->getColumnPreference ( 2 ) ); + listview->setColumnWidthMode ( 1, QListView::Manual ); + listview->setColumnWidthMode ( 2, QListView::Manual ); + } + else + { + listview->setColumnWidth ( 0, preferences->getColumnPreference ( 10 ) ); + listview->setColumnWidthMode ( 0, QListView::Manual ); + listview->setColumnWidth ( 1, preferences->getColumnPreference ( 11 ) ); + listview->setColumnWidthMode ( 1, QListView::Manual ); + listview->setColumnWidth ( 2, preferences->getColumnPreference ( 12 ) ); + listview->setColumnWidthMode ( 2, QListView::Manual ); + listview->setColumnWidthMode ( 3, QListView::Manual ); + } + } + +int Account::displayParentAccountNames ( QComboBox *combobox, QString indexstring ) + { + char **results; + int rows, columns, index; + index = 0; + sqlite_get_table ( adb, "select name from accounts2 order by name asc;", &results, &rows, &columns, NULL ); + int counter = 1; + int indexcounter = 1; + int total = ( rows + 1 ) * columns; + while ( counter < total ) + { + if ( getParentAccountID ( results [ counter ] ) == -1 ) + { + combobox->insertItem ( results [ counter ], -1 ); + if ( strcmp ( results [ counter ], indexstring ) == 0 ) + index = indexcounter; + indexcounter++; + } + counter ++; + } + return index; + } + +int Account::getAccountType ( int accountid ) + { + char **results; + sqlite_get_table_printf ( adb, "select type from accounts2 where accountid= %i;", &results, NULL, NULL, NULL, accountid ); + return atoi ( results [ 1 ] ); + } + +int Account::getStatementDay ( int accountid ) + { + char **results; + sqlite_get_table_printf ( adb, "select statementday from accounts2 where accountid= %i;", &results, NULL, NULL, NULL, accountid ); + return atoi ( results [ 1 ] ); + } + +int Account::getStatementMonth ( int accountid ) + { + char **results; + sqlite_get_table_printf ( adb, "select statementmonth from accounts2 where accountid= %i;", &results, NULL, NULL, NULL, accountid ); + return atoi ( results [ 1 ] ); + } + +int Account::getStatementYear ( int accountid ) + { + char **results; + sqlite_get_table_printf ( adb, "select statementyear from accounts2 where accountid= %i;", &results, NULL, NULL, NULL, accountid ); + return atoi ( results [ 1 ] ); + } + +QString Account::getAccountDescription ( int accountid ) + { + char **results; + sqlite_get_table_printf ( adb, "select description from accounts2 where accountid= %i;", &results, NULL, NULL, NULL, accountid ); + return ( QString ) results [ 1 ]; + } + +QString Account::getCurrencyCode ( int accountid ) + { + char **results; + sqlite_get_table_printf ( adb, "select currency from accounts2 where accountid= %i;", &results, NULL, NULL, NULL, accountid ); + return ( QString ) results [ 1 ]; + } + +QString Account::getAccountName ( int accountid ) + { + char **results; + sqlite_get_table_printf ( adb, "select name from accounts2 where accountid= %i;", &results, NULL, NULL, NULL, accountid ); + return ( QString ) results [ 1 ]; + } + +QString Account::getAccountBalance ( int accountid ) + { + char **results; + sqlite_get_table_printf ( adb, "select balance from accounts2 where accountid= %i;", &results, NULL, NULL, NULL, accountid ); + return ( QString ) results [ 1 ]; + } + +float Account::getAccountCreditLimit ( int accountid ) + { + char **results; + sqlite_get_table_printf ( adb, "select creditlimit from accounts2 where accountid = %i;", &results, NULL, NULL, NULL, accountid ); + return strtod ( results [ 1 ], NULL ); + } + +float Account::getStatementBalance ( int accountid ) + { + char **results; + sqlite_get_table_printf ( adb, "select statementbalance from accounts2 where accountid = %i;", &results, NULL, NULL, NULL, accountid ); + return strtod ( results [ 1 ], NULL ); + } + +GreyBackgroundItem::GreyBackgroundItem ( QListView *parent ) + : QListViewItem ( parent ) + { + } + +GreyBackgroundItem::GreyBackgroundItem ( QListView *parent, QString label1, QString label2, QString label3 ) + : QListViewItem ( parent, label1, label2, label3 ) + { + } + +GreyBackgroundItem::GreyBackgroundItem ( QListView *parent, QString label1, QString label2, QString label3, QString label4 ) + : QListViewItem ( parent, label1, label2, label3, label4 ) + { + } + +GreyBackgroundItem::GreyBackgroundItem ( QListView *parent, QString label1, QString label2, QString label3, QString label4, QString label5 ) + : QListViewItem ( parent, label1, label2, label3, label4, label5 ) + { + } + +void GreyBackgroundItem::paintCell ( QPainter *p, const QColorGroup &cg, int column, int width, int alignment ) + { + QColorGroup _cg ( cg ); + _cg.setColor ( QColorGroup::Base, Qt::lightGray ); + QListViewItem::paintCell ( p, _cg, column, width, alignment ); + } + +QStringList Account::getAccountNames () + { + QStringList accountnames; + char **results; + int rows, counter; + sqlite_get_table ( adb, "select name from accounts2;", &results, &rows, 0, 0 ); + for ( counter = 0; counter < rows; counter++ ) + accountnames.append ( results [ counter+1 ] ); + return accountnames; + } + +QStringList Account::getAccountIDs () + { + QStringList accountids; + char **results; + int rows, counter; + sqlite_get_table ( adb, "select accountid from accounts2;", &results, &rows, 0, 0 ); + for ( counter = 0; counter < rows; counter++ ) + accountids.append ( results [ counter+1 ] ); + return accountids; + } + + |