#!/usr/bin/env node
/**
 * Creates the user's quote exactly as shown in the screenshot.
 *
 *   Customer    : JENTRADEPRO
 *   Quote #     : QT-20260914-001
 *   Customer Ref: RFQ;JEI MAGNETIC DRILLING MACHINE PARTS
 *   Quote Date  : 2026-09-14
 *   Valid Until : 2026-10-14
 *   Status      : Draft
 *
 *   Items:
 *     1. PRO132T-B27 - PANEL CONTROL PCB ASSY 110V (BB1)  qty 1  R 5518.88
 *     2. PRO132T-C24 - CARBON BRUSH EACH, PRO152T        qty 2  R 438.22
 *     3. 35708 - MAGNET SWITCH                            qty 1  R 485.40
 */
import PocketBase from "pocketbase";

const PB_URL = "https://pb.jeistk.apphub.co.za";
const PB_EMAIL = "david@wfsales.co.za";
const PB_PASSWORD = "1234567890";

const pb = new PocketBase(PB_URL);
pb.autoCancellation(false);
await pb.admins.authWithPassword(PB_EMAIL, PB_PASSWORD);

const CUSTOMER_ID  = "dgv6gxgcj2f2o14";
const QUOTE_NUMBER = "QT-20260914-001";

const items = [
  { id: "oz9zgj5xp72m77s", sku: "PRO132T-B27", qty: 1, price: 5518.88 },
  { id: "gfcfv9mkveq95co", sku: "PRO132T-C24", qty: 2, price: 438.22 },
  { id: "9lfcwus2w5w9h84", sku: "35708",       qty: 1, price: 485.40 },
];

// Clean any prior attempt
try {
  const dup = await pb.collection("quotes").getFirstListItem(`quote_number = "${QUOTE_NUMBER}"`);
  await pb.collection("quotes").delete(dup.id);
  console.log(`Removed previous attempt ${dup.id}`);
} catch {
  /* no duplicate */
}

// Create the quote — `items` is a JSON array (schema fix applied earlier)
const record = await pb.collection("quotes").create({
  quote_number: QUOTE_NUMBER,
  customerName: CUSTOMER_ID,
  customerRef: "RFQ;JEI MAGNETIC DRILLING MACHINE PARTS",
  quoteDate:   "2026-09-14 00:00:00.000Z",
  validUntil:  "2026-10-14 00:00:00.000Z",
  notes:       "",
  status:      "Draft",
  items:       items.map(i => i.id),
  quantities:  items.map(i => i.qty),
  unitPrices:  items.map(i => i.price),
});

// Verify
const stored = await pb.collection("quotes").getOne(record.id, { expand: "customerName" });
const customer = stored.expand?.customerName;

const subtotal = items.reduce((s, i) => s + i.qty * i.price, 0);
const vat = subtotal * 0.15;
const total = subtotal + vat;

console.log("\n✅ Quote created on PocketBase");
console.log("─────────────────────────────────────");
console.log(`ID          : ${stored.id}`);
console.log(`Quote #     : ${stored.quote_number}`);
console.log(`Customer    : ${customer?.comapny_name ?? "(unknown)"}`);
console.log(`Customer Ref: ${stored.customerRef}`);
console.log(`Quote Date  : ${stored.quoteDate}`);
console.log(`Valid Until : ${stored.validUntil}`);
console.log(`Status      : ${stored.status}`);
console.log(`Items stored: ${JSON.stringify(stored.items)}`);
console.log(`Quantities  : ${JSON.stringify(stored.quantities)}`);
console.log(`Unit Prices : ${JSON.stringify(stored.unitPrices)}`);
console.log(`Subtotal    : R ${subtotal.toFixed(2)}`);
console.log(`VAT (15%)   : R ${vat.toFixed(2)}`);
console.log(`Total       : R ${total.toFixed(2)}`);
console.log("─────────────────────────────────────");
console.log(`Admin URL   : https://pb.jeistk.apphub.co.za/_/#/collections?collectionId=pbc_134296766&recordId=${stored.id}`);