DataTableAction.php bug

[irekbar]

Order by not work correctly.
Error line: $actionQuery->addOrderBy([$columns[$key]['data'] => $sort]);
After correction: $actionQuery->addOrderBy([$columns[$item['column']]['data'] => $sort]);

[ZAYEC77]

@irekbar, can you give an example of using a widget?

[irekbar]

Example of use:

1. In Controller add following lines:
    public function actions() {
        return [
            'datatables' => [
                'class' => 'nullref\datatable\DataTableAction',
// I use query instead of search model. To define query you can use any ActiveRecord Model eg.
                'query' => Employee::find(),
            ],
        ];
    }

1. In View file add:

<?= \nullref\datatable\DataTable::widget([
                            'serverSide' => true,
                            'ajax' => 'datatables',
// define additional parameters 
                            'tableOptions' => ['class' => 'table table-striped table-bordered', 'width' => '100%'],
                            'scrollX' => true,  
//list columns names which you want to show 
                           'columns' => [
                                'id',
                                'first_name',
                                'last_name',
                                'type',
                                'city',
                                'zip',
                                'street',
                                'email',
                                'phone',
                                //other columns
    ]) 
?>

[ZAYEC77]

@irekbar, thanks