<?php require_once('../Connections/cmctrfdb.php'); ?>
<?php require_once('../webassist/mysqli/rsobj.php'); ?>
<?php
 include('include/headscript.php');
include('db-connect.php');
?>
<?php 
// pickup the get variable
// pickup the get variable
if (isset($_POST["idtrf"])) {
	$idtrf=$_POST["idtrf"]; }
if (isset($_GET["idtrf"])) {
	$idtrf=$_GET["idtrf"]; }
if (isset($_POST["photoname"])) {
	$photoname=$_POST["photoname"]; }
if (isset($_POST["description"])) {
	$description=$_POST["description"]; }
if (isset($_POST["model"])) {
	$model=$_POST["model"]; }
if (isset($_POST["rangemeasuremin"])) {
	$rangemeasuremin=$_POST["rangemeasuremin"]; }
if (isset($_POST["rangemeasuremax"])) {
	$rangemeasuremax=$_POST["rangemeasuremax"]; }
if (isset($_POST["registeredmark"])) {
	$registeredmark=$_POST["registeredmark"]; }
if (isset($_POST["articletype"])) {
	$articletype=$_POST["articletype"]; }
if (isset($_POST["articlecharacteristic"])) {
	$articlecharacteristic=$_POST["articlecharacteristic"]; }
if (isset($_POST["formupdtrfdetails"])) {
	$formupdtrfdetails=$_POST["formupdtrfdetails"]; }
if (isset($_POST['stdselected'])) 
{
    $stds = $_POST['stdselected'];
}
if (isset($_POST["updstdform"])) {
	$updstdform=$_POST["updstdform"]; }

    if (isset($articlecharacteristic)) {
        $listartchar = implode(',', $articlecharacteristic);
    }else{
        $listartchar = "";
    }
if (isset($_POST["addreq"])) {
	$addreq=$_POST["addreq"]; }
if (isset($_POST["addreqform"])) {
	$addreqform=$_POST["addreqform"]; }
else { $addreqform=""; }
if (isset($_POST["addinfo"])) {
	$addinfo=$_POST["addinfo"]; }
else { $addinfo=""; }

