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

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

    - name: Execute PHP EOL checker command
      when: plsk.plesk_found
      ansible.builtin.shell: |
        set -o pipefail
        plesk db -Ne "select d.name,h.php_handler_id
                      from domains d
                      join hosting h on h.dom_id=d.id
                      join sys_users s on s.id=h.sys_user_id" \
        | grep -E 'plesk-php8\.1|plesk-php8\.0|plesk-php7\.|plesk-php5\.'
      args:
        executable: /bin/bash
      changed_when: false
      register: php_eol

    - name: Show servers that are still using PHP EOL
      ansible.builtin.debug:
        msg: "{{ php_eol.stdout_lines | default([]) }}"