在TYPO3 v10上从我的控制器保存系统类别

Question

我有一个理想模型和一个理想控制者。

我的模型的一个属性是类别（在db上有适当的列），我想在这个列中保存系统类别的uid。（后端表单没有问题）

我已经为前端用户创建了一个带有类别的想法的前端表单。此表单将一个ideaModel对象发送到我的ideaController

但是当我做$this-

是因为我的ideaModel属性是一个int，它应该是一个类别类型变量吗？或者对象存储？
我一直在尝试，但我不知道如何处理对象存储？我还不太了解打字错误。如果你知道问题是什么，或者对此有一个有用的指南，我将不胜感激。

理想模型。php

<?php

namespace Edu\EduIdeas\Domain\Model;

use TYPO3\CMS\Extbase\DomainObject\AbstractEntity;

class Idea extends AbstractEntity
{
    /**
     * title
     * 
     * @var string
     */
    protected $title = '';

    /**
     * description
     * 
     * @var string
     */
    protected $description = '';

    /**
     * category
     * 
     * @var int
     */
    protected $category = '';

    /**
     * status
     * 
     * @var int
     */
    protected $status = '';

    /**
     * user
     * 
     * @var int
     */
    protected $user = '';

    /**
     * likes
     * 
     * @var int
     */
    protected $likes = '';

    /**
     * Sets the title
     * 
     * @param string $title
     * @return void
     */
    public function setTitle(string $title): void
    {
        $this->title = $title;
    }

    /**
     * Returns the title
     * 
     * @return string $title
     */
    public function getTitle(): string
    {
        return $this->title;
    }

    /**
     * Sets the description
     * 
     * @param string $description
     * @return void
     */
    public function setDescription(string $description): void
    {
        $this->description = $description;
    }

    /**
     * Returns the description
     * 
     * @return string $description
     */
    public function getDescription(): string
    {
        return $this->description;
    }

    /**
     * Sets the category
     * 
     * @param int $category
     * @return void
     */
    public function setCategory(int $category): void
    {
        $this->category = $category;
    }

    /**
     * Returns the category
     * 
     * @return int $category
     */
    public function getCategory(): int
    {
        return $this->category;
    }
    
    /**
     * Sets the status
     * 
     * @param int $status
     */
    public function setStatus(int $status): void
    {
        $this->status = $status;
    }

    /**
     * Returns the status
     * 
     * @return int $status
     */
    public function getStatus(): int
    {
        return $this->status;
    }

    /**
     * Sets the user
     * 
     * @param int $user
     */
    public function setUser(int $user): void
    {
        $this->user = $user;
    }

    /**
     * Returns the user
     * 
     * @return int $user
     */
    public function getUser(): int
    {
        return $this->user;
    }

    /**
     * Sets the likes
     * 
     * @param int $likes
     */
    public function setLikes(int $likes): void
    {
        $this->likes = $likes;
    }

    /**
     * Returns the likes
     * 
     * @return int $likes
     */
    public function getLikes(): int
    {
        return $this->likes;
    }
}

思想控制者。php

<?php

namespace Edu\EduIdeas\Controller;

use TYPO3\CMS\Extbase\Annotation as Extbase;
use TYPO3\CMS\Extbase\Mvc\Controller\ActionController;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Core\Database\ConnectionPool;
use Edu\EduIdeas\Domain\Model\Idea;
use Edu\EduIdeas\Domain\Repository\IdeaRepository;
/***
 * For the full copyright and license information, please read the
 * LICENSE.txt file that was distributed with this source code.
 *
 *  (c) 2019 
 *
 ***/
/**
 * IdeasController
 */
class IdeasController extends ActionController
{
    /**
     * Inject the idea repository
     *
     * @param Edu\EduIdeas\Domain\Repository\IdeaRepository $ideaRepository
     */
    private $ideaRepository;

    public function injectIdeaRepository(IdeaRepository $ideaRepository)
    {
        $this->ideaRepository = $ideaRepository;
    }

    /**
     * action list
     * 
     * @return string An HTML with a list of posted aideas
     */
    public function listAction()
    {
        $ideas = $this->ideaRepository->findAll();
        $this->view->assign('ideas', $ideas);
    }
    /**
     * @param \Edu\EduIdeas\Domain\Model\Idea $idea The new Idea object
     * @return string An HTML form for creating a new idea
     * @Extbase\IgnoreValidation("newIdea")
     */
    public function newAction(Idea $newIdea = null)
    {
        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
        $categories = $queryBuilder->select('title', 'uid')->from('sys_category')->where($queryBuilder->expr()->eq('parent', $queryBuilder->createNamedParameter(7)))
        ->execute()->fetchAll();
        $this->view->assign('newIdea', $newIdea);
        $this->view->assign('categories', $categories);
    }
    /**
     * Creates a new Idea
     *
     * @param Idea $idea The idea to save on db
     * @return void
     */
    public function createAction(Idea $idea)
    {
        // TODO access protection
        $idea->setStatus(1);
        $idea->setUser($GLOBALS['TSFE']->fe_user->user['uid']);
        $this->ideaRepository->add($idea);
        $this->redirect('list');
    }
}

'category' => [
            'label' => 'LLL:EXT:hebo_ideas/Resources/Private/Language/locallang_db.xlf:hk_ideas_idea.category',
            'config' => [
                'type' => 'select',
                'renderType' => 'selectTree',
                'treeConfig' => [
                    'parentField' => 'parent',
                    'rootUid' => 7,
                    'appearance' => [
                        'showHeader' => false,
                        'expandAll' => true,
                    ],
                ],
                'foreign_table' => 'sys_category',
                'foreign_table_where' => ' AND (sys_category.sys_language_uid = 0 OR sys_category.l10n_parent = 0) ORDER BY sys_category.sorting',
                'size' => 10,
                'minitems' => 0,
                'maxitems' => 1,
            ]
         ],

PD：它是一个int




Answer 1

该错误表示您正试图将空字符串插入整数列。如何求解取决于表的结构。如果该列可为空，请将默认值设置为null：

protected $category = null;

或者，如果列具有其他默认值，例如0，则可以将其设置为该值。否则，您应该在插入之前显式地提供一个有效的整数值：

$idea->setCategory($categoryId);
$this->ideaRepository->add($idea);