tampilan pelayanan surat

Deskripsi:
- tampilan list pelayanan surat

No Issues

prisma/schema.prisma

@@ -193,7 +193,7 @@ model SuratPelayanan {
 
 model Configuration {
   id        String   @id @default(cuid())
-  category  String
+  name      String
   value     String
   createdAt DateTime @default(now())
   updatedAt DateTime @updatedAt

prisma/seed.ts

@@ -1,4 +1,5 @@
 import { categoryPelayananSurat } from "@/lib/categoryPelayananSurat";
+import { confDesa } from "@/lib/configurationDesa";
 import { prisma } from "@/server/lib/prisma";
 
 const category = [
@@ -51,7 +52,6 @@ const user = [
 
 (async () => {
     for (const r of role) {
-        console.log(`Seeding role ${r.name}`)
         await prisma.role.upsert({
             where: { id: r.id },
             create: r,
@@ -81,7 +81,7 @@ const user = [
         console.log(`✅ Category ${c.name} seeded successfully`)
     }
 
-    for (const cp of categoryPelayananSurat){
+    for (const cp of categoryPelayananSurat) {
         await prisma.categoryPelayanan.upsert({
             where: { id: cp.id },
             create: cp,
@@ -91,6 +91,15 @@ const user = [
         console.log(`✅ Category Pelayanan ${cp.name} seeded successfully`)
     }
 
+    for (const c of confDesa) {
+        await prisma.configuration.upsert({
+            where: { id: c.id },
+            create: c,
+            update: c
+        })
+
+        console.log(`✅ Configuration ${c.name} seeded successfully`)
+    }
 
 
 

src/AppRoutes.tsx

@@ -17,6 +17,8 @@ import FormSuratKeteranganKelakuanBaik from "./pages/darmasaba/form_surat_ketera
 import Home from "./pages/Home";
 import CredentialPage from "./pages/scr/dashboard/credential/credential_page";
 import DashboardHome from "./pages/scr/dashboard/dashboard_home";
+import ListPelayananPage from "./pages/scr/dashboard/pelayanan-surat/list_pelayanan_page";
+import ListPage from "./pages/scr/dashboard/pengaduan/list_page";
 import ApikeyPage from "./pages/scr/dashboard/apikey/apikey_page";
 import DashboardLayout from "./pages/scr/dashboard/dashboard_layout";
 import ScrLayout from "./pages/scr/scr_layout";
@@ -92,6 +94,14 @@ export default function AppRoutes() {
               path="/scr/dashboard/dashboard-home"
               element={<DashboardHome />}
             />
+            <Route
+              path="/scr/dashboard/pelayanan-surat/list-pelayanan"
+              element={<ListPelayananPage />}
+            />
+            <Route
+              path="/scr/dashboard/pengaduan/list"
+              element={<ListPage />}
+            />
             <Route
               path="/scr/dashboard/apikey/apikey"
               element={<ApikeyPage />}

src/clientRoutes.ts

@@ -19,6 +19,8 @@ const clientRoutes = {
   "/scr/dashboard": "/scr/dashboard",
   "/scr/dashboard/credential/credential": "/scr/dashboard/credential/credential",
   "/scr/dashboard/dashboard-home": "/scr/dashboard/dashboard-home",
+  "/scr/dashboard/pelayanan-surat/list-pelayanan": "/scr/dashboard/pelayanan-surat/list-pelayanan",
+  "/scr/dashboard/pengaduan/list": "/scr/dashboard/pengaduan/list",
   "/scr/dashboard/apikey/apikey": "/scr/dashboard/apikey/apikey",
   "/dir/dir": "/dir/dir",
   "/*": "/*"

src/index.tsx

@@ -13,6 +13,7 @@ import { MCPRoute } from "./server/routes/mcp_route";
 import PelayananRoute from "./server/routes/pelayanan_surat_route";
 import PengaduanRoute from "./server/routes/pengaduan_route";
 import UserRoute from "./server/routes/user_route";
+import cors from "@elysiajs/cors";
 
 const Docs = new Elysia({
   tags: ["docs"],
@@ -40,6 +41,13 @@ const app = new Elysia()
   .use(Api)
   .use(Docs)
   .use(Auth)
+  .use(
+    cors({
+      origin: "*",
+      methods: ["GET", "POST", "OPTIONS"],
+      allowedHeaders: ["Content-Type"],
+    }),
+  )
   .get(
     "/.well-known/mcp.json",
     async () => {

src/lib/configurationDesa.ts

@@ -0,0 +1,57 @@
+export const confDesa = [
+   {
+      id: "desaNama",
+      name: "Nama Desa",
+      value: "Darmasaba"
+   },
+   {
+      id: "desaKabupaten",
+      name: "Kabupaten",
+      value: "Badung"
+   },
+   {
+      id: "desaKecamatan",
+      name: "Kecamatan",
+      value: "Abiansemal"
+   },
+   {
+      id: "desaAlamat",
+      name: "Alamat Kantor Desa",
+      value: "Jl. Raya Darmasaba No.22, Darmasaba"
+   },
+   {
+      id: "desaPos",
+      name: "Kode Pos",
+      value: "80352"
+   },
+   {
+      id: "desaTelepon",
+      name: "Telepon",
+      value: "081239580000"
+   },
+   {
+      id: "desaEmail",
+      name: "Email",
+      value: "desadarmasaba@badungkab.go.id"
+   },
+   {
+      id: "perbekelNama",
+      name: "Nama Perbekel",
+      value: "Ida Bagus Surya Prabhawa Manuaba, S.H., M.H., N.L.P."
+   },
+   {
+      id: "perbekelJabatan",
+      name: "Jabatan",
+      value: "Perbekel"
+   },
+   {
+      id: "perbekelNIP",
+      name: "NIP",
+      value: ""
+   },
+   {
+      id: "perbekelTTD",
+      name: "TTD",
+      value: ""
+   },
+];

src/pages/dir/dir_page.tsx

@@ -2,16 +2,16 @@ import { Tree } from "@mantine/core";
 
 // ✅ Valid data, all values are unique
 const data = [
-    {
-      value: 'src',
-      label: 'src',
-      children: [
-        { value: 'src/components', label: 'components' },
-        { value: 'src/hooks', label: 'hooks' },
-      ],
-    },
-    { value: 'package.json', label: 'package.json' },
-  ];
+  {
+    value: "src",
+    label: "src",
+    children: [
+      { value: "src/components", label: "components" },
+      { value: "src/hooks", label: "hooks" },
+    ],
+  },
+  { value: "package.json", label: "package.json" },
+];
 
 export default function DirPage() {
   return (

src/pages/scr/dashboard/dashboard_layout.tsx

@@ -1,4 +1,8 @@
-import { useEffect, useState } from "react";
+import {
+  default as clientRoute,
+  default as clientRoutes,
+} from "@/clientRoutes";
+import apiFetch from "@/lib/apiFetch";
 import {
   ActionIcon,
   AppShell,
@@ -22,17 +26,17 @@ import {
   IconChevronLeft,
   IconChevronRight,
   IconDashboard,
+  IconFileCertificate,
   IconKey,
   IconLock,
+  IconMessageReport,
+  IconSettings,
   IconUser,
+  IconUsersGroup,
 } from "@tabler/icons-react";
 import type { User } from "generated/prisma";
+import { useEffect, useState } from "react";
 import { Outlet, useLocation, useNavigate } from "react-router-dom";
-import {
-  default as clientRoute,
-  default as clientRoutes,
-} from "@/clientRoutes";
-import apiFetch from "@/lib/apiFetch";
 
 function Logout() {
   return (
@@ -98,7 +102,7 @@ export default function DashboardLayout() {
                 size="lg"
                 style={{
                   backgroundColor: "rgba(255,255,255,0.05)",
-                  boxShadow: "0 0 6px rgba(0,255,200,0.2)",
+                  boxShadow: "0 0 6px hsla(167, 100%, 50%, 0.20), 0.20)",
                 }}
               >
                 {opened ? <IconChevronLeft /> : <IconChevronRight />}
@@ -186,7 +190,7 @@ function HostView() {
                 {host.name}
               </Text>
               <Text size="sm" c="dimmed">
-                {host.email}
+                {host.roleId}
               </Text>
             </Stack>
           </Flex>
@@ -219,6 +223,31 @@ function NavigationDashboard() {
       label: "Dashboard Overview",
       description: "Quick summary and insights",
     },
+    {
+      path: "/scr/dashboard/pengaduan/list",
+      icon: <IconMessageReport size={20} />,
+      label: "Pengaduan Warga",
+      description: "Manage pengaduan warga",
+    },
+    {
+      path: "/scr/dashboard/pelayanan-surat/list-pelayanan",
+      icon: <IconFileCertificate size={20} />,
+      label: "Pelayanan Surat",
+      description: "Manage pelayanan surat",
+    },
+    {
+      path: "/scr/dashboard/user",
+      icon: <IconUsersGroup size={20} />,
+      label: "User",
+      description: "Manage user",
+    },
+    {
+      path: "/scr/dashboard/setting",
+      icon: <IconSettings size={20} />,
+      label: "Setting",
+      description:
+        "Manage setting (category pengaduan dan pelayanan surat, desa, etc)",
+    },
     {
       path: "/scr/dashboard/apikey/apikey",
       icon: <IconKey size={20} />,

src/pages/scr/dashboard/pelayanan-surat/list_pelayanan_page.tsx

@@ -0,0 +1,271 @@
+import apiFetch from "@/lib/apiFetch";
+import {
+  Badge,
+  Card,
+  CloseButton,
+  Container,
+  Divider,
+  Flex,
+  Group,
+  Input,
+  Stack,
+  Tabs,
+  Text,
+  Title,
+} from "@mantine/core";
+import { useShallowEffect } from "@mantine/hooks";
+import {
+  IconAlignJustified,
+  IconClockHour3,
+  IconFileSad,
+  IconMapPin,
+  IconSearch,
+} from "@tabler/icons-react";
+import { useState } from "react";
+import { useLocation, useNavigate } from "react-router-dom";
+import useSwr from "swr";
+import { proxy } from "valtio";
+
+const state = proxy({ reload: "" });
+function reloadState() {
+  state.reload = Math.random().toString();
+}
+
+export default function PelayananSuratListPage() {
+  const { search } = useLocation();
+  const query = new URLSearchParams(search);
+  const status = query.get("status") as StatusKey;
+
+  return (
+    <Container size="xl" py="xl" w={"100%"}>
+      <Stack gap="xl">
+        <TabListPelayananSurat status={status || "semua"} />
+        <ListPelayananSurat status={status || "semua"} />
+      </Stack>
+    </Container>
+  );
+}
+
+function TabListPelayananSurat({ status }: { status: string }) {
+  const navigate = useNavigate();
+  const dataCount = useSwr("/pelayanan-surat/count", () =>
+    apiFetch.api.pengaduan.count.get().then((res) => res.data),
+  );
+
+  return (
+    <Tabs defaultValue={status || "semua"} color="teal">
+      <Tabs.List grow>
+        <Tabs.Tab
+          value="all"
+          onClick={() => {
+            navigate("?status=semua");
+          }}
+        >
+          Semua ({dataCount?.data?.semua || 0})
+        </Tabs.Tab>
+        <Tabs.Tab
+          value="antrian"
+          onClick={() => {
+            navigate("?status=antrian");
+          }}
+        >
+          Antrian ({dataCount?.data?.antrian || 0})
+        </Tabs.Tab>
+        <Tabs.Tab
+          value="diterima"
+          onClick={() => {
+            navigate("?status=diterima");
+          }}
+        >
+          Diterima ({dataCount?.data?.diterima || 0})
+        </Tabs.Tab>
+        <Tabs.Tab
+          value="dikerjakan"
+          onClick={() => {
+            navigate("?status=dikerjakan");
+          }}
+        >
+          Dikerjakan ({dataCount?.data?.dikerjakan || 0})
+        </Tabs.Tab>
+        <Tabs.Tab
+          value="selesai"
+          onClick={() => {
+            navigate("?status=selesai");
+          }}
+        >
+          Selesai ({dataCount?.data?.selesai || 0})
+        </Tabs.Tab>
+        <Tabs.Tab
+          value="ditolak"
+          onClick={() => {
+            navigate("?status=ditolak");
+          }}
+        >
+          Ditolak ({dataCount?.data?.ditolak || 0})
+        </Tabs.Tab>
+      </Tabs.List>
+    </Tabs>
+  );
+}
+
+type StatusKey =
+  | "antrian"
+  | "diterima"
+  | "dikerjakan"
+  | "ditolak"
+  | "selesai"
+  | "semua";
+function ListPelayananSurat({ status }: { status: StatusKey }) {
+  const [page, setPage] = useState(1);
+  const [value, setValue] = useState("");
+  const { data, mutate, isLoading } = useSwr("/", () =>
+    apiFetch.api.pengaduan.list.get({
+      query: {
+        status,
+        search: value,
+        take: "",
+        page: "",
+      },
+    }),
+  );
+
+  useShallowEffect(() => {
+    mutate();
+  }, [status, value]);
+
+  if (isLoading)
+    return (
+      <Card
+        radius="lg"
+        p="xl"
+        withBorder
+        style={{
+          background:
+            "linear-gradient(145deg, rgba(25,25,25,0.95), rgba(45,45,45,0.85))",
+        }}
+      >
+        <Text size="sm" c="dimmed">
+          Loading pengaduan...
+        </Text>
+      </Card>
+    );
+
+  const list = data?.data || [];
+
+  return (
+    <Stack gap="xl">
+      <Group grow>
+        <Input
+          value={value}
+          placeholder="Cari pengaduan..."
+          onChange={(event) => setValue(event.currentTarget.value)}
+          leftSection={<IconSearch size={16} />}
+          rightSectionPointerEvents="all"
+          rightSection={
+            <CloseButton
+              aria-label="Clear input"
+              onClick={() => setValue("")}
+              style={{ display: value ? undefined : "none" }}
+            />
+          }
+        />
+        {/* <Group justify="flex-end">
+          <Text size="sm">Menampilkan {Number(data?.data?.length) * (page - 1) + 1} – {Math.min(10, Number(data?.data?.length) * page)} dari {Number(data?.data?.length)}</Text>
+          <Pagination total={Number(data?.data?.length)} value={page} onChange={setPage} withPages={false} />
+        </Group> */}
+      </Group>
+      {list.length === 0 ? (
+        <Flex justify="center" align="center" py={"xl"}>
+          <Stack gap={4} align="center">
+            <IconFileSad size={32} color="gray" />
+            <Text c="dimmed" size="sm">
+              No pengaduan have been added yet.
+            </Text>
+          </Stack>
+        </Flex>
+      ) : (
+        list.map((v: any) => (
+          <Card
+            key={v.id}
+            radius="lg"
+            p="xl"
+            withBorder
+            style={{
+              background:
+                "linear-gradient(145deg, rgba(25,25,25,0.95), rgba(45,45,45,0.85))",
+              borderColor: "rgba(100,100,100,0.2)",
+              boxShadow: "0 0 20px rgba(0,255,200,0.08)",
+            }}
+          >
+            <Stack gap="md">
+              <Flex align="center" justify="space-between">
+                <Flex direction={"column"}>
+                  <Title order={3} c="gray.2">
+                    {v.title}
+                  </Title>
+                  <Group>
+                    <Title order={6} c="gray.5">
+                      #{v.noPengaduan}
+                    </Title>
+                    <Text size="sm" c="dimmed">
+                      {v.updatedAt}
+                    </Text>
+                  </Group>
+                </Flex>
+                <Badge
+                  size="xl"
+                  variant="light"
+                  radius="sm"
+                  color={
+                    v.status === "diterima"
+                      ? "green"
+                      : v.status === "ditolak"
+                        ? "red"
+                        : v.status === "selesai"
+                          ? "blue"
+                          : v.status === "dikerjakan"
+                            ? "purple"
+                            : "yellow"
+                  }
+                  style={{ textTransform: "none" }}
+                >
+                  {v.status}
+                </Badge>
+              </Flex>
+              <Divider my={0} />
+              <Stack gap="sm">
+                <Flex direction={"column"} justify="flex-start">
+                  <Group gap="xs">
+                    <IconClockHour3 size={20} color="white" />
+                    <Text size="md" c="white">
+                      Tanggal Aduan
+                    </Text>
+                  </Group>
+                  <Text size="md">{v.createdAt}</Text>
+                </Flex>
+                <Flex direction={"column"} justify="flex-start">
+                  <Group gap="xs">
+                    <IconMapPin size={20} color="white" />
+                    <Text size="md" c="white">
+                      Lokasi
+                    </Text>
+                  </Group>
+                  <Text size="md">{v.location}</Text>
+                </Flex>
+                <Flex direction={"column"} justify="flex-start">
+                  <Group gap="xs">
+                    <IconAlignJustified size={20} color="white" />
+                    <Text size="md" c="white">
+                      Detail
+                    </Text>
+                  </Group>
+                  <Text size="md">{v.detail}</Text>
+                </Flex>
+              </Stack>
+            </Stack>
+          </Card>
+        ))
+      )}
+    </Stack>
+  );
+}

src/pages/scr/dashboard/pengaduan/list_page.tsx

@@ -0,0 +1,271 @@
+import apiFetch from "@/lib/apiFetch";
+import {
+  Badge,
+  Card,
+  CloseButton,
+  Container,
+  Divider,
+  Flex,
+  Group,
+  Input,
+  Stack,
+  Tabs,
+  Text,
+  Title,
+} from "@mantine/core";
+import { useShallowEffect } from "@mantine/hooks";
+import {
+  IconAlignJustified,
+  IconClockHour3,
+  IconFileSad,
+  IconMapPin,
+  IconSearch,
+} from "@tabler/icons-react";
+import { useState } from "react";
+import { useLocation, useNavigate } from "react-router-dom";
+import useSwr from "swr";
+import { proxy } from "valtio";
+
+const state = proxy({ reload: "" });
+function reloadState() {
+  state.reload = Math.random().toString();
+}
+
+export default function PengaduanListPage() {
+  const { search } = useLocation();
+  const query = new URLSearchParams(search);
+  const status = query.get("status") as StatusKey;
+
+  return (
+    <Container size="xl" py="xl" w={"100%"}>
+      <Stack gap="xl">
+        <TabListPengaduan status={status || "semua"} />
+        <ListPengaduan status={status || "semua"} />
+      </Stack>
+    </Container>
+  );
+}
+
+function TabListPengaduan({ status }: { status: string }) {
+  const navigate = useNavigate();
+  const dataCount = useSwr("/pengaduan/count", () =>
+    apiFetch.api.pengaduan.count.get().then((res) => res.data),
+  );
+
+  return (
+    <Tabs defaultValue={status || "semua"} color="teal">
+      <Tabs.List grow>
+        <Tabs.Tab
+          value="all"
+          onClick={() => {
+            navigate("?status=semua");
+          }}
+        >
+          Semua ({dataCount?.data?.semua || 0})
+        </Tabs.Tab>
+        <Tabs.Tab
+          value="antrian"
+          onClick={() => {
+            navigate("?status=antrian");
+          }}
+        >
+          Antrian ({dataCount?.data?.antrian || 0})
+        </Tabs.Tab>
+        <Tabs.Tab
+          value="diterima"
+          onClick={() => {
+            navigate("?status=diterima");
+          }}
+        >
+          Diterima ({dataCount?.data?.diterima || 0})
+        </Tabs.Tab>
+        <Tabs.Tab
+          value="dikerjakan"
+          onClick={() => {
+            navigate("?status=dikerjakan");
+          }}
+        >
+          Dikerjakan ({dataCount?.data?.dikerjakan || 0})
+        </Tabs.Tab>
+        <Tabs.Tab
+          value="selesai"
+          onClick={() => {
+            navigate("?status=selesai");
+          }}
+        >
+          Selesai ({dataCount?.data?.selesai || 0})
+        </Tabs.Tab>
+        <Tabs.Tab
+          value="ditolak"
+          onClick={() => {
+            navigate("?status=ditolak");
+          }}
+        >
+          Ditolak ({dataCount?.data?.ditolak || 0})
+        </Tabs.Tab>
+      </Tabs.List>
+    </Tabs>
+  );
+}
+
+type StatusKey =
+  | "antrian"
+  | "diterima"
+  | "dikerjakan"
+  | "ditolak"
+  | "selesai"
+  | "semua";
+function ListPengaduan({ status }: { status: StatusKey }) {
+  const [page, setPage] = useState(1);
+  const [value, setValue] = useState("");
+  const { data, mutate, isLoading } = useSwr("/", () =>
+    apiFetch.api.pengaduan.list.get({
+      query: {
+        status,
+        search: value,
+        take: "",
+        page: "",
+      },
+    }),
+  );
+
+  useShallowEffect(() => {
+    mutate();
+  }, [status, value]);
+
+  if (isLoading)
+    return (
+      <Card
+        radius="lg"
+        p="xl"
+        withBorder
+        style={{
+          background:
+            "linear-gradient(145deg, rgba(25,25,25,0.95), rgba(45,45,45,0.85))",
+        }}
+      >
+        <Text size="sm" c="dimmed">
+          Loading pengaduan...
+        </Text>
+      </Card>
+    );
+
+  const list = data?.data || [];
+
+  return (
+    <Stack gap="xl">
+      <Group grow>
+        <Input
+          value={value}
+          placeholder="Cari pengaduan..."
+          onChange={(event) => setValue(event.currentTarget.value)}
+          leftSection={<IconSearch size={16} />}
+          rightSectionPointerEvents="all"
+          rightSection={
+            <CloseButton
+              aria-label="Clear input"
+              onClick={() => setValue("")}
+              style={{ display: value ? undefined : "none" }}
+            />
+          }
+        />
+        {/* <Group justify="flex-end">
+          <Text size="sm">Menampilkan {Number(data?.data?.length) * (page - 1) + 1} – {Math.min(10, Number(data?.data?.length) * page)} dari {Number(data?.data?.length)}</Text>
+          <Pagination total={Number(data?.data?.length)} value={page} onChange={setPage} withPages={false} />
+        </Group> */}
+      </Group>
+      {list.length === 0 ? (
+        <Flex justify="center" align="center" py={"xl"}>
+          <Stack gap={4} align="center">
+            <IconFileSad size={32} color="gray" />
+            <Text c="dimmed" size="sm">
+              No pengaduan have been added yet.
+            </Text>
+          </Stack>
+        </Flex>
+      ) : (
+        list.map((v: any) => (
+          <Card
+            key={v.id}
+            radius="lg"
+            p="xl"
+            withBorder
+            style={{
+              background:
+                "linear-gradient(145deg, rgba(25,25,25,0.95), rgba(45,45,45,0.85))",
+              borderColor: "rgba(100,100,100,0.2)",
+              boxShadow: "0 0 20px rgba(0,255,200,0.08)",
+            }}
+          >
+            <Stack gap="md">
+              <Flex align="center" justify="space-between">
+                <Flex direction={"column"}>
+                  <Title order={3} c="gray.2">
+                    {v.title}
+                  </Title>
+                  <Group>
+                    <Title order={6} c="gray.5">
+                      #{v.noPengaduan}
+                    </Title>
+                    <Text size="sm" c="dimmed">
+                      {v.updatedAt}
+                    </Text>
+                  </Group>
+                </Flex>
+                <Badge
+                  size="xl"
+                  variant="light"
+                  radius="sm"
+                  color={
+                    v.status === "diterima"
+                      ? "green"
+                      : v.status === "ditolak"
+                        ? "red"
+                        : v.status === "selesai"
+                          ? "blue"
+                          : v.status === "dikerjakan"
+                            ? "purple"
+                            : "yellow"
+                  }
+                  style={{ textTransform: "none" }}
+                >
+                  {v.status}
+                </Badge>
+              </Flex>
+              <Divider my={0} />
+              <Stack gap="sm">
+                <Flex direction={"column"} justify="flex-start">
+                  <Group gap="xs">
+                    <IconClockHour3 size={20} color="white" />
+                    <Text size="md" c="white">
+                      Tanggal Aduan
+                    </Text>
+                  </Group>
+                  <Text size="md">{v.createdAt}</Text>
+                </Flex>
+                <Flex direction={"column"} justify="flex-start">
+                  <Group gap="xs">
+                    <IconMapPin size={20} color="white" />
+                    <Text size="md" c="white">
+                      Lokasi
+                    </Text>
+                  </Group>
+                  <Text size="md">{v.location}</Text>
+                </Flex>
+                <Flex direction={"column"} justify="flex-start">
+                  <Group gap="xs">
+                    <IconAlignJustified size={20} color="white" />
+                    <Text size="md" c="white">
+                      Detail
+                    </Text>
+                  </Group>
+                  <Text size="md">{v.detail}</Text>
+                </Flex>
+              </Stack>
+            </Stack>
+          </Card>
+        ))
+      )}
+    </Stack>
+  );
+}

src/server/lib/get-last-updated.ts

@@ -0,0 +1,21 @@
+export function getLastUpdated(date: string | Date): string {
+   const now = new Date();
+   const updated = new Date(date);
+   const diffMs = now.getTime() - updated.getTime();
+
+   const diffMinutes = Math.floor(diffMs / (1000 * 60));
+   const diffHours = Math.floor(diffMs / (1000 * 60 * 60));
+   const diffDays = Math.floor(diffMs / (1000 * 60 * 60 * 24));
+
+   if (diffMinutes < 1) return "baru saja";
+   if (diffMinutes < 60) return `${diffMinutes} menit lalu`;
+   if (diffHours < 24) return `${diffHours} jam lalu`;
+   if (diffDays < 7) return `${diffDays} hari lalu`;
+
+   // kalau sudah lebih dari seminggu, tampilkan tanggal
+   return updated.toLocaleDateString("id-ID", {
+      day: "numeric",
+      month: "long",
+      year: "numeric",
+   });
+}

src/server/lib/seafile.ts

@@ -136,33 +136,65 @@ export async function catFile(config: Config, fileName: string): Promise<string>
 }
 
 export async function uploadFile(config: Config, file: File): Promise<string> {
-  const remoteName = path.basename(file.name);
+   const remoteName = path.basename(file.name);
 
-  // 1. Dapatkan upload link (pakai Authorization)
-  const uploadUrlResponse = await fetchWithAuth(
-    config,
-    `${config.URL}/${config.REPO}/upload-link/`
-  );
-  const uploadUrl = (await uploadUrlResponse.text()).replace(/"/g, "");
+   // 1. Dapatkan upload link (pakai Authorization)
+   const uploadUrlResponse = await fetchWithAuth(
+      config,
+      `${config.URL}/${config.REPO}/upload-link/`
+   );
+   const uploadUrl = (await uploadUrlResponse.text()).replace(/"/g, "");
 
-  // 2. Siapkan form-data
-  const formData = new FormData();
-  formData.append("parent_dir", "/");
-  formData.append("relative_path", "syarat-dokumen"); // tanpa slash di akhir
-  formData.append("file", file, remoteName); // file langsung, jangan pakai Blob
+   // 2. Siapkan form-data
+   const formData = new FormData();
+   formData.append("parent_dir", "/");
+   formData.append("relative_path", "syarat-dokumen"); // tanpa slash di akhir
+   formData.append("file", file, remoteName); // file langsung, jangan pakai Blob
 
-  // 3. Upload file TANPA Authorization header, token di query param
-  const res = await fetch(`${uploadUrl}?token=${config.TOKEN}`, {
-    method: "POST",
-    body: formData,
-  });
+   // 3. Upload file TANPA Authorization header, token di query param
+   const res = await fetch(`${uploadUrl}?token=${config.TOKEN}`, {
+      method: "POST",
+      body: formData,
+   });
 
-  const text = await res.text();
-  console.log(text);
+   const text = await res.text();
 
-  if (!res.ok) throw new Error(`Upload failed: ${text}`);
-  return `✅ Uploaded ${file.name} successfully`;
+   if (!res.ok) throw new Error(`Upload failed: ${text}`);
+   return `✅ Uploaded ${file.name} successfully`;
 }
+export async function uploadFileBase64(config: Config, base64File: { name: string; data: string }): Promise<string> {
+   const remoteName = path.basename(base64File.name);
+
+   // 1. Dapatkan upload link (pakai Authorization)
+   const uploadUrlResponse = await fetchWithAuth(
+      config,
+      `${config.URL}/${config.REPO}/upload-link/`
+   );
+   const uploadUrl = (await uploadUrlResponse.text()).replace(/"/g, "");
+
+   // 2. Konversi base64 ke Blob
+   const binary = Buffer.from(base64File.data, "base64");
+   const blob = new Blob([binary]);
+
+   // 3. Siapkan form-data
+   const formData = new FormData();
+   formData.append("parent_dir", "/");
+   formData.append("relative_path", "syarat-dokumen"); // tanpa slash di akhir
+   formData.append("file", blob, remoteName);
+
+   // 4. Upload file TANPA Authorization header, token di query param
+   const res = await fetch(`${uploadUrl}?token=${config.TOKEN}`, {
+      method: "POST",
+      body: formData,
+   });
+
+   const text = await res.text();
+
+   if (!res.ok) throw new Error(`Upload failed: ${text}`);
+   return `✅ Uploaded ${base64File.name} successfully`;
+}
+
+
 
 
 export async function removeFile(config: Config, fileName: string): Promise<string> {

src/server/routes/pelayanan_surat_route.ts

@@ -2,6 +2,7 @@ import Elysia, { StatusMap, t } from "elysia"
 import { generateNoPengajuanSurat } from "../lib/no-pengajuan-surat"
 import { prisma } from "../lib/prisma"
 import type { StatusPengaduan } from "generated/prisma"
+import { normalizePhoneNumber } from "../lib/normalizePhone"
 
 const PelayananRoute = new Elysia({
    prefix: "pelayanan",
@@ -22,7 +23,7 @@ const PelayananRoute = new Elysia({
    }, {
       detail: {
          summary: "List Kategori Pelayanan Surat",
-         description: `tool untuk mendapatkan list kategori pelayanan surat`,
+         description: `tool untuk mendapatkan list kategori pelayanan surat beserta syaratnya untuk memenuhi syarat dokumen sesuai kategori yg dipilih saat melakukan pengajuan surat`,
          tags: ["mcp"]
       }
    })
@@ -175,9 +176,10 @@ const PelayananRoute = new Elysia({
       })
 
       if (!warga) {
+         const nomorHP = normalizePhoneNumber({ phone })
          const cariWarga = await prisma.warga.findFirst({
             where: {
-               phone,
+               phone: nomorHP,
             }
          })
 
@@ -185,7 +187,7 @@ const PelayananRoute = new Elysia({
             const wargaCreate = await prisma.warga.create({
                data: {
                   name: idWarga,
-                  phone,
+                  phone: nomorHP,
                },
                select: {
                   id: true
@@ -210,7 +212,7 @@ const PelayananRoute = new Elysia({
       })
 
       if (!pengaduan.id) {
-         throw new Error("gagal membuat pengaduan")
+         throw new Error("gagal membuat pengajuan surat")
       }
 
       let dataInsertSyaratDokumen = []
@@ -270,7 +272,7 @@ const PelayananRoute = new Elysia({
       }),
       detail: {
          summary: "Create Pengajuan Pelayanan Surat",
-         description: `tool untuk membuat pengajuan pelayanan surat`,
+         description: `tool untuk membuat pengajuan pelayanan surat dengan syarat dokumen serta data text sesuai kategori pelayanan surat yang dipilih`,
          tags: ["mcp"]
       }
    })

src/server/routes/pengaduan_route.ts

@@ -1,10 +1,10 @@
-import { swagger } from "@elysiajs/swagger"
 import Elysia, { t } from "elysia"
 import type { StatusPengaduan } from "generated/prisma"
+import { getLastUpdated } from "../lib/get-last-updated"
 import { generateNoPengaduan } from "../lib/no-pengaduan"
-import { prisma } from "../lib/prisma"
-import { defaultConfigSF, testConnection, uploadFile } from "../lib/seafile"
 import { normalizePhoneNumber } from "../lib/normalizePhone"
+import { prisma } from "../lib/prisma"
+import { defaultConfigSF, uploadFile, uploadFileBase64 } from "../lib/seafile"
 
 const PengaduanRoute = new Elysia({
    prefix: "pengaduan",
@@ -432,45 +432,201 @@ const PengaduanRoute = new Elysia({
          tags: ["mcp"]
       }
    })
-   .use(swagger())
-   .post("/upload",
-      async ({ body }) => {
-         const { file } = body;
+   .post("/upload", async ({ body }) => {
+      const { file } = body;
 
-         // Validasi file
-         if (!file) {
-            return { success: false, message: "File tidak ditemukan" };
-         }
-
-         // Contoh: cek koneksi ke Seafile
-         const coba = await testConnection(defaultConfigSF);
-         console.log("Seafile Connection:", coba);
-
-         // Upload ke Seafile (pastikan uploadFile menerima Blob atau ArrayBuffer)
-         // const buffer = await file.arrayBuffer();
-         const result = await uploadFile(defaultConfigSF, file);
-
-         console.log("Upload result:", result);
-
-         return {
-            success: true,
-            message: "Upload berhasil",
-            filename: file.name,
-            size: file.size,
-            seafileResult: result
-         };
-      },
-      {
-         body: t.Object({
-            file: t.File({ format: "binary" })
-         }),
-         detail: {
-            summary: "Upload File",
-            description: "Tool untuk upload file ke Seafile",
-            tags: ["mcp"],
-            consumes: ["multipart/form-data"]
-         },
+      // Validasi file
+      if (!file) {
+         return { success: false, message: "File tidak ditemukan" };
       }
-   );
+
+      // Upload ke Seafile (pastikan uploadFile menerima Blob atau ArrayBuffer)
+      // const buffer = await file.arrayBuffer();
+      const result = await uploadFile(defaultConfigSF, file);
+
+      return {
+         success: true,
+         message: "Upload berhasil",
+         filename: file.name,
+         size: file.size,
+         seafileResult: result
+      };
+   }, {
+      body: t.Object({
+         file: t.File({ format: "binary" })
+      }),
+      detail: {
+         summary: "Upload File",
+         description: "Tool untuk upload file ke Seafile",
+         tags: ["mcp"],
+         consumes: ["multipart/form-data"]
+      },
+   })
+   .post("/upload-base64", async ({ body }) => {
+      const { file } = body;
+
+      // Validasi file
+      if (!file) {
+         return { success: false, message: "File tidak ditemukan" };
+      }
+
+      // Konversi file ke base64
+      const buffer = await file.arrayBuffer();
+      const base64String = Buffer.from(buffer).toString("base64");
+
+      // (Opsional) jika perlu dikirim ke Seafile sebagai base64
+      const result = await uploadFileBase64(defaultConfigSF, { name: file.name, data: base64String });
+
+      return {
+         success: true,
+         message: "Upload berhasil",
+         filename: file.name,
+         size: file.size,
+         base64Preview: base64String.slice(0, 100) + "...", // hanya preview
+         seafileResult: result
+      };
+   }, {
+      body: t.Object({
+         file: t.File({ format: "binary" })
+      }),
+      detail: {
+         summary: "Upload File (Base64)",
+         description: "Tool untuk upload file ke Seafile dalam format Base64",
+         tags: ["mcp"],
+         consumes: ["multipart/form-data"]
+      },
+   })
+
+   .get("/list", async ({ query }) => {
+      const { take, page, search, status } = query
+      const skip = !page ? 0 : (Number(page) - 1) * (!take ? 10 : Number(take))
+
+      let where: any = {
+         isActive: true,
+         OR: [
+            {
+               title: {
+                  contains: search ?? "",
+                  mode: "insensitive"
+               },
+            },
+            {
+               noPengaduan: {
+                  contains: search ?? "",
+                  mode: "insensitive"
+               },
+            },
+            {
+               detail: {
+                  contains: search ?? "",
+                  mode: "insensitive"
+               },
+            },
+            {
+               Warga: {
+                  phone: {
+                     contains: search ?? "",
+                     mode: "insensitive"
+                  },
+               },
+            }
+         ]
+      }
+
+      if (status && status !== "semua") {
+         where = {
+            ...where,
+            status: status
+         }
+      }
+
+      const data = await prisma.pengaduan.findMany({
+         skip,
+         take: !take ? 10 : Number(take),
+         orderBy: {
+            createdAt: "desc"
+         },
+         where,
+         select: {
+            id: true,
+            noPengaduan: true,
+            title: true,
+            detail: true,
+            location: true,
+            status: true,
+            createdAt: true,
+            updatedAt: true,
+            CategoryPengaduan: {
+               select: {
+                  name: true
+               }
+            },
+            Warga: {
+               select: {
+                  name: true,
+               }
+            }
+         }
+      })
+
+      const dataFix = data.map((item) => {
+         return {
+            noPengaduan: item.noPengaduan,
+            title: item.title,
+            detail: item.detail,
+            status: item.status,
+            location: item.location,
+            createdAt: item.createdAt.toLocaleDateString("id-ID", { day: "numeric", month: "long", year: "numeric" }),
+            updatedAt: 'terakhir diperbarui ' + getLastUpdated(item.updatedAt),
+         }
+      })
+
+      return dataFix
+   }, {
+      query: t.Object({
+         take: t.String({ optional: true }),
+         page: t.String({ optional: true }),
+         search: t.String({ optional: true }),
+         status: t.String({ optional: true }),
+      }),
+      detail: {
+         summary: "List Pengaduan Warga",
+         description: `tool untuk mendapatkan list pengaduan warga`,
+      }
+   })
+   .get("/count", async ({ query }) => {
+      const counts = await prisma.pengaduan.groupBy({
+         by: ['status'],
+         where: {
+            isActive: true,
+         },
+         _count: {
+            status: true,
+         },
+      });
+
+      const grouped = Object.fromEntries(
+         counts.map(c => [c.status, c._count.status])
+      );
+
+      const total = await prisma.pengaduan.count({
+         where: { isActive: true },
+      });
+
+      return {
+         antrian: grouped?.antrian || 0,
+         diterima: grouped?.diterima || 0,
+         dikerjakan: grouped?.dikerjakan || 0,
+         ditolak: grouped?.ditolak || 0,
+         selesai: grouped?.selesai || 0,
+         semua: total,
+      };
+   }, {
+      detail: {
+         summary: "Jumlah Pengaduan Warga",
+         description: `tool untuk mendapatkan jumlah pengaduan warga`,
+      }
+   })
+   ;
 
 export default PengaduanRoute

upload_base64.sh

@@ -0,0 +1,2 @@
+curl -X POST http://localhost:3000/api/pengaduan/upload-base64 \
+  -F file=@package.json