| Server IP : 14.225.204.176 / Your IP : 216.73.216.252 Web Server : nginx/1.24.0 System : Linux nodejs-ybgk 6.8.0-40-generic #40-Ubuntu SMP PREEMPT_DYNAMIC Fri Jul 5 10:34:03 UTC 2024 x86_64 User : root ( 0) PHP Version : 8.1.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/html/php/home-services/app/DataTables/ |
Upload File : |
<?php
/*
* File name: AddressDataTable.php
* Last modified: 2021.03.21 at 12:22:10
* Author: SmarterVision - https://codecanyon.net/user/smartervision
* Copyright (c) 2021
*/
namespace App\DataTables;
use App\Models\Address;
use App\Models\CustomField;
use Barryvdh\DomPDF\Facade as PDF;
use Yajra\DataTables\DataTableAbstract;
use Yajra\DataTables\EloquentDataTable;
use Yajra\DataTables\Html\Builder;
use Yajra\DataTables\Services\DataTable;
class AddressDataTable extends DataTable
{
/**
* custom fields columns
* @var array
*/
public static $customFields = [];
/**
* Build DataTable class.
*
* @param mixed $query Results from query() method.
* @return DataTableAbstract
*/
public function dataTable($query): DataTableAbstract
{
$dataTable = new EloquentDataTable($query);
$columns = array_column($this->getColumns(), 'data');
$dataTable = $dataTable
->editColumn('updated_at', function ($address) {
return getDateColumn($address, 'updated_at');
})
->addColumn('action', 'addresses.datatables_actions')
->rawColumns(array_merge($columns, ['action']));
return $dataTable;
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns(): array
{
$columns = [
[
'data' => 'description',
'title' => trans('lang.address_description'),
],
[
'data' => 'address',
'title' => trans('lang.address_address'),
],
(auth()->check() && auth()->user()->hasRole('admin')) ?
[
'data' => 'user.name',
'title' => trans('lang.address_user_id'),
] : null,
[
'data' => 'updated_at',
'title' => trans('lang.address_updated_at'),
'searchable' => false,
]
];
$columns = array_filter($columns);
$hasCustomField = in_array(Address::class, setting('custom_field_models', []));
if ($hasCustomField) {
$customFieldsCollection = CustomField::where('custom_field_model', Address::class)->where('in_table', '=', true)->get();
foreach ($customFieldsCollection as $key => $field) {
array_splice($columns, $field->order - 1, 0, [[
'data' => 'custom_fields.' . $field->name . '.view',
'title' => trans('lang.address_' . $field->name),
'orderable' => false,
'searchable' => false,
]]);
}
}
return $columns;
}
/**
* Get query source of dataTable.
*
* @param Address $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query(Address $model)
{
if (auth()->user()->hasRole('admin')) {
return $model->newQuery()->with("user");
} else {
return $model->newQuery()->with("user")->where('addresses.user_id', auth()->id());
}
}
/**
* Optional method if you want to use html builder.
*
* @return Builder
*/
public function html()
{
return $this->builder()
->columns($this->getColumns())
->minifiedAjax()
->addAction(['width' => '80px', 'printable' => false, 'responsivePriority' => '100'])
->parameters(array_merge(
config('datatables-buttons.parameters'), [
'language' => json_decode(
file_get_contents(base_path('resources/lang/' . app()->getLocale() . '/datatable.json')
), true)
]
));
}
/**
* Export PDF using DOMPDF
* @return mixed
*/
public function pdf()
{
$data = $this->getDataForPrint();
$pdf = PDF::loadView($this->printPreview, compact('data'));
return $pdf->download($this->filename() . '.pdf');
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'addressesdatatable_' . time();
}
}