+/*
+ * Copyright © 2018 Damyan Ivanov.
+ * This file is part of Mobile-Ledger.
+ * Mobile-Ledger is free software: you can distribute it and/or modify it
+ * under the term of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your opinion), any later version.
+ *
+ * Mobile-Ledger is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License terms for details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with Mobile-Ledger. If not, see <https://www.gnu.org/licenses/>.
+ */
+
package net.ktnx.mobileledger;
+import android.annotation.SuppressLint;
import android.annotation.TargetApi;
import android.database.Cursor;
import android.database.MatrixCursor;
import android.view.MenuItem;
import android.view.MotionEvent;
import android.view.View;
+import android.view.inputmethod.EditorInfo;
import android.widget.AutoCompleteTextView;
import android.widget.EditText;
import android.widget.FilterQueryProvider;
import android.widget.TableRow;
import android.widget.TextView;
+import net.ktnx.mobileledger.async.SaveTransactionTask;
+import net.ktnx.mobileledger.async.TaskCallback;
+import net.ktnx.mobileledger.model.LedgerTransaction;
+import net.ktnx.mobileledger.model.LedgerTransactionItem;
+import net.ktnx.mobileledger.ui.DatePickerFragment;
+import net.ktnx.mobileledger.utils.MobileLedgerDatabase;
+
+import java.util.Date;
import java.util.Objects;
/*
- * TODO: auto-fill of transaction description
- * if Android O's implementation won't work, add a custom one
* TODO: nicer progress while transaction is submitted
* TODO: latest transactions, maybe with browsing further in the past?
* TODO: reports
private AutoCompleteTextView text_descr;
private static SaveTransactionTask saver;
private MenuItem mSave;
+ private MobileLedgerDatabase dbh;
@Override
protected void onCreate(Bundle savedInstanceState) {
Toolbar toolbar = findViewById(R.id.toolbar);
setSupportActionBar(toolbar);
+ dbh = new MobileLedgerDatabase(this);
+
text_date = findViewById(R.id.new_transaction_date);
+ text_date.setOnFocusChangeListener(new View.OnFocusChangeListener() {
+ @Override
+ public
+ void onFocusChange(View v, boolean hasFocus) {
+ if (hasFocus) pickTransactionDate(v);
+ }
+ });
text_descr = findViewById(R.id.new_transaction_description);
- hook_autocompletion_adapter(text_descr, MobileLedgerDB.DESCRIPTION_HISTORY_TABLE, "description");
+ hook_autocompletion_adapter(text_descr, MobileLedgerDatabase
+ .DESCRIPTION_HISTORY_TABLE, "description");
+ hook_text_change_listener(text_descr);
progress = findViewById(R.id.save_transaction_progress);
AutoCompleteTextView acc_name_view = (AutoCompleteTextView) row.getChildAt(0);
TextView amount_view = (TextView) row.getChildAt(1);
hook_swipe_listener(row);
- hook_autocompletion_adapter(acc_name_view, MobileLedgerDB.ACCOUNTS_TABLE, "name");
+ hook_autocompletion_adapter(acc_name_view, MobileLedgerDatabase.ACCOUNTS_TABLE, "name");
hook_text_change_listener(acc_name_view);
hook_text_change_listener(amount_view);
// Log.d("swipe", "hooked to row "+i);
}
}
+ @Override
+ protected
+ void onStart() {
+ super.onStart();
+ if (text_descr.getText().toString().isEmpty()) text_descr.requestFocus();
+ }
+
@Override
public void finish() {
super.finish();
saver = new SaveTransactionTask(this);
saver.setPref(PreferenceManager.getDefaultSharedPreferences(this));
- LedgerTransaction tr = new LedgerTransaction(text_date.getText().toString(), text_descr.getText().toString());
+ String date = text_date.getText().toString();
+ if (date.isEmpty()) date = String.valueOf(new Date().getDate());
+ LedgerTransaction tr = new LedgerTransaction(date, text_descr.getText().toString());
TableLayout table = findViewById(R.id.new_transaction_accounts_table);
for ( int i = 0; i < table.getChildCount(); i++ ) {
}
private void toggle_all_editing(boolean enabled) {
+ text_date.setEnabled(enabled);
+ text_descr.setEnabled(enabled);
TableLayout table = findViewById(R.id.new_transaction_accounts_table);
for (int i = 0; i < table.getChildCount(); i++) {
TableRow row = (TableRow) table.getChildAt(i);
public void onSwipeLeft() {
// Log.d("swipe", "LEFT" + row.getId());
if (table.getChildCount() > 2) {
+ TableRow prev_row = (TableRow) table.getChildAt(table.indexOfChild(row) - 1);
+ TableRow next_row = (TableRow) table.getChildAt(table.indexOfChild(row) + 1);
+ TextView prev_amt =
+ (prev_row != null) ? (TextView) prev_row.getChildAt(1) : text_descr;
+ TextView next_acc =
+ (next_row != null) ? (TextView) next_row.getChildAt(0) : null;
+
+ if (next_acc == null) {
+ prev_amt.setNextFocusRightId(R.id.none);
+ prev_amt.setNextFocusForwardId(R.id.none);
+ prev_amt.setImeOptions(EditorInfo.IME_ACTION_DONE);
+ }
+ else {
+ prev_amt.setNextFocusRightId(next_acc.getId());
+ prev_amt.setNextFocusForwardId(next_acc.getId());
+ prev_amt.setImeOptions(EditorInfo.IME_ACTION_NEXT);
+ }
+
+ if (row.hasFocus()) {
+ if (next_acc != null) next_acc.requestFocus();
+ else prev_amt.requestFocus();
+ }
+
table.removeView(row);
+ check_transaction_submittable();
// Toast.makeText(NewTransactionActivity.this, "LEFT", Toast.LENGTH_LONG).show();
}
else {
private void hook_autocompletion_adapter(final AutoCompleteTextView view, final String table, final String field) {
String[] from = {field};
int[] to = {android.R.id.text1};
- SQLiteDatabase db = MobileLedgerDB.db;
-
- SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, android.R.layout.simple_dropdown_item_1line, null, from, to, 0);
+ SimpleCursorAdapter adapter =
+ new SimpleCursorAdapter(this, android.R.layout.simple_dropdown_item_1line, null,
+ from, to, 0);
adapter.setStringConversionColumn(1);
FilterQueryProvider provider = new FilterQueryProvider() {
@Override
- public Cursor runQuery(CharSequence constraint) {
+ public
+ Cursor runQuery(CharSequence constraint) {
if (constraint == null) return null;
String str = constraint.toString().toUpperCase();
- Log.d("autocompletion", "Looking for "+str);
+ Log.d("autocompletion", "Looking for " + str);
String[] col_names = {FontsContract.Columns._ID, field};
MatrixCursor c = new MatrixCursor(col_names);
- Cursor matches = db.rawQuery(String.format(
- "SELECT %s as a, case when %s_upper LIKE ?||'%%' then 1 " +
- "WHEN %s_upper LIKE '%%:'||?||'%%' then 2 " +
- "WHEN %s_upper LIKE '%% '||?||'%%' then 3 " + "else 9 end " +
- "FROM %s " + "WHERE %s_upper LIKE '%%'||?||'%%' " +
- "ORDER BY 2, 1;", field, field, field, field, table, field),
- new String[]{str, str, str, str});
-
- try {
- int i = 0;
- while (matches.moveToNext()) {
- String match = matches.getString(0);
- int order = matches.getInt(1);
- Log.d("autocompletion", String.format("match: %s |%d", match, order));
- c.newRow().add(i++).add(match);
+ try (SQLiteDatabase db = dbh.getReadableDatabase()) {
+
+ try (Cursor matches = db.rawQuery(String.format(
+ "SELECT %s as a, case when %s_upper LIKE ?||'%%' then 1 "
+ + "WHEN %s_upper LIKE '%%:'||?||'%%' then 2 "
+ + "WHEN %s_upper LIKE '%% '||?||'%%' then 3 " + "else 9 end "
+ + "FROM %s " + "WHERE %s_upper LIKE '%%'||?||'%%' "
+ + "ORDER BY 2, 1;", field, field, field, field, table, field),
+ new String[]{str, str, str, str}))
+ {
+ int i = 0;
+ while (matches.moveToNext()) {
+ String match = matches.getString(0);
+ int order = matches.getInt(1);
+ Log.d("autocompletion", String.format("match: %s |%d", match, order));
+ c.newRow().add(i++).add(match);
+ }
}
- }
- finally {
- matches.close();
- }
- return c;
+ return c;
+ }
}
};
mSave = menu.findItem(R.id.action_submit_transaction);
if (mSave == null) throw new AssertionError();
+ check_transaction_submittable();
+
return true;
}
acc.setLayoutParams(new TableRow.LayoutParams(TableRow.LayoutParams.MATCH_PARENT, TableRow.LayoutParams.WRAP_CONTENT, 9f));
acc.setHint(R.string.new_transaction_account_hint);
acc.setWidth(0);
+ acc.setImeOptions(EditorInfo.IME_ACTION_NEXT | EditorInfo.IME_FLAG_NO_ENTER_ACTION
+ | EditorInfo.IME_FLAG_NAVIGATE_NEXT);
+ acc.setSingleLine(true);
final EditText amt = new EditText(this);
amt.setLayoutParams(new TableRow.LayoutParams(TableRow.LayoutParams.WRAP_CONTENT,
amt.setInputType(InputType.TYPE_CLASS_NUMBER | InputType.TYPE_NUMBER_FLAG_SIGNED | InputType.TYPE_NUMBER_FLAG_DECIMAL );
amt.setMinWidth(dp2px(40));
amt.setTextAlignment(EditText.TEXT_ALIGNMENT_VIEW_END);
+ amt.setImeOptions(EditorInfo.IME_ACTION_DONE);
+
+ // forward navigation support
+ final TableRow last_row = (TableRow) table.getChildAt(table.getChildCount() - 1);
+ final TextView last_amt = (TextView) last_row.getChildAt(1);
+ last_amt.setNextFocusForwardId(acc.getId());
+ last_amt.setNextFocusRightId(acc.getId());
+ last_amt.setImeOptions(EditorInfo.IME_ACTION_NEXT);
+ acc.setNextFocusForwardId(amt.getId());
+ acc.setNextFocusRightId(amt.getId());
final TableRow row = new TableRow(this);
row.setLayoutParams(new TableRow.LayoutParams(TableRow.LayoutParams.MATCH_PARENT, TableRow.LayoutParams.MATCH_PARENT));
if (focus) acc.requestFocus();
hook_swipe_listener(row);
- hook_autocompletion_adapter(acc, MobileLedgerDB.ACCOUNTS_TABLE, "name");
+ hook_autocompletion_adapter(acc, MobileLedgerDatabase.ACCOUNTS_TABLE, "name");
hook_text_change_listener(acc);
hook_text_change_listener(amt);
}
do_add_account_row(true);
}
+ public
+ void resetTransactionFromMenu(MenuItem item) {
+ reset_form();
+ }
+
public void saveTransactionFromMenu(MenuItem item) {
save_transaction();
}
+ private
+ boolean is_zero(float f) {
+ return (f < 0.005) && (f > -0.005);
+ }
+
+ // rules:
+ // 1) at least two account names
+ // 2) each amount must have account name
+ // 3) amounts must balance to 0, or
+ // 3a) there must be exactly one empty amount
+ // 4) empty accounts with empty amounts are ignored
+ // 5) a row with an empty account name or empty amount is guaranteed to exist
+ @SuppressLint("DefaultLocale")
private void check_transaction_submittable() {
TableLayout table = findViewById(R.id.new_transaction_accounts_table);
int accounts = 0;
int accounts_with_values = 0;
+ int amounts = 0;
+ int amounts_with_accounts = 0;
int empty_rows = 0;
- for(int i = 0; i < table.getChildCount(); i++ ) {
- TableRow row = (TableRow) table.getChildAt(i);
+ TextView empty_amount = null;
+ boolean single_empty_amount = false;
+ boolean single_empty_amount_has_account = false;
+ float running_total = 0f;
+ boolean have_description =
+ !((TextView) findViewById(R.id.new_transaction_description)).getText().toString()
+ .isEmpty();
+
+ try {
+ for (int i = 0; i < table.getChildCount(); i++) {
+ TableRow row = (TableRow) table.getChildAt(i);
+
+ TextView acc_name_v = (TextView) row.getChildAt(0);
+ TextView amount_v = (TextView) row.getChildAt(1);
+ String amt = String.valueOf(amount_v.getText());
+ String acc_name = String.valueOf(acc_name_v.getText());
+ acc_name = acc_name.trim();
- TextView acc_name_v = (TextView) row.getChildAt(0);
+ if (!acc_name.isEmpty()) {
+ accounts++;
- String acc_name = String.valueOf(acc_name_v.getText());
- acc_name = acc_name.trim();
- if (!acc_name.isEmpty()) {
- accounts++;
+ if (!amt.isEmpty()) {
+ accounts_with_values++;
+ }
+ }
+ else empty_rows++;
+
+ if (amt.isEmpty()) {
+ amount_v.setHint(String.format("%1.2f", 0f));
+ if (empty_amount == null) {
+ empty_amount = amount_v;
+ single_empty_amount = true;
+ single_empty_amount_has_account = !acc_name.isEmpty();
+ }
+ else if (!acc_name.isEmpty()) single_empty_amount = false;
+ }
+ else {
+ amounts++;
+ if (!acc_name.isEmpty()) amounts_with_accounts++;
+ running_total += Float.valueOf(amt);
+ }
+ }
- TextView amount_v = (TextView) row.getChildAt(1);
- String amt = String.valueOf(amount_v.getText());
+ if ((empty_rows == 0) && ((table.getChildCount() == accounts) || (table.getChildCount()
+ == amounts)))
+ {
+ do_add_account_row(false);
+ }
- if (!amt.isEmpty()) accounts_with_values++;
- } else empty_rows++;
- }
+ Log.d("submittable", String.format("accounts=%d, accounts_with_values=%s, "
+ + "amounts_with_accounts=%d, amounts=%d, running_total=%1.2f, "
+ + "single_empty_with_acc=%s", accounts, accounts_with_values,
+ amounts_with_accounts, amounts, running_total,
+ (single_empty_amount && single_empty_amount_has_account) ? "true" : "false"));
+
+ if (have_description && (accounts >= 2) && (accounts_with_values >= (accounts - 1)) && (
+ amounts_with_accounts == amounts) && (
+ single_empty_amount && single_empty_amount_has_account || is_zero(
+ running_total)))
+ {
+ if (mSave != null) mSave.setVisible(true);
+ }
+ else if (mSave != null) mSave.setVisible(false);
- if (accounts_with_values == accounts && empty_rows == 0) {
- do_add_account_row(false);
- }
+ if (single_empty_amount) {
+ empty_amount
+ .setHint(String.format("%1.2f", (running_total > 0) ? -running_total : 0f));
+ }
- if ((accounts >= 2) && (accounts_with_values >= (accounts - 1))) {
- if (mSave != null) mSave.setVisible(true);
- } else {
+ }
+ catch (NumberFormatException e) {
+ if (mSave != null) mSave.setVisible(false);
+ }
+ catch (Exception e) {
+ e.printStackTrace();
if (mSave != null) mSave.setVisible(false);
}
}
private void reset_form() {
text_date.setText("");
text_descr.setText("");
+
+ text_descr.requestFocus();
+
while(table.getChildCount() > 2) {
table.removeViewAt(2);
}
((TextView)tr.getChildAt(0)).setText("");
((TextView)tr.getChildAt(1)).setText("");
}
-
- text_descr.requestFocus();
}
}