أضف سجلّات تدقيق لتطبيق Laravel

CREATE TABLE audit_logs (
  id           BIGINT UNSIGNED AUTO_INCREMENT,
  occurred_at  DATETIME(6) NOT NULL,
  actor_id     BIGINT UNSIGNED NULL,
  actor_type   VARCHAR(60) NOT NULL,
  entity_id    BIGINT UNSIGNED NOT NULL,
  entity_type  VARCHAR(60) NOT NULL,
  action       VARCHAR(40) NOT NULL,
  payload      JSON NULL,
  PRIMARY KEY (id, occurred_at),
  KEY idx_entity (entity_type, entity_id, occurred_at),
  KEY idx_actor  (actor_type, actor_id, occurred_at)
)
ENGINE=InnoDB
PARTITION BY RANGE (TO_DAYS(occurred_at)) (
  PARTITION p_2026_01 VALUES LESS THAN (TO_DAYS('2026-02-01')),
  PARTITION p_2026_02 VALUES LESS THAN (TO_DAYS('2026-03-01')),
  PARTITION p_max     VALUES LESS THAN MAXVALUE
);

public function up(): void
{
    DB::statement(<<<'SQL'
        CREATE TABLE audit_logs (
            id           BIGINT UNSIGNED AUTO_INCREMENT,
            occurred_at  DATETIME(6) NOT NULL,
            actor_id     BIGINT UNSIGNED NULL,
            actor_type   VARCHAR(60) NOT NULL,
            entity_id    BIGINT UNSIGNED NOT NULL,
            entity_type  VARCHAR(60) NOT NULL,
            action       VARCHAR(40) NOT NULL,
            payload      JSON NULL,
            PRIMARY KEY (id, occurred_at),
            KEY idx_entity (entity_type, entity_id, occurred_at),
            KEY idx_actor  (actor_type, actor_id, occurred_at)
        )
        ENGINE=InnoDB
        PARTITION BY RANGE (TO_DAYS(occurred_at)) (
            PARTITION p_max VALUES LESS THAN MAXVALUE
        )
    SQL);
}

public function handle(): int
{
    $next = now()->addMonth()->startOfMonth();
    $name = 'p_' . $next->format('Y_m');
    $boundary = $next->copy()->addMonth()->format('Y-m-d');

    DB::statement("ALTER TABLE audit_logs REORGANIZE PARTITION p_max INTO (
        PARTITION {$name} VALUES LESS THAN (TO_DAYS('{$boundary}')),
        PARTITION p_max   VALUES LESS THAN MAXVALUE
    )");

    return self::SUCCESS;
}

$schedule->command('audit:rotate-partitions')->monthlyOn(1, '02:00');

class AuditedObserver
{
    public function updated(Model $model): void
    {
        if (! $model->isDirty()) return;

        AuditLog::dispatch(
            actorId:    auth()->id(),
            actorType:  auth()->user() ? 'user' : 'system',
            entityId:   $model->getKey(),
            entityType: $model->getMorphClass(),
            action:     'updated',
            payload:    $model->getDirty(),
        );
    }
}

class AuditLog implements ShouldQueue
{
    public function handle(): void
    {
        DB::table('audit_logs')->insert([
            'occurred_at' => now()->format('Y-m-d H:i:s.u'),
            'actor_id'    => $this->actorId,
            'actor_type'  => $this->actorType,
            'entity_id'   => $this->entityId,
            'entity_type' => $this->entityType,
            'action'      => $this->action,
            'payload'     => json_encode($this->payload),
        ]);
    }
}

// تاريخ الكيان
AuditLog::query()
    ->where('entity_type', 'invoice')
    ->where('entity_id', $invoiceId)
    ->orderByDesc('occurred_at')
    ->limit(50)
    ->get();

// نشاط الفاعل
AuditLog::query()
    ->where('actor_type', 'user')
    ->where('actor_id', $userId)
    ->orderByDesc('occurred_at')
    ->limit(50)
    ->get();