<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Custom\SQLConnection;
use Session;
use View;
use Illuminate\Support\Facades\DB;

class ProvinciaController extends Controller {

    public function index(){
        $paises = SQLConnection::backendStoreProcedure('backend_obtener_paises', array(), 'select');
        $provincias =         SQLConnection::backendStoreProcedure('abm_provincias',array('SELECT', NULL, NULL, NULL, NULL));
        return view('/provincias/provincias')->with(compact('provincias','paises'));  /* BACKEND IV ACTUAL */
    }

    public function insert(){
        $provincia = request()->input("provincia");
        $pais = request()->input("pais");
        if($provincia != null and $provincia != null){
            if($pais != '' and $pais != ''){
                SQLConnection::backendStoreProcedure('abm_provincias',array('INSERT', null, $provincia, $pais, null));  
                $provincias = SQLConnection::backendStoreProcedure('abm_provincias',array("BUSQUEDA-POR-PAISES", NULL,NULL,$pais,NULL));                
                echo json_encode($provincias);
            }else{
                return 'complete el pais';
            }   
        }else{
            return 'complete la provincia';
        }
    }
    
    public function edit(){
        $provincia = request()->input("provincia");
        $pais = request()->input("pais");
        $registro = request()->input("registro");
        if($provincia != null and $provincia != null){
            if($pais != '' and $pais != ''){
                SQLConnection::backendStoreProcedure('abm_provincias',array('UPDATE',$registro, $provincia, $pais, null));
                $provincias = SQLConnection::backendStoreProcedure('abm_provincias',array("BUSQUEDA-POR-PAISES", NULL,NULL,$pais,NULL));
                echo json_encode($provincias);
            }else{
                return 'complete el pais';
            }   
        }else{
            return 'complete la provincia';
        }
    }
    
    public function visible(){
        $registro = request()->input("registro");
        $visible = intval(request()->input("visible"));
        $pais = request()->input("pais");
        //editar visible
        SQLConnection::backendStoreProcedure('abm_provincias',array('VISIBLE',$registro, null, null, $visible));
        $provincias = SQLConnection::backendStoreProcedure('abm_provincias',array('BUSQUEDA-POR-PAISES',NULL,NULL,$pais,NULL));   
        echo json_encode($provincias);
    }
    
    public function provinciasPorPais(){
        $pais = request()->input("countryCode");
        $provincias = SQLConnection::backendStoreProcedure('abm_provincias',array("BUSQUEDA-POR-PAISES",NULL,NULL,$pais,NULL));
        echo json_encode($provincias);
    }
}