

<?php

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

<?php 

// pickup the get variable

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

	$idtrf=$_GET["idtrf"]; }

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

	$code="8"; 



  $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

$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");

?>



<?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();?>



<!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>

<!-- upload image script -->

<script src="https://code.jquery.com/jquery-3.4.1.min.js"></script>

	<script> 

        $(document).ready(function() { 

            $(".upload-doc").click(function(){

                $(".form-horizontal").ajaxForm({target: '.preview'}).submit();

            });

        }); 

</script>

	

	<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></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">

							<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: 95%;" aria-valuenow="95" aria-valuemin="0" aria-valuemax="100">95%</div>

                          </div>

							

                            

                            <?php // photos ?>

                            

                                                        <?php  if ($trfnumberfinal->getColumnVal("idcertification")!='5') { ?>

                            <div class="card">

                                <div class="card-body">

                                    <h4 class="mt-0">Aggiungi le foto <i class="fas fa-info-circle" data-toggle="modal" data-animation="bounce" data-target=".bs-example-modal-center5"></i>

<div class="modal fade bs-example-modal-center5" tabindex="-1" role="dialog" aria-labelledby="mySmallModalLabel" aria-hidden="true">

                                                        <div class="modal-dialog modal-dialog-centered">

                                                            <div class="modal-content">

                                                                <div class="modal-header">

                                                                    <h5 class="modal-title mt-0" id="exampleModalLabel"><?php echo $m18btitle; ?></h5>

                                                                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">

                                                                        <span aria-hidden="true">&times;</span>

                                                                    </button>

                                                                </div>

                                                                <div class="modal-body">

                                                                    <p>Foto frontale e laterale

                                                                    </p>

                                                                </div>

                                                            </div><!-- /.modal-content -->

                                                        </div><!-- /.modal-dialog -->

                                                    </div><!-- /.modal --></h4>

									<?php if ($idcertificate!=6) { ?>

										 <p class="text-muted mb-3">Aggiungi foto etc.....</p> 

								

									

							<table id="photoaded">

                                <tr>

                                    <?php if ($trfnumberfinal->getColumnVal("idarticletype")=='1') {

                                    $photo1=$photoshoesside;

                                    $photo2=$photoshoessole;

                                } elseif ($trfnumberfinal->getColumnVal("idarticletype")=='2') {

                                    $photo1=$photogloveup;

                                    $photo2=$photoglovebottom;

                                } elseif ($trfnumberfinal->getColumnVal("idarticletype")=='3') {

                                    $photo1=$photomasksidea;

                                    $photo2=$photomasksideb;

                                } ?>

                                <th><?php echo $photo1; ?></th>

                                    <th></th>

                                    <th><?php echo $photo2; ?></th>

                                </tr>

                                <tr>

                                <td>

                                    <div class="upload-div">

    <!-- File upload form -->

    <form id="uploadFormphoto"   enctype="multipart/form-data">

		

	

		

        <label></label>

        <input type="file"    name="docphotoone[]" id="fileInput1" >

        <input type="hidden" name="idtrf" id="idtrf" value="<?php echo($trfnumberfinal->getColumnVal("idtrfdetails")); ?>">

        <input type="submit" name="submit" value="UPLOAD"/>

     </form>

	

    <!-- Display upload status -->

    <div id="uploadStatus1"></div>

	   

</div>

                                </td>

                                    <td></td>

                                                            <td>

                                    <div class="upload-div">

    <!-- File upload form -->

    <form id="uploadFormphototwo" enctype="multipart/form-data">

		

	

		

        <label></label>

        <input type="file" name="docphototwo[]" id="fileInput2" >

		<input type="hidden" name="idtrf" id="idtrf" value="<?php echo($trfnumberfinal->getColumnVal("idtrfdetails")); ?>">

        <input type="submit" name="submit" value="UPLOAD"/>

    </form>

	

    <!-- Display upload status -->

    <div id="uploadStatus2"></div>

	    <div id=".gallery"></div><?php } ?>

</div>

                                                               

	   

</div>

                                </td>

                            

                                </tr>

                                                            <tr>

                                                            <td>

                                                                <?php if (!empty($trfnumberfinal->getColumnVal("photoone"))) { ?>

                                                                <img src="uploaddocuments/<?php echo($trfnumberfinal->getColumnVal("photoone")); ?>" height="200" alt=""/><?php } ?></td>

                                                                <td></td>

                                                                <td><?php if (!empty($trfnumberfinal->getColumnVal("phototwo"))) { ?><img src="uploaddocuments/<?php echo($trfnumberfinal->getColumnVal("phototwo")); ?>" height="200" alt=""/><?php } ?></td>

                                                               

                                                            

                                                            </tr>

                                </table>

	



									<br>



						

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

                      </div><!--end card--><?php  } ?>

                                    

									

                            

                            <?php // documents?>

                            <div class="card">

                                <div class="card-body">

                                    <h4 class="mt-0"><?php echo $adddoctitle; ?> <i class="fas fa-info-circle" data-toggle="modal" data-animation="bounce" data-target=".bs-example-modal-center5"></i>

