admin/rooms list: filter out soft-deleted rooms (AND removed_at IS NULL) so /api/rooms/:id/remove hides them from the gallery

c42d61a957ded4ba9efe52515f60e4e259d1591a · 2026-05-29 17:00:02 -0700 · Steve Abrams

Files touched

M server.js

Diff

commit c42d61a957ded4ba9efe52515f60e4e259d1591a
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Fri May 29 17:00:02 2026 -0700

    admin/rooms list: filter out soft-deleted rooms (AND removed_at IS NULL) so /api/rooms/:id/remove hides them from the gallery
---
 server.js | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/server.js b/server.js
index 8271d3f..225fca9 100644
--- a/server.js
+++ b/server.js
@@ -1269,7 +1269,7 @@ app.get('/api/admin/rooms/list', (req, res) => {
     const raw = psqlQuery(
       "SELECT COALESCE(json_agg(t ORDER BY t.id DESC), '[]'::json) FROM (" +
         "SELECT id, design_id, room_type, image_path, to_char(created_at,'YYYY-MM-DD HH24:MI') AS created_at " +
-        "FROM wallco_rooms WHERE image_path IS NOT NULL" +
+        "FROM wallco_rooms WHERE image_path IS NOT NULL AND removed_at IS NULL" +
       ") t;"
     );
     const items = JSON.parse(raw || '[]');

← 0be62b7 elements: add prod-flavored extract.py with path rewriter + · back to Wallco Ai · fix(generator_tick): guard finishRun against non-numeric run 1d9bacf →