mentorcommitmentview.php

<?php
include "home.php";
?>
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <link rel="stylesheet" href="stylespagination.css">
<script>
$(document).ready(function(){
  $("#myInput").on("keyup", function() {
    var value = $(this).val().toLowerCase();
    $("#myTable tr").filter(function() {
      $(this).toggle($(this).text().toLowerCase().indexOf(value) > -1)
    });
  });
});
</script>
<?php
$role=$_SESSION['hrrolesession'];
if(strpos($role,"mentorship") == false){ 
session_destroy();
exit();         
} 
?>
<script>
         $(function() {
            $( "#startDate" ).datepicker({
               appendText:"(yy-mm-dd)",
               changeMonth:true,
               changeYear:true,
               yearRange:"c-0:c+1",
               dateFormat:"yy-mm-dd"
            });
            $( "#endDate" ).datepicker({
               appendText:"(yy-mm-dd)",
               changeMonth:true,
               changeYear:true,
               yearRange:"c-0:c+1",
               dateFormat:"yy-mm-dd"
            });
            $( ".dateElement" ).datepicker({
               appendText:"(yy-mm-dd)",
               changeMonth:true,
               changeYear:true,
               yearRange:"c-35:c+0",
               dateFormat:"yy-mm-dd"
            });
         });
         
  $("#indiv").click(function(){
  $("#impo").toggle();
});
</script>
<script>
$(document).ready(function(){
	//$("#impo").hide();
  $("#indiv").click(function(){
  $("#impo").show();
  $("#all"). prop("checked", false);
});
$("#all").click(function(){
	$("#indiv"). prop("checked", false);
	$('#impo option:first').prop('selected',true);
  $("#impo").hide();  
});



$("#days").click(function(){

    for(var c=0,e=0,d=new Date($("#startDate").val()),a=(new Date($("#endDate").val())-d)/864E5;0<=a;a--)
    {
        var b=new Date(d);
        b.setDate(b.getDate()+a);
        1==Math.ceil(b.getDay()%6/6)?c++:e++
    }
    $("#days").val(c);
});



});
</script>


<style>
	
		.tableFixHead          { overflow-y: auto; height: 100px; }
.tableFixHead thead th { position: sticky; top: 0; }


</style>

<script type="text/javascript">
      $(function() {
        $(".tablelist tr:nth-child(even)").addClass("striped");
        $(".tablelist tr:nth-child(odd)").addClass("nostriped");
      });
      
      
$(document).ready(function () {
  $('#dtBasicExample').DataTable();
  $('.dataTables_length').addClass('bs-select');
});      
      
      
    </script>

    <style type="text/css">
      body,td {
        font-size: 10pt;
      }
      table.tablelist {
        /*background-color: black;*/
        border: 1px black solid;
        border-collapse: collapse;
      }
      th {
        border: 1px outset silver;
        background-color: grey;
        color: white;
      }
      tr.nostriped {
        background-color: white;
        margin: 1px;
      }
      tr.striped {
        /*background-color: #f09320;*/
        background-color: whitesmoke;;
      }
      td {
        padding: 1px 8px;
      }
      .normal {
  font-weight: normal;
}



    </style>


<style>

</style>
<h2>Skills Verification</h2>
<br/>





