fu: single transaction list

[mobile-ledger.git] / app / src / main / java / net / ktnx / mobileledger / ui / transaction_list / TransactionListViewModel.java

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 d0c979e6df9b06ea6325fa80c3e906f5f3a78e62..480c0de271b9d4d71d0f2215c84102a04e482c07 100644 (file)
--- 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,53 +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.model.LedgerTransactionItem;
-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<LedgerTransaction> transactions;
+    private ArrayList<LedgerTransaction> transactions;
 
-    public List<LedgerTransaction> getTransactions(MobileLedgerDatabase dbh) {
-        if (transactions == null) {
-            transactions = new ArrayList<>();
-            reloadTransactions(dbh);
-        }
+    public void reloadTransactions(Context context) {
+        ArrayList<LedgerTransaction> 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));
-                    try (Cursor cAcc = db.rawQuery("SELECT account_name, amount, currency FROM " +
-                                                   "transaction_accounts WHERE transaction_id = ?",
-                            new String[]{tr.getId()}))
-                    {
-                        while (cAcc.moveToNext()) {
-                            tr.add_item(
-                                    new LedgerTransactionItem(cAcc.getString(0), cAcc.getFloat(1),
-                                            cAcc.getString(2)));
-                        }
-                    }
-                    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();
+    }
 }