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->bindColumn("active", "s", "" . ((isset($_POST["active"])) ? $_POST["active"] : "") . "", "WA_DEFAULT"); $UpdateQuery->addFilter("idstandards", "=", "i", "" . ($idstandards) . ""); $UpdateQuery->execute(); $UpdateGoTo = ""; if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo ? rel2abs($UpdateGoTo, dirname(__FILE__)) : ""; $UpdateQuery->redirect($UpdateGoTo); } ?> Action = "insert"; $InsertQuery->Table = "standards"; $InsertQuery->bindColumn("fmidstandards", "i", "" . ((isset($_POST["fmcode"])) ? $_POST["fmcode"] : "") . "", "WA_DEFAULT"); $InsertQuery->bindColumn("standardname", "s", "" . ((isset($_POST["itastdname"])) ? $_POST["itastdname"] : "") . "", "WA_DEFAULT"); $InsertQuery->bindColumn("standardname_eng", "s", "" . ((isset($_POST["engstdname"])) ? $_POST["engstdname"] : "") . "", "WA_DEFAULT"); $InsertQuery->bindColumn("standardcode", "s", "" . ((isset($_POST["standardcode"])) ? $_POST["standardcode"] : "") . "", "WA_DEFAULT"); $InsertQuery->bindColumn("idarticletype", "i", "" . ((isset($_POST["idarticletype"])) ? $_POST["idarticletype"] : "") . "", "WA_DEFAULT"); $InsertQuery->bindColumn("idarticlecharacteristic", "i", "" . ((isset($_POST["articlecharact"])) ? $_POST["articlecharact"] : "") . "", "WA_DEFAULT"); $InsertQuery->bindColumn("virusset", "s", "" . ((isset($_POST["virusprotection"])) ? $_POST["virusprotection"] : "") . "", "WA_DEFAULT"); $InsertQuery->bindColumn("chemicalsset", "s", "" . ((isset($_POST["chemicalagent"])) ? $_POST["chemicalagent"] : "") . "", "WA_DEFAULT"); $InsertQuery->saveInSession(""); $InsertQuery->execute(); $InsertGoTo = ""; if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo ? rel2abs($InsertGoTo, dirname(__FILE__)) : ""; $InsertQuery->redirect($InsertGoTo); } ?> setQuery("SELECT * FROM standards LEFT JOIN article_type ON article_type.idarticletype=standards.idarticletype LEFT JOIN article_characteristic ON article_characteristic.idarticlecharacteristic=standards.idarticlecharacteristic LEFT JOIN dpicategory ON dpicategory.iddpicategory=standards.iddpicategory ORDER BY standards.idarticletype, standards.standardcode"); $standardlist->execute(); ?> <?php echo $titlepage; ?>
  1. TRF
  2. Starter

Gestione Standards

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



atEnd()) { $wa_startindex = $standardlist->Index; ?> moveNext(); } $standardlist->moveFirst(); //return RS to first record unset($wa_startindex); unset($wa_repeatcount); ?>
Tipo Articolo Standard FM Code Caratteristiche Virus Chemical Active
getColumnVal("name_articletype")); ?> getColumnVal("standardcode")); ?> getColumnVal("fmidstandards")); ?> getColumnVal("name_articlecharacteristic")); ?> getColumnVal("virusset") == "Y") { ?>
getColumnVal("chemicalsset") == "Y") { ?>
getColumnVal("active")); ?> " class="mr-2"> ">PC ">DC ">REQ