function Header()
{
$this->Image('picture/logo.jpg', 10, 6, 60);
$this->SetFont('arial', 'B', 13);
$this->Cell(150);
$this->Cell(18, 5, 'Page ' . $this->PageNo() . '/{nb}', 0, 0, 'C');
$this->Ln(8);
$this->Cell(150);
$this->Cell(26, 5, 'Date ' . date("d/m/Y") . '', 0, 0, 'C');
$this->Ln(8);
$this->Cell(150);
$this->Cell(41, 5, 'Report Number: ' . rand(11111, 99999) . '', 0, 0, 'C');
$this->Ln(15);
$this->SetFont('arial', 'B', 15);
$this->Cell(0, 14, 'Employee Training Report', 0, 1, 'C');
$this->Cell(0, 4, getdepartmentname($_POST['department']), 0, 1, 'C');
$this->Cell(0, 15, 'Month of ' . date('F/Y', strtotime($_POST['month'])) . '', 0, 1, 'C');
$this->Ln(11);
}
</li>
<li><b>Email :</b>
<?php
$email = getuserdetails($result['Employees_ID'], 'Email');
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;
?>
</td>
</tr>
<tr>
<th>Recruitment Date :</th>
<td><?php
$recrdate = getuserdetails($userid, 'Recruitment_Date');
echo $recrdate;
?>
</td>
</tr>
<tr>
<th>Department :</th>
<td><?php
$depart = getdepartmentname(getdepartmentID($userid));
echo $depart;
?>
</td>
</tr>
</table>
<input type="submit" Value="Edit" class="form-control" name="edite">
</form>
?>
</td>
<td><b>Recruitment Date :</b>
<?php
$recrdate = getuserdetails($_GET['id'], 'Recruitment_Date');
echo $recrdate;
?>
</td>
</tr>
<tr>
<td><b>Department :</b>
<?php
$depart = getdepartmentname(getdepartmentID($_GET['id']));
echo $depart;
?>
</td>
</tr>
</table>
</div>
<?php
$userids = $_GET['id'];
include 'widget/performances.php';
}
?>
$query = mysql_query("SELECT AVG(employees.Salary) AS Average, SUM(employees.Salary) AS Total, employees_department.Department_ID AS Current_Department\nFROM employees_department INNER JOIN employees ON employees_department.Employees_ID = employees.Employees_ID \nGROUP BY employees_department.Department_ID\nORDER BY average DESC");
} else {
if ($_POST['sort'] == "least-salary") {
$query = mysql_query("SELECT AVG(employees.Salary) AS Average, SUM(employees.Salary) AS Total, employees_department.Department_ID AS Current_Department\nFROM employees_department INNER JOIN employees ON employees_department.Employees_ID = employees.Employees_ID \nGROUP BY employees_department.Department_ID\nORDER BY average ASC");
} else {
$query = mysql_query("SELECT AVG(employees.Salary) AS Average, SUM(employees.Salary) AS Total, employees_department.Department_ID AS Current_Department\nFROM employees_department INNER JOIN employees ON employees_department.Employees_ID = employees.Employees_ID \nGROUP BY employees_department.Department_ID");
}
}
}
}
$x = 1;
$average = 0;
$total = 0;
while ($result = mysql_fetch_assoc($query)) {
$pdf->Cell(40, 7, $x, 0);
$pdf->Cell(40, 7, getdepartmentname($result['Current_Department']), 0);
$pdf->Cell(40, 7, $result['Average'], 0);
$pdf->Cell(40, 7, $result['Total'], 0);
$pdf->Ln(11);
$x++;
$average = $average + $result['Average'];
$total = $total + $result['Total'];
}
$pdf->Ln(6);
$pdf->Cell(40);
$pdf->SetFont('Times', 'B', 12);
$pdf->Cell(40, 7, "Total ", 0);
$pdf->Cell(40, 7, $average, 0);
$pdf->Cell(40, 7, $total, 0);
$pdf->Output();
ob_end_flush();
function print_select_department_sure($departmentid)
{
global $choose_lang;
global $html_etc;
$departmentname = getdepartmentname($departmentid);
print "<TR>";
print "<TD class=TableData noWrap>" . $html_etc[$choose_lang]['部门'] . "：</TD>\n";
print "<TD class=TableData noWrap>\n";
print "<select name=\"departmentid\" class=\"BigSelect\" >\n";
print " <option value=\"0\">{$departmentname}</option>\n";
print "</select>\n";
print "</TD></TR>\n";
}
</td>
</tr>
<tr>
<th>Recruitment Date :</th>
<td><?php
$recrdate = Agetuserdetails($Asearch, 'Recruitment_Date');
echo $recrdate;
?>
</td>
</tr>
<tr>
<th>Department :</th>
<td><?php
$depart = getdepartmentname(AgetdepartmentID($Asearch));
echo $depart;
?>
<th>Privilege:</th>
<td><?php
$pri = Agetuserdetails($Asearch, 'Privilege');
echo $recrdate;
?>
</td>
</tr>
</table>
<input type="submit" Value="Edit" class="form-control" name="edite">
