Doctrine Manager 嘗試更新使用者實體,而無需我進行任何修改
P粉308783585
P粉308783585 2024-04-03 14:04:06
0
1
468

我有一個控制器方法,我正在為我的實體Order 建立一個插入方法,它與User 實體有關係,一個使用者可以有多個訂單,現在當我創建訂單並將用戶設置為它,當我沒有對其進行修改時,學說會嘗試更新用戶,我想知道我做錯了什麼 我的控制器方法

#[Route('/new', name: 'new', methods: ['POST'])]
    public function order(
        Request $request,
        ServiceRepository $serviceRepository,
        EntityManagerInterface $manager
    ): JsonResponse
    {
        $data = json_decode(json: $request->getContent());

        //get service
        if (!property_exists($data, 'service'))
            return $this->json(['status' => false, 'message' => 'service is required']);
        $service = $serviceRepository->find($data->service);

        $order = new Order();

        $order->setUser($this->getUser());
                $order->setCreatedAt(new \DateTimeImmutable());
        $order->setTotal(0);
        $order->setStatus(Order::STATUS_OPEN);
        $order->setService($service);

        $manager->persist($order);
        $manager->flush();

        return $this->json(['status' => true]);
    }

我的使用者實體

<?php

namespace App\Entity;

use App\Repository\UserRepository;
use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\Common\Collections\Collection;
use Doctrine\ORM\Mapping as ORM;
use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;
use Symfony\Component\Security\Core\User\PasswordAuthenticatedUserInterface;
use Symfony\Component\Security\Core\User\UserInterface;
use Symfony\Component\Validator\Constraints as Assert;

#[ORM\Entity(repositoryClass: UserRepository::class)]
#[UniqueEntity('email', message: 'This Email Is Taken')]
#[ORM\Table(name: '`user`')]
class User implements UserInterface, PasswordAuthenticatedUserInterface
{
    #[ORM\Id]
    #[ORM\GeneratedValue]
    #[ORM\Column]
    private ?int $id = null;

    #[ORM\Column(length: 180, unique: true)]
    #[Assert\NotBlank, Assert\Email]
    private ?string $email = null;

    #[ORM\Column]
    private array $roles = [];

    /**
     * @var ?string The hashed password
     */
    #[ORM\Column]
    #[Assert\NotBlank]
    private ?string $password = null;

    #[ORM\Column(length: 255)]
    #[Assert\NotBlank]
    private ?string $name = null;

    #[ORM\Column(length: 255, nullable: true)]
    private ?string $password_token = null;

    #[ORM\Column(nullable: true)]
    private ?\DateTimeImmutable $password_time = null;


    #[ORM\Column]
    private ?\DateTimeImmutable $created_at = null;

    #[ORM\Column(nullable: true)]
    private ?\DateTimeImmutable $updated_at = null;

    #[ORM\OneToMany(mappedBy: 'user', targetEntity: Order::class, orphanRemoval: true)]
    private Collection $total;

    public function __construct()
    {
        $this->total = new ArrayCollection();
    }

    public function getId(): ?int
    {
        return $this->id;
    }

    public function getEmail(): ?string
    {
        return $this->email;
    }

    public function setEmail(string $email): self
    {
        $this->email = $email;

        return $this;
    }

    /**
     * A visual identifier that represents this user.
     *
     * @see UserInterface
     */
    public function getUserIdentifier(): string
    {
        return (string) $this->email;
    }

    /**
     * @deprecated since Symfony 5.3, use getUserIdentifier instead
     */
    public function getUsername(): string
    {
        return (string) $this->email;
    }

    /**
     * @see UserInterface
     */
    public function getRoles(): array
    {
        $roles = $this->roles;
        // guarantee every user at least has ROLE_USER
        $roles[] = 'ROLE_USER';

        return array_unique($roles);
    }

    public function setRoles(array $roles): self
    {
        $this->roles = $roles;

        return $this;
    }

    /**
     * @see PasswordAuthenticatedUserInterface
     */
    public function getPassword(): ?string
    {
        return $this->password;
    }

    public function setPassword(string $password): self
    {
        $this->password = $password;

        return $this;
    }

    /**
     * Returning a salt is only needed, if you are not using a modern
     * hashing algorithm (e.g. bcrypt or sodium) in your security.yaml.
     *
     * @see UserInterface
     */
    public function getSalt(): ?string
    {
        return null;
    }

    /**
     * @see UserInterface
     */
    public function eraseCredentials()
    {
        unset($this->password, $this->roles, $this->access_token, $this->refresh_token, $this->updated_at);
    }

    public function getName(): ?string
    {
        return $this->name;
    }

    public function setName(string $name): self
    {
        $this->name = $name;

        return $this;
    }

    public function getCreatedAt(): ?\DateTimeImmutable
    {
        return $this->created_at;
    }

    public function setCreatedAt(\DateTimeImmutable $created_at): self
    {
        $this->created_at = $created_at;

        return $this;
    }

    public function getUpdatedAt(): ?\DateTimeImmutable
    {
        return $this->updated_at;
    }

    public function setUpdatedAt(?\DateTimeImmutable $updated_at): self
    {
        $this->updated_at = $updated_at;

        return $this;
    }

   /**
    * @return string|null
    */
   public function getPasswordToken(): ?string
   {
       return $this->password_token;
   }

   /**
    * @param string|null $password_token
    */
   public function setPasswordToken(?string $password_token): void
   {
       $this->password_token = $password_token;
   }

