$dados->valor_royalties = (double) $dados->valor_royalties + (double) $num_royalties;
$dados->valor_propaganda = (double) $dados->valor_propaganda + (double) $num_propaganda;
$dados->faturamento = (double) $dados->faturamento + (double) $num_fat;
$num_royalties = number_format($num_royalties, 2, ".", "");
$num_propaganda = number_format($num_propaganda, 2, ".", "");
$num_fat = number_format($num_fat, 2, ".", "");
#dados
$worksheet->write($linha, 0, $dia, $stylecenter);
$worksheet->write($linha, 1, $num_fat, $stylereal);
$worksheet->write($linha, 2, $num_royalties, $stylereal);
$worksheet->write($linha, 3, $num_propaganda, $stylereal);
$worksheet->write($linha, 4, '', $stylebg);
$dia++;
}
if ($imposto != 0 and $imposto != '') {
$despesa = $relatorioDAO->despesasServicoRoyalties($emp->id_empresa, $ano_mes);
$dados->despesa = $despesa->total;
} else {
$despesa->total = 0;
}
#apuração dos royalties
$t_sub_pagar = (double) ((double) $t_num_fat - (double) ((double) $t_num_fat / 100 * (double) $imposto)) - (double) $despesa->total;
$t_pagar = (double) ((double) $t_sub_pagar / 100) * (double) $royalties;
#valor por semestre
$semestre = 0;
$semestre_ext = '';
$semestre_fixo = '';
$semestre_4m = 0;
if ($emp->sem1 != '0.00' and (double) $t_num_fat <= (double) '50000.00') {
$data_sem1 = date("Y-m-d", mktime(0, 0, 0, $ano_mes_exp[1] - 6, 15, $ano_mes_exp[0]));
$data_sem2 = date("Y-m-d", mktime(0, 0, 0, $ano_mes_exp[1] - 12, 15, $ano_mes_exp[0]));