displayblock.class.inc.php 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928
  1. <?php
  2. require_once('../application/webpage.class.inc.php');
  3. require_once('../application/utils.inc.php');
  4. require_once('../core/userrights.class.inc.php');
  5. /**
  6. * Helper class to manage 'blocks' of HTML pieces that are parts of a page and contain some list of cmdb objects
  7. *
  8. * Each block is actually rendered as a <div></div> tag that can be rendered synchronously
  9. * or as a piece of Javascript/JQuery/Ajax that will get its content from another page (ajax.render.php).
  10. * The list of cmdbObjects to be displayed into the block is defined by a filter
  11. * Right now the type of display is either: list, count, bare_details, details, csv, modify or search
  12. * - list produces a table listing the objects
  13. * - count produces a paragraphs with a sentence saying 'cont' objects found
  14. * - bare_details displays just the details of the attributes of the object (best if only one)
  15. * - details display the full details of each object found using its template (best if only one)
  16. * - csv displays a textarea with the CSV export of the list of objects
  17. * - modify displays the form to modify an object (best if only one)
  18. * - search displays a search form with the criteria of the filter set
  19. */
  20. class DisplayBlock
  21. {
  22. const TAG_BLOCK = 'itopblock';
  23. protected $m_oFilter;
  24. protected $m_sStyle;
  25. protected $m_bAsynchronous;
  26. protected $m_aParams;
  27. protected $m_oSet;
  28. public function __construct(DBObjectSearch $oFilter, $sStyle = 'list', $bAsynchronous = false, $aParams = array(), $oSet = null)
  29. {
  30. $this->m_oFilter = $oFilter;
  31. $this->m_sStyle = $sStyle;
  32. $this->m_bAsynchronous = $bAsynchronous;
  33. $this->m_aParams = $aParams;
  34. $this->m_oSet = $oSet;
  35. }
  36. /**
  37. * Constructs a DisplayBlock object from a DBObjectSet already in memory
  38. * @param $oSet DBObjectSet
  39. * @return DisplayBlock The DisplayBlock object, or null if the creation failed
  40. */
  41. public static function FromObjectSet(DBObjectSet $oSet, $sStyle, $aParams = array())
  42. {
  43. $oDummyFilter = new DBObjectSearch($oSet->GetClass());
  44. $oBlock = new DisplayBlock($oDummyFilter, $sStyle, false, $aParams, $oSet); // DisplayBlocks built this way are synchronous
  45. return $oBlock;
  46. }
  47. /**
  48. * Constructs a DisplayBlock object from an XML template
  49. * @param $sTemplate string The XML template
  50. * @return DisplayBlock The DisplayBlock object, or null if the template is invalid
  51. */
  52. public static function FromTemplate($sTemplate)
  53. {
  54. $iStartPos = stripos($sTemplate, '<'.self::TAG_BLOCK.' ',0);
  55. $iEndPos = stripos($sTemplate, '</'.self::TAG_BLOCK.'>', $iStartPos);
  56. $iEndTag = stripos($sTemplate, '>', $iStartPos);
  57. $aParams = array();
  58. if (($iStartPos === false) || ($iEndPos === false)) return null; // invalid template
  59. $sITopBlock = substr($sTemplate,$iStartPos, $iEndPos-$iStartPos+strlen('</'.self::TAG_BLOCK.'>'));
  60. $sITopData = substr($sTemplate, 1+$iEndTag, $iEndPos - $iEndTag - 1);
  61. $sITopTag = substr($sTemplate, $iStartPos + strlen('<'.self::TAG_BLOCK), $iEndTag - $iStartPos - strlen('<'.self::TAG_BLOCK));
  62. $aMatches = array();
  63. $sBlockClass = "DisplayBlock";
  64. $bAsynchronous = false;
  65. $sBlockType = 'list';
  66. $sEncoding = 'text/serialize';
  67. if (preg_match('/ type="(.*)"/U',$sITopTag, $aMatches))
  68. {
  69. $sBlockType = strtolower($aMatches[1]);
  70. }
  71. if (preg_match('/ asynchronous="(.*)"/U',$sITopTag, $aMatches))
  72. {
  73. $bAsynchronous = (strtolower($aMatches[1]) == 'true');
  74. }
  75. if (preg_match('/ blockclass="(.*)"/U',$sITopTag, $aMatches))
  76. {
  77. $sBlockClass = $aMatches[1];
  78. }
  79. if (preg_match('/ objectclass="(.*)"/U',$sITopTag, $aMatches))
  80. {
  81. $sObjectClass = $aMatches[1];
  82. }
  83. if (preg_match('/ encoding="(.*)"/U',$sITopTag, $aMatches))
  84. {
  85. $sEncoding = strtolower($aMatches[1]);
  86. }
  87. if (preg_match('/ link_attr="(.*)"/U',$sITopTag, $aMatches))
  88. {
  89. // The list to display is a list of links to the specified object
  90. $aParams['link_attr'] = $aMatches[1]; // Name of the Ext. Key that makes this linkage
  91. }
  92. if (preg_match('/ target_attr="(.*)"/U',$sITopTag, $aMatches))
  93. {
  94. // The list to display is a list of links to the specified object
  95. $aParams['target_attr'] = $aMatches[1]; // Name of the Ext. Key that make this linkage
  96. }
  97. if (preg_match('/ object_id="(.*)"/U',$sITopTag, $aMatches))
  98. {
  99. // The list to display is a list of links to the specified object
  100. $aParams['object_id'] = $aMatches[1]; // Id of the object to be linked to
  101. }
  102. // Parameters contains a list of extra parameters for the block
  103. // the syntax is param_name1:value1;param_name2:value2;...
  104. if (preg_match('/ parameters="(.*)"/U',$sITopTag, $aMatches))
  105. {
  106. $sParameters = $aMatches[1];
  107. $aPairs = explode(';', $sParameters);
  108. foreach($aPairs as $sPair)
  109. {
  110. if (preg_match('/(.*)\:(.*)/',$sPair, $aMatches))
  111. {
  112. $aParams[trim($aMatches[1])] = trim($aMatches[2]);
  113. }
  114. }
  115. }
  116. if (!empty($aParams['link_attr']))
  117. {
  118. // Check that all mandatory parameters are present:
  119. if(empty($aParams['object_id']))
  120. {
  121. // if 'links' mode is requested the d of the object to link to must be specified
  122. throw new ApplicationException("Parameter object_id is mandatory when link_attr is specified. Check the definition of the display template.");
  123. }
  124. if(empty($aParams['target_attr']))
  125. {
  126. // if 'links' mode is requested the id of the object to link to must be specified
  127. throw new ApplicationException("Parameter target_attr is mandatory when link_attr is specified. Check the definition of the display template.");
  128. }
  129. }
  130. switch($sEncoding)
  131. {
  132. case 'text/serialize':
  133. $oFilter = CMDBSearchFilter::unserialize($sITopData);
  134. break;
  135. case 'text/sibusql':
  136. $oFilter = CMDBSearchFilter::FromSibusQL($sITopData);
  137. break;
  138. case 'text/oql':
  139. $oFilter = CMDBSearchFilter::FromOQL($sITopData);
  140. break;
  141. }
  142. return new $sBlockClass($oFilter, $sBlockType, $bAsynchronous, $aParams);
  143. }
  144. public function Display(WebPage $oPage, $sId, $aExtraParams = array())
  145. {
  146. $oPage->add($this->GetDisplay($oPage, $sId, $aExtraParams));
  147. /*
  148. $aExtraParams = array_merge($aExtraParams, $this->m_aParams);
  149. $aExtraParams['block_id'] = $sId;
  150. if (!$this->m_bAsynchronous)
  151. {
  152. // render now
  153. $oPage->add("<div id=\"$sId\" class=\"display_block\">\n");
  154. $this->RenderContent($oPage, $aExtraParams);
  155. $oPage->add("</div>\n");
  156. }
  157. else
  158. {
  159. // render it as an Ajax (asynchronous) call
  160. $sFilter = $this->m_oFilter->serialize();
  161. $oPage->add("<div id=\"$sId\" class=\"display_block loading\">\n");
  162. $oPage->p("<img src=\"../images/indicator_arrows.gif\"> Loading...");
  163. $oPage->add("</div>\n");
  164. $oPage->add('
  165. <script language="javascript">
  166. $.get("ajax.render.php?filter='.$sFilter.'&style='.$this->m_sStyle.'",
  167. { operation: "ajax" },
  168. function(data){
  169. $("#'.$sId.'").empty();
  170. $("#'.$sId.'").append(data);
  171. $("#'.$sId.'").removeClass("loading");
  172. }
  173. );
  174. </script>'); // TO DO: add support for $aExtraParams in asynchronous/Ajax mode
  175. }
  176. */
  177. }
  178. public function GetDisplay(WebPage $oPage, $sId, $aExtraParams = array())
  179. {
  180. $sHtml = '';
  181. $aExtraParams = array_merge($aExtraParams, $this->m_aParams);
  182. $aExtraParams['block_id'] = $sId;
  183. $sExtraParams = addslashes(str_replace('"', "'", json_encode($aExtraParams))); // JSON encode, change the style of the quotes and escape them
  184. $bAutoReload = false;
  185. if (isset($aExtraParams['auto_reload']))
  186. {
  187. switch($aExtraParams['auto_reload'])
  188. {
  189. case 'fast':
  190. $bAutoReload = true;
  191. $iReloadInterval = utils::GetConfig()->GetFastReloadInterval()*1000;
  192. break;
  193. case 'standard':
  194. case 'true':
  195. case true:
  196. $bAutoReload = true;
  197. $iReloadInterval = utils::GetConfig()->GetStandardReloadInterval()*1000;
  198. break;
  199. default:
  200. if (is_numeric($aExtraParams['auto_reload']))
  201. {
  202. $bAutoReload = true;
  203. $iReloadInterval = $aExtraParams['auto_reload']*1000;
  204. }
  205. else
  206. {
  207. // incorrect config, ignore it
  208. $bAutoReload = false;
  209. }
  210. }
  211. }
  212. $sFilter = $this->m_oFilter->serialize(); // Used either for asynchronous or auto_reload
  213. if (!$this->m_bAsynchronous)
  214. {
  215. // render now
  216. $sHtml .= "<div id=\"$sId\" class=\"display_block\">\n";
  217. $sHtml .= $this->GetRenderContent($oPage, $aExtraParams);
  218. $sHtml .= "</div>\n";
  219. }
  220. else
  221. {
  222. // render it as an Ajax (asynchronous) call
  223. $sHtml .= "<div id=\"$sId\" class=\"display_block loading\">\n";
  224. $sHtml .= $oPage->GetP("<img src=\"../images/indicator_arrows.gif\"> Loading...");
  225. $sHtml .= "</div>\n";
  226. $sHtml .= '
  227. <script language="javascript">
  228. $.get("ajax.render.php?filter='.$sFilter.'&style='.$this->m_sStyle.'",
  229. { operation: "ajax", extra_params: "'.$sExtraParams.'" },
  230. function(data){
  231. $("#'.$sId.'").empty();
  232. $("#'.$sId.'").append(data);
  233. $("#'.$sId.'").removeClass("loading");
  234. $("#'.$sId.' .listResults").tablesorter( { headers: { 0:{sorter: false }}, widgets: [\'zebra\']} ); // sortable and zebra tables
  235. }
  236. );
  237. </script>';
  238. }
  239. if ($bAutoReload)
  240. {
  241. $sHtml .= '
  242. <script language="javascript">
  243. setInterval("ReloadBlock(\''.$sId.'\', \''.$this->m_sStyle.'\', \''.$sFilter.'\', \"'.$sExtraParams.'\")", '.$iReloadInterval.');
  244. </script>';
  245. }
  246. return $sHtml;
  247. }
  248. public function RenderContent(WebPage $oPage, $aExtraParams = array())
  249. {
  250. $oPage->add($this->GetRenderContent($oPage, $aExtraParams));
  251. }
  252. public function GetRenderContent(WebPage $oPage, $aExtraParams = array())
  253. {
  254. $sHtml = '';
  255. // Add the extra params into the filter if they make sense for such a filter
  256. $bDoSearch = utils::ReadParam('dosearch', false);
  257. if ($this->m_oSet == null)
  258. {
  259. if ($this->m_sStyle != 'links')
  260. {
  261. $aFilterCodes = array_keys(MetaModel::GetClassFilterDefs($this->m_oFilter->GetClass()));
  262. foreach($aFilterCodes as $sFilterCode)
  263. {
  264. $sExternalFilterValue = utils::ReadParam($sFilterCode, '');
  265. if (isset($aExtraParams[$sFilterCode]))
  266. {
  267. $this->m_oFilter->AddCondition($sFilterCode, $aExtraParams[$sFilterCode]); // Use the default 'loose' operator
  268. }
  269. else if ($bDoSearch && $sExternalFilterValue != "")
  270. {
  271. $this->m_oFilter->AddCondition($sFilterCode, $sExternalFilterValue); // Use the default 'loose' operator
  272. }
  273. }
  274. }
  275. $this->m_oSet = new CMDBObjectSet($this->m_oFilter);
  276. }
  277. switch($this->m_sStyle)
  278. {
  279. case 'count':
  280. if (isset($aExtraParams['group_by']))
  281. {
  282. $sGroupByField = $aExtraParams['group_by'];
  283. $aGroupBy = array();
  284. $sLabels = array();
  285. while($oObj = $this->m_oSet->Fetch())
  286. {
  287. $sValue = $oObj->Get($sGroupByField);
  288. $aGroupBy[$sValue] = isset($aGroupBy[$sValue]) ? $aGroupBy[$sValue]+1 : 1;
  289. $sLabels[$sValue] = $oObj->GetAsHtml($sGroupByField);
  290. }
  291. $sFilter = urlencode($this->m_oFilter->serialize());
  292. $aData = array();
  293. $oAppContext = new ApplicationContext();
  294. $sParams = $oAppContext->GetForLink();
  295. foreach($aGroupBy as $sValue => $iCount)
  296. {
  297. $aData[] = array ( 'group' => $sLabels[$sValue],
  298. 'value' => "<a href=\"./UI.php?operation=search&dosearch=1&$sParams&filter=$sFilter&$sGroupByField=".urlencode($sValue)."\">$iCount</a>"); // TO DO: add the context information
  299. }
  300. $sHtml .= $oPage->GetTable(array('group' => array('label' => MetaModel::GetLabel($this->m_oFilter->GetClass(), $sGroupByField), 'description' => ''), 'value' => array('label'=>'Count', 'description' => 'Number of elements')), $aData);
  301. }
  302. else
  303. {
  304. // Simply count the number of elements in the set
  305. $iCount = $oSet->Count();
  306. $sHtml .= $oPage->GetP("$iCount objects matching the criteria.");
  307. }
  308. break;
  309. case 'join':
  310. if (!isset($aExtraParams['oql2']))
  311. {
  312. $sHtml .= $oPage->GetP("parameter oql2 is mandatory.");
  313. }
  314. else
  315. {
  316. $sOql2 = $aExtraParams['oql2'];
  317. $sGroupByField = $aExtraParams['group_by'];
  318. $aExtraParams['menu'] = false;
  319. $oFilter1 = CMDBSearchFilter::FromOQL($sOql2);
  320. $oSet1 = new CMDBObjectSet($oFilter1);
  321. if (!isset($aExtraParams['group_by']))
  322. {
  323. // No "group by" specified, use the name of the second class
  324. $sGroupByField = MetaModel::GetNameAttributeCode($oFilter1->GetClass());
  325. }
  326. $aResults = array();
  327. while($oObj = $oSet1->Fetch())
  328. {
  329. $aResult[$oObj->Get($sGroupByField)] = array();
  330. $oSet2 = new CMDBObjectSet($this->m_oFilter, array(), array('oql2' => $oObj->GetKey()));
  331. while($oObj2 = $oSet2->Fetch())
  332. {
  333. $aResults[$oObj->Get($sGroupByField)][$oObj2->GetKey()] = $oObj2;
  334. }
  335. }
  336. $sHtml .= "<table>\n";
  337. foreach($aResults as $sCategory => $aObjects)
  338. {
  339. $sHtml .= "<tr><td><h1>$sCategory</h1></td></tr>\n";
  340. $oSet = CMDBObjectSet::FromArray($this->m_oFilter->GetClass(), $aObjects);
  341. $sHtml .= "<tr><td>".cmdbAbstractObject::GetDisplaySet($oPage, $oSet, $aExtraParams)."</td></tr>\n";
  342. }
  343. $sHtml .= "</table>\n";
  344. }
  345. break;
  346. case 'list':
  347. $aClasses = $this->m_oSet->GetSelectedClasses();
  348. $aAuthorizedClasses = array();
  349. if (count($aClasses) > 1)
  350. {
  351. // Check the classes that can be read (i.e authorized) by this user...
  352. foreach($aClasses as $sAlias => $sClassName)
  353. {
  354. if (UserRights::IsActionAllowed($sClassName, UR_ACTION_READ, $this->m_oSet) == UR_ALLOWED_YES)
  355. {
  356. $aAuthorizedClasses[$sAlias] = $sClassName;
  357. }
  358. }
  359. if (count($aAuthorizedClasses) > 0)
  360. {
  361. if($this->m_oSet->Count() > 0)
  362. {
  363. $sHtml .= cmdbAbstractObject::GetDisplayExtendedSet($oPage, $this->m_oSet, $aExtraParams);
  364. }
  365. else
  366. {
  367. // Empty set
  368. $sHtml .= $oPage->GetP("No object to display.");
  369. }
  370. }
  371. else
  372. {
  373. // Not authorized
  374. $sHtml .= $oPage->GetP("No object to display.");
  375. }
  376. }
  377. else
  378. {
  379. // The list is made of only 1 class of objects, actions on the list are possible
  380. if ( ($this->m_oSet->Count()> 0) && (UserRights::IsActionAllowed($this->m_oSet->GetClass(), UR_ACTION_READ, $this->m_oSet) == UR_ALLOWED_YES) )
  381. {
  382. $sHtml .= cmdbAbstractObject::GetDisplaySet($oPage, $this->m_oSet, $aExtraParams);
  383. }
  384. else
  385. {
  386. $sHtml .= $oPage->GetP("No object to display.");
  387. $sClass = $this->m_oFilter->GetClass();
  388. $bDisplayMenu = isset($aExtraParams['menu']) ? $aExtraParams['menu'] == true : true;
  389. if ($bDisplayMenu)
  390. {
  391. if (UserRights::IsActionAllowed($sClass, UR_ACTION_MODIFY) == UR_ALLOWED_YES)
  392. {
  393. $oAppContext = new ApplicationContext();
  394. $sParams = $oAppContext->GetForLink();
  395. // 1:n links, populate the target object as a default value when creating a new linked object
  396. if (isset($aExtraParams['target_attr']))
  397. {
  398. $aExtraParams['default'][$aExtraParams['target_attr']] = $aExtraParams['object_id'];
  399. }
  400. $sDefault = '';
  401. if (!empty($aExtraParams['default']))
  402. {
  403. foreach($aExtraParams['default'] as $sKey => $sValue)
  404. {
  405. $sDefault.= "&default[$sKey]=$sValue";
  406. }
  407. }
  408. $sHtml .= $oPage->GetP("<a href=\"./UI.php?operation=new&class=$sClass&$sParams{$sDefault}\">Click here to create a new ".Metamodel::GetName($sClass)."</a>\n");
  409. }
  410. }
  411. }
  412. }
  413. break;
  414. case 'links':
  415. //$bDashboardMode = isset($aExtraParams['dashboard']) ? ($aExtraParams['dashboard'] == 'true') : false;
  416. //$bSelectMode = isset($aExtraParams['select']) ? ($aExtraParams['select'] == 'true') : false;
  417. if ( ($this->m_oSet->Count()> 0) && (UserRights::IsActionAllowed($this->m_oSet->GetClass(), UR_ACTION_READ, $this->m_oSet) == UR_ALLOWED_YES) )
  418. {
  419. //$sLinkage = isset($aExtraParams['linkage']) ? $aExtraParams['linkage'] : '';
  420. $sHtml .= cmdbAbstractObject::GetDisplaySet($oPage, $this->m_oSet, $aExtraParams);
  421. }
  422. else
  423. {
  424. $sClass = $this->m_oFilter->GetClass();
  425. $oAttDef = MetaModel::GetAttributeDef($sClass, $this->m_aParams['target_attr']);
  426. $sTargetClass = $oAttDef->GetTargetClass();
  427. $sHtml .= $oPage->GetP("No ".MetaModel::GetName($sTargetClass)." to display.");
  428. $bDisplayMenu = isset($this->m_aParams['menu']) ? $this->m_aParams['menu'] == true : true;
  429. if ($bDisplayMenu)
  430. {
  431. if (UserRights::IsActionAllowed($sClass, UR_ACTION_MODIFY) == UR_ALLOWED_YES)
  432. {
  433. $oAppContext = new ApplicationContext();
  434. $sParams = $oAppContext->GetForLink();
  435. $sHtml .= $oPage->GetP("<a href=\"../pages/UI.php?operation=modify_links&class=$sClass&sParams&link_attr=".$aExtraParams['link_attr']."&id=".$aExtraParams['object_id']."&target_class=$sTargetClass&addObjects=true\">Click here to add new ".Metamodel::GetName($sTargetClass)."s</a>\n");
  436. }
  437. }
  438. }
  439. break;
  440. case 'details':
  441. if (UserRights::IsActionAllowed($this->m_oSet->GetClass(), UR_ACTION_READ, $this->m_oSet) == UR_ALLOWED_YES)
  442. {
  443. while($oObj = $this->m_oSet->Fetch())
  444. {
  445. $sHtml .= $oObj->GetDetails($oPage); // Still used ???
  446. }
  447. }
  448. break;
  449. case 'bare_details':
  450. if (UserRights::IsActionAllowed($this->m_oSet->GetClass(), UR_ACTION_READ, $this->m_oSet) == UR_ALLOWED_YES)
  451. {
  452. while($oObj = $this->m_oSet->Fetch())
  453. {
  454. $sHtml .= $oObj->GetBareDetails($oPage);
  455. }
  456. }
  457. break;
  458. case 'csv':
  459. if (UserRights::IsActionAllowed($this->m_oSet->GetClass(), UR_ACTION_READ, $this->m_oSet) == UR_ALLOWED_YES)
  460. {
  461. $sHtml .= "<textarea style=\"width:95%;height:98%\">\n";
  462. $sHtml .= cmdbAbstractObject::GetSetAsCSV($this->m_oSet);
  463. $sHtml .= "</textarea>\n";
  464. }
  465. break;
  466. case 'modify':
  467. if (UserRights::IsActionAllowed($this->m_oSet->GetClass(), UR_ACTION_MODIFY, $this->m_oSet) == UR_ALLOWED_YES)
  468. {
  469. while($oObj = $this->m_oSet->Fetch())
  470. {
  471. $sHtml .= $oObj->GetModifyForm($oPage);
  472. }
  473. }
  474. break;
  475. case 'search':
  476. $iSearchSectionId = 1;
  477. $sStyle = (isset($aExtraParams['open']) && ($aExtraParams['open'] == 'true')) ? 'SearchDrawer' : 'SearchDrawer DrawerClosed';
  478. $sHtml .= "<div id=\"Search_$iSearchSectionId\" class=\"$sStyle\">\n";
  479. $oPage->add_ready_script("\$(\"#LnkSearch_$iSearchSectionId\").click(function() {\$(\"#Search_$iSearchSectionId\").slideToggle('normal'); $(\"#LnkSearch_$iSearchSectionId\").toggleClass('open');});");
  480. $sHtml .= cmdbAbstractObject::GetSearchForm($oPage, $this->m_oSet, $aExtraParams);
  481. $sHtml .= "</div>\n";
  482. $sHtml .= "<div class=\"HRDrawer\"></div>\n";
  483. $sHtml .= "<div id=\"LnkSearch_$iSearchSectionId\" class=\"DrawerHandle\">Search</div>\n";
  484. break;
  485. case 'pie_chart':
  486. $sGroupBy = isset($aExtraParams['group_by']) ? $aExtraParams['group_by'] : '';
  487. $sFilter = $this->m_oFilter->ToOQL();
  488. $sHtml .= "
  489. <OBJECT classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"
  490. codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0\"
  491. WIDTH=\"400\"
  492. HEIGHT=\"250\"
  493. id=\"charts\"
  494. ALIGN=\"\">
  495. <PARAM NAME=movie VALUE=\"../images/charts.swf?library_path=../images/charts_library&xml_source=".urlencode("../pages/ajax.render.php?operation=pie_chart&group_by=$sGroupBy&encoding=oql&filter=".urlencode($sFilter))."\">
  496. <PARAM NAME=\"quality\" VALUE=\"high\">
  497. <PARAM NAME=\"bgcolor\" VALUE=\"#ffffff\">
  498. <EMBED src=\"../images/charts.swf?library_path=../images/charts_library&xml_source=".urlencode("../pages/ajax.render.php?operation=pie_chart&group_by=$sGroupBy&encoding=oql&filter=".urlencode($sFilter))."\"
  499. quality=\"high\"
  500. bgcolor=\"#ffffff\"
  501. WIDTH=\"400\"
  502. HEIGHT=\"250\"
  503. NAME=\"charts\"
  504. ALIGN=\"\"
  505. swLiveConnect=\"true\"
  506. TYPE=\"application/x-shockwave-flash\"
  507. PLUGINSPAGE=\"http://www.macromedia.com/go/getflashplayer\">
  508. </EMBED>
  509. </OBJECT>
  510. ";
  511. break;
  512. case 'pie_chart_ajax':
  513. if (isset($aExtraParams['group_by']))
  514. {
  515. $sGroupByField = $aExtraParams['group_by'];
  516. $aGroupBy = array();
  517. while($oObj = $this->m_oSet->Fetch())
  518. {
  519. $sValue = $oObj->Get($sGroupByField);
  520. $aGroupBy[$sValue] = isset($aGroupBy[$sValue]) ? $aGroupBy[$sValue]+1 : 1;
  521. }
  522. $sFilter = urlencode($this->m_oFilter->serialize());
  523. $aData = array();
  524. $sHtml .= "<chart>\n";
  525. $sHtml .= "<chart_type>3d pie</chart_type>\n";
  526. $sHtml .= "<chart_data>\n";
  527. $sHtml .= "<row>\n";
  528. $sHtml .= "<null/>\n";
  529. foreach($aGroupBy as $sValue => $void)
  530. {
  531. $sHtml .= "<string>$sValue</string>\n";
  532. }
  533. $sHtml .= "</row>\n";
  534. $sHtml .= "<row>\n";
  535. $sHtml .= "<string></string>\n";
  536. foreach($aGroupBy as $void => $iCount)
  537. {
  538. $sHtml .= "<number>$iCount</number>\n";
  539. }
  540. $sHtml .= "</row>\n";
  541. $sHtml .= "</chart_data>\n";
  542. $sHtml .= "
  543. <chart_value color='ffffff' alpha='90' font='arial' bold='true' size='10' position='inside' prefix='' suffix='' decimals='0' separator='' as_percentage='true' />
  544. <draw>
  545. <text color='000000' alpha='10' font='arial' rotation='0' bold='true' size='30' x='0' y='140' width='400' height='150' h_align='center' v_align='bottom'>|||||||||||||||||||||||||||||||||||||||||||||||</text>
  546. </draw>
  547. <legend_label layout='horizontal' bullet='circle' font='arial' bold='true' size='13' color='000000' alpha='85' />
  548. <legend_rect fill_color='ffffff' fill_alpha='10' line_color='ffffff' line_alpha='50' line_thickness='0' />
  549. <series_color>
  550. <color>ddaa41</color>
  551. <color>88dd11</color>
  552. <color>4e62dd</color>
  553. <color>ff8811</color>
  554. <color>4d4d4d</color>
  555. <color>5a4b6e</color>
  556. <color>1188ff</color>
  557. </series_color>
  558. ";
  559. $sHtml .= "</chart>\n";
  560. }
  561. else
  562. {
  563. // Simply count the number of elements in the set
  564. $iCount = $oSet->Count();
  565. $sHtml .= "<chart>\n</chart>\n";
  566. }
  567. break;
  568. case 'open_flash_chart':
  569. static $iChartCounter = 0;
  570. $sChartType = isset($aExtraParams['chart_type']) ? $aExtraParams['chart_type'] : 'pie';
  571. $sTitle = isset($aExtraParams['chart_title']) ? $aExtraParams['chart_title'] : '';
  572. $sGroupBy = isset($aExtraParams['group_by']) ? $aExtraParams['group_by'] : '';
  573. $sFilter = $this->m_oFilter->ToOQL();
  574. $sHtml .= "<script>
  575. swfobject.embedSWF(\"../images/open-flash-chart.swf\", \"my_chart_{$iChartCounter}\", \"400\", \"400\",\"9.0.0\", \"expressInstall.swf\",
  576. {\"data-file\":\"".urlencode("../pages/ajax.render.php?operation=open_flash_chart&params[group_by]=$sGroupBy&params[chart_type]=$sChartType&params[chart_title]=$sTitle&encoding=oql&filter=".urlencode($sFilter))."\"});
  577. </script>\n";
  578. $sHtml .= "<div id=\"my_chart_{$iChartCounter}\">If the chart does not display, <a href=\"http://get.adobe.com/flash/\" target=\"_blank\">install Flash</a></div>\n";
  579. $iChartCounter++;
  580. break;
  581. case 'open_flash_chart_ajax':
  582. include './php-ofc-library/open-flash-chart.php';
  583. $sChartType = isset($aExtraParams['chart_type']) ? $aExtraParams['chart_type'] : 'pie';
  584. $oChart = new open_flash_chart();
  585. switch($sChartType)
  586. {
  587. case 'bars':
  588. $oChartElement = new bar_glass();
  589. if (isset($aExtraParams['group_by']))
  590. {
  591. $sGroupByField = $aExtraParams['group_by'];
  592. $aGroupBy = array();
  593. while($oObj = $this->m_oSet->Fetch())
  594. {
  595. $sValue = $oObj->Get($sGroupByField);
  596. $aGroupBy[$sValue] = isset($aGroupBy[$sValue]) ? $aGroupBy[$sValue]+1 : 1;
  597. }
  598. $sFilter = urlencode($this->m_oFilter->serialize());
  599. $aData = array();
  600. $aLabels = array();
  601. foreach($aGroupBy as $sValue => $iValue)
  602. {
  603. $aData[] = $iValue;
  604. $aLabels[] = $sValue;
  605. }
  606. $maxValue = max($aData);
  607. $oYAxis = new y_axis();
  608. $aMagicValues = array(1,2,5,10);
  609. $iMultiplier = 1;
  610. $index = 0;
  611. $iTop = $aMagicValues[$index % count($aMagicValues)]*$iMultiplier;
  612. while($maxValue > $iTop)
  613. {
  614. $index++;
  615. $iTop = $aMagicValues[$index % count($aMagicValues)]*$iMultiplier;
  616. if (($index % count($aMagicValues)) == 0)
  617. {
  618. $iMultiplier = $iMultiplier * 10;
  619. }
  620. }
  621. //echo "oYAxis->set_range(0, $iTop, $iMultiplier);\n";
  622. $oYAxis->set_range(0, $iTop, $iMultiplier);
  623. $oChart->set_y_axis( $oYAxis );
  624. $oChartElement->set_values( $aData );
  625. $oXAxis = new x_axis();
  626. $oXLabels = new x_axis_labels();
  627. // set them vertical
  628. $oXLabels->set_vertical();
  629. // set the label text
  630. $oXLabels->set_labels($aLabels);
  631. // Add the X Axis Labels to the X Axis
  632. $oXAxis->set_labels( $oXLabels );
  633. $oChart->set_x_axis( $oXAxis );
  634. }
  635. break;
  636. case 'pie':
  637. default:
  638. $oChartElement = new pie();
  639. $oChartElement->set_start_angle( 35 );
  640. $oChartElement->set_animate( true );
  641. $oChartElement->set_tooltip( '#label# - #val# (#percent#)' );
  642. if (isset($aExtraParams['group_by']))
  643. {
  644. $sGroupByField = $aExtraParams['group_by'];
  645. $aGroupBy = array();
  646. while($oObj = $this->m_oSet->Fetch())
  647. {
  648. $sValue = $oObj->Get($sGroupByField);
  649. $aGroupBy[$sValue] = isset($aGroupBy[$sValue]) ? $aGroupBy[$sValue]+1 : 1;
  650. }
  651. $sFilter = urlencode($this->m_oFilter->serialize());
  652. $aData = array();
  653. foreach($aGroupBy as $sValue => $iValue)
  654. {
  655. $aData[] = new pie_value($iValue, $sValue);
  656. }
  657. $oChartElement->set_values( $aData );
  658. $oChart->x_axis = null;
  659. }
  660. }
  661. if (isset($aExtraParams['chart_title'])) //@@ BUG: not passed via ajax !!!
  662. {
  663. $oTitle = new title( $aExtraParams['chart_title'] );
  664. $oChart->set_title( $oTitle );
  665. }
  666. $oChart->set_bg_colour('#FFFFFF');
  667. $oChart->add_element( $oChartElement );
  668. $sHtml = $oChart->toPrettyString();
  669. break;
  670. default:
  671. // Unsupported style, do nothing.
  672. $sHtml .= "Error: unsupported style of block: ".$this->m_sStyle;
  673. }
  674. return $sHtml;
  675. }
  676. }
  677. /**
  678. * Helper class to manage 'blocks' of HTML pieces that are parts of a page and contain some list of cmdb objects
  679. *
  680. * Each block is actually rendered as a <div></div> tag that can be rendered synchronously
  681. * or as a piece of Javascript/JQuery/Ajax that will get its content from another page (ajax.render.php).
  682. * The list of cmdbObjects to be displayed into the block is defined by a filter
  683. * Right now the type of display is either: list, count or details
  684. * - list produces a table listing the objects
  685. * - count produces a paragraphs with a sentence saying 'cont' objects found
  686. * - details display (as table) the details of each object found (best if only one)
  687. */
  688. class HistoryBlock extends DisplayBlock
  689. {
  690. public function GetRenderContent(WebPage $oPage, $aExtraParams = array())
  691. {
  692. $sHtml = '';
  693. // Add the extra params into the filter if they make sense for such a filter
  694. $aFilterCodes = array_keys(MetaModel::GetClassFilterDefs($this->m_oFilter->GetClass()));
  695. foreach($aFilterCodes as $sFilterCode)
  696. {
  697. if (isset($aExtraParams[$sFilterCode]))
  698. {
  699. $this->m_oFilter->AddCondition($sFilterCode, $aExtraParams[$sFilterCode]); // Use the default 'loose' operator
  700. }
  701. }
  702. $oSet = new CMDBObjectSet($this->m_oFilter, array('date'=>false));
  703. $sHtml .= "<!-- filter: ".($this->m_oFilter->ToOQL())."-->\n";
  704. switch($this->m_sStyle)
  705. {
  706. case 'toggle':
  707. // First the latest change that the user is allowed to see
  708. do
  709. {
  710. $oLatestChangeOp = $oSet->Fetch();
  711. }
  712. while(is_object($oLatestChangeOp) && ($oLatestChangeOp->GetDescription() == ''));
  713. if (is_object($oLatestChangeOp))
  714. {
  715. global $oContext; // User Context.. should be statis instead of global...
  716. // There is one change in the list... only when the object has been created !
  717. $sDate = $oLatestChangeOp->GetAsHTML('date');
  718. $oChange = $oContext->GetObject('CMDBChange', $oLatestChangeOp->Get('change'));
  719. $sUserInfo = $oChange->GetAsHTML('userinfo');
  720. $oSet->Rewind(); // Reset the pointer to the beginning of the set
  721. $sHtml .= $oPage->GetStartCollapsibleSection("Last modified on $sDate by $sUserInfo.");
  722. //$sHtml .= cmdbAbstractObject::GetDisplaySet($oPage, $oSet);
  723. $aChanges = array();
  724. while($oChangeOp = $oSet->Fetch())
  725. {
  726. $sChangeDescription = $oChangeOp->GetDescription();
  727. if ($sChangeDescription != '')
  728. {
  729. // The change is visible for the current user
  730. $changeId = $oChangeOp->Get('change');
  731. $aChanges[$changeId]['date'] = $oChangeOp->Get('date');
  732. $aChanges[$changeId]['userinfo'] = $oChangeOp->Get('userinfo');
  733. if (!isset($aChanges[$changeId]['log']))
  734. {
  735. $aChanges[$changeId]['log'] = array();
  736. }
  737. $aChanges[$changeId]['log'][] = $sChangeDescription;
  738. }
  739. }
  740. $aAttribs = array('date' => array('label' => 'Date', 'description' => 'Date of the change'),
  741. 'userinfo' => array('label' => 'User', 'description' => 'User who made the change'),
  742. 'log' => array('label' => 'Changes', 'description' => 'Changes made to the object'),
  743. );
  744. $aValues = array();
  745. foreach($aChanges as $aChange)
  746. {
  747. $aValues[] = array('date' => $aChange['date'], 'userinfo' => $aChange['userinfo'], 'log' => "<ul><li>".implode('</li><li>', $aChange['log'])."</li></ul>");
  748. }
  749. $sHtml .= $oPage->GetTable($aAttribs, $aValues);
  750. $sHtml .= $oPage->GetEndCollapsibleSection();
  751. }
  752. break;
  753. default:
  754. $sHtml .= parent::GetRenderContent($oPage, $aExtraParams);
  755. }
  756. return $sHtml;
  757. }
  758. }
  759. class MenuBlock extends DisplayBlock
  760. {
  761. public function GetRenderContent(WebPage $oPage, $aExtraParams = array())
  762. {
  763. $sHtml = '';
  764. $oAppContext = new ApplicationContext();
  765. $sContext = $oAppContext->GetForLink();
  766. $sClass = $this->m_oFilter->GetClass();
  767. $oSet = new CMDBObjectSet($this->m_oFilter);
  768. $sFilter = $this->m_oFilter->serialize();
  769. $aActions = array();
  770. $sUIPage = cmdbAbstractObject::ComputeUIPage($sClass);
  771. // 1:n links, populate the target object as a default value when creating a new linked object
  772. if (isset($aExtraParams['target_attr']))
  773. {
  774. $aExtraParams['default'][$aExtraParams['target_attr']] = $aExtraParams['object_id'];
  775. }
  776. $sDefault = '';
  777. if (!empty($aExtraParams['default']))
  778. {
  779. foreach($aExtraParams['default'] as $sKey => $sValue)
  780. {
  781. $sDefault.= "&default[$sKey]=$sValue";
  782. }
  783. }
  784. switch($oSet->Count())
  785. {
  786. case 0:
  787. // No object in the set, the only possible action is "new"
  788. $bIsModifyAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_MODIFY);
  789. if ($bIsModifyAllowed) { $aActions[] = array ('label' => 'New', 'url' => "../page/$sUIPage?operation=new&class=$sClass&$sContext{$sDefault}"); }
  790. break;
  791. case 1:
  792. $oObj = $oSet->Fetch();
  793. $id = $oObj->GetKey();
  794. $bIsModifyAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_MODIFY, $oSet);
  795. $bIsDeleteAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_DELETE, $oSet);
  796. $bIsBulkModifyAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_BULK_MODIFY, $oSet);
  797. $bIsBulkDeleteAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_BULK_DELETE, $oSet);
  798. // Just one object in the set, possible actions are "new / clone / modify and delete"
  799. if (isset($aExtraParams['link_attr']))
  800. {
  801. $id = $aExtraParams['object_id'];
  802. $sTargetAttr = $aExtraParams['target_attr'];
  803. $oAttDef = MetaModel::GetAttributeDef($sClass, $sTargetAttr);
  804. $sTargetClass = $oAttDef->GetTargetClass();
  805. if ($bIsModifyAllowed) { $aActions[] = array ('label' => 'Add...', 'url' => "../pages/$sUIPage?operation=modify_links&class=$sClass&link_attr=".$aExtraParams['link_attr']."&target_class=$sTargetClass&id=$id&addObjects=true&$sContext"); }
  806. if ($bIsModifyAllowed) { $aActions[] = array ('label' => 'Manage...', 'url' => "../pages/$sUIPage?operation=modify_links&class=$sClass&link_attr=".$aExtraParams['link_attr']."&target_class=$sTargetClass&id=$id&sContext"); }
  807. //if ($bIsDeleteAllowed) { $aActions[] = array ('label' => 'Remove All', 'url' => "#"); }
  808. }
  809. else
  810. {
  811. $sUrl = utils::GetAbsoluteUrl();
  812. $aActions[] = array ('label' => 'eMail', 'url' => "mailto:?subject=".$oSet->GetFilter()->__DescribeHTML()."&body=".urlencode("$sUrl?operation=search&filter=$sFilter&$sContext"));
  813. $aActions[] = array ('label' => 'CSV Export', 'url' => "../pages/$sUIPage?operation=search&filter=$sFilter&format=csv&$sContext");
  814. //$aActions[] = array ('label' => 'Bookmark...', 'url' => "../pages/ajax.render.php?operation=create&class=$sClass&filter=$sFilter", 'class' => 'jqmTrigger');
  815. if ($bIsModifyAllowed) { $aActions[] = array ('label' => 'New...', 'url' => "../pages/$sUIPage?operation=new&class=$sClass&$sContext{$sDefault}"); }
  816. //if ($bIsModifyAllowed) { $aActions[] = array ('label' => 'Clone...', 'url' => "../pages/$sUIPage?operation=clone&class=$sClass&id=$id&$sContext"); }
  817. if ($bIsModifyAllowed) { $aActions[] = array ('label' => 'Modify...', 'url' => "../pages/$sUIPage?operation=modify&class=$sClass&id=$id&$sContext"); }
  818. if ($bIsDeleteAllowed) { $aActions[] = array ('label' => 'Delete...', 'url' => "../pages/$sUIPage?operation=delete&class=$sClass&id=$id&$sContext"); }
  819. }
  820. $aTransitions = $oObj->EnumTransitions();
  821. $aStimuli = Metamodel::EnumStimuli($sClass);
  822. foreach($aTransitions as $sStimulusCode => $aTransitionDef)
  823. {
  824. $iActionAllowed = UserRights::IsStimulusAllowed($sClass, $sStimulusCode, $oSet);
  825. switch($iActionAllowed)
  826. {
  827. case UR_ALLOWED_YES:
  828. $aActions[] = array('label' => $aStimuli[$sStimulusCode]->Get('label'), 'url' => "../pages/UI.php?operation=stimulus&stimulus=$sStimulusCode&class=$sClass&id=$id&$sContext");
  829. break;
  830. case UR_ALLOWED_DEPENDS:
  831. $aActions[] = array('label' => $aStimuli[$sStimulusCode]->Get('label').' (*)', 'url' => "../pages/UI.php?operation=stimulus&stimulus=$sStimulusCode&class=$sClass&id=$id&$sContext");
  832. break;
  833. default:
  834. // Do nothing
  835. }
  836. }
  837. //print_r($aTransitions);
  838. break;
  839. default:
  840. // Check rights
  841. // New / Modify
  842. $bIsModifyAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_MODIFY, $oSet);
  843. $bIsBulkModifyAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_BULK_MODIFY, $oSet);
  844. $bIsBulkDeleteAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_BULK_DELETE, $oSet);
  845. if (isset($aExtraParams['link_attr']))
  846. {
  847. $id = $aExtraParams['object_id'];
  848. $sTargetAttr = $aExtraParams['target_attr'];
  849. $oAttDef = MetaModel::GetAttributeDef($sClass, $sTargetAttr);
  850. $sTargetClass = $oAttDef->GetTargetClass();
  851. $bIsDeleteAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_DELETE, $oSet);
  852. if ($bIsModifyAllowed) { $aActions[] = array ('label' => 'Add...', 'url' => "../pages/$sUIPage?operation=modify_links&class=$sClass&link_attr=".$aExtraParams['link_attr']."&target_class=$sTargetClass&id=$id&addObjects=true&$sContext"); }
  853. //if ($bIsBulkModifyAllowed) { $aActions[] = array ('label' => 'Add...', 'url' => "../pages/$sUIPage?operation=modify_links&class=$sClass&linkage=".$aExtraParams['linkage']."&id=$id&addObjects=true&$sContext"); }
  854. if ($bIsBulkModifyAllowed) { $aActions[] = array ('label' => 'Manage...', 'url' => "../pages/$sUIPage?operation=modify_links&class=$sClass&link_attr=".$aExtraParams['link_attr']."&target_class=$sTargetClass&id=$id&sContext"); }
  855. //if ($bIsBulkDeleteAllowed) { $aActions[] = array ('label' => 'Remove All...', 'url' => "#"); }
  856. }
  857. else
  858. {
  859. // many objects in the set, possible actions are: new / modify all / delete all
  860. $sUrl = utils::GetAbsoluteUrl();
  861. $aActions[] = array ('label' => 'eMail', 'url' => "mailto:?subject=".$oSet->GetFilter()->__DescribeHTML()."&body=".urlencode("$sUrl?operation=search&filter=$sFilter&$sContext"));
  862. $aActions[] = array ('label' => 'CSV Export', 'url' => "../pages/$sUIPage?operation=search&filter=$sFilter&format=csv&$sContext");
  863. //$aActions[] = array ('label' => 'Bookmark...', 'url' => "../pages/ajax.render.php?operation=create&class=$sClass&filter=$sFilter", 'class' => 'jqmTrigger');
  864. if ($bIsModifyAllowed) { $aActions[] = array ('label' => 'New...', 'url' => "../pages/$sUIPage?operation=new&class=$sClass&$sContext{$sDefault}"); }
  865. //if ($bIsBulkModifyAllowed) { $aActions[] = array ('label' => 'Modify All...', 'url' => "../pages/$sUIPage?operation=modify_all&filter=$sFilter&$sContext"); }
  866. //if ($bIsBulkDeleteAllowed) { $aActions[] = array ('label' => 'Delete All...', 'url' => "../pages/$sUIPage?operation=delete_all&filter=$sFilter&$sContext"); }
  867. }
  868. }
  869. $sHtml .= "<div class=\"jd_menu_itop\"><ul class=\"jd_menu jd_menu_itop\">\n<li>Actions\n<ul>\n";
  870. foreach ($aActions as $aAction)
  871. {
  872. $sClass = isset($aAction['class']) ? " class=\"{$aAction['class']}\"" : "";
  873. $sHtml .= "<li><a href=\"{$aAction['url']}\"$sClass>{$aAction['label']}</a></li>\n<li>\n";
  874. }
  875. $sHtml .= "</ul>\n</li>\n</ul></div>\n";
  876. $oPage->add_ready_script("$(\"ul.jd_menu\").jdMenu();\n");
  877. return $sHtml;
  878. }
  879. }
  880. ?>