-- Migration: Insert dummy data for monthly_sales table
-- Date: 2025-12-24
-- Purpose: Populate monthly_sales with realistic test data for reporting
-- NOTE: Uses fixed org_id for all records

INSERT INTO monthly_sales (month, year, pos, sales, org_id, created_at, updated_at)
VALUES ('September', 2025, 'POS-01', 79600.50, '00000000-0000-0000-0000-000000000001', '2025-09-30 23:59:59', '2025-09-30 23:59:59')
ON CONFLICT ON CONSTRAINT monthly_sales_unique_month_year_pos DO NOTHING;

INSERT INTO monthly_sales (month, year, pos, sales, org_id, created_at, updated_at)
VALUES ('September', 2025, 'POS-02', 69900.25, '00000000-0000-0000-0000-000000000001', '2025-09-30 23:59:59', '2025-09-30 23:59:59')
ON CONFLICT ON CONSTRAINT monthly_sales_unique_month_year_pos DO NOTHING;

INSERT INTO monthly_sales (month, year, pos, sales, org_id, created_at, updated_at)
VALUES ('October', 2025, 'POS-01', 87200.75, '00000000-0000-0000-0000-000000000001', '2025-10-31 23:59:59', '2025-10-31 23:59:59')
ON CONFLICT ON CONSTRAINT monthly_sales_unique_month_year_pos DO NOTHING;

INSERT INTO monthly_sales (month, year, pos, sales, org_id, created_at, updated_at)
VALUES ('October', 2025, 'POS-02', 76800.50, '00000000-0000-0000-0000-000000000001', '2025-10-31 23:59:59', '2025-10-31 23:59:59')
ON CONFLICT ON CONSTRAINT monthly_sales_unique_month_year_pos DO NOTHING;

INSERT INTO monthly_sales (month, year, pos, sales, org_id, created_at, updated_at)
VALUES ('November', 2025, 'POS-01', 91500.00, '00000000-0000-0000-0000-000000000001', '2025-11-30 23:59:59', '2025-11-30 23:59:59')
ON CONFLICT ON CONSTRAINT monthly_sales_unique_month_year_pos DO NOTHING;

INSERT INTO monthly_sales (month, year, pos, sales, org_id, created_at, updated_at)
VALUES ('November', 2025, 'POS-02', 80200.75, '00000000-0000-0000-0000-000000000001', '2025-11-30 23:59:59', '2025-11-30 23:59:59')
ON CONFLICT ON CONSTRAINT monthly_sales_unique_month_year_pos DO NOTHING;
