Financial transactions table #418
Description
Is your feature request related to a problem? Please describe.
Currently, user funds are stored as a float on the user record, and a Statistic is recorded whenever the amount is modified (thanks to #365). This is better than nothing, but in order to enable electronic payment methods, we need to store more information about individual transactions.
Describe the solution you'd like
A new table, transactions, which stores the amount (in cents, to avoid floating point errors), the payment provider (currently 'cash', but other providers added as new gateways created), and a status. This should include a notes field.
The Users object will need to be altered to return the sum of the transactions for that user when called for 'funds', accounting for the factor of 100 difference in the amount.
Describe alternatives you've considered
Continuing to use the Statistics table to record these details seems like a cludge, and mixes the data with lots of other contexts.