upd: seeder

Deskripsi:
- hapus data seeder lukman

NO Issues

prisma/schema.prisma

@@ -168,6 +168,7 @@ model Announcement {
   createdAt          DateTime             @default(now())
   updatedAt          DateTime             @updatedAt
   AnnouncementMember AnnouncementMember[]
+  AnnouncementFile   AnnouncementFile[]
 }
 
 model AnnouncementMember {
@@ -183,6 +184,18 @@ model AnnouncementMember {
   updatedAt      DateTime     @updatedAt
 }
 
+model AnnouncementFile {
+  id             String       @id @default(cuid())
+  Announcement   Announcement @relation(fields: [idAnnouncement], references: [id])
+  idAnnouncement String
+  name           String
+  extension      String
+  idStorage      String?
+  isActive       Boolean      @default(true)
+  createdAt      DateTime     @default(now())
+  updatedAt      DateTime     @updatedAt
+}
+
 model Project {
   id            String          @id @default(cuid())
   Village       Village         @relation(fields: [idVillage], references: [id])
@@ -410,6 +423,7 @@ model DivisionDisscussion {
   createdAt                  DateTime                     @default(now())
   updatedAt                  DateTime                     @updatedAt
   DivisionDisscussionComment DivisionDisscussionComment[]
+  DivisionDiscussionFile     DivisionDiscussionFile[]
 }
 
 model DivisionDisscussionComment {
@@ -424,6 +438,17 @@ model DivisionDisscussionComment {
   createdAt           DateTime            @default(now())
   updatedAt           DateTime            @updatedAt
 }
+model DivisionDiscussionFile {
+  id                  String              @id @default(cuid())
+  DivisionDisscussion DivisionDisscussion @relation(fields: [idDiscussion], references: [id])
+  idDiscussion        String
+  name                String
+  extension           String
+  idStorage           String?
+  isActive            Boolean             @default(true)
+  createdAt           DateTime            @default(now())
+  updatedAt           DateTime            @updatedAt
+}
 
 model DivisionDocumentFolderFile {
   id                    String                  @id @default(cuid())
@@ -595,6 +620,7 @@ model Discussion {
   updatedAt         DateTime            @updatedAt
   DiscussionMember  DiscussionMember[]
   DiscussionComment DiscussionComment[]
+  DiscussionFile    DiscussionFile[]
 }
 
 model DiscussionMember {
@@ -620,3 +646,15 @@ model DiscussionComment {
   createdAt    DateTime   @default(now())
   updatedAt    DateTime   @updatedAt
 }
+
+model DiscussionFile {
+  id           String     @id @default(cuid())
+  Discussion   Discussion @relation(fields: [idDiscussion], references: [id])
+  idDiscussion String
+  name         String
+  extension    String
+  idStorage    String?
+  isActive     Boolean    @default(true)
+  createdAt    DateTime   @default(now())
+  updatedAt    DateTime   @updatedAt
+}

src/app/api/discussion-general/[id]/route.ts

@@ -3,8 +3,8 @@ import { funGetUserByCookies } from "@/module/auth";
 import { createLogUser } from "@/module/user";
 import _ from "lodash";
 import moment from "moment";
-import { NextResponse } from "next/server";
 import "moment/locale/id";
+import { NextResponse } from "next/server";
 
 
 // GET ONE DETAIL DISKUSI UMUM
@@ -75,6 +75,9 @@ export async function GET(request: Request, context: { params: { id: string } })
                      img: true
                   }
                }
+            },
+            orderBy: {
+               createdAt: "asc"
             }
          })
 

src/app/api/discussion-general/route.ts

@@ -74,6 +74,9 @@ export async function GET(request: Request) {
             DiscussionComment: {
                select: {
                   id: true,
+               },
+               where:{
+                  isActive:true
                }
             }
          }

src/app/api/discussion/[id]/route.ts

@@ -60,6 +60,12 @@ export async function GET(request: Request, context: { params: { id: string } })
                                 img: true
                             }
                         }
+                    },
+                    where: {
+                        isActive:true
+                    },
+                    orderBy: {
+                        createdAt: "asc"
                     }
                 },
             }

src/app/api/discussion/route.ts

@@ -64,6 +64,9 @@ export async function GET(request: Request) {
                DivisionDisscussionComment: {
                   select: {
                      id: true,
+                  },
+                  where:{
+                     isActive:true
                   }
                }
             }

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

@@ -1,4 +1,4 @@
-import { prisma } from "@/module/_global";
+import { DIR, funUploadFile, prisma } from "@/module/_global";
 import { funGetUserById } from "@/module/auth";
 import { createLogUserMobile } from "@/module/user";
 import _ from "lodash";
@@ -20,6 +20,7 @@ export async function GET(request: Request, context: { params: { id: string } })
         const data = await prisma.announcement.count({
             where: {
                 id: id,
+                isActive: true,
             },
         });
 
