79 lines
3.9 KiB
PHP
79 lines
3.9 KiB
PHP
<?php
|
|
//logo
|
|
|
|
// parse general TRF data
|
|
$trfdetails = mysqli_query($cmctrfdb, "SELECT * FROM `trf-details` LEFT JOIN `article_type` ON `trf-details`.idarticletype=`article_type`.idarticletype LEFT JOIN modelarticle ON `trf-details`.model=modelarticle.idmodelarticle WHERE `trf-details`.idtrfdetails='$idtrf'");
|
|
$trfData = mysqli_fetch_assoc($trfdetails);
|
|
$idcertificate = $trfData['idcertification'];
|
|
$otherclient = $trfData['otherclient'];
|
|
|
|
// parse TD data
|
|
$tddetails = mysqli_query($cmctrfdb, "SELECT * FROM data_td WHERE data_td.iddata_td='$idtd'");
|
|
$tdData = mysqli_fetch_assoc($tddetails);
|
|
$idcertificate = $tdData['tdnumber'];
|
|
|
|
|
|
// parse Company data
|
|
$companyinfo = mysqli_query($cmctrfdb, "SELECT * FROM company WHERE company.idcompany='$idcompany'");
|
|
$companyinfoData = mysqli_fetch_assoc($companyinfo);
|
|
$_SESSION['companyname'] = $companyinfoData['companyname_company'];
|
|
|
|
$_SESSION['companyaddress'] = $companyinfoData['address_company'] . ',' . $companyinfoData['zip_company'] . '-' . $companyinfoData['city_company'] . '-' . $companyinfoData['country_company'];
|
|
$_SESSION['phonemail'] = $companyinfoData['telephone_company'] . '-' . $companyinfoData['email_company'];
|
|
|
|
// parse identification parts data
|
|
$identparts = mysqli_query($cmctrfdb, "SELECT * FROM `identificationparts` WHERE `identificationparts`.idtrfdetails='$idtrf'");
|
|
$identpartData = mysqli_fetch_assoc($identparts);
|
|
// parse fileattached data
|
|
$fileattach = mysqli_query($cmctrfdb, "SELECT * FROM `fileattached` WHERE `fileattached`.idtrfdetails='$idtrf'");
|
|
$fileattachData = mysqli_fetch_assoc($fileattach);
|
|
// parse standards data
|
|
$stdinfo = new WA_MySQLi_RS("stdinfo", $cmctrfdb, 0);
|
|
$stdinfo->setQuery("SELECT * FROM `trfstandards` LEFT JOIN `standards` ON `trfstandards`.idstandards=`standards`.idstandards LEFT JOIN protectioncategory ON `trfstandards`.idprotectioncategory=protectioncategory.idprotectioncategory LEFT JOIN dpicategory ON `trfstandards`.iddpicategory=dpicategory.iddpicategory WHERE `trfstandards`.idtrfdetails='$idtrf'");
|
|
$stdinfo->execute();
|
|
|
|
|
|
// parse add requirements data
|
|
$addreqlist = new WA_MySQLi_RS("addreqlist", $cmctrfdb, 0);
|
|
$addreqlist->setQuery("SELECT * FROM trfaddrequirements LEFT JOIN additionalrequirements ON trfaddrequirements.idadditionalrequirements=additionalrequirements.idadditionalrequirements WHERE trfaddrequirements.idtrf='$idtrf'");
|
|
$addreqlist->execute();
|
|
$totreq = $addreqlist->TotalRows;
|
|
// parse chemical agent data
|
|
$cheminfo = new WA_MySQLi_RS("cheminfo", $cmctrfdb, 0);
|
|
$cheminfo->setQuery("SELECT * FROM trfchemicalagent LEFT JOIN chemicalagent ON trfchemicalagent.idchemicalagent=chemicalagent.idchemicalagent WHERE trfchemicalagent.idtrf='$idtrf'");
|
|
$cheminfo->execute();
|
|
// parse certification revision
|
|
$certificationrevision = new WA_MySQLi_RS("certificationrevision", $cmctrfdb, 0);
|
|
$certificationrevision->setQuery("SELECT * FROM certificationtype WHERE certificationtype.idcertificationtype='$idcertificate'");
|
|
$certificationrevision->execute();
|
|
// parse identification parts
|
|
if ($idcertificate == 5 || $idcertificate == 6) {
|
|
$kindcont = 'audit';
|
|
// parse contacts data with variable kindofcontacts
|
|
//$contactsinfo = mysqli_query($cmctrfdb, "SELECT * FROM `contacts` WHERE `contacts`.idtrf='$idtrf' WHERE contacts.kindofcontacts='kindcont'");
|
|
//$contactsinfoData = mysqli_fetch_assoc($contactsinfo);
|
|
// parse audit dpi
|
|
//$identparts = mysqli_query($cmctrfdb, "SELECT * FROM auditdpi WHERE auditdpi.idtrfdetails='$idtrf'");
|
|
//$identpartData = mysqli_fetch_assoc($identparts);
|
|
}
|
|
?>
|
|
<?php
|
|
|
|
//vecchio script immagini
|
|
$appformn = $pdfrequestformn . " N." . $trfData['trfnumber'];
|
|
if (isset($trfData['photofilename'])) {
|
|
$image1 = "uploadimages/" . $trfData['photofilename'];
|
|
/* CHECK IF FILE TYPE IS JPEG */
|
|
$img_info = getimagesize($image1);
|
|
if ($img_info[2] <> IMG_JPEG) {
|
|
/* IF NOT JPEG, USE DEFAULT IMAGE INSTEAD*/
|
|
$image1 = "uploadimages/notav.jpg";
|
|
}
|
|
}
|
|
//echo $appformn;
|
|
|
|
|
|
|
|
|
|
|
|
?>
|