<?php
// Include la libreria TCPDF
ob_start();

// Include l'autoloader di Dompdf
require 'dompdf/autoload.inc.php';

// Utilizza il namespace Dompdf
use Dompdf\Dompdf;
use Dompdf\Options;

$options = new Options();
$options->set('isHtml5ParserEnabled', true);
$options->set('isRemoteEnabled', true);


$dompdf = new Dompdf($options);
$dompdf->setBasePath($_SERVER['DOCUMENT_ROOT']);


require_once '../Connections/cmctrfdb.php';
require_once '../webassist/mysqli/rsobj.php';
//include 'include/headscript.php';

include('languages/' . $_SESSION['langselect'] . '/tdgen.php');
include('languages/' . $_SESSION['langselect'] . '/general.php');
// usa $idtd già impostato da sendtd.php, altrimenti dalla richiesta
$idtd = (int)($idtd ?? $_POST['idtd'] ?? $_GET['idtd'] ?? 0);
if ($idtd <= 0) {
    die('ID dossier mancante');
}

$conn = new mysqli($servername, $username, $password, $dbname);
$stmt = $conn->prepare("SELECT idtrf, idcompany FROM data_td WHERE iddata_td = ?");
$stmt->bind_param("i", $idtd);
$stmt->execute();
$rowids = $stmt->get_result()->fetch_assoc();
$stmt->close();
$conn->close();

if (!$rowids) {
    die('Dossier non trovato');
}

$idtrftd   = (int)$rowids['idtrf'];
$idcompany = (int)$rowids['idcompany'];
$base_url = "https://www.cimac.it/modulo_certificazione/public/";


$conn = new mysqli($servername, $username, $password, $dbname);
$checkQuery = "SELECT COUNT(*) as count FROM fillrisk_td WHERE iddata_td = ?";
$stmt = $conn->prepare($checkQuery);
$stmt->bind_param("i", $idtd);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();
if ($row['count'] == 0) {
    // Non ci sono record, quindi procedi con l'inserimento dei dati da riskarea_td

    // Prendi tutti i record da riskarea_td
    $selectQuery = "SELECT * FROM riskarea_td";
    $result = $conn->query($selectQuery);


    while ($riskRow = $result->fetch_assoc()) {
        // Prepara l'insert per ogni riga trovata in riskarea_td

        $insertQuery = "INSERT INTO fillrisk_td (idriskarea_td, applicable, idcompany, iddata_td, idtrf) VALUES (?, ?, ?, ?, ?)";
        $stmt = $conn->prepare($insertQuery);

        // Converte il valore 'Y'/'N' della colonna default in un intero (1/0)
        $applicableValue = ($riskRow['default'] == 'Y') ? 1 : 0;

        $stmt->bind_param("iiiii", $riskRow['idriskarea_td'], $applicableValue, $idcompany, $idtd, $idtrftd);
        $stmt->execute();
    }
}


// Chiudi lo statement e la connessione se non ti servono più
$stmt->close();
$conn->close();


// query data_td
$conn = new mysqli($servername, $username, $password, $dbname);
$sql = "SELECT * FROM data_td LEFT JOIN logo_td ON data_td.manufacturerlogoid=logo_td.idlogo_Td LEFT JOIN qualcheck_td ON data_td.proddescription=qualcheck_td.idqualcheck_td  WHERE iddata_td = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $idtd); // "i" indica che l'id è un intero
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();
$prodplace = $row['productionplace_same'];
$classshoes = $row['classificationshoes'];
$zipfile = $row['zipname'];
$tdrev  = $row['td_rev'];
$tdnumber  = $row['tdnumber'];

if ($classshoes == "classone") {
    $classfinal = $classone;  // Assumo che il valore che vuoi assegnare sia una stringa "classone"
} elseif ($classshoes == "classtwo") {
    $classfinal = $classtwo;  // Assumo che il valore che vuoi assegnare sia una stringa "classtwo"
} else {
    $classfinal = "default";   // Opzionale: Un valore default se non corrisponde a nessuno dei casi
}

$stmt->close();
$conn->close();

$tdquery = new WA_MySQLi_RS("tdquery", $cmctrfdb, 1);
$tdquery->setQuery("SELECT * FROM `trf-details` LEFT JOIN modelarticle ON modelarticle.idmodelarticle=`trf-details`.model  WHERE `trf-details`.idtrfdetails='$idtrftd'");
$tdquery->execute();

$description = $tdquery->getColumnVal("sample_description");
$trfn = $tdquery->getColumnVal("trfnumber");
$trfrev  = $tdquery->getColumnVal("revtrf");
$mandat  = $tdquery->getColumnVal("otherclient");
$trfnumb = $trfn . ' VER.' . $trfrev;
$trftdnumber = $trfn . 'TF';
$photocover  = $tdquery->getColumnVal("photofilename");
$photoone  = $tdquery->getColumnVal("photoone");
$phototwo  = $tdquery->getColumnVal("phototwo");
$virusprot = $tdquery->getColumnVal("virusprotection");
$idarttype = $tdquery->getColumnVal("idarticletype");

