<?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;

use App\Custom\Classes\SociedadesHelper;
use DB;
use Route;
use stdClass;


class BlueCPanel extends Controller {

    public function index() {
        return view('/blueCPanel/dashboard');
        //return view('/blueCPanel/dashboard')->with(compact(['dbbva','docs','dbbva_p','doc_produccion_informes','doc_sin_tareas']));
    }

    public function documentos() {
        
        $user_id = Session::get('usuario')->user_id;
        Session::forget('es_bbva');
		Session::put('es_bbva','1');

        if(isset($_POST['i'])) {
            $i = $_POST['i'];
            switch ($i) {
                case 'a':
                    //-- DOCUMENTOS PENDIENTE DE VERIFICAR BBVA 'doc_a'
                    return count(SQLConnection::backendStoreProcedure('LN_verificacion_docs_', array('queue', Session::get('usuario')->user_id,null,1226057645), 'select'));
                    break;

                case 'b':
                    //-- DOUMENTOS GENERALES PENDIENTE DE VERIFICAR  'doc_b'
                    Session::put('es_bbva','0');
                    return count(SQLConnection::backendStoreProcedure('LN_verificacion_docs_', array('queue', Session::get('usuario')->user_id), 'select'));
                    break;

                case 'c':
                    //-- DOCUMENTOS BBVS PENDIENTES DE VALORACION 'doc_c'
                    return count(SQLConnection::backendStoreProcedure('LN_docs_valorar_pendientes', array()));
                    break;

                case 'd':
                    //-- DOCUMENTOS PARA PRODUCCION DE INFORMES  'doc_d'
                    return count(SQLConnection::backendStoreProcedure('LN_informes', array('panel_control_reports', NULL, NULL), 'select'));
                    break;

                case 'e':
                    //-- DOCUMENTOS ANALISIS Y VALORACION SIN TAREAS  'doc_e'
                    return count(SQLConnection::backendStoreProcedure('LN_documentos_valoraciones', array($user_id),'select'));
                    break;
                                                        
                default:
                    return 0;
                    break;
            }
            
        }
        return 0;
        
    }

    static function busquedaContrapartes() {
        return view('/blueCPanel/buscador_contrapartes_simple');
    }
}