Localhost via UNIX socket
SELECT users.record_list_name as utente,
       vehicles.record_list_name as veicolo,
       doc.record_linked_table as tipologia,
       doc.record_linked_id,
       doc.record_typology,
       doc.record_sub_typology as sub_tipologia,
       doc.record_list_name as nome,
       doc.document_name as documento,
       doc.document_text as info,
       doc.issued_by as emesso_da,
       doc.start_at as inizio_validita,
       doc.end_at as fine_validita,
#        doc.alert_from_days  ,
#        doc.alert_at,
#        doc.file_name1 as file,
#        doc.file_description1,
#        doc.file_name2,
#        doc.file_description2,
#        doc.file_name3,
#        doc.file_description3,
#        doc.file_name4,
#        doc.file_description4,
#        doc.burocrazia,
       doc.record_extras as extra
FROM documents as doc
   left join users on doc.record_linked_id=users.user_id and doc.record_linked_table = 'employees'
   left join vehicles on doc.record_linked_id=vehicles.vehicle_id and doc.record_linked_table = 'vehicles'
WHERE doc.alert_at <> 'NULL'
  AND doc.alert_at
    BETWEEN CURDATE() and DATE_ADD(NOW(), INTERVAL 15 DAY )
 or doc.end_at BETWEEN CURDATE() and DATE_ADD(NOW(), INTERVAL 15 DAY )
or doc.end_at BETWEEN CURDATE() and doc.alert_at
ORDER BY doc.record_typology, doc.end_at,doc.alert_at ASC<br />
<b>Notice</b>:  Array to string conversion in <b>/home_hdd_raid/rinaldiimpianti/docs.rinaldi-impianti.it/mailsend/phpbased/filecreator.php</b> on line <b>55</b><br />
---------- PROCEDURA Array \t Estratte  voci<br><br><br>SELECT fab.first_aid_box_place as posto,
       fab.first_aid_box_name as nome_box,
       fabd.first_aid_box_detail_name as dettagli,
       fabd.first_aid_box_detail_quantity as quantita,
       fabd.edate_at as scadenza
from first_aid_box_details as fabd
         left join first_aid_boxes as fab on fabd.first_aid_box_id = fab.first_aid_box_id
WHERE fabd.edate_at <> 'NULL'
  AND fabd.edate_at
    BETWEEN NOW() and DATE_ADD(NOW(), INTERVAL 60 DAY)

order by fabd.edate_at, fab.first_aid_box_place, fab.first_aid_box_name, fabd.first_aid_box_detail_name,
         fabd.first_aid_box_detail_quantity asc<br />
<b>Notice</b>:  Array to string conversion in <b>/home_hdd_raid/rinaldiimpianti/docs.rinaldi-impianti.it/mailsend/phpbased/filecreator.php</b> on line <b>55</b><br />
---------- PROCEDURA Array \t Estratte  voci<br><br><br>SELECT work.work_machine_brand,
       work.work_machine_model,
       work.work_machine_sn,
#        maint.work_machine_maintenance_id,
       maint.work_machine_id,
#        maint.record_typology,
#        maint.record_sub_typology,
#        maint.record_relations,
#        maint.record_status,
#        maint.record_locked,
#        maint.record_uuid,
#        maint.record_code,
#        maint.record_list_name,

       maint.work_machine_maintenance_name as operazione,
       maint.work_machine_maintenance_place as posizione,
#        maint.work_machine_maintenance_amount,
       maint.work_machine_maintenance_text as info,
#        maint.file_name1,
#        maint.file_description1,
#        maint.file_name2,
#        maint.file_description2,
#        maint.file_name3,
#        maint.file_description3,
#        maint.file_name4,
#        maint.file_description4,
#        maint.record_control_code,
#        maint.record_control_fields,
       DATE(maint.work_machine_maintenance_date) as data_manutenzione,
       DATE(maint.end_at) as scadenza
#        maint.created_by,
#        maint.updated_by,
#        maint.deleted_by,
#        maint.created_at,
#        maint.updated_at

FROM work_machine_maintenances as maint
         left join work_machines as work on maint.work_machine_id = work.work_machine_id
WHERE maint.end_at <> 'NULL'
  AND maint.end_at
    BETWEEN NOW() and DATE_ADD(NOW(), INTERVAL 5 MONTH)
ORDER BY work_machine_id, work_machine_brand asc<br />
<b>Notice</b>:  Array to string conversion in <b>/home_hdd_raid/rinaldiimpianti/docs.rinaldi-impianti.it/mailsend/phpbased/filecreator.php</b> on line <b>55</b><br />
---------- PROCEDURA Array \t Estratte  voci<br><br><br>SELECT work.vehicle_brand,
       work.vehicle_model,
       work.vehicle_plate,
#        maint.vehicle_maintenance_id,
       maint.vehicle_id,
