Google Charts returning null in mysql query and loop

0

If I do the query in the database it returns values, already in the charts it is returning null, what am I doing wrong?

<?php
require("conexao.php"); //chama o arquivo de conexão ao BD
include("query_ti.php");
ini_set('display_errors', 0);
error_reporting(0);
?>

<!DOCTYPE html>
<html lang="pt">
    <head>
        <link rel="shortcut icon" href="../img/favicon.ico"/>
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name="description" content="">
        <meta name="author" content="">
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
        <meta http-equiv="refresh" content="30">
        <title>PAINEL DE MONITORAMENTO</title>
        <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script><linkrel="stylesheet" href="bootstrap/style.css">
        <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
        <link rel="stylesheet" href="bootstrap/css/datatables.css">
        <script src="bootstrap/js/jquery.min.js">
        </script>
        <script src="bootstrap/js/bootstrap.min.js">
        </script>
        <script src="bootstrap/js/jquery.dataTables.min.js">
        </script>
        <script src="bootstrap/js/datatables.js">
        </script>
        <style type="text/css">
        </style>
    </head>
    <body>
        <div class="container">
<br />
           <!-- <a href="#" class="btn btn-default btn-lg btn-block"><h3>PAINEL DE MONITORAMENTO</h3></a> -->
<br />
            <div class="row">
                <div class="col-md-6">
                    <div id="tiabertosxfechados"></div>
                </div>

                <div class="col-md-6">
                    <div id="tiabertos"></div>
                </div>

            </div>

<br />
            <div class="row">

                <div class="col-md-6">
                    <div id="eletricaabertosxfechados"></div>
                </div>

                <div class="col-md-6">
                    <div id="eletricaabertos"></div>
                </div>
           </div>
         <div class="row">
                <div class="col-md-12">
                    <div id="rowtec"></div>
                </div>


            </div>
         </div>


            <script type="text/javascript">
                google.charts.load('current', {'packages': ['corechart', 'bar']});

                google.charts.setOnLoadCallback(tiabertos);
                google.charts.setOnLoadCallback(tiabertosxfechados);
                google.charts.setOnLoadCallback(eletricaabertos);
                google.charts.setOnLoadCallback(eletricaabertosxfechados);
                google.charts.setOnLoadCallback(rowtec);



//--Config--
// chartArea: {left:10,top:0,width:'75%',height:'75%'},
function tiabertosxfechados() {

                    var data = google.visualization.arrayToDataTable([
                        ['Effort', 'Amount given'],
                        ['ABERTOS', <?php echo"$tiabertoshj"; ?>],
                        ['FECHADOS', <?php echo"$tifechados"; ?>],
                    ]);

                    var options = {
                        pieHole: 0.6,
                        title: 'CHAMADOS DO DIA - TI',
                        legend:{textStyle: {color: '#000000', fontSize: 12}},
                        pieSliceText: 'value',
                        fontSize: 15,
                        colors: ['#4682B4', '#FFCC00'],
                        chartArea: {width:'80%',height:'75%'},
                        is3D: true
                    };

                    var chart = new google.visualization.PieChart(document.getElementById('tiabertosxfechados'));
                    chart.draw(data, options);
                }

function tiabertos() {

                    var data = google.visualization.arrayToDataTable([
                        ['Effort', 'Amount given'],
                        ['ENCAMINHADO', <?php echo"$tiabertos"; ?>],
                        ['AGUARDANDO', <?php echo"$tiaguardandoat"; ?>],
                    ]);

                    var options = {
                        pieHole: 0.6,
                        title: 'CHAMADOS DO DIA - TI',
                        legend:{textStyle: {color: '#000000', fontSize: 12}},
                        pieSliceText: 'value',
                        fontSize: 15,
                        colors: ['#4682B4', '#FFCC00'],
                        chartArea: {width:'80%',height:'75%'},
                        is3D: true
                    };

                    var chart = new google.visualization.PieChart(document.getElementById('tiabertos'));
                    chart.draw(data, options);
                }


function eletricaabertosxfechados() {

                    var data = google.visualization.arrayToDataTable([
                        ['Effort', 'Amount given'],
                        ['ABERTOS', <?php echo"$eletricaabertoshj"; ?>],
                        ['FECHADOS', <?php echo"$eletricafechados"; ?>],
                    ]);

                    var options = {
                        pieHole: 0.6,
                        title: 'CHAMADOS DO DIA - ELÉTRICA',
                        legend:{textStyle: {color: '#000000', fontSize: 12}},
                        pieSliceText: 'value',
                        fontSize: 15,
                        colors: ['#4682B4', '#FFCC00'],
                        chartArea: {width:'80%',height:'75%'},
                        is3D: true
                    };

                    var chart = new google.visualization.PieChart(document.getElementById('eletricaabertosxfechados'));
                    chart.draw(data, options);
                }
