name: Months End

on:
  schedule:
    - cron: '0 7 23-31 * *'  # Every day from the 23rd to end of month at 07:00 UTC
  workflow_dispatch:

jobs:
  surveyed-needs-sign-off:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4

      - name: Set up Python
        uses: actions/setup-python@v5
        with:
          python-version: '3.12'

      - name: Install dependencies
        run: |
          pip install poetry
          poetry install --no-root

      - name: Run scripts
        env:
          PYTHONPATH: ${{ github.workspace }}
        run: |
          pwd
          ls -la
          poetry run python etl/month_end_automation_wave_2_layout.py # Done
          poetry run python etl/month_end_automation_wave_2_no_3.py # Done
          poetry run python etl/month_end_automation_wave_2_no_4.py # Done
          poetry run python etl/month_end_automation_wave_2_no_6.py # Check with Matt if this can be deleted
          poetry run python etl/month_end_automation_wave_2_no_7.py # Done
          poetry run python etl/month_end_automation_wave_2_no_8.py # Done
          poetry run python etl/month_end_automation_wave_2_no_11.py # Done
          poetry run python etl/month_end_automation_wave_2_no_15.py # Done
          poetry run python etl/month_end_automation_wave_accent_housing.py # Done
          poetry run python etl/month_end_automation_wave_3_layout.py # Done