您可以使用DoctrinepostLoad事件向实体添加“真实的”属性并按原样使用它

/**
 * Test
 *
 * @ORM\Entity
 * @ORM\HasLifecycleCallbacks
 */

class Test
{

    ...

    private $state;

    public function getState(): string
    {
       return $this->state;
    }

    /**
     * @ORM\PostLoad()
     */
    public function initState()
    {
        $this->state = $this->modifyStamp > $this->createStamp ? 'draft' : 'published';
    }
}

1. MySQL（〉= 5.7）生成列

（我还没有测试过这个方法）

namespace Entity;

use Doctrine\ORM\Mapping as ORM;

#[ORM\Entity]
class Test {
    #[ORM\Id]
    #[ORM\GeneratedValue]
    #[ORM\Column(type: 'integer')]
    private int|null $id = null;

    #[ORM\Column(type: 'integer')]
    private int|null $modifyStamp = null;

    #[ORM\Column(type: 'integer')]
    private int|null $createStamp = null;

    #[ORM\Column(
        type: "string",
        insertable: false,
        updatable: false,
        generated: "ALWAYS",
        columnDefinition: "GENERATED ALWAYS AS (CASE WHEN modifyStamp > createStamp THEN 'draft' ELSE 'published' END)
    )]
    private string|null $state = null;
}

$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder->select('c')->from('Entity\Test', 'c');
echo '<pre>';
var_export($queryBuilder->getQuery()->getResult());
echo '</pre>';

参见：https://www.doctrine-project.org/projects/doctrine-orm/en/2.14/reference/attributes-reference.html#column和：https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html

2.自定义补水器

(Ugly但不需要MySQL支持）
我能找到的唯一能让它在PHP中工作的东西是一个“丑陋”的水化代码黑客，这个黑客被Doctrine的ObjectHydrator的一些内部约定弄得更丑陋。

use Doctrine\ORM\Internal\Hydration\ObjectHydrator;

class CustomHydrator extends ObjectHydrator {

    private function remapScalars($mixedResultRow) {
        $object = $mixedResultRow[0];
        $remainingScalars = [];
        foreach($mixedResultRow as $name => $value) {
            if ($name == 0) {
                continue;
            }
            $setter = 'set' . ucfirst($name);
            if (method_exists($object, $setter)) {
                $object->$setter($value);
            } else {
                $remainingScalars[$name] = $value;
            }
        }
        return count($remainingScalars) == 0 ?
            $object :
            array_merge([$object], $remainingScalars);
    }

    protected function hydrateRowData(array $row, array &$result) {
        parent::hydrateRowData($row, $result);
        $latestKey = array_key_last($result);
        $latestItem = $result[$latestKey];
        if (is_array($latestItem)) {
            $result[$latestKey] = $this->remapScalars($latestItem);
        }
    }
}

这个实体就像你拥有的一样：

namespace Entity;

use Doctrine\ORM\Mapping as ORM;

#[ORM\Entity]
class Test {
    #[ORM\Id]
    #[ORM\GeneratedValue]
    #[ORM\Column(type: 'integer')]
    private int|null $id = null;

    #[ORM\Column(type: 'integer')]
    private int|null $modifyStamp = null;

    #[ORM\Column(type: 'integer')]
    private int|null $createStamp = null;

    private string|null $state = null;

    public function setState(string $newState) {
        $this->state = $newState;
    }
}

我在控制器中使用了以下代码：

$entityManager->getConfiguration()->addCustomHydrationMode(
    'CustomHydrator',
    'CustomHydrator'
);

$queryBuilder = $entityManager->createQueryBuilder();

$queryBuilder->select('c')->from('Entity\Test', 'c')->addSelect(
    "CASE WHEN c.modifyStamp > c.createStamp
        THEN 'draft' ELSE 'published' END AS state"
);

echo '<pre>';
var_export($queryBuilder->getQuery()->getResult('CustomHydrator'));
echo '</pre>';

3.数据库视图

如果其他方法都失败了，你可以使用一个MySQL视图，让你的实体Map到它。这样，视图就做了CASE WHEN，从你的实体的Angular 来看，它只是另一个列。