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();
+ }
}