Laravel-admin 列表复杂查询中遇到的问题
列表$gird的复杂查询,按照官网文档给出的示例写完,为什么前端没有效果呢?
public function paginate()
{
$perPage = Request::get('per_page', 10);
$page = Request::get('page', 1);
$start = ($page-1)*$perPage;
// 运行sql获取数据数组
$sql = 'SELECT * from tbl_recordsbaseinfo where TIMESTAMPDIFF(YEAR, Birthday, CURDATE()) >= 65';
$result = DB::select($sql);
$movies = static::hydrate($result);
$paginator = new LengthAwarePaginator($movies, $total, $perPage);
$paginator->setPath(url()->current());
return $paginator;
}
public static function with($relations)
{
return new static;
}
本作品采用《CC 协议》,转载必须注明作者和本文链接
推荐文章: