invisio v2.0

<?php
	$empid = $_GET['empid'];
	
	include("config.php");
	$blongs = 'Photo';
	
	$result = $js->prepare('SELECT * FROM `employees` WHERE empid = :empid ');
	$result->execute(array(':empid' => $empid));
	
	while($row = $result->fetch(PDO::FETCH_ASSOC)) 
	{
		$empname = $row['empname'];
		$addr = $row['empaddr'];
		$count = strtoupper($row['emploc']);
		$dob = date("d-m-Y", strtotime($row['dob']));
		$mob = $row['empmob'];
		$mail = $row['empmail'];
		$emer = $row['emergency'];
		$passport = $row['passportno'];
		$passissue = date("d-m-Y", strtotime($row['passissue']));
		$passexp = date("d-m-Y", strtotime($row['passexp']));
		$res = $row['resid'];
		$resissue = date("d-m-Y", strtotime($row['resissue']));
		$resexp = date("d-m-Y", strtotime($row['resexp']));
		$desig = $row['desig'];
		$sql2 = $js->prepare('SELECT * FROM designations WHERE did = :desig ');
		 $sql2->execute(array(':desig' => $desig));
		//$result1->execute();
		while($row3 = $sql2->fetch(PDO::FETCH_ASSOC)) 
		{
			$designame = $row3['designame'];
			
		}
		$doj = date("d-m-Y", strtotime($row['doj']));
		$accm = $row['accmodation'];
		$sal = $row['salary'];
		$allow = $row['allowance'];
		$ticket = $row['ticket'];
		$remarks = $row['remarks'];
		$report = $row['reportto'];
		
		$sql2d = $js->prepare('SELECT * FROM employees WHERE empid = :report ');
		 $sql2d->execute(array(':report' => $report));
		//$result1->execute();
		while($row3d = $sql2d->fetch(PDO::FETCH_ASSOC)) 
		{
			$reportname = $row3d['empname'];
			
		}
		
		$resulti = $js->prepare('SELECT * FROM `employeeimages` WHERE employee = :empid AND belongsto = :blongs ');
		$resulti->execute(array(':empid' => $empid,
								':blongs' => $blongs));
		
		while($rowi = $resulti->fetch(PDO::FETCH_ASSOC)) 
		{
			$file = $rowi['file']; 
		}
	}
	
?>
<!DOCTYPE html>
<html lang="en">
<title> <?php echo $empname?> </title>
<head>
<meta charset="utf-8" />
<style type="text/css">
@page {
    size: A4;
	margin:25px; !important;
}

@media print {
  
	.noprint {display:none;}
	html {
    zoom: 80%;
  }
}
@media print { 
   table {
        page-break-inside: auto;
      }
      tr{
        page-break-inside: avoid;
        page-break-after: auto;
      }
	 /* #sme{display: block; width: 100%; height: 100%;page-break-inside: avoid;}      */
      
}
</style>
<script>
function myFunction() {
    window.print();
}
</script>

</head>
<body>
<div class="noprint">
	<p align="center">
    	<a href="#" onClick="myFunction()" style="border:5px solid; background-color:#093; color:#FFF; padding:8px; text-decoration:none;">PRINT</a>

<a href="employees.php" style="border:5px solid; background-color:#F00; color:#FFF; padding:8px; text-decoration:none;">CLOSE</a>
    </p>
</div>
<div align="center" style="background-color:#FFF">
<header>
	<img src="logo.png" width="200" height="60"><HR  style="border-color:#5053FD" />
</header>
	<h3><b> Employee Report - <?php echo $empname?> </b></h3>
	<table
		style="border-collapse: collapse; width:100% "
		id="table" border="1" cellpadding="5" cellspacing="5">
        <tr>
            <td align="right" colspan="2"><img src="upload/employees/<?php echo $empid?>/<?php echo $file?>" height="150" width="120" ></td>
        </tr>
        <tr>
        	<td colspan="2"><strong>PERSONAL DETAILS</strong></td>
        </tr>
        <tr>
        	<td> ID </td>
            <td> <?php echo $empid ?> </td>
        </tr>
        <tr>
            <td width="26%"> NAME </td>
            <td width="74%"> <?php echo $empname?> </td>
        </tr>
        <tr>
            <td> ADDRESS </td>
            <td> <?php echo $addr?> </td>
        </tr>
        <tr>
            <td> NATIONALITY </td>
            <td> <?php echo $count?> </td>
        </tr>
        <tr>
        	<td> MOBILE </td>
            <td> <?php echo $mob?> </td>
        </tr>
        <tr>
        	<td> EMAIL </td>
            <td> <?php echo $mail?> </td>
        </tr>
        <tr>
        	<td> DATE OF BIRTH </td>
            <td> <?php echo $dob?> </td>
        </tr>
        <tr>
        	<td> EMERGENCY CONTACT </td>
            <td> <?php echo $emer?> </td>
        </tr>
        
        <tr>
        	<td colspan="2"><strong>PASSPORT DETAILS</strong></td>
        </tr>
        <tr>
        	<td> PASSPORT NUMBER </td>
            <td> <?php echo $passport?> </td>
        </tr>
        <tr>
        	<td> DATE OF ISSUE </td>	
            <td> <?php echo $passissue?> </td>
        </tr>
        <tr>
        	<td> DATE OF EXPIRY </td>
            <td> <?php echo $passexp?> </td>
        </tr>
        
         <tr>
        	<td colspan="2"><strong>RESIDENCE ID DETAILS</strong></td>
        </tr>
        <tr>
        	<td> ID NUMBER </td>
            <td> <?php echo $res?> </td>
        </tr>
        <tr>
        	<td> DATE OF ISSUE </td>	
            <td> <?php echo $resissue?> </td>
        </tr>
        <tr>
        	<td> DATE OF EXPIRY </td>
            <td> <?php echo $resexp?> </td>
        </tr>
        
        <tr>
        	<td colspan="2"><strong>RENUMERATION & JOINING DETAILS</strong></td>
        </tr>
        <tr>
        	<td> DESIGNATION </td>
            <td> <?php echo $designame ?></td>
        </tr>
        <tr> 
        	<td> DATE OF JOINING </td>
            <td> <?php echo $doj?></td>
        </tr>
        <tr>
        	<td> ACCOMMODATION </td>
            <td> <?php echo $accm?> </td>
        </tr>
        <tr>
        	<td> SALARY </td>
            <td> <?php echo $sal ?>
        </tr>
        <tr>
        	<td> ALLOWANCE </td>
            <td> <?php echo $allow ?> </td>
        </tr>
        <tr>
        	<td> TICKET </td>
            <td> <?php echo $ticket?> </td>
        </tr>
        <tr>
        	<td> REPORTING TO </td>
            <td> <?php echo $reportname ?> </td>
        </tr>
        <tr>
        	<td> REMARKS </td>
            <td> <?php echo $remarks?> </td>
        </tr>
   </table>