TYPO3扩展库:筛选1:N关系

CREATE TABLE tx_myextension_parent (
    uid int(11) NOT NULL AUTO_INCREMENT,
    title varchar(255) DEFAULT '' NOT NULL,
    PRIMARY KEY (uid)
);

CREATE TABLE tx_myextension_child (
    uid int(11) NOT NULL AUTO_INCREMENT,
    parent_uid int(11) DEFAULT '0' NOT NULL,
    title varchar(255) DEFAULT '' NOT NULL,
    PRIMARY KEY (uid),
    KEY parent_uid (parent_uid)
);

namespace MyVendor\MyExtension\Domain\Model;

use TYPO3\CMS\Extbase\DomainObject\AbstractEntity;

class Parent extends AbstractEntity
{
    /**
     * @var \TYPO3\CMS\Extbase\Persistence\ObjectStorage<\MyVendor\MyExtension\Domain\Model\Child>
     */
    protected $children = null;

    public function getChildren()
    {
        return $this->children;
    }

    public function setChildren(\TYPO3\CMS\Extbase\Persistence\ObjectStorage $children)
    {
        $this->children = $children;
    }
}

class Child extends AbstractEntity
{
    /**
     * @var int
     */
    protected $parentUid = 0;

    public function getParentUid()
    {
        return $this->parentUid;
    }

    public function setParentUid($parentUid)
    {
        $this->parentUid = $parentUid;
    }
}

namespace MyVendor\MyExtension\Domain\Repository;

use TYPO3\CMS\Extbase\Persistence\Repository;

class ParentRepository extends Repository
{
    public function findByParentUid($parentUid)
    {
        $query = $this->createQuery();
        $query->matching(
            $query->equals('parentUid', $parentUid)
        );
        return $query->execute();
    }
}

namespace MyVendor\MyExtension\Controller;

use TYPO3\CMS\Extbase\Mvc\Controller\ActionController;
use MyVendor\MyExtension\Domain\Model\Parent;
use MyVendor\MyExtension\Domain\Repository\ParentRepository;

class ParentController extends ActionController
{
    protected $parentRepository;

    public function injectParentRepository(ParentRepository $parentRepository)
    {
        $this->parentRepository = $parentRepository;
    }

    public function listAction()
    {
        $parentUid = 1; // 示例父记录UID
        $parents = $this->parentRepository->findByParentUid($parentUid);

        $this->view->assign('parents', $parents);
    }
}

<f:for each="{parents}" as="parent">
    <h2>{parent.title}</h2>
    <ul>
        <f:for each="{parent.children}" as="child">
            <li>{child.title}</li>
        </f:for>
    </ul>
</f:for>