diff options
author | Sebastian Reichel <sre@ring0.de> | 2015-04-07 04:06:56 +0200 |
---|---|---|
committer | Sebastian Reichel <sre@ring0.de> | 2015-04-07 04:06:56 +0200 |
commit | 25298f913cb3c33ed0702166927a1a3c25f53900 (patch) | |
tree | 9e59baddecf55461a5571831f9773cdb77b8bd61 /src/database/database.vala | |
parent | 20afb9ff0575eeb84bb6b00b0d9dfcab001c3127 (diff) | |
download | serial-barcode-scanner-25298f913cb3c33ed0702166927a1a3c25f53900.tar.bz2 |
cashbox: add page with details
Diffstat (limited to 'src/database/database.vala')
-rw-r--r-- | src/database/database.vala | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/src/database/database.vala b/src/database/database.vala index 012842b..f0b90c1 100644 --- a/src/database/database.vala +++ b/src/database/database.vala @@ -128,6 +128,7 @@ public class DataBase : Object { queries["cashbox_status"] = "SELECT amount FROM current_cashbox_status"; queries["cashbox_add"] = "INSERT INTO cashbox_diff ('user', 'amount', 'timestamp') VALUES (?, ?, ?)"; queries["cashbox_history"] = "SELECT user, amount, timestamp FROM cashbox_diff ORDER BY timestamp DESC LIMIT 10"; + queries["cashbox_changes"] = "SELECT user, amount, timestamp FROM cashbox_diff WHERE timestamp >= ? and timestamp < ? ORDER BY timestamp ASC"; /* compile queries into statements */ foreach(var entry in queries.entries) { @@ -948,4 +949,24 @@ public class DataBase : Object { return result; } + + public CashboxDiff[] cashbox_changes(int64 start, int64 stop) { + CashboxDiff[] result = {}; + + statements["cashbox_changes"].reset(); + statements["cashbox_changes"].bind_int64(1, start); + statements["cashbox_changes"].bind_int64(2, stop); + + while(statements["cashbox_changes"].step() == Sqlite.ROW) { + CashboxDiff entry = { + statements["cashbox_changes"].column_int(0), + statements["cashbox_changes"].column_int(1), + statements["cashbox_changes"].column_int64(2), + }; + + result += entry; + }; + + return result; + } } |