$slippingtext = $tdquery->getColumnVal("slipping") === 'Y' ? 'Sì' : ($tdquery->getColumnVal("slipping") === '' ? 'No' : $tdquery->getColumnVal("slipping"));
$autoclavabletext = $tdquery->getColumnVal("autoclavable") === 'Y' ? 'Sì' : ($tdquery->getColumnVal("autoclavable") === '' ? 'No' : $tdquery->getColumnVal("autoclavable"));
$ukcatext = $tdquery->getColumnVal("ukca") === 'Y' ? 'Sì' : ($tdquery->getColumnVal("ukca") === '' ? 'No' : $tdquery->getColumnVal("ukca"));
$esdtext = $tdquery->getColumnVal("esd") === 'Y' ? 'Sì' : ($tdquery->getColumnVal("esd") === '' ? 'No' : $tdquery->getColumnVal("esd"));
$shoesorthopedictext = $tdquery->getColumnVal("shoesorthopedic") === 'Y' ? 'Sì' : ($tdquery->getColumnVal("shoesorthopedic") === '' ? 'No' : $tdquery->getColumnVal("shoesorthopedic"));
$shoesorthopedicmodtext = $tdquery->getColumnVal("shoesorthopedicmod") === 'Y' ? 'Sì' : ($tdquery->getColumnVal("shoesorthopedicmod") === '' ? 'No' : $tdquery->getColumnVal("shoesorthopedicmod"));


$conn = new mysqli($servername, $username, $password, $dbname);


$kindcont = "headercertificate";
// Usa segnaposti per i parametri


$sqlcontact = "SELECT * FROM contacts LEFT JOIN countries ON countries.idcountries=contacts.country WHERE contacts.idtrf='$idtrftd' AND contacts.kindofcontacts='$kindcont'";

// Esecuzione della query
$resultcontact = $conn->query($sqlcontact);
$rowcontact = $resultcontact->fetch_assoc();
$companyname = $rowcontact["companyname"];
$address = $rowcontact["address"] . ' ' . $rowcontact["cap"] . ' ' . $rowcontact["city"];
$country = $rowcontact["namecountry"];
$phone = $rowcontact["telephone"];
$emailtd = $rowcontact["email"];
$vat = $rowcontact["piva"];
$ceinside = $rowcontact["ce"];
$mark = $tdquery->getColumnVal("registeredmark");

$contactperson = $rowcontact["contactname"] . ' ' . $rowcontact["contactsurname"];

// Chemical agent
$conn = new mysqli($servername, $username, $password, $dbname);
$sqlchemical = "SELECT trfchemicalagent.level, trfchemicalagent.degradationpercentage, chemicalagent.name_chemicalagent 
                FROM trfchemicalagent 
                LEFT JOIN chemicalagent ON trfchemicalagent.idchemicalagent = chemicalagent.idchemicalagent 
                WHERE trfchemicalagent.idtrf = '$idtrftd'";
$resultchemical = $conn->query($sqlchemical);
$chemicalAgents = []; // Array per memorizzare i risultati

if ($resultchemical && $resultchemical->num_rows > 0) {
    // Riempie l'array con i risultati della query
    while ($rowchemical = $resultchemical->fetch_assoc()) {
        $chemicalAgents[] = $rowchemical;
    }
}
$conn->close();


// Protection cat add
$conn = new mysqli($servername, $username, $password, $dbname);
$sqlprotect = "SELECT * FROM trfaddrequirements LEFT JOIN additionalrequirements ON trfaddrequirements.idadditionalrequirements = additionalrequirements.idadditionalrequirements WHERE trfaddrequirements.idtrf = '$idtrftd'";
$resultprotect = $conn->query($sqlprotect);
$protectionAdd = []; // Array per memorizzare i risultati

if ($resultprotect && $resultprotect->num_rows > 0) {;
    // Riempie l'array con i risultati della query
    while ($rowprotect = $resultprotect->fetch_assoc()) {

        $protectionAdd[] = $rowprotect["name_additionalrequirements_it"];
    }
}
$conn->close();

// Connessione al database
$conn = new mysqli($servername, $username, $password, $dbname);

// Controlla la connessione
if ($conn->connect_error) {
    die("Connessione fallita: " . $conn->connect_error);
}

// Preparazione della query

$tdquerystd = "SELECT * FROM trfstandards 
          LEFT JOIN standards ON trfstandards.idstandards = standards.idstandards 
          LEFT JOIN protectioncategory ON protectioncategory.idprotectioncategory = trfstandards.idprotectioncategory 
          LEFT JOIN dpicategory ON dpicategory.iddpicategory = trfstandards.iddpicategory 
          WHERE trfstandards.idtrfdetails = '$idtrftd'";

// Esecuzione della query
$resultstd = $conn->query($tdquerystd);

if (!$resultstd) {
    die("Errore nell'esecuzione della query: " . $conn->error);
}


$conn = new mysqli($servername, $username, $password, $dbname);

// Controlla la connessione
if ($conn->connect_error) {
    die("Connessione fallita: " . $conn->connect_error);
}
// Preparazione della query
$addprot = "SELECT * FROM trfaddrequirements 
            LEFT JOIN additionalrequirements ON trfaddrequirements.idadditionalrequirements = additionalrequirements.idadditionalrequirements 
            WHERE trfaddrequirements.idtrf = '$idtrftd'";
// Esecuzione della query
$resultaddreq = $conn->query($addprot);
if (!$resultaddreq) {
    die("Errore nell'esecuzione della query: " . $conn->error);
}


$tdquerystd = new WA_MySQLi_RS("tdquerystd", $cmctrfdb, 1);
$tdquerystd->setQuery("SELECT * FROM trfstandards LEFT JOIN standards ON trfstandards.idstandards=standards.idstandards LEFT JOIN protectioncategory ON protectioncategory.idprotectioncategory=trfstandards.idprotectioncategory LEFT JOIN dpicategory ON dpicategory.iddpicategory=trfstandards.iddpicategory WHERE trfstandards.idtrfdetails='$idtrftd'");
$tdquerystd->execute();