function eletricaabertos() {

                    var data = google.visualization.arrayToDataTable([
                        ['Effort', 'Amount given'],
                        ['ENCAMINHADO', <?php echo"$eletricaabertos"; ?>],
                        ['AGUARDANDO', <?php echo"$eletricaaguardandoat"; ?>],
                    ]);

                    var options = {
                        pieHole: 0.6,
                        title: 'CHAMADOS DO DIA - ELÉTRICA',
                        legend:{textStyle: {color: '#000000', fontSize: 12}},
                        pieSliceText: 'value',
                        fontSize: 15,
                        colors: ['#4682B4', '#FFCC00'],
                        chartArea: {width:'80%',height:'75%'},
                        is3D: true
                    };

                    var chart = new google.visualization.PieChart(document.getElementById('eletricaabertos'));
                    chart.draw(data, options);
                }

function rowtec() {
 var data = google.visualization.arrayToDataTable([
             ['Tecnico', 'Chamado'],
              <?php
                while($row = mysqli_fetch_array($fechadosptec)){
                echo "['".$row['TECNICO']."',".$row['CHAMADO']."],";
                }
                ?>

               ]);
        var options = {
          chart: {
            title: 'CHAMADOS FECHADOS P/ TÉCNICO',      
          }  
        };

        var chart = new google.charts.Bar(document.getElementById('rowtec'));

        chart.draw(data, options);
      }

            </script>
    </body>
</html>

Inquiry:

