<?php echo $titlepage; ?>

prepare("SELECT * FROM data_td WHERE iddata_td = ?"); $stmt->bind_param("i", $idtd); $stmt->execute(); $rowtd = $stmt->get_result()->fetch_assoc(); $stmt->close(); $conn->close(); if (!$rowtd) { die('Dossier non trovato'); } $idtrftd = (int)$rowtd['idtrf']; $idcompany = (int)$rowtd['idcompany']; ?> 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(); */ ?> setQuery("SELECT * FROM `trf-details` WHERE `trf-details`.idtrfdetails='$idtrftd'"); $tdquery->execute(); $description = $tdquery->getColumnVal("sample_description"); $trfn = $tdquery->getColumnVal("trfnumber"); $trfrev = $tdquery->getColumnVal("revtrf"); $trfnumb = $trfn . ' VER.' . $trfrev; $idart = $tdquery->getColumnVal("idarticletype"); ?> prepare($partquerylist); $partqueryliststmd->bind_param("i", $idart); $partqueryliststmd->execute(); $resultpartquery = $partqueryliststmd->get_result(); // Copia i risultati in un array $partRows = []; while ($row = $resultpartquery->fetch_assoc()) { // Aggiungi partsnameeng con fallback a partsnameita se non esiste $row['partsnameeng'] = isset($row['partsnameeng']) ? $row['partsnameeng'] : $row['partsnameita']; $partRows[] = $row; } $partqueryliststmd->close(); $conn->close(); // Aggiungi l'opzione specifica in base a $idart switch ($idart) { case 1: $partRows[] = [ 'partsnumber' => '99', 'partsnameita' => 'Calzatura completa', 'partsnameeng' => 'Complete Footwear' ]; break; case 2: $partRows[] = [ 'partsnumber' => '99', 'partsnameita' => 'Guanto Completo', 'partsnameeng' => 'Complete Glove' ]; break; case 3: $partRows[] = [ 'partsnumber' => '99', 'partsnameita' => 'Semimaschera completa', 'partsnameeng' => 'Complete Half-Mask' ]; break; case 4: $partRows[] = [ 'partsnumber' => '99', 'partsnameita' => 'Indumento completo', 'partsnameeng' => 'Complete Garment' ]; break; } ?> <?php echo $titlepage; ?>

- TF: -Rev.

hasRole('Admin') || Auth::user()->hasRole('CustomerService') || Auth::user()->hasRole('Superuser') || Auth::user()->hasRole('Certification'); ?>

setQuery("SELECT * FROM identificationparts WHERE identificationparts.idtrfdetails='$idtrftd'"); $partsquery->execute(); ?> atEnd()) { ?> " name="ididentificationparts"> moveNext(); ?> moveFirst(); // Se hai bisogno di riutilizzare i risultati ?>

List	N.
	" name="partsidnumber" >	" name="description_identificationparts" >	" name="article_identificationparts" >	" name="color_identificationparts" >	" name="material_identificationparts" >	" name="cmcreportnumber_identificationparts">	" name="cmcreportdate_identificationparts">

setQuery("SELECT * FROM trfchemicalagent LEFT JOIN chemicalagent ON trfchemicalagent.idchemicalagent=chemicalagent.idchemicalagent WHERE trfchemicalagent.idtrf='$idtrftd'"); $chemquery->execute(); ?> atEnd()) { ?> " name="idtrfchemicalagent"> moveNext(); ?> moveFirst(); // Se hai bisogno di riutilizzare i risultati ?>


getColumnVal("name_chemicalagent"); ?>		" id="degradationpercentage_getColumnVal("idtrfchemicalagent"); ?>" name="degradationpercentage" maxlength="6" data-id="getColumnVal("idtrfchemicalagent"); ?>" onblur="updateField(this)">