cmdbobject.class.inc.php 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573
  1. <?php
  2. // Copyright (C) 2010 Combodo SARL
  3. //
  4. // This program is free software; you can redistribute it and/or modify
  5. // it under the terms of the GNU General Public License as published by
  6. // the Free Software Foundation; version 3 of the License.
  7. //
  8. // This program is distributed in the hope that it will be useful,
  9. // but WITHOUT ANY WARRANTY; without even the implied warranty of
  10. // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  11. // GNU General Public License for more details.
  12. //
  13. // You should have received a copy of the GNU General Public License
  14. // along with this program; if not, write to the Free Software
  15. // Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
  16. /**
  17. * Class cmdbObject
  18. *
  19. * @author Erwan Taloc <erwan.taloc@combodo.com>
  20. * @author Romain Quetiez <romain.quetiez@combodo.com>
  21. * @author Denis Flaven <denis.flaven@combodo.com>
  22. * @license http://www.opensource.org/licenses/gpl-3.0.html LGPL
  23. */
  24. /**
  25. * cmdbObjectClass
  26. * the file to include, then the core is yours
  27. *
  28. * @package iTopORM
  29. */
  30. require_once('coreexception.class.inc.php');
  31. require_once('config.class.inc.php');
  32. require_once('log.class.inc.php');
  33. require_once('kpi.class.inc.php');
  34. require_once('dict.class.inc.php');
  35. require_once('attributedef.class.inc.php');
  36. require_once('filterdef.class.inc.php');
  37. require_once('stimulus.class.inc.php');
  38. require_once('valuesetdef.class.inc.php');
  39. require_once('MyHelpers.class.inc.php');
  40. require_once('expression.class.inc.php');
  41. require_once('cmdbsource.class.inc.php');
  42. require_once('sqlquery.class.inc.php');
  43. require_once('oql/oqlquery.class.inc.php');
  44. require_once('oql/oqlexception.class.inc.php');
  45. require_once('oql/oql-parser.php');
  46. require_once('oql/oql-lexer.php');
  47. require_once('oql/oqlinterpreter.class.inc.php');
  48. require_once('dbobject.class.php');
  49. require_once('dbobjectsearch.class.php');
  50. require_once('dbobjectset.class.php');
  51. require_once('backgroundprocess.inc.php');
  52. require_once('asynctask.class.inc.php');
  53. require_once('dbproperty.class.inc.php');
  54. // db change tracking data model
  55. require_once('cmdbchange.class.inc.php');
  56. require_once('cmdbchangeop.class.inc.php');
  57. // customization data model
  58. // Romain: temporary moved into application.inc.php (see explanations there)
  59. //require_once('trigger.class.inc.php');
  60. //require_once('action.class.inc.php');
  61. // application log
  62. // Romain: temporary moved into application.inc.php (see explanations there)
  63. //require_once('event.class.inc.php');
  64. require_once('templatestring.class.inc.php');
  65. require_once('csvparser.class.inc.php');
  66. require_once('bulkchange.class.inc.php');
  67. /**
  68. * A persistent object, which changes are accurately recorded
  69. *
  70. * @package iTopORM
  71. */
  72. abstract class CMDBObject extends DBObject
  73. {
  74. protected $m_datCreated;
  75. protected $m_datUpdated;
  76. // Note: this value is static, but that could be changed because it is sometimes a real issue (see update of interfaces / connected_to
  77. protected static $m_oCurrChange = null;
  78. public static function SetCurrentChange(CMDBChange $oChange)
  79. {
  80. self::$m_oCurrChange = $oChange;
  81. }
  82. //
  83. // Todo: simplify the APIs and do not pass the current change as an argument anymore
  84. // SetCurrentChange to be invoked in very few cases (UI.php, CSV import, Data synchro)
  85. // GetCurrentChange to be called ONCE (!) by CMDBChangeOp::OnInsert ($this->Set('change', ..GetCurrentChange())
  86. // GetCurrentChange to create a default change if not already done in the current context
  87. //
  88. public static function GetCurrentChange()
  89. {
  90. return self::$m_oCurrChange;
  91. }
  92. private function RecordObjCreation(CMDBChange $oChange)
  93. {
  94. $oMyChangeOp = MetaModel::NewObject("CMDBChangeOpCreate");
  95. $oMyChangeOp->Set("change", $oChange->GetKey());
  96. $oMyChangeOp->Set("objclass", get_class($this));
  97. $oMyChangeOp->Set("objkey", $this->GetKey());
  98. $iId = $oMyChangeOp->DBInsertNoReload();
  99. }
  100. private function RecordObjDeletion(CMDBChange $oChange, $objkey)
  101. {
  102. $oMyChangeOp = MetaModel::NewObject("CMDBChangeOpDelete");
  103. $oMyChangeOp->Set("change", $oChange->GetKey());
  104. $oMyChangeOp->Set("objclass", get_class($this));
  105. $oMyChangeOp->Set("objkey", $objkey);
  106. $iId = $oMyChangeOp->DBInsertNoReload();
  107. }
  108. private function RecordAttChanges(CMDBChange $oChange, array $aValues, array $aOrigValues)
  109. {
  110. // $aValues is an array of $sAttCode => $value
  111. //
  112. foreach ($aValues as $sAttCode=> $value)
  113. {
  114. $oAttDef = MetaModel::GetAttributeDef(get_class($this), $sAttCode);
  115. if ($oAttDef->IsLinkSet()) continue; // #@# temporary
  116. if ($oAttDef instanceOf AttributeOneWayPassword)
  117. {
  118. // One Way encrypted passwords' history is stored -one way- encrypted
  119. $oMyChangeOp = MetaModel::NewObject("CMDBChangeOpSetAttributeOneWayPassword");
  120. $oMyChangeOp->Set("change", $oChange->GetKey());
  121. $oMyChangeOp->Set("objclass", get_class($this));
  122. $oMyChangeOp->Set("objkey", $this->GetKey());
  123. $oMyChangeOp->Set("attcode", $sAttCode);
  124. if (array_key_exists($sAttCode, $aOrigValues))
  125. {
  126. $original = $aOrigValues[$sAttCode];
  127. }
  128. else
  129. {
  130. $original = '';
  131. }
  132. $oMyChangeOp->Set("prev_pwd", $original);
  133. $iId = $oMyChangeOp->DBInsertNoReload();
  134. }
  135. elseif ($oAttDef instanceOf AttributeEncryptedString)
  136. {
  137. // Encrypted string history is stored encrypted
  138. $oMyChangeOp = MetaModel::NewObject("CMDBChangeOpSetAttributeEncrypted");
  139. $oMyChangeOp->Set("change", $oChange->GetKey());
  140. $oMyChangeOp->Set("objclass", get_class($this));
  141. $oMyChangeOp->Set("objkey", $this->GetKey());
  142. $oMyChangeOp->Set("attcode", $sAttCode);
  143. if (array_key_exists($sAttCode, $aOrigValues))
  144. {
  145. $original = $aOrigValues[$sAttCode];
  146. }
  147. else
  148. {
  149. $original = '';
  150. }
  151. $oMyChangeOp->Set("prevstring", $original);
  152. $iId = $oMyChangeOp->DBInsertNoReload();
  153. }
  154. elseif ($oAttDef instanceOf AttributeBlob)
  155. {
  156. // Data blobs
  157. $oMyChangeOp = MetaModel::NewObject("CMDBChangeOpSetAttributeBlob");
  158. $oMyChangeOp->Set("change", $oChange->GetKey());
  159. $oMyChangeOp->Set("objclass", get_class($this));
  160. $oMyChangeOp->Set("objkey", $this->GetKey());
  161. $oMyChangeOp->Set("attcode", $sAttCode);
  162. if (array_key_exists($sAttCode, $aOrigValues))
  163. {
  164. $original = $aOrigValues[$sAttCode];
  165. }
  166. else
  167. {
  168. $original = new ormDocument();
  169. }
  170. $oMyChangeOp->Set("prevdata", $original);
  171. $iId = $oMyChangeOp->DBInsertNoReload();
  172. }
  173. elseif ($oAttDef instanceOf AttributeCaseLog)
  174. {
  175. $oMyChangeOp = MetaModel::NewObject("CMDBChangeOpSetAttributeCaseLog");
  176. $oMyChangeOp->Set("change", $oChange->GetKey());
  177. $oMyChangeOp->Set("objclass", get_class($this));
  178. $oMyChangeOp->Set("objkey", $this->GetKey());
  179. $oMyChangeOp->Set("attcode", $sAttCode);
  180. $oMyChangeOp->Set("lastentry", $value->GetLatestEntryIndex());
  181. $iId = $oMyChangeOp->DBInsertNoReload();
  182. }
  183. elseif ($oAttDef instanceOf AttributeText)
  184. {
  185. // Data blobs
  186. $oMyChangeOp = MetaModel::NewObject("CMDBChangeOpSetAttributeText");
  187. $oMyChangeOp->Set("change", $oChange->GetKey());
  188. $oMyChangeOp->Set("objclass", get_class($this));
  189. $oMyChangeOp->Set("objkey", $this->GetKey());
  190. $oMyChangeOp->Set("attcode", $sAttCode);
  191. if (array_key_exists($sAttCode, $aOrigValues))
  192. {
  193. $original = $aOrigValues[$sAttCode];
  194. if ($original instanceof ormCaseLog)
  195. {
  196. $original = $original->GetText();
  197. }
  198. }
  199. else
  200. {
  201. $original = null;
  202. }
  203. $oMyChangeOp->Set("prevdata", $original);
  204. $iId = $oMyChangeOp->DBInsertNoReload();
  205. }
  206. else
  207. {
  208. // Scalars
  209. //
  210. $oMyChangeOp = MetaModel::NewObject("CMDBChangeOpSetAttributeScalar");
  211. $oMyChangeOp->Set("change", $oChange->GetKey());
  212. $oMyChangeOp->Set("objclass", get_class($this));
  213. $oMyChangeOp->Set("objkey", $this->GetKey());
  214. $oMyChangeOp->Set("attcode", $sAttCode);
  215. if (array_key_exists($sAttCode, $aOrigValues))
  216. {
  217. $sOriginalValue = $aOrigValues[$sAttCode];
  218. }
  219. else
  220. {
  221. $sOriginalValue = 'undefined';
  222. }
  223. $oMyChangeOp->Set("oldvalue", $sOriginalValue);
  224. $oMyChangeOp->Set("newvalue", $value);
  225. $iId = $oMyChangeOp->DBInsertNoReload();
  226. }
  227. }
  228. }
  229. /**
  230. * Helper to ultimately check user rights before writing (Insert, Update or Delete)
  231. * The check should never fail, because the UI should prevent from such a usage
  232. * Anyhow, if the user has found a workaround... the security gets enforced here
  233. */
  234. protected function CheckUserRights($bSkipStrongSecurity, $iActionCode)
  235. {
  236. if (is_null($bSkipStrongSecurity))
  237. {
  238. // This is temporary
  239. // We have implemented this safety net right before releasing iTop 1.0
  240. // and we decided that it was too risky to activate it
  241. // Anyhow, users willing to have a very strong security could set
  242. // skip_strong_security = 0, in the config file
  243. $bSkipStrongSecurity = MetaModel::GetConfig()->Get('skip_strong_security');
  244. }
  245. if (!$bSkipStrongSecurity)
  246. {
  247. $sClass = get_class($this);
  248. $oSet = DBObjectSet::FromObject($this);
  249. if (!UserRights::IsActionAllowed($sClass, $iActionCode, $oSet))
  250. {
  251. // Intrusion detected
  252. throw new SecurityException('You are not allowed to modify objects of class: '.$sClass);
  253. }
  254. }
  255. }
  256. public function DBInsert()
  257. {
  258. if(!is_object(self::$m_oCurrChange))
  259. {
  260. throw new CoreException("DBInsert() could not be used here, please use DBInsertTracked() instead");
  261. }
  262. return $this->DBInsertTracked_Internal();
  263. }
  264. public function DBInsertTracked(CMDBChange $oChange, $bSkipStrongSecurity = null)
  265. {
  266. $this->CheckUserRights($bSkipStrongSecurity, UR_ACTION_MODIFY);
  267. $oPreviousChange = self::$m_oCurrChange;
  268. self::$m_oCurrChange = $oChange;
  269. $ret = $this->DBInsertTracked_Internal();
  270. self::$m_oCurrChange = $oPreviousChange;
  271. return $ret;
  272. }
  273. public function DBInsertTrackedNoReload(CMDBChange $oChange, $bSkipStrongSecurity = null)
  274. {
  275. $this->CheckUserRights($bSkipStrongSecurity, UR_ACTION_MODIFY);
  276. $oPreviousChange = self::$m_oCurrChange;
  277. self::$m_oCurrChange = $oChange;
  278. $ret = $this->DBInsertTracked_Internal(true);
  279. self::$m_oCurrChange = $oPreviousChange;
  280. return $ret;
  281. }
  282. protected function DBInsertTracked_Internal($bDoNotReload = false)
  283. {
  284. if ($bDoNotReload)
  285. {
  286. $ret = parent::DBInsertNoReload();
  287. }
  288. else
  289. {
  290. $ret = parent::DBInsert();
  291. }
  292. $this->RecordObjCreation(self::$m_oCurrChange);
  293. return $ret;
  294. }
  295. public function DBClone($newKey = null)
  296. {
  297. if(!self::$m_oCurrChange)
  298. {
  299. throw new CoreException("DBClone() could not be used here, please use DBCloneTracked() instead");
  300. }
  301. return $this->DBCloneTracked_Internal();
  302. }
  303. public function DBCloneTracked(CMDBChange $oChange, $newKey = null)
  304. {
  305. $oPreviousChange = self::$m_oCurrChange;
  306. self::$m_oCurrChange = $oChange;
  307. $this->DBCloneTracked_Internal($newKey);
  308. self::$m_oCurrChange = $oPreviousChange;
  309. }
  310. protected function DBCloneTracked_Internal($newKey = null)
  311. {
  312. $newKey = parent::DBClone($newKey);
  313. $oClone = MetaModel::GetObject(get_class($this), $newKey);
  314. $oClone->RecordObjCreation(self::$m_oCurrChange);
  315. return $newKey;
  316. }
  317. public function DBUpdate()
  318. {
  319. if(!self::$m_oCurrChange)
  320. {
  321. throw new CoreException("DBUpdate() could not be used here, please use DBUpdateTracked() instead");
  322. }
  323. return $this->DBUpdateTracked_internal();
  324. }
  325. public function DBUpdateTracked(CMDBChange $oChange, $bSkipStrongSecurity = null)
  326. {
  327. $this->CheckUserRights($bSkipStrongSecurity, UR_ACTION_MODIFY);
  328. $oPreviousChange = self::$m_oCurrChange;
  329. self::$m_oCurrChange = $oChange;
  330. $this->DBUpdateTracked_Internal();
  331. self::$m_oCurrChange = $oPreviousChange;
  332. }
  333. protected function DBUpdateTracked_Internal()
  334. {
  335. // Copy the changes list before the update (the list should be reset afterwards)
  336. $aChanges = $this->ListChanges();
  337. if (count($aChanges) == 0)
  338. {
  339. //throw new CoreWarning("Attempting to update an unchanged object");
  340. return;
  341. }
  342. // Save the original values (will be reset to the new values when the object get written to the DB)
  343. $aOriginalValues = $this->m_aOrigValues;
  344. $ret = parent::DBUpdate();
  345. $this->RecordAttChanges(self::$m_oCurrChange, $aChanges, $aOriginalValues);
  346. return $ret;
  347. }
  348. public function DBDelete(&$oDeletionPlan = null)
  349. {
  350. if(!self::$m_oCurrChange)
  351. {
  352. throw new CoreException("DBDelete() could not be used here, please use DBDeleteTracked() instead");
  353. }
  354. return $this->DBDeleteTracked_Internal($oDeletionPlan);
  355. }
  356. public function DBDeleteTracked(CMDBChange $oChange, $bSkipStrongSecurity = null, &$oDeletionPlan = null)
  357. {
  358. $this->CheckUserRights($bSkipStrongSecurity, UR_ACTION_DELETE);
  359. $oPreviousChange = self::$m_oCurrChange;
  360. self::$m_oCurrChange = $oChange;
  361. $this->DBDeleteTracked_Internal($oDeletionPlan);
  362. self::$m_oCurrChange = $oPreviousChange;
  363. }
  364. protected function DBDeleteTracked_Internal(&$oDeletionPlan = null)
  365. {
  366. $prevkey = $this->GetKey();
  367. $ret = parent::DBDelete($oDeletionPlan);
  368. $this->RecordObjDeletion(self::$m_oCurrChange, $prevkey);
  369. return $ret;
  370. }
  371. public static function BulkDelete(DBObjectSearch $oFilter)
  372. {
  373. if(!self::$m_oCurrChange)
  374. {
  375. throw new CoreException("BulkDelete() could not be used here, please use BulkDeleteTracked() instead");
  376. }
  377. return $this->BulkDeleteTracked_Internal($oFilter);
  378. }
  379. public static function BulkDeleteTracked(CMDBChange $oChange, DBObjectSearch $oFilter)
  380. {
  381. $oPreviousChange = self::$m_oCurrChange;
  382. self::$m_oCurrChange = $oChange;
  383. $this->BulkDeleteTracked_Internal($oFilter);
  384. self::$m_oCurrChange = $oPreviousChange;
  385. }
  386. protected static function BulkDeleteTracked_Internal(DBObjectSearch $oFilter)
  387. {
  388. throw new CoreWarning("Change tracking not tested for bulk operations");
  389. // Get the list of objects to delete (and record data before deleting the DB records)
  390. $oObjSet = new CMDBObjectSet($oFilter);
  391. $aObjAndKeys = array(); // array of id=>object
  392. while ($oItem = $oObjSet->Fetch())
  393. {
  394. $aObjAndKeys[$oItem->GetKey()] = $oItem;
  395. }
  396. $oObjSet->FreeResult();
  397. // Delete in one single efficient query
  398. $ret = parent::BulkDelete($oFilter);
  399. // Record... in many queries !!!
  400. foreach($aObjAndKeys as $prevkey=>$oItem)
  401. {
  402. $oItem->RecordObjDeletion(self::$m_oCurrChange, $prevkey);
  403. }
  404. return $ret;
  405. }
  406. public static function BulkUpdate(DBObjectSearch $oFilter, array $aValues)
  407. {
  408. if(!self::$m_oCurrChange)
  409. {
  410. throw new CoreException("BulkUpdate() could not be used here, please use BulkUpdateTracked() instead");
  411. }
  412. return $this->BulkUpdateTracked_Internal($oFilter, $aValues);
  413. }
  414. public static function BulkUpdateTracked(CMDBChange $oChange, DBObjectSearch $oFilter, array $aValues)
  415. {
  416. $oPreviousChange = self::$m_oCurrChange;
  417. self::$m_oCurrChange = $oChange;
  418. $this->BulkUpdateTracked_Internal($oFilter, $aValues);
  419. self::$m_oCurrChange = $oPreviousChange;
  420. }
  421. protected static function BulkUpdateTracked_Internal(DBObjectSearch $oFilter, array $aValues)
  422. {
  423. // $aValues is an array of $sAttCode => $value
  424. // Get the list of objects to update (and load it before doing the change)
  425. $oObjSet = new CMDBObjectSet($oFilter);
  426. $oObjSet->Load();
  427. // Keep track of the previous values (will be overwritten when the objects are synchronized with the DB)
  428. $aOriginalValues = array();
  429. $oObjSet->Rewind();
  430. while ($oItem = $oObjSet->Fetch())
  431. {
  432. $aOriginalValues[$oItem->GetKey()] = $oItem->m_aOrigValues;
  433. }
  434. // Update in one single efficient query
  435. $ret = parent::BulkUpdate($oFilter, $aValues);
  436. // Record... in many queries !!!
  437. $oObjSet->Rewind();
  438. while ($oItem = $oObjSet->Fetch())
  439. {
  440. $aChangedValues = $oItem->ListChangedValues($aValues);
  441. $oItem->RecordAttChanges(self::$m_oCurrChange, $aChangedValues, $aOriginalValues[$oItem->GetKey()]);
  442. }
  443. return $ret;
  444. }
  445. }
  446. /**
  447. * TODO: investigate how to get rid of this class that was made to workaround some language limitation... or a poor design!
  448. *
  449. * @package iTopORM
  450. */
  451. class CMDBObjectSet extends DBObjectSet
  452. {
  453. // this is the public interface (?)
  454. // I have to define those constructors here... :-(
  455. // just to get the right object class in return.
  456. // I have to think again to those things: maybe it will work fine if a have a constructor define here (?)
  457. static public function FromScratch($sClass)
  458. {
  459. $oFilter = new CMDBSearchFilter($sClass);
  460. $oFilter->AddConditionExpression(new FalseExpression());
  461. $oRetSet = new self($oFilter);
  462. // NOTE: THIS DOES NOT WORK IF m_bLoaded is private in the base class (and you will not get any error message)
  463. $oRetSet->m_bLoaded = true; // no DB load
  464. return $oRetSet;
  465. }
  466. // create an object set ex nihilo
  467. // input = array of objects
  468. static public function FromArray($sClass, $aObjects)
  469. {
  470. $oRetSet = self::FromScratch($sClass);
  471. $oRetSet->AddObjectArray($aObjects, $sClass);
  472. return $oRetSet;
  473. }
  474. static public function FromArrayAssoc($aClasses, $aObjects)
  475. {
  476. // In a perfect world, we should create a complete tree of DBObjectSearch,
  477. // but as we lack most of the information related to the objects,
  478. // let's create one search definition
  479. $sClass = reset($aClasses);
  480. $sAlias = key($aClasses);
  481. $oFilter = new CMDBSearchFilter($sClass, $sAlias);
  482. $oRetSet = new CMDBObjectSet($oFilter);
  483. $oRetSet->m_bLoaded = true; // no DB load
  484. foreach($aObjects as $rowIndex => $aObjectsByClassAlias)
  485. {
  486. $oRetSet->AddObjectExtended($aObjectsByClassAlias);
  487. }
  488. return $oRetSet;
  489. }
  490. }
  491. /**
  492. * TODO: investigate how to get rid of this class that was made to workaround some language limitation... or a poor design!
  493. *
  494. * @package iTopORM
  495. */
  496. class CMDBSearchFilter extends DBObjectSearch
  497. {
  498. // this is the public interface (?)
  499. }
  500. ?>