---
- name: RM10252 - PHP EOL Checker
  hosts: all
  gather_facts: false

  tasks:
    - name: Get Info
      plesk_info:
      register: plsk

    - name: Query domains using EOL Plesk PHP handlers
      ansible.builtin.command:
        cmd: >-
          plesk db -Ne
          select d.name
          from domains d
          join hosting h on h.dom_id=d.id
          where h.php = 'true'
          AND h.php_handler_id REGEXP '^plesk-php(81|80|7|5)';

      register: eol_domains
      when: (plsk.plesk_found and plsk.imunify_found) or (plsk.plesk_found and plsk.cloudlinux_found)
      changed_when: false
      failed_when: false

    - name: Build per-host report object
      ansible.builtin.set_fact:
        rm10252_report:
          hostname: "{{ inventory_hostname }}"
          active_domains: "{{ eol_domains.stdout_lines | default([]) }}"

    - name: Write report to JSON file
      ansible.builtin.copy:
        dest: "RM10252/eol_domains_report.json"
        mode: "0644"
        content: >-
          {{
            (groups['all']
              | map('extract', hostvars, 'rm10252_report')
              | list)
            | to_nice_json
          }}
        delegate_to: localhost
        run_once: true