<div class="modal fade bs-example-modal-center5" tabindex="-1" role="dialog" aria-labelledby="mySmallModalLabel" aria-hidden="true">

                                                        <div class="modal-dialog modal-dialog-centered">

                                                            <div class="modal-content">

                                                                <div class="modal-header">

                                                                    <h5 class="modal-title mt-0" id="exampleModalLabel"><?php echo $m18btitle; ?></h5>

                                                                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">

                                                                        <span aria-hidden="true">&times;</span>

                                                                    </button>

                                                                </div>

                                                                <div class="modal-body">

                                                                    <p><?php echo nl2br($documenthelp); ?>

                                                                    </p>

                                                                </div>

                                                            </div><!-- /.modal-content -->

                                                        </div><!-- /.modal-dialog -->

                                                    </div><!-- /.modal --></h4>

									<?php if ($idcert!=5) { ?>

										 <p class="text-muted mb-3"><?php echo $adddoctitle_help; ?></p> 

									<?php } else { ?>

										<p class="text-muted mb-3"><?php echo $auditdocumenttitle; ?></p>

									<?php } ?>

									

							

									<div class="upload-div">

    <!-- File upload form -->

    <form id="uploadForm" enctype="multipart/form-data">

		

	<div class="form-group row">

    	<label for="validationTooltip01" class="col-sm-2 col-form-label"><?php echo $filedescription; ?></label>

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

    		<input type="text" class="form-control" id="validationTooltip01" name="filedescription" placeholder="<?php echo $filedescription; ?>" required="">

															

    	</div>

	</div>

		

        <label><?php echo $selectfileonyourpc; ?></label>

        <input type="file" name="doc[]" id="fileInput" >

		<input type="hidden" name="idtrf" id="idtrf" value="<?php echo($trfnumberfinal->getColumnVal("idtrfdetails")); ?>">

        <input type="submit" name="submit" value="UPLOAD"/>

    </form>

	

    <!-- Display upload status -->

    <div id="uploadStatus"></div>

	   

</div>

	



									<br>



						

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

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

							

							

 <div class="card" id="provacla">

	 

	 <?php

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

$filenamelist->setQuery("SELECT * FROM fileattached WHERE fileattached.idtrfdetails='$idtrf'");

$filenamelist->execute();

?>

                                <div class="card-body">

                                    <h4 class="mt-0 header-title"><?php echo $addeddoctitle; ?></h4>

                                    <p class="text-muted mb-3"><?php echo $addeddoctitle_help; ?></p> 

									

									

									<div class="upload-div">

    <!-- File upload form -->

    <div class="card-body">

    

                                    

    

                                    <div class="table-responsive" id="docadded">

                                      

                                        <table class="table table-striped mb-0">

                                            <thead>

                                              <tr>

                                                <th><?php echo $filenametitle; ?></th>

                                                <th><?php echo $filenamedesc; ?></th>

                                                

                                                <th><?php echo $actiondel; ?></th>

                                              </tr>

                                              </thead>

                                            <tbody>

												

												  <?php

$wa_startindex = 0;

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

  $wa_startindex = $filenamelist->Index;

?>

                                              <tr>

                                                <td><a href="uploaddocuments/<?php echo($filenamelist->getColumnVal("filename_fileattached")); ?>" target="_blank"><?php echo $filesent; ?></a></td>

                                                <td><?php echo($filenamelist->getColumnVal("description_fileattached")); ?></td>

                                                

                                                <td>                                                       

                                                  

                                                  <a href="deleteaddedoc.php?idtrf=<?php echo $idtrf; ?>&idadddoc=<?php echo($filenamelist->getColumnVal("idfileattached")); ?>"><i class="fas fa-trash-alt text-danger font-16"></i></a>

                                                  </td>

                                              </tr>

                                               <?php

  $filenamelist->moveNext();

}

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

unset($wa_startindex);

unset($wa_repeatcount);

?>

                                              

                                              

                                              </tbody>

                                          </table><br>

<a href="trfoption.php?idtrf=<?php echo $idtrf; ?>&codestep=8"><button type="button" class="btn btn-success waves-effect waves-light"><?php echo $nextsteptitle; ?></button> </a>

										<button type="button" class="btn btn-dark waves-effect waves-light" onclick="history.back()"><?php echo $backstep; ?></button> 

                                         

<!--end /table-->

                                    </div><!--end /tableresponsive-->

                                </div>

	



	   

