Laravel DataTables is an API designed to transform Laravel structures (collections, models, query builders) into a suitable format for consumption by the jQuery Datatables plugin.
Questions tagged [laravel-datatables]
69 questions
0
votes
0 answers
Yarja Datatable Laravel - Null Date Value
I am having issue with handling a null values within a datatable.
In short I have a table with outstanding fees, which has a default null value in the table and is updated the Date paid when the person makes the payment.
This my ajax request in my…
Brendan
- 95
- 1
- 15
0
votes
0 answers
laravel datatables html builder not sending ajax request
View
@extends('dashboard.app' , ['title'=>'Faculties'] )
@section('body')
0
votes
1 answer
My laravel Yajra datatable does not render. It says invalid json response. However I can not read the error since the response is empty
Hello I have the following controller method to return data to my datatable in Laravel,
Controller Method
public function get(Request $request) {
return Datatables::of(AppUser::all())
->addColumn('status', function ($user) {
if…
gfit21x
- 141
- 9
0
votes
0 answers
Laravel 5.7: Is it possible to add direct a value in the table?
I was wondering, if it possible to add directly a value in the table.
Because I would like that all with the value "1" are registered
Schema::table('games', function (Blueprint $table) {
$table->integer('rankPosition', '1');
});
Update…
blackplan
- 246
- 2
- 20
0
votes
2 answers
How to get number of the users registered in this month in laravel
Pls help me
I wnat to get number of the Users registered in this week
and number of the Users registered in this month
SinaValipour
- 21
- 5
0
votes
2 answers
Format date column in datatables
i need format date in my datatable column, i´m reading documentation, but i don´t know how i can to do it.
i have this code for create my datatable:
var callTable = $('#calls').DataTable({
dom: 'Bfrtip',
language: {
url:…
scorpions78
- 553
- 4
- 17
0
votes
1 answer
local server displays yajra laravel datatables correctly, remote server gives error 500
I am able to see my datatables on my local server, so I pushed the files to git, pulled them to my local server, and published the assets using php artisan vendor:publish --tag=datatables.
I have also cleared the cache, and tried the following:
$…
mcadio
- 737
- 7
- 27
0
votes
1 answer
The page on the site stopped working after I added the output of the table from the database to the page of the site
I made a display of the plate on the page of the site and then the following error appeared (error screenshot below) error text:
Undefined variable: users (View: /home/vagrant/code/bacon/resources/views/users.blade.php)
My…
Mineral
- 39
- 1
- 1
- 7
0
votes
1 answer
How to use Nested functions substr(), cast() and Max() in query builder in laravel 8?
I posted this question yesterday but I think it's unclear so I deleted it and posted it again with more details.
In my oracle database I have a USERS table with id_user defined as varchar and this varchar is like this: '145/1' ...... '145/9' so to…
Jon
- 57
- 3
- 11
0
votes
1 answer
Error 419 Page Expired. Laravel Yajra datatables
I'm trying to add a form button to delete a record, but for some reason the csrf token doesn't insert it. I've tried many ways but I can't get it to work. Any suggestions?
0
votes
1 answer
Update table DB in Laravel with findOrNew
How I can update table in DB, with use function findOrNew
I want first check column in table. If I have same title not add, if I dont have - push
I campare @title@ in table DB.
public function update(Request $request, $id)
{$news =…
Oleg St
- 9
- 5
0
votes
1 answer
ColReorder is not working in Responsive DataTables?
I have DataTables and implemented the colReorder by dragging the checkbox element using .sortable() jquery-ui and everything is fine. But when I enable responsive:true the column is not ordering any more.
The reorder index is stored from DB and…
Marky
- 55
- 1
- 2
- 11
0
votes
1 answer
how to do Role Base Access in Laravel?
I am new in Laravel How to do in laravel role with the following table
$table->id();
$table->string('name');
$table->string('email');
$table->timestamp('email_verified_at')->nullable();
…
inasar
- 51
- 1
- 8
0
votes
2 answers
Laravel Yajra Datatables Hide Null Column
Wha is the best way to hide empty or null comumns from Yajra Datatables:
var table = $('.data-table').DataTable({
processing: true,
serverSide: true,
ajax: "{{ route('any.route') }}",
columns: [
// How to Hide…
romaya
- 21
- 1
- 8
0
votes
2 answers
how can i search all data in datatables yajra
i try to use yajra datatables laravel
i have problem in searching
when i search data already exits in datatables it no working
me already try example in documentation but it not working for me
can someone please help me?
teach me how to do like i…
CaptanJunior
- 1
- 1
- 5