Good day.
I have a small problem with paging, which does not work properly, I have two methods, one of which is correctly paged, like this one.
But the other one does not
public function selectord (Request $ request) {
$valorusuario = $request->valorusuario;
$consultarea=usuarios::where("user_id","=",$request->valorusuario)->orderBy('id','DESC')->paginate(6);
$usuariosOpciones=usuarios::pluck('usuario_ad', 'user_id')->unique();
return view('usuario.consultareas',compact('consultarea','usuariosOpciones'));
}
public function revisar()
{
$consultarea=usuarios::orderBy('id','DESC')->paginate(6);
$usuariosOpciones =usuarios::pluck('usuario_ad', 'user_id')->unique();
return view('usuario.consultareas',compact('consultarea','usuariosOpciones'));
}The first one does not work, because when it reaches the limit it generates the next page without registers, the second works without problems, which could be doing wrong?
This is my view
tends('layouts.layout')
@section('content')
<div class="row">
<section class="content">
<div class="col-md-12 col-md-offset-0">
@if(Session::has('success'))
<div class="alert alert-info">
{{Session::get('success')}}
</div>
@endif
<div class="panel panel-default">
<div class="panel-body">
<div class="pull-left"><h3>Usuarios confirmados</h3></div>
<div class="pull-right">
<div class="btn-group">
<div class="col-md-10">
<form action="{{route('usuario.bestado')}}" method="get">
{{csrf_field()}}
<select name="valorestado" id="valorestado" class=" form-control" required>
<option value="Pendiente">Pendiente</option>
<option value="Descartado">Descartado</option>
<option value="Confirmado">Confirmado</option>
</select>
<button class="btn btn-danger btn-xs" type="submit">enviar</button>
</form>
</div>
</div>
<div class="btn-group">
<div class="col-md-10">
<form action="{{route('usuario.selectord')}}" method="get">
{{csrf_field()}}
<select name="valorusuario" id="valorusuario" class=" form-control" required>
@foreach($usuariosOpciones as $user_id => $usuario_ad)
<option value="{{ $user_id }}">{{ $usuario_ad }}</option>
@endforeach
</select>
<button class="btn btn-danger btn-xs" type="submit">enviar</button>
</form>
</div>
</div>
</div>
<div class="table-container">
<table id="mytable" class="table table-bordred table-striped table-bordered">
<thead>
<th>Usuario_ad</th>
<th>Nombre</th>
<th>Apellido</th>
<th>Cedula</th>
<th>Telefonos</th>
<th>Direccion</th>
<th>barrio</th>
<th>Lugar_v</th>
<th>Mesa_v</th>
<th>Email</th>
<th>Ciudad</th>
<th>Estado</th>
<th>Tipo</th>
</thead>
<tbody>
@if($consultarea->count())
@foreach($consultarea as $usuario)
<tr>
<td>{{$usuario->usuario_ad}}</td>
<td>{{$usuario->nombre}}</td>
<td>{{$usuario->apellido}}</td>
<td>{{$usuario->cedula}}</td>
<td>{{$usuario->telefonos}}</td>
<td>{{$usuario->direccion}}</td>
<td>{{$usuario->barrio}}</td>
<td>{{$usuario->lugar_votacion}}</td>
<td>{{$usuario->mesa_votacion}}</td>
<td>{{$usuario->email}}</td>
<td>{{$usuario->ciudad}}</td>
<td>{{$usuario->estado}}</td>
<td>
<form action="{{action('CuentaController@cestado')}}" method="post">
<select name="confirmar" id="confirmar" class=" form-control" required>
<option value="Pendiente">Pendiente</option>
<option value="Descartado">Descartado</option>
<option value="Confirmado">Confirmado</option>
</select>
<input type="text" name="idestado" id="idestado" class="form-control input-sm" value="{{{$usuario->id}}}" readonly="readonly" style="visibility:hidden">
{{csrf_field()}}
<button class="btn btn-info" type="submit"><span>Revisar</span></button>
</form>
</td>
</tr>
@endforeach
@else
<tr>
<td colspan="8">No hay registro !!</td>
</tr>
@endif
</tbody>
</table>
</div>
</div>
{{ $consultarea->links() }}
</div>
</div>
</section>
@endsectionAnd this is my routes
<?php
/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/
Route::get('/panel', 'PanelController@index');
Route::get('/panel/gestion', 'CuentaController@ugestion')->name('usuario.ugestion');
Route::get('/panel/bestado', 'CuentaController@bestado')->name('usuario.bestado');
Route::get('/panel/selectord', 'CuentaController@selectord')->name('usuario.selectord');
Route::get('/panel/revisar', 'CuentaController@revisar')->name('cuenta.revisar');
Route::post('/panel/estado', 'CuentaController@cestado')->name('cuenta.cestado');
Route::post('/panel/asignar', 'CuentaController@asignar')->name('cuenta.asignar');
Route::get('/panel/tareas', 'CuentaController@tareas')->name('cuenta.tareas');
Route::resource('/panel/ecuentas', 'CuentaController');
Route::resource('/panel/registros', 'RegistrosController');
Route::get('/panel/fecha', 'UsuarioController@fecha')->name('usuario.fecha');
Route::get('/panel/selector', 'UsuarioController@selector')->name('usuario.selector');
Route::get('/panel/cedula', 'UsuarioController@cedula')->name('usuario.cedula');
Route::resource('/panel/usuario', 'UsuarioController');
Auth::routes();