<?php
	use classes\lib\CGRewards;

	include('mod/_mod_security.php');

	$criteria = '';
	$filter = '';
	if (!empty($_POST['cgra_date_start']) && is_date($_POST['cgra_date_start'])) :
		$criteria .= " AND cgr.create_date >= " . nzdate($_POST['cgra_date_start']) . " ";
		$filter .= '<br> Updated start date: ' . $_POST['cgra_date_start'];
	endif;
	if (!empty($_POST['cgra_date_end']) && is_date($_POST['cgra_date_end'])) :
		$criteria .= " AND cgr.create_date <= " . nzdatetime($_POST['cgra_date_end'] . ' 23:59:59') . " ";
		$filter .= '<br> Updated end date: ' . $_POST['cgra_date_end'];
	endif;
	if (!empty($_POST['cgra_pull_id'])) :
		$criteria .= " AND cgr.cgr_pull_id = " . nz($_POST['cgra_pull_id'], '0') . " ";
		$filter .= '<br> CG Rewards Pull ID ' . $_POST['cgra_pull_id'];
	else :
		$criteria .= " AND cgr.cgr_pull_id IS NULL ";
	endif;
	$sql = "SELECT cgr.id AS cgr_id, c.primary_email, c.cgr_email, c.first_name, c.last_name, e.event_name, e.event_date_time, cgrt.cgr_type, cgrt.default_award_message
				FROM concierges c
				JOIN cg_rewards cgr ON (c.concierge_id = cgr.concierge_id)
				JOIN cg_reward_types cgrt ON (cgr.cgr_type_id = cgrt.id)
				LEFT JOIN events e ON (e.event_id = cgr.event_id)
				WHERE c.cgr = 1 AND c.cgr_approved = 1 AND c.status = 1
				$criteria
				ORDER BY e.event_id
	";
	//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('CG Rewards Activity Pull');
	$rpt->report_start();
	
	$rpt->header_start();
	if (!empty($filter)) :
		$rpt->header_row_start();
		$rpt->header_cell_add('Filters: '.$filter, ['colspan'=>'11', 'class'=>'large']);
		$rpt->header_row_end();
	endif;
	$rpt->header_row_start();
	$rpt->header_cell_add('Email', ['width'=>'70']);
	$rpt->header_cell_add('Award Name', ['width'=>'70']);
	$rpt->header_cell_add('Award Message', ['width'=>'70']);
	$rpt->header_cell_add('First Name', ['width'=>'70']);
	$rpt->header_cell_add('Last Name', ['width'=>'70']);
	$rpt->header_row_end();
	$rpt->header_end();
	
	$rpt->data_start();
	$ids_to_update = [];
	while($row = $result->fetch(PDO::FETCH_OBJ)) :
		$rpt->data_row_start();
		$rpt->data_cell_add((!empty($row->cgr_email) ? $row->cgr_email : $row->primary_email));
		$rpt->data_cell_add($row->cgr_type);
		$rpt->data_cell_add(!empty($row->event_name) ? $row->event_name . ' - ' . nzdate_display($row->event_date_time) : $row->default_award_message);
		$rpt->data_cell_add($row->first_name);
		$rpt->data_cell_add($row->last_name);
		$rpt->data_row_end();
		$ids_to_update[] = $row->cgr_id;
	endwhile;
	$rpt->data_end();
	if ($_POST['output_format'] == 'csv' && empty($_POST['cgra_pull_id'])) :
		CGRewards::update_activity_pull($ids_to_update);
	endif;
	
	$rpt->report_end();
	$rpt->output_report();

?>