Contao 5 Doctrine Relations: Wir bauen die Buchungs-Logik

1<?php
2
3namespace Acme\BeachsideBundle\Entity;
4
5use Acme\BeachsideBundle\Repository\BookingRepository;
6use Doctrine\DBAL\Types\Types;
7use Doctrine\ORM\Mapping as ORM;
8
9#[ORM\Entity(repositoryClass: BookingRepository::class)]
10#[ORM\Table(name: "tl_booking")]
11class Booking
12{
13    #[ORM\Id]
14    #[ORM\GeneratedValue]
15    #[ORM\Column]
16    private ?int $id = null;
17
18    #[ORM\Column(type: Types::INTEGER, options: ['unsigned' => true, 'default' => 0])]
19    private int $tstamp = 0;
20
21    // Startdatum als Unix Timestamp
22    #[ORM\Column(type: Types::INTEGER)]
23    private int $dateStart = 0;
24
25    // Enddatum als Unix Timestamp
26    #[ORM\Column(type: Types::INTEGER)]
27    private int $dateEnd = 0;
28
29    #[ORM\Column(length: 255)]
30    private ?string $customerName = null;
31
32    // --- HIER IST DIE RELATION ---
33    #[ORM\ManyToOne(inversedBy: 'bookings')]
34    #[ORM\JoinColumn(nullable: false)]
35    private ?BeachChair $beachChair = null;
36
37    // Getter & Setter
38
39    public function getId(): ?int
40    {
41        return $this->id;
42    }
43
44    public function getDateStart(): int
45    {
46        return $this->dateStart;
47    }
48
49    public function setDateStart(int $dateStart): static
50    {
51        $this->dateStart = $dateStart;
52        return $this;
53    }
54
55    public function getDateEnd(): int
56    {
57        return $this->dateEnd;
58    }
59
60    public function setDateEnd(int $dateEnd): static
61    {
62        $this->dateEnd = $dateEnd;
63        return $this;
64    }
65
66    public function getCustomerName(): ?string
67    {
68        return $this->customerName;
69    }
70
71    public function setCustomerName(string $customerName): static
72    {
73        $this->customerName = $customerName;
74        return $this;
75    }
76    
77    // Relation Getter/Setter
78    public function getBeachChair(): ?BeachChair
79    {
80        return $this->beachChair;
81    }
82
83    public function setBeachChair(?BeachChair $beachChair): static
84    {
85        $this->beachChair = $beachChair;
86        return $this;
87    }
88}

1// Oben bei den Uses hinzufügen:
2use Doctrine\Common\Collections\ArrayCollection;
3use Doctrine\Common\Collections\Collection;
4
5// In der Klasse hinzufügen:
6    #[ORM\OneToMany(mappedBy: 'beachChair', targetEntity: Booking::class)]
7    private Collection $bookings;
8
9    public function __construct()
10    {
11        $this->bookings = new ArrayCollection();
12    }
13
14    /**
15     * @return Collection<int, Booking>
16     */
17    public function getBookings(): Collection
18    {
19        return $this->bookings;
20    }

vendor/bin/contao-console doctrine:schema:update --dump-sql

vendor/bin/contao-console doctrine:schema:update --force

1<?php
2
3use Contao\DC_Table;
4
5$GLOBALS['TL_DCA']['tl_booking'] = [
6    'config' => [
7        'dataContainer' => DC_Table::class,
8        'sql' => [
9            'keys' => ['id' => 'primary'],
10        ],
11    ],
12    'list' => [
13        'sorting' => [
14            'mode' => 2, // Sortierung nach einem Feld mit Header
15            'fields' => ['beachChair'], // Gruppiert nach Strandkorb
16            'flag' => 1,
17            'panelLayout' => 'filter;search,limit',
18        ],
19        'label' => [
20            'fields' => ['customerName', 'dateStart', 'dateEnd'],
21            'showColumns' => true,
22            'format' => '%s (%s - %s)', // Formatierung folgt unten
23        ],
24        'operations' => [
25            'edit' => ['href' => 'act=edit', 'icon' => 'edit.svg'],
26            'delete' => ['href' => 'act=delete', 'icon' => 'delete.svg'],
27        ],
28    ],
29    'palettes' => [
30        'default' => 'beachChair,customerName;{date_legend},dateStart,dateEnd',
31    ],
32    'fields' => [
33        'id' => ['sql' => "int(10) unsigned NOT NULL auto_increment"],
34        'tstamp' => ['sql' => "int(10) unsigned NOT NULL default '0'"],
35        
36        // HIER IST DIE RELATION IM BACKEND
37        'beachChair' => [
38            'inputType' => 'select',
39            'filter' => true,
40            'sorting' => true,
41            // Magic: Tabelle.Feld -> Contao holt automatisch die Optionen!
42            'foreignKey' => 'tl_beach_chair.chairNumber', 
43            'eval' => ['mandatory' => true, 'includeBlankOption' => true, 'tl_class' => 'w50'],
44            'relation' => ['type' => 'belongsTo', 'load' => 'lazy'],
45        ],
46        
47        'customerName' => [
48            'inputType' => 'text',
49            'search' => true,
50            'eval' => ['mandatory' => true, 'maxlength' => 255, 'tl_class' => 'w50'],
51        ],
52        'dateStart' => [
53            'inputType' => 'text',
54            'eval' => ['mandatory' => true, 'rgxp' => 'date', 'datepicker' => true, 'tl_class' => 'w50 wizard'],
55        ],
56        'dateEnd' => [
57            'inputType' => 'text',
58            'eval' => ['mandatory' => true, 'rgxp' => 'date', 'datepicker' => true, 'tl_class' => 'w50 wizard'],
59        ],
60    ],
61];