Path: C:\
<!DOCTYPE html>
<html lang="pt-br">
<head>
<meta charset="utf-8" />
<meta http-equiv="x-ua-compatible" content="ie=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1, maximum-scale=1" />
<title>Resumo Financeiro</title>
<link rel="icon" type="image/png" href="../images/favicon.ico">
<link href="../css/style2.css" rel="stylesheet" type="text/css" />
<script src='../js/jquery.min.js'></script>
<script src='../js/tabelas.js'></script>
</head>
<?php
ini_set('max_execution_time',1200);
date_default_timezone_set('America/Sao_Paulo');
$DT=date('d-m-Y_G\hi\m');
$dateadded = date("d/m/Y -- G:i");
$meses = array('','Jan', 'Fev', 'Mar', 'Abr', 'Mai', 'Jun', 'Jul','Ago','Set','Out','Nov','Dez');
$ano= $_POST['from'];
$hoje = date("d-m-Y");
$m1=date('m', strtotime($hoje));
$a1=date('Y', strtotime($hoje));
$inicio='01-01-'.$ano;
if ($ano==$a1){$hoje='01-'.$m1.'-'.$ano;}else{$hoje='31-12-'.$ano;}
$m2= date('m',strtotime($inicio));
$a2= date('Y',strtotime($inicio));
$inicio = date('d-m-Y',strtotime('01-'.$m2.'-'.$a2));
$queryinicio = date('Ymd',strtotime('01-'.$m2.'-'.$a2));
$m1=date('m', strtotime($hoje));
$a1=date('Y', strtotime($hoje));
$m1 = intval($m1);
$m2 = intval($m2);
$ultimo_dia = date("t", mktime(0,0,0,$m1,'01',$a1));
$fim = date('d-m-Y',strtotime($ultimo_dia.'-'.$m1.'-'.$a1));
$queryfim = date('Ymd',strtotime($ultimo_dia.'-'.$m1.'-'.$a1));
for ($i=1;$i<=12;$i++)
{ $ud[$i] = date("t", mktime(0,0,0,$i,'01',$ano));
if ($m1>=$i) {$pes[$i]='S';}else{$pes[$i]='N';}
}
/*
echo ''.$m1.'<br>';
echo ''.$m2.'<br>';
echo ''.$ano.'<br>';
echo ''.$queryinicio.'<br>';
echo ''.$queryfim.'<br>';
for ($i=1;$i<=12;$i++)
{
echo $meses[$i].'='.$pes[$i].'--<br>';
}
*/
for ($mes=1;$mes<=12;$mes++){$ttpaga[$mes]=0;$ttrecebe[$mes]=0;$ttfatura[$mes]=0;for ($dia=1;$dia<=31;$dia++){$recebe[$mes][$dia]=0;$paga[$mes][$dia]=0;$faturadia[$mes][$dia]=0;$fatura[1][$mes][$dia]=0;$fatura[2][$mes][$dia]=0;$fatura[3][$mes][$dia]=0;$fatura[4][$mes][$dia]=0;$fatura[5][$mes][$dia]=0;$fatura[6][$mes][$dia]=0;}}
$ttfaturageral=0;
$ttpagageral=0;
$ttrecebegeral=0;
require_once("../conexao_srvtms.php");
if (!$conn){echo "ATENÇÃO!! FALHA NA CONEXÃO BANCO DE DADOS!";}
for($i=1;$i<=14;$i++){$tg[$i]=0;}
$query1 = sqlsrv_query( $conn, "SELECT CASE
WHEN tp_Lancamento = 'C' THEN 1
WHEN tp_Lancamento = 'D' THEN 2
END as tipo
,MONTH(dt_lancamento) as mes
,DAY(dt_lancamento) as dia
,sum(vl_Lancamento) as valor
,sum(vl_Juros) as juros
,sum(vl_Desconto) as desconto
,sum(vl_Lancamento)+sum(vl_Juros)-sum(vl_Desconto)as saldo
FROM tbdBancario
where dt_lancamento BETWEEN '$queryinicio' and '$queryfim' and rtrim(cd_documento)<>'TRF TRF.'
group by tp_Lancamento, MONTH(dt_lancamento), DAY(dt_lancamento)
order by tp_Lancamento, MONTH(dt_lancamento), DAY(dt_lancamento)", array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
while ($res1 = sqlsrv_fetch_array($query1, SQLSRV_FETCH_ASSOC))
{ if($res1['tipo']=='1')
{ $recebe[$res1['mes']][$res1['dia']]=$res1['saldo'];}
else
{ $paga[$res1['mes']][$res1['dia']]=$res1['saldo'];}
}
$query2 = sqlsrv_query( $conn, "SELECT CASE
WHEN rtrim(b.ds_Pessoa) = 'TRANS WAR - CAMPINAS' THEN 1
WHEN rtrim(b.ds_Pessoa) = 'TRANS WAR - OSASCO' THEN 2
WHEN rtrim(b.ds_Pessoa) = 'TRANS WAR - UBERLANDIA' THEN 3
WHEN rtrim(b.ds_Pessoa) = 'TRANS WAR - GOIANIA' THEN 4
WHEN rtrim(b.ds_Pessoa) = 'TRANS RAW - CAMPINAS' THEN 5
WHEN rtrim(b.ds_Pessoa) = 'TRANS RAW - OSASCO' THEN 6
END as empresa
,MONTH(a.dt_ImpressaoConhecimento) as mes
,DAY(a.dt_ImpressaoConhecimento) as dia
,sum(a.vl_Frete) as faturamento
FROM dtbtransporte.dbo.tbdMovimento AS a
right JOIN dtbtransporte.dbo.tbdPessoa AS b ON a.id_Transportadora=b.id_Pessoa
WHERE a.id_Transportadora<>3059 and Convert(varchar(8), dt_ImpressaoConhecimento,112) BETWEEN '$queryinicio' and '$queryfim'
group by MONTH(a.dt_ImpressaoConhecimento), DAY(a.dt_ImpressaoConhecimento), b.ds_Pessoa
order by empresa, MONTH(a.dt_ImpressaoConhecimento), DAY(a.dt_ImpressaoConhecimento)
", array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
while ($res2 = sqlsrv_fetch_array($query2, SQLSRV_FETCH_ASSOC))
{
$fatura[$res2['empresa']][$res2['mes']][$res2['dia']]=$res2['faturamento'];
}
for ($mes=$m2;$mes<=$m1;++$mes)
{
$resumo[$mes] = '
<style>
table.blue {
border-style:solid;
table-layout:fixed;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
table.blue td {
overflow: hidden;word-wrap: break-word;
}
tr#linha:hover {
background: yellow;
}
</style>
<table width="90%" align="center"><tr width="100%" align="left"><td>
<table class="blue" align="center" cellpadding="2" cellspacing="2">
<col width="4%" />
<col width="8%" />
<col width="8%" />
<col width="10%" />
<col width="10%" />
<col width="10%" />
<col width="10%" />
<col width="10%" />
<col width="10%" />
<col width="10%" />
<col width="10%" />
<tr height="30" style="size=3; font-weight: bold;">
<th align="center" colspan="11" style="color:black; background:#BDBDBD;"><strong>RESUMO FINANCEIRO: '.$meses[$mes].'/'.$ano.'</strong></th>
</tr>
<tr align="center" style="color:white; background:#6D7EA0;">
<th rowspan=2>Dia</th>
<td rowspan=2><b>PAGAMENTO</b></td>
<td rowspan=2><b>RECEBIMENTO</b></td>
<td rowspan=2><b>SALDO</b></td>
<td colspan=7><b>FATURAMENTO</b></td>
</tr>
<tr align="center" style="color:white; background:#6D7EA0;">
<td><b>WAR-CPS</b></td>
<td><b>WAR-SP</b></td>
<td><b>WAR-UDI</b></td>
<td><b>WAR-GYN</b></td>
<td><b>RAW-CPS</b></td>
<td><b>RAW-SP</b></td>
<td><b>TOTAL</b></td>
</tr>
<tbody>';
$bg1=0;$ttpaga[$mes]=0;$ttrecebe[$mes]=0;$ttfatura[$mes]=0;$ttfatura1[$mes]=0;$ttfatura2[$mes]=0;$ttfatura3[$mes]=0;$ttfatura4[$mes]=0;$ttfatura5[$mes]=0;$ttfatura6[$mes]=0;
for ($dia=1; $dia <= $ud[$mes]; $dia++)
{ if ($bg1 == 0)
{$bg="#ffffff";$bg1=1;}
else
{$bg="#BDBDBD";$bg1=0;}
$saldo=$recebe[$mes][$dia]-$paga[$mes][$dia];
$ttpaga[$mes]=$ttpaga[$mes]+$paga[$mes][$dia];
$ttrecebe[$mes]=$ttrecebe[$mes]+$recebe[$mes][$dia];
$faturadia[$mes][$dia]=$fatura[1][$mes][$dia]+$fatura[2][$mes][$dia]+$fatura[3][$mes][$dia]+$fatura[4][$mes][$dia]+$fatura[5][$mes][$dia]+$fatura[6][$mes][$dia];
$ttfatura[$mes]=$ttfatura[$mes]+$faturadia[$mes][$dia];
$ttfatura1[$mes]=$ttfatura1[$mes]+$fatura[1][$mes][$dia];
$ttfatura2[$mes]=$ttfatura2[$mes]+$fatura[2][$mes][$dia];
$ttfatura3[$mes]=$ttfatura3[$mes]+$fatura[3][$mes][$dia];
$ttfatura4[$mes]=$ttfatura4[$mes]+$fatura[4][$mes][$dia];
$ttfatura5[$mes]=$ttfatura5[$mes]+$fatura[5][$mes][$dia];
$ttfatura6[$mes]=$ttfatura6[$mes]+$fatura[6][$mes][$dia];
if ($saldo <0)
{$cle="red";}
else
{$cle="blue";}
$resumo[$mes] .= '
<tr id="linha" bgcolor="'. $bg.'">
<th>'.$dia.'</th>
<td align="right">'.number_format($paga[$mes][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($recebe[$mes][$dia], 2, ',', '.').'</td>
<td align="right" style="font-weight:bold; color:'.$cle.'">'.number_format($saldo, 2, ',', '.').'</td>
<td align="right">'.number_format($fatura[1][$mes][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($fatura[2][$mes][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($fatura[3][$mes][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($fatura[4][$mes][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($fatura[5][$mes][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($fatura[6][$mes][$dia], 2, ',', '.').'</td>
<td align="right" style="font-weight:bold;">'.number_format($faturadia[$mes][$dia], 2, ',', '.').'</td>
</tr>
';
}
$ttsaldo=$ttrecebe[$mes]-$ttpaga[$mes];
if ($ttsaldo <0)
{$cle="red";}
else
{$cle="blue";}
$resumo[$mes] .= '
<tr height="30" align="center" style="color:black; background:yellow;">
<th></th>
<th style="font-weight:bold;" align="right">'.number_format($ttpaga[$mes], 2, ',', '.').'</th>
<td style="font-weight:bold;" align="right">'.number_format($ttrecebe[$mes], 2, ',', '.').'</td>
<td align="right" style="font-weight:bold; color:'.$cle.'">'.number_format($ttsaldo, 2, ',', '.').'</th>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura1[$mes], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura2[$mes], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura3[$mes], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura4[$mes], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura5[$mes], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura6[$mes], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right" style="font-weight:bold;">'.number_format($ttfatura[$mes], 2, ',', '.').'</td>
</tr>
</tbody>
</table></td></tr></table>
';
$ttfaturageral=$ttfaturageral+$ttfatura[$mes];
$ttpagageral=$ttpagageral+$ttpaga[$mes];
$ttrecebegeral=$ttrecebegeral+$ttrecebe[$mes];
}
$resumo[13] = '
<style>
table.blue {
border-style:solid;
table-layout:fixed;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
table.blue td {
overflow: hidden;word-wrap: break-word;
}
tr#linha:hover {
background: yellow;
}
</style>
<table width="90%" align="center"><tr width="100%" align="left"><td>
<table class="blue" align="center" cellpadding="2" cellspacing="2">
<col width="4%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<tr height="30" style="size=3; font-weight: bold;">
<th align="center" colspan="13" style="color:black; background:#BDBDBD;"><strong>RESUMO FINANCEIRO DE PAGAMENTOS EM '.$ano.'</strong></th>
</tr>
<tr align="center" style="color:white; background:#6D7EA0;">
<th>Dia</th>
<td><b>Jan</b></td>
<td><b>Fev</b></td>
<td><b>Mar</b></td>
<td><b>Abr</b></td>
<td><b>Mai</b></td>
<td><b>Jun</b></td>
<td><b>Jul</b></td>
<td><b>Ago</b></td>
<td><b>Set</b></td>
<td><b>Out</b></td>
<td><b>Nov</b></td>
<td><b>Dez</b></td>
</tr>
<tbody>';
for ($dia=1; $dia <= 31; $dia++)
{ if ($bg1 == 0)
{$bg="#ffffff";$bg1=1;}
else
{$bg="#BDBDBD";$bg1=0;}
$resumo[13] .= '
<tr id="linha" bgcolor="'. $bg.'">
<th>'.$dia.'</td>
<td align="right">'.number_format($paga[1][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($paga[2][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($paga[3][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($paga[4][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($paga[5][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($paga[6][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($paga[7][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($paga[8][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($paga[9][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($paga[10][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($paga[11][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($paga[12][$dia], 2, ',', '.').'</td>
</tr>
';
}
$resumo[13] .= '
<tr height="30" align="center" style="color:black; background:yellow;">
<td></td>
<td style="font-weight:bold;" align="right">'.number_format($ttpaga[1], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttpaga[2], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttpaga[3], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttpaga[4], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttpaga[5], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttpaga[6], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttpaga[7], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttpaga[8], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttpaga[9], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttpaga[10], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttpaga[11], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttpaga[12], 2, ',', '.').'</td>
</tr>
<tr height="30" align="center" style="color:black; background:yellow;">
<td></td>
<td style="font-weight:bold;" align="center" colspan=12>'.number_format($ttpagageral, 2, ',', '.').'</td>
</tr>
</tbody>
</table></td></tr></table>
';
$resumo[14] = '
<style>
table.blue {
border-style:solid;
table-layout:fixed;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
table.blue td {
overflow: hidden;word-wrap: break-word;
}
tr#linha:hover {
background: yellow;
}
</style>
<table width="90%" align="center"><tr width="100%" align="left"><td>
<table class="blue" align="center" cellpadding="2" cellspacing="2">
<col width="4%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<tr height="30" style="size=3; font-weight: bold;">
<th align="center" colspan="13" style="color:black; background:#BDBDBD;"><strong>RESUMO FINANCEIRO DE RECEBIMENTOS EM '.$ano.'</strong></th>
</tr>
<tr align="center" style="color:white; background:#6D7EA0;">
<th>Dia</th>
<td><b>Jan</b></td>
<td><b>Fev</b></td>
<td><b>Mar</b></td>
<td><b>Abr</b></td>
<td><b>Mai</b></td>
<td><b>Jun</b></td>
<td><b>Jul</b></td>
<td><b>Ago</b></td>
<td><b>Set</b></td>
<td><b>Out</b></td>
<td><b>Nov</b></td>
<td><b>Dez</b></td>
</tr>
<tbody>';
for ($dia=1; $dia <= 31; $dia++)
{ if ($bg1 == 0)
{$bg="#ffffff";$bg1=1;}
else
{$bg="#BDBDBD";$bg1=0;}
$resumo[14] .= '
<tr id="linha" bgcolor="'. $bg.'">
<th>'.$dia.'</td>
<td align="right">'.number_format($recebe[1][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($recebe[2][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($recebe[3][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($recebe[4][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($recebe[5][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($recebe[6][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($recebe[7][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($recebe[8][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($recebe[9][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($recebe[10][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($recebe[11][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($recebe[12][$dia], 2, ',', '.').'</td>
</tr>
';
}
$resumo[14] .= '
<tr height="30" align="center" style="color:black; background:yellow;">
<td></td>
<td style="font-weight:bold;" align="right">'.number_format($ttrecebe[1], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttrecebe[2], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttrecebe[3], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttrecebe[4], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttrecebe[5], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttrecebe[6], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttrecebe[7], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttrecebe[8], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttrecebe[9], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttrecebe[10], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttrecebe[11], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttrecebe[12], 2, ',', '.').'</td>
</tr>
<tr height="30" align="center" style="color:black; background:yellow;">
<td></td>
<td style="font-weight:bold;" align="center" colspan=12>'.number_format($ttrecebegeral, 2, ',', '.').'</td>
</tr>
</tbody>
</table></td></tr></table>
';
$resumo[15] = '
<style>
table.blue {
border-style:solid;
table-layout:fixed;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
table.blue td {
overflow: hidden;word-wrap: break-word;
}
tr#linha:hover {
background: yellow;
}
</style>
<table width="90%" align="center"><tr width="100%" align="left"><td>
<table class="blue" align="center" cellpadding="2" cellspacing="2">
<col width="4%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<col width="8%" />
<tr height="30" style="size=3; font-weight: bold;">
<th align="center" colspan="13" style="color:black; background:#BDBDBD;"><strong>RESUMO FINANCEIRO DE FATURAMENTO EM '.$ano.'</strong></th>
</tr>
<tr align="center" style="color:white; background:#6D7EA0;">
<th>Dia</th>
<td><b>Jan</b></td>
<td><b>Fev</b></td>
<td><b>Mar</b></td>
<td><b>Abr</b></td>
<td><b>Mai</b></td>
<td><b>Jun</b></td>
<td><b>Jul</b></td>
<td><b>Ago</b></td>
<td><b>Set</b></td>
<td><b>Out</b></td>
<td><b>Nov</b></td>
<td><b>Dez</b></td>
</tr>
<tbody>';
for ($dia=1; $dia <= 31; $dia++)
{ if ($bg1 == 0)
{$bg="#ffffff";$bg1=1;}
else
{$bg="#BDBDBD";$bg1=0;}
$resumo[15] .= '
<tr id="linha" bgcolor="'. $bg.'">
<th>'.$dia.'</td>
<td align="right">'.number_format($faturadia[1][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($faturadia[2][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($faturadia[3][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($faturadia[4][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($faturadia[5][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($faturadia[6][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($faturadia[7][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($faturadia[8][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($faturadia[9][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($faturadia[10][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($faturadia[11][$dia], 2, ',', '.').'</td>
<td align="right">'.number_format($faturadia[12][$dia], 2, ',', '.').'</td>
</tr>
';
}
$resumo[15] .= '
<tr height="30" align="center" style="color:black; background:yellow;">
<td></td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura[1], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura[2], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura[3], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura[4], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura[5], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura[6], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura[7], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura[8], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura[9], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura[10], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura[11], 2, ',', '.').'</td>
<td style="font-weight:bold;" align="right">'.number_format($ttfatura[12], 2, ',', '.').'</td>
</tr>
<tr height="30" align="center" style="color:black; background:yellow;">
<td></td>
<td style="font-weight:bold;" align="center" colspan=12>'.number_format($ttfaturageral, 2, ',', '.').'</td>
</tr>
</tbody>
</table></td></tr></table>
';
$json = json_encode($resumo); // Isto ira converter a array em json
$fopen=fopen('resumo.json','w');
$fwrite=fwrite($fopen,$json);
fclose($fopen);
$data="[['Meses','Faturamento','Pagamento','Recebimento'],";
for ($mes=$m2;$mes<$m1;$mes++)
{ //echo $resumo[$mes];
$data=$data."['".$meses[$mes]."',".$ttfatura[$mes].",".$ttpaga[$mes].",".$ttrecebe[$mes]."],";
}
$data=$data."['".$meses[$mes]."',".$ttfatura[$mes].",".$ttpaga[$mes].",".$ttrecebe[$mes]."]]";
$fopen=fopen('dados1.json','w');
$fwrite=fwrite($fopen,$data);
fclose($fopen);
$data2="[['Meses','Faturado','Pago','Recebido'],";
$data2=$data2."['Totais',".$ttfaturageral.",".$ttpagageral.",".$ttrecebegeral."]]";
$fopen=fopen('dados2.json','w');
$fwrite=fwrite($fopen,$data2);
fclose($fopen);
echo "<script language='JavaScript'>location.href='grafico.php?ano=".$ano."&m1=".$m1."';</script>";
?>
</html>