Merge pull request 'Fix Admin API Mobile' (#58) from mobile-api/18-feb-26 into staging

Reviewed-on: #58

CHANGELOG_COMMIT.md

@@ -0,0 +1,39 @@
+## Catatan Perubahan untuk Commit
+
+### Fitur: Penambahan Pagination pada Endpoint Admin Mobile
+
+#### Deskripsi Umum
+Telah dilakukan penambahan fitur pagination pada beberapa endpoint admin mobile untuk meningkatkan kinerja dan pengalaman pengguna saat mengakses data dalam jumlah besar.
+
+#### File yang Diubah
+
+1. **src/app/api/mobile/admin/job/route.ts**
+   - Ditambahkan parameter `page` dari `searchParams`
+   - Diterapkan logika pagination dengan `takeData` (default 10) dan `skipData`
+   - Query `prisma.job.findMany` telah dimodifikasi untuk mendukung pagination
+
+2. **src/app/api/mobile/admin/event/route.ts**
+   - Diperbaiki definisi variabel `page` untuk memastikan tipe data yang konsisten
+   - Ditambahkan default value 1 untuk parameter `page`
+   - Perhitungan `skipData` disesuaikan agar lebih efisien
+
+3. **src/app/api/mobile/admin/event/[id]/participants/route.ts**
+   - Ditambahkan parameter `page` dari `searchParams`
+   - Diterapkan logika pagination dengan `takeData` (default 10) dan `skipData`
+   - Query `prisma.event_Peserta.findMany` telah dimodifikasi untuk mendukung pagination
+
+#### Tujuan Perubahan
+- Meningkatkan kinerja aplikasi saat mengambil data dalam jumlah besar
+- Memungkinkan pengguna untuk mengakses data secara bertahap melalui halaman-halaman
+- Mengurangi beban server saat mengambil data dalam jumlah besar
+- Memberikan pengalaman pengguna yang lebih baik saat mengakses data admin
+
+#### Cara Penggunaan
+Untuk menggunakan fitur pagination, cukup tambahkan parameter `page` pada query string saat melakukan permintaan ke endpoint yang telah dimodifikasi. Contoh:
+```
+GET /api/mobile/admin/job?page=2
+GET /api/mobile/admin/event?page=3
+GET /api/mobile/admin/event/{id}/participants?page=1
+```
+
+Default jumlah data per halaman adalah 10 item.

PROMPT-AI.md

@@ -1,5 +1,5 @@
 
-File utama: src/app/api/mobile/donation/[id]/[status]/route.ts
+File utama: src/app/api/mobile/admin/donation/[id]/donatur/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
@@ -33,4 +33,13 @@ Buatkan auto input untuk method POST dengan data yang dibutuhkan sesuai dengan s
 - rekening: string
 - imageId: number ( cm60j9q3m000xc9dc584v8rh8 )
 
-Untuk sisa nya anda bisa bebas mengisi data tersebut.
+Untuk sisa nya anda bisa bebas mengisi data tersebut.
+
+<!-- COMMIT & PUSH -->
+Branch: mobile-api/10-feb-26
+Jalankan perintah ini: git checkout -b "Branch"
+Setelah itu jalankan perintah ini: git add .
+Setelah itu jalankan perintah ini: git commit -m "
+<Berikan semua catatan perubahan pada branch ini, tampilan pada saya dan pastikan dalam bahasa indonesia. Saya akan cek baru saya akan berikan perintah push>
+"
+Setelah itu jalankan perintah ini: git push origin "Branch"

QWEN.md

@@ -2,7 +2,7 @@
 
 ## Project Overview
 
-HIPMI (Himpunan Pengusaha Muda Indonesia) is a comprehensive Next.js-based web application built for the Indonesian Young Entrepreneurs Association. The project is a sophisticated platform that provides multiple business functionalities including investment management, donations, events, job listings, forums, voting systems, and collaborative projects.
+HIPMI (Himpunan Pengusaha Muya Indonesia) is a comprehensive Next.js-based web application built for the Indonesian Young Entrepreneurs Association. The project is a sophisticated platform that provides multiple business functionalities including investment management, donations, events, job listings, forums, voting systems, and collaborative projects.
 
 ### Key Technologies
 - **Framework**: Next.js 13+ (with App Router)
@@ -198,4 +198,4 @@ References: #issue-number
 ### Data Protection
 - Encrypted tokens
 - Secure API routes
-- Proper CORS configuration
+- Proper CORS configuration

src/app/api/mobile/admin/donation/[id]/disbursement/route.ts

@@ -10,6 +10,7 @@ import {
   NotificationMobileTitleType,
 } from "../../../../../../../../types/type-mobile-notification";
 import { routeUserMobile } from "@/lib/mobile/route-page-mobile";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 
 export { POST, GET };
 
@@ -154,7 +155,7 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
   const { searchParams } = new URL(request.url);
   const category = searchParams.get("category");
   const page = searchParams.get("page");
-  const takeData = 10;
+  const takeData = PAGINATION_DEFAULT_TAKE;
   const skipData = Number(page) * takeData - takeData;
 
   console.log("[CATEGORY]", category);
@@ -174,6 +175,7 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
           id: true,
           createdAt: true,
           nominalCair: true,
+          title: true,
         },
       });
     } else if (category === "get-one") {

src/app/api/mobile/admin/donation/[id]/donatur/route.ts

@@ -1,6 +1,7 @@
 import _ from "lodash";
 import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 
 export { GET };
 
@@ -9,7 +10,7 @@ async function GET(req: Request, { params }: { params: { id: string } }) {
   const { searchParams } = new URL(req.url);
   const page = searchParams.get("page");
   const status = searchParams.get("status");
-  const takeData = 10;
+  const takeData = PAGINATION_DEFAULT_TAKE;
   const skipData = Number(page) * takeData - takeData;
   const fixStatus = _.startCase(status || "");
 

src/app/api/mobile/admin/donation/route.ts

@@ -1,6 +1,7 @@
 import _ from "lodash";
 import { NextResponse } from "next/server";
 import prisma from "@/lib/prisma";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 
 export { GET };
 
@@ -9,11 +10,10 @@ async function GET(request: Request) {
   const category = searchParams.get("category");
   const page = searchParams.get("page");
   const search = searchParams.get("search");
-  const takeData = 10;
+  const takeData = PAGINATION_DEFAULT_TAKE;
   const skipData = Number(page) * takeData - takeData;
-  console.log("[CATEGORY]", category);
   let fixData;
-  
+
   try {
     if (category === "dashboard") {
       const publish = await prisma.donasi.count({
@@ -48,7 +48,7 @@ async function GET(request: Request) {
           where: {
             active: true,
           },
-        }
+        },
       );
 
       const categoryDonation = countCategoryDonation.length;
@@ -68,7 +68,6 @@ async function GET(request: Request) {
         },
       });
 
-      console.log("[STATUS]", checkStatus);
 
       if (!checkStatus) {
         return NextResponse.json(
@@ -77,7 +76,7 @@ async function GET(request: Request) {
             message: "Failed to get data donation",
             reason: "Status not found",
           },
-          { status: 500 }
+          { status: 500 },
         );
       }
 
@@ -100,6 +99,12 @@ async function GET(request: Request) {
         select: {
           id: true,
           title: true,
+          target: true,
+          DonasiMaster_Durasi: {
+            select: {
+              name: true,
+            },
+          },
           Author: {
             select: {
               id: true,
@@ -109,7 +114,6 @@ async function GET(request: Request) {
         },
       });
 
-      console.log("[LIST]", fixData);
     }
 
     return NextResponse.json(
@@ -118,7 +122,7 @@ async function GET(request: Request) {
         message: `Success get data donation ${category}`,
         data: fixData,
       },
-      { status: 200 }
+      { status: 200 },
     );
   } catch (error) {
     console.error("Error get data donation:", error);
@@ -128,7 +132,7 @@ async function GET(request: Request) {
         message: "Failed to get data donation",
         reason: (error as Error).message,
       },
-      { status: 500 }
+      { status: 500 },
     );
   }
 }

src/app/api/mobile/admin/event/[id]/participants/route.ts

@@ -1,9 +1,15 @@
-import { NextResponse } from "next/server";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 import prisma from "@/lib/prisma";
+import { NextResponse } from "next/server";
 
 export { GET };
 
 async function GET(request: Request, { params }: { params: { id: string } }) {
+  const { searchParams } = new URL(request.url);
+  const page = Number(searchParams.get("page")) || 1;
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page * takeData - takeData;
+
   try {
     const { id } = params;
 
@@ -12,6 +18,7 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
         eventId: id,
       },
       select: {
+        id: true,
         eventId: true,
         userId: true,
         isPresent: true,
@@ -35,6 +42,8 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
           },
         },
       },