<?php
if(isset($_POST['editdoc'])){
include "connect.php";
include 'createEmail.php';
$fileid=$_POST['fileid'];

$contractqry=mysqli_query($conn,"SELECT *,(select concat(lastname,' ',firstname) from users where userid=arf.employeeid) as empname FROM archiving_employee_files arf where arf.fileid='$fileid'");
if(mysqli_num_rows($contractqry)) {

$row=mysqli_fetch_array($contractqry);
	$fileid=$row['fileid'];
	$type=$row['type'];
	$employeeName=$row['empname'];
	$employeeid=$row['employeeid'];

print("

<form action='uploadEmployeeDocument.php' method='post' enctype='multipart/form-data' onSubmit=\"return confirm('Are you sure, you want to save changes on Registered Supplier ?')\">
<fieldset>
<legend>Edit Employee document</legend>
<table width='100%'>
<tr>
<td>Employee:</td>
<td><input type='hidden' name='fileid' required='true' value='$fileid'><select name='employee'><option value='$employeeid' selected='true'>$employeeName</option>");

$employeesqueryActive=mysqli_query($conn,"select userid,concat(lastname,' ',firstname) as empName  from users where active='YES' and userid!='$employeeid' order by lastname");
if(mysqli_num_rows($employeesqueryActive)) {
while($row=mysqli_fetch_array($employeesqueryActive)){
$mployeeId=$row['userid'];
$mployeeName=$row['empName'];
print("<option value='$mployeeId'>$mployeeName</option>");
}
}

print("</td></tr><tr><td>Type of document:</td><td> ");



print(" 
<select id='doctype' name='doctype'>
<option value='$type' selected='true'>$type</option>
    <optgroup label='The First Patch Pocket (Applications)'>
        <option value='Application letter &CV'>Application letter &CV</option>
        <option value='All School certificate(s)'>All School certificate(s)</option>
        <option value='Copy of ID'>Copy of ID</option>
        <option value='Copy of driving license for drivers'>Copy of driving license for drivers</option>
        <option value='Copy of practicing license for healthcare staf'>Copy of practicing license for healthcare staf</option>
        <option value='All written and oral interview papers'>All written and oral interview papers</option>
    </optgroup>
    <optgroup label='Addition to those who left'>
        <option value='Termination letter'>Termination letter</option>
        <option value='End of contract letter'>End of contract letter</option>
        <option value='Resignation letter'>Resignation letter</option>
        <option value='Exit handover form'>Exit handover form</option>
        <option value='Exit interview form'>Exit interview form</option>
    </optgroup>
    <optgroup label='The Second Patch Pocket (Contracts)'>
        <option value='Employment offer(s) or Appointment letter'>Employment offer(s) or Appointment letter</option>
        <option value='Contract'>Contract</option>
        <option value='Contract extension letter(s)'>Contract extension letter(s)</option>
        <option value='Job description(s)'>Job description(s)</option>
        <option value='Drivers’ code of conduct-Drivers'>Drivers’ code of conduct-Drivers</option>
    </optgroup>
    <optgroup label='The Third Patch Pocket (Forms)'>
        <option value='Employee details form'>Employee details form</option>
        <option value='Medical insurance forms'>Medical insurance forms</option>
        <option value='Employee background Check forms'>Employee background Check forms</option>
        <option value='Safeguarding forms'>Safeguarding forms</option>
        <option value='Conflict of interest form'>Conflict of interest form</option>
        <option value='Timesheet'>Timesheet form</option>
    </optgroup>
    <optgroup label='The Fourth Patch Pocket (All Letters)'>
        <option value='salary amendment'>salary amendment</option>
        <option value='disciplinary'>disciplinary</option>
        <option value='end probation & employement confirmation'>end probation & employement confirmation</option>
        <option value='relocation'>relocation</option>
        <option value='bank letters'>bank letters</option>        
        <option value='Other letters'>Other letters</option>
    </optgroup>
</select>
</td></tr>");


print("
<tr>
<td>File(.jpg,.jpeg,.png,.pdf):</td>
<td><input type='file' name='filetoupload' accept='.jpg,.jpeg,.png,.pdf' required='true'></td>
</tr>
</table>
</fieldset>
<br />
<div style='text-align: center;'>
<input type='submit' name='uploadedited' value='Save document' id='uploadid' class='hrbutton''>
</div>
</form>

");


}
exit;
}
?>


    <style>
        .hidden {
            display: none;
        }
        label {
            font-weight: bold;
        }
    </style>








<!-- voiding a file -->


<?php

if(isset($_POST['deldoc'])){	
include 'createEmail.php';
include "connect.php";
$creator=$_SESSION['hruseridsession'];
$fileid=$_POST['fileid'];
$datecreated=date("Y-m-d");

$savedocdetails=mysqli_query($conn,"update archiving_employee_files set voided='1',voided_by='$creator', voided_date='$datecreated' where fileid='$fileid'");

                 print("
<script>
alert('Document is deleted');
</script>
");
     
   
}
?>



<?php

include "connect.php";
$creator=$_SESSION['hruseridsession'];

$commitmentInfo=mysqli_query($conn,"SELECT *,(select concat(lastname,' ',firstname) from users where userid=mc.mentor_id) as mentor from hr_mentorship_commitment mc where and (voided is null or voided=0) order by id ");
if(mysqli_num_rows($commitmentInfo)) {
	print("<div align='right'><span>Search: <input id='myInput' type='text' placeholder='Search..'></span></div>
	<table width='100%' class='tablelist paginated-table' ><thead><tr>
<th>ID</th>
<th>Date created</th>
<th>Mentor</th>
<th>Competency</th>
<th>Are you ready to deliver this skills?</th>
<th>How the Skills Were Obtained</th>
<th>Means of verification</th>
<th>Proof</th>
<!-- <th>Edit/Delete</th> --></thead><tbody id='myTable'>");
$document="";
while($row=mysqli_fetch_array($commitmentInfo)){
	
	$id=$row['id'];
		$date_created=$row['date_created'];
		$mentor=$row['mentor'];
	$competency=$row['competency'];
$ready_to_deliver=$row['ready_to_deliver'];
$obtained_how=$row['obtained_how'];
$means_of_verification=$row['means_of_verification']." ".$row['means_of_verification_other'];;
$file_name_db=$row['proof'];

$dir = "mentorproof/";
if (is_dir($dir)){
  if ($dh = opendir($dir)){
    while (($file = readdir($dh)) !== false){
//$tmp= explode('.', $file);
$file_name=$file;
if($file_name==$file_name_db) {
$document=$file;
break;
}
}
    closedir($dh);
  }
}



if($document!="") {

print("<tr><td>$id</td>
<td>$date_created</td>
<td>$mentor</td>
<td>$competency</td>
<td>$ready_to_deliver</td>
<td>$obtained_how</td>
<td>$means_of_verification</td>
<td><a href='mentorproof/$document' target='_blank'>Document</a></td>

<!-- <td><form action='uploadEmployeeDocument.php' method='post' onSubmit=\"return confirm('Are you sure, you want to Edit ?')\">
<input type='hidden' name='fileid' value='$id'>
<input type='submit' name='editdoc' value='Edit Document'>
</form>
<form action='uploadEmployeeDocument.php' method='post' onSubmit=\"return confirm('Are you sure, you want to delete a document ?')\">
<input type='hidden' name='fileid' value='$id'>
<input type='submit' name='deldoc' value='Delete Document'>
</form>
</td> -->

</tr>");
}else{
print("<tr><td>$id</td>
<td>$date_created</td>
<td>$mentor</td>
<td>$competency</td>
<td>$ready_to_deliver</td>
<td>$obtained_how</td>
<td>$means_of_verification</td>
<td>Not submitted</td>

<!-- <td><form action='uploadEmployeeDocument.php' method='post' onSubmit=\"return confirm('Are you sure, you want to Edit ?')\">
<input type='hidden' name='fileid' value='$id'>
<input type='submit' name='editdoc' value='Edit Document'>
</form>
<form action='uploadEmployeeDocument.php' method='post' onSubmit=\"return confirm('Are you sure, you want to delete a document ?')\">
<input type='hidden' name='fileid' value='$id'>
<input type='submit' name='deldoc' value='Delete Document'>
</form>
</td> -->

</tr>");
}
$document="";
}
print("</tbody></table>");

}else {
print("<br> No Skills Verification recorded");
}
?>
  <div id="pagination">
        <!-- Pagination buttons will be dynamically added here -->
    </div>
<script src="pagination.js"></script>