settings.php

<?php
include "home.php";
?>
<?php
// $role=$_SESSION['hrrolesession'];
// if(strpos($role,"hrsadmin") == 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>
<h1>Settings<h2>
<br/>



<form action="settings.php" method="post">
<fieldset>
<legend>Reset Performance Appraisal</legend>
<table>
<tr>
<td>Employee:</td>
<td><select name="employee">
<option value="" selected="">-- Select employee--</option> <?php
include("connect.php");
$employeesqueryActive=mysqli_query($conn,"select userid,concat(lastname,' ',firstname) as empName  from users where active='YES' 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>");
}
}
?></select></td>
</tr>
<tr>
<td>FY:</td>
<td><select name="fy">
<option value="" selected="">-- Select FY--</option> <?php
include("connect.php");
$fys=mysqli_query($conn,"select distinct FY from hr_performance_ap_targets order by FY");
if(mysqli_num_rows($fys)) {
while($row=mysqli_fetch_array($fys)){
$name=$row['FY'];
print("<option value='$name'>$name</option>");
}
}
?></select></td>
</tr>
<tr>
<td>To which level </td>
<td><select name="level">
<option value="confirmations">CONFIRMATIONS</option>
<option value="devplan">EMPLOYEE DEVELOPMENT PLAN</option>
<option value="conducts">EMPLOYEE CONDUCT</option>
<option value="chalengeAndStrengths">EMPLOYEE STRENGTHS AND CHALLENGES</option>
<option value="chalenges">CHALLENGES</option>
<option value="targets">TARGETS</option>


</select></td>
</tr>
</table>
</fieldset>
<br />
<div style="text-align: center;">
<input type='submit' value='Reset PA' onclick="this.disabled=true; this.value='Please wait...'; document.getElementById('resetpaid').click();" class='hrbutton'>
<input type='submit' name='resetpa' value='Reset PA' id='resetpaid'  style='display:none;' class='hrbutton'>
</div>
</form>






<form action="settings.php" method="post">
<fieldset>
<legend>Set appraisal window</legend>
<table>
<tr>
<td>Start Date: </td>
<td><input type="text" name="startDate" id="startDate"></td>
</tr>
<tr>
<td>End Date: </td>
<td><input type="text" name="endDate" id="endDate"></td>
</tr>
</table>
</fieldset>
<br />
<div style="text-align: center;">
<input type='submit' value='Set Window' onclick="this.disabled=true; this.value='Please wait...'; document.getElementById('requestid').click();" class='hrbutton'>
<input type='submit' name='save' value='Set Window' id='requestid'  style='display:none;' class='hrbutton'>
</div>
</form>
<!-- Reset PA -->

