X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fjava%2Fnet%2Fktnx%2Fmobileledger%2Fmodel%2FMobileLedgerProfile.java;h=f69332ef2d6af9c8c0c18eaddcbb45a5eced14c4;hp=459c3b5c45ac1e0e32f69009243aa9d16f21ca06;hb=e9852f655ca908b8817de90a42ef1dda9a47285e;hpb=1bc494d701b5634b563f234f085a3b5c609ead60

diff --git a/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java b/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java
index 459c3b5c..f69332ef 100644
--- a/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java
+++ b/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java
@@ -38,6 +38,7 @@ public final class MobileLedgerProfile {
     private String uuid;
     private String name;
     private boolean permitPosting;
+    private String preferredAccountsFilter;
     private String url;
     private boolean authEnabled;
     private String authUserName;
@@ -57,7 +58,8 @@ public final class MobileLedgerProfile {
         List<MobileLedgerProfile> list = new ArrayList<>();
         SQLiteDatabase db = MLDB.getDatabase();
         try (Cursor cursor = db.rawQuery("SELECT uuid, name, url, use_authentication, auth_user, " +
-                                         "auth_password, permit_posting, theme, order_no FROM " +
+                                         "auth_password, permit_posting, theme, order_no, " +
+                                         "preferred_accounts_filter FROM " +
                                          "profiles order by order_no", null))
         {
             while (cursor.moveToNext()) {
@@ -70,6 +72,7 @@ public final class MobileLedgerProfile {
                 item.setPostingPermitted(cursor.getInt(6) == 1);
                 item.setThemeId(cursor.getInt(7));
                 item.orderNo = cursor.getInt(8);
+                item.setPreferredAccountsFilter(cursor.getString(9));
                 list.add(item);
                 if (item.getUuid().equals(currentProfileUUID)) result = item;
             }
@@ -97,6 +100,15 @@ public final class MobileLedgerProfile {
             db.endTransaction();
         }
     }
+    public String getPreferredAccountsFilter() {
+        return preferredAccountsFilter;
+    }
+    public void setPreferredAccountsFilter(String preferredAccountsFilter) {
+        this.preferredAccountsFilter = preferredAccountsFilter;
+    }
+    public void setPreferredAccountsFilter(CharSequence preferredAccountsFilter) {
+        setPreferredAccountsFilter(String.valueOf(preferredAccountsFilter));
+    }
     public boolean isPostingPermitted() {
         return permitPosting;
     }
@@ -158,10 +170,12 @@ public final class MobileLedgerProfile {
 //                    permitPosting ? "TRUE" : "FALSE", authEnabled ? "TRUE" : "FALSE", themeId));
             db.execSQL("REPLACE INTO profiles(uuid, name, permit_posting, url, " +
                        "use_authentication, auth_user, " +
-                       "auth_password, theme, order_no) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)",
+                       "auth_password, theme, order_no, preferred_accounts_filter) " +
+                       "VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
                     new Object[]{uuid, name, permitPosting, url, authEnabled,
                                  authEnabled ? authUserName : null,
-                                 authEnabled ? authPassword : null, themeId, orderNo
+                                 authEnabled ? authPassword : null, themeId, orderNo,
+                                 preferredAccountsFilter
                     });
             db.setTransactionSuccessful();
         }
@@ -268,11 +282,12 @@ public final class MobileLedgerProfile {
         Log.d("db", String.format("removing profile %s from DB", uuid));
         db.beginTransaction();
         try {
-            db.execSQL("delete from profiles where uuid=?", new Object[]{uuid});
-            db.execSQL("delete from accounts where profile=?", new Object[]{uuid});
-            db.execSQL("delete from account_values where profile=?", new Object[]{uuid});
-            db.execSQL("delete from transactions where profile=?", new Object[]{uuid});
-            db.execSQL("delete from transaction_accounts where profile=?", new Object[]{uuid});
+            Object[] uuid_param = new Object[]{uuid};
+            db.execSQL("delete from profiles where uuid=?", uuid_param);
+            db.execSQL("delete from accounts where profile=?", uuid_param);
+            db.execSQL("delete from account_values where profile=?", uuid_param);
+            db.execSQL("delete from transactions where profile=?", uuid_param);
+            db.execSQL("delete from transaction_accounts where profile=?", uuid_param);
             db.setTransactionSuccessful();
         }
         finally {
@@ -373,7 +388,7 @@ public final class MobileLedgerProfile {
         Log.d("db", "Updating transaction value stamp");
         Date now = new Date();
         setLongOption(MLDB.OPT_LAST_SCRAPE, now.getTime());
-        Data.lastUpdateDate.set(now);
+        Data.lastUpdateDate.postValue(now);
     }
     public List<LedgerAccount> loadChildAccountsOf(LedgerAccount acc) {
         List<LedgerAccount> result = new ArrayList<>();
@@ -411,4 +426,20 @@ public final class MobileLedgerProfile {
 
         return result;
     }
+    public void wipeAllData() {
+        SQLiteDatabase db = MLDB.getDatabase();
+        db.beginTransaction();
+        try {
+            String[] pUuid = new String[]{uuid};
+            db.execSQL("delete from options where profile=?", pUuid);
+            db.execSQL("delete from accounts where profile=?", pUuid);
+            db.execSQL("delete from account_values where profile=?", pUuid);
+            db.execSQL("delete from transactions where profile=?", pUuid);
+            db.execSQL("delete from transaction_accounts where profile=?", pUuid);
+            db.setTransactionSuccessful();
+        }
+        finally {
+            db.endTransaction();
+        }
+    }
 }