Example #1
0
function item() {
	global $colors, $consolidation_functions, $graph_item_types, $struct_graph_item;

	/* ================= input validation ================= */
	input_validate_input_number(get_request_var("id"));
	/* ==================================================== */

	if (empty($_GET["id"])) {
		$template_item_list = array();

		$header_label = "[new]";
	}else{
		$template_item_list = db_fetch_assoc("select
			graph_templates_item.id,
			graph_templates_item.text_format,
			graph_templates_item.value,
			graph_templates_item.hard_return,
			graph_templates_item.graph_type_id,
			graph_templates_item.consolidation_function_id,
			data_template_rrd.data_source_name,
			cdef.name as cdef_name,
			colors.hex
			from graph_templates_item
			left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id)
			left join data_local on (data_template_rrd.local_data_id=data_local.id)
			left join data_template_data on (data_local.id=data_template_data.local_data_id)
			left join cdef on (cdef_id=cdef.id)
			left join colors on (color_id=colors.id)
			where graph_templates_item.local_graph_id=" . $_GET["id"] . "
			order by graph_templates_item.sequence");

		$host_id = db_fetch_cell("select host_id from graph_local where id=" . $_GET["id"]);
		$header_label = "[edit: " . get_graph_title($_GET["id"]) . "]";
	}

	$graph_template_id = db_fetch_cell("select graph_template_id from graph_local where id=" . $_GET["id"]);

	if (empty($graph_template_id)) {
		$add_text = "graphs_items.php?action=item_edit&local_graph_id=" . $_GET["id"] . "&host_id=$host_id";
	}else{
		$add_text = "";
	}

	html_start_box("<strong>Graph Items</strong> $header_label", "100%", $colors["header"], "3", "center", $add_text);
	draw_graph_items_list($template_item_list, "graphs_items.php", "local_graph_id=" . $_GET["id"], (empty($graph_template_id) ? false : true));
	html_end_box();
}
Example #2
0
function item()
{
    global $colors, $consolidation_functions, $graph_item_types;
    /* ================= input validation ================= */
    input_validate_input_number(get_request_var("id"));
    /* ==================================================== */
    if (empty($_GET["id"])) {
        $template_item_list = array();
        $header_label = "[new]";
    } else {
        $template_item_list = db_fetch_assoc("select\n\t\t\tgraph_templates_item.id,\n\t\t\tgraph_templates_item.text_format,\n\t\t\tgraph_templates_item.value,\n\t\t\tgraph_templates_item.hard_return,\n\t\t\tgraph_templates_item.graph_type_id,\n\t\t\tgraph_templates_item.consolidation_function_id,\n\t\t\tCONCAT_WS(' - ',data_template_data.name,data_template_rrd.data_source_name) as data_source_name,\n\t\t\tcdef.name as cdef_name,\n\t\t\tcolors.hex\n\t\t\tfrom graph_templates_item\n\t\t\tleft join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id)\n\t\t\tleft join data_local on (data_template_rrd.local_data_id=data_local.id)\n\t\t\tleft join data_template_data on (data_local.id=data_template_data.local_data_id)\n\t\t\tleft join cdef on (cdef_id=cdef.id)\n\t\t\tleft join colors on (color_id=colors.id)\n\t\t\twhere graph_templates_item.graph_template_id=" . $_GET["id"] . "\n\t\t\tand graph_templates_item.local_graph_id=0\n\t\t\torder by graph_templates_item.sequence");
        $header_label = "[edit: " . db_fetch_cell("select name from graph_templates where id=" . $_GET["id"]) . "]";
    }
    html_start_box("<strong>Graph Template Items</strong> {$header_label}", "100%", $colors["header"], "3", "center", "graph_templates_items.php?action=item_edit&graph_template_id=" . $_GET["id"]);
    draw_graph_items_list($template_item_list, "graph_templates_items.php", "graph_template_id=" . $_GET["id"], false);
    html_end_box();
    html_start_box("<strong>Graph Item Inputs</strong>", "100%", $colors["header"], "3", "center", "graph_templates_inputs.php?action=input_edit&graph_template_id=" . $_GET["id"]);
    print "<tr bgcolor='#" . $colors["header_panel"] . "'>";
    DrawMatrixHeaderItem("Name", $colors["header_text"], 2);
    print "</tr>";
    $template_item_list = db_fetch_assoc("select id,name from graph_template_input where graph_template_id=" . $_GET["id"] . " order by name");
    $i = 0;
    if (sizeof($template_item_list) > 0) {
        foreach ($template_item_list as $item) {
            form_alternate_row_color($colors["alternate"], $colors["light"], $i);
            ?>
			<td>
				<a class="linkEditMain" href="graph_templates_inputs.php?action=input_edit&id=<?php 
            print $item["id"];
            ?>
&graph_template_id=<?php 
            print $_GET["id"];
            ?>
"><?php 
            print $item["name"];
            ?>
</a>
			</td>
			<td align="right">
				<a href="graph_templates_inputs.php?action=input_remove&id=<?php 
            print $item["id"];
            ?>
&graph_template_id=<?php 
            print $_GET["id"];
            ?>
"><img src="images/delete_icon.gif" width="10" height="10" border="0" alt="Delete"></a>
			</td>
		</tr>
	<?php 
            $i++;
        }
    } else {
        print "<tr bgcolor='#" . $colors["form_alternate2"] . "'><td colspan='2'><em>No Inputs</em></td></tr>";
    }
    html_end_box();
}
Example #3
0
function item()
{
    global $consolidation_functions, $graph_item_types, $struct_graph_item;
    /* ================= input validation ================= */
    input_validate_input_number(get_request_var_request('id'));
    /* ==================================================== */
    if (empty($_REQUEST['id'])) {
        $template_item_list = array();
        $header_label = '[new]';
    } else {
        $template_item_list = db_fetch_assoc_prepared('SELECT
			graph_templates_item.id,
			graph_templates_item.text_format,
			graph_templates_item.value,
			graph_templates_item.hard_return,
			graph_templates_item.graph_type_id,
			graph_templates_item.consolidation_function_id,
			data_template_rrd.data_source_name,
			cdef.name AS cdef_name,
			colors.hex
			FROM graph_templates_item
			LEFT JOIN data_template_rrd ON (graph_templates_item.task_item_id = data_template_rrd.id)
			LEFT JOIN data_local ON (data_template_rrd.local_data_id = data_local.id)
			LEFT JOIN data_template_data ON (data_local.id = data_template_data.local_data_id)
			LEFT JOIN cdef ON (cdef_id = cdef.id)
			LEFT JOIN colors ON (color_id = colors.id)
			WHERE graph_templates_item.local_graph_id = ?
			ORDER BY graph_templates_item.sequence', array($_REQUEST['id']));
        $host_id = db_fetch_cell_prepared('SELECT host_id FROM graph_local WHERE id = ?', array($_REQUEST['id']));
        $header_label = '[edit: ' . htmlspecialchars(get_graph_title($_REQUEST['id'])) . ']';
    }
    $graph_template_id = db_fetch_cell_prepared('SELECT graph_template_id FROM graph_local WHERE id = ?', array($_REQUEST['id']));
    if (empty($graph_template_id)) {
        $add_text = 'graphs_items.php?action=item_edit&local_graph_id=' . $_REQUEST['id'] . "&host_id={$host_id}";
    } else {
        $add_text = '';
    }
    html_start_box("<strong>Graph Items</strong> {$header_label}", '100%', '', '3', 'center', $add_text);
    draw_graph_items_list($template_item_list, 'graphs_items.php', 'local_graph_id=' . $_REQUEST['id'], empty($graph_template_id) ? false : true);
    html_end_box();
}
Example #4
0
function graph_template_display_items() {
	global $colors;
	require(CACTI_BASE_PATH . "/include/graph/graph_arrays.php");

	/* ================= input validation ================= */
	input_validate_input_number(get_request_var("id"));
	/* ==================================================== */

	if (empty($_REQUEST["id"])) {
		$template_item_list = array();

		$header_label = __("[new]");
	}else{
		$template_item_list = db_fetch_assoc("select
			graph_templates_item.id,
			graph_templates_item.text_format,
			graph_templates_item.value,
			graph_templates_item.hard_return,
			graph_templates_item.graph_type_id,
			graph_templates_item.line_width,
			graph_templates_item.dashes,
			graph_templates_item.dash_offset,
			graph_templates_item.textalign,
			graph_templates_item.shift,
			graph_templates_item.consolidation_function_id,
			CONCAT_WS(' - ',data_template_data.name,data_template_rrd.data_source_name) as data_source_name,
			cdef.name as cdef_name,
			colors.hex,
			graph_templates_gprint.name as gprint_name
			from graph_templates_item
			left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id)
			left join data_local on (data_template_rrd.local_data_id=data_local.id)
			left join data_template_data on (data_local.id=data_template_data.local_data_id)
			left join cdef on (cdef_id=cdef.id)
			left join vdef on (vdef_id=vdef.id)
			left join colors on (color_id=colors.id)
			left join graph_templates_gprint on (gprint_id=graph_templates_gprint.id)
			where graph_templates_item.graph_template_id=" . $_REQUEST["id"] . "
			and graph_templates_item.local_graph_id=0
			order by graph_templates_item.sequence");

		$header_label = __("[edit: ") . db_fetch_cell("select name from graph_templates where id=" . $_REQUEST["id"]) . "]";
	}

	/* graph template item */
	html_start_box("<strong>" . __("Graph Template Items") . "</strong> $header_label", "100", $colors["header"], "0", "center", "graph_templates_items.php?action=item_edit&graph_template_id=" . $_REQUEST["id"], true);
	draw_graph_items_list($template_item_list, "graph_templates_items.php", "graph_template_id=" . $_REQUEST["id"], false);
	html_end_box(true);

	/* graph template inputs */
	html_start_box("<strong>" . __("Graph Item Inputs") . "</strong>", "100", $colors["header"], "3", "center", "graph_templates_inputs.php?action=input_edit&graph_template_id=" . $_REQUEST["id"], true);
	print "<tr><td>\n";
	html_header(array(__("Name")), 2,'','','left wp100');

	$template_item_list = db_fetch_assoc("select id,name from graph_template_input where graph_template_id=" . $_REQUEST["id"] . " order by name");

	if (sizeof($template_item_list) > 0) {
		foreach ($template_item_list as $item) {
			form_alternate_row_color("item" . $item["id"]);
			?>
<td><a class="linkEditMain"
	href='<?php print htmlspecialchars("graph_templates_inputs.php?action=input_edit&id=" . $item["id"] . "&graph_template_id=" . $_REQUEST["id"]);?>'><?php print $item["name"];?></a>
</td>
<td align="right"><a
	href='<?php print htmlspecialchars("graph_templates_inputs.php?action=input_remove&id=" . $item["id"] . "&graph_template_id=" . $_GET["id"]);?>'><img
	class="buttonSmall" src="images/delete_icon.gif"
	alt="<?php print __("Delete");?>" align='right'></a></td>
			<?php
			form_end_row();
		}
	}else{
		print "<tr class='rowAlternate1'><td colspan='2'><em>" . __("No Inputs") . "</em></td></tr>";
	}

	print "</table></td></tr>";
	html_end_box(true);

	form_save_button_alt("url!graph_templates.php");

	?>
<script type="text/javascript">
	<!--
	$(document).ready(function(){

		//drag and drop for graph items
		$('#graph_item').tableDnD({
			onDrop: function(table, row) {
//				alert($.tableDnD.serialize());
				$('#AjaxResult').load("lib/ajax/jquery.tablednd/graph_templates_item.ajax.php?id=<?php isset($_GET["id"]) ? print $_GET["id"] : print "";?>&"+$.tableDnD.serialize());
			}
		});

	});
	//-->

</script>
	<?php
}
Example #5
0
function item()
{
    global $consolidation_functions, $graph_item_types;
    /* ================= input validation ================= */
    input_validate_input_number(get_request_var_request("id"));
    /* ==================================================== */
    if (empty($_REQUEST["id"])) {
        $template_item_list = array();
        $header_label = "[new]";
    } else {
        $template_item_list = db_fetch_assoc("SELECT\n\t\t\tgraph_templates_item.id,\n\t\t\tgraph_templates_item.text_format,\n\t\t\tgraph_templates_item.value,\n\t\t\tgraph_templates_item.hard_return,\n\t\t\tgraph_templates_item.graph_type_id,\n\t\t\tgraph_templates_item.consolidation_function_id,\n\t\t\tCONCAT_WS(' - ',data_template_data.name,data_template_rrd.data_source_name) AS data_source_name,\n\t\t\tcdef.name AS cdef_name,\n\t\t\tcolors.hex\n\t\t\tFROM graph_templates_item\n\t\t\tLEFT JOIN data_template_rrd ON (graph_templates_item.task_item_id=data_template_rrd.id)\n\t\t\tLEFT JOIN data_local ON (data_template_rrd.local_data_id=data_local.id)\n\t\t\tLEFT JOIN data_template_data ON (data_local.id=data_template_data.local_data_id)\n\t\t\tLEFT JOIN cdef ON (cdef_id=cdef.id)\n\t\t\tLEFT JOIN colors ON (color_id=colors.id)\n\t\t\tWHERE graph_templates_item.graph_template_id=" . $_REQUEST["id"] . "\n\t\t\tAND graph_templates_item.local_graph_id=0\n\t\t\tORDER BY graph_templates_item.sequence");
        $header_label = "[edit: " . db_fetch_cell("SELECT name FROM graph_templates WHERE id=" . $_REQUEST["id"]) . "]";
    }
    html_start_box("<strong>Graph Template Items</strong> " . htmlspecialchars($header_label), "100%", "", "3", "center", "graph_templates_items.php?action=item_edit&graph_template_id=" . htmlspecialchars(get_request_var_request("id")));
    draw_graph_items_list($template_item_list, "graph_templates_items.php", "graph_template_id=" . $_REQUEST["id"], false);
    html_end_box();
    html_start_box("<strong>Graph Item Inputs</strong>", "100%", "", "3", "center", "graph_templates_inputs.php?action=input_edit&graph_template_id=" . htmlspecialchars(get_request_var_request("id")));
    print "<tr class='tableHeader'>";
    DrawMatrixHeaderItem("Name", "", 2);
    print "</tr>";
    $template_item_list = db_fetch_assoc("SELECT id,name FROM graph_template_input WHERE graph_template_id=" . $_REQUEST["id"] . " ORDER BY name");
    $i = 0;
    if (sizeof($template_item_list) > 0) {
        foreach ($template_item_list as $item) {
            form_alternate_row('', true);
            ?>
			<td>
				<a class="linkEditMain" href="<?php 
            print htmlspecialchars("graph_templates_inputs.php?action=input_edit&id=" . $item["id"] . "&graph_template_id=" . $_REQUEST["id"]);
            ?>
"><?php 
            print htmlspecialchars($item["name"]);
            ?>
</a>
			</td>
			<td align="right">
				<a href="<?php 
            print htmlspecialchars("graph_templates_inputs.php?action=input_remove&id=" . $item["id"] . "&graph_template_id=" . $_REQUEST["id"]);
            ?>
"><img src="images/delete_icon.gif" style="height:10px;width:10px;" border="0" alt="Delete"></a>
			</td>
		</tr>
		<?php 
        }
    } else {
        print "<tr><td colspan='2'><em>No Inputs</em></td></tr>";
    }
    html_end_box();
}