setQuery("SELECT * FROM standards WHERE standards.idstandards='$idstandards' ORDER BY standards.idarticletype, standards.standardcode"); $standarddetail->execute(); ?> setQuery("SELECT * FROM article_type ORDER BY article_type.name_articletype"); $articletypelist->execute(); ?> setQuery("SELECT * FROM article_characteristic ORDER BY article_characteristic.idarticletype, article_characteristic.name_articlecharacteristic"); $articlecharacteristiclist->execute(); ?> setQuery("SELECT * FROM dpicategory ORDER BY dpicategory.value_dpicategory"); $categorydpilist->execute(); ?> getColumnVal("idarticletype"); $articletypesel = new WA_MySQLi_RS("articletypesel", $cmctrfdb, 1); $articletypesel->setQuery("SELECT * FROM article_type WHERE article_type.idarticletype='$idarticletypen'"); $articletypesel->execute(); ?> getColumnVal("idarticlecharacteristic"); $artcharactcheck = new WA_MySQLi_RS("artcharactcheck", $cmctrfdb, 1); $artcharactcheck->setQuery("SELECT * FROM article_characteristic WHERE article_characteristic.idarticlecharacteristic='$idarticlecharacteristicn'"); $artcharactcheck->execute(); ?> getColumnVal("iddpicategory"); $dpicategorycheck = new WA_MySQLi_RS("dpicategorycheck", $cmctrfdb, 1); $dpicategorycheck->setQuery("SELECT * FROM dpicategory WHERE dpicategory.iddpicategory='$iddpicategoryn'"); $dpicategorycheck->execute(); ?> Action = "update"; $UpdateQuery->Table = "standards"; $UpdateQuery->bindColumn("fmidstandards", "i", "" . ((isset($_POST["fmcode"])) ? $_POST["fmcode"] : "") . "", "WA_DEFAULT"); $UpdateQuery->bindColumn("standardname", "s", "" . ((isset($_POST["itastdname"])) ? $_POST["itastdname"] : "") . "", "WA_DEFAULT"); $UpdateQuery->bindColumn("standardname_eng", "s", "" . ((isset($_POST["engstdname"])) ? $_POST["engstdname"] : "") . "", "WA_DEFAULT"); $UpdateQuery->bindColumn("standardcode", "s", "" . ((isset($_POST["standardcode"])) ? $_POST["standardcode"] : "") . "", "WA_DEFAULT"); $UpdateQuery->bindColumn("idarticletype", "i", "" . ((isset($_POST["idarticletype"])) ? $_POST["idarticletype"] : "") . "", "WA_DEFAULT"); $UpdateQuery->bindColumn("idarticlecharacteristic", "i", "" . ((isset($_POST["articlecharact"])) ? $_POST["articlecharact"] : "") . "", "WA_DEFAULT"); $UpdateQuery->bindColumn("iddpicategory", "i", "" . ((isset($_POST["categorydpi"])) ? $_POST["categorydpi"] : "") . "", "WA_DEFAULT"); $UpdateQuery->bindColumn("virusset", "s", "" . ((isset($_POST["virusprotection"])) ? $_POST["virusprotection"] : "") . "", "WA_DEFAULT"); $UpdateQuery->bindColumn("chemicalsset", "s", "" . ((isset($_POST["chemicalagent"])) ? $_POST["chemicalagent"] : "") . "", "WA_DEFAULT"); $UpdateQuery->addFilter("idstandards", "=", "i", "" . ($idstandards) . ""); $UpdateQuery->execute(); $UpdateGoTo = ""; if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo ? rel2abs($UpdateGoTo, dirname(__FILE__)) : ""; $UpdateQuery->redirect($UpdateGoTo); } ?> TRF CIMAC
  1. TRF
  2. Starter

Gestione Standards

Da questa pagina puoi gestire gli standards e tutti i dati correlati

" id="standardcode" name="standardcode">
" id="itastdname" name="itastdname">
" id="engstdname" name="engstdname">
" id="fmcode" name="fmcode">
getColumnVal("virusset")), "Y"))) { echo "checked=\"checked\""; } ?> type="checkbox" class="custom-control-input" id="virusprotection" name="virusprotection" value="Y" data-parsley-multiple="groups" data-parsley-mincheck="2">

getColumnVal("chemicalsset")), "Y"))) { echo "checked=\"checked\""; } ?> type="checkbox" class="custom-control-input" id="chemicalagent" name="chemicalagent" value="Y" data-parsley-multiple="groups" data-parsley-mincheck="2">