import { PrismaClient } from '@prisma/client'

const prisma = new PrismaClient()

async function main() {
  // Clear all data
  await prisma.monthlyInsight.deleteMany()
  await prisma.expense.deleteMany()
  await prisma.paycheck.deleteMany()
  await prisma.paySchedule.deleteMany()

  // ── Pay schedule ────────────────────────────────────────────────
  // Biweekly $2,850. Anchor on 2026-03-14 (last received paycheck).
  // This projects 2026-03-28 as the upcoming payday this weekend.
  await prisma.paySchedule.create({
    data: {
      amountCents: 285000,
      anchorDate: '2026-03-14',
      active: true,
    },
  })

  // ── February 2026 paychecks ──────────────────────────────────────
  // Biweekly back from 2026-03-14: Feb 14, Feb 28 (same cycle −2 periods, −1 period)
  await prisma.paycheck.createMany({
    data: [
      { payDate: '2026-02-14', amountCents: 285000 },
      { payDate: '2026-02-28', amountCents: 285000 },
    ],
  })

  // ── March 2026 paychecks ─────────────────────────────────────────
  // March 14 received; March 28 is upcoming → covered by projected schedule
  await prisma.paycheck.create({
    data: { payDate: '2026-03-14', amountCents: 285000 },
  })

  // ── February 2026 expenses ───────────────────────────────────────
  await prisma.expense.createMany({
    data: [
      { date: '2026-02-02', title: 'Rent',               amountCents: 243000, category: 'RENT'          },
      { date: '2026-02-04', title: 'Grocery Run',         amountCents:  11500, category: 'FOOD'          },
      { date: '2026-02-07', title: 'Coffee & Snacks',     amountCents:   3200, category: 'FOOD'          },
      { date: '2026-02-09', title: 'Electric Bill',       amountCents:   9200, category: 'BILLS'         },
      { date: '2026-02-09', title: 'Internet',            amountCents:   6500, category: 'BILLS'         },
      { date: '2026-02-11', title: 'Gas Station',         amountCents:   5500, category: 'TRANSPORT'     },
      { date: '2026-02-13', title: 'Pharmacy',            amountCents:   4200, category: 'HEALTH'        },
      { date: '2026-02-15', title: 'Movie Tickets',       amountCents:   2800, category: 'ENTERTAINMENT' },
      { date: '2026-02-17', title: 'Grocery Run',         amountCents:   9800, category: 'FOOD'          },
      { date: '2026-02-19', title: 'Gym Membership',      amountCents:   5000, category: 'HEALTH'        },
      { date: '2026-02-21', title: 'Dinner Out',          amountCents:   6800, category: 'FOOD'          },
      { date: '2026-02-22', title: 'New Jeans',           amountCents:  12000, category: 'SHOPPING'      },
      { date: '2026-02-24', title: 'Rideshare',           amountCents:   2200, category: 'TRANSPORT'     },
      { date: '2026-02-26', title: 'Phone Bill',          amountCents:   6500, category: 'BILLS'         },
      { date: '2026-02-28', title: 'Misc Supplies',       amountCents:   1800, category: 'MISC'          },
    ],
  })

  // ── March 2026 expenses (through March 23 — month is ongoing) ───
  await prisma.expense.createMany({
    data: [
      { date: '2026-03-02', title: 'Rent',               amountCents: 243000, category: 'RENT'          },
      { date: '2026-03-04', title: 'Grocery Run',         amountCents:  10800, category: 'FOOD'          },
      { date: '2026-03-06', title: 'Coffee & Snacks',     amountCents:   2900, category: 'FOOD'          },
      { date: '2026-03-08', title: 'Gas Station',         amountCents:   6000, category: 'TRANSPORT'     },
      { date: '2026-03-09', title: 'Electric Bill',       amountCents:   8800, category: 'BILLS'         },
      { date: '2026-03-11', title: 'Streaming Services',  amountCents:   5500, category: 'BILLS'         },
      { date: '2026-03-12', title: 'Lunch Out',           amountCents:   4500, category: 'FOOD'          },
      { date: '2026-03-14', title: 'Pharmacy',            amountCents:   3500, category: 'HEALTH'        },
      { date: '2026-03-16', title: 'Grocery Run',         amountCents:   9500, category: 'FOOD'          },
      { date: '2026-03-17', title: 'Cinema',              amountCents:   3200, category: 'ENTERTAINMENT' },
      { date: '2026-03-19', title: 'Clothing Online',     amountCents:   7500, category: 'SHOPPING'      },
      { date: '2026-03-20', title: 'Phone Bill',          amountCents:   6500, category: 'BILLS'         },
      { date: '2026-03-21', title: 'Rideshare',           amountCents:   1800, category: 'TRANSPORT'     },
      { date: '2026-03-23', title: 'Dinner Out',          amountCents:   5500, category: 'FOOD'          },
    ],
  })

  console.log('✓ Cleared old data')
  console.log('✓ Pay schedule: biweekly $2,850 (anchor 2026-03-14, next: 2026-03-28)')
  console.log('✓ Paychecks: Feb 14, Feb 28, Mar 14 → Mar 28 projected')
  console.log('✓ Expenses: Feb 2026 (15 items) + Mar 2026 (14 items, through Mar 23)')
}

main()
  .catch(console.error)
  .finally(() => prisma.$disconnect())