<?php include('mod/_mod_security.php'); ?>
<?php
	$criteria = '';
	$having_criteria = ' HAVING 1 = 1 ';
	$analytics_join_criteria = '';
	$events_join_criteria = '';
	$filter = '';
	if (empty($_POST['als_date_start'])) :
		$_POST['als_date_start'] = date('Y-m-d', strtotime('first day of last month'));
	endif;
	if (empty($_POST['als_date_end'])) :
		$_POST['als_date_end'] = date('Y-m-d', strtotime('last day of last month'));
	endif;
	switch ($_POST['als_sort_rank'] ?? '') :
		case 'Location':
			$sort_rank = 'l.name ASC';
			$filter .= '<br> Primary Sort/Rank: ' . 'Location';
			break;
		case 'Events Count - Rank':
			$sort_rank = 'event_count DESC';
			$filter .= '<br> Primary Sort/Rank: ' . 'Events Count - Rank';
			break;
		case 'Views - Rank':
			$sort_rank = 'view_count DESC';
			$filter .= '<br> Primary Sort/Rank: ' . 'Views - Rank';
			break;
		case 'Clicks - Rank':
			$sort_rank = 'click_count DESC';
			$filter .= '<br> Primary Sort/Rank: ' . 'Clicks - Rank';
			break;
		default:
			$sort_rank = 'l.name ASC';
			$filter .= '<br> Primary Sort/Rank: ' . 'Posted Date';
	endswitch;
	switch ($_POST['als_sort_rank2'] ?? '') :
		case 'Location':
			$sort_rank .= ', l.name ASC';
			$filter .= '<br> Seondary Sort/Rank: ' . 'Location';
			break;
		case 'Events Count - Rank':
			$sort_rank .= ', event_count DESC';
			$filter .= '<br> Seondary Sort/Rank: ' . 'Events Count - Rank';
			break;
		case 'Views - Rank':
			$sort_rank .= ', view_count DESC';
			$filter .= '<br> Seondary Sort/Rank: ' . 'Views - Rank';
			break;
		case 'Clicks - Rank':
			$sort_rank .= ', click_count DESC';
			$filter .= '<br> Seondary Sort/Rank: ' . 'Clicks - Rank';
			break;
		default:
			$sort_rank .= ' ';
			$filter .= '<br> Seondary Sort/Rank: ' . 'None';
	endswitch;

	if (!empty($_POST['als_date_start']) && is_date($_POST['als_date_start'])) :
		$analytics_join_criteria .= " AND (a.create_date IS NULL OR a.create_date >= " . nzdate($_POST['als_date_start']) . ") ";
		$filter .= '<br> Analytics start date: ' . nzdate_display($_POST['als_date_start']);
	endif;
	if (!empty($_POST['als_date_end']) && is_date($_POST['als_date_end'])) :
		$analytics_join_criteria .= " AND (a.create_date IS NULL OR a.create_date <= " . nzdatetime($_POST['als_date_end'] . ' 23:59:59') . ") ";
		$filter .= '<br> Analytics end date: ' . nzdate_display($_POST['als_date_end']);
	endif;
	if (!empty($_POST['als_include_zero'])) :
		$filter .= '<br> Locations with no events: Included';
	else :
		$having_criteria .= " AND COUNT(DISTINCT e.id) > 0 ";
		$filter .= '<br> Locations with no events: Excluded';
	endif;
	$events_join_criteria .= " AND (e.start_time_local BETWEEN " . nzdate($_POST['als_date_start']) . " AND " . nzdate($_POST['als_date_end'] . ' 23:59:59') . " OR 
		e.end_time_local BETWEEN " . nzdate($_POST['als_date_start']) . " AND " . nzdate($_POST['als_date_end'] . ' 23:59:59') . ") ";
	$slug_start_position = strlen(APP_BASE_USER_SITE_SECURE . 'events/') + 1;
	$sql = "SELECT
		l.id,
		l.name,
		l.slug,
		COUNT(DISTINCT e.id) AS event_count,
		COUNT(DISTINCT CASE WHEN a.category = 'page_view' AND a.action = 'view' THEN a.id ELSE NULL END) AS view_count,
		COUNT(DISTINCT CASE WHEN a.category = 'outbound_ticket_link' AND a.action = 'click' THEN a.id ELSE NULL END) AS click_count
		FROM locations l
		LEFT JOIN events e ON (e.location_id = l.id AND e.status =1 $events_join_criteria)
		LEFT JOIN analytics a ON (a.reference_type = 'event' AND a.reference_id = e.id $analytics_join_criteria)
		WHERE l.status = 1
		$criteria
		GROUP BY l.id, l.name
		$having_criteria
		ORDER BY $sort_rank
	";
	//error_log($sql);
	$result = $db->query($sql) or die('Database Error!');
	$row_count = $result->rowCount();
	if ($row_count <= 0) :
		echo 'No data for report!';
		exit();
	endif;
	
	$rpt = get_report_class($_POST['output_format']);
	$rpt->set_report_title('All Location Analytics Summary');
	$rpt->report_start();
	
	$rpt->header_start();
	if (!empty($filter)) :
		$rpt->header_row_start();
		$rpt->header_cell_add('Filters: '.$filter, ['colspan'=>'5', 'class'=>'large']);
		$rpt->header_row_end();
	endif;
	$rpt->header_row_start();
	$rpt->header_cell_add('Location', ['width'=>'280']);
	$rpt->header_cell_add('Events Count', ['width'=>'100']);
	$rpt->header_cell_add('Views', ['width'=>'100']);
	$rpt->header_cell_add('Clicks', ['width'=>'100']);
	$rpt->header_cell_add('% Clicks', ['width'=>'110']);
	$rpt->header_row_end();
	$rpt->header_end();
	
	$rpt->data_start();
	$rows = $result->fetchAll(PDO::FETCH_OBJ);
	$total_events = array_sum(array_column($rows, 'event_count'));
	$total_views = array_sum(array_column($rows, 'view_count'));
	$total_clicks = array_sum(array_column($rows, 'click_count'));
	$rpt->data_row_start();
	$rpt->data_cell_add('Totals', ['style' => 'font-size:125%; font-weight:bold;']);
	$rpt->data_cell_add($total_events, ['align'=>'right', 'style' => 'font-size:125%; font-weight:bold;']);
	$rpt->data_cell_add($total_views, ['align'=>'right', 'style' => 'font-size:125%; font-weight:bold;']);
	$rpt->data_cell_add($total_clicks, ['align'=>'right', 'style' => 'font-size:125%; font-weight:bold;']);
	$rpt->data_cell_add(number_format($total_views > 0 ? (($total_clicks / $total_views) * 100) : 0, 2), ['align'=>'right', 'style' => 'font-size:125%; font-weight:bold;']);
	$rpt->data_row_end();
	foreach ($rows as $row) :
		$link_data = [];
		$link_data['lms_location_id'] = $row->id;
		$link_data['lms_date_start'] = $_POST['als_date_start'];
		$link_data['lms_date_end'] = $_POST['als_date_end'];
		$link_data['output_format'] = 'html';
		$link_data['orientation'] = 'P';
		$link_data['email_to'] = '';
		$deeplink_data = urlencode(json_encode($link_data));
		$rpt->data_row_start();
		$rpt->data_cell_add('<a href="' . APP_BASE_SECURE . 'report.php?rpt=analytics_location_summary&type=oo_report&deeplink=true&deeplink_data=' . $deeplink_data . '" target="_blank">' . $row->name . '</a>');
		$rpt->data_cell_add($row->event_count, ['align'=>'right']);
		$rpt->data_cell_add($row->view_count, ['align'=>'right']);
		$rpt->data_cell_add($row->click_count, ['align'=>'right']);
		$rpt->data_cell_add(number_format($row->view_count > 0 ? (($row->click_count / $row->view_count) * 100) : 0, 2), ['align'=>'right']);
		$rpt->data_row_end();
	endforeach;
	$rpt->data_row_start();
	$rpt->data_cell_add('Totals', ['style' => 'font-size:125%; font-weight:bold;']);
	$rpt->data_cell_add($total_events, ['align'=>'right', 'style' => 'font-size:125%; font-weight:bold;']);
	$rpt->data_cell_add($total_views, ['align'=>'right', 'style' => 'font-size:125%; font-weight:bold;']);
	$rpt->data_cell_add($total_clicks, ['align'=>'right', 'style' => 'font-size:125%; font-weight:bold;']);
	$rpt->data_cell_add(number_format($total_views > 0 ? (($total_clicks / $total_views) * 100) : 0, 2), ['align'=>'right', 'style' => 'font-size:125%; font-weight:bold;']);
	$rpt->data_row_end();
	$rpt->data_end();
	
	$rpt->report_end();
	$rpt->output_report();