<?php

declare(strict_types=1);

/*
 * This file is part of contao-weinanlieferung-bundle.
 *
 * (c) vonRotenberg
 *
 * @license commercial
 */

namespace vonRotenberg\WeinanlieferungBundle\Controller\Frontend\Ajax;

use Contao\Controller;
use Contao\CoreBundle\Controller\AbstractController;
use Contao\CoreBundle\Exception\PageNotFoundException;
use Contao\CoreBundle\Framework\ContaoFramework;
use Contao\CoreBundle\Security\Authentication\Token\TokenChecker;
use Contao\Environment;
use Contao\File;
use Contao\FilesModel;
use Contao\FormFileUpload;
use Contao\Frontend;
use Contao\FrontendUser;
use Contao\Input;
use Contao\StringUtil;
use Contao\System;
use Doctrine\DBAL\Connection;
use Symfony\Component\EventDispatcher\EventDispatcherInterface;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\Routing\Annotation\Route;
use Symfony\Contracts\Translation\TranslatorInterface;
use vonRotenberg\WeinanlieferungBundle\Event\CheckInCompletedEvent;
use vonRotenberg\WeinanlieferungBundle\Model\WeinanlieferungLageModel;
use vonRotenberg\WeinanlieferungBundle\Model\WeinanlieferungLeseartModel;
use vonRotenberg\WeinanlieferungBundle\Model\WeinanlieferungRebsorteModel;
use vonRotenberg\WeinanlieferungBundle\Model\WeinanlieferungReservationModel;
use vonRotenberg\WeinanlieferungBundle\Model\WeinanlieferungSlotsModel;

/**
 * @Route("/_ajax/vr_wa/v1/slot", name="vr_wa_slot_ajax", defaults={"_scope" = "frontend", "_token_check" = false})
 */
class SlotAjaxController extends AbstractController
{
    private $tokenChecker;
    private $translator;
    private $framework;
    private $eventDispatcher;

    public function __construct(
        ContaoFramework $framework,
        TokenChecker $tokenChecker,
        TranslatorInterface $translator,
        EventDispatcherInterface $eventDispatcher
    )
    {
        $this->framework = $framework;
        $this->tokenChecker = $tokenChecker;
        $this->translator = $translator;
        $this->eventDispatcher = $eventDispatcher;
    }

    public function __invoke(Request $request)
    {
        System::loadLanguageFile('default');

        if (!$this->tokenChecker->hasFrontendUser())
        {
            return $this->renderUnauthorized();
        }

        if (empty($_REQUEST['do']))
        {
            return new Response('Required parameter missing',412);
        }

        $blnModal = true;

        if (!empty($_REQUEST['modal']))
        {
            $blnModal = !(strtolower($_REQUEST['modal']) == 'false');
        }

        switch ($_REQUEST['do'])
        {
            case 'details':
                return $this->renderDetails($blnModal);

            case 'annotation':
                return $this->renderAnnotation($blnModal);

            case 'booking':
                return $this->renderBooking($blnModal);

            case 'reservate':
                return $this->reservate();

            case 'updateReservation':
                return $this->updateReservation();

            case 'delete':
                return $this->deleteReservation();

            case 'checkin':
                return $this->renderCheckin($blnModal);

            case 'updateCheckin':
                return $this->updateCheckin();

            case 'getAvailableNumbers':
                return $this->getAvailableNumbers();
        }

        return new Response('',500);
    }

