Laravel Datatable Ssp Laravel Package

Laravel 13 Compatibility

Change dependencies for Laravel 12

• should not cache indefinitely if $cache_timeout=0

• correct the info in response when user request all items (itemsPerPage === -1)

• can set db_for_search in columns option to specify what column to use when perform search

allow to cache response()->json()

how to use:

• response()->json($cache_timeout, $extended_cache_name);

for example response()->json(120); will cache response()->json() output for 120 seconds

• return items_per_page data in getData method
• thus, $ssp->response()->json() also will return this data

• return current_page and total_pages data in getData method
• thus, $ssp->response()->json() also will return these data

• can customize csv filename in response()->csv($filename, $is_include_datetime_in_filename)
• can set prefix for csv filename

• improved export to csv with large data

• ValidationException can be customizable

Fix column name alias handling (multiple AS expression issue)

• fix lengthMenu in datatablejs (should not include in settings if allowItemsPerPage is null)

• New feature: Replace with SSP->frontend()->setResponseDataRoute($route_name, $parameters = [], $absolute = true)
• Remove feature: SSP->frontend()->setResponseDataRouteName($route_name)

• New feature: Can disable fetch on init (only applied to others framework) on frontend (e.g: $ssp->frontend()->disableFetchOnInit())

• Refactoring (separate into a few Handler)
• New feature: Set frontend settings using chaining method (e.g: $ssp->frontend()->setResponseDataRouteName('users.data')->setInitialSorting('created_at', true))
• New feature: Get frontend settings via only a single method (e.g: $ssp->frontend()->getSettings())
• Remove feature: SSP->setFrontEndFramework()
• Remove feature: SSP->getFrontEndColumns()
• Remove feature: SSP->getFrontEndInitialSorting()

Initial release for version 3

New Feature

• Custom Query

Amend

• Use custom function to get last item in array to avoid conflict with older Laravel version.

Debug

• searchable option

Improvement

• Can use DB::raw() in groupBy feature

Debug

• Use raw column name for order by

New feature

• Can set if the column is searchable (true/false)

Improvement

• Use subquery if not model

Debug

• Default blank array for MySQL variables

New feature

• MySQL variables initiator

Debug

• alias column name for DB raw

Debug

• Check if the formatter is instance of Closure