//echo $listartchar;
?>
<?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("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
 include('include/trfqueryscript.php'); ?>
<?php if (isset($articlecharacteristic)) {
    
    foreach ($articlecharacteristic as $ac) {
        
$stdfromartchar = new WA_MySQLi_RS("stdfromartchar",$cmctrfdb,1);
$stdfromartchar->setQuery("SELECT * FROM standards WHERE standards.idarticlecharacteristic='$ac'");
$stdfromartchar->execute();
        $value=$stdfromartchar->getColumnVal("idstandards");
        $dpicatsel=$stdfromartchar->getColumnVal("iddpicategory");

								//foreach ($stds as $hobys=>$value) {
             				
$stdcheckpresent = new WA_MySQLi_RS("stdcheckpresent",$cmctrfdb,1);
$stdcheckpresent->setQuery("SELECT * FROM trfstandards WHERE trfstandards.idtrfdetails='$idtrf' AND trfstandards.idstandards='$value'");
$stdcheckpresent->execute();

        // insert for glovces EN 420 if not present
        if ($articletype==2) {
        $stdcheckpresent420 = new WA_MySQLi_RS("stdcheckpresent420",$cmctrfdb,1);
$stdcheckpresent420->setQuery("SELECT * FROM trfstandards WHERE trfstandards.idtrfdetails='$idtrf' AND trfstandards.idstandards='129'");
$stdcheckpresent420->execute();
            if (empty($stdcheckpresent420->getColumnVal("idtrfstandards"))) {
             $InsertQuery = new WA_MySQLi_Query($cmctrfdb);
  $InsertQuery->Action = "insert";
  $InsertQuery->Table = "trfstandards";
  $InsertQuery->bindColumn("idtrfdetails", "i", "$idtrf", "WA_DEFAULT");
  $InsertQuery->bindColumn("idstandards", "i", "129", "WA_DEFAULT");
  $InsertQuery->bindColumn("iddpicategory", "i", "$dpicatsel", "WA_DEFAULT");
  $InsertQuery->saveInSession("");
  $InsertQuery->execute();
  $InsertGoTo = "";
 
  $InsertQuery->redirect($InsertGoTo);
        }}
        
	if (empty($stdcheckpresent->getColumnVal("idtrfstandards"))) {

  $InsertQuery = new WA_MySQLi_Query($cmctrfdb);
  $InsertQuery->Action = "insert";
  $InsertQuery->Table = "trfstandards";
  $InsertQuery->bindColumn("idtrfdetails", "i", "$idtrf", "WA_DEFAULT");
  $InsertQuery->bindColumn("idstandards", "i", "$value", "WA_DEFAULT");
  $InsertQuery->bindColumn("iddpicategory", "i", "$dpicatsel", "WA_DEFAULT");
  $InsertQuery->saveInSession("");
  $InsertQuery->execute();
  $InsertGoTo = "";
 
  $InsertQuery->redirect($InsertGoTo);

        }}}//}
								
								
								?>
<?php
if (isset($formupdtrfdetails)) {
  $UpdateQuery = new WA_MySQLi_Query($cmctrfdb);
  $UpdateQuery->Action = "update";
  $UpdateQuery->Table = "`trf-details`";
  $UpdateQuery->bindColumn("sample_description", "s", "$description", "WA_DEFAULT");
  $UpdateQuery->bindColumn("measurefrom", "s", "$rangemeasuremin", "WA_DEFAULT");
  $UpdateQuery->bindColumn("measureto", "s", "$rangemeasuremax", "WA_DEFAULT");
  $UpdateQuery->bindColumn("model", "s", "$model", "WA_DEFAULT");
  $UpdateQuery->bindColumn("idarticletype", "i", "$articletype", "WA_DEFAULT");
  $UpdateQuery->bindColumn("idarticle_characteristics", "s", "$listartchar", "WA_DEFAULT");
  $UpdateQuery->bindColumn("registeredmark", "s", "$registeredmark", "WA_DEFAULT");
  $UpdateQuery->addFilter("idtrfdetails", "=", "i", "".($idtrf)  ."");
  $UpdateQuery->execute();
  $UpdateGoTo = "";
  if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
  $UpdateQuery->redirect($UpdateGoTo);
	
	  $code="3";	
  $InsertQuery2 = new WA_MySQLi_Query($cmctrfdb);
  $InsertQuery2->Action = "insert";
  $InsertQuery2->Table = "wheretrfstep";
  $InsertQuery2->bindColumn("idtrf", "i", "$idtrf", "WA_DEFAULT");
  $InsertQuery2->bindColumn("code", "s", "$code", "WA_DEFAULT");
  $InsertQuery2->saveInSession("");
  $InsertQuery2->execute();
  $InsertGoTo = "";

  $InsertQuery2->redirect($InsertGoTo);
}
?>
<?php
 include('include/trfqueryscript.php'); ?>
<?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");
$articletype=$trfnumberfinal->getColumnVal("idarticletype");
$articlecharact=$trfnumberfinal->getColumnVal("idarticle_characteristics");
?>
<?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 // if all the standards of articletype
// $stdcheck = new WA_MySQLi_RS("stdcheck",$cmctrfdb,0);
// $stdcheck->setQuery("SELECT * FROM standards WHERE standards.idarticletype='$articletype'");
// $stdcheck->execute(); ?>
<?php // preselection based on article characteristic
$stdcheck = new WA_MySQLi_RS("stdcheck",$cmctrfdb,0);
$stdcheck->setQuery("SELECT * FROM standards WHERE standards.idarticlecharacteristic='$articlecharact' ");
$stdcheck->execute();
$idstselect=$stdcheck->getColumnVal("idstandards");
?>
<?php //  inline edit query
$idtrfdetails=$idtrf;
$row1 = mysqli_query($con,"SELECT *,trfstandards.iddpicategory as iddpicategoryid,trfstandards.idprotectioncategory as idprotectioncategoryid,trfstandards.idstandards as idstandardsid FROM trfstandards LEFT JOIN standards ON trfstandards.idstandards=standards.idstandards LEFT JOIN dpicategory ON trfstandards.iddpicategory=dpicategory.iddpicategory LEFT JOIN protectioncategory ON trfstandards.idprotectioncategory=protectioncategory.idprotectioncategory WHERE trfstandards.idtrfdetails='$idtrf'");
//$rows = mysqli_fetch_assoc($row1);
//print_r($rows);
//exit;
$idstandards=mysqli_query($con,"SELECT idstandards ,standardname FROM standards");

//query list protectioncategory
$proteccategorylist=mysqli_query($con,"SELECT idprotectioncategory ,name_protectioncategory FROM protectioncategory");

$idproteccategorylistRecord=array();       
while($idprotectioncategoryrow = mysqli_fetch_assoc($proteccategorylist)) {
    $idproteccategorylistRecord[$idprotectioncategoryrow['idprotectioncategory']]=utf8_encode($idprotectioncategoryrow['name_protectioncategory']);
}
$idprotectioncategoryJson=json_encode($idproteccategorylistRecord);

//Impermeabilità
//query list protectioncategory
$dpicategroylist=mysqli_query($con,"SELECT iddpicategory ,value_dpicategory FROM dpicategory");

$iddpicategorylistRecord=array();       
while($iddpicategoryrow = mysqli_fetch_assoc($dpicategroylist)) {
    $iddpicategorylistRecord[$iddpicategoryrow['iddpicategory']]=utf8_encode($iddpicategoryrow['value_dpicategory']);
}
$iddpicategoryJson=json_encode($iddpicategorylistRecord);
?>
<!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" />

	<!-- inline edit -->
	
	<!-- <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet"> -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
  <script src="https://kit.fontawesome.com/f13e61f9bf.js" crossorigin="anonymous"></script>
	<script src="jquery.tabledit.js"></script>
	<!-- submit form with button -->
<script>
function formSubmit() {
    document.forms["myForm"].submit();
}
</script>

<script type="text/javascript">

$(document).ready(function(){
	populate_cat_tbl();
	
	$("#add").click(function(e){
    var table = $(this).attr('for-table');  //get the target table selector
    var $tr = $(table + ">tbody>tr:last-child").clone(true, true);  //clone the last row
    var nextID = parseInt($tr.find("input.tabledit-identifier").val()) + 1; //get the ID and add one.
    $tr.find("input.tabledit-identifier").val(nextID);  //set the row identifier
    $tr.find("span.tabledit-identifier").text(nextID);  //set the row identifier
    $(table + ">tbody").append($tr);    //add the row to the table
    $tr.find(".tabledit-edit-button").click();  //pretend to click the edit button
    $tr.find("input:not([type=hidden]), select").val("");   //wipe out the inputs.
    $(this).prop('disabled', true);
	$('select[name=idprotectioncategoryid]').prepend("<option value='' selected='selected'>Please Select</option>");
	$('select[name=iddpicategoryid]').prepend("<option value='' selected='selected'>Please Select</option>");
});
/*$('#example1').Tabledit({
    url: 'logic-edit-delete.php',
    columns: {
        identifier: [0, 'id'],
        editable: [[2, 'idprotectioncategory','<?php echo $idprotectioncategoryJson; ?>'], [3, 'iddpicategory','<?php echo $iddpicategoryJson; ?>']]
    },
    onDraw: function() {
        console.log('onDraw()');
    },
    onSuccess: function(data, textStatus, jqXHR) {
        console.log('onSuccess(data, textStatus, jqXHR)');
        console.log(data);
        console.log(textStatus);
        console.log(jqXHR);
        $("#add").prop('disabled', false);
		//location.reload();
    },
    onFail: function(jqXHR, textStatus, errorThrown) {
        console.log('onFail(jqXHR, textStatus, errorThrown)');
        console.log(jqXHR);
        console.log(textStatus);
        console.log(errorThrown);
    },
    onAlways: function() {
        console.log('onAlways()');
    },
    onAjax: function(action, serialize) {
        console.log('onAjax(action, serialize)');
        console.log(action);
        console.log(serialize);
    }
	});*/


});

function populate_cat_tbl(){
	$.get('cat-table.php', {idtrf:'<?php echo $idtrf;?>', standardcodetitle:'<?php echo $standardcodetitle?>', protectioncategorytitle:'<?php echo $protectioncategorytitle;?>', dpicategorytitle:'<?php echo $dpicategorytitle;?>', pleaseselectstd:'<?php echo $pleaseselectstd;?>'}, function(data){
		$('#cat_table_cont').html(data);
		
		$('#example1').Tabledit({
			url: 'logic-edit-delete.php',
			columns: {
				identifier: [0, 'id'],
				editable: [[2, 'idprotectioncategory','<?php echo $idprotectioncategoryJson; ?>'], [3, 'iddpicategory','<?php echo $iddpicategoryJson; ?>']]
			},
            editButton: false,
			onDraw: function() {
				console.log('onDraw()');
			},
			onSuccess: function(data, textStatus, jqXHR) {
				// console.log('onSuccess(data, textStatus, jqXHR)');
				// console.log(data);
				// console.log(textStatus);
				// console.log(jqXHR);
				$("#add").prop('disabled', false);
				populate_cat_tbl();

                /* HIGHLIGHT TR */
                let trID = "#"+data['id'];
                let defBGColor = $(trID).css("background-color");
                let defTxtColor = $(trID).css("color");

                setTimeout(function(){
                    $(trID).css({'background-color':'#228B22', 'color':'#F0F8FF'});
                    $(trID).fadeOut(300, function(){ $(trID).css({'background-color':defBGColor, 'color':defTxtColor}) }).fadeIn(100);
                } ,200);
			}
		});
	});
}

</script>
<style>

.table.user-select-none {
    -webkit-touch-callout: none;
    -webkit-user-select: none;
    -khtml-user-select: none;
    -moz-user-select: none;
    -ms-user-select: none;
    user-select: none;
}
</style>
</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);">CIMAC 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">
							<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 id="accordion">
  <div class="card">
    <div class="card-2" id="headingThree">
      <h5 class="mb-0">
        <button class="btn btn-link collapsed" data-toggle="collapse" data-target="#collapseThree" aria-expanded="false" aria-controls="collapseThree">
          <?php echo $descriptionstep; ?>
        </button>
      </h5>
    </div>
    <div id="collapseThree" class="collapse" aria-labelledby="headingThree" data-parent="#accordion">
      <div class="card-body">

                  <div class="table-responsive">
                    <table class="table table-success mb-0">
                                            <thead>
                                            <tr>
												<th></th>
											    <th><?php echo $typearticletitle; ?></th>
                                                <th><?php echo $descriptiontitle; ?></th>
                                                <th><?php echo $modeltitle; ?></th>
                                                <th><?php echo $rangemeasuremintitle; ?></th>
												<th><?php echo $rangemeasuremaxtitle; ?></th>
												<th><?php echo $articlecharacteristictitle; ?></th>
												<th><?php echo $registeredmarktitle; ?></th>
 
                                            </tr>
                                            </thead>
                                            <tbody>
                                            <tr>
												<td><img src="uploadimages/<?php echo $sphotofilename; ?>" height="100" alt=""/></td>
                                                <td><span class="badge badge-soft-primary"><?php echo $sname_articletype; ?></span></td>
												<td><?php echo $sdescription; ?></td>
                                                <td><?php echo $smodel; ?></td>
                                                <td><?php echo $smeasuremin; ?></td>
												<td><?php echo $smeasuremax; ?></td>
                                                
												<td><span class="badge badge-soft-primary"><?php echo $sname_articlecharacteristic; ?></span></td>
												<td><?php echo $sregisteredmark; ?></td>

                                            </tr>
                                           
  
                                            </tbody>
                                        </table><!--end /table-->
										<br>

					  <a href="trfdetails.php?idtrf=<?php echo $idtrf; ?>"><button type="button" class="btn btn-success waves-effect waves-light"><?php echo $edittitle; ?></button> </a> 
					 </div><!--end /tableresponsive-->
		  
                                </div>
      
    </div>
  </div>
