app/Http/Controllers/UsuariosController.php
/**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
Display a listing of the resource.
@return \Illuminate\Http\Response
Display a listing of the resource . @return \ Illuminate \ Http \ Response
public function index()
    {
        $tipo = $serv = DB::select("SELECT * FROM mudate24bd.recursiva where rec_nemonico = 'SER' or rec_nemonico ='TSE' ORDER BY rec_nemonico, rec_detalle;");
                $servicios = DB::select("
                    SELECT servicios.*, Ser.rec_detalle AS ser_service, Tipo.rec_detalle AS ser_tipo, Parroquia.rec_detalle AS ser_parroquia FROM servicios 
                    INNER JOIN recursiva AS Ser ON ser_servicio_rec_id = Ser.rec_id 
                    INNER JOIN recursiva AS Tipo ON ser_tipo_rec_id = Tipo.rec_id
                    INNER JOIN recursiva AS Parroquia ON ser_parroquia_rec_id = Parroquia.rec_id;
                ");
                return view('usuarios.index',compact('servicios','serv','tipo')); 
                return redirect()->intended('dashboard');
    }
public function index ( ) { $ tipo = $ serv = DB :: select ( " SELECT * FROM mudate24bd.recursiva where rec_nemonico = 'SER' or rec_nemonico ='TSE' ORDER BY rec_nemonico, rec_detalle; " ) ; $ servicios = DB :: select ( " 
                    SELECT servicios.*, Ser.rec_detalle AS ser_service, Tipo.rec_detalle AS ser_tipo, Parroquia.rec_detalle AS ser_parroquia FROM servicios 
                    INNER JOIN recursiva AS Ser ON ser_servicio_rec_id = Ser.rec_id 
                    INNER JOIN recursiva AS Tipo ON ser_tipo_rec_id = Tipo.rec_id
                    INNER JOIN recursiva AS Parroquia ON ser_parroquia_rec_id = Parroquia.rec_id;
                 " ) ; return view ( 'usuarios.index' , compact ( 'servicios' , 'serv' , 'tipo' ) ) ; return redirect ( ) -> intended ( 'dashboard' ) ; }
Display a listing of the resource.
Display a listing of the resource .
//filtrar por el servicio del usuario