    protected function renderDetails(bool $blnModal=true,string $error=null)
    {
        $insertTagService = Controller::getContainer()->get('contao.insert_tag.parser');

        if (empty($_REQUEST['id']))
        {
            return new Response('Required parameter missing',412);
        }

        if (($Slot = WeinanlieferungSlotsModel::findPublishedById($_REQUEST['id'])) === null)
        {
            return new Response('Could not load slot data',500);
        }

        // Get slot reservations from user
        $arrReservations = [];

        if (($Reservations = WeinanlieferungReservationModel::findBy(["uid = ?","pid = ?"],[FrontendUser::getInstance()->id,$Slot->id])) !== null)
        {
            foreach ($Reservations as $reservation)
            {
                $arrSortenBooked = [];
                $SortenLeseart = explode(';',$reservation->sorten);
                foreach($SortenLeseart as $sorteLeseart)
                {
                    list($sorte,$leseart) = explode(',',$sorteLeseart);
                    $objSorte = WeinanlieferungRebsorteModel::findByPk($sorte);
                    $objLeseart = WeinanlieferungLeseartModel::findByPk($leseart);
                    $arrSortenBooked[$objSorte->id.','.$objLeseart->id] = ($objSorte !== null  ? $objSorte->title : '') . ' ' . ($objLeseart !== null  ? $objLeseart->title : '');
                }
                /*if (($Sorten = $reservation->getRelated('sorten')) !== null)
                {
                    $arrSortenBooked = $Sorten->fetchEach('title');
                }*/
                $arrReservations[] = array_merge($reservation->row(),[
                    'sorten' => $arrSortenBooked
                ]);
            }
        }

        // Build data
        $arrSorten = [];
        $Sorten = StringUtil::deserialize($Slot->sorten,true);
        foreach($Sorten as $sorte)
        {
            $objSorte = WeinanlieferungRebsorteModel::findByPk($sorte['sorte']);
            $objLeseart = WeinanlieferungLeseartModel::findByPk($sorte['leseart']);
            $arrSorten[$objSorte->id.','.$objLeseart->id] = ($objSorte !== null  ? $objSorte->title : '') . ' ' . ($objLeseart !== null  ? $objLeseart->title : '');
        }
        /*if (($Sorten = $Slot->getRelated('sorte')) !== null)
        {
            $arrSorten = array_combine($Sorten->fetchEach('id'),$Sorten->fetchEach('title'));
        }*/

        $arrErnteart = [];
        if ($Slot->ernteart !== null)
        {
            foreach (explode(',', $Slot->ernteart) as $ernteart)
            {
                $arrErnteart[$ernteart] = $GLOBALS['TL_LANG']['REF']['wa_ernteart'][$ernteart] ?? $ernteart;
            }
        }

        $arrLage = [];
        if (($Lage = $Slot->getRelated('lage')) !== null)
        {
            $arrLage = array_combine($Lage->fetchEach('id'),$Lage->fetchEach('title'));
        }

        $intReservedBehaelter = $Slot->getReservedBehaelter();
        $intAvailableBehaelter = max(0,$Slot->getAvailableBehaelter());

        $arrData = [
            'modal' => $blnModal,
            'id'       => $Slot->id,
            'slot'     => array_merge($Slot->row(),[
                'anmerkungen' => $insertTagService->replace($Slot->anmerkungen ?? ''),
                'sorte' => $arrSorten,
                'behaelterAvailable' => $intAvailableBehaelter,
                'behaelterBooked' => $Slot->getReservedBehaelter(),
            ]),
            'standort' => $Slot->getRelated('pid'),
            'lage' => $arrLage,
            'ernteart' => $arrErnteart,
            'buchen' => [
                'buchbar' => (boolean) ($Slot->behaelter*3 > $intReservedBehaelter),
                'behaelter' => range(min($intAvailableBehaelter,1),$Slot->behaelter*3-$intReservedBehaelter),
                'sorten' => $arrSorten,
                'lage' => $arrLage,
                'ernteart' => $arrErnteart,
            ],
            'reservations' => $arrReservations
        ];

        if (!empty($error))
        {
            $arrData['toast'] = $error;
        }

        return $this->render('@Contao/modal_slot_details.html.twig',$arrData);
    }