@@ -29,7 +30,7 @@ export async function GET(request: Request, context: { params: { id: string } })
                     success: false,
                     message: "Gagal mendapatkan pengumuman, data tidak ditemukan",
                 },
-                { status: 404 }
+                { status: 200 }
             );
         }
 
@@ -75,13 +76,26 @@ export async function GET(request: Request, context: { params: { id: string } })
         // const fixMember = Object.groupBy(formatMember, ({ group }) => group);
         const fixMember = _.groupBy(formatMember, ({ group }) => group);
 
+        const file = await prisma.announcementFile.findMany({
+            where: {
+                idAnnouncement: id
+            },
+            select: {
+                id: true,
+                idStorage: true,
+                name: true,
+                extension: true
+            }
+        })
+
 
         return NextResponse.json(
             {
                 success: true,
                 message: "Berhasil mendapatkan pengumuman",
                 data: announcement,
-                member: fixMember
+                member: fixMember,
+                file: file
             },
             { status: 200 }
         );
@@ -153,7 +167,12 @@ export async function DELETE(request: Request, context: { params: { id: string }
 //  EDIT PENGUMUMAN
 export async function PUT(request: Request, context: { params: { id: string } }) {
     try {
-        const { title, desc, groups, user } = (await request.json());
+        const body = await request.formData()
+        const dataBody = body.get("data")
+        const cekFile = body.has("file0")
+
+        // const { title, desc, groups, user } = (await request.json());
+        const { title, desc, groups, user, oldFile } = JSON.parse(dataBody as string)
         const { id } = context.params;
         const userMobile = await funGetUserById({ id: String(user) })
 
@@ -173,7 +192,7 @@ export async function PUT(request: Request, context: { params: { id: string } })
                     success: false,
                     message: "Edit pengumuman gagal, data tidak ditemukan",
                 },
-                { status: 404 }
+                { status: 200 }
             );
         }
 
@@ -213,6 +232,41 @@ export async function PUT(request: Request, context: { params: { id: string } })
             data: memberDivision,
         });
 
+        if (oldFile.length > 0) {
+            for (let index = 0; index < oldFile.length; index++) {
+                const element = oldFile[index];
+                if (element.delete) {
+                    await prisma.announcementFile.delete({
+                        where: {
+                            id: element.id
+                        }
+                    })
+                }
+            }
+        }
+
+        if (cekFile) {
+            body.delete("data")
+            for (var pair of body.entries()) {
+                if (String(pair[0]).substring(0, 4) == "file") {
+                    const file = body.get(pair[0]) as File
+                    const fExt = file.name.split(".").pop()
+                    const fName = decodeURIComponent(file.name.replace("." + fExt, ""))
+                    const upload = await funUploadFile({ file: file, dirId: DIR.announcement })
+                    if (upload.success) {
+                        await prisma.announcementFile.create({
+                            data: {
+                                idStorage: upload.data.id,
+                                idAnnouncement: id,
+                                name: fName,
+                                extension: String(fExt)
+                            }
+                        })
+                    }
+                }
+            }
+        }
+
         // create log user
         const log = await createLogUserMobile({ act: 'UPDATE', desc: 'User mengupdate data pengumuman', table: 'announcement', data: id, user: userMobile.id })
 

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

@@ -1,4 +1,4 @@
-import { funSendWebPush, prisma } from "@/module/_global";
+import { DIR, funSendWebPush, funUploadFile, prisma } from "@/module/_global";
 import { funGetUserById } from "@/module/auth";
 import { createLogUserMobile } from '@/module/user';
 import _ from "lodash";