</div>
							
							
							<div class="progress mb-4">
                              <div class="progress-bar" role="progressbar" style="width: 50%;" aria-valuenow="50" aria-valuemin="0" aria-valuemax="100">50%</div>
                          </div>
							
                           <!-- <div class="card">
                              <div class="card-body">
								  <?php include('include/alertcheck.php'); ?>
                                    <h5><?php echo $standardlink; ?></h5>
                                <p class="text-muted mb-3"><?php echo $standardlink_help; ?></p> 
                            <form class="was-validated" action="standardstep.php" method="post" name="myForm">
								
								
						      <?php
$wa_startindex = 0;
while(!$stdcheck->atEnd()) {
  $wa_startindex = $stdcheck->Index;
?>
								
							
								      <?php
  $stdcheck->moveNext();
}
$stdcheck->moveFirst(); //return RS to first record
unset($wa_startindex);
unset($wa_repeatcount);
?>
				
								  	
							  </form>
                      </div>--><!--end card-->
                       
							
                  </div><!--end col-->
						<?php
$standardselectedlist = new WA_MySQLi_RS("standardselectedlist",$cmctrfdb,0);
$standardselectedlist->setQuery("SELECT * FROM trfstandards LEFT JOIN standards ON trfstandards.idstandards=standards.idstandards WHERE trfstandards.idtrfdetails='$idtrf'");
$standardselectedlist->execute();?>
						

					  <div class="col-lg-12">
                            <div class="card">
                                <div class="card-body">
    
                                    <h5><?php echo $assignedstd; ?></h4>
                                    <p class="text-muted mb-3">
                                        <?php echo $assignedstd_help; ?>.
                                    </p>
    
                                    <div class="table-responsive">
