<?php include('_mod_security.php'); ?>

<?php
	$sql = "SELECT DISTINCT id, description FROM categories WHERE active = 1 ORDER BY description ";
	$result = $db->query($sql) or die('Database Error!');
	$ar_categories = $result->fetchAll(PDO::FETCH_KEY_PAIR);

?>

<script>
	$(document).ready(function()	
		{
			$(':input:not(.search, .no_dirty, .no_dirty input)').change(function() {sheet_dirty = true; } );
			$('.report_header').click(function() {
						$('.report_criteria').not($(this).next('.report_criteria')).slideUp(300);
						$(this).next('.report_criteria').slideToggle(300);
					 });
		}
	)
</script>

<h1>Reports</h1>
<?php echo form_message($form_message ?? NULL); ?>

<div class="tab_content" id="tab_content_basic_info" style="display:block;">
	<div class="report_section">
		<div class="report_header">
			Venue Contact Information
		</div>
		<div class="report_criteria oo_report">
			<form name="frm_report_vci" id="frm_report_vci" method="post" action="report.php?rpt=venue_contact&type=oo_report" target="_blank">
				<div class="input_column">
					<?php
						form_field('vci_date_start', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Updated Date Range - Start');
						form_field('vci_date_end', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Updated Date Range - End');
						form_field(['fname'=>'vci_category_id', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Category', 'ar_group'=>$ar_categories]);
						$ar_status = array(''=>'All', '1'=>'Active', '0'=>'Inactive', '2'=>'Pending', );
						form_field('vci_status', 'radiogroup', 50, 0, false, false, false, '', 'no_dirty', '', 'Venue Status', $ar_status);
					?>
				</div>
				<?php report_output_format(); ?>
			</form>
		</div>
	</div>
</div>