package net.ktnx.mobileledger.ui.transaction_list;
+import android.app.Activity;
import android.arch.lifecycle.ViewModel;
-import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
+import android.util.Log;
+import android.view.View;
+import android.widget.AutoCompleteTextView;
+import net.ktnx.mobileledger.R;
import net.ktnx.mobileledger.model.LedgerTransaction;
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(Context context) {
- if (transactions == null) {
- transactions = new ArrayList<>();
- reloadTransactions(context);
- }
+ public void reloadTransactions(TransactionListFragment context) {
+ ArrayList<LedgerTransaction> newList = new ArrayList<>();
- return transactions;
- }
- public void reloadTransactions(Context context) {
- transactions.clear();
- String sql = "SELECT id FROM transactions ORDER BY date desc, id desc";
+ Activity act = context.getActivity();
+
+ boolean hasFilter =
+ act.findViewById(R.id.transaction_list_account_name_filter).getVisibility() ==
+ View.VISIBLE;
+
+ String sql;
+ String[] params;
+
+ sql = "SELECT id FROM transactions ORDER BY date desc, id desc";
+ params = null;
+
+ if (hasFilter) {
+ String filterAccName = String.valueOf(
+ ((AutoCompleteTextView) act.findViewById(R.id.transaction_filter_account_name))
+ .getText());
- try (SQLiteDatabase db = MLDB.getReadableDatabase(context)) {
- try (Cursor cursor = db.rawQuery(sql, null)) {
+ if (!filterAccName.isEmpty()) {
+ sql = "SELECT distinct tr.id from transactions tr JOIN transaction_accounts ta " +
+ "ON ta.transaction_id=tr.id WHERE ta.account_name LIKE ?||'%' AND ta" +
+ ".amount <> 0 ORDER BY tr.date desc, tr.id desc";
+ params = new String[]{filterAccName};
+ }
+ }
+
+ Log.d("tmp", sql);
+ try (SQLiteDatabase db = MLDB.getReadableDatabase()) {
+ try (Cursor cursor = db.rawQuery(sql, params)) {
while (cursor.moveToNext()) {
- transactions.add(new LedgerTransaction(cursor.getInt(0)));
+ 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();
+ }
}