From 1a0e015dea1a27a7581db83612a5f530f18243d2 Mon Sep 17 00:00:00 2001
From: Jin Igarashi <igarashi.jin@water-gis.com>
Date: Thu, 22 May 2025 17:17:44 +0900
Subject: [PATCH] fix: fixed a bug not returning is_star and permission
 properties from /api/storymaps endpoint.

---
 .changeset/four-cougars-hug.md                 |  5 +++++
 sites/geohub/src/lib/server/StorymapManager.ts | 18 +++++++++---------
 2 files changed, 14 insertions(+), 9 deletions(-)
 create mode 100644 .changeset/four-cougars-hug.md

diff --git a/.changeset/four-cougars-hug.md b/.changeset/four-cougars-hug.md
new file mode 100644
index 0000000000..a01e4a7493
--- /dev/null
+++ b/.changeset/four-cougars-hug.md
@@ -0,0 +1,5 @@
+---
+"geohub": patch
+---
+
+fix: fixed a bug not returning is_star and permission properties from /api/storymaps endpoint.
diff --git a/sites/geohub/src/lib/server/StorymapManager.ts b/sites/geohub/src/lib/server/StorymapManager.ts
index da361ba248..6c828daf71 100644
--- a/sites/geohub/src/lib/server/StorymapManager.ts
+++ b/sites/geohub/src/lib/server/StorymapManager.ts
@@ -101,10 +101,6 @@ class StorymapManager {
 			a.updatedat, 
 			a.updated_user,
 			CASE WHEN z.no_stars is not null THEN cast(z.no_stars as integer) ELSE 0 END as no_stars,
-			${
-				excludeChapter === true
-					? `'{}'::integer[] as chapters`
-					: `
 			${
 				user_email
 					? `
@@ -118,11 +114,15 @@ class StorymapManager {
 						`
 					: 'false as is_star,'
 			}
-            ${
-							!is_superuser && user_email
-								? `CASE WHEN p.permission is not null THEN p.permission ELSE null END`
-								: `${is_superuser ? Permission.OWNER : 'null'}`
-						} as permission,
+			${
+				!is_superuser && user_email
+					? `CASE WHEN p.permission is not null THEN p.permission ELSE null END`
+					: `${is_superuser ? Permission.OWNER : 'null'}`
+			} as permission,
+			${
+				excludeChapter === true
+					? `'{}'::integer[] as chapters`
+					: `
 			array_to_json(array_agg(row_to_json((
 				SELECT p FROM (
 				SELECT