-- Source: sql/payroll_anomalies.sql
INSERT INTO tenants (id, name) VALUES
  (1, 'Default Tenant'),
  (2, 'EFL'),
  (3, 'Rolle');
INSERT INTO branches (id, tenant_id, name) VALUES
  (1, 1, 'Main Branch'),
  (2, 2, 'EFL Branch'),
  (3, 3, 'Rolle Branch');



-- Source: demoData/groups.sql
INSERT INTO groups (id, name, description, parent_id) VALUES
(4, 'Finance Team', 'Handles company finances', NULL),
(5, 'Sales Team', 'Responsible for sales', NULL);


-- Source: sql/grant_user1_all_permissions.sql
-- Create HR Administrator role with full access
INSERT INTO groups (id, name, description)
VALUES (6, 'HR Admin Group', 'Full access group');

-- Super Admin role with wildcard permissions
INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Super Admin', NULL, NULL,
    NULL,
    '{"*": ["*"]}',
    NOW(),
    1
);
INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Super Admin', 2, NULL,
    NULL,
    '{"*": ["*"]}',
    NOW(),
    1
);
INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Super Admin', 3, NULL,
    NULL,
    '{"*": ["*"]}',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Procurement Manager', NULL, NULL,
    NULL,
    '{
        "procurement_requests": ["getAll","create","update","delete","approve","reject"],
        "purchase_requests": ["getAll","create","update","delete","approve","reject"],
        "rfqs": ["getAll","create","update","delete","approve","close"],
        "purchase_orders": ["getAll","create","update","delete","approve","close"],
        "goods_receipts": ["getAll","create","update","delete"],
        "vendor_invoices": ["getAll","create","update","delete","approve"],
        "vendors": ["getAll","create","update","delete"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Finance Approver', NULL, NULL,
    NULL,
    '{
        "procurement_requests": ["getAll","approve"],
        "rfqs": ["getAll","approve"],
        "purchase_orders": ["getAll","approve"],
        "vendor_invoices": ["getAll","approve"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'CEO Approver', NULL, NULL,
    NULL,
    '{
        "procurement_requests": ["getAll","approve"],
        "rfqs": ["getAll","approve"],
        "purchase_orders": ["getAll","approve"],
        "vendor_invoices": ["getAll","approve"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Employee', NULL, NULL,
    NULL,
    '{
        "disciplinary_cases": ["getById"],
        "appeals": ["submit","getById"],
        "purchase_requests": ["getAll","create","update"],
        "time_clocks": ["getAll"],
        "payroll_periods": ["getAll"]
    }',
    -- permissions allow regular employees to submit and view their
    -- own purchase requests
    NOW(),
    1
);

INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'HR Administrator', NULL, NULL,
    NULL,
    '{
        "attendance": ["getAll","create","update","delete","approve","reject"],
        "employees": ["getAll","create","update","delete"],
        "employee_types": ["getAll","create","update","delete"],
        "users": ["getAll","create","update","delete"],
        "time_clock_locations": ["getAll","create","update","delete"],
        "payroll": ["getAll","create","update","delete"],
        "payroll_config": ["getAll","create","update","delete"],
        "payslips": ["verify"],
        "requisitions": ["getAll","create","update","delete","approve","reject"],
        "procurement_requests": ["getAll","create","update","delete","approve","reject"],
        "purchase_requests": ["getAll","create","update","delete","approve","reject"],
        "vendor": ["getAll","create","update","delete"],
        "groups": ["getAll","create","update","delete"],
        "user_group_memberships": ["getAll","create","update","delete"],
        "group_permissions": ["getAll","create","update","delete"],
        "training_courses": ["getAll","create","update","delete"],
        "resources": ["getAll","create","update","delete"],
        "locations": ["getAll","create","update","delete"],
        "timeclocks": ["getAll","create","update","delete"],
        "time_clocks": ["getAll","create","update","delete"],
        "reports": ["company","summaryToday","absenteesToday","locationAlerts"],
        "performance_goals": ["*"],
        "performance_reviews": ["*"],
        "feedback_notes": ["*"],
        "check_ins": ["*"],
        "performance_dashboard": ["view"]
        "reports": ["company","summaryToday","absenteesToday","locationAlerts"],
        "violation_types": ["getAll","create","update","delete"],
        "disciplinary_cases": ["getAll","create","update","delete"],
        "case_evidence": ["getAll","create","update","delete"],
        "interview_logs": ["getAll","create","update","delete"],
        "disciplinary_actions": ["getAll","create","update","delete"],
        "appeals": ["getAll","create","update","delete","review"],
        "ohs_actions": ["manage"],
        "ohs_inspections": ["view"],
        "ohs_regulations": ["manage"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Location Officer', NULL, NULL,
    NULL,
    '{"*": ["*"]}',
    NOW(),
    1
);

-- Exit workflow roles
INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'HR Manager', NULL, NULL,
    NULL,
    '{
        "employee_exits": ["*"],
        "exit_clearances": ["*"],
        "exit_approvals": ["*"],
        "exit_interviews": ["*"],
        "exit_feedback": ["*"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Department Head', NULL, NULL,
    NULL,
    '{
        "employee_exits": ["*"],
        "exit_clearances": ["*"],
        "exit_approvals": ["*"],
        "exit_interviews": ["*"],
        "exit_feedback": ["*"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'IT', NULL, NULL,
    NULL,
    '{
        "employee_exits": ["*"],
        "exit_clearances": ["*"],
        "exit_approvals": ["*"],
        "exit_interviews": ["*"],
        "exit_feedback": ["*"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Admin', NULL, NULL,
    NULL,
    '{
        "employee_exits": ["*"],
        "exit_clearances": ["*"],
        "exit_approvals": ["*"],
        "exit_interviews": ["*"],
        "exit_feedback": ["*"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Legal', NULL, NULL,
    NULL,
    '{
        "employee_exits": ["*"],
        "exit_clearances": ["*"],
        "exit_approvals": ["*"],
        "exit_interviews": ["*"],
        "exit_feedback": ["*"]
        "reports": ["company","summaryToday","absenteesToday","locationAlerts"],
        "ohs_inspections": ["view"]
    }',
    NOW(),
    1
);
INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Legal Admin', NULL, NULL,
    NULL,
    '{"cases": ["*"], "matters": ["*"], "case_documents": ["*"], "case_events": ["*"], "case_communications": ["*"], "case_instructions": ["*"]}',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Finance Manager', NULL, NULL,
    NULL,
    '{
        "glaccounts": ["getAll","create","update","delete","toggle"],
        "gltransactions": ["getAll","create","update","delete","import","postBatch","split","parseText"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Accountant', NULL, NULL,
    'Finance Manager',
    '{
        "glaccounts": ["getAll","update"],
        "gltransactions": ["getAll","create","postBatch","split"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Auditor', NULL, NULL,
    NULL,
    '{
        "glaccounts": ["getAll"],
        "gltransactions": ["getAll"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Finance Officer', NULL, NULL,
    NULL,
    '{
        "properties": ["getAll","create","update","delete"],
        "ratepayers": ["*"],
        "property_rates": ["*"],
        "rates_billing": ["generate"],
        "rate_payments": ["create"]
    }',
    NOW(),
    1
);

INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'Council Clerk', NULL, NULL,
    NULL,
    '{
        "properties": ["getAll","create","update","delete"],
        "ratepayers": ["*"],
        "property_rates": ["*"],
        "rates_billing": ["generate"],
        "rate_payments": ["create"]
    }',
    NOW(),
    1
);

-- DMS roles
INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'SuperAdmin', NULL, NULL,
    NULL,
    '{"storage_connectors": ["*"], "documents": ["*"], "calendar_events": ["*"], "meetings": ["*"]}',
    NOW(),
    1
);
INSERT INTO roles_permissions (role, tenant_id, branch_id, inheritedFrom, permissions, updatedAt, createdBy)
VALUES (
    'User', NULL, NULL,
    NULL,
    '{"documents": ["getAll","getById","uploadVersion"]}',
    NOW(),
    1
);


INSERT INTO user_group_memberships (user_id, group_id, role)
VALUES (1, 1, 'Super Admin');
INSERT INTO user_group_memberships (user_id, group_id, role)
VALUES (2, 1, 'Super Admin');
INSERT INTO user_group_memberships (user_id, group_id, role)
VALUES (3, 1, 'Super Admin');
INSERT INTO user_group_memberships (user_id, group_id, role)
VALUES (6, 1, 'Location Officer');
INSERT INTO user_group_memberships (user_id, group_id, role)
VALUES (3, 1, 'Location Officer');
INSERT INTO user_group_memberships (user_id, group_id, role)
VALUES (4, 1, 'Location Officer');

INSERT INTO user_group_memberships (user_id, group_id, role)
VALUES (7, 1, 'Procurement Manager');
INSERT INTO user_group_memberships (user_id, group_id, role)
VALUES (8, 1, 'Finance Approver');
INSERT INTO user_group_memberships (user_id, group_id, role)
VALUES (9, 1, 'CEO Approver');

INSERT INTO user_group_memberships (user_id, group_id, role)
VALUES (8, 1, 'Finance Officer');
INSERT INTO user_group_memberships (user_id, group_id, role)
VALUES (9, 1, 'Council Clerk');



-- Source: demoData/group_permissions.sql
INSERT INTO group_permissions (id, group_id, resource_id, can_view, can_edit, can_create, can_delete) VALUES
(1, 2, 1, TRUE, TRUE, TRUE, TRUE),
(2, 2, 2, TRUE, TRUE, TRUE, TRUE),
(3, 3, 1, TRUE, FALSE, FALSE, FALSE),
(4, 2, 3, TRUE, TRUE, TRUE, TRUE),
(5, 3, 3, TRUE, FALSE, FALSE, FALSE);


-- Source: demoData/user_group_memberships.sql
INSERT INTO user_group_memberships (user_id, group_id, role) VALUES
(2, 2, 'Finance Team'),
(3, 3, 'Sales Team');


-- Source: sql/locations.sql
INSERT INTO locations (name, latitude, longitude, radius_m, tenant_id, branch_id) VALUES
  ('Suva Headquarters', -18.1397956843015, 178.42656254768372, 50, 1, 1),
  ('Sigatoka Office', -18.1458, 177.5065, 50, 1, 1),
  ('Suva Export', -18.1292, 178.4265, 50, 1, 1),
  ('Nadi Office', -17.7533, 177.4435, 50, 1, 1),
  ('Lautoka Office', -17.6167, 177.4667, 50, 1, 1),
  ('Ba Office', -17.5341, 177.6838, 50, 1, 1),
  ('Nausori Office', -18.0244, 178.5451, 50, 1, 1),
  ('Labasa Office', -16.4302, 179.3822, 50, 1, 1),
  ('Nausori Station', -18.0244, 178.5451, 50, 1, 1),
  ('Savusavu', -16.7794, 179.3314, 50, 1, 1),
  ('Navua Station', -18.2194, 178.1592, 50, 1, 1),
  ('Rakiraki Office', -17.3658, 178.1650, 50, 1, 1),
  ('Rotuma', -12.5025, 177.0720, 50, 1, 1),
  ('Lab', -18.0491, 178.5298, 50, 1, 1);


-- Source: demoData/time_clock_locations.sql
INSERT INTO time_clock_locations (id, name, shape, center_lat, center_lng, radius_m, assigned_to_type, assigned_to_ids) VALUES
(1, 'Suva HQ', 'circle', -18.1398, 178.4266, 50, 'location', '1'),
(2, 'Nadi Office', 'circle', -17.7533, 177.4435, 50, 'location', '4');

-- Source: demoData/pay_cycles.sql
INSERT INTO pay_cycles (id, name, frequency, pay_day, cutoff_offset, next_run_date, locale) VALUES
(1, 'Weekly', 'weekly', 'Friday', 0, '2025-06-07', 'en_US'),
(2, 'Fortnightly', 'fortnightly', 'Tuesday', 4, '2025-06-14', 'en_US'),
(3, 'Bi-Monthly-15', 'bi-monthly', '15', 2, '2025-06-15', 'en_US'),
(4, 'Bi-Monthly-30', 'bi-monthly', '30', 2, '2025-06-30', 'en_US'),
(5, 'Monthly', 'monthly', '30', 2, '2025-06-30', 'en_US');


-- Source: demoData/pay_rules.sql
INSERT INTO pay_rules (id, rule_name, overtime_rate, threshold_hours, notes) VALUES
(1, 'Standard OT', 1.50, 40, 'Overtime after 40 hours'),
(2, 'Holiday OT', 2.00, 0, 'Double pay on holidays');


-- Source: demoData/payroll_periods.sql
INSERT INTO payroll_periods ( pay_cycle_id, period_start, period_end) VALUES
( 2, '2025-05-02', '2025-05-15'),
( 2, '2025-05-16', '2025-05-29'),
( 2, '2025-05-30', '2025-06-05');


-- Source: demoData/employee_types.sql
INSERT INTO employee_types (id, type, default_items) VALUES
(1, 'Full-Time', 'Laptop,Phone'),
(2, 'Contractor', 'Laptop');


-- Source: demoData/employees.sql
INSERT INTO employees (id, tenant_id, branch_id, name, department, email, phone, title, salary, createdBy, pay_cycle_id, manager_id) VALUES
(1, 1, 1, 'Alice Johnson', 'HR', 'alice.johnson@example.com', '+1-555-01001', 'HR Manager', 55000, 1, 1, NULL),
(2, 1, 1, 'Bob Smith', 'Engineering', 'bob.smith@example.com', '+1-555-01002', 'Software Engineer', 52000, 1, 2, 1),
(3, 1, 1, 'Carol Williams', 'Sales', 'carol.williams@example.com', '+1-555-01003', 'Sales Representative', 48000, 1, 2, 1),
(4, 1, 1, 'David Brown', 'Engineering', 'david.brown@example.com', '+1-555-01004', 'DevOps Engineer', 56000, 1, 2, 2),
(5, 1, 1, 'Eva Davis', 'Support', 'eva.davis@example.com', '+1-555-01005', 'Support Specialist', 47000, 1, 3, 1);


-- Source: demoData/compensation.sql
INSERT INTO compensation (id, employee_id, pay_type, amount, effective_from, effective_to) VALUES
(1, 1, 'salary', 60000.00, '2025-01-01', NULL),
(2, 2, 'salary', 80000.00, '2025-01-01', NULL),
(3, 3, 'salary', 50000.00, '2025-01-01', NULL),
(4, 4, 'salary', 75000.00, '2025-01-01', NULL),
(5, 5, 'salary', 45000.00, '2025-01-01', NULL);

-- Sample employee custom fields
INSERT INTO employee_custom_fields (id, tenant_id, branch_id, field_name, field_type, is_required) VALUES
  (1, 1, 1, 'linkedin_profile', 'text', FALSE),
  (2, 1, 1, 't_shirt_size', 'text', FALSE);

-- Sample application field definitions
INSERT INTO application_field_definitions
  (id, tenant_id, branch_id, field_name, field_type, is_required, is_filterable)
VALUES
  (1, 1, 1, 'linkedin', 'text', FALSE, TRUE),
  (2, 1, 1, 'portfolio_url', 'text', FALSE, FALSE);


-- Source: demoData/benefit_plans.sql
INSERT INTO benefit_plans (id, name, deduction_amount, pre_tax) VALUES
(1, 'Health Insurance', 150.00, TRUE),
(2, 'Retirement 401k', 200.00, TRUE);


-- Source: demoData/employee_benefits.sql
INSERT INTO employee_benefits (id, employee_id, benefit_plan_id, start_date, end_date) VALUES
(1, 1, 1, '2025-01-01', NULL),
(2, 2, 2, '2025-01-01', NULL);


-- Source: demoData/employee_items.sql
INSERT INTO employee_items (id, employee_id, item_name, is_ppe, expiry_date, assignee_user_id, assignee_group_id) VALUES
(1, 2, 'Laptop', FALSE, NULL, 1, NULL),
(2, 3, 'Safety Helmet', TRUE, '2025-12-31', 1, NULL);


-- Source: demoData/jobs.sql
INSERT INTO jobs (id, title) VALUES
(1, 'Software Engineer'),
(2, 'Sales Representative'),
(3, 'HR Specialist');


-- Source: demoData/open_positions.sql
INSERT INTO open_positions (id, title, department, location, status, description, createdBy, updatedAt) VALUES
(1, 'Junior Developer', 'Engineering', 'Suva', 'Open', 'Entry level role', 1, NOW()),
(2, 'Sales Intern', 'Sales', 'Nadi', 'Open', 'Assist sales team', 1, NOW());


-- Source: demoData/applications.sql
INSERT INTO applications (id, job_id, first_name, last_name, email, phone, address, date_of_birth, position_applied, application_date, status, source, notes, created_by) VALUES
(1, 1, 'George', 'Miller', 'george.miller@example.com', '+1-555-1000', '10 Market St', '1990-04-12', 'Software Engineer', '2025-05-20', 'Under Review', 'Website', NULL, 1);


-- Source: demoData/application_documents.sql
INSERT INTO application_documents (id, application_id, file_name, file_type, file_path, uploaded_by) VALUES
(1, 1, 'resume.pdf', 'resume', '/docs/applications/resume1.pdf', 1);


-- Source: sql/employee_onboarding_workflow.sql
INSERT INTO workflows (name, trigger_event, definition, is_active)
VALUES (
  'Employee Onboarding',
  'employee.hired',
  '{
    "conditions": [],
    "steps": [
      { "type": "assign_items" },
      { "type": "notify_manager" },
      { "type": "trigger_api", "items": ["365", "email_signature"] }
    ]
  }',
  TRUE
);

