<?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 ? '&' : '?') . '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']);
}
}