Angular Store Data and Reload Datatable
Asked Answered
S

1

6

I'm using datatable: https://l-lin.github.io/angular-datatables and bootstrap: https://angular-ui.github.io/bootstrap/

this what i try to achive: after add data using modal from bootstrap and save it, the datatable is reload (without reload current route).

Here is my modalCtrl:

  .controller('addModalCtrl', ['$scope', '$modalInstance', '$http', 'AdminMenu', 'ResultService',
    function ($scope, $modalInstance, $http, AdminMenu, ResultService) {

    $scope.cancel = function () {
        $modalInstance.dismiss('cancel');
    };

    $scope.menu = {};

    $scope.doSubmit = function () {
        var data = {
            name: $scope.menu.title,
            icon: $scope.menu.icon
        };

        AdminMenu.save(data, function (response) {
            $scope.menu = {};
            ResultService(response);
            $modalInstance.dismiss('cancel');
        }, function (response) {
            ResultService(response.data);
        })
    };
}])

here is my datatable function:

 function AdminMenuTableData($compile, $scope, $modal, DTOptionsBuilder, DTColumnBuilder, SweetAlert, AdminMenu, ResultService, APIROOT) {

$scope.dtOptions = DTOptionsBuilder.fromSource(APIROOT + 'admin-menus')
    .withOption('order', [0, "asc"])
    .withOption('createdRow', function (row, data, dataIndex) {
        // Recompiling so we can bind Angular directive to the DT
        $compile(angular.element(row).contents())($scope);
    });

$scope.dtColumns = [
    DTColumnBuilder.newColumn('id', 'ID').withOption('searchable', false),
    DTColumnBuilder.newColumn('name', 'Name'),
    DTColumnBuilder.newColumn('', 'Actions').renderWith(function (data, type, full, meta) {
        return '<a class="btn btn-default btn-xs" ng-click=edit(' + full.id + ')><i class="fa fa-pencil"></i></a> ' +
            '<a class="btn btn-danger btn-xs" ng-click=delete(' + full.id + ')><i class="fa fa-trash"></i></a>';
    }).notSortable()
];

$scope.dtInstance = {};

function reloadData()
{
    $scope.dtInstance.reloadData();
}

}

How can i call reloadData() function so i can refresh the datatable. I've tried to inject AdminenuTableData function but no luck. injector failed.

Any suggestion?

Schifra answered 6/10, 2015 at 3:20 Comment(0)
T
13

Use rerender() instead. It both destroys the table and reinitialize it, including reloading AJAX sources :

$scope.reloadData = function() {
   $scope.dtInstance.rerender(); 
}

demo -> http://plnkr.co/edit/HbMDcMne3OiH2KYbJ8Iv?p=preview

Trounce answered 21/12, 2015 at 12:8 Comment(12)
Its not working I need same solution can you please update the codeDevitrify
given plunker is not working can you please update that code sample.Devitrify
@3rules, the plunkr is updated. The github repo was changed, thats why it didnt work.Trounce
how to do on staticc datatables?Froebel
@Sana, what do you mean exactly by "static datatable"? If you just need to redraw / refresh you can $scope.dtInstance.DataTable.draw()Trounce
I have a datatable with columns predefined.Froebel
embed.plnkr.co/o17Hwu6y1S795wIBMAt4 can you please see this plunker and tell how on changepersons my datatable reloads and show only three records. Even in paging area? thanks in advanceFroebel
Hey @Sana, you are using a 4 year old fork of angular datatables. Just use the latest (and probably final) angularjs version from github.com/l-lin/angular-datatables/tree/v0.6.2 forked plunkr here -> plnkr.co/edit/dt6dfmxTvhfOnPXSrlex?p=preview When using this and "the angular way" you should not have to worry about updating the sourceTrounce
i tried implementing it but im getting error 'TypeError: o.ngDestroy is not a function'Froebel
@sana, if you trace the error, what is the origin of where it is throwed? The 4 year old fork you were using had neither a dtInstance nor a ngDestroy. It was added to the project later on.Trounce
Whenever i am updating $scope.persons it is giving me this error.Froebel
#50631446 can you please have a look at this @TrounceFroebel

© 2022 - 2024 — McMap. All rights reserved.