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= $_GET['ano'];
$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('Y-m-d',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('Y-m-d',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';}
}
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;
$json_pag=json_decode(file_get_contents('json/pagamento.json'), true);
$json_rec=json_decode(file_get_contents('json/recebimento.json'), true);
$json_fat=json_decode(file_get_contents('json/faturamento.json'), true);
for($i=1;$i<=14;$i++){$tg[$i]=0;}
foreach($json_pag as $dt_pag => $pg){
if($dt_pag>='2023-06-01' and $dt_pag<=$queryfim){
$mes_pg=intval(substr($dt_pag, 5,2));
$dia_pg=intval(substr($dt_pag, 8,2));
$paga[$mes_pg][$dia_pg]=$pg['valor'];
//echo 'paga:'.$paga[$mes_pg][$dia_pg].'<br>';
}
}
foreach($json_rec as $dt_rec => $rc){
if($dt_rec>='2023-08-01' and $dt_rec<=$queryfim){
$mes_rc=intval(substr($dt_rec, 5,2));
$dia_rc=intval(substr($dt_rec, 8,2));
$recebe[$mes_rc][$dia_rc]=$rc['valor'];
//echo 'recebe:'.$recebe[$mes_rc][$dia_rc].'<br>';
}
}
$fil["187557"]= 1;
$fil["187562"]= 2;
$fil["187571"]= 3;
$fil["187563"]= 4;
$fil["187573"]= 5;
$fil["187581"]= 6;
foreach($json_fat as $firma => $fat){
foreach($fat as $dt_fat => $ft){
if($dt_fat>='2023-08-01' and $dt_fat<=$queryfim){
$mes_ft=intval(substr($dt_fat, 5,2));
$dia_ft=intval(substr($dt_fat, 8,2));
$fatura[$fil[$firma]][$mes_ft][$dia_ft]=$ft['valor'];
//echo 'fatura: '.$fatura[$fil[$firma]][$mes_ft][$dia_ft].'<br>';
}
}
}
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('json/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('json/dados1.json','w');
$fwrite=fwrite($fopen,$data);
fclose($fopen);
$data2="[['Meses','Faturado','Pago','Recebido'],";
$data2=$data2."['Totais',".$ttfaturageral.",".$ttpagageral.",".$ttrecebegeral."]]";
$fopen=fopen('json/dados2.json','w');
$fwrite=fwrite($fopen,$data2);
fclose($fopen);
echo "<script language='JavaScript'>location.href='grafico.php?ano=".$ano."&m1=".$m1."';</script>";
?>
</html>