51 lines
1.8 KiB
PHP
51 lines
1.8 KiB
PHP
<?php //include('pdf_header.php');
|
|
include('includes/config/config.php');
|
|
//include('pop_up_top.php');
|
|
include('includes/functions.php');
|
|
header('Content-Type: application/force-download');
|
|
header('Content-disposition: attachment; filename=excel_guest_list.xls');
|
|
?>
|
|
<html>
|
|
|
|
<body>
|
|
<table width="100%" >
|
|
<tr><div style="font-size:12px">
|
|
<td width="25%" align="left"> Run Date : <?php echo date("d-M-Y"); ?></td>
|
|
<td width="50%" align="center" style="font-size:40px"><strong>Guest List</strong></td>
|
|
<td width="25%" align="left"> User : <?php echo $username ?></td>
|
|
</tr>
|
|
</table>
|
|
<table border="1">
|
|
<?php
|
|
$sql=base64_decode($filterkey);
|
|
$result = mysqli_query($conn,$sql);
|
|
|
|
$count=1
|
|
//echo $result;
|
|
?>
|
|
<tr bgcolor="#eeeeee" ><th>Sr</th><th>Guest Name</th><th>Father Name</th><th>Associated Employee</th><th>Associated RelationShip</th><th width="5%">Age</th><th width="5%">Gender</th><th>Primary Number</th><th>Aadhar No</th><th width="15%">Address</th><th width="12%">Email Address</th><th>Blood Group</th></tr><?php
|
|
while($row=mysqli_fetch_array($result)){
|
|
|
|
?><tr><td><?php echo $count++?></td><td><?php echo ($row['fname'].' '.$row['lname'])?></td>
|
|
<td><?php echo $row['father_name']?></td>
|
|
<td><?php echo getTableFieldValue('employee',"concat(fname,' ',lname)",'id',$row['emp_id'])?></td>
|
|
<td><?php echo $row['emp_relationship_type']?></td>
|
|
<td><?php echo $row['age']?></td>
|
|
<td><?php echo $row['gender']=='M'?'Male':'Female'?></td>
|
|
<td><?php echo $row['primary_phone']?></td>
|
|
<td><?php echo $row['aadhar_no']?></td>
|
|
<td><?php echo $row['address']?></td>
|
|
<td><?php echo $row['email_id']==null || ''?'':$row['email_id'];?></td>
|
|
<td><?php echo $row['blood_group']?></td>
|
|
</tr>
|
|
<?php
|
|
|
|
|
|
}
|
|
?>
|
|
</table>
|
|
<?php
|
|
//include('pdf_footer.php');
|
|
?>
|
|
|