<?php

namespace App\Http\Controllers;

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

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

class PadronesController extends Controller {
    public static function obtenerPadrones() {
        //$paises = SQLConnection::backendStoreProcedure('backend_obtener_paises', array());		
        $paises = array();
        $padrones = array();
        $nro = null;
        $nom = null;
        return view('/comercial/padrones')->with(compact(['paises', 'padrones', 'nro', 'nom']));
    }

    public static function obtenerPadronesBusqueda() {
        $paises = SQLConnection::backendStoreProcedure('backend_obtener_paises', array());
        $ident = Request::input('ident');
        $nro = preg_replace('/[^0-9a-zA-Z]/', '', Request::input('nro'));
        $nom = Request::input('nom');
        $padrones = SQLConnection::backendStoreProcedure('backend_buscar_en_padron_nueva', array($nro, $nom));

        return view('/comercial/padrones')->with(compact(['paises', 'padrones', 'nro', 'nom']));
    }

    public static function obtenerIdPadron() {
        $id = Request::input('id');
        $padron = SQLConnection::backendStoreProcedure('backend_obtener_id_padron', array($id), 'selectOne');
        return view('/comercial/padron-edit')->with(compact('padron'));
    }

    public static function updateIdPadron() {
        /*$paises = SQLConnection::backendStoreProcedure('backend_obtener_paises', array());*/
        $paises = array();
        $padrones = array();
        $nro = null;
        $nom = null;
        $id = Request::input('id_padron');
        $data[0] = $id;
        $data[1] = trim(Request::input('nombre_persona'));
        $data[2] = trim(Request::input('tipo_persona'));
        $data[3] = trim(Request::input('sexo'));
        $data[4] = (Request::input('habilitado') == 'on' ? 1 : 0);
        $padron = SQLConnection::backendStoreProcedure('backend_update_id_padron', $data);
        return view('/comercial/padrones')->with(compact(['paises', 'padrones', 'nro', 'nom']));
    }


    ////////////////////////////////////
    ///NUEVAS FUNCIONES PANEL PADRON///
    //////////////////////////////////

    public static function panelPadrones() {
        $paises = SQLConnection::backendStoreProcedure('backend_country', array('SELECCIONAR_ACTIVO'));
        $padrones = array();
        $nro = null;
        $nom = null;

        return view('/comercial/padrones_verde')->with(compact(['paises', 'padrones', 'nro', 'nom']));
    }

    public static function buscarPadrones() {
        $paises = SQLConnection::backendStoreProcedure('backend_obtener_paises', array());
        $ident = Request::input('ident');
        $nro = preg_replace('/[^0-9a-zA-Z]/', '', Request::input('nro'));
        $nom = Request::input('nom');
        $padrones = SQLConnection::backendStoreProcedure('backend_buscar_en_padron_nueva', array($nro, $nom));

        return view('/comercial/padrones_verde')->with(compact(['paises', 'padrones', 'nro', 'nom']));
    }

    public static function datosPadronElegido() {
        $id = Request::input('id');
        $padron = SQLConnection::backendStoreProcedure('backend_obtener_id_padron', array($id), 'selectOne');

        return json_encode($padron);
    }

    public function altaPadron() {
        $paises = array();
        $padrones = array();
        $nro = null;
        $nom = null;
        $data[0] = trim(Request::input('identificador'));
        $data[1] = trim(Request::input('numero'));
        $data[2] = trim(Request::input('nombre_persona'));
        $data[3] = trim(Request::input('tipo_persona'));
        if (Request::input('sexo') == 'NA') {
            $data[4] = NULL;
        } else {
            $data[4] = trim(Request::input('sexo'));
        }
        $data[5] = (Request::input('habilitado') == 'on' ? 1 : 0);

        $respuesta = SQLConnection::backendStoreProcedure('backend_insertar_padron', $data, 'selectOne');
        $mensaje = $respuesta->mensaje;

        return $mensaje;
    }

    public static function actualizarPadron() {
        $paises = array();
        $padrones = array();
        $nro = null;
        $nom = null;
        $id = Request::input('id_padron');
        $data[0] = $id;
        $data[1] = trim(Request::input('nombre_persona_editar'));
        $data[2] = trim(Request::input('tipo_persona_editar'));
        if (Request::input('sexo_editar') == 'NA') {
            $data[3] = NULL;
        } else {
            $data[3] = trim(Request::input('sexo_editar'));
        }
        $data[4] = (Request::input('habilitado_editar') == 'on' ? 1 : 0);
        $padron = SQLConnection::backendStoreProcedure('backend_update_id_padron', $data);

        return 0;
    }

}