-- Workflow for OHS incident reporting
INSERT INTO workflows (name, trigger_event, definition, is_active)
VALUES (
  'OHS Incident Reporting',
  'ohs_incident_reported',
  '{
    "conditions": [],
    "steps": [
      { "type": "wait_approval", "role": "hs_officer" },
      { "type": "update_status", "field": "status", "value": "investigating" }
    ]
  }',
  TRUE
);

-- Workflow for time clock creation
INSERT INTO workflows (id, name, trigger_event, definition, is_active)
VALUES (
  100,
  'Time Clock Entry Notification',
  'timeclock.created',
  '{"conditions":[]}',
  TRUE
);

INSERT INTO workflow_steps (workflow_id, step_order, step_type, config)
VALUES (100, 1, 'notify_manager', '{}');

-- Workflow for timesheet approval
INSERT INTO workflows (id, name, trigger_event, definition, is_active)
VALUES (
  101,
  'Timesheet Approval',
  'timesheet.approved',
  '{"conditions":[]}',
  TRUE
);

INSERT INTO workflow_steps (workflow_id, step_order, step_type, config)
VALUES (101, 1, 'create_task', '{"title":"Review approved timesheet","column_id":1}');


-- Source: demoData/tasks.sql
INSERT INTO tasks (id, employee_id, item_name, manager_id, status) VALUES
(1, 2, 'Submit project report', 1, 'pending'),
(2, 3, 'Client follow up', 1, 'completed');


-- Source: demoData/payroll_runs.sql
INSERT INTO payroll_runs (id, payroll_period_id, run_date, status) VALUES
(1, 1, '2025-06-07', 'completed'),
(2, 2, '2025-06-07', 'completed'),
(3, 3, '2025-06-01', 'completed');


-- Source: demoData/payslips.sql
INSERT INTO payslips (
  id,
  payroll_run_id,
  employee_id,
  gross_pay,
  net_pay,
  document_path,
  verified_by,
  verified_at,
  verification_notes
) VALUES
(1, 1, 1, 5000.00, 4000.00, '/docs/payslips/1.pdf', NULL, NULL, NULL),
(2, 1, 2, 6666.67, 5200.00, '/docs/payslips/2.pdf', NULL, NULL, NULL),
(3, 2, 3, 4166.67, 3400.00, '/docs/payslips/3.pdf', NULL, NULL, NULL);


-- Source: demoData/payslip_lines.sql
INSERT INTO payslip_lines (id, payslip_id, description, amount, line_type) VALUES
(1, 1, 'Base Salary', 5000.00, 'earning'),
(2, 1, 'Tax', -1000.00, 'deduction'),
(3, 2, 'Base Salary', 6666.67, 'earning'),
(4, 2, 'Tax', -1466.67, 'deduction');


-- Source: demoData/payroll_adjustments.sql
INSERT INTO payroll_adjustments (id, employee_id, payroll_period_id, description, amount, adjustment_type) VALUES
(1, 1, 1, 'Bonus', 500.00, 'earning'),
(2, 2, 1, 'Health Insurance', -200.00, 'deduction');


-- Source: demoData/payroll_anomalies.sql
INSERT INTO payroll_anomalies (id, payroll_run_id, employee_id, message) VALUES
(1, 1, 2, 'Missing timesheet');


-- Source: demoData/notification_log.sql
INSERT INTO notification_log (type, recipient, subject, message, status) VALUES
('email', 'alice.johnson@example.com', 'Welcome', 'Welcome to the company!', 'sent');


-- Source: demoData/leave_types.sql
INSERT INTO leave_types (id, name, code, description, daysPerYear, accrualType, carryForward, maxCarry, approvalRequired, paid, active, createdBy) VALUES
(1, 'Annual Leave', 'AL', 'Paid annual leave', 20, 'monthly', TRUE, 10, TRUE, TRUE, TRUE, 1),
(2, 'Sick Leave', 'SL', 'Paid sick leave', 10, 'yearly', FALSE, NULL,  TRUE, TRUE, TRUE, 1),
(3, 'Unpaid Leave', 'UL', 'Leave without pay', 0, 'none', FALSE, NULL,  FALSE, TRUE, TRUE, 1);


-- Source: demoData/leave_requests.sql
INSERT INTO leave_requests (id, employeeName, leaveType, startDate, endDate, reason, status, createdBy, approvedAt, approvedBy) VALUES
(1, 'Alice Johnson', 'Annual Leave', '2025-07-01', '2025-07-10', 'Vacation', 'Approved', 1, '2025-06-15', 1),
(2, 'Bob Smith', 'Sick Leave', '2025-06-02', '2025-06-05', 'Flu', 'Approved', 1, '2025-06-01', 1);


-- Source: demoData/GL_Journal_Entries.sql
INSERT INTO GL_Journal_Entries (id, reference, memo, timestamp, created_by, tenant_id, branch_id) VALUES
(1, 'INV-1001', 'Initial capital', '2025-05-01 09:00:00', 1, 1, 1);


-- Source: demoData/tax_settings.sql
INSERT INTO tax_settings (id, name, value) VALUES
(1, 'federal_tax_rate', '10'),
(2, 'state_tax_rate', '5');


-- Source: demoData/tax_brackets.sql
INSERT INTO tax_brackets (id, min_income, max_income, rate) VALUES
(1, 0.00, 20000.00, 10.00),
(2, 20000.01, 50000.00, 20.00),
(3, 50000.01, NULL, 30.00);


-- Source: demoData/procurement_requests.sql
INSERT INTO procurement_requests (id, description, justification, estimated_cost, quantity, preferred_vendor, needed_by, status, requester_id) VALUES
(1, 'Office Chairs', 'Replace old chairs', 1200.00, 10, 'Fiji Furniture', '2025-07-01', 'Pending', 1);


-- Source: demoData/purchase_requests.sql
INSERT INTO purchase_requests (id, description, justification, estimated_cost, quantity, preferred_vendor, needed_by, updatedAt, created_by) VALUES
(1, 'Laptop', 'New hire equipment', 1500.00, 1, 'Computer World', '2025-06-15', NOW(), 1);


-- Source: demoData/vendors.sql
INSERT INTO vendors (id, vendorName, tradingName, businessRegNumber, tin, vatNumber, businessType, incorporationDate, registrationCountry, status, created_by, updated_by) VALUES
(1, 'Fiji Stationers Ltd', 'Fiji Stationers', 'BRN12345', 'TIN54321', 'VAT11111', 'LLC', '2010-03-15', 'Fiji', 'approved', 1, 1),
(2, 'Island Tech Solutions', 'IslandTech', 'BRN67890', 'TIN98765', 'VAT22222', 'Ltd', '2015-07-20', 'Fiji', 'pending', 1, 1),
(3, 'Pacific Catering Co', 'PacCater', 'BRN23456', 'TIN12321', 'VAT33333', 'Ltd', '2012-11-10', 'Fiji', 'approved', 1, 1);


-- Source: demoData/vendor_addresses.sql
INSERT INTO vendor_addresses (id, vendor_id, type, address) VALUES
(1, 1, 'office', '123 Main St, Suva'),
(2, 2, 'office', '456 Tech Park, Nadi'),
(3, 3, 'office', '789 Catering Rd, Lautoka');


-- Source: demoData/vendor_bank_accounts.sql
INSERT INTO vendor_bank_accounts (id, vendor_id, bankName, bankBranch, accountName, accountNumber, bankCode, bankAddress) VALUES
(1, 1, 'Bank of Fiji', 'Suva', 'Fiji Stationers Ltd', '123456789', 'BOF001', '1 Bank St, Suva'),
(2, 2, 'Fiji Bank', 'Nadi', 'Island Tech Solutions', '987654321', 'FJB002', '2 Bank St, Nadi'),
(3, 3, 'Bank of Pacific', 'Lautoka', 'Pacific Catering Co', '555666777', 'BOP003', '3 Bank St, Lautoka');


-- Source: demoData/vendor_capabilities.sql
INSERT INTO vendor_capabilities (id, vendor_id, goodsServices, categoryTags, pastClients, experienceYears, certifications, capacity) VALUES
(1, 1, 'Office Supplies', 'stationery', 'Gov Dept', 15, 'ISO9001', 'High volume'),
(2, 2, 'IT Services', 'software,hardware', 'Various clients', 10, 'Cisco', 'Medium'),
(3, 3, 'Catering Services', 'food', 'Hotels', 8, 'FoodSafe', 'Large events');


-- Source: demoData/vendor_contacts.sql
INSERT INTO vendor_contacts (id, vendor_id, primaryContactName, designation, email, phone) VALUES
(1, 1, 'John Vendor', 'Manager', 'contact@fijistationers.com', '+679-100-200'),
(2, 2, 'Jane Tech', 'Director', 'info@islandtech.com', '+679-200-300'),
(3, 3, 'Paul Cater', 'Owner', 'service@paccater.com', '+679-300-400');


-- Source: demoData/vendor_documents.sql
INSERT INTO vendor_documents (id, vendor_id, filetype, type, file_url, validity) VALUES
(1, 1, 'pdf', 'business_license', '/docs/vendors/license1.pdf', '2026-12-31'),
(2, 2, 'pdf', 'business_license', '/docs/vendors/license2.pdf', '2027-05-31'),
(3, 3, 'pdf', 'business_license', '/docs/vendors/license3.pdf', '2027-10-31');


-- Source: demoData/vendor_supporting_docs.sql
INSERT INTO vendor_supporting_docs (id, vendor_id, filetype, type, file_url, validity) VALUES
(1, 1, 'pdf', 'insurance_certificate', '/docs/vendors/insurance1.pdf', '2025-12-31'),
(2, 2, 'pdf', 'insurance_certificate', '/docs/vendors/insurance2.pdf', '2026-12-31'),
(3, 3, 'pdf', 'insurance_certificate', '/docs/vendors/insurance3.pdf', '2026-12-31');


-- Source: demoData/user_auth_providers.sql
INSERT INTO user_auth_providers (id, user_id, provider, provider_user_id, email, name) VALUES
(1, 1, 'google', 'google-uid-1', 'admin@example.com', 'Test Admin');


-- Source: demoData/user_2fa.sql
INSERT INTO user_2fa (id, user_id, secret) VALUES
(1, 1, 'SECRET1');


-- Source: demoData/user_passkeys.sql
INSERT INTO user_passkeys (id, user_id, credential_id, public_key) VALUES
(1, 1, 'cred1', 'publickeydata');