+      take: page ? takeData : undefined,
+      skip: page ? skipData : undefined,
     });
 
     return NextResponse.json(

src/app/api/mobile/admin/event/route.ts

@@ -1,7 +1,8 @@
-import _ from "lodash";
 import { prisma } from "@/lib";
-import { NextResponse } from "next/server";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
+import _ from "lodash";
 import moment from "moment";
+import { NextResponse } from "next/server";
 
 export { GET };
 
@@ -11,13 +12,12 @@ async function GET(request: Request) {
   const fixStatus = _.startCase(category || "");
 
   const search = searchParams.get("search");
-  const page = searchParams.get("page");
-  const takeData = 10;
-  const skipData = Number(page) * takeData - takeData;
+  const page = Number(searchParams.get("page")) || 1;
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page * takeData - takeData;
   let fixData;
 
-  console.log("[CATEGORY]", category);
-  //   console.log("[FIX STATUS]", fixStatus);
+ 
 
   try {
     if (category === "dashboard") {
@@ -71,7 +71,6 @@ async function GET(request: Request) {
         typeOfEvent,
       };
     } else if (category === "history") {
-      console.log("[HISTORY HERE]");
 
       const data = await prisma.event.findMany({
         take: page ? takeData : undefined,
@@ -151,21 +150,22 @@ async function GET(request: Request) {
           },
         },
         select: {
-            id: true,
-            title: true,
-            tanggal: true,
-            Author: {
-              select: {
-                id: true,
-                username: true,
-                Profile: {
-                  select: {
-                    name: true,
-                  },
+          id: true,
+          title: true,
+          tanggal: true,
+          tanggalSelesai: true,
+          Author: {
+            select: {
+              id: true,
+              username: true,
+              Profile: {
+                select: {
+                  name: true,
                 },
               },
             },
           },
+        },
       });
 
       fixData = data;
@@ -177,7 +177,7 @@ async function GET(request: Request) {
         message: `Success get data event ${category}`,
         data: fixData,
       },
-      { status: 200 }
+      { status: 200 },
     );
   } catch (error) {
     console.log(`[ERROR GET DATA EVENT: ${category}]`, error);
@@ -187,7 +187,7 @@ async function GET(request: Request) {
         message: `Error get data event ${category}`,
         reason: (error as Error).message,
       },
-      { status: 500 }
+      { status: 500 },
     );
   }
 }

src/app/api/mobile/admin/job/route.ts

@@ -1,6 +1,7 @@
 import _ from "lodash";
 import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 
 export { GET };
 
@@ -8,6 +9,9 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
   const { searchParams } = new URL(request.url);
   const category = searchParams.get("category");
   const search = searchParams.get("search");
+  const page = Number(searchParams.get("page")) || 1;
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page * takeData - takeData;
   let fixData;
 
   try {
@@ -66,6 +70,8 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
           title: true,
           Author: true,
         },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
       });
     }
 

