From 025fcee561ef9e94580ddf6652bfd1437c3f2524 Mon Sep 17 00:00:00 2001 From: Sebastian Reichel Date: Tue, 15 Sep 2015 00:42:50 +0200 Subject: web: new product list sorted by best before date --- src/database/db-interface.vala | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) (limited to 'src/database/db-interface.vala') diff --git a/src/database/db-interface.vala b/src/database/db-interface.vala index d469743..c8f56e8 100644 --- a/src/database/db-interface.vala +++ b/src/database/db-interface.vala @@ -17,7 +17,7 @@ public interface Database : Object { public abstract StockEntry[] get_stock() throws IOError; public abstract PriceEntry[] get_prices(uint64 product) throws IOError; - public abstract RestockEntry[] get_restocks(uint64 product) throws IOError; + public abstract RestockEntry[] get_restocks(uint64 product, bool descending) throws IOError; public abstract bool buy(int32 user, uint64 article) throws IOError, DatabaseError; public abstract string get_product_name(uint64 article) throws IOError, DatabaseError; public abstract int get_product_amount(uint64 article) throws IOError, DatabaseError; @@ -58,6 +58,7 @@ public interface Database : Object { public abstract void ean_alias_add(uint64 ean, uint64 real_ean) throws IOError, DatabaseError; public abstract uint64 ean_alias_get(uint64 ean) throws IOError; public abstract EanAlias[] ean_alias_list() throws IOError; + public abstract BestBeforeEntry[] bestbeforelist() throws IOError; } public struct StockEntry { @@ -82,6 +83,13 @@ public struct RestockEntry { public int64 best_before_date; } +public struct BestBeforeEntry { + public uint64 ean; + public string name; + public int amount; + public int64 best_before_date; +} + public struct Supplier { public int64 id; public string name; -- cgit v1.2.3