| Server IP : 172.67.201.108 / Your IP : 216.73.217.39 Web Server : Apache/2.4.68 (Amazon Linux) OpenSSL/3.5.5 System : Linux ip-172-31-69-123.ec2.internal 6.1.176-223.369.amzn2023.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Jul 24 13:34:27 UTC 2026 x86_64 User : ec2-user ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/tgnewdev/admin/mod/ |
Upload File : |
<?php require('_mod_security.php'); ?>
<?php
$sql = "SELECT DISTINCT id, name FROM categories WHERE active = 1 ORDER BY name ";
$result = $db->query($sql) or die('Database Error!');
$ar_categories = $result->fetchAll(PDO::FETCH_KEY_PAIR);
$sql = "SELECT DISTINCT id, name FROM locations WHERE status = 1 ORDER BY name ";
$result = $db->query($sql) or die('Database Error!');
$ar_locations = $result->fetchAll(PDO::FETCH_KEY_PAIR);
$sql = "SELECT DISTINCT id, name FROM obw_locations WHERE status = 1 ORDER BY name ";
$result = $db->query($sql) or die('Database Error!');
$ar_obw_locations = $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">
<script>
function change_range_eae() {
if ($('#eae_predefined_range').val() == 'Custom' || $('#eae_predefined_range').val() == '') {
$('#eae_event_date_start').parent().show();
$('#eae_event_date_end').parent().show();
$('#eae_date_start').parent().show();
$('#eae_date_end').parent().show();
} else {
$('#eae_event_date_start').parent().hide();
$('#eae_event_date_end').parent().hide();
$('#eae_date_start').parent().hide();
$('#eae_date_end').parent().hide();
}
}
$(document).ready(function() {
change_range_eae();
});
</script>
<div class="report_header">
Event Analytics by Event
</div>
<div class="report_criteria oo_report">
<form name="frm_report_eae" id="frm_report_eae" method="post" action="report.php?rpt=analytics_by_event&type=oo_report" target="_blank">
<div class="input_column">
<?php
$ar_predefined_range = ['Last Week', 'Last Month', 'Custom'];
form_field(['fname'=>'eae_predefined_range', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Predefined Date Range', 'ar_group'=>$ar_predefined_range, 'onchange'=>'change_range_eae();']);
form_field('eae_event_date_start', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Event Start Date - Default Monday Last Week ');
form_field('eae_event_date_end', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Event End Date - Default - Any Date After Event Start Date ');
form_field('eae_date_start', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Views/Clicks Date Range - Start - Default Monday Last Week ');
form_field('eae_date_end', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Views/Clicks Date Range - End - Default Sunday Last Week');
form_field(['fname'=>'eae_category_id', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Category', 'ar_group'=>$ar_categories]);
form_field(['fname'=>'eae_location_id', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Location', 'ar_group'=>$ar_locations]);
$ar_sort_rank = ['Event', 'Location', 'Event Date', 'Views - Rank', 'Clicks - Rank'];
form_field(['fname'=>'eae_sort_rank', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Primary Sort/Rank', 'ar_group'=>$ar_sort_rank]);
form_field(['fname'=>'eae_sort_rank2', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Secondary Sort/Rank', 'ar_group'=>$ar_sort_rank]);
?>
</div>
<?php report_output_format(); ?>
</form>
</div>
</div>
<div class="report_section">
<div class="report_header">
Event Analytics by Category
</div>
<div class="report_criteria oo_report">
<form name="frm_report_eac" id="frm_report_eac" method="post" action="report.php?rpt=analytics_by_category&type=oo_report" target="_blank">
<div class="input_column">
<?php
form_field('eac_event_date_start', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Event Start Date - Default Monday Last Week ');
form_field('eac_date_start', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Views/Clicks Date Range - Start - Default Monday Last Week ');
form_field('eac_date_end', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Views/Clicks Date Range - End - Default Sunday Last Week');
form_field(['fname'=>'eac_category_id', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Category', 'ar_group'=>$ar_categories]);
form_field(['fname'=>'eac_include_location', 'ftype'=>'checkbox', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Include Location Categories']);
form_field(['fname'=>'eac_include_free', 'ftype'=>'checkbox', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Include Free Category']);
?>
</div>
<?php report_output_format(); ?>
</form>
</div>
</div>
<div class="report_section">
<script>
function change_range_eap() {
if ($('#eap_predefined_range').val() == 'Custom' || $('#eap_predefined_range').val() == '') {
$('#eap_event_date_start').parent().show();
$('#eap_event_date_end').parent().show();
} else {
$('#eap_event_date_start').parent().hide();
$('#eap_event_date_end').parent().hide();
$('#eae_date_start').parent().hide();
$('#eae_date_end').parent().hide();
}
}
$(document).ready(function() {
change_range_eap();
});
</script>
<div class="report_header">
Event Analytics by Event Posting Date
</div>
<div class="report_criteria oo_report">
<form name="frm_report_eap" id="frm_report_eap" method="post" action="report.php?rpt=analytics_by_event_posted&type=oo_report" target="_blank">
<div class="input_column">
<?php
$ar_predefined_range = ['Last Week', 'Last Month', 'Custom'];
form_field(['fname'=>'eap_predefined_range', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Predefined Date Range', 'ar_group'=>$ar_predefined_range, 'onchange'=>'change_range_eap();']);
form_field('eap_event_date_start', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Event Posted Start Date - Default Monday This Week ');
form_field('eap_event_date_end', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Event Posted End Date - Default Friday This Week ');
form_field(['fname'=>'eap_category_id', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Category', 'ar_group'=>$ar_categories]);
form_field(['fname'=>'eap_location_id', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Location', 'ar_group'=>$ar_locations]);
$ar_sort_rank = ['Event', 'Location', 'Posted Date', 'Event Date', 'Views - Rank', 'Clicks - Rank'];
form_field(['fname'=>'eap_sort_rank', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Primary Sort/Rank', 'ar_group'=>$ar_sort_rank]);
form_field(['fname'=>'eap_sort_rank2', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Secondary Sort/Rank', 'ar_group'=>$ar_sort_rank]);
?>
</div>
<?php report_output_format(); ?>
</form>
</div>
</div>
<div class="report_section">
<div class="report_header">
Location Analytics Monthly Summary
</div>
<div class="report_criteria oo_report">
<form name="frm_report_lms" id="frm_report_lms" method="post" action="report.php?rpt=analytics_location_summary&type=oo_report" target="_blank">
<div class="input_column">
<?php
form_field(['fname'=>'lms_location_id', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>true, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Location', 'ar_group'=>$ar_locations]);
form_field('lms_date_start', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Views/Clicks Start Date - Default 1st day of last month ');
form_field('lms_date_end', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Views/Clicks End Date - Default last day of last month ');
form_field(['fname'=>'lms_category_id', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Category', 'ar_group'=>$ar_categories]);
$ar_sort_rank = ['Event', 'Event Date', 'Views - Rank', 'Clicks - Rank'];
form_field(['fname'=>'lms_sort_rank', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Primary Sort/Rank', 'ar_group'=>$ar_sort_rank]);
form_field(['fname'=>'lms_sort_rank2', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Secondary Sort/Rank', 'ar_group'=>$ar_sort_rank]);
?>
</div>
<?php report_output_format(); ?>
</form>
</div>
</div>
<div class="report_section">
<div class="report_header">
All Location Analytics Summary
</div>
<div class="report_criteria oo_report">
<form name="frm_report_als" id="frm_report_als" method="post" action="report.php?rpt=analytics_all_location_summary&type=oo_report" target="_blank">
<div class="input_column">
<?php
form_field('als_date_start', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Views/Clicks Start Date - Default 1st day of last month ');
form_field('als_date_end', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Views/Clicks End Date - Default last day of last month ');
$ar_sort_rank = ['Location', 'Events Count - Rank', 'Views - Rank', 'Clicks - Rank'];
form_field(['fname'=>'als_sort_rank', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Primary Sort/Rank', 'ar_group'=>$ar_sort_rank]);
form_field(['fname'=>'als_sort_rank2', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Secondary Sort/Rank', 'ar_group'=>$ar_sort_rank]);
form_field(['fname'=>'als_include_zero', 'ftype'=>'checkbox', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Include Locations With No Events']);
?>
</div>
<?php report_output_format(); ?>
</form>
</div>
</div>
<div class="report_section">
<script>
function change_range_oba() {
if ($('#oba_predefined_range').val() == 'Custom' || $('#oba_predefined_range').val() == '') {
$('#oba_event_date_start').parent().show();
$('#oba_event_date_end').parent().show();
$('#oba_date_start').parent().show();
$('#oba_date_end').parent().show();
} else {
$('#oba_event_date_start').parent().hide();
$('#oba_event_date_end').parent().hide();
$('#oba_date_start').parent().hide();
$('#oba_date_end').parent().hide();
}
}
$(document).ready(function() {
change_range_oba();
});
</script>
<div class="report_header">
Off Broadway Analytics by Show
</div>
<div class="report_criteria oo_report">
<form name="frm_report_oba" id="frm_report_oba" method="post" action="report.php?rpt=analytics_off_broadway&type=oo_report" target="_blank">
<div class="input_column">
<?php
$ar_predefined_range = ['Last Week', 'Last Month', 'Current Month', 'Custom'];
form_field(['fname'=>'oba_predefined_range', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Predefined Date Range', 'ar_group'=>$ar_predefined_range, 'onchange'=>'change_range_oba();']);
form_field('oba_date_start', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Views/Clicks Date Range - Start - Default Monday Last Week ');
form_field('oba_date_end', 'text', 20, 0, false, false, false, '', 'date-pick dp-applied no_dirty', '', 'Views/Clicks Date Range - End - Default Sunday Last Week');
form_field(['fname'=>'oba_location_id', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Location', 'ar_group'=>$ar_obw_locations]);
$ar_sort_rank = ['Show Name', 'Location', 'Views - Rank', 'Clicks - Rank'];
form_field(['fname'=>'oba_sort_rank', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Primary Sort/Rank', 'ar_group'=>$ar_sort_rank]);
form_field(['fname'=>'oba_sort_rank2', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Secondary Sort/Rank', 'ar_group'=>$ar_sort_rank]);
?>
</div>
<?php report_output_format(); ?>
</form>
</div>
</div>
<div class="report_section">
<div class="report_header">
Submitter List
</div>
<div class="report_criteria oo_report">
<form name="frm_report_sl" id="frm_report_sl" method="post" action="report.php?rpt=submitter_list&type=oo_report" target="_blank">
<div class="input_column">
<?php
$ar_sort_rank = ['Name', 'Email'];
form_field(['fname'=>'sl_sort_rank', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Primary Sort/Rank - Default Name', 'ar_group'=>$ar_sort_rank]);
$ar_min_event_count = ['1', '2', '3', '4', '5', '10', '15', '20', '30', '40', '50'];
form_field(['fname'=>'sl_min_event_count', 'ftype'=>'select', 'fsize'=>25, 'frequired'=>false, 'fclass'=>'no_dirty', 'fdbname'=>'', 'flabel'=>'Minimum Submitted Events - Default 1', 'ar_group'=>$ar_min_event_count]);
?>
</div>
<?php report_output_format(); ?>
</form>
</div>
</div>
</div>