valuesetdef.class.inc.php 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377
  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. public function GetFilterExpression()
  170. {
  171. return $this->m_sFilterExpr;
  172. }
  173. }
  174. /**
  175. * Set of existing values for a link set attribute, given a relation code
  176. *
  177. * @package iTopORM
  178. */
  179. class ValueSetRelatedObjectsFromLinkSet extends ValueSetDefinition
  180. {
  181. protected $m_sLinkSetAttCode;
  182. protected $m_sExtKeyToRemote;
  183. protected $m_sRelationCode;
  184. protected $m_iMaxDepth;
  185. protected $m_sTargetClass;
  186. protected $m_sTargetExtKey;
  187. // protected $m_aOrderBy;
  188. public function __construct($sLinkSetAttCode, $sExtKeyToRemote, $sRelationCode, $iMaxDepth, $sTargetClass, $sTargetLinkClass, $sTargetExtKey)
  189. {
  190. $this->m_sLinkSetAttCode = $sLinkSetAttCode;
  191. $this->m_sExtKeyToRemote = $sExtKeyToRemote;
  192. $this->m_sRelationCode = $sRelationCode;
  193. $this->m_iMaxDepth = $iMaxDepth;
  194. $this->m_sTargetClass = $sTargetClass;
  195. $this->m_sTargetLinkClass = $sTargetLinkClass;
  196. $this->m_sTargetExtKey = $sTargetExtKey;
  197. // $this->m_aOrderBy = $aOrderBy;
  198. }
  199. protected function LoadValues($aArgs)
  200. {
  201. $this->m_aValues = array();
  202. if (!array_key_exists('this', $aArgs))
  203. {
  204. throw new CoreException("Missing 'this' in arguments", array('args' => $aArgs));
  205. }
  206. $oTarget = $aArgs['this->object()'];
  207. // Nodes from which we will start the search for neighbourhood
  208. $oNodes = DBObjectSet::FromLinkSet($oTarget, $this->m_sLinkSetAttCode, $this->m_sExtKeyToRemote);
  209. // Neighbours, whatever their class
  210. $aRelated = $oNodes->GetRelatedObjects($this->m_sRelationCode, $this->m_iMaxDepth);
  211. $sRootClass = MetaModel::GetRootClass($this->m_sTargetClass);
  212. if (array_key_exists($sRootClass, $aRelated))
  213. {
  214. $aLinksToCreate = array();
  215. foreach($aRelated[$sRootClass] as $iKey => $oObject)
  216. {
  217. if (MetaModel::IsParentClass($this->m_sTargetClass, get_class($oObject)))
  218. {
  219. $oNewLink = MetaModel::NewObject($this->m_sTargetLinkClass);
  220. $oNewLink->Set($this->m_sTargetExtKey, $iKey);
  221. //$oNewLink->Set('role', 'concerned by an impacted CI');
  222. $aLinksToCreate[] = $oNewLink;
  223. }
  224. }
  225. // #@# or AddObjectArray($aObjects) ?
  226. $oSetToCreate = DBObjectSet::FromArray($this->m_sTargetLinkClass, $aLinksToCreate);
  227. $this->m_aValues[$oObject->GetKey()] = $oObject->GetName();
  228. }
  229. return true;
  230. }
  231. public function GetValuesDescription()
  232. {
  233. return 'Filter: '.$this->m_sFilterExpr;
  234. }
  235. }
  236. /**
  237. * Fixed set values (could be hardcoded in the business model)
  238. *
  239. * @package iTopORM
  240. */
  241. class ValueSetEnum extends ValueSetDefinition
  242. {
  243. protected $m_values;
  244. public function __construct($Values)
  245. {
  246. $this->m_values = $Values;
  247. }
  248. // Helper to export the datat model
  249. public function GetValueList()
  250. {
  251. $this->LoadValues($aArgs = array());
  252. return $this->m_aValues;
  253. }
  254. protected function LoadValues($aArgs)
  255. {
  256. if (is_array($this->m_values))
  257. {
  258. $aValues = $this->m_values;
  259. }
  260. elseif (is_string($this->m_values) && strlen($this->m_values) > 0)
  261. {
  262. $aValues = array();
  263. foreach (explode(",", $this->m_values) as $sVal)
  264. {
  265. $sVal = trim($sVal);
  266. $sKey = $sVal;
  267. $aValues[$sKey] = $sVal;
  268. }
  269. }
  270. else
  271. {
  272. $aValues = array();
  273. }
  274. $this->m_aValues = $aValues;
  275. return true;
  276. }
  277. }
  278. /**
  279. * Fixed set values, defined as a range: 0..59 (with an optional increment)
  280. *
  281. * @package iTopORM
  282. */
  283. class ValueSetRange extends ValueSetDefinition
  284. {
  285. protected $m_iStart;
  286. protected $m_iEnd;
  287. public function __construct($iStart, $iEnd, $iStep = 1)
  288. {
  289. $this->m_iStart = $iStart;
  290. $this->m_iEnd = $iEnd;
  291. $this->m_iStep = $iStep;
  292. }
  293. protected function LoadValues($aArgs)
  294. {
  295. $iValue = $this->m_iStart;
  296. for($iValue = $this->m_iStart; $iValue <= $this->m_iEnd; $iValue += $this->m_iStep)
  297. {
  298. $this->m_aValues[$iValue] = $iValue;
  299. }
  300. return true;
  301. }
  302. }
  303. /**
  304. * Data model classes
  305. *
  306. * @package iTopORM
  307. */
  308. class ValueSetEnumClasses extends ValueSetEnum
  309. {
  310. protected $m_sCategories;
  311. public function __construct($sCategories = '', $sAdditionalValues = '')
  312. {
  313. $this->m_sCategories = $sCategories;
  314. parent::__construct($sAdditionalValues);
  315. }
  316. protected function LoadValues($aArgs)
  317. {
  318. // First, get the additional values
  319. parent::LoadValues($aArgs);
  320. // Then, add the classes from the category definition
  321. foreach (MetaModel::GetClasses($this->m_sCategories) as $sClass)
  322. {
  323. $this->m_aValues[$sClass] = MetaModel::GetName($sClass);
  324. }
  325. return true;
  326. }
  327. }
  328. ?>