Creating/Viewing HTML report

Question

Guys, I have a problem and I couldn’t think of a solution ... People who have used iReport know that it has to do grouping very easily in it... The problem is that I am now reporting in HTML ( in the nail rs ), and wanted to group by affiliates ( as example ):

Filial  001 - LOJA TAL
                              column         column          column         column        column
                              dados           dados            dados           dados          dados
                              dados           dados            dados           dados          dados 
                              dados           dados            dados           dados          dados
Total da Filial 001  =        TOTAL          TOTAL           TOTAL          TOTAL         TOTAL

Filial  002 - LOJA TAL
                              column         column          column         column        column
                              dados           dados            dados           dados          dados
                              dados           dados            dados           dados          dados 
                              dados           dados            dados           dados          dados
Total da Filial 002  =        TOTAL          TOTAL           TOTAL          TOTAL         TOTAL

Total Geral           =       TOTAL GERAL

And so on.. in iReport just put a group... But now that I’m doing it in HTML, I can’t find a solution to my problem... Because it’s repeating the name of the branch on all the lines, and I couldn’t think of how to make the total for branch and then the total General...

Example :

Let’s say the numbers come (query result) (1, 1 , 1, 1, 1, 2, 2, 2, 3, 3, 3,) Printar only : 1, 2 , 3.

I have tried to take the values of the branch table and compare with the result of branches that is coming from the query, but it did not work, keeps printing repeatedly.

For example :

 $filias => $this->find(filiais)
 $dadosConsulta['numero_filial'] (este aqui que está vindo repetido, filial para cada resultado)

 if($filiais['numero_filial'] == $dadosConsulta['numero_filial']){
 echo $dadosConsulta['numero_filial'];
 }

I tried something like this above, but it didn’t work either... repeated printava yet. I would like your help ! Thanks.

Edit:

Following image.. At the end when switching from branch 1 to 2 and 2 to 3, so successively, printar Total by Branch, it boils down to this ! Because the way I’m doing it, it’s being printed after every result per seller. Several times.

Answer 1

If it comes all in one select, you can try something like this:

$filialAnterior = -1;
for/while/foreach (o que vc usar para o loop){
     if($filialAnterior === $dadosConsulta['numero_filial']){
        // escreve dados
        // conta total da filial
     }else{
        // mudou filial
        // escreve total da filial
        // abre cabeçalho da nova filial
        // zera total da filial
        $filialAnterior =  $dadosConsulta['numero_filial'];
     }
}