futureDates = origin.futureDates;
apiVersion = origin.apiVersion;
defaultCommodity = origin.defaultCommodity;
+ firstTransactionDate = origin.firstTransactionDate;
+ lastTransactionDate = origin.lastTransactionDate;
}
// loads all profiles into Data.profiles
// returns the profile with the given UUID
db.execSQL("DELETE from transaction_accounts WHERE profile = ? and transaction_id=?",
new Object[]{uuid, tr.getId()});
- db.execSQL(
- "INSERT INTO transactions(profile, id, year, month, day, description, "+
- "comment, data_hash, keep) " +
- "values(?,?,?,?,?,?,?,?,1)",
+ db.execSQL("INSERT INTO transactions(profile, id, year, month, day, description, " +
+ "comment, data_hash, keep) values(?,?,?,?,?,?,?,?,1)",
new Object[]{uuid, tr.getId(), tr.getDate().year, tr.getDate().month,
- tr.getDate().day, tr.getDescription(),
- tr.getComment(), tr.getDataHash()
+ tr.getDate().day, tr.getDescription(), tr.getComment(),
+ tr.getDataHash()
});
for (LedgerTransactionAccount item : tr.getAccounts()) {
try (Cursor cursor = db.rawQuery("SELECT a.expanded, (select 1 from accounts a2 " +
"where a2.profile = a.profile and a2.name like a" +
".name||':%' limit 1) " +
- "FROM accounts a WHERE a.profile = ? and a.name=?", new String[]{uuid, accName}))
+ "FROM accounts a WHERE a.profile = ? and a.name=?",
+ new String[]{uuid, accName}))
{
if (cursor.moveToFirst()) {
- LedgerAccount acc = new LedgerAccount(accName);
+ LedgerAccount acc = new LedgerAccount(this, accName);
acc.setExpanded(cursor.getInt(0) == 1);
acc.setHasSubAccounts(cursor.getInt(1) == 1);