<?php
include('../include/header.php');
$emp_id = $_REQUEST['emp_id'];

?>
<style>
.table > tbody > tr > td, .table > tbody > tr > th, .table > tfoot > tr > td, .table > tfoot > tr > th, .table > thead > tr > td, .table > thead > tr > th { border-top:0px;}
</style>
 <!-- Page wrapper  -->
        <div class="page-wrapper">
            <!-- Bread crumb -->
            <div class="row page-titles">
                <div class="col-md-5 align-self-center">
                   </div>
                <div class="col-md-7 align-self-center">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="javascript:void(0)">Home</a></li>
                        <li class="breadcrumb-item active">Employee Display</li>
                    </ol>
                </div>
            </div>
            <!-- End Bread crumb -->
            <!-- Container fluid  -->
            <div class="container-fluid">
                <!-- Start Page Content -->
			
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body"> 
							 <div class="card card-outline-primary">
						 <div class="card-header" style="cursor:pointer;" id="land_details_click">
                                <h4 class="m-b-0 text-white">Employee Detail</h4>
                            						
	
		
	</div>
		<div class="box-body" id="land_details_contain" style="overflow-y:hidden; ">
		  <h3 class="card-title m-t-15">Person Info</h3>
		<table class="table" style="width:100%">
			<thead>
				
			</thead>
			<tbody>
			<?php
			$sql_emp_det= "select *from tbl_emp_master where md5(id) = '$emp_id' ";
						$result_emp_det = $objhr->viewdata($sql_emp_det);
				
				
						$rows_emp_det = $result_emp_det->fetch_assoc();
						?>
			  	<tr>
					<td>Name :</td><td><b><?php echo strtoupper($rows_emp_det['emp_name']); ?></b></td>
					<td>DOB :</td><td><b><?php  echo strtoupper($rows_emp_det['dob']); ?></b></td>
					<td>Gender :</td><td><b><?php  echo strtoupper($rows_emp_det['gender']); ?></b></td>
					<td>Phone :</td><td><b><?php  echo strtoupper($rows_emp_det['phone_no']); ?></b></td>							
				</tr>  
				
				<tr>
					<td>Aadhar No :</td><td><b><?php  echo strtoupper($rows_emp_det['aadhar_no']); ?></b></td>
					<td>Father Name :</td><td><b><?php  echo strtoupper($rows_emp_det['father_name']); ?></b></td>
					<td>Mother Name :</td><td><b><?php  echo strtoupper($rows_emp_det['mother_name']);  ?></b></td>
					<td>Marital Status :</td><td><b><?php  echo strtoupper($rows_emp_det['marital_status']); ?></b></td>							
				</tr>   
				
				
				<tr>
					<td colspan="1">Permanent Address :</td><td colspan="2"><b><?php  echo strtoupper($rows_emp_det['p_address']); ?></b></td>
					<td colspan="1">Correspondence Address :</td><td colspan="2"><b><?php  echo strtoupper($rows_emp_det['c_address']); ?></b></td>
					<td colspan="1">date of joining</td><td colspan="2"><b><?php  echo strtoupper($rows_emp_det['date_of_join']); ?></b></td>
											
				</tr>      
			</tbody>
		</table>
		
		
		  <h3 class="card-title m-t-15">Qualification</h3>
		<table class="table" style="width:100%">
			<thead>
				
			</thead>
			<tbody>
			<?php
			$sql_emp_q = "select *from tbl_emp_qualification where md5(emp_id) = '$emp_id' ";
						$result_emp_q = $objhr->viewdata($sql_emp_q);
				
				 if($result_emp_q->num_rows > 0){
						while($rows_emp_q = $result_emp_q->fetch_assoc()){
						?>
			  	<tr>
					<td>Course</td><td><b><?php echo strtoupper($rows_emp_q['course']); ?></b></td>
					<td>University / Board</td><td><b><?php echo strtoupper($rows_emp_q['univ_board']); ?></b></td>
					<td>Percent</td><td><b><?php echo strtoupper($rows_emp_q['percentage']); ?></b></td>
					<td>Year Of Passing</td><td><b><?php echo strtoupper($rows_emp_q['year_of_pass']); ?></b></td>							
				</tr>  
				
				<?php }}?>
			</tbody>
		</table>
		
		
		
		  <h3 class="card-title m-t-15">Work Experiance</h3>
		<table class="table" style="width:100%">
			<thead>
				
			</thead>
			<tbody>
			<?php
			$sql_emp_wk = "select *from tbl_emp_work_exp where md5(emp_id) = '$emp_id' ";
						$result_emp_wk = $objhr->viewdata($sql_emp_wk);
				
				 if($result_emp_wk->num_rows > 0){
						while($rows_emp_wk = $result_emp_wk->fetch_assoc()){
						?>
		
			  	<tr>
					<td>Company Name</td><td><b><?php echo strtoupper($rows_emp_wk['company']); ?></b></td>
					<td>Department</td><td><b><?php echo strtoupper($rows_emp_wk['department']); ?></b></td>
					<td>Designation</td><td><b><?php echo strtoupper($rows_emp_wk['designation']); ?></b></td>
					<td>Date of joining</td><td><b><?php echo strtoupper($rows_emp_wk['date_join']); ?></b></td>	
					<td>Date of Leaving</td><td><b><?php echo strtoupper($rows_emp_wk['date_leave']);?></b></td>							
				</tr>  
			<?php }}?>
			</tbody>
		</table>
		
		
		 <h3 class="card-title m-t-15">Skill</h3>
		<table class="table" style="width:100%">
			<thead>
				
			</thead>
			<tbody>
		<?php
			$sql_emp_sk = "select *from tbl_emp_skill where md5(emp_id) = '$emp_id' ";
						$result_emp_sk = $objhr->viewdata($sql_emp_sk);
				
				 if($result_emp_sk->num_rows > 0){
						while($rows_emp_sk = $result_emp_sk->fetch_assoc()){
						?>
			  	<tr>
					<td>Name</td><td><b><?php echo strtoupper($rows_emp_sk['skill']); ?></b></td>
					<td>Level</td><td><b><?php echo strtoupper($rows_emp_sk['skill_level']); ?></b></td>
											
				</tr>  
				<?php }}?>
				
			</tbody>
		</table>
		
		<h3 class="card-title m-t-15">Document</h3>
		<table class="table" style="width:100%">
			<thead>
				
			</thead>
			<tbody>
		
	<?php
			$sql_emp_doc = "select *from tbl_emp_identity where md5(emp_id) = '$emp_id' ";
						$result_emp_doc = $objhr->viewdata($sql_emp_doc);
				
				 if($result_emp_doc->num_rows > 0){
						while($rows_emp_doc = $result_emp_doc->fetch_assoc()){
						?>
    
			  	<tr>
					<td>Name</td><td><b><?php $sql_emp_doc_nm = "select *from tbl_identity_master where id = '".$rows_emp_doc['identity_id']."' ";
						$result_emp_doc_nm = $objhr->viewdata($sql_emp_doc_nm);
						$rows_emp_doc_nm = $result_emp_doc_nm->fetch_assoc();
						echo strtoupper($rows_emp_doc_nm['identity_type']);
						?></b>
					<td>image</td><td align="left"> <img src="../photo/<?php echo $rows_emp_doc['image'];?>" style="width:50px; height:50px;" /></td>
											
				</tr>  
					<?php }}?>
			
			</tbody>
		</table>
		</div>
					</div>
					<!--
					<table class="table table-hover table-bordered table-condensed">
			<thead>
				<tr>
					<th style="border-right:1px solid #000000;">Mauja</th>
					<th style="border-right:1px solid #000000;">Land Area in (Decimal)</th>
					<th style="border-right:1px solid #000000;">Decimal Rate </th>
					<th style="border-right:1px solid #000000;">Total value (Land Area x Decimal Rate)</th>
					<th>1/20 of total value</th>							
				</tr>
			</thead>
			<tbody>
			  	<tr>
					
			  	</tr>      
			</tbody>
		</table>-->
		<!--<input type="submit" name="edit" value="Edit" class="btn btn-primary" />--> 
		
								
							 </div>
                        </div>
						
                    </div>
					
                </div>
				
				
                <!-- End PAge Content -->
            </div>
            <!-- End Container fluid  -->


<?php
include('../include/footer.php');
?>

