<?php
require("../connection.php");
include("../user.php");
$user_id=$_SESSION['user'];
$username=$_SESSION['user_name'];
$id=$_REQUEST['issue_id'];
?>
<div   class="ravi">
			 <div class="box box-primary box-primary7">
			 <div id="getemp">
              
				<?php  
		$cus=mysqli_query($con,"select  *,t.employee_name as f_name,lm.location as loc from non_consumable_issue n  join employee_master t join location_master lm on lm.id=n.location  ORDER BY n.id  DESC limit 1");
	/* echo "SELECT top 1 tab1.issue_id,tab1.item_code,tab1.location,tab1.date,tab2.thosiba_emp_name,tab2.thosiba_emp_code,tab2.thosiba_emp_department,tab2.head_name,tab2.head_mobile,tab2.head_mail
FROM  [asset].[dbo].[new_item_issue1] tab1 left JOIN [toshiba_clms].[dbo].[thosiba_employee_master]  tab2   
    ON tab1.employee_code = tab2.thosiba_emp_code  ORDER BY tab1.issue_id  DESC"; */
		while($item1=mysqli_fetch_array($cus))
		{
			$emm=$item1['f_name'];
			$crea=$item1['created_by'];
			$da=$item1['issue_date'];
			$da1=date("d-m-Y",strtotime($da));
			
		if ($item1['f_name'])
			{
				$na=$item1['f_name'];
				$na1=$item1['emp_code'];
				$na2=$item1['emp_dept'];
				
			}
		
		?>
				<div id="rav" style="margin:5px;">
				
					
                <div id="rs">
				<table class="table table-hover table-bordered" style="font-family:'Times New Roman', Times, serif">
						<thead>
						<tr id="dark">
							<td id="dark" style="text-align:center;" colspan="5">NON-CONSUMABLE ISSUE LIST</td>
						</tr>
						<tr>
							<th>ISSUE ID</th>
							<th>Employee Location</th>
							<th>Employee Code</th>
							<th>Employee Name</th>
							<th>Employee Department</th>
						</tr>
						</thead>
						<tbody>
						<tr>
						<td style="text-align:left;"><?php echo $item1['id']; ?></td>
					    <td style="text-align:left;"><?php echo $item1['loc']; ?> </td>
					    <td style="text-align:left;"><?php echo $item1['emp_code']; ?></td>
					    <td style="text-align:left;"><?php echo $item1['f_name']; ?></td>
						<td style="text-align:left;"><?php echo $item1['emp_dept']; ?></td>

						</tr>
					    </tbody>
				</table>
				
			<?php 
		}
		?>
	
			
			<div style="text-align:left;float: left;width: 33%;margin-left: 20px;">Signature of the Issuer<br> <?php echo $crea;?></div>
			<div style="text-align:right;margin-right:20px;">Signature of the Receiver <br> <?php echo $emm;?></div>
			
			</div>
			
    </div>
			   </div>
			   </div>
				</div> <!-- col 8 close-->