-
-
Save matteosavio/dfb7ddb9c0625a3f2b418babc4cc479f to your computer and use it in GitHub Desktop.
Revisions
-
matteosavio revised this gist
Dec 26, 2018 . 6 changed files with 37 additions and 54 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,19 +1,17 @@ <?php namespace App\Repository\Filters; use Doctrine\ORM\Mapping\ClassMetaData; use Doctrine\ORM\Query\Filter\SQLFilter; class DeletedFilter extends SQLFilter { public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias) { if ($targetEntity->hasField("deletedOn")) { $date = date("Y-m-d h:m:s"); return $targetTableAlias." . deleted_on < '" . $date . "' OR " . $targetTableAlias.".deleted_on IS NULL"; } return ""; } } This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,21 +1,19 @@ <?php namespace App\EventListener; use Doctrine\ORM\Event\PreFlushEventArgs; class DoctrineListener { public function preFlush(PreFlushEventArgs $event) { $em = $event->getEntityManager(); foreach ($em->getUnitOfWork()->getScheduledEntityDeletions() as $object) { if (method_exists($object, "getDeletedOn")) { if ($object->getDeletedOn() instanceof \Datetime) { continue; } else { $object->setDeletedOn(new \DateTime()); $em->merge($object); $em->persist($object); } } This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,37 +1,25 @@ <?php namespace App\Entity; use Doctrine\ORM\Mapping as ORM; class Base { /** * @ORM\Column(type="datetime", nullable=true) */ private $deletedOn; public function getDeletedOn(): ?\DateTimeInterface { return $this->deletedOn; } public function setDeletedOn(?\DateTimeInterface $deletedOn): self { $this->deletedOn = $deletedOn; return $this; } } This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,7 +1,8 @@ # config/packages/doctrine.yaml doctrine: orm: filters: deleted: class: 'App\Repository\Filters\DeletedFilter' enabled: true
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,5 @@ # config/services.yml App\EventListener\DoctrineListener: public: false tags: - { name: doctrine.event_listener, event: preFlush, method: preFlush } This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,7 +0,0 @@ -
baptistedonaux created this gist
Feb 19, 2015 .There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,19 @@ <?php namespace Namespace\MyBundle\Repository\Filters; use Doctrine\ORM\Mapping\ClassMetaData; use Doctrine\ORM\Query\Filter\SQLFilter; class DeletedFilter extends SQLFilter { public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias) { if ($targetEntity->hasField("deletedAt")) { $date = date("Y-m-d h:m:s"); return $targetTableAlias.".deletedAt < '".$date."' OR ".$targetTableAlias.".deletedAt IS NULL"; } return ""; } } This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,24 @@ <?php namespace Namespace\MyBundle\Listener; use Doctrine\ORM\Event\PreFlushEventArgs; class DoctrineListener { public function preFlush(PreFlushEventArgs $event) { $em = $event->getEntityManager(); foreach ($em->getUnitOfWork()->getScheduledEntityDeletions() as $object) { if (method_exists($object, "getDeletedAt")) { if ($object->getDeletedAt() instanceof \Datetime) { continue; } else { $object->setDeletedAt(new \DateTime()); $em->merge($object); $em->persist($object); } } } } } This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,37 @@ <?php namespace Namespace\MyBundle\Entity; use Doctrine\ORM\Mapping as ORM; class Entity { /** * @var datetime $deletedAt * * @ORM\Column(name="deletedAt", type="datetime", nullable=true) */ private $deletedAt; /** * Set deletedAt * * @param \DateTime $deletedAt * @return Plan */ public function setDeletedAt($deletedAt) { $this->deletedAt = $deletedAt; return $this; } /** * Get deletedAt * * @return \DateTime */ public function getDeletedAt() { return $this->deletedAt; } } This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,7 @@ # app/config/config.yml doctrine: orm: filters: deleted: class: 'Namespace\MyBundle\Repository\Filters\DeletedFilter' enabled: true This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,7 @@ # src/namespace/mybundle/Resources/config/services.yml services: kernel.listener.doctrine: class: Namespace\MyBundle\Listener\DoctrineListener public: false tags: - { name: doctrine.event_listener, event: preFlush, method: preFlush }