<?php include('include/alertcheck.php'); ?>

										<div id="cat_table_cont"></div>
										 <!--<table class="table table-striped mb-0" id="example1" style="border:1px solide red">
    	<tr><th style="display:none;">id</th><th><?php echo $standardcodetitle; ?></th><th><?php echo $protectioncategorytitle; ?></th><th><?php echo $dpicategorytitle; ?></th></tr>
    	<?php while($rowquery = mysqli_fetch_assoc($row1)) {?>
    	<tr>
    		<td style="display:none;"><?php echo $rowquery['idtrfstandards'];?></td>

    		<td><?php echo $rowquery['standardcode']; ?></td>
            <td><?php if(isset($rowquery['name_protectioncategory'])){echo $rowquery['name_protectioncategory'];} else { ?><p style="color:red;"><?php echo $pleaseselectstd;} ?></p></td>
            <td><?php if(isset($rowquery['value_dpicategory'])){echo $rowquery['value_dpicategory'];} else { echo $pleaseselectstd;} ?></td>

    	</tr>
    	<?php } ?>
        </table>-->
										
										
										<?php include('include/virusquerycheck.php'); ?><br>

										
<!--end /table-->
                                    </div><!--end /tableresponsive-->
                                </div><!--end card-body-->
                          </div>
                                
                           <?php //  specific list of add req for std
                                $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");
                                $idarticletype=$trfnumberfinal->getColumnVal("idarticletype");
                                $idstandards=$trfnumberfinal->getColumnVal("idstandards");
                                
                                