// query prod place

//query location place
// Assumendo che $idt sia già definito e sanificato per prevenire SQL Injection

$conn = new mysqli($servername, $username, $password, $dbname);
$querylocation = "SELECT idcontactstd, companyName, address, city FROM contacts_td WHERE idtd = ?";
$stmt = $conn->prepare($querylocation);
$stmt->bind_param("i", $idtd); // "i" indica che il parametro è un intero
$stmt->execute();
$result = $stmt->get_result();

$rowslocation = [];
while ($rowlocation = $result->fetch_assoc()) {
    $rowslocation[] = $rowlocation;
}
$stmt->close();

$companylogofinal = !empty($companylogo) ? $base_url . "logos/" . $companylogo : '';

// Crea una nuova istanza di Dompdf
$html = <<<HTML
<!DOCTYPE html>
<html>
<head>
<style>
    @page { 
        margin: 120px 25px 80px 25px; /* Aumenta il margine superiore e inferiore */
    }
    body { 
        font-family: 'DejaVu Sans', sans-serif; 
    }
    header { 
        position: fixed; 
        top: -120px; /* Posizionato 120px sopra il margine superiore della pagina */
        left: 0; 
        right: 0; 
        height: 100px; /* Assicurati che l'altezza sia sufficiente per il tuo logo */
        text-align: center; 
    }
    footer { 
        position: fixed; 
        bottom: -80px; /* Posizionato 80px sopra il margine inferiore della pagina */
        left: 0; 
        right: 0; 
        height: 50px; 
        text-align: center; 
    }
    .page-number:before { 
        content: "Pagina " counter(page); /* Aggiunge "Pagina" prima del numero di pagina */
    }
    table {
        width: 100%;
        border-collapse: collapse;
        margin-top: 20px; /* Mantieni o regola secondo necessità */
    }
    th, td {
        border: 1px solid #000000;
        padding: 4px;
        font-size: 8pt;
        background-color: #fff;
        word-wrap: break-word;
        word-break: break-all;
    }
    th {
        background-color: #909090;
        color: white;
        text-align: left;
        font-size: 9pt;
    }
    td.header-data {
        background-color: #E7F4FA;
        max-width: 100%; /* Assicurati che la cella non superi la larghezza disponibile */
        overflow: hidden; /* Nascondi eventuale contenuto che esce dalla cella */
    }
    td.firstrisk {
        background-color: #ffffff;
        color: #000000;
    }
    .boldstyle {
        font-weight: normal; /* Stile per testo in grassetto, correggi secondo necessità */
        background-color: #ffffff;
        color: #000000;
        font-size: 8pt;
    }
    img {
        max-width: 100%; /* Assicurati che l'immagine non superi la larghezza della cella */
        height: auto; /* Mantieni le proporzioni dell'immagine */
    }
    .content {
        overflow: hidden;
        text-overflow: ellipsis; /* Troncamento del testo se troppo lungo */
    }
    .page-break {
        page-break-after: always;
    }
</style>


</head>
<body>
<header style="margin-top: 20px;">
<img src="{$companylogofinal}" alt="Logo Azienda" style="height: 80px; display: block; margin-top: 10px; float: left;"">
</header>
<footer style="font-size: smaller;">
    <div>
        {$companyaddressfinal}
    </div>
    <div style="font-size: x-small; margin-top: 3px;">
        <span class="page-number"></span>
    </div>
</footer>

<h3 style="text-align: center;">File Tecnico numero: $tdnumber - Rev. $tdrev</h3>

<table>
    <thead>
        <tr>
            <th colspan="2">DATI DEL FABBRICANTE / MANUFACTURER'S DATA</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td class="first-column">Nome Azienda / Company Name</td>
            <td class="header-data">$companyname</td>
        </tr>
        <tr>
            <td class="first-column">Indirizzo / Address</td>
            <td class="header-data">$address</td>
        </tr>
        <tr>
            <td class="first-column">Paese / Country</td>
            <td class="header-data">$country</td>
        </tr>
        <tr>
            <td class="first-column">Telefono / Phone</td>
            <td class="header-data">$phone</td>
        </tr>
        <tr>
            <td class="first-column">Email</td>
            <td class="header-data">$emailtd</td>
        </tr>
        <tr>
            <td class="first-column">Partita IVA / VAT Number</td>
            <td class="header-data">$vat</td>
        </tr>
        <tr>
            <td class="first-column">Marchio / Mark</td>
            <td class="header-data">$mark</td>
        </tr>
        <tr>
            <td class="first-column">Persona di Contatto / Contact Person</td>
            <td class="header-data">$contactperson</td>
        </tr>
    </tbody>
</table>
HTML;

