+ try (Cursor cursor = db.rawQuery("SELECT name FROM accounts ORDER BY name;", null)) {
+ boolean even = false;
+ while (cursor.moveToNext()) {
+ String acc_name = cursor.getString(0);
+
+ LinearLayout r = new LinearLayout(this);
+ r.setLayoutParams(new LinearLayout.LayoutParams(ViewGroup.LayoutParams.MATCH_PARENT, ViewGroup.LayoutParams.WRAP_CONTENT));
+ r.setGravity(Gravity.CENTER_VERTICAL);
+ r.setPadding(getResources().getDimensionPixelSize(R.dimen.activity_horizontal_margin), dp2px(3), getResources().getDimensionPixelSize(R.dimen.activity_horizontal_margin), dp2px(4));
+ if (even)
+ r.setBackgroundColor(getResources().getColor(R.color.table_row_even_bg, getTheme()));
+ even = !even;
+ r.setContextClickable(true);
+ r.setOnCreateContextMenuListener(ccml);
+
+
+ TextView acc_tv = new TextView(this, null, R.style.account_summary_account_name);
+ acc_tv.setLayoutParams(new LinearLayout.LayoutParams(ViewGroup.LayoutParams.WRAP_CONTENT, ViewGroup.LayoutParams.MATCH_PARENT, 5f));
+ acc_tv.setGravity(Gravity.CENTER_VERTICAL);
+ int[] indent_level = new int[]{0};
+ String short_acc_name = strip_higher_accounts(acc_name, indent_level);
+ acc_tv.setPadding(indent_level[0] * getResources().getDimensionPixelSize(R.dimen.activity_horizontal_margin) / 2, 0, 0, 0);
+ acc_tv.setText(short_acc_name);
+ r.addView(acc_tv);
+
+ TextView amt_tv = new TextView(this, null, R.style.account_summary_amounts);
+ amt_tv.setLayoutParams(new LinearLayout.LayoutParams(ViewGroup.LayoutParams.WRAP_CONTENT, ViewGroup.LayoutParams.MATCH_PARENT, 1f));
+ amt_tv.setTextAlignment(EditText.TEXT_ALIGNMENT_VIEW_END);
+ amt_tv.setGravity(Gravity.CENTER_VERTICAL);
+// amt_tv.setGravity(Gravity.CENTER);
+ amt_tv.setMinWidth(dp2px(60f));
+ StringBuilder amt_text = new StringBuilder();
+ try (Cursor cAmounts = db.rawQuery("SELECT currency, value FROM account_values WHERE account = ?", new String[]{acc_name})) {
+ while (cAmounts.moveToNext()) {
+ String curr = cAmounts.getString(0);
+ Float amt = cAmounts.getFloat(1);
+ if (amt_text.length() != 0) amt_text.append('\n');
+ amt_text.append(String.format("%s %1.2f", curr, amt));
+ }
+ }
+ amt_tv.setText(amt_text.toString());
+
+ r.addView(amt_tv);
+
+ root.addView(r);
+ }
+ }