displayblock.class.inc.php 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856
  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 'list':
  310. if ( ($this->m_oSet->Count()> 0) && (UserRights::IsActionAllowed($this->m_oSet->GetClass(), UR_ACTION_READ, $this->m_oSet) == UR_ALLOWED_YES) )
  311. {
  312. $sHtml .= cmdbAbstractObject::GetDisplaySet($oPage, $this->m_oSet, $aExtraParams);
  313. }
  314. else
  315. {
  316. $sHtml .= $oPage->GetP("No object to display.");
  317. $sClass = $this->m_oFilter->GetClass();
  318. $bDisplayMenu = isset($aExtraParams['menu']) ? $aExtraParams['menu'] == true : true;
  319. if ($bDisplayMenu)
  320. {
  321. if (UserRights::IsActionAllowed($sClass, UR_ACTION_MODIFY) == UR_ALLOWED_YES)
  322. {
  323. $oAppContext = new ApplicationContext();
  324. $sParams = $oAppContext->GetForLink();
  325. // 1:n links, populate the target object as a default value when creating a new linked object
  326. if (isset($aExtraParams['target_attr']))
  327. {
  328. $aExtraParams['default'][$aExtraParams['target_attr']] = $aExtraParams['object_id'];
  329. }
  330. $sDefault = '';
  331. if (!empty($aExtraParams['default']))
  332. {
  333. foreach($aExtraParams['default'] as $sKey => $sValue)
  334. {
  335. $sDefault.= "&default[$sKey]=$sValue";
  336. }
  337. }
  338. $sHtml .= $oPage->GetP("<a href=\"./UI.php?operation=new&class=$sClass&$sParams{$sDefault}\">Click here to create a new ".Metamodel::GetName($sClass)."</a>\n");
  339. }
  340. }
  341. }
  342. break;
  343. case 'links':
  344. //$bDashboardMode = isset($aExtraParams['dashboard']) ? ($aExtraParams['dashboard'] == 'true') : false;
  345. //$bSelectMode = isset($aExtraParams['select']) ? ($aExtraParams['select'] == 'true') : false;
  346. if ( ($this->m_oSet->Count()> 0) && (UserRights::IsActionAllowed($this->m_oSet->GetClass(), UR_ACTION_READ, $this->m_oSet) == UR_ALLOWED_YES) )
  347. {
  348. //$sLinkage = isset($aExtraParams['linkage']) ? $aExtraParams['linkage'] : '';
  349. $sHtml .= cmdbAbstractObject::GetDisplaySet($oPage, $this->m_oSet, $aExtraParams);
  350. }
  351. else
  352. {
  353. $sClass = $this->m_oFilter->GetClass();
  354. $oAttDef = MetaModel::GetAttributeDef($sClass, $this->m_aParams['target_attr']);
  355. $sTargetClass = $oAttDef->GetTargetClass();
  356. $sHtml .= $oPage->GetP("No ".MetaModel::GetName($sTargetClass)." to display.");
  357. $bDisplayMenu = isset($this->m_aParams['menu']) ? $this->m_aParams['menu'] == true : true;
  358. if ($bDisplayMenu)
  359. {
  360. if (UserRights::IsActionAllowed($sClass, UR_ACTION_MODIFY) == UR_ALLOWED_YES)
  361. {
  362. $oAppContext = new ApplicationContext();
  363. $sParams = $oAppContext->GetForLink();
  364. $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");
  365. }
  366. }
  367. }
  368. break;
  369. case 'details':
  370. if (UserRights::IsActionAllowed($this->m_oSet->GetClass(), UR_ACTION_READ, $this->m_oSet) == UR_ALLOWED_YES)
  371. {
  372. while($oObj = $this->m_oSet->Fetch())
  373. {
  374. $sHtml .= $oObj->GetDetails($oPage); // Still used ???
  375. }
  376. }
  377. break;
  378. case 'bare_details':
  379. if (UserRights::IsActionAllowed($this->m_oSet->GetClass(), UR_ACTION_READ, $this->m_oSet) == UR_ALLOWED_YES)
  380. {
  381. while($oObj = $this->m_oSet->Fetch())
  382. {
  383. $sHtml .= $oObj->GetBareDetails($oPage);
  384. }
  385. }
  386. break;
  387. case 'csv':
  388. if (UserRights::IsActionAllowed($this->m_oSet->GetClass(), UR_ACTION_READ, $this->m_oSet) == UR_ALLOWED_YES)
  389. {
  390. $sHtml .= "<textarea style=\"width:95%;height:98%\">\n";
  391. $sHtml .= cmdbAbstractObject::GetSetAsCSV($this->m_oSet);
  392. $sHtml .= "</textarea>\n";
  393. }
  394. break;
  395. case 'modify':
  396. if (UserRights::IsActionAllowed($this->m_oSet->GetClass(), UR_ACTION_MODIFY, $this->m_oSet) == UR_ALLOWED_YES)
  397. {
  398. while($oObj = $this->m_oSet->Fetch())
  399. {
  400. $sHtml .= $oObj->GetModifyForm($oPage);
  401. }
  402. }
  403. break;
  404. case 'search':
  405. $iSearchSectionId = 1;
  406. $sStyle = (isset($aExtraParams['open']) && ($aExtraParams['open'] == 'true')) ? 'SearchDrawer' : 'SearchDrawer DrawerClosed';
  407. $sHtml .= "<div id=\"Search_$iSearchSectionId\" class=\"$sStyle\">\n";
  408. $oPage->add_ready_script("\$(\"#LnkSearch_$iSearchSectionId\").click(function() {\$(\"#Search_$iSearchSectionId\").slideToggle('normal'); $(\"#LnkSearch_$iSearchSectionId\").toggleClass('open');});");
  409. $sHtml .= cmdbAbstractObject::GetSearchForm($oPage, $this->m_oSet, $aExtraParams);
  410. $sHtml .= "</div>\n";
  411. $sHtml .= "<div class=\"HRDrawer\"></div>\n";
  412. $sHtml .= "<div id=\"LnkSearch_$iSearchSectionId\" class=\"DrawerHandle\">Search</div>\n";
  413. break;
  414. case 'pie_chart':
  415. $sGroupBy = isset($aExtraParams['group_by']) ? $aExtraParams['group_by'] : '';
  416. $sFilter = $this->m_oFilter->ToOQL();
  417. $sHtml .= "
  418. <OBJECT classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"
  419. codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0\"
  420. WIDTH=\"400\"
  421. HEIGHT=\"250\"
  422. id=\"charts\"
  423. ALIGN=\"\">
  424. <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))."\">
  425. <PARAM NAME=\"quality\" VALUE=\"high\">
  426. <PARAM NAME=\"bgcolor\" VALUE=\"#ffffff\">
  427. <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))."\"
  428. quality=\"high\"
  429. bgcolor=\"#ffffff\"
  430. WIDTH=\"400\"
  431. HEIGHT=\"250\"
  432. NAME=\"charts\"
  433. ALIGN=\"\"
  434. swLiveConnect=\"true\"
  435. TYPE=\"application/x-shockwave-flash\"
  436. PLUGINSPAGE=\"http://www.macromedia.com/go/getflashplayer\">
  437. </EMBED>
  438. </OBJECT>
  439. ";
  440. break;
  441. case 'pie_chart_ajax':
  442. if (isset($aExtraParams['group_by']))
  443. {
  444. $sGroupByField = $aExtraParams['group_by'];
  445. $aGroupBy = array();
  446. while($oObj = $this->m_oSet->Fetch())
  447. {
  448. $sValue = $oObj->Get($sGroupByField);
  449. $aGroupBy[$sValue] = isset($aGroupBy[$sValue]) ? $aGroupBy[$sValue]+1 : 1;
  450. }
  451. $sFilter = urlencode($this->m_oFilter->serialize());
  452. $aData = array();
  453. $sHtml .= "<chart>\n";
  454. $sHtml .= "<chart_type>3d pie</chart_type>\n";
  455. $sHtml .= "<chart_data>\n";
  456. $sHtml .= "<row>\n";
  457. $sHtml .= "<null/>\n";
  458. foreach($aGroupBy as $sValue => $void)
  459. {
  460. $sHtml .= "<string>$sValue</string>\n";
  461. }
  462. $sHtml .= "</row>\n";
  463. $sHtml .= "<row>\n";
  464. $sHtml .= "<string></string>\n";
  465. foreach($aGroupBy as $void => $iCount)
  466. {
  467. $sHtml .= "<number>$iCount</number>\n";
  468. }
  469. $sHtml .= "</row>\n";
  470. $sHtml .= "</chart_data>\n";
  471. $sHtml .= "
  472. <chart_value color='ffffff' alpha='90' font='arial' bold='true' size='10' position='inside' prefix='' suffix='' decimals='0' separator='' as_percentage='true' />
  473. <draw>
  474. <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>
  475. </draw>
  476. <legend_label layout='horizontal' bullet='circle' font='arial' bold='true' size='13' color='000000' alpha='85' />
  477. <legend_rect fill_color='ffffff' fill_alpha='10' line_color='ffffff' line_alpha='50' line_thickness='0' />
  478. <series_color>
  479. <color>ddaa41</color>
  480. <color>88dd11</color>
  481. <color>4e62dd</color>
  482. <color>ff8811</color>
  483. <color>4d4d4d</color>
  484. <color>5a4b6e</color>
  485. <color>1188ff</color>
  486. </series_color>
  487. ";
  488. $sHtml .= "</chart>\n";
  489. }
  490. else
  491. {
  492. // Simply count the number of elements in the set
  493. $iCount = $oSet->Count();
  494. $sHtml .= "<chart>\n</chart>\n";
  495. }
  496. break;
  497. case 'open_flash_chart':
  498. static $iChartCounter = 0;
  499. $sChartType = isset($aExtraParams['chart_type']) ? $aExtraParams['chart_type'] : 'pie';
  500. $sTitle = isset($aExtraParams['chart_title']) ? $aExtraParams['chart_title'] : '';
  501. $sGroupBy = isset($aExtraParams['group_by']) ? $aExtraParams['group_by'] : '';
  502. $sFilter = $this->m_oFilter->ToOQL();
  503. $sHtml .= "<script>
  504. swfobject.embedSWF(\"../images/open-flash-chart.swf\", \"my_chart_{$iChartCounter}\", \"400\", \"400\",\"9.0.0\", \"expressInstall.swf\",
  505. {\"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))."\"});
  506. </script>\n";
  507. $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";
  508. $iChartCounter++;
  509. break;
  510. case 'open_flash_chart_ajax':
  511. include './php-ofc-library/open-flash-chart.php';
  512. $sChartType = isset($aExtraParams['chart_type']) ? $aExtraParams['chart_type'] : 'pie';
  513. $oChart = new open_flash_chart();
  514. switch($sChartType)
  515. {
  516. case 'bars':
  517. $oChartElement = new bar_glass();
  518. if (isset($aExtraParams['group_by']))
  519. {
  520. $sGroupByField = $aExtraParams['group_by'];
  521. $aGroupBy = array();
  522. while($oObj = $this->m_oSet->Fetch())
  523. {
  524. $sValue = $oObj->Get($sGroupByField);
  525. $aGroupBy[$sValue] = isset($aGroupBy[$sValue]) ? $aGroupBy[$sValue]+1 : 1;
  526. }
  527. $sFilter = urlencode($this->m_oFilter->serialize());
  528. $aData = array();
  529. $aLabels = array();
  530. foreach($aGroupBy as $sValue => $iValue)
  531. {
  532. $aData[] = $iValue;
  533. $aLabels[] = $sValue;
  534. }
  535. $maxValue = max($aData);
  536. $oYAxis = new y_axis();
  537. $aMagicValues = array(1,2,5,10);
  538. $iMultiplier = 1;
  539. $index = 0;
  540. $iTop = $aMagicValues[$index % count($aMagicValues)]*$iMultiplier;
  541. while($maxValue > $iTop)
  542. {
  543. $index++;
  544. $iTop = $aMagicValues[$index % count($aMagicValues)]*$iMultiplier;
  545. if (($index % count($aMagicValues)) == 0)
  546. {
  547. $iMultiplier = $iMultiplier * 10;
  548. }
  549. }
  550. //echo "oYAxis->set_range(0, $iTop, $iMultiplier);\n";
  551. $oYAxis->set_range(0, $iTop, $iMultiplier);
  552. $oChart->set_y_axis( $oYAxis );
  553. $oChartElement->set_values( $aData );
  554. $oXAxis = new x_axis();
  555. $oXLabels = new x_axis_labels();
  556. // set them vertical
  557. $oXLabels->set_vertical();
  558. // set the label text
  559. $oXLabels->set_labels($aLabels);
  560. // Add the X Axis Labels to the X Axis
  561. $oXAxis->set_labels( $oXLabels );
  562. $oChart->set_x_axis( $oXAxis );
  563. }
  564. break;
  565. case 'pie':
  566. default:
  567. $oChartElement = new pie();
  568. $oChartElement->set_start_angle( 35 );
  569. $oChartElement->set_animate( true );
  570. $oChartElement->set_tooltip( '#label# - #val# (#percent#)' );
  571. if (isset($aExtraParams['group_by']))
  572. {
  573. $sGroupByField = $aExtraParams['group_by'];
  574. $aGroupBy = array();
  575. while($oObj = $this->m_oSet->Fetch())
  576. {
  577. $sValue = $oObj->Get($sGroupByField);
  578. $aGroupBy[$sValue] = isset($aGroupBy[$sValue]) ? $aGroupBy[$sValue]+1 : 1;
  579. }
  580. $sFilter = urlencode($this->m_oFilter->serialize());
  581. $aData = array();
  582. foreach($aGroupBy as $sValue => $iValue)
  583. {
  584. $aData[] = new pie_value($iValue, $sValue);
  585. }
  586. $oChartElement->set_values( $aData );
  587. $oChart->x_axis = null;
  588. }
  589. }
  590. if (isset($aExtraParams['chart_title'])) //@@ BUG: not passed via ajax !!!
  591. {
  592. $oTitle = new title( $aExtraParams['chart_title'] );
  593. $oChart->set_title( $oTitle );
  594. }
  595. $oChart->set_bg_colour('#FFFFFF');
  596. $oChart->add_element( $oChartElement );
  597. $sHtml = $oChart->toPrettyString();
  598. break;
  599. default:
  600. // Unsupported style, do nothing.
  601. $sHtml .= "Error: unsupported style of block: ".$this->m_sStyle;
  602. }
  603. return $sHtml;
  604. }
  605. }
  606. /**
  607. * Helper class to manage 'blocks' of HTML pieces that are parts of a page and contain some list of cmdb objects
  608. *
  609. * Each block is actually rendered as a <div></div> tag that can be rendered synchronously
  610. * or as a piece of Javascript/JQuery/Ajax that will get its content from another page (ajax.render.php).
  611. * The list of cmdbObjects to be displayed into the block is defined by a filter
  612. * Right now the type of display is either: list, count or details
  613. * - list produces a table listing the objects
  614. * - count produces a paragraphs with a sentence saying 'cont' objects found
  615. * - details display (as table) the details of each object found (best if only one)
  616. */
  617. class HistoryBlock extends DisplayBlock
  618. {
  619. public function GetRenderContent(WebPage $oPage, $aExtraParams = array())
  620. {
  621. $sHtml = '';
  622. // Add the extra params into the filter if they make sense for such a filter
  623. $aFilterCodes = array_keys(MetaModel::GetClassFilterDefs($this->m_oFilter->GetClass()));
  624. foreach($aFilterCodes as $sFilterCode)
  625. {
  626. if (isset($aExtraParams[$sFilterCode]))
  627. {
  628. $this->m_oFilter->AddCondition($sFilterCode, $aExtraParams[$sFilterCode]); // Use the default 'loose' operator
  629. }
  630. }
  631. $oSet = new CMDBObjectSet($this->m_oFilter, array('date'=>false));
  632. $sHtml .= "<!-- filter: ".($this->m_oFilter->ToOQL())."-->\n";
  633. switch($this->m_sStyle)
  634. {
  635. case 'toggle':
  636. // First the latest change that the user is allowed to see
  637. do
  638. {
  639. $oLatestChangeOp = $oSet->Fetch();
  640. }
  641. while(is_object($oLatestChangeOp) && ($oLatestChangeOp->GetDescription() == ''));
  642. if (is_object($oLatestChangeOp))
  643. {
  644. global $oContext; // User Context.. should be statis instead of global...
  645. // There is one change in the list... only when the object has been created !
  646. $sDate = $oLatestChangeOp->GetAsHTML('date');
  647. $oChange = $oContext->GetObject('CMDBChange', $oLatestChangeOp->Get('change'));
  648. $sUserInfo = $oChange->GetAsHTML('userinfo');
  649. $oSet->Rewind(); // Reset the pointer to the beginning of the set
  650. $sHtml .= $oPage->GetStartCollapsibleSection("Last modified on $sDate by $sUserInfo.");
  651. //$sHtml .= cmdbAbstractObject::GetDisplaySet($oPage, $oSet);
  652. $aChanges = array();
  653. while($oChangeOp = $oSet->Fetch())
  654. {
  655. $sChangeDescription = $oChangeOp->GetDescription();
  656. if ($sChangeDescription != '')
  657. {
  658. // The change is visible for the current user
  659. $changeId = $oChangeOp->Get('change');
  660. $aChanges[$changeId]['date'] = $oChangeOp->Get('date');
  661. $aChanges[$changeId]['userinfo'] = $oChangeOp->Get('userinfo');
  662. if (!isset($aChanges[$changeId]['log']))
  663. {
  664. $aChanges[$changeId]['log'] = array();
  665. }
  666. $aChanges[$changeId]['log'][] = $sChangeDescription;
  667. }
  668. }
  669. $aAttribs = array('date' => array('label' => 'Date', 'description' => 'Date of the change'),
  670. 'userinfo' => array('label' => 'User', 'description' => 'User who made the change'),
  671. 'log' => array('label' => 'Changes', 'description' => 'Changes made to the object'),
  672. );
  673. $aValues = array();
  674. foreach($aChanges as $aChange)
  675. {
  676. $aValues[] = array('date' => $aChange['date'], 'userinfo' => $aChange['userinfo'], 'log' => "<ul><li>".implode('</li><li>', $aChange['log'])."</li></ul>");
  677. }
  678. $sHtml .= $oPage->GetTable($aAttribs, $aValues);
  679. $sHtml .= $oPage->GetEndCollapsibleSection();
  680. }
  681. break;
  682. default:
  683. $sHtml .= parent::GetRenderContent($oPage, $aExtraParams);
  684. }
  685. return $sHtml;
  686. }
  687. }
  688. class MenuBlock extends DisplayBlock
  689. {
  690. public function GetRenderContent(WebPage $oPage, $aExtraParams = array())
  691. {
  692. $sHtml = '';
  693. $oAppContext = new ApplicationContext();
  694. $sContext = $oAppContext->GetForLink();
  695. $sClass = $this->m_oFilter->GetClass();
  696. $oSet = new CMDBObjectSet($this->m_oFilter);
  697. $sFilter = $this->m_oFilter->serialize();
  698. $aActions = array();
  699. $sUIPage = cmdbAbstractObject::ComputeUIPage($sClass);
  700. // 1:n links, populate the target object as a default value when creating a new linked object
  701. if (isset($aExtraParams['target_attr']))
  702. {
  703. $aExtraParams['default'][$aExtraParams['target_attr']] = $aExtraParams['object_id'];
  704. }
  705. $sDefault = '';
  706. if (!empty($aExtraParams['default']))
  707. {
  708. foreach($aExtraParams['default'] as $sKey => $sValue)
  709. {
  710. $sDefault.= "&default[$sKey]=$sValue";
  711. }
  712. }
  713. switch($oSet->Count())
  714. {
  715. case 0:
  716. // No object in the set, the only possible action is "new"
  717. $bIsModifyAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_MODIFY);
  718. if ($bIsModifyAllowed) { $aActions[] = array ('label' => 'New', 'url' => "../page/$sUIPage?operation=new&class=$sClass&$sContext{$sDefault}"); }
  719. break;
  720. case 1:
  721. $oObj = $oSet->Fetch();
  722. $id = $oObj->GetKey();
  723. $bIsModifyAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_MODIFY, $oSet);
  724. $bIsDeleteAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_DELETE, $oSet);
  725. $bIsBulkModifyAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_BULK_MODIFY, $oSet);
  726. $bIsBulkDeleteAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_BULK_DELETE, $oSet);
  727. // Just one object in the set, possible actions are "new / clone / modify and delete"
  728. if (isset($aExtraParams['link_attr']))
  729. {
  730. $id = $aExtraParams['object_id'];
  731. $sTargetAttr = $aExtraParams['target_attr'];
  732. $oAttDef = MetaModel::GetAttributeDef($sClass, $sTargetAttr);
  733. $sTargetClass = $oAttDef->GetTargetClass();
  734. 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"); }
  735. 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"); }
  736. //if ($bIsDeleteAllowed) { $aActions[] = array ('label' => 'Remove All', 'url' => "#"); }
  737. }
  738. else
  739. {
  740. $sUrl = utils::GetAbsoluteUrl();
  741. $aActions[] = array ('label' => 'eMail', 'url' => "mailto:?subject=".$oSet->GetFilter()->__DescribeHTML()."&body=".urlencode("$sUrl?operation=search&filter=$sFilter&$sContext"));
  742. $aActions[] = array ('label' => 'CSV Export', 'url' => "../pages/$sUIPage?operation=search&filter=$sFilter&format=csv&$sContext");
  743. //$aActions[] = array ('label' => 'Bookmark...', 'url' => "../pages/ajax.render.php?operation=create&class=$sClass&filter=$sFilter", 'class' => 'jqmTrigger');
  744. if ($bIsModifyAllowed) { $aActions[] = array ('label' => 'New...', 'url' => "../pages/$sUIPage?operation=new&class=$sClass&$sContext{$sDefault}"); }
  745. //if ($bIsModifyAllowed) { $aActions[] = array ('label' => 'Clone...', 'url' => "../pages/$sUIPage?operation=clone&class=$sClass&id=$id&$sContext"); }
  746. if ($bIsModifyAllowed) { $aActions[] = array ('label' => 'Modify...', 'url' => "../pages/$sUIPage?operation=modify&class=$sClass&id=$id&$sContext"); }
  747. if ($bIsDeleteAllowed) { $aActions[] = array ('label' => 'Delete...', 'url' => "../pages/$sUIPage?operation=delete&class=$sClass&id=$id&$sContext"); }
  748. }
  749. $aTransitions = $oObj->EnumTransitions();
  750. $aStimuli = Metamodel::EnumStimuli($sClass);
  751. foreach($aTransitions as $sStimulusCode => $aTransitionDef)
  752. {
  753. $iActionAllowed = UserRights::IsStimulusAllowed($sClass, $sStimulusCode, $oSet);
  754. switch($iActionAllowed)
  755. {
  756. case UR_ALLOWED_YES:
  757. $aActions[] = array('label' => $aStimuli[$sStimulusCode]->Get('label'), 'url' => "../pages/UI.php?operation=stimulus&stimulus=$sStimulusCode&class=$sClass&id=$id&$sContext");
  758. break;
  759. case UR_ALLOWED_DEPENDS:
  760. $aActions[] = array('label' => $aStimuli[$sStimulusCode]->Get('label').' (*)', 'url' => "../pages/UI.php?operation=stimulus&stimulus=$sStimulusCode&class=$sClass&id=$id&$sContext");
  761. break;
  762. default:
  763. // Do nothing
  764. }
  765. }
  766. //print_r($aTransitions);
  767. break;
  768. default:
  769. // Check rights
  770. // New / Modify
  771. $bIsModifyAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_MODIFY, $oSet);
  772. $bIsBulkModifyAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_BULK_MODIFY, $oSet);
  773. $bIsBulkDeleteAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_BULK_DELETE, $oSet);
  774. if (isset($aExtraParams['link_attr']))
  775. {
  776. $id = $aExtraParams['object_id'];
  777. $sTargetAttr = $aExtraParams['target_attr'];
  778. $oAttDef = MetaModel::GetAttributeDef($sClass, $sTargetAttr);
  779. $sTargetClass = $oAttDef->GetTargetClass();
  780. $bIsDeleteAllowed = UserRights::IsActionAllowed($sClass, UR_ACTION_DELETE, $oSet);
  781. 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"); }
  782. //if ($bIsBulkModifyAllowed) { $aActions[] = array ('label' => 'Add...', 'url' => "../pages/$sUIPage?operation=modify_links&class=$sClass&linkage=".$aExtraParams['linkage']."&id=$id&addObjects=true&$sContext"); }
  783. 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"); }
  784. //if ($bIsBulkDeleteAllowed) { $aActions[] = array ('label' => 'Remove All...', 'url' => "#"); }
  785. }
  786. else
  787. {
  788. // many objects in the set, possible actions are: new / modify all / delete all
  789. $sUrl = utils::GetAbsoluteUrl();
  790. $aActions[] = array ('label' => 'eMail', 'url' => "mailto:?subject=".$oSet->GetFilter()->__DescribeHTML()."&body=".urlencode("$sUrl?operation=search&filter=$sFilter&$sContext"));
  791. $aActions[] = array ('label' => 'CSV Export', 'url' => "../pages/$sUIPage?operation=search&filter=$sFilter&format=csv&$sContext");
  792. //$aActions[] = array ('label' => 'Bookmark...', 'url' => "../pages/ajax.render.php?operation=create&class=$sClass&filter=$sFilter", 'class' => 'jqmTrigger');
  793. if ($bIsModifyAllowed) { $aActions[] = array ('label' => 'New...', 'url' => "../pages/$sUIPage?operation=new&class=$sClass&$sContext{$sDefault}"); }
  794. //if ($bIsBulkModifyAllowed) { $aActions[] = array ('label' => 'Modify All...', 'url' => "../pages/$sUIPage?operation=modify_all&filter=$sFilter&$sContext"); }
  795. //if ($bIsBulkDeleteAllowed) { $aActions[] = array ('label' => 'Delete All...', 'url' => "../pages/$sUIPage?operation=delete_all&filter=$sFilter&$sContext"); }
  796. }
  797. }
  798. $sHtml .= "<div class=\"jd_menu_itop\"><ul class=\"jd_menu jd_menu_itop\">\n<li>Actions\n<ul>\n";
  799. foreach ($aActions as $aAction)
  800. {
  801. $sClass = isset($aAction['class']) ? " class=\"{$aAction['class']}\"" : "";
  802. $sHtml .= "<li><a href=\"{$aAction['url']}\"$sClass>{$aAction['label']}</a></li>\n<li>\n";
  803. }
  804. $sHtml .= "</ul>\n</li>\n</ul></div>\n";
  805. $oPage->add_ready_script("$(\"ul.jd_menu\").jdMenu();\n");
  806. return $sHtml;
  807. }
  808. }
  809. ?>