如何将 Yajra 数据表作为日期而不是字符串进行排序

How to ordering Yajra Datatable as a date instead of string

提问人:Lana Septiana 提问时间:9/18/2023 更新时间:9/20/2023 访问量:51

问:

有谁知道如何将列“Tanggal Dibuat”(created_at)按日期排序?目前,当我点击它时。我认为日期没有显示正确的顺序,因为created_at被读取为字符串,而不是日期。我正在使用 Laravel 8 和 Yajra 数据表。这是我的 datatable 文件夹中的 UsersDatatables 代码

public function dataTable($query)
{
    return datatables()
        ->eloquent($query)->addIndexColumn()
        ->editColumn('created_at', function($data) {
            $formatedDate = Carbon::createFromFormat('Y-m-d H:i:s', $data->created_at)->format('d/m/Y'); return $formatedDate; })
        ->editColumn('updated_at', function($data) {
                $formatedDate = Carbon::createFromFormat('Y-m-d H:i:s', $data->updated_at)->format('d/m/Y'); return $formatedDate; })
        ->editColumn('is_active', function ($item) {
                return $item->is_active == 1 ? 'AKTIF' : 'NON-AKTIF';
        })
        ->addColumn('action', function($item) {
                return '
                    <div class="btn-group">
                        <div class="dropdown">
                            <button class="btn btn-primary btn-sm dropdown-toggle" type="button" id="dropdownMenuButton" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                Aksi
                            </button>
                            <ul class="dropdown-menu" aria-labelledby="dropdownMenuButton">
                                <li>
                                    <a class="dropdown-item" href="'. route('user.edit', $item->id) .'">
                                        Ubah 
                                    </a>
                                </li>
                                <li>
                                    <a href="'. route('user.delete', $item->id) .'" class="dropdown-item text-danger" data-confirm-delete="true">
                                        Delete
                                    </a>
                                </li>
                            </ul>
                        </div>
                    </div>
                ';
    });
}

public function query(User $model)
{
    return $model::with('role');
}

public function html()
{
    return $this->builder()
                ->scrollY(725)
                ->scrollCollapse(false)
                ->setTableId('users-table')
                ->serverSide(false)
                ->languagePaginateNext('→')
                ->languagePaginatePrevious('←')
                ->columns($this->getColumns())
                ->minifiedAjax()
                ->orderBy(0, 'asc');
}

protected function getColumns()
{
    return [
        Column::make('DT_RowIndex')
              ->title('No')
              ->addClass('text-center')
              ->orderable(false),
        Column::make('name')
              ->addClass('text-center')
              ->title('Nama'),
        Column::make('role.name')
              ->addClass('text-center')
              ->title('Role'),
        Column::make('is_active')
              ->addClass('text-center')
              ->title('Status'),
        Column::make('created_at')
              ->addClass('text-center')
              ->title('Tanggal Dibuat'),
        Column::computed('action')
              ->addClass('text-center')
              ->title('Opsi')
              ->exportable(false)
              ->printable(false)
              ->addClass('text-center')
    ];
}

protected function filename()
{
    return 'User_' . date('YmdHis');
}

enter image description here

javascript php html ajax laravel

评论


答:

0赞 cengsemihsahin 9/18/2023 #1

Yajra Datatables 在前端使用 jquery datatables。从这里可以看出,您可以通过现有函数进行排序:

适合您的功能可能是: https://datatables.net/reference/option/columns.orderDataorderData()

这样做是这样的:

public function html()
{
    return $this->builder()
                ->scrollY(725)
                ->scrollCollapse(false)
                ->setTableId('users-table')
                ->serverSide(false)
                ->languagePaginateNext('→')
                ->languagePaginatePrevious('←')
                ->columns($this->getColumns())
                ->minifiedAjax()
                ->orderBy(4, 'desc') // Order by the 4th column (created_at) in descending order
                ->orderData([4, 0]); // Specify that the 4th column (created_at) should be treated as date for ordering
}

评论

0赞 Lana Septiana 9/18/2023
我收到错误BadMethodCallException方法Yajra\DataTables\Html\Builder::orderData不存在。还有其他方法吗?
1赞 Md. Mostafijur Rahman 9/19/2023 #2

试试这个

public function query(User $model)
{
    return $model::with('role')->orderBy('created_at', 'asc');
}

评论

1赞 corn on the cob 9/19/2023
您能否解释一下您的代码,以方便这个问题的未来读者?提前致谢!
0赞 Lana Septiana 9/20/2023 #3

所以我找到了“我的方式”来做到这一点,第一步是将数据created_at转换为 unix 时间戳格式(整数),然后将其显示为正常日期