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

57 Commits

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