通过 
搜索
搜索ad-mos / laravel-datatables
Laravel 框架的 DataTables 服务器端 API
v2.7
2024-04-17 13:52 UTC
Requires
- php: ^7.1|^8.0
- doctrine/dbal: ^2.6|^3.0
- illuminate/database: ~5.6.0|~5.7.0|~5.8.0|^6.0|^7.0|^8.0|^9.0|^10
- illuminate/http: ~5.6.0|~5.7.0|~5.8.0|^6.0|^7.0|^8.0|^9.0|^10
README
快速安装
$ composer require ad-mos/laravel-datatables
使用示例
1 - 简单表格
public function data(DataTables $dataTables) { return $dataTables->provide(new User); }
2 - 连接表
public function data(DataTables $dataTables) { $model = new User; $query = $model->newQuery() ->leftJoin('user_emails', 'user_emails.user_id', '=', 'users.id') ->leftJoin('user_phones', 'user_phones.user_id', '=', 'users.id') ->groupBy('users.id'); $aliases = [ 'emails' => 'GROUP_CONCAT(DISTINCT `user_emails`.email SEPARATOR \'|\')', 'phones' => 'GROUP_CONCAT(DISTINCT `user_phones`.phone SEPARATOR \'|\')', ]; return $dataTables->provide($this->model, $query, $aliases); }
DataTables 可以通过 IoC、助手或外观访问
return $dataTables->provide(...); return datatables()->provide(...); return \DataTables::provide(...);
许可证
MIT 许可证。更多信息请点击此处。