$standardlistsel = new WA_MySQLi_RS("standardlistsel",$cmctrfdb,1);
$standardlistsel->setQuery("SELECT * FROM trfstandards WHERE trfstandards.idtrfdetails='$idtrf'");
$standardlistsel->execute();

$idstandards=$standardlistsel->getColumnVal("idstandards");

                                
$addreqlist = new WA_MySQLi_RS("addreqlist",$cmctrfdb,0);
$addreqlist->setQuery("SELECT * FROM stdreqlist LEFT JOIN additionalrequirements ON stdreqlist.idadditionalrequirements=additionalrequirements.idadditionalrequirements WHERE stdreqlist.idstandards='$idstandards' ");
$addreqlist->execute();?>
                                <?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();?>
                                
                                
                                    <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-2">
                                                  <select class="form-control" id="addreq" name="addreq">
                                                      <option value=""><?php echo $pleaseselect; ?></option>
                                                      <?php
while(!$addreqlist->atEnd()) { //dyn select
?>
                                                      <option value="<?php echo($addreqlist->getColumnVal("idadditionalrequirements")); ?>"><?php echo($addreqlist->getColumnVal("$varnamelang")); ?></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 echo($addreqselectedlist->getColumnVal($varnamelang)); ?></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 if (($articletype==1) || (!empty($virusstep))) { ?>
                                            <a href="additionalinfo.php?idtrf=<?php echo $idtrf; ?>&codestep=<?php echo '3'; ?>"><button type="button" class="btn btn-success waves-effect waves-light"><?php echo $nextsteptitle; ?></button> </a> 
										<?php } else { ?>
											<a href="addrequirements.php?idtrf=<?php echo $idtrf; ?>&codestep=<?php echo '3'; ?>"><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 card-->
                      </div>
						
              </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>