if ($ceinside != 'Y') {
    $kindcont = "extrace";
    $sqlcontactextrace = "SELECT * FROM contacts LEFT JOIN countries ON countries.idcountries=contacts.country WHERE contacts.idtrf='$idtrftd' AND contacts.kindofcontacts='$kindcont'";

    $resultcontactextrace = $conn->query($sqlcontactextrace);
    if ($resultcontactextrace->num_rows > 0) {
        // Esecuzione della query
        $rowcontactextrace = $resultcontactextrace->fetch_assoc();
        $companynameextrace = $rowcontactextrace["companyname"];
        $addressextrace = $rowcontactextrace["address"] . ' ' . $rowcontact["cap"] . ' ' . $rowcontact["city"];
        $countryextrace = $rowcontactextrace["namecountry"];
        $phoneextrace = $rowcontactextrace["telephone"];
        $emailtdextrace = $rowcontactextrace["email"];
        $vatextrace = $rowcontactextrace["piva"];


        $contactpersonextrace = $rowcontactextrace["contactname"] . ' ' . $rowcontactextrace["contactsurname"];


        $html .= '<table>
    <thead>
        <tr>
            <th colspan="2">MANDATARIO</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td class="first-column">Nome Azienda / Company Name</td>
            <td class="header-data">' . $companynameextrace . '</td>
        </tr>
        <tr>
            <td class="first-column">Indirizzo / Address</td>
            <td class="header-data">' . $addressextrace . '</td>
        </tr>
        <tr>
            <td class="first-column">Paese / Country</td>
            <td class="header-data">' . $countryextrace . '</td>
        </tr>
        <tr>
            <td class="first-column">Telefono / Phone</td>
            <td class="header-data">' . $phoneextrace . '</td>
        </tr>
        <tr>
            <td class="first-column">Email</td>
            <td class="header-data">' . $emailtdextrace . '</td>
        </tr>
        <tr>
            <td class="first-column">Partita IVA / VAT Number</td>
            <td class="header-data">' . $vatextrace . '</td>
        </tr>
        <tr>
            <td class="first-column">Persona di Contatto / Contact Person</td>
            <td class="header-data">' . $contactpersonextrace . '</td>
        </tr>
    </tbody>
</table>';
    }
}


// prod place
$html .= '<table>
    <thead>
    <tr>
    <th colspan="3">LUOGO DI PRODUZIONE / PRODUCTION SITE</th>
</tr>';

if ($prodplace == 'Y') {
    $html .= '<tr>
        <th class="boldstyle" colspan="3">coincide con il fabbricante / as manufacturer</th>
    </tr>';
} else {
    $html .= '<tr>
        <th class="boldstyle">Nome Azienda / Companu Name</th>
        <th class="boldstyle">Indirizzo / Address</th>
        <th class="boldstyle">Città / City</th>
    </tr>';
    $html .= '</thead>
    <tbody>';

    foreach ($rowslocation as $rowlocation) {
        $html .= "<tr>
            <td class='header-data'>{$rowlocation['companyName']}</td>
            <td class='header-data'>{$rowlocation['address']}</td>
            <td class='header-data'>{$rowlocation['city']}</td>
        </tr>";
    }

    $html .= '</tbody>';
}

$html .= '</table>';

//DPI DATA

$model = $tdquery->getColumnVal("namemodelarticle");
$measuremin = $tdquery->getColumnVal("measurefrom");
$measuremax = $tdquery->getColumnVal("measureto");
$destppe = $row['destinationuseppe'];
$manprocess = $row['manufacutringprocess'];
$ppeage = $row['ppeageing'];
$obsol = $row['obsolescencedeadline'];
$techspec = $row['techspecificationapplied'];
if ($ppeage == 'Y') {
    $ppeagetext = 'Sì';
} else {
    $ppeagetext = 'No';
}
$html .= <<<HTML

<table>
    <thead>
        <tr>
            <th colspan="2">DATI RELATIVI AL DPI / PPE DATA</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td class="first-column">Codice Articolo</td>
            <td class="header-data">{$description}</td>
        </tr>
        <tr>
            <td class="first-column">Modello</td>
            <td class="header-data">{$model}</td>
        </tr>
HTML;

if ($idarttype == 1) {
    $html .= <<<HTML
        <tr>
            <td class="first-column">Classificazione</td>
            <td class="header-data">{$classfinal}</td>
        </tr>
HTML;
}

$html .= <<<HTML
        <tr>
            <td class="first-column">Misura</td>
            <td class="header-data">{$measuremin} - {$measuremax}</td>
        </tr>
        <tr>
            <td class="first-column">Destinazione d'uso del DPI</td>
            <td class="header-data">{$destppe}</td>
        </tr>
        <tr>
            <td class="first-column">Processo di lavorazione</td>
            <td class="header-data">{$manprocess}</td>
        </tr>
        <tr>
            <td class="first-column">DPI soggetto ad invecchiamento</td>
            <td class="header-data">{$ppeagetext}</td>
        </tr>
        <tr>
            <td class="first-column">Data di obsolescenza (anni)</td>
            <td class="header-data">{$obsol}</td>
        </tr>
        <tr>
            <td class="first-column">{$techapplied}</td>
            <td class="header-data">{$techspec}</td>
        </tr>
    </tbody>
</table>
HTML;


//  dpi standard

$html .= '<table>
    
    <tbody>';

while ($rowstd = $resultstd->fetch_assoc()) {
    $stdcode = $rowstd['standardcode'];
    $dpicat = $rowstd['value_dpicategory'];
    $html .= "<tr>
        <td style='font-weight: bold; width: 20%;'>Norme armonizzate di riferimento</td>
        <td class='header-data' style='width: 20%;'>{$stdcode}</td>
        <td style='font-weight: bold; width: 15%;'>Cat Protezione DPI</td>
        <td class='header-data' style='width: 15%;'>{$rowstd['name_protectioncategory']}</td>
        <td style='font-weight: bold; width: 15%;'>Categoria del DPI</td>
        <td class='header-data' style='width: 15%;'>{$rowstd['value_dpicategory']}</td>
    </tr>";
};
$html .= '</tbody></table>';


