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=038515bfb02e4ec32e01293476c179c878276f22;hp=af78c59da480daad091a1c2a91034b7e6594d20f;hb=94aa0aa57db3dce40f31fc0321c718998d9cb48b;hpb=5c73162fd331c1401bb105e56d600c0be84fc715

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 af78c59d..038515bf 100644
--- a/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java
+++ b/app/src/main/java/net/ktnx/mobileledger/model/MobileLedgerProfile.java
@@ -19,28 +19,39 @@ package net.ktnx.mobileledger.model;
 
 import android.database.Cursor;
 import android.database.sqlite.SQLiteDatabase;
+import android.util.Log;
 
 import net.ktnx.mobileledger.utils.MLDB;
 
 import java.util.ArrayList;
 import java.util.List;
+import java.util.UUID;
 
 public final class MobileLedgerProfile {
     private String uuid;
     private String name;
     private String url;
-    private boolean useAuthentication;
+    private boolean authEnabled;
     private String authUserName;
     private String authPassword;
-    public MobileLedgerProfile(String uuid, String name, String url, boolean useAuthentication,
+    public MobileLedgerProfile(String uuid, String name, String url, boolean authEnabled,
                                String authUserName, String authPassword) {
         this.uuid = uuid;
         this.name = name;
         this.url = url;
-        this.useAuthentication = useAuthentication;
+        this.authEnabled = authEnabled;
         this.authUserName = authUserName;
         this.authPassword = authPassword;
     }
+    public MobileLedgerProfile(CharSequence name, CharSequence url, boolean authEnabled,
+                               CharSequence authUserName, CharSequence authPassword) {
+        this.uuid = String.valueOf(UUID.randomUUID());
+        this.name = String.valueOf(name);
+        this.url = String.valueOf(url);
+        this.authEnabled = authEnabled;
+        this.authUserName = String.valueOf(authUserName);
+        this.authPassword = String.valueOf(authPassword);
+    }
     public static List<MobileLedgerProfile> loadAllFromDB() {
         List<MobileLedgerProfile> result = new ArrayList<>();
         SQLiteDatabase db = MLDB.getReadableDatabase();
@@ -48,13 +59,21 @@ public final class MobileLedgerProfile {
                                          "auth_password FROM profiles", null))
         {
             while (cursor.moveToNext()) {
-                result.add(new MobileLedgerProfile(cursor.getString(0), cursor.getString(1),
-                        cursor.getString(2), cursor.getInt(3) == 1, cursor.getString(4),
+                result.add(new MobileLedgerProfile(cursor.getString(0), cursor.getString(1), cursor.getString(2), cursor.getInt(3) == 1, cursor.getString(4),
                         cursor.getString(5)));
             }
         }
         return result;
     }
+    public static List<MobileLedgerProfile> createInitialProfileList() {
+        List<MobileLedgerProfile> result = new ArrayList<>();
+        MobileLedgerProfile first =
+                new MobileLedgerProfile(UUID.randomUUID().toString(), "default", "", false, "", "");
+        first.storeInDB();
+        result.add(first);
+
+        return result;
+    }
     public static MobileLedgerProfile loadUUIDFromDB(String profileUUID) {
         SQLiteDatabase db = MLDB.getReadableDatabase();
         String name;
@@ -90,27 +109,53 @@ public final class MobileLedgerProfile {
     public String getName() {
         return name;
     }
+    public void setName(CharSequence text) {
+        setName(String.valueOf(text));
+    }
+    public void setName(String name) {
+        this.name = name;
+    }
     public String getUrl() {
         return url;
     }
-    public boolean isUseAuthentication() {
-        return useAuthentication;
+    public void setUrl(CharSequence text) {
+        setUrl(String.valueOf(text));
+    }
+    public void setUrl(String url) {
+        this.url = url;
+    }
+    public boolean isAuthEnabled() {
+        return authEnabled;
+    }
+    public void setAuthEnabled(boolean authEnabled) {
+        this.authEnabled = authEnabled;
     }
     public String getAuthUserName() {
         return authUserName;
     }
+    public void setAuthUserName(CharSequence text) {
+        setAuthUserName(String.valueOf(text));
+    }
+    public void setAuthUserName(String authUserName) {
+        this.authUserName = authUserName;
+    }
     public String getAuthPassword() {
         return authPassword;
     }
+    public void setAuthPassword(CharSequence text) {
+        setAuthPassword(String.valueOf(text));
+    }
+    public void setAuthPassword(String authPassword) {
+        this.authPassword = authPassword;
+    }
     public void storeInDB() {
         SQLiteDatabase db = MLDB.getWritableDatabase();
         db.beginTransaction();
         try {
             db.execSQL("REPLACE INTO profiles(uuid, name, url, use_authentication, auth_user, " +
                        "auth_password) VALUES(?, ?, ?, ?, ?, ?)",
-                    new Object[]{uuid, name, url, useAuthentication,
-                                 useAuthentication ? authUserName : null,
-                                 useAuthentication ? authPassword : null
+                    new Object[]{uuid, name, url, authEnabled, authEnabled ? authUserName : null,
+                                 authEnabled ? authPassword : null
                     });
             db.setTransactionSuccessful();
         }
@@ -118,4 +163,100 @@ public final class MobileLedgerProfile {
             db.endTransaction();
         }
     }
+    public void storeAccount(String name) {
+        SQLiteDatabase db = MLDB.getWritableDatabase();
+
+        do {
+            LedgerAccount acc = new LedgerAccount(name);
+            db.execSQL("replace into accounts(profile, name, name_upper, level, keep) values(?, " +
+                       "?, ?, ?, 1)",
+                    new Object[]{this.uuid, name, name.toUpperCase(), acc.getLevel()});
+            name = acc.getParentName();
+        } while (name != null);
+    }
+    public void storeAccountValue(String name, String currency, Float amount) {
+        SQLiteDatabase db = MLDB.getWritableDatabase();
+        db.execSQL("replace into account_values(profile, account, " +
+                   "currency, value, keep) values(?, ?, ?, ?, 1);",
+                new Object[]{uuid, name, currency, amount});
+    }
+    public void storeTransaction(LedgerTransaction tr) {
+        SQLiteDatabase db = MLDB.getWritableDatabase();
+        tr.fillDataHash();
+        db.execSQL("DELETE from transactions WHERE profile=? and id=?",
+                new Object[]{uuid, tr.getId()});
+        db.execSQL("DELETE from transaction_accounts WHERE profile = ? and transaction_id=?",
+                new Object[]{uuid, tr.getId()});
+
+        db.execSQL("INSERT INTO transactions(profile, id, date, description, data_hash, keep) " +
+                   "values(?,?,?,?,?,1)",
+                new Object[]{uuid, tr.getId(), tr.getDate(), tr.getDescription(), tr.getDataHash()
+                });
+
+        for (LedgerTransactionAccount item : tr.getAccounts()) {
+            db.execSQL("INSERT INTO transaction_accounts(profile, transaction_id, " +
+                       "account_name, amount, currency) values(?, ?, ?, ?, ?)",
+                    new Object[]{uuid, tr.getId(), item.getAccountName(), item.getAmount(),
+                                 item.getCurrency()
+                    });
+        }
+        Log.d("profile", String.format("Transaction %d stored", tr.getId()));
+    }
+    public String get_option_value(String name, String default_value) {
+        SQLiteDatabase db = MLDB.getReadableDatabase();
+        try (Cursor cursor = db.rawQuery("select value from options where profile = ? and name=?",
+                new String[]{uuid, name}))
+        {
+            if (cursor.moveToFirst()) {
+                String result = cursor.getString(0);
+
+                if (result == null) {
+                    Log.d("profile", "returning default value for " + name);
+                    result = default_value;
+                }
+                else Log.d("profile", String.format("option %s=%s", name, result));
+
+                return result;
+            }
+            else return default_value;
+        }
+        catch (Exception e) {
+            Log.d("db", "returning default value for " + name, e);
+            return default_value;
+        }
+    }
+    public long get_option_value(String name, long default_value) {
+        long longResult;
+        String result = get_option_value(name, "");
+        if ((result == null) || result.isEmpty()) {
+            Log.d("profile", String.format("Returning default value for option %s", name));
+            longResult = default_value;
+        }
+        else {
+            try {
+                longResult = Long.parseLong(result);
+                Log.d("profile", String.format("option %s=%s", name, result));
+            }
+            catch (Exception e) {
+                Log.d("profile", String.format("Returning default value for option %s", name), e);
+                longResult = default_value;
+            }
+        }
+
+        return longResult;
+    }
+    public void set_option_value(String name, String value) {
+        Log.d("profile", String.format("setting option %s=%s", name, value));
+        SQLiteDatabase db = MLDB.getWritableDatabase();
+        db.execSQL("insert or replace into options(profile, name, value) values(?, ?, ?);",
+                new String[]{uuid, name, value});
+    }
+    public void set_option_value(String name, long value) {
+        set_option_value(name, String.valueOf(value));
+    }
+    public void removeFromDB() {
+        SQLiteDatabase db = MLDB.getWritableDatabase();
+        Log.d("db", String.format("removinf progile %s from DB", uuid));
+        db.execSQL("delete from profiles where uuid=?", new Object[]{uuid});
+    }
 }