<?php
require_once("includes/config.inc.php");

$MAX_PARKING_INDOOR = 5;

//echo API_CONNECTION;
//die();
/**
 * @var \Fusio\Engine\ConnectorInterface $connector
 * @var \Fusio\Engine\ContextInterface $context
 * @var \Fusio\Engine\RequestInterface $request
 * @var \Fusio\Engine\Response\FactoryInterface $response
 * @var \Fusio\Engine\ProcessorInterface $processor
 * @var \Psr\Log\LoggerInterface $logger
 * @var \Psr\SimpleCache\CacheInterface $cache
 */

use PSX\Http\Exception as StatusCode;

/** @var \Doctrine\DBAL\Connection $connection */
$connection = $connector->getConnection( API_CONNECTION );


if( !isset( $_GET['ship'] ) || !isset( $_GET['start'] ) || !isset( $_GET['end'] ) ) die('no access');


	$dbCall = $connection->fetchAll('
			SELECT
				event_calendar_begin,
				event_calendar_end,
				event_calendar_title,
				IF(
					(SELECT
						COUNT(bs.booking_id) AS valet
					FROM pacim_booking bs
						LEFT JOIN pacim_invoice isu ON isu.invoice_id = bs.booking_invoice
						LEFT JOIN pacim_invoice_pos ipsu ON ipsu.invoice_id = isu.invoice_id
					WHERE DATE_FORMAT(bs.booking_begin, "%Y-%m-%d") = DATE_FORMAT(e.event_calendar_begin, "%Y-%m-%d")
						AND isu.invoice_status != 3
						AND isu.invoice_no NOT LIKE "AIDA-%"
						AND ipsu.product_id = 8
						AND DATE_FORMAT(bs.booking_end, "%Y-%m-%d") = DATE_FORMAT(e.event_calendar_end, "%Y-%m-%d")
					) >= e.event_calendar_valet,
					 0,
					 1
				) AS event_valet,
				
				
				IF(
					(
						SELECT IF(e.event_calendar_title LIKE "AIDA%", 0, 10-COUNT(b.booking_id))
						FROM pacim_booking b
						LEFT JOIN pacim_invoice i ON i.invoice_id = b.booking_id
						WHERE b.booking_type LIKE "Halle%"
						AND b.booking_event_id = e.event_calendar_id
						AND b.booking_no NOT LIKE "%-AIDA-%"
						AND i.invoice_status != 3
					) < 1,
					0,
					1
				) AS event_indoor,
				
				
				/*IF((SELECT IF(e.event_calendar_title LIKE "AIDA%", 0, 10-COUNT(b.booking_id)) FROM pacim_booking b LEFT JOIN pacim_invoice i ON i.invoice_id = b.booking_id WHERE b.booking_type LIKE "Halle%" AND b.booking_event_id = e.event_calendar_id AND i.invoice_no NOT LIKE "AIDA-%" AND i.invoice_status != 3) < 1, 0, 1) AS event_indoor,*/
				IF((SELECT 20-COUNT(b.booking_id) FROM pacim_booking b LEFT JOIN pacim_invoice i ON i.invoice_id = b.booking_id WHERE b.booking_type LIKE "Außen%" AND b.booking_event_id = e.event_calendar_id AND b.booking_no NOT LIKE "%-AIDA-%" AND i.invoice_status != 3) < 1, 0, 1) AS event_outdoor
			FROM pacim_events e
			WHERE event_calendar_title = "' . $_GET['ship'] . '"
				  AND event_calendar_begin >= "' . $_GET['start'] . '"
				  AND DATEDIFF(DATE_FORMAT(e.event_calendar_end, "%Y-%m-%d"), DATE_FORMAT(e.event_calendar_begin, "%Y-%m-%d")) <= DATEDIFF("' . $_GET['end'] . '", "' . $_GET['start'] . '")
				  AND (DATEDIFF("' . $_GET['end'] . '", "' . $_GET['start'] . '") - DATEDIFF(DATE_FORMAT(e.event_calendar_end, "%Y-%m-%d"), DATE_FORMAT(e.event_calendar_begin, "%Y-%m-%d"))) >= 0
			ORDER BY e.event_calendar_begin ASC, (DATEDIFF("' . $_GET['end'] . '", "' . $_GET['start'] . '") - DATEDIFF(DATE_FORMAT(e.event_calendar_end, "%Y-%m-%d"), DATE_FORMAT(e.event_calendar_begin, "%Y-%m-%d"))) ASC
			LIMIT 1;
		');

	$event = array(
		'ship' => $_GET['ship'],
		'start' => $_GET['start'],
		'end' => $_GET['end'],
		'event' => ( isset( $dbCall[0] ) ? $dbCall[0] : array('event_indoor' => 0, 'event_outdoor' => 0, 'event_valet' => 0) )
	);
		
	
	return $response->build(200, [], array(
    'status' => 'success',
	'connection' => API_CONNECTION,
	'result' => $event
	));