| Server IP : 14.225.204.176 / Your IP : 216.73.216.6 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: BookingStatusDataTable.php
* Last modified: 2021.11.24 at 19:13:48
* Author: SmarterVision - https://codecanyon.net/user/smartervision
* Copyright (c) 2022
*/
namespace App\DataTables;
use App\Models\BookingStatus;
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 BookingStatusDataTable 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)
{
$dataTable = new EloquentDataTable($query);
$columns = array_column($this->getColumns(), 'data');
$dataTable = $dataTable
->editColumn('updated_at', function ($bookingStatus) {
return getDateColumn($bookingStatus, 'updated_at');
})
->editColumn('status', function ($bookingStatus) {
return $bookingStatus->status;
})
->addColumn('action', 'booking_statuses.datatables_actions')
->rawColumns(array_merge($columns, ['action']));
return $dataTable;
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
$columns = [
[
'data' => 'order',
'title' => trans('lang.booking_status_order'),
],
[
'data' => 'status',
'title' => trans('lang.booking_status_status'),
],
[
'data' => 'updated_at',
'title' => trans('lang.booking_status_updated_at'),
'searchable' => false,
]
];
$hasCustomField = in_array(BookingStatus::class, setting('custom_field_models', []));
if ($hasCustomField) {
$customFieldsCollection = CustomField::where('custom_field_model', BookingStatus::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.booking_status_' . $field->name),
'orderable' => false,
'searchable' => false,
]]);
}
}
return $columns;
}
/**
* Get query source of dataTable.
*
* @param BookingStatus $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query(BookingStatus $model)
{
return $model->newQuery()->select('booking_statuses.*');
}
/**
* 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),
'order' => [[0, 'asc']],
]
));
}
/**
* 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 'booking_statusesdatatable_' . time();
}
}