displayblock.class.inc.php 35 KB

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