X-Git-Url: https://git.ktnx.net/?a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fjava%2Fnet%2Fktnx%2Fmobileledger%2Fmodel%2FLedgerTransaction.java;h=2eba45e9cd4ea1e58d243b794c59d3547b2aaa81;hb=93545c6fbf1244fbd96ecfc50e1115dbdc25f9ae;hp=a103ab3951d92c0ef643f81dbaf15f45c52c1a1c;hpb=6b740c280c79b0170321f533747cdbfc3e179a29;p=mobile-ledger.git diff --git a/app/src/main/java/net/ktnx/mobileledger/model/LedgerTransaction.java b/app/src/main/java/net/ktnx/mobileledger/model/LedgerTransaction.java index a103ab39..2eba45e9 100644 --- a/app/src/main/java/net/ktnx/mobileledger/model/LedgerTransaction.java +++ b/app/src/main/java/net/ktnx/mobileledger/model/LedgerTransaction.java @@ -1,89 +1,234 @@ /* - * Copyright © 2018 Damyan Ivanov. - * This file is part of Mobile-Ledger. - * Mobile-Ledger is free software: you can distribute it and/or modify it + * Copyright © 2021 Damyan Ivanov. + * This file is part of MoLe. + * MoLe is free software: you can distribute it and/or modify it * under the term of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your opinion), any later version. * - * Mobile-Ledger is distributed in the hope that it will be useful, + * MoLe is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License terms for details. * * You should have received a copy of the GNU General Public License - * along with Mobile-Ledger. If not, see . + * along with MoLe. If not, see . */ package net.ktnx.mobileledger.model; +import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; +import androidx.annotation.NonNull; +import androidx.annotation.Nullable; + +import net.ktnx.mobileledger.App; +import net.ktnx.mobileledger.utils.Digest; +import net.ktnx.mobileledger.utils.Globals; +import net.ktnx.mobileledger.utils.SimpleDate; + +import java.nio.charset.StandardCharsets; +import java.security.NoSuchAlgorithmException; +import java.text.ParseException; import java.util.ArrayList; -import java.util.Iterator; +import java.util.Comparator; import java.util.List; public class LedgerTransaction { - private String id; - private String date; + private static final String DIGEST_TYPE = "SHA-256"; + public final Comparator comparator = (o1, o2) -> { + int res = o1.getAccountName() + .compareTo(o2.getAccountName()); + if (res != 0) + return res; + res = o1.getCurrency() + .compareTo(o2.getCurrency()); + if (res != 0) + return res; + res = o1.getComment() + .compareTo(o2.getComment()); + if (res != 0) + return res; + return Float.compare(o1.getAmount(), o2.getAmount()); + }; + private final long profile; + private final Integer id; + private final List accounts; + private SimpleDate date; private String description; - private List items; - - public LedgerTransaction(String id, String date, String description) { + private String comment; + private String dataHash; + private boolean dataLoaded; + public LedgerTransaction(Integer id, String dateString, String description) + throws ParseException { + this(id, Globals.parseLedgerDate(dateString), description); + } + public LedgerTransaction(Integer id, SimpleDate date, String description, + MobileLedgerProfile profile) { + this.profile = profile.getId(); this.id = id; this.date = date; this.description = description; - this.items = new ArrayList<>(); + this.accounts = new ArrayList<>(); + this.dataHash = null; + dataLoaded = false; + } + public LedgerTransaction(Integer id, SimpleDate date, String description) { + this(id, date, description, Data.getProfile()); } - public LedgerTransaction(String date, String description) { + public LedgerTransaction(SimpleDate date, String description) { this(null, date, description); } - public void add_item(LedgerTransactionItem item) { - items.add(item); + public LedgerTransaction(int id) { + this(id, (SimpleDate) null, null); } - - public String getDate() { + public LedgerTransaction(int id, long profileId) { + this.profile = profileId; + this.id = id; + this.date = null; + this.description = null; + this.accounts = new ArrayList<>(); + this.dataHash = null; + this.dataLoaded = false; + } + public List getAccounts() { + return accounts; + } + public void addAccount(LedgerTransactionAccount item) { + accounts.add(item); + dataHash = null; + } + @Nullable + public SimpleDate getDateIfAny() { return date; } - - public void setDate(String date) { + @NonNull + public SimpleDate getDate() { + if (date == null) + throw new IllegalStateException("Transaction has no date"); + return date; + } + public void setDate(SimpleDate date) { this.date = date; + dataHash = null; } - public String getDescription() { return description; } - public void setDescription(String description) { this.description = description; + dataHash = null; } - - public Iterator getItemsIterator() { - return new Iterator() { - private int pointer = 0; - @Override - public boolean hasNext() { - return pointer < items.size(); + public String getComment() { + return comment; + } + public void setComment(String comment) { + this.comment = comment; + } + public int getId() { + return id; + } + protected void fillDataHash() { + loadData(App.getDatabase()); + if (dataHash != null) + return; + try { + Digest sha = new Digest(DIGEST_TYPE); + StringBuilder data = new StringBuilder(); + data.append("ver1"); + data.append(profile); + data.append(getId()); + data.append('\0'); + data.append(getDescription()); + data.append('\0'); + data.append(getComment()); + data.append('\0'); + data.append(Globals.formatLedgerDate(getDate())); + data.append('\0'); + for (LedgerTransactionAccount item : accounts) { + data.append(item.getAccountName()); + data.append('\0'); + data.append(item.getCurrency()); + data.append('\0'); + data.append(item.getAmount()); + data.append('\0'); + data.append(item.getComment()); } + sha.update(data.toString() + .getBytes(StandardCharsets.UTF_8)); + dataHash = sha.digestToHexString(); + } + catch (NoSuchAlgorithmException e) { + throw new RuntimeException( + String.format("Unable to get instance of %s digest", DIGEST_TYPE), e); + } + } + public synchronized void loadData(SQLiteDatabase db) { + if (dataLoaded) + return; + + try (Cursor cTr = db.rawQuery( + "SELECT year, month, day, description, comment from transactions WHERE profile=? " + + "AND id=?", new String[]{String.valueOf(profile), String.valueOf(id)})) + { + if (cTr.moveToFirst()) { + date = new SimpleDate(cTr.getInt(0), cTr.getInt(1), cTr.getInt(2)); + description = cTr.getString(3); + comment = cTr.getString(4); + + accounts.clear(); - @Override - public LedgerTransactionItem next() { - return hasNext() ? items.get(pointer++) : null; + try (Cursor cAcc = db.rawQuery( + "SELECT account_name, amount, currency, comment FROM " + + "transaction_accounts WHERE profile=? AND transaction_id = ?", + new String[]{String.valueOf(profile), String.valueOf(id)})) + { + while (cAcc.moveToNext()) { +// debug("transactions", +// String.format("Loaded %d: %s %1.2f %s", id, cAcc.getString(0), +// cAcc.getFloat(1), cAcc.getString(2))); + addAccount(new LedgerTransactionAccount(cAcc.getString(0), cAcc.getFloat(1), + cAcc.getString(2), cAcc.getString(3))); + } + + finishLoading(); + } } - }; + } + } - public String getId() { - return id; + public String getDataHash() { + fillDataHash(); + return dataHash; } + public void finishLoading() { + dataLoaded = true; + } + @Override + public boolean equals(@Nullable Object obj) { + if (obj == null) + return false; + if (!obj.getClass() + .equals(this.getClass())) + return false; - public void insertInto(SQLiteDatabase db) { - db.execSQL("INSERT INTO transactions(id, date, " + "description) values(?, ?, ?)", - new String[]{id, date, description}); + return ((LedgerTransaction) obj).getDataHash() + .equals(getDataHash()); + } - for(LedgerTransactionItem item : items) { - db.execSQL("INSERT INTO transaction_accounts(transaction_id, account_name, amount, " - + "currency) values(?, ?, ?, ?)", new Object[]{id, item.getAccountName(), - item.getAmount(), item.getCurrency()}); + public boolean hasAccountNamedLike(String name) { + name = name.toUpperCase(); + for (LedgerTransactionAccount acc : accounts) { + if (acc.getAccountName() + .toUpperCase() + .contains(name)) + return true; } + + return false; + } + public void markDataAsLoaded() { + dataLoaded = true; } }