var filterBy = function(functionType) {
    $.fn.dataTableExt.afnFiltering.length = 0;
    $.fn.dataTable.ext.search.push(
        function( settings, data, dataIndex ) {
            var type = data[1]; // use data for the Type column

            if ( type.toUpperCase() == functionType || functionType == 'All' )
            {
                return true;
            }
            return false;
        }
    );
}

$(document).ready(function() {
	var activeObject;
    var table = $('#routine_table').DataTable( {
        lengthChange: false,
		bSort: true,
		paging: config.pagination,
		pageLength: 50,
		autoWidth: true,
		bDeferRender: true,
		bProcessing: true,
		order: [[ 0, "asc" ]],
        buttons: [
            {
                text: 'All',
                action: function ( e, dt, node, config ) {
                    filterBy('All');
                    if (activeObject != null) {
                        activeObject.active(false);
                    }
                    table.draw();
                }
            },
            {
                text: 'Functions',
                action: function ( e, dt, node, config ) {
                    filterBy('FUNCTION');
                    if (activeObject != null) {
                        activeObject.active(false);
                    }
                    this.active( !this.active() );
                    activeObject = this;
                    table.draw();
                }
            },
            {
                text: 'Procedures',
                action: function ( e, dt, node, config ) {
                    filterBy('PROCEDURE');
                    if (activeObject != null) {
                        activeObject.active(false);
                    }
                    this.active( !this.active() );
                    activeObject = this;
                    table.draw();
                }
            },
            {
                extend: 'columnsToggle',
                columns: '.toggle'
            }
        ]
    } );

    //schemaSpy.js
    dataTableExportButtons(table);
} );
