Hi, I've created a report that I'm using for screen presentation and an exported version from the same report. For each of them, I've created a view.php separated file, but the results that I obtained for the exported version and for the HTML output were very different. What comes to my eyes is that all colors are gone. Typography is working fine, but I can't get the results that my customer wants. So my question is, what really works from a Bootstrap CSS for the output on a PDF exported file?
KoolReport's Forum
Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
On a generated PDF from a export, witch Bootstrap formatting really works? #2608
Hi Sebastian, I'm using Export. I didn't know about CloudExport and following your comment, I went back to see how it works... I'm having problems receiving my confirmation and reset emails. None of them arrived at my mailbox. Could you put me in touch with someone from ChromeHeadless.io to help me with that? But coming back to the actual format that I'm using.
This is my Report View Class :
<?php
use koolreport\widgets\google\BarChart;
use koolreport\widgets\google\ColumnChart;
use koolreport\widgets\google\DonutChart;
use koolreport\widgets\google\PieChart;
use koolreport\widgets\koolphp\Table;
?>
<div class="report-content">
<div class="text-center">
<h1 class="display-1 text-muted">Relatório de Vendas</h1>
<h3 class="display-4"> <b>Data de Início:</b> <?php echo $this->params['dtinicio']->format('d/m/Y') ?> <b>Data de Término: </b>
<?php echo $this->params['dtfim']->format('d/m/Y') ?></h3>
</div>
<?php
Table::create( [
"dataSource"=>$this->dataStore('vendas_por_vendedor_data'),
'showFooter' => true,
'colorScheme' => 'more',
"columns"=> [
'Nome' => [
'label' => 'Vendedor',
'footerText' => "<b>Totais Gerais:</b>",
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:center;color:white;background-color:midnightblue",
],
],
'DataPedido' => [
'label' => 'Data do Pedido',
'formatValue' => function ($value,$row) {
return $value->format('d/m/Y');
},
'cssStyle' => [
'td' => "text-align:center",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:center;color:white;background-color:midnightblue",
],
],
'QtdVendas' => [
'label' => 'Qtd Vendas',
'formatValue' => function ($value,$row) {
return formataValor($value,true,0);
},
'cssStyle' => [
'td' => "text-align:center",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:center;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValor($value->sum('QtdVendas'),true,0);
},
'footerText' =>"<b>@value</b>",
],
'ValorTelhas' => [
'label' => 'Valor da Venda',
'formatValue' => function ($value,$row) {
return formataValoresEmReais($value);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValoresEmReais($value->sum('ValorTelhas'));
},
'footerText' =>"<b>@value</b>",
],
'PesoTelhas' => [
'label' => 'Peso KG',
'formatValue' => function ($value, $row) {
return formataValor($value,true,2);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValor($value->sum('PesoTelhas'),true,2);
},
'footerText' => "<b>@value</b>"
],
'TicketMedio' => [
'label' => 'Ticket Médio',
'formatValue' => function ($value, $row, $cKey) {
return ($row['QtdVendas'] > 0)
? formataValoresEmReais($row['ValorTelhas'] / $row['QtdVendas'])
: formataValoresEmReais(0.00);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValoresEmReais($value->sum('ValorTelhas') / $value->sum('QtdVendas'));
},
'footerText' => "<b>@value</b>"
],
'PesoMedio' => [
'label' => 'Valor/KG',
'formatValue' => function ($value, $row, $cKey) {
return ($row['PesoTelhas'] > 0)
? formataValoresEmReais($row['ValorTelhas'] / $row['PesoTelhas'])
: formataValoresEmReais(0.00);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValoresEmReais($value->sum('ValorTelhas') / $value->sum('PesoTelhas'));
},
'footerText' => "<b>@value</b>"
],
'QtdVendasPago' => [
'label' => 'Qtd Vendas (Pg)',
'formatValue' => function ($value) {
return formataValor($value,true,0);
},
'cssStyle' => [
'td' => "text-align:center",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:center;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValor($value->sum('QtdVendasPago'),true,0);
},
'footerText' =>"<b>@value</b>",
],
'ValorTelhasPago' => [
'label' => 'Valor da Venda (Pg)',
'formatValue' => function ($value) {
return formataValoresEmReais($value);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValoresEmReais($value->sum('ValorTelhasPago'));
},
'footerText' =>"<b>@value</b>",
],
'PesoTelhasPago' => [
'label' => 'Peso KG (Pg)',
'formatValue' => function ($value) {
return formataValor($value,true,2);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValor($value->sum('PesoTelhasPago'),true,2);
},
'footerText' => "<b>@value</b>"
],
'TicketMedioPago' => [
'label' => 'Ticket Médio (Pg)',
'formatValue' => function ($value, $row, $cKey) {
return ($row['QtdVendasPago'] > 0)
? formataValoresEmReais($row['ValorTelhasPago'] / $row['QtdVendasPago'])
: formataValoresEmReais(0.00);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return ($value->sum('QtdVendasPago') > 0)
? formataValoresEmReais($value->sum('ValorTelhasPago') / $value->sum('QtdVendasPago'))
: formataValoresEmReais(0.00);
},
'footerText' => "<b>@value</b>"
],
'PesoMedioPago' => [
'label' => 'Valor/KG (Pg)',
'formatValue' => function ($value, $row, $cKey) {
return ($row['PesoTelhasPago'] > 0)
? formataValoresEmReais($row['ValorTelhasPago'] / $row['PesoTelhasPago'])
: formataValoresEmReais(0.00);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return ($value->sum('PesoTelhasPago') > 0.00)
? formataValoresEmReais($value->sum('ValorTelhasPago') / $value->sum('PesoTelhasPago'))
: formataValoresEmReais(0.00);
},
'footerText' => "<b>@value</b>"
],
],
'grouping' => [
'Nome' => [
'calculate' => [
"{sumQtdVendas}" => ['sum','QtdVendas'],
"{sumValorTelhas}" => ['sum','ValorTelhas'],
"{sumPesoTelhas}" => ['sum','PesoTelhas'],
"{avgTicketMedio}" => function ($store) {
return formataValoresEmReais($store->sum('ValorTelhas') / $store->sum('QtdVendas'));
},
"{avgPesoMedio}" => function ($store) {
return formataValoresEmReais($store->sum('ValorTelhas') / $store->sum('PesoTelhas'));
},
"{sumQtdVendasPago}" => ['sum','QtdVendasPago'],
"{sumValorTelhasPago}" => ['sum','ValorTelhasPago'],
"{sumPesoTelhasPago}" => ['sum','PesoTelhasPago'],
"{avgTicketMedioPago}" => function ($store) {
return ($store->sum('QtdVendasPago') > 0)
? formataValoresEmReais($store->sum('ValorTelhasPago') / $store->sum('QtdVendasPago'))
: formataValoresEmReais(0.00);
},
"{avgPesoMedioPago}" => function ($store) {
return ($store->sum('PesoTelhasPago') > 0.00)
? formataValoresEmReais($store->sum('ValorTelhasPago') / $store->sum('PesoTelhasPago'))
: formataValoresEmReais(0.00);
},
],
'bottom' => "<td class='table-dark' colspan=2><b> Total do Vendedor: {Nome}</b></td>
<td class='table-dark' style='text-align: center;'><b>{sumQtdVendas}</b></td>
<td class='table-dark' style='text-align: right;'><b>{sumValorTelhas}</b></td>
<td class='table-dark' style='text-align: right;'><b>{sumPesoTelhas}</b></td>
<td class='table-dark' style='text-align: right;'><b>{avgTicketMedio}</b></td>
<td class='table-dark' style='text-align: right;'><b>{avgPesoMedio}</b></td>
<td class='table-dark' style='text-align: center;'><b>{sumQtdVendasPago}</b></td>
<td class='table-dark' style='text-align: right;'><b>{sumValorTelhasPago}</b></td>
<td class='table-dark' style='text-align: right;'><b>{sumPesoTelhasPago}</b></td>
<td class='table-dark' style='text-align: right;'><b>{avgTicketMedioPago}</b></td>
<td class='table-dark' style='text-align: right;'><b>{avgPesoMedioPago}</b></td>",
],
],
'sorting' => [
'Nome' => 'asc',
'DataPedido' => 'asc',
],
"cssClass" => [
'table' => 'table-primary table-striped table-hover table-bordered',
],
'groupCellsInColumns' => ['Nome'],
]);
?>
</div>
<div class="text-center">
<h1 class="display-1">Gráficos de Vendas</h1>
</div>
<div class="row">
<div class="col-md-6">
<?php
ray($this->dataStore('vendas_por_vendedor')->toArray());
PieChart::create([
'title' => 'Distribuição em Valores',
'dataSource' => $this->dataStore('vendas_por_vendedor'),
'columns' => [
'Nome',
'ValorTelhas' => [
'type' => 'number',
"prefix" => 'R$ ',
]
]
]);
?>
</div>
<div class="col-md-6">
<?php
ray($this->dataStore('metas_vendas'));
ColumnChart::create([
'title' => 'Vendedores X Metas Mensais',
'dataSource' => $this->dataStore('metas_vendas'),
'columns' => [
'Nome',
'ValorTelhas' => [
'label' => 'Valor Vendas',
'formatValue' => function ($value,$row) {
return formataValoresEmReais($value) ;
},
],
'ValorMetaVendedor' => [
'label' => 'Meta',
'formatValue' => function ($value,$row) {
return formataValoresEmReais($value) ;
},
],
],
]);
?>
</div>
</div>
<div class="row">
<div class="col-md-6">
<?php
BarChart::create([
'title' => 'Preço Médio do Aço',
'dataSource' => $this->dataStore('metas_vendas'),
'columns' => [
'Nome',
'PesoMedio' => [
'label' => 'Média Obtida',
'formatValue' => function ($value,$row) {
return formataValoresEmReais($value) ;
},
],
'PrecoMedio' => [
'label' => 'Média Desejada',
'formatValue' => function ($value,$row) {
return formataValoresEmReais($value) ;
},
],
],
]);
?>
</div>
<div class="col-md-6">
<?php
$dados = $this->dataStore('metasvendas_meta_empresa')->toArray()[0];
$resultado = $this->dataStore('resultados');
ray($resultado);
$resultado = $resultado->reject(function ($data) {
return true;
});
ray($resultado);
$row = ['Tipo' => 'Vendas Realizadas', 'Valor' => $dados['PesoTelhas']];
$resultado->push($row);
$aProduzir = ($dados['PesoTelhas'] / $dados['DiasDecorridos']) * $dados['DiasRemanescentes'];
$row = ['Tipo' => 'Vendas Previstas', 'Valor' => $aProduzir ];
$resultado->push($row);
if ($dados['KgAco'] - $aProduzir > 0.00)
{
$row = ['Tipo' => 'Vendas Faltantes', 'Valor' => $dados['KgAco'] - $aProduzir ];
$resultado->push($row);
}
ray($this->dataStore('resultados'));
DonutChart::create([
'title' => 'Previsão de Atingimento de Metas',
'dataSource' => $resultado,
'columns' => [
'Tipo' ,
'Valor' => [
'formatValue' => function ($value) {
return formataValor($value,true,4) . ' Kg.';
}
]
]
])
?>
</div>
</div>
And this is my Report View for PDF output. There are just slight differences that I introduced just to see the output occurring on another form:
<?php
use koolreport\widgets\google\BarChart;
use koolreport\widgets\google\ColumnChart;
use koolreport\widgets\google\DonutChart;
use koolreport\widgets\google\PieChart;
use koolreport\widgets\koolphp\Table;
?>
<html lang="pt-BR">
<body style="margin:0.5cm 1cm 0.5cm 1cm">
<link rel="stylesheet" href="<?php echo asset('css/bootstrap.min.css')?>"
type="text/css" />
<link rel="stylesheet" href="<?php echo asset('css/bootstrap-theme.min.css')?>"
type="text/css" />
<div class="page-header" style="text-align:right"><i>Nacional Telha</i></div>
<div class="page-footer" style="text-align:right">Pág. {pageNum}</div>
<hr/>
<div class="report-content">
<div class="text-center">
<h1 class="display-1 text-muted">Relatório de Vendas</h1>
<h3 class="display-4"> <b>Data de Início:</b> <?php echo $this->params['dtinicio']->format('d/m/Y') ?> <b>Data de Término: </b>
<?php echo $this->params['dtfim']->format('d/m/Y') ?></h3>
</div>
<?php
Table::create( [
"dataSource"=>$this->dataStore('vendas_por_vendedor_data'),
'showFooter' => true,
"columns"=> [
'Nome' => [
'label' => 'Vendedor',
'footerText' => "<b>Totais Gerais:</b>",
'cssStyle' => [
'td' => "text-align:right;font-size=1rem;",
'th' => "text-align:center;color:white;background-color:midnightblue;font-size=1.5rem;",
'tf' => "text-align:center;color:white;background-color:midnightblue;font-size=1.75rem;",
],
],
'DataPedido' => [
'label' => 'Data do Pedido',
'formatValue' => function ($value,$row) {
return $value->format('d/m/Y');
},
'cssStyle' => [
'td' => "text-align:center",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:center;color:white;background-color:midnightblue",
],
],
'QtdVendas' => [
'label' => 'Qtd Vendas',
'formatValue' => function ($value,$row) {
return formataValor($value,true,0);
},
'cssStyle' => [
'td' => "text-align:center",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:center;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValor($value->sum('QtdVendas'),true,0);
},
'footerText' =>"<b>@value</b>",
],
'ValorTelhas' => [
'label' => 'Valor da Venda',
'formatValue' => function ($value,$row) {
return formataValoresEmReais($value);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValoresEmReais($value->sum('ValorTelhas'));
},
'footerText' =>"<b>@value</b>",
],
'PesoTelhas' => [
'label' => 'Peso KG',
'formatValue' => function ($value, $row) {
return formataValor($value,true,2);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValor($value->sum('PesoTelhas'),true,2);
},
'footerText' => "<b>@value</b>"
],
'TicketMedio' => [
'label' => 'Ticket Médio',
'formatValue' => function ($value, $row, $cKey) {
return ($row['QtdVendas'] > 0)
? formataValoresEmReais($row['ValorTelhas'] / $row['QtdVendas'])
: formataValoresEmReais(0.00);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValoresEmReais($value->sum('ValorTelhas') / $value->sum('QtdVendas'));
},
'footerText' => "<b>@value</b>"
],
'PesoMedio' => [
'label' => 'Valor/KG',
'formatValue' => function ($value, $row, $cKey) {
return ($row['PesoTelhas'] > 0)
? formataValoresEmReais($row['ValorTelhas'] / $row['PesoTelhas'])
: formataValoresEmReais(0.00);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValoresEmReais($value->sum('ValorTelhas') / $value->sum('PesoTelhas'));
},
'footerText' => "<b>@value</b>"
],
'QtdVendasPago' => [
'label' => 'Qtd Vendas (Pg)',
'formatValue' => function ($value) {
return formataValor($value,true,0);
},
'cssStyle' => [
'td' => "text-align:center",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:center;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValor($value->sum('QtdVendasPago'),true,0);
},
'footerText' =>"<b>@value</b>",
],
'ValorTelhasPago' => [
'label' => 'Valor da Venda (Pg)',
'formatValue' => function ($value) {
return formataValoresEmReais($value);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValoresEmReais($value->sum('ValorTelhasPago'));
},
'footerText' =>"<b>@value</b>",
],
'PesoTelhasPago' => [
'label' => 'Peso KG (Pg)',
'formatValue' => function ($value) {
return formataValor($value,true,2);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return formataValor($value->sum('PesoTelhasPago'),true,2);
},
'footerText' => "<b>@value</b>"
],
'TicketMedioPago' => [
'label' => 'Ticket Médio (Pg)',
'formatValue' => function ($value, $row, $cKey) {
return ($row['QtdVendasPago'] > 0)
? formataValoresEmReais($row['ValorTelhasPago'] / $row['QtdVendasPago'])
: formataValoresEmReais(0.00);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return ($value->sum('QtdVendasPago') > 0)
? formataValoresEmReais($value->sum('ValorTelhasPago') / $value->sum('QtdVendasPago'))
: formataValoresEmReais(0.00);
},
'footerText' => "<b>@value</b>"
],
'PesoMedioPago' => [
'label' => 'Valor/KG (Pg)',
'formatValue' => function ($value, $row, $cKey) {
return ($row['PesoTelhasPago'] > 0)
? formataValoresEmReais($row['ValorTelhasPago'] / $row['PesoTelhasPago'])
: formataValoresEmReais(0.00);
},
'cssStyle' => [
'td' => "text-align:right",
'th' => "text-align:center;color:white;background-color:midnightblue",
'tf' => "text-align:right;color:white;background-color:midnightblue",
],
'footer' => function ($value) {
return ($value->sum('PesoTelhasPago') > 0.00)
? formataValoresEmReais($value->sum('ValorTelhasPago') / $value->sum('PesoTelhasPago'))
: formataValoresEmReais(0.00);
},
'footerText' => "<b>@value</b>"
],
],
'grouping' => [
'Nome' => [
'calculate' => [
"{sumQtdVendas}" => ['sum','QtdVendas'],
"{sumValorTelhas}" => ['sum','ValorTelhas'],
"{sumPesoTelhas}" => ['sum','PesoTelhas'],
"{avgTicketMedio}" => function ($store) {
return formataValoresEmReais($store->sum('ValorTelhas') / $store->sum('QtdVendas'));
},
"{avgPesoMedio}" => function ($store) {
return formataValoresEmReais($store->sum('ValorTelhas') / $store->sum('PesoTelhas'));
},
"{sumQtdVendasPago}" => ['sum','QtdVendasPago'],
"{sumValorTelhasPago}" => ['sum','ValorTelhasPago'],
"{sumPesoTelhasPago}" => ['sum','PesoTelhasPago'],
"{avgTicketMedioPago}" => function ($store) {
return ($store->sum('QtdVendasPago') > 0)
? formataValoresEmReais($store->sum('ValorTelhasPago') / $store->sum('QtdVendasPago'))
: formataValoresEmReais(0.00);
},
"{avgPesoMedioPago}" => function ($store) {
return ($store->sum('PesoTelhasPago') > 0.00)
? formataValoresEmReais($store->sum('ValorTelhasPago') / $store->sum('PesoTelhasPago'))
: formataValoresEmReais(0.00);
},
],
'bottom' => "<td class='text-muted h5' colspan=2><b> Total do Vendedor: {Nome}</b></td>
<td class='text-muted h5' style='text-align: center;'><b>{sumQtdVendas}</b></td>
<td class='text-muted h5' style='text-align: right;'><b>{sumValorTelhas}</b></td>
<td class='text-muted h5' style='text-align: right;'><b>{sumPesoTelhas}</b></td>
<td class='text-muted h5' style='text-align: right;'><b>{avgTicketMedio}</b></td>
<td class='text-muted h5' style='text-align: right;'><b>{avgPesoMedio}</b></td>
<td class='text-muted h5' style='text-align: center;'><b>{sumQtdVendasPago}</b></td>
<td class='text-muted h5' style='text-align: right;'><b>{sumValorTelhasPago}</b></td>
<td class='text-muted h5' style='text-align: right;'><b>{sumPesoTelhasPago}</b></td>
<td class='text-muted h5' style='text-align: right;'><b>{avgTicketMedioPago}</b></td>
<td class='text-muted h5' style='text-align: right;'><b>{avgPesoMedioPago}</b></td>",
],
],
'sorting' => [
'Nome' => 'asc',
'DataPedido' => 'asc',
],
"cssClass" => [
'table' => 'table-striped table-bordered small',
],
'groupCellsInColumns' => ['Nome'],
]);
?>
</div>
<div class="page-break"></div>
<div class="text-center">
<h1 class="display-1">Gráficos de Vendas</h1>
</div>
<div class="row">
<div class="col-md-6">
<?php
ray($this->dataStore('vendas_por_vendedor')->toArray());
PieChart::create([
'title' => 'Distribuição em Valores',
'dataSource' => $this->dataStore('vendas_por_vendedor'),
'columns' => [
'Nome',
'ValorTelhas' => [
'type' => 'number',
"prefix" => 'R$ ',
]
]
]);
?>
</div>
<div class="col-md-6">
<?php
ray($this->dataStore('metas_vendas'));
ColumnChart::create([
'title' => 'Vendedores X Metas Mensais',
'dataSource' => $this->dataStore('metas_vendas'),
'columns' => [
'Nome',
'ValorTelhas' => [
'label' => 'Valor Vendas',
'formatValue' => function ($value,$row) {
return formataValoresEmReais($value) ;
},
],
'ValorMetaVendedor' => [
'label' => 'Meta',
'formatValue' => function ($value,$row) {
return formataValoresEmReais($value) ;
},
],
],
]);
?>
</div>
</div>
<div class="row">
<div class="col-md-6">
<?php
BarChart::create([
'title' => 'Preço Médio do Aço',
'dataSource' => $this->dataStore('metas_vendas'),
'columns' => [
'Nome',
'PesoMedio' => [
'label' => 'Média Obtida',
'formatValue' => function ($value,$row) {
return formataValoresEmReais($value) ;
},
],
'PrecoMedio' => [
'label' => 'Média Desejada',
'formatValue' => function ($value,$row) {
return formataValoresEmReais($value) ;
},
],
],
]);
?>
</div>
<div class="col-md-6">
<?php
$dados = $this->dataStore('metasvendas_meta_empresa')->toArray()[0];
ray($dados);
$resultado = $this->dataStore('resultados');
ray($resultado);
$resultado = $resultado->reject(function ($data) {
return true;
});
ray($resultado);
$row = ['Tipo' => 'Vendas Realizadas', 'Valor' => $dados['PesoTelhas']];
$resultado->push($row);
$aProduzir = ($dados['DiasRemanescentes'] == 0) ? 0.00 : ($dados['PesoTelhas'] / $dados['DiasDecorridos'])
* $dados['DiasRemanescentes'];
$row = ['Tipo' => 'Vendas Previstas', 'Valor' => $aProduzir ];
$resultado->push($row);
if ($dados['KgAco'] - $aProduzir > 0.00)
{
$row = ['Tipo' => 'Vendas Faltantes', 'Valor' => $dados['KgAco'] - $aProduzir ];
$resultado->push($row);
}
ray($this->dataStore('resultados'));
DonutChart::create([
'title' => 'Previsão de Atingimento de Metas',
'dataSource' => $resultado,
'columns' => [
'Tipo' ,
'Valor' => [
'formatValue' => function ($value) {
return formataValor($value,true,4) . ' Kg.';
}
]
]
])
?>
</div>
</div>
</body>
</html>
Html Report generated :
PDF REport Generated:
Pls use "useLocalTempFolder" setting when you export like this:
$report->run()->export("MyReportPDF")
->settings([
'useLocalTempFolder' => true,
])
->pdf(array(
...
))
->toBrowser("MyReport.pdf");
Then run export and look for the latest .tmp file in your report folder's tmp subfolder. Change its name to .html and open it in browser to see if the style is as you expected or not. Let us know the result with screenshots if possible. Tks,
Hi Sebastian, Showing you the obtained results:
Produced HTML:
<html lang="pt-BR">
<head>
<title>Relatório</title>
<meta charset="UTF-8">
</head>
<body style="margin:0.5cm 1cm 0.5cm 1cm"><script type='text/javascript' src='/koolreport_assets/3186757410/KoolReport.js'></script><script type='text/javascript'>KoolReport.load.resources({"js":["\/koolreport_assets\/421826660\/jquery.min.js",["\/koolreport_assets\/3978417450\/js\/bootstrap.min.js"]],"css":["\/koolreport_assets\/3978417450\/css\/bootstrap.min.css","\/koolreport_assets\/3978417450\/css\/bootstrap-theme.min.css"]});</script><script type='text/javascript'>KoolReport.load.resources({"js":["\/koolreport_assets\/421826660\/jquery.min.js",["\/koolreport_assets\/331824987\/bootstrap.bundle.min.js"]],"css":["\/koolreport_assets\/331824987\/amazing.min.css","\/koolreport_assets\/535633218\/css\/font-awesome.min.css","\/koolreport_assets\/1963501392\/simple-line-icons.min.css"]});</script>
<div class="page-header" style="text-align:right"><i>Nacional Telha</i></div>
<div class="page-footer" style="text-align:right">Pág. {pageNum}</div>
<hr/>
<div class="report-content">
<div class="text-center">
<h1 class="display-1 text-muted">Relatório de Vendas</h1>
<h3 class="display-4"> <b>Data de Início:</b> 01/03/2022 <b>Data de Término: </b>
17/03/2022</h3>
</div>
<krwidget widget-name='ktable6233e712aff891' widget-type='koolreport/widgets/koolphp/Table' class='amazing'><div class="koolphp-table " id="ktable6233e712aff891">
<table class='table table-striped table-bordered small'>
<thead>
<tr>
<th style='text-align:center;color:white;background-color:midnightblue;font-size=150%;'>Vendedor</th><th style='text-align:center;color:white;background-color:midnightblue'>Data do Pedido</th><th style='text-align:center;color:white;background-color:midnightblue'>Qtd Vendas</th><th style='text-align:center;color:white;background-color:midnightblue'>Valor da Venda</th><th style='text-align:center;color:white;background-color:midnightblue'>Peso KG</th><th style='text-align:center;color:white;background-color:midnightblue'>Ticket Médio</th><th style='text-align:center;color:white;background-color:midnightblue'>Valor/KG</th><th style='text-align:center;color:white;background-color:midnightblue'>Qtd Vendas (Pg)</th><th style='text-align:center;color:white;background-color:midnightblue'>Valor da Venda (Pg)</th><th style='text-align:center;color:white;background-color:midnightblue'>Peso KG (Pg)</th><th style='text-align:center;color:white;background-color:midnightblue'>Ticket Médio (Pg)</th><th style='text-align:center;color:white;background-color:midnightblue'>Valor/KG (Pg)</th> </tr>
</thead>
<tbody>
<tr ri='0'>
<td rv="Alexandra Pereira de Jesus" style='text-align:right;font-size=120%;font-weight=600;' >
Alexandra Pereira de Jesus </td>
<td rv="2022-03-02 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
02/03/2022 </td>
<td rv="3" style='text-align:center;font-size=120%;font-weight=600;' >
3 </td>
<td rv="2354.80975" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 2.354,81 </td>
<td rv="203.0978" style='text-align:right;font-size=120%;font-weight=600;' >
203,10 </td>
<td rv="2354.80975" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 784,94 </td>
<td rv="24.782084468665" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 11,59 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='1'>
<td rv="Alexandra Pereira de Jesus" style='text-align:right;font-size=120%;font-weight=600;' >
Alexandra Pereira de Jesus </td>
<td rv="2022-03-03 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
03/03/2022 </td>
<td rv="6" style='text-align:center;font-size=120%;font-weight=600;' >
6 </td>
<td rv="79929.09131" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 79.929,09 </td>
<td rv="6188.5063" style='text-align:right;font-size=120%;font-weight=600;' >
6.188,51 </td>
<td rv="79929.09131" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13.321,52 </td>
<td rv="52.97599193133" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 12,92 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='2'>
<td rv="Alexandra Pereira de Jesus" style='text-align:right;font-size=120%;font-weight=600;' >
Alexandra Pereira de Jesus </td>
<td rv="2022-03-04 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
04/03/2022 </td>
<td rv="4" style='text-align:center;font-size=120%;font-weight=600;' >
4 </td>
<td rv="47936.29055" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 47.936,29 </td>
<td rv="3621.923" style='text-align:right;font-size=120%;font-weight=600;' >
3.621,92 </td>
<td rv="47936.29055" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 11.984,07 </td>
<td rv="52.880122609783" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,24 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='3'>
<td rv="Alexandra Pereira de Jesus" style='text-align:right;font-size=120%;font-weight=600;' >
Alexandra Pereira de Jesus </td>
<td rv="2022-03-08 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
08/03/2022 </td>
<td rv="7" style='text-align:center;font-size=120%;font-weight=600;' >
7 </td>
<td rv="74282.53885" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 74.282,54 </td>
<td rv="5696.9043" style='text-align:right;font-size=120%;font-weight=600;' >
5.696,90 </td>
<td rv="74282.53885" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 10.611,79 </td>
<td rv="92.101936966335" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,04 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='4'>
<td rv="Alexandra Pereira de Jesus" style='text-align:right;font-size=120%;font-weight=600;' >
Alexandra Pereira de Jesus </td>
<td rv="2022-03-09 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
09/03/2022 </td>
<td rv="3" style='text-align:center;font-size=120%;font-weight=600;' >
3 </td>
<td rv="16367.01704" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 16.367,02 </td>
<td rv="1294.4081" style='text-align:right;font-size=120%;font-weight=600;' >
1.294,41 </td>
<td rv="16367.01704" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 5.455,67 </td>
<td rv="38.726960625941" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 12,64 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='5'>
<td rv="Alexandra Pereira de Jesus" style='text-align:right;font-size=120%;font-weight=600;' >
Alexandra Pereira de Jesus </td>
<td rv="2022-03-10 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
10/03/2022 </td>
<td rv="6" style='text-align:center;font-size=120%;font-weight=600;' >
6 </td>
<td rv="47497.96397" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 47.497,96 </td>
<td rv="3553.6575" style='text-align:right;font-size=120%;font-weight=600;' >
3.553,66 </td>
<td rv="47497.96397" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 7.916,33 </td>
<td rv="82.124710768571" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,37 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='6'>
<td rv="Alexandra Pereira de Jesus" style='text-align:right;font-size=120%;font-weight=600;' >
Alexandra Pereira de Jesus </td>
<td rv="2022-03-11 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
11/03/2022 </td>
<td rv="3" style='text-align:center;font-size=120%;font-weight=600;' >
3 </td>
<td rv="13673.5868" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13.673,59 </td>
<td rv="1023.3428" style='text-align:right;font-size=120%;font-weight=600;' >
1.023,34 </td>
<td rv="13673.5868" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 4.557,86 </td>
<td rv="38.370171663898" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,36 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='7'>
<td rv="Alexandra Pereira de Jesus" style='text-align:right;font-size=120%;font-weight=600;' >
Alexandra Pereira de Jesus </td>
<td rv="2022-03-14 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
14/03/2022 </td>
<td rv="5" style='text-align:center;font-size=120%;font-weight=600;' >
5 </td>
<td rv="41092.31663" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 41.092,32 </td>
<td rv="3110.5085" style='text-align:right;font-size=120%;font-weight=600;' >
3.110,51 </td>
<td rv="41092.31663" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 8.218,46 </td>
<td rv="65.889922671844" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,21 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='8'>
<td rv="Alexandra Pereira de Jesus" style='text-align:right;font-size=120%;font-weight=600;' >
Alexandra Pereira de Jesus </td>
<td rv="2022-03-15 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
15/03/2022 </td>
<td rv="2" style='text-align:center;font-size=120%;font-weight=600;' >
2 </td>
<td rv="38914.91333" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 38.914,91 </td>
<td rv="2842.8921" style='text-align:right;font-size=120%;font-weight=600;' >
2.842,89 </td>
<td rv="38914.91333" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 19.457,46 </td>
<td rv="27.316839393812" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,69 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='9'>
<td rv="Alexandra Pereira de Jesus" style='text-align:right;font-size=120%;font-weight=600;' >
Alexandra Pereira de Jesus </td>
<td rv="2022-03-16 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
16/03/2022 </td>
<td rv="2" style='text-align:center;font-size=120%;font-weight=600;' >
2 </td>
<td rv="14915.14575" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 14.915,15 </td>
<td rv="1139.0946" style='text-align:right;font-size=120%;font-weight=600;' >
1.139,09 </td>
<td rv="14915.14575" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 7.457,57 </td>
<td rv="26.247405991106" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,09 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr from='0' to='10' class='row-group' ><td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: center; font-size=150%;' colspan=2><b> Total do Vendedor: Alexandra Pereira de Jesus</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: center; font-size=150%;'><b>41</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right;'><b>R$ 376.963,67</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right; font-size=150%;'><b>28.674,34</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right; font-size=150%;'><b>R$ 9.194,24</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right; font-size=150%;'><b>R$ 13,15</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: center; font-size=150%;'><b>0</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right; font-size=150%;'><b>R$ 0,00</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right; font-size=150%;'><b>0,00</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right; font-size=150%;'><b>R$ 0,00</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right; font-size=150%;'><b>R$ 0,00</b></td></tr> <tr ri='10'>
<td rv="Andressa Lopes" style='text-align:right;font-size=120%;font-weight=600;' >
Andressa Lopes </td>
<td rv="2022-03-01 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
01/03/2022 </td>
<td rv="3" style='text-align:center;font-size=120%;font-weight=600;' >
3 </td>
<td rv="2990.60202" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 2.990,60 </td>
<td rv="220.7505" style='text-align:right;font-size=120%;font-weight=600;' >
220,75 </td>
<td rv="2990.60202" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 996,87 </td>
<td rv="40.60788009402" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,55 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='11'>
<td rv="Andressa Lopes" style='text-align:right;font-size=120%;font-weight=600;' >
Andressa Lopes </td>
<td rv="2022-03-02 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
02/03/2022 </td>
<td rv="2" style='text-align:center;font-size=120%;font-weight=600;' >
2 </td>
<td rv="20147.85768" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 20.147,86 </td>
<td rv="1437.017" style='text-align:right;font-size=120%;font-weight=600;' >
1.437,02 </td>
<td rv="20147.85768" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 10.073,93 </td>
<td rv="31.230094345096" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 14,02 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='12'>
<td rv="Andressa Lopes" style='text-align:right;font-size=120%;font-weight=600;' >
Andressa Lopes </td>
<td rv="2022-03-03 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
03/03/2022 </td>
<td rv="3" style='text-align:center;font-size=120%;font-weight=600;' >
3 </td>
<td rv="21917.73431" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 21.917,73 </td>
<td rv="1626.544" style='text-align:right;font-size=120%;font-weight=600;' >
1.626,54 </td>
<td rv="21917.73431" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 7.305,91 </td>
<td rv="40.606795662169" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,48 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='13'>
<td rv="Andressa Lopes" style='text-align:right;font-size=120%;font-weight=600;' >
Andressa Lopes </td>
<td rv="2022-03-04 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
04/03/2022 </td>
<td rv="5" style='text-align:center;font-size=120%;font-weight=600;' >
5 </td>
<td rv="6709.80491" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 6.709,80 </td>
<td rv="503.7442" style='text-align:right;font-size=120%;font-weight=600;' >
503,74 </td>
<td rv="6709.80491" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 1.341,96 </td>
<td rv="54.052735802536" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,32 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='14'>
<td rv="Andressa Lopes" style='text-align:right;font-size=120%;font-weight=600;' >
Andressa Lopes </td>
<td rv="2022-03-07 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
07/03/2022 </td>
<td rv="5" style='text-align:center;font-size=120%;font-weight=600;' >
5 </td>
<td rv="42854.49753" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 42.854,50 </td>
<td rv="3222.8472" style='text-align:right;font-size=120%;font-weight=600;' >
3.222,85 </td>
<td rv="42854.49753" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 8.570,90 </td>
<td rv="66.426952630126" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,30 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='15'>
<td rv="Andressa Lopes" style='text-align:right;font-size=120%;font-weight=600;' >
Andressa Lopes </td>
<td rv="2022-03-08 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
08/03/2022 </td>
<td rv="4" style='text-align:center;font-size=120%;font-weight=600;' >
4 </td>
<td rv="11246.58462" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 11.246,58 </td>
<td rv="846.0005" style='text-align:right;font-size=120%;font-weight=600;' >
846,00 </td>
<td rv="11246.58462" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 2.811,65 </td>
<td rv="54.081204568882" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,29 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='16'>
<td rv="Andressa Lopes" style='text-align:right;font-size=120%;font-weight=600;' >
Andressa Lopes </td>
<td rv="2022-03-09 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
09/03/2022 </td>
<td rv="2" style='text-align:center;font-size=120%;font-weight=600;' >
2 </td>
<td rv="9931.43721" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 9.931,44 </td>
<td rv="745.744" style='text-align:right;font-size=120%;font-weight=600;' >
745,74 </td>
<td rv="9931.43721" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 4.965,72 </td>
<td rv="26.89377112741" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,32 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='17'>
<td rv="Andressa Lopes" style='text-align:right;font-size=120%;font-weight=600;' >
Andressa Lopes </td>
<td rv="2022-03-10 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
10/03/2022 </td>
<td rv="3" style='text-align:center;font-size=120%;font-weight=600;' >
3 </td>
<td rv="3865.36669" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 3.865,37 </td>
<td rv="287.5445" style='text-align:right;font-size=120%;font-weight=600;' >
287,54 </td>
<td rv="3865.36669" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 1.288,46 </td>
<td rv="40.33988274545" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,44 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='18'>
<td rv="Andressa Lopes" style='text-align:right;font-size=120%;font-weight=600;' >
Andressa Lopes </td>
<td rv="2022-03-11 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
11/03/2022 </td>
<td rv="6" style='text-align:center;font-size=120%;font-weight=600;' >
6 </td>
<td rv="26182.40268" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 26.182,40 </td>
<td rv="1959.1314" style='text-align:right;font-size=120%;font-weight=600;' >
1.959,13 </td>
<td rv="26182.40268" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 4.363,73 </td>
<td rv="80.411350681697" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,36 </td>
<td rv="1" style='text-align:center;font-size=120%;font-weight=600;' >
1 </td>
<td rv="1894.90483" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 1.894,90 </td>
<td rv="140.928" style='text-align:right;font-size=120%;font-weight=600;' >
140,93 </td>
<td rv="1894.90483" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 1.894,90 </td>
<td rv="13.445907342757" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,45 </td>
</tr>
<tr ri='19'>
<td rv="Andressa Lopes" style='text-align:right;font-size=120%;font-weight=600;' >
Andressa Lopes </td>
<td rv="2022-03-14 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
14/03/2022 </td>
<td rv="3" style='text-align:center;font-size=120%;font-weight=600;' >
3 </td>
<td rv="5995.71697" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 5.995,72 </td>
<td rv="451.5935" style='text-align:right;font-size=120%;font-weight=600;' >
451,59 </td>
<td rv="5995.71697" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 1.998,57 </td>
<td rv="40.066038122999" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,28 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='20'>
<td rv="Andressa Lopes" style='text-align:right;font-size=120%;font-weight=600;' >
Andressa Lopes </td>
<td rv="2022-03-15 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
15/03/2022 </td>
<td rv="4" style='text-align:center;font-size=120%;font-weight=600;' >
4 </td>
<td rv="32906.49255" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 32.906,49 </td>
<td rv="2423.0205" style='text-align:right;font-size=120%;font-weight=600;' >
2.423,02 </td>
<td rv="32906.49255" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 8.226,62 </td>
<td rv="53.84396989958" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,58 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr from='10' to='21' class='row-group' ><td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: center; font-size=150%;' colspan=2><b> Total do Vendedor: Andressa Lopes</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: center; font-size=150%;'><b>40</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right;'><b>R$ 184.748,50</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right; font-size=150%;'><b>13.723,94</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right; font-size=150%;'><b>R$ 4.618,71</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right; font-size=150%;'><b>R$ 13,46</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: center; font-size=150%;'><b>1</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right; font-size=150%;'><b>R$ 1.894,90</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right; font-size=150%;'><b>140,93</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right; font-size=150%;'><b>R$ 1.894,90</b></td>
<td class='text-muted small' style='color: yellow; background-color: midnightblue; text-align: right; font-size=150%;'><b>R$ 13,45</b></td></tr> <tr ri='21'>
<td rv="André Fernandes" style='text-align:right;font-size=120%;font-weight=600;' >
André Fernandes </td>
<td rv="2022-03-01 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
01/03/2022 </td>
<td rv="4" style='text-align:center;font-size=120%;font-weight=600;' >
4 </td>
<td rv="8489.34614" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 8.489,35 </td>
<td rv="613.257" style='text-align:right;font-size=120%;font-weight=600;' >
613,26 </td>
<td rv="8489.34614" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 2.122,34 </td>
<td rv="54.173525901729" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,84 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='22'>
<td rv="André Fernandes" style='text-align:right;font-size=120%;font-weight=600;' >
André Fernandes </td>
<td rv="2022-03-02 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
02/03/2022 </td>
<td rv="5" style='text-align:center;font-size=120%;font-weight=600;' >
5 </td>
<td rv="16003.36694" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 16.003,37 </td>
<td rv="1217.8528" style='text-align:right;font-size=120%;font-weight=600;' >
1.217,85 </td>
<td rv="16003.36694" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 3.200,67 </td>
<td rv="52.631168903982" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,14 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='23'>
<td rv="André Fernandes" style='text-align:right;font-size=120%;font-weight=600;' >
André Fernandes </td>
<td rv="2022-03-03 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
03/03/2022 </td>
<td rv="1" style='text-align:center;font-size=120%;font-weight=600;' >
1 </td>
<td rv="463.796" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 463,80 </td>
<td rv="34.498" style='text-align:right;font-size=120%;font-weight=600;' >
34,50 </td>
<td rv="463.796" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 463,80 </td>
<td rv="13.444141689373" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,44 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='24'>
<td rv="André Fernandes" style='text-align:right;font-size=120%;font-weight=600;' >
André Fernandes </td>
<td rv="2022-03-04 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
04/03/2022 </td>
<td rv="6" style='text-align:center;font-size=120%;font-weight=600;' >
6 </td>
<td rv="28548.41889" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 28.548,42 </td>
<td rv="2140.9312" style='text-align:right;font-size=120%;font-weight=600;' >
2.140,93 </td>
<td rv="28548.41889" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 4.758,07 </td>
<td rv="79.051474074288" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 13,33 </td>
<td rv="0" style='text-align:center;font-size=120%;font-weight=600;' >
0 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
<td rv="0" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 0,00 </td>
</tr>
<tr ri='25'>
<td rv="André Fernandes" style='text-align:right;font-size=120%;font-weight=600;' >
André Fernandes </td>
<td rv="2022-03-07 00:00:00" style='text-align:center;font-size=120%;font-weight=600;' >
07/03/2022 </td>
<td rv="3" style='text-align:center;font-size=120%;font-weight=600;' >
3 </td>
<td rv="15843.75839" style='text-align:right;font-size=120%;font-weight=600;' >
R$ 15.843,76 </td>
<td rv="1179.905" style='text-align:right;font-size=120%;font-weight=600;' >
1.179,91 </td>
I think the good news is that the .tmp file has all the correct js, css paths. It's just that Phantomjs headless browser used by Export doesn't render PDF exactly like the web view. Pls try to add the following CSS style to your PDF view file:
<!-- MyReportPDF.view.php -->
<style>
* {
-webkit-print-color-adjust: exact !important;
}
@media print {
* {
-webkit-print-color-adjust: exact !important;
}
}
</style>
How do you install Phantomjs for "koolreport/export/bin" on your dev environment? Pls try to download the binary file from this link:
Build Your Excellent Data Report
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo