Build with Github

modified:   next.config.js
        modified:   src/app/api/mobile/forum/[id]/preview-report-comment/route.ts

### No Issue

.env.example

@@ -0,0 +1,53 @@
+# ==============================
+# Database
+# ==============================
+# Tambahkan connection_limit dan pool_timeout untuk mencegah connection exhaustion
+DATABASE_URL="postgresql://user:password@localhost:5432/dbname?connection_limit=10&pool_timeout=20"
+
+# ==============================
+# 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"

.github/workflows/publish.yml

@@ -0,0 +1,59 @@
+name: Publish Docker to GHCR
+on:
+  workflow_dispatch:
+    inputs:
+      tag:
+        description: "Image tag (e.g. v1.0.0)"
+        required: true
+        default: "latest"
+env:
+  REGISTRY: ghcr.io
+  IMAGE_NAME: ${{ github.repository }}
+jobs:
+  publish:
+    name: Build & Push to GHCR
+    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: Extract tag name
+        id: meta
+        run: echo "tag=${{ github.event.inputs.tag }}" >> $GITHUB_OUTPUT
+
+      - 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: Build and push Docker image
+        uses: docker/build-push-action@v6
+        with:
+          context: .
+          file: ./Dockerfile
+          push: true
+          platforms: linux/amd64
+          tags: ${{ env.REGISTRY }}/${{ env.IMAGE_NAME }}:${{ steps.meta.outputs.tag }}
+          labels: ${{ steps.meta.outputs.labels }}
+          cache-from: type=gha
+          cache-to: type=gha,mode=max

CHANGELOG.md

@@ -2,6 +2,37 @@
 
 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.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)

CHANGELOG_BRANCH.md

@@ -1,63 +0,0 @@
-# Changelog for Branch: fixed-bug/12-feb-26
-
-## 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 `prisma.$disconnect()` 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
-- `src/lib/prismaUtils.ts` - Utility functions for safe database operations
-
-### Modified Files
-1. `src/app/api/user-validate/route.ts`
-   - Removed problematic `prisma.$disconnect()` call
-
-2. `src/lib/prisma.ts`
-   - Configured different logging levels for dev/prod
-   - Removed process listeners that were causing disconnections
-   - Exported prisma instance separately
-
-3. `src/middleware.tsx`
-   - Removed excessive logging statements
-
-4. `src/util/mqtt_client.ts`
-   - Enhanced initialization with error handling
-   - Added reconnection and timeout configurations
-
-5. `src/util/mqtt_loader.tsx`
-   - Added proper cleanup functions
-   - Improved connection handling
-
-6. `src/app_modules/_global/component/new/comp_V3_text_editor_stiker.tsx`
-   - 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

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.

Dockerfile

@@ -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"]

PROMPT-AI.md

@@ -1,5 +1,5 @@
 
-File utama: src/app/api/mobile/admin/master/business-field/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

QWEN.md

@@ -198,4 +198,4 @@ References: #issue-number
 ### Data Protection
 - Encrypted tokens
 - Secure API routes
-- Proper CORS configuration
+- Proper CORS configuration

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;

package.json

@@ -1,15 +1,16 @@
 {
   "name": "hipmi",
-  "version": "1.5.40",
+  "version": "1.6.6",
   "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"
   },

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 {

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!');

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: {

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") {

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 || "");
 

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 },
     );
   }
 }

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(

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 },
     );
   }
 }

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 {

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 },
     );
   }
 }

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 },
     );
   }
 }

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 },
     );
   }
 }

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,

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,
       });
     }
 

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") {

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({

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;
 

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,

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: {

src/app/api/user-validate/route.ts

@@ -76,15 +76,27 @@ 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: "Terjadi kesalahan pada server",
+        error: process.env.NODE_ENV === 'development' ? errorMsg : 'Internal server error',
       },
       { status: 500 }
     );
   }
-  // Removed prisma.$disconnect() from here to prevent connection pool exhaustion
-  // Prisma connections are handled globally and shouldn't be disconnected on each request
 }

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);
               }}
             />
 

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>

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),
+};

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 };

src/lib/prisma.ts

@@ -1,45 +1,21 @@
 import { PrismaClient } from "@prisma/client";
 
