One Hat Cyber Team

Your IP: 216.73.216.142
Server IP: 217.76.53.76
Server: Linux vmi1397931.contaboserver.net 5.4.0-105-generic #119-Ubuntu SMP Mon Mar 7 18:49:24 UTC 2022 x86_64
Server Software: Apache
PHP Version: 8.2.27
Buat File | Buat Folder
Dir : ~/www/wwwroot/mydetails.com.ng/app/Http/Livewire/
View File Name : ScheduleAppointmentTable.php

<?php

namespace App\Http\Livewire;

use App\Models\Vcard;
use App\Models\ScheduleAppointment;
use Illuminate\Database\Eloquent\Builder;
use App\Http\Livewire\LivewireTableComponent;
use Illuminate\Support\Facades\Log;
use Rappasoft\LaravelLivewireTables\Views\Column;


class ScheduleAppointmentTable extends LivewireTableComponent
{
    protected $model = ScheduleAppointment::class;

    protected $type;
    protected $status;

    public bool $showButtonOnHeader = true;

    protected $listeners = ['refresh' => '$refresh', 'changeFilter', 'changeFilterStatus', 'resetPageTable'];

    public string $buttonComponent = 'appointment.calander-button';

    public function configure(): void
    {
        $this->setPrimaryKey('id');
        $this->setPageName('appointment-table');
        $this->setDefaultSort('id', 'desc');
        $this->setSortingPillsStatus(false);
        $this->setPerPage(10);
        $this->setColumnSelectStatus(false);
    }

    public function columns(): array
    {
        return [
            Column::make(__('messages.vcard.vcard_name'), 'vcard.name')
                ->sortable(function (Builder $query, $direction) {
                    return $query->orderBy(Vcard::select('name')->whereColumn('id', 'vcard_id'),
                        $direction);
                })->searchable(),
            Column::make(__('messages.common.name'), 'name')
                ->sortable()->searchable(),
            Column::make(__('messages.common.email'), 'email')
                ->sortable()->searchable(),
            Column::make(__('messages.common.phone'), 'phone')
                ->sortable()->searchable()->view('appointment.columns.phone'),
            Column::make(__('messages.mail.appointment_time'), 'date')
                ->sortable()->searchable()->view('appointment.columns.appointment_time'),
            Column::make(__('messages.common.status'), 'status')
                ->sortable()->view('appointment.columns.status'),
            Column::make(__('messages.common.type'), 'id')->view('appointment.columns.type'),
            Column::make(__('messages.common.action'), 'id')->view('appointment.columns.action'),
            Column::make('tran_id','appointment_tran_id')->hideIf(1),
            Column::make('from','from_time')->hideIf(1),
            Column::make('to','to_time')->hideIf(1)
        ];
    }

    public function changeFilter($value)
    {
        $this->type = $value;
        $this->setBuilder($this->builder());
    }

    public function changeFilterStatus($value)
    {
        $this->status = $value;
        $this->setBuilder($this->builder());
    }

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

        $scheduleAppointments = ScheduleAppointment::with('vcard')->whereIn('vcard_id', $vcardIds);

            $scheduleAppointments->when($type != "", function ($q) use ($type) {
                if ($type == ScheduleAppointment::PAID) {
                    $q->whereNotNull('appointment_tran_id');
                }
                if ($type == ScheduleAppointment::FREE) {
                    $q->whereNull('appointment_tran_id');
                }
            });

            $scheduleAppointments->when($status != "", function ($q) use ($status) {
                if ($status == ScheduleAppointment::COMPLETED) {
                    $q->where('schedule_appointments.status', ScheduleAppointment::COMPLETED);
                }
                if ($status == ScheduleAppointment::PENDING) {
                    $q->where('schedule_appointments.status',ScheduleAppointment::PENDING);
                }
            });

        return $scheduleAppointments;
    }

    public function resetPageTable($pageName = 'appointment-table')
    {
        $rowsPropertyData = $this->getRows()->toArray();
        $prevPageNum = $rowsPropertyData['current_page'] - 1;
        $prevPageNum = $prevPageNum > 0 ? $prevPageNum : 1;
        $pageNum = count($rowsPropertyData['data']) > 0 ? $rowsPropertyData['current_page'] : $prevPageNum;

        $this->setPage($pageNum, $pageName);
    }
}