Fix API Mobile for QC: Ayu

Fix:
- modified:   src/app/api/mobile/admin/forum/route.ts

### No Issue

CHANGELOG.md

@@ -2,6 +2,10 @@
 
 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.5.25](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.5.24...v1.5.25) (2025-12-09)
+
+## [1.5.24](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.5.22...v1.5.24) (2025-12-08)
+
 ## [1.5.22](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.5.21...v1.5.22) (2025-12-03)
 
 ## [1.5.21](https://wibugit.wibudev.com/wibu/hipmi/compare/v1.5.20...v1.5.21) (2025-12-03)

package.json

@@ -1,6 +1,6 @@
 {
   "name": "hipmi",
-  "version": "1.5.22",
+  "version": "1.5.25",
   "private": true,
   "prisma": {
     "seed": "bun prisma/seed.ts"

prisma/migrations/20251208042529_add_accepted_terms_at/migration.sql

@@ -0,0 +1,3 @@
+-- AlterTable
+ALTER TABLE "User" ADD COLUMN     "acceptedForumTermsAt" TIMESTAMP(3),
+ADD COLUMN     "acceptedTermsAt" TIMESTAMP(3);

prisma/schema.prisma

@@ -55,6 +55,9 @@ model User {
 
   blockedUsers BlockedUser[] @relation("Blocking")
   blockedBy    BlockedUser[] @relation("BlockedBy")
+
+  acceptedTermsAt      DateTime?
+  acceptedForumTermsAt DateTime?
 }
 
 model MasterUserRole {

src/app/api/auth/mobile-register/route.ts

@@ -41,6 +41,7 @@ export async function POST(req: Request) {
         nomor: data.nomor,
         active: false,
         termsOfServiceAccepted: data.termsOfServiceAccepted,
+        acceptedTermsAt: new Date(),
       },
     });
 

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

@@ -78,6 +78,7 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
             select: {
               User: {
                 select: {
+                  nomor: true,
                   username: true,
                   id: true,
                   Profile: {

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

@@ -1,5 +1,6 @@
 import _ from "lodash";
 import { NextResponse } from "next/server";
+import prisma from "@/lib/prisma";
 
 export { GET };
 
@@ -12,7 +13,6 @@ async function GET(request: Request) {
   const skipData = Number(page) * takeData - takeData;
   console.log("[CATEGORY]", category);
   let fixData;
-
   
   try {
     if (category === "dashboard") {

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

@@ -29,6 +29,11 @@ async function GET(request: Request, { params }: { params: { id: string } }) {
             },
           },
         },
+        Event: {
+          select: {
+            tanggal: true,
+          },
+        },
       },
     });
 

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

@@ -153,6 +153,7 @@ async function GET(request: Request) {
         select: {
             id: true,
             title: true,
+            tanggal: true,
             Author: {
               select: {
                 id: true,

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

@@ -1,5 +1,6 @@
 import { NextResponse } from "next/server";
 import { prisma } from "@/lib";
+import _ from "lodash";
 
 export { GET };
 
@@ -51,7 +52,7 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
         reportComment,
       };
     } else if (category === "posting") {
-      fixData = await prisma.forum_Posting.findMany({
+      const data = await prisma.forum_Posting.findMany({
         take: page ? takeData : undefined,
         skip: page ? skipData : undefined,
         orderBy: {
@@ -75,10 +76,24 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
               Profile: true,
             },
           },
+          _count: {
+            select: {
+              Forum_ReportPosting: true,
+              Forum_Komentar: true,
+            },
+          },
         },
       });
+
+      fixData = data.map((item) => ({
+        ..._.omit(item, "_count"),
+        reportPosting: item._count.Forum_ReportPosting,
+        komentar: item._count.Forum_Komentar,
+      }));
+
+      console.log("fixData >>", fixData);
     } else if (category === "report_posting") {
-      fixData = await prisma.forum_ReportPosting.findMany({
+      const data = await prisma.forum_ReportPosting.findMany({
         take: page ? takeData : undefined,
         skip: page ? skipData : undefined,
         orderBy: {
@@ -123,8 +138,25 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
           },
         },
       });
+
+      const filterLatest = (data: any) =>
+        Object.values(
+          data.reduce((acc: any, item: any) => {
+            const key = item.Forum_Posting?.id;
+            if (!key) return acc;
+            if (
+              !acc[key] ||
+              new Date(item.createdAt) > new Date(acc[key].createdAt)
+            ) {
+              acc[key] = item;
+            }
+            return acc;
+          }, {})
+        );
+
+      fixData = filterLatest(data);
     } else if (category === "report_comment") {
-      fixData = await prisma.forum_ReportKomentar.findMany({
+      const data = await prisma.forum_ReportKomentar.findMany({
         take: page ? takeData : undefined,
         skip: page ? skipData : undefined,
         orderBy: {
@@ -160,6 +192,23 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
           },
         },
       });
+
+      const filterLatest = (data: any) =>
+        Object.values(
+          data.reduce((acc: any, item: any) => {
+            const key = item.Forum_Komentar?.id;
+            if (!key) return acc;
+            if (
+              !acc[key] ||
+              new Date(item.createdAt) > new Date(acc[key].createdAt)
+            ) {
+              acc[key] = item;
+            }
+            return acc;
+          }, {})
+        );
+
+      fixData = filterLatest(data);
     } else {
       return NextResponse.json(
         {
@@ -171,7 +220,6 @@ async function GET(request: Request, { params }: { params: { name: string } }) {
       );
     }
 
-
     return NextResponse.json(
       {
         success: true,

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

@@ -113,6 +113,7 @@ async function GET(request: Request) {
               Author: {
                 select: {
                   id: true,
+                  username: true,
                   Profile: true,
                 },
               },
@@ -141,6 +142,7 @@ async function GET(request: Request) {
           Author: {
             select: {
               id: true,
+              username: true,
               Profile: true,
             },
           },

src/app/api/mobile/forum/[id]/report-commentar/route.ts

@@ -11,6 +11,24 @@ async function POST(request: Request, { params }: { params: { id: string } }) {
   console.log("[ID]", id);
 
   try {
+    const content = await prisma.forum_Komentar.findUnique({
+      where: {
+        id: id,
+      },
+    });
+
+    const reportList = await prisma.forumMaster_KategoriReport.findUnique({
+      where: {
+        id: data.categoryId,
+      },
+    });
+
+    const msg = `Report Komentar: "${content?.komentar}" dengan kategori \n\n\n${reportList?.title} : \n\n${reportList?.deskripsi}`;
+    const res = await fetch(
+      `https://cld-dkr-prod-wajs-server.wibudev.com/api/wa/code?nom=6282340374412&text=${msg}`,
+      { cache: "no-cache" }
+    );
+
     if (data.categoryId) {
       fixData = await prisma.forum_ReportKomentar.create({
         data: {

src/app/api/mobile/forum/[id]/report-posting/route.ts

@@ -11,6 +11,18 @@ async function POST(request: Request, { params }: { params: { id: string } }) {
   console.log("[ID]", id);
 
   try {
+    const content = await prisma.forum_Posting.findUnique({
+      where: {
+        id: id,
+      },
+    });
+
+    const msg = `Report Postingan: "${content?.diskusi}"`;
+    const res = await fetch(
+      `https://cld-dkr-prod-wajs-server.wibudev.com/api/wa/code?nom=6282340374412&text=${msg}`,
+      { cache: "no-cache" }
+    );
+
     if (data.categoryId) {
       fixData = await prisma.forum_ReportPosting.create({
         data: {

src/app/api/mobile/user/[id]/terms-of-app/route.ts

@@ -0,0 +1,68 @@
+import { NextResponse } from "next/server";
+import { prisma } from "@/lib";
+
+export { POST };
+
+async function POST(request: Request, { params }: { params: { id: string } }) {
+  const { id } = params;
+  const { searchParams } = new URL(request.url);
+  const category = searchParams.get("category");
+
+  console.log("[ID USER", id);
+  console.log("[SEARCH PARAMS", category);
+
+  try {
+    const user = await prisma.user.findUnique({
+      where: {
+        id: id,
+      },
+    });
+
+    if (!user) {
+      return NextResponse.json(
+        {
+          success: false,
+          message: "User not found",
+        },
+        { status: 404 }
+      );
+    }
+
+    const updateUser = await prisma.user.update({
+      where: {
+        id: id,
+      },
+      data: {
+        acceptedForumTermsAt: new Date(),
+      },
+    });
+
+    if (!updateUser) {
+      return NextResponse.json(
+        {
+          success: false,
+          message: "Gagal mengupdate data",
+        },
+        { status: 400 }
+      );
+    }
+
+
+    return NextResponse.json(
+      {
+        success: true,
+        message: "Syarat dan Ketentuan berhasil diterima",
+      },
+      { status: 200 }
+    );
+  } catch (error) {
+    return NextResponse.json(
+      {
+        success: false,
+        message: "Error update data from API ",
+        reason: (error as Error).message,
+      },
+      { status: 500 }
+    );
+  }
+}

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

@@ -123,6 +123,10 @@ async function GET(request: Request) {
           },
         },
       });
+
+      fixData = data;
+
+      
     } else if (category === "contribution") {
       const data = await prisma.voting_Kontributor.findMany({
         orderBy: {

tsconfig.json

@@ -23,6 +23,6 @@
       "@/*": ["./src/*"]
     }
   },
-  "include": ["next-env.d.ts", "**/*.ts", "**/*.tsx", ".next/types/**/*.ts", "src/app_modules/investasi/proses_transaksi/view.jsx", "src/app/api/investasi/midtrans/[id]/route.ts", "src/app_modules/job/create/TextEdit.tsx"],
+  "include": ["next-env.d.ts", "**/*.ts", "**/*.tsx", ".next/types/**/*.ts", "src/app_modules/investasi/proses_transaksi/view.jsx", "src/app/api/investasi/midtrans/[id]/route.ts", "src/app_modules/job/create/TextEdit.tsx", "src/app/api/mobile/forum/[id]/report-comment/route.ts"],
   "exclude": ["node_modules"]
 }