ormlinkset.class.inc.php 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563
  1. <?php
  2. // Copyright (C) 2010-2017 Combodo SARL
  3. //
  4. // This file is part of iTop.
  5. //
  6. // iTop is free software; you can redistribute it and/or modify
  7. // it under the terms of the GNU Affero General Public License as published by
  8. // the Free Software Foundation, either version 3 of the License, or
  9. // (at your option) any later version.
  10. //
  11. // iTop is distributed in the hope that it will be useful,
  12. // but WITHOUT ANY WARRANTY; without even the implied warranty of
  13. // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  14. // GNU Affero General Public License for more details.
  15. //
  16. // You should have received a copy of the GNU Affero General Public License
  17. // along with iTop. If not, see <http://www.gnu.org/licenses/>
  18. require_once('dbobjectiterator.php');
  19. /**
  20. * The value for an attribute representing a set of links between the host object and "remote" objects
  21. *
  22. * @package iTopORM
  23. * @copyright Copyright (C) 2010-2017 Combodo SARL
  24. * @license http://opensource.org/licenses/AGPL-3.0
  25. */
  26. class ormLinkSet implements iDBObjectSetIterator, Iterator, SeekableIterator
  27. {
  28. protected $sHostClass; // subclass of DBObject
  29. protected $sAttCode; // xxxxxx_list
  30. protected $sClass; // class of the links
  31. /**
  32. * @var DBObjectSet
  33. */
  34. protected $oOriginalSet;
  35. /**
  36. * @var DBObject[] array of iObjectId => DBObject
  37. */
  38. protected $aOriginalObjects = null;
  39. /**
  40. * @var bool
  41. */
  42. protected $bHasDelta = false;
  43. /**
  44. * Object from the original set, minus the removed objects
  45. * @var DBObject[] array of iObjectId => DBObject
  46. */
  47. protected $aPreserved;
  48. /**
  49. * @var DBObject[] New items
  50. */
  51. protected $aAdded = array();
  52. /**
  53. * @var DBObject[] Modified items (could also be found in aPreserved)
  54. */
  55. protected $aModified = array();
  56. /**
  57. * @var int[] Removed items
  58. */
  59. protected $aRemoved = array();
  60. /**
  61. * @var int Position in the collection
  62. */
  63. protected $iCursor = 0;
  64. /**
  65. * ormLinkSet constructor.
  66. * @param $sHostClass
  67. * @param $sAttCode
  68. * @param DBObjectSet|null $oOriginalSet
  69. * @throws Exception
  70. */
  71. public function __construct($sHostClass, $sAttCode, DBObjectSet $oOriginalSet = null)
  72. {
  73. $this->sHostClass = $sHostClass;
  74. $this->sAttCode = $sAttCode;
  75. $this->oOriginalSet = $oOriginalSet ? clone $oOriginalSet : null;
  76. $oAttDef = MetaModel::GetAttributeDef($sHostClass, $sAttCode);
  77. if (!$oAttDef instanceof AttributeLinkedSet)
  78. {
  79. throw new Exception("ormLinkSet: $sAttCode is not a link set");
  80. }
  81. $this->sClass = $oAttDef->GetLinkedClass();
  82. if ($oOriginalSet && ($oOriginalSet->GetClass() != $this->sClass))
  83. {
  84. throw new Exception("ormLinkSet: wrong class for the original set, found {$oOriginalSet->GetClass()} while expecting {$oAttDef->GetLinkedClass()}");
  85. }
  86. }
  87. public function GetFilter()
  88. {
  89. return clone $this->oOriginalSet->GetFilter();
  90. }
  91. /**
  92. * Specify the subset of attributes to load (for each class of objects) before performing the SQL query for retrieving the rows from the DB
  93. *
  94. * @param hash $aAttToLoad Format: alias => array of attribute_codes
  95. *
  96. * @return void
  97. */
  98. public function OptimizeColumnLoad($aAttToLoad)
  99. {
  100. $this->oOriginalSet->OptimizeColumnLoad($aAttToLoad);
  101. }
  102. /**
  103. * @param DBObject $oLink
  104. */
  105. public function AddItem(DBObject $oLink)
  106. {
  107. assert($oLink instanceof $this->sClass);
  108. // No impact on the iteration algorithm
  109. $this->aAdded[] = $oLink;
  110. $this->bHasDelta = true;
  111. }
  112. /**
  113. * @param $iObjectId
  114. */
  115. public function RemoveItem($iObjectId)
  116. {
  117. if (array_key_exists($iObjectId, $this->aPreserved))
  118. {
  119. unset($this->aPreserved[$iObjectId]);
  120. $this->aRemoved[$iObjectId] = $iObjectId;
  121. $this->bHasDelta = true;
  122. }
  123. }
  124. /**
  125. * @param DBObject $oLink
  126. */
  127. public function ModifyItem(DBObject $oLink)
  128. {
  129. assert($oLink instanceof $this->sClass);
  130. $iObjectId = $oLink->GetKey();
  131. $this->aModified[$iObjectId] = $oLink;
  132. $this->bHasDelta = true;
  133. }
  134. protected function LoadOriginalIds()
  135. {
  136. if ($this->aOriginalObjects === null)
  137. {
  138. if ($this->oOriginalSet)
  139. {
  140. $this->aOriginalObjects = $this->oOriginalSet->ToArray();
  141. $this->aPreserved = $this->aOriginalObjects; // Copy (not effective until aPreserved gets modified)
  142. foreach ($this->aRemoved as $iObjectId)
  143. {
  144. if (array_key_exists($iObjectId, $this->aPreserved))
  145. {
  146. unset($this->aPreserved[$iObjectId]);
  147. }
  148. }
  149. }
  150. else
  151. {
  152. // Nothing to load
  153. $this->aOriginalObjects = [];
  154. $this->aPreserved = [];
  155. }
  156. }
  157. }
  158. /**
  159. * The class of the objects of the collection (at least a common ancestor)
  160. *
  161. * @return string
  162. */
  163. public function GetClass()
  164. {
  165. return $this->sClass;
  166. }
  167. /**
  168. * The total number of objects in the collection
  169. *
  170. * @return int
  171. */
  172. public function Count()
  173. {
  174. $this->LoadOriginalIds();
  175. $iRet = count($this->aPreserved) + count($this->aAdded);
  176. return $iRet;
  177. }
  178. /**
  179. * Position the cursor to the given 0-based position
  180. *
  181. * @param $iPosition
  182. * @throws Exception
  183. * @internal param int $iRow
  184. */
  185. public function Seek($iPosition)
  186. {
  187. $this->LoadOriginalIds();
  188. $iCount = $this->Count();
  189. if ($iPosition >= $iCount)
  190. {
  191. throw new Exception("Invalid position $iPosition: the link set is made of $iCount items.");
  192. }
  193. $this->rewind();
  194. for($iPos = 0 ; $iPos < $iPosition ; $iPos++)
  195. {
  196. $this->next();
  197. }
  198. }
  199. /**
  200. * Fetch the object at the current position in the collection and move the cursor to the next position.
  201. *
  202. * @return DBObject|null The fetched object or null when at the end
  203. */
  204. public function Fetch()
  205. {
  206. $this->LoadOriginalIds();
  207. $ret = $this->current();
  208. if ($ret === false)
  209. {
  210. $ret = null;
  211. }
  212. $this->next();
  213. return $ret;
  214. }
  215. /**
  216. * Return the current element
  217. * @link http://php.net/manual/en/iterator.current.php
  218. * @return mixed Can return any type.
  219. */
  220. public function current()
  221. {
  222. $this->LoadOriginalIds();
  223. $iPreservedCount = count($this->aPreserved);
  224. if ($this->iCursor < $iPreservedCount)
  225. {
  226. $oRet = current($this->aPreserved);
  227. }
  228. else
  229. {
  230. $oRet = current($this->aAdded);
  231. }
  232. return $oRet;
  233. }
  234. /**
  235. * Move forward to next element
  236. * @link http://php.net/manual/en/iterator.next.php
  237. * @return void Any returned value is ignored.
  238. */
  239. public function next()
  240. {
  241. $this->LoadOriginalIds();
  242. $iPreservedCount = count($this->aPreserved);
  243. if ($this->iCursor < $iPreservedCount)
  244. {
  245. next($this->aPreserved);
  246. }
  247. else
  248. {
  249. next($this->aAdded);
  250. }
  251. // Increment AFTER moving the internal cursors because when starting aAdded, we must leave it intact
  252. $this->iCursor++;
  253. }
  254. /**
  255. * Return the key of the current element
  256. * @link http://php.net/manual/en/iterator.key.php
  257. * @return mixed scalar on success, or null on failure.
  258. */
  259. public function key()
  260. {
  261. return $this->iCursor;
  262. }
  263. /**
  264. * Checks if current position is valid
  265. * @link http://php.net/manual/en/iterator.valid.php
  266. * @return boolean The return value will be casted to boolean and then evaluated.
  267. * Returns true on success or false on failure.
  268. */
  269. public function valid()
  270. {
  271. $this->LoadOriginalIds();
  272. $iCount = $this->Count();
  273. $bRet = ($this->iCursor < $iCount);
  274. return $bRet;
  275. }
  276. /**
  277. * Rewind the Iterator to the first element
  278. * @link http://php.net/manual/en/iterator.rewind.php
  279. * @return void Any returned value is ignored.
  280. */
  281. public function rewind()
  282. {
  283. $this->LoadOriginalIds();
  284. $this->iCursor = 0;
  285. reset($this->aPreserved);
  286. reset($this->aAdded);
  287. }
  288. public function HasDelta()
  289. {
  290. return $this->bHasDelta;
  291. }
  292. /**
  293. * This method has been designed specifically for AttributeLinkedSet:Equals and as such it assumes that the passed argument is a clone of this.
  294. * @param ormLinkSet $oFellow
  295. * @return bool|null
  296. * @throws Exception
  297. */
  298. public function Equals(ormLinkSet $oFellow)
  299. {
  300. $bRet = null;
  301. if ($this === $oFellow)
  302. {
  303. $bRet = true;
  304. }
  305. else
  306. {
  307. if ( ($this->oOriginalSet !== $oFellow->oOriginalSet)
  308. && ($this->oOriginalSet->GetFilter()->ToOQL() != $oFellow->oOriginalSet->GetFilter()->ToOQL()) )
  309. {
  310. throw new Exception('ormLinkSet::Equals assumes that compared link sets have the same original scope');
  311. }
  312. if ($this->HasDelta())
  313. {
  314. throw new Exception('ormLinkSet::Equals assumes that left link set had no delta');
  315. }
  316. $bRet = !$oFellow->HasDelta();
  317. }
  318. return $bRet;
  319. }
  320. public function UpdateFromCompleteList(iDBObjectSetIterator $oFellow)
  321. {
  322. if ($oFellow === $this)
  323. {
  324. throw new Exception('ormLinkSet::UpdateFromCompleteList assumes that the passed link set is at least a clone of the current one');
  325. }
  326. $bUpdateFromDelta = false;
  327. if ($oFellow instanceof ormLinkSet)
  328. {
  329. if ( ($this->oOriginalSet === $oFellow->oOriginalSet)
  330. || ($this->oOriginalSet->GetFilter()->ToOQL() == $oFellow->oOriginalSet->GetFilter()->ToOQL()) )
  331. {
  332. $bUpdateFromDelta = true;
  333. }
  334. }
  335. if ($bUpdateFromDelta)
  336. {
  337. // Same original set -> simply update the delta
  338. $this->iCursor = 0;
  339. $this->aAdded = $oFellow->aAdded;
  340. $this->aRemoved = $oFellow->aRemoved;
  341. $this->aModified = $oFellow->aModified;
  342. $this->aPreserved = $oFellow->aPreserved;
  343. $this->bHasDelta = $oFellow->bHasDelta;
  344. }
  345. else
  346. {
  347. // For backward compatibility reasons, let's rebuild a delta...
  348. // Reset the delta
  349. $this->iCursor = 0;
  350. $this->aAdded = array();
  351. $this->aRemoved = array();
  352. $this->aModified = array();
  353. $this->aPreserved = $this->aOriginalObjects;
  354. $this->bHasDelta = false;
  355. /** @var AttributeLinkedSet $oAttDef */
  356. $oAttDef = MetaModel::GetAttributeDef($this->sHostClass, $this->sAttCode);
  357. $sExtKeyToMe = $oAttDef->GetExtKeyToMe();
  358. $sAdditionalKey = null;
  359. if ($oAttDef->IsIndirect() && !$oAttDef->DuplicatesAllowed())
  360. {
  361. $sAdditionalKey = $oAttDef->GetExtKeyToRemote();
  362. }
  363. // Compare both collections by iterating the whole sets, order them, a build a fingerprint based on meaningful data (what make the difference)
  364. $oComparator = new DBObjectSetComparator($this, $oFellow, array($sExtKeyToMe), $sAdditionalKey);
  365. $aChanges = $oComparator->GetDifferences();
  366. foreach ($aChanges['added'] as $oLink)
  367. {
  368. $this->AddItem($oLink);
  369. }
  370. foreach ($aChanges['modified'] as $oLink)
  371. {
  372. $this->ModifyItem($oLink);
  373. }
  374. foreach ($aChanges['removed'] as $oLink)
  375. {
  376. $this->RemoveItem($oLink->GetKey());
  377. }
  378. }
  379. }
  380. /**
  381. * @param DBObject $oHostObject
  382. */
  383. public function DBWrite(DBObject $oHostObject)
  384. {
  385. /** @var AttributeLinkedSet $oAttDef */
  386. $oAttDef = MetaModel::GetAttributeDef(get_class($oHostObject), $this->sAttCode);
  387. $sExtKeyToMe = $oAttDef->GetExtKeyToMe();
  388. $sExtKeyToRemote = $oAttDef->IsIndirect() ? $oAttDef->GetExtKeyToRemote() : 'n/a';
  389. $aCheckLinks = array();
  390. $aCheckRemote = array();
  391. foreach ($this->aAdded as $oLink)
  392. {
  393. if ($oLink->IsNew())
  394. {
  395. if ($oAttDef->IsIndirect() && !$oAttDef->DuplicatesAllowed())
  396. {
  397. //todo: faire un test qui passe dans cette branche !
  398. $aCheckRemote[] = $oLink->Get($sExtKeyToRemote);
  399. }
  400. }
  401. else
  402. {
  403. //todo: faire un test qui passe dans cette branche !
  404. $aCheckLinks[] = $oLink->GetKey();
  405. }
  406. }
  407. foreach ($this->aRemoved as $iLinkId)
  408. {
  409. $aCheckLinks[] = $iLinkId;
  410. }
  411. foreach ($this->aModified as $iLinkId => $oLink)
  412. {
  413. $aCheckLinks[] = $oLink->GetKey();
  414. }
  415. // Critical section : serialize any write access to these links
  416. //
  417. $oMtx = new iTopMutex('Write-'.$this->sClass);
  418. $oMtx->Lock();
  419. // Check for the existing links
  420. //
  421. if (count($aCheckLinks) > 0)
  422. {
  423. $oSearch = new DBObjectSearch($this->sClass);
  424. $oSearch->AddCondition('id', $aCheckLinks, 'IN');
  425. $oSet = new DBObjectSet($oSearch);
  426. /** @var DBObject[] $aExistingLinks */
  427. $aExistingLinks = $oSet->ToArray();
  428. }
  429. // Check for the existing remote objects
  430. //
  431. if (count($aCheckRemote) > 0)
  432. {
  433. $oSearch = new DBObjectSearch($this->sClass);
  434. $oSearch->AddCondition($sExtKeyToMe, $oHostObject->GetKey(), '=');
  435. $oSearch->AddCondition($sExtKeyToRemote, $aCheckRemote, 'IN');
  436. $oSet = new DBObjectSet($oSearch);
  437. /** @var Int[] $aExistingRemote */
  438. $aExistingRemote = $oSet->GetColumnAsArray($sExtKeyToRemote);
  439. }
  440. // Write the links according to the existing links
  441. //
  442. foreach ($this->aAdded as $oLink)
  443. {
  444. // Make sure that the objects in the set point to "this"
  445. $oLink->Set($sExtKeyToMe, $oHostObject->GetKey());
  446. if ($oLink->IsNew())
  447. {
  448. if (count($aCheckRemote) > 0)
  449. {
  450. if (in_array($oLink->Get($sExtKeyToRemote), $aExistingRemote))
  451. {
  452. // Do not create a duplicate
  453. continue;
  454. }
  455. }
  456. }
  457. else
  458. {
  459. if (!array_key_exists($oLink->GetKey(), $aExistingLinks))
  460. {
  461. $oLink->DBClone();
  462. }
  463. }
  464. $oLink->DBWrite();
  465. }
  466. foreach ($this->aRemoved as $iLinkId)
  467. {
  468. if (array_key_exists($iLinkId, $aExistingLinks))
  469. {
  470. $oLink = $aExistingLinks[$iLinkId];
  471. if ($oAttDef->IsIndirect())
  472. {
  473. $oLink->DBDelete();
  474. }
  475. else
  476. {
  477. $oExtKeyToRemote = MetaModel::GetAttributeDef($this->sClass, $sExtKeyToMe);
  478. if ($oExtKeyToRemote->IsNullAllowed())
  479. {
  480. if ($oLink->Get($sExtKeyToMe) == $oHostObject->GetKey())
  481. {
  482. // Detach the link object from this
  483. $oLink->Set($sExtKeyToMe, 0);
  484. $oLink->DBUpdate();
  485. }
  486. }
  487. else
  488. {
  489. $oLink->DBDelete();
  490. }
  491. }
  492. }
  493. }
  494. // Note: process modifications at the end: if a link to remove has also been listed as modified, then it will be gracefully ignored
  495. foreach ($this->aModified as $iLinkId => $oLink)
  496. {
  497. if (array_key_exists($oLink->GetKey(), $aExistingLinks))
  498. {
  499. $oLink->DBUpdate();
  500. }
  501. else
  502. {
  503. $oLink->DBClone();
  504. }
  505. }
  506. // End of the critical section
  507. //
  508. $oMtx->Unlock();
  509. }
  510. }