valuesetdef.class.inc.php 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360
  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. $oValueExpr = new ScalarExpression('%'.$sContains.'%');
  184. $oNameExpr = new FieldExpression('friendlyname', $oFilter->GetClassAlias());
  185. $oNewCondition = new BinaryExpression($oNameExpr, 'LIKE', $oValueExpr);
  186. $oFilter->AddConditionExpression($oNewCondition);
  187. $oObjects = new DBObjectSet($oFilter, $this->m_aOrderBy, $aArgs);
  188. while ($oObject = $oObjects->Fetch())
  189. {
  190. if (empty($this->m_sValueAttCode))
  191. {
  192. $this->m_aValues[$oObject->GetKey()] = $oObject->GetName();
  193. }
  194. else
  195. {
  196. $this->m_aValues[$oObject->GetKey()] = $oObject->Get($this->m_sValueAttCode);
  197. }
  198. }
  199. return true;
  200. }
  201. public function GetValuesDescription()
  202. {
  203. return 'Filter: '.$this->m_sFilterExpr;
  204. }
  205. public function GetFilterExpression()
  206. {
  207. return $this->m_sFilterExpr;
  208. }
  209. }
  210. /**
  211. * Fixed set values (could be hardcoded in the business model)
  212. *
  213. * @package iTopORM
  214. */
  215. class ValueSetEnum extends ValueSetDefinition
  216. {
  217. protected $m_values;
  218. public function __construct($Values)
  219. {
  220. $this->m_values = $Values;
  221. }
  222. // Helper to export the datat model
  223. public function GetValueList()
  224. {
  225. $this->LoadValues($aArgs = array());
  226. return $this->m_aValues;
  227. }
  228. protected function LoadValues($aArgs)
  229. {
  230. if (is_array($this->m_values))
  231. {
  232. $aValues = $this->m_values;
  233. }
  234. elseif (is_string($this->m_values) && strlen($this->m_values) > 0)
  235. {
  236. $aValues = array();
  237. foreach (explode(",", $this->m_values) as $sVal)
  238. {
  239. $sVal = trim($sVal);
  240. $sKey = $sVal;
  241. $aValues[$sKey] = $sVal;
  242. }
  243. }
  244. else
  245. {
  246. $aValues = array();
  247. }
  248. $this->m_aValues = $aValues;
  249. return true;
  250. }
  251. }
  252. /**
  253. * Fixed set values, defined as a range: 0..59 (with an optional increment)
  254. *
  255. * @package iTopORM
  256. */
  257. class ValueSetRange extends ValueSetDefinition
  258. {
  259. protected $m_iStart;
  260. protected $m_iEnd;
  261. public function __construct($iStart, $iEnd, $iStep = 1)
  262. {
  263. $this->m_iStart = $iStart;
  264. $this->m_iEnd = $iEnd;
  265. $this->m_iStep = $iStep;
  266. }
  267. protected function LoadValues($aArgs)
  268. {
  269. $iValue = $this->m_iStart;
  270. for($iValue = $this->m_iStart; $iValue <= $this->m_iEnd; $iValue += $this->m_iStep)
  271. {
  272. $this->m_aValues[$iValue] = $iValue;
  273. }
  274. return true;
  275. }
  276. }
  277. /**
  278. * Data model classes
  279. *
  280. * @package iTopORM
  281. */
  282. class ValueSetEnumClasses extends ValueSetEnum
  283. {
  284. protected $m_sCategories;
  285. public function __construct($sCategories = '', $sAdditionalValues = '')
  286. {
  287. $this->m_sCategories = $sCategories;
  288. parent::__construct($sAdditionalValues);
  289. }
  290. protected function LoadValues($aArgs)
  291. {
  292. // Call the parent to parse the additional values...
  293. parent::LoadValues($aArgs);
  294. // Translate the labels of the additional values
  295. foreach($this->m_aValues as $sClass => $void)
  296. {
  297. if (MetaModel::IsValidClass($sClass))
  298. {
  299. $this->m_aValues[$sClass] = MetaModel::GetName($sClass);
  300. }
  301. else
  302. {
  303. unset($this->m_aValues[$sClass]);
  304. }
  305. }
  306. // Then, add the classes from the category definition
  307. foreach (MetaModel::GetClasses($this->m_sCategories) as $sClass)
  308. {
  309. if (MetaModel::IsValidClass($sClass))
  310. {
  311. $this->m_aValues[$sClass] = MetaModel::GetName($sClass);
  312. }
  313. else
  314. {
  315. unset($this->m_aValues[$sClass]);
  316. }
  317. }
  318. return true;
  319. }
  320. }