-- Source: demoData/user_phones.sql
INSERT INTO user_phones (id, user_id, phone_number) VALUES
(1, 1, '+1-555-2001'),
(2, 2, '+1-555-2002');


-- Source: demoData/assessment_numbers.sql
INSERT INTO assessment_numbers (id, user_id, number) VALUES
(1, 1, 'A100'),
(2, 2, 'A101');


-- Source: demoData/disciplinary_module.sql
INSERT INTO violation_types (id, name, handbook_ref, updatedAt) VALUES
(1, 'Attendance Violation', 'Section 5.2', NOW()),
(2, 'Code of Conduct', 'Section 3.1', NOW());

INSERT INTO disciplinary_cases (id, employee_id, violation_id, severity, summary, status, assigned_to, tenant_id, branch_id) VALUES
(1, 2, 1, 'minor', 'Late arrival on 2025-05-01', 'open', 1, 1, 1);

INSERT INTO case_evidence (id, case_id, file_path, description, tenant_id, branch_id) VALUES
(1, 1, '/evidence/late1.jpg', 'Time clock screenshot', 1, 1);

INSERT INTO interview_logs (id, case_id, person, notes, logged_at, tenant_id, branch_id) VALUES
(1, 1, 'Bob Smith', 'Employee admitted being late due to traffic', NOW(), 1, 1);

INSERT INTO disciplinary_actions (id, case_id, action, effective_date, approved_by, tenant_id, branch_id) VALUES
(1, 1, 'Written warning', '2025-06-01', 1, 1, 1);

INSERT INTO appeals (id, case_id, employee_id, reason, status, tenant_id, branch_id) VALUES
(1, 1, 2, 'Disputes severity', 'submitted', 1, 1);

-- Sample data for general ledger
INSERT INTO gl_accounts (id, code, name, type, tags, is_active, parent_id, updatedAt) VALUES
  (1, '1000', 'Cash', 'asset', 'bank', TRUE, NULL, NOW()),
  (2, '2000', 'Accounts Payable', 'liability', 'ap', TRUE, NULL, NOW()),
  (3, '4000', 'Sales Revenue', 'revenue', 'income', TRUE, NULL, NOW());

INSERT INTO GL_Journal_Entries (id, reference, memo, timestamp, created_by, tenant_id, branch_id) VALUES
  (2, 'JE001', 'Opening balance', NOW(), 1, 1, 1);

INSERT INTO gl_transactions (id, journal_entry_id, account_id, type, amount, currency, rate, timestamp, memo, reference) VALUES
  (1, 1, 1, 'debit', 1000.00, 'USD', 1.000000, NOW(), 'Opening cash', 'JE001-1'),
  (2, 1, 3, 'credit', 1000.00, 'USD', 1.000000,  NOW(), 'Opening equity', 'JE001-2');

INSERT INTO bank_transactions (id, gl_transaction_id) VALUES (1, 1);
INSERT INTO ap_transactions (id, gl_transaction_id) VALUES (1, 2);
INSERT INTO ar_transactions (id, gl_transaction_id) VALUES (1, 2);
-- Source: demoData/payroll_attendance_demo.sql
-- Demo attendance records for five employees over two weeks
-- Source: demoData/tax_super_demo.sql
-- Superannuation contribution settings
INSERT INTO superannuation_settings (employee_rate, employer_rate)
VALUES (8.00, 10.00);

-- Demo deduction settings
INSERT INTO deduction_settings (name, start_salary, end_salary, base_amount, percent, company_contribution)
VALUES
  ('Union Fee', 0.00, 2000.00, 5.00, 1.00, 1.00),
  ('Union Fee Tier 2', 2000.01, NULL, 10.00, 2.00, 1.50);

-- PAYE tax brackets for Fiji dollars
DELETE FROM tax_brackets;
INSERT INTO tax_brackets (min_income, max_income, rate) VALUES
  (0.00, 30000.00, 0.00),
  (30000.01, 50000.00, 18.00),
  (50000.01, 270000.00, 20.00),
  (270000.01, 300000.00, 33.00);

-- Sample test users
-- Copy or rename this file to test_users.sql and edit as needed
-- testadmin and testuser are the default passwords respectively
INSERT INTO users ( full_name, password, locations, tenant_id, branch_id) VALUES
( 'Test Admin', '$2y$10$PXEdpEbxI5c11/tC3UdC6OrZr7V2MsHAatf5C6LRzRV/goxQDPTl.', NULL ,1,1),
( 'EFLAdmin', '$2y$10$tLsny6hcmKKsFLVsnJL5pucGQyykr.n2lsevZHKvicL6fc3YE41qm', NULL ,2,2),
( 'RolleAdmin', '$2y$10$ayeYEoYWherPt5uC57MGse18Rny3k2saLsFEs87XID7LSmlNDlbVG', NULL ,3,3);

-- Associate login emails with the sample users
INSERT INTO user_emails (user_id, email) VALUES
(1, 'admin@example.com'),
(2, 'efladmin@example.com'),
(3, 'rolleadmin@example.com');


INSERT INTO time_clocks (user_id, clock_type, lat, lng, security_type, clocked_at) VALUES
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:17:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:19:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:18:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-12 16:56:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:13:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:25:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:21:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:10:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:17:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:24:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:14:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:25:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:20:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:06:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:23:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-12 17:23:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:11:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-12 17:11:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:09:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-12 17:04:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:09:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:19:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:08:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:14:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:13:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:24:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:22:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:17:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:24:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:23:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:09:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:04:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:08:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:18:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:07:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:23:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:15:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:10:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:22:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-13 16:58:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:16:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:08:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:15:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:14:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:25:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:24:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:11:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:25:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:22:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:10:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:19:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:22:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:21:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:03:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:06:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:20:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:22:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:24:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:05:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-14 16:57:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:17:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-15 17:17:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:25:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-15 16:55:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:24:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-15 17:10:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:15:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:02:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:15:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:17:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:07:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:01:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:23:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:02:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:12:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-15 17:20:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:09:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-15 17:20:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:22:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-15 17:09:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:07:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-16 16:57:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:15:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-16 17:23:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:21:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-16 17:24:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:20:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-16 16:58:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:14:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:12:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:14:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:17:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:08:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:12:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:15:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:21:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:22:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:01:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:24:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:12:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:23:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:04:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:19:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-19 16:57:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:24:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:20:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:17:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:05:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:23:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:02:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:14:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:00:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:11:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:21:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:10:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-19 16:56:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:24:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:16:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:13:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:10:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:07:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-20 16:57:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:09:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:23:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:09:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:24:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:06:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:21:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:07:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:23:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:22:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:16:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:17:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:21:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:21:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:03:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:21:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:20:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:12:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:22:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:11:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:23:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:23:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:21:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:18:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:13:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:13:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:09:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:20:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:16:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:25:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:17:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:16:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-21 16:57:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:15:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:14:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:08:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:10:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:23:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:15:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:15:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:22:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:11:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:02:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:05:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:18:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:13:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-22 16:58:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:12:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:06:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:10:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:05:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:18:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:21:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:06:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-22 16:58:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:09:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-22 17:22:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:12:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-22 16:56:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:23:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:15:00'),
(2, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:22:00'),
(2, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:14:00'),
(3, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:07:00'),
(3, 'out', -18.1398, 178.4266, 'password', '2025-05-23 16:55:00'),
(4, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:08:00'),
(4, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:15:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:11:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:14:00'),
(6, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:23:00'),
(6, 'out', -17.7533, 177.4435, 'password', '2025-05-23 16:58:00'),
(7, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:17:00'),
(7, 'out', -17.7533, 177.4435, 'password', '2025-05-23 16:57:00'),
(8, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:16:00'),
(8, 'out', -16.4302, 179.3822, 'password', '2025-05-23 17:21:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:08:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-23 16:56:00'),
(10, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:24:00'),
(10, 'out', -16.4302, 179.3822, 'password', '2025-05-23 16:55:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-01 08:21:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-01 17:25:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-01 08:17:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-01 17:16:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-01 08:26:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-01 17:10:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-01 08:17:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-01 17:12:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-01 08:16:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-01 17:12:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-01 08:18:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-01 17:20:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-01 08:15:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-01 17:18:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-01 08:05:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-01 17:18:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-01 08:14:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-01 17:07:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-01 08:25:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-01 17:07:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-01 08:24:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-01 17:15:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-01 08:27:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-01 16:57:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-01 08:07:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-01 17:13:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-01 08:20:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-01 17:01:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-01 08:19:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-01 17:23:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-01 08:18:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-01 17:24:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-01 08:08:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-01 17:07:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-01 08:12:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-01 17:00:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-01 08:09:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-01 17:04:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-01 08:17:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-01 17:07:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-02 08:12:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-02 17:15:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-02 08:20:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-02 17:07:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-02 08:16:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-02 17:20:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-02 08:19:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-02 17:15:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-02 08:15:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-02 17:06:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-02 08:13:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-02 17:19:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-02 08:22:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-02 17:00:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-02 08:15:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-02 17:04:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-02 08:09:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-02 17:05:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-02 08:24:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-02 17:21:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-02 08:24:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-02 17:20:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-02 08:08:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-02 17:09:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-02 08:11:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-02 17:09:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-02 08:09:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-02 17:03:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-02 08:27:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-02 17:16:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-02 08:28:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-02 16:56:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-02 08:24:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-02 16:58:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-02 08:23:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-02 17:04:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-02 08:17:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-02 17:23:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-02 08:29:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-02 17:17:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-03 08:17:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-03 17:22:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-03 08:16:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-03 17:05:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-03 08:14:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-03 17:02:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-03 08:24:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-03 17:05:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-03 08:23:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-03 16:59:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-03 08:11:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-03 17:07:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-03 08:10:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-03 17:06:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-03 08:06:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-03 16:58:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-03 08:28:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-03 17:13:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-03 08:07:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-03 16:58:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-03 08:18:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-03 17:08:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-03 08:11:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-03 17:02:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-03 08:26:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-03 17:17:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-03 08:23:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-03 17:18:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-03 08:14:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-03 17:01:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-03 08:12:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-03 17:04:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-03 08:26:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-03 16:58:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-03 08:15:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-03 17:01:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-03 08:24:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-03 17:13:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-03 08:12:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-03 17:12:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-04 08:14:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-04 16:57:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-04 08:12:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-04 17:21:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-04 08:23:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-04 17:14:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-04 08:26:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-04 17:11:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-04 08:08:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-04 17:16:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-04 08:06:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-04 17:21:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-04 08:14:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-04 17:18:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-04 08:10:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-04 17:16:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-04 08:08:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-04 17:23:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-04 08:30:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-04 17:02:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-04 08:07:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-04 17:07:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-04 08:13:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-04 17:12:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-04 08:22:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-04 16:57:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-04 08:23:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-04 17:17:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-04 08:28:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-04 17:00:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-04 08:11:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-04 17:00:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-04 08:18:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-04 17:07:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-04 08:08:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-04 17:14:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-04 08:27:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-04 16:57:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-04 08:13:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-04 17:21:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-07 08:21:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-07 17:09:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-07 08:11:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-07 16:58:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-07 08:18:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-07 17:25:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-07 08:27:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-07 17:23:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-07 08:08:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-07 17:22:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-07 08:16:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-07 17:08:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-07 08:22:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-07 17:01:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-07 08:12:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-07 17:13:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-07 08:07:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-07 16:56:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-07 08:12:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-07 17:24:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-07 08:27:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-07 16:59:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-07 08:20:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-07 16:57:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-07 08:28:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-07 17:23:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-07 08:11:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-07 17:08:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-07 08:29:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-07 17:05:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-07 08:25:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-07 17:10:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-07 08:12:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-07 16:57:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-07 08:16:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-07 17:22:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-07 08:10:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-07 17:13:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-07 08:13:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-07 17:11:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-08 08:13:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-08 17:18:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-08 08:19:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-08 17:22:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-08 08:18:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-08 17:12:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-08 08:13:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-08 17:12:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-08 08:09:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-08 17:06:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-08 08:29:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-08 17:00:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-08 08:30:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-08 17:21:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-08 08:17:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-08 16:57:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-08 08:08:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-08 17:09:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-08 08:30:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-08 17:07:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-08 08:06:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-08 17:10:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-08 08:26:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-08 16:58:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-08 08:17:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-08 17:13:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-08 08:14:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-08 17:01:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-08 08:09:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-08 16:56:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-08 08:21:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-08 17:12:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-08 08:13:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-08 16:56:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-08 08:22:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-08 17:21:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-08 08:18:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-08 17:02:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-08 08:25:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-08 17:16:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-09 08:08:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-09 17:16:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-09 08:30:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-09 17:19:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-09 08:05:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-09 17:03:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-09 08:22:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-09 17:22:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-09 08:16:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-09 17:20:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-09 08:07:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-09 17:15:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-09 08:26:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-09 17:14:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-09 08:10:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-09 17:08:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-09 08:13:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-09 16:59:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-09 08:22:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-09 17:06:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-09 08:09:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-09 17:21:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-09 08:29:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-09 17:15:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-09 08:28:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-09 16:56:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-09 08:26:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-09 16:57:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-09 08:17:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-09 17:20:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-09 08:24:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-09 17:19:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-09 08:25:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-09 17:22:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-09 08:05:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-09 17:10:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-09 08:06:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-09 17:13:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-09 08:09:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-09 17:25:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-10 08:16:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-10 17:13:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-10 08:26:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-10 16:57:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-10 08:20:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-10 17:24:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-10 08:09:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-10 17:16:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-10 08:10:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-10 17:17:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-10 08:13:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-10 17:23:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-10 08:15:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-10 17:23:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-10 08:07:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-10 17:13:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-10 08:17:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-10 17:17:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-10 08:20:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-10 17:10:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-10 08:25:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-10 17:21:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-10 08:27:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-10 17:06:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-10 08:14:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-10 17:02:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-10 08:14:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-10 17:10:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-10 08:13:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-10 17:11:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-10 08:22:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-10 17:17:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-10 08:24:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-10 17:25:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-10 08:17:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-10 17:14:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-10 08:25:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-10 17:15:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-10 08:14:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-10 17:13:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-11 08:28:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-11 17:00:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-11 08:23:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-11 17:20:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-11 08:28:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-11 17:23:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-11 08:18:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-11 16:59:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-11 08:17:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-11 17:21:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-11 08:21:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-11 17:21:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-11 08:09:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-11 17:22:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-11 08:29:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-11 17:02:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-11 08:16:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-11 17:20:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-11 08:12:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-11 17:19:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-11 08:09:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-11 17:02:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-11 08:22:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-11 16:55:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-11 08:14:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-11 17:18:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-11 08:10:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-11 17:20:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-11 08:28:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-11 17:22:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-11 08:09:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-11 16:59:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-11 08:24:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-11 17:21:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-11 08:17:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-11 16:55:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-11 08:26:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-11 16:58:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-11 08:25:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-11 16:57:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-14 08:12:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-14 17:22:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-14 08:14:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-14 17:14:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-14 08:18:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-14 17:19:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-14 08:09:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-14 17:10:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-14 08:16:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-14 17:05:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-14 08:25:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-14 17:02:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-14 08:12:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-14 17:19:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-14 08:22:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-14 17:03:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-14 08:24:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-14 17:00:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-14 08:29:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-14 17:13:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-14 08:07:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-14 17:25:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-14 08:21:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-14 17:15:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-14 08:09:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-14 17:22:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-14 08:28:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-14 17:15:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-14 08:24:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-14 16:58:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-14 08:16:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-14 17:06:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-14 08:25:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-14 17:17:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-14 08:16:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-14 16:55:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-14 08:26:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-14 17:10:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-14 08:26:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-14 17:08:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-15 08:26:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-15 17:20:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-15 08:05:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-15 17:07:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-15 08:13:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-15 17:16:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-15 08:29:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-15 17:08:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-15 08:25:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-15 17:17:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-15 08:30:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-15 17:20:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-15 08:05:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-15 16:57:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-15 08:13:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-15 17:08:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-15 08:06:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-15 17:25:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-15 08:20:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-15 17:06:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-15 08:24:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-15 17:18:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-15 08:24:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-15 17:02:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-15 08:29:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-15 16:55:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-15 08:24:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-15 17:01:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-15 08:22:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-15 17:11:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-15 08:07:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-15 17:20:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-15 08:06:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-15 17:09:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-15 08:29:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-15 17:02:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-15 08:28:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-15 17:23:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-15 08:16:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-15 17:15:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-16 08:06:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-16 16:55:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-16 08:20:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-16 16:59:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-16 08:10:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-16 16:58:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-16 08:24:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-16 17:07:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-16 08:29:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-16 17:08:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-16 08:09:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-16 17:14:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-16 08:12:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-16 17:01:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-16 08:13:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-16 16:59:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-16 08:11:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-16 17:14:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-16 08:09:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-16 17:19:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-16 08:22:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-16 16:58:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-16 08:15:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-16 17:06:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-16 08:11:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-16 17:07:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-16 08:30:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-16 17:02:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-16 08:06:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-16 17:11:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-16 08:30:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-16 17:23:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-16 08:09:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-16 17:16:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-16 08:13:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-16 17:18:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-16 08:22:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-16 17:04:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-16 08:08:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-16 17:11:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-17 08:24:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-17 17:20:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-17 08:28:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-17 17:15:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-17 08:22:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-17 17:05:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-17 08:06:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-17 17:08:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-17 08:12:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-17 17:16:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-17 08:23:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-17 17:02:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-17 08:21:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-17 17:09:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-17 08:05:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-17 17:07:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-17 08:20:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-17 17:14:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-17 08:06:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-17 17:01:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-17 08:28:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-17 16:59:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-17 08:20:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-17 17:22:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-17 08:18:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-17 17:04:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-17 08:10:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-17 17:17:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-17 08:14:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-17 17:25:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-17 08:14:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-17 17:18:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-17 08:25:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-17 17:21:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-17 08:28:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-17 17:13:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-17 08:06:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-17 17:17:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-17 08:22:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-17 16:58:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-18 08:09:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-18 17:24:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-18 08:05:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-18 17:17:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-18 08:24:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-18 16:56:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-18 08:17:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-18 17:08:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-18 08:17:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-18 17:07:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-18 08:23:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-18 17:05:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-18 08:21:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-18 17:07:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-18 08:17:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-18 17:10:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-18 08:07:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-18 16:57:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-18 08:20:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-18 16:55:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-18 08:21:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-18 16:59:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-18 08:09:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-18 17:18:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-18 08:20:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-18 17:18:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-18 08:24:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-18 17:07:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-18 08:27:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-18 16:57:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-18 08:07:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-18 17:11:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-18 08:11:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-18 17:21:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-18 08:14:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-18 17:25:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-18 08:14:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-18 17:13:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-18 08:16:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-18 17:25:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-21 08:05:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-21 17:09:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-21 08:17:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-21 17:16:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-21 08:24:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-21 17:18:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-21 08:17:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-21 17:04:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-21 08:21:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-21 17:22:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-21 08:23:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-21 17:21:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-21 08:26:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-21 16:55:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-21 08:07:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-21 17:14:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-21 08:13:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-21 17:10:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-21 08:27:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-21 17:15:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-21 08:26:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-21 17:14:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-21 08:29:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-21 17:01:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-21 08:26:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-21 17:14:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-21 08:28:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-21 17:11:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-21 08:10:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-21 16:59:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-21 08:08:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-21 17:02:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-21 08:14:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-21 17:25:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-21 08:18:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-21 17:13:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-21 08:21:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-21 16:58:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-21 08:29:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-21 17:10:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-22 08:29:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-22 17:01:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-22 08:30:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-22 17:21:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-22 08:11:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-22 17:22:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-22 08:12:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-22 17:12:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-22 08:22:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-22 17:00:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-22 08:22:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-22 17:11:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-22 08:19:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-22 17:08:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-22 08:19:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-22 16:56:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-22 08:19:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-22 17:09:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-22 08:25:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-22 17:15:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-22 08:06:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-22 17:25:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-22 08:22:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-22 16:58:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-22 08:18:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-22 17:00:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-22 08:22:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-22 17:09:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-22 08:06:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-22 16:55:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-22 08:11:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-22 17:07:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-22 08:18:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-22 16:55:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-22 08:11:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-22 17:25:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-22 08:17:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-22 17:16:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-22 08:27:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-22 17:08:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-23 08:30:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-23 17:10:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-23 08:20:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-23 17:15:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-23 08:08:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-23 17:02:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-23 08:08:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-23 17:18:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-23 08:13:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-23 17:19:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-23 08:09:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-23 17:16:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-23 08:17:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-23 17:16:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-23 08:28:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-23 17:23:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-23 08:28:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-23 17:03:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-23 08:25:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-23 17:18:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-23 08:25:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-23 17:05:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-23 08:09:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-23 17:01:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-23 08:17:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-23 16:55:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-23 08:09:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-23 17:07:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-23 08:25:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-23 17:25:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-23 08:05:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-23 17:01:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-23 08:08:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-23 17:09:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-23 08:13:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-23 17:20:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-23 08:05:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-23 17:01:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-23 08:21:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-23 16:59:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-24 08:16:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-24 17:06:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-24 08:11:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-24 17:08:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-24 08:05:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-24 17:03:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-24 08:08:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-24 17:24:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-24 08:20:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-24 17:05:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-24 08:19:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-24 17:20:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-24 08:10:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-24 17:14:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-24 08:25:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-24 17:22:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-24 08:08:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-24 17:23:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-24 08:19:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-24 17:12:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-24 08:26:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-24 17:11:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-24 08:30:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-24 17:00:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-24 08:27:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-24 16:55:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-24 08:15:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-24 17:11:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-24 08:20:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-24 17:06:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-24 08:22:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-24 17:01:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-24 08:20:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-24 17:18:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-24 08:22:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-24 17:24:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-24 08:21:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-24 16:57:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-24 08:14:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-24 16:56:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-25 08:21:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-25 17:24:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-25 08:13:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-25 17:08:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-25 08:05:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-25 17:25:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-25 08:23:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-25 17:21:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-25 08:20:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-25 17:13:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-25 08:06:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-25 17:22:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-25 08:29:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-25 17:05:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-25 08:27:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-25 16:55:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-25 08:20:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-25 17:19:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-25 08:23:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-25 17:07:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-25 08:20:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-25 17:14:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-25 08:26:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-25 16:55:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-25 08:22:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-25 17:12:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-25 08:26:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-25 17:02:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-25 08:13:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-25 17:19:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-25 08:16:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-25 17:06:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-25 08:07:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-25 17:16:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-25 08:29:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-25 17:00:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-25 08:20:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-25 17:12:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-25 08:05:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-25 17:22:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-28 08:23:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-28 17:14:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-28 08:24:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-28 17:16:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-28 08:21:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-28 17:12:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-28 08:17:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-28 16:59:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-28 08:23:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-28 17:24:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-28 08:12:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-28 17:09:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-28 08:29:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-28 17:07:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-28 08:11:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-28 17:01:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-28 08:16:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-28 17:05:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-28 08:21:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-28 17:24:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-28 08:25:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-28 16:56:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-28 08:22:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-28 16:55:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-28 08:23:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-28 16:57:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-28 08:28:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-28 17:08:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-28 08:29:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-28 17:19:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-28 08:30:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-28 17:01:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-28 08:05:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-28 17:11:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-28 08:05:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-28 16:58:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-28 08:05:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-28 17:02:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-28 08:12:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-28 17:00:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-29 08:10:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-29 17:25:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-29 08:17:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-29 16:57:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-29 08:10:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-29 17:15:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-29 08:20:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-29 17:19:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-29 08:14:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-29 16:56:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-29 08:19:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-29 17:08:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-29 08:23:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-29 17:07:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-29 08:06:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-29 17:15:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-29 08:18:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-29 17:04:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-29 08:25:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-29 17:09:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-29 08:23:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-29 17:19:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-29 08:15:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-29 17:01:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-29 08:11:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-29 17:19:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-29 08:08:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-29 17:06:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-29 08:05:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-29 17:14:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-29 08:06:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-29 17:00:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-29 08:24:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-29 17:11:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-29 08:17:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-29 17:19:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-29 08:13:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-29 17:21:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-29 08:11:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-29 17:18:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-04-30 08:19:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-04-30 16:58:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-04-30 08:21:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-04-30 17:24:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-04-30 08:10:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-04-30 17:02:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-04-30 08:26:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-04-30 16:55:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-04-30 08:13:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-04-30 17:00:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-04-30 08:17:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-04-30 17:22:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-04-30 08:05:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-04-30 17:20:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-04-30 08:24:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-04-30 17:21:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-04-30 08:25:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-04-30 17:13:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-04-30 08:11:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-04-30 17:03:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-04-30 08:20:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-04-30 17:17:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-04-30 08:24:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-04-30 17:10:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-04-30 08:12:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-04-30 17:19:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-04-30 08:12:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-04-30 17:05:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-04-30 08:23:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-04-30 17:20:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-04-30 08:16:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-04-30 17:04:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-04-30 08:21:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-04-30 17:23:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-04-30 08:25:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-04-30 17:01:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-04-30 08:08:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-04-30 17:22:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-04-30 08:13:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-04-30 17:09:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-01 08:29:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-01 17:21:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-01 08:20:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-01 16:55:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-01 08:17:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-01 17:22:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-01 08:14:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-01 17:12:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-01 08:18:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-01 16:55:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-01 08:10:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-01 17:09:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-01 08:15:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-01 17:10:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-01 08:22:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-01 17:05:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-01 08:20:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-01 17:04:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-01 08:19:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-01 17:22:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-01 08:05:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-01 17:08:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-01 08:05:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-01 17:22:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-01 08:13:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-01 17:03:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-01 08:13:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-01 17:25:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-01 08:18:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-01 17:25:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-01 08:20:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-01 17:14:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-01 08:13:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-01 17:01:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-01 08:28:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-01 17:24:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-01 08:17:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-01 17:16:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-01 08:10:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-01 17:18:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-02 08:28:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-02 17:21:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-02 08:24:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-02 17:06:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-02 08:06:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-02 17:01:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-02 08:20:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-02 17:15:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-02 08:14:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-02 17:08:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-02 08:16:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-02 17:01:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-02 08:07:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-02 17:25:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-02 08:29:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-02 17:20:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-02 08:30:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-02 17:20:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-02 08:16:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-02 17:14:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-02 08:05:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-02 17:04:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-02 08:09:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-02 16:59:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-02 08:24:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-02 17:22:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-02 08:17:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-02 17:03:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-02 08:09:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-02 17:23:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-02 08:21:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-02 16:56:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-02 08:16:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-02 16:59:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-02 08:13:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-02 17:20:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-02 08:27:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-02 17:19:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-02 08:23:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-02 16:58:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-05 08:22:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-05 17:20:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-05 08:09:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-05 17:09:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-05 08:08:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-05 17:12:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-05 08:23:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-05 17:25:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-05 08:06:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-05 17:20:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-05 08:17:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-05 17:09:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-05 08:15:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-05 17:20:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-05 08:30:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-05 16:57:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-05 08:06:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-05 16:59:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-05 08:18:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-05 17:19:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-05 08:11:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-05 17:21:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-05 08:29:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-05 17:15:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-05 08:28:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-05 17:06:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-05 08:25:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-05 17:02:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-05 08:05:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-05 17:22:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-05 08:24:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-05 17:00:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-05 08:18:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-05 17:08:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-05 08:17:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-05 17:16:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-05 08:07:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-05 17:25:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-05 08:19:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-05 17:14:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-06 08:11:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-06 17:08:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-06 08:29:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-06 17:04:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-06 08:05:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-06 17:10:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-06 08:24:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-06 17:07:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-06 08:13:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-06 17:02:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-06 08:07:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-06 17:15:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-06 08:11:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-06 17:20:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-06 08:18:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-06 17:01:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-06 08:10:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-06 17:13:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-06 08:28:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-06 17:04:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-06 08:27:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-06 17:21:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-06 08:20:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-06 16:57:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-06 08:25:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-06 17:11:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-06 08:11:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-06 17:17:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-06 08:14:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-06 17:04:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-06 08:16:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-06 17:23:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-06 08:08:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-06 17:00:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-06 08:24:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-06 17:05:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-06 08:24:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-06 17:18:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-06 08:11:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-06 16:56:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-07 08:20:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-07 17:15:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-07 08:08:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-07 17:04:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-07 08:14:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-07 17:14:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-07 08:13:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-07 16:55:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-07 08:29:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-07 17:04:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-07 08:29:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-07 17:05:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-07 08:14:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-07 17:01:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-07 08:19:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-07 17:12:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-07 08:07:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-07 17:05:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-07 08:12:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-07 17:05:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-07 08:06:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-07 17:01:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-07 08:11:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-07 17:17:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-07 08:13:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-07 17:25:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-07 08:27:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-07 17:00:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-07 08:13:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-07 17:24:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-07 08:07:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-07 17:02:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-07 08:20:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-07 17:20:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-07 08:18:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-07 17:23:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-07 08:28:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-07 17:18:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-07 08:12:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-07 16:58:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-08 08:28:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-08 17:19:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-08 08:20:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-08 17:23:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-08 08:19:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-08 17:02:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-08 08:14:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-08 17:12:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-08 08:09:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-08 17:07:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-08 08:27:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-08 17:00:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-08 08:09:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-08 17:18:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-08 08:27:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-08 17:14:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-08 08:12:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-08 17:24:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-08 08:19:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-08 17:07:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-08 08:07:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-08 17:14:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-08 08:06:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-08 17:07:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-08 08:25:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-08 17:00:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-08 08:29:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-08 16:57:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-08 08:17:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-08 17:25:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-08 08:26:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-08 17:12:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-08 08:29:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-08 16:57:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-08 08:08:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-08 17:17:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-08 08:09:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-08 17:16:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-08 08:17:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-08 17:02:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-09 08:06:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-09 17:15:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-09 08:28:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-09 17:01:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-09 08:09:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-09 16:58:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-09 08:20:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-09 17:23:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-09 08:12:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-09 17:16:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-09 08:11:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-09 17:20:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-09 08:10:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-09 17:19:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-09 08:17:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-09 17:21:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-09 08:18:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-09 17:12:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-09 08:13:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-09 17:10:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-09 08:12:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-09 17:17:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-09 08:15:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-09 17:10:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-09 08:25:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-09 17:06:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-09 08:11:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-09 17:25:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-09 08:08:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-09 17:00:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-09 08:26:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-09 17:22:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-09 08:10:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-09 16:55:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-09 08:06:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-09 17:13:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-09 08:29:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-09 17:22:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-09 08:10:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-09 17:06:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:12:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:06:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:13:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-12 16:57:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:24:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-12 17:00:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:07:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:18:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:19:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:08:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:29:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-12 16:58:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:22:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:24:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:25:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:23:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:05:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-12 17:15:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:11:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:24:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:21:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-12 16:58:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:27:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-12 16:56:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:29:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:25:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:23:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:12:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:10:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-12 17:20:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:25:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:11:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:08:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:13:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-12 08:09:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-12 17:25:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-12 08:15:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-12 17:21:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-12 08:17:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-12 17:18:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:19:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:10:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:27:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:00:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:13:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:13:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:19:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:14:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:27:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:22:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:17:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:12:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:26:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:14:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:28:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:03:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:05:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:09:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:13:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:16:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:27:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:04:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:12:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:11:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:18:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:03:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:22:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-13 16:59:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:09:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:20:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:13:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:06:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:26:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-13 17:22:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-13 08:21:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-13 17:12:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-13 08:25:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-13 17:24:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-13 08:28:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-13 16:59:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:06:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:24:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:23:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:02:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:29:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:11:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:06:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:03:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:21:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:06:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:08:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:11:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:23:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:03:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:30:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:18:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:26:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:09:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:08:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:12:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:25:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-14 16:57:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:27:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:21:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:14:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-14 16:56:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:09:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:07:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:29:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:08:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:10:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:04:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:27:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:11:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-14 08:14:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-14 17:08:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-14 08:28:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-14 17:09:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-14 08:18:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-14 17:13:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:20:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-15 17:09:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:27:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:23:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:27:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-15 16:56:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:18:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-15 16:56:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:28:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:08:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:06:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-15 17:25:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:22:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-15 17:13:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:10:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:07:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:24:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-15 17:17:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:28:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-15 17:23:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:07:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:25:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:13:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-15 16:58:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:13:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-15 17:08:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:05:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:18:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:05:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-15 16:56:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:21:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-15 17:09:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:20:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-15 17:03:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-15 08:15:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-15 17:04:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-15 08:25:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-15 16:57:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-15 08:23:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-15 16:59:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:11:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-16 17:19:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:05:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:22:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:21:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:25:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:18:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-16 17:21:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:29:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:14:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:18:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:15:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:10:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-16 16:58:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:09:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:15:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:24:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:23:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:22:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-16 17:06:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:09:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:10:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:07:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:13:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:05:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-16 17:03:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:12:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:10:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:26:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:15:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:30:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-16 17:00:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:19:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:24:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-16 08:27:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-16 17:20:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-16 08:06:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-16 16:55:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-16 08:28:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-16 17:00:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:23:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:07:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:12:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:19:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:11:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:17:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:05:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:00:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:16:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:22:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:09:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:12:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:27:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:24:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:28:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:07:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:27:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:25:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:14:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:24:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:21:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:12:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:21:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:03:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:14:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:22:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:18:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:17:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:26:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:12:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:09:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-19 17:01:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:26:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:17:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-19 08:22:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-19 17:03:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-19 08:12:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-19 16:57:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-19 08:10:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-19 17:19:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:17:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:22:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:16:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:24:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:12:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:22:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:24:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:25:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:18:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:03:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:18:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:03:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:06:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:01:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:25:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:23:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:12:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:20:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:28:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:18:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:26:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-20 16:56:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:10:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:14:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:17:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:21:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:15:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-20 17:22:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:19:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:05:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:20:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:14:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:24:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-20 16:55:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-20 08:20:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-20 17:03:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-20 08:26:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-20 17:14:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-20 08:22:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-20 16:58:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:15:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:01:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:30:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:19:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:22:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:09:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:18:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:02:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:08:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:00:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:17:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:01:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:24:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:08:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:07:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:02:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:14:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-21 16:58:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:17:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:16:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:11:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:09:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:29:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:12:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:10:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-21 16:58:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:13:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:22:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:05:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:22:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:24:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:09:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:12:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:04:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-21 08:13:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-21 17:24:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-21 08:13:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-21 17:16:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-21 08:17:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-21 17:01:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:10:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:11:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:19:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:01:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:08:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-22 17:13:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:25:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:17:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:08:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:02:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:07:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-22 17:00:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:27:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:04:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:09:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-22 16:57:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:12:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-22 17:04:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:11:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:15:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:30:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-22 16:57:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:08:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-22 16:55:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:10:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-22 16:56:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:24:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:24:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:06:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-22 17:22:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:13:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:11:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:13:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:24:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-22 08:26:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-22 17:07:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-22 08:15:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-22 17:22:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-22 08:06:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-22 17:07:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:19:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:04:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:27:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:06:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:25:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-23 17:12:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:15:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-23 16:56:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:07:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:16:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:21:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-23 17:14:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:19:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:21:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:12:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:21:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:21:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-23 17:11:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:29:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:17:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:17:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:00:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:29:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-23 17:03:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:11:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:03:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:11:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:03:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:29:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-23 17:19:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:26:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:23:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:30:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:25:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-23 08:06:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-23 17:02:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-23 08:24:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-23 17:23:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-23 08:24:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-23 17:12:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-26 08:25:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-26 17:17:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-26 08:17:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-26 17:18:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-26 08:13:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-26 17:15:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-26 08:20:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-26 17:01:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-26 08:11:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-26 17:11:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-26 08:15:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-26 16:56:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-26 08:20:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-26 17:12:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-26 08:07:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-26 17:11:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-26 08:23:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-26 17:15:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-26 08:29:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-26 17:07:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-26 08:09:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-26 17:24:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-26 08:15:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-26 16:56:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-26 08:27:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-26 17:00:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-26 08:12:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-26 16:58:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-26 08:14:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-26 17:07:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-26 08:22:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-26 17:18:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-26 08:26:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-26 17:14:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-26 08:19:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-26 17:17:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-26 08:19:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-26 16:57:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-26 08:20:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-26 17:17:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-27 08:27:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-27 17:03:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-27 08:10:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-27 16:59:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-27 08:07:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-27 17:20:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-27 08:28:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-27 16:59:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-27 08:12:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-27 16:57:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-27 08:21:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-27 17:20:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-27 08:18:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-27 17:15:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-27 08:06:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-27 17:04:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-27 08:30:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-27 17:11:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-27 08:07:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-27 17:02:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-27 08:24:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-27 17:13:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-27 08:29:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-27 16:59:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-27 08:08:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-27 16:57:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-27 08:06:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-27 17:01:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-27 08:17:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-27 17:05:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-27 08:23:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-27 17:14:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-27 08:16:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-27 17:11:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-27 08:18:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-27 17:02:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-27 08:26:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-27 17:05:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-27 08:27:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-27 17:06:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-28 08:21:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-28 17:13:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-28 08:17:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-28 17:23:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-28 08:16:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-28 17:04:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-28 08:15:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-28 17:01:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-28 08:22:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-28 17:24:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-28 08:22:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-28 17:08:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-28 08:22:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-28 17:17:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-28 08:26:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-28 17:23:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-28 08:13:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-28 16:58:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-28 08:30:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-28 17:11:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-28 08:18:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-28 17:24:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-28 08:23:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-28 17:21:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-28 08:16:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-28 17:11:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-28 08:10:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-28 17:05:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-28 08:17:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-28 17:24:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-28 08:14:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-28 17:20:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-28 08:29:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-28 17:22:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-28 08:10:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-28 17:00:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-28 08:30:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-28 17:23:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-28 08:25:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-28 16:59:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-29 08:12:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-29 16:56:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-29 08:06:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-29 17:09:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-29 08:29:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-29 17:06:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-29 08:25:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-29 16:56:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-29 08:06:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-29 17:23:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-29 08:13:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-29 17:03:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-29 08:21:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-29 17:00:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-29 08:29:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-29 16:57:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-29 08:13:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-29 17:01:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-29 08:05:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-29 17:22:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-29 08:30:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-29 17:13:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-29 08:26:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-29 17:08:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-29 08:08:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-29 17:21:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-29 08:17:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-29 17:10:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-29 08:18:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-29 17:11:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-29 08:18:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-29 17:21:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-29 08:27:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-29 17:19:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-29 08:05:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-29 17:07:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-29 08:26:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-29 17:11:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-29 08:25:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-29 17:07:00'),
(1, 'in', -18.1398, 178.4266, 'password', '2025-05-30 08:28:00'),
(1, 'out', -18.1398, 178.4266, 'password', '2025-05-30 17:11:00'),
(2, 'in', -17.7533, 177.4435, 'password', '2025-05-30 08:14:00'),
(2, 'out', -17.7533, 177.4435, 'password', '2025-05-30 17:00:00'),
(3, 'in', -16.4302, 179.3822, 'password', '2025-05-30 08:29:00'),
(3, 'out', -16.4302, 179.3822, 'password', '2025-05-30 17:08:00'),
(4, 'in', -18.1398, 178.4266, 'password', '2025-05-30 08:19:00'),
(4, 'out', -18.1398, 178.4266, 'password', '2025-05-30 16:56:00'),
(5, 'in', -17.7533, 177.4435, 'password', '2025-05-30 08:22:00'),
(5, 'out', -17.7533, 177.4435, 'password', '2025-05-30 16:59:00'),
(6, 'in', -16.4302, 179.3822, 'password', '2025-05-30 08:17:00'),
(6, 'out', -16.4302, 179.3822, 'password', '2025-05-30 16:57:00'),
(7, 'in', -18.1398, 178.4266, 'password', '2025-05-30 08:11:00'),
(7, 'out', -18.1398, 178.4266, 'password', '2025-05-30 17:25:00'),
(8, 'in', -17.7533, 177.4435, 'password', '2025-05-30 08:21:00'),
(8, 'out', -17.7533, 177.4435, 'password', '2025-05-30 17:17:00'),
(9, 'in', -16.4302, 179.3822, 'password', '2025-05-30 08:29:00'),
(9, 'out', -16.4302, 179.3822, 'password', '2025-05-30 17:25:00'),
(10, 'in', -18.1398, 178.4266, 'password', '2025-05-30 08:17:00'),
(10, 'out', -18.1398, 178.4266, 'password', '2025-05-30 17:12:00'),
(11, 'in', -17.7533, 177.4435, 'password', '2025-05-30 08:19:00'),
(11, 'out', -17.7533, 177.4435, 'password', '2025-05-30 17:05:00'),
(12, 'in', -16.4302, 179.3822, 'password', '2025-05-30 08:22:00'),
(12, 'out', -16.4302, 179.3822, 'password', '2025-05-30 17:23:00'),
(13, 'in', -18.1398, 178.4266, 'password', '2025-05-30 08:20:00'),
(13, 'out', -18.1398, 178.4266, 'password', '2025-05-30 17:00:00'),
(14, 'in', -17.7533, 177.4435, 'password', '2025-05-30 08:06:00'),
(14, 'out', -17.7533, 177.4435, 'password', '2025-05-30 17:19:00'),
(15, 'in', -16.4302, 179.3822, 'password', '2025-05-30 08:19:00'),
(15, 'out', -16.4302, 179.3822, 'password', '2025-05-30 16:59:00'),
(16, 'in', -18.1398, 178.4266, 'password', '2025-05-30 08:28:00'),
(16, 'out', -18.1398, 178.4266, 'password', '2025-05-30 16:58:00'),
(17, 'in', -17.7533, 177.4435, 'password', '2025-05-30 08:22:00'),
(17, 'out', -17.7533, 177.4435, 'password', '2025-05-30 17:22:00'),
(18, 'in', -16.4302, 179.3822, 'password', '2025-05-30 08:08:00'),
(18, 'out', -16.4302, 179.3822, 'password', '2025-05-30 17:11:00'),
(19, 'in', -18.1398, 178.4266, 'password', '2025-05-30 08:10:00'),
(19, 'out', -18.1398, 178.4266, 'password', '2025-05-30 17:02:00'),
(20, 'in', -17.7533, 177.4435, 'password', '2025-05-30 08:15:00'),
(20, 'out', -17.7533, 177.4435, 'password', '2025-05-30 17:04:00');

-- Sample calendar events
INSERT INTO calendar_events (id, title, description, start_time, end_time, location, created_at) VALUES
  (1, 'System Demo', 'Initial system demonstration', '2025-06-01 09:00:00', '2025-06-01 10:00:00', 'Conference Room', NOW()),
  (2, 'Weekly Sync', NULL, '2025-06-02 14:00:00', '2025-06-02 15:00:00', 'Online', NOW()),
  (3, 'Client Meeting', 'Discussion with client', '2025-06-03 11:00:00', '2025-06-03 12:00:00', 'Zoom', NOW());

-- Sample meeting links
INSERT INTO meeting_links (id, event_id, url, created_at) VALUES
  (1, 1, 'https://meet.example.com/demo', NOW()),
  (2, 2, 'https://meet.example.com/sync', NOW()),
  (3, 3, 'https://meet.example.com/client', NOW());



-- Source: demoData/ohs_absence_demo.sql
-- Demo OHS injury and absence integration
-- Example incident with restricted duties
INSERT INTO ohs_incidents (
  id, injury_date, injury_time, classification, nature, location,
  activity, how_sustained, days_lost, resumption_date, outcome, status,
  tenant_id, branch_id
) VALUES
  (1, '2025-05-15', '09:30', 'Injury', 'Back strain', 'Warehouse',
   'Lifting boxes', 'Overexertion while lifting', 3, '2025-05-19',
   'Under treatment', 'reported', 1, 1);

INSERT INTO ohs_medicals (
  id, incident_id, first_name, surname, job_title,
  incident_date, incident_time, medical_treatment,
  employment_status, tenant_id, branch_id
) VALUES
  (1, 1, 'Bob', 'Smith', 'Software Engineer',
   '2025-05-15', '09:30', 'Physiotherapy',
   'Full-Time', 1, 1);

UPDATE employees
  SET medical_restrictions = 'No heavy lifting until 2025-05-20'
  WHERE id = 2;

INSERT INTO leave_requests (
  id, employeeName, leaveType, startDate, endDate,
  reason, status, createdBy, approvedAt, approvedBy
) VALUES
  (3, 'Bob Smith', 'Work-Related Injury', '2025-05-15', '2025-05-18',
   'Back strain while lifting', 'Approved', 1, '2025-05-15', 1);

INSERT INTO attendance (
  id, employee, date, restricted_start, restricted_end,
  hours_worked, overtime, injury_flag, restricted_duty, pay_code
) VALUES
  (1, 'Bob Smith', '2025-05-15', NULL, NULL, 0, 0, TRUE, FALSE, 'INJ'),
  (2, 'Bob Smith', '2025-05-19', '09:00', '13:00', 4, 0, FALSE, TRUE, 'REST'),
  (3, 'Bob Smith', '2025-05-20', '09:00', '13:00', 4, 0, FALSE, TRUE, 'REST');


-- Source: demoData/ohs_dashboard_demo.sql
-- Demo OHS incidents for dashboard metrics
INSERT INTO ohs_incidents (
  id, injury_date, injury_time, classification, nature, location,
  activity, how_sustained, days_lost, outcome, status, tenant_id, branch_id
) VALUES
  (2, '2025-06-01', '10:00', 'first_aid', 'minor', 'Workshop',
   'Using box cutter', 'Hand slipped while opening package', 0,
   'Treated onsite', 'closed', 1, 1),
  (3, '2025-06-05', '14:20', 'near_miss', 'none', 'Warehouse',
   'Forklift operating', 'Pallet nearly struck employee', 0,
   'No injury', 'reported', 1, 1),
  (4, '2025-06-08', '11:15', 'medical_treatment', 'moderate', 'Construction Site',
   'Carrying tools', 'Tripped on uneven surface', 0,
   'Clinic visit', 'investigating', 1, 1),
  (5, '2025-06-12', '08:40', 'lti', 'major', 'Maintenance Yard',
   'Working on ladder', 'Fall from height', 14,
   'Workers comp', 'reported', 1, 1),
  (6, '2025-06-20', '09:10', 'fatality', 'critical', 'Highway Project',
   'Traffic control', 'Hit by reversing truck', NULL,
  'Under investigation', 'investigating', 1, 1);

-- Additional near miss incidents for dashboard trends
INSERT INTO ohs_incidents (
  id, injury_date, injury_time, classification, nature, location,
  activity, how_sustained, days_lost, outcome, status, tenant_id, branch_id
) VALUES
  (7, '2025-07-03', '09:00', 'near_miss', 'none', 'Warehouse',
   'Stacking pallets', 'Worker slipped but caught themselves', 0,
   'No injury', 'reported', 1, 1),
  (8, '2025-07-15', '15:30', 'near_miss', 'none', 'Workshop',
   'Operating drill', 'Drill bit broke, no injury', 0,
   'No injury', 'reported', 1, 1);

-- Logs for near miss leaderboard
INSERT INTO ohs_incident_logs (
  id, incident_id, action, details, user_id, logged_at, tenant_id, branch_id
) VALUES
  (1, 3, 'created', NULL, 1, '2025-06-05 14:30', 1, 1),
  (2, 7, 'created', NULL, 1, '2025-07-03 09:30', 1, 1),
  (3, 8, 'created', NULL, 1, '2025-07-15 16:00', 1, 1);

-- Map sample user to employee for leaderboard names
INSERT INTO employees2users (id, employee_id, user_id) VALUES
  (1, 1, 1);

-- Sample workflows illustrating action status automation
INSERT INTO workflows (id, name, trigger_event, definition, is_active) VALUES
  (200, 'OHS Action Overdue Notification', 'ohs.actionOverdue', '{"conditions":[]}', TRUE),
  (201, 'OHS Action Completed', 'ohs.actionCompleted', '{"conditions":[]}', TRUE);

INSERT INTO workflow_steps (workflow_id, step_order, step_type, config) VALUES
  (200, 1, 'update_status', '{"table":"ohs_actions","field":"status","value":"overdue"}'),
  (200, 2, 'notify_manager', '{"message":"Corrective action overdue"}'),
  (201, 1, 'update_status', '{"table":"ohs_actions","field":"status","value":"completed"}');
-- Source: demoData/ohs_incident_form.sql
-- Demo OHS Incident form with multi-step fields
-- Clears existing elements then inserts new definitions
-- Demo OHS Incident form with multi-step fields
-- Clears existing elements then inserts new definitions

DELETE FROM form_elements WHERE form_id = 4;

-- Base form record (if not already present)
INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES (4, 'OHS Incident', 'Default incident report form', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

-- Form fields
INSERT INTO form_elements (form_id, label, field_name, data_column, type_id, order_index) VALUES
    (4, 'injury_date', 'injury_date', 'injury_date', 3, 1),
    (4, 'injury_time', 'injury_time', 'injury_time', 1, 2),
    (4, 'classification', 'classification', 'classification', 4, 3),
    (4, 'location', 'location', 'location', 1, 4),
    (4, 'nature', 'nature', 'nature', 1, 5),
    (4, 'workplace_part', 'workplace_part', 'workplace_part', 1, 6),
    (4, 'activity', 'activity', 'activity', 1, 7),
    (4, 'unexpected', 'unexpected', 'unexpected', 1, 8),
    (4, 'how_sustained', 'how_sustained', 'how_sustained', 1, 9),
    (4, 'completed_by', 'completed_by', 'completed_by', 1, 10),
    (4, 'position', 'position', 'position', 1, 11),
    (4, 'outcome', 'outcome', 'outcome', 1, 12),
    (4, 'preventative_action', 'preventative_action', 'preventative_action', 1, 13),
    (4, 'investigator_id', 'investigator_id', 'investigator_id', 1, 14),
    (4, 'status', 'status', 'status', 4, 15);

-- Tenant scoped fields
INSERT INTO form_elements
    (form_id, tenant_id, branch_id, label, field_name, data_column, type_id, order_index)
VALUES
    (4, 1, NULL, 'Days Lost', 'days_lost', 'days_lost', 2, 16),
    (4, 1, NULL, 'Return-to-Work Date', 'rtw_date', 'rtw_date', 3, 17),
    (4, 1, NULL, 'Restricted Duty Notes', 'restricted_duty_notes', 'restricted_duty_notes', 1, 18);

-- Classification options
INSERT INTO element_options (element_id, display_text, value) VALUES
    ((SELECT id FROM form_elements WHERE form_id = 4 AND field_name = 'classification'), 'Injury', 'injury'),
    ((SELECT id FROM form_elements WHERE form_id = 4 AND field_name = 'classification'), 'Property Damage', 'property_damage'),
    ((SELECT id FROM form_elements WHERE form_id = 4 AND field_name = 'classification'), 'Environmental', 'environmental'),
    ((SELECT id FROM form_elements WHERE form_id = 4 AND field_name = 'classification'), 'Near Miss', 'near_miss'),
    ((SELECT id FROM form_elements WHERE form_id = 4 AND field_name = 'classification'), 'First Aid', 'first_aid'),
    ((SELECT id FROM form_elements WHERE form_id = 4 AND field_name = 'classification'), 'Medical Treatment', 'medical_treatment'),
    ((SELECT id FROM form_elements WHERE form_id = 4 AND field_name = 'classification'), 'LTI', 'lti'),
    ((SELECT id FROM form_elements WHERE form_id = 4 AND field_name = 'classification'), 'Fatality', 'fatality');

-- Status options
INSERT INTO element_options (element_id, display_text, value) VALUES
    ((SELECT id FROM form_elements WHERE form_id = 4 AND field_name = 'status'), 'Reported', 'reported'),
    ((SELECT id FROM form_elements WHERE form_id = 4 AND field_name = 'status'), 'Investigating', 'investigating'),
    ((SELECT id FROM form_elements WHERE form_id = 4 AND field_name = 'status'), 'Closed', 'closed');

-- Tenant table view including custom fields
INSERT INTO table_views (form_id, tenant_id, branch_id, name, columns, sort_by, sort_dir)
VALUES (4, 1, NULL, 'Default', '["status","injury_date","classification","location","days_lost","rtw_date","restricted_duty_notes"]', 'injury_date', 'DESC');

-- ============================================================================
-- 1) PROPERTY DAMAGE (form_id = 13)
-- ============================================================================
DELETE FROM form_elements WHERE form_id = 13;

-- (Re-declare the form itself in case it’s missing)
INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES
  (13, 'OHS Incident – Property Damage', 'Report property damage incidents', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

-- Fields
INSERT INTO form_elements (form_id, label,           field_name,           data_column,            type_id, order_index) VALUES
  (13, 'Date of Damage',   'incident_date',       'incident_date',        3,       1),
  (13, 'Time of Damage',   'incident_time',       'incident_time',        1,       2),
  (13, 'Location',         'location',            'location',             1,       3),
  (13, 'Asset Affected',   'asset_affected',      'asset_affected',       1,       4),
  (13, 'Damage Description','damage_description', 'damage_description',   1,       5),
  (13, 'Estimated Cost',   'estimated_cost',      'estimated_cost',       2,       6),
  (13, 'Immediate Action', 'immediate_action',    'immediate_action',     1,       7),
  (13, 'Responsible Person','responsible_person','responsible_person',    1,       8),
  (13, 'Status',           'status',              'status',               4,       9),
  (13, 'Investigator',     'investigator_id',     'investigator_id',      1,       10);

-- Status dropdown
INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=13 AND field_name='status'), 'Reported',      'reported'),
  ((SELECT id FROM form_elements WHERE form_id=13 AND field_name='status'), 'Investigating','investigating'),
  ((SELECT id FROM form_elements WHERE form_id=13 AND field_name='status'), 'Closed',        'closed');



-- ============================================================================
-- 2) ENVIRONMENTAL (form_id = 14)
-- ============================================================================
DELETE FROM form_elements WHERE form_id = 14;

INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES
  (14, 'OHS Incident – Environmental', 'Report environmental incidents (spills, emissions, etc.)', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

INSERT INTO form_elements (form_id, label,               field_name,              data_column,         type_id, order_index) VALUES
  (14, 'Date',                 'incident_date',         'incident_date',         3,       1),
  (14, 'Time',                 'incident_time',         'incident_time',         1,       2),
  (14, 'Location',             'location',              'location',              1,       3),
  (14, 'Type of Incident',     'env_incident_type',     'env_incident_type',     1,       4),
  (14, 'Impact Description',   'impact_description',    'impact_description',    1,       5),
  (14, 'Area Affected',        'area_affected',         'area_affected',         1,       6),
  (14, 'Volume/Quantity',      'volume',                'volume',                2,       7),
  (14, 'Remediation Action',   'remediation_action',    'remediation_action',    1,       8),
  (14, 'Status',               'status',                'status',                4,       9),
  (14, 'Investigator',         'investigator_id',       'investigator_id',       1,       10);

INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=14 AND field_name='status'), 'Reported',      'reported'),
  ((SELECT id FROM form_elements WHERE form_id=14 AND field_name='status'), 'Investigating','investigating'),
  ((SELECT id FROM form_elements WHERE form_id=14 AND field_name='status'), 'Closed',        'closed');



-- ============================================================================
-- 3) NEAR MISS (form_id = 15)
-- ============================================================================
DELETE FROM form_elements WHERE form_id = 15;

INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES
  (15, 'OHS Incident – Near Miss', 'Report near-miss incidents', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

INSERT INTO form_elements (form_id, label,               field_name,              data_column,         type_id, order_index) VALUES
  (15, 'Date',                 'incident_date',         'incident_date',         3,       1),
  (15, 'Time',                 'incident_time',         'incident_time',         1,       2),
  (15, 'Location',             'location',              'location',              1,       3),
  (15, 'Description of Near Miss','description',        'description',           1,       4),
  (15, 'Hazard Identified',    'hazard_identified',     'hazard_identified',     1,       5),
  (15, 'Potential Consequence','potential_consequence', 'potential_consequence', 1,       6),
  (15, 'Immediate Action',     'immediate_action',      'immediate_action',      1,       7),
  (15, 'Status',               'status',                'status',                4,       8),
  (15, 'Investigator',         'investigator_id',       'investigator_id',       1,       9);

INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=15 AND field_name='status'), 'Reported',      'reported'),
  ((SELECT id FROM form_elements WHERE form_id=15 AND field_name='status'), 'Investigating','investigating'),
  ((SELECT id FROM form_elements WHERE form_id=15 AND field_name='status'), 'Closed',        'closed');



-- ============================================================================
-- 4) FIRST AID (form_id = 16)
-- ============================================================================
DELETE FROM form_elements WHERE form_id = 16;

INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES
  (16, 'OHS Incident – First Aid', 'Report incidents requiring first aid', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

INSERT INTO form_elements (form_id, label,               field_name,              data_column,         type_id, order_index) VALUES
  (16, 'Date',                 'incident_date',         'incident_date',         3,       1),
  (16, 'Time',                 'incident_time',         'incident_time',         1,       2),
  (16, 'Location',             'location',              'location',              1,       3),
  (16, 'Person Treated',       'person_treated',        'person_treated',        1,       4),
  (16, 'Injury Description',   'injury_description',    'injury_description',    1,       5),
  (16, 'First Aid Given',      'first_aid_given',       'first_aid_given',       1,       6),
  (16, 'Treated By',           'treated_by',            'treated_by',            1,       7),
  (16, 'Follow-Up Required?',  'follow_up_required',    'follow_up_required',    4,       8),
  (16, 'Status',               'status',                'status',                4,       9),
  (16, 'Investigator',         'investigator_id',       'investigator_id',       1,       10);

-- Yes/No for follow-up
INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=16 AND field_name='follow_up_required'), 'Yes', 'yes'),
  ((SELECT id FROM form_elements WHERE form_id=16 AND field_name='follow_up_required'), 'No',  'no');

-- Status
INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=16 AND field_name='status'), 'Reported',      'reported'),
  ((SELECT id FROM form_elements WHERE form_id=16 AND field_name='status'), 'Investigating','investigating'),
  ((SELECT id FROM form_elements WHERE form_id=16 AND field_name='status'), 'Closed',        'closed');



