CORE_V5 // Livewire

PATH: home / cardxfeb / public_html / app / Livewire /

Editing: EnquiriesTable.php

<?php

namespace App\Livewire;

use App\Models\Enquiry;
use App\Models\Vcard;
use Illuminate\Database\Eloquent\Builder;
use Rappasoft\LaravelLivewireTables\Views\Column;
use Rappasoft\LaravelLivewireTables\DataTableComponent;

class EnquiriesTable extends LivewireTableComponent
{
    protected $model = Enquiry::class;

public bool $showButtonOnHeader = false;

public function configure(): void
    {
        $this->setPrimaryKey('id');
        $this->setPageName('enquiries-table');
        $this->setDefaultSort('created_at', 'desc');
        $this->setColumnSelectStatus(false);
        $this->setQueryStringStatus(false);
        $this->resetPage('enquiries-table');

$this->setThAttributes(function (Column $column) {
            if ($column->isField('id')) {
                return [
                    'class' => 'd-flex justify-content-start',
                ];
            }

return [];
        });
    }

public function columns(): array
    {
        return [
            Column::make(__('messages.vcard.vcard_name'), 'vcard.name')->searchable()->sortable(function (
                Builder $query,
                $direction
            ) {
                return $query->orderBy(
                    vcard::select('name')->whereColumn('vcards.id', 'enquiries.vcard_id'),
                    $direction
                );
            }),
            Column::make(__('messages.common.name'), 'name')->sortable()->searchable(),
            Column::make(__('messages.common.email'), 'email')->searchable()->sortable()->view('enquiry.columns.email'),
            Column::make(__('messages.common.phone'), 'phone')->searchable(),
            Column::make(__('messages.enquiries.attachment'), 'id')->view('enquiry.columns.attachment'),
            Column::make(__('messages.vcard.created_on'), 'created_at')->sortable()->searchable()->view('enquiry.columns.date'),
            Column::make(__('messages.common.action'), 'id')->view('enquiry.columns.action'),

];
    }

public function builder(): Builder
    {
        $vcardIds = Vcard::whereTenantId(getLogInTenantId())->pluck('id')->toArray();

return Enquiry::with('vcard')->whereIn('vcard_id', $vcardIds);
    }
    public function placeholder()
    {
        return view('lazy_loading.without-listing-skelecton');
    }
}

CANCEL