insert('contacts', [
'kindofcontacts' => $kindofcontacts,
'companyname' => $companyname,
'piva' => $piva,
'address' => $companyaddress,
'city' => $city,
'cap' => $cap,
'country' => $country,
'telephone' => $telephone,
'email' => $email,
'contactname' => $contactname,
'contactsurname' => $contactsurname,
'tempcode' => $tempcode,
]);
}
// --- INSERT contatto (solo "me stesso" / la mia company) -------------
if (isset($formnameme)) {
$db->insert('contacts', [
'kindofcontacts' => $kindofcontacts,
'companyid' => $idcompany,
'tempcode' => $tempcode,
]);
}
// --- Liste per le tendine (usate nel blocco M18A) --------------------
$idproteccategorylistRecord = [];
foreach ($db->select("SELECT idprotectioncategory, name_protectioncategory FROM protectioncategory") as $r) {
$idproteccategorylistRecord[$r['idprotectioncategory']] = $r['name_protectioncategory'];
}
$idprotectioncategoryJson = json_encode($idproteccategorylistRecord);
$iddpicategorylistRecord = [];
foreach ($db->select("SELECT iddpicategory, value_dpicategory FROM dpicategory") as $r) {
$iddpicategorylistRecord[$r['iddpicategory']] = $r['value_dpicategory'];
}
$iddpicategoryJson = json_encode($iddpicategorylistRecord);
// --- Dati del tipo certificato (una sola volta, se richiesto) --------
// Prima erano 7 SELECT identiche ripetute in ogni blocco: qui la facciamo una volta.
$certtypeRow = null;
if (in_array($idcertificate, [1, 2, 3, 4, 5, 6, 7], true)) {
$certtypeRow = $db->selectOne(
"SELECT * FROM certificationtype WHERE idcertificationtype = ?",
[$idcertificate]
);
}
$certtypeId = $certtypeRow['idcertificationtype'] ?? '';
?>
<?php echo $titlepage; ?>