-- EXPOTEX PROJECTS + TRANSACTIONS — DOCUMENT-GROUNDED IMPORT
-- Generated from the supplied invoices, bank incoming-payment statement, client agreements and Dclothingsplug quotation.
-- Rule: invoice-backed project_date/start_date equals the exact transaction/invoice date.
-- completion_date is NULL unless the supplied documents explicitly state an exact completion date; no dates are invented.
-- Dclothingsplug is quotation-only because no matching £1,100.00 incoming payment was found in the supplied incoming-payment statement.

DELETE FROM project_payments;
DELETE FROM projects;
ALTER TABLE projects AUTO_INCREMENT = 1;
ALTER TABLE project_payments AUTO_INCREMENT = 1;

INSERT INTO projects (project_title, slug, client_name, project_location, project_type, contract_value, start_date, completion_date, status, description, scope_of_work, featured) VALUES
('IT Consulting Services', 'it-consulting-services-sophia-mighty-inv-0062', 'Sophia Mighty', NULL, 'IT Consulting Services', NULL, '2026-02-09', NULL, 'completed', 'Source invoice INV-0062, dated 09 February 2026. Client: Sophia Mighty. Service: IT Consulting Services. Bank reference: Direct Credit. Amount paid: £23.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Consulting Services', 0),
('IT Support and Consultancy', 'it-support-and-consultancy-abdillahi-ma-inv-0063', 'Abdillahi MA', NULL, 'IT Support and Consultancy', NULL, '2026-02-12', NULL, 'completed', 'Source invoice INV-0063, dated 12 February 2026. Client: Abdillahi MA. Service: IT Support and Consultancy. Bank reference: Expetex. Amount paid: £65.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Support and Consultancy', 0),
('IT Infrastructure Consultancy', 'it-infrastructure-consultancy-adedapo-o-inv-0064', 'Adedapo O', NULL, 'IT Infrastructure Consultancy', NULL, '2026-02-12', NULL, 'completed', 'Source invoice INV-0064, dated 12 February 2026. Client: Adedapo O. Service: IT Infrastructure Consultancy. Bank reference: IT Consult. Amount paid: £100.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Infrastructure Consultancy', 0),
('IT Technical Support & Consultation', 'it-technical-support-consultation-agiliga-okorodudu-inv-0065', 'Agiliga Okorodudu', NULL, 'IT Technical Support & Consultation', NULL, '2026-02-16', NULL, 'completed', 'Source invoice INV-0065, dated 16 February 2026. Client: Agiliga Okorodudu. Service: IT Technical Support & Consultation. Bank reference: IT Consultation. Amount paid: £100.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Technical Support & Consultation', 0),
('IT Booster Services & Software Support', 'it-booster-services-software-support-m-essien-inv-0066', 'M Essien', NULL, 'IT Booster Services & Software Support', NULL, '2026-02-16', NULL, 'completed', 'Source invoice INV-0066, dated 16 February 2026. Client: M Essien. Service: IT Booster Services & Software Support. Bank reference: Pymnt4ITbooster. Amount paid: £400.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Booster Services & Software Support', 0),
('Balance Payment - IT Consultancy Services', 'balance-payment-it-consultancy-services-agiliga-okorodudu-inv-0067', 'Agiliga Okorodudu', NULL, 'Balance Payment - IT Consultancy Services', NULL, '2026-02-18', NULL, 'completed', 'Source invoice INV-0067, dated 18 February 2026. Client: Agiliga Okorodudu. Service: Balance Payment - IT Consultancy Services. Bank reference: Bal IT Consultatn. Amount paid: £50.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Balance Payment - IT Consultancy Services', 0),
('Technical Consulting & Advisory', 'technical-consulting-advisory-rachael-badejo-inv-0068', 'Rachael Badejo', NULL, 'Technical Consulting & Advisory', NULL, '2026-02-19', NULL, 'completed', 'Source invoice INV-0068, dated 19 February 2026. Client: Rachael Badejo. Service: Technical Consulting & Advisory. Bank reference: Refund. Amount paid: £125.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Consulting & Advisory', 0),
('Technical Consultation Services', 'technical-consultation-services-b-akpan-inv-0069', 'B Akpan', NULL, 'Technical Consultation Services', NULL, '2026-02-20', NULL, 'completed', 'Source invoice INV-0069, dated 20 February 2026. Client: B Akpan. Service: Technical Consultation Services. Bank reference: Consultation. Amount paid: £300.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Consultation Services', 0),
('Technical Support & Systems Maintenance', 'technical-support-systems-maintenance-okolie-a-inv-0070', 'Okolie A', NULL, 'Technical Support & Systems Maintenance', NULL, '2026-02-20', NULL, 'completed', 'Source invoice INV-0070, dated 20 February 2026. Client: Okolie A. Service: Technical Support & Systems Maintenance. Bank reference: Payment4Techsupert. Amount paid: £200.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Support & Systems Maintenance', 0),
('IT Services & Infrastructure Maintenance', 'it-services-infrastructure-maintenance-essien-a-inv-0071', 'Essien A', NULL, 'IT Services & Infrastructure Maintenance', NULL, '2026-02-24', NULL, 'completed', 'Source invoice INV-0071, dated 24 February 2026. Client: Essien A. Service: IT Services & Infrastructure Maintenance. Bank reference: IT Services. Amount paid: £500.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Services & Infrastructure Maintenance', 0),
('IT Support & Technical Services', 'it-support-technical-services-adedayo-adelowo-inv-0072', 'Adedayo Adelowo', NULL, 'IT Support & Technical Services', NULL, '2026-02-26', NULL, 'completed', 'Source invoice INV-0072, dated 26 February 2026. Client: Adedayo Adelowo. Service: IT Support & Technical Services. Bank reference: Pymt 4 IT Service. Amount paid: £500.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Support & Technical Services', 0),
('IT Services & Systems Support', 'it-services-systems-support-andrew-mbukwa-inv-0073', 'Andrew Mbukwa', NULL, 'IT Services & Systems Support', NULL, '2026-02-26', NULL, 'completed', 'Source invoice INV-0073, dated 26 February 2026. Client: Andrew Mbukwa. Service: IT Services & Systems Support. Bank reference: Pymt4ITservices. Amount paid: £500.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Services & Systems Support', 0),
('Technical Consulting & Advisory Services', 'technical-consulting-advisory-services-zainab-adekale-inv-0074', 'Zainab Adekale', NULL, 'Technical Consulting & Advisory Services', NULL, '2026-02-26', NULL, 'completed', 'Source invoice INV-0074, dated 26 February 2026. Client: Zainab Adekale. Service: Technical Consulting & Advisory Services. Bank reference: Pymt4Osusu. Amount paid: £700.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Consulting & Advisory Services', 0),
('IT Infrastructure Consultancy', 'it-infrastructure-consultancy-u-ugloro-inv-0075', 'U Ugloro', NULL, 'IT Infrastructure Consultancy', NULL, '2026-02-26', NULL, 'completed', 'Source invoice INV-0075, dated 26 February 2026. Client: U Ugloro. Service: IT Infrastructure Consultancy. Bank reference: IT Consultation. Amount paid: £1,000.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Infrastructure Consultancy', 0),
('IT Software Support & Systems Maintenance', 'it-software-support-systems-maintenance-m-essien-inv-0076', 'M Essien', NULL, 'IT Software Support & Systems Maintenance', NULL, '2026-03-02', NULL, 'completed', 'Source invoice INV-0076, dated 02 March 2026. Client: M Essien. Service: IT Software Support & Systems Maintenance. Bank reference: Pymt4ITsoftware. Amount paid: £700.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Software Support & Systems Maintenance', 0),
('IT Technical Services & System Support', 'it-technical-services-system-support-a-dibie-inv-0077', 'A Dibie', NULL, 'IT Technical Services & System Support', NULL, '2026-03-02', NULL, 'completed', 'Source invoice INV-0077, dated 02 March 2026. Client: A Dibie. Service: IT Technical Services & System Support. Bank reference: IT Service. Amount paid: £700.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Technical Services & System Support', 0),
('IT Support & Infrastructure Maintenance', 'it-support-infrastructure-maintenance-o-okunade-inv-0078', 'O Okunade', NULL, 'IT Support & Infrastructure Maintenance', NULL, '2026-03-02', NULL, 'completed', 'Source invoice INV-0078, dated 02 March 2026. Client: O Okunade. Service: IT Support & Infrastructure Maintenance. Bank reference: IT Services. Amount paid: £700.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Support & Infrastructure Maintenance', 0),
('IT Equipment & Software Supply', 'it-equipment-software-supply-e-omoruyi-inv-0079', 'E Omoruyi', NULL, 'IT Equipment & Software Supply', NULL, '2026-03-03', NULL, 'completed', 'Source invoice INV-0079, dated 03 March 2026. Client: E Omoruyi. Service: IT Equipment & Software Supply. Bank reference: IT Supply. Amount paid: £2,000.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Equipment & Software Supply', 0),
('IT Services & Technical Support', 'it-services-technical-support-m-essien-inv-0080', 'M Essien', NULL, 'IT Services & Technical Support', NULL, '2026-03-06', NULL, 'completed', 'Source invoice INV-0080, dated 06 March 2026. Client: M Essien. Service: IT Services & Technical Support. Bank reference: Pymt4ITservices. Amount paid: £450.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Services & Technical Support', 0),
('Logistics Technology Consultancy', 'logistics-technology-consultancy-agiliga-okorodudu-inv-0081', 'Agiliga Okorodudu', NULL, 'Logistics Technology Consultancy', NULL, '2026-03-20', NULL, 'completed', 'Source invoice INV-0081, dated 20 March 2026. Client: Agiliga Okorodudu. Service: Logistics Technology Consultancy. Bank reference: Pay For Logistics. Amount paid: £200.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Logistics Technology Consultancy', 0),
('Logistics Systems Support', 'logistics-systems-support-agiliga-okorodudu-inv-0082', 'Agiliga Okorodudu', NULL, 'Logistics Systems Support', NULL, '2026-03-23', NULL, 'completed', 'Source invoice INV-0082, dated 23 March 2026. Client: Agiliga Okorodudu. Service: Logistics Systems Support. Bank reference: Pay For Logistics. Amount paid: £300.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Logistics Systems Support', 0),
('IT Consultancy & Systems Support', 'it-consultancy-systems-support-m-essien-inv-0083', 'M Essien', NULL, 'IT Consultancy & Systems Support', NULL, '2026-03-23', NULL, 'completed', 'Source invoice INV-0083, dated 23 March 2026. Client: M Essien. Service: IT Consultancy & Systems Support. Bank reference: Pymt4ITclodstareg. Amount paid: £300.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Consultancy & Systems Support', 0),
('Technical Support Services', 'technical-support-services-okutubo-a-inv-0084', 'Okutubo A', NULL, 'Technical Support Services', NULL, '2026-03-25', NULL, 'completed', 'Source invoice INV-0084, dated 25 March 2026. Client: Okutubo A. Service: Technical Support Services. Bank reference: Pymt4Teachsupport. Amount paid: £100.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Support Services', 0),
('IT Support & Systems Maintenance', 'it-support-systems-maintenance-zainab-adekale-inv-0085', 'Zainab Adekale', NULL, 'IT Support & Systems Maintenance', NULL, '2026-03-26', NULL, 'completed', 'Source invoice INV-0085, dated 26 March 2026. Client: Zainab Adekale. Service: IT Support & Systems Maintenance. Bank reference: Pymt4Osusu. Amount paid: £700.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Support & Systems Maintenance', 0),
('Technical Support Services', 'technical-support-services-henshaw-etukudoh-inv-0086', 'Henshaw Etukudoh', NULL, 'Technical Support Services', NULL, '2026-03-27', NULL, 'completed', 'Source invoice INV-0086, dated 27 March 2026. Client: Henshaw Etukudoh. Service: Technical Support Services. Bank reference: Pymt4Teachsupport. Amount paid: £105.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Support Services', 0),
('Technical Support & Troubleshooting', 'technical-support-troubleshooting-i-oriuwa-inv-0087', 'I Oriuwa', NULL, 'Technical Support & Troubleshooting', NULL, '2026-03-30', NULL, 'completed', 'Source invoice INV-0087, dated 30 March 2026. Client: I Oriuwa. Service: Technical Support & Troubleshooting. Bank reference: Pymt4Teachsupport. Amount paid: £250.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Support & Troubleshooting', 0),
('Technical Support Services', 'technical-support-services-a-ajoku-inv-0088', 'A Ajoku', NULL, 'Technical Support Services', NULL, '2026-03-30', NULL, 'completed', 'Source invoice INV-0088, dated 30 March 2026. Client: A Ajoku. Service: Technical Support Services. Bank reference: Pymt4Teachsupport. Amount paid: £700.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Support Services', 0),
('IT Supply & Support Services', 'it-supply-support-services-efosa-omoruyi-inv-0089', 'Efosa Omoruyi', NULL, 'IT Supply & Support Services', NULL, '2026-04-01', NULL, 'completed', 'Source invoice INV-0089, dated 01 April 2026. Client: Efosa Omoruyi. Service: IT Supply & Support Services. Bank reference: Bal IT Supply. Amount paid: £300.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Supply & Support Services', 0),
('IT Infrastructure Consultancy', 'it-infrastructure-consultancy-henry-plus-inv-0090', 'Henry Plus', NULL, 'IT Infrastructure Consultancy', NULL, '2026-04-20', NULL, 'completed', 'Source invoice INV-0090, dated 20 April 2026. Client: Henry Plus. Service: IT Infrastructure Consultancy. Bank reference: IT Consultation. Amount paid: £205.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Infrastructure Consultancy', 0),
('IT Consulting Services', 'it-consulting-services-pamela-ojotule-wak-inv-0091', 'Pamela Ojotule Wak', NULL, 'IT Consulting Services', NULL, '2026-04-20', NULL, 'completed', 'Source invoice INV-0091, dated 20 April 2026. Client: Pamela Ojotule Wak. Service: IT Consulting Services. Bank reference: Consulting. Amount paid: £300.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Consulting Services', 0),
('IT Consultancy & Technical Advisory', 'it-consultancy-technical-advisory-o-lawal-inv-0092', 'O Lawal', NULL, 'IT Consultancy & Technical Advisory', NULL, '2026-04-20', NULL, 'completed', 'Source invoice INV-0092, dated 20 April 2026. Client: O Lawal. Service: IT Consultancy & Technical Advisory. Bank reference: IT Consultation. Amount paid: £300.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Consultancy & Technical Advisory', 0),
('Cloud Infrastructure & Hosting Services', 'cloud-infrastructure-hosting-services-akpevwe-ejoh-inv-0093', 'Akpevwe Ejoh', NULL, 'Cloud Infrastructure & Hosting Services', NULL, '2026-04-22', NULL, 'completed', 'Source invoice INV-0093, dated 22 April 2026. Client: Akpevwe Ejoh. Service: Cloud Infrastructure & Hosting Services. Bank reference: Cloud Services. Amount paid: £420.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Cloud Infrastructure & Hosting Services', 0),
('IT Technical Support & Services', 'it-technical-support-services-zainab-adekale-inv-0094', 'Zainab Adekale', NULL, 'IT Technical Support & Services', NULL, '2026-04-24', NULL, 'completed', 'Source invoice INV-0094, dated 24 April 2026. Client: Zainab Adekale. Service: IT Technical Support & Services. Bank reference: Pymt4Osusu. Amount paid: £700.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Technical Support & Services', 0),
('System Implementation & Software Integration Contract', 'system-implementation-software-integration-contract-evolux-solutions-ltd-slex-inv-0095', 'Evolux Solutions Ltd (Slex)', NULL, 'System Implementation & Software Integration Contract', NULL, '2026-04-28', NULL, 'completed', 'Source invoice INV-0095, dated 28 April 2026. Client: Evolux Solutions Ltd (Slex). Service: System Implementation & Software Integration Contract. Bank reference: System Implementat. Amount paid: £5,000.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'System Implementation & Software Integration Contract', 0),
('System Deployment & Technical Configuration', 'system-deployment-technical-configuration-oluwafemi-adebiyi-inv-0096', 'Oluwafemi Adebiyi', NULL, 'System Deployment & Technical Configuration', NULL, '2026-04-30', NULL, 'completed', 'Source invoice INV-0096, dated 30 April 2026. Client: Oluwafemi Adebiyi. Service: System Deployment & Technical Configuration. Bank reference: Deployment/Sys. Amount paid: £750.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'System Deployment & Technical Configuration', 0),
('IT Services & Consultation', 'it-services-consultation-arieke-chinenye-inv-0097', 'Arieke Chinenye', NULL, 'IT Services & Consultation', NULL, '2026-05-05', NULL, 'completed', 'Source invoice INV-0097, dated 05 May 2026. Client: Arieke Chinenye. Service: IT Services & Consultation. Bank reference: Expo Pwrns. Amount paid: £15.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Services & Consultation', 0),
('Technical Services', 'technical-services-chisom-jim-inv-0098', 'Chisom Jim', NULL, 'Technical Services', NULL, '2026-05-05', NULL, 'completed', 'Source invoice INV-0098, dated 05 May 2026. Client: Chisom Jim. Service: Technical Services. Bank reference: Expo Pwrns. Amount paid: £10.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Services', 0),
('IT Support Services', 'it-support-services-arieke-chinenye-inv-0099', 'Arieke Chinenye', NULL, 'IT Support Services', NULL, '2026-05-05', NULL, 'completed', 'Source invoice INV-0099, dated 05 May 2026. Client: Arieke Chinenye. Service: IT Support Services. Bank reference: Expo Pwrns. Amount paid: £35.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Support Services', 0),
('IT Support Services', 'it-support-services-chisom-jim-inv-0100', 'Chisom Jim', NULL, 'IT Support Services', NULL, '2026-05-06', NULL, 'completed', 'Source invoice INV-0100, dated 06 May 2026. Client: Chisom Jim. Service: IT Support Services. Bank reference: Expo Pwrns. Amount paid: £5.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Support Services', 0),
('Technical Services', 'technical-services-o-akanbi-inv-0101', 'O Akanbi', NULL, 'Technical Services', NULL, '2026-05-06', NULL, 'completed', 'Source invoice INV-0101, dated 06 May 2026. Client: O Akanbi. Service: Technical Services. Bank reference: Expo Pwrns. Amount paid: £25.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Services', 0),
('IT Support Services', 'it-support-services-norberta-aquse-inv-0102', 'Norberta Aquse', NULL, 'IT Support Services', NULL, '2026-05-07', NULL, 'completed', 'Source invoice INV-0102, dated 07 May 2026. Client: Norberta Aquse. Service: IT Support Services. Bank reference: Expo Pwrns. Amount paid: £48.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Support Services', 0),
('Technical Services', 'technical-services-erieghwea-r-inv-0103', 'Erieghwea R', NULL, 'Technical Services', NULL, '2026-05-07', NULL, 'completed', 'Source invoice INV-0103, dated 07 May 2026. Client: Erieghwea R. Service: Technical Services. Bank reference: Expo Pwrns. Amount paid: £173.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Services', 0),
('IT Consultancy & Technical Support', 'it-consultancy-technical-support-jenifer-eyituoyo-inv-0104', 'Jenifer Eyituoyo', NULL, 'IT Consultancy & Technical Support', NULL, '2026-05-18', NULL, 'completed', 'Source invoice INV-0104, dated 18 May 2026. Client: Jenifer Eyituoyo. Service: IT Consultancy & Technical Support. Bank reference: IT Consultation. Amount paid: £340.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Consultancy & Technical Support', 0),
('IT Support & Technical Services', 'it-support-technical-services-m-ihe-nwoku-inv-0105', 'M Ihe Nwoku', NULL, 'IT Support & Technical Services', NULL, '2026-05-18', NULL, 'completed', 'Source invoice INV-0105, dated 18 May 2026. Client: M Ihe Nwoku. Service: IT Support & Technical Services. Bank reference: IT Consult. Amount paid: £500.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Support & Technical Services', 0),
('IT Consultancy & Infrastructure Services', 'it-consultancy-infrastructure-services-pamco-limited-inv-0106', 'Pamco Limited', NULL, 'IT Consultancy & Infrastructure Services', NULL, '2026-05-21', NULL, 'completed', 'Source invoice INV-0106, dated 21 May 2026. Client: Pamco Limited. Service: IT Consultancy & Infrastructure Services. Bank reference: IT Consult. Amount paid: £340.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Consultancy & Infrastructure Services', 0),
('IT Consultancy Services', 'it-consultancy-services-oluwaseun-thompson-inv-0107', 'Oluwaseun Thompson', NULL, 'IT Consultancy Services', NULL, '2026-05-26', NULL, 'completed', 'Source invoice INV-0107, dated 26 May 2026. Client: Oluwaseun Thompson. Service: IT Consultancy Services. Bank reference: IT Consult. Amount paid: £200.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Consultancy Services', 0),
('IT Support & Consultation', 'it-support-consultation-e-osaro-inv-0108', 'E Osaro', NULL, 'IT Support & Consultation', NULL, '2026-05-26', NULL, 'completed', 'Source invoice INV-0108, dated 26 May 2026. Client: E Osaro. Service: IT Support & Consultation. Bank reference: IT Consultation. Amount paid: £200.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Support & Consultation', 0),
('IT Support & Technical Advice', 'it-support-technical-advice-o-lawal-inv-0109', 'O Lawal', NULL, 'IT Support & Technical Advice', NULL, '2026-05-27', NULL, 'completed', 'Source invoice INV-0109, dated 27 May 2026. Client: O Lawal. Service: IT Support & Technical Advice. Bank reference: IT Consultation. Amount paid: £300.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Support & Technical Advice', 0),
('Technical Services', 'technical-services-o-odiyi-inv-0110', 'O Odiyi', NULL, 'Technical Services', NULL, '2026-05-29', NULL, 'completed', 'Source invoice INV-0110, dated 29 May 2026. Client: O Odiyi. Service: Technical Services. Bank reference: Expo Pwrns. Amount paid: £35.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Services', 0),
('Technical Support Services', 'technical-support-services-v-akande-inv-0111', 'V Akande', NULL, 'Technical Support Services', NULL, '2026-05-29', NULL, 'completed', 'Source invoice INV-0111, dated 29 May 2026. Client: V Akande. Service: Technical Support Services. Bank reference: Expo Pwrns. Amount paid: £295.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Support Services', 0),
('IT Support & Technical Services', 'it-support-technical-services-agiliga-okorodudu-inv-0112', 'Agiliga Okorodudu', NULL, 'IT Support & Technical Services', NULL, '2026-06-01', NULL, 'completed', 'Source invoice INV-0112, dated 01 June 2026. Client: Agiliga Okorodudu. Service: IT Support & Technical Services. Bank reference: Expo Pwrns. Amount paid: £55.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Support & Technical Services', 0),
('System Support & Maintenance', 'system-support-maintenance-mero-chioma-opute-inv-0113', 'Mero Chioma Opute', NULL, 'System Support & Maintenance', NULL, '2026-06-01', NULL, 'ongoing', 'Source invoice INV-0113, dated 01 June 2026. Client: Mero Chioma Opute. Service: System Support & Maintenance. Bank reference: Suport&Maintenance. Amount paid: £700.00. Invoice status: PAID. Project completion date is not separately stated in the invoice. The separate client service agreement is dated 15 June 2026 and records an ongoing support and maintenance relationship.', 'System Support & Maintenance', 0),
('Technical Support Services', 'technical-support-services-a-ajoku-inv-0114', 'A Ajoku', NULL, 'Technical Support Services', NULL, '2026-06-01', NULL, 'completed', 'Source invoice INV-0114, dated 01 June 2026. Client: A Ajoku. Service: Technical Support Services. Bank reference: Pymt4Teachsupport. Amount paid: £700.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Support Services', 0),
('Technical Support Services', 'technical-support-services-o-animashaun-inv-0115', 'O Animashaun', NULL, 'Technical Support Services', NULL, '2026-06-19', NULL, 'completed', 'Source invoice INV-0115, dated 19 June 2026. Client: O Animashaun. Service: Technical Support Services. Bank reference: Expo Prwn. Amount paid: £47.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Support Services', 0),
('IT Support & Consulting Services', 'it-support-consulting-services-zainab-adekale-inv-0116', 'Zainab Adekale', NULL, 'IT Support & Consulting Services', NULL, '2026-06-26', NULL, 'completed', 'Source invoice INV-0116, dated 26 June 2026. Client: Zainab Adekale. Service: IT Support & Consulting Services. Bank reference: Paymt4Osusu. Amount paid: £700.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'IT Support & Consulting Services', 0),
('System Maintenance & Technical Support', 'system-maintenance-technical-support-african-convenient-shop-inv-0117', 'African Convenient Shop', '80 East Street, Bedminster, Bristol, Avon, BS3 4EY', 'System Maintenance & Technical Support', NULL, '2026-06-29', NULL, 'ongoing', 'Source invoice INV-0117, dated 29 June 2026. Client: African Convenient Shop. Service: System Maintenance & Technical Support. Bank reference: System Maintains. Amount paid: £500.00. Invoice status: PAID. Project completion date is not separately stated in the invoice. The separate service agreement is dated 15 June 2026 and describes an ongoing technical support and system maintenance relationship.', 'System Maintenance & Technical Support', 0),
('System Maintenance & Issue Resolution', 'system-maintenance-issue-resolution-african-convenient-shop-inv-0118', 'African Convenient Shop', '80 East Street, Bedminster, Bristol, Avon, BS3 4EY', 'System Maintenance & Issue Resolution', NULL, '2026-07-01', NULL, 'ongoing', 'Source invoice INV-0118, dated 01 July 2026. Client: African Convenient Shop. Service: System Maintenance & Issue Resolution. Bank reference: System Maintains. Amount paid: £240.00. Invoice status: PAID. Project completion date is not separately stated in the invoice. The separate service agreement is dated 15 June 2026 and describes an ongoing technical support and system maintenance relationship.', 'System Maintenance & Issue Resolution', 0),
('System Maintenance Support', 'system-maintenance-support-jennifer-john-inv-0119', 'Jennifer John', NULL, 'System Maintenance Support', NULL, '2026-07-01', NULL, 'completed', 'Source invoice INV-0119, dated 01 July 2026. Client: Jennifer John. Service: System Maintenance Support. Bank reference: System Maintains. Amount paid: £251.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'System Maintenance Support', 0),
('Technical Support Services', 'technical-support-services-a-ajoku-inv-0120', 'A Ajoku', NULL, 'Technical Support Services', NULL, '2026-07-02', NULL, 'completed', 'Source invoice INV-0120, dated 02 July 2026. Client: A Ajoku. Service: Technical Support Services. Bank reference: Pymt4Teachsupport. Amount paid: £700.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'Technical Support Services', 0),
('System Setup & Configuration', 'system-setup-configuration-m-opute-isaac-inv-0121', 'M Opute Isaac', NULL, 'System Setup & Configuration', NULL, '2026-07-02', NULL, 'completed', 'Source invoice INV-0121, dated 02 July 2026. Client: M Opute Isaac. Service: System Setup & Configuration. Bank reference: System Setup. Amount paid: £1,050.00. Invoice status: PAID. Project completion date is not separately stated in the invoice.', 'System Setup & Configuration', 0),
('Business Website, E-commerce Platform & Digital Solutions', 'business-website-e-commerce-platform-digital-solutions-dclothingsplug-madetuff-uk', 'Dclothingsplug (Madetuff.uk)', '1 Cantle Mews, Essex, CM7 5XZ', 'Website Development & E-commerce', 8350.00, '2026-07-24', NULL, 'ongoing', 'Source quotation EXP-Q-2026-008 dated 24 July 2026. Total project value £8,350.00. The quotation specifies a £1,100.00 mobilisation deposit and £7,250.00 remaining balance by agreed milestones. No £1,100.00 incoming payment is recorded in the supplied incoming-payment statement, so no transaction has been created for the deposit.', 'Business website design and development; E-commerce platform setup; Product catalogue configuration; Domain and hosting configuration; Business email setup; Payment gateway integration; Search Engine Optimisation (SEO); Website security and SSL implementation; Performance optimisation; Testing and deployment; Staff training and project handover; Three months of technical support and maintenance.', 1);

-- Insert the 60 invoice-backed transactions and attach each to its exact project by invoice slug.
INSERT INTO project_payments (project_id, payment_date, amount, currency, payment_reference, payment_method, description)
SELECT id, payment_date, amount, 'GBP', payment_reference, 'Bank Credit', description
FROM (
    SELECT project_slug, payment_date, amount, payment_reference, description FROM (
        SELECT 'it-consulting-services-sophia-mighty-inv-0062' AS project_slug, '2026-02-09' AS payment_date, 23.00 AS amount, 'INV-0062' AS payment_reference, 'IT Consulting Services — Direct Credit' AS description,
        SELECT 'it-support-and-consultancy-abdillahi-ma-inv-0063' AS project_slug, '2026-02-12' AS payment_date, 65.00 AS amount, 'INV-0063' AS payment_reference, 'IT Support and Consultancy — Expetex' AS description,
        SELECT 'it-infrastructure-consultancy-adedapo-o-inv-0064' AS project_slug, '2026-02-12' AS payment_date, 100.00 AS amount, 'INV-0064' AS payment_reference, 'IT Infrastructure Consultancy — IT Consult' AS description,
        SELECT 'it-technical-support-consultation-agiliga-okorodudu-inv-0065' AS project_slug, '2026-02-16' AS payment_date, 100.00 AS amount, 'INV-0065' AS payment_reference, 'IT Technical Support & Consultation — IT Consultation' AS description,
        SELECT 'it-booster-services-software-support-m-essien-inv-0066' AS project_slug, '2026-02-16' AS payment_date, 400.00 AS amount, 'INV-0066' AS payment_reference, 'IT Booster Services & Software Support — Pymnt4ITbooster' AS description,
        SELECT 'balance-payment-it-consultancy-services-agiliga-okorodudu-inv-0067' AS project_slug, '2026-02-18' AS payment_date, 50.00 AS amount, 'INV-0067' AS payment_reference, 'Balance Payment - IT Consultancy Services — Bal IT Consultatn' AS description,
        SELECT 'technical-consulting-advisory-rachael-badejo-inv-0068' AS project_slug, '2026-02-19' AS payment_date, 125.00 AS amount, 'INV-0068' AS payment_reference, 'Technical Consulting & Advisory — Refund' AS description,
        SELECT 'technical-consultation-services-b-akpan-inv-0069' AS project_slug, '2026-02-20' AS payment_date, 300.00 AS amount, 'INV-0069' AS payment_reference, 'Technical Consultation Services — Consultation' AS description,
        SELECT 'technical-support-systems-maintenance-okolie-a-inv-0070' AS project_slug, '2026-02-20' AS payment_date, 200.00 AS amount, 'INV-0070' AS payment_reference, 'Technical Support & Systems Maintenance — Payment4Techsupert' AS description,
        SELECT 'it-services-infrastructure-maintenance-essien-a-inv-0071' AS project_slug, '2026-02-24' AS payment_date, 500.00 AS amount, 'INV-0071' AS payment_reference, 'IT Services & Infrastructure Maintenance — IT Services' AS description,
        SELECT 'it-support-technical-services-adedayo-adelowo-inv-0072' AS project_slug, '2026-02-26' AS payment_date, 500.00 AS amount, 'INV-0072' AS payment_reference, 'IT Support & Technical Services — Pymt 4 IT Service' AS description,
        SELECT 'it-services-systems-support-andrew-mbukwa-inv-0073' AS project_slug, '2026-02-26' AS payment_date, 500.00 AS amount, 'INV-0073' AS payment_reference, 'IT Services & Systems Support — Pymt4ITservices' AS description,
        SELECT 'technical-consulting-advisory-services-zainab-adekale-inv-0074' AS project_slug, '2026-02-26' AS payment_date, 700.00 AS amount, 'INV-0074' AS payment_reference, 'Technical Consulting & Advisory Services — Pymt4Osusu' AS description,
        SELECT 'it-infrastructure-consultancy-u-ugloro-inv-0075' AS project_slug, '2026-02-26' AS payment_date, 1000.00 AS amount, 'INV-0075' AS payment_reference, 'IT Infrastructure Consultancy — IT Consultation' AS description,
        SELECT 'it-software-support-systems-maintenance-m-essien-inv-0076' AS project_slug, '2026-03-02' AS payment_date, 700.00 AS amount, 'INV-0076' AS payment_reference, 'IT Software Support & Systems Maintenance — Pymt4ITsoftware' AS description,
        SELECT 'it-technical-services-system-support-a-dibie-inv-0077' AS project_slug, '2026-03-02' AS payment_date, 700.00 AS amount, 'INV-0077' AS payment_reference, 'IT Technical Services & System Support — IT Service' AS description,
        SELECT 'it-support-infrastructure-maintenance-o-okunade-inv-0078' AS project_slug, '2026-03-02' AS payment_date, 700.00 AS amount, 'INV-0078' AS payment_reference, 'IT Support & Infrastructure Maintenance — IT Services' AS description,
        SELECT 'it-equipment-software-supply-e-omoruyi-inv-0079' AS project_slug, '2026-03-03' AS payment_date, 2000.00 AS amount, 'INV-0079' AS payment_reference, 'IT Equipment & Software Supply — IT Supply' AS description,
        SELECT 'it-services-technical-support-m-essien-inv-0080' AS project_slug, '2026-03-06' AS payment_date, 450.00 AS amount, 'INV-0080' AS payment_reference, 'IT Services & Technical Support — Pymt4ITservices' AS description,
        SELECT 'logistics-technology-consultancy-agiliga-okorodudu-inv-0081' AS project_slug, '2026-03-20' AS payment_date, 200.00 AS amount, 'INV-0081' AS payment_reference, 'Logistics Technology Consultancy — Pay For Logistics' AS description,
        SELECT 'logistics-systems-support-agiliga-okorodudu-inv-0082' AS project_slug, '2026-03-23' AS payment_date, 300.00 AS amount, 'INV-0082' AS payment_reference, 'Logistics Systems Support — Pay For Logistics' AS description,
        SELECT 'it-consultancy-systems-support-m-essien-inv-0083' AS project_slug, '2026-03-23' AS payment_date, 300.00 AS amount, 'INV-0083' AS payment_reference, 'IT Consultancy & Systems Support — Pymt4ITclodstareg' AS description,
        SELECT 'technical-support-services-okutubo-a-inv-0084' AS project_slug, '2026-03-25' AS payment_date, 100.00 AS amount, 'INV-0084' AS payment_reference, 'Technical Support Services — Pymt4Teachsupport' AS description,
        SELECT 'it-support-systems-maintenance-zainab-adekale-inv-0085' AS project_slug, '2026-03-26' AS payment_date, 700.00 AS amount, 'INV-0085' AS payment_reference, 'IT Support & Systems Maintenance — Pymt4Osusu' AS description,
        SELECT 'technical-support-services-henshaw-etukudoh-inv-0086' AS project_slug, '2026-03-27' AS payment_date, 105.00 AS amount, 'INV-0086' AS payment_reference, 'Technical Support Services — Pymt4Teachsupport' AS description,
        SELECT 'technical-support-troubleshooting-i-oriuwa-inv-0087' AS project_slug, '2026-03-30' AS payment_date, 250.00 AS amount, 'INV-0087' AS payment_reference, 'Technical Support & Troubleshooting — Pymt4Teachsupport' AS description,
        SELECT 'technical-support-services-a-ajoku-inv-0088' AS project_slug, '2026-03-30' AS payment_date, 700.00 AS amount, 'INV-0088' AS payment_reference, 'Technical Support Services — Pymt4Teachsupport' AS description,
        SELECT 'it-supply-support-services-efosa-omoruyi-inv-0089' AS project_slug, '2026-04-01' AS payment_date, 300.00 AS amount, 'INV-0089' AS payment_reference, 'IT Supply & Support Services — Bal IT Supply' AS description,
        SELECT 'it-infrastructure-consultancy-henry-plus-inv-0090' AS project_slug, '2026-04-20' AS payment_date, 205.00 AS amount, 'INV-0090' AS payment_reference, 'IT Infrastructure Consultancy — IT Consultation' AS description,
        SELECT 'it-consulting-services-pamela-ojotule-wak-inv-0091' AS project_slug, '2026-04-20' AS payment_date, 300.00 AS amount, 'INV-0091' AS payment_reference, 'IT Consulting Services — Consulting' AS description,
        SELECT 'it-consultancy-technical-advisory-o-lawal-inv-0092' AS project_slug, '2026-04-20' AS payment_date, 300.00 AS amount, 'INV-0092' AS payment_reference, 'IT Consultancy & Technical Advisory — IT Consultation' AS description,
        SELECT 'cloud-infrastructure-hosting-services-akpevwe-ejoh-inv-0093' AS project_slug, '2026-04-22' AS payment_date, 420.00 AS amount, 'INV-0093' AS payment_reference, 'Cloud Infrastructure & Hosting Services — Cloud Services' AS description,
        SELECT 'it-technical-support-services-zainab-adekale-inv-0094' AS project_slug, '2026-04-24' AS payment_date, 700.00 AS amount, 'INV-0094' AS payment_reference, 'IT Technical Support & Services — Pymt4Osusu' AS description,
        SELECT 'system-implementation-software-integration-contract-evolux-solutions-ltd-slex-inv-0095' AS project_slug, '2026-04-28' AS payment_date, 5000.00 AS amount, 'INV-0095' AS payment_reference, 'System Implementation & Software Integration Contract — System Implementat' AS description,
        SELECT 'system-deployment-technical-configuration-oluwafemi-adebiyi-inv-0096' AS project_slug, '2026-04-30' AS payment_date, 750.00 AS amount, 'INV-0096' AS payment_reference, 'System Deployment & Technical Configuration — Deployment/Sys' AS description,
        SELECT 'it-services-consultation-arieke-chinenye-inv-0097' AS project_slug, '2026-05-05' AS payment_date, 15.00 AS amount, 'INV-0097' AS payment_reference, 'IT Services & Consultation — Expo Pwrns' AS description,
        SELECT 'technical-services-chisom-jim-inv-0098' AS project_slug, '2026-05-05' AS payment_date, 10.00 AS amount, 'INV-0098' AS payment_reference, 'Technical Services — Expo Pwrns' AS description,
        SELECT 'it-support-services-arieke-chinenye-inv-0099' AS project_slug, '2026-05-05' AS payment_date, 35.00 AS amount, 'INV-0099' AS payment_reference, 'IT Support Services — Expo Pwrns' AS description,
        SELECT 'it-support-services-chisom-jim-inv-0100' AS project_slug, '2026-05-06' AS payment_date, 5.00 AS amount, 'INV-0100' AS payment_reference, 'IT Support Services — Expo Pwrns' AS description,
        SELECT 'technical-services-o-akanbi-inv-0101' AS project_slug, '2026-05-06' AS payment_date, 25.00 AS amount, 'INV-0101' AS payment_reference, 'Technical Services — Expo Pwrns' AS description,
        SELECT 'it-support-services-norberta-aquse-inv-0102' AS project_slug, '2026-05-07' AS payment_date, 48.00 AS amount, 'INV-0102' AS payment_reference, 'IT Support Services — Expo Pwrns' AS description,
        SELECT 'technical-services-erieghwea-r-inv-0103' AS project_slug, '2026-05-07' AS payment_date, 173.00 AS amount, 'INV-0103' AS payment_reference, 'Technical Services — Expo Pwrns' AS description,
        SELECT 'it-consultancy-technical-support-jenifer-eyituoyo-inv-0104' AS project_slug, '2026-05-18' AS payment_date, 340.00 AS amount, 'INV-0104' AS payment_reference, 'IT Consultancy & Technical Support — IT Consultation' AS description,
        SELECT 'it-support-technical-services-m-ihe-nwoku-inv-0105' AS project_slug, '2026-05-18' AS payment_date, 500.00 AS amount, 'INV-0105' AS payment_reference, 'IT Support & Technical Services — IT Consult' AS description,
        SELECT 'it-consultancy-infrastructure-services-pamco-limited-inv-0106' AS project_slug, '2026-05-21' AS payment_date, 340.00 AS amount, 'INV-0106' AS payment_reference, 'IT Consultancy & Infrastructure Services — IT Consult' AS description,
        SELECT 'it-consultancy-services-oluwaseun-thompson-inv-0107' AS project_slug, '2026-05-26' AS payment_date, 200.00 AS amount, 'INV-0107' AS payment_reference, 'IT Consultancy Services — IT Consult' AS description,
        SELECT 'it-support-consultation-e-osaro-inv-0108' AS project_slug, '2026-05-26' AS payment_date, 200.00 AS amount, 'INV-0108' AS payment_reference, 'IT Support & Consultation — IT Consultation' AS description,
        SELECT 'it-support-technical-advice-o-lawal-inv-0109' AS project_slug, '2026-05-27' AS payment_date, 300.00 AS amount, 'INV-0109' AS payment_reference, 'IT Support & Technical Advice — IT Consultation' AS description,
        SELECT 'technical-services-o-odiyi-inv-0110' AS project_slug, '2026-05-29' AS payment_date, 35.00 AS amount, 'INV-0110' AS payment_reference, 'Technical Services — Expo Pwrns' AS description,
        SELECT 'technical-support-services-v-akande-inv-0111' AS project_slug, '2026-05-29' AS payment_date, 295.00 AS amount, 'INV-0111' AS payment_reference, 'Technical Support Services — Expo Pwrns' AS description,
        SELECT 'it-support-technical-services-agiliga-okorodudu-inv-0112' AS project_slug, '2026-06-01' AS payment_date, 55.00 AS amount, 'INV-0112' AS payment_reference, 'IT Support & Technical Services — Expo Pwrns' AS description,
        SELECT 'system-support-maintenance-mero-chioma-opute-inv-0113' AS project_slug, '2026-06-01' AS payment_date, 700.00 AS amount, 'INV-0113' AS payment_reference, 'System Support & Maintenance — Suport&Maintenance' AS description,
        SELECT 'technical-support-services-a-ajoku-inv-0114' AS project_slug, '2026-06-01' AS payment_date, 700.00 AS amount, 'INV-0114' AS payment_reference, 'Technical Support Services — Pymt4Teachsupport' AS description,
        SELECT 'technical-support-services-o-animashaun-inv-0115' AS project_slug, '2026-06-19' AS payment_date, 47.00 AS amount, 'INV-0115' AS payment_reference, 'Technical Support Services — Expo Prwn' AS description,
        SELECT 'it-support-consulting-services-zainab-adekale-inv-0116' AS project_slug, '2026-06-26' AS payment_date, 700.00 AS amount, 'INV-0116' AS payment_reference, 'IT Support & Consulting Services — Paymt4Osusu' AS description,
        SELECT 'system-maintenance-technical-support-african-convenient-shop-inv-0117' AS project_slug, '2026-06-29' AS payment_date, 500.00 AS amount, 'INV-0117' AS payment_reference, 'System Maintenance & Technical Support — System Maintains' AS description,
        SELECT 'system-maintenance-issue-resolution-african-convenient-shop-inv-0118' AS project_slug, '2026-07-01' AS payment_date, 240.00 AS amount, 'INV-0118' AS payment_reference, 'System Maintenance & Issue Resolution — System Maintains' AS description,
        SELECT 'system-maintenance-support-jennifer-john-inv-0119' AS project_slug, '2026-07-01' AS payment_date, 251.00 AS amount, 'INV-0119' AS payment_reference, 'System Maintenance Support — System Maintains' AS description,
        SELECT 'technical-support-services-a-ajoku-inv-0120' AS project_slug, '2026-07-02' AS payment_date, 700.00 AS amount, 'INV-0120' AS payment_reference, 'Technical Support Services — Pymt4Teachsupport' AS description,
        SELECT 'system-setup-configuration-m-opute-isaac-inv-0121' AS project_slug, '2026-07-02' AS payment_date, 1050.00 AS amount, 'INV-0121' AS payment_reference, 'System Setup & Configuration — System Setup' AS description
    ) AS payment_rows
) AS x
JOIN projects ON projects.slug = x.project_slug;

-- Verification
SELECT COUNT(*) AS total_projects FROM projects;
SELECT COUNT(*) AS total_transactions, SUM(amount) AS total_paid_gbp FROM project_payments;
SELECT p.project_title, p.client_name, p.start_date AS project_date, p.completion_date, pp.payment_date AS transaction_date, pp.amount, pp.payment_reference
FROM projects p LEFT JOIN project_payments pp ON pp.project_id = p.id
ORDER BY COALESCE(pp.payment_date, p.start_date), p.id;