if (empty($_REQUEST["dropdown"]) || !class_exists($_REQUEST["dropdown"])) { // Do nothing commonFooter(); exit; } $item = new $_REQUEST["dropdown"](); if (!$item instanceof CommonDevice) { // echo "Dropdown"; $type = "comp_champ"; $val = Stat::getItems($itemtype, $_REQUEST["date1"], $_REQUEST["date2"], $_REQUEST["dropdown"]); $params = array('type' => $type, 'dropdown' => $_REQUEST["dropdown"], 'date1' => $_REQUEST["date1"], 'date2' => $_REQUEST["date2"], 'start' => $_REQUEST["start"]); } else { // echo "Device"; $type = "device"; $field = $_REQUEST["dropdown"]; $val = Stat::getItems($itemtype, $_REQUEST["date1"], $_REQUEST["date2"], $_REQUEST["dropdown"]); $params = array('type' => $type, 'dropdown' => $_REQUEST["dropdown"], 'date1' => $_REQUEST["date1"], 'date2' => $_REQUEST["date2"], 'start' => $_REQUEST["start"]); } /*printPager($_REQUEST['start'],count($val),$CFG_GLPI['root_doc'].'/front/stat.location.php', "date1=".$_REQUEST["date1"]."&date2=".$_REQUEST["date2"]."&dropdown=".$_REQUEST["dropdown"], 'Stat',$params);*/ if (!$_REQUEST['showgraph']) { PluginMobileStat::show($type, $_REQUEST["date1"], $_REQUEST["date2"], $_REQUEST['start'], $val, $_REQUEST["dropdown"]); } else { $data = Stat::getDatas($type, $_REQUEST["date1"], $_REQUEST["date2"], $_REQUEST['start'], $val, $_REQUEST["dropdown"]); if (isset($data['opened']) && is_array($data['opened'])) { foreach ($data['opened'] as $key => $val) { $cleandata[html_clean($key)] = $val; } PluginMobileStat::showGraph(array($LANG['stats'][5] => $cleandata), array('title' => $LANG['stats'][5], 'showtotal' => 1, 'unit' => $LANG['stats'][35], 'type' => 'pie')); }
echo "<table class='tab_cadre'>"; echo "<tr class='tab_bg_2'><td rowspan='2' class='center'>"; echo "<select name='type'>" . $INSELECT . "</select></td>"; echo "<td class='right'>" . $LANG['search'][8] . " :</td><td>"; showDateFormItem("date1", $_REQUEST["date1"]); echo "</td>"; echo "<td class='right'>" . $LANG['stats'][7] . " :</td>"; echo "<td rowspan='2' class='center'>"; echo "<input type='submit' class='button' name='submit' value=\"" . $LANG['buttons'][7] . "\"></td></tr>"; echo "<tr class='tab_bg_2'><td class='right'>" . $LANG['search'][9] . " :</td><td>"; showDateFormItem("date2", $_REQUEST["date2"]); echo "</td><td class='center'>"; Dropdown::showYesNo('showgraph', $_REQUEST['showgraph']); echo "</td></tr>"; echo "</table></form></div>"; $val = Stat::getItems($_REQUEST["date1"], $_REQUEST["date2"], $_REQUEST["type"]); $params = array('type' => $_REQUEST["type"], 'date1' => $_REQUEST["date1"], 'date2' => $_REQUEST["date2"], 'start' => $_REQUEST["start"]); printPager($_REQUEST['start'], count($val), $CFG_GLPI['root_doc'] . '/front/stat.tracking.php', "date1=" . $_REQUEST["date1"] . "&date2=" . $_REQUEST["date2"] . "&type=" . $_REQUEST["type"] . "&showgraph=" . $_REQUEST["showgraph"], 'Stat', $params); if (!$_REQUEST['showgraph']) { Stat::show($_REQUEST["type"], $_REQUEST["date1"], $_REQUEST["date2"], $_REQUEST['start'], $val); } else { $data = Stat::getDatas($_REQUEST["type"], $_REQUEST["date1"], $_REQUEST["date2"], $_REQUEST['start'], $val); if (isset($data['opened']) && is_array($data['opened'])) { foreach ($data['opened'] as $key => $val) { $newkey = html_clean($key); $cleandata[$newkey] = $val; } Stat::showGraph(array($LANG['stats'][5] => $cleandata), array('title' => $LANG['stats'][5], 'showtotal' => 1, 'unit' => $LANG['stats'][35], 'type' => 'pie')); } if (isset($data['solved']) && is_array($data['solved'])) { foreach ($data['solved'] as $key => $val) {
break; case 'Stat': if (isset($_GET["item_type_param"])) { $params = Toolbox::decodeArrayFromInput($_GET["item_type_param"]); switch ($params["type"]) { case "comp_champ": $val = Stat::getItems($_GET["itemtype"], $params["date1"], $params["date2"], $params["dropdown"]); Stat::showTable($_GET["itemtype"], $params["type"], $params["date1"], $params["date2"], $params["start"], $val, $params["dropdown"]); break; case "device": $val = Stat::getItems($_GET["itemtype"], $params["date1"], $params["date2"], $params["dropdown"]); Stat::showTable($_GET["itemtype"], $params["type"], $params["date1"], $params["date2"], $params["start"], $val, $params["dropdown"]); break; default: $val2 = isset($params['value2']) ? $params['value2'] : 0; $val = Stat::getItems($_GET["itemtype"], $params["date1"], $params["date2"], $params["type"], $val2); Stat::showTable($_GET["itemtype"], $params["type"], $params["date1"], $params["date2"], $params["start"], $val, $val2); } } else { if (isset($_GET["type"]) && $_GET["type"] == "hardwares") { Stat::showItems("", $_GET["date1"], $_GET["date2"], $_GET['start']); } } break; default: // Plugin case if ($plug = isPluginItemType($_GET["item_type"])) { if (Plugin::doOneHook($plug['plugin'], 'dynamicReport', $_GET)) { exit; } }
echo "</form>"; if (empty($_GET["dropdown"]) || !($item = getItemForItemtype($_GET["dropdown"]))) { // Do nothing Html::footer(); exit; } if (!$item instanceof CommonDevice) { // echo "Dropdown"; $type = "comp_champ"; $val = Stat::getItems($_GET['itemtype'], $_GET["date1"], $_GET["date2"], $_GET["dropdown"]); $params = array('type' => $type, 'dropdown' => $_GET["dropdown"], 'date1' => $_GET["date1"], 'date2' => $_GET["date2"], 'start' => $_GET["start"]); } else { // echo "Device"; $type = "device"; $field = $_GET["dropdown"]; $val = Stat::getItems($_GET['itemtype'], $_GET["date1"], $_GET["date2"], $_GET["dropdown"]); $params = array('type' => $type, 'dropdown' => $_GET["dropdown"], 'date1' => $_GET["date1"], 'date2' => $_GET["date2"], 'start' => $_GET["start"]); } Html::printPager($_GET['start'], count($val), $CFG_GLPI['root_doc'] . '/front/stat.location.php', "date1=" . $_GET["date1"] . "&date2=" . $_GET["date2"] . "&itemtype=" . $_GET['itemtype'] . "&dropdown=" . $_GET["dropdown"], 'Stat', $params); if (!$_GET['showgraph']) { Stat::showTable($_GET['itemtype'], $type, $_GET["date1"], $_GET["date2"], $_GET['start'], $val, $_GET["dropdown"]); } else { $data = Stat::getDatas($_GET['itemtype'], $type, $_GET["date1"], $_GET["date2"], $_GET['start'], $val, $_GET["dropdown"]); if (isset($data['opened']) && is_array($data['opened'])) { foreach ($data['opened'] as $key => $val) { $cleandata[Html::clean($key)] = $val; } Stat::showGraph(array(__('Number opened') => $cleandata), array('title' => __('Number opened'), 'showtotal' => 1, 'unit' => __('Tickets'), 'type' => 'pie')); } if (isset($data['solved']) && is_array($data['solved'])) { foreach ($data['solved'] as $key => $val) {
Html::showDateField("date1", array('value' => $_GET["date1"])); echo "</td>"; echo "<td class='right'>" . __('Show graphics') . "</td>"; echo "<td rowspan='2' class='center'>"; echo "<input type='submit' class='submit' name='submit' value=\"" . __s('Display report') . "\"></td>" . "</tr>"; echo "<tr class='tab_bg_2'><td class='right'>" . __('End date') . "</td><td>"; Html::showDateField("date2", array('value' => $_GET["date2"])); echo "</td><td class='center'>"; echo "<input type='hidden' name='value2' value='" . $_GET["value2"] . "'>"; Dropdown::showYesNo('showgraph', $_GET['showgraph']); echo "</td></tr>"; echo "</table>"; // form using GET method : CRSF not needed echo "</form>"; echo "</div>"; $val = Stat::getItems($_GET["itemtype"], $_GET["date1"], $_GET["date2"], $_GET["type"], $_GET["value2"]); $params = array('type' => $_GET["type"], 'date1' => $_GET["date1"], 'date2' => $_GET["date2"], 'value2' => $_GET["value2"], 'start' => $_GET["start"]); Html::printPager($_GET['start'], count($val), $CFG_GLPI['root_doc'] . '/front/stat.tracking.php', "date1=" . $_GET["date1"] . "&date2=" . $_GET["date2"] . "&type=" . $_GET["type"] . "&showgraph=" . $_GET["showgraph"] . "&itemtype=" . $_GET["itemtype"] . "&value2=" . $_GET['value2'], 'Stat', $params); if (!$_GET['showgraph']) { Stat::showTable($_GET["itemtype"], $_GET["type"], $_GET["date1"], $_GET["date2"], $_GET['start'], $val, $_GET['value2']); } else { $data = Stat::getDatas($_GET["itemtype"], $_GET["type"], $_GET["date1"], $_GET["date2"], $_GET['start'], $val, $_GET['value2']); if (isset($data['opened']) && is_array($data['opened'])) { foreach ($data['opened'] as $key => $val) { $newkey = Toolbox::unclean_cross_side_scripting_deep(Html::clean($key)); $cleandata[$newkey] = $val; } Stat::showGraph(array(__('Number opened') => $cleandata), array('title' => __('Number opened'), 'showtotal' => 1, 'unit' => $item->getTypeName(Session::getPluralNumber()), 'type' => 'pie')); } if (isset($data['solved']) && is_array($data['solved'])) { foreach ($data['solved'] as $key => $val) {
$val1 = $_GET["id"]; $val2 = $_GET["champ"]; if ($item = getItemForItemtype($_GET["champ"])) { $device_table = $item->getTable(); $values = Stat::getItems($_GET["itemtype"], $_GET["date1"], $_GET["date2"], $_GET["champ"]); $query = "SELECT `designation`\n FROM `" . $device_table . "`\n WHERE `id` = '" . $_GET['id'] . "'"; $result = $DB->query($query); $title = sprintf(__('%1$s: %2$s'), $item->getTypeName(), $DB->result($result, 0, "designation")); } break; case "comp_champ": $val1 = $_GET["id"]; $val2 = $_GET["champ"]; if ($item = getItemForItemtype($_GET["champ"])) { $table = $item->getTable(); $values = Stat::getItems($_GET["itemtype"], $_GET["date1"], $_GET["date2"], $_GET["champ"]); $title = sprintf(__('%1$s: %2$s'), $item->getTypeName(), Dropdown::getDropdownName($table, $_GET["id"])); } break; } // Found next and prev items $foundkey = -1; foreach ($values as $key => $val) { if ($val['id'] == $_GET["id"]) { $foundkey = $key; } } if ($foundkey >= 0) { if (isset($values[$foundkey + 1])) { $next = $values[$foundkey + 1]['id']; }
KnowbaseItem::showList($_GET, $_GET["is_faq"]); break; case 'Stat': if (isset($_GET["item_type_param"])) { $params = unserialize(stripslashes($_GET["item_type_param"])); switch ($params["type"]) { case "comp_champ": $val = Stat::getItems($params["date1"], $params["date2"], $params["dropdown"]); Stat::show($params["type"], $params["date1"], $params["date2"], $params["start"], $val, $params["dropdown"]); break; case "device": $val = Stat::getItems($params["date1"], $params["date2"], $params["dropdown"]); Stat::show($params["type"], $params["date1"], $params["date2"], $params["start"], $val, $params["dropdown"]); break; default: $val = Stat::getItems($params["date1"], $params["date2"], $params["type"]); Stat::show($params["type"], $params["date1"], $params["date2"], $params["start"], $val); } } else { if (isset($_GET["type"]) && $_GET["type"] == "hardwares") { Stat::showItems("", $_GET["date1"], $_GET["date2"], $_GET['start']); } } break; default: // Plugin case if ($plug = isPluginItemType($_GET["item_type"])) { if (doOneHook($plug['plugin'], 'dynamicReport', $_GET)) { exit; } }