Fix WA Otp

### NO Issue
chore(release): 1.6.8
2026-03-05 16:38:31 +08:00 · 2026-03-05 14:30:03 +08:00 · 2026-03-05 14:28:45 +08:00 · 2026-03-04 16:38:58 +08:00 · 2026-03-04 16:36:57 +08:00 · 2026-03-04 16:08:59 +08:00
95 changed files with 1632 additions and 442 deletions
--- a/.env.example
+++ b/.env.example
@@ -0,0 +1,56 @@
+# ==============================
+# Database
+# ==============================
+# Connection pool settings untuk mencegah connection exhaustion:
+# - connection_limit=10: Maksimal 10 koneksi per Prisma Client instance
+# - pool_timeout=20: Timeout menunggu koneksi tersedia (detik)
+# - connect_timeout=10: Timeout untuk membuat koneksi baru (detik)
+DATABASE_URL="postgresql://user:password@localhost:5432/dbname?connection_limit=10&pool_timeout=20&connect_timeout=10"
+
+# ==============================
+# Auth / Session
+# ==============================
+WIBU_PWD="your_wibu_password"
+NEXT_PUBLIC_BASE_TOKEN_KEY="your_token_key"
+NEXT_PUBLIC_BASE_SESSION_KEY="your_session_key"
+
+# ==============================
+# Payment Gateway (Midtrans)
+# ==============================
+Client_KEY="your_midtrans_client_key"
+Server_KEY="your_midtrans_server_key"
+
+# ==============================
+# Maps
+# ==============================
+MAPBOX_TOKEN="your_mapbox_token"
+
+# ==============================
+# Realtime (WebSocket)
+# ==============================
+WS_APIKEY="your_ws_api_key"
+NEXT_PUBLIC_WIBU_REALTIME_TOKEN="your_realtime_token"
+
+# ==============================
+# Email (Resend)
+# ==============================
+RESEND_APIKEY="your_resend_api_key"
+
+# ==============================
+# WhatsApp
+# ==============================
+WA_SERVER_TOKEN="your_wa_server_token"
+
+# ==============================
+# Firebase Admin (Push Notification)
+# ==============================
+FIREBASE_ADMIN_PROJECT_ID="your_firebase_project_id"
+FIREBASE_ADMIN_CLIENT_EMAIL="your_firebase_client_email@project.iam.gserviceaccount.com"
+# Private key: salin dari service account JSON, ganti newline dengan \n
+FIREBASE_ADMIN_PRIVATE_KEY="-----BEGIN PRIVATE KEY-----\nYOUR_PRIVATE_KEY_HERE\n-----END PRIVATE KEY-----\n"
+
+# ==============================
+# App
+# ==============================
+NEXT_PUBLIC_API_URL="http://localhost:3000"
+LOG_LEVEL="info"
--- a/.github/workflows/publish.yml
+++ b/.github/workflows/publish.yml
@@ -0,0 +1,72 @@
+name: Publish Docker to GHCR
+
+on:
+  workflow_dispatch:
+    inputs:
+      environment:
+        description: "Target environment"
+        required: true
+        type: choice
+        options:
+          - production
+          - staging
+      tag:
+        description: "Image tag (e.g. v1.0.0)"
+        required: true
+
+env:
+  REGISTRY: ghcr.io
+  IMAGE_NAME: ${{ github.repository }}
+
+jobs:
+  publish:
+    name: Build & Push to GHCR (${{ github.event.inputs.environment }})
+    runs-on: ubuntu-latest
+    permissions:
+      contents: read
+      packages: write
+    steps:
+      - name: Free disk space
+        run: |
+          sudo rm -rf /usr/share/dotnet
+          sudo rm -rf /usr/local/lib/android
+          sudo rm -rf /opt/ghc
+          sudo rm -rf /opt/hostedtoolcache/CodeQL
+          sudo docker image prune --all --force
+          df -h
+
+      - name: Checkout repository
+        uses: actions/checkout@v4
+
+      - name: Set up QEMU
+        uses: docker/setup-qemu-action@v3
+
+      - name: Set up Docker Buildx
+        uses: docker/setup-buildx-action@v3
+
+      - name: Log in to GitHub Container Registry
+        uses: docker/login-action@v3
+        with:
+          registry: ${{ env.REGISTRY }}
+          username: ${{ github.actor }}
+          password: ${{ secrets.GITHUB_TOKEN }}
+
+      - name: Generate image metadata
+        id: meta
+        uses: docker/metadata-action@v5
+        with:
+          images: ${{ env.REGISTRY }}/${{ env.IMAGE_NAME }}
+          tags: |
+            type=raw,value=${{ github.event.inputs.environment }}-${{ github.event.inputs.tag }}
+            type=raw,value=${{ github.event.inputs.environment }}-latest
+
+      - name: Build and push Docker image
+        uses: docker/build-push-action@v6
+        with:
+          context: .
+          file: ./Dockerfile
+          push: true
+          platforms: linux/amd64
+          tags: ${{ steps.meta.outputs.tags }}
+          labels: ${{ steps.meta.outputs.labels }}
+          no-cache: true
--- a/CHANGELOG.md
+++ b/CHANGELOG.md
@@ -2,6 +2,43 @@

 All notable changes to this project will be documented in this file. See [commit-and-tag-version](https://github.com/absolute-version/commit-and-tag-version) for commit guidelines.

+## [1.6.8](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.6.7...v1.6.8) (2026-03-05)
+
+## [1.6.7](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.6.6...v1.6.7) (2026-03-04)
+
+## [1.6.6](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.6.5...v1.6.6) (2026-03-03)
+
+
+### Bug Fixes
+
+* prisma connection exhaustion & firebase lazy init ([6dba07b](https://wibugit.wibudev.com/wibu/hipmi/commit/6dba07baac6a3ef7d264c13e378a905002401e1b))
+
+## [1.6.5](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.6.4...v1.6.5) (2026-03-03)
+
+
+### Bug Fixes
+
+* error koneksi Prisma - DATABASE_URL tidak loaded di ([a658881](https://wibugit.wibudev.com/wibu/hipmi/commit/a6588818b5d8018b3a634e0ae0846e309569d370))
+
+## [1.6.4](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.6.3...v1.6.4) (2026-03-03)
+
+## [1.6.3](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.6.2...v1.6.3) (2026-03-03)
+
+## [1.6.2](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.6.1...v1.6.2) (2026-02-25)
+
+## [1.6.1](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.6.0...v1.6.1) (2026-02-25)
+
+## [1.6.0](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.5.40...v1.6.0) (2026-02-23)
+
+
+### Features
+
+* Implementasi pagination pada endpoint mobile donation ([e89886e](https://wibugit.wibudev.com/wibu/hipmi/commit/e89886e1dbc8cb4d95e6cc7c2787fb22a1dcaf56))
+* Tambahkan pagination pada API mobile investasi ([a7694bd](https://wibugit.wibudev.com/wibu/hipmi/commit/a7694bd7d5d72b6499443faf99301faca730d3ed))
+* update mobile donation API and related dependencies ([934d6a3](https://wibugit.wibudev.com/wibu/hipmi/commit/934d6a3ef1015367bee85779796df4f11c5e779c))
+
+## [1.5.40](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.5.39...v1.5.40) (2026-02-06)
+
 ## [1.5.39](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.5.38...v1.5.39) (2026-01-30)

 ## [1.5.38](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.5.37...v1.5.38) (2026-01-27)
--- a/CHANGELOG_COMMIT.md
+++ b/CHANGELOG_COMMIT.md
@@ -0,0 +1,39 @@
+## Catatan Perubahan untuk Commit
+
+### Fitur: Penambahan Pagination pada Endpoint Admin Mobile
+
+#### Deskripsi Umum
+Telah dilakukan penambahan fitur pagination pada beberapa endpoint admin mobile untuk meningkatkan kinerja dan pengalaman pengguna saat mengakses data dalam jumlah besar.
+
+#### File yang Diubah
+
+1. **src/app/api/mobile/admin/job/route.ts**
+   - Ditambahkan parameter `page` dari `searchParams`
+   - Diterapkan logika pagination dengan `takeData` (default 10) dan `skipData`
+   - Query `prisma.job.findMany` telah dimodifikasi untuk mendukung pagination
+
+2. **src/app/api/mobile/admin/event/route.ts**
+   - Diperbaiki definisi variabel `page` untuk memastikan tipe data yang konsisten
+   - Ditambahkan default value 1 untuk parameter `page`
+   - Perhitungan `skipData` disesuaikan agar lebih efisien
+
+3. **src/app/api/mobile/admin/event/[id]/participants/route.ts**
+   - Ditambahkan parameter `page` dari `searchParams`
+   - Diterapkan logika pagination dengan `takeData` (default 10) dan `skipData`
+   - Query `prisma.event_Peserta.findMany` telah dimodifikasi untuk mendukung pagination
+
+#### Tujuan Perubahan
+- Meningkatkan kinerja aplikasi saat mengambil data dalam jumlah besar
+- Memungkinkan pengguna untuk mengakses data secara bertahap melalui halaman-halaman
+- Mengurangi beban server saat mengambil data dalam jumlah besar
+- Memberikan pengalaman pengguna yang lebih baik saat mengakses data admin
+
+#### Cara Penggunaan
+Untuk menggunakan fitur pagination, cukup tambahkan parameter `page` pada query string saat melakukan permintaan ke endpoint yang telah dimodifikasi. Contoh:
+```
+GET /api/mobile/admin/job?page=2
+GET /api/mobile/admin/event?page=3
+GET /api/mobile/admin/event/{id}/participants?page=1
+```
+
+Default jumlah data per halaman adalah 10 item.
--- a/72
+++ b/72
@@ -0,0 +1,72 @@
+# ==============================
+# Stage 1: Builder
+# ==============================
+FROM node:20-bookworm-slim AS builder
+
+WORKDIR /app
+
+# Install system deps
+RUN apt-get update && apt-get install -y --no-install-recommends \
+    libc6 \
+    git \
+    openssl \
+    ca-certificates \
+    && rm -rf /var/lib/apt/lists/*
+
+# Copy dependency files first (for better caching)
+COPY package.json package-lock.json* bun.lockb* ./
+
+ENV SHARP_IGNORE_GLOBAL_LIBVIPS=1
+ENV NEXT_TELEMETRY_DISABLED=1
+ENV NODE_OPTIONS="--max-old-space-size=4096"
+
+# 🔥 Skip postinstall scripts (fix onnxruntime error)
+RUN npm install --legacy-peer-deps --ignore-scripts
+
+# Copy full source
+COPY . .
+
+# Use .env.example as build env
+# (Pastikan file ini ada di project)
+RUN cp .env.example .env || true
+
+# Generate Prisma Client
+ENV PRISMA_CLI_BINARY_TARGETS=debian-openssl-3.0.x
+RUN npx prisma generate
+
+# Build Next.js
+RUN npm run build
+
+# ==============================
+# Stage 2: Runner (Production)
+# ==============================
+FROM node:20-bookworm-slim AS runner
+
+WORKDIR /app
+
+ENV NODE_ENV=production
+ENV NEXT_TELEMETRY_DISABLED=1
+
+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 standalone output
+COPY --from=builder /app/.next/standalone ./
+COPY --from=builder /app/.next/static ./.next/static
+COPY --from=builder /app/public ./public
+
+RUN chown -R nextjs:nodejs /app
+
+USER nextjs
+
+EXPOSE 3000
+
+ENV PORT=3000
+ENV HOSTNAME="0.0.0.0"
+
+CMD ["node", "server.js"]
--- a/PROMPT-AI.md
+++ b/PROMPT-AI.md
@@ -1,6 +1,5 @@

-File utama: src/app/api/mobile/event/route.ts
-File refrensi: src/app/api/mobile/job/[id]/[status]/route.ts
+File utama: src/app/api/mobile/admin/forum/[id]/comment/route.ts

 Terapkan pagination pada file "File utama" pada method GET
 Analisa juga file "File utama", jika belum memiliki page dari seachParams maka terapkan. Juga pastikan take dan skip sudah sesuai dengan pagination. Buat default nya menjadi 10 untuk take data
@@ -14,6 +13,33 @@ dan penerapannya pada query
 take: page ? takeData : undefined,
 skip: page ? skipData : undefined,

+Gunakan bahasa indonesia pada cli agar saya mudah membacanya.
+
+<!-- Additinal prompt -->
+File refrensi: src/app/api/mobile/event/[id]/[status]/route.ts
 Anda bisa menggunakan refrensi dari "File refrensi" jika butuh pemahaman dengan tipe fitur yang sama

-Gunakan bahasa indonesia pada cli agar saya mudah membacanya.
+
+<!-- Auto input promt -->
+End-point: src/app/api/mobile/donation/route.ts
+
+Buatkan auto input untuk method POST dengan data yang dibutuhkan sesuai dengan struktur data yang ada di file tersebut, tidak perlu "temporary"  cukup data "permanent" dengan ketentuan sebagai berikut:
+- authorId: string ( cmha6wb9w0001cfndwl9fcse6 )
+- title: string
+- target: number
+- donasiMaster_DurasiId: number ( 3 )
+- donasiMaster_KategoriId: number ( 3 )
+- namaBank: string
+- rekening: string
+- imageId: number ( cm60j9q3m000xc9dc584v8rh8 )
+
+Untuk sisa nya anda bisa bebas mengisi data tersebut.
+
+<!-- COMMIT & PUSH -->
+Branch: mobile-api/10-feb-26
+Jalankan perintah ini: git checkout -b "Branch"
+Setelah itu jalankan perintah ini: git add .
+Setelah itu jalankan perintah ini: git commit -m "
+<Berikan semua catatan perubahan pada branch ini, tampilan pada saya dan pastikan dalam bahasa indonesia. Saya akan cek baru saya akan berikan perintah push>
+"
+Setelah itu jalankan perintah ini: git push origin "Branch"
--- a/QWEN.md
+++ b/QWEN.md
@@ -2,7 +2,7 @@

 ## Project Overview

-HIPMI (Himpunan Pengusaha Muda Indonesia) is a comprehensive Next.js-based web application built for the Indonesian Young Entrepreneurs Association. The project is a sophisticated platform that provides multiple business functionalities including investment management, donations, events, job listings, forums, voting systems, and collaborative projects.
+HIPMI (Himpunan Pengusaha Muya Indonesia) is a comprehensive Next.js-based web application built for the Indonesian Young Entrepreneurs Association. The project is a sophisticated platform that provides multiple business functionalities including investment management, donations, events, job listings, forums, voting systems, and collaborative projects.

 ### Key Technologies
 - **Framework**: Next.js 13+ (with App Router)
@@ -120,14 +120,6 @@ The team follows a structured Git workflow:
   - `style`: Styling changes
   - `perf`: Performance improvements

-### Code Standards
- TypeScript with strict mode enabled
- Component header comments with file description, creator, date
- Function comments with parameter and return value descriptions
- Custom type interface comments
- Error handling comments
- Complex logic comments
-
 ### Commit Message Format
 ```
 type: Short description
@@ -140,6 +132,62 @@ Body:
 References: #issue-number
 ```

+**Example:**
+```
+feat: Tambahkan fitur kalkulator
+
+Deskripsi:
+- Menambahkan fungsi penambahan, pengurangan, perkalian, dan pembagian
+- Memperbolehkan pengguna untuk memasukkan dua angka dan melakukan operasi matematika
+
+Fixes #12
+```
+
+### Code Standards
+- TypeScript with strict mode enabled
+- Component header comments with file description, creator, date
+- Function comments with parameter and return value descriptions
+- Custom type interface comments
+- Error handling comments
+- Complex logic comments
+
+### Comment Standards
+
+**File Header:**
+```typescript
+/**
+ * Nama File: app.ts
+ * Deskripsi: Ini adalah file utama aplikasi.
+ * Pembuat: John Doe
+ * Tanggal: 27 Juli 2023
+ */
+```
+
+**Function Comments:**
+```typescript
+/**
+ * Fungsi untuk menambahkan dua angka.
+ * @param {number} a - Angka pertama.
+ * @param {number} b - Angka kedua.
+ * @returns {number} Hasil penjumlahan a dan b.
+ */
+function addNumbers(a: number, b: number): number {
+  return a + b;
+}
+```
+
+**Custom Type Comments:**
+```typescript
+/**
+ * Interface untuk merepresentasikan informasi pelanggan.
+ */
+interface Customer {
+  id: number; // ID pelanggan
+  name: string; // Nama pelanggan
+  age?: number; // Umur pelanggan (opsional)
+}
+```
+
 ## Project Structure

 ### Main Directories
@@ -198,4 +246,4 @@ References: #issue-number
 ### Data Protection
 - Encrypted tokens
 - Secure API routes
- Proper CORS configuration
+- Proper CORS configuration
--- a/bun.lock
+++ b/bun.lock
@@ -39,6 +39,7 @@
        "@types/react-dom": "18.2.7",
        "@types/uuid": "^9.0.4",
        "autoprefixer": "10.4.14",
+        "axios": "^1.13.5",
        "bufferutil": "^4.0.8",
        "bun": "^1.1.38",
        "caniuse-lite": "^1.0.30001757",
@@ -1324,7 +1325,7 @@

    "axe-core": ["axe-core@4.10.2", "", {}, "sha512-RE3mdQ7P3FRSe7eqCWoeQ/Z9QXrtniSjp1wUjt5nRC3WIpz5rSCve6o3fsZ2aCpJtrZjSZgjwXAoTO5k4tEI0w=="],

-    "axios": ["axios@0.26.1", "", { "dependencies": { "follow-redirects": "^1.14.8" } }, "sha512-fPwcX4EvnSHuInCMItEhAGnaSEXRBjtzh9fOtsE6E1G6p7vl7edEeZe11QHf18+6+9gR5PbKV/sGKNaD8YaMeA=="],
+    "axios": ["axios@1.13.5", "", { "dependencies": { "follow-redirects": "^1.15.11", "form-data": "^4.0.5", "proxy-from-env": "^1.1.0" } }, "sha512-cz4ur7Vb0xS4/KUN0tPWe44eqxrIu31me+fbang3ijiNscE129POzipJJA6zniq2C/Z6sJCjMimjS8Lc/GAs8Q=="],

    "axobject-query": ["axobject-query@4.1.0", "", {}, "sha512-qIj0G9wZbMGNLjLmg1PT6v2mE9AH2zlnADJD/2tC6E00hgmhUOfEB6greHPAfLRSufHqROIUTkw6E+M3lH0PTQ=="],

@@ -1882,7 +1883,7 @@

    "fn.name": ["fn.name@1.1.0", "", {}, "sha512-GRnmB5gPyJpAhTQdSZTSp9uaPSvl09KoYcMQtsB9rQoOmzs9dH6ffeccH+Z+cv6P68Hu5bC6JjRh4Ah/mHSNRw=="],

-    "follow-redirects": ["follow-redirects@1.15.9", "", {}, "sha512-gew4GsXizNgdoRyqmyfMHyAmXsZDk6mHkSxZFCzW9gwlbtOW44CDtYavM+y+72qD/Vq2l550kMF52DT8fOLJqQ=="],
+    "follow-redirects": ["follow-redirects@1.15.11", "", {}, "sha512-deG2P0JfjrTxl50XGCDyfI97ZGVCxIpfKYmfyrQ54n5FO/0gfIES8C/Psl6kWVDolizcaaxZJnTS0QSMxvnsBQ=="],

    "fontfaceobserver": ["fontfaceobserver@2.3.0", "", {}, "sha512-6FPvD/IVyT4ZlNe7Wcn5Fb/4ChigpucKYSvD6a+0iMoLn2inpo711eyIcKjmDtE5XNcgAkSH9uN/nfAeZzHEfg=="],

@@ -1892,7 +1893,7 @@

    "foreground-child": ["foreground-child@3.3.1", "", { "dependencies": { "cross-spawn": "^7.0.6", "signal-exit": "^4.0.1" } }, "sha512-gIXjKqtFuWEgzFRJA9WCQeSJLZDjgJUOMCMzxtvFq/37KojM1BFGufqsCy0r4qSQmYLsZYMeyRqzIWOMup03sw=="],

-    "form-data": ["form-data@4.0.2", "", { "dependencies": { "asynckit": "^0.4.0", "combined-stream": "^1.0.8", "es-set-tostringtag": "^2.1.0", "mime-types": "^2.1.12" } }, "sha512-hGfm/slu0ZabnNt4oaRZ6uREyfCj6P4fT/n6A1rGV+Z0VdGXjfOhVUpkn6qVQONHGIFwmveGXyDs75+nr6FM8w=="],
+    "form-data": ["form-data@4.0.5", "", { "dependencies": { "asynckit": "^0.4.0", "combined-stream": "^1.0.8", "es-set-tostringtag": "^2.1.0", "hasown": "^2.0.2", "mime-types": "^2.1.12" } }, "sha512-8RipRLol37bNs2bhoV67fiTEvdTrbMUYcFTiy3+wuuOnUog2QBHCZWXDRijWQfAkhBj2Uf5UnVaiWwA5vdd82w=="],

    "form-data-encoder": ["form-data-encoder@1.7.2", "", {}, "sha512-qfqtYan3rxrnCk1VYaA4H+Ms9xdpPqvLZa6xmMgFvhO32x7/3J/ExcTd6qpxM0vH2GdMI+poehyBZvqfMTto8A=="],

@@ -3618,6 +3619,8 @@

    "@types/jsonwebtoken/@types/node": ["@types/node@22.19.1", "", { "dependencies": { "undici-types": "~6.21.0" } }, "sha512-LCCV0HdSZZZb34qifBsyWlUmok6W7ouER+oQIGBScS8EsZsQbrtFTUrDX4hOl+CS6p7cnNC4td+qrSVGSCTUfQ=="],

+    "@types/node-fetch/form-data": ["form-data@4.0.2", "", { "dependencies": { "asynckit": "^0.4.0", "combined-stream": "^1.0.8", "es-set-tostringtag": "^2.1.0", "mime-types": "^2.1.12" } }, "sha512-hGfm/slu0ZabnNt4oaRZ6uREyfCj6P4fT/n6A1rGV+Z0VdGXjfOhVUpkn6qVQONHGIFwmveGXyDs75+nr6FM8w=="],
+
    "@types/request/@types/node": ["@types/node@22.19.1", "", { "dependencies": { "undici-types": "~6.21.0" } }, "sha512-LCCV0HdSZZZb34qifBsyWlUmok6W7ouER+oQIGBScS8EsZsQbrtFTUrDX4hOl+CS6p7cnNC4td+qrSVGSCTUfQ=="],

    "@types/request/form-data": ["form-data@2.5.5", "", { "dependencies": { "asynckit": "^0.4.0", "combined-stream": "^1.0.8", "es-set-tostringtag": "^2.1.0", "hasown": "^2.0.2", "mime-types": "^2.1.35", "safe-buffer": "^5.2.1" } }, "sha512-jqdObeR2rxZZbPSGL+3VckHMYtu+f9//KXBsVny6JSX/pa38Fy+bGjuG8eW/H6USNQWhLi8Num++cU2yOCNz4A=="],
@@ -3630,6 +3633,8 @@

    "ast-types/tslib": ["tslib@2.8.1", "", {}, "sha512-oJFu94HQb+KVduSUQL7wnpmqnfmLsOA/nAh6b6EH0wCEoK0/mPeXU6c3wKDV83MkOuHPRHtSXKKU99IBazS/2w=="],

+    "autocannon/form-data": ["form-data@4.0.2", "", { "dependencies": { "asynckit": "^0.4.0", "combined-stream": "^1.0.8", "es-set-tostringtag": "^2.1.0", "mime-types": "^2.1.12" } }, "sha512-hGfm/slu0ZabnNt4oaRZ6uREyfCj6P4fT/n6A1rGV+Z0VdGXjfOhVUpkn6qVQONHGIFwmveGXyDs75+nr6FM8w=="],
+
    "autoprefixer/caniuse-lite": ["caniuse-lite@1.0.30001701", "", {}, "sha512-faRs/AW3jA9nTwmJBSO1PQ6L/EOgsB5HMQQq4iCu5zhPgVVgO/pZRHlmatwijZKetFw8/Pr4q6dEN8sJuq8qTw=="],

    "babel-plugin-polyfill-corejs2/semver": ["semver@6.3.1", "", { "bin": { "semver": "bin/semver.js" } }, "sha512-BR7VvDCVHO+q2xBEWskxS6DJE1qRnb7DxzUrogb71CWoSficBxYsiAGd+Kl0mmq/MprG9yArRkyrQxTO6XjMzA=="],
@@ -3810,6 +3815,8 @@

    "metro-file-map/debug": ["debug@2.6.9", "", { "dependencies": { "ms": "2.0.0" } }, "sha512-bC7ElrdJaJnPbAP+1EotYvqZsb3ecl5wi6Bfi6BJTUcNowp6cvspg0jXznRTKDjm/E7AdgFBVeAPVMNcKGsHMA=="],

+    "midtrans-client/axios": ["axios@0.26.1", "", { "dependencies": { "follow-redirects": "^1.14.8" } }, "sha512-fPwcX4EvnSHuInCMItEhAGnaSEXRBjtzh9fOtsE6E1G6p7vl7edEeZe11QHf18+6+9gR5PbKV/sGKNaD8YaMeA=="],
+
    "minipass-flush/minipass": ["minipass@3.3.6", "", { "dependencies": { "yallist": "^4.0.0" } }, "sha512-DxiNidxSEK+tHG6zOIklvNOwm3hvCrbUrdtzY74U6HKTJxvIDfOUL5W5P2Ghd3DTkhhKPYGqeNUIh5qcM4YBfw=="],

    "minipass-pipeline/minipass": ["minipass@3.3.6", "", { "dependencies": { "yallist": "^4.0.0" } }, "sha512-DxiNidxSEK+tHG6zOIklvNOwm3hvCrbUrdtzY74U6HKTJxvIDfOUL5W5P2Ghd3DTkhhKPYGqeNUIh5qcM4YBfw=="],
@@ -4190,6 +4197,12 @@

    "metro/debug/ms": ["ms@2.0.0", "", {}, "sha512-Tpp60P6IUJDTuOq/5Z8cdskzJujfwqfOTkrwIwj7IRISpnkJnT6SyJ4PCPnGMoFjC9ddhal5KVIYtAt97ix05A=="],

+    "midtrans-client/axios/follow-redirects": ["follow-redirects@1.15.9", "", {}, "sha512-gew4GsXizNgdoRyqmyfMHyAmXsZDk6mHkSxZFCzW9gwlbtOW44CDtYavM+y+72qD/Vq2l550kMF52DT8fOLJqQ=="],
+
+    "next-dev/axios/follow-redirects": ["follow-redirects@1.15.9", "", {}, "sha512-gew4GsXizNgdoRyqmyfMHyAmXsZDk6mHkSxZFCzW9gwlbtOW44CDtYavM+y+72qD/Vq2l550kMF52DT8fOLJqQ=="],
+
+    "next-dev/axios/form-data": ["form-data@4.0.2", "", { "dependencies": { "asynckit": "^0.4.0", "combined-stream": "^1.0.8", "es-set-tostringtag": "^2.1.0", "mime-types": "^2.1.12" } }, "sha512-hGfm/slu0ZabnNt4oaRZ6uREyfCj6P4fT/n6A1rGV+Z0VdGXjfOhVUpkn6qVQONHGIFwmveGXyDs75+nr6FM8w=="],
+
    "next-dev/react-dom/scheduler": ["scheduler@0.23.2", "", { "dependencies": { "loose-envify": "^1.1.0" } }, "sha512-UOShsPwz7NrMUqhR6t0hWjFduvOzbtv7toDH1/hIrfRNIDBnnBWd0CwJTGvTpngVlmwGCdP9/Zl/tVrDqcuYzQ=="],

    "next-scroll-loader/react-dom/scheduler": ["scheduler@0.23.2", "", { "dependencies": { "loose-envify": "^1.1.0" } }, "sha512-UOShsPwz7NrMUqhR6t0hWjFduvOzbtv7toDH1/hIrfRNIDBnnBWd0CwJTGvTpngVlmwGCdP9/Zl/tVrDqcuYzQ=="],
--- a/eslint.config.mjs.back.txt
+++ b/eslint.config.mjs.back.txt
@@ -1,16 +0,0 @@
-import { fileURLToPath } from "url";
-import { dirname } from "path"; // Pastikan `dirname` diimpor
-import { FlatCompat } from "@eslint/eslintrc";
-
-const __filename = fileURLToPath(import.meta.url);
-const __dirname = dirname(__filename);
-
-const compat = new FlatCompat({
-  baseDirectory: __dirname,
-});
-
-const eslintConfig = [
-  ...compat.extends("next/core-web-vitals", "next/typescript"),
-];
-
-export default eslintConfig;
--- a/next.config.js
+++ b/next.config.js
@@ -1,27 +1,21 @@
 /** @type {import('next').NextConfig} */
 const nextConfig = {
  reactStrictMode: false,
+  output: "standalone",
+  eslint: { ignoreDuringBuilds: true },
+  typescript: { ignoreBuildErrors: true },
  experimental: {
    serverActions: true,
+    serverComponentsExternalPackages: ["@prisma/client", ".prisma/client"],
  },
-  output: "standalone",
-  staticPageGenerationTimeout: 180, // tingkatkan menjadi 3 menit
-  eslint: {
-    ignoreDuringBuilds: true,
+  webpack: (config, { isServer }) => {
+    if (isServer) {
+      config.externals = config.externals || [];
+      config.externals.push("@prisma/client");
+      config.externals.push(".prisma/client");
+    }
+    return config;
  },
-  // async headers() {
-  //   return [
-  //     {
-  //       source: "/(.*)",
-  //       headers: [
-  //         {
-  //           key: "Cache-Control",
-  //           value: "no-store, max-age=0",
-  //         },
-  //       ],
-  //     },
-  //   ];
-  // },
 };

-module.exports = nextConfig;
+module.exports = nextConfig;
--- a/package.json
+++ b/package.json
@@ -1,15 +1,16 @@
 {
  "name": "hipmi",
-  "version": "1.5.39",
+  "version": "1.6.8",
  "private": true,
  "prisma": {
    "seed": "bun prisma/seed.ts"
  },
  "scripts": {
    "dev": "next dev --experimental-https",
-    "build": "next build",
-    "build:dev": "next build",
+    "build": "prisma generate && next build",
+    "build:dev": "prisma generate && next build",
    "start": "next start",
+    "postbuild": "node scripts/postbuild.js",
    "lint": "next lint",
    "ver": "bunx commit-and-tag-version -- --prerelease"
  },
@@ -50,6 +51,7 @@
    "@types/react-dom": "18.2.7",
    "@types/uuid": "^9.0.4",
    "autoprefixer": "10.4.14",
+    "axios": "^1.13.5",
    "bufferutil": "^4.0.8",
    "bun": "^1.1.38",
    "caniuse-lite": "^1.0.30001757",
--- a/prisma/schema.prisma
+++ b/prisma/schema.prisma
@@ -4,7 +4,7 @@
 generator client {
  provider      = "prisma-client-js"
  engineType    = "binary"
-  binaryTargets = ["native"]
+  binaryTargets = ["native", "debian-openssl-3.0.x", "linux-musl-openssl-3.0.x"]
 }

 datasource db {
--- a/prisma/seed.ts
+++ b/prisma/seed.ts
@@ -13,6 +13,6 @@ import { generate_seeder } from "./../src/app_modules/_global/fun/generate_seede
    console.error("<< error seeder", e);
    process.exit(1);
  })
-  .finally(async () => {
-    await prisma.$disconnect();
-  });
+  // .finally(async () => {
+  //   await prisma.$disconnect();
+  // });
--- a/scripts/postbuild.js
+++ b/scripts/postbuild.js
@@ -0,0 +1,60 @@
+const fs = require('fs');
+const path = require('path');
+
+const standaloneDir = path.join(__dirname, '../.next/standalone');
+const prismaDir = path.join(__dirname, '../node_modules/.prisma');
+
+console.log('🚀 Running postbuild script...');
+
+// Copy Prisma binaries ke standalone output
+if (fs.existsSync(prismaDir)) {
+  const dest = path.join(standaloneDir, 'node_modules/.prisma');
+  fs.mkdirSync(path.dirname(dest), { recursive: true });
+  fs.cpSync(prismaDir, dest, { recursive: true });
+  console.log('✓ Prisma binaries copied to standalone output');
+} else {
+  console.warn('⚠ Prisma binaries directory not found, skipping...');
+}
+
+// Copy schema.prisma jika diperlukan
+const schemaSrc = path.join(__dirname, '../prisma/schema.prisma');
+const schemaDest = path.join(standaloneDir, 'prisma/schema.prisma');
+if (fs.existsSync(schemaSrc)) {
+  fs.mkdirSync(path.dirname(schemaDest), { recursive: true });
+  fs.copyFileSync(schemaSrc, schemaDest);
+  console.log('✓ schema.prisma copied to standalone output');
+} else {
+  console.warn('⚠ schema.prisma not found, skipping...');
+}
+
+// Copy prisma client dari node_modules/@prisma/client
+const prismaClientSrc = path.join(__dirname, '../node_modules/@prisma/client');
+const prismaClientDest = path.join(standaloneDir, 'node_modules/@prisma/client');
+if (fs.existsSync(prismaClientSrc)) {
+  fs.mkdirSync(path.dirname(prismaClientDest), { recursive: true });
+  fs.cpSync(prismaClientSrc, prismaClientDest, { recursive: true });
+  console.log('✓ @prisma/client copied to standalone output');
+} else {
+  console.warn('⚠ @prisma/client not found, skipping...');
+}
+
+// Copy .env file jika ada (untuk production)
+const envSrc = path.join(__dirname, '../.env');
+const envDest = path.join(standaloneDir, '.env');
+if (fs.existsSync(envSrc)) {
+  fs.copyFileSync(envSrc, envDest);
+  // console.log('✓ .env file copied to standalone output');
+} else {
+  // console.warn('⚠ .env file not found, skipping...');
+  console.warn('  Pastikan DATABASE_URL di-set di system environment server!');
+}
+
+// Copy .env-local file jika ada (opsional)
+const envLocalSrc = path.join(__dirname, '../.env-local');
+const envLocalDest = path.join(standaloneDir, '.env-local');
+if (fs.existsSync(envLocalSrc)) {
+  fs.copyFileSync(envLocalSrc, envLocalDest);
+  // console.log('✓ .env-local file copied to standalone output');
+}
+
+console.log('✅ Build script completed!');
--- a/src/app/api/admin/notifikasi/count/route.tsx
+++ b/src/app/api/admin/notifikasi/count/route.tsx
@@ -1,4 +1,5 @@
 import { NextResponse } from "next/server";
+import { withRetry } from "@/lib/prisma-retry";
 import { prisma } from "@/lib";

 export const dynamic = "force-dynamic";
@@ -16,13 +17,25 @@ export async function GET(request: Request) {
    const { searchParams } = new URL(request.url);
    const userId = searchParams.get("id");

-    const data = await prisma.notifikasi.count({
-      where: {
-        adminId: userId,
-        userRoleId: "2",
-        isRead: false,
-      },
-    });
+    if (!userId) {
+      return NextResponse.json(
+        { success: false, message: "User ID is required" },
+        { status: 400 }
+      );
+    }
+
+    const data = await withRetry(
+      () =>
+        prisma.notifikasi.count({
+          where: {
+            adminId: userId,
+            userRoleId: "2",
+            isRead: false,
+          },
+        }),
+      undefined,
+      "countAdminNotifications"
+    );

    return NextResponse.json(
      {
@@ -33,7 +46,25 @@ export async function GET(request: Request) {
      { status: 200 }
    );
  } catch (error) {
+    const errorMsg = error instanceof Error ? error.message : "Unknown error";
    console.error("Error get count notifikasi", error);
+
+    // Check if it's a database connection error
+    if (
+      errorMsg.includes("Prisma") ||
+      errorMsg.includes("database") ||
+      errorMsg.includes("connection")
+    ) {
+      return NextResponse.json(
+        {
+          success: false,
+          message: "Database connection error. Please try again.",
+          data: null,
+        },
+        { status: 503 }
+      );
+    }
+
    return NextResponse.json(
      {
        success: false,
--- a/src/app/api/auth/code/[id]/route.ts
+++ b/src/app/api/auth/code/[id]/route.ts
@@ -50,7 +50,5 @@ async function DELETE(
      },
      { status: 500 }
    );
-  } finally {
-    await prisma.$disconnect();
  }
 }
--- a/src/app/api/auth/mobile-login/route.ts
+++ b/src/app/api/auth/mobile-login/route.ts
@@ -1,3 +1,4 @@
+import { withRetry } from "@/lib/prisma-retry";
 import { prisma } from "@/lib";
 import { randomOTP } from "@/app_modules/auth/fun/rondom_otp";
 import { NextResponse } from "next/server";
@@ -9,11 +10,26 @@ export async function POST(req: Request) {
    const body = await req.json();
    const { nomor } = body;

-    const user = await prisma.user.findUnique({
-      where: {
-        nomor: nomor,
-      },
-    });
+    if (!nomor) {
+      return NextResponse.json(
+        {
+          success: false,
+          message: "Nomor telepon diperlukan",
+          status: 400,
+        }
+      );
+    }
+
+    const user = await withRetry(
+      () =>
+        prisma.user.findUnique({
+          where: {
+            nomor: nomor,
+          },
+        }),
+      undefined,
+      "findUserByNomor"
+    );

    if (!user)
      return NextResponse.json({
@@ -22,12 +38,17 @@ export async function POST(req: Request) {
        status: 404,
      });

-    const createOtpId = await prisma.kodeOtp.create({
-      data: {
-        nomor: nomor,
-        otp: codeOtp,
-      },
-    });
+    const createOtpId = await withRetry(
+      () =>
+        prisma.kodeOtp.create({
+          data: {
+            nomor: nomor,
+            otp: codeOtp,
+          },
+        }),
+      undefined,
+      "createOTP"
+    );

    if (!createOtpId)
      return NextResponse.json(
@@ -59,6 +80,25 @@ export async function POST(req: Request) {
      { status: 200 },
    );
  } catch (error) {
+    const errorMsg = error instanceof Error ? error.message : "Unknown error";
+    console.error("Mobile login error:", error);
+
+    // Check if it's a database connection error
+    if (
+      errorMsg.includes("Prisma") ||
+      errorMsg.includes("database") ||
+      errorMsg.includes("connection")
+    ) {
+      return NextResponse.json(
+        {
+          success: false,
+          message: "Database connection error. Please try again.",
+          status: 503,
+        },
+        { status: 503 }
+      );
+    }
+
    return NextResponse.json(
      {
        success: false,
--- a/src/app/api/auth/register/route.ts
+++ b/src/app/api/auth/register/route.ts
@@ -14,8 +14,6 @@ export async function POST(req: Request) {
  try {
    const { data } = await req.json();

-    console.log("data >>", data);
-
    const cekUsername = await prisma.user.findUnique({
      where: {
        username: data.username,
@@ -29,12 +27,12 @@ export async function POST(req: Request) {
      });

    // ✅ Validasi wajib setuju Terms
-    if (data.termsOfServiceAccepted !== true) {
-      return NextResponse.json({
-        success: false,
-        message: "You must agree to the Terms of Service",
-      });
-    }
+    // if (data.termsOfServiceAccepted !== true) {
+    //   return NextResponse.json({
+    //     success: false,
+    //     message: "You must agree to the Terms of Service",
+    //   });
+    // }

    const createUser = await prisma.user.create({
      data: {
--- a/src/app/api/auth/resend/route.ts
+++ b/src/app/api/auth/resend/route.ts
@@ -64,7 +64,5 @@ export async function POST(req: Request) {
      },
      { status: 500 },
    );
-  } finally {
-    await prisma.$disconnect();
  }
 }
--- a/src/app/api/event/[id]/route.ts
+++ b/src/app/api/event/[id]/route.ts
@@ -42,7 +42,5 @@ export async function GET(
      { success: false, message: "Gagal mendapatkan data" },
      { status: 500 }
    );
-  } finally {
-    await prisma.$disconnect();
  }
 }
--- a/src/app/api/event/check-peserta/route.ts
+++ b/src/app/api/event/check-peserta/route.ts
@@ -30,13 +30,11 @@ export async function GET(request: Request) {
      fixData = false;
    }

-    await prisma.$disconnect();
    return NextResponse.json(
      { success: true, message: "Success get data", data: fixData },
      { status: 200 }
    );
  } catch (error) {
-    await prisma.$disconnect();
    backendLogger.error("Error get data detail event:", error);
    return NextResponse.json(
      {
--- a/src/app/api/event/sponsor/[id]/route.ts
+++ b/src/app/api/event/sponsor/[id]/route.ts
@@ -41,13 +41,11 @@ export async function POST(
      },
    });

-    await prisma.$disconnect();
    return NextResponse.json({
      success: true,
      message: "Success create sponsor",
    });
  } catch (error) {
-    await prisma.$disconnect();
    backendLogger.error("Error create sponsor event", error);
    return NextResponse.json(
      { success: false, message: "Failed create sponsor" },
@@ -100,7 +98,5 @@ export async function GET(
      },
      { status: 500 }
    );
-  } finally {
-    await prisma.$disconnect();
  }
 }
--- a/src/app/api/event/sponsor/list/[id]/route.ts
+++ b/src/app/api/event/sponsor/list/[id]/route.ts
@@ -58,7 +58,6 @@ export async function GET(
      });
    }

-    await prisma.$disconnect();
    return NextResponse.json({
      success: true,
      message: "Success create sponsor",
@@ -66,7 +65,6 @@ export async function GET(
    });
  } catch (error) {
    backendLogger.error("Error get sponsor event", error);
-    await prisma.$disconnect();
    return NextResponse.json(
      {
        success: false,
--- a/src/app/api/event/tipe-acara/route.ts
+++ b/src/app/api/event/tipe-acara/route.ts
@@ -33,7 +33,5 @@ export async function GET(request: Request) {
      },
      { status: 500 }
    );
-  } finally {
-    await prisma.$disconnect();
  }
 }
--- a/src/app/api/master/bank/route.ts
+++ b/src/app/api/master/bank/route.ts
@@ -35,7 +35,5 @@ export async function GET(request: Request) {
      },
      { status: 500 }
    );
-  } finally {
-    await prisma.$disconnect();
  }
 }
--- a/src/app/api/master/status_transaksi/route.ts
+++ b/src/app/api/master/status_transaksi/route.ts
@@ -21,13 +21,11 @@ export async function GET(request: Request) {
      },
    });

-    await prisma.$disconnect();
    return NextResponse.json(
      { success: true, message: "Berhasil mendapatkan data", data: res },
      { status: 200 }
    );
  } catch (error) {
-    await prisma.$disconnect();
    backendLogger.error("Error Get Master Status Transaksi >>", error);
    return NextResponse.json(
      {
--- a/src/app/api/mobile/admin/donation/[id]/disbursement/route.ts
+++ b/src/app/api/mobile/admin/donation/[id]/disbursement/route.ts
@@ -10,6 +10,7 @@ import {
  NotificationMobileTitleType,
 } from "../../../../../../../../types/type-mobile-notification";
 import { routeUserMobile } from "@/lib/mobile/route-page-mobile";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { POST, GET };

@@ -154,7 +155,7 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
  const { searchParams } = new URL(request.url);
  const category = searchParams.get("category");
  const page = searchParams.get("page");
-  const takeData = 10;
+  const takeData = PAGINATION_DEFAULT_TAKE;
  const skipData = Number(page) * takeData - takeData;

  console.log("[CATEGORY]", category);
@@ -174,6 +175,7 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
          id: true,
          createdAt: true,
          nominalCair: true,
+          title: true,
        },
      });
    } else if (category === "get-one") {
--- a/src/app/api/mobile/admin/donation/[id]/donatur/route.ts
+++ b/src/app/api/mobile/admin/donation/[id]/donatur/route.ts
@@ -1,6 +1,7 @@
 import _ from "lodash";
 import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET };

@@ -9,7 +10,7 @@ async function GET(req: Request, { params }: { params: { id: string } }) {
  const { searchParams } = new URL(req.url);
  const page = searchParams.get("page");
  const status = searchParams.get("status");
-  const takeData = 10;
+  const takeData = PAGINATION_DEFAULT_TAKE;
  const skipData = Number(page) * takeData - takeData;
  const fixStatus = _.startCase(status || "");

--- a/src/app/api/mobile/admin/donation/route.ts
+++ b/src/app/api/mobile/admin/donation/route.ts
@@ -1,6 +1,7 @@
 import _ from "lodash";
 import { NextResponse } from "next/server";
 import prisma from "@/lib/prisma";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET };

@@ -9,11 +10,10 @@ async function GET(request: Request) {
  const category = searchParams.get("category");
  const page = searchParams.get("page");
  const search = searchParams.get("search");
-  const takeData = 10;
+  const takeData = PAGINATION_DEFAULT_TAKE;
  const skipData = Number(page) * takeData - takeData;
-  console.log("[CATEGORY]", category);
  let fixData;
-  
+
  try {
    if (category === "dashboard") {
      const publish = await prisma.donasi.count({
@@ -48,7 +48,7 @@ async function GET(request: Request) {
          where: {
            active: true,
          },
-        }
+        },
      );

      const categoryDonation = countCategoryDonation.length;
@@ -68,7 +68,6 @@ async function GET(request: Request) {
        },
      });

-      console.log("[STATUS]", checkStatus);

      if (!checkStatus) {
        return NextResponse.json(
@@ -77,7 +76,7 @@ async function GET(request: Request) {
            message: "Failed to get data donation",
            reason: "Status not found",
          },
-          { status: 500 }
+          { status: 500 },
        );
      }

@@ -100,6 +99,12 @@ async function GET(request: Request) {
        select: {
          id: true,
          title: true,
+          target: true,
+          DonasiMaster_Durasi: {
+            select: {
+              name: true,
+            },
+          },
          Author: {
            select: {
              id: true,
@@ -109,7 +114,6 @@ async function GET(request: Request) {
        },
      });

-      console.log("[LIST]", fixData);
    }

    return NextResponse.json(
@@ -118,7 +122,7 @@ async function GET(request: Request) {
        message: `Success get data donation ${category}`,
        data: fixData,
      },
-      { status: 200 }
+      { status: 200 },
    );
  } catch (error) {
    console.error("Error get data donation:", error);
@@ -128,7 +132,7 @@ async function GET(request: Request) {
        message: "Failed to get data donation",
        reason: (error as Error).message,
      },
-      { status: 500 }
+      { status: 500 },
    );
  }
 }
--- a/src/app/api/mobile/admin/event/[id]/participants/route.ts
+++ b/src/app/api/mobile/admin/event/[id]/participants/route.ts
@@ -1,9 +1,15 @@
-import { NextResponse } from "next/server";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 import prisma from "@/lib/prisma";
+import { NextResponse } from "next/server";

 export { GET };

 async function GET(request: Request, { params }: { params: { id: string } }) {
+  const { searchParams } = new URL(request.url);
+  const page = Number(searchParams.get("page")) || 1;
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page * takeData - takeData;
+
  try {
    const { id } = params;

@@ -12,6 +18,7 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
        eventId: id,
      },
      select: {
+        id: true,
        eventId: true,
        userId: true,
        isPresent: true,
@@ -35,6 +42,8 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
          },
        },
      },
+      take: page ? takeData : undefined,
+      skip: page ? skipData : undefined,
    });

    return NextResponse.json(
--- a/src/app/api/mobile/admin/event/route.ts
+++ b/src/app/api/mobile/admin/event/route.ts
@@ -1,7 +1,8 @@
-import _ from "lodash";
 import { prisma } from "@/lib";
-import { NextResponse } from "next/server";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
+import _ from "lodash";
 import moment from "moment";
+import { NextResponse } from "next/server";

 export { GET };

@@ -11,13 +12,12 @@ async function GET(request: Request) {
  const fixStatus = _.startCase(category || "");

  const search = searchParams.get("search");
-  const page = searchParams.get("page");
-  const takeData = 10;
-  const skipData = Number(page) * takeData - takeData;
+  const page = Number(searchParams.get("page")) || 1;
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page * takeData - takeData;
  let fixData;

-  console.log("[CATEGORY]", category);
-  //   console.log("[FIX STATUS]", fixStatus);
+ 

  try {
    if (category === "dashboard") {
@@ -71,7 +71,6 @@ async function GET(request: Request) {
        typeOfEvent,
      };
    } else if (category === "history") {
-      console.log("[HISTORY HERE]");

      const data = await prisma.event.findMany({
        take: page ? takeData : undefined,
@@ -151,21 +150,22 @@ async function GET(request: Request) {
          },
        },
        select: {
-            id: true,
-            title: true,
-            tanggal: true,
-            Author: {
-              select: {
-                id: true,
-                username: true,
-                Profile: {
-                  select: {
-                    name: true,
-                  },
+          id: true,
+          title: true,
+          tanggal: true,
+          tanggalSelesai: true,
+          Author: {
+            select: {
+              id: true,
+              username: true,
+              Profile: {
+                select: {
+                  name: true,
                },
              },
            },
          },
+        },
      });

      fixData = data;
@@ -177,7 +177,7 @@ async function GET(request: Request) {
        message: `Success get data event ${category}`,
        data: fixData,
      },
-      { status: 200 }
+      { status: 200 },
    );
  } catch (error) {
    console.log(`[ERROR GET DATA EVENT: ${category}]`, error);
@@ -187,7 +187,7 @@ async function GET(request: Request) {
        message: `Error get data event ${category}`,
        reason: (error as Error).message,
      },
-      { status: 500 }
+      { status: 500 },
    );
  }
 }
--- a/src/app/api/mobile/admin/forum/[id]/comment/route.ts
+++ b/src/app/api/mobile/admin/forum/[id]/comment/route.ts
@@ -7,6 +7,7 @@ import {
  NotificationMobileTitleType,
 } from "../../../../../../../../types/type-mobile-notification";
 import { routeUserMobile } from "@/lib/mobile/route-page-mobile";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET, PUT };

@@ -14,9 +15,9 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
  const { id } = params;
  const { searchParams } = new URL(request.url);
  const search = searchParams.get("search");
-  const page = searchParams.get("page");
-  const takeData = 10;
-  const skipData = Number(page) * takeData - takeData;
+  const page = Number(searchParams.get("page"));
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page * takeData - takeData;
  const category = searchParams.get("category");
  let fixData;
  try {
--- a/src/app/api/mobile/admin/forum/[id]/report-posting/route.ts
+++ b/src/app/api/mobile/admin/forum/[id]/report-posting/route.ts
@@ -1,15 +1,16 @@
 import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export async function GET(
  request: Request,
-  { params }: { params: { id: string } }
+  { params }: { params: { id: string } },
 ) {
  const { id } = params;
  const { searchParams } = new URL(request.url);
  const search = searchParams.get("search");
  const page = searchParams.get("page");
-  const takeData = 10;
+  const takeData = PAGINATION_DEFAULT_TAKE;
  const skipData = Number(page) * takeData - takeData;
  let fixData;

@@ -60,7 +61,7 @@ export async function GET(
        message: "Success get list report posting",
        data: fixData,
      },
-      { status: 200 }
+      { status: 200 },
    );
  } catch (error) {
    console.error("[ERROR GET LIST REPORT POSTING]", error);
@@ -70,7 +71,7 @@ export async function GET(
        message: "Error get list report posting",
        reason: (error as Error).message,
      },
-      { status: 500 }
+      { status: 500 },
    );
  }
 }
--- a/src/app/api/mobile/admin/forum/route.ts
+++ b/src/app/api/mobile/admin/forum/route.ts
@@ -1,6 +1,7 @@
 import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
 import _ from "lodash";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET };

@@ -9,7 +10,7 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
  const category = searchParams.get("category");
  const search = searchParams.get("search");
  const page = searchParams.get("page");
-  const takeData = 10;
+  const takeData = PAGINATION_DEFAULT_TAKE;
  const skipData = Number(page) * takeData - takeData;

  let fixData;
@@ -79,7 +80,11 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
          _count: {
            select: {
              Forum_ReportPosting: true,
-              Forum_Komentar: true,
+              Forum_Komentar: {
+                where: {
+                  isActive: true,
+                },
+              },
            },
          },
        },
@@ -139,6 +144,14 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
        },
      });

+      // Hitung count report untuk setiap Forum_Posting id
+      const countByPostingId = data.reduce((acc: any, item: any) => {
+        const key = item.Forum_Posting?.id;
+        if (!key) return acc;
+        acc[key] = (acc[key] || 0) + 1;
+        return acc;
+      }, {});
+
      const filterLatest = (data: any) =>
        Object.values(
          data.reduce((acc: any, item: any) => {
@@ -151,10 +164,16 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
              acc[key] = item;
            }
            return acc;
-          }, {})
+          }, {}),
        );

-      fixData = filterLatest(data);
+      const filteredData = filterLatest(data);
+
+      // Tambahkan count ke setiap item
+      fixData = filteredData.map((item: any) => ({
+        ...item,
+        count: countByPostingId[item.Forum_Posting?.id] || 0,
+      }));
    } else if (category === "report_comment") {
      const data = await prisma.forum_ReportKomentar.findMany({
        take: page ? takeData : undefined,
@@ -193,6 +212,14 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
        },
      });

+      // Hitung count report untuk setiap Forum_Komentar id
+      const countByKomentarId = data.reduce((acc: any, item: any) => {
+        const key = item.Forum_Komentar?.id;
+        if (!key) return acc;
+        acc[key] = (acc[key] || 0) + 1;
+        return acc;
+      }, {});
+
      const filterLatest = (data: any) =>
        Object.values(
          data.reduce((acc: any, item: any) => {
@@ -205,10 +232,16 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
              acc[key] = item;
            }
            return acc;
-          }, {})
+          }, {}),
        );

-      fixData = filterLatest(data);
+      const filteredData = filterLatest(data);
+
+      // Tambahkan count ke setiap item
+      fixData = filteredData.map((item: any) => ({
+        ...item,
+        count: countByKomentarId[item.Forum_Komentar?.id] || 0,
+      }));
    } else {
      return NextResponse.json(
        {
@@ -216,7 +249,7 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
          message: "Invalid category",
          reason: "Invalid category",
        },
-        { status: 400 }
+        { status: 400 },
      );
    }

@@ -226,7 +259,7 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
        message: `Success get data forum ${category}`,
        data: fixData,
      },
-      { status: 200 }
+      { status: 200 },
    );
  } catch (error) {
    return NextResponse.json(
@@ -235,7 +268,7 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
        message: `Error get data forum ${category}`,
        reason: (error as Error).message,
      },
-      { status: 500 }
+      { status: 500 },
    );
  }
 }
--- a/src/app/api/mobile/admin/investment/[id]/investor/route.ts
+++ b/src/app/api/mobile/admin/investment/[id]/investor/route.ts
@@ -1,19 +1,20 @@
 import _ from "lodash";
 import { NextResponse } from "next/server";
 import prisma from "@/lib/prisma";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export async function GET(
  request: Request,
-  { params }: { params: { id: string } }
+  { params }: { params: { id: string } },
 ) {
  try {
    let fixData;
    const { id } = params;
    const { searchParams } = new URL(request.url);
-    const page = searchParams.get("page");
+    const page = Number(searchParams.get("page"));
    const status = searchParams.get("status");
-    const takeData = 10;
-    const skipData = Number(page) * takeData - takeData;
+    const takeData = PAGINATION_DEFAULT_TAKE;
+    const skipData = page * takeData - takeData;

    const fixStatus = _.startCase(status ? status : "");

@@ -43,6 +44,7 @@ export async function GET(
        id: true,
        Author: true,
        StatusInvoice: true,
+        nominal: true,
      },
    });

@@ -54,7 +56,7 @@ export async function GET(
        message: "Success get status transaksi",
        data: fixData,
      },
-      { status: 200 }
+      { status: 200 },
    );
  } catch (error) {
    console.error("Eror get status transaksi", error);
@@ -64,7 +66,7 @@ export async function GET(
        message: "Error get status transaksi",
        reason: (error as Error).message,
      },
-      { status: 500 }
+      { status: 500 },
    );
  }
 }
--- a/src/app/api/mobile/admin/investment/route.ts
+++ b/src/app/api/mobile/admin/investment/route.ts
@@ -1,6 +1,7 @@
 import _ from "lodash";
 import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET };

@@ -9,12 +10,9 @@ async function GET(request: Request) {
  const category = searchParams.get("category");
  const search = searchParams.get("search");
  const page = searchParams.get("page");
-  const takeData = 10;
+  const takeData = PAGINATION_DEFAULT_TAKE;
  const skipData = Number(page) * takeData - takeData;

-  console.log("[CATEGORY]", category);
-  console.log("[PAGE]", page);
-
  let fixData;
  try {
    if (category === "dashboard") {
@@ -49,7 +47,6 @@ async function GET(request: Request) {
      };
    } else {
      const fixCategoryToStatus = _.startCase(category || "");
-      console.log("[STATUS]", fixCategoryToStatus);

      const data = await prisma.investasi.findMany({
        take: page ? takeData : undefined,
@@ -70,6 +67,12 @@ async function GET(request: Request) {
        select: {
          id: true,
          title: true,
+          targetDana: true,
+          MasterPencarianInvestor: {
+            select: {
+              name: true,
+            },
+          },
          author: {
            select: {
              id: true,
--- a/src/app/api/mobile/admin/job/route.ts
+++ b/src/app/api/mobile/admin/job/route.ts
@@ -1,6 +1,7 @@
 import _ from "lodash";
 import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET };

@@ -8,6 +9,9 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
  const { searchParams } = new URL(request.url);
  const category = searchParams.get("category");
  const search = searchParams.get("search");
+  const page = Number(searchParams.get("page")) || 1;
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page * takeData - takeData;
  let fixData;

  try {
@@ -66,6 +70,8 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
          title: true,
          Author: true,
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
      });
    }

--- a/src/app/api/mobile/admin/master/bank/route.ts
+++ b/src/app/api/mobile/admin/master/bank/route.ts
@@ -1,14 +1,22 @@
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 import { NextResponse } from "next/server";

 export { GET, POST };

-async function GET() {
+async function GET(request: Request) {
  try {
+    const { searchParams } = new URL(request.url);
+    const page = Number(searchParams.get("page"));
+    const takeData = PAGINATION_DEFAULT_TAKE;
+    const skipData = page * takeData - takeData;
+
    const data = await prisma.masterBank.findMany({
      orderBy: {
        updatedAt: "desc",
      },
+      take: page ? takeData : undefined,
+      skip: page ? skipData : undefined,
    });

    return NextResponse.json(
--- a/src/app/api/mobile/admin/master/business-field/[id]/route.ts
+++ b/src/app/api/mobile/admin/master/business-field/[id]/route.ts
@@ -1,5 +1,6 @@
-import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
+import { NextResponse } from "next/server";

 export { GET, PUT };

@@ -11,6 +12,10 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
    const category = searchParams.get("category");
    const subBidangId = searchParams.get("subBidangId");

+    const page = Number(searchParams.get("page")) || 1;
+    const takeData = PAGINATION_DEFAULT_TAKE;
+    const skipData = page * takeData - takeData;
+
    if (category === "all") {
      const bidang = await prisma.masterBidangBisnis.findUnique({
        where: {
@@ -45,6 +50,16 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
        },
      });

+      fixData = subBidang;
+    } else if (category === "only-sub-bidang") {
+      const subBidang = await prisma.masterSubBidangBisnis.findMany({
+        where: {
+          masterBidangBisnisId: id,
+        },
+        take: takeData,
+        skip: skipData,
+      });
+
      fixData = subBidang;
    }

@@ -71,9 +86,6 @@ async function PUT(request: Request, { params }: { params: { id: string } }) {
  const { searchParams } = new URL(request.url);
  const category = searchParams.get("category");

-  console.log("category", category);
-  console.log("data", data);
-
  try {
    if (category === "bidang") {
      const updateData = await prisma.masterBidangBisnis.update({
--- a/src/app/api/mobile/admin/master/business-field/route.ts
+++ b/src/app/api/mobile/admin/master/business-field/route.ts
@@ -2,15 +2,24 @@ import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
 import _ from "lodash";
 import { Prisma } from "@prisma/client";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET, POST };

 async function GET(request: Request) {
  try {
+    const { searchParams } = new URL(request.url);
+    const page = Number(searchParams.get("page"));
+    const takeData = PAGINATION_DEFAULT_TAKE;
+    const skipData = page * takeData - takeData;
+
+
    const data = await prisma.masterBidangBisnis.findMany({
      orderBy: {
        createdAt: "asc",
      },
+      take: page ? takeData : undefined,
+      skip: page ? skipData : undefined,
    });

    return NextResponse.json({
--- a/src/app/api/mobile/admin/master/donation/route.ts
+++ b/src/app/api/mobile/admin/master/donation/route.ts
@@ -1,10 +1,14 @@
-import { NextResponse } from "next/server";
+import { NextRequest, NextResponse } from "next/server";
 import prisma from "@/lib/prisma";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET, POST };

-async function GET(request: Request) {
+async function GET(request: NextRequest) {
  const { searchParams } = new URL(request.url);
+  const page = Number(searchParams.get("page"));
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page * takeData - takeData;
  //   const category = searchParams.get("category");
  let fixData;

@@ -13,6 +17,8 @@ async function GET(request: Request) {
      orderBy: {
        createdAt: "asc",
      },
+      take: page ? takeData : undefined,
+      skip: page ? skipData : undefined,
    });

    // if (category === "category") {
--- a/src/app/api/mobile/admin/master/type-of-event/route.ts
+++ b/src/app/api/mobile/admin/master/type-of-event/route.ts
@@ -1,14 +1,22 @@
-import { NextResponse } from "next/server";
+import { NextRequest, NextResponse } from "next/server";
 import prisma from "@/lib/prisma";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET, POST };

-async function GET(request: Request) {
+async function GET(request: NextRequest) {
  try {
+    const searchParams = request.nextUrl.searchParams;
+    const page = Number(searchParams.get("page"));
+    const takeData = PAGINATION_DEFAULT_TAKE;
+    const skipData = page * takeData - takeData;
+
    const data = await prisma.eventMaster_TipeAcara.findMany({
      orderBy: {
        updatedAt: "desc",
      },
+      take: page ? takeData : undefined,
+      skip: page ? skipData : undefined,
    });

    return NextResponse.json({
--- a/src/app/api/mobile/admin/user/route.ts
+++ b/src/app/api/mobile/admin/user/route.ts
@@ -1,5 +1,6 @@
-import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
+import { NextResponse } from "next/server";

 export { GET };

@@ -7,10 +8,16 @@ async function GET(request: Request) {
  const { searchParams } = new URL(request.url);
  const search = searchParams.get("search");
  const category = searchParams.get("category");
+  const page = Number(searchParams.get("page"));
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page * takeData - takeData;
+
+  console.log("SEARCH", search);
+  console.log("PAGE", page);

  let fixData;
  try {
-    if(category === "only-user"){
+    if (category === "only-user") {
      fixData = await prisma.user.findMany({
        orderBy: {
          updatedAt: "desc",
@@ -22,8 +29,10 @@ async function GET(request: Request) {
            mode: "insensitive",
          },
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
      });
-    } else if(category === "only-admin"){
+    } else if (category === "only-admin") {
      fixData = await prisma.user.findMany({
        orderBy: {
          updatedAt: "desc",
@@ -35,8 +44,10 @@ async function GET(request: Request) {
            mode: "insensitive",
          },
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
      });
-    } else if  (category === "all-role"){
+    } else if (category === "all-role") {
      fixData = await prisma.user.findMany({
        orderBy: {
          updatedAt: "desc",
@@ -48,13 +59,15 @@ async function GET(request: Request) {
            },
            {
              masterUserRoleId: "2",
-            }
+            },
          ],
          username: {
            contains: search || "",
            mode: "insensitive",
          },
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
      });
    }

@@ -65,13 +78,11 @@ async function GET(request: Request) {
      data: fixData,
    });
  } catch (error) {
-    return NextResponse.json(
-      {
-        status: 500,
-        success: false,
-        message: "Error get data user access",
-        reason: (error as Error).message,
-      },
-    );
+    return NextResponse.json({
+      status: 500,
+      success: false,
+      message: "Error get data user access",
+      reason: (error as Error).message,
+    });
  }
 }
--- a/src/app/api/mobile/admin/voting/route.ts
+++ b/src/app/api/mobile/admin/voting/route.ts
@@ -2,6 +2,7 @@ import _ from "lodash";
 import moment from "moment";
 import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET };

@@ -12,7 +13,7 @@ async function GET(request: Request) {

  const search = searchParams.get("search");
  const page = searchParams.get("page");
-  const takeData = 10;
+  const takeData = PAGINATION_DEFAULT_TAKE;
  const skipData = Number(page) * takeData - takeData;
  let fixData;

--- a/src/app/api/mobile/auth/device-tokens/route.ts
+++ b/src/app/api/mobile/auth/device-tokens/route.ts
@@ -4,13 +4,42 @@ import { prisma } from "@/lib";
 export { POST, GET };

 async function POST(request: NextRequest) {
-  const { data } = await request.json();
  try {
+    // Parse the request body - can accept either nested under 'data' or directly
+    const requestBody = await request.json();
+    
+    // Check if the data is nested under 'data' property (as described in the issue)
+    // or if it's directly in the request body (more common pattern)
+    const payload = requestBody.data ? requestBody.data : requestBody;
+    
+    const { userId, platform, deviceId, model, appVersion, fcmToken } = payload;

-    const { userId, platform, deviceId, model, appVersion, fcmToken } = data;
-
+    // Validate required fields
    if (!fcmToken) {
-      return NextResponse.json({ error: "Missing Token" }, { status: 400 });
+      return NextResponse.json(
+        { error: "Missing FCM token", field: "fcmToken" }, 
+        { status: 400 }
+      );
+    }
+
+    if (!userId) {
+      return NextResponse.json(
+        { error: "Missing user ID", field: "userId" }, 
+        { status: 400 }
+      );
+    }
+
+    // Verify that the user exists before creating/updating the device token
+    const userExists = await prisma.user.findUnique({
+      where: { id: userId },
+      select: { id: true }
+    });
+
+    if (!userExists) {
+      return NextResponse.json(
+        { error: "User not found", field: "userId" }, 
+        { status: 404 }
+      );
    }

    const existing = await prisma.tokenUserDevice.findFirst({
@@ -23,7 +52,6 @@ async function POST(request: NextRequest) {
      },
    });

-
    console.log("✅ EX", existing);

    let deviceToken;
@@ -31,7 +59,7 @@ async function POST(request: NextRequest) {
    if (existing) {
      deviceToken = await prisma.tokenUserDevice.update({
        where: {
-          id: existing?.id,
+          id: existing.id,
        },
        data: {
          platform,
@@ -43,7 +71,7 @@ async function POST(request: NextRequest) {
        },
      });
    } else {
-      // Buat baru jika belum ada
+      // Create new device token record
      deviceToken = await prisma.tokenUserDevice.create({
        data: {
          token: fcmToken,
@@ -58,9 +86,16 @@ async function POST(request: NextRequest) {
    }

    return NextResponse.json({ success: true, data: deviceToken });
-  } catch (error) {
+  } catch (error: any) {
+    console.error("Error registering device token:", error);
+    
+    // Return more informative error response
    return NextResponse.json(
-      { error: (error as Error).message },
+      { 
+        error: "Internal server error",
+        message: error.message || "An unexpected error occurred",
+        field: "server"
+      },
      { status: 500 }
    );
  }
--- a/src/app/api/mobile/donation/[id]/[status]/route.ts
+++ b/src/app/api/mobile/donation/[id]/[status]/route.ts
@@ -1,6 +1,7 @@
 import _ from "lodash";
 import { NextResponse } from "next/server";
 import prisma from "@/lib/prisma";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET, PUT };

@@ -10,8 +11,14 @@ async function GET(
 ) {
  const { id, status } = params;
  const fixStatus = _.startCase(status);
+  const { searchParams } = new URL(request.url);
+  const page = Number(searchParams.get("page")) || 1;
+  const takeData = PAGINATION_DEFAULT_TAKE
+  const skipData = page * takeData - takeData;

  let fixData;
+  let meta = null;
+  
  try {
    const checkStatus = await prisma.donasiMaster_StatusDonasi.findFirst({
      where: {
@@ -50,18 +57,38 @@ async function GET(
      orderBy: {
        updatedAt: "desc",
      },
+      take: takeData,
+      skip: skipData,
    });

+    const totalData = await prisma.donasi.count({
+      where: {
+        authorId: id,
+        donasiMaster_StatusDonasiId: checkStatus.id,
+        active: true,
+      },
+    });
+
+    const totalPages = Math.ceil(totalData / takeData);
+
    fixData = res.map((v: any) => ({
      ..._.omit(v, ["DonasiMaster_Durasi"]),
      nameDonasiDurasi: v.DonasiMaster_Durasi.name,
    }));

+    meta = {
+      currentPage: page,
+      totalData: totalData,
+      totalPage: totalPages,
+      dataPerPage: takeData,
+    };
+
    return NextResponse.json({
      status: 200,
      success: true,
      message: "Berhasil mendapatkan data",
      data: fixData,
+      ...(meta && { meta }),
    });
  } catch (error) {
    console.log("[ERROR]", error);
--- a/src/app/api/mobile/donation/[id]/disbursement/route.ts
+++ b/src/app/api/mobile/donation/[id]/disbursement/route.ts
@@ -1,5 +1,6 @@
 import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET };

@@ -7,7 +8,7 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
  const { id } = params;
  const { searchParams } = new URL(request.url);
  const page = Number(searchParams.get("page"));
-  const takeData = 5;
+  const takeData = PAGINATION_DEFAULT_TAKE;
  const skipData = page * takeData - takeData;

  try {
--- a/src/app/api/mobile/donation/[id]/donatur/route.ts
+++ b/src/app/api/mobile/donation/[id]/donatur/route.ts
@@ -1,3 +1,4 @@
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 import prisma from "@/lib/prisma";
 import { NextResponse } from "next/server";

@@ -9,11 +10,12 @@ export async function GET(
    let fixData;
    const { id } = params;
    const { searchParams } = new URL(request.url);
-    const page = Number(searchParams.get("page"));
-    const takeData = 10;
+    const page = Number(searchParams.get("page")) || 1; // Default page 1 jika tidak ada atau invalid
+    const takeData = PAGINATION_DEFAULT_TAKE;
    const skipData = page * takeData - takeData;

-    fixData = await prisma.donasi_Invoice.findMany({
+    // Query data dengan pagination
+    const data = await prisma.donasi_Invoice.findMany({
      take: page ? takeData : undefined,
      skip: page ? skipData : undefined,
      orderBy: {
@@ -59,10 +61,31 @@ export async function GET(
      },
    });

+    // Hitung total data untuk pagination
+    const totalCount = await prisma.donasi_Invoice.count({
+      where: {
+        donasiId: id,
+        DonasiMaster_StatusInvoice: {
+          name: "Berhasil",
+        },
+      },
+    });
+
+    // Hitung total halaman
+    const totalPages = Math.ceil(totalCount / takeData);
+
+    fixData = data;
+
    return NextResponse.json({
      success: true,
      message: "Data berhasil diambil",
      data: fixData,
+      pagination: {
+        currentPage: page,
+        totalPages: totalPages,
+        totalData: totalCount,
+        dataPerPage: takeData,
+      },
    });
  } catch (error) {
    return NextResponse.json({
--- a/src/app/api/mobile/donation/[id]/news/route.ts
+++ b/src/app/api/mobile/donation/[id]/news/route.ts
@@ -8,6 +8,7 @@ import {
 } from "../../../../../../../types/type-mobile-notification";
 import { routeUserMobile } from "@/lib/mobile/route-page-mobile";
 import { funFindDonaturList } from "@/lib/mobile/donation/find-donatur-list";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { POST, GET, PUT, DELETE };

@@ -94,11 +95,16 @@ async function GET(
  const { id } = params;
  const { searchParams } = new URL(request.url);
  const category = searchParams.get("category");
+  const page = Number(searchParams.get("page")) || 1; // Default page 1 jika tidak ada
+  const takeData = PAGINATION_DEFAULT_TAKE; // Default 10 data per halaman
+  const skipData = page * takeData - takeData;
+  
  let fixData;
+  let totalCount = 0; // Untuk menghitung total data

  try {
    if (category === "get-all") {
-      fixData = await prisma.donasi_Kabar.findMany({
+      const data = await prisma.donasi_Kabar.findMany({
        orderBy: {
          updatedAt: "desc",
        },
@@ -106,6 +112,8 @@ async function GET(
          donasiId: id,
          active: true,
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
        select: {
          id: true,
          title: true,
@@ -113,6 +121,17 @@ async function GET(
          createdAt: true,
        },
      });
+
+      // Hitung total data untuk pagination
+      totalCount = await prisma.donasi_Kabar.count({
+        where: {
+          donasiId: id,
+          active: true,
+        },
+      });
+
+      fixData = data;
+
    } else if (category === "get-one") {
      const data = await prisma.donasi_Kabar.findUnique({
        where: {
@@ -135,11 +154,24 @@ async function GET(
      };
    }

+    // Hitung total halaman jika kategori adalah get-all
+    let pagination = undefined;
+    if (category === "get-all") {
+      const totalPages = Math.ceil(totalCount / takeData);
+      pagination = {
+        currentPage: page,
+        totalPages: totalPages,
+        totalData: totalCount,
+        dataPerPage: takeData,
+      };
+    }
+
    return NextResponse.json({
      status: 200,
      success: true,
      message: "Berhasil mengambil kabar",
      data: fixData,
+      pagination: pagination,
    });
  } catch (error) {
    console.error("[ERROR GET NEWS]", error);
--- a/src/app/api/mobile/donation/route.ts
+++ b/src/app/api/mobile/donation/route.ts
@@ -4,6 +4,7 @@ import _ from "lodash";
 import { NextResponse } from "next/server";
 import { NotificationMobileBodyType } from "../../../../../types/type-mobile-notification";
 import { routeAdminMobile } from "@/lib/mobile/route-page-mobile";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { POST, GET };

@@ -125,7 +126,12 @@ async function GET(request: Request) {
  const { searchParams } = new URL(request.url);
  const category = searchParams.get("category");
  const authorId = searchParams.get("authorId");
+  const page = Number(searchParams.get("page")) || 1; // Default page 1 jika tidak ada
+  const takeData = PAGINATION_DEFAULT_TAKE; // Default 10 data per halaman
+  const skipData = page * takeData - takeData;
+  
  let fixData;
+  let totalCount = 0; // Untuk menghitung total data

  try {
    if (category === "beranda") {
@@ -137,6 +143,8 @@ async function GET(request: Request) {
          donasiMaster_StatusDonasiId: "1",
          active: true,
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
        select: {
          id: true,
          imageId: true,
@@ -152,6 +160,14 @@ async function GET(request: Request) {
        },
      });

+      // Hitung total data untuk pagination
+      totalCount = await prisma.donasi.count({
+        where: {
+          donasiMaster_StatusDonasiId: "1",
+          active: true,
+        },
+      });
+
      fixData = data.map((v: any) => ({
        ..._.omit(v, ["DonasiMaster_Durasi"]),
        durasiDonasi: v.DonasiMaster_Durasi.name,
@@ -164,6 +180,8 @@ async function GET(request: Request) {
        where: {
          authorId: authorId,
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
        select: {
          id: true,
          nominal: true,
@@ -190,6 +208,13 @@ async function GET(request: Request) {
        },
      });

+      // Hitung total data untuk pagination
+      totalCount = await prisma.donasi_Invoice.count({
+        where: {
+          authorId: authorId,
+        },
+      });
+
      fixData = data.map((v: any) => ({
        ..._.omit(v, ["DonasiMaster_StatusInvoice", "Donasi"]),
        statusInvoice: v.DonasiMaster_StatusInvoice.name,
@@ -202,8 +227,21 @@ async function GET(request: Request) {
      }));
    }

+    // Hitung total halaman
+    const totalPages = Math.ceil(totalCount / takeData);
+
    return NextResponse.json(
-      { success: true, message: "Data berhasil diambil", data: fixData },
+      { 
+        success: true, 
+        message: "Data berhasil diambil", 
+        data: fixData,
+        pagination: {
+          currentPage: page,
+          totalPages: totalPages,
+          totalData: totalCount,
+          dataPerPage: takeData,
+        }
+      },
      { status: 200 }
    );
  } catch (error) {
--- a/src/app/api/mobile/event/[id]/[status]/route.ts
+++ b/src/app/api/mobile/event/[id]/[status]/route.ts
@@ -1,6 +1,7 @@
 import { NextResponse } from "next/server";
 import prisma from "@/lib/prisma";
 import _ from "lodash";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET, PUT };

@@ -14,7 +15,7 @@ async function GET(

    const { searchParams } = new URL(request.url);
    const page = Number(searchParams.get("page")) || 1;
-    const takeData = 10;
+    const takeData = PAGINATION_DEFAULT_TAKE
    const skipData = page * takeData - takeData;

    const data = await prisma.event.findMany({
--- a/src/app/api/mobile/event/[id]/participants/route.ts
+++ b/src/app/api/mobile/event/[id]/participants/route.ts
@@ -6,6 +6,7 @@ import {
  NotificationMobileTitleType,
 } from "../../../../../../../types/type-mobile-notification";
 import { routeUserMobile } from "@/lib/mobile/route-page-mobile";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET, POST };

@@ -47,7 +48,7 @@ async function POST(request: Request, { params }: { params: { id: string } }) {
        message: "Success join event",
        data: createJoin,
      },
-      { status: 200 }
+      { status: 200 },
    );
  } catch (error) {
    return NextResponse.json(
@@ -56,7 +57,7 @@ async function POST(request: Request, { params }: { params: { id: string } }) {
        message: "Error join event",
        reason: (error as Error).message,
      },
-      { status: 500 }
+      { status: 500 },
    );
  }
 }
@@ -64,12 +65,17 @@ async function POST(request: Request, { params }: { params: { id: string } }) {
 async function GET(request: Request, { params }: { params: { id: string } }) {
  try {
    const { id } = params;
+    const { searchParams } = new URL(request.url);
+    const page = Number(searchParams.get("page")) || 1;
+    const takeData = PAGINATION_DEFAULT_TAKE
+    const skipData = page * takeData - takeData;

    const data = await prisma.event_Peserta.findMany({
      where: {
        eventId: id,
      },
      select: {
+        id: true,
        eventId: true,
        userId: true,
        isPresent: true,
@@ -87,6 +93,8 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
          },
        },
      },
+      take: takeData,
+      skip: skipData,
    });

    return NextResponse.json(
@@ -94,8 +102,14 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
        success: true,
        message: "Success get participants",
        data: data,
+        meta: {
+          page,
+          take: takeData,
+          total: await prisma.event_Peserta.count({ where: { eventId: id } }),
+          totalPages: Math.ceil(await prisma.event_Peserta.count({ where: { eventId: id } }) / takeData),
+        },
      },
-      { status: 200 }
+      { status: 200 },
    );
  } catch (error) {
    return NextResponse.json(
@@ -104,7 +118,7 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
        message: "Error get participants",
        reason: (error as Error).message,
      },
-      { status: 500 }
+      { status: 500 },
    );
  }
 }
--- a/src/app/api/mobile/event/route.ts
+++ b/src/app/api/mobile/event/route.ts
@@ -5,6 +5,7 @@ import _ from "lodash";
 import moment from "moment";
 import { NextResponse } from "next/server";
 import { NotificationMobileBodyType } from "../../../../../types/type-mobile-notification";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET, POST };

@@ -77,7 +78,7 @@ async function GET(request: Request) {
    const category = searchParams.get("category");
    const userId = searchParams.get("userId");
    const page = Number(searchParams.get("page")) || 1;
-    const takeData = 5;
+    const takeData = PAGINATION_DEFAULT_TAKE;
    const skipData = page * takeData - takeData;

    console.log("[CAT]", category);
@@ -165,6 +166,7 @@ async function GET(request: Request) {
            userId: userId,
          },
          select: {
+            id: true,
            eventId: true,
            userId: true,
            Event: {
--- a/src/app/api/mobile/forum/[id]/preview-report-comment/route.ts
+++ b/src/app/api/mobile/forum/[id]/preview-report-comment/route.ts
@@ -1,4 +1,5 @@
 import { NextResponse } from "next/server";
+import prisma from "@/lib/prisma"

 export async function GET(
  request: Request,
--- a/src/app/api/mobile/investment/[id]/[status]/route.ts
+++ b/src/app/api/mobile/investment/[id]/[status]/route.ts
@@ -1,6 +1,7 @@
 import _ from "lodash";
 import { NextResponse } from "next/server";
 import prisma from "@/lib/prisma";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET, PUT };

@@ -9,6 +10,10 @@ async function GET(
  { params }: { params: { id: string; status: string } }
 ) {
  const { id, status } = params;
+  const { searchParams } = new URL(request.url);
+  const page = Number(searchParams.get("page"));
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page ? page * takeData - takeData : 0;
  const fixStatusName = _.startCase(status);

  try {
@@ -22,6 +27,8 @@ async function GET(
          name: fixStatusName,
        },
      },
+      take: page ? takeData : undefined,
+      skip: page ? skipData : undefined,
      select: {
        id: true,
        title: true,
--- a/src/app/api/mobile/investment/[id]/document/route.ts
+++ b/src/app/api/mobile/investment/[id]/document/route.ts
@@ -6,6 +6,7 @@ import {
  NotificationMobileTitleType,
 } from "../../../../../../../types/type-mobile-notification";
 import { routeAdminMobile, routeUserMobile } from "@/lib/mobile/route-page-mobile";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { POST, GET, DELETE };

@@ -98,6 +99,9 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
  const { id } = params;
  const { searchParams } = new URL(request.url);
  const category = searchParams.get("category");
+  const page = Number(searchParams.get("page"));
+  const takeData = PAGINATION_DEFAULT_TAKE
+  const skipData =  page * takeData - takeData

  try {
    let fixData;
@@ -117,6 +121,8 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
          investasiId: id,
          active: true,
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
      });
    }

--- a/src/app/api/mobile/investment/[id]/investor/route.ts
+++ b/src/app/api/mobile/investment/[id]/investor/route.ts
@@ -1,10 +1,16 @@
 import { NextResponse } from "next/server";
 import prisma from "@/lib/prisma";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET };

 async function GET(request: Request, { params }: { params: { id: string } }) {
  const { id } = params;
+  
+  const { searchParams } = new URL(request.url);
+  const page = Number(searchParams.get("page")) || 1;
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page * takeData - takeData;

  try {
    const data = await prisma.investasi_Invoice.findMany({
@@ -29,13 +35,30 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
          },
        },
      },
+      take: takeData,
+      skip: skipData,
    });

+    const totalData = await prisma.investasi_Invoice.count({
+      where: {
+        investasiId: id,
+        statusInvoiceId: "1",
+      },
+    });
+
+    const totalPages = Math.ceil(totalData / takeData);
+
    return NextResponse.json({
      status: 200,
      success: true,
      message: "Berhasil Mendapatkan Data",
      data: data,
+      meta: {
+        currentPage: page,
+        totalData: totalData,
+        totalPage: totalPages,
+        dataPerPage: takeData,
+      },
    });
  } catch (error) {
    return NextResponse.json({
--- a/src/app/api/mobile/investment/[id]/invoice/route.ts
+++ b/src/app/api/mobile/investment/[id]/invoice/route.ts
@@ -7,6 +7,7 @@ import {
  NotificationMobileTitleType,
  NotificationMobileBodyType,
 } from "../../../../../../../types/type-mobile-notification";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { POST, GET, PUT };

@@ -53,6 +54,9 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
  const { searchParams } = new URL(request.url);
  const category = searchParams.get("category");
  const authorId = searchParams.get("authorId");
+  const page = Number(searchParams.get("page"));
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page ? page * takeData - takeData : 0;

  console.log("[ID INVOICE]", id);

@@ -103,6 +107,8 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
          statusInvoiceId: "1",
          isActive: true,
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
        select: {
          id: true,
          nominal: true,
@@ -129,6 +135,8 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
        where: {
          authorId: authorId,
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
        select: {
          id: true,
          statusInvoiceId: true,
--- a/src/app/api/mobile/investment/[id]/news/route.ts
+++ b/src/app/api/mobile/investment/[id]/news/route.ts
@@ -2,6 +2,7 @@ import _ from "lodash";
 import { prisma } from "@/lib";
 import { NextResponse } from "next/server";
 import { sendNotificationInvestmentAddNews } from "@/lib/mobile/notification/notification-add-news-investment";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { POST, GET, DELETE };

@@ -88,8 +89,13 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
  console.log("id", id);
  const { searchParams } = new URL(request.url);
  const category = searchParams.get("category");
+  const page = Number(searchParams.get("page")) || 1;
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page * takeData - takeData;

  let fixData;
+  let meta = null;
+  
  try {
    if (category === "one-news") {
      const data = await prisma.beritaInvestasi.findFirst({
@@ -113,7 +119,7 @@ async function GET(request: Request, { params }: { params: { id: string } }) {

      fixData = newData;
    } else if (category === "all-news") {
-      fixData = await prisma.beritaInvestasi.findMany({
+      const newsData = await prisma.beritaInvestasi.findMany({
        orderBy: {
          updatedAt: "desc",
        },
@@ -121,7 +127,27 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
          investasiId: id,
          active: true,
        },
+        take: takeData,
+        skip: skipData,
      });
+
+      const totalData = await prisma.beritaInvestasi.count({
+        where: {
+          investasiId: id,
+          active: true,
+        },
+      });
+
+      const totalPages = Math.ceil(totalData / takeData);
+
+      fixData = newsData;
+      
+      meta = {
+        currentPage: page,
+        totalData: totalData,
+        totalPage: totalPages,
+        dataPerPage: takeData,
+      };
    }

    return NextResponse.json({
@@ -129,6 +155,7 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
      success: true,
      message: "Berita berhasil diambil",
      data: fixData,
+      ...(meta && { meta }),
    });
  } catch (error) {
    console.log("[ERROR]", error);
--- a/src/app/api/mobile/investment/route.ts
+++ b/src/app/api/mobile/investment/route.ts
@@ -5,6 +5,7 @@ import moment from "moment";
 import { sendNotificationMobileToManyUser } from "@/lib/mobile/notification/send-notification";
 import { NotificationMobileBodyType } from "../../../../../types/type-mobile-notification";
 import { routeAdminMobile } from "@/lib/mobile/route-page-mobile";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { POST, GET };

@@ -73,6 +74,9 @@ async function GET(request: Request) {
  const { searchParams } = new URL(request.url);
  const category = searchParams.get("category");
  const authorId = searchParams.get("authorId");
+  const page = Number(searchParams.get("page"));
+  const takeData = PAGINATION_DEFAULT_TAKE
+  const skipData = page ? page * takeData - takeData : 0;

  console.log("[CATEGORY]", category);
  console.log("[AUTHOR ID]", authorId);
@@ -132,6 +136,8 @@ async function GET(request: Request) {
        where: {
          masterStatusInvestasiId: "1",
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
        select: {
          id: true,
          imageId: true,
@@ -156,6 +162,8 @@ async function GET(request: Request) {
          authorId: authorId,
          statusInvoiceId: "1",
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
        select: {
          id: true,
          investasiId: true,
--- a/src/app/api/mobile/master/bank/route.ts
+++ b/src/app/api/mobile/master/bank/route.ts
@@ -28,7 +28,5 @@ async function GET() {
      },
      { status: 500 }
    );
-  } finally {
-    await prisma.$disconnect();
  }
 }
--- a/src/app/api/mobile/notification/[id]/route.ts
+++ b/src/app/api/mobile/notification/[id]/route.ts
@@ -1,3 +1,4 @@
+import { withRetry } from "@/lib/prisma-retry";
 import { prisma } from "@/lib";
 import _ from "lodash";
 import { NextRequest, NextResponse } from "next/server";
@@ -22,28 +23,38 @@ export async function GET(
  let fixData;

  try {
-    const data = await prisma.notifikasi.findMany({
-      take: page ? takeData : undefined,
-      skip: page ? skipData : undefined,
-      orderBy: {
-        createdAt: "desc",
-      },
-      where: {
-        recipientId: id,
-        kategoriApp: fixCategory,
-      },
-    });
+    const data = await withRetry(
+      () =>
+        prisma.notifikasi.findMany({
+          take: page ? takeData : undefined,
+          skip: page ? skipData : undefined,
+          orderBy: {
+            createdAt: "desc",
+          },
+          where: {
+            recipientId: id,
+            kategoriApp: fixCategory,
+          },
+        }),
+      undefined,
+      "getNotifications"
+    );

    // Jika pagination digunakan, ambil juga total count untuk informasi
    let totalCount;
    let totalPages;
    if (page) {
-      totalCount = await prisma.notifikasi.count({
-        where: {
-          recipientId: id,
-          kategoriApp: fixCategory,
-        },
-      });
+      totalCount = await withRetry(
+        () =>
+          prisma.notifikasi.count({
+            where: {
+              recipientId: id,
+              kategoriApp: fixCategory,
+            },
+          }),
+        undefined,
+        "countNotifications"
+      );
      totalPages = Math.ceil(totalCount / takeData);
    }

@@ -69,8 +80,23 @@ export async function GET(

    return NextResponse.json(response);
  } catch (error) {
+    const errorMsg = error instanceof Error ? error.message : "Unknown error";
+    console.error("Error getting notifications:", error);
+
+    // Check if it's a database connection error
+    if (
+      errorMsg.includes("Prisma") ||
+      errorMsg.includes("database") ||
+      errorMsg.includes("connection")
+    ) {
+      return NextResponse.json(
+        { error: "Database connection error. Please try again." },
+        { status: 503 }
+      );
+    }
+
    return NextResponse.json(
-      { error: (error as Error).message },
+      { error: errorMsg },
      { status: 500 },
    );
  }
--- a/src/app/api/mobile/notification/[id]/unread-count/route.ts
+++ b/src/app/api/mobile/notification/[id]/unread-count/route.ts
@@ -1,3 +1,4 @@
+import { withRetry } from "@/lib/prisma-retry";
 import { prisma } from "@/lib";
 import { NextRequest, NextResponse } from "next/server";

@@ -9,12 +10,24 @@ export async function GET(
  console.log("User ID:", id);

  try {
-    const data = await prisma.notifikasi.count({
-      where: {
-        recipientId: id,
-        isRead: false,
-      },
-    });
+    if (!id) {
+      return NextResponse.json({
+        success: false,
+        message: "User ID is required",
+      });
+    }
+
+    const data = await withRetry(
+      () =>
+        prisma.notifikasi.count({
+          where: {
+            recipientId: id,
+            isRead: false,
+          },
+        }),
+      undefined,
+      "countUnreadNotifications"
+    );

    console.log("List Notification >>", data);

@@ -23,6 +36,21 @@ export async function GET(
      data: data,
    });
  } catch (error) {
+    const errorMsg = error instanceof Error ? error.message : "Unknown error";
+    console.error("Error getting unread count:", error);
+
+    // Check if it's a database connection error
+    if (
+      errorMsg.includes("Prisma") ||
+      errorMsg.includes("database") ||
+      errorMsg.includes("connection")
+    ) {
+      return NextResponse.json({
+        success: false,
+        message: "Database connection error. Please try again.",
+      });
+    }
+
    return NextResponse.json({
      success: false,
      message: "Failed to get unread count",
--- a/src/app/api/mobile/profile/[id]/route.ts
+++ b/src/app/api/mobile/profile/[id]/route.ts
@@ -131,7 +131,5 @@ async function PUT(request: Request, { params }: { params: { id: string } }) {
      },
      { status: 500 }
    );
-  } finally {
-    await prisma.$disconnect();
  }
 }
--- a/src/app/api/mobile/route.ts
+++ b/src/app/api/mobile/route.ts
@@ -40,7 +40,5 @@ export async function GET(request: Request) {
        status: 500,
      }
    );
-  } finally {
-    await prisma.$disconnect();
  }
 }
--- a/src/app/api/mobile/user/route.ts
+++ b/src/app/api/mobile/user/route.ts
@@ -27,18 +27,18 @@ export async function GET(request: Request) {
        NOT: {
          Profile: null,
        },
-        OR: [
-          {
-            MasterUserRole: {
-              name: "User",
-            },
-          },
-          {
-            MasterUserRole: {
-              name: "Admin",
-            },
-          },
-        ],
+        // OR: [
+        //   {
+        //     MasterUserRole: {
+        //       name: "User",
+        //     },
+        //   },
+        //   {
+        //     MasterUserRole: {
+        //       name: "Admin",
+        //     },
+        //   },
+        // ],
      },
      include: {
        Profile: {
--- a/src/app/api/mobile/voting/[id]/[status]/route.ts
+++ b/src/app/api/mobile/voting/[id]/[status]/route.ts
@@ -1,6 +1,7 @@
 import _ from "lodash";
 import { NextResponse } from "next/server";
 import prisma from "@/lib/prisma";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET, PUT };

@@ -10,14 +11,33 @@ async function GET(
 ) {
  try {
    const { id, status } = params;
-    console.log("[ID]", id);
    const fixStatusName = _.startCase(status);
-    console.log("[STATUS]", fixStatusName);

-    let fixData;
+    const { searchParams } = new URL(request.url);
+    const page = Number(searchParams.get("page")) || 1;
+    const takeData = PAGINATION_DEFAULT_TAKE
+    const skipData = page * takeData - takeData;
+
+    let data;
+    let totalCount;

    if (fixStatusName === "Publish") {
-      fixData = await prisma.voting.findMany({
+      data = await prisma.voting.findMany({
+        where: {
+          authorId: id,
+          isActive: true,
+          akhirVote: {
+            gte: new Date(),
+          },
+          Voting_Status: {
+            name: fixStatusName,
+          },
+        },
+        take: takeData,
+        skip: skipData,
+      });
+
+      totalCount = await prisma.voting.count({
        where: {
          authorId: id,
          isActive: true,
@@ -30,7 +50,18 @@ async function GET(
        },
      });
    } else {
-      fixData = await prisma.voting.findMany({
+      data = await prisma.voting.findMany({
+        where: {
+          authorId: id,
+          Voting_Status: {
+            name: fixStatusName,
+          },
+        },
+        take: takeData,
+        skip: skipData,
+      });
+
+      totalCount = await prisma.voting.count({
        where: {
          authorId: id,
          Voting_Status: {
@@ -40,10 +71,18 @@ async function GET(
      });
    }

+    const totalPages = Math.ceil(totalCount / takeData);
+
    return NextResponse.json({
      success: true,
      message: "Success get voting",
-      data: fixData,
+      data: data,
+      pagination: {
+        currentPage: page,
+        totalPages: totalPages,
+        totalData: totalCount,
+        dataPerPage: takeData,
+      },
    });
  } catch (error) {
    console.log("[ERROR]", error);
@@ -61,9 +100,7 @@ async function PUT(
 ) {
  try {
    const { id, status } = params;
-    console.log("[ID]", id);
    const fixStatusName = _.startCase(status);
-    console.log("[STATUS]", fixStatusName);

    const checkData = await prisma.voting.findFirst({
      where: {
@@ -79,8 +116,6 @@ async function PUT(
      },
    });

-    console.log("[CHECKDATA]", checkData);
-
    if (!checkData)
      return NextResponse.json({
        success: false,
@@ -115,8 +150,6 @@ async function PUT(
      },
    });

-    console.log("[UPDATE]", updateData);
-
    return NextResponse.json({
      success: true,
      message: "Success update voting",
--- a/src/app/api/mobile/voting/[id]/contribution/route.ts
+++ b/src/app/api/mobile/voting/[id]/contribution/route.ts
@@ -1,5 +1,6 @@
 import { NextResponse } from "next/server";
 import prisma from "@/lib/prisma";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { GET };

@@ -8,10 +9,9 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
  const { searchParams } = new URL(request.url);
  const authorId = searchParams.get("authorId");
  const category = searchParams.get("category");
-
-  console.log("[ID]", id);
-  console.log("[AUTHOR ID]", authorId);
-  console.log("[CATEGORY]", category);
+  const page = Number(searchParams.get("page"));
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page ? page * takeData - takeData : 0;

  let fixData;

@@ -53,7 +53,10 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
        where: {
          votingId: id,
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
        select: {
+          id: true,
          Voting_DaftarNamaVote: {
            select: {
              value: true,
@@ -75,8 +78,6 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
        },
      });

-      console.log("[LIST KONTRIBUTOR]", listKontributor);
-
      fixData = listKontributor;
    }

--- a/src/app/api/mobile/voting/route.ts
+++ b/src/app/api/mobile/voting/route.ts
@@ -4,6 +4,7 @@ import _ from "lodash";
 import { sendNotificationMobileToManyUser } from "@/lib/mobile/notification/send-notification";
 import { NotificationMobileBodyType } from "../../../../../types/type-mobile-notification";
 import { routeAdminMobile } from "@/lib/mobile/route-page-mobile";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";

 export { POST, GET };

@@ -87,8 +88,9 @@ async function GET(request: Request) {
  const category = searchParams.get("category");
  const authorId = searchParams.get("authorId");
  const userLoginId = searchParams.get("userLoginId");
-
-  console.log("userLoginId >>", userLoginId);
+  const page = Number(searchParams.get("page"));
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page * takeData - takeData;

  let fixData;

@@ -123,6 +125,8 @@ async function GET(request: Request) {
            },
          },
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
        include: {
          Voting_DaftarNamaVote: {
            orderBy: {
@@ -154,6 +158,8 @@ async function GET(request: Request) {
        where: {
          authorId: authorId,
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
        include: {
          Voting: {
            select: {
@@ -211,6 +217,8 @@ async function GET(request: Request) {
            mode: "insensitive",
          },
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
        include: {
          Voting_DaftarNamaVote: {
            orderBy: {
@@ -249,6 +257,8 @@ async function GET(request: Request) {
            mode: "insensitive",
          },
        },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
        include: {
          Voting_DaftarNamaVote: {
            orderBy: {
--- a/src/app/api/new/home/route.ts
+++ b/src/app/api/new/home/route.ts
@@ -78,7 +78,5 @@ export async function GET(request: Request) {
      },
      { status: 500 }
    );
-  } finally {
-    await prisma.$disconnect();
  }
 }
--- a/src/app/api/new/investasi/berita/[id]/route.ts
+++ b/src/app/api/new/investasi/berita/[id]/route.ts
@@ -49,14 +49,11 @@ export async function GET(
      });
    }

-    await prisma.$disconnect();
-
    return NextResponse.json(
      { success: true, message: "Success get data news", data: fixData },
      { status: 200 }
    );
  } catch (error) {
-    await prisma.$disconnect();
    backendLogger.error("Error get data news", error);
    return NextResponse.json(
      {
--- a/src/app/api/new/investasi/dokumen/[id]/route.ts
+++ b/src/app/api/new/investasi/dokumen/[id]/route.ts
@@ -36,8 +36,6 @@ export async function GET(
        });
      }

-      await prisma.$disconnect();
-
      return NextResponse.json(
        { success: true, message: "Success get data document", data: fixData },
        { status: 200 }
--- a/src/app/api/profile/[id]/route.ts
+++ b/src/app/api/profile/[id]/route.ts
@@ -104,7 +104,5 @@ async function PUT(request: Request) {
      },
      { status: 500 }
    );
-  } finally {
-    await prisma.$disconnect();
  }
 }
--- a/src/app/api/profile/route.ts
+++ b/src/app/api/profile/route.ts
@@ -77,7 +77,5 @@ async function POST(request: Request) {
      },
      { status: 500 }
    );
-  } finally {
-    await prisma.$disconnect();
  }
 }
--- a/src/app/api/user-validate/route.ts
+++ b/src/app/api/user-validate/route.ts
@@ -1,4 +1,5 @@
 import { decrypt } from "@/app/(auth)/_lib/decrypt";
+import { withRetry } from "@/lib/prisma-retry";
 import { prisma } from "@/lib";
 import { cookies } from "next/headers";
 import { NextResponse } from "next/server";
@@ -43,11 +44,16 @@ export async function GET(req: Request) {
      );
    }

-    const user = await prisma.user.findUnique({
-      where: {
-        id: decrypted.id,
-      },
-    });
+    const user = await withRetry(
+      () =>
+        prisma.user.findUnique({
+          where: {
+            id: decrypted.id,
+          },
+        }),
+      undefined,
+      "validateUser"
+    );

    if (!user) {
      return NextResponse.json(
@@ -76,15 +82,46 @@ export async function GET(req: Request) {
      data: user,
    });
  } catch (error) {
-    console.error("Error in user validation:", error);
+    const errorMsg = error instanceof Error ? error.message : "Unknown error";
+    const errorStack = error instanceof Error ? error.stack : "No stack";
+
+    // Log detailed error for debugging
+    console.error("❌ [USER-VALIDATE] Error:", errorMsg);
+    console.error("❌ [USER-VALIDATE] Stack:", errorStack);
+    console.error("❌ [USER-VALIDATE] Time:", new Date().toISOString());
+
+    // Check if it's a database connection error
+    if (
+      errorMsg.includes("Prisma") ||
+      errorMsg.includes("database") ||
+      errorMsg.includes("connection")
+    ) {
+      console.error(
+        "❌ [USER-VALIDATE] Database connection error detected!"
+      );
+      console.error(
+        "❌ [USER-VALIDATE] DATABASE_URL exists:",
+        !!process.env.DATABASE_URL
+      );
+
+      return NextResponse.json(
+        {
+          success: false,
+          message: "Database connection error. Please try again.",
+          error: process.env.NODE_ENV === "development" ? errorMsg : "Internal server error",
+        },
+        { status: 503 }
+      );
+    }
+
    return NextResponse.json(
      {
        success: false,
        message: "Terjadi kesalahan pada server",
+        error:
+          process.env.NODE_ENV === "development" ? errorMsg : "Internal server error",
      },
      { status: 500 }
    );
-  } finally {
-    await prisma.$disconnect();
  }
 }
--- a/src/app/api/user/route.ts
+++ b/src/app/api/user/route.ts
@@ -125,7 +125,5 @@ export async function GET(request: Request) {
        status: 500,
      }
    );
-  } finally {
-    await prisma.$disconnect();
  }
 }
--- a/src/app_modules/_global/component/new/comp_V3_text_editor_stiker.tsx
+++ b/src/app_modules/_global/component/new/comp_V3_text_editor_stiker.tsx
@@ -28,6 +28,7 @@ import { useRouter } from "next/navigation";
 import { IconMoodSmileFilled } from "@tabler/icons-react";
 import { listStiker } from "../../lib/stiker";
 import { UIGlobal_Modal } from "../../ui";
+import mqtt_client from "@/util/mqtt_client";

 const ReactQuill = dynamic(
  async () => {
@@ -248,10 +249,12 @@ function ButtonAction({ value, lengthData }: ButtonActionProps) {
        ComponentGlobal_NotifikasiBerhasil(create.message);
        router.back();

-        mqtt_client.publish(
-          "Forum_create_new",
-          JSON.stringify({ isNewPost: true, count: 1 })
-        );
+        if (typeof window !== 'undefined' && mqtt_client) {
+          mqtt_client.publish(
+            "Forum_create_new",
+            JSON.stringify({ isNewPost: true, count: 1 })
+          );
+        }
      } else {
        ComponentGlobal_NotifikasiGagal(create.message);
      }
--- a/src/app_modules/_global/fun/generate_seeder.ts
+++ b/src/app_modules/_global/fun/generate_seeder.ts
@@ -669,10 +669,8 @@ const limit = pLimit(1);
 export async function generate_seeder() {
  try {
    await Promise.all(listSeederQueue.map((fn) => limit(fn)));
-    await prisma.$disconnect();
  } catch (error) {
    console.error("error generate seeder", error);
-    await prisma.$disconnect();
  }

  return { status: 200, success: true };
--- a/src/app_modules/admin/donasi/fun/get/get_one_by_id.ts
+++ b/src/app_modules/admin/donasi/fun/get/get_one_by_id.ts
@@ -37,6 +37,5 @@ export async function AdminDonasi_getOneById(id: string) {
    },
  });

-  await prisma.$disconnect();
  return res;
 }
--- a/src/app_modules/admin/donasi/fun/update/fun_status_publish.ts
+++ b/src/app_modules/admin/donasi/fun/update/fun_status_publish.ts
@@ -33,12 +33,10 @@ export async function AdminDonasi_funUpdateStatusPublish(
  });

  if (!data) {
-    await prisma.$disconnect();
    return { status: 400, message: "Data tidak ditemukan" };
  }

  revalidatePath(RouterAdminDonasi.table_review);
-  await prisma.$disconnect();

  return {
    data: data,
--- a/src/app_modules/admin/notifikasi/fun/create/fun_create_notif_to_all_user.ts
+++ b/src/app_modules/admin/notifikasi/fun/create/fun_create_notif_to_all_user.ts
@@ -36,12 +36,10 @@ export default async function adminNotifikasi_funCreateToAllUser({
      },
    });
    if (!create) {
-      await prisma.$disconnect();
      return { status: 400, message: "Gagal mengirim notifikasi" };
    }
  }

-  await prisma.$disconnect();
  return {
    status: 201,
    message: "Berhasil mengirim notifikasi",
--- a/src/app_modules/admin/notifikasi/fun/create/fun_create_notif_user.ts
+++ b/src/app_modules/admin/notifikasi/fun/create/fun_create_notif_user.ts
@@ -25,10 +25,8 @@ export default async function adminNotifikasi_funCreateToUser({
  });

  if (!create) {
-    await prisma.$disconnect();
    return { status: 400, message: "Gagal mengirim notifikasi" };
  }

-  await prisma.$disconnect();
  return { status: 201, message: "Berhasil mengirim notifikasi" };
 }
--- a/src/app_modules/auth/login/view.tsx
+++ b/src/app_modules/auth/login/view.tsx
@@ -28,13 +28,10 @@ export default function Login({ version }: { version: string }) {
  const [countryCode, setCountryCode] = useState<string>("62"); // default ke Indonesia

  async function onLogin() {
-    console.log("phone >>", phone);
-
    const nomor = phone;
    if (nomor.length <= 4) return setError(true);

    const fixPhone = `${countryCode}${nomor}`;
-    console.log("fixPhone >>", fixPhone);

    try {
      setLoading(true);
@@ -46,7 +43,6 @@ export default function Login({ version }: { version: string }) {
        router.push("/validasi", { scroll: false });
      } else {
        setLoading(false);
-        console.log("respone >>", respone);
        ComponentGlobal_NotifikasiPeringatan(respone?.message);
      }
    } catch (error) {
@@ -108,9 +104,6 @@ export default function Login({ version }: { version: string }) {
                // Simpan hasil akhir
                setCountryCode(dialCode);
                setPhone(localNumber);
-
-                // console.log("Country Code:", dialCode);
-                // console.log("Clean Local Number:", localNumber);
              }}
            />

--- a/src/app_modules/donasi/fun/get/fun_check_status.tsx
+++ b/src/app_modules/donasi/fun/get/fun_check_status.tsx
@@ -9,9 +9,6 @@ export async function donasi_checkStatus({ id }: { id: string }) {
    },
  });

-  await prisma.$disconnect();
-
-
  if (checkStatus?.donasiMaster_StatusDonasiId == "2") return true;
  return false;

--- a/src/app_modules/waiting_room/view.tsx
+++ b/src/app_modules/waiting_room/view.tsx
@@ -25,15 +25,21 @@ export default function WaitingRoom_View({
  const [isLoadingHome, setIsLoadingHome] = useState(false);

  async function onClickLogout() {
-    setLoading(true);
-    const res = await fetch(`/api/auth/logout?id=${userLoginId}`, {
-      method: "GET",
-    });
+    try {
+      setLoading(true);
+      const res = await fetch(`/api/auth/logout?id=${userLoginId}`, {
+        method: "GET",
+      });

-    const result = await res.json();
-    if (res.status === 200) {
-      ComponentGlobal_NotifikasiBerhasil(result.message);
-      router.push("/", { scroll: false });
+      const result = await res.json();
+      if (res.status === 200) {
+        ComponentGlobal_NotifikasiBerhasil(result.message);
+        router.push("/", { scroll: false });
+      }
+    } catch (error) {
+      console.error("Error button to home", error);
+    } finally {
+      setLoading(false);
    }
  }

@@ -83,7 +89,8 @@ export default function WaitingRoom_View({
                  </Text>
                  <Text fw={"bold"} c={"white"} align="center">
                    Harap tunggu, Anda akan menerima pemberitahuan melalui
-                    Whatsapp setelah disetujui.
+                    Whatsapp setelah disetujui, untuk sementara anda bisa
+                    menunggu pada halaman ini atau keluar.
                  </Text>
                </Stack>
                {isAccess && (
@@ -110,6 +117,10 @@ export default function WaitingRoom_View({
                    Home
                  </Button>
                )}
+
+                <Button color="red" loading={loading} onClick={onClickLogout}>
+                  Keluar
+                </Button>
              </Stack>
            )}
          </ComponentGlobal_CardStyles>
--- a/src/lib/code-otp-sender.ts
+++ b/src/lib/code-otp-sender.ts
@@ -7,23 +7,24 @@ const sendCodeOtp = async ({
  codeOtp?: string;
  newMessage?: string;
 }) => {
-  const msg = newMessage || `HIPMI - Kode ini bersifat RAHASIA dan JANGAN DI BAGIKAN KEPADA SIAPAPUN, termasuk anggota ataupun pengurus HIPMI lainnya.\n\n>> Kode OTP anda: ${codeOtp}.`;
-  const enCode = encodeURIComponent(msg);
-  const res = await fetch(
-    `https://cld-dkr-prod-wajs-server.wibudev.com/api/wa/code?nom=${nomor}&text=${enCode}`,
-    {
-      cache: "no-cache",
-      headers: {
-        Authorization: `Bearer ${process.env.WA_SERVER_TOKEN}`,
-      },
+  const msg =
+    newMessage ||
+    `HIPMI - Kode ini bersifat RAHASIA dan JANGAN DI BAGIKAN KEPADA SIAPAPUN, termasuk anggota ataupun pengurus HIPMI lainnya.\n\n>> Kode OTP anda: ${codeOtp}.`;
+  const enCode = msg;
+
+  const res = await fetch(`https://otp.wibudev.com/api/wa/send-text`, {
+    method: "POST",
+    headers: {
+      "Content-Type": "application/json",
+      Authorization: `Bearer ${process.env.WA_SERVER_TOKEN}`,
    },
-  );
-  // const res = await fetch(
-  //   `https://wa.wibudev.com/code?nom=${nomor}&text=HIPMI - Kode ini bersifat RAHASIA dan JANGAN DI BAGIKAN KEPADA SIAPAPUN, termasuk anggota ataupun pengurus HIPMI lainnya.
-  //     \n
-  //     >> Kode OTP anda: ${codeOtp}.
-  //     `,
-  // );
+    body: JSON.stringify({
+      number: nomor,
+      text: enCode,
+    }),
+  });
+
+  console.log("RES >>", res);

  return res;
 };
--- a/src/lib/firebase-admin.ts
+++ b/src/lib/firebase-admin.ts
@@ -1,24 +1,25 @@
 // lib/firebase-admin.ts
 import { cert, getApp, getApps, initializeApp } from 'firebase-admin/app';
-import { getMessaging } from 'firebase-admin/messaging';
+import { getMessaging, Messaging } from 'firebase-admin/messaging';

-// Ambil dari environment
-const serviceAccount = {
-  projectId: process.env.FIREBASE_ADMIN_PROJECT_ID,
-  clientEmail: process.env.FIREBASE_ADMIN_CLIENT_EMAIL,
-  privateKey: process.env.FIREBASE_ADMIN_PRIVATE_KEY?.replace(/\\n/g, '\n'),
-};
+function getAdminApp() {
+  if (getApps().length > 0) return getApp();

-if (!serviceAccount.projectId || !serviceAccount.clientEmail || !serviceAccount.privateKey) {
-  throw new Error('Firebase Admin credentials are missing in environment variables');
+  const privateKey = process.env.FIREBASE_ADMIN_PRIVATE_KEY?.replace(/\\n/g, '\n');
+  const projectId = process.env.FIREBASE_ADMIN_PROJECT_ID;
+  const clientEmail = process.env.FIREBASE_ADMIN_CLIENT_EMAIL;
+
+  if (!projectId || !clientEmail || !privateKey) {
+    throw new Error('Firebase Admin credentials are missing in environment variables');
+  }
+
+  return initializeApp({
+    credential: cert({ projectId, clientEmail, privateKey }),
+    projectId,
+  });
 }

-// Inisialisasi hanya sekali
-const app = !getApps().length
-  ? initializeApp({
-      credential: cert(serviceAccount),
-      projectId: serviceAccount.projectId,
-    })
-  : getApp();
-
-export const adminMessaging = getMessaging(app);
+export const adminMessaging: Pick<Messaging, 'send' | 'sendEachForMulticast'> = {
+  send: (message) => getMessaging(getAdminApp()).send(message),
+  sendEachForMulticast: (message) => getMessaging(getAdminApp()).sendEachForMulticast(message),
+};
--- a/src/lib/prisma-retry.ts
+++ b/src/lib/prisma-retry.ts
@@ -0,0 +1,188 @@
+import { prisma } from './prisma';
+
+/**
+ * Retry configuration for database operations
+ */
+interface RetryConfig {
+  maxRetries: number;
+  initialDelay: number;
+  maxDelay: number;
+  factor: number;
+}
+
+const DEFAULT_RETRY_CONFIG: RetryConfig = {
+  maxRetries: 3,
+  initialDelay: 100,
+  maxDelay: 5000,
+  factor: 2,
+};
+
+/**
+ * Check if error is retryable (transient error)
+ */
+function isRetryableError(error: any): boolean {
+  const errorMsg = error instanceof Error ? error.message : '';
+  
+  // Retry on connection-related errors
+  const retryablePatterns = [
+    'ECONNRESET',
+    'ECONNREFUSED',
+    'ETIMEDOUT',
+    'ENOTFOUND',
+    'connection closed',
+    'connection terminated',
+    'connection timeout',
+    'socket hang up',
+    'too many connections',
+    'pool is full',
+    'server login has been failing',
+    'FATAL:',
+    'PrismaClientUnknownRequestError',
+  ];
+  
+  return retryablePatterns.some(pattern => 
+    errorMsg.toLowerCase().includes(pattern.toLowerCase())
+  );
+}
+
+/**
+ * Execute database operation with retry mechanism
+ * 
+ * @param operation - The database operation to execute
+ * @param config - Retry configuration (optional)
+ * @param operationName - Name of the operation for logging
+ * 
+ * @example
+ * const user = await withRetry(
+ *   () => prisma.user.findUnique({ where: { id: '123' } }),
+ *   undefined,
+ *   'findUser'
+ * );
+ */
+export async function withRetry<T>(
+  operation: () => Promise<T>,
+  config?: Partial<RetryConfig>,
+  operationName?: string
+): Promise<T> {
+  const retryConfig = { ...DEFAULT_RETRY_CONFIG, ...config };
+  let lastError: any;
+  
+  for (let attempt = 1; attempt <= retryConfig.maxRetries; attempt++) {
+    try {
+      const result = await operation();
+      
+      // Log success if it was a retry
+      if (attempt > 1 && operationName) {
+        console.log(`✅ [DB-RETRY] ${operationName} succeeded after ${attempt} attempts`);
+      }
+      
+      return result;
+    } catch (error) {
+      lastError = error;
+      const errorMsg = error instanceof Error ? error.message : 'Unknown error';
+      
+      // Check if we should retry
+      if (attempt < retryConfig.maxRetries && isRetryableError(error)) {
+        // Calculate delay with exponential backoff + jitter
+        const delay = Math.min(
+          retryConfig.initialDelay * Math.pow(retryConfig.factor, attempt - 1),
+          retryConfig.maxDelay
+        );
+        const jitter = Math.random() * 0.3 * delay; // Add 30% jitter
+        
+        if (operationName) {
+          console.warn(
+            `⚠️ [DB-RETRY] ${operationName} failed (attempt ${attempt}/${retryConfig.maxRetries}): ${errorMsg}`
+          );
+          console.log(`⏳ [DB-RETRY] Retrying in ${Math.round(delay + jitter)}ms...`);
+        }
+        
+        await new Promise(resolve => setTimeout(resolve, delay + jitter));
+      } else {
+        // Don't retry - either max retries reached or not a retryable error
+        if (operationName) {
+          console.error(
+            `❌ [DB-RETRY] ${operationName} failed after ${attempt} attempts: ${errorMsg}`
+          );
+        }
+        break;
+      }
+    }
+  }
+  
+  // All retries exhausted, throw the last error
+  throw lastError;
+}
+
+/**
+ * Execute database operation with timeout
+ * 
+ * @param operation - The database operation to execute
+ * @param timeout - Timeout in milliseconds (default: 30000)
+ * @param operationName - Name of the operation for logging
+ */
+export async function withTimeout<T>(
+  operation: () => Promise<T>,
+  timeout: number = 30000,
+  operationName?: string
+): Promise<T> {
+  const timeoutPromise = new Promise<never>((_, reject) => {
+    setTimeout(() => {
+      reject(new Error(`Operation timed out after ${timeout}ms`));
+    }, timeout);
+  });
+  
+  try {
+    return await Promise.race([operation(), timeoutPromise]);
+  } catch (error) {
+    const errorMsg = error instanceof Error ? error.message : 'Unknown error';
+    if (errorMsg.includes('timed out')) {
+      if (operationName) {
+        console.error(`⏱️ [DB-TIMEOUT] ${operationName} timed out after ${timeout}ms`);
+      }
+    }
+    throw error;
+  }
+}
+
+/**
+ * Combine retry and timeout for robust database operations
+ * 
+ * @param operation - The database operation to execute
+ * @param options - Retry and timeout options
+ * @param operationName - Name of the operation for logging
+ */
+export async function withRetryAndTimeout<T>(
+  operation: () => Promise<T>,
+  options?: {
+    retry?: Partial<RetryConfig>;
+    timeout?: number;
+  },
+  operationName?: string
+): Promise<T> {
+  return withRetry(
+    () => withTimeout(operation, options?.timeout, operationName),
+    options?.retry,
+    operationName
+  );
+}
+
+/**
+ * Health check for database connection
+ */
+export async function checkDatabaseConnection(): Promise<boolean> {
+  try {
+    await withTimeout(
+      () => prisma.$queryRaw`SELECT 1`,
+      5000,
+      'healthCheck'
+    );
+    return true;
+  } catch (error) {
+    const errorMsg = error instanceof Error ? error.message : 'Unknown error';
+    console.error('❌ [DB-HEALTH] Database connection check failed:', errorMsg);
+    return false;
+  }
+}
+
+export { prisma };
--- a/src/lib/prisma.ts
+++ b/src/lib/prisma.ts
@@ -1,53 +1,55 @@
 import { PrismaClient } from "@prisma/client";

-// Deklarasikan variabel global untuk menandai apakah listener sudah ditambahkan
+/**
+ * Instance global Prisma client untuk connection pooling
+ * Menggunakan pattern globalThis untuk mencegah multiple instance selama:
+ * - Hot module replacement (HMR) di development
+ * - Multiple import di seluruh aplikasi
+ * - Server-side rendering di Next.js
+ */
 declare global {
-  var prisma: PrismaClient;
-  var prismaListenersAdded: boolean; // Flag untuk menandai listener
+  // eslint-disable-next-line no-var
+  var prisma: PrismaClient | undefined;
 }

-let prisma: PrismaClient;
+// Konfigurasi connection pool via parameter query DATABASE_URL:
+// connection_limit=10&pool_timeout=20&connect_timeout=10
+const prisma =
+  globalThis.prisma ??
+  new PrismaClient({
+    log:
+      process.env.NODE_ENV === "development"
+        ? ["error", "warn"]
+        : ["error"],
+    datasources: {
+      db: {
+        url: process.env.DATABASE_URL,
+      },
+    },
+  });

-if (process.env.NODE_ENV === "production") {
-  prisma = new PrismaClient();
-} else {
-  if (!global.prisma) {
-    global.prisma = new PrismaClient();
-  }
-  prisma = global.prisma;
+// Hanya assign ke global di development untuk mencegah multiple instance saat HMR
+// Di production, ini di-skip karena tidak ada HMR
+if (process.env.NODE_ENV !== "production") {
+  globalThis.prisma = prisma;
 }

-// Tambahkan listener hanya jika belum ditambahkan sebelumnya
-if (!global.prismaListenersAdded) {
-  // Handle uncaught errors
-  process.on("uncaughtException", async (error) => {
-    console.error("Uncaught Exception:", error);
-    await prisma.$disconnect();
-    process.exit(1);
-  });
+/**
+ * Handler graceful shutdown untuk koneksi Prisma
+ * Panggil ini HANYA saat terminasi process (SIGINT/SIGTERM)
+ * JANGAN panggil $disconnect() setelah query individual
+ */
+async function gracefulShutdown(): Promise<void> {
+  console.log("[Prisma] Menutup koneksi database...");
+  await prisma.$disconnect();
+  console.log("[Prisma] Semua koneksi ditutup");
+}

-  // Handle unhandled promise rejections
-  process.on("unhandledRejection", async (error) => {
-    console.error("Unhandled Rejection:", error);
-    await prisma.$disconnect();
-    process.exit(1);
-  });
-
-  // Handle graceful shutdown
-  process.on("SIGINT", async () => {
-    console.log("Received SIGINT signal. Closing database connections...");
-    await prisma.$disconnect();
-    process.exit(0);
-  });
-
-  process.on("SIGTERM", async () => {
-    console.log("Received SIGTERM signal. Closing database connections...");
-    await prisma.$disconnect();
-    process.exit(0);
-  });
-
-  // Tandai bahwa listener sudah ditambahkan
-  global.prismaListenersAdded = true;
+// Register shutdown handlers (hanya di environment Node.js)
+if (typeof process !== "undefined") {
+  process.on("SIGINT", gracefulShutdown);
+  process.on("SIGTERM", gracefulShutdown);
 }

 export default prisma;
+export { prisma };
--- a/src/lib/prismaUtils.ts
+++ b/src/lib/prismaUtils.ts
@@ -0,0 +1,24 @@
+import { prisma } from './prisma';
+
+/**
+ * Utility function to safely execute Prisma operations
+ * This prevents improper disconnection of the Prisma client
+ * which was causing high CPU usage and connection pool issues
+ */
+export async function executeDbOperation<T>(
+  operation: () => Promise<T>,
+  errorMessage: string = "Database operation failed"
+): Promise<{ success: boolean; data?: T; error?: string }> {
+  try {
+    const data = await operation();
+    return { success: true, data };
+  } catch (error) {
+    console.error(errorMessage, error);
+    return { success: false, error: (error as Error).message };
+  }
+  // Note: We intentionally do NOT call prisma.$disconnect() here
+  // Prisma manages connection pooling automatically and disconnecting
+  // on each request causes performance issues
+}
+
+export { prisma };
--- a/src/middleware.tsx
+++ b/src/middleware.tsx
@@ -65,10 +65,7 @@ export const middleware = async (req: NextRequest) => {

  const { pathname } = req.nextUrl;

-  const apiBaseUrl = new URL(req.url).origin || process.env.NEXT_PUBLIC_API_URL;
-  const dbUrl = process.env.DATABASE_URL;
-  console.log("DATABASE_URL >>", dbUrl);
-  console.log("URL Access >>", req.url);
+  const apiBaseUrl = process.env.NEXT_PUBLIC_API_URL || new URL(req.url).origin;

  // Handle CORS preflight
  const corsResponse = handleCors(req);
--- a/src/util/mqtt_client.ts
+++ b/src/util/mqtt_client.ts
@@ -4,7 +4,66 @@ declare global {
  var mqtt_client: mqtt.MqttClient;
 }

-const mqtt_client =
-  globalThis.mqtt_client || mqtt.connect("wss://io.wibudev.com");
+// Initialize MQTT client with proper error handling and reconnection settings
+let mqtt_client: mqtt.MqttClient;
+
+if (typeof window === 'undefined') {
+  // Server-side code
+  mqtt_client = globalThis.mqtt_client || (() => {
+    const client = mqtt.connect("wss://io.wibudev.com", {
+      reconnectPeriod: 5000, // Reconnect every 5 seconds
+      connectTimeout: 30 * 1000, // 30 second timeout
+      // Clean session to avoid message queue buildup
+      clean: true,
+      // Reduce unnecessary pings
+      keepalive: 60
+    });
+
+    // Prevent multiple initializations
+    globalThis.mqtt_client = client;
+
+    // Add error handling
+    client.on('error', (error) => {
+      console.error('MQTT Connection Error:', error);
+    });
+
+    client.on('reconnect', () => {
+      console.log('MQTT Reconnecting...');
+    });
+
+    client.on('close', () => {
+      console.log('MQTT Connection Closed');
+    });
+
+    return client;
+  })();
+} else {
+  // Client-side code - initialize only once
+  if (!(globalThis as any).mqtt_client) {
+    (globalThis as any).mqtt_client = mqtt.connect("wss://io.wibudev.com", {
+      reconnectPeriod: 5000, // Reconnect every 5 seconds
+      connectTimeout: 30 * 1000, // 30 second timeout
+      // Clean session to avoid message queue buildup
+      clean: true,
+      // Reduce unnecessary pings
+      keepalive: 60
+    });
+
+    // Add error handling
+    (globalThis as any).mqtt_client.on('error', (error: any) => {
+      console.error('MQTT Connection Error:', error);
+    });
+
+    (globalThis as any).mqtt_client.on('reconnect', () => {
+      console.log('MQTT Reconnecting...');
+    });
+
+    (globalThis as any).mqtt_client.on('close', () => {
+      console.log('MQTT Connection Closed');
+    });
+  }
+  
+  mqtt_client = (globalThis as any).mqtt_client;
+}

 export default mqtt_client;
--- a/src/util/mqtt_loader.tsx
+++ b/src/util/mqtt_loader.tsx
@@ -3,20 +3,27 @@
 import { useEffect } from "react";
 import mqtt_client from "./mqtt_client";

-export default function   MqttLoader() {
+export default function MqttLoader() {
  useEffect(() => {
-    mqtt_client.on("connect", () => {
-      console.log("connected");
-    });
+    // Only set up connection handlers once
+    const handleConnect = () => {
+      console.log("MQTT connected");
+    };
+
+    const handleError = (error: any) => {
+      console.error("MQTT Error:", error);
+    };
+
+    // Subscribe to events
+    mqtt_client.on("connect", handleConnect);
+    mqtt_client.on("error", handleError);
+
+    // Cleanup function to unsubscribe when component unmounts
+    return () => {
+      mqtt_client.off("connect", handleConnect);
+      mqtt_client.off("error", handleError);
+    };
  }, []);

  return null;
-
-  //   <>
-  //     <Stack>
-  //       <Button onClick={onClick}>Tekan</Button>
-  //       <Button onClick={onClick2}>Tekan 2</Button>
-  //     </Stack>
-  //   </>
-  // );
 }
--- a/types/env.d.ts
+++ b/types/env.d.ts
@@ -11,5 +11,9 @@ declare namespace NodeJS {
    NEXT_PUBLIC_BASE_SESSION_KEY?: string;
    RESEND_APIKEY?: string;
    WA_SERVER_TOKEN?: string;
+    FIREBASE_ADMIN_PRIVATE_KEY?: string;
+    FIREBASE_ADMIN_CLIENT_EMAIL?: string;
+    FIREBASE_ADMIN_PROJECT_ID?: string;
+    NEXT_PUBLIC_API_URL?: string;
  }
 }
--- a/zCoba.js
+++ b/zCoba.js
@@ -1,26 +0,0 @@
-const { PrismaClient } = require('@prisma/client')
-
-const prisma = new PrismaClient()
-
-async function main() {
-  const result = await prisma.notifikasi.updateMany({
-    where: {
-      recipientId: 'cmha7p6yc0000cfoe5w2e7gdr',
-    },
-    data: {
-      isRead: false,
-      readAt: null,
-    },
-  })
-
-  console.log(`✅ Rows affected: ${result.count}`)
-}
-
-main()
-  .catch((err) => {
-    console.error('❌ Error:', err)
-    process.exit(1)
-  })
-  .finally(async () => {
-    await prisma.$disconnect()
-  })
Author	SHA1	Message	Date
bagasbanuna	b2305a35a6	Fix WA Otp ### NO Issue	2026-03-05 16:38:31 +08:00
bagasbanuna	cbfd105134	chore(release): 1.6.8	2026-03-05 14:30:03 +08:00
bagasbanuna	3e6c94d77f	Usulan Commit Message fix: Implementasi retry mechanism dan error handling untuk database connections Deskripsi: Menambahkan withRetry wrapper pada berbagai API routes untuk menangani transient database errors dan meningkatkan reliabilitas koneksi Memperbaiki error handling pada notification, authentication, dan user validation endpoints dengan response 503 untuk database connection errors Update prisma.ts dengan konfigurasi logging yang lebih baik dan datasources configuration Menambahkan validasi input parameters pada beberapa endpoints Update dokumentasi QWEN.md dengan commit message format dan comment standards Update .env.example dengan connection pool settings yang lebih lengkap File yang diubah: src/lib/prisma.ts — Konfigurasi Prisma client & logging src/app/api/admin/notifikasi/count/route.tsx src/app/api/auth/mobile-login/route.ts src/app/api/mobile/notification/[id]/route.ts src/app/api/user-validate/route.ts Dan 27 file API routes lainnya (penerapan withRetry secara konsisten) QWEN.md — Dokumentasi commit & comment standards .env.example — Database connection pool configuration ### No Issue	2026-03-05 14:28:45 +08:00
bagasbanuna	a6c9182a01	Fix Server dengan penerapan Github build	2026-03-04 16:38:58 +08:00
bagasbanuna	453aa0a4ec	chore(release): 1.6.7	2026-03-04 16:36:57 +08:00
bagasbanuna	fe37cce13e	Fix publish.yml	2026-03-04 16:08:59 +08:00
bagasbanuna	ee05d0c71f	Build Github	2026-03-04 15:18:01 +08:00
bagasbanuna	f8319b9ab5	Build with Github	2026-03-04 14:12:12 +08:00
bagasbanuna	2c1d74973b	Fix bug modified: next.config.js modified: src/app/api/mobile/forum/[id]/preview-report-comment/route.ts ### No Issue	2026-03-03 16:42:39 +08:00
bagasbanuna	04c2e0d580	chore(release): 1.6.6	2026-03-03 16:41:45 +08:00
bipproduction	6dba07baac	fix: prisma connection exhaustion & firebase lazy init - prisma/schema.prisma: tambah binaryTargets debian & linux-musl untuk Docker - src/lib/prisma.ts: pakai global singleton di dev & prod, hapus eager $connect() - src/lib/firebase-admin.ts: lazy initialization agar tidak crash saat build time - .env.example: lengkap dengan semua env variable + connection_limit & pool_timeout Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	2026-03-03 16:26:48 +08:00
bagasbanuna	b76c7a4b1c	Merge pull request 'bug-prisma 3' (#65 ) from bug-prisma/3-mar-26 into staging Reviewed-on: #65	2026-03-03 15:36:43 +08:00
bagasbanuna	240f6eb7c2	Fix console	2026-03-03 15:34:36 +08:00
bagasbanuna	f64ae42825	Fix Prisma 1 fix: error koneksi Prisma dengan retry mechanism 2 3 Perubahan: 4 - src/lib/prisma.ts: Tambah retry (3x) dengan exponential backoff saat connect 5 - src/lib/prisma-retry.ts: NEW - Utility wrapper untuk retry operations 6 - src/app/api/user-validate/route.ts: Improve error logging dengan detail 7 - src/middleware.tsx: Clean up commented code 8 9 Fitur: 10 - Auto retry saat database connection gagal 11 - Explicit () di production 12 - Better error logging untuk debugging 13 - Reusable retry wrapper (withRetry, withTimeout) 14 15 Testing: 16 - Build berhasil ✅ 17 - Type checking passed ✅ 18 19 Fixes: Error in PostgreSQL connection: Error { kind: Closed, cause: None } ### No Issue	2026-03-03 15:30:34 +08:00
bagasbanuna	df5d1aad48	chore(release): 1.6.5	2026-03-03 15:25:39 +08:00
bagasbanuna	82e69309a1	Merge pull request 'bug-prisma 2' (#64 ) from bug-prisma/3-mar-26 into staging Reviewed-on: #64	2026-03-03 14:19:10 +08:00
bagasbanuna	a6588818b5	fix: error koneksi Prisma - DATABASE_URL tidak loaded di production - Tambah validasi DATABASE_URL di prisma.ts - Tambah copy .env file di postbuild script ### No Issue	2026-03-03 14:15:15 +08:00
bagasbanuna	58e1afaa45	chore(release): 1.6.4	2026-03-03 14:14:00 +08:00
bagasbanuna	f65f9b7834	Merge pull request 'bug-prisma' (#63 ) from bug-prisma/3-mar-26 into staging Reviewed-on: #63	2026-03-03 12:11:04 +08:00
bagasbanuna	250b7c5261	Fix Prisma	2026-03-03 12:03:30 +08:00
bagasbanuna	935e519662	chore(release): 1.6.3	2026-03-03 11:55:25 +08:00
bagasbanuna	36b9248ed7	Merge pull request 'fix-bug middle' (#62 ) from fix-bug/25-feb-26 into staging Reviewed-on: #62	2026-02-25 15:35:20 +08:00
bagasbanuna	c6dbd152d5	Fix middleware ### NO Issue	2026-02-25 15:34:22 +08:00
bagasbanuna	714cf5cd5a	chore(release): 1.6.2	2026-02-25 15:22:40 +08:00
bagasbanuna	a2c5f053da	Merge pull request 'fix-bug/25-feb-26' (#61 ) from fix-bug/25-feb-26 into staging Reviewed-on: #61	2026-02-25 14:34:14 +08:00
bagasbanuna	a68343599d	Fix type env Fix: - modified: types/env.d.ts ### No Issue	2026-02-25 14:25:13 +08:00
bagasbanuna	419b87fc92	chore(release): 1.6.1	2026-02-25 12:00:20 +08:00
bagasbanuna	bedc0cc88b	Merge pull request 'Delete termsOfServiceAccepted on register' (#60 ) from mobile-api/24-feb-26 into staging Reviewed-on: #60	2026-02-25 10:46:17 +08:00
bagasbanuna	0271c87ba9	Delete termsOfServiceAccepted on register ### No issue	2026-02-24 18:04:05 +08:00
bagasbanuna	a9fbd544e5	Merge pull request 'mobile-api/24-feb-26' (#59 ) from mobile-api/24-feb-26 into staging Reviewed-on: #59	2026-02-24 07:42:44 +08:00
bagasbanuna	5551f30721	Fix API and clear code modified: src/app/api/auth/register/route.ts modified: src/app_modules/auth/login/view.tsx ### No Issue	2026-02-24 07:38:44 +08:00
bagasbanuna	00d36454d1	chore(release): 1.6.0	2026-02-24 07:33:28 +08:00
bagasbanuna	a762fbe9b1	Fix Api Mobile API – Admin Forum - src/app/api/mobile/admin/forum/route.ts - src/app/api/mobile/admin/forum/[id]/comment/route.ts - src/app/api/mobile/admin/forum/[id]/report-posting/route.ts Docs - PROMPT-AI.md ### No Issue	2026-02-20 16:47:28 +08:00
bagasbanuna	a98ab18423	Fix API Mobile API – Admin Forum & Investment - src/app/api/mobile/admin/forum/route.ts - src/app/api/mobile/admin/investment/route.ts - src/app/api/mobile/admin/investment/[id]/investor/route.ts Docs - PROMPT-AI.md ### No Issue	2026-02-19 16:44:17 +08:00
bagasbanuna	9afd741d4f	Merge pull request 'Fix Admin API Mobile' (#58 ) from mobile-api/18-feb-26 into staging Reviewed-on: #58	2026-02-18 17:33:11 +08:00
bagasbanuna	1c227a2850	Fix Admin API Mobile API – Admin Donation - src/app/api/mobile/admin/donation/[id]/disbursement/route.ts - src/app/api/mobile/admin/donation/[id]/donatur/route.ts - src/app/api/mobile/admin/donation/route.ts API – Master Data (Admin) - src/app/api/mobile/admin/master/donation/route.ts - src/app/api/mobile/admin/master/type-of-event/route.ts API – Admin Voting - src/app/api/mobile/admin/voting/route.ts Docs - PROMPT-AI.md - QWEN.md Deleted - CHANGELOG_BRANCH.md ### No Issue	2026-02-18 17:22:54 +08:00
bagasbanuna	817919f8f7	Merge pull request '### Fitur: Penambahan Pagination pada Endpoint Admin Mobile' (#57 ) from mobile-api/14-feb-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/57	2026-02-14 16:25:39 +08:00
bagasbanuna	5bdb998d2e	### Fitur: Penambahan Pagination pada Endpoint Admin Mobile #### Deskripsi Umum Telah dilakukan penambahan fitur pagination pada beberapa endpoint admin mobile untuk meningkatkan kinerja dan pengalaman pengguna saat mengakses data dalam jumlah besar. #### File yang Diubah 1. src/app/api/mobile/admin/job/route.ts - Ditambahkan parameter dari - Diterapkan logika pagination dengan (default 10) dan - Query telah dimodifikasi untuk mendukung pagination 2. src/app/api/mobile/admin/event/route.ts - Diperbaiki definisi variabel untuk memastikan tipe data yang konsisten - Ditambahkan default value 1 untuk parameter - Perhitungan disesuaikan agar lebih efisien 3. src/app/api/mobile/admin/event/[id]/participants/route.ts - Ditambahkan parameter dari - Diterapkan logika pagination dengan (default 10) dan - Query telah dimodifikasi untuk mendukung pagination #### Tujuan Perubahan - Meningkatkan kinerja aplikasi saat mengambil data dalam jumlah besar - Memungkinkan pengguna untuk mengakses data secara bertahap melalui halaman-halaman - Mengurangi beban server saat mengambil data dalam jumlah besar - Memberikan pengalaman pengguna yang lebih baik saat mengakses data admin #### Cara Penggunaan Untuk menggunakan fitur pagination, cukup tambahkan parameter pada query string saat melakukan permintaan ke endpoint yang telah dimodifikasi. Contoh: Default jumlah data per halaman adalah 10 item. ### No Issue	2026-02-14 15:36:09 +08:00
bagasbanuna	90031e23ef	Merge pull request 'Fix Api Mobile' (#56 ) from mobile-api/13-feb-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/56	2026-02-13 17:41:31 +08:00
bagasbanuna	b585aa3024	Fix Api Mobile API – Admin Master Data - src/app/api/mobile/admin/master/bank/route.ts - src/app/api/mobile/admin/master/business-field/route.ts - src/app/api/mobile/admin/master/business-field/[id]/route.ts Docs - PROMPT-AI.md ### No Issue	2026-02-13 17:40:25 +08:00
bagasbanuna	596ebd2ff4	Merge pull request 'mobile-api/12-feb-26' (#55 ) from mobile-api/12-feb-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/55	2026-02-12 17:49:00 +08:00
bagasbanuna	a8f9d2ac0d	Fix API Mobile Admin API – Admin User (Mobile) - src/app/api/mobile/admin/user/route.ts Docs - PROMPT-AI.md ### No Issue	2026-02-12 17:42:06 +08:00
bagasbanuna	d43f3762a3	Fixed Bug Server ## Summary This branch contains several bug fixes and performance improvements, primarily focusing on: - Database connection management - MQTT client stability - Logging optimization - API enhancements ## Detailed Changes ### Fixed Issues 1. Database Connection Management - Removed from user-validate API route to prevent connection pool exhaustion - Added proper connection handling in global Prisma setup - Reduced logging verbosity in production environments 2. MQTT Client Improvements - Enhanced MQTT client initialization with proper error handling - Added reconnection logic with configurable intervals - Implemented cleanup functions to prevent memory leaks - Added separate initialization logic for server and client-side code 3. Logging Optimization - Removed excessive logging in middleware that was causing high CPU usage - Configured appropriate log levels for development and production 4. Component Stability - Added safety checks in text editor component to prevent MQTT operations on the server side - Improved MQTT publishing logic with client availability checks ### New Files - - Utility functions for safe database operations ### Modified Files 1. - Removed problematic call 2. - Configured different logging levels for dev/prod - Removed process listeners that were causing disconnections - Exported prisma instance separately 3. - Removed excessive logging statements 4. - Enhanced initialization with error handling - Added reconnection and timeout configurations 5. - Added proper cleanup functions - Improved connection handling 6. - Added MQTT client availability checks - Prevented server-side MQTT operations ### Performance Improvements - Reduced database connection overhead - Optimized MQTT connection handling - Eliminated unnecessary logging in production - Better memory management with proper cleanup functions ### No Issue	2026-02-12 16:29:03 +08:00
bagasbanuna	aa700523ca	Merge pull request 'feat: Implementasi pagination pada endpoint mobile donation' (#54 ) from mobile-api/10-feb-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/54	2026-02-10 17:36:02 +08:00
bagasbanuna	e89886e1db	feat: Implementasi pagination pada endpoint mobile donation 4 5 - Menambahkan pagination pada endpoint GET /api/mobile/donation 6 - Menambahkan pagination pada endpoint GET /api/mobile/donation/[id]/news 7 - Menambahkan pagination pada endpoint GET /api/mobile/donation/[id]/donatur 8 - Memperbaiki validasi payload pada endpoint POST /api/mobile/auth/device-tokens 9 - Menangani struktur payload yang bersarang dan langsung pada device token endpoint 10 - Menambahkan informasi pagination ke dalam respons API ### NO Issue	2026-02-10 17:31:39 +08:00
bagasbanuna	236ab4d4a4	Merge pull request 'Mobile API' (#53 ) from mobile-api/9-feb-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/53	2026-02-09 17:38:52 +08:00
bagasbanuna	934d6a3ef1	feat: update mobile donation API and related dependencies Co-authored-by: Qwen-Coder <qwen-coder@alibabacloud.com>	2026-02-09 17:34:49 +08:00
bagasbanuna	a7694bd7d5	feat: Tambahkan pagination pada API mobile investasi Co-authored-by: Qwen-Coder <qwen-coder@alibabacloud.com> Deskripsi: - Tambahkan pagination pada endpoint investor/route.ts - Tambahkan pagination pada endpoint news/route.ts untuk kategori all-news - Gunakan konstanta PAGINATION_DEFAULT_TAKE untuk jumlah data per halaman - Tambahkan metadata pagination (currentPage, totalData, totalPage, dataPerPage) Fixes #issue-number	2026-02-09 15:08:33 +08:00
bagasbanuna	eaa7692359	Merge pull request 'Fix API mobile Investment' (#52 ) from mobile-api/6-feb-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/52	2026-02-06 17:39:36 +08:00
bagasbanuna	3b0ea3d847	chore(release): 1.5.40	2026-02-06 17:38:19 +08:00
bagasbanuna	097758a431	Fix API mobile Investment API – Investment (Mobile) - src/app/api/mobile/investment/route.ts - src/app/api/mobile/investment/[id]/[status]/route.ts - src/app/api/mobile/investment/[id]/invoice/route.ts - src/app/api/mobile/investment/[id]/document/route.ts Docs - PROMPT-AI.md ### No issue	2026-02-06 17:37:47 +08:00
bagasbanuna	d51ce346e6	Merge pull request 'Fix API mobile' (#51 ) from mobile-api/5-feb-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/51	2026-02-05 17:36:40 +08:00
bagasbanuna	6f5849aa29	Fix API mobile API – Voting (User) - src/app/api/mobile/voting/route.ts - src/app/api/mobile/voting/[id]/[status]/route.ts - src/app/api/mobile/voting/[id]/contribution/route.ts Docs - PROMPT-AI.md ### No Issue	2026-02-05 17:35:49 +08:00
bagasbanuna	91f4bb6c9e	Merge pull request 'mobile-api/4-jan-26' (#50 ) from mobile-api/4-jan-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/50	2026-02-05 10:11:03 +08:00
bagasbanuna	6aceb212e4	Fix APi voting mobile laod data API – Event (Mobile) - src/app/api/mobile/event/route.ts - src/app/api/mobile/event/[id]/[status]/route.ts - src/app/api/mobile/event/[id]/participants/route.ts API – Voting (Mobile) - src/app/api/mobile/voting/[id]/[status]/route.ts Docs - PROMPT-AI.md ### No Issue	2026-02-04 17:49:32 +08:00
bagasbanuna	1fe0001994	Merge pull request 'Fix API Job untuk loaddata:' (#49 ) from mobile-api/2-feb-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/49	2026-02-02 17:11:32 +08:00
bagasbanuna	b82a283731	Merge pull request 'mobile-api for load data' (#48 ) from mobile-api/30-jan-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/48	2026-01-30 17:20:09 +08:00
bagasbanuna	6d7d0fd07e	Merge pull request 'mobile-notification done' (#46 ) from mobile-notification/27-jan-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/46	2026-01-27 17:00:26 +08:00
bagasbanuna	bc80bb3441	Merge pull request 'Notification Donasi & EULA on login' (#45 ) from mobile-notification/23-jan-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/45	2026-01-23 17:06:56 +08:00
bagasbanuna	8ab94b9c86	Merge pull request 'mobile-notification invesment' (#44 ) from mobile-notification/21-jan-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/44	2026-01-21 15:41:18 +08:00
bagasbanuna	6e37b18e42	Merge pull request 'mobile-notification report comment' (#43 ) from mobile-notification/19-jan-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/43	2026-01-19 17:54:21 +08:00
bagasbanuna	a6db03d0b4	Merge pull request 'mobile-notification event dan voting' (#42 ) from mobile-notification/15-jan-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/42	2026-01-15 17:41:58 +08:00
bagasbanuna	c550a4e922	Merge pull request 'mobile-notification try to push to apple and android preview' (#41 ) from mobile-notification/12-jan-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/41	2026-01-15 17:41:13 +08:00
bagasbanuna	2431a3fa3e	Merge pull request 'Mobile notification & EULA route' (#40 ) from mobile-notification/9-jan-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/40	2026-01-09 17:47:40 +08:00
bagasbanuna	1ed0da8c7d	Merge pull request 'Fix API mobile notifikasi untuk job' (#39 ) from mobile-notification/7-jan-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/39	2026-01-08 15:26:19 +08:00
bagasbanuna	e15a5d796d	Merge pull request 'mobile notification' (#38 ) from mobile-notification/6-jan-26 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/38	2026-01-06 17:53:14 +08:00
bagasbanuna	836ebfaef0	Merge pull request 'mobile notification API' (#37 ) from mobile-notification/5-jan-25 into staging Reviewed-on: http://wibugit.wibudev.com/wibu/hipmi/pulls/37	2026-01-05 14:06:58 +08:00