<?php
if( !isset( $_SERVER['HTTP_X_REQUESTED_WITH'] ) || ( isset( $_SERVER['HTTP_X_REQUESTED_WITH'] ) && $_SERVER['HTTP_X_REQUESTED_WITH'] != 'com.pacim.sa' ) ) {

    require_once("send_mail.php");

    sendEmail(
       'report@pacim.de',
       'POSSIBLE ATTACK by ' . getIPAddress(),
       content_mail( $_SERVER ),
       TRUE
    );

    die('forbidden');
}

/**
 * @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('PaCIM-PAS');


$count = $connection->fetchColumn('
	SELECT
	    COUNT(*)
	FROM pacim_messages m
	WHERE m.message_template = 8
	ORDER by m.message_datetime DESC
	' . ($request->getParameter('limit') ? 'LIMIT ' . $request->getParameter('limit') : '')
);


$arr_tickets = $connection->fetchAll('
	SELECT
		m.message_id as id,
		m.message_customer as customer,
		m.message_subject as subject,
		m.message_content as content,
		m.message_receiver as receiver,
		DATE_FORMAT(m.message_datetime, "%d.%m.%Y - %H:%i Uhr") AS date,
		c.customer_firstname as firstname,
		c.customer_lastname as lastname
	FROM pacim_messages m
		LEFT JOIN pacim_customer c ON c.customer_id = m.message_customer
	WHERE m.message_template = 8
	ORDER by m.message_datetime DESC
	' . ($request->getParameter('limit') ? 'LIMIT ' . $request->getParameter('limit') : '')
);

$arr_collect = array();

foreach($arr_tickets as $key => $ticket) {
	$arr_collect[ $key ] = $ticket;
	$arr_collect[ $key ]['content_short'] = strip_tags( $ticket['content'] );
}


return $response->build(200, [], array(
	'count' => $count,
	'entries' => $arr_collect
));