<?php include('_mod_security.php'); ?>
<?php
	form_prep('contacts', 'basic_info', 'frm_contact');
	if ($_POST['ajax_event_submitted'] == '1') :
		form_prep_submit();
		form_validate_all();
		if (!$err_flag) :
			try {
				$db->beginTransaction();
				$set = sql_set_update() . form_generate_set();
				if ($action == 'Edit') :
					$sql = "UPDATE contacts set " . $set .
						"WHERE id = " . nz(trim($_REQUEST['id']), '0') . " ";
					save_db_revision('contacts');
					$db->query($sql);
					post_set_update();
				else :
					if ($action == 'Add New') :
						$sql = "INSERT INTO contacts SET " .
							sql_set_create() .
							$set;
						$db->query($sql);
						$_REQUEST['id'] = last_id();
						$_POST['id'] = $_REQUEST['id'];
						post_set_create_update();
					endif;
				endif;
				$db->commit();
			} catch(Exception $e) {
				db_err_rollback($e);
			}
			form_success(['venue_id' => nz($_POST['venue_id'], '0')]);
		else :
			$active_tab = $err_tab;
			$form_message = "Errors found!";
		endif;
	else :
		if ($action == 'Edit') :
			$sql = "SELECT * FROM contacts WHERE id = " . nz(trim($_REQUEST['id']), '0') . " ";
			if (!get_row_to_post($sql)) :
				echo form_fatal_error('Invalid Operation!');
				return;
			endif;
		else :
			if (!empty($_GET['venue_id'])) :
				$_POST['venue_id'] = $_REQUEST['venue_id'];
			endif;
			$_POST['status'] = 1;
		endif;
		$venue_main_phone = lookup_db_field('venues', 'id', nz($_POST['venue_id'], '0'), 'main_phone');
	endif;

?>

<script>
	var active_page = '<?php echo $_REQUEST['IX']; ?>';
	var active_tab = '';

	update_header = function() {
		if ($("#first_name").val() > "" || $("#last_name").val() > "") {
			$("#header_repeater").text(" - " + $("#first_name").val() + ' ' +  $("#last_name").val());
		}
	}

	function populate_default_contact() {
		$('#contact_type').val('RSRV');
		$('#title').val('-');
		$('#first_name').val('Reservation');
		$('#last_name').val('Contact');
		$('#office_phone').val('<?=$venue_main_phone?>');
		$('#cell_phone').val('<?=$venue_main_phone?>');
		$('#preferred_phone').val('office_phone');
	}

	$(document).ready(function() {
		switch_tab('<?php echo $active_tab; ?>');
		update_header();
		$(':input:not(.search)').change(function() {
			sheet_dirty = true;
		});
	})
</script>

<h1>Contact - <?php echo $action; ?><span id="header_repeater"></span></h1>
<?php echo form_message($form_message); ?>

<form name="frm_contact" id="frm_contact" method="post" action="">
	<input name="ajax_event_submitted" type="hidden" value="1" />
	<input name="id" type="hidden" value="<?php echo $_REQUEST['id']; ?>" />
	<input name="active_tab" id="active_tab" type="hidden" value="basic_info" />
	<?php form_button_strip('top'); ?>
	<div class="tab_strip">
		<?php
		form_tab_header('basic_info', 'Basic Info', 'admin,dataentry');
		if (!empty($_REQUEST['id'])) :
			form_tab_header('revisions', 'Revisions', 'admin,dataentry');
		endif;
		?>
	</div>
	<div class="cleardiv">
		&nbsp;
	</div>
	<?php form_tab_start('basic_info', 'Contact - Basic Info'); ?>
		<div class="input_column">
			<?php
			form_field('id', 'text', 10, 0, false, false, true, '', '', 'id', 'Contact ID');
			$sql = "SELECT id, name FROM venues WHERE status IN (1, 2) ORDER BY name ";
			$result_venues = $db->query($sql) or die('Database Error!');
			$ar_venues = $result_venues->fetchAll(PDO::FETCH_KEY_PAIR);
			$venue_readonly = true;
			$venue_required = false;
			if (empty($_POST['venue_id'])) :
				$venue_readonly = false;
				$venue_required = true;
			endif;
			form_field('venue_id', 'select', 10, 0, $venue_required, false, $venue_readonly, '', '', 'venue_id', 'Venue', $ar_venues);
			echo '<br><br><input type="button" value="Fill Default Info" onclick="populate_default_contact();">';
			form_field('contact_type', 'select', 50, 0, true, false, false, '', '', 'contact_type', 'Contact Type', APP_CONTACT_TYPES);
			form_field('title', 'text', 50, 0, true, false, false, '', '', 'title', 'Title');
			form_field('first_name', 'text', 100, 0, true, false, false, '', '', 'first_name', 'First Name', [], '', 'update_header();');
			form_field('last_name', 'text', 100, 0, true, false, false, '', '', 'last_name', 'Last Name', [], '', 'update_header();');
			form_field('email', 'text', 50, 0, true, false, false, '', '', 'email', 'Email', [], '', '', '', 'email');
			form_field('office_phone', 'text', 50, 0, true, false, false, '', '', 'office_phone', 'Office Phone');
			form_field('cell_phone', 'text', 50, 0, true, false, false, '', '', 'cell_phone', 'Cell Phone');
			form_field('accepts_texts', 'checkbox', 50, 0, false, false, false, '', '', 'accepts_texts', 'Accepts Texts');
			form_field('other_phone', 'text', 50, 0, false, false, false, '', '', 'other_phone', 'Other Phone');
			$ar_phone_types = [
				'office_phone' => 'Office',
				'cell_phone' => 'Cell',
				'other_phone' => 'Other',
			];
			form_field('preferred_phone', 'select', 50, 0, false, false, false, '', '', 'preferred_phone', 'Preferred Phone', $ar_phone_types);
			form_field('status', 'radiogroup', 50, 0, true, false, false, '', '', 'status', 'Status', APP_CONTACT_STATUSES);
			?>
		</div>
		<div class="input_column">
			<?php
			form_field('comments', 'textarea', 70, 9, false, false, false, '', '', 'comments', 'Comments');
			?>
		</div>
	<?php form_tab_end(); ?>
	<!-- -------------------------------------------------------------------------------------------------------------- -->
	<?php form_tab_revisions('contacts', $_REQUEST['id']); ?>
	<?php form_button_strip('bottom'); ?>
</form>