@@ -113,7 +113,12 @@ export async function GET(request: Request) {
 // CREATE PENGUMUMAN
 export async function POST(request: Request) {
     try {
-        const { title, desc, groups, user } = (await request.json());
+        const body = await request.formData()
+        const dataBody = body.get("data")
+        const cekFile = body.has("file0")
+
+        // const { title, desc, groups, user } = (await request.json());
+        const { title, desc, groups, user } = JSON.parse(dataBody as string)
         const userMobile = await funGetUserById({ id: String(user) })
 
         if (userMobile.id == "null" || userMobile.id == undefined || userMobile.id == "") {
@@ -152,6 +157,29 @@ export async function POST(request: Request) {
             }
         }
 
+
+        if (cekFile) {
+            body.delete("data")
+            for (var pair of body.entries()) {
+                if (String(pair[0]).substring(0, 4) == "file") {
+                    const file = body.get(pair[0]) as File
+                    const fExt = file.name.split(".").pop()
+                    const fName = decodeURIComponent(file.name.replace("." + fExt, ""))
+                    const upload = await funUploadFile({ file: file, dirId: DIR.announcement })
+                    if (upload.success) {
+                        await prisma.announcementFile.create({
+                            data: {
+                                idStorage: upload.data.id,
+                                idAnnouncement: data.id,
+                                name: fName,
+                                extension: String(fExt)
+                            }
+                        })
+                    }
+                }
+            }
+        }
+
         const announcementMember = await prisma.announcementMember.createMany({
             data: memberDivision,
         });

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

@@ -11,7 +11,7 @@ export async function GET(request: Request) {
       const userMobile = searchParams.get("user")
 
       if (userMobile == "null" || userMobile == undefined || userMobile == "") {
-         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
       }
 
       const user = await funGetUserById({ id: userMobile })

src/app/api/mobile/discussion-general/[id]/comment/route.ts

@@ -147,4 +147,90 @@ export async function POST(request: Request, context: { params: { id: string } }
       console.error(error)
       return NextResponse.json({ success: false, message: "Gagal menambahkan komentar, coba lagi nanti (error: 500)" })
    }
+}
+
+// EDIT KOMENTAR
+export async function PUT(request: Request, context: { params: { id: string } }) {
+   try {
+      const { id } = context.params
+      const { desc, user } = (await request.json());
+      const userMobile = await funGetUserById({ id: String(user) })
+
+      if (userMobile.id == "null" || userMobile.id == undefined || userMobile.id == "") {
+         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
+      }
+
+      const cek = await prisma.discussionComment.count({
+         where: {
+            id,
+            isActive: true
+         }
+      })
+
+      if (cek == 0) {
+         return NextResponse.json({ success: false, message: "Gagal mengedit komentar, data tidak ditemukan" }, { status: 200 });
+      }
+
+
+      const data = await prisma.discussionComment.update({
+         where: {
+            id
+         },
+         data: {
+            comment: desc,
+            isEdited: true
+         }
+      })
+
+      // create log user
+      const log = await createLogUserMobile({ act: 'UPDATE', desc: 'User mengedit komentar pada diskusi umum', table: 'discussionComment', data: id, user: userMobile.id })
+      return NextResponse.json({ success: true, message: "Berhasil mengedit komentar" }, { status: 200 });
+
+   } catch (error) {
+      console.error(error)
+      return NextResponse.json({ success: false, message: "Gagal mengedit komentar, coba lagi nanti (error: 500)" })
+   }
+}
+
+
+// HAPUS KOMENTAR
+export async function DELETE(request: Request, context: { params: { id: string } }) {
+   try {
+      const { id } = context.params
+      const { user } = (await request.json());
+      const userMobile = await funGetUserById({ id: String(user) })
+
+      if (userMobile.id == "null" || userMobile.id == undefined || userMobile.id == "") {
+         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
+      }
+
+      const cek = await prisma.discussionComment.count({
+         where: {
+            id,
+            isActive: true
+         }
+      })
+
+      if (cek == 0) {
+         return NextResponse.json({ success: false, message: "Gagal mengedit komentar, data tidak ditemukan" }, { status: 200 });
+      }
+
+
+      const data = await prisma.discussionComment.update({
+         where: {
+            id
+         },
+         data: {
+            isActive: false
+         }
+      })
+
+      // create log user
+      const log = await createLogUserMobile({ act: 'DELETE', desc: 'User menghapus komentar pada diskusi umum', table: 'discussionComment', data: id, user: userMobile.id })
+      return NextResponse.json({ success: true, message: "Berhasil mengedit komentar" }, { status: 200 });
+
+   } catch (error) {
+      console.error(error)
+      return NextResponse.json({ success: false, message: "Gagal mengedit komentar, coba lagi nanti (error: 500)" })
+   }
 }

src/app/api/mobile/discussion-general/[id]/route.ts

@@ -1,4 +1,4 @@
-import { countTime, prisma } from "@/module/_global";
+import { countTime, DIR, funUploadFile, prisma } from "@/module/_global";
 import { funGetUserById } from "@/module/auth";
 import { createLogUserMobile } from "@/module/user";
 import _ from "lodash";
@@ -19,7 +19,7 @@ export async function GET(request: Request, context: { params: { id: string } })
       const user = await funGetUserById({ id: String(userMobile) })
 
       if (user.id == "null" || user.id == undefined || user.id == "") {
-         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
       }
 
       const cek = await prisma.discussion.count({
@@ -29,7 +29,7 @@ export async function GET(request: Request, context: { params: { id: string } })
       })
 
       if (cek == 0) {
-         return NextResponse.json({ success: false, message: "Gagal mendapatkan diskusi, data tidak ditemukan" }, { status: 404 });
+         return NextResponse.json({ success: false, message: "Gagal mendapatkan diskusi, data tidak ditemukan" }, { status: 200 });
       }
 
       if (kategori == "detail") {
@@ -77,6 +77,9 @@ export async function GET(request: Request, context: { params: { id: string } })
                      img: true
                   }
                }
+            },
+            orderBy: {
+               createdAt: "asc"
             }
          })
 
@@ -124,8 +127,21 @@ export async function GET(request: Request, context: { params: { id: string } })
          } else {
             dataFix = false
          }
-      }
+      } else if (kategori == "file") {
+         const data = await prisma.discussionFile.findMany({
+            where: {
+               idDiscussion: id
+            },
+            select: {
+               id: true,
+               idStorage: true,
+               name: true,
+               extension: true
+            }
+         })
 
+         dataFix = data
+      }
 
       return NextResponse.json({ success: true, message: "Berhasil mendapatkan diskusi", data: dataFix }, { status: 200 });
 
