datatable: data with function, doesn't work sort

[jlopes90]

I use data: function(row) and it works but sorting doesn't work.

Example:

const columns = [];
columns.push({
    data: function(row) {
        return row.id;
    }
});
columns.push({
    data: function(row) {
        return row.name;
    }
});
columns.push({
    data: function(row) {
        const elString = jsoperation.modal(row.json);
        return elString;
    }
});

$(document).ready(function () {
    $('#example').dataTable({
        "serverSide": true,
        "ajax": "example",
        "columns": columns
    });
});

[jlopes90]

I made the changes more or less and it works fine.

---

datatables/src/QueryBuilder.php

Lines 88 to 99 in f5b5c32

	public function setColumnAttributes(): void
	{
	$columns = $this->options->columns();
	if ($columns) {
	foreach ($columns as $attr) {
	$index = $attr['data']['_'] ?? $attr['data'];
	if ($this->columns->visible()->isExists($index)) {
	$this->columns->visible()->get($index)->attr = $attr;
	}
	}
	}
	}

to

public function setColumnAttributes(): void
{
    $columns = $this->options->columns();
    if ($columns) {
        foreach ($columns as $key => $attr) {
            $index = $attr['data']['_'] ?? $attr['data'];

            if ($index === 'function') {
                $index = $key;
            }

            if ($this->columns->visible()->isExists($index)) {
                $this->columns->visible()->get($index)->attr = $attr;
            }
        }
    }
}

---

datatables/src/QueryBuilder.php

Lines 277 to 305 in f5b5c32

	protected function orderBy(): string
	{
	$orders = $this->options->order();
	$orders = array_filter($orders, function ($order) {
	return \in_array($order['dir'], ['asc', 'desc'],
	true) && $this->columns->visible()->offsetGet($order['column'])->isOrderable();
	});
	$o = [];
	foreach ($orders as $order) {
	$data = $this->options->columns()[$order['column']]['data'];
	$id = $data['sort'] ?? $data['_'] ?? $data;
	if ($this->columns->visible()->isExists($id)) {
	$o[] = $this->columns->visible()->get($id)->name.' '.$order['dir'];
	}
	}
	if (\count($o) === 0) {
	if ($this->hasDefaultOrder()) {
	return '';
	}
	$o[] = $this->defaultOrder();
	}
	return $this->db->makeOrderByString($o);
	}

to

protected function orderBy(): string
{
    ...

    foreach ($orders as $order) {
        $data = $this->options->columns()[$order['column']]['data'];
        $id = $data['sort'] ?? $data['_'] ?? $data;

        if ($id === 'function') {
            $id = $order['column'];
        }

        if ($this->columns->visible()->isExists($id)) {
            $o[] = $this->columns->visible()->get($id)->name.' '.$order['dir'];
        }
    }

    ...
}