430 lines
15 KiB
PHP
430 lines
15 KiB
PHP
<?php
|
|
include('include/headscript.php'); ?>
|
|
<?php
|
|
// pickup the get variable
|
|
if (isset($_GET["idtrf"])) {
|
|
$idtrf = $_GET["idtrf"];
|
|
}
|
|
if (isset($_POST["idtrf"])) {
|
|
$idtrf = $_POST["idtrf"];
|
|
}
|
|
|
|
//include('include/alertcheckquery.php');
|
|
|
|
if (isset($_POST["virusprot"])) {
|
|
$virusprot = $_POST["virusprot"];
|
|
} else {
|
|
$virusprot = "";
|
|
}
|
|
if (isset($_POST["addinfo"])) {
|
|
$addinfo = $_POST["addinfo"];
|
|
} else {
|
|
$addinfo = "";
|
|
}
|
|
if (isset($_POST["slipping"])) {
|
|
$slipping = $_POST["slipping"];
|
|
} else {
|
|
$slipping = "";
|
|
}
|
|
if (isset($_POST["orthopedic"])) {
|
|
$orthopedic = $_POST["orthopedic"];
|
|
} else {
|
|
$orthopedic = "";
|
|
}
|
|
if (isset($_POST["orthopedicmod"])) {
|
|
$orthopedicmod = $_POST["orthopedicmod"];
|
|
} else {
|
|
$orthopedicmod = "";
|
|
}
|
|
if (isset($_POST["autoclavable"])) {
|
|
$autoclavable = $_POST["autoclavable"];
|
|
} else {
|
|
$autoclavable = "";
|
|
}
|
|
if (isset($_POST["esd"])) {
|
|
$esd = $_POST["esd"];
|
|
} else {
|
|
$esd = "";
|
|
}
|
|
if (isset($_POST["ukcacert"])) {
|
|
$ukcacert = $_POST["ukcacert"];
|
|
} else {
|
|
$ukcacert = "";
|
|
}
|
|
if (isset($_POST["addreq"])) {
|
|
$addreq = $_POST["addreq"];
|
|
}
|
|
if (isset($_POST["addreqform"])) {
|
|
$addreqform = $_POST["addreqform"];
|
|
} else {
|
|
$addreqform = "";
|
|
}
|
|
if (isset($_POST["codestep"])) {
|
|
$code = "5";
|
|
|
|
$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);
|
|
}
|
|
?>
|
|
<?php
|
|
$conn = mysqli_connect($hostname_cmctrfdb, $username_cmctrfdb, $password_cmctrfdb, $database_cmctrfdb);
|
|
if (!$conn) {
|
|
die("Connessione al database fallita: " . mysqli_connect_error());
|
|
}
|
|
|
|
// Controllo dei campi nulli
|
|
|
|
$sql = "SELECT COUNT(*) AS num_rows FROM trfstandards WHERE idtrfdetails = $idtrf AND (idprotectioncategory IS NULL OR iddpicategory IS NULL)";
|
|
$resultcat = mysqli_query($conn, $sql);
|
|
// Controllo degli errori
|
|
if (!$resultcat) {
|
|
die("Errore nella query: " . mysqli_error($conn));
|
|
}
|
|
/*$row = mysqli_fetch_assoc($resultcat);
|
|
if ($row['num_rows'] > 0) {
|
|
// Campi nulli trovati, torna alla pagina standardstep.php e mostra il messaggio di errore
|
|
header("Location: standardstep.php?idtrf=$idtrf&error=tuttiicampidevonoesserericompilati");
|
|
exit;
|
|
}*/
|
|
?>
|
|
<?php
|
|
|
|
$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");
|
|
$idstandards = $trfnumberfinal->getColumnVal("idstandards");
|
|
$idarticletype = $trfnumberfinal->getColumnVal("idarticletype");
|
|
?>
|
|
<?php
|
|
$standardlistsel = new WA_MySQLi_RS("standardlistsel", $cmctrfdb, 0);
|
|
$standardlistsel->setQuery("SELECT * FROM trfstandards WHERE trfstandards.idtrfdetails='$idtrf'");
|
|
$standardlistsel->execute();
|
|
?>
|
|
<?php
|
|
|
|
$arraystd = array(); ?>
|
|
<?php
|
|
$wa_startindex = 0;
|
|
while (!$standardlistsel->atEnd()) {
|
|
$wa_startindex = $standardlistsel->Index;
|
|
?>
|
|
<?php
|
|
$idstandards = $standardlistsel->getColumnVal("idstandards");
|
|
$arraystd[] = $idstandards;
|
|
|
|
?>
|
|
|
|
<?php
|
|
$standardlistsel->moveNext();
|
|
}
|
|
$standardlistsel->moveFirst(); //return RS to first record
|
|
unset($wa_startindex);
|
|
unset($wa_repeatcount);
|
|
$array2std = implode("','", $arraystd);
|
|
$array3std = "'" . $array2std . "'";
|
|
?>
|
|
|
|
|
|
<?php $idcert = $trfnumberfinal->getColumnVal("idcertification") ?>
|
|
<?php
|
|
$certname = new WA_MySQLi_RS("certname", $cmctrfdb, 1);
|
|
$certname->setQuery("SELECT * FROM certificationtype WHERE certificationtype.idcertificationtype='$idcert'");
|
|
$certname->execute(); ?>
|
|
<?php //complete list add req
|
|
//$addreqlist = new WA_MySQLi_RS("addreqlist",$cmctrfdb,0);
|
|
//$addreqlist->setQuery("SELECT * FROM additionalrequirements WHERE additionalrequirements.idarticletype='$idarticletype' ORDER BY additionalrequirements.name_additionalrequirements");
|
|
//$addreqlist->execute();
|
|
?>
|
|
|
|
<?php // specific list of add req for std
|
|
// Determine the column to select based on the session variable
|
|
$additionalRequirementsField = ($_SESSION['langselect'] == 'en') ? 'name_additionalrequirements_en' : 'name_additionalrequirements_it';
|
|
|
|
// Specific list of add req for std
|
|
$addreqlist = new WA_MySQLi_RS("addreqlist", $cmctrfdb, 0);
|
|
$addreqlist->setQuery("SELECT DISTINCT stdreqlist.idadditionalrequirements, additionalrequirements." . $additionalRequirementsField . " FROM stdreqlist LEFT JOIN additionalrequirements ON stdreqlist.idadditionalrequirements=additionalrequirements.idadditionalrequirements WHERE stdreqlist.idstandards IN ($array3std)");
|
|
$addreqlist->execute();
|
|
|
|
?>
|
|
<?php
|
|
|
|
if ($addinfo == "Y") {
|
|
$UpdateQuery = new WA_MySQLi_Query($cmctrfdb);
|
|
$UpdateQuery->Action = "update";
|
|
$UpdateQuery->Table = "`trf-details`";
|
|
$UpdateQuery->bindColumn("virusprotection", "s", "$virusprot", "WA_DEFAULT");
|
|
$UpdateQuery->bindColumn("shoesorthopedic", "s", "$orthopedic", "WA_DEFAULT");
|
|
$UpdateQuery->bindColumn("shoesorthopedicmod", "s", "$orthopedicmod", "WA_DEFAULT");
|
|
$UpdateQuery->bindColumn("autoclavable", "s", "$autoclavable", "WA_DEFAULT");
|
|
$UpdateQuery->bindColumn("esd", "s", "$esd", "WA_DEFAULT");
|
|
$UpdateQuery->bindColumn("slipping", "s", "$slipping", "WA_DEFAULT");
|
|
$UpdateQuery->addFilter("idtrfdetails", "=", "i", "" . ($idtrf) . "");
|
|
$UpdateQuery->execute();
|
|
$UpdateGoTo = "";
|
|
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo ? rel2abs($UpdateGoTo, dirname(__FILE__)) : "";
|
|
$UpdateQuery->redirect($UpdateGoTo);
|
|
}
|
|
?>
|
|
<?php
|
|
if ($addreqform == "Y") {
|
|
|
|
|
|
$addreqcheck = new WA_MySQLi_RS("addreqcheck", $cmctrfdb, 1);
|
|
$addreqcheck->setQuery("SELECT * FROM trfaddrequirements WHERE trfaddrequirements.idtrf='$idtrf' AND trfaddrequirements.idadditionalrequirements='$addreq'");
|
|
$addreqcheck->execute();
|
|
if (empty($addreqcheck->getColumnVal("idtrfaddrequirements"))) {
|
|
|
|
|
|
$InsertQuery = new WA_MySQLi_Query($cmctrfdb);
|
|
$InsertQuery->Action = "insert";
|
|
$InsertQuery->Table = "trfaddrequirements";
|
|
$InsertQuery->bindColumn("idtrf", "i", "$idtrf", "WA_DEFAULT");
|
|
$InsertQuery->bindColumn("idadditionalrequirements", "i", "$addreq", "WA_DEFAULT");
|
|
$InsertQuery->saveInSession("");
|
|
$InsertQuery->execute();
|
|
$InsertGoTo = "";
|
|
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo ? rel2abs($InsertGoTo, dirname(__FILE__)) : "";
|
|
$InsertQuery->redirect($InsertGoTo);
|
|
}
|
|
}
|
|
?>
|
|
<?php
|
|
$addreqselectedlist = new WA_MySQLi_RS("addreqselectedlist", $cmctrfdb, 0);
|
|
$addreqselectedlist->setQuery("SELECT * FROM trfaddrequirements LEFT JOIN additionalrequirements ON trfaddrequirements.idadditionalrequirements=additionalrequirements.idadditionalrequirements WHERE trfaddrequirements.idtrf='$idtrf'");
|
|
$addreqselectedlist->execute(); ?>
|
|
|
|
<!DOCTYPE html>
|
|
<html lang="en">
|
|
|
|
<head>
|
|
<meta charset="utf-8" />
|
|
<title><?php echo $titlepage; ?> </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);"><?php echo $titlepage; ?></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">
|
|
<div class="card">
|
|
<div class="card-body">
|
|
<div class="media">
|
|
|
|
<?php include('include/appform.php'); ?>
|
|
</div><!--end media-->
|
|
|
|
</div><!--end card-body-->
|
|
</div><!--end card-->
|
|
|
|
<div class="progress mb-4">
|
|
<div class="progress-bar" role="progressbar" style="width: 70%;" aria-valuenow="70" aria-valuemin="0" aria-valuemax="100">70%</div>
|
|
</div>
|
|
<!-- card for additional info gloves -->
|
|
|
|
<div class="card">
|
|
<div class="card-body">
|
|
<h4 class="mt-0 header-title"><?php echo $additionalreqtitle; ?></h4>
|
|
<p class="text-muted mb-3"><?php echo $additionalreqtitle_help; ?></p>
|
|
<form class="form-parsley" action="" method="post" name="myForm">
|
|
<div class="form-group row">
|
|
<?php // var for language translation table name and help
|
|
$colvarname = $addreqlist->getColumnVal("name_additionalrequirements");
|
|
$varnamelang = $colvarname . $lang;
|
|
$varhelplang = "additionalrequirements_" . $lang;
|
|
?>
|
|
<div class="col-sm-5">
|
|
<select class="form-control" id="addreq" name="addreq">
|
|
<option value=""><?php echo $pleaseselect; ?></option>
|
|
<?php
|
|
while (!$addreqlist->atEnd()) { //dyn select
|
|
?><?php
|
|
// Assuming the session_start() has been called earlier in the PHP code to start the session.
|
|
$nameField = ($_SESSION['langselect'] == 'en') ? "name_additionalrequirements_en" : "name_additionalrequirements_it";
|
|
?>
|
|
|
|
<option value="<?php echo ($addreqlist->getColumnVal("idadditionalrequirements")); ?>">
|
|
<?php echo ($addreqlist->getColumnVal($nameField)); ?>
|
|
</option> <?php
|
|
$addreqlist->moveNext();
|
|
} //dyn select
|
|
$addreqlist->moveFirst();
|
|
?>
|
|
</select>
|
|
</div>
|
|
</div>
|
|
|
|
|
|
|
|
|
|
<input type="hidden" name="addreqform" id="addreqform" value="Y">
|
|
<input type="hidden" name="idtrf" id="idtrf" value="<?php echo ($trfnumberfinal->getColumnVal("idtrfdetails")); ?>">
|
|
|
|
<br><br>
|
|
<input type="button" onclick="formSubmit()" class="btn btn-gradient-success waves-effect waves-light" value="<?php echo $addtitle; ?>">
|
|
|
|
</div>
|
|
</form>
|
|
|
|
</div><!--end card-body-->
|
|
|
|
<!-- card for show requirements -->
|
|
<div class="card">
|
|
<div class="card-body">
|
|
<h4 class="mt-0 header-title"><?php echo $additionalreqtitleselected; ?></h4>
|
|
<p class="text-muted mb-3"><?php echo $additionalreqtitleselected_help; ?></p>
|
|
|
|
|
|
<table class="table table-striped mb-0">
|
|
<thead>
|
|
<tr>
|
|
<th><?php echo $addreqtitle; ?></th>
|
|
|
|
<th><?php echo $action; ?></th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
$wa_startindex = 0;
|
|
while (!$addreqselectedlist->atEnd()) {
|
|
$wa_startindex = $addreqselectedlist->Index;
|
|
?>
|
|
<tr>
|
|
<td>
|
|
<?php
|
|
// Assuming session_start() has already been called.
|
|
$nameField = ($_SESSION['langselect'] == 'en') ? 'name_additionalrequirements_en' : 'name_additionalrequirements_it';
|
|
echo ($addreqselectedlist->getColumnVal($nameField));
|
|
?>
|
|
</td>
|
|
<td>
|
|
|
|
<a href="deleteaddreq.php?idaddreq=<?php echo ($addreqselectedlist->getColumnVal("idtrfaddrequirements")); ?>&idtrf=<?php echo $idtrf; ?>"><i class="fas fa-trash-alt text-danger font-16"></i></a>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
$addreqselectedlist->moveNext();
|
|
}
|
|
$addreqselectedlist->moveFirst(); //return RS to first record
|
|
unset($wa_startindex);
|
|
unset($wa_repeatcount);
|
|
?>
|
|
|
|
|
|
</tbody>
|
|
</table>
|
|
|
|
<?php include('include/chemicalsquerycheck.php'); ?>
|
|
<?php if (!empty($chemicalstep)) { ?>
|
|
<a href="chemicalagent.php?idtrf=<?php echo $idtrf; ?>&codestep=5"><button type="button" class="btn btn-success waves-effect waves-light"><?php echo $nextsteptitle; ?></button> </a>
|
|
<?php } else { ?>
|
|
<a href="identificationparts.php?idtrf=<?php echo $idtrf; ?>&codestep=6"><button type="button" class="btn btn-success waves-effect waves-light"><?php echo $nextsteptitle; ?></button> </a>
|
|
<?php } ?>
|
|
<button type="button" class="btn btn-dark waves-effect waves-light" onclick="history.back()"><?php echo $backstep; ?></button>
|
|
</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>
|