Compare commits
6 Commits
fix/admin/
...
nico/25-fe
| Author | SHA1 | Date | |
|---|---|---|---|
| 223b85a714 | |||
| f1729151b3 | |||
| 8e8c133eea | |||
| 1e7acac193 | |||
| 42dcbcfb22 | |||
| 22de1aa1f3 |
@@ -26,7 +26,24 @@ export async function seedBerita() {
|
||||
|
||||
console.log("🔄 Seeding Berita...");
|
||||
|
||||
// Build a map of valid kategori IDs
|
||||
const validKategoriIds = new Set<string>();
|
||||
const kategoriList = await prisma.kategoriBerita.findMany({
|
||||
select: { id: true, name: true },
|
||||
});
|
||||
kategoriList.forEach((k) => validKategoriIds.add(k.id));
|
||||
|
||||
console.log(`📋 Found ${validKategoriIds.size} valid kategori IDs in database`);
|
||||
|
||||
for (const b of beritaJson) {
|
||||
// Validate kategoriBeritaId exists
|
||||
if (!b.kategoriBeritaId || !validKategoriIds.has(b.kategoriBeritaId)) {
|
||||
console.warn(
|
||||
`⚠️ Skipping berita "${b.judul}": Invalid kategoriBeritaId "${b.kategoriBeritaId}"`,
|
||||
);
|
||||
continue;
|
||||
}
|
||||
|
||||
let imageId: string | null = null;
|
||||
|
||||
if (b.imageName) {
|
||||
@@ -44,26 +61,32 @@ export async function seedBerita() {
|
||||
}
|
||||
}
|
||||
|
||||
await prisma.berita.upsert({
|
||||
where: { id: b.id },
|
||||
update: {
|
||||
judul: b.judul,
|
||||
deskripsi: b.deskripsi,
|
||||
content: b.content,
|
||||
kategoriBeritaId: b.kategoriBeritaId,
|
||||
imageId,
|
||||
},
|
||||
create: {
|
||||
id: b.id,
|
||||
judul: b.judul,
|
||||
deskripsi: b.deskripsi,
|
||||
content: b.content,
|
||||
kategoriBeritaId: b.kategoriBeritaId,
|
||||
imageId,
|
||||
},
|
||||
});
|
||||
try {
|
||||
await prisma.berita.upsert({
|
||||
where: { id: b.id },
|
||||
update: {
|
||||
judul: b.judul,
|
||||
deskripsi: b.deskripsi,
|
||||
content: b.content,
|
||||
kategoriBeritaId: b.kategoriBeritaId,
|
||||
imageId,
|
||||
},
|
||||
create: {
|
||||
id: b.id,
|
||||
judul: b.judul,
|
||||
deskripsi: b.deskripsi,
|
||||
content: b.content,
|
||||
kategoriBeritaId: b.kategoriBeritaId,
|
||||
imageId,
|
||||
},
|
||||
});
|
||||
|
||||
console.log(`✅ Berita seeded: ${b.judul}`);
|
||||
console.log(`✅ Berita seeded: ${b.judul}`);
|
||||
} catch (error: any) {
|
||||
console.error(
|
||||
`❌ Failed to seed berita "${b.judul}": ${error.message}`,
|
||||
);
|
||||
}
|
||||
}
|
||||
|
||||
console.log("🎉 Berita seed selesai");
|
||||
|
||||
170
prisma/migrations/20260225082505_deploy/migration.sql
Normal file
170
prisma/migrations/20260225082505_deploy/migration.sql
Normal file
@@ -0,0 +1,170 @@
|
||||
/*
|
||||
Warnings:
|
||||
|
||||
- You are about to alter the column `nama` on the `KategoriPotensi` table. The data in that column could be lost. The data in that column will be cast from `Text` to `VarChar(100)`.
|
||||
- You are about to alter the column `name` on the `PotensiDesa` table. The data in that column could be lost. The data in that column will be cast from `Text` to `VarChar(255)`.
|
||||
- You are about to alter the column `kategoriId` on the `PotensiDesa` table. The data in that column could be lost. The data in that column will be cast from `Text` to `VarChar(36)`.
|
||||
- A unique constraint covering the columns `[nama]` on the table `KategoriPotensi` will be added. If there are existing duplicate values, this will fail.
|
||||
- A unique constraint covering the columns `[name]` on the table `PotensiDesa` will be added. If there are existing duplicate values, this will fail.
|
||||
- Made the column `kategoriId` on table `PotensiDesa` required. This step will fail if there are existing NULL values in that column.
|
||||
|
||||
*/
|
||||
-- DropForeignKey
|
||||
ALTER TABLE "DataPerpustakaan" DROP CONSTRAINT "DataPerpustakaan_imageId_fkey";
|
||||
|
||||
-- DropForeignKey
|
||||
ALTER TABLE "DesaDigital" DROP CONSTRAINT "DesaDigital_imageId_fkey";
|
||||
|
||||
-- DropForeignKey
|
||||
ALTER TABLE "InfoTekno" DROP CONSTRAINT "InfoTekno_imageId_fkey";
|
||||
|
||||
-- DropForeignKey
|
||||
ALTER TABLE "KegiatanDesa" DROP CONSTRAINT "KegiatanDesa_imageId_fkey";
|
||||
|
||||
-- DropForeignKey
|
||||
ALTER TABLE "PengaduanMasyarakat" DROP CONSTRAINT "PengaduanMasyarakat_imageId_fkey";
|
||||
|
||||
-- DropForeignKey
|
||||
ALTER TABLE "PotensiDesa" DROP CONSTRAINT "PotensiDesa_kategoriId_fkey";
|
||||
|
||||
-- DropForeignKey
|
||||
ALTER TABLE "ProfileDesaImage" DROP CONSTRAINT "ProfileDesaImage_imageId_fkey";
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "CaraMemperolehInformasi" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "CaraMemperolehSalinanInformasi" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "DaftarInformasiPublik" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "DasarHukumPPID" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "DataPerpustakaan" ALTER COLUMN "imageId" DROP NOT NULL;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "DesaDigital" ALTER COLUMN "imageId" DROP NOT NULL;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "FormulirPermohonanKeberatan" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "InfoTekno" ALTER COLUMN "imageId" DROP NOT NULL;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "JenisInformasiDiminta" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "JenisKelaminResponden" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "KategoriPotensi" ALTER COLUMN "nama" SET DATA TYPE VARCHAR(100),
|
||||
ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "KategoriPrestasiDesa" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "KegiatanDesa" ALTER COLUMN "imageId" DROP NOT NULL;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "LambangDesa" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "MaskotDesa" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "PegawaiPPID" ADD COLUMN "deletedAt" TIMESTAMP(3);
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "PengaduanMasyarakat" ALTER COLUMN "imageId" DROP NOT NULL;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "PermohonanInformasiPublik" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "PilihanRatingResponden" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "PosisiOrganisasiPPID" ADD COLUMN "deletedAt" TIMESTAMP(3);
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "PotensiDesa" ALTER COLUMN "name" SET DATA TYPE VARCHAR(255),
|
||||
ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT,
|
||||
ALTER COLUMN "kategoriId" SET NOT NULL,
|
||||
ALTER COLUMN "kategoriId" SET DATA TYPE VARCHAR(36);
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "PrestasiDesa" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "ProfileDesaImage" ALTER COLUMN "imageId" DROP NOT NULL;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "ProfilePPID" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "Responden" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "SejarahDesa" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "UmurResponden" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "VisiMisiDesa" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- AlterTable
|
||||
ALTER TABLE "VisiMisiPPID" ALTER COLUMN "deletedAt" DROP NOT NULL,
|
||||
ALTER COLUMN "deletedAt" DROP DEFAULT;
|
||||
|
||||
-- CreateIndex
|
||||
CREATE UNIQUE INDEX "KategoriPotensi_nama_key" ON "KategoriPotensi"("nama");
|
||||
|
||||
-- CreateIndex
|
||||
CREATE UNIQUE INDEX "PotensiDesa_name_key" ON "PotensiDesa"("name");
|
||||
|
||||
-- AddForeignKey
|
||||
ALTER TABLE "ProfileDesaImage" ADD CONSTRAINT "ProfileDesaImage_imageId_fkey" FOREIGN KEY ("imageId") REFERENCES "FileStorage"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|
||||
|
||||
-- AddForeignKey
|
||||
ALTER TABLE "PotensiDesa" ADD CONSTRAINT "PotensiDesa_kategoriId_fkey" FOREIGN KEY ("kategoriId") REFERENCES "KategoriPotensi"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
|
||||
|
||||
-- AddForeignKey
|
||||
ALTER TABLE "DesaDigital" ADD CONSTRAINT "DesaDigital_imageId_fkey" FOREIGN KEY ("imageId") REFERENCES "FileStorage"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|
||||
|
||||
-- AddForeignKey
|
||||
ALTER TABLE "InfoTekno" ADD CONSTRAINT "InfoTekno_imageId_fkey" FOREIGN KEY ("imageId") REFERENCES "FileStorage"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|
||||
|
||||
-- AddForeignKey
|
||||
ALTER TABLE "PengaduanMasyarakat" ADD CONSTRAINT "PengaduanMasyarakat_imageId_fkey" FOREIGN KEY ("imageId") REFERENCES "FileStorage"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|
||||
|
||||
-- AddForeignKey
|
||||
ALTER TABLE "KegiatanDesa" ADD CONSTRAINT "KegiatanDesa_imageId_fkey" FOREIGN KEY ("imageId") REFERENCES "FileStorage"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|
||||
|
||||
-- AddForeignKey
|
||||
ALTER TABLE "DataPerpustakaan" ADD CONSTRAINT "DataPerpustakaan_imageId_fkey" FOREIGN KEY ("imageId") REFERENCES "FileStorage"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|
||||
@@ -1,3 +1,3 @@
|
||||
# Please do not edit this file manually
|
||||
# It should be added in your version-control system (e.g., Git)
|
||||
provider = "postgresql"
|
||||
provider = "postgresql"
|
||||
|
||||
@@ -633,25 +633,25 @@ model KategoriBerita {
|
||||
// ========================================= POTENSI DESA ========================================= //
|
||||
model PotensiDesa {
|
||||
id String @id @default(cuid())
|
||||
name String
|
||||
deskripsi String
|
||||
name String @unique @db.VarChar(255)
|
||||
deskripsi String @db.Text
|
||||
kategori KategoriPotensi? @relation(fields: [kategoriId], references: [id])
|
||||
kategoriId String?
|
||||
kategoriId String @db.VarChar(36)
|
||||
image FileStorage? @relation(fields: [imageId], references: [id])
|
||||
imageId String?
|
||||
content String @db.Text
|
||||
createdAt DateTime @default(now())
|
||||
updatedAt DateTime @updatedAt
|
||||
deletedAt DateTime @default(now())
|
||||
deletedAt DateTime?
|
||||
isActive Boolean @default(true)
|
||||
}
|
||||
|
||||
model KategoriPotensi {
|
||||
id String @id @default(cuid())
|
||||
nama String
|
||||
nama String @unique @db.VarChar(100)
|
||||
createdAt DateTime @default(now())
|
||||
updatedAt DateTime @updatedAt
|
||||
deletedAt DateTime @default(now())
|
||||
deletedAt DateTime?
|
||||
isActive Boolean @default(true)
|
||||
PotensiDesa PotensiDesa[]
|
||||
}
|
||||
|
||||
@@ -160,7 +160,7 @@ function ListKategoriBerita({ search }: { search: string }) {
|
||||
))
|
||||
) : (
|
||||
<TableTr>
|
||||
<TableTd colSpan={4}>
|
||||
<TableTd colSpan={3}> {/* ✅ Match column count (3 columns) */}
|
||||
<Center py={24}>
|
||||
<Text c="dimmed" fz="sm" lh={1.4}>
|
||||
Tidak ada data kategori berita yang cocok
|
||||
|
||||
@@ -187,7 +187,7 @@ function ListBerita({ search }: { search: string }) {
|
||||
<Pagination
|
||||
value={page}
|
||||
onChange={(newPage) => {
|
||||
load(newPage, 10);
|
||||
load(newPage, 10, debouncedSearch); // ✅ Include search parameter
|
||||
window.scrollTo({ top: 0, behavior: 'smooth' });
|
||||
}}
|
||||
total={totalPages}
|
||||
|
||||
@@ -8,6 +8,7 @@ import { IconArrowBack, IconEdit, IconTrash } from '@tabler/icons-react';
|
||||
import { useParams, useRouter } from 'next/navigation';
|
||||
import { useState } from 'react';
|
||||
import { useProxy } from 'valtio/utils';
|
||||
import DOMPurify from 'dompurify';
|
||||
|
||||
export default function DetailPotensi() {
|
||||
const router = useRouter();
|
||||
@@ -77,7 +78,17 @@ export default function DetailPotensi() {
|
||||
|
||||
<Box>
|
||||
<Text fz="lg" fw="bold">Deskripsi</Text>
|
||||
<Text fz="md" c="dimmed" style={{ wordBreak: "break-word", whiteSpace: "normal" }} dangerouslySetInnerHTML={{ __html: data.deskripsi || '-' }}></Text>
|
||||
<Text
|
||||
fz="md"
|
||||
c="dimmed"
|
||||
style={{ wordBreak: "break-word", whiteSpace: "normal" }}
|
||||
dangerouslySetInnerHTML={{
|
||||
__html: DOMPurify.sanitize(data.deskripsi || '-', {
|
||||
ALLOWED_TAGS: ['p', 'br', 'strong', 'em', 'u', 'ul', 'ol', 'li'],
|
||||
ALLOWED_ATTR: []
|
||||
})
|
||||
}}
|
||||
></Text>
|
||||
</Box>
|
||||
|
||||
<Box>
|
||||
@@ -102,7 +113,12 @@ export default function DetailPotensi() {
|
||||
<Text
|
||||
fz="md"
|
||||
c="dimmed"
|
||||
dangerouslySetInnerHTML={{ __html: data.content || '-' }}
|
||||
dangerouslySetInnerHTML={{
|
||||
__html: DOMPurify.sanitize(data.content || '-', {
|
||||
ALLOWED_TAGS: ['p', 'br', 'strong', 'em', 'u', 'ul', 'ol', 'li'],
|
||||
ALLOWED_ATTR: []
|
||||
})
|
||||
}}
|
||||
style={{ wordBreak: "break-word", whiteSpace: "normal" }}
|
||||
/>
|
||||
</Box>
|
||||
|
||||
@@ -27,6 +27,7 @@ import { useProxy } from 'valtio/utils';
|
||||
import HeaderSearch from '../../../_com/header';
|
||||
import potensiDesaState from '../../../_state/desa/potensi';
|
||||
import { useDebouncedValue } from '@mantine/hooks';
|
||||
import DOMPurify from 'dompurify';
|
||||
|
||||
function Potensi() {
|
||||
const [search, setSearch] = useState("");
|
||||
@@ -137,7 +138,12 @@ function ListPotensi({ search }: { search: string }) {
|
||||
fz="sm"
|
||||
lh={1.5}
|
||||
lineClamp={2}
|
||||
dangerouslySetInnerHTML={{ __html: item.deskripsi }}
|
||||
dangerouslySetInnerHTML={{
|
||||
__html: DOMPurify.sanitize(item.deskripsi, {
|
||||
ALLOWED_TAGS: ['p', 'br', 'strong', 'em', 'u', 'ul', 'ol', 'li'],
|
||||
ALLOWED_ATTR: []
|
||||
})
|
||||
}}
|
||||
style={{ wordBreak: 'break-word' }}
|
||||
/>
|
||||
</TableTd>
|
||||
@@ -199,7 +205,12 @@ function ListPotensi({ search }: { search: string }) {
|
||||
<Text
|
||||
fz="sm"
|
||||
lh={1.5}
|
||||
dangerouslySetInnerHTML={{ __html: item.deskripsi }}
|
||||
dangerouslySetInnerHTML={{
|
||||
__html: DOMPurify.sanitize(item.deskripsi, {
|
||||
ALLOWED_TAGS: ['p', 'br', 'strong', 'em', 'u', 'ul', 'ol', 'li'],
|
||||
ALLOWED_ATTR: []
|
||||
})
|
||||
}}
|
||||
style={{ wordBreak: 'break-word' }}
|
||||
/>
|
||||
</Box>
|
||||
|
||||
@@ -95,7 +95,7 @@ function Page() {
|
||||
fz={{ base: 'md', md: 'lg' }}
|
||||
lh={{ base: 1.4, md: 1.4 }}
|
||||
>
|
||||
{perbekel.nama || "I.B. Surya Prabhawa Manuaba, S.H., M.H."}
|
||||
I.B. Surya Prabhawa Manuaba, S.H., M.H.
|
||||
</Text>
|
||||
</Paper>
|
||||
</Stack>
|
||||
|
||||
@@ -1,9 +1,9 @@
|
||||
'use client'
|
||||
|
||||
import { authStore } from "@/store/authStore";
|
||||
import { useDarkMode } from "@/state/darkModeStore";
|
||||
import { themeTokens, getActiveStateStyles } from "@/utils/themeTokens";
|
||||
import { DarkModeToggle } from "@/components/admin/DarkModeToggle";
|
||||
import { useDarkMode } from "@/state/darkModeStore";
|
||||
import { authStore } from "@/store/authStore";
|
||||
import { themeTokens } from "@/utils/themeTokens";
|
||||
import {
|
||||
ActionIcon,
|
||||
AppShell,
|
||||
|
||||
@@ -2,15 +2,49 @@ import prisma from "@/lib/prisma";
|
||||
import { Context } from "elysia";
|
||||
|
||||
export default async function kategoriBeritaDelete(context: Context) {
|
||||
const id = context.params.id as string;
|
||||
try {
|
||||
const id = context.params?.id as string;
|
||||
|
||||
await prisma.kategoriBerita.delete({
|
||||
where: { id },
|
||||
});
|
||||
if (!id) {
|
||||
return Response.json({
|
||||
success: false,
|
||||
message: "ID tidak boleh kosong",
|
||||
}, { status: 400 });
|
||||
}
|
||||
|
||||
return {
|
||||
status: 200,
|
||||
success: true,
|
||||
message: "Sukses Menghapus kategori berita",
|
||||
};
|
||||
// ✅ Cek apakah kategori masih digunakan oleh berita
|
||||
const beritaCount = await prisma.berita.count({
|
||||
where: {
|
||||
kategoriBeritaId: id,
|
||||
isActive: true,
|
||||
},
|
||||
});
|
||||
|
||||
if (beritaCount > 0) {
|
||||
return Response.json({
|
||||
success: false,
|
||||
message: `Kategori tidak dapat dihapus karena masih digunakan oleh ${beritaCount} berita`,
|
||||
}, { status: 400 });
|
||||
}
|
||||
|
||||
// ✅ Soft delete (bukan hard delete)
|
||||
await prisma.kategoriBerita.update({
|
||||
where: { id },
|
||||
data: {
|
||||
deletedAt: new Date(),
|
||||
isActive: false,
|
||||
},
|
||||
});
|
||||
|
||||
return {
|
||||
success: true,
|
||||
message: "Kategori berita berhasil dihapus",
|
||||
};
|
||||
} catch (error) {
|
||||
console.error("Delete kategori error:", error);
|
||||
return Response.json({
|
||||
success: false,
|
||||
message: "Gagal menghapus kategori: " + (error instanceof Error ? error.message : 'Unknown error'),
|
||||
}, { status: 500 });
|
||||
}
|
||||
}
|
||||
@@ -21,8 +21,12 @@ export default async function findUnique(
|
||||
}, { status: 400 });
|
||||
}
|
||||
|
||||
const data = await prisma.potensiDesa.findUnique({
|
||||
where: { id },
|
||||
// ✅ Filter by isActive and deletedAt
|
||||
const data = await prisma.potensiDesa.findFirst({
|
||||
where: {
|
||||
id,
|
||||
isActive: true,
|
||||
},
|
||||
include: {
|
||||
image: true,
|
||||
kategori: true
|
||||
@@ -48,5 +52,5 @@ export default async function findUnique(
|
||||
message: "Gagal mengambil potensi desa: " + (error instanceof Error ? error.message : 'Unknown error'),
|
||||
}, { status: 500 });
|
||||
}
|
||||
|
||||
|
||||
}
|
||||
@@ -2,15 +2,49 @@ import prisma from "@/lib/prisma";
|
||||
import { Context } from "elysia";
|
||||
|
||||
export default async function kategoriPotensiDelete(context: Context) {
|
||||
const id = context.params.id as string;
|
||||
try {
|
||||
const id = context.params?.id as string;
|
||||
|
||||
await prisma.kategoriPotensi.delete({
|
||||
where: { id },
|
||||
});
|
||||
if (!id) {
|
||||
return Response.json({
|
||||
success: false,
|
||||
message: "ID tidak boleh kosong",
|
||||
}, { status: 400 });
|
||||
}
|
||||
|
||||
return {
|
||||
status: 200,
|
||||
success: true,
|
||||
message: "Sukses Menghapus kategori potensi",
|
||||
};
|
||||
// ✅ Cek apakah kategori masih digunakan oleh potensi desa
|
||||
const existingPotensi = await prisma.potensiDesa.findFirst({
|
||||
where: {
|
||||
kategoriId: id,
|
||||
isActive: true,
|
||||
},
|
||||
});
|
||||
|
||||
if (existingPotensi) {
|
||||
return Response.json({
|
||||
success: false,
|
||||
message: "Kategori masih digunakan oleh potensi desa. Tidak dapat dihapus.",
|
||||
}, { status: 400 });
|
||||
}
|
||||
|
||||
// Soft delete
|
||||
await prisma.kategoriPotensi.update({
|
||||
where: { id },
|
||||
data: {
|
||||
deletedAt: new Date(),
|
||||
isActive: false,
|
||||
},
|
||||
});
|
||||
|
||||
return {
|
||||
success: true,
|
||||
message: "Kategori potensi berhasil dihapus",
|
||||
};
|
||||
} catch (error) {
|
||||
console.error("Delete kategori error:", error);
|
||||
return Response.json({
|
||||
success: false,
|
||||
message: "Gagal menghapus kategori: " + (error instanceof Error ? error.message : 'Unknown error'),
|
||||
}, { status: 500 });
|
||||
}
|
||||
}
|
||||
@@ -1,10 +1,9 @@
|
||||
import prisma from "@/lib/prisma";
|
||||
import { requireAuth } from "@/lib/api-auth";
|
||||
|
||||
export default async function sejarahDesaFindFirst(request: Request) {
|
||||
export default async function sejarahDesaFindFirst() {
|
||||
// ✅ Authentication check
|
||||
const headers = new Headers(request.url);
|
||||
const authResult = await requireAuth({ headers });
|
||||
const authResult = await requireAuth();
|
||||
if (!authResult.authenticated) {
|
||||
return authResult.response;
|
||||
}
|
||||
@@ -12,9 +11,8 @@ export default async function sejarahDesaFindFirst(request: Request) {
|
||||
try {
|
||||
// Get the first active record
|
||||
const data = await prisma.sejarahDesa.findFirst({
|
||||
where: {
|
||||
where: {
|
||||
isActive: true,
|
||||
deletedAt: null
|
||||
},
|
||||
orderBy: { createdAt: 'asc' } // Get the oldest one first
|
||||
});
|
||||
|
||||
@@ -7,8 +7,8 @@ const SejarahDesa = new Elysia({
|
||||
prefix: "/sejarah",
|
||||
tags: ["Desa/Profile"],
|
||||
})
|
||||
.get("/first", async (context) => {
|
||||
const response = await sejarahDesaFindFirst(new Request(context.request));
|
||||
.get("/first", async () => {
|
||||
const response = await sejarahDesaFindFirst();
|
||||
return response;
|
||||
})
|
||||
.get("/:id", async (context) => {
|
||||
|
||||
@@ -4,7 +4,7 @@ import { Context } from "elysia";
|
||||
|
||||
export default async function sejarahDesaUpdate(context: Context) {
|
||||
// ✅ Authentication check
|
||||
const authResult = await requireAuth(context);
|
||||
const authResult = await requireAuth();
|
||||
if (!authResult.authenticated) {
|
||||
return authResult.response;
|
||||
}
|
||||
|
||||
@@ -46,11 +46,17 @@ fs.mkdir(UPLOAD_DIR_IMAGE, {
|
||||
}).catch(() => {});
|
||||
|
||||
const corsConfig = {
|
||||
origin: "*",
|
||||
methods: ["GET", "POST", "PATCH", "DELETE", "PUT"] as HTTPMethod[],
|
||||
allowedHeaders: "*",
|
||||
origin: [
|
||||
"http://localhost:3000",
|
||||
"http://localhost:3001",
|
||||
"https://cld-dkr-desa-darmasaba-stg.wibudev.com",
|
||||
"https://cld-dkr-staging-desa-darmasaba.wibudev.com",
|
||||
"*", // Allow all origins in development
|
||||
],
|
||||
methods: ["GET", "POST", "PATCH", "DELETE", "PUT", "OPTIONS"] as HTTPMethod[],
|
||||
allowedHeaders: ["Content-Type", "Authorization", "*"],
|
||||
exposedHeaders: "*",
|
||||
maxAge: 5,
|
||||
maxAge: 86400, // 24 hours
|
||||
credentials: true,
|
||||
};
|
||||
|
||||
|
||||
@@ -2,7 +2,7 @@
|
||||
|
||||
import { useDarkMode } from '@/state/darkModeStore';
|
||||
import { themeTokens } from '@/utils/themeTokens';
|
||||
import { Paper, Box, BoxProps, Divider, DividerProps } from '@mantine/core';
|
||||
import { Box, BoxProps, Divider, DividerProps, Paper } from '@mantine/core';
|
||||
import React from 'react';
|
||||
|
||||
/**
|
||||
@@ -22,7 +22,6 @@ import React from 'react';
|
||||
|
||||
// ============================================================================
|
||||
// Unified Card Component
|
||||
* ============================================================================
|
||||
|
||||
interface UnifiedCardProps extends BoxProps {
|
||||
withBorder?: boolean;
|
||||
@@ -63,12 +62,18 @@ export function UnifiedCard({
|
||||
}
|
||||
};
|
||||
|
||||
const getShadow = () => {
|
||||
if (shadow === 'none') return 'none';
|
||||
return tokens.shadows[shadow];
|
||||
};
|
||||
|
||||
return (
|
||||
<Paper
|
||||
withBorder={withBorder}
|
||||
bg={tokens.colors.bg.card}
|
||||
p={getPadding()}
|
||||
radius={tokens.radius.lg} // 12-16px sesuai spec
|
||||
shadow={getShadow()}
|
||||
style={{
|
||||
borderColor: tokens.colors.border.default,
|
||||
transition: hoverable
|
||||
|
||||
@@ -5,6 +5,8 @@ import { themeTokens, getResponsiveFz } from '@/utils/themeTokens';
|
||||
import { Text, Title, Box, BoxProps } from '@mantine/core';
|
||||
import React from 'react';
|
||||
|
||||
type TextTruncate = 'end' | 'start' | boolean;
|
||||
|
||||
/**
|
||||
* Unified Typography Components
|
||||
*
|
||||
@@ -73,7 +75,7 @@ export function UnifiedTitle({
|
||||
const getColor = () => {
|
||||
if (color === 'primary') return tokens.colors.text.primary;
|
||||
if (color === 'secondary') return tokens.colors.text.secondary;
|
||||
if (color === 'brand') return tokens.colors.brand;
|
||||
if (color === 'brand') return tokens.colors.text.brand;
|
||||
return color;
|
||||
};
|
||||
|
||||
@@ -109,8 +111,14 @@ interface UnifiedTextProps {
|
||||
align?: 'left' | 'center' | 'right';
|
||||
color?: 'primary' | 'secondary' | 'tertiary' | 'muted' | 'brand' | 'link' | string;
|
||||
lineClamp?: number;
|
||||
truncate?: 'start' | 'end' | 'middle' | boolean;
|
||||
truncate?: TextTruncate;
|
||||
span?: boolean;
|
||||
mt?: string;
|
||||
mb?: string;
|
||||
ml?: string;
|
||||
mr?: string;
|
||||
mx?: string;
|
||||
my?: string;
|
||||
style?: React.CSSProperties;
|
||||
}
|
||||
|
||||
@@ -123,6 +131,12 @@ export function UnifiedText({
|
||||
lineClamp,
|
||||
truncate,
|
||||
span = false,
|
||||
mt,
|
||||
mb,
|
||||
ml,
|
||||
mr,
|
||||
mx,
|
||||
my,
|
||||
style,
|
||||
}: UnifiedTextProps) {
|
||||
const { isDark } = useDarkMode();
|
||||
@@ -163,7 +177,7 @@ export function UnifiedText({
|
||||
case 'muted':
|
||||
return tokens.colors.text.muted;
|
||||
case 'brand':
|
||||
return tokens.colors.brand;
|
||||
return tokens.colors.text.brand;
|
||||
case 'link':
|
||||
return tokens.colors.text.link;
|
||||
default:
|
||||
@@ -177,7 +191,7 @@ export function UnifiedText({
|
||||
|
||||
if (span) {
|
||||
return (
|
||||
<Text.Span
|
||||
<Text
|
||||
ta={align}
|
||||
fz={typo.fz}
|
||||
fw={fw}
|
||||
@@ -185,10 +199,16 @@ export function UnifiedText({
|
||||
c={textColor}
|
||||
lineClamp={lineClamp}
|
||||
truncate={truncate}
|
||||
mt={mt}
|
||||
mb={mb}
|
||||
ml={ml}
|
||||
mr={mr}
|
||||
mx={mx}
|
||||
my={my}
|
||||
style={style}
|
||||
>
|
||||
{children}
|
||||
</Text.Span>
|
||||
</Text>
|
||||
);
|
||||
}
|
||||
|
||||
@@ -201,6 +221,12 @@ export function UnifiedText({
|
||||
c={textColor}
|
||||
lineClamp={lineClamp}
|
||||
truncate={truncate}
|
||||
mt={mt}
|
||||
mb={mb}
|
||||
ml={ml}
|
||||
mr={mr}
|
||||
mx={mx}
|
||||
my={my}
|
||||
style={style}
|
||||
>
|
||||
{children}
|
||||
|
||||
@@ -1,11 +1,11 @@
|
||||
/**
|
||||
* Authentication helper untuk API endpoints
|
||||
*
|
||||
*
|
||||
* Usage:
|
||||
* import { requireAuth } from "@/lib/api-auth";
|
||||
*
|
||||
* export default async function myEndpoint(context: Context) {
|
||||
* const authResult = await requireAuth(context);
|
||||
*
|
||||
* export default async function myEndpoint() {
|
||||
* const authResult = await requireAuth();
|
||||
* if (!authResult.authenticated) {
|
||||
* return authResult.response;
|
||||
* }
|
||||
@@ -13,24 +13,24 @@
|
||||
* }
|
||||
*/
|
||||
|
||||
import { getSession } from "@/lib/session";
|
||||
import { getSession, SessionData } from "@/lib/session";
|
||||
|
||||
export type AuthResult =
|
||||
| { authenticated: true; user: any }
|
||||
export type AuthResult =
|
||||
| { authenticated: true; user: NonNullable<SessionData["user"]> }
|
||||
| { authenticated: false; response: Response };
|
||||
|
||||
export async function requireAuth(context: any): Promise<AuthResult> {
|
||||
export async function requireAuth(): Promise<AuthResult> {
|
||||
try {
|
||||
// Cek session dari cookies
|
||||
const session = await getSession();
|
||||
|
||||
|
||||
if (!session || !session.user) {
|
||||
return {
|
||||
authenticated: false,
|
||||
response: new Response(JSON.stringify({
|
||||
success: false,
|
||||
message: "Unauthorized - Silakan login terlebih dahulu"
|
||||
}), {
|
||||
}), {
|
||||
status: 401,
|
||||
headers: { 'Content-Type': 'application/json' }
|
||||
})
|
||||
@@ -44,7 +44,7 @@ export async function requireAuth(context: any): Promise<AuthResult> {
|
||||
response: new Response(JSON.stringify({
|
||||
success: false,
|
||||
message: "Akun Anda tidak aktif. Hubungi administrator."
|
||||
}), {
|
||||
}), {
|
||||
status: 403,
|
||||
headers: { 'Content-Type': 'application/json' }
|
||||
})
|
||||
@@ -55,14 +55,13 @@ export async function requireAuth(context: any): Promise<AuthResult> {
|
||||
authenticated: true,
|
||||
user: session.user
|
||||
};
|
||||
} catch (error) {
|
||||
console.error("Auth error:", error);
|
||||
} catch {
|
||||
return {
|
||||
authenticated: false,
|
||||
response: new Response(JSON.stringify({
|
||||
success: false,
|
||||
message: "Authentication error"
|
||||
}), {
|
||||
}), {
|
||||
status: 500,
|
||||
headers: { 'Content-Type': 'application/json' }
|
||||
})
|
||||
@@ -74,11 +73,11 @@ export async function requireAuth(context: any): Promise<AuthResult> {
|
||||
* Optional auth - tidak error jika tidak authenticated
|
||||
* Berguna untuk endpoint yang bisa diakses public atau private
|
||||
*/
|
||||
export async function optionalAuth(context: any): Promise<any> {
|
||||
export async function optionalAuth(): Promise<NonNullable<SessionData["user"]> | null> {
|
||||
try {
|
||||
const session = await getSession();
|
||||
return session?.user || null;
|
||||
} catch (error) {
|
||||
} catch {
|
||||
return null;
|
||||
}
|
||||
}
|
||||
|
||||
@@ -223,6 +223,10 @@ export const themeTokens = (isDark: boolean = false): ThemeTokens => {
|
||||
hoverSoft: 'rgba(25, 113, 194, 0.03)',
|
||||
hoverMedium: 'rgba(25, 113, 194, 0.05)',
|
||||
activeAccent: 'rgba(25, 113, 194, 0.1)',
|
||||
success: '#22c55e',
|
||||
warning: '#facc15',
|
||||
error: '#ef4444',
|
||||
info: '#38bdf8',
|
||||
};
|
||||
|
||||
const current = isDark ? darkColors : lightColors;
|
||||
@@ -381,3 +385,7 @@ export const getActiveStateStyles = (isActive: boolean, isDark: boolean = false)
|
||||
},
|
||||
};
|
||||
};
|
||||
|
||||
|
||||
|
||||
|
||||
|
||||
Reference in New Issue
Block a user