informe_facturas::informe_compras()

Complexity

Conditions	19
Paths	5008

Size

Total Lines	110
Code Lines	74

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

<?php
    private function informe_compras()
    {
        $sql = "SELECT codproveedor,fecha,SUM(neto) as total FROM facturasprov"
            . " WHERE fecha >= " . $this->empresa->var2str($this->desde)
            . " AND anulada = false "
            . " AND fecha <= " . $this->empresa->var2str($this->hasta);

        if ($this->codserie) {
            $sql .= " AND codserie = " . $this->empresa->var2str($this->codserie);
        }

        if ($this->codagente) {
            $sql .= " AND codagente = " . $this->empresa->var2str($this->codagente);
        }

        if ($this->proveedor) {
            $sql .= " AND codproveedor = " . $this->empresa->var2str($this->proveedor->codproveedor);
        }

        if ($_POST['minimo']) {
            $sql .= " AND neto > " . $this->empresa->var2str($_POST['minimo']);
        }

        $sql .= " GROUP BY codproveedor,fecha ORDER BY codproveedor ASC, fecha DESC;";

        $data = $this->db->select($sql);
        if ($data) {
            $this->template = false;
            header("content-type:application/csv;charset=UTF-8");
            header("Content-Disposition: attachment; filename=\"informe_compras.csv\"");
            echo "codproveedor;nombre;año;ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic;total;%VAR\n";

            $proveedor = new proveedor();
            $stats = array();
            foreach ($data as $d) {
                $anyo = date('Y', strtotime($d['fecha']));
                $mes = date('n', strtotime($d['fecha']));
                if (!isset($stats[$d['codproveedor']][$anyo])) {
                    $stats[$d['codproveedor']][$anyo] = array(
                        1 => 0,
                        2 => 0,
                        3 => 0,
                        4 => 0,
                        5 => 0,
                        6 => 0,
                        7 => 0,
                        8 => 0,
                        9 => 0,
                        10 => 0,
                        11 => 0,
                        12 => 0,
                        13 => 0,
                        14 => 0
                    );
                }

                $stats[$d['codproveedor']][$anyo][$mes] += (float)$d['total'];
                $stats[$d['codproveedor']][$anyo][13] += (float)$d['total'];
            }

            $totales = array();
            foreach ($stats as $i => $value) {
                /// calculamos la variación
                $anterior = 0;
                foreach (array_reverse($value, true) as $j => $value2) {
                    if ($anterior > 0) {
                        $value[$j][14] = ($value2[13] * 100 / $anterior) - 100;
                    }

                    $anterior = $value2[13];

                    if (isset($totales[$j])) {
                        foreach ($value2 as $k => $value3) {
                            $totales[$j][$k] += $value3;
                        }
                    } else {
                        $totales[$j] = $value2;
                    }
                }

                $pro = $proveedor->get($i);
                foreach ($value as $j => $value2) {
                    if ($pro) {
                        echo '"' . $i . '";' . fs_fix_html($pro->nombre) . ';' . $j;
                    } else {
                        echo '"' . $i . '";-;' . $j;
                    }

                    foreach ($value2 as $value3) {
                        echo ';' . number_format($value3, FS_NF0, FS_NF1, FS_NF2);
                    }

                    echo "\n";
                }
                echo ";;;;;;;;;;;;;;;\n";
            }

            foreach (array_reverse($totales, true) as $i => $value) {
                echo ";TOTALES;" . $i;
                $l_total = 0;
                foreach ($value as $j => $value3) {
                    if ($j < 13) {
                        echo ';' . number_format($value3, FS_NF0, FS_NF1, FS_NF2);
                        $l_total += $value3;
                    }
                }
                echo ";" . number_format($l_total, FS_NF0, FS_NF1, FS_NF2) . ";\n";
            }
        } else {
            $this->new_error_msg('Sin resultados.');
        }