<?php include('_mod_security.php'); ?>
<?php
	$sql = "SELECT * FROM guests WHERE user_id = ".$_SESSION['user_id']."  AND event_id = ".$_SESSION['active_event']." ";
	$search_parm = mysqli_real_escape_string($GLOBALS['con'], trim($_POST['strSearch']));
	if ($search_parm != '') :
		$sql = $sql." AND ".search_sql($_POST['strSearch'],'last_name,first_name')." ";
	endif;
	$sql = $sql." ORDER BY last_name ASC";
	$result = mysqli_query($GLOBALS['con'], $sql);
	//echo " ===== ".$sql." ==== ";
	$xls_sql = "SELECT id AS guest_id, guest_type, (IF(guest_type = 'C' AND primary_guest_id = 0, 'Y', '') ) AS individual_child, salutation, last_name, first_name, middle_name, suffix, street, street2, city, state, zip, country, phone, mobile, email, facebook, instagram, twitter, favor_gender, favor_size, comments  FROM guests WHERE user_id = ".$_SESSION['user_id']." AND event_id = ".$_SESSION['active_event']." ORDER BY last_name ASC";
	$ix_list = "guests";
	$ix_form = "guest_form";
?>
<script>
	// ****** Prepare popup form settings *****
	var win_page = 'page_form.php';
	var win_width = 600;
	var win_height = 400;
	var print_section = 'div_db_grid';

	function select_all_guests()
	{
		$('form#guest_selection input[type=checkbox]').each(function(){
			this.checked = true;
		});
	}

	function delete_selected_guests()
	{
		var answer = confirm('Are you sure? Deleting a Guest will delete all associated RSVPs, Gifts, etc.  Deleteing a Primary Guest will also delete all related guests.  This action cannot be reversed!');
		if (answer == true){
			$("#guest_selection").submit();
		}
	}
</script>

<h1>Guest List</h1>
<?php get_reports('all_invited_guests,invited_families'); ?>
<?php get_notes(); ?>
<?php get_help_guide('help_guests'); ?>
<?php
	if (empty($_SESSION['active_event'])) :
?>
		<h3>No Bar/Bat Mitzvah defined - please create or activate a Bar/Bat Mitzvah!</h3>
<?php
	endif;
?>

<?php include('mod/_db_navigator_bar.php'); ?>

<div class="db-grid" id="div_db_grid">

<form id="guest_selection" name="guest_selection" method="post" action="index.php?IX=guest_delete_multiple">
	<table id="db_grid_main" class="dbgrid" align="center" cellpadding="0" cellspacing="2" border="0" >
		<thead>
			<tr>
				<td width="150" align="center" class="data-grid-label">
					Last Name
				</td>
				<td width="150" align="center" class="data-grid-label">
					First Name
				</td>
				<td width="120" align="center" class="data-grid-label">
					Guest Type
				</td>
				<td width="75" align="center" class="data-grid-label">
					Delete
				</td>
				<td width="100" align="center" class="data-grid-label">
					Select
				</td>
			</tr>
		</thead>
		<tbody>
			<tr>
				<td class="data-grid-var">&nbsp;
				</td>
				<td class="data-grid-var">&nbsp;
				</td>
				<td class="data-grid-var">&nbsp;
				</td>
				<td class="data-grid-var">&nbsp;
				</td>
				<td class="data-grid-var" align="center">
					<a href="javascript:select_all_guests();">Select All</a><br />
					<a href="javascript:delete_selected_guests();">Delete selected</a>
				</td>
			</tr>
			<?php
				while($row = mysqli_fetch_object($result)) :
			?>
					<tr>
						<td class="data-grid-var" >
							<a href="index.php?IX=<?php echo $ix_form; ?>&id=<?php echo $row->id; ?>" >
								<?php echo $row->last_name; ?>
							</a>
						</td>
						<td class="data-grid-var">
							<?php echo $row->first_name; ?>
						</td>
						<td class="data-grid-var">
							<?php
								switch ($row->guest_type) :
									case "P" :
										echo 'Primary';
										break;
									case "S" :
										echo 'Significant Other';
										break;
									case "C" :
										echo 'Child';
										break;
									case "G" :
										echo 'Gift Only';
										break;
								endswitch;
							?>
						</td>
						<td class="data-grid-var" align="center" >
							<a href="javascript:confirmDelete('Are you sure?  Deleting a Guest will delete all associated RSVPs, Gifts, etc.  Deleteing a Primary Guest will also delete all related guests.', 'guest_delete&id=<?php echo $row->id; ?>');"><img src="img/delete_icon.gif" style="border:none;"  /></a>
						</td>
						<td class="data-grid-var" align="center" >
							<input type="checkbox" name="guest_select[]" value="<?php echo $row->id; ?>" />
						</td>
					</tr>
			<?php
				endwhile;
			?>
		</tbody>
	</table>
</form>

</div>