X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fjava%2Fnet%2Fktnx%2Fmobileledger%2Fui%2Ftransaction_list%2FTransactionListViewModel.java;h=480c0de271b9d4d71d0f2215c84102a04e482c07;hp=35b011458c8f36759d3e520a2d1552c98fb8a946;hb=a5971dd3588704cc5c8dd9077d4d74860c5a06a9;hpb=a983099d6150044a08a1fbc601d9af9bd8d0c0a8 diff --git a/app/src/main/java/net/ktnx/mobileledger/ui/transaction_list/TransactionListViewModel.java b/app/src/main/java/net/ktnx/mobileledger/ui/transaction_list/TransactionListViewModel.java index 35b01145..480c0de2 100644 --- a/app/src/main/java/net/ktnx/mobileledger/ui/transaction_list/TransactionListViewModel.java +++ b/app/src/main/java/net/ktnx/mobileledger/ui/transaction_list/TransactionListViewModel.java @@ -18,43 +18,42 @@ package net.ktnx.mobileledger.ui.transaction_list; import android.arch.lifecycle.ViewModel; +import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; +import android.util.Log; import net.ktnx.mobileledger.model.LedgerTransaction; -import net.ktnx.mobileledger.utils.MobileLedgerDatabase; +import net.ktnx.mobileledger.utils.MLDB; import java.util.ArrayList; -import java.util.List; public class TransactionListViewModel extends ViewModel { - private List transactions; + private ArrayList transactions; - public List getTransactions(MobileLedgerDatabase dbh) { - if (transactions == null) { - transactions = new ArrayList<>(); - reloadTransactions(dbh); - } + public void reloadTransactions(Context context) { + ArrayList newList = new ArrayList<>(); - return transactions; - } - private void reloadTransactions(MobileLedgerDatabase dbh) { - transactions.clear(); - String sql = "SELECT id, date, description FROM transactions"; - sql += " ORDER BY date desc, id desc"; + String sql = "SELECT id FROM transactions ORDER BY date desc, id desc"; - try (SQLiteDatabase db = dbh.getReadableDatabase()) { + try (SQLiteDatabase db = MLDB.getReadableDatabase(context)) { try (Cursor cursor = db.rawQuery(sql, null)) { while (cursor.moveToNext()) { - LedgerTransaction tr = - new LedgerTransaction(cursor.getString(0), cursor.getString(1), - cursor.getString(2)); - // TODO: fill accounts and amounts - transactions.add(tr); + newList.add(new LedgerTransaction(cursor.getInt(0))); } + transactions = newList; + Log.d("transactions", "transaction list updated"); } } } + public LedgerTransaction getTransaction(int position) { + if (position >= transactions.size()) return null; + return transactions.get(position); + } + public int getTransactionCount() { + if (transactions == null) return 0; + return transactions.size(); + } }