/** Add still-open CSC portal listings (scraped 2026-08-16) to the tracker. */
import { PrismaClient } from "@prisma/client";
const prisma = new PrismaClient();

const CSC = "https://csc.gov.ph/career/";
const common = {
  source: "csc.gov.ph", url: CSC, remoteType: "onsite", phEligibility: "yes",
  payCurrency: "PHP", payPeriod: "month", status: "prospect",
};

// posting: [title, agency, region, itemNo, closing, notes]
const rows: [string, string, string, string, string, string][] = [
  ["Computer Programmer II (2 items) + III", "Department of Finance", "NCR", "OSEC-DOFB-COMPRO2-1-1998 / COMPRO2-11-2000 / COMPRO3-8-2000", "2026-08-26", "CP II ≈ SG-15, CP III ≈ SG-18"],
  ["Information Systems Analyst II + III (3 items)", "Department of Finance", "NCR", "OSEC-DOFB-INFOSA2-5-2000 / INFOSA3-3-2000 / INFOSA3-4-2000", "2026-08-26", "ISA II ≈ SG-16, ISA III ≈ SG-19. Same DOF batch as the CP items — one application effort covers both."],
  ["Legislative Staff Officer III (Computer Programmer IV)", "House of Representatives", "NCR", "501-001 (HRB-LSO3-66-2000)", "2026-08-21", "Senior programmer item in Congress"],
  ["Information Systems Analyst III", "Bureau of Soils and Water Management (DA)", "NCR", "OSEC-DAB-INFOSA3-8-1998", "2026-08-26", "ISA III ≈ SG-19"],
  ["Information Technology Officer II", "Department of Economy, Planning, and Development", "NCR", "ITO2-33-2014", "2026-08-23", "ITO II ≈ SG-22 — highest-paying of the open NCR items"],
  ["Information Systems Analyst II", "Philippine Reclamation Authority", "NCR", "51", "2026-08-19", "GOCC — may have own salary structure"],
  ["Computer Programmer III + II", "City Government of Angeles", "Region III", "72 / 73", "2026-08-20", "Pampanga"],
  ["Computer Programmer III", "Provincial Government of Bohol", "Region VII", "132", "2026-08-20", "Also hiring ITO I (149-2026-01, same deadline)"],
  ["Computer Programmer III", "MGO Pili (Capital), Camarines Sur", "Region V", "03-01-001-15", "2026-08-25", ""],
  ["Computer Programmer I", "MGO Polangui, Albay", "Region V", "20", "2026-08-27", "Entry level, CP I ≈ SG-11"],
  ["Computer Programmer II + III", "Provincial Government of Basilan", "BARMM", "4 / 11", "2026-08-27", ""],
  ["Computer Programmer I (2 items)", "Provincial Government of Davao del Sur", "Region XI", "1069 / 213", "2026-08-20", ""],
  ["Information Systems Analyst I", "West Visayas State University", "Region VI", "WVSUB-INFOSA1-45-2023", "2026-08-23", "SUC"],
  ["Information Systems Analyst II", "Provincial Government of Guimaras", "Region VI", "935", "2026-08-30", "Longest-open deadline of the batch"],
  ["Information Systems Analyst I", "Provincial Government of Siquijor", "Region VII", "PHO-52-54", "2026-08-21", ""],
  ["Information Technology Officer I", "MGO Plaridel, Bulacan", "Region III", "19", "2026-08-26", "Near NCR"],
];

async function main() {
  for (const [title, agency, region, item, closing, extra] of rows) {
    const exists = await prisma.job.findFirst({ where: { title, company: agency } });
    if (exists) { console.log("skip:", agency, title); continue; }
    await prisma.job.create({
      data: {
        ...common,
        title, company: agency,
        location: region + ", Philippines",
        description: `CSC Job Portal listing. Plantilla item: ${item}. Closing date: ${closing}. ${extra}`,
        requirements: "Per CSC qualification standards for the position (education, eligibility, training, experience). See the posting's Details on the CSC portal; apply directly to the agency, not the CSC.",
        tags: "government,csc-portal,onsite" + (region === "NCR" ? ",NCR" : ""),
        notes: `Deadline ${closing}. Scraped from csc.gov.ph/career 2026-08-16 (filter Position: programmer/analyst/ITO). Applications go to the agency's HR, usually with CS Form 212, eligibility proof, transcripts.`,
      },
    });
    console.log("added:", agency, "—", title);
  }
}
main().finally(() => prisma.$disconnect());