$fechadosptec = mysql_query("SELECT 
    u.nome AS TECNICO,
 count(o.numero) AS CHAMADO


FROM
    ocorrencias AS o
        LEFT JOIN
    sistemas AS a ON a.sis_id = o.sistema
        LEFT JOIN
    localizacao AS l ON l.loc_id = o.local
        LEFT JOIN
    instituicao AS i ON i.inst_cod = o.instituicao
        LEFT JOIN
    usuarios AS u ON u.user_id = o.operador
        LEFT JOIN
    usuarios AS ua ON ua.user_id = o.aberto_por
        LEFT JOIN
    'status' AS s ON s.stat_id = o.status
        LEFT JOIN
    status_categ AS stc ON stc.stc_cod = s.stat_cat
        LEFT JOIN
    problemas AS p ON p.prob_id = o.problema
        LEFT JOIN
    sla_solucao AS sls ON sls.slas_cod = p.prob_sla
        LEFT JOIN
    prioridades AS pr ON pr.prior_cod = l.loc_prior
        LEFT JOIN
    sla_solucao AS slr ON slr.slas_cod = pr.prior_sla
        LEFT JOIN
    script_solution AS sol ON sol.script_cod = o.oco_script_sol
        LEFT JOIN
    prior_atend AS prioridade_atendimento ON prioridade_atendimento.pr_cod = o.oco_prior
WHERE
     cast(o.data_fechamento as date) =  cast(NOW() as date)
     AND a.sistema IN ('Ti','Eletrica','Terceirizados','Maquinarios')
     GROUP BY u.nome")or die(mysql_error());

Follow the image of the chart:

<!DOCTYPEhtml><htmllang="pt">
    <head>
        <link rel="shortcut icon" href="../img/favicon.ico"/>
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name="description" content="">
        <meta name="author" content="">
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
        <meta http-equiv="refresh" content="30">
        <title>PAINEL DE MONITORAMENTO</title>
        <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script><linkrel="stylesheet" href="bootstrap/style.css">
        <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
        <link rel="stylesheet" href="bootstrap/css/datatables.css">
        <script src="bootstrap/js/jquery.min.js">
        </script>
        <script src="bootstrap/js/bootstrap.min.js">
        </script>
        <script src="bootstrap/js/jquery.dataTables.min.js">
        </script>
        <script src="bootstrap/js/datatables.js">
        </script>
        <style type="text/css">
        </style>
    </head>
    <body>
        <div class="container">
<br />
           <!-- <a href="#" class="btn btn-default btn-lg btn-block"><h3>PAINEL DE MONITORAMENTO</h3></a> -->
<br />
            <div class="row">
                <div class="col-md-6">
                    <div id="tiabertosxfechados"></div>
                </div>

                <div class="col-md-6">
                    <div id="tiabertos"></div>
                </div>

            </div>

<br />
            <div class="row">

                <div class="col-md-6">
                    <div id="eletricaabertosxfechados"></div>
                </div>

                <div class="col-md-6">
                    <div id="eletricaabertos"></div>
                </div>
           </div>
         <div class="row">
                <div class="col-md-12">
                    <div id="rowtec"></div>
                </div>


            </div>
         </div>


            <script type="text/javascript">
                google.charts.load('current', {'packages': ['corechart', 'bar']});

                google.charts.setOnLoadCallback(tiabertos);
                google.charts.setOnLoadCallback(tiabertosxfechados);
                google.charts.setOnLoadCallback(eletricaabertos);
                google.charts.setOnLoadCallback(eletricaabertosxfechados);
                google.charts.setOnLoadCallback(rowtec);



//--Config--
// chartArea: {left:10,top:0,width:'75%',height:'75%'},
function tiabertosxfechados() {

                    var data = google.visualization.arrayToDataTable([
                        ['Effort', 'Amount given'],
                        ['ABERTOS', 2],
                        ['FECHADOS', 0],
                    ]);

                    var options = {
                        pieHole: 0.6,
                        title: 'CHAMADOS DO DIA - TI',
                        legend:{textStyle: {color: '#000000', fontSize: 12}},
                        pieSliceText: 'value',
                        fontSize: 15,
                        colors: ['#4682B4', '#FFCC00'],
                        chartArea: {width:'80%',height:'75%'},
                        is3D: true
                    };

                    var chart = new google.visualization.PieChart(document.getElementById('tiabertosxfechados'));
                    chart.draw(data, options);
                }

function tiabertos() {

                    var data = google.visualization.arrayToDataTable([
                        ['Effort', 'Amount given'],
                        ['ENCAMINHADO', 5],
                        ['AGUARDANDO', 13],
                    ]);

                    var options = {
                        pieHole: 0.6,
                        title: 'CHAMADOS DO DIA - TI',
                        legend:{textStyle: {color: '#000000', fontSize: 12}},
                        pieSliceText: 'value',
                        fontSize: 15,
                        colors: ['#4682B4', '#FFCC00'],
                        chartArea: {width:'80%',height:'75%'},
                        is3D: true
                    };

                    var chart = new google.visualization.PieChart(document.getElementById('tiabertos'));
                    chart.draw(data, options);
                }


function eletricaabertosxfechados() {

                    var data = google.visualization.arrayToDataTable([
                        ['Effort', 'Amount given'],
                        ['ABERTOS', 2],
                        ['FECHADOS', 5],
                    ]);

                    var options = {
                        pieHole: 0.6,
                        title: 'CHAMADOS DO DIA - ELÉTRICA',
                        legend:{textStyle: {color: '#000000', fontSize: 12}},
                        pieSliceText: 'value',
                        fontSize: 15,
                        colors: ['#4682B4', '#FFCC00'],
                        chartArea: {width:'80%',height:'75%'},
                        is3D: true
                    };

                    var chart = new google.visualization.PieChart(document.getElementById('eletricaabertosxfechados'));
                    chart.draw(data, options);
                }
function eletricaabertos() {

                    var data = google.visualization.arrayToDataTable([
                        ['Effort', 'Amount given'],
                        ['ENCAMINHADO', 6],
                        ['AGUARDANDO', 20],
                    ]);

                    var options = {
                        pieHole: 0.6,
                        title: 'CHAMADOS DO DIA - ELÉTRICA',
                        legend:{textStyle: {color: '#000000', fontSize: 12}},
                        pieSliceText: 'value',
                        fontSize: 15,
                        colors: ['#4682B4', '#FFCC00'],
                        chartArea: {width:'80%',height:'75%'},
                        is3D: true
                    };

                    var chart = new google.visualization.PieChart(document.getElementById('eletricaabertos'));
                    chart.draw(data, options);
                }

function rowtec() {
 var data = google.visualization.arrayToDataTable([
             ['Tecnico', 'Chamado'],

               ]);
        var options = {
          chart: {
            title: 'CHAMADOS FECHADOS P/ TÉCNICO',      
          }  
        };

        var chart = new google.charts.Bar(document.getElementById('rowtec'));

        chart.draw(data, options);
      }

            </script>
    </body>
</html>
    
asked by anonymous 09.09.2016 / 22:31

1 answer

1

I saw the first error see if it solved

search the line

echo "['".$row['TECNICO']."',".$row['CHAMADO']."],";

fixes on closing '

I think this is how it would work

 echo "['".$row['TECNICO']."','".$row['CHAMADO']."'],";

I still think this is not the whole error, you need to pass the html processing and not the source code. Run the script in the browser and display the source code and copy it here in another box so I can see what your php is printing (after replacing the line I made)

    
09.09.2016 / 23:43