import { createDBPool } from "@/internal/datastore/index";
import { getViewpointDB } from "@/internal/viewpoint-db/kcgm-bookings.repo";
import {
  classifyOrigin,
  listBookingsForMemberships,
  MEMBERSHIP_CHUNK,
} from "@/internal/viewpoint-db/signup-bookings.repo";
import { syncSignupMemberBookings } from "@/internal/viewpoint-db/signup-sync.service";
import { NOT_UPGRADED } from "@/internal/repository/promo-code-campaigns/promo-code-signups.repo";
import { ViewpointImportRepository } from "@/internal/viewpoint-import/viewpoint-import.repo";
import dotenv from "dotenv";
import { sql } from "kysely";

dotenv.config();

const coreConfig = {
  host: process.env.DATABASE_HOST,
  port: parseInt(process.env.DATABASE_PORT || "5432"),
  database: process.env.DATABASE_NAME,
  user: process.env.DATABASE_USER,
  password: process.env.DATABASE_PWD,
  ssl:
    process.env.DATABASE_HOST !== "localhost" &&
      process.env.DATABASE_HOST !== "127.0.0.1"
      ? { rejectUnauthorized: false }
      : undefined,
};

const memberConfig = {
  host: process.env.MEMBER_DB_HOST,
  port: parseInt(process.env.MEMBER_DB_PORT || "5432"),
  database: process.env.MEMBER_DB_NAME,
  user: process.env.MEMBER_DB_USER,
  password: process.env.MEMBER_DB_PASSWORD,
  ssl:
    process.env.MEMBER_DB_HOST !== "localhost" &&
      process.env.MEMBER_DB_HOST !== "127.0.0.1"
      ? { rejectUnauthorized: false }
      : undefined,
};

async function main() {
  const write = process.argv.includes("--write");
  const prune = process.argv.includes("--prune");
  const memberDb = createDBPool(memberConfig);
  const viewpointDb = getViewpointDB();

  const signup = (await sql<{ memberships: number; codes: number }>`
    SELECT COUNT(DISTINCT UPPER(BTRIM(members.membership_number)))::int AS memberships,
           COUNT(DISTINCT UPPER(BTRIM(members.signup_promo_code)))::int AS codes
    FROM members
    WHERE COALESCE(BTRIM(members.signup_promo_code), '') <> ''
      AND COALESCE(BTRIM(members.membership_number), '') <> ''
      AND ${sql.raw(NOT_UPGRADED)}
  `.execute(memberDb)) as unknown as {
    rows: Array<{ memberships: number; codes: number }>;
  };
  console.log(
    `Signup members: ${signup.rows[0]?.memberships} memberships across ${signup.rows[0]?.codes} promo codes.`,
  );

  if (!write) {
    const ids = (await sql<{ m: string }>`
      SELECT DISTINCT UPPER(BTRIM(members.membership_number)) AS m
      FROM members
      WHERE COALESCE(BTRIM(members.signup_promo_code), '') <> ''
        AND COALESCE(BTRIM(members.membership_number), '') <> ''
        AND ${sql.raw(NOT_UPGRADED)}
    `.execute(memberDb)) as unknown as { rows: Array<{ m: string }> };

    const sample = ids.rows.slice(0, MEMBERSHIP_CHUNK).map((r) => r.m);
    const rows = await listBookingsForMemberships(viewpointDb, sample);
    const subito = rows.filter(
      (r) => classifyOrigin(r.created_by) === "subito",
    ).length;

    console.log(
      `\nFirst ${sample.length} memberships -> ${rows.length} bookings ` +
      `(${subito} subito, ${rows.length - subito} manual).`,
    );
    const channels = new Map<string, number>();
    for (const r of rows) {
      const key = (r.created_by ?? "(none)").replace(/\s+/g, " ").trim();
      channels.set(key, (channels.get(key) ?? 0) + 1);
    }
    for (const [k, v] of [...channels].sort((a, b) => b[1] - a[1])) {
      console.log(`  ${String(v).padStart(6)}  ${k}`);
    }
    console.log(
      "\nRead-only. Pass --write to upsert into viewpoint_bookings, " +
        "and --prune alongside it to also delete stored bookings this pull no longer selects.",
    );
    await viewpointDb.destroy();
    await memberDb.destroy();
    return;
  }

  const db = createDBPool(coreConfig);
  console.log(
    `\nWriting into ${coreConfig.database} (core2)${prune ? ", pruning stale rows" : ""} ...`,
  );
  const outcome = await syncSignupMemberBookings(db, memberDb, viewpointDb, {
    prune,
  });
  console.log(outcome);

  console.log("Matching against core ...");
  const matched = await new ViewpointImportRepository(
    db,
    memberDb,
  ).matchAgainstCore();
  console.log(matched);

  await db.destroy();
  await viewpointDb.destroy();
  await memberDb.destroy();
}

main().catch((err) => {
  console.error(err);
  process.exit(1);
});
