valuesetdef.class.inc.php 9.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365
  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. * Value set definitions (from a fixed list or from a query, etc.)
  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. 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. public function __construct($sFilterExp, $sValueAttCode = '', $aOrderBy = array(), $bAllowAllData = false)
  91. {
  92. $this->m_sContains = '';
  93. $this->m_sFilterExpr = $sFilterExp;
  94. $this->m_sValueAttCode = $sValueAttCode;
  95. $this->m_aOrderBy = $aOrderBy;
  96. $this->m_bAllowAllData = $bAllowAllData;
  97. $this->m_aExtraConditions = array();
  98. }
  99. public function AddCondition(DBObjectSearch $oFilter)
  100. {
  101. $this->m_aExtraConditions[] = $oFilter;
  102. }
  103. public function ToObjectSet($aArgs = array(), $sContains = '')
  104. {
  105. if ($this->m_bAllowAllData)
  106. {
  107. $oFilter = DBObjectSearch::FromOQL_AllData($this->m_sFilterExpr);
  108. }
  109. else
  110. {
  111. $oFilter = DBObjectSearch::FromOQL($this->m_sFilterExpr);
  112. }
  113. foreach($this->m_aExtraConditions as $oExtraFilter)
  114. {
  115. $oFilter->MergeWith($oExtraFilter);
  116. }
  117. return new DBObjectSet($oFilter, $this->m_aOrderBy, $aArgs);
  118. }
  119. public function GetValues($aArgs, $sContains = '')
  120. {
  121. if (!$this->m_bIsLoaded || ($sContains != $this->m_sContains))
  122. {
  123. $this->LoadValues($aArgs, $sContains);
  124. $this->m_bIsLoaded = true;
  125. }
  126. // The results are already filtered and sorted (on friendly name)
  127. $aRet = $this->m_aValues;
  128. return $aRet;
  129. }
  130. protected function LoadValues($aArgs, $sContains = '')
  131. {
  132. $this->m_sContains = $sContains;
  133. $this->m_aValues = array();
  134. if ($this->m_bAllowAllData)
  135. {
  136. $oFilter = DBObjectSearch::FromOQL_AllData($this->m_sFilterExpr);
  137. }
  138. else
  139. {
  140. $oFilter = DBObjectSearch::FromOQL($this->m_sFilterExpr);
  141. }
  142. if (!$oFilter) return false;
  143. foreach($this->m_aExtraConditions as $oExtraFilter)
  144. {
  145. $oFilter->MergeWith($oExtraFilter);
  146. }
  147. $oValueExpr = new ScalarExpression('%'.$sContains.'%');
  148. $oNameExpr = new FieldExpression('friendlyname', $oFilter->GetClassAlias());
  149. $oNewCondition = new BinaryExpression($oNameExpr, 'LIKE', $oValueExpr);
  150. $oFilter->AddConditionExpression($oNewCondition);
  151. $oObjects = new DBObjectSet($oFilter, $this->m_aOrderBy, $aArgs);
  152. while ($oObject = $oObjects->Fetch())
  153. {
  154. if (empty($this->m_sValueAttCode))
  155. {
  156. $this->m_aValues[$oObject->GetKey()] = $oObject->GetName();
  157. }
  158. else
  159. {
  160. $this->m_aValues[$oObject->GetKey()] = $oObject->Get($this->m_sValueAttCode);
  161. }
  162. }
  163. return true;
  164. }
  165. public function GetValuesDescription()
  166. {
  167. return 'Filter: '.$this->m_sFilterExpr;
  168. }
  169. }
  170. /**
  171. * Set of existing values for a link set attribute, given a relation code
  172. *
  173. * @package iTopORM
  174. */
  175. class ValueSetRelatedObjectsFromLinkSet extends ValueSetDefinition
  176. {
  177. protected $m_sLinkSetAttCode;
  178. protected $m_sExtKeyToRemote;
  179. protected $m_sRelationCode;
  180. protected $m_iMaxDepth;
  181. protected $m_sTargetClass;
  182. protected $m_sTargetExtKey;
  183. // protected $m_aOrderBy;
  184. public function __construct($sLinkSetAttCode, $sExtKeyToRemote, $sRelationCode, $iMaxDepth, $sTargetClass, $sTargetLinkClass, $sTargetExtKey)
  185. {
  186. $this->m_sLinkSetAttCode = $sLinkSetAttCode;
  187. $this->m_sExtKeyToRemote = $sExtKeyToRemote;
  188. $this->m_sRelationCode = $sRelationCode;
  189. $this->m_iMaxDepth = $iMaxDepth;
  190. $this->m_sTargetClass = $sTargetClass;
  191. $this->m_sTargetLinkClass = $sTargetLinkClass;
  192. $this->m_sTargetExtKey = $sTargetExtKey;
  193. // $this->m_aOrderBy = $aOrderBy;
  194. }
  195. protected function LoadValues($aArgs)
  196. {
  197. $this->m_aValues = array();
  198. if (!array_key_exists('this', $aArgs))
  199. {
  200. throw new CoreException("Missing 'this' in arguments", array('args' => $aArgs));
  201. }
  202. $oTarget = $aArgs['this->object()'];
  203. // Nodes from which we will start the search for neighbourhood
  204. $oNodes = DBObjectSet::FromLinkSet($oTarget, $this->m_sLinkSetAttCode, $this->m_sExtKeyToRemote);
  205. // Neighbours, whatever their class
  206. $aRelated = $oNodes->GetRelatedObjects($this->m_sRelationCode, $this->m_iMaxDepth);
  207. $sRootClass = MetaModel::GetRootClass($this->m_sTargetClass);
  208. if (array_key_exists($sRootClass, $aRelated))
  209. {
  210. $aLinksToCreate = array();
  211. foreach($aRelated[$sRootClass] as $iKey => $oObject)
  212. {
  213. if (MetaModel::IsParentClass($this->m_sTargetClass, get_class($oObject)))
  214. {
  215. $oNewLink = MetaModel::NewObject($this->m_sTargetLinkClass);
  216. $oNewLink->Set($this->m_sTargetExtKey, $iKey);
  217. //$oNewLink->Set('role', 'concerned by an impacted CI');
  218. $aLinksToCreate[] = $oNewLink;
  219. }
  220. }
  221. // #@# or AddObjectArray($aObjects) ?
  222. $oSetToCreate = DBObjectSet::FromArray($this->m_sTargetLinkClass, $aLinksToCreate);
  223. $this->m_aValues[$oObject->GetKey()] = $oObject->GetName();
  224. }
  225. return true;
  226. }
  227. public function GetValuesDescription()
  228. {
  229. return 'Filter: '.$this->m_sFilterExpr;
  230. }
  231. }
  232. /**
  233. * Fixed set values (could be hardcoded in the business model)
  234. *
  235. * @package iTopORM
  236. */
  237. class ValueSetEnum extends ValueSetDefinition
  238. {
  239. protected $m_values;
  240. public function __construct($Values)
  241. {
  242. $this->m_values = $Values;
  243. }
  244. protected function LoadValues($aArgs)
  245. {
  246. if (is_array($this->m_values))
  247. {
  248. $aValues = $this->m_values;
  249. }
  250. elseif (is_string($this->m_values) && strlen($this->m_values) > 0)
  251. {
  252. $aValues = array();
  253. foreach (explode(",", $this->m_values) as $sVal)
  254. {
  255. $sVal = trim($sVal);
  256. $sKey = $sVal;
  257. $aValues[$sKey] = $sVal;
  258. }
  259. }
  260. else
  261. {
  262. $aValues = array();
  263. }
  264. $this->m_aValues = $aValues;
  265. return true;
  266. }
  267. }
  268. /**
  269. * Fixed set values, defined as a range: 0..59 (with an optional increment)
  270. *
  271. * @package iTopORM
  272. */
  273. class ValueSetRange extends ValueSetDefinition
  274. {
  275. protected $m_iStart;
  276. protected $m_iEnd;
  277. public function __construct($iStart, $iEnd, $iStep = 1)
  278. {
  279. $this->m_iStart = $iStart;
  280. $this->m_iEnd = $iEnd;
  281. $this->m_iStep = $iStep;
  282. }
  283. protected function LoadValues($aArgs)
  284. {
  285. $iValue = $this->m_iStart;
  286. for($iValue = $this->m_iStart; $iValue <= $this->m_iEnd; $iValue += $this->m_iStep)
  287. {
  288. $this->m_aValues[$iValue] = $iValue;
  289. }
  290. return true;
  291. }
  292. }
  293. /**
  294. * Data model classes
  295. *
  296. * @package iTopORM
  297. */
  298. class ValueSetEnumClasses extends ValueSetEnum
  299. {
  300. protected $m_sCategories;
  301. public function __construct($sCategories = '', $sAdditionalValues = '')
  302. {
  303. $this->m_sCategories = $sCategories;
  304. parent::__construct($sAdditionalValues);
  305. }
  306. protected function LoadValues($aArgs)
  307. {
  308. // First, get the additional values
  309. parent::LoadValues($aArgs);
  310. // Then, add the classes from the category definition
  311. foreach (MetaModel::GetClasses($this->m_sCategories) as $sClass)
  312. {
  313. $this->m_aValues[$sClass] = MetaModel::GetName($sClass);
  314. }
  315. return true;
  316. }
  317. }
  318. ?>