DataTable destroy

mslavko · 27. 02. 2015.

Koristim DataTable plugin i imam tabelu example

Moram da je 'unistim' pa sam napisao:

Kôd:

$('#example').dataTable().fnDestroy();

ali dobijam gresku:

Citat:

Uncaught TypeError: Cannot read property 'style' of undefined
also this I get in console log:enter image description here

Sta bi mogli biti ovde problem? Da li ko koristi datatable plugin?

Pokusao sami sa veliko 'D':

Kôd:

$('#example').DataTable().fnDestroy();

ali onda dobijam:

Citat:

Uncaught TypeError: undefined is not a function

Takodje: http://i.imgur.com/MbK13vr.png

Br@nkoR · 27. 02. 2015.

https://datatables.net/reference/api/destroy()

mslavko · 27. 02. 2015.

Problem je sto na ostalim stranama ova funcija radi samo na jednoj ne, a ne znam razlog

Br@nkoR · 27. 02. 2015.

Postavi link do te stranice, kod ili postavi npr. na jsfiddle ili neki drugi servis.

mslavko · 27. 02. 2015.

Kôd:

var ajdi = 0;
var ajdipar = 0;
var akt ='';
$(document).ready(function() {
    drawVisualization();
 
    });
function drawVisualization() {
     
               $('#example').DataTable({
                             "ajax": {
            "url": 'getFin.php',
            "type": 'POST',
            "dataSrc": function (json) {
                if(!json.data){
               
            $('#myModal').modal('show');
            //$('.analize').hide();
            json.data = [];
        }
                return json.data;
            }
        },
                    paging: false,
                    //"dom":' <"search"f><"top"l>rt<"bottom"ip><"clear">',
                    "oLanguage": {
    "sInfo": 'Ukupno _END_ transakcija.',
    "sInfoEmpty": 'Nema zabelezenih transakcija',
    "sEmptyTable": "Nema transakcija, dodajte klikom na dugme 'Dodaj kupoprodaju'.",
},
                    "columns": [{
                            "data": "ID"
                        }, {
                            "data": "datum"
                        }, 
                        {
                            "data": "datum_dospeca"
                        },{
                            "data": "aktivnost"
                        },
                        
                        {
                            "data": "vrsta"
                        },
                        {
                            "data": "artikl"
                        },
                        
                        {
                            "data": "6"
                        },
                         {
                            "data": "7"
                        },{
                            "data": "8"
                        },
                         {
                            "data": "dobavljac"
                        },
                        {
                            "data": "nacin_placanja"
                        },
                        {
                            "data": "skladiste"
                        },
                        {
                            "data": "akcija"
                        },
                         {
                            "data": "jmere"
                        },
                        {
                            "data": "porez"
                        },
                         {
                            "data": "opis"
                        }
                    ],
                     "fnFooterCallback": function (nRow, aasData, iStart, iEnd, aiDisplay) {

        var columnas = [6, 7, 8]; //the columns you wish to add            
        for (var j in columnas) {
            var columnaActual = columnas[j];
            var total = 0;
            for (var i = iStart; i < iEnd; i++) {
                total = total + parseFloat(aasData[aiDisplay[i]][columnaActual]);
            }
            $($(nRow).children().get(columnaActual-1)).html(total);

        }
    }, 
                    "columnDefs": [
                            {
                        "targets": [0,13,14,15],
                        "visible":false
                            },
                         {
                        "targets": 12,
                        "data": "akcija",
                        "render": function(data, type, full, meta) {
                            // return data; 
                            return '<div style="float:right;"><button class="btn btn-info troskovnik" data-toggle="modal" data-target="#update">Detalji...</button> <i  data-toggle="modal" data-target="#delete" class="fa fa-times"></i></div>';
                        }
                            },
                              { 
                        "targets": 3,
                        "data": "aktivnost",
                        "render": function(data, type, full, meta) {
                            if (data=='prodaja') {
                            return '<button class="btn btn-success">'+data+'</button>';
                            } else if (data=='kupovina'){
                                                        return '<button class="btn btn-danger" >'+data+'</button>';

                            } else {
                                                        return '<button class="btn btn-info" >'+data+'</button>';

                            }
                            
                            }
                              }
                           
                
    ]
                });
            
            var dataTable = $('#example').dataTable();
    $("#searchbox").keyup(function() {
        dataTable.fnFilter(this.value);
    }); 
    
            };


 $(document).ready(function(){
 var oTable =  $('#example'). dataTable();
 
$('#example').on('click', 'tr', function(){
    var oData = oTable.fnGetData(this);
    console.log(oData.ID);
    ajdi = oData.ID;
    $('#naziv1').val(oData.naziv);
    $('#ha1').val(oData.ha);
    $('#ar1').val(oData.ar);
    $('#m21').val(oData.m2);
    $('#kultura1').val(oData.kat_kul);
    $('#osnov1').val(oData.osnov);
    $('#lokacija1').val(oData.lokacija);
    $('#opis1').val(oData.opis);
    $('#select2-kulb1-container').text(oData.planirana_kul);
});
$("#brisi").click(function() {

        $.ajax({
            url: "delete.php",
            type: "POST",
            async: true, 
            data: { vrednostid:ajdi}, //your form data to post goes here as a json object
            dataType: "html",

            success: function(data) {
              $('#delete').modal('hide');
                $('#example').dataTable().fnDestroy();
		drawVisualization();   
            },
             error: function(data) {
         console.log(data);
             }
        });
   
});
$('#myModal1').on('shown.bs.modal', function (e) {
  
    drawInputi();
    
});


    });

