striped() ->type(Exportable::TYPE_XLS, Exportable::TYPE_CSV), Header::make()->showSearchInput(), Footer::make() ->showPerPage(0) ->showRecordCount(), Detail::make() ->view('components.detail') ->showCollapseIcon() ->params([]), ]; } public function datasource(): Builder { return EinundzwanzigPleb::query() ->with([ 'profile', 'paymentEvents' => fn($query) => $query ->where('year', date('Y')) ->where('paid', true), ]) ->where('association_status', '>', 1) ->orWhereNotNull('application_for'); } public function fields(): PowerGridFields { return PowerGrid::fields() ->add('pubkey') ->add( 'avatar', fn($model, ) => '

', ) ->add( 'for', fn($model, ) => $model->application_for ? '

'.AssociationStatus::from( $model->application_for, )->label().'

' : '', ) ->add( 'payment', fn(EinundzwanzigPleb $model) => $model->paymentEvents->count() > 0 && $model->paymentEvents->first()->paid ? ''.number_format( $model->paymentEvents->first()->amount, 0, ',', '.', ).'' : 'keine Zahlung vorhanden', ) ->add('npub_export', fn(EinundzwanzigPleb $model) => $model->npub) ->add( 'npub', fn(EinundzwanzigPleb $model) => 'Nostr Profile', ) ->add('association_status') ->add('association_status_name', fn(EinundzwanzigPleb $model) => $model->association_status->name) ->add('paid_export', fn(EinundzwanzigPleb $model) => $model->paymentEvents->first()?->amount) ->add( 'association_status_formatted', function (EinundzwanzigPleb $model) { $class = match ($model->association_status) { AssociationStatus::DEFAULT => 'text-xs inline-flex font-medium rounded-full text-center px-2.5 py-1 bg-gray-500/20 text-gray-200', AssociationStatus::PASSIVE => 'text-xs inline-flex font-medium rounded-full text-center px-2.5 py-1 bg-yellow-500/20 text-yellow-700', AssociationStatus::ACTIVE => 'text-xs inline-flex font-medium rounded-full text-center px-2.5 py-1 bg-green-500/20 text-green-700', AssociationStatus::HONORARY => 'text-xs inline-flex font-medium rounded-full text-center px-2.5 py-1 bg-blue-500/20 text-blue-700', default => 'text-xs inline-flex font-medium rounded-full text-center px-2.5 py-1 text-red-700', }; return ''.$model->association_status->label().''; }, ) ->add( 'name_lower', fn(EinundzwanzigPleb $model) => strtolower( e($model->profile?->name ?: $model->profile?->display_name ?? ''), ), ); } public function columns(): array { return [ Column::make('Avatar', 'avatar') ->visibleInExport(visible: false), Column::make('Npub', 'npub') ->visibleInExport(visible: false) ->sortable(), Column::make('Name', 'name_lower') ->visibleInExport(visible: true) ->sortable(), Column::make('Aktueller Status', 'association_status_formatted', 'association_status') ->visibleInExport(visible: false) ->sortable(), Column::make('Beitrag '.date('Y'), 'payment') ->visibleInExport(visible: false), Column::make('Bewirbt sich für', 'for', 'application_for') ->visibleInExport(visible: false) ->sortable(), Column::action('Action') ->visibleInExport(visible: false), Column::make('Email', 'email') ->hidden() ->visibleInExport(visible: true), Column::make('Status', 'association_status_name') ->hidden() ->visibleInExport(visible: true), Column::make('Npub', 'npub_export') ->hidden() ->visibleInExport(visible: true), Column::make('Bezahlt', 'paid_export') ->hidden() ->visibleInExport(visible: true), ]; } public function filters(): array { return []; } #[\Livewire\Attributes\On('accept')] public function accept($rowId): void { $pleb = EinundzwanzigPleb::query() ->with('profile') ->findOrFail($rowId); $this->dialog()->confirm([ 'title' => 'Bist du sicher?', 'description' => 'Möchtest du '.$pleb->profile->name.' wirklich akzeptieren?', 'acceptLabel' => 'Ja, akzeptieren', 'method' => 'acceptPleb', 'params' => $rowId, ]); } #[\Livewire\Attributes\On('delete')] public function delete($rowId): void { $pleb = EinundzwanzigPleb::query() ->with('profile') ->findOrFail($rowId); $this->dialog()->confirm([ 'title' => 'Bist du sicher?', 'description' => 'Möchtest du '.$pleb->profile->name.' wirklich löschen?', 'acceptLabel' => 'Ja, lösche', 'method' => 'deletePleb', 'params' => $rowId, ]); } public function acceptPleb($rowId) { $pleb = EinundzwanzigPleb::query()->findOrFail($rowId); $for = $pleb->application_for; $text = $pleb->application_text; $pleb->association_status = AssociationStatus::from($for); $pleb->application_for = null; $pleb->archived_application_text = $text; $pleb->application_text = null; $pleb->save(); $this->fillData(); } public function deletePleb($rowId) { $pleb = EinundzwanzigPleb::query()->findOrFail($rowId); $pleb->application_for = null; $pleb->application_text = null; $pleb->save(); $this->fillData(); } public function actions(EinundzwanzigPleb $row): array { return [ Button::add('delete') ->slot('Löschen') ->id() ->class( 'btn bg-white dark:bg-gray-800 border-gray-200 dark:border-gray-700/60 hover:border-gray-300 dark:hover:border-gray-600 text-red-500', ) ->dispatch('delete', ['rowId' => $row->id]), Button::add('accept') ->slot('Akzeptieren') ->id() ->class( 'btn bg-white dark:bg-gray-800 border-gray-200 dark:border-gray-700/60 hover:border-gray-300 dark:hover:border-gray-600 text-green-500', ) ->dispatch('accept', ['rowId' => $row->id]), ]; } public function actionRules(EinundzwanzigPleb $row): array { return [ // Hide button edit for ID 1 Rule::button('accept') ->when(fn($row) => $row->application_for === null) ->hide(), ]; } }