setQuery("SELECT * FROM `trf-details` ORDER BY `trf-details`.trfnumber DESC LIMIT 1"); $lasttrfnumber->execute();?> getColumnVal("trfnumber"); $nextnumber=$lastnumber+1; ?> setQuery("SELECT * FROM `trf-details` WHERE `trf-details`.tempcode='$tempcode'"); $tempcodesearch->execute(); } ?> getColumnVal("idtrfdetails"))) { $InsertQuery = new WA_MySQLi_Query($cmctrfdb); $InsertQuery->Action = "insert"; $InsertQuery->Table = "`trf-details`"; $InsertQuery->bindColumn("trfnumber", "i", "$nextnumber", "WA_DEFAULT"); $InsertQuery->bindColumn("idcompany", "i", "$idcompany", "WA_DEFAULT"); $InsertQuery->bindColumn("iduser", "i", "$iduserlogin", "WA_DEFAULT"); $InsertQuery->bindColumn("idcertification", "i", "$certtype", "WA_DEFAULT"); $InsertQuery->bindColumn("previousreportnumber", "s", "$previousrepnumber", "WA_DEFAULT"); $InsertQuery->bindColumn("tempcode", "s", "$tempcode", "WA_DEFAULT"); $InsertQuery->bindColumn("notificatedorganismname", "s", "$notificatedorganismname", "WA_DEFAULT"); $InsertQuery->saveInSession(""); $InsertQuery->execute(); $InsertGoTo = ""; $InsertQuery->redirect($InsertGoTo); $tempcodesearch2 = new WA_MySQLi_RS("tempcodesearch",$cmctrfdb,1); $tempcodesearch2->setQuery("SELECT * FROM `trf-details` WHERE `trf-details`.tempcode='$tempcode'"); $tempcodesearch2->execute(); $idtrf=$tempcodesearch2->getColumnVal("idtrfdetails"); }} ?> Action = "insert"; $InsertQuery->Table = "contacts"; $InsertQuery->bindColumn("kindofcontacts", "s", "$kindofcontacts", "WA_DEFAULT"); $InsertQuery->bindColumn("companyname", "s", "$companyname", "WA_DEFAULT"); $InsertQuery->bindColumn("piva", "s", "$piva", "WA_DEFAULT"); $InsertQuery->bindColumn("address", "s", "$companyaddress", "WA_DEFAULT"); $InsertQuery->bindColumn("city", "s", "$city", "WA_DEFAULT"); $InsertQuery->bindColumn("cap", "s", "$cap", "WA_DEFAULT"); $InsertQuery->bindColumn("country", "s", "$country", "WA_DEFAULT"); $InsertQuery->bindColumn("telephone", "s", "$telephone", "WA_DEFAULT"); $InsertQuery->bindColumn("email", "s", "$email", "WA_DEFAULT"); $InsertQuery->bindColumn("contactname", "s", "$contactname", "WA_DEFAULT"); $InsertQuery->bindColumn("contactsurname", "s", "$contactsurname", "WA_DEFAULT"); $InsertQuery->bindColumn("tempcode", "s", "$tempcode", "WA_DEFAULT"); $InsertQuery->saveInSession(""); $InsertQuery->execute(); $InsertGoTo = ""; if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):""; $InsertQuery->redirect($InsertGoTo); } ?> Action = "insert"; $InsertQuery->Table = "contacts"; $InsertQuery->bindColumn("kindofcontacts", "s", "$kindofcontacts", "WA_DEFAULT"); $InsertQuery->bindColumn("companyid", "s", "$idcompany", "WA_DEFAULT"); $InsertQuery->bindColumn("tempcode", "s", "$tempcode", "WA_DEFAULT"); $InsertQuery->saveInSession(""); $InsertQuery->execute(); $InsertGoTo = ""; if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):""; $InsertQuery->redirect($InsertGoTo); } ?> TRF CIMAC
  1. CIMAC TRF
  2. Starter



5%
5%
20%
setQuery("SELECT * FROM certificationtype WHERE certificationtype.idcertificationtype='$idcertificate'"); $certtype->execute(); ?>
20%

.