<?php

$select = "SELECT num_serie_principal FROM sav.equipement GROUP BY num_serie_principal HAVING COUNT(num_serie_principal) > 1";
$update = "UPDATE sav.equipement SET actif=false WHERE num_serie_principal IN (".$select.");";
$connPostgre->query($update);

$result = $connPostgre->query($select)->fetchAll();

foreach ($result as $value){
    $idEquipement = '';
    $selectContrat ="SELECT e.id FROM sav.equipement e, sav.contrat c WHERE num_serie_principal = '".$value['num_serie_principal']."' AND e.id = c.idequipement AND c.date_fin_contrat >= NOW() ORDER BY c.date_fin_contrat DESC LIMIT 1;";
    if(!is_bool($connPostgre->query($selectContrat)) && $connPostgre->query($selectContrat)->fetch() != false) {
        $idEquipement = $connPostgre->query($selectContrat)->fetch()['id'];
    }else{
        $selectIntervention = "SELECT e.id FROM sav.equipement e, sav.planning p WHERE num_serie_principal = '".$value['num_serie_principal']."' AND e.id = p.idequipement ORDER BY p.date DESC LIMIT 1;";
        if(!is_bool($connPostgre->query($selectIntervention)) && $connPostgre->query($selectIntervention)->fetch() != false) {
            $idEquipement = $connPostgre->query($selectIntervention)->fetch()['id'];
        }
    }
    if($idEquipement != '') {
        $update = "UPDATE sav.equipement SET actif=true WHERE id = '" . $idEquipement . "';";
        $connPostgre->query($update);
    }
}