</div>

	



									<br>



						

                          </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 -->

<script>

$(document).ready(function(){

    // File upload via Ajax

    $("#uploadForm").on('submit', function(e){

        e.preventDefault();

        $.ajax({

            type: 'POST',

            url: 'uploadfile.php',

            data: new FormData(this),

            contentType: false,

            cache: false,

            processData:false,

            beforeSend: function(){

                $('#uploadStatus').html('<img src="../images/uploading.gif"/>');

            },

            error:function(){

                $('#uploadStatus').html('<span style="color:#EA4335;">File upload failed, please try again.<span>');

            },

            success: function(data){

                $('#uploadForm')[0].reset();

                $('#uploadStatus').html('<span style="color:#28A74B;">File uploaded successfully.<span>');

                $('.gallery').html(data);

				$("#docadded").load(location.href + " #docadded");

            }

        });

    });

    

    // File type validation

    $("#fileInput").change(function(){

        var fileLength = this.files.length;

        // var match= ["application/pdf","application/msword","image/jpg","image/gif","application/xls","application/xlsx", "application/vnd.ms-excel", "application/vnd.openxmlformats-officedocument.wordprocessingml.document"];

        var i;

        for(i = 0; i < fileLength; i++){ 

            var file = this.files[i];

            var imagefile = file.type;

            if(!((imagefile==match[0]) || (imagefile==match[1]) || (imagefile==match[2]) || (imagefile==match[3]))){

                alert('Please select a valid  file (PDF, word, excel).');

                $("#fileInput").val('');

                return false;

            }

        }

    });

});

</script>



<script>

$(document).ready(function(){

    // File upload via Ajax

    $("#uploadFormphoto").on('submit', function(e){

        e.preventDefault();

        $.ajax({

            type: 'POST',

            url: 'uploadphotofile.php',

            data: new FormData(this),

            contentType: false,

            cache: false,

            processData:false,

            beforeSend: function(){

                $('#uploadStatus1').html('<img src="../images/uploading.gif"/>');

            },

            error:function(){

                $('#uploadStatus1').html('<span style="color:#EA4335;">File upload failed, please try again.<span>');

            },

            success: function(data){

                $('#uploadFormphoto')[0].reset();

                $('#uploadStatus1').html('<span style="color:#28A74B;">File uploaded successfully.<span>');

                $('.gallery').html(data);

				$("#photoaded").load(location.href + " #photoaded");

            }

        });

    });

    

    // File type validation

    $("#fileInput1").change(function(){

        var fileLength = this.files.length;

        // var match= ["application/pdf","application/msword","image/jpg","image/gif","application/xls","application/xlsx", "application/vnd.ms-excel", "application/vnd.openxmlformats-officedocument.wordprocessingml.document"];

        var i;

        for(i = 0; i < fileLength; i++){ 

            var file = this.files[i];

            var imagefile = file.type;

            if(!((imagefile==match[0]) || (imagefile==match[1]) || (imagefile==match[2]) || (imagefile==match[3]))){

                alert('Please select a valid  file (jpg, jpeg, png, bmp).');

                $("#fileInput1").val('');

                return false;

            }

        }

    });

});

</script>

    

    <script>

$(document).ready(function(){

    // File upload via Ajax

    $("#uploadFormphototwo").on('submit', function(e){

        e.preventDefault();

        $.ajax({

            type: 'POST',

            url: 'uploadphotofile2.php',

            data: new FormData(this),

            contentType: false,

            cache: false,

            processData:false,

            beforeSend: function(){

                $('#uploadStatus2').html('<img src="images/uploading.gif"/>');

            },

            error:function(){

                $('#uploadStatus2').html('<span style="color:#EA4335;">File upload failed, please try again.<span>');

            },

            success: function(data){

                $('#uploadFormphototwo')[0].reset();

                $('#uploadStatus2').html('<span style="color:#28A74B;">File uploaded successfully.<span>');

                $('.gallery').html(data);

				$("#photoaded").load(location.href + " #photoaded");

            }

        });

    });

    

    // File type validation

    $("#fileInput2").change(function(){

        var fileLength = this.files.length;

        // var match= ["application/pdf","application/msword","image/jpg","image/gif","application/xls","application/xlsx", "application/vnd.ms-excel", "application/vnd.openxmlformats-officedocument.wordprocessingml.document"];

        var i;

        for(i = 0; i < fileLength; i++){ 

            var file = this.files[i];

            var imagefile = file.type;

            if(!((imagefile==match[0]) || (imagefile==match[1]) || (imagefile==match[2]) || (imagefile==match[3]))){

                alert('Please select a valid  file (jpg, jpeg, png, bmp).');

                $("#fileInput2").val('');

                return false;

            }

        }

    });

});

</script>



        <!-- 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>