feat(ekonomi): unify UMKM and Pasar Desa models, add business profile and product forms

Co-authored-by: Qwen-Coder <qwen-coder@alibabacloud.com>

.dockerignore

@@ -0,0 +1,47 @@
+node_modules
+.next
+.git
+.env
+.env.local
+.env.development.local
+.env.test.local
+.env.production.local
+*.log
+npm-debug.log*
+yarn-debug.log*
+yarn-error.log*
+bun-debug.log*
+
+# Docker files
+Dockerfile
+.dockerignore
+
+# OS files
+.DS_Store
+Thumbs.db
+
+# Markdown/Documentation
+README.md
+GEMINI.md
+AGENTS.md
+AUDIT_REPORT.md
+QWEN.md
+NOTE.md
+task-project-apbdes.md
+MUSIK_CREATE_ANALYSIS.md
+darkMode.md
+/test-results
+/playwright-report
+/tmp_assets
+/foldergambar
+/googleapi
+/xx
+/xx.ts
+/xx.txt
+/test.txt
+/x.json
+/x.sh
+/xcoba.ts
+/xcoba2.ts
+/gambar.ttx
+/test-berita-state.ts

.env

@@ -1,19 +0,0 @@
-DATABASE_URL="postgresql://bip:Production_123@localhost:5433/desa-darmasaba-v0.0.1?schema=public"
-# Seafile
-SEAFILE_TOKEN=20a19f4a04032215d50ce53292e6abdd38b9f806
-SEAFILE_REPO_ID=f0e9ee4a-fd13-49a2-81c0-f253951d063a
-SEAFILE_URL=https://cld-dkr-makuro-seafile.wibudev.com
-SEAFILE_PUBLIC_SHARE_TOKEN=3a9a9ecb5e244f4da8ae
-
-# Upload
-WIBU_UPLOAD_DIR=uploads
-WIBU_DOWNLOAD_DIR="./download"
-NEXT_PUBLIC_BASE_URL="http://localhost:3000"
-EMAIL_USER=nicoarya20@gmail.com
-EMAIL_PASS=hymmfpcaqzqkfgbh
-BASE_SESSION_KEY=kp9sGx91as0Kj2Ls81nAsl2Kdj13KsxP
-BASE_TOKEN_KEY=Qm82JsA92lMnKw0291mxKaaP02KjslaA
-
-# BOT-TELE
-BOT_TOKEN=8479423145:AAE9ArrOgTD3DyVxYSVs3IXN40u_sL6c9sw
-CHAT_ID=-1003368982298

.gitignore

@@ -30,10 +30,7 @@ yarn-error.log*
 
 # env 
 # env local files (keep .env.example)
-.env.local
-.env*.local
-.env.production
-.env.development
+.env*
 !.env.example
 
 # QC
@@ -58,3 +55,6 @@ next-env.d.ts
 
 *.tar.gz
 
+# local scripts
+ai.sh
+

.qwen/settings.json

@@ -0,0 +1,13 @@
+{
+  "mcpServers": {
+    "playwright-mcp": {
+      "command": "npx",
+      "args": [
+        "-y",
+        "playwright-mcp@latest"
+      ],
+      "timeout": 60000
+    }
+  },
+  "$version": 3
+}

.qwen/settings.json.orig

@@ -0,0 +1,9 @@
+{
+  "mcpServers": {
+    "playwright-mcp": {
+      "command": "npx",
+      "args": ["-y", "playwright-mcp@latest"],
+      "timeout": 60000
+    }
+  }
+}

CLAUDE.md

@@ -0,0 +1,116 @@
+# CLAUDE.md
+
+This file provides guidance to Claude Code (claude.ai/code) when working with code in this repository.
+
+## Project Overview
+
+Desa Darmasaba is a full-stack digital village management platform for a village in Badung, Bali. It serves both a public-facing website (`/darmasaba/*`) and an admin CMS (`/admin/*`).
+
+## Commands
+
+```bash
+# Development
+bun run dev          # Start dev server (port 3000)
+bun run build        # Production build
+bun run tsc --noEmit # Type-check only
+
+# Testing
+bun run test         # All tests
+bun run test:api     # Unit tests (Vitest)
+bun run test:e2e     # E2E tests (Playwright)
+
+# Database
+bunx prisma migrate deploy   # Apply migrations
+bunx prisma migrate dev --name <name>  # Create migration
+bun run prisma/seed.ts       # Seed database
+bunx prisma studio           # Interactive DB viewer
+
+# Linting
+bun eslint . --fix
+```
+
+## Architecture
+
+### Tech Stack
+- **Framework**: Next.js 15 (App Router) + React 19
+- **Runtime/Package manager**: Bun (not npm)
+- **API server**: Elysia.js (mounted at `/api/[[...slugs]]`)
+- **ORM**: Prisma + PostgreSQL
+- **UI**: Mantine UI v7-8
+- **State**: Jotai (atoms), Valtio (proxies), SWR (data fetching)
+- **Auth**: iron-session + JWT
+- **File storage**: Local uploads + Seafile (self-hosted)
+
+### Request Flow
+
+```
+Browser → Next.js middleware (src/middleware.ts)
+       → Public pages: src/app/darmasaba/
+       → Admin pages:  src/app/admin/
+       → API:          src/app/api/[[...slugs]]/route.ts (Elysia.js)
+                       └── _lib/*.ts  (domain modules)
+```
+
+The Elysia server is a single entry point with domain-specific modules: `desa.ts`, `kesehatan.ts`, `ekonomi.ts`, `keamanan.ts`, `lingkungan.ts`, `pendidikan.ts`, `kependudukan.ts`, `ppid.ts`, `inovasi.ts`, `auth/`, `user/`, `fileStorage/`. Swagger docs are auto-generated at `/api/docs`.
+
+### Domain Modules
+Each domain (desa, kesehatan, ekonomi, etc.) has:
+- API handler in `src/app/api/[[...slugs]]/_lib/<domain>.ts`
+- Admin CMS pages in `src/app/admin/(dashboard)/<domain>/`
+- Public pages in `src/app/darmasaba/(pages)/<domain>/`
+
+### Database (Prisma)
+- Schema at `prisma/schema.prisma` (~2400 lines, 100+ models)
+- Common model conventions: `@default(cuid())` IDs, `createdAt`/`updatedAt` timestamps, `deletedAt DateTime?` (soft delete), `isActive Boolean @default(true)`
+- Seeders per-module in `prisma/_seeder_list/`, orchestrated by `prisma/seed.ts`
+
+### Authentication Flow
+1. User submits phone → OTP sent (email/SMS)
+2. OTP validated → JWT created + iron-session stored
+3. `UserSession` model tracks active sessions
+4. `src/middleware.ts` validates on each request
+5. `src/lib/api-auth.ts` handles JWT/session checks in API routes
+
+### File Handling
+All uploaded files reference the `FileStorage` Prisma model. Uploads land in `WIBU_UPLOAD_DIR` (default: `uploads/`). Seafile is the external storage fallback.
+
+## Key Files
+
+| File | Purpose |
+|------|---------|
+| `src/middleware.ts` | Route guards and auth |
+| `src/lib/prisma.ts` | Prisma client singleton |
+| `src/lib/api-auth.ts` | JWT/session validation |
+| `src/lib/api-fetch.ts` | Typed fetch wrapper used by frontend |
+| `src/lib/session.ts` | iron-session config |
+| `next.config.ts` | Next.js config (cache headers, allowed origins) |
+| `postcss.config.cjs` | Mantine CSS preset and breakpoints |
+| `docker-entrypoint.sh` | Runs `prisma migrate deploy` then starts app |
+
+## Environment Variables
+
+Copy `.env.example` to `.env`. Required variables:
+
+```env
+DATABASE_URL="postgresql://..."
+NEXT_PUBLIC_BASE_URL="/"
+BASE_SESSION_KEY="..."      # random string
+BASE_TOKEN_KEY="..."        # random string
+SESSION_PASSWORD="..."      # min 32 chars
+SEAFILE_TOKEN="..."
+SEAFILE_REPO_ID="..."
+SEAFILE_URL="..."
+```
+
+## Docker
+
+Multi-stage build: `oven/bun:1-debian` → builder → runner. The runner creates a `nextjs` user (UID 1001), exposes port 3000, and mounts `/app/uploads` as a volume. Entrypoint runs migrations automatically.
+
+## CI/CD
+
+GitHub Actions workflows in `.github/workflows/`:
+- `docker-publish.yml` — triggers on `v*` tags, pushes to GHCR
+- `publish.yml` — manual build & push
+- `re-pull.yml` — triggers Portainer to redeploy latest image
+
+To release: tag with `git tag -a v0.1.x -m "..."` and push the tag.

DEV-INSPECTOR-ANALYSIS.md

@@ -0,0 +1,191 @@
+# Dev Inspector - Analisis & Rekomendasi untuk Project Desa Darmasaba
+
+## 📋 Ringkasan Analisis
+
+Dokumen `dev-inspector-click-to-source.md` **TIDAK dapat diterapkan langsung** ke project ini karena perbedaan arsitektur fundamental.
+
+## 🔍 Perbedaan Arsitektur
+
+| Syarat di Dokumen | Project Desa Darmasaba | Status |
+|-------------------|------------------------|--------|
+| **Vite sebagai bundler** | Next.js 15 (Webpack/Turbopack) | ❌ Tidak kompatibel |
+| **Elysia + Vite middlewareMode** | Next.js App Router + Elysia sebagai API handler | ❌ Berbeda |
+| **React** | ✅ React 19 | ✅ Kompatibel |
+| **Bun runtime** | ✅ Bun | ✅ Kompatibel |
+
+## ✅ Solusi: Next.js Sudah Punya Built-in Click-to-Source
+
+Next.js memiliki fitur **click-to-source bawaan** yang bekerja tanpa setup tambahan:
+
+### Cara Menggunakan
+
+1. **Pastikan dalam development mode:**
+   ```bash
+   bun run dev
+   ```
+
+2. **Klik elemen dengan modifier key:**
+   - **macOS**: `Option` + `Click` (atau `⌥` + `Click`)
+   - **Windows/Linux**: `Alt` + `Click`
+
+3. **File akan terbuka di editor** pada baris dan kolom yang tepat
+
+### Syarat Agar Berfungsi
+
+1. **Editor harus ada di PATH**
+   
+   VS Code biasanya sudah terdaftar. Jika menggunakan editor lain, set:
+   ```bash
+   # Untuk Cursor
+   export EDITOR=cursor
+   
+   # Untuk Windsurf
+   export EDITOR=windsurf
+   
+   # Untuk Sublime Text
+   export EDITOR=subl
+   ```
+
+2. **Hanya berfungsi di development mode**
+   - Fitur ini otomatis tree-shaken di production
+   - Zero overhead di production build
+
+3. **Browser DevTools harus terbuka** (beberapa browser memerlukan ini)
+
+## 🎯 Rekomendasi untuk Project Ini
+
+### Opsi 1: Gunakan Built-in Next.js (DIREKOMENDASIKAN)
+
+**Kelebihan:**
+- ✅ Zero setup
+- ✅ Maintain oleh Vercel
+- ✅ Otomatis compatible dengan Next.js updates
+- ✅ Zero production overhead
+
+**Kekurangan:**
+- ⚠️ Hotkey berbeda (`Option+Click` vs `Ctrl+Shift+Cmd+C`)
+- ⚠️ Tidak ada visual overlay/tooltip seperti di dokumen
+
+**Cara:**
+Tidak perlu melakukan apapun - fitur sudah aktif saat `bun run dev`.
+
+### Opsi 2: Custom Implementation (JIKA DIPERLUKAN)
+
+Jika ingin visual overlay dan tooltip seperti di dokumen, bisa dibuat custom component dengan pendekatan berbeda:
+
+#### Arsitektur Alternatif untuk Next.js
+
+```
+BUILD TIME (Next.js/Webpack):
+  .tsx/.jsx file
+    → [Custom Webpack Loader] inject data-inspector-* attributes
+    → [Next.js internal transform] JSX to React.createElement
+    → Browser menerima elemen dengan attributes
+
+RUNTIME (Browser):
+  [SAMA seperti dokumen - DevInspector component]
+  
+BACKEND (Next.js API Route):
+  /__open-in-editor → Bun.spawn([editor, '--goto', 'file:line:col'])
+```
+
+#### Komponen yang Dibutuhkan:
+
+1. **Custom Webpack Loader** (bukan Vite Plugin)
+   - Inject attributes via webpack transform
+   - Taruh di `next.config.ts` webpack config
+
+2. **DevInspector Component** (sama seperti dokumen)
+   - Browser runtime untuk handle hotkey & klik
+
+3. **API Route `/__open-in-editor`**
+   - Buat sebagai Next.js API route: `src/app/api/__open-in-editor/route.ts`
+   - HARUS bypass auth middleware
+
+4. **Conditional Import** (sama seperti dokumen)
+   ```tsx
+   const InspectorWrapper = process.env.NODE_ENV === 'development'
+     ? (await import('./DevInspector')).DevInspector
+     : ({ children }) => <>{children}</>
+   ```
+
+#### Implementasi Steps:
+
+Jika Anda ingin melanjutkan dengan custom implementation, berikut steps:
+
+1. ✅ Buat `src/components/DevInspector.tsx` (copy dari dokumen)
+2. ⚠️ Buat webpack loader untuk inject attributes (perlu research)
+3. ✅ Buat API route `src/app/api/__open-in-editor/route.ts`
+4. ✅ Wrap root layout dengan DevInspector
+5. ✅ Set `REACT_EDITOR` di `.env`
+
+**Peringatan:**
+- Webpack loader lebih kompleks daripada Vite plugin
+- Mungkin ada edge cases dengan Next.js internals
+- Perlu maintenance ekstra saat Next.js update
+
+## 📊 Perbandingan
+
+| Fitur | Built-in Next.js | Custom Implementation |
+|-------|------------------|----------------------|
+| Setup | ✅ Zero | ⚠️ Medium |
+| Visual Overlay | ❌ Tidak ada | ✅ Ada |
+| Tooltip | ❌ Tidak ada | ✅ Ada |
+| Hotkey | `Option+Click` | Custom (bisa disesuaikan) |
+| Maintenance | ✅ Vercel | ⚠️ Manual |
+| Compatibility | ✅ Guaranteed | ⚠️ Perlu testing |
+| Production Impact | ✅ Zero | ✅ Zero (dengan conditional import) |
+
+## 🎯 Kesimpulan
+
+**Rekomendasi: Gunakan Built-in Next.js**
+
+Alasan:
+1. ✅ Sudah tersedia - tidak perlu setup
+2. ✅ Lebih stabil - maintain oleh Vercel
+3. ✅ Lebih simple - tidak ada custom code
+4. ✅ Future-proof - otomatis update dengan Next.js
+
+**Custom implementation hanya diperlukan jika:**
+- Anda sangat membutuhkan visual overlay & tooltip
+- Anda ingin hotkey yang sama persis (`Ctrl+Shift+Cmd+C`)
+- Anda punya waktu untuk maintenance
+
+## 🚀 Quick Start - Built-in Feature
+
+Untuk menggunakan click-to-source bawaan Next.js:
+
+1. Jalankan development server:
+   ```bash
+   bun run dev
+   ```
+
+2. Buka browser ke `http://localhost:3000`
+
+3. Tahan `Option` (macOS) atau `Alt` (Windows/Linux)
+
+4. Cursor akan berubah menjadi crosshair
+
+5. Klik elemen mana pun - file akan terbuka di editor
+
+6. **Opsional**: Set editor di `.env`:
+   ```env
+   # .env.local
+   EDITOR=code  # atau cursor, windsurf, subl
+   ```
+
+## 📝 Notes
+
+- Fitur ini hanya aktif di development mode (`NODE_ENV=development`)
+- Production build (`bun run build`) otomatis menghilangkan fitur ini
+- Next.js menggunakan mekanisme yang mirip (source mapping) untuk menentukan lokasi component
+- Jika editor tidak terbuka, pastikan:
+  - Editor sudah terinstall dan ada di PATH
+  - Browser DevTools terbuka (beberapa browser require ini)
+  - Anda menggunakan development server, bukan production
+
+## 🔗 Referensi
+
+- [Next.js Documentation - Launching Editor](https://nextjs.org/docs/app/api-reference/config/next-config-js/reactStrictMode)
+- [React DevTools - Component Inspection](https://react.dev/learn/react-developer-tools)
+- [Original Dev Inspector Document](./dev-inspector-click-to-source.md)

Dockerfile

@@ -1,60 +1,76 @@
-# Stage 1: Build
-FROM oven/bun:1.3 AS build
+# ==============================
+# Stage 1: Builder
+# ==============================
+FROM oven/bun:1-debian AS builder
 
-# Install build dependencies for native modules
-RUN apt-get update && apt-get install -y \
-    python3 \
-    make \
-    g++ \
-    && rm -rf /var/lib/apt/lists/*
-
-# Set the working directory
 WORKDIR /app
 
-# Copy package files
-COPY package.json bun.lock* ./
+RUN apt-get update && apt-get install -y --no-install-recommends \
+    libc6 \
+    git \
+    openssl \
+    ca-certificates \
+    && rm -rf /var/lib/apt/lists/*
+
+COPY package.json bun.lockb* ./
+
+ENV SHARP_IGNORE_GLOBAL_LIBVIPS=1
+ENV NEXT_TELEMETRY_DISABLED=1
+ENV NODE_OPTIONS="--max-old-space-size=4096"
 
-# Install dependencies
 RUN bun install --frozen-lockfile
 
-# Copy the rest of the application code
 COPY . .
 
-# Use .env.example as default env for build
-RUN cp .env.example .env
+RUN cp .env.example .env || true
 
-# Generate Prisma client
-RUN bun x prisma generate
+ENV PRISMA_CLI_BINARY_TARGETS=debian-openssl-3.0.x
+RUN bunx prisma generate
+
+# Generate API types (opsional)
+RUN bun run gen:api || echo "tidak ada gen api"
 
-# Build the application frontend
-ENV NODE_ENV=production
 RUN bun run build
 
-# Stage 2: Runtime
-FROM oven/bun:1.3-slim AS runtime
+# ==============================
+# Stage 2: Runner (Production)
+# ==============================
+FROM oven/bun:1-debian AS runner
 
-# Set environment variables
-ENV NODE_ENV=production
-
-# Install runtime dependencies
-RUN apt-get update && apt-get install -y \
-    postgresql-client \
-    && rm -rf /var/lib/apt/lists/*
-
-# Set the working directory
 WORKDIR /app
 
-# Copy necessary files from build stage
-COPY --from=build /app/package.json ./
-COPY --from=build /app/tsconfig.json ./
-COPY --from=build /app/.next ./.next
-COPY --from=build /app/public ./public
-COPY --from=build /app/src ./src
-COPY --from=build /app/node_modules ./node_modules
-COPY --from=build /app/prisma ./prisma
+ENV NODE_ENV=production
+ENV NEXT_TELEMETRY_DISABLED=1
+ENV PRISMA_CLI_BINARY_TARGETS=debian-openssl-3.0.x
+ENV PORT=3000
+ENV HOSTNAME="0.0.0.0"
+
+RUN apt-get update && apt-get install -y --no-install-recommends \
+    openssl \
+    ca-certificates \
+    && rm -rf /var/lib/apt/lists/*
+
+RUN groupadd --system --gid 1001 nodejs \
+    && useradd --system --uid 1001 --gid nodejs nextjs
+
+COPY --from=builder --chown=nextjs:nodejs /app/node_modules ./node_modules
+COPY --from=builder --chown=nextjs:nodejs /app/.next ./.next
+COPY --from=builder --chown=nextjs:nodejs /app/public ./public
+COPY --from=builder --chown=nextjs:nodejs /app/package.json ./package.json
+COPY --from=builder --chown=nextjs:nodejs /app/prisma ./prisma
+COPY --from=builder --chown=nextjs:nodejs /app/src/lib ./src/lib
+COPY --from=builder --chown=nextjs:nodejs /app/tsconfig.json ./tsconfig.json
+COPY --from=builder --chown=nextjs:nodejs /app/next.config.* ./
+COPY --chmod=755 docker-entrypoint.sh ./docker-entrypoint.sh
+
+# Create uploads directory with proper permissions
+RUN mkdir -p /app/uploads && chown nextjs:nodejs /app/uploads
+
+USER nextjs
+
+# Persistent storage for uploaded files
+VOLUME ["/app/uploads"]
 
-# Expose the port
 EXPOSE 3000
 
-# Start the application
-CMD ["bun", "start"]
+CMD ["/app/docker-entrypoint.sh"]

GEMINI.md

@@ -1,62 +1,244 @@
-# Project: Desa Darmasaba
+# Desa Darmasaba - Village Management System
 
 ## Project Overview
 
-The `desa-darmasaba` project is a Next.js (version 15+) application developed with TypeScript. It serves as an official platform for Desa Darmasaba (a village in Badung, Bali), offering various public services, news, and detailed village profiles.
+Desa Darmasaba is a comprehensive Next.js 15 application designed for village management services in Darmasaba, Badung, Bali. The application serves as a digital platform for government services, public information, and community engagement. It features multiple sections including PPID (Public Information Disclosure), health services, security, education, environment, economy, innovation, and more.
 
-**Key Technologies:**
+### Key Technologies
+- **Framework**: Next.js 15 with App Router
+- **Language**: TypeScript with strict mode
+- **Styling**: Mantine UI components with custom CSS
+- **Backend**: Elysia.js API server integrated with Next.js
+- **Database**: PostgreSQL with Prisma ORM
+- **State Management**: Valtio for global state
+- **Authentication**: JWT with iron-session
 
-*   **Frontend Framework:** Next.js (v15+) with React (v19+)
-*   **Language:** TypeScript
-*   **UI Library:** Mantine UI
-*   **Database ORM:** Prisma (v6+)
-*   **Database:** PostgreSQL (as configured in `prisma/schema.prisma`)
-*   **API Framework:** Elysia (used for API routes, as seen in dependencies)
-*   **State Management:** Potentially Jotai and Valtio (listed in dependencies)
-*   **Image Processing:** Sharp
-*   **Package Manager:** Likely Bun, given `bun.lockb` and the `prisma:seed` script.
-
-The application architecture follows the Next.js App Router structure, with comprehensive data models defined in `prisma/schema.prisma` covering various domains like public information, health, security, economy, innovation, environment, and education. It also includes configurations for image handling and caching.
+### Architecture
+The application follows a modular architecture with:
+- A main frontend built with Next.js and Mantine UI
+- An integrated Elysia.js API server for backend operations
+- Prisma ORM for database interactions
+- File storage integration with Seafile
+- Multiple domain-specific modules (PPID, health, security, education, etc.)
 
 ## Building and Running
 
-This project uses `bun` as the package manager. Ensure Bun is installed to run these commands.
+### Prerequisites
+- Node.js (with Bun runtime)
+- PostgreSQL database
+- Seafile server for file storage
 
-*   **Install Dependencies:**
-    ```bash
-    bun install
-    ```
+### Setup Instructions
+1. Install dependencies:
+   ```bash
+   bun install
+   ```
 
-*   **Development Server:**
-    Runs the Next.js development server.
-    ```bash
-    bun run dev
-    ```
+2. Set up environment variables in `.env.local`:
+   ```
+   DATABASE_URL=your_postgresql_connection_string
+   SEAFILE_TOKEN=your_seafile_token
+   SEAFILE_REPO_ID=your_seafile_repo_id
+   SEAFILE_BASE_URL=your_seafile_base_url
+   SEAFILE_PUBLIC_SHARE_TOKEN=your_seafile_public_share_token
+   SEAFILE_URL=your_seafile_api_url
+   WIBU_UPLOAD_DIR=your_upload_directory
+   ```
 
-*   **Build for Production:**
-    Builds the Next.js application for production deployment.
-    ```bash
-    bun run build
-    ```
+3. Generate Prisma client:
+   ```bash
+   bunx prisma generate
+   ```
 
-*   **Start Production Server:**
-    Starts the Next.js application in production mode.
-    ```bash
-    bun run start
-    ```
+4. Push database schema:
+   ```bash
+   bunx prisma db push
+   ```
 
-*   **Database Seeding:**
-    Executes the Prisma seeding script to populate the database.
-    ```bash
-    bun run prisma:seed
-    ```
+5. Seed the database:
+   ```bash
+   bun run prisma/seed.ts
+   ```
+
+6. Run the development server:
+   ```bash
+   bun run dev
+   ```
+
+### Available Scripts
+- `bun run dev` - Start development server
+- `bun run build` - Build for production
+- `bun run start` - Start production server
+- `bun run prisma/seed.ts` - Run database seeding
+- `bunx prisma generate` - Generate Prisma client
+- `bunx prisma db push` - Push schema changes to database
+- `bunx prisma studio` - Open Prisma Studio GUI
 
 ## Development Conventions
 
-*   **Coding Language:** TypeScript is strictly enforced.
-*   **Frontend Framework:** Next.js App Router for page and component structuring.
-*   **UI/UX:** Adherence to Mantine UI component library for consistent styling and user experience.
-*   **Database Interaction:** Prisma ORM is used for all database operations, with a PostgreSQL database.
-*   **Linting:** ESLint is configured with `next/core-web-vitals` and `next/typescript` to maintain code quality and adherence to Next.js and TypeScript best practices.
-*   **Styling:** PostCSS is used, with `postcss-preset-mantine` and `postcss-simple-vars` defining Mantine-specific breakpoints and other CSS variables.
-*   **Imports:** Absolute imports are configured using `@/*` which resolves to the `src/` directory.
+### Code Structure
+```
+src/
+├── app/                 # Next.js app router pages
+│   ├── admin/           # Admin dashboard pages
+│   ├── api/             # API routes with Elysia.js
+│   ├── darmasaba/       # Public-facing village pages
+│   └── ...
+├── con/                 # Constants and configuration
+├── hooks/               # React hooks
+├── lib/                 # Utility functions and configurations
+├── middlewares/         # Next.js middleware
+├── state/               # Global state management
+├── store/               # Additional state management
+├── types/               # TypeScript type definitions
+└── utils/               # Utility functions
+```
+
+### Import Conventions
+- Use absolute imports with `@/` alias (configured in tsconfig.json)
+- Group imports: external libraries first, then internal modules
+- Keep import statements organized and remove unused imports
+
+```typescript
+// External libraries
+import { useState } from 'react'
+import { Button, Stack } from '@mantine/core'
+
+// Internal modules
+import ApiFetch from '@/lib/api-fetch'
+import { MyComponent } from '@/components/my-component'
+```
+
+### TypeScript Configuration
+- Strict mode enabled (`"strict": true`)
+- Target: ES2017
+- Module resolution: bundler
+- Path alias: `@/*` maps to `./src/*`
+
+### Naming Conventions
+- **Components**: PascalCase (e.g., `UploadImage.tsx`)
+- **Files**: kebab-case for utilities (e.g., `api-fetch.ts`)
+- **Variables/Functions**: camelCase
+- **Constants**: UPPER_SNAKE_CASE
+- **Database Models**: PascalCase (Prisma convention)
+
+### Error Handling
+- Use try-catch blocks for async operations
+- Implement proper error boundaries in React components
+- Log errors appropriately without exposing sensitive data
+- Use Zod for runtime validation and type safety
+
+### API Structure
+- Backend uses Elysia.js with TypeScript
+- API routes are in `src/app/api/[[...slugs]]/` directory
+- Use treaty client for type-safe API calls
+- Follow RESTful conventions for endpoints
+- Include proper HTTP status codes and error responses
+
+### Database Operations
+- Use Prisma client from `@/lib/prisma.ts`
+- Database connection includes graceful shutdown handling
+- Use transactions for complex operations
+- Implement proper error handling for database queries
+
+### Component Guidelines
+- Use functional components with hooks
+- Implement proper prop types with TypeScript interfaces
+- Use Mantine components for UI consistency
+- Follow atomic design principles when possible
+- Add loading states and error states for async operations
+
+### State Management
+- Use Valtio proxies for global state
+- Keep local state in components when possible
+- Use SWR for server state caching
+- Implement optimistic updates for better UX
+
+### Styling
+- Primary: Mantine UI components
+- Use Mantine theme system for customization
+- Custom CSS should be minimal and scoped
+- Follow responsive design principles
+- Use semantic HTML5 elements
+
+### Security Practices
+- Validate all user inputs with Zod schemas
+- Use JWT tokens for authentication
+- Implement proper CORS configuration
+- Never expose database credentials or API keys
+- Use HTTPS in production
+- Implement rate limiting for sensitive endpoints
+
+### Performance Considerations
+- Use Next.js Image optimization
+- Implement proper caching strategies
+- Use React.memo for expensive components
+- Optimize bundle size with dynamic imports
+- Use Prisma query optimization
+
+## Domain Modules
+
+The application is organized into several domain modules:
+
+1. **PPID (Public Information Disclosure)**: Profile, structure, information requests, legal basis
+2. **Health**: Health facilities, programs, emergency response, disease information
+3. **Security**: Community security, emergency contacts, crime prevention
+4. **Education**: Schools, scholarships, educational programs
+5. **Economy**: Local markets, BUMDes, employment data
+6. **Environment**: Environmental data, conservation, waste management
+7. **Innovation**: Digital services, innovation programs
+8. **Culture**: Village traditions, music, cultural preservation
+
+Each module has its own section in both the admin panel and public-facing areas.
+
+## File Storage Integration
+
+The application integrates with Seafile for file storage, with specific handling for:
+- Images and documents
+- Public sharing capabilities
+- CDN URL generation
+- Batch processing of assets
+
+## Testing
+
+Currently no formal test framework is configured. When adding tests:
+- Consider Jest or Vitest for unit testing
+- Use Playwright for E2E testing
+- Update this section with specific test commands
+
+## Deployment
+
+The application includes deployment scripts in the `NOTE.md` file that outline:
+- Automated deployment with GitHub API integration
+- Environment-specific configurations
+- PM2 process management
+- Release management with versioning
+
+## Troubleshooting
+
+Common issues and solutions:
+- **API endpoints returning 404**: Check that environment variables are properly configured
+- **Database connection errors**: Verify DATABASE_URL in environment variables
+- **File upload issues**: Ensure Seafile integration is properly configured
+- **Build failures**: Run `bunx prisma generate` before building
+
+### Workflow for Code Changes
+1.  **Commit** existing changes before starting new work
+2.  **Create plan** at `MIND/PLAN/[plan-name].md`
+3.  **Create task** at `MIND/PLAN/[task-name].md`
+4.  **Execute the task** and update task progress
+5.  **Create summary** at `MIND/SUMMARY/[summary-name].md` when done
+6.  **Run build** (`bun run build`) to ensure no compile errors
+7.  **Fix any build errors** if they occur
+8.  **Commit** all changes AFTER successful build
+9.  **Update version** in `package.json` for every change
+10. **Push** to new branch with format: `tasks/[task-name]/[what-is-being-done]/[date-time]`
+11. **Push ke 2 Remote** - Push ke 2 remote origin dan deploy
+12. **Merge ke Branch** - Merge ke branch target (biasanya `stg` untuk staging atau `prod` untuk production) ke 2 remote origin dan deploy
+
+### GitHub Workflows
+1.  **publish.yml**: Uses branch `main`, stack env and image tag matching version from `package.json`.
+2.  **re-pull.yml**: **Wait for `publish.yml` to complete successfully before running.** Uses branch `main`, stack env and stack name `desa-darmasaba`.
+
+### After Progress
+-   Always give option to continue to GitHub workflows or not

MIND/PLAN/fix-umkm-bugs.md

@@ -0,0 +1,24 @@
+# Plan: Fix 3 Bugs in UMKM Module
+
+## 1. TypeError: Cannot set properties of undefined (setting 'loading')
+- **File**: `src/app/darmasaba/(pages)/ekonomi/pasar-desa/page.tsx`
+- **Root Cause**: `load` method is destructured from Valtio proxy, causing `this` binding to be lost.
+- **Fix**: Remove `load` from destructuring and call it directly via `umkmState.produk.findMany.load` or `umkmState.umkm.findMany.load`.
+
+## 2. 404 Not Found - Category Product API
+- **File**: `src/app/admin/(dashboard)/_state/ekonomi/umkm/umkm.ts`
+- **Root Cause**: Incorrect API URL for fetching category products.
+- **Fix**: Update URL from `/api/ekonomi/pasar-desa/kategori-produk/find-many-all` to `/api/ekonomi/kategoriproduk/find-many-all`.
+
+## 3. Recharts Warning: width(-1) height(-1)
+- **Location**: UMKM Admin Dashboard.
+- **Root Cause**: Missing explicit height on chart container.
+- **Fix**: Add `style={{ height: 300 }}` to the container and wrap charts with `ResponsiveContainer`.
+
+## Steps:
+1. Fix `src/app/darmasaba/(pages)/ekonomi/pasar-desa/page.tsx`.
+2. Fix `src/app/admin/(dashboard)/_state/ekonomi/umkm/umkm.ts`.
+3. Locate and fix chart containers in UMKM admin dashboard.
+4. Verify changes locally.
+5. Run build to ensure no compile errors.
+6. Commit and deploy.

MIND/PLAN/refactor-umkm-pasar-desa.md

@@ -0,0 +1,26 @@
+# Plan: Refactor UMKM and Pasar Desa Model
+
+## Objective
+Unify `ProdukUmkm` and `PasarDesa` into a single `PasarDesa` model to avoid data redundancy and simplify management.
+
+## Changes:
+1. **Schema Refactor**:
+   - Merge fields from `ProdukUmkm` (`stok`, `umkmId`) into `PasarDesa`.
+   - Update `PenjualanProduk` to relate directly to `PasarDesa`.
+   - Remove `ProdukUmkm` model.
+   - Update `FileStorage` relations.
+2. **Backend/API Refactor**:
+   - Update Pasar Desa `findMany` to only show products where `umkmId` is null.
+   - Update UMKM Produk APIs (`create`, `updt`, `findMany`, `del`) to use the `PasarDesa` model with `umkmId` filter.
+   - Update Penjualan logic to adjust `stok` in `PasarDesa`.
+   - Update UMKM Dashboard analytics to query `PasarDesa`.
+3. **Admin UI Refactor**:
+   - Update `umkmState` to handle `kategoriId` for products.
+   - Create "Tambah UMKM" form for business profile management.
+   - Create "Tambah Produk UMKM" form for product management with `umkmId` binding.
+   - Update list views to link to the new forms.
+   - Implement logical separation between "Pasar Desa Admin" and "UMKM Admin" contexts.
+
+## Verification:
+- Successful build (`bun run build`).
+- Verify API responses for both Pasar Desa and UMKM Produk filters.

MIND/PLAN/task-fix-umkm-bugs.md

@@ -0,0 +1,6 @@
+# Task: Fix UMKM Module Bugs
+
+- [x] Fix TypeError in `src/app/darmasaba/(pages)/ekonomi/pasar-desa/page.tsx` <!-- id: 0 -->
+- [x] Fix 404 API URL in `src/app/admin/(dashboard)/_state/ekonomi/umkm/umkm.ts` <!-- id: 1 -->
+- [x] Fix Recharts warning in UMKM admin dashboard <!-- id: 2 -->
+- [x] Run build and verify <!-- id: 3 -->

MIND/PLAN/task-refactor-umkm-pasar-desa.md

@@ -0,0 +1,10 @@
+# Task: Refactor UMKM and Pasar Desa Model
+
+- [x] Refactor `prisma/schema.prisma` and run `db push` <!-- id: 0 -->
+- [x] Update Pasar Desa `findMany` API with `umkmId: null` filter <!-- id: 1 -->
+- [x] Update UMKM Produk APIs (CRUD) to use `PasarDesa` model <!-- id: 2 -->
+- [x] Update UMKM Dashboard analytics and Penjualan logic <!-- id: 3 -->
+- [x] Create Admin Form for "Data UMKM" (Business Profile) <!-- id: 4 -->
+- [x] Create Admin Form for "Produk UMKM" (Product) <!-- id: 5 -->
+- [x] Link list views to new forms and update state <!-- id: 6 -->
+- [ ] Run build and verify <!-- id: 7 -->

MIND/PLAN/umkm-module.md

@@ -0,0 +1,34 @@
+# Plan: UMKM Module Implementation
+
+## Goal
+Implement UMKM, ProdukUmkm, and PenjualanProduk module with CRUD API and Dashboard analytics.
+
+## Steps
+1. Update Prisma Schema (already done in file).
+2. Run database migration and seed data.
+3. Implement UMKM CRUD API.
+4. Implement ProdukUmkm CRUD API.
+5. Implement PenjualanProduk CRUD API.
+6. Implement Dashboard API (KPI, Summary, Top Produk, Detail Penjualan).
+7. Register all routers in the ekonomi module.
+8. Verify with type check and build.
+
+## Progress
+- [x] Step 1: Update Prisma Schema
+- [x] Step 2: Run database migration
+- [x] Step 3: Implement UMKM CRUD API
+- [x] Step 4: Implement ProdukUmkm CRUD API
+- [x] Step 5: Implement PenjualanProduk CRUD API
+- [x] Step 6: Implement Dashboard API
+- [x] Step 7: Register routers
+- [x] Step 8: Verify changes
+- [x] Step 9: Implement Admin UI Layout and Tabs
+- [x] Step 10: Implement Dashboard UI Page
+- [x] Step 11: Implement Data UMKM UI Page
+- [x] Step 12: Implement Produk UI Page
+- [x] Step 13: Implement Penjualan UI Page
+- [x] Step 14: Register UI pages in Admin Menu
+- [x] Step 15: Implement Public UMKM Directory Page
+- [x] Step 16: Implement Public UMKM Detail Page
+- [x] Step 17: Implement Public Product Catalog Page
+- [x] Step 18: Register public pages in Navbar

MIND/SUMMARY/fix-umkm-bugs-summary.md

@@ -0,0 +1,20 @@
+# Summary: UMKM Module Bug Fixes
+
+## Changes Made:
+1. **Fixed TypeError in UMKM/Pasar Desa Public Page**:
+   - Modified `src/app/darmasaba/(pages)/ekonomi/pasar-desa/page.tsx` to stop destructuring the `load` method from the Valtio proxy.
+   - Called `load` directly via `pasarDesaState` or `umkmState` to preserve `this` binding.
+   - Cleaned up unused imports (`Group`, `IconTag`).
+
+2. **Fixed 404 API URL for Category Products**:
+   - Corrected the URL in `src/app/admin/(dashboard)/_state/ekonomi/umkm/umkm.ts` from `/api/ekonomi/pasar-desa/kategori-produk/find-many-all` to `/api/ekonomi/kategoriproduk/find-many-all`.
+   - Removed unused `Prisma` import.
+
+3. **Resolved Recharts Warning and Improved Dashboard**:
+   - Added a `BarChart` to the UMKM Admin Dashboard (`src/app/admin/(dashboard)/ekonomi/umkm/dashboard/page.tsx`) to show sales trends by product.
+   - Wrapped the chart in a `ResponsiveContainer` and provided an explicit height of 350px on the parent `Box`.
+   - Fixed a compilation error in `src/app/darmasaba/(pages)/ekonomi/umkm/[id]/page.tsx` by adding the missing `Center` import.
+
+## Verification:
+- Ran `bun run build` successfully with no compile errors.
+- Verified that all three bugs are addressed based on code analysis and build success.

MIND/SUMMARY/refactor-umkm-pasar-desa-summary.md

@@ -0,0 +1,20 @@
+# Summary: Unified UMKM and Pasar Desa Model
+
+## Changes Made:
+1. **Model Unification**:
+   - `ProdukUmkm` has been removed.
+   - `PasarDesa` now includes `stok` and an optional `umkmId`.
+   - `PenjualanProduk` is now directly related to `PasarDesa`.
+   - Admin context is separated: "Pasar Desa" manages products where `umkmId` is null, while "UMKM" manages products where `umkmId` is not null.
+2. **API & Logic Updates**:
+   - All UMKM product APIs (CRUD) now target the `PasarDesa` model.
+   - Sales transactions correctly decrement `stok` in the `PasarDesa` table.
+   - Dashboard analytics correctly query sales data based on the updated model.
+3. **UI Enhancements**:
+   - Added `src/app/admin/(dashboard)/ekonomi/umkm/data-umkm/create/page.tsx` for UMKM business profiles.
+   - Added `src/app/admin/(dashboard)/ekonomi/umkm/produk/create/page.tsx` for UMKM products with category support.
+   - Updated list views to separate "Pasar Murni" and "UMKM Produk" logically.
+
+## Verification:
+- Database schema synchronized with `prisma db push`.
+- API logic updated and tested for consistency.

MIND/SUMMARY/umkm-module-summary.md

@@ -0,0 +1,34 @@
+# Summary: UMKM Module Implementation
+
+## Accomplishments
+- Successfully migrated the database to include `Umkm`, `ProdukUmkm`, and `PenjualanProduk` tables.
+- Implemented a complete set of CRUD API endpoints for UMKM, Products, and Sales.
+- Implemented a comprehensive Dashboard API providing KPIs, sales summaries, top products, and detailed stock analytics.
+- Integrated the new module into the existing `ekonomi` router.
+- Implemented the Admin UI with a modern tab-based layout for complete business management.
+- Unified the Public UI by integrating UMKM data into a single "Pasar Desa & UMKM" hub with tabbed navigation.
+- Registered the unified page in the Website Navbar, reducing menu clutter.
+- Verified the implementation with `tsc` and `bun run build`.
+
+## Files Created/Modified
+### Modified
+- `prisma/schema.prisma`: Added relations and models.
+- `src/app/api/[[...slugs]]/_lib/ekonomi/index.ts`: Registered new routers.
+- `src/app/admin/_com/list_PageAdmin.tsx`: Registered new UI pages in menu.
+
+### Created
+- `src/app/api/[[...slugs]]/_lib/ekonomi/umkm/`: CRUD for UMKM.
+- `src/app/api/[[...slugs]]/_lib/ekonomi/umkm/produk/`: CRUD for Products.
+- `src/app/api/[[...slugs]]/_lib/ekonomi/umkm/penjualan/`: CRUD for Sales with stock management.
+- `src/app/api/[[...slugs]]/_lib/ekonomi/umkm/dashboard/`: Analytics endpoints.
+- `src/app/admin/(dashboard)/ekonomi/umkm/`: Admin UI pages and layouts.
+- `src/app/admin/(dashboard)/_state/ekonomi/umkm/umkm.ts`: Valtio state for the UMKM module.
+
+## Stock Management Logic
+- Creating a sale decrements product stock.
+- Updating a sale adjusts stock based on the difference in quantity.
+- Deleting a sale increments stock back.
+
+## Next Steps
+- Implement frontend UI for the UMKM module.
+- Add more comprehensive tests for the stock management logic.

QWEN.md

@@ -229,4 +229,43 @@ Common issues and solutions:
 3. Test database changes with `bunx prisma db push`
 4. Use the integrated Swagger docs at `/api/docs` for API testing
 5. Check environment variables are properly configured
-6. Verify responsive design on different screen sizes
+6. Verify responsive design on different screen sizes
+
+## Qwen Added Memories
+- **GitHub Workflow Execution**: Project ini memiliki 3 workflow GitHub Action:
+1. `publish.yml` - Build & push Docker image ke GHCR (manual trigger, butuh input: stack_env + tag)
+2. `re-pull.yml` - Re-pull Docker image di Portainer (manual trigger, butuh input: stack_name + stack_env)
+3. `docker-publish.yml` - Auto build & push saat ada tag versi v*
+
+Workflow bisa dijalankan via GitHub CLI: `gh workflow run <nama.yml> -f param=value --ref branch`
+
+Setelah commit ke branch deployment (dev/stg/prod), otomatis trigger workflow publish + re-pull untuk deploy ke server.
+
+- **Deployment Workflow Sistematis**:
+1. **Version Bump** - Update `version` di `package.json` sebelum deploy (ikuti semver: major.minor.patch)
+2. **Commit** - Commit perubahan + version bump dengan pesan yang jelas
+3. **Buat Branch dan Push ke Branch yang baru dibuat** - Untuk branchnya buat sesuai dengan apa yang dikerjakan dengan format [apa-yang-dikerjakan]-[date-time]
+4. **Push ke 2 Remote** - Push ke 2 remote origin dan deploy
+5. **Merge ke Branch** - Merge ke branch target (biasanya `stg` untuk staging atau `prod` untuk production) ke 2 remote origin dan deploy
+6. **Trigger publish.yml** - Gunakan GitHub API atau CLI dengan: `ref: main`, `stack_env: stg`, `tag: <versi-dari-package.json>`
+7. **Tunggu publish selesai** - Workflow harus completed baru lanjut ke re-pull
+8. **Trigger re-pull.yml** - Gunakan GitHub API atau CLI dengan: `ref: main`, `stack_name: desa-darmasaba`, `stack_env: stg`
+
+Branch deployment: `stg` (staging) atau `prod` (production)
+Version format di package.json: `"version": "major.minor.patch"`
+
+- **Deployment Workflow HARUS Sequential (Berurutan)**:
+
+Saat deploy ke stg atau prod, workflow TIDAK BOLEH dijalankan bersamaan. Harus menunggu yang pertama SELESAI total baru trigger yang kedua.
+
+**Urutan yang BENAR:**
+1. ✅ **publish.yml** - Tunggu sampai SELESAI (status: ✓ success)
+2. ✅ **Setelah publish selesai**, baru trigger **re-pull.yml**
+
+**JANGAN trigger keduanya bersamaan!** Ini akan menyebabkan race condition karena re-pull akan menarik image yang belum selesai di-build.
+
+**Cara cek workflow selesai via GitHub CLI:**
+```bash
+gh run watch <publish_run_id>
+# Tunggu sampai ada checkmark ✓
+```

STRUKTUR-PROJEK.md

@@ -0,0 +1,678 @@
+# Dokumentasi Struktur Proyek - Desa Darmasaba
+
+## 1. Ringkasan Proyek
+
+**Desa Darmasaba** adalah aplikasi web komprehensif untuk layanan pemerintahan desa di Desa Darmasaba, Kabupaten Badung, Bali. Aplikasi ini berfungsi sebagai platform digital untuk layanan pemerintah, informasi publik, dan keterlibatan masyarakat.
+
+### Tech Stack
+
+| Kategori | Teknologi |
+|----------|-----------|
+| **Framework Frontend** | Next.js 15 dengan App Router |
+| **Bahasa** | TypeScript (strict mode) |
+| **Styling** | Mantine UI v7/v8 + Custom CSS |
+| **Backend API** | Elysia.js (high-performance TypeScript framework) |
+| **Database** | PostgreSQL |
+| **ORM** | Prisma 6.3.1 |
+| **Runtime** | Bun |
+| **State Management** | Jotai + Valtio + SWR |
+| **Autentikasi** | iron-session + JWT |
+| **File Storage** | Seafile |
+| **Rich Text Editor** | TipTap |
+| **Charts** | Recharts + Chart.js |
+| **Maps** | Leaflet + react-leaflet |
+| **UI Components** | Mantine, PrimeReact, Framer Motion |
+| **Validasi** | Zod |
+| **Testing** | Vitest (unit), Playwright (E2E) |
+| **Deployment** | Docker + GitHub Actions + Portainer |
+| **Registry** | GitHub Container Registry (GHCR) |
+
+---
+
+## 2. Struktur Direktori
+
+```
+desa-darmasaba/
+├── .github/workflows/           # GitHub Actions CI/CD
+│   ├── docker-publish.yml       # Auto build & push saat tag v*
+│   ├── publish.yml              # Manual build & push ke GHCR
+│   ├── re-pull.yml              # Manual re-pull image di Portainer
+│   └── script/                  # Script deployment
+│
+├── prisma/
+│   ├── schema.prisma            # Database schema (2413 baris, 100+ model)
+│   ├── seed.ts                  # Database seeder utama
+│   └── _seeder_list/            # Data seed per modul
+│       ├── desa/                # Seed berita, gallery, layanan, dll
+│       ├── ekonomi/             # Seed APBDes, demografi, dll
+│       ├── inovasi/             # Seed ide inovatif, desa digital
+│       ├── keamanan/            # Seed keamanan, kontak darurat
+│       ├── kesehatan/           # Seed fasilitas kesehatan, posyandu
+│       ├── kependudukan/        # Seed data penduduk
+│       ├── lingkungan/          # Seed lingkungan desa
+│       ├── pendidikan/          # Seed sekolah, beasiswa
+│       ├── ppid/                # Seed PPID
+│       └── landing-page/        # Seed landing page
+│
+├── src/
+│   ├── app/                     # Next.js App Router
+│   │   ├── _com/                # Komponen global (SplashScreen, WebVitals)
+│   │   ├── admin/               # Panel administrasi (protected)
+│   │   │   ├── _com/            # Komponen admin shared
+│   │   │   ├── (dashboard)/     # Dashboard admin dengan route groups
+│   │   │   │   ├── _com/        # Komponen dashboard shared
+│   │   │   │   ├── _state/      # State khusus dashboard
+│   │   │   │   ├── _utils/      # Utilitas dashboard
+│   │   │   │   ├── auth/        # Autentikasi admin
+│   │   │   │   ├── desa/        # Admin: berita, gallery, profil, layanan
+│   │   │   │   ├── ekonomi/     # Admin: APBDes, demografi, BUMDes
+│   │   │   │   ├── inovasi/     # Admin: ide inovatif, desa digital
+│   │   │   │   ├── keamanan/    # Admin: keamanan, kontak darurat
+│   │   │   │   ├── kependudukan/# Admin: banjar, agama, umur, migrasi
+│   │   │   │   ├── kesehatan/   # Admin: puskesmas, posyandu, wabah
+│   │   │   │   ├── landing-page/# Admin: konten landing page
+│   │   │   │   ├── lingkungan/  # Admin: konservasi, sampah, penghijauan
+│   │   │   │   ├── musik/       # Admin: musik desa
+│   │   │   │   ├── pendidikan/  # Admin: sekolah, beasiswa, perpustakaan
+│   │   │   │   ├── ppid/        # Admin: PPID, IKM, permohonan
+│   │   │   │   └── user&role/   # Admin: manajemen user & role
+│   │   │   ├── auth/            # Halaman login admin
+│   │   │   ├── csv/             # Upload/demo CSV
+│   │   │   ├── images/          # Manajemen gambar
+│   │   │   └── upload-demo/     # Demo upload
+│   │   │
+│   │   ├── api/                 # API routes (Elysia.js)
+│   │   │   ├── [[...slugs]]/    # Catch-all route untuk Elysia
+│   │   │   │   ├── _lib/        # Modul API per domain
+│   │   │   │   │   ├── auth/    # Autentikasi API
+│   │   │   │   │   ├── desa/    # API modul desa
+│   │   │   │   │   ├── ekonomi/ # API modul ekonomi
+│   │   │   │   │   ├── fileStorage/ # API file storage
+│   │   │   │   │   ├── inovasi/ # API modul inovasi
+│   │   │   │   │   ├── keamanan/# API modul keamanan
+│   │   │   │   │   ├── kependudukan/ # API modul kependudukan
+│   │   │   │   │   ├── kesehatan/    # API modul kesehatan
+│   │   │   │   │   ├── landing_page/ # API landing page
+│   │   │   │   │   ├── lingkungan/   # API modul lingkungan
+│   │   │   │   │   ├── pendidikan/   # API modul pendidikan
+│   │   │   │   │   ├── ppid/         # API modul PPID
+│   │   │   │   │   ├── search/       # API pencarian global
+│   │   │   │   │   └── user/         # API user management
+│   │   │   │   └── route.ts     # Entry point Elysia server
+│   │   │   ├── admin/           # API khusus admin
+│   │   │   ├── auth/            # API autentikasi
+│   │   │   ├── health/          # Health check endpoint
+│   │   │   ├── layout/          # API layout
+│   │   │   ├── news/            # API berita
+│   │   │   ├── subscribe/       # API subscription (email)
+│   │   │   └── tts/             # Text-to-Speech (ElevenLabs)
+│   │   │
+│   │   ├── context/             # React contexts
+│   │   │   └── MusicContext.tsx # Context untuk pemutar musik
+│   │   │
+│   │   ├── darmasaba/           # Halaman publik (front-facing)
+│   │   │   ├── _com/            # Komponen shared publik
+│   │   │   │   ├── main-page/   # Komponen halaman utama
+│   │   │   │   ├── Navbar.tsx   # Navigasi utama
+│   │   │   │   ├── Footer.tsx   # Footer
+│   │   │   │   ├── FixedPlayerBar.tsx # Music player bar
+│   │   │   │   ├── LoadDataFirstClient.tsx # Data prefetching
+│   │   │   │   ├── NewsReader.tsx # Component pembaca berita
+│   │   │   │   ├── globalSearch.tsx # Pencarian global
+│   │   │   │   └── scrollToTopButton.tsx
+│   │   │   ├── (pages)/         # Halaman publik utama
+│   │   │   │   ├── desa/        # Halaman: profil, berita, gallery, layanan
+│   │   │   │   ├── ekonomi/     # Halaman: APBDes, BUMDes, demografi
+│   │   │   │   ├── inovasi/     # Halaman: inovasi desa
+│   │   │   │   ├── keamanan/    # Halaman: keamanan lingkungan
+│   │   │   │   ├── kependudukan/# Halaman: data penduduk
+│   │   │   │   ├── kesehatan/   # Halaman: fasilitas kesehatan
+│   │   │   │   ├── lingkungan/  # Halaman: lingkungan desa
+│   │   │   │   ├── module/      # Halaman modul tambahan
+│   │   │   │   ├── musik/       # Halaman: musik desa
+│   │   │   │   ├── pendidikan/  # Halaman: pendidikan
+│   │   │   │   └── ppid/        # Halaman: PPID publik
+│   │   │   ├── (tambahan)/      # Halaman tambahan
+│   │   │   ├── layout.tsx       # Layout utama publik
+│   │   │   └── page.tsx         # Landing page utama
+│   │   │
+│   │   ├── login/               # Halaman login
+│   │   ├── registrasi/          # Halaman registrasi
+│   │   ├── waiting-room/        # Halaman waiting room
+│   │   ├── terms-of-service/    # Halaman syarat layanan
+│   │   ├── test-upload/         # Halaman tes upload
+│   │   ├── validasi/            # Halaman validasi
+│   │   ├── coba/                # Halaman percobaan
+│   │   ├── percobaan/           # Halaman percobaan lainnya
+│   │   ├── layout.tsx           # Root layout (MantineProvider)
+│   │   ├── page.tsx             # Root page
+│   │   ├── error.tsx            # Error boundary
+│   │   ├── not-found.tsx        # 404 page
+│   │   ├── globals.css          # Global styles
+│   │   └── favicon.ico
+│   │
+│   ├── components/
+│   │   └── admin/               # Komponen admin reusable
+│   │       ├── AdminThemeProvider.tsx
+│   │       ├── DarkModeToggle.tsx
+│   │       ├── UnifiedSurface.tsx
+│   │       └── UnifiedTypography.tsx
+│   │
+│   ├── con/                     # Constants & konfigurasi
+│   │   └── colors.ts            # Palet warna
+│   │
+│   ├── lib/                     # Utility functions
+│   │   ├── router/              # Router utilities
+│   │   ├── api-auth.ts          # Autentikasi API
+│   │   ├── api-fetch.ts         # Helper fetch API
+│   │   ├── EnvStringParse.ts    # Parser environment variables
+│   │   ├── prisma.ts            # Prisma client instance
+│   │   ├── seafile-auth-service.ts # Integrasi Seafile
+│   │   └── session.ts           # iron-session helper
+│   │
+│   ├── middlewares/             # Next.js middleware
+│   ├── state/                   # Global state (Jotai/Valtio)
+│   │   ├── darkModeStore.ts     # State dark mode
+│   │   ├── state-layanan.ts     # State layanan
+│   │   ├── state-list-image.ts  # State daftar gambar
+│   │   └── state-nav.ts         # State navigasi
+│   │
+│   ├── store/                   # State management tambahan
+│   └── types/                   # TypeScript type definitions
+│
+├── public/                      # Static assets
+│   └── assets/                  # Gambar, icon, dll
+│
+├── uploads/                     # Directory upload (runtime)
+│   └── image/                   # Upload gambar
+│
+├── .env.example                 # Contoh environment variables
+├── .gitignore
+├── AGENTS.md                    # Panduan untuk AI coding agents
+├── Dockerfile                   # Docker image definition
+├── docker-entrypoint.sh         # Entry point container
+├── next.config.ts               # Next.js configuration
+├── package.json                 # Dependencies & scripts
+├── tsconfig.json                # TypeScript configuration
+├── biome.json                   # Biome linter config
+├── eslint.config.mjs            # ESLint config
+├── NOTE.md                      # Catatan deployment
+└── QWEN.md                      # Konteks & memori proyek
+```
+
+---
+
+## 3. Arsitektur Aplikasi
+
+### 3.1 Arsitektur Keseluruhan
+
+```
+┌─────────────────────────────────────────────────────────┐
+│                    Client (Browser)                      │
+└────────────┬────────────────────────────┬────────────────┘
+             │                            │
+             │  Next.js Pages             │  API Calls
+             │  (SSR/CSR)                 │
+             ▼                            ▼
+┌────────────────────────┐    ┌────────────────────────────┐
+│   Next.js 15 App Router│    │   Elysia.js API Server     │
+│   - Pages publik       │    │   - RESTful endpoints      │
+│   - Admin dashboard    │    │   - File upload            │
+│   - Server components  │    │   - Swagger docs (/api/docs│
+│   - Client components  │    │   - Static file serving    │
+└────────────┬───────────┘    └────────────┬───────────────┘
+             │                             │
+             │                             │
+             ▼                             ▼
+┌─────────────────────────────────────────────────────────┐
+│                    PostgreSQL Database                   │
+│                    (via Prisma ORM)                      │
+└─────────────────────────────────────────────────────────┘
+             │
+             ▼
+┌─────────────────────────────────────────────────────────┐
+│                    Seafile File Storage                  │
+│                    (Images & Documents)                  │
+└─────────────────────────────────────────────────────────┘
+```
+
+### 3.2 Next.js App Router
+
+- Menggunakan **App Router** (bukan Pages Router)
+- Route groups `(dashboard)`, `(pages)`, `(tambahan)` untuk organisasi tanpa mempengaruhi URL
+- Layout bersarang: root layout -> admin/darmasaba layout -> page layouts
+- `force-dynamic` digunakan untuk menghindari error prerendering
+- View Transitions API diaktifkan via `next-view-transitions`
+
+### 3.3 Elysia.js API Server
+
+- Terintegrasi sebagai **catch-all route** di `/api/[[...slugs]]/route.ts`
+- Semua HTTP methods (GET, POST, PATCH, DELETE, PUT) di-handle oleh Elysia
+- Plugin yang digunakan:
+  - `@elysiajs/cors` - CORS configuration
+  - `@elysiajs/static` - Static file serving dari `/uploads`
+  - `@elysiajs/swagger` - API documentation di `/api/docs`
+  - `@elysiajs/jwt` - JWT authentication
+  - `@elysiajs/cookie` - Cookie handling
+- Endpoint file upload: `/api/upl-img`, `/api/upl-img-single`, `/api/upl-csv`
+- Image serving: `/api/img/:name` dengan resize support
+
+### 3.4 Rendering Strategy
+
+- **Server Components**: Halaman publik untuk SEO optimal
+- **Client Components**: Komponen interaktif (form, state, animasi)
+- **Force Dynamic**: Beberapa halaman menggunakan `force-dynamic`
+- **ISR**: Caching header untuk assets (1 jam cache)
+
+---
+
+## 4. Modul Domain
+
+### 4.1 Profil Desa (Desa)
+**Admin**: `/admin/desa/*` | **Publik**: `/darmasaba/desa/*`
+
+| Sub-modul | Fungsi |
+|-----------|--------|
+| `berita` | CRUD berita/pengumuman desa |
+| `gallery` | Galeri foto dan video |
+| `layanan` | Manajemen layanan desa |
+| `penghargaan` | Penghargaan yang diraih |
+| `pengumuman` | Pengumuman publik |
+| `potensi` | Potensi desa (pertanian, pariwisata, dll) |
+| `profil` | Profil desa (sejarah, visi misi, lambang, maskot, perangkat) |
+
+### 4.2 PPID (Pejabat Pengelola Informasi dan Dokumentasi)
+**Admin**: `/admin/ppid/*` | **Publik**: `/darmasaba/ppid/*`
+
+| Sub-modul | Fungsi |
+|-----------|--------|
+| `profil-ppid` | Profil pejabat PPID |
+| `struktur-ppid` | Struktur organisasi PPID |
+| `visi-misi-ppid` | Visi dan misi PPID |
+| `daftar-informasi-publik` | Daftar informasi yang tersedia |
+| `dasar-hukum` | Dasar hukum PPID |
+| `permohonan-informasi-publik` | Form permohonan informasi |
+| `permohonan-keberatan-informasi-publik` | Form keberatan |
+| `indeks-kepuasan-masyarakat` | Survei kepuasan masyarakat (IKM) |
+
+### 4.3 Kesehatan
+**Admin**: `/admin/kesehatan/*` | **Publik**: `/darmasaba/kesehatan/*`
+
+| Sub-modul | Fungsi |
+|-----------|--------|
+| `fasilitas-kesehatan` | Data puskesmas, klinik, dokter |
+| `posyandu` | Manajemen posyandu |
+| `program-kesehatan` | Program kesehatan desa |
+| `info-wabah-penyakit` | Informasi wabah |
+| `penanganan-darurat` | Prosedur penanganan darurat |
+| `kontak-darurat` | Kontak darurat kesehatan |
+| `data-kesehatan-warga` | Statistik kesehatan warga |
+| `artikel-kesehatan` | Artikel kesehatan |
+
+### 4.4 Ekonomi
+**Admin**: `/admin/ekonomi/*` | **Publik**: `/darmasaba/ekonomi/*`
+
+| Sub-modul | Fungsi |
+|-----------|--------|
+| `APBDes` | Anggaran Pendapatan dan Belanja Desa (hierarki items + realisasi) |
+| `PADesa-pendapatan-asli-desa` | Pendapatan asli desa |
+| `demografi-pekerjaan` | Demografi pekerjaan penduduk |
+| `jumlah-penduduk-miskin` | Data penduduk miskin |
+| `jumlah-pengangguran` | Data pengangguran |
+| `lowongan-kerja-lokal` | Lowongan kerja lokal |
+| `pasar-desa` | Data pasar desa |
+| `program-kemiskinan` | Program penanganan kemiskinan |
+| `sektor-unggulan-desa` | Sektor unggulan ekonomi |
+| `Struktur-Organisasi-Dan-Sk-Pengurus-BumDes` | Struktur BUMDes |
+
+### 4.5 Kependudukan
+**Admin**: `/admin/kependudukan/*` | **Publik**: `/darmasaba/kependudukan/*`
+
+| Sub-modul | Fungsi |
+|-----------|--------|
+| `data-banjar` | Data banjar (unit wilayah tradisional Bali) |
+| `distribusi-agama` | Distribusi agama penduduk |
+| `distribusi-umur` | Distribusi umur penduduk |
+| `migrasi-penduduk` | Data migrasi (masuk/keluar) |
+
+### 4.6 Pendidikan
+**Admin**: `/admin/pendidikan/*` | **Publik**: `/darmasaba/pendidikan/*`
+
+| Sub-modul | Fungsi |
+|-----------|--------|
+| `beasiswa-desa` | Program beasiswa |
+| `bimbingan-belajar-desa` | Bimbingan belajar |
+| `data-pendidikan` | Data statistik pendidikan |
+| `info-sekolah` | Informasi sekolah |
+| `pendidikan-non-formal` | Pendidikan non-formal |
+| `perpustakaan-digital` | Perpustakaan digital |
+| `program-pendidikan-anak` | Program pendidikan anak |
+
+### 4.7 Keamanan
+**Admin**: `/admin/keamanan/*` | **Publik**: `/darmasaba/keamanan/*`
+
+| Sub-modul | Fungsi |
+|-----------|--------|
+| `keamanan-lingkungan-pecalang-patwal` | Keamanan lingkungan (pecalang Bali) |
+| `kontak-darurat` | Kontak darurat keamanan |
+| `laporan-publik` | Laporan publik |
+| `pencegahan-kriminalitas` | Pencegahan kriminalitas |
+| `polsek-terdekat` | Data polsek terdekat |
+| `tips-keamanan` | Tips keamanan |
+
+### 4.8 Lingkungan
+**Admin**: `/admin/lingkungan/*` | **Publik**: `/darmasaba/lingkungan/*`
+
+| Sub-modul | Fungsi |
+|-----------|--------|
+| `data-lingkungan-desa` | Data lingkungan desa |
+| `edukasi-lingkungan` | Edukasi lingkungan |
+| `gotong-royong` | Kegiatan gotong royong |
+| `konservasi-adat-bali` | Konservasi adat Bali |
+| `pengelolaan-sampah-bank-sampah` | Bank sampah |
+| `program-penghijauan` | Program penghijauan |
+
+### 4.9 Inovasi
+**Admin**: `/admin/inovasi/*` | **Publik**: `/darmasaba/inovasi/*`
+
+| Sub-modul | Fungsi |
+|-----------|--------|
+| `ajukan-ide-inovatif` | Form pengajuan ide inovatif |
+| `desa-digital-smart-village` | Program desa digital |
+| `info-teknologi-tepat-guna` | Info teknologi tepat guna |
+| `kolaborasi-inovasi` | Kolaborasi inovasi |
+| `layanan-online-desa` | Layanan online desa |
+| `program-kreatif-desa` | Program kreatif desa |
+
+### 4.10 Musik Desa
+**Admin**: `/admin/musik/*` | **Publik**: `/darmasaba/musik/*`
+
+- Manajemen audio dan cover musik desa
+- Fixed player bar di halaman publik
+- Context provider untuk state pemutar musik
+
+### 4.11 Landing Page
+**Admin**: `/admin/landing-page/*`
+
+| Sub-modul | Fungsi |
+|-----------|--------|
+| `desa-anti-korupsi` | Konten anti-korupsi |
+| `prestasi-desa` | Prestasi yang diraih |
+| `sdgs-desa` | SDGs (Sustainable Development Goals) |
+| `profil-landing-page` | Profil dan media sosial |
+
+### 4.12 User & Role
+**Admin**: `/admin/user&role/*`
+
+- Manajemen pengguna admin
+- Manajemen role dan permission
+- Manajemen menu akses
+
+---
+
+## 5. Database Schema
+
+### 5.1 Overview
+
+Database menggunakan **PostgreSQL** dengan **Prisma ORM** (versi 6.3.1).
+Schema terdiri dari **2413 baris** dengan **100+ model**.
+
+### 5.2 Model Utama
+
+#### FileStorage
+Model sentral untuk semua file (gambar, dokumen, audio):
+```prisma
+model FileStorage {
+  id           String   @id @default(cuid())
+  name         String   @unique
+  realName     String
+  path         String
+  mimeType     String
+  category     String   // "image" / "document" / "audio" / "other"
+  link         String
+  isActive     Boolean  @default(true)
+  // Relasi ke 50+ model lain (Berita, PotensiDesa, GalleryFoto, dll)
+}
+```
+
+#### AppMenu & AppMenuChild
+Menu navigasi aplikasi:
+```prisma
+model AppMenu {
+  id           String         @id @default(cuid())
+  name         String         @unique
+  link         String
+  isActive     Boolean        @default(true)
+  AppMenuChild AppMenuChild[]
+}
+```
+
+#### User & Role (Autentikasi Admin)
+- `User` - Data pengguna admin
+- `Role` - Role/peran pengguna
+- `Menu` - Menu akses per role
+
+#### Modul Desa
+- `Berita` - Berita desa (dengan featured image & gallery)
+- `GalleryFoto` / `GalleryVideo` - Galeri media
+- `Layanan` - Layanan desa
+- `Pengumuman` - Pengumuman
+- `PotensiDesa` - Potensi desa
+- `ProfileDesaImage` - Gambar profil desa
+- `ProfilPerbekel` - Profil perbekel (kepala desa)
+- `PejabatDesa` - Pejabat desa
+- `Penghargaan` - Penghargaan
+- `PrestasiDesa` - Prestasi
+- `MediaSosial` - Media sosial desa
+
+#### Modul PPID
+- `StrukturPPID` - Struktur organisasi
+- `PosisiOrganisasiPPID` - Posisi dengan hierarki
+- `PegawaiPPID` - Data pegawai
+- `ProfilePPID` - Profil PPID
+- `VisiMisiPPID` - Visi misi
+- `DasarHukumPPID` - Dasar hukum
+- `DaftarInformasiPublik` - Daftar informasi
+- `PermohonanInformasiPublik` - Permohonan informasi
+- `FormulirPermohonanKeberatan` - Formulir keberatan
+- `IndeksKepuasanMasyarakat` - IKM
+- `Responden` + lookup tables - Data responden IKM
+
+#### Modul Kesehatan
+- `Puskesmas` - Data puskesmas
+- `Posyandu` - Data posyandu
+- `ProgramKesehatan` - Program kesehatan
+- `FasilitasKesehatan` - Fasilitas
+- `InfoWabahPenyakit` - Info wabah
+- `PenangananDarurat` - Penanganan darurat
+- `KontakDarurat` - Kontak darurat
+- `ArtikelKesehatan` - Artikel
+
+#### Modul Ekonomi
+- `APBDes` & `APBDesItem` - Anggaran desa (hierarki tree structure)
+- `RealisasiItem` - Realisasi anggaran (multiple per item)
+- `PasarDesa` - Pasar desa
+- `PegawaiBumDes` - Pegawai BUMDes
+- `StrukturBumDes` - Struktur BUMDes
+- `DemografiPekerjaan` - Demografi pekerjaan
+- `JumlahPendudukMiskin` - Data kemiskinan
+- `JumlahPengangguran` - Data pengangguran
+- `LowonganKerjaLokal` - Lowongan kerja
+- `ProgramKemiskinan` - Program kemiskinan
+- `SektorUnggulanDesa` - Sektor unggulan
+- `PendapatanAsli` - Pendapatan asli desa
+
+#### Modul Kependudukan
+- `DataBanjar` - Data banjar
+- `DistribusiAgama` - Distribusi agama
+- `DistribusiUmur` - Distribusi umur
+- `MigrasiPenduduk` - Migrasi
+
+#### Modul Pendidikan
+- `InfoSekolah` - Data sekolah
+- `BeasiswaDesa` - Beasiswa
+- `BimbinganBelajar` - Bimbingan belajar
+- `PendidikanNonFormal` - Pendidikan non-formal
+- `DataPerpustakaan` - Perpustakaan
+
+#### Modul Keamanan
+- `KeamananLingkungan` - Keamanan lingkungan
+- `MenuTipsKeamanan` - Tips keamanan
+- `PencegahanKriminalitas` - Pencegahan kriminalitas
+- `PolsekTerdekat` - Polsek terdekat
+- `LaporanPublik` - Laporan publik
+
+#### Modul Lingkungan
+- `DataLingkunganDesa` - Data lingkungan
+- `KonservasiAdatBali` - Konservasi adat
+- `BankSampah` - Bank sampah
+- `ProgramPenghijauan` - Penghijauan
+- `GotongRoyong` - Gotong royong
+- `EdukasiLingkungan` - Edukasi
+
+#### Modul Inovasi
+- `ProgramInovasi` - Program inovasi
+- `DesaDigital` - Desa digital
+- `InfoTekno` - Info teknologi
+- `KolaborasiInovasi` + `MitraKolaborasi` - Kolaborasi
+- `LayananOnlineDesa` - Layanan online
+- `ProgramKreatifDesa` - Program kreatif
+- `Ajukan` - Pengajuan ide
+
+#### Modul Musik
+- `MusikDesa` - Musik desa
+  - `audioFile` -> FileStorage
+  - `coverImage` -> FileStorage
+
+#### Landing Page
+- `DesaAntiKorupsi` + `KategoriDesaAntiKorupsi`
+- `SdgsDesa` - SDGs
+- `PrestasiDesa` + `KategoriPrestasiDesa`
+- `MediaSosial`
+- `LandingPage_Layanan`
+
+#### APBDes (Struktur Hierarki)
+```prisma
+model APBDesItem {
+  kode           String       // "4", "4.1", "4.1.2"
+  uraian         String       // Nama item
+  anggaran       Float        // Anggaran dalam Rupiah
+  tipe           String?      // "pendapatan" | "belanja" | "pembiayaan"
+  level          Int          // 1, 2, 3
+  parentId       String?      // Self-referencing untuk tree
+  children       APBDesItem[]
+  totalRealisasi Float        @default(0)  // Auto-calculated
+  selisih        Float        @default(0)  // totalRealisasi - anggaran
+  persentase     Float        @default(0)  // (totalRealisasi / anggaran) * 100
+  realisasiItems RealisasiItem[]
+}
+```
+
+### 5.3 Pola Umum Model
+
+Hampir semua model mengikuti pola:
+```prisma
+model Contoh {
+  id        String   @id @default(cuid())
+  // ... fields
+  createdAt DateTime @default(now())
+  updatedAt DateTime @updatedAt
+  deletedAt DateTime? @default(now())  // Soft delete
+  isActive  Boolean  @default(true)    // Soft delete flag
+}
+```
+
+---
+
+## 6. API Routes
+
+### 6.1 Struktur API
+
+Semua API routes ditangani oleh **Elysia.js** di `/src/app/api/[[...slugs]]/route.ts`
+
+### 6.2 API Groups
+
+| Prefix | Modul | Contoh Endpoints |
+|--------|-------|------------------|
+| `/api/layanan` | Layanan | `GET /api/layanan` |
+| `/api/potensi` | Potensi | `GET /api/potensi` |
+| `/api/desa/*` | Desa | CRUD berita, gallery, profil, dll |
+| `/api/ppid/*` | PPID | CRUD struktur, profil, permohonan |
+| `/api/kesehatan/*` | Kesehatan | CRUD puskesmas, posyandu, dll |
+| `/api/ekonomi/*` | Ekonomi | CRUD APBDes, BUMDes, demografi |
+| `/api/kependudukan/*` | Kependudukan | CRUD banjar, demografi |
+| `/api/pendidikan/*` | Pendidikan | CRUD sekolah, beasiswa |
+| `/api/keamanan/*` | Keamanan | CRUD keamanan, kontak darurat |
+| `/api/lingkungan/*` | Lingkungan | CRUD data lingkungan |
+| `/api/inovasi/*` | Inovasi | CRUD program inovasi |
+| `/api/landing-page/*` | Landing Page | CRUD konten landing page |
+| `/api/user/*` | User | CRUD user admin |
+| `/api/user/role/*` | Role | CRUD role & permission |
+| `/api/search` | Search | Pencarian global |
+| `/api/file-storage/*` | File Storage | CRUD file storage |
+| `/api/img/:name` | Image | GET gambar dengan resize |
+| `/api/upl-img` | Upload | Upload multiple images |
+| `/api/upl-img-single` | Upload | Upload single image |
+| `/api/upl-csv` | Upload | Upload CSV files |
+| `/api/utils/version` | Utils | GET versi aplikasi |
+
+### 6.3 API Documentation
+
+Swagger UI tersedia di: **`/api/docs`**
+
+### 6.4 API Route Lainnya
+
+| Route | Fungsi |
+|-------|--------|
+| `/api/health` | Health check endpoint |
+| `/api/news` | API berita (standalone) |
+| `/api/subscribe` | Subscription email |
+| `/api/tts` | Text-to-Speech (ElevenLabs) |
+| `/api/admin/*` | API khusus admin |
+| `/api/auth/*` | API autentikasi |
+
+---
+
+## 7. Halaman Admin
+
+### 7.1 Struktur
+
+Admin dashboard berada di `/admin` dengan route group `(dashboard)`.
+
+| Section | Path | Fungsi |
+|---------|------|--------|
+| **Dashboard** | `/admin` | Dashboard utama |
+| **Autentikasi** | `/admin/auth` | Login admin |
+| **Desa** | `/admin/desa/*` | Berita, gallery, profil, layanan, penghargaan, pengumuman, potensi |
+| **PPID** | `/admin/ppid/*` | Profil, struktur, visi-misi, daftar informasi, dasar hukum, permohonan, IKM |
+| **Kesehatan** | `/admin/kesehatan/*` | Puskesmas, posyandu, program kesehatan, wabah, kontak darurat |
+| **Ekonomi** | `/admin/ekonomi/*` | APBDes, PAD, demografi, pengangguran, kemiskinan, BUMDes, pasar desa |
+| **Kependudukan** | `/admin/kependudukan/*` | Banjar, distribusi agama, distribusi umur, migrasi |
+| **Pendidikan** | `/admin/pendidikan/*` | Sekolah, beasiswa, bimbingan belajar, perpustakaan digital |
+| **Keamanan** | `/admin/keamanan/*` | Keamanan lingkungan, kontak darurat, pencegahan kriminalitas, polsek |
+| **Lingkungan** | `/admin/lingkungan/*` | Data lingkungan, konservasi, bank sampah, penghijauan, gotong royong |
+| **Inovasi** | `/admin/inovasi/*` | Ide inovatif, desa digital, teknologi tepat guna, kolaborasi |
+| **Musik** | `/admin/musik/*` | Manajemen musik desa |
+| **Landing Page** | `/admin/landing-page/*` | Anti-korupsi, prestasi, SDGs, media sosial |
+| **User & Role** | `/admin/user&role/*` | Manajemen user dan role |
+| **Images** | `/admin/images/*` | Manajemen gambar |
+| **CSV** | `/admin/csv/*` | Upload/import CSV |
+
+### 7.2 Komponen Admin Shared
+
+- `AdminThemeProvider.tsx` - Theme provider untuk dark/light mode
+- `DarkModeToggle.tsx` - Toggle dark mode
+- `UnifiedSurface.tsx` - Komponen surface/card unified
+- `UnifiedTypography.tsx` - Tipografi unified
+
+---
+
+## 8. Halaman Publik
+
+### 8.1 Struktur
+
+Halaman publik berada di `/darmasaba` dengan layout yang mencakup Navbar, Footer, dan Fixed Music Player.
+
+| Halaman | Path | Konten |
+|---------|------|--------|
+| **Landing Page

STRUKTUR.md

@@ -0,0 +1,842 @@
+# Dokumentasi Struktur Proyek Desa Darmasaba
+
+## 1. Ringkasan Proyek
+
+**Desa Darmasaba** adalah aplikasi web manajemen desa digital untuk Desa Darmasaba, Kabupaten Badung, Bali. Aplikasi ini berfungsi sebagai platform layanan publik digital yang mencakup informasi pemerintahan, layanan kesehatan, keamanan, pendidikan, ekonomi, lingkungan, dan inovasi desa.
+
+### Tech Stack
+
+| Kategori | Teknologi |
+|----------|-----------|
+| **Framework** | Next.js 15 (App Router) |
+| **Language** | TypeScript (strict mode) |
+| **Runtime** | Bun |
+| **Backend API** | Elysia.js (high-performance HTTP server) |
+| **Database** | PostgreSQL |
+| **ORM** | Prisma 6.3.1 |
+| **UI Framework** | Mantine UI v7-v8 |
+| **State Management** | Jotai + Valtio + SWR |
+| **Authentication** | iron-session + JWT (@elysiajs/jwt) |
+| **File Storage** | Seafile (self-hosted) |
+| **Text Editor** | Tiptap (Rich text editor) |
+| **Charts** | Recharts + Chart.js |
+| **Maps** | Leaflet + react-leaflet |
+| **Testing** | Vitest (unit) + Playwright (E2E) |
+| **Styling** | Mantine + PostCSS + Framer Motion |
+| **Deployment** | Docker + GHCR + Portainer + GitHub Actions |
+| **Version** | 0.1.11 |
+
+---
+
+## 2. Struktur Direktori
+
+```
+desa-darmasaba/
+├── .github/workflows/          # GitHub Actions CI/CD
+│   ├── docker-publish.yml     # Auto build & push saat tag v*
+│   ├── publish.yml            # Manual build & push ke GHCR
+│   ├── re-pull.yml            # Manual re-pull di Portainer
+│   └── script/                # Shell scripts untuk deploy
+├── prisma/
+│   ├── schema.prisma          # Database schema (2413 baris, 100+ model)
+│   └── seed.ts                # Database seeder (400+ baris)
+│       └── _seeder_list/      # Seed data per modul
+├── public/                     # Static assets
+│   └── assets/
+│       └── images/
+├── src/
+│   ├── app/                    # Next.js App Router
+│   │   ├── _com/              # Global components (SplashScreen, WebVitals)
+│   │   ├── admin/             # ADMIN DASHBOARD
+│   │   │   ├── (dashboard)/   # Route group dashboard
+│   │   │   │   ├── desa/      #   - Berita, Gallery, Layanan, dll
+│   │   │   │   ├── ppid/      #   - Informasi publik, struktur, dasar hukum
+│   │   │   │   ├── kesehatan/ #   - Fasilitas, posyandu, puskesmas, wabah
+│   │   │   │   ├── ekonomi/   #   - APBDes, pasar desa, BUMDes, dll
+│   │   │   │   ├── kependudukan/ # - Banjar, agama, umur, migrasi
+│   │   │   │   ├── pendidikan/ # - Sekolah, beasiswa, perpustakaan
+│   │   │   │   ├── keamanan/  #   - Keamanan lingkungan, polsek, dll
+│   │   │   │   ├── lingkungan/ # - Sampah, penghijauan, gotong royong
+│   │   │   │   ├── inovasi/   #   - Desa digital, kolaborasi, dll
+│   │   │   │   ├── landing-page/ # - Profil, prestasi, anti-korupsi
+│   │   │   │   ├── musik/     #   - Musik desa
+│   │   │   │   ├── user&role/ #   - Manajemen user & role
+│   │   │   │   └── _com/      #   - Shared admin components
+│   │   │   ├── auth/          # Login OTP untuk admin
+│   │   │   ├── csv/           # Demo CSV upload
+│   │   │   └── layout.tsx     # Admin shell (AppShell Mantine)
+│   │   ├── api/                # ELYSIA.JS API SERVER
+│   │   │   ├── [[...slugs]]/  # Catch-all route -> Elysia handler
+│   │   │   │   ├── route.ts   #   - Main Elysia server export
+│   │   │   │   └── _lib/      #   - Domain route modules
+│   │   │   │       ├── desa.ts
+│   │   │   │       ├── ppid.ts
+│   │   │   │       ├── kesehatan.ts
+│   │   │   │       ├── ekonomi.ts
+│   │   │   │       ├── keamanan.ts
+│   │   │   │       ├── inovasi.ts
+│   │   │   │       ├── lingkungan.ts
+│   │   │   │       ├── pendidikan.ts
+│   │   │   │       ├── kependudukan.ts
+│   │   │   │       ├── landing_page.ts
+│   │   │   │       ├── user/  #   - User & Role management
+│   │   │   │       ├── fileStorage/
+│   │   │   │       ├── search/
+│   │   │   │       ├── auth/
+│   │   │   │       ├── upl-img.ts, upl-img-single.ts
+│   │   │   │       ├── upl-csv.ts, upl-csv-single.ts
+│   │   │   │       └── img.ts, img-del.ts, imgs.ts
+│   │   │   ├── auth/          # Auth endpoints (login, logout, me)
+│   │   │   └── ...            # Other API routes
+│   │   ├── darmasaba/         # PUBLIC-FACING WEBSITE
+│   │   │   ├── _com/          # Shared components (Navbar, Footer, etc)
+│   │   │   ├── (pages)/       # Public pages route group
+│   │   │   │   ├── desa/      #   - Profil, berita, gallery, layanan
+│   │   │   │   ├── ppid/      #   - PPID public pages
+│   │   │   │   ├── kesehatan/ #   - Health info pages
+│   │   │   │   ├── ekonomi/   #   - Economy pages
+│   │   │   │   ├── kependudukan/
+│   │   │   │   ├── pendidikan/
+│   │   │   │   ├── keamanan/
+│   │   │   │   ├── lingkungan/
+│   │   │   │   ├── inovasi/
+│   │   │   │   ├── musik/
+│   │   │   │   └── module/    #   - External module links
+│   │   │   └── (tambahan)/    # Additional pages
+│   │   ├── login/             # Login page
+│   │   ├── registrasi/        # Registration page
+│   │   ├── waiting-room/      # Waiting room (inactive users)
+│   │   ├── terms-of-service/
+│   │   ├── layout.tsx         # Root layout (MantineProvider, ViewTransitions)
+│   │   └── page.tsx           # Homepage redirect
+│   ├── components/
+│   │   └── admin/             # Admin shared components
+│   │       ├── AdminThemeProvider.tsx
+│   │       ├── DarkModeToggle.tsx
+│   │       ├── UnifiedSurface.tsx
+│   │       └── UnifiedTypography.tsx
+│   ├── con/                   # Constants & configuration
+│   │   ├── colors.ts          # Color palette definitions
+│   │   ├── images.ts
+│   │   ├── navbar-list-menu.ts
+│   │   ├── router.ts          # Route mapping
+│   │   └── sosmed.ts
+│   ├── context/               # React contexts
+│   │   └── MusicContext.tsx   # Music player context
+│   ├── hooks/                 # Custom React hooks
+│   ├── lib/                   # Utility libraries
+│   │   ├── router/
+│   │   ├── api-auth.ts        # API authentication helpers
+│   │   ├── api-fetch.ts       # API fetch wrapper
+│   │   ├── EnvStringParse.ts
+│   │   ├── prisma.ts          # Prisma client singleton
+│   │   ├── seafile-auth-service.ts
+│   │   └── session.ts         # iron-session helper
+│   ├── state/                 # Global state (Jotai/Valtio)
+│   │   ├── darkModeStore.ts
+│   │   ├── state-layanan.ts
+│   │   ├── state-list-image.ts
+│   │   └── state-nav.ts
+│   ├── store/                 # Additional stores
+│   │   └── authStore.ts       # Auth state (Jotai)
+│   ├── types/                 # TypeScript type definitions
+│   └── utils/                 # Utility functions
+│       └── themeTokens.ts     # Dark/light theme tokens
+├── uploads/                   # Local upload directory (images/files)
+├── Dockerfile                 # Multi-stage Docker build (Bun)
+├── docker-entrypoint.sh       # Entry script (migrate + start)
+├── next.config.ts             # Next.js configuration
+├── package.json               # Dependencies & scripts
+├── tsconfig.json              # TypeScript configuration
+├── biome.json                 # Biome linter config
+├── eslint.config.mjs          # ESLint config
+├── NOTE.md                    # Deployment notes
+├── QWEN.md                    # Project memory & workflow
+└── AGENTS.md                  # Agent coding guidelines
+```
+
+---
+
+## 3. Arsitektur
+
+### Pola Arsitektur: Full-Stack Monolith dengan App Router
+
+```
+Browser
+  |
+  +-- Next.js 15 (App Router) -- Server Components + Client Components
+        |
+        +-- /darmasaba/*         -> Public pages (SSR/CSR)
+        +-- /admin/*             -> Admin dashboard (protected)
+        +-- /api/*               -> Elysia.js API server
+              |
+              +-- Elysia Server (src/app/api/[[...slugs]]/route.ts)
+                    |
+                    +-- CORS enabled
+                    +-- Swagger docs di /api/docs
+                    +-- Static file serving (/api/uploads)
+                    +-- Domain modules: Desa, PPID, Kesehatan, Ekonomi, dll
+                    +-- Image upload handlers
+                    |
+                    +-- Prisma ORM --> PostgreSQL
+                    +-- Seafile API  --> File Storage
+```
+
+### Key Architectural Decisions:
+
+1. **Next.js 15 App Router**: Menggunakan React Server Components sebagai default, dengan `"use client"` untuk interaktivitas
+2. **Elysia.js di dalam API Routes**: Catch-all route `[[...slugs]]` meneruskan semua request ke Elysia handler
+3. **Route Groups**: `(dashboard)` dan `(pages)` untuk organisasi tanpa mempengaruhi URL path
+4. **Multi-tenant Ready**: Role-based access control dengan dynamic navbar berdasarkan roleId
+5. **File Uploads**: Local uploads + Seafile integration untuk distributed storage
+
+---
+
+## 4. Modul Domain
+
+### A. PPID (Pejabat Pengelola Informasi dan Dokumentasi)
+**Lokasi**: `src/app/admin/(dashboard)/ppid/` dan `src/app/darmasaba/(pages)/ppid/`
+
+| Sub-modul | Deskripsi |
+|-----------|-----------|
+| Profil PPID | Profil pejabat pengelola informasi |
+| Struktur PPID | Struktur organisasi PPID dengan hierarki |
+| Visi & Misi PPID | Visi dan misi PPID desa |
+| Daftar Informasi Publik | Katalog informasi publik yang tersedia |
+| Dasar Hukum | Regulasi dan dasar hukum PPID |
+| Permohonan Informasi Publik | Form permohonan informasi (NIK, kontak, jenis) |
+| Permohonan Keberatan | Formulir keberatan informasi |
+| Indeks Kepuasan Masyarakat | Survey kepuasan dengan grafik demografis |
+
+### B. Desa (Landing Page & Umum)
+**Lokasi**: `src/app/admin/(dashboard)/desa/` dan `src/app/darmasaba/(pages)/desa/`
+
+| Sub-modul | Deskripsi |
+|-----------|-----------|
+| Profil Desa | Sejarah, visi-misi, lambang, maskot |
+| Profil Perbekel | Biodata, pengalaman, program unggulan perbekel |
+| Perbekel dari Masa ke Masa | Historis perbekel per periode |
+| Berita | Artikel berita dengan kategori & multi-image |
+| Gallery | Foto dan video galeri |
+| Pengumuman | Pengumuman desa dengan kategori |
+| Potensi Desa | Potensi desa dengan kategori |
+| Layanan Desa | Surat keterangan, ajukan permohonan |
+| Penghargaan | Prestasi dan penghargaan desa |
+| Desa Anti Korupsi | Transparansi anti-korupsi |
+| SDGs Desa | Sustainable Development Goals desa |
+| APBDes | Anggaran desa dengan hierarki item & realisasi |
+| Prestasi Desa | Katalog prestasi |
+
+### C. Kesehatan
+**Lokasi**: `src/app/admin/(dashboard)/kesehatan/` dan `src/app/darmasaba/(pages)/kesehatan/`
+
+| Sub-modul | Deskripsi |
+|-----------|-----------|
+| Fasilitas Kesehatan | Info rumah sakit/klinik (jam, dokter, tarif) |
+| Puskesmas | Data puskesmas dengan jam operasional & kontak |
+| Posyandu | Jadwal dan informasi posyandu |
+| Program Kesehatan | Program-program kesehatan desa |
+| Penanganan Darurat | Prosedur penanganan darurat |
+| Kontak Darurat | Kontak emergency dengan WhatsApp |
+| Info Wabah Penyakit | Informasi wabah penyakit |
+| Artikel Kesehatan | Artikel kesehatan lengkap |
+| Data Kesehatan Warga | Statistik kesehatan warga |
+| Kelahiran & Kematian | Data vital statistik |
+| Grafik Kepuasan | Grafik kepuasan layanan kesehatan |
+
+### D. Ekonomi
+**Lokasi**: `src/app/admin/(dashboard)/ekonomi/` dan `src/app/darmasaba/(pages)/ekonomi/`
+
+| Sub-modul | Deskripsi |
+|-----------|-----------|
+| Pasar Desa | Katalog pasar desa dengan produk & rating |
+| Struktur BUMDes | Organisasi BUMDes dengan pengurus |
+| APBDes (PADesa) | Pendapatan Asli Desa |
+| Program Kemiskinan | Program dan statistik kemiskinan |
+| Sektor Unggulan | Sektor ekonomi unggulan desa |
+| Lowongan Kerja Lokal | Info lowongan pekerjaan |
+| Demografi Pekerjaan | Distribusi pekerjaan penduduk |
+| Jumlah Pengangguran | Statistik pengangguran |
+| Penduduk Usia Kerja Menganggur | Analisis pengangguran by usia & pendidikan |
+| Jumlah Penduduk Miskin | Tren kemiskinan tahunan |
+
+### E. Kependudukan
+**Lokasi**: `src/app/admin/(dashboard)/kependudukan/` dan `src/app/darmasaba/(pages)/kependudukan/`
+
+| Sub-modul | Deskripsi |
+|-----------|-----------|
+| Data Banjar | Data penduduk per banjar |
+| Distribusi Agama | Statistik agama penduduk |
+| Distribusi Umur | Piramida umur penduduk |
+| Migrasi Penduduk | Data migrasi masuk/keluar |
+| Dinamika Penduduk | Kelahiran, kematian, migrasi per tahun |
+
+### F. Pendidikan
+**Lokasi**: `src/app/admin/(dashboard)/pendidikan/` dan `src/app/darmasaba/(pages)/pendidikan/`
+
+| Sub-modul | Deskripsi |
+|-----------|-----------|
+| Info Sekolah & PAUD | Data sekolah per jenjang (TK, SD, SMP, SMA) |
+| Beasiswa Desa | Program beasiswa & pendaftar |
+| Program Pendidikan Anak | Program pendidikan anak |
+| Bimbingan Belajar | Informasi bimbingan belajar |
+| Pendidikan Non Formal | Tempat & program non-formal |
+| Perpustakaan Digital | Katalog buku & peminjaman |
+| Data Pendidikan | Statistik pendidikan |
+
+### G. Keamanan
+**Lokasi**: `src/app/admin/(dashboard)/keamanan/` dan `src/app/darmasaba/(pages)/keamanan/`
+
+| Sub-modul | Deskripsi |
+|-----------|-----------|
+| Keamanan Lingkungan (Pecalang/Patwal) | Sistem keamanan tradisional Bali |
+| Polsek Terdekat | Data polsek dengan layanan & map |
+| Kontak Darurat | Kontak darurat keamanan |
+| Pencegahan Kriminalitas | Info pencegahan kriminal |
+| Laporan Publik | Laporan masyarakat dengan tracking status |
+| Tips Keamanan | Tips dan panduan keamanan |
+
+### H. Lingkungan
+**Lokasi**: `src/app/admin/(dashboard)/lingkungan/` dan `src/app/darmasaba/(pages)/lingkungan/`
+
+| Sub-modul | Deskripsi |
+|-----------|-----------|
+| Pengelolaan Sampah | Bank sampah & pengelolaan |
+| Program Penghijauan | Program penghijauan desa |
+| Data Lingkungan | Data lingkungan desa |
+| Gotong Royong | Kegiatan gotong royong |
+| Edukasi Lingkungan | Edukasi lingkungan hidup |
+| Konservasi Adat Bali | Tri Hita Karana & konservasi adat |
+
+### I. Inovasi
+**Lokasi**: `src/app/admin/(dashboard)/inovasi/` dan `src/app/darmasaba/(pages)/inovasi/`
+
+| Sub-modul | Deskripsi |
+|-----------|-----------|
+| Desa Digital (Smart Village) | Transformasi digital desa |
+| Program Kreatif Desa | Program kreatif & inovatif |
+| Kolaborasi Inovasi | Kolaborasi dengan mitra |
+| Info Teknologi Tepat Guna | Info teknologi untuk desa |
+| Ajukan Ide Inovatif | Form pengajuan ide dari warga |
+| Layanan Online Desa | Layanan administrasi online |
+
+### J. Musik Desa
+**Lokasi**: `src/app/admin/(dashboard)/musik/` dan `src/app/darmasaba/(pages)/musik/`
+
+Model `MusikDesa` dengan audio file, cover image, genre, dan durasi. Dilengkapi dengan `FixedPlayerBar` di layout publik.
+
+### K. User & Role (Admin)
+**Lokasi**: `src/app/admin/(dashboard)/user&role/`
+
+- **Role-based Access Control**: Role dengan permission JSON
+- **User Session Management**: Multiple sessions per user dengan JWT
+- **OTP Authentication**: Login dengan nomor telepon + OTP
+- **Menu Access Control**: Dynamic navbar berdasarkan menu akses user
+
+---
+
+## 5. Database Schema (Prisma)
+
+Schema terdiri dari **2413 baris** dengan **100+ model** dan **berbagai enum**. Berikut model-model utama:
+
+### Core Models
+
+| Model | Keterangan |
+|-------|-----------|
+| `FileStorage` | Central file storage untuk semua uploaded files |
+| `AppMenu` / `AppMenuChild` | Menu navigasi aplikasi |
+| `User` / `Role` / `UserSession` / `UserMenuAccess` | Sistem autentikasi & otorisasi |
+| `KodeOtp` | OTP codes untuk login |
+
+### Landing Page & Desa
+
+| Model | Keterangan |
+|-------|-----------|
+| `PejabatDesa` | Pejabat desa dengan foto |
+| `ProfilPerbekel` | Profil perbekel (biodata, pengalaman, program) |
+| `PerbekelDariMasaKeMasa` | Historis perbekel |
+| `Berita` / `KategoriBerita` | Berita desa |
+| `PotensiDesa` / `KategoriPotensi` | Potensi desa |
+| `Pengumuman` / `CategoryPengumuman` | Pengumuman |
+| `GalleryFoto` / `GalleryVideo` | Gallery media |
+| `Penghargaan` | Penghargaan desa |
+| `APBDes` / `APBDesItem` / `RealisasiItem` | Anggaran dengan realisasi |
+| `DesaAntiKorupsi` / `KategoriDesaAntiKorupsi` | Transparansi |
+| `SdgsDesa` | SDGs desa |
+| `PrestasiDesa` / `KategoriPrestasiDesa` | Prestasi |
+| `MusikDesa` | Musik desa |
+
+### PPID
+
+| Model | Keterangan |
+|-------|-----------|
+| `StrukturPPID` / `PosisiOrganisasiPPID` / `PegawaiPPID` | Struktur organisasi |
+| `VisiMisiPPID` | Visi misi |
+| `ProfilePPID` | Profil pejabat |
+| `DasarHukumPPID` | Regulasi |
+| `DaftarInformasiPublik` | Katalog informasi |
+| `PermohonanInformasiPublik` | Permohonan + lookup tables |
+| `FormulirPermohonanKeberatan` | Keberatan |
+| `IndeksKepuasanMasyarakat` + grafik breakdown | Survey kepuasan |
+
+### Kesehatan
+
+| Model | Keterangan |
+|-------|-----------|
+| `FasilitasKesehatan` | Fasilitas lengkap (dokter, tarif, prosedur) |
+| `Puskesmas` / `JamOperasional` / `KontakPuskesmas` | Puskesmas |
+| `Posyandu` | Pos pelayanan terpadu |
+| `ProgramKesehatan` | Program kesehatan |
+| `ArtikelKesehatan` | Artikel lengkap (gejala, pencegahan, P3K, dll) |
+| `PenangananDarurat` / `KontakDarurat` | Darurat |
+| `InfoWabahPenyakit` | Wabah |
+| `DataKematian_Kelahiran` / `Kelahiran` / `Kematian` | Vital statistik |
+| `GrafikKepuasan` | Kepuasan |
+
+### Ekonomi
+
+| Model | Keterangan |
+|-------|-----------|
+| `PasarDesa` / `KategoriProduk` / `KategoriToPasar` | Pasar desa |
+| `StrukturBumDes` / `PosisiOrganisasiBumDes` / `PegawaiBumDes` | BUMDes |
+| `ProgramKemiskinan` / `StatistikKemiskinan` | Kemiskinan |
+| `SektorUnggulanDesa` | Sektor unggulan |
+| `LowonganPekerjaan` | Lowongan |
+| `DataDemografiPekerjaan` | Demografi pekerjaan |
+| `DetailDataPengangguran` | Pengangguran |
+| `GrafikJumlahPendudukMiskin` | Tren kemiskinan |
+
+### Kependudukan
+
+| Model | Keterangan |
+|-------|-----------|
+| `DataBanjar` | Data per banjar |
+| `DistribusiAgama` | Distribusi agama |
+| `DistribusiUmur` | Distribusi umur |
+| `MigrasiPenduduk` | Migrasi (MASUK/KELUAR) |
+| `DinamikaPenduduk` | Dinamika tahunan |
+
+### Pendidikan
+
+| Model | Keterangan |
+|-------|-----------|
+| `JenjangPendidikan` / `Lembaga` / `Siswa` / `Pengajar` | Data sekolah |
+| `BeasiswaPendaftar` | Beasiswa (dengan enum lengkap) |
+| `DataPerpustakaan` / `KategoriBuku` / `PeminjamanBuku` | Perpustakaan |
+| `DataPendidikan` | Statistik |
+
+### Keamanan
+
+| Model | Keterangan |
+|-------|-----------|
+| `KeamananLingkungan` | Keamanan lingkungan |
+| `PolsekTerdekat` / `LayananPolsek` / `LayananToPolsek` | Polsek |
+| `KontakDaruratKeamanan` / `KontakItem` | Kontak darurat |
+| `PencegahanKriminalitas` | Pencegahan |
+| `LaporanPublik` / `PenangananLaporanPublik` (enum StatusLaporan) | Laporan |
+| `Pelapor` | Pelapor |
+| `MenuTipsKeamanan` | Tips |
+
+### Lingkungan
+
+| Model | Keterangan |
+|-------|-----------|
+| `PengelolaanSampah` | Pengelolaan sampah |
+| `KeteranganBankSampahTerdekat` | Bank sampah |
+| `ProgramPenghijauan` | Penghijauan |
+| `DataLingkunganDesa` | Data lingkungan |
+| `KegiatanDesa` / `KategoriKegiatan` | Gotong royong |
+| `FilosofiTriHita` / `BentukKonservasiBerdasarkanAdat` | Konservasi Bali |
+
+### Inovasi
+
+| Model | Keterangan |
+|-------|-----------|
+| `DesaDigital` | Smart village |
+| `ProgramKreatif` | Program kreatif |
+| `KolaborasiInovasi` / `MitraKolaborasi` | Kolaborasi |
+| `InfoTekno` | Teknologi tepat guna |
+| `AjukanIdeInovatif` | Ide dari warga |
+| `AdministrasiOnline` / `JenisLayanan` | Layanan online |
+| `PengaduanMasyarakat` / `JenisPengaduan` | Pengaduan |
+
+---
+
+## 6. API Routes
+
+Semua API ditangani oleh **Elysia.js** di `src/app/api/[[...slugs]]/route.ts`:
+
+| Endpoint Group | Prefix | Deskripsi |
+|---------------|--------|-----------|
+| **File Storage** | `/api/file-storage` | CRUD file storage |
+| **Landing Page** | `/api/landing-page` | Profil, prestasi, anti-korupsi, SDGs, APBDes |
+| **Desa** | `/api/desa` | Berita, gallery, potensi, pengumuman, layanan |
+| **PPID** | `/api/ppid` | Semua endpoint PPID |
+| **Kesehatan** | `/api/kesehatan` | Fasilitas, puskesmas, posyandu, artikel, wabah |
+| **Ekonomi** | `/api/ekonomi` | Pasar desa, BUMDes, APBDes, pengangguran |
+| **Keamanan** | `/api/keamanan` | Keamanan, polsek, laporan, kriminalitas |
+| **Lingkungan** | `/api/lingkungan` | Sampah, penghijauan, gotong royong |
+| **Pendidikan** | `/api/pendidikan` | Sekolah, beasiswa, perpustakaan |
+| **Kependudukan** | `/api/kependudukan` | Banjar, agama, umur, migrasi |
+| **Inovasi** | `/api/inovasi` | Desa digital, kolaborasi, pengaduan |
+| **User** | `/api/admin/user` | CRUD user |
+| **Role** | `/api/admin/role` | CRUD role |
+| **Search** | `/api/search` | Global search |
+| **Utils** | `/api/utils/version` | Version info |
+
+### Utility Endpoints
+
+| Endpoint | Method | Deskripsi |
+|----------|--------|-----------|
+| `/api/img/:name` | GET | Serve image dengan resize |
+| `/api/img/:name` | DELETE | Delete image |
+| `/api/imgs` | GET | List images dengan pagination |
+| `/api/upl-img` | POST | Upload multiple images |
+| `/api/upl-img-single` | POST | Upload single image |
+| `/api/upl-csv` | POST | Upload CSV multiple |
+| `/api/upl-csv-single` | POST | Upload single CSV |
+
+### Auth Endpoints
+
+| Endpoint | Method | Deskripsi |
+|----------|--------|-----------|
+| `/api/auth/login` | POST | Login dengan OTP |
+| `/api/auth/logout` | POST | Logout |
+| `/api/auth/me` | GET | Get current user |
+
+**Swagger Documentation**: Tersedia di `/api/docs`
+
+---
+
+## 7. Halaman Admin
+
+Admin dashboard menggunakan **Mantine AppShell** dengan sidebar navigasi dinamis berbasis role.
+
+### Route Group: `/admin`
+
+| Section | Path | Deskripsi |
+|---------|------|-----------|
+| **Landing Page** | `/admin/landing-page/` | Profil desa, prestasi, anti-korupsi, SDGs, media sosial |
+| **Desa** | `/admin/desa/` | Berita, gallery, layanan, penghargaan, pengumuman, potensi, profil |
+| **PPID** | `/admin/ppid/` | 8 sub-modul PPID lengkap |
+| **Kesehatan** | `/admin/kesehatan/` | 8 sub-modul kesehatan |
+| **Ekonomi** | `/admin/ekonomi/` | 10 sub-modul ekonomi |
+| **Kependudukan** | `/admin/kependudukan/` | 4 sub-modul kependudukan |
+| **Pendidikan** | `/admin/pendidikan/` | 7 sub-modul pendidikan |
+| **Keamanan** | `/admin/keamanan/` | 6 sub-modul keamanan |
+| **Lingkungan** | `/admin/lingkungan/` | 6 sub-modul lingkungan |
+| **Inovasi** | `/admin/inovasi/` | 6 sub-modul inovasi |
+| **Musik** | `/admin/musik/` | Manajemen musik desa |
+| **User & Role** | `/admin/user&role/` | Manajemen user, role, menu access |
+
+### Fitur Admin:
+- **Role-based Dynamic Navbar**: Navbar berubah berdasarkan roleId user
+- **Dark Mode Toggle**: Tema gelap/terang
+- **OTP Login**: Login dengan nomor telepon + kode OTP
+- **Session Management**: Multiple sessions per user dengan JWT tokens
+- **CSV Upload**: Import data via CSV
+- **Image Upload**: Upload dengan preview dan management
+- **Rich Text Editor**: Tiptap untuk konten HTML
+
+### Role-Based Redirect:
+| roleId | Role | Default Redirect |
+|--------|------|-----------------|
+| 0, 1, 2 | Super Admin / Admin Desa | `/admin/landing-page/profil/program-inovasi` |
+| 3 | Admin Kesehatan | `/admin/kesehatan/posyandu` |
+| 4 | Admin Pendidikan | `/admin/pendidikan/info-sekolah/jenjang-pendidikan` |
+
+---
+
+## 8. Halaman Publik
+
+Public website di `/darmasaba/` dengan layout yang mencakup **Navbar**, **Footer**, dan **Fixed Music Player Bar**.
+
+### Route Group: `/darmasaba`
+
+| Section | Path | Deskripsi |
+|---------|------|-----------|
+| **Home** | `/darmasaba` | Landing page utama |
+| **Desa** | `/darmasaba/desa` | Profil, berita, gallery, layanan, pengumuman, potensi |
+| **PPID** | `/darmasaba/ppid` | 7 sub-halaman PPID publik |
+| **Kesehatan** | `/darmasaba/kesehatan` | Info kesehatan publik |
+| **Ekonomi** | `/darmasaba/ekonomi` | Info ekonomi desa |
+| **Kependudukan** | `/darmasaba/kependudukan` | Data kependudukan |
+| **Pendidikan** | `/darmasaba/pendidikan` | Info pendidikan |
+| **Keamanan** | `/darmasaba/keamanan` | Info keamanan |
+| **Lingkungan** | `/darmasaba/lingkungan` | Info lingkungan |
+| **Inovasi** | `/darmasaba/inovasi` | Info inovasi |
+| **Musik** | `/darmasaba/musik` | Musik desa |
+| **Module** | `/darmasaba/module/*` | Link ke modul eksternal (DAVES, MANGAN, Bicara-Darma, BARES, dll) |
+
+### Fitur Publik:
+- **Fixed Music Player Bar**: Player musik yang selalu tampil di bottom
+- **Global Search**: Pencarian global
+- **News Reader**: Notifikasi berita modern
+- **View Transitions**: Smooth page transitions
+- **Responsive Design**: Mobile-first dengan Mantine breakpoints
+
+---
+
+## 9. Komponen Utama
+
+### Admin Components (`src/components/admin/`)
+
+| Komponen | Deskripsi |
+|----------|-----------|
+| `AdminThemeProvider.tsx` | Theme provider untuk admin |
+| `DarkModeToggle.tsx` | Toggle dark/light mode |
+| `UnifiedSurface.tsx` | Consistent surface/card component |
+| `UnifiedTypography.tsx` | Consistent typography system |
+
+### Public Shared Components (`src/app/darmasaba/_com/`)
+
+| Komponen | Deskripsi |
+|----------|-----------|
+| `Navbar.tsx` | Main navigation bar |
+| `NavbarMainMenu.tsx` | Main menu dengan kategori |
+| `NavbarSubMenu.tsx` | Submenu dropdown |
+| `Footer.tsx` | Footer dengan info desa |
+| `FixedPlayerBar.tsx` | Music player bar fixed di bottom |
+| `LoadDataFirstClient.tsx` | Client-side data preloader |
+| `globalSearch.tsx` | Global search component |
+| `NewsReader.tsx` | News notification reader |
+| `ModernNewsNotification.tsx` | News toast notifications |
+
+### Global Components (`src/app/_com/`)
+
+| Komponen | Deskripsi |
+|----------|-----------|
+| `SpashScreen.tsx` | Splash screen on load |
+| `WebVitals.tsx` | Web Vitals monitoring |
+
+---
+
+## 10. State Management
+
+Proyek menggunakan **multi-layer state management**:
+
+| Library | Penggunaan | Lokasi |
+|---------|-----------|--------|
+| **Jotai** | Auth state (`authStore`) | `src/store/authStore.ts` |
+| **Valtio** | Dark mode, layanan, image list, nav state | `src/state/*.ts` |
+| **SWR** | Server state fetching & caching | Digunakan di components |
+| **React Context** | Music player context | `src/app/context/MusicContext.tsx` |
+| **React useState** | Local component state | Di components |
+
+### State Files:
+
+```
+src/state/
+  darkModeStore.ts     -- Valtio proxy untuk dark mode
+  state-layanan.ts     -- State layanan desa
+  state-list-image.ts  -- State list image untuk upload
+  state-nav.ts         -- State navigasi
+
+src/store/
+  authStore.ts         -- Jotai atom untuk auth user state
+```
+
+---
+
+## 11. Autentikasi
+
+Sistem autentikasi menggunakan **OTP (One-Time Password)** via WhatsApp/Telepon dengan **iron-session** untuk session management.
+
+### Flow Autentikasi:
+1. User memasukkan **nomor telepon** di `/login`
+2. Sistem mengirim **kode OTP** via WhatsApp Server
+3. OTP disimpan di model `KodeOtp`
+4. User memasukkan kode OTP
+5. Jika valid, session dibuat dengan **iron-session** + **JWT token**
+6. Session disimpan di `UserSession` model dengan expiry
+
+### Session Structure:
+```typescript
+// src/lib/session.ts
+type SessionData = {
+  user?: {
+    id: string;
+    name: string;
+    roleId: number;
+    menuIds?: string[] | null;
+    isActive?: boolean;
+  };
+};
+```
+
+### Role-Based Access:
+| roleId | Role | Default Redirect |
+|--------|------|-----------------|
+| 0, 1, 2 | Super Admin / Admin Desa | `/admin/landing-page/profil/program-inovasi` |
+| 3 | Admin Kesehatan | `/admin/kesehatan/posyandu` |
+| 4 | Admin Pendidikan | `/admin/pendidikan/info-sekolah/jenjang-pendidikan` |
+
+### Authorization:
+- **UserMenuAccess**: Mapping user ke menu yang boleh diakses
+- **Dynamic Navbar**: Navbar dirender berdasarkan `menuIds` user
+- **Inactive Users**: Dialihkan ke `/waiting-room`
+
+---
+
+## 12. Deployment
+
+### Docker Setup
+
+**Dockerfile** menggunakan **multi-stage build** dengan base image `oven/bun:1-debian`:
+
+```
+Stage 1: Builder
+  - Install dependencies (bun install --frozen-lockfile)
+  - Generate Prisma client
+  - Build Next.js (bun run build)
+
+Stage 2: Runner
+  - Copy .next, node_modules, public, prisma, src/lib, tsconfig.json
+  - Non-root user (nextjs:nodejs)
+  - Volume /app/uploads untuk file uploads
+  - Port 3000
+```
+
+### Entry Point (`docker-entrypoint.sh`):
+```bash
+bunx prisma migrate deploy   # Run migrations
+exec bun start               # Start Next.js production server
+```
+
+### CI/CD dengan GitHub Actions
+
+Terdapat **3 workflow**:
+
+| Workflow | Trigger | Fungsi |
+|----------|---------|--------|
+| `docker-publish.yml` | Push tag `v*` | Auto build & push ke GHCR |
+| `publish.yml` | Manual (workflow_dispatch) | Build & push ke GHCR dengan input `stack_env` + `tag` |
+| `re-pull.yml` | Manual (workflow_dispatch) | Re-pull image di Portainer dengan input `stack_name` + `stack_env` |
+
+### Deployment Workflow (Sequential):
+
+```
+1. Update version di package.json (semver)
+2. Commit perubahan
+3. Push ke branch target (stg/prod)
+4. Trigger publish.yml:
+   gh workflow run publish.yml --ref main -f stack_env=stg -f tag=<version>
+5. Tunggu sampai publish selesai (status: completed)
+6. Trigger re-pull.yml:
+   gh workflow run re-pull.yml --ref main -f stack_name=desa-darmasaba -f stack_env=stg
+7. Verifikasi di Portainer
+```
+
+**PENTING**: `publish.yml` dan `re-pull.yml` TIDAK boleh dijalankan bersamaan (race condition).
+
+### Environments:
+- **dev**: Development
+- **stg**: Staging (`desa-darmasaba-stg.wibudev.com`)
+- **prod**: Production
+
+### Notification:
+- Telegram notification via `notify.sh` script setelah setiap workflow
+
+---
+
+## 13. Scripts
+
+| Script | Command | Deskripsi |
+|--------|---------|-----------|
+| `dev` | `next dev` | Development server |
+| `build` | `next build` | Production build |
+| `start` | `next start` | Production server |
+| `test:api` | `vitest run` | Run API unit tests |
+| `test:e2e` | `playwright test` | Run E2E tests |
+| `test` | `bun run test:api && bun run test:e2e` | Run all tests |
+| `seed` | `bun run prisma/seed.ts` | Seed database |
+| `prisma:generate` | `bunx prisma generate` | Generate Prisma client |
+| `prisma:push` | `bunx prisma db push` | Push schema to database |
+| `prisma:studio` | `bunx prisma studio` | Open Prisma Studio GUI |
+| `gen:api` | *(empty)* | Generate API types (placeholder) |
+
+### Prisma Seed Configuration:
+```json
+// package.json
+{
+  "prisma": {
+    "seed": "bun run prisma/seed.ts"
+  }
+}
+```
+
+---
+
+## 14. Environment Variables
+
+File: `.env.example`
+
+| Variable | Deskripsi | Contoh |
+|----------|-----------|--------|
+| `DATABASE_URL` | PostgreSQL connection string | `postgresql://user:pass@localhost:5432/desa-darmasaba` |
+| `SEAFILE_TOKEN` | Seafile API token | `your_seafile_token` |
+| `SEAFILE_REPO_ID` | Seafile repository ID | `your_repo_id` |
+| `SEAFILE_URL` | Seafile instance URL | `https://seafile.example.com` |
+| `SEAFILE_PUBLIC_SHARE_TOKEN` | Token untuk public share | `your_share_token` |
+| `WIBU_UPLOAD_DIR` | Upload directory path | `uploads` |
+| `WA_SERVER_TOKEN` | WhatsApp server token | `your_wa_token` |
+| `NEXT_PUBLIC_BASE_URL` | Base URL aplikasi | `/` (relative) |
+| `EMAIL_USER` | Email untuk notifikasi | `your_email@gmail.com` |
+| `EMAIL_PASS` | Email app password | `your_app_password` |
+| `BASE_TOKEN_KEY` | JWT secret key | `your_jwt_secret` |
+| `BOT_TOKEN` | Telegram bot token | `your_bot_token` |
+| `CHAT_ID` | Telegram chat ID | `your_chat_id` |
+| `SESSION_PASSWORD` | iron-session password (min 32 chars) | `secure_32_char_password` |
+| `ELEVENLABS_API_KEY` | ElevenLabs API (TTS - optional) | `your_elevenlabs_key` |
+
+---
+
+## 15. Layanan Eksternal
+
+### PostgreSQL
+- **Provider**: PostgreSQL via Prisma ORM
+- **Schema**: `public`
+- **Connection**: Via `DATABASE_URL` environment variable
+- **Migrations**: `prisma migrate deploy` di docker entrypoint
+
+### Seafile (File Storage)
+- **Tipe**: Self-hosted file sync & share
+- **Penggunaan**: Storage untuk images, documents, audio files
+- **Integrasi**: `src/lib/seafile-auth-service.ts`
+- **CDN**: URL generation untuk public sharing
+- **Config**: Token, repo ID, base URL
+
+### WhatsApp Server
+- **Penggunaan**: Kirim OTP codes saat login
+- **Config**: `WA_SERVER_TOKEN`
+
+### Telegram Bot
+- **Penggunaan**: Notifikasi deployment & sistem
+- **Config**: `BOT_TOKEN` + `CHAT_ID`
+- **Integration**: `notify.sh` script di GitHub Actions
+
+### ElevenLabs (Optional)
+- **Penggunaan**: Text-to-Speech (TTS) features
+- **Config**: `ELEVENLABS_API_KEY`
+
+### Email (Nodemailer)
+- **Penggunaan**: Notifikasi email untuk subscription/pengumuman
+- **Config**: `EMAIL_USER` + `EMAIL_PASS`
+- **Provider**: Gmail (app password)
+
+---
+
+## Ringkasan Cepat
+
+| Aspek | Detail |
+|-------|--------|
+| **Framework** | Next.js 15 (App Router) + Elysia.js |
+| **Database** | PostgreSQL + Prisma (100+ models) |
+| **Auth** | OTP + iron-session + JWT |
+| **Storage** | Seafile + local uploads |
+| **UI** | Mantine UI + Tiptap + Framer Motion |
+| **State** | Jotai + Valtio + SWR |
+| **Deploy** | Docker + GHCR + Portainer + GitHub Actions |
+| **Runtime** | Bun |
+| **Testing** | Vitest + Playwright |
+| **Version** | 0.1.11 |

biome.json

@@ -0,0 +1,49 @@
+{
+  "$schema": "https://biomejs.dev/schemas/2.4.10/schema.json",
+  "vcs": {
+    "enabled": true,
+    "clientKind": "git",
+    "useIgnoreFile": true
+  },
+  "files": {
+    "ignoreUnknown": false,
+    "experimentalScannerIgnores": [
+      "node_modules",
+      ".next",
+      "out",
+      "public"
+    ]
+  },
+  "formatter": {
+    "enabled": true,
+    "indentStyle": "space",
+    "indentWidth": 2,
+    "lineWidth": 100
+  },
+  "linter": {
+    "enabled": true,
+    "rules": {
+      "recommended": true,
+      "correctness": {
+        "noUnusedVariables": "warn",
+        "noUnusedImports": "warn"
+      },
+      "suspicious": {
+        "noExplicitAny": "warn"
+      },
+      "style": {
+        "noNonNullAssertion": "warn"
+      },
+      "complexity": {
+        "noForEach": "off"
+      }
+    }
+  },
+  "javascript": {
+    "formatter": {
+      "quoteStyle": "single",
+      "trailingCommas": "all",
+      "semicolons": "always"
+    }
+  }
+}

dev-inspector-click-to-source.md

@@ -0,0 +1,553 @@
+# Skill: Dev Inspector — Click-to-Source untuk Bun + Elysia + Vite + React
+
+## Ringkasan
+
+Fitur development: klik elemen UI di browser → langsung buka source code di editor (VS Code, Cursor, dll) pada baris dan kolom yang tepat. Zero overhead di production.
+
+**Hotkey**: `Ctrl+Shift+Cmd+C` (macOS) / `Ctrl+Shift+Alt+C` → aktifkan mode inspect → klik elemen → file terbuka.
+
+## Kenapa Tidak Pakai Library
+
+`react-dev-inspector` crash di React 19 karena:
+- `fiber.return.child.sibling` bisa null di React 19
+- `_debugSource` dihapus dari React 19
+- Walking fiber tree tidak stabil antar versi React
+
+Solusi ini **regex-based + multi-fallback**, tidak bergantung pada React internals.
+
+## Syarat Arsitektur
+
+Fitur ini bekerja karena 4 syarat struktural terpenuhi. Jika salah satu tidak ada, fitur tidak bisa diimplementasi atau perlu adaptasi signifikan.
+
+### 1. Vite sebagai Bundler (Wajib)
+
+Seluruh mekanisme bergantung pada **Vite plugin transform pipeline**:
+- `inspectorPlugin()` inject attributes ke JSX saat build/HMR
+- `enforce: 'pre'` memastikan plugin jalan sebelum OXC/Babel transform JSX
+- `import.meta.env?.DEV` sebagai compile-time constant untuk tree-shaking
+
+**Tidak bisa diganti dengan**: esbuild standalone, webpack (perlu loader berbeda), SWC standalone.
+**Bisa diganti dengan**: framework yang pakai Vite di dalamnya (Remix Vite, TanStack Start, Astro).
+
+### 2. Server dan Frontend dalam Satu Proses (Wajib)
+
+Endpoint `/__open-in-editor` harus **satu proses dengan dev server** yang melayani frontend:
+- Browser POST ke origin yang sama (no CORS)
+- Server punya akses ke filesystem lokal untuk `Bun.spawn(editor)`
+- Endpoint harus bisa ditangani **sebelum routing & middleware** (auth, tenant, dll)
+
+**Pola yang memenuhi syarat:**
+- Elysia + Vite middlewareMode (project ini) — `onRequest` intercept sebelum route matching
+- Express/Fastify + Vite middlewareMode — middleware biasa sebelum auth
+- Vite dev server standalone (`vite dev`) — pakai `configureServer` hook
+
+**Tidak memenuhi syarat:**
+- Frontend dan backend di proses/port terpisah (misal: CRA + separate API server) — perlu proxy atau CORS config tambahan
+- Serverless/edge deployment — tidak bisa `spawn` editor
+
+### 3. React sebagai UI Framework (Wajib untuk Multi-Fallback)
+
+Strategi extraction source info bergantung pada React internals:
+1. `__reactProps$*` — React menyimpan props di DOM element
+2. `__reactFiber$*` — React fiber tree untuk walk-up
+3. DOM attribute — fallback universal
+
+**Jika pakai framework lain** (Vue, Svelte, Solid):
+- Hanya strategi 3 (DOM attribute) yang berfungsi — tetap cukup
+- Hapus strategi 1 & 2 dari `getCodeInfoFromElement()`
+- Inject attributes tetap via Vite plugin (framework-agnostic)
+
+### 4. Bun sebagai Runtime (Direkomendasikan, Bukan Wajib)
+
+Bun memberikan API yang lebih clean:
+- `Bun.spawn()` — fire-and-forget tanpa import
+- `Bun.which()` — cek executable ada di PATH (mencegah uncatchable error)
+
+**Jika pakai Node.js:**
+- `Bun.spawn()` → `child_process.spawn(editor, args, { detached: true, stdio: 'ignore' }).unref()`
+- `Bun.which()` → `const which = require('which'); which.sync(editor, { nothrow: true })`
+
+### Ringkasan Syarat
+
+| Syarat                        | Wajib?   | Alternatif                                           |
+|-------------------------------|----------|------------------------------------------------------|
+| Vite sebagai bundler          | Ya       | Framework berbasis Vite (Remix, Astro, dll)          |
+| Server + frontend satu proses | Ya       | Bisa diakali dengan proxy, tapi tambah kompleksitas  |
+| React                         | Sebagian | Framework lain bisa, hanya fallback ke DOM attribute |
+| Bun runtime                   | Tidak    | Node.js dengan `child_process` + `which` package     |
+
+## Arsitektur
+
+```
+BUILD TIME (Vite Plugin):
+  .tsx/.jsx file
+    → [inspectorPlugin enforce:'pre'] inject data-inspector-* attributes ke JSX
+    → [react() OXC] transform JSX ke createElement
+    → Browser menerima elemen dengan attributes
+
+RUNTIME (Browser):
+  Hotkey → aktifkan mode → hover elemen → baca attributes → klik
+    → POST /__open-in-editor {relativePath, line, column}
+
+BACKEND (Elysia onRequest):
+  /__open-in-editor → Bun.spawn([editor, '--goto', 'file:line:col'])
+    → Editor terbuka di lokasi tepat
+```
+
+## Komponen yang Dibutuhkan
+
+### 1. Vite Plugin — `inspectorPlugin()` (enforce: 'pre')
+
+Inject `data-inspector-*` ke setiap JSX opening tag via regex.
+
+**HARUS `enforce: 'pre'`** — kalau tidak, OXC transform JSX duluan dan regex tidak bisa menemukan `<Component`.
+
+```typescript
+// Taruh di file vite config (misal: src/vite.ts atau vite.config.ts)
+import path from 'node:path'
+import type { Plugin } from 'vite'
+
+function inspectorPlugin(): Plugin {
+  const rootDir = process.cwd()
+
+  return {
+    name: 'inspector-inject',
+    enforce: 'pre',
+    transform(code, id) {
+      // Hanya .tsx/.jsx, skip node_modules
+      if (!/\.[jt]sx(\?|$)/.test(id) || id.includes('node_modules')) return null
+      if (!code.includes('<')) return null
+
+      const relativePath = path.relative(rootDir, id)
+      let modified = false
+      const lines = code.split('\n')
+      const result: string[] = []
+
+      for (let i = 0; i < lines.length; i++) {
+        let line = lines[i]
+        // Match JSX opening tags: <Component atau <div
+        // Skip TypeScript generics (Record<string>) via charBefore check
+        const jsxPattern = /(<(?:[A-Z][a-zA-Z0-9.]*|[a-z][a-zA-Z0-9-]*))\b/g
+        let match: RegExpExecArray | null = null
+
+        while ((match = jsxPattern.exec(line)) !== null) {
+          // Skip jika karakter sebelum `<` adalah identifier char (TypeScript generic)
+          const charBefore = match.index > 0 ? line[match.index - 1] : ''
+          if (/[a-zA-Z0-9_$.]/.test(charBefore)) continue
+
+          const col = match.index + 1
+          const attr = ` data-inspector-line="${i + 1}" data-inspector-column="${col}" data-inspector-relative-path="${relativePath}"`
+          const insertPos = match.index + match[0].length
+          line = line.slice(0, insertPos) + attr + line.slice(insertPos)
+          modified = true
+          jsxPattern.lastIndex += attr.length
+        }
+
+        result.push(line)
+      }
+
+      if (!modified) return null
+      return result.join('\n')
+    },
+  }
+}
+```
+
+**Mengapa regex, bukan Babel?**
+- `@vitejs/plugin-react` v6+ pakai OXC (Rust), bukan Babel
+- Config `babel: { plugins: [...] }` di plugin-react **DIABAIKAN**
+- Regex jalan sebelum OXC via `enforce: 'pre'`
+
+**Gotcha: TypeScript generics**
+- `Record<string>` → karakter sebelum `<` adalah `d` (identifier) → SKIP
+- `<Button` → karakter sebelum `<` adalah space/newline → MATCH
+
+### 2. Vite Plugin Order (KRITIS)
+
+```typescript
+plugins: [
+  // 1. Route generation (jika pakai TanStack Router)
+  TanStackRouterVite({ ... }),
+
+  // 2. Inspector inject — HARUS sebelum react()
+  inspectorPlugin(),
+
+  // 3. React OXC transform
+  react(),
+
+  // 4. (Opsional) Dedupe React Refresh untuk middlewareMode
+  dedupeRefreshPlugin(),
+]
+```
+
+**Jika urutan salah (inspectorPlugin setelah react):**
+- OXC transform `<Button>` → `React.createElement(Button, ...)`
+- Regex tidak menemukan `<Button` → attributes TIDAK ter-inject
+- Fitur tidak berfungsi, tanpa error
+
+### 3. DevInspector Component (Browser Runtime)
+
+Komponen React yang handle hotkey, overlay, dan klik.
+
+```tsx
+// src/frontend/DevInspector.tsx
+import { useCallback, useEffect, useRef, useState } from 'react'
+
+interface CodeInfo {
+  relativePath: string
+  line: string
+  column: string
+}
+
+/** Baca data-inspector-* dari fiber props atau DOM attributes */
+function getCodeInfoFromElement(element: HTMLElement): CodeInfo | null {
+  // Strategi 1: React internal props __reactProps$ (paling akurat)
+  for (const key of Object.keys(element)) {
+    if (key.startsWith('__reactProps$')) {
+      const props = (element as any)[key]
+      if (props?.['data-inspector-relative-path']) {
+        return {
+          relativePath: props['data-inspector-relative-path'],
+          line: props['data-inspector-line'] || '1',
+          column: props['data-inspector-column'] || '1',
+        }
+      }
+    }
+    // Strategi 2: Walk fiber tree __reactFiber$
+    if (key.startsWith('__reactFiber$')) {
+      const fiber = (element as any)[key]
+      let f = fiber
+      while (f) {
+        const p = f.pendingProps || f.memoizedProps
+        if (p?.['data-inspector-relative-path']) {
+          return {
+            relativePath: p['data-inspector-relative-path'],
+            line: p['data-inspector-line'] || '1',
+            column: p['data-inspector-column'] || '1',
+          }
+        }
+        // Fallback: _debugSource (React < 19)
+        const src = f._debugSource ?? f._debugOwner?._debugSource
+        if (src?.fileName && src?.lineNumber) {
+          return {
+            relativePath: src.fileName,
+            line: String(src.lineNumber),
+            column: String(src.columnNumber ?? 1),
+          }
+        }
+        f = f.return
+      }
+    }
+  }
+
+  // Strategi 3: Fallback DOM attribute langsung
+  const rp = element.getAttribute('data-inspector-relative-path')
+  if (rp) {
+    return {
+      relativePath: rp,
+      line: element.getAttribute('data-inspector-line') || '1',
+      column: element.getAttribute('data-inspector-column') || '1',
+    }
+  }
+
+  return null
+}
+
+/** Walk up DOM tree sampai ketemu elemen yang punya source info */
+function findCodeInfo(target: HTMLElement): CodeInfo | null {
+  let el: HTMLElement | null = target
+  while (el) {
+    const info = getCodeInfoFromElement(el)
+    if (info) return info
+    el = el.parentElement
+  }
+  return null
+}
+
+function openInEditor(info: CodeInfo) {
+  fetch('/__open-in-editor', {
+    method: 'POST',
+    headers: { 'Content-Type': 'application/json' },
+    body: JSON.stringify({
+      relativePath: info.relativePath,
+      lineNumber: info.line,
+      columnNumber: info.column,
+    }),
+  })
+}
+
+export function DevInspector({ children }: { children: React.ReactNode }) {
+  const [active, setActive] = useState(false)
+  const overlayRef = useRef<HTMLDivElement | null>(null)
+  const tooltipRef = useRef<HTMLDivElement | null>(null)
+  const lastInfoRef = useRef<CodeInfo | null>(null)
+
+  const updateOverlay = useCallback((target: HTMLElement | null) => {
+    const ov = overlayRef.current
+    const tt = tooltipRef.current
+    if (!ov || !tt) return
+
+    if (!target) {
+      ov.style.display = 'none'
+      tt.style.display = 'none'
+      lastInfoRef.current = null
+      return
+    }
+
+    const info = findCodeInfo(target)
+    if (!info) {
+      ov.style.display = 'none'
+      tt.style.display = 'none'
+      lastInfoRef.current = null
+      return
+    }
+
+    lastInfoRef.current = info
+
+    const rect = target.getBoundingClientRect()
+    ov.style.display = 'block'
+    ov.style.top = `${rect.top + window.scrollY}px`
+    ov.style.left = `${rect.left + window.scrollX}px`
+    ov.style.width = `${rect.width}px`
+    ov.style.height = `${rect.height}px`
+
+    tt.style.display = 'block'
+    tt.textContent = `${info.relativePath}:${info.line}`
+    const ttTop = rect.top + window.scrollY - 24
+    tt.style.top = `${ttTop > 0 ? ttTop : rect.bottom + window.scrollY + 4}px`
+    tt.style.left = `${rect.left + window.scrollX}px`
+  }, [])
+
+  // Activate/deactivate event listeners
+  useEffect(() => {
+    if (!active) return
+
+    const onMouseOver = (e: MouseEvent) => updateOverlay(e.target as HTMLElement)
+
+    const onClick = (e: MouseEvent) => {
+      e.preventDefault()
+      e.stopPropagation()
+      const info = lastInfoRef.current ?? findCodeInfo(e.target as HTMLElement)
+      if (info) {
+        const loc = `${info.relativePath}:${info.line}:${info.column}`
+        console.log('[DevInspector] Open:', loc)
+        navigator.clipboard.writeText(loc)
+        openInEditor(info)
+      }
+      setActive(false)
+    }
+
+    const onKeyDown = (e: KeyboardEvent) => {
+      if (e.key === 'Escape') setActive(false)
+    }
+
+    document.addEventListener('mouseover', onMouseOver, true)
+    document.addEventListener('click', onClick, true)
+    document.addEventListener('keydown', onKeyDown)
+    document.body.style.cursor = 'crosshair'
+
+    return () => {
+      document.removeEventListener('mouseover', onMouseOver, true)
+      document.removeEventListener('click', onClick, true)
+      document.removeEventListener('keydown', onKeyDown)
+      document.body.style.cursor = ''
+      if (overlayRef.current) overlayRef.current.style.display = 'none'
+      if (tooltipRef.current) tooltipRef.current.style.display = 'none'
+    }
+  }, [active, updateOverlay])
+
+  // Hotkey: Ctrl+Shift+Cmd+C (macOS) / Ctrl+Shift+Alt+C
+  useEffect(() => {
+    const onKeyDown = (e: KeyboardEvent) => {
+      if (e.key.toLowerCase() === 'c' && e.ctrlKey && e.shiftKey && (e.metaKey || e.altKey)) {
+        e.preventDefault()
+        setActive((prev) => !prev)
+      }
+    }
+    document.addEventListener('keydown', onKeyDown)
+    return () => document.removeEventListener('keydown', onKeyDown)
+  }, [])
+
+  return (
+    <>
+      {children}
+      <div
+        ref={overlayRef}
+        style={{
+          display: 'none',
+          position: 'absolute',
+          pointerEvents: 'none',
+          border: '2px solid #3b82f6',
+          backgroundColor: 'rgba(59,130,246,0.1)',
+          zIndex: 99999,
+          transition: 'all 0.05s ease',
+        }}
+      />
+      <div
+        ref={tooltipRef}
+        style={{
+          display: 'none',
+          position: 'absolute',
+          pointerEvents: 'none',
+          backgroundColor: '#1e293b',
+          color: '#e2e8f0',
+          fontSize: '12px',
+          fontFamily: 'monospace',
+          padding: '2px 6px',
+          borderRadius: '3px',
+          zIndex: 100000,
+          whiteSpace: 'nowrap',
+        }}
+      />
+    </>
+  )
+}
+```
+
+### 4. Backend Endpoint — `/__open-in-editor`
+
+**HARUS ditangani di `onRequest` / sebelum middleware**, bukan sebagai route biasa. Kalau jadi route, akan kena auth middleware dan gagal.
+
+```typescript
+// Di entry point server (src/index.tsx), dalam onRequest handler:
+
+if (!isProduction && pathname === '/__open-in-editor' && request.method === 'POST') {
+  const { relativePath, lineNumber, columnNumber } = (await request.json()) as {
+    relativePath: string
+    lineNumber: string
+    columnNumber: string
+  }
+  const file = `${process.cwd()}/${relativePath}`
+  const editor = process.env.REACT_EDITOR || 'code'
+  const loc = `${file}:${lineNumber}:${columnNumber}`
+  const args = editor === 'subl' ? [loc] : ['--goto', loc]
+  const editorPath = Bun.which(editor)
+  console.log(`[inspector] ${editor} → ${editorPath ?? 'NOT FOUND'} → ${loc}`)
+  if (editorPath) {
+    Bun.spawn([editor, ...args], { stdio: ['ignore', 'ignore', 'ignore'] })
+  } else {
+    console.error(`[inspector] Editor "${editor}" not found in PATH. Set REACT_EDITOR in .env`)
+  }
+  return new Response('ok')
+}
+```
+
+**Penting — `Bun.which()` sebelum `Bun.spawn()`:**
+- `Bun.spawn()` throw native error yang TIDAK bisa di-catch jika executable tidak ada
+- `Bun.which()` return null dengan aman → cek dulu sebelum spawn
+
+**Editor yang didukung:**
+
+| REACT_EDITOR     | Editor       | Args                           |
+|------------------|--------------|--------------------------------|
+| `code` (default) | VS Code      | `--goto file:line:col`         |
+| `cursor`         | Cursor       | `--goto file:line:col`         |
+| `windsurf`       | Windsurf     | `--goto file:line:col`         |
+| `subl`           | Sublime Text | `file:line:col` (tanpa --goto) |
+
+### 5. Frontend Entry — Conditional Import (Zero Production Overhead)
+
+```tsx
+// src/frontend.tsx (atau entry point React)
+import type { ReactNode } from 'react'
+
+const InspectorWrapper = import.meta.env?.DEV
+  ? (await import('./frontend/DevInspector')).DevInspector
+  : ({ children }: { children: ReactNode }) => <>{children}</>
+
+const app = (
+  <InspectorWrapper>
+    <App />
+  </InspectorWrapper>
+)
+```
+
+**Bagaimana zero overhead tercapai:**
+- `import.meta.env?.DEV` adalah compile-time constant
+- Production build: `false` → dynamic import TIDAK dieksekusi
+- Tree-shaking menghapus seluruh `DevInspector.tsx` dari bundle
+- Tidak ada runtime check, tidak ada dead code di bundle
+
+### 6. (Opsional) Dedupe React Refresh — Workaround Vite middlewareMode
+
+Jika pakai Vite dalam `middlewareMode` (seperti di Elysia/Express), `@vitejs/plugin-react` v6 bisa inject React Refresh footer dua kali → error "already declared".
+
+```typescript
+function dedupeRefreshPlugin(): Plugin {
+  return {
+    name: 'dedupe-react-refresh',
+    enforce: 'post',
+    transform(code, id) {
+      if (!/\.[jt]sx(\?|$)/.test(id) || id.includes('node_modules')) return null
+
+      const marker = 'import * as RefreshRuntime from "/@react-refresh"'
+      const firstIdx = code.indexOf(marker)
+      if (firstIdx === -1) return null
+
+      const secondIdx = code.indexOf(marker, firstIdx + marker.length)
+      if (secondIdx === -1) return null
+
+      const sourcemapIdx = code.indexOf('\n//# sourceMappingURL=', secondIdx)
+      const endIdx = sourcemapIdx !== -1 ? sourcemapIdx : code.length
+
+      const cleaned = code.slice(0, secondIdx) + code.slice(endIdx)
+      return { code: cleaned, map: null }
+    },
+  }
+}
+```
+
+## Langkah Implementasi di Project Baru
+
+### Prasyarat
+- Runtime: Bun
+- Server: Elysia (atau framework lain dengan onRequest/beforeHandle)
+- Frontend: React + Vite
+- `@vitejs/plugin-react` (OXC)
+
+### Step-by-step
+
+1. **Buat `DevInspector.tsx`** — copy komponen dari Bagian 3 ke folder frontend
+2. **Tambah `inspectorPlugin()`** — copy fungsi dari Bagian 1 ke file vite config
+3. **Atur plugin order** — `inspectorPlugin()` SEBELUM `react()` (Bagian 2)
+4. **Tambah endpoint `/__open-in-editor`** — di `onRequest` handler (Bagian 4)
+5. **Wrap root app** — conditional import di entry point (Bagian 5)
+6. **Set env** — `REACT_EDITOR=code` (atau cursor/windsurf/subl) di `.env`
+7. **(Opsional)** Tambah `dedupeRefreshPlugin()` jika pakai Vite `middlewareMode`
+
+### Checklist Verifikasi
+
+- [ ] `inspectorPlugin` punya `enforce: 'pre'`
+- [ ] Plugin order: inspector → react (bukan sebaliknya)
+- [ ] Endpoint `/__open-in-editor` di LUAR middleware auth
+- [ ] `Bun.which(editor)` dipanggil SEBELUM `Bun.spawn()`
+- [ ] Conditional import pakai `import.meta.env?.DEV`
+- [ ] `REACT_EDITOR` di `.env` sesuai editor yang dipakai
+- [ ] Hotkey berfungsi: `Ctrl+Shift+Cmd+C` / `Ctrl+Shift+Alt+C`
+
+## Gotcha & Pelajaran
+
+| Masalah                          | Penyebab                                    | Solusi                                        |
+|----------------------------------|---------------------------------------------|-----------------------------------------------|
+| Attributes tidak ter-inject      | Plugin order salah                          | `enforce: 'pre'`, taruh sebelum `react()`     |
+| `Record<string>` ikut ter-inject | Regex match TypeScript generics             | Cek `charBefore` — skip jika identifier char  |
+| `Bun.spawn` crash                | Editor tidak ada di PATH                    | Selalu `Bun.which()` dulu                     |
+| Hotkey tidak response            | `e.key` return 'C' (uppercase) karena Shift | Pakai `e.key.toLowerCase()`                   |
+| React Refresh duplicate          | Vite middlewareMode bug                     | `dedupeRefreshPlugin()` enforce: 'post'       |
+| Endpoint kena auth middleware    | Didaftarkan sebagai route biasa             | Tangani di `onRequest` sebelum routing        |
+| `_debugSource` undefined         | React 19 menghapusnya                       | Multi-fallback: reactProps → fiber → DOM attr |
+
+## Adaptasi untuk Framework Lain
+
+### Express/Fastify (bukan Elysia)
+- Endpoint `/__open-in-editor`: gunakan middleware biasa SEBELUM auth
+- `Bun.spawn` → `child_process.spawn` jika pakai Node.js
+- `Bun.which` → `which` npm package jika pakai Node.js
+
+### Next.js
+- Tidak perlu — Next.js punya built-in click-to-source
+- Tapi jika ingin custom: taruh endpoint di `middleware.ts`, plugin di `next.config.js`
+
+### Remix/Tanstack Start (SSR)
+- Plugin tetap sama (Vite-based)
+- Endpoint perlu di server entry, bukan di route loader

docker-entrypoint.sh

@@ -0,0 +1,13 @@
+#!/bin/bash
+set -e
+
+echo "🔄 Running database migrations..."
+cd /app
+bunx prisma migrate deploy || {
+  echo "❌ Migration failed!"
+  exit 1
+}
+echo "✅ Migrations completed successfully"
+
+echo "🚀 Starting application..."
+exec bun start

eslint.config.mjs

@@ -11,6 +11,11 @@ const compat = new FlatCompat({
 
 const eslintConfig = [
   ...compat.extends("next/core-web-vitals", "next/typescript"),
+  {
+    rules: {
+      "@typescript-eslint/no-explicit-any": "warn",
+    },
+  },
 ];
 
 export default eslintConfig;

package.json

@@ -1,6 +1,6 @@
 {
   "name": "desa-darmasaba",
-  "version": "0.1.5",
+  "version": "0.1.17",
   "private": true,
   "scripts": {
     "dev": "next dev",
@@ -8,7 +8,8 @@
     "start": "next start",
     "test:api": "vitest run",
     "test:e2e": "playwright test",
-    "test": "bun run test:api && bun run test:e2e"
+    "test": "bun run test:api && bun run test:e2e",
+    "gen:api": ""
   },
   "prisma": {
     "seed": "bun run prisma/seed.ts"
@@ -120,14 +121,16 @@
     "@types/react-dom": "^19",
     "@vitest/ui": "^4.0.18",
     "eslint": "^9",
-    "eslint-config-next": "15.1.6",
+    "eslint-config-next": "15.5.12",
     "jsdom": "^28.0.0",
     "msw": "^2.12.9",
     "parcel": "^2.6.2",
+    "playwright-mcp": "^0.0.19",
     "postcss": "^8.5.1",
     "postcss-preset-mantine": "^1.17.0",
     "postcss-simple-vars": "^7.0.1",
     "typescript": "^5",
     "vitest": "^4.0.18"
-  }
+  },
+  "packageManager": "yarn@1.22.22+sha512.a6b2f7906b721bba3d67d4aff083df04dad64c399707841b7acf00f6b133b7ac24255f2652fa22ae3534329dc6180534e98d17432037ff6fd140556e2bb3137e"
 }

prisma/_seeder_list/core/seed_app_menu.ts

@@ -0,0 +1,57 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../load-json";
+
+const appMenuJson = loadJsonData("core/app-menu.json");
+const appMenuChildJson = loadJsonData("core/app-menu-child.json");
+
+export async function seedAppMenu() {
+  console.log("🔄 Seeding AppMenu...");
+
+  for (const item of appMenuJson) {
+    await prisma.appMenu.upsert({
+      where: { id: item.id },
+      update: {
+        name: item.name,
+        link: item.link,
+        isActive: item.isActive,
+      },
+      create: {
+        id: item.id,
+        name: item.name,
+        link: item.link,
+        isActive: item.isActive,
+      },
+    });
+
+    console.log(`✅ AppMenu seeded: ${item.name}`);
+  }
+
+  console.log("🎉 AppMenu seed selesai");
+}
+
+export async function seedAppMenuChild() {
+  console.log("🔄 Seeding AppMenuChild...");
+
+  for (const item of appMenuChildJson) {
+    await prisma.appMenuChild.upsert({
+      where: { id: item.id },
+      update: {
+        name: item.name,
+        link: item.link,
+        isActive: item.isActive,
+        appMenuId: item.appMenuId,
+      },
+      create: {
+        id: item.id,
+        name: item.name,
+        link: item.link,
+        isActive: item.isActive,
+        appMenuId: item.appMenuId,
+      },
+    });
+
+    console.log(`✅ AppMenuChild seeded: ${item.name}`);
+  }
+
+  console.log("🎉 AppMenuChild seed selesai");
+}

prisma/_seeder_list/core/seed_core.ts

@@ -0,0 +1,69 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../load-json";
+
+const layananJson = loadJsonData("core/layanan.json");
+const potensiJson = loadJsonData("core/potensi.json");
+const landingPageLayananJson = loadJsonData("core/landingpage-layanan.json");
+
+export async function seedLayananCore() {
+  console.log("🔄 Seeding Layanan...");
+
+  for (const item of layananJson) {
+    await prisma.layanan.upsert({
+      where: { id: item.id },
+      update: {
+        name: item.name,
+      },
+      create: {
+        id: item.id,
+        name: item.name,
+      },
+    });
+
+    console.log(`✅ Layanan seeded: ${item.name}`);
+  }
+
+  console.log("🎉 Layanan seed selesai");
+}
+
+export async function seedPotensiCore() {
+  console.log("🔄 Seeding Potensi...");
+
+  for (const item of potensiJson) {
+    await prisma.potensi.upsert({
+      where: { id: item.id },
+      update: {
+        name: item.name,
+      },
+      create: {
+        id: item.id,
+        name: item.name,
+      },
+    });
+
+    console.log(`✅ Potensi seeded: ${item.name}`);
+  }
+
+  console.log("🎉 Potensi seed selesai");
+}
+
+export async function seedLandingPageLayanan() {
+  console.log("🔄 Seeding LandingPage_Layanan...");
+
+  for (const item of landingPageLayananJson) {
+    await prisma.landingPage_Layanan.upsert({
+      where: { id: item.id },
+      update: {
+        deksripsi: item.deksripsi,
+      },
+      create: {
+        id: item.id,
+        deksripsi: item.deksripsi,
+      },
+    });
+
+    console.log(`✅ LandingPage_Layanan seeded: ${item.id}`);
+  }
+
+  console.log("🎉 LandingPage_Layanan seed selesai");
+}

prisma/_seeder_list/desa/berita/seed_berita.ts

@@ -1,6 +1,8 @@
 import prisma from "@/lib/prisma";
-import kategoriBerita from "../../../data/desa/berita/kategori-berita.json";
-import beritaJson from "../../../data/desa/berita/berita.json";
+import { loadJsonData } from "../../../load-json";
+
+const kategoriBerita = loadJsonData("desa/berita/kategori-berita.json");
+const beritaJson = loadJsonData("desa/berita/berita.json");
 
 export async function seedBerita() {
   // ================== SUBMENU BERITA ========================

prisma/_seeder_list/desa/gallery/foto/seed_foto.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import foto from "../../../../data/desa/gallery/foto/foto.json";
+import { loadJsonData } from "../../../../load-json";
+
+const foto = loadJsonData("desa/gallery/foto/foto.json");
 
 export async function seedFoto() {
   console.log("🔄 Seeding Foto...");

prisma/_seeder_list/desa/gallery/video/seed_video.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import galleryVideo from "../../../../data/desa/gallery/video/video.json";
+import { loadJsonData } from "../../../../load-json";
+
+const galleryVideo = loadJsonData("desa/gallery/video/video.json");
 
 export async function seedVideo() {
   console.log("🔄 Seeding Gallery Video...");

prisma/_seeder_list/desa/layanan/seed_layanan.ts

@@ -1,8 +1,10 @@
 import prisma from "@/lib/prisma";
-import pelayananSuratKeterangan from "../../../data/desa/layanan/pelayananSuratKeterangan.json";
-import pelayananTelunjukSaktiDesa from "../../../data/desa/layanan/pelayananTelunjukSaktiDesa.json";
-import pelayananPerizinanBerusaha from "../../../data/desa/layanan/pelayananPerizinanBerusaha.json";
-import pelayananPendudukNonPermanen from "../../../data/desa/layanan/pelayananPendudukNonPermanen.json";
+import { loadJsonData } from "../../../load-json";
+
+const pelayananSuratKeterangan = loadJsonData("desa/layanan/pelayananSuratKeterangan.json");
+const pelayananTelunjukSaktiDesa = loadJsonData("desa/layanan/pelayananTelunjukSaktiDesa.json");
+const pelayananPerizinanBerusaha = loadJsonData("desa/layanan/pelayananPerizinanBerusaha.json");
+const pelayananPendudukNonPermanen = loadJsonData("desa/layanan/pelayananPendudukNonPermanen.json");
 
 export async function seedLayanan() {
   console.log("🔄 Seeding Pelayanan Surat Keterangan...");

prisma/_seeder_list/desa/musik-desa/seed_musik_desa.ts

@@ -0,0 +1,57 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../../load-json";
+
+const musikJson = loadJsonData("desa/musik-desa/musik-desa.json");
+
+export async function seedMusikDesa() {
+  console.log("Seeding Musik Desa...");
+
+  for (const item of musikJson) {
+    let audioFileId: string | null = null;
+    let coverImageId: string | null = null;
+
+    if (item.audioFileName) {
+      const audio = await prisma.fileStorage.findUnique({
+        where: { name: item.audioFileName },
+        select: { id: true },
+      });
+      if (audio) audioFileId = audio.id;
+    }
+
+    if (item.coverImageName) {
+      const cover = await prisma.fileStorage.findUnique({
+        where: { name: item.coverImageName },
+        select: { id: true },
+      });
+      if (cover) coverImageId = cover.id;
+    }
+
+    await prisma.musikDesa.upsert({
+      where: { id: item.id },
+      update: {
+        judul: item.judul,
+        artis: item.artis,
+        deskripsi: item.deskripsi,
+        durasi: item.durasi,
+        audioFileId,
+        coverImageId,
+        genre: item.genre,
+        tahunRilis: item.tahunRilis,
+      },
+      create: {
+        id: item.id,
+        judul: item.judul,
+        artis: item.artis,
+        deskripsi: item.deskripsi,
+        durasi: item.durasi,
+        audioFileId,
+        coverImageId,
+        genre: item.genre,
+        tahunRilis: item.tahunRilis,
+      },
+    });
+    console.log(`  Musik: ${item.judul} - ${item.artis}`);
+  }
+
+  console.log("Musik Desa seed selesai");
+}

prisma/_seeder_list/desa/penghargaan/penghargaan.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import penghargaan from "../../../data/desa/penghargaan/penghargaan.json"
+import { loadJsonData } from "../../../load-json";
+
+const penghargaan = loadJsonData("desa/penghargaan/penghargaan.json");
 
 export async function seedPenghargaan() {
   console.log("🔄 Seeding Penghargaan...");

prisma/_seeder_list/desa/pengumuman/seed_pengumuman.ts

@@ -1,7 +1,9 @@
 import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../../load-json";
 import { safeSeedUnique } from "../../../safeseedUnique";
-import kategoriPengumuman from "../../../data/desa/pengumuman/kategori-pengumuman.json";
-import pengumuman from "../../../data/desa/pengumuman/pengumuman.json";
+
+const kategoriPengumuman = loadJsonData("desa/pengumuman/kategori-pengumuman.json");
+const pengumuman = loadJsonData("desa/pengumuman/pengumuman.json");
 
 export async function seedPengumuman() {
   console.log("🔄 Seeding Kategori Pengumuman...");

prisma/_seeder_list/desa/potensi/seed_potensi.ts

@@ -1,6 +1,8 @@
 import prisma from "@/lib/prisma";
-import kategoriPotensi from "../../../data/desa/potensi/kategori-potensi.json";
-import potensiDesa from "../../../data/desa/potensi/potensi-desa.json";
+import { loadJsonData } from "../../../load-json";
+
+const kategoriPotensi = loadJsonData("desa/potensi/kategori-potensi.json");
+const potensiDesa = loadJsonData("desa/potensi/potensi-desa.json");
 
 export async function seedPotensi() {
   console.log("🔄Seeding Kategori Potensi Desa ...");

prisma/_seeder_list/desa/profile-desa/seed_profile_desa.ts

@@ -1,10 +1,12 @@
 import prisma from "@/lib/prisma";
-import lambangDesa from "../../../data/desa/profile/lambang_desa.json";
-import maskotDesa from "../../../data/desa/profile/maskot_desa.json";
-import profilePerbekel from "../../../data/desa/profile/profil_perbekel.json";
-import profileDesaImage from "../../../data/desa/profile/profileDesaImage.json";
-import sejarahDesa from "../../../data/desa/profile/sejarah_desa.json";
-import visiMisiDesa from "../../../data/desa/profile/visi_misi_desa.json";
+import { loadJsonData } from "../../../load-json";
+
+const lambangDesa = loadJsonData("desa/profile/lambang_desa.json");
+const maskotDesa = loadJsonData("desa/profile/maskot_desa.json");
+const profilePerbekel = loadJsonData("desa/profile/profil_perbekel.json");
+const profileDesaImage = loadJsonData("desa/profile/profileDesaImage.json");
+const sejarahDesa = loadJsonData("desa/profile/sejarah_desa.json");
+const visiMisiDesa = loadJsonData("desa/profile/visi_misi_desa.json");
 
 export async function seedProfileDesa() {
   // =========== SEJARAH DESA ===========

prisma/_seeder_list/desa/profile-desa/seed_profile_perbekel.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import perbekelDariMasaKeMasa from "../../../data/desa/profile/profile-perbekel-lalu.json";
+import { loadJsonData } from "../../../load-json";
+
+const perbekelDariMasaKeMasa = loadJsonData("desa/profile/profile-perbekel-lalu.json");
 
 export async function seedProfilePerbekel() {
    console.log("🔄 Seeding Perbekel Dari Masa Ke Masa...");

prisma/_seeder_list/ekonomi/seed_apbdes.ts

@@ -0,0 +1,45 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../load-json";
+
+const apbdesJson = loadJsonData("ekonomi/apbdes/apbdes.json");
+
+export async function seedAPBDes() {
+  console.log("Seeding APBDes...");
+
+  for (const item of apbdesJson) {
+    let imageId: string | null = null;
+    let fileId: string | null = null;
+
+    if (item.imageName) {
+      const image = await prisma.fileStorage.findUnique({
+        where: { name: item.imageName },
+        select: { id: true },
+      });
+      if (image) imageId = image.id;
+    }
+
+    await prisma.aPBDes.upsert({
+      where: { id: item.id },
+      update: {
+        tahun: item.tahun,
+        name: item.name,
+        deskripsi: item.deskripsi,
+        jumlah: item.jumlah,
+        imageId,
+        fileId,
+      },
+      create: {
+        id: item.id,
+        tahun: item.tahun,
+        name: item.name,
+        deskripsi: item.deskripsi,
+        jumlah: item.jumlah,
+        imageId,
+        fileId,
+      },
+    });
+    console.log(`  APBDes: ${item.name}`);
+  }
+
+  console.log("APBDes seed selesai");
+}

prisma/_seeder_list/ekonomi/seed_apbdes_item.ts

@@ -0,0 +1,63 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../load-json";
+
+const itemsJson = loadJsonData("ekonomi/apbdes/apbdes-items.json");
+const realisasiJson = loadJsonData("ekonomi/apbdes/realisasi-items.json");
+
+export async function seedAPBDesItem() {
+  console.log("Seeding APBDes Items...");
+
+  // Seed items first (sorted by level to ensure parents exist)
+  const sortedItems = [...itemsJson].sort((a, b) => a.level - b.level);
+
+  for (const item of sortedItems) {
+    await prisma.aPBDesItem.upsert({
+      where: { id: item.id },
+      update: {
+        kode: item.kode,
+        uraian: item.uraian,
+        anggaran: item.anggaran,
+        tipe: item.tipe,
+        level: item.level,
+        parentId: item.parentId,
+        apbdesId: item.apbdesId,
+      },
+      create: {
+        id: item.id,
+        kode: item.kode,
+        uraian: item.uraian,
+        anggaran: item.anggaran,
+        tipe: item.tipe,
+        level: item.level,
+        parentId: item.parentId,
+        apbdesId: item.apbdesId,
+      },
+    });
+    console.log(`  APBDes Item: ${item.kode} - ${item.uraian}`);
+  }
+
+  console.log("Seeding Realisasi Items...");
+  for (const item of realisasiJson) {
+    await prisma.realisasiItem.upsert({
+      where: { id: item.id },
+      update: {
+        kode: item.kode,
+        apbdesItemId: item.apbdesItemId,
+        jumlah: item.jumlah,
+        tanggal: new Date(item.tanggal),
+        keterangan: item.keterangan,
+      },
+      create: {
+        id: item.id,
+        kode: item.kode,
+        apbdesItemId: item.apbdesItemId,
+        jumlah: item.jumlah,
+        tanggal: new Date(item.tanggal),
+        keterangan: item.keterangan,
+      },
+    });
+    console.log(`  Realisasi: ${item.kode} - Rp ${item.jumlah.toLocaleString("id-ID")}`);
+  }
+
+  console.log("APBDes Item & Realisasi seed selesai");
+}

prisma/_seeder_list/ekonomi/seed_demografi_pekerjaan.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import demografiPekerjaan from "../../data/ekonomi/demografi-pekerjaan/demografi-pekerjaan.json";
+import { loadJsonData } from "../../load-json";
+
+const demografiPekerjaan = loadJsonData("ekonomi/demografi-pekerjaan/demografi-pekerjaan.json");
 
 export async function seedDemografiPekerjaan() {
   console.log("🔄 Seeding Demografi Pekerjaan...");

prisma/_seeder_list/ekonomi/seed_jumlah_penduduk_miskin.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import jumlahPendudukMiskin from "../../data/ekonomi/jumlah-penduduk-miskin/jumlah-penduduk-miskin.json";
+import { loadJsonData } from "../../load-json";
+
+const jumlahPendudukMiskin = loadJsonData("ekonomi/jumlah-penduduk-miskin/jumlah-penduduk-miskin.json");
 
 export async function seedJumlahPendudukMiskin() {
   console.log("🔄 Seeding Jumlah Penduduk Miskin...");

prisma/_seeder_list/ekonomi/seed_jumlah_pengangguran.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import jumlahPengangguran from "../../data/ekonomi/jumlah-pengangguran/detail-data-pengangguran.json";
+import { loadJsonData } from "../../load-json";
+
+const jumlahPengangguran = loadJsonData("ekonomi/jumlah-pengangguran/detail-data-pengangguran.json");
 
 export async function seedJumlahPengangguran() {
   for (const d of jumlahPengangguran) {

prisma/_seeder_list/ekonomi/seed_lowongan_kerja_lokal.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import lowonganKerjaLokal from "../../data/ekonomi/lowongan-kerja-lokal/lowongan-kerja-lokal.json";
+import { loadJsonData } from "../../load-json";
+
+const lowonganKerjaLokal = loadJsonData("ekonomi/lowongan-kerja-lokal/lowongan-kerja-lokal.json");
 
 export async function seedLowonganKerjaLokal() {
   console.log("🔄 Seeding Lowongan Kerja Lokal...");

prisma/_seeder_list/ekonomi/seed_pasar_desa.ts

@@ -1,7 +1,9 @@
 import prisma from "@/lib/prisma";
-import kategoriProduk from "../../data/ekonomi/pasar-desa/kategori-produk.json";
-import pasarDesa from "../../data/ekonomi/pasar-desa/pasar-desa.json";
-import kategoriToPasar from "../../data/ekonomi/pasar-desa/kategori-to-pasar.json";
+import { loadJsonData } from "../../load-json";
+
+const kategoriProduk = loadJsonData("ekonomi/pasar-desa/kategori-produk.json");
+const pasarDesa = loadJsonData("ekonomi/pasar-desa/pasar-desa.json");
+const kategoriToPasar = loadJsonData("ekonomi/pasar-desa/kategori-to-pasar.json");
 
 export async function seedPasarDesa() {
   console.log("🔄 Seeding Kategori Produk...");

prisma/_seeder_list/ekonomi/seed_pendapatan_asli.ts

@@ -1,8 +1,10 @@
 import prisma from "@/lib/prisma";
-import apbdes from "../../data/ekonomi/pendapatan-asli-desa/apbDesa.json";
-import pendapatan from "../../data/ekonomi/pendapatan-asli-desa/pendapatanDesa.json";
-import belanja from "../../data/ekonomi/pendapatan-asli-desa/belanjaDesa.json";
-import pembiayaan from "../../data/ekonomi/pendapatan-asli-desa/pembiayaanDesa.json";
+import { loadJsonData } from "../../load-json";
+
+const apbdes = loadJsonData("ekonomi/pendapatan-asli-desa/apbDesa.json");
+const pendapatan = loadJsonData("ekonomi/pendapatan-asli-desa/pendapatanDesa.json");
+const belanja = loadJsonData("ekonomi/pendapatan-asli-desa/belanjaDesa.json");
+const pembiayaan = loadJsonData("ekonomi/pendapatan-asli-desa/pembiayaanDesa.json");
 
 export async function seedPendapatanAsli() {
   console.log("🔄 Seeding Pendapatan Asli...");

prisma/_seeder_list/ekonomi/seed_penduduk_usia_kerja_yang_menganggur.ts

@@ -1,6 +1,8 @@
 import prisma from "@/lib/prisma";
-import grafikMenganggurBerdasarkanUsia from "../../data/ekonomi/jumlah-penduduk-usia-kerja-yang-menganggur/pengangguran-berdasarkan-usia.json";
-import grafikMenganggurBerdasarkanPendidikan from "../../data/ekonomi/jumlah-penduduk-usia-kerja-yang-menganggur/pengangguran-berdasarkan-pendidikan.json";
+import { loadJsonData } from "../../load-json";
+
+const grafikMenganggurBerdasarkanUsia = loadJsonData("ekonomi/jumlah-penduduk-usia-kerja-yang-menganggur/pengangguran-berdasarkan-usia.json");
+const grafikMenganggurBerdasarkanPendidikan = loadJsonData("ekonomi/jumlah-penduduk-usia-kerja-yang-menganggur/pengangguran-berdasarkan-pendidikan.json");
 
 export async function seedPendudukUsiaKerjaYangMenganggur() {
   for (const p of grafikMenganggurBerdasarkanUsia) {

prisma/_seeder_list/ekonomi/seed_program_kemiskinan.ts

@@ -1,6 +1,8 @@
 import prisma from "@/lib/prisma";
-import programKemiskinan from "../../data/ekonomi/program-kemiskinan/program-kemiskinan.json";
-import statistikKemiskinan from "../../data/ekonomi/program-kemiskinan/statistik-kemiskinan.json";
+import { loadJsonData } from "../../load-json";
+
+const programKemiskinan = loadJsonData("ekonomi/program-kemiskinan/program-kemiskinan.json");
+const statistikKemiskinan = loadJsonData("ekonomi/program-kemiskinan/statistik-kemiskinan.json");
 
 export async function seedProgramKemiskinan() {
   for (const s of statistikKemiskinan) {

prisma/_seeder_list/ekonomi/seed_sektor_unggulan_desa.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import sektorUnggulanDesa from "../../data/ekonomi/sektor-unggulan/sektor-unggulan.json";
+import { loadJsonData } from "../../load-json";
+
+const sektorUnggulanDesa = loadJsonData("ekonomi/sektor-unggulan/sektor-unggulan.json");
 
 export async function seedSektorUnggulanDesa() {
    console.log("🔄 Seeding Sektor Unggulan Desa...");

prisma/_seeder_list/ekonomi/seed_struktur_bumdes.ts

@@ -1,6 +1,28 @@
 import prisma from "@/lib/prisma";
-import posisiOrganisasiBumDes from "../../data/ekonomi/struktur-organisasi/posisi-organisasi-bumdes.json";
-import pegawai from "../../data/ekonomi/struktur-organisasi/pegawai-bumdes.json";
+import { loadJsonData } from "../../load-json";
+
+interface PosisiOrganisasi {
+  id: string;
+  nama: string;
+  deskripsi: string;
+  hierarki: number;
+  parentId: string | null;
+}
+
+interface PegawaiBumDes {
+  id: string;
+  namaLengkap: string;
+  gelarAkademik: string;
+  tanggalMasuk: string;
+  email: string;
+  telepon: string;
+  alamat: string;
+  posisiId: string;
+  isActive: boolean;
+}
+
+const posisiOrganisasiBumDes = loadJsonData<PosisiOrganisasi[][]>("ekonomi/struktur-organisasi/posisi-organisasi-bumdes.json");
+const pegawai = loadJsonData<PegawaiBumDes[]>("ekonomi/struktur-organisasi/pegawai-bumdes.json");
 
 export async function seedStrukturBumdes() {
   const flattenedPosisi = posisiOrganisasiBumDes.flat();

prisma/_seeder_list/inovasi/seed_ajukan.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import ajukanIde from "../../data/inovasi/ajukan-ide/ajukan-ide.json";
+import { loadJsonData } from "../../load-json";
+
+const ajukanIde = loadJsonData("inovasi/ajukan-ide/ajukan-ide.json");
 
 export async function seedAjukan() {
   console.log("🔄 Seeding Ajukan Ide Inovatif...");

prisma/_seeder_list/inovasi/seed_desa_digital.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import desaDigital from "../../data/inovasi/desa-digital/desa-digital.json";
+import { loadJsonData } from "../../load-json";
+
+const desaDigital = loadJsonData("inovasi/desa-digital/desa-digital.json");
 
 export async function seedDesaDigital() {
   console.log("🔄 Seeding Desa Digital...");

prisma/_seeder_list/inovasi/seed_info_teknologi.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import infoTeknologi from "../../data/inovasi/info-teknologi/info-teknologi.json";
+import { loadJsonData } from "../../load-json";
+
+const infoTeknologi = loadJsonData("inovasi/info-teknologi/info-teknologi.json");
 
 export async function seedInfoTeknologi() {
   console.log("🔄 Seeding Info Teknologi...");

prisma/_seeder_list/inovasi/seed_kolaborasi_inovasi.ts

@@ -1,6 +1,8 @@
 import prisma from "@/lib/prisma";
-import kolaborasiInovasi from "../../data/inovasi/kolaborasi-inovasi/kolaborasi-inovasi.json";
-import mitraKolaborasi from "../../data/inovasi/kolaborasi-inovasi/mitra-kolaborasi.json";
+import { loadJsonData } from "../../load-json";
+
+const kolaborasiInovasi = loadJsonData("inovasi/kolaborasi-inovasi/kolaborasi-inovasi.json");
+const mitraKolaborasi = loadJsonData("inovasi/kolaborasi-inovasi/mitra-kolaborasi.json");
 
 export async function seedKolaborasiInovasi() {
   console.log("🔄 Seeding Kolaborasi Inovasi...");

prisma/_seeder_list/inovasi/seed_layanan_online_desa.ts

@@ -1,8 +1,10 @@
 import prisma from "@/lib/prisma";
-import jenisLayanan from "../../data/inovasi/layanan-online-desa/jenis-layanan.json";
-import administrasiOnline from "../../data/inovasi/layanan-online-desa/administrasi-online.json";
-import jenisPengaduan from "../../data/inovasi/layanan-online-desa/jenis-pengaduan.json";
-import pengaduanMasyarakat from "../../data/inovasi/layanan-online-desa/pengaduan-masyarakat.json";
+import { loadJsonData } from "../../load-json";
+
+const jenisLayanan = loadJsonData("inovasi/layanan-online-desa/jenis-layanan.json");
+const administrasiOnline = loadJsonData("inovasi/layanan-online-desa/administrasi-online.json");
+const jenisPengaduan = loadJsonData("inovasi/layanan-online-desa/jenis-pengaduan.json");
+const pengaduanMasyarakat = loadJsonData("inovasi/layanan-online-desa/pengaduan-masyarakat.json");
 
 export async function seedLayananOnlineDesa() {
   console.log("🔄 Seeding Jenis Layanan...");

prisma/_seeder_list/inovasi/seed_program_kreatif_desa.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import programKreatif from "../../data/inovasi/program-kreatif-desa/program-kreatif-desa.json";
+import { loadJsonData } from "../../load-json";
+
+const programKreatif = loadJsonData("inovasi/program-kreatif-desa/program-kreatif-desa.json");
 
 export async function seedProgramKreatifDesa() {
   console.log("🔄 Seeding Program Kreatif...");

prisma/_seeder_list/keamanan/seed_keamanan_lingkungan.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import keamananLingkunganJson from "../../data/keamanan/keamanan-lingkungan/keamanan-lingkungan.json";
+import { loadJsonData } from "../../load-json";
+
+const keamananLingkunganJson = loadJsonData("keamanan/keamanan-lingkungan/keamanan-lingkungan.json");
 
 export async function seedKeamananLingkungan() {
 console.log("🔄 Seeding Keamanan Lingkungan...");

prisma/_seeder_list/keamanan/seed_kontak_darurat.ts

@@ -1,7 +1,9 @@
 import prisma from "@/lib/prisma";
-import kontakDaruratKeamanan from "../../data/keamanan/kontak-darurat-keamanan/kontak-darurat-keamanan.json";
-import kontakItem from "../../data/keamanan/kontak-darurat-keamanan/kontakItem.json";
-import kontakDaruratToItem from "../../data/keamanan/kontak-darurat-keamanan/kontakDaruratToItem.json";
+import { loadJsonData } from "../../load-json";
+
+const kontakDaruratKeamanan = loadJsonData("keamanan/kontak-darurat-keamanan/kontak-darurat-keamanan.json");
+const kontakItem = loadJsonData("keamanan/kontak-darurat-keamanan/kontakItem.json");
+const kontakDaruratToItem = loadJsonData("keamanan/kontak-darurat-keamanan/kontakDaruratToItem.json");
 
 export async function seedKontakDaruratKeamanan() {
  console.log("🔄 Seeding Kontak Item...");

prisma/_seeder_list/keamanan/seed_laporan_publik.ts

@@ -1,6 +1,8 @@
 import prisma from "@/lib/prisma";
-import laporanPublik from "../../data/keamanan/laporan-publik/laporan-publik.json";
-import penangananLaporan from "../../data/keamanan/laporan-publik/penanganan-laporan.json";
+import { loadJsonData } from "../../load-json";
+
+const laporanPublik = loadJsonData("keamanan/laporan-publik/laporan-publik.json");
+const penangananLaporan = loadJsonData("keamanan/laporan-publik/penanganan-laporan.json");
 
 export async function seedLaporanPublik() {
   console.log("🔄 Seeding Laporan Publik...");

prisma/_seeder_list/keamanan/seed_pencegahan_kriminalitas.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import pencegahanKriminalitas from "../../data/keamanan/pencegahan-kriminalitas/pencegahan-kriminalitas.json";
+import { loadJsonData } from "../../load-json";
+
+const pencegahanKriminalitas = loadJsonData("keamanan/pencegahan-kriminalitas/pencegahan-kriminalitas.json");
 
 export async function seedPencegahanKriminalitas() {
   console.log("🔄 Seeding Pencegahan Kriminalitas...");

prisma/_seeder_list/keamanan/seed_polsek_terdekat.ts

@@ -1,7 +1,9 @@
 import prisma from "@/lib/prisma";
-import layananPolsek from "../../data/keamanan/polsek-terdekat/layanan-polsek.json";
-import polsekTerdekat from "../../data/keamanan/polsek-terdekat/polsek-terdekat.json";
-import layananToPolsek from "../../data/keamanan/polsek-terdekat/layanan-to-polsek.json";
+import { loadJsonData } from "../../load-json";
+
+const layananPolsek = loadJsonData("keamanan/polsek-terdekat/layanan-polsek.json");
+const polsekTerdekat = loadJsonData("keamanan/polsek-terdekat/polsek-terdekat.json");
+const layananToPolsek = loadJsonData("keamanan/polsek-terdekat/layanan-to-polsek.json");
 
 export async function seedPolsekTerdekat() {
    console.log("🔄 Seeding Layanan Polsek...");

prisma/_seeder_list/keamanan/seed_tips_keamanan.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import tipsKeamananJson from "../../data/keamanan/tips-keamanan/tips-keamanan.json";
+import { loadJsonData } from "../../load-json";
+
+const tipsKeamananJson = loadJsonData("keamanan/tips-keamanan/tips-keamanan.json");
 
 export async function seedTipsKeamanan() {
    console.log("🔄 Seeding Tips Keamanan...");

prisma/_seeder_list/kependudukan/seed_data_banjar.ts

@@ -0,0 +1,32 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../load-json";
+
+const dataBanjarJson = loadJsonData("kependudukan/data-banjar/data-banjar.json");
+
+export async function seedDataBanjar() {
+  console.log("Seeding Data Banjar...");
+
+  for (const item of dataBanjarJson) {
+    await prisma.dataBanjar.upsert({
+      where: { id: item.id },
+      update: {
+        nama: item.nama,
+        penduduk: item.penduduk,
+        kk: item.kk,
+        miskin: item.miskin,
+        tahun: item.tahun,
+      },
+      create: {
+        id: item.id,
+        nama: item.nama,
+        penduduk: item.penduduk,
+        kk: item.kk,
+        miskin: item.miskin,
+        tahun: item.tahun,
+      },
+    });
+    console.log(`  Banjar: ${item.nama} (${item.penduduk} penduduk)`);
+  }
+
+  console.log("Data Banjar seed selesai");
+}

prisma/_seeder_list/kependudukan/seed_dinamika_penduduk.ts

@@ -0,0 +1,32 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../load-json";
+
+const dinamikaPendudukJson = loadJsonData("kependudukan/dinamika-penduduk/dinamika-penduduk.json");
+
+export async function seedDinamikaPenduduk() {
+  console.log("Seeding Dinamika Penduduk...");
+
+  for (const item of dinamikaPendudukJson) {
+    await prisma.dinamikaPenduduk.upsert({
+      where: { id: item.id },
+      update: {
+        tahun: item.tahun,
+        kelahiran: item.kelahiran,
+        kematian: item.kematian,
+        masuk: item.masuk,
+        keluar: item.keluar,
+      },
+      create: {
+        id: item.id,
+        tahun: item.tahun,
+        kelahiran: item.kelahiran,
+        kematian: item.kematian,
+        masuk: item.masuk,
+        keluar: item.keluar,
+      },
+    });
+    console.log(`  Tahun ${item.tahun}: ${item.kelahiran} kelahiran, ${item.kematian} kematian`);
+  }
+
+  console.log("Dinamika Penduduk seed selesai");
+}

prisma/_seeder_list/kependudukan/seed_distribusi_agama.ts

@@ -0,0 +1,28 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../load-json";
+
+const distribusiAgamaJson = loadJsonData("kependudukan/distribusi-agama/distribusi-agama.json");
+
+export async function seedDistribusiAgama() {
+  console.log("Seeding Distribusi Agama...");
+
+  for (const item of distribusiAgamaJson) {
+    await prisma.distribusiAgama.upsert({
+      where: { id: item.id },
+      update: {
+        agama: item.agama,
+        jumlah: item.jumlah,
+        tahun: item.tahun,
+      },
+      create: {
+        id: item.id,
+        agama: item.agama,
+        jumlah: item.jumlah,
+        tahun: item.tahun,
+      },
+    });
+    console.log(`  ${item.agama}: ${item.jumlah} penganut`);
+  }
+
+  console.log("Distribusi Agama seed selesai");
+}

prisma/_seeder_list/kependudukan/seed_distribusi_umur.ts

@@ -0,0 +1,28 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../load-json";
+
+const distribusiUmurJson = loadJsonData("kependudukan/distribusi-umur/distribusi-umur.json");
+
+export async function seedDistribusiUmur() {
+  console.log("Seeding Distribusi Umur...");
+
+  for (const item of distribusiUmurJson) {
+    await prisma.distribusiUmur.upsert({
+      where: { id: item.id },
+      update: {
+        rentangUmur: item.rentangUmur,
+        jumlah: item.jumlah,
+        tahun: item.tahun,
+      },
+      create: {
+        id: item.id,
+        rentangUmur: item.rentangUmur,
+        jumlah: item.jumlah,
+        tahun: item.tahun,
+      },
+    });
+    console.log(`  Rentang ${item.rentangUmur}: ${item.jumlah} jiwa`);
+  }
+
+  console.log("Distribusi Umur seed selesai");
+}

prisma/_seeder_list/kependudukan/seed_migrasi_penduduk.ts

@@ -0,0 +1,34 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../load-json";
+
+const migrasiPendudukJson = loadJsonData("kependudukan/migrasi-penduduk/migrasi-penduduk.json");
+
+export async function seedMigrasiPenduduk() {
+  console.log("Seeding MigrASI PENDUDUK...");
+
+  for (const item of migrasiPendudukJson) {
+    await prisma.migrasiPenduduk.upsert({
+      where: { id: item.id },
+      update: {
+        nama: item.nama,
+        jenis: item.jenis,
+        tanggal: new Date(item.tanggal),
+        asal: item.asal,
+        tujuan: item.tujuan,
+        alasan: item.alasan,
+      },
+      create: {
+        id: item.id,
+        nama: item.nama,
+        jenis: item.jenis,
+        tanggal: new Date(item.tanggal),
+        asal: item.asal,
+        tujuan: item.tujuan,
+        alasan: item.alasan,
+      },
+    });
+    console.log(`  ${item.nama}: ${item.jenis} (${item.alasan})`);
+  }
+
+  console.log("Migrasi Penduduk seed selesai");
+}

prisma/_seeder_list/kesehatan/artikel-kesehatan/seed_artikel_kesehatan.ts

@@ -0,0 +1,106 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../../load-json";
+
+const artikelJson = loadJsonData("kesehatan/artikel-kesehatan/artikel-kesehatan.json");
+const introJson = loadJsonData("kesehatan/artikel-kesehatan/introduction.json");
+const symptomJson = loadJsonData("kesehatan/artikel-kesehatan/symptom.json");
+const preventionJson = loadJsonData("kesehatan/artikel-kesehatan/prevention.json");
+const firstAidJson = loadJsonData("kesehatan/artikel-kesehatan/first-aid.json");
+const mythVsFactJson = loadJsonData("kesehatan/artikel-kesehatan/myth-vs-fact.json");
+const doctorSignJson = loadJsonData("kesehatan/artikel-kesehatan/doctor-sign.json");
+
+export async function seedArtikelKesehatan() {
+  console.log("Seeding Introduction...");
+  for (const item of introJson) {
+    await prisma.introduction.upsert({
+      where: { id: item.id },
+      update: { content: item.content },
+      create: { id: item.id, content: item.content },
+    });
+  }
+
+  console.log("Seeding Symptom...");
+  for (const item of symptomJson) {
+    await prisma.symptom.upsert({
+      where: { id: item.id },
+      update: { title: item.title, content: item.content },
+      create: { id: item.id, title: item.title, content: item.content },
+    });
+  }
+
+  console.log("Seeding Prevention...");
+  for (const item of preventionJson) {
+    await prisma.prevention.upsert({
+      where: { id: item.id },
+      update: { title: item.title, content: item.content },
+      create: { id: item.id, title: item.title, content: item.content },
+    });
+  }
+
+  console.log("Seeding First Aid...");
+  for (const item of firstAidJson) {
+    await prisma.firstAid.upsert({
+      where: { id: item.id },
+      update: { title: item.title, content: item.content },
+      create: { id: item.id, title: item.title, content: item.content },
+    });
+  }
+
+  console.log("Seeding Myth vs Fact...");
+  for (const item of mythVsFactJson) {
+    await prisma.mythVsFact.upsert({
+      where: { id: item.id },
+      update: {
+        title: item.title,
+        mitos: item.mitos,
+        fakta: item.fakta,
+      },
+      create: {
+        id: item.id,
+        title: item.title,
+        mitos: item.mitos,
+        fakta: item.fakta,
+      },
+    });
+  }
+
+  console.log("Seeding Doctor Sign...");
+  for (const item of doctorSignJson) {
+    await prisma.doctorSign.upsert({
+      where: { id: item.id },
+      update: { content: item.content },
+      create: { id: item.id, content: item.content },
+    });
+  }
+
+  console.log("Seeding Artikel Kesehatan...");
+  for (const item of artikelJson) {
+    await prisma.artikelKesehatan.upsert({
+      where: { id: item.id },
+      update: {
+        title: item.title,
+        content: item.content,
+        introductionId: item.introductionId,
+        symptomId: item.symptomId,
+        preventionId: item.preventionId,
+        firstAidId: item.firstAidId,
+        mythVsFactId: item.mythVsFactId,
+        doctorSignId: item.doctorSignId,
+      },
+      create: {
+        id: item.id,
+        title: item.title,
+        content: item.content,
+        introductionId: item.introductionId,
+        symptomId: item.symptomId,
+        preventionId: item.preventionId,
+        firstAidId: item.firstAidId,
+        mythVsFactId: item.mythVsFactId,
+        doctorSignId: item.doctorSignId,
+      },
+    });
+    console.log(`  Artikel: ${item.title}`);
+  }
+
+  console.log("Artikel Kesehatan seed selesai");
+}

prisma/_seeder_list/kesehatan/fasilitas-kesehatan/seed_fasilitas_kesehatan.ts

@@ -0,0 +1,122 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../../load-json";
+
+const faskesJson = loadJsonData("kesehatan/fasilitas-kesehatan/fasilitas-kesehatan.json");
+const infoUmumJson = loadJsonData("kesehatan/fasilitas-kesehatan/informasi-umum.json");
+const layananUnggulanJson = loadJsonData("kesehatan/fasilitas-kesehatan/layanan-unggulan.json");
+const dokterJson = loadJsonData("kesehatan/fasilitas-kesehatan/dokter-tenaga-medis.json");
+const fasilitasPendukungJson = loadJsonData("kesehatan/fasilitas-kesehatan/fasilitas-pendukung.json");
+const prosedurJson = loadJsonData("kesehatan/fasilitas-kesehatan/prosedur-pendaftaran.json");
+const tarifJson = loadJsonData("kesehatan/fasilitas-kesehatan/tarif-layanan.json");
+
+export async function seedFasilitasKesehatan() {
+  console.log("Seeding Informasi Umum...");
+  for (const item of infoUmumJson) {
+    await prisma.informasiUmum.upsert({
+      where: { id: item.id },
+      update: {
+        fasilitas: item.fasilitas,
+        alamat: item.alamat,
+        jamOperasional: item.jamOperasional,
+      },
+      create: {
+        id: item.id,
+        fasilitas: item.fasilitas,
+        alamat: item.alamat,
+        jamOperasional: item.jamOperasional,
+      },
+    });
+    console.log(`  Informasi Umum: ${item.fasilitas}`);
+  }
+
+  console.log("Seeding Layanan Unggulan...");
+  for (const item of layananUnggulanJson) {
+    await prisma.layananUnggulan.upsert({
+      where: { id: item.id },
+      update: { content: item.content },
+      create: { id: item.id, content: item.content },
+    });
+  }
+
+  console.log("Seeding Fasilitas Pendukung...");
+  for (const item of fasilitasPendukungJson) {
+    await prisma.fasilitasPendukung.upsert({
+      where: { id: item.id },
+      update: { content: item.content },
+      create: { id: item.id, content: item.content },
+    });
+  }
+
+  console.log("Seeding Prosedur Pendaftaran...");
+  for (const item of prosedurJson) {
+    await prisma.prosedurPendaftaran.upsert({
+      where: { id: item.id },
+      update: { content: item.content },
+      create: { id: item.id, content: item.content },
+    });
+  }
+
+  console.log("Seeding Tarif dan Layanan...");
+  for (const item of tarifJson) {
+    await prisma.tarifDanLayanan.upsert({
+      where: { id: item.id },
+      update: { layanan: item.layanan, tarif: item.tarif },
+      create: { id: item.id, layanan: item.layanan, tarif: item.tarif },
+    });
+    console.log(`  Tarif: ${item.layanan}`);
+  }
+
+  console.log("Seeding Dokter dan Tenaga Medis...");
+  for (const item of dokterJson) {
+    await prisma.dokterdanTenagaMedis.upsert({
+      where: { id: item.id },
+      update: {
+        name: item.name,
+        specialist: item.specialist,
+        jadwal: item.jadwal,
+        jadwalLibur: item.jadwalLibur,
+        jamBukaOperasional: item.jamBukaOperasional,
+        jamTutupOperasional: item.jamTutupOperasional,
+        jamBukaLibur: item.jamBukaLibur,
+        jamTutupLibur: item.jamTutupLibur,
+      },
+      create: {
+        id: item.id,
+        name: item.name,
+        specialist: item.specialist,
+        jadwal: item.jadwal,
+        jadwalLibur: item.jadwalLibur,
+        jamBukaOperasional: item.jamBukaOperasional,
+        jamTutupOperasional: item.jamTutupOperasional,
+        jamBukaLibur: item.jamBukaLibur,
+        jamTutupLibur: item.jamTutupLibur,
+      },
+    });
+    console.log(`  Dokter: ${item.name}`);
+  }
+
+  console.log("Seeding Fasilitas Kesehatan...");
+  for (const item of faskesJson) {
+    await prisma.fasilitasKesehatan.upsert({
+      where: { id: item.id },
+      update: {
+        name: item.name,
+        informasiUmumId: item.informasiUmumId,
+        layananUnggulanId: item.layananUnggulanId,
+        fasilitasPendukungId: item.fasilitasPendukungId,
+        prosedurPendaftaranId: item.prosedurPendaftaranId,
+      },
+      create: {
+        id: item.id,
+        name: item.name,
+        informasiUmumId: item.informasiUmumId,
+        layananUnggulanId: item.layananUnggulanId,
+        fasilitasPendukungId: item.fasilitasPendukungId,
+        prosedurPendaftaranId: item.prosedurPendaftaranId,
+      },
+    });
+    console.log(`  Fasilitas Kesehatan: ${item.name}`);
+  }
+
+  console.log("Fasilitas Kesehatan seed selesai");
+}

prisma/_seeder_list/kesehatan/info-wabah-penyakit/seed_info_wabah_penyakit.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import infoWabahPenyakitJson from "../../../data/kesehatan/infowabahpenyakit/infowabahpenyakit.json";
+import { loadJsonData } from "../../../load-json";
+
+const infoWabahPenyakitJson = loadJsonData("kesehatan/infowabahpenyakit/infowabahpenyakit.json");
 
 export async function seedInfoWabahPenyakit() {
 console.log("🔄 Seeding Info Wabah Penyakit...");

prisma/_seeder_list/kesehatan/jadwal-kegiatan/seed_jadwal_kegiatan.ts

@@ -0,0 +1,123 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../../load-json";
+
+const jadwalJson = loadJsonData("kesehatan/jadwal-kegiatan/jadwal-kegiatan.json");
+const infoJadwalJson = loadJsonData("kesehatan/jadwal-kegiatan/informasi-jadwal.json");
+const deskJadwalJson = loadJsonData("kesehatan/jadwal-kegiatan/deskripsi-jadwal.json");
+const layananJadwalJson = loadJsonData("kesehatan/jadwal-kegiatan/layanan-jadwal.json");
+const syaratJadwalJson = loadJsonData("kesehatan/jadwal-kegiatan/syarat-ketentuan.json");
+const dokumenJadwalJson = loadJsonData("kesehatan/jadwal-kegiatan/dokumen-jadwal.json");
+const daftarJadwalJson = loadJsonData("kesehatan/jadwal-kegiatan/pendaftaran-jadwal.json");
+
+export async function seedJadwalKegiatan() {
+  console.log("Seeding Informasi Jadwal Kegiatan...");
+  for (const item of infoJadwalJson) {
+    await prisma.informasiJadwalKegiatan.upsert({
+      where: { id: item.id },
+      update: {
+        name: item.name,
+        tanggal: item.tanggal,
+        waktu: item.waktu,
+        lokasi: item.lokasi,
+      },
+      create: {
+        id: item.id,
+        name: item.name,
+        tanggal: item.tanggal,
+        waktu: item.waktu,
+        lokasi: item.lokasi,
+      },
+    });
+    console.log(`  Informasi: ${item.name}`);
+  }
+
+  console.log("Seeding Deskripsi Jadwal Kegiatan...");
+  for (const item of deskJadwalJson) {
+    await prisma.deskripsiJadwalKegiatan.upsert({
+      where: { id: item.id },
+      update: { deskripsi: item.deskripsi },
+      create: { id: item.id, deskripsi: item.deskripsi },
+    });
+  }
+
+  console.log("Seeding Layanan Jadwal Kegiatan...");
+  for (const item of layananJadwalJson) {
+    await prisma.layananJadwalKegiatan.upsert({
+      where: { id: item.id },
+      update: { content: item.content },
+      create: { id: item.id, content: item.content },
+    });
+  }
+
+  console.log("Seeding Syarat & Ketentuan Jadwal...");
+  for (const item of syaratJadwalJson) {
+    await prisma.syaratKetentuanJadwalKegiatan.upsert({
+      where: { id: item.id },
+      update: { content: item.content },
+      create: { id: item.id, content: item.content },
+    });
+  }
+
+  console.log("Seeding Dokumen Jadwal Kegiatan...");
+  for (const item of dokumenJadwalJson) {
+    await prisma.dokumenJadwalKegiatan.upsert({
+      where: { id: item.id },
+      update: { content: item.content },
+      create: { id: item.id, content: item.content },
+    });
+  }
+
+  console.log("Seeding Pendaftaran Jadwal Kegiatan...");
+  for (const item of daftarJadwalJson) {
+    await prisma.pendaftaranJadwalKegiatan.upsert({
+      where: { id: item.id },
+      update: {
+        name: item.name,
+        tanggal: item.tanggal,
+        namaOrangtua: item.namaOrtu,
+        nomor: item.nomor,
+        alamat: item.alamat,
+        catatan: item.catatan,
+      },
+      create: {
+        id: item.id,
+        name: item.name,
+        tanggal: item.tanggal,
+        namaOrangtua: item.namaOrtu,
+        nomor: item.nomor,
+        alamat: item.alamat,
+        catatan: item.catatan,
+      },
+    });
+    console.log(`  Pendaftaran: ${item.name}`);
+  }
+
+  console.log("Seeding Jadwal Kegiatan...");
+  for (const item of jadwalJson) {
+    await prisma.jadwalKegiatan.upsert({
+      where: { id: item.id },
+      update: {
+        content: item.content,
+        informasiJadwalKegiatanId: item.informasiJadwalKegiatanId,
+        deskripsiJadwalKegiatanId: item.deskripsiJadwalKegiatanId,
+        layananJadwalKegiatanId: item.layananJadwalKegiatanId,
+        syaratKetentuanJadwalKegiatanId: item.syaratKetentuanJadwalKegiatanId,
+        dokumenJadwalKegiatanId: item.dokumenJadwalKegiatanId,
+        pendaftaranJadwalKegiatanId: item.pendaftaranJadwalKegiatanId,
+      },
+      create: {
+        id: item.id,
+        content: item.content,
+        informasiJadwalKegiatanId: item.informasiJadwalKegiatanId,
+        deskripsiJadwalKegiatanId: item.deskripsiJadwalKegiatanId,
+        layananJadwalKegiatanId: item.layananJadwalKegiatanId,
+        syaratKetentuanJadwalKegiatanId: item.syaratKetentuanJadwalKegiatanId,
+        dokumenJadwalKegiatanId: item.dokumenJadwalKegiatanId,
+        pendaftaranJadwalKegiatanId: item.pendaftaranJadwalKegiatanId,
+      },
+    });
+    console.log(`  Jadwal Kegiatan seeded`);
+  }
+
+  console.log("Jadwal Kegiatan seed selesai");
+}

prisma/_seeder_list/kesehatan/kontak-darurat/seed_kontak_darurat.ts

@@ -1,6 +1,8 @@
-import kontakDaruratJson from "../../../data/kesehatan/kontak-darurat/kontak-darurat.json";
+import { loadJsonData } from "../../../load-json";
 import prisma from "@/lib/prisma";
 
+const kontakDaruratJson = loadJsonData("kesehatan/kontak-darurat/kontak-darurat.json");
+
 export async function seedKontakDarurat() {
   console.log("🔄 Seeding Kontak Darurat...");
 

prisma/_seeder_list/kesehatan/penanganan-darurat/seed_penanganan_darurat.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import penangananDaruratJson from "../../../data/kesehatan/penanganan-darurat/penganan-darurat.json";
+import { loadJsonData } from "../../../load-json";
+
+const penangananDaruratJson = loadJsonData("kesehatan/penanganan-darurat/penganan-darurat.json");
 
 export async function seedPenangananDarurat() {
   console.log("🔄 Seeding Penanganan Darurat...");

prisma/_seeder_list/kesehatan/posyandu/seed_posyandu.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import posyanduJson from "../../../data/kesehatan/posyandu/posyandu.json";
+import { loadJsonData } from "../../../load-json";
+
+const posyanduJson = loadJsonData("kesehatan/posyandu/posyandu.json");
 
 export async function seedPosyandu() {
   console.log("🔄 Seeding Posyandu...");

prisma/_seeder_list/kesehatan/program-kesehatan/seed_program_kesehatan.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import programKesehatanJson from "../../../data/kesehatan/program-kesehatan/program-kesehatan.json";
+import { loadJsonData } from "../../../load-json";
+
+const programKesehatanJson = loadJsonData("kesehatan/program-kesehatan/program-kesehatan.json");
 
 export async function seedProgramKesehatan() {
   for (const p of programKesehatanJson) {

prisma/_seeder_list/kesehatan/puskesmas/seed_puskesmas.ts

@@ -1,7 +1,9 @@
 import prisma from "@/lib/prisma";
-import puskesmasJson from "../../../data/kesehatan/puskesmas/puskesmas.json";
-import kontakPuskesmasJson from "../../../data/kesehatan/puskesmas/kontak-puskesmas/kontak.json";
-import jamPuskesmasJson from "../../../data/kesehatan/puskesmas/jam-puskesmas/jam.json";
+import { loadJsonData } from "../../../load-json";
+
+const puskesmasJson = loadJsonData("kesehatan/puskesmas/puskesmas.json");
+const kontakPuskesmasJson = loadJsonData("kesehatan/puskesmas/kontak-puskesmas/kontak.json");
+const jamPuskesmasJson = loadJsonData("kesehatan/puskesmas/jam-puskesmas/jam.json");
 
 export async function seedPuskesmas() {
   console.log("🔄 Seeding Kontak Puskesmas...");

prisma/_seeder_list/kesehatan/seed_grafik_kepuasan.ts

@@ -0,0 +1,32 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../load-json";
+
+const grafikKepuasanJson = loadJsonData("kesehatan/grafik-kepuasan/grafik-kepuasan.json");
+
+export async function seedGrafikKepuasan() {
+  console.log("Seeding Grafik Kepuasan...");
+
+  for (const item of grafikKepuasanJson) {
+    await prisma.grafikKepuasan.upsert({
+      where: { id: item.id },
+      update: {
+        nama: item.nama,
+        tanggal: new Date(item.tanggal),
+        jenisKelamin: item.jenisKelamin,
+        alamat: item.alamat,
+        penyakit: item.penyakit,
+      },
+      create: {
+        id: item.id,
+        nama: item.nama,
+        tanggal: new Date(item.tanggal),
+        jenisKelamin: item.jenisKelamin,
+        alamat: item.alamat,
+        penyakit: item.penyakit,
+      },
+    });
+    console.log(`  Grafik Kepuasan: ${item.nama}`);
+  }
+
+  console.log("Grafik Kepuasan seed selesai");
+}

prisma/_seeder_list/kesehatan/seed_kelahiran_kematian.ts

@@ -0,0 +1,70 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../load-json";
+
+const kelahiranJson = loadJsonData("kesehatan/kelahiran/kelahiran.json");
+const kematianJson = loadJsonData("kesehatan/kematian/kematian.json");
+const dataKematianKelahiranJson = loadJsonData("kesehatan/kematian-kelahiran/data-kematian-kelahiran.json");
+
+export async function seedKelahiranKematian() {
+  console.log("Seeding Kelahiran...");
+  for (const item of kelahiranJson) {
+    await prisma.kelahiran.upsert({
+      where: { id: item.id },
+      update: {
+        nama: item.nama,
+        tanggal: new Date(item.tanggal),
+        jenisKelamin: item.jenisKelamin,
+        alamat: item.alamat,
+      },
+      create: {
+        id: item.id,
+        nama: item.nama,
+        tanggal: new Date(item.tanggal),
+        jenisKelamin: item.jenisKelamin,
+        alamat: item.alamat,
+      },
+    });
+    console.log(`  Kelahiran: ${item.nama}`);
+  }
+
+  console.log("Seeding Kematian...");
+  for (const item of kematianJson) {
+    await prisma.kematian.upsert({
+      where: { id: item.id },
+      update: {
+        nama: item.nama,
+        tanggal: new Date(item.tanggal),
+        jenisKelamin: item.jenisKelamin,
+        alamat: item.alamat,
+        penyebab: item.penyebab,
+      },
+      create: {
+        id: item.id,
+        nama: item.nama,
+        tanggal: new Date(item.tanggal),
+        jenisKelamin: item.jenisKelamin,
+        alamat: item.alamat,
+        penyebab: item.penyebab,
+      },
+    });
+    console.log(`  Kematian: ${item.nama}`);
+  }
+
+  console.log("Seeding Data Kematian-Kelahiran...");
+  for (const item of dataKematianKelahiranJson) {
+    await prisma.dataKematian_Kelahiran.upsert({
+      where: { id: item.id },
+      update: {
+        kematianId: item.kematianId,
+        kelahiranId: item.kelahiranId,
+      },
+      create: {
+        id: item.id,
+        kematianId: item.kematianId,
+        kelahiranId: item.kelahiranId,
+      },
+    });
+  }
+
+  console.log("Kelahiran & Kematian seed selesai");
+}

prisma/_seeder_list/landing-page/desa-anti-korupsi/seed_desa_anti_korupsi.ts

@@ -1,6 +1,8 @@
 import prisma from "@/lib/prisma";
-import kategoriDesaAntiKorupsi from "../../../data/landing-page/desa-anti-korupsi/kategoriDesaAntiKorupsi.json"
-import desaAntiKorupsi from "../../../data/landing-page/desa-anti-korupsi/desaantiKorpusi.json"
+import { loadJsonData } from "../../../load-json";
+
+const kategoriDesaAntiKorupsi = loadJsonData("landing-page/desa-anti-korupsi/kategoriDesaAntiKorupsi.json");
+const desaAntiKorupsi = loadJsonData("landing-page/desa-anti-korupsi/desaantiKorpusi.json");
 
 export async function seedDesaAntiKorupsi() {
     for (const k of kategoriDesaAntiKorupsi) {

prisma/_seeder_list/landing-page/prestasi-desa/seed_prestasi_desa.ts

@@ -1,6 +1,8 @@
 import prisma from "@/lib/prisma";
-import prestasiDesa from "../../../data/landing-page/prestasi-desa/prestasi-desa.json"
-import kategoriPrestasiDesa from "../../../data/landing-page/prestasi-desa/kategori-prestasi.json"
+import { loadJsonData } from "../../../load-json";
+
+const prestasiDesa = loadJsonData("landing-page/prestasi-desa/prestasi-desa.json");
+const kategoriPrestasiDesa = loadJsonData("landing-page/prestasi-desa/kategori-prestasi.json");
 
 export async function seedPrestasiDesa() {
 

prisma/_seeder_list/landing-page/profil_landing_page/seed_media_sosial.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import mediaSosial from "../../../data/landing-page/profile/mediaSosial.json"
+import { loadJsonData } from "../../../load-json";
+
+const mediaSosial = loadJsonData("landing-page/profile/mediaSosial.json");
 
 export async function seedMediaSosial() {
   console.log("🔄 Seeding Media Sosial...");

prisma/_seeder_list/landing-page/profil_landing_page/seed_profile_lp.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import profilePejabatDesa from "../../../data/landing-page/profile/profile.json";
+import { loadJsonData } from "../../../load-json";
+
+const profilePejabatDesa = loadJsonData("landing-page/profile/profile.json");
 
 export async function seedProfileLP() {
   console.log("🔄 Seeding Pejabat Desa...");

prisma/_seeder_list/landing-page/profil_landing_page/seed_program_inovasi.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import programInovasi from "../../../data/landing-page/profile/programInovasi.json";
+import { loadJsonData } from "../../../load-json";
+
+const programInovasi = loadJsonData("landing-page/profile/programInovasi.json");
 
 export async function seedProgramInovasi() {
     console.log("🔄 Seeding Program Inovasi...");

prisma/_seeder_list/landing-page/sdgs/seed_sdgs.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import sdgsDesa from "../../../data/landing-page/sdgs-desa/sdgs-desa.json";
+import { loadJsonData } from "../../../load-json";
+
+const sdgsDesa = loadJsonData("landing-page/sdgs-desa/sdgs-desa.json");
 
 export async function seedSDGSDesa() {
   console.log("🔄 Seeding SDGS Desa...");

prisma/_seeder_list/lingkungan/seed_data_gotong_royong.ts

@@ -1,6 +1,8 @@
 import prisma from "@/lib/prisma";
-import kategoriGotongRoyong from "../../data/lingkungan/gotong-royong/kategori-gotong-royong.json";
-import gotongRoyong from "../../data/lingkungan/gotong-royong/gotong-royong.json";
+import { loadJsonData } from "../../load-json";
+
+const kategoriGotongRoyong = loadJsonData("lingkungan/gotong-royong/kategori-gotong-royong.json");
+const gotongRoyong = loadJsonData("lingkungan/gotong-royong/gotong-royong.json");
 
 export async function seedDataGotongRoyong() {
   console.log("🔄 Seeding Kategori Gotong Royong...");

prisma/_seeder_list/lingkungan/seed_data_lingkungan_desa.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import dataLingkunganDesa from "../../data/lingkungan/data-lingkungan-desa/data-lingkungan-desa.json";
+import { loadJsonData } from "../../load-json";
+
+const dataLingkunganDesa = loadJsonData("lingkungan/data-lingkungan-desa/data-lingkungan-desa.json");
 
 export async function seedDataLingkunganDesa() {
   console.log("🔄 Seeding Data Lingkungan Desa...");

prisma/_seeder_list/lingkungan/seed_edukasi_lingkungan.ts

@@ -1,7 +1,9 @@
 import prisma from "@/lib/prisma";
-import tujuanEdukasiLingkungan from "../../data/lingkungan/edukasi-lingkungan/tujuan-edukasi-lingkungan.json";
-import materiEdukasiLingkungan from "../../data/lingkungan/edukasi-lingkungan/materi-edukasi-yang-diberikan.json";
-import contohEdukasiLingkungan from "../../data/lingkungan/edukasi-lingkungan/contoh-kegiatan-di-desa-darmasaba.json";
+import { loadJsonData } from "../../load-json";
+
+const tujuanEdukasiLingkungan = loadJsonData("lingkungan/edukasi-lingkungan/tujuan-edukasi-lingkungan.json");
+const materiEdukasiLingkungan = loadJsonData("lingkungan/edukasi-lingkungan/materi-edukasi-yang-diberikan.json");
+const contohEdukasiLingkungan = loadJsonData("lingkungan/edukasi-lingkungan/contoh-kegiatan-di-desa-darmasaba.json");
 
 export async function seedEdukasiLingkungan() {
   for (const e of tujuanEdukasiLingkungan) {

prisma/_seeder_list/lingkungan/seed_konservasi_adat_bali.ts

@@ -1,7 +1,9 @@
 import prisma from "@/lib/prisma";
-import filosofiTriHita from "../../data/lingkungan/konservasi-adat-bali/filosofi-tri-hita.json";
-import bentukKonservasiBerdasarkanAdat from "../../data/lingkungan/konservasi-adat-bali/bentuk-konservasi.json";
-import nilaiKonservasiAdat from "../../data/lingkungan/konservasi-adat-bali/nilai-konservasi-adat.json";
+import { loadJsonData } from "../../load-json";
+
+const filosofiTriHita = loadJsonData("lingkungan/konservasi-adat-bali/filosofi-tri-hita.json");
+const bentukKonservasiBerdasarkanAdat = loadJsonData("lingkungan/konservasi-adat-bali/bentuk-konservasi.json");
+const nilaiKonservasiAdat = loadJsonData("lingkungan/konservasi-adat-bali/nilai-konservasi-adat.json");
 
 export async function seedKonservasiAdatBali() {
   for (const f of filosofiTriHita) {

prisma/_seeder_list/lingkungan/seed_pengelolaan_sampah.ts

@@ -1,6 +1,8 @@
 import prisma from "@/lib/prisma";
-import pengelolaanSampah from "../../data/lingkungan/pengelolaan-sampah/pengelolaan-sampah.json";
-import keteranganBankSampah from "../../data/lingkungan/pengelolaan-sampah/keterangan-bank-sampah.json";
+import { loadJsonData } from "../../load-json";
+
+const pengelolaanSampah = loadJsonData("lingkungan/pengelolaan-sampah/pengelolaan-sampah.json");
+const keteranganBankSampah = loadJsonData("lingkungan/pengelolaan-sampah/keterangan-bank-sampah.json");
 
 export async function seedPengelolaanSampah() {
   console.log("🔄 Seeding Pengelolaan Sampah...");

prisma/_seeder_list/lingkungan/seed_program_penghijauan.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import programPenghijauan from "../../data/lingkungan/program-penghijauan/program-penghijauan.json";
+import { loadJsonData } from "../../load-json";
+
+const programPenghijauan = loadJsonData("lingkungan/program-penghijauan/program-penghijauan.json");
 
 export async function seedProgramPenghijauan() {
   console.log("🔄 Seeding Program Penghijauan...");

prisma/_seeder_list/pendidikan/seed_beasiswa_pendaftar.ts

@@ -0,0 +1,58 @@
+import prisma from "@/lib/prisma";
+import { loadJsonData } from "../../load-json";
+
+const beasiswaJson = loadJsonData("pendidikan/beasiswa-pendaftar/beasiswa-pendaftar.json");
+
+export async function seedBeasiswaPendaftar() {
+  console.log("Seeding Beasiswa Pendaftar...");
+
+  for (const item of beasiswaJson) {
+    await prisma.beasiswaPendaftar.upsert({
+      where: { id: item.id },
+      update: {
+        namaLengkap: item.namaLengkap,
+        nis: item.nis,
+        kelas: item.kelas,
+        jenisKelamin: item.jenisKelamin,
+        alamatDomisili: item.alamatDomisili,
+        tempatLahir: item.tempatLahir,
+        tanggalLahir: new Date(item.tanggalLahir),
+        namaOrtu: item.namaOrtu,
+        nik: item.nik,
+        pekerjaanOrtu: item.pekerjaanOrtu,
+        penghasilan: item.penghasilan,
+        noHp: item.noHp,
+        kewarganegaraan: item.kewarganegaraan,
+        agama: item.agama,
+        alamatKTP: item.alamatKTP,
+        email: item.email,
+        statusPernikahan: item.statusPernikahan,
+        ukuranBaju: item.ukuranBaju,
+      },
+      create: {
+        id: item.id,
+        namaLengkap: item.namaLengkap,
+        nis: item.nis,
+        kelas: item.kelas,
+        jenisKelamin: item.jenisKelamin,
+        alamatDomisili: item.alamatDomisili,
+        tempatLahir: item.tempatLahir,
+        tanggalLahir: new Date(item.tanggalLahir),
+        namaOrtu: item.namaOrtu,
+        nik: item.nik,
+        pekerjaanOrtu: item.pekerjaanOrtu,
+        penghasilan: item.penghasilan,
+        noHp: item.noHp,
+        kewarganegaraan: item.kewarganegaraan,
+        agama: item.agama,
+        alamatKTP: item.alamatKTP,
+        email: item.email,
+        statusPernikahan: item.statusPernikahan,
+        ukuranBaju: item.ukuranBaju,
+      },
+    });
+    console.log(`  Beasiswa: ${item.namaLengkap} (NIS: ${item.nis})`);
+  }
+
+  console.log("Beasiswa Pendaftar seed selesai");
+}

prisma/_seeder_list/pendidikan/seed_bimbingan_belajar.ts

@@ -1,7 +1,9 @@
 import prisma from "@/lib/prisma";
-import tujuanBimbinganBelajarDesa from "../../data/pendidikan/bimbingan-belajar-desa/tujuan-bimbingan-belajar-desa.json";
-import lokasiJadwalBimbinganBelajarDesa from "../../data/pendidikan/bimbingan-belajar-desa/lokasi-dan-jadwal.json";
-import fasilitasBimbinganBelajarDesa from "../../data/pendidikan/bimbingan-belajar-desa/fasilitas-yang-disediakan.json";
+import { loadJsonData } from "../../load-json";
+
+const tujuanBimbinganBelajarDesa = loadJsonData("pendidikan/bimbingan-belajar-desa/tujuan-bimbingan-belajar-desa.json");
+const lokasiJadwalBimbinganBelajarDesa = loadJsonData("pendidikan/bimbingan-belajar-desa/lokasi-dan-jadwal.json");
+const fasilitasBimbinganBelajarDesa = loadJsonData("pendidikan/bimbingan-belajar-desa/fasilitas-yang-disediakan.json");
 
 export async function seedBimbinganBelajar() {
 for (const t of tujuanBimbinganBelajarDesa) {

prisma/_seeder_list/pendidikan/seed_data_pendidikan.ts

@@ -1,5 +1,7 @@
 import prisma from "@/lib/prisma";
-import dataPendidikan from "../../data/pendidikan/data-pendidikan/data-pendidikan.json";
+import { loadJsonData } from "../../load-json";
+
+const dataPendidikan = loadJsonData("pendidikan/data-pendidikan/data-pendidikan.json");
 
 export async function seedDataPendidikan() {
  console.log("🔄 Seeding Data pendidikan...");

prisma/_seeder_list/pendidikan/seed_data_perpustakaan.ts

@@ -1,6 +1,8 @@
 import prisma from "@/lib/prisma";
-import dataPerpustakaan from "../../data/pendidikan/perpustakaan-digital/perpustakaan-digital.json";
-import kategoriBuku from "../../data/pendidikan/perpustakaan-digital/kategori-buku.json";
+import { loadJsonData } from "../../load-json";
+
+const dataPerpustakaan = loadJsonData("pendidikan/perpustakaan-digital/perpustakaan-digital.json");
+const kategoriBuku = loadJsonData("pendidikan/perpustakaan-digital/kategori-buku.json");
 
 export async function seedDataPerpustakaan() {
   console.log("🔄 Seeding Kategori Buku...");

prisma/_seeder_list/pendidikan/seed_info_program_pendidikan.ts

@@ -1,6 +1,8 @@
 import prisma from "@/lib/prisma";
-import tujuanProgram from "../../data/pendidikan/program-pendidikan-anak/tujuan-program.json";
-import programUnggulan from "../../data/pendidikan/program-pendidikan-anak/program-unggulan.json";
+import { loadJsonData } from "../../load-json";
+
+const tujuanProgram = loadJsonData("pendidikan/program-pendidikan-anak/tujuan-program.json");
+const programUnggulan = loadJsonData("pendidikan/program-pendidikan-anak/program-unggulan.json");
 
 export async function seedInfoProgramPendidikan() {
   for (const t of tujuanProgram) {

prisma/_seeder_list/pendidikan/seed_info_sekolah.ts

@@ -1,8 +1,10 @@
 import prisma from "@/lib/prisma";
-import jenjangPendidikan from "../../data/pendidikan/info-sekolah/jenjang-pendidikan.json";
-import lembagaPendidikan from "../../data/pendidikan/info-sekolah/lembaga.json";
-import siswa from "../../data/pendidikan/info-sekolah/siswa.json";
-import pengajar from "../../data/pendidikan/info-sekolah/pengajar.json";
+import { loadJsonData } from "../../load-json";
+
+const jenjangPendidikan = loadJsonData("pendidikan/info-sekolah/jenjang-pendidikan.json");
+const lembagaPendidikan = loadJsonData("pendidikan/info-sekolah/lembaga.json");
+const siswa = loadJsonData("pendidikan/info-sekolah/siswa.json");
+const pengajar = loadJsonData("pendidikan/info-sekolah/pengajar.json");
 
 export async function seedInfoSekolah() {
   for (const j of jenjangPendidikan) {

prisma/_seeder_list/pendidikan/seed_keunggulan_program.ts

@@ -0,0 +1,32 @@
+import prisma from "@/lib/prisma";
+import { readFileSync } from "fs";
+import { join } from "path";
+
+const keunggulanJson = JSON.parse(
+  readFileSync(
+    join(process.cwd(), "prisma/data/pendidikan/keunggulan-program/keunggulan-program.json"),
+    "utf-8"
+  )
+);
+
+export async function seedKeunggulanProgram() {
+  console.log("Seeding Keunggulan Program...");
+
+  for (const item of keunggulanJson) {
+    await prisma.keunggulanProgram.upsert({
+      where: { id: item.id },
+      update: {
+        judul: item.judul,
+        deskripsi: item.deskripsi,
+      },
+      create: {
+        id: item.id,
+        judul: item.judul,
+        deskripsi: item.deskripsi,
+      },
+    });
+    console.log(`  Keunggulan: ${item.judul}`);
+  }
+
+  console.log("Keunggulan Program seed selesai");
+}

prisma/_seeder_list/pendidikan/seed_pendidikan_non_formal.ts

@@ -1,7 +1,9 @@
 import prisma from "@/lib/prisma";
-import tujuanProgram from "../../data/pendidikan/pendidikan-non-formal/tujuan-program2.json";
-import tempatKegiatan from "../../data/pendidikan/pendidikan-non-formal/tempat-kegiatan.json";
-import jenisProgramYangDiselenggarakan from "../../data/pendidikan/pendidikan-non-formal/jenis-program-yang-diselenggarakan.json";
+import { loadJsonData } from "../../load-json";
+
+const tujuanProgram = loadJsonData("pendidikan/pendidikan-non-formal/tujuan-program2.json");
+const tempatKegiatan = loadJsonData("pendidikan/pendidikan-non-formal/tempat-kegiatan.json");
+const jenisProgramYangDiselenggarakan = loadJsonData("pendidikan/pendidikan-non-formal/jenis-program-yang-diselenggarakan.json");
 
 export async function seedPendidikanNonFormal() {
   for (const t of tujuanProgram) {

prisma/_seeder_list/ppid/daftar-informasi-publik-ppid/seed_daftar_informasi_publik_ppid.ts

@@ -1,8 +1,10 @@
 import prisma from "@/lib/prisma";
-import daftarInformasiPublik from "../../../data/ppid/daftar-informasi-publik-desa-darmasaba/daftarInformasi.json"
-import jenisInformasiDiminta from "../../../data/list-jenisInfromasi.json"
-import caraMemperolehInformasi from "../../../data/list-caraMemperolehInformasi.json"
-import caraMemperolehSalinanInformasi from "../../../data/list-caraMemperolehSalinanInformasi.json"
+import { loadJsonData } from "../../../load-json";
+
+const daftarInformasiPublik = loadJsonData("ppid/daftar-informasi-publik-desa-darmasaba/daftarInformasi.json");
+const jenisInformasiDiminta = loadJsonData("list-jenisInfromasi.json");
+const caraMemperolehInformasi = loadJsonData("list-caraMemperolehInformasi.json");
+const caraMemperolehSalinanInformasi = loadJsonData("list-caraMemperolehSalinanInformasi.json");
 
 export async function seedDaftarInformasiPublikPpid() {