   /**
    * @return \DateTimeImmutable|null
    */
   public function getPasswordTime(): ?\DateTimeImmutable
   {
       return $this->password_time;
   }

   /**
    * @param \DateTimeImmutable|null $password_time
    */
   public function setPasswordTime(?\DateTimeImmutable $password_time): void
   {
       $this->password_time = $password_time;
   }

    /**
     * @return Collection<int, Order>
     */
    public function getTotal(): Collection
    {
        return $this->total;
    }

    public function addTotal(Order $total): self
    {
        if (!$this->total->contains($total)) {
            $this->total->add($total);
            $total->setUser($this);
        }

        return $this;
    }

    public function removeTotal(Order $total): self
    {
        if ($this->total->removeElement($total)) {
            // set the owning side to null (unless already changed)
            if ($total->getUser() === $this) {
                $total->setUser(null);
            }
        }

        return $this;
    }
}

和我的訂單實體

<?php

namespace App\Entity;

use App\Repository\OrderRepository;
use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\Common\Collections\Collection;
use Doctrine\ORM\Mapping as ORM;

#[ORM\Entity(repositoryClass: OrderRepository::class)]
#[ORM\Table(name: '`order`')]
class Order
{
   public const STATUS_OPEN = 'open';
   public const STATUS_AWAITING_PAYMENT  = 'awaiting_payment';
   public const STATUS_PAYMENT_VALIDATED = 'payment_validated';
   public const STATUS_PAYMENT_CANCELLED = 'payment_cancelled';
   public const STATUS_COMPLETED = 'completed';

    #[ORM\Id]
    #[ORM\GeneratedValue]
    #[ORM\Column]
    private ?int $id = null;

    #[ORM\ManyToOne(inversedBy: 'total')]
    #[ORM\JoinColumn(nullable: false)]
    private ?User $user = null;

    #[ORM\Column]
    private ?float $total = null;

    #[ORM\Column(length: 255)]
    private ?string $status = null;

    #[ORM\Column]
    private ?\DateTimeImmutable $created_at = null;

    #[ORM\Column(nullable: true)]
    private ?\DateTimeImmutable $updated_at = null;

    #[ORM\OneToMany(mappedBy: 'parent', targetEntity: OrderItem::class, orphanRemoval: true)]
    private Collection $activity;

    #[ORM\ManyToOne(inversedBy: 'orders')]
    #[ORM\JoinColumn(nullable: false)]
    private ?Service $service = null;

    public function __construct()
    {
        $this->activity = new ArrayCollection();
    }

    public function getId(): ?int
    {
        return $this->id;
    }

    public function getUser(): ?User
    {
        return $this->user;
    }

    public function setUser(?User $user): self
    {
        $this->user = $user;

        return $this;
    }

    public function getTotal(): ?float
    {
        return $this->total;
    }

    public function setTotal(float $total): self
    {
        $this->total = $total;

        return $this;
    }

    public function getStatus(): ?string
    {
        return $this->status;
    }

    public function setStatus(string $status): self
    {
        $this->status = $status;

        return $this;
    }

    public function getCreatedAt(): ?\DateTimeImmutable
    {
        return $this->created_at;
    }

    public function setCreatedAt(\DateTimeImmutable $created_at): self
    {
        $this->created_at = $created_at;

        return $this;
    }

    public function getUpdatedAt(): ?\DateTimeImmutable
    {
        return $this->updated_at;
    }

    public function setUpdatedAt(?\DateTimeImmutable $updated_at): self
    {
        $this->updated_at = $updated_at;

        return $this;
    }

    /**
     * @return Collection<int, OrderItem>
     */
    public function getActivity(): Collection
    {
        return $this->activity;
    }

    public function addActivity(OrderItem $activity): self
    {
        if (!$this->activity->contains($activity)) {
            $this->activity->add($activity);
            $activity->setParent($this);
        }

        return $this;
    }

    public function removeActivity(OrderItem $activity): self
    {
        if ($this->activity->removeElement($activity)) {
            // set the owning side to null (unless already changed)
            if ($activity->getParent() === $this) {
                $activity->setParent(null);
            }
        }

        return $this;
    }

    public function getService(): ?Service
    {
        return $this->service;
    }

    public function setService(?Service $service): self
    {
        $this->service = $service;

        return $this;
    }
}

所以我嘗試保存訂單,之後我使用訂單id 保存訂單項目是上面保存的訂單,但它失敗並給我contstrain 錯誤執行查詢時發生異常: SQLSTATE[23000]: 完整性約束違規: 1048 列「角色」不能為空白 調試後發現,這裡的doctrine是想更新我的用戶,但是我對用戶做了0修改,那為什麼還要更新呢?

P粉308783585
P粉308783585

全部回覆(1)
P粉546138344

所以,夥計們,我在找到答案後忘記回答這個問題,正如您在我的用戶實體中看到的那樣,我有擦除Credentials方法

/**
     * @see UserInterface
     */
    public function eraseCredentials()
    {
        unset($this->password, $this->roles, $this->access_token, $this->refresh_token, $this->updated_at);
    }

我有一個誤解,我在 API 請求中返回用戶之前調用此方法,但它也在刷新之前被調用,所以要小心

熱門教學
更多>
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板
關於我們 免責聲明 Sitemap
PHP中文網:公益線上PHP培訓,幫助PHP學習者快速成長!