<?php include('mod/_mod_security.php'); ?>
<?php
	$criteria = '';
	$filter = '';
	if (isset($_POST['ce_status'])) :
		$criteria .= " AND c.status = " . nz($_POST['ce_status'], '0') . " ";
		$filter .= '<br> Concierge status: ';
		switch ($_POST['ce_status']) :
			case '0' :
				$filter .= 'Inactive';
				break;
			case '1' :
				$filter .= 'Active';
				break;
			case '2' :
				$filter .= 'In Transition';
				break;
		endswitch;
	endif;
	$sql = "SELECT DISTINCT c.*, h.hotel_name, CONCAT(h.bldg_nbr, h.street) AS address, h.city, h.state, h.zip, n.neighborhood_name FROM ( ".
			"SELECT first_name, last_name, title, primary_email AS email, work_phone, cell_phone, cgr, nycahc_member, gte_certified, status, hotel_id FROM concierges WHERE primary_email > ' ' ".
			"UNION ".
			"SELECT first_name, last_name, title, secondary_email AS email, work_phone, cell_phone, cgr, nycahc_member, gte_certified, status, hotel_id FROM concierges WHERE secondary_email > ' ' ".
			"UNION ".
			"SELECT first_name, last_name, title, email_3 AS email, work_phone, cell_phone, cgr, nycahc_member, gte_certified, status, hotel_id FROM concierges WHERE email_3 > ' ' ".
			"UNION ".
			"SELECT first_name, last_name, title, email_4 AS email, work_phone, cell_phone, cgr, nycahc_member, gte_certified, status, hotel_id FROM concierges WHERE email_4 > ' ' ".
			" ) c
			LEFT JOIN hotels h ON (h.hotel_id = c.hotel_id)
			LEFT JOIN neighborhoods n ON (n.neighborhood_id = h.neighborhood_id)
			WHERE c.status = " . nz($_POST['ce_status'], '0') . "
			ORDER BY h.hotel_name ASC, c.first_name ASC, c.last_name ASC
	";
	//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('Concierge Status Report');
	$rpt->report_start();
	
	$rpt->header_start();
	if (!empty($filter)) :
		$rpt->header_row_start();
		$rpt->header_cell_add('Filters: '.$filter, ['colspan'=>'15', 'class'=>'large']);
		$rpt->header_row_end();
	endif;
	$rpt->header_row_start();
	$rpt->header_cell_add('First', ['width'=>'70']);
	$rpt->header_cell_add('Last', ['width'=>'70']);
	$rpt->header_cell_add('Title', ['width'=>'70']);
	$rpt->header_cell_add('Email', ['width'=>'70']);
	$rpt->header_cell_add('Work Phone', ['width'=>'70']);
	$rpt->header_cell_add('Cell Phone', ['width'=>'70']);
	$rpt->header_cell_add('Hotel', ['width'=>'70']);
	$rpt->header_cell_add('Neighborhood', ['width'=>'70']);
	$rpt->header_cell_add('Address', ['width'=>'100']);
	$rpt->header_cell_add('City', ['width'=>'70']);
	$rpt->header_cell_add('State', ['width'=>'40']);
	$rpt->header_cell_add('Zip', ['width'=>'40']);
	$rpt->header_cell_add('CGR', ['width'=>'40']);
	$rpt->header_cell_add('GTE', ['width'=>'40']);
	$rpt->header_cell_add('NYCAHC', ['width'=>'40']);
	$rpt->header_row_end();
	$rpt->header_end();
	
	$rpt->data_start();
	while($row = $result->fetch(PDO::FETCH_OBJ)) :
		$rpt->data_row_start();
		$rpt->data_cell_add($row->first_name);
		$rpt->data_cell_add($row->last_name);
		$rpt->data_cell_add($row->title);
		$rpt->data_cell_add($row->email);
		$rpt->data_cell_add($row->work_phone);
		$rpt->data_cell_add($row->cell_phone);
		$rpt->data_cell_add($row->hotel_name);
		$rpt->data_cell_add($row->neighborhood_name);
		$rpt->data_cell_add($row->address);
		$rpt->data_cell_add($row->city);
		$rpt->data_cell_add($row->state);
		$rpt->data_cell_add($row->zip);
		$rpt->data_cell_add(($row->cgr == 1 ? 'Y' : ''));
		$rpt->data_cell_add(($row->gte_certified == 1 ? 'Y' : ''));
		$rpt->data_cell_add(($row->nycahc_member == 1 ? 'Y' : ''));
		$rpt->data_row_end();
	endwhile;
	$rpt->data_end();
	
	$rpt->report_end();
	$rpt->output_report();

?>