    protected function renderAnnotation(bool $blnModal=true,string $error=null)
    {
        $insertTagService = Controller::getContainer()->get('contao.insert_tag.parser');

        if (empty($_REQUEST['id']))
        {
            return new Response('Required parameter missing',412);
        }

        if (($Slot = WeinanlieferungSlotsModel::findPublishedById($_REQUEST['id'])) === null)
        {
            return new Response('Could not load slot data',500);
        }

        // Build data
        $arrSorten = [];
        $Sorten = StringUtil::deserialize($Slot->sorten,true);
        foreach($Sorten as $sorte)
        {
            $objSorte = WeinanlieferungRebsorteModel::findByPk($sorte['sorte']);
            $objLeseart = WeinanlieferungLeseartModel::findByPk($sorte['leseart']);
            $arrSorten[$objSorte->id.','.$objLeseart->id] = ($objSorte !== null  ? $objSorte->title : '') . ' ' . ($objLeseart !== null  ? $objLeseart->title : '');
        }

        $arrErnteart = [];
        if ($Slot->ernteart !== null)
        {
            foreach (explode(',', $Slot->ernteart) as $ernteart)
            {
                $arrErnteart[] = $GLOBALS['TL_LANG']['REF']['wa_ernteart'][$ernteart] ?? $ernteart;
            }
        }

        $arrLage = [];
        if (($Lage = $Slot->getRelated('lage')) !== null)
        {
            $arrLage = $Lage->fetchEach('title');
        }

        $intAvailableBehaelter = max(0,$Slot->getAvailableBehaelter());

        $arrData = [
            'modal' => $blnModal,
            'id'       => $Slot->id,
            'slot'     => array_merge($Slot->row(),[
                'anmerkungen' => $insertTagService->replace($Slot->anmerkungen ?? ''),
                'sorte' => $arrSorten,
                'behaelterAvailable' => $intAvailableBehaelter
            ]),
            'standort' => $Slot->getRelated('pid'),
            'lage' => $arrLage,
            'ernteart' => $arrErnteart,
            'buchen' => [
                'buchbar' => (boolean) $intAvailableBehaelter,
                'behaelter' => range(min($intAvailableBehaelter,1),$intAvailableBehaelter),
                'sorten' => $arrSorten
            ],
        ];

        return $this->render('@Contao/modal_slot_annotation.html.twig',$arrData);
    }

