"; ?>
Ano Base :
$ano"; } else { echo "
"; } for ($i = $xx; $i >= 2007 ; $i--) { echo "
$i"; } ?>
Visualizando:
$mes/$ano
"; } ?>
Conta
Sub-Conta
JAN
FEV
MAR
ABR
MAI
JUN
JUL
AGO
SET
OUT
NOV
DEZ
Valor.
= '$diaini' AND CAIX_DTA_MOV <= '$diafim' GROUP BY CAIX_CTAS_CTA_ID ,CAIX_CTAS_ID ,CTA_DESCRICAO ,CTAS_DESCRICAO"; $sth = ibase_query($dbh, $stmt); while ($row = ibase_fetch_object ($sth)) { $nSaldo = $nSaldo - $row->CAIX_VALOR; if ($nSaldo >= 0) $pn = 3; else $pn = 6; $cont_reg++; // $valorfat = number_format($row->FAT_VLRFAT, 2, ',', '.'); $data = FormatDate2($row->CAIX_DTA_MOV); $reg = $reg + 1; $tg = number_format($row->CAIX_VALOR, 2, ',', '.'); $m1 = 0; $m2 = 0; $m3 = 0; $m4 = 0; $m5 = 0; $m6 = 0; $m7 = 0; $m8 = 0; $m9 = 0; $m10 = 0; $m11 = 0; $m12 = 0; $stmt2="select extract(month FROM CAIX_DTA_MOV) mes, SUM(CAIX_VALOR) CAIX_VALOR from CAIXA, CONTA, CONTA_S where CAIX_CTAS_ID = CTAS_ID and CAIX_CTAS_CTA_ID = CTA_ID and CTAS_CTA_ID = CTA_ID and CTAS_ES = 'S' and CAIX_EMP_ID = $cemp AND CAIX_DTA_MOV >= '$diaini' AND CAIX_DTA_MOV <= '$diafim' and CAIX_CTAS_CTA_ID = $row->CAIX_CTAS_CTA_ID and CAIX_CTAS_ID = $row->CAIX_CTAS_ID group by extract(month FROM CAIX_DTA_MOV) "; $sth2 = ibase_query($dbh, $stmt2); while ($row2 = ibase_fetch_object ($sth2)) { if ($row2->MES == 1) $m1 = $row2->CAIX_VALOR; if ($row2->MES == 2) $m2 = $row2->CAIX_VALOR; if ($row2->MES == 3) $m3 = $row2->CAIX_VALOR; if ($row2->MES == 4) $m4 = $row2->CAIX_VALOR; if ($row2->MES == 5) $m5 = $row2->CAIX_VALOR; if ($row2->MES == 6) $m6 = $row2->CAIX_VALOR; if ($row2->MES == 7) $m7 = $row2->CAIX_VALOR; if ($row2->MES == 8) $m8 = $row2->CAIX_VALOR; if ($row2->MES == 9) $m9 = $row2->CAIX_VALOR; if ($row2->MES == 10) $m10 = $row2->CAIX_VALOR; if ($row2->MES == 11) $m11 = $row2->CAIX_VALOR; if ($row2->MES == 12) $m12 = $row2->CAIX_VALOR; } $mv1 = $m1; $mv2 = $m2; $mv3 = $m3; $mv4 = $m4; $mv5 = $m5; $mv6 = $m6; $mv7 = $m7; $mv8 = $m8; $mv9 = $m9; $mv10 = $m10; $mv11 = $m11; $mv12 = $m12; if ($cor==1) { echo "
$row->CTA_DESCRICAO
$row->CTAS_DESCRICAO
$mv1
$mv2
$mv3
$mv4
$mv5
$mv6
$mv7
$mv8
$mv9
$mv10
$mv11
$mv12
$tg
"; $f_btn++; $cor = 0; } else { echo "
$row->CTA_DESCRICAO
$row->CTAS_DESCRICAO
$mv1
$mv2
$mv3
$mv4
$mv5
$mv6
$mv7
$mv8
$mv9
$mv10
$mv11
$mv12
$tg
"; $f_btn++; $cor = 1; } } $m1 = 0; $m2 = 0; $m3 = 0; $m4 = 0; $m5 = 0; $m6 = 0; $m7 = 0; $m8 = 0; $m9 = 0; $m10 = 0; $m11 = 0; $m12 = 0; $stmt="select extract(month FROM CAIX_DTA_MOV) MES ,SUM(CAIX_VALOR) CAIX_VALOR from CAIXA, CONTA, CONTA_S where CAIX_CTAS_ID = CTAS_ID and CAIX_CTAS_CTA_ID = CTA_ID and CTAS_CTA_ID = CTA_ID and CTAS_ES = 'S' and CAIX_EMP_ID = $cemp AND CAIX_DTA_MOV >= '$diaini' AND CAIX_DTA_MOV <= '$diafim' GROUP BY extract(month FROM CAIX_DTA_MOV) ORDER by extract(month FROM CAIX_DTA_MOV)"; $sth = ibase_query($dbh, $stmt); while ($row = ibase_fetch_object ($sth)) { if ($row->MES == 1) $m1 = $row->CAIX_VALOR; if ($row->MES == 2) $m2 = $row->CAIX_VALOR; if ($row->MES == 3) $m3 = $row->CAIX_VALOR; if ($row->MES == 4) $m4 = $row->CAIX_VALOR; if ($row->MES == 5) $m5 = $row->CAIX_VALOR; if ($row->MES == 6) $m6 = $row->CAIX_VALOR; if ($row->MES == 7) $m7 = $row->CAIX_VALOR; if ($row->MES == 8) $m8 = $row->CAIX_VALOR; if ($row->MES == 9) $m9 = $row->CAIX_VALOR; if ($row->MES == 10) $m10 = $row->CAIX_VALOR; if ($row->MES == 11) $m11 = $row->CAIX_VALOR; if ($row->MES == 12) $m12 = $row->CAIX_VALOR; } $mt = $m1+$m2+$m3+$m4+$m5+$m6+$m7+$m8+$m9+$m10+$m11+$m12; $mv1 = number_format($m1, 2, ',', '.'); $mv2 = number_format($m2, 2, ',', '.'); $mv3 = number_format($m3, 2, ',', '.'); $mv4 = number_format($m4, 2, ',', '.'); $mv5 = number_format($m5, 2, ',', '.'); $mv6 = number_format($m6, 2, ',', '.'); $mv7 = number_format($m7, 2, ',', '.'); $mv8 = number_format($m8, 2, ',', '.'); $mv9 = number_format($m9, 2, ',', '.'); $mv10 = number_format($m10, 2, ',', '.'); $mv11 = number_format($m11, 2, ',', '.'); $mv12 = number_format($m12, 2, ',', '.'); $mvt = number_format($mt, 2, ',', '.'); echo "
$mv1
$mv2
$mv3
$mv4
$mv5
$mv6
$mv7
$mv8
$mv9
$mv10
$mv11
$mv12
$mvt
"; $mesini = $mes - 2; $anoini = $ano; $anofim = $ano; if ($mesini == 0) { $mesini = 12; $anoini = $ano - 1; } if ($mesini == -1) { $mesini = 11; $anoini = $ano - 1; } $mesfim = $mes + 2; if ($mesfim == 13) { $mesfim = 1; $anofim = $ano + 1; } if ($mesfim == 14) { $mesfim = 2; $anofim = $ano + 1; } $diaini = '01/01/' . $ano; $diafim = '12/31/' . $ano; echo"
"; } echo "
"; if ($cont_reg > 0) echo "
"; else echo "
Filtragem de Duplicatas.
"; echo "