Laravel Datatables adding column with specific html

Question

I have a problem with adding column into the jquery.datatables.

My datatable function looks like this

 public function getSliderImages()
{

    $query = Slider::with('User')->select('sliders.*');

    return Datatables::of($query)
        ->addColumn('fullName',function ($data){
            return $data->user->firstName .' '. $data->user->lastName;
        })
        ->addColumn('types',function ($data){
            return '<ul class="list-condensed list-unstyled no-margin">' .
                '<li><span class="text-semibold">Boyut:</span> '.$data->size.'</li>' .
                '<li><span class="text-semibold">Format:</span> ' .$data->ext.'</li></ul>';
        })

        ->make(true);
}

The returning json file is pretty good however here is the problem My datatable looks like this

And last thing is my javascript

columns: [
                {data: 'slider_slug', name: 'slider_slug',"render": function(data, type, row) {
                    return '<a href="'+loc+'/'+data+'" data-popup="lightbox"> <img src="'+loc+'/'+data+'" class="img-rounded img-preview" </a>';
                },

                    orderable: false,
                    searchable: false
                },
                {data: 'slider_slug', name: 'slider_slug'},
                {data: 'fullName', name: 'fullName'},
                {data: 'created_at', name: 'created_at'},
                {data: 'action',name:'action'},
                {data: 'types',name:'types'},

The returning value is acts like a plain text but its html.

In the javascript I couldnt get 2 data from server.I mean I cannot get 2 variables in 1 row.

How can I solve this problem

Rum Haidar Fauzan · Accepted Answer · 2020-04-15 01:07:55Z

6

Simple... just add ->rawColumns(['fullName', 'types'])

So... your code will be:

public function getSliderImages()
{

    $query = Slider::with('User')->select('sliders.*');

    return Datatables::of($query)
        ->addColumn('fullName',function ($data){
            return $data->user->firstName .' '. $data->user->lastName;
        })
        ->addColumn('types',function ($data){
            return '<ul class="list-condensed list-unstyled no-margin">' .
                '<li><span class="text-semibold">Boyut:</span> '.$data->size.'</li>' .
                '<li><span class="text-semibold">Format:</span> ' .$data->ext.'</li></ul>';
        })
        ->rawColumns(['fullName', 'types'])
        ->make(true);
}

See https://yajrabox.com/docs/laravel-datatables/master/raw-columns

answered Apr 15, 2020 at 1:07

Rum Haidar Fauzan

611 silver badge1 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

Smo · Accepted Answer · 2017-06-07 23:00:42Z

4

I think I have the solution to your problem, try this

 columns: [
              {data: 'slider_slug', name: 'slider_slug',
                            render:function (data, type, full, meta) {
                                console.log(full);
                                return '<a href="'+loc+'/'+data+'" data-popup="lightbox"> <img src="'+loc+'/'+data+'" class="img-rounded img-preview" </a>';
                            }
                    }

edited Jun 7, 2017 at 23:00

answered Jun 7, 2017 at 22:56

Smo

2113 silver badges8 bronze badges

5 Comments

Mehmetali Saraç Over a year ago

I cannot use this because I need two data here. Both $data->ext and $data->size

Smo Over a year ago

Why downvote? With full you can retrieve the values of all the other columns

Mehmetali Saraç Over a year ago

can you explain more ? btw I didnt downvoted I was searching

Mehmetali Saraç Over a year ago

Thank you very much

Smo Over a year ago

Oh, np :) bye !

Hasitha Priyasad Wijerathna · Accepted Answer · 2018-10-31 20:15:55Z

2

please use new rawColumns() method. you have to pass an array or columns that you need to be displayed as raw columns ( with HTML rendered)

example: (driver and action column will be rendered as raw - with HTML)

rawColumns(['driver','action'])

answered Oct 31, 2018 at 20:15

Hasitha Priyasad Wijerathna

2732 silver badges8 bronze badges

Collectives™ on Stack Overflow

Laravel Datatables adding column with specific html

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related