-// Deklarasikan variabel global untuk menandai apakah listener sudah ditambahkan
 declare global {
-  var prisma: PrismaClient;
-  var prismaListenersAdded: boolean; // Flag untuk menandai listener
+  var prisma: PrismaClient | undefined;
 }
 
-let prisma: PrismaClient;
-
-if (process.env.NODE_ENV === "production") {
-  prisma = new PrismaClient({
-    // Reduce logging in production to improve performance
-    log: ['error', 'warn'],
-  });
-} else {
-  if (!global.prisma) {
-    global.prisma = new PrismaClient({
-      log: ['error', 'warn', 'info', 'query'], // More verbose logging in development
-    });
-  }
-  prisma = global.prisma;
+if (!process.env.DATABASE_URL) {
+  throw new Error("DATABASE_URL is required but not found in environment variables");
 }
 
-// Tambahkan listener hanya jika belum ditambahkan sebelumnya
-if (!global.prismaListenersAdded) {
-  // Handle graceful shutdown
-  process.on("SIGINT", async () => {
-    console.log("Received SIGINT signal. Closing database connections...");
-    await prisma.$disconnect();
-    process.exit(0);
+const prisma =
+  global.prisma ??
+  new PrismaClient({
+    log: process.env.NODE_ENV === "development" ? ["error", "warn", "query"] : ["error", "warn"],
   });
 
-  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;
-}
+// Selalu assign ke global agar hanya ada 1 instance (dev: cegah hot-reload, prod: cegah multiple instances)
+global.prisma = prisma;
 
 export default prisma;
 export { prisma };

src/middleware.tsx

@@ -65,11 +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;
-  // Removed excessive logging that was causing high CPU usage
-  // 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);

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;
   }
 }

zCoba.js

@@ -1,204 +0,0 @@
-const { PrismaClient } = require('@prisma/client')
-const axios = require('axios')
-
-const prisma = new PrismaClient()
-
-// Daftar contoh data
-const donationDataList = [
-  {
-    "data": {
-      "authorId": "cmha6wb9w0001cfndwl9fcse6",
-      "title": "Bantuan Pendidikan Anak-anak Kurang Mampu",
-      "target": 50000000,
-      "donasiMaster_DurasiId": 3,
-      "donasiMaster_KategoriId": 3,
-      "namaBank": "Bank Central Asia",
-      "rekening": "1234567890",
-      "imageId": "cm60j9q3m000xc9dc584v8rh8",
-      "pembukaan": "Kami ingin membantu anak-anak kurang mampu mendapatkan pendidikan yang layak.",
-      "cerita": "Pendidikan adalah hak dasar setiap anak. Namun, banyak anak-anak di pelosok negeri yang tidak bisa menikmati pendidikan karena keterbatasan ekonomi. Melalui kampanye ini, kami ingin mengumpulkan dana untuk membantu biaya pendidikan mereka.",
-      "imageCeritaId": "cm60j9q3m000xc9dc584v8rj0"
-    }
-  },
-  {
-    "data": {
-      "authorId": "cmha6wb9w0001cfndwl9fcse6",
-      "title": "Pembangunan Masjid di Desa Terpencil",
-      "target": 100000000,
-      "donasiMaster_DurasiId": 3,
-      "donasiMaster_KategoriId": 3,
-      "namaBank": "Bank Mandiri",
-      "rekening": "0987654321",
-      "imageId": "cm60j9q3m000xc9dc584v8rh8",
-      "pembukaan": "Membangun masjid untuk masyarakat di daerah terpencil yang belum memiliki tempat ibadah.",
-      "cerita": "Di sebuah desa terpencil, masyarakat setiap hari harus berjalan jauh untuk bisa melaksanakan sholat berjamaah. Kami ingin membantu membangun masjid di tengah-tengah mereka agar ibadah bisa dilakukan dengan lebih tenang dan khusyuk.",
-      "imageCeritaId": "cm60j9q3m000xc9dc584v8rj1"
-    }
-  },
-  {
-    "data": {
-      "authorId": "cmha6wb9w0001cfndwl9fcse6",
-      "title": "Bantuan Korban Bencana Alam",
-      "target": 75000000,
-      "donasiMaster_DurasiId": 3,
-      "donasiMaster_KategoriId": 3,
-      "namaBank": "Bank Rakyat Indonesia",
-      "rekening": "5678901234",
-      "imageId": "cm60j9q3m000xc9dc584v8rh8",
-      "pembukaan": "Membantu meringankan beban korban bencana alam berupa kebutuhan pokok dan kebutuhan darurat.",
-      "cerita": "Beberapa wilayah dilanda bencana banjir dan tanah longsor. Masyarakat kehilangan harta benda dan membutuhkan bantuan segera. Dana yang terkumpul akan digunakan untuk menyediakan makanan, obat-obatan, dan kebutuhan pokok lainnya.",
-      "imageCeritaId": "cm60j9q3m000xc9dc584v8rj2"
-    }
-  },
-  {
-    "data": {
-      "authorId": "cmha6wb9w0001cfndwl9fcse6",
-      "title": "Pengadaan Alat Medis Rumah Sakit",
-      "target": 150000000,
-      "donasiMaster_DurasiId": 3,
-      "donasiMaster_KategoriId": 3,
-      "namaBank": "Bank Negara Indonesia",
-      "rekening": "4321098765",
-      "imageId": "cm60j9q3m000xc9dc584v8rh8",
-      "pembukaan": "Meningkatkan kualitas pelayanan kesehatan dengan menyediakan alat medis yang lebih baik.",
-      "cerita": "Rumah sakit daerah kekurangan alat medis untuk melayani pasien. Melalui donasi ini, kami ingin membantu pengadaan alat-alat medis penting seperti ventilator, USG, dan alat laboratorium untuk meningkatkan kualitas pelayanan kesehatan.",
-      "imageCeritaId": "cm60j9q3m000xc9dc584v8rj3"
-    }
-  },
-  {
-    "data": {
-      "authorId": "cmha6wb9w0001cfndwl9fcse6",
-      "title": "Program Beasiswa Mahasiswa Berprestasi",
-      "target": 80000000,
-      "donasiMaster_DurasiId": 3,
-      "donasiMaster_KategoriId": 3,
-      "namaBank": "Bank Danamon",
-      "rekening": "1122334455",
-      "imageId": "cm60j9q3m000xc9dc584v8rh8",
-      "pembukaan": "Memberikan kesempatan kepada mahasiswa berprestasi untuk melanjutkan pendidikan tanpa beban biaya.",
-      "cerita": "Banyak mahasiswa berprestasi yang tidak mampu melanjutkan pendidikan karena keterbatasan biaya. Program beasiswa ini akan membantu mereka menyelesaikan kuliah hingga sarjana.",
-      "imageCeritaId": "cm60j9q3m000xc9dc584v8rj4"
-    }
-  },
-  {
-    "data": {
-      "authorId": "cmha6wb9w0001cfndwl9fcse6",
-      "title": "Pengadaan Air Bersih untuk Desa Kekeringan",
-      "target": 60000000,
-      "donasiMaster_DurasiId": 3,
-      "donasiMaster_KategoriId": 3,
-      "namaBank": "Bank Permata",
-      "rekening": "6677889900",
-      "imageId": "cm60j9q3m000xc9dc584v8rh8",
-      "pembukaan": "Menyediakan akses air bersih bagi masyarakat yang tinggal di daerah rawan kekeringan.",
-      "cerita": "Beberapa desa mengalami kekeringan setiap tahunnya, membuat warga kesulitan mendapatkan air bersih. Kami ingin membangun sumur bor dan sistem distribusi air untuk membantu masyarakat setempat.",
-      "imageCeritaId": "cm60j9q3m000xc9dc584v8rj5"
-    }
-  },
-  {
-    "data": {
-      "authorId": "cmha6wb9w0001cfndwl9fcse6",
-      "title": "Pengobatan Gratis untuk Warga Tidak Mampu",
-      "target": 40000000,
-      "donasiMaster_DurasiId": 3,
-      "donasiMaster_KategoriId": 3,
-      "namaBank": "Bank Panin",
-      "rekening": "9988776655",
-      "imageId": "cm60j9q3m000xc9dc584v8rh8",
-      "pembukaan": "Memberikan layanan kesehatan gratis bagi warga yang tidak mampu membayar biaya pengobatan.",
-      "cerita": "Banyak warga yang menunda pengobatan karena keterbatasan biaya. Melalui program ini, kami akan menyelenggarakan pengobatan gratis secara berkala di berbagai wilayah.",
-      "imageCeritaId": "cm60j9q3m000xc9dc584v8rj6"
-    }
-  },
-  {
-    "data": {
-      "authorId": "cmha6wb9w0001cfndwl9fcse6",
-      "title": "Pembangunan Taman Bacaan Masyarakat",
-      "target": 35000000,
-      "donasiMaster_DurasiId": 3,
-      "donasiMaster_KategoriId": 3,
-      "namaBank": "Bank Mega",
-      "rekening": "1357924680",
-      "imageId": "cm60j9q3m000xc9dc584v8rh8",
-      "pembukaan": "Membangun taman bacaan untuk meningkatkan minat baca masyarakat di wilayah pedesaan.",
-      "cerita": "Minat baca masyarakat di pedesaan masih rendah karena keterbatasan akses buku. Taman bacaan ini akan menyediakan ribuan buku gratis dan ruang baca yang nyaman untuk semua usia.",
-      "imageCeritaId": "cm60j9q3m000xc9dc584v8rj7"
-    }
-  },
-  {
-    "data": {
-      "authorId": "cmha6wb9w0001cfndwl9fcse6",
-      "title": "Pelatihan Keterampilan untuk Pengangguran",
-      "target": 55000000,
-      "donasiMaster_DurasiId": 3,
-      "donasiMaster_KategoriId": 3,
-      "namaBank": "Bank CIMB Niaga",
-      "rekening": "2468135790",
-      "imageId": "cm60j9q3m000xc9dc584v8rh8",
-      "pembukaan": "Memberikan pelatihan keterampilan untuk membantu pengangguran mendapatkan pekerjaan atau usaha mandiri.",
-      "cerita": "Angka pengangguran masih tinggi di beberapa wilayah. Program pelatihan ini akan memberikan keterampilan yang dibutuhkan pasar kerja, seperti menjahit, memasak, teknologi informasi, dan lainnya.",
-      "imageCeritaId": "cm60j9q3m000xc9dc584v8rj8"
-    }
-  },
-  {
-    "data": {
-      "authorId": "cmha6wb9w0001cfndwl9fcse6",
-      "title": "Renovasi Gedung Sekolah Rusak",
-      "target": 90000000,
-      "donasiMaster_DurasiId": 3,
-      "donasiMaster_KategoriId": 3,
-      "namaBank": "Bank OCBC NISP",
-      "rekening": "1029384756",
-      "imageId": "cm60j9q3m000xc9dc584v8rh8",
-      "pembukaan": "Merestrukturasi gedung sekolah yang rusak agar siswa bisa belajar dengan aman dan nyaman.",
-      "cerita": "Banyak gedung sekolah yang rusak parah dan membahayakan keselamatan siswa. Dana dari kampanye ini akan digunakan untuk renovasi dan perbaikan gedung sekolah yang membutuhkan.",
-      "imageCeritaId": "cm60j9q3m000xc9dc584v8rj9"
-    }
-  }
-];
-
-async function sendDonationData() {
-  const baseUrl = 'http://localhost:3000/api/mobile/donation'; // Sesuaikan dengan URL server Anda
-  const headers = {
-    'Content-Type': 'application/json',
-  };
-
-  for (let i = 0; i < donationDataList.length; i++) {
-    try {
-      console.log(`Mengirim data ke-${i + 1}...`);
-      const response = await axios.post(`${baseUrl}?category=permanent`, donationDataList[i], {
-        headers: headers
-      });
-      console.log(`Data ke-${i + 1} berhasil dikirim:`, response.data);
-    } catch (error) {
-      console.error(`Error saat mengirim data ke-${i + 1}:`, error.response?.data || error.message);
-    }
-  }
-}
-
-async function main() {
-  // Menjalankan fungsi untuk mengirim data donasi
-  await sendDonationData();
-
-  // Fungsi asli untuk update notifikasi
-  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()
-  })