Fix eror edit admin lowongan kerja

prisma/data/desa/layanan/pelayananSuratKeterangan.json

@@ -47,9 +47,7 @@
     {
         "id" : "cmdxy754q000svniiiz8oqyo0",
         "name" : "Surat Keterangan Belum Kawin",
-        "deskripsi" : "<p>Persyaratan Dokumen :</p><ul><li><p>Pengantar Kelian Banjar Dinas di Wilayah Masing - masing</p></li><li><p>Fotocopy KTP atau Kartu Keluarga</p></li><li><p>Khusus bagi yang berstatus duda atau janda melampirkan fotocopy akta cerai atau dokumen pendukung lainnya</p></li></ul><p>Alur Pelayanan :</p>",
-        "imageId" : "cmeilibnt000007i66s5f73ss",
-        "image2Id" : "cmeilvjmp000007kz9kll5bd2"
+        "deskripsi" : "<p>Persyaratan Dokumen :</p><ul><li><p>Pengantar Kelian Banjar Dinas di Wilayah Masing - masing</p></li><li><p>Fotocopy KTP atau Kartu Keluarga</p></li><li><p>Khusus bagi yang berstatus duda atau janda melampirkan fotocopy akta cerai atau dokumen pendukung lainnya</p></li></ul><p>Alur Pelayanan :</p>"
     },
     {
         "id" : "cmdxy8pi2000wvnii48fc1sxd",

prisma/data/file-storage.json

@@ -1,29 +0,0 @@
-[
-  {
-    "id": "cmeijzdwk000207lb2u4u96wn",
-    "name": "foto_kades",
-    "realName": "kades.jpg",
-    "path": "uploads/images/kades.jpg",
-    "mimeType": "image/jpeg",
-    "link": "https://drive.google.com/file/d/18C_kzKfEWvsGepAHASb2FIwXyyrzMdu2",
-    "category": "image"
-  },
-  {
-    "id": "cmeilibnt000007i66s5f73ss",
-    "name": "surat-keterangan-belum-kawin",
-    "realName": "surat-keterangan-belum-kawin.jpg",
-    "path": "uploads/images/surat-keterangan-belum-kawin.jpg",
-    "mimeType": "image/jpeg",
-    "link": "https://drive.google.com/file/d/1S6p1gSlgf5fRt6f3UOtB7r3MIHQ4-BlU",
-    "category": "image"
-  },
-  {
-    "id": "cmeilvjmp000007kz9kll5bd2",
-    "name": "skema-surat-keterangan-belum-kawin",
-    "realName": "skema-surat-keterangan-belum-kawin.jpg",
-    "path": "uploads/images/skema-surat-keterangan-belum-kawin.jpg",
-    "mimeType": "image/jpeg",
-    "link": "https://drive.google.com/file/d/1vTXobCipplsNj21BefDuEDTHsb-CbyAz",
-    "category": "image"
-  }
-]

prisma/data/ppid/profile-ppid/profilePPid.json

@@ -5,7 +5,6 @@
     "biodata": "<p>I.B Surya Prabhawa Manuaba, S.H., M.H., adalah Perbekel Darmasaba periode 2021-2027, seorang advokat, pendiri Mantra Legal Consultants & Advocates, serta aktif di bidang musik dan akademis. Dia menempuh pendidikan hukum di Universitas Udayana dan Universitas Mahasaraswati Denpasar, serta memiliki pengalaman luas di berbagai organisasi dan kepemimpinan.</p>",
     "riwayat": "<ul> <li>2021 - 2027: Perbekel Desa Darmasaba</li> <li>2015 - Sekarang: Founder & Managing Director Mantra Legal Consultants & Advocates</li> <li>2020 - Sekarang: Founder Ugawa Record Music Studio</li> <li>2010 - 2016: Dosen Fakultas Hukum Universitas Mahasaraswati Denpasar</li> </ul>",
     "pengalaman": "<ul> <li>1996 – 1997: Ketua OSIS SMP Negeri 1 Abiansemal</li><li>1999 – 2000: Ketua OSIS SMA Negeri 1 Mengwi</li> <li>2008 – 2009: Ketua BEM Universitas Mahasaraswati Denpasar</li> <li>2008 – 2010: Ketua Sekaa Taruna Sila Dharma, Banjar Tengah, Desa Adat Tegal, Darmasaba</li> <li>2020 – Sekarang: Pengurus Young Lawyer Committee Peradi Denpasar</li> <li>2021 – Sekarang: Dewan Kehormatan Himpunan Pengusaha Muda Indonesia (HIPMI) Badung</li> <li>2023 – 2028: Komite Tetap Advokasi – Bidang Hukum dan Regulasi Kamar Dagang dan Industri Badung</li> </ul>",
-    "unggulan": "<h3>Pemberdayaan Ekonomi dan UMKM</h3> <ul> <li>Pelatihan dan pendampingan UMKM lokal</li> <li>Program bantuan modal usaha bagi pelaku usaha kecil</li><li>Digitalisasi UMKM untuk meningkatkan pemasaran produk lokal</li></ul>",
-    "imageId": "cmeijzdwk000207lb2u4u96wn"
+    "unggulan": "<h3>Pemberdayaan Ekonomi dan UMKM</h3> <ul> <li>Pelatihan dan pendampingan UMKM lokal</li> <li>Program bantuan modal usaha bagi pelaku usaha kecil</li><li>Digitalisasi UMKM untuk meningkatkan pemasaran produk lokal</li></ul>"
   }
 ]

prisma/seed.ts

@@ -1,6 +1,4 @@
 import prisma from "@/lib/prisma";
-import fs from "fs/promises";
-import path from "path";
 import profilePejabatDesa from "./data/landing-page/profile/profile.json";
 import penghargaan from "./data/landing-page/penghargaan/penghargaan.json";
 import programInovasi from "./data/landing-page/profile/programInovasi.json";
@@ -52,32 +50,6 @@ import pegawaiPPID from "./data/ppid/struktur-ppid/pegawai-PPID.json";
 import pelayananTelunjukSaktiDesa from "./data/desa/layanan/pelayananTelunjukSaktiDesa.json";
 
 (async () => {
-  //seed file storage
-  const filePath = path.join(__dirname, "data/file-storage.json");
-  const rawData = await fs.readFile(filePath, "utf-8");
-  const files = JSON.parse(rawData);
-
-  console.log(`Seeding ${files.length} file(s) into FileStorage...`);
-
-  for (const file of files) {
-    await prisma.fileStorage.upsert({
-      where: { name: file.name },
-      update: {},
-      create: {
-        id: file.id,
-        name: file.name,
-        realName: file.realName,
-        path: file.path,
-        link: file.link,
-        category: file.category,
-        mimeType: file.mimeType,
-        isActive: file.isActive ?? true,
-      },
-    });
-  }
-
-  console.log("✅ Seeding selesai!");
-
   // =========== LANDING PAGE ===========
   // =========== PROFILE ===========
   for (const p of profilePejabatDesa) {
@@ -155,26 +127,16 @@ import pelayananTelunjukSaktiDesa from "./data/desa/layanan/pelayananTelunjukSak
 
   // =========== LAYANAN DESA ===========
   for (const p of pelayananSuratKeterangan) {
-    // Skip if required image references don't exist
-    if (!p.imageId || !p.image2Id) {
-      console.warn(`Skipping ${p.name} due to missing image references`);
-      continue;
-    }
-
     await prisma.pelayananSuratKeterangan.upsert({
       where: { id: p.id },
       update: {
         name: p.name,
         deskripsi: p.deskripsi,
-        imageId: p.imageId,
-        image2Id: p.image2Id,
       },
       create: {
         id: p.id,
         name: p.name,
         deskripsi: p.deskripsi,
-        imageId: p.imageId,
-        image2Id: p.image2Id,
       },
     });
   }
@@ -533,7 +495,7 @@ import pelayananTelunjukSaktiDesa from "./data/desa/layanan/pelayananTelunjukSak
         riwayat: c.riwayat,
         pengalaman: c.pengalaman,
         unggulan: c.unggulan,
-        imageId: c.imageId,
+        // imageId tidak di-update
       },
       create: {
         id: c.id,
@@ -542,7 +504,7 @@ import pelayananTelunjukSaktiDesa from "./data/desa/layanan/pelayananTelunjukSak
         riwayat: c.riwayat,
         pengalaman: c.pengalaman,
         unggulan: c.unggulan,
-        imageId: c.imageId,
+        // imageId tidak di-create
       },
     });
   }

src/app/admin/(dashboard)/_state/ekonomi/lowongan-kerja.ts

@@ -1,3 +1,4 @@
+/* eslint-disable @typescript-eslint/no-explicit-any */
 import ApiFetch from "@/lib/api-fetch";
 import { Prisma } from "@prisma/client";
 import { toast } from "react-toastify";