if ($idarttype == 1) {
    $html .= <<<HTML
<table>
    <thead>
        <tr>
            <th colspan="2">Altre informazioni</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td class="first-column">Resistenza allo scivolamento</td>
            <td class="header-data" style="width: 50%;">{$slippingtext}</td>
        </tr>
        <tr>
            <td class="first-column">Autoclavabile</td>
            <td class="header-data">{$autoclavabletext}</td>
        </tr>
        <tr>
            <td class="first-column">Certificazione UKCA</td>
            <td class="header-data">{$ukcatext}</td>
        </tr>
        <tr>
            <td class="first-column">Calzature con plantari personalizzati (DGUV)</td>
            <td class="header-data">{$shoesorthopedictext}</td>
        </tr>
        <tr>
            <td class="first-column">Calzature modificate con rialzi o inserti nel fondo (DGUV)</td>
            <td class="header-data">{$shoesorthopedicmodtext}</td>
        </tr>
        <tr>
            <td class="first-column">Calzature ESD</td>
            <td class="header-data">{$esdtext}</td>
        </tr>
    </tbody>
</table>
HTML;
}

//  Add prot category

$html .= '<table>
    
    <tbody>';

while ($rowaddreq = $resultaddreq->fetch_assoc()) {

    $html .= "<tr>
        <td style='font-weight: bold; width: 15%;'>Categoria di protezione aggiuntiva</td>
        <td class='header-data' style='width: 15%;'>{$rowaddreq['name_additionalrequirements_it']}</td>

    </tr>";
};
$html .= '</tbody></table>';


//photos da fare
$photoRows = '';
$hasPhotos = false;

// Check for photocover
if (!empty($photocover)) {
    $coverPath = $base_url . "uploadimages/" . htmlspecialchars($photocover);
    $localCoverPath = __DIR__ . "/uploadimages/" . htmlspecialchars($photocover);
    if (file_exists($localCoverPath)) {
        $imageData = base64_encode(file_get_contents($localCoverPath));
        $mimeType = mime_content_type($localCoverPath);
        $photoRows .= <<<HTML
        <tr>
            <td class="first-column">Foto Articolo / Article Photo</td>
            <td class="header-data">
                <img src='data:$mimeType;base64,$imageData' alt='Cover Photo' style='max-height: 200px;'>
            </td>
        </tr>
HTML;
        $hasPhotos = true;
    }
}

// Check for photoone
if (!empty($photoone)) {
    $photoOnePath = $base_url . "uploaddocuments/" . htmlspecialchars($photoone);
    $localPhotoOnePath = $_SERVER['DOCUMENT_ROOT'] . "/modulo_certificazione/public/uploaddocuments/" . htmlspecialchars($photoone);
    if (file_exists($localPhotoOnePath)) {
        $imageData = base64_encode(file_get_contents($localPhotoOnePath));
        $mimeType = mime_content_type($localPhotoOnePath);
        $photoRows .= <<<HTML
        <tr>
            <td class="first-column">Foto 1 / Photo 1</td>
            <td class="header-data">
                <img src='data:$mimeType;base64,$imageData' alt='Photo 1' style='max-height: 200px;'>
            </td>
        </tr>
HTML;
        $hasPhotos = true;
    }
}

// Check for phototwo
if (!empty($phototwo)) {
    $photoTwoPath = $base_url . "uploaddocuments/" . htmlspecialchars($phototwo);
    $localPhotoTwoPath = $_SERVER['DOCUMENT_ROOT'] . "/modulo_certificazione/public/uploaddocuments/" . htmlspecialchars($phototwo);
    if (file_exists($localPhotoTwoPath)) {
        $imageData = base64_encode(file_get_contents($localPhotoTwoPath));
        $mimeType = mime_content_type($localPhotoTwoPath);
        $photoRows .= <<<HTML
        <tr>
            <td class="first-column">Foto 2 / Photo 2</td>
            <td class="header-data">
                <img src='data:$mimeType;base64,$imageData' alt='Photo 2' style='max-height: 200px;'>
            </td>
        </tr>
HTML;
        $hasPhotos = true;
    }
}

// Add the table only if there are photos
if ($hasPhotos) {
    $html .= <<<HTML
<table>
    <thead>
        <tr>
            <th colspan="2">FOTO DEL PRODOTTO / PRODUCT PHOTOS</th>
        </tr>
    </thead>
    <tbody>
        $photoRows
    </tbody>
</table>
HTML;
}

// virus prot
if ($virusprot == "Y") :
    $html .= '<table>
    <tbody>
    <tr>
    <td style="width: 50%;" colspan="1">Protezione da Virus</td>
    <td>' . (($virusprot == 'Y') ? 'Sì' : 'No') . '</td>

</tr>
        
    </tbody>';


    $html .= '</tbody></table>';
endif;


// chem agent
if (!empty($chemicalAgents)) :
    $html .= '<table>
    <thead>
    <tr>
    <td>Chemical Agent</td>';

    if ($idarttype == 2) {
        $html .= '<td>Level</td>
                  <td>Degradation Percentage</td>';
    }

    $html .= '</tr>
    </thead>
    <tbody>';

    foreach ($chemicalAgents as $agent) :
        $html .= "<tr>
        <td>{$agent['name_chemicalagent']}</td>";

        if ($idarttype == 2) {
            $html .= "<td class='header-data'>{$agent['level']}</td>
                      <td class='header-data'>{$agent['degradationpercentage']}</td>";
        }

        $html .= '</tr>';
    endforeach;
    $html .= '</tbody></table>';
endif;


//table risk query

