function insert_graph_form()
{
$frmGraph = new CFormTable(S_GRAPH, null, 'post');
$frmGraph->SetName('frm_graph');
$frmGraph->SetHelp("web.graphs.graph.php");
$frmGraph->SetMethod('post');
$items = get_request('items', array());
if (isset($_REQUEST['graphid'])) {
$frmGraph->addVar('graphid', $_REQUEST['graphid']);
$result = DBselect('SELECT * FROM graphs WHERE graphid=' . $_REQUEST['graphid']);
$row = DBfetch($result);
$frmGraph->SetTitle(S_GRAPH . ' "' . $row['name'] . '"');
}
if (isset($_REQUEST['graphid']) && !isset($_REQUEST['form_refresh'])) {
$name = $row['name'];
$width = $row['width'];
$height = $row['height'];
$ymin_type = $row["ymin_type"];
$ymax_type = $row["ymax_type"];
$yaxismin = $row['yaxismin'];
$yaxismax = $row['yaxismax'];
$ymin_itemid = $row["ymin_itemid"];
$ymax_itemid = $row["ymax_itemid"];
$showworkperiod = $row['show_work_period'];
$showtriggers = $row['show_triggers'];
$graphtype = $row['graphtype'];
$legend = $row['show_legend'];
$graph3d = $row['show_3d'];
$percent_left = $row['percent_left'];
$percent_right = $row['percent_right'];
$db_items = DBselect('SELECT * FROM graphs_items WHERE graphid=' . $_REQUEST['graphid']);
while ($item = DBfetch($db_items)) {
array_push($items, array('itemid' => $item['itemid'], 'drawtype' => $item['drawtype'], 'sortorder' => $item['sortorder'], 'color' => $item['color'], 'yaxisside' => $item['yaxisside'], 'calc_fnc' => $item['calc_fnc'], 'type' => $item['type'], 'periods_cnt' => $item['periods_cnt']));
}
} else {
$name = get_request('name', '');
$graphtype = get_request('graphtype', GRAPH_TYPE_NORMAL);
if ($graphtype == GRAPH_TYPE_PIE || $graphtype == GRAPH_TYPE_EXPLODED) {
$width = get_request('width', 400);
$height = get_request('height', 300);
} else {
$width = get_request('width', 900);
$height = get_request('height', 200);
}
$ymin_type = get_request("ymin_type", GRAPH_YAXIS_TYPE_CALCULATED);
$ymax_type = get_request("ymax_type", GRAPH_YAXIS_TYPE_CALCULATED);
$yaxismin = get_request("yaxismin", 0.0);
$yaxismax = get_request("yaxismax", 100.0);
$ymin_itemid = get_request("ymin_itemid", 0);
$ymax_itemid = get_request("ymax_itemid", 0);
$showworkperiod = get_request('showworkperiod', 0);
$showtriggers = get_request('showtriggers', 0);
$legend = get_request('legend', 0);
$graph3d = get_request('graph3d', 0);
$visible = get_request('visible');
$percent_left = 0;
$percent_right = 0;
if (isset($visible['percent_left'])) {
$percent_left = get_request('percent_left', 0);
}
if (isset($visible['percent_right'])) {
$percent_right = get_request('percent_right', 0);
}
}
/* reinit $_REQUEST */
$_REQUEST['items'] = $items;
$_REQUEST['name'] = $name;
$_REQUEST['width'] = $width;
$_REQUEST['height'] = $height;
$_REQUEST['ymin_type'] = $ymin_type;
$_REQUEST['ymax_type'] = $ymax_type;
$_REQUEST['yaxismin'] = $yaxismin;
$_REQUEST['yaxismax'] = $yaxismax;
$_REQUEST['ymin_itemid'] = $ymin_itemid;
$_REQUEST['ymax_itemid'] = $ymax_itemid;
$_REQUEST['showworkperiod'] = $showworkperiod;
$_REQUEST['showtriggers'] = $showtriggers;
$_REQUEST['graphtype'] = $graphtype;
$_REQUEST['legend'] = $legend;
$_REQUEST['graph3d'] = $graph3d;
$_REQUEST['percent_left'] = $percent_left;
$_REQUEST['percent_right'] = $percent_right;
/********************/
if ($graphtype != GRAPH_TYPE_NORMAL) {
foreach ($items as $gid => $gitem) {
if ($gitem['type'] != GRAPH_ITEM_AGGREGATED) {
continue;
}
unset($items[$gid]);
}
}
asort_by_key($items, 'sortorder');
$group_gid = get_request('group_gid', array());
$frmGraph->addVar('ymin_itemid', $ymin_itemid);
$frmGraph->addVar('ymax_itemid', $ymax_itemid);
$frmGraph->addRow(S_NAME, new CTextBox('name', $name, 32));
$g_width = new CNumericBox('width', $width, 5);
$g_width->addoption('onblur', 'javascript: submit();');
$frmGraph->addRow(S_WIDTH, $g_width);
$g_height = new CNumericBox('height', $height, 5);
$g_height->addoption('onblur', 'javascript: submit();');
$frmGraph->addRow(S_HEIGHT, $g_height);
$cmbGType = new CComboBox('graphtype', $graphtype, 'graphs.submit(this)');
$cmbGType->addItem(GRAPH_TYPE_NORMAL, S_NORMAL);
$cmbGType->addItem(GRAPH_TYPE_STACKED, S_STACKED);
$cmbGType->addItem(GRAPH_TYPE_PIE, S_PIE);
$cmbGType->addItem(GRAPH_TYPE_EXPLODED, S_EXPLODED);
zbx_add_post_js('graphs.graphtype = ' . $graphtype . ";\n");
$frmGraph->addRow(S_GRAPH_TYPE, $cmbGType);
if ($graphtype == GRAPH_TYPE_NORMAL || $graphtype == GRAPH_TYPE_STACKED) {
$frmGraph->addRow(S_SHOW_WORKING_TIME, new CCheckBox('showworkperiod', $showworkperiod, null, 1));
$frmGraph->addRow(S_SHOW_TRIGGERS, new CCheckBox('showtriggers', $showtriggers, null, 1));
if ($graphtype == GRAPH_TYPE_NORMAL) {
$percent_left = sprintf("%2.2f", $percent_left);
$percent_right = sprintf("%2.2f", $percent_right);
$pr_left_input = new CTextBox('percent_left', $percent_left, '5');
$pr_left_chkbx = new CCheckBox('visible[percent_left]', 1, "javascript: ShowHide('percent_left');", 1);
if ($percent_left == 0) {
$pr_left_input->addOption('style', 'display: none;');
$pr_left_chkbx->SetChecked(0);
}
$pr_right_input = new CTextBox('percent_right', $percent_right, '5');
$pr_right_chkbx = new CCheckBox('visible[percent_right]', 1, "javascript: ShowHide('percent_right');", 1);
if ($percent_right == 0) {
$pr_right_input->addOption('style', 'display: none;');
$pr_right_chkbx->SetChecked(0);
}
$frmGraph->addRow(S_PERCENTILE_LINE . ' (' . S_LEFT . ')', array($pr_left_chkbx, $pr_left_input));
$frmGraph->addRow(S_PERCENTILE_LINE . ' (' . S_RIGHT . ')', array($pr_right_chkbx, $pr_right_input));
}
$yaxis_min = array();
$cmbYType = new CComboBox('ymin_type', $ymin_type, 'javascript: submit();');
$cmbYType->addItem(GRAPH_YAXIS_TYPE_CALCULATED, S_CALCULATED);
$cmbYType->addItem(GRAPH_YAXIS_TYPE_FIXED, S_FIXED);
$cmbYType->addItem(GRAPH_YAXIS_TYPE_ITEM_VALUE, S_ITEM);
$yaxis_min[] = $cmbYType;
if ($ymin_type == GRAPH_YAXIS_TYPE_FIXED) {
$yaxis_min[] = new CTextBox("yaxismin", $yaxismin, 9);
} else {
if ($ymin_type == GRAPH_YAXIS_TYPE_ITEM_VALUE) {
$frmGraph->addVar('yaxismin', $yaxismin);
$ymin_name = '';
if ($ymin_itemid > 0) {
$min_host = get_host_by_itemid($ymin_itemid);
$min_item = get_item_by_itemid($ymin_itemid);
$ymin_name = $min_host['host'] . ':' . item_description($min_item);
}
$yaxis_min[] = new CTextBox("ymin_name", $ymin_name, 80, 'yes');
$yaxis_min[] = new CButton('yaxis_min', S_SELECT, 'javascript: ' . "return PopUp('popup.php?dstfrm=" . $frmGraph->getName() . "&dstfld1=ymin_itemid" . "&dstfld2=ymin_name" . "&srctbl=items" . "&srcfld1=itemid" . "&srcfld2=description',0,0,'zbx_popup_item');");
} else {
$frmGraph->addVar('yaxismin', $yaxismin);
}
}
$frmGraph->addRow(S_YAXIS_MIN_VALUE, $yaxis_min);
$yaxis_max = array();
$cmbYType = new CComboBox("ymax_type", $ymax_type, "submit()");
$cmbYType->addItem(GRAPH_YAXIS_TYPE_CALCULATED, S_CALCULATED);
$cmbYType->addItem(GRAPH_YAXIS_TYPE_FIXED, S_FIXED);
$cmbYType->addItem(GRAPH_YAXIS_TYPE_ITEM_VALUE, S_ITEM);
$yaxis_max[] = $cmbYType;
if ($ymax_type == GRAPH_YAXIS_TYPE_FIXED) {
$yaxis_max[] = new CTextBox("yaxismax", $yaxismax, 9);
} else {
if ($ymax_type == GRAPH_YAXIS_TYPE_ITEM_VALUE) {
$frmGraph->addVar('yaxismax', $yaxismax);
$ymax_name = '';
if ($ymax_itemid > 0) {
$max_host = get_host_by_itemid($ymax_itemid);
$max_item = get_item_by_itemid($ymax_itemid);
$ymax_name = $max_host['host'] . ':' . item_description($max_item);
}
$yaxis_max[] = new CTextBox("ymax_name", $ymax_name, 80, 'yes');
$yaxis_max[] = new CButton('yaxis_max', S_SELECT, 'javascript: ' . "return PopUp('popup.php?dstfrm=" . $frmGraph->getName() . "&dstfld1=ymax_itemid" . "&dstfld2=ymax_name" . "&srctbl=items" . "&srcfld1=itemid" . "&srcfld2=description',0,0,'zbx_popup_item');");
} else {
$frmGraph->addVar('yaxismax', $yaxismax);
}
}
$frmGraph->addRow(S_YAXIS_MAX_VALUE, $yaxis_max);
} else {
$frmGraph->addRow(S_3D_VIEW, new CCheckBox('graph3d', $graph3d, 'javascript: graphs.submit(this);', 1));
$frmGraph->addRow(S_LEGEND, new CCheckBox('legend', $legend, 'javascript: graphs.submit(this);', 1));
}
$only_hostid = null;
$monitored_hosts = null;
if (count($items)) {
$frmGraph->addVar('items', $items);
$items_table = new CTableInfo();
foreach ($items as $gid => $gitem) {
if ($graphtype == GRAPH_TYPE_STACKED && $gitem['type'] == GRAPH_ITEM_AGGREGATED) {
continue;
}
$host = get_host_by_itemid($gitem['itemid']);
$item = get_item_by_itemid($gitem['itemid']);
if ($host['status'] == HOST_STATUS_TEMPLATE) {
$only_hostid = $host['hostid'];
} else {
$monitored_hosts = 1;
}
if ($gitem['type'] == GRAPH_ITEM_AGGREGATED) {
$color = '-';
} else {
$color = new CColorCell(null, $gitem['color']);
}
$do_up = new CLink(S_UP, '#', 'action');
$do_up->OnClick("return create_var('" . $frmGraph->GetName() . "','move_up'," . $gid . ", true);");
$do_down = new CLink(S_DOWN, '#', 'action');
$do_down->OnClick("return create_var('" . $frmGraph->GetName() . "','move_down'," . $gid . ", true);");
$description = new CLink($host['host'] . ': ' . item_description($item), '#', 'action');
$description->OnClick('return PopUp("popup_gitem.php?list_name=items&dstfrm=' . $frmGraph->GetName() . url_param($only_hostid, false, 'only_hostid') . url_param($monitored_hosts, false, 'monitored_hosts') . url_param($graphtype, false, 'graphtype') . url_param($gitem, false) . url_param($gid, false, 'gid') . url_param(get_request('graphid', 0), false, 'graphid') . '",550,400,"graph_item_form");');
if ($graphtype == GRAPH_TYPE_PIE || $graphtype == GRAPH_TYPE_EXPLODED) {
$items_table->addRow(array(new CCheckBox('group_gid[' . $gid . ']', isset($group_gid[$gid])), $gitem['sortorder'], $description, graph_item_calc_fnc2str($gitem["calc_fnc"], $gitem["type"]), graph_item_type2str($gitem['type'], $gitem["periods_cnt"]), $color, array($do_up, SPACE . "|" . SPACE, $do_down)));
} else {
$items_table->addRow(array(new CCheckBox('group_gid[' . $gid . ']', isset($group_gid[$gid])), $gitem['sortorder'], $description, graph_item_calc_fnc2str($gitem["calc_fnc"], $gitem["type"]), graph_item_type2str($gitem['type'], $gitem["periods_cnt"]), graph_item_drawtype2str($gitem["drawtype"], $gitem["type"]), $color, array($do_up, SPACE . "|" . SPACE, $do_down)));
}
}
$dedlete_button = new CButton('delete_item', S_DELETE_SELECTED);
} else {
$items_table = $dedlete_button = null;
}
$frmGraph->addRow(S_ITEMS, array($items_table, new CButton('add_item', S_ADD, "return PopUp('popup_gitem.php?dstfrm=" . $frmGraph->GetName() . url_param($only_hostid, false, 'only_hostid') . url_param($monitored_hosts, false, 'monitored_hosts') . url_param($graphtype, false, 'graphtype') . "',550,400,'graph_item_form');"), $dedlete_button));
unset($items_table, $dedlete_button);
$frmGraph->addItemToBottomRow(new CButton("save", S_SAVE));
if (isset($_REQUEST["graphid"])) {
$frmGraph->addItemToBottomRow(SPACE);
$frmGraph->addItemToBottomRow(new CButton("clone", S_CLONE));
$frmGraph->addItemToBottomRow(SPACE);
$frmGraph->addItemToBottomRow(new CButtonDelete(S_DELETE_GRAPH_Q, url_param("graphid") . url_param('groupid') . url_param("hostid")));
}
$frmGraph->addItemToBottomRow(SPACE);
$frmGraph->addItemToBottomRow(new CButtonCancel(url_param('groupid') . url_param("hostid")));
$frmGraph->Show();
}