@@ -61,13 +62,39 @@ const lowonganKerjaState = proxy({
   findMany: {
     data: null as
       | Prisma.LowonganPekerjaanGetPayload<{
-          omit: { isActive: true };
+          omit: {
+            isActive: true;
+          };
         }>[]
       | null,
-    async load() {
-      const res = await ApiFetch.api.ekonomi.lowongankerja["find-many"].get();
-      if (res.status === 200) {
-        lowonganKerjaState.findMany.data = res.data?.data ?? [];
+    page: 1,
+    totalPages: 1,
+    loading: false,
+    search: "",
+   load: async (page = 1, limit = 10, search = "") => {
+      lowonganKerjaState.findMany.loading = true; // ✅ Akses langsung via nama path
+      lowonganKerjaState.findMany.page = page;
+      lowonganKerjaState.findMany.search = search;
+  
+      try {
+        const query: any = { page, limit };
+        if (search) query.search = search;
+    
+        const res = await ApiFetch.api.ekonomi.lowongankerja["find-many"].get({ query });
+    
+        if (res.status === 200 && res.data?.success) {
+          lowonganKerjaState.findMany.data = res.data.data ?? [];
+          lowonganKerjaState.findMany.totalPages = res.data.totalPages ?? 1;
+        } else {
+          lowonganKerjaState.findMany.data = [];
+          lowonganKerjaState.findMany.totalPages = 1;
+        }
+      } catch (err) {
+        console.error("Gagal fetch lowongan kerja paginated:", err);
+        lowonganKerjaState.findMany.data = [];
+        lowonganKerjaState.findMany.totalPages = 1;
+      } finally {
+        lowonganKerjaState.findMany.loading = false;
       }
     },
   },

src/app/admin/(dashboard)/_state/ekonomi/pasar-desa/pasar-desa.ts

@@ -1,3 +1,4 @@
+/* eslint-disable @typescript-eslint/no-explicit-any */
 import ApiFetch from "@/lib/api-fetch";
 import { Prisma } from "@prisma/client";
 import { toast } from "react-toastify";
@@ -53,22 +54,47 @@ const pasarDesa = proxy({
     },
   },
   findMany: {
-    data: null as Array<
-      Prisma.PasarDesaGetPayload<{
-        include: {
-          image: true;
-          KategoriToPasar: {
-            include: {
-              kategori: true;
+    data: null as
+      | Prisma.PasarDesaGetPayload<{
+          include: {
+            image: true;
+            KategoriToPasar: {
+              include: {
+                kategori: true;
+              };
             };
           };
-        };
-      }>
-    > | null,
-    async load() {
-      const res = await ApiFetch.api.ekonomi.pasardesa["find-many"].get();
-      if (res.status === 200) {
-        pasarDesa.findMany.data = res.data?.data ?? [];
+        }>[]
+      | null,
+    page: 1,
+    totalPages: 1,
+    loading: false,
+    search: "",
+   load: async (page = 1, limit = 10, search = "", categoryId?: string) => {
+      pasarDesa.findMany.loading = true;
+      pasarDesa.findMany.page = page;
+      pasarDesa.findMany.search = search;
+  
+      try {
+        const query: any = { page, limit };
+        if (search) query.search = search;
+        if (categoryId) query.categoryId = categoryId;
+    
+        const res = await ApiFetch.api.ekonomi.pasardesa["find-many"].get({ query });
+    
+        if (res.status === 200 && res.data?.success) {
+          pasarDesa.findMany.data = res.data.data ?? [];
+          pasarDesa.findMany.totalPages = res.data.totalPages ?? 1;
+        } else {
+          pasarDesa.findMany.data = [];
+          pasarDesa.findMany.totalPages = 1;
+        }
+      } catch (err) {
+        console.error("Gagal fetch keamanan lingkungan paginated:", err);
+        pasarDesa.findMany.data = [];
+        pasarDesa.findMany.totalPages = 1;
+      } finally {
+        pasarDesa.findMany.loading = false;
       }
     },
   },
@@ -272,14 +298,41 @@ const kategoriProduk = proxy({
     },
   },
   findMany: {
-    data: null as Array<{
-      id: string;
-      nama: string;
-    }> | null,
-    async load() {
-      const res = await ApiFetch.api.ekonomi.kategoriproduk["find-many"].get();
-      if (res.status === 200) {
-        kategoriProduk.findMany.data = res.data?.data ?? [];
+    data: null as
+      | Prisma.KategoriProdukGetPayload<{
+          omit: {
+            isActive: true;
+          };
+        }>[]
+      | null,
+    page: 1,
+    totalPages: 1,
+    loading: false,
+    search2: "",
+   load: async (page = 1, limit = 10, search2 = "") => {
+      kategoriProduk.findMany.loading = true; // ✅ Akses langsung via nama path
+      kategoriProduk.findMany.page = page;
+      kategoriProduk.findMany.search2 = search2;
+  
+      try {
+        const query: any = { page, limit };
+        if (search2) query.search2 = search2;
+    
+        const res = await ApiFetch.api.ekonomi.kategoriproduk["find-many"].get({ query });
+    
+        if (res.status === 200 && res.data?.success) {
+          kategoriProduk.findMany.data = res.data.data ?? [];
+          kategoriProduk.findMany.totalPages = res.data.totalPages ?? 1;
+        } else {
+          kategoriProduk.findMany.data = [];
+          kategoriProduk.findMany.totalPages = 1;
+        }
+      } catch (err) {
+        console.error("Gagal fetch kategori produk paginated:", err);
+        kategoriProduk.findMany.data = [];
+        kategoriProduk.findMany.totalPages = 1;
+      } finally {
+        kategoriProduk.findMany.loading = false;
       }
     },
   },

src/app/admin/(dashboard)/_state/keamanan/tips-keamanan.ts

@@ -1,3 +1,4 @@
+/* eslint-disable @typescript-eslint/no-explicit-any */
 import ApiFetch from "@/lib/api-fetch";
 import { Prisma } from "@prisma/client";
 import { toast } from "react-toastify";
@@ -53,15 +54,39 @@ const tipsKeamananState = proxy({
   findMany: {
     data: null as
       | Prisma.MenuTipsKeamananGetPayload<{
-          include: { image: true };
+          include: {
+            image: true;
+          };
         }>[]
       | null,
-    async load() {
-      const res = await ApiFetch.api.keamanan.menutipskeamanan[
-        "find-many"
-      ].get();
-      if (res.status === 200) {
-        tipsKeamananState.findMany.data = res.data?.data ?? [];
+    page: 1,
+    totalPages: 1,
+    loading: false,
+    search: "",
+   load: async (page = 1, limit = 10, search = "") => {
+      tipsKeamananState.findMany.loading = true; // ✅ Akses langsung via nama path
+      tipsKeamananState.findMany.page = page;
+      tipsKeamananState.findMany.search = search;
+  
+      try {
+        const query: any = { page, limit };
+        if (search) query.search = search;
+    
+        const res = await ApiFetch.api.keamanan.menutipskeamanan["find-many"].get({ query });
+    
+        if (res.status === 200 && res.data?.success) {
+          tipsKeamananState.findMany.data = res.data.data ?? [];
+          tipsKeamananState.findMany.totalPages = res.data.totalPages ?? 1;
+        } else {
+          tipsKeamananState.findMany.data = [];
+          tipsKeamananState.findMany.totalPages = 1;
+        }
+      } catch (err) {
+        console.error("Gagal fetch menu tips keamanan paginated:", err);
+        tipsKeamananState.findMany.data = [];
+        tipsKeamananState.findMany.totalPages = 1;
+      } finally {
+        tipsKeamananState.findMany.loading = false;
       }
     },
   },

src/app/admin/(dashboard)/desa/layanan/pelayanan_surat_keterangan/[id]/page.tsx

@@ -20,8 +20,6 @@ function DetailSuratKeterangan() {
     suratKeteranganState.findUnique.load(params?.id as string)
   }, [])
 
-  console.log("Ini datanya",suratKeteranganState.findUnique.data)
-
   const handleHapus = () => {
     if (selectedId) {
       suratKeteranganState.delete.byId(selectedId)

src/app/admin/(dashboard)/desa/layanan/pelayanan_surat_keterangan/create/page.tsx

@@ -63,8 +63,8 @@ function CreateSuratKeterangan() {
 
       // Create the record
       await stateSurat.create.create();
-      
-      // If we get here without errors, the create was successful
+
+      // Reset form dan redirect
       resetForm();
       toast.success("Data surat keterangan berhasil ditambahkan");
       router.push("/admin/desa/layanan/pelayanan_surat_keterangan");

src/app/admin/(dashboard)/ekonomi/lowongan-kerja-lokal/[id]/edit/page.tsx

@@ -55,17 +55,17 @@ function EditLowonganKerja() {
 
   const handleSubmit = async () => {
     try {
-      lowonganKerjaState.update.form = {
-        ...lowonganKerjaState.update.form,
-        posisi: formData.posisi,
-        namaPerusahaan: formData.namaPerusahaan,
-        lokasi: formData.lokasi,
-        tipePekerjaan: formData.tipePekerjaan,
-        gaji: formData.gaji,
-        deskripsi: formData.deskripsi,
-        kualifikasi: formData.kualifikasi,
-      }
-      await lowonganState.update.update()
+      // Set the ID for the update
+      lowonganState.update.id = params?.id as string;
+      
+      // Update the form state
+      lowonganState.update.form = {
+        ...lowonganState.update.form,
+        ...formData
+      };
+      
+      // Call the update function
+      await lowonganState.update.update();
       toast.success("Lowongan kerja berhasil diperbarui!");
       router.push("/admin/ekonomi/lowongan-kerja-lokal");
     } catch (error) {
@@ -88,7 +88,7 @@ function EditLowonganKerja() {
           <TextInput
             value={formData.posisi}
             onChange={(val) => {
-              formData.posisi = val.target.value;
+              setFormData(prev => ({ ...prev, posisi: val.target.value }));
             }}
             label={<Text fw={"bold"} fz={"sm"}>Posisi</Text>}
             placeholder='Masukkan posisi'
@@ -96,7 +96,7 @@ function EditLowonganKerja() {
           <TextInput
             value={formData.namaPerusahaan}
             onChange={(val) => {
-              formData.namaPerusahaan = val.target.value;
+              setFormData(prev => ({ ...prev, namaPerusahaan: val.target.value }));
             }}
             label={<Text fw={"bold"} fz={"sm"}>Nama Perusahaan</Text>}
             placeholder='Masukkan nama perusahaan'
@@ -104,7 +104,7 @@ function EditLowonganKerja() {
           <TextInput
             value={formData.lokasi}
             onChange={(val) => {
-              formData.lokasi = val.target.value;
+              setFormData(prev => ({ ...prev, lokasi: val.target.value }));
             }}
             label={<Text fw={"bold"} fz={"sm"}>Lokasi</Text>}
             placeholder='Masukkan lokasi'
@@ -112,7 +112,7 @@ function EditLowonganKerja() {
           <TextInput
             value={formData.tipePekerjaan}
             onChange={(val) => {
-              formData.tipePekerjaan = val.target.value;
+              setFormData(prev => ({ ...prev, tipePekerjaan: val.target.value }));
             }}
             label={<Text fw={"bold"} fz={"sm"}>Tipe Pekerjaan</Text>}
             placeholder='Masukkan tipe pekerjaan'
@@ -120,7 +120,7 @@ function EditLowonganKerja() {
           <TextInput
             value={formData.gaji}
             onChange={(val) => {
-              formData.gaji = val.target.value;
+              setFormData(prev => ({ ...prev, gaji: val.target.value }));
             }}
             label={<Text fw={"bold"} fz={"sm"}>Gaji selama 1 bulan</Text>}
             placeholder='Masukkan gaji'
@@ -130,7 +130,7 @@ function EditLowonganKerja() {
             <EditEditor
               value={formData.deskripsi}
               onChange={(val) => {
-                formData.deskripsi = val;
+                setFormData(prev => ({ ...prev, deskripsi: val }));
               }}
             />
           </Box>
@@ -139,7 +139,7 @@ function EditLowonganKerja() {
             <EditEditor
               value={formData.kualifikasi}
               onChange={(val) => {
-                formData.kualifikasi = val;
+                setFormData(prev => ({ ...prev, kualifikasi: val }));
               }}
             />
           </Box>

src/app/admin/(dashboard)/ekonomi/lowongan-kerja-lokal/page.tsx

@@ -1,6 +1,6 @@
 'use client'
 import colors from '@/con/colors';
-import { Box, Button, Paper, Skeleton, Stack, Table, TableTbody, TableTd, TableTh, TableThead, TableTr } from '@mantine/core';
+import { Box, Button, Center, Pagination, Paper, Skeleton, Stack, Table, TableTbody, TableTd, TableTh, TableThead, TableTr, Text } from '@mantine/core';
 import { IconDeviceImac, IconSearch } from '@tabler/icons-react';
 import HeaderSearch from '../../_com/header';
 import JudulList from '../../_com/judulList';
@@ -30,20 +30,21 @@ function ListLowonganKerjaLokal({ search }: { search: string }) {
   const lowonganState = useProxy(lowonganKerjaState)
   const router = useRouter();
 
+  const {
+    data,
+    page,
+    totalPages,
+    loading,
+    load,
+  } = lowonganState.findMany
+
   useShallowEffect(() => {
-    lowonganState.findMany.load();
-  }, [])
+    load(page, 10, search)
+  }, [page, search])
 
-  const filteredData = (lowonganState.findMany.data || []).filter(item => {
-    const keyword = search.toLowerCase();
-    return (
-      item.posisi.toLowerCase().includes(keyword) ||
-      item.namaPerusahaan.toLowerCase().includes(keyword) ||
-      item.lokasi.toLowerCase().includes(keyword)
-    );
-  });
+  const filteredData = data || []
 
-  if (!lowonganState.findMany.data) {
+  if (loading || !data) {
     return (
       <Stack py={10}>
         <Skeleton h={500} />
@@ -60,18 +61,24 @@ function ListLowonganKerjaLokal({ search }: { search: string }) {
         <Table striped withTableBorder withRowBorders>
           <TableThead>
             <TableTr>
-              <TableTh>Bekerja Sebagai</TableTh>
-              <TableTh>Nama Usaha</TableTh>
-              <TableTh>Alamat Usaha</TableTh>
+              <TableTh>Pekerjaan</TableTh>
+              <TableTh>Nama Perusahaan</TableTh>
+              <TableTh>Lokasi</TableTh>
               <TableTh>Detail</TableTh>
               </TableTr>
           </TableThead>
           <TableTbody>
             {filteredData.map((item) => (
               <TableTr key={item.id}>
-                <TableTd>{item.posisi}</TableTd>
-                <TableTd>{item.namaPerusahaan}</TableTd>
-                <TableTd>{item.lokasi}</TableTd>
+                <TableTd>
+                  <Text fz={"md"}>{item.posisi}</Text>
+                </TableTd>
+                <TableTd>
+                  <Text fz={"md"}>{item.namaPerusahaan}</Text>
+                </TableTd>
+                <TableTd>
+                  <Text fz={"md"}>{item.lokasi}</Text>
+                </TableTd>
                 <TableTd>
                   <Button onClick={() => router.push(`/admin/ekonomi/lowongan-kerja-lokal/${item.id}`)}>
                   <IconDeviceImac size={20} />
@@ -82,6 +89,14 @@ function ListLowonganKerjaLokal({ search }: { search: string }) {
           </TableTbody>
         </Table>  
       </Paper>
+      <Center>
+        <Pagination
+          value={page}
+          onChange={(newPage) => load(newPage)}
+          total={totalPages}
+          my="md"
+        />
+      </Center>
     </Box>
   );
 }

src/app/admin/(dashboard)/ekonomi/pasar-desa/kategori-produk/page.tsx

@@ -1,6 +1,6 @@
 'use client'
 import colors from '@/con/colors';
-import { Box, Button, Paper, Skeleton, Stack, Table, TableTbody, TableTd, TableTh, TableThead, TableTr } from '@mantine/core';
+import { Box, Button, Center, Pagination, Paper, Skeleton, Stack, Table, TableTbody, TableTd, TableTh, TableThead, TableTr } from '@mantine/core';
 import { useShallowEffect } from '@mantine/hooks';
 import { IconEdit, IconSearch, IconX } from '@tabler/icons-react';
 import { useRouter } from 'next/navigation';
@@ -13,31 +13,39 @@ import pasarDesaState from '../../../_state/ekonomi/pasar-desa/pasar-desa';
 
 
 function PasarDesa() {
-  const [search, setSearch] = useState("")
+  const [search2, setSearch2] = useState("")
   return (
     <Box>
       <HeaderSearch
         title='Kategori Produk'
         placeholder='pencarian'
         searchIcon={<IconSearch size={20} />}
-        value={search}
-        onChange={(e) => setSearch(e.currentTarget.value)}
+        value={search2}
+        onChange={(e) => setSearch2(e.currentTarget.value)}
       />
-      <ListPasarDesa search={search} />
+      <ListPasarDesa search2={search2} />
     </Box>
   );
 }
 
-function ListPasarDesa({ search }: { search: string }) {
+function ListPasarDesa({ search2 }: { search2: string }) {
   const statePasar = useProxy(pasarDesaState.kategoriProduk)
   const [modalHapus, setModalHapus] = useState(false)
   const [selectedId, setSelectedId] = useState<string | null>(null)
   // const params = useParams()
   const router = useRouter()
 
+  const {
+    data,
+    page,
+    totalPages,
+    loading,
+    load,
+  } = statePasar.findMany
+
   useShallowEffect(() => {
-    statePasar.findMany.load()
-  }, [])
+    load(page, 10, search2)
+  }, [page, search2])
 
   const handleHapus = () => {
     if (selectedId) {
@@ -47,14 +55,9 @@ function ListPasarDesa({ search }: { search: string }) {
     }
   }
 
-  const filteredData = (statePasar.findMany.data || []).filter(item => {
-    const keyword = search.toLowerCase();
-    return (
-      item.nama.toLowerCase().includes(keyword)
-    );
-  });
+  const filteredData = data || []
 
-  if (!statePasar.findMany.data) {
+  if (loading || !data) {
     return (
       <Stack py={10}>
         <Skeleton h={500} />
@@ -99,6 +102,14 @@ function ListPasarDesa({ search }: { search: string }) {
           </TableTbody>
         </Table>
       </Paper>
+      <Center>
+        <Pagination
+          value={page}
+          onChange={(newPage) => load(newPage)}
+          total={totalPages}
+          my={"md"}
+        />
+      </Center>
       {/* Modal Konfirmasi Hapus */}
       <ModalKonfirmasiHapus
         opened={modalHapus}

src/app/admin/(dashboard)/ekonomi/pasar-desa/produk-pasar-desa/page.tsx

@@ -1,6 +1,6 @@
 'use client'
 import colors from '@/con/colors';
-import { Box, Button, Paper, Skeleton, Stack, Table, TableTbody, TableTd, TableTh, TableThead, TableTr } from '@mantine/core';
+import { Box, Button, Center, Pagination, Paper, Skeleton, Stack, Table, TableTbody, TableTd, TableTh, TableThead, TableTr } from '@mantine/core';
 import { IconDeviceImac, IconSearch } from '@tabler/icons-react';
 import { useShallowEffect } from '@mantine/hooks';
 import { useRouter } from 'next/navigation';
@@ -30,21 +30,21 @@ function ListPasarDesa({ search }: { search: string }) {
   const statePasar = useProxy(pasarDesaState.pasarDesa)
   const router = useRouter();
 
+  const {
+    data,
+    page,
+    totalPages,
+    loading,
+    load,
+  } = statePasar.findMany
+
   useShallowEffect(() => {
-    statePasar.findMany.load()
-  }, [])
+    load(page, 10, search)
+  }, [page, search])
 
-  const filteredData = (statePasar.findMany.data || []).filter(item => {
-    const keyword = search.toLowerCase();
-    return (
-      item.nama.toLowerCase().includes(keyword) ||
-      item.harga.toString().toLowerCase().includes(keyword) ||
-      item.rating.toString().toLowerCase().includes(keyword) ||
-      item.alamatUsaha.toLowerCase().includes(keyword)
-    );
-  });
+  const filteredData = data || []
 
-  if (!statePasar.findMany.data) {
+  if (loading || !data) {
     return (
       <Stack py={10}>
         <Skeleton h={500} />
@@ -86,6 +86,14 @@ function ListPasarDesa({ search }: { search: string }) {
           </TableTbody>
         </Table>
       </Paper>
+      <Center>
+        <Pagination
+          value={page}
+          onChange={(newPage) => load(newPage)}
+          total={totalPages}
+          my={"md"}
+        />
+      </Center>
     </Box>
   );
 }

src/app/admin/(dashboard)/keamanan/tips-keamanan/page.tsx

@@ -1,6 +1,6 @@
 'use client'
 import colors from '@/con/colors';
-import { Box, Button, Paper, Skeleton, Stack, Table, TableTbody, TableTd, TableTh, TableThead, TableTr, Text } from '@mantine/core';
+import { Box, Button, Center, Pagination, Paper, Skeleton, Stack, Table, TableTbody, TableTd, TableTh, TableThead, TableTr, Text } from '@mantine/core';
 import { IconDeviceImac, IconSearch } from '@tabler/icons-react';
 import HeaderSearch from '../../_com/header';
 import JudulList from '../../_com/judulList';
@@ -30,19 +30,21 @@ function ListTipsKeamanan({ search }: { search: string }) {
   const stateKeamanan = useProxy(tipsKeamananState)
   const router = useRouter();
 
+  const {
+    data,
+    page,
+    totalPages,
+    loading,
+    load,
+  } = stateKeamanan.findMany
+
   useShallowEffect(() => {
-    stateKeamanan.findMany.load()
-  }, [])
+    load(page, 10, search)
+  }, [page, search])
 
-  const filteredData = (stateKeamanan.findMany.data || []).filter(item => {
-    const keyword = search.toLowerCase();
-    return (
-      item.judul.toLowerCase().includes(keyword) ||
-      item.deskripsi.toLowerCase().includes(keyword)
-    );
-  });
+  const filteredData = data || []
 
-  if (!stateKeamanan.findMany.data) {
+  if (loading || !data) {
     return (
       <Stack py={10}>
         <Skeleton h={500} />
@@ -67,9 +69,15 @@ function ListTipsKeamanan({ search }: { search: string }) {
           <TableTbody>
             {filteredData.map((item) => (
               <TableTr key={item.id}>
-                <TableTd>{item.judul}</TableTd>
                 <TableTd>
-                  <Text fz={"xs"} dangerouslySetInnerHTML={{__html: item.deskripsi}} />
+                  <Box w={150}>
+                    <Text fz={"md"} truncate={"end"} lineClamp={1}>{item.judul}</Text>
+                  </Box>
+                </TableTd>
+                <TableTd>
+                  <Box w={250}>
+                    <Text fz={"md"} truncate={"end"} lineClamp={1} dangerouslySetInnerHTML={{__html: item.deskripsi}} />
+                  </Box>
                 </TableTd>
                 <TableTd>
                   <Button onClick={() => router.push(`/admin/keamanan/tips-keamanan/${item.id}`)}>
@@ -81,6 +89,14 @@ function ListTipsKeamanan({ search }: { search: string }) {
           </TableTbody>
         </Table>  
       </Paper>
+      <Center>
+        <Pagination
+          value={page}
+          onChange={(newPage) => load(newPage)}
+          total={totalPages}
+          my="md"
+        />
+      </Center>
     </Box>
   );
 }

src/app/api/[[...slugs]]/_lib/ekonomi/lowongan-kerja/findMany.ts

@@ -1,21 +1,55 @@
+/* eslint-disable @typescript-eslint/no-explicit-any */
+// /api/berita/findManyPaginated.ts
 import prisma from "@/lib/prisma";
+import { Context } from "elysia";
 
-export default async function lowonganKerjaFindMany() {
-    try {
-        const data = await prisma.lowonganPekerjaan.findMany({
-            where: { isActive: true },
-        });
+async function lowonganKerjaFindMany(context: Context) {
+  // Ambil parameter dari query
+  const page = Number(context.query.page) || 1;
+  const limit = Number(context.query.limit) || 10;
+  const search = (context.query.search as string) || '';
+  const skip = (page - 1) * limit;
 
-        return {
-            success: true,
-            message: "Success fetch lowongan kerja",
-            data,
-        };
-    } catch (e) {
-        console.error("Find many error:", e);
-        return {
-            success: false,
-            message: "Failed fetch lowongan kerja",
-        };
-    }
-}
+  // Buat where clause
+  const where: any = { isActive: true };
+
+  // Tambahkan pencarian (jika ada)
+  if (search) {
+    where.OR = [
+      { posisi: { contains: search, mode: 'insensitive' } },
+      { namaPerusahaan: { contains: search, mode: 'insensitive' } },
+      { lokasi: { contains: search, mode: 'insensitive' } },
+    ];
+  }
+
+  try {
+    // Ambil data dan total count secara paralel
+    const [data, total] = await Promise.all([
+      prisma.lowonganPekerjaan.findMany({
+        where,
+        skip,
+        take: limit,
+        orderBy: { createdAt: 'desc' },
+      }),
+      prisma.lowonganPekerjaan.count({ where }),
+    ]);
+
+    return {
+      success: true,
+      message: "Berhasil ambil lowongan kerja dengan pagination",
+      data,
+      page,
+      limit,
+      total,
+      totalPages: Math.ceil(total / limit),
+    };
+  } catch (e) {
+    console.error("Error di findMany paginated:", e);
+    return {
+      success: false,
+      message: "Gagal mengambil data lowongan kerja",
+    };
+  }
+}
+
+export default lowonganKerjaFindMany;

src/app/api/[[...slugs]]/_lib/ekonomi/pasar-desa/findMany.ts

@@ -1,26 +1,84 @@
+/* eslint-disable @typescript-eslint/no-explicit-any */
+// /api/berita/findManyPaginated.ts
 import prisma from "@/lib/prisma";
+import { Context } from "elysia";
 
-export default async function pasarDesaFindMany() {
-  const data = await prisma.pasarDesa.findMany({
-    where: {
-      isActive: true, // Opsional filter
-    },
-    orderBy: {
-      createdAt: "desc",
-    },
-    include: {
-      image: true,
-      KategoriToPasar: {
+async function pasarDesaFindMany(context: Context) {
+  // Ambil parameter dari query
+  const page = Number(context.query.page) || 1;
+  const limit = Number(context.query.limit) || 10;
+  const search = (context.query.search as string) || '';
+  const categoryId = context.query.categoryId as string | undefined;
+  const skip = (page - 1) * limit;
+
+  // Buat where clause
+  const where: any = { isActive: true };
+
+  // Tambahkan filter kategori (jika ada)
+  if (categoryId) {
+    where.KategoriToPasar = {
+      some: {
+        kategoriId: categoryId
+      }
+    };
+  }
+
+  // Tambahkan pencarian (jika ada)
+  if (search) {
+    where.AND = where.AND || [];
+    where.AND.push({
+      OR: [
+        { nama: { contains: search, mode: 'insensitive' } },
+        { alamatUsaha: { contains: search, mode: 'insensitive' } },
+        { 
+          KategoriToPasar: { 
+            some: { 
+              kategori: { 
+                nama: { contains: search, mode: 'insensitive' } 
+              } 
+            } 
+          } 
+        }
+      ]
+    });
+  }
+
+  try {
+    // Ambil data dan total count secara paralel
+    const [data, total] = await Promise.all([
+      prisma.pasarDesa.findMany({
+        where,
         include: {
-          kategori: true,
+          image: true,
+          KategoriToPasar: {
+            include: {
+              kategori: true
+            }
+          }
         },
-      },
-    },
-  });
+        skip,
+        take: limit,
+        orderBy: { createdAt: 'desc' },
+      }),
+      prisma.pasarDesa.count({ where }),
+    ]);
 
-  return {
-    success: true,
-    message: "Berhasil mengambil semua data pasar desa",
-    data,
-  };
+    return {
+      success: true,
+      message: "Berhasil ambil pasar desa dengan pagination",
+      data,
+      page,
+      limit,
+      total,
+      totalPages: Math.ceil(total / limit),
+    };
+  } catch (e) {
+    console.error("Error di findMany paginated:", e);
+    return {
+      success: false,
+      message: "Gagal mengambil data pasar desa",
+    };
+  }
 }
+
+export default pasarDesaFindMany;

src/app/api/[[...slugs]]/_lib/ekonomi/pasar-desa/kategori-produk/findMany.ts

@@ -1,15 +1,60 @@
 /* eslint-disable @typescript-eslint/no-explicit-any */
+// /api/berita/findManyPaginated.ts
 import prisma from "@/lib/prisma";
+import { Context } from "elysia";
 
-export default async function kategoriProdukFindMany() {
-    const data = await prisma.kategoriProduk.findMany();
-    return { 
-        success: true,
-        data: data.map((item: any) => {
-            return {
-                id: item.id,
-                nama: item.nama,
-            }
-        }),
+async function kategoriProdukFindMany(context: Context) {
+  // Ambil parameter dari query
+  const page = Number(context.query.page) || 1;
+  const limit = Number(context.query.limit) || 10;
+  const search2 = (context.query.search as string) || '';
+  const skip = (page - 1) * limit;
+
+  // Buat where clause
+  const where: any = { isActive: true };
+
+  // Tambahkan pencarian (jika ada)
+  if (search2) {
+    where.OR = [
+      { nama: { contains: search2, mode: 'insensitive' } },
+      {KategoriToPasar : {
+        some: {
+          kategori: {
+            nama: { contains: search2, mode: 'insensitive' }
+          }
+        }
+      }}
+    ];
+  }
+
+  try {
+    // Ambil data dan total count secara paralel
+    const [data, total] = await Promise.all([
+      prisma.kategoriProduk.findMany({
+        where,
+        skip,
+        take: limit,
+        orderBy: { createdAt: 'desc' },
+      }),
+      prisma.kategoriProduk.count({ where }),
+    ]);
+
+    return {
+      success: true,
+      message: "Berhasil ambil kategori produk dengan pagination",
+      data,
+      page,
+      limit,
+      total,
+      totalPages: Math.ceil(total / limit),
     };
-}
+  } catch (e) {
+    console.error("Error di findMany paginated:", e);
+    return {
+      success: false,
+      message: "Gagal mengambil data kategori produk",
+    };
+  }
+}
+
+export default kategoriProdukFindMany;

src/app/api/[[...slugs]]/_lib/fileStorage/_lib/create.ts

@@ -1,4 +1,3 @@
-// create.ts
 import prisma from "@/lib/prisma";
 import { Context } from "elysia";
 import fs from "fs/promises";
@@ -6,155 +5,47 @@ import path from "path";
 import { nanoid } from "nanoid";
 
 const UPLOAD_DIR = process.env.WIBU_UPLOAD_DIR;
-const BASE_URL = process.env.NEXT_PUBLIC_BASE_URL;
 
 const fileStorageCreate = async (context: Context) => {
   const body = (await context.body) as {
     name: string;
-    file?: File;
-    googleDriveLink?: string;
+    file: File;
   };
-
   const file = body.file;
-  const googleDriveLink = body.googleDriveLink?.trim();
   const name = body.name;
 
+  if (!file) return { status: 400, body: "No file uploaded" };
   if (!name) return { status: 400, body: "No name provided" };
   if (!UPLOAD_DIR) return { status: 500, body: "UPLOAD_DIR is not defined" };
-  if (!BASE_URL) return { status: 500, body: "NEXT_PUBLIC_BASE_URL is not defined" };
 
-  let category = "document";
-  let mimeType = "application/octet-stream";
-  let link = "";
+  // Tentukan kategori berdasarkan mimeType
+  const isImage = file.type.startsWith("image/");
+  const category = isImage ? "image" : "document";
 
-  // 📁 1. Upload File Lokal
-  if (file) {
-    const isImage = file.type.startsWith("image/");
-    category = isImage ? "image" : "document";
-    const pathName = category === "image" ? "images" : "documents";
-    const rootPath = path.join(UPLOAD_DIR, pathName);
-    await fs.mkdir(rootPath, { recursive: true });
+  const pathName = category === "image" ? "images" : "documents";
+  const rootPath = path.join(UPLOAD_DIR, pathName);
+  await fs.mkdir(rootPath, { recursive: true });
 
-    const parts = file.name.split(".");
-    const ext = parts.length > 1 ? parts.pop() : "bin";
-    const newName = nanoid() + "." + ext;
+  const ext = file.name.split(".").pop();
+  const newName = nanoid() + "." + ext;
 
-    mimeType = file.type;
-    link = `${BASE_URL}/uploads/${pathName}/${newName}`;
+  const data = await prisma.fileStorage.create({
+    data: {
+      name: newName,
+      realName: file.name,
+      path: rootPath,
+      mimeType: file.type,
+      category,
+      link: `/api/fileStorage/findUnique/${newName}`,
+    },
+  });
 
-    const data = await prisma.fileStorage.create({
-      data: {
-        name: newName,
-        realName: file.name,
-        path: rootPath,
-        mimeType,
-        category,
-        link,
-      },
-    });
+  await fs.writeFile(
+    path.join(rootPath, newName),
+    Buffer.from(await file.arrayBuffer())
+  );
 
-    await fs.writeFile(
-      path.join(rootPath, newName),
-      Buffer.from(await file.arrayBuffer())
-    );
-
-    return { data };
-  }
-
-  // 🌐 2. Upload dari Google Drive
-  if (googleDriveLink) {
-    // Ekstrak ID dari link Google Drive
-    const idMatch = googleDriveLink.match(/[-\w]{25,}/);
-    if (!idMatch) {
-      return { status: 400, body: "Invalid Google Drive link" };
-    }
-
-    const fileId = idMatch[0];
-    const embedLink = `https://drive.google.com/uc?export=view&id=${fileId}`;
-
-    // Validasi: cek apakah file bisa diakses
-    try {
-      const res = await fetch(embedLink);
-      if (!res.ok) {
-        return { status: 400, body: "Google Drive file not accessible (403/404)" };
-      }
-    } catch (error) {
-      return { status: 400, body: "Failed to access Google Drive file", error };
-    }
-
-    // Simpan ke database
-    const data = await prisma.fileStorage.create({
-      data: {
-        name: `gdrive-${fileId}`,
-        realName: name,
-        path: "",
-        mimeType: "image/jpeg", // default untuk embed
-        category: "image",
-        link: embedLink,
-      },
-    });
-
-    return { data };
-  }
-
-  // ❌ Tidak ada file atau link
-  return { status: 400, body: "Either 'file' or 'googleDriveLink' must be provided" };
+  return { data };
 };
 
 export default fileStorageCreate;
-
-
-
-
-// //kodingan sebelumnya:
-// import prisma from "@/lib/prisma";
-// import { Context } from "elysia";
-// import fs from "fs/promises";
-// import path from "path";
-// import { nanoid } from "nanoid";
-
-// const UPLOAD_DIR = process.env.WIBU_UPLOAD_DIR;
-
-// const fileStorageCreate = async (context: Context) => {
-//   const body = (await context.body) as {
-//     name: string;
-//     file: File;
-//   };
-//   const file = body.file;
-//   const name = body.name;
-
-//   if (!file) return { status: 400, body: "No file uploaded" };
-//   if (!name) return { status: 400, body: "No name provided" };
-//   if (!UPLOAD_DIR) return { status: 500, body: "UPLOAD_DIR is not defined" };
-
-//   // Tentukan kategori berdasarkan mimeType
-//   const isImage = file.type.startsWith("image/");
-//   const category = isImage ? "image" : "document";
-
-//   const pathName = category === "image" ? "images" : "documents";
-//   const rootPath = path.join(UPLOAD_DIR, pathName);
-//   await fs.mkdir(rootPath, { recursive: true });
-
-//   const ext = file.name.split(".").pop();
-//   const newName = nanoid() + "." + ext;
-
-//   const data = await prisma.fileStorage.create({
-//     data: {
-//       name: newName,
-//       realName: file.name,
-//       path: rootPath,
-//       mimeType: file.type,
-//       category,
-//       link: `/api/fileStorage/findUnique/${newName}`,
-//     },
-//   });
-
-//   await fs.writeFile(
-//     path.join(rootPath, newName),
-//     Buffer.from(await file.arrayBuffer())
-//   );
-
-//   return { data };
-// };
-
-// export default fileStorageCreate;

src/app/api/[[...slugs]]/_lib/keamanan/tips-keamanan/findMany.ts

@@ -1,24 +1,57 @@
+/* eslint-disable @typescript-eslint/no-explicit-any */
+// /api/berita/findManyPaginated.ts
 import prisma from "@/lib/prisma";
+import { Context } from "elysia";
 
-export default async function menuTipsKeamananFindMany() {
-    try {
-        const data = await prisma.menuTipsKeamanan.findMany({
-            where: { isActive: true },
-            include: {
-                image: true,
-            },
-        });
+async function tipsKeamananFindMany(context: Context) {
+  // Ambil parameter dari query
+  const page = Number(context.query.page) || 1;
+  const limit = Number(context.query.limit) || 10;
+  const search = (context.query.search as string) || '';
+  const skip = (page - 1) * limit;
 
-        return {
-            success: true,
-            message: "Success fetch menu tips keamanan",
-            data,
-        };
-    } catch (e) {
-        console.error("Find many error:", e);
-        return {
-            success: false,
-            message: "Failed fetch menu tips keamanan",
-        };
-    }
-}
+  // Buat where clause
+  const where: any = { isActive: true };
+
+  // Tambahkan pencarian (jika ada)
+  if (search) {
+    where.OR = [
+      { judul: { contains: search, mode: 'insensitive' } },
+      { deskripsi: { contains: search, mode: 'insensitive' } },
+    ];
+  }
+
+  try {
+    // Ambil data dan total count secara paralel
+    const [data, total] = await Promise.all([
+      prisma.menuTipsKeamanan.findMany({
+        where,
+        include: {
+          image: true,
+        },
+        skip,
+        take: limit,
+        orderBy: { createdAt: 'desc' },
+      }),
+      prisma.menuTipsKeamanan.count({ where }),
+    ]);
+
+    return {
+      success: true,
+      message: "Berhasil ambil menu tips keamanan dengan pagination",
+      data,
+      page,
+      limit,
+      total,
+      totalPages: Math.ceil(total / limit),
+    };
+  } catch (e) {
+    console.error("Error di findMany paginated:", e);
+    return {
+      success: false,
+      message: "Gagal mengambil data tips keamanan",
+    };
+  }
+}
+
+export default tipsKeamananFindMany;

src/app/darmasaba/(pages)/ekonomi/lowongan-kerja-lokal/page.tsx

@@ -1,64 +1,52 @@
 'use client'
+import lowonganKerjaState from '@/app/admin/(dashboard)/_state/ekonomi/lowongan-kerja';
 import colors from '@/con/colors';
-import { Stack, Box, Text, TextInput, Group, SimpleGrid, Paper, Flex, Button } from '@mantine/core';
-import React from 'react';
-import BackButton from '../../desa/layanan/_com/BackButto';
+import { Box, Button, Center, Flex, Group, Pagination, Paper, SimpleGrid, Skeleton, Stack, Text, TextInput } from '@mantine/core';
+import { useDebouncedValue } from '@mantine/hooks';
 import { IconBriefcase, IconClock, IconMapPin, IconSearch } from '@tabler/icons-react';
 import { useRouter } from 'next/navigation';
+import { useEffect, useState } from 'react';
+import { useProxy } from 'valtio/utils';
+import BackButton from '../../desa/layanan/_com/BackButto';
 
-const data = [
-  {
-    id: 1,
-    kerja: 'Kasir',
-    tempat: 'Toko Sumber Rejeki',
-    alamat: 'Desa Munggu , Badung',
-    gaji: 'Rp. 2.500.000 / bulan'
+const formatCurrency = (value: string | number) => {
+  // Convert to string if it's a number
+  const numStr = typeof value === 'number' ? value.toString() : value;
+  
+  // Remove all non-digit characters
+  const digitsOnly = numStr.replace(/\D/g, '');
+  
+  // Format with thousand separators
+  const formatted = digitsOnly.replace(/\B(?=(\d{3})+(?!\d))/g, '.');
+  
+  return `Rp.${formatted}`;
+};
 
-  },
-  {
-    id: 2,
-    kerja: 'Kasir',
-    tempat: 'Toko Sumber Rejeki',
-    alamat: 'Desa Munggu , Badung',
-    gaji: 'Rp. 2.500.000 / bulan'
-
-  },
-  {
-    id: 3,
-    kerja: 'Kasir',
-    tempat: 'Toko Sumber Rejeki',
-    alamat: 'Desa Munggu , Badung',
-    gaji: 'Rp. 2.500.000 / bulan'
-
-  },
-  {
-    id: 4,
-    kerja: 'Kasir',
-    tempat: 'Toko Sumber Rejeki',
-    alamat: 'Desa Munggu , Badung',
-    gaji: 'Rp. 2.500.000 / bulan'
-
-  },
-  {
-    id: 5,
-    kerja: 'Kasir',
-    tempat: 'Toko Sumber Rejeki',
-    alamat: 'Desa Munggu , Badung',
-    gaji: 'Rp. 2.500.000 / bulan'
-
-  },
-  {
-    id: 6,
-    kerja: 'Kasir',
-    tempat: 'Toko Sumber Rejeki',
-    alamat: 'Desa Munggu , Badung',
-    gaji: 'Rp. 2.500.000 / bulan'
-
-  },
-
-]
 function Page() {
+  const state = useProxy(lowonganKerjaState)
   const router = useRouter()
+  const [search, setSearch] = useState('')
+  const [debouncedSearch] = useDebouncedValue(search, 500); // 500ms delay
+
+  const {
+    data,
+    page,
+    totalPages,
+    loading,
+    load,
+  } = state.findMany
+
+  useEffect(() => {
+    load(page, 6, debouncedSearch)
+  }, [page, debouncedSearch, load])
+
+  if (loading || !data) {
+    return (
+      <Stack py={10}>
+        <Skeleton h={500} />
+      </Stack>
+    )
+  }
   return (
     <Stack pos={"relative"} bg={colors.Bg} py={"xl"} gap={"22"}>
       <Box px={{ base: 'md', md: 100 }}>
@@ -74,6 +62,8 @@ function Page() {
             w={{ base: 500, md: 700 }}
             placeholder='Cari Pekerjaan'
             leftSection={<IconSearch size={20} />}
+            value={search}
+            onChange={(e) => setSearch(e.currentTarget.value)}
           />
         </Group>
       </Box>
@@ -93,15 +83,15 @@ function Page() {
                       <Flex gap={'xl'} align={'center'}>
                         <IconBriefcase color={colors['blue-button']} size={50} />
                         <Box>
-                          <Text fw={'bold'} fz={'h4'} c={colors['blue-button']}>{v.kerja}</Text>
-                          <Text fz={'h4'}>{v.tempat}</Text>
+                          <Text fw={'bold'} fz={'h4'} c={colors['blue-button']}>{v.posisi}</Text>
+                          <Text fz={'h4'}>{v.namaPerusahaan}</Text>
                         </Box>
                       </Flex>
                     </Box>
                     <Box>
                       <Flex gap={'xl'} align={'center'}>
                         <IconMapPin color={colors['blue-button']} size={50} />
-                        <Text fz={'h4'}>{v.alamat}</Text>
+                        <Text fz={'h4'}>{v.lokasi}</Text>
                       </Flex>
                     </Box>
                     <Box>
@@ -109,7 +99,7 @@ function Page() {
                         <IconClock color={colors['blue-button']} size={50} />
                         <Box>
                           <Text fw={'bold'} fz={'h4'} c={colors['blue-button']}>Full Time</Text>
-                          <Text fz={'h4'}>{v.gaji}</Text>
+                          <Text fz={'h4'}>{formatCurrency(v.gaji)}</Text>
                         </Box>
                       </Flex>
                     </Box>
@@ -119,6 +109,14 @@ function Page() {
               )
             })}
           </SimpleGrid>
+          <Center>
+            <Pagination
+              value={page}
+              onChange={(newPage) => load(newPage)}
+              total={totalPages}
+              my="md"
+            />
+          </Center>
         </Stack>
       </Box >
     </Stack >

src/app/darmasaba/(pages)/ekonomi/pasar-desa/page.tsx

@@ -1,90 +1,76 @@
 'use client'
+import pasarDesaState from '@/app/admin/(dashboard)/_state/ekonomi/pasar-desa/pasar-desa';
 import colors from '@/con/colors';
-import { Box, Combobox, Flex, Image, InputBase, InputPlaceholder, Paper, SimpleGrid, Stack, Text, TextInput, useCombobox } from '@mantine/core';
+import { Box, Center, Flex, Grid, GridCol, Image, Pagination, Paper, Select, SimpleGrid, Skeleton, Stack, Text, TextInput } from '@mantine/core';
+import { useShallowEffect } from '@mantine/hooks';
 import { IconMapPinFilled, IconSearch, IconShoppingCartFilled, IconStarFilled } from '@tabler/icons-react';
 import { motion } from 'motion/react';
 import { useRouter } from 'next/navigation';
 import { useState } from 'react';
+import { useProxy } from 'valtio/utils';
 import BackButton from '../../desa/layanan/_com/BackButto';
 
-const groceries = [
-  'Makanan',
-  'Minuman',
-  'Pakaian',
-  'Alat Dapur',
-  'Alat Mandi',
-  'Furniture',
-];
-
-const dataBarang = [
-  {
-    id: 1,
-    image: '/api/img/semat.png',
-    judul: 'Semat Bambu / Semat Banten',
-    harga: 'Rp. 3000 / pcs',
-    bintang: '4.9',
-    alamat: 'Jl. Kecubung no.6'
-  },
-  {
-    id: 2,
-    image: '/api/img/kerupuk.png',
-    judul: 'Kerupuk Babi',
-    harga: 'Rp. 12000 / pcs',
-    bintang: '4.9',
-    alamat: 'Jl. Kenari no.7'
-  },
-  {
-    id: 3,
-    image: '/api/img/beras.png',
-    judul: 'beras Merah Organik',
-    harga: 'Rp. 40000 / 1 kg',
-    bintang: '4.9',
-    alamat: 'Jl. Mawar no.8'
-  },
-  {
-    id: 4,
-    image: '/api/img/genteng.png',
-    judul: 'Genteng',
-    harga: 'Rp. 3600 / pcs',
-    bintang: '4.9',
-    alamat: 'Jl. Kecubung no.16'
-  },
-
-]
 function Page() {
-  const [search, setSearch] = useState('');
-  const combobox = useCombobox({
-    onDropdownClose: () => {
-      combobox.resetSelectedOption();
-      combobox.focusTarget();
-      setSearch('');
-    },
-
-    onDropdownOpen: () => {
-      combobox.focusSearchInput();
-    },
-  });
-
-  const [value, setValue] = useState<string | null>(null);
-
-  const options = groceries
-    .filter((item) => item.toLowerCase().includes(search.toLowerCase().trim()))
-    .map((item) => (
-      <Combobox.Option value={item} key={item}>
-        {item}
-      </Combobox.Option>
-    ));
   const router = useRouter()
+  const state = useProxy(pasarDesaState.pasarDesa)
+  const [search, setSearch] = useState('');
+  const [selectedCategory, setSelectedCategory] = useState<string | null>(null);
+  const {
+    data,
+    page,
+    loading,
+    totalPages,
+    load,
+  } = state.findMany
+
+  useShallowEffect(() => {
+    pasarDesaState.kategoriProduk.findMany.load()
+  }, [])
+
+  // Filter data based on selected category
+  const filteredData = selectedCategory
+    ? data?.filter(item => 
+        item.KategoriToPasar?.some(kategori => kategori.kategoriId === selectedCategory)
+      )
+    : data;
+
+  useShallowEffect(() => {
+    load(page, 4, search, selectedCategory || undefined)
+  }, [page, search, selectedCategory])
+
+
+  if (loading || !data) {
+    return (
+      <Stack py={10}>
+        <Skeleton h={500} />
+      </Stack>
+    )
+  }
+
   return (
     <Stack pos={"relative"} bg={colors.Bg} py={"xl"} gap={"22"}>
       <Box px={{ base: 'md', md: 100 }}>
         <BackButton />
       </Box>
       <Box>
-        <Text ta={"center"} fz={{ base: "h1", md: "2.5rem" }} c={colors["blue-button"]} fw={"bold"}>
-          Pasar Desa
-        </Text>
-        <Text px={{ base: 20, md: 150 }} ta={"center"} fz={{ base: "h4", md: "h3" }} >
+        <Grid align='center' px={{ base: 'md', md: 100 }}>
+          <GridCol span={{ base: 12, md: 9 }}>
+            <Text fz={{ base: "h1", md: "2.5rem" }} c={colors["blue-button"]} fw={"bold"}>
+              Pasar Desa
+            </Text>
+          </GridCol>
+          <GridCol span={{ base: 12, md: 3 }}>
+            <TextInput
+              radius={"lg"}
+              placeholder='Cari Produk'
+              value={search}
+              onChange={(e) => setSearch(e.target.value)}
+              leftSection={<IconSearch size={20} />}
+              w={{ base: "50%", md: "100%" }}
+            />
+          </GridCol>
+        </Grid>
+        <Text px={{ base: 'md', md: 100 }} ta={"justify"} fz={{ base: "h4", md: "h3" }} >
           Pasar Desa Online merupakan Media Promosi yang bertujuan untuk membantu warga desa dalam memasarkan dan memperkenalkan produknya kepada masyarakat.
         </Text>
       </Box>
@@ -98,48 +84,23 @@ function Page() {
             }}
           >
             <Box>
-              <Combobox
-                store={combobox}
-                withinPortal={false}
-                onOptionSubmit={(val) => {
-                  setValue(val);
-                  combobox.closeDropdown();
-                }}
-              >
-                <Combobox.Target>
-                  <InputBase
-                    component="button"
-                    type="button"
-                    pointer
-                    rightSection={<Combobox.Chevron />}
-                    onClick={() => combobox.toggleDropdown()}
-                    rightSectionPointerEvents="none"
-                  >
-                    {value || <InputPlaceholder>Kategori</InputPlaceholder>}
-                  </InputBase>
-                </Combobox.Target>
-
-                <Combobox.Dropdown>
-                  <Combobox.Search
-                    value={search}
-                    onChange={(event) => setSearch(event.currentTarget.value)}
-                    placeholder="Search groceries"
-                  />
-                  <Combobox.Options>
-                    {options.length > 0 ? options : <Combobox.Empty>Nothing found</Combobox.Empty>}
-                  </Combobox.Options>
-                </Combobox.Dropdown>
-              </Combobox>
-            </Box>
-            <Box>
-              <TextInput
-                placeholder='Cari Produk'
-                leftSection={<IconSearch size={20} />}
+              <Select
+                placeholder="Pilih Kategori"
+                data={pasarDesaState.kategoriProduk.findMany.data?.map((v) => ({
+                  value: v.id,
+                  label: v.nama
+                })) || []}
+                value={selectedCategory}
+                onChange={setSelectedCategory}
+                clearable
+                searchable
+                nothingFoundMessage="Tidak ada kategori ditemukan"
+                style={{ width: '100%' }}
               />
             </Box>
           </SimpleGrid>
           <SimpleGrid cols={{ base: 1, md: 4 }}>
-            {dataBarang.map((v, k) => {
+            {filteredData?.map((v, k) => {
               return (
                 <Stack key={k}>
                   <motion.div
@@ -148,18 +109,25 @@ function Page() {
                     whileTap={{ scale: 0.8 }}
                   >
                     <Paper p={'lg'}>
-                      <Image radius={'lg'} src={v.image} alt='' />
-                      <Text py={10} fw={'bold'} fz={'lg'}>{v.judul}</Text>
-                      <Text fz={'md'}>{v.harga}</Text>
+                      <Image
+                        radius={'lg'}
+                        src={v.image?.link || '/placeholder-product.jpg'}
+                        alt={v.nama}
+                        h={200}
+                        w='100%'
+                        style={{ objectFit: 'cover' }}
+                      />
+                      <Text py={10} fw={'bold'} fz={'lg'}>{v.nama}</Text>
+                      <Text fz={'md'}>Rp {v.harga.toLocaleString('id-ID')}</Text>
                       <Flex py={10} gap={'md'}>
                         <IconStarFilled size={20} color='#EBCB09' />
-                        <Text fz={'sm'} ml={2}>{v.bintang}</Text>
+                        <Text fz={'sm'} ml={2}>{v.rating}</Text>
                       </Flex>
                       <Flex justify={'space-between'} align={'center'}>
                         <Box>
                           <Flex gap={'md'} align={'center'}>
                             <IconMapPinFilled size={20} color='red' />
-                            <Text fz={'sm'} ml={2}>{v.alamat}</Text>
+                            <Text fz={'sm'} ml={2}>{v.alamatUsaha}</Text>
                           </Flex>
                         </Box>
                         <IconShoppingCartFilled size={20} color={colors['blue-button']} />
@@ -170,6 +138,14 @@ function Page() {
               )
             })}
           </SimpleGrid>
+          <Center>
+            <Pagination
+              value={page}
+              onChange={(newPage) => load(newPage)} // ini penting!
+              total={totalPages}
+              my="md"
+            />
+          </Center>
         </Stack>
       </Box>
     </Stack>

src/app/darmasaba/(pages)/keamanan/keamanan-lingkungan-pecalang-patwal/page.tsx

@@ -88,7 +88,7 @@ function Page() {
             })}
           </SimpleGrid>
         </Stack>
-      </Box>
+      </Box>  
       <Center>
         <Pagination
           value={page}

src/app/darmasaba/(pages)/keamanan/tips-keamanan/page.tsx

@@ -1,83 +1,62 @@
+'use client'
 import colors from '@/con/colors';
-import { Box, Center, Image, List, ListItem, Paper, SimpleGrid, Stack, Text } from '@mantine/core';
+import { Box, Center, Grid, GridCol, Image, Pagination, Paper, SimpleGrid, Skeleton, Stack, Text, TextInput } from '@mantine/core';
 import BackButton from '../../desa/layanan/_com/BackButto';
+import { useProxy } from 'valtio/utils';
+import tipsKeamananState from '@/app/admin/(dashboard)/_state/keamanan/tips-keamanan';
+import { useShallowEffect } from '@mantine/hooks';
+import { useState } from 'react';
+import { IconSearch } from '@tabler/icons-react';
 
-const data1 = [
-  {
-    id: 1,
-    judul: 'Keamanan Rumah',
-    image: '/api/img/kemanan.png',
-    deskripsi: <List>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Pastikan pintu dan jendela selalu terkunci saat meninggalkan rumah.</ListItem>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Pasang lampu penerangan di halaman dan area sekitar rumah untuk mencegah tindak kejahatan.</ListItem>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Jangan mudah memberikan akses masuk ke orang yang tidak dikenal.</ListItem>
-    </List>
-  },
-  {
-    id: 2,
-    judul: 'Keamanan di Jalan',
-    image: '/api/img/keamananjalan.png',
-    deskripsi: <List>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Hindari berjalan sendirian di tempat sepi, terutama pada malam hari.</ListItem>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Simpan barang berharga di tempat yang aman saat bepergian.</ListItem>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Gunakan jalur yang ramai dan terang saat pulang malam.</ListItem>
-    </List>
-  },
-  {
-    id: 3,
-    judul: 'Keamanan Kendaraan',
-    image: '/api/img/keamanankendaraan.png',
-    deskripsi: <List>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Gunakan kunci ganda saat memarkir kendaraan, terutama di tempat umum.</ListItem>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Parkir di tempat yang terang dan mudah diawasi.</ListItem>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Jangan meninggalkan barang berharga di dalam kendaraan.</ListItem>
-    </List>
-  },
-  {
-    id: 4,
-    judul: 'Keamanan Sosial',
-    image: '/api/img/mencurigakan.png',
-    deskripsi: <List>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Laporkan kejadian mencurigakan kepada Pecalang atau perangkat desa.</ListItem>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Jangan mudah percaya terhadap informasi yang belum jelas sumbernya.</ListItem>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Ikuti program sosialisasi keamanan yang diadakan oleh desa.</ListItem>
-    </List>
-  },
-  {
-    id: 5,
-    judul: 'Sistem Laporan Kejadian',
-    image: '/api/img/securitydigital.png',
-    deskripsi: <List>
-      <ListItem>Jangan mudah membagikan informasi pribadi di media sosial.</ListItem>
-      <ListItem>Waspada terhadap penipuan online dan telepon yang mengatasnamakan instansi resmi.</ListItem>
-      <ListItem>Gunakan kata sandi yang kuat untuk akun digital dan ganti secara berkala.</ListItem>
-    </List>
-  },
-  {
-    id: 6,
-    judul: 'Nomor Darurat yang Bisa Dihubungi',
-    image: '/api/img/kontakpecalang.png',
-    deskripsi: <List>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Pecalang: 08125651052</ListItem>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Ambulans: 08125651052</ListItem>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Pemadam Kebakaran: 113</ListItem>
-      <ListItem ta={'justify'} fz={{ base: 'h4', md: 'lg' }}>Polisi: 110</ListItem>
-    </List>
-  }
-]
 
 function Page() {
+  const state = useProxy(tipsKeamananState)
+  const [search, setSearch] = useState('')
+  const {
+    data,
+    page,
+    totalPages,
+    loading,
+    load,
+  } = state.findMany;
+
+  useShallowEffect(() => {
+    load(page, 3, search)
+  }, [page, search])
+
+  if (loading || !data) {
+    return (
+      <Stack pos={"relative"} bg={colors.Bg} py={"xl"} gap={"22"}>
+        <Skeleton h={500} />
+      </Stack>
+    )
+  }
+
   return (
     <Stack pos={"relative"} bg={colors.Bg} py={"xl"} gap={"22"}>
       <Box px={{ base: 'md', md: 100 }}>
         <BackButton />
       </Box>
       <Box>
-        <Text ta={"center"} fz={{ base: "h1", md: "2.5rem" }} c={colors["blue-button"]} fw={"bold"}>
-          Tips Keamanan
-        </Text>
-        <Text px={{ base: 20, md: 150 }} ta={"center"} fz={{ base: "h4", md: "h3" }} >
-          Desa Darmasaba berkomitmen untuk menjaga keamanan dan kenyamanan seluruh warganya. Berikut beberapa tips yang dapat membantu meningkatkan keamanan di lingkungan desa.
+        <Grid align='center' px={{ base: 'md', md: 100 }}>
+          <GridCol span={{ base: 12, md: 9 }}>
+            <Text fz={{ base: "h1", md: "2.5rem" }} c={colors["blue-button"]} fw={"bold"}>
+              Tips Keamanan
+            </Text>
+          </GridCol>
+          <GridCol span={{ base: 12, md: 3 }}>
+            <TextInput
+              radius={"lg"}
+              placeholder='Cari Tips'
+              value={search}
+              onChange={(e) => setSearch(e.target.value)}
+              leftSection={<IconSearch size={20} />}
+              w={{ base: "50%", md: "100%" }}
+            />
+          </GridCol>
+        </Grid>
+        <Text px={{ base: 'md', md: 100 }} ta={"justify"} fz={{ base: "h4", md: "h3" }} >
+          Keamanan dan ketertiban lingkungan di Desa Darmasaba dijaga melalui peran aktif Pecalang dan Patwal (Patroli Pengawal). Mereka bertugas memastikan desa tetap aman, tertib, dan kondusif bagi seluruh warga.
         </Text>
       </Box>
       <Box px={{ base: "md", md: 100 }}>
@@ -88,21 +67,21 @@ function Page() {
               base: 1,
               md: 3,
             }}>
-            {data1.map((v, k) => {
+            {data.map((v, k) => {
               return (
                 <Paper radius={10} key={k} bg={colors["white-trans-1"]}>
                   <Stack gap={'xs'}>
                     <Center p={10}>
-                      <Image src={v.image} radius={10}
-                     alt='' />
+                      <Image src={v.image?.link} radius={10}
+                        alt='' />
                     </Center>
                     <Box px={'xl'}>
                       <Box pb={20}>
                         <Text pb={10} c={colors["blue-button"]} fw={"bold"} fz={"h3"}>
                           {v.judul}
                         </Text>
-                        <Box pr={10}>
-                          {v.deskripsi}
+                        <Box>
+                          <Text pb={10} fz={"md"} dangerouslySetInnerHTML={{ __html: v.deskripsi }} />
                         </Box>
                       </Box>
                     </Box>
@@ -113,6 +92,14 @@ function Page() {
           </SimpleGrid>
         </Stack>
       </Box>
+      <Center>
+        <Pagination
+          value={page}
+          onChange={(newPage) => load(newPage)} // ini penting!
+          total={totalPages}
+          my="md"
+        />
+      </Center>
     </Stack>
   );
 }