livewire-powergrid

New Feature

Action Rules - https://github.com/Power-Components/livewire-powergrid/pull/217

Doc: https://livewire-powergrid.com/#/table/action-rules?id=action-rules

🛠️ Fix

showToggleColumns() mess with #218

🛠️ Fix

action parameters when entry is null

🛠️ Fix

withSum() & withAvg() not working for calculated data Bug Fixed. #222
withCount should only count "valid" records #226
action parameters does not work with zero https://github.com/Power-Components/livewire-powergrid/issues/224

Added

Delete After Download export option (default true) #223

 public function setUp(): void
    {
        // ...
        ->showExportOption('download', ['excel', 'csv'], ['deleteAfterDownload' => true]);

🛠️ Fix

https://github.com/Power-Components/livewire-powergrid/issues/220 - undefined $row when defining a single button in header method

Deprecation

In this version, AlpineJs ^3 is a requirement - deprecation to v2

Upgrade From V1

🛠️ Fix

• powergrid:create - #191, #194, #199 (create based on default App\Models directory. enum field and directory)

• layout improvements for Bootstrap5

• resetPage() order

Added

• TotalRow feature - #179
• tableName - to avoid conflicts between multiple tables on the same page with the same model
• laravel-mix, powergrid.js and powergrid.css
• CI - php 8.1
• named event listeners

New Contributors

• @shishamchudal made their first contribution in https://github.com/Power-Components/livewire-powergrid/pull/179

Full Changelog: https://github.com/Power-Components/livewire-powergrid/compare/v1.5.1...v2.0.0

🛠️ Fixes

• RecordCount display by @Augen2203 in https://github.com/Power-Components/livewire-powergrid/pull/170
• Filter translation + Badge for tests + PhpStorm by @dansysanalyst in https://github.com/Power-Components/livewire-powergrid/pull/158

🔥 Translations

• 🌐 CA|ES|DE by @dansysanalyst in https://github.com/Power-Components/livewire-powergrid/pull/158
• IT translations by @masterix21 in https://github.com/Power-Components/livewire-powergrid/pull/167
• Indonesian lang by @NathanaelGT in https://github.com/Power-Components/livewire-powergrid/pull/157

Added

• More tests by @luanfreitasdev in https://github.com/Power-Components/livewire-powergrid/pull/160

New Contributors

• @Augen2203 made their first contribution in https://github.com/Power-Components/livewire-powergrid/pull/170

Full Changelog: https://github.com/Power-Components/livewire-powergrid/compare/v1.5.0...v1.5.1

🛠️ Fixes

• Larastan php74 by @dansysanalyst in https://github.com/Power-Components/livewire-powergrid/pull/124
• Larastan by @dansysanalyst in https://github.com/Power-Components/livewire-powergrid/pull/126
• [tests] Fix wrong column type in migrations by @dansysanalyst in https://github.com/Power-Components/livewire-powergrid/pull/134
• Larastan by @luanfreitasdev in https://github.com/Power-Components/livewire-powergrid/pull/125
• Tests with supported DBs + Input filter null/blank/empty by @dansysanalyst in https://github.com/Power-Components/livewire-powergrid/pull/147
• add disabled input text by @luanfreitasdev in https://github.com/Power-Components/livewire-powergrid/pull/148
• Prevent xss attack by @NathanaelGT in https://github.com/Power-Components/livewire-powergrid/pull/146
• New parameter for sortBy Method by @throwexceptions in https://github.com/Power-Components/livewire-powergrid/pull/151
• feature: support for all databases supported by laravel to the functionality for sorting alphanumeric values by @vs0uz4 in https://github.com/Power-Components/livewire-powergrid/pull/149
• Stubs passing static analysis by @dansysanalyst in https://github.com/Power-Components/livewire-powergrid/pull/153
• feature: [wip] implementation of the rescue functionality of the database server version used by @vs0uz4 in https://github.com/Power-Components/livewire-powergrid/pull/155
• SqlSupport refactoring by @dansysanalyst in https://github.com/Power-Components/livewire-powergrid/pull/156
• Dev - 1.5 by @luanfreitasdev in https://github.com/Power-Components/livewire-powergrid/pull/152

New Contributors

• @NathanaelGT made their first contribution in https://github.com/Power-Components/livewire-powergrid/pull/146
• @throwexceptions made their first contribution in https://github.com/Power-Components/livewire-powergrid/pull/151

Full Changelog: https://github.com/Power-Components/livewire-powergrid/compare/v1.4.7...v1.5.0

Notes:

• With Sort String Number (SortField with +0) - By default it is disabled, but you can enable it by changing the property: $withSortStringNumber - https://github.com/Power-Components/livewire-powergrid/issues/111
• Update message is disabled by default: bool $showUpdateMessages

• Prefix in sorting with join is ignored by default. bool $ignoreTablePrefix = true avoiding problems with table names with joins when you need to remove them
• Table prefix has been removed: sortable(string $tableWithColumn = ''). Now is sortable()

Before:

Column::add()
     ->title('Category')
     ->field('category_name')
     ->sortable('categories.name'),

After:

Column::add()
     ->title('Category')
     ->field('category_name')
     ->sortable(),

• Table prefix has been removed: searchable(string $tableWithColumn = ''). Now is searchable()

Before:

Column::add()
     ->title('Category')
     ->field('category_name')
     ->searchable('categories.name'),

After:

Column::add()
     ->title('ID')
     ->field('id')
     ->searchable(),

• Add dataField extra parameters do field method.

Column::add()
     ->title('Category')
     ->field('category_name', 'categories.name')
     ->searchable(),

🛠️ Fixes

issues:

• search problem when joining multiple tables #129
• more issues with ambiguous columns when using join #111
• fix action method on action #128
• exporting with join sortable.

good practices with join

1. SortField and primaryKey values:

    public string $sortField = 'dishes.id';
    public string $primaryKey = 'dishes.id';

2. Method addColumns:

     ->addColumn('dishes.name', function (Dish $dish) {
           return $dish->name;
      })

3. Method columns;

      Column::add()
          ->title(__('Name'))
          ->field('dishes.name')

🛠️ Fixes

• sortby string number "+0" is now conditional on the variable public bool $withSortStringNumber = false, as it did not have PostgreSQL support and there are no conflicts with join query.
• bootstrap 5 theme don't have a export option #120 - fixed

🔥 New Translation

• Add ms_MY (Bahasa Melayu - Malaysia) translation. #119

🛠️ Fixes

• added custom parameters to emit - https://github.com/Power-Components/livewire-powergrid/issues/116

🛠️ Fixes

• added parameter to specify the column that will be ordered in case of table joins -
  E.g: ->sortable('categories.name') - See more

🔥 New Translation

• added yoruba translation file #113

🛠️ Fixes

• outside filter #96
• add outside filters boolean and text #96
• enabled filters automatically cleared when filter is empty
• add table name on sortField - https://github.com/Power-Components/livewire-powergrid/issues/111
• add alpinev2 alert on console

🛠️ Fixes

• Prefixes table name on search columns (join) - https://github.com/Power-Components/livewire-powergrid/pull/109

🛠️ Fixes

• Layouts improvements
• Temporarily removed inputMultiSelect from demo
• Pagination Issue with filtering - https://github.com/Power-Components/livewire-powergrid/issues/108
• Query count duplicated

⚡️ PowerGrid 1.4 Released! ⚡️

📺 Laravel daily Quick Datatable Package

🔥 New Features

• Export with queues - https://livewire-powergrid.docsforge.com/main/queue-export/
• 🇹🇷 Turkish translation - https://github.com/Power-Components/livewire-powergrid/pull/92

🛠️ Fixes

• table sortBy - https://github.com/Power-Components/livewire-powergrid/issues/99
• Fix Spanish translation - https://github.com/Power-Components/livewire-powergrid/pull/97
• orderBy string numbers - https://github.com/Power-Components/livewire-powergrid/pull/86
• Removed ‘outside’ filter temporarily from boostrap5 - https://github.com/Power-Components/livewire-powergrid/issues/96
• editOnClick - update without refresh - https://github.com/Power-Components/livewire-powergrid/issues/93
• Friendly alert on Tailwind Forms - https://github.com/Power-Components/livewire-powergrid/pull/101

editOnClick:

:

Fixes

• sorBy column not found quando uma coluna é customizada, exemplo:

->addColumn('produced_at_formatted', function (Dish $dish) {
   return Carbon::parse($dish->produced_at)->format('d/m/Y');
})

Fixes

• Empty table row has been removed
• Fixed addition of templates per component
• wire:key was calling by default the 'id' column in collection components

Fixes

• multi select - (only bootstrap 5 theme)
• remove uppercase on filters
• add updatedPage

Fixes:

• $class is undefined on select component - 81
• added FilterSelectTest