setQuery("SELECT * FROM `trf-details` LEFT JOIN auth_users ON `trf-details`.iduser=auth_users.id LEFT JOIN article_type ON `trf-details`.idarticletype=article_type.idarticletype LEFT JOIN certificationtype ON certificationtype.idcertificationtype=`trf-details`.idcertification WHERE `trf-details`.idcompany='$idcompany' AND `trf-details`.signedon <> '' ORDER BY `trf-details`.trfnumber, `trf-details`.revtrf DESC"); $archivetrflist->execute(); ?> setQuery("SELECT * FROM `trf-details` LEFT JOIN article_type ON `trf-details`.idarticletype=article_type.idarticletype LEFT JOIN certificationtype ON certificationtype.idcertificationtype=`trf-details`.idcertification WHERE `trf-details`.idcompany='$idcompany' AND `trf-details`.signedon ='' ORDER BY `trf-details`.trfnumber"); $drafttrf->execute(); ?> <?php echo $titlepage; ?>
  1. TRF
  2. Starter

atEnd()) { $wa_startindex = $drafttrf->Index; ?> getColumnVal("idtrfdetails"); ?> getColumnVal("idcertification") == 5 && $drafttrf->getColumnVal("revcs") != 's') { ?> getColumnVal("idcertification") == 6 && $drafttrf->getColumnVal("revcs") != 's') { ?> getColumnVal("revcs") != 's') { ?> moveNext(); } $drafttrf->moveFirst(); //return RS to first record unset($wa_startindex); unset($wa_repeatcount); ?>
TRF N. REV Description Cert Type Article type To be Sign
getColumnVal("trfnumber")); ?> getColumnVal("revtrf")) > 0) { ?>RgetColumnVal("revtrf"); } ?> getColumnVal("sample_description")); ?> getColumnVal("name_certification")); ?> getColumnVal($nameField)); ?> getColumnVal("revcs"); if ($revcs == 's') { ?>

atEnd()) { // without signed for rev $idtrf_nosign = $archivetrflist->getColumnVal("idtrfdetails"); $trfnosign = $archivetrflist->getColumnVal("trfnumber"); $archivetrflistnosign = new WA_MySQLi_RS("archivetrflistnosign", $cmctrfdb, 0); $archivetrflistnosign->setQuery("SELECT MAX(revtrf) as max_revtrf FROM `trf-details` WHERE `trf-details`.trfnumber='$trfnosign'"); $archivetrflistnosign->execute(); $maxrevtrf = $archivetrflistnosign->getColumnVal("max_revtrf"); $currentrevtrf = $archivetrflist->getColumnVal("revtrf"); $current_trfnumber = $archivetrflist->getColumnVal("trfnumber"); $current_revtrf = $archivetrflist->getColumnVal("revtrf"); // Check if this is a new TRF number if ($last_trfnumber !== $current_trfnumber) { $last_trfnumber = $current_trfnumber; $last_revtrf = $current_revtrf; } $wa_startindex = $archivetrflist->Index; $idcertfortd = $archivetrflist->getColumnVal("idcertification") ?> moveNext(); } $archivetrflist->moveFirst(); //return RS to first record unset($wa_startindex); unset($wa_repeatcount); ?>
TRF N. REV Signed On Description Cert Type Article type Insert by PDF1 PDF2 ZIP ACTION
getColumnVal("trfnumber")); ?> getColumnVal("revtrf")) > 0) { ?>RgetColumnVal("revtrf"); } ?> getColumnVal("signedon")); ?> getColumnVal("sample_description")); ?> getColumnVal("name_certification")); ?> getColumnVal($nameField)); ?> getColumnVal("email")); ?> " target="_blank"> getColumnVal("pdffilename2"))) { ?>" target="_blank"> getColumnVal("zipname"))) { ?>" target="_blank"> hasRole('Admin')) || (Auth::user()->hasRole('CustomerService')) || (Auth::user()->hasRole('Superuser')) || (Auth::user()->hasRole('Certification')) || (Auth::user()->id == 178)) : ?> getColumnVal('idtrfdetails'); $ntrfdetailschk = $archivetrflist->getColumnVal('trfnumber'); $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connessione fallita: " . $conn->connect_error); } $query = "SELECT COUNT(*) AS count FROM data_td WHERE idtrf = ?"; $stmt = $conn->prepare($query); if ($stmt === false) { die("Errore nella preparazione della query: " . $conn->error); } $stmt->bind_param("i", $idtrfdetailschk); $stmt->execute(); $result = $stmt->get_result(); $rowcheck = $result->fetch_assoc(); if ($rowcheck['count'] < 1) { $buttonColor = '#ff9800'; $onClick = "Swal.fire({ title: 'Sei sicuro di voler creare il Fascicolo Tecnico per il TRF N. " . $ntrfdetailschk . "?', icon: 'warning', showCancelButton: true, confirmButtonColor: '#3085d6', cancelButtonColor: '#d33', confirmButtonText: 'Sì, procedi!', cancelButtonText: 'No, chiudi!' }).then((result) => { if (result.isConfirmed) { window.location.href='techdossier_start.php?idtrftd=" . $idtrfdetailschk . "'; } });"; } else { $buttonColor = '#4CAF50'; $onClick = "window.location.href='archivetd.php';"; } $stmt->close(); $conn->close(); ?>