---
- 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 "plesk-php81\|plesk-php80\|plesk-php7\|plesk-php5"
      args:
        executable: /bin/bash
      register: php_eol
      changed_when: php_eol.rc == 0

    - name: Show servers that are still using PHP EOL
      when: php_eol.rc == 0
      ansible.builtin.lineinfile:
        create: true
        mode: '0644'
        path: RM10252/hostnames
        line: "{{ inventory_hostname }}"
      delegate_to: localhost