<?php

namespace App\Http\Controllers;

use Illuminate\Support\Facades\Response;
use Illuminate\Support\Facades\Session;
use Illuminate\Support\Facades\Request;

use App\Custom\Misc;
use App\Custom\SQLConnection;


class tablasConsultasController extends Controller {
    public static function reportes() {
        $clientes = SQLConnection::backendStoreProcedure('LED_Clientes', array('SELECT', NULL, NULL, NULL, NULL, 0), 'select');
        $sectores = SQLConnection::backendStoreProcedure('sectores_clae', array(), 'select');
        $productos = SQLConnection::backendStoreProcedure('productos_led', array(), 'select');

        $anio = $Year = date("Y");
        $anio1 = $anio - 10;
        $anio2 = $anio - 5;
        return view('/tablasConsultas/balances_reportes')->with(compact(['clientes', 'sectores', 'productos', 'anio1', 'anio2', 'anio']));
    }

    public function balancesReportesResultadoNuevo() {
        $anio = Request::input('anio');
        $sector = Request::input('sector');
        $cliente = Request::input('cliente');
        $producto = Request::input('producto');
        $pais = Request::input('pais');
        $indice = Request::input('indice');
        if (empty($pais) || $pais == '0') {
            $pais = null;
        }
        if (empty($producto) || $producto == 0) {
            $producto = null;
        }
        if (empty($cliente) || $cliente == 0) {
            $cliente = null;
            $producto = null;
        }
        if (empty($sector) || $sector == 0) {
            $sector = null;
        }
        $anio1 = $anio;
        $anio2 = $anio + 1;
        $anio3 = $anio + 2;
        $anio4 = $anio + 3;
        $anio5 = $anio + 4;
        $params = array($anio, $cliente, $producto, $sector, $pais, $indice);
        $registros = SQLConnection::backendStoreProcedure('balances_reporte', $params, 'select');

        return view('/tablasConsultas/tabla_balances_reportes')->with(compact('registros', 'anio1', 'anio2', 'anio3', 'anio4', 'anio5'));
    }

}