????

<?php

    include 'security/conn.php';
    include 'utils/parseToUtf8.php';
    // Definindo qual query será executada, com ou sem filtro


    $origem = $_GET['origem'];
    $projeto = $_GET['projeto'];

    $query_status_demanda = "SELECT mantis_bug_table.version  AS VERSAO,
        CASE WHEN mantis_bug_table.version <> ''
        THEN REPLACE(mantis_bug_table.version,'.','')
        END AS VERSAOSEMPONTO,
        CASE WHEN mantis_bug_table.status IN (10,20,30,50)
             THEN 'EM EXECUÇÃO'
             ELSE 'CONCLUÍDO'
        END AS DESCRICAO,
        COUNT(mantis_bug_table.id) AS QUANTIDADE FROM dbmantis_bugs.mantis_bug_table
        INNER JOIN dbmantis_bugs.mantis_custom_field_string_table
                ON (mantis_bug_table.id = mantis_custom_field_string_table.bug_id)
        WHERE (mantis_custom_field_string_table.value = '$origem')
        AND (mantis_bug_table.project_id = $projeto)
        GROUP BY mantis_bug_table.version, DESCRICAO
        ORDER BY mantis_bug_table.version ASC,
    STATUS ASC";


    function getstatusDemanda($conn, $query_status_demanda){

        if (!$result = $conn->query($query_status_demanda)) {
            echo '
                <script>
                    alert("Erro ao executar a query de status demanda.");
                </script>
            ';
            $result->close();
        }
        // DATA CATCH statusS
        while($row = $result->fetch_array(MYSQL_ASSOC)) {
            $rows[]=$row;
        }

        //$result_status_demanda = parseToUtf8($rows);
        if(isset($rows)){
          $result_status_demanda = json_encode($rows);
          $result->close();
        }else{
            $result_status_demanda = null;
        }

        return $result_status_demanda;
    }

    print getstatusDemanda($conn, $query_status_demanda);

    $conn->close();
?>