diff options
author | Sebastian Reichel <sre@ring0.de> | 2013-05-24 00:12:42 +0200 |
---|---|---|
committer | Sebastian Reichel <sre@ring0.de> | 2013-05-24 00:12:42 +0200 |
commit | 591b7537a26b79389eb2295b2c0afc8b4c35df67 (patch) | |
tree | 641af6c7d554b4f431dc6c003344c13a0e3b021c /src/database/database.vala | |
parent | 1105c32181ebaed1aebad6b44624227e9c83e9ee (diff) | |
download | serial-barcode-scanner-591b7537a26b79389eb2295b2c0afc8b4c35df67.tar.bz2 |
add minimal support for deprecation flag
Diffstat (limited to 'src/database/database.vala')
-rw-r--r-- | src/database/database.vala | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/database/database.vala b/src/database/database.vala index b9db150..05c789d 100644 --- a/src/database/database.vala +++ b/src/database/database.vala @@ -95,7 +95,7 @@ public class DataBase : Object { queries["restocks"] = "SELECT timestamp, amount, price, supplier, best_before_date FROM restock WHERE product = ? ORDER BY timestamp ASC;"; queries["profit_complex"] = "SELECT SUM(memberprice - (SELECT price FROM purchaseprices WHERE product = purch.product)) FROM sales purch, prices WHERE purch.product = prices.product AND purch.user > 0 AND purch.timestamp > ? AND purch.timestamp < ? AND prices.valid_from = (SELECT valid_from FROM prices WHERE product = purch.product AND valid_from < purch.timestamp ORDER BY valid_from DESC LIMIT 1);"; queries["sales_complex"] = "SELECT SUM(memberprice) FROM sales purch, prices WHERE purch.product = prices.product AND purch.user > 0 AND purch.timestamp > ? AND purch.timestamp < ? AND prices.valid_from = (SELECT valid_from FROM prices WHERE product = purch.product AND valid_from < purch.timestamp ORDER BY valid_from DESC LIMIT 1);"; - queries["stock_status"] = "SELECT id, name, amount, memberprice, guestprice FROM products, prices WHERE products.id = prices.product AND prices.valid_from = (SELECT valid_from FROM prices WHERE product = products.id ORDER BY valid_from DESC LIMIT 1) ORDER BY name"; + queries["stock_status"] = "SELECT id, name, amount, memberprice, guestprice FROM stock, prices WHERE stock.id = prices.product AND prices.valid_from = (SELECT valid_from FROM prices WHERE product = stock.id ORDER BY valid_from DESC LIMIT 1) ORDER BY name"; queries["stock_amount"] = "SELECT timestamp, amount FROM restock WHERE product = ? UNION ALL SELECT timestamp, -1 AS amount FROM sales WHERE product = ? ORDER BY timestamp DESC"; queries["session_set"] = "UPDATE authentication SET session=? WHERE user = ?"; queries["session_get"] = "SELECT user FROM authentication WHERE session = ?"; |