<table>
<?php
$query = mysql_query("SELECT * FROM appraisals INNER JOIN employees_appraisals ON appraisals.Appraisals_ID = employees_appraisals.Appraisals_ID WHERE employees_appraisals.Employees_ID='{$userids}' ORDER BY appraisals.Date_in DESC");
$amount = mysql_num_rows($query);
$leave = getleaveamount($userids);
if (empty($amount) == true) {
echo '<tr><th>No appraisal yet</th></tr>';
echo '<tr><td> <br/> </td></tr>';
$Q1 = 0;
$Q2 = 0;
$Q3 = 0;
$Q4 = 0;
$Q5 = 0;
} else {
$result = mysql_result($query, 0);
$Q1 = mysql_result($query, 0, "Q1") * 10;
$Q2 = mysql_result($query, 0, "Q2") * 10;
$Q3 = mysql_result($query, 0, "Q3") * 10;
$Q4 = mysql_result($query, 0, "Q4") * 10;
$Q5 = mysql_result($query, 0, "Q5") * 10;
echo '<tr><th>Effort Rate</th></tr><tr><td><div class="progress">
<div class="progress-bar" role="progressbar" aria-valuenow="60" aria-valuemin="0" aria-valuemax="100" style="width:' . $Q1 . '%">' . mysql_result($query, 0, "Q1") . '/10
</div>
</div>
</td><tr>';
echo '<tr><th>Meeting Attendance Rate</th></tr><tr><td><div class="progress">
<div class="progress-bar" role="progressbar" aria-valuenow="60" aria-valuemin="0" aria-valuemax="100" style="width:' . $Q2 . '%">' . mysql_result($query, 0, "Q2") . '/10
</div>
</div>
</td><tr>';
echo '<tr><th>Workdone Attendance Rate</th></tr><tr><td><div class="progress">
echo $email;
?>
<li><b>Gender :</b>
<?php
$gender = getuserdetails($result['Employees_ID'], 'Gender');
echo $gender;
?>
<li><b>Department :</b>
<?php
$depart = getdepartmentname(getdepartmentID($result['Employees_ID']));
echo $depart;
?>
</li>
<?php
$leave = getleaveamount($result['Employees_ID']);
?>
<div class="progress">
<div class="progress-bar" role="progressbar" aria-valuenow="<?php
$leavebar = round($leave / 14 * 100);
echo $leavebar;
?>
" aria-valuemin="0" aria-valuemax="100" style="width: <?php
$leavebar = $leave / 14 * 100;
echo $leavebar;
?>
%">
<?php
echo $leave . "/14 leaves";
?>
</div>
</th>
<th>
Approval
</th>
</tr>
<?php
if (getuserdetails($userid, 'Privilege') == "supervisor") {
$query = mysql_query("SELECT * \nFROM employees_leave\nWHERE Employees_ID\nIN (\n\nSELECT Employees_ID\nFROM employees_department\nWHERE Department_ID\nIN (\n\nSELECT Department_ID\nFROM department\nWHERE Supervisor_ID = '{$userid}' \n)\n)\nAND Employees_ID\nIN (\n\nSELECT Employees_ID\nFROM employees\nWHERE Privilege = 'normal'\n)");
} else {
$query = mysql_query("SELECT * \nFROM employees_leave\nWHERE Employees_ID\nIN (\n\nSELECT Employees_ID\nFROM employees \nWHERE Privilege= 'supervisor'\n)");
}
while ($result = mysql_fetch_assoc($query)) {
$query2 = mysql_query("SELECT Approval,Approve_By FROM leave_track WHERE EmpLeave_ID = '{$result['EmpLeave_ID']}'");
if (mysql_num_rows($query2) == 0) {
if (getLeaveDetails($result['Leave_ID'], "Duration") > getleaveamount($result['Employees_ID'])) {
$approval = "<form action='approving-leave.php' method='POST' ><input type='submit' name='approve' value='not-approve'><input type='hidden' name ='id' value=" . $result['EmpLeave_ID'] . "></form>";
} else {
$approval = "<form action='approving-leave.php' method='POST' ><input type='submit' name='approve' value='approve'><input type='submit' name='approve' value='not-approve'><input type='hidden' name ='id' value=" . $result['EmpLeave_ID'] . "></form>";
}
} else {
if (mysql_result($query2, 0, "Approval") == "Approve") {
$approval = "Approved";
} else {
$approval = "Not Approve";
}
}
echo "<tr><td>\n\t\t\t\t<ul class='nav navbar-nav navbar-left navbar-user'>\n <li class='dropdown alerts-dropdown'>\n\t\t\t<a href='#' class='dropdown-toggle' data-toggle='dropdown'> " . $result['Employees_ID'] . "<b class='caret'></b></a>\t\n\t\t\t\t<ul class='dropdown-menu'>\n\t\t\t ";
include 'user-status.php';
echo "</ul>\n </li></ul></td><td>" . getLeaveDetails($result['Leave_ID'], "Duration") . "</td><td>" . getLeaveDetails($result['Leave_ID'], "Starting_Date") . "</td><td>" . getLeaveDetails($result['Leave_ID'], "Reason") . "</td><td>" . $approval . "</td></tr>";
}
