Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u184721437

Directory:

/home/u184721437/domains/dataduck.in/public_html/app-project/erp-software/Modules/User/DataTables

Free Space:

7.07 TB

🔧 Quick Actions

✏️ Editing: UsersDataTable.php

<?php

namespace Modules\User\DataTables;

use App\Models\User;
use Yajra\DataTables\Html\Button;
use Yajra\DataTables\Html\Column;
use Yajra\DataTables\Html\Editor\Editor;
use Yajra\DataTables\Html\Editor\Fields;
use Yajra\DataTables\Services\DataTable;

class UsersDataTable extends DataTable
{

public function dataTable($query) {
 return datatables()
 ->eloquent($query)
 ->addColumn('role', function ($data) {
 return view('user::users.partials.roles', [
 'roles' => $data->getRoleNames()
 ]);
 })
 ->addColumn('action', function ($data) {
 return view('user::users.partials.actions', compact('data'));
 })
 ->addColumn('status', function ($data) {
 if ($data->is_active == 1) {
 $html = 'Active';
 } else {
 $html = 'Deactivated';
 }

return $html;
            })
            ->addColumn('image', function ($data) {
                $url = $data->getFirstMediaUrl('avatars');

return '<img src="' . $url . '" style="width:50px;height:50px;" class="img-thumbnail rounded-circle"/>';
 })
 ->rawColumns(['image', 'status']);
 }

public function query(User $model) {
        return $model->newQuery()
            ->with(['roles' => function ($query) {
                $query->select('name')->get();
            }])
            ->where('id', '!=', auth()->id());
    }

public function html() {
 return $this->builder()
 ->setTableId('users-table')
 ->columns($this->getColumns())
 ->minifiedAjax()
 ->dom("<'row'<'col-md-3'l><'col-md-5 mb-2'B><'col-md-4'f>> .
 'tr' .
 <'row'<'col-md-5'i><'col-md-7 mt-2'p>>")
 ->orderBy(6)
 ->buttons(
 Button::make('excel')
 ->text(' Excel'),
 Button::make('print')
 ->text(' Print'),
 Button::make('reset')
 ->text(' Reset'),
 Button::make('reload')
 ->text(' Reload')
 );
 }

protected function getColumns() {
        return [
            Column::computed('image')
                ->className('text-center align-middle'),

Column::make('name')
                ->className('text-center align-middle'),

Column::make('email')
                ->className('text-center align-middle'),

Column::computed('role')
                ->className('text-center align-middle'),

Column::computed('status')
                ->className('text-center align-middle'),

Column::computed('action')
                ->exportable(false)
                ->printable(false)
                ->className('text-center align-middle'),

Column::make('created_at')
                ->visible(false)
        ];
    }

protected function filename(): string {
        return 'Users_' . date('YmdHis');
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: UsersDataTable.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation