feat: tambahkan village-report endpoint dengan perbandingan periode sebelumnya

- Endpoint /village-report kini menghitung activity_count periode saat ini dan prev_activity_count periode sebelumnya dalam satu query (doubleRange) - Tambahkan kalkulasi trend persentase perubahan antar periode - Sertakan data perbekel, active_users, inactive_users, lastActivity, dan daysSince - Tambahkan endpoint /export-logs dan /export-users untuk ekspor CSV
feat: tambah endpoint export-logs dan export-users untuk CSV download
2026-05-28 15:39:47 +08:00 · 2026-05-28 15:06:23 +08:00 · 2026-05-28 14:47:11 +08:00 · 2026-05-28 14:32:49 +08:00 · 2026-05-28 14:18:03 +08:00 · 2026-05-28 14:14:35 +08:00
42 changed files with 2302 additions and 2588 deletions
--- a/.env.example
+++ b/.env.example
@@ -48,6 +48,12 @@ WS_APIKEY="your-websocket-api-key"
 # API key untuk akses endpoint /api/monitoring (header: x-api-key)
 MONITORING_API_KEY="your-monitoring-api-key"

+# ===========================================
+# AI API
+# ===========================================
+# API key untuk akses endpoint /api/ai/* (header: x-api-key)
+AI_API_KEY="your-ai-api-key"
+
 # ===========================================
 # APPLICATION SETTINGS
 # ===========================================
--- a/package.json
+++ b/package.json
@@ -1,6 +1,6 @@
 {
  "name": "sistem-desa-mandiri",
-  "version": "0.1.10",
+  "version": "0.1.18",
  "private": true,
  "scripts": {
    "dev": "next dev --experimental-https",
--- a/prisma/migrations/20260512091824_auto/migration.sql
+++ b/prisma/migrations/20260512091824_auto/migration.sql
@@ -0,0 +1 @@
+-- This is an empty migration.
--- a/prisma/migrations/20260513060219_add_api_key/migration.sql
+++ b/prisma/migrations/20260513060219_add_api_key/migration.sql
@@ -0,0 +1,14 @@
+-- CreateTable
+CREATE TABLE "ApiKey" (
+    "id" TEXT NOT NULL,
+    "name" TEXT NOT NULL,
+    "key" TEXT NOT NULL,
+    "isActive" BOOLEAN NOT NULL DEFAULT true,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "ApiKey_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateIndex
+CREATE UNIQUE INDEX "ApiKey_key_key" ON "ApiKey"("key");
--- a/prisma/migrations/20260515030040_auto/migration.sql
+++ b/prisma/migrations/20260515030040_auto/migration.sql
@@ -0,0 +1 @@
+-- This is an empty migration.
--- a/prisma/migrations/20260515031651_auto/migration.sql
+++ b/prisma/migrations/20260515031651_auto/migration.sql
@@ -0,0 +1 @@
+-- This is an empty migration.
--- a/prisma/migrations/20260518071507_auto/migration.sql
+++ b/prisma/migrations/20260518071507_auto/migration.sql
@@ -0,0 +1 @@
+-- This is an empty migration.
--- a/prisma/migrations/20260519080535_auto/migration.sql
+++ b/prisma/migrations/20260519080535_auto/migration.sql
@@ -0,0 +1 @@
+-- This is an empty migration.
--- a/prisma/migrations/20260521030721_auto/migration.sql
+++ b/prisma/migrations/20260521030721_auto/migration.sql
@@ -0,0 +1 @@
+-- This is an empty migration.
--- a/prisma/migrations/20260522064632_auto/migration.sql
+++ b/prisma/migrations/20260522064632_auto/migration.sql
@@ -0,0 +1 @@
+-- This is an empty migration.
--- a/prisma/migrations/20260525073630_auto/migration.sql
+++ b/prisma/migrations/20260525073630_auto/migration.sql
@@ -0,0 +1 @@
+-- This is an empty migration.
--- a/prisma/schema.prisma
+++ b/prisma/schema.prisma
@@ -729,3 +729,12 @@ model DivisionProjectTaskApproval {
  createdAt           DateTime            @default(now())
  updatedAt           DateTime            @updatedAt
 }
+
+model ApiKey {
+  id        String   @id @default(cuid())
+  name      String
+  key       String   @unique
+  isActive  Boolean  @default(true)
+  createdAt DateTime @default(now())
+  updatedAt DateTime @updatedAt
+}
--- a/src/app/api/ai/[[...slug]]/route.ts
+++ b/src/app/api/ai/[[...slug]]/route.ts
--- a/src/app/api/ai/announcement/[id]/route.ts
+++ b/src/app/api/ai/announcement/[id]/route.ts
@@ -1,95 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import { NextResponse } from "next/server";
-
-
-// GET ONE PENGUMUMAN, UNTUK TAMPIL DETAIL PENGUMUMAN
-export async function GET(request: Request, context: { params: { id: string } }) {
-   try {
-      const { id } = context.params;
-
-      const data = await prisma.announcement.count({
-         where: {
-            id: id,
-         },
-      });
-
-      if (data == 0) {
-         return NextResponse.json(
-            {
-               success: false,
-               message: "Gagal mendapatkan pengumuman, data tidak ditemukan",
-            },
-            { status: 404 }
-         );
-      }
-
-      const announcement = await prisma.announcement.findUnique({
-         where: {
-            id: id,
-         },
-         select: {
-            id: true,
-            title: true,
-            desc: true,
-         },
-      });
-
-      if (!announcement) {
-         return NextResponse.json(
-            {
-               success: false,
-               message: "Gagal mendapatkan pengumuman, data tidak ditemukan",
-            },
-            { status: 404 }
-         );
-      }
-
-      let dataFix = { ...announcement, member: {} };
-
-      const announcementMember = await prisma.announcementMember.findMany({
-         where: {
-            idAnnouncement: id,
-         },
-         select: {
-            idGroup: true,
-            idDivision: true,
-            Group: {
-               select: {
-                  name: true,
-               },
-            },
-            Division: {
-               select: {
-                  name: true,
-               },
-            },
-         },
-      });
-
-      const formatMember = announcementMember.map((v: any) => ({
-         ..._.omit(v, ["Group", "Division"]),
-         idGroup: v.idGroup,
-         idDivision: v.idDivision,
-         group: v.Group.name,
-         division: v.Division.name
-      }))
-
-      dataFix.member = formatMember
-
-      return NextResponse.json(
-         {
-            success: true,
-            message: "Berhasil mendapatkan pengumuman",
-            data: dataFix,
-         },
-         { status: 200 }
-      );
-
-
-
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan pengumuman, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/announcement/route.ts
+++ b/src/app/api/ai/announcement/route.ts
@@ -1,52 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import "moment/locale/id";
-import { NextResponse } from "next/server";
-export const dynamic = 'force-dynamic'
-
-
-
-// GET ALL PENGUMUMAN
-export async function GET(request: Request) {
-   try {
-      const { searchParams } = new URL(request.url);
-      const judul = searchParams.get('search');
-      const page = searchParams.get('page');
-      const get = searchParams.get('get');
-      const villageId = searchParams.get('desa');
-      const active = searchParams.get('active');
-
-      let getFix = 0;
-      if (get == null || get == undefined || get == "" || _.isNaN(Number(get))) {
-         getFix = 10;
-      } else {
-         getFix = Number(get);
-      }
-
-      const dataSkip = page == null || page == undefined ? 0 : Number(page) * getFix - getFix;
-
-
-      let kondisi: any = {
-         idVillage: String(villageId),
-         isActive: (active == "false" || active == undefined) ? false : true,
-         title: {
-            contains: (judul == undefined || judul == null) ? "" : judul,
-            mode: "insensitive"
-         }
-      }
-
-      const data = await prisma.announcement.findMany({
-         skip: dataSkip,
-         take: getFix,
-         where: kondisi,
-         orderBy: {
-            createdAt: 'desc'
-         }
-      });
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan pengumuman", data, }, { status: 200 });
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan pengumuman, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/banner/[id]/route.ts
+++ b/src/app/api/ai/banner/[id]/route.ts
@@ -1,21 +0,0 @@
-import { prisma } from "@/module/_global";
-import { NextResponse } from "next/server";
-
-
-// GET ONE BANNER
-export async function GET(request: Request, context: { params: { id: string } }) {
-   try {
-      const { id } = context.params;
-
-      const data = await prisma.bannerImage.findUnique({
-         where: {
-            id: String(id)
-         }
-      })
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan banner", data }, { status: 200 });
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan banner, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/banner/route.ts
+++ b/src/app/api/ai/banner/route.ts
@@ -1,48 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import { NextResponse } from "next/server";
-
-
-// GET ALL BANNER
-export async function GET(request: Request) {
-   try {
-      const { searchParams } = new URL(request.url);
-      const judul = searchParams.get('search');
-      const page = searchParams.get('page');
-      const get = searchParams.get('get');
-      const villageId = searchParams.get('desa');
-      const active = searchParams.get('active');
-
-      let getFix = 0;
-      if (get == null || get == undefined || get == "" || _.isNaN(Number(get))) {
-         getFix = 10;
-      } else {
-         getFix = Number(get);
-      }
-
-      const dataSkip = page == null || page == undefined ? 0 : Number(page) * getFix - getFix;
-
-      let kondisi: any = {
-         idVillage: String(villageId),
-         isActive: (active == "false" || active == undefined) ? false : true,
-         title: {
-            contains: (judul == undefined || judul == null) ? "" : judul,
-            mode: "insensitive"
-         }
-      }
-
-      const data = await prisma.bannerImage.findMany({
-         skip: dataSkip,
-         take: getFix,
-         where: kondisi,
-         orderBy: {
-            createdAt: 'desc'
-         }
-      });
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan banner", data }, { status: 200 });
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan data banner, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/calendar/[id]/route.ts
+++ b/src/app/api/ai/calendar/[id]/route.ts
@@ -1,99 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import moment from "moment";
-import { NextResponse } from "next/server";
-
-// GET ONE CALENDER BY ID KALENDER REMINDER
-export async function GET(request: Request, context: { params: { id: string } }) {
-   try {
-      const { id } = context.params
-
-      const cek = await prisma.divisionCalendarReminder.count({
-         where: {
-            id: id
-         }
-      })
-
-      if (cek == 0) {
-         return NextResponse.json(
-            {
-               success: false,
-               message: "Gagal mendapatkan acara, data tidak ditemukan",
-            },
-            { status: 404 }
-         );
-      }
-
-      const data: any = await prisma.divisionCalendarReminder.findUnique({
-         where: {
-            id: id
-         },
-         select: {
-            id: true,
-            timeStart: true,
-            dateStart: true,
-            timeEnd: true,
-            createdAt: true,
-            DivisionCalendar: {
-               select: {
-                  id: true,
-                  title: true,
-                  desc: true,
-                  linkMeet: true,
-                  repeatEventTyper: true,
-                  repeatValue: true,
-               }
-            }
-         }
-      });
-      const { DivisionCalendar, ...dataCalender } = data
-      const timeStart = moment.utc(dataCalender?.timeStart).format("HH:mm")
-      const timeEnd = moment.utc(dataCalender?.timeEnd).format("HH:mm")
-      const idCalendar = data?.DivisionCalendar.id
-      const title = data?.DivisionCalendar?.title
-      const desc = data?.DivisionCalendar?.desc
-      const linkMeet = data?.DivisionCalendar?.linkMeet
-      const repeatEventTyper = data?.DivisionCalendar?.repeatEventTyper
-      const repeatValue = data?.DivisionCalendar?.repeatValue
-
-
-      const result = { ...dataCalender, timeStart, timeEnd, title, desc, linkMeet, repeatEventTyper, repeatValue }
-
-
-      const member = await prisma.divisionCalendarMember.findMany({
-         where: {
-            idCalendar
-         },
-         select: {
-            id: true,
-            idUser: true,
-            User: {
-               select: {
-                  id: true,
-                  name: true,
-                  email: true,
-                  img: true
-               }
-            }
-         }
-      })
-      const fixMember = member.map((v: any) => ({
-         ..._.omit(v, ["User"]),
-         name: v.User.name,
-         email: v.User.email,
-         img: v.User.img
-      }))
-
-
-      const dataFix = {
-         ...result,
-         member: fixMember,
-      }
-
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan kalender", data: dataFix }, { status: 200 });
-
-   } catch (error) {
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan kalender, data tidak ditemukan (error: 500)", }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/calendar/route.ts
+++ b/src/app/api/ai/calendar/route.ts
@@ -1,149 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import moment from "moment";
-import "moment/locale/id";
-import { NextResponse } from "next/server";
-
-//GET ALL CALENDER
-export async function GET(request: Request) {
-   try {
-
-      const { searchParams } = new URL(request.url);
-      const idDivision = searchParams.get("division");
-      const isDate = searchParams.get("date")
-      const villageId = searchParams.get("desa")
-      const active = searchParams.get("active")
-      const search = searchParams.get("search")
-      const page = searchParams.get("page")
-      const get = searchParams.get("get")
-
-      let getFix = 0;
-      if (get == null || get == undefined || get == "" || _.isNaN(Number(get))) {
-         getFix = 10;
-      } else {
-         getFix = Number(get);
-      }
-
-
-
-      const dataSkip = page == null || page == undefined ? 0 : Number(page) * getFix - getFix;
-
-
-      let kondisi: any = {}
-
-      if (idDivision != "" && idDivision != null && idDivision != undefined) {
-         if (isDate != null && isDate != undefined && isDate != "") {
-            kondisi = {
-               idDivision: String(idDivision),
-               dateStart: new Date(String(isDate)),
-               DivisionCalendar: {
-                  title: {
-                     contains: (search == undefined || search == null) ? "" : search,
-                     mode: "insensitive"
-                  },
-                  isActive: (active == "false" || active == undefined) ? false : true,
-                  Division: {
-                     idVillage: String(villageId)
-                  }
-               }
-            }
-         } else {
-            kondisi = {
-               idDivision: String(idDivision),
-               DivisionCalendar: {
-                  title: {
-                     contains: (search == undefined || search == null) ? "" : search,
-                     mode: "insensitive"
-                  },
-                  isActive: (active == "false" || active == undefined) ? false : true,
-                  Division: {
-                     idVillage: String(villageId)
-                  }
-               }
-            }
-         }
-      } else {
-         if (isDate != null && isDate != undefined && isDate != "") {
-            kondisi = {
-               dateStart: new Date(String(isDate)),
-               DivisionCalendar: {
-                  title: {
-                     contains: (search == undefined || search == null) ? "" : search,
-                     mode: "insensitive"
-                  },
-                  isActive: (active == "false" || active == undefined) ? false : true,
-                  Division: {
-                     idVillage: String(villageId)
-                  }
-               }
-            }
-         } else {
-            kondisi = {
-               DivisionCalendar: {
-                  title: {
-                     contains: (search == undefined || search == null) ? "" : search,
-                     mode: "insensitive"
-                  },
-                  isActive: (active == "false" || active == undefined) ? false : true,
-                  Division: {
-                     idVillage: String(villageId)
-                  }
-               }
-            }
-         }
-      }
-
-      const data = await prisma.divisionCalendarReminder.findMany({
-         where: kondisi,
-         skip: dataSkip,
-         take: getFix,
-         select: {
-            id: true,
-            dateStart: true,
-            timeStart: true,
-            timeEnd: true,
-            createdAt: true,
-            DivisionCalendar: {
-               select: {
-                  isActive: true,
-                  title: true,
-                  desc: true,
-                  User: {
-                     select: {
-                        name: true
-                     }
-                  }
-               }
-            }
-         },
-         orderBy: [
-            {
-               dateStart: 'asc'
-            },
-            {
-               timeStart: 'asc'
-            },
-            {
-               timeEnd: 'asc'
-            }
-         ]
-      });
-
-      const allOmit = data.map((v: any) => ({
-         ..._.omit(v, ["DivisionCalendar", "User"]),
-         title: v.DivisionCalendar.title,
-         desc: v.DivisionCalendar.desc,
-         createdBy: v.DivisionCalendar.User.name,
-         isActive: v.DivisionCalendar.isActive,
-         timeStart: moment.utc(v.timeStart).format('HH:mm'),
-         timeEnd: moment.utc(v.timeEnd).format('HH:mm')
-      }))
-
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan kalender", data: allOmit }, { status: 200 });
-
-   } catch (error) {
-      console.error(error)
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan kalender, data tidak ditemukan (error: 500)" }, { status: 404 });
-   }
-}
--- a/src/app/api/ai/discussion-general/[id]/route.ts
+++ b/src/app/api/ai/discussion-general/[id]/route.ts
@@ -1,117 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import { NextResponse } from "next/server";
-
-
-// GET ONE DETAIL DISKUSI UMUM
-export async function GET(request: Request, context: { params: { id: string } }) {
-   try {
-      let dataFix
-      const { id } = context.params
-
-      const { searchParams } = new URL(request.url);
-      const kategori = searchParams.get("cat");
-      const idVillage = searchParams.get("desa");
-
-      const cek = await prisma.discussion.count({
-         where: {
-            id,
-            idVillage: String(idVillage)
-         }
-      })
-
-      if (cek == 0) {
-         return NextResponse.json({ success: false, message: "Gagal mendapatkan diskusi, data tidak ditemukan" }, { status: 404 });
-      }
-
-      if (kategori == "comment") {
-         const data = await prisma.discussionComment.findMany({
-            where: {
-               idDiscussion: id,
-               isActive: true
-            },
-            select: {
-               id: true,
-               comment: true,
-               createdAt: true,
-               idUser: true,
-               User: {
-                  select: {
-                     name: true,
-                     img: true
-                  }
-               }
-            }
-         })
-
-         dataFix = data.map((v: any) => ({
-            ..._.omit(v, ["User",]),
-            username: v.User.name,
-            img: v.User.img
-         }))
-
-      } else if (kategori == "member") {
-         const data = await prisma.discussionMember.findMany({
-            where: {
-               idDiscussion: id,
-               isActive: true
-            },
-            select: {
-               idUser: true,
-               User: {
-                  select: {
-                     name: true,
-                     img: true
-                  }
-               }
-            }
-         })
-
-         dataFix = data.map((v: any) => ({
-            ..._.omit(v, ["User",]),
-            name: v.User.name,
-            img: v.User.img
-         }))
-      } else {
-         const data = await prisma.discussion.findUnique({
-            where: {
-               id,
-               idVillage: String(idVillage)
-            },
-            select: {
-               isActive: true,
-               id: true,
-               title: true,
-               idGroup: true,
-               desc: true,
-               status: true,
-               createdAt: true,
-               Group: {
-                  select: {
-                     name: true,
-                  }
-               }
-            }
-         })
-
-         dataFix = {
-            id: data?.id,
-            isActive: data?.isActive,
-            idGroup: data?.idGroup,
-            group: data?.Group.name,
-            title: data?.title,
-            desc: data?.desc,
-            status: data?.status == 1 ? "Open" : "Close",
-            createdAt: data?.createdAt
-         }
-      }
-
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan diskusi", data: dataFix }, { status: 200 });
-
-
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan diskusi, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/discussion-general/route.ts
+++ b/src/app/api/ai/discussion-general/route.ts
@@ -1,92 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import "moment/locale/id";
-import { NextResponse } from "next/server";
-
-
-// GET ALL DISCUSSION GENERAL
-export async function GET(request: Request) {
-   try {
-      const { searchParams } = new URL(request.url);
-      const idGroup = searchParams.get("group");
-      const idVillage = searchParams.get("desa");
-      const search = searchParams.get('search');
-      const page = searchParams.get('page');
-      const status = searchParams.get('status');
-      const active = searchParams.get('active');
-      const get = searchParams.get('get')
-
-
-      let getFix = 10;
-      if (get == null || get == undefined || get == "" || _.isNaN(Number(get))) {
-         getFix = 10;
-      } else {
-         getFix = Number(get);
-      }
-
-      const dataSkip = page == null || page == undefined ? 0 : Number(page) * getFix - getFix;
-
-      let kondisi: any = {
-         isActive: active == "false" ? false : true,
-         status: status == "close" ? 2 : 1,
-         idVillage: String(idVillage),
-         title: {
-            contains: (search == undefined || search == "null") ? "" : search,
-            mode: "insensitive"
-         },
-      }
-
-      if (idGroup != "null" && idGroup != undefined && idGroup != "") {
-         kondisi = {
-            ...kondisi,
-            idGroup: String(idGroup)
-         }
-      }
-
-
-      const data = await prisma.discussion.findMany({
-         skip: dataSkip,
-         take: getFix,
-         where: kondisi,
-         orderBy: [
-            {
-               status: 'desc'
-            },
-            {
-               createdAt: 'desc'
-            }
-         ],
-
-         select: {
-            id: true,
-            title: true,
-            desc: true,
-            status: true,
-            createdAt: true,
-            DiscussionComment: {
-               select: {
-                  id: true,
-               }
-            },
-            Group: {
-               select: {
-                  name: true,
-               }
-            }
-         }
-      });
-
-      const fixData = data.map((v: any) => ({
-         ..._.omit(v, ["DiscussionComment", "status", "Group"]),
-         totalKomentar: v.DiscussionComment.length,
-         status: v.status == 1 ? "Open" : "Close",
-         group: v.Group.name,
-      }))
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan diskusi", data: fixData }, { status: 200 });
-
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan diskusi, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/discussion/[id]/route.ts
+++ b/src/app/api/ai/discussion/[id]/route.ts
@@ -1,92 +0,0 @@
-import { prisma } from "@/module/_global";
-import { NextResponse } from "next/server";
-
-// GET ONE DISCUSSION BY ID
-export async function GET(request: Request, context: { params: { id: string } }) {
-   try {
-      const { id } = context.params
-
-      const cek = await prisma.divisionDisscussion.count({
-         where: { id }
-      })
-
-      if (cek == 0) {
-         return NextResponse.json(
-            { success: false, message: "Gagal mendapatkan diskusi, data tidak ditemukan" },
-            { status: 404 }
-         );
-      }
-
-      const data = await prisma.divisionDisscussion.findUnique({
-         where: { id },
-         select: {
-            isActive: true,
-            id: true,
-            desc: true,
-            status: true,
-            createdAt: true,
-            idDivision: true,
-            Division: {
-               select: {
-                  name: true,
-               }
-            },
-            User: { select: { name: true, img: true } },
-            DivisionDisscussionComment: {
-               select: {
-                  id: true,
-                  comment: true,
-                  createdAt: true,
-                  User: { select: { name: true, img: true } }
-               }
-            },
-         }
-      });
-
-      if (!data) {
-         return NextResponse.json(
-            { success: false, message: "Diskusi tidak ditemukan" },
-            { status: 404 }
-         );
-      }
-
-      // ambil nama creator
-      const createdBy = data.User.name;
-      const status = data.status == 1 ? "Open" : "Close"
-      const division = data.Division.name
-
-      // mapping komentar → hilangkan nested User
-      const komentar = data.DivisionDisscussionComment.map((comment: any) => ({
-         id: comment.id,
-         comment: comment.comment,
-         createdAt: comment.createdAt,
-         username: comment.User.name,
-         userimg: comment.User.img,
-      }));
-
-      // bentuk hasil akhir sesuai request
-      const result = {
-         id: data.id,
-         idDivision: data.idDivision,
-         division,
-         isActive: data.isActive,
-         desc: data.desc,
-         status,
-         createdAt: data.createdAt,
-         createdBy,
-         komentar,
-      };
-
-      return NextResponse.json(
-         { success: true, message: "Berhasil mendapatkan diskusi", data: result },
-         { status: 200 }
-      );
-
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json(
-         { success: false, message: "Gagal mendapatkan diskusi, coba lagi nanti (error: 500)", reason: (error as Error).message },
-         { status: 500 }
-      );
-   }
-}
--- a/src/app/api/ai/discussion/route.ts
+++ b/src/app/api/ai/discussion/route.ts
@@ -1,95 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import "moment/locale/id";
-import { NextResponse } from "next/server";
-
-
-// GET ALL DISCUSSION DIVISION ACTIVE = TRUE
-export async function GET(request: Request) {
-   try {
-      const { searchParams } = new URL(request.url);
-      const idDivision = searchParams.get("division");
-      const search = searchParams.get('search');
-      const page = searchParams.get('page');
-      const status = searchParams.get('status');
-      const isActive = searchParams.get('active');
-      const villageId = searchParams.get('desa');
-      const get = searchParams.get('get');
-
-      let getFix = 0;
-      if (get == null || get == undefined || get == "" || _.isNaN(Number(get))) {
-         getFix = 10;
-      } else {
-         getFix = Number(get);
-      }
-
-      const dataSkip = page == null || page == undefined ? 0 : Number(page) * getFix - getFix;
-
-      let kondisi: any = {
-         isActive: isActive == "false" ? false : true,
-         status: status == "close" ? 2 : 1,
-         Division: {
-            idVillage: String(villageId)
-         },
-         desc: {
-            contains: (search == undefined || search == "null") ? "" : search,
-            mode: "insensitive"
-         },
-      }
-
-
-      if (idDivision != "null" && idDivision != null && idDivision != undefined) {
-         kondisi = {
-            isActive: isActive == "false" ? false : true,
-            status: status == "close" ? 2 : 1,
-            idDivision: idDivision,
-            Division: {
-               idVillage: String(villageId)
-            },
-            desc: {
-               contains: (search == undefined || search == "null") ? "" : search,
-               mode: "insensitive"
-            },
-         }
-      }
-
-      const data = await prisma.divisionDisscussion.findMany({
-         skip: dataSkip,
-         take: getFix,
-         where: kondisi,
-         orderBy: {
-            createdAt: 'desc'
-         },
-         select: {
-            id: true,
-            desc: true,
-            status: true,
-            createdAt: true,
-            idDivision: true,
-            Division: {
-               select: {
-                  name: true,
-               }
-            },
-            DivisionDisscussionComment: {
-               select: {
-                  id: true,
-               }
-            }
-         }
-      });
-
-      const fixData = data.map((v: any) => ({
-         ..._.omit(v, ["DivisionDisscussionComment", "status", "Division"]),
-         totalKomentar: v.DivisionDisscussionComment.length,
-         status: v.status == 1 ? "Open" : "Close",
-         division: v.Division.name
-      }))
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan diskusi", data: fixData, }, { status: 200 });
-
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan diskusi, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/division/[id]/route.ts
+++ b/src/app/api/ai/division/[id]/route.ts
@@ -1,63 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import { NextResponse } from "next/server";
-
-
-// GET ONE DATA DIVISI :: UNTUK TAMPIL DATA DI HALAMAN EDIT DAN INFO
-export async function GET(request: Request, context: { params: { id: string } }) {
-   try {
-      const { id } = context.params;
-      const { searchParams } = new URL(request.url);
-      const idVillage = searchParams.get("desa");
-
-      const data = await prisma.division.findUnique({
-         where: {
-            id: String(id),
-            idVillage: String(idVillage)
-         }
-      });
-
-      if (!data) {
-         return NextResponse.json({ success: false, message: "Gagal mendapatkan divisi, data tidak ditemukan", }, { status: 404 });
-      }
-
-      const member = await prisma.divisionMember.findMany({
-         where: {
-            idDivision: String(id),
-            isActive: true,
-         },
-         select: {
-            id: true,
-            isAdmin: true,
-            idUser: true,
-            User: {
-               select: {
-                  name: true,
-                  img: true
-               }
-            }
-         },
-         orderBy: {
-            isAdmin: 'desc',
-         }
-      })
-
-      const fixMember = member.map((v: any) => ({
-         ..._.omit(v, ["User"]),
-         name: v.User.name,
-         img: v.User.img
-      }))
-
-      const dataFix = {
-         ...data,
-         member: fixMember
-      }
-
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan divisi", data: dataFix, }, { status: 200 });
-
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan divisi, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/division/report/route.ts
+++ b/src/app/api/ai/division/report/route.ts
@@ -1,269 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import { NextResponse } from "next/server";
-
-export async function GET(request: Request) {
-   try {
-      const { searchParams } = new URL(request.url)
-      const idVillage = searchParams.get("desa")
-      const idGroup = searchParams.get("group")
-      const division = searchParams.get("division")
-      const date = searchParams.get("date-start")
-      const dateAkhir = searchParams.get("date-end")
-      const kat = searchParams.get("cat")
-
-
-      // CHART PROGRESS
-      if (kat == "dokumen") {
-         // CHART DOKUMEN
-         let kondisi: any = {
-            isActive: true,
-            category: 'FILE',
-            Division: {
-               idVillage: String(idVillage)
-            },
-            createdAt: {
-               gte: new Date(String(date)),
-               lte: new Date(String(dateAkhir))
-            },
-         }
-
-         if (idGroup != undefined && idGroup != null && idGroup != "") {
-            kondisi = {
-               isActive: true,
-               category: 'FILE',
-               Division: {
-                  idGroup: String(idGroup)
-               },
-               createdAt: {
-                  gte: new Date(String(date)),
-                  lte: new Date(String(dateAkhir))
-               },
-            }
-         }
-
-
-         if (division != undefined && division != null && division != "") {
-            kondisi = {
-               ...kondisi,
-               idDivision: String(division)
-            }
-         }
-
-
-         const dataDokumen = await prisma.divisionDocumentFolderFile.findMany({
-            where: kondisi,
-         })
-
-         const groupData = _.map(_.groupBy(dataDokumen, "extension"), (v: any) => ({
-            file: v[0].extension,
-            jumlah: v.length,
-         }))
-
-         const image = ['jpg', 'jpeg', 'png', 'heic']
-
-         let hasilImage = {
-            name: 'Gambar',
-            value: 0
-         }
-
-         let hasilFile = {
-            name: 'Dokumen',
-            value: 0
-         }
-
-         groupData.map((v: any) => {
-            if (image.some((i: any) => i == v.file)) {
-               hasilImage = {
-                  name: 'Gambar',
-                  value: hasilImage.value + v.jumlah
-               }
-            } else {
-               hasilFile = {
-                  name: 'Dokumen',
-                  value: hasilFile.value + v.jumlah
-               }
-            }
-         })
-
-         const hasilDokumen = { gambar: hasilImage.value, dokumen: hasilFile.value }
-
-         return NextResponse.json({ success: true, message: "Berhasil mendapatkan data", data: hasilDokumen }, { status: 200 });
-      } else if (kat == "event") {
-         // CHART EVENT
-         let kondisiSelesai: any = {
-            isActive: true,
-            Division: {
-               idVillage: String(idVillage)
-            },
-            DivisionCalendarReminder: {
-               some: {
-                  dateStart: {
-                     gte: new Date(String(date)),
-                     lte: new Date()
-                  }
-               }
-            }
-         }
-
-         let kondisiComingSoon: any = {
-            isActive: true,
-            Division: {
-               idVillage: String(idVillage)
-            },
-            DivisionCalendarReminder: {
-               some: {
-                  dateStart: {
-                     gt: new Date(),
-                     lte: new Date(String(dateAkhir))
-                  }
-               }
-            }
-         }
-
-         if (idGroup != undefined && idGroup != null && idGroup != "") {
-            kondisiSelesai = {
-               isActive: true,
-               Division: {
-                  idGroup: String(idGroup)
-               },
-               DivisionCalendarReminder: {
-                  some: {
-                     dateStart: {
-                        gte: new Date(String(date)),
-                        lte: new Date()
-                     }
-                  }
-               }
-            }
-
-            kondisiComingSoon = {
-               isActive: true,
-               Division: {
-                  idGroup: String(idGroup)
-               },
-               DivisionCalendarReminder: {
-                  some: {
-                     dateStart: {
-                        gt: new Date(),
-                        lte: new Date(String(dateAkhir))
-                     }
-                  }
-               }
-            }
-         }
-
-         if (division != undefined && division != null && division != "") {
-            kondisiSelesai = {
-               ...kondisiSelesai,
-               idDivision: String(division)
-            }
-
-            kondisiComingSoon = {
-               ...kondisiComingSoon,
-               idDivision: String(division)
-            }
-         }
-
-         const eventSelesai = await prisma.divisionCalendar.count({
-            where: kondisiSelesai
-         })
-
-         const eventComingSoon = await prisma.divisionCalendar.count({
-            where: kondisiComingSoon
-         })
-
-         const hasilEvent = {
-            selesai: eventSelesai,
-            akan_datang: eventComingSoon
-         }
-
-         return NextResponse.json({ success: true, message: "Berhasil mendapatkan data", data: hasilEvent }, { status: 200 });
-
-      } else {
-         let kondisiProgress: any = {
-            isActive: true,
-            Division: {
-               idVillage: String(idVillage)
-            },
-            DivisionProjectTask: {
-               some: {
-                  dateStart: {
-                     gte: new Date(String(date))
-                  },
-                  dateEnd: {
-                     lte: new Date(String(dateAkhir))
-                  }
-               }
-            }
-         }
-
-         if (idGroup != undefined && idGroup != null && idGroup != "") {
-            kondisiProgress = {
-               isActive: true,
-               Division: {
-                  idGroup: String(idGroup)
-               },
-               DivisionProjectTask: {
-                  some: {
-                     dateStart: {
-                        gte: new Date(String(date))
-                     },
-                     dateEnd: {
-                        lte: new Date(String(dateAkhir))
-                     }
-                  }
-               }
-            }
-         }
-
-         if (division != undefined && division != null && division != "") {
-            kondisiProgress = {
-               ...kondisiProgress,
-               idDivision: String(division)
-            }
-         }
-
-         const data = await prisma.divisionProject.groupBy({
-            where: kondisiProgress,
-            by: ["status"],
-            _count: true
-         })
-
-         const dataStatus = [{ name: 'Segera', status: 0 }, { name: 'Dikerjakan', status: 1 }, { name: 'Selesai', status: 2 }, { name: 'Dibatalkan', status: 3 }]
-         const hasilProgres: any[] = []
-         let input
-         for (let index = 0; index < dataStatus.length; index++) {
-            const cek = data.some((i: any) => i.status == dataStatus[index].status)
-            if (cek) {
-               const find = ((Number(data.find((i: any) => i.status == dataStatus[index].status)?._count) * 100) / data.reduce((n, { _count }) => n + _count, 0)).toFixed(2)
-               const fix = find != "100.00" ? find.substr(-2, 2) == "00" ? find.substr(0, 2) : find : "100"
-               input = {
-                  name: dataStatus[index].name,
-                  value: fix
-               }
-            } else {
-               input = {
-                  name: dataStatus[index].name,
-                  value: 0
-               }
-            }
-            hasilProgres.push(input)
-         }
-
-         const dataFixProgress = hasilProgres.reduce((acc: any, curr: any) => {
-            acc[curr.name] = curr.value
-            return acc
-         }, {})
-
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan data", data: dataFixProgress }, { status: 200 });
-
-      }
-
-   }
-   catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan data, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/division/route.ts
+++ b/src/app/api/ai/division/route.ts
@@ -1,84 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import { NextResponse } from "next/server";
-
-
-// GET ALL DATA DIVISI == LIST DATA DIVISI
-export async function GET(request: Request) {
-   try {
-      const { searchParams } = new URL(request.url);
-      const idVillage = searchParams.get("desa");
-      const idGroup = searchParams.get("group");
-      const name = searchParams.get('search');
-      const page = searchParams.get('page');
-      const active = searchParams.get("active");
-      const get = searchParams.get('get')
-
-      let getFix = 10;
-      if (get == null || get == undefined || get == "" || _.isNaN(Number(get))) {
-         getFix = 10;
-      } else {
-         getFix = Number(get);
-      }
-
-      const dataSkip = page == null || page == undefined ? 0 : Number(page) * getFix - getFix;
-
-      let kondisi: any = {
-         isActive: active == 'false' ? false : true,
-         idVillage: String(idVillage),
-         name: {
-            contains: (name == undefined || name == "null") ? "" : name,
-            mode: "insensitive"
-         }
-      }
-
-      if (idGroup != "null" && idGroup != undefined && idGroup != "") {
-         kondisi = {
-            ...kondisi,
-            idGroup: String(idGroup)
-         }
-      }
-
-
-      const data = await prisma.division.findMany({
-         skip: dataSkip,
-         take: getFix,
-         where: kondisi,
-         select: {
-            id: true,
-            name: true,
-            desc: true,
-            idGroup: true,
-            Group: {
-               select: {
-                  name: true
-               }
-            },
-            DivisionMember: {
-               where: {
-                  isActive: true
-               },
-               select: {
-                  idUser: true
-               }
-            }
-         },
-         orderBy: {
-            createdAt: 'desc'
-         }
-      });
-
-      const allData = data.map((v: any) => ({
-         ..._.omit(v, ["DivisionMember", "Group"]),
-         group: v.Group.name,
-         jumlahMember: v.DivisionMember.length,
-      }))
-
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan divisi", data: allData }, { status: 200 });
-
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan divisi, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/document/route.ts
+++ b/src/app/api/ai/document/route.ts
@@ -1,145 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import moment from "moment";
-import { NextResponse } from "next/server";
-
-
-// GET ALL DOCUMENT
-export async function GET(request: Request) {
-   try {
-      const { searchParams } = new URL(request.url);
-      const idDivision = searchParams.get("division");
-      const villageId = searchParams.get("desa");
-      const path = searchParams.get("path");
-      const active = searchParams.get("active");
-      const search = searchParams.get("search");
-      const page = searchParams.get("page");
-      const get = searchParams.get("get");
-
-      let getFix = 10;
-      if (get == null || get == undefined || get == "" || _.isNaN(Number(get))) {
-         getFix = 10;
-      } else {
-         getFix = Number(get);
-      }
-
-      const dataSkip = page == null || page == undefined ? 0 : Number(page) * getFix - getFix;
-
-      let kondisi: any = {
-         Division: {
-            idVillage: String(villageId)
-         },
-         isActive: active == 'false' ? false : true,
-         path: (path == "undefined" || path == "null" || path == "" || path == null || path == undefined) ? "home" : path,
-         name: {
-            contains: (search == undefined || search == "null") ? "" : search,
-            mode: "insensitive"
-         }
-      }
-
-      if (idDivision != "null" && idDivision != undefined && idDivision != "") {
-         kondisi = {
-            ...kondisi,
-            idDivision: String(idDivision)
-         }
-      }
-
-      let formatDataShare: any[] = [];
-
-      if (path == "home" || path == "null" || path == "undefined" || path == null || path == undefined || path == "") {
-         const dataShare = await prisma.divisionDocumentShare.findMany({
-            where: {
-               isActive: true,
-               idDivision: String(idDivision),
-               DivisionDocumentFolderFile: {
-                  isActive: true
-               }
-            },
-            select: {
-               DivisionDocumentFolderFile: {
-                  select: {
-                     idStorage: true,
-                     id: true,
-                     category: true,
-                     name: true,
-                     extension: true,
-                     path: true,
-                     User: {
-                        select: {
-                           name: true
-                        }
-                     },
-                     createdAt: true,
-                     updatedAt: true
-                  }
-               }
-            },
-            orderBy: {
-               DivisionDocumentFolderFile: {
-                  createdAt: 'desc'
-               }
-            }
-         })
-
-         formatDataShare = dataShare.map((v: any) => ({
-            ..._.omit(v, ["DivisionDocumentFolderFile"]),
-            idStorage: v.DivisionDocumentFolderFile.idStorage,
-            id: v.DivisionDocumentFolderFile.id,
-            category: v.DivisionDocumentFolderFile.category,
-            name: v.DivisionDocumentFolderFile.name,
-            extension: v.DivisionDocumentFolderFile.extension,
-            path: v.DivisionDocumentFolderFile.path,
-            createdBy: v.DivisionDocumentFolderFile.User.name,
-            createdAt: v.DivisionDocumentFolderFile.createdAt,
-            updatedAt: v.DivisionDocumentFolderFile.updatedAt,
-            share: true
-         }))
-      }
-
-
-      const data = await prisma.divisionDocumentFolderFile.findMany({
-         skip: dataSkip,
-         take: getFix,
-         where: kondisi,
-         select: {
-            id: true,
-            category: true,
-            name: true,
-            extension: true,
-            idStorage: true,
-            path: true,
-            User: {
-               select: {
-                  name: true
-               }
-            },
-            createdAt: true,
-            updatedAt: true
-         },
-         orderBy: {
-            createdAt: 'desc'
-         }
-      })
-
-      const allData = data.map((v: any) => ({
-         ..._.omit(v, ["User", "createdAt", "updatedAt"]),
-         createdBy: v.User.name,
-         createdAt: v.createdAt,
-         updatedAt: v.updatedAt,
-         share: false
-      }))
-
-      if (formatDataShare.length > 0) {
-         allData.push(...formatDataShare)
-      }
-
-      const formatData = _.orderBy(allData, ['category', 'createdAt'], ['desc', 'desc']);
-
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan item", data: formatData }, { status: 200 });
-
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan item, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/group/route.ts
+++ b/src/app/api/ai/group/route.ts
@@ -1,45 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import { NextResponse } from "next/server";
-
-export async function GET(request: Request) {
-   try {
-      const { searchParams } = new URL(request.url);
-      const villageId = searchParams.get("desa");
-      const isActive = searchParams.get("active");
-      const search = searchParams.get('search');
-      const page = searchParams.get('page')
-      const get = searchParams.get('get')
-
-      let getFix = 10;
-      if (get == null || get == undefined || get == "" || _.isNaN(Number(get))) {
-         getFix = 10;
-      } else {
-         getFix = Number(get);
-      }
-
-      const dataSkip = page == null || page == undefined ? 0 : Number(page) * getFix - getFix;
-
-      const data = await prisma.group.findMany({
-         skip: dataSkip,
-         take: getFix,
-         where: {
-            isActive: isActive == 'false' ? false : true,
-            idVillage: String(villageId),
-            name: {
-               contains: (search == undefined || search == null) ? "" : search,
-               mode: "insensitive"
-            }
-         },
-         orderBy: {
-            name: 'asc'
-         }
-      });
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan grup", data, }, { status: 200 });
-
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan grup, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/position/route.ts
+++ b/src/app/api/ai/position/route.ts
@@ -1,79 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import { NextResponse } from "next/server";
-
-
-// GET ALL POSITION
-export async function GET(request: Request) {
-   try {
-      const { searchParams } = new URL(request.url);
-      const idVillage = searchParams.get("desa");
-      const idGroup = searchParams.get("group");
-      const active = searchParams.get('active');
-      const search = searchParams.get('search')
-      const page = searchParams.get('page')
-      const get = searchParams.get('get')
-
-      let getFix = 10;
-      if (get == null || get == undefined || get == "" || _.isNaN(Number(get))) {
-         getFix = 10;
-      } else {
-         getFix = Number(get);
-      }
-
-      const dataSkip = page == null || page == undefined ? 0 : Number(page) * getFix - getFix;
-
-      let kondisi: any = {
-         isActive: active == 'false' ? false : true,
-         Group: {
-            idVillage: String(idVillage)
-         },
-         name: {
-            contains: (search == undefined || search == null) ? "" : search,
-            mode: "insensitive"
-         }
-      }
-
-      if (idGroup != "null" && idGroup != undefined && idGroup != "") {
-         kondisi = {
-            ...kondisi,
-            idGroup: String(idGroup)
-         }
-      }
-
-
-
-      const positions = await prisma.position.findMany({
-         skip: dataSkip,
-         take: getFix,
-         where: kondisi,
-         select: {
-            id: true,
-            name: true,
-            idGroup: true,
-            isActive: true,
-            createdAt: true,
-            updatedAt: true,
-            Group: {
-               select: {
-                  name: true
-               }
-            }
-         },
-         orderBy: {
-            name: 'asc'
-         }
-      });
-
-      const allData = positions.map((v: any) => ({
-         ..._.omit(v, ["Group"]),
-         group: v.Group.name
-      }))
-
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan jabatan", data: allData }, { status: 200 });
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan jabatan, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/project/[id]/route.ts
+++ b/src/app/api/ai/project/[id]/route.ts
@@ -1,172 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import moment from "moment";
-import { NextResponse } from "next/server";
-
-
-// GET DETAIL PROJECT / GET ONE PROJECT
-export async function GET(request: Request, context: { params: { id: string } }) {
-   try {
-      let allData
-      const { id } = context.params;
-      const { searchParams } = new URL(request.url);
-      const kategori = searchParams.get("cat");
-
-      const data = await prisma.project.findUnique({
-         where: {
-            id: String(id),
-         },
-         select: {
-            id: true,
-            idVillage: true,
-            idGroup: true,
-            title: true,
-            status: true,
-            desc: true,
-            reason: true,
-            report: true,
-            isActive: true,
-            Group: {
-               select: {
-                  name: true
-               }
-            }
-         }
-      });
-
-      if (!data) {
-         return NextResponse.json({ success: false, message: "Gagal mendapatkan kegiatan, data tidak ditemukan", }, { status: 404 });
-      }
-
-
-      if (kategori == "data") {
-         const dataProgress = await prisma.projectTask.findMany({
-            where: {
-               isActive: true,
-               idProject: String(id)
-            },
-            orderBy: {
-               updatedAt: 'desc'
-            }
-         })
-
-         const semua = dataProgress.length
-         const selesai = _.filter(dataProgress, { status: 1 }).length
-         const progress = Math.ceil((selesai / semua) * 100)
-
-         allData = {
-            id: data.id,
-            idVillage: data.idVillage,
-            idGroup: data.idGroup,
-            group: data.Group.name,
-            title: data.title,
-            status: data.status == 3 ? "batal" : data.status == 2 ? "selesai" : data.status == 1 ? "dikerjakan" : "segera",
-            desc: data.desc,
-            reason: data.reason,
-            report: data.report,
-            isActive: data.isActive,
-            progress: (_.isNaN(progress)) ? 0 : progress,
-         }
-
-      } else if (kategori == "task") {
-         const dataProgress = await prisma.projectTask.findMany({
-            where: {
-               isActive: true,
-               idProject: String(id)
-            },
-            select: {
-               id: true,
-               title: true,
-               desc: true,
-               status: true,
-               dateStart: true,
-               dateEnd: true,
-               createdAt: true
-            },
-            orderBy: {
-               createdAt: 'asc'
-            }
-         })
-
-         const formatData = dataProgress.map((v: any) => ({
-            ..._.omit(v, ["dateStart", "dateEnd", "createdAt", "status"]),
-            status: v.status == 1 ? "selesai" : "belum selesai",
-            dateStart: moment(v.dateStart).format("DD-MM-YYYY"),
-            dateEnd: moment(v.dateEnd).format("DD-MM-YYYY"),
-            createdAt: moment(v.createdAt).format("DD-MM-YYYY HH:mm"),
-         }))
-         const dataFix = _.orderBy(formatData, 'createdAt', 'asc')
-         allData = dataFix
-
-      } else if (kategori == "file") {
-         const dataFile = await prisma.projectFile.findMany({
-            where: {
-               isActive: true,
-               idProject: String(id)
-            },
-            orderBy: {
-               createdAt: 'asc'
-            },
-            select: {
-               id: true,
-               name: true,
-               extension: true,
-               idStorage: true
-            }
-         })
-
-         allData = dataFile
-
-      } else if (kategori == "member") {
-         const dataMember = await prisma.projectMember.findMany({
-            where: {
-               isActive: true,
-               idProject: String(id)
-            },
-            select: {
-               id: true,
-               idUser: true,
-               User: {
-                  select: {
-                     name: true,
-                     email: true,
-                     img: true,
-                     Position: {
-                        select: {
-                           name: true
-                        }
-                     }
-                  }
-               },
-            }
-         })
-
-         const fix = dataMember.map((v: any) => ({
-            ..._.omit(v, ["User"]),
-            name: v.User.name,
-            email: v.User.email,
-            img: v.User.img,
-            position: v.User.Position.name
-         }))
-
-         allData = fix
-      } else if (kategori == "link") {
-         const dataLink = await prisma.projectLink.findMany({
-            where: {
-               isActive: true,
-               idProject: String(id)
-            },
-            orderBy: {
-               createdAt: 'asc'
-            }
-         })
-         allData = dataLink
-      }
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan kegiatan", data: allData }, { status: 200 });
-
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan kegiatan, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/project/route.ts
+++ b/src/app/api/ai/project/route.ts
@@ -1,107 +0,0 @@
-import { prisma } from "@/module/_global";
-import _, { ceil } from "lodash";
-import { NextResponse } from "next/server";
-
-
-// GET ALL DATA PROJECT
-export async function GET(request: Request) {
-   try {
-      const { searchParams } = new URL(request.url);
-      const idVillage = searchParams.get('desa');
-      const name = searchParams.get('search');
-      const status = searchParams.get('status');
-      const idGroup = searchParams.get("group");
-      const page = searchParams.get('page');
-      const get = searchParams.get('get');
-
-      let getFix = 10;
-      if (get == null || get == undefined || get == "" || _.isNaN(Number(get))) {
-         getFix = 10;
-      } else {
-         getFix = Number(get);
-      }
-
-      const dataSkip = page == null || page == undefined ? 0 : Number(page) * getFix - getFix;
-
-
-
-
-      let kondisi: any = {
-         isActive: true,
-         idVillage: String(idVillage),
-         title: {
-            contains: (name == undefined || name == "null") ? "" : name,
-            mode: "insensitive"
-         },
-      }
-
-      if (status != "null" && status != undefined && status != "") {
-         kondisi = {
-            ...kondisi,
-            status: status == "segera" ? 0 : status == "dikerjakan" ? 1 : status == "selesai" ? 2 : status == "batal" ? 3 : 0
-         }
-      }
-
-
-      if (idGroup != "null" && idGroup != undefined && idGroup != "") {
-         kondisi = {
-            ...kondisi,
-            idGroup: String(idGroup)
-         }
-      }
-
-
-      const data = await prisma.project.findMany({
-         skip: dataSkip,
-         take: getFix,
-         where: kondisi,
-         select: {
-            id: true,
-            idGroup: true,
-            title: true,
-            desc: true,
-            status: true,
-            ProjectMember: {
-               where: {
-                  isActive: true
-               },
-               select: {
-                  idUser: true
-               }
-            },
-            ProjectTask: {
-               where: {
-                  isActive: true
-               },
-               select: {
-                  title: true,
-                  status: true
-               }
-            },
-            Group: {
-               select: {
-                  name: true
-               }
-            }
-         },
-         orderBy: {
-            createdAt: 'desc'
-         }
-      })
-
-      const omitData = data.map((v: any) => ({
-         ..._.omit(v, ["ProjectMember", "ProjectTask", "status", "Group"]),
-         group: v.Group.name,
-         status: v.status == 1 ? "dikerjakan" : v.status == 2 ? "selesai" : v.status == 3 ? "batal" : "segera",
-         progress: ceil((v.ProjectTask.filter((i: any) => i.status == 1).length * 100) / v.ProjectTask.length),
-         member: v.ProjectMember.length
-      }))
-
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan kegiatan", data: omitData }, { status: 200 });
-
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan kegiatan, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/task/[id]/route.ts
+++ b/src/app/api/ai/task/[id]/route.ts
@@ -1,180 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import moment from "moment";
-import "moment/locale/id";
-import { NextResponse } from "next/server";
-
-
-// GET DETAIL TASK DIVISI / GET ONE
-export async function GET(request: Request, context: { params: { id: string } }) {
-   try {
-      let allData
-      const { id } = context.params;
-      const { searchParams } = new URL(request.url);
-      const kategori = searchParams.get("cat");
-
-      const data = await prisma.divisionProject.findUnique({
-         where: {
-            id: String(id),
-         },
-         select: {
-            id: true,
-            idDivision: true,
-            title: true,
-            status: true,
-            desc: true,
-            reason: true,
-            report: true,
-            isActive: true,
-            Division: {
-               select: {
-                  name: true
-               }
-            }
-         }
-      });
-
-      if (!data) {
-         return NextResponse.json({ success: false, message: "Gagal mendapatkan kegiatan, data tidak ditemukan", }, { status: 404 });
-      }
-
-      if (kategori == "data") {
-         const dataProgress = await prisma.divisionProjectTask.findMany({
-            where: {
-               isActive: true,
-               idProject: String(id)
-            },
-            orderBy: {
-               updatedAt: 'desc'
-            }
-         })
-
-         const semua = dataProgress.length
-         const selesai = _.filter(dataProgress, { status: 1 }).length
-         const progress = Math.ceil((selesai / semua) * 100)
-
-
-         allData = {
-            id: data.id,
-            idDivision: data.idDivision,
-            division: data.Division.name,
-            title: data.title,
-            status: data.status == 3 ? "batal" : data.status == 2 ? "selesai" : data.status == 1 ? "dikerjakan" : "segera",
-            desc: data.desc,
-            reason: data.reason,
-            report: data.report,
-            isActive: data.isActive,
-            progress: progress,
-         }
-      } else if (kategori == "task") {
-         const dataProgress = await prisma.divisionProjectTask.findMany({
-            where: {
-               isActive: true,
-               idProject: String(id)
-            },
-            select: {
-               id: true,
-               title: true,
-               status: true,
-               dateStart: true,
-               dateEnd: true,
-            },
-            orderBy: {
-               createdAt: 'asc'
-            }
-         })
-
-         const fix = dataProgress.map((v: any) => ({
-            ..._.omit(v, ["dateStart", "dateEnd", "status"]),
-            status: v.status == 1 ? "selesai" : "belum selesai",
-            dateStart: moment(v.dateStart).format("DD-MM-YYYY"),
-            dateEnd: moment(v.dateEnd).format("DD-MM-YYYY"),
-         }))
-
-         allData = fix
-
-      } else if (kategori == "file") {
-         const dataFile = await prisma.divisionProjectFile.findMany({
-            where: {
-               isActive: true,
-               idProject: String(id)
-            },
-            select: {
-               id: true,
-               ContainerFileDivision: {
-                  select: {
-                     id: true,
-                     name: true,
-                     extension: true,
-                     idStorage: true
-                  }
-               }
-            }
-         })
-
-         const fix = dataFile.map((v: any) => ({
-            ..._.omit(v, ["ContainerFileDivision"]),
-            nameInStorage: v.ContainerFileDivision.id,
-            name: v.ContainerFileDivision.name,
-            extension: v.ContainerFileDivision.extension,
-            idStorage: v.ContainerFileDivision.idStorage,
-         }))
-
-         allData = fix
-
-      } else if (kategori == "member") {
-         const dataMember = await prisma.divisionProjectMember.findMany({
-            where: {
-               isActive: true,
-               idProject: String(id)
-            },
-            select: {
-               id: true,
-               idUser: true,
-               User: {
-                  select: {
-                     name: true,
-                     email: true,
-                     img: true,
-                     Position: {
-                        select: {
-                           name: true
-                        }
-                     }
-                  }
-               }
-            }
-         })
-
-
-         const fix = dataMember.map((v: any) => ({
-            ..._.omit(v, ["User"]),
-            name: v.User.name,
-            email: v.User.email,
-            img: v.User.img,
-            position: v.User.Position.name
-         }))
-
-         allData = fix
-      } else if (kategori == "link") {
-         const dataLink = await prisma.divisionProjectLink.findMany({
-            where: {
-               isActive: true,
-               idProject: String(id)
-            },
-            orderBy: {
-               createdAt: 'asc'
-            }
-         })
-
-         allData = dataLink
-      }
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan tugas divisi", data: allData }, { status: 200 });
-
-   }
-   catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan tugas divisi, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/task/route.ts
+++ b/src/app/api/ai/task/route.ts
@@ -1,104 +0,0 @@
-import { prisma } from "@/module/_global";
-import _, { ceil } from "lodash";
-import { NextResponse } from "next/server";
-
-
-// GET ALL DATA TUGAS DIVISI
-export async function GET(request: Request) {
-   try {
-      const { searchParams } = new URL(request.url);
-      const villageId = searchParams.get('desa');
-      const division = searchParams.get('division');
-      const search = searchParams.get('search');
-      const status = searchParams.get('status');
-      const page = searchParams.get('page');
-      const get = searchParams.get('get');
-
-      let getFix = 10;
-      if (get == null || get == undefined || get == "" || _.isNaN(Number(get))) {
-         getFix = 10;
-      } else {
-         getFix = Number(get);
-      }
-
-      const dataSkip = page == null || page == undefined ? 0 : Number(page) * getFix - getFix;
-
-      let kondisi: any = {
-         isActive: true,
-         Division: {
-            idVillage: String(villageId)
-         },
-         title: {
-            contains: (search == undefined || search == "null") ? "" : search,
-            mode: "insensitive"
-         }
-      }
-
-      if (status != "null" && status != undefined && status != "" && status != null) {
-         kondisi = {
-            ...kondisi,
-            status: status == "segera" ? 0 : status == "dikerjakan" ? 1 : status == "selesai" ? 2 : status == "batal" ? 3 : 0
-         }
-      }
-
-      if (division != "null" && division != undefined && division != "" && division != null) {
-         kondisi = {
-            ...kondisi,
-            idDivision: String(division)
-         }
-      }
-
-
-      const data = await prisma.divisionProject.findMany({
-         skip: dataSkip,
-         take: getFix,
-         where: kondisi,
-         select: {
-            id: true,
-            idDivision: true,
-            title: true,
-            desc: true,
-            status: true,
-            DivisionProjectTask: {
-               where: {
-                  isActive: true
-               },
-               select: {
-                  title: true,
-                  status: true
-               }
-            },
-            DivisionProjectMember: {
-               where: {
-                  isActive: true
-               },
-               select: {
-                  idUser: true
-               }
-            },
-            Division: {
-               select: {
-                  name: true
-               }
-            }
-         },
-         orderBy: {
-            createdAt: "desc"
-         }
-      });
-
-      const formatData = data.map((v: any) => ({
-         ..._.omit(v, ["DivisionProjectTask", "DivisionProjectMember", "status", "Division"]),
-         division: v.Division.name,
-         status: v.status == 1 ? "dikerjakan" : v.status == 2 ? "selesai" : v.status == 3 ? "batal" : "segera",
-         progress: ceil((v.DivisionProjectTask.filter((i: any) => i.status == 1).length * 100) / v.DivisionProjectTask.length),
-         member: v.DivisionProjectMember.length,
-      }))
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan divisi", data: formatData }, { status: 200 });
-
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan divisi, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/user/[id]/route.ts
+++ b/src/app/api/ai/user/[id]/route.ts
@@ -1,75 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import { NextResponse } from "next/server";
-
-// GET ONE MEMBER / USER 
-export async function GET(request: Request, context: { params: { id: string } }) {
-   try {
-      const { id } = context.params;
-
-      const users = await prisma.user.findUnique({
-         where: {
-            id: id,
-         },
-         select: {
-            id: true,
-            nik: true,
-            name: true,
-            phone: true,
-            email: true,
-            gender: true,
-            img: true,
-            idGroup: true,
-            isActive: true,
-            idPosition: true,
-            createdAt: true,
-            updatedAt: true,
-            UserRole: {
-               select: {
-                  name: true,
-                  id: true
-               }
-            },
-            Position: {
-               select: {
-                  name: true,
-                  id: true
-               },
-            },
-            Group: {
-               select: {
-                  name: true,
-                  id: true
-               },
-            },
-         },
-      });
-
-      const { ...userData } = users;
-      const group = users?.Group.name
-      const position = users?.Position?.name
-      const idUserRole = users?.UserRole.id
-      const phone = '+62' + users?.phone
-      const role = users?.UserRole.name
-      const gender = users?.gender == "F" ? "Perempuan" : "Laki-Laki"
-
-      const result = { ...userData, gender, group, position, idUserRole, phone, role };
-
-      const omitData = _.omit(result, ["Group", "Position", "UserRole"]);
-
-
-
-      return NextResponse.json(
-         {
-            success: true,
-            message: "Berhasil mendapatkan anggota",
-            data: omitData,
-         },
-         { status: 200 }
-      );
-
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan anggota, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/user/route.ts
+++ b/src/app/api/ai/user/route.ts
@@ -1,88 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import { NextResponse } from "next/server";
-
-// GET ALL MEMBER / USER
-export async function GET(request: Request) {
-   try {
-      const { searchParams } = new URL(request.url);
-      const search = searchParams.get('search')
-      const idVillage = searchParams.get("desa");
-      const idGroup = searchParams.get("group");
-      const active = searchParams.get("active");
-      const page = searchParams.get('page');
-      const get = searchParams.get('get');
-
-      let getFix = 10;
-      if (get == null || get == undefined || get == "" || _.isNaN(Number(get))) {
-         getFix = 10;
-      } else {
-         getFix = Number(get);
-      }
-
-      const dataSkip = page == null || page == undefined ? 0 : Number(page) * getFix - getFix;
-
-      let kondisi: any = {
-         isActive: active == 'false' ? false : true,
-         idVillage: String(idVillage),
-         name: {
-            contains: (search == undefined || search == null) ? "" : search,
-            mode: "insensitive",
-         },
-         NOT: {
-            idUserRole: 'developer'
-         }
-      }
-
-      if (idGroup != "null" && idGroup != undefined && idGroup != "" && idGroup != null) {
-         kondisi = {
-            ...kondisi,
-            idGroup: String(idGroup)
-         }
-      }
-
-
-      const users = await prisma.user.findMany({
-         skip: dataSkip,
-         take: getFix,
-         where: kondisi,
-         select: {
-            id: true,
-            idUserRole: true,
-            isActive: true,
-            nik: true,
-            name: true,
-            phone: true,
-            Position: {
-               select: {
-                  name: true,
-               },
-            },
-            Group: {
-               select: {
-                  name: true,
-               },
-            },
-         },
-         orderBy: {
-            name: 'asc'
-         }
-      });
-
-      const allData = users.map((v: any) => ({
-         ..._.omit(v, ["phone", "gender", "Group", "Position"]),
-         gender: v.gender == "F" ? "Perempuan" : "Laki-Laki",
-         phone: "+" + v.phone,
-         group: v.Group.name,
-         position: v?.Position?.name
-      }))
-
-      return NextResponse.json({ success: true, message: "Berhasil member", data: allData }, { status: 200 });
-
-
-
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan anggota, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/ai/village/route.ts
+++ b/src/app/api/ai/village/route.ts
@@ -1,50 +0,0 @@
-import { prisma } from "@/module/_global";
-import _ from "lodash";
-import { NextResponse } from "next/server";
-
-export async function GET(request: Request) {
-   try {
-      const { searchParams } = new URL(request.url);
-      const isActive = searchParams.get("active");
-      const search = searchParams.get('search');
-      const page = searchParams.get('page')
-      const get = searchParams.get('get')
-
-      let getFix = 10;
-      if (get == null || get == undefined || get == "" || _.isNaN(Number(get))) {
-         getFix = 10;
-      } else {
-         getFix = Number(get);
-      }
-
-      const dataSkip = page == null || page == undefined ? 0 : Number(page) * getFix - getFix;
-
-      const data = await prisma.village.findMany({
-         skip: dataSkip,
-         take: getFix,
-         where: {
-            isActive: isActive == 'false' ? false : true,
-            name: {
-               contains: (search == undefined || search == null) ? "" : search,
-               mode: "insensitive"
-            }
-         },
-         select: {
-            id: true,
-            name: true,
-            isActive: true,
-            createdAt: true,
-            updatedAt: true
-         },
-         orderBy: {
-            name: 'asc'
-         }
-      });
-
-      return NextResponse.json({ success: true, message: "Berhasil mendapatkan desa", data, }, { status: 200 });
-
-   } catch (error) {
-      console.error(error);
-      return NextResponse.json({ success: false, message: "Gagal mendapatkan desa, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
-   }
-}
--- a/src/app/api/mobile/project/task/[id]/approval/route.ts
+++ b/src/app/api/mobile/project/task/[id]/approval/route.ts
@@ -96,13 +96,13 @@ async function sendNotification({
    }
 }

-async function getApproversInVillage(idVillage: string): Promise<NotifTarget[]> {
+async function getApproversInVillage(idVillage: string, idGroup: string): Promise<NotifTarget[]> {
    const approvers = await prisma.user.findMany({
        where: {
            isActive: true,
            idVillage,
            OR: [
-                { isApprover: true },
+                { isApprover: true, idGroup },
                { UserRole: { id: 'supadmin' } }
            ]
        },
@@ -198,7 +198,10 @@ export async function POST(request: Request, context: { params: { id: string } }

        const task = await prisma.projectTask.findUnique({
            where: { id, isActive: true },
-            select: { id: true, status: true, idProject: true, title: true }
+            select: {
+                id: true, status: true, title: true,
+                Project: { select: { id: true, idGroup: true } }
+            }
        });

        if (!task) {
@@ -227,14 +230,14 @@ export async function POST(request: Request, context: { params: { id: string } }
            })
        ]);

-        await recalculateProjectStatus(task.idProject);
+        await recalculateProjectStatus(task.Project.id);

-        // Notifikasi ke semua approver
-        const approverTargets = await getApproversInVillage(String(userMobile.idVillage));
+        // Notifikasi ke semua approver di desa dan group yang sama
+        const approverTargets = await getApproversInVillage(String(userMobile.idVillage), task.Project.idGroup);
        await sendNotification({
            targets: approverTargets,
            idUserFrom: userMobile.id,
-            idContent: task.idProject,
+            idContent: task.Project.id,
            title: 'Pengajuan Penyelesaian Tugas',
            desc: task.title,
        });
@@ -271,7 +274,7 @@ export async function PUT(request: Request, context: { params: { id: string } })

        const task = await prisma.projectTask.findUnique({
            where: { id, isActive: true },
-            select: { id: true, status: true, idProject: true, title: true }
+            select: { id: true, status: true, title: true, Project: { select: { id: true } } }
        });

        if (!task) {
@@ -304,7 +307,7 @@ export async function PUT(request: Request, context: { params: { id: string } })
                })
            ]);

-            await recalculateProjectStatus(task.idProject);
+            await recalculateProjectStatus(task.Project.id);

            // Notifikasi ke submitter
            const submitterTarget = await getUserNotifTarget(pendingApproval.idUser);
@@ -312,7 +315,7 @@ export async function PUT(request: Request, context: { params: { id: string } })
                await sendNotification({
                    targets: [submitterTarget],
                    idUserFrom: userMobile.id,
-                    idContent: task.idProject,
+                    idContent: task.Project.id,
                    title: 'Tugas Disetujui',
                    desc: task.title,
                });
@@ -339,7 +342,7 @@ export async function PUT(request: Request, context: { params: { id: string } })
            })
        ]);

-        await recalculateProjectStatus(task.idProject);
+        await recalculateProjectStatus(task.Project.id);

        // Notifikasi ke submitter
        const submitterTarget = await getUserNotifTarget(pendingApproval.idUser);
@@ -347,7 +350,7 @@ export async function PUT(request: Request, context: { params: { id: string } })
            await sendNotification({
                targets: [submitterTarget],
                idUserFrom: userMobile.id,
-                idContent: task.idProject,
+                idContent: task.Project.id,
                title: 'Tugas Ditolak',
                desc: task.title,
            });
--- a/src/app/api/mobile/task/[id]/route.ts
+++ b/src/app/api/mobile/task/[id]/route.ts
@@ -25,6 +25,9 @@ export async function GET(request: Request, context: { params: { id: string } })
         where: {
            id: String(id),
            isActive: true
+         },
+         include: {
+            Division: { select: { idGroup: true } }
         }
      });

@@ -33,7 +36,7 @@ export async function GET(request: Request, context: { params: { id: string } })
      }

      if (kategori == "data") {
-         allData = data
+         allData = { ...data, idGroup: data.Division.idGroup }
      } else if (kategori == "progress") {
         const dataProgress = await prisma.divisionProjectTask.findMany({
            where: {
--- a/src/app/api/mobile/task/tugas/[id]/approval/route.ts
+++ b/src/app/api/mobile/task/tugas/[id]/approval/route.ts
@@ -96,13 +96,19 @@ async function sendNotification({
 }

 async function getApproversForDivision(idVillage: string, idDivision: string): Promise<NotifTarget[]> {
+    const division = await prisma.division.findUnique({
+        where: { id: idDivision },
+        select: { idGroup: true }
+    });
+    const idGroup = division?.idGroup;
+
    const [globalApprovers, divisionAdmins] = await Promise.all([
        prisma.user.findMany({
            where: {
                isActive: true,
                idVillage,
                OR: [
-                    { isApprover: true },
+                    { isApprover: true, idGroup },
                    { UserRole: { id: 'supadmin' } }
                ]
            },
@@ -285,23 +291,35 @@ export async function PUT(request: Request, context: { params: { id: string } })
            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
        }

-        const canApprove = await getApproverStatus(userMobile.id);
-        if (!canApprove) {
-            // Check if division admin
-            const task = await prisma.divisionProjectTask.findUnique({
-                where: { id, isActive: true },
-                select: { idDivision: true }
-            });
-            if (task) {
-                const isDivAdmin = await prisma.divisionMember.count({
-                    where: { idDivision: task.idDivision, idUser: userMobile.id, isAdmin: true, isActive: true }
-                });
-                if (isDivAdmin === 0) {
-                    return NextResponse.json({ success: false, message: "Anda tidak memiliki izin untuk menyetujui atau menolak tugas" }, { status: 200 });
-                }
-            } else {
-                return NextResponse.json({ success: false, message: "Tugas tidak ditemukan" }, { status: 200 });
-            }
+        const taskForAuth = await prisma.divisionProjectTask.findUnique({
+            where: { id, isActive: true },
+            select: { idDivision: true }
+        });
+        if (!taskForAuth) {
+            return NextResponse.json({ success: false, message: "Tugas tidak ditemukan" }, { status: 200 });
+        }
+
+        const [division, userFull, isDivAdmin] = await Promise.all([
+            prisma.division.findUnique({
+                where: { id: taskForAuth.idDivision },
+                select: { idGroup: true, idVillage: true }
+            }),
+            prisma.user.findUnique({
+                where: { id: userMobile.id },
+                select: { isApprover: true, idGroup: true, idVillage: true, UserRole: { select: { id: true } } }
+            }),
+            prisma.divisionMember.count({
+                where: { idDivision: taskForAuth.idDivision, idUser: userMobile.id, isAdmin: true, isActive: true }
+            })
+        ]);
+
+        const isSupadmin = APPROVER_ROLES.includes(userFull?.UserRole?.id ?? '');
+        const isGroupApprover = !!(userFull?.isApprover &&
+            userFull.idVillage === division?.idVillage &&
+            userFull.idGroup === division?.idGroup);
+
+        if (!isSupadmin && !isGroupApprover && isDivAdmin === 0) {
+            return NextResponse.json({ success: false, message: "Anda tidak memiliki izin untuk menyetujui atau menolak tugas" }, { status: 200 });
        }

        const task = await prisma.divisionProjectTask.findUnique({
--- a/src/app/api/monitoring/[[...slug]]/route.ts
+++ b/src/app/api/monitoring/[[...slug]]/route.ts
--- a/src/app/api/noc/[[...slug]]/route.ts
+++ b/src/app/api/noc/[[...slug]]/route.ts
@@ -1,3 +1,4 @@
+import { isValidApiKey } from "@/lib/apiKey";
 import { prisma } from "@/module/_global";
 import cors from "@elysiajs/cors";
 import { swagger } from "@elysiajs/swagger";
@@ -11,20 +12,40 @@ const NocServer = new Elysia({ prefix: "/api/noc" })
   .use(cors({
      origin: "*",
      methods: ["GET", "POST", "OPTIONS"],
+      allowedHeaders: ["Content-Type", "x-api-key"],
   }))
   .use(swagger({
-      path: "/docs", // Karena prefix instance adalah /api/noc, maka ini akan diakses di /api/noc/docs
+      path: "/docs",
      documentation: {
         info: {
            title: "Sistem Desa Mandiri - NOC API",
            version: "1.0.0",
            description: "API Khusus untuk kebutuhan NOC (Network Operation Center) dan Monitoring Desa",
         },
+         components: {
+            securitySchemes: {
+               ApiKeyAuth: {
+                  type: "apiKey",
+                  in: "header",
+                  name: "x-api-key",
+               },
+            },
+         },
+         security: [{ ApiKeyAuth: [] }],
         tags: [
            { name: "NOC", description: "Endpoint khusus monitoring" }
         ]
      }
   }))
+   .onBeforeHandle(async ({ request, set, path }) => {
+      if (path.startsWith("/api/noc/docs")) return;
+
+      const incoming = request.headers.get("x-api-key");
+      if (!incoming || !(await isValidApiKey(incoming))) {
+         set.status = 401;
+         return { success: false, message: "Unauthorized" };
+      }
+   })

   // ── GET /api/noc/active-divisions ──────────────────────────────────────────
   .get(
--- a/src/lib/apiKey.ts
+++ b/src/lib/apiKey.ts
@@ -0,0 +1,15 @@
+import { prisma } from "@/module/_global";
+
+const CACHE_TTL_MS = 60_000;
+let apiKeyCache: Set<string> = new Set();
+let cacheExpiresAt = 0;
+
+export async function isValidApiKey(incoming: string): Promise<boolean> {
+   const now = Date.now();
+   if (now > cacheExpiresAt) {
+      const rows = await prisma.apiKey.findMany({ where: { isActive: true }, select: { key: true } });
+      apiKeyCache = new Set(rows.map((r) => r.key));
+      cacheExpiresAt = now + CACHE_TTL_MS;
+   }
+   return apiKeyCache.has(incoming);
+}
Author	SHA1	Message	Date
amaliadwiy	1e02747e22	feat: tambahkan village-report endpoint dengan perbandingan periode sebelumnya - Endpoint /village-report kini menghitung activity_count periode saat ini dan prev_activity_count periode sebelumnya dalam satu query (doubleRange) - Tambahkan kalkulasi trend persentase perubahan antar periode - Sertakan data perbekel, active_users, inactive_users, lastActivity, dan daysSince - Tambahkan endpoint /export-logs dan /export-users untuk ekspor CSV	2026-05-28 15:39:47 +08:00
amaliadwiy	a0bffd53cb	feat: tambah endpoint export-logs dan export-users untuk CSV download	2026-05-28 15:06:23 +08:00
amaliadwiy	8dca3e440f	feat: tambah endpoint peak-hours untuk distribusi aktivitas per jam	2026-05-28 14:47:11 +08:00
amaliadwiy	1df1d10c91	feat: tambah endpoint inactive-users dan lengkapi field response-nya	2026-05-28 14:32:49 +08:00
amaliadwiy	e5891f0da3	feat: tambah idVillage ke response log-all-villages	2026-05-28 14:18:03 +08:00
amaliadwiy	619cc9a403	feat: tambah endpoint stale-villages untuk deteksi desa tidak aktif	2026-05-28 14:14:35 +08:00
amaliadwiy	3272ecaef3	feat: tambah field lastActivity ke endpoint monitoring /user	2026-05-28 14:09:42 +08:00
amaliadwiy	3b5126d8ee	Merge pull request 'amalia/25-mei-26' (#53 ) from amalia/25-mei-26 into join Reviewed-on: #53	2026-05-25 17:32:47 +08:00
amaliadwiy	552957282b	bump: version 0.1.18 + migration	2026-05-25 15:36:30 +08:00
amaliadwiy	22555079f3	feat: graph-log-villages support dateFrom/dateTo + recent-village-logs endpoint	2026-05-25 15:08:30 +08:00
amaliadwiy	6cf6486172	feat: tambah endpoint GET /api-keys/:id untuk ambil full key	2026-05-25 12:00:53 +08:00
amaliadwiy	35e51028db	Merge pull request 'amalia/22-mei-26' (#52 ) from amalia/22-mei-26 into join Reviewed-on: #52	2026-05-22 17:41:21 +08:00
amaliadwiy	37ea4e37e7	bump: version 0.1.17 + migration	2026-05-22 14:46:33 +08:00
amaliadwiy	e270db3bfa	feat: add range param to daily-activity and comparison-activity endpoints Both endpoints now accept ?range=7\|30\|90 (default 7). comparison-activity result now follows SQL ORDER BY instead of being remapped through villages array.	2026-05-22 14:16:36 +08:00
amaliadwiy	32dac32532	feat: add village and date range filter on /log-all-villages endpoint	2026-05-22 11:37:42 +08:00
amaliadwiy	d369a71eb6	feat: add filter and orderBy support on /user monitoring endpoint	2026-05-22 11:17:42 +08:00
amaliadwiy	7334831d61	Merge pull request 'bump: version 0.1.16 + migration' (#51 ) from amalia/21-mei-26 into join Reviewed-on: #51	2026-05-21 17:25:52 +08:00
amaliadwiy	c0a4d584af	bump: version 0.1.16 + migration	2026-05-21 11:07:23 +08:00
amaliadwiy	9ac105e7bc	Merge pull request 'amalia/20-mei-26' (#50 ) from amalia/20-mei-26 into join Reviewed-on: #50	2026-05-20 17:22:20 +08:00
amaliadwiy	10457e96e8	feat: tambah autentikasi x-api-key pada NOC API dan ekstrak isValidApiKey ke shared lib	2026-05-20 12:23:38 +08:00
amaliadwiy	9ad934c99f	bump: version 0.1.15 + migration	2026-05-19 16:05:35 +08:00
amaliadwiy	5bfcde32ed	Merge pull request 'amalia/18-mei-26' (#49 ) from amalia/18-mei-26 into join Reviewed-on: #49	2026-05-18 17:26:42 +08:00
amaliadwiy	8240d608ad	feat: tambah field isApprover pada endpoint get & edit user	2026-05-18 16:42:33 +08:00
amaliadwiy	fd7d08d38a	bump: version 0.1.14 + migration	2026-05-18 15:15:07 +08:00
amaliadwiy	b95fd9543c	feat: filter approver berdasarkan group pada project dan division task - project/task approval: filter isApprover berdasarkan desa + group project - project/task approval: supadmin tetap hanya filter desa - division/task approval: expose idGroup dari Division pada response cat=data - division/task approval: filter isApprover berdasarkan desa + group division - division/task approval PUT: ganti getApproverStatus dengan cek langsung berdasarkan village, group, dan keanggotaan division admin	2026-05-18 14:52:38 +08:00
amaliadwiy	7622c58ce4	Merge pull request 'amalia/15-mei-26' (#48 ) from amalia/15-mei-26 into join Reviewed-on: #48	2026-05-15 14:20:52 +08:00
amaliadwiy	d1b90b63e9	bump: version 0.1.13 + migration	2026-05-15 11:16:51 +08:00
amaliadwiy	387a86f17e	bump: version 0.1.12 + migration	2026-05-15 11:00:40 +08:00
amaliadwiy	b749b333f6	Merge pull request 'upd: api jenna perangkat desa' (#47 ) from amalia/13-mei-26 into join Reviewed-on: #47	2026-05-13 17:25:21 +08:00
amaliadwiy	ac6db48a5a	upd: api jenna perangkat desa Deskripsi: - api yg akan diakses oleh jenna perangkat desa - struktur api keys - migrasi database No Issues	2026-05-13 17:22:50 +08:00
amaliadwiy	d8e17340aa	Merge pull request 'amalia/12-mei-26' (#46 ) from amalia/12-mei-26 into join Reviewed-on: #46	2026-05-12 17:26:10 +08:00
amaliadwiy	b6e1f59945	bump: version 0.1.11 + migration	2026-05-12 17:18:24 +08:00
amaliadwiy	0e9fa756cb	feat: expose isDummy on get-villages and edit-villages endpoints	2026-05-12 14:11:22 +08:00
amaliadwiy	e6702ba01e	Merge pull request 'feat: tambah endpoint kalender umum village' (#45 ) from amalia/11-mei-26 into join Reviewed-on: #45	2026-05-11 17:36:03 +08:00