<?php include('mod/_mod_security.php'); ?>
<?php
	$sql = "SELECT g.*,(SELECT s.state_name from states s WHERE s.state = g.state) AS state_name ".
					"FROM guests g WHERE (g.invite_temple = 1 OR g.invite_av = 1 OR g.invite_kv = 1 OR g.invite_dv = 1 OR g.invite_bv = 1) AND g.invitation_send = 1 ".
					"AND g.user_id = ".$_SESSION['user_id']." AND g.event_id = ".$_SESSION['active_event']." ORDER BY g.last_name, g.first_name ";
	$result = mysqli_query($GLOBALS['con'], $sql) or die('Database error!');
	if (mysqli_num_rows($result) <= 0) :
		echo 'No data for report!';
		exit();
	endif;
?>
<table align="center" cellpadding="0" cellspacing="2" border="0">
	<thead>
		<?php report_fixed_header(); ?>
		<tr>
			<td width="640" align="center">
				Formatted Address Proof
			</td>
		</tr>
	</thead>
	<tfoot>
		<?php report_fixed_footer(); ?>
	</tfoot>
	<tbody>
		<?php
			while($row = mysqli_fetch_object($result)) :
		?>
				<tr>
					<td>
						<?php 
							if ($_POST['state_names'] == 'long' && !empty($row->state_name)) :
								$row->state = $row->state_name;
							endif;
							$proof = format_address($row->invitation_text, $row->invitation_text2, $row->salutation, $row->first_name, $row->last_name, $row->suffix, $row->street, $row->street2, $row->city, $row->state, $row->zip, $row->country);
							echo $proof; 
						?>
					</td>
				</tr>
		<?php
			endwhile;
		?>
		<tr>
			<td>
				Total: <?php echo mysqli_num_rows($result); ?>
			</td>
		</tr>
	</tbody>
</table>