pihi.php

<?php
/*
 +-------------------------------------------------------------------------+
 | Copyright (C) 2015-2019 Petr Macek                                      |
 |                                                                         |
 | This program is free software; you can redistribute it and/or           |
 | modify it under the terms of the GNU General Public License             |
 | as published by the Free Software Foundation; either version 2          |
 | of the License, or (at your option) any later version.                  |
 |                                                                         |
 | This program is distributed in the hope that it will be useful,         |
 | but WITHOUT ANY WARRANTY; without even the implied warranty of          |
 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the           |
 | GNU General Public License for more details.                            |
 +-------------------------------------------------------------------------+
 | Cacti: The Complete RRDtool-based Graphing Solution                     |
 +-------------------------------------------------------------------------+
 | This code is designed, written, and maintained by the Cacti Group. See  |
 | about.php and/or the AUTHORS file for specific developer information.   |
 +-------------------------------------------------------------------------+
 | https://github.com/xmacan/                                              |
 | http://www.cacti.net/                                                   |
 +-------------------------------------------------------------------------+
*/

chdir('../../');
include_once('./include/auth.php');
include_once('./include/global_arrays.php');

set_default_action();

$poller_interval = read_config_option('poller_interval');
$selectedTheme = get_selected_theme();


$ar_age = array ('168' => 'Week', '24' => 'Day', '6' => '6 hours', '1' => '1 hour'); 


/* if the user pushed the 'clear' button */
if (get_request_var('clear_x')) {
    unset($_SESSION['pihi_age']);
}

if ( isset_request_var ('age') )
    $_SESSION['pihi_age'] = get_filter_request_var ('age');
if (!isset($_SESSION['pihi_age']))
    $_SESSION['pihi_age'] = 6;

if ( isset_request_var ('host') )
    $_SESSION['host'] = get_filter_request_var ('host');

if ( isset_request_var ('from') )
    $_SESSION['from'] = get_filter_request_var ('from', FILTER_VALIDATE_REGEXP, array('options' => array('regexp' => '/^[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}$/')));


general_header();

echo "<link type='text/css' href='" . $config['url_path'] . "plugins/pihi/themes/common.css' rel='stylesheet'>";

?>

<script type="text/javascript">
<!--

function applyViewAgeFilterChange(objForm) {
	strURL = '?age=' + objForm.age.value;
	strURL = strURL + '&host=' + objForm.host.value;
//	strURL = strURL + '&sort=' + objForm.sort.value;
	document.location = strURL;
}
-->
</script>
<?php

html_start_box('<strong>Ping history</strong>', '100%', '', '3', 'center', '');
?>

<tr>
 <td>
  <form name="form_pihi" action="pihi.php">
   <table width="100%" cellpadding="0" cellspacing="0">
    <tr class="navigate_form">
     <td style='white-space: nowrap;' width="50">
      Age:&nbsp;
     </td>
     <td width="1">
      <select name="age" onChange="applyViewAgeFilterChange(document.form_pihi)">

<?php
foreach ($ar_age as $key=>$value)	{
    if ($_SESSION["pihi_age"] == $key)
	echo '<option value=\'' . $key . '\' selected="selected">' . $value . '</option>';
    else    
	echo '<option value=\'' . $key . '\'>' . $value .'</option>';
}
?>
      </select>
     </td>

     
     <td style='white-space: nowrap;' width='50'>
      &nbsp;Host:&nbsp;
     </td>
     <td width='1'>
      <select name="host" onChange="applyViewAgeFilterChange(document.form_pihi)">

<?php
$hosts = db_fetch_assoc ('SELECT id, description FROM host WHERE pihi_days > 0 ORDER BY description');
if (count($hosts) > 0)	{
    foreach ($hosts as $host)	{
	// default host
	if (!isset($_SESSION['host'])) $_SESSION['host'] = $host['id'];

	if ($_SESSION['host'] == $host['id'])	{
	    echo '<option value="' . $host['id'] . '" selected="selected">' . $host['description'] . '</option>';
	}
	else
	    echo '<option value="' . $host['id'] . '">' . $host['description'] . '</option>';
    }
}

?>
     <td>
      &nbsp;<input type="submit" value="Go" title="Set/Refresh Filters">
      <input type="submit" name="clear_x" value="Clear" title="Clear Filters">
     </td>
    </tr>
  </table>
 </form>