-- ============================================================================
-- 5) MEDICAL TREATMENT (form_id = 17)
-- ============================================================================
DELETE FROM form_elements WHERE form_id = 17;

INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES
  (17, 'OHS Incident – Medical Treatment', 'Report incidents requiring medical treatment', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

INSERT INTO form_elements (form_id, label,               field_name,              data_column,         type_id, order_index) VALUES
  (17, 'Date',                 'incident_date',         'incident_date',         3,       1),
  (17, 'Time',                 'incident_time',         'incident_time',         1,       2),
  (17, 'Location',             'location',              'location',              1,       3),
  (17, 'Person Treated',       'person_treated',        'person_treated',        1,       4),
  (17, 'Injury Description',   'injury_description',    'injury_description',    1,       5),
  (17, 'Medical Details',      'medical_details',       'medical_details',       1,       6),
  (17, 'Provider',             'medical_provider',      'medical_provider',      1,       7),
  (17, 'Follow-Up Required?',  'follow_up_required',    'follow_up_required',    4,       8),
  (17, 'Status',               'status',                'status',                4,       9),
  (17, 'Investigator',         'investigator_id',       'investigator_id',       1,       10);

-- follow-up yes/no, plus status as above
INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=17 AND field_name='follow_up_required'), 'Yes','yes'),
  ((SELECT id FROM form_elements WHERE form_id=17 AND field_name='follow_up_required'), 'No', 'no'),
  ((SELECT id FROM form_elements WHERE form_id=17 AND field_name='status'),            'Reported','reported'),
  ((SELECT id FROM form_elements WHERE form_id=17 AND field_name='status'),            'Investigating','investigating'),
  ((SELECT id FROM form_elements WHERE form_id=17 AND field_name='status'),            'Closed','closed');



