flow/treasuredb
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
57 Commits 1 Branch 0 Tags 219 KiB
master
Commit Graph

57 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
Florian "flowdy" Heß
6391b0498c Various fixes and UX optimizations in trsr 2017-03-05 14:09:58 +01:00
Florian "flowdy" Heß
5299966837 Changed FAIL -> ABORT trigger exceptions 
With FAIL, triggers choke but leave the changes in despite. We need to have the current statement undone, however.
 2017-02-22 21:58:47 +01:00
Florian "flowdy" Heß
f54f940f74 "all" and "each" transaction mode distinction; added missing batch_processor view 2017-02-21 22:29:13 +01:00
Florian "flowdy" Heß
df9c0b4065 Fixed trigger sequence 2017-02-21 22:24:27 +01:00
Florian "flowdy" Heß
7faa3a9515 Fixed multi-line purpose input for ./trsr charge 2017-02-18 12:51:28 +01:00
Florian "flowdy" Heß
db85a31aef Updated README.md 2017-02-17 19:16:40 +01:00
Florian "flowdy" Heß
f5cde1c585 Batch processor (.trsr charge) now also accessible via web interface 
Plus, added `./trsr server` and `./trsr sql` calls. These are essentially execs of
morbo and sqlite3 with appropriate arguments.
 2017-02-17 17:09:59 +01:00
Florian "flowdy" Heß
a686011cf4 Added trsr script 2017-02-11 06:33:15 +01:00
Florian "flowdy" Heß
149e0dbda2 Restrict account labels so we can use it for css classes 2017-02-11 06:32:31 +01:00
Florian "flowdy" Heß
e758a4c8d6 Fixed test in t/02_http+scripts.t 2017-02-11 06:29:45 +01:00
Florian "flowdy" Heß
1a05fd4d54 Fixes to avoid a warning when IBAN is null, in look and redirection 2017-02-06 08:12:56 +01:00
Florian "flowdy" Heß
bb05b06cf3 Test suite starts covering HTTP interface. 
+ Added some files missing in previous commits.
 2017-02-06 08:10:05 +01:00
Florian "flowdy" Heß
8b1a68f07b Various fixes; added full name to account data; do never transfer unchecked 2017-02-03 16:49:43 +01:00
Florian "flowdy" Heß
ba30ec40a2 Fixes and more attractive form style 2017-02-01 21:34:01 +01:00
Florian "flowdy" Heß
6c43accd5f Fixed Transfer note handling in debit and credit upsert forms. 
Plus, explanation in the case that debit is settled / credit is spent so that checking further items is pointless.
 2017-01-31 22:18:16 +01:00
Florian "flowdy" Heß
e91405b041 Reformed history items: Hide target credit purpose as it is insignificant 2017-01-31 22:14:32 +01:00
Florian "flowdy" Heß
d7db9a2eb1 Added categories and Filter widget 2017-01-29 16:08:28 +01:00
Florian "flowdy" Heß
6f19437901 Optimized look and user experience; fixed errors 2017-01-28 14:00:20 +01:00
Florian "flowdy" Heß
5aaff598d1 Changes and fixes in HTTP (e.g. + account upsertion) 
====================================================
  * Account upsertion
  * Empty credit and debit forms, the latter with the ability to charge groups
  * Fixed redirection on posting transfers
  * Reverse order of credits and debits
  * Style: prevent monospace size reduction in some browsers; td.mark class
  * Totals in report and and bankStatement
 2017-01-25 22:38:39 +01:00
Florian "flowdy" Heß
d89ad8c580 Fixed calculation of Balance.even_until 2017-01-25 22:35:15 +01:00
Florian "flowdy" Heß
abad5dc069 __INTERNAL_TRIGGER_STACK with id as primary key (alias to SQL rowid) 2017-01-23 19:08:04 +01:00
Florian "flowdy" Heß
031c248b74 rebalanceIncreasedCredit: set billId and credId in __INTERNAL_TRIGGER_STACK row 2017-01-23 19:08:04 +01:00
Florian "flowdy" Heß
84d913836e Reworked balancing and rebalancing 2017-01-23 19:08:04 +01:00
Florian "flowdy" Heß
336185aee1 Refactorization and splitting of schema files 2017-01-23 19:08:04 +01:00
Florian "flowdy" Heß
53ef8ff175 Various fixes and completing the HTTP interface 2017-01-15 22:03:06 +01:00
Florian "flowdy" Heß
f4bcbcad6f Added rudimentary HTTP interface 2017-01-15 16:27:22 +01:00
Florian "flowdy" Heß
6d31efee39 In schema.sql renamed table _temp to __DO_NOT_MANIPULATE_trigger_memory 
This way, you have been warned: Once you fiddle with this internal database logic, you are on your own.
 2017-01-14 10:31:55 +01:00
