在我的视图中返回了一个带有分页的"servers"表中所有"servers"的列表。我一直在努力弄清楚如何得到排序(asc &(如果可能的话)和过滤(在结果中搜索)工作。
这是我的控制器代码:
$servers = Server::paginate(5);
return View::make('servers.list')
->with('game', '')
->with('servers', $servers);
下面是排序的视图代码:
<ul class="nav">
<li class="active"><a href="#"><i class="icon-angle-down"></i>{{ Lang::line('servers.rank')->get() }}</a></li>
<li><a href="#">{{ Lang::line('servers.date')->get() }}</a></li>
<li><a href="#">{{ Lang::line('servers.language')->get() }}</a></li>
<li><a href="#">{{ Lang::line('servers.uptime')->get() }}</a></li>
<li>{{ HTML::link(URL::full() .'?sort=votes', Lang::line('servers.votes')->get()) }} </li>
</ul>
我想通过简单的锚链接进行排序，点击投票或排名或日期将返回该排序的数据。单击当前选中的同一排序锚点将反转排序方向。
我也有一堆"过滤器"选项，如类别和整数范围，当应用时，将"过滤"/搜索表，并返回与过滤器之前选择的相同排序的结果。
在分页类中所有这些都是可能的吗?如果不是，我该怎么做呢?我不确定使用laravel的最佳方式。
多亏了出色的分页和输入类，这在laravel中很容易做到。在你的视图中试试:
<<p> 示例视图/strong>清理视图
<form action="" method="get" id="filter">
Show <select name="game_id">
<option value="">All</option>
<?php foreach ($games as $game):?>
<option value="<?=$game->id?>" <?=($game->id == Input::get('game_id')) ? 'selected="selected"' : null?>><?=$game->name?></option>
<?php endforeach;?>
</select>
Show <select name="server_id">
<option value="">All</option>
<?php foreach ($servers as $server):?>
<option value="<?=$server->id?>" <?=($server->id == Input::get('server_id')) ? 'selected="selected"' : null?>><?=$server->name?></option>
<?php endforeach;?>
</select>
<input type="submit" value="Filter" rel="filter">
</form>
<hr>
<?php if (count($servers) > 0):?>
<?=$pagination?>
<table>
<tr>
<th><a href="<?=URL::to('servers?sort=id'.$querystr)?>">ID</a></th>
<th><a href="<?=URL::to('servers?sort=rank'.$querystr)?>">RANK</a></th>
<th><a href="<?=URL::to('servers?sort=date'.$querystr)?>">DATE</a></th>
<th><a href="<?=URL::to('servers?sort=language'.$querystr)?>">LANGUAGE</a></th>
<th><a href="<?=URL::to('servers?sort=uptime'.$querystr)?>">UP TIME</a></th>
<th><a href="<?=URL::to('servers?sort=votes'.$querystr)?>">VOTES</a></th>
</tr>
<tr>
<td>
...
</td>
</tr>
</table>
<?=$pagination?>
<?php else:?>
<h2>No results found.</h2>
<?php endif;?>
public function get_action()
{
// CACHE SORTING INPUTS
$allowed = array('rank', 'date', 'language', 'uptime', 'votes'); // add allowable columns to search on
$sort = in_array(Input::get('sort'), $allowed) ? Input::get('sort') : 'id'; // if user type in the url a column that doesnt exist app will default to id
$order = Input::get('order') === 'asc' ? 'asc' : 'desc'; // default desc
$servers = Server::order_by($sort, $order);
// FILTERS
$game = null;
$server = null;
if (Input::has('game_id')) {
$servers = $servers->where('game_id', Input::get('game_id'));
$game = '&game_id='.Input::get('game_id');
}
if (Input::has('server_id')) {
$servers = $servers->where('server_id', Input::get('server_id'));
$server = '&server_id='.Input::get('server_id');
}
// PAGINATION
$servers = $servers->paginate(5);
$pagination = $servers->appends(
array(
'game_id' => Input::get('game_id'),
'server_id' => Input::get('server_id'),
'sort' => Input::get('sort'),
'order' => Input::get('order')
))->links();
return View::make(servers.list)->with(
array(
'game' => null,
'servers' => $servers,
'pagination' => $pagination,
'querystr' => '&order='.(Input::get('order') == 'asc' || null ? 'desc' : 'asc').$game.$server
));
}