<script type="text/javascript">
    $(document).ready(function () {
        $('#table_id').DataTable();
        $('#tabela_totais').DataTable();
    });

    $(function () {
        $('#datetimepicker1').datetimepicker({format: 'L'});
        $('#datetimepicker2').datetimepicker({format: 'L'});
    });

    $.fn.dataTableExt.afnFiltering.push(function (oSettings, aData, iDataIndex) {
        var filterstart = $('#min').val();
        var filterend = $('#max').val();
        var iStartDateCol = 1; //using column 1 in this instance
        var iEndDateCol = 1;

        var tabledatestart = aData[iStartDateCol];
        var tabledateend = aData[iEndDateCol];

        if (filterstart === "" && filterend === "") {
            return true
        } else if ((moment(filterstart).isSame(tabledatestart) || moment(filterstart).isBefore(tabledatestart)) && filterend === "") {
            return true
        } else if ((moment(filterstart).isSame(tabledatestart) || moment(filterstart).isAfter(tabledatestart)) && filterstart === "") {
            return true;
        } else if ((moment(filterstart).isSame(tabledatestart) || moment(filterstart).isBefore(tabledatestart)) && (moment(filterend).isSame(tabledateend) || moment(filterend).isAfter(tabledateend))) {
            return true;
        }
        return false;
    });

    $(document).ready(function () {
        var table = $('#table_id').DataTable();
        var table2 = $('#tabela_totais').DataTable();


        // Add event listeners to the two range filtering inputs
        $(document.getElementById('dateFilter')).click(
        function () {
            var filtered_payments = $("#table_id").dataTable()._('tr', {"filter": "applied"});
            var totals = [];

            for (i = 0, len = filtered_payments.length; i < len; i++) {
                var ticket_id = filtered_payments[i][4];

                if (ticket_id in totals){
                    totals[ticket_id].countertotal = totals[ticket_id].countertotal+1;
                }else{
                    totals[ticket_id] = {countertotal:1, ticket_name:filtered_payments[i][4]};
                }
            }

            table2.clear();

            for (total in totals) {
                var ticket_id1 = total;

                var total = totals[ticket_id1].countertotal;
                var name = totals[ticket_id1].ticket_name;
                table2.row.add([name, total]).draw();
            }
            table.draw();
        });
    });
</script>