1 package net.ktnx.mobileledger;
3 import android.annotation.SuppressLint;
4 import android.annotation.TargetApi;
5 import android.database.Cursor;
6 import android.database.MatrixCursor;
7 import android.database.sqlite.SQLiteDatabase;
8 import android.os.Build;
9 import android.os.Bundle;
10 import android.preference.PreferenceManager;
11 import android.provider.FontsContract;
12 import android.support.design.widget.BaseTransientBottomBar;
13 import android.support.design.widget.Snackbar;
14 import android.support.v4.app.DialogFragment;
15 import android.support.v7.app.AppCompatActivity;
16 import android.support.v7.widget.Toolbar;
17 import android.text.Editable;
18 import android.text.InputType;
19 import android.text.TextWatcher;
20 import android.util.Log;
21 import android.util.TypedValue;
22 import android.view.Gravity;
23 import android.view.Menu;
24 import android.view.MenuItem;
25 import android.view.MotionEvent;
26 import android.view.View;
27 import android.view.inputmethod.EditorInfo;
28 import android.widget.AutoCompleteTextView;
29 import android.widget.EditText;
30 import android.widget.FilterQueryProvider;
31 import android.widget.ProgressBar;
32 import android.widget.SimpleCursorAdapter;
33 import android.widget.TableLayout;
34 import android.widget.TableRow;
35 import android.widget.TextView;
37 import java.util.Date;
38 import java.util.Objects;
41 * TODO: auto-fill of transaction description
42 * if Android O's implementation won't work, add a custom one
43 * TODO: nicer progress while transaction is submitted
44 * TODO: latest transactions, maybe with browsing further in the past?
46 * TODO: get rid of the custom session/cookie and auth code?
47 * (the last problem with the POST was the missing content-length header)
49 * TODO: nicer swiping removal with visual feedback
51 * TODO: update accounts/check settings upon change of backend settings
54 public class NewTransactionActivity extends AppCompatActivity implements TaskCallback {
55 private TableLayout table;
56 private ProgressBar progress;
57 private TextView text_date;
58 private AutoCompleteTextView text_descr;
59 private static SaveTransactionTask saver;
60 private MenuItem mSave;
61 private MobileLedgerDatabase dbh;
64 protected void onCreate(Bundle savedInstanceState) {
65 super.onCreate(savedInstanceState);
66 setContentView(R.layout.activity_new_transaction);
67 Toolbar toolbar = findViewById(R.id.toolbar);
68 setSupportActionBar(toolbar);
70 dbh = new MobileLedgerDatabase(this);
72 text_date = findViewById(R.id.new_transaction_date);
73 text_date.setOnFocusChangeListener(new View.OnFocusChangeListener() {
76 void onFocusChange(View v, boolean hasFocus) {
77 if (hasFocus) pickTransactionDate(v);
80 text_descr = findViewById(R.id.new_transaction_description);
81 hook_autocompletion_adapter(text_descr, MobileLedgerDatabase
82 .DESCRIPTION_HISTORY_TABLE, "description");
83 hook_text_change_listener(text_descr);
85 progress = findViewById(R.id.save_transaction_progress);
87 Objects.requireNonNull(getSupportActionBar()).setDisplayHomeAsUpEnabled(true);
88 table = findViewById(R.id.new_transaction_accounts_table);
89 for (int i = 0; i < table.getChildCount(); i++) {
90 TableRow row = (TableRow) table.getChildAt(i);
91 AutoCompleteTextView acc_name_view = (AutoCompleteTextView) row.getChildAt(0);
92 TextView amount_view = (TextView) row.getChildAt(1);
93 hook_swipe_listener(row);
94 hook_autocompletion_adapter(acc_name_view, MobileLedgerDatabase.ACCOUNTS_TABLE, "name");
95 hook_text_change_listener(acc_name_view);
96 hook_text_change_listener(amount_view);
97 // Log.d("swipe", "hooked to row "+i);
105 if (text_descr.getText().toString().isEmpty()) text_descr.requestFocus();
109 public void finish() {
111 overridePendingTransition(R.anim.dummy, R.anim.slide_out_right);
115 public boolean onOptionsItemSelected(MenuItem item) {
116 switch (item.getItemId()) {
117 case android.R.id.home:
121 return super.onOptionsItemSelected(item);
124 public void save_transaction() {
125 if (mSave != null) mSave.setVisible(false);
126 toggle_all_editing(false);
127 progress.setVisibility(View.VISIBLE);
129 saver = new SaveTransactionTask(this);
131 saver.setPref(PreferenceManager.getDefaultSharedPreferences(this));
132 String date = text_date.getText().toString();
133 if (date.isEmpty()) date = String.valueOf(new Date().getDate());
134 LedgerTransaction tr = new LedgerTransaction(date, text_descr.getText().toString());
136 TableLayout table = findViewById(R.id.new_transaction_accounts_table);
137 for ( int i = 0; i < table.getChildCount(); i++ ) {
138 TableRow row = (TableRow) table.getChildAt(i);
139 String acc = ((TextView) row.getChildAt(0)).getText().toString();
140 String amt = ((TextView) row.getChildAt(1)).getText().toString();
141 LedgerTransactionItem item =
143 ? new LedgerTransactionItem( acc, Float.parseFloat(amt))
144 : new LedgerTransactionItem( acc );
151 private void toggle_all_editing(boolean enabled) {
152 text_date.setEnabled(enabled);
153 text_descr.setEnabled(enabled);
154 TableLayout table = findViewById(R.id.new_transaction_accounts_table);
155 for (int i = 0; i < table.getChildCount(); i++) {
156 TableRow row = (TableRow) table.getChildAt(i);
157 for (int j = 0; j < row.getChildCount(); j++) {
158 row.getChildAt(j).setEnabled(enabled);
163 private void hook_swipe_listener(final TableRow row) {
164 row.getChildAt(0).setOnTouchListener(new OnSwipeTouchListener(this) {
165 public void onSwipeLeft() {
166 // Log.d("swipe", "LEFT" + row.getId());
167 if (table.getChildCount() > 2) {
168 TableRow prev_row = (TableRow) table.getChildAt(table.indexOfChild(row) - 1);
169 TableRow next_row = (TableRow) table.getChildAt(table.indexOfChild(row) + 1);
171 (prev_row != null) ? (TextView) prev_row.getChildAt(1) : text_descr;
173 (next_row != null) ? (TextView) next_row.getChildAt(0) : null;
175 if (next_acc == null) {
176 prev_amt.setNextFocusRightId(R.id.none);
177 prev_amt.setNextFocusForwardId(R.id.none);
178 prev_amt.setImeOptions(EditorInfo.IME_ACTION_DONE);
181 prev_amt.setNextFocusRightId(next_acc.getId());
182 prev_amt.setNextFocusForwardId(next_acc.getId());
183 prev_amt.setImeOptions(EditorInfo.IME_ACTION_NEXT);
186 if (row.hasFocus()) {
187 if (next_acc != null) next_acc.requestFocus();
188 else prev_amt.requestFocus();
191 table.removeView(row);
192 check_transaction_submittable();
193 // Toast.makeText(NewTransactionActivity.this, "LEFT", Toast.LENGTH_LONG).show();
196 Snackbar.make(table, R.string.msg_at_least_two_accounts_are_required, Snackbar.LENGTH_LONG)
197 .setAction("Action", null).show();
201 // public boolean performClick(View view, MotionEvent m) {
204 public boolean onTouch(View view, MotionEvent m) {
205 return gestureDetector.onTouchEvent(m);
210 private void hook_text_change_listener(final TextView view) {
211 view.addTextChangedListener(new TextWatcher() {
213 public void beforeTextChanged(CharSequence s, int start, int count, int after) {
218 public void onTextChanged(CharSequence s, int start, int before, int count) {
223 public void afterTextChanged(Editable s) {
224 // Log.d("input", "text changed");
225 check_transaction_submittable();
231 @TargetApi(Build.VERSION_CODES.N)
232 private void hook_autocompletion_adapter(final AutoCompleteTextView view, final String table, final String field) {
233 String[] from = {field};
234 int[] to = {android.R.id.text1};
235 SimpleCursorAdapter adapter =
236 new SimpleCursorAdapter(this, android.R.layout.simple_dropdown_item_1line, null,
238 adapter.setStringConversionColumn(1);
240 FilterQueryProvider provider = new FilterQueryProvider() {
243 Cursor runQuery(CharSequence constraint) {
244 if (constraint == null) return null;
246 String str = constraint.toString().toUpperCase();
247 Log.d("autocompletion", "Looking for " + str);
248 String[] col_names = {FontsContract.Columns._ID, field};
249 MatrixCursor c = new MatrixCursor(col_names);
251 try (SQLiteDatabase db = dbh.getReadableDatabase()) {
253 try (Cursor matches = db.rawQuery(String.format(
254 "SELECT %s as a, case when %s_upper LIKE ?||'%%' then 1 "
255 + "WHEN %s_upper LIKE '%%:'||?||'%%' then 2 "
256 + "WHEN %s_upper LIKE '%% '||?||'%%' then 3 " + "else 9 end "
257 + "FROM %s " + "WHERE %s_upper LIKE '%%'||?||'%%' "
258 + "ORDER BY 2, 1;", field, field, field, field, table, field),
259 new String[]{str, str, str, str}))
262 while (matches.moveToNext()) {
263 String match = matches.getString(0);
264 int order = matches.getInt(1);
265 Log.d("autocompletion", String.format("match: %s |%d", match, order));
266 c.newRow().add(i++).add(match);
276 adapter.setFilterQueryProvider(provider);
278 view.setAdapter(adapter);
281 public boolean onCreateOptionsMenu(Menu menu) {
282 // Inflate the menu; this adds items to the action bar if it is present.
283 getMenuInflater().inflate(R.menu.new_transaction, menu);
284 mSave = menu.findItem(R.id.action_submit_transaction);
285 if (mSave == null) throw new AssertionError();
287 check_transaction_submittable();
292 public void pickTransactionDate(View view) {
293 DialogFragment picker = new DatePickerFragment();
294 picker.show(getSupportFragmentManager(), "datePicker");
297 public int dp2px(float dp) {
298 return Math.round(TypedValue.applyDimension(TypedValue.COMPLEX_UNIT_DIP, dp, getResources().getDisplayMetrics()));
301 private void do_add_account_row(boolean focus) {
302 final AutoCompleteTextView acc = new AutoCompleteTextView(this);
303 acc.setLayoutParams(new TableRow.LayoutParams(TableRow.LayoutParams.MATCH_PARENT, TableRow.LayoutParams.WRAP_CONTENT, 9f));
304 acc.setHint(R.string.new_transaction_account_hint);
306 acc.setImeOptions(EditorInfo.IME_ACTION_NEXT | EditorInfo.IME_FLAG_NO_ENTER_ACTION
307 | EditorInfo.IME_FLAG_NAVIGATE_NEXT);
308 acc.setSingleLine(true);
310 final EditText amt = new EditText(this);
311 amt.setLayoutParams(new TableRow.LayoutParams(TableRow.LayoutParams.WRAP_CONTENT,
312 TableRow.LayoutParams.MATCH_PARENT, 1f));
313 amt.setHint(R.string.new_transaction_amount_hint);
315 amt.setInputType(InputType.TYPE_CLASS_NUMBER | InputType.TYPE_NUMBER_FLAG_SIGNED | InputType.TYPE_NUMBER_FLAG_DECIMAL );
316 amt.setMinWidth(dp2px(40));
317 amt.setTextAlignment(EditText.TEXT_ALIGNMENT_VIEW_END);
318 amt.setImeOptions(EditorInfo.IME_ACTION_DONE);
320 // forward navigation support
321 final TableRow last_row = (TableRow) table.getChildAt(table.getChildCount() - 1);
322 final TextView last_amt = (TextView) last_row.getChildAt(1);
323 last_amt.setNextFocusForwardId(acc.getId());
324 last_amt.setNextFocusRightId(acc.getId());
325 last_amt.setImeOptions(EditorInfo.IME_ACTION_NEXT);
326 acc.setNextFocusForwardId(amt.getId());
327 acc.setNextFocusRightId(amt.getId());
329 final TableRow row = new TableRow(this);
330 row.setLayoutParams(new TableRow.LayoutParams(TableRow.LayoutParams.MATCH_PARENT, TableRow.LayoutParams.MATCH_PARENT));
331 row.setGravity(Gravity.BOTTOM);
336 if (focus) acc.requestFocus();
338 hook_swipe_listener(row);
339 hook_autocompletion_adapter(acc, MobileLedgerDatabase.ACCOUNTS_TABLE, "name");
340 hook_text_change_listener(acc);
341 hook_text_change_listener(amt);
344 public void addTransactionAccountFromMenu(MenuItem item) {
345 do_add_account_row(true);
349 void resetTransactionFromMenu(MenuItem item) {
353 public void saveTransactionFromMenu(MenuItem item) {
358 boolean is_zero(float f) {
359 return (f < 0.005) && (f > -0.005);
363 // 1) at least two account names
364 // 2) each amount must have account name
365 // 3) amounts must balance to 0, or
366 // 3a) there must be exactly one empty amount
367 // 4) empty accounts with empty amounts are ignored
368 // 5) a row with an empty account name or empty amount is guaranteed to exist
369 @SuppressLint("DefaultLocale")
370 private void check_transaction_submittable() {
371 TableLayout table = findViewById(R.id.new_transaction_accounts_table);
373 int accounts_with_values = 0;
375 int amounts_with_accounts = 0;
377 TextView empty_amount = null;
378 boolean single_empty_amount = false;
379 boolean single_empty_amount_has_account = false;
380 float running_total = 0f;
381 boolean have_description =
382 !((TextView) findViewById(R.id.new_transaction_description)).getText().toString()
386 for (int i = 0; i < table.getChildCount(); i++) {
387 TableRow row = (TableRow) table.getChildAt(i);
389 TextView acc_name_v = (TextView) row.getChildAt(0);
390 TextView amount_v = (TextView) row.getChildAt(1);
391 String amt = String.valueOf(amount_v.getText());
392 String acc_name = String.valueOf(acc_name_v.getText());
393 acc_name = acc_name.trim();
395 if (!acc_name.isEmpty()) {
398 if (!amt.isEmpty()) {
399 accounts_with_values++;
405 amount_v.setHint(String.format("%1.2f", 0f));
406 if (empty_amount == null) {
407 empty_amount = amount_v;
408 single_empty_amount = true;
409 single_empty_amount_has_account = !acc_name.isEmpty();
411 else if (!acc_name.isEmpty()) single_empty_amount = false;
415 if (!acc_name.isEmpty()) amounts_with_accounts++;
416 running_total += Float.valueOf(amt);
420 if ((empty_rows == 0) && ((table.getChildCount() == accounts) || (table.getChildCount()
423 do_add_account_row(false);
426 Log.d("submittable", String.format("accounts=%d, accounts_with_values=%s, "
427 + "amounts_with_accounts=%d, amounts=%d, running_total=%1.2f, "
428 + "single_empty_with_acc=%s", accounts, accounts_with_values,
429 amounts_with_accounts, amounts, running_total,
430 (single_empty_amount && single_empty_amount_has_account) ? "true" : "false"));
432 if (have_description && (accounts >= 2) && (accounts_with_values >= (accounts - 1)) && (
433 amounts_with_accounts == amounts) && (
434 single_empty_amount && single_empty_amount_has_account || is_zero(
437 if (mSave != null) mSave.setVisible(true);
439 else if (mSave != null) mSave.setVisible(false);
441 if (single_empty_amount) {
443 .setHint(String.format("%1.2f", (running_total > 0) ? -running_total : 0f));
447 catch (NumberFormatException e) {
448 if (mSave != null) mSave.setVisible(false);
450 catch (Exception e) {
452 if (mSave != null) mSave.setVisible(false);
458 void done(String error) {
459 progress.setVisibility(View.INVISIBLE);
460 Log.d("visuals", "hiding progress");
462 if (error == null) reset_form();
463 else Snackbar.make(findViewById(R.id.new_transaction_accounts_table), error,
464 BaseTransientBottomBar.LENGTH_LONG).show();
466 toggle_all_editing(true);
467 check_transaction_submittable();
470 private void reset_form() {
471 text_date.setText("");
472 text_descr.setText("");
474 text_descr.requestFocus();
476 while(table.getChildCount() > 2) {
477 table.removeViewAt(2);
479 for( int i = 0; i < 2; i++ ) {
480 TableRow tr = (TableRow) table.getChildAt(i);
481 if ( tr == null) break;
483 ((TextView)tr.getChildAt(0)).setText("");
484 ((TextView)tr.getChildAt(1)).setText("");