    protected function renderBooking(bool $blnModal=true,string $error=null)
    {
        $insertTagService = Controller::getContainer()->get('contao.insert_tag.parser');

        $arrData = [];

        if (empty($_REQUEST['id']))
        {
            return new Response('Required parameter missing',412);
        }

        /** @var WeinanlieferungSlotsModel $Slot */
        if (($Booking = WeinanlieferungReservationModel::findById($_REQUEST['id'])) === null || ($Slot = $Booking->getRelated('pid')) === null)
        {
            return new Response('Could not load booking data',500);
        }

        if ($Booking->approved === '0')
        {
            return $this->render('@Contao/modal_message.html.twig',['type'=>'danger','content'=>'Diese Buchungsanfrage wurde abgelehnt und kann nicht mehr geändert werden.']);
        }

        $objFile = FilesModel::findByUuid($Booking->upload);

        if (!empty($_REQUEST['deleteFile']) && $_REQUEST['deleteFile'] && $objFile !== null)
        {
            $File = new File($objFile->path);
            if ($File->delete())
            {
                $objFile->delete();
                $objFile = null;
            }
        }

        if (!empty($Booking->upload) && $objFile !== null)
        {
            $File = new File($objFile->path);
            $strHref = Environment::get('request');

            // Remove an existing file parameter (see #5683)
            if (isset($_GET['file']))
            {
                $strHref = preg_replace('/(&(amp;)?|\?)file=[^&]+/', '', $strHref);
            }

            $strHref .= (strpos($strHref, '?') !== false ? '&amp;' : '?') . 'file=' . System::urlEncode($File->value);

            $arrData['file'] = [
                'link' => $strHref,
                'filename' => $File->filename,
                'extension' => $File->extension,
                'name' => $File->name,
                'path' => $File->dirname
            ];
        }

        // Send the file to the browser (see #4632 and #8375)
        if ($objFile !== null && ($file = Input::get('file', true)))
        {
            if ($file == $objFile->path)
            {
                Controller::sendFileToBrowser($file);
            }
        }

        $arrSortenAvailable = [];
        $Sorten = StringUtil::deserialize($Slot->sorten,true);
        foreach($Sorten as $sorte)
        {
            $objSorte = WeinanlieferungRebsorteModel::findByPk($sorte['sorte']);
            $objLeseart = WeinanlieferungLeseartModel::findByPk($sorte['leseart']);
            $arrSortenAvailable[$objSorte->id.','.$objLeseart->id] = ($objSorte !== null  ? $objSorte->title : '') . ' ' . ($objLeseart !== null  ? $objLeseart->title : '');
        }
        $arrSortenBooked = [];
        $SortenLeseart = explode(';',$Booking->sorten);
        foreach($SortenLeseart as $sorteLeseart)
        {
            list($sorte,$leseart) = explode(',',$sorteLeseart);
            $objSorte = WeinanlieferungRebsorteModel::findByPk($sorte);
            $objLeseart = WeinanlieferungLeseartModel::findByPk($leseart);
            $arrSortenBooked[$objSorte->id.','.$objLeseart->id] = ($objSorte !== null  ? $objSorte->title : '') . ' ' . ($objLeseart !== null  ? $objLeseart->title : '');
        }

        $arrErnteartAvailable = [];
        if ($Slot->ernteart !== null)
        {
            foreach (explode(',', $Slot->ernteart) as $ernteart)
            {
                $arrErnteartAvailable[$ernteart] = $GLOBALS['TL_LANG']['REF']['wa_ernteart'][$ernteart] ?? $ernteart;
            }
        }
        $arrErnteartBooked = [];
        if ($Booking->ernteart !== null)
        {
            $arrErnteartBooked = explode(',', $Booking->ernteart);
        }

        $arrLagenAvailable = [];
        if (($Lagen = $Slot->getRelated('lage')) !== null)
        {
            foreach ($Lagen as $lage)
            {
                $arrLagenAvailable[$lage->id] = $lage->title;
            }
        }
        $arrLagenBooked = [];
        if ($Booking->lage !== null)
        {
            $arrLagenBooked = explode(',', $Booking->lage);
        }

        $intReservedBehaelter = $Slot->getReservedBehaelter();
        $intAvailableBehaelter = max($Booking->behaelter,$Slot->getAvailableBehaelter());
        $intOcTreshold = $intAvailableBehaelter - $intReservedBehaelter + $Slot->behaelter;

        $arrData = array_merge($arrData,[
            'modal' => $blnModal,
            'id'       => $Booking->id,
            'slot'     => array_merge($Slot->row(),[
                'anmerkungen' => $insertTagService->replace($Slot->anmerkungen ?? ''),
                'sorte' => $arrSortenAvailable,
                'behaelterAvailable' => $intAvailableBehaelter,
                'behaelterOcThreshold' => $intOcTreshold,
                'behaelterBooked' => $Slot->getReservedBehaelter(),
            ]),
            'buchung' => array_merge($Booking->row(),[
                'sorten' => $arrSortenBooked,
                'ernteart' => $arrErnteartBooked,
                'lage' => $arrLagenBooked,
            ]),
            'standort' => $Slot->getRelated('pid'),
            'buchen' => [
                'buchbar' => (boolean) $intAvailableBehaelter,
                'behaelter' => range(min($intAvailableBehaelter,1),$Slot->behaelter*3-$Slot->getReservedBehaelter()+$Booking->behaelter),
                'sorten' => $arrSortenAvailable,
                'ernteart' => $arrErnteartAvailable,
                'lage' => $arrLagenAvailable,
            ]
        ]);

        if (!empty($error))
        {
            $arrData['toast'] = $error;
        }

        return $this->render('@Contao/modal_booking_details.html.twig',$arrData);
    }

