Spaces:

simikkk
/

test7

Runtime error

Upload 86 files

e218aaf verified 4 months ago

10.6 kB

import { db } from '@/lib/db';
import { hashPassword, generateApiKey } from '@/lib/auth';
import { NextResponse } from 'next/server';

export async function GET() {
  try {
    // Upsert demo user
    const hashedPw = await hashPassword('demo1234');
    const apiKey = generateApiKey();

    const user = await db.user.upsert({
      where: { email: 'demo@omniparse.ai' },
      update: {},
      create: {
        email: 'demo@omniparse.ai',
        name: 'Demo User',
        password: hashedPw,
        plan: 'pro',
        apiKey,
      },
    });

    // Delete any existing invoices for this user
    await db.invoice.deleteMany({
      where: { userId: user.id },
    });

    // Define 20 diverse invoices
    const invoiceData = [
      // ── January 2025 (5 invoices) ──
      {
        vendor: 'Acme Corp',
        invNumber: 'INV-2024-001',
        invDate: '2025-01-05',
        dueDate: '2025-02-04',
        amount: 1200,
        vatPct: 0.20,
        currency: 'USD',
        status: 'done' as const,
        isDuplicate: false,
        confidence: 0.95,
        filename: 'invoice_acme_jan.pdf',
        createdAt: new Date('2025-01-06T09:15:00Z'),
      },
      {
        vendor: 'TechVision Inc',
        invNumber: 'INV-2024-002',
        invDate: '2025-01-12',
        dueDate: '2025-02-11',
        amount: 3450,
        vatPct: 0.21,
        currency: 'EUR',
        status: 'done' as const,
        isDuplicate: false,
        confidence: 0.97,
        filename: 'invoice_techvision_jan.pdf',
        createdAt: new Date('2025-01-13T14:30:00Z'),
      },
      {
        vendor: 'Global Supplies Ltd',
        invNumber: 'INV-2024-003',
        invDate: '2025-01-18',
        dueDate: '2025-02-17',
        amount: 890,
        vatPct: 0.15,
        currency: 'USD',
        status: 'done' as const,
        isDuplicate: false,
        confidence: 0.92,
        filename: 'receipt_global_jan.png',
        createdAt: new Date('2025-01-19T11:00:00Z'),
      },
      {
        vendor: 'CloudNine Services',
        invNumber: 'INV-2024-004',
        invDate: '2025-01-22',
        dueDate: '2025-02-21',
        amount: 5200,
        vatPct: 0.20,
        currency: 'USD',
        status: 'review' as const,
        isDuplicate: false,
        confidence: 0.88,
        filename: 'invoice_cloudnine_jan.pdf',
        createdAt: new Date('2025-01-23T08:45:00Z'),
      },
      {
        vendor: 'DataFlow Systems',
        invNumber: 'INV-2024-005',
        invDate: '2025-01-28',
        dueDate: '2025-02-27',
        amount: 750,
        vatPct: 0.10,
        currency: 'USD',
        status: 'done' as const,
        isDuplicate: false,
        confidence: 0.96,
        filename: 'receipt_dataflow_jan.pdf',
        createdAt: new Date('2025-01-29T16:20:00Z'),
      },

      // ── February 2025 (5 invoices) ──
      {
        vendor: 'Pinnacle Solutions',
        invNumber: 'INV-2024-006',
        invDate: '2025-02-03',
        dueDate: '2025-03-05',
        amount: 1250,
        vatPct: 0.18,
        currency: 'USD',
        status: 'done' as const,
        isDuplicate: false,
        confidence: 0.94,
        filename: 'invoice_pinnacle_feb.pdf',
        createdAt: new Date('2025-02-04T10:00:00Z'),
      },
      {
        vendor: 'TechVision Inc',
        invNumber: 'INV-2024-007',
        invDate: '2025-02-08',
        dueDate: '2025-03-10',
        amount: 2100,
        vatPct: 0.20,
        currency: 'USD',
        status: 'done' as const,
        isDuplicate: false,
        confidence: 0.98,
        filename: 'invoice_techvision_feb.pdf',
        createdAt: new Date('2025-02-09T13:15:00Z'),
      },
      {
        vendor: 'Acme Corp',
        invNumber: 'INV-2024-008',
        invDate: '2025-02-14',
        dueDate: '2025-03-16',
        amount: 8750,
        vatPct: 0.20,
        currency: 'GBP',
        status: 'review' as const,
        isDuplicate: false,
        confidence: 0.87,
        filename: 'invoice_acme_feb.pdf',
        createdAt: new Date('2025-02-15T09:30:00Z'),
      },
      {
        vendor: 'Meridian Group',
        invNumber: 'INV-2024-009',
        invDate: '2025-02-20',
        dueDate: '2025-03-22',
        amount: 430,
        vatPct: 0.12,
        currency: 'USD',
        status: 'pending' as const,
        isDuplicate: false,
        confidence: 0.99,
        filename: 'receipt_meridian_feb.png',
        createdAt: new Date('2025-02-21T15:45:00Z'),
      },
      {
        vendor: 'Nexus Technologies',
        invNumber: 'INV-2024-010',
        invDate: '2025-02-26',
        dueDate: '2025-03-28',
        amount: 6300,
        vatPct: 0.25,
        currency: 'USD',
        status: 'done' as const,
        isDuplicate: false,
        confidence: 0.91,
        filename: 'invoice_nexus_feb.pdf',
        createdAt: new Date('2025-02-27T11:10:00Z'),
      },

      // ── March 2025 (5 invoices) ──
      {
        vendor: 'CloudNine Services',
        invNumber: 'INV-2024-011',
        invDate: '2025-03-04',
        dueDate: '2025-04-03',
        amount: 4800,
        vatPct: 0.20,
        currency: 'USD',
        status: 'done' as const,
        isDuplicate: false,
        confidence: 0.93,
        filename: 'invoice_cloudnine_mar.pdf',
        createdAt: new Date('2025-03-05T08:00:00Z'),
      },
      {
        vendor: 'Pinnacle Solutions',
        invNumber: 'INV-2024-012',
        invDate: '2025-03-10',
        dueDate: '2025-04-09',
        amount: 15000,
        vatPct: 0.22,
        currency: 'USD',
        status: 'review' as const,
        isDuplicate: false,
        confidence: 0.86,
        filename: 'invoice_pinnacle_mar.pdf',
        createdAt: new Date('2025-03-11T14:25:00Z'),
      },
      {
        vendor: 'Global Supplies Ltd',
        invNumber: 'INV-2024-013',
        invDate: '2025-03-15',
        dueDate: '2025-04-14',
        amount: 2350,
        vatPct: 0.19,
        currency: 'EUR',
        status: 'done' as const,
        isDuplicate: false,
        confidence: 0.95,
        filename: 'invoice_global_mar.pdf',
        createdAt: new Date('2025-03-16T10:40:00Z'),
      },
      {
        vendor: 'DataFlow Systems',
        invNumber: 'INV-2024-014',
        invDate: '2025-03-19',
        dueDate: '2025-04-18',
        amount: 1100,
        vatPct: 0.15,
        currency: 'USD',
        status: 'done' as const,
        isDuplicate: false,
        confidence: 0.97,
        filename: 'receipt_dataflow_mar.png',
        createdAt: new Date('2025-03-20T09:55:00Z'),
      },
      {
        vendor: 'Acme Corp',
        invNumber: 'INV-2024-015',
        invDate: '2025-03-25',
        dueDate: '2025-04-24',
        amount: 9200,
        vatPct: 0.20,
        currency: 'USD',
        status: 'done' as const,
        isDuplicate: false,
        confidence: 0.89,
        filename: 'invoice_acme_mar.pdf',
        createdAt: new Date('2025-03-26T16:30:00Z'),
      },

      // ── April 2025 (5 invoices) ──
      {
        vendor: 'Nexus Technologies',
        invNumber: 'INV-2024-016',
        invDate: '2025-04-02',
        dueDate: '2025-05-02',
        amount: 6280,
        vatPct: 0.23,
        currency: 'USD',
        status: 'done' as const,
        isDuplicate: true, // Duplicate of INV-2024-010 (same vendor, $6300)
        confidence: 0.88,
        filename: 'invoice_nexus_apr.pdf',
        createdAt: new Date('2025-04-03T11:20:00Z'),
      },
      {
        vendor: 'Meridian Group',
        invNumber: 'INV-2024-017',
        invDate: '2025-04-08',
        dueDate: '2025-05-08',
        amount: 780,
        vatPct: 0.14,
        currency: 'EUR',
        status: 'pending' as const,
        isDuplicate: false,
        confidence: 0.96,
        filename: 'receipt_meridian_apr.png',
        createdAt: new Date('2025-04-09T08:10:00Z'),
      },
      {
        vendor: 'CloudNine Services',
        invNumber: 'INV-2024-018',
        invDate: '2025-04-14',
        dueDate: '2025-05-14',
        amount: 5150,
        vatPct: 0.20,
        currency: 'USD',
        status: 'done' as const,
        isDuplicate: true, // Duplicate of INV-2024-004 (same vendor, $5200)
        confidence: 0.92,
        filename: 'invoice_cloudnine_apr.pdf',
        createdAt: new Date('2025-04-15T13:50:00Z'),
      },
      {
        vendor: 'Pinnacle Solutions',
        invNumber: 'INV-2024-019',
        invDate: '2025-04-20',
        dueDate: '2025-05-20',
        amount: 3200,
        vatPct: 0.20,
        currency: 'GBP',
        status: 'done' as const,
        isDuplicate: false,
        confidence: 0.94,
        filename: 'invoice_pinnacle_apr.pdf',
        createdAt: new Date('2025-04-21T10:05:00Z'),
      },
      {
        vendor: 'TechVision Inc',
        invNumber: 'INV-2024-020',
        invDate: '2025-04-27',
        dueDate: '2025-05-27',
        amount: 2800,
        vatPct: 0.17,
        currency: 'USD',
        status: 'review' as const,
        isDuplicate: false,
        confidence: 0.85,
        filename: 'invoice_techvision_apr.pdf',
        createdAt: new Date('2025-04-28T15:00:00Z'),
      },
    ];

    // Create all invoices with computed VAT and total
    const invoices = await db.invoice.createMany({
      data: invoiceData.map((inv) => ({
        userId: user.id,
        vendor: inv.vendor,
        invNumber: inv.invNumber,
        invDate: inv.invDate,
        dueDate: inv.dueDate,
        amount: inv.amount,
        vatAmount: Math.round(inv.amount * inv.vatPct * 100) / 100,
        total: Math.round(inv.amount * (1 + inv.vatPct) * 100) / 100,
        currency: inv.currency,
        status: inv.status,
        isDuplicate: inv.isDuplicate,
        confidence: inv.confidence,
        filename: inv.filename,
        rawJson: null,
        createdAt: inv.createdAt,
      })),
    });

    return NextResponse.json({
      message: `Seed complete: ${invoices.count} invoices created for demo user`,
      userId: user.id,
      invoiceCount: invoices.count,
      breakdown: {
        byVendor: {
          'Acme Corp': 3,
          'TechVision Inc': 3,
          'Global Supplies Ltd': 2,
          'CloudNine Services': 3,
          'DataFlow Systems': 2,
          'Pinnacle Solutions': 3,
          'Meridian Group': 2,
          'Nexus Technologies': 2,
        },
        byStatus: { done: 14, review: 4, pending: 2 },
        duplicates: 2,
        byCurrency: { USD: 15, EUR: 3, GBP: 2 },
      },
    });
  } catch (error) {
    console.error('[SEED_ERROR]', error);
    return NextResponse.json({ error: 'Seed failed' }, { status: 500 });
  }
}

	import { db } from '@/lib/db';
	import { hashPassword, generateApiKey } from '@/lib/auth';
	import { NextResponse } from 'next/server';

	export async function GET() {
	try {
	// Upsert demo user
	const hashedPw = await hashPassword('demo1234');
	const apiKey = generateApiKey();

	const user = await db.user.upsert({
	where: { email: 'demo@omniparse.ai' },
	update: {},
	create: {
	email: 'demo@omniparse.ai',
	name: 'Demo User',
	password: hashedPw,
	plan: 'pro',
	apiKey,
	},
	});

	// Delete any existing invoices for this user
	await db.invoice.deleteMany({
	where: { userId: user.id },
	});

	// Define 20 diverse invoices
	const invoiceData = [
	// ── January 2025 (5 invoices) ──
	{
	vendor: 'Acme Corp',
	invNumber: 'INV-2024-001',
	invDate: '2025-01-05',
	dueDate: '2025-02-04',
	amount: 1200,
	vatPct: 0.20,
	currency: 'USD',
	status: 'done' as const,
	isDuplicate: false,
	confidence: 0.95,
	filename: 'invoice_acme_jan.pdf',
	createdAt: new Date('2025-01-06T09:15:00Z'),
	},
	{
	vendor: 'TechVision Inc',
	invNumber: 'INV-2024-002',
	invDate: '2025-01-12',
	dueDate: '2025-02-11',
	amount: 3450,
	vatPct: 0.21,
	currency: 'EUR',
	status: 'done' as const,
	isDuplicate: false,
	confidence: 0.97,
	filename: 'invoice_techvision_jan.pdf',
	createdAt: new Date('2025-01-13T14:30:00Z'),
	},
	{
	vendor: 'Global Supplies Ltd',
	invNumber: 'INV-2024-003',
	invDate: '2025-01-18',
	dueDate: '2025-02-17',
	amount: 890,
	vatPct: 0.15,
	currency: 'USD',
	status: 'done' as const,
	isDuplicate: false,
	confidence: 0.92,
	filename: 'receipt_global_jan.png',
	createdAt: new Date('2025-01-19T11:00:00Z'),
	},
	{
	vendor: 'CloudNine Services',
	invNumber: 'INV-2024-004',
	invDate: '2025-01-22',
	dueDate: '2025-02-21',
	amount: 5200,
	vatPct: 0.20,
	currency: 'USD',
	status: 'review' as const,
	isDuplicate: false,
	confidence: 0.88,
	filename: 'invoice_cloudnine_jan.pdf',
	createdAt: new Date('2025-01-23T08:45:00Z'),
	},
	{
	vendor: 'DataFlow Systems',
	invNumber: 'INV-2024-005',
	invDate: '2025-01-28',
	dueDate: '2025-02-27',
	amount: 750,
	vatPct: 0.10,
	currency: 'USD',
	status: 'done' as const,
	isDuplicate: false,
	confidence: 0.96,
	filename: 'receipt_dataflow_jan.pdf',
	createdAt: new Date('2025-01-29T16:20:00Z'),
	},

	// ── February 2025 (5 invoices) ──
	{
	vendor: 'Pinnacle Solutions',
	invNumber: 'INV-2024-006',
	invDate: '2025-02-03',
	dueDate: '2025-03-05',
	amount: 1250,
	vatPct: 0.18,
	currency: 'USD',
	status: 'done' as const,
	isDuplicate: false,
	confidence: 0.94,
	filename: 'invoice_pinnacle_feb.pdf',
	createdAt: new Date('2025-02-04T10:00:00Z'),
	},
	{
	vendor: 'TechVision Inc',
	invNumber: 'INV-2024-007',
	invDate: '2025-02-08',
	dueDate: '2025-03-10',
	amount: 2100,
	vatPct: 0.20,
	currency: 'USD',
	status: 'done' as const,
	isDuplicate: false,
	confidence: 0.98,
	filename: 'invoice_techvision_feb.pdf',
	createdAt: new Date('2025-02-09T13:15:00Z'),
	},
	{
	vendor: 'Acme Corp',
	invNumber: 'INV-2024-008',
	invDate: '2025-02-14',
	dueDate: '2025-03-16',
	amount: 8750,
	vatPct: 0.20,
	currency: 'GBP',
	status: 'review' as const,
	isDuplicate: false,
	confidence: 0.87,
	filename: 'invoice_acme_feb.pdf',
	createdAt: new Date('2025-02-15T09:30:00Z'),
	},
	{
	vendor: 'Meridian Group',
	invNumber: 'INV-2024-009',
	invDate: '2025-02-20',
	dueDate: '2025-03-22',
	amount: 430,
	vatPct: 0.12,
	currency: 'USD',
	status: 'pending' as const,
	isDuplicate: false,
	confidence: 0.99,
	filename: 'receipt_meridian_feb.png',
	createdAt: new Date('2025-02-21T15:45:00Z'),
	},
	{
	vendor: 'Nexus Technologies',
	invNumber: 'INV-2024-010',
	invDate: '2025-02-26',
	dueDate: '2025-03-28',
	amount: 6300,
	vatPct: 0.25,
	currency: 'USD',
	status: 'done' as const,
	isDuplicate: false,
	confidence: 0.91,
	filename: 'invoice_nexus_feb.pdf',
	createdAt: new Date('2025-02-27T11:10:00Z'),
	},

	// ── March 2025 (5 invoices) ──
	{
	vendor: 'CloudNine Services',
	invNumber: 'INV-2024-011',
	invDate: '2025-03-04',
	dueDate: '2025-04-03',
	amount: 4800,
	vatPct: 0.20,
	currency: 'USD',
	status: 'done' as const,
	isDuplicate: false,
	confidence: 0.93,
	filename: 'invoice_cloudnine_mar.pdf',
	createdAt: new Date('2025-03-05T08:00:00Z'),
	},
	{
	vendor: 'Pinnacle Solutions',
	invNumber: 'INV-2024-012',
	invDate: '2025-03-10',
	dueDate: '2025-04-09',
	amount: 15000,
	vatPct: 0.22,
	currency: 'USD',
	status: 'review' as const,
	isDuplicate: false,
	confidence: 0.86,
	filename: 'invoice_pinnacle_mar.pdf',
	createdAt: new Date('2025-03-11T14:25:00Z'),
	},
	{
	vendor: 'Global Supplies Ltd',
	invNumber: 'INV-2024-013',
	invDate: '2025-03-15',
	dueDate: '2025-04-14',
	amount: 2350,
	vatPct: 0.19,
	currency: 'EUR',
	status: 'done' as const,
	isDuplicate: false,
	confidence: 0.95,
	filename: 'invoice_global_mar.pdf',
	createdAt: new Date('2025-03-16T10:40:00Z'),
	},
	{
	vendor: 'DataFlow Systems',
	invNumber: 'INV-2024-014',
	invDate: '2025-03-19',
	dueDate: '2025-04-18',
	amount: 1100,
	vatPct: 0.15,
	currency: 'USD',
	status: 'done' as const,
	isDuplicate: false,
	confidence: 0.97,
	filename: 'receipt_dataflow_mar.png',
	createdAt: new Date('2025-03-20T09:55:00Z'),
	},
	{
	vendor: 'Acme Corp',
	invNumber: 'INV-2024-015',
	invDate: '2025-03-25',
	dueDate: '2025-04-24',
	amount: 9200,
	vatPct: 0.20,
	currency: 'USD',
	status: 'done' as const,
	isDuplicate: false,
	confidence: 0.89,
	filename: 'invoice_acme_mar.pdf',
	createdAt: new Date('2025-03-26T16:30:00Z'),
	},

	// ── April 2025 (5 invoices) ──
	{
	vendor: 'Nexus Technologies',
	invNumber: 'INV-2024-016',
	invDate: '2025-04-02',
	dueDate: '2025-05-02',
	amount: 6280,
	vatPct: 0.23,
	currency: 'USD',
	status: 'done' as const,
	isDuplicate: true, // Duplicate of INV-2024-010 (same vendor, $6300)
	confidence: 0.88,
	filename: 'invoice_nexus_apr.pdf',
	createdAt: new Date('2025-04-03T11:20:00Z'),
	},
	{
	vendor: 'Meridian Group',
	invNumber: 'INV-2024-017',
	invDate: '2025-04-08',
	dueDate: '2025-05-08',
	amount: 780,
	vatPct: 0.14,
	currency: 'EUR',
	status: 'pending' as const,
	isDuplicate: false,
	confidence: 0.96,
	filename: 'receipt_meridian_apr.png',
	createdAt: new Date('2025-04-09T08:10:00Z'),
	},
	{
	vendor: 'CloudNine Services',
	invNumber: 'INV-2024-018',
	invDate: '2025-04-14',
	dueDate: '2025-05-14',
	amount: 5150,
	vatPct: 0.20,
	currency: 'USD',
	status: 'done' as const,
	isDuplicate: true, // Duplicate of INV-2024-004 (same vendor, $5200)
	confidence: 0.92,
	filename: 'invoice_cloudnine_apr.pdf',
	createdAt: new Date('2025-04-15T13:50:00Z'),
	},
	{
	vendor: 'Pinnacle Solutions',
	invNumber: 'INV-2024-019',
	invDate: '2025-04-20',
	dueDate: '2025-05-20',
	amount: 3200,
	vatPct: 0.20,
	currency: 'GBP',
	status: 'done' as const,
	isDuplicate: false,
	confidence: 0.94,
	filename: 'invoice_pinnacle_apr.pdf',
	createdAt: new Date('2025-04-21T10:05:00Z'),
	},
	{
	vendor: 'TechVision Inc',
	invNumber: 'INV-2024-020',
	invDate: '2025-04-27',
	dueDate: '2025-05-27',
	amount: 2800,
	vatPct: 0.17,
	currency: 'USD',
	status: 'review' as const,
	isDuplicate: false,
	confidence: 0.85,
	filename: 'invoice_techvision_apr.pdf',
	createdAt: new Date('2025-04-28T15:00:00Z'),
	},
	];

	// Create all invoices with computed VAT and total
	const invoices = await db.invoice.createMany({
	data: invoiceData.map((inv) => ({
	userId: user.id,
	vendor: inv.vendor,
	invNumber: inv.invNumber,
	invDate: inv.invDate,
	dueDate: inv.dueDate,
	amount: inv.amount,
	vatAmount: Math.round(inv.amount * inv.vatPct * 100) / 100,
	total: Math.round(inv.amount * (1 + inv.vatPct) * 100) / 100,
	currency: inv.currency,
	status: inv.status,
	isDuplicate: inv.isDuplicate,
	confidence: inv.confidence,
	filename: inv.filename,
	rawJson: null,
	createdAt: inv.createdAt,
	})),
	});

	return NextResponse.json({
	message: `Seed complete: ${invoices.count} invoices created for demo user`,
	userId: user.id,
	invoiceCount: invoices.count,
	breakdown: {
	byVendor: {
	'Acme Corp': 3,
	'TechVision Inc': 3,
	'Global Supplies Ltd': 2,
	'CloudNine Services': 3,
	'DataFlow Systems': 2,
	'Pinnacle Solutions': 3,
	'Meridian Group': 2,
	'Nexus Technologies': 2,
	},
	byStatus: { done: 14, review: 4, pending: 2 },
	duplicates: 2,
	byCurrency: { USD: 15, EUR: 3, GBP: 2 },
	},
	});
	} catch (error) {
	console.error('[SEED_ERROR]', error);
	return NextResponse.json({ error: 'Seed failed' }, { status: 500 });
	}
	}