Action = "update";
$UpdateQuery->Table = "dpicategory";
$UpdateQuery->bindColumn("value_dpicategory", "s", "".((isset($_POST["value_dpicategory"]))?$_POST["value_dpicategory"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("value_dpicategory_en", "s", "".((isset($_POST["value_dpicategory_en"]))?$_POST["value_dpicategory_en"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("idarticletype", "i", "".((isset($_POST["idarticletype"]))?$_POST["idarticletype"]:"") ."", "WA_DEFAULT");
$UpdateQuery->addFilter("iddpicategory", "=", "i", "".($iddpicategory) ."");
$UpdateQuery->execute();
$UpdateGoTo = "";
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
$UpdateQuery->redirect($UpdateGoTo);
}
if (isset($formnameadd)) {
$InsertQuery = new WA_MySQLi_Query($cmctrfdb);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "dpicategory";
$InsertQuery->bindColumn("value_dpicategory", "s", "".((isset($_POST["value_dpicategory"]))?$_POST["value_dpicategory"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("value_dpicategory_en", "s", "".((isset($_POST["value_dpicategory_en"]))?$_POST["value_dpicategory_en"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("idarticletype", "i", "".((isset($_POST["idarticletype"]))?$_POST["idarticletype"]:"") ."", "WA_DEFAULT");
$InsertQuery->saveInSession("");
$InsertQuery->execute();
$InsertGoTo = "";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>
setQuery("SELECT * FROM dpicategory LEFT JOIN article_type ON article_type.idarticletype=dpicategory.idarticletype ORDER BY dpicategory.idarticletype");
$dpilist->execute();
?>
TRF CIMAC
Da questa pagina puoi gestire DPI Category da associare poi agli standard
| Nome Protection Category (ITA) |
Nome Protection Category (ENG) |
Tipo Articolo |
|
atEnd()) {
$wa_startindex = $dpilist->Index;
?>
| getColumnVal("value_dpicategory")); ?> |
getColumnVal("value_dpicategory_en")); ?> |
getColumnVal("name_articletype")); ?> |
" class="mr-2">
|
moveNext();
}
$dpilist->moveFirst(); //return RS to first record
unset($wa_startindex);
unset($wa_repeatcount);
?>