    protected function reservate()
    {
        Controller::loadDataContainer('tl_vr_wa_reservation');
        $arrData = [];

        if (($rootPage = Frontend::getRootPageFromUrl()) !== null && !empty($rootPage->vr_wa_uploadFolderSRC))
        {
            $File = new FormFileUpload(\Contao\Widget::getAttributesFromDca($GLOBALS['TL_DCA']['tl_vr_wa_reservation']['fields']['upload'], 'upload'));
            $File->storeFile = true;
            $File->doNotOverwrite = true;
            $File->uploadFolder = $rootPage->vr_wa_uploadFolderSRC;

            $File->validate();

            if ($File->hasErrors())
            {
                return $this->renderDetails(false,'<div class="toast toast--danger mx-0">' . $File->getErrorAsHTML() . '</div>');
            }

            if (!empty($_SESSION['FILES'][$File->name]))
            {
                $arrData['filename'] = $_SESSION['FILES'][$File->name]['name'] ?? '';
                $arrData['upload'] = $_SESSION['FILES'][$File->name]['uuid'] ? StringUtil::uuidToBin($_SESSION['FILES'][$File->name]['uuid']) : null;
            }
        }

        if (empty($_REQUEST['id']))
        {
            return new Response('Missing parameter',412);
        }

        // Form validation
        if (($Slot = WeinanlieferungSlotsModel::findByPk($_REQUEST['id'])) !== null)
        {
//            if (Input::post('behaelter') > $Slot->getAvailableBehaelter())
            if (Input::post('behaelter') > $Slot->behaelter*3-$Slot->getReservedBehaelter())
            {
                return $this->renderDetails(false,sprintf('<div class="toast toast--danger mx-0">Fehler: Es sind mittlerweile nur noch %s Behälter verfügbar.</div>',$Slot->getAvailableBehaelter()));
            }
        }
        $arrError = [];
        foreach (['behaelter','sorten','ernteart','lage'] as $field)
        {
            if (empty(Input::post($field)))
            {
                $arrError = [$field];
            }
        }

        if (count($arrError))
        {
            return $this->renderDetails(false,'<div class="toast toast--danger mx-0">Bitte geben Sie alle Pflichtangaben (mit * markierte Felder) an</div>');
        }

        $arrSorten = [];
        if (!is_array(Input::post('sorten')))
        {
            $arrSorten[] = Input::post('sorten');
        } else {
            $arrSorten = implode(';', Input::post('sorten'));
        }

        $arrErnteart = [];
        if (!is_array(Input::post('ernteart')))
        {
            $arrErnteart[] = Input::post('ernteart');
        } else {
            $arrErnteart = implode(',', Input::post('ernteart'));
        }

        $arrLage = [];
        if (!is_array(Input::post('lage')))
        {
            $arrLage[] = Input::post('lage');
        } else {
            $arrLage = implode(',', Input::post('lage'));
        }

        $Reservation = new WeinanlieferungReservationModel();

        $time = time();

        if (Input::post('behaelter') > $Slot->behaelter - $Slot->getReservedBehaelter())
        {
            $arrData['approved'] = '';
            $arrData['approved_on'] = 0;
        } else {
            $arrData['approved'] = '1';
            $arrData['approved_on'] = $time;
        }

        $arrData = array_merge($arrData,[
            'pid' => $_REQUEST['id'],
            'tstamp' => $time,
            'uid' => FrontendUser::getInstance()->id,
            'behaelter' => Input::post('behaelter'),
            'sorten' => $arrSorten,
            'ernteart' => $arrErnteart,
            'lage' => $arrLage
        ]);
        $Reservation->setRow($arrData);

        $Reservation->save();

        if (empty($Reservation->approved))
        {
            return new Response('<div class="toast toast--warning mx-0"><p>Wir haben Ihre Anfrage erhalten. Bitte warten Sie auf eine Freigabe durch uns.</p></div>',200,['HX-Trigger'=> 'updateWaBooking']);
        }

        return new Response('<div class="toast toast--success mx-0"><p>Reservierung erfolgreich</p></div>',200,['HX-Trigger'=> 'updateWaList']);
    }

