valuesetdef.class.inc.php 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363
  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. /**
  19. * Value set definitions (from a fixed list or from a query, etc.)
  20. *
  21. * @copyright Copyright (C) 2010-2017 Combodo SARL
  22. * @license http://opensource.org/licenses/AGPL-3.0
  23. */
  24. require_once('MyHelpers.class.inc.php');
  25. /**
  26. * ValueSetDefinition
  27. * value sets API and implementations
  28. *
  29. * @package iTopORM
  30. */
  31. abstract class ValueSetDefinition
  32. {
  33. protected $m_bIsLoaded = false;
  34. protected $m_aValues = array();
  35. // Displayable description that could be computed out of the std usage context
  36. public function GetValuesDescription()
  37. {
  38. $aValues = $this->GetValues(array(), '');
  39. $aDisplayedValues = array();
  40. foreach($aValues as $key => $value)
  41. {
  42. $aDisplayedValues[] = "$key => $value";
  43. }
  44. $sAllowedValues = implode(', ', $aDisplayedValues);
  45. return $sAllowedValues;
  46. }
  47. public function GetValues($aArgs, $sContains = '')
  48. {
  49. if (!$this->m_bIsLoaded)
  50. {
  51. $this->LoadValues($aArgs);
  52. $this->m_bIsLoaded = true;
  53. }
  54. if (strlen($sContains) == 0)
  55. {
  56. // No filtering
  57. $aRet = $this->m_aValues;
  58. }
  59. else
  60. {
  61. // Filter on results containing the needle <sContain>
  62. $aRet = array();
  63. foreach ($this->m_aValues as $sKey=>$sValue)
  64. {
  65. if (stripos($sValue, $sContains) !== false)
  66. {
  67. $aRet[$sKey] = $sValue;
  68. }
  69. }
  70. }
  71. // Sort on the display value
  72. asort($aRet);
  73. return $aRet;
  74. }
  75. abstract protected function LoadValues($aArgs);
  76. }
  77. /**
  78. * Set of existing values for an attribute, given a search filter
  79. *
  80. * @package iTopORM
  81. */
  82. class ValueSetObjects extends ValueSetDefinition
  83. {
  84. protected $m_sContains;
  85. protected $m_sFilterExpr; // in OQL
  86. protected $m_sValueAttCode;
  87. protected $m_aOrderBy;
  88. protected $m_aExtraConditions;
  89. private $m_bAllowAllData;
  90. private $m_aModifierProperties;
  91. /**
  92. * @param hash $aOrderBy Array of '[<classalias>.]attcode' => bAscending
  93. */
  94. public function __construct($sFilterExp, $sValueAttCode = '', $aOrderBy = array(), $bAllowAllData = false, $aModifierProperties = array())
  95. {
  96. $this->m_sContains = '';
  97. $this->m_sFilterExpr = $sFilterExp;
  98. $this->m_sValueAttCode = $sValueAttCode;
  99. $this->m_aOrderBy = $aOrderBy;
  100. $this->m_bAllowAllData = $bAllowAllData;
  101. $this->m_aModifierProperties = $aModifierProperties;
  102. $this->m_aExtraConditions = array();
  103. }
  104. public function SetModifierProperty($sPluginClass, $sProperty, $value)
  105. {
  106. $this->m_aModifierProperties[$sPluginClass][$sProperty] = $value;
  107. }
  108. public function AddCondition(DBSearch $oFilter)
  109. {
  110. $this->m_aExtraConditions[] = $oFilter;
  111. }
  112. public function ToObjectSet($aArgs = array(), $sContains = '', $iAdditionalValue = null)
  113. {
  114. if ($this->m_bAllowAllData)
  115. {
  116. $oFilter = DBObjectSearch::FromOQL_AllData($this->m_sFilterExpr);
  117. }
  118. else
  119. {
  120. $oFilter = DBObjectSearch::FromOQL($this->m_sFilterExpr);
  121. }
  122. foreach($this->m_aExtraConditions as $oExtraFilter)
  123. {
  124. $oFilter = $oFilter->Intersect($oExtraFilter);
  125. }
  126. foreach($this->m_aModifierProperties as $sPluginClass => $aProperties)
  127. {
  128. foreach ($aProperties as $sProperty => $value)
  129. {
  130. $oFilter->SetModifierProperty($sPluginClass, $sProperty, $value);
  131. }
  132. }
  133. if ($iAdditionalValue > 0)
  134. {
  135. $oSearchAdditionalValue = new DBObjectSearch($oFilter->GetClass());
  136. $oSearchAdditionalValue->AddConditionExpression( new BinaryExpression(
  137. new FieldExpression('id', $oSearchAdditionalValue->GetClassAlias()),
  138. '=',
  139. new VariableExpression('current_extkey_id'))
  140. );
  141. $oSearchAdditionalValue->AllowAllData();
  142. $oSearchAdditionalValue->SetArchiveMode(true);
  143. $oSearchAdditionalValue->SetInternalParams( array('current_extkey_id' => $iAdditionalValue) );
  144. $oFilter = new DBUnionSearch(array($oFilter, $oSearchAdditionalValue));
  145. }
  146. return new DBObjectSet($oFilter, $this->m_aOrderBy, $aArgs);
  147. }
  148. public function GetValues($aArgs, $sContains = '')
  149. {
  150. if (!$this->m_bIsLoaded || ($sContains != $this->m_sContains))
  151. {
  152. $this->LoadValues($aArgs, $sContains);
  153. $this->m_bIsLoaded = true;
  154. }
  155. // The results are already filtered and sorted (on friendly name)
  156. $aRet = $this->m_aValues;
  157. return $aRet;
  158. }
  159. protected function LoadValues($aArgs, $sContains = '')
  160. {
  161. $this->m_sContains = $sContains;
  162. $this->m_aValues = array();
  163. if ($this->m_bAllowAllData)
  164. {
  165. $oFilter = DBObjectSearch::FromOQL_AllData($this->m_sFilterExpr);
  166. }
  167. else
  168. {
  169. $oFilter = DBObjectSearch::FromOQL($this->m_sFilterExpr);
  170. }
  171. if (!$oFilter) return false;
  172. foreach($this->m_aExtraConditions as $oExtraFilter)
  173. {
  174. $oFilter = $oFilter->Intersect($oExtraFilter);
  175. }
  176. foreach($this->m_aModifierProperties as $sPluginClass => $aProperties)
  177. {
  178. foreach ($aProperties as $sProperty => $value)
  179. {
  180. $oFilter->SetModifierProperty($sPluginClass, $sProperty, $value);
  181. }
  182. }
  183. if (!empty($sContains))
  184. {
  185. $oValueExpr = new ScalarExpression('%'.$sContains.'%');
  186. $oNameExpr = new FieldExpression('friendlyname', $oFilter->GetClassAlias());
  187. $oNewCondition = new BinaryExpression($oNameExpr, 'LIKE', $oValueExpr);
  188. $oFilter->AddConditionExpression($oNewCondition);
  189. }
  190. $oObjects = new DBObjectSet($oFilter, $this->m_aOrderBy, $aArgs);
  191. while ($oObject = $oObjects->Fetch())
  192. {
  193. if (empty($this->m_sValueAttCode))
  194. {
  195. $this->m_aValues[$oObject->GetKey()] = $oObject->GetName();
  196. }
  197. else
  198. {
  199. $this->m_aValues[$oObject->GetKey()] = $oObject->Get($this->m_sValueAttCode);
  200. }
  201. }
  202. return true;
  203. }
  204. public function GetValuesDescription()
  205. {
  206. return 'Filter: '.$this->m_sFilterExpr;
  207. }
  208. public function GetFilterExpression()
  209. {
  210. return $this->m_sFilterExpr;
  211. }
  212. }
  213. /**
  214. * Fixed set values (could be hardcoded in the business model)
  215. *
  216. * @package iTopORM
  217. */
  218. class ValueSetEnum extends ValueSetDefinition
  219. {
  220. protected $m_values;
  221. public function __construct($Values)
  222. {
  223. $this->m_values = $Values;
  224. }
  225. // Helper to export the datat model
  226. public function GetValueList()
  227. {
  228. $this->LoadValues($aArgs = array());
  229. return $this->m_aValues;
  230. }
  231. protected function LoadValues($aArgs)
  232. {
  233. if (is_array($this->m_values))
  234. {
  235. $aValues = $this->m_values;
  236. }
  237. elseif (is_string($this->m_values) && strlen($this->m_values) > 0)
  238. {
  239. $aValues = array();
  240. foreach (explode(",", $this->m_values) as $sVal)
  241. {
  242. $sVal = trim($sVal);
  243. $sKey = $sVal;
  244. $aValues[$sKey] = $sVal;
  245. }
  246. }
  247. else
  248. {
  249. $aValues = array();
  250. }
  251. $this->m_aValues = $aValues;
  252. return true;
  253. }
  254. }
  255. /**
  256. * Fixed set values, defined as a range: 0..59 (with an optional increment)
  257. *
  258. * @package iTopORM
  259. */
  260. class ValueSetRange extends ValueSetDefinition
  261. {
  262. protected $m_iStart;
  263. protected $m_iEnd;
  264. public function __construct($iStart, $iEnd, $iStep = 1)
  265. {
  266. $this->m_iStart = $iStart;
  267. $this->m_iEnd = $iEnd;
  268. $this->m_iStep = $iStep;
  269. }
  270. protected function LoadValues($aArgs)
  271. {
  272. $iValue = $this->m_iStart;
  273. for($iValue = $this->m_iStart; $iValue <= $this->m_iEnd; $iValue += $this->m_iStep)
  274. {
  275. $this->m_aValues[$iValue] = $iValue;
  276. }
  277. return true;
  278. }
  279. }
  280. /**
  281. * Data model classes
  282. *
  283. * @package iTopORM
  284. */
  285. class ValueSetEnumClasses extends ValueSetEnum
  286. {
  287. protected $m_sCategories;
  288. public function __construct($sCategories = '', $sAdditionalValues = '')
  289. {
  290. $this->m_sCategories = $sCategories;
  291. parent::__construct($sAdditionalValues);
  292. }
  293. protected function LoadValues($aArgs)
  294. {
  295. // Call the parent to parse the additional values...
  296. parent::LoadValues($aArgs);
  297. // Translate the labels of the additional values
  298. foreach($this->m_aValues as $sClass => $void)
  299. {
  300. if (MetaModel::IsValidClass($sClass))
  301. {
  302. $this->m_aValues[$sClass] = MetaModel::GetName($sClass);
  303. }
  304. else
  305. {
  306. unset($this->m_aValues[$sClass]);
  307. }
  308. }
  309. // Then, add the classes from the category definition
  310. foreach (MetaModel::GetClasses($this->m_sCategories) as $sClass)
  311. {
  312. if (MetaModel::IsValidClass($sClass))
  313. {
  314. $this->m_aValues[$sClass] = MetaModel::GetName($sClass);
  315. }
  316. else
  317. {
  318. unset($this->m_aValues[$sClass]);
  319. }
  320. }
  321. return true;
  322. }
  323. }