From 1479f8842ac81a8df51ddef2b89be5ecdc046948 Mon Sep 17 00:00:00 2001
From: Sebastian Reichel <sre@ring0.de>
Date: Sun, 18 Dec 2022 16:05:48 +0100
Subject: web: show aliases in product detail page

---
 data/templates/products/entry.html |  1 +
 src/database/database.vala         | 21 +++++++++++++++++++++
 src/database/db-interface.vala     |  1 +
 src/web/web.vala                   |  7 +++++++
 4 files changed, 30 insertions(+)

diff --git a/data/templates/products/entry.html b/data/templates/products/entry.html
index 64b2aa4..369da30 100644
--- a/data/templates/products/entry.html
+++ b/data/templates/products/entry.html
@@ -2,6 +2,7 @@
 <p>
 	<table class="table table-bordered table-nonfluid">
 		<tr><th>EAN</th><td>{{{EAN}}}</td></tr>
+		<tr><th>Aliases</th><td><ul>{{{ALIASES}}}</ul></td></tr>
 		<tr><th>Name</th><td>{{{NAME}}}</td></tr>
 		<tr><th>Category</th><td>{{{CATEGORY}}}</td></tr>
 		<tr><th>Amount</th><td>{{{AMOUNT}}}</td></tr>
diff --git a/src/database/database.vala b/src/database/database.vala
index 52c5dd2..b361daf 100644
--- a/src/database/database.vala
+++ b/src/database/database.vala
@@ -141,6 +141,7 @@ public class DataBase : Object {
 		queries["alias_ean_add"]     = "INSERT OR IGNORE INTO ean_aliases (id, real_ean) VALUES (?, ?)";
 		queries["alias_ean_get"]     = "SELECT real_ean FROM ean_aliases WHERE id = ?";
 		queries["alias_ean_list"]    = "SELECT id, real_ean FROM ean_aliases ORDER BY id ASC";
+		queries["alias_rev_lookup"]  = "SELECT id FROM ean_aliases WHERE real_ean = ?";
 		queries["userid_rfid"]       = "SELECT user FROM rfid_users WHERE rfid = ?";
 		queries["rfid_userid"]       = "SELECT rfid FROM rfid_users WHERE user = ?";
 		queries["rfid_insert"]       = "INSERT OR REPLACE INTO rfid_users ('user','rfid') VALUES (?,?)";
@@ -390,6 +391,26 @@ public class DataBase : Object {
 		}
 	}
 
+	public uint64[] get_product_aliases(uint64 article) throws DBusError, IOError, DatabaseError {
+		statements["alias_rev_lookup"].reset();
+		statements["alias_rev_lookup"].bind_text(1, "%llu".printf(article));
+		uint64[] result = null;
+
+		while (true) {
+			int rc = statements["alias_rev_lookup"].step();
+
+			switch(rc) {
+				case Sqlite.ROW:
+					result += statements["alias_rev_lookup"].column_int64(0);
+					break;
+				case Sqlite.DONE:
+					return result;
+				default:
+					throw new DatabaseError.INTERNAL_ERROR(_("internal error: %d"), rc);
+			}
+		}
+	}
+
 	public string get_product_category(uint64 article) throws DBusError, IOError, DatabaseError {
 		statements["product_category"].reset();
 		statements["product_category"].bind_text(1, "%llu".printf(article));
diff --git a/src/database/db-interface.vala b/src/database/db-interface.vala
index 840f0a8..0db9521 100644
--- a/src/database/db-interface.vala
+++ b/src/database/db-interface.vala
@@ -22,6 +22,7 @@ public interface Database : Object {
 	public abstract RestockEntry[] get_restocks(uint64 product, bool descending) throws DBusError, IOError;
 	public abstract bool buy(int32 user, uint64 article) throws DBusError, IOError, DatabaseError;
 	public abstract string get_product_name(uint64 article) throws DBusError, IOError, DatabaseError;
+	public abstract uint64[] get_product_aliases(uint64 article) throws DBusError, IOError, DatabaseError;
 	public abstract string get_product_category(uint64 article) throws DBusError, IOError, DatabaseError;
 	public abstract int get_product_amount(uint64 article) throws DBusError, IOError, DatabaseError;
 	public abstract bool get_product_deprecated(uint64 article) throws DBusError, IOError, DatabaseError;
diff --git a/src/web/web.vala b/src/web/web.vala
index 0ed852d..414da5c 100644
--- a/src/web/web.vala
+++ b/src/web/web.vala
@@ -732,6 +732,13 @@ public class WebServer {
 			/* ean */
 			t.replace("EAN", "%llu".printf(id));
 
+			/* aliases */
+			string aliases = "";
+			foreach(var a in db.get_product_aliases(id)) {
+				aliases += "<li>%llu</li>".printf(a);
+			}
+			t.replace("ALIASES", aliases);
+
 			/* name */
 			string name = db.get_product_name(id);
 			t.replace("NAME", name);
-- 
cgit v1.2.3