valuesetdef.class.inc.php 8.2 KB

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