Fix api load data event dan notifikasi

API – Event (Mobile)
- src/app/api/mobile/event/route.ts
- src/app/api/mobile/event/[id]/[status]/route.ts

API – Notification (Mobile)
- src/app/api/mobile/notification/[id]/route.ts

Docs / Experiment
- PROMPT-AI.md
- zCoba.js

### No issue

PROMPT-AI.md

@@ -1,5 +1,6 @@
 
-File utama: src/app/api/mobile/notification/[id]/route.ts
+File utama: src/app/api/mobile/event/route.ts
+File refrensi: src/app/api/mobile/job/[id]/[status]/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
@@ -13,4 +14,6 @@ dan penerapannya pada query
 take: page ? takeData : undefined,
 skip: page ? skipData : undefined,
 
+Anda bisa menggunakan refrensi dari "File refrensi" jika butuh pemahaman dengan tipe fitur yang sama
+
 Gunakan bahasa indonesia pada cli agar saya mudah membacanya.

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

@@ -12,6 +12,11 @@ async function GET(
     const { id, status } = params;
     const fixStatusName = _.startCase(status);
 
+    const { searchParams } = new URL(request.url);
+    const page = Number(searchParams.get("page")) || 1;
+    const takeData = 10;
+    const skipData = page * takeData - takeData;
+
     const data = await prisma.event.findMany({
       orderBy: {
         updatedAt: "desc",
@@ -37,13 +42,35 @@ async function GET(
         },
         authorId: true,
       },
+      take: takeData,
+      skip: skipData,
     });
 
+    // Get total count for pagination info
+    const totalCount = await prisma.event.count({
+      where: {
+        active: true,
+        authorId: id,
+        isArsip: false,
+        EventMaster_Status: {
+          name: fixStatusName,
+        },
+      },
+    });
+
+    const totalPages = Math.ceil(totalCount / takeData);
+
     return NextResponse.json(
       {
         success: true,
         message: "Success get event",
         data: data,
+        pagination: {
+          currentPage: page,
+          totalPages: totalPages,
+          totalData: totalCount,
+          dataPerPage: takeData,
+        },
       },
       { status: 200 }
     );

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

@@ -76,11 +76,15 @@ async function GET(request: Request) {
     const { searchParams } = new URL(request.url);
     const category = searchParams.get("category");
     const userId = searchParams.get("userId");
+    const page = Number(searchParams.get("page")) || 1;
+    const takeData = 5;
+    const skipData = page * takeData - takeData;
 
     console.log("[CAT]", category);
     console.log("[USER]", userId);
 
     let fixData;
+    let totalCount = 0;
 
     if (category === "beranda") {
       const allData = await prisma.event.findMany({
@@ -108,84 +112,95 @@ async function GET(request: Request) {
         }
       }
 
-      // const takeData = 10;
+      const [data, count] = await Promise.all([
-      // const skipData = page * takeData - takeData;
+        prisma.event.findMany({
-
+          take: takeData,
-      const data = await prisma.event.findMany({
+          skip: skipData,
-        //   take: takeData,
+          orderBy: [
-        //   skip: skipData,
+            {
-        orderBy: [
+              tanggal: "asc",
-          {
+            },
-            tanggal: "asc",
+          ],
+          where: {
+            active: true,
+            eventMaster_StatusId: "1",
+            isArsip: false,
           },
-        ],
+          select: {
-        where: {
+            id: true,
-          active: true,
+            title: true,
-          eventMaster_StatusId: "1",
+            deskripsi: true,
-          isArsip: false,
+            tanggal: true,
-        },
+            tanggalSelesai: true,
-        select: {
+            EventMaster_Status: {
-          id: true,
+              select: {
-          title: true,
+                name: true,
-          deskripsi: true,
+              },
-          tanggal: true,
+            },
-          tanggalSelesai: true,
+            authorId: true,
-          EventMaster_Status: {
+            Author: {
-            select: {
+              include: {
-              name: true,
+                Profile: true,
+              },
             },
           },
-          authorId: true,
+        }),
-          Author: {
+        prisma.event.count({
-            include: {
+          where: {
-              Profile: true,
+            active: true,
-            },
+            eventMaster_StatusId: "1",
+            isArsip: false,
           },
-        },
+        })
-      });
+      ]);
 
       fixData = data;
+      totalCount = count;
     } else if (category === "contribution") {
-      const data = await prisma.event_Peserta.findMany({
+      const [data, count] = await Promise.all([
-        where: {
+        prisma.event_Peserta.findMany({
-          userId: userId,
+          take: takeData,
-        },
+          skip: skipData,
-        select: {
+          where: {
-          eventId: true,
+            userId: userId,
-          userId: true,
+          },
-          Event: {
+          select: {
-            select: {
+            eventId: true,
-              id: true,
+            userId: true,
-              title: true,
+            Event: {
-              tanggal: true,
+              select: {
-              Author: {
+                id: true,
-                select: {
+                title: true,
-                  id: true,
+                tanggal: true,
-                  username: true,
+                Author: {
-                  Profile: {
+                  select: {
-                    select: {
+                    id: true,
-                      id: true,
+                    username: true,
-                      name: true,
+                    Profile: {
-                      imageId: true,
+                      select: {
+                        id: true,
+                        name: true,
+                        imageId: true,
+                      },
                     },
                   },
                 },
-              },
+                Event_Peserta: {
-              Event_Peserta: {
+                  take: 4,
-                take: 4,
+                  orderBy: {
-                orderBy: {
+                    createdAt: "desc",
-                  createdAt: "desc",
+                  },
-                },
+                  select: {
-                select: {
+                    id: true,
-                  id: true,
+                    userId: true,
-                  userId: true,
+                    User: {
-                  User: {
+                      select: {
-                    select: {
+                        Profile: {
-                      Profile: {
+                          select: {
-                        select: {
+                            id: true,
-                          id: true,
+                            name: true,
-                          name: true,
+                            imageId: true,
-                          imageId: true,
+                          },
                         },
                       },
                     },
@@ -194,86 +209,109 @@ async function GET(request: Request) {
               },
             },
           },
-
+        }),
-          // User: {
+        prisma.event_Peserta.count({
-          //   select: {
+          where: {
-          //     id: true,
+            userId: userId,
-          //     username: true,
+          },
-          //     Profile: {
+        })
-          //       select: {
+      ]);
-          //         id: true,
-          //         name: true,
-          //         imageId: true,
-          //       },
-          //     },
-          //   },
-          // },
-        },
-      });
 
       fixData = data;
+      totalCount = count;
     } else if (category === "all-history") {
-      const data = await prisma.event.findMany({
+      const [data, count] = await Promise.all([
-        orderBy: {
+        prisma.event.findMany({
-          tanggal: "desc",
+          take: takeData,
-        },
+          skip: skipData,
-        where: {
+          orderBy: {
-          eventMaster_StatusId: "1",
+            tanggal: "desc",
-          isArsip: true,
+          },
-        },
+          where: {
-        select: {
+            eventMaster_StatusId: "1",
-          id: true,
+            isArsip: true,
-          title: true,
+          },
-          tanggal: true,
+          select: {
-          deskripsi: true,
+            id: true,
-          active: true,
+            title: true,
-          authorId: true,
+            tanggal: true,
-          Author: {
+            deskripsi: true,
-            select: {
+            active: true,
-              id: true,
+            authorId: true,
-              username: true,
+            Author: {
-              Profile: true,
+              select: {
+                id: true,
+                username: true,
+                Profile: true,
+              },
             },
           },
-        },
+        }),
-      });
+        prisma.event.count({
+          where: {
+            eventMaster_StatusId: "1",
+            isArsip: true,
+          },
+        })
+      ]);
 
       fixData = data;
+      totalCount = count;
     } else if (category === "my-history") {
-      const data = await prisma.event.findMany({
+      const [data, count] = await Promise.all([
-        orderBy: {
+        prisma.event.findMany({
-          tanggal: "desc",
+          take: takeData,
-        },
+          skip: skipData,
-        where: {
+          orderBy: {
-          authorId: userId,
+            tanggal: "desc",
-          eventMaster_StatusId: "1",
+          },
-          isArsip: true,
+          where: {
-        },
+            authorId: userId,
-        select: {
+            eventMaster_StatusId: "1",
-          id: true,
+            isArsip: true,
-          title: true,
+          },
-          tanggal: true,
+          select: {
-          deskripsi: true,
+            id: true,
-          active: true,
+            title: true,
-          authorId: true,
+            tanggal: true,
-          Author: {
+            deskripsi: true,
-            select: {
+            active: true,
-              id: true,
+            authorId: true,
-              username: true,
+            Author: {
-              Profile: true,
+              select: {
+                id: true,
+                username: true,
+                Profile: true,
+              },
             },
           },
-        },
+        }),
-      });
+        prisma.event.count({
+          where: {
+            authorId: userId,
+            eventMaster_StatusId: "1",
+            isArsip: true,
+          },
+        })
+      ]);
 
       fixData = data;
+      totalCount = count;
     }
 
+    const totalPages = Math.ceil(totalCount / takeData);
+
     return NextResponse.json(
       {
         success: true,
         message: "Success get event",
         data: fixData,
+        pagination: {
+          currentPage: page,
+          totalPages: totalPages,
+          totalData: totalCount,
+          dataPerPage: takeData,
+        },
       },
       { status: 200 }
     );

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

@@ -1,3 +1,4 @@
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 import prisma from "@/lib/prisma";
 import _ from "lodash";
 import { NextResponse } from "next/server";
@@ -12,6 +13,11 @@ async function GET(
     const { id, status } = params;
     const fixStatusName = _.startCase(status);
 
+    const { searchParams } = new URL(request.url);
+    const page = Number(searchParams.get("page"));
+    const takeData = PAGINATION_DEFAULT_TAKE;
+    const skipData = page ? page * takeData - takeData : 0;
+
     const data = await prisma.job.findMany({
       orderBy: {
         updatedAt: "desc",
@@ -28,13 +34,20 @@ async function GET(
         id: true,
         title: true,
       },
+      take: takeData,
+      skip: skipData,
     });
 
+
     return NextResponse.json(
       {
         success: true,
         message: "Success get job",
         data: data,
+        pagination: {
+          currentPage: page,
+          dataPerPage: takeData,
+        },
       },
       { status: 200 }
     );

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

@@ -3,6 +3,7 @@ import { routeAdminMobile } from "@/lib/mobile/route-page-mobile";
 import prisma from "@/lib/prisma";
 import { NextResponse } from "next/server";
 import { NotificationMobileBodyType } from "../../../../../types/type-mobile-notification";
+import { PAGINATION_DEFAULT_TAKE } from "@/lib/constans-value/constansValue";
 
 export { POST, GET };
 
@@ -45,7 +46,7 @@ async function POST(request: Request) {
         message: "Berhasil disimpan",
         data: create,
       },
-      { status: 201 }
+      { status: 201 },
     );
   } catch (error) {
     return NextResponse.json(
@@ -54,7 +55,7 @@ async function POST(request: Request) {
         message: "Error create job",
         reason: (error as Error).message,
       },
-      { status: 500 }
+      { status: 500 },
     );
   }
 }
@@ -64,94 +65,129 @@ async function GET(request: Request) {
   const search = searchParams.get("search");
   const category = searchParams.get("category");
   const authorId = searchParams.get("authorId");
+
+  const page = Number(searchParams.get("page")) || 1;
+  const takeData = PAGINATION_DEFAULT_TAKE;
+  const skipData = page * takeData - takeData;
   let fixData;
 
   try {
     if (category === "archive") {
-      const data = await prisma.job.findMany({
+      const [data, count] = await Promise.all([
-        where: {
+        prisma.job.findMany({
-          authorId: authorId,
+          where: {
-          isActive: true,
+            authorId: authorId,
-          isArsip: true,
+            isActive: true,
-          MasterStatus: {
+            isArsip: true,
-            name: "Publish",
+            MasterStatus: {
-          },
+              name: "Publish",
-          //   title: {
-          //     contains: search || "",
-          //     mode: "insensitive",
-          //   },
-        },
-        orderBy: {
-          createdAt: "desc",
-        },
-        select: {
-          id: true,
-          title: true,
-          deskripsi: true,
-          authorId: true,
-          MasterStatus: {
-            select: {
-              name: true,
             },
+            //   title: {
+            //     contains: search || "",
+            //     mode: "insensitive",
+            //   },
           },
-          Author: {
+          orderBy: {
-            select: {
+            createdAt: "desc",
-              id: true,
+          },
-              username: true,
+          select: {
-              Profile: {
+            id: true,
-                select: {
+            title: true,
-                  id: true,
+            deskripsi: true,
-                  name: true,
+            authorId: true,
-                  imageId: true,
+            MasterStatus: {
+              select: {
+                name: true,
+              },
+            },
+            Author: {
+              select: {
+                id: true,
+                username: true,
+                Profile: {
+                  select: {
+                    id: true,
+                    name: true,
+                    imageId: true,
+                  },
                 },
               },
             },
           },
-        },
+          take: takeData,
-      });
+          skip: skipData,
+        }),
+        prisma.job.count({
+          where: {
+            authorId: authorId,
+            isActive: true,
+            isArsip: true,
+            MasterStatus: {
+              name: "Publish",
+            },
+          },
+        }),
+      ]);
 
       fixData = data;
     } else if (category === "beranda") {
-      const data = await prisma.job.findMany({
+      const [data, count] = await Promise.all([
-        where: {
+        prisma.job.findMany({
-          isActive: true,
+          where: {
-          isArsip: false,
+            isActive: true,
-          MasterStatus: {
+            isArsip: false,
-            name: "Publish",
+            MasterStatus: {
-          },
+              name: "Publish",
-          title: {
+            },
-            contains: search || "",
+            title: {
-            mode: "insensitive",
+              contains: search || "",
-          },
+              mode: "insensitive",
-        },
-        orderBy: {
-          createdAt: "desc",
-        },
-        select: {
-          id: true,
-          title: true,
-          deskripsi: true,
-          authorId: true,
-          MasterStatus: {
-            select: {
-              name: true,
             },
           },
-          Author: {
+          orderBy: {
-            select: {
+            createdAt: "desc",
-              id: true,
+          },
-              username: true,
+          select: {
-              Profile: {
+            id: true,
-                select: {
+            title: true,
-                  id: true,
+            deskripsi: true,
-                  name: true,
+            authorId: true,
-                  imageId: true,
+            MasterStatus: {
+              select: {
+                name: true,
+              },
+            },
+            Author: {
+              select: {
+                id: true,
+                username: true,
+                Profile: {
+                  select: {
+                    id: true,
+                    name: true,
+                    imageId: true,
+                  },
                 },
               },
             },
           },
-        },
+          take: takeData,
-      });
+          skip: skipData,
+        }),
+        prisma.job.count({
+          where: {
+            isActive: true,
+            isArsip: false,
+            MasterStatus: {
+              name: "Publish",
+            },
+            title: {
+              contains: search || "",
+              mode: "insensitive",
+            },
+          },
+        }),
+      ]);
 
       fixData = data;
     }
@@ -161,8 +197,12 @@ async function GET(request: Request) {
         success: true,
         message: "Success get data job-vacancy",
         data: fixData,
+        pagination: {
+          currentPage: page,
+          dataPerPage: takeData,
+        },
       },
-      { status: 200 }
+      { status: 200 },
     );
   } catch (error) {
     return NextResponse.json(
@@ -171,7 +211,7 @@ async function GET(request: Request) {
         message: "Error get data job-vacancy",
         reason: (error as Error).message,
       },
-      { status: 500 }
+      { status: 500 },
     );
   }
 }

src/app/api/mobile/notification/[id]/route.ts

@@ -6,20 +6,22 @@ import { adminMessaging } from "@/lib/firebase-admin";
 
 export async function GET(
   request: NextRequest,
-  { params }: { params: { id: string } }
+  { params }: { params: { id: string } },
 ) {
   const { id } = params;
+  console.log("ID", id);
   const { searchParams } = new URL(request.url);
   const category = searchParams.get("category");
-
-  let fixData;
   const fixCategory = _.upperCase(category || "");
 
-  try {
+  const page = Number(searchParams.get("page"));
-    const page = Number(searchParams.get("page"));
+  console.log("page", page);
-    const takeData = 10;
+  const takeData = 10;
-    const skipData = page ? page * takeData - takeData : 0;
+  const skipData = page * takeData - takeData;
 
+  let fixData;
+
+  try {
     const data = await prisma.notifikasi.findMany({
       take: page ? takeData : undefined,
       skip: page ? skipData : undefined,
@@ -69,14 +71,14 @@ export async function GET(
   } catch (error) {
     return NextResponse.json(
       { error: (error as Error).message },
-      { status: 500 }
+      { status: 500 },
     );
   }
 }
 
 export async function PUT(
   request: NextRequest,
-  { params }: { params: { id: string } }
+  { params }: { params: { id: string } },
 ) {
   const { id } = params;
   const { searchParams } = new URL(request.url);
@@ -113,7 +115,7 @@ export async function PUT(
     console.error("Error marking notifications as read:", error);
     return NextResponse.json(
       { error: (error as Error).message },
-      { status: 500 }
+      { status: 500 },
     );
   }
 }

src/lib/constans-value/constansValue.ts

@@ -0,0 +1 @@
+export const PAGINATION_DEFAULT_TAKE = 10;

zCoba.js

@@ -1,28 +1,26 @@
-// const data = [
+const { PrismaClient } = require('@prisma/client')
-//   {
-//     authorId: "clx8pl7r90005su4mldioo0v1",
-//     Donasi: {
-//       id: "clyr304q0000410ljvzms3mag",
-//       title: "Donasi Bencana Alam Aceh",
-//     },
-//   },
-//   {
-//     authorId: "clx8pl7r90005su4mldioo0v1",
-//     Donasi: {
-//       id: "clyr304q0000410ljvzms3mag",
-//       title: "Donasi Bencana Alam Aceh",
-//     },
-//   },
-//   {
-//     authorId: "clycka5eu0001ina3i1ssgze9",
-//     Donasi: {
-//       id: "clyr304q0000410ljvzms3mag",
-//       title: "Donasi Bencana Alam Aceh",
-//     },
-//   },
-// ];
 
+const prisma = new PrismaClient()
 
-console.error("errornya disini klik aja",import.meta.url);
+async function main() {
-console.log(new Set(data.map((d) => d.authorId)));
+  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()
+  })