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

  tasks:
    - name: Initialize per-host report object (always)
      ansible.builtin.set_fact:
        rm10252_report:
          hostname: "{{ inventory_hostname }}"
          active_domains: []

    - name: Get Info
      plesk_info:
      register: plsk

    - name: Query domains using EOL Plesk PHP handlers
      ansible.builtin.command:
        argv:
          - plesk
          - db
          - -Ne
          - "select d.name, h.php_handler_id 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: Update per-host report object with query results
      ansible.builtin.set_fact:
        rm10252_report:
          hostname: "{{ inventory_hostname }}"
          active_domains: "{{ eol_domains.stdout_lines | default([]) }}"
      when: eol_domains is defined

    - name: Write report to JSON file
      ansible.builtin.copy:
        dest: "RM10252/eol_domains_report.json"
        mode: "0644"
        content: >-
          {{
            (ansible_play_hosts_all
              | map('extract', hostvars)
              | map(attribute='rm10252_report', default={})
              | reject('equalto', {})
              | list)
            | to_nice_json
          }}
      delegate_to: localhost
      run_once: true