bundles/VehicleMarketBundle/Document/Areabrick/vehicleListing.php line 56

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace VehicleMarketBundle\Document\Areabrick;
  7. use Knp\Component\Pager\PaginatorInterface;
  8. use Pimcore\Extension\Document\Areabrick\AbstractTemplateAreabrick;
  9. use Pimcore\Extension\Document\Areabrick\EditableDialogBoxConfiguration;
  10. use Pimcore\Extension\Document\Areabrick\EditableDialogBoxInterface;
  11. use Pimcore\Db;
  12. use Pimcore\Model\DataObject\DealerLocation;
  13. use Pimcore\Model\DataObject\Vehicle;
  14. use Pimcore\Model\DataObject\VehicleFilter;
  15. use Pimcore\Model\DataObject\VehicleFilterEntity;
  16. use Pimcore\Model\Document\Editable;
  17. use Pimcore\Model\Document\Editable\Area\Info;
  18. use Symfony\Component\Form\FormFactory;
  19. use Symfony\Component\Form\FormInterface;
  20. use Symfony\Component\HttpFoundation\JsonResponse;
  21. use Symfony\Component\HttpFoundation\Request;
  22. use Symfony\Component\HttpFoundation\Session\Attribute\AttributeBag;
  23. use Symfony\Component\HttpFoundation\Session\Attribute\NamespacedAttributeBag;
  24. use VehicleMarketBundle\Document\Form\CarListFilterFormType;
  25. use VehicleMarketBundle\Service\CampaignSchedule;
  26. use Pimcore\Translation\Translator;
  27. use Pimcore\Tool\Session;
  29. class vehicleListing extends AbstractTemplateAreabrick implements EditableDialogBoxInterface
  31. {
  33.     /**
  34.      * @var PaginatorInterface
  35.      */
  36.     protected $paginator;
  38.     public function getName()
  39.     {
  40.         return 'Vehicle Listing';
  41.     }
  43.     public function __construct(PaginatorInterface $paginator, Translator $translator)
  44.     {
  45.         $this->paginator = $paginator;
  46.         $this->translator = $translator;
  47.     }
  49.     /**
  50.      * @Route("/fahrzeugmarkt", name="carSearch", methods={"GET"})
  51.      *
  52.      * @param Request $request
  53.      *
  54.      * @throws \Exception
  55.      */
  56.     public function action(Info $info)
  57.     {
  58.         $session = $info->getRequest()->getSession();
  59.         /** @var AttributeBag $bag */
  60.         $bag = $session->getBag('search_url');
  61.         $bag->set('search_url', $info->getRequest()->getRequestUri());
  63.         $carFilterURLElement = $info->getDocumentElement('carFilterURL');
  64.         $filterCount = $info->getDocumentElement('displayCount');
  65.         if (isset($carFilterURLElement) && method_exists($carFilterURLElement, 'getData') && !empty($carFilterURLElement->getData())) {
  66.             $carFilterURL = $carFilterURLElement->getData();
  67.             $parts = parse_url($carFilterURL);
  68.             if ($parts['query'] === null) {
  69.                 $parts['query'] = '';
  70.             }
  71.             parse_str($parts['query'], $preselectCarFilterQuery);
  72.         } else {
  73.             $preselectCarFilterQuery = null;
  74.         }
  76.         $make = explode("/", $info->getRequest()->getPathInfo(), 3);
  78.         /**
  79.          * @var FormInterface $form
  80.          */
  81.         $form = $this->container->get('form.factory')->create(CarListFilterFormType::class, null, ['csrf_protection' => false, 'data' => new VehicleFilter()]);
  83.         $condition = '1=1';
  84.         $joinCondition = '';
  85.         $filterBricks = [];
  86.         $sortOrder = 'asc';
  87.         $sortOrderKey = null;
  89.         $form->handleRequest($info->getRequest());
  90.         if (($form->isSubmitted() && $form->isValid())) {
  91.             $filterData = $form->getData();
  92.             if ($filterData->getSortOrder() !== null) {
  93.                 switch ($filterData->getSortOrder()) {
  94.                     case 'sort_price_increasing':
  95.                         $filterBricks[] = "Costs";
  96.                         $sortOrder = 'asc';
  97.                         $sortOrderKey = 'preis';
  98.                         break;
  99.                     case 'sort_price_decreasing':
  100.                         $filterBricks[] = "Costs";
  101.                         $sortOrder = 'desc';
  102.                         $sortOrderKey = 'preis';
  103.                         break;
  104.                     case 'sort_mileage_increasing':
  105.                         $filterBricks[] = "vehicleBaseData";
  106.                         $sortOrder = 'asc';
  107.                         $sortOrderKey = 'kilometer';
  108.                         break;
  109.                     case 'sort_mileage_decreasing':
  110.                         $filterBricks[] = "vehicleBaseData";
  111.                         $sortOrder = 'desc';
  112.                         $sortOrderKey = 'kilometer';
  113.                         break;
  114.                     case 'sort_rate_increasing':
  115.                         $filterBricks[] = "vehicleBaseData";
  116.                         $sortOrder = 'asc';
  117.                         $sortOrderKey = 'filterRate';
  118.                         break;
  119.                     case 'sort_rate_decreasing':
  120.                         $filterBricks[] = "vehicleBaseData";
  121.                         $sortOrder = 'desc';
  122.                         $sortOrderKey = 'filterRate';
  123.                         break;
  124.                 }
  125.             }
  127.             if ($filterData->getCarMake() || !empty($preselectCarFilterQuery['car_list_filter_form']['car_make'])) {
  128.                 $filterBricks[] = "vehicleBaseData";
  129.                 $carMake = empty($preselectCarFilterQuery['car_list_filter_form']['car_make']) || $filterData->getCarMake() ? $filterData->getCarMake() : $preselectCarFilterQuery['car_list_filter_form']['car_make'];
  130.                 $condition .= " and vehicleBaseData.marke LIKE '" . $carMake . "' ";
  131.             }
  133.             if ($filterData->getCarModel()) {
  134.                 $filterBricks[] = "vehicleBaseData";
  136.                 if(str_contains($filterData->getCarModel(), 'alle ')) {
  137.                     switch ($filterData->getCarModel()) {
  138.                         case 'alle 1er':
  139.                             $condition .= " and vehicleBaseData.modellbasis LIKE '1%' ";
  140.                             break;
  141.                         case 'alle 2er':
  142.                             $condition .= " and vehicleBaseData.modellbasis LIKE '2%' ";
  143.                             break;
  144.                         case 'alle 3er':
  145.                             $condition .= " and vehicleBaseData.modellbasis LIKE '3%' ";
  146.                             break;
  147.                         case 'alle 4er':
  148.                             $condition .= " and vehicleBaseData.modellbasis LIKE '4%' ";
  149.                             break;
  150.                         case 'alle 5er':
  151.                             $condition .= " and vehicleBaseData.modellbasis LIKE '5%' ";
  152.                             break;
  153.                         case 'alle 6er':
  154.                             $condition .= " and vehicleBaseData.modellbasis LIKE '6%' ";
  155.                             break;
  156.                         case 'alle 7er':
  157.                             $condition .= " and vehicleBaseData.modellbasis LIKE '7%' ";
  158.                             break;
  159.                         case 'alle 8er':
  160.                             $condition .= " and vehicleBaseData.modellbasis LIKE '8%' ";
  161.                             break;
  162.                         case 'alle i-Modelle':
  163.                             $condition .= " and vehicleBaseData.modellbasis LIKE 'i%' ";
  164.                             break;
  165.                         case 'alle M-Modelle':
  166.                             $condition .= " and vehicleBaseData.modellbasis LIKE 'M%' ";
  167.                             break;
  168.                         case 'alle X-Modelle':
  169.                             $condition .= " and vehicleBaseData.modellbasis LIKE 'X%' ";
  170.                             break;
  171.                         case 'alle Z-Modelle':
  172.                             $condition .= " and vehicleBaseData.modellbasis LIKE 'Z%' ";
  173.                             break;
  174.                     }
  175.                 } else {
  176.                     $condition .= " and vehicleBaseData.modellbasis LIKE '" . $filterData->getCarModel() . "' ";
  177.                 }
  178.             }
  180.             if ($filterData->getCarType()) {
  181.                 $filterBricks[] = "vehicleBaseData";
  182.                 $condition .= " and vehicleBaseData.kategorie LIKE '" . $filterData->getCarType() . "' ";
  183.             }
  185.             if ($filterData->getCarAgeType()) {
  186.                 $filterBricks[] = "vehicleBaseData";
  187.                 switch ($filterData->getCarAgeType()) {
  188.                     case 'Jahreswagen':
  189.                         $condition .= " and vehicleBaseData.jahreswagen = 1 ";
  190.                         break;
  191.                     case 'Vorführfahrzeug':
  192.                         $condition .= " and vehicleBaseData.vorfuehrfahrzeug = 1 ";
  193.                         break;
  194.                     case 'Neufahrzeug':
  195.                         $condition .= " and vehicleBaseData.neufahrzeug = 1 ";
  196.                         break;
  197.                     case 'Gebrauchtfahrzeug':
  198.                         $condition .= " and vehicleBaseData.neufahrzeug = 0 ";
  199.                         break;
  200.                 }
  203.             }
  205.             if ($filterData->getRegistrationYearStart()) {
  206.                 $filterBricks[] = "vehicleBaseData";
  207.                 $condition .= " and vehicleBaseData.ezYear >= '" . $filterData->getRegistrationYearStart() . "' ";
  208.             }
  210.             if ($filterData->getRegistrationYearEnd()) {
  211.                 $filterBricks[] = "vehicleBaseData";
  212.                 $condition .= " and vehicleBaseData.ezYear <= '" . $filterData->getRegistrationYearEnd() . "' ";
  213.             }
  215.             if ($filterData->getMonthlyRateMin()) {
  216.                 $filterBricks[] = "vehicleBaseData";
  217.                 $condition .= " and filterRate >= '" . $filterData->getMonthlyRateMin() . "' ";
  218.             }
  220.             if ($filterData->getMonthlyRateMax()) {
  221.                 $filterBricks[] = "vehicleBaseData";
  222.                 // `filterRate > 0` because 0 means "no bookable rate", not "free": without it a
  223.                 // "up to 300 EUR/month" filter returns every vehicle that has no leasing rate at
  224.                 // all. 391 of 923 vehicles currently carry 0 and another 123 carry NULL.
  225.                 // The MIN filter needs no counterpart - 0 and NULL both fail `>= <min>` already.
  226.                 $condition .= " and filterRate > 0 and filterRate <= '" . $filterData->getMonthlyRateMax() . "' ";
  227.             }
  229.             if ($filterData->getKmDriven()) {
  230.                 $filterBricks[] = "vehicleBaseData";
  231.                 $condition .= " and vehicleBaseData.kilometer <= '" . $filterData->getKmDriven() . "' ";
  232.             }
  234.             if ($filterData->getFuel()) {
  235.                 $filterBricks[] = "TechnicalData";
  236.                 $condition .= " and TechnicalData.kraftstoffart LIKE '" . $filterData->getFuel() . "' ";
  237.             }
  239.             if ($filterData->getTransmission()) {
  240.                 $filterBricks[] = "TechnicalData";
  241.                 $condition .= " and TechnicalData.getriebeart LIKE '" . $filterData->getTransmission() . "' ";
  242.             }
  244.             if ($filterData->getColor()) {
  245.                 $filterBricks[] = "Exterieur";
  246.                 $condition .= " and Exterieur.grundfarbeAussen LIKE '" . $filterData->getColor() . "' ";
  247.             }
  249.             if ($filterData->getCarLocation()) {
  250.                 $location = DealerLocation::getList()->filterByName($filterData->getCarLocation())->current();
  251.                 $filterBricks[] = "vehicleBaseData";
  252.                 $condition .= " and vehicleBaseData.filialId = '" . $location->getLocationId() . "' ";
  253.             }
  255.             if ($filterData->getCarAvailability()) {
  256.                 $filterBricks[] = "vehicleBaseData";
  258.                 if ($filterData->getCarAvailability() === 'now') {
  259.                     $condition .= " and STR_TO_DATE(vehicleBaseData.lieferdatum, \"%d.%m.%Y\") < NOW() ";
  260.                 } else {
  261.                     $condition .= " and STR_TO_DATE(vehicleBaseData.lieferdatum, \"%d.%m.%Y\") >= NOW() ";
  262.                 }
  263.             }
  265.             if ($filterData->getQualityBadge()) {
  266.                 $filterBricks[] = "vehicleBaseData";
  267.                 $condition .= " and vehicleBaseData.qualitaetssiegel LIKE '" . $filterData->getQualityBadge() . "' ";
  268.             }
  270.             if ($filterData->getCampaignName()) {
  271.                 $filterBricks[] = "vehicleBaseData";
  272.                 $condition .= $this->campaignCondition($filterData->getCampaignName());
  273.             }
  275.         } elseif ($preselectCarFilterQuery !== null) {
  276.             if (isset($preselectCarFilterQuery['car_list_filter_form'])) {
  277.                 $filterData = $preselectCarFilterQuery['car_list_filter_form'];
  278.                 if (!$form->isSubmitted()) {
  279.                     $form->setData($filterData);
  280.                 }
  281.             }
  283. //            dd($filterData);
  285.             if ($filterData['sort_order'] !== null) {
  286.                 switch ($filterData['sort_order']) {
  287.                     case 'sort_price_increasing':
  288.                         $filterBricks[] = "Costs";
  289.                         $sortOrder = 'asc';
  290.                         $sortOrderKey = 'preis';
  291.                         break;
  292.                     case 'sort_price_decreasing':
  293.                         $filterBricks[] = "Costs";
  294.                         $sortOrder = 'desc';
  295.                         $sortOrderKey = 'preis';
  296.                         break;
  297.                     case 'sort_mileage_increasing':
  298.                         $filterBricks[] = "vehicleBaseData";
  299.                         $sortOrder = 'asc';
  300.                         $sortOrderKey = 'kilometer';
  301.                         break;
  302.                     case 'sort_mileage_decreasing':
  303.                         $filterBricks[] = "vehicleBaseData";
  304.                         $sortOrder = 'desc';
  305.                         $sortOrderKey = 'kilometer';
  306.                         break;
  307.                     case 'sort_rate_increasing':
  308.                         $filterBricks[] = "vehicleBaseData";
  309.                         $sortOrder = 'asc';
  310.                         $sortOrderKey = 'filterRate';
  311.                         break;
  312.                     case 'sort_rate_decreasing':
  313.                         $filterBricks[] = "vehicleBaseData";
  314.                         $sortOrder = 'desc';
  315.                         $sortOrderKey = 'filterRate';
  316.                         break;
  317.                 }
  318.             }
  320.             if ($filterData['car_make']) {
  321.                 $filterBricks[] = "vehicleBaseData";
  322.                 $condition .= " and vehicleBaseData.marke LIKE '" . $filterData['car_make'] . "' ";
  323.             }
  325.             if ($filterData['car_model']) {
  326.                 $filterBricks[] = "vehicleBaseData";
  328.                 if(str_contains($filterData['car_model'], 'alle ')) {
  329.                     switch ($filterData['car_model']) {
  330.                         case 'alle 1er':
  331.                             $condition .= " and vehicleBaseData.modellbasis LIKE '1%' ";
  332.                             break;
  333.                         case 'alle 2er':
  334.                             $condition .= " and vehicleBaseData.modellbasis LIKE '2%' ";
  335.                             break;
  336.                         case 'alle 3er':
  337.                             $condition .= " and vehicleBaseData.modellbasis LIKE '3%' ";
  338.                             break;
  339.                         case 'alle 4er':
  340.                             $condition .= " and vehicleBaseData.modellbasis LIKE '4%' ";
  341.                             break;
  342.                         case 'alle 5er':
  343.                             $condition .= " and vehicleBaseData.modellbasis LIKE '5%' ";
  344.                             break;
  345.                         case 'alle 6er':
  346.                             $condition .= " and vehicleBaseData.modellbasis LIKE '6%' ";
  347.                             break;
  348.                         case 'alle 7er':
  349.                             $condition .= " and vehicleBaseData.modellbasis LIKE '7%' ";
  350.                             break;
  351.                         case 'alle 8er':
  352.                             $condition .= " and vehicleBaseData.modellbasis LIKE '8%' ";
  353.                             break;
  354.                         case 'alle i-Modelle':
  355.                             $condition .= " and vehicleBaseData.modellbasis LIKE 'i%' ";
  356.                             break;
  357.                         case 'alle M-Modelle':
  358.                             $condition .= " and vehicleBaseData.modellbasis LIKE 'M%' ";
  359.                             break;
  360.                         case 'alle X-Modelle':
  361.                             $condition .= " and vehicleBaseData.modellbasis LIKE 'X%' ";
  362.                             break;
  363.                         case 'alle Z-Modelle':
  364.                             $condition .= " and vehicleBaseData.modellbasis LIKE 'Z%' ";
  365.                             break;
  366.                     }
  367.                 } else {
  368.                     $condition .= " and vehicleBaseData.modellbasis LIKE '" . $filterData['car_model'] . "' ";
  369.                 }
  370.             }
  373.             if ($filterData['car_type']) {
  374.                 $filterBricks[] = "vehicleBaseData";
  375.                 $condition .= " and vehicleBaseData.kategorie LIKE '" . $filterData['car_type'] . "' ";
  376.             }
  378.             if ($filterData['car_age_type']) {
  379.                 $filterBricks[] = "vehicleBaseData";
  380.                 switch ($filterData['car_age_type']) {
  381.                     case 'Jahreswagen':
  382.                         $condition .= " and vehicleBaseData.jahreswagen = 1 ";
  383.                         break;
  384.                     case 'Vorführfahrzeug':
  385.                         $condition .= " and vehicleBaseData.vorfuehrfahrzeug = 1 ";
  386.                         break;
  387.                     case 'Neufahrzeug':
  388.                         $condition .= " and vehicleBaseData.neufahrzeug = 1 ";
  389.                         break;
  390.                     case 'Gebrauchtfahrzeug':
  391.                         $condition .= " and vehicleBaseData.neufahrzeug = 0 ";
  392.                         break;
  393.                 }
  395.             }
  397.             if ($filterData['registration_year_start']) {
  398.                 $filterBricks[] = "vehicleBaseData";
  399.                 $condition .= " and vehicleBaseData.ezYear >= '" . $filterData['registration_year_start'] . "' ";
  400.             }
  402.             if ($filterData['registration_year_end']) {
  403.                 $filterBricks[] = "vehicleBaseData";
  404.                 $condition .= " and vehicleBaseData.ezYear <= '" . $filterData['registration_year_end'] . "' ";
  405.             }
  407.             if ($filterData['monthly_rate_min']) {
  408.                 $filterBricks[] = "vehicleBaseData";
  409.                 $condition .= " and filterRate >= '" . $filterData['monthly_rate_min'] . "' ";
  410.             }
  412.             if ($filterData['monthly_rate_max']) {
  413.                 $filterBricks[] = "vehicleBaseData";
  414.                 // See the same filter on the form path above: 0 means "no bookable rate".
  415.                 $condition .= " and filterRate > 0 and filterRate <= '" . $filterData['monthly_rate_max'] . "' ";
  416.             }
  418.             if ($filterData['km_driven']) {
  419.                 $filterBricks[] = "vehicleBaseData";
  420.                 $condition .= " and vehicleBaseData.kilometer <= '" . $filterData['km_driven'] . "' ";
  421.             }
  423.             if ($filterData['fuel']) {
  424.                 $filterBricks[] = "TechnicalData";
  425.                 $condition .= " and TechnicalData.kraftstoffart LIKE '" . $filterData['fuel'] . "' ";
  426.             }
  428.             if ($filterData['transmission']) {
  429.                 $filterBricks[] = "TechnicalData";
  430.                 $condition .= " and TechnicalData.getriebeart LIKE '" . $filterData['transmission'] . "' ";
  431.             }
  433.             if ($filterData['color']) {
  434.                 $filterBricks[] = "Exterieur";
  435.                 $condition .= " and Exterieur.grundfarbeAussen LIKE '" . $filterData['color'] . "' ";
  436.             }
  438.             if ($filterData['car_location']) {
  439.                 $location = DealerLocation::getList()->filterByName($filterData['car_location'])->current();
  440.                 $filterBricks[] = "vehicleBaseData";
  441.                 $condition .= " and vehicleBaseData.filialId = '" . $location->getLocationId() . "' ";
  442.             }
  444.             if ($filterData['car_availability']) {
  445.                 $filterBricks[] = "vehicleBaseData";
  447.                 if ($filterData['car_availability'] === 'now') {
  448.                     $condition .= " and STR_TO_DATE(vehicleBaseData.lieferdatum, \"%d.%m.%Y\") < NOW() ";
  449.                 } else {
  450.                     $condition .= " and STR_TO_DATE(vehicleBaseData.lieferdatum, \"%d.%m.%Y\") >= NOW() ";
  451.                 }
  452.             }
  454.             if ($filterData['quality_badge']) {
  455.                 $filterBricks[] = "vehicleBaseData";
  456.                 $condition .= " and vehicleBaseData.qualitaetssiegel LIKE '" . $filterData['quality_badge'] . "' ";
  457.             }
  459.             if ($filterData['campaign_name']) {
  460.                 $filterBricks[] = "vehicleBaseData";
  461.                 $condition .= $this->campaignCondition($filterData['campaign_name']);
  462.             }
  463.         }
  466. //        if (isset($make[2])) {
  467. //            $filterBricks[] = "vehicleBaseData";
  468. //            $condition .= " and vehicleBaseData.marke LIKE '" . $make[2] . "' ";
  469. //        }
  470. //
  471.         $filterBricks = array_unique($filterBricks);
  473.         if (count($filterBricks) == 0) {
  474.             $cars = Vehicle::getList();
  475.         } else {
  477.             $cars = Vehicle::getList([
  478.                 "objectbricks" => $filterBricks,
  479.                 "condition" => $condition,
  480.                 "orderKey" => $sortOrderKey,
  481.                 "order" => $sortOrder
  482.             ]);
  483.         }
  485.         $this->keepRatelessVehiclesLast($cars, $sortOrderKey, $sortOrder);
  487.         if ($info->getRequest()->get('json') == 1) {
  488.             return new JsonResponse(
  489.                 ['count' => $cars->getCount()]
  490.             );
  491.         }
  493.         //dd($cars->getQueryBuilder()->getSQL());
  495.         $paginator = $this->paginator->paginate(
  496.             $cars,
  497.             intval($info->getRequest()->get('page', 1)),
  498.             9
  499.         );
  501.         $info->setParam('paginatedCars', $paginator);
  502.         $info->setParam('paginationVariables', $paginator->getPaginationData());
  503.         $info->setParam('form', $form->createView());
  504.         $info->setParam('isBackendUser', (Session::getReadOnly()->get("user")));
  505.     }
  507.     /**
  508.      * SQL fragment for the Kampagne filter.
  509.      *
  510.      * `campaignNames` is a multiselect stored as ",A,B," in the query table, so membership is a
  511.      * LIKE on the comma-delimited value.
  512.      *
  513.      * A campaign that is not running today matches nothing. The dropdown only offers running
  514.      * campaigns (see CarListFilterFormType), but a bookmarked or shared URL can still carry an
  515.      * ended or not-yet-started one - and a vehicle's campaignNames keeps every campaign automedia
  516.      * delivered, including announced ones. Ignoring the filter instead would silently show the
  517.      * full inventory as if the promotion still applied.
  518.      */
  519.     protected function campaignCondition(string $campaignName): string
  520.     {
  521.         if (!(new CampaignSchedule())->isRunning($campaignName)) {
  522.             return ' and 1 = 0 ';
  523.         }
  525.         return ' and vehicleBaseData.campaignNames LIKE ' . Db::get()->quote('%,' . $campaignName . ',%') . ' ';
  526.     }
  528.     /**
  529.      * Sorting by rate ascending must not put the vehicles that have no rate first.
  530.      *
  531.      * `filterRate` is 0 for a vehicle with no bookable leasing rate and NULL for one the ingest
  532.      * never touched - currently 391 and 123 of 923 vehicles. Plain `ORDER BY filterRate asc`
  533.      * therefore fills the first 514 places of "cheapest rate first" with vehicles that show no
  534.      * rate at all, before the cheapest real offer appears.
  535.      *
  536.      * Fixed by ordering, not by filtering: a sort order must not change which vehicles are in the
  537.      * result. The leading term is a boolean - 0 for "has a rate", 1 for "has none" - so the rated
  538.      * vehicles come first, ascending by rate, and the rest keep their place at the end.
  539.      * `setOrderKey(..., false)` passes the expression through unquoted, and Pimcore appends the
  540.      * direction to the whole string (Model\Listing\Dao\QueryBuilderHelperTrait::applyOrderByToQueryBuilder),
  541.      * which is why this is one string and not two keys.
  542.      *
  543.      * Descending needs no help: there, 0 and NULL already sort last.
  544.      */
  545.     protected function keepRatelessVehiclesLast(Vehicle\Listing $cars, ?string $sortOrderKey, string $sortOrder): void
  546.     {
  547.         if ($sortOrderKey !== 'filterRate' || strtolower($sortOrder) !== 'asc') {
  548.             return;
  549.         }
  551.         $cars->setOrderKey('IFNULL(filterRate, 0) = 0, filterRate', false);
  552.     }
  554.     protected function filterFuelTypes(Vehicle $entries, array $search)
  555.     {
  556.         if (!empty($search['kraftstoff'])) {
  557.             $query = '';
  558.             $fuelTypeParams = [];
  559.             for ($i = 0; $i < count($search['kraftstoff']); $i++) {
  560.                 $query .= ' kraftstoffart = :f_type' . $i . ' OR ';
  561.                 $fuelTypeParams['f_type' . $i] = $search['kraftstoff'][$i];
  563.             }
  564.             $query = substr($query, 0, -4);
  566.             $entries->addConditionParam($query, $fuelTypeParams, 'AND');
  567.         }
  569.         return $entries;
  570.     }
  572.     public function getDescription()
  573.     {
  574.         return 'A component for rendering a list of cars';
  575.     }
  577.     public function getEditableDialogBoxConfiguration(Editable $area, ?Info $info): EditableDialogBoxConfiguration
  578.     {
  579.         $cars = Vehicle::getList();
  581.         return (new EditableDialogBoxConfiguration())
  582.             ->setItems([
  583.                 [
  584.                     'type' => 'input',
  585.                     'label' => $this->translator->trans('Url to filter the list:', [], 'admin'),
  586.                     'name' => 'carFilterURL'
  587.                 ],
  588.                 [
  589.                     'type' => 'relation',
  590.                     'label' => $this->translator->trans('Path to the vehicle details page:', [], 'admin'),
  591.                     'name' => 'carDetailPageUrl'
  592.                 ],
  593.                 [
  594.                     'type' => 'select',
  595.                     'name' => 'car-list-filter',
  596.                     'label' => $this->translator->trans('Show filters for the list?', [], 'admin'),
  597.                     'config' => [
  598.                         'store' => [
  599.                             [true, $this->translator->trans('Yes', [], 'admin'),],
  600.                             [false, $this->translator->trans('No', [], 'admin'),],
  601.                         ],
  602.                         'defaultValue' => true
  603.                     ]
  604.                 ],
  605.                 [
  606.                     'type' => 'select',
  607.                     'name' => 'car-list-available-from',
  608.                     'label' => $this->translator->trans('Show Car available from?', [], 'admin'),
  609.                     'config' => [
  610.                         'store' => [
  611.                             [true, $this->translator->trans('Yes', [], 'admin'),],
  612.                             [false, $this->translator->trans('No', [], 'admin'),],
  613.                         ],
  614.                         'defaultValue' => true
  615.                     ]
  616.                 ]
  617. //                ,
  618. //                [
  619. //                    'type' => 'numeric',
  620. //                    'label' => 'Display-Count',
  621. //                    'name' => 'displayCount'
  622. //                ]
  623.             ])
  624.             ->setHeight(460)
  625.             ->setReloadOnClose(true);
  626.     }
  628.     function process_something($cars)
  629.     {
  630.         $myArray = array();
  631.         foreach ($cars as $b) {
  632.             $myArray[] = array($b->getStammdaten()->getVehicleBaseData()->getMarke(), $b->getStammdaten()->getVehicleBaseData()->getMarke());
  633.         }
  634.         return $myArray;
  635.     }
  637.     public function getHtmlTagOpen(Info $info)
  638.     {
  639.         return '';
  640.     }
  642.     public function getHtmlTagClose(Info $info)
  643.     {
  644.         return '';
  645.     }
  647.     public function getTemplateLocation()
  648.     {
  649.         return static::TEMPLATE_LOCATION_BUNDLE;
  650.     }
  651. }