<?php
session_start();
error_reporting(0);
$id=$_GET['id'];
$idd=explode('//',$id);
$dump_date=$idd[0];
$image_uploadedby=$idd[1];
	include("database_connection.php");
	 

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<body>
	
	<form method="post" action=" " name="view_fereportdate" id="view_fereportdate">
	
	<table style="width:100%"   align="center"> 
	<tr>
	<td align="center" style="width:85%;">
	<table  border="1" bgcolor="white" style="width:85%;" class="table table-striped" > 
	<thead>
	<tr height="25">
				<th class="center" ><b>Sr No</b></th>				
				<th class="center"><b>Bank Name</b></th>				
				<th class="center"><b>App No</b></th>
				<th class="center"><b>Type</b></th>
				<th class="center"><b>Image Uploaded By</b></th>
				<th class="center"><b>Upload Date</b></th>
				<th class="center"><b>Upload time</b></th>
				
			</tr>
		 </thead>
		 <tbody>
		<?php
		
		if($dump_date)
		{
				
	$queryr="SELECT  * FROM `allocation_tbl` WHERE image_uploaddate = '$dump_date'  and image_uploadedby='$image_uploadedby' order by id asc";
	$resultr = MYSQLI_QUERY($conn,$queryr);
	}	
	 $j=1;
	while($data=mysqli_fetch_array($resultr)) {
	$id=$data['id'];
	if($data['bank_name']=="SBI AUTO LOAN")
	{
	$bank_name="SBI";
	}
	else
	{
	$bank_name=$data['bank_name'];
	}
	if($id>0)
	{
	
	?>

<tr  height="15">
<td   align="center"><font size="2"><b><?php echo $j ;?></b></font></td>
<td align="center"><font size="2"><b><?php echo strtoupper($bank_name);?></b></font></td>
<td align="center"><font size="2"><b><?php echo strtoupper($data['app_no']);?></b></font></td>
<td   align="center"><font size="2"><b><?php echo $data['type'];?></b></font></td>
<td   align="center"><font size="2"><b><?php echo $data['image_uploadedby'];?></b></font></td>
<td   align="center"><font size="2"><b><?php echo $data['image_uploaddate'];?></b></font></td>
<td   align="center"><font size="2"><b><?php echo $data['image_uploadtime'];?></b></font></td>
</tr>
<?php
	$j++; } } ?>

</tbody>
 </table>
</td>
</tr>
</table>

</div>
</body>
</html>			