</td>
<td>

<?php

if (!empty($_SESSION['host']))	{

    $mins = ($_SESSION['pihi_age']*60) + date('i');

    if (!isset($_SESSION['from']))
	$_SESSION['from'] = db_fetch_cell ('select now()');

    $selected_date = db_fetch_cell ('SELECT min(date) as xdate FROM plugin_pihi_data WHERE host_id = ' . $_SESSION['host'] . ' AND date BETWEEN date_sub(\'' . $_SESSION['from'] . '\',interval ' . $mins . ' minute) and \'' . $_SESSION['from'] . '\'');

    // before
    if (db_fetch_cell ('SELECT count(date) FROM plugin_pihi_data WHERE host_id = ' . $_SESSION['host'] . ' AND date < \'' . $_SESSION['from'] . '\''))	{
	$before = db_fetch_cell ('SELECT date_sub(\'' . $_SESSION['from'] . '\',interval ' . $mins . ' minute)');
    }

    if (db_fetch_cell ('SELECT count(date) FROM plugin_pihi_data WHERE host_id = ' . $_SESSION['host'] . ' AND date > \'' . $_SESSION['from'] . '\''))	{
	$after = db_fetch_cell ('SELECT date_add(\'' . $_SESSION['from'] . '\',interval ' . $mins . ' minute)');
    }

    echo '<b>';
    if (isset($before) && $before > 0) echo '<a href="?from=' . $before . '">&lt;&lt;</a> ';
    else echo '&lt;&lt; ';

    echo $selected_date;

    if (isset($after) && $after > 0) echo '<a href="?from=' . $after . '">&gt;&gt;</a> ';
    else echo '&gt;&gt; ';
    echo '</b>';


    echo '</td></tr>';
    html_end_box();



    $sql  = 'SELECT duration,date, hour(date) as xhour, minute(date) as xminute FROM plugin_pihi_data 
	 WHERE host_id = ' . $_SESSION['host'] . 
	 ' AND date BETWEEN date_sub(\'' . $_SESSION['from'] . '\',interval ' . $mins . ' minute) 
	  AND \'' . $_SESSION['from'] . '\' ORDER BY date';

//    echo $sql;

    $result = db_fetch_assoc ($sql);

    if (count($result) > 0)	{    
	$date = '';
	$dura = '';

	$hour = -1;
	$first = true;
	echo '<table class="pihi_table">';
	foreach ($result as $row)	{
	    $date .= '"' . substr($row['date'],5,-3) . '",';
	    $dura .= $row['duration'] . ',';

	    if ($hour != $row['xhour'])
		echo '<tr><td>' . $row['xhour'] . ' </td>';
    
	    if ($first)	{
		echo '<td>' . $row['xminute'] . '<br/>';
	    }
	    else
		echo '<td>';

	    echo $row['duration'] > 30 ? '<font color="red"><b>' . $row['duration'] . '</b></font>' : $row['duration'] . '</td>';

	    echo '</td>';
	    $hour = $row['xhour'];
	}
	echo '</table>';
    
	// displaying graph

	$date = substr($date,0,-1);
	$dura = substr($dura,0,-1);

	print '<div style="background: white;"><canvas  width="800" height="300" id="mychart"></canvas>';
	print '<script type="text/javascript">';
	$title1 = 'Ping history';
	$line_labels = $date;
	$line_values = $dura;


    print <<<EOF
var ctx = document.getElementById("mychart").getContext("2d");
new Chart(ctx, {
    type: 'bar',
    data: {
        labels: [$line_labels],
        datasets: [{
            label: '$title1',
            data: [$line_values],
            borderColor: 'rgba(220,220,220,0.5)',
            backgroundColor: 'rgba(220,220,220,0.5)',

        },

        ]
    },
    options: {
        responsive: false,
        tooltipTemplate: "<%= value %>%",
          scales: {
	    yAxes: [{
    		scaleLabel: {
    		    display: true,
    		    labelString: 'Duration [ms]'
    		}
	    }]
	}
    }

    
});

EOF;
	print '</script>';

	print '</div>';
	// end of graph
    }
    else	{	// host selected,,but no data
	echo 'No data';
    }
}
else	{ 	// without hosts
    echo '</td></tr>';
    html_end_box();

    echo 'No host with Pihi enabled';
}

bottom_footer();