ppeasy/public/edit-protcat.php

200 lines
7.9 KiB
PHP

<?php
include('include/headscript.php'); ?>
<?php
// pickup the get variable
if (isset($_GET["idprotectioncategory"])) {
$idprotectioncategory=$_GET["idprotectioncategory"];
}
?>
<?php
$articletypelist = new WA_MySQLi_RS("articletypelist",$cmctrfdb,0);
$articletypelist->setQuery("SELECT * FROM article_type ORDER BY article_type.name_articletype");
$articletypelist->execute();?>
<?php
$protcatrecord = new WA_MySQLi_RS("protcatrecord",$cmctrfdb,1);
$protcatrecord->setQuery("SELECT protectioncategory.name_protectioncategory, protectioncategory.name_protectioncategory_en, article_type.name_articletype, protectioncategory.idarticletype AS arttypeid FROM protectioncategory LEFT JOIN article_type ON article_type.idarticletype=protectioncategory.idarticletype WHERE protectioncategory.idprotectioncategory='$idprotectioncategory'");
$protcatrecord->execute();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>TRF CIMAC </title>
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta content="CIMAC TRF Portal" name="description" />
<meta content="" name="author" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<!-- App favicon -->
<link rel="shortcut icon" href="../images/favicon.ico">
<!--Form Wizard-->
<link href="../plugins/jquery-steps/jquery.steps.css" rel="stylesheet" type="text/css">
<!-- App css -->
<link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/jquery-ui.min.css" rel="stylesheet">
<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/metisMenu.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/app.min.css" rel="stylesheet" type="text/css" />
<!-- submit form with button -->
<script>
function formSubmit() {
document.forms["myForm"].submit();
}
</script>
</head>
<body>
<!-- Top Bar Start -->
<?php include('include/topbar.php'); ?>
<!-- Top Bar End -->
<!-- Left Sidenav -->
<?php include('include/leftsidenav.php'); ?>
<!-- end left-sidenav-->
<div class="page-wrapper">
<!-- Page Content-->
<div class="page-content">
<div class="container-fluid">
<!-- Page-Title -->
<div class="row">
<div class="col-sm-12">
<div class="page-title-box">
<div class="float-right">
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="javascript:void(0);">TRF</a></li>
<li class="breadcrumb-item active">Starter</li>
</ol>
</div>
<h4 class="page-title"><?php echo $titlewb; ?></h4>
</div><!--end page-title-box-->
</div><!--end col-->
</div>
<div class="row">
<div class="col-sm-12">
<!-- card for additional info gloves -->
<!--end card-body-->
<!-- card for show requirements -->
<div class="card">
<div class="card-body">
<h4 class="mt-0 header-title">EDIT PROTECTION CATEGORY</h4>
<form class="was-validated" action="admin-protcat.php" method="post" name="myForm">
<div class="form-group row">
<label for="standardcode" class="col-sm-2 col-form-label text-right">Nome PROTECTION CATEGORY ITA</label>
<div class="col-sm-10">
<input class="form-control" type="text" value="<?php echo($protcatrecord->getColumnVal("name_protectioncategory")); ?>" id="name_protectioncategory" name="name_protectioncategory">
</div>
</div>
<div class="form-group row">
<label for="itastdname" class="col-sm-2 col-form-label text-right">Nome PROTECTION CATEGORY ENG</label>
<div class="col-sm-10">
<input class="form-control" type="text" value="<?php echo($protcatrecord->getColumnVal("name_protectioncategory_en")); ?>" id="name_protectioncategory_en" name="name_protectioncategory_en">
</div>
</div>
<div class="form-group row">
<label class="col-sm-2 col-form-label text-right">Tipologia Articolo</label>
<div class="col-sm-10">
<select class="form-control" name="idarticletype" id="idarticletype">
<option value="" <?php if (!(strcmp("", ($protcatrecord->getColumnVal("arttypeid"))))) {echo "selected=\"selected\"";} ?>>Seleziona</option>
<?php
while(!$articletypelist->atEnd()) { //dyn select
?>
<option value="<?php echo($articletypelist->getColumnVal("idarticletype")); ?>"<?php if (!(strcmp($articletypelist->getColumnVal("idarticletype"), ($protcatrecord->getColumnVal("arttypeid"))))) {echo "selected=\"selected\"";} ?>><?php echo($articletypelist->getColumnVal("name_articletype")); ?></option>
<?php
$articletypelist->moveNext();
} //dyn select
$articletypelist->moveFirst();
?>
</select>
</div>
</div>
<br>
<input type="hidden" name="idprotectioncategory" id="idprotectioncategory" value="<?php echo $idprotectioncategory; ?>">
<input type="hidden" name="formnameedit" id="formnameedit" value="stdeditform">
<input type="button" onclick="formSubmit()" class="btn btn-gradient-success waves-effect waves-light" value="Aggiorna"><br>
</form>
</div><!--end card-body-->
</div><!--end card-->
</div><!--end col-->
</div>
<!-- end page title end breadcrumb -->
</div><!-- container -->
<!-- footer start -->
<?php include('include/footer.php'); ?>
</footer><!--end footer-->
</div>
<!-- end page content -->
</div>
<!-- end page-wrapper -->
<!-- jQuery -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.bundle.min.js"></script>
<script src="assets/js/metismenu.min.js"></script>
<script src="assets/js/waves.js"></script>
<script src="assets/js/feather.min.js"></script>
<script src="assets/js/jquery.slimscroll.min.js"></script>
<script src="assets/js/jquery-ui.min.js"></script>
<script src="../plugins/jquery-steps/jquery.steps.min.js"></script>
<script src="assets/pages/jquery.form-wizard.init.js"></script>
<!-- App js -->
<script src="assets/js/app.js"></script>
</body>
</html>