API-Chart.pm

package GR::Controller::API;
use Mojo::Base 'Mojolicious::Controller';

# This action will render a template
sub classificacao {
    my $self = shift;

    my $schema = $self->schema;

    my $result = [];

    $schema->storage->dbh_do( sub {
        my ( $storage, $dbh, @args ) = @_;
        my $sth = $dbh->prepare("SELECT queue.name AS Filas, COUNT(*) Quantidade FROM ticket, queue  WHERE ticket.create_time  BETWEEN '2015-07-01' and '2015-07-16'  AND ticket.queue_id = queue.id AND queue.valid_id = 1  GROUP BY queue.name;" );
        $sth->execute(@args);

        while ( my $l = $sth->fetchrow_hashref ) {
            push @{$result}, { name => $l->{Filas}, y => $l->{Quantidade}, drilldown => $l->{Filas} };
        }

    } );

    $self->render( json => $result );
}

### Output in browser ###
[{"y":"223","name":"Grupo de Operação Service Desk - SESMA","drilldown":"Grupo de Operação Service Desk - SESMA"},{"y":"56","name":"Grupo Especialista da Cibernix Tecnologia","drilldown":"Grupo Especialista da Cibernix Tecnologia"},{"y":"191","name":"Postmaster","drilldown":"Postmaster"}]

1;