Using views for columns in Datatables

I found one way to do this, I put (string) before the view method, now it looks like this:

my controller:

public function data()
    {
        return Datatables::of(Page::select('*'))
        ->addColumn('options', function ($page) {
                return (string) view('options', ['id' => $page->id]);
            })
        ->make(true);
    }

my view:

<script>
$(function() {
    $('table').DataTable({
        processing: true,
        serverSide: true,
        ajax: '{!! route('offers.data') !!}',
        columns: [
        { data: 'id', name: 'id' },
        { data: 'title', name: 'title' },
        { data: 'options', name: 'options', sortable: false, className: 'text-right' }
        ]
    });
});
</script>

Thanks @tntstudio, my controller code is a mess at the moment, this'll clean it right up.

View add this in javascript:

  {data: 'action', name: 'action', orderable: false, searchable: false}

Example of how i added edit/delete/view to one of my projects

public function anyData()
{
    //return Datatables::of(sales::select('*'))->make(true);

$sales = DB::table('sales')
            ->select(['id', 'name','source','phone','salesrep','contactname','status','notes','busname','secondname', 'callback']);


        return Datatables::of($sales)
            ->addColumn('action', function ($sales) {
                return '<a href="sale/'.$sales->id.'/edit" class="btn btn-xs btn-primary"><i class="glyphicon glyphicon-edit"></i> Edit</a>
                <a href="sale/'.$sales->id.'" class="btn btn-xs btn-primary"><i class="glyphicon glyphicon-zoom-in"></i> View</a>

 <button class="btn btn-delete" data-remote="sale/' . $sales->id . '">Delete</button>
                ';
            })
            ->addColumn('phone', function ($sales) {
                return '<a href="tel:'.$sales->phone.'">'.$sales->phone.'</a>';
            })
            //->editColumn('id', 'ID: {{$id}}')
            ->make(true);
}

add column

        return Datatables::of($sales)
            ->addColumn('action', function ($sales) {
                return '<a href="sale/'.$sales->id.'/edit" class="btn btn-xs btn-primary"><i class="glyphicon glyphicon-edit"></i> Edit</a>
                <a href="sale/'.$sales->id.'" class="btn btn-xs btn-primary"><i class="glyphicon glyphicon-zoom-in"></i> View</a>

 <button class="btn btn-delete" data-remote="sale/' . $sales->id . '">Delete</button>
                ';
            })

Example of my delete java in the view

$('#sales-table').on('click', '.btn-delete[data-remote]', function (e) { 
    e.preventDefault();
     $.ajaxSetup({
        headers: {
            'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
        }
    });
     
    var url = $(this).data('remote');
    // confirm then
    $.ajax({
        url: url,
        type: 'DELETE',
        dataType: 'json',
        data: {method: '_DELETE', submit: true}
    }).always(function (data) {
        $('#sales-table').DataTable().draw(false);
    });
});

Any questions i will try to answer later

A bit late. Not sure which version you are using, but in the latest you can do:

->addColumn('actions',  'path.to.your.partial.view')

Just to follow up on the answer from @Voyowsky, this answer works very well and it pretty neat. It is not documented very well (like much of the Laravel DataTables package) but this will call up the view. It includes package-based views, such as 'MyPackage::view.path.in.package'.

The parameters passed to the view will be the columns selected in the query, so an App\User query would include {{ $id }} and {{ $name }} variables, for example.

hi, would like to share my piece of code

in controller

$student = Student::select('id', 'name', 'email', 'age');
        return Datatables::eloquent($student)
            ->addColumn('action', function($student) {
                return view('student.action_student', compact('student'));
            })
            ->make(true);

in student.action_student.blade.php (not complete yet)

<a href="#edit" class="btn btn-xs btn-info"><i class="glyphicon glyphicon-edit"></i> view</a> 
<a href="#edit" class="btn btn-xs btn-primary"><i class="glyphicon glyphicon-edit"></i> Edit</a> 
<a href="#edit" class="btn btn-xs btn-danger"><i class="glyphicon glyphicon-edit"></i> delete</a>

@delang the forum uses markdown syntax. See the link under the reply box on how to use it. For code, it's 3 backticks (`) on it's own line, followed by code, followed by 3 more backticks on it's own line (with nothing else)

```

code

```

@Cronix thanks for pointing this out.