Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- require_once("../config.php");
- session_start();
- $pdf=new PDF_MC_Table();
- $nID=$_SESSION['empID'];
- //Profile
- $pdf->AddPage();
- $pdf->SetWidths(array(30,12,28,36,28,28,12,14));
- //$pdf->SetTextColor( 21, 137, 255);
- $pdf->SetFont('Arial','B',12);
- //Profile section starts
- $pdf->Write(26,'Profile');
- $pdf->Ln();
- $pdf->SetFont('Arial', 'B', 12);
- $pdf->SetTextColor( 0, 0, 0);
- $pdf->Row(array('Name','ID','Department','Role', 'Manager ID','Reviewer ID','Year','Cycle'));
- $query= "select employee.EmployeeName,employee.EmployeeID,employee.ReviewerID,employee.Role,employee.Department,employee.ManagerID,employee.Email,employee.Phone,employee.Photo, department.DeptName, role.RoleName from employee LEFT JOIN department ON department.DeptId=employee.Department LEFT JOIN role ON role.RoleID=employee.Role where employee.EmployeeID='".$_SESSION['empID']."' AND employee.CompanyID='".$_SESSION['compID']."' AND department.CompanyID='".$_SESSION['compID']."' AND role.CompanyID='".$_SESSION['compID']."' AND employee.ActiveStatus=1";
- $result=mysql_query($query);
- $count=mysql_num_rows($result);
- while($row=mysql_fetch_array($result))
- {
- $Name=$row['EmployeeName'];
- $EmployeeID=$row['EmployeeID'];
- $Dept=$row['DeptName'];
- $Role=$row['RoleName'];
- $Manager=$row['ManagerID'];
- $Reviewer=$row['ReviewerID'];
- $pdf->SetFont('Arial', '', 12);
- $pdf->SetTextColor( 0, 0, 0);
- $pdf->Row(array($Name,$EmployeeID,$Dept,$Role,$Manager,$Reviewer,$_SESSION['year'],$_SESSION['cycle']));
- }
- $pdf->Output();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement