

<?php

 include('include/headscript.php'); ?>



<?php

   // pickup the get variable

   if (isset($_GET["idstandards"])) {

       $idstandards=$_GET["idstandards"];

   }

   if (isset($_POST["idstandards"])) {

       $idstandards=$_POST["idstandards"];

   }

   



?>

<?php

if (isset($_POST["formnameedit"])) {

	$idreqcheck=$_POST["reqadd"];?>

<?php

$reqcheck = new WA_MySQLi_RS("reqcheck",$cmctrfdb,1);

$reqcheck->setQuery("SELECT * FROM stdreqlist WHERE stdreqlist.idadditionalrequirements='$idreqcheck'  AND stdreqlist.idstandards='$idstandards'");

$reqcheck->execute();

?>

<?php

	

	if (empty($reqcheck->getColumnVal("idstdreqlist"))) {

	

  $InsertQuery = new WA_MySQLi_Query($cmctrfdb);

  $InsertQuery->Action = "insert";

  $InsertQuery->Table = "stdreqlist";

  $InsertQuery->bindColumn("idstandards", "i", "$idstandards", "WA_DEFAULT");

  $InsertQuery->bindColumn("idadditionalrequirements", "i", "".((isset($_POST["reqadd"]))?$_POST["reqadd"]:"")  ."", "WA_DEFAULT");

  $InsertQuery->saveInSession("");

  $InsertQuery->execute();

  $InsertGoTo = "";

  if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";

  $InsertQuery->redirect($InsertGoTo);

}}

?>

<?php

$standarddetail = new WA_MySQLi_RS("standarddetail",$cmctrfdb,0);

$standarddetail->setQuery("SELECT * FROM standards WHERE standards.idstandards='$idstandards'");

$standarddetail->execute();?>

<?php

$addreqlist = new WA_MySQLi_RS("addreqlist",$cmctrfdb,0);

$addreqlist->setQuery("SELECT * FROM additionalrequirements ORDER BY additionalrequirements.name_additionalrequirements");

$addreqlist->execute();

?>

<?php

$selectaddreqstd = new WA_MySQLi_RS("selectaddreqstd",$cmctrfdb,0);

$selectaddreqstd->setQuery("SELECT * FROM stdreqlist LEFT JOIN standards ON stdreqlist.idstandards=standards.idstandards LEFT JOIN additionalrequirements ON stdreqlist.idadditionalrequirements=additionalrequirements.idadditionalrequirements WHERE stdreqlist.idstandards='$idstandards' ");

$selectaddreqstd->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">Standards: <?php echo($standarddetail->getColumnVal("standardcode")); ?> - <?php echo($standarddetail->getColumnVal("standardname")); ?></h4>

                                <p class="text-muted mb-3">Aggiungi le categorie di DPI per questo standard</p> 

                             

								  <div class="table-responsive">

                                        <table class="table table-bordered mb-0 table-centered">

                                            <thead>

                                            <tr>

                                                <th>ADD REQ</th>

                                                <th>Action</th>

                                            </tr>

                                            </thead>

                                            <tbody>

                                              <?php

$wa_startindex = 0;

while(!$selectaddreqstd->atEnd()) {

  $wa_startindex = $selectaddreqstd->Index;

?>

  <tr>

    <td><?php echo($selectaddreqstd->getColumnVal("name_additionalrequirements_it")); ?></td>

    

    <td>                                                       

      

      <a href="deleteaddreqlist.php?idstandards=<?php echo $idstandards; ?>&idstdreqlist=<?php echo($selectaddreqstd->getColumnVal("idstdreqlist")); ?>"><i class="fas fa-trash-alt text-danger font-16"></i></a>

    </td>

  </tr>

  <?php

  $selectaddreqstd->moveNext();

}

$selectaddreqstd->moveFirst(); //return RS to first record

unset($wa_startindex);

unset($wa_repeatcount);

?>

                                          </tbody>

                                        </table><!--end /table-->

                                </div>

								  

									   

								

                              </div><!--end card-body-->

								

								

							

							

                      </div><!--end card-->

                       

					<div class="card">

                              <div class="card-body">

                                    <h4 class="mt-0 header-title">Standards: <?php echo($standarddetail->getColumnVal("standardcode")); ?> - <?php echo($standarddetail->getColumnVal("standardname")); ?></h4>

                                <p class="text-muted mb-3">Aggiungi i requisiti addizionali per questo standard</p> 

                              <form class="was-validated" action="" method="post" name="myForm">

					<div class="form-group row">

                                                <label class="col-sm-2 col-form-label text-right">Select</label>

                                                <div class="col-sm-10">

                                                    <select class="form-control" name="reqadd" id="reqadd">

                                                      <option value="">Seleziona</option>

                                                      <?php

while(!$addreqlist->atEnd()) { //dyn select

?>

                                                      <option value="<?php echo($addreqlist->getColumnVal("idadditionalrequirements")); ?>"><?php echo($addreqlist->getColumnVal("name_additionalrequirements_it")); ?></option>

                                                      <?php

  $addreqlist->moveNext();

} //dyn select

$addreqlist->moveFirst();

?>

                                                  </select>

                                                </div>

                                            </div>



					<input type="hidden" name="idstandards" id="idstandards" value="<?php echo $idstandards; ?>">

					<input type="hidden" name="formnameedit" id="formnameedit" value="dpieditlist">

					<input type="button" onclick="formSubmit()" class="btn btn-gradient-success waves-effect waves-light" value="Aggiungi"><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>