| getColumnVal("companyname")); ?> | getColumnVal("address")); ?> | getColumnVal("city")); ?> |
', '_blank', 'location=yes,height=500,width=850,scrollbars=yes,status=yes');">
fetchCountry(); ?> 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(); } ?> Action = "update"; $UpdateQuery->Table = "`trf-details`"; $UpdateQuery->bindColumn("previousreportnumber", "s", "$previousrepnumber", "WA_DEFAULT"); $UpdateQuery->bindColumn("notificatedorganismname", "s", "$notificatedorganismname", "WA_DEFAULT"); $UpdateQuery->addFilter("idtrfdetails", "=", "i", "".($idtrf) .""); $UpdateQuery->execute(); $UpdateGoTo = ""; if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):""; $UpdateQuery->redirect($UpdateGoTo); } ?> Action = "update"; $UpdateQuery->Table = "`trf-details`"; $UpdateQuery->bindColumn("previousreportnumber", "s", "$previousrepnumber", "WA_DEFAULT"); $UpdateQuery->bindColumn("revisionfor", "s", "$revwhy", "WA_DEFAULT"); $UpdateQuery->addFilter("idtrfdetails", "=", "i", "".($idtrf) .""); $UpdateQuery->execute(); $UpdateGoTo = ""; if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):""; $UpdateQuery->redirect($UpdateGoTo); } else { $UpdateQuery = new WA_MySQLi_Query($cmctrfdb); $UpdateQuery->Action = "update"; $UpdateQuery->Table = "`trf-details`"; $UpdateQuery->bindColumn("previousreportnumber", "s", "$previousrepnumber", "WA_DEFAULT"); $UpdateQuery->addFilter("idtrfdetails", "=", "i", "".($idtrf) .""); $UpdateQuery->execute(); $UpdateGoTo = ""; if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):""; $UpdateQuery->redirect($UpdateGoTo); } } ?> Action = "update"; $UpdateQuery->Table = "`trf-details`"; $UpdateQuery->bindColumn("previousreportnumber", "s", "$previousrepnumber", "WA_DEFAULT"); $UpdateQuery->bindColumn("toextend", "s", "$toextend", "WA_DEFAULT"); $UpdateQuery->addFilter("idtrfdetails", "=", "i", "".($idtrf) .""); $UpdateQuery->execute(); $UpdateGoTo = ""; if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):""; $UpdateQuery->redirect($UpdateGoTo); } ?> 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"); $code="1"; $InsertQuery = new WA_MySQLi_Query($cmctrfdb); $InsertQuery->Action = "insert"; $InsertQuery->Table = "wheretrfstep"; $InsertQuery->bindColumn("idtrf", "i", "$idtrf", "WA_DEFAULT"); $InsertQuery->bindColumn("code", "i", "$code", "WA_DEFAULT"); $InsertQuery->saveInSession(""); $InsertQuery->execute(); $InsertGoTo = ""; $InsertQuery->redirect($InsertGoTo); $code="2"; $InsertQuery = new WA_MySQLi_Query($cmctrfdb); $InsertQuery->Action = "insert"; $InsertQuery->Table = "wheretrfstep"; $InsertQuery->bindColumn("idtrf", "i", "$idtrf", "WA_DEFAULT"); $InsertQuery->bindColumn("code", "i", "$code", "WA_DEFAULT"); $InsertQuery->saveInSession(""); $InsertQuery->execute(); $InsertGoTo = ""; $InsertQuery->redirect($InsertGoTo); $UpdateQuery = new WA_MySQLi_Query($cmctrfdb); $UpdateQuery->Action = "update"; $UpdateQuery->Table = "contacts"; $UpdateQuery->bindColumn("idtrf", "i", "$idtrf", "WA_DEFAULT"); $UpdateQuery->addFilter("tempcode", "=", "s", "".($tempcode) .""); $UpdateQuery->execute(); $UpdateGoTo = ""; if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):""; $UpdateQuery->redirect($UpdateGoTo); //include('uploadfilecertificate.php'); }} ?> setQuery("SELECT * FROM `trf-details` WHERE `trf-details`.tempcode='$tempcode'"); $trfnumberfinal->execute(); $idtrf=$trfnumberfinal->getColumnVal("idtrfdetails"); $idcertn=$trfnumberfinal->getColumnVal("idcertification"); } else { $trfnumberfinal = new WA_MySQLi_RS("trfnumberfinal",$cmctrfdb,1); $trfnumberfinal->setQuery("SELECT * FROM `trf-details` WHERE `trf-details`.idtrfdetails='$idtrf'"); $trfnumberfinal->execute(); $idcertn=$trfnumberfinal->getColumnVal("idcertification"); } ?> setQuery("SELECT * FROM article_type ORDER BY article_type.name_articletype"); $typearticleselect->execute();?> setQuery("SELECT * FROM article_characteristic ORDER BY article_characteristic.name_articlecharacteristic"); $charactarticle->execute();?> getColumnVal("idcertification") ?> setQuery("SELECT * FROM certificationtype WHERE certificationtype.idcertificationtype='$idcert'"); $certname->execute();?> setQuery("SELECT * FROM modelarticle ORDER BY modelarticle.namemodelarticle"); $modelarticlelist->execute(); ?>
| getColumnVal("companyname")); ?> | getColumnVal("address")); ?> | getColumnVal("city")); ?> |