我在让 yajra laravel 数据表编辑器教程工作时遇到问题

Question

我是Laravel和Datatables/Editor的新手。我在另一个PHP项目中使用了DataTables编辑器，但通过Yajra插件在Laravel中使用它时遇到了问题。我遵循了本教程https://yajrabox.com/docs/laravel-datatables/master/editor-tutorial.一切都很好，但结果并不像我预期的那样奏效。"编辑"one_answers"删除"按钮变灰，行不可选择。我怀疑我要么没有包含DataTables/Editor脚本，要么没有打开Editor.zip(教程中没有(。

我在屏幕上看到的图像

我正在使用：-PHP版本：7.4.2-Laravel版本：6.17.1-Laravel DataTables Editor PHP 1.9.2(付费版本zip文件重命名为Editor.zip并包含在内在根文件夹中(

Web.php

<?php
use AppDataTablesUsersDataTablesEditor;
Route::get('/', function () {
return view('welcome');
});
Auth::routes();
Route::get('/home', 'HomeController@index')->name('home');
Route::get('/users', 'UsersController@index')->name('users.index');
// from https://yajrabox.com/docs/laravel-datatables/master/editor-tutorial
Route::post('/users', 'UsersController@store')->name('users.store');
// from https://yajrabox.com/docs/laravel-datatables/master/editor-usage
Route::post('editor', function(UsersDataTablesEditor $editor) {
return $editor->process(request());
});

UserDataTableEditor.php

<?php
namespace AppDataTables;
use AppUser;
use IlluminateDatabaseEloquentModel;
use IlluminateValidationRule;
use YajraDataTablesDataTablesEditor;
class UsersDataTableEditor extends DataTablesEditor
{
protected $model = User::class;
/**
* Get create action validation rules.
*
* @return array
*/
public function createRules()
{
return [
'email' => 'required|email|unique:' . $this->resolveModel()->getTable(),
'name'  => 'required',
];
}
/**
* Get edit action validation rules.
*
* @param Model $model
* @return array
*/
public function editRules(Model $model)
{
return [
'email' => 'sometimes|required|email|' . Rule::unique($model->getTable())->ignore($model->getKey()),
'name'  => 'sometimes|required',
];
}
/**
* Get remove action validation rules.
*
* @param Model $model
* @return array
*/
public function removeRules(Model $model)
{
return [];
}
}

UserDataTable.php

<?php
namespace AppDataTables;
use AppUser;
use YajraDataTablesHtmlButton;
use YajraDataTablesHtmlColumn;
use YajraDataTablesHtmlEditorEditor;
use YajraDataTablesHtmlEditorFields;
use YajraDataTablesServicesDataTable;

class UsersDataTable extends DataTable
{
/**
* Build DataTable class.
*
* @param mixed $query Results from query() method.
* @return YajraDataTablesDataTableAbstract
*/
public function dataTable($query)
{
return datatables()
->eloquent($query)
->setRowId('id') // Set the RowID
->addColumn('action', 'users.action');
}
/**
* Get query source of dataTable.
*
* @param AppUser $model
* @return IlluminateDatabaseEloquentBuilder
*/
public function query(User $model)
{
return $model->newQuery();
}
/**
* Optional method if you want to use html builder.
*
* @return YajraDataTablesHtmlBuilder
*/
public function html()
{
return $this->builder()
->setTableId('users-table')
->columns($this->getColumns())
->minifiedAjax()
->dom('Bfrtip')
->orderBy(1)
->buttons(
Button::make('create')->editor('editor'),
Button::make('edit')->editor('editor'),
Button::make('remove')->editor('editor'),
Button::make('export'),
Button::make('print'),
Button::make('reset'),
Button::make('reload')
)
->editor(
Editor::make()
->fields([
FieldsText::make('name'),
FieldsText::make('email'),
FieldsPassword::make('password'),
])
);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
Column::computed('action')
->exportable(false)
->printable(false)
->width(60)
->addClass('text-center'),
Column::make('id'),
Column::make('name'),
Column::make('email'),
Column::make('created_at'),
Column::make('updated_at'),
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'Users_' . date('YmdHis');
}
}

UsersController.php

<?php
namespace AppHttpControllers;
use IlluminateHttpRequest;
use AppDataTablesUsersDataTable;
use AppDataTablesUsersDataTableEditor;
class UsersController extends Controller
{
public function index(UsersDataTable $dataTable)
{
return $dataTable->render('users.index');
}
public function store(UsersDataTableEditor $editor)
{
return $editor->process(request());
}
}

app.blade.php

<!doctype html>
<html lang="{{ str_replace('_', '-', app()->getLocale()) }}">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- CSRF Token -->
<meta name="csrf-token" content="{{ csrf_token() }}">
<title>{{ config('app.name', 'Laravel') }}</title>
<!-- Scripts -->
<script src="{{ asset('js/app.js') }}" defer></script>
<!-- Fonts -->
<link rel="dns-prefetch" href="//fonts.gstatic.com">
<link href="https://fonts.googleapis.com/css?family=Nunito" rel="stylesheet">
<!-- Styles -->
<link href="{{ asset('css/app.css') }}" rel="stylesheet">
</head>
<body>
<div id="app">
<nav class="navbar navbar-expand-md navbar-light bg-white shadow-sm">
<div class="container">
<a class="navbar-brand" href="{{ url('/') }}">
{{ config('app.name', 'Laravel') }}
</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="{{ __('Toggle navigation') }}">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarSupportedContent">
<!-- Left Side Of Navbar -->
<ul class="navbar-nav mr-auto">
</ul>
<!-- Right Side Of Navbar -->
<ul class="navbar-nav ml-auto">
<!-- Authentication Links -->
@guest
<li class="nav-item">
<a class="nav-link" href="{{ route('login') }}">{{ __('Login') }}</a>
</li>
@if (Route::has('register'))
<li class="nav-item">
<a class="nav-link" href="{{ route('register') }}">{{ __('Register') }}</a>
</li>
@endif
@else
<li class="nav-item dropdown">
<a id="navbarDropdown" class="nav-link dropdown-toggle" href="#" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false" v-pre>
{{ Auth::user()->name }} <span class="caret"></span>
</a>
<div class="dropdown-menu dropdown-menu-right" aria-labelledby="navbarDropdown">
<a class="dropdown-item" href="{{ route('logout') }}"
onclick="event.preventDefault();
document.getElementById('logout-form').submit();">
{{ __('Logout') }}
</a>
<form id="logout-form" action="{{ route('logout') }}" method="POST" style="display: none;">
@csrf
</form>
</div>
</li>
@endguest
</ul>
</div>
</div>
</nav>
<main class="py-4">
@yield('content')
</main>
</div>
<script src="{{ mix('js/app.js') }}"></script>
<script src="{{ asset('vendor/datatables/buttons.server-side.js') }}"></script>
@stack('scripts')
</body>
</html>

Answer 1

在这里找到答案https://www.gitmemory.com/issue/yajra/laravel-datatables-editor/46/552975895

views/layouts/app.blade.php，就在<头>

<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/select/1.3.1/css/select.dataTables.min.css"/>
</head>

views/layouts/app.blade.php，就在<正文>

<script type="text/javascript" src="https://cdn.datatables.net/select/1.3.1/js/dataTables.select.js"></script>
@stack('scripts')
</body>

app/DataTables/UsersDataTable.php

return $this->builder()
->setTableId('users-table')
->columns($this->getColumns())
->minifiedAjax()
->dom('Bfrtip')
// ---------------------------------------------
->select(true)
//---------------------------------------------
->orderBy(1)
->buttons(
Button::make('create')->editor('editor'),
Button::make('edit')->editor('editor'),
Button::make('remove')->editor('editor'),
Button::make('export'),
Button::make('print'),
Button::make('reset'),
Button::make('reload')
)
->editor(
Editor::make()
->fields([
FieldsText::make('name'),
FieldsText::make('email'),
FieldsPassword::make('password'),
])
//---------------------------------------------
->idSrc(['id'])
//---------------------------------------------
);