<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>"; }