Nested.php 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540
  1. <?php
  2. namespace Gedmo\Tree\Strategy\ORM;
  3. use Gedmo\Tool\Wrapper\EntityWrapper;
  4. use Gedmo\Tool\Wrapper\AbstractWrapper;
  5. use Gedmo\Tree\Strategy,
  6. Doctrine\ORM\EntityManager,
  7. Gedmo\Tree\TreeListener,
  8. Doctrine\ORM\Mapping\ClassMetadataInfo,
  9. Doctrine\ORM\Query;
  10. /**
  11. * This strategy makes tree act like
  12. * nested set.
  13. *
  14. * This behavior can inpact the performance of your application
  15. * since nested set trees are slow on inserts and updates.
  16. *
  17. * @author Gediminas Morkevicius <gediminas.morkevicius@gmail.com>
  18. * @package Gedmo.Tree.Strategy.ORM
  19. * @subpackage Nested
  20. * @link http://www.gediminasm.org
  21. * @license MIT License (http://www.opensource.org/licenses/mit-license.php)
  22. */
  23. class Nested implements Strategy
  24. {
  25. /**
  26. * Previous sibling position
  27. */
  28. const PREV_SIBLING = 'PrevSibling';
  29. /**
  30. * Next sibling position
  31. */
  32. const NEXT_SIBLING = 'NextSibling';
  33. /**
  34. * Last child position
  35. */
  36. const LAST_CHILD = 'LastChild';
  37. /**
  38. * First child position
  39. */
  40. const FIRST_CHILD = 'FirstChild';
  41. /**
  42. * TreeListener
  43. *
  44. * @var AbstractTreeListener
  45. */
  46. protected $listener = null;
  47. /**
  48. * The max number of "right" field of the
  49. * tree in case few root nodes will be persisted
  50. * on one flush for node classes
  51. *
  52. * @var array
  53. */
  54. private $treeEdges = array();
  55. /**
  56. * Stores a list of node position strategies
  57. * for each node by object hash
  58. *
  59. * @var array
  60. */
  61. private $nodePositions = array();
  62. /**
  63. * {@inheritdoc}
  64. */
  65. public function __construct(TreeListener $listener)
  66. {
  67. $this->listener = $listener;
  68. }
  69. /**
  70. * {@inheritdoc}
  71. */
  72. public function getName()
  73. {
  74. return Strategy::NESTED;
  75. }
  76. /**
  77. * Set node position strategy
  78. *
  79. * @param string $oid
  80. * @param string $position
  81. */
  82. public function setNodePosition($oid, $position)
  83. {
  84. $valid = array(
  85. self::FIRST_CHILD,
  86. self::LAST_CHILD,
  87. self::NEXT_SIBLING,
  88. self::PREV_SIBLING
  89. );
  90. if (!in_array($position, $valid, false)) {
  91. throw new \Gedmo\Exception\InvalidArgumentException("Position: {$position} is not valid in nested set tree");
  92. }
  93. $this->nodePositions[$oid] = $position;
  94. }
  95. /**
  96. * {@inheritdoc}
  97. */
  98. public function processScheduledInsertion($em, $node)
  99. {
  100. $meta = $em->getClassMetadata(get_class($node));
  101. $config = $this->listener->getConfiguration($em, $meta->name);
  102. $meta->getReflectionProperty($config['left'])->setValue($node, 0);
  103. $meta->getReflectionProperty($config['right'])->setValue($node, 0);
  104. if (isset($config['level'])) {
  105. $meta->getReflectionProperty($config['level'])->setValue($node, 0);
  106. }
  107. if (isset($config['root'])) {
  108. $meta->getReflectionProperty($config['root'])->setValue($node, 0);
  109. }
  110. }
  111. /**
  112. * {@inheritdoc}
  113. */
  114. public function processScheduledUpdate($em, $node)
  115. {
  116. $meta = $em->getClassMetadata(get_class($node));
  117. $config = $this->listener->getConfiguration($em, $meta->name);
  118. $uow = $em->getUnitOfWork();
  119. $changeSet = $uow->getEntityChangeSet($node);
  120. if (isset($config['root']) && isset($changeSet[$config['root']])) {
  121. throw new \Gedmo\Exception\UnexpectedValueException("Root cannot be changed manualy, change parent instead");
  122. }
  123. $oid = spl_object_hash($node);
  124. if (isset($changeSet[$config['left']]) && isset($this->nodePositions[$oid])) {
  125. $wrapped = AbstractWrapper::wrapp($node, $em);
  126. $parent = $wrapped->getPropertyValue($config['parent']);
  127. // revert simulated changeset
  128. $uow->clearEntityChangeSet($oid);
  129. $wrapped->setPropertyValue($config['left'], $changeSet[$config['left']][0]);
  130. $uow->setOriginalEntityProperty($oid, $config['left'], $changeSet[$config['left']][0]);
  131. // set back all other changes
  132. foreach ($changeSet as $field => $set) {
  133. if ($field !== $config['left']) {
  134. $uow->setOriginalEntityProperty($oid, $field, $set[0]);
  135. $wrapped->setPropertyValue($field, $set[1]);
  136. }
  137. }
  138. $uow->recomputeSingleEntityChangeSet($meta, $node);
  139. $this->updateNode($em, $node, $parent);
  140. } elseif (isset($changeSet[$config['parent']])) {
  141. $this->updateNode($em, $node, $changeSet[$config['parent']][1]);
  142. }
  143. }
  144. /**
  145. * {@inheritdoc}
  146. */
  147. public function processPostPersist($em, $node)
  148. {
  149. $meta = $em->getClassMetadata(get_class($node));
  150. $config = $this->listener->getConfiguration($em, $meta->name);
  151. $parent = $meta->getReflectionProperty($config['parent'])->getValue($node);
  152. $this->updateNode($em, $node, $parent, self::LAST_CHILD);
  153. }
  154. /**
  155. * {@inheritdoc}
  156. */
  157. public function processScheduledDelete($em, $node)
  158. {
  159. $meta = $em->getClassMetadata(get_class($node));
  160. $config = $this->listener->getConfiguration($em, $meta->name);
  161. $uow = $em->getUnitOfWork();
  162. $wrapped = AbstractWrapper::wrapp($node, $em);
  163. $leftValue = $wrapped->getPropertyValue($config['left']);
  164. $rightValue = $wrapped->getPropertyValue($config['right']);
  165. if (!$leftValue || !$rightValue) {
  166. return;
  167. }
  168. $rootId = isset($config['root']) ? $wrapped->getPropertyValue($config['root']) : null;
  169. $diff = $rightValue - $leftValue + 1;
  170. if ($diff > 2) {
  171. $dql = "SELECT node FROM {$config['useObjectClass']} node";
  172. $dql .= " WHERE node.{$config['left']} BETWEEN :left AND :right";
  173. if (isset($config['root'])) {
  174. $dql .= " AND node.{$config['root']} = {$rootId}";
  175. }
  176. $q = $em->createQuery($dql);
  177. // get nodes for deletion
  178. $q->setParameter('left', $leftValue + 1);
  179. $q->setParameter('right', $rightValue - 1);
  180. $nodes = $q->getResult();
  181. foreach ((array)$nodes as $removalNode) {
  182. $uow->scheduleForDelete($removalNode);
  183. }
  184. }
  185. $this->shiftRL($em, $config['useObjectClass'], $rightValue + 1, -$diff, $rootId);
  186. }
  187. /**
  188. * {@inheritdoc}
  189. */
  190. public function onFlushEnd($em)
  191. {
  192. // reset values
  193. $this->treeEdges = array();
  194. $this->updatesOnNodeClasses = array();
  195. }
  196. /**
  197. * {@inheritdoc}
  198. */
  199. public function processPreRemove($em, $node)
  200. {}
  201. /**
  202. * {@inheritdoc}
  203. */
  204. public function processPrePersist($em, $node)
  205. {}
  206. /**
  207. * {@inheritdoc}
  208. */
  209. public function processMetadataLoad($em, $meta)
  210. {}
  211. /**
  212. * Update the $node with a diferent $parent
  213. * destination
  214. *
  215. * @param EntityManager $em
  216. * @param object $node - target node
  217. * @param object $parent - destination node
  218. * @param string $position
  219. * @throws Gedmo\Exception\UnexpectedValueException
  220. * @return void
  221. */
  222. public function updateNode(EntityManager $em, $node, $parent, $position = 'FirstChild')
  223. {
  224. $wrapped = AbstractWrapper::wrapp($node, $em);
  225. $meta = $wrapped->getMetadata();
  226. $config = $this->listener->getConfiguration($em, $meta->name);
  227. $rootId = isset($config['root']) ? $wrapped->getPropertyValue($config['root']) : null;
  228. $identifierField = $meta->getSingleIdentifierFieldName();
  229. $nodeId = $wrapped->getIdentifier();
  230. $left = $wrapped->getPropertyValue($config['left']);
  231. $right = $wrapped->getPropertyValue($config['right']);
  232. $isNewNode = empty($left) && empty($right);
  233. if ($isNewNode) {
  234. $left = 1;
  235. $right = 2;
  236. }
  237. $oid = spl_object_hash($node);
  238. if (isset($this->nodePositions[$oid])) {
  239. $position = $this->nodePositions[$oid];
  240. }
  241. $level = 0;
  242. $treeSize = $right - $left + 1;
  243. $newRootId = null;
  244. if ($parent) {
  245. $wrappedParent = AbstractWrapper::wrapp($parent, $em);
  246. $parentRootId = isset($config['root']) ? $wrappedParent->getPropertyValue($config['root']) : null;
  247. $parentLeft = $wrappedParent->getPropertyValue($config['left']);
  248. $parentRight = $wrappedParent->getPropertyValue($config['right']);
  249. if (!$isNewNode && $rootId === $parentRootId && $parentLeft >= $left && $parentRight <= $right) {
  250. throw new \Gedmo\Exception\UnexpectedValueException("Cannot set child as parent to node: {$nodeId}");
  251. }
  252. if (isset($config['level'])) {
  253. $level = $wrappedParent->getPropertyValue($config['level']);
  254. }
  255. switch ($position) {
  256. case self::PREV_SIBLING:
  257. $newParent = $wrappedParent->getPropertyValue($config['parent']);
  258. if (!$isNewNode) {
  259. $wrapped->setPropertyValue($config['parent'], $newParent);
  260. $em->getUnitOfWork()->recomputeSingleEntityChangeSet($meta, $node);
  261. }
  262. $start = $parentLeft;
  263. break;
  264. case self::NEXT_SIBLING:
  265. $newParent = $wrappedParent->getPropertyValue($config['parent']);
  266. if (!$isNewNode) {
  267. $wrapped->setPropertyValue($config['parent'], $newParent);
  268. $em->getUnitOfWork()->recomputeSingleEntityChangeSet($meta, $node);
  269. }
  270. $start = $parentRight + 1;
  271. break;
  272. case self::LAST_CHILD:
  273. $start = $parentRight;
  274. $level++;
  275. break;
  276. case self::FIRST_CHILD:
  277. default:
  278. $start = $parentLeft + 1;
  279. $level++;
  280. break;
  281. }
  282. $this->shiftRL($em, $config['useObjectClass'], $start, $treeSize, $parentRootId);
  283. if (!$isNewNode && $rootId === $parentRootId && $left >= $start) {
  284. $left += $treeSize;
  285. $wrapped->setPropertyValue($config['left'], $left);
  286. }
  287. if (!$isNewNode && $rootId === $parentRootId && $right >= $start) {
  288. $right += $treeSize;
  289. $wrapped->setPropertyValue($config['right'], $right);
  290. }
  291. $newRootId = $parentRootId;
  292. } elseif (!isset($config['root'])) {
  293. $start = isset($this->treeEdges[$meta->name]) ?
  294. $this->treeEdges[$meta->name] : $this->max($em, $config['useObjectClass']);
  295. $this->treeEdges[$meta->name] = $start + 2;
  296. $start++;
  297. } else {
  298. $start = 1;
  299. $newRootId = $nodeId;
  300. }
  301. $diff = $start - $left;
  302. if (!$isNewNode) {
  303. $levelDiff = isset($config['level']) ? $level - $wrapped->getPropertyValue($config['level']) : null;
  304. $this->shiftRangeRL(
  305. $em,
  306. $config['useObjectClass'],
  307. $left,
  308. $right,
  309. $diff,
  310. $rootId,
  311. $newRootId,
  312. $levelDiff
  313. );
  314. $this->shiftRL($em, $config['useObjectClass'], $left, -$treeSize, $rootId);
  315. } else {
  316. $qb = $em->createQueryBuilder();
  317. $qb->update($config['useObjectClass'], 'node');
  318. if (isset($config['root'])) {
  319. $qb->set('node.' . $config['root'], $newRootId);
  320. $wrapped->setPropertyValue($config['root'], $newRootId);
  321. $em->getUnitOfWork()->setOriginalEntityProperty($oid, $config['root'], $newRootId);
  322. }
  323. if (isset($config['level'])) {
  324. $qb->set('node.' . $config['level'], $level);
  325. $wrapped->setPropertyValue($config['level'], $level);
  326. $em->getUnitOfWork()->setOriginalEntityProperty($oid, $config['level'], $level);
  327. }
  328. if (isset($newParent)) {
  329. $wrappedNewParent = AbstractWrapper::wrapp($newParent, $em);
  330. $newParentId = $wrappedNewParent->getIdentifier();
  331. $qb->set('node.' . $config['parent'], $newParentId);
  332. $wrapped->setPropertyValue($config['parent'], $newParent);
  333. $em->getUnitOfWork()->setOriginalEntityProperty($oid, $config['parent'], $newParent);
  334. }
  335. $qb->set('node.' . $config['left'], $left + $diff);
  336. $qb->set('node.' . $config['right'], $right + $diff);
  337. $qb->where("node.{$identifierField} = {$nodeId}");
  338. $qb->getQuery()->getSingleScalarResult();
  339. $wrapped->setPropertyValue($config['left'], $left + $diff);
  340. $wrapped->setPropertyValue($config['right'], $right + $diff);
  341. $em->getUnitOfWork()->setOriginalEntityProperty($oid, $config['left'], $left + $diff);
  342. $em->getUnitOfWork()->setOriginalEntityProperty($oid, $config['right'], $right + $diff);
  343. }
  344. }
  345. /**
  346. * Get the edge of tree
  347. *
  348. * @param EntityManager $em
  349. * @param string $class
  350. * @param integer $rootId
  351. * @return integer
  352. */
  353. public function max(EntityManager $em, $class, $rootId = 0)
  354. {
  355. $meta = $em->getClassMetadata($class);
  356. $config = $this->listener->getConfiguration($em, $meta->name);
  357. $dql = "SELECT MAX(node.{$config['right']}) FROM {$config['useObjectClass']} node";
  358. if (isset($config['root']) && $rootId) {
  359. $dql .= " WHERE node.{$config['root']} = {$rootId}";
  360. }
  361. $query = $em->createQuery($dql);
  362. $right = $query->getSingleScalarResult();
  363. return intval($right);
  364. }
  365. /**
  366. * Shift tree left and right values by delta
  367. *
  368. * @param EntityManager $em
  369. * @param string $class
  370. * @param integer $first
  371. * @param integer $delta
  372. * @param integer $rootId
  373. * @return void
  374. */
  375. public function shiftRL(EntityManager $em, $class, $first, $delta, $rootId = null)
  376. {
  377. $meta = $em->getClassMetadata($class);
  378. $config = $this->listener->getConfiguration($em, $class);
  379. $sign = ($delta >= 0) ? ' + ' : ' - ';
  380. $absDelta = abs($delta);
  381. $dql = "UPDATE {$meta->name} node";
  382. $dql .= " SET node.{$config['left']} = node.{$config['left']} {$sign} {$absDelta}";
  383. $dql .= " WHERE node.{$config['left']} >= {$first}";
  384. if (isset($config['root'])) {
  385. $dql .= " AND node.{$config['root']} = {$rootId}";
  386. }
  387. $q = $em->createQuery($dql);
  388. $q->getSingleScalarResult();
  389. $dql = "UPDATE {$meta->name} node";
  390. $dql .= " SET node.{$config['right']} = node.{$config['right']} {$sign} {$absDelta}";
  391. $dql .= " WHERE node.{$config['right']} >= {$first}";
  392. if (isset($config['root'])) {
  393. $dql .= " AND node.{$config['root']} = {$rootId}";
  394. }
  395. $q = $em->createQuery($dql);
  396. $q->getSingleScalarResult();
  397. // update in memory nodes increases performance, saves some IO
  398. foreach ($em->getUnitOfWork()->getIdentityMap() as $className => $nodes) {
  399. // for inheritance mapped classes, only root is always in the identity map
  400. if ($className !== $meta->rootEntityName) {
  401. continue;
  402. }
  403. foreach ($nodes as $node) {
  404. if ($node instanceof Proxy && !$node->__isInitialized__) {
  405. continue;
  406. }
  407. $oid = spl_object_hash($node);
  408. $left = $meta->getReflectionProperty($config['left'])->getValue($node);
  409. $root = isset($config['root']) ? $meta->getReflectionProperty($config['root'])->getValue($node) : null;
  410. if ($root === $rootId && $left >= $first) {
  411. $meta->getReflectionProperty($config['left'])->setValue($node, $left + $delta);
  412. $em->getUnitOfWork()->setOriginalEntityProperty($oid, $config['left'], $left + $delta);
  413. }
  414. $right = $meta->getReflectionProperty($config['right'])->getValue($node);
  415. if ($root === $rootId && $right >= $first) {
  416. $meta->getReflectionProperty($config['right'])->setValue($node, $right + $delta);
  417. $em->getUnitOfWork()->setOriginalEntityProperty($oid, $config['right'], $right + $delta);
  418. }
  419. }
  420. }
  421. }
  422. /**
  423. * Shift range of right and left values on tree
  424. * depending on tree level diference also
  425. *
  426. * @param EntityManager $em
  427. * @param string $class
  428. * @param integer $first
  429. * @param integer $last
  430. * @param integer $delta
  431. * @param integer $rootId
  432. * @param integer $destRootId
  433. * @param integer $levelDelta
  434. * @return void
  435. */
  436. public function shiftRangeRL(EntityManager $em, $class, $first, $last, $delta, $rootId = null, $destRootId = null, $levelDelta = null)
  437. {
  438. $meta = $em->getClassMetadata($class);
  439. $config = $this->listener->getConfiguration($em, $class);
  440. $sign = ($delta >= 0) ? ' + ' : ' - ';
  441. $absDelta = abs($delta);
  442. $levelSign = ($levelDelta >= 0) ? ' + ' : ' - ';
  443. $absLevelDelta = abs($levelDelta);
  444. $dql = "UPDATE {$meta->name} node";
  445. $dql .= " SET node.{$config['left']} = node.{$config['left']} {$sign} {$absDelta}";
  446. $dql .= ", node.{$config['right']} = node.{$config['right']} {$sign} {$absDelta}";
  447. if (isset($config['root'])) {
  448. $dql .= ", node.{$config['root']} = {$destRootId}";
  449. }
  450. if (isset($config['level'])) {
  451. $dql .= ", node.{$config['level']} = node.{$config['level']} {$levelSign} {$absLevelDelta}";
  452. }
  453. $dql .= " WHERE node.{$config['left']} >= {$first}";
  454. $dql .= " AND node.{$config['right']} <= {$last}";
  455. if (isset($config['root'])) {
  456. $dql .= " AND node.{$config['root']} = {$rootId}";
  457. }
  458. $q = $em->createQuery($dql);
  459. $q->getSingleScalarResult();
  460. // update in memory nodes increases performance, saves some IO
  461. foreach ($em->getUnitOfWork()->getIdentityMap() as $className => $nodes) {
  462. // for inheritance mapped classes, only root is always in the identity map
  463. if ($className !== $meta->rootEntityName) {
  464. continue;
  465. }
  466. foreach ($nodes as $node) {
  467. if ($node instanceof Proxy && !$node->__isInitialized__) {
  468. continue;
  469. }
  470. $left = $meta->getReflectionProperty($config['left'])->getValue($node);
  471. $right = $meta->getReflectionProperty($config['right'])->getValue($node);
  472. $root = isset($config['root']) ? $meta->getReflectionProperty($config['root'])->getValue($node) : null;
  473. if ($root === $rootId && $left >= $first && $right <= $last) {
  474. $oid = spl_object_hash($node);
  475. $uow = $em->getUnitOfWork();
  476. $meta->getReflectionProperty($config['left'])->setValue($node, $left + $delta);
  477. $uow->setOriginalEntityProperty($oid, $config['left'], $left + $delta);
  478. $meta->getReflectionProperty($config['right'])->setValue($node, $right + $delta);
  479. $uow->setOriginalEntityProperty($oid, $config['right'], $right + $delta);
  480. if (isset($config['root'])) {
  481. $meta->getReflectionProperty($config['root'])->setValue($node, $destRootId);
  482. $uow->setOriginalEntityProperty($oid, $config['root'], $destRootId);
  483. }
  484. if (isset($config['level'])) {
  485. $level = $meta->getReflectionProperty($config['level'])->getValue($node);
  486. $meta->getReflectionProperty($config['level'])->setValue($node, $level + $levelDelta);
  487. $uow->setOriginalEntityProperty($oid, $config['level'], $level + $levelDelta);
  488. }
  489. }
  490. }
  491. }
  492. }
  493. }