$riskquery = new WA_MySQLi_RS("riskquery", $cmctrfdb, 0);
$riskquery->setQuery("SELECT * FROM fillrisk_td LEFT JOIN riskarea_td ON riskarea_td.idriskarea_td=fillrisk_td.idriskarea_td WHERE fillrisk_td.iddata_td = '$idtd' ORDER BY CAST(SUBSTRING_INDEX(CONCAT(riskarea_td.risknumber,'.0.0.0'),'.',1) AS UNSIGNED), CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(CONCAT(riskarea_td.risknumber,'.0.0.0'),'.',2),'.',-1) AS UNSIGNED), CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(CONCAT(riskarea_td.risknumber,'.0.0.0'),'.',3),'.',-1) AS UNSIGNED), CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(CONCAT(riskarea_td.risknumber,'.0.0.0'),'.',4),'.',-1) AS UNSIGNED)");
$riskquery->execute();

$html .= "
<div class='page-break'></div>
<table>
    <thead>
    <tr>
    <th colspan='4'> VALUTAZIONE DEI RISCHI (REQUISITI ESSENZIALI DI SALUTE E SICUREZZA IN ACCORDO ALL'ALLEGATO II DEL REGOLAMENTO (UE) 2016/425) /
    RISK ASSESSMENT (ESSENTIAL HEALTH AND SAFETY REQUIREMENT ACCORDING TO ANNEX II OF THE REGULATION (EU) 2016/425)</th>
</tr>
        <tr>
            <th class='boldstyle' style='width: 10%;'>{$requirementnumbertd}</th>
            <th class='boldstyle' style='width: 45%;'>{$requirementnametd}</th>
            <th class='boldstyle' style='width: 10%;'>{$applicabletd}</th>
            <th class='boldstyle' style='width: 35%;'>{$covertbytd}</th>
        </tr>
    </thead>
    <tbody>";

$html .= <<<HTML
    <tbody>
    HTML;

// Aggiungi qui il codice PHP fornito
while (!$riskquery->atEnd()) {
    $risknumber = $riskquery->getColumnVal("risknumber");
    $riskname_it = $riskquery->getColumnVal("riskname_it");
    $applicable = ($riskquery->getColumnVal("applicable") == "1") ? 'checked' : '';
    $customCheckId = "customCheck{$risknumber}";
    $covertext = '';
    if ($riskquery->getColumnVal("coveredby") == 'coverone') {
        $covertext = $coverone;
    } else if ($riskquery->getColumnVal("coveredby") == 'covertwo') {
        $covertext = $covertwo;
    } else if ($riskquery->getColumnVal("coveredby") == 'coverthree') {
        $covertext = $coverthree;
    }

    $html .= <<<HTML
        <tr>
            <td scope="row" >{$risknumber}</td>
            <td>{$riskname_it}</td>
            <td  class='header-data' style="text-align: center;">
                <div class="custom-control custom-checkbox">
                <input disabled type="checkbox" class="custom-control-input blue-highlight" id="{$customCheckId}" {$applicable} data-parsley-multiple="groups" data-parsley-mincheck="2">

                <label class="custom-control-label" for="{$customCheckId}"></label>
                </div>
            </td>

            <td  class='header-data'>
                <div class="col-sm-24">
                    {$covertext}
                </div>
            </td>
            <input class="form-control" type="hidden" value="{$riskquery->getColumnVal("idfillrisk_td")}" name="fillrisktd{$riskquery->getColumnVal("idfillrisk_td")}">
        </tr>
    HTML;

    $riskquery->moveNext();
}

$html .= <<<HTML
    </tbody>
    HTML;

$html .= '</tbody></table>';

//parts

$html .= "<table>
    <thead>
    <tr>
    <th colspan='7'>  COMPONENTI DEL DPI / PPE PARTS</th>
</tr>
        <tr>
            <th class='boldstyle' style='width: 5%;' >N.</th>
            <th class='boldstyle' style='width: 20%;'>{$descriptionpart}</th>
            <th class='boldstyle' style='width: 20%;'>{$articlepart}</th>
            <th class='boldstyle' style='width: 15%;'>{$colorpart}</th>
            <th class='boldstyle' style='width: 20%;'>{$descriptionpartlist}</th>
            <th class='boldstyle' style='width: 10%;'>{$reprtonumbertrdlabtitle}</th>
            <th class='boldstyle' style='width: 10%;'>{$trddatereporttitle}</th>

        </tr>
    </thead>
    <tbody>";

$partsquery = new WA_MySQLi_RS("partsquery", $cmctrfdb, 0);
$partsquery->setQuery("SELECT * FROM identificationparts WHERE identificationparts.idtrfdetails='$idtrftd'");
$partsquery->execute();

while (!$partsquery->atEnd()) {
    // Decodifica e sanitizza ogni valore del database
    $partsidnumber = htmlspecialchars(html_entity_decode($partsquery->getColumnVal('partsidnumber'), ENT_QUOTES | ENT_HTML5, 'UTF-8'));
    $partdescription = htmlspecialchars(html_entity_decode($partsquery->getColumnVal('description_identificationparts'), ENT_QUOTES | ENT_HTML5, 'UTF-8'));
    $article = htmlspecialchars(html_entity_decode($partsquery->getColumnVal('article_identificationparts'), ENT_QUOTES | ENT_HTML5, 'UTF-8'));
    $color = htmlspecialchars(html_entity_decode($partsquery->getColumnVal('color_identificationparts'), ENT_QUOTES | ENT_HTML5, 'UTF-8'));
    $material = htmlspecialchars(html_entity_decode($partsquery->getColumnVal('material_identificationparts'), ENT_QUOTES | ENT_HTML5, 'UTF-8'));
    $reportnumber = htmlspecialchars(html_entity_decode($partsquery->getColumnVal('cmcreportnumber_identificationparts'), ENT_QUOTES | ENT_HTML5, 'UTF-8'));
    $reportdate = htmlspecialchars(html_entity_decode($partsquery->getColumnVal('cmcreportdate_identificationparts'), ENT_QUOTES | ENT_HTML5, 'UTF-8'));

    // Costruisci la riga HTML
    $html .= "<tr>
            <td class='header-data'>" . $partsidnumber . "</td>
            <td class='header-data'>" . $partdescription . "</td>
            <td class='header-data'>" . $article . "</td>
            <td class='header-data'>" . $color . "</td>
            <td class='header-data'>" . $material . "</td>
            <td class='header-data'>" . $reportnumber . "</td>
            <td class='header-data'>" . $reportdate . "</td>
        </tr>";
    $partsquery->moveNext();
}

$html .= '</tbody></table>';

//ce mark example

$localisationppemarking = $row['localisationppemarking'];
$sizeexamplecemark = $row['sizeexamplecemark'];
$manufacturerlogoid = $row['manufacturerlogoid'];
$filenamelogo = $row['filenamelogo'];
$monthyearprod = $row['monthyearprod'];
$serialbatchnumber = $row['serialbatchnumber'];
$standarduse = $row['standarduse'];
$symbolsaddreq = $row['symbolsaddreq'];
$proddescription = $row['qualchecktext'];
// Aggiungi il base URL alle immagini
$proddescription = preg_replace('/src="(ckupload\/[^"]+)"/', 'src="' . $base_url . '$1"', $proddescription);

// Decodifica eventuali entità HTML nel contenuto
$proddescription = html_entity_decode($proddescription);

$organismnumber = $row['organismnumber'];
$cemarkup = $row['cemarkupload'];
$filenamelogowithpath = !empty($filenamelogo) ? "{$base_url}logos/{$filenamelogo}" : "{$base_url}assets/images/notav.jpg";


// Connessione al database
$conn = new mysqli($servername, $username, $password, $dbname);
$querytdfile = "SELECT idtdfileattached, filename_fileattached, description_fileattached FROM tdfileattached WHERE iddata_td = ? AND description_fileattached = 'CE mark example'";
$stmt = $conn->prepare($querytdfile);
$stmt->bind_param("i", $idtd);
$stmt->execute();
$resulttdfile = $stmt->get_result();

$fileUploaded = $resulttdfile->num_rows > 0;
$fileDetails = $resulttdfile->fetch_assoc();

$html .= <<<HTML
<table>
    <thead>
        <tr>
            <th colspan="2">ESEMPIO DI MARCATURA CE / EXAMPLE OF CE MARKING </th>
        </tr>
    </thead>
    <tbody>
HTML;

if ($cemarkup == 'Y' && $fileUploaded) {
    // $filePathdoc = '{$base_url}uploadtddocuments/' . htmlspecialchars($fileDetails['filename_fileattached']);
    $filePathdoc = $base_url . "uploadtddocuments/" . htmlspecialchars($fileDetails['filename_fileattached']);
    $localFilePath = __DIR__ . "/uploadtddocuments/" . htmlspecialchars($fileDetails['filename_fileattached']);
    $fileDescription = htmlspecialchars($fileDetails['description_fileattached']);
    $fileExtension = strtolower(pathinfo($filePathdoc, PATHINFO_EXTENSION));

    $html .= <<<HTML
        <tr>
            <td class="first-column">FILE (se diverso da immagine il file è caricato nello zip come allegato)</td>
            <td>
HTML;

    //  if (in_array($fileExtension, ['jpg', 'jpeg', 'png', 'gif'])) {
    //     $html .= "<img src='$filePathdoc' alt='$fileDescription' style='max-height: 200px;'>";
    //} else {
    //   $linkattach = $base_url . "uploadtddocuments/" . $fileDetails['filename_fileattached'];
    //    $html .= "<a href='{$linkattach}' target='_blank'>$fileDescription</a>";
    // }

    if (in_array($fileExtension, ['jpg', 'jpeg', 'png', 'gif'])) {
        if (file_exists($localFilePath)) {
            $imageData = base64_encode(file_get_contents($localFilePath));
            $mimeType = mime_content_type($localFilePath);
            $html .= "<img src='data:$mimeType;base64,$imageData' alt='$fileDescription' style='max-height: 200px;'>";
        } else {
            $html .= "<p>Image file not found: $localFilePath</p>";
        }
    } else {
        $linkattach = $base_url . "uploadtddocuments/" . $fileDetails['filename_fileattached'];
        $html .= "<a href='{$linkattach}' target='_blank'>$fileDescription</a>";
    }

    $html .= <<<HTML
            </td>
        </tr>
HTML;
} else {
    $html .= <<<HTML
    <tr>
        <td class="first-column">Posizione della marcatura sul DPI</td>
        <td class="header-data">{$localisationppemarking}</td>
    </tr>
    <tr>
        <td class="first-column">Marchio del fabbricante</td>
        <td><img src="{$filenamelogowithpath}" style="max-height: 80px;"></td>
    </tr>
    <tr>
        <td class="first-column">Codice Articolo</td>
        <td class="header-data">$description</td>
    </tr>
    <tr>
        <td class="first-column">Indirizzo del fabbricante</td>
        <td class="header-data">$address - $country</td>
    </tr>
    <tr>
        <td class="first-column">Misura</td>
        <td class="header-data">{$sizeexamplecemark}</td>
    </tr>
    <tr>
        <td class="first-column">Mese ed anno di produzione</td>
        <td class="header-data">{$monthyearprod}</td>
    </tr>
    <tr>
        <td class="first-column">Numero di serie e/o di lotto</td>
        <td class="header-data">{$serialbatchnumber}</td>
    </tr>
    <tr>
        <td class="first-column">Numero ed anno della norma armonizzata utilizzata</td>
        <td class="header-data">{$standarduse}</td>
    </tr>
    <tr>
        <td class="first-column">Simbolo/i dei requisiti supplementari</td>
        <td class="header-data">{$symbolsaddreq}</td>
    </tr>
    <tr>
        <td class="first-column">Marcatura CE</td>
        <td>
            <img src="{$base_url}assets/images/ce.jpg" alt="CE Image" style="width:100px;">
HTML;

    if (!is_null($organismnumber)) {
        $html .= " Numero Organismo: $organismnumber";
    }

    $html .= <<<HTML
        </td>
    </tr>
</tbody>
</table>
HTML;
}
$stmt->close();
$conn->close();

$html .= <<<HTML
            </td>
        </tr>

    </tbody>
</table>
HTML;

//mezzi di controllo

$html .= <<<HTML
<div class='page-break'></div>
<div class="section" style="width: 100%; margin-top: 20px; padding: 4px; font-size: 8pt; background-color: #fff; word-wrap: break-word; word-break: break-all;">
    <div class="header" style="background-color: #909090; color: white; text-align: left; font-size: 8pt; padding: 4px;">
        <h4 style="font-size: 8pt; font-weight: bold; margin: 0;">
            MEZZI DI CONTROLLO E PROVA IN PRODUZIONE PER GARANTIRE LA CONFORMITÀ / MEANS USED DURING THE PRODUCTION TO ENSURE THE CONFORMITY
        </h2>
    </div>
    <div class="content" style="background-color: #ffffff; color: #000000; padding: 4px; font-size: 8pt; overflow: hidden; text-overflow: ellipsis;">
        $proddescription
    </div>
</div>
HTML;


//imballaggio

$packaging = $row['packaging'];
$signedontd = $row['signedontd'];
$signnametd = $row['signnametd'];
$declarconformity = $row['declarconformity'];
$webaddress = $row['webaddress'];
if ($declarconformity == 'declarone') {
    $declartext = $declarone;
} else {
    $declartext = $declartwo;
}


$html .= <<<HTML

<table>
    <thead>
        <tr>
            <th colspan="2">IMBALLAGGIO / PACKAGING - DICHIARAZIONE DI CONFORMITÀ UE / EU DECLARATION OF CONFORMITY</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td class="first-column">Imballaggio</td>
            <td class="header-data">{$packaging}</td>
        </tr>
        <tr>
            <td class="first-column">Dichiarazione di conformità UE</td>
            <td class="header-data">{$declartext}</td>
        </tr>
        <tr>
            <td class="first-column">Indirizzo del sito web</td>
            <td class="header-data">{$webaddress}</td>
        </tr>

    </tbody>
</table>
HTML;
// zip file
// Costruisci il link solo se $zipfile non è nullo
if (!is_null($zipfile)) {
    $zipLink = $base_url . "uploadtddocuments/ziptd/" . $zipfile;

    $html .= <<<HTML
    <table>
        <tbody>
            <tr>
                <td class="first-column"><a href="{$zipLink}">Scarica il file ZIP con tutti gli allegati</a></td>
            </tr>
        </tbody>
    </table>
    HTML;
}
//sign table

$html .= <<<HTML

<table>
    <thead>
        <tr>
            Firmato digitalmente tramite token
        </tr>
    </thead>
    <tbody>
        <tr>
            <td class="first-column">Firmato il</td>
            <td class="header-data">{$signedontd}</td>
            <td class="header-data">Da</td>
            <td class="header-data">{$signnametd}</td>
        </tr>
      

    </tbody>
</table>
HTML;


// chiusura


$html .= '</tbody></table></body></html>';

//echo $html;

// Carica il tuo HTML nel Dompdf
$dompdf->loadHtml($html);

// (Opzionale) Imposta il formato e l'orientamento della pagina
// Puoi specificare la dimensione del documento e l'orientamento come segue:
$dompdf->setPaper('A4', 'portrait');

// Renderizza il PDF
$dompdf->render();

//rename pdf
$timestamp = time();
$fileName = $trftdnumber . '-' . 'Rev.' . $tdrev . '-' . $timestamp . '.pdf';
$filePath = 'tdpdf/' . $fileName;
// Stream il PDF al browser
// Salva il PDF su disco
$pdfOutput = $dompdf->output();
file_put_contents($filePath, $pdfOutput);

include('include/zipcreationtd.php');

$UpdateQuery = new WA_MySQLi_Query($cmctrfdb);
$UpdateQuery->Action = "update";
$UpdateQuery->Table = "data_td";
$UpdateQuery->bindColumn("pdffilenametd", "s", "$fileName", "WA_DEFAULT");
$UpdateQuery->bindColumn("zipname", "s", "$namefilezip", "WA_DEFAULT");
$UpdateQuery->addFilter("iddata_td", "=", "i", "" . ($idtd)  . "");
$UpdateQuery->execute();
$UpdateGoTo = "";
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo ? rel2abs($UpdateGoTo, dirname(__FILE__)) : "";
$UpdateQuery->redirect($UpdateGoTo);