laravel5.5使用yajra/laravel-datatables-oracle 8.13.7

最新推荐文章于 2024-03-21 09:42:29 发布

皇小邪

最新推荐文章于 2024-03-21 09:42:29 发布

阅读量693

点赞数 1

分类专栏： php laravel

本文链接：https://blog.csdn.net/huangjinao/article/details/94572803

版权

php 同时被 2 个专栏收录

87 篇文章 1 订阅

订阅专栏

laravel

10 篇文章 0 订阅

订阅专栏

根据laravel版本选择对应的yajra/laravel-datatables-oracle版本，否则的话会，安装失败

1、composer安装yajra/laravel-datatables-oracle

$ composer require yajra/laravel-datatables-oracle:"~8.13.7"

2、注册提供者和门面（config/app.php）

'providers' => [
    ...,
    Yajra\DataTables\DataTablesServiceProvider::class,
]

'aliases' => [
    ...,
    'DataTables' => Yajra\DataTables\Facades\DataTables::class,
]

3、配置

$ php artisan vendor:publish --provider="Yajra\DataTables\DataTablesServiceProvider"

4、数据迁移（注：添加数据，进行测试）

创建数据表

$ php artisan migrate

向创建的user表中添加100条数据

$ php artisan tinker
>>> factory(App\User::class, 100)->create();

5、创建视图

父模板：resources/views/layouts/master.blade.php

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <title>Laravel DataTables Tutorial</title>

        <!-- Bootstrap CSS -->
        <link href="//netdna.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css" rel="stylesheet">
        <link rel="stylesheet" href="//cdn.datatables.net/1.10.7/css/jquery.dataTables.min.css">

        <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
        <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
        <!--[if lt IE 9]>
            <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
            <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
        <![endif]-->
        <style>
            body {
                padding-top: 40px;
            }
        </style>
    </head>
    <body>
        <div class="container">
            @yield('content')
        </div>

        <!-- jQuery -->
        <script src="//code.jquery.com/jquery.js"></script>
        <!-- DataTables -->
        <script src="//cdn.datatables.net/1.10.7/js/jquery.dataTables.min.js"></script>
        <!-- Bootstrap JavaScript -->
        <script src="//netdna.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
        <!-- App scripts -->
        @stack('scripts')
    </body>
</html>

index.blade.php

@extends('layouts.master')

@section('content')
    <table class="table table-bordered" id="users-table">
        <thead>
            <tr>
                <th>Id</th>
                <th>Name</th>
                <th>Email</th>
                <th>Created At</th>
                <th>Updated At</th>
            </tr>
        </thead>
    </table>
@stop

@push('scripts')
<script>
$(function() {
    $('#users-table').DataTable({
        processing: true,
        serverSide: true,
        ajax: 'data',
        columns: [
            { data: 'id', name: 'id' },
            { data: 'name', name: 'name' },
            { data: 'email', name: 'email' },
            { data: 'created_at', name: 'created_at' },
            { data: 'updated_at', name: 'updated_at' }
        ]
    });
});
</script>
@endpush

6、创建控制器

php artisan make:controller DatatablesController

namespace App\Http\Controllers;

use App\Http\Requests;
use App\User;
use Yajra\Datatables\Datatables;

class DatatablesController extends Controller
{
    /**
     * Displays datatables front end view
     *
     * @return \Illuminate\View\View
     */
    public function Index()
    {
        return view('datatables.index');
    }

    /**
     * Process datatables ajax request.
     *
     * @return \Illuminate\Http\JsonResponse
     */
    public function Data()
    {
        return Datatables::of(User::query())->make(true);
    }
}

7、配置路由

Route::any('data','DatatablesController@Data');
Route::get('index','DatatablesController@Index');

8、访问测试

皇小邪

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录