import { NextRequest, NextResponse } from 'next/server';
import { getDb } from '@/lib/db';
import { PaperType } from '@/types';

export async function GET(req: NextRequest) {
  try {
    const db = getDb();
    const { searchParams } = new URL(req.url);
    const supplier = searchParams.get('supplier');
    const q = searchParams.get('q');

    let query = 'SELECT * FROM paper_types WHERE 1=1';
    const params: unknown[] = [];

    if (supplier && supplier !== 'all') {
      query += ' AND supplier = ?';
      params.push(supplier);
    }
    if (q) {
      query += ' AND (name LIKE ? OR code LIKE ? OR description LIKE ?)';
      const term = `%${q}%`;
      params.push(term, term, term);
    }

    query += ' ORDER BY is_active DESC, supplier ASC, name ASC, gsm ASC';

    const rows = db.prepare(query).all(...params) as Record<string, unknown>[];
    const papers: PaperType[] = rows.map((r) => {
      const pAbove = Number(r.price_above_500) || Number(r.price_per_ram) || 0;
      const pBelow = Number(r.price_below_500) || pAbove;
      return {
        id: r.id as number,
        code: r.code as string,
        name: r.name as string,
        gsm: r.gsm as number,
        parentWidthCm: r.parent_width_cm as number,
        parentHeightCm: r.parent_height_cm as number,
        priceAbove500: pAbove,
        priceBelow500: pBelow,
        pricePerRam: pAbove,
        pricePerKg: 0,
        supplier: (r.supplier as string) || 'Thuận Phát',
        unit: 'ram',
        description: (r.description as string) || '',
        isActive: Boolean(r.is_active),
      };
    });
    return NextResponse.json(papers);
  } catch (err: unknown) {
    return NextResponse.json({ error: (err as Error).message }, { status: 500 });
  }
}

export async function POST(req: NextRequest) {
  try {
    const body = await req.json();
    const db = getDb();

    const pAbove = Number(body.priceAbove500 ?? body.pricePerRam) || 0;
    const pBelow = Number(body.priceBelow500) || pAbove;

    const stmt = db.prepare(`
      INSERT INTO paper_types (code, name, gsm, parent_width_cm, parent_height_cm, price_above_500, price_below_500, price_per_ram, price_per_kg, supplier, unit, description, is_active)
      VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    `);

    const result = stmt.run(
      body.code,
      body.name,
      body.gsm,
      body.parentWidthCm,
      body.parentHeightCm,
      pAbove,
      pBelow,
      pAbove,
      0,
      body.supplier || 'Thuận Phát',
      'ram',
      body.description || '',
      body.isActive !== false ? 1 : 0
    );

    return NextResponse.json({ success: true, id: Number(result.lastInsertRowid) });
  } 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();
    const db = getDb();

    const pAbove = Number(body.priceAbove500 ?? body.pricePerRam) || 0;
    const pBelow = Number(body.priceBelow500) || pAbove;

    const stmt = db.prepare(`
      UPDATE paper_types
      SET name = ?, gsm = ?, parent_width_cm = ?, parent_height_cm = ?, price_above_500 = ?, price_below_500 = ?, price_per_ram = ?, price_per_kg = 0, supplier = ?, unit = 'ram', description = ?, is_active = ?, updated_at = CURRENT_TIMESTAMP
      WHERE id = ?
    `);

    stmt.run(
      body.name,
      body.gsm,
      body.parentWidthCm,
      body.parentHeightCm,
      pAbove,
      pBelow,
      pAbove,
      body.supplier || 'Thuận Phát',
      body.description || '',
      body.isActive ? 1 : 0,
      body.id
    );

    return NextResponse.json({ success: true });
  } catch (err: unknown) {
    return NextResponse.json({ error: (err as Error).message }, { status: 500 });
  }
}

export async function DELETE(req: NextRequest) {
  try {
    const { searchParams } = new URL(req.url);
    const id = searchParams.get('id');
    if (!id) return NextResponse.json({ error: 'Thiếu ID giấy' }, { status: 400 });

    const db = getDb();
    db.prepare('DELETE FROM paper_types WHERE id = ?').run(Number(id));
    return NextResponse.json({ success: true });
  } catch (err: unknown) {
    return NextResponse.json({ error: (err as Error).message }, { status: 500 });
  }
}