Merge pull request 'server/14-apr-26' (#69 ) from server/14-apr-26 into staging

Reviewed-on: #69
chore: remove unused test file
2026-04-14 16:38:23 +08:00 · 2026-04-14 15:42:58 +08:00 · 2026-04-14 15:34:52 +08:00 · 2026-04-14 15:17:45 +08:00 · 2026-03-30 15:49:07 +08:00 · 2026-03-30 15:48:42 +08:00
88 changed files with 1584 additions and 2381 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,65 @@

 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.7.5](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.7.4...v1.7.5) (2026-04-14)
+
+
+### Bug Fixes
+
+* override MIME type for PDF uploads & fix build errors ([38239c5](https://wibugit.wibudev.com/wibu/hipmi/commit/38239c52d6d083d0c6ee6fde94f09e16fa7201dd))
+
+## [1.7.4](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.7.3...v1.7.4) (2026-03-30)
+
+## [1.7.3](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.7.2...v1.7.3) (2026-03-27)
+
+## [1.7.2](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.7.1...v1.7.2) (2026-03-13)
+
+## [1.7.1](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.7.0...v1.7.1) (2026-03-11)
+
+## [1.7.0](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.6.9...v1.7.0) (2026-03-10)
+
+
+### Features
+
+* Tambahkan deep link handler untuk event confirmation ([73cbf36](https://wibugit.wibudev.com/wibu/hipmi/commit/73cbf3640ac795995e15448b24408b179d2a46d2))
+
+## [1.6.9](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.6.8...v1.6.9) (2026-03-06)
+
+## [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)
--- a/DEBUG_UPLOAD_FILE.md
+++ b/DEBUG_UPLOAD_FILE.md
@@ -0,0 +1,170 @@
+# Debug Guide: Upload File Android vs iOS
+
+## 📱 Problem
+- ✅ Upload **IMAGE** berhasil di iOS dan Android
+- ❌ Upload **PDF** gagal di Android dengan error: `Status: 400 Bad Request`
+
+## 🔍 Root Cause (DITEMUKAN!)
+
+### **Masalah MIME Type PDF**
+Dari log upload:
+```
+File details:
+  - Name: 154ce3b0-6fc0-4a39-9e09-3f9aa2b19300.pdf
+  - Type: image/pdf         ← ❌ SALAH!
+  - Size: 26534 bytes
+```
+
+**Yang benar:**
+- ❌ `image/pdf` (salah - tidak ada MIME type ini)
+- ✅ `application/pdf` (benar - standard MIME type untuk PDF)
+
+### **Kenapa Terjadi?**
+Mobile app (Android) salah set MIME type saat mengirim file PDF. Kemungkinan:
+1. File picker/set MIME type salah di mobile code
+2. Android WebView auto-detect MIME type incorrectly
+3. Mobile app hardcoded MIME type yang salah
+
+## 🛠️ Solusi yang Sudah Diterapkan
+
+### File: `src/app/api/mobile/file/route.ts`
+
+**Fix #1: Safe JSON Parsing**
+- ✅ Cek response sebagai text dulu, lalu parse JSON
+- ✅ Handle Content-Type yang salah dari external storage
+
+**Fix #2: MIME Type Override (LATEST)**
+- ✅ Deteksi file PDF dari extension (.pdf)
+- ✅ Override MIME type ke `application/pdf` jika salah
+- ✅ Rebuild FormData dengan file yang sudah difix
+
+**Code:**
+```typescript
+// Jika file PDF tapi type bukan application/pdf, fix it
+if (fileName.endsWith(".pdf") && originalType !== "application/pdf") {
+  console.log("⚠️ WARNING: PDF file has wrong MIME type:", originalType);
+  console.log("🔧 Overriding to: application/pdf");
+  
+  // Create new File with correct MIME type
+  const buffer = await file.arrayBuffer();
+  fixedFile = new File([buffer], file.name, {
+    type: "application/pdf",
+    lastModified: file.lastModified,
+  });
+  
+  // Rebuild formData with fixed file
+  formData.set("file", fixedFile);
+}
+```
+
+## 🧪 Cara Testing
+
+### 1. **Test Upload dari Android**
+Coba upload file PDF dari Android dan perhatikan log di terminal:
+
+```bash
+# Log yang akan muncul:
+=== UPLOAD REQUEST START ===
+dirId: xxx
+File details:
+  - Name: dokumen.pdf
+  - Type: application/pdf
+  - Size: 1234567 bytes
+  - Size (KB): 1205.63
+===========================
+Directory key: xxx
+=== EXTERNAL STORAGE RESPONSE ===
+Status: 400
+Status Text: Bad Request
+Content-Type: text/html; charset=utf-8
+=================================
+=== ERROR: Non-JSON Response ===
+Response text: Unsupported file format...
+=================================
+```
+
+### 2. **Informasi yang Perlu Dicari:**
+Dari log di atas, perhatikan:
+- **File size** → Berapa MB? (mungkin terlalu besar?)
+- **File type** → `application/pdf` atau yang lain?
+- **External storage response** → Status code & message?
+- **Error text** → Apa yang dikembalikan server external?
+
+### 3. **Compare iOS vs Android**
+Upload file yang sama dari iOS dan Android, bandingkan log-nya.
+
+## 📊 Expected Log Output
+
+### ✅ Success Case:
+```
+=== UPLOAD REQUEST START ===
+dirId: investment
+File details:
+  - Name: proposal.pdf
+  - Type: application/pdf
+  - Size: 524288 bytes
+  - Size (KB): 512.00
+===========================
+Directory key: investment
+=== EXTERNAL STORAGE RESPONSE ===
+Status: 200
+Status Text: OK
+Content-Type: application/json
+=================================
+✅ Upload SUCCESS
+```
+
+### ❌ Failed Case (Non-JSON Response):
+```
+=== UPLOAD REQUEST START ===
+dirId: investment
+File details:
+  - Name: proposal.pdf
+  - Type: application/pdf
+  - Size: 5242880 bytes  ← Mungkin terlalu besar?
+  - Size (KB): 5120.00
+===========================
+=== EXTERNAL STORAGE RESPONSE ===
+Status: 413  ← Payload Too Large?
+Content-Type: text/html
+=================================
+=== ERROR: Non-JSON Response ===
+Response text: <html><body>413 Request Entity Too Large</body></html>
+=================================
+```
+
+## 🔧 Next Steps (Setelah Testing)
+
+Berdasarkan log, kita bisa identify masalahnya:
+
+### **Jika masalah FILE SIZE:**
+- Tambahkan limit validation di frontend
+- Compress PDF sebelum upload
+- Increase external storage limit
+
+### **Jika masalah FILE FORMAT:**
+- Validate file type sebelum upload
+- Convert format jika perlu
+- Update external storage allowed formats
+
+### **Jika masalah NETWORK/HEADERS:**
+- Check user-agent differences
+- Validate Authorization header
+- Check CORS settings
+
+## 📝 Checklist Testing
+- [ ] Test upload PDF kecil (< 1MB) dari Android
+- [ ] Test upload PDF besar (> 5MB) dari Android  
+- [ ] Test upload PDF dari iOS (baseline)
+- [ ] Compare log output iOS vs Android
+- [ ] Check file type yang dikirim
+- [ ] Check file size yang dikirim
+- [ ] Check response dari external storage
+
+## 🎯 Goal
+Dari log yang detail, kita bisa tahu **exact reason** kenapa Android fail, lalu fix dengan tepat.
+
+---
+
+**Last Updated:** 2026-04-14
+**Status:** ✅ Logging added, ready for testing
--- a/68
+++ b/68
@@ -0,0 +1,68 @@
+# ==============================
+# Stage 1: Builder
+# ==============================
+FROM oven/bun:1-debian AS builder
+
+WORKDIR /app
+
+RUN apt-get update && apt-get install -y --no-install-recommends \
+    libc6 \
+    git \
+    openssl \
+    ca-certificates \
+    && rm -rf /var/lib/apt/lists/*
+
+COPY package.json bun.lockb* ./
+
+ENV SHARP_IGNORE_GLOBAL_LIBVIPS=1
+ENV NEXT_TELEMETRY_DISABLED=1
+ENV NODE_OPTIONS="--max-old-space-size=4096"
+
+RUN bun install --frozen-lockfile
+COPY . .
+
+RUN cp .env.example .env || true
+
+ENV PRISMA_CLI_BINARY_TARGETS=debian-openssl-3.0.x
+RUN bunx prisma generate
+
+RUN bun run build
+
+# ==============================
+# Stage 2: Runner (Production)
+# ==============================
+FROM oven/bun:1-debian AS runner
+
+WORKDIR /app
+
+ENV NODE_ENV=production
+ENV NEXT_TELEMETRY_DISABLED=1
+ENV PRISMA_CLI_BINARY_TARGETS=debian-openssl-3.0.x
+
+RUN apt-get update && apt-get install -y --no-install-recommends \
+    openssl \
+    ca-certificates \
+    && rm -rf /var/lib/apt/lists/*
+
+RUN groupadd --system --gid 1001 nodejs \
+    && useradd --system --uid 1001 --gid nodejs nextjs
+
+COPY --from=builder /app/node_modules ./node_modules
+COPY --from=builder /app/.next ./.next
+COPY --from=builder /app/public ./public
+COPY --from=builder /app/package.json ./package.json
+COPY --from=builder /app/prisma ./prisma
+COPY --from=builder /app/src ./src
+COPY --from=builder /app/next.config.js ./next.config.js
+COPY --from=builder /app/tsconfig.json ./tsconfig.json
+
+RUN chown -R nextjs:nodejs /app
+
+USER nextjs
+
+EXPOSE 3000
+
+ENV PORT=3000
+ENV HOSTNAME="0.0.0.0"
+
+CMD ["bun", "start"]
--- a/PROMPT-AI.md
+++ b/PROMPT-AI.md
@@ -1,5 +1,5 @@

-File utama: src/app/api/mobile/admin/investment/[id]/investor/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
--- a/QWEN.md
+++ b/QWEN.md
@@ -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
--- 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,36 @@
 /** @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: "/.well-known/:path*",
+        headers: [
+          { key: "Content-Type", value: "application/json" },
+          {
+            key: "Cache-Control",
+            value: "no-cache, no-store, must-revalidate",
+          },
+        ],
+      },
+    ];
  },
-  // async headers() {
-  //   return [
-  //     {
-  //       source: "/(.*)",
-  //       headers: [
-  //         {
-  //           key: "Cache-Control",
-  //           value: "no-store, max-age=0",
-  //         },
-  //       ],
-  //     },
-  //   ];
-  // },
 };

 module.exports = nextConfig;
--- a/package.json
+++ b/package.json
@@ -1,15 +1,16 @@
 {
  "name": "hipmi",
-  "version": "1.5.40",
+  "version": "1.7.5",
  "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"
  },
--- 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/public/.well-known/assetlinks.json
+++ b/public/.well-known/assetlinks.json
@@ -1,8 +1,10 @@
-[{
-  "relation": ["delegate_permission/common.handle_all_urls"],
-  "target": {
-    "namespace": "android_app",
-    "package_name": "com.bip.hipmimobileapp",
-    "sha256_cert_fingerprints": ["CFF8431520BFAE665025B68138774A4E64AA6338D2DF6C7D900A71F0551FFD2D"]
+[
+  {
+    "relation": ["delegate_permission/common.handle_all_urls"],
+    "target": {
+      "namespace": "android_app",
+      "package_name": "com.bip.hipmimobileapp",
+      "sha256_cert_fingerprints": ["CFF8431520BFAE665025B68138774A4E64AA6338D2DF6C7D900A71F0551FFD2D"]
+    }
  }
-}]
+]
--- 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/(event-confirmation)/event/[id]/confirmation/route.ts
+++ b/src/app/(event-confirmation)/event/[id]/confirmation/route.ts
@@ -0,0 +1,186 @@
+/**
+ * Route Handler untuk Deep Link Event Confirmation
+ * File: app/event/[id]/confirmation/route.ts
+ * Deskripsi: Handle GET request untuk deep link event confirmation dengan redirect ke mobile app
+ * Pembuat: Assistant
+ * Tanggal: 9 Maret 2026
+ */
+
+import { url } from "inspector";
+import { NextRequest, NextResponse } from "next/server";
+
+/**
+ * Detect platform dari User Agent string
+ * @param userAgent - User Agent string dari request
+ * @returns Platform type: 'ios', 'android', atau 'web'
+ */
+function detectPlatform(userAgent: string | null): "ios" | "android" | "web" {
+  if (!userAgent) {
+    return "web";
+  }
+
+  const lowerUA = userAgent.toLowerCase();
+
+  // Detect iOS devices
+  if (
+    /iphone|ipad|ipod/.test(lowerUA) ||
+    (lowerUA.includes("mac") && (("ontouchend" in {}) as any))
+  ) {
+    return "ios";
+  }
+
+  // Detect Android devices
+  if (/android/.test(lowerUA)) {
+    return "android";
+  }
+
+  // Default to web
+  return "web";
+}
+
+/**
+ * Build custom scheme URL untuk mobile app
+ * @param eventId - Event ID dari URL
+ * @param userId - User ID dari query parameter
+ * @param platform - Platform yang terdetect
+ * @returns Custom scheme URL
+ */
+function buildCustomSchemeUrl(
+  eventId: string,
+  userId: string | null,
+  platform: "ios" | "android" | "web",
+): string {
+  const baseUrl = "hipmimobile://event";
+  const url = `${baseUrl}/${eventId}/confirmation${userId ? `?userId=${userId}` : ""}`;
+  return url;
+}
+
+/**
+ * Get base URL dari environment
+ */
+function getBaseUrl(): string {
+  const env = process.env.NEXT_PUBLIC_ENV || "development";
+
+  if (env === "production") {
+    return "https://hipmi.muku.id";
+  }
+
+  if (env === "staging") {
+    return "https://cld-dkr-hipmi-stg.wibudev.com";
+  }
+
+  return "http://localhost:3000";
+}
+
+/**
+ * Handle GET request untuk deep link
+ * @param request - Next.js request object
+ * @returns Redirect ke mobile app atau JSON response untuk debugging
+ */
+export async function GET(
+  request: NextRequest,
+  { params }: { params: { id: string } },
+) {
+  try {
+    // Parse query parameters
+    const searchParams = request.nextUrl.searchParams;
+    const eventId = params.id;
+    const userId = searchParams.get("userId") || null;
+    const userAgent = request.headers.get("user-agent") || "";
+
+    // Detect platform
+    const platform = detectPlatform(userAgent);
+
+    // Log untuk tracking
+    console.log("[Deep Link] Event Confirmation Received:", {
+      eventId,
+      userId,
+      platform,
+      userAgent:
+        userAgent.substring(0, 100) + (userAgent.length > 100 ? "..." : ""),
+      timestamp: new Date().toISOString(),
+      url: request.url,
+    });
+
+    // Build custom scheme URL untuk redirect
+    const customSchemeUrl = buildCustomSchemeUrl(eventId, userId, platform);
+
+    // Redirect ke mobile app untuk iOS dan Android
+    if (platform === "ios" || platform === "android") {
+      console.log("[Deep Link] Redirecting to mobile app:", customSchemeUrl);
+
+      // Redirect ke custom scheme URL
+      return NextResponse.redirect(customSchemeUrl);
+    }
+
+    console.log("[Deep Link] Environment:", process.env.NEXT_PUBLIC_ENV);
+    console.log("[Deep Link] Base URL:", getBaseUrl());
+    console.log("[Deep Link] Request:", {
+      eventId,
+      userId,
+      platform,
+      url: request.url,
+      timestamp: new Date().toISOString(),
+    });
+
+    // Untuk web/desktop, tampilkan JSON response untuk debugging
+    const responseData = {
+      success: true,
+      message: "Deep link received - Web fallback",
+      data: {
+        eventId,
+        userId,
+        platform,
+        userAgent,
+        timestamp: new Date().toISOString(),
+        url: request.url,
+        customSchemeUrl,
+        note: "This is a web fallback. Mobile users will be redirected to the app.",
+      },
+    };
+
+    return NextResponse.json(responseData, {
+      status: 200,
+      headers: {
+        "Content-Type": "application/json",
+        "Access-Control-Allow-Origin": "*",
+        "Access-Control-Allow-Methods": "GET, OPTIONS",
+        "Access-Control-Allow-Headers": "Content-Type",
+      },
+    });
+  } catch (error) {
+    console.error("[Deep Link] Error processing request:", error);
+
+    return NextResponse.json(
+      {
+        success: false,
+        message: "Error processing deep link",
+        error: error instanceof Error ? error.message : "Unknown error",
+      },
+      {
+        status: 500,
+        headers: {
+          "Content-Type": "application/json",
+          "Access-Control-Allow-Origin": "*",
+        },
+      },
+    );
+  }
+}
+
+/**
+ * Handle OPTIONS request untuk CORS preflight
+ */
+export async function OPTIONS() {
+  return NextResponse.json(
+    {},
+    {
+      status: 200,
+      headers: {
+        "Access-Control-Allow-Origin": "*",
+        "Access-Control-Allow-Methods": "GET, OPTIONS",
+        "Access-Control-Allow-Headers": "Content-Type",
+      },
+    },
+  );
+}
--- a/src/app/(support)/support-center/page.tsx
+++ b/src/app/(support)/support-center/page.tsx
@@ -98,7 +98,7 @@ export default function SupportCenter() {
              <Title>Support Center</Title>
            </Group>
            <Text align="center">
-              Send us a message and we'll get back to you as soon as possible.
+              Send us a message and we&apos;ll get back to you as soon as possible.
            </Text>
          </Stack>
        </Stack>
--- 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/mobile-validasi/route.ts
+++ b/src/app/api/auth/mobile-validasi/route.ts
@@ -1,8 +1,12 @@
 import { sessionCreate } from "@/app/(auth)/_lib/session_create";
 import prisma from "@/lib/prisma";
-import backendLogger from "@/util/backendLogger";
 import { NextResponse } from "next/server";

+/**
+ * Validasi OTP untuk login mobile
+ * @param req - Request dengan body { nomor: string, code: string }
+ * @returns Response dengan token jika OTP valid
+ */
 export async function POST(req: Request) {
  if (req.method !== "POST") {
    return NextResponse.json(
@@ -12,8 +16,21 @@ export async function POST(req: Request) {
  }

  try {
-    const { nomor } = await req.json();
+    const { nomor, code } = await req.json();

+    // Validasi input: nomor dan code wajib ada
+    if (!nomor || !code) {
+      return NextResponse.json(
+        { success: false, message: "Nomor dan kode OTP wajib diisi" },
+        { status: 400 }
+      );
+    }
+
+    // Special case untuk Apple Review: nomor 6282340374412 dengan code "1234" selalu valid
+    const isAppleReviewNumber = nomor === "6282340374412";
+    const isAppleReviewCode = code === "1234";
+
+    // Cek user berdasarkan nomor
    const dataUser = await prisma.user.findUnique({
      where: {
        nomor: nomor,
@@ -28,11 +45,92 @@ export async function POST(req: Request) {
      },
    });

-    if (dataUser == null)
+    if (dataUser == null) {
      return NextResponse.json(
        { success: false, message: "Nomor Belum Terdaftar" },
        { status: 200 }
      );
+    }
+
+    // Validasi OTP (skip untuk Apple Review number di production)
+    let otpValid = false;
+
+    if (isAppleReviewNumber && isAppleReviewCode) {
+      // Special case: Apple Review number dengan code "1234" selalu valid
+      otpValid = true;
+      console.log("Apple Review login bypass untuk nomor: " + nomor);
+    } else {
+      // Normal flow: validasi OTP dari database
+      const otpRecord = await prisma.kodeOtp.findFirst({
+        where: {
+          nomor: nomor,
+          isActive: true,
+        },
+        orderBy: {
+          createdAt: "desc",
+        },
+      });
+
+      if (!otpRecord) {
+        return NextResponse.json(
+          { success: false, message: "Kode OTP tidak ditemukan" },
+          { status: 400 }
+        );
+      }
+
+      // Cek expired OTP (5 menit dari createdAt)
+      const now = new Date();
+      const otpCreatedAt = new Date(otpRecord.createdAt);
+      const expiredTime = new Date(otpCreatedAt.getTime() + 5 * 60 * 1000); // 5 menit
+
+      if (now > expiredTime) {
+        // OTP sudah expired, update isActive menjadi false
+        await prisma.kodeOtp.updateMany({
+          where: {
+            nomor: nomor,
+            isActive: true,
+          },
+          data: {
+            isActive: false,
+          },
+        });
+
+        return NextResponse.json(
+          { success: false, message: "Kode OTP sudah kadaluarsa" },
+          { status: 400 }
+        );
+      }
+
+      // Validasi code OTP
+      const inputCode = parseInt(code);
+      if (isNaN(inputCode) || inputCode !== otpRecord.otp) {
+        return NextResponse.json(
+          { success: false, message: "Kode OTP tidak valid" },
+          { status: 400 }
+        );
+      }
+
+      otpValid = true;
+
+      // Nonaktifkan OTP yang sudah digunakan
+      await prisma.kodeOtp.updateMany({
+        where: {
+          nomor: nomor,
+          isActive: true,
+        },
+        data: {
+          isActive: false,
+        },
+      });
+    }
+
+    // Generate token jika OTP valid
+    if (!otpValid) {
+      return NextResponse.json(
+        { success: false, message: "Validasi OTP gagal" },
+        { status: 400 }
+      );
+    }

    const token = await sessionCreate({
      sessionKey: process.env.NEXT_PUBLIC_BASE_SESSION_KEY!,
@@ -46,6 +144,7 @@ export async function POST(req: Request) {
        { status: 500 }
      );
    }
+
    // Buat response dengan token dalam cookie
    const response = NextResponse.json(
      {
@@ -69,7 +168,7 @@ export async function POST(req: Request) {

    return response;
  } catch (error) {
-    backendLogger.log("API Error or Server Error", error);
+    console.log("API Error or Server Error", error);
    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/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
@@ -80,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,
+                },
+              },
            },
          },
        },
@@ -140,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) => {
@@ -152,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,
@@ -194,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) => {
@@ -206,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(
        {
@@ -217,7 +249,7 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
          message: "Invalid category",
          reason: "Invalid category",
        },
-        { status: 400 }
+        { status: 400 },
      );
    }

@@ -227,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(
@@ -236,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/file/route.ts
+++ b/src/app/api/mobile/file/route.ts
@@ -2,14 +2,50 @@ import { funGetDirectoryNameByValue } from "@/app_modules/_global/fun/get";
 import { NextResponse } from "next/server";

 export async function POST(request: Request) {
-  const formData = await request.formData();
-  const dirId = formData.get("dirId");
-
-  const keyOfDirectory = await funGetDirectoryNameByValue({
-    value: dirId as string,
-  });
-
  try {
+    const formData = await request.formData();
+    const dirId = formData.get("dirId");
+    const file = formData.get("file") as File | null;
+
+    // === LOGGING: Request Details ===
+    console.log("=== UPLOAD REQUEST START ===");
+    console.log("dirId:", dirId);
+    console.log("File details:");
+    console.log("  - Name:", file?.name);
+    console.log("  - Type:", file?.type);
+    console.log("  - Size:", file?.size, "bytes");
+    console.log("  - Size (KB):", file ? (file.size / 1024).toFixed(2) : "N/A");
+    console.log("===========================");
+
+    // FIX: Override MIME type jika salah (mobile app kadang kirim image/pdf)
+    let fixedFile = file;
+    if (file) {
+      const fileName = file.name.toLowerCase();
+      const originalType = file.type.toLowerCase();
+      
+      // Jika file PDF tapi type bukan application/pdf, fix it
+      if (fileName.endsWith(".pdf") && originalType !== "application/pdf") {
+        console.log("⚠️ WARNING: PDF file has wrong MIME type:", originalType);
+        console.log("🔧 Overriding to: application/pdf");
+        
+        // Create new File with correct MIME type
+        const buffer = await file.arrayBuffer();
+        fixedFile = new File([buffer], file.name, {
+          type: "application/pdf",
+          lastModified: file.lastModified,
+        });
+        
+        // Rebuild formData with fixed file
+        formData.set("file", fixedFile);
+      }
+    }
+
+    const keyOfDirectory = await funGetDirectoryNameByValue({
+      value: dirId as string,
+    });
+
+    console.log("Directory key:", keyOfDirectory);
+
    const res = await fetch("https://wibu-storage.wibudev.com/api/upload", {
      method: "POST",
      body: formData,
@@ -18,9 +54,70 @@ export async function POST(request: Request) {
      },
    });

-    const dataRes = await res.json();
+    // === LOGGING: Response Details ===
+    console.log("=== EXTERNAL STORAGE RESPONSE ===");
+    console.log("Status:", res.status);
+    console.log("Status Text:", res.statusText);
+    console.log("Content-Type:", res.headers.get("content-type"));
+    console.log("=================================");
+
+    // Cek content-type sebelum parse JSON
+    const contentType = res.headers.get("content-type") || "";
+    let dataRes;
+
+    // Try parse JSON untuk semua response (beberapa server salah set content-type)
+    try {
+      const rawResponse = await res.text();
+      
+      // Coba parse sebagai JSON
+      try {
+        dataRes = JSON.parse(rawResponse);
+        console.log("✅ Successfully parsed response as JSON");
+      } catch {
+        // Bukan JSON - gunakan raw text
+        console.log("⚠️ Response is not JSON, using raw text");
+        
+        if (res.ok) {
+          // Success tapi bukan JSON - return success response
+          return NextResponse.json(
+            { 
+              success: true,
+              message: "Success upload file " + keyOfDirectory,
+            },
+            { status: 200 }
+          );
+        } else {
+          return NextResponse.json(
+            { 
+              success: false, 
+              message: "Upload failed",
+              error: rawResponse.substring(0, 500),
+              fileDetails: {
+                name: file?.name,
+                type: file?.type,
+                size: file?.size,
+              }
+            },
+            { status: res.status || 400 }
+          );
+        }
+      }
+    } catch (readError) {
+      console.log("❌ Failed to read response body");
+      console.log("Read error:", (readError as Error).message);
+      
+      return NextResponse.json(
+        { 
+          success: false, 
+          message: "Failed to read response",
+          reason: (readError as Error).message,
+        },
+        { status: 500 }
+      );
+    }

    if (res.ok) {
+      console.log("✅ Upload SUCCESS");
      return NextResponse.json(
        {
          success: true,
@@ -30,20 +127,34 @@ export async function POST(request: Request) {
        { status: 200 }
      );
    } else {
-      const errorText = await res.text();
-      console.log(`Failed upload ${keyOfDirectory}: ${errorText}`);
+      console.log("❌ Upload FAILED");
+      console.log("Response:", dataRes);
+      
+      const errorMessage = dataRes.message || dataRes.error || JSON.stringify(dataRes);
      return NextResponse.json(
-        { success: false, message: errorText },
-        { status: 400 }
+        { 
+          success: false, 
+          message: errorMessage || "Upload failed",
+          fileDetails: {
+            name: file?.name,
+            type: file?.type,
+            size: file?.size,
+          }
+        },
+        { status: res.status || 400 }
      );
    }
  } catch (error) {
-    console.log("Error upload >>", (error as Error).message || error);
+    console.log("=== CATCH ERROR ===");
+    console.log("Error:", (error as Error).message);
+    console.log("Stack:", (error as Error).stack);
+    console.log("===================");
+    
    return NextResponse.json(
      {
        success: false,
        message: "Failed upload file",
-        reason: (error as Error).message || error,
+        reason: (error as Error).message || "Unknown error",
      },
      { status: 500 }
    );
--- 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/forum/[id]/preview-report-posting/route.ts
+++ b/src/app/api/mobile/forum/[id]/preview-report-posting/route.ts
@@ -1,3 +1,4 @@
+import { prisma } from "@/lib";
 import { NextResponse } from "next/server";

 export async function GET(
--- a/src/app/api/mobile/forum/route.ts
+++ b/src/app/api/mobile/forum/route.ts
@@ -2,7 +2,10 @@ import _ from "lodash";
 import { NextResponse } from "next/server";
 import prisma from "@/lib/prisma";
 import { sendNotificationMobileToManyUser } from "@/lib/mobile/notification/send-notification";
-import { NotificationMobileBodyType, NotificationMobileTitleType } from "../../../../../types/type-mobile-notification";
+import {
+  NotificationMobileBodyType,
+  NotificationMobileTitleType,
+} from "../../../../../types/type-mobile-notification";
 import { routeUserMobile } from "@/lib/mobile/route-page-mobile";

 export { POST, GET };
@@ -72,15 +75,9 @@ async function GET(request: Request) {
  const search = searchParams.get("search");
  const category = searchParams.get("category");
  const page = searchParams.get("page");
-  const takeData = 5;
+  const takeData = 10;
  const skipData = (Number(page) - 1) * takeData;

-  // console.log("authorId", authorId);
-  // console.log("userLoginId", userLoginId);
-  // console.log("search", search);
-  // console.log("category", category);
-  console.log("page", page);
-
  try {
    if (category === "beranda") {
      const blockUserId = await prisma.blockedUser
--- 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/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 }
    );
  }
-  // Removed prisma.$disconnect() from here to prevent connection pool exhaustion
-  // Prisma connections are handled globally and shouldn't be disconnected on each request
 }
--- 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/zCoba/home/page.tsx
+++ b/src/app/zCoba/home/page.tsx
@@ -1,10 +0,0 @@
-import ClientLayout from "./v2_coba_tamplate";
-import ViewV2 from "./v2_view";
-
-export default async function Page() {
-  return (
-    <>
-      <ViewV2 />
-    </>
-  );
-}
--- a/src/app/zCoba/home/test_children.tsx
+++ b/src/app/zCoba/home/test_children.tsx
@@ -1,127 +0,0 @@
-"use client";
-
-import { AccentColor, MainColor } from "@/app_modules/_global/color";
-import {
-    listMenuHomeBody,
-    menuHomeJob,
-} from "@/app_modules/home/component/list_menu_home";
-import {
-    ActionIcon,
-    Box,
-    Group,
-    Image,
-    Paper,
-    SimpleGrid,
-    Stack,
-    Text
-} from "@mantine/core";
-import { IconUserSearch } from "@tabler/icons-react";
-
-export function Test_Children() {
-  return (
-    <>
-      <Box>
-        <Image
-          height={140}
-          fit={"cover"}
-          alt="logo"
-          src={"/aset/home/home-hipmi-new.png"}
-          styles={{
-            imageWrapper: {
-              border: `2px solid ${AccentColor.blue}`,
-              borderRadius: "10px 10px 10px 10px",
-            },
-            image: {
-              borderRadius: "8px 8px 8px 8px",
-            },
-          }}
-        />
-
-        {Array.from(new Array(2)).map((e, i) => (
-          <Stack my={"sm"} key={i}>
-            <SimpleGrid cols={2} spacing="md">
-              {listMenuHomeBody.map((e, i) => (
-                <Paper
-                  key={e.id}
-                  h={150}
-                  bg={MainColor.darkblue}
-                  style={{
-                    borderRadius: "10px 10px 10px 10px",
-                    border: `2px solid ${AccentColor.blue}`,
-                  }}
-                  onClick={() => {}}
-                >
-                  <Stack align="center" justify="center" h={"100%"}>
-                    <ActionIcon
-                      size={50}
-                      variant="transparent"
-                      c={e.link == "" ? "gray.3" : MainColor.white}
-                    >
-                      {e.icon}
-                    </ActionIcon>
-                    <Text
-                      c={e.link == "" ? "gray.3" : MainColor.white}
-                      fz={"xs"}
-                    >
-                      {e.name}
-                    </Text>
-                  </Stack>
-                </Paper>
-              ))}
-            </SimpleGrid>
-
-            {/* Job View */}
-            <Paper
-              p={"md"}
-              w={"100%"}
-              bg={MainColor.darkblue}
-              style={{
-                borderRadius: "10px 10px 10px 10px",
-                border: `2px solid ${AccentColor.blue}`,
-              }}
-            >
-              <Stack onClick={() => {}}>
-                <Group>
-                  <ActionIcon
-                    variant="transparent"
-                    size={40}
-                    c={menuHomeJob.link == "" ? "gray.3" : MainColor.white}
-                  >
-                    {menuHomeJob.icon}
-                  </ActionIcon>
-                  <Text c={menuHomeJob.link == "" ? "gray.3" : MainColor.white}>
-                    {menuHomeJob.name}
-                  </Text>
-                </Group>
-                <SimpleGrid cols={2} spacing="md">
-                  {Array.from({ length: 2 }).map((e, i) => (
-                    <Stack key={i}>
-                      <Group spacing={"xs"}>
-                        <Stack h={"100%"} align="center" justify="flex-start">
-                          <IconUserSearch size={20} color={MainColor.white} />
-                        </Stack>
-                        <Stack spacing={0} w={"60%"}>
-                          <Text
-                            lineClamp={1}
-                            fz={"sm"}
-                            c={MainColor.yellow}
-                            fw={"bold"}
-                          >
-                            nama {i}
-                          </Text>
-                          <Text fz={"sm"} c={MainColor.white} lineClamp={2}>
-                            judulnya {i}
-                          </Text>
-                        </Stack>
-                      </Group>
-                    </Stack>
-                  ))}
-                </SimpleGrid>
-              </Stack>
-            </Paper>
-          </Stack>
-        ))}
-      </Box>
-    </>
-  );
-}
--- a/src/app/zCoba/home/test_footer.tsx
+++ b/src/app/zCoba/home/test_footer.tsx
@@ -1,75 +0,0 @@
-"use client"
-
-import { MainColor } from "@/app_modules/_global/color";
-import { listMenuHomeFooter } from "@/app_modules/home";
-import {
-    ActionIcon,
-    Box,
-    Center,
-    SimpleGrid,
-    Stack,
-    Text,
-} from "@mantine/core";
-import { IconUserCircle } from "@tabler/icons-react";
-import { useRouter } from "next/navigation";
-
-export default function Test_FooterHome() {
-  const router = useRouter();
-
-  return (
-    <Box
-      style={{
-        zIndex: 99,
-        borderRadius: "20px 20px 0px 0px",
-      }}
-      w={"100%"}
-      bottom={0}
-      h={"9vh"}
-    >
-      <SimpleGrid cols={listMenuHomeFooter.length + 1}>
-        {listMenuHomeFooter.map((e) => (
-          <Center h={"9vh"} key={e.id}>
-            <Stack
-              align="center"
-              spacing={0}
-              onClick={() => {
-               console.log("test")
-              }}
-            >
-              <ActionIcon
-                radius={"xl"}
-                c={e.link === "" ? "gray" : MainColor.white}
-                variant="transparent"
-              >
-                {e.icon}
-              </ActionIcon>
-              <Text
-                lineClamp={1}
-                c={e.link === "" ? "gray" : MainColor.white}
-                fz={12}
-              >
-                {e.name}
-              </Text>
-            </Stack>
-          </Center>
-        ))}
-
-        <Center h={"9vh"}>
-          <Stack align="center" spacing={2}>
-            <ActionIcon
-              variant={"transparent"}
-              onClick={() =>
-                console.log("test")
-              }
-            >
-              <IconUserCircle color="white" />
-            </ActionIcon>
-            <Text fz={10} c={MainColor.white}>
-              Profile
-            </Text>
-          </Stack>
-        </Center>
-      </SimpleGrid>
-    </Box>
-  );
-}
--- a/src/app/zCoba/home/test_header.tsx
+++ b/src/app/zCoba/home/test_header.tsx
@@ -1,130 +0,0 @@
-"use client";
-
-import { AccentColor, MainColor } from "@/app_modules/_global/color";
-import {
-  Header,
-  Group,
-  ActionIcon,
-  Text,
-  Title,
-  Box,
-  Loader,
-} from "@mantine/core";
-import { IconArrowLeft, IconChevronLeft } from "@tabler/icons-react";
-import { useRouter } from "next/navigation";
-import React, { useState } from "react";
-
-
-export default function Test_LayoutHeaderTamplate({
-  title,
-  posotion,
-  // left button
-  hideButtonLeft,
-  iconLeft,
-  routerLeft,
-  customButtonLeft,
-  // right button
-  iconRight,
-  routerRight,
-  customButtonRight,
-  backgroundColor,
-}: {
-  title: string;
-  posotion?: any;
-  // left button
-  hideButtonLeft?: boolean;
-  iconLeft?: any;
-  routerLeft?: any;
-  customButtonLeft?: React.ReactNode;
-  // right button
-  iconRight?: any;
-  routerRight?: any;
-  customButtonRight?: React.ReactNode;
-  backgroundColor?: string;
-}) {
-  const router = useRouter();
-  const [isLoading, setIsLoading] = useState(false);
-  const [isRightLoading, setRightLoading] = useState(false);
-
-  return (
-    <>
-      <Box
-        h={"8vh"}
-        // w={"100%"}
-        // pos={"sticky"}
-        // top={0}
-        // style={{
-        //   zIndex: 10,
-        // }}
-        sx={{
-          borderStyle: "none",
-        }}
-        bg={backgroundColor ? backgroundColor : MainColor.darkblue}
-      >
-        <Group h={"100%"} position={posotion ? posotion : "apart"} px={"md"}>
-          {hideButtonLeft ? (
-            <ActionIcon disabled variant="transparent"></ActionIcon>
-          ) : customButtonLeft ? (
-            customButtonLeft
-          ) : (
-            <ActionIcon
-              c={MainColor.white}
-              variant="transparent"
-              radius={"xl"}
-              onClick={() => {
-                setIsLoading(true);
-                routerLeft === undefined
-                  ? router.back()
-                  : router.push(routerLeft, { scroll: false });
-              }}
-            >
-              {/* PAKE LOADING SAAT KLIK BACK */}
-              {/* {isLoading ? (
-                <Loader color={AccentColor.yellow} size={20} />
-              ) : iconLeft ? (
-                iconLeft
-              ) : (
-                <IconChevronLeft />
-              )} */}
-              
-
-              {/* GA PAKE LOADING SAAT KLIK BACK */}
-              {iconLeft ? (
-                iconLeft
-              ) : (
-                <IconChevronLeft />
-              )}
-            </ActionIcon>
-          )}
-
-          <Title order={5} c={MainColor.yellow}>
-            {title}
-          </Title>
-
-          {customButtonRight ? (
-            customButtonRight
-          ) : iconRight === undefined ? (
-            <ActionIcon disabled variant="transparent"></ActionIcon>
-          ) : routerRight === undefined ? (
-            <Box>{iconRight}</Box>
-          ) : (
-            <ActionIcon
-              c={"white"}
-              variant="transparent"
-              onClick={() => {
-                setRightLoading(true);
-                router.push(routerRight);
-              }}
-            >
-              {isRightLoading ? (
-                <Loader color={AccentColor.yellow} size={20} />
-              ) : (
-                iconRight
-              )}
-            </ActionIcon>
-          )}
-        </Group>
-      </Box>
-    </>
-  );
-}
--- a/src/app/zCoba/home/test_tamplate.tsx
+++ b/src/app/zCoba/home/test_tamplate.tsx
@@ -1,127 +0,0 @@
-"use client";
-
-import { AccentColor, MainColor } from "@/app_modules/_global/color";
-import {
-  BackgroundImage,
-  Box,
-  Container,
-  rem,
-  ScrollArea,
-} from "@mantine/core";
-
-export function Test_Tamplate({
-  children,
-  header,
-  footer,
-}: {
-  children: React.ReactNode;
-  header: React.ReactNode;
-  footer?: React.ReactNode;
-}) {
-  return (
-    <>
-      <Box
-        w={"100%"}
-        h={"100%"}
-        style={{
-          backgroundColor: MainColor.black,
-        }}
-      >
-        <Container mih={"100vh"} p={0} size={rem(500)} bg={MainColor.green}>
-          {/* <BackgroundImage
-            src={"/aset/global/main_background.png"}
-            h={"100vh"}
-            // style={{ position: "relative" }}
-          > */}
-            <TestHeader header={header} />
-
-            <TestChildren footer={footer}>{children}</TestChildren>
-
-            <TestFooter footer={footer} />
-          {/* </BackgroundImage> */}
-        </Container>
-      </Box>
-    </>
-  );
-}
-
-export function TestHeader({ header }: { header: React.ReactNode }) {
-  return (
-    <>
-      <Box
-        h={"8vh"}
-        style={{
-          zIndex: 10,
-          alignContent: "center",
-        }}
-        w={"100%"}
-        pos={"sticky"}
-        top={0}
-      >
-        {header}
-      </Box>
-    </>
-  );
-}
-
-export function TestChildren({
-  children,
-  footer,
-}: {
-  children: React.ReactNode;
-  footer: React.ReactNode;
-}) {
-  return (
-    <>
-      <Box
-        style={{ zIndex: 0 }}
-        px={"md"}
-        h={footer ? "82vh" : "92vh"}
-      >
-        {children}
-      </Box>
-    </>
-  );
-}
-
-function TestFooter({ footer }: { footer: React.ReactNode }) {
-  return (
-    <>
-      {footer ? (
-        <Box
-          // w dihilangkan kalau relative
-          w={"100%"}
-          style={{
-            // position: "relative",
-            position: "fixed",
-            bottom: 0,
-            height: "10vh",
-            zIndex: 10,
-            borderRadius: "20px 20px 0px 0px",
-            borderTop: `2px solid ${AccentColor.blue}`,
-            borderRight: `1px solid ${AccentColor.blue}`,
-            borderLeft: `1px solid ${AccentColor.blue}`,
-            // maxWidth dihilangkan kalau relative
-            maxWidth: rem(500),
-          }}
-          bg={AccentColor.darkblue}
-        >
-          <Box
-            h={"100%"}
-            // maw dihilangkan kalau relative
-            maw={rem(500)}
-            style={{
-              borderRadius: "20px 20px 0px 0px",
-              width: "100%",
-            }}
-            // pos={"absolute"}
-          >
-            {footer}
-          </Box>
-        </Box>
-      ) : (
-        ""
-      )}
-    </>
-  );
-}
--- a/src/app/zCoba/home/v2_children.tsx
+++ b/src/app/zCoba/home/v2_children.tsx
@@ -1,26 +0,0 @@
-"use client";
-
-import { Box, ScrollArea } from "@mantine/core";
-
-export function V2_Children({
-  children,
-  height,
-}: {
-  children: React.ReactNode;
-  height?: number;
-}) {
-  return (
-    <>
-      <Box
-        style={{ zIndex: 0 }}
-        px={"md"}
-        h={height ? "82vh" : "92vh"}
-        pos={"static"}
-      >
-          {children}
-        {/* <ScrollArea h={"100%"} px={"md"} bg={"cyan"}>
-        </ScrollArea> */}
-      </Box>
-    </>
-  );
-}
--- a/src/app/zCoba/home/v2_coba_tamplate.tsx
+++ b/src/app/zCoba/home/v2_coba_tamplate.tsx
@@ -1,159 +0,0 @@
-"use client";
-
-import { AccentColor, MainColor } from "@/app_modules/_global/color";
-import {
-  ActionIcon,
-  BackgroundImage, // Import BackgroundImage dari Mantine
-  Box,
-  Button,
-  Container,
-  Group,
-  Text,
-  Title,
-} from "@mantine/core";
-import { useDisclosure, useShallowEffect } from "@mantine/hooks";
-import { createStyles } from "@mantine/styles";
-import { IconBell, IconSearch } from "@tabler/icons-react";
-import { ReactNode, useEffect, useState } from "react";
-
-// Styling langsung didefinisikan di dalam komponen
-const useStyles = createStyles((theme) => ({
-  pageContainer: {
-    display: "flex",
-    flexDirection: "column",
-    minHeight: "100dvh", // dynamic viewport height untuk mobile
-    width: "100%",
-    maxWidth: "500px", // Batasi lebar maksimum
-    margin: "0 auto", // Pusatkan layout
-    boxShadow: "0 0 10px rgba(0, 0, 0, 0.1)", // Tambahkan shadow untuk efek mobile-like
-    backgroundColor: MainColor.darkblue, // Warna latar belakang fallback
-
-    [`@media (max-width: 768px)`]: {
-      maxWidth: "100%", // Pada layar mobile, gunakan lebar penuh
-      boxShadow: "none", // Hilangkan shadow pada mobile
-    },
-  },
-
-  header: {
-    position: "sticky",
-    top: 0,
-    width: "100%",
-    maxWidth: "500px", // Batasi lebar header sesuai container
-    margin: "0 auto", // Pusatkan header
-    backgroundColor: MainColor.darkblue,
-    boxShadow: "0 1px 3px rgba(0, 0, 0, 0.1)",
-    zIndex: 1000, // Pastikan z-index tinggi
-    transition: "all 0.3s ease",
-    color: MainColor.yellow,
-  },
-
-  scrolled: {
-    boxShadow: "0 2px 8px rgba(0, 0, 0, 0.15)",
-  },
-
-  headerContainer: {
-    height: "8vh",
-    display: "flex",
-    alignItems: "center",
-    padding: "0 16px", // Padding untuk mobile view
-
-    [`@media (max-width: 768px)`]: {
-      height: "8vh",
-    },
-    borderBottom: `1px solid ${AccentColor.blue}`,
-    borderBottomLeftRadius: "10px",
-    borderBottomRightRadius: "10px",
-  },
-
-  content: {
-    flex: 1,
-    width: "100%",
-    overflowY: "auto", // Izinkan scrolling pada konten
-    paddingBottom: "15vh", // Sesuaikan dengan tinggi footer
-  },
-
-  footer: {
-    width: "100%",
-    backgroundColor: MainColor.darkblue,
-    borderTop: `1px solid ${AccentColor.blue}`,
-    height: "10vh", // Tinggi footer
-    display: "flex",
-    alignItems: "center",
-    justifyContent: "center",
-    position: "fixed",
-    bottom: 0,
-    left: "50%", // Pusatkan footer
-    transform: "translateX(-50%)", // Pusatkan footer
-    maxWidth: "500px", // Batasi lebar footer
-    color: MainColor.white,
-    borderTopLeftRadius: "10px",
-    borderTopRightRadius: "10px",
-  },
-}));
-
-interface ClientLayoutProps {
-  children: ReactNode;
-}
-
-export default function ClientLayout({ children }: ClientLayoutProps) {
-  const [scrolled, setScrolled] = useState<boolean>(false);
-  const { classes, cx } = useStyles();
-
-  // Effect untuk mendeteksi scroll
-  useEffect(() => {
-    function handleScroll() {
-      if (window.scrollY > 10) {
-        setScrolled(true);
-      } else {
-        setScrolled(false);
-      }
-    }
-
-    window.addEventListener("scroll", handleScroll);
-    return () => window.removeEventListener("scroll", handleScroll);
-  }, []);
-  
-  return (
-    <Box className={classes.pageContainer}>
-      {/* Header - tetap di atas */}
-      <Box
-        className={cx(classes.header, { [classes.scrolled]: scrolled })}
-        component="header"
-      >
-        <Container size="xl" className={classes.headerContainer}>
-          <Group position="apart" w={"100%"}>
-            <ActionIcon>
-              <IconSearch />
-            </ActionIcon>
-            <Title order={4}>Home Test</Title>
-            <ActionIcon>
-              <IconBell />
-            </ActionIcon>
-          </Group>
-        </Container>
-      </Box>
-
-      {/* Konten utama - bisa di-scroll */}
-      <Box className={classes.content}>
-        <Container>{children}</Container>
-      </Box>
-
-      {/* Footer - tetap di bawah */}
-      <Box className={classes.footer} component="footer">
-        <Container size="xl">
-          <Group position="apart" py="md">
-            <Text size="sm">© 2025 Nama Perusahaan</Text>
-            <Group spacing="xs">
-              <Button variant="subtle" size="xs">
-                Privasi
-              </Button>
-              <Button variant="subtle" size="xs">
-                Syarat
-              </Button>
-            </Group>
-          </Group>
-        </Container>
-      </Box>
-    </Box>
-  );
-}
--- a/src/app/zCoba/home/v2_header.tsx
+++ b/src/app/zCoba/home/v2_header.tsx
@@ -1,42 +0,0 @@
-"use client";
-
-import { MainColor } from "@/app_modules/_global/color";
-import { ActionIcon, Box, Group, Title } from "@mantine/core";
-import { IconBell, IconChevronLeft } from "@tabler/icons-react";
-
-export function V2_Header() {
-  return (
-    <>
-      <Box
-        h={"8vh"}
-        style={{
-          zIndex: 10,
-          alignContent: "center",
-        }}
-        w={"100%"}
-        pos={"sticky"}
-        top={0}
-        bg={MainColor.darkblue}
-      >
-        <Group h={"100%"} position={"apart"} px={"md"}>
-          <ActionIcon
-            c={MainColor.white}
-            variant="transparent"
-            radius={"xl"}
-            onClick={() => {}}
-          >
-            <IconChevronLeft />
-          </ActionIcon>
-
-          <Title order={5} c={MainColor.yellow}>
-            Test Tamplate
-          </Title>
-
-          <ActionIcon c={"white"} variant="transparent" onClick={() => {}}>
-            <IconBell />
-          </ActionIcon>
-        </Group>
-      </Box>
-    </>
-  );
-}
--- a/src/app/zCoba/home/v2_home_view.tsx
+++ b/src/app/zCoba/home/v2_home_view.tsx
@@ -1,127 +0,0 @@
-"use client";
-
-import { AccentColor, MainColor } from "@/app_modules/_global/color";
-import {
-  listMenuHomeBody,
-  menuHomeJob,
-} from "@/app_modules/home/component/list_menu_home";
-import {
-  Box,
-  Stack,
-  SimpleGrid,
-  Paper,
-  ActionIcon,
-  Group,
-  Image,
-  Text,
-} from "@mantine/core";
-import { IconUserSearch } from "@tabler/icons-react";
-
-export function V2_HomeView() {
-  return (
-    <>
-      <Box>
-        <Image
-          height={140}
-          fit={"cover"}
-          alt="logo"
-          src={"/aset/home/home-hipmi-new.png"}
-          styles={{
-            imageWrapper: {
-              border: `2px solid ${AccentColor.blue}`,
-              borderRadius: "10px 10px 10px 10px",
-            },
-            image: {
-              borderRadius: "8px 8px 8px 8px",
-            },
-          }}
-        />
-
-        {Array.from(new Array(2)).map((e, i) => (
-          <Stack my={"sm"} key={i}>
-            <SimpleGrid cols={2} spacing="md">
-              {listMenuHomeBody.map((e, i) => (
-                <Paper
-                  key={e.id}
-                  h={150}
-                  bg={MainColor.darkblue}
-                  style={{
-                    borderRadius: "10px 10px 10px 10px",
-                    border: `2px solid ${AccentColor.blue}`,
-                  }}
-                  onClick={() => {}}
-                >
-                  <Stack align="center" justify="center" h={"100%"}>
-                    <ActionIcon
-                      size={50}
-                      variant="transparent"
-                      c={e.link == "" ? "gray.3" : MainColor.white}
-                    >
-                      {e.icon}
-                    </ActionIcon>
-                    <Text
-                      c={e.link == "" ? "gray.3" : MainColor.white}
-                      fz={"xs"}
-                    >
-                      {e.name}
-                    </Text>
-                  </Stack>
-                </Paper>
-              ))}
-            </SimpleGrid>
-
-            {/* Job View */}
-            <Paper
-              p={"md"}
-              w={"100%"}
-              bg={MainColor.darkblue}
-              style={{
-                borderRadius: "10px 10px 10px 10px",
-                border: `2px solid ${AccentColor.blue}`,
-              }}
-            >
-              <Stack onClick={() => {}}>
-                <Group>
-                  <ActionIcon
-                    variant="transparent"
-                    size={40}
-                    c={menuHomeJob.link == "" ? "gray.3" : MainColor.white}
-                  >
-                    {menuHomeJob.icon}
-                  </ActionIcon>
-                  <Text c={menuHomeJob.link == "" ? "gray.3" : MainColor.white}>
-                    {menuHomeJob.name}
-                  </Text>
-                </Group>
-                <SimpleGrid cols={2} spacing="md">
-                  {Array.from({ length: 2 }).map((e, i) => (
-                    <Stack key={i}>
-                      <Group spacing={"xs"}>
-                        <Stack h={"100%"} align="center" justify="flex-start">
-                          <IconUserSearch size={20} color={MainColor.white} />
-                        </Stack>
-                        <Stack spacing={0} w={"60%"}>
-                          <Text
-                            lineClamp={1}
-                            fz={"sm"}
-                            c={MainColor.yellow}
-                            fw={"bold"}
-                          >
-                            nama {i}
-                          </Text>
-                          <Text fz={"sm"} c={MainColor.white} lineClamp={2}>
-                            judulnya {i}
-                          </Text>
-                        </Stack>
-                      </Group>
-                    </Stack>
-                  ))}
-                </SimpleGrid>
-              </Stack>
-            </Paper>
-          </Stack>
-        ))}
-      </Box>
-    </>
-  );
-}
--- a/src/app/zCoba/home/v2_view.tsx
+++ b/src/app/zCoba/home/v2_view.tsx
@@ -1,117 +0,0 @@
-// app/page.tsx
-"use client";
-
-import {
-  Badge,
-  Box,
-  Button,
-  Card,
-  Group,
-  Image,
-  Paper,
-  Stack,
-  Text,
-  Title,
-} from "@mantine/core";
-import ClientLayout from "./v2_coba_tamplate";
-
-export default function ViewV2() {
-  return (
-    <ClientLayout>
-      <Stack spacing="xl" c={"white"}>
-        <Title order={1} ta="center" my="lg" size="h2">
-          Selamat Datang
-        </Title>
-
-        <Text size="md" ta="center" mb="lg">
-          Aplikasi dengan layout yang dioptimalkan untuk tampilan mobile
-        </Text>
-
-        <Stack spacing="md">
-          {[...Array(5)].map((_, index) => (
-            <Card
-              opacity={0.3}
-              key={index}
-              shadow="sm"
-              padding="md"
-              radius="md"
-              withBorder
-            >
-              <Card.Section>
-                <Image
-                  src={`/api/placeholder/400/200`}
-                  height={160}
-                  alt={`Produk ${index + 1}`}
-                />
-              </Card.Section>
-
-              <Group position="apart" mt="md" mb="xs">
-                <Text fw={500}>Produk {index + 1}</Text>
-                <Badge color="blue" variant="light">
-                  Baru
-                </Badge>
-              </Group>
-
-              <Text size="sm" color="dimmed" lineClamp={2}>
-                Deskripsi produk yang singkat dan padat untuk tampilan mobile.
-                Fokus pada informasi penting saja.
-              </Text>
-
-              <Button
-                variant="light"
-                color="blue"
-                fullWidth
-                mt="md"
-                radius="md"
-              >
-                Lihat Detail
-              </Button>
-            </Card>
-          ))}
-        </Stack>
-
-        <Stack spacing="md">
-          {[...Array(5)].map((_, index) => (
-            <Box key={index} mb="xl" h="100px" bg={"gray"}>
-              Test
-            </Box>
-          ))}
-        </Stack>
-
-        {[...Array(5)].map((_, index) => (
-          <div
-            key={index}
-            style={{
-              backgroundColor: "gray",
-              marginBottom: "15px",
-              height: "100px",
-            }}
-          >
-            Test
-          </div>
-        ))}
-
-        <Paper
-          shadow="md"
-          p="md"
-          withBorder
-          radius="md"
-          style={{
-            backgroundImage: "linear-gradient(45deg, #228be6, #4c6ef5)",
-            color: "white",
-          }}
-        >
-          <Text fw={700} size="lg" ta="center">
-            Promo Spesial
-          </Text>
-          <Text ta="center" my="sm">
-            Dapatkan diskon 20% untuk pembelian pertama
-          </Text>
-          <Button variant="white" color="blue" fullWidth>
-            Klaim Sekarang
-          </Button>
-        </Paper>
-      </Stack>
-    </ClientLayout>
-  );
-}
--- a/src/app/zCoba/page.tsx
+++ b/src/app/zCoba/page.tsx
@@ -1,60 +0,0 @@
-"use client";
-
-import { MainColor } from "@/app_modules/_global/color";
-import {
-  Avatar,
-  Button,
-  Center,
-  FileButton,
-  Paper,
-  Stack,
-} from "@mantine/core";
-import { IconCamera } from "@tabler/icons-react";
-import { useState } from "react";
-import { DIRECTORY_ID } from "../../lib";
-
-export default function Page() {
-  const [data, setData] = useState({
-    name: "bagas",
-    hobi: [
-      {
-        id: "1",
-        name: "mancing",
-      },
-      {
-        id: "2",
-        name: "game",
-      },
-    ],
-  });
-
-  return (
-    <>
-      <Stack align="center" justify="center" h={"100vh"}>
-        <pre>{JSON.stringify(data, null, 2)}</pre>
-
-        <Button
-          onClick={() => {
-            const newData = [
-              {
-                id: "1",
-                name: "sepedah",
-              },
-              {
-                id: "2",
-                name: "berenang",
-              },
-            ];
-
-            setData({
-              ...data,
-              hobi: newData,
-            });
-          }}
-        >
-          Ganti
-        </Button>
-      </Stack>
-    </>
-  );
-}
--- a/src/app/zCoba/pdf/_view.tsx
+++ b/src/app/zCoba/pdf/_view.tsx
@@ -1,46 +0,0 @@
-"use client";
-
-import { Button } from "@mantine/core";
-
-interface DownloadButtonProps {
-  fileUrl: string;
-  fileName: string;
-}
-
-export default function Coba() {
-  const fileUrl =
-    "https://wibu-storage.wibudev.com/api/pdf-to-image?url=https://wibu-storage.wibudev.com/api/files/cm7liew81000t3y8ax1v6yo02";
-  const fileName = "example.pdf"; // Nama file yang akan diunduh
-
-  return (
-    <div>
-      <h1>Download File Example</h1>
-      <DownloadButton fileUrl={fileUrl} fileName={fileName} />
-    </div>
-  );
-}
-
-export function DownloadButton({ fileUrl, fileName }: DownloadButtonProps) {
-  const handleDownloadFromAPI = async () => {
-    try {
-      const response = await fetch("https://wibu-storage.wibudev.com/api/files/cm7liew81000t3y8ax1v6yo02")
-      const blob = await response.blob(); // Konversi respons ke Blob
-      const url = window.URL.createObjectURL(blob); // Buat URL untuk Blob
-      const link = document.createElement("a");
-      link.href = url;
-      link.download = "generated-file.pdf"; // Nama file yang akan diunduh
-      document.body.appendChild(link);
-      link.click();
-      document.body.removeChild(link);
-      window.URL.revokeObjectURL(url); // Bersihkan URL
-    } catch (error) {
-      console.error("Error downloading file:", error);
-    }
-  };
-
-  return (
-    <Button onClick={handleDownloadFromAPI} variant="outline" color="blue">
-      Download File
-    </Button>
-  );
-}
--- a/src/app/zCoba/pdf/page.tsx
+++ b/src/app/zCoba/pdf/page.tsx
@@ -1,13 +0,0 @@
-import Coba from "./_view";
-
-
-
-async function Page() {
-  return (
-    <>
-      <Coba />
-    </>
-  );
-}
-
-export default Page;
--- a/src/app/zCoba/scroll/_comp/ui_scroll.tsx
+++ b/src/app/zCoba/scroll/_comp/ui_scroll.tsx
@@ -1,79 +0,0 @@
-/* eslint-disable react-hooks/exhaustive-deps */
-import React, { useState, useEffect } from "react";
-
-// Tipe untuk data item (sesuaikan sesuai API kamu)
-interface Item {
-  id: number;
-  name: string;
-}
-
-// Props komponen
-interface InfiniteScrollProps<T> {
-  fetchFunction: (page: number) => Promise<T[]>;
-  renderItem: (item: T) => React.ReactNode;
-  itemsPerPage?: number;
-  threshold?: number; // Jarak dari bawah halaman untuk memicu load
-}
-
-const InfiniteScroll = <T,>({
-  fetchFunction,
-  renderItem,
-  itemsPerPage = 10,
-  threshold = 50,
-}: InfiniteScrollProps<T>) => {
-  const [items, setItems] = useState<T[]>([]);
-  const [hasMore, setHasMore] = useState(true);
-  const [page, setPage] = useState(1);
-
-  // Load data awal
-  useEffect(() => {
-    const loadInitialData = async () => {
-      const data = await fetchFunction(page);
-      if (data.length === 0) setHasMore(false);
-      setItems(data);
-    };
-
-    loadInitialData();
-  }, [fetchFunction, page]);
-
-  // Handle scroll event
-  useEffect(() => {
-    const handleScroll = () => {
-      const isBottom =
-        window.innerHeight + window.scrollY >=
-        document.body.offsetHeight - threshold;
-
-      if (isBottom && hasMore) {
-        loadMoreItems();
-      }
-    };
-
-    window.addEventListener("scroll", handleScroll);
-    return () => window.removeEventListener("scroll", handleScroll);
-  }, [hasMore, threshold]);
-
-  const loadMoreItems = async () => {
-    const nextPage = page + 1;
-    const newItems = await fetchFunction(nextPage);
-
-    if (newItems.length === 0) {
-      setHasMore(false);
-    }
-
-    setItems((prev) => [...prev, ...newItems]);
-    setPage(nextPage);
-  };
-
-  return (
-    <div >
-      <ul>
-        {items.map((item, index) => (
-          <li key={index}>{renderItem(item)}</li>
-        ))}
-      </ul>
-      {!hasMore && <p>🎉 Semua data telah dimuat.</p>}
-    </div>
-  );
-};
-
-export default InfiniteScroll;
--- a/src/app/zCoba/scroll/page.tsx
+++ b/src/app/zCoba/scroll/page.tsx
@@ -1,46 +0,0 @@
-"use client"
-
-import React, { useState } from "react";
-import InfiniteScroll from "./_comp/ui_scroll";
-import { apiGetMessageByRoomId } from "@/app_modules/colab/_lib/api_collaboration";
-import { ChatMessage } from "@/app/dev/(user)/colab/_comp/interface";
-
-// Definisikan tipe data
-interface User {
-  id: number;
-  name: string;
-  email: string;
-}
-
-
-
-// Komponen App
-function App() {
-    const [data, setData] = useState<ChatMessage[]>([]);
-  // Simulasi API call
-  const fetchUsers = async (page: number): Promise<ChatMessage[]> => {
-    const response = await apiGetMessageByRoomId({
-      id: "cmb5x31dt0001tl7y7vj26pfy",
-    });
-    setData(response.data);
-    return response.data;
-  };
-
-  return (
-    <div style={{ padding: "20px" }}>
-      <h1>Infinite Scroll with TypeScript</h1>
-      <InfiniteScroll<ChatMessage>
-        fetchFunction={fetchUsers}
-        itemsPerPage={10}
-        threshold={100}
-        renderItem={(item) => (
-          <div style={{ marginBottom: "10px" }}>
-            <strong>{item.User?.Profile?.name}</strong> - {item.message}
-          </div>
-        )}
-      />
-    </div>
-  );
-}
-
-export default App;
--- a/src/app/zCoba/skeleton/page.tsx
+++ b/src/app/zCoba/skeleton/page.tsx
@@ -1,56 +0,0 @@
-"use client";
-
-import { ComponentGlobal_CardStyles } from "@/app_modules/_global/component";
-import {
-  UIGlobal_LayoutHeaderTamplate,
-  UIGlobal_LayoutTamplate,
-} from "@/app_modules/_global/ui";
-import CustomSkeleton from "@/app_modules/components/CustomSkeleton";
-import { Button, Center, Grid, Group, Skeleton, Stack } from "@mantine/core";
-import Link from "next/link";
-
-export default function Voting_ComponentSkeletonViewPuh() {
-  return (
-    <>
-      <UIGlobal_LayoutTamplate
-        header={<UIGlobal_LayoutHeaderTamplate title="Skeleton Maker" />}
-      >
-        <Stack>
-          <CustomSkeleton height={300} width={"100%"} />
-          <Center>
-            <CustomSkeleton height={40} radius={"xl"} width={"50%"} />
-          </Center>
-          <CustomSkeleton height={500} width={"100%"} />
-          <CustomSkeleton height={40} radius={"xl"} width={"100%"} />
-        </Stack>
-
-        {/* <Grid align="center">
-            <Grid.Col span={2}>
-              <CustomSkeleton height={40} width={40} circle />
-            </Grid.Col>
-            <Grid.Col span={4}>
-              <CustomSkeleton height={20} width={"100%"} />
-            </Grid.Col>
-            <Grid.Col span={3} offset={3}>
-              <Group position="right">
-                <CustomSkeleton height={20} width={"50%"} />
-              </Group>
-            </Grid.Col>
-          </Grid>
-
-          <Stack>
-            <CustomSkeleton height={20} width={"100%"} radius={"xl"} />
-            <CustomSkeleton height={20} width={"100%"} radius={"xl"} />
-          </Stack> */}
-
-        {/* <Stack spacing={"xl"} p={"sm"}>
-          {Array.from({ length: 4 }).map((_, i) => (
-            <CustomSkeleton key={i} height={50} width={"100%"} />
-          ))}
-          <CustomSkeleton height={100} width={"100%"} />
-          <CustomSkeleton radius="xl" height={50} width={"100%"} />
-        </Stack> */}
-      </UIGlobal_LayoutTamplate>
-    </>
-  );
-}
--- a/src/app/zCoba/test2/page.tsx
+++ b/src/app/zCoba/test2/page.tsx
@@ -1,47 +0,0 @@
-"use client";
-import { gs_realtimeData, IRealtimeData } from "@/lib/global_state";
-import { Button, Stack } from "@mantine/core";
-import { useShallowEffect } from "@mantine/hooks";
-import { useAtom } from "jotai";
-import { WibuRealtime } from "wibu-pkg";
-import { v4 } from "uuid";
-
-export default function Page() {
-  const [dataRealtime, setDataRealtime] = useAtom(gs_realtimeData);
-
-  useShallowEffect(() => {
-    console.log(
-      dataRealtime?.userId == "user2"
-        ? console.log("")
-        : console.log(dataRealtime)
-    );
-  }, [dataRealtime]);
-
-  async function onSend() {
-    const newData: IRealtimeData = {
-      appId: v4(),
-      status: "Publish",
-      userId: "user2",
-      pesan: "apa kabar",
-      title: "coba",
-      kategoriApp: "INVESTASI",
-    };
-
-    WibuRealtime.setData({
-      type: "notification",
-      pushNotificationTo: "ADMIN",
-    });
-  }
-
-  return (
-    <Stack p={"md"} align="center" justify="center" h={"80vh"}>
-      <Button
-        onClick={() => {
-          onSend();
-        }}
-      >
-        Dari test 2 cuma notif
-      </Button>
-    </Stack>
-  );
-}
--- a/src/app/zCoba/text_editor/page.tsx
+++ b/src/app/zCoba/text_editor/page.tsx
@@ -1,140 +0,0 @@
-"use client";
-
-import { useEditor, EditorContent } from "@tiptap/react";
-import StarterKit from "@tiptap/starter-kit";
-import Image from "@tiptap/extension-image";
-import { useState } from "react";
-import {
-  Box,
-  Button,
-  Group,
-  Image as MantineImage,
-  Stack,
-  Text,
-} from "@mantine/core";
-import Underline from "@tiptap/extension-underline";
-import { MainColor } from "@/app_modules/_global/color";
-
-const listStiker = [
-  {
-    id: 2,
-    name: "stiker2",
-    url: "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQN9AKmsBY4yqdn3GueJJEVPJbfmf853gDL4cN8uc9eqsCTiJ1fzhcpywzVP68NCJEA5NQ&usqp=CAU",
-  },
-  {
-    id: 3,
-    name: "stiker3",
-    url: "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcS2lkV3ZiQ8m-OELSui2JGVy80vnh1cyRUV7NrgFNluPVVs2HUAyCHwCMAKGe2s5jk2sn8&usqp=CAU",
-  },
-  {
-    id: 4,
-    name: "stiker4",
-    url: "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQHy9ZdsPc6dHgVTl5yIGpRJ-KtpTIsXA2_kbfO1Oc-pv_f7CNKGxhO56RjKujE3xCyb9k&usqp=CAU",
-  },
-];
-
-export default function RichTextWithStickers() {
-  const [chat, setChat] = useState<string[]>([]);
-
-  const editor = useEditor({
-    extensions: [
-      StarterKit, // Sudah include Bold, Italic, dll
-      Underline, // Tambahan untuk underline
-      Image,
-    ],
-    content: "",
-  });
-
-  const insertSticker = (url: string) => {
-    editor?.chain().focus().setImage({ src: url }).run();
-  };
-
-  return (
-    <Stack p="md">
-      <Text fw={700}>Tiptap Editor dengan Stiker Inline</Text>
-
-      <Box
-        style={{
-          border: "1px solid #ccc",
-          borderRadius: 4,
-          padding: 8,
-          minHeight: 150,
-          backgroundColor: MainColor.white,
-        }}
-      >
-        <Group spacing="xs" mb="sm">
-          <Button
-            variant="default"
-            onClick={() => editor?.chain().focus().toggleBold().run()}
-          >
-            B
-          </Button>
-          <Button
-            variant="default"
-            onClick={() => editor?.chain().focus().toggleItalic().run()}
-          >
-            I
-          </Button>
-          <Button
-            variant="default"
-            onClick={() => editor?.chain().focus().toggleUnderline().run()}
-          >
-            U
-          </Button>
-        </Group>
-        <EditorContent
-          editor={editor}
-          style={{
-            backgroundColor: "white",
-          }}
-        />
-      </Box>
-
-      <Button
-        mt="sm"
-        onClick={() => {
-          if (editor) {
-            setChat((prev) => [...prev, editor.getHTML()]);
-            editor.commands.clearContent();
-          }
-        }}
-      >
-        Kirim
-      </Button>
-
-      <Group>
-        {listStiker.map((item) => (
-          <Box
-            key={item.id}
-            component="button"
-            onClick={() => insertSticker(item.url)}
-            style={{
-              border: "none",
-              background: "transparent",
-              cursor: "pointer",
-            }}
-          >
-            <MantineImage
-              w={30}
-              h={30}
-              src={item.url}
-              alt={item.name}
-              styles={{
-                image: {
-                  width: 30,
-                  height: 30,
-                },
-              }}
-            />
-          </Box>
-        ))}
-      </Group>
-
-      {/* <Stack mt="lg" p="md" bg="gray.1">
-        {chat.map((item, index) => (
-          <Box key={index} dangerouslySetInnerHTML={{ __html: item }} />
-        ))}
-      </Stack> */}
-    </Stack>
-  );
-}
--- a/src/app/zCoba/text_editor2/page.tsx
+++ b/src/app/zCoba/text_editor2/page.tsx
@@ -1,210 +0,0 @@
-"use client";
-import React, { useState, useEffect } from "react";
-import {
-  Box,
-  Button,
-  Group,
-  Image,
-  Paper,
-  ScrollArea,
-  SimpleGrid,
-  Stack,
-  Text,
-  Tooltip,
-  Modal,
-} from "@mantine/core";
-import { useDisclosure } from "@mantine/hooks";
-import dynamic from "next/dynamic";
-import { MainColor } from "@/app_modules/_global/color";
-import { listStiker } from "@/app_modules/_global/lib/stiker";
-
-// Dynamic import ReactQuill dengan SSR disabled
-const ReactQuill = dynamic(
-  async () => {
-    const { default: RQ } = await import("react-quill");
-    // Tidak perlu import CSS dengan import statement
-    return function comp({ forwardedRef, ...props }: any) {
-      return <RQ ref={forwardedRef} {...props} />;
-    };
-  },
-  { ssr: false, loading: () => <p>Loading Editor...</p> }
-);
-
-
-type ChatItem = {
-  content: string; // HTML content including text and stickers
-};
-
-export default function Page() {
-  const [editorContent, setEditorContent] = useState("");
-  const [chat, setChat] = useState<ChatItem[]>([]);
-  const [opened, { open, close }] = useDisclosure(false);
-  const quillRef = React.useRef<any>(null);
-  const [quillLoaded, setQuillLoaded] = useState(false);
-
-  // Load CSS on client-side only
-  useEffect(() => {
-    // Add Quill CSS via <link> tag
-    const link = document.createElement("link");
-    link.href = "https://cdn.quilljs.com/1.3.6/quill.snow.css";
-    link.rel = "stylesheet";
-    document.head.appendChild(link);
-
-    // Add custom style for stickers inside Quill editor
-    const style = document.createElement("style");
-    style.textContent = `
-    .ql-editor img {
-      max-width: 100px !important;
-      max-height: 100px !important;
-    }
-      .chat-content img {
-      max-width: 70px !important;
-      max-height: 70px !important;
-    }
-  `;
-    document.head.appendChild(style);
-
-    setQuillLoaded(true);
-
-    return () => {
-      // Clean up when component unmounts
-      document.head.removeChild(link);
-      document.head.removeChild(style);
-    };
-  }, []);
-
-  // Custom toolbar options for ReactQuill
-  const modules = {
-    toolbar: [
-      [{ header: [1, 2, false] }],
-      ["bold", "italic", "underline", "strike", "blockquote"],
-      [{ list: "ordered" }, { list: "bullet" }],
-      ["link", "image"],
-      ["clean"],
-    ],
-  };
-
-  const formats = [
-    "header",
-    "bold",
-    "italic",
-    "underline",
-    "strike",
-    "blockquote",
-    "list",
-    "bullet",
-    "link",
-    "image",
-  ];
-
-  const insertSticker = (stickerUrl: string) => {
-    if (!quillRef.current) return;
-
-    const quill = quillRef.current.getEditor();
-    const range = quill.getSelection(true);
-
-    // Custom image insertion with size
-    // Use custom blot or HTML string with size attributes
-    const stickerHtml = `<img src="${stickerUrl}" alt="sticker" style="width: 40px; height: 40px;">`;
-
-    // Insert HTML at cursor position
-    quill.clipboard.dangerouslyPasteHTML(range.index, stickerHtml);
-
-    // Move cursor after inserted sticker
-    quill.setSelection(range.index + 1, 0);
-
-    // Focus back on editor
-    quill.focus();
-
-    // Close sticker modal
-    close();
-  };
-
-  // Function to send message
-  const sendMessage = () => {
-    if (editorContent.trim() !== "") {
-      setChat((prev) => [...prev, { content: editorContent }]);
-      setEditorContent(""); // Clear after sending
-    }
-  };
-
-  return (
-    <Stack p={"md"} spacing="md">
-      <SimpleGrid cols={2}>
-        <Stack bg={"gray.1"} h={560} p="md">
-          <Stack>
-            <ScrollArea>
-              {chat.map((item, index) => (
-                <Box key={index} mb="md">
-                  <div
-                    className="chat-content"
-                    dangerouslySetInnerHTML={{ __html: item.content }}
-                  />
-                </Box>
-              ))}
-            </ScrollArea>
-          </Stack>
-        </Stack>
-        <Paper withBorder p="md">
-          <Text size="sm" weight={500} mb="xs">
-            Chat Preview Data:
-          </Text>
-          <ScrollArea h={520}>
-            <pre style={{ whiteSpace: "pre-wrap" }}>
-              {JSON.stringify(chat, null, 2)}
-            </pre>
-          </ScrollArea>
-        </Paper>
-      </SimpleGrid>
-
-      <Box w="100%" maw={800}>
-        <Box mb="xs" bg={MainColor.white}>
-          {quillLoaded && (
-            <ReactQuill
-              forwardedRef={quillRef}
-              theme="snow"
-              value={editorContent}
-              onChange={setEditorContent}
-              modules={modules}
-              formats={formats}
-              placeholder="Ketik pesan di sini atau tambahkan stiker..."
-              style={{
-                height: 120,
-                marginBottom: 40,
-                backgroundColor: MainColor.white,
-              }}
-            />
-          )}
-        </Box>
-
-        <Group position="apart">
-          <Button variant="outline" onClick={open} color="blue">
-            Tambah Stiker
-          </Button>
-
-          <Button onClick={sendMessage}>Kirim Pesan</Button>
-        </Group>
-      </Box>
-
-      {/* Sticker Modal */}
-      <Modal opened={opened} onClose={close} title="Pilih Stiker" size="md">
-        <SimpleGrid cols={3} spacing="md">
-          {listStiker.map((item) => (
-            <Box key={item.id}>
-              <Tooltip label={item.name}>
-                <Image
-                  src={item.url}
-                  height={100}
-                  width={100}
-                  alt={item.name}
-                  style={{ cursor: "pointer" }}
-                  onClick={() => insertSticker(item.url)}
-                />
-              </Tooltip>
-            </Box>
-          ))}
-        </SimpleGrid>
-      </Modal>
-    </Stack>
-  );
-}
--- a/src/app/zCoba/upload/page.tsx
+++ b/src/app/zCoba/upload/page.tsx
@@ -1,133 +0,0 @@
-"use client";
-
-import { MainColor } from "@/app_modules/_global/color";
-import { ComponentGlobal_BoxUploadImage } from "@/app_modules/_global/component";
-import { funGlobal_UploadToStorage } from "@/app_modules/_global/fun";
-import {
-  UIGlobal_LayoutHeaderTamplate,
-  UIGlobal_LayoutTamplate,
-} from "@/app_modules/_global/ui";
-import { clientLogger } from "@/util/clientLogger";
-import {
-  AspectRatio,
-  Button,
-  Center,
-  FileButton,
-  Image,
-  Stack,
-} from "@mantine/core";
-import { IconImageInPicture, IconUpload } from "@tabler/icons-react";
-import { useState } from "react";
-
-export default function Page() {
-  return (
-    <>
-      <UIGlobal_LayoutTamplate
-        header={<UIGlobal_LayoutHeaderTamplate title="Upload" />}
-      >
-        <Upload />
-      </UIGlobal_LayoutTamplate>
-    </>
-  );
-}
-
-function Upload() {
-  const [file, setFile] = useState<File | null>(null);
-  const [image, setImage] = useState<any | null>(null);
-  const [isLoading, setLoading] = useState(false);
-
-  async function onUpload() {
-    if (!file) return alert("File Kosong");
-    try {
-      setLoading(true);
-      const formData = new FormData();
-      formData.append("file", file as File);
-
-      const uploadPhoto = await funGlobal_UploadToStorage({
-        file: file,
-        dirId: "cm5ohsepe002bq4nlxeejhg7q",
-      });
-
-      if (uploadPhoto.success) {
-        setLoading(false);
-        alert("berhasil upload");
-        console.log("uploadPhoto", uploadPhoto);
-      } else {
-        setLoading(false);
-        console.log("gagal upload", uploadPhoto);
-      }
-    } catch (error) {
-      console.error("Error upload img:", error);
-    }
-  }
-
-  return (
-    <>
-      <Stack>
-        <ComponentGlobal_BoxUploadImage>
-          {image ? (
-            <AspectRatio ratio={1 / 1} mt={5} maw={300} mx={"auto"}>
-              <Image style={{ maxHeight: 250 }} alt="Avatar" src={image} />
-            </AspectRatio>
-          ) : (
-            <Center h={"100%"}>
-              <IconImageInPicture size={50} />
-            </Center>
-          )}
-        </ComponentGlobal_BoxUploadImage>
-
-        <Center>
-          <FileButton
-            onChange={async (files: any | null) => {
-              try {
-                const buffer = URL.createObjectURL(
-                  new Blob([new Uint8Array(await files.arrayBuffer())])
-                );
-
-                // if (files.size > MAX_SIZE) {
-                //   ComponentGlobal_NotifikasiPeringatan(
-                //     PemberitahuanMaksimalFile
-                //   );
-                //   return;
-                // } else {
-
-                // }
-
-                console.log("ini buffer", buffer);
-
-                setFile(files);
-                setImage(buffer);
-              } catch (error) {
-                clientLogger.error("Upload error:", error);
-              }
-            }}
-            accept="image/png,image/jpeg"
-          >
-            {(props) => (
-              <Button
-                {...props}
-                radius={"sm"}
-                leftIcon={<IconUpload />}
-                bg={MainColor.yellow}
-                color="yellow"
-                c={"black"}
-              >
-                Upload
-              </Button>
-            )}
-          </FileButton>
-        </Center>
-
-        <Button
-          loaderPosition="center"
-          loading={isLoading}
-          onClick={() => {
-            onUpload();
-          }}
-        >
-          Simpan
-        </Button>
-      </Stack>
-    </>
-  );
-}
--- a/src/app/zz-makuro/LoadDataContoh.tsx
+++ b/src/app/zz-makuro/LoadDataContoh.tsx
@@ -1,30 +0,0 @@
-"use client";
-import { Stack } from "@mantine/core";
-import useSwr from "swr";
-
-const fether = (url: string) =>
-  fetch("https://jsonplaceholder.typicode.com" + url, {
-    cache: "force-cache",
-    next: {
-      revalidate: 60,
-    },
-  }).then((res) => res.json());
-
-export default function LoadDataContoh() {
-  const { data, isLoading, error, mutate, isValidating } = useSwr(
-    "/posts/1",
-    fether,
-    {
-      revalidateOnFocus: false,
-      revalidateOnReconnect: false,
-     refreshInterval: 1000,
-    }
-  );
-  return (
-    <Stack>
-      {isLoading && <div>Loading...</div>}
-      LoadDataContoh
-      {JSON.stringify(data, null, 2)}
-    </Stack>
-  );
-}
--- a/src/app/zz-makuro/get-data-example.ts
+++ b/src/app/zz-makuro/get-data-example.ts
@@ -1,9 +0,0 @@
-async function getDataExample() {
-  const res = await fetch("https://jsonplaceholder.typicode.com/posts", {
-    next: {
-      revalidate: 60,
-    },
-  });
-
-  return res.json();
-}
--- a/src/app/zz-makuro/page.tsx
+++ b/src/app/zz-makuro/page.tsx
@@ -1,51 +0,0 @@
-import { Suspense } from "react";
-import LoadDataContoh from "./LoadDataContoh";
-
-const listMenu = [
-  {
-    name: "Dashboard",
-    url: "/dashboard",
-    icon: "dashboard",
-  },
-  {
-    name: "Event",
-    url: "/event",
-    icon: "event",
-  },
-  {
-    name: "Donasi",
-    url: "/donasi",
-    icon: "donasi",
-  },
-];
-
-const fether = async (url: string) =>
-  fetch("https://jsonplaceholder.typicode.com" + url, {
-    next: {
-      revalidate: 2,
-    },
-  }).then(async (res) => {
-    const data = await res.json();
-    // console.log(data);
-    return data;
-  });
-
-export default async function Page() {
-  const data = await fether("/posts/1");
-  
-  return (
-    <div>
-      {listMenu.map((item) => {
-        return (
-          <div key={item.name}>
-            <a href={item.url}>{item.name}</a>
-          </div>
-        );
-      })}
-      {/* <LoadDataContoh /> */}
-      <Suspense fallback={<div>Loading...</div>}>
-        {JSON.stringify(data, null, 2)}
-      </Suspense>
-    </div>
-  );
-}
--- 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,22 @@ 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,
+    }),
+  });

  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,44 +1,60 @@
 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;
-
-if (process.env.NODE_ENV === "production") {
-  prisma = new PrismaClient({
-    // Reduce logging in production to improve performance
-    log: ['error', 'warn'],
+// 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,
+      },
+    },
  });
-} else {
-  if (!global.prisma) {
-    global.prisma = new PrismaClient({
-      log: ['error', 'warn', 'info', 'query'], // More verbose logging in development
-    });
+
+// 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;
+}
+
+/**
+ * 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");
+}
+
+// Register shutdown handlers (hanya di environment Node.js server)
+// Cegah duplikasi listener dengan cek listenerCount terlebih dahulu
+// IMPORTANT: Bungkus dalam check untuk mencegah error di browser
+if (typeof process !== "undefined" && typeof process.listenerCount === "function") {
+  if (process.listenerCount("SIGINT") === 0) {
+    process.on("SIGINT", gracefulShutdown);
+  }
+  if (process.listenerCount("SIGTERM") === 0) {
+    process.on("SIGTERM", gracefulShutdown);
  }
-  prisma = global.prisma;
-}
-
-// 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);
-  });
-
-  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;
 }

 export default prisma;
--- a/src/middleware.tsx
+++ b/src/middleware.tsx
@@ -49,6 +49,7 @@ const CONFIG: MiddlewareConfig = {
    "/auth/api/login",
    "/waiting-room",
    "/zCoba/*",
+    "/event/*/confirmation",
    "/aset/global/main_background.png",
    "/aset/logo/logo-hipmi.png",
    "/aset/logo/hiconnect.png",
@@ -65,11 +66,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);
--- a/test/coba.test.ts
+++ b/test/coba.test.ts
@@ -1,9 +0,0 @@
-import { prisma } from "@/lib";
-import { describe, test, expect } from "bun:test";
-
-describe("coba test", () => {
-  test("coba", async () => {
-    const user = await prisma.user.findMany();
-    expect(user).not.toBeEmpty();
-  });
-});
--- 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,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()
-  })
Author	SHA1	Message	Date
bagasbanuna	e7698618a2	Merge pull request 'server/14-apr-26' (#69 ) from server/14-apr-26 into staging Reviewed-on: #69	2026-04-14 16:38:23 +08:00
bagasbanuna	a821aeb129	chore: remove unused test file Co-authored-by: Qwen-Coder <qwen-coder@alibabacloud.com>	2026-04-14 15:42:58 +08:00
bagasbanuna	0dd939b979	chore(release): 1.7.5	2026-04-14 15:34:52 +08:00
bagasbanuna	38239c52d6	fix: override MIME type for PDF uploads & fix build errors - Fix PDF upload failing on Android due to wrong MIME type (image/pdf → application/pdf) - Add safe JSON parsing for external storage responses with incorrect Content-Type headers - Add detailed upload logging for debugging (file name, type, size, response status) - Fix TypeScript error: missing prisma import in forum preview-report-posting route - Fix ESLint warning: unescaped apostrophe in support-center page - Add DEBUG_UPLOAD_FILE.md documentation for troubleshooting guide Fixes upload issue where Android devices couldn't upload PDF files due to MIME type mismatch Co-authored-by: Qwen-Coder <qwen-coder@alibabacloud.com>	2026-04-14 15:17:45 +08:00
bagasbanuna	a71997b4ef	Fix version 1.7.4 ## no issue	2026-03-30 15:49:07 +08:00
bagasbanuna	0f584f8c72	chore(release): 1.7.4	2026-03-30 15:48:42 +08:00
bagasbanuna	445801941d	fix	2026-03-27 17:59:59 +08:00
bagasbanuna	defafe694f	chore(release): 1.7.3	2026-03-27 17:22:38 +08:00
bagasbanuna	cd3a9cc223	Fix server ### Issue: process.listenerCount()	2026-03-13 16:44:25 +08:00
bagasbanuna	0eb31073b7	chore(release): 1.7.2	2026-03-13 16:43:35 +08:00
bagasbanuna	d33296d23b	Fix validasi mobile ### No issue;	2026-03-11 14:12:07 +08:00
bagasbanuna	f7d05783c7	chore(release): 1.7.1	2026-03-11 13:56:09 +08:00
bagasbanuna	0f4abea990	Fix Bug & Clean Code ### No Issue"	2026-03-10 16:22:36 +08:00
bagasbanuna	a03c1fa575	Fix Docker file and Clean code ### No issue	2026-03-10 15:07:54 +08:00
bagasbanuna	fe457cd2d4	chore(release): 1.7.0	2026-03-10 15:05:46 +08:00
bagasbanuna	73cbf3640a	feat: Tambahkan deep link handler untuk event confirmation Deskripsi: - Membuat route handler /event/[id]/confirmation untuk deep link mobile - Menambahkan deteksi platform (iOS, Android, Web) dari user agent - Memperbaiki Content-Type header untuk file .well-known (AASA & assetlinks) - Menambahkan route ke public middleware agar bisa diakses tanpa auth File yang diubah: - src/app/event/[id]/confirmation/route.ts (baru) - src/middleware.tsx (tambah public route) - next.config.js (tambah headers untuk .well-known) Testing: - File .well-known accessible: ✅ YES - Content-Type header correct: ✅ YES - Deep link route works: ✅ YES - Platform detection works: ✅ YES ### No Issue	2026-03-09 15:32:54 +08:00
bagasbanuna	dc6fa562cc	Clean code modified: public/.well-known/assetlinks.json modified: src/lib/code-otp-sender.ts ### No issue	2026-03-06 16:35:34 +08:00
bagasbanuna	4fd7bb4a17	chore(release): 1.6.9	2026-03-06 16:29:50 +08:00
bagasbanuna	9199cc6971	Merge pull request 'fix-server' (#68 ) from fix-server/5-mar-26 into staging Reviewed-on: #68	2026-03-05 16:44:21 +08:00
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	74d90ea6aa	Merge pull request 'fix-server/4-mar-26' (#67 ) from fix-server/4-mar-26 into staging Reviewed-on: #67	2026-03-04 16:44:05 +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	edc9d532d4	Merge pull request 'bug-prisma 4' (#66 ) from bug-prisma/3-mar-26 into staging Reviewed-on: #66	2026-03-03 16:47:49 +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	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	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	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	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	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	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	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	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	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	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