    protected function updateReservation()
    {
        Controller::loadDataContainer('tl_vr_wa_reservation');

        if (empty($_REQUEST['id']))
        {
            return new Response('Missing parameter',412);
        }

        if (($Reservation = WeinanlieferungReservationModel::findById($_REQUEST['id'])) === null)
        {
            return new Response('Could not load booking data',500);
        }

        if (FrontendUser::getInstance()->id != $Reservation->uid)
        {
            return new Response('Member not authorized tu update this reservation',500);
        }

        if (($rootPage = Frontend::getRootPageFromUrl()) !== null && !empty($rootPage->vr_wa_uploadFolderSRC))
        {
            $File = new FormFileUpload(\Contao\Widget::getAttributesFromDca($GLOBALS['TL_DCA']['tl_vr_wa_reservation']['fields']['upload'], 'upload'));
            $File->storeFile = true;
            $File->doNotOverwrite = true;
            $File->uploadFolder = $rootPage->vr_wa_uploadFolderSRC;

            $File->validate();

            if ($File->hasErrors())
            {
                return $this->renderBooking(false,'<div class="toast toast--danger mx-0">' . $File->getErrorAsHTML() . '</div>');
            }

            if (!empty($_SESSION['FILES'][$File->name]))
            {
                $Reservation->filename = $_SESSION['FILES'][$File->name]['name'] ?? '';
                $Reservation->upload = $_SESSION['FILES'][$File->name]['uuid'] ? StringUtil::uuidToBin($_SESSION['FILES'][$File->name]['uuid']) : null;
            }
        }

        // Form validation
        /** @var WeinanlieferungSlotsModel $Slot */
        if (($Slot = $Reservation->getRelated('pid')) !== null)
        {
//            if (Input::post('behaelter') > $Slot->getAvailableBehaelter()+$Reservation->behaelter)
            if (Input::post('behaelter') > $Slot->behaelter*3-$Slot->getReservedBehaelter()+$Reservation->behaelter)
            {
                return $this->renderBooking(false,sprintf('<div class="toast toast--danger mx-0">Fehler: Es sind mittlerweile nur noch %s Behälter verfügbar.</div>',$Slot->getAvailableBehaelter()+$Reservation->behaelter));
            }
        }
        $arrError = [];
        foreach (['behaelter','sorten','ernteart','lage'] as $field)
        {
            if (empty(Input::post($field)))
            {
                $arrError = [$field];
            }
        }

        if (count($arrError))
        {
            return $this->renderBooking(false,'<div class="toast toast--danger mx-0">Bitte geben Sie alle Pflichtangaben (mit * markierte Felder) an</div>');
        }

        $arrSorten = [];
        if (!is_array(Input::post('sorten')))
        {
            $arrSorten[] = Input::post('sorten');
        } else {
            $arrSorten = implode(';', Input::post('sorten'));
        }

        $arrErnteart = [];
        if (!is_array(Input::post('ernteart')))
        {
            $arrErnteart[] = Input::post('ernteart');
        } else {
            $arrErnteart = implode(',', Input::post('ernteart'));
        }

        $arrLage = [];
        if (!is_array(Input::post('lage')))
        {
            $arrLage[] = Input::post('lage');
        } else {
            $arrLage = implode(',', Input::post('lage'));
        }

        $time = time();

        if (Input::post('behaelter') > $Slot->behaelter - $Slot->getReservedBehaelter() + $Reservation->behaelter)
        {
            $Reservation->approved = '';
            $Reservation->approved_on = 0;
        } else {
            $Reservation->approved = '1';
            $Reservation->approved_on = $time;
        }

        $Reservation->tstamp = $time;
        $Reservation->behaelter = Input::post('behaelter');
        $Reservation->sorten = $arrSorten;
        $Reservation->ernteart = $arrErnteart;
        $Reservation->lage = $arrLage;

        $Reservation->save();

        if (empty($Reservation->approved))
        {
            return new Response('<div class="toast toast--warning mx-0"><p>Wir haben Ihre Anfrage erhalten. Bitte warten Sie auf eine Freigabe durch uns.</p></div>',200,['HX-Trigger'=> 'updateWaBooking']);
        }

        return new Response('<div class="toast toast--success mx-0"><p>Reservierung erfolgreich geändert</p></div>',200,['HX-Trigger'=> 'updateWaBooking']);
    }

    protected function deleteReservation()
    {
        if (empty($_REQUEST['id']))
        {
            return new Response('Missing parameter',412);
        }

        /** @var Connection $db */
        $db = Controller::getContainer()->get('database_connection');

        $arrCriteria = [
            'uid' => FrontendUser::getInstance()->id,
            'id' => $_REQUEST['id']
        ];

        if ($db->delete('tl_vr_wa_reservation',$arrCriteria))
        {
            return new Response(null,203,['HX-Trigger'=> 'updateWaBooking']);
        }

        return new Response('Could not delete',500);
    }

