confirmhrlevel.php

<?php
include "home.php";


?>

<style>


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


</style>
<script>  
 $(document).ready(function(){  
      var i=1;  
      $('#add').click(function(){  
           i++; 
           $('#dynamic_field').append('<tr id="row'+i+'"><td><textarea name="skills[]" placeholder="Enter Required knowledge, skills and abilities of an employee" class="form-control name_list"  size="10" rows="4" cols="30"></textarea></td><td><textarea name="benefits[]" placeholder="Enter Benefits of developing this new skill or competency" class="form-control name_list"  size="10" rows="4" cols="30"></textarea></td><td><textarea name="action[]" placeholder="Enter Likely Action Steps" class="form-control name_list"  size="10" rows="4" cols="30"></textarea></td><td><textarea name="resources[]" placeholder="Enter Required Resources/People" class="form-control name_list"  size="10" rows="4" cols="30"></textarea></td><td><input type="text" name="timeframe[]" placeholder="Enter Time Frame"  size="10"></td><td><button type="button" name="remove" id="'+i+'" class="btn btn-danger btn_remove">X</button></td></tr>');  
      });  
      $(document).on('click', '.btn_remove', function(){  
           var button_id = $(this).attr("id");   
           $('#row'+button_id+'').remove();  
      });  
      $('#submit').click(function(){            
           $.ajax({  
                url:"name.php",  
                method:"POST",  
                data:$('#add_name').serialize(),  
                success:function(data)  
                {  
                     alert(data);  
                     $('#add_name')[0].reset();  
                }  
           });  
      });  
 });  
 </script>
<script>
         $(function() {
            $( "#dateOfBirth" ).datepicker({
               appendText:"(yy-mm-dd)",
               changeMonth:true,
               changeYear:true,
               yearRange:"c-80:c+0",
               dateFormat:"yy-mm-dd"
            });
            $( ".dateElement" ).datepicker({
               appendText:"(yy-mm-dd)",
               changeMonth:true,
               changeYear:true,
               yearRange:"c-35:c+0",
               dateFormat:"yy-mm-dd"
            });
         });
</script>



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

<script>
function uncheckrestrictided() {
  document.getElementById("restrictided").checked = false;
}
function uncheckunrestricted() {
  document.getElementById("unrestricted").checked = false;
}

function uncheckmedical() {
  document.getElementById("medical").checked = false;
}
function unchecknonmedical() {
  document.getElementById("nonmedical").checked = false;
}
</script>

<h1>APPROVALS CONFIRMATION<h1>
<br/>





<center>
<div style='height: 100%;width: 98%;overflow: scroll;' class="tableFixHead">