src/app/api/mobile/admin/master/bank/route.ts

@@ -1,14 +1,22 @@
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 import { NextResponse } from "next/server";
 
 export { GET, POST };
 
-async function GET() {
+async function GET(request: Request) {
   try {
+    const { searchParams } = new URL(request.url);
+    const page = Number(searchParams.get("page"));
+    const takeData = PAGINATION_DEFAULT_TAKE;
+    const skipData = page * takeData - takeData;
+
     const data = await prisma.masterBank.findMany({
       orderBy: {
         updatedAt: "desc",
       },
+      take: page ? takeData : undefined,
+      skip: page ? skipData : undefined,
     });
 
     return NextResponse.json(

src/app/api/mobile/admin/master/business-field/[id]/route.ts

@@ -1,5 +1,6 @@
-import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
+import { NextResponse } from "next/server";
 
 export { GET, PUT };
 
@@ -11,6 +12,10 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
     const category = searchParams.get("category");
     const subBidangId = searchParams.get("subBidangId");
 
+    const page = Number(searchParams.get("page")) || 1;
+    const takeData = PAGINATION_DEFAULT_TAKE;
+    const skipData = page * takeData - takeData;
+
     if (category === "all") {
       const bidang = await prisma.masterBidangBisnis.findUnique({
         where: {
@@ -45,6 +50,16 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
         },
       });
 
+      fixData = subBidang;
+    } else if (category === "only-sub-bidang") {
+      const subBidang = await prisma.masterSubBidangBisnis.findMany({
+        where: {
+          masterBidangBisnisId: id,
+        },
+        take: takeData,
+        skip: skipData,
+      });
+
       fixData = subBidang;
     }
 
@@ -71,9 +86,6 @@ async function PUT(request: Request, { params }: { params: { id: string } }) {
   const { searchParams } = new URL(request.url);
   const category = searchParams.get("category");
 
-  console.log("category", category);
-  console.log("data", data);
-
   try {
     if (category === "bidang") {
       const updateData = await prisma.masterBidangBisnis.update({

src/app/api/mobile/admin/master/business-field/route.ts

@@ -2,15 +2,24 @@ import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
 import _ from "lodash";
 import { Prisma } from "@prisma/client";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 
 export { GET, POST };
 
 async function GET(request: Request) {
   try {
+    const { searchParams } = new URL(request.url);
+    const page = Number(searchParams.get("page"));
+    const takeData = PAGINATION_DEFAULT_TAKE;
+    const skipData = page * takeData - takeData;
+
+
     const data = await prisma.masterBidangBisnis.findMany({
       orderBy: {
         createdAt: "asc",
       },
+      take: page ? takeData : undefined,
+      skip: page ? skipData : undefined,
     });
 
     return NextResponse.json({

src/app/api/mobile/admin/master/donation/route.ts

@@ -1,10 +1,14 @@
-import { NextResponse } from "next/server";
+import { NextRequest, NextResponse } from "next/server";
 import prisma from "@/lib/prisma";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 
 export { GET, POST };
 
-async function GET(request: Request) {
+async function GET(request: NextRequest) {
   const { searchParams } = new URL(request.url);
+  const page = Number(searchParams.get("page"));
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page * takeData - takeData;
   //   const category = searchParams.get("category");
   let fixData;
 
@@ -13,6 +17,8 @@ async function GET(request: Request) {
       orderBy: {
         createdAt: "asc",
       },
+      take: page ? takeData : undefined,
+      skip: page ? skipData : undefined,
     });
 
     // if (category === "category") {

src/app/api/mobile/admin/master/type-of-event/route.ts

@@ -1,14 +1,22 @@
-import { NextResponse } from "next/server";
+import { NextRequest, NextResponse } from "next/server";
 import prisma from "@/lib/prisma";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 
 export { GET, POST };
 
-async function GET(request: Request) {
+async function GET(request: NextRequest) {
   try {
+    const searchParams = request.nextUrl.searchParams;
+    const page = Number(searchParams.get("page"));
+    const takeData = PAGINATION_DEFAULT_TAKE;
+    const skipData = page * takeData - takeData;
+
     const data = await prisma.eventMaster_TipeAcara.findMany({
       orderBy: {
         updatedAt: "desc",
       },
+      take: page ? takeData : undefined,
+      skip: page ? skipData : undefined,
     });
 
     return NextResponse.json({

src/app/api/mobile/admin/user/route.ts

@@ -1,5 +1,6 @@
-import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
+import { NextResponse } from "next/server";
 
 export { GET };
 
@@ -7,10 +8,16 @@ async function GET(request: Request) {
   const { searchParams } = new URL(request.url);
   const search = searchParams.get("search");
   const category = searchParams.get("category");
+  const page = Number(searchParams.get("page"));
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page * takeData - takeData;
+
+  console.log("SEARCH", search);
+  console.log("PAGE", page);
 
   let fixData;
   try {
-    if(category === "only-user"){
+    if (category === "only-user") {
       fixData = await prisma.user.findMany({
         orderBy: {
           updatedAt: "desc",
@@ -22,8 +29,10 @@ async function GET(request: Request) {
             mode: "insensitive",
           },
         },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
       });
-    } else if(category === "only-admin"){
+    } else if (category === "only-admin") {
       fixData = await prisma.user.findMany({
         orderBy: {
           updatedAt: "desc",
@@ -35,8 +44,10 @@ async function GET(request: Request) {
             mode: "insensitive",
           },
         },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
       });
-    } else if  (category === "all-role"){
+    } else if (category === "all-role") {
       fixData = await prisma.user.findMany({
         orderBy: {
           updatedAt: "desc",
@@ -48,13 +59,15 @@ async function GET(request: Request) {
             },
             {
               masterUserRoleId: "2",
-            }
+            },
           ],
           username: {
             contains: search || "",
             mode: "insensitive",
           },
         },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
       });
     }
 
@@ -65,13 +78,11 @@ async function GET(request: Request) {
       data: fixData,
     });
   } catch (error) {
-    return NextResponse.json(
-      {
-        status: 500,
-        success: false,
-        message: "Error get data user access",
-        reason: (error as Error).message,
-      },
-    );
+    return NextResponse.json({
+      status: 500,
+      success: false,
+      message: "Error get data user access",
+      reason: (error as Error).message,
+    });
   }
 }

src/app/api/mobile/admin/voting/route.ts

@@ -2,6 +2,7 @@ import _ from "lodash";
 import moment from "moment";
 import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 
 export { GET };
 
@@ -12,7 +13,7 @@ async function GET(request: Request) {
 
   const search = searchParams.get("search");
   const page = searchParams.get("page");
-  const takeData = 10;
+  const takeData = PAGINATION_DEFAULT_TAKE;
   const skipData = Number(page) * takeData - takeData;
   let fixData;
 

src/app/api/mobile/auth/device-tokens/route.ts

@@ -4,13 +4,42 @@ import { prisma } from "@/lib";
 export { POST, GET };
 
 async function POST(request: NextRequest) {
-  const { data } = await request.json();
   try {
+    // Parse the request body - can accept either nested under 'data' or directly
+    const requestBody = await request.json();
+    
+    // Check if the data is nested under 'data' property (as described in the issue)
+    // or if it's directly in the request body (more common pattern)
+    const payload = requestBody.data ? requestBody.data : requestBody;
+    
+    const { userId, platform, deviceId, model, appVersion, fcmToken } = payload;
 
-    const { userId, platform, deviceId, model, appVersion, fcmToken } = data;
-
+    // Validate required fields
     if (!fcmToken) {
-      return NextResponse.json({ error: "Missing Token" }, { status: 400 });
+      return NextResponse.json(
+        { error: "Missing FCM token", field: "fcmToken" }, 
+        { status: 400 }
+      );
+    }
+
+    if (!userId) {
+      return NextResponse.json(
+        { error: "Missing user ID", field: "userId" }, 
+        { status: 400 }
+      );
+    }
+
+    // Verify that the user exists before creating/updating the device token
+    const userExists = await prisma.user.findUnique({
+      where: { id: userId },
+      select: { id: true }
+    });
+
+    if (!userExists) {
+      return NextResponse.json(
+        { error: "User not found", field: "userId" }, 
+        { status: 404 }
+      );
     }
 
     const existing = await prisma.tokenUserDevice.findFirst({
@@ -23,7 +52,6 @@ async function POST(request: NextRequest) {
       },
     });
 
-
     console.log("✅ EX", existing);
 
     let deviceToken;
@@ -31,7 +59,7 @@ async function POST(request: NextRequest) {
     if (existing) {
       deviceToken = await prisma.tokenUserDevice.update({
         where: {
-          id: existing?.id,
+          id: existing.id,
         },
         data: {
           platform,
@@ -43,7 +71,7 @@ async function POST(request: NextRequest) {
         },
       });
     } else {
-      // Buat baru jika belum ada
+      // Create new device token record
       deviceToken = await prisma.tokenUserDevice.create({
         data: {
           token: fcmToken,
@@ -58,9 +86,16 @@ async function POST(request: NextRequest) {
     }
 
     return NextResponse.json({ success: true, data: deviceToken });
-  } catch (error) {
+  } catch (error: any) {
+    console.error("Error registering device token:", error);
+    
+    // Return more informative error response
     return NextResponse.json(
-      { error: (error as Error).message },
+      { 
+        error: "Internal server error",
+        message: error.message || "An unexpected error occurred",
+        field: "server"
+      },
       { status: 500 }
     );
   }

src/app/api/mobile/donation/[id]/[status]/route.ts

@@ -1,6 +1,7 @@
 import _ from "lodash";
 import { NextResponse } from "next/server";
 import prisma from "@/lib/prisma";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 
 export { GET, PUT };
 
@@ -12,7 +13,7 @@ async function GET(
   const fixStatus = _.startCase(status);
   const { searchParams } = new URL(request.url);
   const page = Number(searchParams.get("page")) || 1;
-  const takeData = 5
+  const takeData = PAGINATION_DEFAULT_TAKE
   const skipData = page * takeData - takeData;
 
   let fixData;

src/app/api/mobile/donation/[id]/disbursement/route.ts

@@ -1,5 +1,6 @@
 import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 
 export { GET };
 
@@ -7,7 +8,7 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
   const { id } = params;
   const { searchParams } = new URL(request.url);
   const page = Number(searchParams.get("page"));
-  const takeData = 5;
+  const takeData = PAGINATION_DEFAULT_TAKE;
   const skipData = page * takeData - takeData;
 
   try {

src/app/api/mobile/donation/[id]/donatur/route.ts

@@ -1,3 +1,4 @@
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 import prisma from "@/lib/prisma";
 import { NextResponse } from "next/server";
 
@@ -9,11 +10,12 @@ export async function GET(
     let fixData;
     const { id } = params;
     const { searchParams } = new URL(request.url);
-    const page = Number(searchParams.get("page"));
-    const takeData = 10;
+    const page = Number(searchParams.get("page")) || 1; // Default page 1 jika tidak ada atau invalid
+    const takeData = PAGINATION_DEFAULT_TAKE;
     const skipData = page * takeData - takeData;
 
-    fixData = await prisma.donasi_Invoice.findMany({
+    // Query data dengan pagination
+    const data = await prisma.donasi_Invoice.findMany({
       take: page ? takeData : undefined,
       skip: page ? skipData : undefined,
       orderBy: {
@@ -59,10 +61,31 @@ export async function GET(
       },
     });
 
+    // Hitung total data untuk pagination
+    const totalCount = await prisma.donasi_Invoice.count({
+      where: {
+        donasiId: id,
+        DonasiMaster_StatusInvoice: {
+          name: "Berhasil",
+        },
+      },
+    });
+
+    // Hitung total halaman
+    const totalPages = Math.ceil(totalCount / takeData);
+
+    fixData = data;
+
     return NextResponse.json({
       success: true,
       message: "Data berhasil diambil",
       data: fixData,
+      pagination: {
+        currentPage: page,
+        totalPages: totalPages,
+        totalData: totalCount,
+        dataPerPage: takeData,
+      },
     });
   } catch (error) {
     return NextResponse.json({

src/app/api/mobile/donation/[id]/news/route.ts

@@ -8,6 +8,7 @@ import {
 } from "../../../../../../../types/type-mobile-notification";
 import { routeUserMobile } from "@/lib/mobile/route-page-mobile";
 import { funFindDonaturList } from "@/lib/mobile/donation/find-donatur-list";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 
 export { POST, GET, PUT, DELETE };
 
@@ -94,11 +95,16 @@ async function GET(
   const { id } = params;
   const { searchParams } = new URL(request.url);
   const category = searchParams.get("category");
+  const page = Number(searchParams.get("page")) || 1; // Default page 1 jika tidak ada
+  const takeData = PAGINATION_DEFAULT_TAKE; // Default 10 data per halaman
+  const skipData = page * takeData - takeData;
+  
   let fixData;
+  let totalCount = 0; // Untuk menghitung total data
 
   try {
     if (category === "get-all") {
-      fixData = await prisma.donasi_Kabar.findMany({
+      const data = await prisma.donasi_Kabar.findMany({
         orderBy: {
           updatedAt: "desc",
         },
@@ -106,6 +112,8 @@ async function GET(
           donasiId: id,
           active: true,
         },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
         select: {
           id: true,
           title: true,
@@ -113,6 +121,17 @@ async function GET(
           createdAt: true,
         },
       });
+
+      // Hitung total data untuk pagination
+      totalCount = await prisma.donasi_Kabar.count({
+        where: {
+          donasiId: id,
+          active: true,
+        },
+      });
+
+      fixData = data;
+
     } else if (category === "get-one") {
       const data = await prisma.donasi_Kabar.findUnique({
         where: {
@@ -135,11 +154,24 @@ async function GET(
       };
     }
 
+    // Hitung total halaman jika kategori adalah get-all
+    let pagination = undefined;
+    if (category === "get-all") {
+      const totalPages = Math.ceil(totalCount / takeData);
+      pagination = {
+        currentPage: page,
+        totalPages: totalPages,
+        totalData: totalCount,
+        dataPerPage: takeData,
+      };
+    }
+
     return NextResponse.json({
       status: 200,
       success: true,
       message: "Berhasil mengambil kabar",
       data: fixData,
+      pagination: pagination,
     });
   } catch (error) {
     console.error("[ERROR GET NEWS]", error);

src/app/api/mobile/donation/route.ts

@@ -4,6 +4,7 @@ import _ from "lodash";
 import { NextResponse } from "next/server";
 import { NotificationMobileBodyType } from "../../../../../types/type-mobile-notification";
 import { routeAdminMobile } from "@/lib/mobile/route-page-mobile";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 
 export { POST, GET };
 
@@ -125,7 +126,12 @@ async function GET(request: Request) {
   const { searchParams } = new URL(request.url);
   const category = searchParams.get("category");
   const authorId = searchParams.get("authorId");
+  const page = Number(searchParams.get("page")) || 1; // Default page 1 jika tidak ada
+  const takeData = PAGINATION_DEFAULT_TAKE; // Default 10 data per halaman
+  const skipData = page * takeData - takeData;
+  
   let fixData;
+  let totalCount = 0; // Untuk menghitung total data
 
   try {
     if (category === "beranda") {
@@ -137,6 +143,8 @@ async function GET(request: Request) {
           donasiMaster_StatusDonasiId: "1",
           active: true,
         },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
         select: {
           id: true,
           imageId: true,
@@ -152,6 +160,14 @@ async function GET(request: Request) {
         },
       });
 
+      // Hitung total data untuk pagination
+      totalCount = await prisma.donasi.count({
+        where: {
+          donasiMaster_StatusDonasiId: "1",
+          active: true,
+        },
+      });
+
       fixData = data.map((v: any) => ({
         ..._.omit(v, ["DonasiMaster_Durasi"]),
         durasiDonasi: v.DonasiMaster_Durasi.name,
@@ -164,6 +180,8 @@ async function GET(request: Request) {
         where: {
           authorId: authorId,
         },
+        take: page ? takeData : undefined,
+        skip: page ? skipData : undefined,
         select: {
           id: true,
           nominal: true,
@@ -190,6 +208,13 @@ async function GET(request: Request) {
         },
       });
 
+      // Hitung total data untuk pagination
+      totalCount = await prisma.donasi_Invoice.count({
+        where: {
+          authorId: authorId,
+        },
+      });
+
       fixData = data.map((v: any) => ({
         ..._.omit(v, ["DonasiMaster_StatusInvoice", "Donasi"]),
         statusInvoice: v.DonasiMaster_StatusInvoice.name,
@@ -202,8 +227,21 @@ async function GET(request: Request) {
       }));
     }
 
+    // Hitung total halaman
+    const totalPages = Math.ceil(totalCount / takeData);
+
     return NextResponse.json(
-      { success: true, message: "Data berhasil diambil", data: fixData },
+      { 
+        success: true, 
+        message: "Data berhasil diambil", 
+        data: fixData,
+        pagination: {
+          currentPage: page,
+          totalPages: totalPages,
+          totalData: totalCount,
+          dataPerPage: takeData,
+        }
+      },
       { status: 200 }
     );
   } catch (error) {

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

@@ -84,7 +84,7 @@ export async function GET(req: Request) {
       },
       { status: 500 }
     );
-  } finally {
-    await prisma.$disconnect();
   }
+  // Removed prisma.$disconnect() from here to prevent connection pool exhaustion
+  // Prisma connections are handled globally and shouldn't be disconnected on each request
 }

src/app_modules/_global/component/new/comp_V3_text_editor_stiker.tsx

@@ -28,6 +28,7 @@ import { useRouter } from "next/navigation";
 import { IconMoodSmileFilled } from "@tabler/icons-react";
 import { listStiker } from "../../lib/stiker";
 import { UIGlobal_Modal } from "../../ui";
+import mqtt_client from "@/util/mqtt_client";
 
 const ReactQuill = dynamic(
   async () => {
@@ -248,10 +249,12 @@ function ButtonAction({ value, lengthData }: ButtonActionProps) {
         ComponentGlobal_NotifikasiBerhasil(create.message);
         router.back();
 
-        mqtt_client.publish(
-          "Forum_create_new",
-          JSON.stringify({ isNewPost: true, count: 1 })
-        );
+        if (typeof window !== 'undefined' && mqtt_client) {
+          mqtt_client.publish(
+            "Forum_create_new",
+            JSON.stringify({ isNewPost: true, count: 1 })
+          );
+        }
       } else {
         ComponentGlobal_NotifikasiGagal(create.message);
       }

src/lib/prisma.ts

@@ -9,30 +9,21 @@ declare global {
 let prisma: PrismaClient;
 
 if (process.env.NODE_ENV === "production") {
-  prisma = new PrismaClient();
+  prisma = new PrismaClient({
+    // Reduce logging in production to improve performance
+    log: ['error', 'warn'],
+  });
 } else {
   if (!global.prisma) {
-    global.prisma = new PrismaClient();
+    global.prisma = new PrismaClient({
+      log: ['error', 'warn', 'info', 'query'], // More verbose logging in development
+    });
   }
   prisma = global.prisma;
 }
 
 // Tambahkan listener hanya jika belum ditambahkan sebelumnya
 if (!global.prismaListenersAdded) {
-  // Handle uncaught errors
-  process.on("uncaughtException", async (error) => {
-    console.error("Uncaught Exception:", error);
-    await prisma.$disconnect();
-    process.exit(1);
-  });
-
-  // Handle unhandled promise rejections
-  process.on("unhandledRejection", async (error) => {
-    console.error("Unhandled Rejection:", error);
-    await prisma.$disconnect();
-    process.exit(1);
-  });
-
   // Handle graceful shutdown
   process.on("SIGINT", async () => {
     console.log("Received SIGINT signal. Closing database connections...");
@@ -51,3 +42,4 @@ if (!global.prismaListenersAdded) {
 }
 
 export default prisma;
+export { prisma };

src/lib/prismaUtils.ts

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

src/middleware.tsx

@@ -66,9 +66,10 @@ export const middleware = async (req: NextRequest) => {
   const { pathname } = req.nextUrl;
 
   const apiBaseUrl = new URL(req.url).origin || process.env.NEXT_PUBLIC_API_URL;
-  const dbUrl = process.env.DATABASE_URL;
-  console.log("DATABASE_URL >>", dbUrl);
-  console.log("URL Access >>", req.url);
+  // 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);
 
   // Handle CORS preflight
   const corsResponse = handleCors(req);

src/util/mqtt_client.ts

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

src/util/mqtt_loader.tsx

@@ -3,20 +3,27 @@
 import { useEffect } from "react";
 import mqtt_client from "./mqtt_client";
 
-export default function   MqttLoader() {
+export default function MqttLoader() {
   useEffect(() => {
-    mqtt_client.on("connect", () => {
-      console.log("connected");
-    });
+    // Only set up connection handlers once
+    const handleConnect = () => {
+      console.log("MQTT connected");
+    };
+
+    const handleError = (error: any) => {
+      console.error("MQTT Error:", error);
+    };
+
+    // Subscribe to events
+    mqtt_client.on("connect", handleConnect);
+    mqtt_client.on("error", handleError);
+
+    // Cleanup function to unsubscribe when component unmounts
+    return () => {
+      mqtt_client.off("connect", handleConnect);
+      mqtt_client.off("error", handleError);
+    };
   }, []);
 
   return null;
-
-  //   <>
-  //     <Stack>
-  //       <Button onClick={onClick}>Tekan</Button>
-  //       <Button onClick={onClick2}>Tekan 2</Button>
-  //     </Stack>
-  //   </>
-  // );
 }