One Hat Cyber Team

Your IP: 216.73.216.19
Server IP: 178.33.27.10
Server: Linux cpanel.dev-unit.com 3.10.0-1160.108.1.el7.x86_64 #1 SMP Thu Jan 25 16:17:31 UTC 2024 x86_64
Server Software: Apache/2.4.57 (Unix) OpenSSL/1.0.2k-fips
PHP Version: 8.2.11
Buat File | Buat Folder
Dir : ~/home/id/hospital.dev-unit.com/app/Livewire/
View File Name : AccountantPayrollRelationTable.php

<?php

namespace App\Livewire;

use App\Models\Accountant;
use App\Models\EmployeePayroll;
use Filament\Forms\Concerns\InteractsWithForms;
use Filament\Forms\Contracts\HasForms;
use Filament\Tables\Columns\TextColumn;
use Filament\Tables\Concerns\InteractsWithTable;
use Filament\Tables\Contracts\HasTable;
use Filament\Tables\Table;
use Illuminate\Support\Facades\Route;
use Livewire\Component;

class AccountantPayrollRelationTable extends Component implements HasForms, HasTable
{
    use InteractsWithForms;
    use InteractsWithTable;

    public $record;

    public function GetRecord()
    {
        $id = Route::current()->parameter('record');
        $accountants = Accountant::with('payrolls')->where('id', $id)->get();

        foreach ($accountants as $item) {
            $this->record = $item->payrolls;
        }

        $payrollIds = $this->record->pluck('payroll_id')->toArray();
        $payrolls = EmployeePayroll::whereIn('payroll_id', $payrollIds);

        return $payrolls;
    }

    public function table(Table $table): Table
    {
        return $table
            ->query(self::GetRecord())
            ->paginated([10, 25, 50])
            ->columns([
                TextColumn::make('payroll_id')
                    ->badge()
                    ->label(__('messages.employee_payroll.payroll_id'))
                    ->searchable()
                    ->sortable()
                    ->color('primary'),
                TextColumn::make('month')
                    ->label(__('messages.employee_payroll.month'))
                    ->searchable()
                    ->sortable(),
                TextColumn::make('year')
                    ->label(__('messages.employee_payroll.year'))
                    ->searchable()
                    ->sortable(),
                TextColumn::make('basic_salary')
                    ->label(__('messages.employee_payroll.basic_salary'))
                    ->searchable()
                    ->formatStateUsing(fn ($state) => getCurrencyFormat($state, 2))
                    ->sortable(),
                TextColumn::make('allowance')
                    ->label(__('messages.employee_payroll.allowance'))
                    ->searchable()
                    ->formatStateUsing(fn ($state) => getCurrencyFormat($state, 2))
                    ->sortable(),
                TextColumn::make('deductions')
                    ->label(__('messages.employee_payroll.deductions'))
                    ->searchable()
                    ->formatStateUsing(fn ($state) => getCurrencyFormat($state, 2))
                    ->sortable(),
                TextColumn::make('net_salary')
                    ->label(__('messages.employee_payroll.net_salary'))
                    ->searchable()
                    ->formatStateUsing(fn ($state) => getCurrencyFormat($state, 2))
                    ->sortable(),
                TextColumn::make('status')
                    ->label(__('messages.common.status'))
                    ->searchable()
                    ->formatStateUsing(fn ($state) => $state ? __('messages.employee_payroll.paid') : __('messages.employee_payroll.not_paid'))
                    ->badge()
                    ->color(fn ($record) => $record->status ? 'success' : 'danger')
                    ->sortable(),
            ])
            ->filters([
                //
            ])
            ->bulkActions([
                // Tables\Actions\BulkActionGroup::make([
                //     Tables\Actions\DeleteBulkAction::make(),
                // ]),
            ])
            ->emptyStateHeading(__('messages.common.no_data_found'));
    }

    public function render()
    {
        return view('livewire.accountant-payroll-relation-table');
    }
}