-- ============================================================================
-- 6) LTI (Lost Time Injury) (form_id = 18)
-- ============================================================================
DELETE FROM form_elements WHERE form_id = 18;

INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES
  (18, 'OHS Incident – LTI', 'Report lost-time injuries', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

INSERT INTO form_elements (form_id, label,               field_name,              data_column,         type_id, order_index) VALUES
  (18, 'Date',                 'incident_date',         'incident_date',         3,       1),
  (18, 'Time',                 'incident_time',         'incident_time',         1,       2),
  (18, 'Location',             'location',              'location',              1,       3),
  (18, 'Person Injured',       'person_injured',        'person_injured',        1,       4),
  (18, 'Injury Description',   'injury_description',    'injury_description',    1,       5),
  (18, 'Days Lost',            'days_lost',             'days_lost',             2,       6),
  (18, 'Return-to-Work Date',  'rtw_date',              'rtw_date',              3,       7),
  (18, 'Corrective Action',    'corrective_action',     'corrective_action',     1,       8),
  (18, 'Status',               'status',                'status',                4,       9),
  (18, 'Investigator',         'investigator_id',       'investigator_id',       1,       10);

INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=18 AND field_name='status'), 'Reported','reported'),
  ((SELECT id FROM form_elements WHERE form_id=18 AND field_name='status'), 'Investigating','investigating'),
  ((SELECT id FROM form_elements WHERE form_id=18 AND field_name='status'), 'Closed','closed');