Florian "flowdy" Heß
3773c3f123 Various changes and fixes: Added report, etc. Tests pass. 
* reworked and used TrsrDB::expand_ids more tightly
  * account item selection in TrsrDB::make_transfers
  * web_auth / User relation for coming HTTP interface
  * income and target inter-relations between TrsrDB::Credit and TrsrDB::Debit
  * Transfer note
  * reactivated enforceFixedCredit to take effect unless _temp table is empty
  * added CreditsInFocus and Report views
 2017-01-14 09:50:16 +01:00
Florian "flowdy" Heß
440453e4e6 Drop unused variables in pseudonymizr.pl 2016-09-03 15:40:35 +02:00
Florian "flowdy" Heß
15f9ed2a98 Fixed a thinko in pseudonymizr.pl that disabled reuse of a registry file. 2016-09-03 15:25:39 +02:00
Florian "flowdy" Heß
dc4a890a00 Fixed thinko in pseudonymizr.sh 2016-09-03 14:43:11 +02:00
Florian "flowdy" Heß
0fbb5a9e12 Added pseudonymizr.sh so that real financial transfer data can be disclosed pseudonymized, 
in accordance with privacy laws, for a non-member of board or even the club to test treasuredb.
 2016-09-03 14:31:10 +02:00
Florian "flowdy" Heß
8459e9ae48 Fixes and tests for indirect transfers. Extended balance. 
TrsrDB:
    fixed Id -> credId
    autobalance -> make_transfers

TrsrDB::Account:
    added history accessor
TrsrDB::Balance:
    added fieds earned spent and even_until, renamed credit to available
TrsrDB::CurrentArrears:
    fixed account -> debtor in relation declaration
schema.sql:
    fixed triggers
    deactivated trigger enforceFixedCredit
    extended Balance with some more fields
t/schema.{sql,out}
    trivial fixes
t/schema.t added tests:
    Get balances after transfers
    partial use of credit,
    indirect transfers
 2016-07-06 22:53:31 +02:00
Florian "flowdy" Heß
bc37ee316b Refactored and united raw and ORM api tests 2016-07-04 20:21:47 +02:00
Florian "flowdy" Heß
3985b46224 Added TrsrDB::autobalance(). Renamings and fixes. 
Renamed "debts" to "arrears", because of psychologically slightly more positive
connotations. Renamed field "Id" of table Credit to "credId" in analogy to
field "billId" of table Debit.
 2016-07-03 22:26:58 +02:00
Florian "flowdy" Heß
57556d252b added ORM api and some tests 2016-07-03 22:15:32 +02:00
Florian "flowdy" Heß
dbbada8307 Adapted line numbers in t/schema.out 2016-06-26 21:31:06 +02:00
Florian "flowdy" Heß
87ba0eb6f7 Fixed rebalanceIncreasedCredit, i.e. a regression. 2016-06-26 21:29:16 +02:00
Florian "flowdy" Heß
99832d0e10 activate recursive triggers in test sql 2016-06-26 21:29:16 +02:00
Florian "flowdy" Heß
1cd71974c4 fixes after testing. Tests still fail. 2016-06-26 21:29:16 +02:00
Florian "flowdy" Heß
769dcebc92 added recursing triggers to enable indirect payments and revocations. 2016-06-26 21:29:16 +02:00
Florian "flowdy" Heß
d915d32e3b Added check so that debits cannot be linked with an incoming payment as target 2016-06-26 21:27:39 +02:00
Florian "flowdy" Heß
acad2118c5 added History view 2016-06-26 15:27:50 +02:00
Florian "flowdy" Heß
3a5d70d889 Fixed return value evaluation in test.sh 2016-06-25 19:18:31 +02:00
Florian "flowdy" Heß
2639700adb Fixed line numbers in t/schema.out 2016-06-25 19:17:58 +02:00
Florian "flowdy" Heß
b8a8d9c935 Some rewording and language fixes in schema.sql 2016-06-05 20:00:30 +02:00
Florian "flowdy" Heß
3c483d60e6 brought README.md in sync with recent changes, 2nd 2016-06-05 17:08:33 +02:00
Florian "flowdy" Heß
b3053b6f57 brought README.md in sync with recent changes 2016-06-05 17:05:54 +02:00
Florian "flowdy" Heß
36f8c2315f added view "ReconstructedBankStatement" to compare with the actual statement from the club's bank 2016-06-05 16:18:49 +02:00
Florian "flowdy" Heß
f2f1bdf036 rewording in schema.sh; move test scripts to t/; add executable test.sh 2016-06-05 12:41:48 +02:00