<?php
if(isset($_POST['perfomanceconfirm'])){
include("connect.php");
include 'createEmail.php';
$employee_id=$_POST['employee_id'];
$fy=$_POST['fy'];
$userId=$_SESSION['hruseridsession'];
$supervisor_id=$_POST['supervisor_id'];

$updateconfirmationOfEmployee=mysqli_query($conn,"update hr_performance_ap set  hr_office_emp_id='$userId',hr_office_emp_approval='YES',hr_office_emp_approval_date=now() where FY='$fy' and employee_id='$employee_id' ");
$reqError=mysqli_error($conn);
if($reqError==null || $reqError=="") {
	
	$receivers=mysqli_query($conn,"select email,concat(firstname,' ',lastname) as empname,department from users where userid='$employee_id'");
$names= $_SESSION['firstnamesession']." ".$_SESSION['lastnamesession'];
$subject="APPOVAL FROM HR OF PA";
$message="We would like to notify you that HR officer(<b>".$names."</b>) confirm  your performance appraisal.";
$emp_name="";
$department="";
while($rowrec=mysqli_fetch_array($receivers)){	
	$receverEmail=$rowrec['email'];
	$emp_name=$rowrec['empname'];
	$department=$rowrec['department'];
	sendEmail($receverEmail,$subject,$message);
}

//$dpt=$_SESSION['department'];
//print("$names , $emp_name , $department");

$subject="APPOVAL OF PA FROM HR";
$message="We would like to notify you that HR Officer(<b>".$names."</b>) finish to confirm a performance appraisal of <b> ".$emp_name."</b>";
$leaderreceivers=mysqli_query($conn,"select email from users where userid='$supervisor_id'");
	while($rowlrec=mysqli_fetch_array($leaderreceivers)){	
	$receverlEmail=$rowlrec['email'];
	sendEmail($receverlEmail,$subject,$message);
}
print("
<script>
alert('Thank you for this confirmation');
</script>");	
}
}
?>


<?php

include("connect.php");

$fys=mysqli_query($conn,"SELECT FY FROM hr_performance_ap_targets t group by t.fy");
if(mysqli_num_rows($fys)) {
	print("<table><tr>");

while($row=mysqli_fetch_array($fys)){
	
$fy=$row['FY'];
$employee=$row['employee'];
$employeeid=$row['employee_id'];

print("<td>
<form action='confirmhrlevel.php' method='post'>
<input type='hidden' name='fy' value='$fy'>
<input type='submit' name='showselected' value='$fy' class='hrbutton'>");
print("</form>
</td>");
}
print("</tr></table>");
}
?>



<!-- Function -->

<?php
//function showRequest($fy,$employeeid) {
include("connect.php");
$userId=$_SESSION['hruseridsession'];
$fy="FY".  (date('y'));
if(isset($_POST['fy'])){
$fy=$_POST['fy'];
}
$dpt=$_SESSION['department'];
$position=$_SESSION['position'];
// perfomance confirm
$checkCompletedPerfomanceConfirm=mysqli_query($conn,"SELECT *,( select concat(firstname,' ',lastname) from users where userid=hpa.employee_id) as empname  FROM hr_performance_ap hpa where hpa.employee_id !='$userId' and hpa.employee_id in (select userid from users where position!='Chief') and hpa.FY='$fy' and (hpa.hr_office_emp_approval is null or hpa.hr_office_emp_approval='')");

if($position=="Chief") {
$checkCompletedPerfomanceConfirm=mysqli_query($conn,"SELECT *,( select concat(firstname,' ',lastname) from users where userid=hpa.employee_id) as empname  FROM hr_performance_ap hpa where hpa.employee_id !='$userId' and hpa.FY='$fy' and (hpa.hr_office_emp_approval is null or hpa.hr_office_emp_approval='')");
}
if(mysqli_num_rows($checkCompletedPerfomanceConfirm)) {	
	
print("<br /><br /><fieldset> 
<legend>REQUIRED CONFIRMATIONS</legend>
<table width='100%' class='tablelist' id='dynamic_field'><thead>
<tr>
<th>Names</th>
<th>Score</th>
<th>Employee Confirmation</th>
<th>Employee Confirmation Date</th>
<th>Supervisor Confirmation</th>
<th>Supervisor Confirmation Date</th>
<th>Head Confirmation</th>
<th>Head Confirmation Date</th>
<th>HR Confirmation</th>
<th>HR Confirmation Date</th>
<th>Show details</th>
<th>Confirm</th>
</tr></thead>");

while($confirmRow=mysqli_fetch_array($checkCompletedPerfomanceConfirm)){
	$names=$confirmRow['empname'];
	$employeeid=$confirmRow['employee_id'];
	$score=$confirmRow['score'];
	$supervisor_id=$confirmRow['supervisor_id'];
$employee_accept=$confirmRow['employee_accept'];
$employee_accept_date=$confirmRow['employee_accept_date'];
$supervisor_accept=$confirmRow['supervisor_accept'];
$supervisor_accept_date=$confirmRow['supervisor_accept_date'];
$head_of_dpt_approval=$confirmRow['head_of_dpt_approval'];
$head_of_dpt_date=$confirmRow['head_of_dpt_date'];
$hr_office_emp_approval=$confirmRow['hr_office_emp_approval'];
$hr_office_emp_approval_date=$confirmRow['hr_office_emp_approval_date'];
print("<tr>
<td>$names</td>
<td><b>$score</b></td>
<td>$employee_accept</td>
<td>$employee_accept_date</td>
<td>$supervisor_accept</td>
<td>$supervisor_accept_date</td>
<td>$head_of_dpt_approval</td>
<td>$head_of_dpt_date</td>
<td>$hr_office_emp_approval</td>
<td>$hr_office_emp_approval_date</td>
<td>
<form action='showtargets.php' method='post'>
<input type='hidden' name='fy' value='$fy'>
<input type='hidden' name='employeeid' value='$employeeid'>
<input type='submit' name='show' value='Show' class='hrbutton'></form>
</td>
<td>

<form action='confirmhrlevel.php' method='post'>
<input type='hidden' name='fy' value='$fy'><input type='hidden' name='employee_id' value='$employeeid'><input type='hidden' name='supervisor_id' value='$supervisor_id'>

<!-- <select name='confirm'>
<option value='YES'>YES</option>
<option value='DENIED'>DENIED</option>
</select> -->
<!-- <input type='submit' value='CONFIRM' onclick=\"this.disabled=true; this.value='Please wait...'; document.getElementById('perfomanceconfirmID').click();\" class='hrbutton'> -->
<input type='submit' name='perfomanceconfirm' value='CONFIRM' id='perfomanceconfirmID' class='hrbutton'></div>
</form>


</td>
</tr>");

}
print("</table></fieldset>");
}


print("<br /> <hr />");

//Display only
// perfomance confirm

$position=$_SESSION['position'];
// perfomance confirm
$checkCompletedPerfomanceConfirm=mysqli_query($conn,"SELECT *,( select concat(firstname,' ',lastname) from users where userid=hpa.employee_id) as empname  FROM hr_performance_ap hpa where hpa.FY='$fy' and hpa.employee_id in (select userid from users where position!='Chief') and hpa.hr_office_emp_approval is not null");

if($position=="Chief") {
$checkCompletedPerfomanceConfirm=mysqli_query($conn,"SELECT *,( select concat(firstname,' ',lastname) from users where userid=hpa.employee_id) as empname  FROM hr_performance_ap hpa where hpa.FY='$fy' and hpa.hr_office_emp_approval is not null");
}


if(mysqli_num_rows($checkCompletedPerfomanceConfirm)) {	
	
print("<br />
<fieldset> 
<legend>ALREADY CONFIRMED</legend>
<table width='100%' class='tablelist' id='dynamic_field'><thead>
<tr>
<th>Names</th>
<th>Score</th>
<th>Employee Confirmation</th>
<th>Employee Confirmation Date</th>
<th>Supervisor Confirmation</th>
<th>Supervisor Confirmation Date</th>
<th>Head Confirmation</th>
<th>Head Confirmation Date</th>
<th>HR Confirmation</th>
<th>HR Confirmation Date</th>
<th>Show details</th>
</tr></thead>");

while($confirmRow=mysqli_fetch_array($checkCompletedPerfomanceConfirm)){
	$names=$confirmRow['empname'];
	$employeeid=$confirmRow['employee_id'];
	$score=$confirmRow['score'];
$employee_accept=$confirmRow['employee_accept'];
$employee_accept_date=$confirmRow['employee_accept_date'];
$supervisor_accept=$confirmRow['supervisor_accept'];
$supervisor_accept_date=$confirmRow['supervisor_accept_date'];
$head_of_dpt_approval=$confirmRow['head_of_dpt_approval'];
$head_of_dpt_date=$confirmRow['head_of_dpt_date'];
$hr_office_emp_approval=$confirmRow['hr_office_emp_approval'];
$hr_office_emp_approval_date=$confirmRow['hr_office_emp_approval_date'];
print("<tr>
<td>$names</td>
<td><b>$score</b></td>
<td>$employee_accept</td>
<td>$employee_accept_date</td>
<td>$supervisor_accept</td>
<td>$supervisor_accept_date</td>
<td>$head_of_dpt_approval</td>
<td>$head_of_dpt_date</td>
<td>$hr_office_emp_approval</td>
<td>$hr_office_emp_approval_date</td>
<td>
<form action='showtargets.php' method='post'>
<input type='hidden' name='fy' value='$fy'>
<input type='hidden' name='employeeid' value='$employeeid'>
<input type='submit' name='show' value='Show' class='hrbutton'></form>
</td>
</tr>");

}
print("</table></fieldset>");
}


print("</div>");

	
//}

?>





</div>
</center>





</body>
</html>