laravel框架學習之路（三）Laravel Datatables的使用

kbyyd24 發布于2019-08-02 10:33 / 1208人閱讀

摘要：我們知道，做后臺管理系統需要很多表格用來展示我們的數據，筆者在項目中使用過，對于快速開發來說，將是一個不錯的選擇。

我們知道，做后臺管理系統需要很多表格用來展示我們的數據，筆者在tp項目中使用過datatables，對于快速開發來說，datatables將是一個不錯的選擇。
首先來看一下最終的效果：

準備工作：
1、首先，確保你的laravel配置正確（站點能夠正常訪問、數據庫連接正常...）
2、下載Datatables資源文件（AdminLTE中包含了Datatables資源文件，讀者使用其他模板需另行引入的請自行百度），并在頁面中引入，確保資源文件能夠正確加載。
3、文檔：Laravel Datatables開發文檔

系統要求：
Laravel 5.5+
jQuery DataTables v1.10.x

ok，開始動手！（以administrator頁面為例）
1、安裝composer包

composer require yajra/laravel-datatables-oracle:^8.0

如果你需要使用datatables的全部插件可使用以下命令安裝

composer require yajra/laravel-datatables:^1.0

2、配置Datatables（此步驟可省，但還是配置下，確保后續不會出錯）
安裝完成之后，打開config/app.php，鍵入如下代碼

"providers" => [
    // ...
    YajraDataTablesDataTablesServiceProvider::class,
],

使用命令發布配置和資源文件

php artisan vendor:publish --tag=datatables

3、創建administrator模型

php artisan make:model Models/Administrator -m

編輯數據庫遷移文件

engine = "InnoDB";
            $table->increments("id");
            $table->string("login_name")->unique();
            $table->string("display_name");
            $table->string("password");
            $table->string("avatar")->nullable();
            $table->rememberToken();
            $table->tinyInteger("status")->default(1);
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists("administrators");
    }
}

4、創建AdministratorDatatable

php artisan datatables:make Administrator

此命令會生成DataTables/AdministratorDatatable.php，打開并編輯：

setRowClass("text-center")
            ->editColumn("avatar", function (Administrator $administrator) {
                return "avatar."">";
            })
            ->editColumn("roles", function (Administrator $administrator) {
                return $administrator->roles->map(function ($role) {
                    return "".$role->identifier."[".$role->name."]"."";
                })->implode("");
            })
            ->editColumn("status", function (Administrator $administrator) {
                if ($administrator->status == 1) {
                    return "正常";
                }
                return "禁用";
            })
            ->rawColumns(["avatar", "status", "roles", "action"])
            ->addColumn("action", function (Administrator $administrator) {
                $edit_path = admin_base_path("auth/administrators/".$administrator->id."/edit");
                $delete_path = admin_base_path("auth/administrators/".$administrator->id);
                return "".
                        " 編輯".
                    "".
                    " 刪除";
            });
    }

    /**
     * Get query source of dataTable.
     *
     * @param AppModelsAdministrator $model
     * @return IlluminateDatabaseEloquentBuilder
     */
    public function query(Administrator $model)
    {
        return $model->newQuery()->select("id", "login_name", "display_name",
            "avatar", "status", "created_at", "updated_at");
    }

    /**
     * Optional method if you want to use html builder.
     *
     * @return YajraDataTablesHtmlBuilder
     */
    public function html()
    {
        return $this->builder()
            ->addTableClass("table-bordered table-striped")
            ->columns($this->getColumns())
            ->minifiedAjax("administrators")
            ->addAction(["title" => "操作", "class" => "text-center"])
            ->parameters([
                "dom" => "Bfrtip",
                "buttons" => [
                    ["extend" => "create", "text" => " 創建"],
                    ["extend" => "excel", "text" => " 導出"],
                    ["extend" => "print", "text" => " 打印"],
                    ["extend" => "reload", "text" => " 刷新"],
                ],
            ]);
    }

    /**
     * 獲取數據列
     *
     * @return array
     */
    protected function getColumns()
    {
        return [
            ["name" => "id", "data" => "id", "title" => "ID", "class" => "text-center"],
            ["name" => "login_name", "data" => "login_name", "title" => "登錄名", "class" => "text-center", "orderable" => false],
            ["name" => "display_name", "data" => "display_name", "title" => "顯示名", "class" => "text-center", "orderable" => false],
            ["name" => "avatar", "data" => "avatar", "title" => "頭像", "class" => "text-center", "orderable" => false],
            ["name" => "status", "data" => "status", "title" => "狀態", "class" => "text-center"],
            ["name" => "roles", "data" => "roles", "title" => "角色", "class" => "text-center", "orderable" => false],
            ["name" => "created_at", "data" => "created_at", "title" => "創建時間", "class" => "text-center"],
            ["name" => "updated_at", "data" => "updated_at", "title" => "更新時間", "class" => "text-center"],
        ];
    }

    /**
     * 設置導出文件名
     *
     * @return string
     */
    protected function filename()
    {
        return "Administrator_" . date("YmdHis");
    }

    /**
     * 打印列
     * @var array
     */
    protected $printColumns = ["id", "login_name", "display_name", "created_at", "updated_at"];
}

国产xxxx99真实实拍_久久不雅视频_高清韩国a级特黄毛片_嗯老师别我我受不了了小说

資訊專欄INFORMATION COLUMN

上云采購季！| 2核2G4M爆款云服務器低至59元/年，更有多臺、長期優惠，快來選購！

laravel框架學習之路（三）Laravel Datatables的使用

管理員列表

管理員創建

管理員編輯

相關文章