#        maint.record_typology,
#        maint.record_sub_typology,
#        maint.record_relations,
#        maint.record_status,
#        maint.record_locked,
#        maint.record_uuid,
#        maint.record_code,
#        maint.record_list_name,

       maint.vehicle_maintenance_name  as operazione,
       maint.vehicle_maintenance_place as posizione,
#        maint.vehicle_maintenance_amount,
       maint.vehicle_maintenance_text  as info,
#        maint.file_name1,
#        maint.file_description1,
#        maint.file_name2,
#        maint.file_description2,
#        maint.file_name3,
#        maint.file_description3,
#        maint.file_name4,
#        maint.file_description4,
#        maint.record_control_code,
#        maint.record_control_fields,
       maint.vehicle_maintenance_date  as data_manutenzione,
       maint.vehicle_maintenance_name  as attivita,
       maint.vehicle_maintenance_place as luogo
       #        maint.created_by,
#        maint.updated_by,
#        maint.deleted_by,
#        maint.created_at,
#        maint.updated_at

FROM vehicle_maintenances as maint
         left join vehicles as work on maint.vehicle_id = work.vehicle_id
ORDER BY vehicle_plate,vehicle_brand asc

<br><br>Array
(
    [file] => getvehicles.sql
    [name] => vehicle
)
<br><br>mysqli_result Object
(
    [current_field] => 0
    [field_count] => 10
    [lengths] => 
    [num_rows] => 5
    [type] => 0
)
<br><br><br />
<b>Notice</b>:  Array to string conversion in <b>/home_hdd_raid/rinaldiimpianti/docs.rinaldi-impianti.it/mailsend/phpbased/filecreator.php</b> on line <b>55</b><br />
---------- PROCEDURA Array \t Estratte  vocimysqli_result Object
(
    [current_field] => 0
    [field_count] => 10
    [lengths] => 
    [num_rows] => 5
    [type] => 0
)
<br><br><br>Array
(
    [vehicle] => Array
        (
            [0] => Array
                (
                    [vehicle_brand] => Iveco 35/S
                    [vehicle_model] => Daily
                    [vehicle_plate] => CN866DB
                    [vehicle_id] => 11
                    [operazione] => REVISIONE
                    [posizione] => Andrea Ivaldi Centro Collaudi
                    [info] => 
                    [data_manutenzione] => 2020-05-16
                    [attivita] => REVISIONE
                    [luogo] => Andrea Ivaldi Centro Collaudi
                )

            [1] => Array
                (
                    [vehicle_brand] => Fiat
                    [vehicle_model] => Doblò
                    [vehicle_plate] => DG757TY
                    [vehicle_id] => 5
                    [operazione] => Sostituzione parabrezza con assicurazione
                    [posizione] => GlassDrive Acqui Terme
                    [info] => 
                    [data_manutenzione] => 2020-06-06
                    [attivita] => Sostituzione parabrezza con assicurazione
                    [luogo] => GlassDrive Acqui Terme
                )

            [2] => Array
                (
                    [vehicle_brand] => Citroen
                    [vehicle_model] => Jumpy
                    [vehicle_plate] => DM714TS
                    [vehicle_id] => 7
                    [operazione] => REVISIONE
                    [posizione] => Andrea Ivaldi Centro Collaudi
                    [info] => 
                    [data_manutenzione] => 2020-05-16
                    [attivita] => REVISIONE
                    [luogo] => Andrea Ivaldi Centro Collaudi
                )

            [3] => Array
                (
                    [vehicle_brand] => Renault
                    [vehicle_model] => Master
                    [vehicle_plate] => EN011SJ
                    [vehicle_id] => 14
                    [operazione] => REVISIONE
                    [posizione] => Ivaldi Andrea
                    [info] => 
                    [data_manutenzione] => 2020-10-31
                    [attivita] => REVISIONE
                    [luogo] => Ivaldi Andrea
                )

            [4] => Array
                (
                    [vehicle_brand] => Citroen
                    [vehicle_model] => Jumper
                    [vehicle_plate] => FK501YJ
                    [vehicle_id] => 15
                    [operazione] => Sostituzione parabrezza con assicurazione
                    [posizione] => GlassDrive Acqui Terme
                    [info] => Pagata l'IVA
                    [data_manutenzione] => 2020-05-12
                    [attivita] => Sostituzione parabrezza con assicurazione
                    [luogo] => GlassDrive Acqui Terme
                )

        )

)
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Promemoria Scadenze</title>
    <style>
        .vehicles {
            background: lightgrey;
        }

        .employees {
            background: burlywood;
        }

        .none {
            background: lightsteelblue;
        }
    </style>
</head>
<body>
<h2>Elenco documenti con allerta nei prossimi 7gg:</h2>
<h3>L'elenco viene ricalcolato giornamente</h3>

<h2>Elenco materiale presente nei KIT medici in scadenza nei prossimi 60gg:</h2>

<h2>Scandeze manutenzioni macchinari speciali entro i prossimi 5 Mesi:</h2>

<hr>
Email generata il 
</body>
</html>