告别数据变更迷雾：使用Composer与SonataEntityAuditBundle轻松追踪Doctrine实体历史

<code class="bash">composer require sonata-project/entity-audit-bundle</code>

<pre class="brush:php;toolbar:false;">// config/bundles.php

return [
    // ...
    SimpleThings\EntityAudit\SimpleThingsEntityAuditBundle::class => ['all' => true],
    // ...
];

<pre class="brush:php;toolbar:false;"># config/packages/entity_audit.yaml

simple_things_entity_audit:
    audited_entities:
        - App\Entity\Product # 替换为你的实体类
        - App\Entity\Order   # 替换为你的实体类
    # 可选：全局忽略某些字段，例如创建时间、更新时间，避免不必要的修订记录
    global_ignore_columns:
        - created_at
        - updated_at
    # 可选：如果你使用非默认的 Doctrine 连接或实体管理器
    # connection: custom_connection_name
    # entity_manager: custom_entity_manager_name

<pre class="brush:php;toolbar:false;">php bin/console doctrine:schema:update --force
# 或者先查看SQL再执行
# php bin/console doctrine:schema:update --dump-sql

<pre class="brush:php;toolbar:false;"><?php

namespace App\Controller;

use SimpleThings\EntityAudit\AuditReader;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\Routing\Annotation\Route;
use App\Entity\Product; // 假设这是你要审计的实体

class AuditController extends AbstractController
{
    /**
     * @Route("/product/{id}/history", name="product_history")
     */
    public function showProductHistory(int $id, AuditReader $auditReader): Response
    {
        // 获取某个产品的所有修订历史
        $revisions = $auditReader->findRevisions(Product::class, $id);

        $history = [];
        foreach ($revisions as $revision) {
            // 获取该产品在特定修订版本时的状态
            $productAtRevision = $auditReader->find(Product::class, $id, $revision->getRev());
            $history[] = [
                'revision_id' => $revision->getRev(),
                'timestamp' => $revision->getTimestamp()->format('Y-m-d H:i:s'),
                'username' => $revision->getUsername() ?: '未知',
                'revtype' => $productAtRevision->getRevType(), // Bundle会在审计实体中添加这个方法
                'price' => $productAtRevision->getPrice(),
                'name' => $productAtRevision->getName(),
                // ... 其他你关心的字段
            ];
        }

        return $this->render('audit/product_history.html.twig', [
            'product_id' => $id,
            'history' => $history,
        ]);
    }
}

<pre class="brush:php;toolbar:false;"># config/routes.yaml

simple_things_entity_audit:
    resource: "@SimpleThingsEntityAuditBundle/Resources/config/routing/audit.xml"
    prefix: /audit # 审计界面的访问前缀，记得要对其进行安全保护！