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