<script src="./form/<?= $_GET['p'] ?>/<?= $_GET['p'] ?>.js"></script>
<?php
ini_set('display_errors', null);
$municipios = new municipios();
$notas_pagamentos = new notas_pagamentos();
$liquidacoes = new liquidacoes();
$form = new formate_elemento();
$secs = new orgaos();
$nome_sec = 'Todas as secretarias';
$despesas = new despesasDAO();
$data = new Data();
$cod_orgao = 0;
$elemento  = 44905100
?>
<div class="panel panel-success">
    <!-- Default panel contents -->
    <div class="panel-heading text-center"><b> <?php
            $municipio = $municipios->ObterPorPK($_SESSION['municipio']);
            echo $municipio->getNome_municipio();
            ?> | <?= substr($_SESSION['exercicio'],0,4) ?></b></div>
    <div class="panel-body">
        <!-- amCharts javascript sources -->
        <script type="text/javascript" src="https://www.amcharts.com/lib/3/amcharts.js"></script>
        <script type="text/javascript" src="https://cdn.amcharts.com/lib/3/serial.js"></script>
        <script type="text/javascript" src="https://www.amcharts.com/lib/3/themes/patterns.js"></script>

        <!-- amCharts plugins -->
        <script type="text/javascript" src="https://www.amcharts.com/lib/3/plugins/export/export.min.js"></script>
        <link rel="stylesheet" href="https://www.amcharts.com/lib/3/plugins/export/export.css">

        <script type="text/javascript">
            AmCharts.makeChart("chartdiv",
                {
                    "type": "serial",
                    "categoryField": "category",
                    "autoMarginOffset": 40,
                    "marginRight": 60,
                    "marginTop": 60,
                    "startDuration": 1,
                    "precision": 2,
                    "decimalSeparator": ",",
                    "fontSize": 13,
                    "thousandsSeparator": ".",
                    "theme": "patterns",
                    "export": {
                        "enabled": true
                    },
                    "chartCursor": {
                        "enabled": true
                    },
                    "categoryAxis": {
                        "gridPosition": "start"
                    },
                    "trendLines": [],
                    "graphs": [
                        {
                            "balloonText": "[[title]] \n MES [[category]] \n VALOR [[value]]",
                            "bullet": "round",
                            "bulletSize": 10,
                            "id": "AmGraph-1",
                            "lineAlpha": 1,
                            "lineThickness": 3,
                            "title": "PAGAMENTOS",
                            "type": "smoothedLine",
                            "valueField": "column-1"
                        },
                        {
                            "balloonText": "[[title]] \n MES [[category]] \n VALOR [[value]]",
                            "bullet": "square",
                            "id": "AmGraph-2",
                            "lineAlpha": 1,
                            "lineThickness": 1,
                            "title": "LIQUIDACOES",
                            "type": "smoothedLine",
                            "valueField": "column-2"
                        }
                    ],
                    "guides": [],
                    "valueAxes": [
                        {
                            "id": "ValueAxis-1",
                            "title": "<?php echo $nome_sec ?>"
                        }
                    ],
                    "allLabels": [],
                    "balloon": {},
                    "legend": {
                        "enabled": true,
                        "useGraphSettings": true,
                        "valueWidth": 70
                    },

                    "dataProvider": [
                        <?php
                        $valor_total_pago = 0;
                        $valor_total_liq = 0;
                        $grafico[] = "";
                        $grafico2[] = "";
                        $mespag[] = "";
                        $mesliq[] = "";
                        $pagamento = $notas_pagamentos->ObterPorOrgaoElementoMeses($_SESSION['exercicio'], $_SESSION['municipio'], $cod_orgao, $elemento);
                        // $p = 1;
                        foreach ($pagamento as $row) {
                            $valor_pago = number_format($row->getValor_nota_pagamento(), 2, '.', '');
                            $grafico[$row->getData_nota_pagamento()] = $valor_pago;
                            $mespag[$row->getData_nota_pagamento()] = $row->getData_nota_pagamento();
                            $valor_total_pago = $valor_total_pago + $row->getValor_nota_pagamento();
                            //   $p++;
                        }
                        // $l = 1;
                        $liquidacao = $liquidacoes->ObterPorOrgaoElementoMeses($_SESSION['exercicio'], $_SESSION['municipio'], $cod_orgao, $elemento);
                        foreach ($liquidacao as $r) {
                            $valor_liquidado = number_format($r->getValor_liquidado(), 2, '.', '');
                            $grafico2[$r->getData_liquidacao()] = $valor_liquidado;
                            $mesliq[$r->getData_liquidacao()] = $r->getData_liquidacao();
                            $valor_total_liq = $valor_total_liq + $r->getValor_liquidado();
                            //   $l++;
                        }


                        for ($i = 1; $i <= 12; $i++) {

                            /* if($mesliq[$i] == $i && $mespag[$i] == $i) {
                                 echo "\n -->mes: " . $i;
                                 echo " -->liq: " . $mesliq[$i];
                                 echo " -->pag: " . $mespag[$i];
                             }*/

                            if ($mesliq[$i] == $i && $mespag[$i] == $i) {
                                $mes = $data->arrayMes($i);
                                printf("{\"category\": \"%s\",\n\"column-1\": \"%.2f\",\n", $mes, $grafico[$i]);
                                printf("\"column-2\": \"%.2f\"},\n", $grafico2[$i]);
                            } else {
                                $mes = $data->arrayMes($i);
                                printf("{\"category\": \"%s\",\n\"column-1\": \"0\",\n", $mes);
                                printf("\"column-2\": \"0\"},\n");
                            }

                        }
                        ?>
                    ],
                    "titles": [
                        {
                            "id": "Title-1",
                            "size": 15,
                            "text": "ELEMENTO - <?= $form->f_elemento($elemento) . " - " . utf8_encode($despesas->ObterPorPK($elemento)->getDesp_nome()) ?>"
                        },
                        {
                            "id": "Title-2",
                            "tabIndex": 7,
                            "size": 12,
                            "text": "VALOR TOTAL PAGO: $ <?= number_format($valor_total_pago, 2, ',', '.') ?>"
                        },
                        {
                            "id": "Title-3",
                            "tabIndex": 7,
                            "size": 12,
                            "text": "VALOR TOTAL LIQUIDADO: $ <?= number_format($valor_total_liq, 2, ',', '.') ?>"
                        }
                    ]
                }
            );
        </script>

        <div id="chartdiv" style="width: 100%; height: 500px; background-color: #FFFFFF;"></div>
    </div>
</div>