File size: 2,391 Bytes
0a5bd33 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 | import { NextRequest, NextResponse } from 'next/server';
import { getDb } from '@/lib/db';
import { SystemSetting } from '@/types';
export async function GET() {
try {
const db = getDb();
const rows = db.prepare('SELECT key, value FROM system_settings').all() as { key: string; value: string }[];
const map: Record<string, string> = {};
for (const r of rows) {
map[r.key] = r.value;
}
const settings: SystemSetting = {
companyName: map.companyName || 'XƯỞNG IN ẤN PRINTCAL',
companyAddress: map.companyAddress || '',
companyPhone: map.companyPhone || '',
companyEmail: map.companyEmail || '',
bankAccount: map.bankAccount || '',
bankName: map.bankName || '',
quoteFooterNote: map.quoteFooterNote || '',
defaultProfitMargin: Number(map.defaultProfitMargin) || 25,
defaultVatPercent: Number(map.defaultVatPercent) || 8,
};
return NextResponse.json(settings);
} catch (err: unknown) {
return NextResponse.json({ error: (err as Error).message }, { status: 500 });
}
}
export async function PUT(req: NextRequest) {
try {
const body = (await req.json()) as Partial<SystemSetting>;
const db = getDb();
const upsert = db.prepare(`
INSERT INTO system_settings (key, value)
VALUES (?, ?)
ON CONFLICT(key) DO UPDATE SET value = excluded.value
`);
if (body.companyName !== undefined) upsert.run('companyName', body.companyName);
if (body.companyAddress !== undefined) upsert.run('companyAddress', body.companyAddress);
if (body.companyPhone !== undefined) upsert.run('companyPhone', body.companyPhone);
if (body.companyEmail !== undefined) upsert.run('companyEmail', body.companyEmail);
if (body.bankAccount !== undefined) upsert.run('bankAccount', body.bankAccount);
if (body.bankName !== undefined) upsert.run('bankName', body.bankName);
if (body.quoteFooterNote !== undefined) upsert.run('quoteFooterNote', body.quoteFooterNote);
if (body.defaultProfitMargin !== undefined) upsert.run('defaultProfitMargin', String(body.defaultProfitMargin));
if (body.defaultVatPercent !== undefined) upsert.run('defaultVatPercent', String(body.defaultVatPercent));
return NextResponse.json({ success: true });
} catch (err: unknown) {
return NextResponse.json({ error: (err as Error).message }, { status: 500 });
}
}
|