-- ============================================================================
-- 7) FATALITY (form_id = 19)
-- ============================================================================
DELETE FROM form_elements WHERE form_id = 19;

INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES
  (19, 'OHS Incident – Fatality', 'Report fatalities', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

INSERT INTO form_elements (form_id, label,               field_name,              data_column,         type_id, order_index) VALUES
  (19, 'Date',                 'incident_date',         'incident_date',         3,       1),
  (19, 'Time',                 'incident_time',         'incident_time',         1,       2),
  (19, 'Location',             'location',              'location',              1,       3),
  (19, 'Deceased Name',        'deceased_name',         'deceased_name',         1,       4),
  (19, 'Cause of Death',       'cause_of_death',        'cause_of_death',        1,       5),
  (19, 'Reported to Authorities','reported_authorities','reported_authorities', 3,       6),
  (19, 'Coroner Details',      'coroner_details',       'coroner_details',       1,       7),
  (19, 'Corrective Action',    'corrective_action',     'corrective_action',     1,       8),
  (19, 'Status',               'status',                'status',                4,       9),
  (19, 'Investigator',         'investigator_id',       'investigator_id',       1,       10);

INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=19 AND field_name='status'), 'Reported','reported'),
  ((SELECT id FROM form_elements WHERE form_id=19 AND field_name='status'), 'Investigating','investigating'),
  ((SELECT id FROM form_elements WHERE form_id=19 AND field_name='status'), 'Closed','closed');


DELETE FROM form_elements WHERE form_id = 20;

-- Base form record (if not already present)
INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES (20, 'OHS Incident', 'Default incident report form', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

-- Form fields
INSERT INTO form_elements (form_id, label, field_name, data_column, type_id, order_index) VALUES
    (20, 'injury_date', 'injury_date', 'injury_date', 3, 1),
    (20, 'injury_time', 'injury_time', 'injury_time', 1, 2),
    (20, 'classification', 'classification', 'classification', 4, 3),
    (20, 'location', 'location', 'location', 1, 4),
    (20, 'nature', 'nature', 'nature', 1, 5),
    (20, 'workplace_part', 'workplace_part', 'workplace_part', 1, 6),
    (20, 'activity', 'activity', 'activity', 1, 7),
    (20, 'unexpected', 'unexpected', 'unexpected', 1, 8),
    (20, 'how_sustained', 'how_sustained', 'how_sustained', 1, 9),
    (20, 'completed_by', 'completed_by', 'completed_by', 1, 10),
    (20, 'position', 'position', 'position', 1, 11),
    (20, 'outcome', 'outcome', 'outcome', 1, 12),
    (20, 'preventative_action', 'preventative_action', 'preventative_action', 1, 13),
    (20, 'investigator_id', 'investigator_id', 'investigator_id', 1, 14),
    (20, 'status', 'status', 'status', 4, 15);

-- Tenant scoped fields
INSERT INTO form_elements
    (form_id, tenant_id, branch_id, label, field_name, data_column, type_id, order_index)
VALUES
    (20, 1, NULL, 'Days Lost', 'days_lost', 'days_lost', 2, 16),
    (20, 1, NULL, 'Return-to-Work Date', 'rtw_date', 'rtw_date', 3, 17),
    (20, 1, NULL, 'Restricted Duty Notes', 'restricted_duty_notes', 'restricted_duty_notes', 1, 18);

-- Classification options
INSERT INTO element_options (element_id, display_text, value) VALUES
    ((SELECT id FROM form_elements WHERE form_id = 20 AND field_name = 'classification'), 'Injury', 'injury'),
    ((SELECT id FROM form_elements WHERE form_id = 20 AND field_name = 'classification'), 'Property Damage', 'property_damage'),
    ((SELECT id FROM form_elements WHERE form_id = 20 AND field_name = 'classification'), 'Environmental', 'environmental'),
    ((SELECT id FROM form_elements WHERE form_id = 20 AND field_name = 'classification'), 'Near Miss', 'near_miss'),
    ((SELECT id FROM form_elements WHERE form_id = 20 AND field_name = 'classification'), 'First Aid', 'first_aid'),
    ((SELECT id FROM form_elements WHERE form_id = 20 AND field_name = 'classification'), 'Medical Treatment', 'medical_treatment'),
    ((SELECT id FROM form_elements WHERE form_id = 20 AND field_name = 'classification'), 'LTI', 'lti'),
    ((SELECT id FROM form_elements WHERE form_id = 20 AND field_name = 'classification'), 'Fatality', 'fatality');

-- Status options
INSERT INTO element_options (element_id, display_text, value) VALUES
    ((SELECT id FROM form_elements WHERE form_id = 20 AND field_name = 'status'), 'Reported', 'reported'),
    ((SELECT id FROM form_elements WHERE form_id = 20 AND field_name = 'status'), 'Investigating', 'investigating'),
    ((SELECT id FROM form_elements WHERE form_id = 20 AND field_name = 'status'), 'Closed', 'closed');

-- Tenant table view including custom fields
INSERT INTO table_views (form_id, tenant_id, branch_id, name, columns, sort_by, sort_dir)
VALUES (20, 1, NULL, 'Default', '["status","injury_date","classification","location","days_lost","rtw_date","restricted_duty_notes"]', 'injury_date', 'DESC');

-- ============================================================================
-- 1) PROPERTY DAMAGE (form_id = 21)
-- ============================================================================
DELETE FROM form_elements WHERE form_id = 21;

-- (Re-declare the form itself in case it’s missing)
INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES
  (21, 'OHS Incident – Property Damage', 'Report property damage incidents', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

-- Fields
INSERT INTO form_elements (form_id, label,           field_name,           data_column,            type_id, order_index) VALUES
  (21, 'Date of Damage',   'incident_date',       'incident_date',        3,       1),
  (21, 'Time of Damage',   'incident_time',       'incident_time',        1,       2),
  (21, 'Location',         'location',            'location',             1,       3),
  (21, 'Asset Affected',   'asset_affected',      'asset_affected',       1,       4),
  (21, 'Damage Description','damage_description', 'damage_description',   1,       5),
  (21, 'Estimated Cost',   'estimated_cost',      'estimated_cost',       2,       6),
  (21, 'Immediate Action', 'immediate_action',    'immediate_action',     1,       7),
  (21, 'Responsible Person','responsible_person','responsible_person',    1,       8),
  (21, 'Status',           'status',              'status',               4,       9),
  (21, 'Investigator',     'investigator_id',     'investigator_id',      1,       10);

-- Status dropdown
INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=13 AND field_name='status'), 'Reported',      'reported'),
  ((SELECT id FROM form_elements WHERE form_id=13 AND field_name='status'), 'Investigating','investigating'),
  ((SELECT id FROM form_elements WHERE form_id=13 AND field_name='status'), 'Closed',        'closed');



-- ============================================================================
-- 2) ENVIRONMENTAL (form_id = 22)
-- ============================================================================
DELETE FROM form_elements WHERE form_id = 22;

INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES
  (22, 'OHS Incident – Environmental', 'Report environmental incidents (spills, emissions, etc.)', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

INSERT INTO form_elements (form_id, label,               field_name,              data_column,         type_id, order_index) VALUES
  (22, 'Date',                 'incident_date',         'incident_date',         3,       1),
  (22, 'Time',                 'incident_time',         'incident_time',         1,       2),
  (22, 'Location',             'location',              'location',              1,       3),
  (22, 'Type of Incident',     'env_incident_type',     'env_incident_type',     1,       4),
  (22, 'Impact Description',   'impact_description',    'impact_description',    1,       5),
  (22, 'Area Affected',        'area_affected',         'area_affected',         1,       6),
  (22, 'Volume/Quantity',      'volume',                'volume',                2,       7),
  (22, 'Remediation Action',   'remediation_action',    'remediation_action',    1,       8),
  (22, 'Status',               'status',                'status',                4,       9),
  (22, 'Investigator',         'investigator_id',       'investigator_id',       1,       10);

INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=14 AND field_name='status'), 'Reported',      'reported'),
  ((SELECT id FROM form_elements WHERE form_id=14 AND field_name='status'), 'Investigating','investigating'),
  ((SELECT id FROM form_elements WHERE form_id=14 AND field_name='status'), 'Closed',        'closed');



-- ============================================================================
-- 3) NEAR MISS (form_id = 23)
-- ============================================================================
DELETE FROM form_elements WHERE form_id = 23;

INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES
  (23, 'OHS Incident – Near Miss', 'Report near-miss incidents', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

INSERT INTO form_elements (form_id, label,               field_name,              data_column,         type_id, order_index) VALUES
  (23, 'Date',                 'incident_date',         'incident_date',         3,       1),
  (23, 'Time',                 'incident_time',         'incident_time',         1,       2),
  (23, 'Location',             'location',              'location',              1,       3),
  (23, 'Description of Near Miss','description',        'description',           1,       4),
  (23, 'Hazard Identified',    'hazard_identified',     'hazard_identified',     1,       5),
  (23, 'Potential Consequence','potential_consequence', 'potential_consequence', 1,       6),
  (23, 'Immediate Action',     'immediate_action',      'immediate_action',      1,       7),
  (23, 'Status',               'status',                'status',                4,       8),
  (23, 'Investigator',         'investigator_id',       'investigator_id',       1,       9);

INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=15 AND field_name='status'), 'Reported',      'reported'),
  ((SELECT id FROM form_elements WHERE form_id=15 AND field_name='status'), 'Investigating','investigating'),
  ((SELECT id FROM form_elements WHERE form_id=15 AND field_name='status'), 'Closed',        'closed');



-- ============================================================================
-- 4) FIRST AID (form_id = 24)
-- ============================================================================
DELETE FROM form_elements WHERE form_id = 24;

INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES
  (24, 'OHS Incident – First Aid', 'Report incidents requiring first aid', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

INSERT INTO form_elements (form_id, label,               field_name,              data_column,         type_id, order_index) VALUES
  (24, 'Date',                 'incident_date',         'incident_date',         3,       1),
  (24, 'Time',                 'incident_time',         'incident_time',         1,       2),
  (24, 'Location',             'location',              'location',              1,       3),
  (24, 'Person Treated',       'person_treated',        'person_treated',        1,       4),
  (24, 'Injury Description',   'injury_description',    'injury_description',    1,       5),
  (24, 'First Aid Given',      'first_aid_given',       'first_aid_given',       1,       6),
  (24, 'Treated By',           'treated_by',            'treated_by',            1,       7),
  (24, 'Follow-Up Required?',  'follow_up_required',    'follow_up_required',    4,       8),
  (24, 'Status',               'status',                'status',                4,       9),
  (24, 'Investigator',         'investigator_id',       'investigator_id',       1,       10);

-- Yes/No for follow-up
INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=16 AND field_name='follow_up_required'), 'Yes', 'yes'),
  ((SELECT id FROM form_elements WHERE form_id=16 AND field_name='follow_up_required'), 'No',  'no');

-- Status
INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=16 AND field_name='status'), 'Reported',      'reported'),
  ((SELECT id FROM form_elements WHERE form_id=16 AND field_name='status'), 'Investigating','investigating'),
  ((SELECT id FROM form_elements WHERE form_id=16 AND field_name='status'), 'Closed',        'closed');



-- ============================================================================
-- 5) MEDICAL TREATMENT (form_id = 25)
-- ============================================================================
DELETE FROM form_elements WHERE form_id = 25;

INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES
  (25, 'OHS Incident – Medical Treatment', 'Report incidents requiring medical treatment', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

INSERT INTO form_elements (form_id, label,               field_name,              data_column,         type_id, order_index) VALUES
  (25, 'Date',                 'incident_date',         'incident_date',         3,       1),
  (25, 'Time',                 'incident_time',         'incident_time',         1,       2),
  (25, 'Location',             'location',              'location',              1,       3),
  (25, 'Person Treated',       'person_treated',        'person_treated',        1,       4),
  (25, 'Injury Description',   'injury_description',    'injury_description',    1,       5),
  (25, 'Medical Details',      'medical_details',       'medical_details',       1,       6),
  (25, 'Provider',             'medical_provider',      'medical_provider',      1,       7),
  (25, 'Follow-Up Required?',  'follow_up_required',    'follow_up_required',    4,       8),
  (25, 'Status',               'status',                'status',                4,       9),
  (25, 'Investigator',         'investigator_id',       'investigator_id',       1,       10);

-- follow-up yes/no, plus status as above
INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=17 AND field_name='follow_up_required'), 'Yes','yes'),
  ((SELECT id FROM form_elements WHERE form_id=17 AND field_name='follow_up_required'), 'No', 'no'),
  ((SELECT id FROM form_elements WHERE form_id=17 AND field_name='status'),            'Reported','reported'),
  ((SELECT id FROM form_elements WHERE form_id=17 AND field_name='status'),            'Investigating','investigating'),
  ((SELECT id FROM form_elements WHERE form_id=17 AND field_name='status'),            'Closed','closed');



-- ============================================================================
-- 6) LTI (Lost Time Injury) (form_id = 26)
-- ============================================================================
DELETE FROM form_elements WHERE form_id = 26;

INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES
  (26, 'OHS Incident – LTI', 'Report lost-time injuries', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

INSERT INTO form_elements (form_id, label,               field_name,              data_column,         type_id, order_index) VALUES
  (26, 'Date',                 'incident_date',         'incident_date',         3,       1),
  (26, 'Time',                 'incident_time',         'incident_time',         1,       2),
  (26, 'Location',             'location',              'location',              1,       3),
  (26, 'Person Injured',       'person_injured',        'person_injured',        1,       4),
  (26, 'Injury Description',   'injury_description',    'injury_description',    1,       5),
  (26, 'Days Lost',            'days_lost',             'days_lost',             2,       6),
  (26, 'Return-to-Work Date',  'rtw_date',              'rtw_date',              3,       7),
  (26, 'Corrective Action',    'corrective_action',     'corrective_action',     1,       8),
  (26, 'Status',               'status',                'status',                4,       9),
  (26, 'Investigator',         'investigator_id',       'investigator_id',       1,       10);

INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=18 AND field_name='status'), 'Reported','reported'),
  ((SELECT id FROM form_elements WHERE form_id=18 AND field_name='status'), 'Investigating','investigating'),
  ((SELECT id FROM form_elements WHERE form_id=18 AND field_name='status'), 'Closed','closed');



-- ============================================================================
-- 7) FATALITY (form_id = 27)
-- ============================================================================
DELETE FROM form_elements WHERE form_id = 27;

INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES
  (27, 'OHS Incident – Fatality', 'Report fatalities', 'ohs_incidents', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

INSERT INTO form_elements (form_id, label,               field_name,              data_column,         type_id, order_index) VALUES
  (27, 'Date',                 'incident_date',         'incident_date',         3,       1),
  (27, 'Time',                 'incident_time',         'incident_time',         1,       2),
  (27, 'Location',             'location',              'location',              1,       3),
  (27, 'Deceased Name',        'deceased_name',         'deceased_name',         1,       4),
  (27, 'Cause of Death',       'cause_of_death',        'cause_of_death',        1,       5),
  (27, 'Reported to Authorities','reported_authorities','reported_authorities', 3,       6),
  (27, 'Coroner Details',      'coroner_details',       'coroner_details',       1,       7),
  (27, 'Corrective Action',    'corrective_action',     'corrective_action',     1,       8),
  (27, 'Status',               'status',                'status',                4,       9),
  (27, 'Investigator',         'investigator_id',       'investigator_id',       1,       10);

INSERT INTO element_options (element_id, display_text, value)
VALUES
  ((SELECT id FROM form_elements WHERE form_id=19 AND field_name='status'), 'Reported','reported'),
  ((SELECT id FROM form_elements WHERE form_id=19 AND field_name='status'), 'Investigating','investigating'),
  ((SELECT id FROM form_elements WHERE form_id=19 AND field_name='status'), 'Closed','closed');

-- ============================================================================
-- OHS Inspection form (form_id = 28)
-- ============================================================================

-- 1) Remove any existing elements for form 28
DELETE FROM form_elements WHERE form_id = 28;

-- 2) Base form record
INSERT INTO forms (id, name, description, mapped_table, tenant_id, branch_id)
VALUES
  (28, 'OHS Inspection', 'Workplace inspection checklist and report', 'ohs_inspections', NULL, NULL)
ON CONFLICT (id) DO NOTHING;

-- 3) Form fields
INSERT INTO form_elements (form_id, label,                  field_name,            data_column,             type_id, order_index) VALUES
  (28, 'inspection_date',         'inspection_date',       'inspection_date',        3,       1),
  (28, 'inspection_time',         'inspection_time',       'inspection_time',        1,       2),
  (28, 'inspector_name',          'inspector_name',        'inspector_name',         1,       3),
  (28, 'area_or_department',      'area_or_department',    'area_or_department',     1,       4),
  (28, 'inspection_type',         'inspection_type',       'inspection_type',        4,       5),
  (28, 'hazards_identified',      'hazards_identified',    'hazards_identified',     1,       6),
  (28, 'observations',            'observations',          'observations',           1,       7),
  (28, 'corrective_actions',      'corrective_actions',    'corrective_actions',     1,       8),
  (28, 'follow_up_required',      'follow_up_required',    'follow_up_required',     4,       9),
  (28, 'next_inspection_date',    'next_inspection_date',  'next_inspection_date',   3,       10),
  (28, 'status',                  'status',                'status',                 4,       11);

-- 4) Options for inspection_type
INSERT INTO element_options (element_id, display_text, value) VALUES
  ((SELECT id FROM form_elements WHERE form_id=28 AND field_name='inspection_type'), 'Routine',            'routine'),
  ((SELECT id FROM form_elements WHERE form_id=28 AND field_name='inspection_type'), 'Pre-Operation',      'pre_operation'),
  ((SELECT id FROM form_elements WHERE form_id=28 AND field_name='inspection_type'), 'Safety Audit',       'safety_audit'),
  ((SELECT id FROM form_elements WHERE form_id=28 AND field_name='inspection_type'), 'Incident Follow-up','incident_followup');

-- 5) Yes/No for follow_up_required
INSERT INTO element_options (element_id, display_text, value) VALUES
  ((SELECT id FROM form_elements WHERE form_id=28 AND field_name='follow_up_required'), 'Yes', 'yes'),
  ((SELECT id FROM form_elements WHERE form_id=28 AND field_name='follow_up_required'), 'No',  'no');

-- 6) Options for status
INSERT INTO element_options (element_id, display_text, value) VALUES
  ((SELECT id FROM form_elements WHERE form_id=28 AND field_name='status'), 'Scheduled',  'scheduled'),
  ((SELECT id FROM form_elements WHERE form_id=28 AND field_name='status'), 'Completed',  'completed'),
  ((SELECT id FROM form_elements WHERE form_id=28 AND field_name='status'), 'Closed',     'closed');

-- Source: demoSql/trip_logs_demo.sql
-- Sample trip logs referencing demo vehicles
INSERT INTO vehicle_trips (
  id, vehicle_id, driver_id, trip_date, start_time, end_time,
  start_location, start_latitude, start_longitude,
  end_location, end_latitude, end_longitude,
  distance_km, status,
  start_mileage, end_mileage, tenant_id, branch_id
) VALUES
  (1, 1, 2, '2025-06-01', '2025-06-01 08:00:00', '2025-06-01 10:00:00',
   'Suva HQ', -18.1398, 178.4266,
   'Nadi Office', -17.7533, 177.4435,
   200, 'completed', 12000, 12200, 1, 1),
  (2, 2, 3, '2025-06-02', '2025-06-02 07:45:00', '2025-06-02 09:30:00',
   'Nadi Office', -17.7533, 177.4435,
   'Lautoka', -17.6167, 177.4667,
   150, 'in_progress', 8000, 8150, 1, 1),
  (3, 3, 4, '2025-06-03', '2025-06-03 09:00:00', NULL,
   'Lautoka', -17.6167, 177.4667,
   'Suva HQ', -18.1398, 178.4266,
   0, 'scheduled', 15000, NULL, 1, 1),
  (4, 4, 5, '2025-06-04', '2025-06-04 13:00:00', '2025-06-04 15:30:00',
   'Suva HQ', -18.1398, 178.4266,
   'Labasa', -16.4302, 179.3822,
   220, 'cancelled', 5000, 5000, 1, 1),
  (5, 5, 1, '2025-06-05', '2025-06-05 07:30:00', '2025-06-05 09:00:00',
   'Labasa', -16.4302, 179.3822,
   'Savusavu', -16.7794, 179.3314,
   90, 'completed', 22000, 22090, 1, 1);

-- Source: demoSql/trip_points_demo.sql
-- Sample GPS points for demo trips
INSERT INTO vehicle_trip_points (
  id, trip_id, latitude, longitude, recorded_at, tenant_id, branch_id
) VALUES
  (1, 1, -18.1398, 178.4266, '2025-06-01 08:00:00', 1, 1),
  (2, 1, -18.1000, 178.3000, '2025-06-01 08:02:00', 1, 1),
  (3, 1, -18.0500, 178.1000, '2025-06-01 08:04:00', 1, 1),
  (4, 2, -17.7533, 177.4435, '2025-06-02 07:45:00', 1, 1),
  (5, 2, -17.7000, 177.5000, '2025-06-02 07:47:00', 1, 1),
  (6, 2, -17.6500, 177.5200, '2025-06-02 07:49:00', 1, 1),
  (7, 3, -17.6167, 177.4667, '2025-06-03 09:00:00', 1, 1),
  (8, 3, -17.7000, 177.7000, '2025-06-03 09:02:00', 1, 1),
  (9, 3, -17.9000, 177.9000, '2025-06-03 09:04:00', 1, 1),
  (10, 4, -18.1398, 178.4266, '2025-06-04 13:00:00', 1, 1),
  (11, 4, -17.9000, 178.7000, '2025-06-04 13:02:00', 1, 1),
  (12, 4, -17.7000, 179.0000, '2025-06-04 13:04:00', 1, 1),
  (13, 5, -16.4302, 179.3822, '2025-06-05 07:30:00', 1, 1),
  (14, 5, -16.5500, 179.3500, '2025-06-05 07:32:00', 1, 1),
  (15, 5, -16.6800, 179.3400, '2025-06-05 07:34:00', 1, 1);