<?php
include "connect.php";
if(isset($_POST['resetpa'])){	
include 'createEmail.php';
$employeeid=$_POST['employee'];
$fy=$_POST['fy'];
$level=$_POST['level'];

if($level==="targets") {
$updatetarges=mysqli_query($conn,"update hr_performance_ap_targets set accomplished=null,score=null,scorecomment=null where employee_id='$employeeid' and fy='$fy'");
$deletechallenge=mysqli_query($conn,"delete from hr_performance_ap_challenges where employee_id='$employeeid' and fy='$fy'");
$deletechallengeovercome=mysqli_query($conn,"delete from hr_performance_ap_challenges_overcome where employee_id='$employeeid' and fy='$fy'");
$deletechallengeandstrength=mysqli_query($conn,"delete from hr_performance_ap_strength_challenges_overcome where employee_id='$employeeid' and fy='$fy'");
$deleteconducts=mysqli_query($conn,"delete from hr_performance_ap_conduct where employee_id='$employeeid' and fy='$fy'");
$deletedevplan=mysqli_query($conn,"delete from hr_performance_ap_dev_plan where employee_id='$employeeid' and fy='$fy'");
$deleteconfirmations=mysqli_query($conn,"delete from hr_performance_ap where employee_id='$employeeid' and fy='$fy'");
}
if($level==="chalenges") {
$deletechallenge=mysqli_query($conn,"delete from hr_performance_ap_challenges where employee_id='$employeeid' and fy='$fy'");
$deletechallengeovercome=mysqli_query($conn,"delete from hr_performance_ap_challenges_overcome where employee_id='$employeeid' and fy='$fy'");
$deletechallengeandstrength=mysqli_query($conn,"delete from hr_performance_ap_strength_challenges_overcome where employee_id='$employeeid' and fy='$fy'");
$deleteconducts=mysqli_query($conn,"delete from hr_performance_ap_conduct where employee_id='$employeeid' and fy='$fy'");
$deletedevplan=mysqli_query($conn,"delete from hr_performance_ap_dev_plan where employee_id='$employeeid' and fy='$fy'");
$deleteconfirmations=mysqli_query($conn,"delete from hr_performance_ap where employee_id='$employeeid' and fy='$fy'");
}
if($level==="chalengeAndStrengths") {
$deletechallengeandstrength=mysqli_query($conn,"delete from hr_performance_ap_strength_challenges_overcome where employee_id='$employeeid' and fy='$fy'");
$deleteconducts=mysqli_query($conn,"delete from hr_performance_ap_conduct where employee_id='$employeeid' and fy='$fy'");
$deletedevplan=mysqli_query($conn,"delete from hr_performance_ap_dev_plan where employee_id='$employeeid' and fy='$fy'");
$deleteconfirmations=mysqli_query($conn,"delete from hr_performance_ap where employee_id='$employeeid' and fy='$fy'");
}
if($level==="conducts") {
$deleteconducts=mysqli_query($conn,"delete from hr_performance_ap_conduct where employee_id='$employeeid' and fy='$fy'");
$deletedevplan=mysqli_query($conn,"delete from hr_performance_ap_dev_plan where employee_id='$employeeid' and fy='$fy'");
$deleteconfirmations=mysqli_query($conn,"delete from hr_performance_ap where employee_id='$employeeid' and fy='$fy'");
}
if($level==="devplan") {
$deletedevplan=mysqli_query($conn,"delete from hr_performance_ap_dev_plan where employee_id='$employeeid' and fy='$fy'");
$deleteconfirmations=mysqli_query($conn,"delete from hr_performance_ap where employee_id='$employeeid' and fy='$fy'");
}
if($level==="confirmations") {
$deleteconfirmations=mysqli_query($conn,"delete from hr_performance_ap where employee_id='$employeeid' and fy='$fy'");
}

$reqError=mysqli_error($conn);
if(($reqError==null || $reqError=="")) {	
$receivers=mysqli_query($conn,"select email from users where userid='$employeeid'");
$names= $_SESSION['firstnamesession']." ".$_SESSION['lastnamesession'];
$subject="Reset on your Appraisal of $fy";
$message="We would like to notify you that <b>".$names."</b> did reset on your appraisal of  $fy  to the level of $level . ";
while($rowrec=mysqli_fetch_array($receivers)){	
	$receverEmail=$rowrec['email'];
	sendEmail($receverEmail,$subject,$message);
}
$receiversSupervisor=mysqli_query($conn,"select email,(select concat(lastname,' ',firstname) from users where userid='$employeeid') as empName from users where userid in (select supervisor from users where userid='$employeeid')");
$rowrecsup=mysqli_fetch_array($receiversSupervisor);
$receversupEmail=$rowrecsup['email'];
$empName=$rowrecsup['empName'];
$subject="Reset of Appraisal of your supervisee";
$message="We would like to notify you that <b>".$names."</b> did reset on the appraisal of  $fy  to the level of $level . Please seat with $empName for correction";
sendEmail($receversupEmail,$subject,$message);
print("
<script>
alert('Performance Appraisal reset is done');
</script>
");
}
}
?>

<!-- End reset PA -->


<?php
include "connect.php";
if(isset($_POST['save'])){	
include 'createEmail.php';
$employeeid=$_SESSION['hruseridsession'];
$startDate=$_POST['startDate'];
$endDate=$_POST['endDate'];
$startDate=$startDate." 00:00:00";
$endDate=$endDate." 23:59:59";
$requesteddate=date("Y-m-d");
$changeappraisalwindow=mysqli_query($conn,"update hr_performance_ap_window set startdate='$startDate',enddate='$endDate'");
$reqError=mysqli_error($conn);
if(($reqError==null || $reqError=="")) {	
$receivers=mysqli_query($conn,"select email from users where active='YES'");
$names= $_SESSION['firstnamesession']." ".$_SESSION['lastnamesession'];
$subject="Notification on Appraisal window";
$message="We would like to notify you that <b>".$names."</b> has updated the appraisal window (from: <b>".$startDate."</b> to: <b>".$endDate."</b> ). You can <b>start</b> or <b>update</b> the performance appraisal for you or for your supervisee based on the mentioned start date and end date";
while($rowrec=mysqli_fetch_array($receivers)){	
	$receverEmail=$rowrec['email'];
	sendEmail($receverEmail,$subject,$message);
}

print("
<script>
alert('Window is changed successfully');
</script>
");
}
}
?>
<!-- Window -->
<?php
include "connect.php";
$employeeid=$_SESSION['hruseridsession'];
$window=mysqli_query($conn,"select *  from hr_performance_ap_window");
if(mysqli_num_rows($window)) {
print("<br /><fieldset> 
<legend>Performance appraisal window</legend>
<table width='100%' class='tablelist' id='dynamic_field'><thead>
<tr>
<th>Start Date</th>
<th>End Date</th>
</tr></thead>");
while($row=mysqli_fetch_array($window)){
	$start_date=$row['startdate'];
	$end_date=$row['enddate'];
print("<tr>
<td>$start_date</td>
<td>$end_date</td>
</tr>");

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

<br/>
<form action="settings.php" method="post">
<fieldset>
<legend>Clean All Permission days</legend>
<div style="text-align: center;">
<input type='submit' value='Make them Zero' onclick="this.disabled=true; this.value='Please wait...'; document.getElementById('cleanid').click();" class='hrbutton'>
<input type='submit' name='cleanpermissions' value='Make them Zero' id='cleanid'  style='display:none;' class='hrbutton deletebtn'>
</div>
</fieldset>
</form>
<?php
include "connect.php";
if(isset($_POST['cleanpermissions'])){	
include 'createEmail.php';
$employeeid=$_SESSION['hruseridsession'];
$cleanpermission=mysqli_query($conn,"update hr_employee_leave_days set number_of_days='0' where leave_type='Permission'");
$reqError=mysqli_error($conn);
if(($reqError==null || $reqError=="")) {	
print("
<script>
alert('All Permission days are all cleaned');
</script>
");
}
}
?>

     
<!-- Save outstanding leave -->     
     
    <?php
include "connect.php";
if(isset($_POST['saveoutstanding'])){	
include 'createEmail.php';
$creator=$_SESSION['hruseridsession'];
$fy=$_POST['fy'];
$leave_type=$_POST['leavetype'];
$startDate=$startDate." 00:00:00";
$endDate=$endDate." 23:59:59";
$requesteddate=date("Y-m-d");

$employeeleaveschecks=mysqli_query($conn,"select * from hr_outstanding_leave where leave_type='$leave_type' and fy='$fy' ");


if(mysqli_num_rows($employeeleaveschecks) == 0) {
$employeeleaves=mysqli_query($conn,"select number_of_days,employee_id from hr_employee_leave_days where leave_type='$leave_type'");

if(mysqli_num_rows($employeeleaves)) {
while($row=mysqli_fetch_array($employeeleaves)){	
$employee_id=$row['employee_id'];
$number_of_days=$row['number_of_days'];
$saveoutstanding=mysqli_query($conn,"INSERT INTO hr_outstanding_leave (employee_id, fy, leave_type, days, date_created, creator) VALUES('$employee_id','$fy','$leave_type','$number_of_days',now(),'$creator')");

print(mysqli_error($saveoutstanding));
}
print("
<script>
alert('Outstanding  $leave_type in $fy is saved');
</script>
");
}
}else {
print("
<script>
alert('This Outstanding  of $leave_type in $fy exist');
</script>
");
}
}

?> 


<!-- allow or stop allocations -->     
     
    <?php
if(isset($_POST['confirm'])){	
include "connect.php";
$creator=$_SESSION['hruseridsession'];
$employee=$_POST['employee'];
$lleaveAllocationAllowed=$_POST['leaveAllocationAllowed'];
$allowStopAllocation=mysqli_query($conn,"update users set leaveAllocationAllowed='$lleaveAllocationAllowed' where userid='$employee'");
print("
<script>
alert('Information is updated');
</script>
");
}
?> 
     
    <!-- Swap supervisors -->     
     
    <?php
if(isset($_POST['changesup'])){	
include "connect.php";
$creator=$_SESSION['hruseridsession'];
$currsup=$_POST['currsup'];
$newsup=$_POST['newsup'];
$allowStopAllocation=mysqli_query($conn,"update users set supervisor='$newsup' where supervisor='$currsup'");
print("
<script>
alert('Information is updated');
</script>
");
}
?>  
     
                			
                			
<form action="settings.php" method="post">
<fieldset>
<legend>SAVE OUTSTANDING LEAVE</legend>
<table>
<tr>
<td>FY:</td>
<td><select name="fy">
<option value="" selected="">-- Select FY--</option> <?php
include("connect.php");
$employeeLeaveTypes=mysqli_query($conn,"select distinct fy from hr_employee_leave_allocation order by fy");
if(mysqli_num_rows($employeeLeaveTypes)) {
while($row=mysqli_fetch_array($employeeLeaveTypes)){
$name=$row['fy'];
print("<option value='$name'>$name</option>");
}
}
?></select></td>
</tr>
<tr>
<td>LEAVE TYPE: </td>
<td><select name="leavetype">
<option value="" selected="">-- Select leave type--</option> <?php
include("connect.php");
$employeeLeaveTypes=mysqli_query($conn,"select name from hr_employee_leave_type order by name");
if(mysqli_num_rows($employeeLeaveTypes)) {
while($row=mysqli_fetch_array($employeeLeaveTypes)){
$name=$row['name'];
print("<option value='$name'>$name</option>");
}
}
?></select></td>
</tr>
</table>
</fieldset>
<br />
<div style="text-align: center;">
<input type='submit' value='Save Outstanding' onclick="this.disabled=true; this.value='Please wait...'; document.getElementById('saveoutstandingid').click();" class='hrbutton'>
<input type='submit' name='saveoutstanding' value='Save Outstanding' id='saveoutstandingid'  style='display:none;' class='hrbutton'>
</div>
</form>



               			
                			
<form action="settings.php" method="post">
<fieldset>
<legend>SEND EMPLOYEE TO PIP</legend>
<table>
<tr>
<td>Employee: </td>
<td><select name="employee"><option value="" selected="">-- Select employee--</option> <?php
include("connect.php");
$employeesqueryActive=mysqli_query($conn,"select userid,concat(lastname,' ',firstname) as empName  from users where userid in (SELECT employee_id FROM hr_performance_ap where employee_accept='DENIED' or score<=2) 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>");
}
}
?></select></td>
</tr>
<tr>
<td>FY:</td>
<td><select name="fy">
<option value="" selected="">-- Select FY--</option> <?php
include("connect.php");
$fy=mysqli_query($conn,"select distinct FY from hr_performance_ap order by FY");
if(mysqli_num_rows($fy)) {
while($row=mysqli_fetch_array($fy)){
$name=$row['FY'];
print("<option value='$name'>$name</option>");
}
}
?></select></td>
</tr>

</table>
</fieldset>
<br />
<div style="text-align: center;">
<input type='submit' value='Send to PIP' onclick="this.disabled=true; this.value='Please wait...'; document.getElementById('sendTopipid').click();" class='hrbutton'>
<input type='submit' name='sendtopip' value='Send to PIP' id='sendTopipid'  style='display:none;' class='hrbutton'>
</div>
</form>




               			
                			
<form action="settings.php" method="post">
<fieldset>
<legend>STOP/ALLOW ALLOCATIONS ON EMPLOYEE</legend>
<table>
<tr>
<td>Employee: </td>
<td><select name="employee"><option value="" selected="">-- Select employee--</option> <?php
include("connect.php");
$employeesqueryActive=mysqli_query($conn,"select userid,concat(lastname,' ',firstname) as empName  from users where active='YES' 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>");
}
}
?></select></td>
</tr>
<tr>
<td>IS ALLOCATION ACCEPTED?</td>
<td><select name="leaveAllocationAllowed">
<option value="YES">YES</option> 
<option value='NO'>NO</option></select></td>
</tr>

</table>
</fieldset>
<br />
<div style="text-align: center;">
<input type='submit' value='CONFIRM' onclick="this.disabled=true; this.value='Please wait...'; document.getElementById('confirmid').click();" class='hrbutton'>
<input type='submit' name='confirm' value='CONFIRM' id='confirmid'  style='display:none;' class='hrbutton'>
</div>
</form>




                			
<form action="settings.php" method="post">
<fieldset>
<legend>Change Supervisor once</legend>
<table>
<tr>
<td>Current Supervisor: </td>
<td><select name="currsup"><option value="" selected="">-- Select Supervisor--</option> <?php
include("connect.php");
$employeesqueryActive=mysqli_query($conn,"select userid,concat(lastname,' ',firstname) as empName  from users where active='YES' and role like '%supervisor%' 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>");
}
}
?></select></td>
</tr>
<tr>
<td>New Supervisor: </td>
<td><select name="newsup"><option value="" selected="">-- Select Supervisor--</option> <?php
include("connect.php");
$employeesqueryActive=mysqli_query($conn,"select userid,concat(lastname,' ',firstname) as empName  from users where active='YES' and role like '%supervisor%' 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>");
}
}
?></select></td>
</tr>

</table>
</fieldset>
<br />
<div style="text-align: center;">
<input type='submit' value='CHANGE SUP.' onclick="this.disabled=true; this.value='Please wait...'; document.getElementById('changesupid').click();" class='hrbutton'>
<input type='submit' name='changesup' value='CHANGE SUP' id='changesupid'  style='display:none;' class='hrbutton'>
</div>
</form>