employeeTargetsAccomplishmentpip.php

<?php
include "home.php";
?>
<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>


<?php

include("connect.php");
$userId=$_SESSION['hruseridsession'];

$reqList=mysqli_query($conn,"SELECT *,(select GROUP_CONCAT(firstname,' ',lastname) from users u where u.userid = t.employee_id) as employee  FROM hr_pip_ap_targets t where t.employee_id='$userId' group by t.employee_id,t.fy");
if(mysqli_num_rows($reqList)) {
	print("<table><tr>");

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

print("<td>
<form action='employeeCheckAllAppraisals.php' method='post'>
<input type='hidden' name='fy' value='$fy'>
<input type='hidden' name='employeeid' value='$employeeid'>
<input type='submit' name='showselected' value='$fy' class='hrbutton'>");
print("</form>
</td>");
}
print("</tr></table>");
}else {
print("<br>targets not yet recorded");
}
?>





<h1>EMPLOYEE SELF-ASSESSMENT ON Performance Improvement Plan (PIP) <br/><br/> <b><i>ISUZUMA MIKORERE RY'INYONGERA UMUKOZI YIKORERA KU GITI CYE</i></b><h1>
<br/>







<?php
if(isset($_POST['perfomanceconfirm'])){
include("connect.php");
include 'createEmail.php';
$employee_id=$_POST['employee_id'];
$fy=$_POST['fy'];
$confirm=$_POST['confirm'];
$tscore="";
$totalscore=mysqli_query($conn,"SELECT ((((SELECT (SUM(score)/(count(target_id)*5))*60 as scoredintarget FROM hr_pip_ap_targets where employee_id='$employee_id' and FY='$fy' and (accomplished='Fully Accomplished' or accomplished='Partially Accomplished') and score is not null) + (SELECT (SUM(score)/25)*40 as scoredinconduct FROM hr_performance_ap_conduct where employee_id='$employee_id' and FY='$fy' and score is not null))/100)*5) as totalscore");
if(mysqli_num_rows($totalscore)) {
$rowscore=mysqli_fetch_array($totalscore);	
	$tscore=$rowscore['totalscore'];
	$tscore=round($tscore,0);	
}
if($tscore!="" && $tscore!=null) {
$insertconfirmationOfEmployee=mysqli_query($conn,"insert into hr_performance_ap (FY,employee_id,score,employee_accept,employee_accept_date) values('$fy','$employee_id','$tscore','$confirm',now())");
$reqError=mysqli_error($conn);

if($reqError==null || $reqError=="") {
	
$receivers=mysqli_query($conn,"select email from users  where userid in (select supervisor from users  where userid='$employee_id')");
$names= $_SESSION['firstnamesession']." ".$_SESSION['lastnamesession'];
$subject="CONFIRMATION OF PA from your Supervisee ";
$message="We would like to notify you that your Supervisee(<b>".$names."</b>) confirm a performance appraisal."."<br/><br/> <font color=red><strong> Please approve this PA and set the new targets for the upcoming(New) fiscal year.</strong></font>";

while($rowrec=mysqli_fetch_array($receivers)){	
	$receverEmail=$rowrec['email'];
	sendEmail($receverEmail,$subject,$message);
}

if($confirm=="DENIED") {
$receivers=mysqli_query($conn,"select email from users  where role like '%hradmin%'");
$names= $_SESSION['firstnamesession']." ".$_SESSION['lastnamesession'];
$subject="Denial OF PA";
$message="We would like to notify you that the employee(<b>".$names."</b>) denied a performance appraisal (".$fy.").";

while($rowrec=mysqli_fetch_array($receivers)){	
	$receverEmail=$rowrec['email'];
	sendEmail($receverEmail,$subject,$message);
}
}
	
print("
<script>
alert('Thank you for this confirmation');
</script>");	
}
}

}
?>



<?php
if(isset($_POST['edit'])){
include("connect.php");
$target_id=$_POST['target_id'];
$userId=$_SESSION['hruseridsession'];
$targetq=mysqli_query($conn,"SELECT * FROM hr_pip_ap_targets where target_id='$target_id' and supervisor_id='$userId'");
$row=mysqli_fetch_array($targetq);
$target_id=	$row['target_id'];
$date_submited=$row['date_submited'];
$FY=$row['FY'];
$employee_id=$row['employee_id'];
$supervisor_id=$row['supervisor_id'];
$target=$row['target'];
$indicator=$row['indicator'];
$timing=$row['timing'];
$comment=$row['comments'];

print("
<form action='showtargets.php' method='post'>
<table class='tablelist'><thead>
<tr>  <th>PLANNED ACTIVITIES/TARGETS</th>
<th>PERFORMANCE INDICATORS</th>
<th>TIMING OF THE ACTIVITY PER SET TARGET</th>
<th>COMMENTS / OBSERVATIONS</th>                                 
       </tr> </thead>  
      <tr>  
                  <td><input type='hidden' name='target_id' value='$target_id'><input type='hidden' name='fy' value='$FY'><input type='hidden' name='employee_id' value='$employee_id'>
                  
                  
<textarea name=target size=10 rows=4 cols=30>$target</textarea></td>
   <td><textarea name=indicator size=10 rows=4 cols=30>$indicator</textarea></td>
                  <td><input type=text name=timing  size=10 value='$timing' ></td>	
                  <td><textarea name=comment size=10 rows=4 cols=30>$comment</textarea></td>   
						
						                                  
                                  </tr>  
</table>

<div style='text-align: center;'><input type='submit' name='edittarget' value='Save' class='hrbutton'></div>
</form>
");


}
?>



<?php
if(isset($_POST['edittarget'])){
include("connect.php");
$target_id=$_POST['target_id'];
$fy=$_POST['fy'];
$employee_id=$_POST['employee_id'];
$target=$_POST['target'];
$indicator=$_POST['indicator'];
$timing=$_POST['timing'];
$comment=$_POST['comment'];

$updateTargetquery=mysqli_query($conn,"update hr_pip_ap_targets set target='$target',indicator='$indicator', timing='$timing', comments='$comment' where target_id='$target_id'");

showRequest($fy,$employee_id);

}
?>

<!-- Delete procurement request item -->

<?php
if(isset($_POST['accomplished'])){
include("connect.php");
$target_id=$_POST['target_id'];
$employee_id=$_POST['employee_id'];
$accomplishedOption=$_POST['accomplishedOption'];

$fy=$_POST['fy'];
$deleteRequestitemquery=mysqli_query($conn,"update hr_pip_ap_targets set accomplished='$accomplishedOption' where target_id='$target_id'");
//showRequest($fy,$employee_id);
}
?>

<?php
if(isset($_POST['accept'])){
include("connect.php");
$target_id=$_POST['target_id'];
$employee_id=$_POST['employee_id'];
$fy=$_POST['fy'];
$deleteRequestitemquery=mysqli_query($conn,"update hr_pip_ap_targets set employee_accept='YES' where target_id='$target_id'");
//showRequest($fy,$employee_id);
}
?>


<!-- Add notices -->


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

$fy=$_POST['fy'];
$employee_id=$_POST['employee_id'];
$supervisor_id=$_POST['supervisor_id'];
$challenges=$_POST['challenges'];
$overcome=mysqli_real_escape_string($conn,$_POST['overcome']);


$insertchallengeError="";
$insertovercomeError="";
foreach ($challenges as &$challengevalue) {
$challenge=mysqli_real_escape_string($conn,$challengevalue);
$addChallenge=mysqli_query($conn,"insert into hr_performance_ap_challenges(FY,employee_id,challenge,recorded_date) values('$fy','$employee_id','$challenge',now())");
$reqError=mysqli_error($conn);
if($reqError!==null && $reqError!=="") {
$insertchallengeError=$reqError;
}
}
$addOvercome=mysqli_query($conn,"insert into hr_performance_ap_challenges_overcome(FY,employee_id,overcome,recorded_date) values('$fy','$employee_id','$overcome',now())");
$reqError=mysqli_error($conn);
if($reqError!==null && $reqError!=="") {
$insertovercomeError=$reqError;
}
// Star Email


if($insertchallengeError=="" && $insertovercomeError=="") {
	$names=$_SESSION['firstnamesession']." ".$_SESSION['lastnamesession'];	

$receivers=mysqli_query($conn,"select distinct email from users where userid='$supervisor_id'");


$subject="Challenges have been submitted by your Supervisee ";
$message="We would like to notify you that, ".$names.", submitted challenges in the performance appraisal process of".$fy;

while($rowrec=mysqli_fetch_array($receivers)){	
	$receverEmail=$rowrec['email'];
	sendEmail($receverEmail,$subject,$message);
}


}
// End Email

}
?>


<!-- List targerts -->




<?php
include("connect.php");
$employeeid=$_SESSION['hruseridsession'];
$fy="FY".  (date('y'));
$supervisor_id="";

$allowChange=0;
$checkAppraisalwindow=mysqli_query($conn,"select * from hr_performance_ap_window where startdate<=now() and enddate>=now()");
if(mysqli_num_rows($checkAppraisalwindow)) {	
$allowChange=1;
}


	
$targetsList=mysqli_query($conn,"SELECT * FROM hr_pip_ap_targets where employee_id='$employeeid' and FY='$fy' order by target_id");
if(mysqli_num_rows($targetsList)) {	
print("<h5>ACCOMPLISHMENTS: $fy</h5>");
print("<div style='text-align: left;margin-left: 80px'>What were the  set targets and the level of accomplishments in the last fiscal year?<br />
<b><i>Ni iyihe mihigo wabashije kwesa muri uyu mwaka twasoje wa $fy ?</i></b>
<br /><br />");

	print("<center><table width='100%' class='tablelist'><thead><tr>
	
	
<th>PLANNED ACTIVITIES/TARGETS <br /> <b><i>GAHUNDA Y’IBIKORWA BY’UMUKOZI</i></b></th>
<th>PERFORMANCE INDICATORS<br /> <b><i>IBIPIMO FATIZO BY’IBIKORWA</i></b></th>
<th>TIMING OF THE ACTIVITY PER SET TARGET <br /> <b><i>IGIHE IGIKORWA KIZAKORERWAMO</i></b></th>
<th>COMMENTS / OBSERVATIONS <br /> <b><i>ICYONGERWAHO</i></b></th>
<th>DATE CREATED<br /> <b><i>ITARIKI YINJIRIJWEHO</i></b></th>
<th>SCORE<br /> <b><i>AMANOTA</i></b></th>
<th>Accepted?<br /> <b><i>WARAYEMEYE?</i></b></th>
<th>Accomplished?<br /> <b><i>WARAYIRANGIJE?</i></b></th>
</tr></thead>");
while($row1=mysqli_fetch_array($targetsList)){
$target_id=	$row1['target_id'];
$date_submited=$row1['date_submited'];
$FY=$row1['FY'];
$employee_id=$row1['employee_id'];
$supervisor_id=$row1['supervisor_id'];
$target=$row1['target'];
$indicator=$row1['indicator'];
$timing=$row1['timing'];
$comments=$row1['comments'];
$accomplished=$row1['accomplished'];
$score=$row1['score'];
$employee_accept=$row1['employee_accept'];

print("
<tr>
<td>$target</td>
<td>$indicator</td>
<td>$timing</td>
<td>$comments</td>
<td>$date_submited</td>
<td>$score</td><td>");
if(strlen($employee_accept)==0){
print("<form action='employeeTargetsAccomplishmentpip.php' method='post'>
<input type='hidden' name='target_id' value='$target_id'><input type='hidden' name='fy' value='$FY'><input type='hidden' name='employee_id' value='$employee_id'>
");
print("<input type='submit' name='accept' value='Accept' class='hrbutton'></form>");
}else {
print("$employee_accept");
}

print("
</td><td>");


if(strlen($accomplished)==0 && strlen($employee_accept)!=0  && $allowChange==1){
print("<form action='employeeTargetsAccomplishmentpip.php' method='post'>
<input type='hidden' name='target_id' value='$target_id'><input type='hidden' name='fy' value='$FY'><input type='hidden' name='employee_id' value='$employee_id'>
<select name='accomplishedOption'>
<option value='Fully Accomplished'>Fully Accomplished</option>
<option value='Partially Accomplished'>Partially Accomplished</option>
<option value='Not Accomplished'>Not Accomplished</option>
</select>
");
print("<input type='submit' name='accomplished' value='Confirm' class='hrbutton'></form>");
}else {
print("$accomplished");
}


print("</td></tr>");




}
print("</center></table></div><br><br>");
}else {
print("<div style='text-align: left;margin-left: 80px'>Waiting for Supervisor to set targets for $fy or HR did not send you to PIP ............. <br /><br />");


}	



print("</div>");


?>




<!-- </div> -->






</body>
</html>