import net.ktnx.mobileledger.BuildConfig;
import net.ktnx.mobileledger.R;
import net.ktnx.mobileledger.async.DescriptionSelectedCallback;
-import net.ktnx.mobileledger.async.SaveTransactionTask;
+import net.ktnx.mobileledger.async.SendTransactionTask;
import net.ktnx.mobileledger.async.TaskCallback;
import net.ktnx.mobileledger.model.Data;
import net.ktnx.mobileledger.model.LedgerTransaction;
public class NewTransactionActivity extends ProfileThemedActivity
implements TaskCallback, DescriptionSelectedCallback {
- private static SaveTransactionTask saver;
+ private static SendTransactionTask saver;
private TableLayout table;
private ProgressBar progress;
private FloatingActionButton fab;
setContentView(R.layout.activity_new_transaction);
Toolbar toolbar = findViewById(R.id.toolbar);
setSupportActionBar(toolbar);
- toolbar.setSubtitle(Data.profile.get().getName());
+ toolbar.setSubtitle(mProfile.getName());
tvDate = findViewById(R.id.new_transaction_date);
tvDate.setOnFocusChangeListener((v, hasFocus) -> {
// Log.d("swipe", "hooked to row "+i);
}
}
+ @Override
+ protected void initProfile() {
+ String profileUUID = getIntent().getStringExtra("profile_uuid");
+ if (profileUUID != null) {
+ mProfile = Data.getProfile(profileUUID);
+ if (mProfile == null) finish();
+ }
+ else super.initProfile();
+ }
@Override
public void finish() {
super.finish();
progress.setVisibility(View.VISIBLE);
try {
- saver = new SaveTransactionTask(this);
+ saver = new SendTransactionTask(this, mProfile);
String dateString = tvDate.getText().toString();
Date date;
LedgerTransaction tr = new LedgerTransaction(date, tvDescription.getText().toString());
TableLayout table = findViewById(R.id.new_transaction_accounts_table);
+ LedgerTransactionAccount emptyAmountAccount = null;
+ float emptyAmountAccountBalance = 0;
for (int i = 0; i < table.getChildCount(); i++) {
TableRow row = (TableRow) table.getChildAt(i);
String acc = ((TextView) row.getChildAt(0)).getText().toString();
+ if (acc.isEmpty()) continue;
+
String amt = ((TextView) row.getChildAt(1)).getText().toString();
- LedgerTransactionAccount item =
- amt.length() > 0 ? new LedgerTransactionAccount(acc, Float.parseFloat(amt))
- : new LedgerTransactionAccount(acc);
+ LedgerTransactionAccount item;
+ if (amt.length() > 0) {
+ final float amount = Float.parseFloat(amt);
+ item = new LedgerTransactionAccount(acc, amount);
+ emptyAmountAccountBalance += amount;
+ }
+ else {
+ item = new LedgerTransactionAccount(acc);
+ emptyAmountAccount = item;
+ }
tr.addAccount(item);
}
+
+ if (emptyAmountAccount != null)
+ emptyAmountAccount.setAmount(-emptyAmountAccountBalance);
saver.execute(tr);
}
catch (ParseException e) {
Log.d("descr selected", description);
if (!inputStateIsInitial()) return;
- try (Cursor c = MLDB.getDatabase().rawQuery(
- "select profile, id from transactions where description=? order by date desc " +
- "limit 1", new String[]{description}))
- {
+ MobileLedgerProfile currentProfile = Data.profile.get();
+ String accFilter = currentProfile.getPreferredAccountsFilter();
+
+ ArrayList<String> params = new ArrayList<>();
+ StringBuilder sb = new StringBuilder(
+ "select t.profile, t.id from transactions t where t.description=?");
+ params.add(description);
+
+ if (accFilter != null) {
+ sb.append(" AND EXISTS (").append("SELECT 1 FROM transaction_accounts ta ")
+ .append("WHERE ta.profile = t.profile").append(" AND ta.transaction_id = t.id")
+ .append(" AND UPPER(ta.account_name) LIKE '%'||?||'%')");
+ params.add(accFilter.toUpperCase());
+ }
+
+ sb.append(" ORDER BY date desc limit 1");
+
+ final String sql = sb.toString();
+ Log.d("descr", sql);
+ Log.d("descr", params.toString());
+
+ try (Cursor c = MLDB.getDatabase().rawQuery(sql, params.toArray(new String[]{}))) {
if (!c.moveToNext()) return;
String profileUUID = c.getString(0);