update accounts table visual upon refreshilg the account data from the backend
[mobile-ledger.git] / app / src / main / java / net / ktnx / mobileledger / AccountSummary.java
1 package net.ktnx.mobileledger;
2
3 import android.annotation.SuppressLint;
4 import android.content.Intent;
5 import android.content.pm.PackageInfo;
6 import android.content.res.Resources;
7 import android.database.Cursor;
8 import android.os.Build;
9 import android.os.Bundle;
10 import android.preference.PreferenceManager;
11 import android.support.design.widget.Snackbar;
12 import android.support.v4.view.GravityCompat;
13 import android.support.v4.widget.DrawerLayout;
14 import android.support.v7.app.ActionBarDrawerToggle;
15 import android.support.v7.app.AppCompatActivity;
16 import android.support.v7.widget.Toolbar;
17 import android.util.Log;
18 import android.util.TypedValue;
19 import android.view.Menu;
20 import android.view.MenuItem;
21 import android.view.View;
22 import android.view.ViewGroup;
23 import android.widget.EditText;
24 import android.widget.LinearLayout;
25 import android.widget.ProgressBar;
26 import android.widget.TableLayout;
27 import android.widget.TableRow;
28 import android.widget.TextView;
29
30 import java.util.Date;
31
32 import static android.view.View.GONE;
33 import static net.ktnx.mobileledger.MobileLedgerDB.db;
34 import static net.ktnx.mobileledger.MobileLedgerDB.set_option_value;
35
36 public class AccountSummary extends AppCompatActivity {
37     DrawerLayout drawer;
38
39     private static long account_list_last_updated;
40     private static boolean account_list_needs_update = true;
41     public static void preferences_changed() {
42         account_list_needs_update = true;
43     }
44     MenuItem mRefresh;
45
46     @Override
47     protected void onCreate(Bundle savedInstanceState) {
48         super.onCreate(savedInstanceState);
49         setContentView(R.layout.activity_latest_transactions);
50         Toolbar toolbar = findViewById(R.id.toolbar);
51         setSupportActionBar(toolbar);
52
53         drawer = findViewById(R.id.drawer_layout);
54         ActionBarDrawerToggle toggle = new ActionBarDrawerToggle(
55                 this, drawer, toolbar, R.string.navigation_drawer_open, R.string.navigation_drawer_close);
56         drawer.addDrawerListener(toggle);
57         toggle.syncState();
58
59         android.widget.TextView ver = drawer.findViewById(R.id.drawer_version_text);
60
61         try {
62             PackageInfo pi = getApplicationContext().getPackageManager().getPackageInfo(getPackageName(), 0);
63             ver.setText(pi.versionName);
64         } catch (Exception e) {
65             e.printStackTrace();
66         }
67
68         prepare_db();
69         update_accounts(false);
70     }
71
72     public void fab_new_transaction_clicked(View view) {
73         Intent intent = new Intent(this, NewTransactionActivity.class);
74         startActivity(intent);
75     }
76
77     public void nav_exit_clicked(View view) {
78         Log.w("mobileledger", "exiting");
79         finish();
80     }
81
82     public void nav_settings_clicked(View view) {
83         Intent intent = new Intent(this, SettingsActivity.class);
84         startActivity(intent);
85     }
86
87     @Override
88     public void onBackPressed() {
89         DrawerLayout drawer = findViewById(R.id.drawer_layout);
90         if (drawer.isDrawerOpen(GravityCompat.START)) {
91             drawer.closeDrawer(GravityCompat.START);
92         } else {
93             super.onBackPressed();
94         }
95     }
96
97     @Override
98     public boolean onCreateOptionsMenu(Menu menu) {
99         // Inflate the menu; this adds items to the action bar if it is present.
100         getMenuInflater().inflate(R.menu.account_summary, menu);
101         mRefresh = menu.findItem(R.id.menu_acc_summary_refresh);
102         assert mRefresh != null;
103         return true;
104     }
105
106     @Override
107     public boolean onOptionsItemSelected(MenuItem item) {
108         // Handle action bar item clicks here. The action bar will
109         // automatically handle clicks on the Home/Up button, so long
110         // as you specify a parent activity in AndroidManifest.xml.
111         int id = item.getItemId();
112
113         //noinspection SimplifiableIfStatement
114         //if (id == R.id.action_settings) {
115         //    return true;
116         // }
117
118         return super.onOptionsItemSelected(item);
119     }
120
121     public void onRefreshAccountSummaryClicked(MenuItem mi) {
122         update_accounts(true);
123     }
124
125     private void prepare_db() {
126         if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.N) {
127             MobileLedgerDB.setDb_filename(this.getApplicationInfo().deviceProtectedDataDir + "/" + MobileLedgerDB.DATABASE_NAME);
128         }
129         else {
130             MobileLedgerDB.setDb_filename(MobileLedgerDB.DATABASE_NAME);
131         }
132         MobileLedgerDB.initDB();
133
134         MobileLedgerDB.applyRevisions(getResources(), getPackageName());
135
136         account_list_last_updated = MobileLedgerDB.get_option_value("last_refresh", (long) 0);
137
138     }
139
140     private void update_accounts(boolean force) {
141         long now = new Date().getTime();
142         if ((now > (account_list_last_updated + (24 * 3600*1000))) || force) {
143             Log.d("db", "accounts last updated at " + account_list_last_updated+" and now is " + now+". re-fetching");
144             update_accounts();
145         }
146     }
147
148     private void update_accounts() {
149         mRefresh.setVisible(false);
150         Resources rm = getResources();
151
152         ProgressBar pb = findViewById(R.id.progressBar);
153         pb.setVisibility(View.VISIBLE);
154         TextView pt = findViewById(R.id.textProgress);
155         pt.setVisibility(View.VISIBLE);
156         pb.setIndeterminate(true);
157
158         RetrieveAccountsTask task = new RetrieveAccountsTask() {
159             @Override
160             protected void onProgressUpdate(Integer... values) {
161                 if ( values[0] == 0 )
162                     pt.setText(R.string.progress_connecting);
163                 else
164                     pt.setText(String.format(getResources().getString(R.string.progress_N_accounts_loaded), values[0]));
165             }
166
167             @Override
168             protected void onPostExecute(Void result) {
169                 pb.setVisibility(GONE);
170                 pt.setVisibility(GONE);
171                 mRefresh.setVisible(true);
172                 if (this.error != 0) {
173                     String err_text = rm.getString(this.error);
174                     Log.d("visual", String.format("showing snackbar: %s", err_text));
175                     Snackbar.make(drawer, err_text, Snackbar.LENGTH_LONG ).show();
176                 }
177                 else {
178                     set_option_value("last_refresh", new Date().getTime() );
179                     update_account_table();
180                 }
181             }
182         };
183
184         task.setPref(PreferenceManager.getDefaultSharedPreferences(this));
185         task.execute();
186
187     }
188
189     public int dp2px(float dp) {
190         return Math.round(TypedValue.applyDimension(TypedValue.COMPLEX_UNIT_DIP, dp, getResources().getDisplayMetrics()));
191     }
192
193     @SuppressLint("DefaultLocale")
194     private void update_account_table() {
195         LinearLayout root = findViewById(R.id.account_root);
196         root.removeAllViewsInLayout();
197
198         try (Cursor cursor = db.rawQuery("SELECT name FROM accounts ORDER BY name;", null)) {
199             boolean even = false;
200             while (cursor.moveToNext()) {
201                 String acc_name = cursor.getString(0);
202
203                 TableLayout t = new TableLayout(this);
204                 TableRow r = new TableRow(this);
205                 r.setLayoutParams(new TableRow.LayoutParams(ViewGroup.LayoutParams.MATCH_PARENT, ViewGroup.LayoutParams.MATCH_PARENT));
206                 if (even)
207                     r.setBackgroundColor(getResources().getColor(R.color.table_row_even_bg, getTheme()));
208                 even = !even;
209
210                 TextView acc_tv = new TextView(this, null, R.style.account_summary_account_name);
211                 acc_tv.setLayoutParams(new TableRow.LayoutParams(ViewGroup.LayoutParams.MATCH_PARENT, ViewGroup.LayoutParams.WRAP_CONTENT, 9f));
212                 acc_tv.setText(acc_name);
213                 r.addView(acc_tv);
214
215                 TextView amt_tv = new TextView(this, null, R.style.account_summary_amounts);
216                 amt_tv.setLayoutParams(new TableRow.LayoutParams(ViewGroup.LayoutParams.MATCH_PARENT, ViewGroup.LayoutParams.WRAP_CONTENT, 1f));
217                 amt_tv.setTextAlignment(EditText.TEXT_ALIGNMENT_VIEW_END);
218                 amt_tv.setMinWidth(dp2px(40f));
219                 StringBuilder amt_text = new StringBuilder();
220                 try (Cursor cAmounts = db.rawQuery("SELECT currency, value FROM account_values WHERE account = ?", new String[]{acc_name})) {
221                     while (cAmounts.moveToNext()) {
222                         String curr = cAmounts.getString(0);
223                         Float amt = cAmounts.getFloat(1);
224                         if (amt_text.length() != 0) amt_text.append('\n');
225                         amt_text.append(String.format("%s %1.2f", curr, amt));
226                     }
227                 }
228                 amt_tv.setText(amt_text.toString());
229
230                 r.addView(amt_tv);
231
232                 t.addView(r);
233
234                 root.addView(t);
235             }
236         }
237     }
238 }