    protected function renderUnauthorized()
    {
        return $this->render('@Contao/modal_unauthorized.html.twig');
    }

    protected function renderCheckin(bool $blnModal=true, string $error=null)
    {
        $insertTagService = Controller::getContainer()->get('contao.insert_tag.parser');

        $arrData = [];

        if (empty($_REQUEST['id']))
        {
            return new Response('Required parameter missing', 412);
        }

        /** @var WeinanlieferungReservationModel $Booking */
        if (($Booking = WeinanlieferungReservationModel::findById($_REQUEST['id'])) === null || ($Slot = $Booking->getRelated('pid')) === null)
        {
            return new Response('Could not load booking data', 500);
        }

        if ($Booking->approved === '0')
        {
            return $this->render('@Contao/modal_message.html.twig', ['type'=>'danger', 'content'=>'Diese Buchungsanfrage wurde abgelehnt und kann nicht eingecheckt werden.']);
        }

        if ($Booking->checked_in === '1')
        {
            return $this->render('@Contao/modal_message.html.twig', ['type'=>'info', 'content'=>'Diese Buchung wurde bereits eingecheckt.']);
        }

        // Get the standort to access the number_ranges
        $Standort = $Slot->getRelated('pid');
        if ($Standort === null)
        {
            return new Response('Could not load standort data', 500);
        }

        // Prepare data for the template
        $arrSortenBooked = [];
        $SortenLeseart = explode(';', $Booking->sorten);
        foreach($SortenLeseart as $sorteLeseart)
        {
            list($sorte, $leseart) = explode(',', $sorteLeseart);
            $objSorte = WeinanlieferungRebsorteModel::findByPk($sorte);
            $objLeseart = WeinanlieferungLeseartModel::findByPk($leseart);
            $arrSortenBooked[$objSorte->id.','.$objLeseart->id] = ($objSorte !== null ? $objSorte->title : '') . ' ' . ($objLeseart !== null ? $objLeseart->title : '');
        }

        $arrErnteartBooked = [];
        if ($Booking->ernteart !== null)
        {
            foreach (explode(',', $Booking->ernteart) as $ernteart)
            {
                $arrErnteartBooked[] = $GLOBALS['TL_LANG']['REF']['wa_ernteart'][$ernteart] ?? $ernteart;
            }
        }

        $arrLagenBooked = [];
        if ($Booking->lage !== null)
        {
            if (($Lagen = $Booking->getRelated('lage')) !== null)
            {
                $arrLagenBooked = $Lagen->fetchEach('title');
            }
        }

        $arrData = array_merge($arrData, [
            'modal' => $blnModal,
            'id' => $Booking->id,
            'slot' => array_merge($Slot->row(), [
                'anmerkungen' => $insertTagService->replace($Slot->anmerkungen ?? ''),
            ]),
            'buchung' => array_merge($Booking->row(), [
                'sorten' => $arrSortenBooked,
                'ernteart' => $arrErnteartBooked,
                'lage' => $arrLagenBooked,
            ]),
            'standort' => $Standort,
            'checkin' => [
                'behaelter' => $Booking->behaelter,
            ]
        ]);

        if (!empty($error))
        {
            $arrData['toast'] = $error;
        }

        return $this->render('@Contao/modal_checkin.html.twig', $arrData);
    }

