// Construction tasks, subcontractors and change orders dataset (construction-tasks-subcontractors-and-change-orders-dataset) v1 — Prisma seed // Synthetic sample data, CC0-1.0. Generated deterministically; re-running the // generator with the same spec and seed reproduces this file exactly. // // Delegates are named after the tables (prisma.materials), which assumes models // mapped to those table names. Rename the delegates if your models differ. import { PrismaClient } from '@prisma/client'; const prisma = new PrismaClient(); async function main() { await prisma.materials.createMany({ data: [ { id: 1, list: "price_list", name: "Ready-mix concrete", unit: "m3", unit_price: "118.00" }, { id: 2, list: "price_list", name: "Reinforcement bar", unit: "tonne", unit_price: "780.00" }, { id: 3, list: "price_list", name: "Structural steel section", unit: "tonne", unit_price: "1250.00" }, { id: 4, list: "price_list", name: "Facing brick", unit: "1000", unit_price: "640.00" }, { id: 5, list: "price_list", name: "Concrete block", unit: "pallet", unit_price: "215.00" }, { id: 6, list: "price_list", name: "Plasterboard sheet", unit: "sheet", unit_price: "9.40" }, { id: 7, list: "price_list", name: "Insulation board", unit: "sheet", unit_price: "21.50" }, { id: 8, list: "price_list", name: "Roof tile", unit: "m2", unit_price: "34.00" }, { id: 9, list: "price_list", name: "Copper pipe", unit: "metre", unit_price: "8.60" }, { id: 10, list: "price_list", name: "Electrical cable", unit: "drum", unit_price: "165.00" }, { id: 11, list: "price_list", name: "Timber joist", unit: "metre", unit_price: "5.20" }, { id: 12, list: "price_list", name: "Double-glazed unit", unit: "unit", unit_price: "280.00" }, { id: 13, list: "price_list", name: "Floor screed", unit: "bag", unit_price: "6.80" }, { id: 14, list: "price_list", name: "Paint, masonry", unit: "tin", unit_price: "54.00" }, ], }); await prisma.projects.createMany({ data: [ { id: 1, name: "Foundry Kingsway", building_type: "apartment_block", city: "Sacramento", budget: "6682487", starts_on: "2025-02-25", status: "snagging" }, { id: 2, name: "Meridian Riverside", building_type: "apartment_block", city: "Weberfurt", budget: "3568953", starts_on: "2025-04-10", status: "handed_over" }, { id: 3, name: "Harbour Station", building_type: "apartment_block", city: "Rio Rancho", budget: "2020306", starts_on: "2025-04-14", status: "handed_over" }, { id: 4, name: "Riverside Albion", building_type: "office_fit_out", city: "New Gastonfield", budget: "4499351", starts_on: "2025-01-15", status: "on_site" }, { id: 5, name: "Albion Maple", building_type: "clinic", city: "Port Kelvin", budget: "7087345", starts_on: "2025-06-09", status: "on_site" }, { id: 6, name: "Kingsway Harbour", building_type: "warehouse", city: "Maggiohaven", budget: "7677096", starts_on: "2025-05-19", status: "snagging" }, ], }); await prisma.subcontractors.createMany({ data: [ { id: 1, panel: "approved_panel", trading_as: "Ashdown Electrical", trade: "electrical", day_rate: "310.00" }, { id: 2, panel: "approved_panel", trading_as: "Brightwell Plumbing and Heating", trade: "plumbing", day_rate: "295.00" }, { id: 3, panel: "approved_panel", trading_as: "Carrick Groundworks", trade: "groundworks", day_rate: "340.00" }, { id: 4, panel: "approved_panel", trading_as: "Dunmore Roofing", trade: "roofing", day_rate: "305.00" }, { id: 5, panel: "approved_panel", trading_as: "Elmhurst Plastering", trade: "plastering", day_rate: "260.00" }, { id: 6, panel: "approved_panel", trading_as: "Fenwick Scaffolding", trade: "scaffolding", day_rate: "285.00" }, { id: 7, panel: "approved_panel", trading_as: "Grayling Joinery", trade: "joinery", day_rate: "275.00" }, { id: 8, panel: "approved_panel", trading_as: "Harcourt Steel Erection", trade: "steelwork", day_rate: "365.00" }, { id: 9, panel: "approved_panel", trading_as: "Ivybridge Glazing", trade: "glazing", day_rate: "320.00" }, { id: 10, panel: "approved_panel", trading_as: "Jarrow Flooring", trade: "flooring", day_rate: "250.00" }, ], }); await prisma.tasks.createMany({ data: [ { id: 1, project_id: 5, task_no: 1, subcontractor_id: 9, trade: "glazing", planned_start: "2025-06-10", planned_days: 29, planned_cost: "59767.23", status: "complete", overrun_days: -4 }, { id: 2, project_id: 2, task_no: 1, subcontractor_id: 7, trade: "joinery", planned_start: "2025-04-22", planned_days: 54, planned_cost: "69716.87", status: "not_started", overrun_days: null }, { id: 3, project_id: 3, task_no: 1, subcontractor_id: 3, trade: "groundworks", planned_start: "2025-04-19", planned_days: 7, planned_cost: "157446.04", status: "complete", overrun_days: 16 }, { id: 4, project_id: 1, task_no: 1, subcontractor_id: 9, trade: "glazing", planned_start: "2025-03-09", planned_days: 53, planned_cost: "178187.81", status: "in_progress", overrun_days: null }, { id: 5, project_id: 4, task_no: 1, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-01-21", planned_days: 40, planned_cost: "29669.05", status: "complete", overrun_days: -5 }, { id: 6, project_id: 4, task_no: 2, subcontractor_id: 1, trade: "electrical", planned_start: "2025-02-01", planned_days: 9, planned_cost: "16086.84", status: "in_progress", overrun_days: null }, { id: 7, project_id: 5, task_no: 2, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-06-17", planned_days: 16, planned_cost: "4022.06", status: "not_started", overrun_days: null }, { id: 8, project_id: 4, task_no: 3, subcontractor_id: 1, trade: "electrical", planned_start: "2025-02-19", planned_days: 21, planned_cost: "61127.17", status: "complete", overrun_days: 11 }, { id: 9, project_id: 1, task_no: 2, subcontractor_id: 10, trade: "flooring", planned_start: "2025-03-21", planned_days: 3, planned_cost: "18096.97", status: "in_progress", overrun_days: null }, { id: 10, project_id: 6, task_no: 1, subcontractor_id: 3, trade: "groundworks", planned_start: "2025-05-31", planned_days: 3, planned_cost: "38126.06", status: "complete", overrun_days: -5 }, { id: 11, project_id: 4, task_no: 4, subcontractor_id: 1, trade: "electrical", planned_start: "2025-03-01", planned_days: 57, planned_cost: "46279.86", status: "not_started", overrun_days: null }, { id: 12, project_id: 3, task_no: 2, subcontractor_id: 5, trade: "plastering", planned_start: "2025-05-03", planned_days: 6, planned_cost: "4192.89", status: "not_started", overrun_days: null }, { id: 13, project_id: 4, task_no: 5, subcontractor_id: 8, trade: "steelwork", planned_start: "2025-03-11", planned_days: 4, planned_cost: "46493.85", status: "in_progress", overrun_days: null }, { id: 14, project_id: 6, task_no: 2, subcontractor_id: 1, trade: "electrical", planned_start: "2025-06-09", planned_days: 5, planned_cost: "41582.58", status: "complete", overrun_days: 24 }, { id: 15, project_id: 5, task_no: 3, subcontractor_id: 1, trade: "electrical", planned_start: "2025-06-26", planned_days: 3, planned_cost: "89305.74", status: "in_progress", overrun_days: null }, { id: 16, project_id: 6, task_no: 3, subcontractor_id: 1, trade: "electrical", planned_start: "2025-06-23", planned_days: 6, planned_cost: "93916.97", status: "complete", overrun_days: 29 }, { id: 17, project_id: 3, task_no: 3, subcontractor_id: 5, trade: "plastering", planned_start: "2025-05-17", planned_days: 35, planned_cost: "28279.24", status: "complete", overrun_days: 2 }, { id: 18, project_id: 5, task_no: 4, subcontractor_id: 1, trade: "electrical", planned_start: "2025-07-05", planned_days: 30, planned_cost: "77346.23", status: "in_progress", overrun_days: null }, { id: 19, project_id: 5, task_no: 5, subcontractor_id: 8, trade: "steelwork", planned_start: "2025-07-21", planned_days: 32, planned_cost: "55304.55", status: "complete", overrun_days: 10 }, { id: 20, project_id: 6, task_no: 4, subcontractor_id: 7, trade: "joinery", planned_start: "2025-07-04", planned_days: 3, planned_cost: "6221.30", status: "complete", overrun_days: 24 }, { id: 21, project_id: 1, task_no: 3, subcontractor_id: 10, trade: "flooring", planned_start: "2025-03-30", planned_days: 19, planned_cost: "24043.87", status: "complete", overrun_days: -1 }, { id: 22, project_id: 4, task_no: 6, subcontractor_id: 1, trade: "electrical", planned_start: "2025-03-28", planned_days: 35, planned_cost: "14517.39", status: "complete", overrun_days: 34 }, { id: 23, project_id: 5, task_no: 6, subcontractor_id: 1, trade: "electrical", planned_start: "2025-07-29", planned_days: 52, planned_cost: "50324.90", status: "complete", overrun_days: -1 }, { id: 24, project_id: 6, task_no: 5, subcontractor_id: 3, trade: "groundworks", planned_start: "2025-07-19", planned_days: 4, planned_cost: "20686.36", status: "complete", overrun_days: 29 }, { id: 25, project_id: 6, task_no: 6, subcontractor_id: 3, trade: "groundworks", planned_start: "2025-07-27", planned_days: 35, planned_cost: "125518.89", status: "complete", overrun_days: 37 }, { id: 26, project_id: 4, task_no: 7, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-04-07", planned_days: 3, planned_cost: "71111.83", status: "not_started", overrun_days: null }, { id: 27, project_id: 3, task_no: 4, subcontractor_id: 1, trade: "electrical", planned_start: "2025-05-30", planned_days: 18, planned_cost: "52834.41", status: "in_progress", overrun_days: null }, { id: 28, project_id: 2, task_no: 2, subcontractor_id: 4, trade: "roofing", planned_start: "2025-05-06", planned_days: 9, planned_cost: "21914.89", status: "not_started", overrun_days: null }, { id: 29, project_id: 6, task_no: 7, subcontractor_id: 10, trade: "flooring", planned_start: "2025-08-11", planned_days: 10, planned_cost: "42928.10", status: "not_started", overrun_days: null }, { id: 30, project_id: 3, task_no: 5, subcontractor_id: 3, trade: "groundworks", planned_start: "2025-06-17", planned_days: 8, planned_cost: "140278.78", status: "not_started", overrun_days: null }, { id: 31, project_id: 5, task_no: 7, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-08-14", planned_days: 10, planned_cost: "31962.85", status: "complete", overrun_days: 23 }, { id: 32, project_id: 6, task_no: 8, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-08-20", planned_days: 27, planned_cost: "145740.41", status: "in_progress", overrun_days: null }, { id: 33, project_id: 1, task_no: 4, subcontractor_id: 1, trade: "electrical", planned_start: "2025-04-14", planned_days: 18, planned_cost: "165473.26", status: "in_progress", overrun_days: null }, { id: 34, project_id: 2, task_no: 3, subcontractor_id: 5, trade: "plastering", planned_start: "2025-05-12", planned_days: 7, planned_cost: "41799.37", status: "not_started", overrun_days: null }, { id: 35, project_id: 2, task_no: 4, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-05-30", planned_days: 25, planned_cost: "101477.25", status: "complete", overrun_days: -5 }, { id: 36, project_id: 6, task_no: 9, subcontractor_id: 3, trade: "groundworks", planned_start: "2025-08-26", planned_days: 3, planned_cost: "23166.90", status: "complete", overrun_days: 41 }, { id: 37, project_id: 1, task_no: 5, subcontractor_id: 4, trade: "roofing", planned_start: "2025-04-30", planned_days: 53, planned_cost: "28635.51", status: "not_started", overrun_days: null }, { id: 38, project_id: 6, task_no: 10, subcontractor_id: 6, trade: "scaffolding", planned_start: "2025-09-09", planned_days: 25, planned_cost: "137927.88", status: "complete", overrun_days: -2 }, { id: 39, project_id: 6, task_no: 11, subcontractor_id: 8, trade: "steelwork", planned_start: "2025-09-17", planned_days: 18, planned_cost: "140163.06", status: "complete", overrun_days: 6 }, { id: 40, project_id: 1, task_no: 6, subcontractor_id: 1, trade: "electrical", planned_start: "2025-05-19", planned_days: 44, planned_cost: "4010.20", status: "in_progress", overrun_days: null }, { id: 41, project_id: 1, task_no: 7, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-05-29", planned_days: 8, planned_cost: "133071.04", status: "complete", overrun_days: -3 }, { id: 42, project_id: 4, task_no: 8, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-04-16", planned_days: 5, planned_cost: "31563.91", status: "complete", overrun_days: -4 }, { id: 43, project_id: 2, task_no: 5, subcontractor_id: 1, trade: "electrical", planned_start: "2025-06-05", planned_days: 21, planned_cost: "907.89", status: "complete", overrun_days: 18 }, { id: 44, project_id: 4, task_no: 9, subcontractor_id: 4, trade: "roofing", planned_start: "2025-05-01", planned_days: 13, planned_cost: "30786.20", status: "in_progress", overrun_days: null }, { id: 45, project_id: 1, task_no: 8, subcontractor_id: 1, trade: "electrical", planned_start: "2025-06-15", planned_days: 19, planned_cost: "59457.29", status: "complete", overrun_days: 9 }, { id: 46, project_id: 6, task_no: 12, subcontractor_id: 1, trade: "electrical", planned_start: "2025-09-26", planned_days: 33, planned_cost: "150934.67", status: "complete", overrun_days: 42 }, { id: 47, project_id: 6, task_no: 13, subcontractor_id: 9, trade: "glazing", planned_start: "2025-10-14", planned_days: 41, planned_cost: "35667.06", status: "not_started", overrun_days: null }, { id: 48, project_id: 4, task_no: 10, subcontractor_id: 10, trade: "flooring", planned_start: "2025-05-07", planned_days: 38, planned_cost: "39073.48", status: "in_progress", overrun_days: null }, { id: 49, project_id: 5, task_no: 8, subcontractor_id: 8, trade: "steelwork", planned_start: "2025-08-27", planned_days: 8, planned_cost: "59136.41", status: "complete", overrun_days: 29 }, { id: 50, project_id: 4, task_no: 11, subcontractor_id: 9, trade: "glazing", planned_start: "2025-05-21", planned_days: 55, planned_cost: "94942.47", status: "in_progress", overrun_days: null }, { id: 51, project_id: 4, task_no: 12, subcontractor_id: 1, trade: "electrical", planned_start: "2025-05-27", planned_days: 33, planned_cost: "57620.82", status: "not_started", overrun_days: null }, { id: 52, project_id: 6, task_no: 14, subcontractor_id: 9, trade: "glazing", planned_start: "2025-10-23", planned_days: 15, planned_cost: "15957.29", status: "complete", overrun_days: -3 }, { id: 53, project_id: 2, task_no: 6, subcontractor_id: 9, trade: "glazing", planned_start: "2025-06-21", planned_days: 3, planned_cost: "131604.82", status: "complete", overrun_days: 22 }, { id: 54, project_id: 3, task_no: 6, subcontractor_id: 10, trade: "flooring", planned_start: "2025-06-30", planned_days: 11, planned_cost: "1299.35", status: "complete", overrun_days: 5 }, { id: 55, project_id: 5, task_no: 9, subcontractor_id: 1, trade: "electrical", planned_start: "2025-09-09", planned_days: 38, planned_cost: "41129.58", status: "complete", overrun_days: 22 }, { id: 56, project_id: 5, task_no: 10, subcontractor_id: 8, trade: "steelwork", planned_start: "2025-09-17", planned_days: 38, planned_cost: "120746.75", status: "in_progress", overrun_days: null }, { id: 57, project_id: 4, task_no: 13, subcontractor_id: 1, trade: "electrical", planned_start: "2025-06-16", planned_days: 25, planned_cost: "7974.47", status: "complete", overrun_days: 26 }, { id: 58, project_id: 1, task_no: 9, subcontractor_id: 6, trade: "scaffolding", planned_start: "2025-07-05", planned_days: 16, planned_cost: "22667.14", status: "in_progress", overrun_days: null }, { id: 59, project_id: 2, task_no: 7, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-07-06", planned_days: 5, planned_cost: "5237.60", status: "complete", overrun_days: 7 }, { id: 60, project_id: 2, task_no: 8, subcontractor_id: 1, trade: "electrical", planned_start: "2025-07-17", planned_days: 34, planned_cost: "46570.33", status: "complete", overrun_days: -1 }, { id: 61, project_id: 4, task_no: 14, subcontractor_id: 3, trade: "groundworks", planned_start: "2025-07-02", planned_days: 8, planned_cost: "11918.27", status: "complete", overrun_days: 29 }, { id: 62, project_id: 4, task_no: 15, subcontractor_id: 5, trade: "plastering", planned_start: "2025-07-18", planned_days: 39, planned_cost: "63337.82", status: "complete", overrun_days: -5 }, { id: 63, project_id: 3, task_no: 7, subcontractor_id: 5, trade: "plastering", planned_start: "2025-07-17", planned_days: 3, planned_cost: "3480.43", status: "in_progress", overrun_days: null }, { id: 64, project_id: 4, task_no: 16, subcontractor_id: 6, trade: "scaffolding", planned_start: "2025-07-25", planned_days: 5, planned_cost: "1428.53", status: "complete", overrun_days: -3 }, { id: 65, project_id: 2, task_no: 9, subcontractor_id: 6, trade: "scaffolding", planned_start: "2025-07-31", planned_days: 9, planned_cost: "37461.47", status: "in_progress", overrun_days: null }, { id: 66, project_id: 2, task_no: 10, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-08-10", planned_days: 4, planned_cost: "124128.26", status: "in_progress", overrun_days: null }, { id: 67, project_id: 1, task_no: 10, subcontractor_id: 8, trade: "steelwork", planned_start: "2025-07-20", planned_days: 28, planned_cost: "164574.28", status: "complete", overrun_days: -3 }, { id: 68, project_id: 4, task_no: 17, subcontractor_id: 9, trade: "glazing", planned_start: "2025-08-14", planned_days: 4, planned_cost: "14000.14", status: "in_progress", overrun_days: null }, { id: 69, project_id: 4, task_no: 18, subcontractor_id: 3, trade: "groundworks", planned_start: "2025-09-03", planned_days: 3, planned_cost: "168348.43", status: "in_progress", overrun_days: null }, { id: 70, project_id: 3, task_no: 8, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-08-04", planned_days: 55, planned_cost: "147343.92", status: "not_started", overrun_days: null }, { id: 71, project_id: 4, task_no: 19, subcontractor_id: 1, trade: "electrical", planned_start: "2025-09-13", planned_days: 3, planned_cost: "58441.67", status: "not_started", overrun_days: null }, { id: 72, project_id: 2, task_no: 11, subcontractor_id: 10, trade: "flooring", planned_start: "2025-08-16", planned_days: 42, planned_cost: "136867.46", status: "complete", overrun_days: -5 }, { id: 73, project_id: 5, task_no: 11, subcontractor_id: 8, trade: "steelwork", planned_start: "2025-09-24", planned_days: 14, planned_cost: "96675.12", status: "complete", overrun_days: 44 }, { id: 74, project_id: 2, task_no: 12, subcontractor_id: 9, trade: "glazing", planned_start: "2025-08-31", planned_days: 3, planned_cost: "17075.65", status: "complete", overrun_days: 8 }, { id: 75, project_id: 6, task_no: 15, subcontractor_id: 8, trade: "steelwork", planned_start: "2025-10-31", planned_days: 24, planned_cost: "117705.65", status: "complete", overrun_days: 1 }, { id: 76, project_id: 6, task_no: 16, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-11-14", planned_days: 16, planned_cost: "102333.27", status: "not_started", overrun_days: null }, { id: 77, project_id: 1, task_no: 11, subcontractor_id: 1, trade: "electrical", planned_start: "2025-07-31", planned_days: 29, planned_cost: "55109.84", status: "complete", overrun_days: 33 }, { id: 78, project_id: 1, task_no: 12, subcontractor_id: 4, trade: "roofing", planned_start: "2025-08-19", planned_days: 6, planned_cost: "23908.64", status: "in_progress", overrun_days: null }, { id: 79, project_id: 1, task_no: 13, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-08-25", planned_days: 37, planned_cost: "2646.34", status: "complete", overrun_days: -5 }, { id: 80, project_id: 3, task_no: 9, subcontractor_id: 9, trade: "glazing", planned_start: "2025-08-19", planned_days: 50, planned_cost: "82194.93", status: "complete", overrun_days: 3 }, { id: 81, project_id: 5, task_no: 12, subcontractor_id: 1, trade: "electrical", planned_start: "2025-10-09", planned_days: 9, planned_cost: "167326.42", status: "complete", overrun_days: 6 }, { id: 82, project_id: 4, task_no: 20, subcontractor_id: 1, trade: "electrical", planned_start: "2025-09-24", planned_days: 11, planned_cost: "11936.29", status: "complete", overrun_days: 21 }, { id: 83, project_id: 1, task_no: 14, subcontractor_id: 1, trade: "electrical", planned_start: "2025-09-03", planned_days: 5, planned_cost: "153505.91", status: "in_progress", overrun_days: null }, { id: 84, project_id: 3, task_no: 10, subcontractor_id: 8, trade: "steelwork", planned_start: "2025-08-27", planned_days: 4, planned_cost: "78169.60", status: "complete", overrun_days: -4 }, { id: 85, project_id: 2, task_no: 13, subcontractor_id: 4, trade: "roofing", planned_start: "2025-09-09", planned_days: 6, planned_cost: "34043.59", status: "not_started", overrun_days: null }, { id: 86, project_id: 2, task_no: 14, subcontractor_id: 4, trade: "roofing", planned_start: "2025-09-26", planned_days: 21, planned_cost: "36097.59", status: "complete", overrun_days: 10 }, { id: 87, project_id: 5, task_no: 13, subcontractor_id: 4, trade: "roofing", planned_start: "2025-10-27", planned_days: 49, planned_cost: "7814.92", status: "not_started", overrun_days: null }, { id: 88, project_id: 2, task_no: 15, subcontractor_id: 4, trade: "roofing", planned_start: "2025-10-09", planned_days: 4, planned_cost: "116668.59", status: "complete", overrun_days: 3 }, { id: 89, project_id: 1, task_no: 15, subcontractor_id: 1, trade: "electrical", planned_start: "2025-09-20", planned_days: 26, planned_cost: "142428.69", status: "in_progress", overrun_days: null }, { id: 90, project_id: 2, task_no: 16, subcontractor_id: 1, trade: "electrical", planned_start: "2025-10-18", planned_days: 27, planned_cost: "13811.52", status: "complete", overrun_days: -5 }, { id: 91, project_id: 1, task_no: 16, subcontractor_id: 1, trade: "electrical", planned_start: "2025-10-04", planned_days: 5, planned_cost: "17941.14", status: "complete", overrun_days: -4 }, { id: 92, project_id: 1, task_no: 17, subcontractor_id: 8, trade: "steelwork", planned_start: "2025-10-14", planned_days: 13, planned_cost: "98794.23", status: "complete", overrun_days: 34 }, { id: 93, project_id: 5, task_no: 14, subcontractor_id: 3, trade: "groundworks", planned_start: "2025-11-05", planned_days: 4, planned_cost: "1459.33", status: "complete", overrun_days: 35 }, { id: 94, project_id: 2, task_no: 17, subcontractor_id: 3, trade: "groundworks", planned_start: "2025-10-27", planned_days: 54, planned_cost: "15258.14", status: "not_started", overrun_days: null }, { id: 95, project_id: 1, task_no: 18, subcontractor_id: 7, trade: "joinery", planned_start: "2025-10-20", planned_days: 4, planned_cost: "93416.50", status: "not_started", overrun_days: null }, { id: 96, project_id: 5, task_no: 15, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-11-11", planned_days: 40, planned_cost: "9263.13", status: "complete", overrun_days: 1 }, { id: 97, project_id: 2, task_no: 18, subcontractor_id: 1, trade: "electrical", planned_start: "2025-11-05", planned_days: 3, planned_cost: "37834.81", status: "not_started", overrun_days: null }, { id: 98, project_id: 2, task_no: 19, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-11-13", planned_days: 38, planned_cost: "51782.80", status: "complete", overrun_days: 34 }, { id: 99, project_id: 6, task_no: 17, subcontractor_id: 7, trade: "joinery", planned_start: "2025-12-04", planned_days: 6, planned_cost: "3893.13", status: "in_progress", overrun_days: null }, { id: 100, project_id: 6, task_no: 18, subcontractor_id: 6, trade: "scaffolding", planned_start: "2025-12-14", planned_days: 34, planned_cost: "5251.75", status: "not_started", overrun_days: null }, { id: 101, project_id: 3, task_no: 11, subcontractor_id: 4, trade: "roofing", planned_start: "2025-09-06", planned_days: 4, planned_cost: "9981.62", status: "complete", overrun_days: -2 }, { id: 102, project_id: 4, task_no: 21, subcontractor_id: 2, trade: "plumbing", planned_start: "2025-10-03", planned_days: 23, planned_cost: "160159.27", status: "in_progress", overrun_days: null }, { id: 103, project_id: 4, task_no: 22, subcontractor_id: 1, trade: "electrical", planned_start: "2025-10-19", planned_days: 12, planned_cost: "73898.03", status: "complete", overrun_days: 19 }, { id: 104, project_id: 3, task_no: 12, subcontractor_id: 7, trade: "joinery", planned_start: "2025-09-13", planned_days: 16, planned_cost: "2718.11", status: "in_progress", overrun_days: null }, { id: 105, project_id: 6, task_no: 19, subcontractor_id: 1, trade: "electrical", planned_start: "2025-12-22", planned_days: 4, planned_cost: "17081.06", status: "complete", overrun_days: -5 }, { id: 106, project_id: 3, task_no: 13, subcontractor_id: 4, trade: "roofing", planned_start: "2025-10-02", planned_days: 3, planned_cost: "118495.33", status: "complete", overrun_days: 7 }, { id: 107, project_id: 5, task_no: 16, subcontractor_id: 1, trade: "electrical", planned_start: "2025-11-24", planned_days: 38, planned_cost: "36100.22", status: "complete", overrun_days: 16 }, { id: 108, project_id: 6, task_no: 20, subcontractor_id: 4, trade: "roofing", planned_start: "2026-01-03", planned_days: 17, planned_cost: "84880.97", status: "in_progress", overrun_days: null }, { id: 109, project_id: 3, task_no: 14, subcontractor_id: 1, trade: "electrical", planned_start: "2025-10-14", planned_days: 23, planned_cost: "8192.36", status: "complete", overrun_days: -4 }, { id: 110, project_id: 2, task_no: 20, subcontractor_id: 1, trade: "electrical", planned_start: "2025-11-23", planned_days: 4, planned_cost: "83646.69", status: "in_progress", overrun_days: null }, { id: 111, project_id: 2, task_no: 21, subcontractor_id: 1, trade: "electrical", planned_start: "2025-12-05", planned_days: 26, planned_cost: "22966.88", status: "blocked", overrun_days: null }, { id: 112, project_id: 5, task_no: 17, subcontractor_id: 4, trade: "roofing", planned_start: "2025-12-02", planned_days: 46, planned_cost: "152846.36", status: "complete", overrun_days: 12 }, { id: 113, project_id: 1, task_no: 19, subcontractor_id: 1, trade: "electrical", planned_start: "2025-11-02", planned_days: 4, planned_cost: "26020.89", status: "not_started", overrun_days: null }, { id: 114, project_id: 4, task_no: 23, subcontractor_id: 1, trade: "electrical", planned_start: "2025-10-26", planned_days: 5, planned_cost: "19622.80", status: "complete", overrun_days: 2 }, { id: 115, project_id: 2, task_no: 22, subcontractor_id: 5, trade: "plastering", planned_start: "2025-12-21", planned_days: 5, planned_cost: "123387.70", status: "in_progress", overrun_days: null }, { id: 116, project_id: 3, task_no: 15, subcontractor_id: 4, trade: "roofing", planned_start: "2025-10-21", planned_days: 40, planned_cost: "34594.83", status: "not_started", overrun_days: null }, { id: 117, project_id: 6, task_no: 21, subcontractor_id: 8, trade: "steelwork", planned_start: "2026-01-17", planned_days: 8, planned_cost: "84989.67", status: "complete", overrun_days: 8 }, { id: 118, project_id: 1, task_no: 20, subcontractor_id: 1, trade: "electrical", planned_start: "2025-11-19", planned_days: 3, planned_cost: "54558.17", status: "complete", overrun_days: -5 }, { id: 119, project_id: 5, task_no: 18, subcontractor_id: 3, trade: "groundworks", planned_start: "2025-12-22", planned_days: 3, planned_cost: "52776.60", status: "not_started", overrun_days: null }, { id: 120, project_id: 1, task_no: 21, subcontractor_id: 1, trade: "electrical", planned_start: "2025-11-26", planned_days: 16, planned_cost: "48029.00", status: "complete", overrun_days: 43 }, ], }); await prisma.change_orders.createMany({ data: [ { id: 1, task_id: 99, project_id: 6, change_ref: "CO-0525", raised_on: "2025-12-08", reason: "client_request", direction: "addition", value: "38095.98", days_requested: 2, status: "approved", decided_on: "2025-12-13" }, { id: 2, task_id: 59, project_id: 2, change_ref: "CO-6351", raised_on: "2025-08-15", reason: "regulation", direction: "omission", value: "53311.34", days_requested: 1, status: "approved", decided_on: "2025-08-17" }, { id: 3, task_id: 92, project_id: 1, change_ref: "CO-0383", raised_on: "2025-11-25", reason: "regulation", direction: "addition", value: "11523.98", days_requested: 0, status: "approved", decided_on: "2025-12-03" }, { id: 4, task_id: 89, project_id: 1, change_ref: "CO-6260", raised_on: "2025-11-02", reason: "design_error", direction: "addition", value: "18704.17", days_requested: 24, status: "approved", decided_on: "2025-11-28" }, { id: 5, task_id: 102, project_id: 4, change_ref: "CO-7163", raised_on: "2025-10-18", reason: "regulation", direction: "addition", value: "691.74", days_requested: 1, status: "approved", decided_on: "2025-11-07" }, { id: 6, task_id: 1, project_id: 5, change_ref: "CO-4149", raised_on: "2025-07-20", reason: "design_error", direction: "addition", value: "35328.85", days_requested: 27, status: "pending", decided_on: null }, { id: 7, task_id: 65, project_id: 2, change_ref: "CO-6157", raised_on: "2025-08-18", reason: "supplier_substitution", direction: "addition", value: "1235.12", days_requested: 12, status: "approved", decided_on: "2025-09-10" }, { id: 8, task_id: 24, project_id: 6, change_ref: "CO-0061", raised_on: "2025-08-20", reason: "client_request", direction: "addition", value: "4073.49", days_requested: 1, status: "approved", decided_on: "2025-09-06" }, { id: 9, task_id: 36, project_id: 6, change_ref: "CO-5780", raised_on: "2025-08-28", reason: "site_condition", direction: "addition", value: "15914.90", days_requested: 9, status: "approved", decided_on: "2025-08-30" }, { id: 10, task_id: 105, project_id: 6, change_ref: "CO-3065", raised_on: "2026-01-07", reason: "site_condition", direction: "addition", value: "4762.90", days_requested: 11, status: "approved", decided_on: "2026-01-11" }, { id: 11, task_id: 40, project_id: 1, change_ref: "CO-3485", raised_on: "2025-05-21", reason: "design_error", direction: "addition", value: "637.82", days_requested: 29, status: "approved", decided_on: "2025-06-15" }, { id: 12, task_id: 6, project_id: 4, change_ref: "CO-1534", raised_on: "2025-02-24", reason: "regulation", direction: "addition", value: "19045.60", days_requested: 0, status: "approved", decided_on: "2025-03-01" }, { id: 13, task_id: 80, project_id: 3, change_ref: "CO-4769", raised_on: "2025-09-10", reason: "client_request", direction: "omission", value: "1810.66", days_requested: 26, status: "approved", decided_on: "2025-10-03" }, { id: 14, task_id: 44, project_id: 4, change_ref: "CO-8242", raised_on: "2025-05-27", reason: "regulation", direction: "addition", value: "486.23", days_requested: 2, status: "pending", decided_on: null }, { id: 15, task_id: 76, project_id: 6, change_ref: "CO-0719", raised_on: "2025-11-28", reason: "client_request", direction: "addition", value: "25697.09", days_requested: 2, status: "withdrawn", decided_on: null }, { id: 16, task_id: 38, project_id: 6, change_ref: "CO-0830", raised_on: "2025-09-12", reason: "client_request", direction: "addition", value: "7697.72", days_requested: 26, status: "approved", decided_on: "2025-10-04" }, { id: 17, task_id: 51, project_id: 4, change_ref: "CO-2127", raised_on: "2025-06-10", reason: "client_request", direction: "addition", value: "773.23", days_requested: 28, status: "pending", decided_on: null }, { id: 18, task_id: 49, project_id: 5, change_ref: "CO-3502", raised_on: "2025-10-03", reason: "design_error", direction: "omission", value: "6203.99", days_requested: 25, status: "approved", decided_on: "2025-10-08" }, { id: 19, task_id: 19, project_id: 5, change_ref: "CO-2708", raised_on: "2025-08-27", reason: "regulation", direction: "addition", value: "432.20", days_requested: 1, status: "approved", decided_on: "2025-09-01" }, { id: 20, task_id: 75, project_id: 6, change_ref: "CO-6024", raised_on: "2025-12-07", reason: "site_condition", direction: "omission", value: "29179.85", days_requested: 19, status: "approved", decided_on: "2025-12-08" }, { id: 21, task_id: 2, project_id: 2, change_ref: "CO-7575", raised_on: "2025-05-18", reason: "regulation", direction: "addition", value: "41224.00", days_requested: 7, status: "withdrawn", decided_on: null }, { id: 22, task_id: 111, project_id: 2, change_ref: "CO-4621", raised_on: "2025-12-06", reason: "client_request", direction: "addition", value: "17522.72", days_requested: 1, status: "approved", decided_on: "2025-12-29" }, { id: 23, task_id: 25, project_id: 6, change_ref: "CO-7248", raised_on: "2025-07-29", reason: "design_error", direction: "addition", value: "4807.48", days_requested: 2, status: "approved", decided_on: "2025-08-27" }, { id: 24, task_id: 84, project_id: 3, change_ref: "CO-4761", raised_on: "2025-09-06", reason: "design_error", direction: "omission", value: "41553.84", days_requested: 10, status: "approved", decided_on: "2025-09-26" }, { id: 25, task_id: 23, project_id: 5, change_ref: "CO-7962", raised_on: "2025-08-15", reason: "client_request", direction: "addition", value: "41052.45", days_requested: 1, status: "pending", decided_on: null }, { id: 26, task_id: 14, project_id: 6, change_ref: "CO-7249", raised_on: "2025-07-23", reason: "design_error", direction: "addition", value: "40429.19", days_requested: 10, status: "approved", decided_on: "2025-08-22" }, { id: 27, task_id: 29, project_id: 6, change_ref: "CO-3862", raised_on: "2025-09-05", reason: "client_request", direction: "addition", value: "445.85", days_requested: 0, status: "approved", decided_on: "2025-09-18" }, { id: 28, task_id: 104, project_id: 3, change_ref: "CO-1895", raised_on: "2025-10-14", reason: "regulation", direction: "addition", value: "30278.92", days_requested: 2, status: "approved", decided_on: "2025-11-05" }, { id: 29, task_id: 107, project_id: 5, change_ref: "CO-0446", raised_on: "2025-12-17", reason: "design_error", direction: "addition", value: "403.56", days_requested: 8, status: "withdrawn", decided_on: null }, { id: 30, task_id: 64, project_id: 4, change_ref: "CO-1351", raised_on: "2025-08-25", reason: "client_request", direction: "omission", value: "13980.56", days_requested: 1, status: "pending", decided_on: null }, { id: 31, task_id: 61, project_id: 4, change_ref: "CO-1653", raised_on: "2025-07-24", reason: "regulation", direction: "addition", value: "20848.89", days_requested: 0, status: "approved", decided_on: "2025-08-18" }, { id: 32, task_id: 88, project_id: 2, change_ref: "CO-3413", raised_on: "2025-11-21", reason: "client_request", direction: "addition", value: "20688.88", days_requested: 0, status: "pending", decided_on: null }, { id: 33, task_id: 119, project_id: 5, change_ref: "CO-5840", raised_on: "2026-01-18", reason: "client_request", direction: "addition", value: "51945.36", days_requested: 10, status: "pending", decided_on: null }, { id: 34, task_id: 30, project_id: 3, change_ref: "CO-7462", raised_on: "2025-07-29", reason: "site_condition", direction: "addition", value: "56142.37", days_requested: 3, status: "pending", decided_on: null }, { id: 35, task_id: 15, project_id: 5, change_ref: "CO-2199", raised_on: "2025-06-27", reason: "client_request", direction: "addition", value: "51897.42", days_requested: 1, status: "approved", decided_on: "2025-07-07" }, { id: 36, task_id: 85, project_id: 2, change_ref: "CO-0487", raised_on: "2025-10-14", reason: "regulation", direction: "addition", value: "27810.18", days_requested: 0, status: "rejected", decided_on: "2025-10-31" }, { id: 37, task_id: 63, project_id: 3, change_ref: "CO-0821", raised_on: "2025-07-27", reason: "design_error", direction: "addition", value: "4119.12", days_requested: 8, status: "approved", decided_on: "2025-08-19" }, { id: 38, task_id: 3, project_id: 3, change_ref: "CO-9152", raised_on: "2025-04-29", reason: "regulation", direction: "addition", value: "1093.09", days_requested: 0, status: "pending", decided_on: null }, { id: 39, task_id: 60, project_id: 2, change_ref: "CO-5778", raised_on: "2025-08-01", reason: "supplier_substitution", direction: "addition", value: "29169.53", days_requested: 15, status: "withdrawn", decided_on: null }, { id: 40, task_id: 50, project_id: 4, change_ref: "CO-3200", raised_on: "2025-06-05", reason: "client_request", direction: "addition", value: "29697.73", days_requested: 5, status: "pending", decided_on: null }, { id: 41, task_id: 57, project_id: 4, change_ref: "CO-5524", raised_on: "2025-07-01", reason: "design_error", direction: "addition", value: "8212.32", days_requested: 6, status: "approved", decided_on: "2025-07-18" }, { id: 42, task_id: 62, project_id: 4, change_ref: "CO-3515", raised_on: "2025-07-31", reason: "site_condition", direction: "addition", value: "641.06", days_requested: 18, status: "approved", decided_on: "2025-08-02" }, { id: 43, task_id: 78, project_id: 1, change_ref: "CO-3188", raised_on: "2025-08-29", reason: "site_condition", direction: "addition", value: "9927.39", days_requested: 2, status: "approved", decided_on: "2025-09-24" }, { id: 44, task_id: 68, project_id: 4, change_ref: "CO-3360", raised_on: "2025-08-23", reason: "design_error", direction: "addition", value: "15923.95", days_requested: 20, status: "withdrawn", decided_on: null }, { id: 45, task_id: 116, project_id: 3, change_ref: "CO-0956", raised_on: "2025-10-30", reason: "client_request", direction: "addition", value: "23167.66", days_requested: 13, status: "pending", decided_on: null }, { id: 46, task_id: 97, project_id: 2, change_ref: "CO-1239", raised_on: "2025-11-11", reason: "client_request", direction: "omission", value: "20779.29", days_requested: 26, status: "approved", decided_on: "2025-11-12" }, { id: 47, task_id: 43, project_id: 2, change_ref: "CO-7564", raised_on: "2025-06-20", reason: "design_error", direction: "omission", value: "24427.11", days_requested: 22, status: "approved", decided_on: "2025-07-12" }, { id: 48, task_id: 33, project_id: 1, change_ref: "CO-9431", raised_on: "2025-04-23", reason: "design_error", direction: "addition", value: "58398.79", days_requested: 8, status: "approved", decided_on: "2025-05-09" }, { id: 49, task_id: 58, project_id: 1, change_ref: "CO-0373", raised_on: "2025-08-13", reason: "site_condition", direction: "addition", value: "42957.51", days_requested: 14, status: "approved", decided_on: "2025-08-27" }, { id: 50, task_id: 52, project_id: 6, change_ref: "CO-8734", raised_on: "2025-11-18", reason: "site_condition", direction: "addition", value: "32455.78", days_requested: 1, status: "approved", decided_on: "2025-12-09" }, { id: 51, task_id: 66, project_id: 2, change_ref: "CO-9654", raised_on: "2025-09-14", reason: "site_condition", direction: "addition", value: "2367.31", days_requested: 30, status: "approved", decided_on: "2025-10-02" }, { id: 52, task_id: 7, project_id: 5, change_ref: "CO-9893", raised_on: "2025-06-29", reason: "client_request", direction: "addition", value: "56801.25", days_requested: 24, status: "approved", decided_on: "2025-07-23" }, { id: 53, task_id: 39, project_id: 6, change_ref: "CO-9160", raised_on: "2025-10-04", reason: "regulation", direction: "addition", value: "46622.91", days_requested: 29, status: "pending", decided_on: null }, { id: 54, task_id: 94, project_id: 2, change_ref: "CO-1592", raised_on: "2025-12-06", reason: "client_request", direction: "addition", value: "15178.45", days_requested: 0, status: "rejected", decided_on: "2025-12-24" }, { id: 55, task_id: 120, project_id: 1, change_ref: "CO-1595", raised_on: "2025-12-26", reason: "regulation", direction: "addition", value: "830.99", days_requested: 6, status: "withdrawn", decided_on: null }, { id: 56, task_id: 81, project_id: 5, change_ref: "CO-4708", raised_on: "2025-10-10", reason: "client_request", direction: "addition", value: "50587.37", days_requested: 3, status: "approved", decided_on: "2025-10-25" }, { id: 57, task_id: 4, project_id: 1, change_ref: "CO-8200", raised_on: "2025-04-04", reason: "client_request", direction: "addition", value: "22735.41", days_requested: 16, status: "approved", decided_on: "2025-04-10" }, { id: 58, task_id: 91, project_id: 1, change_ref: "CO-0569", raised_on: "2025-10-19", reason: "site_condition", direction: "addition", value: "2787.91", days_requested: 20, status: "pending", decided_on: null }, { id: 59, task_id: 70, project_id: 3, change_ref: "CO-7975", raised_on: "2025-09-17", reason: "regulation", direction: "addition", value: "27188.37", days_requested: 0, status: "approved", decided_on: "2025-10-08" }, { id: 60, task_id: 48, project_id: 4, change_ref: "CO-3655", raised_on: "2025-05-07", reason: "client_request", direction: "addition", value: "973.17", days_requested: 15, status: "withdrawn", decided_on: null }, { id: 61, task_id: 13, project_id: 4, change_ref: "CO-4191", raised_on: "2025-03-29", reason: "site_condition", direction: "omission", value: "26789.25", days_requested: 7, status: "rejected", decided_on: "2025-04-18" }, { id: 62, task_id: 114, project_id: 4, change_ref: "CO-3225", raised_on: "2025-11-28", reason: "supplier_substitution", direction: "omission", value: "34082.14", days_requested: 6, status: "approved", decided_on: "2025-11-30" }, { id: 63, task_id: 56, project_id: 5, change_ref: "CO-4147", raised_on: "2025-10-07", reason: "regulation", direction: "omission", value: "3455.69", days_requested: 22, status: "approved", decided_on: "2025-10-19" }, { id: 64, task_id: 55, project_id: 5, change_ref: "CO-8366", raised_on: "2025-09-27", reason: "design_error", direction: "omission", value: "403.89", days_requested: 5, status: "approved", decided_on: "2025-10-11" }, ], }); await prisma.deliveries.createMany({ data: [ { id: 1, task_id: 49, material_id: 1, delivered_on: "2025-09-02", quantity: 9, unit_price: "118.00", line_cost: "1062.00" }, { id: 2, task_id: 4, material_id: 9, delivered_on: "2025-03-20", quantity: 41, unit_price: "8.60", line_cost: "352.60" }, { id: 3, task_id: 69, material_id: 7, delivered_on: "2025-09-04", quantity: 1, unit_price: "21.50", line_cost: "21.50" }, { id: 4, task_id: 95, material_id: 1, delivered_on: "2025-10-29", quantity: 3, unit_price: "118.00", line_cost: "354.00" }, { id: 5, task_id: 108, material_id: 6, delivered_on: "2026-01-08", quantity: 59, unit_price: "9.40", line_cost: "554.60" }, { id: 6, task_id: 113, material_id: 2, delivered_on: "2025-11-07", quantity: 46, unit_price: "780.00", line_cost: "35880.00" }, { id: 7, task_id: 58, material_id: 12, delivered_on: "2025-07-06", quantity: 15, unit_price: "280.00", line_cost: "4200.00" }, { id: 8, task_id: 39, material_id: 2, delivered_on: "2025-10-07", quantity: 1, unit_price: "780.00", line_cost: "780.00" }, { id: 9, task_id: 7, material_id: 1, delivered_on: "2025-07-17", quantity: 7, unit_price: "118.00", line_cost: "826.00" }, { id: 10, task_id: 92, material_id: 1, delivered_on: "2025-10-21", quantity: 12, unit_price: "118.00", line_cost: "1416.00" }, { id: 11, task_id: 63, material_id: 2, delivered_on: "2025-08-01", quantity: 3, unit_price: "780.00", line_cost: "2340.00" }, { id: 12, task_id: 25, material_id: 10, delivered_on: "2025-08-13", quantity: 59, unit_price: "165.00", line_cost: "9735.00" }, { id: 13, task_id: 35, material_id: 11, delivered_on: "2025-06-13", quantity: 4, unit_price: "5.20", line_cost: "20.80" }, { id: 14, task_id: 69, material_id: 1, delivered_on: "2025-09-17", quantity: 8, unit_price: "118.00", line_cost: "944.00" }, { id: 15, task_id: 63, material_id: 2, delivered_on: "2025-08-16", quantity: 58, unit_price: "780.00", line_cost: "45240.00" }, { id: 16, task_id: 104, material_id: 10, delivered_on: "2025-10-08", quantity: 3, unit_price: "165.00", line_cost: "495.00" }, { id: 17, task_id: 73, material_id: 1, delivered_on: "2025-10-15", quantity: 6, unit_price: "118.00", line_cost: "708.00" }, { id: 18, task_id: 101, material_id: 11, delivered_on: "2025-09-23", quantity: 2, unit_price: "5.20", line_cost: "10.40" }, { id: 19, task_id: 114, material_id: 4, delivered_on: "2025-11-13", quantity: 27, unit_price: "640.00", line_cost: "17280.00" }, { id: 20, task_id: 118, material_id: 1, delivered_on: "2025-11-23", quantity: 56, unit_price: "118.00", line_cost: "6608.00" }, { id: 21, task_id: 50, material_id: 6, delivered_on: "2025-06-12", quantity: 31, unit_price: "9.40", line_cost: "291.40" }, { id: 22, task_id: 10, material_id: 2, delivered_on: "2025-06-18", quantity: 2, unit_price: "780.00", line_cost: "1560.00" }, { id: 23, task_id: 111, material_id: 10, delivered_on: "2025-12-25", quantity: 20, unit_price: "165.00", line_cost: "3300.00" }, { id: 24, task_id: 55, material_id: 1, delivered_on: "2025-09-21", quantity: 20, unit_price: "118.00", line_cost: "2360.00" }, { id: 25, task_id: 34, material_id: 6, delivered_on: "2025-05-30", quantity: 27, unit_price: "9.40", line_cost: "253.80" }, { id: 26, task_id: 95, material_id: 5, delivered_on: "2025-10-28", quantity: 7, unit_price: "215.00", line_cost: "1505.00" }, { id: 27, task_id: 11, material_id: 1, delivered_on: "2025-03-22", quantity: 26, unit_price: "118.00", line_cost: "3068.00" }, { id: 28, task_id: 75, material_id: 14, delivered_on: "2025-11-26", quantity: 1, unit_price: "54.00", line_cost: "54.00" }, { id: 29, task_id: 83, material_id: 1, delivered_on: "2025-09-08", quantity: 41, unit_price: "118.00", line_cost: "4838.00" }, { id: 30, task_id: 25, material_id: 12, delivered_on: "2025-08-05", quantity: 1, unit_price: "280.00", line_cost: "280.00" }, { id: 31, task_id: 24, material_id: 13, delivered_on: "2025-08-10", quantity: 4, unit_price: "6.80", line_cost: "27.20" }, { id: 32, task_id: 98, material_id: 1, delivered_on: "2025-12-13", quantity: 24, unit_price: "118.00", line_cost: "2832.00" }, { id: 33, task_id: 19, material_id: 2, delivered_on: "2025-08-09", quantity: 57, unit_price: "780.00", line_cost: "44460.00" }, { id: 34, task_id: 78, material_id: 1, delivered_on: "2025-08-20", quantity: 7, unit_price: "118.00", line_cost: "826.00" }, { id: 35, task_id: 64, material_id: 12, delivered_on: "2025-08-23", quantity: 8, unit_price: "280.00", line_cost: "2240.00" }, { id: 36, task_id: 78, material_id: 9, delivered_on: "2025-09-12", quantity: 54, unit_price: "8.60", line_cost: "464.40" }, { id: 37, task_id: 12, material_id: 6, delivered_on: "2025-05-17", quantity: 19, unit_price: "9.40", line_cost: "178.60" }, { id: 38, task_id: 25, material_id: 10, delivered_on: "2025-08-18", quantity: 21, unit_price: "165.00", line_cost: "3465.00" }, { id: 39, task_id: 60, material_id: 6, delivered_on: "2025-07-21", quantity: 59, unit_price: "9.40", line_cost: "554.60" }, { id: 40, task_id: 103, material_id: 9, delivered_on: "2025-11-18", quantity: 1, unit_price: "8.60", line_cost: "8.60" }, { id: 41, task_id: 43, material_id: 11, delivered_on: "2025-06-16", quantity: 15, unit_price: "5.20", line_cost: "78.00" }, { id: 42, task_id: 30, material_id: 7, delivered_on: "2025-07-05", quantity: 34, unit_price: "21.50", line_cost: "731.00" }, { id: 43, task_id: 49, material_id: 13, delivered_on: "2025-09-18", quantity: 30, unit_price: "6.80", line_cost: "204.00" }, { id: 44, task_id: 65, material_id: 5, delivered_on: "2025-08-11", quantity: 17, unit_price: "215.00", line_cost: "3655.00" }, { id: 45, task_id: 46, material_id: 1, delivered_on: "2025-10-24", quantity: 2, unit_price: "118.00", line_cost: "236.00" }, { id: 46, task_id: 74, material_id: 4, delivered_on: "2025-09-10", quantity: 21, unit_price: "640.00", line_cost: "13440.00" }, { id: 47, task_id: 43, material_id: 4, delivered_on: "2025-07-03", quantity: 47, unit_price: "640.00", line_cost: "30080.00" }, { id: 48, task_id: 117, material_id: 4, delivered_on: "2026-01-21", quantity: 4, unit_price: "640.00", line_cost: "2560.00" }, { id: 49, task_id: 32, material_id: 6, delivered_on: "2025-09-08", quantity: 2, unit_price: "9.40", line_cost: "18.80" }, { id: 50, task_id: 42, material_id: 4, delivered_on: "2025-04-16", quantity: 46, unit_price: "640.00", line_cost: "29440.00" }, { id: 51, task_id: 108, material_id: 1, delivered_on: "2026-01-29", quantity: 9, unit_price: "118.00", line_cost: "1062.00" }, { id: 52, task_id: 87, material_id: 2, delivered_on: "2025-11-05", quantity: 2, unit_price: "780.00", line_cost: "1560.00" }, { id: 53, task_id: 118, material_id: 12, delivered_on: "2025-11-29", quantity: 3, unit_price: "280.00", line_cost: "840.00" }, { id: 54, task_id: 56, material_id: 6, delivered_on: "2025-10-16", quantity: 20, unit_price: "9.40", line_cost: "188.00" }, { id: 55, task_id: 47, material_id: 10, delivered_on: "2025-10-18", quantity: 16, unit_price: "165.00", line_cost: "2640.00" }, { id: 56, task_id: 33, material_id: 5, delivered_on: "2025-05-02", quantity: 4, unit_price: "215.00", line_cost: "860.00" }, { id: 57, task_id: 55, material_id: 11, delivered_on: "2025-09-28", quantity: 30, unit_price: "5.20", line_cost: "156.00" }, { id: 58, task_id: 43, material_id: 11, delivered_on: "2025-06-14", quantity: 14, unit_price: "5.20", line_cost: "72.80" }, { id: 59, task_id: 41, material_id: 8, delivered_on: "2025-06-28", quantity: 1, unit_price: "34.00", line_cost: "34.00" }, { id: 60, task_id: 67, material_id: 1, delivered_on: "2025-08-05", quantity: 5, unit_price: "118.00", line_cost: "590.00" }, { id: 61, task_id: 105, material_id: 2, delivered_on: "2025-12-25", quantity: 1, unit_price: "780.00", line_cost: "780.00" }, { id: 62, task_id: 37, material_id: 9, delivered_on: "2025-05-30", quantity: 16, unit_price: "8.60", line_cost: "137.60" }, { id: 63, task_id: 7, material_id: 1, delivered_on: "2025-06-17", quantity: 40, unit_price: "118.00", line_cost: "4720.00" }, { id: 64, task_id: 59, material_id: 1, delivered_on: "2025-07-27", quantity: 11, unit_price: "118.00", line_cost: "1298.00" }, { id: 65, task_id: 4, material_id: 3, delivered_on: "2025-03-26", quantity: 1, unit_price: "1250.00", line_cost: "1250.00" }, { id: 66, task_id: 17, material_id: 8, delivered_on: "2025-06-11", quantity: 5, unit_price: "34.00", line_cost: "170.00" }, { id: 67, task_id: 110, material_id: 1, delivered_on: "2025-11-26", quantity: 6, unit_price: "118.00", line_cost: "708.00" }, { id: 68, task_id: 101, material_id: 1, delivered_on: "2025-10-02", quantity: 25, unit_price: "118.00", line_cost: "2950.00" }, { id: 69, task_id: 62, material_id: 5, delivered_on: "2025-07-25", quantity: 10, unit_price: "215.00", line_cost: "2150.00" }, { id: 70, task_id: 21, material_id: 5, delivered_on: "2025-04-07", quantity: 31, unit_price: "215.00", line_cost: "6665.00" }, { id: 71, task_id: 52, material_id: 2, delivered_on: "2025-10-23", quantity: 2, unit_price: "780.00", line_cost: "1560.00" }, { id: 72, task_id: 60, material_id: 2, delivered_on: "2025-08-09", quantity: 8, unit_price: "780.00", line_cost: "6240.00" }, { id: 73, task_id: 19, material_id: 10, delivered_on: "2025-07-21", quantity: 8, unit_price: "165.00", line_cost: "1320.00" }, { id: 74, task_id: 108, material_id: 9, delivered_on: "2026-01-12", quantity: 30, unit_price: "8.60", line_cost: "258.00" }, { id: 75, task_id: 80, material_id: 9, delivered_on: "2025-08-22", quantity: 35, unit_price: "8.60", line_cost: "301.00" }, { id: 76, task_id: 96, material_id: 2, delivered_on: "2025-12-07", quantity: 1, unit_price: "780.00", line_cost: "780.00" }, { id: 77, task_id: 35, material_id: 12, delivered_on: "2025-06-07", quantity: 47, unit_price: "280.00", line_cost: "13160.00" }, { id: 78, task_id: 87, material_id: 1, delivered_on: "2025-11-05", quantity: 49, unit_price: "118.00", line_cost: "5782.00" }, { id: 79, task_id: 55, material_id: 3, delivered_on: "2025-09-27", quantity: 10, unit_price: "1250.00", line_cost: "12500.00" }, { id: 80, task_id: 69, material_id: 6, delivered_on: "2025-09-04", quantity: 30, unit_price: "9.40", line_cost: "282.00" }, { id: 81, task_id: 79, material_id: 1, delivered_on: "2025-08-30", quantity: 21, unit_price: "118.00", line_cost: "2478.00" }, { id: 82, task_id: 51, material_id: 11, delivered_on: "2025-06-07", quantity: 1, unit_price: "5.20", line_cost: "5.20" }, { id: 83, task_id: 57, material_id: 1, delivered_on: "2025-07-07", quantity: 1, unit_price: "118.00", line_cost: "118.00" }, { id: 84, task_id: 20, material_id: 1, delivered_on: "2025-07-15", quantity: 7, unit_price: "118.00", line_cost: "826.00" }, { id: 85, task_id: 44, material_id: 11, delivered_on: "2025-05-15", quantity: 33, unit_price: "5.20", line_cost: "171.60" }, { id: 86, task_id: 49, material_id: 4, delivered_on: "2025-09-16", quantity: 7, unit_price: "640.00", line_cost: "4480.00" }, { id: 87, task_id: 30, material_id: 1, delivered_on: "2025-07-04", quantity: 27, unit_price: "118.00", line_cost: "3186.00" }, { id: 88, task_id: 100, material_id: 9, delivered_on: "2025-12-27", quantity: 42, unit_price: "8.60", line_cost: "361.20" }, { id: 89, task_id: 80, material_id: 10, delivered_on: "2025-08-28", quantity: 33, unit_price: "165.00", line_cost: "5445.00" }, { id: 90, task_id: 38, material_id: 4, delivered_on: "2025-09-10", quantity: 15, unit_price: "640.00", line_cost: "9600.00" }, { id: 91, task_id: 59, material_id: 2, delivered_on: "2025-07-27", quantity: 38, unit_price: "780.00", line_cost: "29640.00" }, { id: 92, task_id: 73, material_id: 12, delivered_on: "2025-10-05", quantity: 18, unit_price: "280.00", line_cost: "5040.00" }, { id: 93, task_id: 9, material_id: 1, delivered_on: "2025-03-27", quantity: 52, unit_price: "118.00", line_cost: "6136.00" }, { id: 94, task_id: 94, material_id: 14, delivered_on: "2025-11-04", quantity: 57, unit_price: "54.00", line_cost: "3078.00" }, { id: 95, task_id: 45, material_id: 1, delivered_on: "2025-06-29", quantity: 51, unit_price: "118.00", line_cost: "6018.00" }, { id: 96, task_id: 59, material_id: 4, delivered_on: "2025-07-26", quantity: 14, unit_price: "640.00", line_cost: "8960.00" }, { id: 97, task_id: 56, material_id: 3, delivered_on: "2025-09-27", quantity: 5, unit_price: "1250.00", line_cost: "6250.00" }, { id: 98, task_id: 57, material_id: 7, delivered_on: "2025-07-08", quantity: 8, unit_price: "21.50", line_cost: "172.00" }, { id: 99, task_id: 32, material_id: 9, delivered_on: "2025-09-01", quantity: 20, unit_price: "8.60", line_cost: "172.00" }, { id: 100, task_id: 89, material_id: 14, delivered_on: "2025-10-16", quantity: 2, unit_price: "54.00", line_cost: "108.00" }, { id: 101, task_id: 17, material_id: 10, delivered_on: "2025-06-06", quantity: 1, unit_price: "165.00", line_cost: "165.00" }, { id: 102, task_id: 103, material_id: 1, delivered_on: "2025-10-29", quantity: 43, unit_price: "118.00", line_cost: "5074.00" }, { id: 103, task_id: 51, material_id: 7, delivered_on: "2025-06-20", quantity: 32, unit_price: "21.50", line_cost: "688.00" }, { id: 104, task_id: 4, material_id: 4, delivered_on: "2025-03-14", quantity: 48, unit_price: "640.00", line_cost: "30720.00" }, { id: 105, task_id: 72, material_id: 13, delivered_on: "2025-09-05", quantity: 6, unit_price: "6.80", line_cost: "40.80" }, { id: 106, task_id: 21, material_id: 2, delivered_on: "2025-04-03", quantity: 18, unit_price: "780.00", line_cost: "14040.00" }, { id: 107, task_id: 100, material_id: 2, delivered_on: "2026-01-06", quantity: 28, unit_price: "780.00", line_cost: "21840.00" }, { id: 108, task_id: 104, material_id: 9, delivered_on: "2025-10-07", quantity: 32, unit_price: "8.60", line_cost: "275.20" }, { id: 109, task_id: 32, material_id: 2, delivered_on: "2025-08-22", quantity: 35, unit_price: "780.00", line_cost: "27300.00" }, { id: 110, task_id: 46, material_id: 9, delivered_on: "2025-10-20", quantity: 27, unit_price: "8.60", line_cost: "232.20" }, { id: 111, task_id: 26, material_id: 7, delivered_on: "2025-04-30", quantity: 8, unit_price: "21.50", line_cost: "172.00" }, { id: 112, task_id: 17, material_id: 3, delivered_on: "2025-05-18", quantity: 16, unit_price: "1250.00", line_cost: "20000.00" }, { id: 113, task_id: 3, material_id: 7, delivered_on: "2025-04-27", quantity: 11, unit_price: "21.50", line_cost: "236.50" }, { id: 114, task_id: 63, material_id: 14, delivered_on: "2025-08-09", quantity: 16, unit_price: "54.00", line_cost: "864.00" }, { id: 115, task_id: 56, material_id: 1, delivered_on: "2025-10-01", quantity: 4, unit_price: "118.00", line_cost: "472.00" }, { id: 116, task_id: 79, material_id: 2, delivered_on: "2025-09-09", quantity: 5, unit_price: "780.00", line_cost: "3900.00" }, { id: 117, task_id: 31, material_id: 3, delivered_on: "2025-09-03", quantity: 19, unit_price: "1250.00", line_cost: "23750.00" }, { id: 118, task_id: 94, material_id: 6, delivered_on: "2025-11-11", quantity: 32, unit_price: "9.40", line_cost: "300.80" }, { id: 119, task_id: 114, material_id: 2, delivered_on: "2025-11-16", quantity: 12, unit_price: "780.00", line_cost: "9360.00" }, { id: 120, task_id: 92, material_id: 3, delivered_on: "2025-10-26", quantity: 10, unit_price: "1250.00", line_cost: "12500.00" }, { id: 121, task_id: 82, material_id: 12, delivered_on: "2025-09-27", quantity: 53, unit_price: "280.00", line_cost: "14840.00" }, { id: 122, task_id: 41, material_id: 7, delivered_on: "2025-06-26", quantity: 6, unit_price: "21.50", line_cost: "129.00" }, { id: 123, task_id: 26, material_id: 2, delivered_on: "2025-04-20", quantity: 2, unit_price: "780.00", line_cost: "1560.00" }, { id: 124, task_id: 87, material_id: 1, delivered_on: "2025-11-01", quantity: 15, unit_price: "118.00", line_cost: "1770.00" }, { id: 125, task_id: 83, material_id: 1, delivered_on: "2025-09-23", quantity: 2, unit_price: "118.00", line_cost: "236.00" }, { id: 126, task_id: 44, material_id: 5, delivered_on: "2025-05-11", quantity: 2, unit_price: "215.00", line_cost: "430.00" }, { id: 127, task_id: 98, material_id: 1, delivered_on: "2025-12-08", quantity: 6, unit_price: "118.00", line_cost: "708.00" }, { id: 128, task_id: 3, material_id: 3, delivered_on: "2025-05-07", quantity: 1, unit_price: "1250.00", line_cost: "1250.00" }, { id: 129, task_id: 109, material_id: 2, delivered_on: "2025-11-10", quantity: 23, unit_price: "780.00", line_cost: "17940.00" }, { id: 130, task_id: 61, material_id: 1, delivered_on: "2025-07-24", quantity: 11, unit_price: "118.00", line_cost: "1298.00" }, { id: 131, task_id: 111, material_id: 1, delivered_on: "2025-12-06", quantity: 32, unit_price: "118.00", line_cost: "3776.00" }, { id: 132, task_id: 3, material_id: 8, delivered_on: "2025-05-16", quantity: 14, unit_price: "34.00", line_cost: "476.00" }, { id: 133, task_id: 119, material_id: 1, delivered_on: "2026-01-19", quantity: 13, unit_price: "118.00", line_cost: "1534.00" }, { id: 134, task_id: 18, material_id: 14, delivered_on: "2025-07-31", quantity: 1, unit_price: "54.00", line_cost: "54.00" }, { id: 135, task_id: 74, material_id: 4, delivered_on: "2025-09-18", quantity: 13, unit_price: "640.00", line_cost: "8320.00" }, { id: 136, task_id: 105, material_id: 5, delivered_on: "2026-01-10", quantity: 57, unit_price: "215.00", line_cost: "12255.00" }, { id: 137, task_id: 101, material_id: 2, delivered_on: "2025-09-22", quantity: 12, unit_price: "780.00", line_cost: "9360.00" }, { id: 138, task_id: 109, material_id: 1, delivered_on: "2025-10-20", quantity: 26, unit_price: "118.00", line_cost: "3068.00" }, { id: 139, task_id: 117, material_id: 12, delivered_on: "2026-02-05", quantity: 43, unit_price: "280.00", line_cost: "12040.00" }, { id: 140, task_id: 8, material_id: 1, delivered_on: "2025-03-09", quantity: 39, unit_price: "118.00", line_cost: "4602.00" }, { id: 141, task_id: 42, material_id: 4, delivered_on: "2025-05-13", quantity: 41, unit_price: "640.00", line_cost: "26240.00" }, { id: 142, task_id: 24, material_id: 14, delivered_on: "2025-08-12", quantity: 13, unit_price: "54.00", line_cost: "702.00" }, { id: 143, task_id: 82, material_id: 6, delivered_on: "2025-09-24", quantity: 3, unit_price: "9.40", line_cost: "28.20" }, { id: 144, task_id: 105, material_id: 5, delivered_on: "2026-01-21", quantity: 14, unit_price: "215.00", line_cost: "3010.00" }, { id: 145, task_id: 46, material_id: 8, delivered_on: "2025-10-19", quantity: 22, unit_price: "34.00", line_cost: "748.00" }, { id: 146, task_id: 104, material_id: 4, delivered_on: "2025-10-11", quantity: 1, unit_price: "640.00", line_cost: "640.00" }, { id: 147, task_id: 94, material_id: 6, delivered_on: "2025-11-06", quantity: 16, unit_price: "9.40", line_cost: "150.40" }, { id: 148, task_id: 92, material_id: 1, delivered_on: "2025-11-08", quantity: 17, unit_price: "118.00", line_cost: "2006.00" }, { id: 149, task_id: 84, material_id: 14, delivered_on: "2025-08-27", quantity: 4, unit_price: "54.00", line_cost: "216.00" }, { id: 150, task_id: 1, material_id: 5, delivered_on: "2025-06-15", quantity: 1, unit_price: "215.00", line_cost: "215.00" }, { id: 151, task_id: 110, material_id: 1, delivered_on: "2025-12-09", quantity: 8, unit_price: "118.00", line_cost: "944.00" }, { id: 152, task_id: 100, material_id: 2, delivered_on: "2025-12-16", quantity: 17, unit_price: "780.00", line_cost: "13260.00" }, { id: 153, task_id: 65, material_id: 2, delivered_on: "2025-08-08", quantity: 2, unit_price: "780.00", line_cost: "1560.00" }, { id: 154, task_id: 79, material_id: 1, delivered_on: "2025-09-11", quantity: 25, unit_price: "118.00", line_cost: "2950.00" }, { id: 155, task_id: 40, material_id: 3, delivered_on: "2025-05-27", quantity: 25, unit_price: "1250.00", line_cost: "31250.00" }, { id: 156, task_id: 62, material_id: 2, delivered_on: "2025-07-26", quantity: 3, unit_price: "780.00", line_cost: "2340.00" }, { id: 157, task_id: 5, material_id: 3, delivered_on: "2025-02-15", quantity: 50, unit_price: "1250.00", line_cost: "62500.00" }, { id: 158, task_id: 83, material_id: 1, delivered_on: "2025-09-17", quantity: 4, unit_price: "118.00", line_cost: "472.00" }, { id: 159, task_id: 85, material_id: 10, delivered_on: "2025-09-30", quantity: 44, unit_price: "165.00", line_cost: "7260.00" }, { id: 160, task_id: 7, material_id: 1, delivered_on: "2025-07-13", quantity: 3, unit_price: "118.00", line_cost: "354.00" }, { id: 161, task_id: 64, material_id: 3, delivered_on: "2025-07-31", quantity: 1, unit_price: "1250.00", line_cost: "1250.00" }, { id: 162, task_id: 41, material_id: 1, delivered_on: "2025-06-02", quantity: 30, unit_price: "118.00", line_cost: "3540.00" }, { id: 163, task_id: 84, material_id: 6, delivered_on: "2025-09-03", quantity: 55, unit_price: "9.40", line_cost: "517.00" }, { id: 164, task_id: 67, material_id: 1, delivered_on: "2025-08-04", quantity: 2, unit_price: "118.00", line_cost: "236.00" }, { id: 165, task_id: 6, material_id: 1, delivered_on: "2025-02-21", quantity: 20, unit_price: "118.00", line_cost: "2360.00" }, { id: 166, task_id: 9, material_id: 1, delivered_on: "2025-03-30", quantity: 25, unit_price: "118.00", line_cost: "2950.00" }, { id: 167, task_id: 73, material_id: 5, delivered_on: "2025-10-18", quantity: 8, unit_price: "215.00", line_cost: "1720.00" }, { id: 168, task_id: 26, material_id: 6, delivered_on: "2025-04-19", quantity: 13, unit_price: "9.40", line_cost: "122.20" }, { id: 169, task_id: 34, material_id: 4, delivered_on: "2025-06-07", quantity: 23, unit_price: "640.00", line_cost: "14720.00" }, ], }); } main() .then(() => prisma.$disconnect()) .catch(async error => { console.error(error); await prisma.$disconnect(); process.exit(1); });