a HTML je:

Kôd:

<table id="example" class="table table-striped table-bordered table-responsitive" cellspacing="0" width="100%">
        <thead>
            <tr>
                <th>ID</th>
                <th>Datum</th>
                <th>Dospece</th>
                <th><i class="fa fa-random"></i></th>
                <th>Vrsta</th>
                <th>Artikl</th>
                <th>Kolicina</th>
                <th>Iznos</th>
                <th>Placeno</th>
                <th>Kome/Od koga</th>
                <th>Placanje</th>
                <th>Skladiste</th>
                <th></th>
            </tr>
        </thead>
 
        <tfoot>
            <tr>
               <th>ID</th>
                <th>Datum</th>
                <th>Dospece</th>
                <th><i class="fa fa-random"></i></th>
                <th>Vrsta</th>
                <th>Artikl</th>
                <th>Kolicina</th>
                <th>Iznos</th>
                <th>Placeno</th>
                <th>Kome/Od koga</th>
                <th>Placanje</th>
                <th>Skladiste</th>
                <th></th>
            </tr>
        </tfoot>
    </table>

mslavko · 27. 02. 2015.

Takodje getFin.php generise JSON podatke:

Citat:

{"data":[{"ID":1,"aktivnost":"prodaja","vrsta":"Kultura","a rtikl":"psenica","6":"222 Kg","7":290,"dobavljac":"M. Milic","datum":"2014-04-24","datum_dospeca":"2015-02-03","8":288,"nacin_placanja":"gotovinsko","skladis te":"Novo skladiste","jmere":"Kg","porez":20,"opis":"Prodaja robe bla bla bla"},{"ID":14,"aktivnost":"Odaberi","vrsta":"","a rtikl":"","6":"0 kom","7":0,"dobavljac":"","datum":"2015-03-06","datum_dospeca":"0000-00-00","8":0,"nacin_placanja":"gotovinsko","skladiste ":"","jmere":"kom","porez":0,"opis":"Napomene o traksakciji"},{"ID":13,"aktivnost":"Odaberi","vrst a":"","artikl":"","6":"9 kom","7":9,"dobavljac":"","datum":"2015-03-06","datum_dospeca":"0000-00-00","8":9,"nacin_placanja":"gotovinsko","skladiste ":"","jmere":"kom","porez":0,"opis":"Napomene o traksakciji"},{"ID":12,"aktivnost":"Odaberi","vrst a":"","artikl":"","6":"55 kom","7":55,"dobavljac":"","datum":"2015-03-07","datum_dospeca":"0000-00-00","8":55,"nacin_placanja":"gotovinsko","skladist e":"","jmere":"kom","porez":0,"opis":"Napomene o traksakciji"},{"ID":11,"aktivnost":"Odaberi","vrst a":"","artikl":"","6":"7 kom","7":7,"dobavljac":"","datum":"2015-03-07","datum_dospeca":"0000-00-00","8":7,"nacin_placanja":"gotovinsko","skladiste ":"","jmere":"kom","porez":0,"opis":"Napomene o traksakciji"}]}

i sa njima je sve uredu

Br@nkoR · 27. 02. 2015.

U columns imaš definisano 16 kolona, a u html kodu umaš 13, dodaj još 3 polja koja nedostaju.

Ili pogledaj npr.
http://stackoverflow.com/a/26483798

mslavko · 28. 02. 2015.

Hvala PUNo! Nemogu da verujem kakvu sam gresku prevideo!

27. 02. 2015.	#2
Br@nkoR banned Professional Datum učlanjenja: 04.06.2005 Poruke: 371 Hvala: 0 738 "Hvala" u 83 poruka	https://datatables.net/reference/api/destroy() __________________ Don't look at me; I'm lost too. “If you can't dazzle them with brilliance, baffle them with buls*t.”

27. 02. 2015.	#4
Br@nkoR banned Professional Datum učlanjenja: 04.06.2005 Poruke: 371 Hvala: 0 738 "Hvala" u 83 poruka	Postavi link do te stranice, kod ili postavi npr. na jsfiddle ili neki drugi servis. __________________ Don't look at me; I'm lost too. “If you can't dazzle them with brilliance, baffle them with buls*t.”

27. 02. 2015.	#7
Br@nkoR banned Professional Datum učlanjenja: 04.06.2005 Poruke: 371 Hvala: 0 738 "Hvala" u 83 poruka	U columns imaš definisano 16 kolona, a u html kodu umaš 13, dodaj još 3 polja koja nedostaju. Ili pogledaj npr. http://stackoverflow.com/a/26483798 __________________ Don't look at me; I'm lost too. “If you can't dazzle them with brilliance, baffle them with buls*t.”

27. 02. 2015.	#3
mslavko profesionalac Professional Datum učlanjenja: 25.10.2012 Poruke: 278 Hvala: 16 32 "Hvala" u 9 poruka	Problem je sto na ostalim stranama ova funcija radi samo na jednoj ne, a ne znam razlog

28. 02. 2015.	#8
mslavko profesionalac Professional Datum učlanjenja: 25.10.2012 Poruke: 278 Hvala: 16 32 "Hvala" u 9 poruka	Hvala PUNo! Nemogu da verujem kakvu sam gresku prevideo!