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 : AffiliateUserTable.php

<?php

namespace App\Http\Livewire;

use App\Models\User;
use App\Models\AffiliateUser;
use Illuminate\Database\Eloquent\Builder;
use Rappasoft\LaravelLivewireTables\Views\Column;
use Rappasoft\LaravelLivewireTables\DataTableComponent;

class AffiliateUserTable extends LivewireTableComponent
{
    protected $model = AffiliateUser::class;
    
    public function configure(): void
    {
        $this->setPrimaryKey('id');
        $this->setPageName('affiliate-user-table');
        $this->setDefaultSort('created_at', 'desc');
        $this->setColumnSelectStatus(false);
        $this->setPerPage(10);
    }

    public function columns(): array
    {
        return [
            Column::make(__('messages.affiliation.affiliated_by'), "affiliated_by")
            ->sortable(function (Builder $query, $direction) {
                return $query->orderBy(User::select('first_name')->whereColumn('affiliate_users.affiliated_by',
                    'users.id'),
                    $direction);
            })->hideIf(isAdmin())->view('sadmin.affiliateUsers.columns.affilated_by'),
            Column::make(__('messages.common.user'), "user_id")
            ->sortable(function (Builder $query, $direction) {
                return $query->orderBy(User::select('first_name')->whereColumn('affiliate_users.user_id',
                    'users.id'),
                    $direction);
            })->searchable(function (Builder $query, $direction) {
                return $query->whereHas('user', function (Builder $q) use ($direction) {
                    $q->whereRaw(
                        "TRIM(CONCAT(first_name, ' ', last_name)) like '%{$direction}%'"
                    );
                });
            })->view('sadmin.affiliateUsers.columns.user'),
            Column::make(__('messages.setting.affiliation_amount'), "amount")
                ->sortable()->searchable()->view('sadmin.affiliateUsers.columns.affilation_amount'),
            Column::make(__('messages.date'), "created_at")
                ->sortable()->view('sadmin.affiliateUsers.columns.date'),

        ];
    }


    public function builder(): Builder
    {
        $query = AffiliateUser::with('user', 'affiliated_by_user');

        if (isAdmin()) {
            $query->whereAffiliatedBy(getLogInUserId());
        }

        return $query;
    }


}