@@ -244,7 +260,12 @@ export async function DELETE(request: Request, context: { params: { id: string }
 export async function PUT(request: Request, context: { params: { id: string } }) {
    try {
       const { id } = context.params
-      const { title, desc, user } = (await request.json());
+      const body = await request.formData()
+      const dataBody = body.get("data")
+      const cekFile = body.has("file0")
+
+      // const { title, desc, user } = (await request.json());
+      const { title, desc, user, oldFile } = JSON.parse(dataBody as string)
 
       const userMobile = await funGetUserById({ id: String(user) })
 
@@ -272,6 +293,41 @@ export async function PUT(request: Request, context: { params: { id: string } })
          }
       });
 
+      if (oldFile.length > 0) {
+         for (let index = 0; index < oldFile.length; index++) {
+            const element = oldFile[index];
+            if (element.delete) {
+               await prisma.discussionFile.delete({
+                  where: {
+                     id: element.id
+                  }
+               })
+            }
+         }
+      }
+
+      if (cekFile) {
+         body.delete("data")
+         for (var pair of body.entries()) {
+            if (String(pair[0]).substring(0, 4) == "file") {
+               const file = body.get(pair[0]) as File
+               const fExt = file.name.split(".").pop()
+               const fName = decodeURIComponent(file.name.replace("." + fExt, ""))
+               const upload = await funUploadFile({ file: file, dirId: DIR.discussion })
+               if (upload.success) {
+                  await prisma.discussionFile.create({
+                     data: {
+                        idStorage: upload.data.id,
+                        idDiscussion: id,
+                        name: fName,
+                        extension: String(fExt)
+                     }
+                  })
+               }
+            }
+         }
+      }
+
       // create log user
       const log = await createLogUserMobile({ act: 'UPDATE', desc: 'User mengupdate data diskusi umum', table: 'discussion', data: id, user: userMobile.id })
       return NextResponse.json({ success: true, message: "Berhasil mengedit diskusi umum" }, { status: 200 });

src/app/api/mobile/discussion-general/route.ts

@@ -1,4 +1,4 @@
-import { prisma } from "@/module/_global";
+import { DIR, funUploadFile, prisma } from "@/module/_global";
 import { funGetUserById } from "@/module/auth";
 import { createLogUserMobile } from "@/module/user";
 import _ from "lodash";
@@ -15,7 +15,7 @@ export async function GET(request: Request) {
       const { searchParams } = new URL(request.url);
       const user = searchParams.get("user")
       if (user == "null" || user == undefined || user == "") {
-         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
       }
 
       const userMobile = await funGetUserById({ id: user })
@@ -75,6 +75,9 @@ export async function GET(request: Request) {
             DiscussionComment: {
                select: {
                   id: true,
+               },
+               where: {
+                  isActive: true
                }
             }
          }
@@ -109,13 +112,20 @@ export async function GET(request: Request) {
 // CREATE DISCUSSION GENERALE
 export async function POST(request: Request) {
    try {
-      const { idGroup, user, title, desc, member } = await request.json();
 
-      if (user == "null" || user == undefined || user == "") {
+      const body = await request.formData()
+      const dataBody = body.get("data")
+      const cekFile = body.has("file0")
+
+      // const { idGroup, user, title, desc, member } = await request.json();
+      const { idGroup, user, title, desc, member } = JSON.parse(dataBody as string)
+
+      const userMobile = await funGetUserById({ id: user })
+
+      if (userMobile.id == "null" || userMobile.id == undefined || userMobile.id == "") {
          return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
       }
 
-      const userMobile = await funGetUserById({ id: user })
       const userId = user
       const userRoleLogin = userMobile.idUserRole
 
@@ -142,6 +152,29 @@ export async function POST(request: Request) {
          data: dataMember
       })
 
+
+      if (cekFile) {
+         body.delete("data")
+         for (var pair of body.entries()) {
+            if (String(pair[0]).substring(0, 4) == "file") {
+               const file = body.get(pair[0]) as File
+               const fExt = file.name.split(".").pop()
+               const fName = decodeURIComponent(file.name.replace("." + fExt, ""))
+               const upload = await funUploadFile({ file: file, dirId: DIR.discussion })
+               if (upload.success) {
+                  await prisma.discussionFile.create({
+                     data: {
+                        idStorage: upload.data.id,
+                        idDiscussion: data.id,
+                        name: fName,
+                        extension: String(fExt)
+                     }
+                  })
+               }
+            }
+         }
+      }
+
       const memberNotifMobile = await prisma.discussionMember.findMany({
          where: {
             idDiscussion: data.id

src/app/api/mobile/discussion/[id]/comment/route.ts

@@ -5,7 +5,7 @@ import _ from "lodash";
 import { NextResponse } from "next/server";
 import { sendFCMNotificationMany } from "../../../../../../../xsendMany";
 
-// CREATE COMENT BY ID KOMENTAR
+// CREATE COMENT
 export async function POST(request: Request, context: { params: { id: string } }) {
     try {
         const { id } = context.params
@@ -156,4 +156,103 @@ export async function POST(request: Request, context: { params: { id: string } }
         console.error(error);
         return NextResponse.json({ success: false, message: "Gagal menambah komentar, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
     }
+}
+
+// EDIT KOMENTAR
+export async function PUT(request: Request, context: { params: { id: string } }) {
+    try {
+        const { id } = context.params
+        const { comment, user } = (await request.json());
+
+        const userMobile = await funGetUserById({ id: String(user) })
+
+        if (userMobile.id == "null" || userMobile.id == undefined || userMobile.id == "") {
+            return NextResponse.json({ success: false, message: "User tidak ditemukan" }, { status: 200 });
+        }
+
+        const cek = await prisma.divisionDisscussionComment.count({
+            where: {
+                id,
+                isActive: true
+            }
+        })
+
+        if (cek == 0) {
+            return NextResponse.json(
+                {
+                    success: false,
+                    message: "Edit komentar gagal, data tidak ditemukan",
+                },
+                { status: 200 }
+            );
+        }
+
+        const data = await prisma.divisionDisscussionComment.update({
+            where: {
+                id: id
+            },
+            data: {
+                comment: comment,
+                isEdited: true
+            }
+        })
+
+        // create log user
+        const log = await createLogUserMobile({ act: 'UPDATE', desc: 'User mengedit komentar pada diskusi divisi', table: 'divisionDisscussionComment', data: id, user: userMobile.id })
+
+        return NextResponse.json({ success: true, message: "Berhasil mengedit komentar" }, { status: 200 });
+
+    } catch (error) {
+        console.error(error);
+        return NextResponse.json({ success: false, message: "Gagal menambah komentar, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
+    }
+}
+
+// HAPUS KOMENTAR
+export async function DELETE(request: Request, context: { params: { id: string } }) {
+    try {
+        const { id } = context.params
+        const { user } = (await request.json());
+
+        const userMobile = await funGetUserById({ id: String(user) })
+
+        if (userMobile.id == "null" || userMobile.id == undefined || userMobile.id == "") {
+            return NextResponse.json({ success: false, message: "User tidak ditemukan" }, { status: 200 });
+        }
+
+        const cek = await prisma.divisionDisscussionComment.count({
+            where: {
+                id,
+                isActive: true
+            }
+        })
+
+        if (cek == 0) {
+            return NextResponse.json(
+                {
+                    success: false,
+                    message: "Hapus komentar gagal, data tidak ditemukan",
+                },
+                { status: 200 }
+            );
+        }
+
+        const data = await prisma.divisionDisscussionComment.update({
+            where: {
+                id: id
+            },
+            data: {
+                isActive: false
+            }
+        })
+
+        // create log user
+        const log = await createLogUserMobile({ act: 'DELETE', desc: 'User menghapus komentar pada diskusi divisi', table: 'divisionDisscussionComment', data: id, user: userMobile.id })
+
+        return NextResponse.json({ success: true, message: "Berhasil menghapus komentar" }, { status: 200 });
+
+    } catch (error) {
+        console.error(error);
+        return NextResponse.json({ success: false, message: "Gagal menghapus komentar, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });
+    }
 }

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

@@ -1,4 +1,4 @@
-import { countTime, prisma } from "@/module/_global";
+import { countTime, DIR, funUploadFile, prisma } from "@/module/_global";
 import { funGetUserById } from "@/module/auth";
 import { createLogUserMobile } from "@/module/user";
 import _ from "lodash";
@@ -31,14 +31,15 @@ export async function GET(request: Request, context: { params: { id: string } })
                     success: false,
                     message: "Gagal mendapatkan diskusi, data tidak ditemukan",
                 },
-                { status: 404 }
+                { status: 200 }
             );
         }
 
         if (cat == "comment") {
             const data = await prisma.divisionDisscussionComment.findMany({
                 where: {
-                    idDisscussion: id
+                    idDisscussion: id,
+                    isActive: true
                 },
                 select: {
                     id: true,
@@ -53,6 +54,9 @@ export async function GET(request: Request, context: { params: { id: string } })
                             img: true
                         }
                     }
+                },
+                orderBy: {
+                    createdAt: "asc"
                 }
             })
 
@@ -66,6 +70,21 @@ export async function GET(request: Request, context: { params: { id: string } })
             }))
 
             return NextResponse.json({ success: true, message: "Berhasil mendapatkan komentar", data: omitMember }, { status: 200 });
+        } else if (cat == "file") {
+            const data = await prisma.divisionDiscussionFile.findMany({
+                where: {
+                    idDiscussion: id,
+                    isActive: true
+                },
+                select: {
+                    id: true,
+                    idStorage: true,
+                    name: true,
+                    extension: true
+                }
+            })
+
+            return NextResponse.json({ success: true, message: "Berhasil mendapatkan file", data: data }, { status: 200 });
         } else {
             const data = await prisma.divisionDisscussion.findUnique({
                 where: {
@@ -133,7 +152,7 @@ export async function DELETE(request: Request, context: { params: { id: string }
         });
 
         if (data == 0) {
-            return NextResponse.json({ success: false, message: "Gagal mendapatkan diskusi, data tidak ditemukan" }, { status: 404 });
+            return NextResponse.json({ success: false, message: "Gagal mendapatkan diskusi, data tidak ditemukan" }, { status: 200 });
         }
 
         const result = await prisma.divisionDisscussion.update({
@@ -208,7 +227,13 @@ export async function PUT(request: Request, context: { params: { id: string } })
 export async function POST(request: Request, context: { params: { id: string } }) {
     try {
         const { id } = context.params
-        const { title, desc, user } = (await request.json())
+        const body = await request.formData()
+        const dataBody = body.get("data")
+        const cekFile = body.has("file0")
+
+        // const { title, desc, user } = (await request.json())
+        const { title, desc, user, oldFile } = JSON.parse(dataBody as string)
+
 
         const userMobile = await funGetUserById({ id: String(user) })
 
@@ -235,6 +260,41 @@ export async function POST(request: Request, context: { params: { id: string } }
             }
         });
 
+        if (oldFile.length > 0) {
+            for (let index = 0; index < oldFile.length; index++) {
+                const element = oldFile[index];
+                if (element.delete) {
+                    await prisma.divisionDiscussionFile.delete({
+                        where: {
+                            id: element.id
+                        }
+                    })
+                }
+            }
+        }
+
+        if (cekFile) {
+            body.delete("data")
+            for (var pair of body.entries()) {
+                if (String(pair[0]).substring(0, 4) == "file") {
+                    const file = body.get(pair[0]) as File
+                    const fExt = file.name.split(".").pop()
+                    const fName = decodeURIComponent(file.name.replace("." + fExt, ""))
+                    const upload = await funUploadFile({ file: file, dirId: DIR.discussionDivision })
+                    if (upload.success) {
+                        await prisma.divisionDiscussionFile.create({
+                            data: {
+                                idStorage: upload.data.id,
+                                idDiscussion: id,
+                                name: fName,
+                                extension: String(fExt)
+                            }
+                        })
+                    }
+                }
+            }
+        }
+
         // create log user
         const log = await createLogUserMobile({ act: 'UPDATE', desc: 'User mengupdate data diskusi', table: 'divisionDisscussion', data: id, user: userMobile.id })
         return NextResponse.json({ success: true, message: "Berhasil mengedit diskusi" }, { status: 200 });

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

@@ -1,4 +1,4 @@
-import { funSendWebPush, prisma } from "@/module/_global";
+import { DIR, funSendWebPush, funUploadFile, prisma } from "@/module/_global";
 import { funGetUserById } from "@/module/auth";
 import { createLogUserMobile } from "@/module/user";
 import _ from "lodash";
@@ -35,7 +35,7 @@ export async function GET(request: Request) {
          })
 
          if (cekDivision == 0) {
-            return NextResponse.json({ success: false, message: "Gagal mendapatkan divisi, data tidak ditemukan" }, { status: 404 });
+            return NextResponse.json({ success: false, message: "Gagal mendapatkan divisi, data tidak ditemukan" }, { status: 200 });
          }
 
          const data = await prisma.divisionDisscussion.findMany({
@@ -67,6 +67,9 @@ export async function GET(request: Request) {
                DivisionDisscussionComment: {
                   select: {
                      id: true,
+                  },
+                  where: {
+                     isActive: true
                   }
                }
             }
@@ -99,7 +102,14 @@ export async function GET(request: Request) {
 // CREATE DISCUSSION
 export async function POST(request: Request) {
    try {
-      const { idDivision, desc, user } = (await request.json());
+      const body = await request.formData()
+      const dataBody = body.get("data")
+      const cekFile = body.has("file0")
+
+      // const { idDivision, desc, user } = (await request.json());
+      const { idDivision, desc, user } = JSON.parse(String(dataBody));
+
+
       const userMobile = await funGetUserById({ id: String(user) })
 
       if (userMobile.id == "null" || userMobile.id == undefined || userMobile.id == "") {
@@ -118,7 +128,7 @@ export async function POST(request: Request) {
       })
 
       if (cekDivision == 0) {
-         return NextResponse.json({ success: false, message: "Gagal mendapatkan divisi, data tidak ditemukan" }, { status: 404 });
+         return NextResponse.json({ success: false, message: "Gagal mendapatkan divisi, data tidak ditemukan" }, { status: 200 });
       }
 
       const data = await prisma.divisionDisscussion.create({
@@ -132,6 +142,29 @@ export async function POST(request: Request) {
          }
       });
 
+
+      if (cekFile) {
+         body.delete("data")
+         for (var pair of body.entries()) {
+            if (String(pair[0]).substring(0, 4) == "file") {
+               const file = body.get(pair[0]) as File
+               const fExt = file.name.split(".").pop()
+               const fName = decodeURIComponent(file.name.replace("." + fExt, ""))
+               const upload = await funUploadFile({ file: file, dirId: DIR.discussionDivision })
+               if (upload.success) {
+                  await prisma.divisionDiscussionFile.create({
+                     data: {
+                        idStorage: upload.data.id,
+                        idDiscussion: data.id,
+                        name: fName,
+                        extension: String(fExt)
+                     }
+                  })
+               }
+            }
+         }
+      }
+
       const memberDivision = await prisma.divisionMember.findMany({
          where: {
             idDivision: idDivision

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

@@ -12,7 +12,7 @@ export async function GET(request: Request, context: { params: { id: string } })
       const userMobile = searchParams.get("user")
 
       if (userMobile == "null" || userMobile == undefined || userMobile == "") {
-         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
       }
 
       const { id } = context.params;
@@ -28,7 +28,7 @@ export async function GET(request: Request, context: { params: { id: string } })
                success: false,
                message: "Gagal mendapatkan grup, data tidak ditemukan",
             },
-            { status: 404 }
+            { status: 200 }
          );
       }
 
@@ -52,7 +52,7 @@ export async function DELETE(request: Request, context: { params: { id: string }
       const { isActive, user } = (await request.json());
 
       if (user == "null" || user == undefined || user == "") {
-         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
       }
       const userLogin = await funGetUserById({ id: user })
 
@@ -68,7 +68,7 @@ export async function DELETE(request: Request, context: { params: { id: string }
                success: false,
                message: "Edit grup gagal, data tidak ditemukan",
             },
-            { status: 404 }
+            { status: 200 }
          );
       }
 
@@ -98,7 +98,7 @@ export async function PUT(request: Request, context: { params: { id: string } })
       const { name, user } = (await request.json());
 
       if (user == "null" || user == undefined || user == "") {
-         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
       }
 
       const data = await prisma.group.count({
@@ -113,7 +113,7 @@ export async function PUT(request: Request, context: { params: { id: string } })
                success: false,
                message: "Edit grup gagal, data tidak ditemukan",
             },
-            { status: 404 }
+            { status: 200 }
          );
       }
 

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

@@ -11,7 +11,7 @@ export async function GET(request: Request) {
       const userMobile = searchParams.get("user")
 
       if (userMobile == "null" || userMobile == undefined || userMobile == "") {
-         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
       }
 
       const user = await funGetUserById({ id: userMobile })
@@ -51,7 +51,7 @@ export async function POST(request: Request) {
       const { name, user } = (await request.json());
 
       if (user == "null" || user == undefined || user == "") {
-         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+         return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
       }
 
       const userMobile = await funGetUserById({ id: user })

src/app/api/mobile/home/search/route.ts

@@ -11,7 +11,7 @@ export async function GET(request: Request) {
         const userMobile = searchParams.get("user")
 
         if (userMobile == "null" || userMobile == undefined || userMobile == "") {
-            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
         }
 
         const userId = await funGetUserById({ id: userMobile })

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

@@ -11,7 +11,7 @@ export async function GET(request: Request, context: { params: { id: string } })
         const { id } = context.params;
 
         if (userMobile == "null" || userMobile == undefined || userMobile == "") {
-            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
         }
 
         const data = await prisma.position.findUnique({
@@ -30,7 +30,7 @@ export async function GET(request: Request, context: { params: { id: string } })
                     success: false,
                     message: "Gagal mendapatkan jabatan, data tidak ditemukan",
                 },
-                { status: 404 }
+                { status: 200 }
             );
         }
 
@@ -55,7 +55,7 @@ export async function DELETE(request: Request, context: { params: { id: string }
         const { isActive, user } = (await request.json());
 
         if (user == "null" || user == undefined || user == "") {
-            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
         }
 
         const data = await prisma.position.count({
@@ -104,7 +104,7 @@ export async function PUT(request: Request, context: { params: { id: string } })
         const { name, idGroup, user } = await request.json();
 
         if (user == "null" || user == undefined || user == "") {
-            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
         }
 
         const cek = await prisma.position.count({

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

@@ -16,7 +16,7 @@ export async function GET(request: Request) {
         const userMobile = searchParams.get("user")
 
         if (userMobile == "null" || userMobile == undefined || userMobile == "") {
-            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
         }
 
         const user = await funGetUserById({ id: userMobile })
@@ -35,7 +35,7 @@ export async function GET(request: Request) {
         })
 
         if (cek == 0) {
-            return NextResponse.json({ success: false, message: "Gagal mendapatkan jabatan, data tidak ditemukan", }, { status: 404 });
+            return NextResponse.json({ success: false, message: "Gagal mendapatkan jabatan, data tidak ditemukan", }, { status: 200 });
         }
 
         const filter = await prisma.group.findUnique({
@@ -93,7 +93,7 @@ export async function POST(request: Request) {
         const { name, idGroup, user } = await request.json();
 
         if (user == "null" || user == undefined || user == "") {
-            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
         }
 
         const userMobile = await funGetUserById({ id: user })
@@ -131,7 +131,7 @@ export async function POST(request: Request) {
         } else {
             return NextResponse.json(
                 { success: false, message: "Jabatan sudah ada" },
-                { status: 400 }
+                { status: 200 }
             );
         }
 

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

@@ -87,7 +87,7 @@ export async function DELETE(request: Request, context: { params: { id: string }
         const { isActive, user } = (await request.json());
 
         if (user == "null" || user == undefined || user == "") {
-            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
         }
 
         const data = await prisma.user.count({
@@ -102,7 +102,7 @@ export async function DELETE(request: Request, context: { params: { id: string }
                     success: false,
                     message: "Gagal mendapatkan anggota, data tidak ditemukan",
                 },
-                { status: 404 }
+                { status: 200 }
             );
         }
 
@@ -158,7 +158,7 @@ export async function PUT(request: Request, context: { params: { id: string } })
         } = JSON.parse(data as string)
 
         if (user == "null" || user == undefined || user == "") {
-            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
         }
 
         const cekNIK = await prisma.user.count({
@@ -247,7 +247,7 @@ export async function PUT(request: Request, context: { params: { id: string } })
                 { status: 200 }
             );
         } else {
-            return Response.json({ success: false, message: "Anggota sudah ada" }, { status: 400 });
+            return Response.json({ success: false, message: "Anggota sudah ada" }, { status: 200 });
         }
     } catch (error) {
         console.error(error);

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

@@ -11,7 +11,7 @@ export async function GET(request: Request) {
     try {
         const user = await funGetUserByCookies()
         if (user.id == undefined) {
-            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 401 });
+            return NextResponse.json({ success: false, message: "Anda harus login untuk mengakses ini" }, { status: 200 });
         }
         const data = await prisma.user.findUnique({
             where: {

src/app/api/version-app/route.ts

@@ -2,7 +2,7 @@ import { NextResponse } from "next/server";
 
 export async function GET(request: Request) {
    try {
-      return NextResponse.json({ success: true, version: "2.0.7", tahap: "beta", update: "-api mobile; -login tanpa otp (mobile app); -tambah laporan pada project dan tugas divisi; -tambah upload link pada project dan tugas divisi; -tambah detail tanggal dan jam pada project dan tugas divisi; -api jenna ai; -privacy policy" }, { status: 200 });
+      return NextResponse.json({ success: true, version: "2.1.0", tahap: "beta", update: "-api mobile; -login tanpa otp (mobile app); -tambah laporan pada project dan tugas divisi; -tambah upload link pada project dan tugas divisi; -tambah detail tanggal dan jam pada project dan tugas divisi; -api jenna ai; -privacy policy" }, { status: 200 });
    } catch (error) {
       console.error(error);
       return NextResponse.json({ success: false, version: "Gagal mendapatkan version, coba lagi nanti (error: 500)", reason: (error as Error).message, }, { status: 500 });

src/module/_global/bin/val_global.ts

@@ -1,6 +1,6 @@
-import { hookstate } from "@hookstate/core"
-import { IGlobalTema } from './type_global';
+import { hookstate } from "@hookstate/core";
 import { RefObject } from "react";
+import { IGlobalTema } from './type_global';
 
 export const pwd_key_config = "fchgvjknlmdfnbvghhujlaknsdvjbhknlkmsdbdyu567t8y9u30r4587638y9uipkoeghjvuyi89ipkoefmnrjbhtiu4or9ipkoemnjfbhjiuoijdklnjhbviufojkejnshbiuojijknehgruyu"
 export const globalRole = hookstate<string>('')
@@ -11,7 +11,10 @@ export const DIR = {
    document: "cm0xhbkf50009acbbtw03qo4l",
    village: "cm0xhb91o0007acbbkx8rk8hj",
    user: "cm0x8dbwn0005bp5tgmfcthzw",
-   banner: "cm1sxex19004938bjvyaq8vta"
+   banner: "cm1sxex19004938bjvyaq8vta",
+   announcement: "cmkdfkze4005hkhjgunsroi4t",
+   discussion: "cmkf5h7ic006jkhjgyrkog7ut",
+   discussionDivision: "cmkdfktfm005fkhjggjvnqly5"
 }
 
 export const keyWibu = 'padahariminggukuturutayahkekotanaikdelmanistimewakududukdimuka'

src/module/seeder/data/admin.json

@@ -8,15 +8,7 @@
       "gender": "F"
    },
    {
-      "id": "devLukman",
-      "idAdminRole": "dev",
-      "name": "Lukman",
-      "phone": "6287701790942",
-      "email": "lukman@bip.com",
-      "gender": "M"
-   },
-   {
-      "id": "devLukman",
+      "id": "devMalik",
       "idAdminRole": "dev",
       "name": "Malik",
       "phone": "6289697338821",