<?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\MemberModel;
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;
use vonRotenberg\WeinanlieferungBundle\Model\WeinanlieferungUnitModel;
/**
* @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();
case 'validateNumber':
return $this->validateNumber();
}
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');
}*/
// Compute unit display fields for this reservation
$unitTitle = $GLOBALS['TL_LANG']['MSC']['wa_unit_base'] ?? 'Behälter';
$unitAmountDisplay = (int) $reservation->behaelter;
if ((int)$reservation->unit_id > 0) {
$unitModel = WeinanlieferungUnitModel::findByPk((int)$reservation->unit_id);
if (null !== $unitModel) {
$unitTitle = (string)$unitModel->title;
}
$unitAmountDisplay = (int) ($reservation->unit_amount ?: 0);
if ($unitAmountDisplay <= 0) {
$mult = (int) ($unitModel ? $unitModel->multiplier : 0);
$unitAmountDisplay = $mult > 0 ? max(1, (int) ($reservation->behaelter / $mult)) : (int) $reservation->behaelter;
}
}
$arrReservations[] = array_merge($reservation->row(),[
'sorten' => $arrSortenBooked,
'unit_title' => $unitTitle,
'unit_amount_display' => $unitAmountDisplay,
]);
}
}
// 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*1.5 > $intReservedBehaelter),
'behaelter' => range(min($intAvailableBehaelter,1),$Slot->behaelter*1.5-$intReservedBehaelter),
'units' => $this->getAvailableUnitsForCapacity($intAvailableBehaelter),
'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),
'units' => $this->getAvailableUnitsForCapacity($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();
// While editing, available base units should include the current booking's base units,
// because the edit will override the former amount.
$intAvailableBehaelter = max(0, $Slot->getAvailableBehaelter() + (int) $Booking->behaelter);
$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,
// display fields
'unit_title' => (function() use ($Booking) {
if ((int)$Booking->unit_id > 0) {
$m = WeinanlieferungUnitModel::findByPk((int)$Booking->unit_id);
return $m ? (string)$m->title : ($GLOBALS['TL_LANG']['MSC']['wa_unit_base'] ?? 'Behälter');
}
return $GLOBALS['TL_LANG']['MSC']['wa_unit_base'] ?? 'Behälter';
})(),
'unit_amount_display' => (function() use ($Booking) {
if ((int)$Booking->unit_id > 0) {
$m = WeinanlieferungUnitModel::findByPk((int)$Booking->unit_id);
$amount = (int) ($Booking->unit_amount ?: 0);
if ($amount > 0) return $amount;
$mult = (int) ($m ? $m->multiplier : 0);
return $mult > 0 ? max(1, (int) ($Booking->behaelter / $mult)) : (int) $Booking->behaelter;
}
return (int) $Booking->behaelter;
})(),
]),
'standort' => $Slot->getRelated('pid'),
'buchen' => [
'buchbar' => (boolean) $intAvailableBehaelter,
'behaelter' => range(min($intAvailableBehaelter,1),$Slot->behaelter*1.5-$Slot->getReservedBehaelter()+$Booking->behaelter),
'units' => $this->getAvailableUnitsForCapacity($intAvailableBehaelter),
'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);
}
// recompute the base units
$unitId = (int) Input::post('unit_id');
$unitAmount = (int) Input::post('unit_amount');
$multiplier = 1;
if ($unitId > 0) {
if (($u = WeinanlieferungUnitModel::findByPk($unitId)) !== null) {
$multiplier = max(1, (int) $u->multiplier);
}
}
$intBehaelter = $unitAmount > 0 ? $unitAmount * $multiplier : (int) Input::post('behaelter');
// Form validation and unit capacity
if (($Slot = WeinanlieferungSlotsModel::findByPk($_REQUEST['id'])) !== null)
{
if ($intBehaelter > $Slot->behaelter*1.5 - $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 (['sorten','ernteart','lage'] as $field)
{
if (empty(Input::post($field)))
{
$arrError = [$field];
}
}
// Require either (unit selection (allowing 0) with unit_amount, or behaelter fallback)
$postedUnitId = Input::post('unit_id');
$hasUnitId = ($postedUnitId !== null && $postedUnitId !== '' && $postedUnitId !== false);
if (!$hasUnitId || empty(Input::post('unit_amount')))
{
if (empty(Input::post('behaelter')))
{
$arrError[] = 'behaelter';
}
}
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 ($intBehaelter > $Slot->behaelter - $Slot->getReservedBehaelter())
{
$arrData['approved'] = '';
$arrData['approved_on'] = 0;
} else {
$arrData['approved'] = '1';
$arrData['approved_on'] = $time;
}
// Determine fields to store
$arrData = array_merge($arrData,[
'pid' => $_REQUEST['id'],
'tstamp' => $time,
'uid' => FrontendUser::getInstance()->id,
'behaelter' => $intBehaelter,
'unit_id' => $unitId,
'unit_amount' => $unitAmount,
'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;
}
}
// recompute base units
$unitId = (int) Input::post('unit_id');
$unitAmount = (int) Input::post('unit_amount');
$multiplier = 1;
if ($unitId > 0) {
if (($u = WeinanlieferungUnitModel::findByPk($unitId)) !== null) {
$multiplier = max(1, (int) $u->multiplier);
}
}
$intBehaelter = $unitAmount > 0 ? $unitAmount * $multiplier : (int) Input::post('behaelter');
// Form validation
/** @var WeinanlieferungSlotsModel $Slot */
if (($Slot = $Reservation->getRelated('pid')) !== null)
{
if ($intBehaelter > $Slot->behaelter*1.5 - $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 (['sorten','ernteart','lage'] as $field)
{
if (empty(Input::post($field)))
{
$arrError = [$field];
}
}
$postedUnitId = Input::post('unit_id');
$hasUnitId = ($postedUnitId !== null && $postedUnitId !== '' && $postedUnitId !== false);
if (!$hasUnitId || empty(Input::post('unit_amount')))
{
if (empty(Input::post('behaelter')))
{
$arrError[] = 'behaelter';
}
}
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 ($intBehaelter > $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 = $intBehaelter;
$Reservation->unit_id = $unitId;
$Reservation->unit_amount = $unitAmount;
$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, array $formData=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');
}
}
// Load the member model for the booking's user
$memberModel = MemberModel::findById($Booking->uid);
$currentMemberModel = MemberModel::findById(FrontendUser::getInstance()->id);
$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,
'expected' => ($Booking->unit_amount ?? 0) > 0 ? (int)$Booking->unit_amount : (int)$Booking->behaelter,
'unit_title' => (function() use ($Booking) {
if ((int)$Booking->unit_id > 0) {
$m = WeinanlieferungUnitModel::findByPk((int)$Booking->unit_id);
return $m ? (string)$m->title : ($GLOBALS['TL_LANG']['MSC']['wa_unit_base'] ?? 'Behälter');
}
return $GLOBALS['TL_LANG']['MSC']['wa_unit_base'] ?? 'Behälter';
})(),
'unit_amount_display' => (function() use ($Booking) {
if ((int)$Booking->unit_id > 0) {
$m = WeinanlieferungUnitModel::findByPk((int)$Booking->unit_id);
$amount = (int) ($Booking->unit_amount ?: 0);
if ($amount > 0) return $amount;
$mult = (int) ($m ? $m->multiplier : 0);
return $mult > 0 ? max(1, (int) ($Booking->behaelter / $mult)) : (int) $Booking->behaelter;
}
return (int) $Booking->behaelter;
})(),
],
'member' => $memberModel ? $memberModel->row() : null,
'current_member' => $currentMemberModel ? $currentMemberModel->row() : null
]);
// Add form data if provided (to preserve values after validation errors)
if ($formData !== null) {
$arrData['form_data'] = $formData;
}
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');
$expectedCount = ($Booking->unit_amount ?? 0) > 0 ? (int)$Booking->unit_amount : (int)$Booking->behaelter;
if (!is_array($behaelterNumbers) || count($behaelterNumbers) != $expectedCount)
{
// Prepare form data to preserve input values
$formData = [
'behaelter_numbers' => $behaelterNumbers ?: [],
'member_numbers' => Input::post('member_numbers') ?: []
];
return $this->renderCheckin(false, '<div class="toast toast--danger mx-0">Bitte wählen Sie für jede Einheit eine Nummer aus.</div>', $formData);
}
// Get member numbers from the form
$memberNumbers = Input::post('member_numbers');
// If member numbers are not provided or not an array, initialize an empty array
if (!is_array($memberNumbers) || count($memberNumbers) != $Booking->behaelter)
{
$memberNumbers = array_fill(0, count($behaelterNumbers), '');
}
// Get the current member's number to use as fallback
$currentMember = MemberModel::findById(FrontendUser::getInstance()->id);
$currentMemberNo = $currentMember ? $currentMember->memberno : '';
// 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))
{
// Prepare form data to preserve input values
$formData = [
'behaelter_numbers' => $behaelterNumbers,
'member_numbers' => $memberNumbers
];
return $this->renderCheckin(false, '<div class="toast toast--danger mx-0">Jede Nummer kann nur einmal verwendet werden.</div>', $formData);
}
// Validate all numbers on the server side as a final check
$invalidNumbers = [];
$currentTime = time();
$Slot = $Booking->getRelated('pid');
$Standort = $Slot->getRelated('pid');
// Get all used numbers from current bookings (excluding past bookings)
$usedNumbers = [];
// Get the database connection
$db = Controller::getContainer()->get('database_connection');
// 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 != ?
AND s.pid = ?"; // Only check for the same standort
$stmt = $db->prepare($sql);
$stmt->bindValue(1, $currentTime);
$stmt->bindValue(2, $Booking->id);
$stmt->bindValue(3, $Standort->id);
$result = $stmt->executeQuery();
while ($row = $result->fetchAssociative()) {
$numbers = json_decode($row['behaelter_numbers'], true);
if (is_array($numbers)) {
foreach ($numbers as $item) {
$usedNumbers[] = isset($item['behaelter']) ? $item['behaelter'] : $item;
}
}
}
// Check each number
foreach ($behaelterNumbers as $index => $number) {
// Skip the special value 9999
if ($number === '9999') {
continue;
}
// Check if the number is numeric
if (!is_numeric($number)) {
$invalidNumbers[] = "Behälter " . ($index + 1) . ": Die eingegebene Nummer ist keine gültige Zahl.";
continue;
}
// Check if the number is already in use
if (in_array($number, $usedNumbers)) {
$invalidNumbers[] = "Behälter " . ($index + 1) . ": Diese Nummer wird bereits in einer anderen aktiven Buchung verwendet.";
continue;
}
// Check if the number is within the valid ranges for this standort
$validRanges = $Standort->extractNumbersFromRanges([], 10000); // Get all possible numbers
if (!in_array($number, $validRanges) && !empty($validRanges)) {
$invalidNumbers[] = "Behälter " . ($index + 1) . ": Die eingegebene Nummer liegt nicht im gültigen Bereich für diesen Standort.";
}
}
// If there are invalid numbers, return an error
if (!empty($invalidNumbers)) {
$errorMessage = '<div class="toast toast--danger mx-0"><p>Folgende Fehler wurden gefunden:</p><ul>';
foreach ($invalidNumbers as $error) {
$errorMessage .= '<li>' . $error . '</li>';
}
$errorMessage .= '</ul></div>';
// Prepare form data to preserve input values
$formData = [
'behaelter_numbers' => $behaelterNumbers,
'member_numbers' => $memberNumbers,
'invalid_fields' => array_map(function($error) {
// Extract the behälter number from the error message
if (preg_match('/Behälter (\d+):/', $error, $matches)) {
return (int)$matches[1] - 1; // Convert to zero-based index
}
return null;
}, $invalidNumbers)
];
return $this->renderCheckin(false, $errorMessage, $formData);
}
// Create combined array with behaelter numbers and member numbers
$combinedData = [];
foreach ($behaelterNumbers as $index => $behaelterNumber) {
$memberNumber = !empty($memberNumbers[$index]) ? $memberNumbers[$index] : $currentMemberNo;
$combinedData[] = [
'behaelter' => $behaelterNumber,
'member' => $memberNumber
];
}
// Save the check-in data
$time = time();
$Booking->checked_in = '1';
$Booking->checked_in_on = $time;
$Booking->behaelter_numbers = json_encode($combinedData);
$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[] = isset($number['behaelter']) ? $number['behaelter'] : $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']);
}
protected function validateNumber()
{
if (empty($_REQUEST['id']) || !isset($_REQUEST['number']))
{
return new Response(json_encode(['valid' => false, 'message' => 'Required parameters missing']), 412, ['Content-Type' => 'application/json']);
}
$number = $_REQUEST['number'];
// Special case: "Nummer nicht bekannt" is always valid
if ($number === '9999') {
return new Response(json_encode(['valid' => true]), 200, ['Content-Type' => 'application/json']);
}
// Check if the number is a valid number format
if (!is_numeric($number)) {
return new Response(json_encode([
'valid' => false,
'message' => 'Die eingegebene Nummer ist keine gültige Zahl.'
]), 200, ['Content-Type' => 'application/json']);
}
/** @var WeinanlieferungReservationModel $Booking */
if (($Booking = WeinanlieferungReservationModel::findById($_REQUEST['id'])) === null || ($Slot = $Booking->getRelated('pid')) === null)
{
return new Response(json_encode(['valid' => false, 'message' => 'Could not load booking data']), 500, ['Content-Type' => 'application/json']);
}
// Get the standort to access the number_ranges
$Standort = $Slot->getRelated('pid');
if ($Standort === null)
{
return new Response(json_encode(['valid' => false, 'message' => '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');
// 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 != ?
AND s.pid = ?"; // Only check for the same standort
$stmt = $db->prepare($sql);
$stmt->bindValue(1, $currentTime);
$stmt->bindValue(2, $Booking->id);
$stmt->bindValue(3, $Standort->id);
$result = $stmt->executeQuery();
while ($row = $result->fetchAssociative()) {
$numbers = json_decode($row['behaelter_numbers'], true);
if (is_array($numbers)) {
foreach ($numbers as $item) {
$usedNumbers[] = isset($item['behaelter']) ? $item['behaelter'] : $item;
}
}
}
// Check if the number is already in use
if (in_array($number, $usedNumbers)) {
return new Response(json_encode([
'valid' => false,
'message' => 'Diese Nummer wird bereits in einer anderen aktiven Buchung verwendet.'
]), 200, ['Content-Type' => 'application/json']);
}
// Check if the number is within the valid ranges for this standort
$validRanges = $Standort->extractNumbersFromRanges([], 10000); // Get all possible numbers
if (!in_array($number, $validRanges) && !empty($validRanges)) {
return new Response(json_encode([
'valid' => false,
'message' => 'Die eingegebene Nummer liegt nicht im gültigen Bereich für diesen Standort.'
]), 200, ['Content-Type' => 'application/json']);
}
// If we got here, the number is valid
return new Response(json_encode(['valid' => true]), 200, ['Content-Type' => 'application/json']);
}
protected function getAvailableUnitsForCapacity(int $availableBaseUnits): array
{
// Always include the base unit (Behälter) with multiplier 1
$units = [];
$units[] = [
'id' => 0,
'title' => $GLOBALS['TL_LANG']['MSC']['wa_unit_base'] ?? 'Behälter',
'multiplier' => 1,
'max_amount' => $availableBaseUnits, // one check-in per base unit
];
// Load custom units from DB
if (($all = WeinanlieferungUnitModel::findAll()) !== null) {
foreach ($all as $unit) {
$mult = (int)($unit->multiplier ?? 0);
if ($mult < 1) {
continue; // skip invalid
}
// A unit fits if at least one of it can be placed into remaining capacity
$maxAmount = intdiv(max(0, $availableBaseUnits), $mult);
if ($maxAmount < 1) {
continue; // does not fit current capacity
}
$units[] = [
'id' => (int)$unit->id,
'title' => (string)$unit->title,
'multiplier' => $mult,
'max_amount' => $maxAmount,
];
}
}
return $units;
}
}