<?php
header("Content-Type: text/html; charset=ISO-8859-1",true);
session_start();
include ("PATHS.php");
//include ("".$includesPath."var_sessao.php");
include ("includes/functions/funcoes.inc");
include ("includes/javascript/funcoes.js");
include ("includes/queries/queries.php");
include ("".$includesPath."config.inc.php");
// ("".$includesPath."languages/".LANGUAGE."");
include ("".$includesPath."versao.php");
include("includes/classes/conecta.class.php");
include("includes/classes/auth.class.php");
if ($_SESSION['s_logado']==0) {
print "<script>window.open('index.php','_parent','')</script>";
exit;
}
$conec = new conexao;
$conec->conecta('MYSQL');
$_SESSION['s_page_home'] = $_SERVER['PHP_SELF'];
print "<html>";
print "<head>";
print "<meta http-equiv="content-Type" content="text/html; charset=utf-8" />";
print "<script type='text/javascript' src='https://www.google.com/jsapi'></script>";
print "<link rel=stylesheet type='text/css' href='includes/css/estilos.css.php'>";
$auth = new auth;
$auth->testa_user($_SESSION['s_usuario'],$_SESSION['s_nivel'],$_SESSION['s_nivel_desc'],3);
//Todas as áreas que o usuário percente
$uareas = $_SESSION['s_area'];
if ($_SESSION['s_uareas']) {
$uareas.=",".$_SESSION['s_uareas'];
}
// Quantidade total de chamados abertos no sistema para as áreas que você faz parte
$qryTotal = "SELECT a.sistema area, a.sis_id area_cod, s.stat_id, s.status, o.numero
FROM ocorrencias o
JOIN sistemas a
ON o.sistema = a.sis_id
JOIN status s
ON s.stat_id = o.status
AND s.stat_painel IN (1,2)
WHERE o.sistema IN (".$uareas.")";
$execTotal = mysql_query($qryTotal) or die (TRANS('MSG_ERR_TOTAL_OCCO'). $qryTotal);
$regTotal = mysql_num_rows($execTotal);
//Quantidade de chamados abertos por áreas que você faz parte
$qryAreas = "SELECT count(*) total, a.sistema area
FROM ocorrencias o
JOIN sistemas a
ON o.sistema = a.sis_id
JOIN status s
ON s.stat_id = o.status
AND s.stat_painel IN (1,2)
WHERE o.sistema IN (".$uareas.")
GROUP BY a.sistema";
$execAreas = mysql_query($qryAreas) or die(TRANS('MSG_ERR_RESCUE_ALL_OCCO'). $qryAreas);
$regAreas = mysql_num_rows($execAreas);
print "</br>";
// print "<table border='1' cellpadding='5' cellspacing='0' align='center' width='100%'>";
// print "<tr>";
// print "<td>";
print "<div id='chart_div'></div>";
// print "</td><td>";
print "<div id='chart_div2'></div>";
// print "</td>";
// print "</tr>";
// print "</table>";
?>
<script type="text/javascript">
function invertView(id) {
var element = document.getElementById(id);
var elementImg = document.getElementById('img'+id);
var address = './includes/icons/';
if (element.style.display=='none'){
element.style.display='';
elementImg.src = address+'close.png';
} else {
element.style.display='none';
elementImg.src = address+'open.png';
}
}
google.load('visualization', '1', {packages:['gauge']});
google.setOnLoadCallback(drawChart);
<?php
$qryStatus1 = "SELECT LEFT(s.status,16) status, count(*) total
FROM ocorrencias o
JOIN status s
ON o.status = s.stat_id
AND s.stat_painel IN (1,2)
AND s.stat_id NOT IN (1,2)
WHERE o.sistema = 4
GROUP BY s.status";
$execStatus1 = mysql_query($qryStatus1) or die (TRANS('MSG_ERR_QRY_STATUS'). $qryStatus1);
$cont = mysql_num_rows($execStatus1);
$i=1;
$dados1="";
while ($rowStatus1 = mysql_fetch_array($execStatus1)) {
$dados1.=",['".$rowStatus1['status']."',".$rowStatus1['total']."]";
}
?>
function drawChart() {
var data = google.visualization.arrayToDataTable([['Label', 'Value']<?=$dados1?>]);
var options = {width: 400, height: 400, redFrom: 75, redTo: 100, yellowFrom:50, yellowTo: 75, minorTicks: 5};
var chart = new google.visualization.Gauge(document.getElementById('chart_div'));
chart.draw(data, options);
}
<?php
$qryStatus2 = "SELECT LEFT(s.status,16) status, count(*) total
FROM ocorrencias o
JOIN status s
ON o.status = s.stat_id
AND s.stat_painel IN (1,2)
AND s.stat_id IN (1,2)
WHERE o.sistema = 4
GROUP BY s.status";
$execStatus2 = mysql_query($qryStatus2) or die (TRANS('MSG_ERR_QRY_STATUS'). $qryStatus2);
$dados2="";
while ($rowStatus2 = mysql_fetch_array($execStatus2)) {
$dados2.=",['".$rowStatus2['status']."',".$rowStatus2['total']."]";
}
?>
google.load('visualization', '1', {packages:['gauge']});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([['Label', 'Value']<?=$dados2?>]);
var options = { width: 400, height: 400, redFrom: 10, redTo: 60, max: 60, yellowFrom:5, yellowTo: 10, minorTicks: 5};
var chart = new google.visualization.Gauge(document.getElementById('chart_div2'));
chart.draw(data, options);
}
</script>
<?php
print "</body>";
print "</html>";
?>
Início 