    protected function updateCheckin()
    {
        if (empty($_REQUEST['id']))
        {
            return new Response('Missing parameter', 412);
        }

        /** @var WeinanlieferungReservationModel $Booking */
        if (($Booking = WeinanlieferungReservationModel::findById($_REQUEST['id'])) === null)
        {
            return new Response('Could not load booking data', 500);
        }

        // Validate that we have the correct number of behaelter numbers
        $behaelterNumbers = Input::post('behaelter_numbers');
        if (!is_array($behaelterNumbers) || count($behaelterNumbers) != $Booking->behaelter)
        {
            return $this->renderCheckin(false, '<div class="toast toast--danger mx-0">Bitte wählen Sie für jeden Behälter eine Nummer aus.</div>');
        }

        // Filter out the special value 9999 ("Nummer nicht bekannt") for duplicate check
        $numbersForDuplicateCheck = array_filter($behaelterNumbers, function($number) {
            return $number !== '9999';
        });

        // Check for duplicate numbers (excluding the special value 9999)
        if (count(array_unique($numbersForDuplicateCheck)) != count($numbersForDuplicateCheck))
        {
            return $this->renderCheckin(false, '<div class="toast toast--danger mx-0">Jede Nummer kann nur einmal verwendet werden.</div>');
        }

        // Save the check-in data
        $time = time();
        $Booking->checked_in = '1';
        $Booking->checked_in_on = $time;
        $Booking->behaelter_numbers = json_encode($behaelterNumbers);
        $Booking->tstamp = $time;
        $Booking->save();

        // Create reservation data array for the event
        $reservationData = $Booking->row();

        // Dispatch the check-in completed event
        $event = new CheckInCompletedEvent($reservationData, $Booking);
        $this->eventDispatcher->dispatch($event, CheckInCompletedEvent::NAME);

        return new Response('<div class="toast toast--success mx-0"><p>Check-in erfolgreich durchgeführt</p></div>', 200, ['HX-Trigger'=> 'updateWaBooking']);
    }

    protected function getAvailableNumbers()
    {
        if (empty($_REQUEST['id']))
        {
            return new Response('Required parameter missing', 412);
        }

        /** @var WeinanlieferungReservationModel $Booking */
        if (($Booking = WeinanlieferungReservationModel::findById($_REQUEST['id'])) === null || ($Slot = $Booking->getRelated('pid')) === null)
        {
            return new Response('Could not load booking data', 500);
        }

        if ($Booking->approved === '0')
        {
            return new Response(json_encode(['error' => 'Diese Buchungsanfrage wurde abgelehnt und kann nicht eingecheckt werden.']), 400, ['Content-Type' => 'application/json']);
        }

        if ($Booking->checked_in === '1')
        {
            return new Response(json_encode(['error' => 'Diese Buchung wurde bereits eingecheckt.']), 400, ['Content-Type' => 'application/json']);
        }

        // Get the standort to access the number_ranges
        $Standort = $Slot->getRelated('pid');
        if ($Standort === null)
        {
            return new Response(json_encode(['error' => 'Could not load standort data']), 500, ['Content-Type' => 'application/json']);
        }

        // Get all used numbers from current bookings (excluding past bookings)
        $usedNumbers = [];
        $currentTime = time();

        // Get the database connection
        $db = Controller::getContainer()->get('database_connection');

        // More efficient query to get used numbers from current bookings
        $sql = "SELECT r.behaelter_numbers
                FROM tl_vr_wa_reservation r
                JOIN tl_vr_wa_slot s ON r.pid = s.id
                WHERE r.behaelter_numbers != ''
                AND s.time >= ?
                AND r.id != ?";

        $stmt = $db->prepare($sql);
        $stmt->bindValue(1, $currentTime);
        $stmt->bindValue(2, $Booking->id);
        $result = $stmt->executeQuery();

        while ($row = $result->fetchAssociative()) {
            $numbers = json_decode($row['behaelter_numbers'], true);
            if (is_array($numbers)) {
                foreach ($numbers as $number) {
                    $usedNumbers[] = $number;
                }
            }
        }

        // Get a batch of available numbers
        // We'll limit to a reasonable number to improve performance
        $limit = 100; // Adjust this based on your needs
        if (!empty($_REQUEST['limit']) && is_numeric($_REQUEST['limit'])) {
            $limit = (int)$_REQUEST['limit'];
        }

        // Get available numbers directly, excluding used ones
        $availableNumbers = $Standort->extractNumbersFromRanges($usedNumbers, $limit);

        // Add the special option "Nummer nicht bekannt" with value 9999
        // This option should always be available and can be used multiple times
        array_unshift($availableNumbers, '9999');

        // Return the numbers as JSON
        return new Response(json_encode(['numbers' => $availableNumbers]), 200, ['Content-Type' => 'application/json']);
    }
}